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 2671: DELETE xla_transaction_entities xte

2667: ----------------------------------------------------------------------
2668: -- following will delete the row from entities if there is no
2669: -- event exists for the entity
2670: ----------------------------------------------------------------------
2671: DELETE xla_transaction_entities xte
2672: WHERE xte.entity_id = g_entity_id
2673: AND xte.application_id = g_application_id
2674: AND NOT EXISTS
2675: (SELECT '1' FROM xla_events xe

Line 2952: DELETE xla_transaction_entities xte

2948: -------------------------------------------------------------------------
2949: -- following will delete the row from entities if there is no
2950: -- event exists for the entity
2951: -------------------------------------------------------------------------
2952: DELETE xla_transaction_entities xte
2953: WHERE xte.entity_id = g_entity_id
2954: AND xte.application_id = g_application_id
2955: AND NOT EXISTS
2956: (SELECT '1' FROM xla_events xe

Line 3316: l_entity_id XLA_TRANSACTION_ENTITIES.ENTITY_ID%TYPE;

3312: RETURN INTEGER IS
3313:
3314: l_log_module VARCHAR2(240);
3315: l_temp NUMBER;
3316: l_entity_id XLA_TRANSACTION_ENTITIES.ENTITY_ID%TYPE;
3317: cursor c_existing_events is
3318: select 1
3319: from xla_events
3320: where entity_id=l_entity_id;

Line 3441: FROM xla_transaction_entities a

3437:
3438: BEGIN
3439: SELECT entity_id
3440: INTO l_entity_id
3441: FROM xla_transaction_entities a
3442: WHERE a.application_id = p_source_info.application_id
3443: AND a.ledger_id = p_source_info.ledger_id
3444: AND a.entity_code = p_source_info.entity_type_code
3445: AND NVL(a.source_id_int_1,C_NUM) =

Line 3509: DELETE xla_transaction_entities

3505: RETURN 1;
3506: END IF;
3507: CLOSE c_existing_events;
3508:
3509: DELETE xla_transaction_entities
3510: WHERE entity_id = l_entity_id
3511: AND application_id = p_source_info.application_id;
3512:
3513: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 4882: SELECT xla_transaction_entities_s.nextval

4878: l_update_gt_string varchar2(4000);
4879: l_query_string varchar2(4000);
4880:
4881: CURSOR csr_get_trx_entities is
4882: SELECT xla_transaction_entities_s.nextval
4883: ,source_id_int_1
4884: ,source_id_int_2
4885: ,source_id_int_3
4886: ,source_id_int_4

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

5111: END;
5112:
5113: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
5114: trace
5115: (p_msg => 'just before insert into xla_transaction entities'
5116: ,p_level => C_LEVEL_STATEMENT
5117: ,p_module =>l_log_module);
5118: END IF;
5119:

Line 5143: INSERT INTO xla_transaction_entities

5139: ,l_array_valuation_method
5140: LIMIT 2000;
5141:
5142: FORALL i in 1..l_array_entity_id.COUNT
5143: INSERT INTO xla_transaction_entities
5144: (entity_id
5145: ,application_id
5146: ,source_application_id
5147: ,ledger_id

Line 5550: FROM xla_transaction_entities xte

5546: OR xeg.event_status_code not in ('I', 'N', 'U'));
5547:
5548: CURSOR csr_lock_te is
5549: SELECT xte.entity_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

Line 5700: -- lock the entity in xla_transaction_entities table

5696: ,p_level => C_LEVEL_STATEMENT
5697: ,p_module =>l_log_module);
5698: END IF;
5699:
5700: -- lock the entity in xla_transaction_entities table
5701: -- for the entities that require gapless processing
5702: open csr_lock_te;
5703: close csr_lock_te;
5704:

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

5878: -- 3. no manual entity events are modified
5879: -- 4. application_id is populated and all equals p_application_id
5880: CURSOR csr_manual_processed_events(app_id NUMBER) is
5881: SELECT 1
5882: FROM xla_events_int_gt xeg, xla_events xe, xla_transaction_entities xte
5883: WHERE xeg.application_id = xe.application_id (+)
5884: AND xeg.event_id = xe.event_id (+)
5885: AND xe.entity_id = xte.entity_id (+)
5886: AND xte.application_id(+) = app_id

Line 5915: FROM xla_transaction_entities xte

5911: AND xe.event_status_code not in ('I', 'N', 'U');
5912:
5913: CURSOR csr_lock_te is
5914: SELECT xte.entity_id
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

Line 6051: -- lock the entity in xla_transaction_entities table

6047: ,p_level => C_LEVEL_STATEMENT
6048: ,p_module =>l_log_module);
6049: END IF;
6050:
6051: -- lock the entity in xla_transaction_entities table
6052: -- for the entities that require gapless processing
6053: open csr_lock_te;
6054: close csr_lock_te;
6055:

Line 6133: DELETE xla_transaction_entities xte

6129: ,p_level => C_LEVEL_STATEMENT
6130: ,p_module =>l_log_module);
6131: END IF;
6132:
6133: DELETE xla_transaction_entities xte
6134: WHERE not exists (
6135: SELECT 1
6136: FROM xla_events xe
6137: WHERE xe.entity_id = xte.entity_id

Line 8028: FROM xla_transaction_entities xte

8024: ,xte.entity_code
8025: ,xte.transaction_number
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

Line 8065: FROM xla_transaction_entities a

8061: ,a.entity_code
8062: ,a.transaction_number
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

Line 8088: FROM xla_transaction_entities a

8084: SELECT a.entity_id
8085: ,a.entity_code
8086: ,a.transaction_number
8087: ,b.event_number
8088: FROM xla_transaction_entities a
8089: ,xla_events b
8090: WHERE b.event_id = eventid
8091: AND a.entity_id = b.entity_id
8092: AND a.application_id = p_source_info.application_id;

Line 8097: FROM xla_transaction_entities a

8093: -- FOR UPDATE NOWAIT;
8094:
8095: CURSOR c_lock_te (entityid in number) is
8096: SELECT a.entity_id
8097: FROM xla_transaction_entities a
8098: WHERE a.entity_id=entityid
8099: AND a.application_id = p_source_info.application_id
8100: FOR UPDATE NOWAIT;
8101: l_log_module VARCHAR2(240);

Line 8340: INSERT INTO xla_transaction_entities

8336: ,p_level => C_LEVEL_PROCEDURE
8337: ,p_module =>l_log_module);
8338: END IF;
8339:
8340: INSERT INTO xla_transaction_entities
8341: (entity_id
8342: ,application_id
8343: ,source_application_id
8344: ,ledger_id

Line 8369: (xla_transaction_entities_s.nextval

8365: ,source_id_char_2
8366: ,source_id_char_3
8367: ,source_id_char_4)
8368: VALUES
8369: (xla_transaction_entities_s.nextval
8370: ,p_event_source_info.application_id
8371: ,NVL(p_event_source_info.source_application_id,
8372: p_event_source_info.application_id)
8373: ,p_event_source_info.ledger_id

Line 8459: UPDATE xla_transaction_entities

8455: ,p_level => C_LEVEL_PROCEDURE
8456: ,p_module =>l_log_module);
8457: END IF;
8458:
8459: UPDATE xla_transaction_entities
8460: SET transaction_number = p_transaction_number
8461: WHERE entity_id = g_entity_id
8462: AND application_id = g_application_id;
8463: