78:
79: ---------------------------
80: -- DECLARE Local Variables
81: ---------------------------
82: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_BUDGET_PVT.CREATE_BUDGET_LINE';
83: L_DEBUG_ENABLED VARCHAR2(10);
84: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
85: IS_DEBUG_PROCEDURE_ON BOOLEAN;
86: l_budget_line_rec budget_line_rec;
80: -- DECLARE Local Variables
81: ---------------------------
82: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_BUDGET_PVT.CREATE_BUDGET_LINE';
83: L_DEBUG_ENABLED VARCHAR2(10);
84: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
85: IS_DEBUG_PROCEDURE_ON BOOLEAN;
86: l_budget_line_rec budget_line_rec;
87: l_budget_line_tbl budget_line_tbl ;
88: l_api_version NUMBER ;
218:
219: ---------------------------
220: -- DECLARE Local Variables
221: ---------------------------
222: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_BUDGET_PVT.UPDATE_BUDGET_LINE';
223: L_DEBUG_ENABLED VARCHAR2(10);
224: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
225: IS_DEBUG_PROCEDURE_ON BOOLEAN;
226: l_budget_line_rec budget_line_rec;
220: -- DECLARE Local Variables
221: ---------------------------
222: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_BUDGET_PVT.UPDATE_BUDGET_LINE';
223: L_DEBUG_ENABLED VARCHAR2(10);
224: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
225: IS_DEBUG_PROCEDURE_ON BOOLEAN;
226: l_budget_line_rec budget_line_rec;
227: l_budget_line_tbl budget_line_tbl ;
228: l_api_version NUMBER ;
358: p_decision_status_code IN OUT NOCOPY okl_subsidy_pool_budgets_b.decision_status_code%TYPE)IS
359: ---------------------------
360: -- DECLARE Local Variables
361: ---------------------------
362: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_BUDGET_PVT.SET_DECISION_STATUS_CODE';
363: L_DEBUG_ENABLED VARCHAR2(10);
364: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
365: IS_DEBUG_PROCEDURE_ON BOOLEAN;
366: l_budget_line_rec budget_line_rec;
360: -- DECLARE Local Variables
361: ---------------------------
362: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_BUDGET_PVT.SET_DECISION_STATUS_CODE';
363: L_DEBUG_ENABLED VARCHAR2(10);
364: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
365: IS_DEBUG_PROCEDURE_ON BOOLEAN;
366: l_budget_line_rec budget_line_rec;
367: l_sub_pool_budget_id OKL_SUBSIDY_POOL_BUDGETS_B.ID%TYPE ;
368: x_budget_line_rec budget_line_rec;
570:
571: ---------------------------
572: -- DECLARE Local Variables
573: ---------------------------
574: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_BUDGET_PVT.VALIDATE_BUDGET_LINE';
575: L_DEBUG_ENABLED VARCHAR2(10);
576: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
577: IS_DEBUG_PROCEDURE_ON BOOLEAN;
578: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_BUDGET_LINE';
572: -- DECLARE Local Variables
573: ---------------------------
574: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_BUDGET_PVT.VALIDATE_BUDGET_LINE';
575: L_DEBUG_ENABLED VARCHAR2(10);
576: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
577: IS_DEBUG_PROCEDURE_ON BOOLEAN;
578: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_BUDGET_LINE';
579: l_api_version CONSTANT NUMBER := 1.0;
580: l_return_status VARCHAR2(1);