[Home] [Help]
4388: --Bug Fix 4121175
4389: l_klnv_tbl_in (1).tax_code := p_k_line_rec.tax_code;
4390: --End Bug Fix 4121175
4391: l_klnv_tbl_in (1).coverage_id := p_k_line_rec.coverage_template_id;
4392: l_klnv_tbl_in (1).standard_cov_yn := p_k_line_rec.standard_cov_yn;
4393: l_klnv_tbl_in (1).price_uom := p_k_line_rec.price_uom;
4394:
4395: --Added in R12 by rsu
4396: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
5211: );
5212: RAISE g_exception_halt_validation;
5213: END IF;
5214:
5215: IF p_k_covd_rec.standard_coverage = 'N'
5216: THEN
5217: oks_coverages_pub.update_cov_eff
5218: (p_api_version => 1.0,
5219: p_init_msg_list => 'F',
6066: l_line_rec.order_line_id := p_extwar_rec.srv_order_line_id;
6067: l_line_rec.warranty_flag := p_extwar_rec.warranty_flag;
6068: l_line_rec.currency := p_extwar_rec.srv_currency;
6069: l_line_rec.coverage_template_id := p_extwar_rec.srv_cov_template_id;
6070: l_line_rec.standard_cov_yn := 'Y';
6071: l_line_rec.cust_account := p_extwar_rec.cust_account;
6072: l_line_rec.SOURCE := 'NEW';
6073: l_line_rec.upg_orig_system_ref := 'ORDER'; -- added 04-jun-2002 Vigandhi
6074: l_line_rec.upg_orig_system_ref_id := NULL; -- added 04-jun-2002 Vigandhi
6143: -- added 04-jun-2002 Vigandhi
6144: l_covd_rec.prod_item_id := p_extwar_rec.lvl_inventory_id;
6145: l_covd_rec.tax_amount := p_extwar_rec.tax_amount;
6146: -- added tax calculation from OM. -- Vigandhi
6147: l_covd_rec.standard_coverage := 'Y';
6148:
6149: IF p_extwar_rec.srv_sdt > SYSDATE
6150: THEN
6151: get_sts_code ('SIGNED', NULL, l_ste_code, l_sts_code);
10419: l_line_rec.cust_account := p_kdtl_rec.new_account_id;
10420: l_line_rec.ln_price_list_id := l_price_list_id;
10421: l_line_rec.coverage_id := p_kdtl_rec.coverage_id;
10422: l_line_rec.coverage_template_id := p_kdtl_rec.coverage_id;
10423: l_line_rec.standard_cov_yn := p_kdtl_rec.standard_cov_yn;
10424: l_line_rec.price_uom := p_kdtl_rec.price_uom_tl;
10425:
10426: --l_line_rec.line_renewal_type := p_extwar_rec.line_renewal_type;
10427: IF l_line_rec.warranty_flag = 'W'
10715: l_covd_rec.quantity := p_kdtl_rec.cp_qty;
10716: l_covd_rec.list_price := p_kdtl_rec.service_unit_price;
10717: l_covd_rec.uom_code := p_kdtl_rec.uom_code;
10718: l_covd_rec.negotiated_amount := l_newamt;
10719: l_covd_rec.standard_coverage := p_kdtl_rec.standard_cov_yn;
10720: l_covd_rec.price_uom := p_kdtl_rec.price_uom_sl;
10721: l_covd_rec.toplvl_uom_code := p_kdtl_rec.toplvl_uom_code;
10722: --mchoudha added for bug#5233956
10723: l_covd_rec.toplvl_price_qty := p_kdtl_rec.toplvl_price_qty;
12879: RAISE g_exception_halt_validation;
12880: END IF;
12881:
12882: IF p_kdtl_tbl (l_ctr).coverage_id IS NOT NULL
12883: AND p_kdtl_tbl (l_ctr).standard_cov_yn =
12884: 'N'
12885: THEN
12886: oks_coverages_pub.create_adjusted_coverage
12887: (p_api_version => l_api_version,
12917: END IF;
12918:
12919: UPDATE oks_k_lines_b
12920: SET coverage_id = l_coverage_id,
12921: standard_cov_yn = 'N'
12922: WHERE cle_id = l_line_id;
12923: END IF;
12924:
12925:
13485: RAISE g_exception_halt_validation;
13486: END IF;
13487:
13488: IF p_kdtl_tbl (l_ctr).coverage_id IS NOT NULL
13489: AND p_kdtl_tbl (l_ctr).standard_cov_yn = 'N'
13490: THEN
13491: oks_coverages_pub.create_adjusted_coverage
13492: (p_api_version => l_api_version,
13493: p_init_msg_list => l_init_msg_list,
13521: END IF;
13522:
13523: UPDATE oks_k_lines_b
13524: SET coverage_id = l_coverage_id,
13525: standard_cov_yn = 'N'
13526: WHERE cle_id = l_line_id;
13527: END IF;
13528:
13529: oks_coverages_pvt.create_k_coverage_ext