APPS.INV_DIAG_RCV_PO dependencies on INV_DIAG_RCV_PO

Line 1: PACKAGE BODY inv_diag_rcv_po AS

1: PACKAGE BODY inv_diag_rcv_po AS
2: /* $Header: INVDPO1B.pls 120.2 2008/02/01 05:59:19 ssadasiv noship $ */
3: ------------------------------------------------------------
4: -- procedure to initialize test datastructures
5: -- executes prior to test run

Line 97: po_sql INV_DIAG_RCV_PO_COMMON.sqls_list; -- Table of varchar2

93: l_count NUMBER := 0;
94:
95: sql_text VARCHAR2(6000); -- Text variable to hold the sqls
96:
97: po_sql INV_DIAG_RCV_PO_COMMON.sqls_list; -- Table of varchar2
98: l_skip_rest VARCHAR2(1):= 'N'; -- Flag for skipping a Data collection Package call.
99:
100: dummy_num NUMBER;
101: l_operating_id po_headers_all.org_id%TYPE;

Line 257: INV_DIAG_RCV_PO_COMMON.build_all_sql(l_operating_id,l_po_number,l_line_num,l_line_loc_num,l_org_id,l_receipt_num,po_sql);

253: l_receipt_num IS NOT NULL AND
254: l_org_id IS NOT NULL AND
255: l_skip_rest = 'N' THEN
256:
257: INV_DIAG_RCV_PO_COMMON.build_all_sql(l_operating_id,l_po_number,l_line_num,l_line_loc_num,l_org_id,l_receipt_num,po_sql);
258: l_skip_rest := 'Y';
259: END if;
260:
261: -- Below procedure will handle both PO,OU and PO,OU,PLL,POL

Line 266: INV_DIAG_RCV_PO_COMMON.build_po_all_sql(l_operating_id,l_po_number,l_line_num,l_line_loc_num,po_sql);

262: IF l_po_number IS NOT NULL AND
263: l_operating_id IS NOT NULL AND
264: l_skip_rest = 'N' THEN
265:
266: INV_DIAG_RCV_PO_COMMON.build_po_all_sql(l_operating_id,l_po_number,l_line_num,l_line_loc_num,po_sql);
267: l_skip_rest := 'Y';
268: END if;
269:
270: IF l_receipt_num IS NOT NULL AND

Line 681: END INV_DIAG_RCV_PO;

677: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
678: END runTest;
679:
680:
681: END INV_DIAG_RCV_PO;