DBA Data[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on FND_PROFILE

Line 1439: -- This line is commented by vakulkar fnd_profile.value('CSF_TASK_SIGNAL_COLOR');

1435: RETURN NUMBER IS
1436: --variable for setting color code for gantt
1437:
1438: --variable for storing Profile value set by user
1439: -- This line is commented by vakulkar fnd_profile.value('CSF_TASK_SIGNAL_COLOR');
1440: --when you call this function from gantt, it does not get refreshed value from the buffer
1441: --instead it gets null or old value.
1442: --but when you use fnd_profile.value_specific function it returns the current value.
1443: --variable for returning color code for a task

Line 1442: --but when you use fnd_profile.value_specific function it returns the current value.

1438: --variable for storing Profile value set by user
1439: -- This line is commented by vakulkar fnd_profile.value('CSF_TASK_SIGNAL_COLOR');
1440: --when you call this function from gantt, it does not get refreshed value from the buffer
1441: --instead it gets null or old value.
1442: --but when you use fnd_profile.value_specific function it returns the current value.
1443: --variable for returning color code for a task
1444: BEGIN
1445: l_task_custom_color := 'N';
1446:

Line 1928: l_levelmatch := NVL(fnd_profile.VALUE('CSF_SKILL_LEVEL_MATCH'), 2);

1924: -- 2 for EQUAL TO
1925: -- 3 for EQUAL TO or GREATER THAN
1926: -- In case the profile return a null, the default value
1927: -- will be 2 (EQUAL TO).
1928: l_levelmatch := NVL(fnd_profile.VALUE('CSF_SKILL_LEVEL_MATCH'), 2);
1929:
1930: l_start := csf_timezones_pvt.date_to_client_tz_date(p_start);
1931: l_end := csf_timezones_pvt.date_to_client_tz_date(p_end);
1932: OPEN c_resource_plan_window(p_task_id, l_start, l_end, p_resource_id, p_resource_type);

Line 2950: l_default_effort_uom := fnd_profile.value_specific('CSF_DEFAULT_EFFORT_UOM', g_user_id);

2946: -- move these profiles intialisation in this procedure
2947: -- as this procedure gets executed first for populating dispatch
2948: -- cente gantt.
2949: ---------------------------------------------------------------------------
2950: l_default_effort_uom := fnd_profile.value_specific('CSF_DEFAULT_EFFORT_UOM', g_user_id);
2951: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);
2952: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
2953: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
2954: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';

Line 2951: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);

2947: -- as this procedure gets executed first for populating dispatch
2948: -- cente gantt.
2949: ---------------------------------------------------------------------------
2950: l_default_effort_uom := fnd_profile.value_specific('CSF_DEFAULT_EFFORT_UOM', g_user_id);
2951: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);
2952: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
2953: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
2954: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
2955: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);

Line 2952: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);

2948: -- cente gantt.
2949: ---------------------------------------------------------------------------
2950: l_default_effort_uom := fnd_profile.value_specific('CSF_DEFAULT_EFFORT_UOM', g_user_id);
2951: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);
2952: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
2953: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
2954: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
2955: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
2956: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);

Line 2953: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);

2949: ---------------------------------------------------------------------------
2950: l_default_effort_uom := fnd_profile.value_specific('CSF_DEFAULT_EFFORT_UOM', g_user_id);
2951: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);
2952: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
2953: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
2954: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
2955: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
2956: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);
2957: -------------------------------------------------------------------------------

Line 2954: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';

2950: l_default_effort_uom := fnd_profile.value_specific('CSF_DEFAULT_EFFORT_UOM', g_user_id);
2951: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);
2952: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
2953: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
2954: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
2955: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
2956: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);
2957: -------------------------------------------------------------------------------
2958: -- End for adding profile values

Line 2955: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);

2951: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);
2952: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
2953: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
2954: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
2955: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
2956: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);
2957: -------------------------------------------------------------------------------
2958: -- End for adding profile values
2959: -------------------------------------------------------------------------------

Line 2956: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);

2952: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
2953: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
2954: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
2955: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
2956: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);
2957: -------------------------------------------------------------------------------
2958: -- End for adding profile values
2959: -------------------------------------------------------------------------------
2960: OPEN C_Terr_Resource;

Line 5398: g_use_custom_chromatics := fnd_profile.VALUE('CSF_USE_CUSTOM_CHROMATICS') = 'Y';

5394: END get_schedule_advise_options;
5395: BEGIN
5396: -- package instantiation
5397: set_tooltip_labels;
5398: g_use_custom_chromatics := fnd_profile.VALUE('CSF_USE_CUSTOM_CHROMATICS') = 'Y';
5399:
5400: IF g_use_custom_chromatics THEN
5401: g_get_custom_color;
5402: END IF;

Line 5404: g_uom_minutes := fnd_profile.value_specific('CSF_UOM_MINUTES', g_user_id);

5400: IF g_use_custom_chromatics THEN
5401: g_get_custom_color;
5402: END IF;
5403: g_user_id := fnd_global.user_id;
5404: g_uom_minutes := fnd_profile.value_specific('CSF_UOM_MINUTES', g_user_id);
5405: g_uom_hours := fnd_profile.value_specific('CSF_UOM_HOURS', g_user_id);
5406: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
5407: l_language := USERENV('LANG');
5408: g_resource_id :=csf_resource_pub.resource_id;

Line 5405: g_uom_hours := fnd_profile.value_specific('CSF_UOM_HOURS', g_user_id);

5401: g_get_custom_color;
5402: END IF;
5403: g_user_id := fnd_global.user_id;
5404: g_uom_minutes := fnd_profile.value_specific('CSF_UOM_MINUTES', g_user_id);
5405: g_uom_hours := fnd_profile.value_specific('CSF_UOM_HOURS', g_user_id);
5406: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
5407: l_language := USERENV('LANG');
5408: g_resource_id :=csf_resource_pub.resource_id;
5409: g_resource_type :=csf_resource_pub.resource_type;

Line 5406: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');

5402: END IF;
5403: g_user_id := fnd_global.user_id;
5404: g_uom_minutes := fnd_profile.value_specific('CSF_UOM_MINUTES', g_user_id);
5405: g_uom_hours := fnd_profile.value_specific('CSF_UOM_HOURS', g_user_id);
5406: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
5407: l_language := USERENV('LANG');
5408: g_resource_id :=csf_resource_pub.resource_id;
5409: g_resource_type :=csf_resource_pub.resource_type;
5410: g_server_tz := fnd_timezones.get_server_timezone_code;

Line 5416: if nvl(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'),'N') = 'Y'

5412: g_tz_enabled := 'N';
5413:
5414: -- this function is currently not present in fnd_timezones 1158
5415: -- copied from AFTZONEB.pls 115.3 and modified
5416: if nvl(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'),'N') = 'Y'
5417: then
5418: g_tz_enabled := 'Y';
5419: end if;
5420: