eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_TRIPS_PUB dependencies on FND_PROFILE

Line 21: g_datetime_fmt_mask fnd_profile_option_values.profile_option_value%TYPE;

17:
18: g_tz_enabled VARCHAR2(1);
19: g_server_tz_code fnd_timezones_b.timezone_code%TYPE;
20: g_client_tz_code fnd_timezones_b.timezone_code%TYPE;
21: g_datetime_fmt_mask fnd_profile_option_values.profile_option_value%TYPE;
22: g_duration_uom mtl_uom_conversions.uom_code%TYPE;
23: g_overtime NUMBER;
24:
25: g_assigned_status_id NUMBER;

Line 324: g_duration_uom := fnd_profile.value('CSF_UOM_MINUTES');

320: END process_messages;
321:
322: PROCEDURE init_package IS
323: BEGIN
324: g_duration_uom := fnd_profile.value('CSF_UOM_MINUTES');
325: g_overtime := NVL(CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spMaxOvertime'), 0) / g_mins_in_day;
326:
327:
328: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');

Line 328: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');

324: g_duration_uom := fnd_profile.value('CSF_UOM_MINUTES');
325: g_overtime := NVL(CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spMaxOvertime'), 0) / g_mins_in_day;
326:
327:
328: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
329: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
330: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
331: g_tz_enabled := fnd_timezones.timezones_enabled;
332: g_server_tz_code := fnd_timezones.get_server_timezone_code;

Line 329: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);

325: g_overtime := NVL(CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spMaxOvertime'), 0) / g_mins_in_day;
326:
327:
328: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
329: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
330: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
331: g_tz_enabled := fnd_timezones.timezones_enabled;
332: g_server_tz_code := fnd_timezones.get_server_timezone_code;
333: g_client_tz_code := fnd_timezones.get_client_timezone_code;

Line 330: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';

326:
327:
328: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
329: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
330: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
331: g_tz_enabled := fnd_timezones.timezones_enabled;
332: g_server_tz_code := fnd_timezones.get_server_timezone_code;
333: g_client_tz_code := fnd_timezones.get_client_timezone_code;
334:

Line 335: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');

331: g_tz_enabled := fnd_timezones.timezones_enabled;
332: g_server_tz_code := fnd_timezones.get_server_timezone_code;
333: g_client_tz_code := fnd_timezones.get_client_timezone_code;
334:
335: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
336: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
337: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');
338: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');
339: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');

Line 336: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');

332: g_server_tz_code := fnd_timezones.get_server_timezone_code;
333: g_client_tz_code := fnd_timezones.get_client_timezone_code;
334:
335: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
336: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
337: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');
338: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');
339: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
340:

Line 337: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');

333: g_client_tz_code := fnd_timezones.get_client_timezone_code;
334:
335: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
336: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
337: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');
338: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');
339: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
340:
341: SELECT name INTO g_dep_task_name

Line 338: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');

334:
335: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
336: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
337: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');
338: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');
339: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
340:
341: SELECT name INTO g_dep_task_name
342: FROM jtf_task_types_vl WHERE task_type_id = g_dep_task_type_id;

Line 339: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');

335: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
336: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
337: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');
338: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');
339: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
340:
341: SELECT name INTO g_dep_task_name
342: FROM jtf_task_types_vl WHERE task_type_id = g_dep_task_type_id;
343:

Line 4808: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');

4804: l_end_res date;
4805: l_server_diff number;
4806: l_res_diff number;
4807: l_main_diff number;
4808: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
4809: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
4810:
4811: X_RETURN_STATUS Varchar2(10);
4812: x_msg_count number;

Line 4809: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

4805: l_server_diff number;
4806: l_res_diff number;
4807: l_main_diff number;
4808: l_tz_enabled VARCHAR2(10):=fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS');
4809: l_server_tz_id Number := to_number (fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
4810:
4811: X_RETURN_STATUS Varchar2(10);
4812: x_msg_count number;
4813: x_msg_data Varchar2(2000);

Line 4843: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y'

4839:
4840: l_server_diff := trunc ((p_end_server - p_start_server ) * g_hours_in_day,2);
4841: IF l_server_diff > 24
4842: THEN
4843: If fnd_profile.value_specific('ENABLE_TIMEZONE_CONVERSIONS') = 'Y'
4844: Then
4845: l_res_Timezone_id := Get_Res_Timezone_Id (p_resource_id);
4846: l_start_res := ServerDT_To_ResourceDt(p_start_server,l_server_tz_id,l_res_Timezone_id);
4847: l_end_res := ServerDT_To_ResourceDt(p_end_server,l_server_tz_id,l_res_Timezone_id);

Line 4953: l_Res_TimeZone_id := nvl(l_Res_TimeZone_id,fnd_profile.value_specific('SERVER_TIMEZONE_ID'));

4949: Open C_Res_TimeZone ;
4950: Fetch C_Res_TimeZone into l_Res_TimeZone_id;
4951: Close C_Res_TimeZone ;
4952:
4953: l_Res_TimeZone_id := nvl(l_Res_TimeZone_id,fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
4954:
4955: Return (l_Res_TimeZone_id);
4956:
4957: End Get_Res_Timezone_Id;