DBA Data[Home] [Help]

APPS.OKL_MASS_REBOOK_PVT dependencies on OKL_STREAMS

Line 3146: FROM okl_streams strm,

3142: --Bug 6740000 ssdeshpa start
3143: --Changed Stream Type Subclass to 'INVESTOR_DISBURSEMENT'
3144: CURSOR disb_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3145: SELECT strm.id
3146: FROM okl_streams strm,
3147: okl_strm_type_v TYPE
3148: WHERE TYPE.id = strm.sty_id
3149: AND TYPE.stream_type_subclass = 'INVESTOR_DISBURSEMENT'
3150: AND strm.khr_id = p_chr_id

Line 3156: FROM okl_streams strm,

3152: --Bug 6740000 ssdeshpa End
3153:
3154: CURSOR accu_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3155: SELECT strm.id
3156: FROM okl_streams strm,
3157: okl_strm_type_v TYPE
3158: WHERE TYPE.id = strm.sty_id
3159: AND TYPE.stream_type_purpose IN (
3160: 'INVESTOR_RENTAL_ACCRUAL',

Line 3187: l_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;

3183: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
3184: --Bug 6740000 ssdeshpa End
3185:
3186: i NUMBER := 0;
3187: l_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3188: x_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3189:
3190: l_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3191: x_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;

Line 3188: x_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;

3184: --Bug 6740000 ssdeshpa End
3185:
3186: i NUMBER := 0;
3187: l_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3188: x_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3189:
3190: l_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3191: x_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3192:

Line 3190: l_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;

3186: i NUMBER := 0;
3187: l_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3188: x_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3189:
3190: l_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3191: x_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3192:
3193:
3194: lx_value VARCHAR2(1);

Line 3191: x_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;

3187: l_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3188: x_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3189:
3190: l_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3191: x_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3192:
3193:
3194: lx_value VARCHAR2(1);
3195: lx_inv_agmt_chr_id_tbl Okl_Securitization_Pvt.inv_agmt_chr_id_tbl_type;

Line 3245: okl_streams_pub.update_streams(

3241: l_disb_strm_tbl(i).date_history := SYSDATE;
3242: END LOOP;
3243:
3244: IF (l_disb_strm_tbl.COUNT > 0) THEN
3245: okl_streams_pub.update_streams(
3246: p_api_version => 1.0,
3247: p_init_msg_list => OKC_API.G_FALSE,
3248: x_return_status => x_return_status,
3249: x_msg_count => x_msg_count,

Line 3386: okl_streams_pub.update_streams(

3382: l_accu_strm_tbl(i).active_yn := 'N';
3383: END LOOP;
3384:
3385: IF (l_accu_strm_tbl.COUNT > 0) THEN
3386: okl_streams_pub.update_streams(
3387: p_api_version => 1.0,
3388: p_init_msg_list => OKC_API.G_FALSE,
3389: x_return_status => x_return_status,
3390: x_msg_count => x_msg_count,

Line 3636: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041

3632: END IF;
3633:
3634: -- dedey,Bug#4264314
3635:
3636: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041
3637: OKL_CONTRACT_REBOOK_PVT.calc_accrual_adjustment(
3638: p_api_version => p_api_version,
3639: p_init_msg_list => p_init_msg_list,
3640: x_return_status => x_return_status,

Line 3778: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS; -- MGAAP 7263041

3774:
3775: -- MGAAP start 7263041
3776: IF (l_multi_gaap_yn = 'Y') THEN
3777:
3778: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS; -- MGAAP 7263041
3779:
3780: OKL_CONTRACT_REBOOK_PVT.calc_accrual_adjustment(
3781: p_api_version => p_api_version,
3782: p_init_msg_list => p_init_msg_list,

Line 3793: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041

3789: p_trx_date => sysdate, -- 4583578 passing sysdate instead of rebook date
3790: x_accrual_rec => l_accrual_rec,
3791: x_stream_tbl => l_stream_tbl);
3792:
3793: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041
3794:
3795: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3796: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3797: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 3885: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

3881: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3882: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before call calc_inv_acc_adjustment for SECONDARY');
3883: END IF;
3884:
3885: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3886: OKL_CONTRACT_REBOOK_PVT.calc_inv_acc_adjustment(
3887: p_api_version => p_api_version,
3888: p_init_msg_list => p_init_msg_list,
3889: x_return_status => x_return_status,

Line 3900: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

3896: x_inv_stream_tbl => l_inv_stream_tbl,
3897: p_product_id => l_reporting_pdt_id
3898: );
3899:
3900: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
3901:
3902: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3903: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call calc_inv_acc_adjustment'||x_return_status);
3904: END IF;