23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE create_pl_sii_details
27: (p_validate in number default hr_api.g_false_num
28: ,p_effective_date in date
29: ,p_contract_category in varchar2
30: ,p_per_or_asg_id in number
31: ,p_business_group_id in number
74: --
75: -- {End of comments}
76: -- ----------------------------------------------------------------------------
77: PROCEDURE update_pl_sii_details
78: (p_validate in number default hr_api.g_false_num
79: ,p_effective_date in date
80: ,p_datetrack_update_mode in varchar2
81: ,p_sii_details_id in number
82: ,p_object_version_number in out nocopy number
79: ,p_effective_date in date
80: ,p_datetrack_update_mode in varchar2
81: ,p_sii_details_id in number
82: ,p_object_version_number in out nocopy number
83: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
84: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
85: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
86: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
87: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
80: ,p_datetrack_update_mode in varchar2
81: ,p_sii_details_id in number
82: ,p_object_version_number in out nocopy number
83: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
84: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
85: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
86: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
87: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
88: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
81: ,p_sii_details_id in number
82: ,p_object_version_number in out nocopy number
83: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
84: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
85: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
86: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
87: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
88: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
89: ,p_health_contribution in varchar2 default hr_api.g_varchar2
82: ,p_object_version_number in out nocopy number
83: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
84: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
85: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
86: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
87: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
88: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
89: ,p_health_contribution in varchar2 default hr_api.g_varchar2
90: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
83: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
84: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
85: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
86: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
87: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
88: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
89: ,p_health_contribution in varchar2 default hr_api.g_varchar2
90: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
91: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
84: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
85: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
86: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
87: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
88: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
89: ,p_health_contribution in varchar2 default hr_api.g_varchar2
90: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
91: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
92: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
85: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
86: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
87: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
88: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
89: ,p_health_contribution in varchar2 default hr_api.g_varchar2
90: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
91: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
92: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
93: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
86: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
87: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
88: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
89: ,p_health_contribution in varchar2 default hr_api.g_varchar2
90: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
91: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
92: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
93: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
94: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
87: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
88: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
89: ,p_health_contribution in varchar2 default hr_api.g_varchar2
90: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
91: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
92: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
93: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
94: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
95: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
88: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
89: ,p_health_contribution in varchar2 default hr_api.g_varchar2
90: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
91: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
92: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
93: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
94: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
95: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
96: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
89: ,p_health_contribution in varchar2 default hr_api.g_varchar2
90: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
91: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
92: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
93: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
94: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
95: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
96: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
97: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
90: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
91: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
92: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
93: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
94: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
95: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
96: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
97: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
98: ,p_effective_start_date out nocopy date
91: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
92: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
93: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
94: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
95: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
96: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
97: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
98: ,p_effective_start_date out nocopy date
99: ,p_effective_end_date out nocopy date
92: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
93: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
94: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
95: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
96: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
97: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
98: ,p_effective_start_date out nocopy date
99: ,p_effective_end_date out nocopy date
100: ,p_return_status out nocopy varchar2
93: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
94: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
95: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
96: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
97: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
98: ,p_effective_start_date out nocopy date
99: ,p_effective_end_date out nocopy date
100: ,p_return_status out nocopy varchar2
101: );
122: --
123: -- {End of comments}
124: -- ----------------------------------------------------------------------------
125: PROCEDURE delete_pl_sii_details
126: (p_validate in number default hr_api.g_false_num
127: ,p_effective_date in date
128: ,p_datetrack_delete_mode in varchar2
129: ,p_sii_details_id in number
130: ,p_object_version_number in out nocopy number