DBA Data[Home] [Help]

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 284: g_duration_uom := fnd_profile.value('CSF_UOM_MINUTES');

280: END process_messages;
281:
282: PROCEDURE init_package IS
283: BEGIN
284: g_duration_uom := fnd_profile.value('CSF_UOM_MINUTES');
285: g_overtime := NVL(fnd_profile.value('MAXOVERTIME'), 0) / g_mins_in_day;
286: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
287: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
288: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';

Line 285: g_overtime := NVL(fnd_profile.value('MAXOVERTIME'), 0) / g_mins_in_day;

281:
282: PROCEDURE init_package IS
283: BEGIN
284: g_duration_uom := fnd_profile.value('CSF_UOM_MINUTES');
285: g_overtime := NVL(fnd_profile.value('MAXOVERTIME'), 0) / g_mins_in_day;
286: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
287: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
288: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
289: g_tz_enabled := fnd_timezones.timezones_enabled;

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

282: PROCEDURE init_package IS
283: BEGIN
284: g_duration_uom := fnd_profile.value('CSF_UOM_MINUTES');
285: g_overtime := NVL(fnd_profile.value('MAXOVERTIME'), 0) / g_mins_in_day;
286: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
287: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
288: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
289: g_tz_enabled := fnd_timezones.timezones_enabled;
290: g_server_tz_code := fnd_timezones.get_server_timezone_code;

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

283: BEGIN
284: g_duration_uom := fnd_profile.value('CSF_UOM_MINUTES');
285: g_overtime := NVL(fnd_profile.value('MAXOVERTIME'), 0) / g_mins_in_day;
286: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
287: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
288: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
289: g_tz_enabled := fnd_timezones.timezones_enabled;
290: g_server_tz_code := fnd_timezones.get_server_timezone_code;
291: g_client_tz_code := fnd_timezones.get_client_timezone_code;

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

284: g_duration_uom := fnd_profile.value('CSF_UOM_MINUTES');
285: g_overtime := NVL(fnd_profile.value('MAXOVERTIME'), 0) / g_mins_in_day;
286: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
287: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
288: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
289: g_tz_enabled := fnd_timezones.timezones_enabled;
290: g_server_tz_code := fnd_timezones.get_server_timezone_code;
291: g_client_tz_code := fnd_timezones.get_client_timezone_code;
292:

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

289: g_tz_enabled := fnd_timezones.timezones_enabled;
290: g_server_tz_code := fnd_timezones.get_server_timezone_code;
291: g_client_tz_code := fnd_timezones.get_client_timezone_code;
292:
293: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
294: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
295: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');
296: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');
297: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');

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

290: g_server_tz_code := fnd_timezones.get_server_timezone_code;
291: g_client_tz_code := fnd_timezones.get_client_timezone_code;
292:
293: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
294: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
295: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');
296: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');
297: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
298:

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

291: g_client_tz_code := fnd_timezones.get_client_timezone_code;
292:
293: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
294: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
295: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');
296: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');
297: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
298:
299: SELECT name INTO g_dep_task_name

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

292:
293: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
294: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
295: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');
296: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');
297: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
298:
299: SELECT name INTO g_dep_task_name
300: FROM jtf_task_types_vl WHERE task_type_id = g_dep_task_type_id;

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

293: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
294: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
295: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');
296: g_blocked_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKEDASS_STATUS');
297: g_closed_status_id := fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
298:
299: SELECT name INTO g_dep_task_name
300: FROM jtf_task_types_vl WHERE task_type_id = g_dep_task_type_id;
301:

Line 3294: l_num_days := fnd_profile.value('PLANSCOPE');

3290: l_start_date := csf_timezones_pvt.date_to_server_tz_date(TRUNC(l_start_date));
3291: END IF;
3292:
3293: IF p_num_days IS NULL OR p_num_days <= 0 THEN
3294: l_num_days := fnd_profile.value('PLANSCOPE');
3295: IF l_num_days IS NULL OR l_num_days <=0 THEN
3296: l_num_days := 7;
3297: END IF;
3298: ELSE