APPS.CSF_GANTT_DATA_PKG dependencies on JTF_TASK_CUSTOM_COLORS

Line 4005: FROM jtf_task_custom_colors

4001: IF l_rule_id IS NOT NULL THEN
4002: BEGIN
4003: SELECT background_col_dec
4004: INTO l_task_dec_color
4005: FROM jtf_task_custom_colors
4006: WHERE rule_id = l_rule_id;
4007:
4008: RETURN(l_task_dec_color);
4009: EXCEPTION

Line 4012: jtf_task_custom_colors_pub.get_task_dec_bgcolor(p_task_id, p_task_type_id

4008: RETURN(l_task_dec_color);
4009: EXCEPTION
4010: WHEN NO_DATA_FOUND THEN
4011: RETURN(
4012: jtf_task_custom_colors_pub.get_task_dec_bgcolor(p_task_id, p_task_type_id
4013: , p_task_priority_id, p_assignment_status_id)
4014: );
4015: END;
4016: ELSE

Line 4019: jtf_task_custom_colors_pub.get_task_dec_bgcolor(p_task_id, p_task_type_id

4015: END;
4016: ELSE
4017: -- if profile is not set then return JTF VALUE
4018: RETURN(
4019: jtf_task_custom_colors_pub.get_task_dec_bgcolor(p_task_id, p_task_type_id
4020: , p_task_priority_id, p_assignment_status_id)
4021: );
4022: END IF;
4023: ELSE

Line 4025: jtf_task_custom_colors_pub.get_task_dec_bgcolor(p_task_id, p_task_type_id

4021: );
4022: END IF;
4023: ELSE
4024: RETURN(
4025: jtf_task_custom_colors_pub.get_task_dec_bgcolor(p_task_id, p_task_type_id
4026: , p_task_priority_id, p_assignment_status_id)
4027: );
4028: END IF;
4029: END get_gantt_task_color;

Line 4927: FROM jtf_task_custom_colors

4923: , assignment_status_id
4924: , escalated_task
4925: , background_col_dec
4926: , background_col_rgb
4927: FROM jtf_task_custom_colors
4928: WHERE active_flag = 'Y'
4929: ORDER BY color_determination_priority;
4930:
4931: i BINARY_INTEGER := 0;

Line 5170: FROM jtf_task_custom_colors

5166: AND TRUNC(ca.end_date_time) <= trunc(p_end_date);
5167:
5168: CURSOR get_tdu_color(t_rule_id NUMBER) IS
5169: SELECT background_col_dec
5170: FROM jtf_task_custom_colors
5171: WHERE rule_id = t_rule_id;
5172:
5173: CURSOR C_Virtual_Tasks
5174: IS

Line 5630: FROM jtf_task_custom_colors

5626: , assignment_status_id
5627: , escalated_task
5628: , background_col_dec
5629: , background_col_rgb
5630: FROM jtf_task_custom_colors
5631: WHERE active_flag = 'Y'
5632: ORDER BY color_determination_priority;
5633:
5634: i BINARY_INTEGER := 0;

Line 6699: FROM jtf_task_custom_colors

6695: WHERE seq_id = 6;
6696:
6697: CURSOR get_tdu_color(t_rule_id NUMBER) IS
6698: SELECT background_col_dec
6699: FROM jtf_task_custom_colors
6700: WHERE rule_id = t_rule_id;
6701:
6702: CURSOR c_task_bar_info
6703: IS

Line 7418: FROM jtf_task_custom_colors

7414: , assignment_status_id
7415: , escalated_task
7416: , background_col_dec
7417: , background_col_rgb
7418: FROM jtf_task_custom_colors
7419: WHERE active_flag = 'Y'
7420: ORDER BY color_determination_priority;
7421:
7422: i BINARY_INTEGER := 0;