DBA Data[Home] [Help]

APPS.AHL_UC_WF_APPR_PVT dependencies on WF_ENGINE

Line 58: l_object_id := wf_engine.getitemattrnumber

54:
55: l_return_status := FND_API.g_ret_sts_success;
56:
57:
58: l_object_id := wf_engine.getitemattrnumber
59: (
60: itemtype => itemtype
61: ,itemkey => itemkey
62: ,aname => 'OBJECT_ID'

Line 68: l_object_version_number := wf_engine.getitemattrnumber

64: IF G_DEBUG='Y' THEN
65: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS --> l_object_id='||l_object_id);
66: END IF;
67:
68: l_object_version_number := wf_engine.getitemattrnumber
69: (
70: itemtype => itemtype,
71: itemkey => itemkey,
72: aname => 'OBJECT_VER'

Line 110: wf_engine.setitemattrtext

106: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
107: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
108: l_subject := fnd_message.get;
109:
110: wf_engine.setitemattrtext
111: (
112: itemtype => itemtype
113: ,itemkey => itemkey
114: ,aname => 'FORWARD_SUBJECT'

Line 123: wf_engine.setitemattrtext

119: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
120: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
121: l_subject := fnd_message.get;
122:
123: wf_engine.setitemattrtext
124: (
125: itemtype => itemtype
126: ,itemkey => itemkey
127: ,aname => 'APPROVAL_SUBJECT'

Line 139: wf_engine.setitemattrtext

135: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
136: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
137: l_subject := fnd_message.get;
138:
139: wf_engine.setitemattrtext
140: (
141: itemtype => itemtype
142: ,itemkey => itemkey
143: ,aname => 'REJECT_SUBJECT'

Line 155: wf_engine.setitemattrtext

151: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
152: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
153: l_subject := fnd_message.get;
154:
155: wf_engine.setitemattrtext
156: (
157: itemtype => itemtype
158: ,itemkey => itemkey
159: ,aname => 'APPROVED_SUBJECT'

Line 171: wf_engine.setitemattrtext

167: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
168: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
169: l_subject := fnd_message.get;
170:
171: wf_engine.setitemattrtext
172: (
173: itemtype => itemtype
174: ,itemkey => itemkey
175: ,aname => 'FINAL_SUBJECT'

Line 187: wf_engine.setitemattrtext

183: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
184: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
185: l_subject := fnd_message.get;
186:
187: wf_engine.setitemattrtext
188: (
189: itemtype => itemtype
190: ,itemkey => itemkey
191: ,aname => 'REMIND_SUBJECT'

Line 203: wf_engine.setitemattrtext

199: fnd_message.set_token('UC_HEADER_ID', l_uc_header_rec.unit_config_header_id, false);
200: fnd_message.set_token('NAME',l_uc_header_rec.name, false);
201: l_subject := fnd_message.get;
202:
203: wf_engine.setitemattrtext
204: (
205: itemtype => itemtype
206: ,itemkey => itemkey
207: ,aname => 'ERROR_SUBJECT'

Line 227: wf_engine.setitemattrnumber

223:
224:
225: IF l_return_status = FND_API.g_ret_sts_success THEN
226:
227: wf_engine.setitemattrnumber
228: (
229: itemtype => itemtype,
230: itemkey => itemkey,
231: aname => 'RULE_ID',

Line 238: wf_engine.setitemattrnumber

234: IF G_DEBUG='Y' THEN
235: AHL_DEBUG_PUB.debug('UC: SET_ACTIVITY_DETAILS -- RULE_ID='||l_approval_rule_id);
236: END IF;
237:
238: wf_engine.setitemattrnumber
239: (
240: itemtype => itemtype,
241: itemkey => itemkey,
242: aname => 'APPROVER_SEQ',

Line 375: l_object := wf_engine.getitemattrtext

371: l_hyphen_pos1 := INSTR(document_id, ':');
372: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
373: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
374:
375: l_object := wf_engine.getitemattrtext
376: (
377: itemtype => l_item_type
378: ,itemkey => l_item_key
379: ,aname => 'OBJECT_TYPE'

Line 382: l_object_id := wf_engine.getitemattrNumber

378: ,itemkey => l_item_key
379: ,aname => 'OBJECT_TYPE'
380: );
381:
382: l_object_id := wf_engine.getitemattrNumber
383: (
384: itemtype => l_item_type
385: ,itemkey => l_item_key
386: ,aname => 'OBJECT_ID'

Line 389: l_approver := wf_engine.getitemattrtext

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

Line 511: l_object := wf_engine.getitemattrtext

507: l_hyphen_pos1 := INSTR(document_id, ':');
508: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
509: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
510:
511: l_object := wf_engine.getitemattrtext
512: (
513: itemtype => l_item_type
514: ,itemkey => l_item_key
515: ,aname => 'OBJECT_TYPE'

Line 518: l_object_id := wf_engine.getitemattrNumber

514: ,itemkey => l_item_key
515: ,aname => 'OBJECT_TYPE'
516: );
517:
518: l_object_id := wf_engine.getitemattrNumber
519: (
520: itemtype => l_item_type
521: ,itemkey => l_item_key
522: ,aname => 'OBJECT_ID'

Line 525: l_approver := wf_engine.getitemattrtext

521: ,itemkey => l_item_key
522: ,aname => 'OBJECT_ID'
523: );
524:
525: l_approver := wf_engine.getitemattrtext
526: (
527: itemtype => l_item_type
528: ,itemkey => l_item_key
529: ,aname => 'APPROVER'

Line 644: l_object := wf_engine.getitemattrtext

640: l_hyphen_pos1 := INSTR(document_id, ':');
641: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
642: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
643:
644: l_object := wf_engine.getitemattrtext
645: (
646: itemtype => l_item_type
647: ,itemkey => l_item_key
648: ,aname => 'OBJECT_TYPE'

Line 651: l_object_id := wf_engine.getitemattrNumber

647: ,itemkey => l_item_key
648: ,aname => 'OBJECT_TYPE'
649: );
650:
651: l_object_id := wf_engine.getitemattrNumber
652: (
653: itemtype => l_item_type
654: ,itemkey => l_item_key
655: ,aname => 'OBJECT_ID'

Line 658: l_approver := wf_engine.getitemattrtext

654: ,itemkey => l_item_key
655: ,aname => 'OBJECT_ID'
656: );
657:
658: l_approver := wf_engine.getitemattrtext
659: (
660: itemtype => l_item_type
661: ,itemkey => l_item_key
662: ,aname => 'APPROVER'

Line 777: l_object := wf_engine.getitemattrtext

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

Line 784: l_object_id := wf_engine.getitemattrNumber

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

Line 791: l_approver := wf_engine.getitemattrtext

787: ,itemkey => l_item_key
788: ,aname => 'OBJECT_ID'
789: );
790:
791: l_approver := wf_engine.getitemattrtext
792: (
793: itemtype => l_item_type
794: ,itemkey => l_item_key
795: ,aname => 'APPROVER'

Line 911: l_object := wf_engine.getitemattrtext

907: l_hyphen_pos1 := INSTR(document_id, ':');
908: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
909: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
910:
911: l_object := wf_engine.getitemattrtext
912: (
913: itemtype => l_item_type
914: ,itemkey => l_item_key
915: ,aname => 'OBJECT_TYPE'

Line 918: l_object_id := wf_engine.getitemattrNumber

914: ,itemkey => l_item_key
915: ,aname => 'OBJECT_TYPE'
916: );
917:
918: l_object_id := wf_engine.getitemattrNumber
919: (
920: itemtype => l_item_type
921: ,itemkey => l_item_key
922: ,aname => 'OBJECT_ID'

Line 925: l_requester := wf_engine.getitemattrtext

921: ,itemkey => l_item_key
922: ,aname => 'OBJECT_ID'
923: );
924:
925: l_requester := wf_engine.getitemattrtext
926: (
927: itemtype => l_item_type
928: ,itemkey => l_item_key
929: ,aname => 'REQUESTER'

Line 934: l_requester_note := wf_engine.getitemattrtext

930: );
931: IF G_DEBUG='Y' THEN
932: AHL_DEBUG_PUB.debug('UC: NTF_APPROVAL --> l_requester='||l_requester);
933: END IF;
934: l_requester_note := wf_engine.getitemattrtext
935: (
936: itemtype => l_item_type
937: ,itemkey => l_item_key
938: ,aname => 'REQUESTER_NOTE'

Line 1052: l_object := wf_engine.getitemattrtext

1048: l_hyphen_pos1 := INSTR(document_id, ':');
1049: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1050: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1051:
1052: l_object := wf_engine.getitemattrtext
1053: (
1054: itemtype => l_item_type
1055: ,itemkey => l_item_key
1056: ,aname => 'OBJECT_TYPE'

Line 1059: l_object_id := wf_engine.getitemattrNumber

1055: ,itemkey => l_item_key
1056: ,aname => 'OBJECT_TYPE'
1057: );
1058:
1059: l_object_id := wf_engine.getitemattrNumber
1060: (
1061: itemtype => l_item_type
1062: ,itemkey => l_item_key
1063: ,aname => 'OBJECT_ID'

Line 1066: l_requester := wf_engine.getitemattrtext

1062: ,itemkey => l_item_key
1063: ,aname => 'OBJECT_ID'
1064: );
1065:
1066: l_requester := wf_engine.getitemattrtext
1067: (
1068: itemtype => l_item_type
1069: ,itemkey => l_item_key
1070: ,aname => 'REQUESTER'

Line 1076: l_requester_note := wf_engine.getitemattrtext

1072: IF G_DEBUG='Y' THEN
1073: AHL_DEBUG_PUB.debug('UC: NTF_APPROVAL_REMINDER -- l_requester='||l_requester);
1074: END IF;
1075:
1076: l_requester_note := wf_engine.getitemattrtext
1077: (
1078: itemtype => l_item_type
1079: ,itemkey => l_item_key
1080: ,aname => 'REQUESTER_NOTE'

Line 1192: l_object := wf_engine.getitemattrtext

1188: l_hyphen_pos1 := INSTR(document_id, ':');
1189: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1190: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1191:
1192: l_object := wf_engine.getitemattrtext
1193: (
1194: itemtype => l_item_type
1195: ,itemkey => l_item_key
1196: ,aname => 'OBJECT_TYPE'

Line 1199: l_object_id := wf_engine.getitemattrNumber

1195: ,itemkey => l_item_key
1196: ,aname => 'OBJECT_TYPE'
1197: );
1198:
1199: l_object_id := wf_engine.getitemattrNumber
1200: (
1201: itemtype => l_item_type
1202: ,itemkey => l_item_key
1203: ,aname => 'OBJECT_ID'

Line 1206: l_error_msg := wf_engine.getitemattrText

1202: ,itemkey => l_item_key
1203: ,aname => 'OBJECT_ID'
1204: );
1205:
1206: l_error_msg := wf_engine.getitemattrText
1207: (
1208: itemtype => l_item_type
1209: ,itemkey => l_item_key
1210: ,aname => 'ERROR_MSG'

Line 1333: l_approval_status := wf_engine.getitemattrtext

1329: -- RUN Mode
1330: --
1331: IF (funcmode = 'RUN') THEN
1332:
1333: l_approval_status := wf_engine.getitemattrtext
1334: (
1335: itemtype => itemtype,
1336: itemkey => itemkey,
1337: aname => 'UPDATE_GEN_STATUS'

Line 1345: /* l_original_status := wf_engine.getitemattrtext

1341: IF G_DEBUG='Y' THEN
1342: AHL_DEBUG_PUB.debug('UC: UPDATE_STATUS -- l_approval_status='||l_approval_status);
1343: END IF;
1344:
1345: /* l_original_status := wf_engine.getitemattrtext
1346: (
1347: itemtype => itemtype,
1348: itemkey => itemkey,
1349: aname => 'ORIG_STATUS_ID'

Line 1355: l_object_version_number := wf_engine.getitemattrnumber

1351: IF G_DEBUG='Y' THEN
1352: AHL_DEBUG_PUB.debug('UC: UPDATE_STATUS -- l_original_status='||l_original_status);
1353: END IF;
1354: */
1355: l_object_version_number := wf_engine.getitemattrnumber
1356: (
1357: itemtype => itemtype,
1358: itemkey => itemkey,
1359: aname => 'OBJECT_VER'

Line 1366: l_object_id := wf_engine.getitemattrnumber

1362: IF G_DEBUG='Y' THEN
1363: AHL_DEBUG_PUB.debug('UC: UPDATE_STATUS --> l_object_version_number='||l_object_version_number);
1364: END IF;
1365:
1366: l_object_id := wf_engine.getitemattrnumber
1367: (
1368: itemtype => itemtype,
1369: itemkey => itemkey,
1370: aname => 'OBJECT_ID'

Line 1564: l_next_status := wf_engine.getitemattrText

1560: -- RUN mode
1561: --
1562: IF (funcmode = 'RUN')
1563: THEN
1564: l_next_status := wf_engine.getitemattrText
1565: (
1566: itemtype => itemtype
1567: ,itemkey => itemkey
1568: ,aname => 'ORG_STATUS_ID'

Line 1574: l_object_version_number := wf_engine.getitemattrnumber

1570: IF G_DEBUG='Y' THEN
1571: AHL_DEBUG_PUB.debug('UC: REVERT_STATUS -- l_next_status'||l_next_status);
1572: END IF;
1573:
1574: l_object_version_number := wf_engine.getitemattrnumber
1575: (
1576: itemtype => itemtype
1577: ,itemkey => itemkey
1578: ,aname => 'OBJECT_VER'

Line 1585: l_object_id := wf_engine.getitemattrnumber

1581: IF G_DEBUG='Y' THEN
1582: AHL_DEBUG_PUB.debug('UC: REVERT_STATUS -- l_object_version_number'||l_object_version_number);
1583: END IF;
1584:
1585: l_object_id := wf_engine.getitemattrnumber
1586: (
1587: itemtype => itemtype
1588: ,itemkey => itemkey
1589: ,aname => 'OBJECT_ID'