APPS.CSE_FA_INTEGRATION_GRP SQL Statements

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

Line: 14

      SELECT 'Y'
      FROM   csi_install_parameters
      WHERE  freeze_flag = 'Y';

Line: 55

      SELECT transaction_id
      FROM   csi_transactions
      WHERE  transaction_type_id = 123
      AND    source_line_ref     = 'MASS_ADD_ID'
      AND    source_line_ref_id  = p_mass_addition_id
      ORDER by source_transaction_date desc;

Line: 117

  PROCEDURE update_inst_asset(
    px_csi_txn_rec      IN OUT nocopy csi_datastructures_pub.transaction_rec,
    px_inst_asset_rec   IN OUT nocopy csi_datastructures_pub.instance_asset_rec,
    x_return_status        OUT nocopy varchar2)
  IS

    l_lookup_tbl           csi_asset_pvt.lookup_tbl;

Line: 138

    csi_asset_pvt.update_instance_asset (
      p_api_version         => 1.0,
      p_commit              => fnd_api.g_false,
      p_init_msg_list       => fnd_api.g_true,
      p_validation_level    => fnd_api.g_valid_level_full,
      p_instance_asset_rec  => px_inst_asset_rec,
      p_txn_rec             => px_csi_txn_rec,
      x_return_status       => l_return_status,
      x_msg_count           => l_msg_count,
      x_msg_data            => l_msg_data,
      p_lookup_tbl          => l_lookup_tbl,
      p_asset_count_rec     => l_asset_count_rec,
      p_asset_id_tbl        => l_asset_id_tbl,
      p_asset_loc_tbl       => l_asset_loc_tbl);

Line: 160

  END update_inst_asset;

Line: 185

      SELECT cia.instance_asset_id,
             cia.asset_quantity,
             cia.instance_id,
             cia.object_version_number,
             cii.inventory_item_id,
             cii.serial_number
      FROM   csi_i_assets cia,
             csi_item_instances cii
      WHERE  cia.fa_mass_addition_id = p_mass_addition_id
      AND    cii.instance_id         = cia.instance_id;

Line: 197

      SELECT pei.expenditure_item_id,
             pei.orig_transaction_reference txn_ref
      FROM   pa_expenditure_items_all      pei,
             pa_project_asset_line_details ppald,
             pa_project_asset_lines_all    ppal
      WHERE  ppal.project_asset_line_id         = p_project_asset_line_id
      AND    ppald.project_asset_line_detail_id = ppal.project_asset_line_detail_id
      AND    pei.expenditure_item_id            = ppald.expenditure_item_id
      AND    pei.transaction_source             IN ('CSE_PO_RECEIPT','CSE_INV_ISSUE')
      AND    pei.net_zero_adjustment_flag         = 'N'
      AND   (pei.attribute8 is not null and pei.attribute9 is not null);

Line: 256

                  update_inst_asset (
                    px_csi_txn_rec     => l_csi_txn_rec,
                    px_inst_asset_rec  => l_inst_asset_rec,
                    x_return_status    => l_return_status);

Line: 314

                    l_inst_asset_rec.update_status     := cse_datastructures_pub.g_in_service;

Line: 341

                      update_inst_asset (
                        px_csi_txn_rec    => l_csi_txn_rec,
                        px_inst_asset_rec => l_inst_asset_rec,
                        x_return_status   => l_return_status);

Line: 473

      SELECT pei.expenditure_item_id,
             pei.orig_transaction_reference txn_ref,
             pei.attribute6 item,
             pei.attribute7 serial_number,
             pei.attribute8 location,
             pei.attribute9 asset_category,
             pei.attribute10 product_class,
             ppa.location_id,
             ppa.depreciation_expense_ccid expense_ccid,
             ppa.assigned_to_person_id     employee_id
      FROM   pa_expenditure_items_all      pei,
             pa_project_asset_line_details ppald,
             pa_project_asset_lines_all    ppal,
             pa_project_assets_all         ppa
      WHERE  ppal.project_asset_line_id         = p_project_asset_line_id
      AND    ppa.project_asset_id               = ppal.project_asset_id
      AND    ppald.project_asset_line_detail_id = ppal.project_asset_line_detail_id
      AND    pei.expenditure_item_id            = ppald.expenditure_item_id
      AND    pei.transaction_source             IN ('CSE_PO_RECEIPT','CSE_INV_ISSUE')
      AND    pei.net_zero_adjustment_flag       = 'N'
      AND   (pei.attribute8 is not null and pei.attribute9 is not null);

Line: 521

              SELECT current_units
              INTO   l_current_units
              FROM   fa_additions
              WHERE  asset_id = l_asset_id;

Line: 579

                l_txn_error_rec.error_stage          := cse_datastructures_pub.g_fa_update;