APPS.PQH_FR_EMP_STAT_SITUATION_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_emp_stat_situation >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_emp_stat_situation
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_statutory_situation_id in number
15: ,p_person_id in number
16: ,p_provisional_start_date in date

Line 88: hr_api.constant_to_boolean

84: --
85: -- Convert constant values to their corresponding boolean value
86: --
87: l_validate :=
88: hr_api.constant_to_boolean
89: (p_constant_value => p_validate);
90: --
91: -- Register Surrogate ID or user key values
92: --

Line 203: (p_validate in number default hr_api.g_false_num

199: -- ----------------------------------------------------------------------------
200: -- |-----------------------< update_emp_stat_situation >----------------------|
201: -- ----------------------------------------------------------------------------
202: PROCEDURE update_emp_stat_situation
203: (p_validate in number default hr_api.g_false_num
204: ,p_effective_date in date
205: ,p_emp_stat_situation_id in number
206: ,p_statutory_situation_id in number default hr_api.g_number
207: ,p_person_id in number default hr_api.g_number

Line 206: ,p_statutory_situation_id in number default hr_api.g_number

202: PROCEDURE update_emp_stat_situation
203: (p_validate in number default hr_api.g_false_num
204: ,p_effective_date in date
205: ,p_emp_stat_situation_id in number
206: ,p_statutory_situation_id in number default hr_api.g_number
207: ,p_person_id in number default hr_api.g_number
208: ,p_provisional_start_date in date default hr_api.g_date
209: ,p_provisional_end_date in date default hr_api.g_date
210: ,p_actual_start_date in date default hr_api.g_date

Line 207: ,p_person_id in number default hr_api.g_number

203: (p_validate in number default hr_api.g_false_num
204: ,p_effective_date in date
205: ,p_emp_stat_situation_id in number
206: ,p_statutory_situation_id in number default hr_api.g_number
207: ,p_person_id in number default hr_api.g_number
208: ,p_provisional_start_date in date default hr_api.g_date
209: ,p_provisional_end_date in date default hr_api.g_date
210: ,p_actual_start_date in date default hr_api.g_date
211: ,p_actual_end_date in date default hr_api.g_date

Line 208: ,p_provisional_start_date in date default hr_api.g_date

204: ,p_effective_date in date
205: ,p_emp_stat_situation_id in number
206: ,p_statutory_situation_id in number default hr_api.g_number
207: ,p_person_id in number default hr_api.g_number
208: ,p_provisional_start_date in date default hr_api.g_date
209: ,p_provisional_end_date in date default hr_api.g_date
210: ,p_actual_start_date in date default hr_api.g_date
211: ,p_actual_end_date in date default hr_api.g_date
212: ,p_approval_flag in varchar2 default hr_api.g_varchar2

Line 209: ,p_provisional_end_date in date default hr_api.g_date

205: ,p_emp_stat_situation_id in number
206: ,p_statutory_situation_id in number default hr_api.g_number
207: ,p_person_id in number default hr_api.g_number
208: ,p_provisional_start_date in date default hr_api.g_date
209: ,p_provisional_end_date in date default hr_api.g_date
210: ,p_actual_start_date in date default hr_api.g_date
211: ,p_actual_end_date in date default hr_api.g_date
212: ,p_approval_flag in varchar2 default hr_api.g_varchar2
213: ,p_comments in varchar2 default hr_api.g_varchar2

Line 210: ,p_actual_start_date in date default hr_api.g_date

206: ,p_statutory_situation_id in number default hr_api.g_number
207: ,p_person_id in number default hr_api.g_number
208: ,p_provisional_start_date in date default hr_api.g_date
209: ,p_provisional_end_date in date default hr_api.g_date
210: ,p_actual_start_date in date default hr_api.g_date
211: ,p_actual_end_date in date default hr_api.g_date
212: ,p_approval_flag in varchar2 default hr_api.g_varchar2
213: ,p_comments in varchar2 default hr_api.g_varchar2
214: ,p_contact_person_id in number default hr_api.g_number

Line 211: ,p_actual_end_date in date default hr_api.g_date

207: ,p_person_id in number default hr_api.g_number
208: ,p_provisional_start_date in date default hr_api.g_date
209: ,p_provisional_end_date in date default hr_api.g_date
210: ,p_actual_start_date in date default hr_api.g_date
211: ,p_actual_end_date in date default hr_api.g_date
212: ,p_approval_flag in varchar2 default hr_api.g_varchar2
213: ,p_comments in varchar2 default hr_api.g_varchar2
214: ,p_contact_person_id in number default hr_api.g_number
215: ,p_contact_relationship in varchar2 default hr_api.g_varchar2

Line 212: ,p_approval_flag in varchar2 default hr_api.g_varchar2

208: ,p_provisional_start_date in date default hr_api.g_date
209: ,p_provisional_end_date in date default hr_api.g_date
210: ,p_actual_start_date in date default hr_api.g_date
211: ,p_actual_end_date in date default hr_api.g_date
212: ,p_approval_flag in varchar2 default hr_api.g_varchar2
213: ,p_comments in varchar2 default hr_api.g_varchar2
214: ,p_contact_person_id in number default hr_api.g_number
215: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
216: ,p_external_organization_id in number default hr_api.g_number

Line 213: ,p_comments in varchar2 default hr_api.g_varchar2

209: ,p_provisional_end_date in date default hr_api.g_date
210: ,p_actual_start_date in date default hr_api.g_date
211: ,p_actual_end_date in date default hr_api.g_date
212: ,p_approval_flag in varchar2 default hr_api.g_varchar2
213: ,p_comments in varchar2 default hr_api.g_varchar2
214: ,p_contact_person_id in number default hr_api.g_number
215: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
216: ,p_external_organization_id in number default hr_api.g_number
217: ,p_renewal_flag in varchar2 default hr_api.g_varchar2

Line 214: ,p_contact_person_id in number default hr_api.g_number

210: ,p_actual_start_date in date default hr_api.g_date
211: ,p_actual_end_date in date default hr_api.g_date
212: ,p_approval_flag in varchar2 default hr_api.g_varchar2
213: ,p_comments in varchar2 default hr_api.g_varchar2
214: ,p_contact_person_id in number default hr_api.g_number
215: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
216: ,p_external_organization_id in number default hr_api.g_number
217: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
218: ,p_renew_stat_situation_id in number default hr_api.g_number

Line 215: ,p_contact_relationship in varchar2 default hr_api.g_varchar2

211: ,p_actual_end_date in date default hr_api.g_date
212: ,p_approval_flag in varchar2 default hr_api.g_varchar2
213: ,p_comments in varchar2 default hr_api.g_varchar2
214: ,p_contact_person_id in number default hr_api.g_number
215: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
216: ,p_external_organization_id in number default hr_api.g_number
217: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
218: ,p_renew_stat_situation_id in number default hr_api.g_number
219: ,p_seconded_career_id in number default hr_api.g_number

Line 216: ,p_external_organization_id in number default hr_api.g_number

212: ,p_approval_flag in varchar2 default hr_api.g_varchar2
213: ,p_comments in varchar2 default hr_api.g_varchar2
214: ,p_contact_person_id in number default hr_api.g_number
215: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
216: ,p_external_organization_id in number default hr_api.g_number
217: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
218: ,p_renew_stat_situation_id in number default hr_api.g_number
219: ,p_seconded_career_id in number default hr_api.g_number
220: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 217: ,p_renewal_flag in varchar2 default hr_api.g_varchar2

213: ,p_comments in varchar2 default hr_api.g_varchar2
214: ,p_contact_person_id in number default hr_api.g_number
215: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
216: ,p_external_organization_id in number default hr_api.g_number
217: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
218: ,p_renew_stat_situation_id in number default hr_api.g_number
219: ,p_seconded_career_id in number default hr_api.g_number
220: ,p_attribute_category in varchar2 default hr_api.g_varchar2
221: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 218: ,p_renew_stat_situation_id in number default hr_api.g_number

214: ,p_contact_person_id in number default hr_api.g_number
215: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
216: ,p_external_organization_id in number default hr_api.g_number
217: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
218: ,p_renew_stat_situation_id in number default hr_api.g_number
219: ,p_seconded_career_id in number default hr_api.g_number
220: ,p_attribute_category in varchar2 default hr_api.g_varchar2
221: ,p_attribute1 in varchar2 default hr_api.g_varchar2
222: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 219: ,p_seconded_career_id in number default hr_api.g_number

215: ,p_contact_relationship in varchar2 default hr_api.g_varchar2
216: ,p_external_organization_id in number default hr_api.g_number
217: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
218: ,p_renew_stat_situation_id in number default hr_api.g_number
219: ,p_seconded_career_id in number default hr_api.g_number
220: ,p_attribute_category in varchar2 default hr_api.g_varchar2
221: ,p_attribute1 in varchar2 default hr_api.g_varchar2
222: ,p_attribute2 in varchar2 default hr_api.g_varchar2
223: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 220: ,p_attribute_category in varchar2 default hr_api.g_varchar2

216: ,p_external_organization_id in number default hr_api.g_number
217: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
218: ,p_renew_stat_situation_id in number default hr_api.g_number
219: ,p_seconded_career_id in number default hr_api.g_number
220: ,p_attribute_category in varchar2 default hr_api.g_varchar2
221: ,p_attribute1 in varchar2 default hr_api.g_varchar2
222: ,p_attribute2 in varchar2 default hr_api.g_varchar2
223: ,p_attribute3 in varchar2 default hr_api.g_varchar2
224: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 221: ,p_attribute1 in varchar2 default hr_api.g_varchar2

217: ,p_renewal_flag in varchar2 default hr_api.g_varchar2
218: ,p_renew_stat_situation_id in number default hr_api.g_number
219: ,p_seconded_career_id in number default hr_api.g_number
220: ,p_attribute_category in varchar2 default hr_api.g_varchar2
221: ,p_attribute1 in varchar2 default hr_api.g_varchar2
222: ,p_attribute2 in varchar2 default hr_api.g_varchar2
223: ,p_attribute3 in varchar2 default hr_api.g_varchar2
224: ,p_attribute4 in varchar2 default hr_api.g_varchar2
225: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 222: ,p_attribute2 in varchar2 default hr_api.g_varchar2

218: ,p_renew_stat_situation_id in number default hr_api.g_number
219: ,p_seconded_career_id in number default hr_api.g_number
220: ,p_attribute_category in varchar2 default hr_api.g_varchar2
221: ,p_attribute1 in varchar2 default hr_api.g_varchar2
222: ,p_attribute2 in varchar2 default hr_api.g_varchar2
223: ,p_attribute3 in varchar2 default hr_api.g_varchar2
224: ,p_attribute4 in varchar2 default hr_api.g_varchar2
225: ,p_attribute5 in varchar2 default hr_api.g_varchar2
226: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 223: ,p_attribute3 in varchar2 default hr_api.g_varchar2

219: ,p_seconded_career_id in number default hr_api.g_number
220: ,p_attribute_category in varchar2 default hr_api.g_varchar2
221: ,p_attribute1 in varchar2 default hr_api.g_varchar2
222: ,p_attribute2 in varchar2 default hr_api.g_varchar2
223: ,p_attribute3 in varchar2 default hr_api.g_varchar2
224: ,p_attribute4 in varchar2 default hr_api.g_varchar2
225: ,p_attribute5 in varchar2 default hr_api.g_varchar2
226: ,p_attribute6 in varchar2 default hr_api.g_varchar2
227: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 224: ,p_attribute4 in varchar2 default hr_api.g_varchar2

220: ,p_attribute_category in varchar2 default hr_api.g_varchar2
221: ,p_attribute1 in varchar2 default hr_api.g_varchar2
222: ,p_attribute2 in varchar2 default hr_api.g_varchar2
223: ,p_attribute3 in varchar2 default hr_api.g_varchar2
224: ,p_attribute4 in varchar2 default hr_api.g_varchar2
225: ,p_attribute5 in varchar2 default hr_api.g_varchar2
226: ,p_attribute6 in varchar2 default hr_api.g_varchar2
227: ,p_attribute7 in varchar2 default hr_api.g_varchar2
228: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 225: ,p_attribute5 in varchar2 default hr_api.g_varchar2

221: ,p_attribute1 in varchar2 default hr_api.g_varchar2
222: ,p_attribute2 in varchar2 default hr_api.g_varchar2
223: ,p_attribute3 in varchar2 default hr_api.g_varchar2
224: ,p_attribute4 in varchar2 default hr_api.g_varchar2
225: ,p_attribute5 in varchar2 default hr_api.g_varchar2
226: ,p_attribute6 in varchar2 default hr_api.g_varchar2
227: ,p_attribute7 in varchar2 default hr_api.g_varchar2
228: ,p_attribute8 in varchar2 default hr_api.g_varchar2
229: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 226: ,p_attribute6 in varchar2 default hr_api.g_varchar2

222: ,p_attribute2 in varchar2 default hr_api.g_varchar2
223: ,p_attribute3 in varchar2 default hr_api.g_varchar2
224: ,p_attribute4 in varchar2 default hr_api.g_varchar2
225: ,p_attribute5 in varchar2 default hr_api.g_varchar2
226: ,p_attribute6 in varchar2 default hr_api.g_varchar2
227: ,p_attribute7 in varchar2 default hr_api.g_varchar2
228: ,p_attribute8 in varchar2 default hr_api.g_varchar2
229: ,p_attribute9 in varchar2 default hr_api.g_varchar2
230: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 227: ,p_attribute7 in varchar2 default hr_api.g_varchar2

223: ,p_attribute3 in varchar2 default hr_api.g_varchar2
224: ,p_attribute4 in varchar2 default hr_api.g_varchar2
225: ,p_attribute5 in varchar2 default hr_api.g_varchar2
226: ,p_attribute6 in varchar2 default hr_api.g_varchar2
227: ,p_attribute7 in varchar2 default hr_api.g_varchar2
228: ,p_attribute8 in varchar2 default hr_api.g_varchar2
229: ,p_attribute9 in varchar2 default hr_api.g_varchar2
230: ,p_attribute10 in varchar2 default hr_api.g_varchar2
231: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 228: ,p_attribute8 in varchar2 default hr_api.g_varchar2

224: ,p_attribute4 in varchar2 default hr_api.g_varchar2
225: ,p_attribute5 in varchar2 default hr_api.g_varchar2
226: ,p_attribute6 in varchar2 default hr_api.g_varchar2
227: ,p_attribute7 in varchar2 default hr_api.g_varchar2
228: ,p_attribute8 in varchar2 default hr_api.g_varchar2
229: ,p_attribute9 in varchar2 default hr_api.g_varchar2
230: ,p_attribute10 in varchar2 default hr_api.g_varchar2
231: ,p_attribute11 in varchar2 default hr_api.g_varchar2
232: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 229: ,p_attribute9 in varchar2 default hr_api.g_varchar2

225: ,p_attribute5 in varchar2 default hr_api.g_varchar2
226: ,p_attribute6 in varchar2 default hr_api.g_varchar2
227: ,p_attribute7 in varchar2 default hr_api.g_varchar2
228: ,p_attribute8 in varchar2 default hr_api.g_varchar2
229: ,p_attribute9 in varchar2 default hr_api.g_varchar2
230: ,p_attribute10 in varchar2 default hr_api.g_varchar2
231: ,p_attribute11 in varchar2 default hr_api.g_varchar2
232: ,p_attribute12 in varchar2 default hr_api.g_varchar2
233: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 230: ,p_attribute10 in varchar2 default hr_api.g_varchar2

226: ,p_attribute6 in varchar2 default hr_api.g_varchar2
227: ,p_attribute7 in varchar2 default hr_api.g_varchar2
228: ,p_attribute8 in varchar2 default hr_api.g_varchar2
229: ,p_attribute9 in varchar2 default hr_api.g_varchar2
230: ,p_attribute10 in varchar2 default hr_api.g_varchar2
231: ,p_attribute11 in varchar2 default hr_api.g_varchar2
232: ,p_attribute12 in varchar2 default hr_api.g_varchar2
233: ,p_attribute13 in varchar2 default hr_api.g_varchar2
234: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 231: ,p_attribute11 in varchar2 default hr_api.g_varchar2

227: ,p_attribute7 in varchar2 default hr_api.g_varchar2
228: ,p_attribute8 in varchar2 default hr_api.g_varchar2
229: ,p_attribute9 in varchar2 default hr_api.g_varchar2
230: ,p_attribute10 in varchar2 default hr_api.g_varchar2
231: ,p_attribute11 in varchar2 default hr_api.g_varchar2
232: ,p_attribute12 in varchar2 default hr_api.g_varchar2
233: ,p_attribute13 in varchar2 default hr_api.g_varchar2
234: ,p_attribute14 in varchar2 default hr_api.g_varchar2
235: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 232: ,p_attribute12 in varchar2 default hr_api.g_varchar2

228: ,p_attribute8 in varchar2 default hr_api.g_varchar2
229: ,p_attribute9 in varchar2 default hr_api.g_varchar2
230: ,p_attribute10 in varchar2 default hr_api.g_varchar2
231: ,p_attribute11 in varchar2 default hr_api.g_varchar2
232: ,p_attribute12 in varchar2 default hr_api.g_varchar2
233: ,p_attribute13 in varchar2 default hr_api.g_varchar2
234: ,p_attribute14 in varchar2 default hr_api.g_varchar2
235: ,p_attribute15 in varchar2 default hr_api.g_varchar2
236: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 233: ,p_attribute13 in varchar2 default hr_api.g_varchar2

229: ,p_attribute9 in varchar2 default hr_api.g_varchar2
230: ,p_attribute10 in varchar2 default hr_api.g_varchar2
231: ,p_attribute11 in varchar2 default hr_api.g_varchar2
232: ,p_attribute12 in varchar2 default hr_api.g_varchar2
233: ,p_attribute13 in varchar2 default hr_api.g_varchar2
234: ,p_attribute14 in varchar2 default hr_api.g_varchar2
235: ,p_attribute15 in varchar2 default hr_api.g_varchar2
236: ,p_attribute16 in varchar2 default hr_api.g_varchar2
237: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 234: ,p_attribute14 in varchar2 default hr_api.g_varchar2

230: ,p_attribute10 in varchar2 default hr_api.g_varchar2
231: ,p_attribute11 in varchar2 default hr_api.g_varchar2
232: ,p_attribute12 in varchar2 default hr_api.g_varchar2
233: ,p_attribute13 in varchar2 default hr_api.g_varchar2
234: ,p_attribute14 in varchar2 default hr_api.g_varchar2
235: ,p_attribute15 in varchar2 default hr_api.g_varchar2
236: ,p_attribute16 in varchar2 default hr_api.g_varchar2
237: ,p_attribute17 in varchar2 default hr_api.g_varchar2
238: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 235: ,p_attribute15 in varchar2 default hr_api.g_varchar2

231: ,p_attribute11 in varchar2 default hr_api.g_varchar2
232: ,p_attribute12 in varchar2 default hr_api.g_varchar2
233: ,p_attribute13 in varchar2 default hr_api.g_varchar2
234: ,p_attribute14 in varchar2 default hr_api.g_varchar2
235: ,p_attribute15 in varchar2 default hr_api.g_varchar2
236: ,p_attribute16 in varchar2 default hr_api.g_varchar2
237: ,p_attribute17 in varchar2 default hr_api.g_varchar2
238: ,p_attribute18 in varchar2 default hr_api.g_varchar2
239: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 236: ,p_attribute16 in varchar2 default hr_api.g_varchar2

232: ,p_attribute12 in varchar2 default hr_api.g_varchar2
233: ,p_attribute13 in varchar2 default hr_api.g_varchar2
234: ,p_attribute14 in varchar2 default hr_api.g_varchar2
235: ,p_attribute15 in varchar2 default hr_api.g_varchar2
236: ,p_attribute16 in varchar2 default hr_api.g_varchar2
237: ,p_attribute17 in varchar2 default hr_api.g_varchar2
238: ,p_attribute18 in varchar2 default hr_api.g_varchar2
239: ,p_attribute19 in varchar2 default hr_api.g_varchar2
240: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 237: ,p_attribute17 in varchar2 default hr_api.g_varchar2

233: ,p_attribute13 in varchar2 default hr_api.g_varchar2
234: ,p_attribute14 in varchar2 default hr_api.g_varchar2
235: ,p_attribute15 in varchar2 default hr_api.g_varchar2
236: ,p_attribute16 in varchar2 default hr_api.g_varchar2
237: ,p_attribute17 in varchar2 default hr_api.g_varchar2
238: ,p_attribute18 in varchar2 default hr_api.g_varchar2
239: ,p_attribute19 in varchar2 default hr_api.g_varchar2
240: ,p_attribute20 in varchar2 default hr_api.g_varchar2
241: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 238: ,p_attribute18 in varchar2 default hr_api.g_varchar2

234: ,p_attribute14 in varchar2 default hr_api.g_varchar2
235: ,p_attribute15 in varchar2 default hr_api.g_varchar2
236: ,p_attribute16 in varchar2 default hr_api.g_varchar2
237: ,p_attribute17 in varchar2 default hr_api.g_varchar2
238: ,p_attribute18 in varchar2 default hr_api.g_varchar2
239: ,p_attribute19 in varchar2 default hr_api.g_varchar2
240: ,p_attribute20 in varchar2 default hr_api.g_varchar2
241: ,p_attribute21 in varchar2 default hr_api.g_varchar2
242: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 239: ,p_attribute19 in varchar2 default hr_api.g_varchar2

235: ,p_attribute15 in varchar2 default hr_api.g_varchar2
236: ,p_attribute16 in varchar2 default hr_api.g_varchar2
237: ,p_attribute17 in varchar2 default hr_api.g_varchar2
238: ,p_attribute18 in varchar2 default hr_api.g_varchar2
239: ,p_attribute19 in varchar2 default hr_api.g_varchar2
240: ,p_attribute20 in varchar2 default hr_api.g_varchar2
241: ,p_attribute21 in varchar2 default hr_api.g_varchar2
242: ,p_attribute22 in varchar2 default hr_api.g_varchar2
243: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 240: ,p_attribute20 in varchar2 default hr_api.g_varchar2

236: ,p_attribute16 in varchar2 default hr_api.g_varchar2
237: ,p_attribute17 in varchar2 default hr_api.g_varchar2
238: ,p_attribute18 in varchar2 default hr_api.g_varchar2
239: ,p_attribute19 in varchar2 default hr_api.g_varchar2
240: ,p_attribute20 in varchar2 default hr_api.g_varchar2
241: ,p_attribute21 in varchar2 default hr_api.g_varchar2
242: ,p_attribute22 in varchar2 default hr_api.g_varchar2
243: ,p_attribute23 in varchar2 default hr_api.g_varchar2
244: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 241: ,p_attribute21 in varchar2 default hr_api.g_varchar2

237: ,p_attribute17 in varchar2 default hr_api.g_varchar2
238: ,p_attribute18 in varchar2 default hr_api.g_varchar2
239: ,p_attribute19 in varchar2 default hr_api.g_varchar2
240: ,p_attribute20 in varchar2 default hr_api.g_varchar2
241: ,p_attribute21 in varchar2 default hr_api.g_varchar2
242: ,p_attribute22 in varchar2 default hr_api.g_varchar2
243: ,p_attribute23 in varchar2 default hr_api.g_varchar2
244: ,p_attribute24 in varchar2 default hr_api.g_varchar2
245: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 242: ,p_attribute22 in varchar2 default hr_api.g_varchar2

238: ,p_attribute18 in varchar2 default hr_api.g_varchar2
239: ,p_attribute19 in varchar2 default hr_api.g_varchar2
240: ,p_attribute20 in varchar2 default hr_api.g_varchar2
241: ,p_attribute21 in varchar2 default hr_api.g_varchar2
242: ,p_attribute22 in varchar2 default hr_api.g_varchar2
243: ,p_attribute23 in varchar2 default hr_api.g_varchar2
244: ,p_attribute24 in varchar2 default hr_api.g_varchar2
245: ,p_attribute25 in varchar2 default hr_api.g_varchar2
246: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 243: ,p_attribute23 in varchar2 default hr_api.g_varchar2

239: ,p_attribute19 in varchar2 default hr_api.g_varchar2
240: ,p_attribute20 in varchar2 default hr_api.g_varchar2
241: ,p_attribute21 in varchar2 default hr_api.g_varchar2
242: ,p_attribute22 in varchar2 default hr_api.g_varchar2
243: ,p_attribute23 in varchar2 default hr_api.g_varchar2
244: ,p_attribute24 in varchar2 default hr_api.g_varchar2
245: ,p_attribute25 in varchar2 default hr_api.g_varchar2
246: ,p_attribute26 in varchar2 default hr_api.g_varchar2
247: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 244: ,p_attribute24 in varchar2 default hr_api.g_varchar2

240: ,p_attribute20 in varchar2 default hr_api.g_varchar2
241: ,p_attribute21 in varchar2 default hr_api.g_varchar2
242: ,p_attribute22 in varchar2 default hr_api.g_varchar2
243: ,p_attribute23 in varchar2 default hr_api.g_varchar2
244: ,p_attribute24 in varchar2 default hr_api.g_varchar2
245: ,p_attribute25 in varchar2 default hr_api.g_varchar2
246: ,p_attribute26 in varchar2 default hr_api.g_varchar2
247: ,p_attribute27 in varchar2 default hr_api.g_varchar2
248: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 245: ,p_attribute25 in varchar2 default hr_api.g_varchar2

241: ,p_attribute21 in varchar2 default hr_api.g_varchar2
242: ,p_attribute22 in varchar2 default hr_api.g_varchar2
243: ,p_attribute23 in varchar2 default hr_api.g_varchar2
244: ,p_attribute24 in varchar2 default hr_api.g_varchar2
245: ,p_attribute25 in varchar2 default hr_api.g_varchar2
246: ,p_attribute26 in varchar2 default hr_api.g_varchar2
247: ,p_attribute27 in varchar2 default hr_api.g_varchar2
248: ,p_attribute28 in varchar2 default hr_api.g_varchar2
249: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 246: ,p_attribute26 in varchar2 default hr_api.g_varchar2

242: ,p_attribute22 in varchar2 default hr_api.g_varchar2
243: ,p_attribute23 in varchar2 default hr_api.g_varchar2
244: ,p_attribute24 in varchar2 default hr_api.g_varchar2
245: ,p_attribute25 in varchar2 default hr_api.g_varchar2
246: ,p_attribute26 in varchar2 default hr_api.g_varchar2
247: ,p_attribute27 in varchar2 default hr_api.g_varchar2
248: ,p_attribute28 in varchar2 default hr_api.g_varchar2
249: ,p_attribute29 in varchar2 default hr_api.g_varchar2
250: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 247: ,p_attribute27 in varchar2 default hr_api.g_varchar2

243: ,p_attribute23 in varchar2 default hr_api.g_varchar2
244: ,p_attribute24 in varchar2 default hr_api.g_varchar2
245: ,p_attribute25 in varchar2 default hr_api.g_varchar2
246: ,p_attribute26 in varchar2 default hr_api.g_varchar2
247: ,p_attribute27 in varchar2 default hr_api.g_varchar2
248: ,p_attribute28 in varchar2 default hr_api.g_varchar2
249: ,p_attribute29 in varchar2 default hr_api.g_varchar2
250: ,p_attribute30 in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number

Line 248: ,p_attribute28 in varchar2 default hr_api.g_varchar2

244: ,p_attribute24 in varchar2 default hr_api.g_varchar2
245: ,p_attribute25 in varchar2 default hr_api.g_varchar2
246: ,p_attribute26 in varchar2 default hr_api.g_varchar2
247: ,p_attribute27 in varchar2 default hr_api.g_varchar2
248: ,p_attribute28 in varchar2 default hr_api.g_varchar2
249: ,p_attribute29 in varchar2 default hr_api.g_varchar2
250: ,p_attribute30 in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_return_status out nocopy varchar2

Line 249: ,p_attribute29 in varchar2 default hr_api.g_varchar2

245: ,p_attribute25 in varchar2 default hr_api.g_varchar2
246: ,p_attribute26 in varchar2 default hr_api.g_varchar2
247: ,p_attribute27 in varchar2 default hr_api.g_varchar2
248: ,p_attribute28 in varchar2 default hr_api.g_varchar2
249: ,p_attribute29 in varchar2 default hr_api.g_varchar2
250: ,p_attribute30 in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_return_status out nocopy varchar2
253: ) is

Line 250: ,p_attribute30 in varchar2 default hr_api.g_varchar2

246: ,p_attribute26 in varchar2 default hr_api.g_varchar2
247: ,p_attribute27 in varchar2 default hr_api.g_varchar2
248: ,p_attribute28 in varchar2 default hr_api.g_varchar2
249: ,p_attribute29 in varchar2 default hr_api.g_varchar2
250: ,p_attribute30 in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_return_status out nocopy varchar2
253: ) is
254: --

Line 281: hr_api.constant_to_boolean

277: --
278: -- Convert constant values to their corresponding boolean value
279: --
280: l_validate :=
281: hr_api.constant_to_boolean
282: (p_constant_value => p_validate);
283: --
284: -- Register Surrogate ID or user key values
285: --

Line 393: (p_validate in number default hr_api.g_false_num

389: -- ----------------------------------------------------------------------------
390: -- |-----------------------< delete_emp_stat_situation >----------------------|
391: -- ----------------------------------------------------------------------------
392: PROCEDURE delete_emp_stat_situation
393: (p_validate in number default hr_api.g_false_num
394: ,p_emp_stat_situation_id in number
395: ,p_object_version_number in number
396: ,p_return_status out nocopy varchar2
397: ) is

Line 423: hr_api.constant_to_boolean

419: --
420: -- Convert constant values to their corresponding boolean value
421: --
422: l_validate :=
423: hr_api.constant_to_boolean
424: (p_constant_value => p_validate);
425: --
426: -- Register Surrogate ID or user key values
427: --

Line 487: (p_validate in number default hr_api.g_false_num

483: -- ----------------------------------------------------------------------------
484: -- |-----------------------< renew_emp_stat_situation >-----------------------|
485: -- ----------------------------------------------------------------------------
486: PROCEDURE renew_emp_stat_situation
487: (p_validate in number default hr_api.g_false_num
488: ,p_emp_stat_situation_id in out nocopy number
489: ,p_renew_stat_situation_id in number
490: ,p_renewal_duration in number
491: ,p_duration_units in varchar2

Line 526: hr_api.constant_to_boolean

522: --
523: -- Convert constant values to their corresponding boolean value
524: --
525: l_validate :=
526: hr_api.constant_to_boolean
527: (p_constant_value => p_validate);
528: --
529: -- Register Surrogate ID or user key values
530: --

Line 599: (p_validate in number default hr_api.g_false_num

595: -- ----------------------------------------------------------------------------
596: -- |---------------------< reinstate_emp_stat_situation >---------------------|
597: -- ----------------------------------------------------------------------------
598: PROCEDURE reinstate_emp_stat_situation
599: (p_validate in number default hr_api.g_false_num
600: ,p_person_id in number
601: ,p_emp_stat_situation_id in number
602: ,p_reinstate_date in date
603: ,p_comments in varchar2

Line 632: hr_api.constant_to_boolean

628: --
629: -- Convert constant values to their corresponding boolean value
630: --
631: l_validate :=
632: hr_api.constant_to_boolean
633: (p_constant_value => p_validate);
634: --
635: -- Register Surrogate ID or user key values
636: --