APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_HEADERS_INTERFACE

Line 2006: FROM po_headers_interface

2002: -- new columns added in R12
2003: p_headers.style_id_tbl(i),
2004: p_headers.created_language_tbl(i),
2005: p_headers.tax_attribute_update_code_tbl(i)
2006: FROM po_headers_interface
2007: WHERE interface_header_id = p_headers.intf_header_id_tbl(i)
2008: AND p_headers.error_flag_tbl(i) = FND_API.g_FALSE;
2009:
2010: IF (PO_LOG.d_proc) THEN

Line 2092: FROM po_headers_interface

2088: p_headers.last_updated_by_tbl(i),
2089: p_headers.last_update_login_tbl(i),
2090: p_headers.creation_date_tbl(i),
2091: p_headers.created_by_tbl(i)
2092: FROM po_headers_interface
2093: WHERE interface_header_id = p_headers.intf_header_id_tbl(i)
2094: AND p_headers.error_flag_tbl(i) = FND_API.g_FALSE
2095: AND p_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET
2096: AND COALESCE(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag, 'N') = 'Y';

Line 2122: -- po_headers_interface table

2118: -- There are 2 cases when new rows will be inserted
2119: -- into po_distributions_draft_all table:
2120: -- 1. encumberance is required for new blanket: the
2121: -- attribute values will be read from
2122: -- po_headers_interface table
2123: -- 2. valid distribution rows exist in interface table:
2124: -- attribute values will be read from
2125: -- po_distributions_interface table
2126: -- This procedure will handle the first case

Line 2154: -- add distribution row from po_headers_interface table

2150: IF (PO_LOG.d_proc) THEN
2151: PO_LOG.proc_begin(d_module);
2152: END IF;
2153:
2154: -- add distribution row from po_headers_interface table
2155: IF (PO_PDOI_PARAMS.g_request.document_type =
2156: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
2157: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2158: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN

Line 2244: -- po_headers_interface table

2240: -- There are 2 cases when new rows will be inserted
2241: -- into po_distributions_draft_all table:
2242: -- 1. encumberance is required for new blanket: the
2243: -- attribute values will be read from
2244: -- po_headers_interface table
2245: -- 2. valid distribution rows exist in interface table:
2246: -- attribute values will be read from
2247: -- po_distributions_interface table
2248: -- This procedure will handle the second case