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

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

Line: 43


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            PARENT_TRX_ID,
            CHILD_TRX_ID,
            CONTRACT_NUMBER,
            REBOOK_STATUS,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ORG_ID,
            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_Var_Int_Process_V
     WHERE okl_var_int_process_v.id = p_id;

Line: 94


              l_vipv_rec.PROGRAM_UPDATE_DATE,
              l_vipv_rec.ORG_ID,
              l_vipv_rec.attribute_category,
              l_vipv_rec.attribute1,
              l_vipv_rec.attribute2,
              l_vipv_rec.attribute3,
              l_vipv_rec.attribute4,
              l_vipv_rec.attribute5,
              l_vipv_rec.attribute6,
              l_vipv_rec.attribute7,
              l_vipv_rec.attribute8,
              l_vipv_rec.attribute9,
              l_vipv_rec.attribute10,
              l_vipv_rec.attribute11,
              l_vipv_rec.attribute12,
              l_vipv_rec.attribute13,
              l_vipv_rec.attribute14,
              l_vipv_rec.attribute15,
              l_vipv_rec.created_by,
              l_vipv_rec.creation_date,
              l_vipv_rec.last_updated_by,
              l_vipv_rec.last_update_date,
              l_vipv_rec.last_update_login;

Line: 158


    SELECT
            ID,
            PARENT_TRX_ID,
            CHILD_TRX_ID,
            CONTRACT_NUMBER,
            REBOOK_STATUS,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ORG_ID,
            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,
            OBJECT_VERSION_NUMBER
      FROM Okl_Var_Int_Process_B
     WHERE okl_var_int_process_b.id = p_id;

Line: 208


              l_vip_rec.PROGRAM_UPDATE_DATE,
              l_vip_rec.ORG_ID,
              l_vip_rec.attribute_category,
              l_vip_rec.attribute1,
              l_vip_rec.attribute2,
              l_vip_rec.attribute3,
              l_vip_rec.attribute4,
              l_vip_rec.attribute5,
              l_vip_rec.attribute6,
              l_vip_rec.attribute7,
              l_vip_rec.attribute8,
              l_vip_rec.attribute9,
              l_vip_rec.attribute10,
              l_vip_rec.attribute11,
              l_vip_rec.attribute12,
              l_vip_rec.attribute13,
              l_vip_rec.attribute14,
              l_vip_rec.attribute15,
              l_vip_rec.created_by,
              l_vip_rec.creation_date,
              l_vip_rec.last_updated_by,
              l_vip_rec.last_update_date,
              l_vip_rec.last_update_login,
              l_vip_rec.object_version_number;

Line: 300


    IF (l_vipv_rec.program_update_date = Okl_Api.G_MISS_DATE) THEN
      l_vipv_rec.program_update_date := NULL;

Line: 360


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

Line: 363


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

Line: 366


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

Line: 588


    p_to.program_update_date := p_from.program_update_date;

Line: 608


    p_to.last_updated_by := p_from.last_updated_by;

Line: 609


    p_to.last_update_date := p_from.last_update_date;

Line: 610


    p_to.last_update_login := p_from.last_update_login;

Line: 627


    p_to.program_update_date := p_from.program_update_date;

Line: 647


    p_to.last_updated_by := p_from.last_updated_by;

Line: 648


    p_to.last_update_date := p_from.last_update_date;

Line: 649


    p_to.last_update_login := p_from.last_update_login;

Line: 812


  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_vip_rec                      IN vip_rec_type,
    x_vip_rec                      OUT NOCOPY vip_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 821


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

Line: 838


	  SELECT
	  		DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
	  		DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_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_vip_rec.request_id,
	  	   x_vip_rec.program_application_id,
	  	   x_vip_rec.program_id,
	  	   x_vip_rec.program_update_date
	  FROM dual;

Line: 872


    INSERT INTO OKL_VAR_INT_PROCESS_B(
      id,
      parent_trx_id,
      child_trx_id,
      contract_number,
      rebook_status,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      org_id,
      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,
      object_version_number)
    VALUES (
      l_vip_rec.id,
      l_vip_rec.parent_trx_id,
      l_vip_rec.child_trx_id,
      l_vip_rec.contract_number,
      l_vip_rec.rebook_status,
      l_vip_rec.request_id,
      l_vip_rec.program_application_id,
      l_vip_rec.program_id,
      l_vip_rec.program_update_date,
      l_vip_rec.org_id,
      l_vip_rec.attribute_category,
      l_vip_rec.attribute1,
      l_vip_rec.attribute2,
      l_vip_rec.attribute3,
      l_vip_rec.attribute4,
      l_vip_rec.attribute5,
      l_vip_rec.attribute6,
      l_vip_rec.attribute7,
      l_vip_rec.attribute8,
      l_vip_rec.attribute9,
      l_vip_rec.attribute10,
      l_vip_rec.attribute11,
      l_vip_rec.attribute12,
      l_vip_rec.attribute13,
      l_vip_rec.attribute14,
      l_vip_rec.attribute15,
      l_vip_rec.created_by,
      l_vip_rec.creation_date,
      l_vip_rec.last_updated_by,
      l_vip_rec.last_update_date,
      l_vip_rec.last_update_login,
      l_vip_rec.object_version_number);

Line: 973


  END insert_row;

Line: 977


  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_vipv_rec                     IN vipv_rec_type,
    x_vipv_rec                     OUT NOCOPY vipv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 987


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

Line: 1003


      l_vipv_rec.LAST_UPDATE_DATE := l_vipv_rec.CREATION_DATE;

Line: 1004


      l_vipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1005


      l_vipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1069


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vip_rec,
      lx_vip_rec
    );

Line: 1118


  END insert_row;

Line: 1122


  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_vipv_tbl                     IN vipv_tbl_type,
    x_vipv_tbl                     OUT NOCOPY vipv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1132


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

Line: 1140


        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_vipv_rec                     => p_vipv_tbl(i),
          x_vipv_rec                     => x_vipv_tbl(i));

Line: 1194


  END insert_row;

Line: 1212


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_VAR_INT_PROCESS_B
     WHERE ID = p_vip_rec.id
       AND OBJECT_VERSION_NUMBER = p_vip_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1219


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_VAR_INT_PROCESS_B
     WHERE ID = p_vip_rec.id;

Line: 1260


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1269


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1467


  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_vip_rec                      IN vip_rec_type,
    x_vip_rec                      OUT NOCOPY vip_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1476


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

Line: 1528


      IF (x_vip_rec.program_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_vip_rec.program_update_date := l_vip_rec.program_update_date;

Line: 1608


        IF (x_vip_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_vip_rec.last_updated_by := l_vip_rec.last_updated_by;

Line: 1612


        IF (x_vip_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_vip_rec.last_update_date := l_vip_rec.last_update_date;

Line: 1616


        IF (x_vip_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_vip_rec.last_update_login := l_vip_rec.last_update_login;

Line: 1666


    UPDATE OKL_VAR_INT_PROCESS_B
    SET PARENT_TRX_ID = l_def_vip_rec.parent_trx_id,
        CHILD_TRX_ID = l_def_vip_rec.child_trx_id,
        CONTRACT_NUMBER = l_def_vip_rec.contract_number,
        REBOOK_STATUS = l_def_vip_rec.rebook_status,
        REQUEST_ID = l_def_vip_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_vip_rec.program_application_id,
        PROGRAM_ID = l_def_vip_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_vip_rec.program_update_date,
        ORG_ID = l_def_vip_rec.org_id,
        ATTRIBUTE_CATEGORY = l_def_vip_rec.attribute_category,
        ATTRIBUTE1 = l_def_vip_rec.attribute1,
        ATTRIBUTE2 = l_def_vip_rec.attribute2,
        ATTRIBUTE3 = l_def_vip_rec.attribute3,
        ATTRIBUTE4 = l_def_vip_rec.attribute4,
        ATTRIBUTE5 = l_def_vip_rec.attribute5,
        ATTRIBUTE6 = l_def_vip_rec.attribute6,
        ATTRIBUTE7 = l_def_vip_rec.attribute7,
        ATTRIBUTE8 = l_def_vip_rec.attribute8,
        ATTRIBUTE9 = l_def_vip_rec.attribute9,
        ATTRIBUTE10 = l_def_vip_rec.attribute10,
        ATTRIBUTE11 = l_def_vip_rec.attribute11,
        ATTRIBUTE12 = l_def_vip_rec.attribute12,
        ATTRIBUTE13 = l_def_vip_rec.attribute13,
        ATTRIBUTE14 = l_def_vip_rec.attribute14,
        ATTRIBUTE15 = l_def_vip_rec.attribute15,
        CREATED_BY = l_def_vip_rec.created_by,
        CREATION_DATE = l_def_vip_rec.creation_date,
        LAST_UPDATED_BY = l_def_vip_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_vip_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_vip_rec.last_update_login,
        OBJECT_VERSION_NUMBER = l_def_vip_rec.object_version_number
    WHERE ID = l_def_vip_rec.id;

Line: 1734


  END update_row;

Line: 1738


  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_vipv_rec                     IN vipv_rec_type,
    x_vipv_rec                     OUT NOCOPY vipv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1748


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

Line: 1763


      l_vipv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1764


      l_vipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1765


      l_vipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1821


      IF (x_vipv_rec.program_update_date = Okl_Api.G_MISS_DATE)
      THEN
        x_vipv_rec.program_update_date := l_db_vipv_rec.program_update_date;

Line: 1901


        IF (x_vipv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_vipv_rec.last_updated_by := l_db_vipv_rec.last_updated_by;

Line: 1905


        IF (x_vipv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_vipv_rec.last_update_date := l_db_vipv_rec.last_update_date;

Line: 1909


        IF (x_vipv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_vipv_rec.last_update_login := l_db_vipv_rec.last_update_login;

Line: 1996


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vip_rec,
      lx_vip_rec
    );

Line: 2044


  END update_row;

Line: 2048


  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_vipv_tbl                     IN vipv_tbl_type,
    x_vipv_tbl                     OUT NOCOPY vipv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2058


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

Line: 2066


        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_vipv_rec                     => p_vipv_tbl(i),
          x_vipv_rec                     => x_vipv_tbl(i));

Line: 2120


  END update_row;

Line: 2128


  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_vip_rec                      IN vip_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2136


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

Line: 2151


    DELETE FROM OKL_VAR_INT_PROCESS_B
     WHERE ID = p_vip_rec.id;

Line: 2187


  END delete_row;

Line: 2191


  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_vipv_rec                     IN vipv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2200


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

Line: 2224


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

Line: 2269


  END delete_row;

Line: 2273


  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_vipv_tbl                     IN vipv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2282


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

Line: 2290


        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_vipv_rec                     => p_vipv_tbl(i));

Line: 2343


  END delete_row;