eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHG_EMISSION_RATES_PKG dependencies on FND_NUMBER

Line 836: vl_formula_contents := replace(vl_formula_contents, 'Q', fnd_number.NUMBER_TO_CANONICAL(x_quantity));

832: vl_ec := 0;
833: END;
834: -- Substritue Variables
835: -- Q
836: vl_formula_contents := replace(vl_formula_contents, 'Q', fnd_number.NUMBER_TO_CANONICAL(x_quantity));
837: -- EC
838: vl_formula_contents := replace(vl_formula_contents, 'EC', fnd_number.NUMBER_TO_CANONICAL(vl_ec));
839:
840: -- Insert energy row

Line 838: vl_formula_contents := replace(vl_formula_contents, 'EC', fnd_number.NUMBER_TO_CANONICAL(vl_ec));

834: -- Substritue Variables
835: -- Q
836: vl_formula_contents := replace(vl_formula_contents, 'Q', fnd_number.NUMBER_TO_CANONICAL(x_quantity));
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(

Line 856: vl_formula_contents_tmp := replace(vl_formula_contents, 'EF', fnd_number.NUMBER_TO_CANONICAL(gas_type.factor_value));

852:
853: -- For all Gas Types
854: for gas_type in per_gas loop
855:
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)