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

Line 90: wf_engine.CreateProcess( ItemType => ItemType,

86:
87: --
88: -- Start Process :
89: --
90: wf_engine.CreateProcess( ItemType => ItemType,
91: ItemKey => ItemKey,
92: process => WorkflowProcess );
93:
94: wf_engine.SetItemUserKey ( ItemType => ItemType,

Line 94: wf_engine.SetItemUserKey ( ItemType => ItemType,

90: wf_engine.CreateProcess( ItemType => ItemType,
91: ItemKey => ItemKey,
92: process => WorkflowProcess );
93:
94: wf_engine.SetItemUserKey ( ItemType => ItemType,
95: ItemKey => ItemKey,
96: UserKey => ItemUserKey);
97: --
98: -- Initialize workflow item attributes

Line 100: wf_engine.SetItemAttrNumber (itemtype => itemtype,

96: UserKey => ItemUserKey);
97: --
98: -- Initialize workflow item attributes
99: --
100: wf_engine.SetItemAttrNumber (itemtype => itemtype,
101: itemkey => itemkey,
102: aname => 'AMV_CHANNEL_ID',
103: avalue => ChannelId);
104: --

Line 105: wf_engine.SetItemAttrText ( itemtype => itemtype,

101: itemkey => itemkey,
102: aname => 'AMV_CHANNEL_ID',
103: avalue => ChannelId);
104: --
105: wf_engine.SetItemAttrText ( itemtype => itemtype,
106: itemkey => itemkey,
107: aname => 'AMV_CHANNEL_NAME',
108: avalue => l_channel_name);
109: --

Line 110: wf_engine.SetItemAttrNumber (itemtype => itemtype,

106: itemkey => itemkey,
107: aname => 'AMV_CHANNEL_NAME',
108: avalue => l_channel_name);
109: --
110: wf_engine.SetItemAttrNumber (itemtype => itemtype,
111: itemkey => itemkey,
112: aname => 'AMV_REQUESTOR_ID',
113: avalue => RequestorId);
114: --

Line 115: wf_engine.SetItemAttrText ( itemtype => itemtype,

111: itemkey => itemkey,
112: aname => 'AMV_REQUESTOR_ID',
113: avalue => RequestorId);
114: --
115: wf_engine.SetItemAttrText ( itemtype => itemtype,
116: itemkey => itemkey,
117: aname => 'AMV_REQUESTOR',
118: avalue => l_requestor);
119: --

Line 120: wf_engine.SetItemAttrNumber (itemtype => itemtype,

116: itemkey => itemkey,
117: aname => 'AMV_REQUESTOR',
118: avalue => l_requestor);
119: --
120: wf_engine.SetItemAttrNumber (itemtype => itemtype,
121: itemkey => itemkey,
122: aname => 'AMV_ITEM_ID',
123: avalue => ItemId);
124: --

Line 125: wf_engine.SetItemAttrText ( itemtype => itemtype,

121: itemkey => itemkey,
122: aname => 'AMV_ITEM_ID',
123: avalue => ItemId);
124: --
125: wf_engine.SetItemAttrText ( itemtype => itemtype,
126: itemkey => itemkey,
127: aname => 'AMV_ITEM_NAME',
128: avalue => l_item_name);
129: --

Line 130: wf_engine.SetItemAttrNumber (itemtype => itemtype,

126: itemkey => itemkey,
127: aname => 'AMV_ITEM_NAME',
128: avalue => l_item_name);
129: --
130: wf_engine.SetItemAttrNumber (itemtype => itemtype,
131: itemkey => itemkey,
132: aname => 'AMV_TIMEOUT',
133: avalue => Timeout);
134: --

Line 135: wf_engine.SetItemAttrText ( itemtype => itemtype,

131: itemkey => itemkey,
132: aname => 'AMV_TIMEOUT',
133: avalue => Timeout);
134: --
135: wf_engine.SetItemAttrText ( itemtype => itemtype,
136: itemkey => itemkey,
137: aname => 'AMV_WORKFLOW_PROCESS',
138: avalue => WorkflowProcess);
139:

Line 141: wf_engine.SetItemOwner ( itemtype => itemtype,

137: aname => 'AMV_WORKFLOW_PROCESS',
138: avalue => WorkflowProcess);
139:
140: --
141: wf_engine.SetItemOwner ( itemtype => itemtype,
142: itemkey => itemkey,
143: owner => ProcessOwner );
144:
145: --

Line 146: wf_engine.StartProcess( itemtype => itemtype,

142: itemkey => itemkey,
143: owner => ProcessOwner );
144:
145: --
146: wf_engine.StartProcess( itemtype => itemtype,
147: itemkey => itemkey );
148: --
149: EXCEPTION
150: WHEN OTHERS THEN

Line 302: l_channel_id := wf_engine.GetItemAttrNumber(

298: --
299: -- RUN mode - normal process execution
300: --
301: IF (funcmode = 'RUN') THEN
302: l_channel_id := wf_engine.GetItemAttrNumber(
303: itemtype => itemtype,
304: itemkey => itemkey,
305: aname => 'AMV_CHANNEL_ID' );
306:

Line 307: l_requestor_id := wf_engine.GetItemAttrNumber(

303: itemtype => itemtype,
304: itemkey => itemkey,
305: aname => 'AMV_CHANNEL_ID' );
306:
307: l_requestor_id := wf_engine.GetItemAttrNumber(
308: itemtype => itemtype,
309: itemkey => itemkey,
310: aname => 'AMV_REQUESTOR_ID' );
311:

Line 325: resultout := wf_engine.eng_completed||':Y';

321: x_result_flag => l_setup_result
322: );
323:
324: IF l_setup_result = FND_API.G_TRUE THEN
325: resultout := wf_engine.eng_completed||':Y';
326: ELSE
327: OPEN Chn_Publish;
328: FETCH Chn_Publish INTO l_publish_flag;
329: CLOSE Chn_Publish;

Line 333: resultout := wf_engine.eng_completed||':Y';

329: CLOSE Chn_Publish;
330:
331: IF l_publish_flag = FND_API.G_TRUE THEN
332: IF Is_ChannelApprover(l_channel_id, l_requestor_id) THEN
333: resultout := wf_engine.eng_completed||':Y';
334: ELSE
335: OPEN Chn_Access;
336: FETCH Chn_Access INTO l_create_flag;
337: CLOSE Chn_Access;

Line 340: resultout := wf_engine.eng_completed||':Y';

336: FETCH Chn_Access INTO l_create_flag;
337: CLOSE Chn_Access;
338:
339: IF l_create_flag = FND_API.G_TRUE THEN
340: resultout := wf_engine.eng_completed||':Y';
341: ELSE
342: resultout := wf_engine.eng_completed||':N';
343: END IF;
344: END IF;

Line 342: resultout := wf_engine.eng_completed||':N';

338:
339: IF l_create_flag = FND_API.G_TRUE THEN
340: resultout := wf_engine.eng_completed||':Y';
341: ELSE
342: resultout := wf_engine.eng_completed||':N';
343: END IF;
344: END IF;
345: ELSE
346: resultout := wf_engine.eng_completed||':Y';

Line 346: resultout := wf_engine.eng_completed||':Y';

342: resultout := wf_engine.eng_completed||':N';
343: END IF;
344: END IF;
345: ELSE
346: resultout := wf_engine.eng_completed||':Y';
347: END IF;
348: END IF;
349: --
350:

Line 432: l_channel_id := wf_engine.GetItemAttrNumber(

428: --
429: -- RUN mode - normal process execution
430: --
431: IF (funcmode = 'RUN') THEN
432: l_channel_id := wf_engine.GetItemAttrNumber(
433: itemtype => itemtype,
434: itemkey => itemkey,
435: aname => 'AMV_CHANNEL_ID' );
436:

Line 437: l_requestor_id := wf_engine.GetItemAttrNumber(

433: itemtype => itemtype,
434: itemkey => itemkey,
435: aname => 'AMV_CHANNEL_ID' );
436:
437: l_requestor_id := wf_engine.GetItemAttrNumber(
438: itemtype => itemtype,
439: itemkey => itemkey,
440: aname => 'AMV_REQUESTOR_ID' );
441:

Line 448: resultout := wf_engine.eng_completed||':Y';

444: CLOSE Chn_Subscribe;
445:
446: IF l_subscribe_flag = FND_API.G_TRUE THEN
447: IF Is_ChannelApprover(l_channel_id, l_requestor_id) THEN
448: resultout := wf_engine.eng_completed||':Y';
449: ELSE
450: OPEN Chn_Access;
451: FETCH Chn_Access INTO l_view_flag;
452: CLOSE Chn_Access;

Line 455: resultout := wf_engine.eng_completed||':Y';

451: FETCH Chn_Access INTO l_view_flag;
452: CLOSE Chn_Access;
453:
454: IF l_view_flag = FND_API.G_TRUE THEN
455: resultout := wf_engine.eng_completed||':Y';
456: ELSE
457: resultout := wf_engine.eng_completed||':N';
458: END IF;
459: END IF;

Line 457: resultout := wf_engine.eng_completed||':N';

453:
454: IF l_view_flag = FND_API.G_TRUE THEN
455: resultout := wf_engine.eng_completed||':Y';
456: ELSE
457: resultout := wf_engine.eng_completed||':N';
458: END IF;
459: END IF;
460: ELSE
461: resultout := wf_engine.eng_completed||':Y';

Line 461: resultout := wf_engine.eng_completed||':Y';

457: resultout := wf_engine.eng_completed||':N';
458: END IF;
459: END IF;
460: ELSE
461: resultout := wf_engine.eng_completed||':Y';
462: END IF;
463: --
464:
465: --

Line 622: l_channel_id := wf_engine.GetItemAttrNumber(

618: --
619: -- RUN mode - normal process execution
620: --
621: IF (funcmode = 'RUN') THEN
622: l_channel_id := wf_engine.GetItemAttrNumber(
623: itemtype => itemtype,
624: itemkey => itemkey,
625: aname => 'AMV_CHANNEL_ID' );
626:

Line 627: l_requestor_id := wf_engine.GetItemAttrNumber(

623: itemtype => itemtype,
624: itemkey => itemkey,
625: aname => 'AMV_CHANNEL_ID' );
626:
627: l_requestor_id := wf_engine.GetItemAttrNumber(
628: itemtype => itemtype,
629: itemkey => itemkey,
630: aname => 'AMV_REQUESTOR_ID' );
631:

Line 632: l_item_id := wf_engine.GetItemAttrNumber(

628: itemtype => itemtype,
629: itemkey => itemkey,
630: aname => 'AMV_REQUESTOR_ID' );
631:
632: l_item_id := wf_engine.GetItemAttrNumber(
633: itemtype => itemtype,
634: itemkey => itemkey,
635: aname => 'AMV_ITEM_ID' );
636:

Line 637: l_channel_name := wf_engine.GetItemAttrText(

633: itemtype => itemtype,
634: itemkey => itemkey,
635: aname => 'AMV_ITEM_ID' );
636:
637: l_channel_name := wf_engine.GetItemAttrText(
638: itemtype => itemtype,
639: itemkey => itemkey,
640: aname => 'AMV_CHANNEL_NAME' );
641:

Line 642: l_item_name := wf_engine.GetItemAttrText(

638: itemtype => itemtype,
639: itemkey => itemkey,
640: aname => 'AMV_CHANNEL_NAME' );
641:
642: l_item_name := wf_engine.GetItemAttrText(
643: itemtype => itemtype,
644: itemkey => itemkey,
645: aname => 'AMV_ITEM_NAME' );
646:

Line 647: l_comments := wf_engine.GetItemAttrText(

643: itemtype => itemtype,
644: itemkey => itemkey,
645: aname => 'AMV_ITEM_NAME' );
646:
647: l_comments := wf_engine.GetItemAttrText(
648: itemtype => itemtype,
649: itemkey => itemkey,
650: aname => 'AMV_COMMENTS' );
651:

Line 652: l_forward_to_usertype := wf_engine.GetItemAttrText(

648: itemtype => itemtype,
649: itemkey => itemkey,
650: aname => 'AMV_COMMENTS' );
651:
652: l_forward_to_usertype := wf_engine.GetItemAttrText(
653: itemtype => itemtype,
654: itemkey => itemkey,
655: aname => 'AMV_FORWARD_TO_USERTYPE' );
656:

Line 657: l_timeout := wf_engine.GetItemAttrNumber(

653: itemtype => itemtype,
654: itemkey => itemkey,
655: aname => 'AMV_FORWARD_TO_USERTYPE' );
656:
657: l_timeout := wf_engine.GetItemAttrNumber(
658: itemtype => itemtype,
659: itemkey => itemkey,
660: aname => 'AMV_TIMEOUT' );
661:

Line 662: l_workflow_process := wf_engine.GetItemAttrText(

658: itemtype => itemtype,
659: itemkey => itemkey,
660: aname => 'AMV_TIMEOUT' );
661:
662: l_workflow_process := wf_engine.GetItemAttrText(
663: itemtype => itemtype,
664: itemkey => itemkey,
665: aname => 'AMV_WORKFLOW_PROCESS' );
666:

Line 691: wf_engine.SetItemAttrText (

687: l_role_name := l_forward_to_username;
688: END IF;
689:
690: -- NOTE perform a check to validate role creation
691: wf_engine.SetItemAttrText (
692: itemtype=> itemtype,
693: itemkey => itemkey,
694: aname => 'AMV_CHANNEL_APPROVER',
695: avalue => l_role_name);

Line 697: wf_engine.SetItemAttrText (

693: itemkey => itemkey,
694: aname => 'AMV_CHANNEL_APPROVER',
695: avalue => l_role_name);
696: --
697: wf_engine.SetItemAttrText (
698: itemtype=> itemtype,
699: itemkey => itemkey,
700: aname => 'AMV_FORWARD_TO_USERNAME',
701: avalue => l_forward_to_username);

Line 727: wf_engine.SetItemAttrText (

723: --
724: END IF;
725: --
726: --
727: wf_engine.SetItemAttrText (
728: itemtype => itemtype,
729: itemkey => itemkey,
730: aname => 'AMV_FORWARD_TO_USERTYPE',
731: avalue => l_forward_to_usertype);

Line 813: if (funcmode <> wf_engine.eng_run) then

809:
810: BEGIN
811:
812: -- Do nothing in cancel mode
813: if (funcmode <> wf_engine.eng_run) then
814: resultout := wf_engine.eng_null;
815: return;
816: end if;
817:

Line 814: resultout := wf_engine.eng_null;

810: BEGIN
811:
812: -- Do nothing in cancel mode
813: if (funcmode <> wf_engine.eng_run) then
814: resultout := wf_engine.eng_null;
815: return;
816: end if;
817:
818: --

Line 821: IF (funcmode = wf_engine.eng_run) THEN

817:
818: --
819: -- RUN mode - normal process execution
820: --
821: IF (funcmode = wf_engine.eng_run) THEN
822: -- Get Notifications group_id for activity
823: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
824: l_group_id,l_user);
825: -- check for notification status and set AMV_PROCESS_ERROR to 'COMPLETE' if processing is done

Line 828: --resultout := wf_engine.eng_null;

824: l_group_id,l_user);
825: -- check for notification status and set AMV_PROCESS_ERROR to 'COMPLETE' if processing is done
826: for result_rec in result_codes loop
827: --if (process_completed(l_group_id)) then
828: --resultout := wf_engine.eng_null;
829: --return;
830: --else
831: resultout := wf_engine.eng_completed||':'||l_result_code;
832: return;

Line 831: resultout := wf_engine.eng_completed||':'||l_result_code;

827: --if (process_completed(l_group_id)) then
828: --resultout := wf_engine.eng_null;
829: --return;
830: --else
831: resultout := wf_engine.eng_completed||':'||l_result_code;
832: return;
833: --end if;
834: end loop;
835: END IF;

Line 889: l_approval_status := wf_engine.GetItemAttrText(

885: IF (funcmode = 'RUN') THEN
886: --
887: -- Return process to run
888: --
889: l_approval_status := wf_engine.GetItemAttrText(
890: itemtype => itemtype,
891: itemkey => itemkey,
892: aname => 'AMV_APPROVAL_STATUS' );
893:

Line 894: l_channel_id := wf_engine.GetItemAttrNumber(

890: itemtype => itemtype,
891: itemkey => itemkey,
892: aname => 'AMV_APPROVAL_STATUS' );
893:
894: l_channel_id := wf_engine.GetItemAttrNumber(
895: itemtype => itemtype,
896: itemkey => itemkey,
897: aname => 'AMV_CHANNEL_ID' );
898:

Line 899: l_item_id := wf_engine.GetItemAttrNumber(

895: itemtype => itemtype,
896: itemkey => itemkey,
897: aname => 'AMV_CHANNEL_ID' );
898:
899: l_item_id := wf_engine.GetItemAttrNumber(
900: itemtype => itemtype,
901: itemkey => itemkey,
902: aname => 'AMV_ITEM_ID' );
903:

Line 923: wf_engine.SetItemAttrText ( itemtype => itemtype,

919: p_approval_status => AMV_UTILITY_PVT.G_APPROVED);
920:
921: -- Check if api completes sucessfully
922: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
923: wf_engine.SetItemAttrText ( itemtype => itemtype,
924: itemkey => itemkey,
925: aname => 'AMV_APPROVAL_STATUS',
926: avalue => 'NOTIFIED');
927: resultout := 'COMPLETE:Y';

Line 931: wf_engine.SetItemAttrText ( itemtype => itemtype,

927: resultout := 'COMPLETE:Y';
928: return;
929: ELSE
930: --
931: wf_engine.SetItemAttrText ( itemtype => itemtype,
932: itemkey => itemkey,
933: aname => 'AMV_PROCESS_ERROR',
934: avalue => l_msg_data);
935: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 935: wf_engine.SetItemAttrText ( itemtype => itemtype,

931: wf_engine.SetItemAttrText ( itemtype => itemtype,
932: itemkey => itemkey,
933: aname => 'AMV_PROCESS_ERROR',
934: avalue => l_msg_data);
935: wf_engine.SetItemAttrText ( itemtype => itemtype,
936: itemkey => itemkey,
937: aname => 'AMV_APPROVAL_STATUS',
938: avalue => 'NOTIFIED');
939: resultout := 'COMPLETE:N';

Line 1017: l_approval_status := wf_engine.GetItemAttrText(

1013: IF (funcmode = 'RUN') THEN
1014: --
1015: -- Return process to run
1016: --
1017: l_approval_status := wf_engine.GetItemAttrText(
1018: itemtype => itemtype,
1019: itemkey => itemkey,
1020: aname => 'AMV_APPROVAL_STATUS' );
1021:

Line 1022: l_channel_id := wf_engine.GetItemAttrNumber(

1018: itemtype => itemtype,
1019: itemkey => itemkey,
1020: aname => 'AMV_APPROVAL_STATUS' );
1021:
1022: l_channel_id := wf_engine.GetItemAttrNumber(
1023: itemtype => itemtype,
1024: itemkey => itemkey,
1025: aname => 'AMV_CHANNEL_ID' );
1026:

Line 1027: l_requestor_id := wf_engine.GetItemAttrNumber(

1023: itemtype => itemtype,
1024: itemkey => itemkey,
1025: aname => 'AMV_CHANNEL_ID' );
1026:
1027: l_requestor_id := wf_engine.GetItemAttrNumber(
1028: itemtype => itemtype,
1029: itemkey => itemkey,
1030: aname => 'AMV_REQUESTOR_ID' );
1031:

Line 1074: wf_engine.SetItemAttrText ( itemtype => itemtype,

1070: p_mychannel_obj => l_mychannel_obj,
1071: x_mychannel_id => l_mychannel_id);
1072:
1073: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1074: wf_engine.SetItemAttrText ( itemtype => itemtype,
1075: itemkey => itemkey,
1076: aname => 'AMV_APPROVAL_STATUS',
1077: avalue => 'NOTIFIED');
1078: resultout := 'COMPLETE:Y';

Line 1082: wf_engine.SetItemAttrText ( itemtype => itemtype,

1078: resultout := 'COMPLETE:Y';
1079: return;
1080: ELSE
1081: --
1082: wf_engine.SetItemAttrText ( itemtype => itemtype,
1083: itemkey => itemkey,
1084: aname => 'AMV_PROCESS_ERROR',
1085: avalue => l_msg_data);
1086: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 1086: wf_engine.SetItemAttrText ( itemtype => itemtype,

1082: wf_engine.SetItemAttrText ( itemtype => itemtype,
1083: itemkey => itemkey,
1084: aname => 'AMV_PROCESS_ERROR',
1085: avalue => l_msg_data);
1086: wf_engine.SetItemAttrText ( itemtype => itemtype,
1087: itemkey => itemkey,
1088: aname => 'AMV_APPROVAL_STATUS',
1089: avalue => 'NOTIFIED');
1090: resultout := 'COMPLETE:N';

Line 1163: l_approval_status := wf_engine.GetItemAttrText(

1159: IF (funcmode = 'RUN') THEN
1160: --
1161: -- Return process to run
1162: --
1163: l_approval_status := wf_engine.GetItemAttrText(
1164: itemtype => itemtype,
1165: itemkey => itemkey,
1166: aname => 'AMV_APPROVAL_STATUS' );
1167:

Line 1168: l_channel_id := wf_engine.GetItemAttrNumber(

1164: itemtype => itemtype,
1165: itemkey => itemkey,
1166: aname => 'AMV_APPROVAL_STATUS' );
1167:
1168: l_channel_id := wf_engine.GetItemAttrNumber(
1169: itemtype => itemtype,
1170: itemkey => itemkey,
1171: aname => 'AMV_CHANNEL_ID' );
1172:

Line 1173: l_item_id := wf_engine.GetItemAttrNumber(

1169: itemtype => itemtype,
1170: itemkey => itemkey,
1171: aname => 'AMV_CHANNEL_ID' );
1172:
1173: l_item_id := wf_engine.GetItemAttrNumber(
1174: itemtype => itemtype,
1175: itemkey => itemkey,
1176: aname => 'AMV_ITEM_ID' );
1177:

Line 1195: wf_engine.SetItemAttrText ( itemtype => itemtype,

1191: p_item_id => l_item_id,
1192: p_approval_status => AMV_UTILITY_PVT.G_REJECTED);
1193:
1194: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1195: wf_engine.SetItemAttrText ( itemtype => itemtype,
1196: itemkey => itemkey,
1197: aname => 'AMV_APPROVAL_STATUS',
1198: avalue => 'NOTIFIED');
1199: resultout := 'COMPLETE:Y';

Line 1203: wf_engine.SetItemAttrText ( itemtype => itemtype,

1199: resultout := 'COMPLETE:Y';
1200: return;
1201: ELSE
1202: --
1203: wf_engine.SetItemAttrText ( itemtype => itemtype,
1204: itemkey => itemkey,
1205: aname => 'AMV_PROCESS_ERROR',
1206: avalue => l_msg_data);
1207: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 1207: wf_engine.SetItemAttrText ( itemtype => itemtype,

1203: wf_engine.SetItemAttrText ( itemtype => itemtype,
1204: itemkey => itemkey,
1205: aname => 'AMV_PROCESS_ERROR',
1206: avalue => l_msg_data);
1207: wf_engine.SetItemAttrText ( itemtype => itemtype,
1208: itemkey => itemkey,
1209: aname => 'AMV_APPROVAL_STATUS',
1210: avalue => 'NOTIFIED');
1211: resultout := 'COMPLETE:N';