6: -- PROCEDURE delete_comb_rule
7: ---------------------------------------------------------------------------
8:
9: PROCEDURE delete_comb_rules (p_api_version IN NUMBER
10: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
11: ,x_return_status OUT NOCOPY VARCHAR2
12: ,x_msg_count OUT NOCOPY NUMBER
13: ,x_msg_data OUT NOCOPY VARCHAR2
14: ,p_cahv_rec IN cahv_rec_type
14: ,p_cahv_rec IN cahv_rec_type
15: ) IS
16:
17: i NUMBER :=0;
18: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
19: l_api_version NUMBER ;
20: l_init_msg_list VARCHAR2(1) ;
21: l_msg_data VARCHAR2(2000);
22: l_msg_count NUMBER ;
101: -- PROCEDURE delete_comb_rules
102: ---------------------------------------------------------------------------
103:
104: PROCEDURE delete_comb_rules (p_api_version IN NUMBER
105: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
106: ,x_return_status OUT NOCOPY VARCHAR2
107: ,x_msg_count OUT NOCOPY NUMBER
108: ,x_msg_data OUT NOCOPY VARCHAR2
109: ,p_cahv_tbl IN cahv_tbl_type
109: ,p_cahv_tbl IN cahv_tbl_type
110: ) IS
111:
112: i NUMBER :=0;
113: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
114: l_api_version NUMBER ;
115: l_init_msg_list VARCHAR2(1) ;
116: l_msg_data VARCHAR2(2000);
117: l_msg_count NUMBER ;
137:
138:
139: --Delete the Master
140: --Initialize the return status
141: l_return_status := Okc_Api.G_RET_STS_SUCCESS;
142:
143: IF (lp_cahv_tbl.COUNT > 0) THEN
144: i := p_cahv_tbl.FIRST;
145: LOOP