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.

[Home] [Help]

APPS.FA_TRANS_API_PUB dependencies on FA_LOAD_TBL_PKG

Line 613: -- Get the details from fa_load_tbl_pkg.dist_table

609:
610: -- ***** Asset Distribution Info ***** --
611: l_asset_dist_tbl.delete;
612:
613: -- Get the details from fa_load_tbl_pkg.dist_table
614: for i in 1 .. fa_load_tbl_pkg.dist_table.count loop
615: if (fa_load_tbl_pkg.dist_table(i).record_status = 'INSERT') then
616: l_asset_dist_rec.distribution_id :=
617: fa_load_tbl_pkg.dist_table(i).dist_id;

Line 614: for i in 1 .. fa_load_tbl_pkg.dist_table.count loop

610: -- ***** Asset Distribution Info ***** --
611: l_asset_dist_tbl.delete;
612:
613: -- Get the details from fa_load_tbl_pkg.dist_table
614: for i in 1 .. fa_load_tbl_pkg.dist_table.count loop
615: if (fa_load_tbl_pkg.dist_table(i).record_status = 'INSERT') then
616: l_asset_dist_rec.distribution_id :=
617: fa_load_tbl_pkg.dist_table(i).dist_id;
618: l_asset_dist_rec.units_assigned :=

Line 615: if (fa_load_tbl_pkg.dist_table(i).record_status = 'INSERT') then

611: l_asset_dist_tbl.delete;
612:
613: -- Get the details from fa_load_tbl_pkg.dist_table
614: for i in 1 .. fa_load_tbl_pkg.dist_table.count loop
615: if (fa_load_tbl_pkg.dist_table(i).record_status = 'INSERT') then
616: l_asset_dist_rec.distribution_id :=
617: fa_load_tbl_pkg.dist_table(i).dist_id;
618: l_asset_dist_rec.units_assigned :=
619: fa_load_tbl_pkg.dist_table(i).trans_units;

Line 617: fa_load_tbl_pkg.dist_table(i).dist_id;

613: -- Get the details from fa_load_tbl_pkg.dist_table
614: for i in 1 .. fa_load_tbl_pkg.dist_table.count loop
615: if (fa_load_tbl_pkg.dist_table(i).record_status = 'INSERT') then
616: l_asset_dist_rec.distribution_id :=
617: fa_load_tbl_pkg.dist_table(i).dist_id;
618: l_asset_dist_rec.units_assigned :=
619: fa_load_tbl_pkg.dist_table(i).trans_units;
620: l_asset_dist_rec.transaction_units := NULL;
621: l_asset_dist_rec.assigned_to :=

Line 619: fa_load_tbl_pkg.dist_table(i).trans_units;

615: if (fa_load_tbl_pkg.dist_table(i).record_status = 'INSERT') then
616: l_asset_dist_rec.distribution_id :=
617: fa_load_tbl_pkg.dist_table(i).dist_id;
618: l_asset_dist_rec.units_assigned :=
619: fa_load_tbl_pkg.dist_table(i).trans_units;
620: l_asset_dist_rec.transaction_units := NULL;
621: l_asset_dist_rec.assigned_to :=
622: fa_load_tbl_pkg.dist_table(i).assigned_to;
623: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;

Line 622: fa_load_tbl_pkg.dist_table(i).assigned_to;

618: l_asset_dist_rec.units_assigned :=
619: fa_load_tbl_pkg.dist_table(i).trans_units;
620: l_asset_dist_rec.transaction_units := NULL;
621: l_asset_dist_rec.assigned_to :=
622: fa_load_tbl_pkg.dist_table(i).assigned_to;
623: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
624: l_asset_dist_rec.location_ccid :=
625: fa_load_tbl_pkg.dist_table(i).location_id;
626:

Line 623: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;

619: fa_load_tbl_pkg.dist_table(i).trans_units;
620: l_asset_dist_rec.transaction_units := NULL;
621: l_asset_dist_rec.assigned_to :=
622: fa_load_tbl_pkg.dist_table(i).assigned_to;
623: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
624: l_asset_dist_rec.location_ccid :=
625: fa_load_tbl_pkg.dist_table(i).location_id;
626:
627: l_asset_dist_tbl(i) := l_asset_dist_rec;

Line 625: fa_load_tbl_pkg.dist_table(i).location_id;

621: l_asset_dist_rec.assigned_to :=
622: fa_load_tbl_pkg.dist_table(i).assigned_to;
623: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
624: l_asset_dist_rec.location_ccid :=
625: fa_load_tbl_pkg.dist_table(i).location_id;
626:
627: l_asset_dist_tbl(i) := l_asset_dist_rec;
628: end if;
629: end loop;

Line 634: -- Get the details from fa_load_tbl_pkg.inv_table

630:
631: -- ***** Invoice Info ***** --
632: l_inv_tbl.delete;
633:
634: -- Get the details from fa_load_tbl_pkg.inv_table
635: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
636:
637: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
638: l_inv_rec.asset_invoice_id :=

Line 635: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop

631: -- ***** Invoice Info ***** --
632: l_inv_tbl.delete;
633:
634: -- Get the details from fa_load_tbl_pkg.inv_table
635: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
636:
637: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
638: l_inv_rec.asset_invoice_id :=
639: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

Line 637: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;

633:
634: -- Get the details from fa_load_tbl_pkg.inv_table
635: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
636:
637: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
638: l_inv_rec.asset_invoice_id :=
639: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
640: l_inv_rec.fixed_assets_cost :=
641: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;

Line 639: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

635: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
636:
637: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
638: l_inv_rec.asset_invoice_id :=
639: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
640: l_inv_rec.fixed_assets_cost :=
641: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
642: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
643: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

Line 641: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;

637: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
638: l_inv_rec.asset_invoice_id :=
639: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
640: l_inv_rec.fixed_assets_cost :=
641: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
642: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
643: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
644: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
645: l_inv_rec.payables_batch_name :=

Line 642: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;

638: l_inv_rec.asset_invoice_id :=
639: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
640: l_inv_rec.fixed_assets_cost :=
641: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
642: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
643: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
644: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
645: l_inv_rec.payables_batch_name :=
646: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

Line 643: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

639: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
640: l_inv_rec.fixed_assets_cost :=
641: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
642: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
643: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
644: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
645: l_inv_rec.payables_batch_name :=
646: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
647: l_inv_rec.payables_code_combination_id :=

Line 644: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;

640: l_inv_rec.fixed_assets_cost :=
641: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
642: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
643: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
644: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
645: l_inv_rec.payables_batch_name :=
646: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
647: l_inv_rec.payables_code_combination_id :=
648: fa_load_tbl_pkg.inv_table(i).payables_ccid;

Line 646: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

642: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
643: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
644: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
645: l_inv_rec.payables_batch_name :=
646: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
647: l_inv_rec.payables_code_combination_id :=
648: fa_load_tbl_pkg.inv_table(i).payables_ccid;
649: l_inv_rec.feeder_system_name :=
650: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

Line 648: fa_load_tbl_pkg.inv_table(i).payables_ccid;

644: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
645: l_inv_rec.payables_batch_name :=
646: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
647: l_inv_rec.payables_code_combination_id :=
648: fa_load_tbl_pkg.inv_table(i).payables_ccid;
649: l_inv_rec.feeder_system_name :=
650: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
651: l_inv_rec.create_batch_date :=
652: fa_load_tbl_pkg.inv_table(i).create_batch_date;

Line 650: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

646: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
647: l_inv_rec.payables_code_combination_id :=
648: fa_load_tbl_pkg.inv_table(i).payables_ccid;
649: l_inv_rec.feeder_system_name :=
650: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
651: l_inv_rec.create_batch_date :=
652: fa_load_tbl_pkg.inv_table(i).create_batch_date;
653: l_inv_rec.create_batch_id :=
654: fa_load_tbl_pkg.inv_table(i).create_batch_id;

Line 652: fa_load_tbl_pkg.inv_table(i).create_batch_date;

648: fa_load_tbl_pkg.inv_table(i).payables_ccid;
649: l_inv_rec.feeder_system_name :=
650: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
651: l_inv_rec.create_batch_date :=
652: fa_load_tbl_pkg.inv_table(i).create_batch_date;
653: l_inv_rec.create_batch_id :=
654: fa_load_tbl_pkg.inv_table(i).create_batch_id;
655: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
656: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

Line 654: fa_load_tbl_pkg.inv_table(i).create_batch_id;

650: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
651: l_inv_rec.create_batch_date :=
652: fa_load_tbl_pkg.inv_table(i).create_batch_date;
653: l_inv_rec.create_batch_id :=
654: fa_load_tbl_pkg.inv_table(i).create_batch_id;
655: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
656: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
657: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
658: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

Line 655: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;

651: l_inv_rec.create_batch_date :=
652: fa_load_tbl_pkg.inv_table(i).create_batch_date;
653: l_inv_rec.create_batch_id :=
654: fa_load_tbl_pkg.inv_table(i).create_batch_id;
655: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
656: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
657: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
658: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
659: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

Line 656: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

652: fa_load_tbl_pkg.inv_table(i).create_batch_date;
653: l_inv_rec.create_batch_id :=
654: fa_load_tbl_pkg.inv_table(i).create_batch_id;
655: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
656: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
657: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
658: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
659: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
660: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

Line 657: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;

653: l_inv_rec.create_batch_id :=
654: fa_load_tbl_pkg.inv_table(i).create_batch_id;
655: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
656: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
657: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
658: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
659: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
660: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
661: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

Line 658: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

654: fa_load_tbl_pkg.inv_table(i).create_batch_id;
655: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
656: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
657: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
658: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
659: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
660: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
661: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
662: l_inv_rec.ap_distribution_line_number :=

Line 659: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

655: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
656: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
657: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
658: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
659: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
660: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
661: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
662: l_inv_rec.ap_distribution_line_number :=
663: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

Line 660: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

656: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
657: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
658: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
659: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
660: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
661: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
662: l_inv_rec.ap_distribution_line_number :=
663: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
664: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

Line 661: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

657: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
658: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
659: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
660: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
661: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
662: l_inv_rec.ap_distribution_line_number :=
663: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
664: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
665: --l_inv_rec.split_merged_code :=

Line 663: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

659: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
660: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
661: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
662: l_inv_rec.ap_distribution_line_number :=
663: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
664: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
665: --l_inv_rec.split_merged_code :=
666: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
667: --l_inv_rec.parent_mass_additions_id :=

Line 664: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

660: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
661: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
662: l_inv_rec.ap_distribution_line_number :=
663: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
664: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
665: --l_inv_rec.split_merged_code :=
666: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
667: --l_inv_rec.parent_mass_additions_id :=
668: --l_inv_rec.unrevalued_cost :=

Line 666: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;

662: l_inv_rec.ap_distribution_line_number :=
663: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
664: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
665: --l_inv_rec.split_merged_code :=
666: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
667: --l_inv_rec.parent_mass_additions_id :=
668: --l_inv_rec.unrevalued_cost :=
669: --l_inv_rec.merged_code :=
670: --l_inv_rec.split_code :=

Line 674: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;

670: --l_inv_rec.split_code :=
671: --l_inv_rec.merge_parent_mass_additions_id :=
672: --l_inv_rec.split_parent_mass_additions_id :=
673: l_inv_rec.project_asset_line_id :=
674: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
675: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
676: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
677: l_inv_rec.material_indicator_flag :=
678: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

Line 675: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;

671: --l_inv_rec.merge_parent_mass_additions_id :=
672: --l_inv_rec.split_parent_mass_additions_id :=
673: l_inv_rec.project_asset_line_id :=
674: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
675: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
676: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
677: l_inv_rec.material_indicator_flag :=
678: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
679: l_inv_rec.depreciate_in_group_flag :=

Line 676: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;

672: --l_inv_rec.split_parent_mass_additions_id :=
673: l_inv_rec.project_asset_line_id :=
674: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
675: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
676: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
677: l_inv_rec.material_indicator_flag :=
678: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
679: l_inv_rec.depreciate_in_group_flag :=
680: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

Line 678: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

674: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
675: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
676: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
677: l_inv_rec.material_indicator_flag :=
678: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
679: l_inv_rec.depreciate_in_group_flag :=
680: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
681: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
682: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

Line 680: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

676: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
677: l_inv_rec.material_indicator_flag :=
678: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
679: l_inv_rec.depreciate_in_group_flag :=
680: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
681: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
682: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
683: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
684: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;

Line 681: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;

677: l_inv_rec.material_indicator_flag :=
678: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
679: l_inv_rec.depreciate_in_group_flag :=
680: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
681: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
682: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
683: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
684: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
685: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

Line 682: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

678: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
679: l_inv_rec.depreciate_in_group_flag :=
680: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
681: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
682: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
683: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
684: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
685: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
686: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

Line 683: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

679: l_inv_rec.depreciate_in_group_flag :=
680: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
681: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
682: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
683: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
684: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
685: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
686: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
687: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

Line 684: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;

680: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
681: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
682: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
683: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
684: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
685: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
686: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
687: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
688: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

Line 685: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

681: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
682: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
683: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
684: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
685: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
686: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
687: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
688: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
689: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

Line 686: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

682: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
683: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
684: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
685: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
686: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
687: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
688: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
689: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
690: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

Line 687: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

683: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
684: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
685: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
686: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
687: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
688: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
689: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
690: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
691: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

Line 688: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

684: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
685: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
686: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
687: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
688: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
689: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
690: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
691: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
692: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

Line 689: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

685: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
686: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
687: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
688: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
689: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
690: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
691: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
692: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
693: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

Line 690: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

686: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
687: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
688: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
689: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
690: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
691: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
692: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
693: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
694: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

Line 691: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

687: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
688: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
689: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
690: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
691: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
692: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
693: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
694: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
695: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

Line 692: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

688: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
689: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
690: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
691: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
692: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
693: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
694: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
695: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
696: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

Line 693: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

689: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
690: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
691: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
692: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
693: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
694: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
695: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
696: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
697: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

Line 694: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

690: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
691: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
692: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
693: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
694: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
695: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
696: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
697: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
698: l_inv_rec.attribute_category_code :=

Line 695: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

691: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
692: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
693: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
694: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
695: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
696: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
697: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
698: l_inv_rec.attribute_category_code :=
699: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

Line 696: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

692: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
693: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
694: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
695: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
696: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
697: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
698: l_inv_rec.attribute_category_code :=
699: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
700:

Line 697: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

693: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
694: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
695: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
696: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
697: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
698: l_inv_rec.attribute_category_code :=
699: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
700:
701: l_inv_tbl(i) := l_inv_rec;

Line 699: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

695: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
696: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
697: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
698: l_inv_rec.attribute_category_code :=
699: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
700:
701: l_inv_tbl(i) := l_inv_rec;
702: end loop;
703:

Line 1275: -- Get the details from fa_load_tbl_pkg.inv_table

1271:
1272: -- ***** Invoice Information ***** --
1273: l_inv_tbl.delete;
1274:
1275: -- Get the details from fa_load_tbl_pkg.inv_table
1276: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1277:
1278: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1279: l_inv_rec.asset_invoice_id :=

Line 1276: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop

1272: -- ***** Invoice Information ***** --
1273: l_inv_tbl.delete;
1274:
1275: -- Get the details from fa_load_tbl_pkg.inv_table
1276: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1277:
1278: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1279: l_inv_rec.asset_invoice_id :=
1280: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

Line 1278: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;

1274:
1275: -- Get the details from fa_load_tbl_pkg.inv_table
1276: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1277:
1278: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1279: l_inv_rec.asset_invoice_id :=
1280: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1281: l_inv_rec.fixed_assets_cost :=
1282: fa_load_tbl_pkg.inv_table(i).inv_new_cost -

Line 1280: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

1276: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1277:
1278: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1279: l_inv_rec.asset_invoice_id :=
1280: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1281: l_inv_rec.fixed_assets_cost :=
1282: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
1283: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
1284: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;

Line 1282: fa_load_tbl_pkg.inv_table(i).inv_new_cost -

1278: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1279: l_inv_rec.asset_invoice_id :=
1280: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1281: l_inv_rec.fixed_assets_cost :=
1282: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
1283: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
1284: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1285: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1286: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;

Line 1283: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);

1279: l_inv_rec.asset_invoice_id :=
1280: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1281: l_inv_rec.fixed_assets_cost :=
1282: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
1283: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
1284: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1285: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1286: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1287: l_inv_rec.payables_batch_name :=

Line 1284: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;

1280: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1281: l_inv_rec.fixed_assets_cost :=
1282: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
1283: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
1284: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1285: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1286: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1287: l_inv_rec.payables_batch_name :=
1288: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

Line 1285: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

1281: l_inv_rec.fixed_assets_cost :=
1282: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
1283: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
1284: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1285: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1286: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1287: l_inv_rec.payables_batch_name :=
1288: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1289: l_inv_rec.payables_code_combination_id :=

Line 1286: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;

1282: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
1283: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
1284: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1285: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1286: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1287: l_inv_rec.payables_batch_name :=
1288: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1289: l_inv_rec.payables_code_combination_id :=
1290: fa_load_tbl_pkg.inv_table(i).payables_ccid;

Line 1288: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

1284: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1285: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1286: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1287: l_inv_rec.payables_batch_name :=
1288: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1289: l_inv_rec.payables_code_combination_id :=
1290: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1291: l_inv_rec.feeder_system_name :=
1292: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

Line 1290: fa_load_tbl_pkg.inv_table(i).payables_ccid;

1286: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1287: l_inv_rec.payables_batch_name :=
1288: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1289: l_inv_rec.payables_code_combination_id :=
1290: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1291: l_inv_rec.feeder_system_name :=
1292: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1293: l_inv_rec.create_batch_date :=
1294: fa_load_tbl_pkg.inv_table(i).create_batch_date;

Line 1292: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

1288: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1289: l_inv_rec.payables_code_combination_id :=
1290: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1291: l_inv_rec.feeder_system_name :=
1292: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1293: l_inv_rec.create_batch_date :=
1294: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1295: l_inv_rec.create_batch_id :=
1296: fa_load_tbl_pkg.inv_table(i).create_batch_id;

Line 1294: fa_load_tbl_pkg.inv_table(i).create_batch_date;

1290: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1291: l_inv_rec.feeder_system_name :=
1292: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1293: l_inv_rec.create_batch_date :=
1294: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1295: l_inv_rec.create_batch_id :=
1296: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1297: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1298: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

Line 1296: fa_load_tbl_pkg.inv_table(i).create_batch_id;

1292: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1293: l_inv_rec.create_batch_date :=
1294: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1295: l_inv_rec.create_batch_id :=
1296: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1297: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1298: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1299: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1300: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

Line 1297: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;

1293: l_inv_rec.create_batch_date :=
1294: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1295: l_inv_rec.create_batch_id :=
1296: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1297: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1298: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1299: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1300: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1301: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

Line 1298: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

1294: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1295: l_inv_rec.create_batch_id :=
1296: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1297: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1298: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1299: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1300: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1301: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1302: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

Line 1299: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;

1295: l_inv_rec.create_batch_id :=
1296: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1297: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1298: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1299: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1300: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1301: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1302: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1303: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

Line 1300: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

1296: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1297: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1298: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1299: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1300: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1301: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1302: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1303: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1304: l_inv_rec.ap_distribution_line_number :=

Line 1301: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

1297: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1298: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1299: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1300: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1301: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1302: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1303: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1304: l_inv_rec.ap_distribution_line_number :=
1305: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

Line 1302: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

1298: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1299: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1300: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1301: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1302: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1303: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1304: l_inv_rec.ap_distribution_line_number :=
1305: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1306: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

Line 1303: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

1299: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1300: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1301: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1302: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1303: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1304: l_inv_rec.ap_distribution_line_number :=
1305: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1306: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1307: --l_inv_rec.split_merged_code :=

Line 1305: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

1301: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1302: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1303: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1304: l_inv_rec.ap_distribution_line_number :=
1305: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1306: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1307: --l_inv_rec.split_merged_code :=
1308: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
1309: --l_inv_rec.parent_mass_additions_id :=

Line 1306: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

1302: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1303: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1304: l_inv_rec.ap_distribution_line_number :=
1305: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1306: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1307: --l_inv_rec.split_merged_code :=
1308: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
1309: --l_inv_rec.parent_mass_additions_id :=
1310: --l_inv_rec.unrevalued_cost :=

Line 1308: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;

1304: l_inv_rec.ap_distribution_line_number :=
1305: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1306: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1307: --l_inv_rec.split_merged_code :=
1308: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
1309: --l_inv_rec.parent_mass_additions_id :=
1310: --l_inv_rec.unrevalued_cost :=
1311: --l_inv_rec.merged_code :=
1312: --l_inv_rec.split_code :=

Line 1316: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;

1312: --l_inv_rec.split_code :=
1313: --l_inv_rec.merge_parent_mass_additions_id :=
1314: --l_inv_rec.split_parent_mass_additions_id :=
1315: l_inv_rec.project_asset_line_id :=
1316: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1317: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1318: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1319: l_inv_rec.material_indicator_flag :=
1320: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

Line 1317: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;

1313: --l_inv_rec.merge_parent_mass_additions_id :=
1314: --l_inv_rec.split_parent_mass_additions_id :=
1315: l_inv_rec.project_asset_line_id :=
1316: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1317: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1318: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1319: l_inv_rec.material_indicator_flag :=
1320: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1321: l_inv_rec.depreciate_in_group_flag :=

Line 1318: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;

1314: --l_inv_rec.split_parent_mass_additions_id :=
1315: l_inv_rec.project_asset_line_id :=
1316: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1317: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1318: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1319: l_inv_rec.material_indicator_flag :=
1320: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1321: l_inv_rec.depreciate_in_group_flag :=
1322: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

Line 1320: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

1316: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1317: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1318: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1319: l_inv_rec.material_indicator_flag :=
1320: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1321: l_inv_rec.depreciate_in_group_flag :=
1322: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1323: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1324: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

Line 1322: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

1318: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1319: l_inv_rec.material_indicator_flag :=
1320: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1321: l_inv_rec.depreciate_in_group_flag :=
1322: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1323: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1324: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1325: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1326: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

Line 1323: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;

1319: l_inv_rec.material_indicator_flag :=
1320: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1321: l_inv_rec.depreciate_in_group_flag :=
1322: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1323: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1324: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1325: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1326: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1327: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

Line 1324: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

1320: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1321: l_inv_rec.depreciate_in_group_flag :=
1322: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1323: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1324: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1325: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1326: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1327: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1328: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

Line 1325: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;

1321: l_inv_rec.depreciate_in_group_flag :=
1322: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1323: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1324: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1325: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1326: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1327: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1328: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1329: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

Line 1326: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

1322: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1323: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1324: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1325: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1326: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1327: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1328: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1329: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1330: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

Line 1327: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

1323: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1324: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1325: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1326: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1327: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1328: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1329: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1330: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1331: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

Line 1328: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

1324: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1325: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1326: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1327: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1328: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1329: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1330: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1331: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1332: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

Line 1329: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

1325: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1326: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1327: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1328: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1329: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1330: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1331: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1332: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1333: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

Line 1330: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

1326: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1327: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1328: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1329: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1330: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1331: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1332: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1333: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1334: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

Line 1331: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

1327: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1328: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1329: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1330: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1331: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1332: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1333: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1334: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1335: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

Line 1332: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

1328: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1329: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1330: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1331: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1332: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1333: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1334: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1335: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1336: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

Line 1333: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

1329: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1330: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1331: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1332: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1333: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1334: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1335: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1336: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1337: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

Line 1334: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

1330: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1331: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1332: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1333: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1334: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1335: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1336: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1337: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1338: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

Line 1335: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

1331: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1332: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1333: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1334: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1335: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1336: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1337: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1338: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1339: l_inv_rec.attribute_category_code :=

Line 1336: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

1332: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1333: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1334: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1335: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1336: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1337: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1338: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1339: l_inv_rec.attribute_category_code :=
1340: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

Line 1337: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

1333: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1334: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1335: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1336: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1337: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1338: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1339: l_inv_rec.attribute_category_code :=
1340: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
1341:

Line 1338: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

1334: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1335: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1336: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1337: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1338: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1339: l_inv_rec.attribute_category_code :=
1340: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
1341:
1342: if ((p_reset_miss_flag = 'YES') and

Line 1340: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

1336: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1337: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1338: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1339: l_inv_rec.attribute_category_code :=
1340: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
1341:
1342: if ((p_reset_miss_flag = 'YES') and
1343: (l_inv_trans_rec.transaction_type = 'INVOICE ADJUSTMENT')) then
1344:

Line 1534: -- Get the details from fa_load_tbl_pkg.dist_tbl;

1530:
1531: -- ***** Asset Distribution Info ***** --
1532: l_asset_dist_tbl.delete;
1533:
1534: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1535: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1536: fa_load_tbl_pkg.dist_table.LAST loop
1537: l_asset_dist_rec.distribution_id :=
1538: fa_load_tbl_pkg.dist_table(i).dist_id;

Line 1535: for i in fa_load_tbl_pkg.dist_table.FIRST ..

1531: -- ***** Asset Distribution Info ***** --
1532: l_asset_dist_tbl.delete;
1533:
1534: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1535: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1536: fa_load_tbl_pkg.dist_table.LAST loop
1537: l_asset_dist_rec.distribution_id :=
1538: fa_load_tbl_pkg.dist_table(i).dist_id;
1539: --l_asset_dist_rec.units_assigned :=

Line 1536: fa_load_tbl_pkg.dist_table.LAST loop

1532: l_asset_dist_tbl.delete;
1533:
1534: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1535: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1536: fa_load_tbl_pkg.dist_table.LAST loop
1537: l_asset_dist_rec.distribution_id :=
1538: fa_load_tbl_pkg.dist_table(i).dist_id;
1539: --l_asset_dist_rec.units_assigned :=
1540: l_asset_dist_rec.transaction_units :=

Line 1538: fa_load_tbl_pkg.dist_table(i).dist_id;

1534: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1535: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1536: fa_load_tbl_pkg.dist_table.LAST loop
1537: l_asset_dist_rec.distribution_id :=
1538: fa_load_tbl_pkg.dist_table(i).dist_id;
1539: --l_asset_dist_rec.units_assigned :=
1540: l_asset_dist_rec.transaction_units :=
1541: fa_load_tbl_pkg.dist_table(i).trans_units;
1542: l_asset_dist_rec.assigned_to :=

Line 1541: fa_load_tbl_pkg.dist_table(i).trans_units;

1537: l_asset_dist_rec.distribution_id :=
1538: fa_load_tbl_pkg.dist_table(i).dist_id;
1539: --l_asset_dist_rec.units_assigned :=
1540: l_asset_dist_rec.transaction_units :=
1541: fa_load_tbl_pkg.dist_table(i).trans_units;
1542: l_asset_dist_rec.assigned_to :=
1543: fa_load_tbl_pkg.dist_table(i).assigned_to;
1544: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1545: l_asset_dist_rec.location_ccid :=

Line 1543: fa_load_tbl_pkg.dist_table(i).assigned_to;

1539: --l_asset_dist_rec.units_assigned :=
1540: l_asset_dist_rec.transaction_units :=
1541: fa_load_tbl_pkg.dist_table(i).trans_units;
1542: l_asset_dist_rec.assigned_to :=
1543: fa_load_tbl_pkg.dist_table(i).assigned_to;
1544: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1545: l_asset_dist_rec.location_ccid :=
1546: fa_load_tbl_pkg.dist_table(i).location_id;
1547:

Line 1544: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;

1540: l_asset_dist_rec.transaction_units :=
1541: fa_load_tbl_pkg.dist_table(i).trans_units;
1542: l_asset_dist_rec.assigned_to :=
1543: fa_load_tbl_pkg.dist_table(i).assigned_to;
1544: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1545: l_asset_dist_rec.location_ccid :=
1546: fa_load_tbl_pkg.dist_table(i).location_id;
1547:
1548: l_asset_dist_tbl(i) := l_asset_dist_rec;

Line 1546: fa_load_tbl_pkg.dist_table(i).location_id;

1542: l_asset_dist_rec.assigned_to :=
1543: fa_load_tbl_pkg.dist_table(i).assigned_to;
1544: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1545: l_asset_dist_rec.location_ccid :=
1546: fa_load_tbl_pkg.dist_table(i).location_id;
1547:
1548: l_asset_dist_tbl(i) := l_asset_dist_rec;
1549: end loop;
1550:

Line 1696: -- Get the details from fa_load_tbl_pkg.dist_tbl;

1692:
1693: -- ***** Asset Distribution Info ***** --
1694: l_asset_dist_tbl.delete;
1695:
1696: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1697: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1698: fa_load_tbl_pkg.dist_table.LAST loop
1699: l_asset_dist_rec.distribution_id :=
1700: fa_load_tbl_pkg.dist_table(i).dist_id;

Line 1697: for i in fa_load_tbl_pkg.dist_table.FIRST ..

1693: -- ***** Asset Distribution Info ***** --
1694: l_asset_dist_tbl.delete;
1695:
1696: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1697: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1698: fa_load_tbl_pkg.dist_table.LAST loop
1699: l_asset_dist_rec.distribution_id :=
1700: fa_load_tbl_pkg.dist_table(i).dist_id;
1701: --l_asset_dist_rec.units_assigned :=

Line 1698: fa_load_tbl_pkg.dist_table.LAST loop

1694: l_asset_dist_tbl.delete;
1695:
1696: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1697: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1698: fa_load_tbl_pkg.dist_table.LAST loop
1699: l_asset_dist_rec.distribution_id :=
1700: fa_load_tbl_pkg.dist_table(i).dist_id;
1701: --l_asset_dist_rec.units_assigned :=
1702: l_asset_dist_rec.transaction_units :=

Line 1700: fa_load_tbl_pkg.dist_table(i).dist_id;

1696: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1697: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1698: fa_load_tbl_pkg.dist_table.LAST loop
1699: l_asset_dist_rec.distribution_id :=
1700: fa_load_tbl_pkg.dist_table(i).dist_id;
1701: --l_asset_dist_rec.units_assigned :=
1702: l_asset_dist_rec.transaction_units :=
1703: fa_load_tbl_pkg.dist_table(i).trans_units;
1704: l_asset_dist_rec.assigned_to :=

Line 1703: fa_load_tbl_pkg.dist_table(i).trans_units;

1699: l_asset_dist_rec.distribution_id :=
1700: fa_load_tbl_pkg.dist_table(i).dist_id;
1701: --l_asset_dist_rec.units_assigned :=
1702: l_asset_dist_rec.transaction_units :=
1703: fa_load_tbl_pkg.dist_table(i).trans_units;
1704: l_asset_dist_rec.assigned_to :=
1705: fa_load_tbl_pkg.dist_table(i).assigned_to;
1706: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1707: l_asset_dist_rec.location_ccid :=

Line 1705: fa_load_tbl_pkg.dist_table(i).assigned_to;

1701: --l_asset_dist_rec.units_assigned :=
1702: l_asset_dist_rec.transaction_units :=
1703: fa_load_tbl_pkg.dist_table(i).trans_units;
1704: l_asset_dist_rec.assigned_to :=
1705: fa_load_tbl_pkg.dist_table(i).assigned_to;
1706: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1707: l_asset_dist_rec.location_ccid :=
1708: fa_load_tbl_pkg.dist_table(i).location_id;
1709:

Line 1706: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;

1702: l_asset_dist_rec.transaction_units :=
1703: fa_load_tbl_pkg.dist_table(i).trans_units;
1704: l_asset_dist_rec.assigned_to :=
1705: fa_load_tbl_pkg.dist_table(i).assigned_to;
1706: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1707: l_asset_dist_rec.location_ccid :=
1708: fa_load_tbl_pkg.dist_table(i).location_id;
1709:
1710: l_asset_dist_tbl(i) := l_asset_dist_rec;

Line 1708: fa_load_tbl_pkg.dist_table(i).location_id;

1704: l_asset_dist_rec.assigned_to :=
1705: fa_load_tbl_pkg.dist_table(i).assigned_to;
1706: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1707: l_asset_dist_rec.location_ccid :=
1708: fa_load_tbl_pkg.dist_table(i).location_id;
1709:
1710: l_asset_dist_tbl(i) := l_asset_dist_rec;
1711: end loop;
1712:

Line 1894: -- Get the details from fa_load_tbl_pkg.inv_table

1890:
1891: -- ***** Invoice Info ***** --
1892: l_inv_tbl.delete;
1893:
1894: -- Get the details from fa_load_tbl_pkg.inv_table
1895: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1896:
1897: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1898: l_inv_rec.asset_invoice_id :=

Line 1895: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop

1891: -- ***** Invoice Info ***** --
1892: l_inv_tbl.delete;
1893:
1894: -- Get the details from fa_load_tbl_pkg.inv_table
1895: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1896:
1897: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1898: l_inv_rec.asset_invoice_id :=
1899: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

Line 1897: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;

1893:
1894: -- Get the details from fa_load_tbl_pkg.inv_table
1895: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1896:
1897: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1898: l_inv_rec.asset_invoice_id :=
1899: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1900: l_inv_rec.fixed_assets_cost := 0 -
1901: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;

Line 1899: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

1895: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1896:
1897: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1898: l_inv_rec.asset_invoice_id :=
1899: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1900: l_inv_rec.fixed_assets_cost := 0 -
1901: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;
1902: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1903: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

Line 1901: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;

1897: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1898: l_inv_rec.asset_invoice_id :=
1899: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1900: l_inv_rec.fixed_assets_cost := 0 -
1901: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;
1902: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1903: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1904: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1905: l_inv_rec.payables_batch_name :=

Line 1902: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;

1898: l_inv_rec.asset_invoice_id :=
1899: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1900: l_inv_rec.fixed_assets_cost := 0 -
1901: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;
1902: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1903: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1904: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1905: l_inv_rec.payables_batch_name :=
1906: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

Line 1903: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

1899: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1900: l_inv_rec.fixed_assets_cost := 0 -
1901: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;
1902: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1903: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1904: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1905: l_inv_rec.payables_batch_name :=
1906: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1907: l_inv_rec.payables_code_combination_id :=

Line 1904: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;

1900: l_inv_rec.fixed_assets_cost := 0 -
1901: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;
1902: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1903: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1904: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1905: l_inv_rec.payables_batch_name :=
1906: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1907: l_inv_rec.payables_code_combination_id :=
1908: fa_load_tbl_pkg.inv_table(i).payables_ccid;

Line 1906: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

1902: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1903: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1904: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1905: l_inv_rec.payables_batch_name :=
1906: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1907: l_inv_rec.payables_code_combination_id :=
1908: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1909: l_inv_rec.feeder_system_name :=
1910: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

Line 1908: fa_load_tbl_pkg.inv_table(i).payables_ccid;

1904: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1905: l_inv_rec.payables_batch_name :=
1906: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1907: l_inv_rec.payables_code_combination_id :=
1908: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1909: l_inv_rec.feeder_system_name :=
1910: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1911: l_inv_rec.create_batch_date :=
1912: fa_load_tbl_pkg.inv_table(i).create_batch_date;

Line 1910: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

1906: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1907: l_inv_rec.payables_code_combination_id :=
1908: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1909: l_inv_rec.feeder_system_name :=
1910: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1911: l_inv_rec.create_batch_date :=
1912: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1913: l_inv_rec.create_batch_id :=
1914: fa_load_tbl_pkg.inv_table(i).create_batch_id;

Line 1912: fa_load_tbl_pkg.inv_table(i).create_batch_date;

1908: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1909: l_inv_rec.feeder_system_name :=
1910: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1911: l_inv_rec.create_batch_date :=
1912: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1913: l_inv_rec.create_batch_id :=
1914: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1915: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1916: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

Line 1914: fa_load_tbl_pkg.inv_table(i).create_batch_id;

1910: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1911: l_inv_rec.create_batch_date :=
1912: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1913: l_inv_rec.create_batch_id :=
1914: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1915: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1916: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1917: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1918: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

Line 1915: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;

1911: l_inv_rec.create_batch_date :=
1912: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1913: l_inv_rec.create_batch_id :=
1914: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1915: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1916: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1917: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1918: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1919: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

Line 1916: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

1912: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1913: l_inv_rec.create_batch_id :=
1914: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1915: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1916: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1917: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1918: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1919: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1920: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

Line 1917: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;

1913: l_inv_rec.create_batch_id :=
1914: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1915: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1916: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1917: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1918: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1919: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1920: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1921: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

Line 1918: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

1914: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1915: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1916: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1917: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1918: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1919: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1920: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1921: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1922: l_inv_rec.ap_distribution_line_number :=

Line 1919: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

1915: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1916: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1917: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1918: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1919: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1920: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1921: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1922: l_inv_rec.ap_distribution_line_number :=
1923: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

Line 1920: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

1916: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1917: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1918: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1919: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1920: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1921: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1922: l_inv_rec.ap_distribution_line_number :=
1923: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1924: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

Line 1921: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

1917: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1918: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1919: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1920: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1921: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1922: l_inv_rec.ap_distribution_line_number :=
1923: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1924: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1925: --l_inv_rec.split_merged_code :=

Line 1923: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

1919: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1920: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1921: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1922: l_inv_rec.ap_distribution_line_number :=
1923: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1924: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1925: --l_inv_rec.split_merged_code :=
1926: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
1927: --l_inv_rec.parent_mass_additions_id :=

Line 1924: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

1920: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1921: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1922: l_inv_rec.ap_distribution_line_number :=
1923: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1924: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1925: --l_inv_rec.split_merged_code :=
1926: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
1927: --l_inv_rec.parent_mass_additions_id :=
1928: --l_inv_rec.unrevalued_cost :=

Line 1926: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;

1922: l_inv_rec.ap_distribution_line_number :=
1923: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1924: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1925: --l_inv_rec.split_merged_code :=
1926: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
1927: --l_inv_rec.parent_mass_additions_id :=
1928: --l_inv_rec.unrevalued_cost :=
1929: --l_inv_rec.merged_code :=
1930: --l_inv_rec.split_code :=

Line 1934: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;

1930: --l_inv_rec.split_code :=
1931: --l_inv_rec.merge_parent_mass_additions_id :=
1932: --l_inv_rec.split_parent_mass_additions_id :=
1933: l_inv_rec.project_asset_line_id :=
1934: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1935: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1936: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1937: l_inv_rec.material_indicator_flag :=
1938: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

Line 1935: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;

1931: --l_inv_rec.merge_parent_mass_additions_id :=
1932: --l_inv_rec.split_parent_mass_additions_id :=
1933: l_inv_rec.project_asset_line_id :=
1934: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1935: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1936: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1937: l_inv_rec.material_indicator_flag :=
1938: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1939: l_inv_rec.depreciate_in_group_flag :=

Line 1936: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;

1932: --l_inv_rec.split_parent_mass_additions_id :=
1933: l_inv_rec.project_asset_line_id :=
1934: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1935: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1936: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1937: l_inv_rec.material_indicator_flag :=
1938: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1939: l_inv_rec.depreciate_in_group_flag :=
1940: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

Line 1938: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

1934: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1935: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1936: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1937: l_inv_rec.material_indicator_flag :=
1938: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1939: l_inv_rec.depreciate_in_group_flag :=
1940: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1941: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1942: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

Line 1940: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

1936: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1937: l_inv_rec.material_indicator_flag :=
1938: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1939: l_inv_rec.depreciate_in_group_flag :=
1940: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1941: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1942: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1943: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1944: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

Line 1941: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;

1937: l_inv_rec.material_indicator_flag :=
1938: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1939: l_inv_rec.depreciate_in_group_flag :=
1940: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1941: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1942: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1943: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1944: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1945: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

Line 1942: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

1938: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1939: l_inv_rec.depreciate_in_group_flag :=
1940: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1941: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1942: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1943: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1944: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1945: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1946: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

Line 1943: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;

1939: l_inv_rec.depreciate_in_group_flag :=
1940: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1941: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1942: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1943: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1944: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1945: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1946: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1947: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

Line 1944: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

1940: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1941: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1942: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1943: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1944: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1945: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1946: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1947: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1948: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

Line 1945: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

1941: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1942: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1943: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1944: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1945: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1946: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1947: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1948: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1949: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

Line 1946: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

1942: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1943: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1944: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1945: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1946: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1947: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1948: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1949: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1950: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

Line 1947: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

1943: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1944: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1945: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1946: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1947: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1948: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1949: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1950: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1951: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

Line 1948: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

1944: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1945: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1946: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1947: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1948: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1949: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1950: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1951: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1952: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

Line 1949: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

1945: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1946: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1947: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1948: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1949: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1950: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1951: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1952: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1953: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

Line 1950: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

1946: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1947: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1948: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1949: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1950: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1951: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1952: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1953: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1954: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

Line 1951: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

1947: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1948: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1949: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1950: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1951: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1952: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1953: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1954: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1955: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

Line 1952: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

1948: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1949: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1950: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1951: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1952: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1953: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1954: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1955: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1956: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

Line 1953: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

1949: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1950: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1951: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1952: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1953: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1954: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1955: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1956: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1957: l_inv_rec.attribute_category_code :=

Line 1954: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

1950: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1951: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1952: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1953: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1954: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1955: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1956: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1957: l_inv_rec.attribute_category_code :=
1958: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

Line 1955: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

1951: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1952: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1953: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1954: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1955: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1956: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1957: l_inv_rec.attribute_category_code :=
1958: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
1959:

Line 1956: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

1952: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1953: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1954: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1955: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1956: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1957: l_inv_rec.attribute_category_code :=
1958: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
1959:
1960: l_inv_tbl(i) := l_inv_rec;

Line 1958: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

1954: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1955: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1956: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1957: l_inv_rec.attribute_category_code :=
1958: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
1959:
1960: l_inv_tbl(i) := l_inv_rec;
1961: end loop;
1962:

Line 2471: -- Get the details from fa_load_tbl_pkg.dist_tbl;

2467:
2468: -- ***** Asset Distribution Info ***** --
2469: l_asset_dist_tbl.delete;
2470:
2471: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2472: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2473: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2474: l_asset_dist_rec.distribution_id :=
2475: fa_load_tbl_pkg.dist_table(i).dist_id;

Line 2472: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop

2468: -- ***** Asset Distribution Info ***** --
2469: l_asset_dist_tbl.delete;
2470:
2471: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2472: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2473: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2474: l_asset_dist_rec.distribution_id :=
2475: fa_load_tbl_pkg.dist_table(i).dist_id;
2476: l_asset_dist_rec.transaction_units :=

Line 2473: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then

2469: l_asset_dist_tbl.delete;
2470:
2471: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2472: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2473: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2474: l_asset_dist_rec.distribution_id :=
2475: fa_load_tbl_pkg.dist_table(i).dist_id;
2476: l_asset_dist_rec.transaction_units :=
2477: fa_load_tbl_pkg.dist_table(i).trans_units;

Line 2475: fa_load_tbl_pkg.dist_table(i).dist_id;

2471: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2472: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2473: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2474: l_asset_dist_rec.distribution_id :=
2475: fa_load_tbl_pkg.dist_table(i).dist_id;
2476: l_asset_dist_rec.transaction_units :=
2477: fa_load_tbl_pkg.dist_table(i).trans_units;
2478: l_asset_dist_rec.units_assigned := NULL;
2479: l_asset_dist_rec.assigned_to :=

Line 2477: fa_load_tbl_pkg.dist_table(i).trans_units;

2473: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2474: l_asset_dist_rec.distribution_id :=
2475: fa_load_tbl_pkg.dist_table(i).dist_id;
2476: l_asset_dist_rec.transaction_units :=
2477: fa_load_tbl_pkg.dist_table(i).trans_units;
2478: l_asset_dist_rec.units_assigned := NULL;
2479: l_asset_dist_rec.assigned_to :=
2480: fa_load_tbl_pkg.dist_table(i).assigned_to;
2481: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;

Line 2480: fa_load_tbl_pkg.dist_table(i).assigned_to;

2476: l_asset_dist_rec.transaction_units :=
2477: fa_load_tbl_pkg.dist_table(i).trans_units;
2478: l_asset_dist_rec.units_assigned := NULL;
2479: l_asset_dist_rec.assigned_to :=
2480: fa_load_tbl_pkg.dist_table(i).assigned_to;
2481: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
2482: l_asset_dist_rec.location_ccid :=
2483: fa_load_tbl_pkg.dist_table(i).location_id;
2484:

Line 2481: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;

2477: fa_load_tbl_pkg.dist_table(i).trans_units;
2478: l_asset_dist_rec.units_assigned := NULL;
2479: l_asset_dist_rec.assigned_to :=
2480: fa_load_tbl_pkg.dist_table(i).assigned_to;
2481: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
2482: l_asset_dist_rec.location_ccid :=
2483: fa_load_tbl_pkg.dist_table(i).location_id;
2484:
2485: l_asset_dist_tbl(i) := l_asset_dist_rec;

Line 2483: fa_load_tbl_pkg.dist_table(i).location_id;

2479: l_asset_dist_rec.assigned_to :=
2480: fa_load_tbl_pkg.dist_table(i).assigned_to;
2481: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
2482: l_asset_dist_rec.location_ccid :=
2483: fa_load_tbl_pkg.dist_table(i).location_id;
2484:
2485: l_asset_dist_tbl(i) := l_asset_dist_rec;
2486: end if;
2487: end loop;

Line 2497: -- Get the details from fa_load_tbl_pkg.inv_table

2493:
2494: -- ***** Invoice Info ***** --
2495: l_inv_tbl.delete;
2496:
2497: -- Get the details from fa_load_tbl_pkg.inv_table
2498: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2499:
2500: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2501: l_inv_rec.asset_invoice_id :=

Line 2498: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop

2494: -- ***** Invoice Info ***** --
2495: l_inv_tbl.delete;
2496:
2497: -- Get the details from fa_load_tbl_pkg.inv_table
2498: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2499:
2500: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2501: l_inv_rec.asset_invoice_id :=
2502: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

Line 2500: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;

2496:
2497: -- Get the details from fa_load_tbl_pkg.inv_table
2498: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2499:
2500: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2501: l_inv_rec.asset_invoice_id :=
2502: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2503: l_inv_rec.fixed_assets_cost :=
2504: fa_load_tbl_pkg.inv_table(i).inv_new_cost -

Line 2502: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

2498: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2499:
2500: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2501: l_inv_rec.asset_invoice_id :=
2502: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2503: l_inv_rec.fixed_assets_cost :=
2504: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
2505: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
2506: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;

Line 2504: fa_load_tbl_pkg.inv_table(i).inv_new_cost -

2500: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2501: l_inv_rec.asset_invoice_id :=
2502: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2503: l_inv_rec.fixed_assets_cost :=
2504: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
2505: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
2506: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2507: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2508: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;

Line 2505: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);

2501: l_inv_rec.asset_invoice_id :=
2502: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2503: l_inv_rec.fixed_assets_cost :=
2504: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
2505: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
2506: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2507: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2508: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2509: l_inv_rec.payables_batch_name :=

Line 2506: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;

2502: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2503: l_inv_rec.fixed_assets_cost :=
2504: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
2505: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
2506: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2507: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2508: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2509: l_inv_rec.payables_batch_name :=
2510: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

Line 2507: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

2503: l_inv_rec.fixed_assets_cost :=
2504: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
2505: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
2506: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2507: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2508: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2509: l_inv_rec.payables_batch_name :=
2510: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2511: l_inv_rec.payables_code_combination_id :=

Line 2508: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;

2504: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
2505: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
2506: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2507: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2508: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2509: l_inv_rec.payables_batch_name :=
2510: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2511: l_inv_rec.payables_code_combination_id :=
2512: fa_load_tbl_pkg.inv_table(i).payables_ccid;

Line 2510: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

2506: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2507: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2508: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2509: l_inv_rec.payables_batch_name :=
2510: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2511: l_inv_rec.payables_code_combination_id :=
2512: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2513: l_inv_rec.feeder_system_name :=
2514: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

Line 2512: fa_load_tbl_pkg.inv_table(i).payables_ccid;

2508: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2509: l_inv_rec.payables_batch_name :=
2510: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2511: l_inv_rec.payables_code_combination_id :=
2512: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2513: l_inv_rec.feeder_system_name :=
2514: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2515: l_inv_rec.create_batch_date :=
2516: fa_load_tbl_pkg.inv_table(i).create_batch_date;

Line 2514: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

2510: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2511: l_inv_rec.payables_code_combination_id :=
2512: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2513: l_inv_rec.feeder_system_name :=
2514: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2515: l_inv_rec.create_batch_date :=
2516: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2517: l_inv_rec.create_batch_id :=
2518: fa_load_tbl_pkg.inv_table(i).create_batch_id;

Line 2516: fa_load_tbl_pkg.inv_table(i).create_batch_date;

2512: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2513: l_inv_rec.feeder_system_name :=
2514: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2515: l_inv_rec.create_batch_date :=
2516: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2517: l_inv_rec.create_batch_id :=
2518: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2519: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2520: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

Line 2518: fa_load_tbl_pkg.inv_table(i).create_batch_id;

2514: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2515: l_inv_rec.create_batch_date :=
2516: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2517: l_inv_rec.create_batch_id :=
2518: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2519: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2520: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2521: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2522: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

Line 2519: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;

2515: l_inv_rec.create_batch_date :=
2516: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2517: l_inv_rec.create_batch_id :=
2518: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2519: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2520: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2521: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2522: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2523: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

Line 2520: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

2516: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2517: l_inv_rec.create_batch_id :=
2518: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2519: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2520: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2521: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2522: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2523: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2524: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

Line 2521: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;

2517: l_inv_rec.create_batch_id :=
2518: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2519: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2520: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2521: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2522: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2523: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2524: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2525: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

Line 2522: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

2518: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2519: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2520: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2521: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2522: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2523: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2524: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2525: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2526: l_inv_rec.ap_distribution_line_number :=

Line 2523: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

2519: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2520: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2521: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2522: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2523: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2524: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2525: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2526: l_inv_rec.ap_distribution_line_number :=
2527: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

Line 2524: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

2520: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2521: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2522: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2523: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2524: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2525: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2526: l_inv_rec.ap_distribution_line_number :=
2527: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2528: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

Line 2525: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

2521: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2522: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2523: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2524: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2525: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2526: l_inv_rec.ap_distribution_line_number :=
2527: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2528: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2529: --l_inv_rec.split_merged_code :=

Line 2527: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

2523: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2524: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2525: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2526: l_inv_rec.ap_distribution_line_number :=
2527: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2528: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2529: --l_inv_rec.split_merged_code :=
2530: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
2531: --l_inv_rec.parent_mass_additions_id :=

Line 2528: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

2524: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2525: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2526: l_inv_rec.ap_distribution_line_number :=
2527: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2528: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2529: --l_inv_rec.split_merged_code :=
2530: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
2531: --l_inv_rec.parent_mass_additions_id :=
2532: --l_inv_rec.unrevalued_cost :=

Line 2530: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;

2526: l_inv_rec.ap_distribution_line_number :=
2527: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2528: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2529: --l_inv_rec.split_merged_code :=
2530: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
2531: --l_inv_rec.parent_mass_additions_id :=
2532: --l_inv_rec.unrevalued_cost :=
2533: --l_inv_rec.merged_code :=
2534: --l_inv_rec.split_code :=

Line 2538: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;

2534: --l_inv_rec.split_code :=
2535: --l_inv_rec.merge_parent_mass_additions_id :=
2536: --l_inv_rec.split_parent_mass_additions_id :=
2537: l_inv_rec.project_asset_line_id :=
2538: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
2539: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
2540: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2541: l_inv_rec.material_indicator_flag :=
2542: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

Line 2539: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;

2535: --l_inv_rec.merge_parent_mass_additions_id :=
2536: --l_inv_rec.split_parent_mass_additions_id :=
2537: l_inv_rec.project_asset_line_id :=
2538: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
2539: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
2540: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2541: l_inv_rec.material_indicator_flag :=
2542: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2543: l_inv_rec.depreciate_in_group_flag :=

Line 2540: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;

2536: --l_inv_rec.split_parent_mass_additions_id :=
2537: l_inv_rec.project_asset_line_id :=
2538: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
2539: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
2540: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2541: l_inv_rec.material_indicator_flag :=
2542: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2543: l_inv_rec.depreciate_in_group_flag :=
2544: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

Line 2542: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

2538: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
2539: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
2540: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2541: l_inv_rec.material_indicator_flag :=
2542: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2543: l_inv_rec.depreciate_in_group_flag :=
2544: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2545: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2546: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

Line 2544: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

2540: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2541: l_inv_rec.material_indicator_flag :=
2542: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2543: l_inv_rec.depreciate_in_group_flag :=
2544: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2545: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2546: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2547: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2548: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

Line 2545: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;

2541: l_inv_rec.material_indicator_flag :=
2542: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2543: l_inv_rec.depreciate_in_group_flag :=
2544: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2545: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2546: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2547: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2548: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2549: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

Line 2546: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

2542: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2543: l_inv_rec.depreciate_in_group_flag :=
2544: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2545: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2546: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2547: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2548: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2549: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2550: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

Line 2547: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;

2543: l_inv_rec.depreciate_in_group_flag :=
2544: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2545: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2546: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2547: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2548: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2549: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2550: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2551: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

Line 2548: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

2544: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2545: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2546: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2547: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2548: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2549: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2550: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2551: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2552: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

Line 2549: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

2545: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2546: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2547: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2548: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2549: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2550: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2551: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2552: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2553: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

Line 2550: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

2546: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2547: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2548: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2549: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2550: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2551: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2552: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2553: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2554: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

Line 2551: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

2547: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2548: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2549: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2550: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2551: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2552: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2553: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2554: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2555: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

Line 2552: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

2548: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2549: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2550: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2551: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2552: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2553: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2554: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2555: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2556: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

Line 2553: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

2549: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2550: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2551: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2552: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2553: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2554: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2555: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2556: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2557: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

Line 2554: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

2550: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2551: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2552: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2553: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2554: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2555: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2556: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2557: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2558: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

Line 2555: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

2551: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2552: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2553: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2554: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2555: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2556: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2557: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2558: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2559: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

Line 2556: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

2552: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2553: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2554: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2555: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2556: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2557: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2558: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2559: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2560: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

Line 2557: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

2553: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2554: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2555: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2556: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2557: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2558: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2559: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2560: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2561: l_inv_rec.attribute_category_code :=

Line 2558: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

2554: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2555: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2556: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2557: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2558: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2559: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2560: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2561: l_inv_rec.attribute_category_code :=
2562: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

Line 2559: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

2555: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2556: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2557: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2558: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2559: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2560: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2561: l_inv_rec.attribute_category_code :=
2562: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
2563:

Line 2560: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

2556: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2557: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2558: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2559: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2560: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2561: l_inv_rec.attribute_category_code :=
2562: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
2563:
2564: l_inv_tbl(i) := l_inv_rec;

Line 2562: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

2558: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2559: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2560: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2561: l_inv_rec.attribute_category_code :=
2562: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
2563:
2564: l_inv_tbl(i) := l_inv_rec;
2565: end loop;
2566:

Line 2934: -- Get the details from fa_load_tbl_pkg.dist_tbl;

2930:
2931: -- ***** Asset Distribution Info ***** --
2932: l_asset_dist_tbl.delete;
2933:
2934: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2935: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2936: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2937: l_asset_dist_rec.distribution_id :=
2938: fa_load_tbl_pkg.dist_table(i).dist_id;

Line 2935: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop

2931: -- ***** Asset Distribution Info ***** --
2932: l_asset_dist_tbl.delete;
2933:
2934: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2935: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2936: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2937: l_asset_dist_rec.distribution_id :=
2938: fa_load_tbl_pkg.dist_table(i).dist_id;
2939: l_asset_dist_rec.units_assigned :=

Line 2936: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then

2932: l_asset_dist_tbl.delete;
2933:
2934: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2935: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2936: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2937: l_asset_dist_rec.distribution_id :=
2938: fa_load_tbl_pkg.dist_table(i).dist_id;
2939: l_asset_dist_rec.units_assigned :=
2940: fa_load_tbl_pkg.dist_table(i).trans_units;

Line 2938: fa_load_tbl_pkg.dist_table(i).dist_id;

2934: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2935: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2936: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2937: l_asset_dist_rec.distribution_id :=
2938: fa_load_tbl_pkg.dist_table(i).dist_id;
2939: l_asset_dist_rec.units_assigned :=
2940: fa_load_tbl_pkg.dist_table(i).trans_units;
2941: l_asset_dist_rec.transaction_units := NULL;
2942: l_asset_dist_rec.assigned_to :=

Line 2940: fa_load_tbl_pkg.dist_table(i).trans_units;

2936: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2937: l_asset_dist_rec.distribution_id :=
2938: fa_load_tbl_pkg.dist_table(i).dist_id;
2939: l_asset_dist_rec.units_assigned :=
2940: fa_load_tbl_pkg.dist_table(i).trans_units;
2941: l_asset_dist_rec.transaction_units := NULL;
2942: l_asset_dist_rec.assigned_to :=
2943: fa_load_tbl_pkg.dist_table(i).assigned_to;
2944: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;

Line 2943: fa_load_tbl_pkg.dist_table(i).assigned_to;

2939: l_asset_dist_rec.units_assigned :=
2940: fa_load_tbl_pkg.dist_table(i).trans_units;
2941: l_asset_dist_rec.transaction_units := NULL;
2942: l_asset_dist_rec.assigned_to :=
2943: fa_load_tbl_pkg.dist_table(i).assigned_to;
2944: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
2945: l_asset_dist_rec.location_ccid :=
2946: fa_load_tbl_pkg.dist_table(i).location_id;
2947:

Line 2944: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;

2940: fa_load_tbl_pkg.dist_table(i).trans_units;
2941: l_asset_dist_rec.transaction_units := NULL;
2942: l_asset_dist_rec.assigned_to :=
2943: fa_load_tbl_pkg.dist_table(i).assigned_to;
2944: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
2945: l_asset_dist_rec.location_ccid :=
2946: fa_load_tbl_pkg.dist_table(i).location_id;
2947:
2948: l_asset_dist_tbl(i) := l_asset_dist_rec;

Line 2946: fa_load_tbl_pkg.dist_table(i).location_id;

2942: l_asset_dist_rec.assigned_to :=
2943: fa_load_tbl_pkg.dist_table(i).assigned_to;
2944: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
2945: l_asset_dist_rec.location_ccid :=
2946: fa_load_tbl_pkg.dist_table(i).location_id;
2947:
2948: l_asset_dist_tbl(i) := l_asset_dist_rec;
2949: end if;
2950: end loop;

Line 2962: -- Get the details from fa_load_tbl_pkg.inv_table

2958:
2959: -- ***** Invoice Info ***** --
2960: l_inv_tbl.delete;
2961:
2962: -- Get the details from fa_load_tbl_pkg.inv_table
2963: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2964:
2965: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2966: l_inv_rec.asset_invoice_id :=

Line 2963: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop

2959: -- ***** Invoice Info ***** --
2960: l_inv_tbl.delete;
2961:
2962: -- Get the details from fa_load_tbl_pkg.inv_table
2963: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2964:
2965: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2966: l_inv_rec.asset_invoice_id :=
2967: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

Line 2965: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;

2961:
2962: -- Get the details from fa_load_tbl_pkg.inv_table
2963: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2964:
2965: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2966: l_inv_rec.asset_invoice_id :=
2967: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2968: l_inv_rec.fixed_assets_cost :=
2969: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;

Line 2967: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

2963: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2964:
2965: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2966: l_inv_rec.asset_invoice_id :=
2967: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2968: l_inv_rec.fixed_assets_cost :=
2969: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
2970: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2971: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

Line 2969: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;

2965: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2966: l_inv_rec.asset_invoice_id :=
2967: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2968: l_inv_rec.fixed_assets_cost :=
2969: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
2970: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2971: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2972: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2973: l_inv_rec.payables_batch_name :=

Line 2970: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;

2966: l_inv_rec.asset_invoice_id :=
2967: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2968: l_inv_rec.fixed_assets_cost :=
2969: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
2970: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2971: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2972: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2973: l_inv_rec.payables_batch_name :=
2974: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

Line 2971: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

2967: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2968: l_inv_rec.fixed_assets_cost :=
2969: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
2970: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2971: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2972: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2973: l_inv_rec.payables_batch_name :=
2974: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2975: l_inv_rec.payables_code_combination_id :=

Line 2972: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;

2968: l_inv_rec.fixed_assets_cost :=
2969: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
2970: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2971: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2972: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2973: l_inv_rec.payables_batch_name :=
2974: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2975: l_inv_rec.payables_code_combination_id :=
2976: fa_load_tbl_pkg.inv_table(i).payables_ccid;

Line 2974: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

2970: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2971: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2972: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2973: l_inv_rec.payables_batch_name :=
2974: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2975: l_inv_rec.payables_code_combination_id :=
2976: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2977: l_inv_rec.feeder_system_name :=
2978: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

Line 2976: fa_load_tbl_pkg.inv_table(i).payables_ccid;

2972: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2973: l_inv_rec.payables_batch_name :=
2974: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2975: l_inv_rec.payables_code_combination_id :=
2976: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2977: l_inv_rec.feeder_system_name :=
2978: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2979: l_inv_rec.create_batch_date :=
2980: fa_load_tbl_pkg.inv_table(i).create_batch_date;

Line 2978: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

2974: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2975: l_inv_rec.payables_code_combination_id :=
2976: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2977: l_inv_rec.feeder_system_name :=
2978: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2979: l_inv_rec.create_batch_date :=
2980: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2981: l_inv_rec.create_batch_id :=
2982: fa_load_tbl_pkg.inv_table(i).create_batch_id;

Line 2980: fa_load_tbl_pkg.inv_table(i).create_batch_date;

2976: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2977: l_inv_rec.feeder_system_name :=
2978: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2979: l_inv_rec.create_batch_date :=
2980: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2981: l_inv_rec.create_batch_id :=
2982: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2983: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2984: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

Line 2982: fa_load_tbl_pkg.inv_table(i).create_batch_id;

2978: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2979: l_inv_rec.create_batch_date :=
2980: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2981: l_inv_rec.create_batch_id :=
2982: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2983: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2984: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2985: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2986: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

Line 2983: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;

2979: l_inv_rec.create_batch_date :=
2980: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2981: l_inv_rec.create_batch_id :=
2982: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2983: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2984: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2985: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2986: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2987: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

Line 2984: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

2980: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2981: l_inv_rec.create_batch_id :=
2982: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2983: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2984: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2985: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2986: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2987: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2988: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

Line 2985: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;

2981: l_inv_rec.create_batch_id :=
2982: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2983: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2984: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2985: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2986: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2987: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2988: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2989: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

Line 2986: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

2982: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2983: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2984: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2985: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2986: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2987: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2988: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2989: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2990: l_inv_rec.ap_distribution_line_number :=

Line 2987: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

2983: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2984: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2985: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2986: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2987: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2988: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2989: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2990: l_inv_rec.ap_distribution_line_number :=
2991: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

Line 2988: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

2984: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2985: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2986: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2987: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2988: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2989: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2990: l_inv_rec.ap_distribution_line_number :=
2991: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2992: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

Line 2989: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

2985: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2986: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2987: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2988: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2989: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2990: l_inv_rec.ap_distribution_line_number :=
2991: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2992: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2993: --l_inv_rec.split_merged_code :=

Line 2991: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

2987: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2988: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2989: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2990: l_inv_rec.ap_distribution_line_number :=
2991: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2992: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2993: --l_inv_rec.split_merged_code :=
2994: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
2995: --l_inv_rec.parent_mass_additions_id :=

Line 2992: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

2988: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2989: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2990: l_inv_rec.ap_distribution_line_number :=
2991: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2992: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2993: --l_inv_rec.split_merged_code :=
2994: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
2995: --l_inv_rec.parent_mass_additions_id :=
2996: --l_inv_rec.unrevalued_cost :=

Line 2994: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;

2990: l_inv_rec.ap_distribution_line_number :=
2991: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2992: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2993: --l_inv_rec.split_merged_code :=
2994: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
2995: --l_inv_rec.parent_mass_additions_id :=
2996: --l_inv_rec.unrevalued_cost :=
2997: --l_inv_rec.merged_code :=
2998: --l_inv_rec.split_code :=

Line 3002: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;

2998: --l_inv_rec.split_code :=
2999: --l_inv_rec.merge_parent_mass_additions_id :=
3000: --l_inv_rec.split_parent_mass_additions_id :=
3001: l_inv_rec.project_asset_line_id :=
3002: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
3003: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
3004: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3005: l_inv_rec.material_indicator_flag :=
3006: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

Line 3003: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;

2999: --l_inv_rec.merge_parent_mass_additions_id :=
3000: --l_inv_rec.split_parent_mass_additions_id :=
3001: l_inv_rec.project_asset_line_id :=
3002: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
3003: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
3004: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3005: l_inv_rec.material_indicator_flag :=
3006: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3007: l_inv_rec.depreciate_in_group_flag :=

Line 3004: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;

3000: --l_inv_rec.split_parent_mass_additions_id :=
3001: l_inv_rec.project_asset_line_id :=
3002: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
3003: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
3004: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3005: l_inv_rec.material_indicator_flag :=
3006: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3007: l_inv_rec.depreciate_in_group_flag :=
3008: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

Line 3006: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

3002: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
3003: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
3004: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3005: l_inv_rec.material_indicator_flag :=
3006: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3007: l_inv_rec.depreciate_in_group_flag :=
3008: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3009: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3010: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

Line 3008: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

3004: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3005: l_inv_rec.material_indicator_flag :=
3006: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3007: l_inv_rec.depreciate_in_group_flag :=
3008: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3009: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3010: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3011: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3012: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

Line 3009: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;

3005: l_inv_rec.material_indicator_flag :=
3006: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3007: l_inv_rec.depreciate_in_group_flag :=
3008: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3009: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3010: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3011: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3012: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3013: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

Line 3010: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

3006: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3007: l_inv_rec.depreciate_in_group_flag :=
3008: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3009: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3010: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3011: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3012: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3013: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3014: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

Line 3011: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;

3007: l_inv_rec.depreciate_in_group_flag :=
3008: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3009: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3010: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3011: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3012: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3013: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3014: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3015: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

Line 3012: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

3008: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3009: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3010: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3011: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3012: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3013: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3014: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3015: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3016: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

Line 3013: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

3009: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3010: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3011: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3012: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3013: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3014: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3015: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3016: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3017: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

Line 3014: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

3010: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3011: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3012: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3013: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3014: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3015: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3016: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3017: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3018: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

Line 3015: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

3011: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3012: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3013: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3014: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3015: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3016: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3017: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3018: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3019: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

Line 3016: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

3012: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3013: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3014: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3015: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3016: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3017: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3018: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3019: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3020: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

Line 3017: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

3013: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3014: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3015: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3016: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3017: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3018: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3019: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3020: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3021: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

Line 3018: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

3014: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3015: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3016: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3017: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3018: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3019: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3020: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3021: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3022: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

Line 3019: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

3015: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3016: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3017: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3018: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3019: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3020: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3021: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3022: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3023: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

Line 3020: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

3016: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3017: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3018: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3019: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3020: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3021: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3022: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3023: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
3024: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

Line 3021: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

3017: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3018: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3019: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3020: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3021: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3022: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3023: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
3024: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
3025: l_inv_rec.attribute_category_code :=

Line 3022: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

3018: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3019: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3020: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3021: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3022: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3023: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
3024: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
3025: l_inv_rec.attribute_category_code :=
3026: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

Line 3023: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

3019: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3020: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3021: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3022: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3023: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
3024: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
3025: l_inv_rec.attribute_category_code :=
3026: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
3027:

Line 3024: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

3020: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3021: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3022: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3023: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
3024: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
3025: l_inv_rec.attribute_category_code :=
3026: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
3027:
3028: l_inv_tbl(i) := l_inv_rec;

Line 3026: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

3022: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3023: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
3024: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
3025: l_inv_rec.attribute_category_code :=
3026: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
3027:
3028: l_inv_tbl(i) := l_inv_rec;
3029: end loop;
3030:

Line 3945: -- Get the details from fa_load_tbl_pkg.inv_table

3941:
3942: -- ***** Invoice Info ***** --
3943: l_inv_tbl.delete;
3944:
3945: -- Get the details from fa_load_tbl_pkg.inv_table
3946: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
3947:
3948: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
3949: l_inv_rec.asset_invoice_id :=

Line 3946: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop

3942: -- ***** Invoice Info ***** --
3943: l_inv_tbl.delete;
3944:
3945: -- Get the details from fa_load_tbl_pkg.inv_table
3946: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
3947:
3948: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
3949: l_inv_rec.asset_invoice_id :=
3950: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

Line 3948: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;

3944:
3945: -- Get the details from fa_load_tbl_pkg.inv_table
3946: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
3947:
3948: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
3949: l_inv_rec.asset_invoice_id :=
3950: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
3951: l_inv_rec.fixed_assets_cost :=
3952: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;

Line 3950: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

3946: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
3947:
3948: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
3949: l_inv_rec.asset_invoice_id :=
3950: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
3951: l_inv_rec.fixed_assets_cost :=
3952: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
3953: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
3954: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

Line 3952: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;

3948: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
3949: l_inv_rec.asset_invoice_id :=
3950: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
3951: l_inv_rec.fixed_assets_cost :=
3952: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
3953: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
3954: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
3955: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
3956: l_inv_rec.payables_batch_name :=

Line 3953: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;

3949: l_inv_rec.asset_invoice_id :=
3950: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
3951: l_inv_rec.fixed_assets_cost :=
3952: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
3953: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
3954: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
3955: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
3956: l_inv_rec.payables_batch_name :=
3957: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

Line 3954: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

3950: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
3951: l_inv_rec.fixed_assets_cost :=
3952: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
3953: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
3954: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
3955: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
3956: l_inv_rec.payables_batch_name :=
3957: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
3958: l_inv_rec.payables_code_combination_id :=

Line 3955: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;

3951: l_inv_rec.fixed_assets_cost :=
3952: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
3953: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
3954: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
3955: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
3956: l_inv_rec.payables_batch_name :=
3957: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
3958: l_inv_rec.payables_code_combination_id :=
3959: fa_load_tbl_pkg.inv_table(i).payables_ccid;

Line 3957: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

3953: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
3954: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
3955: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
3956: l_inv_rec.payables_batch_name :=
3957: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
3958: l_inv_rec.payables_code_combination_id :=
3959: fa_load_tbl_pkg.inv_table(i).payables_ccid;
3960: l_inv_rec.feeder_system_name :=
3961: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

Line 3959: fa_load_tbl_pkg.inv_table(i).payables_ccid;

3955: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
3956: l_inv_rec.payables_batch_name :=
3957: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
3958: l_inv_rec.payables_code_combination_id :=
3959: fa_load_tbl_pkg.inv_table(i).payables_ccid;
3960: l_inv_rec.feeder_system_name :=
3961: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
3962: l_inv_rec.create_batch_date :=
3963: fa_load_tbl_pkg.inv_table(i).create_batch_date;

Line 3961: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

3957: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
3958: l_inv_rec.payables_code_combination_id :=
3959: fa_load_tbl_pkg.inv_table(i).payables_ccid;
3960: l_inv_rec.feeder_system_name :=
3961: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
3962: l_inv_rec.create_batch_date :=
3963: fa_load_tbl_pkg.inv_table(i).create_batch_date;
3964: l_inv_rec.create_batch_id :=
3965: fa_load_tbl_pkg.inv_table(i).create_batch_id;

Line 3963: fa_load_tbl_pkg.inv_table(i).create_batch_date;

3959: fa_load_tbl_pkg.inv_table(i).payables_ccid;
3960: l_inv_rec.feeder_system_name :=
3961: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
3962: l_inv_rec.create_batch_date :=
3963: fa_load_tbl_pkg.inv_table(i).create_batch_date;
3964: l_inv_rec.create_batch_id :=
3965: fa_load_tbl_pkg.inv_table(i).create_batch_id;
3966: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3967: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

Line 3965: fa_load_tbl_pkg.inv_table(i).create_batch_id;

3961: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
3962: l_inv_rec.create_batch_date :=
3963: fa_load_tbl_pkg.inv_table(i).create_batch_date;
3964: l_inv_rec.create_batch_id :=
3965: fa_load_tbl_pkg.inv_table(i).create_batch_id;
3966: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3967: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3968: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3969: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

Line 3966: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;

3962: l_inv_rec.create_batch_date :=
3963: fa_load_tbl_pkg.inv_table(i).create_batch_date;
3964: l_inv_rec.create_batch_id :=
3965: fa_load_tbl_pkg.inv_table(i).create_batch_id;
3966: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3967: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3968: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3969: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3970: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

Line 3967: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

3963: fa_load_tbl_pkg.inv_table(i).create_batch_date;
3964: l_inv_rec.create_batch_id :=
3965: fa_load_tbl_pkg.inv_table(i).create_batch_id;
3966: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3967: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3968: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3969: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3970: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3971: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

Line 3968: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;

3964: l_inv_rec.create_batch_id :=
3965: fa_load_tbl_pkg.inv_table(i).create_batch_id;
3966: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3967: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3968: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3969: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3970: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3971: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3972: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

Line 3969: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

3965: fa_load_tbl_pkg.inv_table(i).create_batch_id;
3966: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3967: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3968: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3969: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3970: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3971: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3972: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
3973: l_inv_rec.ap_distribution_line_number :=

Line 3970: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

3966: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3967: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3968: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3969: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3970: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3971: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3972: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
3973: l_inv_rec.ap_distribution_line_number :=
3974: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

Line 3971: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

3967: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3968: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3969: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3970: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3971: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3972: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
3973: l_inv_rec.ap_distribution_line_number :=
3974: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
3975: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

Line 3972: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

3968: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3969: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3970: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3971: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3972: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
3973: l_inv_rec.ap_distribution_line_number :=
3974: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
3975: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
3976: --l_inv_rec.split_merged_code :=

Line 3974: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

3970: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3971: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3972: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
3973: l_inv_rec.ap_distribution_line_number :=
3974: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
3975: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
3976: --l_inv_rec.split_merged_code :=
3977: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
3978: --l_inv_rec.parent_mass_additions_id :=

Line 3975: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

3971: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3972: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
3973: l_inv_rec.ap_distribution_line_number :=
3974: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
3975: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
3976: --l_inv_rec.split_merged_code :=
3977: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
3978: --l_inv_rec.parent_mass_additions_id :=
3979: --l_inv_rec.unrevalued_cost :=

Line 3977: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;

3973: l_inv_rec.ap_distribution_line_number :=
3974: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
3975: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
3976: --l_inv_rec.split_merged_code :=
3977: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
3978: --l_inv_rec.parent_mass_additions_id :=
3979: --l_inv_rec.unrevalued_cost :=
3980: --l_inv_rec.merged_code :=
3981: --l_inv_rec.split_code :=

Line 3985: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;

3981: --l_inv_rec.split_code :=
3982: --l_inv_rec.merge_parent_mass_additions_id :=
3983: --l_inv_rec.split_parent_mass_additions_id :=
3984: l_inv_rec.project_asset_line_id :=
3985: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
3986: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
3987: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3988: l_inv_rec.material_indicator_flag :=
3989: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

Line 3986: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;

3982: --l_inv_rec.merge_parent_mass_additions_id :=
3983: --l_inv_rec.split_parent_mass_additions_id :=
3984: l_inv_rec.project_asset_line_id :=
3985: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
3986: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
3987: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3988: l_inv_rec.material_indicator_flag :=
3989: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3990: l_inv_rec.depreciate_in_group_flag :=

Line 3987: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;

3983: --l_inv_rec.split_parent_mass_additions_id :=
3984: l_inv_rec.project_asset_line_id :=
3985: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
3986: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
3987: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3988: l_inv_rec.material_indicator_flag :=
3989: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3990: l_inv_rec.depreciate_in_group_flag :=
3991: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

Line 3989: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

3985: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
3986: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
3987: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3988: l_inv_rec.material_indicator_flag :=
3989: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3990: l_inv_rec.depreciate_in_group_flag :=
3991: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3992: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3993: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

Line 3991: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

3987: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3988: l_inv_rec.material_indicator_flag :=
3989: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3990: l_inv_rec.depreciate_in_group_flag :=
3991: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3992: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3993: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3994: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3995: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

Line 3992: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;

3988: l_inv_rec.material_indicator_flag :=
3989: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3990: l_inv_rec.depreciate_in_group_flag :=
3991: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3992: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3993: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3994: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3995: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3996: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

Line 3993: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

3989: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3990: l_inv_rec.depreciate_in_group_flag :=
3991: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3992: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3993: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3994: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3995: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3996: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3997: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

Line 3994: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;

3990: l_inv_rec.depreciate_in_group_flag :=
3991: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3992: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3993: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3994: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3995: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3996: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3997: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3998: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

Line 3995: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

3991: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3992: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3993: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3994: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3995: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3996: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3997: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3998: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3999: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

Line 3996: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

3992: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3993: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3994: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3995: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3996: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3997: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3998: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3999: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
4000: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

Line 3997: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

3993: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3994: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3995: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3996: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3997: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3998: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3999: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
4000: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
4001: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

Line 3998: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

3994: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3995: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3996: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3997: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3998: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3999: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
4000: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
4001: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
4002: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

Line 3999: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

3995: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3996: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3997: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3998: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3999: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
4000: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
4001: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
4002: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
4003: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

Line 4000: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

3996: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3997: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3998: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3999: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
4000: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
4001: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
4002: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
4003: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
4004: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

Line 4001: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

3997: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3998: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3999: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
4000: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
4001: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
4002: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
4003: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
4004: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
4005: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

Line 4002: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

3998: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3999: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
4000: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
4001: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
4002: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
4003: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
4004: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
4005: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
4006: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

Line 4003: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

3999: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
4000: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
4001: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
4002: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
4003: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
4004: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
4005: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
4006: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
4007: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

Line 4004: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

4000: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
4001: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
4002: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
4003: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
4004: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
4005: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
4006: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
4007: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
4008: l_inv_rec.attribute_category_code :=

Line 4005: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

4001: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
4002: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
4003: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
4004: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
4005: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
4006: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
4007: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
4008: l_inv_rec.attribute_category_code :=
4009: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

Line 4006: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

4002: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
4003: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
4004: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
4005: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
4006: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
4007: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
4008: l_inv_rec.attribute_category_code :=
4009: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
4010:

Line 4007: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

4003: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
4004: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
4005: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
4006: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
4007: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
4008: l_inv_rec.attribute_category_code :=
4009: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
4010:
4011: if (p_reset_miss_flag = 'YES') then

Line 4009: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

4005: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
4006: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
4007: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
4008: l_inv_rec.attribute_category_code :=
4009: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
4010:
4011: if (p_reset_miss_flag = 'YES') then
4012: -- Fix for Bug #2653564. Need to pass different record groups to
4013: -- IN and OUT parameters.