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.

APPS.PA_SUMMARIZE_FORECAST_UTIL_PVT dependencies on PA_UTILIZATION_OPTIONS

Line 16: l_forecast_thru_date pa_utilization_options.forecast_thru_date%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_forecast_thru_date;

12: l_fc_start_date DATE := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_start_date;
13: l_fc_end_date DATE := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;
14:
15: -- Utilization Option details
16: l_forecast_thru_date pa_utilization_options.forecast_thru_date%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_forecast_thru_date;
17: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag;
18: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag;
19: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag;
20:

Line 17: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag;

13: l_fc_end_date DATE := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;
14:
15: -- Utilization Option details
16: l_forecast_thru_date pa_utilization_options.forecast_thru_date%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_forecast_thru_date;
17: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag;
18: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag;
19: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag;
20:
21: -- Implementation options

Line 18: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag;

14:
15: -- Utilization Option details
16: l_forecast_thru_date pa_utilization_options.forecast_thru_date%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_forecast_thru_date;
17: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag;
18: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag;
19: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag;
20:
21: -- Implementation options
22: l_org_id pa_implementations.org_id%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_org_id;

Line 19: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag;

15: -- Utilization Option details
16: l_forecast_thru_date pa_utilization_options.forecast_thru_date%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_forecast_thru_date;
17: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag;
18: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag;
19: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag;
20:
21: -- Implementation options
22: l_org_id pa_implementations.org_id%TYPE := PA_REP_UTIL_GLOB.G_implementation_details.G_org_id;
23:

Line 443: -- Update pa_utilization_options with the dates for which Balances exist.

439: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
440: END IF;
441:
442: --
443: -- Update pa_utilization_options with the dates for which Balances exist.
444: --
445: /* Bug 1628557
446: * Put the code for update outside of the if loop so that the thru date
447: * is updated with the end date of the current run (it would no longer

Line 454: UPDATE pa_utilization_options_all

450: * IF NVL(l_forecast_thru_date, l_fc_end_date -1) < l_fc_end_date THEN
451: * code for update
452: * END IF;
453: */
454: UPDATE pa_utilization_options_all
455: SET forecast_thru_date = l_fc_end_date
456: , forecast_last_run_date = sysdate
457: WHERE NVL(org_id, -99) = l_org_id;
458:

Line 470: PA_DEBUG.G_Err_Stage := '1650 : After updating PA_UTILIZATION_OPTIONS_ALL';

466: */
467:
468: COMMIT;
469: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
470: PA_DEBUG.G_Err_Stage := '1650 : After updating PA_UTILIZATION_OPTIONS_ALL';
471: PA_DEBUG.Log_Message(p_message => PA_DEBUG.G_Err_Stage);
472: PA_DEBUG.g_err_stage := '1660: Exiting the Package PA_SUMMARIZE_FORECAST_UTIL';
473: END IF;
474: -- Reset the error stack when returning to the calling program