1 PACKAGE CSF_MAP_ACC_HRS_PKG AUTHID CURRENT_USER as
2 /* $Header: csfmaccs.pls 120.4 2011/05/25 12:33:09 shadas ship $ */
3 --
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 -- Purpose: Briefly explain the functionality of the package
8 --
9 -- MODIFICATION HISTORY
10 -- Person Date Comments
11 -- --------- ------ ------------------------------------------
12 -- Enter package declarations as shown below
13
14 TYPE access_hours_rec IS RECORD (
15 ACCESS_HOUR_MAP_ID NUMBER := null,
16 CUSTOMER_ID NUMBER := null,
17 CUSTOMER_SITE_ID NUMBER := null,
18 CUSTOMER_LOCATION_ID NUMBER := null,
19 ACCESSHOUR_REQUIRED VARCHAR2(2) := null,
20 AFTER_HOURS_FLAG VARCHAR2(2) := null,
21 MONDAY_FIRST_START DATE := null,
22 MONDAY_FIRST_END DATE := null,
23 MONDAY_SECOND_START DATE := null,
24 MONDAY_SECOND_END DATE := null,
25 TUESDAY_FIRST_START DATE := null,
26 TUESDAY_FIRST_END DATE := null,
27 TUESDAY_SECOND_START DATE := null,
28 TUESDAY_SECOND_END DATE := null,
29 WEDNESDAY_FIRST_START DATE := null,
30 WEDNESDAY_FIRST_END DATE := null,
31 WEDNESDAY_SECOND_START DATE := null,
32 WEDNESDAY_SECOND_END DATE := null,
33 THURSDAY_FIRST_START DATE := null,
34 THURSDAY_FIRST_END DATE := null,
35 THURSDAY_SECOND_START DATE := null,
36 THURSDAY_SECOND_END DATE := null,
37 FRIDAY_FIRST_START DATE := null,
38 FRIDAY_FIRST_END DATE := null,
39 FRIDAY_SECOND_START DATE := null,
40 FRIDAY_SECOND_END DATE := null,
41 SATURDAY_FIRST_START DATE := null,
42 SATURDAY_FIRST_END DATE := null,
43 SATURDAY_SECOND_START DATE := null,
44 SATURDAY_SECOND_END DATE := null,
45 SUNDAY_FIRST_START DATE := null,
46 SUNDAY_FIRST_END DATE := null,
47 SUNDAY_SECOND_START DATE := null,
48 SUNDAY_SECOND_END DATE := null,
49 DESCRIPTION VARCHAR2(240) := null,
50 OBJECT_VERSION_NUMBER NUMBER := null,
51 CREATED_BY NUMBER := null,
52 CREATION_DATE DATE := null,
53 LAST_UPDATED_BY NUMBER := null,
54 LAST_UPDATE_DATE DATE := null,
55 LAST_UPDATE_LOGIN NUMBER := null,
56 security_group_id NUMBER := null);
57
58 PROCEDURE Query_Row(
59 p_customer_id in number,
60 p_customer_site_id in number,
61 p_customer_location_id in number,
62 x_access_hours out nocopy access_hours_rec);
63
64 PROCEDURE Insert_Row(
65 px_ACCESS_HOUR_MAP_ID IN OUT NOCOPY NUMBER,
66 p_CUSTOMER_ID IN NUMBER,
67 p_CUSTOMER_SITE_ID IN NUMBER,
68 p_CUSTOMER_LOCATION_ID IN NUMBER,
69 p_ACCESSHOUR_REQUIRED IN VARCHAR2,
70 p_AFTER_HOURS_FLAG IN VARCHAR2,
71 p_MONDAY_FIRST_START IN DATE,
72 p_MONDAY_FIRST_END IN DATE,
73 p_MONDAY_SECOND_START IN DATE,
74 p_MONDAY_SECOND_END IN DATE,
75 p_TUESDAY_FIRST_START IN DATE,
76 p_TUESDAY_FIRST_END IN DATE,
77 p_TUESDAY_SECOND_START IN DATE,
78 p_TUESDAY_SECOND_END IN DATE,
79 p_WEDNESDAY_FIRST_START IN DATE,
80 p_WEDNESDAY_FIRST_END IN DATE,
81 p_WEDNESDAY_SECOND_START IN DATE,
82 p_WEDNESDAY_SECOND_END IN DATE,
83 p_THURSDAY_FIRST_START IN DATE,
84 p_THURSDAY_FIRST_END IN DATE,
85 p_THURSDAY_SECOND_START IN DATE,
86 p_THURSDAY_SECOND_END IN DATE,
87 p_FRIDAY_FIRST_START IN DATE,
88 p_FRIDAY_FIRST_END IN DATE,
89 p_FRIDAY_SECOND_START IN DATE,
90 p_FRIDAY_SECOND_END IN DATE,
91 p_SATURDAY_FIRST_START IN DATE,
92 p_SATURDAY_FIRST_END IN DATE,
93 p_SATURDAY_SECOND_START IN DATE,
94 p_SATURDAY_SECOND_END IN DATE,
95 p_SUNDAY_FIRST_START IN DATE,
96 p_SUNDAY_FIRST_END IN DATE,
97 p_SUNDAY_SECOND_START IN DATE,
98 p_SUNDAY_SECOND_END IN DATE,
99 p_DESCRIPTION IN VARCHAR2,
100 X_OBJECT_VERSION_NUMBER Out NOCOPY NUMBER,
101 p_CREATED_BY IN NUMBER,
102 p_CREATION_DATE IN DATE,
103 p_LAST_UPDATED_BY IN NUMBER,
104 p_LAST_UPDATE_DATE IN DATE,
105 p_LAST_UPDATE_LOGIN IN NUMBER,
106 p_security_group_id IN NUMBER);
107
108
109
110 PROCEDURE Update_Row(
111 p_ACCESS_HOUR_MAP_ID IN NUMBER,
112 p_CUSTOMER_ID IN NUMBER,
113 p_CUSTOMER_SITE_ID IN NUMBER,
114 p_CUSTOMER_LOCATION_ID IN NUMBER,
115 p_ACCESSHOUR_REQUIRED IN VARCHAR2,
116 p_AFTER_HOURS_FLAG IN VARCHAR2,
117 p_MONDAY_FIRST_START IN DATE,
118 p_MONDAY_FIRST_END IN DATE,
119 p_MONDAY_SECOND_START IN DATE,
120 p_MONDAY_SECOND_END IN DATE,
121 p_TUESDAY_FIRST_START IN DATE,
122 p_TUESDAY_FIRST_END IN DATE,
123 p_TUESDAY_SECOND_START IN DATE,
124 p_TUESDAY_SECOND_END IN DATE,
125 p_WEDNESDAY_FIRST_START IN DATE,
126 p_WEDNESDAY_FIRST_END IN DATE,
127 p_WEDNESDAY_SECOND_START IN DATE,
128 p_WEDNESDAY_SECOND_END IN DATE,
129 p_THURSDAY_FIRST_START IN DATE,
130 p_THURSDAY_FIRST_END IN DATE,
131 p_THURSDAY_SECOND_START IN DATE,
132 p_THURSDAY_SECOND_END IN DATE,
133 p_FRIDAY_FIRST_START IN DATE,
134 p_FRIDAY_FIRST_END IN DATE,
135 p_FRIDAY_SECOND_START IN DATE,
136 p_FRIDAY_SECOND_END IN DATE,
137 p_SATURDAY_FIRST_START IN DATE,
138 p_SATURDAY_FIRST_END IN DATE,
139 p_SATURDAY_SECOND_START IN DATE,
140 p_SATURDAY_SECOND_END IN DATE,
141 p_SUNDAY_FIRST_START IN DATE,
142 p_SUNDAY_FIRST_END IN DATE,
143 p_SUNDAY_SECOND_START IN DATE,
144 p_SUNDAY_SECOND_END IN DATE,
145 p_DESCRIPTION IN VARCHAR2,
146 X_OBJECT_VERSION_NUMBER Out NOCOPY NUMBER,
147 p_LAST_UPDATED_BY IN NUMBER,
148 p_LAST_UPDATE_DATE IN DATE,
149 p_LAST_UPDATE_LOGIN IN NUMBER,
150 p_security_group_id IN NUMBER);
151
152 PROCEDURE Lock_Row(
153 p_ACCESS_HOUR_MAP_ID IN NUMBER,
154 P_OBJECT_VERSION_NUMBER in NUMBER);
155
156 PROCEDURE Delete_Row(
157 p_ACCESS_HOUR_MAP_ID IN NUMBER);
158
159 PROCEDURE ADD_LANGUAGE;
160
161 PROCEDURE Load_Row(
162 p_ACCESS_HOUR_MAP_ID IN NUMBER,
163 p_CUSTOMER_ID IN NUMBER,
164 p_CUSTOMER_SITE_ID IN NUMBER,
165 p_CUSTOMER_LOCATION_ID IN NUMBER,
166 p_ACCESSHOUR_REQUIRED IN VARCHAR2,
167 p_AFTER_HOURS_FLAG IN VARCHAR2,
168 p_MONDAY_FIRST_START IN DATE,
169 p_MONDAY_FIRST_END IN DATE,
170 p_MONDAY_SECOND_START IN DATE,
171 p_MONDAY_SECOND_END IN DATE,
172 p_TUESDAY_FIRST_START IN DATE,
173 p_TUESDAY_FIRST_END IN DATE,
174 p_TUESDAY_SECOND_START IN DATE,
175 p_TUESDAY_SECOND_END IN DATE,
176 p_WEDNESDAY_FIRST_START IN DATE,
177 p_WEDNESDAY_FIRST_END IN DATE,
178 p_WEDNESDAY_SECOND_START IN DATE,
179 p_WEDNESDAY_SECOND_END IN DATE,
180 p_THURSDAY_FIRST_START IN DATE,
181 p_THURSDAY_FIRST_END IN DATE,
182 p_THURSDAY_SECOND_START IN DATE,
183 p_THURSDAY_SECOND_END IN DATE,
184 p_FRIDAY_FIRST_START IN DATE,
185 p_FRIDAY_FIRST_END IN DATE,
186 p_FRIDAY_SECOND_START IN DATE,
187 p_FRIDAY_SECOND_END IN DATE,
188 p_SATURDAY_FIRST_START IN DATE,
189 p_SATURDAY_FIRST_END IN DATE,
190 p_SATURDAY_SECOND_START IN DATE,
191 p_SATURDAY_SECOND_END IN DATE,
192 p_SUNDAY_FIRST_START IN DATE,
193 p_SUNDAY_FIRST_END IN DATE,
194 p_SUNDAY_SECOND_START IN DATE,
195 p_SUNDAY_SECOND_END IN DATE,
196 p_DESCRIPTION IN VARCHAR2,
197 P_OBJECT_VERSION_NUMBER IN NUMBER,
198 P_OWNER IN VARCHAR2,
199 p_CREATED_BY IN NUMBER,
200 p_CREATION_DATE IN DATE,
201 p_LAST_UPDATED_BY IN NUMBER,
202 p_LAST_UPDATE_DATE IN DATE,
203 p_LAST_UPDATE_LOGIN IN NUMBER,
204 p_security_group_id IN NUMBER);
205
206
207 PROCEDURE Translate_Row( X_ACCESS_HOUR_MAP_ID in NUMBER,
208 X_DESCRIPTION in varchar2,
209 X_LAST_UPDATE_DATE in date,
210 X_LAST_UPDATE_LOGIN in number,
211 X_OWNER in varchar2);
212
213 END CSF_MAP_ACC_HRS_PKG; -- Package spec