APPS.PSA_AP_BC_PVT dependencies on XLA_EVENTS_INT_GT

Line 85: TYPE Event_tab_type IS TABLE OF XLA_EVENTS_INT_GT%ROWTYPE INDEX BY BINARY_INTEGER;

81: AND xla.entity_id = xte.entity_id
82: AND xla.application_id = xte.application_id
83: AND xte.ledger_id = p_ledger_id;
84:
85: TYPE Event_tab_type IS TABLE OF XLA_EVENTS_INT_GT%ROWTYPE INDEX BY BINARY_INTEGER;
86: l_events_Tab Event_tab_type;
87: l_event_count NUMBER;
88:
89: l_curr_calling_sequence VARCHAR2(2000);

Line 116: DELETE FROM XLA_EVENTS_INT_GT;

112: --setting xla security context to use table xla_transaction_entity
113:
114: xla_security_pkg.set_security_context(602); --passing SLA application_id
115:
116: DELETE FROM XLA_EVENTS_INT_GT;
117: psa_utils.debug_other_string(g_state_level,l_api_name, '# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );
118:
119: l_event_count := 0;
120: FOR rec_events IN c_get_unprocessed_events

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

113:
114: xla_security_pkg.set_security_context(602); --passing SLA application_id
115:
116: DELETE FROM XLA_EVENTS_INT_GT;
117: psa_utils.debug_other_string(g_state_level,l_api_name, '# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );
118:
119: l_event_count := 0;
120: FOR rec_events IN c_get_unprocessed_events
121: LOOP

Line 138: INSERT INTO XLA_EVENTS_INT_GT

134:
135: IF l_event_count > 0 THEN
136:
137: FORALL i IN 1..l_event_count
138: INSERT INTO XLA_EVENTS_INT_GT
139: VALUES l_events_tab(i) ;
140:
141: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);
142: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');

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

137: FORALL i IN 1..l_event_count
138: INSERT INTO XLA_EVENTS_INT_GT
139: VALUES l_events_tab(i) ;
140:
141: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);
142: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
143:
144: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);
145: