APPS.JTF_TASK_TEMP_GROUP_PVT SQL Statements

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

Line: 3

   v_select   VARCHAR2(6000);

Line: 43

      SELECT jtf_task_temp_groups_s.nextval
        INTO v_task_template_group_id
        FROM dual;

Line: 47

      jtf_task_temp_groups_pkg.insert_row (
         v_rowid,
         v_task_template_group_id,
         p_source_object_type_code,
         p_start_date_active,
         p_end_date_active,
         p_attribute1,
         p_attribute2,
         p_attribute3,
         p_attribute4,
         p_attribute5,
         p_attribute6,
         p_attribute7,
         p_attribute8,
         p_attribute9,
         p_attribute10,
         p_attribute11,
         p_attribute12,
         p_attribute13,
         p_attribute14,
         p_attribute15,
         p_attribute_category,
         p_template_group_name,
         p_description,
         SYSDATE,
         fnd_global.user_id,
         SYSDATE,
         fnd_global.user_id,
         fnd_global.login_id,
         p_application_id
      );

Line: 119

   PROCEDURE update_task_template_group (
      p_commit                    IN       VARCHAR2,
      p_task_template_group_id    IN       NUMBER,
      p_template_group_name       IN       VARCHAR2,
      p_source_object_type_code   IN       VARCHAR2,
      p_start_date_active         IN       DATE,
      p_end_date_active           IN       DATE,
      p_description               IN       VARCHAR2,
      p_attribute1                IN       VARCHAR2,
      p_attribute2                IN       VARCHAR2,
      p_attribute3                IN       VARCHAR2,
      p_attribute4                IN       VARCHAR2,
      p_attribute5                IN       VARCHAR2,
      p_attribute6                IN       VARCHAR2,
      p_attribute7                IN       VARCHAR2,
      p_attribute8                IN       VARCHAR2,
      p_attribute9                IN       VARCHAR2,
      p_attribute10               IN       VARCHAR2,
      p_attribute11               IN       VARCHAR2,
      p_attribute12               IN       VARCHAR2,
      p_attribute13               IN       VARCHAR2,
      p_attribute14               IN       VARCHAR2,
      p_attribute15               IN       VARCHAR2,
      p_attribute_category        IN       VARCHAR2,
      x_return_status             OUT NOCOPY      VARCHAR2,
      x_msg_count                 OUT NOCOPY      NUMBER,
      x_msg_data                  OUT NOCOPY      VARCHAR2,
      x_object_version_number     IN OUT NOCOPY   NUMBER,
      p_application_id            IN       NUMBER DEFAULT NULL
   )
   IS
      l_api_name   VARCHAR2(30) := 'UPDATE_TASK_TEMPLATE_GROUP';

Line: 153

      SAVEPOINT update_template_group_pvt;

Line: 160

      jtf_task_temp_groups_pkg.update_row (
         p_task_template_group_id,
         x_object_version_number + 1,
         p_source_object_type_code,
         p_start_date_active,
         p_end_date_active,
         p_attribute1,
         p_attribute2,
         p_attribute3,
         p_attribute4,
         p_attribute5,
         p_attribute6,
         p_attribute7,
         p_attribute8,
         p_attribute9,
         p_attribute10,
         p_attribute11,
         p_attribute12,
         p_attribute13,
         p_attribute14,
         p_attribute15,
         p_attribute_category,
         p_template_group_name,
         p_description,
         SYSDATE,
         fnd_global.user_id,
         fnd_global.login_id,
         p_application_id
      );

Line: 201

         ROLLBACK TO update_template_group_pvt;

Line: 209

         ROLLBACK TO update_template_group_pvt;

Line: 217

         ROLLBACK TO update_template_group_pvt;

Line: 229

   END update_task_template_group;

Line: 231

   PROCEDURE delete_task_template_group (
      p_commit                   IN       VARCHAR2,
      p_task_template_group_id   IN       NUMBER,
      x_return_status            OUT NOCOPY      VARCHAR2,
      x_msg_count                OUT NOCOPY      NUMBER,
      x_msg_data                 OUT NOCOPY      VARCHAR2
   )
   IS
      l_api_name   VARCHAR2(30) := 'DELETE_TASK_TEMPLATE_GROUP';

Line: 242

      SAVEPOINT delete_template_group_pvt;

Line: 244

      jtf_task_temp_groups_pkg.delete_row (p_task_template_group_id);

Line: 254

         ROLLBACK TO delete_template_group_pvt;

Line: 262

         ROLLBACK TO delete_template_group_pvt;

Line: 270

         ROLLBACK TO delete_template_group_pvt;

Line: 282

   END delete_task_template_group;

Line: 363

         v_select := 'select TASK_TEMPLATE_GROUP_ID,' ||
                     'TEMPLATE_GROUP_NAME,' ||
                     'SOURCE_OBJECT_TYPE_CODE,' ||
                     'START_DATE_ACTIVE,' ||
                     'END_DATE_ACTIVE,' ||
                     'DESCRIPTION,' ||
                     'ATTRIBUTE1,' ||
                     'ATTRIBUTE2,' ||
                     'ATTRIBUTE3,' ||
                     'ATTRIBUTE4,' ||
                     'ATTRIBUTE5,' ||
                     'ATTRIBUTE6,' ||
                     'ATTRIBUTE7,' ||
                     'ATTRIBUTE8,' ||
                     'ATTRIBUTE9,' ||
                     'ATTRIBUTE10,' ||
                     'ATTRIBUTE11,' ||
                     'ATTRIBUTE12,' ||
                     'ATTRIBUTE13,' ||
                     'ATTRIBUTE14,' ||
                     'ATTRIBUTE15,' ||
                     'ATTRIBUTE_CATEGORY,' ||
                     'object_version_number ,' ||
                     'APPLICATION_ID ' ||
                     'from jtf_task_temp_groups_vl ';

Line: 413

            v_select := v_select || ' where ' || v_where;

Line: 418

            v_select := v_select || ' order by ';

Line: 430

               v_select := v_select ||
                           v_comma ||
                           p_sort_data (v_index).field_name ||
                           ' ';

Line: 438

                  v_select := v_select || 'asc ';

Line: 441

                  v_select := v_select || 'desc ';

Line: 451

      x_task_template_group.DELETE;

Line: 455

         v_tbl.DELETE;

Line: 457

         dump_long_line ('v_sel:', v_select);

Line: 459

         DBMS_SQL.parse (v_cursor_id, v_select, DBMS_SQL.v7);