[Home] [Help]
19: -- 12-FEB-03 vejayara Bug 2796261-Source_Txn_currency_code in
20: -- pa_fin_plan_lines_tmp was not populated.
21: -- Now it is populated.
22: -- 02-JUN-03 msoundra replaced the call to
23: -- API pa_fp_org_fcst_utils.get_utilization_details
24: -- with pa_pji_util_pkg.get_utilization_dtls to get the numbers from
25: -- PJI data model if PJI is installed.
26: -- 21-AUG-03 dbora Bug 3106741 Performance related changes
27: -- 25-AUG-08 bifernan Bug 7309811 Use byte equivalent versions of
661: l_stage := 100;
662: -- hr_utility.trace(to_char(l_stage));
663:
664: -- get information from pa_forecast_options_all
665: pa_fp_org_fcst_utils.get_forecast_option_details
666: ( x_fcst_period_type => l_org_fcst_period_type
667: ,x_period_set_name => l_period_set_name
668: ,x_act_period_type => l_act_period_type
669: ,x_org_projfunc_currency_code => l_org_projfunc_currency_code
1030: /* Get Project information if the project exists else create the
1031: project by copying the template as per forecasting options
1032: and then get the project info */
1033:
1034: pa_fp_org_fcst_utils.get_org_project_info
1035: ( p_organization_id => l_organization_id
1036: ,x_org_project_id => l_project_id
1037: ,x_return_status => l_return_status
1038: ,x_err_code => l_err_code);
1067: IF P_PA_DEBUG_MODE = 'Y' THEN
1068: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1069: END IF;
1070:
1071: pa_fp_org_fcst_utils.get_org_task_info
1072: ( p_project_id => l_project_id
1073: ,x_organization_id => l_task_organization_id
1074: ,x_org_task_id => l_own_task_id
1075: ,x_return_status => l_return_status
1224: pa_debug.g_err_stage := l_stage||': Get Org Task Info';
1225: IF P_PA_DEBUG_MODE = 'Y' THEN
1226: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1227: END IF;
1228: pa_fp_org_fcst_utils.get_org_task_info
1229: ( p_project_id => l_project_id
1230: ,x_organization_id => l_task_organization_id
1231: ,x_org_task_id => l_own_task_id
1232: ,x_return_status => l_return_status
1453: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1454: END IF;
1455:
1456:
1457: pa_fp_org_fcst_utils.get_period_profile
1458: ( p_project_id => l_project_id
1459: ,p_period_profile_type => 'FINANCIAL_PLANNING'
1460: ,p_plan_period_type => l_org_fcst_period_type
1461: ,p_period_set_name => l_period_set_name
1722: IF P_PA_DEBUG_MODE = 'Y' THEN
1723: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1724: END IF;
1725:
1726: pa_fp_org_fcst_utils.get_org_task_info
1727: ( p_project_id => l_project_id
1728: ,x_organization_id => l_task_organization_id
1729: ,x_org_task_id => l_own_task_id
1730: ,x_return_status => l_return_status
2189:
2190: IF (l_pfi_txn_project_id IS NULL OR
2191: l_pfi_txn_project_id <> l_fi_txn_project_id_tab(i)) THEN
2192: IF l_weighted_or_full_code = 'W' THEN
2193: pa_fp_org_fcst_utils.get_probability_percent
2194: ( p_project_id => l_fi_txn_project_id_tab(i)
2195: ,x_prob_percent => l_prob_percent
2196: ,x_return_status => l_return_status
2197: ,x_err_code => l_err_code);
3076: FOR i in l_bl_res_asg_id_tab.first..l_bl_res_asg_id_tab.last LOOP
3077: l_stage := 8700;
3078: -- hr_utility.trace(to_char(l_stage));
3079:
3080: /* API call changed from pa_fp_org_fcst_utils.get_utilization_details
3081: to pa_pji_util_pkg.get_utilization_dtls to get the Utilization
3082: numbers from PJI data model if PJI is installed. */
3083:
3084: pa_pji_util_pkg.get_utilization_dtls
3127:
3128: l_stage := 8800;
3129: -- hr_utility.trace(to_char(l_stage));
3130:
3131: pa_fp_org_fcst_utils.get_headcount
3132: ( p_organization_id => l_organization_id
3133: ,p_effective_date => l_bl_start_date_tab(i)
3134: ,x_headcount => l_bl_head_count_tab(i)
3135: ,x_return_status => l_return_status