APPS.FA_ASSET_TRACE_PKG dependencies on FA_ADDITIONS

Line 46: g_asset_number FA_ADDITIONS.ASSET_NUMBER%TYPE;

42: g_sel_tbl FA_ASSET_TRACE_PVT.t_asset_tbl;
43: g_no_rec_tbl t_asset_tbl;
44: g_tmp_tbl t_asset_tbl;
45: g_output_tbl t_asset_tbl;
46: g_asset_number FA_ADDITIONS.ASSET_NUMBER%TYPE;
47: g_asset_id FA_ADDITIONS.ASSET_ID%TYPE;
48: g_book FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
49: g_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
50: g_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;

Line 47: g_asset_id FA_ADDITIONS.ASSET_ID%TYPE;

43: g_no_rec_tbl t_asset_tbl;
44: g_tmp_tbl t_asset_tbl;
45: g_output_tbl t_asset_tbl;
46: g_asset_number FA_ADDITIONS.ASSET_NUMBER%TYPE;
47: g_asset_id FA_ADDITIONS.ASSET_ID%TYPE;
48: g_book FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
49: g_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
50: g_source_book FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK%TYPE;
51: g_sob_id FA_BOOK_CONTROLS.SET_OF_BOOKS_ID%TYPE;

Line 182: FROM fa_additions_b

178: g_asset_id := to_number(p_asset_number);
179:
180: SELECT asset_number
181: INTO g_asset_number
182: FROM fa_additions_b
183: where asset_id = g_asset_id;
184: else
185: g_asset_number := p_asset_number;
186: BEGIN

Line 189: FROM fa_additions_b

185: g_asset_number := p_asset_number;
186: BEGIN
187: SELECT asset_id
188: INTO l_asset_id
189: FROM fa_additions_b
190: WHERE asset_number = p_asset_number;
191:
192: g_asset_id := l_asset_id;
193:

Line 432: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_B';

428: and asset_id = g_asset_id
429: and book_type_code = g_book;
430:
431: l_idx:= l_idx+ 1;
432: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_B';
433: l_options_tbl(l_idx).l_gen_select := 'Y';
434: l_options_tbl(l_idx).l_col_order := 'ASSET_NUMBER,ASSET_TYPE,ASSET_CATEGORY_ID,CURRENT_UNITS';
435: l_idx:= l_idx+ 1;
436: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_TL';

Line 436: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_TL';

432: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_B';
433: l_options_tbl(l_idx).l_gen_select := 'Y';
434: l_options_tbl(l_idx).l_col_order := 'ASSET_NUMBER,ASSET_TYPE,ASSET_CATEGORY_ID,CURRENT_UNITS';
435: l_idx:= l_idx+ 1;
436: l_options_tbl(l_idx).l_tbl := 'FA_ADDITIONS_TL';
437: l_options_tbl(l_idx).l_gen_select := 'Y';
438: l_idx:= l_idx+ 1;
439: l_options_tbl(l_idx).l_tbl := 'FA_TRANSACTION_HEADERS';
440: l_options_tbl(l_idx).l_gen_select := 'Y';