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 935: SELECT xla_accounting_batches_s.NEXTVAL INTO g_accounting_batch_id FROM DUAL;

931:
932: ----------------------------------------------------------------------------
933: -- Fetching Accounting Batch Id
934: ----------------------------------------------------------------------------
935: SELECT xla_accounting_batches_s.NEXTVAL INTO g_accounting_batch_id FROM DUAL;
936:
937: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
938: trace
939: (p_msg => 'g_accounting_batch_id = '||g_accounting_batch_id

Line 965: FROM DUAL;

961: DECODE(p_security_id_char_1,NULL,NULL,'and security_id_char_1 = '''||p_security_id_char_1||''' ')||
962: DECODE(p_security_id_char_2,NULL,NULL,'and security_id_char_2 = '''||p_security_id_char_2||''' ')||
963: DECODE(p_security_id_char_3,NULL,NULL,'and security_id_char_3 = '''||p_security_id_char_3||''' ')
964: INTO g_security_condition
965: FROM DUAL;
966:
967: ----------------------------------------------------------------------------
968: -- Building filter condition based process_category.
969: -- This condition will be added dynamically to select statemtents.

Line 974: FROM DUAL;

970: ----------------------------------------------------------------------------
971: SELECT
972: DECODE(p_process_category,NULL,NULL,'and event_class_group_code = '''||p_process_category||'''')
973: INTO g_process_category_condition
974: FROM DUAL;
975:
976: ----------------------------------------------------------------------------
977: -- Building filter condition based on source_application_id.
978: ----------------------------------------------------------------------------

Line 982: FROM DUAL;

978: ----------------------------------------------------------------------------
979: SELECT
980: DECODE(p_source_application_id,NULL,NULL,'and source_application_id = '||p_source_application_id)
981: INTO g_source_appl_condition
982: FROM DUAL;
983:
984: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
985: trace
986: (p_msg => 'g_security_condition = '||g_security_condition

Line 1656: FROM DUAL;

1652: DECODE(p_security_id_char_1,NULL,NULL,'and security_id_char_1 = '''||p_security_id_char_1||''' ')||
1653: DECODE(p_security_id_char_2,NULL,NULL,'and security_id_char_2 = '''||p_security_id_char_2||''' ')||
1654: DECODE(p_security_id_char_3,NULL,NULL,'and security_id_char_3 = '''||p_security_id_char_3||''' ')
1655: INTO g_security_condition
1656: FROM DUAL;
1657:
1658: ----------------------------------------------------------------------------
1659: -- Building filter condition based process_category.
1660: -- This condition will be added dynamically to select statemtents.

Line 1665: FROM DUAL;

1661: ----------------------------------------------------------------------------
1662: SELECT
1663: DECODE(p_process_category,NULL,NULL,'and event_class_group_code = '''||p_process_category||'''')
1664: INTO g_process_category_condition
1665: FROM DUAL;
1666:
1667: ----------------------------------------------------------------------------
1668: -- Building filter condition based on source_application_id.
1669: ----------------------------------------------------------------------------

Line 1673: FROM DUAL;

1669: ----------------------------------------------------------------------------
1670: SELECT
1671: DECODE(p_source_application_id,NULL,NULL,'and source_application_id = '||p_source_application_id)
1672: INTO g_source_appl_condition
1673: FROM DUAL;
1674: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Dynamic conditions built');
1675:
1676: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1677: trace

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

2851: -- Following sets the session's client identifier for the purpose of global
2852: --
2853: -- application context.
2854: --
2855: SELECT xla_accounting_batches_s.nextval INTO p_accounting_batch_id FROM DUAL;
2856: g_accounting_batch_id := p_accounting_batch_id;
2857:
2858: dbms_session.set_identifier
2859: (client_id => g_accounting_batch_id);

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

3617: ----------------------------------------------------------------------------
3618: -- Call massive update only if there is any valid entry
3619: -- Bug 5065965. Modified the following sql for performance.
3620: ----------------------------------------------------------------------------
3621: SELECT COUNT(1) INTO l_acct_batch_entries FROM DUAL
3622: WHERE EXISTS
3623: (SELECT 'Y'
3624: FROM xla_events
3625: WHERE application_id = g_application_id

Line 5817: FROM DUAL;

5813: --For bug fix 7677948
5814: FOR i IN l_array_base_ledgers.FIRST..l_array_base_ledgers.LAST LOOP
5815: SELECT gl_interface_control_s.NEXTVAL, l_array_base_ledgers(i)
5816: INTO g_array_group_id(i), g_array_ledger_id(i)
5817: FROM DUAL;
5818:
5819: IF l_array_alc_ledgers.COUNT > 0 AND
5820: l_array_base_ledgers(i) = g_ledger_id
5821: THEN