DBA Data[Home] [Help]

APPS.AHL_FMP_MR_APPROVAL_PVT dependencies on WF_ENGINE

Line 47: l_object_id := wf_engine.getitemattrnumber(

43:
44: fnd_msg_pub.initialize;
45: l_return_status := fnd_api.g_ret_sts_success;
46:
47: l_object_id := wf_engine.getitemattrnumber(
48: itemtype => itemtype
49: ,itemkey => itemkey
50: ,aname => 'OBJECT_ID'
51: );

Line 52: l_application_usg_code := wf_engine.getItemAttrText(

48: itemtype => itemtype
49: ,itemkey => itemkey
50: ,aname => 'OBJECT_ID'
51: );
52: l_application_usg_code := wf_engine.getItemAttrText(
53: itemtype => itemtype,
54: itemkey => itemkey,
55: aname => 'APPLICATION_USG_CODE'
56: );

Line 86: wf_engine.setitemattrtext(

82: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
83: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
84: l_subject := fnd_message.get;
85:
86: wf_engine.setitemattrtext(
87: itemtype => itemtype
88: ,itemkey => itemkey
89: ,aname => 'FORWARD_SUBJECT'
90: ,avalue => l_subject

Line 103: wf_engine.setitemattrtext(

99: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
100: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
101: l_subject := fnd_message.get;
102:
103: wf_engine.setitemattrtext(
104: itemtype => itemtype
105: ,itemkey => itemkey
106: ,aname => 'APPROVAL_SUBJECT'
107: ,avalue => l_subject

Line 121: wf_engine.setitemattrtext(

117: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
118: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
119: l_subject := fnd_message.get;
120:
121: wf_engine.setitemattrtext(
122: itemtype => itemtype
123: ,itemkey => itemkey
124: ,aname => 'REJECT_SUBJECT'
125: ,avalue => l_subject

Line 140: wf_engine.setitemattrtext(

136: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
137: l_subject := fnd_message.get;
138:
139:
140: wf_engine.setitemattrtext(
141: itemtype => itemtype
142: ,itemkey => itemkey
143: ,aname => 'APPROVED_SUBJECT'
144: ,avalue => l_subject

Line 157: wf_engine.setitemattrtext(

153: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
154: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
155: l_subject := fnd_message.get;
156:
157: wf_engine.setitemattrtext(
158: itemtype => itemtype
159: ,itemkey => itemkey
160: ,aname => 'FINAL_SUBJECT'
161: ,avalue => l_subject

Line 174: wf_engine.setitemattrtext(

170: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
171: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
172: l_subject := fnd_message.get;
173:
174: wf_engine.setitemattrtext(
175: itemtype => itemtype
176: ,itemkey => itemkey
177: ,aname => 'REMIND_SUBJECT'
178: ,avalue => l_subject);

Line 184: wf_engine.setitemattrtext(

180: fnd_message.set_token('TITLE',l_mr_rec.TITLE, false);
181: fnd_message.set_token('VERSION_NUMBER',l_mr_rec.VERSION_NUMBER);
182: l_subject := fnd_message.get;
183:
184: wf_engine.setitemattrtext(
185: itemtype => itemtype
186: ,itemkey => itemkey
187: ,aname => 'ERROR_SUBJECT'
188: ,avalue => l_subject

Line 214: wf_engine.setitemattrnumber(

210: END IF;
211:
212: IF l_return_status = fnd_api.g_ret_sts_success THEN
213:
214: wf_engine.setitemattrnumber(
215: itemtype => itemtype,
216: itemkey => itemkey,
217: aname => 'RULE_ID',
218: avalue => l_approval_rule_id

Line 221: wf_engine.setitemattrnumber(

217: aname => 'RULE_ID',
218: avalue => l_approval_rule_id
219: );
220:
221: wf_engine.setitemattrnumber(
222: itemtype => itemtype,
223: itemkey => itemkey,
224: aname => 'APPROVER_SEQ',
225: avalue => l_approver_seq

Line 355: l_object := wf_engine.getitemattrtext(

351: l_hyphen_pos1 := INSTR(document_id, ':');
352: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
353: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
354:
355: l_object := wf_engine.getitemattrtext(
356: itemtype => l_item_type
357: ,itemkey => l_item_key
358: ,aname => 'OBJECT_TYPE'
359: );

Line 361: l_object_id := wf_engine.getitemattrNumber(

357: ,itemkey => l_item_key
358: ,aname => 'OBJECT_TYPE'
359: );
360:
361: l_object_id := wf_engine.getitemattrNumber(
362: itemtype => l_item_type
363: ,itemkey => l_item_key
364: ,aname => 'OBJECT_ID'
365: );

Line 367: l_approver := wf_engine.getitemattrtext(

363: ,itemkey => l_item_key
364: ,aname => 'OBJECT_ID'
365: );
366:
367: l_approver := wf_engine.getitemattrtext(
368: itemtype => l_item_type
369: ,itemkey => l_item_key
370: ,aname => 'APPROVER'
371: );

Line 479: l_object := wf_engine.getitemattrtext(

475: l_hyphen_pos1 := INSTR(document_id, ':');
476: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
477: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
478:
479: l_object := wf_engine.getitemattrtext(
480: itemtype => l_item_type
481: ,itemkey => l_item_key
482: ,aname => 'OBJECT_TYPE'
483: );

Line 485: l_object_id := wf_engine.getitemattrNumber(

481: ,itemkey => l_item_key
482: ,aname => 'OBJECT_TYPE'
483: );
484:
485: l_object_id := wf_engine.getitemattrNumber(
486: itemtype => l_item_type
487: ,itemkey => l_item_key
488: ,aname => 'OBJECT_ID'
489: );

Line 491: l_approver := wf_engine.getitemattrtext(

487: ,itemkey => l_item_key
488: ,aname => 'OBJECT_ID'
489: );
490:
491: l_approver := wf_engine.getitemattrtext(
492: itemtype => l_item_type
493: ,itemkey => l_item_key
494: ,aname => 'APPROVER'
495: );

Line 604: l_object := wf_engine.getitemattrtext(

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

Line 610: l_object_id := wf_engine.getitemattrNumber(

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

Line 727: l_object := wf_engine.getitemattrtext(

723: l_hyphen_pos1 := INSTR(document_id, ':');
724: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
725: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
726:
727: l_object := wf_engine.getitemattrtext(
728: itemtype => l_item_type
729: ,itemkey => l_item_key
730: ,aname => 'OBJECT_TYPE'
731: );

Line 733: l_object_id := wf_engine.getitemattrNumber(

729: ,itemkey => l_item_key
730: ,aname => 'OBJECT_TYPE'
731: );
732:
733: l_object_id := wf_engine.getitemattrNumber(
734: itemtype => l_item_type
735: ,itemkey => l_item_key
736: ,aname => 'OBJECT_ID'
737: );

Line 739: l_approver := wf_engine.getitemattrtext(

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

Line 854: l_object := wf_engine.getitemattrtext(

850: l_hyphen_pos1 := INSTR(document_id, ':');
851: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
852: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
853:
854: l_object := wf_engine.getitemattrtext(
855: itemtype => l_item_type
856: ,itemkey => l_item_key
857: ,aname => 'OBJECT_TYPE'
858: );

Line 860: l_object_id := wf_engine.getitemattrNumber(

856: ,itemkey => l_item_key
857: ,aname => 'OBJECT_TYPE'
858: );
859:
860: l_object_id := wf_engine.getitemattrNumber(
861: itemtype => l_item_type
862: ,itemkey => l_item_key
863: ,aname => 'OBJECT_ID'
864: );

Line 866: l_requester := wf_engine.getitemattrtext(

862: ,itemkey => l_item_key
863: ,aname => 'OBJECT_ID'
864: );
865:
866: l_requester := wf_engine.getitemattrtext(
867: itemtype => l_item_type
868: ,itemkey => l_item_key
869: ,aname => 'REQUESTER'
870: );

Line 872: l_requester_note := wf_engine.getitemattrtext(

868: ,itemkey => l_item_key
869: ,aname => 'REQUESTER'
870: );
871:
872: l_requester_note := wf_engine.getitemattrtext(
873: itemtype => l_item_type
874: ,itemkey => l_item_key
875: ,aname => 'REQUESTER_NOTE'
876: );

Line 974: l_object := wf_engine.getitemattrtext(

970: l_hyphen_pos1 := INSTR(document_id, ':');
971: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
972: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
973:
974: l_object := wf_engine.getitemattrtext(
975: itemtype => l_item_type
976: ,itemkey => l_item_key
977: ,aname => 'OBJECT_TYPE'
978: );

Line 980: l_object_id := wf_engine.getitemattrNumber(

976: ,itemkey => l_item_key
977: ,aname => 'OBJECT_TYPE'
978: );
979:
980: l_object_id := wf_engine.getitemattrNumber(
981: itemtype => l_item_type
982: ,itemkey => l_item_key
983: ,aname => 'OBJECT_ID'
984: );

Line 986: l_requester := wf_engine.getitemattrtext(

982: ,itemkey => l_item_key
983: ,aname => 'OBJECT_ID'
984: );
985:
986: l_requester := wf_engine.getitemattrtext(
987: itemtype => l_item_type
988: ,itemkey => l_item_key
989: ,aname => 'REQUESTER'
990: );

Line 992: l_requester_note := wf_engine.getitemattrtext(

988: ,itemkey => l_item_key
989: ,aname => 'REQUESTER'
990: );
991:
992: l_requester_note := wf_engine.getitemattrtext(
993: itemtype => l_item_type
994: ,itemkey => l_item_key
995: ,aname => 'REQUESTER_NOTE'
996: );

Line 1098: l_object := wf_engine.getitemattrtext(

1094: l_hyphen_pos1 := INSTR(document_id, ':');
1095: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1096: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1097:
1098: l_object := wf_engine.getitemattrtext(
1099: itemtype => l_item_type
1100: ,itemkey => l_item_key
1101: ,aname => 'OBJECT_TYPE'
1102: );

Line 1104: l_object_id := wf_engine.getitemattrNumber(

1100: ,itemkey => l_item_key
1101: ,aname => 'OBJECT_TYPE'
1102: );
1103:
1104: l_object_id := wf_engine.getitemattrNumber(
1105: itemtype => l_item_type
1106: ,itemkey => l_item_key
1107: ,aname => 'OBJECT_ID'
1108: );

Line 1110: l_error_msg := wf_engine.getitemattrText(

1106: ,itemkey => l_item_key
1107: ,aname => 'OBJECT_ID'
1108: );
1109:
1110: l_error_msg := wf_engine.getitemattrText(
1111: itemtype => l_item_type,
1112: itemkey => l_item_key,
1113: aname => 'ERROR_MSG'
1114: );

Line 1219: l_approval_status := wf_engine.getitemattrtext(

1215: AHL_DEBUG_PUB.debug( 'Start Update Status API','+UPDATE_STATUS+');
1216: END IF;
1217:
1218: IF funcmode = 'RUN' THEN
1219: l_approval_status := wf_engine.getitemattrtext(
1220: itemtype => itemtype
1221: ,itemkey => itemkey
1222: ,aname => 'UPDATE_GEN_STATUS'
1223: );

Line 1226: l_next_status := wf_engine.getitemattrText(

1222: ,aname => 'UPDATE_GEN_STATUS'
1223: );
1224:
1225: IF l_approval_status = 'APPROVED' THEN
1226: l_next_status := wf_engine.getitemattrText(
1227: itemtype => itemtype
1228: ,itemkey => itemkey
1229: ,aname => 'NEW_STATUS_ID'
1230: );

Line 1233: l_next_status := wf_engine.getitemattrText(

1229: ,aname => 'NEW_STATUS_ID'
1230: );
1231:
1232: ELSE
1233: l_next_status := wf_engine.getitemattrText(
1234: itemtype => itemtype
1235: ,itemkey => itemkey
1236: ,aname => 'REJECT_STATUS_ID'
1237: );

Line 1240: l_object_version_number := wf_engine.getitemattrnumber(

1236: ,aname => 'REJECT_STATUS_ID'
1237: );
1238: END IF;
1239:
1240: l_object_version_number := wf_engine.getitemattrnumber(
1241: itemtype => itemtype
1242: ,itemkey => itemkey
1243: ,aname => 'OBJECT_VER'
1244: );

Line 1245: l_object_id := wf_engine.getitemattrnumber(

1241: itemtype => itemtype
1242: ,itemkey => itemkey
1243: ,aname => 'OBJECT_VER'
1244: );
1245: l_object_id := wf_engine.getitemattrnumber(
1246: itemtype => itemtype
1247: ,itemkey => itemkey
1248: ,aname => 'OBJECT_ID'
1249: );

Line 1384: l_next_status := wf_engine.getitemattrText(

1380: END IF;
1381:
1382: l_return_Status:='S';
1383: IF funcmode = 'RUN' THEN
1384: l_next_status := wf_engine.getitemattrText(
1385: itemtype => itemtype
1386: ,itemkey => itemkey
1387: ,aname => 'ORG_STATUS_ID'
1388: );

Line 1390: l_object_version_number := wf_engine.getitemattrnumber(

1386: ,itemkey => itemkey
1387: ,aname => 'ORG_STATUS_ID'
1388: );
1389:
1390: l_object_version_number := wf_engine.getitemattrnumber(
1391: itemtype => itemtype
1392: ,itemkey => itemkey
1393: ,aname => 'OBJECT_VER'
1394: );

Line 1395: l_object_id := wf_engine.getitemattrnumber(

1391: itemtype => itemtype
1392: ,itemkey => itemkey
1393: ,aname => 'OBJECT_VER'
1394: );
1395: l_object_id := wf_engine.getitemattrnumber(
1396: itemtype => itemtype
1397: ,itemkey => itemkey
1398: ,aname => 'OBJECT_ID'
1399: );