DBA Data[Home] [Help]

APPS.GHG_EMISSION_RATES_PKG dependencies on GHG_TRANSACTIONS_PKG

Line 214: set emission_quantity = GHG_transactions_pkg.get_emission_total(x_emission_id)

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,

Line 215: , energy_quantity = GHG_transactions_pkg.get_energy_total(x_emission_id)

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)