DBA Data[Home] [Help]

APPS.AMS_ACTMETRIC_PVT dependencies on FND_PROFILE

Line 4253: NVL(Fnd_Profile.Value (L_ALLOW_ACTUAL_UPDATE_METR),'N');

4249: (G_CATEGORY_COSTS, G_CATEGORY_REVENUES)
4250: AND l_metric_details_rec.metric_calculation_type IN
4251: ('MANUAL', 'FUNCTION') THEN
4252: l_allow_actual_update :=
4253: NVL(Fnd_Profile.Value (L_ALLOW_ACTUAL_UPDATE_METR),'N');
4254:
4255: --sunkumar 04/30/2003
4256: --added profile option to restrict updation of actuals
4257: IF (l_allow_actual_update = 'N') THEN

Line 4285: NVL(Fnd_Profile.Value (L_ALLOW_ACTUAL_UPDATE_METR),'N');

4281: (G_CATEGORY_COSTS, G_CATEGORY_REVENUES)
4282: AND l_metric_details_rec.metric_calculation_type IN
4283: ('MANUAL', 'FUNCTION') THEN
4284: l_allow_actual_update :=
4285: NVL(Fnd_Profile.Value (L_ALLOW_ACTUAL_UPDATE_METR),'N');
4286:
4287: -- Profile option to restrict updation of actuals.
4288: IF (l_allow_actual_update = 'N') THEN
4289: --object is not active and profile is N hence do not allow update

Line 5026: RETURN Fnd_Profile.Value('AMS_DEFAULT_CURR_CODE');

5022: FUNCTION Default_Func_Currency
5023: RETURN VARCHAR2
5024: IS
5025: BEGIN
5026: RETURN Fnd_Profile.Value('AMS_DEFAULT_CURR_CODE');
5027: -- RETURN 'USD';
5028: END Default_Func_Currency;
5029:
5030: ---------------------------------------------------------------------

Line 5726: l_conversion_type := Fnd_Profile.Value (L_CONVERSION_TYPE_PROFILE);

5722: -- Initialize return status.
5723: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5724:
5725: -- Get the currency conversion type from profile option
5726: l_conversion_type := Fnd_Profile.Value (L_CONVERSION_TYPE_PROFILE);
5727:
5728: -- Check if both currencies are identical
5729: IF ( p_from_currency = p_to_currency ) THEN
5730: -- l_denominator := 1;

Line 5834: l_conversion_type := Fnd_Profile.Value (L_CONVERSION_TYPE_PROFILE);

5830: -- Initialize return status.
5831: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5832:
5833: -- Get the currency conversion type from profile option
5834: l_conversion_type := Fnd_Profile.Value (L_CONVERSION_TYPE_PROFILE);
5835:
5836: -- Check if both currencies are identical
5837: IF ( p_from_currency <> p_to_currency ) THEN
5838: --

Line 6535: nvl(fnd_profile.value('JTF_PROFILE_DEFAULT_NUM_ROWS'),10);

6531:
6532: -- BUG 3815334: Use profile for max buckets.
6533: -- This is the same profile that DCF uses for report page length.
6534: l_max_bucket_count :=
6535: nvl(fnd_profile.value('JTF_PROFILE_DEFAULT_NUM_ROWS'),10);
6536: IF p_start_date IS NULL
6537: OR p_end_date IS NULL
6538: OR TRUNC(p_start_date) > TRUNC(p_end_date)
6539: OR p_interval_amount IS NULL