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

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

Line: 101


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            POT_ID,
            KHR_ID,
            POOL_NUMBER,
            DESCRIPTION,
            SHORT_DESCRIPTION,
            CURRENCY_CODE,
            TOTAL_PRINCIPAL_AMOUNT,
            TOTAL_RECEIVABLE_AMOUNT,
            SECURITIES_CREDIT_RATING,
            DATE_CREATED,
            DATE_LAST_UPDATED,
            DATE_LAST_RECONCILED,
            DATE_TOTAL_PRINCIPAL_CALC,
            STATUS_CODE,
			DISPLAY_IN_LEASE_CENTER,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            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
      FROM OKL_POOLS
     WHERE OKL_POOLS.id = p_id;

Line: 167


	l_polv_rec.date_last_updated,
	l_polv_rec.date_last_reconciled,
	l_polv_rec.date_total_principal_calc,
	l_polv_rec.status_code,
	l_polv_rec.display_in_lease_center,
	l_polv_rec.attribute_category,
	l_polv_rec.attribute1,
	l_polv_rec.attribute2,
	l_polv_rec.attribute3,
	l_polv_rec.attribute4,
	l_polv_rec.attribute5,
	l_polv_rec.attribute6,
	l_polv_rec.attribute7,
	l_polv_rec.attribute8,
	l_polv_rec.attribute9,
	l_polv_rec.attribute10,
	l_polv_rec.attribute11,
	l_polv_rec.attribute12,
	l_polv_rec.attribute13,
	l_polv_rec.attribute14,
	l_polv_rec.attribute15,
	l_polv_rec.org_id,
	l_polv_rec.request_id,
	l_polv_rec.program_application_id,
	l_polv_rec.program_id,
	l_polv_rec.program_update_date,
	l_polv_rec.created_by,
	l_polv_rec.creation_date,
	l_polv_rec.last_updated_by,
	l_polv_rec.last_update_date,
	l_polv_rec.last_update_login,
	l_polv_rec.legal_entity_id;

Line: 240


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            POT_ID,
            KHR_ID,
            POOL_NUMBER,
            DESCRIPTION,
            SHORT_DESCRIPTION,
            CURRENCY_CODE,
            TOTAL_PRINCIPAL_AMOUNT,
            TOTAL_RECEIVABLE_AMOUNT,
            SECURITIES_CREDIT_RATING,
            DATE_CREATED,
            DATE_LAST_UPDATED,
            DATE_LAST_RECONCILED,
            DATE_TOTAL_PRINCIPAL_CALC,
            STATUS_CODE,
			DISPLAY_IN_LEASE_CENTER,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            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
     FROM okl_pools
     WHERE okl_pools.id = p_id;

Line: 306


	l_pol_rec.date_last_updated,
	l_pol_rec.date_last_reconciled,
	l_pol_rec.date_total_principal_calc,
	l_pol_rec.status_code,
	l_pol_rec.display_in_lease_center,
	l_pol_rec.attribute_category,
	l_pol_rec.attribute1,
	l_pol_rec.attribute2,
	l_pol_rec.attribute3,
	l_pol_rec.attribute4,
	l_pol_rec.attribute5,
	l_pol_rec.attribute6,
	l_pol_rec.attribute7,
	l_pol_rec.attribute8,
	l_pol_rec.attribute9,
	l_pol_rec.attribute10,
	l_pol_rec.attribute11,
	l_pol_rec.attribute12,
	l_pol_rec.attribute13,
	l_pol_rec.attribute14,
	l_pol_rec.attribute15,
	l_pol_rec.org_id,
	l_pol_rec.request_id,
	l_pol_rec.program_application_id,
	l_pol_rec.program_id,
	l_pol_rec.program_update_date,
	l_pol_rec.created_by,
	l_pol_rec.creation_date,
	l_pol_rec.last_updated_by,
	l_pol_rec.last_update_date,
	l_pol_rec.last_update_login,
	l_pol_rec.legal_entity_id;

Line: 417


    IF (l_polv_rec.date_last_updated = OKL_API.G_MISS_DATE ) THEN
      l_polv_rec.date_last_updated := NULL;

Line: 495


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

Line: 504


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

Line: 507


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

Line: 510


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

Line: 587


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

Line: 634


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

Line: 715


  SELECT '1'
    FROM FND_CURRENCIES_VL
   WHERE FND_CURRENCIES_VL.currency_code = p_code; -- Bug 6982517. Changed to use the parameter.

Line: 832


  PROCEDURE validate_date_last_updated(
    x_return_status                OUT NOCOPY VARCHAR2,
    p_date_last_updated                   IN DATE) IS
  BEGIN
    x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line: 837


    IF (p_date_last_updated = OKL_API.G_MISS_DATE OR
        p_date_last_updated IS NULL)
    THEN
      OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'date_last_updated');

Line: 855


  END validate_date_last_updated;

Line: 938


    validate_date_last_updated(x_return_status, p_polv_rec.date_last_updated);

Line: 990


  SELECT '1'
  FROM OKL_POOLS
  WHERE  pool_number = p_rec.pool_number
    AND  id     <> NVL(p_rec.id,-9999);

Line: 1097


    p_to.date_last_updated := p_from.date_last_updated;

Line: 1122


    p_to.program_update_date := p_from.program_update_date;

Line: 1125


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1126


    p_to.last_update_date := p_from.last_update_date;

Line: 1127


    p_to.last_update_login := p_from.last_update_login;

Line: 1147


    p_to.date_last_updated := p_from.date_last_updated;

Line: 1172


    p_to.program_update_date := p_from.program_update_date;

Line: 1175


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1176


    p_to.last_update_date := p_from.last_update_date;

Line: 1177


    p_to.last_update_login := p_from.last_update_login;

Line: 1424


  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_pol_rec                      IN pol_rec_type,
    x_pol_rec                      OUT NOCOPY pol_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1433


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

Line: 1469


    INSERT INTO okl_pools(
	ID,
	OBJECT_VERSION_NUMBER,
	POT_ID,
	KHR_ID,
	POOL_NUMBER,
	DESCRIPTION,
	SHORT_DESCRIPTION,
	CURRENCY_CODE,
	TOTAL_PRINCIPAL_AMOUNT,
	TOTAL_RECEIVABLE_AMOUNT,
	SECURITIES_CREDIT_RATING,
	DATE_CREATED,
	DATE_LAST_UPDATED,
	DATE_LAST_RECONCILED,
	DATE_TOTAL_PRINCIPAL_CALC,
	STATUS_CODE,
	DISPLAY_IN_LEASE_CENTER,
	ATTRIBUTE_CATEGORY,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,
	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
	ATTRIBUTE15,
	ORG_ID,
	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)
    VALUES (
	l_pol_rec.id,
	l_pol_rec.object_version_number,
	l_pol_rec.pot_id,
	l_pol_rec.khr_id,
	l_pol_rec.pool_number,
	l_pol_rec.description,
	l_pol_rec.short_description,
	l_pol_rec.currency_code,
	l_pol_rec.total_principal_amount,
	l_pol_rec.total_receivable_amount,
	l_pol_rec.securities_credit_rating,
	l_pol_rec.date_created,
	l_pol_rec.date_last_updated,
	l_pol_rec.date_last_reconciled,
	l_pol_rec.date_total_principal_calc,
	l_pol_rec.status_code,
	l_pol_rec.display_in_lease_center,
	l_pol_rec.attribute_category,
	l_pol_rec.attribute1,
	l_pol_rec.attribute2,
	l_pol_rec.attribute3,
	l_pol_rec.attribute4,
	l_pol_rec.attribute5,
	l_pol_rec.attribute6,
	l_pol_rec.attribute7,
	l_pol_rec.attribute8,
	l_pol_rec.attribute9,
	l_pol_rec.attribute10,
	l_pol_rec.attribute11,
	l_pol_rec.attribute12,
	l_pol_rec.attribute13,
	l_pol_rec.attribute14,
	l_pol_rec.attribute15,
	l_pol_rec.org_id,
	l_pol_rec.request_id,
	l_pol_rec.program_application_id,
	l_pol_rec.program_id,
	l_pol_rec.program_update_date,
	l_pol_rec.created_by,
	l_pol_rec.creation_date,
	l_pol_rec.last_updated_by,
	l_pol_rec.last_update_date,
	l_pol_rec.last_update_login,
	l_pol_rec.legal_entity_id);

Line: 1594


  END insert_row;

Line: 1598


  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_polv_rec                     IN polv_rec_type,
    x_polv_rec                     OUT NOCOPY polv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1608


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

Line: 1624


      l_polv_rec.LAST_UPDATE_DATE := l_polv_rec.CREATION_DATE;

Line: 1625


      l_polv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1626


      l_polv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1642


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

Line: 1702


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pol_rec,
      lx_pol_rec
    );

Line: 1751


  END insert_row;

Line: 1755


  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_polv_tbl                     IN polv_tbl_type,
    x_polv_tbl                     OUT NOCOPY polv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1766


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

Line: 1780


          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_polv_rec                     => p_polv_tbl(i),
            x_polv_rec                     => x_polv_tbl(i));

Line: 1848


  END insert_row;

Line: 1853


  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_polv_tbl                     IN polv_tbl_type,
    x_polv_tbl                     OUT NOCOPY polv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1863


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

Line: 1870


      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_polv_tbl                     => p_polv_tbl,
        x_polv_tbl                     => x_polv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1912


  END insert_row;

Line: 1930


    SELECT OBJECT_VERSION_NUMBER
      FROM okl_pools
     WHERE ID = p_pol_rec.id
       AND OBJECT_VERSION_NUMBER = p_pol_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1937


    SELECT OBJECT_VERSION_NUMBER
      FROM okl_pools
     WHERE ID = p_pol_rec.id;

Line: 1978


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1987


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2267


  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_pol_rec                      IN pol_rec_type,
    x_pol_rec                      OUT NOCOPY pol_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2276


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

Line: 2344


        IF (x_pol_rec.date_last_updated = OKL_API.G_MISS_DATE)
        THEN
          x_pol_rec.date_last_updated := l_pol_rec.date_last_updated;

Line: 2446


        IF (x_pol_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_pol_rec.program_update_date := l_pol_rec.program_update_date;

Line: 2458


        IF (x_pol_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_pol_rec.last_updated_by := l_pol_rec.last_updated_by;

Line: 2462


        IF (x_pol_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_pol_rec.last_update_date := l_pol_rec.last_update_date;

Line: 2466


        IF (x_pol_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_pol_rec.last_update_login := l_pol_rec.last_update_login;

Line: 2515


    UPDATE okl_pools
    SET OBJECT_VERSION_NUMBER = l_def_pol_rec.object_version_number,
        POT_ID = l_def_pol_rec.pot_id,
        KHR_ID = l_def_pol_rec.khr_id,
        POOL_NUMBER = l_def_pol_rec.pool_number,
        DESCRIPTION = l_def_pol_rec.description,
        SHORT_DESCRIPTION = l_def_pol_rec.short_description,
        CURRENCY_CODE = l_def_pol_rec.currency_code,
        TOTAL_PRINCIPAL_AMOUNT = l_def_pol_rec.total_principal_amount,
        TOTAL_RECEIVABLE_AMOUNT = l_def_pol_rec.total_receivable_amount,
        SECURITIES_CREDIT_RATING = l_def_pol_rec.securities_credit_rating,
        DATE_CREATED = l_def_pol_rec.date_created,
        DATE_LAST_UPDATED = l_def_pol_rec.date_last_updated,
        DATE_LAST_RECONCILED = l_def_pol_rec.date_last_reconciled,
        DATE_TOTAL_PRINCIPAL_CALC = l_def_pol_rec.date_total_principal_calc,
        STATUS_CODE = l_def_pol_rec.status_code,
        DISPLAY_IN_LEASE_CENTER = l_def_pol_rec.display_in_lease_center,
        ATTRIBUTE_CATEGORY = l_def_pol_rec.attribute_category,
        ATTRIBUTE1 = l_def_pol_rec.attribute1,
        ATTRIBUTE2 = l_def_pol_rec.attribute2,
        ATTRIBUTE3 = l_def_pol_rec.attribute3,
        ATTRIBUTE4 = l_def_pol_rec.attribute4,
        ATTRIBUTE5 = l_def_pol_rec.attribute5,
        ATTRIBUTE6 = l_def_pol_rec.attribute6,
        ATTRIBUTE7 = l_def_pol_rec.attribute7,
        ATTRIBUTE8 = l_def_pol_rec.attribute8,
        ATTRIBUTE9 = l_def_pol_rec.attribute9,
        ATTRIBUTE10 = l_def_pol_rec.attribute10,
        ATTRIBUTE11 = l_def_pol_rec.attribute11,
        ATTRIBUTE12 = l_def_pol_rec.attribute12,
        ATTRIBUTE13 = l_def_pol_rec.attribute13,
        ATTRIBUTE14 = l_def_pol_rec.attribute14,
        ATTRIBUTE15 = l_def_pol_rec.attribute15,
        ORG_ID = l_def_pol_rec.org_id,
        REQUEST_ID = l_def_pol_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_pol_rec.program_application_id,
        PROGRAM_ID = l_def_pol_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_pol_rec.program_update_date,
        CREATED_BY = l_def_pol_rec.created_by,
        CREATION_DATE = l_def_pol_rec.creation_date,
        LAST_UPDATED_BY = l_def_pol_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_pol_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_pol_rec.last_update_login,
        LEGAL_ENTITY_ID = l_def_pol_rec.legal_entity_id
    WHERE ID = l_def_pol_rec.id;

Line: 2595


  END update_row;

Line: 2599


  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_polv_rec                     IN polv_rec_type,
    x_polv_rec                     OUT NOCOPY polv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2609


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

Line: 2624


      l_polv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2625


      l_polv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2626


      l_polv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2689


        IF (x_polv_rec.date_last_updated = OKL_API.G_MISS_DATE)
        THEN
          x_polv_rec.date_last_updated := l_db_polv_rec.date_last_updated;

Line: 2789


        IF (x_polv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_polv_rec.program_update_date := l_db_polv_rec.program_update_date;

Line: 2801


        IF (x_polv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_polv_rec.last_updated_by := l_db_polv_rec.last_updated_by;

Line: 2805


        IF (x_polv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_polv_rec.last_update_date := l_db_polv_rec.last_update_date;

Line: 2809


        IF (x_polv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_polv_rec.last_update_login := l_db_polv_rec.last_update_login;

Line: 2902


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pol_rec,
      lx_pol_rec
    );

Line: 2950


  END update_row;

Line: 2954


  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_polv_tbl                     IN polv_tbl_type,
    x_polv_tbl                     OUT NOCOPY polv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2965


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

Line: 2979


          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_polv_rec                     => p_polv_tbl(i),
            x_polv_rec                     => x_polv_tbl(i));

Line: 3047


  END update_row;

Line: 3052


  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_polv_tbl                     IN polv_tbl_type,
    x_polv_tbl                     OUT NOCOPY polv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3062


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

Line: 3069


      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_polv_tbl                     => p_polv_tbl,
        x_polv_tbl                     => x_polv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3111


  END update_row;

Line: 3119


  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_pol_rec                      IN pol_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3127


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

Line: 3142


    DELETE FROM okl_pools
     WHERE ID = p_pol_rec.id;

Line: 3178


  END delete_row;

Line: 3182


  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_polv_rec                     IN polv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3191


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

Line: 3215


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

Line: 3260


  END delete_row;

Line: 3264


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3274


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

Line: 3288


          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_polv_rec                     => p_polv_tbl(i));

Line: 3355


  END delete_row;

Line: 3360


  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_polv_tbl                     IN polv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3369


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

Line: 3376


      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_polv_tbl                     => p_polv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3417


  END delete_row;