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

Line 559: ,p_msg => 'trying to lock xla_ac_balances'

555:
556: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
557: trace
558: (p_module => l_log_module
559: ,p_msg => 'trying to lock xla_ac_balances'
560: ,p_level => C_LEVEL_STATEMENT
561: );
562: END IF;
563: LOCK TABLE xla_ac_balances IN EXCLUSIVE MODE NOWAIT;

Line 563: LOCK TABLE xla_ac_balances IN EXCLUSIVE MODE NOWAIT;

559: ,p_msg => 'trying to lock xla_ac_balances'
560: ,p_level => C_LEVEL_STATEMENT
561: );
562: END IF;
563: LOCK TABLE xla_ac_balances IN EXCLUSIVE MODE NOWAIT;
564:
565: END IF;
566:
567: l_date := SYSDATE;

Line 665: ,p_msg => 'trying to lock xla_ac_balances'

661:
662: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
663: trace
664: (p_module => l_log_module
665: ,p_msg => 'trying to lock xla_ac_balances'
666: ,p_level => C_LEVEL_STATEMENT
667: );
668: END IF;
669: LOCK TABLE xla_ac_balances IN EXCLUSIVE MODE NOWAIT;

Line 669: LOCK TABLE xla_ac_balances IN EXCLUSIVE MODE NOWAIT;

665: ,p_msg => 'trying to lock xla_ac_balances'
666: ,p_level => C_LEVEL_STATEMENT
667: );
668: END IF;
669: LOCK TABLE xla_ac_balances IN EXCLUSIVE MODE NOWAIT;
670:
671: END IF;
672:
673: IF NVL(p_balance_source_code, 'C') = 'C'

Line 849: INSERT INTO xla_ac_balances

845: ,cp_request_id => NVL(l_req_id, -1)
846: );
847: CLOSE lc_lock_balance_statuses;
848:
849: INSERT INTO xla_ac_balances
850: ( application_id
851: ,ledger_id
852: ,code_combination_id
853: ,analytical_criterion_code

Line 880: SELECT /+ leading(XBS XBA) use_nl(XBH XBA) index(XBA XLA_AC_BALANCES_N1) index(XBA_NEW XLA_AC_BALANCES_N1) / xba.application_id

876: ,program_id
877: ,request_id
878: ,effective_period_num
879: )
880: SELECT /*+ leading(XBS XBA) use_nl(XBH XBA) index(XBA XLA_AC_BALANCES_N1) index(XBA_NEW XLA_AC_BALANCES_N1) */ xba.application_id
881: ,xba.ledger_id
882: ,xba.code_combination_id
883: ,xba.analytical_criterion_code
884: ,xba.analytical_criterion_type_code

Line 938: ,xla_ac_balances xba

934: ,l_prog_id --program_id
935: ,NVL(l_req_id, -1) --request_id
936: ,l_dest_effective_period_num
937: FROM xla_balance_statuses xbs
938: ,xla_ac_balances xba
939: ,xla_analytical_hdrs_b xbh
940: WHERE xbs.application_id = p_application_id
941: AND xbs.ledger_id = p_ledger_id
942: AND xbs.balance_source_code = 'A'

Line 962: FROM xla_ac_balances xba1

958: )
959: )
960: -- Bug 7321087 Begin
961: AND NOT EXISTS( SELECT 1
962: FROM xla_ac_balances xba1
963: WHERE xba1.application_id = xba.application_id
964: AND xba1.ledger_id = xba.ledger_id
965: AND xba1.code_combination_id = xba.code_combination_id
966: AND xba1.analytical_criterion_code = xba.analytical_criterion_code

Line 2534: ,xla_ac_balances xba

2530: ,xbh.year_end_carry_forward_code
2531: ,ctr.account_type
2532: FROM xla_bal_ac_ctrbs_gt ctr
2533: ,xla_analytical_hdrs_b xbh
2534: ,xla_ac_balances xba
2535: WHERE ctr.application_id = p_application_id
2536: AND ctr.ledger_id = p_ledger_id
2537: AND ctr.effective_period_num = p_effective_period_num
2538: AND xbh.analytical_criterion_code = ctr.analytical_criterion_code

Line 2829: UPDATE /+ NO_EXPAND INDEX (XBA XLA_AC_BALANCES_U1)/ xla_ac_balances xba

2825: g_date := SYSDATE;
2826:
2827: --Update balances same year
2828: FORALL i IN 1..la_code_combination_id.LAST
2829: UPDATE /*+ NO_EXPAND INDEX (XBA XLA_AC_BALANCES_U1)*/ xla_ac_balances xba
2830: SET xba.beginning_balance_dr =
2831: DECODE( xba.period_name
2832: ,la_contribution_period_name (i)
2833: ,xba.beginning_balance_dr

Line 2921: UPDATE /+ NO_EXPAND INDEX (XBA XLA_AC_BALANCES_U1)/ xla_ac_balances xba

2917: g_date := SYSDATE;
2918:
2919: --UPDATE balances following years
2920: FORALL i IN 1..la_code_combination_id.LAST
2921: UPDATE /*+ NO_EXPAND INDEX (XBA XLA_AC_BALANCES_U1)*/ xla_ac_balances xba
2922: SET xba.beginning_balance_dr =
2923: DECODE( la_change_balance_dr(i)
2924: ,0
2925: ,xba.beginning_balance_dr

Line 2994: INSERT INTO xla_ac_balances xba

2990: THEN
2991: g_date := SYSDATE;
2992:
2993: FORALL i IN 1..la_code_combination_id.LAST
2994: INSERT INTO xla_ac_balances xba
2995: ( application_id
2996: ,ledger_id
2997: ,code_combination_id
2998: ,analytical_criterion_code

Line 3105: FROM xla_ac_balances xba

3101: AND NOT EXISTS
3102: (
3103: -- bug 7113937 Removed outer join in where clause
3104: SELECT /*+ no_unnest */ 1
3105: FROM xla_ac_balances xba
3106: WHERE xba.application_id = la_application_id(i)
3107: AND xba.ledger_id = la_ledger_id (i)
3108: AND xba.code_combination_id = la_code_combination_id(i)
3109: AND xba.analytical_criterion_code = la_analytical_criterion_code(i)

Line 3170: xla_bal_ac_ctrbs_gt and xla_ac_balances.

3166:
3167: /*
3168: bug#8347976 PLSQL numeric character to number conversion error while undo acctng.
3169: p_analytical_criterion_code is VARCHAR2 wherever its referenced ie
3170: xla_bal_ac_ctrbs_gt and xla_ac_balances.
3171: */
3172:
3173: FUNCTION move_identified_bals_forward
3174: ( p_application_id IN INTEGER

Line 3555: INSERT INTO xla_ac_balances xba

3551: END IF;
3552:
3553: IF NVL(p_balance_source_code, 'A') = 'A'
3554: THEN
3555: INSERT INTO xla_ac_balances xba
3556: ( application_id
3557: ,ledger_id
3558: ,code_combination_id
3559: ,analytical_criterion_code

Line 3663: ,xla_ac_balances xba

3659: ,NVL(l_req_id, -1)
3660: ,gpsbs.effective_period_num
3661: FROM xla_balance_statuses xbs
3662: ,gl_period_statuses gpsbs
3663: ,xla_ac_balances xba
3664: ,gl_period_statuses gpsnew
3665: ,xla_analytical_hdrs_b xbh
3666: WHERE xbs.application_id = p_application_id
3667: AND xbs.ledger_id = p_ledger_id

Line 3703: FROM xla_ac_balances xbanew

3699: AND gpsnew.effective_period_num <= p_dest_effective_period_num
3700: AND gpsnew.effective_period_num >
3701: (
3702: SELECT MAX(gpsint.effective_period_num)
3703: FROM xla_ac_balances xbanew
3704: ,gl_period_statuses gpsint
3705: WHERE xbanew.ledger_id = p_ledger_id
3706: AND xbanew.application_id = p_application_id
3707: AND xbanew.code_combination_id = p_code_combination_id

Line 3719: ' xla_ac_balances created'

3715: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3716: trace
3717: ( p_module => l_log_module
3718: ,p_msg => l_row_count ||
3719: ' xla_ac_balances created'
3720: ,p_level => C_LEVEL_STATEMENT
3721: );
3722: END IF;
3723: END IF;

Line 8121: --delete xla_ac_balances

8117: COMMIT;
8118: END IF;
8119: END LOOP;
8120:
8121: --delete xla_ac_balances
8122: LOOP
8123: DELETE
8124: FROM xla_ac_balances xabext
8125: WHERE xabext.ROWID IN

Line 8124: FROM xla_ac_balances xabext

8120:
8121: --delete xla_ac_balances
8122: LOOP
8123: DELETE
8124: FROM xla_ac_balances xabext
8125: WHERE xabext.ROWID IN
8126: ( SELECT xab.ROWID
8127: FROM xla_balance_statuses xbs
8128: ,xla_ac_balances xab

Line 8128: ,xla_ac_balances xab

8124: FROM xla_ac_balances xabext
8125: WHERE xabext.ROWID IN
8126: ( SELECT xab.ROWID
8127: FROM xla_balance_statuses xbs
8128: ,xla_ac_balances xab
8129: ,gl_period_statuses gps
8130: WHERE xbs.balance_source_code = 'A'
8131: AND xbs.balance_status_code = 'R'
8132: AND xbs.request_id = NVL(l_req_id, -1)

Line 8149: ,p_msg => l_row_count || ' xla_ac_balances deleted'

8145:
8146: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8147: trace
8148: ( p_module => l_log_module
8149: ,p_msg => l_row_count || ' xla_ac_balances deleted'
8150: ,p_level => C_LEVEL_STATEMENT
8151: );
8152: END IF;
8153: