eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_OFFERS_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |-----------------------------< create_offer >-----------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_offer
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date default null
14: ,p_offer_status in varchar2
15: ,p_discretionary_job_title in varchar2 default null
16: ,p_offer_extended_method in varchar2 default null

Line 89: hr_api.constant_to_boolean

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

Line 210: (p_validate in number default hr_api.g_false_num

206: -- ----------------------------------------------------------------------------
207: -- |-----------------------------< update_offer >-----------------------------|
208: -- ----------------------------------------------------------------------------
209: PROCEDURE update_offer
210: (p_validate in number default hr_api.g_false_num
211: ,p_effective_date in date default hr_api.g_date
212: ,p_offer_status in varchar2 default hr_api.g_varchar2
213: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
214: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2

Line 211: ,p_effective_date in date default hr_api.g_date

207: -- |-----------------------------< update_offer >-----------------------------|
208: -- ----------------------------------------------------------------------------
209: PROCEDURE update_offer
210: (p_validate in number default hr_api.g_false_num
211: ,p_effective_date in date default hr_api.g_date
212: ,p_offer_status in varchar2 default hr_api.g_varchar2
213: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
214: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
215: ,p_respondent_id in number default hr_api.g_number

Line 212: ,p_offer_status in varchar2 default hr_api.g_varchar2

208: -- ----------------------------------------------------------------------------
209: PROCEDURE update_offer
210: (p_validate in number default hr_api.g_false_num
211: ,p_effective_date in date default hr_api.g_date
212: ,p_offer_status in varchar2 default hr_api.g_varchar2
213: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
214: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
215: ,p_respondent_id in number default hr_api.g_number
216: ,p_expiry_date in date default hr_api.g_date

Line 213: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2

209: PROCEDURE update_offer
210: (p_validate in number default hr_api.g_false_num
211: ,p_effective_date in date default hr_api.g_date
212: ,p_offer_status in varchar2 default hr_api.g_varchar2
213: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
214: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
215: ,p_respondent_id in number default hr_api.g_number
216: ,p_expiry_date in date default hr_api.g_date
217: ,p_proposed_start_date in date default hr_api.g_date

Line 214: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2

210: (p_validate in number default hr_api.g_false_num
211: ,p_effective_date in date default hr_api.g_date
212: ,p_offer_status in varchar2 default hr_api.g_varchar2
213: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
214: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
215: ,p_respondent_id in number default hr_api.g_number
216: ,p_expiry_date in date default hr_api.g_date
217: ,p_proposed_start_date in date default hr_api.g_date
218: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2

Line 215: ,p_respondent_id in number default hr_api.g_number

211: ,p_effective_date in date default hr_api.g_date
212: ,p_offer_status in varchar2 default hr_api.g_varchar2
213: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
214: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
215: ,p_respondent_id in number default hr_api.g_number
216: ,p_expiry_date in date default hr_api.g_date
217: ,p_proposed_start_date in date default hr_api.g_date
218: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
219: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2

Line 216: ,p_expiry_date in date default hr_api.g_date

212: ,p_offer_status in varchar2 default hr_api.g_varchar2
213: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
214: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
215: ,p_respondent_id in number default hr_api.g_number
216: ,p_expiry_date in date default hr_api.g_date
217: ,p_proposed_start_date in date default hr_api.g_date
218: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
219: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
220: ,p_offer_shipping_date in date default hr_api.g_date

Line 217: ,p_proposed_start_date in date default hr_api.g_date

213: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
214: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
215: ,p_respondent_id in number default hr_api.g_number
216: ,p_expiry_date in date default hr_api.g_date
217: ,p_proposed_start_date in date default hr_api.g_date
218: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
219: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
220: ,p_offer_shipping_date in date default hr_api.g_date
221: ,p_applicant_assignment_id in number default hr_api.g_number

Line 218: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2

214: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
215: ,p_respondent_id in number default hr_api.g_number
216: ,p_expiry_date in date default hr_api.g_date
217: ,p_proposed_start_date in date default hr_api.g_date
218: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
219: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
220: ,p_offer_shipping_date in date default hr_api.g_date
221: ,p_applicant_assignment_id in number default hr_api.g_number
222: ,p_offer_assignment_id in number default hr_api.g_number

Line 219: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2

215: ,p_respondent_id in number default hr_api.g_number
216: ,p_expiry_date in date default hr_api.g_date
217: ,p_proposed_start_date in date default hr_api.g_date
218: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
219: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
220: ,p_offer_shipping_date in date default hr_api.g_date
221: ,p_applicant_assignment_id in number default hr_api.g_number
222: ,p_offer_assignment_id in number default hr_api.g_number
223: ,p_address_id in number default hr_api.g_number

Line 220: ,p_offer_shipping_date in date default hr_api.g_date

216: ,p_expiry_date in date default hr_api.g_date
217: ,p_proposed_start_date in date default hr_api.g_date
218: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
219: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
220: ,p_offer_shipping_date in date default hr_api.g_date
221: ,p_applicant_assignment_id in number default hr_api.g_number
222: ,p_offer_assignment_id in number default hr_api.g_number
223: ,p_address_id in number default hr_api.g_number
224: ,p_template_id in number default hr_api.g_number

Line 221: ,p_applicant_assignment_id in number default hr_api.g_number

217: ,p_proposed_start_date in date default hr_api.g_date
218: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
219: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
220: ,p_offer_shipping_date in date default hr_api.g_date
221: ,p_applicant_assignment_id in number default hr_api.g_number
222: ,p_offer_assignment_id in number default hr_api.g_number
223: ,p_address_id in number default hr_api.g_number
224: ,p_template_id in number default hr_api.g_number
225: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2

Line 222: ,p_offer_assignment_id in number default hr_api.g_number

218: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
219: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
220: ,p_offer_shipping_date in date default hr_api.g_date
221: ,p_applicant_assignment_id in number default hr_api.g_number
222: ,p_offer_assignment_id in number default hr_api.g_number
223: ,p_address_id in number default hr_api.g_number
224: ,p_template_id in number default hr_api.g_number
225: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
226: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2

Line 223: ,p_address_id in number default hr_api.g_number

219: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
220: ,p_offer_shipping_date in date default hr_api.g_date
221: ,p_applicant_assignment_id in number default hr_api.g_number
222: ,p_offer_assignment_id in number default hr_api.g_number
223: ,p_address_id in number default hr_api.g_number
224: ,p_template_id in number default hr_api.g_number
225: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
226: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
227: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 224: ,p_template_id in number default hr_api.g_number

220: ,p_offer_shipping_date in date default hr_api.g_date
221: ,p_applicant_assignment_id in number default hr_api.g_number
222: ,p_offer_assignment_id in number default hr_api.g_number
223: ,p_address_id in number default hr_api.g_number
224: ,p_template_id in number default hr_api.g_number
225: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
226: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
227: ,p_attribute_category in varchar2 default hr_api.g_varchar2
228: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 225: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2

221: ,p_applicant_assignment_id in number default hr_api.g_number
222: ,p_offer_assignment_id in number default hr_api.g_number
223: ,p_address_id in number default hr_api.g_number
224: ,p_template_id in number default hr_api.g_number
225: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
226: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
227: ,p_attribute_category in varchar2 default hr_api.g_varchar2
228: ,p_attribute1 in varchar2 default hr_api.g_varchar2
229: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 226: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2

222: ,p_offer_assignment_id in number default hr_api.g_number
223: ,p_address_id in number default hr_api.g_number
224: ,p_template_id in number default hr_api.g_number
225: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
226: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
227: ,p_attribute_category in varchar2 default hr_api.g_varchar2
228: ,p_attribute1 in varchar2 default hr_api.g_varchar2
229: ,p_attribute2 in varchar2 default hr_api.g_varchar2
230: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 227: ,p_attribute_category in varchar2 default hr_api.g_varchar2

223: ,p_address_id in number default hr_api.g_number
224: ,p_template_id in number default hr_api.g_number
225: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
226: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
227: ,p_attribute_category in varchar2 default hr_api.g_varchar2
228: ,p_attribute1 in varchar2 default hr_api.g_varchar2
229: ,p_attribute2 in varchar2 default hr_api.g_varchar2
230: ,p_attribute3 in varchar2 default hr_api.g_varchar2
231: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 228: ,p_attribute1 in varchar2 default hr_api.g_varchar2

224: ,p_template_id in number default hr_api.g_number
225: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
226: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
227: ,p_attribute_category in varchar2 default hr_api.g_varchar2
228: ,p_attribute1 in varchar2 default hr_api.g_varchar2
229: ,p_attribute2 in varchar2 default hr_api.g_varchar2
230: ,p_attribute3 in varchar2 default hr_api.g_varchar2
231: ,p_attribute4 in varchar2 default hr_api.g_varchar2
232: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 229: ,p_attribute2 in varchar2 default hr_api.g_varchar2

225: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
226: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
227: ,p_attribute_category in varchar2 default hr_api.g_varchar2
228: ,p_attribute1 in varchar2 default hr_api.g_varchar2
229: ,p_attribute2 in varchar2 default hr_api.g_varchar2
230: ,p_attribute3 in varchar2 default hr_api.g_varchar2
231: ,p_attribute4 in varchar2 default hr_api.g_varchar2
232: ,p_attribute5 in varchar2 default hr_api.g_varchar2
233: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 230: ,p_attribute3 in varchar2 default hr_api.g_varchar2

226: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
227: ,p_attribute_category in varchar2 default hr_api.g_varchar2
228: ,p_attribute1 in varchar2 default hr_api.g_varchar2
229: ,p_attribute2 in varchar2 default hr_api.g_varchar2
230: ,p_attribute3 in varchar2 default hr_api.g_varchar2
231: ,p_attribute4 in varchar2 default hr_api.g_varchar2
232: ,p_attribute5 in varchar2 default hr_api.g_varchar2
233: ,p_attribute6 in varchar2 default hr_api.g_varchar2
234: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 231: ,p_attribute4 in varchar2 default hr_api.g_varchar2

227: ,p_attribute_category in varchar2 default hr_api.g_varchar2
228: ,p_attribute1 in varchar2 default hr_api.g_varchar2
229: ,p_attribute2 in varchar2 default hr_api.g_varchar2
230: ,p_attribute3 in varchar2 default hr_api.g_varchar2
231: ,p_attribute4 in varchar2 default hr_api.g_varchar2
232: ,p_attribute5 in varchar2 default hr_api.g_varchar2
233: ,p_attribute6 in varchar2 default hr_api.g_varchar2
234: ,p_attribute7 in varchar2 default hr_api.g_varchar2
235: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 232: ,p_attribute5 in varchar2 default hr_api.g_varchar2

228: ,p_attribute1 in varchar2 default hr_api.g_varchar2
229: ,p_attribute2 in varchar2 default hr_api.g_varchar2
230: ,p_attribute3 in varchar2 default hr_api.g_varchar2
231: ,p_attribute4 in varchar2 default hr_api.g_varchar2
232: ,p_attribute5 in varchar2 default hr_api.g_varchar2
233: ,p_attribute6 in varchar2 default hr_api.g_varchar2
234: ,p_attribute7 in varchar2 default hr_api.g_varchar2
235: ,p_attribute8 in varchar2 default hr_api.g_varchar2
236: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 233: ,p_attribute6 in varchar2 default hr_api.g_varchar2

229: ,p_attribute2 in varchar2 default hr_api.g_varchar2
230: ,p_attribute3 in varchar2 default hr_api.g_varchar2
231: ,p_attribute4 in varchar2 default hr_api.g_varchar2
232: ,p_attribute5 in varchar2 default hr_api.g_varchar2
233: ,p_attribute6 in varchar2 default hr_api.g_varchar2
234: ,p_attribute7 in varchar2 default hr_api.g_varchar2
235: ,p_attribute8 in varchar2 default hr_api.g_varchar2
236: ,p_attribute9 in varchar2 default hr_api.g_varchar2
237: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 234: ,p_attribute7 in varchar2 default hr_api.g_varchar2

230: ,p_attribute3 in varchar2 default hr_api.g_varchar2
231: ,p_attribute4 in varchar2 default hr_api.g_varchar2
232: ,p_attribute5 in varchar2 default hr_api.g_varchar2
233: ,p_attribute6 in varchar2 default hr_api.g_varchar2
234: ,p_attribute7 in varchar2 default hr_api.g_varchar2
235: ,p_attribute8 in varchar2 default hr_api.g_varchar2
236: ,p_attribute9 in varchar2 default hr_api.g_varchar2
237: ,p_attribute10 in varchar2 default hr_api.g_varchar2
238: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 235: ,p_attribute8 in varchar2 default hr_api.g_varchar2

231: ,p_attribute4 in varchar2 default hr_api.g_varchar2
232: ,p_attribute5 in varchar2 default hr_api.g_varchar2
233: ,p_attribute6 in varchar2 default hr_api.g_varchar2
234: ,p_attribute7 in varchar2 default hr_api.g_varchar2
235: ,p_attribute8 in varchar2 default hr_api.g_varchar2
236: ,p_attribute9 in varchar2 default hr_api.g_varchar2
237: ,p_attribute10 in varchar2 default hr_api.g_varchar2
238: ,p_attribute11 in varchar2 default hr_api.g_varchar2
239: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 236: ,p_attribute9 in varchar2 default hr_api.g_varchar2

232: ,p_attribute5 in varchar2 default hr_api.g_varchar2
233: ,p_attribute6 in varchar2 default hr_api.g_varchar2
234: ,p_attribute7 in varchar2 default hr_api.g_varchar2
235: ,p_attribute8 in varchar2 default hr_api.g_varchar2
236: ,p_attribute9 in varchar2 default hr_api.g_varchar2
237: ,p_attribute10 in varchar2 default hr_api.g_varchar2
238: ,p_attribute11 in varchar2 default hr_api.g_varchar2
239: ,p_attribute12 in varchar2 default hr_api.g_varchar2
240: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 237: ,p_attribute10 in varchar2 default hr_api.g_varchar2

233: ,p_attribute6 in varchar2 default hr_api.g_varchar2
234: ,p_attribute7 in varchar2 default hr_api.g_varchar2
235: ,p_attribute8 in varchar2 default hr_api.g_varchar2
236: ,p_attribute9 in varchar2 default hr_api.g_varchar2
237: ,p_attribute10 in varchar2 default hr_api.g_varchar2
238: ,p_attribute11 in varchar2 default hr_api.g_varchar2
239: ,p_attribute12 in varchar2 default hr_api.g_varchar2
240: ,p_attribute13 in varchar2 default hr_api.g_varchar2
241: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 238: ,p_attribute11 in varchar2 default hr_api.g_varchar2

234: ,p_attribute7 in varchar2 default hr_api.g_varchar2
235: ,p_attribute8 in varchar2 default hr_api.g_varchar2
236: ,p_attribute9 in varchar2 default hr_api.g_varchar2
237: ,p_attribute10 in varchar2 default hr_api.g_varchar2
238: ,p_attribute11 in varchar2 default hr_api.g_varchar2
239: ,p_attribute12 in varchar2 default hr_api.g_varchar2
240: ,p_attribute13 in varchar2 default hr_api.g_varchar2
241: ,p_attribute14 in varchar2 default hr_api.g_varchar2
242: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 239: ,p_attribute12 in varchar2 default hr_api.g_varchar2

235: ,p_attribute8 in varchar2 default hr_api.g_varchar2
236: ,p_attribute9 in varchar2 default hr_api.g_varchar2
237: ,p_attribute10 in varchar2 default hr_api.g_varchar2
238: ,p_attribute11 in varchar2 default hr_api.g_varchar2
239: ,p_attribute12 in varchar2 default hr_api.g_varchar2
240: ,p_attribute13 in varchar2 default hr_api.g_varchar2
241: ,p_attribute14 in varchar2 default hr_api.g_varchar2
242: ,p_attribute15 in varchar2 default hr_api.g_varchar2
243: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 240: ,p_attribute13 in varchar2 default hr_api.g_varchar2

236: ,p_attribute9 in varchar2 default hr_api.g_varchar2
237: ,p_attribute10 in varchar2 default hr_api.g_varchar2
238: ,p_attribute11 in varchar2 default hr_api.g_varchar2
239: ,p_attribute12 in varchar2 default hr_api.g_varchar2
240: ,p_attribute13 in varchar2 default hr_api.g_varchar2
241: ,p_attribute14 in varchar2 default hr_api.g_varchar2
242: ,p_attribute15 in varchar2 default hr_api.g_varchar2
243: ,p_attribute16 in varchar2 default hr_api.g_varchar2
244: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 241: ,p_attribute14 in varchar2 default hr_api.g_varchar2

237: ,p_attribute10 in varchar2 default hr_api.g_varchar2
238: ,p_attribute11 in varchar2 default hr_api.g_varchar2
239: ,p_attribute12 in varchar2 default hr_api.g_varchar2
240: ,p_attribute13 in varchar2 default hr_api.g_varchar2
241: ,p_attribute14 in varchar2 default hr_api.g_varchar2
242: ,p_attribute15 in varchar2 default hr_api.g_varchar2
243: ,p_attribute16 in varchar2 default hr_api.g_varchar2
244: ,p_attribute17 in varchar2 default hr_api.g_varchar2
245: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 242: ,p_attribute15 in varchar2 default hr_api.g_varchar2

238: ,p_attribute11 in varchar2 default hr_api.g_varchar2
239: ,p_attribute12 in varchar2 default hr_api.g_varchar2
240: ,p_attribute13 in varchar2 default hr_api.g_varchar2
241: ,p_attribute14 in varchar2 default hr_api.g_varchar2
242: ,p_attribute15 in varchar2 default hr_api.g_varchar2
243: ,p_attribute16 in varchar2 default hr_api.g_varchar2
244: ,p_attribute17 in varchar2 default hr_api.g_varchar2
245: ,p_attribute18 in varchar2 default hr_api.g_varchar2
246: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 243: ,p_attribute16 in varchar2 default hr_api.g_varchar2

239: ,p_attribute12 in varchar2 default hr_api.g_varchar2
240: ,p_attribute13 in varchar2 default hr_api.g_varchar2
241: ,p_attribute14 in varchar2 default hr_api.g_varchar2
242: ,p_attribute15 in varchar2 default hr_api.g_varchar2
243: ,p_attribute16 in varchar2 default hr_api.g_varchar2
244: ,p_attribute17 in varchar2 default hr_api.g_varchar2
245: ,p_attribute18 in varchar2 default hr_api.g_varchar2
246: ,p_attribute19 in varchar2 default hr_api.g_varchar2
247: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 244: ,p_attribute17 in varchar2 default hr_api.g_varchar2

240: ,p_attribute13 in varchar2 default hr_api.g_varchar2
241: ,p_attribute14 in varchar2 default hr_api.g_varchar2
242: ,p_attribute15 in varchar2 default hr_api.g_varchar2
243: ,p_attribute16 in varchar2 default hr_api.g_varchar2
244: ,p_attribute17 in varchar2 default hr_api.g_varchar2
245: ,p_attribute18 in varchar2 default hr_api.g_varchar2
246: ,p_attribute19 in varchar2 default hr_api.g_varchar2
247: ,p_attribute20 in varchar2 default hr_api.g_varchar2
248: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 245: ,p_attribute18 in varchar2 default hr_api.g_varchar2

241: ,p_attribute14 in varchar2 default hr_api.g_varchar2
242: ,p_attribute15 in varchar2 default hr_api.g_varchar2
243: ,p_attribute16 in varchar2 default hr_api.g_varchar2
244: ,p_attribute17 in varchar2 default hr_api.g_varchar2
245: ,p_attribute18 in varchar2 default hr_api.g_varchar2
246: ,p_attribute19 in varchar2 default hr_api.g_varchar2
247: ,p_attribute20 in varchar2 default hr_api.g_varchar2
248: ,p_attribute21 in varchar2 default hr_api.g_varchar2
249: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 246: ,p_attribute19 in varchar2 default hr_api.g_varchar2

242: ,p_attribute15 in varchar2 default hr_api.g_varchar2
243: ,p_attribute16 in varchar2 default hr_api.g_varchar2
244: ,p_attribute17 in varchar2 default hr_api.g_varchar2
245: ,p_attribute18 in varchar2 default hr_api.g_varchar2
246: ,p_attribute19 in varchar2 default hr_api.g_varchar2
247: ,p_attribute20 in varchar2 default hr_api.g_varchar2
248: ,p_attribute21 in varchar2 default hr_api.g_varchar2
249: ,p_attribute22 in varchar2 default hr_api.g_varchar2
250: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 247: ,p_attribute20 in varchar2 default hr_api.g_varchar2

243: ,p_attribute16 in varchar2 default hr_api.g_varchar2
244: ,p_attribute17 in varchar2 default hr_api.g_varchar2
245: ,p_attribute18 in varchar2 default hr_api.g_varchar2
246: ,p_attribute19 in varchar2 default hr_api.g_varchar2
247: ,p_attribute20 in varchar2 default hr_api.g_varchar2
248: ,p_attribute21 in varchar2 default hr_api.g_varchar2
249: ,p_attribute22 in varchar2 default hr_api.g_varchar2
250: ,p_attribute23 in varchar2 default hr_api.g_varchar2
251: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 248: ,p_attribute21 in varchar2 default hr_api.g_varchar2

244: ,p_attribute17 in varchar2 default hr_api.g_varchar2
245: ,p_attribute18 in varchar2 default hr_api.g_varchar2
246: ,p_attribute19 in varchar2 default hr_api.g_varchar2
247: ,p_attribute20 in varchar2 default hr_api.g_varchar2
248: ,p_attribute21 in varchar2 default hr_api.g_varchar2
249: ,p_attribute22 in varchar2 default hr_api.g_varchar2
250: ,p_attribute23 in varchar2 default hr_api.g_varchar2
251: ,p_attribute24 in varchar2 default hr_api.g_varchar2
252: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 249: ,p_attribute22 in varchar2 default hr_api.g_varchar2

245: ,p_attribute18 in varchar2 default hr_api.g_varchar2
246: ,p_attribute19 in varchar2 default hr_api.g_varchar2
247: ,p_attribute20 in varchar2 default hr_api.g_varchar2
248: ,p_attribute21 in varchar2 default hr_api.g_varchar2
249: ,p_attribute22 in varchar2 default hr_api.g_varchar2
250: ,p_attribute23 in varchar2 default hr_api.g_varchar2
251: ,p_attribute24 in varchar2 default hr_api.g_varchar2
252: ,p_attribute25 in varchar2 default hr_api.g_varchar2
253: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 250: ,p_attribute23 in varchar2 default hr_api.g_varchar2

246: ,p_attribute19 in varchar2 default hr_api.g_varchar2
247: ,p_attribute20 in varchar2 default hr_api.g_varchar2
248: ,p_attribute21 in varchar2 default hr_api.g_varchar2
249: ,p_attribute22 in varchar2 default hr_api.g_varchar2
250: ,p_attribute23 in varchar2 default hr_api.g_varchar2
251: ,p_attribute24 in varchar2 default hr_api.g_varchar2
252: ,p_attribute25 in varchar2 default hr_api.g_varchar2
253: ,p_attribute26 in varchar2 default hr_api.g_varchar2
254: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 251: ,p_attribute24 in varchar2 default hr_api.g_varchar2

247: ,p_attribute20 in varchar2 default hr_api.g_varchar2
248: ,p_attribute21 in varchar2 default hr_api.g_varchar2
249: ,p_attribute22 in varchar2 default hr_api.g_varchar2
250: ,p_attribute23 in varchar2 default hr_api.g_varchar2
251: ,p_attribute24 in varchar2 default hr_api.g_varchar2
252: ,p_attribute25 in varchar2 default hr_api.g_varchar2
253: ,p_attribute26 in varchar2 default hr_api.g_varchar2
254: ,p_attribute27 in varchar2 default hr_api.g_varchar2
255: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 252: ,p_attribute25 in varchar2 default hr_api.g_varchar2

248: ,p_attribute21 in varchar2 default hr_api.g_varchar2
249: ,p_attribute22 in varchar2 default hr_api.g_varchar2
250: ,p_attribute23 in varchar2 default hr_api.g_varchar2
251: ,p_attribute24 in varchar2 default hr_api.g_varchar2
252: ,p_attribute25 in varchar2 default hr_api.g_varchar2
253: ,p_attribute26 in varchar2 default hr_api.g_varchar2
254: ,p_attribute27 in varchar2 default hr_api.g_varchar2
255: ,p_attribute28 in varchar2 default hr_api.g_varchar2
256: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 253: ,p_attribute26 in varchar2 default hr_api.g_varchar2

249: ,p_attribute22 in varchar2 default hr_api.g_varchar2
250: ,p_attribute23 in varchar2 default hr_api.g_varchar2
251: ,p_attribute24 in varchar2 default hr_api.g_varchar2
252: ,p_attribute25 in varchar2 default hr_api.g_varchar2
253: ,p_attribute26 in varchar2 default hr_api.g_varchar2
254: ,p_attribute27 in varchar2 default hr_api.g_varchar2
255: ,p_attribute28 in varchar2 default hr_api.g_varchar2
256: ,p_attribute29 in varchar2 default hr_api.g_varchar2
257: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 254: ,p_attribute27 in varchar2 default hr_api.g_varchar2

250: ,p_attribute23 in varchar2 default hr_api.g_varchar2
251: ,p_attribute24 in varchar2 default hr_api.g_varchar2
252: ,p_attribute25 in varchar2 default hr_api.g_varchar2
253: ,p_attribute26 in varchar2 default hr_api.g_varchar2
254: ,p_attribute27 in varchar2 default hr_api.g_varchar2
255: ,p_attribute28 in varchar2 default hr_api.g_varchar2
256: ,p_attribute29 in varchar2 default hr_api.g_varchar2
257: ,p_attribute30 in varchar2 default hr_api.g_varchar2
258: ,p_change_reason in varchar2 default null

Line 255: ,p_attribute28 in varchar2 default hr_api.g_varchar2

251: ,p_attribute24 in varchar2 default hr_api.g_varchar2
252: ,p_attribute25 in varchar2 default hr_api.g_varchar2
253: ,p_attribute26 in varchar2 default hr_api.g_varchar2
254: ,p_attribute27 in varchar2 default hr_api.g_varchar2
255: ,p_attribute28 in varchar2 default hr_api.g_varchar2
256: ,p_attribute29 in varchar2 default hr_api.g_varchar2
257: ,p_attribute30 in varchar2 default hr_api.g_varchar2
258: ,p_change_reason in varchar2 default null
259: ,p_decline_reason in varchar2 default null

Line 256: ,p_attribute29 in varchar2 default hr_api.g_varchar2

252: ,p_attribute25 in varchar2 default hr_api.g_varchar2
253: ,p_attribute26 in varchar2 default hr_api.g_varchar2
254: ,p_attribute27 in varchar2 default hr_api.g_varchar2
255: ,p_attribute28 in varchar2 default hr_api.g_varchar2
256: ,p_attribute29 in varchar2 default hr_api.g_varchar2
257: ,p_attribute30 in varchar2 default hr_api.g_varchar2
258: ,p_change_reason in varchar2 default null
259: ,p_decline_reason in varchar2 default null
260: ,p_note_text in varchar2 default null

Line 257: ,p_attribute30 in varchar2 default hr_api.g_varchar2

253: ,p_attribute26 in varchar2 default hr_api.g_varchar2
254: ,p_attribute27 in varchar2 default hr_api.g_varchar2
255: ,p_attribute28 in varchar2 default hr_api.g_varchar2
256: ,p_attribute29 in varchar2 default hr_api.g_varchar2
257: ,p_attribute30 in varchar2 default hr_api.g_varchar2
258: ,p_change_reason in varchar2 default null
259: ,p_decline_reason in varchar2 default null
260: ,p_note_text in varchar2 default null
261: ,p_status_change_date in date default null

Line 296: hr_api.constant_to_boolean

292: --
293: -- Convert constant values to their corresponding boolean value
294: --
295: l_validate :=
296: hr_api.constant_to_boolean
297: (p_constant_value => p_validate);
298: --
299: -- Register Surrogate ID or user key values
300: --

Line 418: (p_validate in number default hr_api.g_false_num

414: -- ----------------------------------------------------------------------------
415: -- |-----------------------------< delete_offer >-----------------------------|
416: -- ----------------------------------------------------------------------------
417: PROCEDURE delete_offer
418: (p_validate in number default hr_api.g_false_num
419: ,p_object_version_number in number
420: ,p_offer_id in number
421: ,p_effective_date in date default hr_api.g_date
422: ,p_return_status out nocopy varchar2

Line 421: ,p_effective_date in date default hr_api.g_date

417: PROCEDURE delete_offer
418: (p_validate in number default hr_api.g_false_num
419: ,p_object_version_number in number
420: ,p_offer_id in number
421: ,p_effective_date in date default hr_api.g_date
422: ,p_return_status out nocopy varchar2
423: ) is
424: --
425: -- Variables for API Boolean parameters

Line 449: hr_api.constant_to_boolean

445: --
446: -- Convert constant values to their corresponding boolean value
447: --
448: l_validate :=
449: hr_api.constant_to_boolean
450: (p_constant_value => p_validate);
451: --
452: -- Register Surrogate ID or user key values
453: --

Line 514: (p_validate in number default hr_api.g_false_num

510: -- ----------------------------------------------------------------------------
511: -- |------------------------------< close_offer >-----------------------------|
512: -- ----------------------------------------------------------------------------
513: PROCEDURE close_offer
514: (p_validate in number default hr_api.g_false_num
515: ,p_effective_date in date default hr_api.g_date
516: ,p_applicant_assignment_id in number default hr_api.g_number
517: ,p_offer_id in number default hr_api.g_number
518: ,p_respondent_id in number default hr_api.g_number

Line 515: ,p_effective_date in date default hr_api.g_date

511: -- |------------------------------< close_offer >-----------------------------|
512: -- ----------------------------------------------------------------------------
513: PROCEDURE close_offer
514: (p_validate in number default hr_api.g_false_num
515: ,p_effective_date in date default hr_api.g_date
516: ,p_applicant_assignment_id in number default hr_api.g_number
517: ,p_offer_id in number default hr_api.g_number
518: ,p_respondent_id in number default hr_api.g_number
519: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 516: ,p_applicant_assignment_id in number default hr_api.g_number

512: -- ----------------------------------------------------------------------------
513: PROCEDURE close_offer
514: (p_validate in number default hr_api.g_false_num
515: ,p_effective_date in date default hr_api.g_date
516: ,p_applicant_assignment_id in number default hr_api.g_number
517: ,p_offer_id in number default hr_api.g_number
518: ,p_respondent_id in number default hr_api.g_number
519: ,p_change_reason in varchar2 default hr_api.g_varchar2
520: ,p_decline_reason in varchar2 default hr_api.g_varchar2

Line 517: ,p_offer_id in number default hr_api.g_number

513: PROCEDURE close_offer
514: (p_validate in number default hr_api.g_false_num
515: ,p_effective_date in date default hr_api.g_date
516: ,p_applicant_assignment_id in number default hr_api.g_number
517: ,p_offer_id in number default hr_api.g_number
518: ,p_respondent_id in number default hr_api.g_number
519: ,p_change_reason in varchar2 default hr_api.g_varchar2
520: ,p_decline_reason in varchar2 default hr_api.g_varchar2
521: ,p_note_text in varchar2 default hr_api.g_varchar2

Line 518: ,p_respondent_id in number default hr_api.g_number

514: (p_validate in number default hr_api.g_false_num
515: ,p_effective_date in date default hr_api.g_date
516: ,p_applicant_assignment_id in number default hr_api.g_number
517: ,p_offer_id in number default hr_api.g_number
518: ,p_respondent_id in number default hr_api.g_number
519: ,p_change_reason in varchar2 default hr_api.g_varchar2
520: ,p_decline_reason in varchar2 default hr_api.g_varchar2
521: ,p_note_text in varchar2 default hr_api.g_varchar2
522: ,p_status_change_date in date default hr_api.g_date

Line 519: ,p_change_reason in varchar2 default hr_api.g_varchar2

515: ,p_effective_date in date default hr_api.g_date
516: ,p_applicant_assignment_id in number default hr_api.g_number
517: ,p_offer_id in number default hr_api.g_number
518: ,p_respondent_id in number default hr_api.g_number
519: ,p_change_reason in varchar2 default hr_api.g_varchar2
520: ,p_decline_reason in varchar2 default hr_api.g_varchar2
521: ,p_note_text in varchar2 default hr_api.g_varchar2
522: ,p_status_change_date in date default hr_api.g_date
523: ,p_return_status out nocopy varchar2

Line 520: ,p_decline_reason in varchar2 default hr_api.g_varchar2

516: ,p_applicant_assignment_id in number default hr_api.g_number
517: ,p_offer_id in number default hr_api.g_number
518: ,p_respondent_id in number default hr_api.g_number
519: ,p_change_reason in varchar2 default hr_api.g_varchar2
520: ,p_decline_reason in varchar2 default hr_api.g_varchar2
521: ,p_note_text in varchar2 default hr_api.g_varchar2
522: ,p_status_change_date in date default hr_api.g_date
523: ,p_return_status out nocopy varchar2
524: ) is

Line 521: ,p_note_text in varchar2 default hr_api.g_varchar2

517: ,p_offer_id in number default hr_api.g_number
518: ,p_respondent_id in number default hr_api.g_number
519: ,p_change_reason in varchar2 default hr_api.g_varchar2
520: ,p_decline_reason in varchar2 default hr_api.g_varchar2
521: ,p_note_text in varchar2 default hr_api.g_varchar2
522: ,p_status_change_date in date default hr_api.g_date
523: ,p_return_status out nocopy varchar2
524: ) is
525: --

Line 522: ,p_status_change_date in date default hr_api.g_date

518: ,p_respondent_id in number default hr_api.g_number
519: ,p_change_reason in varchar2 default hr_api.g_varchar2
520: ,p_decline_reason in varchar2 default hr_api.g_varchar2
521: ,p_note_text in varchar2 default hr_api.g_varchar2
522: ,p_status_change_date in date default hr_api.g_date
523: ,p_return_status out nocopy varchar2
524: ) is
525: --
526: -- Variables for API Boolean parameters

Line 550: hr_api.constant_to_boolean

546: --
547: -- Convert constant values to their corresponding boolean value
548: --
549: l_validate :=
550: hr_api.constant_to_boolean
551: (p_constant_value => p_validate);
552: --
553: -- Register Surrogate ID or user key values
554: --

Line 620: (p_validate in number default hr_api.g_false_num

616: -- ----------------------------------------------------------------------------
617: -- |------------------------------< hold_offer >------------------------------|
618: -- ----------------------------------------------------------------------------
619: PROCEDURE hold_offer
620: (p_validate in number default hr_api.g_false_num
621: ,p_effective_date in date default hr_api.g_date
622: ,p_offer_id in number
623: ,p_respondent_id in number default hr_api.g_number
624: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 621: ,p_effective_date in date default hr_api.g_date

617: -- |------------------------------< hold_offer >------------------------------|
618: -- ----------------------------------------------------------------------------
619: PROCEDURE hold_offer
620: (p_validate in number default hr_api.g_false_num
621: ,p_effective_date in date default hr_api.g_date
622: ,p_offer_id in number
623: ,p_respondent_id in number default hr_api.g_number
624: ,p_change_reason in varchar2 default hr_api.g_varchar2
625: ,p_status_change_date in date default hr_api.g_date

Line 623: ,p_respondent_id in number default hr_api.g_number

619: PROCEDURE hold_offer
620: (p_validate in number default hr_api.g_false_num
621: ,p_effective_date in date default hr_api.g_date
622: ,p_offer_id in number
623: ,p_respondent_id in number default hr_api.g_number
624: ,p_change_reason in varchar2 default hr_api.g_varchar2
625: ,p_status_change_date in date default hr_api.g_date
626: ,p_note_text in varchar2 default hr_api.g_varchar2
627: ,p_object_version_number in out nocopy number

Line 624: ,p_change_reason in varchar2 default hr_api.g_varchar2

620: (p_validate in number default hr_api.g_false_num
621: ,p_effective_date in date default hr_api.g_date
622: ,p_offer_id in number
623: ,p_respondent_id in number default hr_api.g_number
624: ,p_change_reason in varchar2 default hr_api.g_varchar2
625: ,p_status_change_date in date default hr_api.g_date
626: ,p_note_text in varchar2 default hr_api.g_varchar2
627: ,p_object_version_number in out nocopy number
628: ,p_return_status out nocopy varchar2

Line 625: ,p_status_change_date in date default hr_api.g_date

621: ,p_effective_date in date default hr_api.g_date
622: ,p_offer_id in number
623: ,p_respondent_id in number default hr_api.g_number
624: ,p_change_reason in varchar2 default hr_api.g_varchar2
625: ,p_status_change_date in date default hr_api.g_date
626: ,p_note_text in varchar2 default hr_api.g_varchar2
627: ,p_object_version_number in out nocopy number
628: ,p_return_status out nocopy varchar2
629: ) is

Line 626: ,p_note_text in varchar2 default hr_api.g_varchar2

622: ,p_offer_id in number
623: ,p_respondent_id in number default hr_api.g_number
624: ,p_change_reason in varchar2 default hr_api.g_varchar2
625: ,p_status_change_date in date default hr_api.g_date
626: ,p_note_text in varchar2 default hr_api.g_varchar2
627: ,p_object_version_number in out nocopy number
628: ,p_return_status out nocopy varchar2
629: ) is
630: --

Line 657: hr_api.constant_to_boolean

653: --
654: -- Convert constant values to their corresponding boolean value
655: --
656: l_validate :=
657: hr_api.constant_to_boolean
658: (p_constant_value => p_validate);
659: --
660: -- Register Surrogate ID or user key values
661: --

Line 728: (p_validate in number default hr_api.g_false_num

724: -- ----------------------------------------------------------------------------
725: -- |-----------------------------< release_offer >----------------------------|
726: -- ----------------------------------------------------------------------------
727: PROCEDURE release_offer
728: (p_validate in number default hr_api.g_false_num
729: ,p_effective_date in date default hr_api.g_date
730: ,p_offer_id in number
731: ,p_respondent_id in number default hr_api.g_number
732: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 729: ,p_effective_date in date default hr_api.g_date

725: -- |-----------------------------< release_offer >----------------------------|
726: -- ----------------------------------------------------------------------------
727: PROCEDURE release_offer
728: (p_validate in number default hr_api.g_false_num
729: ,p_effective_date in date default hr_api.g_date
730: ,p_offer_id in number
731: ,p_respondent_id in number default hr_api.g_number
732: ,p_change_reason in varchar2 default hr_api.g_varchar2
733: ,p_status_change_date in date default hr_api.g_date

Line 731: ,p_respondent_id in number default hr_api.g_number

727: PROCEDURE release_offer
728: (p_validate in number default hr_api.g_false_num
729: ,p_effective_date in date default hr_api.g_date
730: ,p_offer_id in number
731: ,p_respondent_id in number default hr_api.g_number
732: ,p_change_reason in varchar2 default hr_api.g_varchar2
733: ,p_status_change_date in date default hr_api.g_date
734: ,p_note_text in varchar2 default hr_api.g_varchar2
735: ,p_object_version_number in out nocopy number

Line 732: ,p_change_reason in varchar2 default hr_api.g_varchar2

728: (p_validate in number default hr_api.g_false_num
729: ,p_effective_date in date default hr_api.g_date
730: ,p_offer_id in number
731: ,p_respondent_id in number default hr_api.g_number
732: ,p_change_reason in varchar2 default hr_api.g_varchar2
733: ,p_status_change_date in date default hr_api.g_date
734: ,p_note_text in varchar2 default hr_api.g_varchar2
735: ,p_object_version_number in out nocopy number
736: ,p_return_status out nocopy varchar2

Line 733: ,p_status_change_date in date default hr_api.g_date

729: ,p_effective_date in date default hr_api.g_date
730: ,p_offer_id in number
731: ,p_respondent_id in number default hr_api.g_number
732: ,p_change_reason in varchar2 default hr_api.g_varchar2
733: ,p_status_change_date in date default hr_api.g_date
734: ,p_note_text in varchar2 default hr_api.g_varchar2
735: ,p_object_version_number in out nocopy number
736: ,p_return_status out nocopy varchar2
737: ) is

Line 734: ,p_note_text in varchar2 default hr_api.g_varchar2

730: ,p_offer_id in number
731: ,p_respondent_id in number default hr_api.g_number
732: ,p_change_reason in varchar2 default hr_api.g_varchar2
733: ,p_status_change_date in date default hr_api.g_date
734: ,p_note_text in varchar2 default hr_api.g_varchar2
735: ,p_object_version_number in out nocopy number
736: ,p_return_status out nocopy varchar2
737: ) is
738: --

Line 765: hr_api.constant_to_boolean

761: --
762: -- Convert constant values to their corresponding boolean value
763: --
764: l_validate :=
765: hr_api.constant_to_boolean
766: (p_constant_value => p_validate);
767: --
768: -- Register Surrogate ID or user key values
769: --

Line 926: ,p_validate in number default hr_api.g_false_num

922: ,p_title in varchar2 default null
923: ,p_validate_df_flex in number default null
924: ,p_object_version_number out nocopy number
925: ,p_effective_date in date
926: ,p_validate in number default hr_api.g_false_num
927: ,p_contract_id in number default null
928: ,p_establishment_id in number default null
929: ,p_collective_agreement_id in number default null
930: ,p_cagr_grade_def_id in number default null

Line 983: hr_api.constant_to_boolean

979: --
980: -- Convert constant values to their corresponding boolean value
981: --
982: l_validate_df_flex :=
983: hr_api.constant_to_boolean
984: (p_constant_value => p_validate_df_flex);
985: l_validate :=
986: hr_api.constant_to_boolean
987: (p_constant_value => p_validate);

Line 986: hr_api.constant_to_boolean

982: l_validate_df_flex :=
983: hr_api.constant_to_boolean
984: (p_constant_value => p_validate_df_flex);
985: l_validate :=
986: hr_api.constant_to_boolean
987: (p_constant_value => p_validate);
988: --
989: -- Register Surrogate ID or user key values
990: --

Line 1199: ,p_recruiter_id in number default hr_api.g_number

1195: (p_assignment_id in out nocopy number
1196: ,p_effective_start_date out nocopy date
1197: ,p_effective_end_date out nocopy date
1198: ,p_business_group_id out nocopy number
1199: ,p_recruiter_id in number default hr_api.g_number
1200: ,p_grade_id in number default hr_api.g_number
1201: ,p_position_id in number default hr_api.g_number
1202: ,p_job_id in number default hr_api.g_number
1203: ,p_assignment_status_type_id in number default hr_api.g_number

Line 1200: ,p_grade_id in number default hr_api.g_number

1196: ,p_effective_start_date out nocopy date
1197: ,p_effective_end_date out nocopy date
1198: ,p_business_group_id out nocopy number
1199: ,p_recruiter_id in number default hr_api.g_number
1200: ,p_grade_id in number default hr_api.g_number
1201: ,p_position_id in number default hr_api.g_number
1202: ,p_job_id in number default hr_api.g_number
1203: ,p_assignment_status_type_id in number default hr_api.g_number
1204: ,p_payroll_id in number default hr_api.g_number

Line 1201: ,p_position_id in number default hr_api.g_number

1197: ,p_effective_end_date out nocopy date
1198: ,p_business_group_id out nocopy number
1199: ,p_recruiter_id in number default hr_api.g_number
1200: ,p_grade_id in number default hr_api.g_number
1201: ,p_position_id in number default hr_api.g_number
1202: ,p_job_id in number default hr_api.g_number
1203: ,p_assignment_status_type_id in number default hr_api.g_number
1204: ,p_payroll_id in number default hr_api.g_number
1205: ,p_location_id in number default hr_api.g_number

Line 1202: ,p_job_id in number default hr_api.g_number

1198: ,p_business_group_id out nocopy number
1199: ,p_recruiter_id in number default hr_api.g_number
1200: ,p_grade_id in number default hr_api.g_number
1201: ,p_position_id in number default hr_api.g_number
1202: ,p_job_id in number default hr_api.g_number
1203: ,p_assignment_status_type_id in number default hr_api.g_number
1204: ,p_payroll_id in number default hr_api.g_number
1205: ,p_location_id in number default hr_api.g_number
1206: ,p_person_referred_by_id in number default hr_api.g_number

Line 1203: ,p_assignment_status_type_id in number default hr_api.g_number

1199: ,p_recruiter_id in number default hr_api.g_number
1200: ,p_grade_id in number default hr_api.g_number
1201: ,p_position_id in number default hr_api.g_number
1202: ,p_job_id in number default hr_api.g_number
1203: ,p_assignment_status_type_id in number default hr_api.g_number
1204: ,p_payroll_id in number default hr_api.g_number
1205: ,p_location_id in number default hr_api.g_number
1206: ,p_person_referred_by_id in number default hr_api.g_number
1207: ,p_supervisor_id in number default hr_api.g_number

Line 1204: ,p_payroll_id in number default hr_api.g_number

1200: ,p_grade_id in number default hr_api.g_number
1201: ,p_position_id in number default hr_api.g_number
1202: ,p_job_id in number default hr_api.g_number
1203: ,p_assignment_status_type_id in number default hr_api.g_number
1204: ,p_payroll_id in number default hr_api.g_number
1205: ,p_location_id in number default hr_api.g_number
1206: ,p_person_referred_by_id in number default hr_api.g_number
1207: ,p_supervisor_id in number default hr_api.g_number
1208: ,p_special_ceiling_step_id in number default hr_api.g_number

Line 1205: ,p_location_id in number default hr_api.g_number

1201: ,p_position_id in number default hr_api.g_number
1202: ,p_job_id in number default hr_api.g_number
1203: ,p_assignment_status_type_id in number default hr_api.g_number
1204: ,p_payroll_id in number default hr_api.g_number
1205: ,p_location_id in number default hr_api.g_number
1206: ,p_person_referred_by_id in number default hr_api.g_number
1207: ,p_supervisor_id in number default hr_api.g_number
1208: ,p_special_ceiling_step_id in number default hr_api.g_number
1209: ,p_recruitment_activity_id in number default hr_api.g_number

Line 1206: ,p_person_referred_by_id in number default hr_api.g_number

1202: ,p_job_id in number default hr_api.g_number
1203: ,p_assignment_status_type_id in number default hr_api.g_number
1204: ,p_payroll_id in number default hr_api.g_number
1205: ,p_location_id in number default hr_api.g_number
1206: ,p_person_referred_by_id in number default hr_api.g_number
1207: ,p_supervisor_id in number default hr_api.g_number
1208: ,p_special_ceiling_step_id in number default hr_api.g_number
1209: ,p_recruitment_activity_id in number default hr_api.g_number
1210: ,p_source_organization_id in number default hr_api.g_number

Line 1207: ,p_supervisor_id in number default hr_api.g_number

1203: ,p_assignment_status_type_id in number default hr_api.g_number
1204: ,p_payroll_id in number default hr_api.g_number
1205: ,p_location_id in number default hr_api.g_number
1206: ,p_person_referred_by_id in number default hr_api.g_number
1207: ,p_supervisor_id in number default hr_api.g_number
1208: ,p_special_ceiling_step_id in number default hr_api.g_number
1209: ,p_recruitment_activity_id in number default hr_api.g_number
1210: ,p_source_organization_id in number default hr_api.g_number
1211: ,p_organization_id in number default hr_api.g_number

Line 1208: ,p_special_ceiling_step_id in number default hr_api.g_number

1204: ,p_payroll_id in number default hr_api.g_number
1205: ,p_location_id in number default hr_api.g_number
1206: ,p_person_referred_by_id in number default hr_api.g_number
1207: ,p_supervisor_id in number default hr_api.g_number
1208: ,p_special_ceiling_step_id in number default hr_api.g_number
1209: ,p_recruitment_activity_id in number default hr_api.g_number
1210: ,p_source_organization_id in number default hr_api.g_number
1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_people_group_id in number default hr_api.g_number

Line 1209: ,p_recruitment_activity_id in number default hr_api.g_number

1205: ,p_location_id in number default hr_api.g_number
1206: ,p_person_referred_by_id in number default hr_api.g_number
1207: ,p_supervisor_id in number default hr_api.g_number
1208: ,p_special_ceiling_step_id in number default hr_api.g_number
1209: ,p_recruitment_activity_id in number default hr_api.g_number
1210: ,p_source_organization_id in number default hr_api.g_number
1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_people_group_id in number default hr_api.g_number
1213: ,p_soft_coding_keyflex_id in number default hr_api.g_number

Line 1210: ,p_source_organization_id in number default hr_api.g_number

1206: ,p_person_referred_by_id in number default hr_api.g_number
1207: ,p_supervisor_id in number default hr_api.g_number
1208: ,p_special_ceiling_step_id in number default hr_api.g_number
1209: ,p_recruitment_activity_id in number default hr_api.g_number
1210: ,p_source_organization_id in number default hr_api.g_number
1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_people_group_id in number default hr_api.g_number
1213: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1214: ,p_vacancy_id in number default hr_api.g_number

Line 1211: ,p_organization_id in number default hr_api.g_number

1207: ,p_supervisor_id in number default hr_api.g_number
1208: ,p_special_ceiling_step_id in number default hr_api.g_number
1209: ,p_recruitment_activity_id in number default hr_api.g_number
1210: ,p_source_organization_id in number default hr_api.g_number
1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_people_group_id in number default hr_api.g_number
1213: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1214: ,p_vacancy_id in number default hr_api.g_number
1215: ,p_pay_basis_id in number default hr_api.g_number

Line 1212: ,p_people_group_id in number default hr_api.g_number

1208: ,p_special_ceiling_step_id in number default hr_api.g_number
1209: ,p_recruitment_activity_id in number default hr_api.g_number
1210: ,p_source_organization_id in number default hr_api.g_number
1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_people_group_id in number default hr_api.g_number
1213: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1214: ,p_vacancy_id in number default hr_api.g_number
1215: ,p_pay_basis_id in number default hr_api.g_number
1216: ,p_assignment_type in varchar2 default hr_api.g_varchar2

Line 1213: ,p_soft_coding_keyflex_id in number default hr_api.g_number

1209: ,p_recruitment_activity_id in number default hr_api.g_number
1210: ,p_source_organization_id in number default hr_api.g_number
1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_people_group_id in number default hr_api.g_number
1213: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1214: ,p_vacancy_id in number default hr_api.g_number
1215: ,p_pay_basis_id in number default hr_api.g_number
1216: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1217: ,p_primary_flag in varchar2 default hr_api.g_varchar2

Line 1214: ,p_vacancy_id in number default hr_api.g_number

1210: ,p_source_organization_id in number default hr_api.g_number
1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_people_group_id in number default hr_api.g_number
1213: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1214: ,p_vacancy_id in number default hr_api.g_number
1215: ,p_pay_basis_id in number default hr_api.g_number
1216: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1217: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1218: ,p_application_id in number default hr_api.g_number

Line 1215: ,p_pay_basis_id in number default hr_api.g_number

1211: ,p_organization_id in number default hr_api.g_number
1212: ,p_people_group_id in number default hr_api.g_number
1213: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1214: ,p_vacancy_id in number default hr_api.g_number
1215: ,p_pay_basis_id in number default hr_api.g_number
1216: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1217: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1218: ,p_application_id in number default hr_api.g_number
1219: ,p_assignment_number in varchar2 default hr_api.g_varchar2

Line 1216: ,p_assignment_type in varchar2 default hr_api.g_varchar2

1212: ,p_people_group_id in number default hr_api.g_number
1213: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1214: ,p_vacancy_id in number default hr_api.g_number
1215: ,p_pay_basis_id in number default hr_api.g_number
1216: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1217: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1218: ,p_application_id in number default hr_api.g_number
1219: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1220: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 1217: ,p_primary_flag in varchar2 default hr_api.g_varchar2

1213: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1214: ,p_vacancy_id in number default hr_api.g_number
1215: ,p_pay_basis_id in number default hr_api.g_number
1216: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1217: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1218: ,p_application_id in number default hr_api.g_number
1219: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1220: ,p_change_reason in varchar2 default hr_api.g_varchar2
1221: ,p_comment_id out nocopy number

Line 1218: ,p_application_id in number default hr_api.g_number

1214: ,p_vacancy_id in number default hr_api.g_number
1215: ,p_pay_basis_id in number default hr_api.g_number
1216: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1217: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1218: ,p_application_id in number default hr_api.g_number
1219: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1220: ,p_change_reason in varchar2 default hr_api.g_varchar2
1221: ,p_comment_id out nocopy number
1222: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1219: ,p_assignment_number in varchar2 default hr_api.g_varchar2

1215: ,p_pay_basis_id in number default hr_api.g_number
1216: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1217: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1218: ,p_application_id in number default hr_api.g_number
1219: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1220: ,p_change_reason in varchar2 default hr_api.g_varchar2
1221: ,p_comment_id out nocopy number
1222: ,p_comments in varchar2 default hr_api.g_varchar2
1223: ,p_date_probation_end in date default hr_api.g_date

Line 1220: ,p_change_reason in varchar2 default hr_api.g_varchar2

1216: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1217: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1218: ,p_application_id in number default hr_api.g_number
1219: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1220: ,p_change_reason in varchar2 default hr_api.g_varchar2
1221: ,p_comment_id out nocopy number
1222: ,p_comments in varchar2 default hr_api.g_varchar2
1223: ,p_date_probation_end in date default hr_api.g_date
1224: ,p_default_code_comb_id in number default hr_api.g_number

Line 1222: ,p_comments in varchar2 default hr_api.g_varchar2

1218: ,p_application_id in number default hr_api.g_number
1219: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1220: ,p_change_reason in varchar2 default hr_api.g_varchar2
1221: ,p_comment_id out nocopy number
1222: ,p_comments in varchar2 default hr_api.g_varchar2
1223: ,p_date_probation_end in date default hr_api.g_date
1224: ,p_default_code_comb_id in number default hr_api.g_number
1225: ,p_employment_category in varchar2 default hr_api.g_varchar2
1226: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 1223: ,p_date_probation_end in date default hr_api.g_date

1219: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1220: ,p_change_reason in varchar2 default hr_api.g_varchar2
1221: ,p_comment_id out nocopy number
1222: ,p_comments in varchar2 default hr_api.g_varchar2
1223: ,p_date_probation_end in date default hr_api.g_date
1224: ,p_default_code_comb_id in number default hr_api.g_number
1225: ,p_employment_category in varchar2 default hr_api.g_varchar2
1226: ,p_frequency in varchar2 default hr_api.g_varchar2
1227: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

Line 1224: ,p_default_code_comb_id in number default hr_api.g_number

1220: ,p_change_reason in varchar2 default hr_api.g_varchar2
1221: ,p_comment_id out nocopy number
1222: ,p_comments in varchar2 default hr_api.g_varchar2
1223: ,p_date_probation_end in date default hr_api.g_date
1224: ,p_default_code_comb_id in number default hr_api.g_number
1225: ,p_employment_category in varchar2 default hr_api.g_varchar2
1226: ,p_frequency in varchar2 default hr_api.g_varchar2
1227: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1228: ,p_manager_flag in varchar2 default hr_api.g_varchar2

Line 1225: ,p_employment_category in varchar2 default hr_api.g_varchar2

1221: ,p_comment_id out nocopy number
1222: ,p_comments in varchar2 default hr_api.g_varchar2
1223: ,p_date_probation_end in date default hr_api.g_date
1224: ,p_default_code_comb_id in number default hr_api.g_number
1225: ,p_employment_category in varchar2 default hr_api.g_varchar2
1226: ,p_frequency in varchar2 default hr_api.g_varchar2
1227: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1228: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1229: ,p_normal_hours in number default hr_api.g_number

Line 1226: ,p_frequency in varchar2 default hr_api.g_varchar2

1222: ,p_comments in varchar2 default hr_api.g_varchar2
1223: ,p_date_probation_end in date default hr_api.g_date
1224: ,p_default_code_comb_id in number default hr_api.g_number
1225: ,p_employment_category in varchar2 default hr_api.g_varchar2
1226: ,p_frequency in varchar2 default hr_api.g_varchar2
1227: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1228: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1229: ,p_normal_hours in number default hr_api.g_number
1230: ,p_perf_review_period in number default hr_api.g_number

Line 1227: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

1223: ,p_date_probation_end in date default hr_api.g_date
1224: ,p_default_code_comb_id in number default hr_api.g_number
1225: ,p_employment_category in varchar2 default hr_api.g_varchar2
1226: ,p_frequency in varchar2 default hr_api.g_varchar2
1227: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1228: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1229: ,p_normal_hours in number default hr_api.g_number
1230: ,p_perf_review_period in number default hr_api.g_number
1231: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 1228: ,p_manager_flag in varchar2 default hr_api.g_varchar2

1224: ,p_default_code_comb_id in number default hr_api.g_number
1225: ,p_employment_category in varchar2 default hr_api.g_varchar2
1226: ,p_frequency in varchar2 default hr_api.g_varchar2
1227: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1228: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1229: ,p_normal_hours in number default hr_api.g_number
1230: ,p_perf_review_period in number default hr_api.g_number
1231: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1232: ,p_period_of_service_id in number default hr_api.g_number

Line 1229: ,p_normal_hours in number default hr_api.g_number

1225: ,p_employment_category in varchar2 default hr_api.g_varchar2
1226: ,p_frequency in varchar2 default hr_api.g_varchar2
1227: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1228: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1229: ,p_normal_hours in number default hr_api.g_number
1230: ,p_perf_review_period in number default hr_api.g_number
1231: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1232: ,p_period_of_service_id in number default hr_api.g_number
1233: ,p_probation_period in number default hr_api.g_number

Line 1230: ,p_perf_review_period in number default hr_api.g_number

1226: ,p_frequency in varchar2 default hr_api.g_varchar2
1227: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1228: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1229: ,p_normal_hours in number default hr_api.g_number
1230: ,p_perf_review_period in number default hr_api.g_number
1231: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1232: ,p_period_of_service_id in number default hr_api.g_number
1233: ,p_probation_period in number default hr_api.g_number
1234: ,p_probation_unit in varchar2 default hr_api.g_varchar2

Line 1231: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

1227: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1228: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1229: ,p_normal_hours in number default hr_api.g_number
1230: ,p_perf_review_period in number default hr_api.g_number
1231: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1232: ,p_period_of_service_id in number default hr_api.g_number
1233: ,p_probation_period in number default hr_api.g_number
1234: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1235: ,p_sal_review_period in number default hr_api.g_number

Line 1232: ,p_period_of_service_id in number default hr_api.g_number

1228: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1229: ,p_normal_hours in number default hr_api.g_number
1230: ,p_perf_review_period in number default hr_api.g_number
1231: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1232: ,p_period_of_service_id in number default hr_api.g_number
1233: ,p_probation_period in number default hr_api.g_number
1234: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1235: ,p_sal_review_period in number default hr_api.g_number
1236: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 1233: ,p_probation_period in number default hr_api.g_number

1229: ,p_normal_hours in number default hr_api.g_number
1230: ,p_perf_review_period in number default hr_api.g_number
1231: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1232: ,p_period_of_service_id in number default hr_api.g_number
1233: ,p_probation_period in number default hr_api.g_number
1234: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1235: ,p_sal_review_period in number default hr_api.g_number
1236: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1237: ,p_set_of_books_id in number default hr_api.g_number

Line 1234: ,p_probation_unit in varchar2 default hr_api.g_varchar2

1230: ,p_perf_review_period in number default hr_api.g_number
1231: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1232: ,p_period_of_service_id in number default hr_api.g_number
1233: ,p_probation_period in number default hr_api.g_number
1234: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1235: ,p_sal_review_period in number default hr_api.g_number
1236: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1237: ,p_set_of_books_id in number default hr_api.g_number
1238: ,p_source_type in varchar2 default hr_api.g_varchar2

Line 1235: ,p_sal_review_period in number default hr_api.g_number

1231: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1232: ,p_period_of_service_id in number default hr_api.g_number
1233: ,p_probation_period in number default hr_api.g_number
1234: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1235: ,p_sal_review_period in number default hr_api.g_number
1236: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1237: ,p_set_of_books_id in number default hr_api.g_number
1238: ,p_source_type in varchar2 default hr_api.g_varchar2
1239: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

Line 1236: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

1232: ,p_period_of_service_id in number default hr_api.g_number
1233: ,p_probation_period in number default hr_api.g_number
1234: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1235: ,p_sal_review_period in number default hr_api.g_number
1236: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1237: ,p_set_of_books_id in number default hr_api.g_number
1238: ,p_source_type in varchar2 default hr_api.g_varchar2
1239: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1240: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

Line 1237: ,p_set_of_books_id in number default hr_api.g_number

1233: ,p_probation_period in number default hr_api.g_number
1234: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1235: ,p_sal_review_period in number default hr_api.g_number
1236: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1237: ,p_set_of_books_id in number default hr_api.g_number
1238: ,p_source_type in varchar2 default hr_api.g_varchar2
1239: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1240: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1241: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

Line 1238: ,p_source_type in varchar2 default hr_api.g_varchar2

1234: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1235: ,p_sal_review_period in number default hr_api.g_number
1236: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1237: ,p_set_of_books_id in number default hr_api.g_number
1238: ,p_source_type in varchar2 default hr_api.g_varchar2
1239: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1240: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1241: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1242: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

Line 1239: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

1235: ,p_sal_review_period in number default hr_api.g_number
1236: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1237: ,p_set_of_books_id in number default hr_api.g_number
1238: ,p_source_type in varchar2 default hr_api.g_varchar2
1239: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1240: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1241: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1242: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1243: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

Line 1240: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

1236: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1237: ,p_set_of_books_id in number default hr_api.g_number
1238: ,p_source_type in varchar2 default hr_api.g_varchar2
1239: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1240: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1241: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1242: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1243: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1244: ,p_request_id in number default hr_api.g_number

Line 1241: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

1237: ,p_set_of_books_id in number default hr_api.g_number
1238: ,p_source_type in varchar2 default hr_api.g_varchar2
1239: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1240: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1241: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1242: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1243: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1244: ,p_request_id in number default hr_api.g_number
1245: ,p_program_application_id in number default hr_api.g_number

Line 1242: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

1238: ,p_source_type in varchar2 default hr_api.g_varchar2
1239: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1240: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1241: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1242: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1243: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1244: ,p_request_id in number default hr_api.g_number
1245: ,p_program_application_id in number default hr_api.g_number
1246: ,p_program_id in number default hr_api.g_number

Line 1243: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

1239: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1240: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1241: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1242: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1243: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1244: ,p_request_id in number default hr_api.g_number
1245: ,p_program_application_id in number default hr_api.g_number
1246: ,p_program_id in number default hr_api.g_number
1247: ,p_program_update_date in date default hr_api.g_date

Line 1244: ,p_request_id in number default hr_api.g_number

1240: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1241: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1242: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1243: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1244: ,p_request_id in number default hr_api.g_number
1245: ,p_program_application_id in number default hr_api.g_number
1246: ,p_program_id in number default hr_api.g_number
1247: ,p_program_update_date in date default hr_api.g_date
1248: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

Line 1245: ,p_program_application_id in number default hr_api.g_number

1241: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1242: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1243: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1244: ,p_request_id in number default hr_api.g_number
1245: ,p_program_application_id in number default hr_api.g_number
1246: ,p_program_id in number default hr_api.g_number
1247: ,p_program_update_date in date default hr_api.g_date
1248: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1249: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

Line 1246: ,p_program_id in number default hr_api.g_number

1242: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1243: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1244: ,p_request_id in number default hr_api.g_number
1245: ,p_program_application_id in number default hr_api.g_number
1246: ,p_program_id in number default hr_api.g_number
1247: ,p_program_update_date in date default hr_api.g_date
1248: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1249: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1250: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

Line 1247: ,p_program_update_date in date default hr_api.g_date

1243: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1244: ,p_request_id in number default hr_api.g_number
1245: ,p_program_application_id in number default hr_api.g_number
1246: ,p_program_id in number default hr_api.g_number
1247: ,p_program_update_date in date default hr_api.g_date
1248: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1249: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1250: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1251: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

Line 1248: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

1244: ,p_request_id in number default hr_api.g_number
1245: ,p_program_application_id in number default hr_api.g_number
1246: ,p_program_id in number default hr_api.g_number
1247: ,p_program_update_date in date default hr_api.g_date
1248: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1249: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1250: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1251: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1252: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

Line 1249: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

1245: ,p_program_application_id in number default hr_api.g_number
1246: ,p_program_id in number default hr_api.g_number
1247: ,p_program_update_date in date default hr_api.g_date
1248: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1249: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1250: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1251: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1252: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

Line 1250: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

1246: ,p_program_id in number default hr_api.g_number
1247: ,p_program_update_date in date default hr_api.g_date
1248: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1249: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1250: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1251: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1252: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

Line 1251: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

1247: ,p_program_update_date in date default hr_api.g_date
1248: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1249: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1250: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1251: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1252: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

Line 1252: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

1248: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1249: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1250: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1251: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1252: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

Line 1253: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

1249: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1250: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1251: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1252: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

Line 1254: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

1250: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1251: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1252: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

Line 1255: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

1251: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1252: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

Line 1256: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

1252: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

Line 1257: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

1253: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

Line 1258: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

1254: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

Line 1259: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

1255: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

Line 1260: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

1256: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

Line 1261: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

1257: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

Line 1262: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

1258: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

Line 1263: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

1259: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

Line 1264: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

1260: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

Line 1265: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

1261: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

Line 1266: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

1262: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

Line 1267: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

1263: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

Line 1268: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

1264: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

Line 1269: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

1265: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

Line 1270: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

1266: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

Line 1271: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

1267: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

Line 1272: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

1268: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

Line 1273: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

1269: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

Line 1274: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

1270: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

Line 1275: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

1271: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1279: ,p_title in varchar2 default hr_api.g_varchar2

Line 1276: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

1272: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1279: ,p_title in varchar2 default hr_api.g_varchar2
1280: ,p_contract_id in number default hr_api.g_number

Line 1277: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

1273: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1279: ,p_title in varchar2 default hr_api.g_varchar2
1280: ,p_contract_id in number default hr_api.g_number
1281: ,p_establishment_id in number default hr_api.g_number

Line 1278: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

1274: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1279: ,p_title in varchar2 default hr_api.g_varchar2
1280: ,p_contract_id in number default hr_api.g_number
1281: ,p_establishment_id in number default hr_api.g_number
1282: ,p_collective_agreement_id in number default hr_api.g_number

Line 1279: ,p_title in varchar2 default hr_api.g_varchar2

1275: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1279: ,p_title in varchar2 default hr_api.g_varchar2
1280: ,p_contract_id in number default hr_api.g_number
1281: ,p_establishment_id in number default hr_api.g_number
1282: ,p_collective_agreement_id in number default hr_api.g_number
1283: ,p_cagr_grade_def_id in number default hr_api.g_number

Line 1280: ,p_contract_id in number default hr_api.g_number

1276: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1279: ,p_title in varchar2 default hr_api.g_varchar2
1280: ,p_contract_id in number default hr_api.g_number
1281: ,p_establishment_id in number default hr_api.g_number
1282: ,p_collective_agreement_id in number default hr_api.g_number
1283: ,p_cagr_grade_def_id in number default hr_api.g_number
1284: ,p_cagr_id_flex_num in number default hr_api.g_number

Line 1281: ,p_establishment_id in number default hr_api.g_number

1277: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1279: ,p_title in varchar2 default hr_api.g_varchar2
1280: ,p_contract_id in number default hr_api.g_number
1281: ,p_establishment_id in number default hr_api.g_number
1282: ,p_collective_agreement_id in number default hr_api.g_number
1283: ,p_cagr_grade_def_id in number default hr_api.g_number
1284: ,p_cagr_id_flex_num in number default hr_api.g_number
1285: ,p_asg_object_version_number in out nocopy number

Line 1282: ,p_collective_agreement_id in number default hr_api.g_number

1278: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1279: ,p_title in varchar2 default hr_api.g_varchar2
1280: ,p_contract_id in number default hr_api.g_number
1281: ,p_establishment_id in number default hr_api.g_number
1282: ,p_collective_agreement_id in number default hr_api.g_number
1283: ,p_cagr_grade_def_id in number default hr_api.g_number
1284: ,p_cagr_id_flex_num in number default hr_api.g_number
1285: ,p_asg_object_version_number in out nocopy number
1286: ,p_notice_period in number default hr_api.g_number

Line 1283: ,p_cagr_grade_def_id in number default hr_api.g_number

1279: ,p_title in varchar2 default hr_api.g_varchar2
1280: ,p_contract_id in number default hr_api.g_number
1281: ,p_establishment_id in number default hr_api.g_number
1282: ,p_collective_agreement_id in number default hr_api.g_number
1283: ,p_cagr_grade_def_id in number default hr_api.g_number
1284: ,p_cagr_id_flex_num in number default hr_api.g_number
1285: ,p_asg_object_version_number in out nocopy number
1286: ,p_notice_period in number default hr_api.g_number
1287: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

Line 1284: ,p_cagr_id_flex_num in number default hr_api.g_number

1280: ,p_contract_id in number default hr_api.g_number
1281: ,p_establishment_id in number default hr_api.g_number
1282: ,p_collective_agreement_id in number default hr_api.g_number
1283: ,p_cagr_grade_def_id in number default hr_api.g_number
1284: ,p_cagr_id_flex_num in number default hr_api.g_number
1285: ,p_asg_object_version_number in out nocopy number
1286: ,p_notice_period in number default hr_api.g_number
1287: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1288: ,p_employee_category in varchar2 default hr_api.g_varchar2

Line 1286: ,p_notice_period in number default hr_api.g_number

1282: ,p_collective_agreement_id in number default hr_api.g_number
1283: ,p_cagr_grade_def_id in number default hr_api.g_number
1284: ,p_cagr_id_flex_num in number default hr_api.g_number
1285: ,p_asg_object_version_number in out nocopy number
1286: ,p_notice_period in number default hr_api.g_number
1287: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1288: ,p_employee_category in varchar2 default hr_api.g_varchar2
1289: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1290: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

Line 1287: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

1283: ,p_cagr_grade_def_id in number default hr_api.g_number
1284: ,p_cagr_id_flex_num in number default hr_api.g_number
1285: ,p_asg_object_version_number in out nocopy number
1286: ,p_notice_period in number default hr_api.g_number
1287: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1288: ,p_employee_category in varchar2 default hr_api.g_varchar2
1289: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1290: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1291: ,p_posting_content_id in number default hr_api.g_number

Line 1288: ,p_employee_category in varchar2 default hr_api.g_varchar2

1284: ,p_cagr_id_flex_num in number default hr_api.g_number
1285: ,p_asg_object_version_number in out nocopy number
1286: ,p_notice_period in number default hr_api.g_number
1287: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1288: ,p_employee_category in varchar2 default hr_api.g_varchar2
1289: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1290: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1291: ,p_posting_content_id in number default hr_api.g_number
1292: ,p_placement_date_start in date default hr_api.g_date

Line 1289: ,p_work_at_home in varchar2 default hr_api.g_varchar2

1285: ,p_asg_object_version_number in out nocopy number
1286: ,p_notice_period in number default hr_api.g_number
1287: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1288: ,p_employee_category in varchar2 default hr_api.g_varchar2
1289: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1290: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1291: ,p_posting_content_id in number default hr_api.g_number
1292: ,p_placement_date_start in date default hr_api.g_date
1293: ,p_vendor_id in number default hr_api.g_number

Line 1290: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

1286: ,p_notice_period in number default hr_api.g_number
1287: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1288: ,p_employee_category in varchar2 default hr_api.g_varchar2
1289: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1290: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1291: ,p_posting_content_id in number default hr_api.g_number
1292: ,p_placement_date_start in date default hr_api.g_date
1293: ,p_vendor_id in number default hr_api.g_number
1294: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2

Line 1291: ,p_posting_content_id in number default hr_api.g_number

1287: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1288: ,p_employee_category in varchar2 default hr_api.g_varchar2
1289: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1290: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1291: ,p_posting_content_id in number default hr_api.g_number
1292: ,p_placement_date_start in date default hr_api.g_date
1293: ,p_vendor_id in number default hr_api.g_number
1294: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1295: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2

Line 1292: ,p_placement_date_start in date default hr_api.g_date

1288: ,p_employee_category in varchar2 default hr_api.g_varchar2
1289: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1290: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1291: ,p_posting_content_id in number default hr_api.g_number
1292: ,p_placement_date_start in date default hr_api.g_date
1293: ,p_vendor_id in number default hr_api.g_number
1294: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1295: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1296: ,p_assignment_category in varchar2 default hr_api.g_varchar2

Line 1293: ,p_vendor_id in number default hr_api.g_number

1289: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1290: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1291: ,p_posting_content_id in number default hr_api.g_number
1292: ,p_placement_date_start in date default hr_api.g_date
1293: ,p_vendor_id in number default hr_api.g_number
1294: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1295: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1296: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1297: ,p_project_title in varchar2 default hr_api.g_varchar2

Line 1294: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2

1290: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1291: ,p_posting_content_id in number default hr_api.g_number
1292: ,p_placement_date_start in date default hr_api.g_date
1293: ,p_vendor_id in number default hr_api.g_number
1294: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1295: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1296: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1297: ,p_project_title in varchar2 default hr_api.g_varchar2
1298: ,p_applicant_rank in number default hr_api.g_number

Line 1295: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2

1291: ,p_posting_content_id in number default hr_api.g_number
1292: ,p_placement_date_start in date default hr_api.g_date
1293: ,p_vendor_id in number default hr_api.g_number
1294: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1295: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1296: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1297: ,p_project_title in varchar2 default hr_api.g_varchar2
1298: ,p_applicant_rank in number default hr_api.g_number
1299: ,p_grade_ladder_pgm_id in number default hr_api.g_number

Line 1296: ,p_assignment_category in varchar2 default hr_api.g_varchar2

1292: ,p_placement_date_start in date default hr_api.g_date
1293: ,p_vendor_id in number default hr_api.g_number
1294: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1295: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1296: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1297: ,p_project_title in varchar2 default hr_api.g_varchar2
1298: ,p_applicant_rank in number default hr_api.g_number
1299: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1300: ,p_supervisor_assignment_id in number default hr_api.g_number

Line 1297: ,p_project_title in varchar2 default hr_api.g_varchar2

1293: ,p_vendor_id in number default hr_api.g_number
1294: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1295: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1296: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1297: ,p_project_title in varchar2 default hr_api.g_varchar2
1298: ,p_applicant_rank in number default hr_api.g_number
1299: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1300: ,p_supervisor_assignment_id in number default hr_api.g_number
1301: ,p_vendor_site_id in number default hr_api.g_number

Line 1298: ,p_applicant_rank in number default hr_api.g_number

1294: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1295: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1296: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1297: ,p_project_title in varchar2 default hr_api.g_varchar2
1298: ,p_applicant_rank in number default hr_api.g_number
1299: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1300: ,p_supervisor_assignment_id in number default hr_api.g_number
1301: ,p_vendor_site_id in number default hr_api.g_number
1302: ,p_po_header_id in number default hr_api.g_number

Line 1299: ,p_grade_ladder_pgm_id in number default hr_api.g_number

1295: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1296: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1297: ,p_project_title in varchar2 default hr_api.g_varchar2
1298: ,p_applicant_rank in number default hr_api.g_number
1299: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1300: ,p_supervisor_assignment_id in number default hr_api.g_number
1301: ,p_vendor_site_id in number default hr_api.g_number
1302: ,p_po_header_id in number default hr_api.g_number
1303: ,p_po_line_id in number default hr_api.g_number

Line 1300: ,p_supervisor_assignment_id in number default hr_api.g_number

1296: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1297: ,p_project_title in varchar2 default hr_api.g_varchar2
1298: ,p_applicant_rank in number default hr_api.g_number
1299: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1300: ,p_supervisor_assignment_id in number default hr_api.g_number
1301: ,p_vendor_site_id in number default hr_api.g_number
1302: ,p_po_header_id in number default hr_api.g_number
1303: ,p_po_line_id in number default hr_api.g_number
1304: ,p_projected_assignment_end in date default hr_api.g_date

Line 1301: ,p_vendor_site_id in number default hr_api.g_number

1297: ,p_project_title in varchar2 default hr_api.g_varchar2
1298: ,p_applicant_rank in number default hr_api.g_number
1299: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1300: ,p_supervisor_assignment_id in number default hr_api.g_number
1301: ,p_vendor_site_id in number default hr_api.g_number
1302: ,p_po_header_id in number default hr_api.g_number
1303: ,p_po_line_id in number default hr_api.g_number
1304: ,p_projected_assignment_end in date default hr_api.g_date
1305: ,p_payroll_id_updated out nocopy number

Line 1302: ,p_po_header_id in number default hr_api.g_number

1298: ,p_applicant_rank in number default hr_api.g_number
1299: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1300: ,p_supervisor_assignment_id in number default hr_api.g_number
1301: ,p_vendor_site_id in number default hr_api.g_number
1302: ,p_po_header_id in number default hr_api.g_number
1303: ,p_po_line_id in number default hr_api.g_number
1304: ,p_projected_assignment_end in date default hr_api.g_date
1305: ,p_payroll_id_updated out nocopy number
1306: ,p_validation_start_date out nocopy date

Line 1303: ,p_po_line_id in number default hr_api.g_number

1299: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1300: ,p_supervisor_assignment_id in number default hr_api.g_number
1301: ,p_vendor_site_id in number default hr_api.g_number
1302: ,p_po_header_id in number default hr_api.g_number
1303: ,p_po_line_id in number default hr_api.g_number
1304: ,p_projected_assignment_end in date default hr_api.g_date
1305: ,p_payroll_id_updated out nocopy number
1306: ,p_validation_start_date out nocopy date
1307: ,p_validation_end_date out nocopy date

Line 1304: ,p_projected_assignment_end in date default hr_api.g_date

1300: ,p_supervisor_assignment_id in number default hr_api.g_number
1301: ,p_vendor_site_id in number default hr_api.g_number
1302: ,p_po_header_id in number default hr_api.g_number
1303: ,p_po_line_id in number default hr_api.g_number
1304: ,p_projected_assignment_end in date default hr_api.g_date
1305: ,p_payroll_id_updated out nocopy number
1306: ,p_validation_start_date out nocopy date
1307: ,p_validation_end_date out nocopy date
1308: ,p_effective_date in date default hr_api.g_date

Line 1308: ,p_effective_date in date default hr_api.g_date

1304: ,p_projected_assignment_end in date default hr_api.g_date
1305: ,p_payroll_id_updated out nocopy number
1306: ,p_validation_start_date out nocopy date
1307: ,p_validation_end_date out nocopy date
1308: ,p_effective_date in date default hr_api.g_date
1309: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
1310: ,p_validate in number default hr_api.g_false_num
1311: ,p_offer_id in out nocopy number
1312: ,p_offer_status in varchar2 default null

Line 1309: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2

1305: ,p_payroll_id_updated out nocopy number
1306: ,p_validation_start_date out nocopy date
1307: ,p_validation_end_date out nocopy date
1308: ,p_effective_date in date default hr_api.g_date
1309: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
1310: ,p_validate in number default hr_api.g_false_num
1311: ,p_offer_id in out nocopy number
1312: ,p_offer_status in varchar2 default null
1313: ,p_return_status out nocopy varchar2

Line 1310: ,p_validate in number default hr_api.g_false_num

1306: ,p_validation_start_date out nocopy date
1307: ,p_validation_end_date out nocopy date
1308: ,p_effective_date in date default hr_api.g_date
1309: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
1310: ,p_validate in number default hr_api.g_false_num
1311: ,p_offer_id in out nocopy number
1312: ,p_offer_status in varchar2 default null
1313: ,p_return_status out nocopy varchar2
1314: ) is

Line 1351: hr_api.constant_to_boolean

1347: --
1348: -- Convert constant values to their corresponding boolean value
1349: --
1350: l_payroll_id_updated :=
1351: hr_api.constant_to_boolean
1352: (p_constant_value => p_payroll_id_updated);
1353: l_validate :=
1354: hr_api.constant_to_boolean
1355: (p_constant_value => p_validate);

Line 1354: hr_api.constant_to_boolean

1350: l_payroll_id_updated :=
1351: hr_api.constant_to_boolean
1352: (p_constant_value => p_payroll_id_updated);
1353: l_validate :=
1354: hr_api.constant_to_boolean
1355: (p_constant_value => p_validate);
1356: --
1357: -- Register Surrogate ID or user key values
1358: --

Line 1518: hr_api.boolean_to_constant

1514: --
1515: -- Convert API non-warning boolean parameter values
1516: --
1517: p_payroll_id_updated :=
1518: hr_api.boolean_to_constant
1519: (p_boolean_value => l_payroll_id_updated
1520: );
1521: --
1522: -- Derive the API return status value based on whether

Line 1585: (p_validate in number default hr_api.g_false_num

1581: -- ----------------------------------------------------------------------------
1582: -- |------------------------< delete_offer_assignment >-----------------------|
1583: -- ----------------------------------------------------------------------------
1584: PROCEDURE delete_offer_assignment
1585: (p_validate in number default hr_api.g_false_num
1586: ,p_effective_date in date default hr_api.g_date
1587: ,p_offer_assignment_id in number
1588: ,p_return_status out nocopy varchar2
1589: ) is

Line 1586: ,p_effective_date in date default hr_api.g_date

1582: -- |------------------------< delete_offer_assignment >-----------------------|
1583: -- ----------------------------------------------------------------------------
1584: PROCEDURE delete_offer_assignment
1585: (p_validate in number default hr_api.g_false_num
1586: ,p_effective_date in date default hr_api.g_date
1587: ,p_offer_assignment_id in number
1588: ,p_return_status out nocopy varchar2
1589: ) is
1590: --

Line 1615: hr_api.constant_to_boolean

1611: --
1612: -- Convert constant values to their corresponding boolean value
1613: --
1614: l_validate :=
1615: hr_api.constant_to_boolean
1616: (p_constant_value => p_validate);
1617: --
1618: -- Register Surrogate ID or user key values
1619: --

Line 1679: (p_validate in number default hr_api.g_false_num

1675: -- ----------------------------------------------------------------------------
1676: -- |--------------------------< upload_offer_letter >-------------------------|
1677: -- ----------------------------------------------------------------------------
1678: PROCEDURE upload_offer_letter
1679: (p_validate in number default hr_api.g_false_num
1680: ,p_offer_letter in BLOB
1681: ,p_offer_id in number
1682: ,p_object_version_number in number
1683: ,p_return_status out nocopy varchar2

Line 1710: hr_api.constant_to_boolean

1706: --
1707: -- Convert constant values to their corresponding boolean value
1708: --
1709: l_validate :=
1710: hr_api.constant_to_boolean
1711: (p_constant_value => p_validate);
1712: --
1713: -- Register Surrogate ID or user key values
1714: --

Line 1777: ,p_effective_end_date in date default hr_api.g_eot

1773: -- ----------------------------------------------------------------------------
1774: PROCEDURE is_run_benmgle_for_irec_reqd
1775: (p_assignment_id in number
1776: ,p_effective_start_date in date default trunc(sysdate)
1777: ,p_effective_end_date in date default hr_api.g_eot
1778: ,p_business_group_id in number
1779: ,p_recruiter_id in number default null
1780: ,p_grade_id in number default null
1781: ,p_position_id in number default null

Line 2179: ,p_effective_end_date in date default hr_api.g_eot

2175: -- ----------------------------------------------------------------------------
2176: PROCEDURE run_benmgle_for_irec
2177: (p_assignment_id in number
2178: ,p_effective_start_date in date default trunc(sysdate)
2179: ,p_effective_end_date in date default hr_api.g_eot
2180: ,p_business_group_id in number
2181: ,p_recruiter_id in number default null
2182: ,p_grade_id in number default null
2183: ,p_position_id in number default null

Line 2477: ,p_validate in number default hr_api.g_false_num

2473: procedure process_offers_api
2474: (
2475: p_document in CLOB
2476: ,p_return_status out nocopy VARCHAR2
2477: ,p_validate in number default hr_api.g_false_num
2478: ,p_effective_date in date default null
2479: )
2480: IS
2481: l_postState VARCHAR2(2);

Line 2624: ,p_validate in number default hr_api.g_false_num

2620: procedure process_asg_api
2621: (
2622: p_document in CLOB
2623: ,p_return_status out nocopy VARCHAR2
2624: ,p_validate in number default hr_api.g_false_num
2625: ,p_effective_date in date default null
2626: )
2627: IS
2628: l_postState VARCHAR2(2);

Line 2859: from hr_api_transactions hrt, irc_offers iro

2855: ,offer_status
2856: ,applicant_assignment_id
2857: ,expiry_date
2858: ,object_version_number
2859: from hr_api_transactions hrt, irc_offers iro
2860: where hrt.transaction_id = p_transaction_id
2861: and hrt.transaction_ref_id = iro.offer_id;
2862: --
2863: cursor csr_offer_history_details(p_offer_id number) is

Line 3025: l_applicant_assignment_id hr_api_transactions.assignment_id%TYPE := p_applicant_assignment_id;

3021: l_proc varchar2(72) := g_package || 'void_ben_records';
3022: l_void_per_in_ler_id ben_pil_assignment.per_in_ler_id%TYPE;
3023: l_restore_per_in_ler_id ben_pil_assignment.per_in_ler_id%TYPE := null;
3024: l_person_id per_all_assignments_f.person_id%TYPE := null;
3025: l_applicant_assignment_id hr_api_transactions.assignment_id%TYPE := p_applicant_assignment_id;
3026: --
3027: cursor csr_applicant_assignment_id is
3028: select assignment_id
3029: from hr_api_transactions

Line 3029: from hr_api_transactions

3025: l_applicant_assignment_id hr_api_transactions.assignment_id%TYPE := p_applicant_assignment_id;
3026: --
3027: cursor csr_applicant_assignment_id is
3028: select assignment_id
3029: from hr_api_transactions
3030: where transaction_id = p_transaction_id;
3031: --
3032: cursor csr_void_per_in_ler_id is
3033: select max(per_in_ler_id)