APPS.OKL_SLA_PROCESSING_PVT dependencies on OKL_TRX_CONTRACTS_ALL

Line 45: TYPE t_id_tbl IS TABLE OF okl_trx_contracts_all.id%TYPE INDEX BY BINARY_INTEGER;

41: FROM xla_post_acctg_events_v
42: WHERE application_id = p_application_id;
43:
44: TYPE t_event_tbl IS TABLE OF xla_events.event_id%TYPE INDEX BY BINARY_INTEGER;
45: TYPE t_id_tbl IS TABLE OF okl_trx_contracts_all.id%TYPE INDEX BY BINARY_INTEGER;
46: l_event_tbl t_event_tbl;
47: l_tcn_tbl t_id_tbl;
48: l_fetch_size NUMBER := 1000;
49:

Line 67: UPDATE okl_trx_contracts_all

63:
64: FETCH events_info_csr BULK COLLECT INTO l_event_tbl, l_tcn_tbl limit l_fetch_size;
65:
66: FORALL i IN 1..l_event_tbl.count
67: UPDATE okl_trx_contracts_all
68: SET tsu_code = 'CANCELED',
69: canceled_date = sysdate,
70: accounting_reversal_yn = 'N'
71: WHERE id = l_tcn_tbl(i)