[Home] [Help]
375: WHERE application_id = p_application_id
376: AND entity_code = p_entity_code
377: AND event_class_code = p_event_class_code
378: AND not exists (SELECT 'x'
379: FROM xla_extract_objects_gt o
380: WHERE o.object_name = e.object_name)
381: --
382: -- Get all reference objects for the event class that are not defined in the
383: -- database
420: AND e.application_id = h.application_id
421: AND e.entity_code = h.entity_code
422: AND e.event_class_code = h.event_class_code
423: AND not exists (SELECT 'x'
424: FROM xla_extract_objects_gt o
425: WHERE o.object_name = e.object_name)
426: UNION ALL
427: SELECT r.entity_code
428: ,r.event_class_code
840: o.object_type_code extract_object_type,
841: o.always_populated_flag extract_object_pop_flag,
842: g.source_datatype_code column_datatype_code
843: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
844: xla_extract_objects_gt og
845: WHERE g.application_id = o.application_id
846: AND g.entity_code = o.entity_code
847: AND g.event_class_code = o.event_class_code
848: AND g.source_level_code = o.object_type_code
869: o.object_type_code extract_object_type,
870: o.always_populated_flag extract_object_pop_flag,
871: g.source_datatype_code column_datatype_code
872: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
873: xla_extract_objects_gt og
874: WHERE g.application_id = o.application_id
875: AND g.entity_code = o.entity_code
876: AND g.event_class_code = o.event_class_code
877: AND g.source_level_code = o.object_type_code
1027: o.object_type_code extract_object_type,
1028: o.always_populated_flag extract_object_pop_flag,
1029: g.source_datatype_code column_datatype_code
1030: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
1031: xla_extract_objects_gt og
1032: WHERE g.application_id = o.application_id
1033: AND g.entity_code = o.entity_code
1034: AND g.event_class_code = o.event_class_code
1035: AND g.source_level_code = o.object_type_code
1054: o.object_type_code extract_object_type,
1055: o.always_populated_flag extract_object_pop_flag,
1056: g.source_datatype_code column_datatype_code
1057: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
1058: xla_extract_objects_gt og
1059: WHERE g.application_id = o.application_id
1060: AND g.entity_code = o.entity_code
1061: AND g.event_class_code = o.event_class_code
1062: AND g.source_level_code = o.object_type_code
1213: WHERE og.owner = t.owner
1214: AND o.object_name = t.table_name
1215: AND t.column_name = g.source_code)
1216: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
1217: xla_extract_objects_gt og
1218: WHERE g.application_id = o.application_id
1219: AND g.entity_code = o.entity_code
1220: AND g.event_class_code = o.event_class_code
1221: AND g.source_level_code = o.object_type_code
1256: AND uo.object_type = 'SYNONYM'
1257: AND t.column_name = g.source_code
1258: )
1259: FROM xla_evt_class_sources_gt g, xla_extract_objects o,
1260: xla_extract_objects_gt og
1261: WHERE g.application_id = o.application_id
1262: AND g.entity_code = o.entity_code
1263: AND g.event_class_code = o.event_class_code
1264: AND g.source_level_code = o.object_type_code
1876: l_amb_context_code := p_amb_context_code;
1877: l_product_rule_code := p_product_rule_code;
1878: l_product_rule_type_code := p_product_rule_type_code;
1879:
1880: DELETE FROM xla_extract_objects_gt;
1881: DELETE FROM xla_reference_objects_gt;
1882:
1883: -- Get owner for current schema
1884: SELECT user
1888: IF p_product_rule_code is NULL THEN
1889:
1890: -- Insert objects for an event class and current owner in GT table
1891: INSERT
1892: INTO xla_extract_objects_gt
1893: (object_name
1894: ,owner)
1895: SELECT ext.object_name, l_user
1896: FROM xla_extract_objects ext
1920: AND rfr.event_class_code = p_event_class_code;
1921:
1922: -- Insert objects for an event class and different owner in GT table
1923: INSERT
1924: INTO xla_extract_objects_gt
1925: (object_name
1926: ,owner)
1927: SELECT ext.object_name
1928: ,(SELECT syn.table_owner
1985: IF l_ref_object_flag = 'N' THEN
1986:
1987: BEGIN
1988: INSERT
1989: INTO xla_extract_objects_gt
1990: (object_name
1991: ,owner)
1992: VALUES(l_object_name
1993: ,l_user);
2040:
2041: IF l_ref_object_flag = 'N' THEN
2042: BEGIN
2043: INSERT
2044: INTO xla_extract_objects_gt
2045: (object_name
2046: ,owner)
2047: VALUES(l_object_name
2048: ,l_syn_owner);
2160: /*
2161: CURSOR c_aad_event_id
2162: IS
2163: SELECT distinct extract_object_name, extract_object_type_code
2164: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
2165: WHERE application_id = p_application_id
2166: AND entity_code = p_entity_code
2167: AND event_class_code = p_event_class_code
2168: AND extract_object_name IS NOT NULL
2177: */
2178: CURSOR c_aad_event_id
2179: IS
2180: SELECT distinct extract_object_name, extract_object_type_code
2181: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
2182: WHERE application_id = p_application_id
2183: AND entity_code = p_entity_code
2184: AND event_class_code = p_event_class_code
2185: AND extract_object_name IS NOT NULL
2226: /*
2227: CURSOR c_aad_language
2228: IS
2229: SELECT distinct extract_object_name, extract_object_type_code
2230: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
2231: WHERE application_id = p_application_id
2232: AND entity_code = p_entity_code
2233: AND event_class_code = p_event_class_code
2234: AND extract_object_name IS NOT NULL
2243: -- 4420371 AND t.NULLABLE = 'N'); */
2244: CURSOR c_aad_language
2245: IS
2246: SELECT distinct extract_object_name, extract_object_type_code
2247: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
2248: WHERE application_id = p_application_id
2249: AND entity_code = p_entity_code
2250: AND event_class_code = p_event_class_code
2251: AND extract_object_name IS NOT NULL
2294: /*
2295: CURSOR c_aad_line_number
2296: IS
2297: SELECT distinct extract_object_name, extract_object_type_code
2298: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
2299: WHERE application_id = p_application_id
2300: AND entity_code = p_entity_code
2301: AND event_class_code = p_event_class_code
2302: AND extract_object_name IS NOT NULL
2311: -- 4420371 AND t.NULLABLE = 'N'); */
2312: CURSOR c_aad_line_number
2313: IS
2314: SELECT distinct extract_object_name, extract_object_type_code
2315: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og
2316: WHERE application_id = p_application_id
2317: AND entity_code = p_entity_code
2318: AND event_class_code = p_event_class_code
2319: AND extract_object_name IS NOT NULL
2361: /*
2362: CURSOR c_aad_ledger_id
2363: IS
2364: SELECT distinct extract_object_name, extract_object_type_code
2365: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og, xla_subledgers app
2366: WHERE e.application_id = p_application_id
2367: AND e.entity_code = p_entity_code
2368: AND e.event_class_code = p_event_class_code
2369: AND e.extract_object_name IS NOT NULL
2379: AND t.data_type = 'NUMBER'); */
2380: CURSOR c_aad_ledger_id
2381: IS
2382: SELECT distinct extract_object_name, extract_object_type_code
2383: FROM xla_evt_class_sources_gt e, xla_extract_objects_gt og, xla_subledgers app
2384: WHERE e.application_id = p_application_id
2385: AND e.entity_code = p_entity_code
2386: AND e.event_class_code = p_event_class_code
2387: AND e.extract_object_name IS NOT NULL
2430: /*
2431: CURSOR c_event_id
2432: IS
2433: SELECT e.object_name, object_type_code
2434: FROM xla_extract_objects e, xla_extract_objects_gt og
2435: WHERE application_id = p_application_id
2436: AND entity_code = p_entity_code
2437: AND event_class_code = p_event_class_code
2438: AND e.object_name = og.object_name
2443: AND t.column_name = 'EVENT_ID'
2444: AND t.data_type = 'NUMBER')
2445: -- 4420371 AND t.nullable = 'N')
2446: AND EXISTS (SELECT 'y'
2447: FROM xla_extract_objects_gt a
2448: WHERE a.object_name = e.object_name); */
2449: CURSOR c_event_id
2450: IS
2451: SELECT e.object_name, object_type_code
2448: WHERE a.object_name = e.object_name); */
2449: CURSOR c_event_id
2450: IS
2451: SELECT e.object_name, object_type_code
2452: FROM xla_extract_objects e, xla_extract_objects_gt og
2453: WHERE application_id = p_application_id
2454: AND entity_code = p_entity_code
2455: AND event_class_code = p_event_class_code
2456: AND e.object_name = og.object_name
2487: )
2488: )
2489: -- 4420371 AND t.nullable = 'N')
2490: AND EXISTS (SELECT 'y'
2491: FROM xla_extract_objects_gt a
2492: WHERE a.object_name = e.object_name);
2493:
2494:
2495: l_event_id c_event_id%rowtype;
2499: /*
2500: CURSOR c_language
2501: IS
2502: SELECT e.object_name, object_type_code
2503: FROM xla_extract_objects e, xla_extract_objects_gt og
2504: WHERE application_id = p_application_id
2505: AND entity_code = p_entity_code
2506: AND event_class_code = p_event_class_code
2507: AND object_type_code IN ('HEADER_MLS','LINE_MLS')
2513: AND t.column_name = 'LANGUAGE'
2514: AND t.data_type = 'VARCHAR2')
2515: -- 4420371 AND t.nullable = 'N')
2516: AND EXISTS (SELECT 'y'
2517: FROM xla_extract_objects_gt a
2518: WHERE a.object_name = e.object_name); */
2519: CURSOR c_language
2520: IS
2521: SELECT e.object_name, object_type_code
2518: WHERE a.object_name = e.object_name); */
2519: CURSOR c_language
2520: IS
2521: SELECT e.object_name, object_type_code
2522: FROM xla_extract_objects e, xla_extract_objects_gt og
2523: WHERE application_id = p_application_id
2524: AND entity_code = p_entity_code
2525: AND event_class_code = p_event_class_code
2526: AND object_type_code IN ('HEADER_MLS','LINE_MLS')
2558: )
2559: )
2560: -- 4420371 AND t.nullable = 'N')
2561: AND EXISTS (SELECT 'y'
2562: FROM xla_extract_objects_gt a
2563: WHERE a.object_name = e.object_name);
2564:
2565:
2566: l_language c_language%rowtype;
2570: /*
2571: CURSOR c_line_number
2572: IS
2573: SELECT e.object_name, object_type_code
2574: FROM xla_extract_objects e, xla_extract_objects_gt og
2575: WHERE application_id = p_application_id
2576: AND entity_code = p_entity_code
2577: AND event_class_code = p_event_class_code
2578: AND object_type_code IN ('LINE','LINE_MLS')
2584: AND t.column_name = 'LINE_NUMBER'
2585: AND t.data_type = 'NUMBER')
2586: -- 4420371 AND t.nullable = 'N')
2587: AND EXISTS (SELECT 'y'
2588: FROM xla_extract_objects_gt a
2589: WHERE a.object_name = e.object_name); */
2590: CURSOR c_line_number
2591: IS
2592: SELECT e.object_name, object_type_code
2589: WHERE a.object_name = e.object_name); */
2590: CURSOR c_line_number
2591: IS
2592: SELECT e.object_name, object_type_code
2593: FROM xla_extract_objects e, xla_extract_objects_gt og
2594: WHERE application_id = p_application_id
2595: AND entity_code = p_entity_code
2596: AND event_class_code = p_event_class_code
2597: AND object_type_code IN ('LINE','LINE_MLS')
2629: )
2630: )
2631: -- 4420371 AND t.nullable = 'N')
2632: AND EXISTS (SELECT 'y'
2633: FROM xla_extract_objects_gt a
2634: WHERE a.object_name = e.object_name);
2635:
2636:
2637: l_line_number c_line_number%rowtype;
2640: -- Added and commented for bug 15938563
2641: /* CURSOR c_ledger_id
2642: IS
2643: SELECT e.object_name, object_type_code
2644: FROM xla_extract_objects e, xla_extract_objects_gt og, xla_subledgers app
2645: WHERE e.application_id = p_application_id
2646: AND e.entity_code = p_entity_code
2647: AND e.event_class_code = p_event_class_code
2648: AND e.object_type_code IN ('LINE','LINE_MLS')
2655: AND og.owner = t.owner
2656: AND t.column_name = 'LEDGER_ID'
2657: AND t.data_type = 'NUMBER')
2658: AND EXISTS (SELECT 'y'
2659: FROM xla_extract_objects_gt a
2660: WHERE a.object_name = e.object_name); */
2661: CURSOR c_ledger_id
2662: IS
2663: SELECT e.object_name, object_type_code
2660: WHERE a.object_name = e.object_name); */
2661: CURSOR c_ledger_id
2662: IS
2663: SELECT e.object_name, object_type_code
2664: FROM xla_extract_objects e, xla_extract_objects_gt og, xla_subledgers app
2665: WHERE e.application_id = p_application_id
2666: AND e.entity_code = p_entity_code
2667: AND e.event_class_code = p_event_class_code
2668: AND e.object_type_code IN ('LINE','LINE_MLS')
2700: AND T.COLUMN_NAME = 'LEDGER_ID'
2701: and t.data_type = 'NUMBER'
2702: ))
2703: AND EXISTS (SELECT 'y'
2704: FROM xla_extract_objects_gt a
2705: WHERE a.object_name = e.object_name);
2706:
2707:
2708: l_ledger_id c_ledger_id%rowtype;
3612: /*
3613: CURSOR c_mls
3614: IS
3615: SELECT distinct c.column_name
3616: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
3617: WHERE c.table_name = e.object_name
3618: AND e.object_name = og.object_name
3619: AND og.owner = c.owner
3620: AND e.application_id = p_application_id
3633: WHEN 'HEADER' THEN 'N'
3634: WHEN 'LINE' THEN 'N'
3635: ELSE decode(c.data_type,'NUMBER','N','DATE','N', decode(c.column_name,'LANGUAGE','N','Y'))
3636: END translated_flag
3637: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
3638: WHERE c.table_name = e.object_name
3639: AND e.object_name = og.object_name
3640: AND og.owner = c.owner
3641: --
3697: AND s.source_code = c.column_name); */
3698: CURSOR c_mls
3699: IS
3700: SELECT distinct c.column_name
3701: FROM dba_tab_columns c,user_objects uo,xla_extract_objects e, xla_extract_objects_gt og
3702: WHERE c.table_name = e.object_name
3703: AND uo.object_name = e.object_name
3704: AND uo.object_type <> 'SYNONYM'
3705: AND e.object_name = og.object_name
3711: AND c.data_type IN ('NUMBER','DATE')
3712: AND c.column_name NOT IN ('EVENT_ID','LINE_NUMBER','LEDGER_ID')
3713: UNION ALL
3714: SELECT distinct c.column_name
3715: FROM dba_tab_columns c,user_objects uo,user_synonyms s,xla_extract_objects e, xla_extract_objects_gt og
3716: WHERE s.table_owner = c.owner
3717: AND s.table_name = c.table_name
3718: AND s.synonym_name = e.object_name
3719: AND uo.object_name = e.object_name
3736: WHEN 'HEADER' THEN 'N'
3737: WHEN 'LINE' THEN 'N'
3738: ELSE decode(c.data_type,'NUMBER','N','DATE','N', decode(c.column_name,'LANGUAGE','N','Y'))
3739: END translated_flag
3740: FROM dba_tab_columns c,user_objects uo, xla_extract_objects e, xla_extract_objects_gt og
3741: WHERE c.table_name = e.object_name
3742: AND uo.object_name = e.object_name
3743: AND uo.object_type <> 'SYNONYM'
3744: AND e.object_name = og.object_name
3769: WHEN 'HEADER' THEN 'N'
3770: WHEN 'LINE' THEN 'N'
3771: ELSE decode(c.data_type,'NUMBER','N','DATE','N', decode(c.column_name,'LANGUAGE','N','Y'))
3772: END translated_flag
3773: FROM dba_tab_columns c,user_objects uo,user_synonyms s, xla_extract_objects e, xla_extract_objects_gt og
3774: WHERE s.table_owner = c.owner
3775: AND c.table_name = s.table_name
3776: AND uo.object_name = s.synonym_name
3777: AND uo.object_name =e.object_name
4338: ,g_created_by
4339: ,g_last_updated_by
4340: ,g_last_update_date
4341: ,g_last_update_login
4342: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
4343: WHERE c.table_name = e.object_name
4344: AND og.object_name = e.object_name
4345: AND og.owner = c.owner
4346: AND e.object_type_code IN ('HEADER','HEADER_MLS')
4435: ,g_created_by
4436: ,g_last_updated_by
4437: ,g_last_update_date
4438: ,g_last_update_login
4439: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
4440: WHERE c.table_name = e.object_name
4441: AND og.object_name = e.object_name
4442: AND og.owner = c.owner
4443: AND e.object_type_code IN ('LINE','LINE_MLS')
4532: ,g_created_by
4533: ,g_last_updated_by
4534: ,g_last_update_date
4535: ,g_last_update_login
4536: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
4537: WHERE c.table_name = e.object_name
4538: AND og.object_name = e.object_name
4539: AND og.owner = c.owner
4540: AND e.object_type_code IN ('HEADER','HEADER_MLS')
4629: ,g_created_by
4630: ,g_last_updated_by
4631: ,g_last_update_date
4632: ,g_last_update_login
4633: FROM dba_tab_columns c, xla_extract_objects e, xla_extract_objects_gt og
4634: WHERE c.table_name = e.object_name
4635: AND og.object_name = e.object_name
4636: AND og.owner = c.owner
4637: AND e.object_type_code IN ('LINE','LINE_MLS')
4725: ,g_created_by
4726: ,g_last_updated_by
4727: ,g_last_update_date
4728: ,g_last_update_login
4729: FROM dba_tab_columns c,user_objects uo, xla_extract_objects e, xla_extract_objects_gt og
4730: WHERE c.table_name = e.object_name
4731: AND uo.object_name = e.object_name
4732: AND uo.object_type <> 'SYNONYM'
4733: AND og.object_name = e.object_name
4757: ,g_created_by
4758: ,g_last_updated_by
4759: ,g_last_update_date
4760: ,g_last_update_login
4761: FROM dba_tab_columns c,user_objects uo,user_synonyms s, xla_extract_objects e, xla_extract_objects_gt og
4762: WHERE s.table_owner = c.owner
4763: AND c.table_name = s.table_name
4764: AND uo.object_name = s.synonym_name
4765: AND uo.object_name = e.object_name
4897: ,g_created_by
4898: ,g_last_updated_by
4899: ,g_last_update_date
4900: ,g_last_update_login
4901: FROM dba_tab_columns c,user_objects uo, xla_extract_objects e, xla_extract_objects_gt og
4902: WHERE c.table_name = e.object_name
4903: AND uo.object_name = e.object_name
4904: AND uo.object_type <> 'SYNONYM'
4905: AND og.object_name = e.object_name
4929: ,g_created_by
4930: ,g_last_updated_by
4931: ,g_last_update_date
4932: ,g_last_update_login
4933: FROM dba_tab_columns c, user_objects uo,user_synonyms s,xla_extract_objects e, xla_extract_objects_gt og
4934: WHERE s.table_owner = c.owner
4935: AND c.table_name = s.table_name
4936: AND uo.object_name = s.synonym_name
4937: AND uo.object_name = e.object_name
5070: ,g_created_by
5071: ,g_last_updated_by
5072: ,g_last_update_date
5073: ,g_last_update_login
5074: FROM dba_tab_columns c, user_objects uo,xla_extract_objects e, xla_extract_objects_gt og
5075: WHERE c.table_name = e.object_name
5076: AND uo.object_name = e.object_name
5077: AND uo.object_type <> 'SYNONYM'
5078: AND og.object_name = e.object_name
5102: ,g_created_by
5103: ,g_last_updated_by
5104: ,g_last_update_date
5105: ,g_last_update_login
5106: FROM dba_tab_columns c, user_objects uo,user_synonyms s,xla_extract_objects e, xla_extract_objects_gt og
5107: WHERE s.table_owner = c.owner
5108: AND c.table_name = s.table_name
5109: AND uo.object_name = s.synonym_name
5110: AND uo.object_name = e.object_name
5244: ,g_created_by
5245: ,g_last_updated_by
5246: ,g_last_update_date
5247: ,g_last_update_login
5248: FROM dba_tab_columns c,user_objects uo, xla_extract_objects e, xla_extract_objects_gt og
5249: WHERE c.table_name = e.object_name
5250: AND uo.object_name = e.object_name
5251: AND uo.object_type <> 'SYNONYM'
5252: AND og.object_name = e.object_name
5276: ,g_created_by
5277: ,g_last_updated_by
5278: ,g_last_update_date
5279: ,g_last_update_login
5280: FROM dba_tab_columns c, user_objects uo,user_synonyms s,xla_extract_objects e, xla_extract_objects_gt og
5281: WHERE s.table_owner = c.owner
5282: AND c.table_name = s.table_name
5283: AND uo.object_name = s.synonym_name
5284: AND uo.object_name = e.object_name