54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_psd_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: --
130: pay_psd_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: --
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: --
135: pay_psd_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When Others Then
138: --
139: Raise;
170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure update_dml
174: (p_rec in out nocopy pay_psd_shd.g_rec_type
175: ,p_effective_date in date
176: ,p_datetrack_mode in varchar2
177: ,p_validation_start_date in date
178: ,p_validation_end_date in date
237: --
238: -- {End Of Comments}
239: -- ----------------------------------------------------------------------------
240: Procedure dt_pre_update
241: (p_rec in out nocopy pay_psd_shd.g_rec_type
242: ,p_effective_date in date
243: ,p_datetrack_mode in varchar2
244: ,p_validation_start_date in date
245: ,p_validation_end_date in date
253: If (p_datetrack_mode <> hr_api.g_correction) then
254: --
255: -- Update the current effective end date
256: --
257: pay_psd_shd.upd_effective_end_date
258: (p_effective_date => p_effective_date
259: ,p_base_key_value => p_rec.sii_details_id
260: ,p_new_effective_end_date => (p_validation_start_date - 1)
261: ,p_validation_start_date => p_validation_start_date
322: --
323: -- {End Of Comments}
324: -- ----------------------------------------------------------------------------
325: Procedure pre_update
326: (p_rec in out nocopy pay_psd_shd.g_rec_type
327: ,p_effective_date in date
328: ,p_datetrack_mode in varchar2
329: ,p_validation_start_date in date
330: ,p_validation_end_date in date
380: --
381: -- {End Of Comments}
382: -- ----------------------------------------------------------------------------
383: Procedure post_update
384: (p_rec in pay_psd_shd.g_rec_type
385: ,p_effective_date in date
386: ,p_datetrack_mode in varchar2
387: ,p_validation_start_date in date
388: ,p_validation_end_date in date
449: => p_rec.program_application_id
450: ,p_request_id
451: => p_rec.request_id
452: ,p_effective_start_date_o
453: => pay_psd_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o
455: => pay_psd_shd.g_old_rec.effective_end_date
456: ,p_per_or_asg_id_o
457: => pay_psd_shd.g_old_rec.per_or_asg_id
451: => p_rec.request_id
452: ,p_effective_start_date_o
453: => pay_psd_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o
455: => pay_psd_shd.g_old_rec.effective_end_date
456: ,p_per_or_asg_id_o
457: => pay_psd_shd.g_old_rec.per_or_asg_id
458: ,p_business_group_id_o
459: => pay_psd_shd.g_old_rec.business_group_id
453: => pay_psd_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o
455: => pay_psd_shd.g_old_rec.effective_end_date
456: ,p_per_or_asg_id_o
457: => pay_psd_shd.g_old_rec.per_or_asg_id
458: ,p_business_group_id_o
459: => pay_psd_shd.g_old_rec.business_group_id
460: ,p_contract_category_o
461: => pay_psd_shd.g_old_rec.contract_category
455: => pay_psd_shd.g_old_rec.effective_end_date
456: ,p_per_or_asg_id_o
457: => pay_psd_shd.g_old_rec.per_or_asg_id
458: ,p_business_group_id_o
459: => pay_psd_shd.g_old_rec.business_group_id
460: ,p_contract_category_o
461: => pay_psd_shd.g_old_rec.contract_category
462: ,p_object_version_number_o
463: => pay_psd_shd.g_old_rec.object_version_number
457: => pay_psd_shd.g_old_rec.per_or_asg_id
458: ,p_business_group_id_o
459: => pay_psd_shd.g_old_rec.business_group_id
460: ,p_contract_category_o
461: => pay_psd_shd.g_old_rec.contract_category
462: ,p_object_version_number_o
463: => pay_psd_shd.g_old_rec.object_version_number
464: ,p_emp_social_security_info_o
465: => pay_psd_shd.g_old_rec.emp_social_security_info
459: => pay_psd_shd.g_old_rec.business_group_id
460: ,p_contract_category_o
461: => pay_psd_shd.g_old_rec.contract_category
462: ,p_object_version_number_o
463: => pay_psd_shd.g_old_rec.object_version_number
464: ,p_emp_social_security_info_o
465: => pay_psd_shd.g_old_rec.emp_social_security_info
466: ,p_old_age_contribution_o
467: => pay_psd_shd.g_old_rec.old_age_contribution
461: => pay_psd_shd.g_old_rec.contract_category
462: ,p_object_version_number_o
463: => pay_psd_shd.g_old_rec.object_version_number
464: ,p_emp_social_security_info_o
465: => pay_psd_shd.g_old_rec.emp_social_security_info
466: ,p_old_age_contribution_o
467: => pay_psd_shd.g_old_rec.old_age_contribution
468: ,p_pension_contribution_o
469: => pay_psd_shd.g_old_rec.pension_contribution
463: => pay_psd_shd.g_old_rec.object_version_number
464: ,p_emp_social_security_info_o
465: => pay_psd_shd.g_old_rec.emp_social_security_info
466: ,p_old_age_contribution_o
467: => pay_psd_shd.g_old_rec.old_age_contribution
468: ,p_pension_contribution_o
469: => pay_psd_shd.g_old_rec.pension_contribution
470: ,p_sickness_contribution_o
471: => pay_psd_shd.g_old_rec.sickness_contribution
465: => pay_psd_shd.g_old_rec.emp_social_security_info
466: ,p_old_age_contribution_o
467: => pay_psd_shd.g_old_rec.old_age_contribution
468: ,p_pension_contribution_o
469: => pay_psd_shd.g_old_rec.pension_contribution
470: ,p_sickness_contribution_o
471: => pay_psd_shd.g_old_rec.sickness_contribution
472: ,p_work_injury_contribution_o
473: => pay_psd_shd.g_old_rec.work_injury_contribution
467: => pay_psd_shd.g_old_rec.old_age_contribution
468: ,p_pension_contribution_o
469: => pay_psd_shd.g_old_rec.pension_contribution
470: ,p_sickness_contribution_o
471: => pay_psd_shd.g_old_rec.sickness_contribution
472: ,p_work_injury_contribution_o
473: => pay_psd_shd.g_old_rec.work_injury_contribution
474: ,p_labor_contribution_o
475: => pay_psd_shd.g_old_rec.labor_contribution
469: => pay_psd_shd.g_old_rec.pension_contribution
470: ,p_sickness_contribution_o
471: => pay_psd_shd.g_old_rec.sickness_contribution
472: ,p_work_injury_contribution_o
473: => pay_psd_shd.g_old_rec.work_injury_contribution
474: ,p_labor_contribution_o
475: => pay_psd_shd.g_old_rec.labor_contribution
476: ,p_health_contribution_o
477: => pay_psd_shd.g_old_rec.health_contribution
471: => pay_psd_shd.g_old_rec.sickness_contribution
472: ,p_work_injury_contribution_o
473: => pay_psd_shd.g_old_rec.work_injury_contribution
474: ,p_labor_contribution_o
475: => pay_psd_shd.g_old_rec.labor_contribution
476: ,p_health_contribution_o
477: => pay_psd_shd.g_old_rec.health_contribution
478: ,p_unemployment_contribution_o
479: => pay_psd_shd.g_old_rec.unemployment_contribution
473: => pay_psd_shd.g_old_rec.work_injury_contribution
474: ,p_labor_contribution_o
475: => pay_psd_shd.g_old_rec.labor_contribution
476: ,p_health_contribution_o
477: => pay_psd_shd.g_old_rec.health_contribution
478: ,p_unemployment_contribution_o
479: => pay_psd_shd.g_old_rec.unemployment_contribution
480: ,p_old_age_cont_end_reason_o
481: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
475: => pay_psd_shd.g_old_rec.labor_contribution
476: ,p_health_contribution_o
477: => pay_psd_shd.g_old_rec.health_contribution
478: ,p_unemployment_contribution_o
479: => pay_psd_shd.g_old_rec.unemployment_contribution
480: ,p_old_age_cont_end_reason_o
481: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
482: ,p_pension_cont_end_reason_o
483: => pay_psd_shd.g_old_rec.pension_cont_end_reason
477: => pay_psd_shd.g_old_rec.health_contribution
478: ,p_unemployment_contribution_o
479: => pay_psd_shd.g_old_rec.unemployment_contribution
480: ,p_old_age_cont_end_reason_o
481: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
482: ,p_pension_cont_end_reason_o
483: => pay_psd_shd.g_old_rec.pension_cont_end_reason
484: ,p_sickness_cont_end_reason_o
485: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
479: => pay_psd_shd.g_old_rec.unemployment_contribution
480: ,p_old_age_cont_end_reason_o
481: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
482: ,p_pension_cont_end_reason_o
483: => pay_psd_shd.g_old_rec.pension_cont_end_reason
484: ,p_sickness_cont_end_reason_o
485: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
486: ,p_work_injury_cont_end_reaso_o
487: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
481: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
482: ,p_pension_cont_end_reason_o
483: => pay_psd_shd.g_old_rec.pension_cont_end_reason
484: ,p_sickness_cont_end_reason_o
485: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
486: ,p_work_injury_cont_end_reaso_o
487: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
488: ,p_labor_fund_cont_end_reason_o
489: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
483: => pay_psd_shd.g_old_rec.pension_cont_end_reason
484: ,p_sickness_cont_end_reason_o
485: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
486: ,p_work_injury_cont_end_reaso_o
487: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
488: ,p_labor_fund_cont_end_reason_o
489: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
490: ,p_health_cont_end_reason_o
491: => pay_psd_shd.g_old_rec.health_cont_end_reason
485: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
486: ,p_work_injury_cont_end_reaso_o
487: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
488: ,p_labor_fund_cont_end_reason_o
489: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
490: ,p_health_cont_end_reason_o
491: => pay_psd_shd.g_old_rec.health_cont_end_reason
492: ,p_unemployment_cont_end_reas_o
493: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
487: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
488: ,p_labor_fund_cont_end_reason_o
489: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
490: ,p_health_cont_end_reason_o
491: => pay_psd_shd.g_old_rec.health_cont_end_reason
492: ,p_unemployment_cont_end_reas_o
493: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
494: ,p_program_id_o
495: => pay_psd_shd.g_old_rec.program_id
489: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
490: ,p_health_cont_end_reason_o
491: => pay_psd_shd.g_old_rec.health_cont_end_reason
492: ,p_unemployment_cont_end_reas_o
493: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
494: ,p_program_id_o
495: => pay_psd_shd.g_old_rec.program_id
496: ,p_program_login_id_o
497: => pay_psd_shd.g_old_rec.program_login_id
491: => pay_psd_shd.g_old_rec.health_cont_end_reason
492: ,p_unemployment_cont_end_reas_o
493: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
494: ,p_program_id_o
495: => pay_psd_shd.g_old_rec.program_id
496: ,p_program_login_id_o
497: => pay_psd_shd.g_old_rec.program_login_id
498: ,p_program_application_id_o
499: => pay_psd_shd.g_old_rec.program_application_id
493: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
494: ,p_program_id_o
495: => pay_psd_shd.g_old_rec.program_id
496: ,p_program_login_id_o
497: => pay_psd_shd.g_old_rec.program_login_id
498: ,p_program_application_id_o
499: => pay_psd_shd.g_old_rec.program_application_id
500: ,p_request_id_o
501: => pay_psd_shd.g_old_rec.request_id
495: => pay_psd_shd.g_old_rec.program_id
496: ,p_program_login_id_o
497: => pay_psd_shd.g_old_rec.program_login_id
498: ,p_program_application_id_o
499: => pay_psd_shd.g_old_rec.program_application_id
500: ,p_request_id_o
501: => pay_psd_shd.g_old_rec.request_id
502: );
503: --
497: => pay_psd_shd.g_old_rec.program_login_id
498: ,p_program_application_id_o
499: => pay_psd_shd.g_old_rec.program_application_id
500: ,p_request_id_o
501: => pay_psd_shd.g_old_rec.request_id
502: );
503: --
504: exception
505: --
557: --
558: -- {End Of Comments}
559: -- ----------------------------------------------------------------------------
560: Procedure convert_defs
561: (p_rec in out nocopy pay_psd_shd.g_rec_type
562: ) is
563: --
564: Begin
565: --
569: -- is being used then we must set to the 'current' argument value.
570: --
571: If (p_rec.per_or_asg_id = hr_api.g_number) then
572: p_rec.per_or_asg_id :=
573: pay_psd_shd.g_old_rec.per_or_asg_id;
574: End If;
575: If (p_rec.business_group_id = hr_api.g_number) then
576: p_rec.business_group_id :=
577: pay_psd_shd.g_old_rec.business_group_id;
573: pay_psd_shd.g_old_rec.per_or_asg_id;
574: End If;
575: If (p_rec.business_group_id = hr_api.g_number) then
576: p_rec.business_group_id :=
577: pay_psd_shd.g_old_rec.business_group_id;
578: End If;
579: If (p_rec.contract_category = hr_api.g_varchar2) then
580: p_rec.contract_category :=
581: pay_psd_shd.g_old_rec.contract_category;
577: pay_psd_shd.g_old_rec.business_group_id;
578: End If;
579: If (p_rec.contract_category = hr_api.g_varchar2) then
580: p_rec.contract_category :=
581: pay_psd_shd.g_old_rec.contract_category;
582: End If;
583: If (p_rec.emp_social_security_info = hr_api.g_varchar2) then
584: p_rec.emp_social_security_info :=
585: pay_psd_shd.g_old_rec.emp_social_security_info;
581: pay_psd_shd.g_old_rec.contract_category;
582: End If;
583: If (p_rec.emp_social_security_info = hr_api.g_varchar2) then
584: p_rec.emp_social_security_info :=
585: pay_psd_shd.g_old_rec.emp_social_security_info;
586: End If;
587: If (p_rec.old_age_contribution = hr_api.g_varchar2) then
588: p_rec.old_age_contribution :=
589: pay_psd_shd.g_old_rec.old_age_contribution;
585: pay_psd_shd.g_old_rec.emp_social_security_info;
586: End If;
587: If (p_rec.old_age_contribution = hr_api.g_varchar2) then
588: p_rec.old_age_contribution :=
589: pay_psd_shd.g_old_rec.old_age_contribution;
590: End If;
591: If (p_rec.pension_contribution = hr_api.g_varchar2) then
592: p_rec.pension_contribution :=
593: pay_psd_shd.g_old_rec.pension_contribution;
589: pay_psd_shd.g_old_rec.old_age_contribution;
590: End If;
591: If (p_rec.pension_contribution = hr_api.g_varchar2) then
592: p_rec.pension_contribution :=
593: pay_psd_shd.g_old_rec.pension_contribution;
594: End If;
595: If (p_rec.sickness_contribution = hr_api.g_varchar2) then
596: p_rec.sickness_contribution :=
597: pay_psd_shd.g_old_rec.sickness_contribution;
593: pay_psd_shd.g_old_rec.pension_contribution;
594: End If;
595: If (p_rec.sickness_contribution = hr_api.g_varchar2) then
596: p_rec.sickness_contribution :=
597: pay_psd_shd.g_old_rec.sickness_contribution;
598: End If;
599: If (p_rec.work_injury_contribution = hr_api.g_varchar2) then
600: p_rec.work_injury_contribution :=
601: pay_psd_shd.g_old_rec.work_injury_contribution;
597: pay_psd_shd.g_old_rec.sickness_contribution;
598: End If;
599: If (p_rec.work_injury_contribution = hr_api.g_varchar2) then
600: p_rec.work_injury_contribution :=
601: pay_psd_shd.g_old_rec.work_injury_contribution;
602: End If;
603: If (p_rec.labor_contribution = hr_api.g_varchar2) then
604: p_rec.labor_contribution :=
605: pay_psd_shd.g_old_rec.labor_contribution;
601: pay_psd_shd.g_old_rec.work_injury_contribution;
602: End If;
603: If (p_rec.labor_contribution = hr_api.g_varchar2) then
604: p_rec.labor_contribution :=
605: pay_psd_shd.g_old_rec.labor_contribution;
606: End If;
607: If (p_rec.health_contribution = hr_api.g_varchar2) then
608: p_rec.health_contribution :=
609: pay_psd_shd.g_old_rec.health_contribution;
605: pay_psd_shd.g_old_rec.labor_contribution;
606: End If;
607: If (p_rec.health_contribution = hr_api.g_varchar2) then
608: p_rec.health_contribution :=
609: pay_psd_shd.g_old_rec.health_contribution;
610: End If;
611: If (p_rec.unemployment_contribution = hr_api.g_varchar2) then
612: p_rec.unemployment_contribution :=
613: pay_psd_shd.g_old_rec.unemployment_contribution;
609: pay_psd_shd.g_old_rec.health_contribution;
610: End If;
611: If (p_rec.unemployment_contribution = hr_api.g_varchar2) then
612: p_rec.unemployment_contribution :=
613: pay_psd_shd.g_old_rec.unemployment_contribution;
614: End If;
615: If (p_rec.old_age_cont_end_reason = hr_api.g_varchar2) then
616: p_rec.old_age_cont_end_reason :=
617: pay_psd_shd.g_old_rec.old_age_cont_end_reason;
613: pay_psd_shd.g_old_rec.unemployment_contribution;
614: End If;
615: If (p_rec.old_age_cont_end_reason = hr_api.g_varchar2) then
616: p_rec.old_age_cont_end_reason :=
617: pay_psd_shd.g_old_rec.old_age_cont_end_reason;
618: End If;
619: If (p_rec.pension_cont_end_reason = hr_api.g_varchar2) then
620: p_rec.pension_cont_end_reason :=
621: pay_psd_shd.g_old_rec.pension_cont_end_reason;
617: pay_psd_shd.g_old_rec.old_age_cont_end_reason;
618: End If;
619: If (p_rec.pension_cont_end_reason = hr_api.g_varchar2) then
620: p_rec.pension_cont_end_reason :=
621: pay_psd_shd.g_old_rec.pension_cont_end_reason;
622: End If;
623: If (p_rec.sickness_cont_end_reason = hr_api.g_varchar2) then
624: p_rec.sickness_cont_end_reason :=
625: pay_psd_shd.g_old_rec.sickness_cont_end_reason;
621: pay_psd_shd.g_old_rec.pension_cont_end_reason;
622: End If;
623: If (p_rec.sickness_cont_end_reason = hr_api.g_varchar2) then
624: p_rec.sickness_cont_end_reason :=
625: pay_psd_shd.g_old_rec.sickness_cont_end_reason;
626: End If;
627: If (p_rec.work_injury_cont_end_reason = hr_api.g_varchar2) then
628: p_rec.work_injury_cont_end_reason :=
629: pay_psd_shd.g_old_rec.work_injury_cont_end_reason;
625: pay_psd_shd.g_old_rec.sickness_cont_end_reason;
626: End If;
627: If (p_rec.work_injury_cont_end_reason = hr_api.g_varchar2) then
628: p_rec.work_injury_cont_end_reason :=
629: pay_psd_shd.g_old_rec.work_injury_cont_end_reason;
630: End If;
631: If (p_rec.labor_fund_cont_end_reason = hr_api.g_varchar2) then
632: p_rec.labor_fund_cont_end_reason :=
633: pay_psd_shd.g_old_rec.labor_fund_cont_end_reason;
629: pay_psd_shd.g_old_rec.work_injury_cont_end_reason;
630: End If;
631: If (p_rec.labor_fund_cont_end_reason = hr_api.g_varchar2) then
632: p_rec.labor_fund_cont_end_reason :=
633: pay_psd_shd.g_old_rec.labor_fund_cont_end_reason;
634: End If;
635: If (p_rec.health_cont_end_reason = hr_api.g_varchar2) then
636: p_rec.health_cont_end_reason :=
637: pay_psd_shd.g_old_rec.health_cont_end_reason;
633: pay_psd_shd.g_old_rec.labor_fund_cont_end_reason;
634: End If;
635: If (p_rec.health_cont_end_reason = hr_api.g_varchar2) then
636: p_rec.health_cont_end_reason :=
637: pay_psd_shd.g_old_rec.health_cont_end_reason;
638: End If;
639: If (p_rec.unemployment_cont_end_reason = hr_api.g_varchar2) then
640: p_rec.unemployment_cont_end_reason :=
641: pay_psd_shd.g_old_rec.unemployment_cont_end_reason;
637: pay_psd_shd.g_old_rec.health_cont_end_reason;
638: End If;
639: If (p_rec.unemployment_cont_end_reason = hr_api.g_varchar2) then
640: p_rec.unemployment_cont_end_reason :=
641: pay_psd_shd.g_old_rec.unemployment_cont_end_reason;
642: End If;
643: If (p_rec.program_id = hr_api.g_number) then
644: p_rec.program_id :=
645: pay_psd_shd.g_old_rec.program_id;
641: pay_psd_shd.g_old_rec.unemployment_cont_end_reason;
642: End If;
643: If (p_rec.program_id = hr_api.g_number) then
644: p_rec.program_id :=
645: pay_psd_shd.g_old_rec.program_id;
646: End If;
647: If (p_rec.program_login_id = hr_api.g_number) then
648: p_rec.program_login_id :=
649: pay_psd_shd.g_old_rec.program_login_id;
645: pay_psd_shd.g_old_rec.program_id;
646: End If;
647: If (p_rec.program_login_id = hr_api.g_number) then
648: p_rec.program_login_id :=
649: pay_psd_shd.g_old_rec.program_login_id;
650: End If;
651: If (p_rec.program_application_id = hr_api.g_number) then
652: p_rec.program_application_id :=
653: pay_psd_shd.g_old_rec.program_application_id;
649: pay_psd_shd.g_old_rec.program_login_id;
650: End If;
651: If (p_rec.program_application_id = hr_api.g_number) then
652: p_rec.program_application_id :=
653: pay_psd_shd.g_old_rec.program_application_id;
654: End If;
655: If (p_rec.request_id = hr_api.g_number) then
656: p_rec.request_id :=
657: pay_psd_shd.g_old_rec.request_id;
653: pay_psd_shd.g_old_rec.program_application_id;
654: End If;
655: If (p_rec.request_id = hr_api.g_number) then
656: p_rec.request_id :=
657: pay_psd_shd.g_old_rec.request_id;
658: End If;
659: --
660: End convert_defs;
661: --
664: -- ----------------------------------------------------------------------------
665: Procedure upd
666: (p_effective_date in date
667: ,p_datetrack_mode in varchar2
668: ,p_rec in out nocopy pay_psd_shd.g_rec_type
669: ) is
670: --
671: l_proc varchar2(72) := g_package||'upd';
672: l_validation_start_date date;
680: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
681: --
682: -- We must lock the row which we need to update.
683: --
684: pay_psd_shd.lck
685: (p_effective_date => p_effective_date
686: ,p_datetrack_mode => p_datetrack_mode
687: ,p_sii_details_id => p_rec.sii_details_id
688: ,p_object_version_number => p_rec.object_version_number
773: ,p_effective_start_date out nocopy date
774: ,p_effective_end_date out nocopy date
775: ) is
776: --
777: l_rec pay_psd_shd.g_rec_type;
778: l_proc varchar2(72) := g_package||'upd';
779: --
780: Begin
781: hr_utility.set_location('Entering:'||l_proc, 5);
783: -- Call conversion function to turn arguments into the
784: -- l_rec structure.
785: --
786: l_rec :=
787: pay_psd_shd.convert_args
788: (p_sii_details_id
789: ,null
790: ,null
791: ,hr_api.g_number