[Home] [Help]
1262: INTO l_rel_exists
1263: FROM DUAL
1264: WHERE EXISTS (SELECT 'Exists std PO ref the orig GA'
1265: FROM po_lines_all POL,
1266: po_headers_all POH
1267: WHERE POL.from_header_id = p_po_header_id
1268: AND POL.po_header_id = POH.po_header_id
1269: AND POH.creation_date >= l_exp_date);
1270:
1358: l_col_name PO_INTERFACE_ERRORS.column_name%TYPE;
1359: l_col_value PO_INTERFACE_ERRORS.column_value%TYPE;
1360: l_token_name VARCHAR2(100);
1361: l_token_value VARCHAR2(100);
1362: l_doc_num_for_msg_dsp PO_HEADERS_ALL.segment1%TYPE;
1363:
1364: l_skip_cat_upload_chk VARCHAR2(1);
1365:
1366: l_status_rec PO_STATUS_REC_TYPE;
1368:
1369: l_orig_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1370: l_orig_consumption_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1371:
1372: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
1373:
1374: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1375: l_final_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1376:
1502: -- po_header_id, we attempt to derive document number
1503: -- from po_header_id
1504: SELECT NVL(MIN(segment1), 'UNKNOWN')
1505: INTO l_doc_num_for_msg_dsp
1506: FROM po_headers_all
1507: WHERE po_header_id = l_po_header_id_tbl(i);
1508:
1509: PO_PDOI_ERR_UTL.add_fatal_error
1510: ( p_interface_header_id => l_interface_header_id_tbl(i),
2198:
2199: /* PDOI for Complex PO Project: Logic for creating Pay items: Start */
2200: BEGIN
2201: SELECT Nvl(DECODE(PHI.po_header_id,NULL,PHI.style_id,
2202: (SELECT PH.style_id FROM po_headers_all PH
2203: WHERE PH.po_header_id = PHI.po_header_id)),1),
2204: -- In 'UPDATE' mode, the style_id corresponding to the base PO
2205: -- needs to be considered.
2206: PLI.interface_line_id,