APPS.GHG_TRANSACTIONS_HISTORY_PKG SQL Statements

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

Line: 6

PROCEDURE insert_row (x_transaction_id NUMBER) IS

v_package          VARCHAR2(100);

Line: 14

  v_package := 'GHG_TRANSACTIONS_HISTORY_PKG.insert_row';

Line: 15

  v_debug_info := 'Inserting into GHG_TRANSACTIONS_HISTORY_ALL';

Line: 19

    SELECT MAX(transaction_version)
    INTO   v_transaction_version
    FROM   GHG_TRANSACTIONS_HISTORY_ALL
    WHERE  transaction_id = x_transaction_id;

Line: 33

  INSERT INTO GHG_TRANSACTIONS_HISTORY_ALL
             (txn_type_lookup_code,
              transaction_id,
              transaction_version,
              --emission_rate_id,
              ghg_organization_id,
              transaction_type_lookup_code,
              usage_quantity,
              unit_of_measure,
              uom_conversion,
              emission_quantity,
              energy_quantity,
              transaction_date_from,
              transaction_date_to,
              description,
              org_id,
              set_of_books_id,
              invoice_id,
              transaction_line_number,
              distribution_line_number,
              invoice_line_number,
              vendor_id,
              vendor_site_id,
              attribute1,
              attribute2,
              attribute3,
              attribute4,
              attribute5,
              attribute6,
              attribute7,
              attribute8,
              attribute9,
              attribute10,
              attribute11,
              attribute12,
              attribute13,
              attribute14,
              attribute15,
              attribute16,
              attribute17,
              attribute18,
              attribute19,
              attribute20,
              attribute_category,
              created_by,
              creation_date,
              last_updated_by,
              last_update_date,
              last_update_login,
              MEASUREMENT_CRITERIA)
  SELECT      xne.txn_type_lookup_code,
              xne.transaction_id,
              v_transaction_version,
              --xne.emission_rate_id,
              --xne.transaction_source_id,
              xne.ghg_organization_id,
              xne.transaction_type_lookup_code,
              xne.usage_quantity,
              xne.unit_of_measure,
              xne.uom_conversion,
              xne.emission_quantity,
              xne.energy_quantity,
              xne.transaction_date_from,
              xne.transaction_date_to,
              xne.description,
              xne.org_id,
              xne.set_of_books_id,
              xne.invoice_id,
              xne.transaction_line_number,
              xne.distribution_line_number,
              xne.invoice_line_number,
              xne.vendor_id,
              xne.vendor_site_id,
              xne.attribute1,
              xne.attribute2,
              xne.attribute3,
              xne.attribute4,
              xne.attribute5,
              xne.attribute6,
              xne.attribute7,
              xne.attribute8,
              xne.attribute9,
              xne.attribute10,
              xne.attribute11,
              xne.attribute12,
              xne.attribute13,
              xne.attribute14,
              xne.attribute15,
              xne.attribute16,
              xne.attribute17,
              xne.attribute18,
              xne.attribute19,
              xne.attribute20,
              xne.attribute_category,
              xne.created_by,
              xne.creation_date,
              xne.last_updated_by,
              xne.last_update_date,
              xne.last_update_login,
              MEASUREMENT_CRITERIA
  FROM  GHG_TRANSACTIONS_V xne
  WHERE xne.transaction_id = x_transaction_id;

Line: 146

END insert_row;