eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_CMP_EXTRACT_PKG dependencies on XLA_EVT_CLASS_SOURCES_GT

Line 990: trace(p_msg => 'SQL - DELETE FROM xla_evt_class_sources_gt '

986: END IF;
987:
988: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
989:
990: trace(p_msg => 'SQL - DELETE FROM xla_evt_class_sources_gt '
991: ,p_level => C_LEVEL_STATEMENT
992: ,p_module => l_log_module);
993: trace(p_msg => 'p_application_id = ' ||p_application_id
994: ,p_level => C_LEVEL_STATEMENT

Line 1007: DELETE FROM xla_evt_class_sources_gt gt

1003: ,p_module => l_log_module);
1004:
1005: END IF;
1006:
1007: DELETE FROM xla_evt_class_sources_gt gt
1008: WHERE gt.application_id = p_application_id
1009: AND gt.entity_code = p_entity_code
1010: AND gt.event_class_code = p_event_class_code
1011: ;

Line 1015: (p_msg => '# rows deleted from xla_evt_class_sources_gt = '||SQL%ROWCOUNT

1011: ;
1012: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1013:
1014: trace
1015: (p_msg => '# rows deleted from xla_evt_class_sources_gt = '||SQL%ROWCOUNT
1016: ,p_level => C_LEVEL_STATEMENT
1017: ,p_module => l_log_module);
1018:
1019: END IF;

Line 1078: -- insert sources in xla_evt_class_sources_gt temporary table

1074: , p_entity_code
1075: , p_event_class_code
1076: );
1077: --
1078: -- insert sources in xla_evt_class_sources_gt temporary table
1079: --
1080: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1081:
1082: trace

Line 1083: (p_msg => 'SQL- Insert Into xla_evt_class_sources_gt '

1079: --
1080: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1081:
1082: trace
1083: (p_msg => 'SQL- Insert Into xla_evt_class_sources_gt '
1084: ,p_level => C_LEVEL_STATEMENT
1085: ,p_module => l_log_module);
1086:
1087: END IF;

Line 1092: INSERT INTO xla_evt_class_sources_gt

1088:
1089: --
1090: FORALL Idx IN p_array_evt_source_index.FIRST .. p_array_evt_source_index.LAST
1091:
1092: INSERT INTO xla_evt_class_sources_gt
1093: (
1094: application_id
1095: , entity_code
1096: , event_class_code

Line 1149: FROM xla_evt_class_sources_gt gt

1145: AND xes.source_type_code = 'S'
1146: AND xes.active_flag = 'Y'
1147: -- added not exists to prevent inserting sources that are already there in GT table (Dimple)
1148: AND not exists (SELECT 'x'
1149: FROM xla_evt_class_sources_gt gt
1150: WHERE gt.application_id = xes.application_id
1151: AND gt.entity_code = xes.entity_code
1152: AND gt.event_class_code = xes.event_class_code
1153: AND gt.source_application_id = xes.source_application_id

Line 1160: (p_msg => '# rows inserted into xla_evt_class_sources_gt = '||SQL%ROWCOUNT

1156: --
1157: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1158:
1159: trace
1160: (p_msg => '# rows inserted into xla_evt_class_sources_gt = '||SQL%ROWCOUNT
1161: ,p_level => C_LEVEL_STATEMENT
1162: ,p_module => l_log_module);
1163:
1164: END IF;

Line 1223: (p_msg => 'SQL- SELECT from xla_evt_class_sources_gt '

1219: --
1220: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1221:
1222: trace
1223: (p_msg => 'SQL- SELECT from xla_evt_class_sources_gt '
1224: ,p_level => C_LEVEL_STATEMENT
1225: ,p_module => l_log_module);
1226:
1227: END IF;

Line 1239: FROM xla_evt_class_sources_gt gt

1235: END
1236: BULK COLLECT INTO
1237: l_array_evt_source_index
1238: , l_array_evt_source_Level
1239: FROM xla_evt_class_sources_gt gt
1240: WHERE gt.application_id = p_application_id
1241: AND gt.entity_code = p_entity_code
1242: AND gt.event_class_code = p_event_class_code
1243: ;

Line 1249: (p_msg => '# rows inserted into xla_evt_class_sources_gt = '||SQL%ROWCOUNT

1245: --
1246: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1247:
1248: trace
1249: (p_msg => '# rows inserted into xla_evt_class_sources_gt = '||SQL%ROWCOUNT
1250: ,p_level => C_LEVEL_STATEMENT
1251: ,p_module => l_log_module);
1252:
1253: END IF;

Line 1336: FROM xla_evt_class_sources_gt gt

1332: , nvl(gt.always_populated_flag,C_NOT_ALWAYS_POPULATED)
1333: , nvl(gt.reference_object_flag,C_NOT_REF_OBJ)
1334: , gt.join_condition
1335: , nvl(ro.linked_to_ref_obj_name, ro.object_name)
1336: FROM xla_evt_class_sources_gt gt
1337: , xla_reference_objects ro
1338: WHERE gt.application_id = p_application_id
1339: AND gt.entity_code = p_entity_code
1340: AND gt.event_class_code = p_event_class_code

Line 1352: FROM xla_evt_class_sources_gt gt

1348: , nvl(ro1.always_populated_flag,C_NOT_ALWAYS_POPULATED)
1349: , 'Y'
1350: , ro1.join_condition
1351: , nvl(ro1.linked_to_ref_obj_name, ro1.object_name)
1352: FROM xla_evt_class_sources_gt gt
1353: , xla_reference_objects ro
1354: , xla_reference_objects ro1
1355: WHERE gt.application_id = p_application_id
1356: AND gt.entity_code = p_entity_code

Line 1373: FROM xla_evt_class_sources_gt gt

1369: ,nvl(eo.always_populated_flag,C_NOT_ALWAYS_POPULATED)
1370: ,'N'
1371: ,null
1372: ,null
1373: FROM xla_evt_class_sources_gt gt
1374: , xla_reference_objects ro
1375: , xla_extract_objects eo
1376: WHERE gt.application_id = p_application_id
1377: AND gt.entity_code = p_entity_code

Line 1414: (p_msg => 'SQL - Fetch xla_evt_class_sources_gt '

1410: --
1411: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1412:
1413: trace
1414: (p_msg => 'SQL - Fetch xla_evt_class_sources_gt '
1415: ,p_level => C_LEVEL_STATEMENT
1416: ,p_module => l_log_module);
1417:
1418: END IF;

Line 1433: (p_msg => '# rows selected from xla_evt_class_sources_gt = '||table_cur%ROWCOUNT

1429:
1430: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1431:
1432: trace
1433: (p_msg => '# rows selected from xla_evt_class_sources_gt = '||table_cur%ROWCOUNT
1434: ,p_level => C_LEVEL_STATEMENT
1435: ,p_module => l_log_module);
1436:
1437: END IF;

Line 1600: (p_msg => 'SQL- SELECT from xla_evt_class_sources_gt'

1596: --
1597: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1598:
1599: trace
1600: (p_msg => 'SQL- SELECT from xla_evt_class_sources_gt'
1601: ,p_level => C_LEVEL_STATEMENT
1602: ,p_module => l_log_module);
1603:
1604: END IF;

Line 1616: FROM xla_evt_class_sources_gt gt

1612: l_array_source_hash_id
1613: , l_array_object_name
1614: , l_array_object_type
1615:
1616: FROM xla_evt_class_sources_gt gt
1617: WHERE gt.application_id = p_application_id
1618: AND gt.entity_code = p_entity_code
1619: AND gt.event_class_code = p_event_class_code
1620: ;

Line 1625: (p_msg => '# rows selected from xla_evt_class_sources_gt = '||SQL%ROWCOUNT

1621: --
1622: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1623:
1624: trace
1625: (p_msg => '# rows selected from xla_evt_class_sources_gt = '||SQL%ROWCOUNT
1626: ,p_level => C_LEVEL_STATEMENT
1627: ,p_module => l_log_module);
1628:
1629: END IF;

Line 2068: -- Insert sources in xla_evt_class_sources_gt GT table

2064: , l_array_translated_flag
2065: );
2066:
2067: --
2068: -- Insert sources in xla_evt_class_sources_gt GT table
2069: --
2070: InsertSourcesIntoGtTable (
2071: p_application_id
2072: , p_entity_code