DBA Data[Home] [Help]

APPS.AHL_MC_APPROVALS_PVT dependencies on WF_ENGINE

Line 53: l_object_id := wf_engine.getitemattrnumber

49: 'At the start of PLSQL procedure'
50: );
51: END IF;
52:
53: l_object_id := wf_engine.getitemattrnumber
54: (
55: itemtype => itemtype
56: ,itemkey => itemkey
57: ,aname => 'OBJECT_ID'

Line 105: wf_engine.setitemattrtext

101: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
102: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
103: l_subject := fnd_message.get;
104:
105: wf_engine.setitemattrtext
106: (
107: itemtype => itemtype
108: ,itemkey => itemkey
109: ,aname => 'FORWARD_SUBJECT'

Line 128: wf_engine.setitemattrtext

124: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
125: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
126: l_subject := fnd_message.get;
127:
128: wf_engine.setitemattrtext
129: (
130: itemtype => itemtype
131: ,itemkey => itemkey
132: ,aname => 'APPROVAL_SUBJECT'

Line 151: wf_engine.setitemattrtext

147: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
148: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
149: l_subject := fnd_message.get;
150:
151: wf_engine.setitemattrtext
152: (
153: itemtype => itemtype
154: ,itemkey => itemkey
155: ,aname => 'REJECT_SUBJECT'

Line 174: wf_engine.setitemattrtext

170: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
171: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
172: l_subject := fnd_message.get;
173:
174: wf_engine.setitemattrtext
175: (
176: itemtype => itemtype
177: ,itemkey => itemkey
178: ,aname => 'APPROVED_SUBJECT'

Line 197: wf_engine.setitemattrtext

193: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
194: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
195: l_subject := fnd_message.get;
196:
197: wf_engine.setitemattrtext
198: (
199: itemtype => itemtype
200: ,itemkey => itemkey
201: ,aname => 'FINAL_SUBJECT'

Line 220: wf_engine.setitemattrtext

216: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
217: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
218: l_subject := fnd_message.get;
219:
220: wf_engine.setitemattrtext
221: (
222: itemtype => itemtype
223: ,itemkey => itemkey
224: ,aname => 'REMIND_SUBJECT'

Line 243: wf_engine.setitemattrtext

239: fnd_message.set_token('MC_HEADER_ID', l_mc_header_rec.mc_header_id, false);
240: fnd_message.set_token('NAME',l_mc_header_rec.NAME, false);
241: l_subject := fnd_message.get;
242:
243: wf_engine.setitemattrtext
244: (
245: itemtype => itemtype
246: ,itemkey => itemkey
247: ,aname => 'ERROR_SUBJECT'

Line 283: wf_engine.setitemattrnumber

279: );
280:
281: IF l_return_status = FND_API.g_ret_sts_success
282: THEN
283: wf_engine.setitemattrnumber
284: (
285: itemtype => itemtype,
286: itemkey => itemkey,
287: aname => 'RULE_ID',

Line 301: wf_engine.setitemattrnumber

297: 'RULE_ID='||l_approval_rule_id
298: );
299: END IF;
300:
301: wf_engine.setitemattrnumber
302: (
303: itemtype => itemtype,
304: itemkey => itemkey,
305: aname => 'APPROVER_SEQ',

Line 454: l_object := wf_engine.getitemattrtext

450: l_hyphen_pos1 := INSTR(document_id, ':');
451: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
452: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
453:
454: l_object := wf_engine.getitemattrtext
455: (
456: itemtype => l_item_type
457: ,itemkey => l_item_key
458: ,aname => 'OBJECT_TYPE'

Line 461: l_object_id := wf_engine.getitemattrNumber

457: ,itemkey => l_item_key
458: ,aname => 'OBJECT_TYPE'
459: );
460:
461: l_object_id := wf_engine.getitemattrNumber
462: (
463: itemtype => l_item_type
464: ,itemkey => l_item_key
465: ,aname => 'OBJECT_ID'

Line 468: l_approver := wf_engine.getitemattrtext

464: ,itemkey => l_item_key
465: ,aname => 'OBJECT_ID'
466: );
467:
468: l_approver := wf_engine.getitemattrtext
469: (
470: itemtype => l_item_type
471: ,itemkey => l_item_key
472: ,aname => 'APPROVER'

Line 616: l_object := wf_engine.getitemattrtext

612: l_hyphen_pos1 := INSTR(document_id, ':');
613: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
614: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
615:
616: l_object := wf_engine.getitemattrtext
617: (
618: itemtype => l_item_type
619: ,itemkey => l_item_key
620: ,aname => 'OBJECT_TYPE'

Line 623: l_object_id := wf_engine.getitemattrNumber

619: ,itemkey => l_item_key
620: ,aname => 'OBJECT_TYPE'
621: );
622:
623: l_object_id := wf_engine.getitemattrNumber
624: (
625: itemtype => l_item_type
626: ,itemkey => l_item_key
627: ,aname => 'OBJECT_ID'

Line 630: l_approver := wf_engine.getitemattrtext

626: ,itemkey => l_item_key
627: ,aname => 'OBJECT_ID'
628: );
629:
630: l_approver := wf_engine.getitemattrtext
631: (
632: itemtype => l_item_type
633: ,itemkey => l_item_key
634: ,aname => 'APPROVER'

Line 776: l_object := wf_engine.getitemattrtext

772: l_hyphen_pos1 := INSTR(document_id, ':');
773: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
774: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
775:
776: l_object := wf_engine.getitemattrtext
777: (
778: itemtype => l_item_type
779: ,itemkey => l_item_key
780: ,aname => 'OBJECT_TYPE'

Line 783: l_object_id := wf_engine.getitemattrNumber

779: ,itemkey => l_item_key
780: ,aname => 'OBJECT_TYPE'
781: );
782:
783: l_object_id := wf_engine.getitemattrNumber
784: (
785: itemtype => l_item_type
786: ,itemkey => l_item_key
787: ,aname => 'OBJECT_ID'

Line 930: l_object := wf_engine.getitemattrtext

926: l_hyphen_pos1 := INSTR(document_id, ':');
927: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
928: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
929:
930: l_object := wf_engine.getitemattrtext
931: (
932: itemtype => l_item_type
933: ,itemkey => l_item_key
934: ,aname => 'OBJECT_TYPE'

Line 937: l_object_id := wf_engine.getitemattrNumber

933: ,itemkey => l_item_key
934: ,aname => 'OBJECT_TYPE'
935: );
936:
937: l_object_id := wf_engine.getitemattrNumber
938: (
939: itemtype => l_item_type
940: ,itemkey => l_item_key
941: ,aname => 'OBJECT_ID'

Line 944: l_approver := wf_engine.getitemattrtext

940: ,itemkey => l_item_key
941: ,aname => 'OBJECT_ID'
942: );
943:
944: l_approver := wf_engine.getitemattrtext
945: (
946: itemtype => l_item_type
947: ,itemkey => l_item_key
948: ,aname => 'APPROVER'

Line 1091: l_object := wf_engine.getitemattrtext

1087: l_hyphen_pos1 := INSTR(document_id, ':');
1088: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1089: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1090:
1091: l_object := wf_engine.getitemattrtext
1092: (
1093: itemtype => l_item_type
1094: ,itemkey => l_item_key
1095: ,aname => 'OBJECT_TYPE'

Line 1098: l_object_id := wf_engine.getitemattrNumber

1094: ,itemkey => l_item_key
1095: ,aname => 'OBJECT_TYPE'
1096: );
1097:
1098: l_object_id := wf_engine.getitemattrNumber
1099: (
1100: itemtype => l_item_type
1101: ,itemkey => l_item_key
1102: ,aname => 'OBJECT_ID'

Line 1105: l_requester := wf_engine.getitemattrtext

1101: ,itemkey => l_item_key
1102: ,aname => 'OBJECT_ID'
1103: );
1104:
1105: l_requester := wf_engine.getitemattrtext
1106: (
1107: itemtype => l_item_type
1108: ,itemkey => l_item_key
1109: ,aname => 'REQUESTER'

Line 1112: l_requester_note := wf_engine.getitemattrtext

1108: ,itemkey => l_item_key
1109: ,aname => 'REQUESTER'
1110: );
1111:
1112: l_requester_note := wf_engine.getitemattrtext
1113: (
1114: itemtype => l_item_type
1115: ,itemkey => l_item_key
1116: ,aname => 'REQUESTER_NOTE'

Line 1261: l_object := wf_engine.getitemattrtext

1257: l_hyphen_pos1 := INSTR(document_id, ':');
1258: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1259: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1260:
1261: l_object := wf_engine.getitemattrtext
1262: (
1263: itemtype => l_item_type
1264: ,itemkey => l_item_key
1265: ,aname => 'OBJECT_TYPE'

Line 1268: l_object_id := wf_engine.getitemattrNumber

1264: ,itemkey => l_item_key
1265: ,aname => 'OBJECT_TYPE'
1266: );
1267:
1268: l_object_id := wf_engine.getitemattrNumber
1269: (
1270: itemtype => l_item_type
1271: ,itemkey => l_item_key
1272: ,aname => 'OBJECT_ID'

Line 1275: l_requester := wf_engine.getitemattrtext

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

Line 1282: l_requester_note := wf_engine.getitemattrtext

1278: ,itemkey => l_item_key
1279: ,aname => 'REQUESTER'
1280: );
1281:
1282: l_requester_note := wf_engine.getitemattrtext
1283: (
1284: itemtype => l_item_type
1285: ,itemkey => l_item_key
1286: ,aname => 'REQUESTER_NOTE'

Line 1429: l_object := wf_engine.getitemattrtext

1425: l_hyphen_pos1 := INSTR(document_id, ':');
1426: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1427: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1428:
1429: l_object := wf_engine.getitemattrtext
1430: (
1431: itemtype => l_item_type
1432: ,itemkey => l_item_key
1433: ,aname => 'OBJECT_TYPE'

Line 1436: l_object_id := wf_engine.getitemattrNumber

1432: ,itemkey => l_item_key
1433: ,aname => 'OBJECT_TYPE'
1434: );
1435:
1436: l_object_id := wf_engine.getitemattrNumber
1437: (
1438: itemtype => l_item_type
1439: ,itemkey => l_item_key
1440: ,aname => 'OBJECT_ID'

Line 1443: l_error_msg := wf_engine.getitemattrText

1439: ,itemkey => l_item_key
1440: ,aname => 'OBJECT_ID'
1441: );
1442:
1443: l_error_msg := wf_engine.getitemattrText
1444: (
1445: itemtype => l_item_type
1446: ,itemkey => l_item_key
1447: ,aname => 'ERROR_MSG'

Line 1583: l_next_status := wf_engine.getitemattrtext

1579: -- RUN Mode
1580: --
1581: IF (funcmode = 'RUN')
1582: THEN
1583: l_next_status := wf_engine.getitemattrtext
1584: (
1585: itemtype => itemtype
1586: ,itemkey => itemkey
1587: ,aname => 'UPDATE_GEN_STATUS'

Line 1590: l_object_version_number := wf_engine.getitemattrnumber

1586: ,itemkey => itemkey
1587: ,aname => 'UPDATE_GEN_STATUS'
1588: );
1589:
1590: l_object_version_number := wf_engine.getitemattrnumber
1591: (
1592: itemtype => itemtype
1593: ,itemkey => itemkey
1594: ,aname => 'OBJECT_VER'

Line 1597: l_object_id := wf_engine.getitemattrnumber

1593: ,itemkey => itemkey
1594: ,aname => 'OBJECT_VER'
1595: );
1596:
1597: l_object_id := wf_engine.getitemattrnumber
1598: (
1599: itemtype => itemtype
1600: ,itemkey => itemkey
1601: ,aname => 'OBJECT_ID'

Line 1776: l_next_status := wf_engine.getitemattrText

1772: -- RUN mode
1773: --
1774: IF (funcmode = 'RUN')
1775: THEN
1776: l_next_status := wf_engine.getitemattrText
1777: (
1778: itemtype => itemtype
1779: ,itemkey => itemkey
1780: ,aname => 'ORG_STATUS_ID'

Line 1782: l_object_version_number := wf_engine.getitemattrnumber

1778: itemtype => itemtype
1779: ,itemkey => itemkey
1780: ,aname => 'ORG_STATUS_ID'
1781: );
1782: l_object_version_number := wf_engine.getitemattrnumber
1783: (
1784: itemtype => itemtype
1785: ,itemkey => itemkey
1786: ,aname => 'OBJECT_VER'

Line 1789: l_object_id := wf_engine.getitemattrnumber

1785: ,itemkey => itemkey
1786: ,aname => 'OBJECT_VER'
1787: );
1788:
1789: l_object_id := wf_engine.getitemattrnumber
1790: (
1791: itemtype => itemtype
1792: ,itemkey => itemkey
1793: ,aname => 'OBJECT_ID'