DBA Data[Home] [Help]

APPS.PO_DRAFT_EVENTS_PKG dependencies on XLA_EVENTS_INT_GT

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

84: AND xe.PROCESS_STATUS_CODE IN ('I','D')
85: AND xte.ledger_id = p_ledger_id
86: AND xe.event_date BETWEEN p_start_date AND p_end_date;
87:
88: TYPE Event_tab_type IS TABLE OF XLA_EVENTS_INT_GT%ROWTYPE INDEX BY BINARY_INTEGER;
89: l_events_Tab Event_tab_type;
90: l_event_count NUMBER;
91:
92:

Line 124: DELETE FROM XLA_EVENTS_INT_GT;

120: xla_security_pkg.set_security_context(602); --passing SLA application_id
121:
122: l_progress := '001';
123:
124: DELETE FROM XLA_EVENTS_INT_GT;
125:
126: IF g_debug_stmt THEN
127: PO_DEBUG.debug_stmt(l_log_head,l_progress,'# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );
128: END IF;

Line 127: PO_DEBUG.debug_stmt(l_log_head,l_progress,'# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );

123:
124: DELETE FROM XLA_EVENTS_INT_GT;
125:
126: IF g_debug_stmt THEN
127: PO_DEBUG.debug_stmt(l_log_head,l_progress,'# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );
128: END IF;
129:
130: l_progress := '002';
131:

Line 152: INSERT INTO XLA_EVENTS_INT_GT

148:
149: IF l_event_count > 0 THEN
150:
151: FORALL i IN 1..l_event_count
152: INSERT INTO XLA_EVENTS_INT_GT
153: VALUES l_events_tab(i) ;
154:
155: IF g_debug_stmt THEN
156: PO_DEBUG.debug_stmt(l_log_head,l_progress,'#Rows inserted into xla_events_int_gt table:' || l_event_count);

Line 156: PO_DEBUG.debug_stmt(l_log_head,l_progress,'#Rows inserted into xla_events_int_gt table:' || l_event_count);

152: INSERT INTO XLA_EVENTS_INT_GT
153: VALUES l_events_tab(i) ;
154:
155: IF g_debug_stmt THEN
156: PO_DEBUG.debug_stmt(l_log_head,l_progress,'#Rows inserted into xla_events_int_gt table:' || l_event_count);
157: END IF;
158:
159: END IF;
160: