APPS.PER_CTK_DEL dependencies on PER_CTK_SHD

Line 52: (p_rec in per_ctk_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in per_ctk_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: per_ctk_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: per_ctk_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in per_ctk_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in per_ctk_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: -- for elgiy object

Line 147: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND

143: l_effective_date date;
144: Begin
145: hr_utility.set_location('Entering:'||l_proc, 10);
146: --
147: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
148: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number)) then
149:
150: -- delete old eligy profile eligy object (child)
151: open c_elig_prfl_elig_obj(per_ctk_shd.g_old_rec.eligibility_profile_id, per_ctk_shd.g_old_rec.eligibility_object_id);

Line 148: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number)) then

144: Begin
145: hr_utility.set_location('Entering:'||l_proc, 10);
146: --
147: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
148: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number)) then
149:
150: -- delete old eligy profile eligy object (child)
151: open c_elig_prfl_elig_obj(per_ctk_shd.g_old_rec.eligibility_profile_id, per_ctk_shd.g_old_rec.eligibility_object_id);
152: fetch c_elig_prfl_elig_obj into l_elig_obj_elig_prfl_id,l_prf_obj_ovn,l_effective_date;

Line 151: open c_elig_prfl_elig_obj(per_ctk_shd.g_old_rec.eligibility_profile_id, per_ctk_shd.g_old_rec.eligibility_object_id);

147: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
148: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number)) then
149:
150: -- delete old eligy profile eligy object (child)
151: open c_elig_prfl_elig_obj(per_ctk_shd.g_old_rec.eligibility_profile_id, per_ctk_shd.g_old_rec.eligibility_object_id);
152: fetch c_elig_prfl_elig_obj into l_elig_obj_elig_prfl_id,l_prf_obj_ovn,l_effective_date;
153: if(c_elig_prfl_elig_obj%found) then
154: begin
155: ben_ELIG_OBJ_ELIG_PROFL_api.delete_elig_obj_elig_profl

Line 175: open c_elig_obj(per_ctk_shd.g_old_rec.eligibility_object_id);

171: end if;
172: close c_elig_prfl_elig_obj;
173:
174:
175: open c_elig_obj(per_ctk_shd.g_old_rec.eligibility_object_id);
176: fetch c_elig_obj into l_obj_ovn,l_effective_date;
177: if(c_elig_obj%found) then
178: begin
179: ben_elig_obj_api.delete_elig_obj

Line 182: p_elig_obj_id=>per_ctk_shd.g_old_rec.eligibility_object_id,

178: begin
179: ben_elig_obj_api.delete_elig_obj
180: (
181: p_validate=>false,
182: p_elig_obj_id=>per_ctk_shd.g_old_rec.eligibility_object_id,
183: p_effective_start_date=>l_effective_start_date,
184: p_effective_end_date=>l_effective_end_date,
185: p_object_version_number=>l_obj_ovn,
186: p_effective_date=>l_effective_date,

Line 232: Procedure post_delete(p_rec in per_ctk_shd.g_rec_type) is

228: -- Internal Row Handler Use Only.
229: --
230: -- {End Of Comments}
231: -- -----------------------------------------------------------------------------
232: Procedure post_delete(p_rec in per_ctk_shd.g_rec_type) is
233: --
234: l_proc varchar2(72) := g_package||'post_delete';
235: --
236: Begin

Line 244: => per_ctk_shd.g_old_rec.checklist_id

240: per_ctk_rkd.after_delete
241: (p_task_in_checklist_id
242: => p_rec.task_in_checklist_id
243: ,p_checklist_id_o
244: => per_ctk_shd.g_old_rec.checklist_id
245: ,p_checklist_task_name_o
246: => per_ctk_shd.g_old_rec.checklist_task_name
247: ,p_eligibility_object_id_o
248: => per_ctk_shd.g_old_rec.eligibility_object_id

Line 246: => per_ctk_shd.g_old_rec.checklist_task_name

242: => p_rec.task_in_checklist_id
243: ,p_checklist_id_o
244: => per_ctk_shd.g_old_rec.checklist_id
245: ,p_checklist_task_name_o
246: => per_ctk_shd.g_old_rec.checklist_task_name
247: ,p_eligibility_object_id_o
248: => per_ctk_shd.g_old_rec.eligibility_object_id
249: ,p_eligibility_profile_id_o
250: => per_ctk_shd.g_old_rec.eligibility_profile_id

Line 248: => per_ctk_shd.g_old_rec.eligibility_object_id

244: => per_ctk_shd.g_old_rec.checklist_id
245: ,p_checklist_task_name_o
246: => per_ctk_shd.g_old_rec.checklist_task_name
247: ,p_eligibility_object_id_o
248: => per_ctk_shd.g_old_rec.eligibility_object_id
249: ,p_eligibility_profile_id_o
250: => per_ctk_shd.g_old_rec.eligibility_profile_id
251: ,p_ame_attribute_identifier_o
252: => per_ctk_shd.g_old_rec.ame_attribute_identifier

Line 250: => per_ctk_shd.g_old_rec.eligibility_profile_id

246: => per_ctk_shd.g_old_rec.checklist_task_name
247: ,p_eligibility_object_id_o
248: => per_ctk_shd.g_old_rec.eligibility_object_id
249: ,p_eligibility_profile_id_o
250: => per_ctk_shd.g_old_rec.eligibility_profile_id
251: ,p_ame_attribute_identifier_o
252: => per_ctk_shd.g_old_rec.ame_attribute_identifier
253: ,p_description_o
254: => per_ctk_shd.g_old_rec.description

Line 252: => per_ctk_shd.g_old_rec.ame_attribute_identifier

248: => per_ctk_shd.g_old_rec.eligibility_object_id
249: ,p_eligibility_profile_id_o
250: => per_ctk_shd.g_old_rec.eligibility_profile_id
251: ,p_ame_attribute_identifier_o
252: => per_ctk_shd.g_old_rec.ame_attribute_identifier
253: ,p_description_o
254: => per_ctk_shd.g_old_rec.description
255: ,p_mandatory_flag_o
256: => per_ctk_shd.g_old_rec.mandatory_flag

Line 254: => per_ctk_shd.g_old_rec.description

250: => per_ctk_shd.g_old_rec.eligibility_profile_id
251: ,p_ame_attribute_identifier_o
252: => per_ctk_shd.g_old_rec.ame_attribute_identifier
253: ,p_description_o
254: => per_ctk_shd.g_old_rec.description
255: ,p_mandatory_flag_o
256: => per_ctk_shd.g_old_rec.mandatory_flag
257: ,p_target_duration_o
258: => per_ctk_shd.g_old_rec.target_duration

Line 256: => per_ctk_shd.g_old_rec.mandatory_flag

252: => per_ctk_shd.g_old_rec.ame_attribute_identifier
253: ,p_description_o
254: => per_ctk_shd.g_old_rec.description
255: ,p_mandatory_flag_o
256: => per_ctk_shd.g_old_rec.mandatory_flag
257: ,p_target_duration_o
258: => per_ctk_shd.g_old_rec.target_duration
259: ,p_target_duration_uom_o
260: => per_ctk_shd.g_old_rec.target_duration_uom

Line 258: => per_ctk_shd.g_old_rec.target_duration

254: => per_ctk_shd.g_old_rec.description
255: ,p_mandatory_flag_o
256: => per_ctk_shd.g_old_rec.mandatory_flag
257: ,p_target_duration_o
258: => per_ctk_shd.g_old_rec.target_duration
259: ,p_target_duration_uom_o
260: => per_ctk_shd.g_old_rec.target_duration_uom
261: ,p_task_sequence_o
262: => per_ctk_shd.g_old_rec.task_sequence

Line 260: => per_ctk_shd.g_old_rec.target_duration_uom

256: => per_ctk_shd.g_old_rec.mandatory_flag
257: ,p_target_duration_o
258: => per_ctk_shd.g_old_rec.target_duration
259: ,p_target_duration_uom_o
260: => per_ctk_shd.g_old_rec.target_duration_uom
261: ,p_task_sequence_o
262: => per_ctk_shd.g_old_rec.task_sequence
263: ,p_object_version_number_o
264: => per_ctk_shd.g_old_rec.object_version_number

Line 262: => per_ctk_shd.g_old_rec.task_sequence

258: => per_ctk_shd.g_old_rec.target_duration
259: ,p_target_duration_uom_o
260: => per_ctk_shd.g_old_rec.target_duration_uom
261: ,p_task_sequence_o
262: => per_ctk_shd.g_old_rec.task_sequence
263: ,p_object_version_number_o
264: => per_ctk_shd.g_old_rec.object_version_number
265: ,p_action_url_o
266: => per_ctk_shd.g_old_rec.action_url

Line 264: => per_ctk_shd.g_old_rec.object_version_number

260: => per_ctk_shd.g_old_rec.target_duration_uom
261: ,p_task_sequence_o
262: => per_ctk_shd.g_old_rec.task_sequence
263: ,p_object_version_number_o
264: => per_ctk_shd.g_old_rec.object_version_number
265: ,p_action_url_o
266: => per_ctk_shd.g_old_rec.action_url
267: ,p_attribute_category_o
268: => per_ctk_shd.g_old_rec.attribute_category

Line 266: => per_ctk_shd.g_old_rec.action_url

262: => per_ctk_shd.g_old_rec.task_sequence
263: ,p_object_version_number_o
264: => per_ctk_shd.g_old_rec.object_version_number
265: ,p_action_url_o
266: => per_ctk_shd.g_old_rec.action_url
267: ,p_attribute_category_o
268: => per_ctk_shd.g_old_rec.attribute_category
269: ,p_attribute1_o
270: => per_ctk_shd.g_old_rec.attribute1

Line 268: => per_ctk_shd.g_old_rec.attribute_category

264: => per_ctk_shd.g_old_rec.object_version_number
265: ,p_action_url_o
266: => per_ctk_shd.g_old_rec.action_url
267: ,p_attribute_category_o
268: => per_ctk_shd.g_old_rec.attribute_category
269: ,p_attribute1_o
270: => per_ctk_shd.g_old_rec.attribute1
271: ,p_attribute2_o
272: => per_ctk_shd.g_old_rec.attribute2

Line 270: => per_ctk_shd.g_old_rec.attribute1

266: => per_ctk_shd.g_old_rec.action_url
267: ,p_attribute_category_o
268: => per_ctk_shd.g_old_rec.attribute_category
269: ,p_attribute1_o
270: => per_ctk_shd.g_old_rec.attribute1
271: ,p_attribute2_o
272: => per_ctk_shd.g_old_rec.attribute2
273: ,p_attribute3_o
274: => per_ctk_shd.g_old_rec.attribute3

Line 272: => per_ctk_shd.g_old_rec.attribute2

268: => per_ctk_shd.g_old_rec.attribute_category
269: ,p_attribute1_o
270: => per_ctk_shd.g_old_rec.attribute1
271: ,p_attribute2_o
272: => per_ctk_shd.g_old_rec.attribute2
273: ,p_attribute3_o
274: => per_ctk_shd.g_old_rec.attribute3
275: ,p_attribute4_o
276: => per_ctk_shd.g_old_rec.attribute4

Line 274: => per_ctk_shd.g_old_rec.attribute3

270: => per_ctk_shd.g_old_rec.attribute1
271: ,p_attribute2_o
272: => per_ctk_shd.g_old_rec.attribute2
273: ,p_attribute3_o
274: => per_ctk_shd.g_old_rec.attribute3
275: ,p_attribute4_o
276: => per_ctk_shd.g_old_rec.attribute4
277: ,p_attribute5_o
278: => per_ctk_shd.g_old_rec.attribute5

Line 276: => per_ctk_shd.g_old_rec.attribute4

272: => per_ctk_shd.g_old_rec.attribute2
273: ,p_attribute3_o
274: => per_ctk_shd.g_old_rec.attribute3
275: ,p_attribute4_o
276: => per_ctk_shd.g_old_rec.attribute4
277: ,p_attribute5_o
278: => per_ctk_shd.g_old_rec.attribute5
279: ,p_attribute6_o
280: => per_ctk_shd.g_old_rec.attribute6

Line 278: => per_ctk_shd.g_old_rec.attribute5

274: => per_ctk_shd.g_old_rec.attribute3
275: ,p_attribute4_o
276: => per_ctk_shd.g_old_rec.attribute4
277: ,p_attribute5_o
278: => per_ctk_shd.g_old_rec.attribute5
279: ,p_attribute6_o
280: => per_ctk_shd.g_old_rec.attribute6
281: ,p_attribute7_o
282: => per_ctk_shd.g_old_rec.attribute7

Line 280: => per_ctk_shd.g_old_rec.attribute6

276: => per_ctk_shd.g_old_rec.attribute4
277: ,p_attribute5_o
278: => per_ctk_shd.g_old_rec.attribute5
279: ,p_attribute6_o
280: => per_ctk_shd.g_old_rec.attribute6
281: ,p_attribute7_o
282: => per_ctk_shd.g_old_rec.attribute7
283: ,p_attribute8_o
284: => per_ctk_shd.g_old_rec.attribute8

Line 282: => per_ctk_shd.g_old_rec.attribute7

278: => per_ctk_shd.g_old_rec.attribute5
279: ,p_attribute6_o
280: => per_ctk_shd.g_old_rec.attribute6
281: ,p_attribute7_o
282: => per_ctk_shd.g_old_rec.attribute7
283: ,p_attribute8_o
284: => per_ctk_shd.g_old_rec.attribute8
285: ,p_attribute9_o
286: => per_ctk_shd.g_old_rec.attribute9

Line 284: => per_ctk_shd.g_old_rec.attribute8

280: => per_ctk_shd.g_old_rec.attribute6
281: ,p_attribute7_o
282: => per_ctk_shd.g_old_rec.attribute7
283: ,p_attribute8_o
284: => per_ctk_shd.g_old_rec.attribute8
285: ,p_attribute9_o
286: => per_ctk_shd.g_old_rec.attribute9
287: ,p_attribute10_o
288: => per_ctk_shd.g_old_rec.attribute10

Line 286: => per_ctk_shd.g_old_rec.attribute9

282: => per_ctk_shd.g_old_rec.attribute7
283: ,p_attribute8_o
284: => per_ctk_shd.g_old_rec.attribute8
285: ,p_attribute9_o
286: => per_ctk_shd.g_old_rec.attribute9
287: ,p_attribute10_o
288: => per_ctk_shd.g_old_rec.attribute10
289: ,p_attribute11_o
290: => per_ctk_shd.g_old_rec.attribute11

Line 288: => per_ctk_shd.g_old_rec.attribute10

284: => per_ctk_shd.g_old_rec.attribute8
285: ,p_attribute9_o
286: => per_ctk_shd.g_old_rec.attribute9
287: ,p_attribute10_o
288: => per_ctk_shd.g_old_rec.attribute10
289: ,p_attribute11_o
290: => per_ctk_shd.g_old_rec.attribute11
291: ,p_attribute12_o
292: => per_ctk_shd.g_old_rec.attribute12

Line 290: => per_ctk_shd.g_old_rec.attribute11

286: => per_ctk_shd.g_old_rec.attribute9
287: ,p_attribute10_o
288: => per_ctk_shd.g_old_rec.attribute10
289: ,p_attribute11_o
290: => per_ctk_shd.g_old_rec.attribute11
291: ,p_attribute12_o
292: => per_ctk_shd.g_old_rec.attribute12
293: ,p_attribute13_o
294: => per_ctk_shd.g_old_rec.attribute13

Line 292: => per_ctk_shd.g_old_rec.attribute12

288: => per_ctk_shd.g_old_rec.attribute10
289: ,p_attribute11_o
290: => per_ctk_shd.g_old_rec.attribute11
291: ,p_attribute12_o
292: => per_ctk_shd.g_old_rec.attribute12
293: ,p_attribute13_o
294: => per_ctk_shd.g_old_rec.attribute13
295: ,p_attribute14_o
296: => per_ctk_shd.g_old_rec.attribute14

Line 294: => per_ctk_shd.g_old_rec.attribute13

290: => per_ctk_shd.g_old_rec.attribute11
291: ,p_attribute12_o
292: => per_ctk_shd.g_old_rec.attribute12
293: ,p_attribute13_o
294: => per_ctk_shd.g_old_rec.attribute13
295: ,p_attribute14_o
296: => per_ctk_shd.g_old_rec.attribute14
297: ,p_attribute15_o
298: => per_ctk_shd.g_old_rec.attribute15

Line 296: => per_ctk_shd.g_old_rec.attribute14

292: => per_ctk_shd.g_old_rec.attribute12
293: ,p_attribute13_o
294: => per_ctk_shd.g_old_rec.attribute13
295: ,p_attribute14_o
296: => per_ctk_shd.g_old_rec.attribute14
297: ,p_attribute15_o
298: => per_ctk_shd.g_old_rec.attribute15
299: ,p_attribute16_o
300: => per_ctk_shd.g_old_rec.attribute16

Line 298: => per_ctk_shd.g_old_rec.attribute15

294: => per_ctk_shd.g_old_rec.attribute13
295: ,p_attribute14_o
296: => per_ctk_shd.g_old_rec.attribute14
297: ,p_attribute15_o
298: => per_ctk_shd.g_old_rec.attribute15
299: ,p_attribute16_o
300: => per_ctk_shd.g_old_rec.attribute16
301: ,p_attribute17_o
302: => per_ctk_shd.g_old_rec.attribute17

Line 300: => per_ctk_shd.g_old_rec.attribute16

296: => per_ctk_shd.g_old_rec.attribute14
297: ,p_attribute15_o
298: => per_ctk_shd.g_old_rec.attribute15
299: ,p_attribute16_o
300: => per_ctk_shd.g_old_rec.attribute16
301: ,p_attribute17_o
302: => per_ctk_shd.g_old_rec.attribute17
303: ,p_attribute18_o
304: => per_ctk_shd.g_old_rec.attribute18

Line 302: => per_ctk_shd.g_old_rec.attribute17

298: => per_ctk_shd.g_old_rec.attribute15
299: ,p_attribute16_o
300: => per_ctk_shd.g_old_rec.attribute16
301: ,p_attribute17_o
302: => per_ctk_shd.g_old_rec.attribute17
303: ,p_attribute18_o
304: => per_ctk_shd.g_old_rec.attribute18
305: ,p_attribute19_o
306: => per_ctk_shd.g_old_rec.attribute19

Line 304: => per_ctk_shd.g_old_rec.attribute18

300: => per_ctk_shd.g_old_rec.attribute16
301: ,p_attribute17_o
302: => per_ctk_shd.g_old_rec.attribute17
303: ,p_attribute18_o
304: => per_ctk_shd.g_old_rec.attribute18
305: ,p_attribute19_o
306: => per_ctk_shd.g_old_rec.attribute19
307: ,p_attribute20_o
308: => per_ctk_shd.g_old_rec.attribute20

Line 306: => per_ctk_shd.g_old_rec.attribute19

302: => per_ctk_shd.g_old_rec.attribute17
303: ,p_attribute18_o
304: => per_ctk_shd.g_old_rec.attribute18
305: ,p_attribute19_o
306: => per_ctk_shd.g_old_rec.attribute19
307: ,p_attribute20_o
308: => per_ctk_shd.g_old_rec.attribute20
309: ,p_information_category_o
310: => per_ctk_shd.g_old_rec.information_category

Line 308: => per_ctk_shd.g_old_rec.attribute20

304: => per_ctk_shd.g_old_rec.attribute18
305: ,p_attribute19_o
306: => per_ctk_shd.g_old_rec.attribute19
307: ,p_attribute20_o
308: => per_ctk_shd.g_old_rec.attribute20
309: ,p_information_category_o
310: => per_ctk_shd.g_old_rec.information_category
311: ,p_information1_o
312: => per_ctk_shd.g_old_rec.information1

Line 310: => per_ctk_shd.g_old_rec.information_category

306: => per_ctk_shd.g_old_rec.attribute19
307: ,p_attribute20_o
308: => per_ctk_shd.g_old_rec.attribute20
309: ,p_information_category_o
310: => per_ctk_shd.g_old_rec.information_category
311: ,p_information1_o
312: => per_ctk_shd.g_old_rec.information1
313: ,p_information2_o
314: => per_ctk_shd.g_old_rec.information2

Line 312: => per_ctk_shd.g_old_rec.information1

308: => per_ctk_shd.g_old_rec.attribute20
309: ,p_information_category_o
310: => per_ctk_shd.g_old_rec.information_category
311: ,p_information1_o
312: => per_ctk_shd.g_old_rec.information1
313: ,p_information2_o
314: => per_ctk_shd.g_old_rec.information2
315: ,p_information3_o
316: => per_ctk_shd.g_old_rec.information3

Line 314: => per_ctk_shd.g_old_rec.information2

310: => per_ctk_shd.g_old_rec.information_category
311: ,p_information1_o
312: => per_ctk_shd.g_old_rec.information1
313: ,p_information2_o
314: => per_ctk_shd.g_old_rec.information2
315: ,p_information3_o
316: => per_ctk_shd.g_old_rec.information3
317: ,p_information4_o
318: => per_ctk_shd.g_old_rec.information4

Line 316: => per_ctk_shd.g_old_rec.information3

312: => per_ctk_shd.g_old_rec.information1
313: ,p_information2_o
314: => per_ctk_shd.g_old_rec.information2
315: ,p_information3_o
316: => per_ctk_shd.g_old_rec.information3
317: ,p_information4_o
318: => per_ctk_shd.g_old_rec.information4
319: ,p_information5_o
320: => per_ctk_shd.g_old_rec.information5

Line 318: => per_ctk_shd.g_old_rec.information4

314: => per_ctk_shd.g_old_rec.information2
315: ,p_information3_o
316: => per_ctk_shd.g_old_rec.information3
317: ,p_information4_o
318: => per_ctk_shd.g_old_rec.information4
319: ,p_information5_o
320: => per_ctk_shd.g_old_rec.information5
321: ,p_information6_o
322: => per_ctk_shd.g_old_rec.information6

Line 320: => per_ctk_shd.g_old_rec.information5

316: => per_ctk_shd.g_old_rec.information3
317: ,p_information4_o
318: => per_ctk_shd.g_old_rec.information4
319: ,p_information5_o
320: => per_ctk_shd.g_old_rec.information5
321: ,p_information6_o
322: => per_ctk_shd.g_old_rec.information6
323: ,p_information7_o
324: => per_ctk_shd.g_old_rec.information7

Line 322: => per_ctk_shd.g_old_rec.information6

318: => per_ctk_shd.g_old_rec.information4
319: ,p_information5_o
320: => per_ctk_shd.g_old_rec.information5
321: ,p_information6_o
322: => per_ctk_shd.g_old_rec.information6
323: ,p_information7_o
324: => per_ctk_shd.g_old_rec.information7
325: ,p_information8_o
326: => per_ctk_shd.g_old_rec.information8

Line 324: => per_ctk_shd.g_old_rec.information7

320: => per_ctk_shd.g_old_rec.information5
321: ,p_information6_o
322: => per_ctk_shd.g_old_rec.information6
323: ,p_information7_o
324: => per_ctk_shd.g_old_rec.information7
325: ,p_information8_o
326: => per_ctk_shd.g_old_rec.information8
327: ,p_information9_o
328: => per_ctk_shd.g_old_rec.information9

Line 326: => per_ctk_shd.g_old_rec.information8

322: => per_ctk_shd.g_old_rec.information6
323: ,p_information7_o
324: => per_ctk_shd.g_old_rec.information7
325: ,p_information8_o
326: => per_ctk_shd.g_old_rec.information8
327: ,p_information9_o
328: => per_ctk_shd.g_old_rec.information9
329: ,p_information10_o
330: => per_ctk_shd.g_old_rec.information10

Line 328: => per_ctk_shd.g_old_rec.information9

324: => per_ctk_shd.g_old_rec.information7
325: ,p_information8_o
326: => per_ctk_shd.g_old_rec.information8
327: ,p_information9_o
328: => per_ctk_shd.g_old_rec.information9
329: ,p_information10_o
330: => per_ctk_shd.g_old_rec.information10
331: ,p_information11_o
332: => per_ctk_shd.g_old_rec.information11

Line 330: => per_ctk_shd.g_old_rec.information10

326: => per_ctk_shd.g_old_rec.information8
327: ,p_information9_o
328: => per_ctk_shd.g_old_rec.information9
329: ,p_information10_o
330: => per_ctk_shd.g_old_rec.information10
331: ,p_information11_o
332: => per_ctk_shd.g_old_rec.information11
333: ,p_information12_o
334: => per_ctk_shd.g_old_rec.information12

Line 332: => per_ctk_shd.g_old_rec.information11

328: => per_ctk_shd.g_old_rec.information9
329: ,p_information10_o
330: => per_ctk_shd.g_old_rec.information10
331: ,p_information11_o
332: => per_ctk_shd.g_old_rec.information11
333: ,p_information12_o
334: => per_ctk_shd.g_old_rec.information12
335: ,p_information13_o
336: => per_ctk_shd.g_old_rec.information13

Line 334: => per_ctk_shd.g_old_rec.information12

330: => per_ctk_shd.g_old_rec.information10
331: ,p_information11_o
332: => per_ctk_shd.g_old_rec.information11
333: ,p_information12_o
334: => per_ctk_shd.g_old_rec.information12
335: ,p_information13_o
336: => per_ctk_shd.g_old_rec.information13
337: ,p_information14_o
338: => per_ctk_shd.g_old_rec.information14

Line 336: => per_ctk_shd.g_old_rec.information13

332: => per_ctk_shd.g_old_rec.information11
333: ,p_information12_o
334: => per_ctk_shd.g_old_rec.information12
335: ,p_information13_o
336: => per_ctk_shd.g_old_rec.information13
337: ,p_information14_o
338: => per_ctk_shd.g_old_rec.information14
339: ,p_information15_o
340: => per_ctk_shd.g_old_rec.information15

Line 338: => per_ctk_shd.g_old_rec.information14

334: => per_ctk_shd.g_old_rec.information12
335: ,p_information13_o
336: => per_ctk_shd.g_old_rec.information13
337: ,p_information14_o
338: => per_ctk_shd.g_old_rec.information14
339: ,p_information15_o
340: => per_ctk_shd.g_old_rec.information15
341: ,p_information16_o
342: => per_ctk_shd.g_old_rec.information16

Line 340: => per_ctk_shd.g_old_rec.information15

336: => per_ctk_shd.g_old_rec.information13
337: ,p_information14_o
338: => per_ctk_shd.g_old_rec.information14
339: ,p_information15_o
340: => per_ctk_shd.g_old_rec.information15
341: ,p_information16_o
342: => per_ctk_shd.g_old_rec.information16
343: ,p_information17_o
344: => per_ctk_shd.g_old_rec.information17

Line 342: => per_ctk_shd.g_old_rec.information16

338: => per_ctk_shd.g_old_rec.information14
339: ,p_information15_o
340: => per_ctk_shd.g_old_rec.information15
341: ,p_information16_o
342: => per_ctk_shd.g_old_rec.information16
343: ,p_information17_o
344: => per_ctk_shd.g_old_rec.information17
345: ,p_information18_o
346: => per_ctk_shd.g_old_rec.information18

Line 344: => per_ctk_shd.g_old_rec.information17

340: => per_ctk_shd.g_old_rec.information15
341: ,p_information16_o
342: => per_ctk_shd.g_old_rec.information16
343: ,p_information17_o
344: => per_ctk_shd.g_old_rec.information17
345: ,p_information18_o
346: => per_ctk_shd.g_old_rec.information18
347: ,p_information19_o
348: => per_ctk_shd.g_old_rec.information19

Line 346: => per_ctk_shd.g_old_rec.information18

342: => per_ctk_shd.g_old_rec.information16
343: ,p_information17_o
344: => per_ctk_shd.g_old_rec.information17
345: ,p_information18_o
346: => per_ctk_shd.g_old_rec.information18
347: ,p_information19_o
348: => per_ctk_shd.g_old_rec.information19
349: ,p_information20_o
350: => per_ctk_shd.g_old_rec.information20

Line 348: => per_ctk_shd.g_old_rec.information19

344: => per_ctk_shd.g_old_rec.information17
345: ,p_information18_o
346: => per_ctk_shd.g_old_rec.information18
347: ,p_information19_o
348: => per_ctk_shd.g_old_rec.information19
349: ,p_information20_o
350: => per_ctk_shd.g_old_rec.information20
351: );
352: --

Line 350: => per_ctk_shd.g_old_rec.information20

346: => per_ctk_shd.g_old_rec.information18
347: ,p_information19_o
348: => per_ctk_shd.g_old_rec.information19
349: ,p_information20_o
350: => per_ctk_shd.g_old_rec.information20
351: );
352: --
353: exception
354: --

Line 370: (p_rec in per_ctk_shd.g_rec_type

366: -- ----------------------------------------------------------------------------
367: -- |---------------------------------< del >----------------------------------|
368: -- ----------------------------------------------------------------------------
369: Procedure del
370: (p_rec in per_ctk_shd.g_rec_type
371: ) is
372: --
373: l_proc varchar2(72) := g_package||'del';
374: --

Line 380: per_ctk_shd.lck

376: hr_utility.set_location('Entering:'||l_proc, 5);
377: --
378: -- We must lock the row which we need to delete.
379: --
380: per_ctk_shd.lck
381: (p_rec.task_in_checklist_id
382: ,p_rec.object_version_number
383: );
384: --

Line 417: l_rec per_ctk_shd.g_rec_type;

413: (p_task_in_checklist_id in number
414: ,p_object_version_number in number
415: ) is
416: --
417: l_rec per_ctk_shd.g_rec_type;
418: l_proc varchar2(72) := g_package||'del';
419: --
420: Begin
421: hr_utility.set_location('Entering:'||l_proc, 5);