[Home] [Help]
4987: (p_entity_type_code => p_entity_type_code);
4988:
4989: select enable_gapless_events_flag
4990: into g_gapless_flag
4991: from xla_entity_types_b
4992: where entity_code=p_entity_type_code
4993: and application_id=p_application_id;
4994:
4995: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
5511: -- 3. no manual entity events are modified
5512: -- 4. application_id is populated and all equals p_application_id
5513: CURSOR csr_manual_processed_events(app_id NUMBER) is
5514: SELECT 1
5515: FROM xla_events_int_gt xeg, xla_events xe, xla_entity_types_b xet
5516: WHERE xeg.application_id = xe.application_id (+)
5517: AND xeg.event_id = xe.event_id (+)
5518: AND xeg.entity_code = xet.entity_code (+)
5519: AND xet.application_id(+) = app_id
5550: FROM xla_transaction_entities xte
5551: WHERE xte.application_id = p_application_id
5552: AND xte.entity_id in
5553: (SELECT entity_id
5554: FROM xla_events_int_gt xeg, xla_entity_types_b xet
5555: WHERE xeg.application_id = xet.application_id
5556: AND xeg.entity_code = xet.entity_code
5557: AND xet.enable_gapless_events_flag = 'Y')
5558: FOR UPDATE NOWAIT;
5560: Cursor csr_new_gap is
5561: Select min(xe.event_number), xe.entity_id, xe.application_id
5562: From xla_events_int_gt xeg,
5563: xla_events xe,
5564: xla_entity_types_b xet
5565: Where xeg.event_id = xe.event_id
5566: And xeg.application_id = xe.application_id
5567: And xeg.entity_code = xet.entity_code
5568: And xeg.application_id = xet.application_id
5582: And xe.entity_id in (
5583: Select xe.entity_id
5584: From xla_events_int_gt xeg,
5585: xla_events xe,
5586: xla_entity_types_b xet
5587: Where xeg.event_id = xe.event_id
5588: And xet.entity_code = xeg.entity_code
5589: And xet.application_id = xe.application_id
5590: And xet.enable_gapless_events_flag = 'Y'
5915: FROM xla_transaction_entities xte
5916: WHERE xte.application_id = p_application_id
5917: AND xte.entity_id in
5918: (SELECT entity_id
5919: FROM xla_events_int_gt xeg, xla_entity_types_b xet
5920: WHERE xeg.application_id = xet.application_id
5921: AND xeg.entity_code = xet.entity_code
5922: AND xet.enable_gapless_events_flag = 'Y')
5923: FOR UPDATE NOWAIT;
5925: Cursor csr_new_gap is
5926: Select min(xe.event_number), xe.entity_id, xe.application_id
5927: From xla_events_int_gt xeg,
5928: xla_events xe,
5929: xla_entity_types_b xet
5930: Where xeg.event_id = xe.event_id
5931: And xeg.application_id = xe.application_id
5932: And xeg.entity_code = xet.entity_code
5933: And xeg.application_id = xet.application_id
7290: ,m.source_id_col_name_2
7291: ,m.source_id_col_name_3
7292: ,m.source_id_col_name_4
7293: ,t.enabled_flag
7294: FROM xla_entity_types_b t
7295: ,xla_entity_id_mappings m
7296: WHERE t.application_id = g_application_id
7297: AND t.application_id = m.application_id
7298: AND t.entity_code = m.entity_code;
8026: ,max(xe.event_number)
8027: ,xet.enable_gapless_events_flag
8028: FROM xla_transaction_entities xte
8029: ,xla_events xe
8030: ,xla_entity_types_b xet
8031: WHERE xte.application_id = p_source_info.application_id
8032: AND xte.ledger_id = p_source_info.ledger_id
8033: AND xte.entity_code = p_source_info.entity_type_code
8034: AND NVL(xte.source_id_int_1,-99) = NVL(p_source_info.source_id_int_1,-99)
8051:
8052:
8053: CURSOR get_gapless_flag is
8054: SELECT a.enable_gapless_events_flag
8055: FROM xla_entity_types_b a
8056: WHERE a.entity_code=p_source_info.entity_type_code
8057: AND a.application_id=p_source_info.application_id;
8058:
8059: CURSOR c2 IS
8063: ,MAX(b.event_number)
8064: ,c.enable_gapless_events_flag
8065: FROM xla_transaction_entities a
8066: ,xla_events b
8067: ,xla_entity_types_b c
8068: WHERE a.application_id = p_source_info.application_id
8069: AND a.entity_id = g_entity_id
8070: AND b.entity_id = g_entity_id
8071: and a.entity_code=c.entity_code