62: x_msg_count NUMBER;
63: l_api_version CONSTANT NUMBER DEFAULT '1.0';
64: x_msg_data VARCHAR2(100);
65:
66: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.POOL_TRX_KHR_RBK';
67: l_debug_enabled VARCHAR2(10);
68: is_debug_statement_on BOOLEAN;
69:
70: BEGIN
223: x_msg_count NUMBER;
224: l_api_version CONSTANT NUMBER DEFAULT 1.0;
225: x_msg_data VARCHAR2(1000);
226:
227: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.REDUCE_POOL_BALANCE';
228: l_debug_enabled VARCHAR2(10);
229: is_debug_statement_on BOOLEAN;
230:
231: BEGIN
358: lv_sixv_rec sixv_rec_type;
359: lx_sixv_rec sixv_rec_type;
360: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POOL_TRX_KHR_BOOK';
361:
362: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.CREATE_POOL_TRX_KHR_BOOK';
363: l_debug_enabled VARCHAR2(10);
364: is_debug_procedure_on BOOLEAN;
365: is_debug_statement_on BOOLEAN;
366:
618: idx PLS_INTEGER;
619: l_sub_pool_applicable VARCHAR2(10);
620: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POOL_TRX_KHR_REVERSE';
621:
622: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.CREATE_POOL_TRX_KHR_REVERSE';
623: l_debug_enabled VARCHAR2(10);
624: is_debug_procedure_on BOOLEAN;
625: is_debug_statement_on BOOLEAN;
626:
989: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POOL_TRX_KHR_RBK';
990: lv_six_tbl sixv_tbl_type;
991: lx_six_tbl sixv_tbl_type;
992:
993: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.CREATE_POOL_TRX_KHR_RBK';
994: l_debug_enabled VARCHAR2(10);
995: is_debug_procedure_on BOOLEAN;
996: is_debug_statement_on BOOLEAN;
997:
1272: cv_split_info_rec c_split_info_csr%ROWTYPE;
1273:
1274: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'POOL_TRX_KHR_SPLIT';
1275:
1276: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_AUTH_TRX_PVT.CREATE_POOL_TRX_KHR_SPLIT';
1277: l_debug_enabled VARCHAR2(10);
1278: is_debug_procedure_on BOOLEAN;
1279: is_debug_statement_on BOOLEAN;
1280: