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_REP_UTIL_GLOB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 262


   *  The checking of the last_update_date of pa_org_hierarchy_denorm is
   *  to find if the the organization hierarchy changed during the run.
   */
    SELECT max(LAST_UPDATE_DATE)
      INTO l_orghier_date_before
      FROM pa_org_hierarchy_denorm
     WHERE pa_org_use_type = 'REPORTING'
       AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
       AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
     ;

Line: 274


      PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm before the run is <'||l_orghier_date_before||'>';

Line: 379


    SELECT max(LAST_UPDATE_DATE)
      INTO l_orghier_date_after
      FROM pa_org_hierarchy_denorm
     WHERE pa_org_use_type = 'REPORTING'
       AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
       AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
     ;

Line: 405


      PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm after the run is <'||l_orghier_date_after||'>';

Line: 604


   *  The checking of the last_update_date of pa_org_hierarchy_denorm is
   *  to find if the the organization hierarchy changed during the run.
   */
    SELECT max(LAST_UPDATE_DATE)
      INTO l_orghier_date_before
      FROM pa_org_hierarchy_denorm
     WHERE pa_org_use_type = 'REPORTING'
       AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
       AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.
G_org_structure_version_id
     ;

Line: 616


      PA_DEBUG.g_err_stage := '300 : Max Last_Update_Date of pa_org_hierarchy_denorm before the run is <'||l_orghier_date_before||'>';

Line: 722


    SELECT max(LAST_UPDATE_DATE)
      INTO l_orghier_date_after
      FROM pa_org_hierarchy_denorm
     WHERE pa_org_use_type = 'REPORTING'
       AND NVL(org_id, -99) = pa_rep_util_glob.G_implementation_details.G_org_id
       AND ORG_HIERARCHY_VERSION_ID = pa_rep_util_glob.G_implementation_details.G_org_structure_version_id
     ;

Line: 748


      PA_DEBUG.g_err_stage := '310 : Max Last_Update_Date of pa_org_hierarchy_denorm after the run is <'||l_orghier_date_after||'>';

Line: 896


    SELECT (g.period_year*10000) + g.period_num
      INTO effective_start_period_num
      FROM gl_date_period_map     map
          ,gl_periods             g
--    WHERE g.period_set_name   = G_implementation_details.G_period_set_name
      WHERE g.period_set_name   = p_period_set_name   --bug 3434019
        AND g.period_name       = map.period_name
        AND map.accounting_date = p_start_date
        AND map.period_type     = p_period_type
--        AND map.period_set_name = G_implementation_details.G_period_set_name;

Line: 1092


    G_who_columns.G_last_updated_by   := FND_GLOBAL.USER_ID;

Line: 1095


    G_who_columns.G_last_update_date  := G_who_columns.G_creation_date;

Line: 1096


    G_who_columns.G_last_update_login      := FND_GLOBAL.LOGIN_ID;

Line: 1133


    PA_DEBUG.g_err_stage := '200 : Before Selecting Implementation Details';

Line: 1137


    SELECT NVL(imp.org_id,-99)
          ,imp.org_structure_version_id
          ,imp.start_organization_id
          ,imp.pa_period_type
          ,sob.accounted_period_type
          ,sob.period_set_name
          ,imp.period_set_name                 --bug 3434019
      INTO G_implementation_details.G_org_id
          ,G_implementation_details.G_org_structure_version_id
          ,G_implementation_details.G_start_organization_id
          ,G_implementation_details.G_pa_period_type
          ,G_implementation_details.G_gl_period_type
          ,G_implementation_details.G_gl_period_set_name   --bug 3434019
          ,G_implementation_details.G_pa_period_set_name   --bug 3434019
    FROM pa_implementations imp
          ,gl_sets_of_books sob
    WHERE sob.set_of_books_id = imp.set_of_books_id ;

Line: 1156


    PA_DEBUG.g_err_stage := '250 : After Selecting Implementation Details';

Line: 1170


    SELECT pa_period_flag
          ,gl_period_flag
          ,global_exp_period_flag
          ,forecast_thru_date
          ,actuals_thru_date
      INTO G_util_option_details.G_pa_period_flag
          ,G_util_option_details.G_gl_period_flag
          ,G_util_option_details.G_ge_period_flag
          ,G_util_option_details.G_forecast_thru_date
          ,G_util_option_details.G_actuals_thru_date
    FROM pa_utilization_options;

Line: 1196


    SELECT actuals_last_run_date
          ,forecast_last_run_date
      INTO G_last_run_when.G_ac_last_run_date
          ,G_last_run_when.G_fc_last_run_date
    FROM pa_utilization_options;

Line: 1464


  PROCEDURE update_util_cache
  IS
      l_global_week_start_day PLS_INTEGER;

Line: 1478


    PA_DEBUG.Set_Curr_Function( p_function   => 'Update_Util_Cache');

Line: 1480


    PA_DEBUG.g_err_stage := '50 : Entering PA_REP_UTIL_GLOB.update_util_cache';

Line: 1494


    PA_DEBUG.g_err_stage := '200 : Before Selecting Implementation Details';

Line: 1498


    SELECT NVL(imp.org_id,-99)
          ,imp.org_structure_version_id
          ,imp.start_organization_id
          ,imp.pa_period_type
          ,sob.accounted_period_type
          ,sob.period_set_name
          ,imp.period_set_name
    INTO   l_org_id
          ,l_org_structure_version_id
          ,l_start_organization_id
          ,l_pa_period_type
          ,l_gl_period_type
--        ,l_period_set_name
          ,l_gl_period_set_name   -- bug 3434019
          ,l_pa_period_set_name   -- bug 3434019
    FROM pa_implementations imp
          ,gl_sets_of_books sob
    WHERE sob.set_of_books_id = imp.set_of_books_id ;

Line: 1518


    PA_DEBUG.g_err_stage := '250 : After Selecting Implementation Details';

Line: 1567


	    G_who_columns.G_last_updated_by   := FND_GLOBAL.USER_ID;

Line: 1570


	    G_who_columns.G_last_update_date  := G_who_columns.G_creation_date;

Line: 1571


	    G_who_columns.G_last_update_login      := FND_GLOBAL.LOGIN_ID;

Line: 1610


	    SELECT pa_period_flag
	          ,gl_period_flag
	          ,global_exp_period_flag
	          ,forecast_thru_date
	          ,actuals_thru_date
		  ,actuals_last_run_date
		  ,forecast_last_run_date
	      INTO G_util_option_details.G_pa_period_flag
	          ,G_util_option_details.G_gl_period_flag
	          ,G_util_option_details.G_ge_period_flag
	          ,G_util_option_details.G_forecast_thru_date
	          ,G_util_option_details.G_actuals_thru_date
		  ,G_last_run_when.G_ac_last_run_date
	          ,G_last_run_when.G_fc_last_run_date
	    FROM pa_utilization_options;

Line: 1648


   PA_DEBUG.g_err_stage := '500 : Exiting PA_REP_UTIL_GLOB.update_util_cache';

Line: 1656


  END update_util_cache;