[Home] [Help]
PACKAGE: APPS.CSF_PLANBOARD_TASKS
Source
1 PACKAGE csf_planboard_tasks AUTHID CURRENT_USER AS
2 /*$Header: CSFCTPLS.pls 120.4.12020000.1 2012/06/27 06:38:23 appldev ship $*/
3
4 -- stores resource and task info for resource with a maximum of 100 tasks
5 -- assigned to a resource on a day
6
7 type pb_rec_type is record
8 ( resource_id number
9 , resource_type varchar2(30)
10 , resource_name varchar2(360)
11 , task_cell_1 varchar2(150)
12 , task_cell_2 varchar2(150)
13 , task_cell_3 varchar2(150)
14 , task_cell_4 varchar2(150)
15 , task_cell_5 varchar2(150)
16 , task_cell_6 varchar2(150)
17 , task_cell_7 varchar2(150)
18 , task_cell_8 varchar2(150)
19 , task_cell_9 varchar2(150)
20 , task_cell_10 varchar2(150)
21 , task_cell_11 varchar2(150)
22 , task_cell_12 varchar2(150)
23 , task_cell_13 varchar2(150)
24 , task_cell_14 varchar2(150)
25 , task_cell_15 varchar2(150)
26 , task_id_1 number
27 , task_id_2 number
28 , task_id_3 number
29 , task_id_4 number
30 , task_id_5 number
31 , task_id_6 number
32 , task_id_7 number
33 , task_id_8 number
34 , task_id_9 number
35 , task_id_10 number
36 , task_id_11 number
37 , task_id_12 number
38 , task_id_13 number
39 , task_id_14 number
40 , task_id_15 number
41 , actual_indicator varchar2(100)
42 , real_task_cnt number
43 , RGB_color_1 varchar2(20)
44 , RGB_color_2 varchar2(20)
45 , RGB_color_3 varchar2(20)
46 , RGB_color_4 varchar2(20)
47 , RGB_color_5 varchar2(20)
48 , RGB_color_6 varchar2(20)
49 , RGB_color_7 varchar2(20)
50 , RGB_color_8 varchar2(20)
51 , RGB_color_9 varchar2(20)
52 , RGB_color_10 varchar2(20)
53 , RGB_color_11 varchar2(20)
54 , RGB_color_12 varchar2(20)
55 , RGB_color_13 varchar2(20)
56 , RGB_color_14 varchar2(20)
57 , RGB_color_15 varchar2(20)
58 , other_info_1 varchar2(150)
59 , other_info_2 varchar2(150)
60 , other_info_3 varchar2(150)
61 , other_info_4 varchar2(150)
62 , other_info_5 varchar2(150)
63 , other_info_6 varchar2(150)
64 , other_info_7 varchar2(150)
65 , other_info_8 varchar2(150)
66 , other_info_9 varchar2(150)
67 , other_info_10 varchar2(150)
68 , other_info_11 varchar2(150)
69 , other_info_12 varchar2(150)
70 , other_info_13 varchar2(150)
71 , other_info_14 varchar2(150)
72 , other_info_15 varchar2(150)
73 );
74
75 type pb_tbl_type is table of pb_rec_type index by binary_integer;
76
77
78
79 -- fills pl/sql table with resource and task info at a certain date
80 -- when resource id and type are given, then only the record for this
81 -- resource is returned (selective refresh versus complete table refresh)
82 PROCEDURE populate_planboard_table
83 ( p_start_date in date
84 , p_end_date in date
85 , p_resource_id in number default null
86 , p_resource_type in varchar2 default null
87 , p_shift_reg in varchar2 default null
88 , p_shift_std in varchar2 default null
89 , x_pb_tbl out nocopy pb_tbl_type
90 );
91
92 END csf_planboard_tasks;