DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_MULTI_MOD_REQUESTS

Line 734: l_multi_mod_req_type PO_MULTI_MOD_REQUESTS.MULTI_MOD_REQUEST_TYPE%TYPE; --multi-mod

730: l_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --Bug 4254468
731: l_new_vendor po_vendors.vendor_name%type; --multi-mod
732: l_new_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --multi-mod
733: l_multi_mod_req_id PO_MULTI_MOD_DOCS.MULTI_MOD_REQUEST_ID%TYPE; -- multi-mod
734: l_multi_mod_req_type PO_MULTI_MOD_REQUESTS.MULTI_MOD_REQUEST_TYPE%TYPE; --multi-mod
735: l_supplier_change_note varchar2(320); --multi-mod
736: l_supplier_site_change_note varchar2(320); --multi-mod
737: l_validation_details_url varchar2(320); --multi-mod
738: l_communicatePriceChange VARCHAR2(1); -- bug4176111

Line 965: FROM PO_MULTI_MOD_REQUESTS

961: WHERE DRAFT_ID = DraftID;
962:
963: SELECT MULTI_MOD_REQUEST_TYPE
964: INTO l_multi_mod_req_type
965: FROM PO_MULTI_MOD_REQUESTS
966: WHERE MULTI_MOD_REQUEST_ID = l_multi_mod_req_id;
967:
968: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname => 'APPROVAL_SOURCE', avalue => ActionOriginatedFrom);
969: