APPS.FA_TRANS_API_PUB dependencies on FA_LOAD_TBL_PKG

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

574:
575: -- ***** Asset Distribution Info ***** --
576: l_asset_dist_tbl.delete;
577:
578: -- Get the details from fa_load_tbl_pkg.dist_table
579: for i in 1 .. fa_load_tbl_pkg.dist_table.count loop
580: if (fa_load_tbl_pkg.dist_table(i).record_status = 'INSERT') then
581: l_asset_dist_rec.distribution_id :=
582: fa_load_tbl_pkg.dist_table(i).dist_id;

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

575: -- ***** Asset Distribution Info ***** --
576: l_asset_dist_tbl.delete;
577:
578: -- Get the details from fa_load_tbl_pkg.dist_table
579: for i in 1 .. fa_load_tbl_pkg.dist_table.count loop
580: if (fa_load_tbl_pkg.dist_table(i).record_status = 'INSERT') then
581: l_asset_dist_rec.distribution_id :=
582: fa_load_tbl_pkg.dist_table(i).dist_id;
583: l_asset_dist_rec.units_assigned :=

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

576: l_asset_dist_tbl.delete;
577:
578: -- Get the details from fa_load_tbl_pkg.dist_table
579: for i in 1 .. fa_load_tbl_pkg.dist_table.count loop
580: if (fa_load_tbl_pkg.dist_table(i).record_status = 'INSERT') then
581: l_asset_dist_rec.distribution_id :=
582: fa_load_tbl_pkg.dist_table(i).dist_id;
583: l_asset_dist_rec.units_assigned :=
584: fa_load_tbl_pkg.dist_table(i).trans_units;

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

578: -- Get the details from fa_load_tbl_pkg.dist_table
579: for i in 1 .. fa_load_tbl_pkg.dist_table.count loop
580: if (fa_load_tbl_pkg.dist_table(i).record_status = 'INSERT') then
581: l_asset_dist_rec.distribution_id :=
582: fa_load_tbl_pkg.dist_table(i).dist_id;
583: l_asset_dist_rec.units_assigned :=
584: fa_load_tbl_pkg.dist_table(i).trans_units;
585: l_asset_dist_rec.transaction_units := NULL;
586: l_asset_dist_rec.assigned_to :=

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

580: if (fa_load_tbl_pkg.dist_table(i).record_status = 'INSERT') then
581: l_asset_dist_rec.distribution_id :=
582: fa_load_tbl_pkg.dist_table(i).dist_id;
583: l_asset_dist_rec.units_assigned :=
584: fa_load_tbl_pkg.dist_table(i).trans_units;
585: l_asset_dist_rec.transaction_units := NULL;
586: l_asset_dist_rec.assigned_to :=
587: fa_load_tbl_pkg.dist_table(i).assigned_to;
588: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;

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

583: l_asset_dist_rec.units_assigned :=
584: fa_load_tbl_pkg.dist_table(i).trans_units;
585: l_asset_dist_rec.transaction_units := NULL;
586: l_asset_dist_rec.assigned_to :=
587: fa_load_tbl_pkg.dist_table(i).assigned_to;
588: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
589: l_asset_dist_rec.location_ccid :=
590: fa_load_tbl_pkg.dist_table(i).location_id;
591:

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

584: fa_load_tbl_pkg.dist_table(i).trans_units;
585: l_asset_dist_rec.transaction_units := NULL;
586: l_asset_dist_rec.assigned_to :=
587: fa_load_tbl_pkg.dist_table(i).assigned_to;
588: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
589: l_asset_dist_rec.location_ccid :=
590: fa_load_tbl_pkg.dist_table(i).location_id;
591:
592: l_asset_dist_tbl(i) := l_asset_dist_rec;

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

586: l_asset_dist_rec.assigned_to :=
587: fa_load_tbl_pkg.dist_table(i).assigned_to;
588: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
589: l_asset_dist_rec.location_ccid :=
590: fa_load_tbl_pkg.dist_table(i).location_id;
591:
592: l_asset_dist_tbl(i) := l_asset_dist_rec;
593: end if;
594: end loop;

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

595:
596: -- ***** Invoice Info ***** --
597: l_inv_tbl.delete;
598:
599: -- Get the details from fa_load_tbl_pkg.inv_table
600: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
601:
602: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
603: l_inv_rec.asset_invoice_id :=

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

596: -- ***** Invoice Info ***** --
597: l_inv_tbl.delete;
598:
599: -- Get the details from fa_load_tbl_pkg.inv_table
600: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
601:
602: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
603: l_inv_rec.asset_invoice_id :=
604: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

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

598:
599: -- Get the details from fa_load_tbl_pkg.inv_table
600: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
601:
602: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
603: l_inv_rec.asset_invoice_id :=
604: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
605: l_inv_rec.fixed_assets_cost :=
606: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;

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

600: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
601:
602: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
603: l_inv_rec.asset_invoice_id :=
604: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
605: l_inv_rec.fixed_assets_cost :=
606: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
607: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
608: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

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

602: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
603: l_inv_rec.asset_invoice_id :=
604: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
605: l_inv_rec.fixed_assets_cost :=
606: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
607: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
608: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
609: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
610: l_inv_rec.payables_batch_name :=

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

603: l_inv_rec.asset_invoice_id :=
604: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
605: l_inv_rec.fixed_assets_cost :=
606: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
607: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
608: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
609: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
610: l_inv_rec.payables_batch_name :=
611: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

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

604: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
605: l_inv_rec.fixed_assets_cost :=
606: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
607: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
608: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
609: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
610: l_inv_rec.payables_batch_name :=
611: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
612: l_inv_rec.payables_code_combination_id :=

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

605: l_inv_rec.fixed_assets_cost :=
606: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
607: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
608: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
609: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
610: l_inv_rec.payables_batch_name :=
611: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
612: l_inv_rec.payables_code_combination_id :=
613: fa_load_tbl_pkg.inv_table(i).payables_ccid;

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

607: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
608: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
609: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
610: l_inv_rec.payables_batch_name :=
611: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
612: l_inv_rec.payables_code_combination_id :=
613: fa_load_tbl_pkg.inv_table(i).payables_ccid;
614: l_inv_rec.feeder_system_name :=
615: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

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

609: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
610: l_inv_rec.payables_batch_name :=
611: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
612: l_inv_rec.payables_code_combination_id :=
613: fa_load_tbl_pkg.inv_table(i).payables_ccid;
614: l_inv_rec.feeder_system_name :=
615: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
616: l_inv_rec.create_batch_date :=
617: fa_load_tbl_pkg.inv_table(i).create_batch_date;

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

611: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
612: l_inv_rec.payables_code_combination_id :=
613: fa_load_tbl_pkg.inv_table(i).payables_ccid;
614: l_inv_rec.feeder_system_name :=
615: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
616: l_inv_rec.create_batch_date :=
617: fa_load_tbl_pkg.inv_table(i).create_batch_date;
618: l_inv_rec.create_batch_id :=
619: fa_load_tbl_pkg.inv_table(i).create_batch_id;

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

613: fa_load_tbl_pkg.inv_table(i).payables_ccid;
614: l_inv_rec.feeder_system_name :=
615: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
616: l_inv_rec.create_batch_date :=
617: fa_load_tbl_pkg.inv_table(i).create_batch_date;
618: l_inv_rec.create_batch_id :=
619: fa_load_tbl_pkg.inv_table(i).create_batch_id;
620: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
621: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

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

615: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
616: l_inv_rec.create_batch_date :=
617: fa_load_tbl_pkg.inv_table(i).create_batch_date;
618: l_inv_rec.create_batch_id :=
619: fa_load_tbl_pkg.inv_table(i).create_batch_id;
620: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
621: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
622: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
623: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

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

616: l_inv_rec.create_batch_date :=
617: fa_load_tbl_pkg.inv_table(i).create_batch_date;
618: l_inv_rec.create_batch_id :=
619: fa_load_tbl_pkg.inv_table(i).create_batch_id;
620: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
621: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
622: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
623: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
624: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

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

617: fa_load_tbl_pkg.inv_table(i).create_batch_date;
618: l_inv_rec.create_batch_id :=
619: fa_load_tbl_pkg.inv_table(i).create_batch_id;
620: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
621: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
622: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
623: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
624: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
625: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

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

618: l_inv_rec.create_batch_id :=
619: fa_load_tbl_pkg.inv_table(i).create_batch_id;
620: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
621: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
622: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
623: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
624: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
625: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
626: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

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

619: fa_load_tbl_pkg.inv_table(i).create_batch_id;
620: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
621: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
622: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
623: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
624: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
625: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
626: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
627: l_inv_rec.ap_distribution_line_number :=

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

620: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
621: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
622: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
623: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
624: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
625: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
626: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
627: l_inv_rec.ap_distribution_line_number :=
628: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

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

621: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
622: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
623: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
624: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
625: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
626: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
627: l_inv_rec.ap_distribution_line_number :=
628: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
629: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

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

622: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
623: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
624: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
625: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
626: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
627: l_inv_rec.ap_distribution_line_number :=
628: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
629: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
630: --l_inv_rec.split_merged_code :=

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

624: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
625: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
626: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
627: l_inv_rec.ap_distribution_line_number :=
628: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
629: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
630: --l_inv_rec.split_merged_code :=
631: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
632: --l_inv_rec.parent_mass_additions_id :=

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

625: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
626: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
627: l_inv_rec.ap_distribution_line_number :=
628: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
629: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
630: --l_inv_rec.split_merged_code :=
631: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
632: --l_inv_rec.parent_mass_additions_id :=
633: --l_inv_rec.unrevalued_cost :=

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

627: l_inv_rec.ap_distribution_line_number :=
628: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
629: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
630: --l_inv_rec.split_merged_code :=
631: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
632: --l_inv_rec.parent_mass_additions_id :=
633: --l_inv_rec.unrevalued_cost :=
634: --l_inv_rec.merged_code :=
635: --l_inv_rec.split_code :=

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

635: --l_inv_rec.split_code :=
636: --l_inv_rec.merge_parent_mass_additions_id :=
637: --l_inv_rec.split_parent_mass_additions_id :=
638: l_inv_rec.project_asset_line_id :=
639: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
640: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
641: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
642: l_inv_rec.material_indicator_flag :=
643: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

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

636: --l_inv_rec.merge_parent_mass_additions_id :=
637: --l_inv_rec.split_parent_mass_additions_id :=
638: l_inv_rec.project_asset_line_id :=
639: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
640: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
641: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
642: l_inv_rec.material_indicator_flag :=
643: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
644: l_inv_rec.depreciate_in_group_flag :=

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

637: --l_inv_rec.split_parent_mass_additions_id :=
638: l_inv_rec.project_asset_line_id :=
639: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
640: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
641: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
642: l_inv_rec.material_indicator_flag :=
643: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
644: l_inv_rec.depreciate_in_group_flag :=
645: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

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

639: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
640: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
641: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
642: l_inv_rec.material_indicator_flag :=
643: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
644: l_inv_rec.depreciate_in_group_flag :=
645: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
646: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
647: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

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

641: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
642: l_inv_rec.material_indicator_flag :=
643: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
644: l_inv_rec.depreciate_in_group_flag :=
645: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
646: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
647: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
648: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
649: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;

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

642: l_inv_rec.material_indicator_flag :=
643: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
644: l_inv_rec.depreciate_in_group_flag :=
645: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
646: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
647: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
648: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
649: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
650: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

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

643: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
644: l_inv_rec.depreciate_in_group_flag :=
645: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
646: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
647: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
648: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
649: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
650: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
651: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

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

644: l_inv_rec.depreciate_in_group_flag :=
645: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
646: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
647: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
648: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
649: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
650: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
651: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
652: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

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

645: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
646: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
647: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
648: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
649: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
650: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
651: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
652: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
653: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

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

646: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
647: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
648: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
649: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
650: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
651: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
652: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
653: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
654: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

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

647: l_inv_rec.depreciate_in_group_flag := fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
648: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
649: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
650: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
651: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
652: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
653: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
654: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
655: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

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

648: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
649: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
650: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
651: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
652: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
653: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
654: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
655: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
656: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

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

649: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
650: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
651: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
652: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
653: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
654: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
655: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
656: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
657: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

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

650: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
651: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
652: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
653: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
654: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
655: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
656: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
657: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
658: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

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

651: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
652: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
653: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
654: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
655: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
656: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
657: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
658: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
659: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

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

652: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
653: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
654: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
655: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
656: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
657: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
658: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
659: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
660: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

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

653: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
654: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
655: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
656: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
657: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
658: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
659: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
660: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
661: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

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

654: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
655: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
656: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
657: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
658: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
659: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
660: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
661: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
662: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

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

655: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
656: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
657: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
658: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
659: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
660: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
661: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
662: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
663: l_inv_rec.attribute_category_code :=

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

656: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
657: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
658: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
659: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
660: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
661: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
662: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
663: l_inv_rec.attribute_category_code :=
664: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

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

657: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
658: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
659: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
660: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
661: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
662: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
663: l_inv_rec.attribute_category_code :=
664: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
665:

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

658: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
659: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
660: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
661: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
662: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
663: l_inv_rec.attribute_category_code :=
664: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
665:
666: l_inv_tbl(i) := l_inv_rec;

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

660: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
661: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
662: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
663: l_inv_rec.attribute_category_code :=
664: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
665:
666: l_inv_tbl(i) := l_inv_rec;
667: end loop;
668:

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

1194:
1195: -- ***** Invoice Information ***** --
1196: l_inv_tbl.delete;
1197:
1198: -- Get the details from fa_load_tbl_pkg.inv_table
1199: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1200:
1201: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1202: l_inv_rec.asset_invoice_id :=

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

1195: -- ***** Invoice Information ***** --
1196: l_inv_tbl.delete;
1197:
1198: -- Get the details from fa_load_tbl_pkg.inv_table
1199: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1200:
1201: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1202: l_inv_rec.asset_invoice_id :=
1203: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

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

1197:
1198: -- Get the details from fa_load_tbl_pkg.inv_table
1199: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1200:
1201: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1202: l_inv_rec.asset_invoice_id :=
1203: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1204: l_inv_rec.fixed_assets_cost :=
1205: fa_load_tbl_pkg.inv_table(i).inv_new_cost -

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

1199: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1200:
1201: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1202: l_inv_rec.asset_invoice_id :=
1203: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1204: l_inv_rec.fixed_assets_cost :=
1205: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
1206: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
1207: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;

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

1201: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1202: l_inv_rec.asset_invoice_id :=
1203: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1204: l_inv_rec.fixed_assets_cost :=
1205: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
1206: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
1207: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1208: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1209: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;

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

1202: l_inv_rec.asset_invoice_id :=
1203: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1204: l_inv_rec.fixed_assets_cost :=
1205: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
1206: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
1207: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1208: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1209: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1210: l_inv_rec.payables_batch_name :=

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

1203: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1204: l_inv_rec.fixed_assets_cost :=
1205: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
1206: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
1207: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1208: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1209: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1210: l_inv_rec.payables_batch_name :=
1211: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

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

1204: l_inv_rec.fixed_assets_cost :=
1205: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
1206: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
1207: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1208: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1209: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1210: l_inv_rec.payables_batch_name :=
1211: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1212: l_inv_rec.payables_code_combination_id :=

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

1205: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
1206: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
1207: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1208: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1209: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1210: l_inv_rec.payables_batch_name :=
1211: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1212: l_inv_rec.payables_code_combination_id :=
1213: fa_load_tbl_pkg.inv_table(i).payables_ccid;

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

1207: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1208: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1209: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1210: l_inv_rec.payables_batch_name :=
1211: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1212: l_inv_rec.payables_code_combination_id :=
1213: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1214: l_inv_rec.feeder_system_name :=
1215: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

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

1209: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1210: l_inv_rec.payables_batch_name :=
1211: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1212: l_inv_rec.payables_code_combination_id :=
1213: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1214: l_inv_rec.feeder_system_name :=
1215: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1216: l_inv_rec.create_batch_date :=
1217: fa_load_tbl_pkg.inv_table(i).create_batch_date;

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

1211: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1212: l_inv_rec.payables_code_combination_id :=
1213: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1214: l_inv_rec.feeder_system_name :=
1215: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1216: l_inv_rec.create_batch_date :=
1217: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1218: l_inv_rec.create_batch_id :=
1219: fa_load_tbl_pkg.inv_table(i).create_batch_id;

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

1213: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1214: l_inv_rec.feeder_system_name :=
1215: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1216: l_inv_rec.create_batch_date :=
1217: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1218: l_inv_rec.create_batch_id :=
1219: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1220: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1221: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

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

1215: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1216: l_inv_rec.create_batch_date :=
1217: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1218: l_inv_rec.create_batch_id :=
1219: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1220: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1221: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1222: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1223: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

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

1216: l_inv_rec.create_batch_date :=
1217: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1218: l_inv_rec.create_batch_id :=
1219: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1220: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1221: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1222: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1223: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1224: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

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

1217: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1218: l_inv_rec.create_batch_id :=
1219: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1220: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1221: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1222: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1223: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1224: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1225: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

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

1218: l_inv_rec.create_batch_id :=
1219: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1220: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1221: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1222: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1223: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1224: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1225: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1226: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

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

1219: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1220: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1221: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1222: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1223: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1224: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1225: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1226: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1227: l_inv_rec.ap_distribution_line_number :=

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

1220: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1221: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1222: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1223: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1224: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1225: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1226: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1227: l_inv_rec.ap_distribution_line_number :=
1228: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

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

1221: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1222: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1223: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1224: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1225: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1226: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1227: l_inv_rec.ap_distribution_line_number :=
1228: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1229: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

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

1222: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1223: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1224: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1225: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1226: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1227: l_inv_rec.ap_distribution_line_number :=
1228: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1229: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1230: --l_inv_rec.split_merged_code :=

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

1224: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1225: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1226: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1227: l_inv_rec.ap_distribution_line_number :=
1228: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1229: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1230: --l_inv_rec.split_merged_code :=
1231: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
1232: --l_inv_rec.parent_mass_additions_id :=

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

1225: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1226: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1227: l_inv_rec.ap_distribution_line_number :=
1228: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1229: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1230: --l_inv_rec.split_merged_code :=
1231: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
1232: --l_inv_rec.parent_mass_additions_id :=
1233: --l_inv_rec.unrevalued_cost :=

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

1227: l_inv_rec.ap_distribution_line_number :=
1228: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1229: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1230: --l_inv_rec.split_merged_code :=
1231: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
1232: --l_inv_rec.parent_mass_additions_id :=
1233: --l_inv_rec.unrevalued_cost :=
1234: --l_inv_rec.merged_code :=
1235: --l_inv_rec.split_code :=

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

1235: --l_inv_rec.split_code :=
1236: --l_inv_rec.merge_parent_mass_additions_id :=
1237: --l_inv_rec.split_parent_mass_additions_id :=
1238: l_inv_rec.project_asset_line_id :=
1239: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1240: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1241: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1242: l_inv_rec.material_indicator_flag :=
1243: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

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

1236: --l_inv_rec.merge_parent_mass_additions_id :=
1237: --l_inv_rec.split_parent_mass_additions_id :=
1238: l_inv_rec.project_asset_line_id :=
1239: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1240: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1241: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1242: l_inv_rec.material_indicator_flag :=
1243: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1244: l_inv_rec.depreciate_in_group_flag :=

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

1237: --l_inv_rec.split_parent_mass_additions_id :=
1238: l_inv_rec.project_asset_line_id :=
1239: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1240: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1241: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1242: l_inv_rec.material_indicator_flag :=
1243: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1244: l_inv_rec.depreciate_in_group_flag :=
1245: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

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

1239: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1240: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1241: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1242: l_inv_rec.material_indicator_flag :=
1243: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1244: l_inv_rec.depreciate_in_group_flag :=
1245: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1246: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1247: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

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

1241: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1242: l_inv_rec.material_indicator_flag :=
1243: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1244: l_inv_rec.depreciate_in_group_flag :=
1245: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1246: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1247: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1248: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1249: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

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

1242: l_inv_rec.material_indicator_flag :=
1243: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1244: l_inv_rec.depreciate_in_group_flag :=
1245: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1246: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1247: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1248: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1249: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1250: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

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

1243: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1244: l_inv_rec.depreciate_in_group_flag :=
1245: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1246: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1247: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1248: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1249: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1250: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1251: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

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

1244: l_inv_rec.depreciate_in_group_flag :=
1245: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1246: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1247: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1248: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1249: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1250: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1251: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1252: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

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

1245: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1246: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1247: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1248: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1249: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1250: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1251: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1252: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1253: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

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

1246: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1247: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1248: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1249: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1250: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1251: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1252: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1253: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1254: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

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

1247: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1248: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1249: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1250: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1251: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1252: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1253: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1254: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1255: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

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

1248: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1249: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1250: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1251: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1252: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1253: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1254: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1255: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1256: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

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

1249: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1250: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1251: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1252: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1253: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1254: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1255: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1256: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1257: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

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

1250: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1251: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1252: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1253: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1254: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1255: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1256: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1257: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1258: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

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

1251: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1252: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1253: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1254: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1255: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1256: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1257: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1258: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1259: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

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

1252: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1253: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1254: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1255: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1256: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1257: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1258: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1259: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1260: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

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

1253: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1254: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1255: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1256: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1257: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1258: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1259: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1260: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1261: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

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

1254: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1255: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1256: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1257: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1258: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1259: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1260: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1261: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1262: l_inv_rec.attribute_category_code :=

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

1255: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1256: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1257: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1258: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1259: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1260: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1261: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1262: l_inv_rec.attribute_category_code :=
1263: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

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

1256: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1257: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1258: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1259: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1260: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1261: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1262: l_inv_rec.attribute_category_code :=
1263: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
1264:

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

1257: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1258: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1259: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1260: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1261: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1262: l_inv_rec.attribute_category_code :=
1263: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
1264:
1265: if ((p_reset_miss_flag = 'YES') and

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

1259: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1260: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1261: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1262: l_inv_rec.attribute_category_code :=
1263: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
1264:
1265: if ((p_reset_miss_flag = 'YES') and
1266: (l_inv_trans_rec.transaction_type = 'INVOICE ADJUSTMENT')) then
1267:

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

1450:
1451: -- ***** Asset Distribution Info ***** --
1452: l_asset_dist_tbl.delete;
1453:
1454: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1455: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1456: fa_load_tbl_pkg.dist_table.LAST loop
1457: l_asset_dist_rec.distribution_id :=
1458: fa_load_tbl_pkg.dist_table(i).dist_id;

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

1451: -- ***** Asset Distribution Info ***** --
1452: l_asset_dist_tbl.delete;
1453:
1454: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1455: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1456: fa_load_tbl_pkg.dist_table.LAST loop
1457: l_asset_dist_rec.distribution_id :=
1458: fa_load_tbl_pkg.dist_table(i).dist_id;
1459: --l_asset_dist_rec.units_assigned :=

Line 1456: fa_load_tbl_pkg.dist_table.LAST loop

1452: l_asset_dist_tbl.delete;
1453:
1454: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1455: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1456: fa_load_tbl_pkg.dist_table.LAST loop
1457: l_asset_dist_rec.distribution_id :=
1458: fa_load_tbl_pkg.dist_table(i).dist_id;
1459: --l_asset_dist_rec.units_assigned :=
1460: l_asset_dist_rec.transaction_units :=

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

1454: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1455: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1456: fa_load_tbl_pkg.dist_table.LAST loop
1457: l_asset_dist_rec.distribution_id :=
1458: fa_load_tbl_pkg.dist_table(i).dist_id;
1459: --l_asset_dist_rec.units_assigned :=
1460: l_asset_dist_rec.transaction_units :=
1461: fa_load_tbl_pkg.dist_table(i).trans_units;
1462: l_asset_dist_rec.assigned_to :=

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

1457: l_asset_dist_rec.distribution_id :=
1458: fa_load_tbl_pkg.dist_table(i).dist_id;
1459: --l_asset_dist_rec.units_assigned :=
1460: l_asset_dist_rec.transaction_units :=
1461: fa_load_tbl_pkg.dist_table(i).trans_units;
1462: l_asset_dist_rec.assigned_to :=
1463: fa_load_tbl_pkg.dist_table(i).assigned_to;
1464: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1465: l_asset_dist_rec.location_ccid :=

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

1459: --l_asset_dist_rec.units_assigned :=
1460: l_asset_dist_rec.transaction_units :=
1461: fa_load_tbl_pkg.dist_table(i).trans_units;
1462: l_asset_dist_rec.assigned_to :=
1463: fa_load_tbl_pkg.dist_table(i).assigned_to;
1464: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1465: l_asset_dist_rec.location_ccid :=
1466: fa_load_tbl_pkg.dist_table(i).location_id;
1467:

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

1460: l_asset_dist_rec.transaction_units :=
1461: fa_load_tbl_pkg.dist_table(i).trans_units;
1462: l_asset_dist_rec.assigned_to :=
1463: fa_load_tbl_pkg.dist_table(i).assigned_to;
1464: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1465: l_asset_dist_rec.location_ccid :=
1466: fa_load_tbl_pkg.dist_table(i).location_id;
1467:
1468: l_asset_dist_tbl(i) := l_asset_dist_rec;

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

1462: l_asset_dist_rec.assigned_to :=
1463: fa_load_tbl_pkg.dist_table(i).assigned_to;
1464: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1465: l_asset_dist_rec.location_ccid :=
1466: fa_load_tbl_pkg.dist_table(i).location_id;
1467:
1468: l_asset_dist_tbl(i) := l_asset_dist_rec;
1469: end loop;
1470:

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

1611:
1612: -- ***** Asset Distribution Info ***** --
1613: l_asset_dist_tbl.delete;
1614:
1615: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1616: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1617: fa_load_tbl_pkg.dist_table.LAST loop
1618: l_asset_dist_rec.distribution_id :=
1619: fa_load_tbl_pkg.dist_table(i).dist_id;

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

1612: -- ***** Asset Distribution Info ***** --
1613: l_asset_dist_tbl.delete;
1614:
1615: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1616: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1617: fa_load_tbl_pkg.dist_table.LAST loop
1618: l_asset_dist_rec.distribution_id :=
1619: fa_load_tbl_pkg.dist_table(i).dist_id;
1620: --l_asset_dist_rec.units_assigned :=

Line 1617: fa_load_tbl_pkg.dist_table.LAST loop

1613: l_asset_dist_tbl.delete;
1614:
1615: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1616: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1617: fa_load_tbl_pkg.dist_table.LAST loop
1618: l_asset_dist_rec.distribution_id :=
1619: fa_load_tbl_pkg.dist_table(i).dist_id;
1620: --l_asset_dist_rec.units_assigned :=
1621: l_asset_dist_rec.transaction_units :=

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

1615: -- Get the details from fa_load_tbl_pkg.dist_tbl;
1616: for i in fa_load_tbl_pkg.dist_table.FIRST ..
1617: fa_load_tbl_pkg.dist_table.LAST loop
1618: l_asset_dist_rec.distribution_id :=
1619: fa_load_tbl_pkg.dist_table(i).dist_id;
1620: --l_asset_dist_rec.units_assigned :=
1621: l_asset_dist_rec.transaction_units :=
1622: fa_load_tbl_pkg.dist_table(i).trans_units;
1623: l_asset_dist_rec.assigned_to :=

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

1618: l_asset_dist_rec.distribution_id :=
1619: fa_load_tbl_pkg.dist_table(i).dist_id;
1620: --l_asset_dist_rec.units_assigned :=
1621: l_asset_dist_rec.transaction_units :=
1622: fa_load_tbl_pkg.dist_table(i).trans_units;
1623: l_asset_dist_rec.assigned_to :=
1624: fa_load_tbl_pkg.dist_table(i).assigned_to;
1625: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1626: l_asset_dist_rec.location_ccid :=

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

1620: --l_asset_dist_rec.units_assigned :=
1621: l_asset_dist_rec.transaction_units :=
1622: fa_load_tbl_pkg.dist_table(i).trans_units;
1623: l_asset_dist_rec.assigned_to :=
1624: fa_load_tbl_pkg.dist_table(i).assigned_to;
1625: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1626: l_asset_dist_rec.location_ccid :=
1627: fa_load_tbl_pkg.dist_table(i).location_id;
1628:

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

1621: l_asset_dist_rec.transaction_units :=
1622: fa_load_tbl_pkg.dist_table(i).trans_units;
1623: l_asset_dist_rec.assigned_to :=
1624: fa_load_tbl_pkg.dist_table(i).assigned_to;
1625: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1626: l_asset_dist_rec.location_ccid :=
1627: fa_load_tbl_pkg.dist_table(i).location_id;
1628:
1629: l_asset_dist_tbl(i) := l_asset_dist_rec;

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

1623: l_asset_dist_rec.assigned_to :=
1624: fa_load_tbl_pkg.dist_table(i).assigned_to;
1625: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
1626: l_asset_dist_rec.location_ccid :=
1627: fa_load_tbl_pkg.dist_table(i).location_id;
1628:
1629: l_asset_dist_tbl(i) := l_asset_dist_rec;
1630: end loop;
1631:

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

1808:
1809: -- ***** Invoice Info ***** --
1810: l_inv_tbl.delete;
1811:
1812: -- Get the details from fa_load_tbl_pkg.inv_table
1813: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1814:
1815: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1816: l_inv_rec.asset_invoice_id :=

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

1809: -- ***** Invoice Info ***** --
1810: l_inv_tbl.delete;
1811:
1812: -- Get the details from fa_load_tbl_pkg.inv_table
1813: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1814:
1815: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1816: l_inv_rec.asset_invoice_id :=
1817: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

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

1811:
1812: -- Get the details from fa_load_tbl_pkg.inv_table
1813: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1814:
1815: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1816: l_inv_rec.asset_invoice_id :=
1817: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1818: l_inv_rec.fixed_assets_cost := 0 -
1819: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;

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

1813: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
1814:
1815: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1816: l_inv_rec.asset_invoice_id :=
1817: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1818: l_inv_rec.fixed_assets_cost := 0 -
1819: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;
1820: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1821: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

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

1815: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
1816: l_inv_rec.asset_invoice_id :=
1817: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1818: l_inv_rec.fixed_assets_cost := 0 -
1819: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;
1820: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1821: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1822: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1823: l_inv_rec.payables_batch_name :=

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

1816: l_inv_rec.asset_invoice_id :=
1817: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1818: l_inv_rec.fixed_assets_cost := 0 -
1819: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;
1820: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1821: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1822: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1823: l_inv_rec.payables_batch_name :=
1824: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

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

1817: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
1818: l_inv_rec.fixed_assets_cost := 0 -
1819: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;
1820: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1821: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1822: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1823: l_inv_rec.payables_batch_name :=
1824: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1825: l_inv_rec.payables_code_combination_id :=

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

1818: l_inv_rec.fixed_assets_cost := 0 -
1819: fa_load_tbl_pkg.inv_table(i).inv_transfer_cost;
1820: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1821: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1822: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1823: l_inv_rec.payables_batch_name :=
1824: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1825: l_inv_rec.payables_code_combination_id :=
1826: fa_load_tbl_pkg.inv_table(i).payables_ccid;

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

1820: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
1821: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
1822: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1823: l_inv_rec.payables_batch_name :=
1824: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1825: l_inv_rec.payables_code_combination_id :=
1826: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1827: l_inv_rec.feeder_system_name :=
1828: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

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

1822: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
1823: l_inv_rec.payables_batch_name :=
1824: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1825: l_inv_rec.payables_code_combination_id :=
1826: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1827: l_inv_rec.feeder_system_name :=
1828: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1829: l_inv_rec.create_batch_date :=
1830: fa_load_tbl_pkg.inv_table(i).create_batch_date;

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

1824: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
1825: l_inv_rec.payables_code_combination_id :=
1826: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1827: l_inv_rec.feeder_system_name :=
1828: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1829: l_inv_rec.create_batch_date :=
1830: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1831: l_inv_rec.create_batch_id :=
1832: fa_load_tbl_pkg.inv_table(i).create_batch_id;

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

1826: fa_load_tbl_pkg.inv_table(i).payables_ccid;
1827: l_inv_rec.feeder_system_name :=
1828: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1829: l_inv_rec.create_batch_date :=
1830: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1831: l_inv_rec.create_batch_id :=
1832: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1833: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1834: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

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

1828: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
1829: l_inv_rec.create_batch_date :=
1830: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1831: l_inv_rec.create_batch_id :=
1832: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1833: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1834: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1835: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1836: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

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

1829: l_inv_rec.create_batch_date :=
1830: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1831: l_inv_rec.create_batch_id :=
1832: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1833: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1834: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1835: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1836: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1837: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

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

1830: fa_load_tbl_pkg.inv_table(i).create_batch_date;
1831: l_inv_rec.create_batch_id :=
1832: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1833: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1834: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1835: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1836: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1837: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1838: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

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

1831: l_inv_rec.create_batch_id :=
1832: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1833: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1834: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1835: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1836: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1837: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1838: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1839: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

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

1832: fa_load_tbl_pkg.inv_table(i).create_batch_id;
1833: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1834: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1835: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1836: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1837: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1838: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1839: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1840: l_inv_rec.ap_distribution_line_number :=

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

1833: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
1834: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1835: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1836: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1837: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1838: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1839: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1840: l_inv_rec.ap_distribution_line_number :=
1841: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

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

1834: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
1835: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1836: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1837: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1838: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1839: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1840: l_inv_rec.ap_distribution_line_number :=
1841: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1842: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

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

1835: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
1836: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
1837: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1838: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1839: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1840: l_inv_rec.ap_distribution_line_number :=
1841: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1842: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1843: --l_inv_rec.split_merged_code :=

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

1837: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
1838: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1839: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1840: l_inv_rec.ap_distribution_line_number :=
1841: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1842: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1843: --l_inv_rec.split_merged_code :=
1844: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
1845: --l_inv_rec.parent_mass_additions_id :=

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

1838: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
1839: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
1840: l_inv_rec.ap_distribution_line_number :=
1841: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1842: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1843: --l_inv_rec.split_merged_code :=
1844: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
1845: --l_inv_rec.parent_mass_additions_id :=
1846: --l_inv_rec.unrevalued_cost :=

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

1840: l_inv_rec.ap_distribution_line_number :=
1841: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
1842: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
1843: --l_inv_rec.split_merged_code :=
1844: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
1845: --l_inv_rec.parent_mass_additions_id :=
1846: --l_inv_rec.unrevalued_cost :=
1847: --l_inv_rec.merged_code :=
1848: --l_inv_rec.split_code :=

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

1848: --l_inv_rec.split_code :=
1849: --l_inv_rec.merge_parent_mass_additions_id :=
1850: --l_inv_rec.split_parent_mass_additions_id :=
1851: l_inv_rec.project_asset_line_id :=
1852: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1853: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1854: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1855: l_inv_rec.material_indicator_flag :=
1856: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

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

1849: --l_inv_rec.merge_parent_mass_additions_id :=
1850: --l_inv_rec.split_parent_mass_additions_id :=
1851: l_inv_rec.project_asset_line_id :=
1852: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1853: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1854: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1855: l_inv_rec.material_indicator_flag :=
1856: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1857: l_inv_rec.depreciate_in_group_flag :=

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

1850: --l_inv_rec.split_parent_mass_additions_id :=
1851: l_inv_rec.project_asset_line_id :=
1852: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1853: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1854: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1855: l_inv_rec.material_indicator_flag :=
1856: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1857: l_inv_rec.depreciate_in_group_flag :=
1858: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

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

1852: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
1853: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
1854: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1855: l_inv_rec.material_indicator_flag :=
1856: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1857: l_inv_rec.depreciate_in_group_flag :=
1858: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1859: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1860: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

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

1854: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
1855: l_inv_rec.material_indicator_flag :=
1856: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1857: l_inv_rec.depreciate_in_group_flag :=
1858: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1859: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1860: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1861: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1862: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

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

1855: l_inv_rec.material_indicator_flag :=
1856: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1857: l_inv_rec.depreciate_in_group_flag :=
1858: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1859: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1860: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1861: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1862: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1863: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

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

1856: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
1857: l_inv_rec.depreciate_in_group_flag :=
1858: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1859: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1860: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1861: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1862: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1863: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1864: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

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

1857: l_inv_rec.depreciate_in_group_flag :=
1858: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1859: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1860: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1861: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1862: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1863: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1864: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1865: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

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

1858: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
1859: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1860: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1861: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1862: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1863: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1864: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1865: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1866: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

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

1859: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
1860: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1861: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1862: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1863: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1864: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1865: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1866: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1867: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

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

1860: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
1861: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1862: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1863: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1864: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1865: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1866: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1867: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1868: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

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

1861: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
1862: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1863: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1864: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1865: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1866: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1867: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1868: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1869: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

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

1862: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
1863: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1864: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1865: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1866: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1867: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1868: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1869: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1870: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

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

1863: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
1864: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1865: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1866: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1867: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1868: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1869: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1870: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1871: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

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

1864: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
1865: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1866: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1867: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1868: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1869: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1870: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1871: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1872: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

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

1865: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
1866: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1867: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1868: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1869: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1870: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1871: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1872: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1873: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

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

1866: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
1867: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1868: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1869: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1870: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1871: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1872: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1873: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1874: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

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

1867: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
1868: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1869: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1870: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1871: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1872: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1873: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1874: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1875: l_inv_rec.attribute_category_code :=

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

1868: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
1869: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1870: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1871: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1872: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1873: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1874: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1875: l_inv_rec.attribute_category_code :=
1876: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

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

1869: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
1870: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1871: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1872: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1873: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1874: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1875: l_inv_rec.attribute_category_code :=
1876: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
1877:

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

1870: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
1871: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
1872: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1873: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1874: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1875: l_inv_rec.attribute_category_code :=
1876: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
1877:
1878: l_inv_tbl(i) := l_inv_rec;

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

1872: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
1873: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
1874: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
1875: l_inv_rec.attribute_category_code :=
1876: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
1877:
1878: l_inv_tbl(i) := l_inv_rec;
1879: end loop;
1880:

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

2383:
2384: -- ***** Asset Distribution Info ***** --
2385: l_asset_dist_tbl.delete;
2386:
2387: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2388: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2389: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2390: l_asset_dist_rec.distribution_id :=
2391: fa_load_tbl_pkg.dist_table(i).dist_id;

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

2384: -- ***** Asset Distribution Info ***** --
2385: l_asset_dist_tbl.delete;
2386:
2387: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2388: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2389: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2390: l_asset_dist_rec.distribution_id :=
2391: fa_load_tbl_pkg.dist_table(i).dist_id;
2392: l_asset_dist_rec.transaction_units :=

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

2385: l_asset_dist_tbl.delete;
2386:
2387: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2388: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2389: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2390: l_asset_dist_rec.distribution_id :=
2391: fa_load_tbl_pkg.dist_table(i).dist_id;
2392: l_asset_dist_rec.transaction_units :=
2393: fa_load_tbl_pkg.dist_table(i).trans_units;

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

2387: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2388: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2389: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2390: l_asset_dist_rec.distribution_id :=
2391: fa_load_tbl_pkg.dist_table(i).dist_id;
2392: l_asset_dist_rec.transaction_units :=
2393: fa_load_tbl_pkg.dist_table(i).trans_units;
2394: l_asset_dist_rec.units_assigned := NULL;
2395: l_asset_dist_rec.assigned_to :=

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

2389: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2390: l_asset_dist_rec.distribution_id :=
2391: fa_load_tbl_pkg.dist_table(i).dist_id;
2392: l_asset_dist_rec.transaction_units :=
2393: fa_load_tbl_pkg.dist_table(i).trans_units;
2394: l_asset_dist_rec.units_assigned := NULL;
2395: l_asset_dist_rec.assigned_to :=
2396: fa_load_tbl_pkg.dist_table(i).assigned_to;
2397: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;

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

2392: l_asset_dist_rec.transaction_units :=
2393: fa_load_tbl_pkg.dist_table(i).trans_units;
2394: l_asset_dist_rec.units_assigned := NULL;
2395: l_asset_dist_rec.assigned_to :=
2396: fa_load_tbl_pkg.dist_table(i).assigned_to;
2397: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
2398: l_asset_dist_rec.location_ccid :=
2399: fa_load_tbl_pkg.dist_table(i).location_id;
2400:

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

2393: fa_load_tbl_pkg.dist_table(i).trans_units;
2394: l_asset_dist_rec.units_assigned := NULL;
2395: l_asset_dist_rec.assigned_to :=
2396: fa_load_tbl_pkg.dist_table(i).assigned_to;
2397: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
2398: l_asset_dist_rec.location_ccid :=
2399: fa_load_tbl_pkg.dist_table(i).location_id;
2400:
2401: l_asset_dist_tbl(i) := l_asset_dist_rec;

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

2395: l_asset_dist_rec.assigned_to :=
2396: fa_load_tbl_pkg.dist_table(i).assigned_to;
2397: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
2398: l_asset_dist_rec.location_ccid :=
2399: fa_load_tbl_pkg.dist_table(i).location_id;
2400:
2401: l_asset_dist_tbl(i) := l_asset_dist_rec;
2402: end if;
2403: end loop;

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

2409:
2410: -- ***** Invoice Info ***** --
2411: l_inv_tbl.delete;
2412:
2413: -- Get the details from fa_load_tbl_pkg.inv_table
2414: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2415:
2416: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2417: l_inv_rec.asset_invoice_id :=

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

2410: -- ***** Invoice Info ***** --
2411: l_inv_tbl.delete;
2412:
2413: -- Get the details from fa_load_tbl_pkg.inv_table
2414: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2415:
2416: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2417: l_inv_rec.asset_invoice_id :=
2418: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

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

2412:
2413: -- Get the details from fa_load_tbl_pkg.inv_table
2414: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2415:
2416: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2417: l_inv_rec.asset_invoice_id :=
2418: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2419: l_inv_rec.fixed_assets_cost :=
2420: fa_load_tbl_pkg.inv_table(i).inv_new_cost -

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

2414: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2415:
2416: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2417: l_inv_rec.asset_invoice_id :=
2418: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2419: l_inv_rec.fixed_assets_cost :=
2420: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
2421: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
2422: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;

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

2416: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2417: l_inv_rec.asset_invoice_id :=
2418: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2419: l_inv_rec.fixed_assets_cost :=
2420: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
2421: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
2422: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2423: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2424: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;

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

2417: l_inv_rec.asset_invoice_id :=
2418: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2419: l_inv_rec.fixed_assets_cost :=
2420: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
2421: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
2422: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2423: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2424: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2425: l_inv_rec.payables_batch_name :=

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

2418: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2419: l_inv_rec.fixed_assets_cost :=
2420: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
2421: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
2422: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2423: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2424: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2425: l_inv_rec.payables_batch_name :=
2426: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

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

2419: l_inv_rec.fixed_assets_cost :=
2420: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
2421: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
2422: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2423: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2424: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2425: l_inv_rec.payables_batch_name :=
2426: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2427: l_inv_rec.payables_code_combination_id :=

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

2420: fa_load_tbl_pkg.inv_table(i).inv_new_cost -
2421: nvl(fa_load_tbl_pkg.inv_table(i).fixed_assets_cost, 0);
2422: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2423: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2424: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2425: l_inv_rec.payables_batch_name :=
2426: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2427: l_inv_rec.payables_code_combination_id :=
2428: fa_load_tbl_pkg.inv_table(i).payables_ccid;

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

2422: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2423: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2424: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2425: l_inv_rec.payables_batch_name :=
2426: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2427: l_inv_rec.payables_code_combination_id :=
2428: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2429: l_inv_rec.feeder_system_name :=
2430: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

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

2424: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2425: l_inv_rec.payables_batch_name :=
2426: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2427: l_inv_rec.payables_code_combination_id :=
2428: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2429: l_inv_rec.feeder_system_name :=
2430: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2431: l_inv_rec.create_batch_date :=
2432: fa_load_tbl_pkg.inv_table(i).create_batch_date;

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

2426: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2427: l_inv_rec.payables_code_combination_id :=
2428: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2429: l_inv_rec.feeder_system_name :=
2430: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2431: l_inv_rec.create_batch_date :=
2432: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2433: l_inv_rec.create_batch_id :=
2434: fa_load_tbl_pkg.inv_table(i).create_batch_id;

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

2428: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2429: l_inv_rec.feeder_system_name :=
2430: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2431: l_inv_rec.create_batch_date :=
2432: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2433: l_inv_rec.create_batch_id :=
2434: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2435: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2436: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

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

2430: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2431: l_inv_rec.create_batch_date :=
2432: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2433: l_inv_rec.create_batch_id :=
2434: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2435: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2436: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2437: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2438: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

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

2431: l_inv_rec.create_batch_date :=
2432: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2433: l_inv_rec.create_batch_id :=
2434: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2435: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2436: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2437: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2438: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2439: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

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

2432: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2433: l_inv_rec.create_batch_id :=
2434: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2435: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2436: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2437: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2438: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2439: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2440: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

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

2433: l_inv_rec.create_batch_id :=
2434: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2435: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2436: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2437: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2438: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2439: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2440: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2441: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

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

2434: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2435: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2436: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2437: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2438: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2439: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2440: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2441: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2442: l_inv_rec.ap_distribution_line_number :=

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

2435: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2436: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2437: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2438: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2439: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2440: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2441: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2442: l_inv_rec.ap_distribution_line_number :=
2443: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

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

2436: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2437: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2438: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2439: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2440: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2441: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2442: l_inv_rec.ap_distribution_line_number :=
2443: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2444: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

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

2437: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2438: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2439: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2440: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2441: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2442: l_inv_rec.ap_distribution_line_number :=
2443: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2444: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2445: --l_inv_rec.split_merged_code :=

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

2439: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2440: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2441: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2442: l_inv_rec.ap_distribution_line_number :=
2443: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2444: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2445: --l_inv_rec.split_merged_code :=
2446: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
2447: --l_inv_rec.parent_mass_additions_id :=

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

2440: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2441: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2442: l_inv_rec.ap_distribution_line_number :=
2443: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2444: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2445: --l_inv_rec.split_merged_code :=
2446: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
2447: --l_inv_rec.parent_mass_additions_id :=
2448: --l_inv_rec.unrevalued_cost :=

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

2442: l_inv_rec.ap_distribution_line_number :=
2443: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2444: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2445: --l_inv_rec.split_merged_code :=
2446: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
2447: --l_inv_rec.parent_mass_additions_id :=
2448: --l_inv_rec.unrevalued_cost :=
2449: --l_inv_rec.merged_code :=
2450: --l_inv_rec.split_code :=

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

2450: --l_inv_rec.split_code :=
2451: --l_inv_rec.merge_parent_mass_additions_id :=
2452: --l_inv_rec.split_parent_mass_additions_id :=
2453: l_inv_rec.project_asset_line_id :=
2454: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
2455: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
2456: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2457: l_inv_rec.material_indicator_flag :=
2458: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

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

2451: --l_inv_rec.merge_parent_mass_additions_id :=
2452: --l_inv_rec.split_parent_mass_additions_id :=
2453: l_inv_rec.project_asset_line_id :=
2454: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
2455: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
2456: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2457: l_inv_rec.material_indicator_flag :=
2458: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2459: l_inv_rec.depreciate_in_group_flag :=

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

2452: --l_inv_rec.split_parent_mass_additions_id :=
2453: l_inv_rec.project_asset_line_id :=
2454: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
2455: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
2456: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2457: l_inv_rec.material_indicator_flag :=
2458: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2459: l_inv_rec.depreciate_in_group_flag :=
2460: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

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

2454: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
2455: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
2456: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2457: l_inv_rec.material_indicator_flag :=
2458: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2459: l_inv_rec.depreciate_in_group_flag :=
2460: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2461: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2462: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

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

2456: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2457: l_inv_rec.material_indicator_flag :=
2458: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2459: l_inv_rec.depreciate_in_group_flag :=
2460: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2461: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2462: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2463: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2464: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

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

2457: l_inv_rec.material_indicator_flag :=
2458: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2459: l_inv_rec.depreciate_in_group_flag :=
2460: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2461: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2462: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2463: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2464: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2465: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

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

2458: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2459: l_inv_rec.depreciate_in_group_flag :=
2460: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2461: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2462: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2463: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2464: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2465: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2466: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

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

2459: l_inv_rec.depreciate_in_group_flag :=
2460: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2461: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2462: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2463: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2464: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2465: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2466: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2467: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

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

2460: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2461: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2462: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2463: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2464: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2465: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2466: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2467: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2468: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

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

2461: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2462: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2463: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2464: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2465: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2466: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2467: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2468: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2469: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

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

2462: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2463: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2464: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2465: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2466: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2467: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2468: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2469: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2470: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

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

2463: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2464: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2465: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2466: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2467: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2468: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2469: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2470: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2471: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

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

2464: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2465: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2466: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2467: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2468: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2469: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2470: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2471: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2472: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

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

2465: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2466: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2467: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2468: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2469: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2470: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2471: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2472: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2473: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

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

2466: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2467: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2468: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2469: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2470: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2471: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2472: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2473: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2474: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

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

2467: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2468: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2469: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2470: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2471: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2472: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2473: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2474: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2475: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

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

2468: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2469: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2470: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2471: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2472: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2473: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2474: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2475: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2476: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

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

2469: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2470: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2471: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2472: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2473: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2474: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2475: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2476: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2477: l_inv_rec.attribute_category_code :=

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

2470: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2471: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2472: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2473: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2474: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2475: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2476: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2477: l_inv_rec.attribute_category_code :=
2478: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

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

2471: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2472: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2473: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2474: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2475: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2476: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2477: l_inv_rec.attribute_category_code :=
2478: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
2479:

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

2472: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2473: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2474: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2475: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2476: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2477: l_inv_rec.attribute_category_code :=
2478: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
2479:
2480: l_inv_tbl(i) := l_inv_rec;

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

2474: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2475: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2476: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2477: l_inv_rec.attribute_category_code :=
2478: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
2479:
2480: l_inv_tbl(i) := l_inv_rec;
2481: end loop;
2482:

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

2844:
2845: -- ***** Asset Distribution Info ***** --
2846: l_asset_dist_tbl.delete;
2847:
2848: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2849: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2850: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2851: l_asset_dist_rec.distribution_id :=
2852: fa_load_tbl_pkg.dist_table(i).dist_id;

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

2845: -- ***** Asset Distribution Info ***** --
2846: l_asset_dist_tbl.delete;
2847:
2848: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2849: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2850: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2851: l_asset_dist_rec.distribution_id :=
2852: fa_load_tbl_pkg.dist_table(i).dist_id;
2853: l_asset_dist_rec.units_assigned :=

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

2846: l_asset_dist_tbl.delete;
2847:
2848: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2849: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2850: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2851: l_asset_dist_rec.distribution_id :=
2852: fa_load_tbl_pkg.dist_table(i).dist_id;
2853: l_asset_dist_rec.units_assigned :=
2854: fa_load_tbl_pkg.dist_table(i).trans_units;

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

2848: -- Get the details from fa_load_tbl_pkg.dist_tbl;
2849: for i in 1 .. fa_load_tbl_pkg.dist_table.COUNT loop
2850: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2851: l_asset_dist_rec.distribution_id :=
2852: fa_load_tbl_pkg.dist_table(i).dist_id;
2853: l_asset_dist_rec.units_assigned :=
2854: fa_load_tbl_pkg.dist_table(i).trans_units;
2855: l_asset_dist_rec.transaction_units := NULL;
2856: l_asset_dist_rec.assigned_to :=

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

2850: if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
2851: l_asset_dist_rec.distribution_id :=
2852: fa_load_tbl_pkg.dist_table(i).dist_id;
2853: l_asset_dist_rec.units_assigned :=
2854: fa_load_tbl_pkg.dist_table(i).trans_units;
2855: l_asset_dist_rec.transaction_units := NULL;
2856: l_asset_dist_rec.assigned_to :=
2857: fa_load_tbl_pkg.dist_table(i).assigned_to;
2858: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;

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

2853: l_asset_dist_rec.units_assigned :=
2854: fa_load_tbl_pkg.dist_table(i).trans_units;
2855: l_asset_dist_rec.transaction_units := NULL;
2856: l_asset_dist_rec.assigned_to :=
2857: fa_load_tbl_pkg.dist_table(i).assigned_to;
2858: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
2859: l_asset_dist_rec.location_ccid :=
2860: fa_load_tbl_pkg.dist_table(i).location_id;
2861:

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

2854: fa_load_tbl_pkg.dist_table(i).trans_units;
2855: l_asset_dist_rec.transaction_units := NULL;
2856: l_asset_dist_rec.assigned_to :=
2857: fa_load_tbl_pkg.dist_table(i).assigned_to;
2858: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
2859: l_asset_dist_rec.location_ccid :=
2860: fa_load_tbl_pkg.dist_table(i).location_id;
2861:
2862: l_asset_dist_tbl(i) := l_asset_dist_rec;

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

2856: l_asset_dist_rec.assigned_to :=
2857: fa_load_tbl_pkg.dist_table(i).assigned_to;
2858: l_asset_dist_rec.expense_ccid := fa_load_tbl_pkg.dist_table(i).ccid;
2859: l_asset_dist_rec.location_ccid :=
2860: fa_load_tbl_pkg.dist_table(i).location_id;
2861:
2862: l_asset_dist_tbl(i) := l_asset_dist_rec;
2863: end if;
2864: end loop;

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

2872:
2873: -- ***** Invoice Info ***** --
2874: l_inv_tbl.delete;
2875:
2876: -- Get the details from fa_load_tbl_pkg.inv_table
2877: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2878:
2879: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2880: l_inv_rec.asset_invoice_id :=

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

2873: -- ***** Invoice Info ***** --
2874: l_inv_tbl.delete;
2875:
2876: -- Get the details from fa_load_tbl_pkg.inv_table
2877: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2878:
2879: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2880: l_inv_rec.asset_invoice_id :=
2881: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

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

2875:
2876: -- Get the details from fa_load_tbl_pkg.inv_table
2877: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2878:
2879: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2880: l_inv_rec.asset_invoice_id :=
2881: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2882: l_inv_rec.fixed_assets_cost :=
2883: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;

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

2877: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
2878:
2879: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2880: l_inv_rec.asset_invoice_id :=
2881: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2882: l_inv_rec.fixed_assets_cost :=
2883: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
2884: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2885: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

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

2879: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
2880: l_inv_rec.asset_invoice_id :=
2881: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2882: l_inv_rec.fixed_assets_cost :=
2883: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
2884: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2885: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2886: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2887: l_inv_rec.payables_batch_name :=

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

2880: l_inv_rec.asset_invoice_id :=
2881: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2882: l_inv_rec.fixed_assets_cost :=
2883: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
2884: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2885: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2886: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2887: l_inv_rec.payables_batch_name :=
2888: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

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

2881: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
2882: l_inv_rec.fixed_assets_cost :=
2883: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
2884: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2885: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2886: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2887: l_inv_rec.payables_batch_name :=
2888: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2889: l_inv_rec.payables_code_combination_id :=

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

2882: l_inv_rec.fixed_assets_cost :=
2883: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
2884: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2885: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2886: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2887: l_inv_rec.payables_batch_name :=
2888: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2889: l_inv_rec.payables_code_combination_id :=
2890: fa_load_tbl_pkg.inv_table(i).payables_ccid;

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

2884: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
2885: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
2886: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2887: l_inv_rec.payables_batch_name :=
2888: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2889: l_inv_rec.payables_code_combination_id :=
2890: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2891: l_inv_rec.feeder_system_name :=
2892: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

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

2886: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
2887: l_inv_rec.payables_batch_name :=
2888: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2889: l_inv_rec.payables_code_combination_id :=
2890: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2891: l_inv_rec.feeder_system_name :=
2892: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2893: l_inv_rec.create_batch_date :=
2894: fa_load_tbl_pkg.inv_table(i).create_batch_date;

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

2888: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
2889: l_inv_rec.payables_code_combination_id :=
2890: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2891: l_inv_rec.feeder_system_name :=
2892: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2893: l_inv_rec.create_batch_date :=
2894: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2895: l_inv_rec.create_batch_id :=
2896: fa_load_tbl_pkg.inv_table(i).create_batch_id;

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

2890: fa_load_tbl_pkg.inv_table(i).payables_ccid;
2891: l_inv_rec.feeder_system_name :=
2892: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2893: l_inv_rec.create_batch_date :=
2894: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2895: l_inv_rec.create_batch_id :=
2896: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2897: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2898: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

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

2892: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
2893: l_inv_rec.create_batch_date :=
2894: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2895: l_inv_rec.create_batch_id :=
2896: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2897: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2898: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2899: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2900: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

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

2893: l_inv_rec.create_batch_date :=
2894: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2895: l_inv_rec.create_batch_id :=
2896: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2897: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2898: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2899: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2900: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2901: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

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

2894: fa_load_tbl_pkg.inv_table(i).create_batch_date;
2895: l_inv_rec.create_batch_id :=
2896: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2897: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2898: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2899: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2900: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2901: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2902: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

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

2895: l_inv_rec.create_batch_id :=
2896: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2897: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2898: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2899: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2900: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2901: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2902: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2903: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

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

2896: fa_load_tbl_pkg.inv_table(i).create_batch_id;
2897: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2898: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2899: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2900: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2901: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2902: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2903: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2904: l_inv_rec.ap_distribution_line_number :=

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

2897: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
2898: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2899: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2900: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2901: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2902: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2903: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2904: l_inv_rec.ap_distribution_line_number :=
2905: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

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

2898: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
2899: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2900: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2901: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2902: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2903: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2904: l_inv_rec.ap_distribution_line_number :=
2905: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2906: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

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

2899: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
2900: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
2901: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2902: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2903: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2904: l_inv_rec.ap_distribution_line_number :=
2905: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2906: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2907: --l_inv_rec.split_merged_code :=

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

2901: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
2902: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2903: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2904: l_inv_rec.ap_distribution_line_number :=
2905: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2906: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2907: --l_inv_rec.split_merged_code :=
2908: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
2909: --l_inv_rec.parent_mass_additions_id :=

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

2902: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
2903: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
2904: l_inv_rec.ap_distribution_line_number :=
2905: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2906: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2907: --l_inv_rec.split_merged_code :=
2908: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
2909: --l_inv_rec.parent_mass_additions_id :=
2910: --l_inv_rec.unrevalued_cost :=

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

2904: l_inv_rec.ap_distribution_line_number :=
2905: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
2906: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
2907: --l_inv_rec.split_merged_code :=
2908: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
2909: --l_inv_rec.parent_mass_additions_id :=
2910: --l_inv_rec.unrevalued_cost :=
2911: --l_inv_rec.merged_code :=
2912: --l_inv_rec.split_code :=

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

2912: --l_inv_rec.split_code :=
2913: --l_inv_rec.merge_parent_mass_additions_id :=
2914: --l_inv_rec.split_parent_mass_additions_id :=
2915: l_inv_rec.project_asset_line_id :=
2916: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
2917: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
2918: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2919: l_inv_rec.material_indicator_flag :=
2920: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

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

2913: --l_inv_rec.merge_parent_mass_additions_id :=
2914: --l_inv_rec.split_parent_mass_additions_id :=
2915: l_inv_rec.project_asset_line_id :=
2916: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
2917: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
2918: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2919: l_inv_rec.material_indicator_flag :=
2920: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2921: l_inv_rec.depreciate_in_group_flag :=

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

2914: --l_inv_rec.split_parent_mass_additions_id :=
2915: l_inv_rec.project_asset_line_id :=
2916: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
2917: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
2918: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2919: l_inv_rec.material_indicator_flag :=
2920: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2921: l_inv_rec.depreciate_in_group_flag :=
2922: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

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

2916: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
2917: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
2918: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2919: l_inv_rec.material_indicator_flag :=
2920: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2921: l_inv_rec.depreciate_in_group_flag :=
2922: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2923: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2924: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

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

2918: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
2919: l_inv_rec.material_indicator_flag :=
2920: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2921: l_inv_rec.depreciate_in_group_flag :=
2922: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2923: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2924: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2925: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2926: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

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

2919: l_inv_rec.material_indicator_flag :=
2920: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2921: l_inv_rec.depreciate_in_group_flag :=
2922: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2923: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2924: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2925: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2926: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2927: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

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

2920: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
2921: l_inv_rec.depreciate_in_group_flag :=
2922: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2923: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2924: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2925: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2926: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2927: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2928: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

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

2921: l_inv_rec.depreciate_in_group_flag :=
2922: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2923: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2924: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2925: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2926: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2927: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2928: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2929: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

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

2922: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
2923: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2924: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2925: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2926: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2927: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2928: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2929: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2930: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

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

2923: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
2924: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2925: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2926: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2927: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2928: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2929: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2930: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2931: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

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

2924: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
2925: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2926: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2927: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2928: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2929: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2930: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2931: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2932: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

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

2925: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
2926: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2927: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2928: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2929: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2930: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2931: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2932: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2933: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

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

2926: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
2927: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2928: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2929: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2930: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2931: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2932: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2933: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2934: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

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

2927: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
2928: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2929: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2930: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2931: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2932: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2933: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2934: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2935: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

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

2928: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
2929: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2930: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2931: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2932: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2933: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2934: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2935: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2936: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

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

2929: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
2930: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2931: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2932: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2933: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2934: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2935: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2936: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2937: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

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

2930: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
2931: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2932: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2933: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2934: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2935: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2936: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2937: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2938: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

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

2931: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
2932: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2933: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2934: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2935: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2936: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2937: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2938: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2939: l_inv_rec.attribute_category_code :=

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

2932: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
2933: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2934: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2935: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2936: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2937: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2938: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2939: l_inv_rec.attribute_category_code :=
2940: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

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

2933: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
2934: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2935: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2936: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2937: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2938: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2939: l_inv_rec.attribute_category_code :=
2940: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
2941:

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

2934: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
2935: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
2936: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2937: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2938: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2939: l_inv_rec.attribute_category_code :=
2940: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
2941:
2942: l_inv_tbl(i) := l_inv_rec;

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

2936: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
2937: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
2938: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
2939: l_inv_rec.attribute_category_code :=
2940: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
2941:
2942: l_inv_tbl(i) := l_inv_rec;
2943: end loop;
2944:

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

3848:
3849: -- ***** Invoice Info ***** --
3850: l_inv_tbl.delete;
3851:
3852: -- Get the details from fa_load_tbl_pkg.inv_table
3853: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
3854:
3855: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
3856: l_inv_rec.asset_invoice_id :=

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

3849: -- ***** Invoice Info ***** --
3850: l_inv_tbl.delete;
3851:
3852: -- Get the details from fa_load_tbl_pkg.inv_table
3853: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
3854:
3855: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
3856: l_inv_rec.asset_invoice_id :=
3857: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;

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

3851:
3852: -- Get the details from fa_load_tbl_pkg.inv_table
3853: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
3854:
3855: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
3856: l_inv_rec.asset_invoice_id :=
3857: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
3858: l_inv_rec.fixed_assets_cost :=
3859: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;

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

3853: for i in 1 .. fa_load_tbl_pkg.inv_table.COUNT loop
3854:
3855: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
3856: l_inv_rec.asset_invoice_id :=
3857: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
3858: l_inv_rec.fixed_assets_cost :=
3859: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
3860: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
3861: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;

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

3855: l_inv_rec.po_vendor_id := fa_load_tbl_pkg.inv_table(i).po_vendor_id;
3856: l_inv_rec.asset_invoice_id :=
3857: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
3858: l_inv_rec.fixed_assets_cost :=
3859: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
3860: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
3861: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
3862: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
3863: l_inv_rec.payables_batch_name :=

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

3856: l_inv_rec.asset_invoice_id :=
3857: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
3858: l_inv_rec.fixed_assets_cost :=
3859: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
3860: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
3861: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
3862: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
3863: l_inv_rec.payables_batch_name :=
3864: fa_load_tbl_pkg.inv_table(i).payables_batch_name;

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

3857: fa_load_tbl_pkg.inv_table(i).asset_invoice_id;
3858: l_inv_rec.fixed_assets_cost :=
3859: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
3860: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
3861: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
3862: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
3863: l_inv_rec.payables_batch_name :=
3864: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
3865: l_inv_rec.payables_code_combination_id :=

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

3858: l_inv_rec.fixed_assets_cost :=
3859: fa_load_tbl_pkg.inv_table(i).fixed_assets_cost;
3860: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
3861: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
3862: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
3863: l_inv_rec.payables_batch_name :=
3864: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
3865: l_inv_rec.payables_code_combination_id :=
3866: fa_load_tbl_pkg.inv_table(i).payables_ccid;

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

3860: l_inv_rec.deleted_flag := fa_load_tbl_pkg.inv_table(i).deleted_flag;
3861: l_inv_rec.po_number := fa_load_tbl_pkg.inv_table(i).po_number;
3862: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
3863: l_inv_rec.payables_batch_name :=
3864: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
3865: l_inv_rec.payables_code_combination_id :=
3866: fa_load_tbl_pkg.inv_table(i).payables_ccid;
3867: l_inv_rec.feeder_system_name :=
3868: fa_load_tbl_pkg.inv_table(i).feeder_system_name;

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

3862: l_inv_rec.invoice_number := fa_load_tbl_pkg.inv_table(i).invoice_number;
3863: l_inv_rec.payables_batch_name :=
3864: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
3865: l_inv_rec.payables_code_combination_id :=
3866: fa_load_tbl_pkg.inv_table(i).payables_ccid;
3867: l_inv_rec.feeder_system_name :=
3868: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
3869: l_inv_rec.create_batch_date :=
3870: fa_load_tbl_pkg.inv_table(i).create_batch_date;

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

3864: fa_load_tbl_pkg.inv_table(i).payables_batch_name;
3865: l_inv_rec.payables_code_combination_id :=
3866: fa_load_tbl_pkg.inv_table(i).payables_ccid;
3867: l_inv_rec.feeder_system_name :=
3868: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
3869: l_inv_rec.create_batch_date :=
3870: fa_load_tbl_pkg.inv_table(i).create_batch_date;
3871: l_inv_rec.create_batch_id :=
3872: fa_load_tbl_pkg.inv_table(i).create_batch_id;

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

3866: fa_load_tbl_pkg.inv_table(i).payables_ccid;
3867: l_inv_rec.feeder_system_name :=
3868: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
3869: l_inv_rec.create_batch_date :=
3870: fa_load_tbl_pkg.inv_table(i).create_batch_date;
3871: l_inv_rec.create_batch_id :=
3872: fa_load_tbl_pkg.inv_table(i).create_batch_id;
3873: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3874: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;

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

3868: fa_load_tbl_pkg.inv_table(i).feeder_system_name;
3869: l_inv_rec.create_batch_date :=
3870: fa_load_tbl_pkg.inv_table(i).create_batch_date;
3871: l_inv_rec.create_batch_id :=
3872: fa_load_tbl_pkg.inv_table(i).create_batch_id;
3873: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3874: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3875: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3876: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;

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

3869: l_inv_rec.create_batch_date :=
3870: fa_load_tbl_pkg.inv_table(i).create_batch_date;
3871: l_inv_rec.create_batch_id :=
3872: fa_load_tbl_pkg.inv_table(i).create_batch_id;
3873: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3874: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3875: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3876: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3877: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;

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

3870: fa_load_tbl_pkg.inv_table(i).create_batch_date;
3871: l_inv_rec.create_batch_id :=
3872: fa_load_tbl_pkg.inv_table(i).create_batch_id;
3873: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3874: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3875: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3876: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3877: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3878: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;

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

3871: l_inv_rec.create_batch_id :=
3872: fa_load_tbl_pkg.inv_table(i).create_batch_id;
3873: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3874: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3875: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3876: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3877: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3878: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3879: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;

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

3872: fa_load_tbl_pkg.inv_table(i).create_batch_id;
3873: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3874: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3875: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3876: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3877: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3878: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3879: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
3880: l_inv_rec.ap_distribution_line_number :=

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

3873: l_inv_rec.invoice_date := fa_load_tbl_pkg.inv_table(i).invoice_date;
3874: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3875: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3876: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3877: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3878: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3879: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
3880: l_inv_rec.ap_distribution_line_number :=
3881: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;

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

3874: l_inv_rec.payables_cost := fa_load_tbl_pkg.inv_table(i).payables_cost;
3875: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3876: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3877: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3878: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3879: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
3880: l_inv_rec.ap_distribution_line_number :=
3881: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
3882: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;

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

3875: l_inv_rec.post_batch_id := fa_load_tbl_pkg.inv_table(i).post_batch_id;
3876: l_inv_rec.invoice_id := fa_load_tbl_pkg.inv_table(i).invoice_id;
3877: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3878: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3879: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
3880: l_inv_rec.ap_distribution_line_number :=
3881: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
3882: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
3883: --l_inv_rec.split_merged_code :=

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

3877: l_inv_rec.invoice_distribution_id := fa_load_tbl_pkg.inv_table(i).invoice_distribution_id;
3878: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3879: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
3880: l_inv_rec.ap_distribution_line_number :=
3881: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
3882: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
3883: --l_inv_rec.split_merged_code :=
3884: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
3885: --l_inv_rec.parent_mass_additions_id :=

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

3878: l_inv_rec.invoice_line_number := fa_load_tbl_pkg.inv_table(i).invoice_line_number;
3879: l_inv_rec.po_distribution_id := fa_load_tbl_pkg.inv_table(i).po_distribution_id;
3880: l_inv_rec.ap_distribution_line_number :=
3881: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
3882: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
3883: --l_inv_rec.split_merged_code :=
3884: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
3885: --l_inv_rec.parent_mass_additions_id :=
3886: --l_inv_rec.unrevalued_cost :=

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

3880: l_inv_rec.ap_distribution_line_number :=
3881: fa_load_tbl_pkg.inv_table(i).ap_dist_line_num;
3882: l_inv_rec.payables_units := fa_load_tbl_pkg.inv_table(i).payables_units;
3883: --l_inv_rec.split_merged_code :=
3884: l_inv_rec.description := fa_load_tbl_pkg.inv_table(i).description;
3885: --l_inv_rec.parent_mass_additions_id :=
3886: --l_inv_rec.unrevalued_cost :=
3887: --l_inv_rec.merged_code :=
3888: --l_inv_rec.split_code :=

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

3888: --l_inv_rec.split_code :=
3889: --l_inv_rec.merge_parent_mass_additions_id :=
3890: --l_inv_rec.split_parent_mass_additions_id :=
3891: l_inv_rec.project_asset_line_id :=
3892: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
3893: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
3894: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3895: l_inv_rec.material_indicator_flag :=
3896: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;

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

3889: --l_inv_rec.merge_parent_mass_additions_id :=
3890: --l_inv_rec.split_parent_mass_additions_id :=
3891: l_inv_rec.project_asset_line_id :=
3892: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
3893: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
3894: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3895: l_inv_rec.material_indicator_flag :=
3896: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3897: l_inv_rec.depreciate_in_group_flag :=

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

3890: --l_inv_rec.split_parent_mass_additions_id :=
3891: l_inv_rec.project_asset_line_id :=
3892: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
3893: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
3894: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3895: l_inv_rec.material_indicator_flag :=
3896: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3897: l_inv_rec.depreciate_in_group_flag :=
3898: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;

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

3892: fa_load_tbl_pkg.inv_table(i).project_asset_line_id;
3893: l_inv_rec.project_id := fa_load_tbl_pkg.inv_table(i).project_id;
3894: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3895: l_inv_rec.material_indicator_flag :=
3896: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3897: l_inv_rec.depreciate_in_group_flag :=
3898: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3899: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3900: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;

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

3894: l_inv_rec.task_id := fa_load_tbl_pkg.inv_table(i).task_id;
3895: l_inv_rec.material_indicator_flag :=
3896: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3897: l_inv_rec.depreciate_in_group_flag :=
3898: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3899: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3900: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3901: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3902: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;

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

3895: l_inv_rec.material_indicator_flag :=
3896: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3897: l_inv_rec.depreciate_in_group_flag :=
3898: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3899: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3900: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3901: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3902: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3903: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;

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

3896: fa_load_tbl_pkg.inv_table(i).material_indicator_flag;
3897: l_inv_rec.depreciate_in_group_flag :=
3898: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3899: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3900: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3901: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3902: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3903: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3904: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;

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

3897: l_inv_rec.depreciate_in_group_flag :=
3898: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3899: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3900: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3901: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3902: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3903: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3904: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3905: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;

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

3898: fa_load_tbl_pkg.inv_table(i).depreciate_in_group_flag;
3899: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3900: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3901: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3902: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3903: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3904: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3905: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3906: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;

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

3899: l_inv_rec.source_line_id := fa_load_tbl_pkg.inv_table(i).source_line_id;
3900: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3901: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3902: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3903: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3904: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3905: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3906: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3907: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;

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

3900: l_inv_rec.attribute1 := fa_load_tbl_pkg.inv_table(i).attribute1;
3901: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3902: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3903: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3904: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3905: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3906: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3907: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3908: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;

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

3901: l_inv_rec.attribute2 := fa_load_tbl_pkg.inv_table(i).attribute2;
3902: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3903: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3904: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3905: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3906: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3907: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3908: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3909: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;

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

3902: l_inv_rec.attribute3 := fa_load_tbl_pkg.inv_table(i).attribute3;
3903: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3904: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3905: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3906: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3907: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3908: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3909: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3910: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;

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

3903: l_inv_rec.attribute4 := fa_load_tbl_pkg.inv_table(i).attribute4;
3904: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3905: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3906: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3907: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3908: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3909: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3910: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3911: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;

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

3904: l_inv_rec.attribute5 := fa_load_tbl_pkg.inv_table(i).attribute5;
3905: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3906: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3907: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3908: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3909: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3910: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3911: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3912: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;

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

3905: l_inv_rec.attribute6 := fa_load_tbl_pkg.inv_table(i).attribute6;
3906: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3907: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3908: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3909: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3910: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3911: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3912: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3913: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;

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

3906: l_inv_rec.attribute7 := fa_load_tbl_pkg.inv_table(i).attribute7;
3907: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3908: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3909: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3910: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3911: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3912: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3913: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
3914: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;

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

3907: l_inv_rec.attribute8 := fa_load_tbl_pkg.inv_table(i).attribute8;
3908: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3909: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3910: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3911: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3912: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3913: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
3914: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
3915: l_inv_rec.attribute_category_code :=

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

3908: l_inv_rec.attribute9 := fa_load_tbl_pkg.inv_table(i).attribute9;
3909: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3910: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3911: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3912: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3913: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
3914: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
3915: l_inv_rec.attribute_category_code :=
3916: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;

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

3909: l_inv_rec.attribute10 := fa_load_tbl_pkg.inv_table(i).attribute10;
3910: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3911: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3912: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3913: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
3914: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
3915: l_inv_rec.attribute_category_code :=
3916: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
3917:

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

3910: l_inv_rec.attribute11 := fa_load_tbl_pkg.inv_table(i).attribute11;
3911: l_inv_rec.attribute12 := fa_load_tbl_pkg.inv_table(i).attribute12;
3912: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3913: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
3914: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
3915: l_inv_rec.attribute_category_code :=
3916: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
3917:
3918: if (p_reset_miss_flag = 'YES') then

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

3912: l_inv_rec.attribute13 := fa_load_tbl_pkg.inv_table(i).attribute13;
3913: l_inv_rec.attribute14 := fa_load_tbl_pkg.inv_table(i).attribute14;
3914: l_inv_rec.attribute15 := fa_load_tbl_pkg.inv_table(i).attribute15;
3915: l_inv_rec.attribute_category_code :=
3916: fa_load_tbl_pkg.inv_table(i).attribute_cat_code;
3917:
3918: if (p_reset_miss_flag = 'YES') then
3919: -- Fix for Bug #2653564. Need to pass different record groups to
3920: -- IN and OUT parameters.