DBA Data[Home] [Help]

APPS.OKE_AGREEMENT_PVT dependencies on OKE_AGREEMENT_PVT

Line 1: package body OKE_AGREEMENT_PVT as

1: package body OKE_AGREEMENT_PVT as
2: /* $Header: OKEVKAGB.pls 120.3 2005/10/11 12:26:24 ifilimon noship $ */
3:
4: --
5: -- Local Variables

Line 2483: --oke_debug.debug('entering oke_agreement_pvt.create_agreement');

2479: l_agreement_length NUMBER := 0;
2480:
2481: BEGIN
2482:
2483: --oke_debug.debug('entering oke_agreement_pvt.create_agreement');
2484: --dbms_output.put_line('enter oke_agreement_pvt.create_agreement');
2485:
2486: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2487:

Line 2484: --dbms_output.put_line('enter oke_agreement_pvt.create_agreement');

2480:
2481: BEGIN
2482:
2483: --oke_debug.debug('entering oke_agreement_pvt.create_agreement');
2484: --dbms_output.put_line('enter oke_agreement_pvt.create_agreement');
2485:
2486: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2487:
2488: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

Line 3031: --dbms_output.put_line('finished oke_agreement_pvt.create_agreement w/ ' || p_return_status);

3027: COMMIT WORK;
3028:
3029: END IF;
3030:
3031: --dbms_output.put_line('finished oke_agreement_pvt.create_agreement w/ ' || p_return_status);
3032: --oke_debug.debug('finished oke_agreement_pvt.create_agreement w/ ' || p_return_status);
3033:
3034: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
3035: x_msg_data => p_msg_data

Line 3032: --oke_debug.debug('finished oke_agreement_pvt.create_agreement w/ ' || p_return_status);

3028:
3029: END IF;
3030:
3031: --dbms_output.put_line('finished oke_agreement_pvt.create_agreement w/ ' || p_return_status);
3032: --oke_debug.debug('finished oke_agreement_pvt.create_agreement w/ ' || p_return_status);
3033:
3034: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
3035: x_msg_data => p_msg_data
3036: );

Line 3324: --dbms_output.put_line('entering oke_agreement_pvt.update_agreement');

3320: l_agreement_length NUMBER := 0;
3321:
3322: BEGIN
3323:
3324: --dbms_output.put_line('entering oke_agreement_pvt.update_agreement');
3325: --oke_debug.debug('entering oke_agreement_pvt.update_agreement');
3326:
3327: p_return_status := OKE_API.G_RET_STS_SUCCESS;
3328:

Line 3325: --oke_debug.debug('entering oke_agreement_pvt.update_agreement');

3321:
3322: BEGIN
3323:
3324: --dbms_output.put_line('entering oke_agreement_pvt.update_agreement');
3325: --oke_debug.debug('entering oke_agreement_pvt.update_agreement');
3326:
3327: p_return_status := OKE_API.G_RET_STS_SUCCESS;
3328:
3329: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

Line 4232: --dbms_output.put_line('finished oke_agreement_pvt.update_agreement w/ ' || p_return_status);

4228: COMMIT WORK;
4229:
4230: END IF;
4231:
4232: --dbms_output.put_line('finished oke_agreement_pvt.update_agreement w/ ' || p_return_status);
4233: --oke_debug.debug('finished oke_agreement_pvt.update_agreement w/ ' || p_return_status);
4234:
4235: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
4236: x_msg_data => p_msg_data

Line 4233: --oke_debug.debug('finished oke_agreement_pvt.update_agreement w/ ' || p_return_status);

4229:
4230: END IF;
4231:
4232: --dbms_output.put_line('finished oke_agreement_pvt.update_agreement w/ ' || p_return_status);
4233: --oke_debug.debug('finished oke_agreement_pvt.update_agreement w/ ' || p_return_status);
4234:
4235: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
4236: x_msg_data => p_msg_data
4237: );

Line 4369: --dbms_output.put_line('entering oke_agreement_pvt.update_pa_funding');

4365: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
4366:
4367: BEGIN
4368:
4369: --dbms_output.put_line('entering oke_agreement_pvt.update_pa_funding');
4370: --oke_debug.debug('entering oke_agreement_pvt.update_pa_funding');
4371:
4372: p_return_status := OKE_API.G_RET_STS_SUCCESS;
4373:

Line 4370: --oke_debug.debug('entering oke_agreement_pvt.update_pa_funding');

4366:
4367: BEGIN
4368:
4369: --dbms_output.put_line('entering oke_agreement_pvt.update_pa_funding');
4370: --oke_debug.debug('entering oke_agreement_pvt.update_pa_funding');
4371:
4372: p_return_status := OKE_API.G_RET_STS_SUCCESS;
4373:
4374: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

Line 4521: --dbms_output.put_line('calling pa_agreement_pub.add_funding from oke_agreement_pvt');

4517: IF (l_add_flag = 'Y') THEN -- AND
4518: --(nvl(l_version, 0) <> 0 or p_allocation_in_rec.amount <> 0) THEN
4519:
4520: IF l_diff_amount<>0 THEN
4521: --dbms_output.put_line('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4522: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4523:
4524: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4525: p_commit => OKE_API.G_FALSE ,

Line 4522: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');

4518: --(nvl(l_version, 0) <> 0 or p_allocation_in_rec.amount <> 0) THEN
4519:
4520: IF l_diff_amount<>0 THEN
4521: --dbms_output.put_line('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4522: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4523:
4524: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4525: p_commit => OKE_API.G_FALSE ,
4526: p_init_msg_list => OKE_API.G_FALSE ,

Line 4585: --dbms_output.put_line('calling pa_agreement_pub.update_funding from oke_agreement_pvt');

4581: p_project_funding => l_project_funding
4582: );
4583:
4584:
4585: --dbms_output.put_line('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4586: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4587:
4588: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4589: p_commit => OKE_API.G_FALSE ,

Line 4586: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');

4582: );
4583:
4584:
4585: --dbms_output.put_line('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4586: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4587:
4588: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4589: p_commit => OKE_API.G_FALSE ,
4590: p_init_msg_list => OKE_API.G_FALSE ,

Line 4714: --dbms_output.put_line('finished oke_agreement_pvt.update_funding w/ ' || p_return_status);

4710: = p_allocation_in_rec.fund_allocation_id || '.';
4711:
4712: -- END LOOP;
4713:
4714: --dbms_output.put_line('finished oke_agreement_pvt.update_funding w/ ' || p_return_status);
4715: --oke_debug.debug('finished oke_agreement_pvt.update_funding w/ ' || p_return_status);
4716:
4717: IF FND_API.to_boolean(p_commit) THEN
4718:

Line 4715: --oke_debug.debug('finished oke_agreement_pvt.update_funding w/ ' || p_return_status);

4711:
4712: -- END LOOP;
4713:
4714: --dbms_output.put_line('finished oke_agreement_pvt.update_funding w/ ' || p_return_status);
4715: --oke_debug.debug('finished oke_agreement_pvt.update_funding w/ ' || p_return_status);
4716:
4717: IF FND_API.to_boolean(p_commit) THEN
4718:
4719: COMMIT WORK;

Line 4789: --dbms_output.put_line('entering oke_agreement_pvt.add_pa_funding');

4785: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
4786:
4787: BEGIN
4788:
4789: --dbms_output.put_line('entering oke_agreement_pvt.add_pa_funding');
4790: --oke_debug.debug('entering oke_agreement_pvt.add_pa_funding');
4791:
4792: p_return_status := OKE_API.G_RET_STS_SUCCESS;
4793:

Line 4790: --oke_debug.debug('entering oke_agreement_pvt.add_pa_funding');

4786:
4787: BEGIN
4788:
4789: --dbms_output.put_line('entering oke_agreement_pvt.add_pa_funding');
4790: --oke_debug.debug('entering oke_agreement_pvt.add_pa_funding');
4791:
4792: p_return_status := OKE_API.G_RET_STS_SUCCESS;
4793:
4794: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

Line 4965: --dbms_output.put_line('finished oke_agreement_pvt.add_pa_funding w/ ' || p_return_status);

4961: COMMIT WORK;
4962:
4963: END IF;
4964:
4965: --dbms_output.put_line('finished oke_agreement_pvt.add_pa_funding w/ ' || p_return_status);
4966: --oke_debug.debug('finished oke_agreement_pvt.add_pa_funding w/ ' || p_return_status);
4967:
4968: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
4969: x_msg_data => p_msg_data

Line 4966: --oke_debug.debug('finished oke_agreement_pvt.add_pa_funding w/ ' || p_return_status);

4962:
4963: END IF;
4964:
4965: --dbms_output.put_line('finished oke_agreement_pvt.add_pa_funding w/ ' || p_return_status);
4966: --oke_debug.debug('finished oke_agreement_pvt.add_pa_funding w/ ' || p_return_status);
4967:
4968: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
4969: x_msg_data => p_msg_data
4970: );

Line 5001: end OKE_AGREEMENT_PVT;

4997: p_api_type => '_PVT'
4998: );
4999: END add_pa_funding;
5000:
5001: end OKE_AGREEMENT_PVT;