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_SEC_AGREEMENT_PVT dependencies on OKL_CONTRACT_PUB

Line 1570: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

1566: lx_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1567:
1568: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1569: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1570: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1571: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1572:
1573: l_polv_rec polv_rec_type;
1574: x_polv_rec polv_rec_type;

Line 1571: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

1567:
1568: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1569: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
1570: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1571: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
1572:
1573: l_polv_rec polv_rec_type;
1574: x_polv_rec polv_rec_type;
1575:

Line 1728: OKL_CONTRACT_PUB.validate_contract_header(

1724: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1725: RAISE OKC_API.G_EXCEPTION_ERROR;
1726: END IF;
1727:
1728: OKL_CONTRACT_PUB.validate_contract_header(
1729: p_api_version => p_api_version,
1730: p_init_msg_list => p_init_msg_list,
1731: x_return_status => x_return_status,
1732: x_msg_count => x_msg_count,

Line 1743: OKL_CONTRACT_PUB.create_contract_header(

1739: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1740: RAISE OKC_API.G_EXCEPTION_ERROR;
1741: END IF;
1742:
1743: OKL_CONTRACT_PUB.create_contract_header(
1744: p_api_version => p_api_version,
1745: p_init_msg_list => p_init_msg_list,
1746: x_return_status => x_return_status,
1747: x_msg_count => x_msg_count,

Line 2011: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

2007: lx_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
2008:
2009: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2010: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2011: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2012: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2013: l_polv_rec polv_rec_type;
2014: x_polv_rec polv_rec_type;
2015:

Line 2012: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

2008:
2009: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2010: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2011: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2012: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2013: l_polv_rec polv_rec_type;
2014: x_polv_rec polv_rec_type;
2015:
2016: lp_clev_rec clev_rec_type;

Line 2146: OKL_CONTRACT_PUB.update_contract_header(

2142: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2143: RAISE OKC_API.G_EXCEPTION_ERROR;
2144: END IF;
2145:
2146: OKL_CONTRACT_PUB.update_contract_header(
2147: p_api_version => p_api_version,
2148: p_init_msg_list => p_init_msg_list,
2149: x_return_status => x_return_status,
2150: x_msg_count => x_msg_count,

Line 2358: okl_contract_pub.update_contract_line(

2354: lp_clev_rec.end_date := p_secAgreement_rec.end_date;
2355: lp_clev_rec.id := l_kle_id;
2356:
2357:
2358: okl_contract_pub.update_contract_line(
2359: p_api_version => p_api_version,
2360: p_init_msg_list => p_init_msg_list,
2361: x_return_status => x_return_status,
2362: x_msg_count => x_msg_count,

Line 2389: okl_contract_pub.update_contract_line(

2385: lp_clev_rec.end_date := p_secAgreement_rec.end_date;
2386: lp_clev_rec.id := l_okl_top_line_rec.id;
2387:
2388:
2389: okl_contract_pub.update_contract_line(
2390: p_api_version => p_api_version,
2391: p_init_msg_list => p_init_msg_list,
2392: x_return_status => x_return_status,
2393: x_msg_count => x_msg_count,

Line 2415: okl_contract_pub.update_contract_line(

2411: lp_clev_rec.end_date := p_secAgreement_rec.end_date;
2412: lp_clev_rec.id := l_okl_sub_line_rec.id;
2413:
2414:
2415: okl_contract_pub.update_contract_line(
2416: p_api_version => p_api_version,
2417: p_init_msg_list => p_init_msg_list,
2418: x_return_status => x_return_status,
2419: x_msg_count => x_msg_count,

Line 2508: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

2504: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
2505: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2506: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2507: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2508: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2509: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2510:
2511:
2512:

Line 2509: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

2505: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2506: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2507: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2508: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2509: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2510:
2511:
2512:
2513: lp_secagreement_rec secagreement_rec_type;

Line 2743: --dbms_output.put_line('okl_contract_pub.update_contract_header start');

2739: ----------------------------------------------------------------------------
2740: --3 Mark associated contract to securitizated
2741: ----------------------------------------------------------------------------
2742: --dbms_output.put_line('3. Mark associated contract to securtizated');
2743: --dbms_output.put_line('okl_contract_pub.update_contract_header start');
2744: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2745: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '3. Mark associated contract to securtizated.');
2746: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_contract_pub.update_contract_header: START');
2747: END IF;

Line 2746: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_contract_pub.update_contract_header: START');

2742: --dbms_output.put_line('3. Mark associated contract to securtizated');
2743: --dbms_output.put_line('okl_contract_pub.update_contract_header start');
2744: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2745: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '3. Mark associated contract to securtizated.');
2746: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_contract_pub.update_contract_header: START');
2747: END IF;
2748:
2749:
2750: OPEN c_pool_chr;

Line 2764: okl_contract_pub.update_contract_header(

2760: lp_chrv_rec.id := l_chr_id;
2761: lp_khrv_rec.id := l_chr_id;
2762: lp_khrv_rec.SECURITIZED_CODE := G_SECURITIZED_CODE_Y;
2763:
2764: okl_contract_pub.update_contract_header(
2765: p_api_version => p_api_version,
2766: p_init_msg_list => p_init_msg_list,
2767: x_return_status => x_return_status,
2768: x_msg_count => x_msg_count,

Line 2776: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header x_return_status :' || x_return_status);

2772: x_chrv_rec => lx_chrv_rec,
2773: x_khrv_rec => lx_khrv_rec);
2774:
2775: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2776: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header x_return_status :' || x_return_status);
2777: END IF;
2778:
2779: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2780: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2788: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header: END');

2784:
2785: END LOOP;
2786: CLOSE c_pool_chr;
2787: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2788: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header: END');
2789: END IF;
2790:
2791: -- gboomina added for Bug 6763287 - Start
2792: ----------------------------------------------------------------------------

Line 3211: --dbms_output.put_line('okl_contract_pub.update_contract_line start');

3207: -- cascade update all associated line sts_code to active
3208: -- loop
3209: ----------------------------------------------------------------------------
3210: --dbms_output.put_line('2. update agreement contract header lines status');
3211: --dbms_output.put_line('okl_contract_pub.update_contract_line start');
3212:
3213: OPEN c_agr_lns;
3214: LOOP
3215: FETCH c_agr_lns INTO

Line 3224: okl_contract_pub.update_contract_line(

3220: lp_klev_rec.id := l_kle_id;
3221: lp_clev_rec.STS_CODE := p_sec_agreement_status;
3222: lp_clev_rec.id := l_kle_id;
3223:
3224: okl_contract_pub.update_contract_line(
3225: p_api_version => p_api_version,
3226: p_init_msg_list => p_init_msg_list,
3227: x_return_status => x_return_status,
3228: x_msg_count => x_msg_count,

Line 3243: --dbms_output.put_line('okl_contract_pub.update_contract_line start');

3239: END IF;
3240:
3241: END LOOP;
3242: CLOSE c_agr_lns;
3243: --dbms_output.put_line('okl_contract_pub.update_contract_line start');
3244:
3245: /*** End API body ******************************************************/
3246:
3247: -- Get message count and if count is 1, get message info

Line 3447: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

3443: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3444:
3445: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3446: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3447: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3448: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3449:
3450:
3451:

Line 3448: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

3444:
3445: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3446: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3447: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3448: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3449:
3450:
3451:
3452: lp_secagreement_rec secagreement_rec_type;

Line 3647: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_contract_pub.update_contract_header: START');

3643: --2 Mark associated contract to securitizated
3644: ----------------------------------------------------------------------------
3645: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3646: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '2. Mark associated contract to securtizated.');
3647: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_contract_pub.update_contract_header: START');
3648: END IF;
3649:
3650: OPEN c_pool_chr_csr(l_pol_id);
3651: LOOP

Line 3663: okl_contract_pub.update_contract_header(

3659: lp_chrv_rec.id := l_chr_id;
3660: lp_khrv_rec.id := l_chr_id;
3661: lp_khrv_rec.SECURITIZED_CODE := G_SECURITIZED_CODE_Y;
3662:
3663: okl_contract_pub.update_contract_header(
3664: p_api_version => p_api_version,
3665: p_init_msg_list => p_init_msg_list,
3666: x_return_status => x_return_status,
3667: x_msg_count => x_msg_count,

Line 3675: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header x_return_status :' || x_return_status);

3671: x_chrv_rec => lx_chrv_rec,
3672: x_khrv_rec => lx_khrv_rec);
3673:
3674: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3675: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header x_return_status :' || x_return_status);
3676: END IF;
3677:
3678: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3679: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3687: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header: END');

3683:
3684: END LOOP;
3685: CLOSE c_pool_chr_csr;
3686: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3687: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header: END');
3688: END IF;
3689:
3690:
3691: ----------------------------------------------------------------------------

Line 3870: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');

3866: --Update the total stake to include the additional stake
3867: FOR get_inv_stake_rec IN get_inv_stake_csr(p_khr_id)
3868: LOOP
3869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3870: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');
3871: END IF;
3872:
3873: --Only if an additional stake amount has been captured, then add this stake to the original stake
3874: IF get_inv_stake_rec.additional_stake IS NOT NULL THEN

Line 3880: OKL_CONTRACT_PUB.update_contract_line(

3876: l_klev_rec.id := get_inv_stake_rec.id;
3877: l_klev_rec.amount := get_inv_stake_rec.original_stake + get_inv_stake_rec.additional_stake;
3878: l_klev_rec.amount_stake := NULL;
3879:
3880: OKL_CONTRACT_PUB.update_contract_line(
3881: p_api_version => p_api_version,
3882: p_init_msg_list => p_init_msg_list,
3883: x_return_status => x_return_status,
3884: x_msg_count => x_msg_count,

Line 4419: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');

4415: --Update the additional stake on removing transaction
4416: FOR get_inv_stake_rec IN get_inv_stake_csr(p_chr_id)
4417: LOOP
4418: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4419: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');
4420: END IF;
4421:
4422:
4423: --Remove the additional stake amount

Line 4429: OKL_CONTRACT_PUB.update_contract_line(

4425: l_clev_rec.id := get_inv_stake_rec.id;
4426: l_klev_rec.id := get_inv_stake_rec.id;
4427: l_klev_rec.amount_stake := NULL;
4428:
4429: OKL_CONTRACT_PUB.update_contract_line(
4430: p_api_version => p_api_version,
4431: p_init_msg_list => p_init_msg_list,
4432: x_return_status => x_return_status,
4433: x_msg_count => x_msg_count,