APPS.JTF_CAL_UTILITY_PVT dependencies on FND_PROFILE

Line 193: AND jrb.user_id = to_number(fnd_profile.value('USER_ID'));

189: FROM jtf_rs_resource_extns jrb
190: , jtf_rs_resource_extns_tl jrt
191: WHERE jrb.resource_id = jrt.resource_id
192: AND jrt.language = userenv('LANG')
193: AND jrb.user_id = to_number(fnd_profile.value('USER_ID'));
194:
195: r_ResourceInfo c_ResourceInfo%ROWTYPE;
196:
197: BEGIN

Line 345: fnd_profile.value('JTF_CAL_SPAN_DAYS')

341: p_PeriodStartDate,
342: p_PeriodEndDate,
343: p_StartDate,
344: p_EndDate,
345: fnd_profile.value('JTF_CAL_SPAN_DAYS')
346: );
347: /*
348: IF (p_StartDate IS NULL)
349: THEN

Line 863: x_CalSpanDaysProfile := fnd_profile.value('JTF_CAL_SPAN_DAYS');

859: x_Preferences,
860: x_WeekTimePrefTbl
861: );
862:
863: x_CalSpanDaysProfile := fnd_profile.value('JTF_CAL_SPAN_DAYS');
864:
865: END GetPreferences;
866:
867: PROCEDURE GetPreferences

Line 891: x_CalSpanDaysProfile := fnd_profile.value('JTF_CAL_SPAN_DAYS');

887: x_Preferences.LoggedOnRSType := p_QueryRSType;
888: x_Preferences.LoggedOnRSName := GetResourceName( p_QueryRSID
889: , p_QueryRSType
890: );
891: x_CalSpanDaysProfile := fnd_profile.value('JTF_CAL_SPAN_DAYS');
892:
893: END GetPreferences;
894:
895: PROCEDURE GetPreferences

Line 954: x_Preferences.TimeZone := to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'));

950: x_Preferences.DisplayItems := 'NO';
951: x_Preferences.TaskCustomerSource := 'NO';
952: x_Preferences.TimeFormat := '12';
953: x_Preferences.DateFormat := 'DD-MON-YYYY';
954: x_Preferences.TimeZone := to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),'4'));
955: x_Preferences.WeekStart := 2;
956: x_Preferences.WeekEnd := 6;
957: x_Preferences.ApptIncrement := 30;
958: x_Preferences.ApptColor := '#663300'; --Brown

Line 1366: --l_SourceTimezoneID := to_number(FND_PROFILE.Value('JTF_CAL_DEFAULT_TIMEZONE'));

1362: THEN
1363: /**************************************************************************
1364: ** If the timezone is not defined used the profile value
1365: **************************************************************************/
1366: --l_SourceTimezoneID := to_number(FND_PROFILE.Value('JTF_CAL_DEFAULT_TIMEZONE'));
1367: l_SourceTimezoneID := to_number(FND_PROFILE.Value('SERVER_TIMEZONE_ID'));
1368: --l_SourceTimezoneID := to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),4));
1369: ELSE
1370: l_SourceTimezoneID := p_source_tz_id;

Line 1367: l_SourceTimezoneID := to_number(FND_PROFILE.Value('SERVER_TIMEZONE_ID'));

1363: /**************************************************************************
1364: ** If the timezone is not defined used the profile value
1365: **************************************************************************/
1366: --l_SourceTimezoneID := to_number(FND_PROFILE.Value('JTF_CAL_DEFAULT_TIMEZONE'));
1367: l_SourceTimezoneID := to_number(FND_PROFILE.Value('SERVER_TIMEZONE_ID'));
1368: --l_SourceTimezoneID := to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),4));
1369: ELSE
1370: l_SourceTimezoneID := p_source_tz_id;
1371: END IF;

Line 1368: --l_SourceTimezoneID := to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),4));

1364: ** If the timezone is not defined used the profile value
1365: **************************************************************************/
1366: --l_SourceTimezoneID := to_number(FND_PROFILE.Value('JTF_CAL_DEFAULT_TIMEZONE'));
1367: l_SourceTimezoneID := to_number(FND_PROFILE.Value('SERVER_TIMEZONE_ID'));
1368: --l_SourceTimezoneID := to_number(NVL(FND_PROFILE.Value('CLIENT_TIMEZONE_ID'),4));
1369: ELSE
1370: l_SourceTimezoneID := p_source_tz_id;
1371: END IF;
1372: /***********************************************************************