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.

APPS.OKL_MASS_REBOOK_PVT dependencies on OKL_TRX_CONTRACTS

Line 2585: Okl_Trx_Contracts_Pub.update_trx_contracts(

2581: l_tcnv_rec.source_trx_id := G_TERMINATION_TRX_ID;
2582: l_tcnv_rec.source_trx_type := G_TERMINATION_TRX_TYPE;
2583: G_MASS_RBK_TRX_ID := x_tcnv_rec.id;
2584:
2585: Okl_Trx_Contracts_Pub.update_trx_contracts(
2586: p_api_version => l_api_version,
2587: p_init_msg_list => OKL_API.G_FALSE,
2588: x_return_status => x_return_status,
2589: x_msg_count => x_msg_count,

Line 2620: Okl_Trx_Contracts_Pub.update_trx_contracts(

2616: --l_tcnv_rec.source_trx_type := G_PPD_TRX_TYPE;
2617: l_tcnv_rec.source_trx_type := 'TCN';
2618: G_MASS_RBK_TRX_ID := x_tcnv_rec.id;
2619:
2620: Okl_Trx_Contracts_Pub.update_trx_contracts(
2621: p_api_version => l_api_version,
2622: p_init_msg_list => OKL_API.G_FALSE,
2623: x_return_status => x_return_status,
2624: x_msg_count => x_msg_count,

Line 3123: FROM okl_trx_contracts

3119:
3120: CURSOR l_okl_trbk_txn_csr
3121: IS
3122: SELECT date_transaction_occurred
3123: FROM okl_trx_contracts
3124: WHERE id = p_rbk_trx_id;
3125:
3126: CURSOR l_okl_tcn_type_csr
3127: IS

Line 3132: FROM okl_trx_contracts trxp,

3128: SELECT trxp.tcn_type,
3129: trxp.qte_id,
3130: trxp.date_transaction_occurred,
3131: qtev.qtp_code
3132: FROM okl_trx_contracts trxp,
3133: okl_trx_contracts trxc,
3134: okl_trx_quotes_v qtev
3135: WHERE trxp.id = trxc.source_trx_id
3136: AND trxc.id = p_rbk_trx_id

Line 3133: okl_trx_contracts trxc,

3129: trxp.qte_id,
3130: trxp.date_transaction_occurred,
3131: qtev.qtp_code
3132: FROM okl_trx_contracts trxp,
3133: okl_trx_contracts trxc,
3134: okl_trx_quotes_v qtev
3135: WHERE trxp.id = trxc.source_trx_id
3136: AND trxc.id = p_rbk_trx_id
3137: AND trxc.tsu_code <> 'PROCESSED'

Line 3521: FROM okl_trx_contracts

3517:
3518:
3519: CURSOR parent_trx_csr (p_trx_id NUMBER) IS
3520: SELECT source_trx_id, source_trx_type
3521: FROM okl_trx_contracts
3522: WHERE id = p_trx_id
3523: AND tsu_code <> 'PROCESSED';
3524:
3525: CURSOR parent_tcn_type_csr (p_trx_id NUMBER) IS

Line 3527: from okl_trx_contracts

3523: AND tsu_code <> 'PROCESSED';
3524:
3525: CURSOR parent_tcn_type_csr (p_trx_id NUMBER) IS
3526: select tcn_type
3527: from okl_trx_contracts
3528: where id = p_trx_id;
3529:
3530: l_rbk_id okl_rbk_selected_contract.id%TYPE;
3531: l_rbk_khr_id okl_rbk_selected_contract.khr_id%TYPE;

Line 3543: l_parent_tcn_type okl_trx_contracts.tcn_type%TYPE;

3539: --Bug# 4107330
3540: l_rbk_trx_date okl_rbk_selected_contract.transaction_date%TYPE;
3541: l_request_name okl_rbk_selected_contract.request_name%TYPE;
3542:
3543: l_parent_tcn_type okl_trx_contracts.tcn_type%TYPE;
3544: l_mstv_tbl mstv_tbl_type;
3545: x_mstv_tbl mstv_tbl_type;
3546:
3547: l_tcnv_rec tcnv_rec_type;

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

3552:
3553: not_to_process EXCEPTION;
3554:
3555: -- dedey,Bug#4264314
3556: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE := null; -- MGAAP 7263041
3557: l_accrual_rec OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type;
3558: l_stream_tbl OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type;
3559: -- dedey,Bug#4264314
3560:

Line 3971: Okl_Trx_Contracts_Pub.update_trx_contracts(

3967: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3968: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before update_trx_contracts');
3969: END IF;
3970:
3971: Okl_Trx_Contracts_Pub.update_trx_contracts(
3972: p_api_version => l_api_version,
3973: p_init_msg_list => OKL_API.G_FALSE,
3974: x_return_status => x_return_status,
3975: x_msg_count => x_msg_count,

Line 4029: Okl_Trx_Contracts_Pub.update_trx_contracts(

4025: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4026: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'before update_trx_contracts');
4027: END IF;
4028:
4029: Okl_Trx_Contracts_Pub.update_trx_contracts(
4030: p_api_version => l_api_version,
4031: p_init_msg_list => OKL_API.G_FALSE,
4032: x_return_status => x_return_status,
4033: x_msg_count => x_msg_count,

Line 4118: Okl_Trx_Contracts_Pub.update_trx_contracts(

4114: l_tcnv_rec.id := l_rbk_transaction_id;
4115: l_tcnv_rec.tsu_code := 'PROCESSED';
4116:
4117:
4118: Okl_Trx_Contracts_Pub.update_trx_contracts(
4119: p_api_version => l_api_version,
4120: p_init_msg_list => OKL_API.G_FALSE,
4121: x_return_status => x_return_status,
4122: x_msg_count => x_msg_count,

Line 4460: Okl_Trx_Contracts_Pub.update_trx_contracts(

4456:
4457: l_tcnv_rec.id := trx_rec.transaction_id;
4458: l_tcnv_rec.tsu_code := 'CANCELED';
4459:
4460: Okl_Trx_Contracts_Pub.update_trx_contracts(
4461: p_api_version => 1.0,
4462: p_init_msg_list => OKL_API.G_FALSE,
4463: x_return_status => x_return_status,
4464: x_msg_count => x_msg_count,

Line 5450: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,

5446: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5447: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5448: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5449: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5450: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5451: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5452: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5453: ) IS
5454:

Line 5451: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,

5447: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5448: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5449: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5450: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5451: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5452: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5453: ) IS
5454:
5455: l_api_name VARCHAR2(35) := 'apply_mass_rebook';

Line 5452: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE

5448: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5449: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5450: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5451: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5452: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5453: ) IS
5454:
5455: l_api_name VARCHAR2(35) := 'apply_mass_rebook';
5456: l_proc_name VARCHAR2(35) := 'APPLY_MASS_REBOOK';

Line 5696: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,

5692: p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
5693: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5694: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5695: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5696: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5697: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5698: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
5699: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5700: ) IS

Line 5697: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,

5693: p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
5694: p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
5695: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5696: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5697: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5698: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
5699: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5700: ) IS
5701:

Line 5699: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE

5695: p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
5696: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5697: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5698: p_transaction_date IN OKL_RBK_SELECTED_CONTRACT.TRANSACTION_DATE%TYPE,
5699: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE
5700: ) IS
5701:
5702: l_api_name VARCHAR2(35) := 'apply_mass_rebook';
5703: l_proc_name VARCHAR2(35) := 'APPLY_MASS_REBOOK';

Line 5938: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,

5934: x_msg_count OUT NOCOPY NUMBER,
5935: x_msg_data OUT NOCOPY VARCHAR2,
5936: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
5937: p_kle_tbl IN kle_tbl_type,
5938: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5939: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5940: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
5941: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
5942: p_ppd_amount IN NUMBER,

Line 5939: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,

5935: x_msg_data OUT NOCOPY VARCHAR2,
5936: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
5937: p_kle_tbl IN kle_tbl_type,
5938: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5939: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5940: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
5941: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
5942: p_ppd_amount IN NUMBER,
5943: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,

Line 5940: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,

5936: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
5937: p_kle_tbl IN kle_tbl_type,
5938: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5939: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5940: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
5941: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
5942: p_ppd_amount IN NUMBER,
5943: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,
5944: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type

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

5937: p_kle_tbl IN kle_tbl_type,
5938: p_source_trx_id IN OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
5939: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5940: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
5941: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
5942: p_ppd_amount IN NUMBER,
5943: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,
5944: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type
5945: )