APPS.PSA_AP_BC_PVT dependencies on XLA_EVENTS_INT_GT

Line 72: TYPE Event_tab_type IS TABLE OF XLA_EVENTS_INT_GT%rowtype

68: AND xla.entity_id = xte.entity_id
69: AND xla.application_id = xte.application_id
70: AND xte.ledger_id = p_ledger_id;
71:
72: TYPE Event_tab_type IS TABLE OF XLA_EVENTS_INT_GT%rowtype
73: INDEX BY BINARY_INTEGER;
74: l_events_Tab Event_tab_type;
75: l_event_count NUMBER;
76:

Line 103: DELETE FROM XLA_EVENTS_INT_GT;

99: --setting xla security context to use table xla_transaction_entity
100:
101: xla_security_pkg.set_security_context(200); --passing payables application_id
102:
103: DELETE FROM XLA_EVENTS_INT_GT;
104: psa_utils.debug_other_string(g_state_level,l_api_name, '# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );
105:
106: l_event_count := 0;
107: FOR rec_events IN c_get_unprocessed_events

Line 104: psa_utils.debug_other_string(g_state_level,l_api_name, '# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );

100:
101: xla_security_pkg.set_security_context(200); --passing payables application_id
102:
103: DELETE FROM XLA_EVENTS_INT_GT;
104: psa_utils.debug_other_string(g_state_level,l_api_name, '# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );
105:
106: l_event_count := 0;
107: FOR rec_events IN c_get_unprocessed_events
108: LOOP

Line 124: INSERT INTO XLA_EVENTS_INT_GT

120:
121:
122: IF l_event_count > 0 THEN
123: FORALL i IN 1..l_event_count
124: INSERT INTO XLA_EVENTS_INT_GT
125: VALUES l_events_tab(i) ;
126: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);
127: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
128:

Line 126: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);

122: IF l_event_count > 0 THEN
123: FORALL i IN 1..l_event_count
124: INSERT INTO XLA_EVENTS_INT_GT
125: VALUES l_events_tab(i) ;
126: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);
127: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
128:
129: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);
130: