DBA Data[Home] [Help]

APPS.AHL_OPERATIONS_APPROVAL_PVT dependencies on WF_ENGINE

Line 70: l_object_id := wf_engine.getitemattrnumber(

66: fnd_msg_pub.initialize;
67:
68: l_return_status :=fnd_api.g_ret_sts_success;
69:
70: l_object_id := wf_engine.getitemattrnumber(
71: itemtype => itemtype
72: ,itemkey => itemkey
73: ,aname => 'OBJECT_ID'
74: );

Line 114: wf_engine.setitemattrtext(

110: l_subject_err:= l_subject_err||to_char(l_object_id);
111: END IF;
112: CLOSE GetOperationDet;
113:
114: wf_engine.setitemattrtext(
115: itemtype => itemtype,
116: itemkey => itemkey,
117: aname => 'FORWARD_SUBJECT',
118: avalue => l_subject_apr);

Line 120: wf_engine.setitemattrtext(

116: itemkey => itemkey,
117: aname => 'FORWARD_SUBJECT',
118: avalue => l_subject_apr);
119:
120: wf_engine.setitemattrtext(
121: itemtype => itemtype,
122: itemkey => itemkey,
123: aname => 'APPROVAL_SUBJECT',
124: avalue => l_subject);

Line 126: wf_engine.setitemattrtext(

122: itemkey => itemkey,
123: aname => 'APPROVAL_SUBJECT',
124: avalue => l_subject);
125:
126: wf_engine.setitemattrtext(
127: itemtype => itemtype,
128: itemkey => itemkey,
129: aname => 'REJECT_SUBJECT',
130: avalue => l_subject_rej);

Line 132: wf_engine.setitemattrtext(

128: itemkey => itemkey,
129: aname => 'REJECT_SUBJECT',
130: avalue => l_subject_rej);
131:
132: wf_engine.setitemattrtext(
133: itemtype => itemtype,
134: itemkey => itemkey,
135: aname => 'APPROVED_SUBJECT',
136: avalue => l_subject);

Line 138: wf_engine.setitemattrtext(

134: itemkey => itemkey,
135: aname => 'APPROVED_SUBJECT',
136: avalue => l_subject);
137:
138: wf_engine.setitemattrtext(
139: itemtype => itemtype,
140: itemkey => itemkey,
141: aname => 'FINAL_SUBJECT',
142: avalue => l_subject);

Line 144: wf_engine.setitemattrtext(

140: itemkey => itemkey,
141: aname => 'FINAL_SUBJECT',
142: avalue => l_subject);
143:
144: wf_engine.setitemattrtext(
145: itemtype => itemtype,
146: itemkey => itemkey,
147: aname => 'REMIND_SUBJECT',
148: avalue => l_subject);

Line 150: wf_engine.setitemattrtext(

146: itemkey => itemkey,
147: aname => 'REMIND_SUBJECT',
148: avalue => l_subject);
149:
150: wf_engine.setitemattrtext(
151: itemtype => itemtype,
152: itemkey => itemkey,
153: aname => 'ERROR_SUBJECT',
154: avalue => l_subject_err);

Line 171: wf_engine.setitemattrnumber(

167: );
168:
169: IF l_return_status = fnd_api.g_ret_sts_success THEN
170:
171: wf_engine.setitemattrnumber(
172: itemtype => itemtype,
173: itemkey => itemkey,
174: aname => 'RULE_ID',
175: avalue => l_approval_rule_id

Line 178: wf_engine.setitemattrnumber(

174: aname => 'RULE_ID',
175: avalue => l_approval_rule_id
176: );
177:
178: wf_engine.setitemattrnumber(
179: itemtype => itemtype,
180: itemkey => itemkey,
181: aname => 'APPROVER_SEQ',
182: avalue => l_approver_seq

Line 283: l_object := wf_engine.getitemattrtext(

279: l_hyphen_pos1 := INSTR(document_id, ':');
280: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
281: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
282:
283: l_object := wf_engine.getitemattrtext(
284: itemtype => l_item_type,
285: itemkey => l_item_key,
286: aname => 'OBJECT_TYPE');
287:

Line 288: l_object_id := wf_engine.getitemattrNumber(

284: itemtype => l_item_type,
285: itemkey => l_item_key,
286: aname => 'OBJECT_TYPE');
287:
288: l_object_id := wf_engine.getitemattrNumber(
289: itemtype => l_item_type,
290: itemkey => l_item_key,
291: aname => 'OBJECT_ID');
292:

Line 293: l_approver := wf_engine.getitemattrtext(

289: itemtype => l_item_type,
290: itemkey => l_item_key,
291: aname => 'OBJECT_ID');
292:
293: l_approver := wf_engine.getitemattrtext(
294: itemtype => l_item_type,
295: itemkey => l_item_key,
296: aname => 'APPROVER');
297:

Line 404: l_object := wf_engine.getitemattrtext(

400: l_hyphen_pos1 := INSTR(document_id, ':');
401: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
402: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
403:
404: l_object := wf_engine.getitemattrtext(
405: itemtype => l_item_type
406: ,itemkey => l_item_key
407: ,aname => 'OBJECT_TYPE'
408: );

Line 410: l_object_id := wf_engine.getitemattrNumber(

406: ,itemkey => l_item_key
407: ,aname => 'OBJECT_TYPE'
408: );
409:
410: l_object_id := wf_engine.getitemattrNumber(
411: itemtype => l_item_type
412: ,itemkey => l_item_key
413: ,aname => 'OBJECT_ID'
414: );

Line 416: l_approver := wf_engine.getitemattrtext(

412: ,itemkey => l_item_key
413: ,aname => 'OBJECT_ID'
414: );
415:
416: l_approver := wf_engine.getitemattrtext(
417: itemtype => l_item_type
418: ,itemkey => l_item_key
419: ,aname => 'APPROVER'
420: );

Line 519: l_object := wf_engine.getitemattrtext(

515: l_hyphen_pos1 := INSTR(document_id, ':');
516: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
517: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
518:
519: l_object := wf_engine.getitemattrtext(
520: itemtype => l_item_type
521: ,itemkey => l_item_key
522: ,aname => 'OBJECT_TYPE'
523: );

Line 525: l_object_id := wf_engine.getitemattrNumber(

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

Line 626: l_object := wf_engine.getitemattrtext(

622: l_hyphen_pos1 := INSTR(document_id, ':');
623: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
624: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
625:
626: l_object := wf_engine.getitemattrtext(
627: itemtype => l_item_type
628: ,itemkey => l_item_key
629: ,aname => 'OBJECT_TYPE'
630: );

Line 632: l_object_id := wf_engine.getitemattrNumber(

628: ,itemkey => l_item_key
629: ,aname => 'OBJECT_TYPE'
630: );
631:
632: l_object_id := wf_engine.getitemattrNumber(
633: itemtype => l_item_type
634: ,itemkey => l_item_key
635: ,aname => 'OBJECT_ID'
636: );

Line 638: l_approver := wf_engine.getitemattrtext(

634: ,itemkey => l_item_key
635: ,aname => 'OBJECT_ID'
636: );
637:
638: l_approver := wf_engine.getitemattrtext(
639: itemtype => l_item_type
640: ,itemkey => l_item_key
641: ,aname => 'APPROVER'
642: );

Line 745: l_object := wf_engine.getitemattrtext(

741: l_hyphen_pos1 := INSTR(document_id, ':');
742: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
743: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
744:
745: l_object := wf_engine.getitemattrtext(
746: itemtype => l_item_type
747: ,itemkey => l_item_key
748: ,aname => 'OBJECT_TYPE'
749: );

Line 751: l_object_id := wf_engine.getitemattrNumber(

747: ,itemkey => l_item_key
748: ,aname => 'OBJECT_TYPE'
749: );
750:
751: l_object_id := wf_engine.getitemattrNumber(
752: itemtype => l_item_type
753: ,itemkey => l_item_key
754: ,aname => 'OBJECT_ID'
755: );

Line 757: l_requester := wf_engine.getitemattrtext(

753: ,itemkey => l_item_key
754: ,aname => 'OBJECT_ID'
755: );
756:
757: l_requester := wf_engine.getitemattrtext(
758: itemtype => l_item_type
759: ,itemkey => l_item_key
760: ,aname => 'REQUESTER'
761: );

Line 763: l_requester_note := wf_engine.getitemattrtext(

759: ,itemkey => l_item_key
760: ,aname => 'REQUESTER'
761: );
762:
763: l_requester_note := wf_engine.getitemattrtext(
764: itemtype => l_item_type
765: ,itemkey => l_item_key
766: ,aname => 'REQUESTER_NOTE'
767: );

Line 871: l_object := wf_engine.getitemattrtext(

867: l_hyphen_pos1 := INSTR(document_id, ':');
868: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
869: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
870:
871: l_object := wf_engine.getitemattrtext(
872: itemtype => l_item_type
873: ,itemkey => l_item_key
874: ,aname => 'OBJECT_TYPE'
875: );

Line 877: l_object_id := wf_engine.getitemattrNumber(

873: ,itemkey => l_item_key
874: ,aname => 'OBJECT_TYPE'
875: );
876:
877: l_object_id := wf_engine.getitemattrNumber(
878: itemtype => l_item_type
879: ,itemkey => l_item_key
880: ,aname => 'OBJECT_ID'
881: );

Line 883: l_requester := wf_engine.getitemattrtext(

879: ,itemkey => l_item_key
880: ,aname => 'OBJECT_ID'
881: );
882:
883: l_requester := wf_engine.getitemattrtext(
884: itemtype => l_item_type
885: ,itemkey => l_item_key
886: ,aname => 'REQUESTER'
887: );

Line 889: l_requester_note := wf_engine.getitemattrtext(

885: ,itemkey => l_item_key
886: ,aname => 'REQUESTER'
887: );
888:
889: l_requester_note := wf_engine.getitemattrtext(
890: itemtype => l_item_type
891: ,itemkey => l_item_key
892: ,aname => 'REQUESTER_NOTE'
893: );

Line 1001: l_object := wf_engine.getitemattrtext(

997: l_hyphen_pos1 := INSTR(document_id, ':');
998: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
999: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1000:
1001: l_object := wf_engine.getitemattrtext(
1002: itemtype => l_item_type
1003: ,itemkey => l_item_key
1004: ,aname => 'OBJECT_TYPE'
1005: );

Line 1007: l_object_id := wf_engine.getitemattrNumber(

1003: ,itemkey => l_item_key
1004: ,aname => 'OBJECT_TYPE'
1005: );
1006:
1007: l_object_id := wf_engine.getitemattrNumber(
1008: itemtype => l_item_type
1009: ,itemkey => l_item_key
1010: ,aname => 'OBJECT_ID'
1011: );

Line 1013: l_error_msg := wf_engine.getitemattrText(

1009: ,itemkey => l_item_key
1010: ,aname => 'OBJECT_ID'
1011: );
1012:
1013: l_error_msg := wf_engine.getitemattrText(
1014: itemtype => l_item_type
1015: ,itemkey => l_item_key
1016: ,aname => 'ERROR_MSG'
1017: );

Line 1127: l_approval_status := wf_engine.getitemattrtext(

1123: AHL_DEBUG_PUB.debug( 'Start UpdateStatus','+DebugWfOper+');
1124: END IF;
1125:
1126: IF funcmode = 'RUN' THEN
1127: l_approval_status := wf_engine.getitemattrtext(
1128: itemtype => itemtype
1129: ,itemkey => itemkey
1130: ,aname => 'UPDATE_GEN_STATUS'
1131: );

Line 1137: l_next_status := wf_engine.getitemattrText(

1133: AHL_DEBUG_PUB.debug( 'Update Status After Getitemattrtext','+DebugWfOper+');
1134: END IF;
1135:
1136: IF l_approval_status = 'APPROVED' THEN
1137: l_next_status := wf_engine.getitemattrText(
1138: itemtype => itemtype
1139: ,itemkey => itemkey
1140: ,aname => 'NEW_STATUS_ID'
1141: );

Line 1144: l_next_status := wf_engine.getitemattrText(

1140: ,aname => 'NEW_STATUS_ID'
1141: );
1142:
1143: ELSE
1144: l_next_status := wf_engine.getitemattrText(
1145: itemtype => itemtype
1146: ,itemkey => itemkey
1147: ,aname => 'REJECT_STATUS_ID'
1148: );

Line 1151: l_object_version_number := wf_engine.getitemattrnumber(

1147: ,aname => 'REJECT_STATUS_ID'
1148: );
1149: END IF;
1150:
1151: l_object_version_number := wf_engine.getitemattrnumber(
1152: itemtype => itemtype
1153: ,itemkey => itemkey
1154: ,aname => 'OBJECT_VER'
1155: );

Line 1156: l_object_id := wf_engine.getitemattrnumber(

1152: itemtype => itemtype
1153: ,itemkey => itemkey
1154: ,aname => 'OBJECT_VER'
1155: );
1156: l_object_id := wf_engine.getitemattrnumber(
1157: itemtype => itemtype
1158: ,itemkey => itemkey
1159: ,aname => 'OBJECT_ID'
1160: );

Line 1164: l_approver_note := wf_engine.GetItemAttrText(

1160: );
1161:
1162: l_status_date := SYSDATE;
1163:
1164: l_approver_note := wf_engine.GetItemAttrText(
1165: itemtype => itemtype,
1166: itemkey => itemkey,
1167: aname => 'APPROVER NOTE' );
1168:

Line 1297: l_next_status := wf_engine.getitemattrText(

1293: END IF;
1294:
1295: l_return_Status:='S';
1296: IF funcmode = 'RUN' THEN
1297: l_next_status := wf_engine.getitemattrText(
1298: itemtype => itemtype
1299: ,itemkey => itemkey
1300: ,aname => 'ORG_STATUS_ID'
1301: );

Line 1303: l_object_version_number := wf_engine.getitemattrnumber(

1299: ,itemkey => itemkey
1300: ,aname => 'ORG_STATUS_ID'
1301: );
1302:
1303: l_object_version_number := wf_engine.getitemattrnumber(
1304: itemtype => itemtype
1305: ,itemkey => itemkey
1306: ,aname => 'OBJECT_VER'
1307: );

Line 1308: l_object_id := wf_engine.getitemattrnumber(

1304: itemtype => itemtype
1305: ,itemkey => itemkey
1306: ,aname => 'OBJECT_VER'
1307: );
1308: l_object_id := wf_engine.getitemattrnumber(
1309: itemtype => itemtype
1310: ,itemkey => itemkey
1311: ,aname => 'OBJECT_ID'
1312: );