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.

[Home] [Help]

APPS.XLA_BALANCES_PKG dependencies on XLA_CONTROL_BALANCES

Line 549: ,p_msg => 'trying to lock xla_control_balances'

545:
546: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
547: trace
548: (p_module => l_log_module
549: ,p_msg => 'trying to lock xla_control_balances'
550: ,p_level => C_LEVEL_STATEMENT
551: );
552: END IF;
553: LOCK TABLE xla_control_balances IN EXCLUSIVE MODE NOWAIT;

Line 553: LOCK TABLE xla_control_balances IN EXCLUSIVE MODE NOWAIT;

549: ,p_msg => 'trying to lock xla_control_balances'
550: ,p_level => C_LEVEL_STATEMENT
551: );
552: END IF;
553: LOCK TABLE xla_control_balances IN EXCLUSIVE MODE NOWAIT;
554:
555: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
556: trace
557: (p_module => l_log_module

Line 655: ,p_msg => 'trying to lock xla_control_balances'

651:
652: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
653: trace
654: (p_module => l_log_module
655: ,p_msg => 'trying to lock xla_control_balances'
656: ,p_level => C_LEVEL_STATEMENT
657: );
658: END IF;
659: LOCK TABLE xla_control_balances IN EXCLUSIVE MODE NOWAIT;

Line 659: LOCK TABLE xla_control_balances IN EXCLUSIVE MODE NOWAIT;

655: ,p_msg => 'trying to lock xla_control_balances'
656: ,p_level => C_LEVEL_STATEMENT
657: );
658: END IF;
659: LOCK TABLE xla_control_balances IN EXCLUSIVE MODE NOWAIT;
660:
661: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
662: trace
663: (p_module => l_log_module

Line 685: INSERT INTO xla_control_balances

681: ,cp_request_id => NVL(l_req_id, -1)
682: );
683: CLOSE lc_lock_balance_statuses;
684:
685: INSERT INTO xla_control_balances
686: ( application_id
687: ,ledger_id
688: ,code_combination_id
689: ,party_type_code

Line 798: ,xla_control_balances xba

794: ,l_prog_appl_id --program_application_id
795: ,l_prog_id --program_id
796: ,NVL(l_req_id, -1) --request_id
797: FROM xla_balance_statuses xbs
798: ,xla_control_balances xba
799: ,xla_control_balances xbanew
800: WHERE xbs.application_id = p_application_id
801: AND xbs.ledger_id = p_ledger_id
802: AND xbs.balance_source_code = 'C'

Line 799: ,xla_control_balances xbanew

795: ,l_prog_id --program_id
796: ,NVL(l_req_id, -1) --request_id
797: FROM xla_balance_statuses xbs
798: ,xla_control_balances xba
799: ,xla_control_balances xbanew
800: WHERE xbs.application_id = p_application_id
801: AND xbs.ledger_id = p_ledger_id
802: AND xbs.balance_source_code = 'C'
803: AND xbs.balance_status_code = p_balance_status_code_selected

Line 1870: ,xla_control_balances xba

1866: ,-NVL(xba.draft_beginning_balance_cr, 0)
1867: ) change_draft_balance_cr
1868: ,ctr.balance_status_eff_per_num
1869: FROM xla_bal_ctrl_ctrbs_gt ctr
1870: ,xla_control_balances xba
1871: WHERE ctr.application_id = p_application_id
1872: AND ctr.ledger_id = p_ledger_id
1873: AND ctr.effective_period_num = p_effective_period_num
1874: AND xba.application_id (+)= ctr.application_id

Line 2035: UPDATE xla_control_balances xba

2031: g_date := SYSDATE;
2032:
2033: --Update balances same year
2034: FORALL i IN 1..la_code_combination_id.LAST
2035: UPDATE xla_control_balances xba
2036: SET xba.beginning_balance_dr =
2037: DECODE( xba.period_name
2038: ,la_contribution_period_name (i)
2039: ,xba.beginning_balance_dr

Line 2157: UPDATE xla_control_balances xba

2153: g_date := SYSDATE;
2154:
2155: --UPDATE balances following years
2156: FORALL i IN 1..la_code_combination_id.LAST
2157: UPDATE xla_control_balances xba
2158: SET xba.beginning_balance_dr =
2159: DECODE( la_change_balance_dr(i)
2160: ,0
2161: ,xba.beginning_balance_dr

Line 2238: from xla_control_balances xcb, gl_period_statuses gps

2234: l_begin_bal_cr := null; --7608545 - Reset begin_bal_cr to null
2235: FOR j IN (select nvl(beginning_balance_dr,0) + nvl(period_balance_dr,0) begin_dr
2236: ,nvl(beginning_balance_cr,0) + nvl(period_balance_cr,0) begin_cr
2237: from(select xcb.*
2238: from xla_control_balances xcb, gl_period_statuses gps
2239: where xcb.application_id = la_application_id(i)
2240: and xcb.application_id = gps.application_id
2241: and xcb.ledger_id = gps.ledger_id
2242: and xcb.ledger_id = la_ledger_id(i)

Line 2256: INSERT INTO xla_control_balances xba

2252: l_begin_bal_cr := j.begin_cr;
2253:
2254: END LOOP;
2255:
2256: INSERT INTO xla_control_balances xba
2257: ( application_id
2258: ,ledger_id
2259: ,code_combination_id
2260: ,party_type_code

Line 2391: ,xla_control_balances xba

2387: ,g_prog_appl_id
2388: ,g_prog_id
2389: ,g_req_id
2390: FROM xla_bal_period_stats_gt gps
2391: ,xla_control_balances xba
2392: WHERE gps.ledger_id = la_ledger_id (i)
2393: AND gps.effective_period_num >= la_contribution_eff_per_num(i)
2394: AND gps.effective_period_num <= la_balance_stat_eff_per_num(i)
2395: AND xba.application_id (+)= la_application_id(i)

Line 3363: INSERT INTO xla_control_balances xba

3359: l_return_value := 0;
3360:
3361: IF NVL(p_balance_source_code, 'C') = 'C'
3362: THEN
3363: INSERT INTO xla_control_balances xba
3364: ( application_id
3365: ,ledger_id
3366: ,code_combination_id
3367: ,party_type_code

Line 3500: ,xla_control_balances xba

3496: ,l_prog_id
3497: ,NVL(l_req_id, -1)
3498: FROM xla_balance_statuses xbs
3499: ,gl_period_statuses gpsbs
3500: ,xla_control_balances xba
3501: ,gl_period_statuses gpsnew
3502: WHERE xbs.application_id = p_application_id
3503: AND xbs.ledger_id = p_ledger_id
3504: AND xbs.balance_source_code = 'C'

Line 3524: FROM xla_control_balances xbanew

3520: AND gpsnew.effective_period_num <= p_dest_effective_period_num
3521: AND gpsnew.effective_period_num >
3522: (
3523: SELECT MAX(effective_period_num)
3524: FROM xla_control_balances xbanew
3525: ,gl_period_statuses gpsint
3526: WHERE xbanew.ledger_id = p_ledger_id
3527: AND xbanew.application_id = p_application_id
3528: AND xbanew.code_combination_id = p_code_combination_id

Line 3543: ' xla_control_balances created'

3539: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3540: trace
3541: ( p_module => l_log_module
3542: ,p_msg => l_row_count ||
3543: ' xla_control_balances created'
3544: ,p_level => C_LEVEL_STATEMENT
3545: );
3546: END IF;
3547: END IF;

Line 7886: FROM xla_control_balances xcbext

7882:
7883: --delete control balances
7884: LOOP
7885: DELETE
7886: FROM xla_control_balances xcbext
7887: WHERE xcbext.ROWID IN
7888: ( SELECT xcb.ROWID
7889: FROM xla_balance_statuses xbs
7890: ,xla_control_balances xcb

Line 7890: ,xla_control_balances xcb

7886: FROM xla_control_balances xcbext
7887: WHERE xcbext.ROWID IN
7888: ( SELECT xcb.ROWID
7889: FROM xla_balance_statuses xbs
7890: ,xla_control_balances xcb
7891: ,gl_period_statuses gps
7892: WHERE xbs.balance_source_code = 'C'
7893: AND xbs.balance_status_code = 'R'
7894: AND xbs.request_id = NVL(l_req_id, -1)

Line 7929: ,p_msg => l_row_count || ' xla_control_balances deleted'

7925:
7926: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7927: trace
7928: (p_module => l_log_module
7929: ,p_msg => l_row_count || ' xla_control_balances deleted'
7930: ,p_level => C_LEVEL_STATEMENT
7931: );
7932: END IF;
7933:

Line 9578: --delete xla_control_balances

9574: COMMIT;
9575: END IF;
9576: END LOOP;
9577:
9578: --delete xla_control_balances
9579: LOOP
9580: DELETE
9581: FROM xla_control_balances xcb
9582: WHERE xcb.code_combination_id IN

Line 9581: FROM xla_control_balances xcb

9577:
9578: --delete xla_control_balances
9579: LOOP
9580: DELETE
9581: FROM xla_control_balances xcb
9582: WHERE xcb.code_combination_id IN
9583: (
9584: SELECT xbt.code_combination_id
9585: FROM xla_bal_synchronize_gt xbt

Line 10339: FROM xla_control_balances xba

10335: INTO l_existing_balance_period_name
10336: ,l_existing_begin_balance_dr
10337: ,l_existing_begin_balance_cr
10338: ,l_existing_balance_rowid
10339: FROM xla_control_balances xba
10340: WHERE xba.ledger_id = p_ledger_id
10341: AND xba.application_id = p_application_id
10342: AND xba.code_combination_id = p_code_combination_id
10343: AND xba.initial_balance_flag = 'Y'

Line 10380: UPDATE xla_control_balances xba

10376: xla_exceptions_pkg.raise_message
10377: (p_location => 'xla_balances_pkg.initialize');
10378: END IF;
10379:
10380: UPDATE xla_control_balances xba
10381: SET xba.initial_balance_flag = 'N'
10382: WHERE xba.rowid = l_existing_balance_rowid;
10383:
10384: l_row_count := SQL%ROWCOUNT;

Line 10468: UPDATE xla_control_balances xba

10464: ( p_mode => 'D'
10465: ,p_ae_header_id => l_ae_header_id
10466: );
10467:
10468: UPDATE xla_control_balances xba
10469: SET xba.beginning_balance_dr = xba.beginning_balance_dr + xba.period_balance_dr
10470: ,xba.beginning_balance_cr = xba.beginning_balance_cr + xba.period_balance_cr
10471: ,xba.period_balance_dr = 0
10472: ,xba.period_balance_cr = 0