APPS.GHG_EMISSION_RATES_PKG dependencies on FND_PROFILE

Line 408: AND upper(end_user_column_name) = fnd_profile.value('GHG_FACTOR_BREAK_REGION');

404: AND exists (select 1
405: from GHG_organizations fac
406: where fac.ghg_organization_id = x_facility_id
407: and fac.location_id = hr.location_id)
408: AND upper(end_user_column_name) = fnd_profile.value('GHG_FACTOR_BREAK_REGION');
409: EXCEPTION
410: WHEN NO_DATA_FOUND THEN
411: v_location := 'ALL';
412: END;

Line 518: AND upper(end_user_column_name) = fnd_profile.value('GHG_FACTOR_BREAK_REGION');

514: AND exists (select 1
515: from GHG_organizations fac
516: where fac.ghg_organization_id = x_facility_id
517: and fac.location_id = hr.location_id)
518: AND upper(end_user_column_name) = fnd_profile.value('GHG_FACTOR_BREAK_REGION');
519: EXCEPTION
520: WHEN NO_DATA_FOUND THEN
521: v_location := 'ALL';
522: END;

Line 751: AND upper(end_user_column_name) = fnd_profile.value('GHG_FACTOR_BREAK_REGION');

747: AND exists (select 1
748: from GHG_organizations fac
749: where fac.ghg_organization_id = x_facility_id
750: and fac.location_id = hr.location_id)
751: AND upper(end_user_column_name) = fnd_profile.value('GHG_FACTOR_BREAK_REGION');
752: EXCEPTION
753: WHEN NO_DATA_FOUND THEN
754: v_location := 'ALL';
755: END;

Line 807: select decode(x_uom_class, fnd_profile.value('GHG_UOM_CLASS'), nvl(ef.secondary_formula_id,ef.formula_id), ef.formula_id)

803:
804: -- Get Formula Id
805: -- if the x_uom_class is as per the value set in the profile option 'GHG_UOM_CLASS', then we use the secondary energy formula only
806:
807: select decode(x_uom_class, fnd_profile.value('GHG_UOM_CLASS'), nvl(ef.secondary_formula_id,ef.formula_id), ef.formula_id)
808: into vl_formula_id
809: from ghg_sources s
810: , ghg_source_combinations_all f
811: , ghg_emission_formulas ef

Line 847: x_quantity*decode(x_uom_class, fnd_profile.value('GHG_UOM_CLASS'), 1, vl_ec) ,

843: x_emission_id,
844: x_emission_date,
845: 'N',
846: 'ENERGY',
847: x_quantity*decode(x_uom_class, fnd_profile.value('GHG_UOM_CLASS'), 1, vl_ec) ,
848: x_factor_id,
849: x_org_id,
850: fnd_profile.value('USER_ID'), sysdate, fnd_profile.value('USER_ID'), sysdate, null
851: );

Line 850: fnd_profile.value('USER_ID'), sysdate, fnd_profile.value('USER_ID'), sysdate, null

846: 'ENERGY',
847: x_quantity*decode(x_uom_class, fnd_profile.value('GHG_UOM_CLASS'), 1, vl_ec) ,
848: x_factor_id,
849: x_org_id,
850: fnd_profile.value('USER_ID'), sysdate, fnd_profile.value('USER_ID'), sysdate, null
851: );
852:
853: -- For all Gas Types
854: for gas_type in per_gas loop

Line 869: fnd_profile.value('USER_ID'), sysdate, fnd_profile.value('USER_ID'), sysdate, null

865: gas_type.gas_type_lookup_code,
866: vl_co2e,
867: x_factor_id,
868: x_org_id,
869: fnd_profile.value('USER_ID'), sysdate, fnd_profile.value('USER_ID'), sysdate, null
870: );
871: end loop;
872: END;
873: