210:
211: end loop;
212:
213: update GHG_transactions_all
214: set emission_quantity = GHG_transactions_pkg.get_emission_total(x_emission_id)
215: , energy_quantity = GHG_transactions_pkg.get_energy_total(x_emission_id)
216: , emission_SCOPE_LOOKUP_CODE =
217: (SELECT decode(emission_SCOPE_LOOKUP_CODE,
218: '-99999', SCOPE_LOOKUP_CODE,
211: end loop;
212:
213: update GHG_transactions_all
214: set emission_quantity = GHG_transactions_pkg.get_emission_total(x_emission_id)
215: , energy_quantity = GHG_transactions_pkg.get_energy_total(x_emission_id)
216: , emission_SCOPE_LOOKUP_CODE =
217: (SELECT decode(emission_SCOPE_LOOKUP_CODE,
218: '-99999', SCOPE_LOOKUP_CODE,
219: emission_SCOPE_LOOKUP_CODE)