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

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

Line: 12


      select
         OKC_RG_ROLE_DEFS_S1.nextval
      from
         dual;

Line: 18


      select
	 nvl(max(id), 11000) + 1
      from
         OKC_RG_ROLE_DEFS_V
      where
         id >= 11000 AND id < 50000;

Line: 35


    SELECT OKC_RG_ROLE_DEFS_S1.nextval
      INTO l_id
      FROM DUAL;

Line: 75


    SELECT
            ID,
            SRD_ID,
            SRE_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            SUBJECT_OBJECT_FLAG,
            OPTIONAL_YN,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ACCESS_LEVEL
      FROM Okc_Rg_Role_Defs
     WHERE okc_rg_role_defs.id  = p_id;

Line: 119


              l_rrd_rec.LAST_UPDATED_BY,
              l_rrd_rec.LAST_UPDATE_DATE,
              l_rrd_rec.SUBJECT_OBJECT_FLAG,
              l_rrd_rec.OPTIONAL_YN,
              l_rrd_rec.LAST_UPDATE_LOGIN,
              l_rrd_rec.ATTRIBUTE_CATEGORY,
              l_rrd_rec.ATTRIBUTE1,
              l_rrd_rec.ATTRIBUTE2,
              l_rrd_rec.ATTRIBUTE3,
              l_rrd_rec.ATTRIBUTE4,
              l_rrd_rec.ATTRIBUTE5,
              l_rrd_rec.ATTRIBUTE6,
              l_rrd_rec.ATTRIBUTE7,
              l_rrd_rec.ATTRIBUTE8,
              l_rrd_rec.ATTRIBUTE9,
              l_rrd_rec.ATTRIBUTE10,
              l_rrd_rec.ATTRIBUTE11,
              l_rrd_rec.ATTRIBUTE12,
              l_rrd_rec.ATTRIBUTE13,
              l_rrd_rec.ATTRIBUTE14,
              l_rrd_rec.ATTRIBUTE15,
              l_rrd_rec.ACCESS_LEVEL;

Line: 161


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SRD_ID,
            SRE_ID,
            OPTIONAL_YN,
            SUBJECT_OBJECT_FLAG,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ACCESS_LEVEL
      FROM Okc_Rg_Role_Defs_V
     WHERE okc_rg_role_defs_v.id = p_id;

Line: 223


              l_rrdv_rec.LAST_UPDATED_BY,
              l_rrdv_rec.LAST_UPDATE_DATE,
              l_rrdv_rec.LAST_UPDATE_LOGIN,
              l_rrdv_rec.ACCESS_LEVEL;

Line: 317


    IF (l_rrdv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_rrdv_rec.last_updated_by := NULL;

Line: 320


    IF (l_rrdv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_rrdv_rec.last_update_date := NULL;

Line: 323


    IF (l_rrdv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_rrdv_rec.last_update_login := NULL;

Line: 659


      SELECT 'x'
        FROM Okc_Subclass_Roles_V
       WHERE okc_subclass_roles_v.id = p_id;

Line: 663


      SELECT 'x'
        FROM Okc_Subclass_Rg_Defs_V
       WHERE okc_subclass_rg_defs_v.id = p_id;

Line: 706


      SELECT 'x'
        FROM Okc_Rg_Role_Defs_V
       WHERE srd_id = p_srd_id
         AND sre_id = p_sre_id
         AND ((p_id IS NULL)
          OR  (p_id IS NOT NULL
         AND   id <> p_id));

Line: 775


    p_to.last_updated_by := p_from.last_updated_by;

Line: 776


    p_to.last_update_date := p_from.last_update_date;

Line: 779


    p_to.last_update_login := p_from.last_update_login;

Line: 809


    p_to.last_updated_by := p_from.last_updated_by;

Line: 810


    p_to.last_update_date := p_from.last_update_date;

Line: 813


    p_to.last_update_login := p_from.last_update_login;

Line: 983


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrd_rec                      IN rrd_rec_type,
    x_rrd_rec                      OUT NOCOPY rrd_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 992


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

Line: 1028


    INSERT INTO OKC_RG_ROLE_DEFS(
        id,
        srd_id,
        sre_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        subject_object_flag,
        optional_yn,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        access_level)
      VALUES (
        l_rrd_rec.id,
        l_rrd_rec.srd_id,
        l_rrd_rec.sre_id,
        l_rrd_rec.object_version_number,
        l_rrd_rec.created_by,
        l_rrd_rec.creation_date,
        l_rrd_rec.last_updated_by,
        l_rrd_rec.last_update_date,
        l_rrd_rec.subject_object_flag,
        l_rrd_rec.optional_yn,
        l_rrd_rec.last_update_login,
        l_rrd_rec.attribute_category,
        l_rrd_rec.attribute1,
        l_rrd_rec.attribute2,
        l_rrd_rec.attribute3,
        l_rrd_rec.attribute4,
        l_rrd_rec.attribute5,
        l_rrd_rec.attribute6,
        l_rrd_rec.attribute7,
        l_rrd_rec.attribute8,
        l_rrd_rec.attribute9,
        l_rrd_rec.attribute10,
        l_rrd_rec.attribute11,
        l_rrd_rec.attribute12,
        l_rrd_rec.attribute13,
        l_rrd_rec.attribute14,
        l_rrd_rec.attribute15,
        l_rrd_rec.access_level);

Line: 1120


  END insert_row;

Line: 1124


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrdv_rec                     IN rrdv_rec_type,
    x_rrdv_rec                     OUT NOCOPY rrdv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1134


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

Line: 1150


      l_rrdv_rec.LAST_UPDATE_DATE := l_rrdv_rec.CREATION_DATE;

Line: 1151


      l_rrdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1152


      l_rrdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1216


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rrd_rec,
      lx_rrd_rec
    );

Line: 1264


  END insert_row;

Line: 1268


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrdv_tbl                     IN rrdv_tbl_type,
    x_rrdv_tbl                     OUT NOCOPY rrdv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1278


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

Line: 1287


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_rrdv_rec                     => p_rrdv_tbl(i),
          x_rrdv_rec                     => x_rrdv_tbl(i));

Line: 1330


  END insert_row;

Line: 1348


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_RG_ROLE_DEFS
     WHERE ID = p_rrd_rec.id
       AND OBJECT_VERSION_NUMBER = p_rrd_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1355


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_RG_ROLE_DEFS
    WHERE ID = p_rrd_rec.id;

Line: 1396


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1405


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1592


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrd_rec                      IN rrd_rec_type,
    x_rrd_rec                      OUT NOCOPY rrd_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1601


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

Line: 1647


      IF (x_rrd_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rrd_rec.last_updated_by := l_rrd_rec.last_updated_by;

Line: 1651


      IF (x_rrd_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rrd_rec.last_update_date := l_rrd_rec.last_update_date;

Line: 1663


      IF (x_rrd_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rrd_rec.last_update_login := l_rrd_rec.last_update_login;

Line: 1775


    UPDATE  OKC_RG_ROLE_DEFS
    SET SRD_ID = l_def_rrd_rec.srd_id,
        SRE_ID = l_def_rrd_rec.sre_id,
        OBJECT_VERSION_NUMBER = l_def_rrd_rec.object_version_number,
        CREATED_BY = l_def_rrd_rec.created_by,
        CREATION_DATE = l_def_rrd_rec.creation_date,
        LAST_UPDATED_BY = l_def_rrd_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_rrd_rec.last_update_date,
        SUBJECT_OBJECT_FLAG = l_def_rrd_rec.subject_object_flag,
        OPTIONAL_YN = l_def_rrd_rec.optional_yn,
        LAST_UPDATE_LOGIN = l_def_rrd_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_rrd_rec.attribute_category,
        ATTRIBUTE1 = l_def_rrd_rec.attribute1,
        ATTRIBUTE2 = l_def_rrd_rec.attribute2,
        ATTRIBUTE3 = l_def_rrd_rec.attribute3,
        ATTRIBUTE4 = l_def_rrd_rec.attribute4,
        ATTRIBUTE5 = l_def_rrd_rec.attribute5,
        ATTRIBUTE6 = l_def_rrd_rec.attribute6,
        ATTRIBUTE7 = l_def_rrd_rec.attribute7,
        ATTRIBUTE8 = l_def_rrd_rec.attribute8,
        ATTRIBUTE9 = l_def_rrd_rec.attribute9,
        ATTRIBUTE10 = l_def_rrd_rec.attribute10,
        ATTRIBUTE11 = l_def_rrd_rec.attribute11,
        ATTRIBUTE12 = l_def_rrd_rec.attribute12,
        ATTRIBUTE13 = l_def_rrd_rec.attribute13,
        ATTRIBUTE14 = l_def_rrd_rec.attribute14,
        ATTRIBUTE15 = l_def_rrd_rec.attribute15,
        ACCESS_LEVEL = l_def_rrd_rec.access_level
    WHERE ID = l_def_rrd_rec.id;

Line: 1838


  END update_row;

Line: 1842


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrdv_rec                     IN rrdv_rec_type,
    x_rrdv_rec                     OUT NOCOPY rrdv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1852


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

Line: 1866


      l_rrdv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1867


      l_rrdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1868


      l_rrdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1984


      IF (x_rrdv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rrdv_rec.last_updated_by := l_rrdv_rec.last_updated_by;

Line: 1988


      IF (x_rrdv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rrdv_rec.last_update_date := l_rrdv_rec.last_update_date;

Line: 1992


      IF (x_rrdv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rrdv_rec.last_update_login := l_rrdv_rec.last_update_login;

Line: 2067


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rrd_rec,
      lx_rrd_rec
    );

Line: 2114


  END update_row;

Line: 2118


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrdv_tbl                     IN rrdv_tbl_type,
    x_rrdv_tbl                     OUT NOCOPY rrdv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2128


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

Line: 2137


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_rrdv_rec                     => p_rrdv_tbl(i),
          x_rrdv_rec                     => x_rrdv_tbl(i));

Line: 2180


  END update_row;

Line: 2188


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrd_rec                      IN rrd_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2196


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

Line: 2210


    DELETE FROM OKC_RG_ROLE_DEFS
     WHERE ID = l_rrd_rec.id;

Line: 2245


  END delete_row;

Line: 2249


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrdv_rec                     IN rrdv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2258


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

Line: 2282


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rrd_rec
    );

Line: 2326


  END delete_row;

Line: 2330


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrdv_tbl                     IN rrdv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2339


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

Line: 2348


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_rrdv_rec                     => p_rrdv_tbl(i));

Line: 2390


  END delete_row;