DBA Data[Home] [Help]

APPS.PAY_PSD_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 127: When hr_api.check_integrity_violated Then

123: End If;
124: --
125: hr_utility.set_location(' Leaving:'||l_proc, 15);
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));

Line 131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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: --
135: pay_psd_shd.constraint_error

Line 132: When hr_api.unique_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: --
135: pay_psd_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 136: (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;
140: End dt_update_dml;

Line 253: If (p_datetrack_mode <> hr_api.g_correction) then

249: l_dummy_version_number number;
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);
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

Line 266: If (p_datetrack_mode = hr_api.g_update_override) then

262: ,p_validation_end_date => p_validation_end_date
263: ,p_object_version_number => l_dummy_version_number
264: );
265: --
266: If (p_datetrack_mode = hr_api.g_update_override) then
267: --
268: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
269: -- delete any future rows
270: --

Line 506: when hr_api.cannot_find_prog_unit then

502: );
503: --
504: exception
505: --
506: when hr_api.cannot_find_prog_unit then
507: --
508: hr_api.cannot_find_prog_unit_error
509: (p_module_name => 'PAY_PL_SII_DETAILS_F'
510: ,p_hook_type => 'AU');

Line 508: hr_api.cannot_find_prog_unit_error

504: exception
505: --
506: when hr_api.cannot_find_prog_unit then
507: --
508: hr_api.cannot_find_prog_unit_error
509: (p_module_name => 'PAY_PL_SII_DETAILS_F'
510: ,p_hook_type => 'AU');
511: --
512: end;

Line 571: If (p_rec.per_or_asg_id = hr_api.g_number) then

567: -- p_rec plsql record structure
568: -- to see if a system default is being used. If a system default
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

Line 575: If (p_rec.business_group_id = hr_api.g_number) then

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;
578: End If;
579: If (p_rec.contract_category = hr_api.g_varchar2) then

Line 579: If (p_rec.contract_category = hr_api.g_varchar2) then

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;
582: End If;
583: If (p_rec.emp_social_security_info = hr_api.g_varchar2) then

Line 583: If (p_rec.emp_social_security_info = hr_api.g_varchar2) then

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;
586: End If;
587: If (p_rec.old_age_contribution = hr_api.g_varchar2) then

Line 587: If (p_rec.old_age_contribution = hr_api.g_varchar2) then

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;
590: End If;
591: If (p_rec.pension_contribution = hr_api.g_varchar2) then

Line 591: If (p_rec.pension_contribution = hr_api.g_varchar2) then

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;
594: End If;
595: If (p_rec.sickness_contribution = hr_api.g_varchar2) then

Line 595: If (p_rec.sickness_contribution = hr_api.g_varchar2) then

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;
598: End If;
599: If (p_rec.work_injury_contribution = hr_api.g_varchar2) then

Line 599: If (p_rec.work_injury_contribution = hr_api.g_varchar2) then

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;
602: End If;
603: If (p_rec.labor_contribution = hr_api.g_varchar2) then

Line 603: If (p_rec.labor_contribution = hr_api.g_varchar2) then

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;
606: End If;
607: If (p_rec.health_contribution = hr_api.g_varchar2) then

Line 607: If (p_rec.health_contribution = hr_api.g_varchar2) then

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;
610: End If;
611: If (p_rec.unemployment_contribution = hr_api.g_varchar2) then

Line 611: If (p_rec.unemployment_contribution = hr_api.g_varchar2) then

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;
614: End If;
615: If (p_rec.old_age_cont_end_reason = hr_api.g_varchar2) then

Line 615: If (p_rec.old_age_cont_end_reason = hr_api.g_varchar2) then

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;
618: End If;
619: If (p_rec.pension_cont_end_reason = hr_api.g_varchar2) then

Line 619: If (p_rec.pension_cont_end_reason = hr_api.g_varchar2) then

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;
622: End If;
623: If (p_rec.sickness_cont_end_reason = hr_api.g_varchar2) then

Line 623: If (p_rec.sickness_cont_end_reason = hr_api.g_varchar2) then

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;
626: End If;
627: If (p_rec.work_injury_cont_end_reason = hr_api.g_varchar2) then

Line 627: If (p_rec.work_injury_cont_end_reason = hr_api.g_varchar2) then

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;
630: End If;
631: If (p_rec.labor_fund_cont_end_reason = hr_api.g_varchar2) then

Line 631: If (p_rec.labor_fund_cont_end_reason = hr_api.g_varchar2) then

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;
634: End If;
635: If (p_rec.health_cont_end_reason = hr_api.g_varchar2) then

Line 635: If (p_rec.health_cont_end_reason = hr_api.g_varchar2) then

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;
638: End If;
639: If (p_rec.unemployment_cont_end_reason = hr_api.g_varchar2) then

Line 639: If (p_rec.unemployment_cont_end_reason = hr_api.g_varchar2) then

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;
642: End If;
643: If (p_rec.program_id = hr_api.g_number) then

Line 643: If (p_rec.program_id = hr_api.g_number) then

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;
646: End If;
647: If (p_rec.program_login_id = hr_api.g_number) then

Line 647: If (p_rec.program_login_id = hr_api.g_number) then

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;
650: End If;
651: If (p_rec.program_application_id = hr_api.g_number) then

Line 651: If (p_rec.program_application_id = hr_api.g_number) then

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;
654: End If;
655: If (p_rec.request_id = hr_api.g_number) then

Line 655: If (p_rec.request_id = hr_api.g_number) then

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;
658: End If;
659: --

Line 754: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2

750: (p_effective_date in date
751: ,p_datetrack_mode in varchar2
752: ,p_sii_details_id in number
753: ,p_object_version_number in out nocopy number
754: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
755: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
756: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
757: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
758: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2

Line 755: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2

751: ,p_datetrack_mode in varchar2
752: ,p_sii_details_id in number
753: ,p_object_version_number in out nocopy number
754: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
755: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
756: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
757: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
758: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
759: ,p_labor_contribution in varchar2 default hr_api.g_varchar2

Line 756: ,p_pension_contribution in varchar2 default hr_api.g_varchar2

752: ,p_sii_details_id in number
753: ,p_object_version_number in out nocopy number
754: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
755: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
756: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
757: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
758: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
759: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
760: ,p_health_contribution in varchar2 default hr_api.g_varchar2

Line 757: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2

753: ,p_object_version_number in out nocopy number
754: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
755: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
756: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
757: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
758: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
759: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
760: ,p_health_contribution in varchar2 default hr_api.g_varchar2
761: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2

Line 758: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2

754: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
755: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
756: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
757: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
758: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
759: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
760: ,p_health_contribution in varchar2 default hr_api.g_varchar2
761: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
762: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 759: ,p_labor_contribution in varchar2 default hr_api.g_varchar2

755: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
756: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
757: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
758: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
759: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
760: ,p_health_contribution in varchar2 default hr_api.g_varchar2
761: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
762: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
763: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 760: ,p_health_contribution in varchar2 default hr_api.g_varchar2

756: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
757: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
758: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
759: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
760: ,p_health_contribution in varchar2 default hr_api.g_varchar2
761: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
762: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
763: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
764: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 761: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2

757: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
758: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
759: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
760: ,p_health_contribution in varchar2 default hr_api.g_varchar2
761: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
762: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
763: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
764: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
765: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 762: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2

758: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
759: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
760: ,p_health_contribution in varchar2 default hr_api.g_varchar2
761: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
762: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
763: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
764: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
765: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
766: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 763: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2

759: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
760: ,p_health_contribution in varchar2 default hr_api.g_varchar2
761: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
762: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
763: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
764: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
765: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
766: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
767: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 764: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2

760: ,p_health_contribution in varchar2 default hr_api.g_varchar2
761: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
762: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
763: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
764: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
765: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
766: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
767: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
768: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 765: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2

761: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
762: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
763: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
764: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
765: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
766: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
767: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
768: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
769: ,p_program_id in number default hr_api.g_number

Line 766: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2

762: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
763: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
764: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
765: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
766: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
767: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
768: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
769: ,p_program_id in number default hr_api.g_number
770: ,p_program_login_id in number default hr_api.g_number

Line 767: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2

763: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
764: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
765: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
766: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
767: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
768: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
769: ,p_program_id in number default hr_api.g_number
770: ,p_program_login_id in number default hr_api.g_number
771: ,p_program_application_id in number default hr_api.g_number

Line 768: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2

764: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
765: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
766: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
767: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
768: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
769: ,p_program_id in number default hr_api.g_number
770: ,p_program_login_id in number default hr_api.g_number
771: ,p_program_application_id in number default hr_api.g_number
772: ,p_request_id in number default hr_api.g_number

Line 769: ,p_program_id in number default hr_api.g_number

765: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
766: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
767: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
768: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
769: ,p_program_id in number default hr_api.g_number
770: ,p_program_login_id in number default hr_api.g_number
771: ,p_program_application_id in number default hr_api.g_number
772: ,p_request_id in number default hr_api.g_number
773: ,p_effective_start_date out nocopy date

Line 770: ,p_program_login_id in number default hr_api.g_number

766: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
767: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
768: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
769: ,p_program_id in number default hr_api.g_number
770: ,p_program_login_id in number default hr_api.g_number
771: ,p_program_application_id in number default hr_api.g_number
772: ,p_request_id in number default hr_api.g_number
773: ,p_effective_start_date out nocopy date
774: ,p_effective_end_date out nocopy date

Line 771: ,p_program_application_id in number default hr_api.g_number

767: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
768: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
769: ,p_program_id in number default hr_api.g_number
770: ,p_program_login_id in number default hr_api.g_number
771: ,p_program_application_id in number default hr_api.g_number
772: ,p_request_id in number default hr_api.g_number
773: ,p_effective_start_date out nocopy date
774: ,p_effective_end_date out nocopy date
775: ) is

Line 772: ,p_request_id in number default hr_api.g_number

768: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
769: ,p_program_id in number default hr_api.g_number
770: ,p_program_login_id in number default hr_api.g_number
771: ,p_program_application_id in number default hr_api.g_number
772: ,p_request_id in number default hr_api.g_number
773: ,p_effective_start_date out nocopy date
774: ,p_effective_end_date out nocopy date
775: ) is
776: --

Line 791: ,hr_api.g_number

787: pay_psd_shd.convert_args
788: (p_sii_details_id
789: ,null
790: ,null
791: ,hr_api.g_number
792: ,hr_api.g_number
793: ,hr_api.g_varchar2
794: ,p_object_version_number
795: ,p_emp_social_security_info

Line 792: ,hr_api.g_number

788: (p_sii_details_id
789: ,null
790: ,null
791: ,hr_api.g_number
792: ,hr_api.g_number
793: ,hr_api.g_varchar2
794: ,p_object_version_number
795: ,p_emp_social_security_info
796: ,p_old_age_contribution

Line 793: ,hr_api.g_varchar2

789: ,null
790: ,null
791: ,hr_api.g_number
792: ,hr_api.g_number
793: ,hr_api.g_varchar2
794: ,p_object_version_number
795: ,p_emp_social_security_info
796: ,p_old_age_contribution
797: ,p_pension_contribution