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.GME_BATCH_STEP_CHARGE_DBL SQL Statements

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

Line: 10


 |    insert_row                                                            |
 |                                                                          |
 | TYPE                                                                     |
 |    Private                                                               |
 |                                                                          |
 | DESCRIPTION                                                              |
 |   insert_Row will insert a row in  gme_batch_step_charges                |
 |                                                                          |
 |                                                                          |
 | PARAMETERS                                                               |
 |    p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE             |
 |    x_batch_step_charges IN OUT NOCOPY gme_batch_step_charges%ROWTYPE     |
 | RETURNS                                                                  |
 |    BOOLEAN                                                               |
 |                                                                          |
 | HISTORY                                                                  |
 |    04-05-2004 Rishi Varma bug 3307549                  |
 |         Created                                  |
 |                                                                          |
 +==========================================================================+
  Api end of comments
*/
   FUNCTION insert_row (
      p_batch_step_charges_in   IN              gme_batch_step_charges%ROWTYPE
     ,x_batch_step_charges      IN OUT NOCOPY   gme_batch_step_charges%ROWTYPE)
      RETURN BOOLEAN
   IS
      l_api_name   CONSTANT VARCHAR2 (30) := 'INSERT_ROW';

Line: 41


      INSERT INTO gme_batch_step_charges
                  (batch_id
                  ,batchstep_id
                  ,resources
                  ,charge_number
                  ,charge_quantity
                  ,activity_sequence_number
                  ,plan_start_date
                  ,plan_cmplt_date
                  ,last_update_date, creation_date
                  ,created_by, last_updated_by
                  ,last_update_login)
           VALUES (x_batch_step_charges.batch_id
                  ,x_batch_step_charges.batchstep_id
                  ,x_batch_step_charges.resources
                  ,x_batch_step_charges.charge_number
                  ,x_batch_step_charges.charge_quantity
                  ,x_batch_step_charges.activity_sequence_number
                  ,x_batch_step_charges.plan_start_date
                  ,x_batch_step_charges.plan_cmplt_date
                  ,gme_common_pvt.g_timestamp, gme_common_pvt.g_timestamp
                  ,gme_common_pvt.g_user_ident, gme_common_pvt.g_user_ident
                  ,gme_common_pvt.g_login_id);

Line: 76


   END insert_row;

Line: 115


         SELECT batch_id
               ,batchstep_id
               ,resources
               ,activity_sequence_number
               ,charge_number
               ,charge_quantity
               ,plan_start_date
               ,plan_cmplt_date
               ,last_update_date
               ,creation_date
               ,created_by
               ,last_updated_by
               ,last_update_login
           INTO x_batch_step_charges.batch_id
               ,x_batch_step_charges.batchstep_id
               ,x_batch_step_charges.resources
               ,x_batch_step_charges.activity_sequence_number
               ,x_batch_step_charges.charge_number
               ,x_batch_step_charges.charge_quantity
               ,x_batch_step_charges.plan_start_date
               ,x_batch_step_charges.plan_cmplt_date
               ,x_batch_step_charges.last_update_date
               ,x_batch_step_charges.creation_date
               ,x_batch_step_charges.created_by
               ,x_batch_step_charges.last_updated_by
               ,x_batch_step_charges.last_update_login
           FROM gme_batch_step_charges
          WHERE batchstep_id = p_batch_step_charges_in.batchstep_id;

Line: 145


         SELECT batch_id
               ,batchstep_id
               ,resources
               ,activity_sequence_number
               ,charge_number
               ,charge_quantity
               ,plan_start_date
               ,plan_cmplt_date
               ,last_update_date
               ,creation_date
               ,created_by
               ,last_updated_by
               ,last_update_login
           INTO x_batch_step_charges.batch_id
               ,x_batch_step_charges.batchstep_id
               ,x_batch_step_charges.resources
               ,x_batch_step_charges.activity_sequence_number
               ,x_batch_step_charges.charge_number
               ,x_batch_step_charges.charge_quantity
               ,x_batch_step_charges.plan_start_date
               ,x_batch_step_charges.plan_cmplt_date
               ,x_batch_step_charges.last_update_date
               ,x_batch_step_charges.creation_date
               ,x_batch_step_charges.created_by
               ,x_batch_step_charges.last_updated_by
               ,x_batch_step_charges.last_update_login
           FROM gme_batch_step_charges
          WHERE batch_id = p_batch_step_charges_in.batch_id
            AND batchstep_id = p_batch_step_charges_in.batchstep_id;

Line: 198


 |    update_row                                                            |
 |                                                                          |
 | TYPE                                                                     |
 |    Private                                                               |
 |                                                                          |
 | USAGE                                                                    |
 |   update_Row will update a row in  gme_batch_step_charges                |
 |                                                                          |
 | DESCRIPTION                                                              |
 |   update_row will update a row in  gme_batch_step_charges                |
 |                                                                          |
 |                                                                          |
 | PARAMETERS                                                               |
 |    p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE             |
 | RETURNS                                                                  |
 |    BOOLEAN                                                               |
 |                                                                          |
 | HISTORY                                                                  |
 |     04-NAY-2004  Rishi Varma Bug 3307549                  |
 |         Created                             |
 |                                                                          |
 +==========================================================================+
  Api end of comments
*/
   FUNCTION update_row (
      p_batch_step_charges_in   IN   gme_batch_step_charges%ROWTYPE)
      RETURN BOOLEAN
   IS
      CURSOR cur_both_ids (v_batch_id NUMBER, v_batchstep_id NUMBER)
      IS
         SELECT     1
               FROM gme_batch_step_charges
              WHERE batch_id = v_batch_id AND batchstep_id = v_batchstep_id
         FOR UPDATE NOWAIT;

Line: 235


         SELECT     1
               FROM gme_batch_step_charges
              WHERE batchstep_id = v_batchstep_id
         FOR UPDATE NOWAIT;

Line: 244


      l_api_name    CONSTANT VARCHAR2 (30) := 'UPDATE_ROW';

Line: 260


         UPDATE gme_batch_step_charges
            SET batch_id = p_batch_step_charges_in.batch_id
               ,batchstep_id = p_batch_step_charges_in.batchstep_id
               ,resources = p_batch_step_charges_in.resources
               ,activity_sequence_number =
                              p_batch_step_charges_in.activity_sequence_number
               ,charge_number = p_batch_step_charges_in.charge_number
               ,charge_quantity = p_batch_step_charges_in.charge_quantity
               ,plan_start_date = p_batch_step_charges_in.plan_start_date
               ,plan_cmplt_date = p_batch_step_charges_in.plan_cmplt_date
               ,last_update_date = gme_common_pvt.g_timestamp
               ,last_updated_by = gme_common_pvt.g_user_ident
               ,last_update_login = gme_common_pvt.g_login_id
          WHERE batchstep_id = p_batch_step_charges_in.batchstep_id
            AND last_update_date = p_batch_step_charges_in.last_update_date;

Line: 291


         UPDATE gme_batch_step_charges
            SET batch_id = p_batch_step_charges_in.batch_id
               ,batchstep_id = p_batch_step_charges_in.batchstep_id
               ,resources = p_batch_step_charges_in.resources
               ,activity_sequence_number =
                              p_batch_step_charges_in.activity_sequence_number
               ,charge_number = p_batch_step_charges_in.charge_number
               ,charge_quantity = p_batch_step_charges_in.charge_quantity
               ,plan_start_date = p_batch_step_charges_in.plan_start_date
               ,plan_cmplt_date = p_batch_step_charges_in.plan_cmplt_date
               ,last_update_date = gme_common_pvt.g_timestamp
               ,last_updated_by = gme_common_pvt.g_user_ident
               ,last_update_login = gme_common_pvt.g_login_id
          WHERE batchstep_id = p_batch_step_charges_in.batchstep_id
            AND batch_id = p_batch_step_charges_in.batch_id
            AND last_update_date = p_batch_step_charges_in.last_update_date;

Line: 347


   END update_row;

Line: 352


 |    delete_row                                                            |
 |                                                                          |
 | TYPE                                                                     |
 |    Private                                                               |
 |                                                                          |
 | USAGE                                                                    |
 |   delete_Row will delete a row in  gme_batch_step_charges                |
 |                                                                          |
 | DESCRIPTION                                                              |
 |   delete_row will delete a row in  gme_batch_step_charges                |
 |                                                                          |
 |                                                                          |
 | PARAMETERS                                                               |
 |    p_batch_step_charges_in IN gme_batch_step_charges%ROWTYPE             |
 | RETURNS                                                                  |
 |    BOOLEAN                                                               |
 |                                                                          |
 | HISTORY                                                                  |
 |     04-NAY-2004  Rishi Varma Bug 3307549                  |
 |         Created                             |
 |                                                                          |
 +==========================================================================+
  Api end of comments
*/
   FUNCTION delete_row (
      p_batch_step_charges_in   IN   gme_batch_step_charges%ROWTYPE)
      RETURN BOOLEAN
   IS
      CURSOR cur_both_ids (v_batch_id NUMBER, v_batchstep_id NUMBER)
      IS
         SELECT     1
               FROM gme_batch_step_charges
              WHERE batch_id = v_batch_id AND batchstep_id = v_batchstep_id
         FOR UPDATE NOWAIT;

Line: 389


         SELECT     1
               FROM gme_batch_step_charges
              WHERE batchstep_id = v_batchstep_id
         FOR UPDATE NOWAIT;

Line: 396


         SELECT     1
               FROM gme_batch_step_charges
              WHERE batch_id = v_batch_id
         FOR UPDATE NOWAIT;

Line: 406


      l_api_name    CONSTANT VARCHAR2 (30) := 'DELETE_ROW';

Line: 439


         DELETE FROM gme_batch_step_charges
               WHERE batchstep_id = p_batch_step_charges_in.batchstep_id;

Line: 447


                                || 'in delete dbl,batch,step id is'
                                || p_batch_step_charges_in.batch_id
                               ,p_batch_step_charges_in.batchstep_id);

Line: 466


         DELETE FROM gme_batch_step_charges
               WHERE batch_id = p_batch_step_charges_in.batch_id
                 AND batchstep_id = p_batch_step_charges_in.batchstep_id;

Line: 475


                                || 'in delete dbl,batch_id is'
                                || p_batch_step_charges_in.batch_id);

Line: 492


         DELETE FROM gme_batch_step_charges
               WHERE batch_id = p_batch_step_charges_in.batch_id;

Line: 534


   END delete_row;