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

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

Line: 101


    SELECT
            ID,
            KHR_ID,
            SOURCE_TABLE,
            SOURCE_ID,
            INTEREST_RATE,
            INTEREST_CALC_START_DATE,
            INTEREST_CALC_END_DATE,
            CALC_METHOD_CODE,
            PRINCIPAL_BALANCE,
            VALID_YN,
            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,
            INTEREST_AMT,
            INTEREST_CALC_DAYS,
            KLE_ID,
            CATCHUP_AMT,
            CATCHUP_SETTLEMENT_CODE
      FROM Okl_Var_Int_Params_V
     WHERE okl_var_int_params_v.id = p_id;

Line: 168


              l_virv_rec.program_update_date,
              l_virv_rec.attribute_category,
              l_virv_rec.attribute1,
              l_virv_rec.attribute2,
              l_virv_rec.attribute3,
              l_virv_rec.attribute4,
              l_virv_rec.attribute5,
              l_virv_rec.attribute6,
              l_virv_rec.attribute7,
              l_virv_rec.attribute8,
              l_virv_rec.attribute9,
              l_virv_rec.attribute10,
              l_virv_rec.attribute11,
              l_virv_rec.attribute12,
              l_virv_rec.attribute13,
              l_virv_rec.attribute14,
              l_virv_rec.attribute15,
              l_virv_rec.created_by,
              l_virv_rec.creation_date,
              l_virv_rec.last_updated_by,
              l_virv_rec.last_update_date,
              l_virv_rec.last_update_login,
			  l_virv_rec.interest_amt,
			  l_virv_rec.interest_calc_days,
              l_virv_rec.kle_id,
              l_virv_rec.catchup_amt,
              l_virv_rec.catchup_settlement_code;

Line: 236


    SELECT
            ID,
            KHR_ID,
            SOURCE_TABLE,
            SOURCE_ID,
            INTEREST_RATE,
            INTEREST_CALC_START_DATE,
            INTEREST_CALC_END_DATE,
            CALC_METHOD_CODE,
            PRINCIPAL_BALANCE,
            VALID_YN,
            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,
            INTEREST_AMT,
            INTEREST_CALC_DAYS,
            KLE_ID,
            CATCHUP_AMT,
            CATCHUP_SETTLEMENT_CODE
      FROM Okl_Var_Int_Params
     WHERE okl_var_int_params.id = p_id;

Line: 303


              l_vir_rec.program_update_date,
              l_vir_rec.attribute_category,
              l_vir_rec.attribute1,
              l_vir_rec.attribute2,
              l_vir_rec.attribute3,
              l_vir_rec.attribute4,
              l_vir_rec.attribute5,
              l_vir_rec.attribute6,
              l_vir_rec.attribute7,
              l_vir_rec.attribute8,
              l_vir_rec.attribute9,
              l_vir_rec.attribute10,
              l_vir_rec.attribute11,
              l_vir_rec.attribute12,
              l_vir_rec.attribute13,
              l_vir_rec.attribute14,
              l_vir_rec.attribute15,
              l_vir_rec.created_by,
              l_vir_rec.creation_date,
              l_vir_rec.last_updated_by,
              l_vir_rec.last_update_date,
              l_vir_rec.last_update_login,
			  l_vir_rec.interest_amt,
			  l_vir_rec.interest_calc_days,
              l_vir_rec.kle_id,
              l_vir_rec.catchup_amt,
              l_vir_rec.catchup_settlement_code;

Line: 416


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

Line: 473


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

Line: 476


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

Line: 479


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

Line: 537


      SELECT ID
      FROM okl_k_headers
      WHERE id = p_khr_id;

Line: 1031


    p_to.program_update_date := p_from.program_update_date;

Line: 1050


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1051


    p_to.last_update_date := p_from.last_update_date;

Line: 1052


    p_to.last_update_login := p_from.last_update_login;

Line: 1079


    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: 1352


  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_vir_rec                      IN vir_rec_type,
    x_vir_rec                      OUT NOCOPY vir_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1361


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

Line: 1397


    INSERT INTO OKL_VAR_INT_PARAMS(
      id,
      khr_id,
      source_table,
      source_id,
      interest_rate,
      interest_calc_start_date,
      interest_calc_end_date,
      calc_method_code,
      principal_balance,
      valid_yn,
      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,
	  interest_amt,
	  interest_calc_days,
      kle_id,
      catchup_amt,
      catchup_settlement_code)
    VALUES (
      l_vir_rec.id,
      l_vir_rec.khr_id,
      l_vir_rec.source_table,
      l_vir_rec.source_id,
      l_vir_rec.interest_rate,
      l_vir_rec.interest_calc_start_date,
      l_vir_rec.interest_calc_end_date,
      l_vir_rec.calc_method_code,
      l_vir_rec.principal_balance,
      l_vir_rec.valid_yn,
      l_vir_rec.object_version_number,
      l_vir_rec.org_id,
      l_vir_rec.request_id,
      l_vir_rec.program_application_id,
      l_vir_rec.program_id,
      l_vir_rec.program_update_date,
      l_vir_rec.attribute_category,
      l_vir_rec.attribute1,
      l_vir_rec.attribute2,
      l_vir_rec.attribute3,
      l_vir_rec.attribute4,
      l_vir_rec.attribute5,
      l_vir_rec.attribute6,
      l_vir_rec.attribute7,
      l_vir_rec.attribute8,
      l_vir_rec.attribute9,
      l_vir_rec.attribute10,
      l_vir_rec.attribute11,
      l_vir_rec.attribute12,
      l_vir_rec.attribute13,
      l_vir_rec.attribute14,
      l_vir_rec.attribute15,
      l_vir_rec.created_by,
      l_vir_rec.creation_date,
      l_vir_rec.last_updated_by,
      l_vir_rec.last_update_date,
      l_vir_rec.last_update_login,
	  l_vir_rec.interest_amt,
	  l_vir_rec.interest_calc_days,
      l_vir_rec.kle_id,
      l_vir_rec.catchup_amt,
      l_vir_rec.catchup_settlement_code);

Line: 1518


  END insert_row;

Line: 1522


  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_virv_rec                     IN virv_rec_type,
    x_virv_rec                     OUT NOCOPY virv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1532


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

Line: 1548


      l_virv_rec.LAST_UPDATE_DATE := l_virv_rec.CREATION_DATE;

Line: 1549


      l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1550


      l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1566


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

Line: 1632


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vir_rec,
      lx_vir_rec
    );

Line: 1681


  END insert_row;

Line: 1685


  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_virv_tbl                     IN virv_tbl_type,
    x_virv_tbl                     OUT NOCOPY virv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1696


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

Line: 1710


          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_virv_rec                     => p_virv_tbl(i),
            x_virv_rec                     => x_virv_tbl(i));

Line: 1778


  END insert_row;

Line: 1783


  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_virv_tbl                     IN virv_tbl_type,
    x_virv_tbl                     OUT NOCOPY virv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1793


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

Line: 1800


      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_virv_tbl                     => p_virv_tbl,
        x_virv_tbl                     => x_virv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1842


  END insert_row;

Line: 1860


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_VAR_INT_PARAMS
     WHERE ID = p_vir_rec.id
       AND OBJECT_VERSION_NUMBER = p_vir_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1867


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_VAR_INT_PARAMS
     WHERE ID = p_vir_rec.id;

Line: 1908


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1917


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2197


  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_vir_rec                      IN vir_rec_type,
    x_vir_rec                      OUT NOCOPY vir_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2206


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

Line: 2286


        IF (x_vir_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vir_rec.program_update_date := l_vir_rec.program_update_date;

Line: 2362


        IF (x_vir_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_vir_rec.last_updated_by := l_vir_rec.last_updated_by;

Line: 2366


        IF (x_vir_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vir_rec.last_update_date := l_vir_rec.last_update_date;

Line: 2370


        IF (x_vir_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_vir_rec.last_update_login := l_vir_rec.last_update_login;

Line: 2436


    UPDATE OKL_VAR_INT_PARAMS
    SET KHR_ID = l_def_vir_rec.khr_id,
        SOURCE_TABLE = l_def_vir_rec.source_table,
        SOURCE_ID = l_def_vir_rec.source_id,
        INTEREST_RATE = l_def_vir_rec.interest_rate,
        INTEREST_CALC_START_DATE = l_def_vir_rec.interest_calc_start_date,
        INTEREST_CALC_END_DATE = l_def_vir_rec.interest_calc_end_date,
        CALC_METHOD_CODE = l_def_vir_rec.calc_method_code,
        PRINCIPAL_BALANCE = l_def_vir_rec.principal_balance,
        VALID_YN = l_def_vir_rec.valid_yn,
        OBJECT_VERSION_NUMBER = l_def_vir_rec.object_version_number,
        ORG_ID = l_def_vir_rec.org_id,
        REQUEST_ID = l_def_vir_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_vir_rec.program_application_id,
        PROGRAM_ID = l_def_vir_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_vir_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_vir_rec.attribute_category,
        ATTRIBUTE1 = l_def_vir_rec.attribute1,
        ATTRIBUTE2 = l_def_vir_rec.attribute2,
        ATTRIBUTE3 = l_def_vir_rec.attribute3,
        ATTRIBUTE4 = l_def_vir_rec.attribute4,
        ATTRIBUTE5 = l_def_vir_rec.attribute5,
        ATTRIBUTE6 = l_def_vir_rec.attribute6,
        ATTRIBUTE7 = l_def_vir_rec.attribute7,
        ATTRIBUTE8 = l_def_vir_rec.attribute8,
        ATTRIBUTE9 = l_def_vir_rec.attribute9,
        ATTRIBUTE10 = l_def_vir_rec.attribute10,
        ATTRIBUTE11 = l_def_vir_rec.attribute11,
        ATTRIBUTE12 = l_def_vir_rec.attribute12,
        ATTRIBUTE13 = l_def_vir_rec.attribute13,
        ATTRIBUTE14 = l_def_vir_rec.attribute14,
        ATTRIBUTE15 = l_def_vir_rec.attribute15,
        CREATED_BY = l_def_vir_rec.created_by,
        CREATION_DATE = l_def_vir_rec.creation_date,
        LAST_UPDATED_BY = l_def_vir_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_vir_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_vir_rec.last_update_login,
        INTEREST_AMT = l_def_vir_rec.interest_amt,
        INTEREST_CALC_DAYS = l_def_vir_rec.interest_calc_days,
        KLE_ID = l_def_vir_rec.kle_id,
        CATCHUP_AMT = l_def_vir_rec.catchup_amt,
        CATCHUP_SETTLEMENT_CODE = l_def_vir_rec.catchup_settlement_code
    WHERE ID = l_def_vir_rec.id;

Line: 2514


  END update_row;

Line: 2518


  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_virv_rec                     IN virv_rec_type,
    x_virv_rec                     OUT NOCOPY virv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2528


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

Line: 2543


      l_virv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2544


      l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2545


      l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2620


        IF (x_virv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_virv_rec.program_update_date := l_db_virv_rec.program_update_date;

Line: 2696


        IF (x_virv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_virv_rec.last_updated_by := l_db_virv_rec.last_updated_by;

Line: 2700


        IF (x_virv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_virv_rec.last_update_date := l_db_virv_rec.last_update_date;

Line: 2704


        IF (x_virv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_virv_rec.last_update_login := l_db_virv_rec.last_update_login;

Line: 2750


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

Line: 2840


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vir_rec,
      lx_vir_rec
    );

Line: 2888


  END update_row;

Line: 2892


  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_virv_tbl                     IN virv_tbl_type,
    x_virv_tbl                     OUT NOCOPY virv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2903


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

Line: 2917


          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_virv_rec                     => p_virv_tbl(i),
            x_virv_rec                     => x_virv_tbl(i));

Line: 2985


  END update_row;

Line: 2990


  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_virv_tbl                     IN virv_tbl_type,
    x_virv_tbl                     OUT NOCOPY virv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3000


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

Line: 3007


      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_virv_tbl                     => p_virv_tbl,
        x_virv_tbl                     => x_virv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3049


  END update_row;

Line: 3057


  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_vir_rec                      IN vir_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3065


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

Line: 3080


    DELETE FROM OKL_VAR_INT_PARAMS
     WHERE ID = p_vir_rec.id;

Line: 3116


  END delete_row;

Line: 3120


  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_virv_rec                     IN virv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3129


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

Line: 3153


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

Line: 3198


  END delete_row;

Line: 3202


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3212


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

Line: 3226


          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_virv_rec                     => p_virv_tbl(i));

Line: 3293


  END delete_row;

Line: 3298


  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_virv_tbl                     IN virv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3307


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

Line: 3314


      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_virv_tbl                     => p_virv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3355


  END delete_row;