[Home] [Help]
78: BEGIN
79:
80: select count(*)
81: into v_row_count
82: from GHG_transaction_details_all
83: where source_combination_id = x_rate_id;
84:
85: if v_row_count > 1 THEN
86: RETURN TRUE;
137: fnd_global.user_id,
138: sysdate,
139: fnd_global.user_id,
140: fnd_global.conc_request_id
141: from ghg_transaction_details_all a
142: where a.transaction_id = x_emission_id;
143:
144: --End of Code--Added by neechand as per Bug 14741401 on 23rd jan 2013
145:
142: where a.transaction_id = x_emission_id;
143:
144: --End of Code--Added by neechand as per Bug 14741401 on 23rd jan 2013
145:
146: delete from GHG_transaction_details_all
147: where transaction_id = x_emission_id;
148:
149: -- dbms_output.put_line('Create Emissions:'||x_emission_id);
150:
837: -- EC
838: vl_formula_contents := replace(vl_formula_contents, 'EC', fnd_number.NUMBER_TO_CANONICAL(vl_ec));
839:
840: -- Insert energy row
841: insert into GHG_transaction_details_all (transaction_id,transaction_date,transaction_type,transaction_component_type,transaction_value,source_combination_id,org_id,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
842: values(
843: x_emission_id,
844: x_emission_date,
845: 'N',
856: vl_formula_contents_tmp := replace(vl_formula_contents, 'EF', fnd_number.NUMBER_TO_CANONICAL(gas_type.factor_value));
857:
858: EXECUTE IMMEDIATE vl_formula_contents_tmp INTO vl_co2e;
859:
860: insert into GHG_transaction_details_all (transaction_id,transaction_date,transaction_type,transaction_component_type,transaction_value,source_combination_id,org_id,created_by,creation_date,last_updated_by,last_update_date,last_update_login)
861: values(
862: x_emission_id,
863: x_emission_date,
864: gas_type.factor_type,