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

Line 153: FROM dual;

149:
150:
151: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
152: INTO l_sql_time
153: FROM dual;
154:
155: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
156: trace
157: (p_msg => 'UPG_MAIN procedure start time: ' || l_sql_time

Line 375: FROM dual;

371: ccid_check();
372:
373: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
374: INTO l_sql_time
375: FROM dual;
376:
377: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
378: trace
379: (p_msg => 'UPG_MAIN validation procedure end time: ' || l_sql_time

Line 493: FROM dual;

489:
490:
491: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
492: INTO l_sql_time
493: FROM dual;
494:
495: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
496: trace
497: (p_msg => 'UPG_MAIN procedure end time: ' || l_sql_time

Line 786: FROM DUAL

782: BEGIN
783:
784: SELECT 1
785: INTO l_relationship_exists
786: FROM DUAL
787: WHERE EXISTS (SELECT 1
788: FROM gl_ledger_relationships
789: WHERE primary_ledger_id = l_primary_ledger_id
790: AND target_ledger_id = l_secondary_alc_ledger_id

Line 928: FROM DUAL

924: BEGIN
925:
926: SELECT 1
927: INTO l_untransferred_headers
928: FROM DUAL
929: WHERE EXISTS (SELECT 1
930: FROM xla_ae_headers
931: WHERE ledger_id = l_primary_ledger_id
932: AND accounting_entry_status_code = 'F'

Line 980: FROM DUAL

976:
977:
978: SELECT 1
979: INTO l_sec_alc_data_check
980: FROM DUAL
981: WHERE EXISTS (SELECT 1
982: FROM xla_ae_headers
983: WHERE ledger_id = l_secondary_alc_ledger_id);
984:

Line 1085: FROM dual;

1081: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1082:
1083: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
1084: INTO l_sql_time
1085: FROM dual;
1086:
1087: trace
1088: (p_msg => 'populate_rates procedure start: ' || l_sql_time
1089: ,p_level => C_LEVEL_PROCEDURE

Line 1102: FROM DUAL

1098:
1099:
1100: SELECT 1
1101: INTO l_rate_exists
1102: FROM DUAL
1103: WHERE EXISTS (SELECT 1
1104: FROM xla_rc_upgrade_rates
1105: WHERE relationship_id = l_relationship_id
1106: AND upgrade_run_id = l_upgrade_id);

Line 1377: FROM dual;

1373: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1374:
1375: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
1376: INTO l_sql_time
1377: FROM dual;
1378:
1379: trace
1380: (p_msg => 'populate_rates procedure end: ' || l_sql_time
1381: ,p_level => C_LEVEL_PROCEDURE

Line 1436: FROM DUAL

1432:
1433:
1434: SELECT 1
1435: INTO l_alc_exists
1436: FROM DUAL
1437: WHERE EXISTS (SELECT 1
1438: FROM xla_subledgers
1439: WHERE alc_enabled_flag = 'Y');
1440:

Line 1707: FROM dual;

1703: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1704:
1705: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
1706: INTO l_sql_time
1707: FROM dual;
1708:
1709: trace
1710: (p_msg => 'xla_ae_headers insert SQL start: ' || l_sql_time
1711: ,p_level => C_LEVEL_PROCEDURE

Line 1894: FROM dual;

1890: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1891:
1892: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
1893: INTO l_sql_time
1894: FROM dual;
1895:
1896:
1897: trace
1898: (p_msg => 'xla_ae_headers insert SQL end and xla_ae_lines SQL start: ' || l_sql_time

Line 2146: FROM dual;

2142: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2143:
2144: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2145: INTO l_sql_time
2146: FROM dual;
2147:
2148: trace
2149: (p_msg => 'xla_ae_lines insert SQL end: ' || l_sql_time
2150: ,p_level => C_LEVEL_PROCEDURE

Line 2198: FROM dual;

2194: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2195:
2196: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2197: INTO l_sql_time
2198: FROM dual;
2199:
2200: trace
2201: (p_msg => 'xla_ae_headers insert SQL start: ' || l_sql_time
2202: ,p_level => C_LEVEL_PROCEDURE

Line 2380: FROM dual;

2376: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2377:
2378: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2379: INTO l_sql_time
2380: FROM dual;
2381:
2382:
2383: trace
2384: (p_msg => 'xla_ae_headers insert SQL end and xla_ae_lines SQL start: ' || l_sql_time

Line 2631: FROM dual;

2627: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2628:
2629: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2630: INTO l_sql_time
2631: FROM dual;
2632:
2633: trace
2634: (p_msg => 'xla_ae_lines insert SQL end: ' || l_sql_time
2635: ,p_level => C_LEVEL_PROCEDURE

Line 2716: FROM dual;

2712: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2713:
2714: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2715: INTO l_sql_time
2716: FROM dual;
2717:
2718: trace
2719: (p_msg => 'ccid check SQL start: ' || l_sql_time
2720: ,p_level => C_LEVEL_PROCEDURE

Line 2752: FROM dual;

2748: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2749:
2750: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2751: INTO l_sql_time
2752: FROM dual;
2753:
2754: trace
2755: (p_msg => 'ccid check SQL end: ' || l_sql_time
2756: ,p_level => C_LEVEL_PROCEDURE

Line 2769: FROM DUAL

2765: BEGIN
2766:
2767: SELECT 1
2768: INTO l_ccid_check
2769: FROM DUAL
2770: WHERE EXISTS (SELECT 1
2771: FROM gl_accts_map_int_gt
2772: WHERE coa_mapping_id = l_mapping_relationship_id
2773: AND to_ccid IS NULL);

Line 2932: FROM dual;

2928: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2929:
2930: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2931: INTO l_sql_time
2932: FROM dual;
2933:
2934: trace
2935: (p_msg => 'ccid update SQL start: ' || l_sql_time
2936: ,p_level => C_LEVEL_PROCEDURE

Line 2958: FROM dual;

2954:
2955:
2956: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2957: INTO l_sql_time
2958: FROM dual;
2959:
2960: trace
2961: (p_msg => 'ccid update SQL end: ' || l_sql_time
2962: ,p_level => C_LEVEL_PROCEDURE

Line 2973: FROM DUAL

2969: BEGIN
2970:
2971: SELECT 1
2972: INTO l_ccid_check
2973: FROM DUAL
2974: WHERE EXISTS (SELECT 1
2975: FROM xla_ae_lines
2976: WHERE code_combination_id = -1
2977: AND request_id = l_upgrade_id);

Line 3104: FROM dual;

3100: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3101:
3102: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3103: INTO l_sql_time
3104: FROM dual;
3105:
3106: trace
3107: (p_msg => 'calendar conversion SQL start: ' || l_sql_time
3108: ,p_level => C_LEVEL_PROCEDURE

Line 3135: FROM dual;

3131:
3132:
3133: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3134: INTO l_sql_time
3135: FROM dual;
3136:
3137: trace
3138: (p_msg => 'calendar convert SQL end: ' || l_sql_time
3139: ,p_level => C_LEVEL_PROCEDURE

Line 3207: FROM dual;

3203: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3204:
3205: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3206: INTO l_sql_time
3207: FROM dual;
3208:
3209: trace
3210: (p_msg => 'displayed line num SQL start: ' || l_sql_time
3211: ,p_level => C_LEVEL_PROCEDURE

Line 3257: FROM dual;

3253:
3254:
3255: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3256: INTO l_sql_time
3257: FROM dual;
3258:
3259: trace
3260: (p_msg => 'displayed line num SQL end: ' || l_sql_time
3261: ,p_level => C_LEVEL_PROCEDURE

Line 3278: FROM dual;

3274:
3275:
3276: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3277: INTO l_sql_time
3278: FROM dual;
3279:
3280: trace
3281: (p_msg => 'displayed line num SQL end: ' || l_sql_time
3282: ,p_level => C_LEVEL_PROCEDURE

Line 3334: FROM dual;

3330: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3331:
3332: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3333: INTO l_sql_time
3334: FROM dual;
3335:
3336: trace
3337: (p_msg => 'distribution links SQL start time: ' || l_sql_time
3338: ,p_level => C_LEVEL_PROCEDURE

Line 3541: FROM dual;

3537: ,p_module => l_log_module);
3538:
3539: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3540: INTO l_sql_time
3541: FROM dual;
3542:
3543: trace
3544: (p_msg => 'distribution links insert SQL end, segment insert start (if applicable): ' || l_sql_time
3545: ,p_level => C_LEVEL_PROCEDURE

Line 3584: FROM dual;

3580: ,p_module => l_log_module);
3581:
3582: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3583: INTO l_sql_time
3584: FROM dual;
3585:
3586: trace
3587: (p_msg => 'distribution links update SQL end: ' || l_sql_time
3588: ,p_level => C_LEVEL_PROCEDURE

Line 3627: FROM dual;

3623: ,p_module => l_log_module);
3624:
3625: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3626: INTO l_sql_time
3627: FROM dual;
3628:
3629: trace
3630: (p_msg => 'xla_ae_segment SQL end time: ' || l_sql_time
3631: ,p_level => C_LEVEL_PROCEDURE

Line 3704: FROM dual;

3700: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3701:
3702: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3703: INTO l_sql_time
3704: FROM dual;
3705:
3706: trace
3707: (p_msg => 'post validation procedure start time: ' || l_sql_time
3708: ,p_level => C_LEVEL_PROCEDURE

Line 3718: FROM DUAL

3714: BEGIN
3715:
3716: SELECT 1
3717: INTO l_error_lines
3718: FROM DUAL
3719: WHERE EXISTS (SELECT 1
3720: FROM xla_ae_lines
3721: WHERE request_id = l_upgrade_id
3722: GROUP BY ae_header_id

Line 3775: FROM dual;

3771:
3772:
3773: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3774: INTO l_sql_time
3775: FROM dual;
3776:
3777: trace
3778: (p_msg => 'post validation procedure end time: ' || l_sql_time
3779: ,p_level => C_LEVEL_PROCEDURE

Line 3817: FROM dual;

3813:
3814: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3815: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3816: INTO l_sql_time
3817: FROM dual;
3818: trace
3819: (p_msg => 'crash recovery procedure start time: ' || l_sql_time
3820: ,p_level => C_LEVEL_PROCEDURE
3821: ,p_module => l_log_module);

Line 3828: FROM DUAL

3824: BEGIN
3825:
3826: SELECT 1
3827: INTO l_relationship_exists
3828: FROM DUAL
3829: WHERE EXISTS (SELECT 1
3830: FROM gl_ledger_relationships
3831: WHERE primary_ledger_id = l_primary_ledger_id
3832: AND target_ledger_id = l_secondary_alc_ledger_id

Line 3935: FROM dual;

3931: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3932:
3933: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3934: INTO l_sql_time
3935: FROM dual;
3936:
3937: trace
3938: (p_msg => 'crash recovery procedure end time: ' || l_sql_time
3939: ,p_level => C_LEVEL_PROCEDURE