1 PACKAGE CSP_REPAIR_PO_GRP AUTHID CURRENT_USER AS
2 /* $Header: cspgrpos.pls 120.4.12020000.3 2013/04/12 19:35:09 vidsrini 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 ,P_Shipping_method IN varchar2 DEFAULT FND_API.G_MISS_CHAR
59 ,x_requisition_header_id OUT NOCOPY NUMBER
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 FUNCTION GET_ORGANIZATION_NAME
66 (P_dest_organization_id NUMBER
67 ) return VARCHAR2;
68
69 PROCEDURE GET_ITEM_DETAILS
70 (P_organization_id IN NUMBER
71 ,P_inventory_item_id IN NUMBER
72 ,x_item_number OUT NOCOPY VARCHAR2
73 ,x_item_description OUT NOCOPY VARCHAR2
74 ,x_primary_uom_code OUT NOCOPY VARCHAR2
75 ,x_return_status OUT NOCOPY VARCHAR2
76 ,x_msg_data OUT NOCOPY VARCHAR2
77 ,x_msg_count OUT NOCOPY NUMBER
78 );
79
80 PROCEDURE CREATE_CSP_SNAP_LOG ;
81
82 Procedure create_csp_index
83 (p_sql_stmt IN varchar2,
84 p_object IN varchar2);
85
86
87 END CSP_REPAIR_PO_GRP; -- Package spec
[Home] [Help]