APPS.HR_CLE_DEL dependencies on HR_CLE_SHD

Line 54: (p_rec in out nocopy hr_cle_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy hr_cle_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 97: (p_rec in out nocopy hr_cle_shd.g_rec_type

93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy hr_cle_shd.g_rec_type
98: ,p_effective_date in date
99: ,p_datetrack_mode in varchar2
100: ,p_validation_start_date in date
101: ,p_validation_end_date in date

Line 154: (p_rec in out nocopy hr_cle_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy hr_cle_shd.g_rec_type
155: ,p_effective_date in date
156: ,p_datetrack_mode in varchar2
157: ,p_validation_start_date in date
158: ,p_validation_end_date in date

Line 169: := hr_cle_shd.g_old_rec.effective_start_date;

165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.effective_start_date
169: := hr_cle_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = hr_api.g_delete) then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else

Line 179: hr_cle_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: hr_cle_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date
181: ,p_base_key_value => p_rec.soc_ins_contr_lvls_id
182: ,p_new_effective_end_date => p_rec.effective_end_date
183: ,p_validation_start_date => p_validation_start_date

Line 228: (p_rec in out nocopy hr_cle_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_delete
228: (p_rec in out nocopy hr_cle_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date

Line 288: (p_rec in hr_cle_shd.g_rec_type

284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure post_delete
288: (p_rec in hr_cle_shd.g_rec_type
289: ,p_effective_date in date
290: ,p_datetrack_mode in varchar2
291: ,p_validation_start_date in date
292: ,p_validation_end_date in date

Line 317: => hr_cle_shd.g_old_rec.organization_id

313: => p_rec.effective_start_date
314: ,p_effective_end_date
315: => p_rec.effective_end_date
316: ,p_organization_id_o
317: => hr_cle_shd.g_old_rec.organization_id
318: ,p_normal_percentage_o
319: => hr_cle_shd.g_old_rec.normal_percentage
320: ,p_normal_amount_o
321: => hr_cle_shd.g_old_rec.normal_amount

Line 319: => hr_cle_shd.g_old_rec.normal_percentage

315: => p_rec.effective_end_date
316: ,p_organization_id_o
317: => hr_cle_shd.g_old_rec.organization_id
318: ,p_normal_percentage_o
319: => hr_cle_shd.g_old_rec.normal_percentage
320: ,p_normal_amount_o
321: => hr_cle_shd.g_old_rec.normal_amount
322: ,p_increased_percentage_o
323: => hr_cle_shd.g_old_rec.increased_percentage

Line 321: => hr_cle_shd.g_old_rec.normal_amount

317: => hr_cle_shd.g_old_rec.organization_id
318: ,p_normal_percentage_o
319: => hr_cle_shd.g_old_rec.normal_percentage
320: ,p_normal_amount_o
321: => hr_cle_shd.g_old_rec.normal_amount
322: ,p_increased_percentage_o
323: => hr_cle_shd.g_old_rec.increased_percentage
324: ,p_increased_amount_o
325: => hr_cle_shd.g_old_rec.increased_amount

Line 323: => hr_cle_shd.g_old_rec.increased_percentage

319: => hr_cle_shd.g_old_rec.normal_percentage
320: ,p_normal_amount_o
321: => hr_cle_shd.g_old_rec.normal_amount
322: ,p_increased_percentage_o
323: => hr_cle_shd.g_old_rec.increased_percentage
324: ,p_increased_amount_o
325: => hr_cle_shd.g_old_rec.increased_amount
326: ,p_reduced_percentage_o
327: => hr_cle_shd.g_old_rec.reduced_percentage

Line 325: => hr_cle_shd.g_old_rec.increased_amount

321: => hr_cle_shd.g_old_rec.normal_amount
322: ,p_increased_percentage_o
323: => hr_cle_shd.g_old_rec.increased_percentage
324: ,p_increased_amount_o
325: => hr_cle_shd.g_old_rec.increased_amount
326: ,p_reduced_percentage_o
327: => hr_cle_shd.g_old_rec.reduced_percentage
328: ,p_reduced_amount_o
329: => hr_cle_shd.g_old_rec.reduced_amount

Line 327: => hr_cle_shd.g_old_rec.reduced_percentage

323: => hr_cle_shd.g_old_rec.increased_percentage
324: ,p_increased_amount_o
325: => hr_cle_shd.g_old_rec.increased_amount
326: ,p_reduced_percentage_o
327: => hr_cle_shd.g_old_rec.reduced_percentage
328: ,p_reduced_amount_o
329: => hr_cle_shd.g_old_rec.reduced_amount
330: ,p_effective_start_date_o
331: => hr_cle_shd.g_old_rec.effective_start_date

Line 329: => hr_cle_shd.g_old_rec.reduced_amount

325: => hr_cle_shd.g_old_rec.increased_amount
326: ,p_reduced_percentage_o
327: => hr_cle_shd.g_old_rec.reduced_percentage
328: ,p_reduced_amount_o
329: => hr_cle_shd.g_old_rec.reduced_amount
330: ,p_effective_start_date_o
331: => hr_cle_shd.g_old_rec.effective_start_date
332: ,p_effective_end_date_o
333: => hr_cle_shd.g_old_rec.effective_end_date

Line 331: => hr_cle_shd.g_old_rec.effective_start_date

327: => hr_cle_shd.g_old_rec.reduced_percentage
328: ,p_reduced_amount_o
329: => hr_cle_shd.g_old_rec.reduced_amount
330: ,p_effective_start_date_o
331: => hr_cle_shd.g_old_rec.effective_start_date
332: ,p_effective_end_date_o
333: => hr_cle_shd.g_old_rec.effective_end_date
334: ,p_attribute_category_o
335: => hr_cle_shd.g_old_rec.attribute_category

Line 333: => hr_cle_shd.g_old_rec.effective_end_date

329: => hr_cle_shd.g_old_rec.reduced_amount
330: ,p_effective_start_date_o
331: => hr_cle_shd.g_old_rec.effective_start_date
332: ,p_effective_end_date_o
333: => hr_cle_shd.g_old_rec.effective_end_date
334: ,p_attribute_category_o
335: => hr_cle_shd.g_old_rec.attribute_category
336: ,p_attribute1_o
337: => hr_cle_shd.g_old_rec.attribute1

Line 335: => hr_cle_shd.g_old_rec.attribute_category

331: => hr_cle_shd.g_old_rec.effective_start_date
332: ,p_effective_end_date_o
333: => hr_cle_shd.g_old_rec.effective_end_date
334: ,p_attribute_category_o
335: => hr_cle_shd.g_old_rec.attribute_category
336: ,p_attribute1_o
337: => hr_cle_shd.g_old_rec.attribute1
338: ,p_attribute2_o
339: => hr_cle_shd.g_old_rec.attribute2

Line 337: => hr_cle_shd.g_old_rec.attribute1

333: => hr_cle_shd.g_old_rec.effective_end_date
334: ,p_attribute_category_o
335: => hr_cle_shd.g_old_rec.attribute_category
336: ,p_attribute1_o
337: => hr_cle_shd.g_old_rec.attribute1
338: ,p_attribute2_o
339: => hr_cle_shd.g_old_rec.attribute2
340: ,p_attribute3_o
341: => hr_cle_shd.g_old_rec.attribute3

Line 339: => hr_cle_shd.g_old_rec.attribute2

335: => hr_cle_shd.g_old_rec.attribute_category
336: ,p_attribute1_o
337: => hr_cle_shd.g_old_rec.attribute1
338: ,p_attribute2_o
339: => hr_cle_shd.g_old_rec.attribute2
340: ,p_attribute3_o
341: => hr_cle_shd.g_old_rec.attribute3
342: ,p_attribute4_o
343: => hr_cle_shd.g_old_rec.attribute4

Line 341: => hr_cle_shd.g_old_rec.attribute3

337: => hr_cle_shd.g_old_rec.attribute1
338: ,p_attribute2_o
339: => hr_cle_shd.g_old_rec.attribute2
340: ,p_attribute3_o
341: => hr_cle_shd.g_old_rec.attribute3
342: ,p_attribute4_o
343: => hr_cle_shd.g_old_rec.attribute4
344: ,p_attribute5_o
345: => hr_cle_shd.g_old_rec.attribute5

Line 343: => hr_cle_shd.g_old_rec.attribute4

339: => hr_cle_shd.g_old_rec.attribute2
340: ,p_attribute3_o
341: => hr_cle_shd.g_old_rec.attribute3
342: ,p_attribute4_o
343: => hr_cle_shd.g_old_rec.attribute4
344: ,p_attribute5_o
345: => hr_cle_shd.g_old_rec.attribute5
346: ,p_attribute6_o
347: => hr_cle_shd.g_old_rec.attribute6

Line 345: => hr_cle_shd.g_old_rec.attribute5

341: => hr_cle_shd.g_old_rec.attribute3
342: ,p_attribute4_o
343: => hr_cle_shd.g_old_rec.attribute4
344: ,p_attribute5_o
345: => hr_cle_shd.g_old_rec.attribute5
346: ,p_attribute6_o
347: => hr_cle_shd.g_old_rec.attribute6
348: ,p_attribute7_o
349: => hr_cle_shd.g_old_rec.attribute7

Line 347: => hr_cle_shd.g_old_rec.attribute6

343: => hr_cle_shd.g_old_rec.attribute4
344: ,p_attribute5_o
345: => hr_cle_shd.g_old_rec.attribute5
346: ,p_attribute6_o
347: => hr_cle_shd.g_old_rec.attribute6
348: ,p_attribute7_o
349: => hr_cle_shd.g_old_rec.attribute7
350: ,p_attribute8_o
351: => hr_cle_shd.g_old_rec.attribute8

Line 349: => hr_cle_shd.g_old_rec.attribute7

345: => hr_cle_shd.g_old_rec.attribute5
346: ,p_attribute6_o
347: => hr_cle_shd.g_old_rec.attribute6
348: ,p_attribute7_o
349: => hr_cle_shd.g_old_rec.attribute7
350: ,p_attribute8_o
351: => hr_cle_shd.g_old_rec.attribute8
352: ,p_attribute9_o
353: => hr_cle_shd.g_old_rec.attribute9

Line 351: => hr_cle_shd.g_old_rec.attribute8

347: => hr_cle_shd.g_old_rec.attribute6
348: ,p_attribute7_o
349: => hr_cle_shd.g_old_rec.attribute7
350: ,p_attribute8_o
351: => hr_cle_shd.g_old_rec.attribute8
352: ,p_attribute9_o
353: => hr_cle_shd.g_old_rec.attribute9
354: ,p_attribute10_o
355: => hr_cle_shd.g_old_rec.attribute10

Line 353: => hr_cle_shd.g_old_rec.attribute9

349: => hr_cle_shd.g_old_rec.attribute7
350: ,p_attribute8_o
351: => hr_cle_shd.g_old_rec.attribute8
352: ,p_attribute9_o
353: => hr_cle_shd.g_old_rec.attribute9
354: ,p_attribute10_o
355: => hr_cle_shd.g_old_rec.attribute10
356: ,p_attribute11_o
357: => hr_cle_shd.g_old_rec.attribute11

Line 355: => hr_cle_shd.g_old_rec.attribute10

351: => hr_cle_shd.g_old_rec.attribute8
352: ,p_attribute9_o
353: => hr_cle_shd.g_old_rec.attribute9
354: ,p_attribute10_o
355: => hr_cle_shd.g_old_rec.attribute10
356: ,p_attribute11_o
357: => hr_cle_shd.g_old_rec.attribute11
358: ,p_attribute12_o
359: => hr_cle_shd.g_old_rec.attribute12

Line 357: => hr_cle_shd.g_old_rec.attribute11

353: => hr_cle_shd.g_old_rec.attribute9
354: ,p_attribute10_o
355: => hr_cle_shd.g_old_rec.attribute10
356: ,p_attribute11_o
357: => hr_cle_shd.g_old_rec.attribute11
358: ,p_attribute12_o
359: => hr_cle_shd.g_old_rec.attribute12
360: ,p_attribute13_o
361: => hr_cle_shd.g_old_rec.attribute13

Line 359: => hr_cle_shd.g_old_rec.attribute12

355: => hr_cle_shd.g_old_rec.attribute10
356: ,p_attribute11_o
357: => hr_cle_shd.g_old_rec.attribute11
358: ,p_attribute12_o
359: => hr_cle_shd.g_old_rec.attribute12
360: ,p_attribute13_o
361: => hr_cle_shd.g_old_rec.attribute13
362: ,p_attribute14_o
363: => hr_cle_shd.g_old_rec.attribute14

Line 361: => hr_cle_shd.g_old_rec.attribute13

357: => hr_cle_shd.g_old_rec.attribute11
358: ,p_attribute12_o
359: => hr_cle_shd.g_old_rec.attribute12
360: ,p_attribute13_o
361: => hr_cle_shd.g_old_rec.attribute13
362: ,p_attribute14_o
363: => hr_cle_shd.g_old_rec.attribute14
364: ,p_attribute15_o
365: => hr_cle_shd.g_old_rec.attribute15

Line 363: => hr_cle_shd.g_old_rec.attribute14

359: => hr_cle_shd.g_old_rec.attribute12
360: ,p_attribute13_o
361: => hr_cle_shd.g_old_rec.attribute13
362: ,p_attribute14_o
363: => hr_cle_shd.g_old_rec.attribute14
364: ,p_attribute15_o
365: => hr_cle_shd.g_old_rec.attribute15
366: ,p_attribute16_o
367: => hr_cle_shd.g_old_rec.attribute16

Line 365: => hr_cle_shd.g_old_rec.attribute15

361: => hr_cle_shd.g_old_rec.attribute13
362: ,p_attribute14_o
363: => hr_cle_shd.g_old_rec.attribute14
364: ,p_attribute15_o
365: => hr_cle_shd.g_old_rec.attribute15
366: ,p_attribute16_o
367: => hr_cle_shd.g_old_rec.attribute16
368: ,p_attribute17_o
369: => hr_cle_shd.g_old_rec.attribute17

Line 367: => hr_cle_shd.g_old_rec.attribute16

363: => hr_cle_shd.g_old_rec.attribute14
364: ,p_attribute15_o
365: => hr_cle_shd.g_old_rec.attribute15
366: ,p_attribute16_o
367: => hr_cle_shd.g_old_rec.attribute16
368: ,p_attribute17_o
369: => hr_cle_shd.g_old_rec.attribute17
370: ,p_attribute18_o
371: => hr_cle_shd.g_old_rec.attribute18

Line 369: => hr_cle_shd.g_old_rec.attribute17

365: => hr_cle_shd.g_old_rec.attribute15
366: ,p_attribute16_o
367: => hr_cle_shd.g_old_rec.attribute16
368: ,p_attribute17_o
369: => hr_cle_shd.g_old_rec.attribute17
370: ,p_attribute18_o
371: => hr_cle_shd.g_old_rec.attribute18
372: ,p_attribute19_o
373: => hr_cle_shd.g_old_rec.attribute19

Line 371: => hr_cle_shd.g_old_rec.attribute18

367: => hr_cle_shd.g_old_rec.attribute16
368: ,p_attribute17_o
369: => hr_cle_shd.g_old_rec.attribute17
370: ,p_attribute18_o
371: => hr_cle_shd.g_old_rec.attribute18
372: ,p_attribute19_o
373: => hr_cle_shd.g_old_rec.attribute19
374: ,p_attribute20_o
375: => hr_cle_shd.g_old_rec.attribute20

Line 373: => hr_cle_shd.g_old_rec.attribute19

369: => hr_cle_shd.g_old_rec.attribute17
370: ,p_attribute18_o
371: => hr_cle_shd.g_old_rec.attribute18
372: ,p_attribute19_o
373: => hr_cle_shd.g_old_rec.attribute19
374: ,p_attribute20_o
375: => hr_cle_shd.g_old_rec.attribute20
376: ,p_object_version_number_o
377: => hr_cle_shd.g_old_rec.object_version_number

Line 375: => hr_cle_shd.g_old_rec.attribute20

371: => hr_cle_shd.g_old_rec.attribute18
372: ,p_attribute19_o
373: => hr_cle_shd.g_old_rec.attribute19
374: ,p_attribute20_o
375: => hr_cle_shd.g_old_rec.attribute20
376: ,p_object_version_number_o
377: => hr_cle_shd.g_old_rec.object_version_number
378: ,p_attribute21_o
379: => hr_cle_shd.g_old_rec.attribute21

Line 377: => hr_cle_shd.g_old_rec.object_version_number

373: => hr_cle_shd.g_old_rec.attribute19
374: ,p_attribute20_o
375: => hr_cle_shd.g_old_rec.attribute20
376: ,p_object_version_number_o
377: => hr_cle_shd.g_old_rec.object_version_number
378: ,p_attribute21_o
379: => hr_cle_shd.g_old_rec.attribute21
380: ,p_attribute22_o
381: => hr_cle_shd.g_old_rec.attribute22

Line 379: => hr_cle_shd.g_old_rec.attribute21

375: => hr_cle_shd.g_old_rec.attribute20
376: ,p_object_version_number_o
377: => hr_cle_shd.g_old_rec.object_version_number
378: ,p_attribute21_o
379: => hr_cle_shd.g_old_rec.attribute21
380: ,p_attribute22_o
381: => hr_cle_shd.g_old_rec.attribute22
382: ,p_attribute23_o
383: => hr_cle_shd.g_old_rec.attribute23

Line 381: => hr_cle_shd.g_old_rec.attribute22

377: => hr_cle_shd.g_old_rec.object_version_number
378: ,p_attribute21_o
379: => hr_cle_shd.g_old_rec.attribute21
380: ,p_attribute22_o
381: => hr_cle_shd.g_old_rec.attribute22
382: ,p_attribute23_o
383: => hr_cle_shd.g_old_rec.attribute23
384: ,p_attribute24_o
385: => hr_cle_shd.g_old_rec.attribute24

Line 383: => hr_cle_shd.g_old_rec.attribute23

379: => hr_cle_shd.g_old_rec.attribute21
380: ,p_attribute22_o
381: => hr_cle_shd.g_old_rec.attribute22
382: ,p_attribute23_o
383: => hr_cle_shd.g_old_rec.attribute23
384: ,p_attribute24_o
385: => hr_cle_shd.g_old_rec.attribute24
386: ,p_attribute25_o
387: => hr_cle_shd.g_old_rec.attribute25

Line 385: => hr_cle_shd.g_old_rec.attribute24

381: => hr_cle_shd.g_old_rec.attribute22
382: ,p_attribute23_o
383: => hr_cle_shd.g_old_rec.attribute23
384: ,p_attribute24_o
385: => hr_cle_shd.g_old_rec.attribute24
386: ,p_attribute25_o
387: => hr_cle_shd.g_old_rec.attribute25
388: ,p_attribute26_o
389: => hr_cle_shd.g_old_rec.attribute26

Line 387: => hr_cle_shd.g_old_rec.attribute25

383: => hr_cle_shd.g_old_rec.attribute23
384: ,p_attribute24_o
385: => hr_cle_shd.g_old_rec.attribute24
386: ,p_attribute25_o
387: => hr_cle_shd.g_old_rec.attribute25
388: ,p_attribute26_o
389: => hr_cle_shd.g_old_rec.attribute26
390: ,p_attribute27_o
391: => hr_cle_shd.g_old_rec.attribute27

Line 389: => hr_cle_shd.g_old_rec.attribute26

385: => hr_cle_shd.g_old_rec.attribute24
386: ,p_attribute25_o
387: => hr_cle_shd.g_old_rec.attribute25
388: ,p_attribute26_o
389: => hr_cle_shd.g_old_rec.attribute26
390: ,p_attribute27_o
391: => hr_cle_shd.g_old_rec.attribute27
392: ,p_attribute28_o
393: => hr_cle_shd.g_old_rec.attribute28

Line 391: => hr_cle_shd.g_old_rec.attribute27

387: => hr_cle_shd.g_old_rec.attribute25
388: ,p_attribute26_o
389: => hr_cle_shd.g_old_rec.attribute26
390: ,p_attribute27_o
391: => hr_cle_shd.g_old_rec.attribute27
392: ,p_attribute28_o
393: => hr_cle_shd.g_old_rec.attribute28
394: ,p_attribute29_o
395: => hr_cle_shd.g_old_rec.attribute29

Line 393: => hr_cle_shd.g_old_rec.attribute28

389: => hr_cle_shd.g_old_rec.attribute26
390: ,p_attribute27_o
391: => hr_cle_shd.g_old_rec.attribute27
392: ,p_attribute28_o
393: => hr_cle_shd.g_old_rec.attribute28
394: ,p_attribute29_o
395: => hr_cle_shd.g_old_rec.attribute29
396: ,p_attribute30_o
397: => hr_cle_shd.g_old_rec.attribute30

Line 395: => hr_cle_shd.g_old_rec.attribute29

391: => hr_cle_shd.g_old_rec.attribute27
392: ,p_attribute28_o
393: => hr_cle_shd.g_old_rec.attribute28
394: ,p_attribute29_o
395: => hr_cle_shd.g_old_rec.attribute29
396: ,p_attribute30_o
397: => hr_cle_shd.g_old_rec.attribute30
398: ,p_flat_tax_limit_per_month_o
399: => hr_cle_shd.g_old_rec.flat_tax_limit_per_month

Line 397: => hr_cle_shd.g_old_rec.attribute30

393: => hr_cle_shd.g_old_rec.attribute28
394: ,p_attribute29_o
395: => hr_cle_shd.g_old_rec.attribute29
396: ,p_attribute30_o
397: => hr_cle_shd.g_old_rec.attribute30
398: ,p_flat_tax_limit_per_month_o
399: => hr_cle_shd.g_old_rec.flat_tax_limit_per_month
400: ,p_flat_tax_limit_per_year_o
401: => hr_cle_shd.g_old_rec.flat_tax_limit_per_year

Line 399: => hr_cle_shd.g_old_rec.flat_tax_limit_per_month

395: => hr_cle_shd.g_old_rec.attribute29
396: ,p_attribute30_o
397: => hr_cle_shd.g_old_rec.attribute30
398: ,p_flat_tax_limit_per_month_o
399: => hr_cle_shd.g_old_rec.flat_tax_limit_per_month
400: ,p_flat_tax_limit_per_year_o
401: => hr_cle_shd.g_old_rec.flat_tax_limit_per_year
402: ,p_min_increased_contribution_o
403: => hr_cle_shd.g_old_rec.min_increased_contribution

Line 401: => hr_cle_shd.g_old_rec.flat_tax_limit_per_year

397: => hr_cle_shd.g_old_rec.attribute30
398: ,p_flat_tax_limit_per_month_o
399: => hr_cle_shd.g_old_rec.flat_tax_limit_per_month
400: ,p_flat_tax_limit_per_year_o
401: => hr_cle_shd.g_old_rec.flat_tax_limit_per_year
402: ,p_min_increased_contribution_o
403: => hr_cle_shd.g_old_rec.min_increased_contribution
404: ,p_max_increased_contribution_o
405: => hr_cle_shd.g_old_rec.max_increased_contribution

Line 403: => hr_cle_shd.g_old_rec.min_increased_contribution

399: => hr_cle_shd.g_old_rec.flat_tax_limit_per_month
400: ,p_flat_tax_limit_per_year_o
401: => hr_cle_shd.g_old_rec.flat_tax_limit_per_year
402: ,p_min_increased_contribution_o
403: => hr_cle_shd.g_old_rec.min_increased_contribution
404: ,p_max_increased_contribution_o
405: => hr_cle_shd.g_old_rec.max_increased_contribution
406: ,p_month1_o
407: => hr_cle_shd.g_old_rec.month1

Line 405: => hr_cle_shd.g_old_rec.max_increased_contribution

401: => hr_cle_shd.g_old_rec.flat_tax_limit_per_year
402: ,p_min_increased_contribution_o
403: => hr_cle_shd.g_old_rec.min_increased_contribution
404: ,p_max_increased_contribution_o
405: => hr_cle_shd.g_old_rec.max_increased_contribution
406: ,p_month1_o
407: => hr_cle_shd.g_old_rec.month1
408: ,p_month1_min_contribution_o
409: => hr_cle_shd.g_old_rec.month1_min_contribution

Line 407: => hr_cle_shd.g_old_rec.month1

403: => hr_cle_shd.g_old_rec.min_increased_contribution
404: ,p_max_increased_contribution_o
405: => hr_cle_shd.g_old_rec.max_increased_contribution
406: ,p_month1_o
407: => hr_cle_shd.g_old_rec.month1
408: ,p_month1_min_contribution_o
409: => hr_cle_shd.g_old_rec.month1_min_contribution
410: ,p_month1_max_contribution_o
411: => hr_cle_shd.g_old_rec.month1_max_contribution

Line 409: => hr_cle_shd.g_old_rec.month1_min_contribution

405: => hr_cle_shd.g_old_rec.max_increased_contribution
406: ,p_month1_o
407: => hr_cle_shd.g_old_rec.month1
408: ,p_month1_min_contribution_o
409: => hr_cle_shd.g_old_rec.month1_min_contribution
410: ,p_month1_max_contribution_o
411: => hr_cle_shd.g_old_rec.month1_max_contribution
412: ,p_month2_o
413: => hr_cle_shd.g_old_rec.month2

Line 411: => hr_cle_shd.g_old_rec.month1_max_contribution

407: => hr_cle_shd.g_old_rec.month1
408: ,p_month1_min_contribution_o
409: => hr_cle_shd.g_old_rec.month1_min_contribution
410: ,p_month1_max_contribution_o
411: => hr_cle_shd.g_old_rec.month1_max_contribution
412: ,p_month2_o
413: => hr_cle_shd.g_old_rec.month2
414: ,p_month2_min_contribution_o
415: => hr_cle_shd.g_old_rec.month2_min_contribution

Line 413: => hr_cle_shd.g_old_rec.month2

409: => hr_cle_shd.g_old_rec.month1_min_contribution
410: ,p_month1_max_contribution_o
411: => hr_cle_shd.g_old_rec.month1_max_contribution
412: ,p_month2_o
413: => hr_cle_shd.g_old_rec.month2
414: ,p_month2_min_contribution_o
415: => hr_cle_shd.g_old_rec.month2_min_contribution
416: ,p_month2_max_contribution_o
417: => hr_cle_shd.g_old_rec.month2_max_contribution

Line 415: => hr_cle_shd.g_old_rec.month2_min_contribution

411: => hr_cle_shd.g_old_rec.month1_max_contribution
412: ,p_month2_o
413: => hr_cle_shd.g_old_rec.month2
414: ,p_month2_min_contribution_o
415: => hr_cle_shd.g_old_rec.month2_min_contribution
416: ,p_month2_max_contribution_o
417: => hr_cle_shd.g_old_rec.month2_max_contribution
418: ,p_employee_contribution_o
419: => hr_cle_shd.g_old_rec.employee_contribution

Line 417: => hr_cle_shd.g_old_rec.month2_max_contribution

413: => hr_cle_shd.g_old_rec.month2
414: ,p_month2_min_contribution_o
415: => hr_cle_shd.g_old_rec.month2_min_contribution
416: ,p_month2_max_contribution_o
417: => hr_cle_shd.g_old_rec.month2_max_contribution
418: ,p_employee_contribution_o
419: => hr_cle_shd.g_old_rec.employee_contribution
420: ,p_contribution_level_type_o
421: => hr_cle_shd.g_old_rec.contribution_level_type

Line 419: => hr_cle_shd.g_old_rec.employee_contribution

415: => hr_cle_shd.g_old_rec.month2_min_contribution
416: ,p_month2_max_contribution_o
417: => hr_cle_shd.g_old_rec.month2_max_contribution
418: ,p_employee_contribution_o
419: => hr_cle_shd.g_old_rec.employee_contribution
420: ,p_contribution_level_type_o
421: => hr_cle_shd.g_old_rec.contribution_level_type
422: );
423: --

Line 421: => hr_cle_shd.g_old_rec.contribution_level_type

417: => hr_cle_shd.g_old_rec.month2_max_contribution
418: ,p_employee_contribution_o
419: => hr_cle_shd.g_old_rec.employee_contribution
420: ,p_contribution_level_type_o
421: => hr_cle_shd.g_old_rec.contribution_level_type
422: );
423: --
424: exception
425: --

Line 443: ,p_rec in out nocopy hr_cle_shd.g_rec_type

439: -- ----------------------------------------------------------------------------
440: Procedure del
441: (p_effective_date in date
442: ,p_datetrack_mode in varchar2
443: ,p_rec in out nocopy hr_cle_shd.g_rec_type
444: ) is
445: --
446: l_proc varchar2(72) := g_package||'del';
447: l_validation_start_date date;

Line 461: hr_cle_shd.lck

457: hr_utility.trace('object2' ||p_rec.object_version_number);
458: --
459: -- We must lock the row which we need to delete.
460: --
461: hr_cle_shd.lck
462: (p_effective_date => p_effective_date
463: ,p_datetrack_mode => p_datetrack_mode
464: ,p_soc_ins_contr_lvls_id => p_rec.soc_ins_contr_lvls_id
465: ,p_object_version_number => p_rec.object_version_number

Line 524: l_rec hr_cle_shd.g_rec_type;

520: ,p_effective_start_date out nocopy date
521: ,p_effective_end_date out nocopy date
522: ) is
523: --
524: l_rec hr_cle_shd.g_rec_type;
525: l_proc varchar2(72) := g_package||'del';
526: --
527: Begin
528: hr_utility.set_location('Entering:'||l_proc, 5);