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 IGI_IAC_UPLOAD_LINES

Line 13: Asset_Id igi_iac_upload_lines.asset_id%type,

9: Tolerance_Flag igi_iac_upload_headers.tolerance_flag%type,
10: Tolerance_Amount igi_iac_upload_headers.tolerance_amount%type,
11: Tolerance_Percent igi_iac_upload_headers.tolerance_percent%type,
12: Revaluation_Id igi_iac_upload_headers.revaluation_id%type,
13: Asset_Id igi_iac_upload_lines.asset_id%type,
14: Line_Num igi_iac_upload_lines.line_num%type,
15: Category_Id igi_iac_upload_lines.category_id%type,
16: Original_Cost igi_iac_upload_lines.original_cost%type,
17: New_Cost igi_iac_upload_lines.new_cost%type,

Line 14: Line_Num igi_iac_upload_lines.line_num%type,

10: Tolerance_Amount igi_iac_upload_headers.tolerance_amount%type,
11: Tolerance_Percent igi_iac_upload_headers.tolerance_percent%type,
12: Revaluation_Id igi_iac_upload_headers.revaluation_id%type,
13: Asset_Id igi_iac_upload_lines.asset_id%type,
14: Line_Num igi_iac_upload_lines.line_num%type,
15: Category_Id igi_iac_upload_lines.category_id%type,
16: Original_Cost igi_iac_upload_lines.original_cost%type,
17: New_Cost igi_iac_upload_lines.new_cost%type,
18: Line_Status_Flag igi_iac_upload_lines.status_flag%type,

Line 15: Category_Id igi_iac_upload_lines.category_id%type,

11: Tolerance_Percent igi_iac_upload_headers.tolerance_percent%type,
12: Revaluation_Id igi_iac_upload_headers.revaluation_id%type,
13: Asset_Id igi_iac_upload_lines.asset_id%type,
14: Line_Num igi_iac_upload_lines.line_num%type,
15: Category_Id igi_iac_upload_lines.category_id%type,
16: Original_Cost igi_iac_upload_lines.original_cost%type,
17: New_Cost igi_iac_upload_lines.new_cost%type,
18: Line_Status_Flag igi_iac_upload_lines.status_flag%type,
19: Gross_Flag igi_iac_upload_lines.gross_flag%type,

Line 16: Original_Cost igi_iac_upload_lines.original_cost%type,

12: Revaluation_Id igi_iac_upload_headers.revaluation_id%type,
13: Asset_Id igi_iac_upload_lines.asset_id%type,
14: Line_Num igi_iac_upload_lines.line_num%type,
15: Category_Id igi_iac_upload_lines.category_id%type,
16: Original_Cost igi_iac_upload_lines.original_cost%type,
17: New_Cost igi_iac_upload_lines.new_cost%type,
18: Line_Status_Flag igi_iac_upload_lines.status_flag%type,
19: Gross_Flag igi_iac_upload_lines.gross_flag%type,
20: Percentage_Diff igi_iac_upload_lines.percentage_diff%type,

Line 17: New_Cost igi_iac_upload_lines.new_cost%type,

13: Asset_Id igi_iac_upload_lines.asset_id%type,
14: Line_Num igi_iac_upload_lines.line_num%type,
15: Category_Id igi_iac_upload_lines.category_id%type,
16: Original_Cost igi_iac_upload_lines.original_cost%type,
17: New_Cost igi_iac_upload_lines.new_cost%type,
18: Line_Status_Flag igi_iac_upload_lines.status_flag%type,
19: Gross_Flag igi_iac_upload_lines.gross_flag%type,
20: Percentage_Diff igi_iac_upload_lines.percentage_diff%type,
21: Amount_Diff igi_iac_upload_lines.amount_diff%type,

Line 18: Line_Status_Flag igi_iac_upload_lines.status_flag%type,

14: Line_Num igi_iac_upload_lines.line_num%type,
15: Category_Id igi_iac_upload_lines.category_id%type,
16: Original_Cost igi_iac_upload_lines.original_cost%type,
17: New_Cost igi_iac_upload_lines.new_cost%type,
18: Line_Status_Flag igi_iac_upload_lines.status_flag%type,
19: Gross_Flag igi_iac_upload_lines.gross_flag%type,
20: Percentage_Diff igi_iac_upload_lines.percentage_diff%type,
21: Amount_Diff igi_iac_upload_lines.amount_diff%type,
22: Comments igi_iac_upload_lines.comments%type,

Line 19: Gross_Flag igi_iac_upload_lines.gross_flag%type,

15: Category_Id igi_iac_upload_lines.category_id%type,
16: Original_Cost igi_iac_upload_lines.original_cost%type,
17: New_Cost igi_iac_upload_lines.new_cost%type,
18: Line_Status_Flag igi_iac_upload_lines.status_flag%type,
19: Gross_Flag igi_iac_upload_lines.gross_flag%type,
20: Percentage_Diff igi_iac_upload_lines.percentage_diff%type,
21: Amount_Diff igi_iac_upload_lines.amount_diff%type,
22: Comments igi_iac_upload_lines.comments%type,
23: Exception_Message igi_iac_upload_lines.exception_message%type,

Line 20: Percentage_Diff igi_iac_upload_lines.percentage_diff%type,

16: Original_Cost igi_iac_upload_lines.original_cost%type,
17: New_Cost igi_iac_upload_lines.new_cost%type,
18: Line_Status_Flag igi_iac_upload_lines.status_flag%type,
19: Gross_Flag igi_iac_upload_lines.gross_flag%type,
20: Percentage_Diff igi_iac_upload_lines.percentage_diff%type,
21: Amount_Diff igi_iac_upload_lines.amount_diff%type,
22: Comments igi_iac_upload_lines.comments%type,
23: Exception_Message igi_iac_upload_lines.exception_message%type,
24: Period_Counter_Fully_Retired fa_books.period_counter_fully_retired%type);

Line 21: Amount_Diff igi_iac_upload_lines.amount_diff%type,

17: New_Cost igi_iac_upload_lines.new_cost%type,
18: Line_Status_Flag igi_iac_upload_lines.status_flag%type,
19: Gross_Flag igi_iac_upload_lines.gross_flag%type,
20: Percentage_Diff igi_iac_upload_lines.percentage_diff%type,
21: Amount_Diff igi_iac_upload_lines.amount_diff%type,
22: Comments igi_iac_upload_lines.comments%type,
23: Exception_Message igi_iac_upload_lines.exception_message%type,
24: Period_Counter_Fully_Retired fa_books.period_counter_fully_retired%type);
25:

Line 22: Comments igi_iac_upload_lines.comments%type,

18: Line_Status_Flag igi_iac_upload_lines.status_flag%type,
19: Gross_Flag igi_iac_upload_lines.gross_flag%type,
20: Percentage_Diff igi_iac_upload_lines.percentage_diff%type,
21: Amount_Diff igi_iac_upload_lines.amount_diff%type,
22: Comments igi_iac_upload_lines.comments%type,
23: Exception_Message igi_iac_upload_lines.exception_message%type,
24: Period_Counter_Fully_Retired fa_books.period_counter_fully_retired%type);
25:
26: Procedure New_File(

Line 23: Exception_Message igi_iac_upload_lines.exception_message%type,

19: Gross_Flag igi_iac_upload_lines.gross_flag%type,
20: Percentage_Diff igi_iac_upload_lines.percentage_diff%type,
21: Amount_Diff igi_iac_upload_lines.amount_diff%type,
22: Comments igi_iac_upload_lines.comments%type,
23: Exception_Message igi_iac_upload_lines.exception_message%type,
24: Period_Counter_Fully_Retired fa_books.period_counter_fully_retired%type);
25:
26: Procedure New_File(
27: P_File_Name IN igi_iac_upload_headers.file_name%type,

Line 33: P_New_Cost IN igi_iac_upload_lines.new_cost%type,

29: P_Tolerance_Flag IN igi_iac_upload_headers.tolerance_flag%type,
30: P_Tolerance_Amount IN igi_iac_upload_headers.tolerance_amount%type,
31: P_Tolerance_Percent IN igi_iac_upload_headers.tolerance_percent%type,
32: P_Asset_Number IN fa_additions.asset_number%type,
33: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
34: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type );
35:
36: Procedure Tol_Errors(
37: P_File_Name IN igi_iac_upload_headers.file_name%type,

Line 34: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type );

30: P_Tolerance_Amount IN igi_iac_upload_headers.tolerance_amount%type,
31: P_Tolerance_Percent IN igi_iac_upload_headers.tolerance_percent%type,
32: P_Asset_Number IN fa_additions.asset_number%type,
33: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
34: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type );
35:
36: Procedure Tol_Errors(
37: P_File_Name IN igi_iac_upload_headers.file_name%type,
38: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,

Line 46: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,

42: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
43: P_Asset_Number IN fa_additions.asset_number%type,
44: P_Asset_Desc IN fa_additions.description%type,
45: P_Cat_Desc IN fa_categories.description%type,
46: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,
47: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
48: P_Amt_Diff IN igi_iac_upload_lines.amount_diff%type,
49: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,
50: P_Message IN igi_iac_upload_lines.exception_message%type,

Line 47: P_New_Cost IN igi_iac_upload_lines.new_cost%type,

43: P_Asset_Number IN fa_additions.asset_number%type,
44: P_Asset_Desc IN fa_additions.description%type,
45: P_Cat_Desc IN fa_categories.description%type,
46: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,
47: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
48: P_Amt_Diff IN igi_iac_upload_lines.amount_diff%type,
49: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,
50: P_Message IN igi_iac_upload_lines.exception_message%type,
51: P_Line_Action IN fnd_lookup_values.lookup_code%type,

Line 48: P_Amt_Diff IN igi_iac_upload_lines.amount_diff%type,

44: P_Asset_Desc IN fa_additions.description%type,
45: P_Cat_Desc IN fa_categories.description%type,
46: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,
47: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
48: P_Amt_Diff IN igi_iac_upload_lines.amount_diff%type,
49: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,
50: P_Message IN igi_iac_upload_lines.exception_message%type,
51: P_Line_Action IN fnd_lookup_values.lookup_code%type,
52: P_Comments IN igi_iac_upload_lines.comments%type,

Line 49: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,

45: P_Cat_Desc IN fa_categories.description%type,
46: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,
47: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
48: P_Amt_Diff IN igi_iac_upload_lines.amount_diff%type,
49: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,
50: P_Message IN igi_iac_upload_lines.exception_message%type,
51: P_Line_Action IN fnd_lookup_values.lookup_code%type,
52: P_Comments IN igi_iac_upload_lines.comments%type,
53: -- Bug 3391921 Start

Line 50: P_Message IN igi_iac_upload_lines.exception_message%type,

46: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,
47: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
48: P_Amt_Diff IN igi_iac_upload_lines.amount_diff%type,
49: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,
50: P_Message IN igi_iac_upload_lines.exception_message%type,
51: P_Line_Action IN fnd_lookup_values.lookup_code%type,
52: P_Comments IN igi_iac_upload_lines.comments%type,
53: -- Bug 3391921 Start
54: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type);

Line 52: P_Comments IN igi_iac_upload_lines.comments%type,

48: P_Amt_Diff IN igi_iac_upload_lines.amount_diff%type,
49: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,
50: P_Message IN igi_iac_upload_lines.exception_message%type,
51: P_Line_Action IN fnd_lookup_values.lookup_code%type,
52: P_Comments IN igi_iac_upload_lines.comments%type,
53: -- Bug 3391921 Start
54: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type);
55: -- Bug 3391921 End
56:

Line 54: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type);

50: P_Message IN igi_iac_upload_lines.exception_message%type,
51: P_Line_Action IN fnd_lookup_values.lookup_code%type,
52: P_Comments IN igi_iac_upload_lines.comments%type,
53: -- Bug 3391921 Start
54: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type);
55: -- Bug 3391921 End
56:
57: Procedure Excpt_Errors(
58: P_File_Name IN igi_iac_upload_headers.file_name%type,

Line 65: P_Line_Num IN igi_iac_upload_lines.line_num%type,

61: P_Currency IN igi_iac_upload_headers.currency_code%type,
62: P_Status IN igi_iac_upload_headers.status_flag%type,
63: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
64: P_Asset_Number IN fa_additions.asset_number%type,
65: P_Line_Num IN igi_iac_upload_lines.line_num%type,
66: P_Asset_Desc IN fa_additions.description%type,
67: P_Cat_Desc IN fa_categories.description%type,
68: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
69: P_Message IN igi_iac_upload_lines.exception_message%type,

Line 68: P_New_Cost IN igi_iac_upload_lines.new_cost%type,

64: P_Asset_Number IN fa_additions.asset_number%type,
65: P_Line_Num IN igi_iac_upload_lines.line_num%type,
66: P_Asset_Desc IN fa_additions.description%type,
67: P_Cat_Desc IN fa_categories.description%type,
68: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
69: P_Message IN igi_iac_upload_lines.exception_message%type,
70: P_Line_Action IN fnd_lookup_values.lookup_code%type,
71: -- Bug 3391921 Start
72: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type);

Line 69: P_Message IN igi_iac_upload_lines.exception_message%type,

65: P_Line_Num IN igi_iac_upload_lines.line_num%type,
66: P_Asset_Desc IN fa_additions.description%type,
67: P_Cat_Desc IN fa_categories.description%type,
68: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
69: P_Message IN igi_iac_upload_lines.exception_message%type,
70: P_Line_Action IN fnd_lookup_values.lookup_code%type,
71: -- Bug 3391921 Start
72: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type);
73: -- Bug 3391921 End

Line 72: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type);

68: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
69: P_Message IN igi_iac_upload_lines.exception_message%type,
70: P_Line_Action IN fnd_lookup_values.lookup_code%type,
71: -- Bug 3391921 Start
72: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type);
73: -- Bug 3391921 End
74:
75: Procedure Valid_Assets(
76: P_File_Name IN igi_iac_upload_headers.file_name%type,

Line 85: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,

81: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
82: P_Asset_Number IN fa_additions.asset_number%type,
83: P_Asset_Desc IN fa_additions.description%type,
84: P_Cat_Desc IN fa_categories.description%type,
85: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,
86: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
87: P_Line_Action IN fnd_lookup_values.lookup_code%type,
88: -- Bug 3391921 Start
89: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type );

Line 86: P_New_Cost IN igi_iac_upload_lines.new_cost%type,

82: P_Asset_Number IN fa_additions.asset_number%type,
83: P_Asset_Desc IN fa_additions.description%type,
84: P_Cat_Desc IN fa_categories.description%type,
85: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,
86: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
87: P_Line_Action IN fnd_lookup_values.lookup_code%type,
88: -- Bug 3391921 Start
89: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type );
90: -- Bug 3391921 End

Line 89: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type );

85: P_Original_Cost IN igi_iac_upload_lines.original_cost%type,
86: P_New_Cost IN igi_iac_upload_lines.new_cost%type,
87: P_Line_Action IN fnd_lookup_values.lookup_code%type,
88: -- Bug 3391921 Start
89: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type );
90: -- Bug 3391921 End
91:
92: Procedure Transfer_Data(
93: errbuf OUT NOCOPY varchar2,