DBA Data[Home] [Help]

APPS.AHL_ITEMGROUPS_APPROVAL_PVT dependencies on WF_ENGINE

Line 77: l_object_id := wf_engine.getitemattrnumber(

73: fnd_msg_pub.initialize;
74:
75: l_return_status := fnd_api.g_ret_sts_success;
76:
77: l_object_id := wf_engine.getitemattrnumber(
78: itemtype => itemtype
79: ,itemkey => itemkey
80: ,aname => 'OBJECT_ID'
81: );

Line 115: wf_engine.setitemattrtext(

111:
112: END IF;
113:
114:
115: wf_engine.setitemattrtext(
116: itemtype => itemtype
117: ,itemkey => itemkey
118: ,aname => 'FORWARD_SUBJECT'
119: ,avalue => l_subject);

Line 120: wf_engine.setitemattrtext(

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

Line 127: wf_engine.setitemattrtext(

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

Line 134: wf_engine.setitemattrtext(

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

Line 140: wf_engine.setitemattrtext(

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

Line 146: wf_engine.setitemattrtext(

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

Line 152: wf_engine.setitemattrtext(

148: ,itemkey => itemkey
149: ,aname => 'FINAL_SUBJECT'
150: ,avalue => l_subject);
151:
152: wf_engine.setitemattrtext(
153: itemtype => itemtype
154: ,itemkey => itemkey
155: ,aname => 'REMIND_SUBJECT'
156: ,avalue => l_subject);

Line 158: wf_engine.setitemattrtext(

154: ,itemkey => itemkey
155: ,aname => 'REMIND_SUBJECT'
156: ,avalue => l_subject);
157:
158: wf_engine.setitemattrtext(
159: itemtype => itemtype
160: ,itemkey => itemkey
161: ,aname => 'ERROR_SUBJECT'
162: ,avalue => l_subject

Line 205: wf_engine.setitemattrnumber(

201: END IF;
202:
203: IF l_return_status = fnd_api.g_ret_sts_success THEN
204:
205: wf_engine.setitemattrnumber(
206: itemtype => itemtype,
207: itemkey => itemkey,
208: aname => 'RULE_ID',
209: avalue => l_approval_rule_id

Line 212: wf_engine.setitemattrnumber(

208: aname => 'RULE_ID',
209: avalue => l_approval_rule_id
210: );
211:
212: wf_engine.setitemattrnumber(
213: itemtype => itemtype,
214: itemkey => itemkey,
215: aname => 'APPROVER_SEQ',
216: avalue => l_approver_seq

Line 344: l_object := wf_engine.getitemattrtext(

340: l_hyphen_pos1 := INSTR(document_id, ':');
341: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
342: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
343:
344: l_object := wf_engine.getitemattrtext(
345: itemtype => l_item_type
346: ,itemkey => l_item_key
347: ,aname => 'OBJECT_TYPE'
348: );

Line 350: l_object_id := wf_engine.getitemattrNumber(

346: ,itemkey => l_item_key
347: ,aname => 'OBJECT_TYPE'
348: );
349:
350: l_object_id := wf_engine.getitemattrNumber(
351: itemtype => l_item_type
352: ,itemkey => l_item_key
353: ,aname => 'OBJECT_ID'
354: );

Line 356: l_approver := wf_engine.getitemattrtext(

352: ,itemkey => l_item_key
353: ,aname => 'OBJECT_ID'
354: );
355:
356: l_approver := wf_engine.getitemattrtext(
357: itemtype => l_item_type
358: ,itemkey => l_item_key
359: ,aname => 'APPROVER'
360: );

Line 468: l_object := wf_engine.getitemattrtext(

464: l_hyphen_pos1 := INSTR(document_id, ':');
465: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
466: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
467:
468: l_object := wf_engine.getitemattrtext(
469: itemtype => l_item_type
470: ,itemkey => l_item_key
471: ,aname => 'OBJECT_TYPE'
472: );

Line 474: l_object_id := wf_engine.getitemattrNumber(

470: ,itemkey => l_item_key
471: ,aname => 'OBJECT_TYPE'
472: );
473:
474: l_object_id := wf_engine.getitemattrNumber(
475: itemtype => l_item_type
476: ,itemkey => l_item_key
477: ,aname => 'OBJECT_ID'
478: );

Line 480: l_approver := wf_engine.getitemattrtext(

476: ,itemkey => l_item_key
477: ,aname => 'OBJECT_ID'
478: );
479:
480: l_approver := wf_engine.getitemattrtext(
481: itemtype => l_item_type
482: ,itemkey => l_item_key
483: ,aname => 'APPROVER'
484: );

Line 624: l_object := wf_engine.getitemattrtext(

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

Line 630: l_object_id := wf_engine.getitemattrNumber(

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

Line 767: l_object := wf_engine.getitemattrtext(

763: l_hyphen_pos1 := INSTR(document_id, ':');
764: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
765: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
766:
767: l_object := wf_engine.getitemattrtext(
768: itemtype => l_item_type
769: ,itemkey => l_item_key
770: ,aname => 'OBJECT_TYPE'
771: );

Line 773: l_object_id := wf_engine.getitemattrNumber(

769: ,itemkey => l_item_key
770: ,aname => 'OBJECT_TYPE'
771: );
772:
773: l_object_id := wf_engine.getitemattrNumber(
774: itemtype => l_item_type
775: ,itemkey => l_item_key
776: ,aname => 'OBJECT_ID'
777: );

Line 779: l_approver := wf_engine.getitemattrtext(

775: ,itemkey => l_item_key
776: ,aname => 'OBJECT_ID'
777: );
778:
779: l_approver := wf_engine.getitemattrtext(
780: itemtype => l_item_type
781: ,itemkey => l_item_key
782: ,aname => 'APPROVER'
783: );

Line 913: l_object := wf_engine.getitemattrtext(

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

Line 919: l_object_id := wf_engine.getitemattrNumber(

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

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: itemtype => l_item_type
927: ,itemkey => l_item_key
928: ,aname => 'REQUESTER'
929: );

Line 931: l_requester_note := wf_engine.getitemattrtext(

927: ,itemkey => l_item_key
928: ,aname => 'REQUESTER'
929: );
930:
931: l_requester_note := wf_engine.getitemattrtext(
932: itemtype => l_item_type
933: ,itemkey => l_item_key
934: ,aname => 'REQUESTER_NOTE'
935: );

Line 1071: l_object := wf_engine.getitemattrtext(

1067: l_hyphen_pos1 := INSTR(document_id, ':');
1068: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1069: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1070:
1071: l_object := wf_engine.getitemattrtext(
1072: itemtype => l_item_type
1073: ,itemkey => l_item_key
1074: ,aname => 'OBJECT_TYPE'
1075: );

Line 1077: l_object_id := wf_engine.getitemattrNumber(

1073: ,itemkey => l_item_key
1074: ,aname => 'OBJECT_TYPE'
1075: );
1076:
1077: l_object_id := wf_engine.getitemattrNumber(
1078: itemtype => l_item_type
1079: ,itemkey => l_item_key
1080: ,aname => 'OBJECT_ID'
1081: );

Line 1083: l_requester := wf_engine.getitemattrtext(

1079: ,itemkey => l_item_key
1080: ,aname => 'OBJECT_ID'
1081: );
1082:
1083: l_requester := wf_engine.getitemattrtext(
1084: itemtype => l_item_type
1085: ,itemkey => l_item_key
1086: ,aname => 'REQUESTER'
1087: );

Line 1089: l_requester_note := wf_engine.getitemattrtext(

1085: ,itemkey => l_item_key
1086: ,aname => 'REQUESTER'
1087: );
1088:
1089: l_requester_note := wf_engine.getitemattrtext(
1090: itemtype => l_item_type
1091: ,itemkey => l_item_key
1092: ,aname => 'REQUESTER_NOTE'
1093: );

Line 1228: l_object := wf_engine.getitemattrtext(

1224: l_hyphen_pos1 := INSTR(document_id, ':');
1225: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1226: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1227:
1228: l_object := wf_engine.getitemattrtext(
1229: itemtype => l_item_type
1230: ,itemkey => l_item_key
1231: ,aname => 'OBJECT_TYPE'
1232: );

Line 1234: l_object_id := wf_engine.getitemattrNumber(

1230: ,itemkey => l_item_key
1231: ,aname => 'OBJECT_TYPE'
1232: );
1233:
1234: l_object_id := wf_engine.getitemattrNumber(
1235: itemtype => l_item_type
1236: ,itemkey => l_item_key
1237: ,aname => 'OBJECT_ID'
1238: );

Line 1240: l_error_msg := wf_engine.getitemattrText(

1236: ,itemkey => l_item_key
1237: ,aname => 'OBJECT_ID'
1238: );
1239:
1240: l_error_msg := wf_engine.getitemattrText(
1241: itemtype => l_item_type
1242: ,itemkey => l_item_key
1243: ,aname => 'ERROR_MSG'
1244: );

Line 1368: l_approval_status := wf_engine.getitemattrtext(

1364: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Start UpdateStatus');
1365: END IF;
1366:
1367: IF funcmode = 'RUN' THEN
1368: l_approval_status := wf_engine.getitemattrtext(
1369: itemtype => itemtype
1370: ,itemkey => itemkey
1371: ,aname => 'UPDATE_GEN_STATUS'
1372: );

Line 1379: l_next_status := wf_engine.getitemattrText(

1375: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'After GetItemAttrText UpdateStatus');
1376: END IF;
1377:
1378: IF l_approval_status = 'APPROVED' THEN
1379: l_next_status := wf_engine.getitemattrText(
1380: itemtype => itemtype
1381: ,itemkey => itemkey
1382: ,aname => 'NEW_STATUS_ID'
1383: );

Line 1386: l_next_status := wf_engine.getitemattrText(

1382: ,aname => 'NEW_STATUS_ID'
1383: );
1384:
1385: ELSE
1386: l_next_status := wf_engine.getitemattrText(
1387: itemtype => itemtype
1388: ,itemkey => itemkey
1389: ,aname => 'REJECT_STATUS_ID'
1390: );

Line 1393: l_object_version_number := wf_engine.getitemattrnumber(

1389: ,aname => 'REJECT_STATUS_ID'
1390: );
1391: END IF;
1392:
1393: l_object_version_number := wf_engine.getitemattrnumber(
1394: itemtype => itemtype
1395: ,itemkey => itemkey
1396: ,aname => 'OBJECT_VER'
1397: );

Line 1398: l_object_id := wf_engine.getitemattrnumber(

1394: itemtype => itemtype
1395: ,itemkey => itemkey
1396: ,aname => 'OBJECT_VER'
1397: );
1398: l_object_id := wf_engine.getitemattrnumber(
1399: itemtype => itemtype
1400: ,itemkey => itemkey
1401: ,aname => 'OBJECT_ID'
1402: );

Line 1594: l_next_status := wf_engine.getitemattrText(

1590: END IF;
1591:
1592: l_return_Status:='S';
1593: IF funcmode = 'RUN' THEN
1594: l_next_status := wf_engine.getitemattrText(
1595: itemtype => itemtype
1596: ,itemkey => itemkey
1597: ,aname => 'ORG_STATUS_ID'
1598: );

Line 1600: l_object_version_number := wf_engine.getitemattrnumber(

1596: ,itemkey => itemkey
1597: ,aname => 'ORG_STATUS_ID'
1598: );
1599:
1600: l_object_version_number := wf_engine.getitemattrnumber(
1601: itemtype => itemtype
1602: ,itemkey => itemkey
1603: ,aname => 'OBJECT_VER'
1604: );

Line 1605: l_object_id := wf_engine.getitemattrnumber(

1601: itemtype => itemtype
1602: ,itemkey => itemkey
1603: ,aname => 'OBJECT_VER'
1604: );
1605: l_object_id := wf_engine.getitemattrnumber(
1606: itemtype => itemtype
1607: ,itemkey => itemkey
1608: ,aname => 'OBJECT_ID'
1609: );