APPS.OKL_INSURANCE_POLICIES_PUB SQL Statements

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

Line: 7

           PROCEDURE   insert_ap_request(
         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_tap_id          IN NUMBER,
         p_credit_amount   IN NUMBER,
         p_credit_sty_id   IN NUMBER,
         p_khr_id         IN NUMBER ,
         p_kle_id         IN NUMBER,
         p_invoice_date   IN DATE,
         p_trx_id         IN NUMBER,
         p_vendor_site_id      IN NUMBER ,
         x_request_id     OUT NOCOPY NUMBER

    )  IS

    l_api_version NUMBER ;

Line: 43

    SAVEPOINT insert_ap_request;

Line: 61

    OKL_INSURANCE_POLICIES_Pvt.insert_ap_request(
             l_api_version     ,
    		 l_init_msg_list   ,
             l_return_status   ,
             l_msg_count       ,
             l_msg_data        ,
         l_tap_id          ,
         l_credit_amount   ,
         l_credit_sty_id   ,
         l_khr_id          ,
         l_kle_id         ,
         l_invoice_date   ,
         l_trx_id,
         l_vendor_site_id,
         l_request_id
    );

Line: 91

          ROLLBACK TO insert_ap_request;

Line: 99

          ROLLBACK TO insert_ap_request;

Line: 107

          ROLLBACK TO insert_ap_request;

Line: 111

          FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME ,   'insert_ap_request');

Line: 115

         END insert_ap_request;

Line: 119

         PROCEDURE   insert_ap_request(
         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_tap_id          IN NUMBER,
         p_credit_amount   IN NUMBER,
         p_credit_sty_id   IN NUMBER,
         p_khr_id         IN NUMBER ,
         p_kle_id         IN NUMBER,
         p_invoice_date   IN DATE,
         p_trx_id         IN NUMBER

    )  IS

      l_api_version NUMBER ;

Line: 151

    SAVEPOINT insert_ap_request;

Line: 167

    OKL_INSURANCE_POLICIES_Pvt.insert_ap_request(
             l_api_version     ,
    		 l_init_msg_list   ,
             l_return_status   ,
             l_msg_count       ,
             l_msg_data        ,
         l_tap_id          ,
         l_credit_amount   ,
         l_credit_sty_id   ,
         l_khr_id          ,
         l_kle_id         ,
         l_invoice_date   ,
         l_trx_id
    );

Line: 194

          ROLLBACK TO insert_ap_request;

Line: 202

          ROLLBACK TO insert_ap_request;

Line: 210

          ROLLBACK TO insert_ap_request;

Line: 214

          FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME ,   'insert_ap_request'   	);

Line: 218

         END insert_ap_request;

Line: 303

         PROCEDURE delete_policy(
         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_ipyv_rec                  IN  ipyv_rec_type,
         x_ipyv_rec                  OUT NOCOPY  ipyv_rec_type
         )IS
           l_api_version NUMBER ;

Line: 322

    SAVEPOINT ins_delete_policy;

Line: 331

    OKL_INSURANCE_POLICIES_Pvt.delete_policy(
             l_api_version     ,
    		 l_init_msg_list   ,
             l_return_status   ,
             l_msg_count       ,
             l_msg_data        ,
             l_ipyv_rec       ,
             lx_ipyv_rec      );

Line: 351

          ROLLBACK TO ins_delete_policy;

Line: 359

          ROLLBACK TO ins_delete_policy;

Line: 367

          ROLLBACK TO ins_delete_policy;

Line: 371

          FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME ,   'delete_policy'   	);

Line: 375

           END delete_policy;