APPS.PA_SUMMARIZE_ACTUAL_UTIL_PVT dependencies on PA_UTILIZATION_OPTIONS

Line 18: l_actuals_thru_date pa_utilization_options.actuals_thru_date%TYPE := pa_rep_util_glob.G_util_option_details.G_actuals_thru_date;

14: l_ac_end_date DATE := pa_rep_util_glob.G_input_parameters.G_ac_end_date;
15: /*
16: * Utilization Option details.
17: */
18: l_actuals_thru_date pa_utilization_options.actuals_thru_date%TYPE := pa_rep_util_glob.G_util_option_details.G_actuals_thru_date;
19: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
20: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
21: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
22: /*

Line 19: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;

15: /*
16: * Utilization Option details.
17: */
18: l_actuals_thru_date pa_utilization_options.actuals_thru_date%TYPE := pa_rep_util_glob.G_util_option_details.G_actuals_thru_date;
19: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
20: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
21: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
22: /*
23: * Implementation.

Line 20: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;

16: * Utilization Option details.
17: */
18: l_actuals_thru_date pa_utilization_options.actuals_thru_date%TYPE := pa_rep_util_glob.G_util_option_details.G_actuals_thru_date;
19: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
20: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
21: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
22: /*
23: * Implementation.
24: */

Line 21: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;

17: */
18: l_actuals_thru_date pa_utilization_options.actuals_thru_date%TYPE := pa_rep_util_glob.G_util_option_details.G_actuals_thru_date;
19: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
20: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
21: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
22: /*
23: * Implementation.
24: */
25: l_org_id pa_implementations.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;

Line 433: PA_DEBUG.g_err_stage := '550: Before updating PA_UTILIZATION_OPTIONS_ALL';

429: END IF;
430:
431:
432: IF l_debug ='Y'THEN -- bug 2674619
433: PA_DEBUG.g_err_stage := '550: Before updating PA_UTILIZATION_OPTIONS_ALL';
434: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
435: END IF;
436:
437: /*

Line 438: * Update pa_utilization_options with the dates for which

434: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
435: END IF;
436:
437: /*
438: * Update pa_utilization_options with the dates for which
439: * Balances exist.
440: */
441: /*
442: * Bug 1628557

Line 451: UPDATE pa_utilization_options_all

447: * IF NVL(l_actuals_thru_date, l_ac_end_date -1) < l_ac_end_date THEN
448: * code for update
449: * END IF;
450: */
451: UPDATE pa_utilization_options_all
452: SET actuals_thru_date = l_ac_end_date
453: , actuals_last_run_date = sysdate
454: WHERE NVL(org_id,-99) = l_org_id;
455:

Line 457: PA_DEBUG.g_err_stage := '600: After updating PA_UTILIZATION_OPTIONS_ALL';

453: , actuals_last_run_date = sysdate
454: WHERE NVL(org_id,-99) = l_org_id;
455:
456: IF l_debug ='Y'THEN -- bug 2674619
457: PA_DEBUG.g_err_stage := '600: After updating PA_UTILIZATION_OPTIONS_ALL';
458: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
459: PA_DEBUG.g_err_stage := '700: Exiting the Package PA_SUMMARIZE_ACTUAL_UTIL_PVT';
460: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
461: END IF;