[Home] [Help]
PACKAGE: APPS.OKS_EXTWARPRGM_PVT
Source
1 PACKAGE oks_extwarprgm_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKSREWRS.pls 120.25.12020000.3 2012/12/26 11:24:08 spingali ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 g_required_value CONSTANT VARCHAR2 (200)
8 := okc_api.g_required_value;
9 g_invalid_value CONSTANT VARCHAR2 (200) := okc_api.g_invalid_value;
10 g_col_name_token CONSTANT VARCHAR2 (200)
11 := okc_api.g_col_name_token;
12 g_parent_table_token CONSTANT VARCHAR2 (200)
13 := okc_api.g_parent_table_token;
14 g_child_table_token CONSTANT VARCHAR2 (200)
15 := okc_api.g_child_table_token;
16 g_unexpected_error CONSTANT VARCHAR2 (200)
17 := 'OKC_CONTRACTS_UNEXP_ERROR';
18 g_sqlerrm_token CONSTANT VARCHAR2 (200) := 'SQLerrm';
19 g_sqlcode_token CONSTANT VARCHAR2 (200) := 'SQLcode';
20 g_uppercase_required CONSTANT VARCHAR2 (200)
21 := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
22 g_app_id CONSTANT NUMBER := 515;
23 ------------------------------------------------------------------------------------
24 -- Constants used for Message Logging
25 g_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
26 g_level_error CONSTANT NUMBER := fnd_log.level_error;
27 g_level_exception CONSTANT NUMBER := fnd_log.level_exception;
28 g_level_event CONSTANT NUMBER := fnd_log.level_event;
29 g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
30 g_level_statement CONSTANT NUMBER := fnd_log.level_statement;
31 g_level_current CONSTANT NUMBER := fnd_log.g_current_runtime_level;
32 g_module_current CONSTANT VARCHAR2 (255)
33 := 'oks.plsql.oks_int_extwar_pvt';
34 ------------------------------------------------------------------------------------
35 -- GLOBAL EXCEPTION
36 ---------------------------------------------------------------------------
37 g_exception_halt_validation EXCEPTION;
38 -- GLOBAL VARIABLES
39 ---------------------------------------------------------------------------
40 g_pkg_name CONSTANT VARCHAR2 (200) := 'OKSOMINT';
41 g_app_name CONSTANT VARCHAR2 (3) := 'OKS';
42 g_jtf_order_hdr CONSTANT VARCHAR2 (200) := 'OKX_ORDERHEAD';
43 g_jtf_order_ln CONSTANT VARCHAR2 (200) := 'OKX_ORDERLINE';
44 g_invoice_contact CONSTANT VARCHAR2 (200) := 'BILLING';
45 g_rule_group_code CONSTANT VARCHAR2 (200) := 'SVC_K';
46 g_jtf_extwarr CONSTANT VARCHAR2 (200) := 'OKX_SERVICE';
47 g_jtf_warr CONSTANT VARCHAR2 (200) := 'OKX_WARRANTY';
48 /*Added for ER 16039680 */
49 g_jtf_subscription CONSTANT VARCHAR2 (200) := 'OKX_SUBSCRIPTION';
50 /*Added for ER 16039680 */
51 g_jtf_party CONSTANT VARCHAR2 (200) := 'OKX_PARTY';
52 g_jtf_party_vendor CONSTANT VARCHAR2 (200) := 'OKX_OPERUNIT';
53 g_jtf_invoice_contact CONSTANT VARCHAR2 (200) := 'OKX_PCONTACT';
54 g_jtf_billto CONSTANT VARCHAR2 (200) := 'OKX_BILLTO';
55 g_jtf_shipto CONSTANT VARCHAR2 (200) := 'OKX_SHIPTO';
56 g_jtf_arl CONSTANT VARCHAR2 (200) := 'OKX_ACCTRULE';
57 g_jtf_ire CONSTANT VARCHAR2 (200) := 'OKX_INVRULE';
58 g_jtf_custprod CONSTANT VARCHAR2 (200) := 'OKX_CUSTPROD';
59 g_jtf_custacct CONSTANT VARCHAR2 (200) := 'OKX_CUSTACCT';
60 g_jtf_price CONSTANT VARCHAR2 (200) := 'OKX_PRICE';
61 g_jtf_payment_term CONSTANT VARCHAR2 (200) := 'OKX_RPAYTERM';
62 g_jtf_conv_type CONSTANT VARCHAR2 (200) := 'OKX_CONVTYPE';
63 g_jtf_taxexemp CONSTANT VARCHAR2 (200) := 'OKX_TAXEXEMP';
64 g_jtf_taxctrl CONSTANT VARCHAR2 (200) := 'OKX_TAXCTRL';
65 g_ptr NUMBER := 1;
66 g_fnd_log_option CONSTANT VARCHAR2 (30)
67 := NVL (fnd_profile.VALUE ('OKS_DEBUG'), 'N');
68 G_CONTEXT_ORDER_HEADER CONSTANT VARCHAR2(30) := 'ORDER_HEADER';
69 G_CONTEXT_ORDER_LINE CONSTANT VARCHAR2(30) := 'ORDER_LINE';
70 G_PAYMENT_CREDIT_CARD CONSTANT VARCHAR2(30) := 'CREDIT_CARD';
71 G_TRF_K_CREATE VARCHAR2(1) := 'N'; --added for bug 12747411
72
73
74 ---------------------------------------------------------------------------
75 TYPE pricing_attributes_type IS RECORD (
76 pricing_context okc_price_att_values.pricing_context%TYPE
77 := okc_api.g_miss_char,
78 pricing_attribute1 okc_price_att_values.pricing_attribute1%TYPE
79 := okc_api.g_miss_char,
80 pricing_attribute2 okc_price_att_values.pricing_attribute2%TYPE
81 := okc_api.g_miss_char,
82 pricing_attribute3 okc_price_att_values.pricing_attribute3%TYPE
83 := okc_api.g_miss_char,
84 pricing_attribute4 okc_price_att_values.pricing_attribute4%TYPE
85 := okc_api.g_miss_char,
86 pricing_attribute5 okc_price_att_values.pricing_attribute5%TYPE
87 := okc_api.g_miss_char,
88 pricing_attribute6 okc_price_att_values.pricing_attribute6%TYPE
89 := okc_api.g_miss_char,
90 pricing_attribute7 okc_price_att_values.pricing_attribute7%TYPE
91 := okc_api.g_miss_char,
92 pricing_attribute8 okc_price_att_values.pricing_attribute8%TYPE
93 := okc_api.g_miss_char,
94 pricing_attribute9 okc_price_att_values.pricing_attribute9%TYPE
95 := okc_api.g_miss_char,
96 pricing_attribute10 okc_price_att_values.pricing_attribute10%TYPE
97 := okc_api.g_miss_char,
98 pricing_attribute11 okc_price_att_values.pricing_attribute11%TYPE
99 := okc_api.g_miss_char,
100 pricing_attribute12 okc_price_att_values.pricing_attribute12%TYPE
101 := okc_api.g_miss_char,
102 pricing_attribute13 okc_price_att_values.pricing_attribute13%TYPE
103 := okc_api.g_miss_char,
104 pricing_attribute14 okc_price_att_values.pricing_attribute14%TYPE
105 := okc_api.g_miss_char,
106 pricing_attribute15 okc_price_att_values.pricing_attribute15%TYPE
107 := okc_api.g_miss_char,
108 pricing_attribute16 okc_price_att_values.pricing_attribute16%TYPE
109 := okc_api.g_miss_char,
110 pricing_attribute17 okc_price_att_values.pricing_attribute17%TYPE
111 := okc_api.g_miss_char,
112 pricing_attribute18 okc_price_att_values.pricing_attribute18%TYPE
113 := okc_api.g_miss_char,
114 pricing_attribute19 okc_price_att_values.pricing_attribute19%TYPE
115 := okc_api.g_miss_char,
116 pricing_attribute20 okc_price_att_values.pricing_attribute20%TYPE
117 := okc_api.g_miss_char,
118 pricing_attribute21 okc_price_att_values.pricing_attribute21%TYPE
119 := okc_api.g_miss_char,
120 pricing_attribute22 okc_price_att_values.pricing_attribute22%TYPE
121 := okc_api.g_miss_char,
122 pricing_attribute23 okc_price_att_values.pricing_attribute23%TYPE
123 := okc_api.g_miss_char,
124 pricing_attribute24 okc_price_att_values.pricing_attribute24%TYPE
125 := okc_api.g_miss_char,
126 pricing_attribute25 okc_price_att_values.pricing_attribute25%TYPE
127 := okc_api.g_miss_char,
128 pricing_attribute26 okc_price_att_values.pricing_attribute26%TYPE
129 := okc_api.g_miss_char,
130 pricing_attribute27 okc_price_att_values.pricing_attribute27%TYPE
131 := okc_api.g_miss_char,
132 pricing_attribute28 okc_price_att_values.pricing_attribute28%TYPE
133 := okc_api.g_miss_char,
134 pricing_attribute29 okc_price_att_values.pricing_attribute29%TYPE
135 := okc_api.g_miss_char,
136 pricing_attribute30 okc_price_att_values.pricing_attribute30%TYPE
137 := okc_api.g_miss_char,
138 pricing_attribute31 okc_price_att_values.pricing_attribute31%TYPE
139 := okc_api.g_miss_char,
140 pricing_attribute32 okc_price_att_values.pricing_attribute32%TYPE
141 := okc_api.g_miss_char,
142 pricing_attribute33 okc_price_att_values.pricing_attribute33%TYPE
143 := okc_api.g_miss_char,
144 pricing_attribute34 okc_price_att_values.pricing_attribute34%TYPE
145 := okc_api.g_miss_char,
146 pricing_attribute35 okc_price_att_values.pricing_attribute35%TYPE
147 := okc_api.g_miss_char,
148 pricing_attribute36 okc_price_att_values.pricing_attribute36%TYPE
149 := okc_api.g_miss_char,
150 pricing_attribute37 okc_price_att_values.pricing_attribute37%TYPE
151 := okc_api.g_miss_char,
152 pricing_attribute38 okc_price_att_values.pricing_attribute38%TYPE
153 := okc_api.g_miss_char,
154 pricing_attribute39 okc_price_att_values.pricing_attribute39%TYPE
155 := okc_api.g_miss_char,
156 pricing_attribute40 okc_price_att_values.pricing_attribute40%TYPE
157 := okc_api.g_miss_char,
158 pricing_attribute41 okc_price_att_values.pricing_attribute41%TYPE
159 := okc_api.g_miss_char,
160 pricing_attribute42 okc_price_att_values.pricing_attribute42%TYPE
161 := okc_api.g_miss_char,
162 pricing_attribute43 okc_price_att_values.pricing_attribute43%TYPE
163 := okc_api.g_miss_char,
164 pricing_attribute44 okc_price_att_values.pricing_attribute44%TYPE
165 := okc_api.g_miss_char,
166 pricing_attribute45 okc_price_att_values.pricing_attribute45%TYPE
167 := okc_api.g_miss_char,
168 pricing_attribute46 okc_price_att_values.pricing_attribute46%TYPE
169 := okc_api.g_miss_char,
170 pricing_attribute47 okc_price_att_values.pricing_attribute47%TYPE
171 := okc_api.g_miss_char,
172 pricing_attribute48 okc_price_att_values.pricing_attribute48%TYPE
173 := okc_api.g_miss_char,
174 pricing_attribute49 okc_price_att_values.pricing_attribute49%TYPE
175 := okc_api.g_miss_char,
176 pricing_attribute50 okc_price_att_values.pricing_attribute50%TYPE
177 := okc_api.g_miss_char,
178 pricing_attribute51 okc_price_att_values.pricing_attribute51%TYPE
179 := okc_api.g_miss_char,
180 pricing_attribute52 okc_price_att_values.pricing_attribute52%TYPE
181 := okc_api.g_miss_char,
182 pricing_attribute53 okc_price_att_values.pricing_attribute53%TYPE
183 := okc_api.g_miss_char,
184 pricing_attribute54 okc_price_att_values.pricing_attribute54%TYPE
185 := okc_api.g_miss_char,
186 pricing_attribute55 okc_price_att_values.pricing_attribute55%TYPE
187 := okc_api.g_miss_char,
188 pricing_attribute56 okc_price_att_values.pricing_attribute56%TYPE
189 := okc_api.g_miss_char,
190 pricing_attribute57 okc_price_att_values.pricing_attribute57%TYPE
191 := okc_api.g_miss_char,
192 pricing_attribute58 okc_price_att_values.pricing_attribute58%TYPE
193 := okc_api.g_miss_char,
194 pricing_attribute59 okc_price_att_values.pricing_attribute59%TYPE
195 := okc_api.g_miss_char,
196 pricing_attribute60 okc_price_att_values.pricing_attribute60%TYPE
197 := okc_api.g_miss_char,
198 pricing_attribute61 okc_price_att_values.pricing_attribute61%TYPE
199 := okc_api.g_miss_char,
200 pricing_attribute62 okc_price_att_values.pricing_attribute62%TYPE
201 := okc_api.g_miss_char,
202 pricing_attribute63 okc_price_att_values.pricing_attribute63%TYPE
203 := okc_api.g_miss_char,
204 pricing_attribute64 okc_price_att_values.pricing_attribute64%TYPE
205 := okc_api.g_miss_char,
206 pricing_attribute65 okc_price_att_values.pricing_attribute65%TYPE
207 := okc_api.g_miss_char,
208 pricing_attribute66 okc_price_att_values.pricing_attribute66%TYPE
209 := okc_api.g_miss_char,
210 pricing_attribute67 okc_price_att_values.pricing_attribute67%TYPE
211 := okc_api.g_miss_char,
212 pricing_attribute68 okc_price_att_values.pricing_attribute68%TYPE
213 := okc_api.g_miss_char,
214 pricing_attribute69 okc_price_att_values.pricing_attribute69%TYPE
215 := okc_api.g_miss_char,
216 pricing_attribute70 okc_price_att_values.pricing_attribute70%TYPE
217 := okc_api.g_miss_char,
218 pricing_attribute71 okc_price_att_values.pricing_attribute71%TYPE
219 := okc_api.g_miss_char,
220 pricing_attribute72 okc_price_att_values.pricing_attribute72%TYPE
221 := okc_api.g_miss_char,
222 pricing_attribute73 okc_price_att_values.pricing_attribute73%TYPE
223 := okc_api.g_miss_char,
224 pricing_attribute74 okc_price_att_values.pricing_attribute74%TYPE
225 := okc_api.g_miss_char,
226 pricing_attribute75 okc_price_att_values.pricing_attribute75%TYPE
227 := okc_api.g_miss_char,
228 pricing_attribute76 okc_price_att_values.pricing_attribute76%TYPE
229 := okc_api.g_miss_char,
230 pricing_attribute77 okc_price_att_values.pricing_attribute77%TYPE
231 := okc_api.g_miss_char,
232 pricing_attribute78 okc_price_att_values.pricing_attribute78%TYPE
233 := okc_api.g_miss_char,
234 pricing_attribute79 okc_price_att_values.pricing_attribute79%TYPE
235 := okc_api.g_miss_char,
236 pricing_attribute80 okc_price_att_values.pricing_attribute80%TYPE
237 := okc_api.g_miss_char,
238 pricing_attribute81 okc_price_att_values.pricing_attribute81%TYPE
239 := okc_api.g_miss_char,
240 pricing_attribute82 okc_price_att_values.pricing_attribute82%TYPE
241 := okc_api.g_miss_char,
242 pricing_attribute83 okc_price_att_values.pricing_attribute83%TYPE
243 := okc_api.g_miss_char,
244 pricing_attribute84 okc_price_att_values.pricing_attribute84%TYPE
245 := okc_api.g_miss_char,
246 pricing_attribute85 okc_price_att_values.pricing_attribute85%TYPE
247 := okc_api.g_miss_char,
248 pricing_attribute86 okc_price_att_values.pricing_attribute86%TYPE
249 := okc_api.g_miss_char,
250 pricing_attribute87 okc_price_att_values.pricing_attribute87%TYPE
251 := okc_api.g_miss_char,
252 pricing_attribute88 okc_price_att_values.pricing_attribute88%TYPE
253 := okc_api.g_miss_char,
254 pricing_attribute89 okc_price_att_values.pricing_attribute89%TYPE
255 := okc_api.g_miss_char,
256 pricing_attribute90 okc_price_att_values.pricing_attribute90%TYPE
257 := okc_api.g_miss_char,
258 pricing_attribute91 okc_price_att_values.pricing_attribute91%TYPE
259 := okc_api.g_miss_char,
260 pricing_attribute92 okc_price_att_values.pricing_attribute92%TYPE
261 := okc_api.g_miss_char,
262 pricing_attribute93 okc_price_att_values.pricing_attribute93%TYPE
263 := okc_api.g_miss_char,
264 pricing_attribute94 okc_price_att_values.pricing_attribute94%TYPE
265 := okc_api.g_miss_char,
266 pricing_attribute95 okc_price_att_values.pricing_attribute95%TYPE
267 := okc_api.g_miss_char,
268 pricing_attribute96 okc_price_att_values.pricing_attribute96%TYPE
269 := okc_api.g_miss_char,
270 pricing_attribute97 okc_price_att_values.pricing_attribute97%TYPE
271 := okc_api.g_miss_char,
272 pricing_attribute98 okc_price_att_values.pricing_attribute98%TYPE
273 := okc_api.g_miss_char,
274 pricing_attribute99 okc_price_att_values.pricing_attribute99%TYPE
275 := okc_api.g_miss_char,
276 pricing_attribute100 okc_price_att_values.pricing_attribute100%TYPE
277 := okc_api.g_miss_char
278 );
279
280 TYPE partyrole_type IS RECORD (
281 party_role VARCHAR2 (30),
282 object1_id1 NUMBER,
283 object1_code VARCHAR2 (30)
284 );
285
286 TYPE partyrole_tbl IS TABLE OF partyrole_type
287 INDEX BY BINARY_INTEGER;
288
289 TYPE contact_type IS RECORD (
290 party_role VARCHAR2 (30),
291 contact_role VARCHAR2 (30),
292 contact_object_code VARCHAR2 (30),
293 contact_id NUMBER,
294 flag VARCHAR2 (1)
295 );
296
297 TYPE contact_tbl IS TABLE OF contact_type
298 INDEX BY BINARY_INTEGER;
299
300 TYPE salescredit_type IS RECORD (
301 ctc_id NUMBER,
302 sales_credit_type_id NUMBER,
303 PERCENT NUMBER,
304 sales_group_id NUMBER
305 );
306
307 TYPE salescredit_tbl IS TABLE OF salescredit_type
308 INDEX BY BINARY_INTEGER;
309
310 TYPE k_header_rec_type IS RECORD (
311 contract_number VARCHAR2 (120),
312 rty_code VARCHAR2 (30),
313 start_date DATE,
314 end_date DATE,
315 sts_code VARCHAR2 (30),
316 scs_code VARCHAR2 (30),
317 class_code VARCHAR2 (30),
318 authoring_org_id NUMBER,
319 short_description VARCHAR2 (1995),
320 chr_group NUMBER,
321 pdf_id NUMBER,
322 party_id NUMBER,
323 bill_to_id NUMBER,
324 ship_to_id NUMBER,
325 contact_id NUMBER,
326 price_list_id NUMBER,
327 cust_po_number VARCHAR2 (240),
328 agreement_id NUMBER,
329 currency VARCHAR2 (15),
330 accounting_rule_id NUMBER,
331 invoice_rule_id NUMBER,
332 order_hdr_id NUMBER,
333 payment_term_id NUMBER,
334 cvn_type VARCHAR2 (25),
335 cvn_rate NUMBER,
336 cvn_date DATE,
337 cvn_euro_rate NUMBER,
338 billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE,
339 tax_exemption_id NUMBER,
340 tax_status_flag VARCHAR2 (30),
341 third_party_role VARCHAR2 (30),
342 merge_type VARCHAR2 (10),
343 merge_object_id NUMBER,
344 renewal_type VARCHAR2 (3) --'NSR/SFA/DNR/EVN'
345 ,
346 renewal_pricing_type VARCHAR2 (3) --'LST/PCT/MAN'
347 ,
348 renewal_price_list_id NUMBER,
349 renewal_markup NUMBER,
350 renewal_po VARCHAR2 (1) --'Y/N'
351 ,
352 qto_contact_id NUMBER,
353 qto_email_id NUMBER,
354 qto_phone_id NUMBER,
355 qto_fax_id NUMBER,
356 qto_site_id NUMBER,
357 order_line_id NUMBER,
358 billing_profile_id NUMBER,
359 qcl_id NUMBER,
360 grace_period VARCHAR2 (250),
361 inv_organization_id NUMBER,
362 grace_duration NUMBER,
363 salesrep_id NUMBER,
364 ar_interface_yn VARCHAR2 (1),
365 summary_trx_yn VARCHAR2 (1),
366 hold_billing VARCHAR2 (1),
367 inv_trx_type VARCHAR2 (40),
368 payment_type VARCHAR2 (30),
369 ccr_number VARCHAR2 (80),
370 ccr_exp_date DATE,
371 period_start VARCHAR2 (30),
372 period_type VARCHAR2 (10),
373 price_uom VARCHAR2 (30),
374 attribute1 VARCHAR2 (450),
375 attribute2 VARCHAR2 (450),
376 attribute3 VARCHAR2 (450),
377 attribute4 VARCHAR2 (450),
378 attribute5 VARCHAR2 (450),
379 attribute6 VARCHAR2 (450),
380 attribute7 VARCHAR2 (450),
381 attribute8 VARCHAR2 (450),
382 attribute9 VARCHAR2 (450),
383 attribute10 VARCHAR2 (450),
384 attribute11 VARCHAR2 (450),
385 attribute12 VARCHAR2 (450),
386 attribute13 VARCHAR2 (450),
387 attribute14 VARCHAR2 (450),
388 attribute15 VARCHAR2 (450),
389 renewal_status VARCHAR2 (30)
390 -- Added by JVARGHES for 12.0 enhancements.
391 -- Added by rsu for R12
392 ,
393 tax_classification_code VARCHAR2 (50), /* nechatur 13-07-06 bug#5380870 Increased the tax_classification_code length from 30 to 50 */
394 exemption_certificate_number VARCHAR2 (80),
395 exemption_reason_code VARCHAR2 (30),
396 -- Added by rsu for R12
397 RENEWAL_APPROVAL_FLAG VARCHAR2(30) --Bug# 5173373
398 );
399
400 TYPE k_line_service_rec_type IS RECORD (
401 k_id NUMBER,
402 k_line_number VARCHAR2 (150),
403 line_sts_code VARCHAR2 (30),
404 cust_account NUMBER,
405 org_id NUMBER,
406 srv_id NUMBER,
407 object_name VARCHAR2 (440),
408 srv_segment1 VARCHAR2 (440),
409 srv_desc VARCHAR2 (440),
410 srv_sdt DATE,
411 srv_edt DATE,
412 bill_to_id NUMBER,
413 ship_to_id NUMBER,
414 order_line_id NUMBER,
415 accounting_rule_id NUMBER,
416 invoicing_rule_id NUMBER,
417 warranty_flag VARCHAR2 (2),
418 coverage_template_id NUMBER,
419 currency VARCHAR2 (15),
420 SOURCE VARCHAR2 (30),
421 reason_code VARCHAR2 (30),
422 reason_comments VARCHAR2 (1995),
423 line_renewal_type VARCHAR2 (3) -- 'FUL/KEP/DNR'
424 ,
425 upg_orig_system_ref VARCHAR2 (60),
426 upg_orig_system_ref_id NUMBER,
427 commitment_id NUMBER,
428 tax_code NUMBER,
429 ln_price_list_id NUMBER,
430 coverage_id NUMBER,
431 standard_cov_yn VARCHAR2 (1),
432 price_uom VARCHAR2 (30),
433 attribute1 VARCHAR2 (450),
434 attribute2 VARCHAR2 (450),
435 attribute3 VARCHAR2 (450),
436 attribute4 VARCHAR2 (450),
437 attribute5 VARCHAR2 (450),
438 attribute6 VARCHAR2 (450),
439 attribute7 VARCHAR2 (450),
440 attribute8 VARCHAR2 (450),
441 attribute9 VARCHAR2 (450),
442 attribute10 VARCHAR2 (450),
443 attribute11 VARCHAR2 (450),
444 attribute12 VARCHAR2 (450),
445 attribute13 VARCHAR2 (450),
446 attribute14 VARCHAR2 (450),
447 attribute15 VARCHAR2 (450)
448 --added by rsu for r12
449 ,
450 tax_classification_code VARCHAR2 (50), /* nechatur 13-07-06 bug#5380870 Increased the tax_classification_code length from 30 to 50 */
451 exemption_certificate_number VARCHAR2 (80),
452 exemption_reason_code VARCHAR2 (30),
453 tax_status oks_k_lines_b.tax_status%TYPE
454 --added by rsu for r12
455 );
456
457 TYPE k_line_covered_level_rec_type IS RECORD (
458 k_id NUMBER,
459 rty_code VARCHAR2 (30),
460 attach_2_line_id NUMBER,
461 attach_2_line_desc VARCHAR2 (450),
462 line_number VARCHAR2 (150),
463 product_sts_code VARCHAR2 (30),
464 customer_product_id NUMBER,
465 product_item_id NUMBER,
466 product_segment1 VARCHAR2 (440),
467 product_desc VARCHAR2 (440),
468 product_start_date DATE,
469 product_end_date DATE,
470 quantity NUMBER,
471 uom_code VARCHAR2 (3),
472 list_price NUMBER,
473 negotiated_amount NUMBER,
474 currency_code VARCHAR2 (15),
475 warranty_flag VARCHAR2 (2),
476 reason_code VARCHAR2 (30),
477 reason_comments VARCHAR2 (1995),
478 line_renewal_type VARCHAR2 (3) -- 'FUL/KEP/DNR'
479 ,
480 order_line_id NUMBER,
481 translated_text VARCHAR2 (1995),
482 upg_orig_system_ref VARCHAR2 (60),
483 upg_orig_system_ref_id NUMBER,
484 prod_item_id NUMBER,
485 tax_amount NUMBER,
486 standard_coverage VARCHAR2 (1),
487 price_uom VARCHAR2 (30),
488 toplvl_uom_code VARCHAR2 (3),
489 --mchoudha added for bug#5233956
490 toplvl_price_qty Number,
491 attribute1 VARCHAR2 (450),
492 attribute2 VARCHAR2 (450),
493 attribute3 VARCHAR2 (450),
494 attribute4 VARCHAR2 (450),
495 attribute5 VARCHAR2 (450),
496 attribute6 VARCHAR2 (450),
497 attribute7 VARCHAR2 (450),
498 attribute8 VARCHAR2 (450),
499 attribute9 VARCHAR2 (450),
500 attribute10 VARCHAR2 (450),
501 attribute11 VARCHAR2 (450),
502 attribute12 VARCHAR2 (450),
503 attribute13 VARCHAR2 (450),
504 attribute14 VARCHAR2 (450),
505 attribute15 VARCHAR2 (450)
506 );
507
508 TYPE extwar_rec_type IS RECORD (
509 warranty_flag VARCHAR2 (30),
510 rty_code VARCHAR2 (30),
511 merge_type VARCHAR2 (10),
512 merge_object_id NUMBER,
513 hdr_sdt DATE,
514 hdr_edt DATE,
515 hdr_org_id NUMBER,
516 hdr_party_id NUMBER,
517 hdr_third_party_role VARCHAR2 (30),
518 hdr_bill_2_id NUMBER,
519 hdr_ship_2_id NUMBER,
520 hdr_price_list_id NUMBER,
521 hdr_cust_po_number VARCHAR2 (240),
522 hdr_agreement_id NUMBER,
523 hdr_currency VARCHAR2 (15),
524 hdr_acct_rule_id NUMBER,
525 hdr_inv_rule_id NUMBER,
526 hdr_order_hdr_id NUMBER,
527 hdr_status VARCHAR2 (30),
528 hdr_payment_term_id NUMBER,
529 hdr_cvn_type VARCHAR2 (25),
530 hdr_cvn_rate NUMBER,
531 hdr_cvn_date DATE,
532 hdr_cvn_euro_rate NUMBER,
533 hdr_chr_group NUMBER,
534 hdr_pdf_id NUMBER,
535 hdr_tax_exemption_id NUMBER,
536 hdr_tax_status_flag VARCHAR2 (30),
537 hdr_renewal_type VARCHAR2 (3),
538 hdr_renewal_pricing_type VARCHAR2 (3),
539 hdr_renewal_price_list_id NUMBER,
540 hdr_renewal_markup NUMBER,
541 hdr_renewal_po VARCHAR2 (1),
542 hdr_contact_id NUMBER,
543 hdr_qcl_id NUMBER,
544 cust_account NUMBER,
545 srv_id NUMBER,
546 srv_name VARCHAR2 (440),
547 srv_desc VARCHAR2 (440),
548 srv_sdt DATE,
549 srv_edt DATE,
550 srv_bill_2_id NUMBER,
551 srv_ship_2_id NUMBER,
552 srv_order_line_id NUMBER,
553 srv_amount NUMBER,
554 srv_unit_price NUMBER,
555 srv_price_percent NUMBER,
556 srv_currency VARCHAR2 (15),
557 srv_cov_template_id NUMBER,
558 lvl_cp_id NUMBER,
559 lvl_inventory_id NUMBER,
560 lvl_inventory_name VARCHAR2 (440),
561 lvl_inventory_desc VARCHAR2 (440),
562 lvl_quantity NUMBER,
563 lvl_uom_code VARCHAR2 (3),
564 lvl_order_line_id NUMBER,
565 lvl_sts_code VARCHAR2 (40),
566 lvl_line_renewal_type VARCHAR2 (3),
567 line_invoicing_rule_id NUMBER,
568 line_accounting_rule_id NUMBER,
569 qto_contact_id NUMBER,
570 qto_email_id NUMBER,
571 qto_phone_id NUMBER,
572 qto_fax_id NUMBER,
573 qto_site_id NUMBER,
574 billing_profile_id NUMBER
575 --, Translated_text Varchar2(1995);
576 ,
577 line_renewal_type VARCHAR2 (3),
578 grace_period VARCHAR2 (250),
579 grace_duration NUMBER,
580 hdr_scs_code VARCHAR2 (30),
581 salesrep_id NUMBER,
582 commitment_id NUMBER,
583 ccr_number VARCHAR2 (80),
584 ccr_exp_date DATE,
585 tax_amount NUMBER,
586 ln_price_list_id NUMBER
587 --added by rsu for r12
588 ,
589 tax_classification_code VARCHAR2 (50), /* nechatur 13-07-06 bug#5380870 Increased the tax_classification_code length from 30 to 50 */
590 exemption_certificate_number VARCHAR2 (80),
591 exemption_reason_code VARCHAR2 (30)
592 --added by rsu for r12
593 ,
594 renewal_status VARCHAR2 (30)
595
596 -- added Vigandhi : for warranty contract negotiation status
597 );
598
599 TYPE contract_trf_rec IS RECORD (
600 hdr_id NUMBER,
601 hdr_org_id NUMBER,
602 hdr_sdt DATE,
603 hdr_edt DATE,
604 hdr_sts VARCHAR2 (30),
605 contract_number VARCHAR2 (40),
606 scs_code VARCHAR2 (40),
607 service_line_id NUMBER,
608 service_line_number VARCHAR2 (150),
609 service_inventory_id VARCHAR2 (240),
610 object_line_id NUMBER,
611 --Service_name VARCHAR2(240),
612 --Service_Description VARCHAR2(240),
613 service_sdt DATE,
614 service_edt DATE,
615 service_bill_2_id NUMBER,
616 service_ship_2_id NUMBER,
617 --Service_order_line_id NUMBER,
618 service_amount NUMBER,
619 service_tax_amount NUMBER,
620 tax_code NUMBER,
621 service_unit_price NUMBER,
622 service_currency VARCHAR2 (15),
623 --Service_Cov_id NUMBER,
624 -- K_Item_Id NUMBER,
625 cp_qty NUMBER,
626 --warranty_flag VARCHAR2(2),
627 cust_account NUMBER,
628 invoice_rule_id NUMBER,
629 accounting_rule_id NUMBER,
630 price_list_id NUMBER,
631 payment_term_id NUMBER,
632 hdr_acct_rule_id NUMBER,
633 hdr_inv_rule_id NUMBER,
634 ar_interface_yn VARCHAR2 (1),
635 summary_trx_yn VARCHAR2 (1),
636 hold_billing VARCHAR2 (1),
637 inv_trx_type VARCHAR2 (40),
638 payment_type VARCHAR2 (30),
639 organization_id NUMBER,
640 cvn_type VARCHAR2 (30),
641 cvn_rate NUMBER,
642 cvn_date DATE,
643 cvn_euro_rate NUMBER,
644 billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE,
645 --resource_id Number,
646 -- group_id Number,
647 --access_level Varchar2(3),
648 cle_id_renewed NUMBER,
649 sts_code VARCHAR2 (30),
650 prod_sts_code VARCHAR2 (30),
651 prod_sdt DATE,
652 prod_edt DATE,
653 prod_term_date DATE,
654 lse_id NUMBER,
655 prod_name VARCHAR2 (240),
656 prod_description VARCHAR2 (240),
657 prod_line_renewal_type VARCHAR2 (30),
658 --start_delay Number,
659 upg_orig_system_ref VARCHAR2 (60),
660 upg_orig_system_ref_id NUMBER,
661 cust_po_number VARCHAR2 (150), --07-May-2003
662 header_currency VARCHAR2 (15), --07-May-2003
663 --ord_hdr_id Varchar2(40), --07-May-2003
664 party_id NUMBER,
665 instance_id NUMBER,
666 prod_inventory_item NUMBER,
667 transfer_date DATE,
668 transaction_date DATE,
669 old_account_id NUMBER,
670 new_account_id NUMBER,
671 system_id NUMBER,
672 old_cp_id NUMBER,
673 coverage_id NUMBER,
674 standard_cov_yn VARCHAR2 (1),
675 period_start VARCHAR2 (30),
676 period_type VARCHAR2 (10),
677 uom_code VARCHAR2 (3),
678 price_uom_sl VARCHAR2 (30), -- Added to cpoy price_uom
679 price_uom_tl VARCHAR2 (30), -- Added to cpoy price_uom
680 price_uom_hdr VARCHAR2 (30), -- Added to cpoy price_uom
681 toplvl_uom_code VARCHAR2 (3),
682 --mchoudha added for bug#5233956
683 toplvl_price_qty Number
684 );
685
686 TYPE contract_rec IS RECORD (
687 old_cp_id NUMBER,
688 termination_date DATE,
689 installation_date DATE,
690 transaction_date DATE,
691 old_customer_acct_id NUMBER,
692 new_customer_acct_id NUMBER,
693 system_id NUMBER,
694 current_cp_quantity NUMBER,
695 new_quantity NUMBER,
696 new_customer_product_id NUMBER,
697 object_line_id NUMBER,
698 hdr_id NUMBER,
699 hdr_sdt DATE,
700 hdr_edt DATE,
701 hdr_sts VARCHAR2 (30),
702 service_line_id NUMBER,
703 service_amount NUMBER,
704 prod_sdt DATE,
705 prod_edt DATE,
706 prod_sts_code VARCHAR2 (30),
707 cust_account NUMBER,
708 service_sdt DATE,
709 service_edt DATE,
710 sts_code VARCHAR2 (30),
711 contract_number VARCHAR2 (40),
712 old_cp_quantity NUMBER,
713 price_negotiated NUMBER,
714 term_date DATE,
715 prod_inventory_item NUMBER,
716 hdr_org_id NUMBER,
717 organization_id NUMBER,
718 lse_id NUMBER,
719 scs_code VARCHAR2 (40),
720 new_cp_id NUMBER,
721 service_inventory_id VARCHAR2 (240),
722 service_currency VARCHAR2 (15),
723 uom_code VARCHAR2 (30),
724 prod_line_renewal_type VARCHAR2 (30),
725 raise_credit VARCHAR2 (50),
726 party_id NUMBER,
727 service_tax_amount NUMBER,
728 service_unit_price NUMBER,
729 prod_name VARCHAR2 (240),
730 prod_description VARCHAR2 (240),
731 --start_delay Number,
732 upg_orig_system_ref VARCHAR2 (60),
733 upg_orig_system_ref_id NUMBER,
734 new_inventory_item NUMBER,
735 return_reason_code VARCHAR2 (30),
736 order_line_id NUMBER,
737 price_uom_code VARCHAR2 (30), -- Added to cpoy price_uom
738 toplvl_uom_code VARCHAR2 (3),
739 --mchoudha added for bug#5233956
740 toplvl_price_qty Number
741 );
742
743 TYPE contract_trf_tbl IS TABLE OF contract_trf_rec
744 INDEX BY BINARY_INTEGER;
745
746 TYPE contract_tbl IS TABLE OF contract_rec
747 INDEX BY BINARY_INTEGER;
748
749 PROCEDURE update_cov_level (
750 p_covered_line_id IN NUMBER,
751 p_new_end_date IN DATE,
752 p_k_item_id IN NUMBER,
753 p_new_negotiated_amt IN NUMBER,
754 p_new_cp_qty IN NUMBER,
755 p_list_price IN NUMBER,
756 x_return_status OUT NOCOPY VARCHAR2,
757 x_msg_count OUT NOCOPY NUMBER,
758 x_msg_data OUT NOCOPY VARCHAR2
759 );
760
761 PROCEDURE create_k_hdr (
762 p_k_header_rec IN k_header_rec_type,
763 p_contact_tbl IN contact_tbl,
764 p_salescredit_tbl_in IN salescredit_tbl
765 --mmadhavi bug 4174921
766 ,
767 p_caller IN VARCHAR2,
768 x_order_error OUT NOCOPY VARCHAR2,
769 x_chr_id OUT NOCOPY NUMBER,
770 x_return_status OUT NOCOPY VARCHAR2,
771 x_msg_count OUT NOCOPY NUMBER,
772 x_msg_data OUT NOCOPY VARCHAR2
773 );
774
775 PROCEDURE create_k_service_lines (
776 p_k_line_rec IN k_line_service_rec_type,
777 p_contact_tbl IN contact_tbl,
778 p_salescredit_tbl_in IN salescredit_tbl,
779 p_caller IN VARCHAR2,
780 x_order_error OUT NOCOPY VARCHAR2,
781 x_service_line_id OUT NOCOPY NUMBER,
782 x_return_status OUT NOCOPY VARCHAR2,
783 x_msg_count OUT NOCOPY NUMBER,
784 x_msg_data OUT NOCOPY VARCHAR2
785 );
786
787 PROCEDURE create_k_covered_levels (
788 p_k_covd_rec IN k_line_covered_level_rec_type,
789 p_price_attribs IN pricing_attributes_type,
790 p_caller IN VARCHAR2,
791 x_order_error OUT NOCOPY VARCHAR2,
792 x_covlvl_id OUT NOCOPY NUMBER,
793 x_update_line OUT NOCOPY VARCHAR2,
794 x_return_status OUT NOCOPY VARCHAR2,
795 x_msg_count OUT NOCOPY NUMBER,
796 x_msg_data OUT NOCOPY VARCHAR2
797 );
798
799 PROCEDURE create_contract_ibnew (
800 p_extwar_rec IN extwar_rec_type,
801 p_contact_tbl_in IN oks_extwarprgm_pvt.contact_tbl,
802 p_salescredit_tbl_hdr_in IN oks_extwarprgm_pvt.salescredit_tbl
803 --mmadhavi bug 4174921
804 ,
805 p_salescredit_tbl_line_in IN oks_extwarprgm_pvt.salescredit_tbl,
806 p_price_attribs_in IN oks_extwarprgm_pvt.pricing_attributes_type,
807 x_inst_dtls_tbl IN OUT NOCOPY oks_ihd_pvt.ihdv_tbl_type,
808 x_chrid OUT NOCOPY NUMBER,
809 x_return_status OUT NOCOPY VARCHAR2,
810 x_msg_count OUT NOCOPY NUMBER,
811 x_msg_data OUT NOCOPY VARCHAR2
812 );
813
814 PROCEDURE create_contract_ibsplit (
815 p_kdtl_tbl IN contract_tbl,
816 x_return_status OUT NOCOPY VARCHAR2,
817 x_msg_count OUT NOCOPY NUMBER,
818 x_msg_data OUT NOCOPY VARCHAR2
819 );
820
821 PROCEDURE update_contract_ibreplace (
822 p_kdtl_tbl IN contract_tbl,
823 x_return_status OUT NOCOPY VARCHAR2,
824 x_msg_count OUT NOCOPY NUMBER,
825 x_msg_data OUT NOCOPY VARCHAR2
826 );
827
828 PROCEDURE create_contract_ibreturn (
829 p_kdtl_tbl IN contract_tbl,
830 x_return_status OUT NOCOPY VARCHAR2,
831 x_msg_count OUT NOCOPY NUMBER,
832 x_msg_data OUT NOCOPY VARCHAR2
833 );
834
835 PROCEDURE create_k_system_transfer (
836 p_kdtl_tbl IN contract_trf_tbl,
837 x_return_status OUT NOCOPY VARCHAR2,
838 x_msg_count OUT NOCOPY NUMBER,
839 x_msg_data OUT NOCOPY VARCHAR2
840 );
841
842 PROCEDURE create_contract_terminate (
843 p_kdtl_tbl IN contract_tbl,
844 x_return_status OUT NOCOPY VARCHAR2,
845 x_msg_count OUT NOCOPY NUMBER,
846 x_msg_data OUT NOCOPY VARCHAR2
847 );
848
849 PROCEDURE update_contract_idc (
850 p_kdtl_tbl IN contract_tbl,
851 x_return_status OUT NOCOPY VARCHAR2,
852 x_msg_count OUT NOCOPY NUMBER,
853 x_msg_data OUT NOCOPY VARCHAR2
854 );
855
856 PROCEDURE create_contract_ibupdate (
857 p_kdtl_tbl IN contract_tbl,
858 x_return_status OUT NOCOPY VARCHAR2,
859 x_msg_count OUT NOCOPY NUMBER,
860 x_msg_data OUT NOCOPY VARCHAR2
861 );
862
863 PROCEDURE get_sts_code (
864 p_ste_code IN VARCHAR2,
865 p_sts_code IN VARCHAR2,
866 x_ste_code OUT NOCOPY VARCHAR2,
867 x_sts_code OUT NOCOPY VARCHAR2
868 );
869
870 PROCEDURE send_notification (
871 p_order_id IN NUMBER,
872 p_contract_id NUMBER,
873 p_type IN VARCHAR2
874 );
875
876 PROCEDURE get_jtf_resource (
877 p_authorg_id NUMBER,
878 p_party_id NUMBER,
879 x_winners_rec OUT NOCOPY jtf_terr_assign_pub.bulk_winners_rec_type,
880 x_msg_count OUT NOCOPY NUMBER,
881 x_msg_data OUT NOCOPY VARCHAR2,
882 x_return_status OUT NOCOPY VARCHAR2
883 );
884
885 -----------------------------------------------------------------------
886 -- Procedure: get_cc_trxn_extn
887 -- Added 03/03/2006 by Vijay Ramalingam
888 -----------------------------------------------------------------------
889 -- The get_cc_trxn_extn procedure is used to get a transaction extension
890 -- id from iPayments, based on an existing transaction extension id from
891 -- a sales order header or an order line from OM.
892 -- This API is called while creating an Extended warranty contract
893 -- from OM. It is called at the header level for a sales order header
894 -- or at line level for a sales order line.
895 -- p_context_level identifies the level at which it is called and the
896 -- applicable values are 'ORDER_HEADER' and 'ORDER_LINE'
897
898 PROCEDURE get_cc_trxn_extn (
899 p_order_header_id IN NUMBER,
900 p_order_line_id IN NUMBER,
901 p_context_level IN VARCHAR2,
902 p_contract_hdr_id IN NUMBER,
903 p_contract_line_id IN NUMBER,
904 x_entity_id OUT NOCOPY NUMBER,
905 x_return_status OUT NOCOPY VARCHAR2
906 ) ;
907
908 END oks_extwarprgm_pvt;