eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_WORKFLOW_PKG dependencies on WF_ENGINE

Line 126: WF_ENGINE.CreateProcess( itemtype => itemtype,

122:
123: log_message('Calling workflow engine to create the process',3);
124: -- Create a new Wf process
125: --b6694902_debug.debug('Before calling createprocess ');
126: WF_ENGINE.CreateProcess( itemtype => itemtype,
127: itemkey => itemkey,
128: process => l_process);
129:
130:

Line 172: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

168: 'Change Document Id ['||p_ci_id||']'
169: ,3);
170:
171: IF l_proj_info_rec.project_id IS NOT NULL THEN
172: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
173: ,itemkey => itemkey
174: ,aname => 'PROJECT_ID'
175: ,avalue => l_proj_info_rec.project_id
176: );

Line 180: WF_ENGINE.SetItemAttrText (itemtype => itemtype

176: );
177: END IF;
178:
179: IF l_proj_info_rec.project_number IS NOT NULL THEN
180: WF_ENGINE.SetItemAttrText (itemtype => itemtype
181: ,itemkey => itemkey
182: ,aname => 'PROJECT_NUMBER'
183: ,avalue => l_proj_info_rec.project_number
184: );

Line 188: WF_ENGINE.SetItemAttrText (itemtype => itemtype

184: );
185: END IF;
186:
187: IF c_ci_info_rec.ci_number IS NOT NULL THEN
188: WF_ENGINE.SetItemAttrText (itemtype => itemtype
189: ,itemkey => itemkey
190: ,aname => 'CONTROL_ITEM_NUMBER'
191: ,avalue => c_ci_info_rec.ci_number
192: );

Line 196: WF_ENGINE.SetItemAttrText (itemtype => itemtype

192: );
193: END IF;
194:
195: IF l_proj_info_rec.project_name IS NOT NULL THEN
196: WF_ENGINE.SetItemAttrText (itemtype => itemtype
197: ,itemkey => itemkey
198: ,aname => 'PROJECT_NAME'
199: ,avalue => l_proj_info_rec.project_name
200: );

Line 204: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

200: );
201: END IF;
202:
203: IF l_proj_info_rec.organization_id IS NOT NULL THEN
204: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
205: ,itemkey => itemkey
206: ,aname => 'PROJ_ORG_ID'
207: ,avalue => l_proj_info_rec.organization_id
208: );

Line 221: WF_ENGINE.SetItemAttrText (itemtype => itemtype

217: 'Task End Date ['||c_task_info_rec.scheduled_end_date||']'
218: ,3);
219:
220: IF c_task_info_rec.parent_task_number IS NOT NULL THEN
221: WF_ENGINE.SetItemAttrText (itemtype => itemtype
222: ,itemkey => itemkey
223: ,aname => 'PARENT_TASK_NUMBER'
224: ,avalue => c_task_info_rec.parent_task_number
225: );

Line 229: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

225: );
226: END IF;
227:
228: IF c_task_info_rec.parent_task_id IS NOT NULL THEN
229: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
230: ,itemkey => itemkey
231: ,aname => 'PARENT_TASK_ID'
232: ,avalue => c_task_info_rec.parent_task_id
233: );

Line 237: WF_ENGINE.SetItemAttrText (itemtype => itemtype

233: );
234: END IF;
235:
236: IF c_task_info_rec.task_number IS NOT NULL THEN
237: WF_ENGINE.SetItemAttrText (itemtype => itemtype
238: ,itemkey => itemkey
239: ,aname => 'TASK_NUMBER'
240: ,avalue => c_task_info_rec.task_number
241: );

Line 245: WF_ENGINE.SetItemAttrText (itemtype => itemtype

241: );
242: END IF;
243:
244: IF c_task_info_rec.task_name IS NOT NULL THEN
245: WF_ENGINE.SetItemAttrText (itemtype => itemtype
246: ,itemkey => itemkey
247: ,aname => 'TASK_NAME'
248: ,avalue => c_task_info_rec.task_number
249: );

Line 253: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

249: );
250: END IF;
251:
252: IF c_task_info_rec.task_id IS NOT NULL THEN
253: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
254: ,itemkey => itemkey
255: ,aname => 'TASK_ID'
256: ,avalue => c_task_info_rec.task_id
257: );

Line 261: WF_ENGINE.SetItemAttrDate (itemtype => itemtype

257: );
258: END IF;
259:
260: IF c_task_info_rec.scheduled_start_date IS NOT NULL THEN
261: WF_ENGINE.SetItemAttrDate (itemtype => itemtype
262: ,itemkey => itemkey
263: ,aname => 'TASK_ST_DATE'
264: ,avalue => c_task_info_rec.scheduled_start_date
265: );

Line 269: WF_ENGINE.SetItemAttrDate (itemtype => itemtype

265: );
266: END IF;
267:
268: IF c_task_info_rec.scheduled_end_date IS NOT NULL THEN
269: WF_ENGINE.SetItemAttrDate (itemtype => itemtype
270: ,itemkey => itemkey
271: ,aname => 'TASK_END_DATE'
272: ,avalue => c_task_info_rec.scheduled_end_date
273: );

Line 277: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

273: );
274: END IF;
275:
276: IF p_ci_id IS NOT NULL THEN
277: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
278: ,itemkey => itemkey
279: ,aname => 'CI_ID'
280: ,avalue => p_ci_id
281: );

Line 289: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

285: 'Workflow started by ['||l_user_full_name||']'
286: ,3);
287:
288: IF l_content_id IS NOT NULL THEN
289: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
290: ,itemkey => itemkey
291: ,aname => 'CONTENT_ID'
292: ,avalue => l_content_id
293: );

Line 297: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

293: );
294: END IF;
295:
296: IF l_workflow_started_by_id IS NOT NULL THEN
297: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
298: ,itemkey => itemkey
299: ,aname => 'SUBMITTED_BY_ID'
300: ,avalue => l_workflow_started_by_id
301: );

Line 305: WF_ENGINE.SetItemAttrText (itemtype => itemtype

301: );
302: END IF;
303:
304: IF l_user_full_name IS NOT NULL THEN
305: WF_ENGINE.SetItemAttrText (itemtype => itemtype
306: ,itemkey => itemkey
307: ,aname => 'SUBMITTED_BY'
308: ,avalue => l_user_full_name
309: );

Line 313: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

309: );
310: END IF;
311:
312: IF l_workflow_started_by_id IS NOT NULL THEN
313: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
314: ,itemkey => itemkey
315: ,aname => 'WORKFLOW_STARTED_BY_ID'
316: ,avalue => l_workflow_started_by_id
317: );

Line 321: WF_ENGINE.SetItemAttrText (itemtype => itemtype

317: );
318: END IF;
319:
320: IF l_user_name IS NOT NULL THEN
321: WF_ENGINE.SetItemAttrText (itemtype => itemtype
322: ,itemkey => itemkey
323: ,aname => 'WORKFLOW_STARTED_BY_NAME'
324: ,avalue => l_user_name
325: );

Line 329: WF_ENGINE.SetItemAttrText (itemtype => itemtype

325: );
326: END IF;
327:
328: IF l_user_full_name IS NOT NULL THEN
329: WF_ENGINE.SetItemAttrText (itemtype => itemtype
330: ,itemkey => itemkey
331: ,aname => 'WORKFLOW_STARTED_BY_FULL_NAME'
332: ,avalue => l_user_full_name
333: );

Line 337: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

333: );
334: END IF;
335:
336: IF l_resp_id IS NOT NULL THEN
337: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
338: ,itemkey => itemkey
339: ,aname => 'RESPONSIBILITY_ID'
340: ,avalue => l_resp_id
341: );

Line 345: WF_ENGINE.SetItemAttrText (itemtype => itemtype

341: );
342: END IF;
343:
344: IF l_wf_started_date IS NOT NULL THEN
345: WF_ENGINE.SetItemAttrText (itemtype => itemtype
346: ,itemkey => itemkey
347: ,aname => 'WF_STARTED_DATE'
348: ,avalue => l_wf_started_date
349: );

Line 353: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

349: );
350: END IF;
351:
352: IF p_approver_user_id IS NOT NULL THEN
353: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
354: ,itemkey => itemkey
355: ,aname => 'TASK_APPROVER_ID'
356: ,avalue => p_approver_user_id
357: );

Line 373: WF_ENGINE.SetItemAttrText (itemtype => itemtype

369: 'Task approver ['||l_user_full_name||']'
370: ,3);
371:
372: IF l_user_full_name IS NOT NULL THEN
373: WF_ENGINE.SetItemAttrText (itemtype => itemtype
374: ,itemkey => itemkey
375: ,aname => 'TASK_APPROVER_NAME'
376: ,avalue => l_user_full_name
377: );

Line 390: WF_ENGINE.SetItemAttrText (itemtype => itemtype

386: END IF;
387: CLOSE c_starter_full_name;
388:
389: IF l_user_full_name IS NOT NULL THEN
390: WF_ENGINE.SetItemAttrText (itemtype => itemtype
391: ,itemkey => itemkey
392: ,aname => 'TASK_APPROVER_FULLNAME'
393: ,avalue => l_user_full_name
394: );

Line 398: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

394: );
395: END IF;
396:
397: IF p_parent_struc_ver IS NOT NULL THEN
398: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
399: ,itemkey => itemkey
400: ,aname => 'PARENT_STRUC_VER_ID'
401: ,avalue => p_parent_struc_ver
402: );

Line 405: WF_ENGINE.StartProcess (itemtype => itemtype

401: ,avalue => p_parent_struc_ver
402: );
403: END IF;
404:
405: WF_ENGINE.StartProcess (itemtype => itemtype
406: ,itemkey => itemkey
407: );
408:
409: IF x_err_code = 0 THEN

Line 437: --wf_engine.threshold := l_save_threshold;

433: WF_CORE.CONTEXT('PA_TASK_APPROVAL_WF','Start_Task_Aprv_Wf');
434: RAISE;
435: WHEN OTHERS THEN
436: --b6694902_debug.debug('In Others Exception ');
437: --wf_engine.threshold := l_save_threshold;
438: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: FND_MSG_PUB.Add_Exc_Msg
440: ( p_pkg_name => 'PA_TASK_APPROVAL_PKG'
441: , p_procedure_name => 'Start_Task_Aprv_Wf'

Line 934: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

930: BEGIN
931:
932: log_message('Inside Is_Child_Task',3);
933:
934: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
935: ,itemkey => itemkey
936: ,aname => 'PROJECT_ID');
937: l_proj_element := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
938: ,itemkey => itemkey

Line 937: l_proj_element := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

933:
934: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
935: ,itemkey => itemkey
936: ,aname => 'PROJECT_ID');
937: l_proj_element := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
938: ,itemkey => itemkey
939: ,aname => 'TASK_ID');
940: l_parent_struc_ver := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
941: ,itemkey => itemkey

Line 940: l_parent_struc_ver := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

936: ,aname => 'PROJECT_ID');
937: l_proj_element := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
938: ,itemkey => itemkey
939: ,aname => 'TASK_ID');
940: l_parent_struc_ver := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
941: ,itemkey => itemkey
942: ,aname => 'PARENT_STRUC_VER_ID');
943: l_proj_org := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
944: ,itemkey => itemkey

Line 943: l_proj_org := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

939: ,aname => 'TASK_ID');
940: l_parent_struc_ver := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
941: ,itemkey => itemkey
942: ,aname => 'PARENT_STRUC_VER_ID');
943: l_proj_org := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
944: ,itemkey => itemkey
945: ,aname => 'PROJ_ORG_ID');
946: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
947: ,itemkey => itemkey

Line 946: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

942: ,aname => 'PARENT_STRUC_VER_ID');
943: l_proj_org := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
944: ,itemkey => itemkey
945: ,aname => 'PROJ_ORG_ID');
946: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
947: ,itemkey => itemkey
948: ,aname => 'CI_ID');
949:
950: log_message('Before calling PA_TASK_APPROVAL_PKG.Is_Child_Task',3);

Line 960: resultout := wf_engine.eng_completed||':'||'T';

956: ,l_msg_count
957: ,l_msg_data
958: ,l_return_status ) THEN
959: log_message('Task '||l_proj_element||' is a child task',3);
960: resultout := wf_engine.eng_completed||':'||'T';
961: ELSE
962: log_message('Generating notification for task approval',3);
963: Generate_Task_Aprv_Notify(p_item_type => itemtype
964: ,p_item_key => itemkey

Line 974: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

970: ,x_content_id => l_content_id
971: );
972:
973: IF l_content_id IS NOT NULL THEN
974: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
975: ,itemkey => itemkey
976: ,aname => 'CONTENT_ID'
977: ,avalue => l_content_id
978: );

Line 985: resultout := wf_engine.eng_completed||':'||'F';

981: UPDATE PA_PROJ_ELEMENTS
982: SET task_status = 'SUBMITTED'
983: WHERE proj_element_id = l_proj_element;
984:
985: resultout := wf_engine.eng_completed||':'||'F';
986: log_message('Task '||l_proj_element||' is a top/root task',3);
987: END IF;
988: EXCEPTION
989: WHEN FND_API.G_EXC_ERROR THEN

Line 1023: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1019: l_ci_id NUMBER;
1020: BEGIN
1021: log_message('Inside the procedure Is_Parent_Task_Approved',3);
1022:
1023: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1024: ,itemkey => itemkey
1025: ,aname => 'PROJECT_ID');
1026:
1027: l_proj_element := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

Line 1027: l_proj_element := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1023: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1024: ,itemkey => itemkey
1025: ,aname => 'PROJECT_ID');
1026:
1027: l_proj_element := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1028: ,itemkey => itemkey
1029: ,aname => 'TASK_ID');
1030:
1031: l_parent_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

Line 1031: l_parent_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1027: l_proj_element := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1028: ,itemkey => itemkey
1029: ,aname => 'TASK_ID');
1030:
1031: l_parent_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1032: ,itemkey => itemkey
1033: ,aname => 'PARENT_TASK_ID');
1034: l_parent_struc_ver := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1035: ,itemkey => itemkey

Line 1034: l_parent_struc_ver := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1030:
1031: l_parent_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1032: ,itemkey => itemkey
1033: ,aname => 'PARENT_TASK_ID');
1034: l_parent_struc_ver := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1035: ,itemkey => itemkey
1036: ,aname => 'PARENT_STRUC_VER_ID');
1037:
1038: l_proj_org := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

Line 1038: l_proj_org := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1034: l_parent_struc_ver := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1035: ,itemkey => itemkey
1036: ,aname => 'PARENT_STRUC_VER_ID');
1037:
1038: l_proj_org := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1039: ,itemkey => itemkey
1040: ,aname => 'PROJ_ORG_ID');
1041:
1042: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

Line 1042: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1038: l_proj_org := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1039: ,itemkey => itemkey
1040: ,aname => 'PROJ_ORG_ID');
1041:
1042: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1043: ,itemkey => itemkey
1044: ,aname => 'CI_ID');
1045:
1046: IF PA_TASK_APPROVAL_PKG.Is_Parent_Task_Approved (

Line 1065: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

1061: ,p_ci_id => l_ci_id
1062: ,x_content_id => l_content_id
1063: );
1064: IF l_content_id IS NOT NULL THEN
1065: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
1066: ,itemkey => itemkey
1067: ,aname => 'CONTENT_ID'
1068: ,avalue => l_content_id
1069: );

Line 1079: resultout := wf_engine.eng_completed||':'||'T';

1075: UPDATE PA_PROJ_ELEMENTS
1076: SET task_status = 'SUBMITTED'
1077: WHERE proj_element_id = l_proj_element;
1078:
1079: resultout := wf_engine.eng_completed||':'||'T';
1080: ELSE
1081: log_message('Parent Task '||l_parent_task_id||' of task '||l_proj_element||' is not yet approved',3);
1082: resultout := wf_engine.eng_completed||':'||'F';
1083: END IF;

Line 1082: resultout := wf_engine.eng_completed||':'||'F';

1078:
1079: resultout := wf_engine.eng_completed||':'||'T';
1080: ELSE
1081: log_message('Parent Task '||l_parent_task_id||' of task '||l_proj_element||' is not yet approved',3);
1082: resultout := wf_engine.eng_completed||':'||'F';
1083: END IF;
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_ERROR THEN
1086: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Parent_Task_Approved',itemtype, itemkey, to_char(actid), funcmode);

Line 1179: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1175:
1176: BEGIN
1177:
1178: log_message('Inside procedure POST_TASK ',3);
1179: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1180: ,itemkey => itemkey
1181: ,aname => 'PROJECT_ID');
1182: l_parent_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1183: ,itemkey => itemkey

Line 1182: l_parent_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1178: log_message('Inside procedure POST_TASK ',3);
1179: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1180: ,itemkey => itemkey
1181: ,aname => 'PROJECT_ID');
1182: l_parent_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1183: ,itemkey => itemkey
1184: ,aname => 'PARENT_TASK_ID');
1185: l_task_number := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1186: ,itemkey => itemkey

Line 1185: l_task_number := WF_ENGINE.GetItemAttrText(itemtype => itemtype

1181: ,aname => 'PROJECT_ID');
1182: l_parent_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1183: ,itemkey => itemkey
1184: ,aname => 'PARENT_TASK_ID');
1185: l_task_number := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1186: ,itemkey => itemkey
1187: ,aname => 'TASK_NUMBER');
1188: l_task_name := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1189: ,itemkey => itemkey

Line 1188: l_task_name := WF_ENGINE.GetItemAttrText(itemtype => itemtype

1184: ,aname => 'PARENT_TASK_ID');
1185: l_task_number := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1186: ,itemkey => itemkey
1187: ,aname => 'TASK_NUMBER');
1188: l_task_name := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1189: ,itemkey => itemkey
1190: ,aname => 'TASK_NAME');
1191: l_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1192: ,itemkey => itemkey

Line 1191: l_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1187: ,aname => 'TASK_NUMBER');
1188: l_task_name := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1189: ,itemkey => itemkey
1190: ,aname => 'TASK_NAME');
1191: l_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1192: ,itemkey => itemkey
1193: ,aname => 'TASK_ID');
1194: l_task_st_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype
1195: ,itemkey => itemkey

Line 1194: l_task_st_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype

1190: ,aname => 'TASK_NAME');
1191: l_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1192: ,itemkey => itemkey
1193: ,aname => 'TASK_ID');
1194: l_task_st_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype
1195: ,itemkey => itemkey
1196: ,aname => 'TASK_ST_DATE');
1197: l_task_end_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype
1198: ,itemkey => itemkey

Line 1197: l_task_end_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype

1193: ,aname => 'TASK_ID');
1194: l_task_st_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype
1195: ,itemkey => itemkey
1196: ,aname => 'TASK_ST_DATE');
1197: l_task_end_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype
1198: ,itemkey => itemkey
1199: ,aname => 'TASK_END_DATE');
1200: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1201: ,itemkey => itemkey

Line 1200: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1196: ,aname => 'TASK_ST_DATE');
1197: l_task_end_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype
1198: ,itemkey => itemkey
1199: ,aname => 'TASK_END_DATE');
1200: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1201: ,itemkey => itemkey
1202: ,aname => 'PROJ_ORG_ID');
1203: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1204: ,itemkey => itemkey

Line 1203: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1199: ,aname => 'TASK_END_DATE');
1200: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1201: ,itemkey => itemkey
1202: ,aname => 'PROJ_ORG_ID');
1203: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1204: ,itemkey => itemkey
1205: ,aname => 'CI_ID');
1206: l_result := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1207: ,itemkey => itemkey

Line 1206: l_result := WF_ENGINE.GetItemAttrText(itemtype => itemtype

1202: ,aname => 'PROJ_ORG_ID');
1203: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1204: ,itemkey => itemkey
1205: ,aname => 'CI_ID');
1206: l_result := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1207: ,itemkey => itemkey
1208: ,aname => 'RESULT');
1209:
1210:

Line 1260: resultout := wf_engine.eng_completed||':'||'F';

1256: --b6694902_debug.debug('Inside POST_TASK for task '||l_task_id||' x_msg_data:'||x_msg_data);
1257:
1258: IF x_return_status <> 'S' THEN
1259: log_message('Call to PA_TASKS_MAINT_PUB.CREATE_TASK is errored out',3);
1260: resultout := wf_engine.eng_completed||':'||'F';
1261: ELSE
1262: log_message('Create Task is successful',3);
1263: UPDATE PA_PROJ_ELEMENTS SET link_task_flag = 'N', task_status = ''
1264: WHERE proj_element_id = l_task_id;

Line 1320: resultout := wf_engine.eng_completed||':'||'T';

1316:
1317: END LOOP;
1318:
1319: END LOOP;
1320: resultout := wf_engine.eng_completed||':'||'T';
1321: END IF;
1322: EXCEPTION
1323: WHEN FND_API.G_EXC_ERROR THEN
1324: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Post_Task',itemtype, itemkey, to_char(actid), funcmode);

Line 1361: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1357: log_message('Inside Update_Task_Status Procedure',3);
1358:
1359: log_message('Fetching all the workflow attribute values required',3);
1360:
1361: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1362: ,itemkey => itemkey
1363: ,aname => 'PROJECT_ID');
1364: l_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1365: ,itemkey => itemkey

Line 1364: l_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1360:
1361: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1362: ,itemkey => itemkey
1363: ,aname => 'PROJECT_ID');
1364: l_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1365: ,itemkey => itemkey
1366: ,aname => 'TASK_ID');
1367: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1368: ,itemkey => itemkey

Line 1367: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1363: ,aname => 'PROJECT_ID');
1364: l_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1365: ,itemkey => itemkey
1366: ,aname => 'TASK_ID');
1367: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1368: ,itemkey => itemkey
1369: ,aname => 'PROJ_ORG_ID');
1370:
1371: l_parent_struc_ver := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

Line 1371: l_parent_struc_ver := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1367: l_org_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1368: ,itemkey => itemkey
1369: ,aname => 'PROJ_ORG_ID');
1370:
1371: l_parent_struc_ver := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1372: ,itemkey => itemkey
1373: ,aname => 'PARENT_STRUC_VER_ID');
1374:
1375: l_aprv_user_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

Line 1375: l_aprv_user_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1371: l_parent_struc_ver := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1372: ,itemkey => itemkey
1373: ,aname => 'PARENT_STRUC_VER_ID');
1374:
1375: l_aprv_user_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1376: ,itemkey => itemkey
1377: ,aname => 'TASK_APPROVER_ID');
1378:
1379: l_proj_element_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype

Line 1379: l_proj_element_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype

1375: l_aprv_user_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1376: ,itemkey => itemkey
1377: ,aname => 'TASK_APPROVER_ID');
1378:
1379: l_proj_element_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1380: ,itemkey => itemkey
1381: ,aname => 'TASK_ID');
1382:
1383: l_ci_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype

Line 1383: l_ci_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype

1379: l_proj_element_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1380: ,itemkey => itemkey
1381: ,aname => 'TASK_ID');
1382:
1383: l_ci_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype
1384: ,itemkey => itemkey
1385: ,aname => 'CI_ID');
1386:
1387: log_message('Marking task status to pending for its parent tasks approval',3);

Line 1404: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

1400: ,p_cd_yn => 'N'
1401: ,x_content_id => l_content_id
1402: );
1403: IF l_content_id IS NOT NULL THEN
1404: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
1405: ,itemkey => itemkey
1406: ,aname => 'CONTENT_ID'
1407: ,avalue => l_content_id
1408: );

Line 1491: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1487: BEGIN
1488:
1489: log_message('Inside Delete_Task Procedure',3);
1490:
1491: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1492: ,itemkey => itemkey
1493: ,aname => 'CI_ID');
1494: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1495: ,itemkey => itemkey

Line 1494: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1490:
1491: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1492: ,itemkey => itemkey
1493: ,aname => 'CI_ID');
1494: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1495: ,itemkey => itemkey
1496: ,aname => 'PROJECT_ID');
1497: l_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1498: ,itemkey => itemkey

Line 1497: l_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1493: ,aname => 'CI_ID');
1494: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1495: ,itemkey => itemkey
1496: ,aname => 'PROJECT_ID');
1497: l_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1498: ,itemkey => itemkey
1499: ,aname => 'TASK_ID');
1500:
1501: l_aprv_user_id := WF_ENGINE.GetItemAttrNumber

Line 1501: l_aprv_user_id := WF_ENGINE.GetItemAttrNumber

1497: l_task_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1498: ,itemkey => itemkey
1499: ,aname => 'TASK_ID');
1500:
1501: l_aprv_user_id := WF_ENGINE.GetItemAttrNumber
1502: (itemtype => itemtype
1503: ,itemkey => itemkey
1504: ,aname => 'TASK_APPROVER_ID'
1505: );

Line 1586: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1582: BEGIN
1583: log_message('Inside Verify_Task_Status',3);
1584: x_return_status := 'S';
1585:
1586: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1587: ,itemkey => itemkey
1588: ,aname => 'CI_ID');
1589:
1590: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

Line 1590: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1586: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1587: ,itemkey => itemkey
1588: ,aname => 'CI_ID');
1589:
1590: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1591: ,itemkey => itemkey
1592: ,aname => 'PROJECT_ID');
1593: log_message('Closing any earlier notifications of task and raising new notification',3);
1594: FOR TaskId in C1 LOOP

Line 1649: resultout := wf_engine.eng_completed||':'||'F';

1645: END LOOP;
1646:
1647: IF l_unapproved_task_cnt >0 THEN
1648: log_message('There are '||l_unapproved_task_cnt||' unapproved tasks for this Change Document',3);
1649: resultout := wf_engine.eng_completed||':'||'F';
1650: ELSE
1651: log_message('There is no task pending for Approval, which is used in this Change document',3);
1652: resultout := wf_engine.eng_completed||':'||'T';
1653: END IF;

Line 1652: resultout := wf_engine.eng_completed||':'||'T';

1648: log_message('There are '||l_unapproved_task_cnt||' unapproved tasks for this Change Document',3);
1649: resultout := wf_engine.eng_completed||':'||'F';
1650: ELSE
1651: log_message('There is no task pending for Approval, which is used in this Change document',3);
1652: resultout := wf_engine.eng_completed||':'||'T';
1653: END IF;
1654: EXCEPTION
1655: WHEN FND_API.G_EXC_ERROR THEN
1656: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Verify_Task_Status',itemtype, itemkey, to_char(actid), funcmode);

Line 1685: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1681: BEGIN
1682: log_message('Inside MARK_CO_STATUS',3);
1683: x_return_status := 'S';
1684:
1685: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1686: ,itemkey => itemkey
1687: ,aname => 'CI_ID');
1688: log_message('Marking change document status to CI_SUBMITTED',3);
1689: PA_TASK_APPROVAL_PKG.Mark_CO_Status(

Line 1695: resultout := wf_engine.eng_completed||':'||'F';

1691: ,x_msg_count
1692: ,x_msg_data
1693: ,x_return_status);
1694: IF x_return_status = 'E' THEN
1695: resultout := wf_engine.eng_completed||':'||'F';
1696: ELSE
1697: resultout := wf_engine.eng_completed||':'||'T';
1698: END IF;
1699: EXCEPTION

Line 1697: resultout := wf_engine.eng_completed||':'||'T';

1693: ,x_return_status);
1694: IF x_return_status = 'E' THEN
1695: resultout := wf_engine.eng_completed||':'||'F';
1696: ELSE
1697: resultout := wf_engine.eng_completed||':'||'T';
1698: END IF;
1699: EXCEPTION
1700: WHEN FND_API.G_EXC_ERROR THEN
1701: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Mark_CO_Status',itemtype, itemkey, to_char(actid), funcmode);

Line 1784: WF_ENGINE.SetItemAttrText (itemtype => itemtype

1780: CLOSE c_starter_full_name;
1781:
1782: log_message('Setting the item attributes to reflect the respective task data',3);
1783: IF c_task_info_rec.parent_task_number IS NOT NULL THEN
1784: WF_ENGINE.SetItemAttrText (itemtype => itemtype
1785: ,itemkey => itemkey
1786: ,aname => 'PARENT_TASK_NUMBER'
1787: ,avalue => c_task_info_rec.parent_task_number
1788: );

Line 1792: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

1788: );
1789: END IF;
1790:
1791: IF c_task_info_rec.parent_task_id IS NOT NULL THEN
1792: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
1793: ,itemkey => itemkey
1794: ,aname => 'PARENT_TASK_ID'
1795: ,avalue => c_task_info_rec.parent_task_id
1796: );

Line 1800: WF_ENGINE.SetItemAttrText (itemtype => itemtype

1796: );
1797: END IF;
1798:
1799: IF c_task_info_rec.task_number IS NOT NULL THEN
1800: WF_ENGINE.SetItemAttrText (itemtype => itemtype
1801: ,itemkey => itemkey
1802: ,aname => 'TASK_NUMBER'
1803: ,avalue => c_task_info_rec.task_number
1804: );

Line 1808: WF_ENGINE.SetItemAttrText (itemtype => itemtype

1804: );
1805: END IF;
1806:
1807: IF c_task_info_rec.task_name IS NOT NULL THEN
1808: WF_ENGINE.SetItemAttrText (itemtype => itemtype
1809: ,itemkey => itemkey
1810: ,aname => 'TASK_NAME'
1811: ,avalue => c_task_info_rec.task_number
1812: );

Line 1816: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

1812: );
1813: END IF;
1814:
1815: IF c_task_info_rec.task_id IS NOT NULL THEN
1816: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
1817: ,itemkey => itemkey
1818: ,aname => 'TASK_ID'
1819: ,avalue => c_task_info_rec.task_id
1820: );

Line 1824: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

1820: );
1821: END IF;
1822:
1823: IF c_task_info_rec.created_by IS NOT NULL THEN
1824: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
1825: ,itemkey => itemkey
1826: ,aname => 'SUBMITTED_BY_ID'
1827: ,avalue => c_task_info_rec.created_by
1828: );

Line 1832: WF_ENGINE.SetItemAttrText (itemtype => itemtype

1828: );
1829: END IF;
1830:
1831: IF l_user_full_name IS NOT NULL THEN
1832: WF_ENGINE.SetItemAttrText (itemtype => itemtype
1833: ,itemkey => itemkey
1834: ,aname => 'SUBMITTED_BY'
1835: ,avalue => l_user_full_name
1836: );

Line 1840: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

1836: );
1837: END IF;
1838:
1839: IF c_task_info_rec.created_by IS NOT NULL THEN
1840: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
1841: ,itemkey => itemkey
1842: ,aname => 'WORKFLOW_STARTED_BY_ID'
1843: ,avalue => c_task_info_rec.created_by
1844: );

Line 1848: WF_ENGINE.SetItemAttrText (itemtype => itemtype

1844: );
1845: END IF;
1846:
1847: IF l_user_name IS NOT NULL THEN
1848: WF_ENGINE.SetItemAttrText (itemtype => itemtype
1849: ,itemkey => itemkey
1850: ,aname => 'WORKFLOW_STARTED_BY_NAME'
1851: ,avalue => l_user_name
1852: );

Line 1855: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1851: ,avalue => l_user_name
1852: );
1853: END IF;
1854:
1855: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1856: ,itemkey => itemkey
1857: ,aname => 'PROJECT_ID');
1858:
1859: l_proj_org := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

Line 1859: l_proj_org := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1855: l_project_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1856: ,itemkey => itemkey
1857: ,aname => 'PROJECT_ID');
1858:
1859: l_proj_org := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1860: ,itemkey => itemkey
1861: ,aname => 'PROJ_ORG_ID');
1862: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1863: ,itemkey => itemkey

Line 1862: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype

1858:
1859: l_proj_org := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1860: ,itemkey => itemkey
1861: ,aname => 'PROJ_ORG_ID');
1862: l_ci_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype
1863: ,itemkey => itemkey
1864: ,aname => 'CI_ID');
1865:
1866: log_message('Calling generate_task_aprv_notify to generate notification',3);

Line 1878: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype

1874: ,x_content_id => l_content_id
1875: );
1876:
1877: IF l_content_id IS NOT NULL THEN
1878: WF_ENGINE.SetItemAttrNumber (itemtype => itemtype
1879: ,itemkey => itemkey
1880: ,aname => 'CONTENT_ID'
1881: ,avalue => l_content_id
1882: );

Line 1902: resultout := wf_engine.eng_completed||':'||'F';

1898: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE
1899: WHERE element_version_id = l_elem_ver_id;
1900:
1901: IF g_del_taskrec.COUNT > 0 THEN
1902: resultout := wf_engine.eng_completed||':'||'F';
1903: ELSE
1904: resultout := wf_engine.eng_completed||':'||'T';
1905: END IF;
1906: g_del_taskrec.delete(g_del_taskrec.FIRST,g_del_taskrec.FIRST);

Line 1904: resultout := wf_engine.eng_completed||':'||'T';

1900:
1901: IF g_del_taskrec.COUNT > 0 THEN
1902: resultout := wf_engine.eng_completed||':'||'F';
1903: ELSE
1904: resultout := wf_engine.eng_completed||':'||'T';
1905: END IF;
1906: g_del_taskrec.delete(g_del_taskrec.FIRST,g_del_taskrec.FIRST);
1907: ELSE
1908: resultout := wf_engine.eng_completed||':'||'T';

Line 1908: resultout := wf_engine.eng_completed||':'||'T';

1904: resultout := wf_engine.eng_completed||':'||'T';
1905: END IF;
1906: g_del_taskrec.delete(g_del_taskrec.FIRST,g_del_taskrec.FIRST);
1907: ELSE
1908: resultout := wf_engine.eng_completed||':'||'T';
1909: END IF;
1910: EXCEPTION
1911: WHEN FND_API.G_EXC_ERROR THEN
1912: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Last_Task',itemtype, itemkey, to_char(actid), funcmode);