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.IGI_IAC_WEBADI_PKG dependencies on FA_BOOKS

Line 82: cp_asset_id in fa_books.asset_id%type) Is

78:
79: -- Bug 3413035 Start
80: Cursor C_Full_Ret_Counter(
81: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,
82: cp_asset_id in fa_books.asset_id%type) Is
83: Select bk.period_counter_fully_retired
84: From fa_books bk
85: Where bk.book_type_code = cp_book_type_code
86: and bk.asset_id = cp_asset_id

Line 84: From fa_books bk

80: Cursor C_Full_Ret_Counter(
81: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,
82: cp_asset_id in fa_books.asset_id%type) Is
83: Select bk.period_counter_fully_retired
84: From fa_books bk
85: Where bk.book_type_code = cp_book_type_code
86: and bk.asset_id = cp_asset_id
87: and bk.transaction_header_id_out is null;
88: -- Bug 3413035 End

Line 106: p_asset_id IN fa_books.asset_id%type,

102: End If;
103: End;
104: */
105: Function Last_Period_Counter(
106: p_asset_id IN fa_books.asset_id%type,
107: p_book_type_code IN igi_iac_upload_headers.book_type_code%type,
108: p_dpis_period_counter IN number,
109: p_last_period_counter OUT NOCOPY number) Return Boolean Is
110: l_calendar_type varchar2(40);

Line 116: From fa_calendar_types ct, fa_book_controls bc, fa_books bk

112: l_life_in_months number;
113: Begin
114: Select ct.calendar_type, ct.number_per_fiscal_year, bk.life_in_months
115: Into l_calendar_type, l_number_per_fiscal_year, l_life_in_months
116: From fa_calendar_types ct, fa_book_controls bc, fa_books bk
117: Where ct.calendar_type = bc.deprn_calendar
118: and bk.book_type_code = p_book_type_code
119: and bk.date_ineffective is null
120: and bk.asset_id = p_asset_id

Line 263: From fa_books

259: Cursor C_Dpis(
260: cp_book_type_code IN igi_iac_upload_headers.book_type_code%type,
261: cp_asset_id IN igi_iac_upload_lines.asset_id%type) Is
262: Select date_placed_in_service, life_in_months
263: From fa_books
264: Where book_type_code = cp_book_type_code
265: and asset_id = cp_asset_id
266: and date_ineffective is null;
267:

Line 268: l_date_placed_in_service fa_books.date_placed_in_service%type;

264: Where book_type_code = cp_book_type_code
265: and asset_id = cp_asset_id
266: and date_ineffective is null;
267:
268: l_date_placed_in_service fa_books.date_placed_in_service%type;
269: l_life_in_months fa_books.life_in_months%type;
270: l_dpis_period_counter fa_deprn_summary.period_counter%type;
271: l_end_date fa_books.date_placed_in_service%type;
272: l_end_period_counter fa_deprn_summary.period_counter%type;

Line 269: l_life_in_months fa_books.life_in_months%type;

265: and asset_id = cp_asset_id
266: and date_ineffective is null;
267:
268: l_date_placed_in_service fa_books.date_placed_in_service%type;
269: l_life_in_months fa_books.life_in_months%type;
270: l_dpis_period_counter fa_deprn_summary.period_counter%type;
271: l_end_date fa_books.date_placed_in_service%type;
272: l_end_period_counter fa_deprn_summary.period_counter%type;
273: l_total_periods number;

Line 271: l_end_date fa_books.date_placed_in_service%type;

267:
268: l_date_placed_in_service fa_books.date_placed_in_service%type;
269: l_life_in_months fa_books.life_in_months%type;
270: l_dpis_period_counter fa_deprn_summary.period_counter%type;
271: l_end_date fa_books.date_placed_in_service%type;
272: l_end_period_counter fa_deprn_summary.period_counter%type;
273: l_total_periods number;
274: l_remaining_periods number;
275: Begin

Line 323: From fa_books

319: Cursor C_Dpis(
320: cp_book_type_code IN igi_iac_upload_headers.book_type_code%type,
321: cp_asset_id IN igi_iac_upload_lines.asset_id%type) Is
322: Select date_placed_in_service, life_in_months
323: From fa_books
324: Where book_type_code = cp_book_type_code
325: and asset_id = cp_asset_id
326: and date_ineffective is null;
327:

Line 328: l_date_placed_in_service fa_books.date_placed_in_service%type;

324: Where book_type_code = cp_book_type_code
325: and asset_id = cp_asset_id
326: and date_ineffective is null;
327:
328: l_date_placed_in_service fa_books.date_placed_in_service%type;
329: l_life_in_months fa_books.life_in_months%type;
330: l_dpis_period_counter fa_deprn_summary.period_counter%type;
331: l_end_date fa_books.date_placed_in_service%type;
332: l_end_period_counter fa_deprn_summary.period_counter%type;

Line 329: l_life_in_months fa_books.life_in_months%type;

325: and asset_id = cp_asset_id
326: and date_ineffective is null;
327:
328: l_date_placed_in_service fa_books.date_placed_in_service%type;
329: l_life_in_months fa_books.life_in_months%type;
330: l_dpis_period_counter fa_deprn_summary.period_counter%type;
331: l_end_date fa_books.date_placed_in_service%type;
332: l_end_period_counter fa_deprn_summary.period_counter%type;
333: l_total_periods number;

Line 331: l_end_date fa_books.date_placed_in_service%type;

327:
328: l_date_placed_in_service fa_books.date_placed_in_service%type;
329: l_life_in_months fa_books.life_in_months%type;
330: l_dpis_period_counter fa_deprn_summary.period_counter%type;
331: l_end_date fa_books.date_placed_in_service%type;
332: l_end_period_counter fa_deprn_summary.period_counter%type;
333: l_total_periods number;
334: l_remaining_periods number;
335: Begin

Line 712: From fa_books bk, fa_additions ad

708: Select bk.cost,
709: bk.period_counter_fully_retired,
710: ad.asset_id,
711: ad.asset_category_id
712: From fa_books bk, fa_additions ad
713: Where bk.book_type_code = cp_book_type_code
714: and bk.transaction_header_id_out is null
715: and ad.asset_id = bk.asset_id
716: and ad.asset_number = cp_asset_number;

Line 1229: FROM fa_books bk,

1225: cp_asset_id IN fa_additions.asset_id%TYPE
1226: )
1227: IS
1228: SELECT bk.cost
1229: FROM fa_books bk,
1230: fa_additions ad
1231: WHERE bk.book_type_code = cp_book_type_code
1232: AND bk.transaction_header_id_out IS NULL
1233: AND ad.asset_id = bk.asset_id

Line 1248: l_fa_asset_cost fa_books.cost%TYPE;

1244: WHERE book_type_code = cp_book_type_code
1245: AND asset_id = cp_asset_id
1246: AND period_counter = cp_period_counter;
1247:
1248: l_fa_asset_cost fa_books.cost%TYPE;
1249: l_iac_asset_cost igi_iac_asset_balances.adjusted_cost%TYPE;
1250: l_current_cost igi_iac_reval_asset_rules.current_cost%TYPE;
1251: -- bug 3536362, end 1
1252: