APPS.PO_DRAFT_MERGE_PKG dependencies on PO_LINES_DRAFT_ALL

Line 130: po_lines_draft_all pld

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
134: from fnd_attached_documents

Line 724: po_lines_draft_all pld

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;
728:

Line 1588: from fnd_attached_documents fad, po_lines_draft_all pld , fnd_documents fd

1584: procedure MERGE_LINE_ATTACHMENTS(p_draft_id NUMBER) AS
1585:
1586: cursor modified_line_attachments_c(p_draft_id NUMBER,p_entity_name VARCHAR2) is
1587: select pld.po_line_id as po_line_id, fad.attached_document_id , fad.ORIG_ATTACH_DOC_ID ,fd.datatype_id
1588: from fnd_attached_documents fad, po_lines_draft_all pld , fnd_documents fd
1589: where pld.draft_id = p_draft_id
1590: and fad.entity_name = p_entity_name
1591: and fad.pk1_value = to_char(pld.po_line_id) || '-' || to_char(p_draft_id)
1592: AND ORIG_ATTACH_DOC_ID IS NOT NULL

Line 1603: from fnd_attached_documents fad, po_lines_draft_all pld , fnd_documents fd

1599: --Fetch all new attachments other than mod specific attachments as merge
1600: -- is not needed for these attachmnets
1601: cursor new_line_attachments_c(p_draft_id NUMBER) is
1602: select pld.po_line_id as po_line_id, fad.attached_document_id , fad.ORIG_ATTACH_DOC_ID ,fd.datatype_id
1603: from fnd_attached_documents fad, po_lines_draft_all pld , fnd_documents fd
1604: where pld.draft_id = p_draft_id
1605: and fad.entity_name = 'PO_LINES'
1606: and fad.pk1_value = to_char(pld.po_line_id) || '-' || to_char(p_draft_id)
1607: AND ORIG_ATTACH_DOC_ID IS NULL

Line 1819: UPDATE PO_LINES_DRAFT_ALL

1815: UPDATE PO_DRAFTS
1816: SET status = 'COMPLETED'
1817: WHERE draft_id = p_draft_id;
1818: -- Set draft_line_status as well.
1819: UPDATE PO_LINES_DRAFT_ALL
1820: SET draft_line_status = 'COMPLETED'
1821: WHERE draft_id = p_draft_id
1822: AND po_header_id = po_po_header_id
1823: AND draft_line_status is NULL;

Line 1980: UPDATE po_lines_draft_all

1976: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'Is PAR Enabled : ' || l_is_par_enabled );
1977:
1978: IF l_is_par_enabled = 'Y' THEN
1979:
1980: UPDATE po_lines_draft_all
1981: SET draft_line_status = 'PO_CREATED'
1982: WHERE po_header_id = p_document_id
1983: AND mod_draft_id = p_draft_id;
1984: