[Home] [Help]
PACKAGE: APPS.PER_GRADES_PKG
Source
1 package PER_GRADES_PKG AUTHID CURRENT_USER as
2 /* $Header: pegrd01t.pkh 115.4 2003/05/23 17:44:36 kjagadee ship $ */
3
4 -- Standard insert procedure
5
6 procedure insert_row(
7 p_row_id in out nocopy varchar2,
8 p_grade_id in out nocopy number,
9 p_business_group_id number,
10 p_grade_definition_id number,
11 p_date_from date,
12 p_sequence number,
13 p_comments varchar2,
14 p_date_to date,
15 p_name varchar2,
16 p_request_id number,
17 p_program_application_id number,
18 p_program_id number,
19 p_program_update_date date,
20 p_attribute_category varchar2,
21 p_attribute1 varchar2,
22 p_attribute2 varchar2,
23 p_attribute3 varchar2,
24 p_attribute4 varchar2,
25 p_attribute5 varchar2,
26 p_attribute6 varchar2,
27 p_attribute7 varchar2,
28 p_attribute8 varchar2,
29 p_attribute9 varchar2,
30 p_attribute10 varchar2,
31 p_attribute11 varchar2,
32 p_attribute12 varchar2,
33 p_attribute13 varchar2,
34 p_attribute14 varchar2,
35 p_attribute15 varchar2,
36 p_attribute16 varchar2,
37 p_attribute17 varchar2,
38 p_attribute18 varchar2,
39 p_attribute19 varchar2,
40 p_attribute20 varchar2,
41 p_language_code varchar2 default hr_api.userenv_lang);
42
43
44 --standard delete procedure
45
46 procedure delete_row(p_row_id varchar2,
47 p_grd_id in number);
48
49
50 --standard lock procedure
51
52 procedure lock_row (
53 p_row_id varchar2,
54 p_grade_id number,
55 p_business_group_id number,
56 p_grade_definition_id number,
57 p_date_from date,
58 p_sequence number,
59 p_comments varchar2,
60 p_date_to date,
61 p_name varchar2,
62 p_request_id number,
63 p_program_application_id number,
64 p_program_id number,
65 p_program_update_date date,
66 p_attribute_category varchar2,
67 p_attribute1 varchar2,
68 p_attribute2 varchar2,
69 p_attribute3 varchar2,
70 p_attribute4 varchar2,
71 p_attribute5 varchar2,
72 p_attribute6 varchar2,
73 p_attribute7 varchar2,
74 p_attribute8 varchar2,
75 p_attribute9 varchar2,
76 p_attribute10 varchar2,
77 p_attribute11 varchar2,
78 p_attribute12 varchar2,
79 p_attribute13 varchar2,
80 p_attribute14 varchar2,
81 p_attribute15 varchar2,
82 p_attribute16 varchar2,
83 p_attribute17 varchar2,
84 p_attribute18 varchar2,
85 p_attribute19 varchar2,
86 p_attribute20 varchar2,
87 p_language_code varchar2 default hr_api.userenv_lang);
88
89
90 --standard update procedure
91
92 procedure update_row(
93 p_row_id varchar2,
94 p_grade_id number,
95 p_business_group_id number,
96 p_grade_definition_id number,
97 p_date_from date,
98 p_sequence number,
99 p_comments varchar2,
100 p_date_to date,
101 p_name varchar2,
102 p_request_id number,
103 p_program_application_id number,
104 p_program_id number,
105 p_program_update_date date,
106 p_attribute_category varchar2,
107 p_attribute1 varchar2,
108 p_attribute2 varchar2,
109 p_attribute3 varchar2,
110 p_attribute4 varchar2,
111 p_attribute5 varchar2,
112 p_attribute6 varchar2,
113 p_attribute7 varchar2,
114 p_attribute8 varchar2,
115 p_attribute9 varchar2,
116 p_attribute10 varchar2,
117 p_attribute11 varchar2,
118 p_attribute12 varchar2,
119 p_attribute13 varchar2,
120 p_attribute14 varchar2,
121 p_attribute15 varchar2,
122 p_attribute16 varchar2,
123 p_attribute17 varchar2,
124 p_attribute18 varchar2,
125 p_attribute19 varchar2,
126 p_attribute20 varchar2,
127 p_language_code varchar2 default hr_api.userenv_lang);
128
129
130 procedure stbdelvl(
131 p_grd_id number);
132
133
134 procedure postup1(
135 p_seq NUMBER,
136 p_s_seq IN OUT NOCOPY NUMBER,
137 p_lastup NUMBER,
138 p_login NUMBER,
139 p_grd_id NUMBER,
140 p_bgroup NUMBER,
141 l_exists OUT NOCOPY VARCHAR2);
142
143
144 procedure postup2(
145 p_grd_id NUMBER,
146 p_bgroup NUMBER,
147 p_date_from DATE,
148 p_date_to DATE,
149 p_eot DATE,
150 p_date_to_old DATE);
151
152
153 procedure gstruct(
154 p_b_group number,
155 p_s_def_col IN OUT NOCOPY varchar2);
156
157
158 PROCEDURE b_check_grade_date_from (
159 p_grd_id NUMBER,
160 p_date_from DATE);
161
162
163 PROCEDURE chk_flex_def (
164 p_rwid VARCHAR2,
165 p_grd_id NUMBER,
166 p_bgroup_id NUMBER,
167 p_grdef_id NUMBER);
168
169
170 PROCEDURE chk_grade (
171 p_rwid VARCHAR2,
172 p_bgroup_id NUMBER,
173 p_seg VARCHAR2,
174 p_popid OUT NOCOPY VARCHAR2,
175 p_fail OUT NOCOPY BOOLEAN);
176
177 procedure old_date_to(p_grd_id IN NUMBER,
178 p_old_date IN OUT NOCOPY DATE);
179
180
181 procedure chk_seq(p_rwid in varchar2,
182 p_bgroup in number,
183 p_seq in number);
184
185 -- Start of Bug fix 2400465
186 -- ----------------------------------------------------------------------------
187 -- |-------------------< chk_date_from >----------------------|
188 -- ----------------------------------------------------------------------------
189 -- {Start Of Comments}
190 --
191 -- Description:
192 -- This procedure will check any valid grade rate is existing(attached)
193 -- for this grade id with effective from date is before the from date
194 -- of the grade.
195 --
196 -- Prerequisites:
197 -- A valid grade must be existing .
198 --
199 -- In Parameters:
200 -- Name Reqd Type Description
201 -- p_grade_id yes number System assigned id for
202 -- the grade
203 -- p_date_from yes date New from date of the
204 -- grade
205 -- Post Success:
206 -- User cannot modify the grade from date to a date less than the effective
207 -- from date of a grade rate which is attached to this grade. User will
208 -- be stopped with the dispaly of an appropriate message
209 --
210 -- Post Failure:
211 -- None.
212 --
213 -- Access Status:
214 -- Internal developement use.
215 --
216 -- {End Of Comments}
217 -- ----------------------------------------------------------------------------
218 procedure chk_date_from(p_grade_id in number,
219 p_date_from in date);
220
221 -- ----------------------------------------------------------------------------
222 -- |-------------------< chk_end_date >----------------------|
223 -- ----------------------------------------------------------------------------
224 -- {Start Of Comments}
225 --
226 -- Description:
227 -- This procedure will check any valid grade rate is existing for this
228 -- grade with effective end date is greater than the end date of grade
229 --
230 -- Prerequisites:
231 -- A valid grade must be existing .
232 --
233 -- In Parameters:
234 -- Name Reqd Type Description
235 -- p_grade_id yes number System assigned id for
236 -- the grade
237 -- p_date_to yes date New date to for the
238 -- grade
239 -- Post Success:
240 -- User cannot modify the grade "date to" to a date less than the effective
241 -- end date of a grade rate which is attached to this grade. A message
242 -- will be displayed to the user for the same.
243 --
244 -- Post Failure:
245 -- None.
246 --
247 -- Access Status:
248 -- Internal developement use.
249 --
250 -- {End Of Comments}
251 -- ----------------------------------------------------------------------------
252 procedure chk_end_date(p_grade_id in number,
253 p_date_to in date);
254 -- End of fix
255
256 end PER_GRADES_PKG;