DBA Data[Home] [Help]

APPS.GME_VALIDATE_FLEX_FLD_PVT SQL Statements

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

Line: 794

         SELECT 1
           FROM gme_batch_steps
          WHERE batchstep_id = v_rec_id;
Line: 1295

         /* Bug 3681718 - Only update flex field columns in x_ OUT parameter. */
         x_batch_step.attribute_category :=
                                           l_batch_step_row.attribute_category;
Line: 1513

         SELECT 1
           FROM gme_batch_step_activities
          WHERE batchstep_activity_id = v_rec_id;
Line: 2015

         /* Bug 3681718 - Only update flex field columns in x_ OUT parameter. */
         x_step_activities.attribute_category :=
                                      l_step_activities_row.attribute_category;
Line: 2264

         SELECT 1
           FROM gme_batch_step_resources
          WHERE batchstep_resource_id = v_rec_id;
Line: 2768

         /* Bug 3681718 - Only update flex field columns in x_ OUT parameter. */
         x_step_resources.attribute_category :=
                                        l_step_resource_row.attribute_category;
Line: 2992

         SELECT 1
           FROM gme_resource_txns
          WHERE poc_trans_id = v_rec_id;
Line: 4390

         SELECT 1
           FROM gme_process_parameters
          WHERE process_param_id = v_rec_id;
Line: 4894

         /* Only update flex field columns in x_out parameter. */
         x_process_param_rec.attribute_category :=
                                        l_process_param_rec.attribute_category;