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 288: OKL_ACCOUNTING_UTIL.VALIDATE_SOURCE_ID_TABLE(p_source_id => p_source_Id,

284: RAISE OKL_API.G_EXCEPTION_ERROR;
285: END IF;
286:
287: l_validate_flag :=
288: OKL_ACCOUNTING_UTIL.VALIDATE_SOURCE_ID_TABLE(p_source_id => p_source_Id,
289: p_source_table => p_source_table);
290:
291: IF (l_validate_flag = OKL_API.G_FALSE) THEN
292: OKL_API.set_message(p_app_name => G_APP_NAME,

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

296:
297: END IF;
298:
299:
300: OKL_ACCOUNTING_UTIL.get_period_info(p_date => p_acct_date,
301: p_period_name => l_period_name,
302: p_start_date => l_start_date,
303: p_end_date => l_end_date);
304:

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

309: p_token1_value => p_acct_date);
310: RAISE OKL_API.G_EXCEPTION_ERROR;
311: END IF;
312:
313: l_period_status := OKL_ACCOUNTING_UTIL.get_okl_period_status(l_period_name);
314:
315: IF (l_period_status NOT IN ('O','F')) THEN
316: OKL_API.set_message(p_app_name => G_APP_NAME,
317: p_msg_name => 'OKL_PERD_INVALID_STATUS',