eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_MASS_REBOOK_PVT dependencies on OKL_TRX_CONTRACTS

Line 2646: Okl_Trx_Contracts_Pub.update_trx_contracts(

2642: l_tcnv_rec.source_trx_id := G_TERMINATION_TRX_ID;
2643: l_tcnv_rec.source_trx_type := G_TERMINATION_TRX_TYPE;
2644: G_MASS_RBK_TRX_ID := x_tcnv_rec.id;
2645:
2646: Okl_Trx_Contracts_Pub.update_trx_contracts(
2647: p_api_version => l_api_version,
2648: p_init_msg_list => OKL_API.G_FALSE,
2649: x_return_status => x_return_status,
2650: x_msg_count => x_msg_count,

Line 2681: Okl_Trx_Contracts_Pub.update_trx_contracts(

2677: --l_tcnv_rec.source_trx_type := G_PPD_TRX_TYPE;
2678: l_tcnv_rec.source_trx_type := 'TCN';
2679: G_MASS_RBK_TRX_ID := x_tcnv_rec.id;
2680:
2681: Okl_Trx_Contracts_Pub.update_trx_contracts(
2682: p_api_version => l_api_version,
2683: p_init_msg_list => OKL_API.G_FALSE,
2684: x_return_status => x_return_status,
2685: x_msg_count => x_msg_count,

Line 3247: FROM okl_trx_contracts

3243:
3244: CURSOR l_okl_trbk_txn_csr
3245: IS
3246: SELECT date_transaction_occurred
3247: FROM okl_trx_contracts
3248: WHERE id = p_rbk_trx_id;
3249:
3250: CURSOR l_okl_tcn_type_csr
3251: IS

Line 3256: FROM okl_trx_contracts trxp,

3252: SELECT trxp.tcn_type,
3253: trxp.qte_id,
3254: trxp.date_transaction_occurred,
3255: qtev.qtp_code
3256: FROM okl_trx_contracts trxp,
3257: okl_trx_contracts trxc,
3258: okl_trx_quotes_v qtev
3259: WHERE trxp.id = trxc.source_trx_id
3260: AND trxc.id = p_rbk_trx_id

Line 3257: okl_trx_contracts trxc,

3253: trxp.qte_id,
3254: trxp.date_transaction_occurred,
3255: qtev.qtp_code
3256: FROM okl_trx_contracts trxp,
3257: okl_trx_contracts trxc,
3258: okl_trx_quotes_v qtev
3259: WHERE trxp.id = trxc.source_trx_id
3260: AND trxc.id = p_rbk_trx_id
3261: AND trxc.tsu_code <> 'PROCESSED'

Line 3645: FROM okl_trx_contracts

3641:
3642:
3643: CURSOR parent_trx_csr (p_trx_id NUMBER) IS
3644: SELECT source_trx_id, source_trx_type
3645: FROM okl_trx_contracts
3646: WHERE id = p_trx_id
3647: AND tsu_code <> 'PROCESSED';
3648:
3649: CURSOR parent_tcn_type_csr (p_trx_id NUMBER) IS

Line 3651: from okl_trx_contracts

3647: AND tsu_code <> 'PROCESSED';
3648:
3649: CURSOR parent_tcn_type_csr (p_trx_id NUMBER) IS
3650: select tcn_type
3651: from okl_trx_contracts
3652: where id = p_trx_id;
3653:
3654: l_rbk_id okl_rbk_selected_contract.id%TYPE;
3655: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;

Line 3667: l_parent_tcn_type okl_trx_contracts.tcn_type%TYPE;

3663: --Bug# 4107330
3664: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
3665: l_request_name okl_rbk_selected_contract.request_name%TYPE;
3666:
3667: l_parent_tcn_type okl_trx_contracts.tcn_type%TYPE;
3668: l_mstv_tbl mstv_tbl_type;
3669: x_mstv_tbl mstv_tbl_type;
3670:
3671: l_tcnv_rec tcnv_rec_type;

Line 3680: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE := null; -- MGAAP 7263041

3676:
3677: not_to_process EXCEPTION;
3678:
3679: -- dedey,Bug#4264314
3680: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE := null; -- MGAAP 7263041
3681: l_accrual_rec OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type;
3682: l_stream_tbl OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type;
3683: -- dedey,Bug#4264314
3684:

Line 4111: Okl_Trx_Contracts_Pub.update_trx_contracts(

4107: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4108: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before update_trx_contracts');
4109: END IF;
4110:
4111: Okl_Trx_Contracts_Pub.update_trx_contracts(
4112: p_api_version => l_api_version,
4113: p_init_msg_list => OKL_API.G_FALSE,
4114: x_return_status => x_return_status,
4115: x_msg_count => x_msg_count,

Line 4169: Okl_Trx_Contracts_Pub.update_trx_contracts(

4165: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4166: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before update_trx_contracts');
4167: END IF;
4168:
4169: Okl_Trx_Contracts_Pub.update_trx_contracts(
4170: p_api_version => l_api_version,
4171: p_init_msg_list => OKL_API.G_FALSE,
4172: x_return_status => x_return_status,
4173: x_msg_count => x_msg_count,

Line 4258: Okl_Trx_Contracts_Pub.update_trx_contracts(

4254: l_tcnv_rec.id := l_rbk_transaction_id;
4255: l_tcnv_rec.tsu_code := 'PROCESSED';
4256:
4257:
4258: Okl_Trx_Contracts_Pub.update_trx_contracts(
4259: p_api_version => l_api_version,
4260: p_init_msg_list => OKL_API.G_FALSE,
4261: x_return_status => x_return_status,
4262: x_msg_count => x_msg_count,

Line 4600: Okl_Trx_Contracts_Pub.update_trx_contracts(

4596:
4597: l_tcnv_rec.id := trx_rec.transaction_id;
4598: l_tcnv_rec.tsu_code := 'CANCELED';
4599:
4600: Okl_Trx_Contracts_Pub.update_trx_contracts(
4601: p_api_version => 1.0,
4602: p_init_msg_list => OKL_API.G_FALSE,
4603: x_return_status => x_return_status,
4604: x_msg_count => x_msg_count,

Line 5590: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,

5586: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5587: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5588: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5589: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5590: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5591: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5592: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5593: ) IS
5594:

Line 5591: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,

5587: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5588: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5589: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5590: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5591: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5592: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5593: ) IS
5594:
5595: l_api_name VARCHAR2(35) := 'apply_mass_rebook';

Line 5592: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE

5588: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5589: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5590: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5591: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5592: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5593: ) IS
5594:
5595: l_api_name VARCHAR2(35) := 'apply_mass_rebook';
5596: l_proc_name VARCHAR2(35) := 'APPLY_MASS_REBOOK';

Line 5836: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,

5832: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5833: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5834: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5835: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5836: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5837: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5838: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
5839: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5840: ) IS

Line 5837: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,

5833: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5834: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5835: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5836: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5837: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5838: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
5839: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5840: ) IS
5841:

Line 5839: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE

5835: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5836: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5837: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5838: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
5839: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5840: ) IS
5841:
5842: l_api_name VARCHAR2(35) := 'apply_mass_rebook';
5843: l_proc_name VARCHAR2(35) := 'APPLY_MASS_REBOOK';

Line 6078: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,

6074: x_msg_count OUT NOCOPY NUMBER,
6075: x_msg_data OUT NOCOPY VARCHAR2,
6076: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
6077: p_kle_tbl IN kle_tbl_type,
6078: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
6079: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
6080: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
6081: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
6082: p_ppd_amount IN NUMBER,

Line 6079: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,

6075: x_msg_data OUT NOCOPY VARCHAR2,
6076: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
6077: p_kle_tbl IN kle_tbl_type,
6078: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
6079: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
6080: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
6081: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
6082: p_ppd_amount IN NUMBER,
6083: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,

Line 6080: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,

6076: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
6077: p_kle_tbl IN kle_tbl_type,
6078: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
6079: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
6080: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
6081: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
6082: p_ppd_amount IN NUMBER,
6083: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,
6084: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type

Line 6081: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,

6077: p_kle_tbl IN kle_tbl_type,
6078: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
6079: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
6080: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
6081: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
6082: p_ppd_amount IN NUMBER,
6083: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,
6084: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type
6085: )