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 478: l_object := wf_engine.getitemattrtext(

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

Line 484: l_object_id := wf_engine.getitemattrNumber(

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

Line 490: l_approver := wf_engine.getitemattrtext(

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

Line 603: l_object := wf_engine.getitemattrtext(

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

Line 609: l_object_id := wf_engine.getitemattrNumber(

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

Line 726: l_object := wf_engine.getitemattrtext(

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

Line 732: l_object_id := wf_engine.getitemattrNumber(

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

Line 738: l_approver := wf_engine.getitemattrtext(

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

Line 853: l_object := wf_engine.getitemattrtext(

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

Line 859: l_object_id := wf_engine.getitemattrNumber(

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

Line 865: l_requester := wf_engine.getitemattrtext(

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

Line 871: l_requester_note := wf_engine.getitemattrtext(

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

Line 973: l_object := wf_engine.getitemattrtext(

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

Line 979: l_object_id := wf_engine.getitemattrNumber(

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

Line 985: l_requester := wf_engine.getitemattrtext(

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

Line 991: l_requester_note := wf_engine.getitemattrtext(

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

Line 1097: l_object := wf_engine.getitemattrtext(

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

Line 1103: l_object_id := wf_engine.getitemattrNumber(

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

Line 1109: l_error_msg := wf_engine.getitemattrText(

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

Line 1218: l_approval_status := wf_engine.getitemattrtext(

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

Line 1225: l_next_status := wf_engine.getitemattrText(

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

Line 1232: l_next_status := wf_engine.getitemattrText(

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

Line 1239: l_object_version_number := wf_engine.getitemattrnumber(

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

Line 1244: l_object_id := wf_engine.getitemattrnumber(

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

Line 1383: l_next_status := wf_engine.getitemattrText(

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

Line 1389: l_object_version_number := wf_engine.getitemattrnumber(

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

Line 1394: l_object_id := wf_engine.getitemattrnumber(

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