[Home] [Help]
PACKAGE: APPS.IGI_IAC_WEBADI_PKG
Source
1 PACKAGE IGI_IAC_WEBADI_PKG AS
2 -- $Header: igiiasas.pls 120.3.12000000.1 2007/08/01 16:18:59 npandya noship $
3 Type Upload_Record is Record (
4 File_Name igi_iac_upload_headers.file_name%type,
5 Book_Type_Code igi_iac_upload_headers.book_type_code%type,
6 Period_Counter igi_iac_upload_headers.period_counter%type,
7 Currency_Code igi_iac_upload_headers.currency_code%type,
8 Hdr_Status_Flag igi_iac_upload_headers.status_flag%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,
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(
27 P_File_Name IN igi_iac_upload_headers.file_name%type,
28 P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%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,
38 P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
39 P_Period IN fa_deprn_periods.period_name%type,
40 P_Currency IN igi_iac_upload_headers.currency_code%type,
41 P_Status IN igi_iac_upload_headers.status_flag%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,
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,
59 P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
60 P_Period IN fa_deprn_periods.period_name%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,
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,
77 P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
78 P_Period IN fa_deprn_periods.period_name%type,
79 P_Currency IN igi_iac_upload_headers.currency_code%type,
80 P_Status IN igi_iac_upload_headers.status_flag%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 );
90 -- Bug 3391921 End
91
92 Procedure Transfer_Data(
93 errbuf OUT NOCOPY varchar2,
94 retcode OUT NOCOPY number,
95 p_file_name IN igi_iac_upload_headers.file_name%type,
96 p_preview_flag IN varchar2);
97 END IGI_IAC_WEBADI_PKG;