[Home] [Help]
PACKAGE: APPS.ASO_INSTDTLS_INT
Source
1 PACKAGE ASO_instdtls_INT as
2 /* $Header: asoisers.pls 120.3 2006/03/29 10:21:58 hagrawal ship $ */
3 -- Start of Comments
4 -- Package name : ASO_Installdetails_INT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11
12 --
13 --
14 -- Record types
15 --
16 -- Inst_detail_rec_type
17 -- Contact_Rec_Type
18 -- System_Rec_Type
19 -- Cascade_Line_Rec_Type
20 --
21 --
22 -- API
23 --
24 -- Create_Installation_Details
25 -- Update_Installation_Details
26 -- Delete_Installation_Details
27 -- Autocreate_systems
28 -- Update_Inst_Details_Order
29 --
30
31
32
33
34 -- Default number of records fetch per call
35 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
36
37 TYPE Inst_detail_rec_type IS RECORD
38 (
39 line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
40 order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
41 quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
42 source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
43 transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
44 system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
45 customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
46 type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
47 quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
48 installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
49 installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
50 installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
51 new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
52 new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
53 expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE,
54 start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
55 end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
56 object_version_number NUMBER DEFAULT FND_API.G_MISS_NUM
57 --desc_flex DFF_Rec_Type
58 );
59 G_MISS_Inst_detail_Rec Inst_detail_Rec_Type;
60 TYPE Inst_detail_Tbl_type IS TABLE OF Inst_detail_Rec_type
61 INDEX BY BINARY_INTEGER;
62 G_MISS_Inst_detail_Tbl Inst_detail_Tbl_Type;
63
64
65
66 TYPE Contact_Rec_Type IS RECORD
67 (
68 CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
69 CONTACT_TYPE VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 CS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, -- key to cs_contacts
71 OPERATION_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
72 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
73 OLD_CONTACT_ID NUMBER := FND_API.G_MISS_NUM, --needed internally by api
74 CONTACT_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR -- Added for Bug 1554869 shegde
75
76 );
77
78
79 G_MISS_Contact_Rec Contact_Rec_Type;
80 TYPE Contact_Tbl_type IS TABLE OF Contact_Rec_type
81 INDEX BY BINARY_INTEGER;
82 G_MISS_Contact_Tbl Contact_Tbl_Type;
83
84
85 TYPE System_Rec_Type IS RECORD
86 (
87 customer_id NUMBER,
88 NAME VARCHAR2(240),
89 DESCRIPTION VARCHAR2(240),
90 system_type_code VARCHAR2(50),
91 number_to_create NUMBER,
92 install_site_use_id NUMBER DEFAULT NULL,
93 technical_contact_id NUMBER DEFAULT NULL,
94 service_admin_contact_id NUMBER DEFAULT NULL,
95 ship_to_site_use_id NUMBER DEFAULT NULL,
96 ship_to_contact_id NUMBER DEFAULT NULL,
97 bill_to_site_use_id NUMBER DEFAULT NULL,
98 bill_to_contact_id NUMBER DEFAULT NULL,
99 config_system_type VARCHAR2(150) DEFAULT NULL,
100 start_date_active DATE DEFAULT NULL,
101 end_date_active DATE DEFAULT NULL,
102 attribute1 VARCHAR2(150) DEFAULT NULL,
103 attribute2 VARCHAR2(150) DEFAULT NULL,
104 attribute3 VARCHAR2(150) DEFAULT NULL,
105 attribute4 VARCHAR2(150) DEFAULT NULL,
106 attribute5 VARCHAR2(150) DEFAULT NULL,
107 attribute6 VARCHAR2(150) DEFAULT NULL,
108 attribute7 VARCHAR2(150) DEFAULT NULL,
109 attribute8 VARCHAR2(150) DEFAULT NULL,
110 attribute9 VARCHAR2(150) DEFAULT NULL,
111 attribute10 VARCHAR2(150) DEFAULT NULL,
112 attribute11 VARCHAR2(150) DEFAULT NULL,
113 attribute12 VARCHAR2(150) DEFAULT NULL,
114 attribute13 VARCHAR2(150) DEFAULT NULL,
115 attribute14 VARCHAR2(150) DEFAULT NULL,
116 attribute15 VARCHAR2(150) DEFAULT NULL,
117 attribute_category VARCHAR2(150) DEFAULT NULL
118 );
119
120 G_MISS_System_Rec System_Rec_Type;
121 TYPE System_Tbl_type IS TABLE OF System_Rec_type
122 INDEX BY BINARY_INTEGER;
123 G_MISS_System_Tbl System_Tbl_Type;
124
125
126 TYPE Cascade_Line_Rec_Type IS RECORD
127 (
128 LINE_ID NUMBER := FND_API.G_MISS_NUM,
129 PARENT_LINE_ID NUMBER := FND_API.G_MISS_NUM,
130 QTY_FACTOR NUMBER := 1,
131 INST_DETAIL_CREATED VARCHAR2(1) := FND_API.G_FALSE
132 );
133
134
135 G_MISS_Cascade_Line_Rec Cascade_Line_Rec_Type;
136 TYPE Cascade_Line_Tbl_type IS TABLE OF Cascade_Line_Rec_type
137 INDEX BY BINARY_INTEGER;
138 G_MISS_Cascade_line_Tbl Cascade_Line_Tbl_Type;
139
140 --G_MISS_DFF_rec CS_Installedbase_PUB.DFF_rec_type;
141
142
143
144 TYPE Line_Inst_Rec_Type IS RECORD
145 (
146 LINE_ID NUMBER := FND_API.G_MISS_NUM,
147 INST_DETAIL_ID NUMBER := FND_API.G_MISS_NUM,
148 QUANTITY NUMBER := FND_API.G_MISS_NUM
149 );
150
151
152 G_MISS_Line_Inst_Rec Line_Inst_Rec_Type;
153 TYPE Line_Inst_Tbl_type IS TABLE OF Line_Inst_Rec_type
154 INDEX BY BINARY_INTEGER;
155 G_MISS_line_Inst_Tbl Line_Inst_Tbl_Type;
156
157 TYPE Name_Rec_Type IS RECORD(
158 system_id NUMBER,
159 name VARCHAR2(50));
160
161 TYPE name_tbl_type IS TABLE OF Name_Rec_Type
162 index by BINARY_INTEGER;
163
164 G_System_name_tbl Name_Tbl_Type;
165
166 Function Get_System_Rec Return System_rec_type ;
167
168 -- *******************************************************
169 -- Start of Comments
170 -- *******************************************************
171 -- API Name: Create_Installation_Details
172 -- Type : Public
173 -- Pre-Req :
174 -- Parameters:
175 --
176 -- Standard IN Parameters:
177 -- p_api_version IN NUMBER Required
178 -- p_init_msg_list IN VARCHAR2 Optional
179 -- Default = FND_API.G_FALSE
180 --
181 -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
182 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
183 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
184 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
185 --
186 -- Create_Installation_Details IN Parameters:
187 -- p_line_inst_dtl_rec Line_Inst_Dtl_Rec_Type Required
188 -- p_cascade_line_tbl IN Cascade_line_tbl_type DEFAULT = G_MISS_Cascade_Line_Tbl
189
190 -- Create_Installation_Details OUT NOCOPY /* file.sql.39 change */ Parameters:
191 -- x_line_inst_dtl_id NUMBER
192 --
193 -- End of Comments
194 --
195 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
196 -- The Master delete procedure may not be needed depends on different business requirements.
197
198
199 PROCEDURE Create_Installation_Detail
200 (
201 p_api_version_number IN NUMBER,
202 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
203 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
204 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
205 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
206 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
207 -- p_object_version_number IN NUMBER,
208 p_line_inst_dtl_tbl IN Inst_Detail_tbl_type,
209 p_cascade_line_tbl IN cascade_line_tbl_type DEFAULT G_MISS_Cascade_Line_Tbl,
210 p_contact_tbl IN contact_tbl_type DEFAULT G_MISS_Contact_Tbl,
211 x_line_inst_dtl_id OUT NOCOPY /* file.sql.39 change */ NUMBER
212
213 );
214
215 -- API name : Update_Installation_Details
216 -- Type : Public
217 -- Function : This API is used to update Installation details records.
218 -- Pre-reqs : None.
219 --
220 -- Standard IN Parameters:
221 -- p_api_version_number IN NUMBER Required
222 -- p_init_msg_list IN VARCHAR2 Optional
223 -- Default = FND_API.G_FALSE
224 --
225 -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
226 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
227 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
228 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
229 --
230 -- Update_Installation_Details IN Parameters:
231 -- p_line_inst_dtl_id NUMBER Required
232 -- p_line_inst_dtl_tbl Line_Inst_Dtl_Tbl_Type Required
233
234 -- Update_Installation_Details OUT NOCOPY /* file.sql.39 change */ Parameters:
235 -- None
236 --
237 -- Version : Current version 1.0
238 -- Initial version 1.0
239 --
240 -- End of comments
241 --------------------------------------------------------------------------
242
243 PROCEDURE Update_Installation_Detail
244 (
245 p_api_version_number IN NUMBER,
246 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
247 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
248 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
249 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
250 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
251 p_object_version_number IN NUMBER,
252 p_line_inst_dtl_tbl IN Inst_Detail_Tbl_Type,
253 p_contact_tbl IN contact_tbl_type DEFAULT G_MISS_Contact_Tbl,
254 p_cascade_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE );
255
256
257 --------------------------------------------------------------------------
258
259 -- Start of comments
260 -- API name : Delete_Installation_Details
261 -- Type : Public
262 -- Function : This API is used to delete Installation details records.
263 -- Pre-reqs : None.
264 --
265 -- Standard IN Parameters:
266 -- p_api_version_number IN NUMBER Required
267 -- p_init_msg_list IN VARCHAR2 Optional
268 -- Default = FND_API.G_FALSE
269 --
270 -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
271 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
272 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
273 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
274 --
275 -- Delete_Installation_Details IN Parameters:
276 -- p_line_inst_dtl_id NUMBER Required
277
278 -- Delete_Installation_Details OUT NOCOPY /* file.sql.39 change */ Parameters:
279 -- None
280 --
281 -- Version : Current version 1.0
282 -- Initial version 1.0
283 --
284 -- End of comments
285 --------------------------------------------------------------------------
286
287 PROCEDURE Delete_Installation_Detail
288 (
289 p_api_version_number IN NUMBER,
290 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
291 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
292 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
293 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
294 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
295 p_line_inst_dtl_id IN NUMBER
296 );
297
298
299 PROCEDURE Autocreate_systems
300 (
301 p_api_version_number IN NUMBER,
302 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
303 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
304 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
305 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
306 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
307 -- p_system_tbl IN OUT NOCOPY /* file.sql.39 change */ System_Tbl_Type
308 p_system_rec IN System_Rec_Type ,
309 x_system_name_tbl OUT NOCOPY /* file.sql.39 change */ Name_tbl_type
310 );
311
312 PROCEDURE Update_Inst_Details_ORDER
313 (
314 p_api_version_number IN NUMBER,
315 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
318 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
319 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
320 p_quote_line_shipment_id IN NUMBER,
321 p_order_line_id IN NUMBER
322 );
323
324
325 PROCEDURE CASCADE_DETAILS_YN(
326 p_api_version IN NUMBER,
327 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
328 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
329 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
330 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
331 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
332 p_object_version_number IN NUMBER,
333 p_cascade_line_rec IN cascade_line_rec_type,
334 x_line_inst_dtl_id OUT NOCOPY /* file.sql.39 change */ NUMBER);
335
336
337 END ASO_instdtls_INT;