APPS.ZPB_DC_WF dependencies on ZPB_TASK_PARAMETERS

Line 81: FROM zpb_task_parameters

77:
78: -- Set attributes
79: SELECT value
80: INTO l_template_name
81: FROM zpb_task_parameters
82: WHERE task_id = l_task_id
83: AND name = 'TEMPLATE_NAME';
84:
85: wf_engine.SetItemAttrText(

Line 93: FROM zpb_task_parameters

89: avalue => l_template_name);
90:
91: SELECT value
92: INTO l_wait_for_review
93: FROM zpb_task_parameters
94: WHERE task_id = l_task_id
95: AND name = 'TEMPLATE_WAIT_FOR_REVIEW';
96:
97: wf_engine.SetItemAttrText(

Line 131: l_notify zpb_task_parameters.value%TYPE;

127: resultout OUT nocopy varchar2
128: )
129: IS
130: l_wait_for_review varchar2(1);
131: l_notify zpb_task_parameters.value%TYPE;
132: l_task_id number;
133: l_from_name fnd_user.user_name%TYPE;
134: l_user_id number;
135: l_template_name zpb_dc_objects.template_name%TYPE;

Line 167: FROM zpb_task_parameters

163: avalue => l_from_name);
164:
165: SELECT value
166: INTO l_notify
167: FROM zpb_task_parameters
168: WHERE task_id = l_task_id
169: AND name = 'NOTIFICATION_RECIPIENT_TYPE';
170:
171: IF (l_wait_for_review = 'Y') THEN

Line 296: l_distribute_message zpb_task_parameters.value%TYPE;

292: l_req_id number := 0;
293: l_object_id number;
294: l_object_user_id number;
295: l_object_user_name fnd_user.description%TYPE;
296: l_distribute_message zpb_task_parameters.value%TYPE;
297: l_template_name zpb_dc_objects.template_name%TYPE;
298: l_prior_item_key zpb_analysis_cycle_tasks.item_key%TYPE;
299: l_issue_msg fnd_new_messages.message_text%TYPE;
300:

Line 335: FROM zpb_task_parameters

331: /* To find out the specific distributed template
332: for multiple template cases */
333: SELECT value
334: INTO l_ac_template_id
335: FROM zpb_task_parameters
336: WHERE task_id = l_task_id
337: AND name = 'DISTRIBUTION_TEMPLATE_ID';
338:
339: SELECT template_id, template_name

Line 389: FROM zpb_task_parameters

385:
386: -- Get the distribute message to populate dc distribution message
387: SELECT value
388: INTO l_distribute_message
389: FROM zpb_task_parameters
390: WHERE task_id = l_task_id
391: AND name = 'DISTRIBUTION_MESSAGE';
392:
393: wf_engine.SetItemAttrText(

Line 512: FROM zpb_task_parameters

508: IF (l_instance_id is not null and
509: l_task_id is not null) then -- AUTO--
510: SELECT value
511: INTO l_ac_template_id
512: FROM zpb_task_parameters
513: WHERE task_id = l_task_id
514: AND name = 'DISTRIBUTION_TEMPLATE_ID';
515:
516: SELECT object_user_id

Line 998: FROM zpb_task_parameters param,

994: aname => 'TASKID');
995:
996: FOR template_id_rec IN (
997: SELECT obj.template_id
998: FROM zpb_task_parameters param,
999: zpb_dc_objects obj
1000: WHERE param.task_id = l_task_id
1001: AND param.name = 'SUBMISSION_TEMPLATE_ID'
1002: AND to_number(param.value) = obj.ac_template_id

Line 1033: FROM zpb_task_parameters

1029: /* To find out any (of the many) template(s)
1030: for multiple template cases */
1031: SELECT min(value)
1032: INTO l_ac_template_id
1033: FROM zpb_task_parameters
1034: WHERE task_id = l_task_id
1035: AND name = 'SUBMISSION_TEMPLATE_ID';
1036:
1037: SELECT object_user_id

Line 1338: FROM zpb_task_parameters param,

1334: aname => 'INSTANCEID');
1335:
1336: SELECT count(*)
1337: INTO l_count
1338: FROM zpb_task_parameters param,
1339: zpb_dc_objects obj
1340: WHERE param.task_id = l_task_id
1341: AND param.name = 'SUBMISSION_TEMPLATE_ID'
1342: AND to_number(param.value) = obj.ac_template_id

Line 2935: FROM zpb_dc_objects obj,zpb_analysis_cycle_tasks task,zpb_task_parameters param

2931: -- Find the item key manage submission task that is managing the submissions
2932: -- of this template
2933: SELECT task.item_key
2934: INTO l_item_key
2935: FROM zpb_dc_objects obj,zpb_analysis_cycle_tasks task,zpb_task_parameters param
2936: WHERE obj.object_id = l_object_id
2937: AND task.analysis_cycle_id = obj.ac_instance_id
2938: AND task.task_id = param.task_id
2939: AND param.name = 'SUBMISSION_TEMPLATE_ID'