DBA Data[Home] [Help]

APPS.PAY_PL_SII_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_pl_sii_details >------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_pl_sii_details
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_contract_category in varchar2
15: ,p_per_or_asg_id in number
16: ,p_business_group_id in number

Line 62: hr_api.constant_to_boolean

58: --
59: -- Convert constant values to their corresponding boolean value
60: --
61: l_validate :=
62: hr_api.constant_to_boolean
63: (p_constant_value => p_validate);
64: --
65: -- Register Surrogate ID or user key values
66: --

Line 159: (p_validate in number default hr_api.g_false_num

155: -- ----------------------------------------------------------------------------
156: -- |-------------------------< update_pl_sii_details >------------------------|
157: -- ----------------------------------------------------------------------------
158: PROCEDURE update_pl_sii_details
159: (p_validate in number default hr_api.g_false_num
160: ,p_effective_date in date
161: ,p_datetrack_update_mode in varchar2
162: ,p_sii_details_id in number
163: ,p_object_version_number in out nocopy number

Line 164: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2

160: ,p_effective_date in date
161: ,p_datetrack_update_mode in varchar2
162: ,p_sii_details_id in number
163: ,p_object_version_number in out nocopy number
164: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
165: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
166: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
167: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
168: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2

Line 165: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2

161: ,p_datetrack_update_mode in varchar2
162: ,p_sii_details_id in number
163: ,p_object_version_number in out nocopy number
164: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
165: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
166: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
167: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
168: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
169: ,p_labor_contribution in varchar2 default hr_api.g_varchar2

Line 166: ,p_pension_contribution in varchar2 default hr_api.g_varchar2

162: ,p_sii_details_id in number
163: ,p_object_version_number in out nocopy number
164: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
165: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
166: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
167: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
168: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
169: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
170: ,p_health_contribution in varchar2 default hr_api.g_varchar2

Line 167: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2

163: ,p_object_version_number in out nocopy number
164: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
165: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
166: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
167: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
168: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
169: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
170: ,p_health_contribution in varchar2 default hr_api.g_varchar2
171: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2

Line 168: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2

164: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
165: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
166: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
167: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
168: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
169: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
170: ,p_health_contribution in varchar2 default hr_api.g_varchar2
171: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
172: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 169: ,p_labor_contribution in varchar2 default hr_api.g_varchar2

165: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
166: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
167: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
168: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
169: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
170: ,p_health_contribution in varchar2 default hr_api.g_varchar2
171: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
172: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
173: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 170: ,p_health_contribution in varchar2 default hr_api.g_varchar2

166: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
167: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
168: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
169: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
170: ,p_health_contribution in varchar2 default hr_api.g_varchar2
171: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
172: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
173: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
174: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 171: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2

167: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
168: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
169: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
170: ,p_health_contribution in varchar2 default hr_api.g_varchar2
171: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
172: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
173: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
174: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
175: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 172: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2

168: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
169: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
170: ,p_health_contribution in varchar2 default hr_api.g_varchar2
171: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
172: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
173: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
174: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
175: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
176: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 173: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2

169: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
170: ,p_health_contribution in varchar2 default hr_api.g_varchar2
171: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
172: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
173: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
174: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
175: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
176: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
177: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 174: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2

170: ,p_health_contribution in varchar2 default hr_api.g_varchar2
171: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
172: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
173: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
174: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
175: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
176: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
177: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
178: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2

Line 175: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2

171: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
172: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
173: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
174: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
175: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
176: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
177: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
178: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
179: ,p_effective_start_date out nocopy date

Line 176: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2

172: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
173: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
174: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
175: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
176: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
177: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
178: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
179: ,p_effective_start_date out nocopy date
180: ,p_effective_end_date out nocopy date

Line 177: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2

173: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
174: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
175: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
176: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
177: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
178: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
179: ,p_effective_start_date out nocopy date
180: ,p_effective_end_date out nocopy date
181: ,p_return_status out nocopy varchar2

Line 178: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2

174: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
175: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
176: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
177: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
178: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
179: ,p_effective_start_date out nocopy date
180: ,p_effective_end_date out nocopy date
181: ,p_return_status out nocopy varchar2
182: ) is

Line 210: hr_api.constant_to_boolean

206: --
207: -- Convert constant values to their corresponding boolean value
208: --
209: l_validate :=
210: hr_api.constant_to_boolean
211: (p_constant_value => p_validate);
212: --
213: -- Register Surrogate ID or user key values
214: --

Line 299: (p_validate in number default hr_api.g_false_num

295: -- ----------------------------------------------------------------------------
296: -- |-------------------------< delete_pl_sii_details >------------------------|
297: -- ----------------------------------------------------------------------------
298: PROCEDURE delete_pl_sii_details
299: (p_validate in number default hr_api.g_false_num
300: ,p_effective_date in date
301: ,p_datetrack_delete_mode in varchar2
302: ,p_sii_details_id in number
303: ,p_object_version_number in out nocopy number

Line 335: hr_api.constant_to_boolean

331: --
332: -- Convert constant values to their corresponding boolean value
333: --
334: l_validate :=
335: hr_api.constant_to_boolean
336: (p_constant_value => p_validate);
337: --
338: -- Register Surrogate ID or user key values
339: --