APPS.PO_PDOI_PREPROC_PVT dependencies on PO_HEADERS_ALL

Line 1184: po_headers_all POH

1180: INTO l_rel_exists
1181: FROM DUAL
1182: WHERE EXISTS (SELECT 'Exists std PO ref the orig GA'
1183: FROM po_lines_all POL,
1184: po_headers_all POH
1185: WHERE POL.from_header_id = p_po_header_id
1186: AND POL.po_header_id = POH.po_header_id
1187: AND POH.creation_date >= l_exp_date);
1188:

Line 1280: l_doc_num_for_msg_dsp PO_HEADERS_ALL.segment1%TYPE;

1276: l_col_name PO_INTERFACE_ERRORS.column_name%TYPE;
1277: l_col_value PO_INTERFACE_ERRORS.column_value%TYPE;
1278: l_token_name VARCHAR2(100);
1279: l_token_value VARCHAR2(100);
1280: l_doc_num_for_msg_dsp PO_HEADERS_ALL.segment1%TYPE;
1281:
1282: l_skip_cat_upload_chk VARCHAR2(1);
1283:
1284: l_status_rec PO_STATUS_REC_TYPE;

Line 1290: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;

1286:
1287: l_orig_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1288: l_orig_consumption_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1289:
1290: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
1291:
1292: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1293: l_final_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1294:

Line 1424: FROM po_headers_all

1420: -- po_header_id, we attempt to derive document number
1421: -- from po_header_id
1422: SELECT NVL(MIN(segment1), 'UNKNOWN')
1423: INTO l_doc_num_for_msg_dsp
1424: FROM po_headers_all
1425: WHERE po_header_id = l_po_header_id_tbl(i);
1426:
1427: PO_PDOI_ERR_UTL.add_fatal_error
1428: ( p_interface_header_id => l_interface_header_id_tbl(i),