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_CONTROL_BALANCES

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

2100: END IF;
2101:
2102: --
2103: --
2104: -- Update the BEGINNING BALANCE, PERIOD BALANCE into the xla_control_balances table if record already exists for that group.
2105: --
2106: l_update_bal := 'UPDATE /*+ ordered index(b,xla_control_balances_N99) */xla_control_balances b
2107: SET last_update_date = '''||g_date||'''
2108: , last_updated_by = '||g_user_id||'

Line 2106: l_update_bal := 'UPDATE /+ ordered index(b,xla_control_balances_N99) /xla_control_balances b

2102: --
2103: --
2104: -- Update the BEGINNING BALANCE, PERIOD BALANCE into the xla_control_balances table if record already exists for that group.
2105: --
2106: l_update_bal := 'UPDATE /*+ ordered index(b,xla_control_balances_N99) */xla_control_balances b
2107: SET last_update_date = '''||g_date||'''
2108: , last_updated_by = '||g_user_id||'
2109: , last_update_login = '||g_login_id||'
2110: , program_update_date = '''||g_date||'''

Line 2196: , p_msg => '# rows updated in xla_control_balances : '

2192:
2193: IF (c_level_procedure >= g_log_level)
2194: THEN
2195: TRACE (p_module => l_log_module
2196: , p_msg => '# rows updated in xla_control_balances : '
2197: || l_update1_count
2198: , p_level => c_level_procedure
2199: );
2200: END IF;

Line 2208: l_insert_bal := 'INSERT INTO xla_control_balances xba (

2204: --
2205: IF l_update1_count <> l_merge_count
2206: THEN
2207: -- insert rows only if the rows updated is not equal to the total no of rows in gt table
2208: l_insert_bal := 'INSERT INTO xla_control_balances xba (
2209: application_id
2210: , ledger_id
2211: , code_combination_id
2212: , party_type_code

Line 2270: FROM xla_control_balances xba

2266: AND gps.application_id = 101
2267: AND gps.adjustment_period_flag = ''N''
2268: AND gps.closing_status IN (''O'', ''C'', ''P'')
2269: AND NOT EXISTS ( SELECT /*+ no_unnest $parallel_1$ */ 1
2270: FROM xla_control_balances xba
2271: WHERE xba.application_id = temp.application_id
2272: AND xba.ledger_id = temp.ledger_id
2273: AND xba.code_combination_id = temp.code_combination_id
2274: AND xba.party_type_code = temp.party_type_code

Line 2325: , p_msg => ' # rows inserted into xla_control_balances : '

2321:
2322: IF (c_level_procedure >= g_log_level)
2323: THEN
2324: TRACE (p_module => l_log_module
2325: , p_msg => ' # rows inserted into xla_control_balances : '
2326: || l_insert2_count
2327: , p_level => c_level_procedure
2328: );
2329: END IF;

Line 3142: INSERT INTO xla_control_balances

3138: , p_module => l_log_module
3139: );
3140: END IF;
3141:
3142: INSERT INTO xla_control_balances
3143: (application_id
3144: , ledger_id
3145: , code_combination_id
3146: , party_type_code

Line 3241: , xla_control_balances bal

3237: ,g_prog_appl_id
3238: ,g_prog_id
3239: ,g_req_id
3240: FROM gl_period_statuses gps
3241: , xla_control_balances bal
3242: ,(select ledger_id
3243: from xla_ledger_relationships_v
3244: where (ledger_category_code IN ('PRIMARY','ALC')
3245: and primary_ledger_id = p_ledger_id)

Line 3386: WHERE EXISTS (SELECT 1 FROM xla_control_balances where effective_period_num is null)

3382: CURSOR csr_bal_count
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

Line 3393: WHERE EXISTS (SELECT 1 FROM xla_control_balances WHERE ledger_id = p_ledger_id)

3389: CURSOR csr_bal_sob_count(p_ledger_id NUMBER)
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

Line 3504: UPDATE xla_control_balances xab

3500: );
3501: END IF;
3502:
3503:
3504: UPDATE xla_control_balances xab
3505: SET EFFECTIVE_PERIOD_NUM = ( SELECT gps.effective_period_num
3506: FROM gl_period_statuses gps
3507: WHERE gps.ledger_id = xab.ledger_id
3508: AND gps.application_id = 101

Line 3526: , p_msg => '# Rows update in xla_control_balances ' || SQL%ROWCOUNT

3522:
3523: IF (c_level_procedure >= g_log_level)
3524: THEN
3525: TRACE (p_module => l_log_module
3526: , p_msg => '# Rows update in xla_control_balances ' || SQL%ROWCOUNT
3527: , p_level => c_level_procedure
3528: );
3529: END IF;
3530:

Line 3602: UPDATE xla_control_balances xab

3598: );
3599: END IF;
3600:
3601:
3602: UPDATE xla_control_balances xab
3603: SET EFFECTIVE_PERIOD_NUM = ( SELECT gps.effective_period_num
3604: FROM gl_period_statuses gps
3605: WHERE gps.ledger_id = xab.ledger_id
3606: AND gps.application_id = 101

Line 3624: , p_msg => '# Rows update in xla_control_balances ' || SQL%ROWCOUNT

3620:
3621: IF (c_level_procedure >= g_log_level)
3622: THEN
3623: TRACE (p_module => l_log_module
3624: , p_msg => '# Rows update in xla_control_balances ' || SQL%ROWCOUNT
3625: , p_level => c_level_procedure
3626: );
3627: END IF;
3628: