APPS.XLA_BALANCES_CALC_PKG dependencies on XLA_CTRL_BAL_INTERIM_GT

Line 1607: l_summary_stmt VARCHAR2(6000):= 'INSERT INTO xla_ctrl_bal_interim_gt (

1603: l_summary_bind_count INTEGER :=1 ;
1604: l_processed_bind_array t_array_varchar;
1605: l_processed_bind_count INTEGER :=1 ;
1606:
1607: l_summary_stmt VARCHAR2(6000):= 'INSERT INTO xla_ctrl_bal_interim_gt (
1608: application_id
1609: , ledger_id
1610: , code_combination_id
1611: , party_type_code

Line 1918: , p_msg => '# rows inserted in xla_ctrl_bal_interim_gt : '

1914:
1915: IF (c_level_procedure >= g_log_level)
1916: THEN
1917: TRACE (p_module => l_log_module
1918: , p_msg => '# rows inserted in xla_ctrl_bal_interim_gt : '
1919: || l_insert1_count
1920: , p_level => c_level_procedure
1921: );
1922: END IF;

Line 1940: MERGE INTO xla_ctrl_bal_interim_gt stmp

1936:
1937: --
1938: -- Calculate the bgin balance and insert records into summary table for future periods
1939: --
1940: MERGE INTO xla_ctrl_bal_interim_gt stmp
1941: USING (SELECT period_balance_dr
1942: , period_balance_cr
1943: , SUM (lag_dr) OVER (PARTITION BY application_id, ledger_id, code_combination_id
1944: , party_type_code, party_id, party_site_id

Line 2034: , xla_ctrl_bal_interim_gt tmp

2030: , gps.period_name
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

Line 2096: , p_msg => '# rows merged in xla_ctrl_bal_interim_gt : '

2092:
2093: IF (c_level_procedure >= g_log_level)
2094: THEN
2095: TRACE (p_module => l_log_module
2096: , p_msg => '# rows merged in xla_ctrl_bal_interim_gt : '
2097: || l_merge_count
2098: , p_level => c_level_procedure
2099: );
2100: END IF;

Line 2116: (SELECT /*+ $parallel$ index(tmp,xla_ctrl_bal_interim_gt_U1) */

2112: , program_id = '||g_prog_id||'
2113: , request_id = '||g_req_id||'
2114: ,(period_balance_dr, period_balance_cr, beginning_balance_dr
2115: , beginning_balance_cr) =
2116: (SELECT /*+ $parallel$ index(tmp,xla_ctrl_bal_interim_gt_U1) */
2117: NVL (b.period_balance_dr, 0)
2118: + NVL (tmp.period_balance_dr, 0) period_balance_dr
2119: , NVL (b.period_balance_cr, 0)
2120: + NVL (tmp.period_balance_cr, 0) period_balance_cr

Line 2125: FROM xla_ctrl_bal_interim_gt tmp

2121: , NVL (b.beginning_balance_dr, 0)
2122: + NVL (tmp.beginning_balance_dr, 0) beginning_balance_dr
2123: , NVL (b.beginning_balance_cr, 0)
2124: + NVL (tmp.beginning_balance_cr, 0) beginning_balance_cr
2125: FROM xla_ctrl_bal_interim_gt tmp
2126: WHERE tmp.application_id = b.application_id
2127: AND tmp.ledger_id = b.ledger_id
2128: AND tmp.code_combination_id = b.code_combination_id
2129: AND tmp.party_type_code = b.party_type_code

Line 2149: FROM xla_ctrl_bal_interim_gt xal_bal1)';

2145: , xal_bal1.party_type_code
2146: , xal_bal1.party_id
2147: , xal_bal1.party_site_id
2148: , xal_bal1.effective_period_num
2149: FROM xla_ctrl_bal_interim_gt xal_bal1)';
2150:
2151: -- Replace parallel hint based on the profile option
2152: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN
2153: l_update_bal := REPLACE(l_update_bal,'$parallel$','parallel(tmp)');

Line 2259: FROM xla_ctrl_bal_interim_gt temp

2255: , '''||g_date||'''
2256: , '||g_prog_appl_id||'
2257: , '||g_prog_id||'
2258: , '||g_req_id||'
2259: FROM xla_ctrl_bal_interim_gt temp
2260: , gl_period_statuses gps
2261: , xla_ledger_relationships_v xlr
2262: WHERE xlr.ledger_id = temp.ledger_id
2263: AND gps.ledger_id = DECODE(xlr.ledger_category_code, ''ALC''