1: PACKAGE BODY CSP_REPAIR_PO_PVT AS
2: /* $Header: cspgrexb.pls 120.21.12020000.12 2013/04/10 22:58:34 vidsrini ship $ */
3:
4: -- Purpose: To create Repair execution
5: -- Start of Comments
2: /* $Header: cspgrexb.pls 120.21.12020000.12 2013/04/10 22:58:34 vidsrini ship $ */
3:
4: -- Purpose: To create Repair execution
5: -- Start of Comments
6: -- Package name : CSP_REPAIR_PO_PVT
7: -- Purpose : This package creates Repair Purchase Order Execution details.
8: -- History : 05-July-2005, Arul Joseph.
9: -- NOTE :
10: -- End of Comments
8: -- History : 05-July-2005, Arul Joseph.
9: -- NOTE :
10: -- End of Comments
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_REPAIR_PO_PVT';
13: G_FILE_NAME CONSTANT VARCHAR2(30) := 'cspgrexb.pls';
14:
15: Procedure Add_Err_Msg Is
16: l_msg_index_out NUMBER;
170:
171: EXCP_USER_DEFINED EXCEPTION;
172:
173: x_relieved_quantity NUMBER;
174: l_reservation_rec CSP_REPAIR_PO_PVT.out_reserve_rec_type;
175:
176: x_item_number VARCHAR2(40);
177: x_item_description VARCHAR2(240);
178: l_primary_uom_code VARCHAR2(3);
2217: Close l_Get_Account_Id_Csr;
2218: Return l_account_id;
2219: End Get_CSP_Acccount_ID;
2220:
2221: END CSP_REPAIR_PO_PVT;