[Home] [Help]
4282: --Bug Fix 4121175
4283: l_klnv_tbl_in (1).tax_code := p_k_line_rec.tax_code;
4284: --End Bug Fix 4121175
4285: l_klnv_tbl_in (1).coverage_id := p_k_line_rec.coverage_template_id;
4286: l_klnv_tbl_in (1).standard_cov_yn := p_k_line_rec.standard_cov_yn;
4287: l_klnv_tbl_in (1).price_uom := p_k_line_rec.price_uom;
4288:
4289: --Added in R12 by rsu
4290: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
5043: );
5044: RAISE g_exception_halt_validation;
5045: END IF;
5046:
5047: IF p_k_covd_rec.standard_coverage = 'N'
5048: THEN
5049: oks_coverages_pub.update_cov_eff
5050: (p_api_version => 1.0,
5051: p_init_msg_list => 'F',
5898: l_line_rec.order_line_id := p_extwar_rec.srv_order_line_id;
5899: l_line_rec.warranty_flag := p_extwar_rec.warranty_flag;
5900: l_line_rec.currency := p_extwar_rec.srv_currency;
5901: l_line_rec.coverage_template_id := p_extwar_rec.srv_cov_template_id;
5902: l_line_rec.standard_cov_yn := 'Y';
5903: l_line_rec.cust_account := p_extwar_rec.cust_account;
5904: l_line_rec.SOURCE := 'NEW';
5905: l_line_rec.upg_orig_system_ref := 'ORDER'; -- added 04-jun-2002 Vigandhi
5906: l_line_rec.upg_orig_system_ref_id := NULL; -- added 04-jun-2002 Vigandhi
5975: -- added 04-jun-2002 Vigandhi
5976: l_covd_rec.prod_item_id := p_extwar_rec.lvl_inventory_id;
5977: l_covd_rec.tax_amount := p_extwar_rec.tax_amount;
5978: -- added tax calculation from OM. -- Vigandhi
5979: l_covd_rec.standard_coverage := 'Y';
5980:
5981: IF p_extwar_rec.srv_sdt > SYSDATE
5982: THEN
5983: get_sts_code ('SIGNED', NULL, l_ste_code, l_sts_code);
10171: l_line_rec.cust_account := p_kdtl_rec.new_account_id;
10172: l_line_rec.ln_price_list_id := l_price_list_id;
10173: l_line_rec.coverage_id := p_kdtl_rec.coverage_id;
10174: l_line_rec.coverage_template_id := p_kdtl_rec.coverage_id;
10175: l_line_rec.standard_cov_yn := p_kdtl_rec.standard_cov_yn;
10176: l_line_rec.price_uom := p_kdtl_rec.price_uom_tl;
10177:
10178: --l_line_rec.line_renewal_type := p_extwar_rec.line_renewal_type;
10179: IF l_line_rec.warranty_flag = 'W'
10467: l_covd_rec.quantity := p_kdtl_rec.cp_qty;
10468: l_covd_rec.list_price := p_kdtl_rec.service_unit_price;
10469: l_covd_rec.uom_code := p_kdtl_rec.uom_code;
10470: l_covd_rec.negotiated_amount := l_newamt;
10471: l_covd_rec.standard_coverage := p_kdtl_rec.standard_cov_yn;
10472: l_covd_rec.price_uom := p_kdtl_rec.price_uom_sl;
10473: l_covd_rec.toplvl_uom_code := p_kdtl_rec.toplvl_uom_code;
10474: --mchoudha added for bug#5233956
10475: l_covd_rec.toplvl_price_qty := p_kdtl_rec.toplvl_price_qty;
12623: RAISE g_exception_halt_validation;
12624: END IF;
12625:
12626: IF p_kdtl_tbl (l_ctr).coverage_id IS NOT NULL
12627: AND p_kdtl_tbl (l_ctr).standard_cov_yn =
12628: 'N'
12629: THEN
12630: oks_coverages_pub.create_adjusted_coverage
12631: (p_api_version => l_api_version,
12661: END IF;
12662:
12663: UPDATE oks_k_lines_b
12664: SET coverage_id = l_coverage_id,
12665: standard_cov_yn = 'N'
12666: WHERE cle_id = l_line_id;
12667: END IF;
12668:
12669:
13222: RAISE g_exception_halt_validation;
13223: END IF;
13224:
13225: IF p_kdtl_tbl (l_ctr).coverage_id IS NOT NULL
13226: AND p_kdtl_tbl (l_ctr).standard_cov_yn = 'N'
13227: THEN
13228: oks_coverages_pub.create_adjusted_coverage
13229: (p_api_version => l_api_version,
13230: p_init_msg_list => l_init_msg_list,
13258: END IF;
13259:
13260: UPDATE oks_k_lines_b
13261: SET coverage_id = l_coverage_id,
13262: standard_cov_yn = 'N'
13263: WHERE cle_id = l_line_id;
13264: END IF;
13265:
13266: oks_coverages_pvt.create_k_coverage_ext