DBA Data[Home] [Help]

APPS.OZF_OFFERADJ_APPROVAL_PVT dependencies on WF_ENGINE

Line 114: wf_engine.getitemattrtext (

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

Line 120: wf_engine.getitemattrtext (

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

Line 126: l_note := wf_engine.getitemattrtext(

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

Line 133: wf_engine.getitemattrtext (

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

Line 286: wf_engine.getitemattrtext (

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

Line 292: wf_engine.getitemattrtext (

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

Line 299: wf_engine.getitemattrtext (

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

Line 306: wf_engine.getitemattrtext (

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

Line 459: wf_engine.getitemattrtext (

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

Line 465: wf_engine.getitemattrtext (

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

Line 472: wf_engine.getitemattrtext (

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

Line 479: wf_engine.getitemattrtext (

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

Line 635: wf_engine.getitemattrtext (

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

Line 642: wf_engine.getitemattrtext (

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

Line 649: wf_engine.getitemattrtext (

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

Line 656: NVL(wf_engine.getitemattrtext (

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

Line 809: wf_engine.getitemattrtext (

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

Line 815: wf_engine.getitemattrtext (

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

Line 822: wf_engine.getitemattrtext (

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

Line 829: NVL(wf_engine.getitemattrtext (

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

Line 1009: wf_engine.getitemattrnumber (

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

Line 1072: wf_engine.setitemattrnumber (

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

Line 1078: wf_engine.setitemattrnumber (

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

Line 1092: wf_engine.setitemattrtext(

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

Line 1105: wf_engine.setitemattrtext(

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

Line 1119: wf_engine.setitemattrtext(

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

Line 1132: wf_engine.setitemattrtext(

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

Line 1143: wf_engine.setitemattrtext (

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

Line 1150: wf_engine.setitemattrtext (

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

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

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

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

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

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

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

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

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

Line 1307: wf_engine.getitemattrtext (

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

Line 1329: wf_engine.getitemattrnumber (

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

Line 1336: wf_engine.getitemattrnumber (

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