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.

[Home] [Help]

APPS.OKE_AGREEMENT_PVT dependencies on OKE_FUNDING_UTIL_PKG

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

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

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

568:
569: IF (p_task_id is not null) OR
570: (p_task_id <> OKE_API.G_MISS_NUM) THEN
571:
572: OKE_FUNDING_UTIL_PKG.multi_customer(x_project_id => p_project_id ,
573: x_project_number => l_project_number,
574: x_count => l_count
575: );
576:

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

848: get_min_unit(p_min_unit => l_min_unit ,
849: p_agreement_currency => l_ou.agreement_currency_code
850: );
851:
852: OKE_FUNDING_UTIL_PKG.get_calculate_amount(x_conversion_type => l_allocation.pa_conversion_type ,
853: x_conversion_date => l_allocation.pa_conversion_date ,
854: x_conversion_rate => l_allocation.pa_conversion_rate ,
855: x_org_amount => p_allocation_in_rec.amount ,
856: x_min_unit => l_min_unit ,

Line 2354: -- OKE_FUNDING_UTIL_PKG.funding_mode

2350: -- Description: This procedure is used to create pa agreement
2351: --
2352: -- Calling subprograms: OKE_API.start_activity
2353: -- OKE_API.end_activity
2354: -- OKE_FUNDING_UTIL_PKG.funding_mode
2355: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
2356: -- OKE_FUNDING_UTIL_PKG.update_source_flag
2357: -- PA_AGREEMENT_PUB.create_agreement
2358: -- add_pa_funding

Line 2355: -- OKE_FUNDING_UTIL_PKG.get_converted_amount

2351: --
2352: -- Calling subprograms: OKE_API.start_activity
2353: -- OKE_API.end_activity
2354: -- OKE_FUNDING_UTIL_PKG.funding_mode
2355: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
2356: -- OKE_FUNDING_UTIL_PKG.update_source_flag
2357: -- PA_AGREEMENT_PUB.create_agreement
2358: -- add_pa_funding
2359: -- validate_agreement_attributes

Line 2356: -- OKE_FUNDING_UTIL_PKG.update_source_flag

2352: -- Calling subprograms: OKE_API.start_activity
2353: -- OKE_API.end_activity
2354: -- OKE_FUNDING_UTIL_PKG.funding_mode
2355: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
2356: -- OKE_FUNDING_UTIL_PKG.update_source_flag
2357: -- PA_AGREEMENT_PUB.create_agreement
2358: -- add_pa_funding
2359: -- validate_agreement_attributes
2360: -- check_project_null

Line 2475: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;

2471: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2472: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2473: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
2474: --l_allocation c_allocation%ROWTYPE;
2475: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
2476: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
2477: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
2478: l_agreement_tbl AGREEMENT_TBL_TYPE;
2479: l_agreement_length NUMBER := 0;

Line 2476: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;

2472: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2473: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
2474: --l_allocation c_allocation%ROWTYPE;
2475: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
2476: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
2477: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
2478: l_agreement_tbl AGREEMENT_TBL_TYPE;
2479: l_agreement_length NUMBER := 0;
2480:

Line 2477: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;

2473: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
2474: --l_allocation c_allocation%ROWTYPE;
2475: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
2476: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
2477: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
2478: l_agreement_tbl AGREEMENT_TBL_TYPE;
2479: l_agreement_length NUMBER := 0;
2480:
2481: BEGIN

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

2550: FOR l_allocation IN c_allocation(l_ou.org_id) LOOP
2551:
2552: IF (l_allocation.projfunc_currency_code <> l_funding_in_rec.currency_code) THEN
2553:
2554: OKE_FUNDING_UTIL_PKG.get_converted_amount(x_funding_source_id => l_funding_in_rec.funding_source_id ,
2555: x_project_id => l_allocation.project_id ,
2556: x_project_number => l_allocation.project_number ,
2557: x_amount => l_allocation.amount ,
2558: x_conversion_type => l_allocation.pa_conversion_type ,

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

2614:
2615: IF (l_allocation.multi_currency_billing_flag = 'N') AND
2616: (l_allocation.projfunc_currency_code <> l_funding_in_rec.currency_code) THEN
2617:
2618: OKE_FUNDING_UTIL_PKG.get_converted_amount(x_funding_source_id => l_funding_in_rec.funding_source_id ,
2619: x_project_id => l_allocation.project_id ,
2620: x_project_number => l_allocation.project_number ,
2621: x_amount => l_allocation.amount ,
2622: x_conversion_type => l_allocation.pa_conversion_type ,

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

2718:
2719: --oke_debug.debug('calling oke_funding_util.funding_mode');
2720: --dbms_output.put_line('calling oke_funding_util.funding_mode');
2721:
2722: OKE_FUNDING_UTIL_PKG.funding_mode(x_proj_sum_tbl => l_proj_sum_tbl ,
2723: x_task_sum_tbl => l_task_sum_tbl ,
2724: x_funding_level_tbl => l_funding_level_tbl ,
2725: x_project_err => l_err_project_number ,
2726: x_return_status => l_return_status

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

3017:
3018: --dbms_output.put_line('calling oke_funding_util.update_source_flag');
3019: --oke_debug.debug('calling oke_funding_util.update_source_flag');
3020:
3021: OKE_FUNDING_UTIL_PKG.update_source_flag(x_funding_source_id => p_funding_in_rec.funding_source_id ,
3022: x_commit => OKE_API.G_FALSE
3023: );
3024:
3025: IF FND_API.to_boolean(p_commit) THEN

Line 3299: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;

3295: -- l_orig_agreement_tbl AGREEMENT_TBL_TYPE;
3296: -- l_allocation_in_tbl OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE;
3297: -- l_rate NUMBER;
3298: l_project_number VARCHAR2(25);
3299: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
3300: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
3301: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
3302: -- l_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3303: --l_orig_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;

Line 3300: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;

3296: -- l_allocation_in_tbl OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE;
3297: -- l_rate NUMBER;
3298: l_project_number VARCHAR2(25);
3299: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
3300: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
3301: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
3302: -- l_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3303: --l_orig_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3304: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;

Line 3301: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;

3297: -- l_rate NUMBER;
3298: l_project_number VARCHAR2(25);
3299: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
3300: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
3301: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
3302: -- l_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3303: --l_orig_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3304: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
3305: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

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

3401:
3402: --oke_debug.debug('calling oke_funding_util.funding_mode');
3403: --dbms_output.put_line('calling oke_funding_util.funding_mode');
3404:
3405: OKE_FUNDING_UTIL_PKG.funding_mode(x_proj_sum_tbl => l_proj_sum_tbl ,
3406: x_task_sum_tbl => l_task_sum_tbl ,
3407: x_funding_level_tbl => l_funding_level_tbl ,
3408: x_project_err => l_err_project_number ,
3409: x_return_status => l_return_status

Line 4279: -- OKE_FUNDING_UTIL_PKG.get_converted_amount

4275: -- Calling subprograms: OKE_API.start_activity
4276: -- OKE_API.end_activity
4277: -- PA_AGREEMENT_PUB.update_funding
4278: -- PA_AGREEMENT_PUB.add_funding
4279: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
4280: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
4281: -- validate_line_attributes
4282: -- pa_update_or_add
4283: -- get_proj_funding

Line 4280: -- OKE_FUNDING_UTIL_PKG.update_alloc_version

4276: -- OKE_API.end_activity
4277: -- PA_AGREEMENT_PUB.update_funding
4278: -- PA_AGREEMENT_PUB.add_funding
4279: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
4280: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
4281: -- validate_line_attributes
4282: -- pa_update_or_add
4283: -- get_proj_funding
4284: --

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

4427: -- IF (l_convert_flag = 'Y') THEN
4428:
4429: IF (l_agreement_currency <> l_source_currency) THEN
4430:
4431: OKE_FUNDING_UTIL_PKG.get_converted_amount(x_funding_source_id => p_allocation_in_rec.funding_source_id ,
4432: x_project_id => p_allocation_in_rec.project_id ,
4433: x_project_number => l_allocation.project_number ,
4434: x_amount => p_allocation_in_rec.amount ,
4435: x_conversion_type => l_allocation.pa_conversion_type ,

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

4563:
4564: --dbms_output.put_line('calling oke_funding_util.update_alloc_version');
4565: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4566:
4567: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,
4568: x_version_add => 1 ,
4569: x_commit => OKE_API.G_FALSE
4570: );
4571: END IF;

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

4627:
4628: --dbms_output.put_line('calling oke_funding_util.update_alloc_version');
4629: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4630:
4631: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,
4632: x_version_add => 0 ,
4633: x_commit => OKE_API.G_FALSE
4634: );
4635:

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

4950:
4951: --dbms_output.put_line('calling oke_funding_util.update_alloc_version');
4952: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4953:
4954: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,
4955: x_version_add => 1 ,
4956: x_commit => OKE_API.G_FALSE
4957: );
4958: