DBA Data[Home] [Help]

APPS.AHL_PC_APPROVAL_PVT dependencies on WF_ENGINE

Line 52: l_object_id := wf_engine.getitemattrnumber

48: IF G_DEBUG='Y' THEN
49: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- Begin');
50: END IF;
51:
52: l_object_id := wf_engine.getitemattrnumber
53: (
54: itemtype => itemtype
55: ,itemkey => itemkey
56: ,aname => 'OBJECT_ID'

Line 88: wf_engine.setitemattrtext

84: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
85: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
86: l_subject := fnd_message.get;
87:
88: wf_engine.setitemattrtext
89: (
90: itemtype => itemtype
91: ,itemkey => itemkey
92: ,aname => 'FORWARD_SUBJECT'

Line 104: wf_engine.setitemattrtext

100: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
101: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
102: l_subject := fnd_message.get;
103:
104: wf_engine.setitemattrtext
105: (
106: itemtype => itemtype
107: ,itemkey => itemkey
108: ,aname => 'APPROVAL_SUBJECT'

Line 120: wf_engine.setitemattrtext

116: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
117: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
118: l_subject := fnd_message.get;
119:
120: wf_engine.setitemattrtext
121: (
122: itemtype => itemtype
123: ,itemkey => itemkey
124: ,aname => 'REJECT_SUBJECT'

Line 136: wf_engine.setitemattrtext

132: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
133: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
134: l_subject := fnd_message.get;
135:
136: wf_engine.setitemattrtext
137: (
138: itemtype => itemtype
139: ,itemkey => itemkey
140: ,aname => 'APPROVED_SUBJECT'

Line 152: wf_engine.setitemattrtext

148: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
149: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
150: l_subject := fnd_message.get;
151:
152: wf_engine.setitemattrtext
153: (
154: itemtype => itemtype
155: ,itemkey => itemkey
156: ,aname => 'FINAL_SUBJECT'

Line 168: wf_engine.setitemattrtext

164: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
165: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
166: l_subject := fnd_message.get;
167:
168: wf_engine.setitemattrtext
169: (
170: itemtype => itemtype
171: ,itemkey => itemkey
172: ,aname => 'REMIND_SUBJECT'

Line 184: wf_engine.setitemattrtext

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

Line 210: wf_engine.setitemattrnumber

206: END IF;
207:
208: IF l_return_status = FND_API.g_ret_sts_success
209: THEN
210: wf_engine.setitemattrnumber
211: (
212: itemtype => itemtype,
213: itemkey => itemkey,
214: aname => 'RULE_ID',

Line 221: wf_engine.setitemattrnumber

217: IF G_DEBUG='Y' THEN
218: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- RULE_ID='||l_approval_rule_id);
219: END IF;
220:
221: wf_engine.setitemattrnumber
222: (
223: itemtype => itemtype,
224: itemkey => itemkey,
225: aname => 'APPROVER_SEQ',

Line 348: l_object := wf_engine.getitemattrtext

344: l_hyphen_pos1 := INSTR(document_id, ':');
345: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
346: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
347:
348: l_object := wf_engine.getitemattrtext
349: (
350: itemtype => l_item_type
351: ,itemkey => l_item_key
352: ,aname => 'OBJECT_TYPE'

Line 355: l_object_id := wf_engine.getitemattrNumber

351: ,itemkey => l_item_key
352: ,aname => 'OBJECT_TYPE'
353: );
354:
355: l_object_id := wf_engine.getitemattrNumber
356: (
357: itemtype => l_item_type
358: ,itemkey => l_item_key
359: ,aname => 'OBJECT_ID'

Line 362: l_approver := wf_engine.getitemattrtext

358: ,itemkey => l_item_key
359: ,aname => 'OBJECT_ID'
360: );
361:
362: l_approver := wf_engine.getitemattrtext
363: (
364: itemtype => l_item_type
365: ,itemkey => l_item_key
366: ,aname => 'APPROVER'

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: (
480: itemtype => l_item_type
481: ,itemkey => l_item_key
482: ,aname => 'OBJECT_TYPE'

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: (
487: itemtype => l_item_type
488: ,itemkey => l_item_key
489: ,aname => 'OBJECT_ID'

Line 492: l_approver := wf_engine.getitemattrtext

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

Line 605: l_object := wf_engine.getitemattrtext

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

Line 612: l_object_id := wf_engine.getitemattrNumber

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

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: (
729: itemtype => l_item_type
730: ,itemkey => l_item_key
731: ,aname => 'OBJECT_TYPE'

Line 734: l_object_id := wf_engine.getitemattrNumber

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

Line 741: l_approver := wf_engine.getitemattrtext

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

Line 857: l_object := wf_engine.getitemattrtext

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

Line 864: l_object_id := wf_engine.getitemattrNumber

860: ,itemkey => l_item_key
861: ,aname => 'OBJECT_TYPE'
862: );
863:
864: l_object_id := wf_engine.getitemattrNumber
865: (
866: itemtype => l_item_type
867: ,itemkey => l_item_key
868: ,aname => 'OBJECT_ID'

Line 871: l_requester := wf_engine.getitemattrtext

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

Line 878: l_requester_note := wf_engine.getitemattrtext

874: ,itemkey => l_item_key
875: ,aname => 'REQUESTER'
876: );
877:
878: l_requester_note := wf_engine.getitemattrtext
879: (
880: itemtype => l_item_type
881: ,itemkey => l_item_key
882: ,aname => 'REQUESTER_NOTE'

Line 995: l_object := wf_engine.getitemattrtext

991: l_hyphen_pos1 := INSTR(document_id, ':');
992: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
993: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
994:
995: l_object := wf_engine.getitemattrtext
996: (
997: itemtype => l_item_type
998: ,itemkey => l_item_key
999: ,aname => 'OBJECT_TYPE'

Line 1002: l_object_id := wf_engine.getitemattrNumber

998: ,itemkey => l_item_key
999: ,aname => 'OBJECT_TYPE'
1000: );
1001:
1002: l_object_id := wf_engine.getitemattrNumber
1003: (
1004: itemtype => l_item_type
1005: ,itemkey => l_item_key
1006: ,aname => 'OBJECT_ID'

Line 1009: l_requester := wf_engine.getitemattrtext

1005: ,itemkey => l_item_key
1006: ,aname => 'OBJECT_ID'
1007: );
1008:
1009: l_requester := wf_engine.getitemattrtext
1010: (
1011: itemtype => l_item_type
1012: ,itemkey => l_item_key
1013: ,aname => 'REQUESTER'

Line 1016: l_requester_note := wf_engine.getitemattrtext

1012: ,itemkey => l_item_key
1013: ,aname => 'REQUESTER'
1014: );
1015:
1016: l_requester_note := wf_engine.getitemattrtext
1017: (
1018: itemtype => l_item_type
1019: ,itemkey => l_item_key
1020: ,aname => 'REQUESTER_NOTE'

Line 1131: l_object := wf_engine.getitemattrtext

1127: l_hyphen_pos1 := INSTR(document_id, ':');
1128: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1129: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1130:
1131: l_object := wf_engine.getitemattrtext
1132: (
1133: itemtype => l_item_type
1134: ,itemkey => l_item_key
1135: ,aname => 'OBJECT_TYPE'

Line 1138: l_object_id := wf_engine.getitemattrNumber

1134: ,itemkey => l_item_key
1135: ,aname => 'OBJECT_TYPE'
1136: );
1137:
1138: l_object_id := wf_engine.getitemattrNumber
1139: (
1140: itemtype => l_item_type
1141: ,itemkey => l_item_key
1142: ,aname => 'OBJECT_ID'

Line 1145: l_error_msg := wf_engine.getitemattrText

1141: ,itemkey => l_item_key
1142: ,aname => 'OBJECT_ID'
1143: );
1144:
1145: l_error_msg := wf_engine.getitemattrText
1146: (
1147: itemtype => l_item_type
1148: ,itemkey => l_item_key
1149: ,aname => 'ERROR_MSG'

Line 1278: l_approval_status := wf_engine.getitemattrtext

1274: -- RUN Mode
1275: --
1276: IF (funcmode = 'RUN')
1277: THEN
1278: l_approval_status := wf_engine.getitemattrtext
1279: (
1280: itemtype => itemtype
1281: ,itemkey => itemkey
1282: ,aname => 'UPDATE_GEN_STATUS'

Line 1291: l_next_status := wf_engine.getitemattrText

1287:
1288: /*
1289: IF l_approval_status = 'APPROVED'
1290: THEN
1291: l_next_status := wf_engine.getitemattrText
1292: (
1293: itemtype => itemtype
1294: ,itemkey => itemkey
1295: ,aname => 'NEW_STATUS_ID'

Line 1298: l_next_status := wf_engine.getitemattrText

1294: ,itemkey => itemkey
1295: ,aname => 'NEW_STATUS_ID'
1296: );
1297: ELSE
1298: l_next_status := wf_engine.getitemattrText
1299: (
1300: itemtype => itemtype
1301: ,itemkey => itemkey
1302: ,aname => 'REJECT_STATUS_ID'

Line 1313: l_object_version_number := wf_engine.getitemattrnumber

1309: */
1310:
1311: l_next_status := l_approval_status;
1312:
1313: l_object_version_number := wf_engine.getitemattrnumber
1314: (
1315: itemtype => itemtype
1316: ,itemkey => itemkey
1317: ,aname => 'OBJECT_VER'

Line 1323: l_object_id := wf_engine.getitemattrnumber

1319: IF G_DEBUG='Y' THEN
1320: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number='||l_object_version_number);
1321: END IF;
1322:
1323: l_object_id := wf_engine.getitemattrnumber
1324: (
1325: itemtype => itemtype
1326: ,itemkey => itemkey
1327: ,aname => 'OBJECT_ID'

Line 1331: l_bue_msg := wf_engine.getitemattrText

1327: ,aname => 'OBJECT_ID'
1328: );
1329:
1330: -- AJPRASAN:: Bug #9596384 - Retrieve the attribute 'REQUESTER_NOTE' which stores a hint on whether to run BUE or not, as per the logic mentioned in AHL_PC_HEADER_PVT.INITIATE_PC_APPROVAL
1331: l_bue_msg := wf_engine.getitemattrText
1332: (
1333: itemtype => itemtype
1334: ,itemkey => itemkey
1335: ,aname => 'REQUESTER_NOTE'

Line 1525: l_next_status := wf_engine.getitemattrText

1521: -- RUN mode
1522: --
1523: IF (funcmode = 'RUN')
1524: THEN
1525: l_next_status := wf_engine.getitemattrText
1526: (
1527: itemtype => itemtype
1528: ,itemkey => itemkey
1529: ,aname => 'ORG_STATUS_ID'

Line 1535: l_object_version_number := wf_engine.getitemattrnumber

1531: IF G_DEBUG='Y' THEN
1532: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status'||l_next_status);
1533: END IF;
1534:
1535: l_object_version_number := wf_engine.getitemattrnumber
1536: (
1537: itemtype => itemtype
1538: ,itemkey => itemkey
1539: ,aname => 'OBJECT_VER'

Line 1545: l_object_id := wf_engine.getitemattrnumber

1541: IF G_DEBUG='Y' THEN
1542: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number'||l_object_version_number);
1543: END IF;
1544:
1545: l_object_id := wf_engine.getitemattrnumber
1546: (
1547: itemtype => itemtype
1548: ,itemkey => itemkey
1549: ,aname => 'OBJECT_ID'