APPS.FV_SETUP_PKG SQL Statements

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

Line: 134

          delete from FV_FACTS_USSGL_ACCOUNTS;

Line: 135

          fv_utility.log_mesg('Deleted from FV_FACTS_USSGL_ACCOUNTS');

Line: 308

               p_delete_133_setup IN VARCHAR2) is
  l_module_name VARCHAR2(200) := g_module_name || 'LOAD_SF133_SETUP_DATA';

Line: 313

       IF p_delete_133_setup = 'Y' THEN
        fv_utility.log_mesg('Deleting 133 setup data');

Line: 317

          delete from FV_SF133_REP_LINE_CALC;

Line: 318

          fv_utility.log_mesg('Deleted from FV_SF133_REP_LINE_CALC');

Line: 319

          delete from FV_SF133_DEFINITIONS_ACCTS;

Line: 320

          fv_utility.log_mesg('Deleted from FV_SF133_DEFINITIONS_ACCTS');

Line: 321

          delete from FV_SF133_DEFINITIONS_LINES;

Line: 322

          fv_utility.log_mesg('Deleted from FV_SF133_DEFINITIONS_LINES');

Line: 364

               p_delete_sbr_setup IN VARCHAR2) is
  l_module_name VARCHAR2(200) := g_module_name || 'LOAD_SBR_SETUP_DATA';

Line: 369

       IF p_delete_sbr_setup = 'Y' THEN
        fv_utility.log_mesg('Deleting SBR setup data');

Line: 373

          delete from FV_SBR_REP_LINE_CALC;

Line: 374

          fv_utility.log_mesg('Deleted from FV_SBR_REP_LINE_CALC');

Line: 375

          delete from FV_SBR_DEFINITIONS_ACCTS;

Line: 376

          fv_utility.log_mesg('Deleted from FV_SBR_DEFINITIONS_ACCTS');

Line: 377

          delete from FV_SBR_DEFINITIONS_LINES;

Line: 378

          fv_utility.log_mesg('Deleted from FV_SBR_DEFINITIONS_LINES');

Line: 452

   UPDATE fa_rx_reports
   SET responsibility_id = (SELECT responsibility_id
                            FROM FND_responsibility_tl
                            WHERE responsibility_name = 'Federal Administrator'
                            AND   language= 'US')
   WHERE report_id IN (395,397,399,415,417,100227);

Line: 518

          DELETE FROM FV_GTAS_ATTRIBUTES
          WHERE set_of_books_id = p_sob_id;

Line: 523

          DELETE FROM FV_GTAS_ATTRIBUTES;

Line: 526

         fv_utility.log_mesg('Deleted from FV_GTAS_ATTRIBUTES');