APPS.ICX_CAT_UTIL_PKG dependencies on PO_SYSTEM_PARAMETERS

Line 51: SELECT default_rate_type into default_conversion_type FROM po_system_parameters;

47:
48: -- use default rate type from purchasing options if rate type is null
49: if ( x_conversion_type is null ) then
50: begin
51: SELECT default_rate_type into default_conversion_type FROM po_system_parameters;
52: exception
53: WHEN OTHERS THEN default_conversion_type := null;
54: end;
55: end if;

Line 130: SELECT default_rate_type into default_conversion_type FROM po_system_parameters;

126: converted_amount := round ( ( x_amount * x_conversion_rate)/to_mau ) * to_mau ;
127: elsif (x_conversion_type is null) then
128: -- Get the rate depending on the default rate type from purchasing options
129: begin
130: SELECT default_rate_type into default_conversion_type FROM po_system_parameters;
131: exception
132: WHEN OTHERS THEN default_conversion_type := null;
133: end;
134: converted_amount := round ( ( x_amount * gl_currency_api.get_rate(x_from_currency,x_to_currency, x_conversion_date, default_conversion_type ))/to_mau ) * to_mau ;