1 PACKAGE CSP_REPAIR_PO_GRP AUTHID CURRENT_USER AS
2 /* $Header: cspgrpos.pls 120.4 2007/09/19 18:38:42 ajosephg ship $ */
3 -- Start of Comments
4 -- Package name : CSP_REPAIR_PO_GRP
5 -- Purpose : This package creates Repair Purchase Order Requisition and Reservation of defective parts.
6 -- History :
7 -- NOTE :
8 -- End of Comments
9 -- MODIFICATION HISTORY
10 -- Person Date Comments
11 -- --------- ------ ------------------------------------------
12 -- ajosephg 01/22/01 Created Package
13
14 TYPE defective_parts_rec_type IS RECORD
15 (defective_item_id NUMBER
16 ,defective_quantity NUMBER
17 );
18
19 TYPE defective_parts_tbl_Type IS TABLE OF defective_parts_rec_type
20 INDEX BY BINARY_INTEGER;
21
22 TYPE defect_parts_reserve_rec_type IS RECORD
23 (defective_item_id NUMBER
24 ,defective_quantity NUMBER
25 ,reservation_id NUMBER
26 );
27
28 TYPE defect_parts_reserve_tbl_Type IS TABLE OF defect_parts_reserve_rec_type
29 INDEX BY BINARY_INTEGER;
30
31
32 TYPE out_reserve_rec_type IS RECORD(need_by_date DATE
33 ,organization_id NUMBER
34 ,item_id NUMBER
35 ,item_uom_code VARCHAR2(3)
36 ,quantity_needed NUMBER
37 ,sub_inventory_code VARCHAR2(10)
38 ,line_id NUMBER
39 ,revision VARCHAR2(3)
40 ,reservation_id NUMBER);
41
42 TYPE out_reserve_tbl_Type IS TABLE OF out_reserve_rec_type
43 INDEX BY BINARY_INTEGER;
44
45 PROCEDURE CREATE_REPAIR_PO
46 (p_api_version IN NUMBER
47 ,p_Init_Msg_List IN VARCHAR2 DEFAULT FND_API.G_FALSE
48 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
49 ,P_repair_supplier_id IN NUMBER
50 ,P_repair_supplier_org_id IN NUMBER
51 ,P_repair_program IN VARCHAR2
52 ,P_dest_organization_id IN NUMBER
53 ,P_source_organization_id IN NUMBER
54 ,P_repair_to_item_id IN NUMBER
55 ,P_quantity IN NUMBER
56 ,P_need_by_date IN DATE
57 ,P_defective_parts_tbl IN CSP_REPAIR_PO_GRP.defective_parts_tbl_Type
58 ,x_requisition_header_id OUT NOCOPY NUMBER
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 );
63
64 FUNCTION GET_ORGANIZATION_NAME
65 (P_dest_organization_id NUMBER
66 ) return VARCHAR2;
67
68 PROCEDURE GET_ITEM_DETAILS
69 (P_organization_id IN NUMBER
70 ,P_inventory_item_id IN NUMBER
71 ,x_item_number OUT NOCOPY VARCHAR2
72 ,x_item_description OUT NOCOPY VARCHAR2
73 ,x_primary_uom_code OUT NOCOPY VARCHAR2
74 ,x_return_status OUT NOCOPY VARCHAR2
75 ,x_msg_data OUT NOCOPY VARCHAR2
76 ,x_msg_count OUT NOCOPY NUMBER
77 );
78
79 PROCEDURE CREATE_CSP_SNAP_LOG ;
80
81 Procedure create_csp_index
82 (p_sql_stmt IN varchar2,
83 p_object IN varchar2);
84
85
86 END CSP_REPAIR_PO_GRP; -- Package spec