130: CLOSE dist_csr;
131:
132: IF (l_dist_tbl.COUNT > 0) THEN
133:
134: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
135: IF(L_DEBUG_ENABLED='Y') THEN
136: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
137: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
138: END IF;
137: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
138: END IF;
139: IF(IS_DEBUG_PROCEDURE_ON) THEN
140: BEGIN
141: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
142: END;
143: END IF;
144: Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs(p_api_version => l_api_version
145: ,p_init_msg_list => l_init_msg_list
140: BEGIN
141: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
142: END;
143: END IF;
144: Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs(p_api_version => l_api_version
145: ,p_init_msg_list => l_init_msg_list
146: ,x_return_status => x_return_status
147: ,x_msg_count => l_msg_count
148: ,x_msg_data => l_msg_data
148: ,x_msg_data => l_msg_data
149: ,p_tabv_tbl => l_dist_tbl);
150: IF(IS_DEBUG_PROCEDURE_ON) THEN
151: BEGIN
152: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
153: END;
154: END IF;
155: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
156:
151: BEGIN
152: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
153: END;
154: END IF;
155: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
156:
157: END IF;
158:
159:
162: CLOSE src_csr;
163:
164: l_asev_rec.ID :=l_id;
165:
166: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
167: IF(IS_DEBUG_PROCEDURE_ON) THEN
168: BEGIN
169: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Acct_Sources_Pvt.delete_acct_sources ');
170: END;
183: BEGIN
184: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Acct_Sources_Pvt.delete_acct_sources ');
185: END;
186: END IF;
187: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
188:
189:
190:
191: END IF;
326: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
327:
328: l_tclv_rec_in TCLV_REC_TYPE ;
329: l_tclv_rec_out TCLV_REC_TYPE;
330: l_tabv_tbl OKL_TRNS_ACC_DSTRS_PUB.TABV_TBL_TYPE;
331: l_old_avl_id NUMBER := NULL;
332: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';
333: i NUMBER := 0;
334: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;