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
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,
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:
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',