DBA Data[Home] [Help]

APPS.IGI_IAC_WEBADI_PKG dependencies on IGI_IAC_UPLOAD_HEADERS

Line 4: File_Name igi_iac_upload_headers.file_name%type,

1: PACKAGE IGI_IAC_WEBADI_PKG AUTHID CURRENT_USER 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,

Line 5: Book_Type_Code igi_iac_upload_headers.book_type_code%type,

1: PACKAGE IGI_IAC_WEBADI_PKG AUTHID CURRENT_USER 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,

Line 6: Period_Counter igi_iac_upload_headers.period_counter%type,

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,

Line 7: Currency_Code igi_iac_upload_headers.currency_code%type,

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,

Line 8: Hdr_Status_Flag igi_iac_upload_headers.status_flag%type,

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,

Line 9: Tolerance_Flag igi_iac_upload_headers.tolerance_flag%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,

Line 10: Tolerance_Amount igi_iac_upload_headers.tolerance_amount%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,

Line 11: Tolerance_Percent igi_iac_upload_headers.tolerance_percent%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,

Line 12: Revaluation_Id igi_iac_upload_headers.revaluation_id%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,

Line 27: P_File_Name IN igi_iac_upload_headers.file_name%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,

Line 28: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%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,

Line 29: P_Tolerance_Flag IN igi_iac_upload_headers.tolerance_flag%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,

Line 30: P_Tolerance_Amount IN igi_iac_upload_headers.tolerance_amount%type,

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 );

Line 31: P_Tolerance_Percent IN igi_iac_upload_headers.tolerance_percent%type,

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:

Line 37: P_File_Name IN igi_iac_upload_headers.file_name%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,

Line 38: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%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,

Line 40: P_Currency IN igi_iac_upload_headers.currency_code%type,

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,

Line 41: P_Status IN igi_iac_upload_headers.status_flag%type,

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,

Line 58: P_File_Name IN igi_iac_upload_headers.file_name%type,

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,

Line 59: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%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,

Line 61: P_Currency IN igi_iac_upload_headers.currency_code%type,

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,

Line 62: P_Status IN igi_iac_upload_headers.status_flag%type,

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,

Line 76: P_File_Name IN igi_iac_upload_headers.file_name%type,

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,

Line 77: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%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,

Line 79: P_Currency IN igi_iac_upload_headers.currency_code%type,

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,

Line 80: P_Status IN igi_iac_upload_headers.status_flag%type,

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,

Line 95: p_file_name IN igi_iac_upload_headers.file_name%type,

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;