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_VRR_PVT SQL Statements

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

Line: 101


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CRS_ID,
            REASON_CODE,
            NOTE,
            DESCRIPTION,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Vp_Cr_Reasons_V
     WHERE okl_vp_cr_reasons_v.id = p_id;

Line: 167


              l_vrrv_rec.program_update_date,
              l_vrrv_rec.created_by,
              l_vrrv_rec.creation_date,
              l_vrrv_rec.last_updated_by,
              l_vrrv_rec.last_update_date,
              l_vrrv_rec.last_update_login;

Line: 214


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CRS_ID,
            REASON_CODE,
            NOTE,
            DESCRIPTION,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Vp_Cr_Reasons
     WHERE okl_vp_cr_reasons.id = p_id;

Line: 280


              l_vrr_rec.program_update_date,
              l_vrr_rec.created_by,
              l_vrr_rec.creation_date,
              l_vrr_rec.last_updated_by,
              l_vrr_rec.last_update_date,
              l_vrr_rec.last_update_login;

Line: 402


    IF (l_vrrv_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN
      l_vrrv_rec.program_update_date := NULL;

Line: 411


    IF (l_vrrv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_vrrv_rec.last_updated_by := NULL;

Line: 414


    IF (l_vrrv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_vrrv_rec.last_update_date := NULL;

Line: 417


    IF (l_vrrv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_vrrv_rec.last_update_login := NULL;

Line: 483


    SELECT 'X'
      FROM okl_vp_change_requests
     WHERE id = p_crs_id;

Line: 523


    SELECT 'X'
      FROM fnd_lookups
     WHERE lookup_type = 'OKL_VP_CR_REASONS'
       AND lookup_code = p_reason_code;

Line: 693


    p_to.program_update_date := p_from.program_update_date;

Line: 696


    p_to.last_updated_by := p_from.last_updated_by;

Line: 697


    p_to.last_update_date := p_from.last_update_date;

Line: 698


    p_to.last_update_login := p_from.last_update_login;

Line: 730


    p_to.program_update_date := p_from.program_update_date;

Line: 733


    p_to.last_updated_by := p_from.last_updated_by;

Line: 734


    p_to.last_update_date := p_from.last_update_date;

Line: 735


    p_to.last_update_login := p_from.last_update_login;

Line: 981


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vrr_rec                      IN vrr_rec_type,
    x_vrr_rec                      OUT NOCOPY vrr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 990


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

Line: 1026


    INSERT INTO OKL_VP_CR_REASONS(
      id,
      object_version_number,
      crs_id,
      reason_code,
      note,
      description,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_vrr_rec.id,
      l_vrr_rec.object_version_number,
      l_vrr_rec.crs_id,
      l_vrr_rec.reason_code,
      l_vrr_rec.note,
      l_vrr_rec.description,
      l_vrr_rec.attribute_category,
      l_vrr_rec.attribute1,
      l_vrr_rec.attribute2,
      l_vrr_rec.attribute3,
      l_vrr_rec.attribute4,
      l_vrr_rec.attribute5,
      l_vrr_rec.attribute6,
      l_vrr_rec.attribute7,
      l_vrr_rec.attribute8,
      l_vrr_rec.attribute9,
      l_vrr_rec.attribute10,
      l_vrr_rec.attribute11,
      l_vrr_rec.attribute12,
      l_vrr_rec.attribute13,
      l_vrr_rec.attribute14,
      l_vrr_rec.attribute15,
      l_vrr_rec.request_id,
      l_vrr_rec.program_application_id,
      l_vrr_rec.program_id,
      l_vrr_rec.program_update_date,
      l_vrr_rec.created_by,
      l_vrr_rec.creation_date,
      l_vrr_rec.last_updated_by,
      l_vrr_rec.last_update_date,
      l_vrr_rec.last_update_login);

Line: 1125


  END insert_row;

Line: 1129


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vrrv_rec                     IN vrrv_rec_type,
    x_vrrv_rec                     OUT NOCOPY vrrv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1139


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

Line: 1155


      l_vrrv_rec.LAST_UPDATE_DATE := l_vrrv_rec.CREATION_DATE;

Line: 1156


      l_vrrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1157


      l_vrrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1221


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vrr_rec,
      lx_vrr_rec
    );

Line: 1270


  END insert_row;

Line: 1274


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vrrv_tbl                     IN vrrv_tbl_type,
    x_vrrv_tbl                     OUT NOCOPY vrrv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1285


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

Line: 1299


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_vrrv_rec                     => p_vrrv_tbl(i),
            x_vrrv_rec                     => x_vrrv_tbl(i));

Line: 1367


  END insert_row;

Line: 1372


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vrrv_tbl                     IN vrrv_tbl_type,
    x_vrrv_tbl                     OUT NOCOPY vrrv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1382


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

Line: 1389


      insert_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_vrrv_tbl                     => p_vrrv_tbl,
        x_vrrv_tbl                     => x_vrrv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1431


  END insert_row;

Line: 1449


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_VP_CR_REASONS
     WHERE ID = p_vrr_rec.id
       AND OBJECT_VERSION_NUMBER = p_vrr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1456


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_VP_CR_REASONS
     WHERE ID = p_vrr_rec.id;

Line: 1497


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1506


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1786


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vrr_rec                      IN vrr_rec_type,
    x_vrr_rec                      OUT NOCOPY vrr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1795


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

Line: 1915


        IF (x_vrr_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vrr_rec.program_update_date := l_vrr_rec.program_update_date;

Line: 1927


        IF (x_vrr_rec.last_updated_by = OKL_API.G_MISS_NUM OR x_vrr_rec.last_updated_by IS NULL)
        THEN
          x_vrr_rec.last_updated_by := l_vrr_rec.last_updated_by;

Line: 1931


        IF (x_vrr_rec.last_update_date = OKL_API.G_MISS_DATE OR x_vrr_rec.last_update_date IS NULL)
        THEN
          x_vrr_rec.last_update_date := l_vrr_rec.last_update_date;

Line: 1935


        IF (x_vrr_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_vrr_rec.last_update_login := l_vrr_rec.last_update_login;

Line: 1981


    UPDATE OKL_VP_CR_REASONS
    SET OBJECT_VERSION_NUMBER = l_def_vrr_rec.object_version_number,
        CRS_ID = l_def_vrr_rec.crs_id,
        REASON_CODE = l_def_vrr_rec.reason_code,
        NOTE = l_def_vrr_rec.note,
        DESCRIPTION = l_def_vrr_rec.description,
        ATTRIBUTE_CATEGORY = l_def_vrr_rec.attribute_category,
        ATTRIBUTE1 = l_def_vrr_rec.attribute1,
        ATTRIBUTE2 = l_def_vrr_rec.attribute2,
        ATTRIBUTE3 = l_def_vrr_rec.attribute3,
        ATTRIBUTE4 = l_def_vrr_rec.attribute4,
        ATTRIBUTE5 = l_def_vrr_rec.attribute5,
        ATTRIBUTE6 = l_def_vrr_rec.attribute6,
        ATTRIBUTE7 = l_def_vrr_rec.attribute7,
        ATTRIBUTE8 = l_def_vrr_rec.attribute8,
        ATTRIBUTE9 = l_def_vrr_rec.attribute9,
        ATTRIBUTE10 = l_def_vrr_rec.attribute10,
        ATTRIBUTE11 = l_def_vrr_rec.attribute11,
        ATTRIBUTE12 = l_def_vrr_rec.attribute12,
        ATTRIBUTE13 = l_def_vrr_rec.attribute13,
        ATTRIBUTE14 = l_def_vrr_rec.attribute14,
        ATTRIBUTE15 = l_def_vrr_rec.attribute15,
        REQUEST_ID = l_def_vrr_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_vrr_rec.program_application_id,
        PROGRAM_ID = l_def_vrr_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_vrr_rec.program_update_date,
        CREATED_BY = l_def_vrr_rec.created_by,
        CREATION_DATE = l_def_vrr_rec.creation_date,
        LAST_UPDATED_BY = l_def_vrr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_vrr_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_vrr_rec.last_update_login
    WHERE ID = l_def_vrr_rec.id;

Line: 2048


  END update_row;

Line: 2052


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vrrv_rec                     IN vrrv_rec_type,
    x_vrrv_rec                     OUT NOCOPY vrrv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2062


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

Line: 2077


      l_vrrv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2078


      l_vrrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2079


      l_vrrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2194


        IF (x_vrrv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vrrv_rec.program_update_date := l_db_vrrv_rec.program_update_date;

Line: 2206


        IF (x_vrrv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_vrrv_rec.last_updated_by := l_db_vrrv_rec.last_updated_by;

Line: 2210


        IF (x_vrrv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vrrv_rec.last_update_date := l_db_vrrv_rec.last_update_date;

Line: 2214


        IF (x_vrrv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_vrrv_rec.last_update_login := l_db_vrrv_rec.last_update_login;

Line: 2300


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vrr_rec,
      lx_vrr_rec
    );

Line: 2348


  END update_row;

Line: 2352


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vrrv_tbl                     IN vrrv_tbl_type,
    x_vrrv_tbl                     OUT NOCOPY vrrv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2363


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

Line: 2377


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_vrrv_rec                     => p_vrrv_tbl(i),
            x_vrrv_rec                     => x_vrrv_tbl(i));

Line: 2445


  END update_row;

Line: 2450


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vrrv_tbl                     IN vrrv_tbl_type,
    x_vrrv_tbl                     OUT NOCOPY vrrv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2460


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

Line: 2467


      update_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_vrrv_tbl                     => p_vrrv_tbl,
        x_vrrv_tbl                     => x_vrrv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2509


  END update_row;

Line: 2517


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vrr_rec                      IN vrr_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2525


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

Line: 2540


    DELETE FROM OKL_VP_CR_REASONS
     WHERE ID = p_vrr_rec.id;

Line: 2576


  END delete_row;

Line: 2580


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vrrv_rec                     IN vrrv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2589


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

Line: 2613


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vrr_rec
    );

Line: 2658


  END delete_row;

Line: 2662


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vrrv_tbl                     IN vrrv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2672


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

Line: 2686


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_vrrv_rec                     => p_vrrv_tbl(i));

Line: 2753


  END delete_row;

Line: 2758


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_vrrv_tbl                     IN vrrv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2767


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

Line: 2774


      delete_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_vrrv_tbl                     => p_vrrv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2815


  END delete_row;