[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
662: l_stage := 100;
663: -- hr_utility.trace(to_char(l_stage));
664:
665: -- get information from pa_forecast_options_all
666: pa_fp_org_fcst_utils.get_forecast_option_details
667: ( x_fcst_period_type => l_org_fcst_period_type
668: ,x_period_set_name => l_period_set_name
669: ,x_act_period_type => l_act_period_type
670: ,x_org_projfunc_currency_code => l_org_projfunc_currency_code
1031: /* Get Project information if the project exists else create the
1032: project by copying the template as per forecasting options
1033: and then get the project info */
1034:
1035: pa_fp_org_fcst_utils.get_org_project_info
1036: ( p_organization_id => l_organization_id
1037: ,x_org_project_id => l_project_id
1038: ,x_return_status => l_return_status
1039: ,x_err_code => l_err_code);
1068: IF P_PA_DEBUG_MODE = 'Y' THEN
1069: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1070: END IF;
1071:
1072: pa_fp_org_fcst_utils.get_org_task_info
1073: ( p_project_id => l_project_id
1074: ,x_organization_id => l_task_organization_id
1075: ,x_org_task_id => l_own_task_id
1076: ,x_return_status => l_return_status
1225: pa_debug.g_err_stage := l_stage||': Get Org Task Info';
1226: IF P_PA_DEBUG_MODE = 'Y' THEN
1227: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1228: END IF;
1229: pa_fp_org_fcst_utils.get_org_task_info
1230: ( p_project_id => l_project_id
1231: ,x_organization_id => l_task_organization_id
1232: ,x_org_task_id => l_own_task_id
1233: ,x_return_status => l_return_status
1454: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1455: END IF;
1456:
1457:
1458: pa_fp_org_fcst_utils.get_period_profile
1459: ( p_project_id => l_project_id
1460: ,p_period_profile_type => 'FINANCIAL_PLANNING'
1461: ,p_plan_period_type => l_org_fcst_period_type
1462: ,p_period_set_name => l_period_set_name
1723: IF P_PA_DEBUG_MODE = 'Y' THEN
1724: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1725: END IF;
1726:
1727: pa_fp_org_fcst_utils.get_org_task_info
1728: ( p_project_id => l_project_id
1729: ,x_organization_id => l_task_organization_id
1730: ,x_org_task_id => l_own_task_id
1731: ,x_return_status => l_return_status
2190:
2191: IF (l_pfi_txn_project_id IS NULL OR
2192: l_pfi_txn_project_id <> l_fi_txn_project_id_tab(i)) THEN
2193: IF l_weighted_or_full_code = 'W' THEN
2194: pa_fp_org_fcst_utils.get_probability_percent
2195: ( p_project_id => l_fi_txn_project_id_tab(i)
2196: ,x_prob_percent => l_prob_percent
2197: ,x_return_status => l_return_status
2198: ,x_err_code => l_err_code);
3077: FOR i in l_bl_res_asg_id_tab.first..l_bl_res_asg_id_tab.last LOOP
3078: l_stage := 8700;
3079: -- hr_utility.trace(to_char(l_stage));
3080:
3081: /* API call changed from pa_fp_org_fcst_utils.get_utilization_details
3082: to pa_pji_util_pkg.get_utilization_dtls to get the Utilization
3083: numbers from PJI data model if PJI is installed. */
3084:
3085: pa_pji_util_pkg.get_utilization_dtls
3128:
3129: l_stage := 8800;
3130: -- hr_utility.trace(to_char(l_stage));
3131:
3132: pa_fp_org_fcst_utils.get_headcount
3133: ( p_organization_id => l_organization_id
3134: ,p_effective_date => l_bl_start_date_tab(i)
3135: ,x_headcount => l_bl_head_count_tab(i)
3136: ,x_return_status => l_return_status