PACKAGE: APPS.CSP_REPAIR_ORDER_PKG

Source

1 PACKAGE csp_repair_order_pkg AUTHID CURRENT_USER AS
2 /* $Header: cspgrors.pls 120.0.12020000.4 2013/03/21 04:03:13 sunarasi noship $ */
3 -- Start of Comments
4 -- Package name     :csp_repair_order_pkg
5 -- Purpose          :
6 -- History          :
7 --  01-Mar-13, sunarasi
8 --
9 -- NOTE             :
10 -- End of Comments
11  TYPE REF_CURSOR IS REF CURSOR;
12  TYPE ORD_CURSOR IS REF CURSOR;
13   FUNCTION REPAIR_ORDER_DETAILS
14       (p_item_id	NUMBER,
15        p_org_id	NUMBER,
16        p_item_number VARCHAR2,
17        p_uom VARCHAR2,
18        p_quantity NUMBER,
19        p_subinv VARCHAR2) RETURN ref_cursor;
20 
21   FUNCTION create_repair_order
22                 (p_item_id	NUMBER,
23                  p_org_id	NUMBER,
24                  p_dest_org_id	NUMBER,
25                  p_need_by_date DATE,
26                  p_uom VARCHAR2,
27                  P_QTY		NUMBER,
28                  p_repair_supplier_id NUMBER) return ord_cursor;
29 END;