[Home] [Help]
5812: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
5813:
5814: BEGIN
5815:
5816: l_streams_repo_policy := OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY;
5817:
5818: -- calculate asset line level depreciation
5819: IF(p_contract_line_id IS NOT NULL) THEN
5820: FOR p_asset_details_csr IN asset_details_csr(p_contract_line_id)
6441:
6442: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
6443: BEGIN
6444:
6445: l_streams_repo_policy := OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY;
6446: -- calculate asset line level depreciation
6447: IF(p_contract_line_id IS NOT NULL) THEN
6448: FOR p_asset_details_csr IN asset_details_csr(p_contract_line_id)
6449: LOOP
10868: IF (( p_contract_id IS NULL ) OR ( p_contract_line_id IS NULL )) THEN
10869: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
10870: END IF;
10871:
10872: l_streams_repo_policy := OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY;
10873: l_book_type_code := NULL;
10874: IF (l_streams_repo_policy = 'PRIMARY') THEN
10875: l_book_class := 'CORPORATE';
10876: ELSE
11092: IF (( p_contract_id IS NULL ) OR ( p_contract_line_id IS NULL )) THEN
11093: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
11094: END IF;
11095:
11096: l_streams_repo_policy := OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY;
11097: l_book_type_code := NULL;
11098: IF (l_streams_repo_policy = 'PRIMARY') THEN
11099: l_book_class := 'CORPORATE';
11100: ELSE
12244: -- gboomina Bug 5215019 - End
12245:
12246: --check if streams required for reporting product
12247: IF l_rep_prod_streams_yn = 'Y' THEN
12248: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS; --MGAAP 7263041
12249: --PAGARG 31-Dec-2004 Bug# 4097591, Pass stream type id to cursor
12250: --OPEN line_reporting_csr(p_contract_line_id, l_end_date, l_stream_type_id); -- now passing l_end_date 26-Aug-2004 3849355
12251: OPEN line_csr(p_contract_line_id, l_end_date, l_stream_type_id); -- now passing l_end_date 26-Aug-2004 3849355
12252: FETCH line_csr INTO l_unearned_income;
12250: --OPEN line_reporting_csr(p_contract_line_id, l_end_date, l_stream_type_id); -- now passing l_end_date 26-Aug-2004 3849355
12251: OPEN line_csr(p_contract_line_id, l_end_date, l_stream_type_id); -- now passing l_end_date 26-Aug-2004 3849355
12252: FETCH line_csr INTO l_unearned_income;
12253: CLOSE line_csr;
12254: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
12255: ELSE
12256: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
12257: -- Start : Bug 6030917 : prasjain
12258: --added for prorating incase of partial unit termination
12252: FETCH line_csr INTO l_unearned_income;
12253: CLOSE line_csr;
12254: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
12255: ELSE
12256: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
12257: -- Start : Bug 6030917 : prasjain
12258: --added for prorating incase of partial unit termination
12259:
12260: IF nvl(l_proration_factor,1) = 1 THEN
14063: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14064: END IF;
14065:
14066: -- 7626121
14067: l_streams_repo_policy := OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY;
14068: l_book_type_code := NULL;
14069: IF (l_streams_repo_policy = 'PRIMARY') THEN
14070: l_book_class := 'CORPORATE';
14071: ELSE