APPS.INV_DIAG_RCV_IPROC_COMMON dependencies on INV_DIAG_RCV_PO_COMMON

Line 9: p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list)

5: --------------------------------------------------
6: PROCEDURE build_req_sql(p_operating_id IN NUMBER,
7: p_req_number IN VARCHAR2,
8: p_line_num IN NUMBER,
9: p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list)
10: IS
11: -- Initialize Local Variables.
12: l_operating_id po_requisition_headers_all.org_id%TYPE := p_operating_id;
13: l_req_number po_requisition_headers_all.segment1%TYPE := p_req_number;

Line 1318: PROCEDURE build_req_rcv_sql(p_receipt_num IN VARCHAR2,p_org_id IN NUMBER,p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS

1314:
1315: -------------------------------------------------------
1316: -- Package to Build sqls for Receipt and OU combination
1317: -------------------------------------------------------
1318: PROCEDURE build_req_rcv_sql(p_receipt_num IN VARCHAR2,p_org_id IN NUMBER,p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
1319:
1320: -- Initialize Local Variables.
1321: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := p_receipt_num;
1322: l_org_id rcv_shipment_headers.organization_id%TYPE := p_org_id;

Line 1910: p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list)

1906: p_req_number IN VARCHAR2,
1907: p_line_num IN NUMBER,
1908: p_receipt_number IN VARCHAR2,
1909: p_org_id IN NUMBER,
1910: p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list)
1911: IS
1912:
1913: -- Initialize Local Variables.
1914: l_operating_id po_requisition_headers_all.org_id%TYPE := p_operating_id;