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

Line 71: l_object_id := wf_engine.getitemattrnumber(

67: fnd_msg_pub.initialize;
68:
69: l_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: l_object_id := wf_engine.getitemattrnumber(
72: itemtype => itemtype
73: ,itemkey => itemkey
74: ,aname => 'OBJECT_ID'
75: );

Line 192: wf_engine.setitemattrtext(

188:
189: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FW_SUBJECT');
190: l_subject := FND_MESSAGE.get || l_temp_subject;
191:
192: wf_engine.setitemattrtext(
193: itemtype => itemtype
194: ,itemkey => itemkey
195: ,aname => 'FORWARD_SUBJECT'
196: ,avalue => l_subject

Line 202: wf_engine.setitemattrtext(

198:
199: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APPR_SUBJECT');
200: l_subject := FND_MESSAGE.get || l_temp_subject;
201:
202: wf_engine.setitemattrtext(
203: itemtype => itemtype
204: ,itemkey => itemkey
205: ,aname => 'APPROVAL_SUBJECT'
206: ,avalue => l_subject

Line 212: wf_engine.setitemattrtext(

208:
209: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REJ_SUBJECT');
210: l_subject := FND_MESSAGE.get || l_temp_subject;
211:
212: wf_engine.setitemattrtext(
213: itemtype => itemtype
214: ,itemkey => itemkey
215: ,aname => 'REJECT_SUBJECT'
216: ,avalue => l_subject

Line 222: wf_engine.setitemattrtext(

218:
219: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_APVD_SUBJECT');
220: l_subject := FND_MESSAGE.get || l_temp_subject;
221:
222: wf_engine.setitemattrtext(
223: itemtype => itemtype
224: ,itemkey => itemkey
225: ,aname => 'APPROVED_SUBJECT'
226: ,avalue => l_subject

Line 232: wf_engine.setitemattrtext(

228:
229: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_FIN_SUBJECT');
230: l_subject := FND_MESSAGE.get || l_temp_subject;
231:
232: wf_engine.setitemattrtext(
233: itemtype => itemtype
234: ,itemkey => itemkey
235: ,aname => 'FINAL_SUBJECT'
236: ,avalue => l_subject

Line 242: wf_engine.setitemattrtext(

238:
239: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_REM_SUBJECT');
240: l_subject := FND_MESSAGE.get || l_temp_subject;
241:
242: wf_engine.setitemattrtext(
243: itemtype => itemtype
244: ,itemkey => itemkey
245: ,aname => 'REMIND_SUBJECT'
246: ,avalue => l_subject);

Line 251: wf_engine.setitemattrtext(

247:
248: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_ERR_SUBJECT');
249: l_subject := FND_MESSAGE.get || l_temp_subject;
250:
251: wf_engine.setitemattrtext(
252: itemtype => itemtype
253: ,itemkey => itemkey
254: ,aname => 'ERROR_SUBJECT'
255: ,avalue => l_subject

Line 258: wf_engine.setitemattrtext(

254: ,aname => 'ERROR_SUBJECT'
255: ,avalue => l_subject
256: );
257:
258: wf_engine.setitemattrtext(
259: itemtype => itemtype
260: ,itemkey => itemkey
261: ,aname => 'REQUESTER_NOTE'
262: ,avalue => l_requester_note

Line 280: wf_engine.setitemattrnumber(

276: );
277:
278: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
279:
280: wf_engine.setitemattrnumber(
281: itemtype => itemtype,
282: itemkey => itemkey,
283: aname => 'RULE_ID',
284: avalue => l_approval_rule_id

Line 287: wf_engine.setitemattrnumber(

283: aname => 'RULE_ID',
284: avalue => l_approval_rule_id
285: );
286:
287: wf_engine.setitemattrnumber(
288: itemtype => itemtype,
289: itemkey => itemkey,
290: aname => 'APPROVER_SEQ',
291: avalue => l_approver_seq

Line 381: l_object := wf_engine.getitemattrtext(

377: l_hyphen_pos1 := INSTR(document_id, ':');
378: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
379: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
380:
381: l_object := wf_engine.getitemattrtext(
382: itemtype => l_item_type
383: ,itemkey => l_item_key
384: ,aname => 'OBJECT_TYPE'
385: );

Line 387: l_object_id := wf_engine.getitemattrNumber(

383: ,itemkey => l_item_key
384: ,aname => 'OBJECT_TYPE'
385: );
386:
387: l_object_id := wf_engine.getitemattrNumber(
388: itemtype => l_item_type
389: ,itemkey => l_item_key
390: ,aname => 'OBJECT_ID'
391: );

Line 401: l_approver := wf_engine.getitemattrtext(

397: 'Deferral Approval Request has been forwarded for unit_deferral_id : ' || l_object_id
398: );
399: END IF;
400:
401: l_approver := wf_engine.getitemattrtext(
402: itemtype => l_item_type
403: ,itemkey => l_item_key
404: ,aname => 'APPROVER'
405: );

Line 407: l_requester_note := wf_engine.getitemattrtext(

403: ,itemkey => l_item_key
404: ,aname => 'APPROVER'
405: );
406:
407: l_requester_note := wf_engine.getitemattrtext(
408: itemtype => l_item_type
409: ,itemkey => l_item_key
410: ,aname => 'REQUESTER_NOTE'
411: );

Line 493: l_object := wf_engine.getitemattrtext(

489: l_hyphen_pos1 := INSTR(document_id, ':');
490: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
491: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
492:
493: l_object := wf_engine.getitemattrtext(
494: itemtype => l_item_type
495: ,itemkey => l_item_key
496: ,aname => 'OBJECT_TYPE'
497: );

Line 499: l_object_id := wf_engine.getitemattrNumber(

495: ,itemkey => l_item_key
496: ,aname => 'OBJECT_TYPE'
497: );
498:
499: l_object_id := wf_engine.getitemattrNumber(
500: itemtype => l_item_type
501: ,itemkey => l_item_key
502: ,aname => 'OBJECT_ID'
503: );

Line 513: l_approver := wf_engine.getitemattrtext(

509: 'Sending FYI for approval of unit_deferral_id : ' || l_object_id
510: );
511: END IF;
512:
513: l_approver := wf_engine.getitemattrtext(
514: itemtype => l_item_type
515: ,itemkey => l_item_key
516: ,aname => 'APPROVER'
517: );

Line 519: l_requester_note := wf_engine.getitemattrtext(

515: ,itemkey => l_item_key
516: ,aname => 'APPROVER'
517: );
518:
519: l_requester_note := wf_engine.getitemattrtext(
520: itemtype => l_item_type
521: ,itemkey => l_item_key
522: ,aname => 'REQUESTER_NOTE'
523: );

Line 606: l_object := wf_engine.getitemattrtext(

602: l_hyphen_pos1 := INSTR(document_id, ':');
603: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
604: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
605:
606: l_object := wf_engine.getitemattrtext(
607: itemtype => l_item_type
608: ,itemkey => l_item_key
609: ,aname => 'OBJECT_TYPE'
610: );

Line 612: l_object_id := wf_engine.getitemattrNumber(

608: ,itemkey => l_item_key
609: ,aname => 'OBJECT_TYPE'
610: );
611:
612: l_object_id := wf_engine.getitemattrNumber(
613: itemtype => l_item_type
614: ,itemkey => l_item_key
615: ,aname => 'OBJECT_ID'
616: );

Line 626: l_requester_note := wf_engine.getitemattrtext(

622: 'Deferral finally approved for unit_deferral_id : ' || l_object_id
623: );
624: END IF;
625:
626: l_requester_note := wf_engine.getitemattrtext(
627: itemtype => l_item_type
628: ,itemkey => l_item_key
629: ,aname => 'REQUESTER_NOTE'
630: );

Line 713: l_object := wf_engine.getitemattrtext(

709: l_hyphen_pos1 := INSTR(document_id, ':');
710: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
711: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
712:
713: l_object := wf_engine.getitemattrtext(
714: itemtype => l_item_type
715: ,itemkey => l_item_key
716: ,aname => 'OBJECT_TYPE'
717: );

Line 719: l_object_id := wf_engine.getitemattrNumber(

715: ,itemkey => l_item_key
716: ,aname => 'OBJECT_TYPE'
717: );
718:
719: l_object_id := wf_engine.getitemattrNumber(
720: itemtype => l_item_type
721: ,itemkey => l_item_key
722: ,aname => 'OBJECT_ID'
723: );

Line 733: l_approver := wf_engine.getitemattrtext(

729: 'Sending FYI for Deferral Rejection of unit_deferral_id : ' || l_object_id
730: );
731: END IF;
732:
733: l_approver := wf_engine.getitemattrtext(
734: itemtype => l_item_type
735: ,itemkey => l_item_key
736: ,aname => 'APPROVER'
737: );

Line 739: l_requester_note := wf_engine.getitemattrtext(

735: ,itemkey => l_item_key
736: ,aname => 'APPROVER'
737: );
738:
739: l_requester_note := wf_engine.getitemattrtext(
740: itemtype => l_item_type
741: ,itemkey => l_item_key
742: ,aname => 'REQUESTER_NOTE'
743: );

Line 828: l_object := wf_engine.getitemattrtext(

824: l_hyphen_pos1 := INSTR(document_id, ':');
825: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
826: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
827:
828: l_object := wf_engine.getitemattrtext(
829: itemtype => l_item_type
830: ,itemkey => l_item_key
831: ,aname => 'OBJECT_TYPE'
832: );

Line 834: l_object_id := wf_engine.getitemattrNumber(

830: ,itemkey => l_item_key
831: ,aname => 'OBJECT_TYPE'
832: );
833:
834: l_object_id := wf_engine.getitemattrNumber(
835: itemtype => l_item_type
836: ,itemkey => l_item_key
837: ,aname => 'OBJECT_ID'
838: );

Line 848: l_requester := wf_engine.getitemattrtext(

844: 'Sending notfication to approver for unit_deferral_id : ' || l_object_id
845: );
846: END IF;
847:
848: l_requester := wf_engine.getitemattrtext(
849: itemtype => l_item_type
850: ,itemkey => l_item_key
851: ,aname => 'REQUESTER'
852: );

Line 854: l_requester_note := wf_engine.getitemattrtext(

850: ,itemkey => l_item_key
851: ,aname => 'REQUESTER'
852: );
853:
854: l_requester_note := wf_engine.getitemattrtext(
855: itemtype => l_item_type
856: ,itemkey => l_item_key
857: ,aname => 'REQUESTER_NOTE'
858: );

Line 945: l_object := wf_engine.getitemattrtext(

941: l_hyphen_pos1 := INSTR(document_id, ':');
942: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
943: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
944:
945: l_object := wf_engine.getitemattrtext(
946: itemtype => l_item_type
947: ,itemkey => l_item_key
948: ,aname => 'OBJECT_TYPE'
949: );

Line 951: l_object_id := wf_engine.getitemattrNumber(

947: ,itemkey => l_item_key
948: ,aname => 'OBJECT_TYPE'
949: );
950:
951: l_object_id := wf_engine.getitemattrNumber(
952: itemtype => l_item_type
953: ,itemkey => l_item_key
954: ,aname => 'OBJECT_ID'
955: );

Line 965: l_requester := wf_engine.getitemattrtext(

961: 'Sending reminder to approver for unit_deferral_id : ' || l_object_id
962: );
963: END IF;
964:
965: l_requester := wf_engine.getitemattrtext(
966: itemtype => l_item_type
967: ,itemkey => l_item_key
968: ,aname => 'REQUESTER'
969: );

Line 971: l_requester_note := wf_engine.getitemattrtext(

967: ,itemkey => l_item_key
968: ,aname => 'REQUESTER'
969: );
970:
971: l_requester_note := wf_engine.getitemattrtext(
972: itemtype => l_item_type
973: ,itemkey => l_item_key
974: ,aname => 'REQUESTER_NOTE'
975: );

Line 1058: l_object := wf_engine.getitemattrtext(

1054: l_hyphen_pos1 := INSTR(document_id, ':');
1055: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1056: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1057:
1058: l_object := wf_engine.getitemattrtext(
1059: itemtype => l_item_type
1060: ,itemkey => l_item_key
1061: ,aname => 'OBJECT_TYPE'
1062: );

Line 1064: l_object_id := wf_engine.getitemattrNumber(

1060: ,itemkey => l_item_key
1061: ,aname => 'OBJECT_TYPE'
1062: );
1063:
1064: l_object_id := wf_engine.getitemattrNumber(
1065: itemtype => l_item_type
1066: ,itemkey => l_item_key
1067: ,aname => 'OBJECT_ID'
1068: );

Line 1079: l_error_msg := wf_engine.getitemattrText(

1075: 'Error in approval workflow process for unit_deferral_id : ' || l_object_id
1076: );
1077: END IF;
1078:
1079: l_error_msg := wf_engine.getitemattrText(
1080: itemtype => l_item_type
1081: ,itemkey => l_item_key
1082: ,aname => 'ERROR_MSG'
1083: );

Line 1093: l_requester_note := wf_engine.getitemattrtext(

1089: 'ahl.plsql.AHL_PRD_DF_APPR_PVT.Ntf_Error_Act',
1090: 'Error Message : ' || l_error_msg
1091: );
1092: END IF;
1093: l_requester_note := wf_engine.getitemattrtext(
1094: itemtype => l_item_type
1095: ,itemkey => l_item_key
1096: ,aname => 'REQUESTER_NOTE'
1097: );

Line 1188: l_approval_status := wf_engine.getitemattrtext(

1184: l_return_status := FND_API.G_RET_STS_SUCCESS;
1185:
1186: IF (funcmode = 'RUN') THEN
1187:
1188: l_approval_status := wf_engine.getitemattrtext(
1189: itemtype => itemtype,
1190: itemkey => itemkey,
1191: aname => 'UPDATE_GEN_STATUS'
1192: );

Line 1194: l_object_id := wf_engine.getitemattrnumber(

1190: itemkey => itemkey,
1191: aname => 'UPDATE_GEN_STATUS'
1192: );
1193:
1194: l_object_id := wf_engine.getitemattrnumber(
1195: itemtype => itemtype,
1196: itemkey => itemkey,
1197: aname => 'OBJECT_ID'
1198: );

Line 1199: l_object_version_number := wf_engine.getitemattrnumber(

1195: itemtype => itemtype,
1196: itemkey => itemkey,
1197: aname => 'OBJECT_ID'
1198: );
1199: l_object_version_number := wf_engine.getitemattrnumber(
1200: itemtype => itemtype,
1201: itemkey => itemkey,
1202: aname => 'OBJECT_VER'
1203: );

Line 1204: l_approver_note := wf_engine.getitemattrtext(

1200: itemtype => itemtype,
1201: itemkey => itemkey,
1202: aname => 'OBJECT_VER'
1203: );
1204: l_approver_note := wf_engine.getitemattrtext(
1205: itemtype => itemtype,
1206: itemkey => itemkey,
1207: aname => 'APPROVER NOTE'
1208: );

Line 1240: l_new_status := wf_engine.getitemattrText(

1236: END IF;
1237:
1238: IF (l_approval_status IN( 'MR-TERMINATE','TERMINATED','CANCELLED')) THEN
1239:
1240: l_new_status := wf_engine.getitemattrText(
1241: itemtype => itemtype,
1242: itemkey => itemkey,
1243: aname => 'NEW_STATUS_ID'
1244: );

Line 1297: l_new_status := wf_engine.getitemattrText(

1293: );
1294:
1295:
1296: ELSE
1297: l_new_status := wf_engine.getitemattrText(
1298: itemtype => itemtype,
1299: itemkey => itemkey,
1300: aname => 'NEW_STATUS_ID'
1301: );

Line 1315: l_new_status := wf_engine.getitemattrText(

1311: END IF;
1312: END IF;
1313: CLOSE unit_effectivity_id_csr;
1314: ELSE
1315: l_new_status := wf_engine.getitemattrText(
1316: itemtype => itemtype,
1317: itemkey => itemkey,
1318: aname => 'REJECT_STATUS_ID'
1319: );

Line 1470: l_orig_status := wf_engine.getitemattrText(

1466: SAVEPOINT AHL_DEF_REVT_STATUS;
1467: l_return_status := FND_API.G_RET_STS_SUCCESS;
1468:
1469: IF (funcmode = 'RUN') THEN
1470: l_orig_status := wf_engine.getitemattrText(
1471: itemtype => itemtype,
1472: itemkey => itemkey,
1473: aname => 'ORG_STATUS_ID'
1474: );

Line 1475: l_object_id := wf_engine.getitemattrnumber(

1471: itemtype => itemtype,
1472: itemkey => itemkey,
1473: aname => 'ORG_STATUS_ID'
1474: );
1475: l_object_id := wf_engine.getitemattrnumber(
1476: itemtype => itemtype,
1477: itemkey => itemkey,
1478: aname => 'OBJECT_ID'
1479: );

Line 1480: l_object_version_number := wf_engine.getitemattrnumber(

1476: itemtype => itemtype,
1477: itemkey => itemkey,
1478: aname => 'OBJECT_ID'
1479: );
1480: l_object_version_number := wf_engine.getitemattrnumber(
1481: itemtype => itemtype,
1482: itemkey => itemkey,
1483: aname => 'OBJECT_VER'
1484: );

Line 1485: l_approver_note := wf_engine.getitemattrnumber(

1481: itemtype => itemtype,
1482: itemkey => itemkey,
1483: aname => 'OBJECT_VER'
1484: );
1485: l_approver_note := wf_engine.getitemattrnumber(
1486: itemtype => itemtype,
1487: itemkey => itemkey,
1488: aname => 'APPROVER NOTE'
1489: );