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 1273: l_approval_status := wf_engine.getitemattrtext

1269: -- RUN Mode
1270: --
1271: IF (funcmode = 'RUN')
1272: THEN
1273: l_approval_status := wf_engine.getitemattrtext
1274: (
1275: itemtype => itemtype
1276: ,itemkey => itemkey
1277: ,aname => 'UPDATE_GEN_STATUS'

Line 1286: l_next_status := wf_engine.getitemattrText

1282:
1283: /*
1284: IF l_approval_status = 'APPROVED'
1285: THEN
1286: l_next_status := wf_engine.getitemattrText
1287: (
1288: itemtype => itemtype
1289: ,itemkey => itemkey
1290: ,aname => 'NEW_STATUS_ID'

Line 1293: l_next_status := wf_engine.getitemattrText

1289: ,itemkey => itemkey
1290: ,aname => 'NEW_STATUS_ID'
1291: );
1292: ELSE
1293: l_next_status := wf_engine.getitemattrText
1294: (
1295: itemtype => itemtype
1296: ,itemkey => itemkey
1297: ,aname => 'REJECT_STATUS_ID'

Line 1308: l_object_version_number := wf_engine.getitemattrnumber

1304: */
1305:
1306: l_next_status := l_approval_status;
1307:
1308: l_object_version_number := wf_engine.getitemattrnumber
1309: (
1310: itemtype => itemtype
1311: ,itemkey => itemkey
1312: ,aname => 'OBJECT_VER'

Line 1318: l_object_id := wf_engine.getitemattrnumber

1314: IF G_DEBUG='Y' THEN
1315: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number='||l_object_version_number);
1316: END IF;
1317:
1318: l_object_id := wf_engine.getitemattrnumber
1319: (
1320: itemtype => itemtype
1321: ,itemkey => itemkey
1322: ,aname => 'OBJECT_ID'

Line 1500: l_next_status := wf_engine.getitemattrText

1496: -- RUN mode
1497: --
1498: IF (funcmode = 'RUN')
1499: THEN
1500: l_next_status := wf_engine.getitemattrText
1501: (
1502: itemtype => itemtype
1503: ,itemkey => itemkey
1504: ,aname => 'ORG_STATUS_ID'

Line 1510: l_object_version_number := wf_engine.getitemattrnumber

1506: IF G_DEBUG='Y' THEN
1507: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status'||l_next_status);
1508: END IF;
1509:
1510: l_object_version_number := wf_engine.getitemattrnumber
1511: (
1512: itemtype => itemtype
1513: ,itemkey => itemkey
1514: ,aname => 'OBJECT_VER'

Line 1520: l_object_id := wf_engine.getitemattrnumber

1516: IF G_DEBUG='Y' THEN
1517: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number'||l_object_version_number);
1518: END IF;
1519:
1520: l_object_id := wf_engine.getitemattrnumber
1521: (
1522: itemtype => itemtype
1523: ,itemkey => itemkey
1524: ,aname => 'OBJECT_ID'