DBA Data[Home] [Help]

APPS.OKL_REVERSAL_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 141: WHERE prdst.ledger_id = OKL_ACCOUNTING_UTIL.get_set_of_books_id

137:
138: CURSOR prdst_csr(v_period_name VARCHAR2) IS
139: SELECT prdst.closing_status
140: FROM GL_PERIOD_STATUSES_V prdst
141: WHERE prdst.ledger_id = OKL_ACCOUNTING_UTIL.get_set_of_books_id
142: AND prdst.period_name = v_period_name
143: AND prdst.APPLICATION_ID = l_application_id;
144:
145: CURSOR check_dist_csr

Line 295: OKL_ACCOUNTING_UTIL.VALIDATE_SOURCE_ID_TABLE(p_source_id => p_source_Id,

291: RAISE OKL_API.G_EXCEPTION_ERROR;
292: END IF;
293:
294: l_validate_flag :=
295: OKL_ACCOUNTING_UTIL.VALIDATE_SOURCE_ID_TABLE(p_source_id => p_source_Id,
296: p_source_table => p_source_table);
297:
298: IF (l_validate_flag = OKL_API.G_FALSE) THEN
299: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 307: OKL_ACCOUNTING_UTIL.get_period_info(p_date => p_acct_date,

303:
304: END IF;
305:
306:
307: OKL_ACCOUNTING_UTIL.get_period_info(p_date => p_acct_date,
308: p_period_name => l_period_name,
309: p_start_date => l_start_date,
310: p_end_date => l_end_date);
311:

Line 320: l_period_status := OKL_ACCOUNTING_UTIL.get_okl_period_status(l_period_name);

316: p_token1_value => p_acct_date);
317: RAISE OKL_API.G_EXCEPTION_ERROR;
318: END IF;
319:
320: l_period_status := OKL_ACCOUNTING_UTIL.get_okl_period_status(l_period_name);
321:
322: IF (l_period_status NOT IN ('O','F')) THEN
323: OKL_API.set_message(p_app_name => G_APP_NAME,
324: p_msg_name => 'OKL_PERD_INVALID_STATUS',