1 PACKAGE CSF_MAP_ACC_HRS_PKG as
2 /* $Header: csfmaccs.pls 120.1 2005/11/29 17:02:45 rhungund noship $ */
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 PROCEDURE Insert_Row(
15 px_ACCESS_HOUR_MAP_ID IN OUT NOCOPY NUMBER,
16 p_CUSTOMER_ID IN NUMBER,
17 p_CUSTOMER_SITE_ID IN NUMBER,
18 p_CUSTOMER_LOCATION_ID IN NUMBER,
19 p_ACCESSHOUR_REQUIRED IN VARCHAR2,
20 p_AFTER_HOURS_FLAG IN VARCHAR2,
21 p_MONDAY_FIRST_START IN DATE,
22 p_MONDAY_FIRST_END IN DATE,
23 p_MONDAY_SECOND_START IN DATE,
24 p_MONDAY_SECOND_END IN DATE,
25 p_TUESDAY_FIRST_START IN DATE,
26 p_TUESDAY_FIRST_END IN DATE,
27 p_TUESDAY_SECOND_START IN DATE,
28 p_TUESDAY_SECOND_END IN DATE,
29 p_WEDNESDAY_FIRST_START IN DATE,
30 p_WEDNESDAY_FIRST_END IN DATE,
31 p_WEDNESDAY_SECOND_START IN DATE,
32 p_WEDNESDAY_SECOND_END IN DATE,
33 p_THURSDAY_FIRST_START IN DATE,
34 p_THURSDAY_FIRST_END IN DATE,
35 p_THURSDAY_SECOND_START IN DATE,
36 p_THURSDAY_SECOND_END IN DATE,
37 p_FRIDAY_FIRST_START IN DATE,
38 p_FRIDAY_FIRST_END IN DATE,
39 p_FRIDAY_SECOND_START IN DATE,
40 p_FRIDAY_SECOND_END IN DATE,
41 p_SATURDAY_FIRST_START IN DATE,
42 p_SATURDAY_FIRST_END IN DATE,
43 p_SATURDAY_SECOND_START IN DATE,
44 p_SATURDAY_SECOND_END IN DATE,
45 p_SUNDAY_FIRST_START IN DATE,
46 p_SUNDAY_FIRST_END IN DATE,
47 p_SUNDAY_SECOND_START IN DATE,
48 p_SUNDAY_SECOND_END IN DATE,
49 p_DESCRIPTION IN VARCHAR2,
50 X_OBJECT_VERSION_NUMBER Out NOCOPY NUMBER,
51 p_CREATED_BY IN NUMBER,
52 p_CREATION_DATE IN DATE,
53 p_LAST_UPDATED_BY IN NUMBER,
54 p_LAST_UPDATE_DATE IN DATE,
55 p_LAST_UPDATE_LOGIN IN NUMBER,
56 p_security_group_id IN NUMBER);
57
58
59
60 PROCEDURE Update_Row(
61 p_ACCESS_HOUR_MAP_ID IN NUMBER,
62 p_CUSTOMER_ID IN NUMBER,
63 p_CUSTOMER_SITE_ID IN NUMBER,
64 p_CUSTOMER_LOCATION_ID IN NUMBER,
65 p_ACCESSHOUR_REQUIRED IN VARCHAR2,
66 p_AFTER_HOURS_FLAG IN VARCHAR2,
67 p_MONDAY_FIRST_START IN DATE,
68 p_MONDAY_FIRST_END IN DATE,
69 p_MONDAY_SECOND_START IN DATE,
70 p_MONDAY_SECOND_END IN DATE,
71 p_TUESDAY_FIRST_START IN DATE,
72 p_TUESDAY_FIRST_END IN DATE,
73 p_TUESDAY_SECOND_START IN DATE,
74 p_TUESDAY_SECOND_END IN DATE,
75 p_WEDNESDAY_FIRST_START IN DATE,
76 p_WEDNESDAY_FIRST_END IN DATE,
77 p_WEDNESDAY_SECOND_START IN DATE,
78 p_WEDNESDAY_SECOND_END IN DATE,
79 p_THURSDAY_FIRST_START IN DATE,
80 p_THURSDAY_FIRST_END IN DATE,
81 p_THURSDAY_SECOND_START IN DATE,
82 p_THURSDAY_SECOND_END IN DATE,
83 p_FRIDAY_FIRST_START IN DATE,
84 p_FRIDAY_FIRST_END IN DATE,
85 p_FRIDAY_SECOND_START IN DATE,
86 p_FRIDAY_SECOND_END IN DATE,
87 p_SATURDAY_FIRST_START IN DATE,
88 p_SATURDAY_FIRST_END IN DATE,
89 p_SATURDAY_SECOND_START IN DATE,
90 p_SATURDAY_SECOND_END IN DATE,
91 p_SUNDAY_FIRST_START IN DATE,
92 p_SUNDAY_FIRST_END IN DATE,
93 p_SUNDAY_SECOND_START IN DATE,
94 p_SUNDAY_SECOND_END IN DATE,
95 p_DESCRIPTION IN VARCHAR2,
96 X_OBJECT_VERSION_NUMBER Out NOCOPY NUMBER,
97 p_LAST_UPDATED_BY IN NUMBER,
98 p_LAST_UPDATE_DATE IN DATE,
99 p_LAST_UPDATE_LOGIN IN NUMBER,
100 p_security_group_id IN NUMBER);
101
102 PROCEDURE Lock_Row(
103 p_ACCESS_HOUR_MAP_ID IN NUMBER,
104 P_OBJECT_VERSION_NUMBER in NUMBER);
105
106 PROCEDURE Delete_Row(
107 p_ACCESS_HOUR_MAP_ID IN NUMBER);
108
109 PROCEDURE ADD_LANGUAGE;
110
111 PROCEDURE Load_Row(
112 p_ACCESS_HOUR_MAP_ID IN NUMBER,
113 p_CUSTOMER_ID IN NUMBER,
114 p_CUSTOMER_SITE_ID IN NUMBER,
115 p_CUSTOMER_LOCATION_ID IN NUMBER,
116 p_ACCESSHOUR_REQUIRED IN VARCHAR2,
117 p_AFTER_HOURS_FLAG IN VARCHAR2,
118 p_MONDAY_FIRST_START IN DATE,
119 p_MONDAY_FIRST_END IN DATE,
120 p_MONDAY_SECOND_START IN DATE,
121 p_MONDAY_SECOND_END IN DATE,
122 p_TUESDAY_FIRST_START IN DATE,
123 p_TUESDAY_FIRST_END IN DATE,
124 p_TUESDAY_SECOND_START IN DATE,
125 p_TUESDAY_SECOND_END IN DATE,
126 p_WEDNESDAY_FIRST_START IN DATE,
127 p_WEDNESDAY_FIRST_END IN DATE,
128 p_WEDNESDAY_SECOND_START IN DATE,
129 p_WEDNESDAY_SECOND_END IN DATE,
130 p_THURSDAY_FIRST_START IN DATE,
131 p_THURSDAY_FIRST_END IN DATE,
132 p_THURSDAY_SECOND_START IN DATE,
133 p_THURSDAY_SECOND_END IN DATE,
134 p_FRIDAY_FIRST_START IN DATE,
135 p_FRIDAY_FIRST_END IN DATE,
136 p_FRIDAY_SECOND_START IN DATE,
137 p_FRIDAY_SECOND_END IN DATE,
138 p_SATURDAY_FIRST_START IN DATE,
139 p_SATURDAY_FIRST_END IN DATE,
140 p_SATURDAY_SECOND_START IN DATE,
141 p_SATURDAY_SECOND_END IN DATE,
142 p_SUNDAY_FIRST_START IN DATE,
143 p_SUNDAY_FIRST_END IN DATE,
144 p_SUNDAY_SECOND_START IN DATE,
145 p_SUNDAY_SECOND_END IN DATE,
146 p_DESCRIPTION IN VARCHAR2,
147 P_OBJECT_VERSION_NUMBER IN NUMBER,
148 P_OWNER IN VARCHAR2,
149 p_CREATED_BY IN NUMBER,
150 p_CREATION_DATE IN DATE,
151 p_LAST_UPDATED_BY IN NUMBER,
152 p_LAST_UPDATE_DATE IN DATE,
153 p_LAST_UPDATE_LOGIN IN NUMBER,
154 p_security_group_id IN NUMBER);
155
156
157 PROCEDURE Translate_Row( X_ACCESS_HOUR_MAP_ID in NUMBER,
158 X_DESCRIPTION in varchar2,
159 X_LAST_UPDATE_DATE in date,
160 X_LAST_UPDATE_LOGIN in number,
161 X_OWNER in varchar2);
162
163 END CSF_MAP_ACC_HRS_PKG; -- Package spec