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_HEADERS

Line 13: cp_file_name IN igi_iac_upload_headers.file_name%type) Is

9: l_error_level number:=FND_LOG.LEVEL_ERROR;
10: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
11:
12: Cursor C_File_Transferred(
13: cp_file_name IN igi_iac_upload_headers.file_name%type) Is
14: Select 'X'
15: From igi_iac_upload_headers
16: Where file_name = cp_file_name
17: and status_flag = 'T';

Line 15: From igi_iac_upload_headers

11:
12: Cursor C_File_Transferred(
13: cp_file_name IN igi_iac_upload_headers.file_name%type) Is
14: Select 'X'
15: From igi_iac_upload_headers
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,

Line 19: Cursor C_Asset_Exists(cp_file_name IN igi_iac_upload_headers.file_name%type,

15: From igi_iac_upload_headers
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,

Line 40: From igi_iac_upload_headers hd,

36: ln.Percentage_Diff,
37: ln.Amount_Diff,
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

Line 48: Cursor C_Excpt_Asset(cp_file_name IN igi_iac_upload_headers.file_name%type,

44: and hd.file_name = cp_file_name
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,

Line 70: From igi_iac_upload_headers hd,

66: ln.Percentage_Diff,
67: ln.Amount_Diff,
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

Line 81: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,

77: and ln.line_num = cp_line_num;
78:
79: -- Bug 3413035 Start
80: Cursor C_Full_Ret_Counter(
81: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,
82: cp_asset_id in fa_books.asset_id%type) Is
83: Select bk.period_counter_fully_retired
84: From fa_books bk
85: Where bk.book_type_code = cp_book_type_code

Line 107: p_book_type_code IN igi_iac_upload_headers.book_type_code%type,

103: End;
104: */
105: Function Last_Period_Counter(
106: p_asset_id IN fa_books.asset_id%type,
107: p_book_type_code IN igi_iac_upload_headers.book_type_code%type,
108: p_dpis_period_counter IN number,
109: p_last_period_counter OUT NOCOPY number) Return Boolean Is
110: l_calendar_type varchar2(40);
111: l_number_per_fiscal_year number;

Line 134: p_file_name IN igi_iac_upload_headers.file_name%type,

130: End;
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;

Line 161: Procedure Delete_Line(p_file_name IN igi_iac_upload_headers.file_name%type,

157: p_upload_record.Comments := C_Asset_Exists_Rec.Comments;
158: End Loop;
159: End;
160:
161: Procedure Delete_Line(p_file_name IN igi_iac_upload_headers.file_name%type,
162: p_asset_id IN igi_iac_upload_lines.asset_id%type,
163: p_line_num IN igi_iac_upload_lines.line_num%type) Is
164: Begin
165: Delete from igi_iac_upload_lines

Line 173: Insert into igi_iac_upload_headers(

169: End;
170:
171: Procedure Insert_Header(p_upload_record IN upload_record) Is
172: Begin
173: Insert into igi_iac_upload_headers(
174: File_Name,
175: Book_Type_Code,
176: Period_Counter,
177: Currency_Code,

Line 247: Update igi_iac_upload_headers set

243: End Insert_Line;
244:
245: Procedure Update_Header(p_upload_record IN upload_record) Is
246: Begin
247: Update igi_iac_upload_headers set
248: Tolerance_Flag = p_upload_record.tolerance_flag,
249: Tolerance_Amount = p_upload_record.tolerance_amount,
250: Tolerance_Percent = p_upload_record.tolerance_percent,
251: Revaluation_Id = p_upload_record.revaluation_id,

Line 260: cp_book_type_code IN igi_iac_upload_headers.book_type_code%type,

256: End Update_Header;
257:
258: Procedure Gross_Up(p_upload_record IN OUT nocopy upload_record) Is
259: Cursor C_Dpis(
260: cp_book_type_code IN igi_iac_upload_headers.book_type_code%type,
261: cp_asset_id IN igi_iac_upload_lines.asset_id%type) Is
262: Select date_placed_in_service, life_in_months
263: From fa_books
264: Where book_type_code = cp_book_type_code

Line 304: p_book_type_code IN igi_iac_upload_headers.book_type_code%type,

300: End Gross_Up;
301:
302: Procedure Update_Duplicate_Assets(
303: p_file_name IN igi_iac_upload_lines.file_name%type,
304: p_book_type_code IN igi_iac_upload_headers.book_type_code%type,
305: p_period_counter IN igi_iac_upload_headers.period_counter%type,
306: p_asset_id IN igi_iac_upload_lines.asset_id%type,
307: p_line_num IN igi_iac_upload_lines.line_num%type,
308: p_message IN igi_iac_upload_lines.exception_message%type) Is

Line 305: p_period_counter IN igi_iac_upload_headers.period_counter%type,

301:
302: Procedure Update_Duplicate_Assets(
303: p_file_name IN igi_iac_upload_lines.file_name%type,
304: p_book_type_code IN igi_iac_upload_headers.book_type_code%type,
305: p_period_counter IN igi_iac_upload_headers.period_counter%type,
306: p_asset_id IN igi_iac_upload_lines.asset_id%type,
307: p_line_num IN igi_iac_upload_lines.line_num%type,
308: p_message IN igi_iac_upload_lines.exception_message%type) Is
309: Cursor C_Dup_Asset_Info(

Line 320: cp_book_type_code IN igi_iac_upload_headers.book_type_code%type,

316: and asset_id = cp_asset_id
317: and line_num <> cp_line_num;
318:
319: Cursor C_Dpis(
320: cp_book_type_code IN igi_iac_upload_headers.book_type_code%type,
321: cp_asset_id IN igi_iac_upload_lines.asset_id%type) Is
322: Select date_placed_in_service, life_in_months
323: From fa_books
324: Where book_type_code = cp_book_type_code

Line 433: Cursor C_Dup_Assets(cp_file_name IN igi_iac_upload_headers.file_name%type,

429: End Check_Tolerances;
430:
431: Procedure Check_Exceptions(p_upload_record IN OUT nocopy upload_record)Is
432:
433: Cursor C_Dup_Assets(cp_file_name IN igi_iac_upload_headers.file_name%type,
434: cp_asset_id IN igi_iac_upload_lines.asset_id%type) Is
435: Select count(*)
436: From igi_iac_upload_lines
437: Where file_name = cp_file_name

Line 441: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,

437: Where file_name = cp_file_name
438: and asset_id = cp_asset_id;
439:
440: Cursor C_Valid_Iac_Cat(
441: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,
442: cp_category_id in igi_iac_upload_lines.category_id%type) Is
443: Select allow_prof_reval_flag
444: From igi_iac_category_books
445: Where book_type_code = cp_book_type_code

Line 449: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is

445: Where book_type_code = cp_book_type_code
446: and category_id = cp_category_id;
447:
448: Cursor C_Max_Period_counter(
449: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is
450: Select max(period_counter)
451: From fa_deprn_summary
452: Where book_type_code = cp_book_type_code;
453:

Line 455: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is

451: From fa_deprn_summary
452: Where book_type_code = cp_book_type_code;
453:
454: Cursor C_Last_Closed_Period(
455: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is
456: Select last_period_counter
457: From fa_book_controls
458: Where book_type_code = cp_book_type_code;
459:

Line 585: p_file_name IN igi_iac_upload_headers.file_name%type) Is

581: and line_num = p_upload_record.line_num;
582: End Update_Line;
583:
584: Procedure Update_Header_Status(
585: p_file_name IN igi_iac_upload_headers.file_name%type) Is
586: Cursor C_Lines(cp_file_name IN igi_iac_upload_headers.file_name%type) Is
587: Select count(*) line_cnt
588: From igi_iac_upload_lines
589: Where file_name = cp_file_name;

Line 586: Cursor C_Lines(cp_file_name IN igi_iac_upload_headers.file_name%type) Is

582: End Update_Line;
583:
584: Procedure Update_Header_Status(
585: p_file_name IN igi_iac_upload_headers.file_name%type) Is
586: Cursor C_Lines(cp_file_name IN igi_iac_upload_headers.file_name%type) Is
587: Select count(*) line_cnt
588: From igi_iac_upload_lines
589: Where file_name = cp_file_name;
590:

Line 591: Cursor C_Errors(cp_file_name IN igi_iac_upload_headers.file_name%type,

587: Select count(*) line_cnt
588: From igi_iac_upload_lines
589: Where file_name = cp_file_name;
590:
591: Cursor C_Errors(cp_file_name IN igi_iac_upload_headers.file_name%type,
592: cp_status_flag IN varchar2) Is
593: Select count(*) exp_cnt
594: From igi_iac_upload_lines
595: Where file_name = cp_file_name

Line 604: Delete from igi_iac_upload_headers where file_name = p_file_name;

600: Open C_Lines(p_file_name);
601: Fetch C_Lines into l_lines;
602: Close C_Lines;
603: If l_lines = 0 Then
604: Delete from igi_iac_upload_headers where file_name = p_file_name;
605: Else
606: Open C_Errors(p_file_name, 'E');
607: Fetch C_Errors into l_errors;
608: Close C_Errors;

Line 610: Update igi_iac_upload_headers

606: Open C_Errors(p_file_name, 'E');
607: Fetch C_Errors into l_errors;
608: Close C_Errors;
609: If l_errors > 0 Then
610: Update igi_iac_upload_headers
611: Set status_flag = 'E'
612: Where file_name = p_file_name;
613: Else
614: l_errors := 0;

Line 619: Update igi_iac_upload_headers

615: Open C_Errors(p_file_name, 'L');
616: Fetch C_Errors into l_errors;
617: Close C_Errors;
618: If l_errors > 0 Then
619: Update igi_iac_upload_headers
620: Set status_flag = 'L'
621: Where file_name = p_file_name;
622: Else
623: Update igi_iac_upload_headers

Line 623: Update igi_iac_upload_headers

619: Update igi_iac_upload_headers
620: Set status_flag = 'L'
621: Where file_name = p_file_name;
622: Else
623: Update igi_iac_upload_headers
624: Set status_flag = 'A'
625: Where file_name = p_file_name;
626: End If;
627: End If;

Line 641: p_file_name IN igi_iac_upload_headers.file_name%type,

637: Raise;
638: End Update_Header_Status;
639:
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,

Line 645: Cursor C_Dup_Count(cp_file_name IN igi_iac_upload_headers.file_name%type,

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(*)
649: From igi_iac_upload_lines

Line 689: P_File_Name IN igi_iac_upload_headers.file_name%type,

685: Raise;
686: End Final_Dup_Asset_Check;
687:
688: Procedure New_File(
689: P_File_Name IN igi_iac_upload_headers.file_name%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,

Line 690: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,

686: End Final_Dup_Asset_Check;
687:
688: Procedure New_File(
689: P_File_Name IN igi_iac_upload_headers.file_name%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,

Line 691: P_Tolerance_Flag IN igi_iac_upload_headers.tolerance_flag%type,

687:
688: Procedure New_File(
689: P_File_Name IN igi_iac_upload_headers.file_name%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,

Line 692: P_Tolerance_Amount IN igi_iac_upload_headers.tolerance_amount%type,

688: Procedure New_File(
689: P_File_Name IN igi_iac_upload_headers.file_name%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

Line 693: P_Tolerance_Percent IN igi_iac_upload_headers.tolerance_percent%type,

689: P_File_Name IN igi_iac_upload_headers.file_name%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:

Line 699: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is

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(
699: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is
700: Select fa.last_period_counter, gl.currency_code
701: From fa_book_controls fa, gl_sets_of_books gl
702: Where book_type_code = cp_book_type_code
703: and gl.set_of_books_id = fa.set_of_books_id;

Line 706: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,

702: Where book_type_code = cp_book_type_code
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,

Line 719: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,

715: and ad.asset_id = bk.asset_id
716: and ad.asset_number = cp_asset_number;
717:
718: Cursor C_Get_Adjustments(
719: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,
720: cp_asset_id in igi_iac_upload_lines.asset_id%type,
721: cp_period_counter in igi_iac_upload_headers.period_counter%type) Is
722: Select nvl(adjusted_cost,0)adjusted_cost
723: From igi_iac_asset_balances

Line 721: cp_period_counter in igi_iac_upload_headers.period_counter%type) Is

717:
718: Cursor C_Get_Adjustments(
719: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,
720: cp_asset_id in igi_iac_upload_lines.asset_id%type,
721: cp_period_counter in igi_iac_upload_headers.period_counter%type) Is
722: Select nvl(adjusted_cost,0)adjusted_cost
723: From igi_iac_asset_balances
724: Where book_type_code = cp_book_type_code
725: and asset_id = cp_asset_id

Line 729: cp_file_name in igi_iac_upload_headers.status_flag%type) Is

725: and asset_id = cp_asset_id
726: and period_counter = cp_period_counter;
727:
728: Cursor C_File_Status(
729: cp_file_name in igi_iac_upload_headers.status_flag%type) Is
730: Select status_flag, period_counter, currency_code
731: From igi_iac_upload_headers
732: Where file_name = cp_file_name;
733:

Line 731: From igi_iac_upload_headers

727:
728: Cursor C_File_Status(
729: cp_file_name in igi_iac_upload_headers.status_flag%type) Is
730: Select status_flag, period_counter, currency_code
731: From igi_iac_upload_headers
732: Where file_name = cp_file_name;
733:
734: Cursor C_Line_Num(
735: cp_file_name in igi_iac_upload_headers.file_name%type) Is

Line 735: cp_file_name in igi_iac_upload_headers.file_name%type) Is

731: From igi_iac_upload_headers
732: Where file_name = cp_file_name;
733:
734: Cursor C_Line_Num(
735: cp_file_name in igi_iac_upload_headers.file_name%type) Is
736: Select nvl(max(line_num),0) + 1 Line_Num
737: From igi_iac_upload_lines
738: Where file_name = cp_file_name;
739:

Line 740: l_status_flag igi_iac_upload_headers.status_flag%type;

736: Select nvl(max(line_num),0) + 1 Line_Num
737: From igi_iac_upload_lines
738: Where file_name = cp_file_name;
739:
740: l_status_flag igi_iac_upload_headers.status_flag%type;
741: l_period_counter igi_iac_upload_headers.period_counter%type;
742: l_currency_code igi_iac_upload_headers.currency_code%type;
743: l_upload_record Upload_Record;
744: E_Non_Iac_Book exception;

Line 741: l_period_counter igi_iac_upload_headers.period_counter%type;

737: From igi_iac_upload_lines
738: Where file_name = cp_file_name;
739:
740: l_status_flag igi_iac_upload_headers.status_flag%type;
741: l_period_counter igi_iac_upload_headers.period_counter%type;
742: l_currency_code igi_iac_upload_headers.currency_code%type;
743: l_upload_record Upload_Record;
744: E_Non_Iac_Book exception;
745: E_Igi_Tol_Yes exception;

Line 742: l_currency_code igi_iac_upload_headers.currency_code%type;

738: Where file_name = cp_file_name;
739:
740: l_status_flag igi_iac_upload_headers.status_flag%type;
741: l_period_counter igi_iac_upload_headers.period_counter%type;
742: l_currency_code igi_iac_upload_headers.currency_code%type;
743: l_upload_record Upload_Record;
744: E_Non_Iac_Book exception;
745: E_Igi_Tol_Yes exception;
746: E_Igi_Tol_No exception;

Line 858: P_File_Name IN igi_iac_upload_headers.file_name%type,

854: Fnd_Message.Raise_Error;
855: End New_File;
856:
857: Procedure Tol_Errors(
858: P_File_Name IN igi_iac_upload_headers.file_name%type,
859: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
860: P_Period IN fa_deprn_periods.period_name%type,
861: P_Currency IN igi_iac_upload_headers.currency_code%type,
862: P_Status IN igi_iac_upload_headers.status_flag%type,

Line 859: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,

855: End New_File;
856:
857: Procedure Tol_Errors(
858: P_File_Name IN igi_iac_upload_headers.file_name%type,
859: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
860: P_Period IN fa_deprn_periods.period_name%type,
861: P_Currency IN igi_iac_upload_headers.currency_code%type,
862: P_Status IN igi_iac_upload_headers.status_flag%type,
863: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,

Line 861: P_Currency IN igi_iac_upload_headers.currency_code%type,

857: Procedure Tol_Errors(
858: P_File_Name IN igi_iac_upload_headers.file_name%type,
859: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
860: P_Period IN fa_deprn_periods.period_name%type,
861: P_Currency IN igi_iac_upload_headers.currency_code%type,
862: P_Status IN igi_iac_upload_headers.status_flag%type,
863: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
864: P_Asset_Number IN fa_additions.asset_number%type,
865: P_Asset_Desc IN fa_additions.description%type,

Line 862: P_Status IN igi_iac_upload_headers.status_flag%type,

858: P_File_Name IN igi_iac_upload_headers.file_name%type,
859: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
860: P_Period IN fa_deprn_periods.period_name%type,
861: P_Currency IN igi_iac_upload_headers.currency_code%type,
862: P_Status IN igi_iac_upload_headers.status_flag%type,
863: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
864: P_Asset_Number IN fa_additions.asset_number%type,
865: P_Asset_Desc IN fa_additions.description%type,
866: P_Cat_Desc IN fa_categories.description%type,

Line 962: P_File_Name IN igi_iac_upload_headers.file_name%type,

958: Fnd_Message.Raise_Error;
959: End Tol_Errors;
960:
961: Procedure Excpt_Errors(
962: P_File_Name IN igi_iac_upload_headers.file_name%type,
963: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
964: P_Period IN fa_deprn_periods.period_name%type,
965: P_Currency IN igi_iac_upload_headers.currency_code%type,
966: P_Status IN igi_iac_upload_headers.status_flag%type,

Line 963: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,

959: End Tol_Errors;
960:
961: Procedure Excpt_Errors(
962: P_File_Name IN igi_iac_upload_headers.file_name%type,
963: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
964: P_Period IN fa_deprn_periods.period_name%type,
965: P_Currency IN igi_iac_upload_headers.currency_code%type,
966: P_Status IN igi_iac_upload_headers.status_flag%type,
967: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,

Line 965: P_Currency IN igi_iac_upload_headers.currency_code%type,

961: Procedure Excpt_Errors(
962: P_File_Name IN igi_iac_upload_headers.file_name%type,
963: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
964: P_Period IN fa_deprn_periods.period_name%type,
965: P_Currency IN igi_iac_upload_headers.currency_code%type,
966: P_Status IN igi_iac_upload_headers.status_flag%type,
967: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
968: P_Asset_Number IN fa_additions.asset_number%type,
969: P_Line_Num IN igi_iac_upload_lines.line_num%type,

Line 966: P_Status IN igi_iac_upload_headers.status_flag%type,

962: P_File_Name IN igi_iac_upload_headers.file_name%type,
963: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
964: P_Period IN fa_deprn_periods.period_name%type,
965: P_Currency IN igi_iac_upload_headers.currency_code%type,
966: P_Status IN igi_iac_upload_headers.status_flag%type,
967: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
968: P_Asset_Number IN fa_additions.asset_number%type,
969: P_Line_Num IN igi_iac_upload_lines.line_num%type,
970: P_Asset_Desc IN fa_additions.description%type,

Line 979: l_dummy igi_iac_upload_headers.status_flag%type;

975: -- Bug 3391921 Start
976: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is
977: -- Bug 3391921 End
978:
979: l_dummy igi_iac_upload_headers.status_flag%type;
980: l_upload_record upload_record;
981: l_upd_line_flag varchar2(1) := 'Y';
982: Begin
983: If not igi_gen.is_req_installed('IAC') Then

Line 1090: P_File_Name IN igi_iac_upload_headers.file_name%type,

1086: Fnd_Message.Raise_Error;
1087: End Excpt_Errors;
1088:
1089: Procedure Valid_Assets(
1090: P_File_Name IN igi_iac_upload_headers.file_name%type,
1091: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
1092: P_Period IN fa_deprn_periods.period_name%type,
1093: P_Currency IN igi_iac_upload_headers.currency_code%type,
1094: P_Status IN igi_iac_upload_headers.status_flag%type,

Line 1091: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,

1087: End Excpt_Errors;
1088:
1089: Procedure Valid_Assets(
1090: P_File_Name IN igi_iac_upload_headers.file_name%type,
1091: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
1092: P_Period IN fa_deprn_periods.period_name%type,
1093: P_Currency IN igi_iac_upload_headers.currency_code%type,
1094: P_Status IN igi_iac_upload_headers.status_flag%type,
1095: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,

Line 1093: P_Currency IN igi_iac_upload_headers.currency_code%type,

1089: Procedure Valid_Assets(
1090: P_File_Name IN igi_iac_upload_headers.file_name%type,
1091: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
1092: P_Period IN fa_deprn_periods.period_name%type,
1093: P_Currency IN igi_iac_upload_headers.currency_code%type,
1094: P_Status IN igi_iac_upload_headers.status_flag%type,
1095: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
1096: P_Asset_Number IN fa_additions.asset_number%type,
1097: P_Asset_Desc IN fa_additions.description%type,

Line 1094: P_Status IN igi_iac_upload_headers.status_flag%type,

1090: P_File_Name IN igi_iac_upload_headers.file_name%type,
1091: P_Book_Type_Code IN igi_iac_upload_headers.book_type_code%type,
1092: P_Period IN fa_deprn_periods.period_name%type,
1093: P_Currency IN igi_iac_upload_headers.currency_code%type,
1094: P_Status IN igi_iac_upload_headers.status_flag%type,
1095: P_Hdr_Action IN fnd_lookup_values.lookup_code%type,
1096: P_Asset_Number IN fa_additions.asset_number%type,
1097: P_Asset_Desc IN fa_additions.description%type,
1098: P_Cat_Desc IN fa_categories.description%type,

Line 1122: Delete from igi_iac_upload_headers where file_name = p_file_name;

1118: End If;
1119: Close C_File_Transferred;
1120:
1121: If p_hdr_action = 'Y' Then
1122: Delete from igi_iac_upload_headers where file_name = p_file_name;
1123: Delete from igi_iac_upload_lines where file_name = p_file_name;
1124: Else -- N
1125: Assign_Values_To_Rec(l_upload_record, p_file_name, p_asset_number);
1126: -- Bug 3391921 Start

Line 1168: p_file_name IN igi_iac_upload_headers.file_name%type,

1164:
1165: Procedure Transfer_Data(
1166: errbuf OUT NOCOPY varchar2,
1167: retcode OUT NOCOPY number,
1168: p_file_name IN igi_iac_upload_headers.file_name%type,
1169: p_preview_flag IN varchar2) Is
1170:
1171: Cursor C_Upload_Hdr(
1172: cp_file_name in igi_iac_upload_headers.file_name%type) Is

Line 1172: cp_file_name in igi_iac_upload_headers.file_name%type) Is

1168: p_file_name IN igi_iac_upload_headers.file_name%type,
1169: p_preview_flag IN varchar2) Is
1170:
1171: Cursor C_Upload_Hdr(
1172: cp_file_name in igi_iac_upload_headers.file_name%type) Is
1173: Select * from igi_iac_upload_headers
1174: Where file_name = cp_file_name;
1175:
1176: Cursor C_Upload_Lines(

Line 1173: Select * from igi_iac_upload_headers

1169: p_preview_flag IN varchar2) Is
1170:
1171: Cursor C_Upload_Hdr(
1172: cp_file_name in igi_iac_upload_headers.file_name%type) Is
1173: Select * from igi_iac_upload_headers
1174: Where file_name = cp_file_name;
1175:
1176: Cursor C_Upload_Lines(
1177: cp_file_name in igi_iac_upload_headers.file_name%type) Is

Line 1177: cp_file_name in igi_iac_upload_headers.file_name%type) Is

1173: Select * from igi_iac_upload_headers
1174: Where file_name = cp_file_name;
1175:
1176: Cursor C_Upload_Lines(
1177: cp_file_name in igi_iac_upload_headers.file_name%type) Is
1178: Select * from igi_iac_upload_lines
1179: Where file_name = cp_file_name;
1180:
1181: Cursor C_Categories(

Line 1182: cp_file_name in igi_iac_upload_headers.file_name%type) Is

1178: Select * from igi_iac_upload_lines
1179: Where file_name = cp_file_name;
1180:
1181: Cursor C_Categories(
1182: cp_file_name in igi_iac_upload_headers.file_name%type) Is
1183: Select distinct category_id from igi_iac_upload_lines
1184: where file_name = cp_file_name;
1185:
1186: Cursor C_Max_Period_counter(

Line 1187: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is

1183: Select distinct category_id from igi_iac_upload_lines
1184: where file_name = cp_file_name;
1185:
1186: Cursor C_Max_Period_counter(
1187: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is
1188: Select max(period_counter) max_period_counter
1189: From fa_deprn_summary
1190: Where book_type_code = cp_book_type_code;
1191:

Line 1193: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is

1189: From fa_deprn_summary
1190: Where book_type_code = cp_book_type_code;
1191:
1192: Cursor C_Last_Closed_Period(
1193: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is
1194: Select last_period_counter
1195: From fa_book_controls
1196: Where book_type_code = cp_book_type_code;
1197:

Line 1199: CURSOR c_preview_exists(cp_book_type_code igi_iac_upload_headers.book_type_code%TYPE)

1195: From fa_book_controls
1196: Where book_type_code = cp_book_type_code;
1197:
1198: -- bug 3443410, start 1
1199: CURSOR c_preview_exists(cp_book_type_code igi_iac_upload_headers.book_type_code%TYPE)
1200: IS
1201: SELECT irar.asset_id,
1202: fa.asset_number,
1203: irar.selected_for_reval_flag,

Line 1224: CURSOR C_FA_Asset_Cost(cp_book_type_code IN igi_iac_upload_headers.book_type_code%TYPE,

1220: -- bug 3443410, end 1
1221:
1222: -- bug 3536362, start 1
1223: -- cursor to retrieve the historic portion of the cost of an asset
1224: CURSOR C_FA_Asset_Cost(cp_book_type_code IN igi_iac_upload_headers.book_type_code%TYPE,
1225: cp_asset_id IN fa_additions.asset_id%TYPE
1226: )
1227: IS
1228: SELECT bk.cost

Line 1237: CURSOR C_IAC_Asset_Cost(cp_book_type_code IN igi_iac_upload_headers.book_type_code%TYPE,

1233: AND ad.asset_id = bk.asset_id
1234: AND ad.asset_id = cp_asset_id;
1235:
1236: -- cursor to retrieve the iac portion of the cost of an asset
1237: CURSOR C_IAC_Asset_Cost(cp_book_type_code IN igi_iac_upload_headers.book_type_code%TYPE,
1238: cp_asset_id IN igi_iac_upload_lines.asset_id%TYPE,
1239: cp_period_counter IN igi_iac_upload_headers.period_counter%TYPE
1240: )
1241: IS

Line 1239: cp_period_counter IN igi_iac_upload_headers.period_counter%TYPE

1235:
1236: -- cursor to retrieve the iac portion of the cost of an asset
1237: CURSOR C_IAC_Asset_Cost(cp_book_type_code IN igi_iac_upload_headers.book_type_code%TYPE,
1238: cp_asset_id IN igi_iac_upload_lines.asset_id%TYPE,
1239: cp_period_counter IN igi_iac_upload_headers.period_counter%TYPE
1240: )
1241: IS
1242: SELECT nvl(adjusted_cost,0) adjusted_cost
1243: FROM igi_iac_asset_balances

Line 1458: Update igi_iac_upload_headers

1454: l_asset_count := l_asset_count + 1;
1455: End If;
1456: End Loop ;
1457:
1458: Update igi_iac_upload_headers
1459: Set status_flag = 'T', revaluation_id = l_reval_id
1460: Where file_name = p_file_name;
1461:
1462: If sql%notfound then