1 PACKAGE CS_Inst_Detail_PUB AUTHID CURRENT_USER AS
2 /* $Header: cspinsds.pls 120.1 2006/03/27 16:12:50 epajaril noship $ */
3
4 -- ---------------------------------------------------------
5 -- Declare Data Types
6 -- ---------------------------------------------------------
7 -- Added the line_inst_detail_id to this record type becoz this same record type
8 -- is used for getting the line installation details given an order_line_id and
9 -- it must return the line_inst_detail_id.
10 -- Also, had to remove desc_flex from this record type since a PL/SQL table
11 -- cannot be based on a record type that is non-scalar.
12
13 TYPE Line_Inst_Dtl_Rec_Type IS RECORD
14 (
15 line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
16 order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
17 quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
18 source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
19 transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
20 system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
21 customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
22 type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
23 quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
24 installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
25 installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
26 installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
27 new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
28 new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
29 expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
30 start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
31 end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
32 rcv_transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM -- Added shegde
33 --desc_flex DFF_Rec_Type
34 );
35
36 TYPE Line_Inst_Dtl_Tbl_Type is TABLE OF Line_Inst_Dtl_Rec_Type
37 INDEX BY BINARY_INTEGER;
38
39
40 TYPE Rma_Rcpt_Rec_Type IS RECORD
41 (
42 line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43 quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
44 rcv_transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM
45 );
46
47 TYPE Rma_Rcpt_Tbl_Type is TABLE OF Rma_Rcpt_Rec_Type
48 INDEX BY BINARY_INTEGER;
49
50 --------------------------------------------------------------------------
51 PROCEDURE Get_Line_Inst_Details
52 (
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_line_inst_detail_id IN NUMBER,
60 x_line_inst_dtl_rec OUT NOCOPY Line_Inst_Dtl_Rec_Type,
61 x_line_inst_dtl_desc_flex OUT NOCOPY CS_InstalledBase_PUB.DFF_Rec_Type
62 );
63
64 /* Over Loaded Procedure Specifications */
65
66 PROCEDURE Get_Line_Inst_Details
67 (
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_order_line_id IN NUMBER,
75 x_line_inst_dtl_tbl OUT NOCOPY Line_Inst_Dtl_Tbl_Type,
76 x_line_inst_dtl_tbl_count OUT NOCOPY NUMBER
77 );
78
79 /* Added for RMA Returns Bug 1500577 shegde */
80
81 PROCEDURE Get_rma_line_Inst_Details
82 (
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_rma_only IN VARCHAR2 DEFAULT FND_API.G_TRUE,
90 p_order_line_id IN NUMBER,
91 x_line_inst_dtl_tbl OUT NOCOPY CS_INST_DETAIL_PUB.Line_Inst_Dtl_Tbl_Type,
92 x_line_inst_dtl_tbl_count OUT NOCOPY NUMBER
93 );
94
95
96
97 --------------------------------------------------------------------------
98 --------------------------------------------------------------------------
99
100 -- Start of comments
101 -- API name : Create_Installation_Details
102 -- Type : Public
103 -- Function : This API is used to create Installation details records.
104 -- Pre-reqs : None.
105 --
106 -- Standard IN Parameters:
107 -- p_api_version IN NUMBER Required
108 -- p_init_msg_list IN VARCHAR2 Optional
109 -- Default = FND_API.G_FALSE
110 --
111 -- Standard OUT NOCOPY Parameters:
112 -- x_return_status OUT NOCOPY VARCHAR2(1)
113 -- x_msg_count OUT NOCOPY NUMBER
114 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
115 --
116 -- Create_Installation_Details IN Parameters:
117 -- p_line_inst_dtl_rec Line_Inst_Dtl_Rec_Type Required
118 -- p_line_inst_dtl_desc_flex DFF_Rec_Type
119
120 -- Create_Installation_Details OUT NOCOPY Parameters:
121 -- x_line_inst_detail_id NUMBER
122 --
123 -- Version : Current version 1.0
124 -- Initial version 1.0
125 --
126 -- End of comments
127 --------------------------------------------------------------------------
128
129 PROCEDURE Create_Installation_Details
130 (
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
133 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_line_inst_dtl_rec IN Line_Inst_Dtl_Rec_Type,
138 p_line_inst_dtl_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
139 p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
140 x_line_inst_detail_id OUT NOCOPY NUMBER,
141 x_object_version_number OUT NOCOPY NUMBER -- was commented
142 );
143
144
145 --------------------------------------------------------------------------
146
147 -- Start of comments
148 -- API name : Update_Installation_Details
149 -- Type : Public
150 -- Function : This API is used to update Installation details records.
151 -- Pre-reqs : None.
152 --
153 -- Standard IN Parameters:
154 -- p_api_version IN NUMBER Required
155 -- p_init_msg_list IN VARCHAR2 Optional
156 -- Default = FND_API.G_FALSE
157 --
158 -- Standard OUT NOCOPY Parameters:
159 -- x_return_status OUT NOCOPY VARCHAR2(1)
160 -- x_msg_count OUT NOCOPY NUMBER
161 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
162 --
163 -- Update_Installation_Details IN Parameters:
164 -- p_line_inst_dtl_rec Line_Inst_Dtl_Rec_Type Required
165 -- p_line_inst_dtl_desc_flex DFF_Rec_Type
166
167 -- Update_Installation_Details OUT NOCOPY Parameters:
168 -- None
169 --
170 -- Version : Current version 1.0
171 -- Initial version 1.0
172 --
173 -- End of comments
174 --------------------------------------------------------------------------
175
176 PROCEDURE Update_Installation_Details
177 (
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
180 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_line_inst_dtl_rec IN Line_Inst_Dtl_Rec_Type,
185 p_line_inst_dtl_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
186 p_object_version_number IN NUMBER,
187 x_object_version_number OUT NOCOPY NUMBER -- was commented
188 );
189
190
191 --------------------------------------------------------------------------
192
193 -- Start of comments
194 -- API name : Delete_Installation_Details
195 -- Type : Public
196 -- Function : This API is used to delete Installation details records.
197 -- Pre-reqs : None.
198 --
199 -- Standard IN Parameters:
200 -- p_api_version IN NUMBER Required
201 -- p_init_msg_list IN VARCHAR2 Optional
202 -- Default = FND_API.G_FALSE
203 --
204 -- Standard OUT NOCOPY Parameters:
205 -- x_return_status OUT NOCOPY VARCHAR2(1)
206 -- x_msg_count OUT NOCOPY NUMBER
207 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
208 --
209 -- Delete_Installation_Details IN Parameters:
210 -- p_line_inst_detail_id NUMBER Required
211
212 -- Delete_Installation_Details OUT NOCOPY Parameters:
213 -- None
214 --
215 -- Version : Current version 1.0
216 -- Initial version 1.0
217 --
218 -- End of comments
219 --------------------------------------------------------------------------
220
221 PROCEDURE Delete_Installation_Details
222 (
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
225 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_line_inst_detail_id IN NUMBER--,
230 -- p_object_version_number IN NUMBER
231 );
232
233 /* Added this Procedure for RMA Returns Bug 1500577 shegde */
234
235 PROCEDURE Update_Inst_Details_RMA_Rcpt
236 (
237 p_api_version IN NUMBER,
238 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
239 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_rcpt_tbl IN RMA_RCPT_TBL_TYPE,
244 p_rcpt_tbl_count IN NUMBER,
245 p_order_line_id IN NUMBER,
246 p_cp_id IN NUMBER,
247 p_serial_flag IN VARCHAR2,
248 p_object_version_number IN NUMBER,
249 x_object_version_number OUT NOCOPY NUMBER
250 ) ;
251
252 END CS_Inst_Detail_PUB;