eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_EVENTS_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 82: | XLA_TRANSACTION_ENTITIES and |

78: | Cleaned up Exception messages. |
79: | 23-Jul-02 S. Singhania Modified code to handle to issue of 'enabled |
80: | flags'.( see DLD closed issues). |
81: | 14-Aug-02 S. Singhania Changed XLA_ENTITES and XLA_ENTITIES_S to |
82: | XLA_TRANSACTION_ENTITIES and |
83: | XLA_TRANSACTION_ENTITIES_S |
84: | 09-Sep-02 S. Singhania Made changes to 'cache_entity_info' to handle |
85: | MANUAL events. Bug # 2529997. |
86: | 09-Sep-02 S. Singhania modified 'create_bulk_events' routine (with |

Line 83: | XLA_TRANSACTION_ENTITIES_S |

79: | 23-Jul-02 S. Singhania Modified code to handle to issue of 'enabled |
80: | flags'.( see DLD closed issues). |
81: | 14-Aug-02 S. Singhania Changed XLA_ENTITES and XLA_ENTITIES_S to |
82: | XLA_TRANSACTION_ENTITIES and |
83: | XLA_TRANSACTION_ENTITIES_S |
84: | 09-Sep-02 S. Singhania Made changes to 'cache_entity_info' to handle |
85: | MANUAL events. Bug # 2529997. |
86: | 09-Sep-02 S. Singhania modified 'create_bulk_events' routine (with |
87: | single array) to handle entities belonging |

Line 129: | to lock rows in xla_transaction_entities. |

125: | - VALIDATE_EVNENT_CLASS_CODE |
126: | - VALIDATE_EVNET_TYPE_CODE. |
127: | 12-Dec-03 S. Singhania Bug # 3268790. |
128: | - Modified cursors in CACHE_ENTITY_INFO not |
129: | to lock rows in xla_transaction_entities. |
130: | - Routines DELETE_EVENTS and DELETE_EVENT |
131: | are modified not to delete entites when |
132: | last STANDARD event is deleted for the |
133: | entity. |

Line 137: | from xla_transaction_entities(bug 3316535) |

133: | entity. |
134: | 04-Mar-04 W. Shen Gapless event processing project |
135: | 25-Mar-04 W. Shen add trace |
136: | 23-Jun-04 W. Shen New API delete_entity to delete entities |
137: | from xla_transaction_entities(bug 3316535) |
138: | 10-Aug-04 S. Singhania Added trace messages to help debug the code |
139: | 23-OCT-04 W. Shen New API to delete/update/create event in bulk |
140: | 09-Nov-04 S. Singhania Made chnages for valuation method enhancements|
141: | Following routines were modified: |

Line 2726: DELETE xla_transaction_entities xte

2722: ----------------------------------------------------------------------
2723: -- following will delete the row from entities if there is no
2724: -- event exists for the entity
2725: ----------------------------------------------------------------------
2726: DELETE xla_transaction_entities xte
2727: WHERE xte.entity_id = g_entity_id
2728: AND xte.application_id = g_application_id
2729: AND NOT EXISTS
2730: (SELECT '1' FROM xla_events xe

Line 3011: DELETE xla_transaction_entities xte

3007: -------------------------------------------------------------------------
3008: -- following will delete the row from entities if there is no
3009: -- event exists for the entity
3010: -------------------------------------------------------------------------
3011: DELETE xla_transaction_entities xte
3012: WHERE xte.entity_id = g_entity_id
3013: AND xte.application_id = g_application_id
3014: AND NOT EXISTS
3015: (SELECT '1' FROM xla_events xe

Line 3381: l_entity_id XLA_TRANSACTION_ENTITIES.ENTITY_ID%TYPE;

3377: RETURN INTEGER IS
3378:
3379: l_log_module VARCHAR2(240);
3380: l_temp NUMBER;
3381: l_entity_id XLA_TRANSACTION_ENTITIES.ENTITY_ID%TYPE;
3382: cursor c_existing_events is
3383: select 1
3384: from xla_events
3385: where entity_id=l_entity_id;

Line 3506: FROM xla_transaction_entities a

3502:
3503: BEGIN
3504: SELECT entity_id
3505: INTO l_entity_id
3506: FROM xla_transaction_entities a
3507: WHERE a.application_id = p_source_info.application_id
3508: AND a.ledger_id = p_source_info.ledger_id
3509: AND a.entity_code = p_source_info.entity_type_code
3510: AND NVL(a.source_id_int_1,-99) =

Line 3574: DELETE xla_transaction_entities

3570: RETURN 1;
3571: END IF;
3572: CLOSE c_existing_events;
3573:
3574: DELETE xla_transaction_entities
3575: WHERE entity_id = l_entity_id
3576: AND application_id = p_source_info.application_id;
3577:
3578: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 5343: SELECT xla_transaction_entities_s.nextval

5339: l_update_gt_string varchar2(4000);
5340: l_query_string varchar2(4000);
5341:
5342: CURSOR csr_get_trx_entities is
5343: SELECT xla_transaction_entities_s.nextval
5344: ,source_id_int_1
5345: ,source_id_int_2
5346: ,source_id_int_3
5347: ,source_id_int_4

Line 5576: (p_msg => 'just before insert into xla_transaction entities'

5572: END;
5573:
5574: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
5575: trace
5576: (p_msg => 'just before insert into xla_transaction entities'
5577: ,p_level => C_LEVEL_STATEMENT
5578: ,p_module =>l_log_module);
5579: END IF;
5580:

Line 5605: INSERT INTO xla_transaction_entities

5601: ,l_array_valuation_method
5602: LIMIT g_limit_event_size;
5603:
5604: FORALL i in 1..l_array_entity_id.COUNT
5605: INSERT INTO xla_transaction_entities
5606: (entity_id
5607: ,application_id
5608: ,source_application_id
5609: ,ledger_id

Line 6096: FROM xla_transaction_entities xte

6092: OR xeg.event_status_code not in ('I', 'N', 'U'));
6093:
6094: CURSOR csr_lock_te is
6095: SELECT xte.entity_id
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

Line 6246: -- lock the entity in xla_transaction_entities table

6242: ,p_level => C_LEVEL_STATEMENT
6243: ,p_module =>l_log_module);
6244: END IF;
6245:
6246: -- lock the entity in xla_transaction_entities table
6247: -- for the entities that require gapless processing
6248: open csr_lock_te;
6249: close csr_lock_te;
6250:

Line 6466: FROM xla_events_int_gt xeg, xla_events xe, xla_transaction_entities xte

6462: -- 3. no manual entity events are modified
6463: -- 4. application_id is populated and all equals p_application_id
6464: CURSOR csr_manual_processed_events(app_id NUMBER) is
6465: SELECT 1
6466: FROM xla_events_int_gt xeg, xla_events xe, xla_transaction_entities xte
6467: WHERE xeg.application_id = xe.application_id (+)
6468: AND xeg.event_id = xe.event_id (+)
6469: AND xe.entity_id = xte.entity_id (+)
6470: AND xte.application_id(+) = app_id

Line 6499: FROM xla_transaction_entities xte

6495: AND xe.event_status_code not in ('I', 'N', 'U');
6496:
6497: CURSOR csr_lock_te is
6498: SELECT xte.entity_id
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

Line 6636: -- lock the entity in xla_transaction_entities table

6632: ,p_level => C_LEVEL_STATEMENT
6633: ,p_module =>l_log_module);
6634: END IF;
6635:
6636: -- lock the entity in xla_transaction_entities table
6637: -- for the entities that require gapless processing
6638: open csr_lock_te;
6639: close csr_lock_te;
6640:

Line 6722: DELETE xla_transaction_entities xte

6718: ,p_level => C_LEVEL_STATEMENT
6719: ,p_module =>l_log_module);
6720: END IF;
6721:
6722: DELETE xla_transaction_entities xte
6723: WHERE not exists (SELECT 1
6724: FROM xla_events xe
6725: WHERE xe.entity_id = xte.entity_id
6726: AND xe.application_id = xte.application_id)

Line 8616: FROM xla_transaction_entities xte

8612: ,xte.entity_code
8613: ,xte.transaction_number
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

Line 8654: FROM xla_transaction_entities a

8650: ,a.entity_code
8651: ,a.transaction_number
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

Line 8678: FROM xla_transaction_entities a

8674: SELECT a.entity_id
8675: ,a.entity_code
8676: ,a.transaction_number
8677: ,b.event_number
8678: FROM xla_transaction_entities a
8679: ,xla_events b
8680: WHERE b.event_id = eventid
8681: AND b.application_id = p_source_info.application_id -- 8967771
8682: AND a.entity_id = b.entity_id

Line 8690: FROM xla_transaction_entities a

8686:
8687:
8688: CURSOR c_lock_te (entityid in number) is
8689: SELECT a.entity_id
8690: FROM xla_transaction_entities a
8691: WHERE a.entity_id=entityid
8692: AND a.application_id = p_source_info.application_id
8693: FOR UPDATE NOWAIT;
8694:

Line 8703: FROM xla_transaction_entities xte

8699: ,xte.entity_code
8700: ,xte.transaction_number
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

Line 9069: INSERT INTO xla_transaction_entities

9065: ,p_level => C_LEVEL_PROCEDURE
9066: ,p_module =>l_log_module);
9067: END IF;
9068:
9069: INSERT INTO xla_transaction_entities
9070: (entity_id
9071: ,application_id
9072: ,source_application_id
9073: ,ledger_id

Line 9098: (xla_transaction_entities_s.nextval

9094: ,source_id_char_2
9095: ,source_id_char_3
9096: ,source_id_char_4)
9097: VALUES
9098: (xla_transaction_entities_s.nextval
9099: ,p_event_source_info.application_id
9100: ,NVL(p_event_source_info.source_application_id,
9101: p_event_source_info.application_id)
9102: ,p_event_source_info.ledger_id

Line 9188: UPDATE xla_transaction_entities

9184: ,p_level => C_LEVEL_PROCEDURE
9185: ,p_module =>l_log_module);
9186: END IF;
9187:
9188: UPDATE xla_transaction_entities
9189: SET transaction_number = p_transaction_number
9190: WHERE entity_id = g_entity_id
9191: AND application_id = g_application_id;
9192: