APPS.OKL_VR_DATA_HANDLER_PVT SQL Statements

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

Line: 5

  PROCEDURE UPDATE_LAST_INT_CAL_DATE(
        p_api_version            IN  NUMBER,
        p_init_msg_list          IN  VARCHAR2,
        x_return_status          OUT NOCOPY VARCHAR2,
        x_msg_count              OUT NOCOPY NUMBER,
        x_msg_data               OUT NOCOPY VARCHAR2,
        p_contract_id            IN  NUMBER,
        p_last_interest_cal_date IN  DATE
    )
   IS

  BEGIN
     OKL_VARIABLE_INTEREST_PVT.print_debug('Before updating Last Interest Calculation Date:' || p_last_interest_cal_date);

Line: 20

     UPDATE okl_k_headers khr
        SET khr.date_last_interim_interest_cal = p_last_interest_cal_date
      WHERE khr.id = p_contract_id;

Line: 26

     OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure UPDATE_LAST_INT_CAL_DATE');

Line: 35

  END UPDATE_LAST_INT_CAL_DATE;

Line: 39

  PROCEDURE INSERT_PRINCIPAL_BAL_TXN(
        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_vpb_tbl            IN  OKL_VARIABLE_INTEREST_PVT.vpb_tbl_type) IS

    l_index       NUMBER := 0;

Line: 52

    OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure INSERT_PRINCIPAL_BAL_TXN using following parameters : ');

Line: 59

       INSERT INTO OKL_VAR_PRINCIPAL_BAL_TXN VALUES p_vpb_tbl(l_index);

Line: 71

       OKL_VARIABLE_INTEREST_PVT.print_debug ('No. of records inserted : '|| SQL%rowcount);

Line: 76

       OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure INSERT_PRINCIPAL_BAL_TXN');

Line: 77

       OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception during bulk insert');

Line: 96

  END INSERT_PRINCIPAL_BAL_TXN;

Line: 100

  PROCEDURE INSERT_VIR_PARAMS(
        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_vir_tbl            IN  OKL_VARIABLE_INTEREST_PVT.vir_tbl_type) IS

    l_index      NUMBER := 0;

Line: 113

    OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure INSERT_VIR_PARAMS using following parameters : ');

Line: 120

       INSERT INTO okl_var_int_params VALUES p_vir_tbl(l_index);

Line: 131

       OKL_VARIABLE_INTEREST_PVT.print_debug ('No. of records inserted : '|| SQL%rowcount);

Line: 137

       OKL_VARIABLE_INTEREST_PVT.print_debug ('Exception during bulk insert');

Line: 156

  END INSERT_VIR_PARAMS;