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 41: igi_iac_upload_lines ln,

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
45: and ln.file_name = hd.file_name

Line 50: cp_line_num IN igi_iac_upload_lines.line_num%type) Is

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,
54: hd.Status_Flag Hdr_Status_Flag,

Line 71: igi_iac_upload_lines ln,

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
75: and ln.file_name = hd.file_name

Line 162: p_asset_id IN igi_iac_upload_lines.asset_id%type,

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
166: Where file_name = p_file_name

Line 163: p_line_num IN igi_iac_upload_lines.line_num%type) Is

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
166: Where file_name = p_file_name
167: and asset_id = p_asset_id

Line 165: Delete from igi_iac_upload_lines

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
166: Where file_name = p_file_name
167: and asset_id = p_asset_id
168: and line_num = p_line_num;
169: End;

Line 207: Insert into igi_iac_upload_lines(

203: End Insert_Header;
204:
205: Procedure Insert_Line(p_upload_record IN upload_record) Is
206: Begin
207: Insert into igi_iac_upload_lines(
208: File_Name,
209: Asset_Id,
210: Line_Num,
211: Category_Id,

Line 261: cp_asset_id IN igi_iac_upload_lines.asset_id%type) Is

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
265: and asset_id = cp_asset_id

Line 303: p_file_name IN igi_iac_upload_lines.file_name%type,

299: End If;
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,

Line 306: p_asset_id IN igi_iac_upload_lines.asset_id%type,

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(
310: cp_file_name IN igi_iac_upload_lines.file_name%type,

Line 307: p_line_num IN igi_iac_upload_lines.line_num%type,

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(
310: cp_file_name IN igi_iac_upload_lines.file_name%type,
311: cp_asset_id IN igi_iac_upload_lines.asset_id%type,

Line 308: p_message IN igi_iac_upload_lines.exception_message%type) Is

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(
310: cp_file_name IN igi_iac_upload_lines.file_name%type,
311: cp_asset_id IN igi_iac_upload_lines.asset_id%type,
312: cp_line_num IN igi_iac_upload_lines.line_num%type) IS

Line 310: cp_file_name IN igi_iac_upload_lines.file_name%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(
310: cp_file_name IN igi_iac_upload_lines.file_name%type,
311: cp_asset_id IN igi_iac_upload_lines.asset_id%type,
312: cp_line_num IN igi_iac_upload_lines.line_num%type) IS
313: Select Line_Num, New_Cost, Gross_Flag, Status_Flag
314: From igi_iac_upload_lines

Line 311: cp_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(
310: cp_file_name IN igi_iac_upload_lines.file_name%type,
311: cp_asset_id IN igi_iac_upload_lines.asset_id%type,
312: cp_line_num IN igi_iac_upload_lines.line_num%type) IS
313: Select Line_Num, New_Cost, Gross_Flag, Status_Flag
314: From igi_iac_upload_lines
315: Where file_name = cp_file_name

Line 312: cp_line_num IN igi_iac_upload_lines.line_num%type) IS

308: p_message IN igi_iac_upload_lines.exception_message%type) Is
309: Cursor C_Dup_Asset_Info(
310: cp_file_name IN igi_iac_upload_lines.file_name%type,
311: cp_asset_id IN igi_iac_upload_lines.asset_id%type,
312: cp_line_num IN igi_iac_upload_lines.line_num%type) IS
313: Select Line_Num, New_Cost, Gross_Flag, Status_Flag
314: From igi_iac_upload_lines
315: Where file_name = cp_file_name
316: and asset_id = cp_asset_id

Line 314: From igi_iac_upload_lines

310: cp_file_name IN igi_iac_upload_lines.file_name%type,
311: cp_asset_id IN igi_iac_upload_lines.asset_id%type,
312: cp_line_num IN igi_iac_upload_lines.line_num%type) IS
313: Select Line_Num, New_Cost, Gross_Flag, Status_Flag
314: From igi_iac_upload_lines
315: Where file_name = cp_file_name
316: and asset_id = cp_asset_id
317: and line_num <> cp_line_num;
318:

Line 321: cp_asset_id IN igi_iac_upload_lines.asset_id%type) Is

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
325: and asset_id = cp_asset_id

Line 365: Update igi_iac_upload_lines

361: C_Dup_Asset_Info_Rec.new_cost,p_book_type_code) Then
362: null;
363: End If;
364: End If;
365: Update igi_iac_upload_lines
366: Set New_Cost = C_Dup_Asset_Info_Rec.new_cost,
367: Status_Flag = 'E',
368: Amount_Diff = null,
369: Percentage_Diff = null,

Line 434: cp_asset_id IN igi_iac_upload_lines.asset_id%type) Is

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
438: and asset_id = cp_asset_id;

Line 436: From igi_iac_upload_lines

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
438: and asset_id = cp_asset_id;
439:
440: Cursor C_Valid_Iac_Cat(

Line 442: cp_category_id in igi_iac_upload_lines.category_id%type) Is

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
446: and category_id = cp_category_id;

Line 570: Update igi_iac_upload_lines

566: End Check_Exceptions;
567:
568: Procedure Update_Line(p_upload_record IN upload_record) Is
569: Begin
570: Update igi_iac_upload_lines
571: Set new_cost = p_upload_record.new_cost,
572: original_cost = p_upload_record.original_cost,
573: percentage_diff = p_upload_record.percentage_diff,
574: amount_diff = p_upload_record.amount_diff,

Line 588: From igi_iac_upload_lines

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:
591: Cursor C_Errors(cp_file_name IN igi_iac_upload_headers.file_name%type,
592: cp_status_flag IN varchar2) Is

Line 594: From igi_iac_upload_lines

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
596: and status_flag = cp_status_flag;
597: l_errors number;
598: l_lines number;

Line 642: p_asset_id IN igi_iac_upload_lines.asset_id%type,

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,
646: cp_asset_id IN igi_iac_upload_lines.asset_id%type,

Line 643: p_line_num IN igi_iac_upload_lines.line_num%type,

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,
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

Line 646: cp_asset_id IN igi_iac_upload_lines.asset_id%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
650: Where file_name = cp_file_name

Line 647: cp_line_num IN igi_iac_upload_lines.line_num%type) Is

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
650: Where file_name = cp_file_name
651: and asset_id = cp_asset_id

Line 649: From igi_iac_upload_lines

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
650: Where file_name = cp_file_name
651: and asset_id = cp_asset_id
652: and line_num <> cp_line_num
653: and status_flag = 'E';

Line 695: P_New_Cost IN igi_iac_upload_lines.new_cost%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(
699: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is

Line 696: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is

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(
699: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is
700: Select fa.last_period_counter, gl.currency_code

Line 720: cp_asset_id in igi_iac_upload_lines.asset_id%type,

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

Line 740: From igi_iac_upload_lines

736:
737: Cursor C_Line_Num(
738: cp_file_name in igi_iac_upload_headers.file_name%type) Is
739: Select nvl(max(line_num),0) + 1 Line_Num
740: From igi_iac_upload_lines
741: Where file_name = cp_file_name;
742:
743: l_status_flag igi_iac_upload_headers.status_flag%type;
744: l_period_counter igi_iac_upload_headers.period_counter%type;

Line 881: P_Original_Cost IN igi_iac_upload_lines.original_cost%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,
884: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,
885: P_Message IN igi_iac_upload_lines.exception_message%type,

Line 882: P_New_Cost IN igi_iac_upload_lines.new_cost%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,
884: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,
885: P_Message IN igi_iac_upload_lines.exception_message%type,
886: P_Line_Action IN fnd_lookup_values.lookup_code%type,

Line 883: P_Amt_Diff IN igi_iac_upload_lines.amount_diff%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,
884: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,
885: P_Message IN igi_iac_upload_lines.exception_message%type,
886: P_Line_Action IN fnd_lookup_values.lookup_code%type,
887: P_Comments IN igi_iac_upload_lines.comments%type,

Line 884: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%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,
884: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,
885: P_Message IN igi_iac_upload_lines.exception_message%type,
886: P_Line_Action IN fnd_lookup_values.lookup_code%type,
887: P_Comments IN igi_iac_upload_lines.comments%type,
888: -- Bug 3391921 Start

Line 885: P_Message IN igi_iac_upload_lines.exception_message%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,
884: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,
885: P_Message IN igi_iac_upload_lines.exception_message%type,
886: P_Line_Action IN fnd_lookup_values.lookup_code%type,
887: P_Comments IN igi_iac_upload_lines.comments%type,
888: -- Bug 3391921 Start
889: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is

Line 887: P_Comments IN igi_iac_upload_lines.comments%type,

883: P_Amt_Diff IN igi_iac_upload_lines.amount_diff%type,
884: P_Per_Diff IN igi_iac_upload_lines.percentage_diff%type,
885: P_Message IN igi_iac_upload_lines.exception_message%type,
886: P_Line_Action IN fnd_lookup_values.lookup_code%type,
887: P_Comments IN igi_iac_upload_lines.comments%type,
888: -- Bug 3391921 Start
889: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is
890: -- Bug 3391921 End
891: l_dummy varchar2(1);

Line 889: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is

885: P_Message IN igi_iac_upload_lines.exception_message%type,
886: P_Line_Action IN fnd_lookup_values.lookup_code%type,
887: P_Comments IN igi_iac_upload_lines.comments%type,
888: -- Bug 3391921 Start
889: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is
890: -- Bug 3391921 End
891: l_dummy varchar2(1);
892: l_upload_record upload_record;
893: l_upd_line_flag varchar2(1) := 'Y';

Line 983: P_Line_Num IN igi_iac_upload_lines.line_num%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,
987: P_Message IN igi_iac_upload_lines.exception_message%type,

Line 986: P_New_Cost IN igi_iac_upload_lines.new_cost%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,
989: -- Bug 3391921 Start
990: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is

Line 987: P_Message IN igi_iac_upload_lines.exception_message%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,
989: -- Bug 3391921 Start
990: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is
991: -- Bug 3391921 End

Line 990: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is

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,
989: -- Bug 3391921 Start
990: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is
991: -- Bug 3391921 End
992:
993: l_dummy igi_iac_upload_headers.status_flag%type;
994: l_upload_record upload_record;

Line 1113: P_Original_Cost IN igi_iac_upload_lines.original_cost%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,
1116: -- Bug 3391921 Start
1117: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is

Line 1114: P_New_Cost IN igi_iac_upload_lines.new_cost%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,
1116: -- Bug 3391921 Start
1117: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is
1118: -- Bug 3391921 End

Line 1117: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is

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,
1116: -- Bug 3391921 Start
1117: P_Gross_Flag IN igi_iac_upload_lines.gross_flag%type) Is
1118: -- Bug 3391921 End
1119:
1120: l_dummy varchar2(1);
1121: l_upload_record upload_record;

Line 1137: Delete from igi_iac_upload_lines where file_name = p_file_name;

1133: Close C_File_Transferred;
1134:
1135: If p_hdr_action = 'Y' Then
1136: Delete from igi_iac_upload_headers where file_name = p_file_name;
1137: Delete from igi_iac_upload_lines where file_name = p_file_name;
1138: Else -- N
1139: Assign_Values_To_Rec(l_upload_record, p_file_name, p_asset_number);
1140: -- Bug 3391921 Start
1141: l_upload_record.gross_flag := p_gross_flag;

Line 1192: Select * from igi_iac_upload_lines

1188: Where file_name = cp_file_name;
1189:
1190: Cursor C_Upload_Lines(
1191: cp_file_name in igi_iac_upload_headers.file_name%type) Is
1192: Select * from igi_iac_upload_lines
1193: Where file_name = cp_file_name;
1194:
1195: Cursor C_Categories(
1196: cp_file_name in igi_iac_upload_headers.file_name%type) Is

Line 1197: Select distinct category_id from igi_iac_upload_lines

1193: Where file_name = cp_file_name;
1194:
1195: Cursor C_Categories(
1196: cp_file_name in igi_iac_upload_headers.file_name%type) Is
1197: Select distinct category_id from igi_iac_upload_lines
1198: where file_name = cp_file_name;
1199:
1200: Cursor C_Max_Period_counter(
1201: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is

Line 1252: cp_asset_id IN igi_iac_upload_lines.asset_id%TYPE,

1248: AND ad.asset_id = cp_asset_id;
1249:
1250: -- cursor to retrieve the iac portion of the cost of an asset
1251: CURSOR C_IAC_Asset_Cost(cp_book_type_code IN igi_iac_upload_headers.book_type_code%TYPE,
1252: cp_asset_id IN igi_iac_upload_lines.asset_id%TYPE,
1253: cp_period_counter IN igi_iac_upload_headers.period_counter%TYPE
1254: )
1255: IS
1256: SELECT nvl(adjusted_cost,0) adjusted_cost