1 PACKAGE CSP_REPAIR_PO_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspgrexs.pls 120.1.12020000.2 2013/03/25 22:16:17 vidsrini ship $ */
3
4 -- Start of Comments
5 -- Package name : CSP_REPAIR_PO_GRP
6 -- Purpose : This package creates Repair Purchase Order Execution details.
7 -- History :
8 -- NOTE :
9 -- End of Comments
10 -- MODIFICATION HISTORY
11 -- Person Date Comments
12 -- --------- ------ ------------------------------------------
13 -- ajosephg 07/05/05 Created Package
14
15
16 TYPE out_reserve_rec_type IS RECORD(need_by_date DATE
17 ,organization_id NUMBER
18 ,item_id NUMBER
19 ,item_uom_code VARCHAR2(3)
20 ,quantity_needed NUMBER
21 ,sub_inventory_code VARCHAR2(10)
22 ,line_id NUMBER
23 ,revision VARCHAR2(3)
24 ,reservation_id NUMBER);
25
26 /** Errbuf returns error messages
27 Retcode returns 0 = Success, 1 = Success with warnings, 2 = Error
28 **/
29
30 PROCEDURE RUN_REPAIR_EXECUTION
31 (errbuf OUT NOCOPY VARCHAR2,
32 retcode OUT NOCOPY NUMBER,
33 p_Api_Version_Number IN NUMBER,
34 p_repair_po_header_id IN NUMBER default null
35 );
36
37 PROCEDURE REP_PO_SCRAP_ADJUST_TRANSACT
38 (p_Api_Version_Number IN NUMBER
39 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
40 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
41 ,p_REPAIR_PO_HEADER_ID IN NUMBER
42 ,p_SCRAP_ADJUST_FLAG IN VARCHAR2
43 ,p_SCRAP_ADJUST_ITEM_ID IN NUMBER
44 ,p_SCRAP_ADJUST_QTY IN NUMBER
45 ,p_SCRAP_ADJUST_DATE IN DATE
46 ,p_reason_id IN NUMBER --VIDYA ADDED HERE
47 ,x_return_status OUT NOCOPY VARCHAR2
48 ,x_msg_count OUT NOCOPY NUMBER
49 ,x_msg_data OUT NOCOPY VARCHAR2
50 );
51 Function Get_CSP_Acccount_ID (p_organization_id NUMBER, p_SCRAP_ADJUST_FLAG varchar2,Prof_val varchar2)--Vidya added this function 12/3/2013
52 Return NUMBER;
53
54 END CSP_REPAIR_PO_PVT; -- Package spec