[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;
3550: --Fix for bug#3424479
3551: -- FIX DONE FOR USAGE CONTRACT SHOWING INCORRECT MESSAGE WHEN CASCADING DATES.
3552: -- ADDED CHECK FOR USAGE LINE lse_id <> 12
3553: -- GCHADHA 8-JULY-2004
3554: If l_okc_lines_rec.lse_id not in (46, 12) AND nvl(l_oks_lines_rec.standard_cov_yn, 'N') <> 'Y' then
3555:
3556: Open LineCov_cur(l_cle_id);
3557: Fetch LineCov_cur into l_id;
3558: If LineCov_cur%Found Then
3718: -- Bug 5227077 --
3719:
3720: End If;
3721: -- Bug 5191587 --
3722: ELSIf l_okc_lines_rec.lse_id in ('1','14','19') AND nvl(l_oks_lines_rec.standard_cov_yn, 'N') = 'Y' then
3723:
3724: /*added for bug 10132468*/
3725:
3726: OKS_PM_PROGRAMS_PVT.ADJUST_PM_PROGRAM_SCHEDULE
4302: object_version_number,
4303: inv_print_flag,
4304: price_uom, -- 8/23/05 hkamdar R12 Partial Period
4305: invoice_text,
4306: standard_cov_yn -- Issue# 14 Bug 4566346
4307: from oks_k_lines_v
4308: where cle_id = p_cle_id;
4309: l_oks_lines_rec cur_oks_lines%ROWTYPE;
4310: l_oks_sub_lines_rec cur_oks_lines%ROWTYPE;
4771: --new
4772:
4773: If l_line_dates is not null then
4774:
4775: IF l_cle_id_old <> l_cle_id AND nvl(l_oks_lines_rec.standard_cov_yn, 'N') <> 'Y' Then
4776: ----errorout_gsi('Line date is not null, calling update_coverage_effectivity');
4777: OPEN cur_line_dates(l_cle_id );
4778: FETCH cur_line_dates INTO line_dates_rec;
4779: CLOSE cur_line_dates;
5500: |
5501: | Purpose: Insert cascade attributes data into OKC_CASCADE_CONC_REQ
5502: |
5503: | In Parameters: header_lines_tbl Cascade header attributes
5504: | Out Parameters: x_return_status standard return status
5505: |
5506: +============================================================================*/
5507:
5508: PROCEDURE ADD_CONCURRENT(header_lines_tbl IN OKS_ATTR_DEFAULTS_PVT.header_lines_tbl_type,
5574: | Procedure: Add_Concurrent_SUB |
5575: | Purpose: Insert cascade attributes data into OKC_CASCADE_CONC_REQ_SUB
5576: |
5577: | In Parameters: l_line_table Cascade lines attributes
5578: | Out Parameters: x_return_status standard return status
5579: |
5580: +============================================================================*/
5581:
5582: PROCEDURE ADD_CONCURRENT_SUB(lines_sublines_tbl IN OKS_ATTR_DEFAULTS_PVT.lines_sublines_tbl_type,
5644: |
5645: | Purpose: Invoke cascade api to cascade the attributes from header to lines
5646: |
5647: | In Parameters: p_chr_id the contract id
5648: | Out Parameters: x_return_status standard return status
5649: |
5650: +============================================================================*/
5651:
5652: PROCEDURE Cascade_concurrent(errbuf OUT NOCOPY VARCHAR2