DBA Data[Home] [Help]

APPS.OZF_OFFERADJ_APPROVAL_PVT dependencies on WF_ENGINE

Line 115: wf_engine.getitemattrtext (

111: - 1);
112: l_item_key := SUBSTR (document_id, l_hyphen_pos1
113: + 1);
114: l_activity_type :=
115: wf_engine.getitemattrtext (
116: itemtype=> l_item_type,
117: itemkey=> l_item_key,
118: aname => 'AMS_ACTIVITY_TYPE'
119: );

Line 121: wf_engine.getitemattrtext (

117: itemkey=> l_item_key,
118: aname => 'AMS_ACTIVITY_TYPE'
119: );
120: l_offer_adjustment_id :=
121: wf_engine.getitemattrtext (
122: itemtype=> l_item_type,
123: itemkey=> l_item_key,
124: aname => 'AMS_ACTIVITY_ID'
125: );

Line 127: l_note := wf_engine.getitemattrtext(

123: itemkey=> l_item_key,
124: aname => 'AMS_ACTIVITY_ID'
125: );
126:
127: l_note := wf_engine.getitemattrtext(
128: itemtype => l_item_type
129: ,itemkey => l_item_key
130: ,aname => 'AMS_NOTES_FROM_REQUESTOR'
131: );

Line 134: wf_engine.getitemattrtext (

130: ,aname => 'AMS_NOTES_FROM_REQUESTOR'
131: );
132:
133: l_approver :=
134: wf_engine.getitemattrtext (
135: itemtype=> l_item_type,
136: itemkey=> l_item_key,
137: aname => 'AMS_APPROVER'
138: );

Line 287: wf_engine.getitemattrtext (

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

Line 293: wf_engine.getitemattrtext (

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

Line 300: wf_engine.getitemattrtext (

296: aname => 'AMS_ACTIVITY_ID'
297: );
298:
299: l_note :=
300: wf_engine.getitemattrtext (
301: itemtype=> l_item_type,
302: itemkey=> l_item_key,
303: aname => 'AMS_NOTES_FROM_REQUESTOR'
304: );

Line 307: wf_engine.getitemattrtext (

303: aname => 'AMS_NOTES_FROM_REQUESTOR'
304: );
305:
306: l_approver :=
307: wf_engine.getitemattrtext (
308: itemtype=> l_item_type,
309: itemkey=> l_item_key,
310: aname => 'AMS_APPROVER'
311: );

Line 460: wf_engine.getitemattrtext (

456: - 1);
457: l_item_key := SUBSTR (document_id, l_hyphen_pos1
458: + 1);
459: l_activity_type :=
460: wf_engine.getitemattrtext (
461: itemtype=> l_item_type,
462: itemkey=> l_item_key,
463: aname => 'AMS_ACTIVITY_TYPE'
464: );

Line 466: wf_engine.getitemattrtext (

462: itemkey=> l_item_key,
463: aname => 'AMS_ACTIVITY_TYPE'
464: );
465: l_offer_adjustment_id :=
466: wf_engine.getitemattrtext (
467: itemtype=> l_item_type,
468: itemkey=> l_item_key,
469: aname => 'AMS_ACTIVITY_ID'
470: );

Line 473: wf_engine.getitemattrtext (

469: aname => 'AMS_ACTIVITY_ID'
470: );
471:
472: l_note :=
473: wf_engine.getitemattrtext (
474: itemtype=> l_item_type,
475: itemkey=> l_item_key,
476: aname => 'AMS_NOTES_FROM_REQUESTOR'
477: );

Line 480: wf_engine.getitemattrtext (

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

Line 636: wf_engine.getitemattrtext (

632: - 1);
633: l_item_key := SUBSTR (document_id, l_hyphen_pos1
634: + 1);
635: l_activity_type :=
636: wf_engine.getitemattrtext (
637: itemtype=> l_item_type,
638: itemkey=> l_item_key,
639: aname => 'AMS_ACTIVITY_TYPE'
640: );

Line 643: wf_engine.getitemattrtext (

639: aname => 'AMS_ACTIVITY_TYPE'
640: );
641:
642: l_offer_adjustment_id :=
643: wf_engine.getitemattrtext (
644: itemtype=> l_item_type,
645: itemkey=> l_item_key,
646: aname => 'AMS_ACTIVITY_ID'
647: );

Line 650: wf_engine.getitemattrtext (

646: aname => 'AMS_ACTIVITY_ID'
647: );
648:
649: l_requester :=
650: wf_engine.getitemattrtext (
651: itemtype=> l_item_type,
652: itemkey=> l_item_key,
653: aname => 'AMS_REQUESTER'
654: );

Line 657: NVL(wf_engine.getitemattrtext (

653: aname => 'AMS_REQUESTER'
654: );
655:
656: l_note :=
657: NVL(wf_engine.getitemattrtext (
658: itemtype=> l_item_type,
659: itemkey=> l_item_key,
660: aname => 'AMS_NOTES_FROM_REQUESTOR'
661: ),'-');

Line 810: wf_engine.getitemattrtext (

806: - 1);
807: l_item_key := SUBSTR (document_id, l_hyphen_pos1
808: + 1);
809: l_activity_type :=
810: wf_engine.getitemattrtext (
811: itemtype=> l_item_type,
812: itemkey=> l_item_key,
813: aname => 'AMS_ACTIVITY_TYPE'
814: );

Line 816: wf_engine.getitemattrtext (

812: itemkey=> l_item_key,
813: aname => 'AMS_ACTIVITY_TYPE'
814: );
815: l_offer_adjustment_id :=
816: wf_engine.getitemattrtext (
817: itemtype=> l_item_type,
818: itemkey=> l_item_key,
819: aname => 'AMS_ACTIVITY_ID'
820: );

Line 823: wf_engine.getitemattrtext (

819: aname => 'AMS_ACTIVITY_ID'
820: );
821:
822: l_requester :=
823: wf_engine.getitemattrtext (
824: itemtype=> l_item_type,
825: itemkey=> l_item_key,
826: aname => 'AMS_REQUESTER'
827: );

Line 830: NVL(wf_engine.getitemattrtext (

826: aname => 'AMS_REQUESTER'
827: );
828:
829: l_note :=
830: NVL(wf_engine.getitemattrtext (
831: itemtype=> l_item_type,
832: itemkey=> l_item_key,
833: aname => 'AMS_NOTES_FROM_REQUESTOR'
834: ),'-');

Line 1010: wf_engine.getitemattrnumber (

1006: BEGIN
1007: fnd_msg_pub.initialize;
1008:
1009: l_activity_id :=
1010: wf_engine.getitemattrnumber (
1011: itemtype=> itemtype,
1012: itemkey=> itemkey,
1013: aname => 'AMS_ACTIVITY_ID'
1014: );

Line 1073: wf_engine.setitemattrnumber (

1069: x_return_status=> l_return_status
1070: );
1071:
1072: IF l_return_status = fnd_api.g_ret_sts_success THEN
1073: wf_engine.setitemattrnumber (
1074: itemtype=> itemtype,
1075: itemkey=> itemkey,
1076: aname => 'AMS_APPROVAL_DETAIL_ID',
1077: avalue=> l_approval_detail_id

Line 1079: wf_engine.setitemattrnumber (

1075: itemkey=> itemkey,
1076: aname => 'AMS_APPROVAL_DETAIL_ID',
1077: avalue=> l_approval_detail_id
1078: );
1079: wf_engine.setitemattrnumber (
1080: itemtype=> itemtype,
1081: itemkey=> itemkey,
1082: aname => 'AMS_APPROVER_SEQ',
1083: avalue=> l_approver_seq

Line 1093: wf_engine.setitemattrtext(

1089: fnd_message.set_token ('ADJUSTMENT_NAME', l_offer_adj_name, FALSE);
1090: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1091: l_string := SUBSTR(fnd_message.get,1,1000);
1092:
1093: wf_engine.setitemattrtext(
1094: itemtype => itemtype
1095: ,itemkey => itemkey
1096: ,aname => 'FYI_SUBJECT'
1097: ,avalue => l_string

Line 1106: wf_engine.setitemattrtext(

1102: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1103: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1104: l_string := Substr(FND_MESSAGE.Get,1,1000);
1105:
1106: wf_engine.setitemattrtext(
1107: itemtype => itemtype
1108: ,itemkey => itemkey
1109: ,aname => 'APP_SUBJECT'
1110: ,avalue => l_string

Line 1120: wf_engine.setitemattrtext(

1116: fnd_message.set_token ('OFFER_NAME', l_object_details.name, FALSE);
1117: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1118: l_string := Substr(FND_MESSAGE.Get,1,1000);
1119:
1120: wf_engine.setitemattrtext(
1121: itemtype => itemtype
1122: ,itemkey => itemkey
1123: ,aname => 'APRV_SUBJECT'
1124: ,avalue => l_string

Line 1133: wf_engine.setitemattrtext(

1129: fnd_message.set_token ('OFFER_NAME', l_object_details.name , FALSE);
1130: fnd_message.set_token ('EFFECTIVE_DATE', l_effective_date, FALSE);
1131: l_string := Substr(FND_MESSAGE.Get,1,1000);
1132:
1133: wf_engine.setitemattrtext(
1134: itemtype => itemtype
1135: ,itemkey => itemkey
1136: ,aname => 'REJECT_SUBJECT'
1137: ,avalue => l_string

Line 1144: wf_engine.setitemattrtext (

1140: -- BUG 2352621
1141:
1142: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','OFFRADJ');
1143:
1144: wf_engine.setitemattrtext (
1145: itemtype=> itemtype,
1146: itemkey=> itemkey,
1147: aname => 'AMS_APPROVAL_OBJECT_MEANING',
1148: avalue=> l_lookup_meaning

Line 1151: wf_engine.setitemattrtext (

1147: aname => 'AMS_APPROVAL_OBJECT_MEANING',
1148: avalue=> l_lookup_meaning
1149: );
1150:
1151: wf_engine.setitemattrtext (
1152: itemtype=> itemtype,
1153: itemkey=> itemkey,
1154: aname => 'AMS_APPROVAL_OBJECT_NAME',
1155: avalue=> l_object_details.name

Line 1289: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

1285: l_appl_id NUMBER;
1286: l_security_group_id NUMBER;
1287:
1288: BEGIN
1289: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1290: , itemkey => itemkey
1291: , aname => 'USER_ID'
1292: );
1293: l_resp_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

Line 1293: l_resp_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

1289: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1290: , itemkey => itemkey
1291: , aname => 'USER_ID'
1292: );
1293: l_resp_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1294: , itemkey => itemkey
1295: , aname => 'RESPONSIBILITY_ID'
1296: );
1297: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

Line 1297: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

1293: l_resp_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1294: , itemkey => itemkey
1295: , aname => 'RESPONSIBILITY_ID'
1296: );
1297: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1298: , itemkey => itemkey
1299: , aname => 'APPLICATION_ID'
1300: );
1301: l_security_group_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

Line 1301: l_security_group_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

1297: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1298: , itemkey => itemkey
1299: , aname => 'APPLICATION_ID'
1300: );
1301: l_security_group_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1302: , itemkey => itemkey
1303: , aname => 'SECURITY_GROUP_ID'
1304: );
1305:

Line 1308: wf_engine.getitemattrtext (

1304: );
1305:
1306: IF funcmode = 'RUN' THEN
1307: l_approval_status :=
1308: wf_engine.getitemattrtext (
1309: itemtype=> itemtype,
1310: itemkey=> itemkey,
1311: aname => 'UPDATE_GEN_STATUS'
1312: );

Line 1330: wf_engine.getitemattrnumber (

1326:
1327: END IF;
1328:
1329: l_object_version_number :=
1330: wf_engine.getitemattrnumber (
1331: itemtype=> itemtype,
1332: itemkey=> itemkey,
1333: aname => 'AMS_OBJECT_VERSION_NUMBER'
1334: );

Line 1337: wf_engine.getitemattrnumber (

1333: aname => 'AMS_OBJECT_VERSION_NUMBER'
1334: );
1335:
1336: l_offer_adjustment_id :=
1337: wf_engine.getitemattrnumber (
1338: itemtype=> itemtype,
1339: itemkey=> itemkey,
1340: aname => 'AMS_ACTIVITY_ID'
1341: );