APPS.OKL_CSH_ALLCT_RULES_PUB SQL Statements

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

Line: 9

PROCEDURE delete_comb_rules (p_api_version  IN NUMBER
       ,p_init_msg_list   IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
       ,x_return_status   OUT NOCOPY VARCHAR2
       ,x_msg_count       OUT NOCOPY NUMBER
       ,x_msg_data        OUT NOCOPY VARCHAR2
       ,p_cahv_rec        IN cahv_rec_type
                        ) IS

i                    NUMBER :=0;

Line: 34

SAVEPOINT csh_allct_rules_delete_rec;

Line: 46

Okl_Csh_Allct_Rules_Pvt.delete_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_cahv_rec);

Line: 73

      ROLLBACK TO csh_allct_rules_delete_rec;

Line: 81

      ROLLBACK TO csh_allct_rules_delete_rec;

Line: 89

      ROLLBACK TO csh_allct_rules_delete_rec;

Line: 98

END delete_comb_rules;

Line: 104

PROCEDURE delete_comb_rules (p_api_version  IN NUMBER
       ,p_init_msg_list   IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
       ,x_return_status   OUT NOCOPY VARCHAR2
       ,x_msg_count       OUT NOCOPY NUMBER
       ,x_msg_data        OUT NOCOPY VARCHAR2
       ,p_cahv_tbl        IN cahv_tbl_type
                        ) IS

i                    NUMBER :=0;

Line: 128

SAVEPOINT csh_allct_rules_delete_tbl;

Line: 147

    Okl_Csh_Allct_Rules_Pvt.delete_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_cahv_tbl(i));

Line: 180

      ROLLBACK TO csh_allct_rules_delete_tbl;

Line: 188

      ROLLBACK TO csh_allct_rules_delete_tbl;

Line: 196

      ROLLBACK TO csh_allct_rules_delete_tbl;

Line: 205

END delete_comb_rules;