1 PACKAGE CSI_JAVA_INTERFACE_PKG AS
2 /* $Header: csivjis.pls 120.10 2006/09/18 09:38:31 bnarayan noship $ */
3
4 /*----------------------------------------------------*/
5 /* ****************Important***************************/
6 /* This package is created for JAVA Interface to */
7 /* Installed Base(CSI). The procedures here are */
8 /* subject to change without notice. */
9 /*----------------------------------------------------*/
10
11 /**** contract Record ***/
12
13 TYPE csi_output_rec_ib IS RECORD
14
15 ( contract_id Number
16 ,contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
17 ,contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE
18 ,sts_code OKC_K_HEADERS_B.STS_CODE%TYPE
19 ,service_line_id Number
20 ,service_name VARCHAR2(300)
21 ,service_description VARCHAR2(300)
22 ,coverage_term_line_id Number
23 ,coverage_term_name OKC_K_LINES_V.NAME%TYPE
24 ,coverage_term_description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE
25 ,service_start_date Date
26 ,service_end_date Date
27 ,warranty_flag Varchar2(1)
28 ,eligible_for_entitlement Varchar2(1)
29 ,exp_reaction_time Date
30 ,exp_resolution_time Date
31 ,status_code Varchar2(1)
32 ,status_text Varchar2(1995)
33 ,date_terminated Date
34 );
35
36 TYPE csi_output_tbl_ib IS TABLE OF csi_output_rec_ib INDEX BY BINARY_INTEGER;
37
38 TYPE csi_coverage_rec_ib IS RECORD
39 (
40 covered_level_code VARCHAR2(100)
41 ,covered_level_id Number
42 );
43
44 TYPE csi_coverage_tbl_ib IS TABLE OF csi_coverage_rec_ib INDEX BY BINARY_INTEGER;
45
46 TYPE dpl_instance_rec is RECORD
47 ( INSTANCE_ID NUMBER);
48
49 TYPE dpl_instance_tbl IS TABLE OF dpl_instance_rec INDEX BY BINARY_INTEGER;
50
51
52 /*----------------------------------------------------*/
53 /* procedure name: create_item_instance */
54 /* description : procedure used to */
55 /* create item instances */
56 /*----------------------------------------------------*/
57
58 PROCEDURE create_item_instance
59 (
60 p_api_version IN NUMBER
61 ,p_commit IN VARCHAR2 := fnd_api.g_false
62 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
63 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
64 ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
65 ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
66 ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
67 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73 /*---------------------------------------------------*/
74 /* Procedure name: Split_Item_Instance */
75 /* Description : This procedure is used to create */
76 /* split lines for instance */
77 /*---------------------------------------------------*/
78
79 PROCEDURE Split_Item_Instance
80 (
81 p_api_version IN NUMBER
82 ,p_commit IN VARCHAR2 := fnd_api.g_false
83 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
84 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
85 ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
86 ,p_quantity1 IN NUMBER
87 ,p_quantity2 IN NUMBER
88 ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
89 ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
90 ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
91 ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
92 ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
93 ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
94 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
95 ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
96 ,x_return_status OUT NOCOPY VARCHAR2
97 ,x_msg_count OUT NOCOPY NUMBER
98 ,x_msg_data OUT NOCOPY VARCHAR2
99 );
100
101 /*---------------------------------------------------*/
102 /* Procedure name: Split_Item_Instance_lines */
103 /* Description : This procedure is used to create */
104 /* split lines for instance */
105 /*---------------------------------------------------*/
106 PROCEDURE Split_Item_Instance_Lines
107 (
108 p_api_version IN NUMBER
109 ,p_commit IN VARCHAR2 := fnd_api.g_false
110 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
111 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
112 ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
113 ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
114 ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
115 ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
116 ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
117 ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
118 ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
119 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
120 ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
121 ,x_return_status OUT NOCOPY VARCHAR2
122 ,x_msg_count OUT NOCOPY NUMBER
123 ,x_msg_data OUT NOCOPY VARCHAR2
124 );
125
126 /*---------------------------------------------------*/
127 /* procedure name: copy_item_instance */
128 /* description : Copies an instace from an instance */
129 /*---------------------------------------------------*/
130
131 PROCEDURE copy_item_instance
132 (
133 p_api_version IN NUMBER
134 ,p_commit IN VARCHAR2 := fnd_api.g_false
135 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
136 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
137 ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
138 ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
139 ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
140 ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
141 ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false
142 ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
143 ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
144 ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
145 ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
146 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
147 ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
148 ,x_return_status OUT NOCOPY VARCHAR2
149 ,x_msg_count OUT NOCOPY NUMBER
150 ,x_msg_data OUT NOCOPY VARCHAR2
151 );
152
153 /*----------------------------------------------------*/
154 /* procedure name: getContracts */
155 /* description : procedure used to */
156 /* get the contract details */
157 /*----------------------------------------------------*/
158 PROCEDURE getContracts
159 (
160 product_id IN Number
161 ,x_return_status OUT NOCOPY Varchar2
162 ,x_msg_count OUT NOCOPY Number
163 ,x_msg_data OUT NOCOPY Varchar2
164 ,x_output_contracts OUT NOCOPY csi_output_tbl_ib
165 );
166
167
168 /*----------------------------------------------------*/
169 /* procedure name: Get_Coverage_For_Prod_Sch */
170 /* description : procedure used to get contract */
171 /* coverage info for product search on*/
172 /* a given contract number */
173 /*----------------------------------------------------*/
174 PROCEDURE Get_Coverage_For_Prod_Sch
175 (
176 contract_number IN VARCHAR2 := fnd_api.g_miss_char
177 ,x_coverage_tbl OUT NOCOPY csi_coverage_tbl_ib
178 ,x_sequence_id OUT NOCOPY NUMBER
179 ,x_return_status OUT NOCOPY Varchar2
180 ,x_msg_count OUT NOCOPY Number
181 ,x_msg_data OUT NOCOPY Varchar2
182 );
183
184 /*----------------------------------------------------*/
185 /* procedure name: Get_Contract_Where_Clause */
186 /* description : procedure used to get Product */
187 /* Search where clause for a given */
188 /* contract number */
189 /* Note, will be depricated once */
190 /* Get_Coverage_For_Prod_Sch becomes stable. */
191 /*----------------------------------------------------*/
192 PROCEDURE Get_Contract_Where_Clause
193 (
194 contract_number IN VARCHAR2 := fnd_api.g_miss_char
195 ,instance_table_name IN VARCHAR2 := fnd_api.g_miss_char
196 ,x_where_clause OUT NOCOPY VARCHAR2
197 ,x_return_status OUT NOCOPY Varchar2
198 ,x_msg_count OUT NOCOPY Number
199 ,x_msg_data OUT NOCOPY Varchar2
200 );
201
202 /*---------------------------------------------------*/
203 /* procedure name: get_history_transactions */
204 /* description : Retreive history transactions */
205 /* */
206 /*---------------------------------------------------*/
207
208 PROCEDURE get_history_transactions
209 ( p_api_version IN NUMBER
210 ,p_commit IN VARCHAR2 := fnd_api.g_false
211 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
212 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
213 ,p_transaction_id IN NUMBER
214 ,p_instance_id IN NUMBER
215 ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
216 ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl
217 ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl
218 ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
219 ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
220 ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
221 ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
222 ,x_rel_history_tbl OUT NOCOPY csi_datastructures_pub.relationship_history_tbl
223 ,x_return_status OUT NOCOPY VARCHAR2
224 ,x_msg_count OUT NOCOPY NUMBER
225 ,x_msg_data OUT NOCOPY VARCHAR2
226 ) ;
227
228 ----------------------------------------------------------------------------------
229 -- API name : CSI_CONFIG_LAUNCH_PRMS
230 -- Package Name: CSI_JAVA_INTERFACE_PKG
231 -- Type : Public
232 -- Pre-reqs : None
233 -- Function: Returns the parameters necessary for launching the CZ configurator.
234 -- Version : Current version 1.0
235 -- Initial version 1.0
236
237 Procedure CSI_CONFIG_LAUNCH_PRMS
238 ( p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
240 p_commit IN VARCHAR2 := FND_API.g_false,
241 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 x_configurable OUT NOCOPY VARCHAR2,
246 x_icx_sessn_tkt OUT NOCOPY VARCHAR2,
247 x_db_id OUT NOCOPY VARCHAR2,
248 x_servlet_url OUT NOCOPY VARCHAR2,
249 x_sysdate OUT NOCOPY VARCHAR2
250 );
251
252 ----------------------------------------------------------------------------------
253 -- API name : is_configurable
254 -- Package Name: CSI_JAVA_INTERFACE_PKG
255 -- Type : Public
256 -- Pre-reqs : None
257 -- Function: Checks whether a config item is independently configurable or not.
258 -- Version : Current version 1.0
259 -- Initial version 1.0
260 -- Parameters:
261 -- IN: p_api_version (required), standard IN parameter
262 -- p_config_hdr_id (required), config_hdr_id of an instance
263 -- IN: p_config_hdr_id (required), config_hdr_id of an instance
264 -- p_config_hdr_id (required), config_hdr_id of an instance
265 -- p_config_rev_nbr (required), config_rev_nbr of an instance
266 -- p_config_item_id (required), config_item_id of an instance item
267 -- OUT: x_return_value, has one of the following values FND_API.G_TRUE, FND_API.G_FALSE,NULL
268 -- x_return_status, standard out parameter (see generate_config_trees)
269 -- x_msg_count, standard out parameter
270 -- x_msg_data, standard out parameter
271
272 PROCEDURE IS_CONFIGURABLE(p_api_version IN NUMBER
273 ,p_config_hdr_id IN NUMBER
274 ,p_config_rev_nbr IN NUMBER
275 ,p_config_item_id IN NUMBER
276 ,x_return_value OUT NOCOPY VARCHAR2
277 ,x_return_status OUT NOCOPY VARCHAR2
278 ,x_msg_count OUT NOCOPY NUMBER
279 ,x_msg_data OUT NOCOPY VARCHAR2
280 );
281
282
283
284
285 /*
286 procedure Name : get_instance_link_locations
287 description : Gets the start and end location for netwrok link item.
288 */
289 PROCEDURE get_instance_link_locations
290 (
291 p_api_version IN NUMBER
292 ,p_commit IN VARCHAR2 := fnd_api.g_false
296 ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec
293 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
294 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
295 ,p_instance_id IN NUMBER
297 ,x_return_status OUT NOCOPY VARCHAR2
298 ,x_msg_count OUT NOCOPY NUMBER
299 ,x_msg_data OUT NOCOPY VARCHAR2
300 );
301
302 PROCEDURE get_contact_details
303 (
304 p_api_version IN NUMBER
305 ,p_commit IN VARCHAR2
306 ,p_init_msg_list IN VARCHAR2
307 ,p_validation_level IN NUMBER
308 ,p_contact_party_id IN NUMBER
309 ,p_contact_flag IN VARCHAR2
310 ,p_party_tbl IN VARCHAR2
311 ,x_contact_details OUT NOCOPY csi_datastructures_pub.contact_details_rec
312 ,x_return_status OUT NOCOPY VARCHAR2
313 ,x_msg_count OUT NOCOPY NUMBER
314 ,x_msg_data OUT NOCOPY VARCHAR2
315 );
316
317 Procedure bld_instance_all_parents_tbl
318 (
322 );
319 p_subject_id IN NUMBER,
320 p_relationship_type_code IN VARCHAR2,
321 p_time_stamp IN DATE
323
324
325 FUNCTION get_instance_all_parents
326 (
327 p_subject_id IN NUMBER,
328 p_time_stamp IN DATE
329 ) RETURN VARCHAR2;
330
331
332 FUNCTION get_config_org_id(
333 p_instance_id IN NUMBER,
334 p_last_oe_order_line_id IN NUMBER)
335 RETURN VARCHAR2;
336
337 PROCEDURE delete_search_oks_temp
338 (
339 p_sequence_id IN NUMBER
340 ,x_return_status OUT NOCOPY VARCHAR2
341 ,x_msg_count OUT NOCOPY NUMBER
342 ,x_msg_data OUT NOCOPY VARCHAR2
343 ) ;
344
345 PROCEDURE expire_relationship
346 (
347 p_api_version IN NUMBER
348 ,p_commit IN VARCHAR2
349 ,p_init_msg_list IN VARCHAR2
350 ,p_validation_level IN NUMBER
351 ,p_subject_id IN NUMBER
352 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
353 ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
354 ,x_return_status OUT NOCOPY VARCHAR2
355 ,x_msg_count OUT NOCOPY NUMBER
356 ,x_msg_data OUT NOCOPY VARCHAR2
357 ) ;
358
359 FUNCTION get_instance_ids
360 (
361 P_instance_tbl IN OUT NOCOPY dpl_instance_tbl
362
363 )RETURN VARCHAR2;
364
365
366 END CSI_JAVA_INTERFACE_PKG;
367