APPS.JTF_TASK_TEMP_GROUP_PUB SQL Statements

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

Line: 8

    select null
      from jtf_task_temp_groups_vl
      where task_template_group_id = p_task_template_group_id;

Line: 33

    select null
      from jtf_task_temp_groups_vl
      where template_group_name = p_task_template_group_name;

Line: 60

    select null
      from jtf_task_temp_groups_vl
      where template_group_name = p_task_template_group_name
        and task_template_group_id <> p_task_template_group_id;

Line: 85

    select null
      from jtf_objects_vl
      where object_code = p_src_obj_typ
        and trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
                           and     trunc(nvl(end_date_active,  sysdate));

Line: 342

Procedure  UPDATE_TASK_TEMPLATE_GROUP
  (
  P_API_VERSION             IN  NUMBER,
  P_INIT_MSG_LIST           IN  VARCHAR2    default fnd_api.g_false,
  P_COMMIT                  IN  VARCHAR2    default fnd_api.g_false,
  P_VALIDATE_LEVEL          IN  VARCHAR2    default fnd_api.g_valid_level_full,
  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_version           constant number := 1.0;

Line: 378

  l_api_name              constant varchar2(30) := 'UPDATE_TASK_TEMPLATE_GROUP'  ;

Line: 385

  savepoint update_task_template_group;

Line: 429

  jtf_task_temp_group_pvt.update_task_template_group
    (
    P_COMMIT,
    P_TASK_TEMPLATE_GROUP_ID,
    P_TEMPLATE_GROUP_NAME,
    P_SOURCE_OBJECT_TYPE_CODE,
    P_START_DATE_ACTIVE,
    P_END_DATE_ACTIVE,
    P_DESCRIPTION,
    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,
    X_RETURN_STATUS,
    X_MSG_COUNT,
    X_MSG_DATA,
    X_OBJECT_VERSION_NUMBER,
    P_APPLICATION_ID
    );

Line: 466

                ROLLBACK TO update_task_template_group;

Line: 473

                ROLLBACK TO update_task_template_group;

Line: 481

                ROLLBACK TO update_task_template_group;

Line: 491

  end UPDATE_TASK_TEMPLATE_GROUP;

Line: 496

Procedure  DELETE_TASK_TEMPLATE_GROUP
  (
  P_API_VERSION              IN  NUMBER,
  P_INIT_MSG_LIST           IN  VARCHAR2    default fnd_api.g_false,
  P_COMMIT                  IN  VARCHAR2    default fnd_api.g_false,
  P_VALIDATE_LEVEL          IN  VARCHAR2    default fnd_api.g_valid_level_full,
  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,
  X_OBJECT_VERSION_NUMBER    IN NUMBER
  ) is


  l_api_version           constant number := 1.0;

Line: 511

  l_api_name              constant varchar2(30) := 'DELETE_TASK_TEMPLATE_GROUP'  ;

Line: 525

  savepoint delete_task_template_group;

Line: 553

  jtf_task_temp_group_pvt.delete_task_template_group
    (
    P_COMMIT,
    P_TASK_TEMPLATE_GROUP_ID,
    X_RETURN_STATUS,
    X_MSG_COUNT,
    X_MSG_DATA
    );

Line: 568

              ROLLBACK TO delete_task_template_group;

Line: 576

              ROLLBACK TO delete_task_template_group;

Line: 584

              ROLLBACK TO delete_task_template_group;

Line: 594

end delete_task_template_group;