DBA Data[Home] [Help]

APPS.XLA_EVENTS_PKG dependencies on XLA_ENTITY_TYPES_B

Line 5452: from xla_entity_types_b

5448: (p_entity_type_code => p_entity_type_code);
5449:
5450: select enable_gapless_events_flag
5451: into g_gapless_flag
5452: from xla_entity_types_b
5453: where entity_code=p_entity_type_code
5454: and application_id=p_application_id;
5455:
5456: IF (C_LEVEL_STATEMENT>= g_log_level) THEN

Line 6061: FROM xla_events_int_gt xeg, xla_events xe, xla_entity_types_b xet

6057: -- 3. no manual entity events are modified
6058: -- 4. application_id is populated and all equals p_application_id
6059: CURSOR csr_manual_processed_events(app_id NUMBER) is
6060: SELECT 1
6061: FROM xla_events_int_gt xeg, xla_events xe, xla_entity_types_b xet
6062: WHERE xeg.application_id = xe.application_id (+)
6063: AND xeg.event_id = xe.event_id (+)
6064: AND xeg.entity_code = xet.entity_code (+)
6065: AND xet.application_id(+) = app_id

Line 6100: FROM xla_events_int_gt xeg, xla_entity_types_b xet

6096: FROM xla_transaction_entities xte
6097: WHERE xte.application_id = p_application_id
6098: AND xte.entity_id in
6099: (SELECT entity_id
6100: FROM xla_events_int_gt xeg, xla_entity_types_b xet
6101: WHERE xeg.application_id = xet.application_id
6102: AND xeg.entity_code = xet.entity_code
6103: AND xet.enable_gapless_events_flag = 'Y')
6104: FOR UPDATE NOWAIT;

Line 6110: xla_entity_types_b xet

6106: Cursor csr_new_gap is
6107: Select min(xe.event_number), xe.entity_id, xe.application_id
6108: From xla_events_int_gt xeg,
6109: xla_events xe,
6110: xla_entity_types_b xet
6111: Where xeg.event_id = xe.event_id
6112: And xeg.application_id = xe.application_id
6113: And xeg.entity_code = xet.entity_code
6114: And xeg.application_id = xet.application_id

Line 6132: xla_entity_types_b xet

6128: And xe.entity_id in (
6129: Select xe.entity_id
6130: From xla_events_int_gt xeg,
6131: xla_events xe,
6132: xla_entity_types_b xet
6133: Where xeg.event_id = xe.event_id
6134: And xet.entity_code = xeg.entity_code
6135: And xet.application_id = xe.application_id
6136: And xet.enable_gapless_events_flag = 'Y'

Line 6503: FROM xla_events_int_gt xeg, xla_entity_types_b xet

6499: FROM xla_transaction_entities xte
6500: WHERE xte.application_id = p_application_id
6501: AND xte.entity_id in
6502: (SELECT entity_id
6503: FROM xla_events_int_gt xeg, xla_entity_types_b xet
6504: WHERE xeg.application_id = xet.application_id
6505: AND xeg.entity_code = xet.entity_code
6506: AND xet.enable_gapless_events_flag = 'Y')
6507: FOR UPDATE NOWAIT;

Line 6513: xla_entity_types_b xet

6509: Cursor csr_new_gap is
6510: Select min(xe.event_number), xe.entity_id, xe.application_id
6511: From xla_events_int_gt xeg,
6512: xla_events xe,
6513: xla_entity_types_b xet
6514: Where xeg.event_id = xe.event_id
6515: And xeg.application_id = xe.application_id
6516: And xeg.entity_code = xet.entity_code
6517: And xeg.application_id = xet.application_id

Line 7882: FROM xla_entity_types_b t

7878: ,m.source_id_col_name_2
7879: ,m.source_id_col_name_3
7880: ,m.source_id_col_name_4
7881: ,t.enabled_flag
7882: FROM xla_entity_types_b t
7883: ,xla_entity_id_mappings m
7884: WHERE t.application_id = g_application_id
7885: AND t.application_id = m.application_id
7886: AND t.entity_code = m.entity_code;

Line 8618: ,xla_entity_types_b xet

8614: ,max(xe.event_number)
8615: ,xet.enable_gapless_events_flag
8616: FROM xla_transaction_entities xte
8617: ,xla_events xe
8618: ,xla_entity_types_b xet
8619: WHERE xte.application_id = p_source_info.application_id
8620: AND xte.ledger_id = p_source_info.ledger_id
8621: AND xte.entity_code = p_source_info.entity_type_code
8622: AND NVL(xte.source_id_int_1,-99) = NVL(p_source_info.source_id_int_1,-99)

Line 8644: FROM xla_entity_types_b a

8640:
8641:
8642: CURSOR get_gapless_flag is
8643: SELECT a.enable_gapless_events_flag
8644: FROM xla_entity_types_b a
8645: WHERE a.entity_code=p_source_info.entity_type_code
8646: AND a.application_id=p_source_info.application_id;
8647:
8648: CURSOR c2 IS

Line 8656: ,xla_entity_types_b c

8652: ,MAX(b.event_number)
8653: ,c.enable_gapless_events_flag
8654: FROM xla_transaction_entities a
8655: ,xla_events b
8656: ,xla_entity_types_b c
8657: WHERE a.application_id = p_source_info.application_id
8658: AND a.entity_id = g_entity_id
8659: AND b.entity_id = g_entity_id
8660: AND b.application_id = a.application_id -- 8967771

Line 8705: ,xla_entity_types_b xet

8701: ,nvl(max(xe.event_number),0)
8702: ,xet.enable_gapless_events_flag
8703: FROM xla_transaction_entities xte
8704: ,xla_events xe
8705: ,xla_entity_types_b xet
8706: WHERE xte.application_id = p_source_info.application_id
8707: AND xte.ledger_id = p_source_info.ledger_id
8708: AND xte.entity_code = p_source_info.entity_type_code
8709: AND NVL(xte.source_id_int_1,-99) = NVL(p_source_info.source_id_int_1,-99)