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_ADDITIONS

Line 20: cp_asset_number IN fa_additions.asset_number%type) Is

16: Where file_name = cp_file_name
17: and status_flag = 'T';
18:
19: Cursor C_Asset_Exists(cp_file_name IN igi_iac_upload_headers.file_name%type,
20: cp_asset_number IN fa_additions.asset_number%type) Is
21: Select hd.Book_Type_Code,
22: hd.Period_Counter,
23: hd.Currency_Code,
24: hd.Status_Flag Hdr_Status_Flag,

Line 42: fa_additions fa

38: ln.Exception_Message,
39: ln.Comments
40: From igi_iac_upload_headers hd,
41: igi_iac_upload_lines ln,
42: fa_additions fa
43: Where fa.asset_number = cp_asset_number
44: and hd.file_name = cp_file_name
45: and ln.file_name = hd.file_name
46: and ln.asset_id = fa.asset_id;

Line 49: cp_asset_number IN fa_additions.asset_number%type,

45: and ln.file_name = hd.file_name
46: and ln.asset_id = fa.asset_id;
47:
48: Cursor C_Excpt_Asset(cp_file_name IN igi_iac_upload_headers.file_name%type,
49: cp_asset_number IN fa_additions.asset_number%type,
50: cp_line_num IN igi_iac_upload_lines.line_num%type) Is
51: Select hd.Book_Type_Code,
52: hd.Period_Counter,
53: hd.Currency_Code,

Line 72: fa_additions fa

68: ln.Exception_Message,
69: ln.Comments
70: From igi_iac_upload_headers hd,
71: igi_iac_upload_lines ln,
72: fa_additions fa
73: Where fa.asset_number = cp_asset_number
74: and hd.file_name = cp_file_name
75: and ln.file_name = hd.file_name
76: and ln.asset_id = fa.asset_id

Line 135: p_asset_number IN fa_additions.asset_number%type) Is

131:
132: Procedure Assign_Values_To_Rec(
133: p_upload_record IN out nocopy upload_record,
134: p_file_name IN igi_iac_upload_headers.file_name%type,
135: p_asset_number IN fa_additions.asset_number%type) Is
136: Begin
137: For C_Asset_Exists_Rec in C_Asset_Exists(p_file_Name, p_asset_number) Loop
138: p_upload_record.File_Name := p_file_name;
139: p_upload_record.Book_Type_Code := C_Asset_Exists_Rec.Book_Type_Code;

Line 644: p_asset_number IN fa_additions.asset_number%type) Is

640: Procedure Final_Dup_Asset_Check(
641: p_file_name IN igi_iac_upload_headers.file_name%type,
642: p_asset_id IN igi_iac_upload_lines.asset_id%type,
643: p_line_num IN igi_iac_upload_lines.line_num%type,
644: p_asset_number IN fa_additions.asset_number%type) Is
645: Cursor C_Dup_Count(cp_file_name IN igi_iac_upload_headers.file_name%type,
646: cp_asset_id IN igi_iac_upload_lines.asset_id%type,
647: cp_line_num IN igi_iac_upload_lines.line_num%type) Is
648: Select count(*)

Line 694: P_Asset_Number IN fa_additions.asset_number%type,

690: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
691: P_Tolerance_Flag IN igi_iac_upload_headers.tolerance_flag%type,
692: P_Tolerance_Amount IN igi_iac_upload_headers.tolerance_amount%type,
693: P_Tolerance_Percent IN igi_iac_upload_headers.tolerance_percent%type,
694: P_Asset_Number IN fa_additions.asset_number%type,
695: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
696: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is
697:
698: Cursor C_Book_Defaults(

Line 707: cp_asset_number in fa_additions.asset_number%type) Is

703: and gl.set_of_books_id = fa.set_of_books_id;
704:
705: Cursor C_Asset_Details(
706: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,
707: cp_asset_number in fa_additions.asset_number%type) Is
708: Select bk.cost,
709: bk.period_counter_fully_retired,
710: ad.asset_id,
711: ad.asset_category_id

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 878: P_Asset_Number IN fa_additions.asset_number%type,

874: P_Period IN fa_deprn_periods.period_name%type,
875: P_Currency IN igi_iac_upload_headers.currency_code%type,
876: P_Status IN igi_iac_upload_headers.status_flag%type,
877: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
878: P_Asset_Number IN fa_additions.asset_number%type,
879: P_Asset_Desc IN fa_additions.description%type,
880: P_Cat_Desc IN fa_categories.description%type,
881: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,
882: P_New_Cost IN igi_iac_upload_lines.new_cost%type,

Line 879: P_Asset_Desc IN fa_additions.description%type,

875: P_Currency IN igi_iac_upload_headers.currency_code%type,
876: P_Status IN igi_iac_upload_headers.status_flag%type,
877: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
878: P_Asset_Number IN fa_additions.asset_number%type,
879: P_Asset_Desc IN fa_additions.description%type,
880: P_Cat_Desc IN fa_categories.description%type,
881: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,
882: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
883: P_Amt_Diff IN igi_iac_upload_lines.amount_diff%type,

Line 982: P_Asset_Number IN fa_additions.asset_number%type,

978: P_Period IN fa_deprn_periods.period_name%type,
979: P_Currency IN igi_iac_upload_headers.currency_code%type,
980: P_Status IN igi_iac_upload_headers.status_flag%type,
981: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
982: P_Asset_Number IN fa_additions.asset_number%type,
983: P_Line_Num IN igi_iac_upload_lines.line_num%type,
984: P_Asset_Desc IN fa_additions.description%type,
985: P_Cat_Desc IN fa_categories.description%type,
986: P_New_Cost IN igi_iac_upload_lines.new_cost%type,

Line 984: P_Asset_Desc IN fa_additions.description%type,

980: P_Status IN igi_iac_upload_headers.status_flag%type,
981: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
982: P_Asset_Number IN fa_additions.asset_number%type,
983: P_Line_Num IN igi_iac_upload_lines.line_num%type,
984: P_Asset_Desc IN fa_additions.description%type,
985: P_Cat_Desc IN fa_categories.description%type,
986: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
987: P_Message IN igi_iac_upload_lines.exception_message%type,
988: P_Line_Action IN fnd_lookup_values.lookup_code%type,

Line 1110: P_Asset_Number IN fa_additions.asset_number%type,

1106: P_Period IN fa_deprn_periods.period_name%type,
1107: P_Currency IN igi_iac_upload_headers.currency_code%type,
1108: P_Status IN igi_iac_upload_headers.status_flag%type,
1109: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
1110: P_Asset_Number IN fa_additions.asset_number%type,
1111: P_Asset_Desc IN fa_additions.description%type,
1112: P_Cat_Desc IN fa_categories.description%type,
1113: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,
1114: P_New_Cost IN igi_iac_upload_lines.new_cost%type,

Line 1111: P_Asset_Desc IN fa_additions.description%type,

1107: P_Currency IN igi_iac_upload_headers.currency_code%type,
1108: P_Status IN igi_iac_upload_headers.status_flag%type,
1109: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
1110: P_Asset_Number IN fa_additions.asset_number%type,
1111: P_Asset_Desc IN fa_additions.description%type,
1112: P_Cat_Desc IN fa_categories.description%type,
1113: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,
1114: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
1115: P_Line_Action IN fnd_lookup_values.lookup_code%type,

Line 1221: fa_additions fa

1217: irar.selected_for_reval_flag,
1218: iir.status
1219: FROM igi_iac_reval_asset_rules irar,
1220: igi_iac_revaluations iir,
1221: fa_additions fa
1222: WHERE irar.book_type_code = cp_book_type_code
1223: AND fa.asset_id = irar.asset_id
1224: AND irar.revaluation_id = iir.revaluation_id
1225: AND irar.revaluation_id = (SELECT max(revaluation_id)

Line 1239: cp_asset_id IN fa_additions.asset_id%TYPE

1235:
1236: -- bug 3536362, start 1
1237: -- cursor to retrieve the historic portion of the cost of an asset
1238: CURSOR C_FA_Asset_Cost(cp_book_type_code IN igi_iac_upload_headers.book_type_code%TYPE,
1239: cp_asset_id IN fa_additions.asset_id%TYPE
1240: )
1241: IS
1242: SELECT bk.cost
1243: FROM fa_books bk,

Line 1244: fa_additions ad

1240: )
1241: IS
1242: SELECT bk.cost
1243: FROM fa_books bk,
1244: fa_additions ad
1245: WHERE bk.book_type_code = cp_book_type_code
1246: AND bk.transaction_header_id_out IS NULL
1247: AND ad.asset_id = bk.asset_id
1248: AND ad.asset_id = cp_asset_id;