DBA Data[Home] [Help]

APPS.CSI_TXN_HISTORY_PURGE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 66

       Select Min(transaction_id),
              Max(transaction_id)
       Into   from_trans,
              to_trans
       From   CSI_TRANSACTIONS
       Where  creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS');
Line: 98

        select 'x'
        into l_exists
        from CSI_II_FORWARD_SYNC_TEMP
        where date_time_stamp <= to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
        and   process_flag <> 'P'
        and   rownum < 2;
Line: 422

                 Update CSI_OBJECT_DICTIONARY
                 Set    last_archive_date = t_date;
Line: 466

    Select csh.*
    From   CSI_ITEM_INSTANCES_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between From_trans and To_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 480

      Select object_id
      Into   l_table_id
      From   csi_object_dictionary
      Where  object_name = 'CSI_ITEM_INSTANCES_H';
Line: 492

      Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
      Into   v_batch
      From   dual;
Line: 512

      l_inst_hist_rec_tab.instance_id.DELETE;
Line: 513

      l_inst_hist_rec_tab.old_instance_number.DELETE;
Line: 514

      l_inst_hist_rec_tab.new_instance_number.DELETE;
Line: 515

      l_inst_hist_rec_tab.old_external_reference.DELETE;
Line: 516

      l_inst_hist_rec_tab.new_external_reference.DELETE;
Line: 517

      l_inst_hist_rec_tab.old_inventory_item_id.DELETE;
Line: 518

      l_inst_hist_rec_tab.new_inventory_item_id.DELETE;
Line: 519

      l_inst_hist_rec_tab.old_inventory_revision.DELETE;
Line: 520

      l_inst_hist_rec_tab.new_inventory_revision.DELETE;
Line: 521

      l_inst_hist_rec_tab.old_inv_master_org_id.DELETE;
Line: 522

      l_inst_hist_rec_tab.new_inv_master_org_id.DELETE;
Line: 523

      l_inst_hist_rec_tab.old_serial_number.DELETE;
Line: 524

      l_inst_hist_rec_tab.new_serial_number.DELETE;
Line: 525

      l_inst_hist_rec_tab.old_mfg_serial_number_flag.DELETE;
Line: 526

      l_inst_hist_rec_tab.new_mfg_serial_number_flag.DELETE;
Line: 527

      l_inst_hist_rec_tab.old_lot_number.DELETE;
Line: 528

      l_inst_hist_rec_tab.new_lot_number.DELETE;
Line: 529

      l_inst_hist_rec_tab.old_quantity.DELETE;
Line: 530

      l_inst_hist_rec_tab.new_quantity.DELETE;
Line: 531

      l_inst_hist_rec_tab.old_unit_of_measure.DELETE;
Line: 532

      l_inst_hist_rec_tab.new_unit_of_measure.DELETE;
Line: 533

      l_inst_hist_rec_tab.old_accounting_class_code.DELETE;
Line: 534

      l_inst_hist_rec_tab.new_accounting_class_code.DELETE;
Line: 535

      l_inst_hist_rec_tab.old_instance_condition_id.DELETE;
Line: 536

      l_inst_hist_rec_tab.new_instance_condition_id.DELETE;
Line: 537

      l_inst_hist_rec_tab.old_instance_status_id.DELETE;
Line: 538

      l_inst_hist_rec_tab.new_instance_status_id.DELETE;
Line: 539

      l_inst_hist_rec_tab.old_customer_view_flag.DELETE;
Line: 540

      l_inst_hist_rec_tab.new_customer_view_flag.DELETE;
Line: 541

      l_inst_hist_rec_tab.old_merchant_view_flag.DELETE;
Line: 542

      l_inst_hist_rec_tab.new_merchant_view_flag.DELETE;
Line: 543

      l_inst_hist_rec_tab.old_sellable_flag.DELETE;
Line: 544

      l_inst_hist_rec_tab.new_sellable_flag.DELETE;
Line: 545

      l_inst_hist_rec_tab.old_system_id.DELETE;
Line: 546

      l_inst_hist_rec_tab.new_system_id.DELETE;
Line: 547

      l_inst_hist_rec_tab.old_instance_type_code.DELETE;
Line: 548

      l_inst_hist_rec_tab.new_instance_type_code.DELETE;
Line: 549

      l_inst_hist_rec_tab.old_active_start_date.DELETE;
Line: 550

      l_inst_hist_rec_tab.new_active_start_date.DELETE;
Line: 551

      l_inst_hist_rec_tab.old_active_end_date.DELETE;
Line: 552

      l_inst_hist_rec_tab.new_active_end_date.DELETE;
Line: 553

      l_inst_hist_rec_tab.old_location_type_code.DELETE;
Line: 554

      l_inst_hist_rec_tab.new_location_type_code.DELETE;
Line: 555

      l_inst_hist_rec_tab.old_location_id.DELETE;
Line: 556

      l_inst_hist_rec_tab.new_location_id.DELETE;
Line: 557

      l_inst_hist_rec_tab.old_inv_organization_id.DELETE;
Line: 558

      l_inst_hist_rec_tab.new_inv_organization_id.DELETE;
Line: 559

      l_inst_hist_rec_tab.old_inv_subinventory_name.DELETE;
Line: 560

      l_inst_hist_rec_tab.new_inv_subinventory_name.DELETE;
Line: 561

      l_inst_hist_rec_tab.old_inv_locator_id.DELETE;
Line: 562

      l_inst_hist_rec_tab.new_inv_locator_id.DELETE;
Line: 563

      l_inst_hist_rec_tab.old_pa_project_id.DELETE;
Line: 564

      l_inst_hist_rec_tab.new_pa_project_id.DELETE;
Line: 565

      l_inst_hist_rec_tab.old_pa_project_task_id.DELETE;
Line: 566

      l_inst_hist_rec_tab.new_pa_project_task_id.DELETE;
Line: 567

      l_inst_hist_rec_tab.old_in_transit_order_line_id.DELETE;
Line: 568

      l_inst_hist_rec_tab.new_in_transit_order_line_id.DELETE;
Line: 569

      l_inst_hist_rec_tab.old_wip_job_id.DELETE;
Line: 570

      l_inst_hist_rec_tab.new_wip_job_id.DELETE;
Line: 571

      l_inst_hist_rec_tab.old_po_order_line_id.DELETE;
Line: 572

      l_inst_hist_rec_tab.new_po_order_line_id.DELETE;
Line: 573

      l_inst_hist_rec_tab.old_install_date.DELETE;
Line: 574

      l_inst_hist_rec_tab.new_install_date.DELETE;
Line: 575

      l_inst_hist_rec_tab.old_return_by_date.DELETE;
Line: 576

      l_inst_hist_rec_tab.new_return_by_date.DELETE;
Line: 577

      l_inst_hist_rec_tab.old_actual_return_date.DELETE;
Line: 578

      l_inst_hist_rec_tab.new_actual_return_date.DELETE;
Line: 579

      l_inst_hist_rec_tab.old_completeness_flag.DELETE;
Line: 580

      l_inst_hist_rec_tab.new_completeness_flag.DELETE;
Line: 581

      l_inst_hist_rec_tab.old_inst_context.DELETE;
Line: 582

      l_inst_hist_rec_tab.new_inst_context.DELETE;
Line: 583

      l_inst_hist_rec_tab.old_inst_attribute1.DELETE;
Line: 584

      l_inst_hist_rec_tab.new_inst_attribute1.DELETE;
Line: 585

      l_inst_hist_rec_tab.old_inst_attribute2.DELETE;
Line: 586

      l_inst_hist_rec_tab.new_inst_attribute2.DELETE;
Line: 587

      l_inst_hist_rec_tab.old_inst_attribute3.DELETE;
Line: 588

      l_inst_hist_rec_tab.new_inst_attribute3.DELETE;
Line: 589

      l_inst_hist_rec_tab.old_inst_attribute4.DELETE;
Line: 590

      l_inst_hist_rec_tab.new_inst_attribute4.DELETE;
Line: 591

      l_inst_hist_rec_tab.old_inst_attribute5.DELETE;
Line: 592

      l_inst_hist_rec_tab.new_inst_attribute5.DELETE;
Line: 593

      l_inst_hist_rec_tab.old_inst_attribute6.DELETE;
Line: 594

      l_inst_hist_rec_tab.new_inst_attribute6.DELETE;
Line: 595

      l_inst_hist_rec_tab.old_inst_attribute7.DELETE;
Line: 596

      l_inst_hist_rec_tab.new_inst_attribute7.DELETE;
Line: 597

      l_inst_hist_rec_tab.old_inst_attribute8.DELETE;
Line: 598

      l_inst_hist_rec_tab.new_inst_attribute8.DELETE;
Line: 599

      l_inst_hist_rec_tab.old_inst_attribute9.DELETE;
Line: 600

      l_inst_hist_rec_tab.new_inst_attribute9.DELETE;
Line: 601

      l_inst_hist_rec_tab.old_inst_attribute10.DELETE;
Line: 602

      l_inst_hist_rec_tab.new_inst_attribute10.DELETE;
Line: 603

      l_inst_hist_rec_tab.old_inst_attribute11.DELETE;
Line: 604

      l_inst_hist_rec_tab.new_inst_attribute11.DELETE;
Line: 605

      l_inst_hist_rec_tab.old_inst_attribute12.DELETE;
Line: 606

      l_inst_hist_rec_tab.new_inst_attribute12.DELETE;
Line: 607

      l_inst_hist_rec_tab.old_inst_attribute13.DELETE;
Line: 608

      l_inst_hist_rec_tab.new_inst_attribute13.DELETE;
Line: 609

      l_inst_hist_rec_tab.old_inst_attribute14.DELETE;
Line: 610

      l_inst_hist_rec_tab.new_inst_attribute14.DELETE;
Line: 611

      l_inst_hist_rec_tab.old_inst_attribute15.DELETE;
Line: 612

      l_inst_hist_rec_tab.new_inst_attribute15.DELETE;
Line: 613

      l_inst_hist_rec_tab.old_install_location_type_code.DELETE;
Line: 614

      l_inst_hist_rec_tab.new_install_location_type_code.DELETE;
Line: 615

      l_inst_hist_rec_tab.old_install_location_id.DELETE;
Line: 616

      l_inst_hist_rec_tab.new_install_location_id.DELETE;
Line: 617

      l_inst_hist_rec_tab.old_instance_usage_code.DELETE;
Line: 618

      l_inst_hist_rec_tab.new_instance_usage_code.DELETE;
Line: 619

      l_inst_hist_rec_tab.old_config_inst_rev_num.DELETE;
Line: 620

      l_inst_hist_rec_tab.new_config_inst_rev_num.DELETE;
Line: 621

      l_inst_hist_rec_tab.old_config_valid_status.DELETE;
Line: 622

      l_inst_hist_rec_tab.new_config_valid_status.DELETE;
Line: 623

      l_inst_hist_rec_tab.old_instance_description.DELETE;
Line: 624

      l_inst_hist_rec_tab.new_instance_description.DELETE;
Line: 625

      l_inst_hist_rec_tab.instance_history_id.DELETE;
Line: 626

      l_inst_hist_rec_tab.transaction_id.DELETE;
Line: 627

      l_inst_hist_rec_tab.old_last_vld_organization_id.DELETE;
Line: 628

      l_inst_hist_rec_tab.new_last_vld_organization_id.DELETE;
Line: 629

      l_inst_hist_rec_tab.old_last_oe_agreement_id.DELETE;
Line: 630

      l_inst_hist_rec_tab.new_last_oe_agreement_id.DELETE;
Line: 631

      l_inst_hist_rec_tab.inst_full_dump_flag.DELETE;
Line: 632

      l_inst_hist_rec_tab.inst_created_by.DELETE;
Line: 633

      l_inst_hist_rec_tab.inst_creation_date.DELETE;
Line: 634

      l_inst_hist_rec_tab.inst_last_updated_by.DELETE;
Line: 635

      l_inst_hist_rec_tab.inst_last_update_date.DELETE;
Line: 636

      l_inst_hist_rec_tab.inst_last_update_login.DELETE;
Line: 637

      l_inst_hist_rec_tab.inst_object_version_number.DELETE;
Line: 638

      l_inst_hist_rec_tab.inst_security_group_id.DELETE;
Line: 639

      l_inst_hist_rec_tab.inst_migrated_flag.DELETE;
Line: 641

      l_inst_hist_rec_tab.old_network_asset_flag.DELETE;
Line: 642

      l_inst_hist_rec_tab.new_network_asset_flag.DELETE;
Line: 643

      l_inst_hist_rec_tab.old_maintainable_flag.DELETE;
Line: 644

      l_inst_hist_rec_tab.new_maintainable_flag.DELETE;
Line: 645

      l_inst_hist_rec_tab.old_pn_location_id.DELETE;
Line: 646

      l_inst_hist_rec_tab.new_pn_location_id.DELETE;
Line: 647

      l_inst_hist_rec_tab.old_asset_criticality_code.DELETE;
Line: 648

      l_inst_hist_rec_tab.new_asset_criticality_code.DELETE;
Line: 649

      l_inst_hist_rec_tab.old_category_id.DELETE;
Line: 650

      l_inst_hist_rec_tab.new_category_id.DELETE;
Line: 651

      l_inst_hist_rec_tab.old_equipment_gen_object_id.DELETE;
Line: 652

      l_inst_hist_rec_tab.new_equipment_gen_object_id.DELETE;
Line: 653

      l_inst_hist_rec_tab.old_instantiation_flag.DELETE;
Line: 654

      l_inst_hist_rec_tab.new_instantiation_flag.DELETE;
Line: 655

      l_inst_hist_rec_tab.old_linear_location_id.DELETE;
Line: 656

      l_inst_hist_rec_tab.new_linear_location_id.DELETE;
Line: 657

      l_inst_hist_rec_tab.old_operational_log_flag.DELETE;
Line: 658

      l_inst_hist_rec_tab.new_operational_log_flag.DELETE;
Line: 659

      l_inst_hist_rec_tab.old_checkin_status.DELETE;
Line: 660

      l_inst_hist_rec_tab.new_checkin_status.DELETE;
Line: 661

      l_inst_hist_rec_tab.old_supplier_warranty_exp_date.DELETE;
Line: 662

      l_inst_hist_rec_tab.new_supplier_warranty_exp_date.DELETE;
Line: 663

      l_inst_hist_rec_tab.old_inst_attribute16.DELETE;
Line: 664

      l_inst_hist_rec_tab.new_inst_attribute16.DELETE;
Line: 665

      l_inst_hist_rec_tab.old_inst_attribute17.DELETE;
Line: 666

      l_inst_hist_rec_tab.new_inst_attribute17.DELETE;
Line: 667

      l_inst_hist_rec_tab.old_inst_attribute18.DELETE;
Line: 668

      l_inst_hist_rec_tab.new_inst_attribute18.DELETE;
Line: 669

      l_inst_hist_rec_tab.old_inst_attribute19.DELETE;
Line: 670

      l_inst_hist_rec_tab.new_inst_attribute19.DELETE;
Line: 671

      l_inst_hist_rec_tab.old_inst_attribute20.DELETE;
Line: 672

      l_inst_hist_rec_tab.new_inst_attribute20.DELETE;
Line: 673

      l_inst_hist_rec_tab.old_inst_attribute21.DELETE;
Line: 674

      l_inst_hist_rec_tab.new_inst_attribute21.DELETE;
Line: 675

      l_inst_hist_rec_tab.old_inst_attribute22.DELETE;
Line: 676

      l_inst_hist_rec_tab.new_inst_attribute22.DELETE;
Line: 677

      l_inst_hist_rec_tab.old_inst_attribute23.DELETE;
Line: 678

      l_inst_hist_rec_tab.new_inst_attribute23.DELETE;
Line: 679

      l_inst_hist_rec_tab.old_inst_attribute24.DELETE;
Line: 680

      l_inst_hist_rec_tab.new_inst_attribute24.DELETE;
Line: 681

      l_inst_hist_rec_tab.old_inst_attribute25.DELETE;
Line: 682

      l_inst_hist_rec_tab.new_inst_attribute25.DELETE;
Line: 683

      l_inst_hist_rec_tab.old_inst_attribute26.DELETE;
Line: 684

      l_inst_hist_rec_tab.new_inst_attribute26.DELETE;
Line: 685

      l_inst_hist_rec_tab.old_inst_attribute27.DELETE;
Line: 686

      l_inst_hist_rec_tab.new_inst_attribute27.DELETE;
Line: 687

      l_inst_hist_rec_tab.old_inst_attribute28.DELETE;
Line: 688

      l_inst_hist_rec_tab.new_inst_attribute28.DELETE;
Line: 689

      l_inst_hist_rec_tab.old_inst_attribute29.DELETE;
Line: 690

      l_inst_hist_rec_tab.new_inst_attribute29.DELETE;
Line: 691

      l_inst_hist_rec_tab.old_inst_attribute30.DELETE;
Line: 692

      l_inst_hist_rec_tab.new_inst_attribute30.DELETE;
Line: 700

      Select csi_history_archive_s.Nextval
      Into l_archive_id_tbl(l_ctr)
      From dual;
Line: 826

      l_inst_hist_rec_tab.inst_last_updated_by(l_ctr)           :=  i.last_updated_by;
Line: 827

      l_inst_hist_rec_tab.inst_last_update_date(l_ctr)          :=  i.last_update_date;
Line: 828

      l_inst_hist_rec_tab.inst_last_update_login(l_ctr)         :=  i.last_update_login;
Line: 904

         Insert Into CSI_HISTORY_ARCHIVE
         (
           HISTORY_ARCHIVE_ID
          ,OBJECT_ID
          ,ENTITY_HISTORY_ID
          ,TRANSACTION_ID
          ,ENTITY_ID
          ,COL_NUM_01
          ,COL_NUM_02
          ,COL_NUM_03
          ,COL_NUM_04
          ,COL_NUM_05
          ,COL_NUM_06
          ,COL_NUM_07
          ,COL_NUM_08
          ,COL_NUM_09
          ,COL_NUM_10
          ,COL_NUM_11
          ,COL_NUM_12
          ,COL_NUM_13
          ,COL_NUM_14
          ,COL_NUM_15
          ,COL_NUM_16
          ,COL_NUM_17
          ,COL_NUM_18
          ,COL_NUM_19
          ,COL_NUM_20
          ,COL_NUM_21
          ,COL_NUM_22
          ,COL_NUM_23
          ,COL_NUM_24
          ,COL_NUM_25
          ,COL_NUM_26
          ,COL_NUM_27
          ,COL_NUM_28
          ,COL_NUM_29
          ,COL_NUM_30
          ,COL_NUM_31
          ,COL_NUM_32
          ,COL_NUM_33
          ,COL_NUM_34
          ,COL_NUM_35
          ,COL_NUM_36
          ,COL_NUM_37 -- entity creation_by
          ,COL_NUM_38 -- entity last_updated_by
          ,COL_NUM_39 -- entity last_update_login
          ,COL_NUM_40 -- entity object_version_number
          ,COL_NUM_41 -- entity security_group_id

          ,COL_NUM_42 -- entity old_pn_location_id
          ,COL_NUM_43 -- entity new_pn_location_id
          ,COL_NUM_44 -- entity old_category_id
          ,COL_NUM_45 -- entity new_category_id
          ,COL_NUM_46 -- entity old_equipment_gen_object_id
          ,COL_NUM_47 -- entity new_equipment_gen_object_id
          ,COL_NUM_48 -- entity old_linear_location_id
          ,COL_NUM_49 -- entity new_linear_location_id
          ,COL_NUM_50 -- entity old_checkin_status
          ,COL_NUM_51 -- entity new_checkin_status

          ,COL_CHAR_01
          ,COL_CHAR_02
          ,COL_CHAR_03
          ,COL_CHAR_04
          ,COL_CHAR_05
          ,COL_CHAR_06
          ,COL_CHAR_07
          ,COL_CHAR_08
          ,COL_CHAR_09
          ,COL_CHAR_10
          ,COL_CHAR_11
          ,COL_CHAR_12
          ,COL_CHAR_13
          ,COL_CHAR_14
          ,COL_CHAR_15
          ,COL_CHAR_16
          ,COL_CHAR_17
          ,COL_CHAR_18
          ,COL_CHAR_19
          ,COL_CHAR_20
          ,COL_CHAR_21
          ,COL_CHAR_22
          ,COL_CHAR_23
          ,COL_CHAR_24
          ,COL_CHAR_25
          ,COL_CHAR_26
          ,COL_CHAR_27
          ,COL_CHAR_28
          ,COL_CHAR_29
          ,COL_CHAR_30
          ,COL_CHAR_31 -- entity old_context
          ,COL_CHAR_32 -- entity new_context
          ,COL_CHAR_33 -- entity old_attribute1
          ,COL_CHAR_34 -- entity new_attribute1
          ,COL_CHAR_35 -- entity old_attribute2
          ,COL_CHAR_36 -- entity new_attribute2
          ,COL_CHAR_37 -- entity old_attribute3
          ,COL_CHAR_38 -- entity new_attribute3
          ,COL_CHAR_39 -- entity old_attribute4
          ,COL_CHAR_40 -- entity new_attribute4
          ,COL_CHAR_41 -- entity old_attribute5
          ,COL_CHAR_42 -- entity new_attribute5
          ,COL_CHAR_43 -- entity old_attribute6
          ,COL_CHAR_44 -- entity new_attribute6
          ,COL_CHAR_45 -- entity old_attribute7
          ,COL_CHAR_46 -- entity new_attribute7
          ,COL_CHAR_47 -- entity old_attribute8
          ,COL_CHAR_48 -- entity new_attribute8
          ,COL_CHAR_49 -- entity old_attribute9
          ,COL_CHAR_50 -- entity new_attribute9
          ,COL_CHAR_51 -- entity old_attribute10
          ,COL_CHAR_52 -- entity new_attribute10
          ,COL_CHAR_53 -- entity old_attribute11
          ,COL_CHAR_54 -- entity new_attribute11
          ,COL_CHAR_55 -- entity old_attribute12
          ,COL_CHAR_56 -- entity new_attribute12
          ,COL_CHAR_57 -- entity old_attribute13
          ,COL_CHAR_58 -- entity new_attribute13
          ,COL_CHAR_59 -- entity old_attribute14
          ,COL_CHAR_60 -- entity new_attribute14
          ,COL_CHAR_61 -- entity old_attribute15
          ,COL_CHAR_62 -- entity new_attribute15
          ,COL_CHAR_63
          ,COL_CHAR_64
          ,COL_CHAR_65
          ,COL_CHAR_66
          ,COL_CHAR_67
          ,COL_CHAR_68
          ,COL_CHAR_69
          ,COL_CHAR_70
          ,COL_CHAR_71 -- entity full_dump_flag
          ,COL_CHAR_72 -- entity migrated_flag

          ,COL_CHAR_73 -- entity old_attribute16
          ,COL_CHAR_74 -- entity new_attribute16
          ,COL_CHAR_75 -- entity old_attribute17
          ,COL_CHAR_76 -- entity new_attribute17
          ,COL_CHAR_77 -- entity old_attribute18
          ,COL_CHAR_78 -- entity new_attribute18
          ,COL_CHAR_79 -- entity old_attribute19
          ,COL_CHAR_80 -- entity new_attribute19
          ,COL_CHAR_81 -- entity old_attribute20
          ,COL_CHAR_82 -- entity new_attribute20
          ,COL_CHAR_83 -- entity old_attribute21
          ,COL_CHAR_84 -- entity new_attribute21
          ,COL_CHAR_85 -- entity old_attribute22
          ,COL_CHAR_86 -- entity new_attribute22
          ,COL_CHAR_87 -- entity old_attribute23
          ,COL_CHAR_88 -- entity new_attribute23
          ,COL_CHAR_89 -- entity old_attribute24
          ,COL_CHAR_90 -- entity new_attribute24
          ,COL_CHAR_91 -- entity old_attribute25
          ,COL_CHAR_92 -- entity new_attribute25
          ,COL_CHAR_93 -- entity old_attribute26
          ,COL_CHAR_94 -- entity new_attribute26
          ,COL_CHAR_95 -- entity old_attribute27
          ,COL_CHAR_96 -- entity new_attribute27
          ,COL_CHAR_97 -- entity old_attribute28
          ,COL_CHAR_98 -- entity new_attribute28
          ,COL_CHAR_99 -- entity old_attribute29
          ,COL_CHAR_100 -- entity new_attribute29
          ,COL_CHAR_101 -- entity old_attribute30
          ,COL_CHAR_102 -- entity new_attribute30

          ,COL_CHAR_103 -- entity old_network_asset_flag
          ,COL_CHAR_104 -- entity new_network_asset_flag
          ,COL_CHAR_105 -- entity old_maintainable_flag
          ,COL_CHAR_106 -- entity new_maintainable_flag
          ,COL_CHAR_107 -- entity old_asset_criticality_code
          ,COL_CHAR_108 -- entity new_asset_criticality_code
          ,COL_CHAR_109 -- entity old_instantiation_flag
          ,COL_CHAR_110 -- entity new_instantiation_flag
          ,COL_CHAR_111 -- entity old_operational_log_flag
          ,COL_CHAR_112 -- entity new_operational_log_flag

          ,COL_DATE_01  -- entity old_active_start_date
          ,COL_DATE_02  -- entity new_active_start_date
          ,COL_DATE_03  -- entity old_active_end_date
          ,COL_DATE_04  -- entity new_active_end_date
          ,COL_DATE_05
          ,COL_DATE_06
          ,COL_DATE_07
          ,COL_DATE_08
          ,COL_DATE_09
          ,COL_DATE_10
          ,COL_DATE_11 -- entity creation_date
          ,COL_DATE_12 -- entity last_update_date

          ,COL_DATE_13 -- entity old_supplier_warranty_exp_date
          ,COL_DATE_14 -- entity new_supplier_warranty_exp_date

          ,CONTEXT
          ,ATTRIBUTE1
          ,ATTRIBUTE2
          ,ATTRIBUTE3
          ,ATTRIBUTE4
          ,ATTRIBUTE5
          ,ATTRIBUTE6
          ,ATTRIBUTE7
          ,ATTRIBUTE8
          ,ATTRIBUTE9
          ,ATTRIBUTE10
          ,ATTRIBUTE11
          ,ATTRIBUTE12
          ,ATTRIBUTE13
          ,ATTRIBUTE14
          ,ATTRIBUTE15
          ,CREATED_BY
          ,CREATION_DATE
          ,LAST_UPDATED_BY
          ,LAST_UPDATE_DATE
          ,LAST_UPDATE_LOGIN
          ,OBJECT_VERSION_NUMBER
          ,SECURITY_GROUP_ID
          )
		  Values
          (
          l_archive_id_tbl(i),
          l_table_id,
	 	  l_inst_hist_rec_tab.instance_history_id(i),
		  l_inst_hist_rec_tab.transaction_id(i),
		  l_inst_hist_rec_tab.instance_id(i),
		  l_inst_hist_rec_tab.old_inventory_item_id(i),
		  l_inst_hist_rec_tab.new_inventory_item_id(i),
		  l_inst_hist_rec_tab.old_inv_master_org_id(i),
		  l_inst_hist_rec_tab.new_inv_master_org_id(i),
		  l_inst_hist_rec_tab.old_quantity(i),
		  l_inst_hist_rec_tab.new_quantity(i),
		  l_inst_hist_rec_tab.old_instance_condition_id(i),
		  l_inst_hist_rec_tab.new_instance_condition_id(i),
		  l_inst_hist_rec_tab.old_instance_status_id(i),
		  l_inst_hist_rec_tab.new_instance_status_id(i),
		  l_inst_hist_rec_tab.old_system_id(i),
		  l_inst_hist_rec_tab.new_system_id(i),
		  l_inst_hist_rec_tab.old_location_id(i),
		  l_inst_hist_rec_tab.new_location_id(i),
		  l_inst_hist_rec_tab.old_inv_organization_id(i),
		  l_inst_hist_rec_tab.new_inv_organization_id(i),
		  l_inst_hist_rec_tab.old_inv_locator_id(i),
		  l_inst_hist_rec_tab.new_inv_locator_id(i),
		  l_inst_hist_rec_tab.old_pa_project_id(i),
		  l_inst_hist_rec_tab.new_pa_project_id(i),
		  l_inst_hist_rec_tab.old_pa_project_task_id(i),
		  l_inst_hist_rec_tab.new_pa_project_task_id(i),
		  l_inst_hist_rec_tab.old_in_transit_order_line_id(i),
		  l_inst_hist_rec_tab.new_in_transit_order_line_id(i),
		  l_inst_hist_rec_tab.old_wip_job_id(i),
		  l_inst_hist_rec_tab.new_wip_job_id(i),
		  l_inst_hist_rec_tab.old_po_order_line_id(i),
		  l_inst_hist_rec_tab.new_po_order_line_id(i),
		  l_inst_hist_rec_tab.old_install_location_id(i),
		  l_inst_hist_rec_tab.new_install_location_id(i),
		  l_inst_hist_rec_tab.old_last_vld_organization_id(i),
		  l_inst_hist_rec_tab.new_last_vld_organization_id(i),
          l_inst_hist_rec_tab.old_last_oe_agreement_id(i),
          l_inst_hist_rec_tab.new_last_oe_agreement_id(i),
		  l_inst_hist_rec_tab.old_config_inst_rev_num(i),
		  l_inst_hist_rec_tab.new_config_inst_rev_num(i),
   		  l_inst_hist_rec_tab.inst_created_by(i),
   		  l_inst_hist_rec_tab.inst_last_updated_by(i),
   		  l_inst_hist_rec_tab.inst_last_update_login(i),
   		  l_inst_hist_rec_tab.inst_object_version_number(i),
   		  l_inst_hist_rec_tab.inst_security_group_id(i),
          -- Added for eam
          l_inst_hist_rec_tab.old_pn_location_id(i),
          l_inst_hist_rec_tab.new_pn_location_id(i),
          l_inst_hist_rec_tab.old_category_id(i),
          l_inst_hist_rec_tab.new_category_id(i),
          l_inst_hist_rec_tab.old_equipment_gen_object_id(i),
          l_inst_hist_rec_tab.new_equipment_gen_object_id(i),
          l_inst_hist_rec_tab.old_linear_location_id(i),
          l_inst_hist_rec_tab.new_linear_location_id(i),
          l_inst_hist_rec_tab.old_checkin_status(i),
          l_inst_hist_rec_tab.new_checkin_status(i),
          -- End addition for eam
		  l_inst_hist_rec_tab.old_instance_number(i),
		  l_inst_hist_rec_tab.new_instance_number(i),
		  l_inst_hist_rec_tab.old_external_reference(i),
		  l_inst_hist_rec_tab.new_external_reference(i),
		  l_inst_hist_rec_tab.old_inventory_revision(i),
		  l_inst_hist_rec_tab.new_inventory_revision(i),
		  l_inst_hist_rec_tab.old_serial_number(i),
		  l_inst_hist_rec_tab.new_serial_number(i),
		  l_inst_hist_rec_tab.old_mfg_serial_number_flag(i),
		  l_inst_hist_rec_tab.new_mfg_serial_number_flag(i),
		  l_inst_hist_rec_tab.old_lot_number(i),
		  l_inst_hist_rec_tab.new_lot_number(i),
		  l_inst_hist_rec_tab.old_unit_of_measure(i),
		  l_inst_hist_rec_tab.new_unit_of_measure(i),
		  l_inst_hist_rec_tab.old_accounting_class_code(i),
		  l_inst_hist_rec_tab.new_accounting_class_code(i),
		  l_inst_hist_rec_tab.old_customer_view_flag(i),
		  l_inst_hist_rec_tab.new_customer_view_flag(i),
		  l_inst_hist_rec_tab.old_merchant_view_flag(i),
		  l_inst_hist_rec_tab.new_merchant_view_flag(i),
		  l_inst_hist_rec_tab.old_sellable_flag(i),
		  l_inst_hist_rec_tab.new_sellable_flag(i),
		  l_inst_hist_rec_tab.old_instance_type_code(i),
		  l_inst_hist_rec_tab.new_instance_type_code(i),
		  l_inst_hist_rec_tab.old_location_type_code(i),
		  l_inst_hist_rec_tab.new_location_type_code(i),
		  l_inst_hist_rec_tab.old_inv_subinventory_name(i),
		  l_inst_hist_rec_tab.new_inv_subinventory_name(i),
		  l_inst_hist_rec_tab.old_completeness_flag(i),
		  l_inst_hist_rec_tab.new_completeness_flag(i),
		  l_inst_hist_rec_tab.old_inst_context(i),
		  l_inst_hist_rec_tab.new_inst_context(i),
		  l_inst_hist_rec_tab.old_inst_attribute1(i),
		  l_inst_hist_rec_tab.new_inst_attribute1(i),
		  l_inst_hist_rec_tab.old_inst_attribute2(i),
		  l_inst_hist_rec_tab.new_inst_attribute2(i),
		  l_inst_hist_rec_tab.old_inst_attribute3(i),
		  l_inst_hist_rec_tab.new_inst_attribute3(i),
		  l_inst_hist_rec_tab.old_inst_attribute4(i),
		  l_inst_hist_rec_tab.new_inst_attribute4(i),
		  l_inst_hist_rec_tab.old_inst_attribute5(i),
		  l_inst_hist_rec_tab.new_inst_attribute5(i),
		  l_inst_hist_rec_tab.old_inst_attribute6(i),
		  l_inst_hist_rec_tab.new_inst_attribute6(i),
		  l_inst_hist_rec_tab.old_inst_attribute7(i),
		  l_inst_hist_rec_tab.new_inst_attribute7(i),
		  l_inst_hist_rec_tab.old_inst_attribute8(i),
		  l_inst_hist_rec_tab.new_inst_attribute8(i),
		  l_inst_hist_rec_tab.old_inst_attribute9(i),
		  l_inst_hist_rec_tab.new_inst_attribute9(i),
		  l_inst_hist_rec_tab.old_inst_attribute10(i),
		  l_inst_hist_rec_tab.new_inst_attribute10(i),
		  l_inst_hist_rec_tab.old_inst_attribute11(i),
		  l_inst_hist_rec_tab.new_inst_attribute11(i),
		  l_inst_hist_rec_tab.old_inst_attribute12(i),
		  l_inst_hist_rec_tab.new_inst_attribute12(i),
		  l_inst_hist_rec_tab.old_inst_attribute13(i),
		  l_inst_hist_rec_tab.new_inst_attribute13(i),
		  l_inst_hist_rec_tab.old_inst_attribute14(i),
		  l_inst_hist_rec_tab.new_inst_attribute14(i),
		  l_inst_hist_rec_tab.old_inst_attribute15(i),
		  l_inst_hist_rec_tab.new_inst_attribute15(i),
		  l_inst_hist_rec_tab.old_install_location_type_code(i),
		  l_inst_hist_rec_tab.new_install_location_type_code(i),
		  l_inst_hist_rec_tab.old_instance_usage_code(i),
		  l_inst_hist_rec_tab.new_instance_usage_code(i),
		  l_inst_hist_rec_tab.old_config_valid_status(i),
		  l_inst_hist_rec_tab.new_config_valid_status(i),
		  l_inst_hist_rec_tab.old_instance_description(i),
		  l_inst_hist_rec_tab.new_instance_description(i),
		  l_inst_hist_rec_tab.inst_full_dump_flag(i),
   		  l_inst_hist_rec_tab.inst_migrated_flag(i),
       -- Added for eam
          l_inst_hist_rec_tab.old_inst_attribute16(i),
          l_inst_hist_rec_tab.new_inst_attribute16(i),
          l_inst_hist_rec_tab.old_inst_attribute17(i),
          l_inst_hist_rec_tab.new_inst_attribute17(i),
          l_inst_hist_rec_tab.old_inst_attribute18(i),
          l_inst_hist_rec_tab.new_inst_attribute18(i),
          l_inst_hist_rec_tab.old_inst_attribute19(i),
          l_inst_hist_rec_tab.new_inst_attribute19(i),
          l_inst_hist_rec_tab.old_inst_attribute20(i),
          l_inst_hist_rec_tab.new_inst_attribute20(i),
          l_inst_hist_rec_tab.old_inst_attribute21(i),
          l_inst_hist_rec_tab.new_inst_attribute21(i),
          l_inst_hist_rec_tab.old_inst_attribute22(i),
          l_inst_hist_rec_tab.new_inst_attribute22(i),
          l_inst_hist_rec_tab.old_inst_attribute23(i),
          l_inst_hist_rec_tab.new_inst_attribute23(i),
          l_inst_hist_rec_tab.old_inst_attribute24(i),
          l_inst_hist_rec_tab.new_inst_attribute24(i),
          l_inst_hist_rec_tab.old_inst_attribute25(i),
          l_inst_hist_rec_tab.new_inst_attribute25(i),
          l_inst_hist_rec_tab.old_inst_attribute26(i),
          l_inst_hist_rec_tab.new_inst_attribute26(i),
          l_inst_hist_rec_tab.old_inst_attribute27(i),
          l_inst_hist_rec_tab.new_inst_attribute27(i),
          l_inst_hist_rec_tab.old_inst_attribute28(i),
          l_inst_hist_rec_tab.new_inst_attribute28(i),
          l_inst_hist_rec_tab.old_inst_attribute29(i),
          l_inst_hist_rec_tab.new_inst_attribute29(i),
          l_inst_hist_rec_tab.old_inst_attribute30(i),
          l_inst_hist_rec_tab.new_inst_attribute30(i),

          l_inst_hist_rec_tab.old_network_asset_flag(i),
          l_inst_hist_rec_tab.new_network_asset_flag(i),
          l_inst_hist_rec_tab.old_maintainable_flag(i),
          l_inst_hist_rec_tab.new_maintainable_flag(i),
          l_inst_hist_rec_tab.old_asset_criticality_code(i),
          l_inst_hist_rec_tab.new_asset_criticality_code(i),
          l_inst_hist_rec_tab.old_instantiation_flag(i),
          l_inst_hist_rec_tab.new_instantiation_flag(i),
          l_inst_hist_rec_tab.old_operational_log_flag(i),
          l_inst_hist_rec_tab.new_operational_log_flag(i),

       -- End addition for eam
		  l_inst_hist_rec_tab.old_active_start_date(i),
		  l_inst_hist_rec_tab.new_active_start_date(i),
		  l_inst_hist_rec_tab.old_active_end_date(i),
		  l_inst_hist_rec_tab.new_active_end_date(i),
          l_inst_hist_rec_tab.old_install_date(i),
          l_inst_hist_rec_tab.new_install_date(i),
          l_inst_hist_rec_tab.old_return_by_date(i),
          l_inst_hist_rec_tab.new_return_by_date(i),
          l_inst_hist_rec_tab.old_actual_return_date(i),
          l_inst_hist_rec_tab.new_actual_return_date(i),
   		  l_inst_hist_rec_tab.inst_creation_date(i),
   		  l_inst_hist_rec_tab.inst_last_update_date(i),
          -- Added for eam
          l_inst_hist_rec_tab.old_supplier_warranty_exp_date(i),
          l_inst_hist_rec_tab.new_supplier_warranty_exp_date(i),
          -- End addition for eam
          null,
          null,
          null,
          null,
          null,
          null,
          null,
          null,
          null,
          null,
          null,
          null,
          null,
          null,
          null,
          null,
          l_user_id,
          sysdate,
          l_user_id,
          sysdate,
          l_login_id,
          1,
          null
         );
Line: 1340

         Delete From CSI_ITEM_INSTANCES_H
         Where instance_history_id = l_inst_hist_rec_tab.instance_history_id(i);
Line: 1347

         Update CSI_ITEM_INSTANCES
         Set last_purge_date = to_date(purge_to_date,'YYYY/MM/DD HH24:MI:SS')
         Where instance_id = l_inst_hist_rec_tab.instance_id(i);
Line: 1408

    Select csh.*
    From   CSI_I_PARTIES_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between from_trans and to_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 1423

      Select object_id
      Into   l_table_id
      From   csi_object_dictionary
      Where  object_name = 'CSI_I_PARTIES_H';
Line: 1435

      Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
      Into   v_batch
      From   dual;
Line: 1455

      l_pty_hist_rec_tab.instance_party_history_id.DELETE;
Line: 1456

      l_pty_hist_rec_tab.instance_party_id.DELETE;
Line: 1457

      l_pty_hist_rec_tab.transaction_id.DELETE;
Line: 1458

      l_pty_hist_rec_tab.old_party_source_table.DELETE;
Line: 1459

      l_pty_hist_rec_tab.new_party_source_table.DELETE;
Line: 1460

      l_pty_hist_rec_tab.old_party_id.DELETE;
Line: 1461

      l_pty_hist_rec_tab.new_party_id.DELETE;
Line: 1462

      l_pty_hist_rec_tab.old_relationship_type_code.DELETE;
Line: 1463

      l_pty_hist_rec_tab.new_relationship_type_code.DELETE;
Line: 1464

      l_pty_hist_rec_tab.old_contact_flag.DELETE;
Line: 1465

      l_pty_hist_rec_tab.new_contact_flag.DELETE;
Line: 1466

      l_pty_hist_rec_tab.old_contact_ip_id.DELETE;
Line: 1467

      l_pty_hist_rec_tab.new_contact_ip_id.DELETE;
Line: 1468

      l_pty_hist_rec_tab.old_active_start_date.DELETE;
Line: 1469

      l_pty_hist_rec_tab.new_active_start_date.DELETE;
Line: 1470

      l_pty_hist_rec_tab.old_active_end_date.DELETE;
Line: 1471

      l_pty_hist_rec_tab.new_active_end_date.DELETE;
Line: 1472

      l_pty_hist_rec_tab.old_context.DELETE;
Line: 1473

      l_pty_hist_rec_tab.new_context.DELETE;
Line: 1474

      l_pty_hist_rec_tab.old_attribute1.DELETE;
Line: 1475

      l_pty_hist_rec_tab.new_attribute1.DELETE;
Line: 1476

      l_pty_hist_rec_tab.old_attribute2.DELETE;
Line: 1477

      l_pty_hist_rec_tab.new_attribute2.DELETE;
Line: 1478

      l_pty_hist_rec_tab.old_attribute3.DELETE;
Line: 1479

      l_pty_hist_rec_tab.new_attribute3.DELETE;
Line: 1480

      l_pty_hist_rec_tab.old_attribute4.DELETE;
Line: 1481

      l_pty_hist_rec_tab.new_attribute4.DELETE;
Line: 1482

      l_pty_hist_rec_tab.old_attribute5.DELETE;
Line: 1483

      l_pty_hist_rec_tab.new_attribute5.DELETE;
Line: 1484

      l_pty_hist_rec_tab.old_attribute6.DELETE;
Line: 1485

      l_pty_hist_rec_tab.new_attribute6.DELETE;
Line: 1486

      l_pty_hist_rec_tab.old_attribute7.DELETE;
Line: 1487

      l_pty_hist_rec_tab.new_attribute7.DELETE;
Line: 1488

      l_pty_hist_rec_tab.old_attribute8.DELETE;
Line: 1489

      l_pty_hist_rec_tab.new_attribute8.DELETE;
Line: 1490

      l_pty_hist_rec_tab.old_attribute9.DELETE;
Line: 1491

      l_pty_hist_rec_tab.new_attribute9.DELETE;
Line: 1492

      l_pty_hist_rec_tab.old_attribute10.DELETE;
Line: 1493

      l_pty_hist_rec_tab.new_attribute10.DELETE;
Line: 1494

      l_pty_hist_rec_tab.old_attribute11.DELETE;
Line: 1495

      l_pty_hist_rec_tab.new_attribute11.DELETE;
Line: 1496

      l_pty_hist_rec_tab.old_attribute12.DELETE;
Line: 1497

      l_pty_hist_rec_tab.new_attribute12.DELETE;
Line: 1498

      l_pty_hist_rec_tab.old_attribute13.DELETE;
Line: 1499

      l_pty_hist_rec_tab.new_attribute13.DELETE;
Line: 1500

      l_pty_hist_rec_tab.old_attribute14.DELETE;
Line: 1501

      l_pty_hist_rec_tab.new_attribute14.DELETE;
Line: 1502

      l_pty_hist_rec_tab.old_attribute15.DELETE;
Line: 1503

      l_pty_hist_rec_tab.new_attribute15.DELETE;
Line: 1504

      l_pty_hist_rec_tab.old_preferred_flag.DELETE;
Line: 1505

      l_pty_hist_rec_tab.new_preferred_flag.DELETE;
Line: 1506

      l_pty_hist_rec_tab.old_primary_flag.DELETE;
Line: 1507

      l_pty_hist_rec_tab.new_primary_flag.DELETE;
Line: 1508

      l_pty_hist_rec_tab.pty_full_dump_flag.DELETE;
Line: 1509

      l_pty_hist_rec_tab.pty_created_by.DELETE;
Line: 1510

      l_pty_hist_rec_tab.pty_creation_date.DELETE;
Line: 1511

      l_pty_hist_rec_tab.pty_last_updated_by.DELETE;
Line: 1512

      l_pty_hist_rec_tab.pty_last_update_date.DELETE;
Line: 1513

      l_pty_hist_rec_tab.pty_last_update_login.DELETE;
Line: 1514

      l_pty_hist_rec_tab.pty_object_version_number.DELETE;
Line: 1515

      l_pty_hist_rec_tab.pty_security_group_id.DELETE;
Line: 1516

      l_pty_hist_rec_tab.pty_migrated_flag.DELETE;
Line: 1524

      Select csi_history_archive_s.Nextval
      Into l_archive_id_tbl(l_ctr)
      From dual;
Line: 1584

      l_pty_hist_rec_tab.pty_last_updated_by(l_ctr)        :=  i.last_updated_by;
Line: 1585

      l_pty_hist_rec_tab.pty_last_update_date(l_ctr)       :=  i.last_update_date;
Line: 1586

      l_pty_hist_rec_tab.pty_last_update_login(l_ctr)      :=  i.last_update_login;
Line: 1606

         Insert Into CSI_HISTORY_ARCHIVE
         (
            HISTORY_ARCHIVE_ID
           ,OBJECT_ID
           ,ENTITY_HISTORY_ID
           ,TRANSACTION_ID
           ,ENTITY_ID
           ,COL_NUM_01
           ,COL_NUM_02
           ,COL_NUM_03
           ,COL_NUM_04
           ,COL_NUM_37
           ,COL_NUM_38
           ,COL_NUM_39
           ,COL_NUM_40
           ,COL_NUM_41
           ,COL_CHAR_01
           ,COL_CHAR_02
           ,COL_CHAR_03
           ,COL_CHAR_04
           ,COL_CHAR_05
           ,COL_CHAR_06
           ,COL_CHAR_07
           ,COL_CHAR_08
           ,COL_CHAR_09
           ,COL_CHAR_10
           ,COL_CHAR_31
           ,COL_CHAR_32
           ,COL_CHAR_33
           ,COL_CHAR_34
           ,COL_CHAR_35
           ,COL_CHAR_36
           ,COL_CHAR_37
           ,COL_CHAR_38
           ,COL_CHAR_39
           ,COL_CHAR_40
           ,COL_CHAR_41
           ,COL_CHAR_42
           ,COL_CHAR_43
           ,COL_CHAR_44
           ,COL_CHAR_45
           ,COL_CHAR_46
           ,COL_CHAR_47
           ,COL_CHAR_48
           ,COL_CHAR_49
           ,COL_CHAR_50
           ,COL_CHAR_51
           ,COL_CHAR_52
           ,COL_CHAR_53
           ,COL_CHAR_54
           ,COL_CHAR_55
           ,COL_CHAR_56
           ,COL_CHAR_57
           ,COL_CHAR_58
           ,COL_CHAR_59
           ,COL_CHAR_60
           ,COL_CHAR_61
           ,COL_CHAR_62
           ,COL_CHAR_71
           ,COL_CHAR_72
           ,COL_DATE_01
           ,COL_DATE_02
           ,COL_DATE_03
           ,COL_DATE_04
           ,COL_DATE_11
           ,COL_DATE_12
           ,CONTEXT
           ,ATTRIBUTE1
           ,ATTRIBUTE2
           ,ATTRIBUTE3
           ,ATTRIBUTE4
           ,ATTRIBUTE5
           ,ATTRIBUTE6
           ,ATTRIBUTE7
           ,ATTRIBUTE8
           ,ATTRIBUTE9
           ,ATTRIBUTE10
           ,ATTRIBUTE11
           ,ATTRIBUTE12
           ,ATTRIBUTE13
           ,ATTRIBUTE14
           ,ATTRIBUTE15
           ,CREATED_BY
           ,CREATION_DATE
           ,LAST_UPDATED_BY
           ,LAST_UPDATE_DATE
           ,LAST_UPDATE_LOGIN
           ,OBJECT_VERSION_NUMBER
           ,SECURITY_GROUP_ID
           )
           Values
           (
           l_archive_id_tbl(i),
           l_table_id,
           l_pty_hist_rec_tab.instance_party_history_id(i),
           l_pty_hist_rec_tab.transaction_id(i),
           l_pty_hist_rec_tab.instance_party_id(i),
           l_pty_hist_rec_tab.old_party_id(i),
           l_pty_hist_rec_tab.new_party_id(i),
           l_pty_hist_rec_tab.old_contact_ip_id(i),
           l_pty_hist_rec_tab.new_contact_ip_id(i),
           l_pty_hist_rec_tab.pty_created_by(i),
           l_pty_hist_rec_tab.pty_last_updated_by(i),
           l_pty_hist_rec_tab.pty_last_update_login(i),
           l_pty_hist_rec_tab.pty_object_version_number(i),
           l_pty_hist_rec_tab.pty_security_group_id(i),
           l_pty_hist_rec_tab.old_party_source_table(i),
           l_pty_hist_rec_tab.new_party_source_table(i),
           l_pty_hist_rec_tab.old_relationship_type_code(i),
           l_pty_hist_rec_tab.new_relationship_type_code(i),
           l_pty_hist_rec_tab.old_contact_flag(i),
           l_pty_hist_rec_tab.new_contact_flag(i),
           l_pty_hist_rec_tab.old_preferred_flag(i),
           l_pty_hist_rec_tab.new_preferred_flag(i),
           l_pty_hist_rec_tab.old_primary_flag(i),
           l_pty_hist_rec_tab.new_primary_flag(i),
           l_pty_hist_rec_tab.old_context(i),
           l_pty_hist_rec_tab.new_context(i),
           l_pty_hist_rec_tab.old_attribute1(i),
           l_pty_hist_rec_tab.new_attribute1(i),
           l_pty_hist_rec_tab.old_attribute2(i),
           l_pty_hist_rec_tab.new_attribute2(i),
           l_pty_hist_rec_tab.old_attribute3(i),
           l_pty_hist_rec_tab.new_attribute3(i),
           l_pty_hist_rec_tab.old_attribute4(i),
           l_pty_hist_rec_tab.new_attribute4(i),
           l_pty_hist_rec_tab.old_attribute5(i),
           l_pty_hist_rec_tab.new_attribute5(i),
           l_pty_hist_rec_tab.old_attribute6(i),
           l_pty_hist_rec_tab.new_attribute6(i),
           l_pty_hist_rec_tab.old_attribute7(i),
           l_pty_hist_rec_tab.new_attribute7(i),
           l_pty_hist_rec_tab.old_attribute8(i),
           l_pty_hist_rec_tab.new_attribute8(i),
           l_pty_hist_rec_tab.old_attribute9(i),
           l_pty_hist_rec_tab.new_attribute9(i),
           l_pty_hist_rec_tab.old_attribute10(i),
           l_pty_hist_rec_tab.new_attribute10(i),
           l_pty_hist_rec_tab.old_attribute11(i),
           l_pty_hist_rec_tab.new_attribute11(i),
           l_pty_hist_rec_tab.old_attribute12(i),
           l_pty_hist_rec_tab.new_attribute12(i),
           l_pty_hist_rec_tab.old_attribute13(i),
           l_pty_hist_rec_tab.new_attribute13(i),
           l_pty_hist_rec_tab.old_attribute14(i),
           l_pty_hist_rec_tab.new_attribute14(i),
           l_pty_hist_rec_tab.old_attribute15(i),
           l_pty_hist_rec_tab.new_attribute15(i),
           l_pty_hist_rec_tab.pty_full_dump_flag(i),
           l_pty_hist_rec_tab.pty_migrated_flag(i),
           l_pty_hist_rec_tab.old_active_start_date(i),
           l_pty_hist_rec_tab.new_active_start_date(i),
           l_pty_hist_rec_tab.old_active_end_date(i),
           l_pty_hist_rec_tab.new_active_end_date(i),
           l_pty_hist_rec_tab.pty_creation_date(i),
           l_pty_hist_rec_tab.pty_last_update_date(i),
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           l_user_id,
           sysdate,
           l_user_id,
           sysdate,
           l_login_id,
           1,
           null
           );
Line: 1791

          Delete From CSI_I_PARTIES_H
          Where instance_party_history_id = l_pty_hist_rec_tab.instance_party_history_id(i);
Line: 1851

    Select csh.*
    From   CSI_IP_ACCOUNTS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between from_trans and to_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 1866

      Select object_id
      Into   l_table_id
      From   csi_object_dictionary
      Where  object_name = 'CSI_IP_ACCOUNTS_H';
Line: 1879

      Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
      Into   v_batch
      From   dual;
Line: 1899

      l_acct_hist_rec_tab.ip_account_history_id.DELETE;
Line: 1900

      l_acct_hist_rec_tab.ip_account_id.DELETE;
Line: 1901

      l_acct_hist_rec_tab.transaction_id.DELETE;
Line: 1902

      l_acct_hist_rec_tab.old_party_account_id.DELETE;
Line: 1903

      l_acct_hist_rec_tab.new_party_account_id.DELETE;
Line: 1904

      l_acct_hist_rec_tab.old_relationship_type_code.DELETE;
Line: 1905

      l_acct_hist_rec_tab.new_relationship_type_code.DELETE;
Line: 1906

      l_acct_hist_rec_tab.old_bill_to_address.DELETE;
Line: 1907

      l_acct_hist_rec_tab.new_bill_to_address.DELETE;
Line: 1908

      l_acct_hist_rec_tab.old_ship_to_address.DELETE;
Line: 1909

      l_acct_hist_rec_tab.new_ship_to_address.DELETE;
Line: 1910

      l_acct_hist_rec_tab.old_active_start_date.DELETE;
Line: 1911

      l_acct_hist_rec_tab.new_active_start_date.DELETE;
Line: 1912

      l_acct_hist_rec_tab.old_active_end_date.DELETE;
Line: 1913

      l_acct_hist_rec_tab.new_active_end_date.DELETE;
Line: 1914

      l_acct_hist_rec_tab.old_context.DELETE;
Line: 1915

      l_acct_hist_rec_tab.new_context.DELETE;
Line: 1916

      l_acct_hist_rec_tab.old_attribute1.DELETE;
Line: 1917

      l_acct_hist_rec_tab.new_attribute1.DELETE;
Line: 1918

      l_acct_hist_rec_tab.old_attribute2.DELETE;
Line: 1919

      l_acct_hist_rec_tab.new_attribute2.DELETE;
Line: 1920

      l_acct_hist_rec_tab.old_attribute3.DELETE;
Line: 1921

      l_acct_hist_rec_tab.new_attribute3.DELETE;
Line: 1922

      l_acct_hist_rec_tab.old_attribute4.DELETE;
Line: 1923

      l_acct_hist_rec_tab.new_attribute4.DELETE;
Line: 1924

      l_acct_hist_rec_tab.old_attribute5.DELETE;
Line: 1925

      l_acct_hist_rec_tab.new_attribute5.DELETE;
Line: 1926

      l_acct_hist_rec_tab.old_attribute6.DELETE;
Line: 1927

      l_acct_hist_rec_tab.new_attribute6.DELETE;
Line: 1928

      l_acct_hist_rec_tab.old_attribute7.DELETE;
Line: 1929

      l_acct_hist_rec_tab.new_attribute7.DELETE;
Line: 1930

      l_acct_hist_rec_tab.old_attribute8.DELETE;
Line: 1931

      l_acct_hist_rec_tab.new_attribute8.DELETE;
Line: 1932

      l_acct_hist_rec_tab.old_attribute9.DELETE;
Line: 1933

      l_acct_hist_rec_tab.new_attribute9.DELETE;
Line: 1934

      l_acct_hist_rec_tab.old_attribute10.DELETE;
Line: 1935

      l_acct_hist_rec_tab.new_attribute10.DELETE;
Line: 1936

      l_acct_hist_rec_tab.old_attribute11.DELETE;
Line: 1937

      l_acct_hist_rec_tab.new_attribute11.DELETE;
Line: 1938

      l_acct_hist_rec_tab.old_attribute12.DELETE;
Line: 1939

      l_acct_hist_rec_tab.new_attribute12.DELETE;
Line: 1940

      l_acct_hist_rec_tab.old_attribute13.DELETE;
Line: 1941

      l_acct_hist_rec_tab.new_attribute13.DELETE;
Line: 1942

      l_acct_hist_rec_tab.old_attribute14.DELETE;
Line: 1943

      l_acct_hist_rec_tab.new_attribute14.DELETE;
Line: 1944

      l_acct_hist_rec_tab.old_attribute15.DELETE;
Line: 1945

      l_acct_hist_rec_tab.new_attribute15.DELETE;
Line: 1946

      l_acct_hist_rec_tab.acct_full_dump_flag.DELETE;
Line: 1947

      l_acct_hist_rec_tab.acct_created_by.DELETE;
Line: 1948

      l_acct_hist_rec_tab.acct_creation_date.DELETE;
Line: 1949

      l_acct_hist_rec_tab.acct_last_updated_by.DELETE;
Line: 1950

      l_acct_hist_rec_tab.acct_last_update_date.DELETE;
Line: 1951

      l_acct_hist_rec_tab.acct_last_update_login.DELETE;
Line: 1952

      l_acct_hist_rec_tab.acct_object_version_number.DELETE;
Line: 1953

      l_acct_hist_rec_tab.acct_security_group_id.DELETE;
Line: 1954

      l_acct_hist_rec_tab.acct_migrated_flag.DELETE;
Line: 1955

      l_acct_hist_rec_tab.old_instance_party_id.DELETE;
Line: 1956

      l_acct_hist_rec_tab.new_instance_party_id.DELETE;
Line: 1964

      Select csi_history_archive_s.Nextval
      Into l_archive_id_tbl(l_ctr)
      From dual;
Line: 2018

      l_acct_hist_rec_tab.acct_last_updated_by(l_ctr)       :=  i.last_updated_by;
Line: 2019

      l_acct_hist_rec_tab.acct_last_update_date(l_ctr)      :=  i.last_update_date;
Line: 2020

      l_acct_hist_rec_tab.acct_last_update_login(l_ctr)     :=  i.last_update_login;
Line: 2042

         Insert Into CSI_HISTORY_ARCHIVE
         (
            HISTORY_ARCHIVE_ID
           ,OBJECT_ID
           ,ENTITY_HISTORY_ID
           ,TRANSACTION_ID
           ,ENTITY_ID
           ,COL_NUM_01
           ,COL_NUM_02
           ,COL_NUM_03
           ,COL_NUM_04
           ,COL_NUM_05
           ,COL_NUM_06
           ,COL_NUM_07
           ,COL_NUM_08
           ,COL_NUM_37
           ,COL_NUM_38
           ,COL_NUM_39
           ,COL_NUM_40
           ,COL_NUM_41
           ,COL_CHAR_01
           ,COL_CHAR_02
           ,COL_CHAR_31
           ,COL_CHAR_32
           ,COL_CHAR_33
           ,COL_CHAR_34
           ,COL_CHAR_35
           ,COL_CHAR_36
           ,COL_CHAR_37
           ,COL_CHAR_38
           ,COL_CHAR_39
           ,COL_CHAR_40
           ,COL_CHAR_41
           ,COL_CHAR_42
           ,COL_CHAR_43
           ,COL_CHAR_44
           ,COL_CHAR_45
           ,COL_CHAR_46
           ,COL_CHAR_47
           ,COL_CHAR_48
           ,COL_CHAR_49
           ,COL_CHAR_50
           ,COL_CHAR_51
           ,COL_CHAR_52
           ,COL_CHAR_53
           ,COL_CHAR_54
           ,COL_CHAR_55
           ,COL_CHAR_56
           ,COL_CHAR_57
           ,COL_CHAR_58
           ,COL_CHAR_59
           ,COL_CHAR_60
           ,COL_CHAR_61
           ,COL_CHAR_62
           ,COL_CHAR_71
           ,COL_CHAR_72
           ,COL_DATE_01
           ,COL_DATE_02
           ,COL_DATE_03
           ,COL_DATE_04
           ,COL_DATE_11
           ,COL_DATE_12
           ,CONTEXT
           ,ATTRIBUTE1
           ,ATTRIBUTE2
           ,ATTRIBUTE3
           ,ATTRIBUTE4
           ,ATTRIBUTE5
           ,ATTRIBUTE6
           ,ATTRIBUTE7
           ,ATTRIBUTE8
           ,ATTRIBUTE9
           ,ATTRIBUTE10
           ,ATTRIBUTE11
           ,ATTRIBUTE12
           ,ATTRIBUTE13
           ,ATTRIBUTE14
           ,ATTRIBUTE15
           ,CREATED_BY
           ,CREATION_DATE
           ,LAST_UPDATED_BY
           ,LAST_UPDATE_DATE
           ,LAST_UPDATE_LOGIN
           ,OBJECT_VERSION_NUMBER
           ,SECURITY_GROUP_ID
           )
           Values
           (
           l_archive_id_tbl(i),
           l_table_id,
           l_acct_hist_rec_tab.ip_account_history_id(i),
           l_acct_hist_rec_tab.transaction_id(i),
           l_acct_hist_rec_tab.ip_account_id(i),
           l_acct_hist_rec_tab.old_party_account_id(i),
           l_acct_hist_rec_tab.new_party_account_id(i),
           l_acct_hist_rec_tab.old_bill_to_address(i),
           l_acct_hist_rec_tab.new_bill_to_address(i),
           l_acct_hist_rec_tab.old_ship_to_address(i),
           l_acct_hist_rec_tab.new_ship_to_address(i),
           l_acct_hist_rec_tab.old_instance_party_id(i),
           l_acct_hist_rec_tab.new_instance_party_id(i),
           l_acct_hist_rec_tab.acct_created_by(i),
           l_acct_hist_rec_tab.acct_last_updated_by(i),
           l_acct_hist_rec_tab.acct_last_update_login(i),
		   l_acct_hist_rec_tab.acct_object_version_number(i), -- obj_ver_num
           l_acct_hist_rec_tab.acct_security_group_id(i), -- sec_grp_id
           l_acct_hist_rec_tab.old_relationship_type_code(i),
           l_acct_hist_rec_tab.new_relationship_type_code(i),
           l_acct_hist_rec_tab.old_context(i),
           l_acct_hist_rec_tab.new_context(i),
           l_acct_hist_rec_tab.old_attribute1(i),
           l_acct_hist_rec_tab.new_attribute1(i),
           l_acct_hist_rec_tab.old_attribute2(i),
           l_acct_hist_rec_tab.new_attribute2(i),
           l_acct_hist_rec_tab.old_attribute3(i),
           l_acct_hist_rec_tab.new_attribute3(i),
           l_acct_hist_rec_tab.old_attribute4(i),
           l_acct_hist_rec_tab.new_attribute4(i),
           l_acct_hist_rec_tab.old_attribute5(i),
           l_acct_hist_rec_tab.new_attribute5(i),
           l_acct_hist_rec_tab.old_attribute6(i),
           l_acct_hist_rec_tab.new_attribute6(i),
           l_acct_hist_rec_tab.old_attribute7(i),
           l_acct_hist_rec_tab.new_attribute7(i),
           l_acct_hist_rec_tab.old_attribute8(i),
           l_acct_hist_rec_tab.new_attribute8(i),
           l_acct_hist_rec_tab.old_attribute9(i),
           l_acct_hist_rec_tab.new_attribute9(i),
           l_acct_hist_rec_tab.old_attribute10(i),
           l_acct_hist_rec_tab.new_attribute10(i),
           l_acct_hist_rec_tab.old_attribute11(i),
           l_acct_hist_rec_tab.new_attribute11(i),
           l_acct_hist_rec_tab.old_attribute12(i),
           l_acct_hist_rec_tab.new_attribute12(i),
           l_acct_hist_rec_tab.old_attribute13(i),
           l_acct_hist_rec_tab.new_attribute13(i),
           l_acct_hist_rec_tab.old_attribute14(i),
           l_acct_hist_rec_tab.new_attribute14(i),
           l_acct_hist_rec_tab.old_attribute15(i),
           l_acct_hist_rec_tab.new_attribute15(i),
           l_acct_hist_rec_tab.acct_full_dump_flag(i), --'N', dump_flag
           l_acct_hist_rec_tab.acct_migrated_flag(i), -- mig_flag
           l_acct_hist_rec_tab.old_active_start_date(i),
           l_acct_hist_rec_tab.new_active_start_date(i),
           l_acct_hist_rec_tab.old_active_end_date(i),
           l_acct_hist_rec_tab.new_active_end_date(i),
           l_acct_hist_rec_tab.acct_creation_date(i),
           l_acct_hist_rec_tab.acct_last_update_date(i),
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           l_user_id,
           sysdate,
           l_user_id,
           sysdate,
           l_login_id,
           1,
           null
           );
Line: 2219

               Delete From CSI_IP_ACCOUNTS_H
               Where ip_account_history_id = l_acct_hist_rec_tab.ip_account_history_id(i);
Line: 2278

    Select csh.*
    From   CSI_I_ORG_ASSIGNMENTS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between from_trans and to_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 2293

      Select object_id
      Into   l_table_id
      From   csi_object_dictionary
      Where  object_name = 'CSI_I_ORG_ASSIGNMENTS_H';
Line: 2305

      Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
      Into   v_batch
      From   dual;
Line: 2325

      l_org_units_hist_rec_tab.instance_ou_history_id.DELETE;
Line: 2326

      l_org_units_hist_rec_tab.instance_ou_id.DELETE;
Line: 2327

      l_org_units_hist_rec_tab.transaction_id.DELETE;
Line: 2328

      l_org_units_hist_rec_tab.old_operating_unit_id.DELETE;
Line: 2329

      l_org_units_hist_rec_tab.new_operating_unit_id.DELETE;
Line: 2330

      l_org_units_hist_rec_tab.old_ou_relnship_type_code.DELETE;
Line: 2331

      l_org_units_hist_rec_tab.new_ou_relnship_type_code.DELETE;
Line: 2332

      l_org_units_hist_rec_tab.old_ou_active_start_date.DELETE;
Line: 2333

      l_org_units_hist_rec_tab.new_ou_active_start_date.DELETE;
Line: 2334

      l_org_units_hist_rec_tab.old_ou_active_end_date.DELETE;
Line: 2335

      l_org_units_hist_rec_tab.new_ou_active_end_date.DELETE;
Line: 2336

      l_org_units_hist_rec_tab.old_ou_context.DELETE;
Line: 2337

      l_org_units_hist_rec_tab.new_ou_context.DELETE;
Line: 2338

      l_org_units_hist_rec_tab.old_ou_attribute1.DELETE;
Line: 2339

      l_org_units_hist_rec_tab.new_ou_attribute1.DELETE;
Line: 2340

      l_org_units_hist_rec_tab.old_ou_attribute2.DELETE;
Line: 2341

      l_org_units_hist_rec_tab.new_ou_attribute2.DELETE;
Line: 2342

      l_org_units_hist_rec_tab.old_ou_attribute3.DELETE;
Line: 2343

      l_org_units_hist_rec_tab.new_ou_attribute3.DELETE;
Line: 2344

      l_org_units_hist_rec_tab.old_ou_attribute4.DELETE;
Line: 2345

      l_org_units_hist_rec_tab.new_ou_attribute4.DELETE;
Line: 2346

      l_org_units_hist_rec_tab.old_ou_attribute5.DELETE;
Line: 2347

      l_org_units_hist_rec_tab.new_ou_attribute5.DELETE;
Line: 2348

      l_org_units_hist_rec_tab.old_ou_attribute6.DELETE;
Line: 2349

      l_org_units_hist_rec_tab.new_ou_attribute6.DELETE;
Line: 2350

      l_org_units_hist_rec_tab.old_ou_attribute7.DELETE;
Line: 2351

      l_org_units_hist_rec_tab.new_ou_attribute7.DELETE;
Line: 2352

      l_org_units_hist_rec_tab.old_ou_attribute8.DELETE;
Line: 2353

      l_org_units_hist_rec_tab.new_ou_attribute8.DELETE;
Line: 2354

      l_org_units_hist_rec_tab.old_ou_attribute9.DELETE;
Line: 2355

      l_org_units_hist_rec_tab.new_ou_attribute9.DELETE;
Line: 2356

      l_org_units_hist_rec_tab.old_ou_attribute10.DELETE;
Line: 2357

      l_org_units_hist_rec_tab.new_ou_attribute10.DELETE;
Line: 2358

      l_org_units_hist_rec_tab.old_ou_attribute11.DELETE;
Line: 2359

      l_org_units_hist_rec_tab.new_ou_attribute11.DELETE;
Line: 2360

      l_org_units_hist_rec_tab.old_ou_attribute12.DELETE;
Line: 2361

      l_org_units_hist_rec_tab.new_ou_attribute12.DELETE;
Line: 2362

      l_org_units_hist_rec_tab.old_ou_attribute13.DELETE;
Line: 2363

      l_org_units_hist_rec_tab.new_ou_attribute13.DELETE;
Line: 2364

      l_org_units_hist_rec_tab.old_ou_attribute14.DELETE;
Line: 2365

      l_org_units_hist_rec_tab.new_ou_attribute14.DELETE;
Line: 2366

      l_org_units_hist_rec_tab.old_ou_attribute15.DELETE;
Line: 2367

      l_org_units_hist_rec_tab.new_ou_attribute15.DELETE;
Line: 2368

      l_org_units_hist_rec_tab.ou_full_dump_flag.DELETE;
Line: 2369

      l_org_units_hist_rec_tab.ou_created_by.DELETE;
Line: 2370

      l_org_units_hist_rec_tab.ou_creation_date.DELETE;
Line: 2371

      l_org_units_hist_rec_tab.ou_last_updated_by.DELETE;
Line: 2372

      l_org_units_hist_rec_tab.ou_last_update_date.DELETE;
Line: 2373

      l_org_units_hist_rec_tab.ou_last_update_login.DELETE;
Line: 2374

      l_org_units_hist_rec_tab.ou_object_version_number.DELETE;
Line: 2375

      l_org_units_hist_rec_tab.ou_security_group_id.DELETE;
Line: 2376

      l_org_units_hist_rec_tab.ou_migrated_flag.DELETE;
Line: 2384

      Select csi_history_archive_s.Nextval
      Into l_archive_id_tbl(l_ctr)
      From dual;
Line: 2434

      l_org_units_hist_rec_tab.ou_last_updated_by(l_ctr)            :=  i.last_updated_by;
Line: 2435

      l_org_units_hist_rec_tab.ou_last_update_date(l_ctr)           :=  i.last_update_date;
Line: 2436

      l_org_units_hist_rec_tab.ou_last_update_login(l_ctr)          :=  i.last_update_login;
Line: 2456

         Insert Into CSI_HISTORY_ARCHIVE
         (
            HISTORY_ARCHIVE_ID
           ,OBJECT_ID
           ,ENTITY_HISTORY_ID
           ,TRANSACTION_ID
           ,ENTITY_ID
           ,COL_NUM_01
           ,COL_NUM_02
           ,COL_NUM_37
           ,COL_NUM_38
           ,COL_NUM_39
           ,COL_NUM_40
           ,COL_NUM_41
           ,COL_CHAR_01
           ,COL_CHAR_02
           ,COL_CHAR_31
           ,COL_CHAR_32
           ,COL_CHAR_33
           ,COL_CHAR_34
           ,COL_CHAR_35
           ,COL_CHAR_36
           ,COL_CHAR_37
           ,COL_CHAR_38
           ,COL_CHAR_39
           ,COL_CHAR_40
           ,COL_CHAR_41
           ,COL_CHAR_42
           ,COL_CHAR_43
           ,COL_CHAR_44
           ,COL_CHAR_45
           ,COL_CHAR_46
           ,COL_CHAR_47
           ,COL_CHAR_48
           ,COL_CHAR_49
           ,COL_CHAR_50
           ,COL_CHAR_51
           ,COL_CHAR_52
           ,COL_CHAR_53
           ,COL_CHAR_54
           ,COL_CHAR_55
           ,COL_CHAR_56
           ,COL_CHAR_57
           ,COL_CHAR_58
           ,COL_CHAR_59
           ,COL_CHAR_60
           ,COL_CHAR_61
           ,COL_CHAR_62
           ,COL_CHAR_71
           ,COL_CHAR_72
           ,COL_DATE_01
           ,COL_DATE_02
           ,COL_DATE_03
           ,COL_DATE_04
           ,COL_DATE_11
           ,COL_DATE_12
           ,CONTEXT
           ,ATTRIBUTE1
           ,ATTRIBUTE2
           ,ATTRIBUTE3
           ,ATTRIBUTE4
           ,ATTRIBUTE5
           ,ATTRIBUTE6
           ,ATTRIBUTE7
           ,ATTRIBUTE8
           ,ATTRIBUTE9
           ,ATTRIBUTE10
           ,ATTRIBUTE11
           ,ATTRIBUTE12
           ,ATTRIBUTE13
           ,ATTRIBUTE14
           ,ATTRIBUTE15
           ,CREATED_BY
           ,CREATION_DATE
           ,LAST_UPDATED_BY
           ,LAST_UPDATE_DATE
           ,LAST_UPDATE_LOGIN
           ,OBJECT_VERSION_NUMBER
           ,SECURITY_GROUP_ID
           )
           Values
           (
           l_archive_id_tbl(i),
           l_table_id,
           l_org_units_hist_rec_tab.instance_ou_history_id(i),
           l_org_units_hist_rec_tab.transaction_id(i),
           l_org_units_hist_rec_tab.instance_ou_id(i),
           l_org_units_hist_rec_tab.old_operating_unit_id(i),
           l_org_units_hist_rec_tab.new_operating_unit_id(i),
           l_org_units_hist_rec_tab.ou_created_by(i),
           l_org_units_hist_rec_tab.ou_last_updated_by(i),
           l_org_units_hist_rec_tab.ou_last_update_login(i),
		   l_org_units_hist_rec_tab.ou_object_version_number(i), -- obj_ver_num
           l_org_units_hist_rec_tab.ou_security_group_id(i), -- sec_grp_id
           l_org_units_hist_rec_tab.old_ou_relnship_type_code(i),
           l_org_units_hist_rec_tab.new_ou_relnship_type_code(i),
           l_org_units_hist_rec_tab.old_ou_context(i),
           l_org_units_hist_rec_tab.new_ou_context(i),
           l_org_units_hist_rec_tab.old_ou_attribute1(i),
           l_org_units_hist_rec_tab.new_ou_attribute1(i),
           l_org_units_hist_rec_tab.old_ou_attribute2(i),
           l_org_units_hist_rec_tab.new_ou_attribute2(i),
           l_org_units_hist_rec_tab.old_ou_attribute3(i),
           l_org_units_hist_rec_tab.new_ou_attribute3(i),
           l_org_units_hist_rec_tab.old_ou_attribute4(i),
           l_org_units_hist_rec_tab.new_ou_attribute4(i),
           l_org_units_hist_rec_tab.old_ou_attribute5(i),
           l_org_units_hist_rec_tab.new_ou_attribute5(i),
           l_org_units_hist_rec_tab.old_ou_attribute6(i),
           l_org_units_hist_rec_tab.new_ou_attribute6(i),
           l_org_units_hist_rec_tab.old_ou_attribute7(i),
           l_org_units_hist_rec_tab.new_ou_attribute7(i),
           l_org_units_hist_rec_tab.old_ou_attribute8(i),
           l_org_units_hist_rec_tab.new_ou_attribute8(i),
           l_org_units_hist_rec_tab.old_ou_attribute9(i),
           l_org_units_hist_rec_tab.new_ou_attribute9(i),
           l_org_units_hist_rec_tab.old_ou_attribute10(i),
           l_org_units_hist_rec_tab.new_ou_attribute10(i),
           l_org_units_hist_rec_tab.old_ou_attribute11(i),
           l_org_units_hist_rec_tab.new_ou_attribute11(i),
           l_org_units_hist_rec_tab.old_ou_attribute12(i),
           l_org_units_hist_rec_tab.new_ou_attribute12(i),
           l_org_units_hist_rec_tab.old_ou_attribute13(i),
           l_org_units_hist_rec_tab.new_ou_attribute13(i),
           l_org_units_hist_rec_tab.old_ou_attribute14(i),
           l_org_units_hist_rec_tab.new_ou_attribute14(i),
           l_org_units_hist_rec_tab.old_ou_attribute15(i),
           l_org_units_hist_rec_tab.new_ou_attribute15(i),
           l_org_units_hist_rec_tab.ou_full_dump_flag(i), --'N', dump_flag
           l_org_units_hist_rec_tab.ou_migrated_flag(i), -- mig_flag
           l_org_units_hist_rec_tab.old_ou_active_start_date(i),
           l_org_units_hist_rec_tab.new_ou_active_start_date(i),
           l_org_units_hist_rec_tab.old_ou_active_end_date(i),
           l_org_units_hist_rec_tab.new_ou_active_end_date(i),
           l_org_units_hist_rec_tab.ou_creation_date(i),
           l_org_units_hist_rec_tab.ou_last_update_date(i),
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           l_user_id,
           sysdate,
           l_user_id,
           sysdate,
           l_login_id,
           1,
           null
           );
Line: 2621

               Delete From CSI_I_ORG_ASSIGNMENTS_H
               Where instance_ou_history_id = l_org_units_hist_rec_tab.instance_ou_history_id(i);
Line: 2681

    Select csh.*
    From   CSI_IEA_VALUES_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between from_trans and to_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 2696

      Select object_id
      Into   l_table_id
      From   csi_object_dictionary
      Where  object_name = 'CSI_IEA_VALUES_H';
Line: 2708

      Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
      Into   v_batch
      From   dual;
Line: 2728

      l_ext_attrib_hist_rec_tab.attribute_value_history_id.DELETE;
Line: 2729

      l_ext_attrib_hist_rec_tab.attribute_value_id.DELETE;
Line: 2730

      l_ext_attrib_hist_rec_tab.transaction_id.DELETE;
Line: 2731

      l_ext_attrib_hist_rec_tab.old_attribute_value.DELETE;
Line: 2732

      l_ext_attrib_hist_rec_tab.new_attribute_value.DELETE;
Line: 2733

      l_ext_attrib_hist_rec_tab.old_ext_active_start_date.DELETE;
Line: 2734

      l_ext_attrib_hist_rec_tab.new_ext_active_start_date.DELETE;
Line: 2735

      l_ext_attrib_hist_rec_tab.old_ext_active_end_date.DELETE;
Line: 2736

      l_ext_attrib_hist_rec_tab.new_ext_active_end_date.DELETE;
Line: 2737

      l_ext_attrib_hist_rec_tab.old_ext_context.DELETE;
Line: 2738

      l_ext_attrib_hist_rec_tab.new_ext_context.DELETE;
Line: 2739

      l_ext_attrib_hist_rec_tab.old_ext_attribute1.DELETE;
Line: 2740

      l_ext_attrib_hist_rec_tab.new_ext_attribute1.DELETE;
Line: 2741

      l_ext_attrib_hist_rec_tab.old_ext_attribute2.DELETE;
Line: 2742

      l_ext_attrib_hist_rec_tab.new_ext_attribute2.DELETE;
Line: 2743

      l_ext_attrib_hist_rec_tab.old_ext_attribute3.DELETE;
Line: 2744

      l_ext_attrib_hist_rec_tab.new_ext_attribute3.DELETE;
Line: 2745

      l_ext_attrib_hist_rec_tab.old_ext_attribute4.DELETE;
Line: 2746

      l_ext_attrib_hist_rec_tab.new_ext_attribute4.DELETE;
Line: 2747

      l_ext_attrib_hist_rec_tab.old_ext_attribute5.DELETE;
Line: 2748

      l_ext_attrib_hist_rec_tab.new_ext_attribute5.DELETE;
Line: 2749

      l_ext_attrib_hist_rec_tab.old_ext_attribute6.DELETE;
Line: 2750

      l_ext_attrib_hist_rec_tab.new_ext_attribute6.DELETE;
Line: 2751

      l_ext_attrib_hist_rec_tab.old_ext_attribute7.DELETE;
Line: 2752

      l_ext_attrib_hist_rec_tab.new_ext_attribute7.DELETE;
Line: 2753

      l_ext_attrib_hist_rec_tab.old_ext_attribute8.DELETE;
Line: 2754

      l_ext_attrib_hist_rec_tab.new_ext_attribute8.DELETE;
Line: 2755

      l_ext_attrib_hist_rec_tab.old_ext_attribute9.DELETE;
Line: 2756

      l_ext_attrib_hist_rec_tab.new_ext_attribute9.DELETE;
Line: 2757

      l_ext_attrib_hist_rec_tab.old_ext_attribute10.DELETE;
Line: 2758

      l_ext_attrib_hist_rec_tab.new_ext_attribute10.DELETE;
Line: 2759

      l_ext_attrib_hist_rec_tab.old_ext_attribute11.DELETE;
Line: 2760

      l_ext_attrib_hist_rec_tab.new_ext_attribute11.DELETE;
Line: 2761

      l_ext_attrib_hist_rec_tab.old_ext_attribute12.DELETE;
Line: 2762

      l_ext_attrib_hist_rec_tab.new_ext_attribute12.DELETE;
Line: 2763

      l_ext_attrib_hist_rec_tab.old_ext_attribute13.DELETE;
Line: 2764

      l_ext_attrib_hist_rec_tab.new_ext_attribute13.DELETE;
Line: 2765

      l_ext_attrib_hist_rec_tab.old_ext_attribute14.DELETE;
Line: 2766

      l_ext_attrib_hist_rec_tab.new_ext_attribute14.DELETE;
Line: 2767

      l_ext_attrib_hist_rec_tab.old_ext_attribute15.DELETE;
Line: 2768

      l_ext_attrib_hist_rec_tab.new_ext_attribute15.DELETE;
Line: 2769

      l_ext_attrib_hist_rec_tab.ext_full_dump_flag.DELETE;
Line: 2770

      l_ext_attrib_hist_rec_tab.ext_created_by.DELETE;
Line: 2771

      l_ext_attrib_hist_rec_tab.ext_creation_date.DELETE;
Line: 2772

      l_ext_attrib_hist_rec_tab.ext_last_updated_by.DELETE;
Line: 2773

      l_ext_attrib_hist_rec_tab.ext_last_update_date.DELETE;
Line: 2774

      l_ext_attrib_hist_rec_tab.ext_last_update_login.DELETE;
Line: 2775

      l_ext_attrib_hist_rec_tab.ext_object_version_number.DELETE;
Line: 2776

      l_ext_attrib_hist_rec_tab.ext_security_group_id.DELETE;
Line: 2777

      l_ext_attrib_hist_rec_tab.ext_migrated_flag.DELETE;
Line: 2785

      Select csi_history_archive_s.Nextval
      Into l_archive_id_tbl(l_ctr)
      From dual;
Line: 2833

      l_ext_attrib_hist_rec_tab.ext_last_updated_by(l_ctr)          :=  i.last_updated_by;
Line: 2834

      l_ext_attrib_hist_rec_tab.ext_last_update_date(l_ctr)         :=  i.last_update_date;
Line: 2835

      l_ext_attrib_hist_rec_tab.ext_last_update_login(l_ctr)        :=  i.last_update_login;
Line: 2856

         Insert Into CSI_HISTORY_ARCHIVE
         (
            HISTORY_ARCHIVE_ID
           ,OBJECT_ID
           ,ENTITY_HISTORY_ID
           ,TRANSACTION_ID
           ,ENTITY_ID
           ,COL_NUM_37
           ,COL_NUM_38
           ,COL_NUM_39
           ,COL_NUM_40
           ,COL_NUM_41
           ,COL_CHAR_01
           ,COL_CHAR_02
           ,COL_CHAR_31
           ,COL_CHAR_32
           ,COL_CHAR_33
           ,COL_CHAR_34
           ,COL_CHAR_35
           ,COL_CHAR_36
           ,COL_CHAR_37
           ,COL_CHAR_38
           ,COL_CHAR_39
           ,COL_CHAR_40
           ,COL_CHAR_41
           ,COL_CHAR_42
           ,COL_CHAR_43
           ,COL_CHAR_44
           ,COL_CHAR_45
           ,COL_CHAR_46
           ,COL_CHAR_47
           ,COL_CHAR_48
           ,COL_CHAR_49
           ,COL_CHAR_50
           ,COL_CHAR_51
           ,COL_CHAR_52
           ,COL_CHAR_53
           ,COL_CHAR_54
           ,COL_CHAR_55
           ,COL_CHAR_56
           ,COL_CHAR_57
           ,COL_CHAR_58
           ,COL_CHAR_59
           ,COL_CHAR_60
           ,COL_CHAR_61
           ,COL_CHAR_62
           ,COL_CHAR_71
           ,COL_CHAR_72
           ,COL_DATE_01
           ,COL_DATE_02
           ,COL_DATE_03
           ,COL_DATE_04
           ,COL_DATE_11
           ,COL_DATE_12
           ,CONTEXT
           ,ATTRIBUTE1
           ,ATTRIBUTE2
           ,ATTRIBUTE3
           ,ATTRIBUTE4
           ,ATTRIBUTE5
           ,ATTRIBUTE6
           ,ATTRIBUTE7
           ,ATTRIBUTE8
           ,ATTRIBUTE9
           ,ATTRIBUTE10
           ,ATTRIBUTE11
           ,ATTRIBUTE12
           ,ATTRIBUTE13
           ,ATTRIBUTE14
           ,ATTRIBUTE15
           ,CREATED_BY
           ,CREATION_DATE
           ,LAST_UPDATED_BY
           ,LAST_UPDATE_DATE
           ,LAST_UPDATE_LOGIN
           ,OBJECT_VERSION_NUMBER
           ,SECURITY_GROUP_ID
           )
           Values
           (
           l_archive_id_tbl(i),
           l_table_id,
           l_ext_attrib_hist_rec_tab.attribute_value_history_id(i),
           l_ext_attrib_hist_rec_tab.transaction_id(i),
           l_ext_attrib_hist_rec_tab.attribute_value_id(i),
           l_ext_attrib_hist_rec_tab.ext_created_by(i),
           l_ext_attrib_hist_rec_tab.ext_last_updated_by(i),
           l_ext_attrib_hist_rec_tab.ext_last_update_login(i),
           l_ext_attrib_hist_rec_tab.ext_object_version_number(i), -- obj_ver_num
           l_ext_attrib_hist_rec_tab.ext_security_group_id(i),
           l_ext_attrib_hist_rec_tab.old_attribute_value(i),
           l_ext_attrib_hist_rec_tab.new_attribute_value(i),
           l_ext_attrib_hist_rec_tab.old_ext_context(i),
           l_ext_attrib_hist_rec_tab.new_ext_context(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute1(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute1(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute2(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute2(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute3(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute3(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute4(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute4(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute5(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute5(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute6(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute6(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute7(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute7(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute8(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute8(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute9(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute9(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute10(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute10(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute11(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute11(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute12(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute12(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute13(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute13(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute14(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute14(i),
           l_ext_attrib_hist_rec_tab.old_ext_attribute15(i),
           l_ext_attrib_hist_rec_tab.new_ext_attribute15(i),
           l_ext_attrib_hist_rec_tab.ext_full_dump_flag(i), --'N', dump_flag
           l_ext_attrib_hist_rec_tab.ext_migrated_flag(i), -- mig_flag
           l_ext_attrib_hist_rec_tab.old_ext_active_start_date(i),
           l_ext_attrib_hist_rec_tab.new_ext_active_start_date(i),
           l_ext_attrib_hist_rec_tab.old_ext_active_end_date(i),
           l_ext_attrib_hist_rec_tab.new_ext_active_end_date(i),
           l_ext_attrib_hist_rec_tab.ext_creation_date(i),
           l_ext_attrib_hist_rec_tab.ext_last_update_date(i),
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           l_user_id,
           sysdate,
           l_user_id,
           sysdate,
           l_login_id,
           1,
           null
           );
Line: 3017

               Delete From CSI_IEA_VALUES_H
               Where attribute_value_history_id = l_ext_attrib_hist_rec_tab.attribute_value_history_id(i);
Line: 3077

    Select csh.*
    From   CSI_I_PRICING_ATTRIBS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between from_trans and to_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 3092

      Select object_id
      Into   l_table_id
      From   csi_object_dictionary
      Where  object_name = 'CSI_I_PRICING_ATTRIBS_H';
Line: 3104

      Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
      Into   v_batch
      From   dual;
Line: 3124

      l_pri_attribs_hist_rec_tab.price_attrib_history_id.DELETE;
Line: 3125

      l_pri_attribs_hist_rec_tab.pricing_attribute_id.DELETE;
Line: 3126

      l_pri_attribs_hist_rec_tab.transaction_id.DELETE;
Line: 3127

      l_pri_attribs_hist_rec_tab.old_pricing_context.DELETE;
Line: 3128

      l_pri_attribs_hist_rec_tab.new_pricing_context.DELETE;
Line: 3129

      l_pri_attribs_hist_rec_tab.old_pricing_attribute1.DELETE;
Line: 3130

      l_pri_attribs_hist_rec_tab.new_pricing_attribute1.DELETE;
Line: 3131

      l_pri_attribs_hist_rec_tab.old_pricing_attribute2.DELETE;
Line: 3132

      l_pri_attribs_hist_rec_tab.new_pricing_attribute2.DELETE;
Line: 3133

      l_pri_attribs_hist_rec_tab.old_pricing_attribute3.DELETE;
Line: 3134

      l_pri_attribs_hist_rec_tab.new_pricing_attribute3.DELETE;
Line: 3135

      l_pri_attribs_hist_rec_tab.old_pricing_attribute4.DELETE;
Line: 3136

      l_pri_attribs_hist_rec_tab.new_pricing_attribute4.DELETE;
Line: 3137

      l_pri_attribs_hist_rec_tab.old_pricing_attribute5.DELETE;
Line: 3138

      l_pri_attribs_hist_rec_tab.new_pricing_attribute5.DELETE;
Line: 3139

      l_pri_attribs_hist_rec_tab.old_pricing_attribute6.DELETE;
Line: 3140

      l_pri_attribs_hist_rec_tab.new_pricing_attribute6.DELETE;
Line: 3141

      l_pri_attribs_hist_rec_tab.old_pricing_attribute7.DELETE;
Line: 3142

      l_pri_attribs_hist_rec_tab.new_pricing_attribute7.DELETE;
Line: 3143

      l_pri_attribs_hist_rec_tab.old_pricing_attribute8.DELETE;
Line: 3144

      l_pri_attribs_hist_rec_tab.new_pricing_attribute8.DELETE;
Line: 3145

      l_pri_attribs_hist_rec_tab.old_pricing_attribute9.DELETE;
Line: 3146

      l_pri_attribs_hist_rec_tab.new_pricing_attribute9.DELETE;
Line: 3147

      l_pri_attribs_hist_rec_tab.old_pricing_attribute10.DELETE;
Line: 3148

      l_pri_attribs_hist_rec_tab.new_pricing_attribute10.DELETE;
Line: 3149

      l_pri_attribs_hist_rec_tab.old_pricing_attribute11.DELETE;
Line: 3150

      l_pri_attribs_hist_rec_tab.new_pricing_attribute11.DELETE;
Line: 3151

      l_pri_attribs_hist_rec_tab.old_pricing_attribute12.DELETE;
Line: 3152

      l_pri_attribs_hist_rec_tab.new_pricing_attribute12.DELETE;
Line: 3153

      l_pri_attribs_hist_rec_tab.old_pricing_attribute13.DELETE;
Line: 3154

      l_pri_attribs_hist_rec_tab.new_pricing_attribute13.DELETE;
Line: 3155

      l_pri_attribs_hist_rec_tab.old_pricing_attribute14.DELETE;
Line: 3156

      l_pri_attribs_hist_rec_tab.new_pricing_attribute14.DELETE;
Line: 3157

      l_pri_attribs_hist_rec_tab.old_pricing_attribute15.DELETE;
Line: 3158

      l_pri_attribs_hist_rec_tab.new_pricing_attribute15.DELETE;
Line: 3159

      l_pri_attribs_hist_rec_tab.old_pricing_attribute16.DELETE;
Line: 3160

      l_pri_attribs_hist_rec_tab.new_pricing_attribute16.DELETE;
Line: 3161

      l_pri_attribs_hist_rec_tab.old_pricing_attribute17.DELETE;
Line: 3162

      l_pri_attribs_hist_rec_tab.new_pricing_attribute17.DELETE;
Line: 3163

      l_pri_attribs_hist_rec_tab.old_pricing_attribute18.DELETE;
Line: 3164

      l_pri_attribs_hist_rec_tab.new_pricing_attribute18.DELETE;
Line: 3165

      l_pri_attribs_hist_rec_tab.old_pricing_attribute19.DELETE;
Line: 3166

      l_pri_attribs_hist_rec_tab.new_pricing_attribute19.DELETE;
Line: 3167

      l_pri_attribs_hist_rec_tab.old_pricing_attribute20.DELETE;
Line: 3168

      l_pri_attribs_hist_rec_tab.new_pricing_attribute20.DELETE;
Line: 3169

      l_pri_attribs_hist_rec_tab.old_pricing_attribute21.DELETE;
Line: 3170

      l_pri_attribs_hist_rec_tab.new_pricing_attribute21.DELETE;
Line: 3171

      l_pri_attribs_hist_rec_tab.old_pricing_attribute22.DELETE;
Line: 3172

      l_pri_attribs_hist_rec_tab.new_pricing_attribute22.DELETE;
Line: 3173

      l_pri_attribs_hist_rec_tab.old_pricing_attribute23.DELETE;
Line: 3174

      l_pri_attribs_hist_rec_tab.new_pricing_attribute23.DELETE;
Line: 3175

      l_pri_attribs_hist_rec_tab.old_pricing_attribute24.DELETE;
Line: 3176

      l_pri_attribs_hist_rec_tab.new_pricing_attribute24.DELETE;
Line: 3177

      l_pri_attribs_hist_rec_tab.old_pricing_attribute25.DELETE;
Line: 3178

      l_pri_attribs_hist_rec_tab.new_pricing_attribute25.DELETE;
Line: 3179

      l_pri_attribs_hist_rec_tab.old_pricing_attribute26.DELETE;
Line: 3180

      l_pri_attribs_hist_rec_tab.new_pricing_attribute26.DELETE;
Line: 3181

      l_pri_attribs_hist_rec_tab.old_pricing_attribute27.DELETE;
Line: 3182

      l_pri_attribs_hist_rec_tab.new_pricing_attribute27.DELETE;
Line: 3183

      l_pri_attribs_hist_rec_tab.old_pricing_attribute28.DELETE;
Line: 3184

      l_pri_attribs_hist_rec_tab.new_pricing_attribute28.DELETE;
Line: 3185

      l_pri_attribs_hist_rec_tab.old_pricing_attribute29.DELETE;
Line: 3186

      l_pri_attribs_hist_rec_tab.new_pricing_attribute29.DELETE;
Line: 3187

      l_pri_attribs_hist_rec_tab.old_pricing_attribute30.DELETE;
Line: 3188

      l_pri_attribs_hist_rec_tab.new_pricing_attribute30.DELETE;
Line: 3189

      l_pri_attribs_hist_rec_tab.old_pricing_attribute31.DELETE;
Line: 3190

      l_pri_attribs_hist_rec_tab.new_pricing_attribute31.DELETE;
Line: 3191

      l_pri_attribs_hist_rec_tab.old_pricing_attribute32.DELETE;
Line: 3192

      l_pri_attribs_hist_rec_tab.new_pricing_attribute32.DELETE;
Line: 3193

      l_pri_attribs_hist_rec_tab.old_pricing_attribute33.DELETE;
Line: 3194

      l_pri_attribs_hist_rec_tab.new_pricing_attribute33.DELETE;
Line: 3195

      l_pri_attribs_hist_rec_tab.old_pricing_attribute34.DELETE;
Line: 3196

      l_pri_attribs_hist_rec_tab.new_pricing_attribute34.DELETE;
Line: 3197

      l_pri_attribs_hist_rec_tab.old_pricing_attribute35.DELETE;
Line: 3198

      l_pri_attribs_hist_rec_tab.new_pricing_attribute35.DELETE;
Line: 3199

      l_pri_attribs_hist_rec_tab.old_pricing_attribute36.DELETE;
Line: 3200

      l_pri_attribs_hist_rec_tab.new_pricing_attribute36.DELETE;
Line: 3201

      l_pri_attribs_hist_rec_tab.old_pricing_attribute37.DELETE;
Line: 3202

      l_pri_attribs_hist_rec_tab.new_pricing_attribute37.DELETE;
Line: 3203

      l_pri_attribs_hist_rec_tab.old_pricing_attribute38.DELETE;
Line: 3204

      l_pri_attribs_hist_rec_tab.new_pricing_attribute38.DELETE;
Line: 3205

      l_pri_attribs_hist_rec_tab.old_pricing_attribute39.DELETE;
Line: 3206

      l_pri_attribs_hist_rec_tab.new_pricing_attribute39.DELETE;
Line: 3207

      l_pri_attribs_hist_rec_tab.old_pricing_attribute40.DELETE;
Line: 3208

      l_pri_attribs_hist_rec_tab.new_pricing_attribute40.DELETE;
Line: 3209

      l_pri_attribs_hist_rec_tab.old_pricing_attribute41.DELETE;
Line: 3210

      l_pri_attribs_hist_rec_tab.new_pricing_attribute41.DELETE;
Line: 3211

      l_pri_attribs_hist_rec_tab.old_pricing_attribute42.DELETE;
Line: 3212

      l_pri_attribs_hist_rec_tab.new_pricing_attribute42.DELETE;
Line: 3213

      l_pri_attribs_hist_rec_tab.old_pricing_attribute43.DELETE;
Line: 3214

      l_pri_attribs_hist_rec_tab.new_pricing_attribute43.DELETE;
Line: 3215

      l_pri_attribs_hist_rec_tab.old_pricing_attribute44.DELETE;
Line: 3216

      l_pri_attribs_hist_rec_tab.new_pricing_attribute44.DELETE;
Line: 3217

      l_pri_attribs_hist_rec_tab.old_pricing_attribute45.DELETE;
Line: 3218

      l_pri_attribs_hist_rec_tab.new_pricing_attribute45.DELETE;
Line: 3219

      l_pri_attribs_hist_rec_tab.old_pricing_attribute46.DELETE;
Line: 3220

      l_pri_attribs_hist_rec_tab.new_pricing_attribute46.DELETE;
Line: 3221

      l_pri_attribs_hist_rec_tab.old_pricing_attribute47.DELETE;
Line: 3222

      l_pri_attribs_hist_rec_tab.new_pricing_attribute47.DELETE;
Line: 3223

      l_pri_attribs_hist_rec_tab.old_pricing_attribute48.DELETE;
Line: 3224

      l_pri_attribs_hist_rec_tab.new_pricing_attribute48.DELETE;
Line: 3225

      l_pri_attribs_hist_rec_tab.old_pricing_attribute49.DELETE;
Line: 3226

      l_pri_attribs_hist_rec_tab.new_pricing_attribute49.DELETE;
Line: 3227

      l_pri_attribs_hist_rec_tab.old_pricing_attribute50.DELETE;
Line: 3228

      l_pri_attribs_hist_rec_tab.new_pricing_attribute50.DELETE;
Line: 3229

      l_pri_attribs_hist_rec_tab.old_pricing_attribute51.DELETE;
Line: 3230

      l_pri_attribs_hist_rec_tab.new_pricing_attribute51.DELETE;
Line: 3231

      l_pri_attribs_hist_rec_tab.old_pricing_attribute52.DELETE;
Line: 3232

      l_pri_attribs_hist_rec_tab.new_pricing_attribute52.DELETE;
Line: 3233

      l_pri_attribs_hist_rec_tab.old_pricing_attribute53.DELETE;
Line: 3234

      l_pri_attribs_hist_rec_tab.new_pricing_attribute53.DELETE;
Line: 3235

      l_pri_attribs_hist_rec_tab.old_pricing_attribute54.DELETE;
Line: 3236

      l_pri_attribs_hist_rec_tab.new_pricing_attribute54.DELETE;
Line: 3237

      l_pri_attribs_hist_rec_tab.old_pricing_attribute55.DELETE;
Line: 3238

      l_pri_attribs_hist_rec_tab.new_pricing_attribute55.DELETE;
Line: 3239

      l_pri_attribs_hist_rec_tab.old_pricing_attribute56.DELETE;
Line: 3240

      l_pri_attribs_hist_rec_tab.new_pricing_attribute56.DELETE;
Line: 3241

      l_pri_attribs_hist_rec_tab.old_pricing_attribute57.DELETE;
Line: 3242

      l_pri_attribs_hist_rec_tab.new_pricing_attribute57.DELETE;
Line: 3243

      l_pri_attribs_hist_rec_tab.old_pricing_attribute58.DELETE;
Line: 3244

      l_pri_attribs_hist_rec_tab.new_pricing_attribute58.DELETE;
Line: 3245

      l_pri_attribs_hist_rec_tab.old_pricing_attribute59.DELETE;
Line: 3246

      l_pri_attribs_hist_rec_tab.new_pricing_attribute59.DELETE;
Line: 3247

      l_pri_attribs_hist_rec_tab.old_pricing_attribute60.DELETE;
Line: 3248

      l_pri_attribs_hist_rec_tab.new_pricing_attribute60.DELETE;
Line: 3249

      l_pri_attribs_hist_rec_tab.old_pricing_attribute61.DELETE;
Line: 3250

      l_pri_attribs_hist_rec_tab.new_pricing_attribute61.DELETE;
Line: 3251

      l_pri_attribs_hist_rec_tab.old_pricing_attribute62.DELETE;
Line: 3252

      l_pri_attribs_hist_rec_tab.new_pricing_attribute62.DELETE;
Line: 3253

      l_pri_attribs_hist_rec_tab.old_pricing_attribute63.DELETE;
Line: 3254

      l_pri_attribs_hist_rec_tab.new_pricing_attribute63.DELETE;
Line: 3255

      l_pri_attribs_hist_rec_tab.old_pricing_attribute64.DELETE;
Line: 3256

      l_pri_attribs_hist_rec_tab.new_pricing_attribute64.DELETE;
Line: 3257

      l_pri_attribs_hist_rec_tab.old_pricing_attribute65.DELETE;
Line: 3258

      l_pri_attribs_hist_rec_tab.new_pricing_attribute65.DELETE;
Line: 3259

      l_pri_attribs_hist_rec_tab.old_pricing_attribute66.DELETE;
Line: 3260

      l_pri_attribs_hist_rec_tab.new_pricing_attribute66.DELETE;
Line: 3261

      l_pri_attribs_hist_rec_tab.old_pricing_attribute67.DELETE;
Line: 3262

      l_pri_attribs_hist_rec_tab.new_pricing_attribute67.DELETE;
Line: 3263

      l_pri_attribs_hist_rec_tab.old_pricing_attribute68.DELETE;
Line: 3264

      l_pri_attribs_hist_rec_tab.new_pricing_attribute68.DELETE;
Line: 3265

      l_pri_attribs_hist_rec_tab.old_pricing_attribute69.DELETE;
Line: 3266

      l_pri_attribs_hist_rec_tab.new_pricing_attribute69.DELETE;
Line: 3267

      l_pri_attribs_hist_rec_tab.old_pricing_attribute70.DELETE;
Line: 3268

      l_pri_attribs_hist_rec_tab.new_pricing_attribute70.DELETE;
Line: 3269

      l_pri_attribs_hist_rec_tab.old_pricing_attribute71.DELETE;
Line: 3270

      l_pri_attribs_hist_rec_tab.new_pricing_attribute71.DELETE;
Line: 3271

      l_pri_attribs_hist_rec_tab.old_pricing_attribute72.DELETE;
Line: 3272

      l_pri_attribs_hist_rec_tab.new_pricing_attribute72.DELETE;
Line: 3273

      l_pri_attribs_hist_rec_tab.old_pricing_attribute73.DELETE;
Line: 3274

      l_pri_attribs_hist_rec_tab.new_pricing_attribute73.DELETE;
Line: 3275

      l_pri_attribs_hist_rec_tab.old_pricing_attribute74.DELETE;
Line: 3276

      l_pri_attribs_hist_rec_tab.new_pricing_attribute74.DELETE;
Line: 3277

      l_pri_attribs_hist_rec_tab.old_pricing_attribute75.DELETE;
Line: 3278

      l_pri_attribs_hist_rec_tab.new_pricing_attribute75.DELETE;
Line: 3279

      l_pri_attribs_hist_rec_tab.old_pricing_attribute76.DELETE;
Line: 3280

      l_pri_attribs_hist_rec_tab.new_pricing_attribute76.DELETE;
Line: 3281

      l_pri_attribs_hist_rec_tab.old_pricing_attribute77.DELETE;
Line: 3282

      l_pri_attribs_hist_rec_tab.new_pricing_attribute77.DELETE;
Line: 3283

      l_pri_attribs_hist_rec_tab.old_pricing_attribute78.DELETE;
Line: 3284

      l_pri_attribs_hist_rec_tab.new_pricing_attribute78.DELETE;
Line: 3285

      l_pri_attribs_hist_rec_tab.old_pricing_attribute79.DELETE;
Line: 3286

      l_pri_attribs_hist_rec_tab.new_pricing_attribute79.DELETE;
Line: 3287

      l_pri_attribs_hist_rec_tab.old_pricing_attribute80.DELETE;
Line: 3288

      l_pri_attribs_hist_rec_tab.new_pricing_attribute80.DELETE;
Line: 3289

      l_pri_attribs_hist_rec_tab.old_pricing_attribute81.DELETE;
Line: 3290

      l_pri_attribs_hist_rec_tab.new_pricing_attribute81.DELETE;
Line: 3291

      l_pri_attribs_hist_rec_tab.old_pricing_attribute82.DELETE;
Line: 3292

      l_pri_attribs_hist_rec_tab.new_pricing_attribute82.DELETE;
Line: 3293

      l_pri_attribs_hist_rec_tab.old_pricing_attribute83.DELETE;
Line: 3294

      l_pri_attribs_hist_rec_tab.new_pricing_attribute83.DELETE;
Line: 3295

      l_pri_attribs_hist_rec_tab.old_pricing_attribute84.DELETE;
Line: 3296

      l_pri_attribs_hist_rec_tab.new_pricing_attribute84.DELETE;
Line: 3297

      l_pri_attribs_hist_rec_tab.old_pricing_attribute85.DELETE;
Line: 3298

      l_pri_attribs_hist_rec_tab.new_pricing_attribute85.DELETE;
Line: 3299

      l_pri_attribs_hist_rec_tab.old_pricing_attribute86.DELETE;
Line: 3300

      l_pri_attribs_hist_rec_tab.new_pricing_attribute86.DELETE;
Line: 3301

      l_pri_attribs_hist_rec_tab.old_pricing_attribute87.DELETE;
Line: 3302

      l_pri_attribs_hist_rec_tab.new_pricing_attribute87.DELETE;
Line: 3303

      l_pri_attribs_hist_rec_tab.old_pricing_attribute88.DELETE;
Line: 3304

      l_pri_attribs_hist_rec_tab.new_pricing_attribute88.DELETE;
Line: 3305

      l_pri_attribs_hist_rec_tab.old_pricing_attribute89.DELETE;
Line: 3306

      l_pri_attribs_hist_rec_tab.new_pricing_attribute89.DELETE;
Line: 3307

      l_pri_attribs_hist_rec_tab.old_pricing_attribute90.DELETE;
Line: 3308

      l_pri_attribs_hist_rec_tab.new_pricing_attribute90.DELETE;
Line: 3309

      l_pri_attribs_hist_rec_tab.old_pricing_attribute91.DELETE;
Line: 3310

      l_pri_attribs_hist_rec_tab.new_pricing_attribute91.DELETE;
Line: 3311

      l_pri_attribs_hist_rec_tab.old_pricing_attribute92.DELETE;
Line: 3312

      l_pri_attribs_hist_rec_tab.new_pricing_attribute92.DELETE;
Line: 3313

      l_pri_attribs_hist_rec_tab.old_pricing_attribute93.DELETE;
Line: 3314

      l_pri_attribs_hist_rec_tab.new_pricing_attribute93.DELETE;
Line: 3315

      l_pri_attribs_hist_rec_tab.old_pricing_attribute94.DELETE;
Line: 3316

      l_pri_attribs_hist_rec_tab.new_pricing_attribute94.DELETE;
Line: 3317

      l_pri_attribs_hist_rec_tab.old_pricing_attribute95.DELETE;
Line: 3318

      l_pri_attribs_hist_rec_tab.new_pricing_attribute95.DELETE;
Line: 3319

      l_pri_attribs_hist_rec_tab.old_pricing_attribute96.DELETE;
Line: 3320

      l_pri_attribs_hist_rec_tab.new_pricing_attribute96.DELETE;
Line: 3321

      l_pri_attribs_hist_rec_tab.old_pricing_attribute97.DELETE;
Line: 3322

      l_pri_attribs_hist_rec_tab.new_pricing_attribute97.DELETE;
Line: 3323

      l_pri_attribs_hist_rec_tab.old_pricing_attribute98.DELETE;
Line: 3324

      l_pri_attribs_hist_rec_tab.new_pricing_attribute98.DELETE;
Line: 3325

      l_pri_attribs_hist_rec_tab.old_pricing_attribute99.DELETE;
Line: 3326

      l_pri_attribs_hist_rec_tab.new_pricing_attribute99.DELETE;
Line: 3327

      l_pri_attribs_hist_rec_tab.old_pricing_attribute100.DELETE;
Line: 3328

      l_pri_attribs_hist_rec_tab.new_pricing_attribute100.DELETE;
Line: 3329

      l_pri_attribs_hist_rec_tab.old_pri_active_start_date.DELETE;
Line: 3330

      l_pri_attribs_hist_rec_tab.new_pri_active_start_date.DELETE;
Line: 3331

      l_pri_attribs_hist_rec_tab.old_pri_active_end_date.DELETE;
Line: 3332

      l_pri_attribs_hist_rec_tab.new_pri_active_end_date.DELETE;
Line: 3333

      l_pri_attribs_hist_rec_tab.old_pri_context.DELETE;
Line: 3334

      l_pri_attribs_hist_rec_tab.new_pri_context.DELETE;
Line: 3335

      l_pri_attribs_hist_rec_tab.old_pri_attribute1.DELETE;
Line: 3336

      l_pri_attribs_hist_rec_tab.new_pri_attribute1.DELETE;
Line: 3337

      l_pri_attribs_hist_rec_tab.old_pri_attribute2.DELETE;
Line: 3338

      l_pri_attribs_hist_rec_tab.new_pri_attribute2.DELETE;
Line: 3339

      l_pri_attribs_hist_rec_tab.old_pri_attribute3.DELETE;
Line: 3340

      l_pri_attribs_hist_rec_tab.new_pri_attribute3.DELETE;
Line: 3341

      l_pri_attribs_hist_rec_tab.old_pri_attribute4.DELETE;
Line: 3342

      l_pri_attribs_hist_rec_tab.new_pri_attribute4.DELETE;
Line: 3343

      l_pri_attribs_hist_rec_tab.old_pri_attribute5.DELETE;
Line: 3344

      l_pri_attribs_hist_rec_tab.new_pri_attribute5.DELETE;
Line: 3345

      l_pri_attribs_hist_rec_tab.old_pri_attribute6.DELETE;
Line: 3346

      l_pri_attribs_hist_rec_tab.new_pri_attribute6.DELETE;
Line: 3347

      l_pri_attribs_hist_rec_tab.old_pri_attribute7.DELETE;
Line: 3348

      l_pri_attribs_hist_rec_tab.new_pri_attribute7.DELETE;
Line: 3349

      l_pri_attribs_hist_rec_tab.old_pri_attribute8.DELETE;
Line: 3350

      l_pri_attribs_hist_rec_tab.new_pri_attribute8.DELETE;
Line: 3351

      l_pri_attribs_hist_rec_tab.old_pri_attribute9.DELETE;
Line: 3352

      l_pri_attribs_hist_rec_tab.new_pri_attribute9.DELETE;
Line: 3353

      l_pri_attribs_hist_rec_tab.old_pri_attribute10.DELETE;
Line: 3354

      l_pri_attribs_hist_rec_tab.new_pri_attribute10.DELETE;
Line: 3355

      l_pri_attribs_hist_rec_tab.old_pri_attribute11.DELETE;
Line: 3356

      l_pri_attribs_hist_rec_tab.new_pri_attribute11.DELETE;
Line: 3357

      l_pri_attribs_hist_rec_tab.old_pri_attribute12.DELETE;
Line: 3358

      l_pri_attribs_hist_rec_tab.new_pri_attribute12.DELETE;
Line: 3359

      l_pri_attribs_hist_rec_tab.old_pri_attribute13.DELETE;
Line: 3360

      l_pri_attribs_hist_rec_tab.new_pri_attribute13.DELETE;
Line: 3361

      l_pri_attribs_hist_rec_tab.old_pri_attribute14.DELETE;
Line: 3362

      l_pri_attribs_hist_rec_tab.new_pri_attribute14.DELETE;
Line: 3363

      l_pri_attribs_hist_rec_tab.old_pri_attribute15.DELETE;
Line: 3364

      l_pri_attribs_hist_rec_tab.new_pri_attribute15.DELETE;
Line: 3365

      l_pri_attribs_hist_rec_tab.pri_full_dump_flag.DELETE;
Line: 3366

      l_pri_attribs_hist_rec_tab.pri_created_by.DELETE;
Line: 3367

      l_pri_attribs_hist_rec_tab.pri_creation_date.DELETE;
Line: 3368

      l_pri_attribs_hist_rec_tab.pri_last_updated_by.DELETE;
Line: 3369

      l_pri_attribs_hist_rec_tab.pri_last_update_date.DELETE;
Line: 3370

      l_pri_attribs_hist_rec_tab.pri_last_update_login.DELETE;
Line: 3371

      l_pri_attribs_hist_rec_tab.pri_object_version_number.DELETE;
Line: 3372

      l_pri_attribs_hist_rec_tab.pri_security_group_id.DELETE;
Line: 3373

      l_pri_attribs_hist_rec_tab.pri_migrated_flag.DELETE;
Line: 3381

      Select csi_history_archive_s.Nextval
      Into l_archive_id_tbl(l_ctr)
      From dual;
Line: 3629

      l_pri_attribs_hist_rec_tab.pri_last_updated_by(l_ctr)               :=  i.last_updated_by;
Line: 3630

      l_pri_attribs_hist_rec_tab.pri_last_update_date(l_ctr)              :=  i.last_update_date;
Line: 3631

      l_pri_attribs_hist_rec_tab.pri_last_update_login(l_ctr)             :=  i.last_update_login;
Line: 3651

         Insert Into CSI_HISTORY_ARCHIVE
         (
            HISTORY_ARCHIVE_ID
           ,OBJECT_ID
           ,ENTITY_HISTORY_ID
           ,TRANSACTION_ID
           ,ENTITY_ID
           ,COL_NUM_37
           ,COL_NUM_38
           ,COL_NUM_39
           ,COL_NUM_40
           ,COL_NUM_41
          ,COL_CHAR_01
          ,COL_CHAR_02
          ,COL_CHAR_03
          ,COL_CHAR_04
          ,COL_CHAR_05
          ,COL_CHAR_06
          ,COL_CHAR_07
          ,COL_CHAR_08
          ,COL_CHAR_09
          ,COL_CHAR_10
          ,COL_CHAR_11
          ,COL_CHAR_12
          ,COL_CHAR_13
          ,COL_CHAR_14
          ,COL_CHAR_15
          ,COL_CHAR_16
          ,COL_CHAR_17
          ,COL_CHAR_18
          ,COL_CHAR_19
          ,COL_CHAR_20
          ,COL_CHAR_21
          ,COL_CHAR_22
          ,COL_CHAR_23
          ,COL_CHAR_24
          ,COL_CHAR_25
          ,COL_CHAR_26
          ,COL_CHAR_27
          ,COL_CHAR_28
          ,COL_CHAR_29
          ,COL_CHAR_30
          ,COL_CHAR_31
          ,COL_CHAR_32
          ,COL_CHAR_33
          ,COL_CHAR_34
          ,COL_CHAR_35
          ,COL_CHAR_36
          ,COL_CHAR_37
          ,COL_CHAR_38
          ,COL_CHAR_39
          ,COL_CHAR_40
          ,COL_CHAR_41
          ,COL_CHAR_42
          ,COL_CHAR_43
          ,COL_CHAR_44
          ,COL_CHAR_45
          ,COL_CHAR_46
          ,COL_CHAR_47
          ,COL_CHAR_48
          ,COL_CHAR_49
          ,COL_CHAR_50
          ,COL_CHAR_51
          ,COL_CHAR_52
          ,COL_CHAR_53
          ,COL_CHAR_54
          ,COL_CHAR_55
          ,COL_CHAR_56
          ,COL_CHAR_57
          ,COL_CHAR_58
          ,COL_CHAR_59
          ,COL_CHAR_60
          ,COL_CHAR_61
          ,COL_CHAR_62
          ,COL_CHAR_63
          ,COL_CHAR_64
          ,COL_CHAR_65
          ,COL_CHAR_66
          ,COL_CHAR_67
          ,COL_CHAR_68
          ,COL_CHAR_69
          ,COL_CHAR_70
          ,COL_CHAR_71
          ,COL_CHAR_72
          ,COL_CHAR_73
          ,COL_CHAR_74
          ,COL_CHAR_75
          ,COL_CHAR_76
          ,COL_CHAR_77
          ,COL_CHAR_78
          ,COL_CHAR_79
          ,COL_CHAR_80
          ,COL_CHAR_81
          ,COL_CHAR_82
          ,COL_CHAR_83
          ,COL_CHAR_84
          ,COL_CHAR_85
          ,COL_CHAR_86
          ,COL_CHAR_87
          ,COL_CHAR_88
          ,COL_CHAR_89
          ,COL_CHAR_90
          ,COL_CHAR_91
          ,COL_CHAR_92
          ,COL_CHAR_93
          ,COL_CHAR_94
          ,COL_CHAR_95
          ,COL_CHAR_96
          ,COL_CHAR_97
          ,COL_CHAR_98
          ,COL_CHAR_99
          ,COL_CHAR_100
          ,COL_CHAR_101
          ,COL_CHAR_102
          ,COL_CHAR_103
          ,COL_CHAR_104
          ,COL_CHAR_105
          ,COL_CHAR_106
          ,COL_CHAR_107
          ,COL_CHAR_108
          ,COL_CHAR_109
          ,COL_CHAR_110
          ,COL_CHAR_111
          ,COL_CHAR_112
          ,COL_CHAR_113
          ,COL_CHAR_114
          ,COL_CHAR_115
          ,COL_CHAR_116
          ,COL_CHAR_117
          ,COL_CHAR_118
          ,COL_CHAR_119
          ,COL_CHAR_120
          ,COL_CHAR_121
          ,COL_CHAR_122
          ,COL_CHAR_123
          ,COL_CHAR_124
          ,COL_CHAR_125
          ,COL_CHAR_126
          ,COL_CHAR_127
          ,COL_CHAR_128
          ,COL_CHAR_129
          ,COL_CHAR_130
          ,COL_CHAR_131
          ,COL_CHAR_132
          ,COL_CHAR_133
          ,COL_CHAR_134
          ,COL_CHAR_135
          ,COL_CHAR_136
          ,COL_CHAR_137
          ,COL_CHAR_138
          ,COL_CHAR_139
          ,COL_CHAR_140
          ,COL_CHAR_141
          ,COL_CHAR_142
          ,COL_CHAR_143
          ,COL_CHAR_144
          ,COL_CHAR_145
          ,COL_CHAR_146
          ,COL_CHAR_147
          ,COL_CHAR_148
          ,COL_CHAR_149
          ,COL_CHAR_150
          ,COL_CHAR_151
          ,COL_CHAR_152
          ,COL_CHAR_153
          ,COL_CHAR_154
          ,COL_CHAR_155
          ,COL_CHAR_156
          ,COL_CHAR_157
          ,COL_CHAR_158
          ,COL_CHAR_159
          ,COL_CHAR_160
          ,COL_CHAR_161
          ,COL_CHAR_162
          ,COL_CHAR_163
          ,COL_CHAR_164
          ,COL_CHAR_165
          ,COL_CHAR_166
          ,COL_CHAR_167
          ,COL_CHAR_168
          ,COL_CHAR_169
          ,COL_CHAR_170
          ,COL_CHAR_171
          ,COL_CHAR_172
          ,COL_CHAR_173
          ,COL_CHAR_174
          ,COL_CHAR_175
          ,COL_CHAR_176
          ,COL_CHAR_177
          ,COL_CHAR_178
          ,COL_CHAR_179
          ,COL_CHAR_180
          ,COL_CHAR_181
          ,COL_CHAR_182
          ,COL_CHAR_183
          ,COL_CHAR_184
          ,COL_CHAR_185
          ,COL_CHAR_186
          ,COL_CHAR_187
          ,COL_CHAR_188
          ,COL_CHAR_189
          ,COL_CHAR_190
          ,COL_CHAR_191
          ,COL_CHAR_192
          ,COL_CHAR_193
          ,COL_CHAR_194
          ,COL_CHAR_195
          ,COL_CHAR_196
          ,COL_CHAR_197
          ,COL_CHAR_198
          ,COL_CHAR_199
          ,COL_CHAR_200
          ,COL_CHAR_201
          ,COL_CHAR_202
          ,COL_CHAR_203
          ,COL_CHAR_204
          ,COL_CHAR_205
          ,COL_CHAR_206
          ,COL_CHAR_207
          ,COL_CHAR_208
          ,COL_CHAR_209
          ,COL_CHAR_210
          ,COL_CHAR_211
          ,COL_CHAR_212
          ,COL_CHAR_213
          ,COL_CHAR_214
          ,COL_CHAR_215
          ,COL_CHAR_216
          ,COL_CHAR_217
          ,COL_CHAR_218
          ,COL_CHAR_219
          ,COL_CHAR_220
          ,COL_CHAR_221
          ,COL_CHAR_222
          ,COL_CHAR_223
          ,COL_CHAR_224
          ,COL_CHAR_225
          ,COL_CHAR_226
          ,COL_CHAR_227
          ,COL_CHAR_228
          ,COL_CHAR_229
          ,COL_CHAR_230
          ,COL_CHAR_231
          ,COL_CHAR_232
          ,COL_CHAR_233
          ,COL_CHAR_234
          ,COL_CHAR_235
          ,COL_CHAR_236
          ,COL_DATE_01
          ,COL_DATE_02
          ,COL_DATE_03
          ,COL_DATE_04
          ,COL_DATE_11
          ,COL_DATE_12
          ,CONTEXT
          ,ATTRIBUTE1
          ,ATTRIBUTE2
          ,ATTRIBUTE3
          ,ATTRIBUTE4
          ,ATTRIBUTE5
          ,ATTRIBUTE6
          ,ATTRIBUTE7
          ,ATTRIBUTE8
          ,ATTRIBUTE9
          ,ATTRIBUTE10
          ,ATTRIBUTE11
          ,ATTRIBUTE12
          ,ATTRIBUTE13
          ,ATTRIBUTE14
          ,ATTRIBUTE15
          ,CREATED_BY
          ,CREATION_DATE
          ,LAST_UPDATED_BY
          ,LAST_UPDATE_DATE
          ,LAST_UPDATE_LOGIN
          ,OBJECT_VERSION_NUMBER
          ,SECURITY_GROUP_ID
           )
           Values
           (
               l_archive_id_tbl(i),
               l_table_id,
               l_pri_attribs_hist_rec_tab.price_attrib_history_id(i),
               l_pri_attribs_hist_rec_tab.transaction_id(i),
               l_pri_attribs_hist_rec_tab.pricing_attribute_id(i),
               l_pri_attribs_hist_rec_tab.pri_created_by(i),
               l_pri_attribs_hist_rec_tab.pri_last_updated_by(i),
               l_pri_attribs_hist_rec_tab.pri_last_update_login(i),
               l_pri_attribs_hist_rec_tab.pri_object_version_number(i),
               l_pri_attribs_hist_rec_tab.pri_security_group_id(i),
               l_pri_attribs_hist_rec_tab.old_pricing_context(i),
               l_pri_attribs_hist_rec_tab.new_pricing_context(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute1(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute1(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute2(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute2(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute3(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute3(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute4(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute4(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute5(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute5(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute6(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute6(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute7(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute7(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute8(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute8(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute9(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute9(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute10(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute10(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute11(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute11(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute12(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute12(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute13(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute13(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute14(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute14(i),
               l_pri_attribs_hist_rec_tab.old_pri_context(i),
               l_pri_attribs_hist_rec_tab.new_pri_context(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute1(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute1(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute2(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute2(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute3(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute3(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute4(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute4(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute5(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute5(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute6(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute6(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute7(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute7(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute8(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute8(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute9(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute9(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute10(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute10(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute11(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute11(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute12(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute12(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute13(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute13(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute14(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute14(i),
               l_pri_attribs_hist_rec_tab.old_pri_attribute15(i),
               l_pri_attribs_hist_rec_tab.new_pri_attribute15(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute15(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute15(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute16(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute16(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute17(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute17(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute18(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute18(i),
               l_pri_attribs_hist_rec_tab.pri_full_dump_flag(i),
               l_pri_attribs_hist_rec_tab.pri_migrated_flag(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute19(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute19(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute20(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute20(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute21(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute21(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute22(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute22(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute23(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute23(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute24(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute24(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute25(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute25(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute26(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute26(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute27(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute27(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute28(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute28(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute29(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute29(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute30(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute30(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute31(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute31(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute32(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute32(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute33(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute33(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute34(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute34(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute35(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute35(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute36(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute36(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute37(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute37(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute38(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute38(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute39(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute39(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute40(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute40(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute41(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute41(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute42(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute42(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute43(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute43(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute44(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute44(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute45(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute45(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute46(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute46(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute47(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute47(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute48(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute48(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute49(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute49(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute50(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute50(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute51(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute51(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute52(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute52(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute53(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute53(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute54(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute54(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute55(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute55(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute56(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute56(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute57(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute57(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute58(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute58(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute59(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute59(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute60(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute60(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute61(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute61(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute62(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute62(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute63(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute63(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute64(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute64(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute65(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute65(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute66(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute66(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute67(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute67(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute68(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute68(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute69(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute69(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute70(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute70(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute71(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute71(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute72(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute72(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute73(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute73(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute74(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute74(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute75(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute75(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute76(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute76(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute77(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute77(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute78(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute78(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute79(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute79(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute80(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute80(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute81(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute81(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute82(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute82(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute83(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute83(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute84(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute84(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute85(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute85(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute86(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute86(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute87(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute87(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute88(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute88(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute89(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute89(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute90(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute90(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute91(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute91(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute92(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute92(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute93(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute93(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute94(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute94(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute95(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute95(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute96(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute96(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute97(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute97(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute98(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute98(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute99(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute99(i),
               l_pri_attribs_hist_rec_tab.old_pricing_attribute100(i),
               l_pri_attribs_hist_rec_tab.new_pricing_attribute100(i),
               l_pri_attribs_hist_rec_tab.old_pri_active_start_date(i),
               l_pri_attribs_hist_rec_tab.new_pri_active_start_date(i),
               l_pri_attribs_hist_rec_tab.old_pri_active_end_date(i),
               l_pri_attribs_hist_rec_tab.new_pri_active_end_date(i),
               l_pri_attribs_hist_rec_tab.pri_creation_date(i),
               l_pri_attribs_hist_rec_tab.pri_last_update_date(i),
               null,
               null,
               null,
               null,
               null,
               null,
               null,
               null,
               null,
               null,
               null,
               null,
               null,
               null,
               null,
               null,
               l_user_id,
               sysdate,
               l_user_id,
               sysdate,
               l_login_id,
               1,
               null
               );
Line: 4212

               Delete From CSI_I_PRICING_ATTRIBS_H
               Where price_attrib_history_id = l_pri_attribs_hist_rec_tab.price_attrib_history_id(i);
Line: 4272

    Select csh.*
    From   CSI_I_ASSETS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between from_trans and to_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 4287

      Select object_id
      Into   l_table_id
      From   csi_object_dictionary
      Where  object_name = 'CSI_I_ASSETS_H';
Line: 4299

      Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
      Into   v_batch
      From   dual;
Line: 4319

      l_ins_asset_hist_rec_tab.instance_asset_history_id.DELETE;
Line: 4320

      l_ins_asset_hist_rec_tab.instance_asset_id.DELETE;
Line: 4321

      l_ins_asset_hist_rec_tab.transaction_id.DELETE;
Line: 4322

      l_ins_asset_hist_rec_tab.old_instance_id.DELETE;
Line: 4323

      l_ins_asset_hist_rec_tab.new_instance_id.DELETE;
Line: 4324

      l_ins_asset_hist_rec_tab.old_fa_asset_id.DELETE;
Line: 4325

      l_ins_asset_hist_rec_tab.new_fa_asset_id.DELETE;
Line: 4326

      l_ins_asset_hist_rec_tab.old_asset_quantity.DELETE;
Line: 4327

      l_ins_asset_hist_rec_tab.new_asset_quantity.DELETE;
Line: 4328

      l_ins_asset_hist_rec_tab.old_fa_book_type_code.DELETE;
Line: 4329

      l_ins_asset_hist_rec_tab.new_fa_book_type_code.DELETE;
Line: 4330

      l_ins_asset_hist_rec_tab.old_fa_location_id.DELETE;
Line: 4331

      l_ins_asset_hist_rec_tab.new_fa_location_id.DELETE;
Line: 4332

      l_ins_asset_hist_rec_tab.old_update_status.DELETE;
Line: 4333

      l_ins_asset_hist_rec_tab.new_update_status.DELETE;
Line: 4334

      l_ins_asset_hist_rec_tab.old_ast_active_start_date.DELETE;
Line: 4335

      l_ins_asset_hist_rec_tab.new_ast_active_start_date.DELETE;
Line: 4336

      l_ins_asset_hist_rec_tab.old_ast_active_end_date.DELETE;
Line: 4337

      l_ins_asset_hist_rec_tab.new_ast_active_end_date.DELETE;
Line: 4338

      l_ins_asset_hist_rec_tab.ast_full_dump_flag.DELETE;
Line: 4339

      l_ins_asset_hist_rec_tab.ast_created_by.DELETE;
Line: 4340

      l_ins_asset_hist_rec_tab.ast_creation_date.DELETE;
Line: 4341

      l_ins_asset_hist_rec_tab.ast_last_updated_by.DELETE;
Line: 4342

      l_ins_asset_hist_rec_tab.ast_last_update_date.DELETE;
Line: 4343

      l_ins_asset_hist_rec_tab.ast_last_update_login.DELETE;
Line: 4344

      l_ins_asset_hist_rec_tab.ast_object_version_number.DELETE;
Line: 4345

      l_ins_asset_hist_rec_tab.ast_security_group_id.DELETE;
Line: 4346

      l_ins_asset_hist_rec_tab.ast_migrated_flag.DELETE;
Line: 4354

      Select csi_history_archive_s.Nextval
      Into l_archive_id_tbl(l_ctr)
      From dual;
Line: 4371

      l_ins_asset_hist_rec_tab.old_update_status(l_ctr)                :=  i.old_update_status;
Line: 4372

      l_ins_asset_hist_rec_tab.new_update_status(l_ctr)                :=  i.new_update_status;
Line: 4380

      l_ins_asset_hist_rec_tab.ast_last_updated_by(l_ctr)              :=  i.last_updated_by;
Line: 4381

      l_ins_asset_hist_rec_tab.ast_last_update_date(l_ctr)             :=  i.last_update_date;
Line: 4382

      l_ins_asset_hist_rec_tab.ast_last_update_login(l_ctr)            :=  i.last_update_login;
Line: 4402

         Insert Into CSI_HISTORY_ARCHIVE
         (

            HISTORY_ARCHIVE_ID
           ,OBJECT_ID
           ,ENTITY_HISTORY_ID
           ,TRANSACTION_ID
           ,ENTITY_ID
           ,COL_NUM_01
           ,COL_NUM_02
           ,COL_NUM_03
           ,COL_NUM_04
           ,COL_NUM_05
           ,COL_NUM_06
           ,COL_NUM_07
           ,COL_NUM_08
           ,COL_NUM_37
           ,COL_NUM_38
           ,COL_NUM_39
           ,COL_NUM_40
           ,COL_NUM_41
           ,COL_CHAR_01
           ,COL_CHAR_02
           ,COL_CHAR_03
           ,COL_CHAR_04
           ,COL_CHAR_71
           ,COL_CHAR_72
           ,COL_DATE_01
           ,COL_DATE_02
           ,COL_DATE_03
           ,COL_DATE_04
           ,COL_DATE_11
           ,COL_DATE_12
           ,CONTEXT
           ,ATTRIBUTE1
           ,ATTRIBUTE2
           ,ATTRIBUTE3
           ,ATTRIBUTE4
           ,ATTRIBUTE5
           ,ATTRIBUTE6
           ,ATTRIBUTE7
           ,ATTRIBUTE8
           ,ATTRIBUTE9
           ,ATTRIBUTE10
           ,ATTRIBUTE11
           ,ATTRIBUTE12
           ,ATTRIBUTE13
           ,ATTRIBUTE14
           ,ATTRIBUTE15
           ,CREATED_BY
           ,CREATION_DATE
           ,LAST_UPDATED_BY
           ,LAST_UPDATE_DATE
           ,LAST_UPDATE_LOGIN
           ,OBJECT_VERSION_NUMBER
           ,SECURITY_GROUP_ID
           )
           Values
           (
           l_archive_id_tbl(i),
           l_table_id,
           l_ins_asset_hist_rec_tab.instance_asset_history_id(i),
           l_ins_asset_hist_rec_tab.transaction_id(i),
           l_ins_asset_hist_rec_tab.instance_asset_id(i),
           l_ins_asset_hist_rec_tab.old_instance_id(i),
           l_ins_asset_hist_rec_tab.new_instance_id(i),
           l_ins_asset_hist_rec_tab.old_fa_asset_id(i),
           l_ins_asset_hist_rec_tab.new_fa_asset_id(i),
           l_ins_asset_hist_rec_tab.old_asset_quantity(i),
           l_ins_asset_hist_rec_tab.new_asset_quantity(i),
           l_ins_asset_hist_rec_tab.old_fa_location_id(i),
           l_ins_asset_hist_rec_tab.new_fa_location_id(i),
           l_ins_asset_hist_rec_tab.ast_created_by(i),
           l_ins_asset_hist_rec_tab.ast_last_updated_by(i),
           l_ins_asset_hist_rec_tab.ast_last_update_login(i),
	   l_ins_asset_hist_rec_tab.ast_object_version_number(i), -- obj_ver_num
           l_ins_asset_hist_rec_tab.ast_security_group_id(i), -- sec_grp_id
           l_ins_asset_hist_rec_tab.old_fa_book_type_code(i),
           l_ins_asset_hist_rec_tab.new_fa_book_type_code(i),
           l_ins_asset_hist_rec_tab.old_update_status(i),
           l_ins_asset_hist_rec_tab.new_update_status(i),
           l_ins_asset_hist_rec_tab.ast_full_dump_flag(i), --'N', dump_flag
           l_ins_asset_hist_rec_tab.ast_migrated_flag(i), -- mig_flag
           l_ins_asset_hist_rec_tab.old_ast_active_start_date(i),
           l_ins_asset_hist_rec_tab.new_ast_active_start_date(i),
           l_ins_asset_hist_rec_tab.old_ast_active_end_date(i),
           l_ins_asset_hist_rec_tab.new_ast_active_end_date(i),
           l_ins_asset_hist_rec_tab.ast_creation_date(i),
           l_ins_asset_hist_rec_tab.ast_last_update_date(i),
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           l_user_id,
           sysdate,
           l_user_id,
           sysdate,
           l_login_id,
           1,
           null
           );
Line: 4520

               Delete From CSI_I_ASSETS_H
               Where instance_asset_history_id = l_ins_asset_hist_rec_tab.instance_asset_history_id(i);
Line: 4575

    Select csh.*
    From   CSI_I_VERSION_LABELS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between from_trans and to_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 4590

      Select object_id
      Into   l_table_id
      From   csi_object_dictionary
      Where  object_name = 'CSI_I_VERSION_LABELS_H';
Line: 4602

      Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
      Into   v_batch
      From   dual;
Line: 4622

      l_ver_label_hist_rec_tab.version_label_history_id.DELETE;
Line: 4623

      l_ver_label_hist_rec_tab.version_label_id.DELETE;
Line: 4624

      l_ver_label_hist_rec_tab.transaction_id.DELETE;
Line: 4625

      l_ver_label_hist_rec_tab.old_version_label.DELETE;
Line: 4626

      l_ver_label_hist_rec_tab.new_version_label.DELETE;
Line: 4627

      l_ver_label_hist_rec_tab.old_ver_description.DELETE;
Line: 4628

      l_ver_label_hist_rec_tab.new_ver_description.DELETE;
Line: 4629

      l_ver_label_hist_rec_tab.old_date_time_stamp.DELETE;
Line: 4630

      l_ver_label_hist_rec_tab.new_date_time_stamp.DELETE;
Line: 4631

      l_ver_label_hist_rec_tab.old_ver_active_start_date.DELETE;
Line: 4632

      l_ver_label_hist_rec_tab.new_ver_active_start_date.DELETE;
Line: 4633

      l_ver_label_hist_rec_tab.old_ver_active_end_date.DELETE;
Line: 4634

      l_ver_label_hist_rec_tab.new_ver_active_end_date.DELETE;
Line: 4635

      l_ver_label_hist_rec_tab.old_ver_context.DELETE;
Line: 4636

      l_ver_label_hist_rec_tab.new_ver_context.DELETE;
Line: 4637

      l_ver_label_hist_rec_tab.old_ver_attribute1.DELETE;
Line: 4638

      l_ver_label_hist_rec_tab.new_ver_attribute1.DELETE;
Line: 4639

      l_ver_label_hist_rec_tab.old_ver_attribute2.DELETE;
Line: 4640

      l_ver_label_hist_rec_tab.new_ver_attribute2.DELETE;
Line: 4641

      l_ver_label_hist_rec_tab.old_ver_attribute3.DELETE;
Line: 4642

      l_ver_label_hist_rec_tab.new_ver_attribute3.DELETE;
Line: 4643

      l_ver_label_hist_rec_tab.old_ver_attribute4.DELETE;
Line: 4644

      l_ver_label_hist_rec_tab.new_ver_attribute4.DELETE;
Line: 4645

      l_ver_label_hist_rec_tab.old_ver_attribute5.DELETE;
Line: 4646

      l_ver_label_hist_rec_tab.new_ver_attribute5.DELETE;
Line: 4647

      l_ver_label_hist_rec_tab.old_ver_attribute6.DELETE;
Line: 4648

      l_ver_label_hist_rec_tab.new_ver_attribute6.DELETE;
Line: 4649

      l_ver_label_hist_rec_tab.old_ver_attribute7.DELETE;
Line: 4650

      l_ver_label_hist_rec_tab.new_ver_attribute7.DELETE;
Line: 4651

      l_ver_label_hist_rec_tab.old_ver_attribute8.DELETE;
Line: 4652

      l_ver_label_hist_rec_tab.new_ver_attribute8.DELETE;
Line: 4653

      l_ver_label_hist_rec_tab.old_ver_attribute9.DELETE;
Line: 4654

      l_ver_label_hist_rec_tab.new_ver_attribute9.DELETE;
Line: 4655

      l_ver_label_hist_rec_tab.old_ver_attribute10.DELETE;
Line: 4656

      l_ver_label_hist_rec_tab.new_ver_attribute10.DELETE;
Line: 4657

      l_ver_label_hist_rec_tab.old_ver_attribute11.DELETE;
Line: 4658

      l_ver_label_hist_rec_tab.new_ver_attribute11.DELETE;
Line: 4659

      l_ver_label_hist_rec_tab.old_ver_attribute12.DELETE;
Line: 4660

      l_ver_label_hist_rec_tab.new_ver_attribute12.DELETE;
Line: 4661

      l_ver_label_hist_rec_tab.old_ver_attribute13.DELETE;
Line: 4662

      l_ver_label_hist_rec_tab.new_ver_attribute13.DELETE;
Line: 4663

      l_ver_label_hist_rec_tab.old_ver_attribute14.DELETE;
Line: 4664

      l_ver_label_hist_rec_tab.new_ver_attribute14.DELETE;
Line: 4665

      l_ver_label_hist_rec_tab.old_ver_attribute15.DELETE;
Line: 4666

      l_ver_label_hist_rec_tab.new_ver_attribute15.DELETE;
Line: 4667

      l_ver_label_hist_rec_tab.ver_full_dump_flag.DELETE;
Line: 4668

      l_ver_label_hist_rec_tab.ver_created_by.DELETE;
Line: 4669

      l_ver_label_hist_rec_tab.ver_creation_date.DELETE;
Line: 4670

      l_ver_label_hist_rec_tab.ver_last_updated_by.DELETE;
Line: 4671

      l_ver_label_hist_rec_tab.ver_last_update_date.DELETE;
Line: 4672

      l_ver_label_hist_rec_tab.ver_last_update_login.DELETE;
Line: 4673

      l_ver_label_hist_rec_tab.ver_object_version_number.DELETE;
Line: 4674

      l_ver_label_hist_rec_tab.ver_security_group_id.DELETE;
Line: 4675

      l_ver_label_hist_rec_tab.ver_migrated_flag.DELETE;
Line: 4683

      Select csi_history_archive_s.Nextval
      Into l_archive_id_tbl(l_ctr)
      From dual;
Line: 4735

      l_ver_label_hist_rec_tab.ver_last_updated_by(l_ctr)              :=  i.last_updated_by;
Line: 4736

      l_ver_label_hist_rec_tab.ver_last_update_date(l_ctr)             :=  i.last_update_date;
Line: 4737

      l_ver_label_hist_rec_tab.ver_last_update_login(l_ctr)            :=  i.last_update_login;
Line: 4757

         Insert Into CSI_HISTORY_ARCHIVE
         (
            HISTORY_ARCHIVE_ID
           ,OBJECT_ID
           ,ENTITY_HISTORY_ID
           ,TRANSACTION_ID
           ,ENTITY_ID
           ,COL_NUM_37
           ,COL_NUM_38
           ,COL_NUM_39
           ,COL_NUM_40
           ,COL_NUM_41
           ,COL_CHAR_01
           ,COL_CHAR_02
           ,COL_CHAR_03
           ,COL_CHAR_04
           ,COL_CHAR_31
           ,COL_CHAR_32
           ,COL_CHAR_33
           ,COL_CHAR_34
           ,COL_CHAR_35
           ,COL_CHAR_36
           ,COL_CHAR_37
           ,COL_CHAR_38
           ,COL_CHAR_39
           ,COL_CHAR_40
           ,COL_CHAR_41
           ,COL_CHAR_42
           ,COL_CHAR_43
           ,COL_CHAR_44
           ,COL_CHAR_45
           ,COL_CHAR_46
           ,COL_CHAR_47
           ,COL_CHAR_48
           ,COL_CHAR_49
           ,COL_CHAR_50
           ,COL_CHAR_51
           ,COL_CHAR_52
           ,COL_CHAR_53
           ,COL_CHAR_54
           ,COL_CHAR_55
           ,COL_CHAR_56
           ,COL_CHAR_57
           ,COL_CHAR_58
           ,COL_CHAR_59
           ,COL_CHAR_60
           ,COL_CHAR_61
           ,COL_CHAR_62
           ,COL_CHAR_71
           ,COL_CHAR_72
           ,COL_DATE_01
           ,COL_DATE_02
           ,COL_DATE_03
           ,COL_DATE_04
           ,COL_DATE_05
           ,COL_DATE_06
           ,COL_DATE_11
           ,COL_DATE_12
           ,CONTEXT
           ,ATTRIBUTE1
           ,ATTRIBUTE2
           ,ATTRIBUTE3
           ,ATTRIBUTE4
           ,ATTRIBUTE5
           ,ATTRIBUTE6
           ,ATTRIBUTE7
           ,ATTRIBUTE8
           ,ATTRIBUTE9
           ,ATTRIBUTE10
           ,ATTRIBUTE11
           ,ATTRIBUTE12
           ,ATTRIBUTE13
           ,ATTRIBUTE14
           ,ATTRIBUTE15
           ,CREATED_BY
           ,CREATION_DATE
           ,LAST_UPDATED_BY
           ,LAST_UPDATE_DATE
           ,LAST_UPDATE_LOGIN
           ,OBJECT_VERSION_NUMBER
           ,SECURITY_GROUP_ID
           )
           Values
           (
           l_archive_id_tbl(i),
           l_table_id,
           l_ver_label_hist_rec_tab.version_label_history_id(i),
           l_ver_label_hist_rec_tab.transaction_id(i),
           l_ver_label_hist_rec_tab.version_label_id(i),
           l_ver_label_hist_rec_tab.ver_created_by(i),
           l_ver_label_hist_rec_tab.ver_last_updated_by(i),
           l_ver_label_hist_rec_tab.ver_last_update_login(i),
           l_ver_label_hist_rec_tab.ver_object_version_number(i), -- obj_ver_num
           l_ver_label_hist_rec_tab.ver_security_group_id(i), -- sec_grp_id
           l_ver_label_hist_rec_tab.old_version_label(i),
           l_ver_label_hist_rec_tab.new_version_label(i),
           l_ver_label_hist_rec_tab.old_ver_description(i),
           l_ver_label_hist_rec_tab.new_ver_description(i),
           l_ver_label_hist_rec_tab.old_ver_context(i),
           l_ver_label_hist_rec_tab.new_ver_context(i),
           l_ver_label_hist_rec_tab.old_ver_attribute1(i),
           l_ver_label_hist_rec_tab.new_ver_attribute1(i),
           l_ver_label_hist_rec_tab.old_ver_attribute2(i),
           l_ver_label_hist_rec_tab.new_ver_attribute2(i),
           l_ver_label_hist_rec_tab.old_ver_attribute3(i),
           l_ver_label_hist_rec_tab.new_ver_attribute3(i),
           l_ver_label_hist_rec_tab.old_ver_attribute4(i),
           l_ver_label_hist_rec_tab.new_ver_attribute4(i),
           l_ver_label_hist_rec_tab.old_ver_attribute5(i),
           l_ver_label_hist_rec_tab.new_ver_attribute5(i),
           l_ver_label_hist_rec_tab.old_ver_attribute6(i),
           l_ver_label_hist_rec_tab.new_ver_attribute6(i),
           l_ver_label_hist_rec_tab.old_ver_attribute7(i),
           l_ver_label_hist_rec_tab.new_ver_attribute7(i),
           l_ver_label_hist_rec_tab.old_ver_attribute8(i),
           l_ver_label_hist_rec_tab.new_ver_attribute8(i),
           l_ver_label_hist_rec_tab.old_ver_attribute9(i),
           l_ver_label_hist_rec_tab.new_ver_attribute9(i),
           l_ver_label_hist_rec_tab.old_ver_attribute10(i),
           l_ver_label_hist_rec_tab.new_ver_attribute10(i),
           l_ver_label_hist_rec_tab.old_ver_attribute11(i),
           l_ver_label_hist_rec_tab.new_ver_attribute11(i),
           l_ver_label_hist_rec_tab.old_ver_attribute12(i),
           l_ver_label_hist_rec_tab.new_ver_attribute12(i),
           l_ver_label_hist_rec_tab.old_ver_attribute13(i),
           l_ver_label_hist_rec_tab.new_ver_attribute13(i),
           l_ver_label_hist_rec_tab.old_ver_attribute14(i),
           l_ver_label_hist_rec_tab.new_ver_attribute14(i),
           l_ver_label_hist_rec_tab.old_ver_attribute15(i),
           l_ver_label_hist_rec_tab.new_ver_attribute15(i),
           l_ver_label_hist_rec_tab.ver_full_dump_flag(i), --'N', dump_flag
           l_ver_label_hist_rec_tab.ver_migrated_flag(i), -- mig_flag
           l_ver_label_hist_rec_tab.old_ver_active_start_date(i),
           l_ver_label_hist_rec_tab.new_ver_active_start_date(i),
           l_ver_label_hist_rec_tab.old_ver_active_end_date(i),
           l_ver_label_hist_rec_tab.new_ver_active_end_date(i),
           l_ver_label_hist_rec_tab.old_date_time_stamp(i),
           l_ver_label_hist_rec_tab.new_date_time_stamp(i),
           l_ver_label_hist_rec_tab.ver_creation_date(i),
           l_ver_label_hist_rec_tab.ver_last_update_date(i),
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           l_user_id,
           sysdate,
           l_user_id,
           sysdate,
           l_login_id,
           1,
           null
           );
Line: 4926

              Delete From CSI_I_VERSION_LABELS_H
              Where version_label_history_id = l_ver_label_hist_rec_tab.version_label_history_id(i);
Line: 4987

    Select csh.*
    From   CSI_II_RELATIONSHIPS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between from_trans and to_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 5002

      Select object_id
      Into   l_table_id
      From   csi_object_dictionary
      Where  object_name = 'CSI_II_RELATIONSHIPS_H';
Line: 5014

      Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
      Into   v_batch
      From   dual;
Line: 5034

      l_rel_hist_rec_tab.relationship_history_id.DELETE;
Line: 5035

      l_rel_hist_rec_tab.relationship_id.DELETE;
Line: 5036

      l_rel_hist_rec_tab.transaction_id.DELETE;
Line: 5037

      l_rel_hist_rec_tab.old_subject_id.DELETE;
Line: 5038

      l_rel_hist_rec_tab.new_subject_id.DELETE;
Line: 5039

      l_rel_hist_rec_tab.old_position_reference.DELETE;
Line: 5040

      l_rel_hist_rec_tab.new_position_reference.DELETE;
Line: 5041

      l_rel_hist_rec_tab.old_rel_active_start_date.DELETE;
Line: 5042

      l_rel_hist_rec_tab.new_rel_active_start_date.DELETE;
Line: 5043

      l_rel_hist_rec_tab.old_rel_active_end_date.DELETE;
Line: 5044

      l_rel_hist_rec_tab.new_rel_active_end_date.DELETE;
Line: 5045

      l_rel_hist_rec_tab.old_mandatory_flag.DELETE;
Line: 5046

      l_rel_hist_rec_tab.new_mandatory_flag.DELETE;
Line: 5047

      l_rel_hist_rec_tab.old_rel_context.DELETE;
Line: 5048

      l_rel_hist_rec_tab.new_rel_context.DELETE;
Line: 5049

      l_rel_hist_rec_tab.old_rel_attribute1.DELETE;
Line: 5050

      l_rel_hist_rec_tab.new_rel_attribute1.DELETE;
Line: 5051

      l_rel_hist_rec_tab.old_rel_attribute2.DELETE;
Line: 5052

      l_rel_hist_rec_tab.new_rel_attribute2.DELETE;
Line: 5053

      l_rel_hist_rec_tab.old_rel_attribute3.DELETE;
Line: 5054

      l_rel_hist_rec_tab.new_rel_attribute3.DELETE;
Line: 5055

      l_rel_hist_rec_tab.old_rel_attribute4.DELETE;
Line: 5056

      l_rel_hist_rec_tab.new_rel_attribute4.DELETE;
Line: 5057

      l_rel_hist_rec_tab.old_rel_attribute5.DELETE;
Line: 5058

      l_rel_hist_rec_tab.new_rel_attribute5.DELETE;
Line: 5059

      l_rel_hist_rec_tab.old_rel_attribute6.DELETE;
Line: 5060

      l_rel_hist_rec_tab.new_rel_attribute6.DELETE;
Line: 5061

      l_rel_hist_rec_tab.old_rel_attribute7.DELETE;
Line: 5062

      l_rel_hist_rec_tab.new_rel_attribute7.DELETE;
Line: 5063

      l_rel_hist_rec_tab.old_rel_attribute8.DELETE;
Line: 5064

      l_rel_hist_rec_tab.new_rel_attribute8.DELETE;
Line: 5065

      l_rel_hist_rec_tab.old_rel_attribute9.DELETE;
Line: 5066

      l_rel_hist_rec_tab.new_rel_attribute9.DELETE;
Line: 5067

      l_rel_hist_rec_tab.old_rel_attribute10.DELETE;
Line: 5068

      l_rel_hist_rec_tab.new_rel_attribute10.DELETE;
Line: 5069

      l_rel_hist_rec_tab.old_rel_attribute11.DELETE;
Line: 5070

      l_rel_hist_rec_tab.new_rel_attribute11.DELETE;
Line: 5071

      l_rel_hist_rec_tab.old_rel_attribute12.DELETE;
Line: 5072

      l_rel_hist_rec_tab.new_rel_attribute12.DELETE;
Line: 5073

      l_rel_hist_rec_tab.old_rel_attribute13.DELETE;
Line: 5074

      l_rel_hist_rec_tab.new_rel_attribute13.DELETE;
Line: 5075

      l_rel_hist_rec_tab.old_rel_attribute14.DELETE;
Line: 5076

      l_rel_hist_rec_tab.new_rel_attribute14.DELETE;
Line: 5077

      l_rel_hist_rec_tab.old_rel_attribute15.DELETE;
Line: 5078

      l_rel_hist_rec_tab.new_rel_attribute15.DELETE;
Line: 5079

      l_rel_hist_rec_tab.rel_full_dump_flag.DELETE;
Line: 5080

      l_rel_hist_rec_tab.rel_created_by.DELETE;
Line: 5081

      l_rel_hist_rec_tab.rel_creation_date.DELETE;
Line: 5082

      l_rel_hist_rec_tab.rel_last_updated_by.DELETE;
Line: 5083

      l_rel_hist_rec_tab.rel_last_update_date.DELETE;
Line: 5084

      l_rel_hist_rec_tab.rel_last_update_login.DELETE;
Line: 5085

      l_rel_hist_rec_tab.rel_object_version_number.DELETE;
Line: 5086

      l_rel_hist_rec_tab.rel_security_group_id.DELETE;
Line: 5087

      l_rel_hist_rec_tab.rel_migrated_flag.DELETE;
Line: 5095

      Select csi_history_archive_s.Nextval
      Into l_archive_id_tbl(l_ctr)
      From dual;
Line: 5147

      l_rel_hist_rec_tab.rel_last_updated_by(l_ctr)            :=  i.last_updated_by;
Line: 5148

      l_rel_hist_rec_tab.rel_last_update_date(l_ctr)           :=  i.last_update_date;
Line: 5149

      l_rel_hist_rec_tab.rel_last_update_login(l_ctr)          :=  i.last_update_login;
Line: 5169

         Insert Into CSI_HISTORY_ARCHIVE
         (
            HISTORY_ARCHIVE_ID
           ,OBJECT_ID
           ,ENTITY_HISTORY_ID
           ,TRANSACTION_ID
           ,ENTITY_ID
           ,COL_NUM_01
           ,COL_NUM_02
           ,COL_NUM_37
           ,COL_NUM_38
           ,COL_NUM_39
           ,COL_NUM_40
           ,COL_NUM_41
           ,COL_CHAR_01
           ,COL_CHAR_02
           ,COL_CHAR_03
           ,COL_CHAR_04
           ,COL_CHAR_31
           ,COL_CHAR_32
           ,COL_CHAR_33
           ,COL_CHAR_34
           ,COL_CHAR_35
           ,COL_CHAR_36
           ,COL_CHAR_37
           ,COL_CHAR_38
           ,COL_CHAR_39
           ,COL_CHAR_40
           ,COL_CHAR_41
           ,COL_CHAR_42
           ,COL_CHAR_43
           ,COL_CHAR_44
           ,COL_CHAR_45
           ,COL_CHAR_46
           ,COL_CHAR_47
           ,COL_CHAR_48
           ,COL_CHAR_49
           ,COL_CHAR_50
           ,COL_CHAR_51
           ,COL_CHAR_52
           ,COL_CHAR_53
           ,COL_CHAR_54
           ,COL_CHAR_55
           ,COL_CHAR_56
           ,COL_CHAR_57
           ,COL_CHAR_58
           ,COL_CHAR_59
           ,COL_CHAR_60
           ,COL_CHAR_61
           ,COL_CHAR_62
           ,COL_CHAR_71
           ,COL_CHAR_72
           ,COL_DATE_01
           ,COL_DATE_02
           ,COL_DATE_03
           ,COL_DATE_04
           ,COL_DATE_11
           ,COL_DATE_12
           ,CONTEXT
           ,ATTRIBUTE1
           ,ATTRIBUTE2
           ,ATTRIBUTE3
           ,ATTRIBUTE4
           ,ATTRIBUTE5
           ,ATTRIBUTE6
           ,ATTRIBUTE7
           ,ATTRIBUTE8
           ,ATTRIBUTE9
           ,ATTRIBUTE10
           ,ATTRIBUTE11
           ,ATTRIBUTE12
           ,ATTRIBUTE13
           ,ATTRIBUTE14
           ,ATTRIBUTE15
           ,CREATED_BY
           ,CREATION_DATE
           ,LAST_UPDATED_BY
           ,LAST_UPDATE_DATE
           ,LAST_UPDATE_LOGIN
           ,OBJECT_VERSION_NUMBER
           ,SECURITY_GROUP_ID
           )
           Values
           (
           l_archive_id_tbl(i),
           l_table_id,
           l_rel_hist_rec_tab.relationship_history_id(i),
           l_rel_hist_rec_tab.transaction_id(i),
           l_rel_hist_rec_tab.relationship_id(i),
           l_rel_hist_rec_tab.old_subject_id(i),
           l_rel_hist_rec_tab.new_subject_id(i),
           l_rel_hist_rec_tab.rel_created_by(i),
           l_rel_hist_rec_tab.rel_last_updated_by(i),
           l_rel_hist_rec_tab.rel_last_update_login(i),
           l_rel_hist_rec_tab.rel_object_version_number(i), -- obj_ver_num
           l_rel_hist_rec_tab.rel_security_group_id(i), -- sec_grp_id
           l_rel_hist_rec_tab.old_position_reference(i),
           l_rel_hist_rec_tab.new_position_reference(i),
           l_rel_hist_rec_tab.old_mandatory_flag(i),
           l_rel_hist_rec_tab.new_mandatory_flag(i),
           l_rel_hist_rec_tab.old_rel_context(i),
           l_rel_hist_rec_tab.new_rel_context(i),
           l_rel_hist_rec_tab.old_rel_attribute1(i),
           l_rel_hist_rec_tab.new_rel_attribute1(i),
           l_rel_hist_rec_tab.old_rel_attribute2(i),
           l_rel_hist_rec_tab.new_rel_attribute2(i),
           l_rel_hist_rec_tab.old_rel_attribute3(i),
           l_rel_hist_rec_tab.new_rel_attribute3(i),
           l_rel_hist_rec_tab.old_rel_attribute4(i),
           l_rel_hist_rec_tab.new_rel_attribute4(i),
           l_rel_hist_rec_tab.old_rel_attribute5(i),
           l_rel_hist_rec_tab.new_rel_attribute5(i),
           l_rel_hist_rec_tab.old_rel_attribute6(i),
           l_rel_hist_rec_tab.new_rel_attribute6(i),
           l_rel_hist_rec_tab.old_rel_attribute7(i),
           l_rel_hist_rec_tab.new_rel_attribute7(i),
           l_rel_hist_rec_tab.old_rel_attribute8(i),
           l_rel_hist_rec_tab.new_rel_attribute8(i),
           l_rel_hist_rec_tab.old_rel_attribute9(i),
           l_rel_hist_rec_tab.new_rel_attribute9(i),
           l_rel_hist_rec_tab.old_rel_attribute10(i),
           l_rel_hist_rec_tab.new_rel_attribute10(i),
           l_rel_hist_rec_tab.old_rel_attribute11(i),
           l_rel_hist_rec_tab.new_rel_attribute11(i),
           l_rel_hist_rec_tab.old_rel_attribute12(i),
           l_rel_hist_rec_tab.new_rel_attribute12(i),
           l_rel_hist_rec_tab.old_rel_attribute13(i),
           l_rel_hist_rec_tab.new_rel_attribute13(i),
           l_rel_hist_rec_tab.old_rel_attribute14(i),
           l_rel_hist_rec_tab.new_rel_attribute14(i),
           l_rel_hist_rec_tab.old_rel_attribute15(i),
           l_rel_hist_rec_tab.new_rel_attribute15(i),
           l_rel_hist_rec_tab.rel_full_dump_flag(i), --'N', dump_flag
           l_rel_hist_rec_tab.rel_migrated_flag(i), -- mig_flag
           l_rel_hist_rec_tab.old_rel_active_start_date(i),
           l_rel_hist_rec_tab.new_rel_active_start_date(i),
           l_rel_hist_rec_tab.old_rel_active_end_date(i),
           l_rel_hist_rec_tab.new_rel_active_end_date(i),
           l_rel_hist_rec_tab.rel_creation_date(i),
           l_rel_hist_rec_tab.rel_last_update_date(i),
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           l_user_id,
           sysdate,
           l_user_id,
           sysdate,
           l_login_id,
           1,
           null
           );
Line: 5338

               Delete From CSI_II_RELATIONSHIPS_H
               Where relationship_history_id = l_rel_hist_rec_tab.relationship_history_id(i);
Line: 5398

    Select csh.*
    From   CSI_SYSTEMS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between from_trans and to_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 5413

      Select object_id
      Into   l_table_id
      From   csi_object_dictionary
      Where  object_name = 'CSI_SYSTEMS_H';
Line: 5425

      Select fnd_profile.value('CSI_TXN_HISTORY_PURGE_BATCH_SIZE')
      Into   v_batch
      From   dual;
Line: 5445

      l_sys_hist_rec_tab.system_history_id.DELETE;
Line: 5446

      l_sys_hist_rec_tab.system_id.DELETE;
Line: 5447

      l_sys_hist_rec_tab.transaction_id.DELETE;
Line: 5448

      l_sys_hist_rec_tab.old_customer_id.DELETE;
Line: 5449

      l_sys_hist_rec_tab.new_customer_id.DELETE;
Line: 5450

      l_sys_hist_rec_tab.old_system_type_code.DELETE;
Line: 5451

      l_sys_hist_rec_tab.new_system_type_code.DELETE;
Line: 5452

      l_sys_hist_rec_tab.old_system_number.DELETE;
Line: 5453

      l_sys_hist_rec_tab.new_system_number.DELETE;
Line: 5454

      l_sys_hist_rec_tab.old_parent_system_id.DELETE;
Line: 5455

      l_sys_hist_rec_tab.new_parent_system_id.DELETE;
Line: 5456

      l_sys_hist_rec_tab.old_ship_to_contact_id.DELETE;
Line: 5457

      l_sys_hist_rec_tab.new_ship_to_contact_id.DELETE;
Line: 5458

      l_sys_hist_rec_tab.old_bill_to_contact_id.DELETE;
Line: 5459

      l_sys_hist_rec_tab.new_bill_to_contact_id.DELETE;
Line: 5460

      l_sys_hist_rec_tab.old_technical_contact_id.DELETE;
Line: 5461

      l_sys_hist_rec_tab.new_technical_contact_id.DELETE;
Line: 5462

      l_sys_hist_rec_tab.old_service_admin_contact_id.DELETE;
Line: 5463

      l_sys_hist_rec_tab.new_service_admin_contact_id.DELETE;
Line: 5464

      l_sys_hist_rec_tab.old_ship_to_site_use_id.DELETE;
Line: 5465

      l_sys_hist_rec_tab.new_ship_to_site_use_id.DELETE;
Line: 5466

      l_sys_hist_rec_tab.old_install_site_use_id.DELETE;
Line: 5467

      l_sys_hist_rec_tab.new_install_site_use_id.DELETE;
Line: 5468

      l_sys_hist_rec_tab.old_bill_to_site_use_id.DELETE;
Line: 5469

      l_sys_hist_rec_tab.new_bill_to_site_use_id.DELETE;
Line: 5470

      l_sys_hist_rec_tab.old_coterminate_day_month.DELETE;
Line: 5471

      l_sys_hist_rec_tab.new_coterminate_day_month.DELETE;
Line: 5472

      l_sys_hist_rec_tab.old_sys_active_start_date.DELETE;
Line: 5473

      l_sys_hist_rec_tab.new_sys_active_start_date.DELETE;
Line: 5474

      l_sys_hist_rec_tab.old_sys_active_end_date.DELETE;
Line: 5475

      l_sys_hist_rec_tab.new_sys_active_end_date.DELETE;
Line: 5476

      l_sys_hist_rec_tab.old_autocreated_from_system.DELETE;
Line: 5477

      l_sys_hist_rec_tab.new_autocreated_from_system.DELETE;
Line: 5478

      l_sys_hist_rec_tab.old_config_system_type.DELETE;
Line: 5479

      l_sys_hist_rec_tab.new_config_system_type.DELETE;
Line: 5480

      l_sys_hist_rec_tab.old_name.DELETE;
Line: 5481

      l_sys_hist_rec_tab.new_name.DELETE;
Line: 5482

      l_sys_hist_rec_tab.old_sys_description.DELETE;
Line: 5483

      l_sys_hist_rec_tab.new_sys_description.DELETE;
Line: 5484

      l_sys_hist_rec_tab.old_sys_context.DELETE;
Line: 5485

      l_sys_hist_rec_tab.new_sys_context.DELETE;
Line: 5486

      l_sys_hist_rec_tab.old_sys_attribute1.DELETE;
Line: 5487

      l_sys_hist_rec_tab.new_sys_attribute1.DELETE;
Line: 5488

      l_sys_hist_rec_tab.old_sys_attribute2.DELETE;
Line: 5489

      l_sys_hist_rec_tab.new_sys_attribute2.DELETE;
Line: 5490

      l_sys_hist_rec_tab.old_sys_attribute3.DELETE;
Line: 5491

      l_sys_hist_rec_tab.new_sys_attribute3.DELETE;
Line: 5492

      l_sys_hist_rec_tab.old_sys_attribute4.DELETE;
Line: 5493

      l_sys_hist_rec_tab.new_sys_attribute4.DELETE;
Line: 5494

      l_sys_hist_rec_tab.old_sys_attribute5.DELETE;
Line: 5495

      l_sys_hist_rec_tab.new_sys_attribute5.DELETE;
Line: 5496

      l_sys_hist_rec_tab.old_sys_attribute6.DELETE;
Line: 5497

      l_sys_hist_rec_tab.new_sys_attribute6.DELETE;
Line: 5498

      l_sys_hist_rec_tab.old_sys_attribute7.DELETE;
Line: 5499

      l_sys_hist_rec_tab.new_sys_attribute7.DELETE;
Line: 5500

      l_sys_hist_rec_tab.old_sys_attribute8.DELETE;
Line: 5501

      l_sys_hist_rec_tab.new_sys_attribute8.DELETE;
Line: 5502

      l_sys_hist_rec_tab.old_sys_attribute9.DELETE;
Line: 5503

      l_sys_hist_rec_tab.new_sys_attribute9.DELETE;
Line: 5504

      l_sys_hist_rec_tab.old_sys_attribute10.DELETE;
Line: 5505

      l_sys_hist_rec_tab.new_sys_attribute10.DELETE;
Line: 5506

      l_sys_hist_rec_tab.old_sys_attribute11.DELETE;
Line: 5507

      l_sys_hist_rec_tab.new_sys_attribute11.DELETE;
Line: 5508

      l_sys_hist_rec_tab.old_sys_attribute12.DELETE;
Line: 5509

      l_sys_hist_rec_tab.new_sys_attribute12.DELETE;
Line: 5510

      l_sys_hist_rec_tab.old_sys_attribute13.DELETE;
Line: 5511

      l_sys_hist_rec_tab.new_sys_attribute13.DELETE;
Line: 5512

      l_sys_hist_rec_tab.old_sys_attribute14.DELETE;
Line: 5513

      l_sys_hist_rec_tab.new_sys_attribute14.DELETE;
Line: 5514

      l_sys_hist_rec_tab.old_sys_attribute15.DELETE;
Line: 5515

      l_sys_hist_rec_tab.new_sys_attribute15.DELETE;
Line: 5516

      l_sys_hist_rec_tab.sys_full_dump_flag.DELETE;
Line: 5517

      l_sys_hist_rec_tab.sys_created_by.DELETE;
Line: 5518

      l_sys_hist_rec_tab.sys_creation_date.DELETE;
Line: 5519

      l_sys_hist_rec_tab.sys_last_updated_by.DELETE;
Line: 5520

      l_sys_hist_rec_tab.sys_last_update_date.DELETE;
Line: 5521

      l_sys_hist_rec_tab.sys_last_update_login.DELETE;
Line: 5522

      l_sys_hist_rec_tab.sys_object_version_number.DELETE;
Line: 5523

      l_sys_hist_rec_tab.sys_security_group_id.DELETE;
Line: 5524

      l_sys_hist_rec_tab.sys_migrated_flag.DELETE;
Line: 5525

      l_sys_hist_rec_tab.old_sys_operating_unit_id.DELETE;
Line: 5526

      l_sys_hist_rec_tab.new_sys_operating_unit_id.DELETE;
Line: 5534

      Select csi_history_archive_s.Nextval
      Into l_archive_id_tbl(l_ctr)
      From dual;
Line: 5612

      l_sys_hist_rec_tab.sys_last_updated_by(l_ctr)            :=  i.last_updated_by;
Line: 5613

      l_sys_hist_rec_tab.sys_last_update_date(l_ctr)           :=  i.last_update_date;
Line: 5614

      l_sys_hist_rec_tab.sys_last_update_login(l_ctr)          :=  i.last_update_login;
Line: 5636

         Insert Into CSI_HISTORY_ARCHIVE
         (
            HISTORY_ARCHIVE_ID
           ,OBJECT_ID
           ,ENTITY_HISTORY_ID
           ,TRANSACTION_ID
           ,ENTITY_ID
           ,COL_NUM_01
           ,COL_NUM_02
           ,COL_NUM_03
           ,COL_NUM_04
           ,COL_NUM_05
           ,COL_NUM_06
           ,COL_NUM_07
           ,COL_NUM_08
           ,COL_NUM_09
           ,COL_NUM_10
           ,COL_NUM_11
           ,COL_NUM_12
           ,COL_NUM_13
           ,COL_NUM_14
           ,COL_NUM_15
           ,COL_NUM_16
           ,COL_NUM_17
           ,COL_NUM_18
           ,COL_NUM_19
           ,COL_NUM_20
           ,COL_NUM_21
           ,COL_NUM_22
           ,COL_NUM_37
           ,COL_NUM_38
           ,COL_NUM_39
           ,COL_NUM_40
           ,COL_NUM_41
           ,COL_CHAR_01
           ,COL_CHAR_02
           ,COL_CHAR_03
           ,COL_CHAR_04
           ,COL_CHAR_05
           ,COL_CHAR_06
           ,COL_CHAR_07
           ,COL_CHAR_08
           ,COL_CHAR_09
           ,COL_CHAR_10
           ,COL_CHAR_11
           ,COL_CHAR_12
           ,COL_CHAR_31
           ,COL_CHAR_32
           ,COL_CHAR_33
           ,COL_CHAR_34
           ,COL_CHAR_35
           ,COL_CHAR_36
           ,COL_CHAR_37
           ,COL_CHAR_38
           ,COL_CHAR_39
           ,COL_CHAR_40
           ,COL_CHAR_41
           ,COL_CHAR_42
           ,COL_CHAR_43
           ,COL_CHAR_44
           ,COL_CHAR_45
           ,COL_CHAR_46
           ,COL_CHAR_47
           ,COL_CHAR_48
           ,COL_CHAR_49
           ,COL_CHAR_50
           ,COL_CHAR_51
           ,COL_CHAR_52
           ,COL_CHAR_53
           ,COL_CHAR_54
           ,COL_CHAR_55
           ,COL_CHAR_56
           ,COL_CHAR_57
           ,COL_CHAR_58
           ,COL_CHAR_59
           ,COL_CHAR_60
           ,COL_CHAR_61
           ,COL_CHAR_62
           ,COL_CHAR_71
           ,COL_CHAR_72
           ,COL_DATE_01
           ,COL_DATE_02
           ,COL_DATE_03
           ,COL_DATE_04
           ,COL_DATE_11
           ,COL_DATE_12
           ,CONTEXT
           ,ATTRIBUTE1
           ,ATTRIBUTE2
           ,ATTRIBUTE3
           ,ATTRIBUTE4
           ,ATTRIBUTE5
           ,ATTRIBUTE6
           ,ATTRIBUTE7
           ,ATTRIBUTE8
           ,ATTRIBUTE9
           ,ATTRIBUTE10
           ,ATTRIBUTE11
           ,ATTRIBUTE12
           ,ATTRIBUTE13
           ,ATTRIBUTE14
           ,ATTRIBUTE15
           ,CREATED_BY
           ,CREATION_DATE
           ,LAST_UPDATED_BY
           ,LAST_UPDATE_DATE
           ,LAST_UPDATE_LOGIN
           ,OBJECT_VERSION_NUMBER
           ,SECURITY_GROUP_ID
           )
           Values
           (
           l_archive_id_tbl(i),
           l_table_id,
           l_sys_hist_rec_tab.system_history_id(i),
           l_sys_hist_rec_tab.transaction_id(i),
           l_sys_hist_rec_tab.system_id(i),
           l_sys_hist_rec_tab.old_customer_id(i),
           l_sys_hist_rec_tab.new_customer_id(i),
           l_sys_hist_rec_tab.old_parent_system_id(i),
           l_sys_hist_rec_tab.new_parent_system_id(i),
           l_sys_hist_rec_tab.old_bill_to_contact_id(i),
           l_sys_hist_rec_tab.new_bill_to_contact_id(i),
           l_sys_hist_rec_tab.old_ship_to_contact_id(i),
           l_sys_hist_rec_tab.new_ship_to_contact_id(i),
           l_sys_hist_rec_tab.old_technical_contact_id(i),
           l_sys_hist_rec_tab.new_technical_contact_id(i),
           l_sys_hist_rec_tab.old_service_admin_contact_id(i),
           l_sys_hist_rec_tab.new_service_admin_contact_id(i),
           l_sys_hist_rec_tab.old_ship_to_site_use_id(i),
           l_sys_hist_rec_tab.new_ship_to_site_use_id(i),
           l_sys_hist_rec_tab.old_install_site_use_id(i),
           l_sys_hist_rec_tab.new_install_site_use_id(i),
           l_sys_hist_rec_tab.old_bill_to_site_use_id(i),
           l_sys_hist_rec_tab.new_bill_to_site_use_id(i),
           l_sys_hist_rec_tab.old_autocreated_from_system(i),
           l_sys_hist_rec_tab.new_autocreated_from_system(i),
           l_sys_hist_rec_tab.old_sys_operating_unit_id(i),
           l_sys_hist_rec_tab.new_sys_operating_unit_id(i),
           l_sys_hist_rec_tab.sys_created_by(i),
           l_sys_hist_rec_tab.sys_last_updated_by(i),
           l_sys_hist_rec_tab.sys_last_update_login(i),
	   l_sys_hist_rec_tab.sys_object_version_number(i), -- obj_ver_num
           l_sys_hist_rec_tab.sys_security_group_id(i), -- sec_grp_id
           l_sys_hist_rec_tab.old_system_type_code(i),
           l_sys_hist_rec_tab.new_system_type_code(i),
           l_sys_hist_rec_tab.old_system_number(i),
           l_sys_hist_rec_tab.new_system_number(i),
           l_sys_hist_rec_tab.old_coterminate_day_month(i),
           l_sys_hist_rec_tab.new_coterminate_day_month(i),
           l_sys_hist_rec_tab.old_config_system_type(i),
           l_sys_hist_rec_tab.new_config_system_type(i),
           l_sys_hist_rec_tab.old_name(i),
           l_sys_hist_rec_tab.new_name(i),
           l_sys_hist_rec_tab.old_sys_description(i),
           l_sys_hist_rec_tab.new_sys_description(i),
           l_sys_hist_rec_tab.old_sys_context(i),
           l_sys_hist_rec_tab.new_sys_context(i),
           l_sys_hist_rec_tab.old_sys_attribute1(i),
           l_sys_hist_rec_tab.new_sys_attribute1(i),
           l_sys_hist_rec_tab.old_sys_attribute2(i),
           l_sys_hist_rec_tab.new_sys_attribute2(i),
           l_sys_hist_rec_tab.old_sys_attribute3(i),
           l_sys_hist_rec_tab.new_sys_attribute3(i),
           l_sys_hist_rec_tab.old_sys_attribute4(i),
           l_sys_hist_rec_tab.new_sys_attribute4(i),
           l_sys_hist_rec_tab.old_sys_attribute5(i),
           l_sys_hist_rec_tab.new_sys_attribute5(i),
           l_sys_hist_rec_tab.old_sys_attribute6(i),
           l_sys_hist_rec_tab.new_sys_attribute6(i),
           l_sys_hist_rec_tab.old_sys_attribute7(i),
           l_sys_hist_rec_tab.new_sys_attribute7(i),
           l_sys_hist_rec_tab.old_sys_attribute8(i),
           l_sys_hist_rec_tab.new_sys_attribute8(i),
           l_sys_hist_rec_tab.old_sys_attribute9(i),
           l_sys_hist_rec_tab.new_sys_attribute9(i),
           l_sys_hist_rec_tab.old_sys_attribute10(i),
           l_sys_hist_rec_tab.new_sys_attribute10(i),
           l_sys_hist_rec_tab.old_sys_attribute11(i),
           l_sys_hist_rec_tab.new_sys_attribute11(i),
           l_sys_hist_rec_tab.old_sys_attribute12(i),
           l_sys_hist_rec_tab.new_sys_attribute12(i),
           l_sys_hist_rec_tab.old_sys_attribute13(i),
           l_sys_hist_rec_tab.new_sys_attribute13(i),
           l_sys_hist_rec_tab.old_sys_attribute14(i),
           l_sys_hist_rec_tab.new_sys_attribute14(i),
           l_sys_hist_rec_tab.old_sys_attribute15(i),
           l_sys_hist_rec_tab.new_sys_attribute15(i),
           l_sys_hist_rec_tab.sys_full_dump_flag(i), --'N', dump_flag
           l_sys_hist_rec_tab.sys_migrated_flag(i), -- mig_flag
           l_sys_hist_rec_tab.old_sys_active_start_date(i),
           l_sys_hist_rec_tab.new_sys_active_start_date(i),
           l_sys_hist_rec_tab.old_sys_active_end_date(i),
           l_sys_hist_rec_tab.new_sys_active_end_date(i),
           l_sys_hist_rec_tab.sys_creation_date(i),
           l_sys_hist_rec_tab.sys_last_update_date(i),
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           null,
           l_user_id,
           sysdate,
           l_user_id,
           sysdate,
           l_login_id,
           1,
           null
           );
Line: 5861

               Delete From CSI_SYSTEMS_H
               Where system_history_id = l_sys_hist_rec_tab.system_history_id(i);
Line: 5915

    Select COUNT(*)
    Into   l_temp
    From   CSI_ITEM_INSTANCES_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between From_trans and To_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 5929

    Select COUNT(*)
    Into   l_temp1
    From   CSI_I_PARTIES_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between From_trans and To_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 5943

    Select COUNT(*)
    Into   l_temp2
    From   CSI_IP_ACCOUNTS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between From_trans and To_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 5957

    Select COUNT(*)
    Into   l_temp3
    From   CSI_I_ORG_ASSIGNMENTS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between From_trans and To_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 5971

    Select COUNT(*)
    Into   l_temp4
    From   CSI_IEA_VALUES_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between From_trans and To_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 5985

    Select COUNT(*)
    Into   l_temp5
    From   CSI_I_PRICING_ATTRIBS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between From_trans and To_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 5999

    Select COUNT(*)
    Into   l_temp6
    From   CSI_I_ASSETS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between From_trans and To_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 6013

    Select COUNT(*)
    Into   l_temp7
    From   CSI_I_VERSION_LABELS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between From_trans and To_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 6027

    Select COUNT(*)
    Into   l_temp8
    From   CSI_II_RELATIONSHIPS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between From_trans and To_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;
Line: 6041

    Select COUNT(*)
    Into   l_temp9
    From   CSI_SYSTEMS_H csh,
           CSI_TRANSACTIONS csit
    Where  csit.transaction_id between From_trans and To_trans
    And    csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
    And    csh.transaction_id = csit.transaction_id;