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

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

Line: 96


    SELECT
            ID,
            KHR_ID,
            PARTY_ID,
            PARTY_NAME,
            COUNTRY,
            ADDRESS1,
            ADDRESS2,
            ADDRESS3,
            ADDRESS4,
            CITY,
            POSTAL_CODE,
            STATE,
            PROVINCE,
            COUNTY,
            PO_BOX_NUMBER,
            HOUSE_NUMBER,
            STREET_SUFFIX,
            APARTMENT_NUMBER,
            STREET,
            RURAL_ROUTE_NUMBER,
            STREET_NUMBER,
            BUILDING,
            FLOOR,
            SUITE,
            ROOM,
            POSTAL_PLUS4_CODE,
            PHONE_COUNTRY_CODE,
            PHONE_AREA_CODE,
            PHONE_NUMBER,
            PHONE_EXTENSION,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_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_OPEN_INT_PRTY
     WHERE OKL_OPEN_INT_PRTY.id = p_id;

Line: 198


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

Line: 260


    SELECT
            ID,
            KHR_ID,
            PARTY_ID,
            PARTY_NAME,
            COUNTRY,
            ADDRESS1,
            ADDRESS2,
            ADDRESS3,
            ADDRESS4,
            CITY,
            POSTAL_CODE,
            STATE,
            PROVINCE,
            COUNTY,
            PO_BOX_NUMBER,
            HOUSE_NUMBER,
            STREET_SUFFIX,
            APARTMENT_NUMBER,
            STREET,
            RURAL_ROUTE_NUMBER,
            STREET_NUMBER,
            BUILDING,
            FLOOR,
            SUITE,
            ROOM,
            POSTAL_PLUS4_CODE,
            PHONE_COUNTRY_CODE,
            PHONE_AREA_CODE,
            PHONE_NUMBER,
            PHONE_EXTENSION,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_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_Open_Int_Prty
     WHERE okl_open_int_prty.id = p_id;

Line: 362


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

Line: 529


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

Line: 586


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

Line: 589


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

Line: 592


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

Line: 876


    p_to.program_update_date := p_from.program_update_date;

Line: 895


    p_to.last_updated_by := p_from.last_updated_by;

Line: 896


    p_to.last_update_date := p_from.last_update_date;

Line: 897


    p_to.last_update_login := p_from.last_update_login;

Line: 939


    p_to.program_update_date := p_from.program_update_date;

Line: 958


    p_to.last_updated_by := p_from.last_updated_by;

Line: 959


    p_to.last_update_date := p_from.last_update_date;

Line: 960


    p_to.last_update_login := p_from.last_update_login;

Line: 1201


  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_oip_rec                      IN oip_rec_type,
    x_oip_rec                      OUT NOCOPY oip_rec_type) AS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 1209


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

Line: 1245


    INSERT INTO OKL_OPEN_INT_PRTY(
      id,
      khr_id,
      party_id,
      party_name,
      country,
      address1,
      address2,
      address3,
      address4,
      city,
      postal_code,
      state,
      province,
      county,
      po_box_number,
      house_number,
      street_suffix,
      apartment_number,
      street,
      rural_route_number,
      street_number,
      building,
      floor,
      suite,
      room,
      postal_plus4_code,
      phone_country_code,
      phone_area_code,
      phone_number,
      phone_extension,
      object_version_number,
      org_id,
      request_id,
      program_application_id,
      program_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_oip_rec.id,
      l_oip_rec.khr_id,
      l_oip_rec.party_id,
      l_oip_rec.party_name,
      l_oip_rec.country,
      l_oip_rec.address1,
      l_oip_rec.address2,
      l_oip_rec.address3,
      l_oip_rec.address4,
      l_oip_rec.city,
      l_oip_rec.postal_code,
      l_oip_rec.state,
      l_oip_rec.province,
      l_oip_rec.county,
      l_oip_rec.po_box_number,
      l_oip_rec.house_number,
      l_oip_rec.street_suffix,
      l_oip_rec.apartment_number,
      l_oip_rec.street,
      l_oip_rec.rural_route_number,
      l_oip_rec.street_number,
      l_oip_rec.building,
      l_oip_rec.floor,
      l_oip_rec.suite,
      l_oip_rec.room,
      l_oip_rec.postal_plus4_code,
      l_oip_rec.phone_country_code,
      l_oip_rec.phone_area_code,
      l_oip_rec.phone_number,
      l_oip_rec.phone_extension,
      l_oip_rec.object_version_number,
      l_oip_rec.org_id,
      l_oip_rec.request_id,
      l_oip_rec.program_application_id,
      l_oip_rec.program_id,
      l_oip_rec.program_update_date,
      l_oip_rec.attribute_category,
      l_oip_rec.attribute1,
      l_oip_rec.attribute2,
      l_oip_rec.attribute3,
      l_oip_rec.attribute4,
      l_oip_rec.attribute5,
      l_oip_rec.attribute6,
      l_oip_rec.attribute7,
      l_oip_rec.attribute8,
      l_oip_rec.attribute9,
      l_oip_rec.attribute10,
      l_oip_rec.attribute11,
      l_oip_rec.attribute12,
      l_oip_rec.attribute13,
      l_oip_rec.attribute14,
      l_oip_rec.attribute15,
      l_oip_rec.created_by,
      l_oip_rec.creation_date,
      l_oip_rec.last_updated_by,
      l_oip_rec.last_update_date,
      l_oip_rec.last_update_login);

Line: 1396


  END insert_row;

Line: 1400


  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_oipv_rec                     IN oipv_rec_type,
    x_oipv_rec                     OUT NOCOPY oipv_rec_type) AS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 1409


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

Line: 1425


      l_oipv_rec.LAST_UPDATE_DATE := l_oipv_rec.CREATION_DATE;

Line: 1426


      l_oipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1427


      l_oipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1444


	  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_oipv_rec.request_id,
	  	   x_oipv_rec.program_application_id,
	  	   x_oipv_rec.program_id,
	  	   x_oipv_rec.program_update_date
	  FROM dual;

Line: 1508


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oip_rec,
      lx_oip_rec
    );

Line: 1557


  END insert_row;

Line: 1561


  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_oipv_tbl                     IN oipv_tbl_type,
    x_oipv_tbl                     OUT NOCOPY oipv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 1571


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

Line: 1585


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_oipv_rec                     => p_oipv_tbl(i),
            x_oipv_rec                     => x_oipv_tbl(i));

Line: 1653


  END insert_row;

Line: 1657


  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_oipv_tbl                     IN oipv_tbl_type,
    x_oipv_tbl                     OUT NOCOPY oipv_tbl_type) AS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 1666


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

Line: 1673


      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_oipv_tbl                     => p_oipv_tbl,
        x_oipv_tbl                     => x_oipv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1715


  END insert_row;

Line: 1731


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_OPEN_INT_PRTY
     WHERE ID = p_oip_rec.id
       AND OBJECT_VERSION_NUMBER = p_oip_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1737


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_OPEN_INT_PRTY
     WHERE ID = p_oip_rec.id;

Line: 1777


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1786


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2063


  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_oip_rec                      IN oip_rec_type,
    x_oip_rec                      OUT NOCOPY oip_rec_type) AS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 2071


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

Line: 2231


        IF (x_oip_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oip_rec.program_update_date := l_oip_rec.program_update_date;

Line: 2307


        IF (x_oip_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oip_rec.last_updated_by := l_oip_rec.last_updated_by;

Line: 2311


        IF (x_oip_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oip_rec.last_update_date := l_oip_rec.last_update_date;

Line: 2315


        IF (x_oip_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oip_rec.last_update_login := l_oip_rec.last_update_login;

Line: 2361


    UPDATE OKL_OPEN_INT_PRTY
    SET KHR_ID = l_def_oip_rec.khr_id,
        PARTY_ID = l_def_oip_rec.party_id,
        PARTY_NAME = l_def_oip_rec.party_name,
        COUNTRY = l_def_oip_rec.country,
        ADDRESS1 = l_def_oip_rec.address1,
        ADDRESS2 = l_def_oip_rec.address2,
        ADDRESS3 = l_def_oip_rec.address3,
        ADDRESS4 = l_def_oip_rec.address4,
        CITY = l_def_oip_rec.city,
        POSTAL_CODE = l_def_oip_rec.postal_code,
        STATE = l_def_oip_rec.state,
        PROVINCE = l_def_oip_rec.province,
        COUNTY = l_def_oip_rec.county,
        PO_BOX_NUMBER = l_def_oip_rec.po_box_number,
        HOUSE_NUMBER = l_def_oip_rec.house_number,
        STREET_SUFFIX = l_def_oip_rec.street_suffix,
        APARTMENT_NUMBER = l_def_oip_rec.apartment_number,
        STREET = l_def_oip_rec.street,
        RURAL_ROUTE_NUMBER = l_def_oip_rec.rural_route_number,
        STREET_NUMBER = l_def_oip_rec.street_number,
        BUILDING = l_def_oip_rec.building,
        FLOOR = l_def_oip_rec.floor,
        SUITE = l_def_oip_rec.suite,
        ROOM = l_def_oip_rec.room,
        POSTAL_PLUS4_CODE = l_def_oip_rec.postal_plus4_code,
        PHONE_COUNTRY_CODE = l_def_oip_rec.phone_country_code,
        PHONE_AREA_CODE = l_def_oip_rec.phone_area_code,
        PHONE_NUMBER = l_def_oip_rec.phone_number,
        PHONE_EXTENSION = l_def_oip_rec.phone_extension,
        OBJECT_VERSION_NUMBER = l_def_oip_rec.object_version_number,
        ORG_ID = l_def_oip_rec.org_id,
        REQUEST_ID = l_def_oip_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_oip_rec.program_application_id,
        PROGRAM_ID = l_def_oip_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_oip_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_oip_rec.attribute_category,
        ATTRIBUTE1 = l_def_oip_rec.attribute1,
        ATTRIBUTE2 = l_def_oip_rec.attribute2,
        ATTRIBUTE3 = l_def_oip_rec.attribute3,
        ATTRIBUTE4 = l_def_oip_rec.attribute4,
        ATTRIBUTE5 = l_def_oip_rec.attribute5,
        ATTRIBUTE6 = l_def_oip_rec.attribute6,
        ATTRIBUTE7 = l_def_oip_rec.attribute7,
        ATTRIBUTE8 = l_def_oip_rec.attribute8,
        ATTRIBUTE9 = l_def_oip_rec.attribute9,
        ATTRIBUTE10 = l_def_oip_rec.attribute10,
        ATTRIBUTE11 = l_def_oip_rec.attribute11,
        ATTRIBUTE12 = l_def_oip_rec.attribute12,
        ATTRIBUTE13 = l_def_oip_rec.attribute13,
        ATTRIBUTE14 = l_def_oip_rec.attribute14,
        ATTRIBUTE15 = l_def_oip_rec.attribute15,
        CREATED_BY = l_def_oip_rec.created_by,
        CREATION_DATE = l_def_oip_rec.creation_date,
        LAST_UPDATED_BY = l_def_oip_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_oip_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_oip_rec.last_update_login
    WHERE ID = l_def_oip_rec.id;

Line: 2453


  END update_row;

Line: 2457


  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_oipv_rec                     IN oipv_rec_type,
    x_oipv_rec                     OUT NOCOPY oipv_rec_type) AS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 2466


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

Line: 2481


      l_oipv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2482


      l_oipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2483


      l_oipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2642


        IF (x_oipv_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oipv_rec.program_update_date := l_db_oipv_rec.program_update_date;

Line: 2718


        IF (x_oipv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_oipv_rec.last_updated_by := l_db_oipv_rec.last_updated_by;

Line: 2722


        IF (x_oipv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_oipv_rec.last_update_date := l_db_oipv_rec.last_update_date;

Line: 2726


        IF (x_oipv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_oipv_rec.last_update_login := l_db_oipv_rec.last_update_login;

Line: 2746


        SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oipv_rec.request_id),
             NVL(DECODE(Fnd_Global.PROG_APPL_ID,   -1,NULL,Fnd_Global.PROG_APPL_ID), x_oipv_rec.program_application_id),
             NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oipv_rec.program_id),
             DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oipv_rec.program_update_date,SYSDATE)
        INTO
        x_oipv_rec.request_id,
        x_oipv_rec.program_application_id,
        x_oipv_rec.program_id,
        x_oipv_rec.program_update_date
        FROM   dual;

Line: 2827


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_oip_rec,
      lx_oip_rec
    );

Line: 2875


  END update_row;

Line: 2879


  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_oipv_tbl                     IN oipv_tbl_type,
    x_oipv_tbl                     OUT NOCOPY oipv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 2889


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

Line: 2903


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_oipv_rec                     => p_oipv_tbl(i),
            x_oipv_rec                     => x_oipv_tbl(i));

Line: 2971


  END update_row;

Line: 2975


  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_oipv_tbl                     IN oipv_tbl_type,
    x_oipv_tbl                     OUT NOCOPY oipv_tbl_type) AS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 2984


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

Line: 2991


      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_oipv_tbl                     => p_oipv_tbl,
        x_oipv_tbl                     => x_oipv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3033


  END update_row;

Line: 3040


  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_oip_rec                      IN oip_rec_type) AS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 3047


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

Line: 3061


    DELETE FROM OKL_OPEN_INT_PRTY
     WHERE ID = p_oip_rec.id;

Line: 3096


  END delete_row;

Line: 3100


  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_oipv_rec                     IN oipv_rec_type) AS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 3108


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

Line: 3132


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

Line: 3177


  END delete_row;

Line: 3181


  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_oipv_tbl                     IN oipv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 3190


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

Line: 3204


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_oipv_rec                     => p_oipv_tbl(i));

Line: 3271


  END delete_row;

Line: 3275


  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_oipv_tbl                     IN oipv_tbl_type) AS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 3283


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

Line: 3290


      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_oipv_tbl                     => p_oipv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3331


  END delete_row;