1 PACKAGE PA_TIMELINE_GLOB AUTHID CURRENT_USER as
2 /* $Header: PARLTMLS.pls 115.9 2002/02/12 18:31:13 pkm ship $*/
3
4 TYPE TimeChartRecord IS RECORD ( time_chart_record_type VARCHAR(30),
5 assignment_id NUMBER ,
6 resource_id NUMBER ,
7 start_date DATE ,
8 end_date DATE ,
9 scale_type VARCHAR2(30) ,
10 color_pattern VARCHAR2(30) ,
11 help_text VARCHAR2(150)
12 );
13
14 TYPE TimeChartTabTyp IS TABLE OF TimeChartRecord INDEX BY BINARY_INTEGER;
15
16 TYPE TimeScaleRecord IS RECORD ( start_date DATE ,
17 end_date DATE ,
18 scale_row_type VARCHAR2(30) ,
19 scale_type VARCHAR2(30) ,
20 scale_text VARCHAR2(30) ,
21 scale_marker_code VARCHAR2(1)
22 );
23
24 TYPE TimeScaleTabTyp IS TABLE OF TimeScaleRecord INDEX BY BINARY_INTEGER;
25
26 TYPE ColorPatternRecord IS RECORD ( status_code VARCHAR2(30) ,
27 color_pattern_code VARCHAR2(1),
28 description VARCHAR2(80)
29 );
30
31 TYPE ColorPatternTabTyp IS TABLE OF ColorPatternRecord INDEX BY BINARY_INTEGER;
32
33 TYPE TimelineProfileSetup IS RECORD
34 (res_capacity_percentage NUMBER,
35 res_overcommitment_percentage NUMBER,
36 availability_cal_period VARCHAR2(30),
37 availability_duration NUMBER);
38
39 TYPE TimeChartWeekDetailRecord IS RECORD (
40 event_id NUMBER,
41 sys_status_code PA_PROJECT_STATUSES.project_system_status_code%TYPE,
42 status_priority NUMBER,
43 day_one_hours NUMBER,
44 day_two_hours NUMBER,
45 day_three_hours NUMBER,
46 day_four_hours NUMBER,
47 day_five_hours NUMBER,
48 day_six_hours NUMBER,
49 day_seven_hours NUMBER);
50
51 TYPE TimeChartWeekDetailTabTyp IS TABLE OF TimeChartWeekDetailRecord INDEX BY BINARY_INTEGER;
52
53 TYPE ResourceCapacityRecord IS RECORD (
54 day_one_hours NUMBER,
55 day_two_hours NUMBER,
56 day_three_hours NUMBER,
57 day_four_hours NUMBER,
58 day_five_hours NUMBER,
59 day_six_hours NUMBER,
60 day_seven_hours NUMBER);
61
62 TYPE WeekDatesRangeRecord IS RECORD ( week_start_date DATE ,
63 week_end_date DATE
64 );
65
66 TYPE WeekDatesRangeTabTyp IS TABLE OF WeekDatesRangeRecord INDEX BY BINARY_INTEGER;
67
68 END PA_TIMELINE_GLOB;