737:
738:
739: begin
740:
741: l_uom_hours := fnd_profile.value('CSF_UOM_HOURS');
742: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR',fnd_global.user_id);
743: lf := fnd_global.local_chr(10);
744: l_tz := fnd_profile.value('CSF_DEFAULT_TIMEZONE_DC');
745: l_real_task_cnt := 0;
738:
739: begin
740:
741: l_uom_hours := fnd_profile.value('CSF_UOM_HOURS');
742: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR',fnd_global.user_id);
743: lf := fnd_global.local_chr(10);
744: l_tz := fnd_profile.value('CSF_DEFAULT_TIMEZONE_DC');
745: l_real_task_cnt := 0;
746: l_task_custom_color := 'N';
740:
741: l_uom_hours := fnd_profile.value('CSF_UOM_HOURS');
742: l_rule_id := fnd_profile.value_specific('CSF_TASK_SIGNAL_COLOR',fnd_global.user_id);
743: lf := fnd_global.local_chr(10);
744: l_tz := fnd_profile.value('CSF_DEFAULT_TIMEZONE_DC');
745: l_real_task_cnt := 0;
746: l_task_custom_color := 'N';
747: k :=0;
748: m :=0;
783: l_assign_id := jtf_number_table();
784:
785:
786: -- fetch resources
787: IF NVL(FND_PROFILE.value('CSF_DC_DISPLAY_ONLY_TECHNICIANS'), 'N') = 'Y' THEN
788: OPEN c_res_technician;
789: FETCH c_res_technician
790: BULK COLLECT INTO
791: resource_name
1431: NULL;
1432: END populate_planboard_table;
1433: BEGIN
1434: -- getting the indicator if custom color coding will be used.
1435: g_use_custom_chromatics := fnd_profile.value('CSF_USE_CUSTOM_CHROMATICS') = 'Y' ;
1436: END csf_planboard_tasks;
1437: