APPS.PAY_PEL_DEL dependencies on PAY_PEL_SHD

Line 54: (p_rec in out nocopy pay_pel_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pay_pel_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 66: pay_pel_shd.g_api_dml := true; -- Set the api dml status

62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: pay_pel_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

Line 75: pay_pel_shd.g_api_dml := false; -- Unset the api dml status

71: delete from pay_element_links_f
72: where element_link_id = p_rec.element_link_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pay_pel_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than

Line 77: pay_pel_shd.g_api_dml := true; -- Set the api dml status

73: and effective_start_date = p_validation_start_date;
74: --
75: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pay_pel_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --

Line 86: pay_pel_shd.g_api_dml := false; -- Unset the api dml status

82: delete from pay_element_links_f
83: where element_link_id = p_rec.element_link_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --

Line 93: pay_pel_shd.g_api_dml := false; -- Unset the api dml status

89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
94: Raise;
95: --
96: End dt_delete_dml;
97: --

Line 102: (p_rec in out nocopy pay_pel_shd.g_rec_type

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy pay_pel_shd.g_rec_type
103: ,p_effective_date in date
104: ,p_datetrack_mode in varchar2
105: ,p_validation_start_date in date
106: ,p_validation_end_date in date

Line 159: (p_rec in out nocopy pay_pel_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure dt_pre_delete
159: (p_rec in out nocopy pay_pel_shd.g_rec_type
160: ,p_effective_date in date
161: ,p_datetrack_mode in varchar2
162: ,p_validation_start_date in date
163: ,p_validation_end_date in date

Line 174: := pay_pel_shd.g_old_rec.effective_start_date;

170: --
171: If (p_datetrack_mode <> hr_api.g_zap) then
172: --
173: p_rec.effective_start_date
174: := pay_pel_shd.g_old_rec.effective_start_date;
175: --
176: If (p_datetrack_mode = hr_api.g_delete) then
177: p_rec.effective_end_date := p_validation_start_date - 1;
178: Else

Line 184: pay_pel_shd.upd_effective_end_date

180: End If;
181: --
182: -- Update the current effective end date record
183: --
184: pay_pel_shd.upd_effective_end_date
185: (p_effective_date => p_effective_date
186: ,p_base_key_value => p_rec.element_link_id
187: ,p_new_effective_end_date => p_rec.effective_end_date
188: ,p_validation_start_date => p_validation_start_date

Line 233: (p_rec in out nocopy pay_pel_shd.g_rec_type

229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure pre_delete
233: (p_rec in out nocopy pay_pel_shd.g_rec_type
234: ,p_effective_date in date
235: ,p_datetrack_mode in varchar2
236: ,p_validation_start_date in date
237: ,p_validation_end_date in date

Line 315: (p_rec in pay_pel_shd.g_rec_type

311: --
312: -- {End Of Comments}
313: -- ----------------------------------------------------------------------------
314: Procedure post_delete
315: (p_rec in pay_pel_shd.g_rec_type
316: ,p_effective_date in date
317: ,p_datetrack_mode in varchar2
318: ,p_validation_start_date in date
319: ,p_validation_end_date in date

Line 344: => pay_pel_shd.g_old_rec.effective_start_date

340: => p_rec.effective_start_date
341: ,p_effective_end_date
342: => p_rec.effective_end_date
343: ,p_effective_start_date_o
344: => pay_pel_shd.g_old_rec.effective_start_date
345: ,p_effective_end_date_o
346: => pay_pel_shd.g_old_rec.effective_end_date
347: ,p_payroll_id_o
348: => pay_pel_shd.g_old_rec.payroll_id

Line 346: => pay_pel_shd.g_old_rec.effective_end_date

342: => p_rec.effective_end_date
343: ,p_effective_start_date_o
344: => pay_pel_shd.g_old_rec.effective_start_date
345: ,p_effective_end_date_o
346: => pay_pel_shd.g_old_rec.effective_end_date
347: ,p_payroll_id_o
348: => pay_pel_shd.g_old_rec.payroll_id
349: ,p_job_id_o
350: => pay_pel_shd.g_old_rec.job_id

Line 348: => pay_pel_shd.g_old_rec.payroll_id

344: => pay_pel_shd.g_old_rec.effective_start_date
345: ,p_effective_end_date_o
346: => pay_pel_shd.g_old_rec.effective_end_date
347: ,p_payroll_id_o
348: => pay_pel_shd.g_old_rec.payroll_id
349: ,p_job_id_o
350: => pay_pel_shd.g_old_rec.job_id
351: ,p_position_id_o
352: => pay_pel_shd.g_old_rec.position_id

Line 350: => pay_pel_shd.g_old_rec.job_id

346: => pay_pel_shd.g_old_rec.effective_end_date
347: ,p_payroll_id_o
348: => pay_pel_shd.g_old_rec.payroll_id
349: ,p_job_id_o
350: => pay_pel_shd.g_old_rec.job_id
351: ,p_position_id_o
352: => pay_pel_shd.g_old_rec.position_id
353: ,p_people_group_id_o
354: => pay_pel_shd.g_old_rec.people_group_id

Line 352: => pay_pel_shd.g_old_rec.position_id

348: => pay_pel_shd.g_old_rec.payroll_id
349: ,p_job_id_o
350: => pay_pel_shd.g_old_rec.job_id
351: ,p_position_id_o
352: => pay_pel_shd.g_old_rec.position_id
353: ,p_people_group_id_o
354: => pay_pel_shd.g_old_rec.people_group_id
355: ,p_cost_allocation_keyflex_id_o
356: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id

Line 354: => pay_pel_shd.g_old_rec.people_group_id

350: => pay_pel_shd.g_old_rec.job_id
351: ,p_position_id_o
352: => pay_pel_shd.g_old_rec.position_id
353: ,p_people_group_id_o
354: => pay_pel_shd.g_old_rec.people_group_id
355: ,p_cost_allocation_keyflex_id_o
356: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
357: ,p_organization_id_o
358: => pay_pel_shd.g_old_rec.organization_id

Line 356: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id

352: => pay_pel_shd.g_old_rec.position_id
353: ,p_people_group_id_o
354: => pay_pel_shd.g_old_rec.people_group_id
355: ,p_cost_allocation_keyflex_id_o
356: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
357: ,p_organization_id_o
358: => pay_pel_shd.g_old_rec.organization_id
359: ,p_element_type_id_o
360: => pay_pel_shd.g_old_rec.element_type_id

Line 358: => pay_pel_shd.g_old_rec.organization_id

354: => pay_pel_shd.g_old_rec.people_group_id
355: ,p_cost_allocation_keyflex_id_o
356: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
357: ,p_organization_id_o
358: => pay_pel_shd.g_old_rec.organization_id
359: ,p_element_type_id_o
360: => pay_pel_shd.g_old_rec.element_type_id
361: ,p_location_id_o
362: => pay_pel_shd.g_old_rec.location_id

Line 360: => pay_pel_shd.g_old_rec.element_type_id

356: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
357: ,p_organization_id_o
358: => pay_pel_shd.g_old_rec.organization_id
359: ,p_element_type_id_o
360: => pay_pel_shd.g_old_rec.element_type_id
361: ,p_location_id_o
362: => pay_pel_shd.g_old_rec.location_id
363: ,p_grade_id_o
364: => pay_pel_shd.g_old_rec.grade_id

Line 362: => pay_pel_shd.g_old_rec.location_id

358: => pay_pel_shd.g_old_rec.organization_id
359: ,p_element_type_id_o
360: => pay_pel_shd.g_old_rec.element_type_id
361: ,p_location_id_o
362: => pay_pel_shd.g_old_rec.location_id
363: ,p_grade_id_o
364: => pay_pel_shd.g_old_rec.grade_id
365: ,p_balancing_keyflex_id_o
366: => pay_pel_shd.g_old_rec.balancing_keyflex_id

Line 364: => pay_pel_shd.g_old_rec.grade_id

360: => pay_pel_shd.g_old_rec.element_type_id
361: ,p_location_id_o
362: => pay_pel_shd.g_old_rec.location_id
363: ,p_grade_id_o
364: => pay_pel_shd.g_old_rec.grade_id
365: ,p_balancing_keyflex_id_o
366: => pay_pel_shd.g_old_rec.balancing_keyflex_id
367: ,p_business_group_id_o
368: => pay_pel_shd.g_old_rec.business_group_id

Line 366: => pay_pel_shd.g_old_rec.balancing_keyflex_id

362: => pay_pel_shd.g_old_rec.location_id
363: ,p_grade_id_o
364: => pay_pel_shd.g_old_rec.grade_id
365: ,p_balancing_keyflex_id_o
366: => pay_pel_shd.g_old_rec.balancing_keyflex_id
367: ,p_business_group_id_o
368: => pay_pel_shd.g_old_rec.business_group_id
369: ,p_element_set_id_o
370: => pay_pel_shd.g_old_rec.element_set_id

Line 368: => pay_pel_shd.g_old_rec.business_group_id

364: => pay_pel_shd.g_old_rec.grade_id
365: ,p_balancing_keyflex_id_o
366: => pay_pel_shd.g_old_rec.balancing_keyflex_id
367: ,p_business_group_id_o
368: => pay_pel_shd.g_old_rec.business_group_id
369: ,p_element_set_id_o
370: => pay_pel_shd.g_old_rec.element_set_id
371: ,p_pay_basis_id_o
372: => pay_pel_shd.g_old_rec.pay_basis_id

Line 370: => pay_pel_shd.g_old_rec.element_set_id

366: => pay_pel_shd.g_old_rec.balancing_keyflex_id
367: ,p_business_group_id_o
368: => pay_pel_shd.g_old_rec.business_group_id
369: ,p_element_set_id_o
370: => pay_pel_shd.g_old_rec.element_set_id
371: ,p_pay_basis_id_o
372: => pay_pel_shd.g_old_rec.pay_basis_id
373: ,p_costable_type_o
374: => pay_pel_shd.g_old_rec.costable_type

Line 372: => pay_pel_shd.g_old_rec.pay_basis_id

368: => pay_pel_shd.g_old_rec.business_group_id
369: ,p_element_set_id_o
370: => pay_pel_shd.g_old_rec.element_set_id
371: ,p_pay_basis_id_o
372: => pay_pel_shd.g_old_rec.pay_basis_id
373: ,p_costable_type_o
374: => pay_pel_shd.g_old_rec.costable_type
375: ,p_link_to_all_payrolls_flag_o
376: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag

Line 374: => pay_pel_shd.g_old_rec.costable_type

370: => pay_pel_shd.g_old_rec.element_set_id
371: ,p_pay_basis_id_o
372: => pay_pel_shd.g_old_rec.pay_basis_id
373: ,p_costable_type_o
374: => pay_pel_shd.g_old_rec.costable_type
375: ,p_link_to_all_payrolls_flag_o
376: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
377: ,p_multiply_value_flag_o
378: => pay_pel_shd.g_old_rec.multiply_value_flag

Line 376: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag

372: => pay_pel_shd.g_old_rec.pay_basis_id
373: ,p_costable_type_o
374: => pay_pel_shd.g_old_rec.costable_type
375: ,p_link_to_all_payrolls_flag_o
376: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
377: ,p_multiply_value_flag_o
378: => pay_pel_shd.g_old_rec.multiply_value_flag
379: ,p_standard_link_flag_o
380: => pay_pel_shd.g_old_rec.standard_link_flag

Line 378: => pay_pel_shd.g_old_rec.multiply_value_flag

374: => pay_pel_shd.g_old_rec.costable_type
375: ,p_link_to_all_payrolls_flag_o
376: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
377: ,p_multiply_value_flag_o
378: => pay_pel_shd.g_old_rec.multiply_value_flag
379: ,p_standard_link_flag_o
380: => pay_pel_shd.g_old_rec.standard_link_flag
381: ,p_transfer_to_gl_flag_o
382: => pay_pel_shd.g_old_rec.transfer_to_gl_flag

Line 380: => pay_pel_shd.g_old_rec.standard_link_flag

376: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
377: ,p_multiply_value_flag_o
378: => pay_pel_shd.g_old_rec.multiply_value_flag
379: ,p_standard_link_flag_o
380: => pay_pel_shd.g_old_rec.standard_link_flag
381: ,p_transfer_to_gl_flag_o
382: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
383: ,p_comment_id_o
384: => pay_pel_shd.g_old_rec.comment_id

Line 382: => pay_pel_shd.g_old_rec.transfer_to_gl_flag

378: => pay_pel_shd.g_old_rec.multiply_value_flag
379: ,p_standard_link_flag_o
380: => pay_pel_shd.g_old_rec.standard_link_flag
381: ,p_transfer_to_gl_flag_o
382: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
383: ,p_comment_id_o
384: => pay_pel_shd.g_old_rec.comment_id
385: ,p_comments_o
386: => pay_pel_shd.g_old_rec.comments

Line 384: => pay_pel_shd.g_old_rec.comment_id

380: => pay_pel_shd.g_old_rec.standard_link_flag
381: ,p_transfer_to_gl_flag_o
382: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
383: ,p_comment_id_o
384: => pay_pel_shd.g_old_rec.comment_id
385: ,p_comments_o
386: => pay_pel_shd.g_old_rec.comments
387: ,p_employment_category_o
388: => pay_pel_shd.g_old_rec.employment_category

Line 386: => pay_pel_shd.g_old_rec.comments

382: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
383: ,p_comment_id_o
384: => pay_pel_shd.g_old_rec.comment_id
385: ,p_comments_o
386: => pay_pel_shd.g_old_rec.comments
387: ,p_employment_category_o
388: => pay_pel_shd.g_old_rec.employment_category
389: ,p_qualifying_age_o
390: => pay_pel_shd.g_old_rec.qualifying_age

Line 388: => pay_pel_shd.g_old_rec.employment_category

384: => pay_pel_shd.g_old_rec.comment_id
385: ,p_comments_o
386: => pay_pel_shd.g_old_rec.comments
387: ,p_employment_category_o
388: => pay_pel_shd.g_old_rec.employment_category
389: ,p_qualifying_age_o
390: => pay_pel_shd.g_old_rec.qualifying_age
391: ,p_qualifying_length_of_servi_o
392: => pay_pel_shd.g_old_rec.qualifying_length_of_service

Line 390: => pay_pel_shd.g_old_rec.qualifying_age

386: => pay_pel_shd.g_old_rec.comments
387: ,p_employment_category_o
388: => pay_pel_shd.g_old_rec.employment_category
389: ,p_qualifying_age_o
390: => pay_pel_shd.g_old_rec.qualifying_age
391: ,p_qualifying_length_of_servi_o
392: => pay_pel_shd.g_old_rec.qualifying_length_of_service
393: ,p_qualifying_units_o
394: => pay_pel_shd.g_old_rec.qualifying_units

Line 392: => pay_pel_shd.g_old_rec.qualifying_length_of_service

388: => pay_pel_shd.g_old_rec.employment_category
389: ,p_qualifying_age_o
390: => pay_pel_shd.g_old_rec.qualifying_age
391: ,p_qualifying_length_of_servi_o
392: => pay_pel_shd.g_old_rec.qualifying_length_of_service
393: ,p_qualifying_units_o
394: => pay_pel_shd.g_old_rec.qualifying_units
395: ,p_attribute_category_o
396: => pay_pel_shd.g_old_rec.attribute_category

Line 394: => pay_pel_shd.g_old_rec.qualifying_units

390: => pay_pel_shd.g_old_rec.qualifying_age
391: ,p_qualifying_length_of_servi_o
392: => pay_pel_shd.g_old_rec.qualifying_length_of_service
393: ,p_qualifying_units_o
394: => pay_pel_shd.g_old_rec.qualifying_units
395: ,p_attribute_category_o
396: => pay_pel_shd.g_old_rec.attribute_category
397: ,p_attribute1_o
398: => pay_pel_shd.g_old_rec.attribute1

Line 396: => pay_pel_shd.g_old_rec.attribute_category

392: => pay_pel_shd.g_old_rec.qualifying_length_of_service
393: ,p_qualifying_units_o
394: => pay_pel_shd.g_old_rec.qualifying_units
395: ,p_attribute_category_o
396: => pay_pel_shd.g_old_rec.attribute_category
397: ,p_attribute1_o
398: => pay_pel_shd.g_old_rec.attribute1
399: ,p_attribute2_o
400: => pay_pel_shd.g_old_rec.attribute2

Line 398: => pay_pel_shd.g_old_rec.attribute1

394: => pay_pel_shd.g_old_rec.qualifying_units
395: ,p_attribute_category_o
396: => pay_pel_shd.g_old_rec.attribute_category
397: ,p_attribute1_o
398: => pay_pel_shd.g_old_rec.attribute1
399: ,p_attribute2_o
400: => pay_pel_shd.g_old_rec.attribute2
401: ,p_attribute3_o
402: => pay_pel_shd.g_old_rec.attribute3

Line 400: => pay_pel_shd.g_old_rec.attribute2

396: => pay_pel_shd.g_old_rec.attribute_category
397: ,p_attribute1_o
398: => pay_pel_shd.g_old_rec.attribute1
399: ,p_attribute2_o
400: => pay_pel_shd.g_old_rec.attribute2
401: ,p_attribute3_o
402: => pay_pel_shd.g_old_rec.attribute3
403: ,p_attribute4_o
404: => pay_pel_shd.g_old_rec.attribute4

Line 402: => pay_pel_shd.g_old_rec.attribute3

398: => pay_pel_shd.g_old_rec.attribute1
399: ,p_attribute2_o
400: => pay_pel_shd.g_old_rec.attribute2
401: ,p_attribute3_o
402: => pay_pel_shd.g_old_rec.attribute3
403: ,p_attribute4_o
404: => pay_pel_shd.g_old_rec.attribute4
405: ,p_attribute5_o
406: => pay_pel_shd.g_old_rec.attribute5

Line 404: => pay_pel_shd.g_old_rec.attribute4

400: => pay_pel_shd.g_old_rec.attribute2
401: ,p_attribute3_o
402: => pay_pel_shd.g_old_rec.attribute3
403: ,p_attribute4_o
404: => pay_pel_shd.g_old_rec.attribute4
405: ,p_attribute5_o
406: => pay_pel_shd.g_old_rec.attribute5
407: ,p_attribute6_o
408: => pay_pel_shd.g_old_rec.attribute6

Line 406: => pay_pel_shd.g_old_rec.attribute5

402: => pay_pel_shd.g_old_rec.attribute3
403: ,p_attribute4_o
404: => pay_pel_shd.g_old_rec.attribute4
405: ,p_attribute5_o
406: => pay_pel_shd.g_old_rec.attribute5
407: ,p_attribute6_o
408: => pay_pel_shd.g_old_rec.attribute6
409: ,p_attribute7_o
410: => pay_pel_shd.g_old_rec.attribute7

Line 408: => pay_pel_shd.g_old_rec.attribute6

404: => pay_pel_shd.g_old_rec.attribute4
405: ,p_attribute5_o
406: => pay_pel_shd.g_old_rec.attribute5
407: ,p_attribute6_o
408: => pay_pel_shd.g_old_rec.attribute6
409: ,p_attribute7_o
410: => pay_pel_shd.g_old_rec.attribute7
411: ,p_attribute8_o
412: => pay_pel_shd.g_old_rec.attribute8

Line 410: => pay_pel_shd.g_old_rec.attribute7

406: => pay_pel_shd.g_old_rec.attribute5
407: ,p_attribute6_o
408: => pay_pel_shd.g_old_rec.attribute6
409: ,p_attribute7_o
410: => pay_pel_shd.g_old_rec.attribute7
411: ,p_attribute8_o
412: => pay_pel_shd.g_old_rec.attribute8
413: ,p_attribute9_o
414: => pay_pel_shd.g_old_rec.attribute9

Line 412: => pay_pel_shd.g_old_rec.attribute8

408: => pay_pel_shd.g_old_rec.attribute6
409: ,p_attribute7_o
410: => pay_pel_shd.g_old_rec.attribute7
411: ,p_attribute8_o
412: => pay_pel_shd.g_old_rec.attribute8
413: ,p_attribute9_o
414: => pay_pel_shd.g_old_rec.attribute9
415: ,p_attribute10_o
416: => pay_pel_shd.g_old_rec.attribute10

Line 414: => pay_pel_shd.g_old_rec.attribute9

410: => pay_pel_shd.g_old_rec.attribute7
411: ,p_attribute8_o
412: => pay_pel_shd.g_old_rec.attribute8
413: ,p_attribute9_o
414: => pay_pel_shd.g_old_rec.attribute9
415: ,p_attribute10_o
416: => pay_pel_shd.g_old_rec.attribute10
417: ,p_attribute11_o
418: => pay_pel_shd.g_old_rec.attribute11

Line 416: => pay_pel_shd.g_old_rec.attribute10

412: => pay_pel_shd.g_old_rec.attribute8
413: ,p_attribute9_o
414: => pay_pel_shd.g_old_rec.attribute9
415: ,p_attribute10_o
416: => pay_pel_shd.g_old_rec.attribute10
417: ,p_attribute11_o
418: => pay_pel_shd.g_old_rec.attribute11
419: ,p_attribute12_o
420: => pay_pel_shd.g_old_rec.attribute12

Line 418: => pay_pel_shd.g_old_rec.attribute11

414: => pay_pel_shd.g_old_rec.attribute9
415: ,p_attribute10_o
416: => pay_pel_shd.g_old_rec.attribute10
417: ,p_attribute11_o
418: => pay_pel_shd.g_old_rec.attribute11
419: ,p_attribute12_o
420: => pay_pel_shd.g_old_rec.attribute12
421: ,p_attribute13_o
422: => pay_pel_shd.g_old_rec.attribute13

Line 420: => pay_pel_shd.g_old_rec.attribute12

416: => pay_pel_shd.g_old_rec.attribute10
417: ,p_attribute11_o
418: => pay_pel_shd.g_old_rec.attribute11
419: ,p_attribute12_o
420: => pay_pel_shd.g_old_rec.attribute12
421: ,p_attribute13_o
422: => pay_pel_shd.g_old_rec.attribute13
423: ,p_attribute14_o
424: => pay_pel_shd.g_old_rec.attribute14

Line 422: => pay_pel_shd.g_old_rec.attribute13

418: => pay_pel_shd.g_old_rec.attribute11
419: ,p_attribute12_o
420: => pay_pel_shd.g_old_rec.attribute12
421: ,p_attribute13_o
422: => pay_pel_shd.g_old_rec.attribute13
423: ,p_attribute14_o
424: => pay_pel_shd.g_old_rec.attribute14
425: ,p_attribute15_o
426: => pay_pel_shd.g_old_rec.attribute15

Line 424: => pay_pel_shd.g_old_rec.attribute14

420: => pay_pel_shd.g_old_rec.attribute12
421: ,p_attribute13_o
422: => pay_pel_shd.g_old_rec.attribute13
423: ,p_attribute14_o
424: => pay_pel_shd.g_old_rec.attribute14
425: ,p_attribute15_o
426: => pay_pel_shd.g_old_rec.attribute15
427: ,p_attribute16_o
428: => pay_pel_shd.g_old_rec.attribute16

Line 426: => pay_pel_shd.g_old_rec.attribute15

422: => pay_pel_shd.g_old_rec.attribute13
423: ,p_attribute14_o
424: => pay_pel_shd.g_old_rec.attribute14
425: ,p_attribute15_o
426: => pay_pel_shd.g_old_rec.attribute15
427: ,p_attribute16_o
428: => pay_pel_shd.g_old_rec.attribute16
429: ,p_attribute17_o
430: => pay_pel_shd.g_old_rec.attribute17

Line 428: => pay_pel_shd.g_old_rec.attribute16

424: => pay_pel_shd.g_old_rec.attribute14
425: ,p_attribute15_o
426: => pay_pel_shd.g_old_rec.attribute15
427: ,p_attribute16_o
428: => pay_pel_shd.g_old_rec.attribute16
429: ,p_attribute17_o
430: => pay_pel_shd.g_old_rec.attribute17
431: ,p_attribute18_o
432: => pay_pel_shd.g_old_rec.attribute18

Line 430: => pay_pel_shd.g_old_rec.attribute17

426: => pay_pel_shd.g_old_rec.attribute15
427: ,p_attribute16_o
428: => pay_pel_shd.g_old_rec.attribute16
429: ,p_attribute17_o
430: => pay_pel_shd.g_old_rec.attribute17
431: ,p_attribute18_o
432: => pay_pel_shd.g_old_rec.attribute18
433: ,p_attribute19_o
434: => pay_pel_shd.g_old_rec.attribute19

Line 432: => pay_pel_shd.g_old_rec.attribute18

428: => pay_pel_shd.g_old_rec.attribute16
429: ,p_attribute17_o
430: => pay_pel_shd.g_old_rec.attribute17
431: ,p_attribute18_o
432: => pay_pel_shd.g_old_rec.attribute18
433: ,p_attribute19_o
434: => pay_pel_shd.g_old_rec.attribute19
435: ,p_attribute20_o
436: => pay_pel_shd.g_old_rec.attribute20

Line 434: => pay_pel_shd.g_old_rec.attribute19

430: => pay_pel_shd.g_old_rec.attribute17
431: ,p_attribute18_o
432: => pay_pel_shd.g_old_rec.attribute18
433: ,p_attribute19_o
434: => pay_pel_shd.g_old_rec.attribute19
435: ,p_attribute20_o
436: => pay_pel_shd.g_old_rec.attribute20
437: ,p_object_version_number_o
438: => pay_pel_shd.g_old_rec.object_version_number

Line 436: => pay_pel_shd.g_old_rec.attribute20

432: => pay_pel_shd.g_old_rec.attribute18
433: ,p_attribute19_o
434: => pay_pel_shd.g_old_rec.attribute19
435: ,p_attribute20_o
436: => pay_pel_shd.g_old_rec.attribute20
437: ,p_object_version_number_o
438: => pay_pel_shd.g_old_rec.object_version_number
439: );
440: --

Line 438: => pay_pel_shd.g_old_rec.object_version_number

434: => pay_pel_shd.g_old_rec.attribute19
435: ,p_attribute20_o
436: => pay_pel_shd.g_old_rec.attribute20
437: ,p_object_version_number_o
438: => pay_pel_shd.g_old_rec.object_version_number
439: );
440: --
441: exception
442: --

Line 460: ,p_rec in out nocopy pay_pel_shd.g_rec_type

456: -- ----------------------------------------------------------------------------
457: Procedure del
458: (p_effective_date in date
459: ,p_datetrack_mode in varchar2
460: ,p_rec in out nocopy pay_pel_shd.g_rec_type
461: ) is
462: --
463: l_proc varchar2(72) := g_package||'del';
464: l_validation_start_date date;

Line 477: pay_pel_shd.lck

473:
474: --
475: -- We must lock the row which we need to delete.
476: --
477: pay_pel_shd.lck
478: (p_effective_date => p_effective_date
479: ,p_datetrack_mode => p_datetrack_mode
480: ,p_element_link_id => p_rec.element_link_id
481: ,p_object_version_number => p_rec.object_version_number

Line 549: l_rec pay_pel_shd.g_rec_type;

545: ,p_effective_end_date out nocopy date
546: ,p_warning out nocopy boolean
547: ) is
548: --
549: l_rec pay_pel_shd.g_rec_type;
550: l_proc varchar2(72) := g_package||'del';
551: --
552: Begin
553: hr_utility.set_location('Entering:'||l_proc, 5);