APPS.PAY_ETU_DEL dependencies on PAY_ETU_SHD

Line 54: (p_rec in out nocopy pay_etu_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pay_etu_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 134: (p_rec in out nocopy pay_etu_shd.g_rec_type

130: -- ----------------------------------------------------------------------------
131: -- |------------------------------< delete_dml >------------------------------|
132: -- ----------------------------------------------------------------------------
133: Procedure delete_dml
134: (p_rec in out nocopy pay_etu_shd.g_rec_type
135: ,p_effective_date in date
136: ,p_datetrack_mode in varchar2
137: ,p_validation_start_date in date
138: ,p_validation_end_date in date

Line 191: (p_rec in out nocopy pay_etu_shd.g_rec_type

187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure dt_pre_delete
191: (p_rec in out nocopy pay_etu_shd.g_rec_type
192: ,p_effective_date in date
193: ,p_datetrack_mode in varchar2
194: ,p_validation_start_date in date
195: ,p_validation_end_date in date

Line 206: := pay_etu_shd.g_old_rec.effective_start_date;

202: --
203: If (p_datetrack_mode <> hr_api.g_zap) then
204: --
205: p_rec.effective_start_date
206: := pay_etu_shd.g_old_rec.effective_start_date;
207: --
208: If (p_datetrack_mode = hr_api.g_delete) then
209: p_rec.effective_end_date := p_validation_start_date - 1;
210: Else

Line 216: pay_etu_shd.upd_effective_end_date

212: End If;
213: --
214: -- Update the current effective end date record
215: --
216: pay_etu_shd.upd_effective_end_date
217: (p_effective_date => p_effective_date
218: ,p_base_key_value => p_rec.element_type_usage_id
219: ,p_new_effective_end_date => p_rec.effective_end_date
220: ,p_validation_start_date => p_validation_start_date

Line 265: (p_rec in out nocopy pay_etu_shd.g_rec_type

261: --
262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure pre_delete
265: (p_rec in out nocopy pay_etu_shd.g_rec_type
266: ,p_effective_date in date
267: ,p_datetrack_mode in varchar2
268: ,p_validation_start_date in date
269: ,p_validation_end_date in date

Line 325: (p_rec in pay_etu_shd.g_rec_type

321: --
322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: Procedure post_delete
325: (p_rec in pay_etu_shd.g_rec_type
326: ,p_effective_date in date
327: ,p_datetrack_mode in varchar2
328: ,p_validation_start_date in date
329: ,p_validation_end_date in date

Line 360: => pay_etu_shd.g_old_rec.run_type_id

356: => p_rec.effective_end_date
357: ,p_element_type_usage_id
358: => p_rec.element_type_usage_id
359: ,p_run_type_id_o
360: => pay_etu_shd.g_old_rec.run_type_id
361: ,p_element_type_id_o
362: => pay_etu_shd.g_old_rec.element_type_id
363: ,p_inclusion_flag_o
364: => pay_etu_shd.g_old_rec.inclusion_flag

Line 362: => pay_etu_shd.g_old_rec.element_type_id

358: => p_rec.element_type_usage_id
359: ,p_run_type_id_o
360: => pay_etu_shd.g_old_rec.run_type_id
361: ,p_element_type_id_o
362: => pay_etu_shd.g_old_rec.element_type_id
363: ,p_inclusion_flag_o
364: => pay_etu_shd.g_old_rec.inclusion_flag
365: ,p_effective_start_date_o
366: => pay_etu_shd.g_old_rec.effective_start_date

Line 364: => pay_etu_shd.g_old_rec.inclusion_flag

360: => pay_etu_shd.g_old_rec.run_type_id
361: ,p_element_type_id_o
362: => pay_etu_shd.g_old_rec.element_type_id
363: ,p_inclusion_flag_o
364: => pay_etu_shd.g_old_rec.inclusion_flag
365: ,p_effective_start_date_o
366: => pay_etu_shd.g_old_rec.effective_start_date
367: ,p_effective_end_date_o
368: => pay_etu_shd.g_old_rec.effective_end_date

Line 366: => pay_etu_shd.g_old_rec.effective_start_date

362: => pay_etu_shd.g_old_rec.element_type_id
363: ,p_inclusion_flag_o
364: => pay_etu_shd.g_old_rec.inclusion_flag
365: ,p_effective_start_date_o
366: => pay_etu_shd.g_old_rec.effective_start_date
367: ,p_effective_end_date_o
368: => pay_etu_shd.g_old_rec.effective_end_date
369: ,p_object_version_number_o
370: => pay_etu_shd.g_old_rec.object_version_number

Line 368: => pay_etu_shd.g_old_rec.effective_end_date

364: => pay_etu_shd.g_old_rec.inclusion_flag
365: ,p_effective_start_date_o
366: => pay_etu_shd.g_old_rec.effective_start_date
367: ,p_effective_end_date_o
368: => pay_etu_shd.g_old_rec.effective_end_date
369: ,p_object_version_number_o
370: => pay_etu_shd.g_old_rec.object_version_number
371: ,p_business_group_id_o
372: => pay_etu_shd.g_old_rec.business_group_id

Line 370: => pay_etu_shd.g_old_rec.object_version_number

366: => pay_etu_shd.g_old_rec.effective_start_date
367: ,p_effective_end_date_o
368: => pay_etu_shd.g_old_rec.effective_end_date
369: ,p_object_version_number_o
370: => pay_etu_shd.g_old_rec.object_version_number
371: ,p_business_group_id_o
372: => pay_etu_shd.g_old_rec.business_group_id
373: ,p_legislation_code_o
374: => pay_etu_shd.g_old_rec.legislation_code

Line 372: => pay_etu_shd.g_old_rec.business_group_id

368: => pay_etu_shd.g_old_rec.effective_end_date
369: ,p_object_version_number_o
370: => pay_etu_shd.g_old_rec.object_version_number
371: ,p_business_group_id_o
372: => pay_etu_shd.g_old_rec.business_group_id
373: ,p_legislation_code_o
374: => pay_etu_shd.g_old_rec.legislation_code
375: ,p_usage_type_o
376: => pay_etu_shd.g_old_rec.usage_type

Line 374: => pay_etu_shd.g_old_rec.legislation_code

370: => pay_etu_shd.g_old_rec.object_version_number
371: ,p_business_group_id_o
372: => pay_etu_shd.g_old_rec.business_group_id
373: ,p_legislation_code_o
374: => pay_etu_shd.g_old_rec.legislation_code
375: ,p_usage_type_o
376: => pay_etu_shd.g_old_rec.usage_type
377: );
378: --

Line 376: => pay_etu_shd.g_old_rec.usage_type

372: => pay_etu_shd.g_old_rec.business_group_id
373: ,p_legislation_code_o
374: => pay_etu_shd.g_old_rec.legislation_code
375: ,p_usage_type_o
376: => pay_etu_shd.g_old_rec.usage_type
377: );
378: --
379: exception
380: --

Line 398: ,p_rec in out nocopy pay_etu_shd.g_rec_type

394: -- ----------------------------------------------------------------------------
395: Procedure del
396: (p_effective_date in date
397: ,p_datetrack_mode in varchar2
398: ,p_rec in out nocopy pay_etu_shd.g_rec_type
399: ) is
400: --
401: l_proc varchar2(72) := g_package||'del';
402: l_validation_start_date date;

Line 414: pay_etu_shd.lck

410: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
411: --
412: -- We must lock the row which we need to delete.
413: --
414: pay_etu_shd.lck
415: (p_effective_date => p_effective_date
416: ,p_datetrack_mode => p_datetrack_mode
417: ,p_element_type_usage_id => p_rec.element_type_usage_id
418: ,p_object_version_number => p_rec.object_version_number

Line 477: l_rec pay_etu_shd.g_rec_type;

473: ,p_effective_start_date out nocopy date
474: ,p_effective_end_date out nocopy date
475: ) is
476: --
477: l_rec pay_etu_shd.g_rec_type;
478: l_proc varchar2(72) := g_package||'del';
479: --
480: Begin
481: hr_utility.set_location('Entering:'||l_proc, 5);