[Home] [Help]
646: -- Check if GT table has any sources
647: CURSOR c_gt_sources
648: IS
649: SELECT 'x'
650: FROM xla_evt_class_sources_gt
651: WHERE application_id = p_application_id
652: AND entity_code = p_entity_code
653: AND event_class_code = p_event_class_code;
654:
684: ,p_level => C_LEVEL_PROCEDURE);
685: END IF;
686:
687: -- Insert all sources that are assigned to the event class into the GT table
688: INSERT INTO xla_evt_class_sources_gt
689: (application_id
690: ,entity_code
691: ,event_class_code
692: ,source_application_id
834: o.object_name extract_object_name,
835: o.object_type_code extract_object_type,
836: o.always_populated_flag extract_object_pop_flag,
837: g.source_datatype_code column_datatype_code
838: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
839: xla_extract_objects_gt og
840: WHERE g.application_id = o.application_id
841: AND g.entity_code = o.entity_code
842: AND g.event_class_code = o.event_class_code
866: o.object_type_code extract_object_type,
867: r.always_populated_flag extract_object_pop_flag,
868: g.source_datatype_code column_datatype_code,
869: r.join_condition, r.linked_to_ref_obj_name
870: FROM xla_evt_class_sources_gt g, xla_reference_objects r, xla_extract_objects o,
871: xla_reference_objects_gt og
872: WHERE g.application_id = r.application_id
873: AND g.entity_code = r.entity_code
874: AND g.event_class_code = r.event_class_code
902: o.object_name extract_object_name,
903: o.object_type_code extract_object_type,
904: o.always_populated_flag extract_object_pop_flag,
905: g.source_datatype_code column_datatype_code
906: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
907: xla_extract_objects_gt og
908: WHERE g.application_id = o.application_id
909: AND g.entity_code = o.entity_code
910: AND g.event_class_code = o.event_class_code
933: o.object_type_code extract_object_type,
934: r.always_populated_flag extract_object_pop_flag,
935: g.source_datatype_code column_datatype_code,
936: r.join_condition, r.linked_to_ref_obj_name
937: FROM xla_evt_class_sources_gt g, xla_reference_objects r, xla_extract_objects o,
938: xla_reference_objects_gt og
939: WHERE g.application_id = r.application_id
940: AND g.entity_code = r.entity_code
941: AND g.event_class_code = r.event_class_code
973: FROM dba_tab_columns T
974: WHERE og.owner = t.owner
975: AND o.object_name = t.table_name
976: AND t.column_name = g.source_code)
977: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
978: xla_extract_objects_gt og
979: WHERE g.application_id = o.application_id
980: AND g.entity_code = o.entity_code
981: AND g.event_class_code = o.event_class_code
1006: WHERE og.owner = t.owner
1007: AND r.reference_object_name = t.table_name
1008: AND t.column_name = g.source_code)
1009: ,r.join_condition
1010: FROM xla_evt_class_sources_gt g
1011: ,xla_reference_objects r
1012: ,xla_extract_objects o
1013: ,xla_reference_objects_gt og
1014: WHERE g.application_id = r.application_id
1034: -- Get all sources from GT table with null extract object
1035: CURSOR c_null_obj
1036: IS
1037: SELECT source_application_id, source_code, source_level_code
1038: FROM xla_evt_class_sources_gt g
1039: WHERE g.application_id = p_application_id
1040: AND g.entity_code = p_entity_code
1041: AND g.event_class_code = p_event_class_code
1042: AND extract_object_name IS NULL;
1047: CURSOR c_datatype
1048: IS
1049: SELECT source_application_id, source_code, extract_object_name,
1050: extract_object_type_code
1051: FROM xla_evt_class_sources_gt g
1052: WHERE source_datatype_code <> column_datatype_code
1053: AND extract_object_name IS NOT NULL
1054: AND g.application_id = p_application_id
1055: AND g.entity_code = p_entity_code
1114:
1115: -- Bulk update the GT table with the extract object name for each source
1116: IF l_array_pop_source_code.COUNT > 0 THEN
1117: FORALL i IN l_array_pop_source_code.FIRST..l_array_pop_source_code.LAST
1118: UPDATE xla_evt_class_sources_gt gt
1119: SET gt.extract_object_name = l_array_pop_object_name(i),
1120: gt.extract_object_type_code = l_array_pop_object_type(i),
1121: gt.always_populated_flag = l_array_pop_pop_flag(i),
1122: gt.column_datatype_code = l_array_pop_col_datatype(i),
1139:
1140: -- Bulk update the GT table with the reference object name for each source
1141: IF l_array_ref_pop_source_code.COUNT > 0 THEN
1142: FORALL i IN l_array_ref_pop_source_code.FIRST..l_array_ref_pop_source_code.LAST
1143: UPDATE xla_evt_class_sources_gt gt
1144: SET gt.extract_object_name = l_array_ref_pop_object_name(i),
1145: gt.extract_object_type_code = l_array_ref_pop_object_type(i),
1146: gt.always_populated_flag = l_array_ref_pop_pop_flag(i),
1147: gt.column_datatype_code = l_array_ref_pop_col_datatype(i),
1154: AND gt.event_class_code = p_event_class_code
1155: AND l_array_ref_pop_linked_obj(i) IS NULL;
1156:
1157: FORALL i IN l_array_ref_pop_source_code.FIRST..l_array_ref_pop_source_code.LAST
1158: UPDATE xla_evt_class_sources_gt gt
1159: SET gt.extract_object_name = l_array_ref_pop_object_name(i),
1160: gt.extract_object_type_code = l_array_ref_pop_object_type(i),
1161: gt.always_populated_flag = l_array_ref_pop_pop_flag(i),
1162: gt.column_datatype_code = l_array_ref_pop_col_datatype(i),
1184:
1185: -- Bulk update the GT table with the extract object name for each source
1186: IF l_array_source_code.COUNT > 0 THEN
1187: FORALL i IN l_array_source_code.FIRST..l_array_source_code.LAST
1188: UPDATE xla_evt_class_sources_gt gt
1189: SET gt.extract_object_name = l_array_object_name(i),
1190: gt.extract_object_type_code = l_array_object_type(i),
1191: gt.always_populated_flag = l_array_pop_flag(i),
1192: gt.column_datatype_code = l_array_col_datatype(i),
1212:
1213: -- Bulk update the GT table with the reference object name for each source
1214: IF l_array_ref_source_code.COUNT > 0 THEN
1215: FORALL i IN l_array_ref_source_code.FIRST..l_array_ref_source_code.LAST
1216: UPDATE xla_evt_class_sources_gt gt
1217: SET gt.extract_object_name = l_array_ref_object_name(i),
1218: gt.extract_object_type_code = l_array_ref_object_type(i),
1219: gt.always_populated_flag = l_array_ref_pop_flag(i),
1220: gt.column_datatype_code = l_array_ref_col_datatype(i),
1226: AND gt.entity_code = p_entity_code
1227: AND gt.event_class_code = p_event_class_code
1228: AND l_array_ref_linked_obj(i) IS NULL;
1229: FORALL i IN l_array_ref_source_code.FIRST..l_array_ref_source_code.LAST
1230: UPDATE xla_evt_class_sources_gt gt
1231: SET gt.extract_object_name = l_array_ref_object_name(i),
1232: gt.extract_object_type_code = l_array_ref_object_type(i),
1233: gt.always_populated_flag = l_array_ref_pop_flag(i),
1234: gt.column_datatype_code = l_array_ref_col_datatype(i),
1256:
1257: -- Bulk update the GT table with the extract object name for each source
1258: IF l_array_dt_source_code.COUNT > 0 THEN
1259: FORALL j IN l_array_dt_source_code.FIRST..l_array_dt_source_code.LAST
1260: UPDATE xla_evt_class_sources_gt gt
1261: SET gt.extract_object_name = l_array_dt_object_name(j),
1262: gt.extract_object_type_code = l_array_dt_object_type(j),
1263: gt.always_populated_flag = l_array_dt_pop_flag(j),
1264: gt.column_datatype_code = l_array_dt_col_datatype(j),
1283:
1284: -- Bulk update the GT table with the reference object name for each source
1285: IF l_array_ref_dt_source_code.COUNT > 0 THEN
1286: FORALL j IN l_array_ref_dt_source_code.FIRST..l_array_ref_dt_source_code.LAST
1287: UPDATE xla_evt_class_sources_gt gt
1288: SET gt.extract_object_name = l_array_ref_dt_object_name(j),
1289: gt.extract_object_type_code = l_array_ref_dt_object_type(j),
1290: gt.always_populated_flag = l_array_ref_dt_pop_flag(j),
1291: gt.column_datatype_code = l_array_ref_dt_col_datatype(j),
1779: -- Get all extract objects for an AAD which do not have event_id column
1780: CURSOR c_aad_event_id
1781: IS
1782: SELECT distinct extract_object_name, extract_object_type_code
1783: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
1784: WHERE application_id = p_application_id
1785: AND entity_code = p_entity_code
1786: AND event_class_code = p_event_class_code
1787: AND extract_object_name IS NOT NULL
1799: -- Get all extract objects for an AAD which do not have language column
1800: CURSOR c_aad_language
1801: IS
1802: SELECT distinct extract_object_name, extract_object_type_code
1803: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
1804: WHERE application_id = p_application_id
1805: AND entity_code = p_entity_code
1806: AND event_class_code = p_event_class_code
1807: AND extract_object_name IS NOT NULL
1820: -- Get all extract objects for an AAD which do not have line_number column
1821: CURSOR c_aad_line_number
1822: IS
1823: SELECT distinct extract_object_name, extract_object_type_code
1824: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
1825: WHERE application_id = p_application_id
1826: AND entity_code = p_entity_code
1827: AND event_class_code = p_event_class_code
1828: AND extract_object_name IS NOT NULL
1841: -- Get all extract objects for an AAD which do not have ledger_id column
1842: CURSOR c_aad_ledger_id
1843: IS
1844: SELECT distinct extract_object_name, extract_object_type_code
1845: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og, xla_subledgers app
1846: WHERE e.application_id = p_application_id
1847: AND e.entity_code = p_entity_code
1848: AND e.event_class_code = p_event_class_code
1849: AND e.extract_object_name IS NOT NULL