DBA Data[Home] [Help]

APPS.PA_SUMMARIZE_FORECAST_UTIL_PVT dependencies on PA_UTILIZATION_OPTIONS_ALL

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