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_EVENTS_INT_GT

Line 4848: FROM xla_events_int_gt;

4844: l_log_module VARCHAR2(240);
4845:
4846: CURSOR csr_xla_event_exist IS
4847: SELECT 1
4848: FROM xla_events_int_gt;
4849:
4850: CURSOR csr_xla_event_number IS
4851: SELECT 1
4852: FROM xla_events_int_gt

Line 4852: FROM xla_events_int_gt

4848: FROM xla_events_int_gt;
4849:
4850: CURSOR csr_xla_event_number IS
4851: SELECT 1
4852: FROM xla_events_int_gt
4853: WHERE event_number is null or event_number<1;
4854:
4855: CURSOR csr_processing_gapless IS
4856: SELECT entity_id, event_id, event_number, event_status_code

Line 4857: FROM xla_events_int_gt

4853: WHERE event_number is null or event_number<1;
4854:
4855: CURSOR csr_processing_gapless IS
4856: SELECT entity_id, event_id, event_number, event_status_code
4857: FROM xla_events_int_gt
4858: ORDER BY entity_id, event_number;
4859:
4860: CURSOR csr_status_error is
4861: SELECT 1 from xla_events_int_gt

Line 4861: SELECT 1 from xla_events_int_gt

4857: FROM xla_events_int_gt
4858: ORDER BY entity_id, event_number;
4859:
4860: CURSOR csr_status_error is
4861: SELECT 1 from xla_events_int_gt
4862: WHERE event_status_code not in ('I', 'U', 'N');
4863:
4864: CURSOR csr_event_type_error(p_entity_code VARCHAR2, p_app_id NUMBER) is
4865: SELECT 1

Line 4866: FROM xla_events_int_gt xeg, xla_event_types_b xet

4862: WHERE event_status_code not in ('I', 'U', 'N');
4863:
4864: CURSOR csr_event_type_error(p_entity_code VARCHAR2, p_app_id NUMBER) is
4865: SELECT 1
4866: FROM xla_events_int_gt xeg, xla_event_types_b xet
4867: WHERE xet.entity_code(+) = p_entity_code
4868: AND xet.application_id(+) = p_app_id
4869: AND xeg.event_type_code = xet.event_type_code (+)
4870: AND nvl(xet.enabled_flag, 'N') = 'N';

Line 4874: FROM xla_events_int_gt xeg

4870: AND nvl(xet.enabled_flag, 'N') = 'N';
4871:
4872: CURSOR csr_parameter_mismatch(p_entity_code VARCHAR2, p_app_id NUMBER) is
4873: SELECT 1
4874: FROM xla_events_int_gt xeg
4875: WHERE xeg.entity_code <> p_entity_code
4876: OR xeg.application_id <> p_app_id;
4877:
4878: l_update_gt_string varchar2(4000);

Line 4903: FROM xla_events_int_gt);

4899: ,source_id_char_2
4900: ,source_id_char_3
4901: ,source_id_char_4
4902: ,valuation_method
4903: FROM xla_events_int_gt);
4904:
4905: BEGIN
4906: IF g_log_enabled THEN
4907: l_log_module := C_DEFAULT_MODULE||'.create_bulk_events';

Line 4966: select count(1) into l_rowcount_gt from xla_events_int_gt;

4962: ----------------------------------------------------------------------------
4963: -- Immediately exit if the table is empty
4964: -- the l_rowcount_gt is also useful to find if there is invalid data
4965: ----------------------------------------------------------------------------
4966: select count(1) into l_rowcount_gt from xla_events_int_gt;
4967: if(l_rowcount_gt = 0) then
4968: return;
4969: end if;
4970:

Line 5034: FROM xla_events_int_gt xeg

5030: 'SELECT 1
5031: FROM dual
5032: WHERE EXISTS
5033: (SELECT 1
5034: FROM xla_events_int_gt xeg
5035: WHERE xeg.entity_code <> :1
5036: OR xeg.application_id <> :2
5037: OR xeg.event_status_code not in (''I'', ''U'', ''N'')
5038: OR xeg.event_type_code not in

Line 5062: 'The parameters passed to the procedure do not match with the data in the xla_events_int_gt table'

5058: (p_appli_s_name => 'XLA'
5059: ,p_msg_name => 'XLA_COMMON_ERROR'
5060: ,p_token_1 => 'ERROR'
5061: ,p_value_1 =>
5062: 'The parameters passed to the procedure do not match with the data in the xla_events_int_gt table'
5063: ,p_token_2 => 'LOCATION'
5064: ,p_value_2 => 'xla_events_pkg.create_bulk_events');
5065: return;
5066: end if;

Line 5171: (SELECT /+ index (xe xla_events_int_gt_n1) /

5167: ,source_id_char_1
5168: ,source_id_char_2
5169: ,source_id_char_3
5170: ,source_id_char_4)
5171: (SELECT /*+ index (xe xla_events_int_gt_n1) */
5172: l_array_entity_id(i)
5173: , p_application_id
5174: , nvl(p_source_application_id, p_application_id)
5175: , p_ledger_id

Line 5199: FROM xla_events_int_gt xe

5195: , xe.source_id_char_1
5196: , xe.source_id_char_2
5197: , xe.source_id_char_3
5198: , xe.source_id_char_4
5199: FROM xla_events_int_gt xe
5200: WHERE NVL( xe.source_id_int_1,-99) = NVL(l_array_source_id_int_1(i),C_NUM)
5201: AND NVL( xe.source_id_int_2,-99) = NVL(l_array_source_id_int_2(i),C_NUM)
5202: AND NVL( xe.source_id_int_3,-99) = NVL(l_array_source_id_int_3(i),C_NUM)
5203: AND NVL( xe.source_id_int_4,-99) = NVL(l_array_source_id_int_4(i),C_NUM)

Line 5213: UPDATE /+ index (xe xla_events_int_gt_n1) / xla_events_int_gt xe

5209: AND ROWNUM = 1
5210: );
5211:
5212: FORALL i IN 1..l_array_entity_id.COUNT
5213: UPDATE /*+ index (xe xla_events_int_gt_n1) */ xla_events_int_gt xe
5214: SET xe.entity_id = l_array_entity_id(i)
5215: , xe.event_id = xla_events_s.nextval
5216: WHERE NVL( xe.source_id_int_1,-99)= NVL(l_array_source_id_int_1(i),C_NUM)
5217: AND NVL( xe.source_id_int_2,-99) = NVL(l_array_source_id_int_2(i),C_NUM)

Line 5288: UPDATE xla_events_int_gt

5284: END IF;
5285: END LOOP;
5286:
5287: FORALL i in 1..l_array_event_id.COUNT
5288: UPDATE xla_events_int_gt
5289: SET on_hold_flag = l_array_on_hold_flag(i)
5290: WHERE event_id=l_array_event_id(i);
5291:
5292: EXIT when csr_processing_gapless%NOTFOUND;

Line 5346: ,nvl(xla_events_int_gt.budgetary_control_flag,'N')

5342: ,event_status_code
5343: ,C_INTERNAL_UNPROCESSED
5344: ,TRUNC(event_date)
5345: ,nvl(transaction_date, TRUNC(event_date))
5346: ,nvl(xla_events_int_gt.budgetary_control_flag,'N')
5347: ,sysdate
5348: ,xla_environment_pkg.g_usr_id
5349: ,sysdate
5350: ,xla_environment_pkg.g_usr_id

Line 5369: FROM xla_events_int_gt);

5365: ,reference_date_2
5366: ,reference_date_3
5367: ,reference_date_4
5368: ,on_hold_flag
5369: FROM xla_events_int_gt);
5370: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5371: trace
5372: (p_msg => 'Number of events created(gapless) = '||
5373: to_char(SQL%ROWCOUNT)

Line 5431: ,nvl(xla_events_int_gt.budgetary_control_flag,'N')

5427: ,event_status_code
5428: ,C_INTERNAL_UNPROCESSED
5429: ,TRUNC(event_date)
5430: ,nvl(transaction_date, TRUNC(event_date))
5431: ,nvl(xla_events_int_gt.budgetary_control_flag,'N')
5432: ,sysdate
5433: ,xla_environment_pkg.g_usr_id
5434: ,sysdate
5435: ,xla_environment_pkg.g_usr_id

Line 5454: FROM xla_events_int_gt);

5450: ,reference_date_2
5451: ,reference_date_3
5452: ,reference_date_4
5453: ,'N'
5454: FROM xla_events_int_gt);
5455: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5456: trace
5457: (p_msg => 'Number of events created(non gapless) = '||
5458: to_char(SQL%ROWCOUNT)

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

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

Line 5530: FROM xla_events_int_gt xeg

5526: OR xeg.application_id <> app_id);
5527:
5528: CURSOR csr_invalid_app(app_id NUMBER) is
5529: SELECT 1
5530: FROM xla_events_int_gt xeg
5531: WHERE xeg.application_id <> app_id;
5532:
5533: CURSOR csr_invalid_event_id(app_id NUMBER) is
5534: SELECT 1

Line 5535: FROM xla_events_int_gt xeg, xla_events xe

5531: WHERE xeg.application_id <> app_id;
5532:
5533: CURSOR csr_invalid_event_id(app_id NUMBER) is
5534: SELECT 1
5535: FROM xla_events_int_gt xeg, xla_events xe
5536: WHERE xeg.application_id = xe.application_id (+)
5537: AND xeg.event_id = xe.event_id (+)
5538: AND xe.event_id is null;
5539:

Line 5542: FROM xla_events_int_gt xeg, xla_events xe

5538: AND xe.event_id is null;
5539:
5540: CURSOR csr_invalid_event_status(app_id NUMBER) is
5541: SELECT 1
5542: FROM xla_events_int_gt xeg, xla_events xe
5543: WHERE xeg.application_id = xe.application_id
5544: AND xeg.event_id = xe.event_id
5545: AND (xe.event_status_code not in ('I', 'N', 'U')
5546: OR xeg.event_status_code not in ('I', 'N', 'U'));

Line 5554: FROM xla_events_int_gt xeg, xla_entity_types_b xet

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;

Line 5562: From xla_events_int_gt xeg,

5558: FOR UPDATE NOWAIT;
5559:
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

Line 5580: FROM xla_events xe, xla_events_int_gt xeg

5576: Select xe.entity_id,
5577: xe.event_id,
5578: xe.event_number,
5579: nvl(xeg.event_status_code, xe.event_status_code)
5580: FROM xla_events xe, xla_events_int_gt xeg
5581: Where xe.event_id = xeg.event_id(+)
5582: And xe.entity_id in (
5583: Select xe.entity_id
5584: From xla_events_int_gt xeg,

Line 5584: From xla_events_int_gt xeg,

5580: FROM xla_events xe, xla_events_int_gt xeg
5581: Where xe.event_id = xeg.event_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

Line 5645: 'The parameter application_id does not match with the data in xla_events_int_gt table'

5641: (p_appli_s_name => 'XLA'
5642: ,p_msg_name => 'XLA_COMMON_ERROR'
5643: ,p_token_1 => 'ERROR'
5644: ,p_value_1 =>
5645: 'The parameter application_id does not match with the data in xla_events_int_gt table'
5646: ,p_token_2 => 'LOCATION'
5647: ,p_value_2 => 'xla_events_pkg.update_bulk_event_statuses(fn)');
5648: end if;
5649: close csr_invalid_app;

Line 5806: FROM xla_events_int_gt xeg

5802:
5803: UPDATE xla_events xe
5804: SET xe.event_status_code = (
5805: SELECT event_status_code
5806: FROM xla_events_int_gt xeg
5807: WHERE xeg.event_id = xe.event_id),
5808: xe.process_status_code = 'U'
5809: WHERE xe.event_id in (
5810: SELECT event_id

Line 5811: FROM xla_events_int_gt);

5807: WHERE xeg.event_id = xe.event_id),
5808: xe.process_status_code = 'U'
5809: WHERE xe.event_id in (
5810: SELECT event_id
5811: FROM xla_events_int_gt);
5812:
5813: /* -- Maintaining the Draft balance is no more required bug 5529569
5814:
5815: IF (C_LEVEL_STATEMENT>= g_log_level) THEN

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 5896: FROM xla_events_int_gt xeg

5892: OR xeg.application_id <> app_id);
5893:
5894: CURSOR csr_invalid_app(app_id NUMBER) is
5895: SELECT 1
5896: FROM xla_events_int_gt xeg
5897: WHERE xeg.application_id <> app_id;
5898:
5899: CURSOR csr_invalid_event_id(app_id NUMBER) is
5900: SELECT 1

Line 5901: FROM xla_events_int_gt xeg, xla_events xe

5897: WHERE xeg.application_id <> app_id;
5898:
5899: CURSOR csr_invalid_event_id(app_id NUMBER) is
5900: SELECT 1
5901: FROM xla_events_int_gt xeg, xla_events xe
5902: WHERE xeg.application_id = xe.application_id (+)
5903: AND xeg.event_id = xe.event_id (+)
5904: AND xe.event_id is null;
5905:

Line 5908: FROM xla_events_int_gt xeg, xla_events xe

5904: AND xe.event_id is null;
5905:
5906: CURSOR csr_invalid_event_status(app_id NUMBER) is
5907: SELECT 1
5908: FROM xla_events_int_gt xeg, xla_events xe
5909: WHERE xeg.application_id = xe.application_id
5910: AND xeg.event_id = xe.event_id
5911: AND xe.event_status_code not in ('I', 'N', 'U');
5912:

Line 5919: FROM xla_events_int_gt xeg, xla_entity_types_b xet

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;

Line 5927: From xla_events_int_gt xeg,

5923: FOR UPDATE NOWAIT;
5924:
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

Line 5988: 'The parameter application_id does not match with the data in xla_events_int_gt table'

5984: (p_appli_s_name => 'XLA'
5985: ,p_msg_name => 'XLA_COMMON_ERROR'
5986: ,p_token_1 => 'ERROR'
5987: ,p_value_1 =>
5988: 'The parameter application_id does not match with the data in xla_events_int_gt table'
5989: ,p_token_2 => 'LOCATION'
5990: ,p_value_2 => 'xla_events_pkg.update_bulk_event_statuses(fn)');
5991: end if;
5992: close csr_invalid_app;

Line 6039: select count(1) into l_rowcount_gt from xla_events_int_gt;

6035: ----------------------------------------------------------------------------
6036: -- Immediately exit if the table is empty
6037: -- the l_rowcount_gt is also useful to find if there is invalid data
6038: ----------------------------------------------------------------------------
6039: select count(1) into l_rowcount_gt from xla_events_int_gt;
6040: if(l_rowcount_gt = 0) then
6041: return;
6042: end if;
6043:

Line 6116: UPDATE xla_events_int_gt xeg

6112: ,p_level => C_LEVEL_STATEMENT
6113: ,p_module =>l_log_module);
6114: END IF;
6115:
6116: UPDATE xla_events_int_gt xeg
6117: SET xeg.entity_id =
6118: (SELECT xe.entity_id
6119: FROM xla_events xe
6120: WHERE xe.event_id = xeg.event_id);

Line 6125: FROM xla_events_int_gt);

6121:
6122: DELETE xla_events
6123: WHERE event_id in (
6124: SELECT event_id
6125: FROM xla_events_int_gt);
6126: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
6127: trace
6128: (p_msg => 'Number of events deleted:'||to_char(SQL%ROWCOUNT)
6129: ,p_level => C_LEVEL_STATEMENT

Line 6142: FROM xla_events_int_gt);

6138: AND xe.application_id = xte.application_id
6139: AND xte.application_id = p_application_id)
6140: AND entity_id in (
6141: SELECT entity_id
6142: FROM xla_events_int_gt);
6143:
6144: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
6145: trace
6146: (p_msg => 'Number of transaction entity deleted:'||

Line 8774: (SELECT xeg.event_id FROM xla_events_int_gt xeg, xla_events xe

8770: -- good: reduce the event_id that are selected
8771: -- bad: need to join to xla_events table
8772: DELETE FROM xla_accounting_errors
8773: WHERE event_id IN
8774: (SELECT xeg.event_id FROM xla_events_int_gt xeg, xla_events xe
8775: WHERE xeg.event_id = xe.event_id
8776: AND xe.event_status_code in ('D', 'I'));
8777:
8778: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 8789: FROM xla_events_int_gt xeg,

8785: -- Bug 5529420
8786: DELETE FROM xla_distribution_links
8787: WHERE application_id= g_application_id and ae_header_id IN
8788: (SELECT xh.ae_header_id
8789: FROM xla_events_int_gt xeg,
8790: xla_ae_headers xh
8791: WHERE
8792: xh.event_id = xeg.event_id AND
8793: xh.application_id = g_application_id AND

Line 8814: ,xla_events_int_gt xeg

8810: WHERE ae_header_id IN
8811: (SELECT xah.ae_header_id
8812: FROM xla_events xe
8813: ,xla_ae_headers xah
8814: ,xla_events_int_gt xeg
8815: WHERE xe.application_id = xah.application_id
8816: AND xah.event_id = xe.event_id
8817: AND xeg.event_id = xe.event_id);
8818:

Line 8835: ,xla_events_int_gt xeg

8831: WHERE ae_header_id IN
8832: (SELECT xah.ae_header_id
8833: FROM xla_events xe
8834: ,xla_ae_headers xah
8835: ,xla_events_int_gt xeg
8836: WHERE xe.application_id = xah.application_id
8837: AND xah.event_id = xe.event_id
8838: AND xeg.event_id = xe.event_id);
8839:

Line 8856: ,xla_events_int_gt xeg

8852: WHERE ae_header_id IN
8853: (SELECT xah.ae_header_id
8854: FROM xla_events xe
8855: ,xla_ae_headers xah
8856: ,xla_events_int_gt xeg
8857: WHERE xe.application_id = xah.application_id
8858: AND xah.event_id = xe.event_id
8859: AND xeg.event_id = xe.event_id);
8860:

Line 8878: ,xla_events_int_gt xeg

8874: WHERE ae_header_id IN
8875: (SELECT xah.ae_header_id
8876: FROM xla_events xe
8877: ,xla_ae_headers xah
8878: ,xla_events_int_gt xeg
8879: WHERE xe.application_id = xah.application_id
8880: AND xah.event_id = xe.event_id
8881: AND xeg.event_id = xe.event_id);
8882:

Line 8899: ,xla_events_int_gt xeg

8895: WHERE ae_header_id IN
8896: (SELECT xah.ae_header_id
8897: FROM xla_events xe
8898: ,xla_ae_headers xah
8899: ,xla_events_int_gt xeg
8900: WHERE xe.application_id = xah.application_id
8901: AND xah.event_id = xe.event_id
8902: AND xeg.event_id = xe.event_id);
8903:

Line 8921: ,xla_events_int_gt xeg

8917: AND ae_header_id IN
8918: (SELECT xah.ae_header_id
8919: FROM xla_events xe
8920: ,xla_ae_headers xah
8921: ,xla_events_int_gt xeg
8922: WHERE xe.application_id = xah.application_id
8923: AND xe.application_id = g_application_id
8924: AND xah.application_id = g_application_id
8925: AND xah.event_id = xe.event_id

Line 8945: ,xla_events_int_gt xeg

8941: AND ae_header_id IN
8942: (SELECT xah.ae_header_id
8943: FROM xla_events xe
8944: ,xla_ae_headers xah
8945: ,xla_events_int_gt xeg
8946: WHERE xe.application_id = xah.application_id
8947: AND xah.event_id = xe.event_id
8948: AND xeg.event_id = xe.event_id);
8949: