APPS.XLA_REVERSE_EVENTS_PVT_PKG dependencies on XLA_REVERSE_EVENTS_INTERFACE

Line 1135: MERGE /*+ INDEX(int,XLA_REVERSE_EVENTS_INTF_U1) */ INTO XLA_REVERSE_EVENTS_INTERFACE int

1131: ,p_module =>l_log_module);
1132:
1133: END IF;
1134:
1135: MERGE /*+ INDEX(int,XLA_REVERSE_EVENTS_INTF_U1) */ INTO XLA_REVERSE_EVENTS_INTERFACE int
1136: USING XLA_EVENTS_GT evt
1137: ON ( int.event_id = evt.event_number
1138: AND int.ledger_id = g_ledger_id
1139: AND int.batch_code = g_batch_code

Line 1151: ( p_msg => 'Number of Rows Updated in XLA_REVERSE_EVENTS_INTERFACE ' || SQL%ROWCOUNT

1147: ;
1148:
1149: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1150: trace
1151: ( p_msg => 'Number of Rows Updated in XLA_REVERSE_EVENTS_INTERFACE ' || SQL%ROWCOUNT
1152: ,p_level => C_LEVEL_PROCEDURE
1153: ,p_module =>l_log_module);
1154: END IF;
1155:

Line 1418: FROM XLA_REVERSE_EVENTS_INTERFACE evt

1414: evt.REVERSAL_ENTITY_ID REFERENCE_NUM_1 ,
1415: evt.REVERSAL_EVENT_ID REFERENCE_NUM_2 ,
1416: evt.process_status_code REFERENCE_CHAR_1 ,
1417: NULL REFERENCE_CHAR_2
1418: FROM XLA_REVERSE_EVENTS_INTERFACE evt
1419: ,xla_events xe
1420: WHERE evt.application_id = :1
1421: AND evt.ledger_id = :2
1422: AND evt.batch_code = :3

Line 1743: FROM xla_reverse_events_interface intf

1739: ,intf.reversal_entity_id reference_num_1
1740: ,intf.reversal_event_id reference_num_2
1741: ,intf.process_status_code reference_char_1
1742: ,intf.rowid reference_char_2
1743: FROM xla_reverse_events_interface intf
1744: WHERE intf.batch_code = :1
1745: AND intf.application_id = :2
1746: AND intf.ledger_id = :3
1747: AND intf.process_status_code IN( ''U'', ''E'' )

Line 2050: FROM XLA_REVERSE_EVENTS_INTERFACE xet

2046:
2047: IF p_delete_flag = 'Y' THEN
2048:
2049: DELETE /*+ rowid(xet) */
2050: FROM XLA_REVERSE_EVENTS_INTERFACE xet
2051: WHERE xet.rowid IN ( SELECT reference_char_2
2052: FROM xla_events_gt
2053: ) ;
2054: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2062: UPDATE /*+ rowid(xet) */XLA_REVERSE_EVENTS_INTERFACE xet

2058: ,p_module => l_log_module);
2059: END IF;
2060: ELSE
2061:
2062: UPDATE /*+ rowid(xet) */XLA_REVERSE_EVENTS_INTERFACE xet
2063: SET xet.REVERSAL_EVENT_ID = NULL
2064: ,xet.REVERSAL_ENTITY_ID = NULL
2065: ,xet.ACCOUNTING_BATCH_ID = NULL
2066: ,xet.process_status_code = 'U'