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 2005/11/23 14:37:58 ausmani noship $ */
3:
4: --
5: -- Local Variables

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

2739: -- l_conversion_rate NUMBER;
2740:
2741: BEGIN
2742:
2743: --dbms_output.put_line('entering oke_fundsource_pvt.create_funding');
2744: --oke_debug.debug('entering oke_fundsource_pvt.create_funding');
2745:
2746: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2747: p_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;

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

2740:
2741: BEGIN
2742:
2743: --dbms_output.put_line('entering oke_fundsource_pvt.create_funding');
2744: --oke_debug.debug('entering oke_fundsource_pvt.create_funding');
2745:
2746: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2747: p_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
2748:

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

2795:
2796: l_funding_in_rec.funding_source_id := get_funding_source_id;
2797: p_funding_out_rec.funding_source_id := l_funding_in_rec.funding_source_id;
2798:
2799: -- dbms_output.put_line('calling oke_fundingsource_pvt.insert_row from oke_fundsource_pvt');
2800: --oke_debug.debug('calling oke_fundingsource_pvt.insert_row from oke_fundsource_pvt');
2801:
2802: OKE_FUNDINGSOURCE_PVT.insert_row(X_Rowid => l_rowid ,
2803: X_Funding_Source_Id => l_funding_in_rec.funding_source_id ,

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

2796: l_funding_in_rec.funding_source_id := get_funding_source_id;
2797: p_funding_out_rec.funding_source_id := l_funding_in_rec.funding_source_id;
2798:
2799: -- dbms_output.put_line('calling oke_fundingsource_pvt.insert_row from oke_fundsource_pvt');
2800: --oke_debug.debug('calling oke_fundingsource_pvt.insert_row from oke_fundsource_pvt');
2801:
2802: OKE_FUNDINGSOURCE_PVT.insert_row(X_Rowid => l_rowid ,
2803: X_Funding_Source_Id => l_funding_in_rec.funding_source_id ,
2804: X_Pool_Party_Id => l_funding_in_rec.pool_party_id ,

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

2860: COMMIT WORK;
2861:
2862: END IF;
2863:
2864: -- dbms_output.put_line('finished oke_fundsource_pvt.create_funding');
2865: --oke_debug.debug('finished oke_fundsource_pvt.create_funding');
2866:
2867: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
2868: x_msg_data => p_msg_data

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

2861:
2862: END IF;
2863:
2864: -- dbms_output.put_line('finished oke_fundsource_pvt.create_funding');
2865: --oke_debug.debug('finished oke_fundsource_pvt.create_funding');
2866:
2867: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
2868: x_msg_data => p_msg_data
2869: );

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

2938: l_agreement_flag VARCHAR2(1);
2939:
2940: BEGIN
2941:
2942: --dbms_output.put_line('entering oke_fundsource_pvt.update_funding');
2943: --oke_debug.debug('entering oke_fundsource_pvt.update_funding');
2944:
2945: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2946: p_funding_out_rec.funding_source_id := p_funding_in_rec.funding_source_id;

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

2939:
2940: BEGIN
2941:
2942: --dbms_output.put_line('entering oke_fundsource_pvt.update_funding');
2943: --oke_debug.debug('entering oke_fundsource_pvt.update_funding');
2944:
2945: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2946: p_funding_out_rec.funding_source_id := p_funding_in_rec.funding_source_id;
2947: p_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;

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

3055: X_Revenue_Hard_Limit => l_funding_in_rec.revenue_hard_limit ,
3056: X_Agreement_Org_id => l_funding_in_rec.agreement_org_id
3057: );
3058:
3059: -- dbms_output.put_line('finished oke_fundsource_pvt.update_funding w/ ' || p_return_status);
3060: --oke_debug.debug('finished oke_fundsource_pvt.update_funding w/ ' || p_return_status);
3061:
3062: IF FND_API.to_boolean(p_commit) THEN
3063:

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

3056: X_Agreement_Org_id => l_funding_in_rec.agreement_org_id
3057: );
3058:
3059: -- dbms_output.put_line('finished oke_fundsource_pvt.update_funding w/ ' || p_return_status);
3060: --oke_debug.debug('finished oke_fundsource_pvt.update_funding w/ ' || p_return_status);
3061:
3062: IF FND_API.to_boolean(p_commit) THEN
3063:
3064: COMMIT WORK;

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

3142: l_length NUMBER;
3143:
3144: BEGIN
3145:
3146: -- dbms_output.put_line('entering oke_fundsource_pvt.delete_funding');
3147: --oke_debug.debug('entering oke_fundsource_pvt.delete_funding');
3148:
3149: p_return_status := OKE_API.G_RET_STS_SUCCESS;
3150:

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

3143:
3144: BEGIN
3145:
3146: -- dbms_output.put_line('entering oke_fundsource_pvt.delete_funding');
3147: --oke_debug.debug('entering oke_fundsource_pvt.delete_funding');
3148:
3149: p_return_status := OKE_API.G_RET_STS_SUCCESS;
3150:
3151: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

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

3202: --dbms_output.put_line('pm_agreement_reference '|| l_agreement.pm_agreement_reference);
3203:
3204: fnd_client_info.set_org_context(l_agreement.org_id);
3205:
3206: -- dbms_output.put_line('calling pa_agreement_pub.delete_agreement from oke_fundsource_pvt');
3207: --oke_debug.debug('calling pa_agreement_pub.delete_agreement from oke_fundsource_pvt');
3208:
3209: PA_AGREEMENT_PUB.delete_agreement(p_api_version_number => p_api_version ,
3210: p_commit => OKE_API.G_FALSE ,

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

3203:
3204: fnd_client_info.set_org_context(l_agreement.org_id);
3205:
3206: -- dbms_output.put_line('calling pa_agreement_pub.delete_agreement from oke_fundsource_pvt');
3207: --oke_debug.debug('calling pa_agreement_pub.delete_agreement from oke_fundsource_pvt');
3208:
3209: PA_AGREEMENT_PUB.delete_agreement(p_api_version_number => p_api_version ,
3210: p_commit => OKE_API.G_FALSE ,
3211: p_init_msg_list => OKE_API.G_FALSE ,

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

3230: END LOOP;
3231:
3232: END IF;
3233:
3234: --dbms_output.put_line('finished oke_fundsource_pvt.delete_funding w/ ' || p_return_status);
3235: --oke_debug.debug('finished oke_fundsource_pvt.delete_funding w/ ' || p_return_status);
3236:
3237: IF FND_API.to_boolean(p_commit) THEN
3238:

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

3231:
3232: END IF;
3233:
3234: --dbms_output.put_line('finished oke_fundsource_pvt.delete_funding w/ ' || p_return_status);
3235: --oke_debug.debug('finished oke_fundsource_pvt.delete_funding w/ ' || p_return_status);
3236:
3237: IF FND_API.to_boolean(p_commit) THEN
3238:
3239: COMMIT WORK;

Line 3287: -- OKE_FUNDSOURCE_PVT.create_funding

3283: -- and create a funding record in OKE
3284: --
3285: -- Calling subprograms: OKE_API.start_activity
3286: -- OKE_API.end_activity
3287: -- OKE_FUNDSOURCE_PVT.create_funding
3288: -- OKE_ALLOCATION_PVT.add_allocation
3289: -- OKE_FUNDING_UTIL_PKG.check_single_org
3290: -- OKE_FUNDING_UTIL_PKG.update_source_flag
3291: -- OKE_FUNDING_UTIL_PKG.update_alloc_version

Line 3932: -- OKE_FUNDSOURCE_PVT.create_funding

3928: -- and create a funding record in OKE
3929: --
3930: -- Calling subprograms: OKE_API.start_activity
3931: -- OKE_API.end_activity
3932: -- OKE_FUNDSOURCE_PVT.create_funding
3933: -- OKE_ALLOCATION_PVT.add_allocation
3934: -- OKE_FUNDING_UTIL_PKG.check_single_org
3935: -- OKE_FUNDING_UTIL_PKG.update_source_flag
3936: -- OKE_FUNDING_UTIL_PKG.update_alloc_version

Line 4738: end OKE_FUNDSOURCE_PVT;

4734: return funding_in_rec;
4735:
4736: END get_funding_rec;
4737:
4738: end OKE_FUNDSOURCE_PVT;