DBA Data[Home] [Help]

APPS.AHL_ITEMCOMP_APPROVAL_PVT dependencies on WF_ENGINE

Line 85: l_object_id := wf_engine.getitemattrnumber(

81: fnd_msg_pub.initialize;
82:
83: l_return_status := fnd_api.g_ret_sts_success;
84:
85: l_object_id := wf_engine.getitemattrnumber(
86: itemtype => itemtype
87: ,itemkey => itemkey
88: ,aname => 'OBJECT_ID'
89: );

Line 150: wf_engine.setitemattrtext(

146:
147: END IF;
148:
149:
150: wf_engine.setitemattrtext(
151: itemtype => itemtype
152: ,itemkey => itemkey
153: ,aname => 'FORWARD_SUBJECT'
154: ,avalue => l_fwd_subject);

Line 155: wf_engine.setitemattrtext(

151: itemtype => itemtype
152: ,itemkey => itemkey
153: ,aname => 'FORWARD_SUBJECT'
154: ,avalue => l_fwd_subject);
155: wf_engine.setitemattrtext(
156: itemtype => itemtype
157: ,itemkey => itemkey
158: ,aname => 'APPROVAL_SUBJECT'
159: ,avalue => l_appr_subject);

Line 162: wf_engine.setitemattrtext(

158: ,aname => 'APPROVAL_SUBJECT'
159: ,avalue => l_appr_subject);
160:
161:
162: wf_engine.setitemattrtext(
163: itemtype => itemtype
164: ,itemkey => itemkey
165: ,aname => 'REJECT_SUBJECT'
166: ,avalue => l_reject_subject);

Line 169: wf_engine.setitemattrtext(

165: ,aname => 'REJECT_SUBJECT'
166: ,avalue => l_reject_subject);
167:
168:
169: wf_engine.setitemattrtext(
170: itemtype => itemtype
171: ,itemkey => itemkey
172: ,aname => 'APPROVED_SUBJECT'
173: ,avalue => l_approved_subject);

Line 175: wf_engine.setitemattrtext(

171: ,itemkey => itemkey
172: ,aname => 'APPROVED_SUBJECT'
173: ,avalue => l_approved_subject);
174:
175: wf_engine.setitemattrtext(
176: itemtype => itemtype
177: ,itemkey => itemkey
178: ,aname => 'APPROVED_SUBJECT'
179: ,avalue => l_approved_subject);

Line 181: wf_engine.setitemattrtext(

177: ,itemkey => itemkey
178: ,aname => 'APPROVED_SUBJECT'
179: ,avalue => l_approved_subject);
180:
181: wf_engine.setitemattrtext(
182: itemtype => itemtype
183: ,itemkey => itemkey
184: ,aname => 'FINAL_SUBJECT'
185: ,avalue => l_final_subject);

Line 187: wf_engine.setitemattrtext(

183: ,itemkey => itemkey
184: ,aname => 'FINAL_SUBJECT'
185: ,avalue => l_final_subject);
186:
187: wf_engine.setitemattrtext(
188: itemtype => itemtype
189: ,itemkey => itemkey
190: ,aname => 'REMIND_SUBJECT'
191: ,avalue => l_remind_subject);

Line 193: wf_engine.setitemattrtext(

189: ,itemkey => itemkey
190: ,aname => 'REMIND_SUBJECT'
191: ,avalue => l_remind_subject);
192:
193: wf_engine.setitemattrtext(
194: itemtype => itemtype
195: ,itemkey => itemkey
196: ,aname => 'ERROR_SUBJECT'
197: ,avalue => l_error_subject

Line 240: wf_engine.setitemattrnumber(

236: END IF;
237:
238: IF l_return_status = fnd_api.g_ret_sts_success THEN
239:
240: wf_engine.setitemattrnumber(
241: itemtype => itemtype,
242: itemkey => itemkey,
243: aname => 'RULE_ID',
244: avalue => l_approval_rule_id

Line 247: wf_engine.setitemattrnumber(

243: aname => 'RULE_ID',
244: avalue => l_approval_rule_id
245: );
246:
247: wf_engine.setitemattrnumber(
248: itemtype => itemtype,
249: itemkey => itemkey,
250: aname => 'APPROVER_SEQ',
251: avalue => l_approver_seq

Line 380: l_object := wf_engine.getitemattrtext(

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

Line 386: l_object_id := wf_engine.getitemattrNumber(

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

Line 392: l_approver := wf_engine.getitemattrtext(

388: ,itemkey => l_item_key
389: ,aname => 'OBJECT_ID'
390: );
391:
392: l_approver := wf_engine.getitemattrtext(
393: itemtype => l_item_type
394: ,itemkey => l_item_key
395: ,aname => 'APPROVER'
396: );

Line 504: l_object := wf_engine.getitemattrtext(

500: l_hyphen_pos1 := INSTR(document_id, ':');
501: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
502: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
503:
504: l_object := wf_engine.getitemattrtext(
505: itemtype => l_item_type
506: ,itemkey => l_item_key
507: ,aname => 'OBJECT_TYPE'
508: );

Line 510: l_object_id := wf_engine.getitemattrNumber(

506: ,itemkey => l_item_key
507: ,aname => 'OBJECT_TYPE'
508: );
509:
510: l_object_id := wf_engine.getitemattrNumber(
511: itemtype => l_item_type
512: ,itemkey => l_item_key
513: ,aname => 'OBJECT_ID'
514: );

Line 516: l_approver := wf_engine.getitemattrtext(

512: ,itemkey => l_item_key
513: ,aname => 'OBJECT_ID'
514: );
515:
516: l_approver := wf_engine.getitemattrtext(
517: itemtype => l_item_type
518: ,itemkey => l_item_key
519: ,aname => 'APPROVER'
520: );

Line 662: l_object := wf_engine.getitemattrtext(

658: l_hyphen_pos1 := INSTR(document_id, ':');
659: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
660: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
661:
662: l_object := wf_engine.getitemattrtext(
663: itemtype => l_item_type
664: ,itemkey => l_item_key
665: ,aname => 'OBJECT_TYPE'
666: );

Line 668: l_object_id := wf_engine.getitemattrNumber(

664: ,itemkey => l_item_key
665: ,aname => 'OBJECT_TYPE'
666: );
667:
668: l_object_id := wf_engine.getitemattrNumber(
669: itemtype => l_item_type
670: ,itemkey => l_item_key
671: ,aname => 'OBJECT_ID'
672: );

Line 807: l_object := wf_engine.getitemattrtext(

803: l_hyphen_pos1 := INSTR(document_id, ':');
804: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
805: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
806:
807: l_object := wf_engine.getitemattrtext(
808: itemtype => l_item_type
809: ,itemkey => l_item_key
810: ,aname => 'OBJECT_TYPE'
811: );

Line 813: l_object_id := wf_engine.getitemattrNumber(

809: ,itemkey => l_item_key
810: ,aname => 'OBJECT_TYPE'
811: );
812:
813: l_object_id := wf_engine.getitemattrNumber(
814: itemtype => l_item_type
815: ,itemkey => l_item_key
816: ,aname => 'OBJECT_ID'
817: );

Line 819: l_approver := wf_engine.getitemattrtext(

815: ,itemkey => l_item_key
816: ,aname => 'OBJECT_ID'
817: );
818:
819: l_approver := wf_engine.getitemattrtext(
820: itemtype => l_item_type
821: ,itemkey => l_item_key
822: ,aname => 'APPROVER'
823: );

Line 954: l_object := wf_engine.getitemattrtext(

950: l_hyphen_pos1 := INSTR(document_id, ':');
951: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
952: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
953:
954: l_object := wf_engine.getitemattrtext(
955: itemtype => l_item_type
956: ,itemkey => l_item_key
957: ,aname => 'OBJECT_TYPE'
958: );

Line 960: l_object_id := wf_engine.getitemattrNumber(

956: ,itemkey => l_item_key
957: ,aname => 'OBJECT_TYPE'
958: );
959:
960: l_object_id := wf_engine.getitemattrNumber(
961: itemtype => l_item_type
962: ,itemkey => l_item_key
963: ,aname => 'OBJECT_ID'
964: );

Line 966: l_requester := wf_engine.getitemattrtext(

962: ,itemkey => l_item_key
963: ,aname => 'OBJECT_ID'
964: );
965:
966: l_requester := wf_engine.getitemattrtext(
967: itemtype => l_item_type
968: ,itemkey => l_item_key
969: ,aname => 'REQUESTER'
970: );

Line 972: l_requester_note := wf_engine.getitemattrtext(

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

Line 1112: l_object := wf_engine.getitemattrtext(

1108: l_hyphen_pos1 := INSTR(document_id, ':');
1109: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1110: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1111:
1112: l_object := wf_engine.getitemattrtext(
1113: itemtype => l_item_type
1114: ,itemkey => l_item_key
1115: ,aname => 'OBJECT_TYPE'
1116: );

Line 1118: l_object_id := wf_engine.getitemattrNumber(

1114: ,itemkey => l_item_key
1115: ,aname => 'OBJECT_TYPE'
1116: );
1117:
1118: l_object_id := wf_engine.getitemattrNumber(
1119: itemtype => l_item_type
1120: ,itemkey => l_item_key
1121: ,aname => 'OBJECT_ID'
1122: );

Line 1124: l_requester := wf_engine.getitemattrtext(

1120: ,itemkey => l_item_key
1121: ,aname => 'OBJECT_ID'
1122: );
1123:
1124: l_requester := wf_engine.getitemattrtext(
1125: itemtype => l_item_type
1126: ,itemkey => l_item_key
1127: ,aname => 'REQUESTER'
1128: );

Line 1130: l_requester_note := wf_engine.getitemattrtext(

1126: ,itemkey => l_item_key
1127: ,aname => 'REQUESTER'
1128: );
1129:
1130: l_requester_note := wf_engine.getitemattrtext(
1131: itemtype => l_item_type
1132: ,itemkey => l_item_key
1133: ,aname => 'REQUESTER_NOTE'
1134: );

Line 1269: l_object := wf_engine.getitemattrtext(

1265: l_hyphen_pos1 := INSTR(document_id, ':');
1266: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1267: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1268:
1269: l_object := wf_engine.getitemattrtext(
1270: itemtype => l_item_type
1271: ,itemkey => l_item_key
1272: ,aname => 'OBJECT_TYPE'
1273: );

Line 1275: l_object_id := wf_engine.getitemattrNumber(

1271: ,itemkey => l_item_key
1272: ,aname => 'OBJECT_TYPE'
1273: );
1274:
1275: l_object_id := wf_engine.getitemattrNumber(
1276: itemtype => l_item_type
1277: ,itemkey => l_item_key
1278: ,aname => 'OBJECT_ID'
1279: );

Line 1281: l_error_msg := wf_engine.getitemattrText(

1277: ,itemkey => l_item_key
1278: ,aname => 'OBJECT_ID'
1279: );
1280:
1281: l_error_msg := wf_engine.getitemattrText(
1282: itemtype => l_item_type
1283: ,itemkey => l_item_key
1284: ,aname => 'ERROR_MSG'
1285: );

Line 1405: l_approval_status := wf_engine.getitemattrtext(

1401: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Start UpdateStatus');
1402: END IF;
1403:
1404: IF funcmode = 'RUN' THEN
1405: l_approval_status := wf_engine.getitemattrtext(
1406: itemtype => itemtype
1407: ,itemkey => itemkey
1408: ,aname => 'UPDATE_GEN_STATUS'
1409: );

Line 1416: l_next_status := wf_engine.getitemattrText(

1412: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'After GetItemAttrText UpdateStatus');
1413: END IF;
1414:
1415: IF l_approval_status = 'APPROVED' THEN
1416: l_next_status := wf_engine.getitemattrText(
1417: itemtype => itemtype
1418: ,itemkey => itemkey
1419: ,aname => 'NEW_STATUS_ID'
1420: );

Line 1423: l_next_status := wf_engine.getitemattrText(

1419: ,aname => 'NEW_STATUS_ID'
1420: );
1421:
1422: ELSE
1423: l_next_status := wf_engine.getitemattrText(
1424: itemtype => itemtype
1425: ,itemkey => itemkey
1426: ,aname => 'REJECT_STATUS_ID'
1427: );

Line 1430: l_object_version_number := wf_engine.getitemattrnumber(

1426: ,aname => 'REJECT_STATUS_ID'
1427: );
1428: END IF;
1429:
1430: l_object_version_number := wf_engine.getitemattrnumber(
1431: itemtype => itemtype
1432: ,itemkey => itemkey
1433: ,aname => 'OBJECT_VER'
1434: );

Line 1435: l_object_id := wf_engine.getitemattrnumber(

1431: itemtype => itemtype
1432: ,itemkey => itemkey
1433: ,aname => 'OBJECT_VER'
1434: );
1435: l_object_id := wf_engine.getitemattrnumber(
1436: itemtype => itemtype
1437: ,itemkey => itemkey
1438: ,aname => 'OBJECT_ID'
1439: );

Line 1618: l_next_status := wf_engine.getitemattrText(

1614: END IF;
1615:
1616: l_return_Status:='S';
1617: IF funcmode = 'RUN' THEN
1618: l_next_status := wf_engine.getitemattrText(
1619: itemtype => itemtype
1620: ,itemkey => itemkey
1621: ,aname => 'ORG_STATUS_ID'
1622: );

Line 1624: l_object_version_number := wf_engine.getitemattrnumber(

1620: ,itemkey => itemkey
1621: ,aname => 'ORG_STATUS_ID'
1622: );
1623:
1624: l_object_version_number := wf_engine.getitemattrnumber(
1625: itemtype => itemtype
1626: ,itemkey => itemkey
1627: ,aname => 'OBJECT_VER'
1628: );

Line 1629: l_object_id := wf_engine.getitemattrnumber(

1625: itemtype => itemtype
1626: ,itemkey => itemkey
1627: ,aname => 'OBJECT_VER'
1628: );
1629: l_object_id := wf_engine.getitemattrnumber(
1630: itemtype => itemtype
1631: ,itemkey => itemkey
1632: ,aname => 'OBJECT_ID'
1633: );