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

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

Line: 101


    SELECT
	ID,
	OBJECT_VERSION_NUMBER,
	POL_ID,
	KHR_ID,
	KLE_ID,
	STY_ID,
	STM_ID,
	STY_CODE,
	POX_ID,
	STREAMS_FROM_DATE,
	STREAMS_TO_DATE,
	TRANSACTION_NUMBER_IN,
	TRANSACTION_NUMBER_OUT,
	DATE_INACTIVE,
	ATTRIBUTE_CATEGORY,
	STATUS_CODE,
	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_POOL_CONTENTS_V
     WHERE OKL_POOL_CONTENTS_V.id = p_id;

Line: 185


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

Line: 232


    SELECT
	ID,
	OBJECT_VERSION_NUMBER,
	POL_ID,
	KHR_ID,
	KLE_ID,
	STY_ID,
	STM_ID,
	STY_CODE,
	POX_ID,
	STREAMS_FROM_DATE,
	STREAMS_TO_DATE,
	TRANSACTION_NUMBER_IN,
	TRANSACTION_NUMBER_OUT,
	DATE_INACTIVE,
	ATTRIBUTE_CATEGORY,
	STATUS_CODE,
	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_pool_contents
     WHERE okl_pool_contents.id = p_id;

Line: 316


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

Line: 470


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

Line: 479


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

Line: 482


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

Line: 485


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

Line: 560


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

Line: 612


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

Line: 665


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

Line: 718


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

Line: 771


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

Line: 824


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

Line: 900


  SELECT '1'
    FROM OKL_POOL_TRANSACTIONS_V
   WHERE OKL_POOL_TRANSACTIONS_V.transaction_number = p_trans_num;

Line: 948


  SELECT '1'
    FROM OKL_POOL_TRANSACTIONS_V
   WHERE OKL_POOL_TRANSACTIONS_V.transaction_number = p_trans_num;

Line: 1198


    p_to.program_update_date := p_from.program_update_date;

Line: 1201


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1202


    p_to.last_update_date := p_from.last_update_date;

Line: 1203


    p_to.last_update_login := p_from.last_update_login;

Line: 1244


    p_to.program_update_date := p_from.program_update_date;

Line: 1247


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1248


    p_to.last_update_date := p_from.last_update_date;

Line: 1249


    p_to.last_update_login := p_from.last_update_login;

Line: 1495


  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_poc_rec                      IN poc_rec_type,
    x_poc_rec                      OUT NOCOPY poc_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1504


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

Line: 1540


    INSERT INTO okl_pool_contents(
	ID,
	OBJECT_VERSION_NUMBER,
	POL_ID,
	KHR_ID,
	KLE_ID,
	STY_ID,
	STM_ID,
	STY_CODE,
	POX_ID,
	STREAMS_FROM_DATE,
	STREAMS_TO_DATE,
	TRANSACTION_NUMBER_IN,
	TRANSACTION_NUMBER_OUT,
	DATE_INACTIVE,
	ATTRIBUTE_CATEGORY,
	STATUS_CODE,
	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_poc_rec.id,
	l_poc_rec.object_version_number,
	l_poc_rec.pol_id,
	l_poc_rec.khr_id,
	l_poc_rec.kle_id,
	l_poc_rec.sty_id,
	l_poc_rec.stm_id,
	l_poc_rec.sty_code,
	l_poc_rec.pox_id,
	l_poc_rec.streams_from_date,
	l_poc_rec.streams_to_date,
	l_poc_rec.transaction_number_in,
	l_poc_rec.transaction_number_out,
	l_poc_rec.date_inactive,
	l_poc_rec.attribute_category,
	l_poc_rec.status_code,
	l_poc_rec.attribute1 ,
	l_poc_rec.attribute2,
	l_poc_rec.attribute3,
	l_poc_rec.attribute4,
	l_poc_rec.attribute5,
	l_poc_rec.attribute6,
	l_poc_rec.attribute7,
	l_poc_rec.attribute8,
	l_poc_rec.attribute9,
	l_poc_rec.attribute10,
	l_poc_rec.attribute11,
	l_poc_rec.attribute12,
	l_poc_rec.attribute13,
	l_poc_rec.attribute14,
	l_poc_rec.attribute15,
	l_poc_rec.request_id,
	l_poc_rec.program_application_id,
	l_poc_rec.program_id,
	l_poc_rec.program_update_date,
	l_poc_rec.created_by,
	l_poc_rec.creation_date,
	l_poc_rec.last_updated_by,
	l_poc_rec.last_update_date,
	l_poc_rec.last_update_login);

Line: 1657


  END insert_row;

Line: 1661


  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_pocv_rec                     IN pocv_rec_type,
    x_pocv_rec                     OUT NOCOPY pocv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1671


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

Line: 1687


      l_pocv_rec.LAST_UPDATE_DATE := l_pocv_rec.CREATION_DATE;

Line: 1688


      l_pocv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1689


      l_pocv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1705


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

Line: 1764


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_poc_rec,
      lx_poc_rec
    );

Line: 1813


  END insert_row;

Line: 1817


  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_pocv_tbl                     IN pocv_tbl_type,
    x_pocv_tbl                     OUT NOCOPY pocv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1828


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

Line: 1842


          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_pocv_rec                     => p_pocv_tbl(i),
            x_pocv_rec                     => x_pocv_tbl(i));

Line: 1910


  END insert_row;

Line: 1915


  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_pocv_tbl                     IN pocv_tbl_type,
    x_pocv_tbl                     OUT NOCOPY pocv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1925


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

Line: 1932


      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_pocv_tbl                     => p_pocv_tbl,
        x_pocv_tbl                     => x_pocv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1974


  END insert_row;

Line: 1992


    SELECT OBJECT_VERSION_NUMBER
      FROM okl_pool_contents
     WHERE ID = p_poc_rec.id
       AND OBJECT_VERSION_NUMBER = p_poc_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1999


    SELECT OBJECT_VERSION_NUMBER
      FROM okl_pool_contents
     WHERE ID = p_poc_rec.id;

Line: 2040


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2049


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2329


  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_poc_rec                      IN poc_rec_type,
    x_poc_rec                      OUT NOCOPY poc_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2338


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

Line: 2495


        IF (x_poc_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_poc_rec.program_update_date := l_poc_rec.program_update_date;

Line: 2507


        IF (x_poc_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_poc_rec.last_updated_by := l_poc_rec.last_updated_by;

Line: 2511


        IF (x_poc_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_poc_rec.last_update_date := l_poc_rec.last_update_date;

Line: 2515


        IF (x_poc_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_poc_rec.last_update_login := l_poc_rec.last_update_login;

Line: 2561


    UPDATE okl_pool_contents
    SET OBJECT_VERSION_NUMBER = l_def_poc_rec.object_version_number,
        POL_ID = l_def_poc_rec.pol_id,
        KHR_ID = l_def_poc_rec.khr_id,
        KLE_ID = l_def_poc_rec.kle_id,
        STY_ID = l_def_poc_rec.sty_id,
        STM_ID = l_def_poc_rec.stm_id,
        STY_CODE = l_def_poc_rec.sty_code,
        POX_ID = l_def_poc_rec.pox_id,
        STREAMS_FROM_DATE = l_def_poc_rec.streams_from_date,
        STREAMS_TO_DATE = l_def_poc_rec.streams_to_date,
        TRANSACTION_NUMBER_IN = l_def_poc_rec.transaction_number_in,
        TRANSACTION_NUMBER_OUT = l_def_poc_rec.transaction_number_out,
        DATE_INACTIVE = l_def_poc_rec.date_inactive,
        STATUS_CODE = l_def_poc_rec.status_code,
        ATTRIBUTE_CATEGORY = l_def_poc_rec.attribute_category,
        ATTRIBUTE1 = l_def_poc_rec.attribute1,
        ATTRIBUTE2 = l_def_poc_rec.attribute2,
        ATTRIBUTE3 = l_def_poc_rec.attribute3,
        ATTRIBUTE4 = l_def_poc_rec.attribute4,
        ATTRIBUTE5 = l_def_poc_rec.attribute5,
        ATTRIBUTE6 = l_def_poc_rec.attribute6,
        ATTRIBUTE7 = l_def_poc_rec.attribute7,
        ATTRIBUTE8 = l_def_poc_rec.attribute8,
        ATTRIBUTE9 = l_def_poc_rec.attribute9,
        ATTRIBUTE10 = l_def_poc_rec.attribute10,
        ATTRIBUTE11 = l_def_poc_rec.attribute11,
        ATTRIBUTE12 = l_def_poc_rec.attribute12,
        ATTRIBUTE13 = l_def_poc_rec.attribute13,
        ATTRIBUTE14 = l_def_poc_rec.attribute14,
        ATTRIBUTE15 = l_def_poc_rec.attribute15,
        REQUEST_ID = l_def_poc_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_poc_rec.program_application_id,
        PROGRAM_ID = l_def_poc_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_poc_rec.program_update_date,
        CREATED_BY = l_def_poc_rec.created_by,
        CREATION_DATE = l_def_poc_rec.creation_date,
        LAST_UPDATED_BY = l_def_poc_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_poc_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_poc_rec.last_update_login
    WHERE ID = l_def_poc_rec.id;

Line: 2637


  END update_row;

Line: 2641


  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_pocv_rec                     IN pocv_rec_type,
    x_pocv_rec                     OUT NOCOPY pocv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2651


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

Line: 2666


      l_pocv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2667


      l_pocv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2668


      l_pocv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2823


        IF (x_pocv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_pocv_rec.program_update_date := l_db_pocv_rec.program_update_date;

Line: 2835


        IF (x_pocv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_pocv_rec.last_updated_by := l_db_pocv_rec.last_updated_by;

Line: 2839


        IF (x_pocv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_pocv_rec.last_update_date := l_db_pocv_rec.last_update_date;

Line: 2843


        IF (x_pocv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_pocv_rec.last_update_login := l_db_pocv_rec.last_update_login;

Line: 2931


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_poc_rec,
      lx_poc_rec
    );

Line: 2979


  END update_row;

Line: 2983


  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_pocv_tbl                     IN pocv_tbl_type,
    x_pocv_tbl                     OUT NOCOPY pocv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2994


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

Line: 3008


          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_pocv_rec                     => p_pocv_tbl(i),
            x_pocv_rec                     => x_pocv_tbl(i));

Line: 3076


  END update_row;

Line: 3081


  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_pocv_tbl                     IN pocv_tbl_type,
    x_pocv_tbl                     OUT NOCOPY pocv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3091


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

Line: 3098


      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_pocv_tbl                     => p_pocv_tbl,
        x_pocv_tbl                     => x_pocv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3140


  END update_row;

Line: 3148


  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_poc_rec                      IN poc_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3156


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

Line: 3171


    DELETE FROM okl_pool_contents
     WHERE ID = p_poc_rec.id;

Line: 3207


  END delete_row;

Line: 3211


  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_pocv_rec                     IN pocv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3220


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

Line: 3244


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

Line: 3289


  END delete_row;

Line: 3293


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3303


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

Line: 3317


          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_pocv_rec                     => p_pocv_tbl(i));

Line: 3384


  END delete_row;

Line: 3389


  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_pocv_tbl                     IN pocv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3398


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

Line: 3405


      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_pocv_tbl                     => p_pocv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3446


  END delete_row;