DBA Data[Home] [Help]

APPS.INV_DIAG_RCV_IPROC dependencies on PO_HEADERS_ALL

Line 100: l_operating_id po_headers_all.org_id%TYPE;

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;

Line 101: l_req_number po_headers_all.segment1%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:

Line 275: PO_HEADERS_ALL'||'

271: PO_REQUISITION_LINES_ALL'||'
272: PO_REQ_DISTRIBUTIONS_ALL'||'
273: '||'
274: '||'
275: PO_HEADERS_ALL'||'
276: PO_LINES_ALL'||'
277: PO_LINE_LOCATIONS_ALL'||'
278: '||'
279: '||'

Line 374: JTF_DIAGNOSTIC_COREAPI.insert_html('');

370:
371: sql_text := po_sql(4);
372:
373: JTF_DIAGNOSTIC_COREAPI.insert_html('

Purchase Order Details

');
374: JTF_DIAGNOSTIC_COREAPI.insert_html('');
375: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');
376: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
377: JTF_DIAGNOSTIC_COREAPI.BRPrint;
378:

Line 375: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');

371: sql_text := po_sql(4);
372:
373: JTF_DIAGNOSTIC_COREAPI.insert_html('

Purchase Order Details

');
374: JTF_DIAGNOSTIC_COREAPI.insert_html('');
375: JTF_DIAGNOSTIC_COREAPI.insert_html('PO_HEADERS_ALL  [Top]');
376: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sql_text,'');
377: JTF_DIAGNOSTIC_COREAPI.BRPrint;
378:
379: sql_text := po_sql(5);