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 1720: OKL_CONTRACT_PUB.validate_contract_header(

1716: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1717: RAISE OKC_API.G_EXCEPTION_ERROR;
1718: END IF;
1719:
1720: OKL_CONTRACT_PUB.validate_contract_header(
1721: p_api_version => p_api_version,
1722: p_init_msg_list => p_init_msg_list,
1723: x_return_status => x_return_status,
1724: x_msg_count => x_msg_count,

Line 1735: OKL_CONTRACT_PUB.create_contract_header(

1731: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1732: RAISE OKC_API.G_EXCEPTION_ERROR;
1733: END IF;
1734:
1735: OKL_CONTRACT_PUB.create_contract_header(
1736: p_api_version => p_api_version,
1737: p_init_msg_list => p_init_msg_list,
1738: x_return_status => x_return_status,
1739: x_msg_count => x_msg_count,

Line 2003: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

1999: lx_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
2000:
2001: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2002: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2003: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2004: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2005: l_polv_rec polv_rec_type;
2006: x_polv_rec polv_rec_type;
2007:

Line 2004: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

2000:
2001: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2002: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2003: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2004: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2005: l_polv_rec polv_rec_type;
2006: x_polv_rec polv_rec_type;
2007:
2008: lp_clev_rec clev_rec_type;

Line 2129: OKL_CONTRACT_PUB.update_contract_header(

2125: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2126: RAISE OKC_API.G_EXCEPTION_ERROR;
2127: END IF;
2128:
2129: OKL_CONTRACT_PUB.update_contract_header(
2130: p_api_version => p_api_version,
2131: p_init_msg_list => p_init_msg_list,
2132: x_return_status => x_return_status,
2133: x_msg_count => x_msg_count,

Line 2341: okl_contract_pub.update_contract_line(

2337: lp_clev_rec.end_date := p_secAgreement_rec.end_date;
2338: lp_clev_rec.id := l_kle_id;
2339:
2340:
2341: okl_contract_pub.update_contract_line(
2342: p_api_version => p_api_version,
2343: p_init_msg_list => p_init_msg_list,
2344: x_return_status => x_return_status,
2345: x_msg_count => x_msg_count,

Line 2372: okl_contract_pub.update_contract_line(

2368: lp_clev_rec.end_date := p_secAgreement_rec.end_date;
2369: lp_clev_rec.id := l_okl_top_line_rec.id;
2370:
2371:
2372: okl_contract_pub.update_contract_line(
2373: p_api_version => p_api_version,
2374: p_init_msg_list => p_init_msg_list,
2375: x_return_status => x_return_status,
2376: x_msg_count => x_msg_count,

Line 2398: okl_contract_pub.update_contract_line(

2394: lp_clev_rec.end_date := p_secAgreement_rec.end_date;
2395: lp_clev_rec.id := l_okl_sub_line_rec.id;
2396:
2397:
2398: okl_contract_pub.update_contract_line(
2399: p_api_version => p_api_version,
2400: p_init_msg_list => p_init_msg_list,
2401: x_return_status => x_return_status,
2402: x_msg_count => x_msg_count,

Line 2491: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

2487: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
2488: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2489: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2490: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2491: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2492: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2493:
2494:
2495:

Line 2492: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

2488: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2489: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2490: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2491: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2492: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
2493:
2494:
2495:
2496: lp_secagreement_rec secagreement_rec_type;

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

2722: ----------------------------------------------------------------------------
2723: --3 Mark associated contract to securitizated
2724: ----------------------------------------------------------------------------
2725: --dbms_output.put_line('3. Mark associated contract to securtizated');
2726: --dbms_output.put_line('okl_contract_pub.update_contract_header start');
2727: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2728: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '3. Mark associated contract to securtizated.');
2729: 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');
2730: END IF;

Line 2729: 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');

2725: --dbms_output.put_line('3. Mark associated contract to securtizated');
2726: --dbms_output.put_line('okl_contract_pub.update_contract_header start');
2727: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2728: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '3. Mark associated contract to securtizated.');
2729: 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');
2730: END IF;
2731:
2732:
2733: OPEN c_pool_chr;

Line 2747: okl_contract_pub.update_contract_header(

2743: lp_chrv_rec.id := l_chr_id;
2744: lp_khrv_rec.id := l_chr_id;
2745: lp_khrv_rec.SECURITIZED_CODE := G_SECURITIZED_CODE_Y;
2746:
2747: okl_contract_pub.update_contract_header(
2748: p_api_version => p_api_version,
2749: p_init_msg_list => p_init_msg_list,
2750: x_return_status => x_return_status,
2751: x_msg_count => x_msg_count,

Line 2759: 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);

2755: x_chrv_rec => lx_chrv_rec,
2756: x_khrv_rec => lx_khrv_rec);
2757:
2758: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2759: 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);
2760: END IF;
2761:
2762: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2763: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2767:
2768: END LOOP;
2769: CLOSE c_pool_chr;
2770: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2771: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header: END');
2772: END IF;
2773:
2774: -- gboomina added for Bug 6763287 - Start
2775: ----------------------------------------------------------------------------

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

3190: -- cascade update all associated line sts_code to active
3191: -- loop
3192: ----------------------------------------------------------------------------
3193: --dbms_output.put_line('2. update agreement contract header lines status');
3194: --dbms_output.put_line('okl_contract_pub.update_contract_line start');
3195:
3196: OPEN c_agr_lns;
3197: LOOP
3198: FETCH c_agr_lns INTO

Line 3207: okl_contract_pub.update_contract_line(

3203: lp_klev_rec.id := l_kle_id;
3204: lp_clev_rec.STS_CODE := p_sec_agreement_status;
3205: lp_clev_rec.id := l_kle_id;
3206:
3207: okl_contract_pub.update_contract_line(
3208: p_api_version => p_api_version,
3209: p_init_msg_list => p_init_msg_list,
3210: x_return_status => x_return_status,
3211: x_msg_count => x_msg_count,

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

3222: END IF;
3223:
3224: END LOOP;
3225: CLOSE c_agr_lns;
3226: --dbms_output.put_line('okl_contract_pub.update_contract_line start');
3227:
3228: /*** End API body ******************************************************/
3229:
3230: -- Get message count and if count is 1, get message info

Line 3430: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

3426: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3427:
3428: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3429: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3430: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3431: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3432:
3433:
3434:

Line 3431: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

3427:
3428: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3429: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3430: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3431: lx_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3432:
3433:
3434:
3435: lp_secagreement_rec secagreement_rec_type;

Line 3630: 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');

3626: --2 Mark associated contract to securitizated
3627: ----------------------------------------------------------------------------
3628: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3629: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '2. Mark associated contract to securtizated.');
3630: 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');
3631: END IF;
3632:
3633: OPEN c_pool_chr_csr(l_pol_id);
3634: LOOP

Line 3646: okl_contract_pub.update_contract_header(

3642: lp_chrv_rec.id := l_chr_id;
3643: lp_khrv_rec.id := l_chr_id;
3644: lp_khrv_rec.SECURITIZED_CODE := G_SECURITIZED_CODE_Y;
3645:
3646: okl_contract_pub.update_contract_header(
3647: p_api_version => p_api_version,
3648: p_init_msg_list => p_init_msg_list,
3649: x_return_status => x_return_status,
3650: x_msg_count => x_msg_count,

Line 3658: 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);

3654: x_chrv_rec => lx_chrv_rec,
3655: x_khrv_rec => lx_khrv_rec);
3656:
3657: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3658: 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);
3659: END IF;
3660:
3661: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3662: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

3666:
3667: END LOOP;
3668: CLOSE c_pool_chr_csr;
3669: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3670: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header: END');
3671: END IF;
3672:
3673:
3674: ----------------------------------------------------------------------------

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

3849: --Update the total stake to include the additional stake
3850: FOR get_inv_stake_rec IN get_inv_stake_csr(p_khr_id)
3851: LOOP
3852: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3853: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');
3854: END IF;
3855:
3856: --Only if an additional stake amount has been captured, then add this stake to the original stake
3857: IF get_inv_stake_rec.additional_stake IS NOT NULL THEN

Line 3863: OKL_CONTRACT_PUB.update_contract_line(

3859: l_klev_rec.id := get_inv_stake_rec.id;
3860: l_klev_rec.amount := get_inv_stake_rec.original_stake + get_inv_stake_rec.additional_stake;
3861: l_klev_rec.amount_stake := NULL;
3862:
3863: OKL_CONTRACT_PUB.update_contract_line(
3864: p_api_version => p_api_version,
3865: p_init_msg_list => p_init_msg_list,
3866: x_return_status => x_return_status,
3867: x_msg_count => x_msg_count,

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

4387: --Update the additional stake on removing transaction
4388: FOR get_inv_stake_rec IN get_inv_stake_csr(p_chr_id)
4389: LOOP
4390: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4391: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');
4392: END IF;
4393:
4394:
4395: --Remove the additional stake amount

Line 4401: OKL_CONTRACT_PUB.update_contract_line(

4397: l_clev_rec.id := get_inv_stake_rec.id;
4398: l_klev_rec.id := get_inv_stake_rec.id;
4399: l_klev_rec.amount_stake := NULL;
4400:
4401: OKL_CONTRACT_PUB.update_contract_line(
4402: p_api_version => p_api_version,
4403: p_init_msg_list => p_init_msg_list,
4404: x_return_status => x_return_status,
4405: x_msg_count => x_msg_count,