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

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

Line: 159


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            IDI_TYPE,
            PROCESS_FLAG,
            PROPORTION_CONTRIBUTED,
            INDEX_NAME,
            PROGRAM_ID,
            DESCRIPTION,
            VALUE,
            DATETIME_VALID,
            DATETIME_INVALID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_UPDATE_DATE,
            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
      FROM Okl_Indx_Interfaces
     WHERE okl_indx_interfaces.id = p_id;

Line: 217


              l_idi_rec.PROGRAM_UPDATE_DATE,
              l_idi_rec.ATTRIBUTE_CATEGORY,
              l_idi_rec.ATTRIBUTE1,
              l_idi_rec.ATTRIBUTE2,
              l_idi_rec.ATTRIBUTE3,
              l_idi_rec.ATTRIBUTE4,
              l_idi_rec.ATTRIBUTE5,
              l_idi_rec.ATTRIBUTE6,
              l_idi_rec.ATTRIBUTE7,
              l_idi_rec.ATTRIBUTE8,
              l_idi_rec.ATTRIBUTE9,
              l_idi_rec.ATTRIBUTE10,
              l_idi_rec.ATTRIBUTE11,
              l_idi_rec.ATTRIBUTE12,
              l_idi_rec.ATTRIBUTE13,
              l_idi_rec.ATTRIBUTE14,
              l_idi_rec.ATTRIBUTE15,
              l_idi_rec.CREATED_BY,
              l_idi_rec.CREATION_DATE,
              l_idi_rec.LAST_UPDATED_BY,
              l_idi_rec.LAST_UPDATE_DATE,
              l_idi_rec.LAST_UPDATE_LOGIN;

Line: 259


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            IDI_TYPE,
            PROCESS_FLAG,
            PROPORTION_CONTRIBUTED,
            INDEX_NAME,
            DESCRIPTION,
            VALUE,
            DATETIME_VALID,
            DATETIME_INVALID,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            PROGRAM_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Indx_Interfaces_V
     WHERE okl_indx_interfaces_v.id = p_id;

Line: 333


              l_idiv_rec.PROGRAM_UPDATE_DATE,
              l_idiv_rec.CREATED_BY,
              l_idiv_rec.CREATION_DATE,
              l_idiv_rec.LAST_UPDATED_BY,
              l_idiv_rec.LAST_UPDATE_DATE,
              l_idiv_rec.LAST_UPDATE_LOGIN;

Line: 444


    IF (l_idiv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
      l_idiv_rec.program_update_date := NULL;

Line: 453


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

Line: 456


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

Line: 459


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

Line: 563


    p_to.program_update_date := p_from.program_update_date;

Line: 582


    p_to.last_updated_by := p_from.last_updated_by;

Line: 583


    p_to.last_update_date := p_from.last_update_date;

Line: 584


    p_to.last_update_login := p_from.last_update_login;

Line: 604


    p_to.program_update_date := p_from.program_update_date;

Line: 623


    p_to.last_updated_by := p_from.last_updated_by;

Line: 624


    p_to.last_update_date := p_from.last_update_date;

Line: 625


    p_to.last_update_login := p_from.last_update_login;

Line: 785


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_idi_rec                      IN idi_rec_type,
    x_idi_rec                      OUT NOCOPY idi_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 794


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

Line: 830


    INSERT INTO OKL_INDX_INTERFACES(
        id,
        object_version_number,
        idi_type,
        process_flag,
        proportion_contributed,
        index_name,
        program_id,
        description,
        value,
        datetime_valid,
        datetime_invalid,
        request_id,
        program_application_id,
        program_update_date,
        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)
      VALUES (
        l_idi_rec.id,
        l_idi_rec.object_version_number,
        l_idi_rec.idi_type,
        l_idi_rec.process_flag,
        l_idi_rec.proportion_contributed,
        l_idi_rec.index_name,
        l_idi_rec.program_id,
        l_idi_rec.description,
        l_idi_rec.value,
        l_idi_rec.datetime_valid,
        l_idi_rec.datetime_invalid,
        l_idi_rec.request_id,
        l_idi_rec.program_application_id,
        l_idi_rec.program_update_date,
        l_idi_rec.attribute_category,
        l_idi_rec.attribute1,
        l_idi_rec.attribute2,
        l_idi_rec.attribute3,
        l_idi_rec.attribute4,
        l_idi_rec.attribute5,
        l_idi_rec.attribute6,
        l_idi_rec.attribute7,
        l_idi_rec.attribute8,
        l_idi_rec.attribute9,
        l_idi_rec.attribute10,
        l_idi_rec.attribute11,
        l_idi_rec.attribute12,
        l_idi_rec.attribute13,
        l_idi_rec.attribute14,
        l_idi_rec.attribute15,
        l_idi_rec.created_by,
        l_idi_rec.creation_date,
        l_idi_rec.last_updated_by,
        l_idi_rec.last_update_date,
        l_idi_rec.last_update_login);

Line: 936


  END insert_row;

Line: 940


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_idiv_rec                     IN idiv_rec_type,
    x_idiv_rec                     OUT NOCOPY idiv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 950


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

Line: 966


      l_idiv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 967


      l_idiv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 968


      l_idiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 983


	SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
		DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
		DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
		DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
	INTO  x_idiv_rec.REQUEST_ID
		,x_idiv_rec.PROGRAM_APPLICATION_ID
		,x_idiv_rec.PROGRAM_ID
		,x_idiv_rec.PROGRAM_UPDATE_DATE
	FROM DUAL;

Line: 1043


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_idi_rec,
      lx_idi_rec
    );

Line: 1091


  END insert_row;

Line: 1095


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_idiv_tbl                     IN idiv_tbl_type,
    x_idiv_tbl                     OUT NOCOPY idiv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1105


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

Line: 1115


        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_idiv_rec                     => p_idiv_tbl(i),
          x_idiv_rec                     => x_idiv_tbl(i));

Line: 1164


  END insert_row;

Line: 1182


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_INDX_INTERFACES
     WHERE ID = p_idi_rec.id
       AND OBJECT_VERSION_NUMBER = p_idi_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1189


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_INDX_INTERFACES
    WHERE ID = p_idi_rec.id;

Line: 1230


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1239


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1433


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_idi_rec                      IN idi_rec_type,
    x_idi_rec                      OUT NOCOPY idi_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1442


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

Line: 1516


      IF (x_idi_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_idi_rec.program_update_date := l_idi_rec.program_update_date;

Line: 1592


      IF (x_idi_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_idi_rec.last_updated_by := l_idi_rec.last_updated_by;

Line: 1596


      IF (x_idi_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_idi_rec.last_update_date := l_idi_rec.last_update_date;

Line: 1600


      IF (x_idi_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_idi_rec.last_update_login := l_idi_rec.last_update_login;

Line: 1644


    UPDATE  OKL_INDX_INTERFACES
    SET OBJECT_VERSION_NUMBER = l_def_idi_rec.object_version_number,
        IDI_TYPE = l_def_idi_rec.idi_type,
        PROCESS_FLAG = l_def_idi_rec.process_flag,
        PROPORTION_CONTRIBUTED = l_def_idi_rec.proportion_contributed,
        INDEX_NAME = l_def_idi_rec.index_name,
        PROGRAM_ID = l_def_idi_rec.program_id,
        DESCRIPTION = l_def_idi_rec.description,
        VALUE = l_def_idi_rec.value,
        DATETIME_VALID = l_def_idi_rec.datetime_valid,
        DATETIME_INVALID = l_def_idi_rec.datetime_invalid,
        REQUEST_ID = l_def_idi_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_idi_rec.program_application_id,
        PROGRAM_UPDATE_DATE = l_def_idi_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_idi_rec.attribute_category,
        ATTRIBUTE1 = l_def_idi_rec.attribute1,
        ATTRIBUTE2 = l_def_idi_rec.attribute2,
        ATTRIBUTE3 = l_def_idi_rec.attribute3,
        ATTRIBUTE4 = l_def_idi_rec.attribute4,
        ATTRIBUTE5 = l_def_idi_rec.attribute5,
        ATTRIBUTE6 = l_def_idi_rec.attribute6,
        ATTRIBUTE7 = l_def_idi_rec.attribute7,
        ATTRIBUTE8 = l_def_idi_rec.attribute8,
        ATTRIBUTE9 = l_def_idi_rec.attribute9,
        ATTRIBUTE10 = l_def_idi_rec.attribute10,
        ATTRIBUTE11 = l_def_idi_rec.attribute11,
        ATTRIBUTE12 = l_def_idi_rec.attribute12,
        ATTRIBUTE13 = l_def_idi_rec.attribute13,
        ATTRIBUTE14 = l_def_idi_rec.attribute14,
        ATTRIBUTE15 = l_def_idi_rec.attribute15,
        CREATED_BY = l_def_idi_rec.created_by,
        CREATION_DATE = l_def_idi_rec.creation_date,
        LAST_UPDATED_BY = l_def_idi_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_idi_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_idi_rec.last_update_login
    WHERE ID = l_def_idi_rec.id;

Line: 1714


  END update_row;

Line: 1718


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_idiv_rec                     IN idiv_rec_type,
    x_idiv_rec                     OUT NOCOPY idiv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1728


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

Line: 1742


      l_idiv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1743


      l_idiv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1744


      l_idiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1880


      IF (x_idiv_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_idiv_rec.program_update_date := l_idiv_rec.program_update_date;

Line: 1892


      IF (x_idiv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_idiv_rec.last_updated_by := l_idiv_rec.last_updated_by;

Line: 1896


      IF (x_idiv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_idiv_rec.last_update_date := l_idiv_rec.last_update_date;

Line: 1900


      IF (x_idiv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_idiv_rec.last_update_login := l_idiv_rec.last_update_login;

Line: 1917


	SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
		DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
		DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
		DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
	INTO  x_idiv_rec.REQUEST_ID
		,x_idiv_rec.PROGRAM_APPLICATION_ID
		,x_idiv_rec.PROGRAM_ID
		,x_idiv_rec.PROGRAM_UPDATE_DATE
	FROM DUAL;

Line: 1981


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_idi_rec,
      lx_idi_rec
    );

Line: 2028


  END update_row;

Line: 2032


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_idiv_tbl                     IN idiv_tbl_type,
    x_idiv_tbl                     OUT NOCOPY idiv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2042


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

Line: 2052


        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_idiv_rec                     => p_idiv_tbl(i),
          x_idiv_rec                     => x_idiv_tbl(i));

Line: 2101


  END update_row;

Line: 2109


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_idi_rec                      IN idi_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2117


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

Line: 2131


    DELETE FROM OKL_INDX_INTERFACES
     WHERE ID = l_idi_rec.id;

Line: 2166


  END delete_row;

Line: 2170


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_idiv_rec                     IN idiv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2179


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

Line: 2203


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

Line: 2247


  END delete_row;

Line: 2251


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_idiv_tbl                     IN idiv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2260


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

Line: 2270


        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_idiv_rec                     => p_idiv_tbl(i));

Line: 2318


  END delete_row;