[Home] [Help]
PACKAGE BODY: APPS.HXT_AAI
Source
1 PACKAGE BODY HXT_AAI AS
2 /* $Header: hxtaai.pkb 115.0 99/07/16 13:38:23 porting ship $ */
3
4 procedure insert_HXT_ADD_ASSIGN_INFO(
5 p_rowid IN OUT VARCHAR2,
6 p_id NUMBER,
7 p_effective_start_date DATE,
8 p_effective_end_date DATE,
9 p_assignment_id NUMBER,
10 p_autogen_hours_yn VARCHAR2,
11 p_rotation_plan NUMBER,
12 p_earning_policy NUMBER,
13 p_shift_differential_policy NUMBER,
14 p_hour_deduction_policy NUMBER,
15 p_created_by NUMBER,
16 p_creation_date DATE,
17 p_last_updated_by NUMBER,
18 p_last_update_date DATE,
19 p_last_update_login NUMBER,
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_attribute21 VARCHAR2,
42 p_attribute22 VARCHAR2,
43 p_attribute23 VARCHAR2,
44 p_attribute24 VARCHAR2,
45 p_attribute25 VARCHAR2,
46 p_attribute26 VARCHAR2,
47 p_attribute27 VARCHAR2,
48 p_attribute28 VARCHAR2,
49 p_attribute29 VARCHAR2,
50 p_attribute30 VARCHAR2
51 ) is
52
53 cursor c2 is select rowid
54 from hxt_add_assign_info_f
55 where effective_start_date = p_effective_start_date
56 and effective_end_date = p_effective_end_date
57 and id = p_id;
58
59 begin
60
61 insert into HXT_ADD_ASSIGN_INFO_F(
62 id,
63 effective_start_date,
64 effective_end_date,
65 assignment_id,
66 autogen_hours_yn,
67 rotation_plan,
68 earning_policy,
69 shift_differential_policy,
70 hour_deduction_policy,
71 created_by,
72 creation_date,
73 last_updated_by,
74 last_update_date,
75 last_update_login,
76 attribute_category,
77 attribute1,
78 attribute2,
79 attribute3,
80 attribute4,
81 attribute5,
82 attribute6,
83 attribute7,
84 attribute8,
85 attribute9,
86 attribute10,
87 attribute11,
88 attribute12,
89 attribute13,
90 attribute14,
91 attribute15,
92 attribute16,
93 attribute17,
94 attribute18,
95 attribute19,
96 attribute20,
97 attribute21,
98 attribute22,
99 attribute23,
100 attribute24,
101 attribute25,
102 attribute26,
103 attribute27,
104 attribute28,
105 attribute29,
106 attribute30)
107 VALUES(
108 p_id,
109 p_effective_start_date,
110 p_effective_end_date,
111 p_assignment_id,
112 p_autogen_hours_yn,
113 p_rotation_plan,
114 p_earning_policy,
115 p_shift_differential_policy,
116 p_hour_deduction_policy,
117 p_created_by,
118 p_creation_date,
119 p_last_updated_by,
120 p_last_update_date,
121 p_last_update_login,
122 p_attribute_category,
123 p_attribute1,
124 p_attribute2,
125 p_attribute3,
126 p_attribute4,
127 p_attribute5,
128 p_attribute6,
129 p_attribute7,
130 p_attribute8,
131 p_attribute9,
132 p_attribute10,
133 p_attribute11,
134 p_attribute12,
135 p_attribute13,
136 p_attribute14,
137 p_attribute15,
138 p_attribute16,
139 p_attribute17,
140 p_attribute18,
141 p_attribute19,
142 p_attribute20,
143 p_attribute21,
144 p_attribute22,
145 p_attribute23,
146 p_attribute24,
147 p_attribute25,
148 p_attribute26,
149 p_attribute27,
150 p_attribute28,
151 p_attribute29,
152 p_attribute30);
153
154 open c2;
155 fetch c2 into p_rowid;
156 close c2;
157 null;
158
159 end insert_HXT_ADD_ASSIGN_INFO;
160
161
162 procedure update_HXT_ADD_ASSIGN_INFO(
163 p_rowid IN VARCHAR2,
164 p_id NUMBER,
165 p_effective_start_date DATE,
166 p_effective_end_date DATE,
167 p_assignment_id NUMBER,
168 p_autogen_hours_yn VARCHAR2,
169 p_rotation_plan NUMBER,
170 p_earning_policy NUMBER,
171 p_shift_differential_policy NUMBER,
172 p_hour_deduction_policy NUMBER,
173 p_created_by NUMBER,
174 p_creation_date DATE,
175 p_last_updated_by NUMBER,
176 p_last_update_date DATE,
177 p_last_update_login NUMBER,
178 p_attribute_category VARCHAR2,
179 p_attribute1 VARCHAR2,
180 p_attribute2 VARCHAR2,
181 p_attribute3 VARCHAR2,
182 p_attribute4 VARCHAR2,
183 p_attribute5 VARCHAR2,
184 p_attribute6 VARCHAR2,
185 p_attribute7 VARCHAR2,
186 p_attribute8 VARCHAR2,
187 p_attribute9 VARCHAR2,
188 p_attribute10 VARCHAR2,
189 p_attribute11 VARCHAR2,
190 p_attribute12 VARCHAR2,
191 p_attribute13 VARCHAR2,
192 p_attribute14 VARCHAR2,
193 p_attribute15 VARCHAR2,
194 p_attribute16 VARCHAR2,
195 p_attribute17 VARCHAR2,
196 p_attribute18 VARCHAR2,
197 p_attribute19 VARCHAR2,
198 p_attribute20 VARCHAR2,
199 p_attribute21 VARCHAR2,
200 p_attribute22 VARCHAR2,
201 p_attribute23 VARCHAR2,
202 p_attribute24 VARCHAR2,
203 p_attribute25 VARCHAR2,
204 p_attribute26 VARCHAR2,
205 p_attribute27 VARCHAR2,
206 p_attribute28 VARCHAR2,
207 p_attribute29 VARCHAR2,
208 p_attribute30 VARCHAR2
209 ) is
210
211 begin
212
213 update HXT_ADD_ASSIGN_INFO_F
214 set
215 effective_start_date = p_effective_start_date,
216 effective_end_date = p_effective_end_date,
217 assignment_id = p_assignment_id,
218 autogen_hours_yn = p_autogen_hours_yn,
219 rotation_plan = p_rotation_plan,
220 earning_policy = p_earning_policy,
221 shift_differential_policy = p_shift_differential_policy,
222 hour_deduction_policy = p_hour_deduction_policy,
223 created_by = p_created_by,
224 creation_date = p_creation_date,
225 last_updated_by = p_last_updated_by,
226 last_update_date = p_last_update_date,
227 last_update_login = p_last_update_login,
228 attribute_category = p_attribute_category,
229 attribute1 = p_attribute1,
230 attribute2 = p_attribute2,
231 attribute3 = p_attribute3,
232 attribute4 = p_attribute4,
233 attribute5 = p_attribute5,
234 attribute6 = p_attribute6,
235 attribute7 = p_attribute7,
236 attribute8 = p_attribute8,
237 attribute9 = p_attribute9,
238 attribute10 = p_attribute10,
239 attribute11 = p_attribute11,
240 attribute12 = p_attribute12,
241 attribute13 = p_attribute13,
242 attribute14 = p_attribute14,
243 attribute15 = p_attribute15,
244 attribute16 = p_attribute16,
245 attribute17 = p_attribute17,
246 attribute18 = p_attribute18,
247 attribute19 = p_attribute19,
248 attribute20 = p_attribute20,
249 attribute21 = p_attribute21,
250 attribute22 = p_attribute22,
251 attribute23 = p_attribute23,
252 attribute24 = p_attribute24,
253 attribute25 = p_attribute25,
254 attribute26 = p_attribute26,
255 attribute27 = p_attribute27,
256 attribute28 = p_attribute28,
257 attribute29 = p_attribute29,
258 attribute30 = p_attribute30
259 where rowid = p_rowid;
260
261 end update_HXT_ADD_ASSIGN_INFO;
262
263
264 procedure delete_HXT_ADD_ASSIGN_INFO(p_rowid VARCHAR2) is
265 begin
266 delete from HXT_ADD_ASSIGN_INFO_F
267 where rowid = chartorowid(p_rowid);
268 end delete_HXT_ADD_ASSIGN_INFO;
269
270 procedure lock_HXT_ADD_ASSIGN_INFO(p_rowid VARCHAR2) is
271 vnull number;
272 begin
273 if p_rowid is not null then
274 select ASSIGNMENT_ID into vnull
275 from hxt_add_assign_info_f
276 where rowid = p_rowid
277 for update of hxt_add_assign_info_f.ASSIGNMENT_ID nowait;
278
279 end if;
280 end lock_HXT_ADD_ASSIGN_INFO;
281
282 end HXT_AAI;