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.ENG_WORKFLOW_API_PKG dependencies on WF_ENGINE

Line 19: -- step must be performed. A call to wf_engine.CompleteActivty

15: -- - DEFERED
16: -- execution should be defered to background
17: -- - NOTIFIED[::]
18: -- activity has notified an external entity that this
19: -- step must be performed. A call to wf_engine.CompleteActivty
20: -- will signal when this step is complete. Optional
21: -- return of notification ID and assigned user.
22: -- - ERROR[:]
23: -- function encountered an error.

Line 71: X_change_notice := Wf_Engine.GetItemAttrText(

67: --
68: -- RUN mode - normal process execution
69: --
70: IF (funcmode = 'RUN') THEN
71: X_change_notice := Wf_Engine.GetItemAttrText(
72: itemtype => itemtype,
73: itemkey => itemkey,
74: aname => 'CHANGE_NOTICE');
75: X_org_id := Wf_Engine.GetItemAttrNumber(

Line 75: X_org_id := Wf_Engine.GetItemAttrNumber(

71: X_change_notice := Wf_Engine.GetItemAttrText(
72: itemtype => itemtype,
73: itemkey => itemkey,
74: aname => 'CHANGE_NOTICE');
75: X_org_id := Wf_Engine.GetItemAttrNumber(
76: itemtype => itemtype,
77: itemkey => itemkey,
78: aname => 'ORG_ID');
79: X_rev_id := Wf_Engine.GetItemAttrNumber(

Line 79: X_rev_id := Wf_Engine.GetItemAttrNumber(

75: X_org_id := Wf_Engine.GetItemAttrNumber(
76: itemtype => itemtype,
77: itemkey => itemkey,
78: aname => 'ORG_ID');
79: X_rev_id := Wf_Engine.GetItemAttrNumber(
80: itemtype => itemtype,
81: itemkey => itemkey,
82: aname => 'REV_ID');
83: IF (X_change_notice is null or X_org_id is null or

Line 108: Wf_Engine.SetItemAttrText(itemtype => itemtype,

104: <>
105: IF (X_hyphen2 <> 0) THEN
106: X_org_id := substr(X_ecoorg, X_hyphen2 +1);
107: X_change_notice := substr(X_ecoorg, 1, X_hyphen2 -1);
108: Wf_Engine.SetItemAttrText(itemtype => itemtype,
109: itemkey => itemkey,
110: aname => 'CHANGE_NOTICE',
111: avalue => X_change_notice);
112: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,

Line 112: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,

108: Wf_Engine.SetItemAttrText(itemtype => itemtype,
109: itemkey => itemkey,
110: aname => 'CHANGE_NOTICE',
111: avalue => X_change_notice);
112: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
113: itemkey => itemkey,
114: aname => 'ORG_ID',
115: avalue => X_org_id);
116: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,

Line 116: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,

112: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
113: itemkey => itemkey,
114: aname => 'ORG_ID',
115: avalue => X_org_id);
116: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
117: itemkey => itemkey,
118: aname => 'REV_ID',
119: avalue => X_rev_id);
120: ELSE

Line 346: Wf_Engine.SetItemAttrText(itemtype => itemtype,

342: X_approval_list_name := null;
343: end;
344:
345: -- Add aproval list name in attribute APPROVAL_LIST
346: Wf_Engine.SetItemAttrText(itemtype => itemtype,
347: itemkey => itemkey,
348: aname => 'APPROVAL_LIST',
349: avalue => X_approval_list_name );
350: -- ERES end

Line 353: Wf_Engine.SetItemAttrText(itemtype => itemtype,

349: avalue => X_approval_list_name );
350: -- ERES end
351:
352:
353: Wf_Engine.SetItemAttrText(itemtype => itemtype,
354: itemkey => itemkey,
355: aname => 'CHANGE_NOTICE',
356: avalue => X_change_notice);
357: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 357: Wf_Engine.SetItemAttrText(itemtype => itemtype,

353: Wf_Engine.SetItemAttrText(itemtype => itemtype,
354: itemkey => itemkey,
355: aname => 'CHANGE_NOTICE',
356: avalue => X_change_notice);
357: Wf_Engine.SetItemAttrText(itemtype => itemtype,
358: itemkey => itemkey,
359: aname => 'ECO_DESCRIPTION',
360: avalue => X_description);
361: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 361: Wf_Engine.SetItemAttrText(itemtype => itemtype,

357: Wf_Engine.SetItemAttrText(itemtype => itemtype,
358: itemkey => itemkey,
359: aname => 'ECO_DESCRIPTION',
360: avalue => X_description);
361: Wf_Engine.SetItemAttrText(itemtype => itemtype,
362: itemkey => itemkey,
363: aname => 'ECO_STATUS',
364: avalue => X_eco_status);
365: Wf_Engine.SetItemAttrDate(itemtype => itemtype,

Line 365: Wf_Engine.SetItemAttrDate(itemtype => itemtype,

361: Wf_Engine.SetItemAttrText(itemtype => itemtype,
362: itemkey => itemkey,
363: aname => 'ECO_STATUS',
364: avalue => X_eco_status);
365: Wf_Engine.SetItemAttrDate(itemtype => itemtype,
366: itemkey => itemkey,
367: aname => 'INITIATION_DATE',
368: avalue => X_initiation_date);
369:

Line 371: Wf_Engine.SetItemOwner( itemtype => itemtype,

367: aname => 'INITIATION_DATE',
368: avalue => X_initiation_date);
369:
370: l_requestor_name := FND_GLOBAL.USER_NAME;
371: Wf_Engine.SetItemOwner( itemtype => itemtype,
372: itemkey => itemkey,
373: owner => l_requestor_name );
374:
375: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 375: Wf_Engine.SetItemAttrText(itemtype => itemtype,

371: Wf_Engine.SetItemOwner( itemtype => itemtype,
372: itemkey => itemkey,
373: owner => l_requestor_name );
374:
375: Wf_Engine.SetItemAttrText(itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'PRIORITY_CODE',
378: avalue => X_priority_code);
379: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 379: Wf_Engine.SetItemAttrText(itemtype => itemtype,

375: Wf_Engine.SetItemAttrText(itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'PRIORITY_CODE',
378: avalue => X_priority_code);
379: Wf_Engine.SetItemAttrText(itemtype => itemtype,
380: itemkey => itemkey,
381: aname => 'REASON_CODE',
382: avalue => X_reason_code);
383: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,

Line 383: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,

379: Wf_Engine.SetItemAttrText(itemtype => itemtype,
380: itemkey => itemkey,
381: aname => 'REASON_CODE',
382: avalue => X_reason_code);
383: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
384: itemkey => itemkey,
385: aname => 'ESTIMATED_ENG_COST',
386: avalue => X_estimated_eng_cost);
387: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,

Line 387: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,

383: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
384: itemkey => itemkey,
385: aname => 'ESTIMATED_ENG_COST',
386: avalue => X_estimated_eng_cost);
387: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
388: itemkey => itemkey,
389: aname => 'ESTIMATED_MFG_COST',
390: avalue => X_estimated_mfg_cost);
391: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 391: Wf_Engine.SetItemAttrText(itemtype => itemtype,

387: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
388: itemkey => itemkey,
389: aname => 'ESTIMATED_MFG_COST',
390: avalue => X_estimated_mfg_cost);
391: Wf_Engine.SetItemAttrText(itemtype => itemtype,
392: itemkey => itemkey,
393: aname => 'ATTRIBUTE_CATEGORY',
394: avalue => X_attribute_category);
395: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 395: Wf_Engine.SetItemAttrText(itemtype => itemtype,

391: Wf_Engine.SetItemAttrText(itemtype => itemtype,
392: itemkey => itemkey,
393: aname => 'ATTRIBUTE_CATEGORY',
394: avalue => X_attribute_category);
395: Wf_Engine.SetItemAttrText(itemtype => itemtype,
396: itemkey => itemkey,
397: aname => 'ATTRIBUTE1',
398: avalue => X_attribute1);
399: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 399: Wf_Engine.SetItemAttrText(itemtype => itemtype,

395: Wf_Engine.SetItemAttrText(itemtype => itemtype,
396: itemkey => itemkey,
397: aname => 'ATTRIBUTE1',
398: avalue => X_attribute1);
399: Wf_Engine.SetItemAttrText(itemtype => itemtype,
400: itemkey => itemkey,
401: aname => 'ATTRIBUTE2',
402: avalue => X_attribute2);
403: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 403: Wf_Engine.SetItemAttrText(itemtype => itemtype,

399: Wf_Engine.SetItemAttrText(itemtype => itemtype,
400: itemkey => itemkey,
401: aname => 'ATTRIBUTE2',
402: avalue => X_attribute2);
403: Wf_Engine.SetItemAttrText(itemtype => itemtype,
404: itemkey => itemkey,
405: aname => 'ATTRIBUTE3',
406: avalue => X_attribute3);
407: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 407: Wf_Engine.SetItemAttrText(itemtype => itemtype,

403: Wf_Engine.SetItemAttrText(itemtype => itemtype,
404: itemkey => itemkey,
405: aname => 'ATTRIBUTE3',
406: avalue => X_attribute3);
407: Wf_Engine.SetItemAttrText(itemtype => itemtype,
408: itemkey => itemkey,
409: aname => 'ATTRIBUTE4',
410: avalue => X_attribute4);
411: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 411: Wf_Engine.SetItemAttrText(itemtype => itemtype,

407: Wf_Engine.SetItemAttrText(itemtype => itemtype,
408: itemkey => itemkey,
409: aname => 'ATTRIBUTE4',
410: avalue => X_attribute4);
411: Wf_Engine.SetItemAttrText(itemtype => itemtype,
412: itemkey => itemkey,
413: aname => 'ATTRIBUTE5',
414: avalue => X_attribute5);
415: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 415: Wf_Engine.SetItemAttrText(itemtype => itemtype,

411: Wf_Engine.SetItemAttrText(itemtype => itemtype,
412: itemkey => itemkey,
413: aname => 'ATTRIBUTE5',
414: avalue => X_attribute5);
415: Wf_Engine.SetItemAttrText(itemtype => itemtype,
416: itemkey => itemkey,
417: aname => 'ATTRIBUTE6',
418: avalue => X_attribute6);
419: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 419: Wf_Engine.SetItemAttrText(itemtype => itemtype,

415: Wf_Engine.SetItemAttrText(itemtype => itemtype,
416: itemkey => itemkey,
417: aname => 'ATTRIBUTE6',
418: avalue => X_attribute6);
419: Wf_Engine.SetItemAttrText(itemtype => itemtype,
420: itemkey => itemkey,
421: aname => 'ATTRIBUTE7',
422: avalue => X_attribute7);
423: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 423: Wf_Engine.SetItemAttrText(itemtype => itemtype,

419: Wf_Engine.SetItemAttrText(itemtype => itemtype,
420: itemkey => itemkey,
421: aname => 'ATTRIBUTE7',
422: avalue => X_attribute7);
423: Wf_Engine.SetItemAttrText(itemtype => itemtype,
424: itemkey => itemkey,
425: aname => 'ATTRIBUTE8',
426: avalue => X_attribute8);
427: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 427: Wf_Engine.SetItemAttrText(itemtype => itemtype,

423: Wf_Engine.SetItemAttrText(itemtype => itemtype,
424: itemkey => itemkey,
425: aname => 'ATTRIBUTE8',
426: avalue => X_attribute8);
427: Wf_Engine.SetItemAttrText(itemtype => itemtype,
428: itemkey => itemkey,
429: aname => 'ATTRIBUTE9',
430: avalue => X_attribute9);
431: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 431: Wf_Engine.SetItemAttrText(itemtype => itemtype,

427: Wf_Engine.SetItemAttrText(itemtype => itemtype,
428: itemkey => itemkey,
429: aname => 'ATTRIBUTE9',
430: avalue => X_attribute9);
431: Wf_Engine.SetItemAttrText(itemtype => itemtype,
432: itemkey => itemkey,
433: aname => 'ATTRIBUTE10',
434: avalue => X_attribute10);
435: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 435: Wf_Engine.SetItemAttrText(itemtype => itemtype,

431: Wf_Engine.SetItemAttrText(itemtype => itemtype,
432: itemkey => itemkey,
433: aname => 'ATTRIBUTE10',
434: avalue => X_attribute10);
435: Wf_Engine.SetItemAttrText(itemtype => itemtype,
436: itemkey => itemkey,
437: aname => 'ATTRIBUTE11',
438: avalue => X_attribute11);
439: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 439: Wf_Engine.SetItemAttrText(itemtype => itemtype,

435: Wf_Engine.SetItemAttrText(itemtype => itemtype,
436: itemkey => itemkey,
437: aname => 'ATTRIBUTE11',
438: avalue => X_attribute11);
439: Wf_Engine.SetItemAttrText(itemtype => itemtype,
440: itemkey => itemkey,
441: aname => 'ATTRIBUTE12',
442: avalue => X_attribute12);
443: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 443: Wf_Engine.SetItemAttrText(itemtype => itemtype,

439: Wf_Engine.SetItemAttrText(itemtype => itemtype,
440: itemkey => itemkey,
441: aname => 'ATTRIBUTE12',
442: avalue => X_attribute12);
443: Wf_Engine.SetItemAttrText(itemtype => itemtype,
444: itemkey => itemkey,
445: aname => 'ATTRIBUTE13',
446: avalue => X_attribute13);
447: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 447: Wf_Engine.SetItemAttrText(itemtype => itemtype,

443: Wf_Engine.SetItemAttrText(itemtype => itemtype,
444: itemkey => itemkey,
445: aname => 'ATTRIBUTE13',
446: avalue => X_attribute13);
447: Wf_Engine.SetItemAttrText(itemtype => itemtype,
448: itemkey => itemkey,
449: aname => 'ATTRIBUTE14',
450: avalue => X_attribute14);
451: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 451: Wf_Engine.SetItemAttrText(itemtype => itemtype,

447: Wf_Engine.SetItemAttrText(itemtype => itemtype,
448: itemkey => itemkey,
449: aname => 'ATTRIBUTE14',
450: avalue => X_attribute14);
451: Wf_Engine.SetItemAttrText(itemtype => itemtype,
452: itemkey => itemkey,
453: aname => 'ATTRIBUTE15',
454: avalue => X_attribute15);
455: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 455: Wf_Engine.SetItemAttrText(itemtype => itemtype,

451: Wf_Engine.SetItemAttrText(itemtype => itemtype,
452: itemkey => itemkey,
453: aname => 'ATTRIBUTE15',
454: avalue => X_attribute15);
455: Wf_Engine.SetItemAttrText(itemtype => itemtype,
456: itemkey => itemkey,
457: aname => 'APPROVAL_STATUS',
458: avalue => X_approval_status);
459: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 459: Wf_Engine.SetItemAttrText(itemtype => itemtype,

455: Wf_Engine.SetItemAttrText(itemtype => itemtype,
456: itemkey => itemkey,
457: aname => 'APPROVAL_STATUS',
458: avalue => X_approval_status);
459: Wf_Engine.SetItemAttrText(itemtype => itemtype,
460: itemkey => itemkey,
461: aname => 'ORGANIZATION_CODE',
462: avalue => X_org_code);
463: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 463: Wf_Engine.SetItemAttrText(itemtype => itemtype,

459: Wf_Engine.SetItemAttrText(itemtype => itemtype,
460: itemkey => itemkey,
461: aname => 'ORGANIZATION_CODE',
462: avalue => X_org_code);
463: Wf_Engine.SetItemAttrText(itemtype => itemtype,
464: itemkey => itemkey,
465: aname => 'ORGANIZATION_NAME',
466: avalue => X_org_name);
467: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 467: Wf_Engine.SetItemAttrText(itemtype => itemtype,

463: Wf_Engine.SetItemAttrText(itemtype => itemtype,
464: itemkey => itemkey,
465: aname => 'ORGANIZATION_NAME',
466: avalue => X_org_name);
467: Wf_Engine.SetItemAttrText(itemtype => itemtype,
468: itemkey => itemkey,
469: aname => 'FULL_NAME',
470: avalue => X_requestor);
471: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 471: Wf_Engine.SetItemAttrText(itemtype => itemtype,

467: Wf_Engine.SetItemAttrText(itemtype => itemtype,
468: itemkey => itemkey,
469: aname => 'FULL_NAME',
470: avalue => X_requestor);
471: Wf_Engine.SetItemAttrText(itemtype => itemtype,
472: itemkey => itemkey,
473: aname => 'CHANGE_TYPE',
474: avalue => X_change_type);
475: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 475: Wf_Engine.SetItemAttrText(itemtype => itemtype,

471: Wf_Engine.SetItemAttrText(itemtype => itemtype,
472: itemkey => itemkey,
473: aname => 'CHANGE_TYPE',
474: avalue => X_change_type);
475: Wf_Engine.SetItemAttrText(itemtype => itemtype,
476: itemkey => itemkey,
477: aname => 'ECO_DEPT_NAME',
478: avalue => X_eco_dept_name);
479: Wf_Engine.SetItemAttrText(itemtype => itemtype,

Line 479: Wf_Engine.SetItemAttrText(itemtype => itemtype,

475: Wf_Engine.SetItemAttrText(itemtype => itemtype,
476: itemkey => itemkey,
477: aname => 'ECO_DEPT_NAME',
478: avalue => X_eco_dept_name);
479: Wf_Engine.SetItemAttrText(itemtype => itemtype,
480: itemkey => itemkey,
481: aname => 'ECO_DEPT_CODE',
482: avalue => X_eco_dept_code);
483:

Line 485: Wf_Engine.SetItemAttrNumber(itemtype=> itemtype,

481: aname => 'ECO_DEPT_CODE',
482: avalue => X_eco_dept_code);
483:
484: /* Fix for bug 5215778 - Added below code to assign values to Wf attributes TASK_ID, PROJECT_ID */
485: Wf_Engine.SetItemAttrNumber(itemtype=> itemtype,
486: itemkey => itemkey,
487: aname => 'TASK_ID',
488: avalue => X_task_id);
489: Wf_Engine.SetItemAttrNumber(itemtype=> itemtype,

Line 489: Wf_Engine.SetItemAttrNumber(itemtype=> itemtype,

485: Wf_Engine.SetItemAttrNumber(itemtype=> itemtype,
486: itemkey => itemkey,
487: aname => 'TASK_ID',
488: avalue => X_task_id);
489: Wf_Engine.SetItemAttrNumber(itemtype=> itemtype,
490: itemkey => itemkey,
491: aname => 'PROJECT_ID',
492: avalue => X_project_id);
493:

Line 498: Wf_Engine.SetItemAttrText(itemtype => itemtype,

494: /* Fix for bug 5131658- Get FND User who starts workflow*/
495: X_owner_value := GetWFItemOwnerRole(itemtype,
496: itemkey);
497: /* Set the value to WF_SIGN_REQUESTER */
498: Wf_Engine.SetItemAttrText(itemtype => itemtype,
499: itemkey => itemkey,
500: aname => '#WF_SIGN_REQUESTER',
501: avalue => X_owner_value);
502: /* End of fix for bug 5131658 */

Line 697: X_itemkey := Wf_Engine.GetItemAttrText(itemtype => itemtype,

693: --
694: -- RUN mode - normal process execution
695: --
696: IF (funcmode = 'RUN') THEN
697: X_itemkey := Wf_Engine.GetItemAttrText(itemtype => itemtype,
698: itemkey => itemkey,
699: aname => 'ERROR_ITEM_KEY');
700: X_itemtype := Wf_Engine.GetItemAttrText(itemtype => itemtype,
701: itemkey => itemkey,

Line 700: X_itemtype := Wf_Engine.GetItemAttrText(itemtype => itemtype,

696: IF (funcmode = 'RUN') THEN
697: X_itemkey := Wf_Engine.GetItemAttrText(itemtype => itemtype,
698: itemkey => itemkey,
699: aname => 'ERROR_ITEM_KEY');
700: X_itemtype := Wf_Engine.GetItemAttrText(itemtype => itemtype,
701: itemkey => itemkey,
702: aname => 'ERROR_ITEM_TYPE');
703: Get_ECO_and_OrgId(itemtype => X_itemtype,
704: itemkey => X_itemkey,

Line 1066: l_Event_Key := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,

1062: IF P_FUNCMODE ='RUN' THEN
1063:
1064: l_requester := FND_GLOBAL.USER_NAME;
1065:
1066: l_Event_Key := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,
1067: itemkey => p_itemkey,
1068: aname => 'CHANGE_ID');
1069:
1070: l_eres_doc := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,

Line 1070: l_eres_doc := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,

1066: l_Event_Key := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,
1067: itemkey => p_itemkey,
1068: aname => 'CHANGE_ID');
1069:
1070: l_eres_doc := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,
1071: itemkey => p_itemkey,
1072: aname => 'OPEN_ERES_DOC');
1073:
1074: l_change_notice := wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,

Line 1074: l_change_notice := wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,

1070: l_eres_doc := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,
1071: itemkey => p_itemkey,
1072: aname => 'OPEN_ERES_DOC');
1073:
1074: l_change_notice := wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
1075: itemkey => p_itemkey,
1076: aname => 'CHANGE_NOTICE');
1077:
1078: IF l_eres_doc = 0

Line 1142: Wf_Engine.SetItemAttrNumber(itemtype => p_itemtype,

1138: p_document_id => l_doc_id,
1139: p_doc_parameters_tbl => l_parameters);
1140:
1141: -- SET DOC ID
1142: Wf_Engine.SetItemAttrNumber(itemtype => p_itemtype,
1143: itemkey => p_itemkey,
1144: aname => 'DOC_ID',
1145: avalue => l_doc_id);
1146: end if;

Line 1149: Wf_Engine.SetItemAttrNumber(itemtype => p_itemtype,

1145: avalue => l_doc_id);
1146: end if;
1147: -- the rest below will be called many times, per # of signers
1148:
1149: Wf_Engine.SetItemAttrNumber(itemtype => p_itemtype,
1150: itemkey => p_itemkey,
1151: aname => 'OPEN_ERES_DOC',
1152: avalue => 1);
1153:

Line 1154: l_doc_id := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,

1150: itemkey => p_itemkey,
1151: aname => 'OPEN_ERES_DOC',
1152: avalue => 1);
1153:
1154: l_doc_id := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,
1155: itemkey => p_itemkey,
1156: aname => 'DOC_ID');
1157:
1158:

Line 1160: l_notification_result := wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,

1156: aname => 'DOC_ID');
1157:
1158:
1159: -- get the result of the notification i.e approve/rejected
1160: l_notification_result := wf_engine.GETITEMATTRTEXT(itemtype => p_itemtype,
1161: itemkey => p_itemkey,
1162: aname => 'RESULT');
1163:
1164:

Line 1169: l_sign_params(1).param_value:= wf_engine.getitemattrtext(p_itemtype,p_itemkey,'SIG_REASON');

1165: /* Post Signature Parameters */
1166:
1167: -- Singning Reason
1168: l_sign_params(1).param_name:= 'REASON_CODE';
1169: l_sign_params(1).param_value:= wf_engine.getitemattrtext(p_itemtype,p_itemkey,'SIG_REASON');
1170: l_sign_params(1).param_displayname:= 'Signing Reason';
1171:
1172: -- Signer comments
1173: l_sign_params(2).param_name:='SIGNERS_COMMENT';

Line 1174: l_sign_params(2).param_value:= wf_engine.getitemattrtext(p_itemtype,p_itemkey,'SIGNERS_COMMENTS');

1170: l_sign_params(1).param_displayname:= 'Signing Reason';
1171:
1172: -- Signer comments
1173: l_sign_params(2).param_name:='SIGNERS_COMMENT';
1174: l_sign_params(2).param_value:= wf_engine.getitemattrtext(p_itemtype,p_itemkey,'SIGNERS_COMMENTS');
1175: l_sign_params(2).param_displayname:='Signer Comments';
1176:
1177:
1178: -- Signature Type

Line 1180: l_sign_params(3).param_value:= wf_engine.getitemattrtext(p_itemtype,p_itemkey,'WF_SIGNER_TYPE');

1176:
1177:
1178: -- Signature Type
1179: l_sign_params(3).param_name:='WF_SIGNER_TYPE';
1180: l_sign_params(3).param_value:= wf_engine.getitemattrtext(p_itemtype,p_itemkey,'WF_SIGNER_TYPE');
1181: l_sign_params(3).param_displayname:='Signature Type ';
1182:
1183: IF l_notification_result ='Y'
1184: THEN

Line 1281: wf_engine.setitemattrtext(itemtype => itemtype,

1277: AND eec.change_notice = X_change_notice;
1278:
1279: l_requester_name := FND_GLOBAL.USER_NAME;
1280:
1281: wf_engine.setitemattrtext(itemtype => itemtype,
1282: itemkey => itemkey,
1283: aname => '#WF_SIGN_REQUESTER',
1284: avalue => l_requester_name );
1285:

Line 1286: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,

1282: itemkey => itemkey,
1283: aname => '#WF_SIGN_REQUESTER',
1284: avalue => l_requester_name );
1285:
1286: Wf_Engine.SetItemAttrNumber(itemtype => itemtype,
1287: itemkey => itemkey,
1288: aname => 'CHANGE_ID',
1289: avalue => X_change_id);
1290:

Line 1292: wf_engine.setitemattrtext(itemtype => itemtype,

1288: aname => 'CHANGE_ID',
1289: avalue => X_change_id);
1290:
1291: -- Attachments hookup calls
1292: wf_engine.setitemattrtext(itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => '#ATTACHMENTS',
1295: avalue => 'FND:entity=ENG_ENGINEERING_CHANGES'||'&'||'pk1name=CHANGE_ID'||'&'||'pk1value='||X_change_id);
1296:

Line 1319: l_psig_event := wf_engine.getItemAttrEvent(itemtype, itemkey, '#PSIG_EVENT');

1315: ) ;
1316:
1317: /* Generate Event Payload */
1318:
1319: l_psig_event := wf_engine.getItemAttrEvent(itemtype, itemkey, '#PSIG_EVENT');
1320:
1321: l_psig_event.setEventName('oracle.apps.eng.ecoApproval');
1322: l_psig_event.setEventKey(X_change_id);
1323: l_psig_event.setEventData(p_xmldoc);

Line 1325: wf_engine.setItemAttrEvent(itemtype, itemkey,'#PSIG_EVENT',l_psig_event);

1321: l_psig_event.setEventName('oracle.apps.eng.ecoApproval');
1322: l_psig_event.setEventKey(X_change_id);
1323: l_psig_event.setEventData(p_xmldoc);
1324:
1325: wf_engine.setItemAttrEvent(itemtype, itemkey,'#PSIG_EVENT',l_psig_event);
1326:
1327: /* get the From attributes */
1328:
1329: wf_event.addParameterToList(p_name => '#FROM_ROLE',

Line 1455: l_response_read := wf_notification.getattrtext(wf_engine.context_nid, 'READ_RESPONSE');

1451: -- The attribute stores user's response of "I have read the e-record".
1452: -- if the answer is No, then raise application error
1453: --
1454: IF (funcmode = 'RESPOND') THEN
1455: l_response_read := wf_notification.getattrtext(wf_engine.context_nid, 'READ_RESPONSE');
1456: IF (l_response_read = 'N') THEN
1457: WF_CORE.CONTEXT('ENG_WORKFLOW_API_PKG', 'VoteForResultType',itemtype, itemkey,
1458: FND_MESSAGE.GET_STRING('EDR','EDR_EREC_NOT_REVIEWED_ERR'));
1459: raise_application_error(-20002,FND_MESSAGE.GET_STRING('EDR','EDR_EREC_NOT_REVIEWED_ERR'));

Line 1474: if (funcmode <> wf_engine.eng_run)

1470:
1471:
1472:
1473: -- Do nothing unless in RUN or TIMEOUT modes
1474: if (funcmode <> wf_engine.eng_run)
1475: and (funcmode <> wf_engine.eng_timeout) then
1476: resultout := wf_engine.eng_null;
1477: return;
1478: end if;

Line 1475: and (funcmode <> wf_engine.eng_timeout) then

1471:
1472:
1473: -- Do nothing unless in RUN or TIMEOUT modes
1474: if (funcmode <> wf_engine.eng_run)
1475: and (funcmode <> wf_engine.eng_timeout) then
1476: resultout := wf_engine.eng_null;
1477: return;
1478: end if;
1479:

Line 1476: resultout := wf_engine.eng_null;

1472:
1473: -- Do nothing unless in RUN or TIMEOUT modes
1474: if (funcmode <> wf_engine.eng_run)
1475: and (funcmode <> wf_engine.eng_timeout) then
1476: resultout := wf_engine.eng_null;
1477: return;
1478: end if;
1479:
1480: -- SYNCHMODE: Not allowed

Line 1481: if (itemkey = wf_engine.eng_synch) then

1477: return;
1478: end if;
1479:
1480: -- SYNCHMODE: Not allowed
1481: if (itemkey = wf_engine.eng_synch) then
1482: Wf_Core.Token('OPERATION', 'Wf_Standard.VotForResultType');
1483: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
1484: end if;
1485:

Line 1489: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,

1485:
1486: -- Get Notifications group_id for activity
1487: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
1488: l_group_id,l_user);
1489: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
1490: actid,'VOTING_OPTION');
1491: if (l_voting_option not in ('REQUIRE_ALL_VOTES', 'WAIT_FOR_ALL_VOTES',
1492: 'TALLY_ON_EVERY_VOTE')) then
1493: raise wf_invalid_command;

Line 1503: ((funcmode = wf_engine.eng_run) and

1499: -- and there are still open notifications, then return WAITING to
1500: -- either continue voting (in run mode) or trigger timeout processing
1501: -- (in timeout mode).
1502: if ((l_voting_option = 'REQUIRE_ALL_VOTES') or
1503: ((funcmode = wf_engine.eng_run) and
1504: (l_voting_option = 'WAIT_FOR_ALL_VOTES'))) then
1505: if (wf_notification.OpenNotificationsExist(l_group_id)) then
1506: resultout := wf_engine.eng_waiting;
1507: return;

Line 1506: resultout := wf_engine.eng_waiting;

1502: if ((l_voting_option = 'REQUIRE_ALL_VOTES') or
1503: ((funcmode = wf_engine.eng_run) and
1504: (l_voting_option = 'WAIT_FOR_ALL_VOTES'))) then
1505: if (wf_notification.OpenNotificationsExist(l_group_id)) then
1506: resultout := wf_engine.eng_waiting;
1507: return;
1508: end if;
1509: end if;
1510:

Line 1524: if (funcmode = wf_engine.eng_timeout) then

1520: l_code_count,l_per_of_total,l_per_of_vote);
1521:
1522: -- If this is timeout mode, then use the percent of votes cast so far.
1523: -- If this is run mode, then use the percent of total votes possible.
1524: if (funcmode = wf_engine.eng_timeout) then
1525: l_per_code := l_per_of_vote;
1526: else
1527: l_per_code := l_per_of_total;
1528: end if;

Line 1531: per_success := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,

1527: l_per_code := l_per_of_total;
1528: end if;
1529:
1530: -- Get percent vote needed for this result to succeed
1531: per_success := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey,
1532: actid,result_rec.result_code);
1533:
1534: if (per_success is null) then
1535: -- Null value means this is a default result.

Line 1542: default_result := wf_engine.eng_tie;

1538: max_default := l_code_count;
1539: default_result := result_rec.result_code;
1540: elsif (l_code_count = max_default) then
1541: -- Tie for default result.
1542: default_result := wf_engine.eng_tie;
1543: end if;
1544: else
1545: -- If:
1546: -- a. % vote for this result > % needed for success OR

Line 1558: resultout := wf_engine.eng_completed||':'||wf_engine.eng_tie;

1554: -- Save satisfied result.
1555: result := result_rec.result_code;
1556: else
1557: -- This is the second result to be satisfied. Return a tie.
1558: resultout := wf_engine.eng_completed||':'||wf_engine.eng_tie;
1559: return;
1560: end if;
1561: end if;
1562: end if;

Line 1568: resultout := wf_engine.eng_completed||':'||result;

1564:
1565: if (result is not null) then
1566:
1567: -- Return the satisfied result code.
1568: resultout := wf_engine.eng_completed||':'||result;
1569: else
1570: -- If we get here no non-default results were satisfied.
1571: if (funcmode = wf_engine.eng_run and
1572: wf_notification.OpenNotificationsExist(l_group_id)) then

Line 1571: if (funcmode = wf_engine.eng_run and

1567: -- Return the satisfied result code.
1568: resultout := wf_engine.eng_completed||':'||result;
1569: else
1570: -- If we get here no non-default results were satisfied.
1571: if (funcmode = wf_engine.eng_run and
1572: wf_notification.OpenNotificationsExist(l_group_id)) then
1573: -- Not timed out and still open notifications.
1574: -- Return waiting to continue voting.
1575: resultout := wf_engine.eng_waiting;

Line 1575: resultout := wf_engine.eng_waiting;

1571: if (funcmode = wf_engine.eng_run and
1572: wf_notification.OpenNotificationsExist(l_group_id)) then
1573: -- Not timed out and still open notifications.
1574: -- Return waiting to continue voting.
1575: resultout := wf_engine.eng_waiting;
1576: elsif (default_result is not null) then
1577: -- Either timeout or all notifications closed
1578: -- Return default result if one found.
1579: resultout := wf_engine.eng_completed||':'||default_result;

Line 1579: resultout := wf_engine.eng_completed||':'||default_result;

1575: resultout := wf_engine.eng_waiting;
1576: elsif (default_result is not null) then
1577: -- Either timeout or all notifications closed
1578: -- Return default result if one found.
1579: resultout := wf_engine.eng_completed||':'||default_result;
1580: elsif (funcmode = wf_engine.eng_timeout) then
1581: -- If Timeout has occured then return result Timeout so the Timeout
1582: -- transition will occur - BUG2885157
1583: resultout := wf_engine.eng_completed||':'||wf_engine.eng_timeout;

Line 1580: elsif (funcmode = wf_engine.eng_timeout) then

1576: elsif (default_result is not null) then
1577: -- Either timeout or all notifications closed
1578: -- Return default result if one found.
1579: resultout := wf_engine.eng_completed||':'||default_result;
1580: elsif (funcmode = wf_engine.eng_timeout) then
1581: -- If Timeout has occured then return result Timeout so the Timeout
1582: -- transition will occur - BUG2885157
1583: resultout := wf_engine.eng_completed||':'||wf_engine.eng_timeout;
1584: else

Line 1583: resultout := wf_engine.eng_completed||':'||wf_engine.eng_timeout;

1579: resultout := wf_engine.eng_completed||':'||default_result;
1580: elsif (funcmode = wf_engine.eng_timeout) then
1581: -- If Timeout has occured then return result Timeout so the Timeout
1582: -- transition will occur - BUG2885157
1583: resultout := wf_engine.eng_completed||':'||wf_engine.eng_timeout;
1584: else
1585: -- All notifications closed, and no default.
1586: -- Return nomatch
1587:

Line 1589: resultout := wf_engine.eng_completed||':'||wf_engine.eng_nomatch;

1585: -- All notifications closed, and no default.
1586: -- Return nomatch
1587:
1588:
1589: resultout := wf_engine.eng_completed||':'||wf_engine.eng_nomatch;
1590:
1591: end if;
1592: end if;
1593:

Line 1643: l_doc_id := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,

1639:
1640:
1641: /***** ERES: closeDocument ******/
1642:
1643: l_doc_id := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,
1644: itemkey => p_itemkey,
1645: aname => 'DOC_ID');
1646: l_Event_Key := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,
1647: itemkey => p_itemkey,

Line 1646: l_Event_Key := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,

1642:
1643: l_doc_id := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,
1644: itemkey => p_itemkey,
1645: aname => 'DOC_ID');
1646: l_Event_Key := wf_engine.GETITEMATTRNUMBER(itemtype => p_itemtype,
1647: itemkey => p_itemkey,
1648: aname => 'CHANGE_ID');
1649: QA_EDR_STANDARD.Close_Document (
1650: p_api_version => 1.0,