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.PAY_PPD_DEL dependencies on PAY_PPD_SHD

Line 54: (p_rec in out nocopy pay_ppd_shd.g_rec_type

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

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

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

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

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

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

313: => p_rec.effective_start_date
314: ,p_effective_end_date
315: => p_rec.effective_end_date
316: ,p_effective_start_date_o
317: => pay_ppd_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => pay_ppd_shd.g_old_rec.effective_end_date
320: ,p_per_or_asg_id_o
321: => pay_ppd_shd.g_old_rec.per_or_asg_id

Line 319: => pay_ppd_shd.g_old_rec.effective_end_date

315: => p_rec.effective_end_date
316: ,p_effective_start_date_o
317: => pay_ppd_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => pay_ppd_shd.g_old_rec.effective_end_date
320: ,p_per_or_asg_id_o
321: => pay_ppd_shd.g_old_rec.per_or_asg_id
322: ,p_business_group_id_o
323: => pay_ppd_shd.g_old_rec.business_group_id

Line 321: => pay_ppd_shd.g_old_rec.per_or_asg_id

317: => pay_ppd_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => pay_ppd_shd.g_old_rec.effective_end_date
320: ,p_per_or_asg_id_o
321: => pay_ppd_shd.g_old_rec.per_or_asg_id
322: ,p_business_group_id_o
323: => pay_ppd_shd.g_old_rec.business_group_id
324: ,p_contract_category_o
325: => pay_ppd_shd.g_old_rec.contract_category

Line 323: => pay_ppd_shd.g_old_rec.business_group_id

319: => pay_ppd_shd.g_old_rec.effective_end_date
320: ,p_per_or_asg_id_o
321: => pay_ppd_shd.g_old_rec.per_or_asg_id
322: ,p_business_group_id_o
323: => pay_ppd_shd.g_old_rec.business_group_id
324: ,p_contract_category_o
325: => pay_ppd_shd.g_old_rec.contract_category
326: ,p_object_version_number_o
327: => pay_ppd_shd.g_old_rec.object_version_number

Line 325: => pay_ppd_shd.g_old_rec.contract_category

321: => pay_ppd_shd.g_old_rec.per_or_asg_id
322: ,p_business_group_id_o
323: => pay_ppd_shd.g_old_rec.business_group_id
324: ,p_contract_category_o
325: => pay_ppd_shd.g_old_rec.contract_category
326: ,p_object_version_number_o
327: => pay_ppd_shd.g_old_rec.object_version_number
328: ,p_tax_reduction_o
329: => pay_ppd_shd.g_old_rec.tax_reduction

Line 327: => pay_ppd_shd.g_old_rec.object_version_number

323: => pay_ppd_shd.g_old_rec.business_group_id
324: ,p_contract_category_o
325: => pay_ppd_shd.g_old_rec.contract_category
326: ,p_object_version_number_o
327: => pay_ppd_shd.g_old_rec.object_version_number
328: ,p_tax_reduction_o
329: => pay_ppd_shd.g_old_rec.tax_reduction
330: ,p_tax_calc_with_spouse_child_o
331: => pay_ppd_shd.g_old_rec.tax_calc_with_spouse_child

Line 329: => pay_ppd_shd.g_old_rec.tax_reduction

325: => pay_ppd_shd.g_old_rec.contract_category
326: ,p_object_version_number_o
327: => pay_ppd_shd.g_old_rec.object_version_number
328: ,p_tax_reduction_o
329: => pay_ppd_shd.g_old_rec.tax_reduction
330: ,p_tax_calc_with_spouse_child_o
331: => pay_ppd_shd.g_old_rec.tax_calc_with_spouse_child
332: ,p_income_reduction_o
333: => pay_ppd_shd.g_old_rec.income_reduction

Line 331: => pay_ppd_shd.g_old_rec.tax_calc_with_spouse_child

327: => pay_ppd_shd.g_old_rec.object_version_number
328: ,p_tax_reduction_o
329: => pay_ppd_shd.g_old_rec.tax_reduction
330: ,p_tax_calc_with_spouse_child_o
331: => pay_ppd_shd.g_old_rec.tax_calc_with_spouse_child
332: ,p_income_reduction_o
333: => pay_ppd_shd.g_old_rec.income_reduction
334: ,p_income_reduction_amount_o
335: => pay_ppd_shd.g_old_rec.income_reduction_amount

Line 333: => pay_ppd_shd.g_old_rec.income_reduction

329: => pay_ppd_shd.g_old_rec.tax_reduction
330: ,p_tax_calc_with_spouse_child_o
331: => pay_ppd_shd.g_old_rec.tax_calc_with_spouse_child
332: ,p_income_reduction_o
333: => pay_ppd_shd.g_old_rec.income_reduction
334: ,p_income_reduction_amount_o
335: => pay_ppd_shd.g_old_rec.income_reduction_amount
336: ,p_rate_of_tax_o
337: => pay_ppd_shd.g_old_rec.rate_of_tax

Line 335: => pay_ppd_shd.g_old_rec.income_reduction_amount

331: => pay_ppd_shd.g_old_rec.tax_calc_with_spouse_child
332: ,p_income_reduction_o
333: => pay_ppd_shd.g_old_rec.income_reduction
334: ,p_income_reduction_amount_o
335: => pay_ppd_shd.g_old_rec.income_reduction_amount
336: ,p_rate_of_tax_o
337: => pay_ppd_shd.g_old_rec.rate_of_tax
338: ,p_program_id_o
339: => pay_ppd_shd.g_old_rec.program_id

Line 337: => pay_ppd_shd.g_old_rec.rate_of_tax

333: => pay_ppd_shd.g_old_rec.income_reduction
334: ,p_income_reduction_amount_o
335: => pay_ppd_shd.g_old_rec.income_reduction_amount
336: ,p_rate_of_tax_o
337: => pay_ppd_shd.g_old_rec.rate_of_tax
338: ,p_program_id_o
339: => pay_ppd_shd.g_old_rec.program_id
340: ,p_program_login_id_o
341: => pay_ppd_shd.g_old_rec.program_login_id

Line 339: => pay_ppd_shd.g_old_rec.program_id

335: => pay_ppd_shd.g_old_rec.income_reduction_amount
336: ,p_rate_of_tax_o
337: => pay_ppd_shd.g_old_rec.rate_of_tax
338: ,p_program_id_o
339: => pay_ppd_shd.g_old_rec.program_id
340: ,p_program_login_id_o
341: => pay_ppd_shd.g_old_rec.program_login_id
342: ,p_program_application_id_o
343: => pay_ppd_shd.g_old_rec.program_application_id

Line 341: => pay_ppd_shd.g_old_rec.program_login_id

337: => pay_ppd_shd.g_old_rec.rate_of_tax
338: ,p_program_id_o
339: => pay_ppd_shd.g_old_rec.program_id
340: ,p_program_login_id_o
341: => pay_ppd_shd.g_old_rec.program_login_id
342: ,p_program_application_id_o
343: => pay_ppd_shd.g_old_rec.program_application_id
344: ,p_request_id_o
345: => pay_ppd_shd.g_old_rec.request_id

Line 343: => pay_ppd_shd.g_old_rec.program_application_id

339: => pay_ppd_shd.g_old_rec.program_id
340: ,p_program_login_id_o
341: => pay_ppd_shd.g_old_rec.program_login_id
342: ,p_program_application_id_o
343: => pay_ppd_shd.g_old_rec.program_application_id
344: ,p_request_id_o
345: => pay_ppd_shd.g_old_rec.request_id
346: );
347: --

Line 345: => pay_ppd_shd.g_old_rec.request_id

341: => pay_ppd_shd.g_old_rec.program_login_id
342: ,p_program_application_id_o
343: => pay_ppd_shd.g_old_rec.program_application_id
344: ,p_request_id_o
345: => pay_ppd_shd.g_old_rec.request_id
346: );
347: --
348: exception
349: --

Line 367: ,p_rec in out nocopy pay_ppd_shd.g_rec_type

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

Line 383: pay_ppd_shd.lck

379: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
380: --
381: -- We must lock the row which we need to delete.
382: --
383: pay_ppd_shd.lck
384: (p_effective_date => p_effective_date
385: ,p_datetrack_mode => p_datetrack_mode
386: ,p_paye_details_id => p_rec.paye_details_id
387: ,p_object_version_number => p_rec.object_version_number

Line 452: l_rec pay_ppd_shd.g_rec_type;

448: ,p_effective_start_date out nocopy date
449: ,p_effective_end_date out nocopy date
450: ) is
451: --
452: l_rec pay_ppd_shd.g_rec_type;
453: l_proc varchar2(72) := g_package||'del';
454: --
455: Begin
456: hr_utility.set_location('Entering:'||l_proc, 5);