APPS.FV_FACTS_GL_PKG_EXT SQL Statements

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

Line: 93

      fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'SELECT from fv_system_parameters');

Line: 95

    SELECT fsp.factsi_customer_attribute,
           fsp.factsi_vendor_attribute
      INTO p_customer_attribute,
           p_vendor_attribute
      FROM fv_system_parameters fsp;

Line: 182

    l_select_stmt         VARCHAR2(1024);

Line: 249

        SELECT gps.period_year,
               gps.period_num
          INTO p_period_year,
               p_from_period_num
          FROM gl_period_statuses gps
         WHERE gps.application_id = 101
           AND gps.ledger_id = p_ledger_id         --g_set_of_books_id
           AND gps.period_name = p_from_period;

Line: 261

          l_location   := l_module_name||'select_gl_period_statuses1';

Line: 270

          l_location   := l_module_name||'select_gl_period_statuses1';

Line: 281

        SELECT gps.period_year,
               gps.period_num
          INTO l_period_year,
               p_to_period_num
          FROM gl_period_statuses gps
         WHERE gps.application_id = 101
           AND gps.ledger_id = p_ledger_id         --g_set_of_books_id
           AND gps.period_name = p_to_period;

Line: 293

          l_location   := l_module_name||'select_gl_period_statuses1';

Line: 302

          l_location   := l_module_name||'select_gl_period_statuses1';

Line: 355

        l_select_stmt := 'SELECT vendor_type_lookup_code vendor_type, '||
                                 l_vendor_attribute||' elimnation_id '||
                           'FROM po_vendors
                           WHERE vendor_id = :p_vendor_or_cust_id';

Line: 360

        l_select_stmt := 'SELECT customer_class_code vendor_type, '||
                                 l_customer_attribute||' elimnation_id '||
                           'FROM ra_customers
                           WHERE customer_id = :p_vendor_or_cust_id';

Line: 368

        dbms_sql.parse(l_cursor_id, l_select_stmt, dbms_sql.v7);

Line: 387

          l_location   := l_module_name||'select_gl_period_statuses1';

Line: 398

        SELECT concurrent_program_name
          INTO g_conc_program_name
          FROM fnd_concurrent_programs fcp
         WHERE fcp.concurrent_program_id = g_conc_program_id;

Line: 408

          l_location   := l_module_name||'select_fnd_concurrent_programs';

Line: 567

        FOR sob_rec IN (SELECT set_of_books_id
                        FROM   fv_facts1_run
                        WHERE  fiscal_year = l_period_year)
         LOOP

           UPDATE fv_facts1_line_balances ffpb
              SET ffpb.party_classification = l_vendor_type,
                  ffpb.eliminations_dept =
                    DECODE (l_vendor_type, 'FEDERAL', SUBSTR(NVL(l_elimination_id, '00'), 1, 6), '  '),
                  g_ng_indicator = DECODE(l_vendor_type, 'FEDERAL', 'F', 'N')
            WHERE ffpb.party_id = p_vendor_or_cust_id
              AND ffpb.party_type = p_vendor_or_cust
              AND ffpb.set_of_books_id = sob_rec.set_of_books_id
              AND ffpb.period_year = l_period_year
              AND ffpb.period_num BETWEEN l_from_period_num AND l_to_period_num;

Line: 589

                 'Updated fv_facts1_line_balances');

Line: 590

             fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_rows||' rows updated.');

Line: 601

          l_location   := l_module_name||'update_fv_facts1_line_balances';

Line: 617

    fv_utility.log_mesg(fnd_log.level_statement, l_module_name, 'UPDATED '||l_tot_rows||' ROWS IN FV_FACTS1_LINE_BALANCES.');