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

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

68: -- - DEFERED
69: -- execution should be defered to background
70: -- - NOTIFIED[::]
71: -- activity has notified an external entity that this
72: -- step must be performed. A call to wf_engine.CompleteActivty
73: -- will signal when this step is complete. Optional
74: -- return of notification ID and assigned user.
75: -- - ERROR[:]
76: -- function encountered an error.

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

92: -- RUN mode - normal process execution
93: --
94: if (funcmode = 'RUN') then
95:
96: wf_engine.SetItemAttrText( itemtype => itemtype,
97: itemkey => itemkey,
98: aname => 'AME_PROCESS_STATUS',
99: avalue => 'INPROCESS');
100:

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

97: itemkey => itemkey,
98: aname => 'AME_PROCESS_STATUS',
99: avalue => 'INPROCESS');
100:
101: wf_engine.SetItemAttrText( itemtype => itemtype,
102: itemkey => itemkey,
103: aname => 'APPROVER_RESPONSE',
104: avalue => 'NORESPONSE');
105:

Line 114: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

110: END IF;
111: end if;
112:
113: -- no result needed
114: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
115: return;
116: end if;
117:
118:

Line 125: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

121: --
122: if (funcmode = 'CANCEL') then
123:
124: -- no result needed
125: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
126: return;
127: end if;
128:
129: --

Line 134: resultout := wf_engine.eng_null;

130: -- Other execution modes may be created in the future. Your
131: -- activity will indicate that it does not implement a mode
132: -- by returning null
133: --
134: resultout := wf_engine.eng_null;
135: return;
136:
137: exception
138: when others then

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

186: --
187: if (funcmode = 'RUN') then
188:
189:
190: wf_engine.SetItemAttrText ( itemtype => itemtype,
191: itemkey => itemkey,
192: aname => 'AME_PROCESS_STATUS',
193: avalue => 'REJECTED');
194:

Line 209: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

205: -- Other execution modes may be created in the future. Your
206: -- activity will indicate that it does not implement a mode
207: -- by returning null
208: --
209: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
210: return;
211:
212: exception
213: when others then

Line 274: resultout := wf_engine.eng_completed||':'||l_profile_value;

270: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
271: END IF;
272: end if;
273:
274: resultout := wf_engine.eng_completed||':'||l_profile_value;
275:
276:
277: wf_engine.SetItemAttrText ( itemtype => itemtype,
278: itemkey => itemkey,

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

273:
274: resultout := wf_engine.eng_completed||':'||l_profile_value;
275:
276:
277: wf_engine.SetItemAttrText ( itemtype => itemtype,
278: itemkey => itemkey,
279: aname => 'AME_ENABLED',
280: avalue => l_profile_value);
281: l_progress := 2;

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

280: avalue => l_profile_value);
281: l_progress := 2;
282:
283: if (l_profile_value = 'N') then
284: wf_engine.SetItemAttrText ( itemtype => itemtype,
285: itemkey => itemkey,
286: aname => 'AME_PROCESS_STATUS',
287: avalue => 'NOAME');
288: end if;

Line 301: resultout := wf_engine.eng_null;

297: return;
298:
299: end if;
300:
301: resultout := wf_engine.eng_null;
302: return;
303:
304: exception
305: when others then

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

379: --
380: if (funcmode = 'RUN') then
381:
382:
383: wf_engine.SetItemAttrText ( itemtype => itemtype,
384: itemkey => itemkey,
385: aname => 'APPROVER_RESPONSE',
386: avalue => 'NORESPONSE');
387:

Line 389: resultout := wf_engine.eng_completed||':'||'VALID_NEXT_APPROVER';

385: aname => 'APPROVER_RESPONSE',
386: avalue => 'NORESPONSE');
387:
388:
389: resultout := wf_engine.eng_completed||':'||'VALID_NEXT_APPROVER';
390:
391: -- ame_api2.clearAllApprovals( applicationIdIn=>177,
392: -- transactionTypeIn=>'POS_SUPP_APPR',
393: -- transactionIdIn=>itemkey);

Line 412: resultout := wf_engine.eng_completed||':'||'NO_NEXT_APPROVER';

408: end if;
409:
410: if (l_completeYNO = 'Y') then
411:
412: resultout := wf_engine.eng_completed||':'||'NO_NEXT_APPROVER';
413:
414: wf_engine.SetItemAttrText ( itemtype => itemtype,
415: itemkey => itemkey,
416: aname => 'AME_PROCESS_STATUS',

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

410: if (l_completeYNO = 'Y') then
411:
412: resultout := wf_engine.eng_completed||':'||'NO_NEXT_APPROVER';
413:
414: wf_engine.SetItemAttrText ( itemtype => itemtype,
415: itemkey => itemkey,
416: aname => 'AME_PROCESS_STATUS',
417: avalue => 'APPROVED');
418:

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

495: END IF;
496: end if;
497:
498:
499: wf_engine.SetItemAttrText ( itemtype => itemtype,
500: itemkey => itemkey,
501: aname => 'APPROVER_USER_NAME',
502: avalue => l_next_approver_user_name);
503:

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

501: aname => 'APPROVER_USER_NAME',
502: avalue => l_next_approver_user_name);
503:
504:
505: wf_engine.SetItemAttrText ( itemtype => itemtype,
506: itemkey => itemkey,
507: aname => 'APPROVER_DISPLAY_NAME',
508: avalue => l_next_approver_disp_name);
509:

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

506: itemkey => itemkey,
507: aname => 'APPROVER_DISPLAY_NAME',
508: avalue => l_next_approver_disp_name);
509:
510: wf_engine.SetItemAttrText ( itemtype => itemtype,
511: itemkey => itemkey,
512: aname => 'AME_APPROVER_ID',
513: avalue => g_next_approvers(l_approver_index).orig_system_id);
514:

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

511: itemkey => itemkey,
512: aname => 'AME_APPROVER_ID',
513: avalue => g_next_approvers(l_approver_index).orig_system_id);
514:
515: wf_engine.SetItemAttrText ( itemtype => itemtype,
516: itemkey => itemkey,
517: aname => 'APPROVER_EMPID',
518: avalue => l_next_approver_id);
519:

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

516: itemkey => itemkey,
517: aname => 'APPROVER_EMPID',
518: avalue => l_next_approver_id);
519:
520: wf_engine.SetItemAttrText ( itemtype => itemtype,
521: itemkey => itemkey,
522: aname => 'APPROVAL_GROUP_ID',
523: avalue => g_next_approvers(l_approver_index).group_or_chain_id);
524:

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

521: itemkey => itemkey,
522: aname => 'APPROVAL_GROUP_ID',
523: avalue => g_next_approvers(l_approver_index).group_or_chain_id);
524:
525: wf_engine.SetItemAttrText ( itemtype => itemtype,
526: itemkey => itemkey,
527: aname => 'AME_APPROVER_TYPE',
528: avalue => g_next_approvers(l_approver_index).orig_system);
529:

Line 553: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

549: --
550: if (funcmode = 'CANCEL') then
551:
552: -- no result needed
553: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
554: return;
555: end if;
556:
557: --

Line 562: resultout := wf_engine.eng_null;

558: -- Other execution modes may be created in the future. Your
559: -- activity will indicate that it does not implement a mode
560: -- by returning null
561: --
562: resultout := wf_engine.eng_null;
563: return;
564:
565: exception
566: when others then

Line 624: wf_approver := wf_engine.GetItemAttrText(itemtype => wfItemType,

620: status := 'E';
621: return;
622: end if;
623:
624: wf_approver := wf_engine.GetItemAttrText(itemtype => wfItemType,
625: itemkey => suppid,
626: aname => 'APPROVER_USER_NAME');
627:
628: wf_approver_response := wf_engine.GetItemAttrText(itemtype => wfItemType,

Line 628: wf_approver_response := wf_engine.GetItemAttrText(itemtype => wfItemType,

624: wf_approver := wf_engine.GetItemAttrText(itemtype => wfItemType,
625: itemkey => suppid,
626: aname => 'APPROVER_USER_NAME');
627:
628: wf_approver_response := wf_engine.GetItemAttrText(itemtype => wfItemType,
629: itemkey => suppid,
630: aname => 'APPROVER_RESPONSE');
631:
632: l_progress := 'GET_APPROVER_IN_WF: 002 WF attribute APPROVER_USER_NAME - '||wf_approver ||

Line 730: wf_approver := wf_engine.GetItemAttrText(itemtype => wfItemType,

726: resultout => result);
727:
728: --end fix
729:
730: wf_approver := wf_engine.GetItemAttrText(itemtype => wfItemType,
731: itemkey => suppid,
732: aname => 'APPROVER_USER_NAME');
733:
734: wf_approver_response := wf_engine.GetItemAttrText(itemtype => wfItemType,

Line 734: wf_approver_response := wf_engine.GetItemAttrText(itemtype => wfItemType,

730: wf_approver := wf_engine.GetItemAttrText(itemtype => wfItemType,
731: itemkey => suppid,
732: aname => 'APPROVER_USER_NAME');
733:
734: wf_approver_response := wf_engine.GetItemAttrText(itemtype => wfItemType,
735: itemkey => suppid,
736: aname => 'APPROVER_RESPONSE');
737:
738: l_progress := 'CHECK_IF_APPROVER: 003 WF attribute APPROVER_USER_NAME - '||wf_approver ||

Line 788: process_status := wf_engine.GetItemAttrText(itemtype => wfItemType,

784: begin
785:
786: l_progress := 'GET_AME_PROCESS_STATUS: 001';
787:
788: process_status := wf_engine.GetItemAttrText(itemtype => wfItemType,
789: itemkey => suppid,
790: aname => 'AME_PROCESS_STATUS');
791:
792: result := process_status;

Line 842: wf_approver := wf_engine.GetItemAttrText(itemtype => wfItemType,

838: begin
839:
840: l_progress := 'PROCESS_APPROVE: 001';
841:
842: wf_approver := wf_engine.GetItemAttrText(itemtype => wfItemType,
843: itemkey => suppid,
844: aname => 'APPROVER_USER_NAME');
845:
846: l_progress := 'PROCESS_APPROVE: 002 username - '||approver||' approver in WF - '||wf_approver;

Line 856: wf_engine.SetItemAttrText ( itemtype => wfItemType,

852: end if;
853:
854: if wf_approver = approver
855: then
856: wf_engine.SetItemAttrText ( itemtype => wfItemType,
857: itemkey => suppid,
858: aname => 'APPROVER_RESPONSE',
859: avalue => 'APPROVE');
860:

Line 879: wf_engine.CompleteActivity( itemtype => wfItemType,

875: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
876: END IF;
877: end if;
878:
879: wf_engine.CompleteActivity( itemtype => wfItemType,
880: itemkey => suppid,
881: activity => 'BLOCK',
882: result => null);
883:

Line 961: wf_approver := wf_engine.GetItemAttrText(itemtype => wfItemType,

957: begin
958:
959: l_progress := 'PROCESS_REJECT: 001';
960:
961: wf_approver := wf_engine.GetItemAttrText(itemtype => wfItemType,
962: itemkey => suppid,
963: aname => 'APPROVER_USER_NAME');
964:
965: l_progress := 'PROCESS_REJECT: 002 username - '||approver||' approver in WF - '||wf_approver;

Line 975: wf_engine.SetItemAttrText ( itemtype => wfItemType,

971: end if;
972:
973: if wf_approver = approver
974: then
975: wf_engine.SetItemAttrText ( itemtype => wfItemType,
976: itemkey => suppid,
977: aname => 'APPROVER_RESPONSE',
978: avalue => 'REJECT');
979:

Line 1000: wf_engine.CompleteActivity( itemtype => wfItemType,

996: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
997: END IF;
998: end if;
999:
1000: wf_engine.CompleteActivity( itemtype => wfItemType,
1001: itemkey => suppid,
1002: activity => 'BLOCK',
1003: result => null);
1004:

Line 1121: l_transaction_type := wf_engine.GetItemAttrText( itemtype => wfItemType,

1117: -- IF (g_po_wf_debug = 'Y') THEN
1118: -- PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1119: --END IF;
1120:
1121: l_transaction_type := wf_engine.GetItemAttrText( itemtype => wfItemType,
1122: itemkey => suppid,
1123: aname => 'AME_TRANSACTION_TYPE');
1124:
1125: l_approver_type := wf_engine.GetItemAttrText( itemtype => wfItemType,

Line 1125: l_approver_type := wf_engine.GetItemAttrText( itemtype => wfItemType,

1121: l_transaction_type := wf_engine.GetItemAttrText( itemtype => wfItemType,
1122: itemkey => suppid,
1123: aname => 'AME_TRANSACTION_TYPE');
1124:
1125: l_approver_type := wf_engine.GetItemAttrText( itemtype => wfItemType,
1126: itemkey => suppid,
1127: aname => 'AME_APPROVER_TYPE');
1128:
1129: l_progress := 'Process_Response_Internal: 002 -- l_approver_type :' || l_approver_type ;

Line 1146: l_current_approver.name := wf_engine.GetItemAttrText( itemtype => wfItemType,

1142: elsif (l_approver_type = 'FND') then
1143: l_current_approver.orig_system := 'FND';
1144: else
1145: l_current_approver.orig_system := 'PER';
1146: l_current_approver.name := wf_engine.GetItemAttrText( itemtype => wfItemType,
1147: itemkey => suppid,
1148: aname => 'APPROVER_USER_NAME');
1149: end if;
1150:

Line 1151: l_current_approver.name := wf_engine.GetItemAttrText( itemtype => wfItemType,

1147: itemkey => suppid,
1148: aname => 'APPROVER_USER_NAME');
1149: end if;
1150:
1151: l_current_approver.name := wf_engine.GetItemAttrText( itemtype => wfItemType,
1152: itemkey => suppid,
1153: aname => 'APPROVER_USER_NAME');
1154:
1155: l_current_approver.orig_system_id := wf_engine.GetItemAttrNumber( itemtype => wfItemType,

Line 1155: l_current_approver.orig_system_id := wf_engine.GetItemAttrNumber( itemtype => wfItemType,

1151: l_current_approver.name := wf_engine.GetItemAttrText( itemtype => wfItemType,
1152: itemkey => suppid,
1153: aname => 'APPROVER_USER_NAME');
1154:
1155: l_current_approver.orig_system_id := wf_engine.GetItemAttrNumber( itemtype => wfItemType,
1156: itemkey => suppid,
1157: aname => 'AME_APPROVER_ID');
1158: */
1159: --start replace

Line 1162: l_current_approver.name := 'POS:'||wf_engine.GetItemAttrText( itemtype => wfItemType,

1158: */
1159: --start replace
1160: if (l_approver_type = 'POS') then
1161: l_current_approver.orig_system := 'POS';
1162: l_current_approver.name := 'POS:'||wf_engine.GetItemAttrText( itemtype => wfItemType,
1163: itemkey => suppid,
1164: aname => 'AME_APPROVER_ID');
1165: elsif (l_approver_type = 'FND') then
1166: l_current_approver.orig_system := 'FND';

Line 1167: l_current_approver.name := wf_engine.GetItemAttrText( itemtype => wfItemType,

1163: itemkey => suppid,
1164: aname => 'AME_APPROVER_ID');
1165: elsif (l_approver_type = 'FND') then
1166: l_current_approver.orig_system := 'FND';
1167: l_current_approver.name := wf_engine.GetItemAttrText( itemtype => wfItemType,
1168: itemkey => suppid,
1169: aname => 'APPROVER_USER_NAME');
1170: else
1171: l_current_approver.orig_system := 'PER';

Line 1172: l_current_approver.name := wf_engine.GetItemAttrText( itemtype => wfItemType,

1168: itemkey => suppid,
1169: aname => 'APPROVER_USER_NAME');
1170: else
1171: l_current_approver.orig_system := 'PER';
1172: l_current_approver.name := wf_engine.GetItemAttrText( itemtype => wfItemType,
1173: itemkey => suppid,
1174: aname => 'APPROVER_USER_NAME');
1175: end if;
1176:

Line 1177: l_current_approver.orig_system_id := wf_engine.GetItemAttrText( itemtype => wfItemType,

1173: itemkey => suppid,
1174: aname => 'APPROVER_USER_NAME');
1175: end if;
1176:
1177: l_current_approver.orig_system_id := wf_engine.GetItemAttrText( itemtype => wfItemType,
1178: itemkey => suppid,
1179: aname => 'AME_APPROVER_ID');
1180: --end replace
1181:

Line 1271: wf_engine.CreateProcess(itemtype => wfItemType,

1267: l_progress := 1;
1268:
1269: -- create workflow process
1270:
1271: wf_engine.CreateProcess(itemtype => wfItemType,
1272: itemkey => suppid, /*using suppid as the itemkey*/
1273: process => wfProcess);
1274:
1275:

Line 1278: wf_engine.SetItemAttrText (itemtype => wfItemType,

1274:
1275:
1276: l_progress := 2;
1277:
1278: wf_engine.SetItemAttrText (itemtype => wfItemType,
1279: itemkey => suppid,
1280: aname => 'REQUESTOR',
1281: avalue => requestor);
1282:

Line 1283: wf_engine.SetItemAttrText (itemtype => wfItemType,

1279: itemkey => suppid,
1280: aname => 'REQUESTOR',
1281: avalue => requestor);
1282:
1283: wf_engine.SetItemAttrText (itemtype => wfItemType,
1284: itemkey => suppid,
1285: aname => 'SUPPLIERNAME',
1286: avalue => suppname);
1287:

Line 1290: wf_engine.StartProcess(itemtype => wfItemType,

1286: avalue => suppname);
1287:
1288: l_progress := 3;
1289:
1290: wf_engine.StartProcess(itemtype => wfItemType,
1291: itemkey => suppid );
1292:
1293: l_progress := 4;
1294: