APPS.OKL_PERIOD_SWEEP_PVT dependencies on OKL_TRNS_ACC_DSTRS

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 168: l_tabv_tbl OKL_TRNS_ACC_DSTRS_PUB.TABV_TBL_TYPE;

164: p_period_to IN VARCHAR2,
165: p_run_option IN VARCHAR2)
166: IS
167:
168: l_tabv_tbl OKL_TRNS_ACC_DSTRS_PUB.TABV_TBL_TYPE;
169: x_tabv_tbl OKL_TRNS_ACC_DSTRS_PUB.TABV_TBL_TYPE;
170: l_aetv_tbl OKL_ACCT_EVENT_PUB.aetv_tbl_type;
171: x_aetv_tbl OKL_ACCT_EVENT_PUB.aetv_tbl_type;
172: l_aehv_tbl OKL_ACCT_EVENT_PUB.aehv_tbl_type;

Line 169: x_tabv_tbl OKL_TRNS_ACC_DSTRS_PUB.TABV_TBL_TYPE;

165: p_run_option IN VARCHAR2)
166: IS
167:
168: l_tabv_tbl OKL_TRNS_ACC_DSTRS_PUB.TABV_TBL_TYPE;
169: x_tabv_tbl OKL_TRNS_ACC_DSTRS_PUB.TABV_TBL_TYPE;
170: l_aetv_tbl OKL_ACCT_EVENT_PUB.aetv_tbl_type;
171: x_aetv_tbl OKL_ACCT_EVENT_PUB.aetv_tbl_type;
172: l_aehv_tbl OKL_ACCT_EVENT_PUB.aehv_tbl_type;
173: x_aehv_tbl OKL_ACCT_EVENT_PUB.aehv_tbl_type;

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 330: OKL_TRNS_ACC_DSTRS_PUB.update_trns_acc_dstrs(p_api_version => l_api_version,

326: i := i +1;
327: END LOOP;
328:
329: IF (l_tabv_tbl.COUNT > 0) THEN
330: OKL_TRNS_ACC_DSTRS_PUB.update_trns_acc_dstrs(p_api_version => l_api_version,
331: p_init_msg_list => l_init_msg_list,
332: x_return_status => l_return_status,
333: x_msg_count => l_msg_count,
334: x_msg_data => l_msg_data,