APPS.CAC_VIEW_ACC_DAILY_VIEW_PVT dependencies on FND_PROFILE

Line 73: l_client_timezone_id := TO_NUMBER(NVL(FND_PROFILE.VALUE('CLIENT_TIMEZONE_ID'),4));

69: IS
70: l_client_timezone_id NUMBER;
71: l_client_date DATE;
72: BEGIN
73: l_client_timezone_id := TO_NUMBER(NVL(FND_PROFILE.VALUE('CLIENT_TIMEZONE_ID'),4));
74:
75: CAC_VIEW_UTIL_PVT.AdjustForTimezone
76: (p_source_tz_id => p_source_timezone_id
77: ,p_dest_tz_id => l_client_timezone_id

Line 1079: l_client_timezone_id := TO_NUMBER(NVL(fnd_profile.value('CLIENT_TIMEZONE_ID'),'4'));

1075: l_end_date rec_repeating.end_date_active%TYPE;
1076: l_time_hh NUMBER;
1077: l_time_mm NUMBER;
1078: BEGIN
1079: l_client_timezone_id := TO_NUMBER(NVL(fnd_profile.value('CLIENT_TIMEZONE_ID'),'4'));
1080:
1081:
1082: IF p_recurrence_rule_id IS NULL THEN
1083: fnd_message.set_name('JTF', 'CAC_VIEW_NO_REPEAT');

Line 1099: l_end_date:=NVL(hz_timezone_pub.convert_datetime(TO_NUMBER(NVL(fnd_profile.value('SERVER_TIMEZONE_ID'),'4'))

1095:
1096: l_end_date := rec_repeating.end_date_active;
1097: l_end_date := l_end_date+(l_time_hh/24)+(l_time_mm/1440);
1098:
1099: l_end_date:=NVL(hz_timezone_pub.convert_datetime(TO_NUMBER(NVL(fnd_profile.value('SERVER_TIMEZONE_ID'),'4'))
1100: ,l_client_timezone_id
1101: ,l_end_date),l_end_date);
1102:
1103: