DBA Data[Home] [Help]

APPS.OZF_PRICELIST_APPROVAL_PVT dependencies on WF_ENGINE

Line 79: l_activity_type := wf_engine.getitemattrtext(

75: l_hyphen_pos1 := INSTR(document_id, ':');
76: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
77: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
78:
79: l_activity_type := wf_engine.getitemattrtext(
80: itemtype => l_item_type
81: ,itemkey => l_item_key
82: ,aname => 'AMS_ACTIVITY_TYPE'
83: );

Line 85: l_list_header_id := wf_engine.getitemattrtext(

81: ,itemkey => l_item_key
82: ,aname => 'AMS_ACTIVITY_TYPE'
83: );
84:
85: l_list_header_id := wf_engine.getitemattrtext(
86: itemtype => l_item_type
87: ,itemkey => l_item_key
88: ,aname => 'AMS_ACTIVITY_ID'
89: );

Line 91: l_approver := wf_engine.getitemattrtext(

87: ,itemkey => l_item_key
88: ,aname => 'AMS_ACTIVITY_ID'
89: );
90:
91: l_approver := wf_engine.getitemattrtext(
92: itemtype => l_item_type
93: ,itemkey => l_item_key
94: ,aname => 'AMS_APPROVER'
95: );

Line 113: wf_engine.setitemattrtext(

109: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_SUBJ');
110: fnd_message.set_token('PRICELIST_NAME', l_name, false);
111: l_subject := fnd_message.get;
112:
113: wf_engine.setitemattrtext(
114: itemtype => l_item_type
115: ,itemkey => l_item_key
116: ,aname => 'FYI_SUBJECT'
117: ,avalue => l_subject

Line 216: l_activity_type := wf_engine.getitemattrtext(

212: -- release 2.5 version of this demo
213: l_hyphen_pos1 := INSTR(document_id, ':');
214: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
215: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
216: l_activity_type := wf_engine.getitemattrtext(
217: itemtype => l_item_type
218: ,itemkey => l_item_key
219: ,aname => 'AMS_ACTIVITY_TYPE'
220: );

Line 222: l_list_header_id := wf_engine.getitemattrtext(

218: ,itemkey => l_item_key
219: ,aname => 'AMS_ACTIVITY_TYPE'
220: );
221:
222: l_list_header_id := wf_engine.getitemattrtext(
223: itemtype => l_item_type
224: ,itemkey => l_item_key
225: ,aname => 'AMS_ACTIVITY_ID'
226: );

Line 228: l_requester := wf_engine.getitemattrtext(

224: ,itemkey => l_item_key
225: ,aname => 'AMS_ACTIVITY_ID'
226: );
227:
228: l_requester := wf_engine.getitemattrtext(
229: itemtype => l_item_type
230: ,itemkey => l_item_key
231: ,aname => 'AMS_REQUESTER'
232: );

Line 234: l_approver := wf_engine.getitemattrtext(

230: ,itemkey => l_item_key
231: ,aname => 'AMS_REQUESTER'
232: );
233:
234: l_approver := wf_engine.getitemattrtext(
235: itemtype => l_item_type
236: ,itemkey => l_item_key
237: ,aname => 'AMS_APPROVER'
238: );

Line 256: wf_engine.setitemattrtext(

252: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_SUBJ');
253: fnd_message.set_token('PRICELIST_NAME', l_name, false);
254: l_subject := fnd_message.get;
255:
256: wf_engine.setitemattrtext(
257: itemtype => l_item_type
258: ,itemkey => l_item_key
259: ,aname => 'APP_SUBJECT'
260: ,avalue => l_subject

Line 359: l_activity_type := wf_engine.getitemattrtext(

355: l_hyphen_pos1 := INSTR(document_id, ':');
356: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
357: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
358:
359: l_activity_type := wf_engine.getitemattrtext(
360: itemtype => l_item_type
361: ,itemkey => l_item_key
362: ,aname => 'AMS_ACTIVITY_TYPE'
363: );

Line 365: l_list_header_id := wf_engine.getitemattrtext(

361: ,itemkey => l_item_key
362: ,aname => 'AMS_ACTIVITY_TYPE'
363: );
364:
365: l_list_header_id := wf_engine.getitemattrtext(
366: itemtype => l_item_type
367: ,itemkey => l_item_key
368: ,aname => 'AMS_ACTIVITY_ID'
369: );

Line 371: l_requester := wf_engine.getitemattrtext(

367: ,itemkey => l_item_key
368: ,aname => 'AMS_ACTIVITY_ID'
369: );
370:
371: l_requester := wf_engine.getitemattrtext(
372: itemtype => l_item_type
373: ,itemkey => l_item_key
374: ,aname => 'AMS_REQUESTER'
375: );

Line 393: wf_engine.setitemattrtext(

389: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPR_REM_SUBJ');
390: fnd_message.set_token('PRICELIST_NAME', l_name, false);
391: l_subject := fnd_message.get;
392:
393: wf_engine.setitemattrtext(
394: itemtype => l_item_type
395: ,itemkey => l_item_key
396: ,aname => 'APP_SUBJECT'
397: ,avalue => l_subject

Line 496: l_activity_type := wf_engine.getitemattrtext(

492: l_hyphen_pos1 := INSTR(document_id, ':');
493: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
494: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
495:
496: l_activity_type := wf_engine.getitemattrtext(
497: itemtype => l_item_type
498: ,itemkey => l_item_key
499: ,aname => 'AMS_ACTIVITY_TYPE'
500: );

Line 502: l_list_header_id := wf_engine.getitemattrtext(

498: ,itemkey => l_item_key
499: ,aname => 'AMS_ACTIVITY_TYPE'
500: );
501:
502: l_list_header_id := wf_engine.getitemattrtext(
503: itemtype => l_item_type
504: ,itemkey => l_item_key
505: ,aname => 'AMS_ACTIVITY_ID'
506: );

Line 508: l_approver := wf_engine.getitemattrtext(

504: ,itemkey => l_item_key
505: ,aname => 'AMS_ACTIVITY_ID'
506: );
507:
508: l_approver := wf_engine.getitemattrtext(
509: itemtype => l_item_type
510: ,itemkey => l_item_key
511: ,aname => 'AMS_APPROVER'
512: );

Line 530: wf_engine.setitemattrtext(

526: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_SUBJ');
527: fnd_message.set_token('PRICELIST_NAME', l_name, false);
528: l_subject := fnd_message.get;
529:
530: wf_engine.setitemattrtext(
531: itemtype => l_item_type
532: ,itemkey => l_item_key
533: ,aname => 'APRV_SUBJECT'
534: ,avalue => l_subject

Line 633: l_activity_type := wf_engine.getitemattrtext(

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

Line 639: l_list_header_id := wf_engine.getitemattrtext(

635: ,itemkey => l_item_key
636: ,aname => 'AMS_ACTIVITY_TYPE'
637: );
638:
639: l_list_header_id := wf_engine.getitemattrtext(
640: itemtype => l_item_type
641: ,itemkey => l_item_key
642: ,aname => 'AMS_ACTIVITY_ID'
643: );

Line 645: l_approver := wf_engine.getitemattrtext(

641: ,itemkey => l_item_key
642: ,aname => 'AMS_ACTIVITY_ID'
643: );
644:
645: l_approver := wf_engine.getitemattrtext(
646: itemtype => l_item_type
647: ,itemkey => l_item_key
648: ,aname => 'AMS_APPROVER'
649: );

Line 667: wf_engine.setitemattrtext(

663: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_SUBJ');
664: fnd_message.set_token('PRICELIST_NAME', l_name, false);
665: l_subject := fnd_message.get;
666:
667: wf_engine.setitemattrtext(
668: itemtype => l_item_type
669: ,itemkey => l_item_key
670: ,aname => 'REJECT_SUBJECT'
671: ,avalue => l_subject

Line 761: l_activity_id := wf_engine.getitemattrnumber(

757:
758: BEGIN
759: fnd_msg_pub.initialize;
760:
761: l_activity_id := wf_engine.getitemattrnumber(
762: itemtype => itemtype
763: ,itemkey => itemkey
764: ,aname => 'AMS_ACTIVITY_ID'
765: );

Line 792: wf_engine.setitemattrnumber(

788: ,x_return_status => l_return_status
789: );
790:
791: IF l_return_status = fnd_api.g_ret_sts_success THEN
792: wf_engine.setitemattrnumber(
793: itemtype => itemtype
794: ,itemkey => itemkey
795: ,aname => 'AMS_APPROVAL_DETAIL_ID'
796: ,avalue => l_approval_detail_id

Line 798: wf_engine.setitemattrnumber(

794: ,itemkey => itemkey
795: ,aname => 'AMS_APPROVAL_DETAIL_ID'
796: ,avalue => l_approval_detail_id
797: );
798: wf_engine.setitemattrnumber(
799: itemtype => itemtype
800: ,itemkey => itemkey
801: ,aname => 'AMS_APPROVER_SEQ'
802: ,avalue => l_approver_seq

Line 809: wf_engine.setitemattrtext(

805: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_SUBJ');
806: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
807: l_subject := fnd_message.get;
808:
809: wf_engine.setitemattrtext(
810: itemtype => itemtype
811: ,itemkey => itemkey
812: ,aname => 'FYI_SUBJECT'
813: ,avalue => l_subject

Line 820: wf_engine.setitemattrtext(

816: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_SUBJ');
817: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
818: l_subject := fnd_message.get;
819:
820: wf_engine.setitemattrtext(
821: itemtype => itemtype
822: ,itemkey => itemkey
823: ,aname => 'APP_SUBJECT'
824: ,avalue => l_subject

Line 831: wf_engine.setitemattrtext(

827: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_SUBJ');
828: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
829: l_subject := fnd_message.get;
830:
831: wf_engine.setitemattrtext(
832: itemtype => itemtype
833: ,itemkey => itemkey
834: ,aname => 'APRV_SUBJECT'
835: ,avalue => l_subject

Line 842: wf_engine.setitemattrtext(

838: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_SUBJ');
839: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
840: l_subject := fnd_message.get;
841:
842: wf_engine.setitemattrtext(
843: itemtype => itemtype
844: ,itemkey => itemkey
845: ,aname => 'REJECT_SUBJECT'
846: ,avalue => l_subject

Line 850: wf_engine.setitemattrtext (

846: ,avalue => l_subject
847: );
848: -- julou 07/02/2002 added for implementation of BUG 2352621
849: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','PRIC');
850: wf_engine.setitemattrtext (
851: itemtype=> itemtype,
852: itemkey=> itemkey,
853: aname => 'AMS_APPROVAL_OBJECT_MEANING',
854: avalue=> l_lookup_meaning

Line 857: wf_engine.setitemattrtext (

853: aname => 'AMS_APPROVAL_OBJECT_MEANING',
854: avalue=> l_lookup_meaning
855: );
856:
857: wf_engine.setitemattrtext (
858: itemtype=> itemtype,
859: itemkey=> itemkey,
860: aname => 'AMS_APPROVAL_OBJECT_NAME',
861: avalue=> l_object_details.name

Line 976: l_approval_status := wf_engine.getitemattrtext(

972: l_list_header_id NUMBER;
973:
974: BEGIN
975: IF funcmode = 'RUN' THEN
976: l_approval_status := wf_engine.getitemattrtext(
977: itemtype => itemtype
978: ,itemkey => itemkey
979: ,aname => 'UPDATE_GEN_STATUS'
980: );

Line 983: l_next_status_id := wf_engine.getitemattrnumber(

979: ,aname => 'UPDATE_GEN_STATUS'
980: );
981:
982: IF l_approval_status = 'APPROVED' THEN
983: l_next_status_id := wf_engine.getitemattrnumber(
984: itemtype => itemtype
985: ,itemkey => itemkey
986: ,aname => 'AMS_NEW_STAT_ID'
987: );

Line 989: l_next_status_id := wf_engine.getitemattrnumber(

985: ,itemkey => itemkey
986: ,aname => 'AMS_NEW_STAT_ID'
987: );
988: ELSIF l_approval_status = 'REJECTED' THEN
989: l_next_status_id := wf_engine.getitemattrnumber(
990: itemtype => itemtype
991: ,itemkey => itemkey
992: ,aname => 'AMS_REJECT_STAT_ID'
993: );

Line 997: l_next_status_id := wf_engine.GetItemAttrNumber(

993: );
994: -- julou added 07/02/2002 for bug 2352621
995: -- if Workflow status is ERROR revert status of price list to original status
996: ELSE
997: l_next_status_id := wf_engine.GetItemAttrNumber(
998: itemtype => itemtype,
999: itemkey => itemkey,
1000: aname => 'AMS_ORIG_STAT_ID' );
1001: END IF;

Line 1003: l_object_version_number := wf_engine.getitemattrnumber(

999: itemkey => itemkey,
1000: aname => 'AMS_ORIG_STAT_ID' );
1001: END IF;
1002:
1003: l_object_version_number := wf_engine.getitemattrnumber(
1004: itemtype => itemtype
1005: ,itemkey => itemkey
1006: ,aname => 'AMS_OBJECT_VERSION_NUMBER'
1007: );

Line 1008: l_list_header_id := wf_engine.getitemattrnumber(

1004: itemtype => itemtype
1005: ,itemkey => itemkey
1006: ,aname => 'AMS_OBJECT_VERSION_NUMBER'
1007: );
1008: l_list_header_id := wf_engine.getitemattrnumber(
1009: itemtype => itemtype
1010: ,itemkey => itemkey
1011: ,aname => 'AMS_ACTIVITY_ID'
1012: );