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.

[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on FND_PROFILE

Line 76: g_debug VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');

72: g_dflt_tz_for_sc varchar2(3);
73: g_off_time VARCHAR2(80);
74: G_PER_TIME VARCHAR2(80);
75: g_commute VARCHAR2(10);
76: g_debug VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
77: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
78:
79:
80: g_excl_travel varchar2(200);

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

73: g_off_time VARCHAR2(80);
74: G_PER_TIME VARCHAR2(80);
75: g_commute VARCHAR2(10);
76: g_debug VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
77: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
78:
79:
80: g_excl_travel varchar2(200);
81:

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

3944: RETURN NUMBER IS
3945: --variable for setting color code for gantt
3946:
3947: --variable for storing Profile value set by user
3948: -- This line is commented by vakulkar fnd_profile.value('CSF_TASK_SIGNAL_COLOR');
3949: --when you call this function from gantt, it does not get refreshed value from the buffer
3950: --instead it gets null or old value.
3951: --but when you use fnd_profile.value_specific function it returns the current value.
3952: --variable for returning color code for a task

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

3947: --variable for storing Profile value set by user
3948: -- This line is commented by vakulkar fnd_profile.value('CSF_TASK_SIGNAL_COLOR');
3949: --when you call this function from gantt, it does not get refreshed value from the buffer
3950: --instead it gets null or old value.
3951: --but when you use fnd_profile.value_specific function it returns the current value.
3952: --variable for returning color code for a task
3953: BEGIN
3954: l_task_custom_color := 'N';
3955:

Line 4487: AND category_set_id = fnd_profile.VALUE('CS_SR_DEFAULT_CATEGORY_SET'))

4483: AND ts.skill_type_id = rs.skill_type_id
4484: AND EXISTS (SELECT 1
4485: FROM mtl_item_categories mic
4486: WHERE mic.category_id = rs.skill_id
4487: AND category_set_id = fnd_profile.VALUE('CS_SR_DEFAULT_CATEGORY_SET'))
4488: )
4489: GROUP BY rs.resource_id, rs.resource_type) rs
4490: , (
4491: SELECT COUNT(*) count_of_req_skills

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

4509: -- 2 for EQUAL TO
4510: -- 3 for EQUAL TO or GREATER THAN
4511: -- In case the profile return a null, the default value
4512: -- will be 2 (EQUAL TO).
4513: l_levelmatch := NVL(fnd_profile.VALUE('CSF_SKILL_LEVEL_MATCH'), 2);
4514:
4515: l_start := csf_timezones_pvt.date_to_client_tz_date(p_start);
4516: l_end := csf_timezones_pvt.date_to_client_tz_date(p_end);
4517: OPEN c_resource_plan_window(p_task_id, l_start, l_end, p_resource_id, p_resource_type);

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

5757: -- move these profiles intialisation in this procedure
5758: -- as this procedure gets executed first for populating dispatch
5759: -- cente gantt.
5760: ---------------------------------------------------------------------------
5761: l_default_effort_uom := fnd_profile.value_specific('CSF_DEFAULT_EFFORT_UOM', g_user_id);
5762: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);
5763: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
5764: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
5765: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';

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

5758: -- as this procedure gets executed first for populating dispatch
5759: -- cente gantt.
5760: ---------------------------------------------------------------------------
5761: l_default_effort_uom := fnd_profile.value_specific('CSF_DEFAULT_EFFORT_UOM', g_user_id);
5762: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);
5763: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
5764: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
5765: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
5766: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);

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

5759: -- cente gantt.
5760: ---------------------------------------------------------------------------
5761: l_default_effort_uom := fnd_profile.value_specific('CSF_DEFAULT_EFFORT_UOM', g_user_id);
5762: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);
5763: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
5764: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
5765: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
5766: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
5767: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);

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

5760: ---------------------------------------------------------------------------
5761: l_default_effort_uom := fnd_profile.value_specific('CSF_DEFAULT_EFFORT_UOM', g_user_id);
5762: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);
5763: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
5764: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
5765: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
5766: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
5767: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);
5768: -------------------------------------------------------------------------------

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

5761: l_default_effort_uom := fnd_profile.value_specific('CSF_DEFAULT_EFFORT_UOM', g_user_id);
5762: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);
5763: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
5764: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
5765: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
5766: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
5767: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);
5768: -------------------------------------------------------------------------------
5769: -- End for adding profile values

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

5762: l_default_effort := fnd_profile.value_specific('CSF_DEFAULT_EFFORT', g_user_id);
5763: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
5764: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
5765: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
5766: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
5767: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);
5768: -------------------------------------------------------------------------------
5769: -- End for adding profile values
5770: -------------------------------------------------------------------------------

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

5763: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR', g_user_id);
5764: l_profile_value := fnd_profile.value_specific('CSF_USE_CUSTOM_CHROMATICS', g_user_id);
5765: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
5766: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
5767: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);
5768: -------------------------------------------------------------------------------
5769: -- End for adding profile values
5770: -------------------------------------------------------------------------------
5771:

Line 5773: IF NVL(FND_PROFILE.value('CSF_DC_DISPLAY_ONLY_TECHNICIANS'), 'N') = 'Y' THEN

5769: -- End for adding profile values
5770: -------------------------------------------------------------------------------
5771:
5772: -- fetch resources
5773: IF NVL(FND_PROFILE.value('CSF_DC_DISPLAY_ONLY_TECHNICIANS'), 'N') = 'Y' THEN
5774: OPEN c_res_technician;
5775: FETCH c_res_technician
5776: BULK COLLECT INTO
5777: p_res_id

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

7551: l_task_City_name :=jtf_varchar2_table_1000();
7552: l_task_Site_Name :=jtf_varchar2_table_1000();
7553: l_task_Postal_Code :=jtf_varchar2_table_1000();
7554:
7555: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
7556: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
7557: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);
7558:
7559:

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

7552: l_task_Site_Name :=jtf_varchar2_table_1000();
7553: l_task_Postal_Code :=jtf_varchar2_table_1000();
7554:
7555: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
7556: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
7557: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);
7558:
7559:
7560:

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

7553: l_task_Postal_Code :=jtf_varchar2_table_1000();
7554:
7555: g_label_on_task := fnd_profile.value_specific('CSF_DISPLAY_LABEL_ON_TASK', g_user_id) = 'Y';
7556: g_dflt_tz_for_dc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_DC', g_user_id);
7557: g_dflt_tz_for_sc := fnd_profile.value_specific('CSF_DEFAULT_TIMEZONE_SC', g_user_id);
7558:
7559:
7560:
7561:

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

8691:
8692: BEGIN
8693: -- package instantiation
8694: set_tooltip_labels;
8695: g_use_custom_chromatics := fnd_profile.VALUE('CSF_USE_CUSTOM_CHROMATICS') = 'Y';
8696:
8697: IF g_use_custom_chromatics THEN
8698: g_get_custom_color;
8699: END IF;

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

8697: IF g_use_custom_chromatics THEN
8698: g_get_custom_color;
8699: END IF;
8700: g_user_id := fnd_global.user_id;
8701: g_uom_minutes := fnd_profile.value_specific('CSF_UOM_MINUTES', g_user_id);
8702: g_uom_hours := fnd_profile.value_specific('CSF_UOM_HOURS', g_user_id);
8703: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
8704: l_language := USERENV('LANG');
8705: g_resource_id :=csf_resource_pub.resource_id;

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

8698: g_get_custom_color;
8699: END IF;
8700: g_user_id := fnd_global.user_id;
8701: g_uom_minutes := fnd_profile.value_specific('CSF_UOM_MINUTES', g_user_id);
8702: g_uom_hours := fnd_profile.value_specific('CSF_UOM_HOURS', g_user_id);
8703: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
8704: l_language := USERENV('LANG');
8705: g_resource_id :=csf_resource_pub.resource_id;
8706: g_resource_type :=csf_resource_pub.resource_type;

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

8699: END IF;
8700: g_user_id := fnd_global.user_id;
8701: g_uom_minutes := fnd_profile.value_specific('CSF_UOM_MINUTES', g_user_id);
8702: g_uom_hours := fnd_profile.value_specific('CSF_UOM_HOURS', g_user_id);
8703: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
8704: l_language := USERENV('LANG');
8705: g_resource_id :=csf_resource_pub.resource_id;
8706: g_resource_type :=csf_resource_pub.resource_type;
8707: g_server_tz := fnd_timezones.get_server_timezone_code;

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

8709: g_tz_enabled := 'N';
8710:
8711: -- this function is currently not present in fnd_timezones 1158
8712: -- copied from AFTZONEB.pls 115.3 and modified
8713: if nvl(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'),'N') = 'Y'
8714: then
8715: g_tz_enabled := 'Y';
8716: end if;
8717: