APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_HEADERS_DRAFT_ALL

Line 909: FROM po_headers_draft_all phda,

905: phda.ame_approval_id),
906: phda.ame_transaction_type
907: INTO l_ame_approval_id,
908: l_ame_transaction_type
909: FROM po_headers_draft_all phda,
910: po_drafts pd
911: WHERE phda.po_header_id = DocumentID
912: AND phda.draft_id = DraftID
913: AND phda.draft_id = pd.draft_id;

Line 917: update po_headers_draft_all

913: AND phda.draft_id = pd.draft_id;
914:
915: if l_ame_approval_id = 0 then
916: select po_ame_approvals_s.nextval into l_ame_approval_id from dual;
917: update po_headers_draft_all
918: set ame_approval_id = l_ame_approval_id
919: where po_header_id = DocumentID
920: and draft_id = DraftID;
921: end if;

Line 974: FROM po_headers_draft_all phda,

970: IF l_multi_mod_req_type = 'VENDOR_CHANGE' THEN
971:
972: SELECT pv.vendor_name, pvs.vendor_site_code
973: INTO l_new_vendor, l_new_vendor_site_code
974: FROM po_headers_draft_all phda,
975: po_vendors pv,
976: po_vendor_sites_all pvs
977: WHERE draft_id = DraftID
978: AND phda.vendor_id = pv.vendor_id

Line 1214: FROM po_headers_draft_all

1210: INTO l_revision_num,
1211: l_doc_display_name,
1212: l_conterms_exist_flag,
1213: l_document_number
1214: FROM po_headers_draft_all
1215: WHERE po_header_id = DocumentID
1216: AND draft_id = DraftId;
1217: END IF; -- l_is_mod = 'N' then
1218: l_doc_num_rel := l_document_number;

Line 5067: UPDATE Po_Headers_Draft_all

5063: ,
5064: pending_signature_flag = DECODE(l_pending_signature_flag, 'Y', DECODE(acceptance_required_flag, 'S', 'Y', 'N'), pending_signature_flag)
5065: WHERE po_header_id = l_po_header_id;
5066: ELSE
5067: UPDATE Po_Headers_Draft_all
5068: SET WF_ITEM_TYPE = itemtype,
5069: WF_ITEM_KEY = itemkey,
5070: last_updated_by = fnd_global.user_id,
5071: last_update_login = fnd_global.login_id,