[Home] [Help]
96: po_sql INV_DIAG_RCV_PO_COMMON.sqls_list; -- Table of varchar2
97: l_skip_rest VARCHAR2(1):= 'N'; -- Flag for skipping a Data collection Package call.
98:
99: dummy_num NUMBER;
100: l_operating_id po_headers_all.org_id%TYPE;
101: l_req_number po_headers_all.segment1%TYPE;
102: l_line_num po_lines_all.line_num%TYPE;
103: l_org_id rcv_shipment_headers.organization_id%TYPE;
104: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
97: l_skip_rest VARCHAR2(1):= 'N'; -- Flag for skipping a Data collection Package call.
98:
99: dummy_num NUMBER;
100: l_operating_id po_headers_all.org_id%TYPE;
101: l_req_number po_headers_all.segment1%TYPE;
102: l_line_num po_lines_all.line_num%TYPE;
103: l_org_id rcv_shipment_headers.organization_id%TYPE;
104: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
105:
271:
370:
371: sql_text := po_sql(4);
372:
373: JTF_DIAGNOSTIC_COREAPI.insert_html('
371: sql_text := po_sql(4);
372:
373: JTF_DIAGNOSTIC_COREAPI.insert_html('