[Home] [Help]
522: END IF;
523:
524: -- If l_line_type is set as either 'NEW' or 'RELEASE' call
525: -- l_line_rents_nr_csr cursor in order to consider either only new
526: -- assets or only re-leased assets, else no change in the standard behavior
527:
528: IF l_line_type IN ('NEW','RELEASE') then
529: l_line_rents_amount := 0;
530:
957: END IF;
958:
959: -- If l_line_type is set as either 'NEW' or 'RELEASE' call
960: -- lines_nr_csr cursor in order to consider either only new
961: -- assets or only re-leased assets, else no change in the standard behavior
962:
963: IF l_line_type IN ('NEW','RELEASE') THEN
964:
965: FOR line_nr_rec IN lines_nr_csr( p_chr_id, l_line_type )
1418: Else
1419: --Bug# 15992711 , Start
1420: -- If l_line_type is set as either 'NEW' or 'RELEASE' call
1421: -- get_unearn_rev_nr_csr cursor in order to consider either only new
1422: -- assets or only re-leased assets, else no change in the standard behavior
1423:
1424: IF l_line_type IN ('NEW','RELEASE') THEN
1425:
1426: IF l_capred_incl_terminated = TRUE THEN
1668:
1669: --Bug# 15992711 , Start
1670: -- If l_line_type is set as either 'NEW' or 'RELEASE'
1671: -- based on the value of l_line_type query will consider either only new
1672: -- assets or only re-leased assets, else no change in the standard behavior
1673:
1674: IF l_line_type IN ('NEW','RELEASE') THEN
1675:
1676: IF l_discount_incl_terminated THEN
2516:
2517: --Bug# 15992711 , Start
2518: -- If l_line_type is set as either 'NEW' or 'RELEASE' call
2519: -- l_lines_nr_csr or l_lines_nr_csr_incl_term cursor based on l_discount_incl_terminated value
2520: -- in order to consider either only new assets or only re-leased assets, else no change in the standard behavior
2521:
2522: IF l_line_type IN ('NEW','RELEASE') THEN
2523: IF l_discount_incl_terminated THEN
2524:
4301:
4302: --Bug# 15992711 , Start
4303: -- If l_line_type is set as either 'NEW' or 'RELEASE' call
4304: -- get_unearn_rev_nr_csr cursor in order to consider either only new
4305: -- assets or only re-leased assets, else no change in the standard behavior
4306:
4307: IF l_line_type IN ('NEW','RELEASE') THEN
4308:
4309: OPEN get_unearn_rev_nr_csr (p_khr_id, l_provision_date, l_rent_sty_id, l_lease_inc_sty_id, l_line_type);
7965: END IF;
7966:
7967: -- If l_line_type is set as either 'NEW' or 'RELEASE' call
7968: -- capz_nr_csr cursor in order to consider either only new
7969: -- assets or only re-leased assets, else no change in the standard behavior
7970:
7971: IF l_line_type IN ('NEW','RELEASE') THEN
7972: OPEN capz_nr_csr( p_chr_id, l_line_type );
7973: FETCH capz_nr_csr INTO l_capz_int;
9313:
9314: --Bug# 15992711 , Start
9315: -- If l_line_type is set as either 'NEW' or 'RELEASE' call
9316: -- l_cleb_nr_csr cursor in order to consider either only new
9317: -- assets or only re-leased assets, else no change in the standard behavior
9318: IF l_line_type IN ('NEW','RELEASE') THEN
9319: IF (l_discount_incl_terminated) THEN
9320: OPEN l_cleb_nr_termn_csr(p_chr_id => p_chr_id, p_line_type => l_line_type);
9321: LOOP
9362:
9363: CLOSE l_cleb_nr_csr;
9364:
9365: END IF;
9366: --IF (l_discount_incl_terminated) THEN -- Commented standard code
9367: ELSIF (l_discount_incl_terminated) THEN
9368:
9369: --Bug# 15992711 , End
9370:
11128: END IF;
11129:
11130: -- If l_line_type is set as either 'NEW' or 'RELEASE' call
11131: -- l_line_income_nr_csr cursor in order to consider either only new
11132: -- assets or only re-leased assets, else no change in the standard behavior
11133:
11134: IF l_line_type IN ('NEW','RELEASE') THEN
11135:
11136: l_line_income_amount := 0;
11643: /* ankushar 09-Feb-2007 OKL R12B Billing enhancement
11644: Replaced reference of okl_cnsld_ar_strms_b with Billing Util API call
11645: start changes
11646: */
11647: --Initialize standard API parameters
11648: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
11649: x_msg_count NUMBER;
11650: x_msg_data VARCHAR2(256);
11651:
11927: --ndani - 15-Mar-2013 Start - Rebook Accounting Fix
11928: --Bug# 16511024 , Start
11929: -- If l_line_type is set as either 'NEW' or 'RELEASE' call
11930: -- l_nr_asset_csr_incl_terminated or l_nr_asset_csr cursor in order to consider either only new
11931: -- assets or only re-leased assets, else no change in the standard behavior
11932:
11933: IF l_line_type IN ('NEW','RELEASE') THEN
11934: IF l_discount_incl_terminated THEN
11935: OPEN l_nr_asset_csr_incl_terminated(p_chr_id => p_contract_id,