APPS.PAY_PSD_DEL dependencies on PAY_PSD_SHD

Line 54: (p_rec in out nocopy pay_psd_shd.g_rec_type

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

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

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

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

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

284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure post_delete
288: (p_rec in pay_psd_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_psd_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_psd_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o
319: => pay_psd_shd.g_old_rec.effective_end_date
320: ,p_per_or_asg_id_o
321: => pay_psd_shd.g_old_rec.per_or_asg_id

Line 319: => pay_psd_shd.g_old_rec.effective_end_date

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

Line 321: => pay_psd_shd.g_old_rec.per_or_asg_id

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

Line 323: => pay_psd_shd.g_old_rec.business_group_id

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

Line 325: => pay_psd_shd.g_old_rec.contract_category

321: => pay_psd_shd.g_old_rec.per_or_asg_id
322: ,p_business_group_id_o
323: => pay_psd_shd.g_old_rec.business_group_id
324: ,p_contract_category_o
325: => pay_psd_shd.g_old_rec.contract_category
326: ,p_object_version_number_o
327: => pay_psd_shd.g_old_rec.object_version_number
328: ,p_emp_social_security_info_o
329: => pay_psd_shd.g_old_rec.emp_social_security_info

Line 327: => pay_psd_shd.g_old_rec.object_version_number

323: => pay_psd_shd.g_old_rec.business_group_id
324: ,p_contract_category_o
325: => pay_psd_shd.g_old_rec.contract_category
326: ,p_object_version_number_o
327: => pay_psd_shd.g_old_rec.object_version_number
328: ,p_emp_social_security_info_o
329: => pay_psd_shd.g_old_rec.emp_social_security_info
330: ,p_old_age_contribution_o
331: => pay_psd_shd.g_old_rec.old_age_contribution

Line 329: => pay_psd_shd.g_old_rec.emp_social_security_info

325: => pay_psd_shd.g_old_rec.contract_category
326: ,p_object_version_number_o
327: => pay_psd_shd.g_old_rec.object_version_number
328: ,p_emp_social_security_info_o
329: => pay_psd_shd.g_old_rec.emp_social_security_info
330: ,p_old_age_contribution_o
331: => pay_psd_shd.g_old_rec.old_age_contribution
332: ,p_pension_contribution_o
333: => pay_psd_shd.g_old_rec.pension_contribution

Line 331: => pay_psd_shd.g_old_rec.old_age_contribution

327: => pay_psd_shd.g_old_rec.object_version_number
328: ,p_emp_social_security_info_o
329: => pay_psd_shd.g_old_rec.emp_social_security_info
330: ,p_old_age_contribution_o
331: => pay_psd_shd.g_old_rec.old_age_contribution
332: ,p_pension_contribution_o
333: => pay_psd_shd.g_old_rec.pension_contribution
334: ,p_sickness_contribution_o
335: => pay_psd_shd.g_old_rec.sickness_contribution

Line 333: => pay_psd_shd.g_old_rec.pension_contribution

329: => pay_psd_shd.g_old_rec.emp_social_security_info
330: ,p_old_age_contribution_o
331: => pay_psd_shd.g_old_rec.old_age_contribution
332: ,p_pension_contribution_o
333: => pay_psd_shd.g_old_rec.pension_contribution
334: ,p_sickness_contribution_o
335: => pay_psd_shd.g_old_rec.sickness_contribution
336: ,p_work_injury_contribution_o
337: => pay_psd_shd.g_old_rec.work_injury_contribution

Line 335: => pay_psd_shd.g_old_rec.sickness_contribution

331: => pay_psd_shd.g_old_rec.old_age_contribution
332: ,p_pension_contribution_o
333: => pay_psd_shd.g_old_rec.pension_contribution
334: ,p_sickness_contribution_o
335: => pay_psd_shd.g_old_rec.sickness_contribution
336: ,p_work_injury_contribution_o
337: => pay_psd_shd.g_old_rec.work_injury_contribution
338: ,p_labor_contribution_o
339: => pay_psd_shd.g_old_rec.labor_contribution

Line 337: => pay_psd_shd.g_old_rec.work_injury_contribution

333: => pay_psd_shd.g_old_rec.pension_contribution
334: ,p_sickness_contribution_o
335: => pay_psd_shd.g_old_rec.sickness_contribution
336: ,p_work_injury_contribution_o
337: => pay_psd_shd.g_old_rec.work_injury_contribution
338: ,p_labor_contribution_o
339: => pay_psd_shd.g_old_rec.labor_contribution
340: ,p_health_contribution_o
341: => pay_psd_shd.g_old_rec.health_contribution

Line 339: => pay_psd_shd.g_old_rec.labor_contribution

335: => pay_psd_shd.g_old_rec.sickness_contribution
336: ,p_work_injury_contribution_o
337: => pay_psd_shd.g_old_rec.work_injury_contribution
338: ,p_labor_contribution_o
339: => pay_psd_shd.g_old_rec.labor_contribution
340: ,p_health_contribution_o
341: => pay_psd_shd.g_old_rec.health_contribution
342: ,p_unemployment_contribution_o
343: => pay_psd_shd.g_old_rec.unemployment_contribution

Line 341: => pay_psd_shd.g_old_rec.health_contribution

337: => pay_psd_shd.g_old_rec.work_injury_contribution
338: ,p_labor_contribution_o
339: => pay_psd_shd.g_old_rec.labor_contribution
340: ,p_health_contribution_o
341: => pay_psd_shd.g_old_rec.health_contribution
342: ,p_unemployment_contribution_o
343: => pay_psd_shd.g_old_rec.unemployment_contribution
344: ,p_old_age_cont_end_reason_o
345: => pay_psd_shd.g_old_rec.old_age_cont_end_reason

Line 343: => pay_psd_shd.g_old_rec.unemployment_contribution

339: => pay_psd_shd.g_old_rec.labor_contribution
340: ,p_health_contribution_o
341: => pay_psd_shd.g_old_rec.health_contribution
342: ,p_unemployment_contribution_o
343: => pay_psd_shd.g_old_rec.unemployment_contribution
344: ,p_old_age_cont_end_reason_o
345: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
346: ,p_pension_cont_end_reason_o
347: => pay_psd_shd.g_old_rec.pension_cont_end_reason

Line 345: => pay_psd_shd.g_old_rec.old_age_cont_end_reason

341: => pay_psd_shd.g_old_rec.health_contribution
342: ,p_unemployment_contribution_o
343: => pay_psd_shd.g_old_rec.unemployment_contribution
344: ,p_old_age_cont_end_reason_o
345: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
346: ,p_pension_cont_end_reason_o
347: => pay_psd_shd.g_old_rec.pension_cont_end_reason
348: ,p_sickness_cont_end_reason_o
349: => pay_psd_shd.g_old_rec.sickness_cont_end_reason

Line 347: => pay_psd_shd.g_old_rec.pension_cont_end_reason

343: => pay_psd_shd.g_old_rec.unemployment_contribution
344: ,p_old_age_cont_end_reason_o
345: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
346: ,p_pension_cont_end_reason_o
347: => pay_psd_shd.g_old_rec.pension_cont_end_reason
348: ,p_sickness_cont_end_reason_o
349: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
350: ,p_work_injury_cont_end_reaso_o
351: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason

Line 349: => pay_psd_shd.g_old_rec.sickness_cont_end_reason

345: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
346: ,p_pension_cont_end_reason_o
347: => pay_psd_shd.g_old_rec.pension_cont_end_reason
348: ,p_sickness_cont_end_reason_o
349: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
350: ,p_work_injury_cont_end_reaso_o
351: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
352: ,p_labor_fund_cont_end_reason_o
353: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason

Line 351: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason

347: => pay_psd_shd.g_old_rec.pension_cont_end_reason
348: ,p_sickness_cont_end_reason_o
349: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
350: ,p_work_injury_cont_end_reaso_o
351: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
352: ,p_labor_fund_cont_end_reason_o
353: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
354: ,p_health_cont_end_reason_o
355: => pay_psd_shd.g_old_rec.health_cont_end_reason

Line 353: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason

349: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
350: ,p_work_injury_cont_end_reaso_o
351: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
352: ,p_labor_fund_cont_end_reason_o
353: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
354: ,p_health_cont_end_reason_o
355: => pay_psd_shd.g_old_rec.health_cont_end_reason
356: ,p_unemployment_cont_end_reas_o
357: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason

Line 355: => pay_psd_shd.g_old_rec.health_cont_end_reason

351: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
352: ,p_labor_fund_cont_end_reason_o
353: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
354: ,p_health_cont_end_reason_o
355: => pay_psd_shd.g_old_rec.health_cont_end_reason
356: ,p_unemployment_cont_end_reas_o
357: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
358: ,p_program_id_o
359: => pay_psd_shd.g_old_rec.program_id

Line 357: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason

353: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
354: ,p_health_cont_end_reason_o
355: => pay_psd_shd.g_old_rec.health_cont_end_reason
356: ,p_unemployment_cont_end_reas_o
357: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
358: ,p_program_id_o
359: => pay_psd_shd.g_old_rec.program_id
360: ,p_program_login_id_o
361: => pay_psd_shd.g_old_rec.program_login_id

Line 359: => pay_psd_shd.g_old_rec.program_id

355: => pay_psd_shd.g_old_rec.health_cont_end_reason
356: ,p_unemployment_cont_end_reas_o
357: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
358: ,p_program_id_o
359: => pay_psd_shd.g_old_rec.program_id
360: ,p_program_login_id_o
361: => pay_psd_shd.g_old_rec.program_login_id
362: ,p_program_application_id_o
363: => pay_psd_shd.g_old_rec.program_application_id

Line 361: => pay_psd_shd.g_old_rec.program_login_id

357: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
358: ,p_program_id_o
359: => pay_psd_shd.g_old_rec.program_id
360: ,p_program_login_id_o
361: => pay_psd_shd.g_old_rec.program_login_id
362: ,p_program_application_id_o
363: => pay_psd_shd.g_old_rec.program_application_id
364: ,p_request_id_o
365: => pay_psd_shd.g_old_rec.request_id

Line 363: => pay_psd_shd.g_old_rec.program_application_id

359: => pay_psd_shd.g_old_rec.program_id
360: ,p_program_login_id_o
361: => pay_psd_shd.g_old_rec.program_login_id
362: ,p_program_application_id_o
363: => pay_psd_shd.g_old_rec.program_application_id
364: ,p_request_id_o
365: => pay_psd_shd.g_old_rec.request_id
366: );
367: --

Line 365: => pay_psd_shd.g_old_rec.request_id

361: => pay_psd_shd.g_old_rec.program_login_id
362: ,p_program_application_id_o
363: => pay_psd_shd.g_old_rec.program_application_id
364: ,p_request_id_o
365: => pay_psd_shd.g_old_rec.request_id
366: );
367: --
368: exception
369: --

Line 387: ,p_rec in out nocopy pay_psd_shd.g_rec_type

383: -- ----------------------------------------------------------------------------
384: Procedure del
385: (p_effective_date in date
386: ,p_datetrack_mode in varchar2
387: ,p_rec in out nocopy pay_psd_shd.g_rec_type
388: ) is
389: --
390: l_proc varchar2(72) := g_package||'del';
391: l_validation_start_date date;

Line 403: pay_psd_shd.lck

399: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
400: --
401: -- We must lock the row which we need to delete.
402: --
403: pay_psd_shd.lck
404: (p_effective_date => p_effective_date
405: ,p_datetrack_mode => p_datetrack_mode
406: ,p_sii_details_id => p_rec.sii_details_id
407: ,p_object_version_number => p_rec.object_version_number

Line 472: l_rec pay_psd_shd.g_rec_type;

468: ,p_effective_start_date out nocopy date
469: ,p_effective_end_date out nocopy date
470: ) is
471: --
472: l_rec pay_psd_shd.g_rec_type;
473: l_proc varchar2(72) := g_package||'del';
474: --
475: Begin
476: hr_utility.set_location('Entering:'||l_proc, 5);