APPS.GME_INIT_RSRC_TXNS_SUMMARY SQL Statements

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

Line: 29

     SELECT
       COUNT(*)
     FROM
       gme_resource_txns_summary;

Line: 36

      SELECT
       orgn_code,
       resources,
       instance_id,
       start_date,
       end_date,
       sequence_dependent_ind,
       last_updated_by,
       last_update_login
      FROM
       gme_resource_txns
      WHERE
       completed_ind = 0 AND
       delete_mark   = 0;

Line: 53

      SELECT
        resource_id
      FROM
        cr_rsrc_dtl
      WHERE
        resources = p_resource AND
        orgn_code = p_orgn_code;

Line: 95

          UPDATE
             gme_resource_txns_summary
          SET
             required_units    = required_units + 1,
             last_updated_by   = txns_rec.last_updated_by,
             last_update_date  = l_sysdate,
             last_update_login = txns_rec.last_update_login
          WHERE
             start_date                     = txns_rec.start_date AND
             end_date                       = txns_rec.end_date   AND
             resource_id                    = l_resource_id       AND
             NVL(instance_id, -1)           = NVL(txns_rec.instance_id, -1) AND
             sequence_dependent_ind         = NVL(txns_rec.sequence_dependent_ind, 0);

Line: 113

            INSERT INTO gme_resource_txns_summary
                    ( resource_id
                     ,instance_id
                     ,start_date
                     ,end_date
                     ,required_units
                     ,sequence_dependent_ind
                     ,creation_date
                     ,last_update_date
                     ,created_by
                     ,last_updated_by
                     ,last_update_login)
             VALUES
                    ( l_resource_id
                     ,txns_rec.instance_id
                     ,txns_rec.start_date
                     ,txns_rec.end_date
                     ,1
                     ,NVL(txns_rec.sequence_dependent_ind, 0)
                     ,l_sysdate
                     ,l_sysdate
                     ,txns_rec.last_updated_by
                     ,txns_rec.last_updated_by
                     ,txns_rec.last_update_login);