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

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

Line: 99


    SELECT OKL_POX_SEQ.NEXTVAL INTO	l_newvalue FROM dual;

Line: 111


    SELECT
	ID,
	OBJECT_VERSION_NUMBER,
	POL_ID,
	TRANSACTION_NUMBER,
	TRANSACTION_DATE,
	TRANSACTION_TYPE,
	TRANSACTION_SUB_TYPE,
	DATE_EFFECTIVE,
	CURRENCY_CODE,
	CURRENCY_CONVERSION_TYPE,
	CURRENCY_CONVERSION_DATE,
	CURRENCY_CONVERSION_RATE,
	TRANSACTION_REASON,
	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,
	LEGAL_ENTITY_ID,
 TRANSACTION_STATUS
      FROM OKL_POOL_TRANSACTIONS_V
     WHERE OKL_POOL_TRANSACTIONS_V.id = p_id;

Line: 193


	l_poxv_rec.program_update_date,
	l_poxv_rec.created_by,
	l_poxv_rec.creation_date,
	l_poxv_rec.last_updated_by,
	l_poxv_rec.last_update_date,
	l_poxv_rec.last_update_login,
	l_poxv_rec.legal_entity_id,
 l_poxv_rec.transaction_status;

Line: 242


    SELECT
	ID,
	OBJECT_VERSION_NUMBER,
	POL_ID,
	TRANSACTION_NUMBER,
	TRANSACTION_DATE,
	TRANSACTION_TYPE,
	TRANSACTION_SUB_TYPE,
	DATE_EFFECTIVE,
	CURRENCY_CODE,
	CURRENCY_CONVERSION_TYPE,
	CURRENCY_CONVERSION_DATE,
	CURRENCY_CONVERSION_RATE,
	TRANSACTION_REASON,
	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,
	LEGAL_ENTITY_ID,
 TRANSACTION_STATUS
     FROM okl_pool_transactions
     WHERE okl_pool_transactions.id = p_id;

Line: 324


	l_pox_rec.program_update_date,
	l_pox_rec.created_by,
	l_pox_rec.creation_date,
	l_pox_rec.last_updated_by,
	l_pox_rec.last_update_date,
	l_pox_rec.last_update_login,
	l_pox_rec.legal_entity_id,
 l_pox_rec.transaction_status;

Line: 474


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

Line: 483


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

Line: 486


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

Line: 489


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

Line: 570


  SELECT '1'
    FROM OKL_POOLS
   WHERE OKL_POOLS.id = p_id;

Line: 867


      SELECT '1'
      FROM   OKL_POOL_TRANSACTIONS_V
      WHERE  transaction_number =  p_poxv_rec.transaction_number
       AND  id     <> NVL(p_poxv_rec.id,-9999);

Line: 1095


    p_to.program_update_date := p_from.program_update_date;

Line: 1098


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1099


    p_to.last_update_date := p_from.last_update_date;

Line: 1100


    p_to.last_update_login := p_from.last_update_login;

Line: 1142


    p_to.program_update_date := p_from.program_update_date;

Line: 1145


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1146


    p_to.last_update_date := p_from.last_update_date;

Line: 1147


    p_to.last_update_login := p_from.last_update_login;

Line: 1395


  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_pox_rec                      IN pox_rec_type,
    x_pox_rec                      OUT NOCOPY pox_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1404


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

Line: 1440


    INSERT INTO okl_pool_transactions(
	ID,
	OBJECT_VERSION_NUMBER,
	POL_ID,
	TRANSACTION_NUMBER,
	TRANSACTION_DATE,
	TRANSACTION_TYPE,
	TRANSACTION_SUB_TYPE,
	DATE_EFFECTIVE,
	CURRENCY_CODE,
	CURRENCY_CONVERSION_TYPE,
	CURRENCY_CONVERSION_DATE,
	CURRENCY_CONVERSION_RATE,
	TRANSACTION_REASON,
	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,
	LEGAL_ENTITY_ID,
 TRANSACTION_STATUS)
    VALUES (
	l_pox_rec.id,
	l_pox_rec.object_version_number,
	l_pox_rec.pol_id,
	l_pox_rec.transaction_number,
	l_pox_rec.transaction_date,
	l_pox_rec.transaction_type,
	l_pox_rec.transaction_sub_type,
	l_pox_rec.date_effective,
	l_pox_rec.currency_code,
	l_pox_rec.currency_conversion_type,
	l_pox_rec.currency_conversion_date,
	l_pox_rec.currency_conversion_rate,
	l_pox_rec.transaction_reason,
	l_pox_rec.attribute_category,
	l_pox_rec.attribute1,
	l_pox_rec.attribute2,
	l_pox_rec.attribute3,
	l_pox_rec.attribute4,
	l_pox_rec.attribute5,
	l_pox_rec.attribute6,
	l_pox_rec.attribute7,
	l_pox_rec.attribute8,
	l_pox_rec.attribute9,
	l_pox_rec.attribute10,
	l_pox_rec.attribute11,
	l_pox_rec.attribute12,
	l_pox_rec.attribute13,
	l_pox_rec.attribute14,
	l_pox_rec.attribute15,
	l_pox_rec.request_id,
	l_pox_rec.program_application_id,
	l_pox_rec.program_id,
	l_pox_rec.program_update_date,
	l_pox_rec.created_by,
	l_pox_rec.creation_date,
	l_pox_rec.last_updated_by,
	l_pox_rec.last_update_date,
	l_pox_rec.last_update_login,
	l_pox_rec.legal_entity_id,
 l_pox_rec.transaction_status);

Line: 1557


  END insert_row;

Line: 1561


  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_poxv_rec                     IN poxv_rec_type,
    x_poxv_rec                     OUT NOCOPY poxv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1571


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

Line: 1587


      l_poxv_rec.LAST_UPDATE_DATE := l_poxv_rec.CREATION_DATE;

Line: 1588


      l_poxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1589


      l_poxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1605


      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_poxv_rec.REQUEST_ID
            ,x_poxv_rec.PROGRAM_APPLICATION_ID
            ,x_poxv_rec.PROGRAM_ID
            ,x_poxv_rec.PROGRAM_UPDATE_DATE
      FROM DUAL;

Line: 1665


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pox_rec,
      lx_pox_rec
    );

Line: 1714


  END insert_row;

Line: 1718


  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_poxv_tbl                     IN poxv_tbl_type,
    x_poxv_tbl                     OUT NOCOPY poxv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1729


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

Line: 1743


          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_poxv_rec                     => p_poxv_tbl(i),
            x_poxv_rec                     => x_poxv_tbl(i));

Line: 1811


  END insert_row;

Line: 1816


  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_poxv_tbl                     IN poxv_tbl_type,
    x_poxv_tbl                     OUT NOCOPY poxv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1826


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

Line: 1833


      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_poxv_tbl                     => p_poxv_tbl,
        x_poxv_tbl                     => x_poxv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1875


  END insert_row;

Line: 1893


    SELECT OBJECT_VERSION_NUMBER
      FROM okl_pool_transactions
     WHERE ID = p_pox_rec.id
       AND OBJECT_VERSION_NUMBER = p_pox_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1900


    SELECT OBJECT_VERSION_NUMBER
      FROM okl_pool_transactions
     WHERE ID = p_pox_rec.id;

Line: 1941


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1950


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2230


  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_pox_rec                      IN pox_rec_type,
    x_pox_rec                      OUT NOCOPY pox_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2239


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

Line: 2388


        IF (x_pox_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_pox_rec.program_update_date := l_pox_rec.program_update_date;

Line: 2400


        IF (x_pox_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_pox_rec.last_updated_by := l_pox_rec.last_updated_by;

Line: 2404


        IF (x_pox_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_pox_rec.last_update_date := l_pox_rec.last_update_date;

Line: 2408


        IF (x_pox_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_pox_rec.last_update_login := l_pox_rec.last_update_login;

Line: 2462


    UPDATE okl_pool_transactions
    SET OBJECT_VERSION_NUMBER = l_def_pox_rec.object_version_number,
        POL_ID = l_def_pox_rec.pol_id,
        transaction_number = l_def_pox_rec.transaction_number,
        transaction_date = l_def_pox_rec.transaction_date,
        transaction_type = l_def_pox_rec.transaction_type,
        transaction_sub_type = l_def_pox_rec.transaction_sub_type,
        date_effective = l_def_pox_rec.date_effective,
        currency_code = l_def_pox_rec.currency_code,
        currency_conversion_type = l_def_pox_rec.currency_conversion_type,
        currency_conversion_date = l_def_pox_rec.currency_conversion_date,
        currency_conversion_rate = l_def_pox_rec.currency_conversion_rate,
        transaction_reason = l_def_pox_rec.transaction_reason,
        ATTRIBUTE_CATEGORY = l_def_pox_rec.attribute_category,
        ATTRIBUTE1 = l_def_pox_rec.attribute1,
        ATTRIBUTE2 = l_def_pox_rec.attribute2,
        ATTRIBUTE3 = l_def_pox_rec.attribute3,
        ATTRIBUTE4 = l_def_pox_rec.attribute4,
        ATTRIBUTE5 = l_def_pox_rec.attribute5,
        ATTRIBUTE6 = l_def_pox_rec.attribute6,
        ATTRIBUTE7 = l_def_pox_rec.attribute7,
        ATTRIBUTE8 = l_def_pox_rec.attribute8,
        ATTRIBUTE9 = l_def_pox_rec.attribute9,
        ATTRIBUTE10 = l_def_pox_rec.attribute10,
        ATTRIBUTE11 = l_def_pox_rec.attribute11,
        ATTRIBUTE12 = l_def_pox_rec.attribute12,
        ATTRIBUTE13 = l_def_pox_rec.attribute13,
        ATTRIBUTE14 = l_def_pox_rec.attribute14,
        ATTRIBUTE15 = l_def_pox_rec.attribute15,
        REQUEST_ID = l_def_pox_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_pox_rec.program_application_id,
        PROGRAM_ID = l_def_pox_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_pox_rec.program_update_date,
        CREATED_BY = l_def_pox_rec.created_by,
        CREATION_DATE = l_def_pox_rec.creation_date,
        LAST_UPDATED_BY = l_def_pox_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_pox_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_pox_rec.last_update_login,
	LEGAL_ENTITY_ID = l_def_pox_rec.legal_entity_id,
 	TRANSACTION_STATUS = l_def_pox_rec.transaction_status
    WHERE ID = l_def_pox_rec.id;

Line: 2538


  END update_row;

Line: 2542


  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_poxv_rec                     IN poxv_rec_type,
    x_poxv_rec                     OUT NOCOPY poxv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2552


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

Line: 2567


      l_poxv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2568


      l_poxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2569


      l_poxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2716


        IF (x_poxv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_poxv_rec.program_update_date := l_db_poxv_rec.program_update_date;

Line: 2728


        IF (x_poxv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_poxv_rec.last_updated_by := l_db_poxv_rec.last_updated_by;

Line: 2732


        IF (x_poxv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_poxv_rec.last_update_date := l_db_poxv_rec.last_update_date;

Line: 2736


        IF (x_poxv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_poxv_rec.last_update_login := l_db_poxv_rec.last_update_login;

Line: 2832


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pox_rec,
      lx_pox_rec
    );

Line: 2880


  END update_row;

Line: 2884


  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_poxv_tbl                     IN poxv_tbl_type,
    x_poxv_tbl                     OUT NOCOPY poxv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2895


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

Line: 2909


          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_poxv_rec                     => p_poxv_tbl(i),
            x_poxv_rec                     => x_poxv_tbl(i));

Line: 2977


  END update_row;

Line: 2982


  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_poxv_tbl                     IN poxv_tbl_type,
    x_poxv_tbl                     OUT NOCOPY poxv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2992


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

Line: 2999


      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_poxv_tbl                     => p_poxv_tbl,
        x_poxv_tbl                     => x_poxv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3041


  END update_row;

Line: 3049


  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_pox_rec                      IN pox_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3057


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

Line: 3072


    DELETE FROM okl_pool_transactions
     WHERE ID = p_pox_rec.id;

Line: 3108


  END delete_row;

Line: 3112


  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_poxv_rec                     IN poxv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3121


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

Line: 3145


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

Line: 3190


  END delete_row;

Line: 3194


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3204


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

Line: 3218


          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_poxv_rec                     => p_poxv_tbl(i));

Line: 3285


  END delete_row;

Line: 3290


  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_poxv_tbl                     IN poxv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3299


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

Line: 3306


      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_poxv_tbl                     => p_poxv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3347


  END delete_row;