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 2136: FROM xla_bal_period_stats_gt gps

2132: AND xba.party_site_id = la_party_site_id(i)
2133: AND xba.initial_balance_flag = 'N'
2134: AND xba.period_name IN
2135: ( SELECT gps.period_name
2136: FROM xla_bal_period_stats_gt gps
2137: WHERE gps.ledger_id = la_ledger_id(i)
2138: AND gps.period_year = la_contribution_period_year(i)
2139: AND gps.effective_period_num >= la_contribution_eff_per_num(i)
2140: )

Line 2188: FROM xla_bal_period_stats_gt gps2

2184: + la_change_draft_balance_cr(i)
2185: )
2186: ,xba.first_period_flag =
2187: (SELECT gps2.first_period_in_year_flag
2188: FROM xla_bal_period_stats_gt gps2
2189: WHERE gps2.ledger_id = la_ledger_id(i)
2190: AND gps2.period_name = xba.period_name
2191: )
2192: ,creation_date = g_date

Line 2210: FROM xla_bal_period_stats_gt gps

2206: AND xba.party_site_id = la_party_site_id(i)
2207: AND xba.initial_balance_flag = 'N'
2208: AND xba.period_name IN
2209: ( SELECT gps.period_name
2210: FROM xla_bal_period_stats_gt gps
2211: WHERE gps.ledger_id = la_ledger_id(i)
2212: AND gps.period_year = la_contributed_period_year(i)
2213: )
2214: AND la_contributed_period_year(i) > la_contribution_period_year(i);

Line 2390: FROM xla_bal_period_stats_gt gps

2386: ,g_date
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)

Line 2908: FROM xla_bal_period_stats_gt gps

2904: AND (xba.ac5 IS NULL or xba.ac5 = la_ac5(i))
2905: AND xba.initial_balance_flag = 'N'
2906: AND xba.period_name IN
2907: ( SELECT gps.period_name
2908: FROM xla_bal_period_stats_gt gps
2909: WHERE gps.ledger_id = la_ledger_id(i)
2910: AND gps.period_year = la_contribution_period_year(i)
2911: AND gps.effective_period_num >= la_contribution_eff_per_num(i)
2912: )

Line 2946: FROM xla_bal_period_stats_gt gps2

2942: + la_change_balance_cr(i)
2943: )
2944: ,xba.first_period_flag =
2945: (SELECT gps2.first_period_in_year_flag
2946: FROM xla_bal_period_stats_gt gps2
2947: WHERE gps2.ledger_id = la_ledger_id(i)
2948: AND gps2.period_name = xba.period_name
2949: )
2950: ,creation_date = g_date

Line 2979: FROM xla_bal_period_stats_gt gps

2975: )
2976: )
2977: AND xba.period_name IN
2978: ( SELECT gps.period_name
2979: FROM xla_bal_period_stats_gt gps
2980: WHERE gps.ledger_id = la_ledger_id(i)
2981: AND gps.period_year = la_contributed_period_year(i)
2982: )
2983: AND la_contributed_period_year(i) > la_contribution_period_year(i);

Line 3101: FROM xla_bal_period_stats_gt gps

3097: ,g_date
3098: ,g_prog_appl_id
3099: ,g_prog_id
3100: ,g_req_id
3101: FROM xla_bal_period_stats_gt gps
3102: ,xla_analytical_hdrs_b xbh
3103: WHERE gps.ledger_id = la_ledger_id (i)
3104: AND gps.effective_period_num >= la_contribution_eff_per_num(i)
3105: AND gps.effective_period_num <= la_balance_stat_eff_per_num(i)

Line 5614: INTO xla_bal_period_stats_gt

5610: THEN
5611: --**Insert a record = p_equal_to_eff_per_num
5612: --Disregarded indentation for readability
5613: INSERT
5614: INTO xla_bal_period_stats_gt
5615: ( ledger_id
5616: ,period_name
5617: ,effective_period_num
5618: ,period_year

Line 5646: FROM xla_bal_period_stats_gt xbp

5642: AND gps.adjustment_period_flag = 'N'
5643: AND gps.effective_period_num = p_equal_to_eff_per_num
5644: AND (gps.ledger_id, gps.period_name)
5645: NOT IN (SELECT xbp.ledger_id, xbp.period_name
5646: FROM xla_bal_period_stats_gt xbp
5647: )
5648: );
5649:
5650: l_row_count := SQL%ROWCOUNT;

Line 5664: INTO xla_bal_period_stats_gt

5660: THEN
5661: --**insert records >= p_grt_or_equal_to_eff_per_num
5662: --Disregarded indentation for readability
5663: INSERT
5664: INTO xla_bal_period_stats_gt
5665: ( ledger_id
5666: ,period_name
5667: ,effective_period_num
5668: ,period_year

Line 5696: FROM xla_bal_period_stats_gt xbp

5692: AND gps.adjustment_period_flag = 'N'
5693: AND gps.effective_period_num >= p_grt_or_equal_to_eff_per_num
5694: AND (gps.ledger_id, gps.period_name)
5695: NOT IN (SELECT xbp.ledger_id, xbp.period_name
5696: FROM xla_bal_period_stats_gt xbp
5697: )
5698: );
5699:
5700: l_row_count := SQL%ROWCOUNT;

Line 5712: INTO xla_bal_period_stats_gt

5708: THEN
5709: --**insert records > p_grt_1_diff_2_arg1 but <> p_grt_1_diff_2_arg2
5710: --Disregarded indentation for readability
5711: INSERT
5712: INTO xla_bal_period_stats_gt
5713: ( ledger_id
5714: ,period_name
5715: ,effective_period_num
5716: ,period_year

Line 5745: FROM xla_bal_period_stats_gt xbp

5741: AND gps.effective_period_num >= p_grteq_1_diff_2_arg1
5742: AND gps.effective_period_num <> p_grteq_1_diff_2_arg2
5743: AND (gps.ledger_id, gps.period_name)
5744: NOT IN (SELECT xbp.ledger_id, xbp.period_name
5745: FROM xla_bal_period_stats_gt xbp
5746: )
5747: );
5748:
5749: l_row_count := SQL%ROWCOUNT;

Line 5761: INTO xla_bal_period_stats_gt

5757: THEN
5758: --**insert records >= p_grteq_1_less_2_arg1 but < p_grteq_1_less_2_arg2
5759: --Disregarded indentation for readability
5760: INSERT
5761: INTO xla_bal_period_stats_gt
5762: ( ledger_id
5763: ,period_name
5764: ,effective_period_num
5765: ,period_year

Line 5794: FROM xla_bal_period_stats_gt xbp

5790: AND gps.effective_period_num >= p_grteq_1_less_2_arg1
5791: AND gps.effective_period_num < p_grteq_1_less_2_arg2
5792: AND (gps.ledger_id, gps.period_name)
5793: NOT IN (SELECT xbp.ledger_id, xbp.period_name
5794: FROM xla_bal_period_stats_gt xbp
5795: )
5796: );
5797:
5798: l_row_count := SQL%ROWCOUNT;

Line 5823: || ' inserted into xla_bal_period_stats_gt'

5819: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5820: trace
5821: (p_module => l_log_module
5822: ,p_msg => l_row_count
5823: || ' inserted into xla_bal_period_stats_gt'
5824: ,p_level => C_LEVEL_STATEMENT
5825: );
5826: END IF;
5827:

Line 5884: FROM xla_bal_period_stats_gt xbst

5880:
5881: IF g_cached_ledgers(p_ledger_id) <> p_first_eff_per_num
5882: THEN
5883: DELETE
5884: FROM xla_bal_period_stats_gt xbst
5885: WHERE xbst.ledger_id = p_ledger_id;
5886:
5887: l_row_count := SQL%ROWCOUNT;
5888:

Line 5893: ' deleted from xla_bal_period_stats_gt'

5889: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5890: trace
5891: (p_module => l_log_module
5892: ,p_msg => l_row_count ||
5893: ' deleted from xla_bal_period_stats_gt'
5894: ,p_level => C_LEVEL_STATEMENT
5895: );
5896: END IF;
5897:

Line 5929: FROM xla_bal_period_stats_gt xbst

5925:
5926: IF g_cached_ledgers(p_ledger_id) < p_first_eff_per_num
5927: THEN
5928: DELETE
5929: FROM xla_bal_period_stats_gt xbst
5930: WHERE xbst.ledger_id = p_ledger_id
5931: AND ( xbst.effective_period_num < p_first_eff_per_num
5932: OR xbst.effective_period_num > p_first_eff_per_num
5933: );

Line 5941: ' deleted from xla_bal_period_stats_gt'

5937: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5938: trace
5939: (p_module => l_log_module
5940: ,p_msg => l_row_count ||
5941: ' deleted from xla_bal_period_stats_gt'
5942: ,p_level => C_LEVEL_STATEMENT
5943: );
5944: END IF;
5945: ELSIF g_cached_ledgers(p_ledger_id) = p_first_eff_per_num

Line 5948: FROM xla_bal_period_stats_gt xbst

5944: END IF;
5945: ELSIF 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:
5952: l_row_count := SQL%ROWCOUNT;

Line 5958: ' deleted from xla_bal_period_stats_gt'

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

Line 5964: FROM xla_bal_period_stats_gt xbst

5960: );
5961: END IF;
5962: ELSE --g_cached_ledgers(p_ledger_id) > p_first_eff_per_num
5963: DELETE
5964: FROM xla_bal_period_stats_gt xbst
5965: WHERE xbst.ledger_id = p_ledger_id;
5966:
5967: l_row_count := SQL%ROWCOUNT;
5968:

Line 5973: ' deleted from xla_bal_period_stats_gt'

5969: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5970: trace
5971: (p_module => l_log_module
5972: ,p_msg => l_row_count ||
5973: ' deleted from xla_bal_period_stats_gt'
5974: ,p_level => C_LEVEL_STATEMENT
5975: );
5976: END IF;
5977: --***Insert a record = p_first_eff_per_num

Line 6007: FROM xla_bal_period_stats_gt xbst

6003: END IF;
6004: IF g_cached_ledgers(p_ledger_id) < p_first_eff_per_num
6005: THEN
6006: DELETE
6007: FROM xla_bal_period_stats_gt xbst
6008: WHERE xbst.ledger_id = p_ledger_id
6009: AND xbst.effective_period_num < p_first_eff_per_num;
6010:
6011: l_row_count := SQL%ROWCOUNT;

Line 6017: ' deleted from xla_bal_period_stats_gt'

6013: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6014: trace
6015: (p_module => l_log_module
6016: ,p_msg => l_row_count ||
6017: ' deleted from xla_bal_period_stats_gt'
6018: ,p_level => C_LEVEL_STATEMENT
6019: );
6020: END IF;
6021:

Line 6064: FROM xla_bal_period_stats_gt xbst

6060: END IF;
6061: ELSIF g_cached_ledgers(p_ledger_id) < p_first_eff_per_num
6062: THEN
6063: DELETE
6064: FROM xla_bal_period_stats_gt xbst
6065: WHERE xbst.ledger_id = p_ledger_id
6066: AND xbst.effective_period_num < p_first_eff_per_num;
6067:
6068: l_row_count := SQL%ROWCOUNT;

Line 6074: ' deleted from xla_bal_period_stats_gt'

6070: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6071: trace
6072: (p_module => l_log_module
6073: ,p_msg => l_row_count ||
6074: ' deleted from xla_bal_period_stats_gt'
6075: ,p_level => C_LEVEL_STATEMENT
6076: );
6077: END IF;
6078: ELSE --g_cached_ledgers(p_ledger_id) > p_first_eff_per_num