APPS.PO_DRAFT_MERGE_PKG dependencies on PO_HEADERS_DRAFT_ALL

Line 129: from po_headers_draft_all phd,

125: p_draft_id IN NUMBER)
126: is
127: cursor lines_with_attachments_c(p_draft_id number) is
128: select pld.po_line_id as po_line_id
129: from po_headers_draft_all phd,
130: po_lines_draft_all pld
131: where phd.draft_id = p_draft_id
132: and phd.po_header_id = pld.po_header_id
133: and exists (select 1

Line 141: from po_headers_draft_all phd,

137:
138: cursor line_locs_with_attachments_c(p_draft_id number) is
139: select plld.po_line_id as po_line_id,
140: plld.line_location_id as line_location_id
141: from po_headers_draft_all phd,
142: po_line_locations_draft_all plld
143: where phd.draft_id = p_draft_id
144: and phd.po_header_id = plld.po_header_id
145: and exists (select 1

Line 328: UPDATE po_headers_draft_all

324: procedure update_mod_approved_date(p_draft_id IN NUMBER,
325: p_document_id IN NUMBER)
326: IS
327: BEGIN
328: UPDATE po_headers_draft_all
329: SET approved_date = sysdate
330: WHERE draft_id = p_draft_id
331: AND po_header_id = p_document_id;
332:

Line 723: from po_headers_draft_all phd,

719: l_draft_id PO_DRAFTS.draft_id%TYPE;
720: cursor control_action_line_c is
721: select nvl(pld.control_action, 'NULL') as control_action,
722: pld.po_line_id as po_line_id
723: from po_headers_draft_all phd,
724: po_lines_draft_all pld
725: where phd.draft_id = l_draft_id
726: and phd.po_header_id = pld.po_header_id
727: and pld.control_action is not NULL;

Line 733: from po_headers_draft_all phd,

729: cursor control_action_line_loc_c is
730: select nvl(plld.control_action, 'NULL') as control_action,
731: plld.po_line_id as po_line_id,
732: plld.line_location_id as po_line_location_id
733: from po_headers_draft_all phd,
734: po_line_locations_draft_all plld
735: where phd.draft_id = l_draft_id
736: and phd.po_header_id = plld.po_header_id
737: and plld.control_action is not NULL;

Line 772: from po_headers_draft_all phd,

768: into v_type_code,
769: l_control_Action,
770: p_document_id,
771: l_date
772: from po_headers_draft_all phd,
773: po_drafts pd
774: where phd.draft_id = l_draft_id
775: and phd.draft_id = pd.draft_id;
776:

Line 1329: FROM po_headers_draft_all

1325:
1326:
1327: SELECT uda_template_id
1328: INTO l_uda_template_id
1329: FROM po_headers_draft_all
1330: WHERE po_header_id = l_po_hdr_id
1331: AND draft_id = l_draft_id;
1332:
1333: --

Line 1964: FROM po_headers_draft_all pha,

1960:
1961: BEGIN
1962: SELECT par_enabled_flag
1963: INTO l_is_par_enabled
1964: FROM po_headers_draft_all pha,
1965: po_doc_style_headers pds
1966: WHERE pha.style_id = pds.style_id
1967: AND pha.po_header_id = p_document_id
1968: AND pha.draft_id = p_draft_id;