APPS.XLA_ACCOUNTING_DUMP_PKG dependencies on XLA_DIAG_EVENTS

Line 1053: , xla_diag_events xde

1049: g_array_events.reference_date_4,
1050: g_array_events.event_class_name,
1051: g_array_events.event_type_name
1052: FROM xla_events xe
1053: , xla_diag_events xde
1054: , xla_diag_ledgers xdl
1055: , xla_subledger_options_v xsov
1056: , xla_event_classes_tl xect
1057: , xla_event_types_tl xett

Line 1175: , xla_diag_events xde

1171: , xde.event_class_code event_class_code
1172: , nvl(xtv.name,xde.event_type_code) event_type_name
1173: , xde.event_type_code event_type_code
1174: FROM xla_events xe
1175: , xla_diag_events xde
1176: , xla_subledger_options_v xsov
1177: , xla_event_classes_tl xecv
1178: , xla_event_types_tl xtv
1179: WHERE xe.application_id = xde.application_id

Line 1309: , xla_diag_events xde

1305: , xdl.amb_context_code amb_context
1306: , xdl.start_date_active start_date
1307: , xdl.end_date_active end_date
1308: FROM xla_events xe
1309: , xla_diag_events xde
1310: , xla_diag_ledgers xdl
1311: , xla_subledger_options_v xso1
1312: , xla_subledger_options_v xso2
1313: , xla_subledger_options_v xso3

Line 1871: , xla_diag_events xde

1867: , xla_acct_attributes_b xaa
1868: , xla_acct_attributes_tl xaat
1869: , xla_sources_tl xstl
1870: , xla_diag_sources xds
1871: , xla_diag_events xde
1872: , xla_diag_ledgers xdl
1873: WHERE xde.event_id = xds.event_id
1874: AND xds.ledger_id = xdl.ledger_id
1875: AND xde.ledger_id = xdl.primary_ledger_id

Line 1907: , xla_diag_events xde

1903: , xla_acct_attributes_b xaa
1904: , xla_acct_attributes_tl xaat
1905: , xla_sources_tl xst
1906: , xla_diag_sources xds
1907: , xla_diag_events xde
1908: , xla_diag_ledgers xdl
1909: WHERE xde.event_id = xds.event_id
1910: AND xds.ledger_id = xdl.ledger_id
1911: AND xde.ledger_id = xdl.primary_ledger_id

Line 2048: FROM xla_diag_events xde

2044: , nvl(xaat.name,xals.accounting_attribute_code) attribute_name
2045: , nvl(xst.name, xds.source_code) source_name
2046: , xds.source_value source_value
2047: , xds.source_meaning source_meaning
2048: FROM xla_diag_events xde
2049: , xla_diag_ledgers xdl
2050: , xla_diag_sources xds
2051: , xla_sources_tl xst
2052: , xla_aad_line_defn_assgns xald

Line 2142: , xla_diag_events xde

2138: , xla_acct_attributes_b xaa
2139: , xla_acct_attributes_tl xaat
2140: , xla_sources_tl xstl
2141: , xla_diag_sources xds
2142: , xla_diag_events xde
2143: , xla_diag_ledgers xdl
2144: , xla_aad_line_defn_assgns xald
2145: , xla_line_defn_jlt_assgns xldj
2146: , xla_prod_acct_headers xpah

Line 3135: write_logfile('**Start** purge of xla_diag_events');

3131:
3132: ELSE
3133:
3134:
3135: write_logfile('**Start** purge of xla_diag_events');
3136:
3137: IF l_up_to_date IS NOT NULL AND p_request_id IS NOT NULL THEN
3138:
3139: DELETE FROM xla_diag_events

Line 3139: DELETE FROM xla_diag_events

3135: write_logfile('**Start** purge of xla_diag_events');
3136:
3137: IF l_up_to_date IS NOT NULL AND p_request_id IS NOT NULL THEN
3138:
3139: DELETE FROM xla_diag_events
3140: WHERE event_id IN
3141: (SELECT event_id FROM xla_diag_events
3142: WHERE application_id = p_application_id
3143: AND creation_date <= l_up_to_date

Line 3141: (SELECT event_id FROM xla_diag_events

3137: IF l_up_to_date IS NOT NULL AND p_request_id IS NOT NULL THEN
3138:
3139: DELETE FROM xla_diag_events
3140: WHERE event_id IN
3141: (SELECT event_id FROM xla_diag_events
3142: WHERE application_id = p_application_id
3143: AND creation_date <= l_up_to_date
3144: AND request_id = p_request_id)
3145: ;

Line 3149: DELETE FROM xla_diag_events

3145: ;
3146:
3147: ELSIF l_up_to_date IS NULL AND p_request_id IS NOT NULL THEN
3148:
3149: DELETE FROM xla_diag_events
3150: WHERE event_id IN
3151: (SELECT event_id FROM xla_diag_events
3152: WHERE application_id = p_application_id
3153: AND request_id = p_request_id)

Line 3151: (SELECT event_id FROM xla_diag_events

3147: ELSIF l_up_to_date IS NULL AND p_request_id IS NOT NULL THEN
3148:
3149: DELETE FROM xla_diag_events
3150: WHERE event_id IN
3151: (SELECT event_id FROM xla_diag_events
3152: WHERE application_id = p_application_id
3153: AND request_id = p_request_id)
3154: ;
3155:

Line 3158: DELETE FROM xla_diag_events

3154: ;
3155:
3156: ELSIF l_up_to_date IS NOT NULL AND p_request_id IS NULL THEN
3157:
3158: DELETE FROM xla_diag_events
3159: WHERE event_id IN
3160: (SELECT event_id FROM xla_diag_events
3161: WHERE application_id = p_application_id
3162: AND creation_date <= l_up_to_date)

Line 3160: (SELECT event_id FROM xla_diag_events

3156: ELSIF l_up_to_date IS NOT NULL AND p_request_id IS NULL THEN
3157:
3158: DELETE FROM xla_diag_events
3159: WHERE event_id IN
3160: (SELECT event_id FROM xla_diag_events
3161: WHERE application_id = p_application_id
3162: AND creation_date <= l_up_to_date)
3163: ;
3164:

Line 3167: DELETE FROM xla_diag_events

3163: ;
3164:
3165: ELSE
3166:
3167: DELETE FROM xla_diag_events
3168: WHERE event_id IN
3169: (SELECT event_id FROM xla_diag_events
3170: WHERE application_id = p_application_id )
3171: ;

Line 3169: (SELECT event_id FROM xla_diag_events

3165: ELSE
3166:
3167: DELETE FROM xla_diag_events
3168: WHERE event_id IN
3169: (SELECT event_id FROM xla_diag_events
3170: WHERE application_id = p_application_id )
3171: ;
3172:
3173: END IF;

Line 3184: write_logfile('** End ** purge of xla_diag_events');

3180: ,p_module => l_log_module);
3181: END IF;
3182:
3183: write_logfile('Number of rows deleted ='||SQL%ROWCOUNT);
3184: write_logfile('** End ** purge of xla_diag_events');
3185: write_logfile('**Start** purge of xla_diag_ledgers');
3186:
3187:
3188: DELETE FROM xla_diag_ledgers

Line 3192: FROM xla_diag_events

3188: DELETE FROM xla_diag_ledgers
3189: WHERE application_id = p_application_id
3190: AND primary_ledger_id NOT IN
3191: (SELECT ledger_id
3192: FROM xla_diag_events
3193: WHERE application_id = p_application_id
3194: )
3195: ;
3196: