DBA Data[Home] [Help]

APPS.OZF_SD_UTIL_PVT dependencies on FND_PROFILE

Line 15: --l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));

11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_SD_UTIL_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvsdub.pls';
13:
14:
15: --l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
16:
17: function SD_CONVERT_CURRENCY(p_batch_line_id number,p_amount number ) return number
18: is
19:

Line 147: l_rn_timezone := fnd_profile.value('CLN_RN_TIMEZONE');

143: END IF;
144: l_count_t_appearanace := instr(p_rn_date,'T');
145: IF (l_count_t_appearanace > 0) THEN
146: --Datetime Format: YYYYMMDDThhmmss.SSSZ
147: l_rn_timezone := fnd_profile.value('CLN_RN_TIMEZONE');
148:
149: -- get the timezone of the db server
150: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;
151:

Line 565: l_rn_timezone := fnd_profile.value('CLN_RN_TIMEZONE');

561:
562: -- get the timezone of the db server
563: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;
564:
565: l_rn_timezone := fnd_profile.value('CLN_RN_TIMEZONE');
566:
567:
568: -- this function converts the datetime from the user entered/db timezone to UTC
569: x_utc_date := FND_TIMEZONES_PVT.adjust_datetime(p_input_date,l_db_timezone,l_rn_timezone);