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.OKE_AGREEMENT_PVT dependencies on OKE_FUNDING_UTIL_PKG

Line 281: p_agreement_in_rec.owned_by_person_id := OKE_FUNDING_UTIL_PKG.get_owned_by(L_USER_ID) ;

277: p_agreement_in_rec.revenue_limit_flag := l_revenue_hard_limit ;
278: p_agreement_in_rec.invoice_limit_flag := l_hard_limit ;
279: p_agreement_in_rec.expiration_date := p_funding_in_rec.end_date_active ;
280: p_agreement_in_rec.description := G_DESCRIPTION ;
281: p_agreement_in_rec.owned_by_person_id := OKE_FUNDING_UTIL_PKG.get_owned_by(L_USER_ID) ;
282: p_agreement_in_rec.term_id := l_term_id ;
283: p_agreement_in_rec.template_flag := 'N' ;
284: p_agreement_in_rec.attribute_category := p_funding_in_rec.pa_attribute_category ;
285: p_agreement_in_rec.attribute1 := p_funding_in_rec.pa_attribute1 ;

Line 587: OKE_FUNDING_UTIL_PKG.multi_customer(x_project_id => p_project_id ,

583:
584: IF (p_task_id is not null) OR
585: (p_task_id <> OKE_API.G_MISS_NUM) THEN
586:
587: OKE_FUNDING_UTIL_PKG.multi_customer(x_project_id => p_project_id ,
588: x_project_number => l_project_number,
589: x_count => l_count
590: );
591:

Line 867: OKE_FUNDING_UTIL_PKG.get_calculate_amount(x_conversion_type => l_allocation.pa_conversion_type ,

863: get_min_unit(p_min_unit => l_min_unit ,
864: p_agreement_currency => l_ou.agreement_currency_code
865: );
866:
867: OKE_FUNDING_UTIL_PKG.get_calculate_amount(x_conversion_type => l_allocation.pa_conversion_type ,
868: x_conversion_date => l_allocation.pa_conversion_date ,
869: x_conversion_rate => l_allocation.pa_conversion_rate ,
870: x_org_amount => p_allocation_in_rec.amount ,
871: x_min_unit => l_min_unit ,

Line 2369: -- OKE_FUNDING_UTIL_PKG.funding_mode

2365: -- Description: This procedure is used to create pa agreement
2366: --
2367: -- Calling subprograms: OKE_API.start_activity
2368: -- OKE_API.end_activity
2369: -- OKE_FUNDING_UTIL_PKG.funding_mode
2370: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
2371: -- OKE_FUNDING_UTIL_PKG.update_source_flag
2372: -- PA_AGREEMENT_PUB.create_agreement
2373: -- add_pa_funding

Line 2370: -- OKE_FUNDING_UTIL_PKG.get_converted_amount

2366: --
2367: -- Calling subprograms: OKE_API.start_activity
2368: -- OKE_API.end_activity
2369: -- OKE_FUNDING_UTIL_PKG.funding_mode
2370: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
2371: -- OKE_FUNDING_UTIL_PKG.update_source_flag
2372: -- PA_AGREEMENT_PUB.create_agreement
2373: -- add_pa_funding
2374: -- validate_agreement_attributes

Line 2371: -- OKE_FUNDING_UTIL_PKG.update_source_flag

2367: -- Calling subprograms: OKE_API.start_activity
2368: -- OKE_API.end_activity
2369: -- OKE_FUNDING_UTIL_PKG.funding_mode
2370: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
2371: -- OKE_FUNDING_UTIL_PKG.update_source_flag
2372: -- PA_AGREEMENT_PUB.create_agreement
2373: -- add_pa_funding
2374: -- validate_agreement_attributes
2375: -- check_project_null

Line 2491: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;

2487: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2488: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2489: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
2490: --l_allocation c_allocation%ROWTYPE;
2491: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
2492: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
2493: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
2494: l_agreement_tbl AGREEMENT_TBL_TYPE;
2495: l_agreement_length NUMBER := 0;

Line 2492: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;

2488: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2489: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
2490: --l_allocation c_allocation%ROWTYPE;
2491: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
2492: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
2493: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
2494: l_agreement_tbl AGREEMENT_TBL_TYPE;
2495: l_agreement_length NUMBER := 0;
2496:

Line 2493: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;

2489: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
2490: --l_allocation c_allocation%ROWTYPE;
2491: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
2492: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
2493: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
2494: l_agreement_tbl AGREEMENT_TBL_TYPE;
2495: l_agreement_length NUMBER := 0;
2496:
2497: BEGIN

Line 2570: OKE_FUNDING_UTIL_PKG.get_converted_amount(x_funding_source_id => l_funding_in_rec.funding_source_id ,

2566: FOR l_allocation IN c_allocation(l_ou.org_id) LOOP
2567:
2568: IF (l_allocation.projfunc_currency_code <> l_funding_in_rec.currency_code) THEN
2569:
2570: OKE_FUNDING_UTIL_PKG.get_converted_amount(x_funding_source_id => l_funding_in_rec.funding_source_id ,
2571: x_project_id => l_allocation.project_id ,
2572: x_project_number => l_allocation.project_number ,
2573: x_amount => l_allocation.amount ,
2574: x_conversion_type => l_allocation.pa_conversion_type ,

Line 2634: OKE_FUNDING_UTIL_PKG.get_converted_amount(x_funding_source_id => l_funding_in_rec.funding_source_id ,

2630:
2631: IF (l_allocation.multi_currency_billing_flag = 'N') AND
2632: (l_allocation.projfunc_currency_code <> l_funding_in_rec.currency_code) THEN
2633:
2634: OKE_FUNDING_UTIL_PKG.get_converted_amount(x_funding_source_id => l_funding_in_rec.funding_source_id ,
2635: x_project_id => l_allocation.project_id ,
2636: x_project_number => l_allocation.project_number ,
2637: x_amount => l_allocation.amount ,
2638: x_conversion_type => l_allocation.pa_conversion_type ,

Line 2738: OKE_FUNDING_UTIL_PKG.funding_mode(x_proj_sum_tbl => l_proj_sum_tbl ,

2734:
2735: --oke_debug.debug('calling oke_funding_util.funding_mode');
2736: --dbms_output.put_line('calling oke_funding_util.funding_mode');
2737:
2738: OKE_FUNDING_UTIL_PKG.funding_mode(x_proj_sum_tbl => l_proj_sum_tbl ,
2739: x_task_sum_tbl => l_task_sum_tbl ,
2740: x_funding_level_tbl => l_funding_level_tbl ,
2741: x_project_err => l_err_project_number ,
2742: x_return_status => l_return_status

Line 3041: OKE_FUNDING_UTIL_PKG.update_source_flag(x_funding_source_id => p_funding_in_rec.funding_source_id ,

3037:
3038: --dbms_output.put_line('calling oke_funding_util.update_source_flag');
3039: --oke_debug.debug('calling oke_funding_util.update_source_flag');
3040:
3041: OKE_FUNDING_UTIL_PKG.update_source_flag(x_funding_source_id => p_funding_in_rec.funding_source_id ,
3042: x_commit => OKE_API.G_FALSE
3043: );
3044:
3045: IF FND_API.to_boolean(p_commit) THEN

Line 3320: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;

3316: -- l_orig_agreement_tbl AGREEMENT_TBL_TYPE;
3317: -- l_allocation_in_tbl OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE;
3318: -- l_rate NUMBER;
3319: l_project_number VARCHAR2(25);
3320: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
3321: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
3322: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
3323: -- l_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3324: --l_orig_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;

Line 3321: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;

3317: -- l_allocation_in_tbl OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE;
3318: -- l_rate NUMBER;
3319: l_project_number VARCHAR2(25);
3320: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
3321: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
3322: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
3323: -- l_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3324: --l_orig_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3325: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;

Line 3322: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;

3318: -- l_rate NUMBER;
3319: l_project_number VARCHAR2(25);
3320: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
3321: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
3322: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
3323: -- l_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3324: --l_orig_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3325: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
3326: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

Line 3426: OKE_FUNDING_UTIL_PKG.funding_mode(x_proj_sum_tbl => l_proj_sum_tbl ,

3422:
3423: --oke_debug.debug('calling oke_funding_util.funding_mode');
3424: --dbms_output.put_line('calling oke_funding_util.funding_mode');
3425:
3426: OKE_FUNDING_UTIL_PKG.funding_mode(x_proj_sum_tbl => l_proj_sum_tbl ,
3427: x_task_sum_tbl => l_task_sum_tbl ,
3428: x_funding_level_tbl => l_funding_level_tbl ,
3429: x_project_err => l_err_project_number ,
3430: x_return_status => l_return_status

Line 4304: -- OKE_FUNDING_UTIL_PKG.get_converted_amount

4300: -- Calling subprograms: OKE_API.start_activity
4301: -- OKE_API.end_activity
4302: -- PA_AGREEMENT_PUB.update_funding
4303: -- PA_AGREEMENT_PUB.add_funding
4304: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
4305: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
4306: -- validate_line_attributes
4307: -- pa_update_or_add
4308: -- get_proj_funding

Line 4305: -- OKE_FUNDING_UTIL_PKG.update_alloc_version

4301: -- OKE_API.end_activity
4302: -- PA_AGREEMENT_PUB.update_funding
4303: -- PA_AGREEMENT_PUB.add_funding
4304: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
4305: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
4306: -- validate_line_attributes
4307: -- pa_update_or_add
4308: -- get_proj_funding
4309: --

Line 4456: OKE_FUNDING_UTIL_PKG.get_converted_amount(x_funding_source_id => p_allocation_in_rec.funding_source_id ,

4452: -- IF (l_convert_flag = 'Y') THEN
4453:
4454: IF (l_agreement_currency <> l_source_currency) THEN
4455:
4456: OKE_FUNDING_UTIL_PKG.get_converted_amount(x_funding_source_id => p_allocation_in_rec.funding_source_id ,
4457: x_project_id => p_allocation_in_rec.project_id ,
4458: x_project_number => l_allocation.project_number ,
4459: x_amount => p_allocation_in_rec.amount ,
4460: x_conversion_type => l_allocation.pa_conversion_type ,

Line 4592: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,

4588:
4589: --dbms_output.put_line('calling oke_funding_util.update_alloc_version');
4590: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4591:
4592: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,
4593: x_version_add => 1 ,
4594: x_commit => OKE_API.G_FALSE
4595: );
4596: END IF;

Line 4656: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,

4652:
4653: --dbms_output.put_line('calling oke_funding_util.update_alloc_version');
4654: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4655:
4656: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,
4657: x_version_add => 0 ,
4658: x_commit => OKE_API.G_FALSE
4659: );
4660:

Line 4979: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,

4975:
4976: --dbms_output.put_line('calling oke_funding_util.update_alloc_version');
4977: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4978:
4979: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,
4980: x_version_add => 1 ,
4981: x_commit => OKE_API.G_FALSE
4982: );
4983: