APPS.HZ_MGD_MASS_UPDATE_CP SQL Statements

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

Line: 55

  HZ_MGD_MASS_UPDATE_REP_GEN.Initialize;

Line: 57

  HZ_MGD_MASS_UPDATE_REP_GEN.log( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
                            , p_msg => '>> Run_Mass_Update_Credit_Usages');

Line: 61

  HZ_MGD_MASS_UPDATE_REP_GEN.log
  ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
  , p_msg => 'assigning p_release to the global G_RELEASE='
             ||p_release
  );

Line: 67

  HZ_MGD_MASS_UPDATE_CP.G_RELEASE:=p_release;

Line: 69

  HZ_MGD_MASS_UPDATE_REP_GEN.log
  ( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_STATEMENT
  , p_msg => 'p_profile_class_id='||TO_CHAR(p_profile_class_id)
             ||'p_currency_code='||p_currency_code
  );

Line: 76

  HZ_MGD_MASS_UPDATE_MEDIATOR.Mass_Update_Usage_Rules
  ( p_profile_class_id        => p_profile_class_id
  , p_currency_code           => p_currency_code
  , p_profile_class_amount_id => p_profile_class_amount_id
  , x_errbuf                  => l_errbuf
  , x_retcode                 => l_retcode
  );

Line: 87

  HZ_MGD_MASS_UPDATE_REP_GEN.Generate_Report
  ( p_prof_class_id             => p_profile_class_id
  , p_currency_code             => p_currency_code
  , p_profile_class_amount_id   => p_profile_class_amount_id
  );

Line: 93

  HZ_MGD_MASS_UPDATE_REP_GEN.Log( p_priority => HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_PROCEDURE
                             , p_msg => '<< Run_Mass_Update_Credit_Usages');

Line: 99

    HZ_MGD_MASS_UPDATE_REP_GEN.Log(HZ_MGD_MASS_UPDATE_REP_GEN.G_LOG_EXCEPTION,'SQLERRM '|| SQLERRM) ;

Line: 103

      FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 'Run_Mass_Update_Credit_Usages');

Line: 111

END Run_Mass_Update_Credit_Usages;