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_BALANCES_CALC_PKG dependencies on XLA_AC_BALANCES

Line 1084: -- Update the BEGINNING BALANCE, PERIOD BALANCE into the xla_ac_balances table if record already exists for that group.

1080: );
1081: END IF;
1082:
1083: --
1084: -- Update the BEGINNING BALANCE, PERIOD BALANCE into the xla_ac_balances table if record already exists for that group.
1085: --
1086: l_update_bal := 'UPDATE /*+ index(b,xla_ac_balances_N99) */xla_ac_balances b
1087: SET last_update_date = '''||g_date||'''
1088: , last_updated_by = '||g_user_id||'

Line 1086: l_update_bal := 'UPDATE /+ index(b,xla_ac_balances_N99) /xla_ac_balances b

1082:
1083: --
1084: -- Update the BEGINNING BALANCE, PERIOD BALANCE into the xla_ac_balances table if record already exists for that group.
1085: --
1086: l_update_bal := 'UPDATE /*+ index(b,xla_ac_balances_N99) */xla_ac_balances b
1087: SET last_update_date = '''||g_date||'''
1088: , last_updated_by = '||g_user_id||'
1089: , last_update_login = '||g_login_id||'
1090: , program_update_date = '''||g_date||'''

Line 1192: , p_msg => '# rows updated in xla_ac_balances : '

1188:
1189: IF (c_level_procedure >= g_log_level)
1190: THEN
1191: TRACE (p_module => l_log_module
1192: , p_msg => '# rows updated in xla_ac_balances : '
1193: || l_update1_count
1194: , p_level => c_level_procedure
1195: );
1196: END IF;

Line 1204: l_insert_bal := 'INSERT INTO xla_ac_balances xba

1200: --
1201: IF l_update1_count <> l_merge_count
1202: THEN
1203: -- insert rows only if the rows updated is not equal to the total no of rows in gt table
1204: l_insert_bal := 'INSERT INTO xla_ac_balances xba
1205: ( application_id
1206: , ledger_id
1207: , code_combination_id
1208: , analytical_criterion_code

Line 1289: FROM xla_ac_balances xba

1285: AND gcc.account_type IN (''A'', ''L'', ''O'')
1286: )
1287: )
1288: AND NOT EXISTS ( SELECT /*+ no_unnest $parallel_1$ */ 1
1289: FROM xla_ac_balances xba
1290: WHERE xba.application_id = temp.application_id
1291: AND xba.ledger_id = temp.ledger_id
1292: AND xba.code_combination_id = temp.code_combination_id
1293: AND xba.analytical_criterion_code = temp.analytical_criterion_code

Line 1352: , p_msg => ' # rows inserted into xla_ac_balances : '

1348:
1349: IF (c_level_procedure >= g_log_level)
1350: THEN
1351: TRACE (p_module => l_log_module
1352: , p_msg => ' # rows inserted into xla_ac_balances : '
1353: || l_insert2_count
1354: , p_level => c_level_procedure
1355: );
1356: END IF;

Line 2986: INSERT INTO xla_ac_balances

2982: , p_module => l_log_module
2983: );
2984: END IF;
2985:
2986: INSERT INTO xla_ac_balances
2987: (application_id
2988: , ledger_id
2989: , code_combination_id
2990: , analytical_criterion_code

Line 3095: , xla_ac_balances bal

3091: ,g_prog_appl_id
3092: ,g_prog_id
3093: ,g_req_id
3094: FROM gl_period_statuses gps
3095: , xla_ac_balances bal
3096: , gl_code_combinations gcc
3097: , xla_analytical_hdrs_b xbh
3098: , (select ledger_id
3099: from xla_ledger_relationships_v

Line 3387: OR EXISTS (SELECT 1 FROM xla_ac_balances where effective_period_num is null);

3383: IS
3384: SELECT COUNT(1) bal_count
3385: FROM dual
3386: WHERE EXISTS (SELECT 1 FROM xla_control_balances where effective_period_num is null)
3387: OR EXISTS (SELECT 1 FROM xla_ac_balances where effective_period_num is null);
3388:
3389: CURSOR csr_bal_sob_count(p_ledger_id NUMBER)
3390: IS
3391: SELECT COUNT(1) bal_sob_count

Line 3394: OR EXISTS (SELECT 1 FROM xla_ac_balances WHERE ledger_id = p_ledger_id);

3390: IS
3391: SELECT COUNT(1) bal_sob_count
3392: FROM dual
3393: WHERE EXISTS (SELECT 1 FROM xla_control_balances WHERE ledger_id = p_ledger_id)
3394: OR EXISTS (SELECT 1 FROM xla_ac_balances WHERE ledger_id = p_ledger_id);
3395:
3396: -- Bug12613841 added the cursor csr_xlo_not_null_count
3397: CURSOR csr_xlo_not_null_count
3398: IS

Line 3476: UPDATE xla_ac_balances xab

3472: and effective_period_num is null;
3473:
3474: -- Begin Bug 13928188
3475:
3476: UPDATE xla_ac_balances xab
3477: SET EFFECTIVE_PERIOD_NUM = ( SELECT gps.effective_period_num
3478: FROM gl_period_statuses gps
3479: WHERE gps.ledger_id = xab.ledger_id
3480: AND gps.application_id = 101

Line 3498: , p_msg => '# Rows update in xla_ac_balances ' || SQL%ROWCOUNT

3494:
3495: IF (c_level_procedure >= g_log_level)
3496: THEN
3497: TRACE (p_module => l_log_module
3498: , p_msg => '# Rows update in xla_ac_balances ' || SQL%ROWCOUNT
3499: , p_level => c_level_procedure
3500: );
3501: END IF;
3502:

Line 3574: UPDATE xla_ac_balances xab

3570:
3571:
3572: -- Begin Bug 13928188
3573:
3574: UPDATE xla_ac_balances xab
3575: SET EFFECTIVE_PERIOD_NUM = ( SELECT gps.effective_period_num
3576: FROM gl_period_statuses gps
3577: WHERE gps.ledger_id = xab.ledger_id
3578: AND gps.application_id = 101

Line 3596: , p_msg => '# Rows update in xla_ac_balances ' || SQL%ROWCOUNT

3592:
3593: IF (c_level_procedure >= g_log_level)
3594: THEN
3595: TRACE (p_module => l_log_module
3596: , p_msg => '# Rows update in xla_ac_balances ' || SQL%ROWCOUNT
3597: , p_level => c_level_procedure
3598: );
3599: END IF;
3600: