APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_PLAN_REVENUE

Line 2665: -- 1. Get PA_PLAN_REVENUE.GET_PLANNING_RATES API IN parameter values

2661: l_rt_res_format_id_tab.delete;
2662:
2663: -- 0. Execute SQLs (FCST_RATE_PA, FCST_RATE_GL, FCST_RATE_NONE cursors) to
2664: -- determine the qty and rate API parameters per period
2665: -- 1. Get PA_PLAN_REVENUE.GET_PLANNING_RATES API IN parameter values
2666:
2667: IF p_FP_COLS_REC.X_TIME_PHASED_CODE = 'P' THEN
2668: OPEN FCST_RATE_PA(l_proj_assgn_id_tab(j),p_actuals_thru_date,l_proj_exp_organization_id_tab(j), l_org_id);
2669: FETCH FCST_RATE_PA BULK COLLECT INTO

Line 2765: -- 2. Call PA_PLAN_REVENUE.GET_PLANNING_RATES API based on periodic data

2761: CLOSE FCST_RATE_NONE;
2762:
2763: END IF;
2764:
2765: -- 2. Call PA_PLAN_REVENUE.GET_PLANNING_RATES API based on periodic data
2766: -- in PA/GL periods. Need to also pass in billability flag. (Project
2767: -- assignments with different bill rate override currency are mapped
2768: -- to different budget lines.)
2769: FOR k in 1..l_rt_start_date_tab.COUNT LOOP

Line 2807: p_msg => 'BEFORE calling pa_plan_revenue.Get_planning_Rates',

2803: IF p_pa_debug_mode = 'Y' THEN
2804:
2805: pa_fp_gen_amount_utils.fp_debug
2806: (p_called_mode => p_called_mode,
2807: p_msg => 'BEFORE calling pa_plan_revenue.Get_planning_Rates',
2808: p_module_name => l_module_name,
2809: p_log_level => 5);
2810: pa_fp_gen_amount_utils.fp_debug
2811: (p_called_mode => p_called_mode,

Line 2835: pa_plan_revenue.Get_planning_Rates

2831:
2832: -- Bug 4548733: Uncommented the p_billability_flag input parameter,
2833: -- passing it l_proj_billable_flag(j) as the value.
2834:
2835: pa_plan_revenue.Get_planning_Rates
2836: (
2837: p_project_id => p_project_id
2838: ,p_task_id => 0
2839: ,p_top_task_id => NULL

Line 6444: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',

6440:
6441: FOR i IN 1..l_res_asg_id_tab.count LOOP
6442: IF p_pa_debug_mode = 'Y' THEN
6443: pa_fp_gen_amount_utils.fp_debug
6444: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',
6445: p_module_name => l_module_name,
6446: p_log_level => 5);
6447: END IF;
6448: PA_PLAN_REVENUE.GET_PLANNING_RATES(

Line 6448: PA_PLAN_REVENUE.GET_PLANNING_RATES(

6444: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',
6445: p_module_name => l_module_name,
6446: p_log_level => 5);
6447: END IF;
6448: PA_PLAN_REVENUE.GET_PLANNING_RATES(
6449: p_project_id => p_project_id,
6450: p_task_id => l_task_id_tab(i),
6451: p_top_task_id => l_top_task_id_tab(i),
6452: p_person_id => l_person_id_tab(i),

Line 6527: (p_msg => 'Status after calling pa_plan_revenue.Get_planning_Rates'

6523: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6524: END IF;
6525: IF p_pa_debug_mode = 'Y' THEN
6526: pa_fp_gen_amount_utils.fp_debug
6527: (p_msg => 'Status after calling pa_plan_revenue.Get_planning_Rates'
6528: ||x_return_status,
6529: p_module_name => l_module_name,
6530: p_log_level => 5);
6531: END IF;

Line 6988: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',

6984:
6985: FOR i IN 1..l_res_asg_id_tab.count LOOP
6986: IF p_pa_debug_mode = 'Y' THEN
6987: pa_fp_gen_amount_utils.fp_debug
6988: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',
6989: p_module_name => l_module_name,
6990: p_log_level => 5);
6991: END IF;
6992: PA_PLAN_REVENUE.GET_PLANNING_RATES(

Line 6992: PA_PLAN_REVENUE.GET_PLANNING_RATES(

6988: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',
6989: p_module_name => l_module_name,
6990: p_log_level => 5);
6991: END IF;
6992: PA_PLAN_REVENUE.GET_PLANNING_RATES(
6993: p_project_id => p_project_id,
6994: p_task_id => l_task_id_tab(i),
6995: p_top_task_id => l_top_task_id_tab(i),
6996: p_person_id => l_person_id_tab(i),

Line 7071: (p_msg => 'Status after calling pa_plan_revenue.Get_planning_Rates'

7067: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7068: END IF;
7069: IF p_pa_debug_mode = 'Y' THEN
7070: pa_fp_gen_amount_utils.fp_debug
7071: (p_msg => 'Status after calling pa_plan_revenue.Get_planning_Rates'
7072: ||x_return_status,
7073: p_module_name => l_module_name,
7074: p_log_level => 5);
7075: END IF;