DBA Data[Home] [Help]

APPS.OKE_FUNDSOURCE_PVT dependencies on OKE_FUNDSOURCE_PVT

Line 1: package body OKE_FUNDSOURCE_PVT as

1: package body OKE_FUNDSOURCE_PVT as
2: /* $Header: OKEVKFDB.pls 120.2.12020000.6 2012/12/12 04:58:11 skuchima ship $ */
3:
4: --
5: -- Local Variables

Line 2877: --dbms_output.put_line('entering oke_fundsource_pvt.create_funding');

2873: -- l_conversion_rate NUMBER;
2874:
2875: BEGIN
2876:
2877: --dbms_output.put_line('entering oke_fundsource_pvt.create_funding');
2878: --oke_debug.debug('entering oke_fundsource_pvt.create_funding');
2879:
2880: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2881: p_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;

Line 2878: --oke_debug.debug('entering oke_fundsource_pvt.create_funding');

2874:
2875: BEGIN
2876:
2877: --dbms_output.put_line('entering oke_fundsource_pvt.create_funding');
2878: --oke_debug.debug('entering oke_fundsource_pvt.create_funding');
2879:
2880: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2881: p_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
2882:

Line 2933: -- dbms_output.put_line('calling oke_fundingsource_pvt.insert_row from oke_fundsource_pvt');

2929:
2930: l_funding_in_rec.funding_source_id := get_funding_source_id;
2931: p_funding_out_rec.funding_source_id := l_funding_in_rec.funding_source_id;
2932:
2933: -- dbms_output.put_line('calling oke_fundingsource_pvt.insert_row from oke_fundsource_pvt');
2934: --oke_debug.debug('calling oke_fundingsource_pvt.insert_row from oke_fundsource_pvt');
2935:
2936: OKE_FUNDINGSOURCE_PVT.insert_row(X_Rowid => l_rowid ,
2937: X_Funding_Source_Id => l_funding_in_rec.funding_source_id ,

Line 2934: --oke_debug.debug('calling oke_fundingsource_pvt.insert_row from oke_fundsource_pvt');

2930: l_funding_in_rec.funding_source_id := get_funding_source_id;
2931: p_funding_out_rec.funding_source_id := l_funding_in_rec.funding_source_id;
2932:
2933: -- dbms_output.put_line('calling oke_fundingsource_pvt.insert_row from oke_fundsource_pvt');
2934: --oke_debug.debug('calling oke_fundingsource_pvt.insert_row from oke_fundsource_pvt');
2935:
2936: OKE_FUNDINGSOURCE_PVT.insert_row(X_Rowid => l_rowid ,
2937: X_Funding_Source_Id => l_funding_in_rec.funding_source_id ,
2938: X_Pool_Party_Id => l_funding_in_rec.pool_party_id ,

Line 3013: -- dbms_output.put_line('finished oke_fundsource_pvt.create_funding');

3009: COMMIT WORK;
3010:
3011: END IF;
3012:
3013: -- dbms_output.put_line('finished oke_fundsource_pvt.create_funding');
3014: --oke_debug.debug('finished oke_fundsource_pvt.create_funding');
3015:
3016: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
3017: x_msg_data => p_msg_data

Line 3014: --oke_debug.debug('finished oke_fundsource_pvt.create_funding');

3010:
3011: END IF;
3012:
3013: -- dbms_output.put_line('finished oke_fundsource_pvt.create_funding');
3014: --oke_debug.debug('finished oke_fundsource_pvt.create_funding');
3015:
3016: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
3017: x_msg_data => p_msg_data
3018: );

Line 3091: --dbms_output.put_line('entering oke_fundsource_pvt.update_funding');

3087: l_agreement_flag VARCHAR2(1);
3088:
3089: BEGIN
3090:
3091: --dbms_output.put_line('entering oke_fundsource_pvt.update_funding');
3092: --oke_debug.debug('entering oke_fundsource_pvt.update_funding');
3093:
3094: p_return_status := OKE_API.G_RET_STS_SUCCESS;
3095: p_funding_out_rec.funding_source_id := p_funding_in_rec.funding_source_id;

Line 3092: --oke_debug.debug('entering oke_fundsource_pvt.update_funding');

3088:
3089: BEGIN
3090:
3091: --dbms_output.put_line('entering oke_fundsource_pvt.update_funding');
3092: --oke_debug.debug('entering oke_fundsource_pvt.update_funding');
3093:
3094: p_return_status := OKE_API.G_RET_STS_SUCCESS;
3095: p_funding_out_rec.funding_source_id := p_funding_in_rec.funding_source_id;
3096: p_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;

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

3219: X_Revenue_Hard_Limit => l_funding_in_rec.revenue_hard_limit ,
3220: X_Agreement_Org_id => l_funding_in_rec.agreement_org_id
3221: );
3222:
3223: -- dbms_output.put_line('finished oke_fundsource_pvt.update_funding w/ ' || p_return_status);
3224: --oke_debug.debug('finished oke_fundsource_pvt.update_funding w/ ' || p_return_status);
3225:
3226: IF FND_API.to_boolean(p_commit) THEN
3227:

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

3220: X_Agreement_Org_id => l_funding_in_rec.agreement_org_id
3221: );
3222:
3223: -- dbms_output.put_line('finished oke_fundsource_pvt.update_funding w/ ' || p_return_status);
3224: --oke_debug.debug('finished oke_fundsource_pvt.update_funding w/ ' || p_return_status);
3225:
3226: IF FND_API.to_boolean(p_commit) THEN
3227:
3228: COMMIT WORK;

Line 3310: -- dbms_output.put_line('entering oke_fundsource_pvt.delete_funding');

3306: l_length NUMBER;
3307:
3308: BEGIN
3309:
3310: -- dbms_output.put_line('entering oke_fundsource_pvt.delete_funding');
3311: --oke_debug.debug('entering oke_fundsource_pvt.delete_funding');
3312:
3313: p_return_status := OKE_API.G_RET_STS_SUCCESS;
3314:

Line 3311: --oke_debug.debug('entering oke_fundsource_pvt.delete_funding');

3307:
3308: BEGIN
3309:
3310: -- dbms_output.put_line('entering oke_fundsource_pvt.delete_funding');
3311: --oke_debug.debug('entering oke_fundsource_pvt.delete_funding');
3312:
3313: p_return_status := OKE_API.G_RET_STS_SUCCESS;
3314:
3315: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

Line 3370: -- dbms_output.put_line('calling pa_agreement_pub.delete_agreement from oke_fundsource_pvt');

3366: --dbms_output.put_line('pm_agreement_reference '|| l_agreement.pm_agreement_reference);
3367:
3368: fnd_client_info.set_org_context(l_agreement.org_id);
3369:
3370: -- dbms_output.put_line('calling pa_agreement_pub.delete_agreement from oke_fundsource_pvt');
3371: --oke_debug.debug('calling pa_agreement_pub.delete_agreement from oke_fundsource_pvt');
3372:
3373: PA_AGREEMENT_PUB.delete_agreement(p_api_version_number => p_api_version ,
3374: p_commit => OKE_API.G_FALSE ,

Line 3371: --oke_debug.debug('calling pa_agreement_pub.delete_agreement from oke_fundsource_pvt');

3367:
3368: fnd_client_info.set_org_context(l_agreement.org_id);
3369:
3370: -- dbms_output.put_line('calling pa_agreement_pub.delete_agreement from oke_fundsource_pvt');
3371: --oke_debug.debug('calling pa_agreement_pub.delete_agreement from oke_fundsource_pvt');
3372:
3373: PA_AGREEMENT_PUB.delete_agreement(p_api_version_number => p_api_version ,
3374: p_commit => OKE_API.G_FALSE ,
3375: p_init_msg_list => OKE_API.G_FALSE ,

Line 3398: --dbms_output.put_line('finished oke_fundsource_pvt.delete_funding w/ ' || p_return_status);

3394: END LOOP;
3395:
3396: END IF;
3397:
3398: --dbms_output.put_line('finished oke_fundsource_pvt.delete_funding w/ ' || p_return_status);
3399: --oke_debug.debug('finished oke_fundsource_pvt.delete_funding w/ ' || p_return_status);
3400:
3401: IF FND_API.to_boolean(p_commit) THEN
3402:

Line 3399: --oke_debug.debug('finished oke_fundsource_pvt.delete_funding w/ ' || p_return_status);

3395:
3396: END IF;
3397:
3398: --dbms_output.put_line('finished oke_fundsource_pvt.delete_funding w/ ' || p_return_status);
3399: --oke_debug.debug('finished oke_fundsource_pvt.delete_funding w/ ' || p_return_status);
3400:
3401: IF FND_API.to_boolean(p_commit) THEN
3402:
3403: COMMIT WORK;

Line 3451: -- OKE_FUNDSOURCE_PVT.create_funding

3447: -- and create a funding record in OKE
3448: --
3449: -- Calling subprograms: OKE_API.start_activity
3450: -- OKE_API.end_activity
3451: -- OKE_FUNDSOURCE_PVT.create_funding
3452: -- OKE_ALLOCATION_PVT.add_allocation
3453: -- OKE_FUNDING_UTIL_PKG.check_single_org
3454: -- OKE_FUNDING_UTIL_PKG.update_source_flag
3455: -- OKE_FUNDING_UTIL_PKG.update_alloc_version

Line 4129: -- OKE_FUNDSOURCE_PVT.create_funding

4125: -- and create a funding record in OKE
4126: --
4127: -- Calling subprograms: OKE_API.start_activity
4128: -- OKE_API.end_activity
4129: -- OKE_FUNDSOURCE_PVT.create_funding
4130: -- OKE_ALLOCATION_PVT.add_allocation
4131: -- OKE_FUNDING_UTIL_PKG.check_single_org
4132: -- OKE_FUNDING_UTIL_PKG.update_source_flag
4133: -- OKE_FUNDING_UTIL_PKG.update_alloc_version

Line 4952: end OKE_FUNDSOURCE_PVT;

4948: return funding_in_rec;
4949:
4950: END get_funding_rec;
4951:
4952: end OKE_FUNDSOURCE_PVT;