DBA Data[Home] [Help]

APPS.OKL_MASS_REBOOK_PVT dependencies on OKL_STREAMS

Line 3270: FROM okl_streams strm,

3266: --Bug 6740000 ssdeshpa start
3267: --Changed Stream Type Subclass to 'INVESTOR_DISBURSEMENT'
3268: CURSOR disb_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3269: SELECT strm.id
3270: FROM okl_streams strm,
3271: okl_strm_type_v TYPE
3272: WHERE TYPE.id = strm.sty_id
3273: AND TYPE.stream_type_subclass = 'INVESTOR_DISBURSEMENT'
3274: AND strm.khr_id = p_chr_id

Line 3280: FROM okl_streams strm,

3276: --Bug 6740000 ssdeshpa End
3277:
3278: CURSOR accu_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3279: SELECT strm.id
3280: FROM okl_streams strm,
3281: okl_strm_type_v TYPE
3282: WHERE TYPE.id = strm.sty_id
3283: AND TYPE.stream_type_purpose IN (
3284: 'INVESTOR_RENTAL_ACCRUAL',

Line 3311: l_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;

3307: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
3308: --Bug 6740000 ssdeshpa End
3309:
3310: i NUMBER := 0;
3311: l_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3312: x_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3313:
3314: l_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3315: x_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;

Line 3312: x_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;

3308: --Bug 6740000 ssdeshpa End
3309:
3310: i NUMBER := 0;
3311: l_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3312: x_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3313:
3314: l_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3315: x_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3316:

Line 3314: l_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;

3310: i NUMBER := 0;
3311: l_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3312: x_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3313:
3314: l_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3315: x_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3316:
3317:
3318: lx_value VARCHAR2(1);

Line 3315: x_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;

3311: l_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3312: x_disb_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3313:
3314: l_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3315: x_accu_strm_tbl OKL_STREAMS_PUB.stmv_tbl_type;
3316:
3317:
3318: lx_value VARCHAR2(1);
3319: lx_inv_agmt_chr_id_tbl Okl_Securitization_Pvt.inv_agmt_chr_id_tbl_type;

Line 3369: okl_streams_pub.update_streams(

3365: l_disb_strm_tbl(i).date_history := SYSDATE;
3366: END LOOP;
3367:
3368: IF (l_disb_strm_tbl.COUNT > 0) THEN
3369: okl_streams_pub.update_streams(
3370: p_api_version => 1.0,
3371: p_init_msg_list => OKC_API.G_FALSE,
3372: x_return_status => x_return_status,
3373: x_msg_count => x_msg_count,

Line 3510: okl_streams_pub.update_streams(

3506: l_accu_strm_tbl(i).active_yn := 'N';
3507: END LOOP;
3508:
3509: IF (l_accu_strm_tbl.COUNT > 0) THEN
3510: okl_streams_pub.update_streams(
3511: p_api_version => 1.0,
3512: p_init_msg_list => OKC_API.G_FALSE,
3513: x_return_status => x_return_status,
3514: x_msg_count => x_msg_count,

Line 3765: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041

3761: END IF;
3762:
3763: -- dedey,Bug#4264314
3764:
3765: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041
3766: OKL_CONTRACT_REBOOK_PVT.calc_accrual_adjustment(
3767: p_api_version => p_api_version,
3768: p_init_msg_list => p_init_msg_list,
3769: x_return_status => x_return_status,

Line 3909: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS; -- MGAAP 7263041

3905:
3906: -- MGAAP start 7263041
3907: IF (l_multi_gaap_yn = 'Y') THEN
3908:
3909: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS; -- MGAAP 7263041
3910:
3911: OKL_CONTRACT_REBOOK_PVT.calc_accrual_adjustment(
3912: p_api_version => p_api_version,
3913: p_init_msg_list => p_init_msg_list,

Line 3924: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041

3920: p_trx_date => sysdate, -- 4583578 passing sysdate instead of rebook date
3921: x_accrual_rec => l_accrual_rec,
3922: x_stream_tbl => l_stream_tbl);
3923:
3924: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041
3925:
3926: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3927: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3928: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 4022: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

4018: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4019: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before call calc_inv_acc_adjustment for SECONDARY');
4020: END IF;
4021:
4022: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
4023: OKL_CONTRACT_REBOOK_PVT.calc_inv_acc_adjustment(
4024: p_api_version => p_api_version,
4025: p_init_msg_list => p_init_msg_list,
4026: x_return_status => x_return_status,

Line 4037: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

4033: x_inv_stream_tbl => l_inv_stream_tbl,
4034: p_product_id => l_reporting_pdt_id
4035: );
4036:
4037: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
4038:
4039: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4040: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call calc_inv_acc_adjustment'||x_return_status);
4041: END IF;