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

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

Line: 101


    SELECT
            ID,
            CHR_ID,
            CRS_ID,
            OBJECT_VERSION_NUMBER,
            START_DATE,
            END_DATE,
            DESCRIPTION,
            ASSOC_OBJECT_TYPE_CODE,
            ASSOC_OBJECT_ID,
            ASSOC_OBJECT_VERSION,
            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_Associations_V
     WHERE okl_vp_associations_v.id = p_id;

Line: 175


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

Line: 222


    SELECT
            ID,
            CHR_ID,
            CRS_ID,
            OBJECT_VERSION_NUMBER,
            START_DATE,
            END_DATE,
            DESCRIPTION,
            ASSOC_OBJECT_TYPE_CODE,
            ASSOC_OBJECT_ID,
            ASSOC_OBJECT_VERSION,
            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_Associations
     WHERE okl_vp_associations.id = p_id;

Line: 296


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

Line: 430


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

Line: 439


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

Line: 442


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

Line: 445


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

Line: 597


      SELECT 'Y'
      From FND_LOOKUPS
      Where lookup_type = 'OKL_VP_ASSOC_OBJECT_TYPES'
      And  nvl(enabled_flag,'N') = 'Y'
      And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
      And lookup_code = p_assoc_object_type_code;

Line: 824


    p_to.program_update_date := p_from.program_update_date;

Line: 827


    p_to.last_updated_by := p_from.last_updated_by;

Line: 828


    p_to.last_update_date := p_from.last_update_date;

Line: 829


    p_to.last_update_login := p_from.last_update_login;

Line: 865


    p_to.program_update_date := p_from.program_update_date;

Line: 868


    p_to.last_updated_by := p_from.last_updated_by;

Line: 869


    p_to.last_update_date := p_from.last_update_date;

Line: 870


    p_to.last_update_login := p_from.last_update_login;

Line: 1116


  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_vas_rec                      IN vas_rec_type,
    x_vas_rec                      OUT NOCOPY vas_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1125


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

Line: 1161


    INSERT INTO OKL_VP_ASSOCIATIONS(
      id,
      chr_id,
      crs_id,
      object_version_number,
      start_date,
      end_date,
      description,
      assoc_object_type_code,
      assoc_object_id,
      assoc_object_version,
      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_vas_rec.id,
      l_vas_rec.chr_id,
      l_vas_rec.crs_id,
      l_vas_rec.object_version_number,
      l_vas_rec.start_date,
      l_vas_rec.end_date,
      l_vas_rec.description,
      l_vas_rec.assoc_object_type_code,
      l_vas_rec.assoc_object_id,
      l_vas_rec.assoc_object_version,
      l_vas_rec.attribute_category,
      l_vas_rec.attribute1,
      l_vas_rec.attribute2,
      l_vas_rec.attribute3,
      l_vas_rec.attribute4,
      l_vas_rec.attribute5,
      l_vas_rec.attribute6,
      l_vas_rec.attribute7,
      l_vas_rec.attribute8,
      l_vas_rec.attribute9,
      l_vas_rec.attribute10,
      l_vas_rec.attribute11,
      l_vas_rec.attribute12,
      l_vas_rec.attribute13,
      l_vas_rec.attribute14,
      l_vas_rec.attribute15,
      l_vas_rec.request_id,
      l_vas_rec.program_application_id,
      l_vas_rec.program_id,
      l_vas_rec.program_update_date,
      l_vas_rec.created_by,
      l_vas_rec.creation_date,
      l_vas_rec.last_updated_by,
      l_vas_rec.last_update_date,
      l_vas_rec.last_update_login);

Line: 1268


  END insert_row;

Line: 1272


  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_vasv_rec                     IN vasv_rec_type,
    x_vasv_rec                     OUT NOCOPY vasv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1282


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

Line: 1298


      l_vasv_rec.LAST_UPDATE_DATE := l_vasv_rec.CREATION_DATE;

Line: 1299


      l_vasv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1300


      l_vasv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1364


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vas_rec,
      lx_vas_rec
    );

Line: 1413


  END insert_row;

Line: 1417


  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_vasv_tbl                     IN vasv_tbl_type,
    x_vasv_tbl                     OUT NOCOPY vasv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1428


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

Line: 1442


          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_vasv_rec                     => p_vasv_tbl(i),
            x_vasv_rec                     => x_vasv_tbl(i));

Line: 1510


  END insert_row;

Line: 1515


  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_vasv_tbl                     IN vasv_tbl_type,
    x_vasv_tbl                     OUT NOCOPY vasv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1525


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

Line: 1532


      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_vasv_tbl                     => p_vasv_tbl,
        x_vasv_tbl                     => x_vasv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1574


  END insert_row;

Line: 1592


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_VP_ASSOCIATIONS
     WHERE ID = p_vas_rec.id
       AND OBJECT_VERSION_NUMBER = p_vas_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1599


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_VP_ASSOCIATIONS
     WHERE ID = p_vas_rec.id;

Line: 1640


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1649


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1929


  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_vas_rec                      IN vas_rec_type,
    x_vas_rec                      OUT NOCOPY vas_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1938


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

Line: 2074


        IF (x_vas_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vas_rec.program_update_date := l_vas_rec.program_update_date;

Line: 2086


        IF (x_vas_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_vas_rec.last_updated_by := l_vas_rec.last_updated_by;

Line: 2090


        IF (x_vas_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vas_rec.last_update_date := l_vas_rec.last_update_date;

Line: 2094


        IF (x_vas_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_vas_rec.last_update_login := l_vas_rec.last_update_login;

Line: 2139


    UPDATE OKL_VP_ASSOCIATIONS
    SET CHR_ID = l_def_vas_rec.chr_id,
        CRS_ID = l_def_vas_rec.crs_id,
        OBJECT_VERSION_NUMBER = l_def_vas_rec.object_version_number,
        START_DATE = l_def_vas_rec.start_date,
        END_DATE = l_def_vas_rec.end_date,
        DESCRIPTION = l_def_vas_rec.description,
        ASSOC_OBJECT_TYPE_CODE = l_def_vas_rec.assoc_object_type_code,
        ASSOC_OBJECT_ID = l_def_vas_rec.assoc_object_id,
        ASSOC_OBJECT_VERSION = l_def_vas_rec.assoc_object_version,
        ATTRIBUTE_CATEGORY = l_def_vas_rec.attribute_category,
        ATTRIBUTE1 = l_def_vas_rec.attribute1,
        ATTRIBUTE2 = l_def_vas_rec.attribute2,
        ATTRIBUTE3 = l_def_vas_rec.attribute3,
        ATTRIBUTE4 = l_def_vas_rec.attribute4,
        ATTRIBUTE5 = l_def_vas_rec.attribute5,
        ATTRIBUTE6 = l_def_vas_rec.attribute6,
        ATTRIBUTE7 = l_def_vas_rec.attribute7,
        ATTRIBUTE8 = l_def_vas_rec.attribute8,
        ATTRIBUTE9 = l_def_vas_rec.attribute9,
        ATTRIBUTE10 = l_def_vas_rec.attribute10,
        ATTRIBUTE11 = l_def_vas_rec.attribute11,
        ATTRIBUTE12 = l_def_vas_rec.attribute12,
        ATTRIBUTE13 = l_def_vas_rec.attribute13,
        ATTRIBUTE14 = l_def_vas_rec.attribute14,
        ATTRIBUTE15 = l_def_vas_rec.attribute15,
        REQUEST_ID = l_def_vas_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_vas_rec.program_application_id,
        PROGRAM_ID = l_def_vas_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_vas_rec.program_update_date,
        CREATED_BY = l_def_vas_rec.created_by,
        CREATION_DATE = l_def_vas_rec.creation_date,
        LAST_UPDATED_BY = l_def_vas_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_vas_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_vas_rec.last_update_login
    WHERE ID = l_def_vas_rec.id;

Line: 2210


  END update_row;

Line: 2214


  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_vasv_rec                     IN vasv_rec_type,
    x_vasv_rec                     OUT NOCOPY vasv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2224


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

Line: 2239


      l_vasv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2240


      l_vasv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2241


      l_vasv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2376


        IF (x_vasv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vasv_rec.program_update_date := l_db_vasv_rec.program_update_date;

Line: 2388


        IF (x_vasv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_vasv_rec.last_updated_by := l_db_vasv_rec.last_updated_by;

Line: 2392


        IF (x_vasv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vasv_rec.last_update_date := l_db_vasv_rec.last_update_date;

Line: 2396


        IF (x_vasv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_vasv_rec.last_update_login := l_db_vasv_rec.last_update_login;

Line: 2483


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vas_rec,
      lx_vas_rec
    );

Line: 2531


  END update_row;

Line: 2535


  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_vasv_tbl                     IN vasv_tbl_type,
    x_vasv_tbl                     OUT NOCOPY vasv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2546


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

Line: 2560


          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_vasv_rec                     => p_vasv_tbl(i),
            x_vasv_rec                     => x_vasv_tbl(i));

Line: 2628


  END update_row;

Line: 2633


  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_vasv_tbl                     IN vasv_tbl_type,
    x_vasv_tbl                     OUT NOCOPY vasv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2643


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

Line: 2650


      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_vasv_tbl                     => p_vasv_tbl,
        x_vasv_tbl                     => x_vasv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2692


  END update_row;

Line: 2700


  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_vas_rec                      IN vas_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2708


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

Line: 2723


    DELETE FROM OKL_VP_ASSOCIATIONS
     WHERE ID = p_vas_rec.id;

Line: 2759


  END delete_row;

Line: 2763


  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_vasv_rec                     IN vasv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2772


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

Line: 2796


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

Line: 2841


  END delete_row;

Line: 2845


  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_vasv_tbl                     IN vasv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2855


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

Line: 2869


          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_vasv_rec                     => p_vasv_tbl(i));

Line: 2936


  END delete_row;

Line: 2941


  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_vasv_tbl                     IN vasv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2950


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

Line: 2957


      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_vasv_tbl                     => p_vasv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2998


  END delete_row;