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_BAL_PERIOD_STATS_GT

Line 2125: FROM xla_bal_period_stats_gt gps

2121: AND xba.party_site_id = la_party_site_id(i)
2122: AND xba.initial_balance_flag = 'N'
2123: AND xba.period_name IN
2124: ( SELECT gps.period_name
2125: FROM xla_bal_period_stats_gt gps
2126: WHERE gps.ledger_id = la_ledger_id(i)
2127: AND gps.period_year = la_contribution_period_year(i)
2128: AND gps.effective_period_num >= la_contribution_eff_per_num(i)
2129: )

Line 2177: FROM xla_bal_period_stats_gt gps2

2173: + la_change_draft_balance_cr(i)
2174: )
2175: ,xba.first_period_flag =
2176: (SELECT gps2.first_period_in_year_flag
2177: FROM xla_bal_period_stats_gt gps2
2178: WHERE gps2.ledger_id = la_ledger_id(i)
2179: AND gps2.period_name = xba.period_name
2180: )
2181: ,creation_date = g_date

Line 2199: FROM xla_bal_period_stats_gt gps

2195: AND xba.party_site_id = la_party_site_id(i)
2196: AND xba.initial_balance_flag = 'N'
2197: AND xba.period_name IN
2198: ( SELECT gps.period_name
2199: FROM xla_bal_period_stats_gt gps
2200: WHERE gps.ledger_id = la_ledger_id(i)
2201: AND gps.period_year = la_contributed_period_year(i)
2202: )
2203: AND la_contributed_period_year(i) > la_contribution_period_year(i);

Line 2381: FROM xla_bal_period_stats_gt gps

2377: ,g_prog_appl_id
2378: ,g_prog_id
2379: ,g_req_id
2380: ,gps.effective_period_num
2381: FROM xla_bal_period_stats_gt gps
2382: ,xla_control_balances xba
2383: WHERE gps.ledger_id = la_ledger_id (i)
2384: AND gps.effective_period_num >= la_contribution_eff_per_num(i)
2385: AND gps.effective_period_num <= la_balance_stat_eff_per_num(i)

Line 2900: FROM xla_bal_period_stats_gt gps

2896: AND nvl(xba.ac5,' ') = nvl(la_ac5(i),' ')
2897: AND xba.initial_balance_flag = 'N'
2898: AND xba.period_name IN
2899: ( SELECT /*+ CARDINALITY(GPS,1) */ gps.period_name
2900: FROM xla_bal_period_stats_gt gps
2901: WHERE gps.ledger_id = la_ledger_id(i)
2902: AND gps.period_year = la_contribution_period_year(i)
2903: AND gps.effective_period_num >= la_contribution_eff_per_num(i)
2904: )

Line 2938: FROM xla_bal_period_stats_gt gps2

2934: + la_change_balance_cr(i)
2935: )
2936: ,xba.first_period_flag =
2937: (SELECT gps2.first_period_in_year_flag
2938: FROM xla_bal_period_stats_gt gps2
2939: WHERE gps2.ledger_id = la_ledger_id(i)
2940: AND gps2.period_name = xba.period_name
2941: )
2942: ,creation_date = g_date

Line 2971: FROM xla_bal_period_stats_gt gps

2967: )
2968: )
2969: AND xba.period_name IN
2970: ( SELECT /*+ CARDINALITY(GPS,1) */ gps.period_name
2971: FROM xla_bal_period_stats_gt gps
2972: WHERE gps.ledger_id = la_ledger_id(i)
2973: AND gps.period_year = la_contributed_period_year(i)
2974: )
2975: AND la_contributed_period_year(i) > la_contribution_period_year(i);

Line 3095: FROM xla_bal_period_stats_gt gps

3091: ,g_prog_appl_id
3092: ,g_prog_id
3093: ,g_req_id
3094: ,gps.effective_period_num
3095: FROM xla_bal_period_stats_gt gps
3096: ,xla_analytical_hdrs_b xbh
3097: WHERE gps.ledger_id = la_ledger_id (i)
3098: AND gps.effective_period_num >= la_contribution_eff_per_num(i)
3099: AND gps.effective_period_num <= la_balance_stat_eff_per_num(i)

Line 5633: INTO xla_bal_period_stats_gt

5629: THEN
5630: --**Insert a record = p_equal_to_eff_per_num
5631: --Disregarded indentation for readability
5632: INSERT
5633: INTO xla_bal_period_stats_gt
5634: ( ledger_id
5635: ,period_name
5636: ,effective_period_num
5637: ,period_year

Line 5665: FROM xla_bal_period_stats_gt xbp

5661: AND gps.adjustment_period_flag = 'N'
5662: AND gps.effective_period_num = p_equal_to_eff_per_num
5663: AND (gps.ledger_id, gps.period_name)
5664: NOT IN (SELECT xbp.ledger_id, xbp.period_name
5665: FROM xla_bal_period_stats_gt xbp
5666: )
5667: );
5668:
5669: l_row_count := SQL%ROWCOUNT;

Line 5683: INTO xla_bal_period_stats_gt

5679: THEN
5680: --**insert records >= p_grt_or_equal_to_eff_per_num
5681: --Disregarded indentation for readability
5682: INSERT
5683: INTO xla_bal_period_stats_gt
5684: ( ledger_id
5685: ,period_name
5686: ,effective_period_num
5687: ,period_year

Line 5715: FROM xla_bal_period_stats_gt xbp

5711: AND gps.adjustment_period_flag = 'N'
5712: AND gps.effective_period_num >= p_grt_or_equal_to_eff_per_num
5713: AND (gps.ledger_id, gps.period_name)
5714: NOT IN (SELECT xbp.ledger_id, xbp.period_name
5715: FROM xla_bal_period_stats_gt xbp
5716: )
5717: );
5718:
5719: l_row_count := SQL%ROWCOUNT;

Line 5731: INTO xla_bal_period_stats_gt

5727: THEN
5728: --**insert records > p_grt_1_diff_2_arg1 but <> p_grt_1_diff_2_arg2
5729: --Disregarded indentation for readability
5730: INSERT
5731: INTO xla_bal_period_stats_gt
5732: ( ledger_id
5733: ,period_name
5734: ,effective_period_num
5735: ,period_year

Line 5764: FROM xla_bal_period_stats_gt xbp

5760: AND gps.effective_period_num >= p_grteq_1_diff_2_arg1
5761: AND gps.effective_period_num <> p_grteq_1_diff_2_arg2
5762: AND (gps.ledger_id, gps.period_name)
5763: NOT IN (SELECT xbp.ledger_id, xbp.period_name
5764: FROM xla_bal_period_stats_gt xbp
5765: )
5766: );
5767:
5768: l_row_count := SQL%ROWCOUNT;

Line 5780: INTO xla_bal_period_stats_gt

5776: THEN
5777: --**insert records >= p_grteq_1_less_2_arg1 but < p_grteq_1_less_2_arg2
5778: --Disregarded indentation for readability
5779: INSERT
5780: INTO xla_bal_period_stats_gt
5781: ( ledger_id
5782: ,period_name
5783: ,effective_period_num
5784: ,period_year

Line 5813: FROM xla_bal_period_stats_gt xbp

5809: AND gps.effective_period_num >= p_grteq_1_less_2_arg1
5810: AND gps.effective_period_num < p_grteq_1_less_2_arg2
5811: AND (gps.ledger_id, gps.period_name)
5812: NOT IN (SELECT xbp.ledger_id, xbp.period_name
5813: FROM xla_bal_period_stats_gt xbp
5814: )
5815: );
5816:
5817: l_row_count := SQL%ROWCOUNT;

Line 5842: || ' inserted into xla_bal_period_stats_gt'

5838: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5839: trace
5840: (p_module => l_log_module
5841: ,p_msg => l_row_count
5842: || ' inserted into xla_bal_period_stats_gt'
5843: ,p_level => C_LEVEL_STATEMENT
5844: );
5845: END IF;
5846:

Line 5903: FROM xla_bal_period_stats_gt xbst

5899:
5900: IF g_cached_ledgers(p_ledger_id) <> p_first_eff_per_num
5901: THEN
5902: DELETE
5903: FROM xla_bal_period_stats_gt xbst
5904: WHERE xbst.ledger_id = p_ledger_id;
5905:
5906: l_row_count := SQL%ROWCOUNT;
5907:

Line 5912: ' deleted from xla_bal_period_stats_gt'

5908: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5909: trace
5910: (p_module => l_log_module
5911: ,p_msg => l_row_count ||
5912: ' deleted from xla_bal_period_stats_gt'
5913: ,p_level => C_LEVEL_STATEMENT
5914: );
5915: END IF;
5916:

Line 5948: FROM xla_bal_period_stats_gt xbst

5944:
5945: IF g_cached_ledgers(p_ledger_id) < p_first_eff_per_num
5946: THEN
5947: DELETE
5948: FROM xla_bal_period_stats_gt xbst
5949: WHERE xbst.ledger_id = p_ledger_id
5950: AND ( xbst.effective_period_num < p_first_eff_per_num
5951: OR xbst.effective_period_num > p_first_eff_per_num
5952: );

Line 5960: ' deleted from xla_bal_period_stats_gt'

5956: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5957: trace
5958: (p_module => l_log_module
5959: ,p_msg => l_row_count ||
5960: ' deleted from xla_bal_period_stats_gt'
5961: ,p_level => C_LEVEL_STATEMENT
5962: );
5963: END IF;
5964: ELSIF g_cached_ledgers(p_ledger_id) = p_first_eff_per_num

Line 5967: FROM xla_bal_period_stats_gt xbst

5963: END IF;
5964: ELSIF g_cached_ledgers(p_ledger_id) = p_first_eff_per_num
5965: THEN
5966: DELETE
5967: FROM xla_bal_period_stats_gt xbst
5968: WHERE xbst.ledger_id = p_ledger_id
5969: AND xbst.effective_period_num > p_first_eff_per_num;
5970:
5971: l_row_count := SQL%ROWCOUNT;

Line 5977: ' deleted from xla_bal_period_stats_gt'

5973: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5974: trace
5975: (p_module => l_log_module
5976: ,p_msg => l_row_count ||
5977: ' deleted from xla_bal_period_stats_gt'
5978: ,p_level => C_LEVEL_STATEMENT
5979: );
5980: END IF;
5981: ELSE --g_cached_ledgers(p_ledger_id) > p_first_eff_per_num

Line 5983: FROM xla_bal_period_stats_gt xbst

5979: );
5980: END IF;
5981: ELSE --g_cached_ledgers(p_ledger_id) > p_first_eff_per_num
5982: DELETE
5983: FROM xla_bal_period_stats_gt xbst
5984: WHERE xbst.ledger_id = p_ledger_id;
5985:
5986: l_row_count := SQL%ROWCOUNT;
5987:

Line 5992: ' deleted from xla_bal_period_stats_gt'

5988: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5989: trace
5990: (p_module => l_log_module
5991: ,p_msg => l_row_count ||
5992: ' deleted from xla_bal_period_stats_gt'
5993: ,p_level => C_LEVEL_STATEMENT
5994: );
5995: END IF;
5996: --***Insert a record = p_first_eff_per_num

Line 6026: FROM xla_bal_period_stats_gt xbst

6022: END IF;
6023: IF g_cached_ledgers(p_ledger_id) < p_first_eff_per_num
6024: THEN
6025: DELETE
6026: FROM xla_bal_period_stats_gt xbst
6027: WHERE xbst.ledger_id = p_ledger_id
6028: AND xbst.effective_period_num < p_first_eff_per_num;
6029:
6030: l_row_count := SQL%ROWCOUNT;

Line 6036: ' deleted from xla_bal_period_stats_gt'

6032: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6033: trace
6034: (p_module => l_log_module
6035: ,p_msg => l_row_count ||
6036: ' deleted from xla_bal_period_stats_gt'
6037: ,p_level => C_LEVEL_STATEMENT
6038: );
6039: END IF;
6040:

Line 6083: FROM xla_bal_period_stats_gt xbst

6079: END IF;
6080: ELSIF g_cached_ledgers(p_ledger_id) < p_first_eff_per_num
6081: THEN
6082: DELETE
6083: FROM xla_bal_period_stats_gt xbst
6084: WHERE xbst.ledger_id = p_ledger_id
6085: AND xbst.effective_period_num < p_first_eff_per_num;
6086:
6087: l_row_count := SQL%ROWCOUNT;

Line 6093: ' deleted from xla_bal_period_stats_gt'

6089: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6090: trace
6091: (p_module => l_log_module
6092: ,p_msg => l_row_count ||
6093: ' deleted from xla_bal_period_stats_gt'
6094: ,p_level => C_LEVEL_STATEMENT
6095: );
6096: END IF;
6097: ELSE --g_cached_ledgers(p_ledger_id) > p_first_eff_per_num