APPS.CSF_GANTT_DATA_PKG dependencies on JTF_TASK_CUSTOM_COLORS

Line 1496: FROM jtf_task_custom_colors

1492: IF l_rule_id IS NOT NULL THEN
1493: BEGIN
1494: SELECT background_col_dec
1495: INTO l_task_dec_color
1496: FROM jtf_task_custom_colors
1497: WHERE rule_id = l_rule_id;
1498:
1499: RETURN(l_task_dec_color);
1500: EXCEPTION

Line 1503: jtf_task_custom_colors_pub.get_task_dec_bgcolor(p_task_id, p_task_type_id

1499: RETURN(l_task_dec_color);
1500: EXCEPTION
1501: WHEN NO_DATA_FOUND THEN
1502: RETURN(
1503: jtf_task_custom_colors_pub.get_task_dec_bgcolor(p_task_id, p_task_type_id
1504: , p_task_priority_id, p_assignment_status_id)
1505: );
1506: END;
1507: ELSE

Line 1510: jtf_task_custom_colors_pub.get_task_dec_bgcolor(p_task_id, p_task_type_id

1506: END;
1507: ELSE
1508: -- if profile is not set then return JTF VALUE
1509: RETURN(
1510: jtf_task_custom_colors_pub.get_task_dec_bgcolor(p_task_id, p_task_type_id
1511: , p_task_priority_id, p_assignment_status_id)
1512: );
1513: END IF;
1514: ELSE

Line 1516: jtf_task_custom_colors_pub.get_task_dec_bgcolor(p_task_id, p_task_type_id

1512: );
1513: END IF;
1514: ELSE
1515: RETURN(
1516: jtf_task_custom_colors_pub.get_task_dec_bgcolor(p_task_id, p_task_type_id
1517: , p_task_priority_id, p_assignment_status_id)
1518: );
1519: END IF;
1520: END get_gantt_task_color;

Line 2263: FROM jtf_task_custom_colors

2259: , assignment_status_id
2260: , escalated_task
2261: , background_col_dec
2262: , background_col_rgb
2263: FROM jtf_task_custom_colors
2264: WHERE active_flag = 'Y'
2265: ORDER BY color_determination_priority;
2266:
2267: i BINARY_INTEGER := 0;

Line 2427: FROM jtf_task_custom_colors

2423: AND TRUNC(ca.end_date_time) <= p_end_date;
2424:
2425: CURSOR get_tdu_color(t_rule_id NUMBER) IS
2426: SELECT background_col_dec
2427: FROM jtf_task_custom_colors
2428: WHERE rule_id = t_rule_id;
2429:
2430: CURSOR C_Virtual_Tasks
2431: IS

Line 2838: FROM jtf_task_custom_colors

2834: , assignment_status_id
2835: , escalated_task
2836: , background_col_dec
2837: , background_col_rgb
2838: FROM jtf_task_custom_colors
2839: WHERE active_flag = 'Y'
2840: ORDER BY color_determination_priority;
2841:
2842: i BINARY_INTEGER := 0;

Line 3718: FROM jtf_task_custom_colors

3714: WHERE seq_id = 6;
3715:
3716: CURSOR get_tdu_color(t_rule_id NUMBER) IS
3717: SELECT background_col_dec
3718: FROM jtf_task_custom_colors
3719: WHERE rule_id = t_rule_id;
3720:
3721:
3722: CURSOR c_res_detail IS

Line 4347: FROM jtf_task_custom_colors

4343: , assignment_status_id
4344: , escalated_task
4345: , background_col_dec
4346: , background_col_rgb
4347: FROM jtf_task_custom_colors
4348: WHERE active_flag = 'Y'
4349: ORDER BY color_determination_priority;
4350:
4351: i BINARY_INTEGER := 0;