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_LEDGER_OPTIONS

Line 23: | updating the effective_period_num in xla_ledger_options. |

19: | 2. Fix the analytical balance calculation to consider the |
20: | year_end_carry_forward_code. |
21: | 3. For ledgers created after the new balances fix the code to |
22: | update the effective_period_num in balances table in addition to |
23: | updating the effective_period_num in xla_ledger_options. |
24: | |
25: | |
26: +======================================================================*/
27:

Line 535: , xla_ledger_options xlo

531: , xla_ae_lines ael
532: , xla_ae_line_acs acs
533: , xla_analytical_hdrs_b xbh
534: , gl_period_statuses gps
535: , xla_ledger_options xlo
536: , xla_ledger_relationships_v xlr
537: $bal_concurrency$
538: WHERE aeh.application_id = :'||l_summary_bind_count||'
539: AND aeh.accounting_entry_status_code = ''F''

Line 990: , xla_ledger_options xlo

986: FROM gl_period_statuses gps
987: ,xla_analytical_hdrs_b xbh --Bug13498442
988: , gl_code_combinations gcc --Bug13498442
989: , xla_ac_bal_interim_gt tmp
990: , xla_ledger_options xlo
991: , xla_ledger_relationships_v xlr
992: WHERE gps.effective_period_num <= xlo.effective_period_num
993: AND gps.effective_period_num >= tmp.effective_period_num
994: AND gps.closing_status IN ('O', 'C', 'P')

Line 1373: , xla_ledger_options xlo

1369: ,ael.ae_line_num
1370: FROM xla_ae_headers aeh
1371: , xla_ae_lines ael
1372: , gl_period_statuses gps
1373: , xla_ledger_options xlo
1374: , xla_ledger_relationships_v xlr
1375: $bal_concurrency$
1376: WHERE aeh.accounting_entry_status_code = ''F''
1377: AND aeh.application_id = :'||l_processed_bind_count||'

Line 1635: , xla_ledger_options xlo

1631: , SUBSTR (gps.effective_period_num, 1, 4) period_year
1632: FROM xla_ae_headers aeh
1633: , xla_ae_lines ael
1634: , gl_period_statuses gps
1635: , xla_ledger_options xlo
1636: , xla_ledger_relationships_v xlr
1637: $bal_concurrency$
1638: WHERE aeh.application_id = :'||l_summary_bind_count||'
1639: AND aeh.accounting_entry_status_code = ''F''

Line 2035: , xla_ledger_options xlo

2031: , gps.effective_period_num
2032: , gps.period_year
2033: FROM gl_period_statuses gps
2034: , xla_ctrl_bal_interim_gt tmp
2035: , xla_ledger_options xlo
2036: , xla_ledger_relationships_v xlr
2037: WHERE gps.effective_period_num <= xlo.effective_period_num
2038: AND gps.effective_period_num >= tmp.effective_period_num
2039: AND gps.closing_status IN ('O', 'C', 'P')

Line 2344: , xla_ledger_options xlo

2340: ,ael.ae_line_num
2341: FROM xla_ae_headers aeh
2342: , xla_ae_lines ael
2343: , gl_period_statuses gps
2344: , xla_ledger_options xlo
2345: , xla_ledger_relationships_v xlr
2346: $bal_concurrency$
2347: WHERE aeh.accounting_entry_status_code = ''F''
2348: AND aeh.application_id = :'||l_processed_bind_count||'

Line 2655: FROM xla_ledger_options xlo

2651: AND gps.closing_status IN (''O'',''C'',''P'')
2652: AND gps.adjustment_period_flag = ''N''
2653: )gps_effective_period_num
2654: , xlo.ledger_id
2655: FROM xla_ledger_options xlo
2656: ,xla_ledger_relationships_v xlr
2657: WHERE xlr.ledger_id = '||p_ledger_id || '
2658: AND xlo.ledger_id = DECODE(xlr.ledger_category_code , ''ALC''
2659: ,xlr.primary_ledger_id, xlr.ledger_id)

Line 2676: FROM xla_ledger_options xlo

2672: AND gps.closing_status IN (''O'',''C'',''P'')
2673: AND gps.adjustment_period_flag = ''N''
2674: )gps_effective_period_num
2675: , xlo.ledger_id
2676: FROM xla_ledger_options xlo
2677: ,xla_ledger_relationships_v xlr
2678: ,xla_ae_headers xah
2679: WHERE xlo.ledger_id = DECODE(xlr.ledger_category_code , ''ALC''
2680: ,xlr.primary_ledger_id, xlr.ledger_id)

Line 2897: FROM xla_ledger_options

2893:
2894: CURSOR csr_eff_period (p_ledger_id VARCHAR2)
2895: IS
2896: SELECT distinct effective_period_num
2897: FROM xla_ledger_options
2898: WHERE ledger_id = p_ledger_id
2899: AND effective_period_num is not null;
2900: BEGIN
2901: IF g_log_enabled

Line 2956: , 'There is no record in xla_ledger_options for ledger '||p_ledger_id

2952: IF l_from_effective_period_num IS NULL
2953: THEN
2954: fnd_file.put_line
2955: (fnd_file.LOG
2956: , 'There is no record in xla_ledger_options for ledger '||p_ledger_id
2957: );
2958: RETURN FALSE;
2959: ELSIF l_from_effective_period_num >= p_effective_period_num
2960: THEN -- Proceed only if target period is greater than current open period

Line 3268: UPDATE xla_ledger_options

3264: END IF;
3265:
3266: --Bug 12673914
3267: --Added condition effective_period_num < p_effective_period_num below
3268: UPDATE xla_ledger_options
3269: SET effective_period_num = p_effective_period_num
3270: WHERE ledger_id = p_ledger_id
3271: AND nvl(effective_period_num,-1) < p_effective_period_num;
3272:

Line 3275: TRACE (p_msg => '# rows updated in xla_ledger_options : ' || SQL%ROWCOUNT

3271: AND nvl(effective_period_num,-1) < p_effective_period_num;
3272:
3273: IF (c_level_procedure >= g_log_level)
3274: THEN
3275: TRACE (p_msg => '# rows updated in xla_ledger_options : ' || SQL%ROWCOUNT
3276: , p_level => c_level_procedure
3277: , p_module => l_log_module
3278: );
3279: END IF;

Line 3283: TRACE (p_msg => 'xla_ledger_options updated with effective_period_num '||p_effective_period_num

3279: END IF;
3280:
3281: IF (c_level_procedure >= g_log_level)
3282: THEN
3283: TRACE (p_msg => 'xla_ledger_options updated with effective_period_num '||p_effective_period_num
3284: , p_level => c_level_procedure
3285: , p_module => l_log_module
3286: );
3287: END IF;

Line 3378: FROM xla_ledger_options

3374:
3375: CURSOR csr_xlo_effperiod(p_ledger_id NUMBER)
3376: IS
3377: SELECT COUNT(1) xlo_effperiod_count
3378: FROM xla_ledger_options
3379: WHERE ledger_id = p_ledger_id
3380: AND effective_period_num is not null;
3381: -- Bug12613841 modified cursor csr_bal_count to add where effective_period_num is null
3382: CURSOR csr_bal_count

Line 3401: FROM xla_ledger_options

3397: CURSOR csr_xlo_not_null_count
3398: IS
3399: SELECT count(1)
3400: INTO l_not_nul_count
3401: FROM xla_ledger_options
3402: WHERE effective_period_num IS NOT NULL;
3403:
3404: BEGIN
3405: IF g_log_enabled

Line 3456: UPDATE xla_ledger_options xlo

3452: AND l_xlo_effperiod_count = 0
3453: THEN
3454: IF l_xlo_not_nul_count > 0 THEN -- added Bug12613841
3455:
3456: UPDATE xla_ledger_options xlo
3457: SET effective_period_num = (SELECT gps.effective_period_num
3458: FROM gl_period_statuses gps,gl_ledgers gll
3459: WHERE gps.application_id= 101
3460: AND gps.ledger_id = xlo.ledger_id

Line 3545: THEN -- No record in balances table. So, update xla_ledger_options and exit

3541: p_retcode := 0;
3542: END IF;
3543: ELSIF l_bal_sob_count = 0
3544: AND l_ledger_category_code <> 'ALC'
3545: THEN -- No record in balances table. So, update xla_ledger_options and exit
3546:
3547: --Bug 12673914
3548: --Added condition effective_period_num < l_effective_period_num
3549: UPDATE xla_ledger_options

Line 3549: UPDATE xla_ledger_options

3545: THEN -- No record in balances table. So, update xla_ledger_options and exit
3546:
3547: --Bug 12673914
3548: --Added condition effective_period_num < l_effective_period_num
3549: UPDATE xla_ledger_options
3550: SET effective_period_num = l_effective_period_num
3551: WHERE ledger_id in
3552: (
3553: SELECT ledger_id

Line 3566: , p_msg => '# Rows update in xla_ledger_options ' || SQL%ROWCOUNT

3562:
3563: IF (c_level_procedure >= g_log_level)
3564: THEN
3565: TRACE (p_module => l_log_module
3566: , p_msg => '# Rows update in xla_ledger_options ' || SQL%ROWCOUNT
3567: , p_level => c_level_procedure
3568: );
3569: END IF;
3570:

Line 3862: FROM xla_ledger_options

3858:
3859: -- Check if balances upgrade script has been run.
3860: SELECT count(1)
3861: INTO l_ledger_count
3862: FROM xla_ledger_options
3863: WHERE effective_period_num IS NOT NULL;
3864:
3865: IF l_ledger_count = 0
3866: THEN

Line 4188: FROM xla_ledger_options

4184:
4185: -- Check if balances upgrade script has been run.
4186: SELECT count(1)
4187: INTO l_ledger_count
4188: FROM xla_ledger_options
4189: WHERE effective_period_num IS NOT NULL;
4190:
4191: IF l_ledger_count = 0
4192: THEN

Line 4469: FROM xla_ledger_options

4465: SAVEPOINT SAVEPOINT_BAL;
4466: -- Check if balances upgrade script has been run.
4467: SELECT count(1)
4468: INTO l_ledger_count
4469: FROM xla_ledger_options
4470: WHERE effective_period_num is not null;
4471:
4472:
4473: IF l_ledger_count = 0