1 PACKAGE JTF_TASK_CUSTOM_COLORS_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfptkfs.pls 115.5 2002/12/06 20:47:40 cjang ship $ */
3 /*======================================================================+
4 | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
5 | All rights reserved. |
6 +=======================================================================+
7 | FILENAME |
8 | jtfptkfs.pls |
9 | |
10 | DESCRIPTION |
11 | This package is used to get the color for a task. |
12 | |
13 | NOTES |
14 | |
15 | |
16 | Date Developer Change |
17 | ----------- --------------- --------------------------------------- |
18 | 22-Oct-2002 cjang Created. |
19 | 31-Oct-2002 cjang Added get_task_bgcolors() |
20 | Added parameters for the new column |
21 | background_col_dec. |
22 | Defined taskcolor_tbl and |
23 | Changed the parameter on get_task_bgcolors
24 | to the type of get_task_bgcolors |
25 | 06-Nov-2002 cjang Removed task_assignment_id from taskcolor_rec
26 | 06-Dec-2002 Chan-Ik Jang Fixed Bug 2696521: |
27 | Added get_task_dec_bgcolor() |
28 *=======================================================================*/
29
30 ----------------------------------------------------------------
31 -- PL/SQL Table of record to contain the color setup data
32 ----------------------------------------------------------------
33 TYPE custom_color_rec IS RECORD (
34 task_type_id NUMBER,
35 task_priority_id NUMBER,
36 assignment_status_id NUMBER,
37 escalated_task VARCHAR2(1),
38 background_col_dec NUMBER,
39 background_col_rgb VARCHAR2(12)
40 );
41 TYPE custom_color_tbl IS TABLE OF custom_color_rec INDEX BY BINARY_INTEGER;
42
43 g_custom_color_tbl custom_color_tbl;
44
45 ----------------------------------------------------------------
46 -- PL/SQL Table of record to contain the combination of task_id
47 -- and task_assignment_id with the colors
48 ----------------------------------------------------------------
49 TYPE taskcolor_rec IS RECORD (
50 task_id NUMBER,
51 task_type_id NUMBER,
52 task_priority_id NUMBER,
53 assignment_status_id NUMBER,
54 background_col_dec NUMBER,
55 background_col_rgb VARCHAR2(12)
56 );
57 TYPE taskcolor_tbl IS TABLE OF taskcolor_rec INDEX BY BINARY_INTEGER;
58
59 ----------------------------------------------------------------
60 -- FUNCTION GET_TASK_RGB_BGCOLOR:
61 ----------------------------------------------------------------
62 -- This procedure returns the background color for rgb
63 --
64 -- PARAMETERS:
65 -- p_task_id : used to check whether it has an escalation.
66 -- p_task_type_id : used to match the coloring rule.
67 -- p_task_priority_id : used to match the coloring rule.
68 -- p_assignment_status_id : used to match the coloring rule.
69 ----------------------------------------------------------------
70 FUNCTION get_task_rgb_bgcolor(p_task_id IN NUMBER
71 ,p_task_type_id IN NUMBER
72 ,p_task_priority_id IN NUMBER
73 ,p_assignment_status_id IN NUMBER
74 )
75 RETURN VARCHAR2;
76
77 ----------------------------------------------------------------
78 -- FUNCTION GET_TASK_DEC_BGCOLOR:
79 ----------------------------------------------------------------
80 -- This procedure returns the background color as decimal
81 --
82 -- PARAMETERS:
83 -- p_task_id : used to check whether it has an escalation.
84 -- p_task_type_id : used to match the coloring rule.
85 -- p_task_priority_id : used to match the coloring rule.
86 -- p_assignment_status_id : used to match the coloring rule.
87 ----------------------------------------------------------------
88 FUNCTION get_task_dec_bgcolor(p_task_id IN NUMBER
89 ,p_task_type_id IN NUMBER
90 ,p_task_priority_id IN NUMBER
91 ,p_assignment_status_id IN NUMBER
92 )
93 RETURN NUMBER;
94
95 ----------------------------------------------------------------
96 -- PROCEDURE GET_TASK_BGCOLORS:
97 -- This procedure returns the background color
98 -- for decimal and rgb.
99 ----------------------------------------------------------------
100 PROCEDURE get_task_bgcolors(p_taskcolor_tbl IN OUT NOCOPY taskcolor_tbl);
101
102 END JTF_TASK_CUSTOM_COLORS_PUB;