eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PCL_DEL dependencies on PER_PCL_SHD

Line 54: (p_rec in out nocopy per_pcl_shd.g_rec_type

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

93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy per_pcl_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 per_pcl_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy per_pcl_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: := per_pcl_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: := per_pcl_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: per_pcl_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: per_pcl_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date
181: ,p_base_key_value => p_rec.cagr_entitlement_line_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 per_pcl_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_delete
228: (p_rec in out nocopy per_pcl_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 per_pcl_shd.g_rec_type

284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure post_delete
288: (p_rec in per_pcl_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: => per_pcl_shd.g_old_rec.cagr_entitlement_id

313: => p_rec.effective_start_date
314: ,p_effective_end_date
315: => p_rec.effective_end_date
316: ,p_cagr_entitlement_id_o
317: => per_pcl_shd.g_old_rec.cagr_entitlement_id
318: ,p_mandatory_o
319: => per_pcl_shd.g_old_rec.mandatory
320: ,p_value_o
321: => per_pcl_shd.g_old_rec.value

Line 319: => per_pcl_shd.g_old_rec.mandatory

315: => p_rec.effective_end_date
316: ,p_cagr_entitlement_id_o
317: => per_pcl_shd.g_old_rec.cagr_entitlement_id
318: ,p_mandatory_o
319: => per_pcl_shd.g_old_rec.mandatory
320: ,p_value_o
321: => per_pcl_shd.g_old_rec.value
322: ,p_range_from_o
323: => per_pcl_shd.g_old_rec.range_from

Line 321: => per_pcl_shd.g_old_rec.value

317: => per_pcl_shd.g_old_rec.cagr_entitlement_id
318: ,p_mandatory_o
319: => per_pcl_shd.g_old_rec.mandatory
320: ,p_value_o
321: => per_pcl_shd.g_old_rec.value
322: ,p_range_from_o
323: => per_pcl_shd.g_old_rec.range_from
324: ,p_range_to_o
325: => per_pcl_shd.g_old_rec.range_to

Line 323: => per_pcl_shd.g_old_rec.range_from

319: => per_pcl_shd.g_old_rec.mandatory
320: ,p_value_o
321: => per_pcl_shd.g_old_rec.value
322: ,p_range_from_o
323: => per_pcl_shd.g_old_rec.range_from
324: ,p_range_to_o
325: => per_pcl_shd.g_old_rec.range_to
326: ,p_effective_start_date_o
327: => per_pcl_shd.g_old_rec.effective_start_date

Line 325: => per_pcl_shd.g_old_rec.range_to

321: => per_pcl_shd.g_old_rec.value
322: ,p_range_from_o
323: => per_pcl_shd.g_old_rec.range_from
324: ,p_range_to_o
325: => per_pcl_shd.g_old_rec.range_to
326: ,p_effective_start_date_o
327: => per_pcl_shd.g_old_rec.effective_start_date
328: ,p_effective_end_date_o
329: => per_pcl_shd.g_old_rec.effective_end_date

Line 327: => per_pcl_shd.g_old_rec.effective_start_date

323: => per_pcl_shd.g_old_rec.range_from
324: ,p_range_to_o
325: => per_pcl_shd.g_old_rec.range_to
326: ,p_effective_start_date_o
327: => per_pcl_shd.g_old_rec.effective_start_date
328: ,p_effective_end_date_o
329: => per_pcl_shd.g_old_rec.effective_end_date
330: ,p_parent_spine_id_o
331: => per_pcl_shd.g_old_rec.parent_spine_id

Line 329: => per_pcl_shd.g_old_rec.effective_end_date

325: => per_pcl_shd.g_old_rec.range_to
326: ,p_effective_start_date_o
327: => per_pcl_shd.g_old_rec.effective_start_date
328: ,p_effective_end_date_o
329: => per_pcl_shd.g_old_rec.effective_end_date
330: ,p_parent_spine_id_o
331: => per_pcl_shd.g_old_rec.parent_spine_id
332: ,p_step_id_o
333: => per_pcl_shd.g_old_rec.step_id

Line 331: => per_pcl_shd.g_old_rec.parent_spine_id

327: => per_pcl_shd.g_old_rec.effective_start_date
328: ,p_effective_end_date_o
329: => per_pcl_shd.g_old_rec.effective_end_date
330: ,p_parent_spine_id_o
331: => per_pcl_shd.g_old_rec.parent_spine_id
332: ,p_step_id_o
333: => per_pcl_shd.g_old_rec.step_id
334: ,p_from_step_id_o
335: => per_pcl_shd.g_old_rec.from_step_id

Line 333: => per_pcl_shd.g_old_rec.step_id

329: => per_pcl_shd.g_old_rec.effective_end_date
330: ,p_parent_spine_id_o
331: => per_pcl_shd.g_old_rec.parent_spine_id
332: ,p_step_id_o
333: => per_pcl_shd.g_old_rec.step_id
334: ,p_from_step_id_o
335: => per_pcl_shd.g_old_rec.from_step_id
336: ,p_to_step_id_o
337: => per_pcl_shd.g_old_rec.to_step_id

Line 335: => per_pcl_shd.g_old_rec.from_step_id

331: => per_pcl_shd.g_old_rec.parent_spine_id
332: ,p_step_id_o
333: => per_pcl_shd.g_old_rec.step_id
334: ,p_from_step_id_o
335: => per_pcl_shd.g_old_rec.from_step_id
336: ,p_to_step_id_o
337: => per_pcl_shd.g_old_rec.to_step_id
338: ,p_status_o
339: => per_pcl_shd.g_old_rec.status

Line 337: => per_pcl_shd.g_old_rec.to_step_id

333: => per_pcl_shd.g_old_rec.step_id
334: ,p_from_step_id_o
335: => per_pcl_shd.g_old_rec.from_step_id
336: ,p_to_step_id_o
337: => per_pcl_shd.g_old_rec.to_step_id
338: ,p_status_o
339: => per_pcl_shd.g_old_rec.status
340: ,p_oipl_id_o
341: => per_pcl_shd.g_old_rec.oipl_id

Line 339: => per_pcl_shd.g_old_rec.status

335: => per_pcl_shd.g_old_rec.from_step_id
336: ,p_to_step_id_o
337: => per_pcl_shd.g_old_rec.to_step_id
338: ,p_status_o
339: => per_pcl_shd.g_old_rec.status
340: ,p_oipl_id_o
341: => per_pcl_shd.g_old_rec.oipl_id
342: ,p_object_version_number_o
343: => per_pcl_shd.g_old_rec.object_version_number

Line 341: => per_pcl_shd.g_old_rec.oipl_id

337: => per_pcl_shd.g_old_rec.to_step_id
338: ,p_status_o
339: => per_pcl_shd.g_old_rec.status
340: ,p_oipl_id_o
341: => per_pcl_shd.g_old_rec.oipl_id
342: ,p_object_version_number_o
343: => per_pcl_shd.g_old_rec.object_version_number
344: ,p_grade_spine_id_o
345: => per_pcl_shd.g_old_rec.grade_spine_id

Line 343: => per_pcl_shd.g_old_rec.object_version_number

339: => per_pcl_shd.g_old_rec.status
340: ,p_oipl_id_o
341: => per_pcl_shd.g_old_rec.oipl_id
342: ,p_object_version_number_o
343: => per_pcl_shd.g_old_rec.object_version_number
344: ,p_grade_spine_id_o
345: => per_pcl_shd.g_old_rec.grade_spine_id
346: ,p_eligy_prfl_id_o
347: => per_pcl_shd.g_old_rec.eligy_prfl_id

Line 345: => per_pcl_shd.g_old_rec.grade_spine_id

341: => per_pcl_shd.g_old_rec.oipl_id
342: ,p_object_version_number_o
343: => per_pcl_shd.g_old_rec.object_version_number
344: ,p_grade_spine_id_o
345: => per_pcl_shd.g_old_rec.grade_spine_id
346: ,p_eligy_prfl_id_o
347: => per_pcl_shd.g_old_rec.eligy_prfl_id
348: );
349: --

Line 347: => per_pcl_shd.g_old_rec.eligy_prfl_id

343: => per_pcl_shd.g_old_rec.object_version_number
344: ,p_grade_spine_id_o
345: => per_pcl_shd.g_old_rec.grade_spine_id
346: ,p_eligy_prfl_id_o
347: => per_pcl_shd.g_old_rec.eligy_prfl_id
348: );
349: --
350: exception
351: --

Line 369: ,p_rec in out nocopy per_pcl_shd.g_rec_type

365: -- ----------------------------------------------------------------------------
366: Procedure del
367: (p_effective_date in date
368: ,p_datetrack_mode in varchar2
369: ,p_rec in out nocopy per_pcl_shd.g_rec_type
370: ) is
371: --
372: l_proc varchar2(72) := g_package||'del';
373: l_validation_start_date date;

Line 385: per_pcl_shd.lck

381: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
382: --
383: -- We must lock the row which we need to delete.
384: --
385: per_pcl_shd.lck
386: (p_effective_date => p_effective_date
387: ,p_datetrack_mode => p_datetrack_mode
388: ,p_cagr_entitlement_line_id => p_rec.cagr_entitlement_line_id
389: ,p_object_version_number => p_rec.object_version_number

Line 448: l_rec per_pcl_shd.g_rec_type;

444: ,p_effective_start_date out nocopy date
445: ,p_effective_end_date out nocopy date
446: ) is
447: --
448: l_rec per_pcl_shd.g_rec_type;
449: l_proc varchar2(72) := g_package||'del';
450: --
451: Begin
452: hr_utility.set_location('Entering:'||l_proc, 5);