DBA Data[Home] [Help]

APPS.OKL_PERIOD_SWEEP_PVT dependencies on XLA_EVENTS

Line 21: FROM OKL_TRNS_ACC_DSTRS dstrs,XLA_EVENTS xle

17: IS
18: SELECT DISTINCT dstrs.SOURCE_ID,
19: dstrs.SOURCE_TABLE,
20: dstrs.GL_DATE
21: FROM OKL_TRNS_ACC_DSTRS dstrs,XLA_EVENTS xle
22: WHERE dstrs.GL_DATE BETWEEN p_gl_date_from AND p_gl_date_to
23: AND dstrs.SET_OF_BOOKS_ID = p_ledger_id
24: AND dstrs.ACCOUNTING_EVENT_ID =xle.EVENT_ID
25: AND xle.EVENT_STATUS_CODE IN ('I','U')

Line 214: FROM OKL_TRNS_ACC_DSTRS dstrs,XLA_EVENTS xle

210: p_gl_date_from DATE,
211: p_gl_date_to DATE)
212: IS
213: SELECT dstrs.ID,dstrs.ACCOUNTING_EVENT_ID,dstrs.SOURCE_ID
214: FROM OKL_TRNS_ACC_DSTRS dstrs,XLA_EVENTS xle
215: WHERE dstrs.GL_DATE BETWEEN p_gl_date_from AND p_gl_date_to
216: AND dstrs.SET_OF_BOOKS_ID = p_ledger_id
217: AND dstrs.ACCOUNTING_EVENT_ID =xle.EVENT_ID
218: AND xle.EVENT_STATUS_CODE IN ('I','U')

Line 345: OKL_XLA_EVENTS_PVT.update_event(p_api_version =>l_api_version

341:
342: j :=0;
343: IF (l_tcn_tbl.COUNT > 0) THEN
344: FOR j in l_tcn_tbl.FIRST..l_tcn_tbl.LAST LOOP
345: OKL_XLA_EVENTS_PVT.update_event(p_api_version =>l_api_version
346: ,p_init_msg_list =>l_init_msg_list
347: ,x_return_status =>l_return_status
348: ,x_msg_count =>l_msg_count
349: ,x_msg_data =>l_msg_data