[Home] [Help]
544: -- Ebtax --
545: tax_classification_code,
546: exempt_certificate_number,
547: exempt_reason_code,
548: standard_cov_yn -- Issue#14 Bug 4566346
549: -- Ebtax --
550: from oks_k_lines_v
551: where cle_id = p_cle_id;
552: l_oks_lines_rec cur_oks_lines%ROWTYPE;
3515: --Fix for bug#3424479
3516: -- FIX DONE FOR USAGE CONTRACT SHOWING INCORRECT MESSAGE WHEN CASCADING DATES.
3517: -- ADDED CHECK FOR USAGE LINE lse_id <> 12
3518: -- GCHADHA 8-JULY-2004
3519: If l_okc_lines_rec.lse_id not in (46, 12) AND nvl(l_oks_lines_rec.standard_cov_yn, 'N') <> 'Y' then
3520:
3521: Open LineCov_cur(l_cle_id);
3522: Fetch LineCov_cur into l_id;
3523: If LineCov_cur%Found Then
3683: -- Bug 5227077 --
3684:
3685: End If;
3686: -- Bug 5191587 --
3687: ELSIf l_okc_lines_rec.lse_id in ('1','14','19') AND nvl(l_oks_lines_rec.standard_cov_yn, 'N') = 'Y' then
3688: If l_sr_number IS NOT NULL then
3689: fnd_msg_pub.initialize;
3690: OKC_API.SET_MESSAGE(
3691: p_app_name => G_APP_NAME_OKS,
4230: object_version_number,
4231: inv_print_flag,
4232: price_uom, -- 8/23/05 hkamdar R12 Partial Period
4233: invoice_text,
4234: standard_cov_yn -- Issue# 14 Bug 4566346
4235: from oks_k_lines_v
4236: where cle_id = p_cle_id;
4237: l_oks_lines_rec cur_oks_lines%ROWTYPE;
4238: l_oks_sub_lines_rec cur_oks_lines%ROWTYPE;
4672: --new
4673:
4674: If l_line_dates is not null then
4675:
4676: IF l_cle_id_old <> l_cle_id AND nvl(l_oks_lines_rec.standard_cov_yn, 'N') <> 'Y' Then
4677: ----errorout_gsi('Line date is not null, calling update_coverage_effectivity');
4678: OPEN cur_line_dates(l_cle_id );
4679: FETCH cur_line_dates INTO line_dates_rec;
4680: CLOSE cur_line_dates;