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