APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_HEADERS_INTERFACE

Line 2242: FROM po_headers_interface

2238: p_headers.clm_max_order_amount_tbl(i),
2239: p_headers.clm_amount_released_tbl(i),
2240: p_headers.fon_ref_id_tbl(i),
2241: p_headers.clm_contract_officer_tbl(i)
2242: FROM po_headers_interface
2243: WHERE interface_header_id = p_headers.intf_header_id_tbl(i)
2244: AND p_headers.error_flag_tbl(i) = FND_API.g_FALSE;
2245:
2246: IF (PO_LOG.d_proc) THEN

Line 2328: FROM po_headers_interface

2324: p_headers.last_updated_by_tbl(i),
2325: p_headers.last_update_login_tbl(i),
2326: p_headers.creation_date_tbl(i),
2327: p_headers.created_by_tbl(i)
2328: FROM po_headers_interface
2329: WHERE interface_header_id = p_headers.intf_header_id_tbl(i)
2330: AND p_headers.error_flag_tbl(i) = FND_API.g_FALSE
2331: AND p_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET
2332: AND COALESCE(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag, 'N') = 'Y';

Line 2358: -- po_headers_interface table

2354: -- There are 2 cases when new rows will be inserted
2355: -- into po_distributions_draft_all table:
2356: -- 1. encumberance is required for new blanket: the
2357: -- attribute values will be read from
2358: -- po_headers_interface table
2359: -- 2. valid distribution rows exist in interface table:
2360: -- attribute values will be read from
2361: -- po_distributions_interface table
2362: -- This procedure will handle the first case

Line 2390: -- add distribution row from po_headers_interface table

2386: IF (PO_LOG.d_proc) THEN
2387: PO_LOG.proc_begin(d_module);
2388: END IF;
2389:
2390: -- add distribution row from po_headers_interface table
2391: IF (PO_PDOI_PARAMS.g_request.document_type =
2392: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
2393: PO_PDOI_PARAMS.g_sys.po_encumbrance_flag = 'Y' AND
2394: PO_PDOI_PARAMS.g_sys.req_encumbrance_flag = 'Y') THEN

Line 2480: -- po_headers_interface table

2476: -- There are 2 cases when new rows will be inserted
2477: -- into po_distributions_draft_all table:
2478: -- 1. encumberance is required for new blanket: the
2479: -- attribute values will be read from
2480: -- po_headers_interface table
2481: -- 2. valid distribution rows exist in interface table:
2482: -- attribute values will be read from
2483: -- po_distributions_interface table
2484: -- This procedure will handle the second case