63: ,p_action_type IN VARCHAR2
64: ,p_representation_code IN VARCHAR2
65: ,p_event_status_code IN VARCHAR2);
66:
67: TYPE tcn_tbl_type IS TABLE OF okl_trx_contracts_all.id%TYPE INDEX BY BINARY_INTEGER;
68: TYPE try_tbl_type IS TABLE OF okl_trx_contracts_all.try_id%TYPE INDEX BY BINARY_INTEGER;
69: TYPE ledger_tbl_type IS TABLE OF okl_trx_contracts_all.set_of_books_id%TYPE INDEX BY BINARY_INTEGER;
70:
71: -- API to update the event status in bulk. If p_action_type is null, then
64: ,p_representation_code IN VARCHAR2
65: ,p_event_status_code IN VARCHAR2);
66:
67: TYPE tcn_tbl_type IS TABLE OF okl_trx_contracts_all.id%TYPE INDEX BY BINARY_INTEGER;
68: TYPE try_tbl_type IS TABLE OF okl_trx_contracts_all.try_id%TYPE INDEX BY BINARY_INTEGER;
69: TYPE ledger_tbl_type IS TABLE OF okl_trx_contracts_all.set_of_books_id%TYPE INDEX BY BINARY_INTEGER;
70:
71: -- API to update the event status in bulk. If p_action_type is null, then
72: -- events for both create and reverse event types are updated.
65: ,p_event_status_code IN VARCHAR2);
66:
67: TYPE tcn_tbl_type IS TABLE OF okl_trx_contracts_all.id%TYPE INDEX BY BINARY_INTEGER;
68: TYPE try_tbl_type IS TABLE OF okl_trx_contracts_all.try_id%TYPE INDEX BY BINARY_INTEGER;
69: TYPE ledger_tbl_type IS TABLE OF okl_trx_contracts_all.set_of_books_id%TYPE INDEX BY BINARY_INTEGER;
70:
71: -- API to update the event status in bulk. If p_action_type is null, then
72: -- events for both create and reverse event types are updated.
73: PROCEDURE update_bulk_event_statuses(