APPS.PA_SUMMARIZE_ACTUAL_UTIL_PVT dependencies on PA_UTILIZATION_OPTIONS_ALL

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 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;