DBA Data[Home] [Help]

APPS.AHL_ROUTE_APPROVAL_PVT dependencies on WF_ENGINE

Line 49: l_object_id := wf_engine.getitemattrnumber(

45: fnd_msg_pub.initialize;
46:
47: l_return_status := fnd_api.g_ret_sts_success;
48:
49: l_object_id := wf_engine.getitemattrnumber(
50: itemtype => itemtype
51: ,itemkey => itemkey
52: ,aname => 'OBJECT_ID'
53: );

Line 80: wf_engine.setitemattrtext(

76: AHL_DEBUG_PUB.debug( 'Route No'||l_route_rec.route_no,'+DebugWfRoute+');
77: AHL_DEBUG_PUB.debug( 'Subject:'||l_subject,'+DebugWfRoute+');
78: END IF;
79:
80: wf_engine.setitemattrtext(
81: itemtype => itemtype
82: ,itemkey => itemkey
83: ,aname => 'FORWARD_SUBJECT'
84: ,avalue => l_subject);

Line 85: wf_engine.setitemattrtext(

81: itemtype => itemtype
82: ,itemkey => itemkey
83: ,aname => 'FORWARD_SUBJECT'
84: ,avalue => l_subject);
85: wf_engine.setitemattrtext(
86: itemtype => itemtype
87: ,itemkey => itemkey
88: ,aname => 'APPROVAL_SUBJECT'
89: ,avalue => l_subject);

Line 92: wf_engine.setitemattrtext(

88: ,aname => 'APPROVAL_SUBJECT'
89: ,avalue => l_subject);
90:
91:
92: wf_engine.setitemattrtext(
93: itemtype => itemtype
94: ,itemkey => itemkey
95: ,aname => 'REJECT_SUBJECT'
96: ,avalue => l_subject);

Line 99: wf_engine.setitemattrtext(

95: ,aname => 'REJECT_SUBJECT'
96: ,avalue => l_subject);
97:
98:
99: wf_engine.setitemattrtext(
100: itemtype => itemtype
101: ,itemkey => itemkey
102: ,aname => 'APPROVED_SUBJECT'
103: ,avalue => l_subject);

Line 105: wf_engine.setitemattrtext(

101: ,itemkey => itemkey
102: ,aname => 'APPROVED_SUBJECT'
103: ,avalue => l_subject);
104:
105: wf_engine.setitemattrtext(
106: itemtype => itemtype
107: ,itemkey => itemkey
108: ,aname => 'APPROVED_SUBJECT'
109: ,avalue => l_subject);

Line 111: wf_engine.setitemattrtext(

107: ,itemkey => itemkey
108: ,aname => 'APPROVED_SUBJECT'
109: ,avalue => l_subject);
110:
111: wf_engine.setitemattrtext(
112: itemtype => itemtype
113: ,itemkey => itemkey
114: ,aname => 'FINAL_SUBJECT'
115: ,avalue => l_subject);

Line 117: wf_engine.setitemattrtext(

113: ,itemkey => itemkey
114: ,aname => 'FINAL_SUBJECT'
115: ,avalue => l_subject);
116:
117: wf_engine.setitemattrtext(
118: itemtype => itemtype
119: ,itemkey => itemkey
120: ,aname => 'REMIND_SUBJECT'
121: ,avalue => l_subject);

Line 123: wf_engine.setitemattrtext(

119: ,itemkey => itemkey
120: ,aname => 'REMIND_SUBJECT'
121: ,avalue => l_subject);
122:
123: wf_engine.setitemattrtext(
124: itemtype => itemtype
125: ,itemkey => itemkey
126: ,aname => 'ERROR_SUBJECT'
127: ,avalue => l_subject

Line 159: wf_engine.setitemattrnumber(

155: END IF;
156:
157: IF l_return_status = fnd_api.g_ret_sts_success THEN
158:
159: wf_engine.setitemattrnumber(
160: itemtype => itemtype,
161: itemkey => itemkey,
162: aname => 'RULE_ID',
163: avalue => l_approval_rule_id

Line 166: wf_engine.setitemattrnumber(

162: aname => 'RULE_ID',
163: avalue => l_approval_rule_id
164: );
165:
166: wf_engine.setitemattrnumber(
167: itemtype => itemtype,
168: itemkey => itemkey,
169: aname => 'APPROVER_SEQ',
170: avalue => l_approver_seq

Line 286: l_object := wf_engine.getitemattrtext(

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

Line 292: l_object_id := wf_engine.getitemattrNumber(

288: ,itemkey => l_item_key
289: ,aname => 'OBJECT_TYPE'
290: );
291:
292: l_object_id := wf_engine.getitemattrNumber(
293: itemtype => l_item_type
294: ,itemkey => l_item_key
295: ,aname => 'OBJECT_ID'
296: );

Line 298: l_approver := wf_engine.getitemattrtext(

294: ,itemkey => l_item_key
295: ,aname => 'OBJECT_ID'
296: );
297:
298: l_approver := wf_engine.getitemattrtext(
299: itemtype => l_item_type
300: ,itemkey => l_item_key
301: ,aname => 'APPROVER'
302: );

Line 396: l_object := wf_engine.getitemattrtext(

392: l_hyphen_pos1 := INSTR(document_id, ':');
393: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
394: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
395:
396: l_object := wf_engine.getitemattrtext(
397: itemtype => l_item_type
398: ,itemkey => l_item_key
399: ,aname => 'OBJECT_TYPE'
400: );

Line 402: l_object_id := wf_engine.getitemattrNumber(

398: ,itemkey => l_item_key
399: ,aname => 'OBJECT_TYPE'
400: );
401:
402: l_object_id := wf_engine.getitemattrNumber(
403: itemtype => l_item_type
404: ,itemkey => l_item_key
405: ,aname => 'OBJECT_ID'
406: );

Line 408: l_approver := wf_engine.getitemattrtext(

404: ,itemkey => l_item_key
405: ,aname => 'OBJECT_ID'
406: );
407:
408: l_approver := wf_engine.getitemattrtext(
409: itemtype => l_item_type
410: ,itemkey => l_item_key
411: ,aname => 'APPROVER'
412: );

Line 516: l_object := wf_engine.getitemattrtext(

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

Line 522: l_object_id := wf_engine.getitemattrNumber(

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

Line 628: l_object := wf_engine.getitemattrtext(

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

Line 634: l_object_id := wf_engine.getitemattrNumber(

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

Line 640: l_approver := wf_engine.getitemattrtext(

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

Line 741: l_object := wf_engine.getitemattrtext(

737: l_hyphen_pos1 := INSTR(document_id, ':');
738: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
739: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
740:
741: l_object := wf_engine.getitemattrtext(
742: itemtype => l_item_type
743: ,itemkey => l_item_key
744: ,aname => 'OBJECT_TYPE'
745: );

Line 747: l_object_id := wf_engine.getitemattrNumber(

743: ,itemkey => l_item_key
744: ,aname => 'OBJECT_TYPE'
745: );
746:
747: l_object_id := wf_engine.getitemattrNumber(
748: itemtype => l_item_type
749: ,itemkey => l_item_key
750: ,aname => 'OBJECT_ID'
751: );

Line 753: l_requester := wf_engine.getitemattrtext(

749: ,itemkey => l_item_key
750: ,aname => 'OBJECT_ID'
751: );
752:
753: l_requester := wf_engine.getitemattrtext(
754: itemtype => l_item_type
755: ,itemkey => l_item_key
756: ,aname => 'REQUESTER'
757: );

Line 759: l_requester_note := wf_engine.getitemattrtext(

755: ,itemkey => l_item_key
756: ,aname => 'REQUESTER'
757: );
758:
759: l_requester_note := wf_engine.getitemattrtext(
760: itemtype => l_item_type
761: ,itemkey => l_item_key
762: ,aname => 'REQUESTER_NOTE'
763: );

Line 868: l_object := wf_engine.getitemattrtext(

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

Line 874: l_object_id := wf_engine.getitemattrNumber(

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

Line 880: l_requester := wf_engine.getitemattrtext(

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

Line 886: l_requester_note := wf_engine.getitemattrtext(

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

Line 994: l_object := wf_engine.getitemattrtext(

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

Line 1000: l_object_id := wf_engine.getitemattrNumber(

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

Line 1006: l_error_msg := wf_engine.getitemattrText(

1002: ,itemkey => l_item_key
1003: ,aname => 'OBJECT_ID'
1004: );
1005:
1006: l_error_msg := wf_engine.getitemattrText(
1007: itemtype => l_item_type
1008: ,itemkey => l_item_key
1009: ,aname => 'ERROR_MSG'
1010: );

Line 1120: l_approval_status := wf_engine.getitemattrtext(

1116: AHL_DEBUG_PUB.debug( 'Start UpdateStatus','+DebugWfRoute+');
1117: END IF;
1118:
1119: IF funcmode = 'RUN' THEN
1120: l_approval_status := wf_engine.getitemattrtext(
1121: itemtype => itemtype
1122: ,itemkey => itemkey
1123: ,aname => 'UPDATE_GEN_STATUS'
1124: );

Line 1130: l_next_status := wf_engine.getitemattrText(

1126: AHL_DEBUG_PUB.debug( 'After GetItemAttrText UpdateStatus','+DebugWfRoute+');
1127: END IF;
1128:
1129: IF l_approval_status = 'APPROVED' THEN
1130: l_next_status := wf_engine.getitemattrText(
1131: itemtype => itemtype
1132: ,itemkey => itemkey
1133: ,aname => 'NEW_STATUS_ID'
1134: );

Line 1137: l_next_status := wf_engine.getitemattrText(

1133: ,aname => 'NEW_STATUS_ID'
1134: );
1135:
1136: ELSE
1137: l_next_status := wf_engine.getitemattrText(
1138: itemtype => itemtype
1139: ,itemkey => itemkey
1140: ,aname => 'REJECT_STATUS_ID'
1141: );

Line 1144: l_object_version_number := wf_engine.getitemattrnumber(

1140: ,aname => 'REJECT_STATUS_ID'
1141: );
1142: END IF;
1143:
1144: l_object_version_number := wf_engine.getitemattrnumber(
1145: itemtype => itemtype
1146: ,itemkey => itemkey
1147: ,aname => 'OBJECT_VER'
1148: );

Line 1149: l_object_id := wf_engine.getitemattrnumber(

1145: itemtype => itemtype
1146: ,itemkey => itemkey
1147: ,aname => 'OBJECT_VER'
1148: );
1149: l_object_id := wf_engine.getitemattrnumber(
1150: itemtype => itemtype
1151: ,itemkey => itemkey
1152: ,aname => 'OBJECT_ID'
1153: );

Line 1157: l_approver_note := wf_engine.GetItemAttrText(

1153: );
1154:
1155: l_status_date := SYSDATE;
1156:
1157: l_approver_note := wf_engine.GetItemAttrText(
1158: itemtype => itemtype,
1159: itemkey => itemkey,
1160: aname => 'APPROVER NOTE' );
1161:

Line 1301: l_next_status := wf_engine.getitemattrText(

1297: END IF;
1298:
1299: l_return_Status:='S';
1300: IF funcmode = 'RUN' THEN
1301: l_next_status := wf_engine.getitemattrText(
1302: itemtype => itemtype
1303: ,itemkey => itemkey
1304: ,aname => 'ORG_STATUS_ID'
1305: );

Line 1307: l_object_version_number := wf_engine.getitemattrnumber(

1303: ,itemkey => itemkey
1304: ,aname => 'ORG_STATUS_ID'
1305: );
1306:
1307: l_object_version_number := wf_engine.getitemattrnumber(
1308: itemtype => itemtype
1309: ,itemkey => itemkey
1310: ,aname => 'OBJECT_VER'
1311: );

Line 1312: l_object_id := wf_engine.getitemattrnumber(

1308: itemtype => itemtype
1309: ,itemkey => itemkey
1310: ,aname => 'OBJECT_VER'
1311: );
1312: l_object_id := wf_engine.getitemattrnumber(
1313: itemtype => itemtype
1314: ,itemkey => itemkey
1315: ,aname => 'OBJECT_ID'
1316: );