1: PACKAGE BODY csp_repair_order_pkg AS
2: /* $Header: cspgrorb.pls 120.0.12020000.5 2013/03/21 04:15:28 sunarasi noship $ */
3: -- Start of Comments
4: -- Package name : csp_repair_order_pkg
5: -- Purpose :
1: PACKAGE BODY csp_repair_order_pkg AS
2: /* $Header: cspgrorb.pls 120.0.12020000.5 2013/03/21 04:15:28 sunarasi noship $ */
3: -- Start of Comments
4: -- Package name : csp_repair_order_pkg
5: -- Purpose :
6: -- History :
7: -- 01-Mar-13, sunarasi
8: --
7: -- 01-Mar-13, sunarasi
8: --
9: -- NOTE :
10: -- End of Comments
11: G_PKG_NAME CONSTANT VARCHAR2(30):='CSP_REPAIR_ORDER_PKG';
12: FUNCTION REPAIR_ORDER_DETAILS
13: (p_item_id NUMBER,
14: p_org_id NUMBER,
15: p_item_number VARCHAR2,