23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE delete_pension_end_reasons
27: (p_validate in number default hr_api.g_false_num
28: ,p_ins_end_reason_id in number
29: ,p_object_version_number in number
30: ,p_return_status out nocopy varchar2
31: );
52: --
53: -- {End of comments}
54: -- ----------------------------------------------------------------------------
55: PROCEDURE insert_pension_end_reasons
56: (p_validate in number default hr_api.g_false_num
57: ,p_effective_date in date
58: ,p_business_group_id in number
59: ,p_provider_organization_id in number
60: ,p_end_reason_number in varchar2
87: --
88: -- {End of comments}
89: -- ----------------------------------------------------------------------------
90: PROCEDURE update_pension_end_reasons
91: (p_validate in number default hr_api.g_false_num
92: ,p_effective_date in date
93: ,p_ins_end_reason_id in number
94: ,p_object_version_number in out nocopy number
95: ,p_business_group_id in number default hr_api.g_number
91: (p_validate in number default hr_api.g_false_num
92: ,p_effective_date in date
93: ,p_ins_end_reason_id in number
94: ,p_object_version_number in out nocopy number
95: ,p_business_group_id in number default hr_api.g_number
96: ,p_provider_organization_id in number default hr_api.g_number
97: ,p_end_reason_number in varchar2 default hr_api.g_varchar2
98: ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2
99: ,p_end_reason_description in varchar2 default hr_api.g_varchar2
92: ,p_effective_date in date
93: ,p_ins_end_reason_id in number
94: ,p_object_version_number in out nocopy number
95: ,p_business_group_id in number default hr_api.g_number
96: ,p_provider_organization_id in number default hr_api.g_number
97: ,p_end_reason_number in varchar2 default hr_api.g_varchar2
98: ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2
99: ,p_end_reason_description in varchar2 default hr_api.g_varchar2
100: ,p_return_status out nocopy varchar2
93: ,p_ins_end_reason_id in number
94: ,p_object_version_number in out nocopy number
95: ,p_business_group_id in number default hr_api.g_number
96: ,p_provider_organization_id in number default hr_api.g_number
97: ,p_end_reason_number in varchar2 default hr_api.g_varchar2
98: ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2
99: ,p_end_reason_description in varchar2 default hr_api.g_varchar2
100: ,p_return_status out nocopy varchar2
101: );
94: ,p_object_version_number in out nocopy number
95: ,p_business_group_id in number default hr_api.g_number
96: ,p_provider_organization_id in number default hr_api.g_number
97: ,p_end_reason_number in varchar2 default hr_api.g_varchar2
98: ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2
99: ,p_end_reason_description in varchar2 default hr_api.g_varchar2
100: ,p_return_status out nocopy varchar2
101: );
102: end pqh_de_ins_end_reasons_swi;
95: ,p_business_group_id in number default hr_api.g_number
96: ,p_provider_organization_id in number default hr_api.g_number
97: ,p_end_reason_number in varchar2 default hr_api.g_varchar2
98: ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2
99: ,p_end_reason_description in varchar2 default hr_api.g_varchar2
100: ,p_return_status out nocopy varchar2
101: );
102: end pqh_de_ins_end_reasons_swi;