DBA Data[Home] [Help]

APPS.CLN_RN_UTILS dependencies on FND_PROFILE

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

7: -- Arguments
8: -- Date
9: -- Notes
10: --
11: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
12: PROCEDURE CONVERT_TO_RN_TIMEZONE(
13: p_input_date IN DATE,
14: x_utc_date OUT NOCOPY DATE )
15: IS

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

29: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;
30: IF (l_Debug_Level <= 1) THEN
31: cln_debug_pub.Add('TimeZone of the DB server -->'||l_db_timezone,1);
32: END IF;
33: l_rn_timezone := fnd_profile.value('CLN_RN_TIMEZONE');
34: IF (l_Debug_Level <= 1) THEN
35: cln_debug_pub.Add('TimeZone of the UTC -->'||l_rn_timezone,1);
36: END IF;
37: IF (l_Debug_Level <= 1) THEN

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

210: END IF;
211: l_count_t_appearanace := instr(p_rn_date,'T');
212: IF (l_count_t_appearanace > 0) THEN
213: --Datetime Format: YYYYMMDDThhmmss.SSSZ
214: l_rn_timezone := fnd_profile.value('CLN_RN_TIMEZONE');
215: IF (l_Debug_Level <= 1) THEN
216: cln_debug_pub.Add('TimeZone of the UTC '||l_rn_timezone,1);
217: END IF;
218: -- get the timezone of the db server

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

1495: RETURN;
1496: END IF;
1497: IF (p_rn_time is not null) THEN
1498: --Datetime Format: YYYYMMDDThhmmss.SSSZ
1499: l_rn_timezone := fnd_profile.value('CLN_RN_TIMEZONE');
1500: IF (l_Debug_Level <= 1) THEN
1501: cln_debug_pub.Add('TimeZone of the UTC '||l_rn_timezone,1);
1502: END IF;
1503: -- get the timezone of the db server