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.FA_GAINLOSS_RET_PKG dependencies on FA_DEPRN_OVERRIDE

Line 1442: from fa_deprn_override do

1438:
1439: --bug13014394: checking to see if override is used or not
1440: cursor c_override_exist (c_asset_id number, c_status varchar2, c_rowid rowid)is
1441: select do.rowid
1442: from fa_deprn_override do
1443: , fa_deprn_periods dp
1444: where do.asset_id = c_asset_id
1445: and do.book_type_code = ret.book
1446: and dp.period_counter = cpd_ctr

Line 1842: if fa_cache_pkg.fa_deprn_override_enabled then

1838:
1839: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret3.1', '', p_log_level_rec => p_log_level_rec); end if;
1840:
1841: --bug13014394: checking to see if override exists for retirement
1842: if fa_cache_pkg.fa_deprn_override_enabled then
1843: open c_override_exist(ret.asset_id, 'POST', l_rowid);
1844: fetch c_override_exist into l_rowid;
1845: if c_override_exist%NOTFOUND then
1846: l_override_exist := FALSE;

Line 1892: if fa_cache_pkg.fa_deprn_override_enabled and

1888: fa_debug_pkg.add (l_calling_fn, 'before reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1889: end if;
1890:
1891: --bug13014394: checking back to see if override is used during previous fagcdp call
1892: if fa_cache_pkg.fa_deprn_override_enabled and
1893: l_override_exist then
1894: open c_override_exist(ret.asset_id, 'POSTED', l_rowid);
1895: fetch c_override_exist into l_rowid;
1896: if c_override_exist%NOTFOUND then

Line 2139: if fa_cache_pkg.fa_deprn_override_enabled then

2135: l_rowid := null;
2136: l_override_exist := FALSE;
2137: l_override_used := FALSE;
2138:
2139: if fa_cache_pkg.fa_deprn_override_enabled then
2140: open c_override_exist(bk.group_asset_id, 'POST', l_rowid);
2141: fetch c_override_exist into l_rowid;
2142: if c_override_exist%NOTFOUND then
2143: l_override_exist := FALSE;

Line 2191: if fa_cache_pkg.fa_deprn_override_enabled and

2187: fa_debug_pkg.add (l_calling_fn, 'before group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2188: end if;
2189:
2190: --bug13014394: checking back to see if override is used during previous fagcdp call
2191: if fa_cache_pkg.fa_deprn_override_enabled and
2192: l_override_exist then
2193: open c_override_exist(bk.group_asset_id, 'POSTED', l_rowid);
2194: fetch c_override_exist into l_rowid;
2195: if c_override_exist%NOTFOUND then