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_ACCOUNTING_PKG dependencies on DUAL

Line 960: SELECT xla_accounting_batches_s.NEXTVAL INTO g_accounting_batch_id FROM DUAL;

956:
957: ----------------------------------------------------------------------------
958: -- Fetching Accounting Batch Id
959: ----------------------------------------------------------------------------
960: SELECT xla_accounting_batches_s.NEXTVAL INTO g_accounting_batch_id FROM DUAL;
961:
962: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
963: trace
964: (p_msg => 'g_accounting_batch_id = '||g_accounting_batch_id

Line 993: FROM DUAL;

989: DECODE(p_security_id_char_1,NULL,NULL,'and security_id_char_1 = '''||p_security_id_char_1||''' ')||
990: DECODE(p_security_id_char_2,NULL,NULL,'and security_id_char_2 = '''||p_security_id_char_2||''' ')||
991: DECODE(p_security_id_char_3,NULL,NULL,'and security_id_char_3 = '''||p_security_id_char_3||''' ')
992: INTO g_security_condition
993: FROM DUAL;
994:
995: ----------------------------------------------------------------------------
996: -- Building filter condition based process_category.
997: -- This condition will be added dynamically to select statemtents.

Line 1002: FROM DUAL;

998: ----------------------------------------------------------------------------
999: SELECT
1000: DECODE(p_process_category,NULL,NULL,'and event_class_group_code = '''||p_process_category||'''')
1001: INTO g_process_category_condition
1002: FROM DUAL;
1003:
1004: ----------------------------------------------------------------------------
1005: -- Building filter condition based on source_application_id.
1006: ----------------------------------------------------------------------------

Line 1010: FROM DUAL;

1006: ----------------------------------------------------------------------------
1007: SELECT
1008: DECODE(p_source_application_id,NULL,NULL,'and source_application_id = '||p_source_application_id)
1009: INTO g_source_appl_condition
1010: FROM DUAL;
1011:
1012: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1013: trace
1014: (p_msg => 'g_security_condition = '||g_security_condition

Line 1431: SELECT 1 INTO l_code FROM dual WHERE EXISTS

1427: -- FSAH-PSFT FP
1428: -- Set retcode as warning when ever CmboEdit returns Invalid CCID's -- 7502532
1429: IF ( nvl(fnd_profile.value('XLA_FSAH_EXT_CCID_VAL'),'N') = 'Y') THEN
1430: BEGIN
1431: SELECT 1 INTO l_code FROM dual WHERE EXISTS
1432: (SELECT 1 FROM xla_events xe, xla_ae_headers xah WHERE
1433: xe.application_id= p_application_id AND
1434: xe.application_id=xah.application_id AND
1435: xe.process_status_code in ('I','R') AND

Line 1816: FROM DUAL;

1812: DECODE(p_security_id_char_1,NULL,NULL,'and security_id_char_1 = '''||p_security_id_char_1||''' ')||
1813: DECODE(p_security_id_char_2,NULL,NULL,'and security_id_char_2 = '''||p_security_id_char_2||''' ')||
1814: DECODE(p_security_id_char_3,NULL,NULL,'and security_id_char_3 = '''||p_security_id_char_3||''' ')
1815: INTO g_security_condition
1816: FROM DUAL;
1817:
1818: ----------------------------------------------------------------------------
1819: -- Building filter condition based process_category.
1820: -- This condition will be added dynamically to select statemtents.

Line 1825: FROM DUAL;

1821: ----------------------------------------------------------------------------
1822: SELECT
1823: DECODE(p_process_category,NULL,NULL,'and event_class_group_code = '''||p_process_category||'''')
1824: INTO g_process_category_condition
1825: FROM DUAL;
1826:
1827: ----------------------------------------------------------------------------
1828: -- Building filter condition based on source_application_id.
1829: ----------------------------------------------------------------------------

Line 1833: FROM DUAL;

1829: ----------------------------------------------------------------------------
1830: SELECT
1831: DECODE(p_source_application_id,NULL,NULL,'and source_application_id = '||p_source_application_id)
1832: INTO g_source_appl_condition
1833: FROM DUAL;
1834: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Dynamic conditions built');
1835:
1836: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1837: trace

Line 3075: SELECT xla_accounting_batches_s.nextval INTO p_accounting_batch_id FROM DUAL;

3071: -- Following sets the session's client identifier for the purpose of global
3072: --
3073: -- application context.
3074: --
3075: SELECT xla_accounting_batches_s.nextval INTO p_accounting_batch_id FROM DUAL;
3076: g_accounting_batch_id := p_accounting_batch_id;
3077:
3078: dbms_session.set_identifier
3079: (client_id => g_accounting_batch_id);

Line 3860: SELECT COUNT(1) INTO l_acct_batch_entries FROM DUAL

3856: ----------------------------------------------------------------------------
3857: -- Call massive update only if there is any valid entry
3858: -- Bug 5065965. Modified the following sql for performance.
3859: ----------------------------------------------------------------------------
3860: SELECT COUNT(1) INTO l_acct_batch_entries FROM DUAL
3861: WHERE EXISTS
3862: (SELECT 'Y'
3863: FROM xla_events
3864: WHERE application_id = g_application_id

Line 6195: FROM DUAL;

6191: --For bug fix 7677948
6192: FOR i IN l_array_base_ledgers.FIRST..l_array_base_ledgers.LAST LOOP
6193: SELECT gl_interface_control_s.NEXTVAL, l_array_base_ledgers(i)
6194: INTO g_array_group_id(i), g_array_ledger_id(i)
6195: FROM DUAL;
6196:
6197: IF l_array_alc_ledgers.COUNT > 0 AND
6198: l_array_base_ledgers(i) = g_ledger_id
6199: THEN