<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: wushuang
$Date: 2011-11-24 下午1:55:05
$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="execute">
<bm:update-sql><![CDATA[
DECLARE
v_job_type NUMBER;
BEGIN
--将前台执行的JOB类型转换为后台需要的格式
IF ${/parameter/@type} = 'RUN' THEN
v_job_type := fnd_request_pkg.g_job_type_is_run;
ELSIF ${/parameter/@type} = 'DELETE' THEN
v_job_type := fnd_request_pkg.g_job_type_is_delete;
ELSIF ${/parameter/@type} = 'SLEEP' THEN
v_job_type := fnd_request_pkg.g_job_type_is_sleep;
ELSIF ${/parameter/@type} = 'WAKE' THEN
v_job_type := fnd_request_pkg.g_job_type_is_wake;
END IF;
fnd_request_pkg.job_handle(p_request_id => ${@request_id},
p_user_id => ${/session/@user_id},
p_job_type => v_job_type);
END;
]]></bm:update-sql>
</bm:operation>
</bm:operations>
</bm:model>
-
Spencer Chang authoredbfd31bca