[Home] [Help]
127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: END IF;
131: -- TAPI call which inserts the budget line records in the table OKL_SUBSIDY_POOL_BUDGETS_B.
132: okl_sib_pvt.insert_row(l_api_version,
133: l_init_msg_list,
134: l_return_status,
135: l_msg_count,
269: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
270: RAISE OKL_API.G_EXCEPTION_ERROR;
271: END IF;
272:
273: -- TAPI call which updates the budget line records in the table OKL_SUBSIDY_POOL_BUDGETS_B.
274: okl_sib_pvt.update_row (l_api_version,
275: l_init_msg_list,
276: l_return_status,
277: l_msg_count,
338: -- Start of comments
339: --
340: -- Procedure Name : set_decision_status_code
341: -- Description : procedure for updating the decision status code
342: -- table OKL_SUBSIDY_POOL_BUDGETS_B.
343: -- Business Rules : This procedure sets the value of column desicion_status_code
344: -- with the value passed to this procedure for the given line id.
345: -- decision_status_code is a status of the corresponding budget line.
346: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
353: p_init_msg_list IN VARCHAR2,
354: x_return_status OUT NOCOPY VARCHAR2,
355: x_msg_count OUT NOCOPY NUMBER,
356: x_msg_data OUT NOCOPY VARCHAR2,
357: p_sub_pool_budget_id IN okl_subsidy_pool_budgets_b.id%TYPE,
358: p_decision_status_code IN OUT NOCOPY okl_subsidy_pool_budgets_b.decision_status_code%TYPE)IS
359: ---------------------------
360: -- DECLARE Local Variables
361: ---------------------------
354: x_return_status OUT NOCOPY VARCHAR2,
355: x_msg_count OUT NOCOPY NUMBER,
356: x_msg_data OUT NOCOPY VARCHAR2,
357: p_sub_pool_budget_id IN okl_subsidy_pool_budgets_b.id%TYPE,
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;
367: l_sub_pool_budget_id OKL_SUBSIDY_POOL_BUDGETS_B.ID%TYPE ;
368: x_budget_line_rec budget_line_rec;
369: l_row_found BOOLEAN;
370: l_api_version NUMBER ;
371: l_init_msg_list VARCHAR2(1) ;
379: -------------------
380: -- DECLARE Cursors
381: -------------------
382: -- cursor to fetch a record with the passed id.
383: CURSOR c_get_budget_id (cp_sub_pool_budget_id IN okl_subsidy_pool_budgets_b.id%type) IS
384: SELECT id
385: ,object_version_number
386: ,sfwt_flag
387: ,note