[Home] [Help]
PACKAGE: APPS.PA_SCHEDULE_GLOB
Source
1 PACKAGE PA_SCHEDULE_GLOB as
2 /* $Header: PARGGLBS.pls 120.1 2005/12/08 00:26:01 appldev ship $ */
3
4 TYPE ScheduleRecord IS RECORD ( schrowid rowid,
5 schedule_id number,
6 calendar_id number,
7 assignment_id number,
8 project_id number,
9 schedule_type_code varchar2(30),
10 assignment_status_code varchar2(30),
11 system_status_code varchar2(30),
12 start_date DATE,
13 end_date DATE,
14 monday_hours number,
15 tuesday_hours number,
16 wednesday_hours number,
17 thursday_hours number,
18 friday_hours number,
19 saturday_hours number,
20 sunday_hours number,
21 change_type_code VARCHAR2(30) );
22
23 TYPE ScheduleTabTyp IS TABLE OF ScheduleRecord INDEX BY BINARY_INTEGER;
24
25
26 TYPE SchExceptRecord IS RECORD ( exceptRowid rowid,
27 schedule_exception_id number,
28 calendar_id number,
29 assignment_id number,
30 project_id number,
31 schedule_type_code varchar2(30),
32 assignment_status_code varchar2(30),
33 exception_type_code varchar2(30),
34 duration_shift_type_code varchar2(30),
35 duration_shift_unit_code varchar2(30),
36 number_of_shift number,
37 start_date DATE,
38 end_date DATE,
39 resource_calendar_percent number,
40 non_working_day_flag varchar2(1),
41 change_hours_type_code varchar2(30),
42 change_calendar_type_code varchar2(30),
43 change_calendar_id number,
44 monday_hours number,
45 tuesday_hours number,
46 wednesday_hours number,
47 thursday_hours number,
48 friday_hours number,
49 saturday_hours number,
50 sunday_hours number );
51
52 TYPE SchExceptTabTyp IS TABLE OF SchExceptRecord INDEX BY BINARY_INTEGER;
53
54
55 TYPE calendar_record IS RECORD ( seq_num number,
56 duration number,
57 monday_hours number,
58 tuesday_hours number,
59 wednesday_hours number,
60 thursday_hours number,
61 friday_hours number,
62 saturday_hours number,
63 sunday_hours number);
64
65 TYPE calendarTabTyp IS TABLE OF calendar_record INDEX BY BINARY_INTEGER;
66
67
68
69 TYPE cal_exception_record IS RECORD ( exception_id number,
70 except_start_date DATE,
71 except_end_date DATE,
72 exception_category varchar2(30));
73
74
75 TYPE CalExceptionTabTyp IS TABLE OF cal_exception_record INDEX BY BINARY_INTEGER;
76
77
78 END PA_SCHEDULE_GLOB;