<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: DJ  
    $Date: 2013-3-21 上午11:36:47  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
            SELECT t1.parameter_id,
			       t1.seq,
			       t1.parameter_name,
			       t1.parameter_type,
			       decode(t1.parameter_type,
			              'DATE',
			              sch_task_pkg.get_para_default_date(j.parameter_value),
			              j.parameter_value) as parameter_value,
			       (case
			         when j.parameter_value is null then
			          'N'
			         else
			          'Y'
			       end) as lov_has_default_value,
			       (case
			         when t1.edit_type = 'LOV' and t1.parameter_type = 'VARCHAR2' and
			              j.parameter_value is not null and
			              j.parameter_value not like
			              chr(36) || chr(123) || chr(47) || '%' then
			          chr(39) || j.parameter_value || chr(39)
			         else
			          j.parameter_value
			       end) as default_value_format,
			       t1.task_code,
			       t1.description,
			       t1.edit_type,
			       t1.display_flag,
			       t1.display_type,
			       t1.lov_sql
			  FROM SCH_TASK_PARAMETER t1, sch_job_parameter j
			 where j.parameter_id = t1.parameter_id
			   and j.job_id = ${@job_id}
			 ORDER BY t1.seq
            ]]></bm:query-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
                begin
				    sch_concurrent_job_pkg.update_job_parameter(p_job_id				=> ${@job_id},
				    											p_user_id 				=> ${/session/@user_id},
				   												p_parameter_1 			=> ${@parameter_1},
							                                    p_parameter_2 			=> ${@parameter_2},
							                                    p_parameter_3 			=> ${@parameter_3},
							                                    p_parameter_4 			=> ${@parameter_4},
							                                    p_parameter_5 			=> ${@parameter_5},
							                                    p_parameter_6 			=> ${@parameter_6},
							                                    p_parameter_7 			=> ${@parameter_7},
							                                    p_parameter_8 			=> ${@parameter_8},
							                                    p_parameter_9 			=> ${@parameter_9},
							                                    p_parameter_10 			=> ${@parameter_10},
							                                    p_parameter_11       	=> ${@parameter_11},
		                                                    	p_parameter_12       	=> ${@parameter_12},
			                                                    p_parameter_13       	=> ${@parameter_13},
			                                                    p_parameter_14       	=> ${@parameter_14},
			                                                    p_parameter_15       	=> ${@parameter_15},
			                                                    p_parameter_16       	=> ${@parameter_16},
			                                                    p_parameter_17       	=> ${@parameter_17},
			                                                    p_parameter_18       	=> ${@parameter_18},
			                                                    p_parameter_19       	=> ${@parameter_19},
			                                                    p_parameter_20       	=> ${@parameter_20});
				end;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
