APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_PLAN_REVENUE

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

2673: l_rt_res_format_id_tab.delete;
2674:
2675: -- 0. Execute SQLs (FCST_RATE_PA, FCST_RATE_GL, FCST_RATE_NONE cursors) to
2676: -- determine the qty and rate API parameters per period
2677: -- 1. Get PA_PLAN_REVENUE.GET_PLANNING_RATES API IN parameter values
2678:
2679: IF p_FP_COLS_REC.X_TIME_PHASED_CODE = 'P' THEN
2680: OPEN FCST_RATE_PA(l_proj_assgn_id_tab(j),p_actuals_thru_date,l_proj_exp_organization_id_tab(j), l_org_id);
2681: FETCH FCST_RATE_PA BULK COLLECT INTO

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

2773: CLOSE FCST_RATE_NONE;
2774:
2775: END IF;
2776:
2777: -- 2. Call PA_PLAN_REVENUE.GET_PLANNING_RATES API based on periodic data
2778: -- in PA/GL periods. Need to also pass in billability flag. (Project
2779: -- assignments with different bill rate override currency are mapped
2780: -- to different budget lines.)
2781: FOR k in 1..l_rt_start_date_tab.COUNT LOOP

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

2815: IF p_pa_debug_mode = 'Y' THEN
2816:
2817: pa_fp_gen_amount_utils.fp_debug
2818: (p_called_mode => p_called_mode,
2819: p_msg => 'BEFORE calling pa_plan_revenue.Get_planning_Rates',
2820: p_module_name => l_module_name,
2821: p_log_level => 5);
2822: pa_fp_gen_amount_utils.fp_debug
2823: (p_called_mode => p_called_mode,

Line 2847: pa_plan_revenue.Get_planning_Rates

2843:
2844: -- Bug 4548733: Uncommented the p_billability_flag input parameter,
2845: -- passing it l_proj_billable_flag(j) as the value.
2846:
2847: pa_plan_revenue.Get_planning_Rates
2848: (
2849: p_project_id => p_project_id
2850: ,p_task_id => 0
2851: ,p_top_task_id => NULL

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

7097:
7098: FOR i IN 1..l_res_asg_id_tab.count LOOP
7099: IF p_pa_debug_mode = 'Y' THEN
7100: pa_fp_gen_amount_utils.fp_debug
7101: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',
7102: p_module_name => l_module_name,
7103: p_log_level => 5);
7104: END IF;
7105: PA_PLAN_REVENUE.GET_PLANNING_RATES(

Line 7105: PA_PLAN_REVENUE.GET_PLANNING_RATES(

7101: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',
7102: p_module_name => l_module_name,
7103: p_log_level => 5);
7104: END IF;
7105: PA_PLAN_REVENUE.GET_PLANNING_RATES(
7106: p_project_id => p_project_id,
7107: p_task_id => l_task_id_tab(i),
7108: p_top_task_id => l_top_task_id_tab(i),
7109: p_person_id => l_person_id_tab(i),

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

7180: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7181: END IF;
7182: IF p_pa_debug_mode = 'Y' THEN
7183: pa_fp_gen_amount_utils.fp_debug
7184: (p_msg => 'Status after calling pa_plan_revenue.Get_planning_Rates'
7185: ||x_return_status,
7186: p_module_name => l_module_name,
7187: p_log_level => 5);
7188: END IF;

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

7641:
7642: FOR i IN 1..l_res_asg_id_tab.count LOOP
7643: IF p_pa_debug_mode = 'Y' THEN
7644: pa_fp_gen_amount_utils.fp_debug
7645: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',
7646: p_module_name => l_module_name,
7647: p_log_level => 5);
7648: END IF;
7649: PA_PLAN_REVENUE.GET_PLANNING_RATES(

Line 7649: PA_PLAN_REVENUE.GET_PLANNING_RATES(

7645: (p_msg => 'Before calling pa_plan_revenue.Get_planning_Rates',
7646: p_module_name => l_module_name,
7647: p_log_level => 5);
7648: END IF;
7649: PA_PLAN_REVENUE.GET_PLANNING_RATES(
7650: p_project_id => p_project_id,
7651: p_task_id => l_task_id_tab(i),
7652: p_top_task_id => l_top_task_id_tab(i),
7653: p_person_id => l_person_id_tab(i),

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

7724: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7725: END IF;
7726: IF p_pa_debug_mode = 'Y' THEN
7727: pa_fp_gen_amount_utils.fp_debug
7728: (p_msg => 'Status after calling pa_plan_revenue.Get_planning_Rates'
7729: ||x_return_status,
7730: p_module_name => l_module_name,
7731: p_log_level => 5);
7732: END IF;