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 91: hr_api.constant_to_boolean

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

Line 214: (p_validate in number default hr_api.g_false_num

210: -- ----------------------------------------------------------------------------
211: -- |-----------------------------< update_offer >-----------------------------|
212: -- ----------------------------------------------------------------------------
213: PROCEDURE update_offer
214: (p_validate in number default hr_api.g_false_num
215: ,p_effective_date in date default hr_api.g_date
216: ,p_offer_status in varchar2 default hr_api.g_varchar2
217: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
218: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2

Line 215: ,p_effective_date in date default hr_api.g_date

211: -- |-----------------------------< update_offer >-----------------------------|
212: -- ----------------------------------------------------------------------------
213: PROCEDURE update_offer
214: (p_validate in number default hr_api.g_false_num
215: ,p_effective_date in date default hr_api.g_date
216: ,p_offer_status in varchar2 default hr_api.g_varchar2
217: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
218: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
219: ,p_respondent_id in number default hr_api.g_number

Line 216: ,p_offer_status in varchar2 default hr_api.g_varchar2

212: -- ----------------------------------------------------------------------------
213: PROCEDURE update_offer
214: (p_validate in number default hr_api.g_false_num
215: ,p_effective_date in date default hr_api.g_date
216: ,p_offer_status in varchar2 default hr_api.g_varchar2
217: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
218: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
219: ,p_respondent_id in number default hr_api.g_number
220: ,p_expiry_date in date default hr_api.g_date

Line 217: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2

213: PROCEDURE update_offer
214: (p_validate in number default hr_api.g_false_num
215: ,p_effective_date in date default hr_api.g_date
216: ,p_offer_status in varchar2 default hr_api.g_varchar2
217: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
218: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
219: ,p_respondent_id in number default hr_api.g_number
220: ,p_expiry_date in date default hr_api.g_date
221: ,p_proposed_start_date in date default hr_api.g_date

Line 218: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2

214: (p_validate in number default hr_api.g_false_num
215: ,p_effective_date in date default hr_api.g_date
216: ,p_offer_status in varchar2 default hr_api.g_varchar2
217: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
218: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
219: ,p_respondent_id in number default hr_api.g_number
220: ,p_expiry_date in date default hr_api.g_date
221: ,p_proposed_start_date in date default hr_api.g_date
222: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2

Line 219: ,p_respondent_id in number default hr_api.g_number

215: ,p_effective_date in date default hr_api.g_date
216: ,p_offer_status in varchar2 default hr_api.g_varchar2
217: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
218: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
219: ,p_respondent_id in number default hr_api.g_number
220: ,p_expiry_date in date default hr_api.g_date
221: ,p_proposed_start_date in date default hr_api.g_date
222: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
223: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2

Line 220: ,p_expiry_date in date default hr_api.g_date

216: ,p_offer_status in varchar2 default hr_api.g_varchar2
217: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
218: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
219: ,p_respondent_id in number default hr_api.g_number
220: ,p_expiry_date in date default hr_api.g_date
221: ,p_proposed_start_date in date default hr_api.g_date
222: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
223: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
224: ,p_offer_shipping_date in date default hr_api.g_date

Line 221: ,p_proposed_start_date in date default hr_api.g_date

217: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
218: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
219: ,p_respondent_id in number default hr_api.g_number
220: ,p_expiry_date in date default hr_api.g_date
221: ,p_proposed_start_date in date default hr_api.g_date
222: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
223: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
224: ,p_offer_shipping_date in date default hr_api.g_date
225: ,p_applicant_assignment_id in number default hr_api.g_number

Line 222: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2

218: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
219: ,p_respondent_id in number default hr_api.g_number
220: ,p_expiry_date in date default hr_api.g_date
221: ,p_proposed_start_date in date default hr_api.g_date
222: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
223: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
224: ,p_offer_shipping_date in date default hr_api.g_date
225: ,p_applicant_assignment_id in number default hr_api.g_number
226: ,p_offer_assignment_id in number default hr_api.g_number

Line 223: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2

219: ,p_respondent_id in number default hr_api.g_number
220: ,p_expiry_date in date default hr_api.g_date
221: ,p_proposed_start_date in date default hr_api.g_date
222: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
223: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
224: ,p_offer_shipping_date in date default hr_api.g_date
225: ,p_applicant_assignment_id in number default hr_api.g_number
226: ,p_offer_assignment_id in number default hr_api.g_number
227: ,p_address_id in number default hr_api.g_number

Line 224: ,p_offer_shipping_date in date default hr_api.g_date

220: ,p_expiry_date in date default hr_api.g_date
221: ,p_proposed_start_date in date default hr_api.g_date
222: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
223: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
224: ,p_offer_shipping_date in date default hr_api.g_date
225: ,p_applicant_assignment_id in number default hr_api.g_number
226: ,p_offer_assignment_id in number default hr_api.g_number
227: ,p_address_id in number default hr_api.g_number
228: ,p_template_id in number default hr_api.g_number

Line 225: ,p_applicant_assignment_id in number default hr_api.g_number

221: ,p_proposed_start_date in date default hr_api.g_date
222: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
223: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
224: ,p_offer_shipping_date in date default hr_api.g_date
225: ,p_applicant_assignment_id in number default hr_api.g_number
226: ,p_offer_assignment_id in number default hr_api.g_number
227: ,p_address_id in number default hr_api.g_number
228: ,p_template_id in number default hr_api.g_number
229: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2

Line 226: ,p_offer_assignment_id in number default hr_api.g_number

222: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
223: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
224: ,p_offer_shipping_date in date default hr_api.g_date
225: ,p_applicant_assignment_id in number default hr_api.g_number
226: ,p_offer_assignment_id in number default hr_api.g_number
227: ,p_address_id in number default hr_api.g_number
228: ,p_template_id in number default hr_api.g_number
229: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
230: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2

Line 227: ,p_address_id in number default hr_api.g_number

223: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
224: ,p_offer_shipping_date in date default hr_api.g_date
225: ,p_applicant_assignment_id in number default hr_api.g_number
226: ,p_offer_assignment_id in number default hr_api.g_number
227: ,p_address_id in number default hr_api.g_number
228: ,p_template_id in number default hr_api.g_number
229: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
230: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
231: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 228: ,p_template_id in number default hr_api.g_number

224: ,p_offer_shipping_date in date default hr_api.g_date
225: ,p_applicant_assignment_id in number default hr_api.g_number
226: ,p_offer_assignment_id in number default hr_api.g_number
227: ,p_address_id in number default hr_api.g_number
228: ,p_template_id in number default hr_api.g_number
229: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
230: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
231: ,p_attribute_category in varchar2 default hr_api.g_varchar2
232: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 229: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2

225: ,p_applicant_assignment_id in number default hr_api.g_number
226: ,p_offer_assignment_id in number default hr_api.g_number
227: ,p_address_id in number default hr_api.g_number
228: ,p_template_id in number default hr_api.g_number
229: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
230: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
231: ,p_attribute_category in varchar2 default hr_api.g_varchar2
232: ,p_attribute1 in varchar2 default hr_api.g_varchar2
233: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 230: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2

226: ,p_offer_assignment_id in number default hr_api.g_number
227: ,p_address_id in number default hr_api.g_number
228: ,p_template_id in number default hr_api.g_number
229: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
230: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
231: ,p_attribute_category in varchar2 default hr_api.g_varchar2
232: ,p_attribute1 in varchar2 default hr_api.g_varchar2
233: ,p_attribute2 in varchar2 default hr_api.g_varchar2
234: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 231: ,p_attribute_category in varchar2 default hr_api.g_varchar2

227: ,p_address_id in number default hr_api.g_number
228: ,p_template_id in number default hr_api.g_number
229: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
230: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
231: ,p_attribute_category in varchar2 default hr_api.g_varchar2
232: ,p_attribute1 in varchar2 default hr_api.g_varchar2
233: ,p_attribute2 in varchar2 default hr_api.g_varchar2
234: ,p_attribute3 in varchar2 default hr_api.g_varchar2
235: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 232: ,p_attribute1 in varchar2 default hr_api.g_varchar2

228: ,p_template_id in number default hr_api.g_number
229: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
230: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
231: ,p_attribute_category in varchar2 default hr_api.g_varchar2
232: ,p_attribute1 in varchar2 default hr_api.g_varchar2
233: ,p_attribute2 in varchar2 default hr_api.g_varchar2
234: ,p_attribute3 in varchar2 default hr_api.g_varchar2
235: ,p_attribute4 in varchar2 default hr_api.g_varchar2
236: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 233: ,p_attribute2 in varchar2 default hr_api.g_varchar2

229: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
230: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
231: ,p_attribute_category in varchar2 default hr_api.g_varchar2
232: ,p_attribute1 in varchar2 default hr_api.g_varchar2
233: ,p_attribute2 in varchar2 default hr_api.g_varchar2
234: ,p_attribute3 in varchar2 default hr_api.g_varchar2
235: ,p_attribute4 in varchar2 default hr_api.g_varchar2
236: ,p_attribute5 in varchar2 default hr_api.g_varchar2
237: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 234: ,p_attribute3 in varchar2 default hr_api.g_varchar2

230: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
231: ,p_attribute_category in varchar2 default hr_api.g_varchar2
232: ,p_attribute1 in varchar2 default hr_api.g_varchar2
233: ,p_attribute2 in varchar2 default hr_api.g_varchar2
234: ,p_attribute3 in varchar2 default hr_api.g_varchar2
235: ,p_attribute4 in varchar2 default hr_api.g_varchar2
236: ,p_attribute5 in varchar2 default hr_api.g_varchar2
237: ,p_attribute6 in varchar2 default hr_api.g_varchar2
238: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 235: ,p_attribute4 in varchar2 default hr_api.g_varchar2

231: ,p_attribute_category in varchar2 default hr_api.g_varchar2
232: ,p_attribute1 in varchar2 default hr_api.g_varchar2
233: ,p_attribute2 in varchar2 default hr_api.g_varchar2
234: ,p_attribute3 in varchar2 default hr_api.g_varchar2
235: ,p_attribute4 in varchar2 default hr_api.g_varchar2
236: ,p_attribute5 in varchar2 default hr_api.g_varchar2
237: ,p_attribute6 in varchar2 default hr_api.g_varchar2
238: ,p_attribute7 in varchar2 default hr_api.g_varchar2
239: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 236: ,p_attribute5 in varchar2 default hr_api.g_varchar2

232: ,p_attribute1 in varchar2 default hr_api.g_varchar2
233: ,p_attribute2 in varchar2 default hr_api.g_varchar2
234: ,p_attribute3 in varchar2 default hr_api.g_varchar2
235: ,p_attribute4 in varchar2 default hr_api.g_varchar2
236: ,p_attribute5 in varchar2 default hr_api.g_varchar2
237: ,p_attribute6 in varchar2 default hr_api.g_varchar2
238: ,p_attribute7 in varchar2 default hr_api.g_varchar2
239: ,p_attribute8 in varchar2 default hr_api.g_varchar2
240: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 237: ,p_attribute6 in varchar2 default hr_api.g_varchar2

233: ,p_attribute2 in varchar2 default hr_api.g_varchar2
234: ,p_attribute3 in varchar2 default hr_api.g_varchar2
235: ,p_attribute4 in varchar2 default hr_api.g_varchar2
236: ,p_attribute5 in varchar2 default hr_api.g_varchar2
237: ,p_attribute6 in varchar2 default hr_api.g_varchar2
238: ,p_attribute7 in varchar2 default hr_api.g_varchar2
239: ,p_attribute8 in varchar2 default hr_api.g_varchar2
240: ,p_attribute9 in varchar2 default hr_api.g_varchar2
241: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 238: ,p_attribute7 in varchar2 default hr_api.g_varchar2

234: ,p_attribute3 in varchar2 default hr_api.g_varchar2
235: ,p_attribute4 in varchar2 default hr_api.g_varchar2
236: ,p_attribute5 in varchar2 default hr_api.g_varchar2
237: ,p_attribute6 in varchar2 default hr_api.g_varchar2
238: ,p_attribute7 in varchar2 default hr_api.g_varchar2
239: ,p_attribute8 in varchar2 default hr_api.g_varchar2
240: ,p_attribute9 in varchar2 default hr_api.g_varchar2
241: ,p_attribute10 in varchar2 default hr_api.g_varchar2
242: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 239: ,p_attribute8 in varchar2 default hr_api.g_varchar2

235: ,p_attribute4 in varchar2 default hr_api.g_varchar2
236: ,p_attribute5 in varchar2 default hr_api.g_varchar2
237: ,p_attribute6 in varchar2 default hr_api.g_varchar2
238: ,p_attribute7 in varchar2 default hr_api.g_varchar2
239: ,p_attribute8 in varchar2 default hr_api.g_varchar2
240: ,p_attribute9 in varchar2 default hr_api.g_varchar2
241: ,p_attribute10 in varchar2 default hr_api.g_varchar2
242: ,p_attribute11 in varchar2 default hr_api.g_varchar2
243: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 240: ,p_attribute9 in varchar2 default hr_api.g_varchar2

236: ,p_attribute5 in varchar2 default hr_api.g_varchar2
237: ,p_attribute6 in varchar2 default hr_api.g_varchar2
238: ,p_attribute7 in varchar2 default hr_api.g_varchar2
239: ,p_attribute8 in varchar2 default hr_api.g_varchar2
240: ,p_attribute9 in varchar2 default hr_api.g_varchar2
241: ,p_attribute10 in varchar2 default hr_api.g_varchar2
242: ,p_attribute11 in varchar2 default hr_api.g_varchar2
243: ,p_attribute12 in varchar2 default hr_api.g_varchar2
244: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 241: ,p_attribute10 in varchar2 default hr_api.g_varchar2

237: ,p_attribute6 in varchar2 default hr_api.g_varchar2
238: ,p_attribute7 in varchar2 default hr_api.g_varchar2
239: ,p_attribute8 in varchar2 default hr_api.g_varchar2
240: ,p_attribute9 in varchar2 default hr_api.g_varchar2
241: ,p_attribute10 in varchar2 default hr_api.g_varchar2
242: ,p_attribute11 in varchar2 default hr_api.g_varchar2
243: ,p_attribute12 in varchar2 default hr_api.g_varchar2
244: ,p_attribute13 in varchar2 default hr_api.g_varchar2
245: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 242: ,p_attribute11 in varchar2 default hr_api.g_varchar2

238: ,p_attribute7 in varchar2 default hr_api.g_varchar2
239: ,p_attribute8 in varchar2 default hr_api.g_varchar2
240: ,p_attribute9 in varchar2 default hr_api.g_varchar2
241: ,p_attribute10 in varchar2 default hr_api.g_varchar2
242: ,p_attribute11 in varchar2 default hr_api.g_varchar2
243: ,p_attribute12 in varchar2 default hr_api.g_varchar2
244: ,p_attribute13 in varchar2 default hr_api.g_varchar2
245: ,p_attribute14 in varchar2 default hr_api.g_varchar2
246: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 243: ,p_attribute12 in varchar2 default hr_api.g_varchar2

239: ,p_attribute8 in varchar2 default hr_api.g_varchar2
240: ,p_attribute9 in varchar2 default hr_api.g_varchar2
241: ,p_attribute10 in varchar2 default hr_api.g_varchar2
242: ,p_attribute11 in varchar2 default hr_api.g_varchar2
243: ,p_attribute12 in varchar2 default hr_api.g_varchar2
244: ,p_attribute13 in varchar2 default hr_api.g_varchar2
245: ,p_attribute14 in varchar2 default hr_api.g_varchar2
246: ,p_attribute15 in varchar2 default hr_api.g_varchar2
247: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 244: ,p_attribute13 in varchar2 default hr_api.g_varchar2

240: ,p_attribute9 in varchar2 default hr_api.g_varchar2
241: ,p_attribute10 in varchar2 default hr_api.g_varchar2
242: ,p_attribute11 in varchar2 default hr_api.g_varchar2
243: ,p_attribute12 in varchar2 default hr_api.g_varchar2
244: ,p_attribute13 in varchar2 default hr_api.g_varchar2
245: ,p_attribute14 in varchar2 default hr_api.g_varchar2
246: ,p_attribute15 in varchar2 default hr_api.g_varchar2
247: ,p_attribute16 in varchar2 default hr_api.g_varchar2
248: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 245: ,p_attribute14 in varchar2 default hr_api.g_varchar2

241: ,p_attribute10 in varchar2 default hr_api.g_varchar2
242: ,p_attribute11 in varchar2 default hr_api.g_varchar2
243: ,p_attribute12 in varchar2 default hr_api.g_varchar2
244: ,p_attribute13 in varchar2 default hr_api.g_varchar2
245: ,p_attribute14 in varchar2 default hr_api.g_varchar2
246: ,p_attribute15 in varchar2 default hr_api.g_varchar2
247: ,p_attribute16 in varchar2 default hr_api.g_varchar2
248: ,p_attribute17 in varchar2 default hr_api.g_varchar2
249: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 246: ,p_attribute15 in varchar2 default hr_api.g_varchar2

242: ,p_attribute11 in varchar2 default hr_api.g_varchar2
243: ,p_attribute12 in varchar2 default hr_api.g_varchar2
244: ,p_attribute13 in varchar2 default hr_api.g_varchar2
245: ,p_attribute14 in varchar2 default hr_api.g_varchar2
246: ,p_attribute15 in varchar2 default hr_api.g_varchar2
247: ,p_attribute16 in varchar2 default hr_api.g_varchar2
248: ,p_attribute17 in varchar2 default hr_api.g_varchar2
249: ,p_attribute18 in varchar2 default hr_api.g_varchar2
250: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 247: ,p_attribute16 in varchar2 default hr_api.g_varchar2

243: ,p_attribute12 in varchar2 default hr_api.g_varchar2
244: ,p_attribute13 in varchar2 default hr_api.g_varchar2
245: ,p_attribute14 in varchar2 default hr_api.g_varchar2
246: ,p_attribute15 in varchar2 default hr_api.g_varchar2
247: ,p_attribute16 in varchar2 default hr_api.g_varchar2
248: ,p_attribute17 in varchar2 default hr_api.g_varchar2
249: ,p_attribute18 in varchar2 default hr_api.g_varchar2
250: ,p_attribute19 in varchar2 default hr_api.g_varchar2
251: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 248: ,p_attribute17 in varchar2 default hr_api.g_varchar2

244: ,p_attribute13 in varchar2 default hr_api.g_varchar2
245: ,p_attribute14 in varchar2 default hr_api.g_varchar2
246: ,p_attribute15 in varchar2 default hr_api.g_varchar2
247: ,p_attribute16 in varchar2 default hr_api.g_varchar2
248: ,p_attribute17 in varchar2 default hr_api.g_varchar2
249: ,p_attribute18 in varchar2 default hr_api.g_varchar2
250: ,p_attribute19 in varchar2 default hr_api.g_varchar2
251: ,p_attribute20 in varchar2 default hr_api.g_varchar2
252: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 249: ,p_attribute18 in varchar2 default hr_api.g_varchar2

245: ,p_attribute14 in varchar2 default hr_api.g_varchar2
246: ,p_attribute15 in varchar2 default hr_api.g_varchar2
247: ,p_attribute16 in varchar2 default hr_api.g_varchar2
248: ,p_attribute17 in varchar2 default hr_api.g_varchar2
249: ,p_attribute18 in varchar2 default hr_api.g_varchar2
250: ,p_attribute19 in varchar2 default hr_api.g_varchar2
251: ,p_attribute20 in varchar2 default hr_api.g_varchar2
252: ,p_attribute21 in varchar2 default hr_api.g_varchar2
253: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 250: ,p_attribute19 in varchar2 default hr_api.g_varchar2

246: ,p_attribute15 in varchar2 default hr_api.g_varchar2
247: ,p_attribute16 in varchar2 default hr_api.g_varchar2
248: ,p_attribute17 in varchar2 default hr_api.g_varchar2
249: ,p_attribute18 in varchar2 default hr_api.g_varchar2
250: ,p_attribute19 in varchar2 default hr_api.g_varchar2
251: ,p_attribute20 in varchar2 default hr_api.g_varchar2
252: ,p_attribute21 in varchar2 default hr_api.g_varchar2
253: ,p_attribute22 in varchar2 default hr_api.g_varchar2
254: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 251: ,p_attribute20 in varchar2 default hr_api.g_varchar2

247: ,p_attribute16 in varchar2 default hr_api.g_varchar2
248: ,p_attribute17 in varchar2 default hr_api.g_varchar2
249: ,p_attribute18 in varchar2 default hr_api.g_varchar2
250: ,p_attribute19 in varchar2 default hr_api.g_varchar2
251: ,p_attribute20 in varchar2 default hr_api.g_varchar2
252: ,p_attribute21 in varchar2 default hr_api.g_varchar2
253: ,p_attribute22 in varchar2 default hr_api.g_varchar2
254: ,p_attribute23 in varchar2 default hr_api.g_varchar2
255: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 252: ,p_attribute21 in varchar2 default hr_api.g_varchar2

248: ,p_attribute17 in varchar2 default hr_api.g_varchar2
249: ,p_attribute18 in varchar2 default hr_api.g_varchar2
250: ,p_attribute19 in varchar2 default hr_api.g_varchar2
251: ,p_attribute20 in varchar2 default hr_api.g_varchar2
252: ,p_attribute21 in varchar2 default hr_api.g_varchar2
253: ,p_attribute22 in varchar2 default hr_api.g_varchar2
254: ,p_attribute23 in varchar2 default hr_api.g_varchar2
255: ,p_attribute24 in varchar2 default hr_api.g_varchar2
256: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 253: ,p_attribute22 in varchar2 default hr_api.g_varchar2

249: ,p_attribute18 in varchar2 default hr_api.g_varchar2
250: ,p_attribute19 in varchar2 default hr_api.g_varchar2
251: ,p_attribute20 in varchar2 default hr_api.g_varchar2
252: ,p_attribute21 in varchar2 default hr_api.g_varchar2
253: ,p_attribute22 in varchar2 default hr_api.g_varchar2
254: ,p_attribute23 in varchar2 default hr_api.g_varchar2
255: ,p_attribute24 in varchar2 default hr_api.g_varchar2
256: ,p_attribute25 in varchar2 default hr_api.g_varchar2
257: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 254: ,p_attribute23 in varchar2 default hr_api.g_varchar2

250: ,p_attribute19 in varchar2 default hr_api.g_varchar2
251: ,p_attribute20 in varchar2 default hr_api.g_varchar2
252: ,p_attribute21 in varchar2 default hr_api.g_varchar2
253: ,p_attribute22 in varchar2 default hr_api.g_varchar2
254: ,p_attribute23 in varchar2 default hr_api.g_varchar2
255: ,p_attribute24 in varchar2 default hr_api.g_varchar2
256: ,p_attribute25 in varchar2 default hr_api.g_varchar2
257: ,p_attribute26 in varchar2 default hr_api.g_varchar2
258: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 255: ,p_attribute24 in varchar2 default hr_api.g_varchar2

251: ,p_attribute20 in varchar2 default hr_api.g_varchar2
252: ,p_attribute21 in varchar2 default hr_api.g_varchar2
253: ,p_attribute22 in varchar2 default hr_api.g_varchar2
254: ,p_attribute23 in varchar2 default hr_api.g_varchar2
255: ,p_attribute24 in varchar2 default hr_api.g_varchar2
256: ,p_attribute25 in varchar2 default hr_api.g_varchar2
257: ,p_attribute26 in varchar2 default hr_api.g_varchar2
258: ,p_attribute27 in varchar2 default hr_api.g_varchar2
259: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 256: ,p_attribute25 in varchar2 default hr_api.g_varchar2

252: ,p_attribute21 in varchar2 default hr_api.g_varchar2
253: ,p_attribute22 in varchar2 default hr_api.g_varchar2
254: ,p_attribute23 in varchar2 default hr_api.g_varchar2
255: ,p_attribute24 in varchar2 default hr_api.g_varchar2
256: ,p_attribute25 in varchar2 default hr_api.g_varchar2
257: ,p_attribute26 in varchar2 default hr_api.g_varchar2
258: ,p_attribute27 in varchar2 default hr_api.g_varchar2
259: ,p_attribute28 in varchar2 default hr_api.g_varchar2
260: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 257: ,p_attribute26 in varchar2 default hr_api.g_varchar2

253: ,p_attribute22 in varchar2 default hr_api.g_varchar2
254: ,p_attribute23 in varchar2 default hr_api.g_varchar2
255: ,p_attribute24 in varchar2 default hr_api.g_varchar2
256: ,p_attribute25 in varchar2 default hr_api.g_varchar2
257: ,p_attribute26 in varchar2 default hr_api.g_varchar2
258: ,p_attribute27 in varchar2 default hr_api.g_varchar2
259: ,p_attribute28 in varchar2 default hr_api.g_varchar2
260: ,p_attribute29 in varchar2 default hr_api.g_varchar2
261: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 258: ,p_attribute27 in varchar2 default hr_api.g_varchar2

254: ,p_attribute23 in varchar2 default hr_api.g_varchar2
255: ,p_attribute24 in varchar2 default hr_api.g_varchar2
256: ,p_attribute25 in varchar2 default hr_api.g_varchar2
257: ,p_attribute26 in varchar2 default hr_api.g_varchar2
258: ,p_attribute27 in varchar2 default hr_api.g_varchar2
259: ,p_attribute28 in varchar2 default hr_api.g_varchar2
260: ,p_attribute29 in varchar2 default hr_api.g_varchar2
261: ,p_attribute30 in varchar2 default hr_api.g_varchar2
262: ,p_change_reason in varchar2 default null

Line 259: ,p_attribute28 in varchar2 default hr_api.g_varchar2

255: ,p_attribute24 in varchar2 default hr_api.g_varchar2
256: ,p_attribute25 in varchar2 default hr_api.g_varchar2
257: ,p_attribute26 in varchar2 default hr_api.g_varchar2
258: ,p_attribute27 in varchar2 default hr_api.g_varchar2
259: ,p_attribute28 in varchar2 default hr_api.g_varchar2
260: ,p_attribute29 in varchar2 default hr_api.g_varchar2
261: ,p_attribute30 in varchar2 default hr_api.g_varchar2
262: ,p_change_reason in varchar2 default null
263: ,p_decline_reason in varchar2 default null

Line 260: ,p_attribute29 in varchar2 default hr_api.g_varchar2

256: ,p_attribute25 in varchar2 default hr_api.g_varchar2
257: ,p_attribute26 in varchar2 default hr_api.g_varchar2
258: ,p_attribute27 in varchar2 default hr_api.g_varchar2
259: ,p_attribute28 in varchar2 default hr_api.g_varchar2
260: ,p_attribute29 in varchar2 default hr_api.g_varchar2
261: ,p_attribute30 in varchar2 default hr_api.g_varchar2
262: ,p_change_reason in varchar2 default null
263: ,p_decline_reason in varchar2 default null
264: ,p_note_text in varchar2 default null

Line 261: ,p_attribute30 in varchar2 default hr_api.g_varchar2

257: ,p_attribute26 in varchar2 default hr_api.g_varchar2
258: ,p_attribute27 in varchar2 default hr_api.g_varchar2
259: ,p_attribute28 in varchar2 default hr_api.g_varchar2
260: ,p_attribute29 in varchar2 default hr_api.g_varchar2
261: ,p_attribute30 in varchar2 default hr_api.g_varchar2
262: ,p_change_reason in varchar2 default null
263: ,p_decline_reason in varchar2 default null
264: ,p_note_text in varchar2 default null
265: ,p_status_change_date in date default null

Line 300: hr_api.constant_to_boolean

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

Line 422: (p_validate in number default hr_api.g_false_num

418: -- ----------------------------------------------------------------------------
419: -- |-----------------------------< delete_offer >-----------------------------|
420: -- ----------------------------------------------------------------------------
421: PROCEDURE delete_offer
422: (p_validate in number default hr_api.g_false_num
423: ,p_object_version_number in number
424: ,p_offer_id in number
425: ,p_effective_date in date default hr_api.g_date
426: ,p_return_status out nocopy varchar2

Line 425: ,p_effective_date in date default hr_api.g_date

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

Line 453: hr_api.constant_to_boolean

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

Line 518: (p_validate in number default hr_api.g_false_num

514: -- ----------------------------------------------------------------------------
515: -- |------------------------------< close_offer >-----------------------------|
516: -- ----------------------------------------------------------------------------
517: PROCEDURE close_offer
518: (p_validate in number default hr_api.g_false_num
519: ,p_effective_date in date default hr_api.g_date
520: ,p_applicant_assignment_id in number default hr_api.g_number
521: ,p_offer_id in number default hr_api.g_number
522: ,p_respondent_id in number default hr_api.g_number

Line 519: ,p_effective_date in date default hr_api.g_date

515: -- |------------------------------< close_offer >-----------------------------|
516: -- ----------------------------------------------------------------------------
517: PROCEDURE close_offer
518: (p_validate in number default hr_api.g_false_num
519: ,p_effective_date in date default hr_api.g_date
520: ,p_applicant_assignment_id in number default hr_api.g_number
521: ,p_offer_id in number default hr_api.g_number
522: ,p_respondent_id in number default hr_api.g_number
523: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 520: ,p_applicant_assignment_id in number default hr_api.g_number

516: -- ----------------------------------------------------------------------------
517: PROCEDURE close_offer
518: (p_validate in number default hr_api.g_false_num
519: ,p_effective_date in date default hr_api.g_date
520: ,p_applicant_assignment_id in number default hr_api.g_number
521: ,p_offer_id in number default hr_api.g_number
522: ,p_respondent_id in number default hr_api.g_number
523: ,p_change_reason in varchar2 default hr_api.g_varchar2
524: ,p_decline_reason in varchar2 default hr_api.g_varchar2

Line 521: ,p_offer_id in number default hr_api.g_number

517: PROCEDURE close_offer
518: (p_validate in number default hr_api.g_false_num
519: ,p_effective_date in date default hr_api.g_date
520: ,p_applicant_assignment_id in number default hr_api.g_number
521: ,p_offer_id in number default hr_api.g_number
522: ,p_respondent_id in number default hr_api.g_number
523: ,p_change_reason in varchar2 default hr_api.g_varchar2
524: ,p_decline_reason in varchar2 default hr_api.g_varchar2
525: ,p_note_text in varchar2 default hr_api.g_varchar2

Line 522: ,p_respondent_id in number default hr_api.g_number

518: (p_validate in number default hr_api.g_false_num
519: ,p_effective_date in date default hr_api.g_date
520: ,p_applicant_assignment_id in number default hr_api.g_number
521: ,p_offer_id in number default hr_api.g_number
522: ,p_respondent_id in number default hr_api.g_number
523: ,p_change_reason in varchar2 default hr_api.g_varchar2
524: ,p_decline_reason in varchar2 default hr_api.g_varchar2
525: ,p_note_text in varchar2 default hr_api.g_varchar2
526: ,p_status_change_date in date default hr_api.g_date

Line 523: ,p_change_reason in varchar2 default hr_api.g_varchar2

519: ,p_effective_date in date default hr_api.g_date
520: ,p_applicant_assignment_id in number default hr_api.g_number
521: ,p_offer_id in number default hr_api.g_number
522: ,p_respondent_id in number default hr_api.g_number
523: ,p_change_reason in varchar2 default hr_api.g_varchar2
524: ,p_decline_reason in varchar2 default hr_api.g_varchar2
525: ,p_note_text in varchar2 default hr_api.g_varchar2
526: ,p_status_change_date in date default hr_api.g_date
527: ,p_return_status out nocopy varchar2

Line 524: ,p_decline_reason in varchar2 default hr_api.g_varchar2

520: ,p_applicant_assignment_id in number default hr_api.g_number
521: ,p_offer_id in number default hr_api.g_number
522: ,p_respondent_id in number default hr_api.g_number
523: ,p_change_reason in varchar2 default hr_api.g_varchar2
524: ,p_decline_reason in varchar2 default hr_api.g_varchar2
525: ,p_note_text in varchar2 default hr_api.g_varchar2
526: ,p_status_change_date in date default hr_api.g_date
527: ,p_return_status out nocopy varchar2
528: ) is

Line 525: ,p_note_text in varchar2 default hr_api.g_varchar2

521: ,p_offer_id in number default hr_api.g_number
522: ,p_respondent_id in number default hr_api.g_number
523: ,p_change_reason in varchar2 default hr_api.g_varchar2
524: ,p_decline_reason in varchar2 default hr_api.g_varchar2
525: ,p_note_text in varchar2 default hr_api.g_varchar2
526: ,p_status_change_date in date default hr_api.g_date
527: ,p_return_status out nocopy varchar2
528: ) is
529: --

Line 526: ,p_status_change_date in date default hr_api.g_date

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

Line 554: hr_api.constant_to_boolean

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

Line 624: (p_validate in number default hr_api.g_false_num

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

Line 625: ,p_effective_date in date default hr_api.g_date

621: -- |------------------------------< hold_offer >------------------------------|
622: -- ----------------------------------------------------------------------------
623: PROCEDURE hold_offer
624: (p_validate in number default hr_api.g_false_num
625: ,p_effective_date in date default hr_api.g_date
626: ,p_offer_id in number
627: ,p_respondent_id in number default hr_api.g_number
628: ,p_change_reason in varchar2 default hr_api.g_varchar2
629: ,p_status_change_date in date default hr_api.g_date

Line 627: ,p_respondent_id in number default hr_api.g_number

623: PROCEDURE hold_offer
624: (p_validate in number default hr_api.g_false_num
625: ,p_effective_date in date default hr_api.g_date
626: ,p_offer_id in number
627: ,p_respondent_id in number default hr_api.g_number
628: ,p_change_reason in varchar2 default hr_api.g_varchar2
629: ,p_status_change_date in date default hr_api.g_date
630: ,p_note_text in varchar2 default hr_api.g_varchar2
631: ,p_object_version_number in out nocopy number

Line 628: ,p_change_reason in varchar2 default hr_api.g_varchar2

624: (p_validate in number default hr_api.g_false_num
625: ,p_effective_date in date default hr_api.g_date
626: ,p_offer_id in number
627: ,p_respondent_id in number default hr_api.g_number
628: ,p_change_reason in varchar2 default hr_api.g_varchar2
629: ,p_status_change_date in date default hr_api.g_date
630: ,p_note_text in varchar2 default hr_api.g_varchar2
631: ,p_object_version_number in out nocopy number
632: ,p_return_status out nocopy varchar2

Line 629: ,p_status_change_date in date default hr_api.g_date

625: ,p_effective_date in date default hr_api.g_date
626: ,p_offer_id in number
627: ,p_respondent_id in number default hr_api.g_number
628: ,p_change_reason in varchar2 default hr_api.g_varchar2
629: ,p_status_change_date in date default hr_api.g_date
630: ,p_note_text in varchar2 default hr_api.g_varchar2
631: ,p_object_version_number in out nocopy number
632: ,p_return_status out nocopy varchar2
633: ) is

Line 630: ,p_note_text in varchar2 default hr_api.g_varchar2

626: ,p_offer_id in number
627: ,p_respondent_id in number default hr_api.g_number
628: ,p_change_reason in varchar2 default hr_api.g_varchar2
629: ,p_status_change_date in date default hr_api.g_date
630: ,p_note_text in varchar2 default hr_api.g_varchar2
631: ,p_object_version_number in out nocopy number
632: ,p_return_status out nocopy varchar2
633: ) is
634: --

Line 661: hr_api.constant_to_boolean

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

Line 732: (p_validate in number default hr_api.g_false_num

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

Line 733: ,p_effective_date in date default hr_api.g_date

729: -- |-----------------------------< release_offer >----------------------------|
730: -- ----------------------------------------------------------------------------
731: PROCEDURE release_offer
732: (p_validate in number default hr_api.g_false_num
733: ,p_effective_date in date default hr_api.g_date
734: ,p_offer_id in number
735: ,p_respondent_id in number default hr_api.g_number
736: ,p_change_reason in varchar2 default hr_api.g_varchar2
737: ,p_status_change_date in date default hr_api.g_date

Line 735: ,p_respondent_id in number default hr_api.g_number

731: PROCEDURE release_offer
732: (p_validate in number default hr_api.g_false_num
733: ,p_effective_date in date default hr_api.g_date
734: ,p_offer_id in number
735: ,p_respondent_id in number default hr_api.g_number
736: ,p_change_reason in varchar2 default hr_api.g_varchar2
737: ,p_status_change_date in date default hr_api.g_date
738: ,p_note_text in varchar2 default hr_api.g_varchar2
739: ,p_object_version_number in out nocopy number

Line 736: ,p_change_reason in varchar2 default hr_api.g_varchar2

732: (p_validate in number default hr_api.g_false_num
733: ,p_effective_date in date default hr_api.g_date
734: ,p_offer_id in number
735: ,p_respondent_id in number default hr_api.g_number
736: ,p_change_reason in varchar2 default hr_api.g_varchar2
737: ,p_status_change_date in date default hr_api.g_date
738: ,p_note_text in varchar2 default hr_api.g_varchar2
739: ,p_object_version_number in out nocopy number
740: ,p_return_status out nocopy varchar2

Line 737: ,p_status_change_date in date default hr_api.g_date

733: ,p_effective_date in date default hr_api.g_date
734: ,p_offer_id in number
735: ,p_respondent_id in number default hr_api.g_number
736: ,p_change_reason in varchar2 default hr_api.g_varchar2
737: ,p_status_change_date in date default hr_api.g_date
738: ,p_note_text in varchar2 default hr_api.g_varchar2
739: ,p_object_version_number in out nocopy number
740: ,p_return_status out nocopy varchar2
741: ) is

Line 738: ,p_note_text in varchar2 default hr_api.g_varchar2

734: ,p_offer_id in number
735: ,p_respondent_id in number default hr_api.g_number
736: ,p_change_reason in varchar2 default hr_api.g_varchar2
737: ,p_status_change_date in date default hr_api.g_date
738: ,p_note_text in varchar2 default hr_api.g_varchar2
739: ,p_object_version_number in out nocopy number
740: ,p_return_status out nocopy varchar2
741: ) is
742: --

Line 769: hr_api.constant_to_boolean

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

Line 930: ,p_validate in number default hr_api.g_false_num

926: ,p_title in varchar2 default null
927: ,p_validate_df_flex in number default null
928: ,p_object_version_number out nocopy number
929: ,p_effective_date in date
930: ,p_validate in number default hr_api.g_false_num
931: ,p_contract_id in number default null
932: ,p_establishment_id in number default null
933: ,p_collective_agreement_id in number default null
934: ,p_cagr_grade_def_id in number default null

Line 987: hr_api.constant_to_boolean

983: --
984: -- Convert constant values to their corresponding boolean value
985: --
986: l_validate_df_flex :=
987: hr_api.constant_to_boolean
988: (p_constant_value => p_validate_df_flex);
989: l_validate :=
990: hr_api.constant_to_boolean
991: (p_constant_value => p_validate);

Line 990: hr_api.constant_to_boolean

986: l_validate_df_flex :=
987: hr_api.constant_to_boolean
988: (p_constant_value => p_validate_df_flex);
989: l_validate :=
990: hr_api.constant_to_boolean
991: (p_constant_value => p_validate);
992: --
993: -- Register Surrogate ID or user key values
994: --

Line 1203: ,p_recruiter_id in number default hr_api.g_number

1199: (p_assignment_id in out nocopy number
1200: ,p_effective_start_date out nocopy date
1201: ,p_effective_end_date out nocopy date
1202: ,p_business_group_id out nocopy number
1203: ,p_recruiter_id in number default hr_api.g_number
1204: ,p_grade_id in number default hr_api.g_number
1205: ,p_position_id in number default hr_api.g_number
1206: ,p_job_id in number default hr_api.g_number
1207: ,p_assignment_status_type_id in number default hr_api.g_number

Line 1204: ,p_grade_id in number default hr_api.g_number

1200: ,p_effective_start_date out nocopy date
1201: ,p_effective_end_date out nocopy date
1202: ,p_business_group_id out nocopy number
1203: ,p_recruiter_id in number default hr_api.g_number
1204: ,p_grade_id in number default hr_api.g_number
1205: ,p_position_id in number default hr_api.g_number
1206: ,p_job_id in number default hr_api.g_number
1207: ,p_assignment_status_type_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number

Line 1205: ,p_position_id in number default hr_api.g_number

1201: ,p_effective_end_date out nocopy date
1202: ,p_business_group_id out nocopy number
1203: ,p_recruiter_id in number default hr_api.g_number
1204: ,p_grade_id in number default hr_api.g_number
1205: ,p_position_id in number default hr_api.g_number
1206: ,p_job_id in number default hr_api.g_number
1207: ,p_assignment_status_type_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number

Line 1206: ,p_job_id in number default hr_api.g_number

1202: ,p_business_group_id out nocopy number
1203: ,p_recruiter_id in number default hr_api.g_number
1204: ,p_grade_id in number default hr_api.g_number
1205: ,p_position_id in number default hr_api.g_number
1206: ,p_job_id in number default hr_api.g_number
1207: ,p_assignment_status_type_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_person_referred_by_id in number default hr_api.g_number

Line 1207: ,p_assignment_status_type_id in number default hr_api.g_number

1203: ,p_recruiter_id in number default hr_api.g_number
1204: ,p_grade_id in number default hr_api.g_number
1205: ,p_position_id in number default hr_api.g_number
1206: ,p_job_id in number default hr_api.g_number
1207: ,p_assignment_status_type_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_person_referred_by_id in number default hr_api.g_number
1211: ,p_supervisor_id in number default hr_api.g_number

Line 1208: ,p_payroll_id in number default hr_api.g_number

1204: ,p_grade_id in number default hr_api.g_number
1205: ,p_position_id in number default hr_api.g_number
1206: ,p_job_id in number default hr_api.g_number
1207: ,p_assignment_status_type_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_person_referred_by_id in number default hr_api.g_number
1211: ,p_supervisor_id in number default hr_api.g_number
1212: ,p_special_ceiling_step_id in number default hr_api.g_number

Line 1209: ,p_location_id in number default hr_api.g_number

1205: ,p_position_id in number default hr_api.g_number
1206: ,p_job_id in number default hr_api.g_number
1207: ,p_assignment_status_type_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_person_referred_by_id in number default hr_api.g_number
1211: ,p_supervisor_id in number default hr_api.g_number
1212: ,p_special_ceiling_step_id in number default hr_api.g_number
1213: ,p_recruitment_activity_id in number default hr_api.g_number

Line 1210: ,p_person_referred_by_id in number default hr_api.g_number

1206: ,p_job_id in number default hr_api.g_number
1207: ,p_assignment_status_type_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_person_referred_by_id in number default hr_api.g_number
1211: ,p_supervisor_id in number default hr_api.g_number
1212: ,p_special_ceiling_step_id in number default hr_api.g_number
1213: ,p_recruitment_activity_id in number default hr_api.g_number
1214: ,p_source_organization_id in number default hr_api.g_number

Line 1211: ,p_supervisor_id in number default hr_api.g_number

1207: ,p_assignment_status_type_id in number default hr_api.g_number
1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_person_referred_by_id in number default hr_api.g_number
1211: ,p_supervisor_id in number default hr_api.g_number
1212: ,p_special_ceiling_step_id in number default hr_api.g_number
1213: ,p_recruitment_activity_id in number default hr_api.g_number
1214: ,p_source_organization_id in number default hr_api.g_number
1215: ,p_organization_id in number default hr_api.g_number

Line 1212: ,p_special_ceiling_step_id in number default hr_api.g_number

1208: ,p_payroll_id in number default hr_api.g_number
1209: ,p_location_id in number default hr_api.g_number
1210: ,p_person_referred_by_id in number default hr_api.g_number
1211: ,p_supervisor_id in number default hr_api.g_number
1212: ,p_special_ceiling_step_id in number default hr_api.g_number
1213: ,p_recruitment_activity_id in number default hr_api.g_number
1214: ,p_source_organization_id in number default hr_api.g_number
1215: ,p_organization_id in number default hr_api.g_number
1216: ,p_people_group_id in number default hr_api.g_number

Line 1213: ,p_recruitment_activity_id in number default hr_api.g_number

1209: ,p_location_id in number default hr_api.g_number
1210: ,p_person_referred_by_id in number default hr_api.g_number
1211: ,p_supervisor_id in number default hr_api.g_number
1212: ,p_special_ceiling_step_id in number default hr_api.g_number
1213: ,p_recruitment_activity_id in number default hr_api.g_number
1214: ,p_source_organization_id in number default hr_api.g_number
1215: ,p_organization_id in number default hr_api.g_number
1216: ,p_people_group_id in number default hr_api.g_number
1217: ,p_soft_coding_keyflex_id in number default hr_api.g_number

Line 1214: ,p_source_organization_id in number default hr_api.g_number

1210: ,p_person_referred_by_id in number default hr_api.g_number
1211: ,p_supervisor_id in number default hr_api.g_number
1212: ,p_special_ceiling_step_id in number default hr_api.g_number
1213: ,p_recruitment_activity_id in number default hr_api.g_number
1214: ,p_source_organization_id in number default hr_api.g_number
1215: ,p_organization_id in number default hr_api.g_number
1216: ,p_people_group_id in number default hr_api.g_number
1217: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1218: ,p_vacancy_id in number default hr_api.g_number

Line 1215: ,p_organization_id in number default hr_api.g_number

1211: ,p_supervisor_id in number default hr_api.g_number
1212: ,p_special_ceiling_step_id in number default hr_api.g_number
1213: ,p_recruitment_activity_id in number default hr_api.g_number
1214: ,p_source_organization_id in number default hr_api.g_number
1215: ,p_organization_id in number default hr_api.g_number
1216: ,p_people_group_id in number default hr_api.g_number
1217: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1218: ,p_vacancy_id in number default hr_api.g_number
1219: ,p_pay_basis_id in number default hr_api.g_number

Line 1216: ,p_people_group_id in number default hr_api.g_number

1212: ,p_special_ceiling_step_id in number default hr_api.g_number
1213: ,p_recruitment_activity_id in number default hr_api.g_number
1214: ,p_source_organization_id in number default hr_api.g_number
1215: ,p_organization_id in number default hr_api.g_number
1216: ,p_people_group_id in number default hr_api.g_number
1217: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1218: ,p_vacancy_id in number default hr_api.g_number
1219: ,p_pay_basis_id in number default hr_api.g_number
1220: ,p_assignment_type in varchar2 default hr_api.g_varchar2

Line 1217: ,p_soft_coding_keyflex_id in number default hr_api.g_number

1213: ,p_recruitment_activity_id in number default hr_api.g_number
1214: ,p_source_organization_id in number default hr_api.g_number
1215: ,p_organization_id in number default hr_api.g_number
1216: ,p_people_group_id in number default hr_api.g_number
1217: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1218: ,p_vacancy_id in number default hr_api.g_number
1219: ,p_pay_basis_id in number default hr_api.g_number
1220: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1221: ,p_primary_flag in varchar2 default hr_api.g_varchar2

Line 1218: ,p_vacancy_id in number default hr_api.g_number

1214: ,p_source_organization_id in number default hr_api.g_number
1215: ,p_organization_id in number default hr_api.g_number
1216: ,p_people_group_id in number default hr_api.g_number
1217: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1218: ,p_vacancy_id in number default hr_api.g_number
1219: ,p_pay_basis_id in number default hr_api.g_number
1220: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1221: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1222: ,p_application_id in number default hr_api.g_number

Line 1219: ,p_pay_basis_id in number default hr_api.g_number

1215: ,p_organization_id in number default hr_api.g_number
1216: ,p_people_group_id in number default hr_api.g_number
1217: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1218: ,p_vacancy_id in number default hr_api.g_number
1219: ,p_pay_basis_id in number default hr_api.g_number
1220: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1221: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1222: ,p_application_id in number default hr_api.g_number
1223: ,p_assignment_number in varchar2 default hr_api.g_varchar2

Line 1220: ,p_assignment_type in varchar2 default hr_api.g_varchar2

1216: ,p_people_group_id in number default hr_api.g_number
1217: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1218: ,p_vacancy_id in number default hr_api.g_number
1219: ,p_pay_basis_id in number default hr_api.g_number
1220: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1221: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1222: ,p_application_id in number default hr_api.g_number
1223: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1224: ,p_change_reason in varchar2 default hr_api.g_varchar2

Line 1221: ,p_primary_flag in varchar2 default hr_api.g_varchar2

1217: ,p_soft_coding_keyflex_id in number default hr_api.g_number
1218: ,p_vacancy_id in number default hr_api.g_number
1219: ,p_pay_basis_id in number default hr_api.g_number
1220: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1221: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1222: ,p_application_id in number default hr_api.g_number
1223: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1224: ,p_change_reason in varchar2 default hr_api.g_varchar2
1225: ,p_comment_id out nocopy number

Line 1222: ,p_application_id in number default hr_api.g_number

1218: ,p_vacancy_id in number default hr_api.g_number
1219: ,p_pay_basis_id in number default hr_api.g_number
1220: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1221: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1222: ,p_application_id in number default hr_api.g_number
1223: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1224: ,p_change_reason in varchar2 default hr_api.g_varchar2
1225: ,p_comment_id out nocopy number
1226: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1223: ,p_assignment_number in varchar2 default hr_api.g_varchar2

1219: ,p_pay_basis_id in number default hr_api.g_number
1220: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1221: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1222: ,p_application_id in number default hr_api.g_number
1223: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1224: ,p_change_reason in varchar2 default hr_api.g_varchar2
1225: ,p_comment_id out nocopy number
1226: ,p_comments in varchar2 default hr_api.g_varchar2
1227: ,p_date_probation_end in date default hr_api.g_date

Line 1224: ,p_change_reason in varchar2 default hr_api.g_varchar2

1220: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1221: ,p_primary_flag in varchar2 default hr_api.g_varchar2
1222: ,p_application_id in number default hr_api.g_number
1223: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1224: ,p_change_reason in varchar2 default hr_api.g_varchar2
1225: ,p_comment_id out nocopy number
1226: ,p_comments in varchar2 default hr_api.g_varchar2
1227: ,p_date_probation_end in date default hr_api.g_date
1228: ,p_default_code_comb_id in number default hr_api.g_number

Line 1226: ,p_comments in varchar2 default hr_api.g_varchar2

1222: ,p_application_id in number default hr_api.g_number
1223: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1224: ,p_change_reason in varchar2 default hr_api.g_varchar2
1225: ,p_comment_id out nocopy number
1226: ,p_comments in varchar2 default hr_api.g_varchar2
1227: ,p_date_probation_end in date default hr_api.g_date
1228: ,p_default_code_comb_id in number default hr_api.g_number
1229: ,p_employment_category in varchar2 default hr_api.g_varchar2
1230: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 1227: ,p_date_probation_end in date default hr_api.g_date

1223: ,p_assignment_number in varchar2 default hr_api.g_varchar2
1224: ,p_change_reason in varchar2 default hr_api.g_varchar2
1225: ,p_comment_id out nocopy number
1226: ,p_comments in varchar2 default hr_api.g_varchar2
1227: ,p_date_probation_end in date default hr_api.g_date
1228: ,p_default_code_comb_id in number default hr_api.g_number
1229: ,p_employment_category in varchar2 default hr_api.g_varchar2
1230: ,p_frequency in varchar2 default hr_api.g_varchar2
1231: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

Line 1228: ,p_default_code_comb_id in number default hr_api.g_number

1224: ,p_change_reason in varchar2 default hr_api.g_varchar2
1225: ,p_comment_id out nocopy number
1226: ,p_comments in varchar2 default hr_api.g_varchar2
1227: ,p_date_probation_end in date default hr_api.g_date
1228: ,p_default_code_comb_id in number default hr_api.g_number
1229: ,p_employment_category in varchar2 default hr_api.g_varchar2
1230: ,p_frequency in varchar2 default hr_api.g_varchar2
1231: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1232: ,p_manager_flag in varchar2 default hr_api.g_varchar2

Line 1229: ,p_employment_category in varchar2 default hr_api.g_varchar2

1225: ,p_comment_id out nocopy number
1226: ,p_comments in varchar2 default hr_api.g_varchar2
1227: ,p_date_probation_end in date default hr_api.g_date
1228: ,p_default_code_comb_id in number default hr_api.g_number
1229: ,p_employment_category in varchar2 default hr_api.g_varchar2
1230: ,p_frequency in varchar2 default hr_api.g_varchar2
1231: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1232: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1233: ,p_normal_hours in number default hr_api.g_number

Line 1230: ,p_frequency in varchar2 default hr_api.g_varchar2

1226: ,p_comments in varchar2 default hr_api.g_varchar2
1227: ,p_date_probation_end in date default hr_api.g_date
1228: ,p_default_code_comb_id in number default hr_api.g_number
1229: ,p_employment_category in varchar2 default hr_api.g_varchar2
1230: ,p_frequency in varchar2 default hr_api.g_varchar2
1231: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1232: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1233: ,p_normal_hours in number default hr_api.g_number
1234: ,p_perf_review_period in number default hr_api.g_number

Line 1231: ,p_internal_address_line in varchar2 default hr_api.g_varchar2

1227: ,p_date_probation_end in date default hr_api.g_date
1228: ,p_default_code_comb_id in number default hr_api.g_number
1229: ,p_employment_category in varchar2 default hr_api.g_varchar2
1230: ,p_frequency in varchar2 default hr_api.g_varchar2
1231: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1232: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1233: ,p_normal_hours in number default hr_api.g_number
1234: ,p_perf_review_period in number default hr_api.g_number
1235: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 1232: ,p_manager_flag in varchar2 default hr_api.g_varchar2

1228: ,p_default_code_comb_id in number default hr_api.g_number
1229: ,p_employment_category in varchar2 default hr_api.g_varchar2
1230: ,p_frequency in varchar2 default hr_api.g_varchar2
1231: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1232: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1233: ,p_normal_hours in number default hr_api.g_number
1234: ,p_perf_review_period in number default hr_api.g_number
1235: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1236: ,p_period_of_service_id in number default hr_api.g_number

Line 1233: ,p_normal_hours in number default hr_api.g_number

1229: ,p_employment_category in varchar2 default hr_api.g_varchar2
1230: ,p_frequency in varchar2 default hr_api.g_varchar2
1231: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1232: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1233: ,p_normal_hours in number default hr_api.g_number
1234: ,p_perf_review_period in number default hr_api.g_number
1235: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1236: ,p_period_of_service_id in number default hr_api.g_number
1237: ,p_probation_period in number default hr_api.g_number

Line 1234: ,p_perf_review_period in number default hr_api.g_number

1230: ,p_frequency in varchar2 default hr_api.g_varchar2
1231: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1232: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1233: ,p_normal_hours in number default hr_api.g_number
1234: ,p_perf_review_period in number default hr_api.g_number
1235: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1236: ,p_period_of_service_id in number default hr_api.g_number
1237: ,p_probation_period in number default hr_api.g_number
1238: ,p_probation_unit in varchar2 default hr_api.g_varchar2

Line 1235: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2

1231: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1232: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1233: ,p_normal_hours in number default hr_api.g_number
1234: ,p_perf_review_period in number default hr_api.g_number
1235: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1236: ,p_period_of_service_id in number default hr_api.g_number
1237: ,p_probation_period in number default hr_api.g_number
1238: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1239: ,p_sal_review_period in number default hr_api.g_number

Line 1236: ,p_period_of_service_id in number default hr_api.g_number

1232: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1233: ,p_normal_hours in number default hr_api.g_number
1234: ,p_perf_review_period in number default hr_api.g_number
1235: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1236: ,p_period_of_service_id in number default hr_api.g_number
1237: ,p_probation_period in number default hr_api.g_number
1238: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1239: ,p_sal_review_period in number default hr_api.g_number
1240: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

Line 1237: ,p_probation_period in number default hr_api.g_number

1233: ,p_normal_hours in number default hr_api.g_number
1234: ,p_perf_review_period in number default hr_api.g_number
1235: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1236: ,p_period_of_service_id in number default hr_api.g_number
1237: ,p_probation_period in number default hr_api.g_number
1238: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1239: ,p_sal_review_period in number default hr_api.g_number
1240: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1241: ,p_set_of_books_id in number default hr_api.g_number

Line 1238: ,p_probation_unit in varchar2 default hr_api.g_varchar2

1234: ,p_perf_review_period in number default hr_api.g_number
1235: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1236: ,p_period_of_service_id in number default hr_api.g_number
1237: ,p_probation_period in number default hr_api.g_number
1238: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1239: ,p_sal_review_period in number default hr_api.g_number
1240: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1241: ,p_set_of_books_id in number default hr_api.g_number
1242: ,p_source_type in varchar2 default hr_api.g_varchar2

Line 1239: ,p_sal_review_period in number default hr_api.g_number

1235: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1236: ,p_period_of_service_id in number default hr_api.g_number
1237: ,p_probation_period in number default hr_api.g_number
1238: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1239: ,p_sal_review_period in number default hr_api.g_number
1240: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1241: ,p_set_of_books_id in number default hr_api.g_number
1242: ,p_source_type in varchar2 default hr_api.g_varchar2
1243: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

Line 1240: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2

1236: ,p_period_of_service_id in number default hr_api.g_number
1237: ,p_probation_period in number default hr_api.g_number
1238: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1239: ,p_sal_review_period in number default hr_api.g_number
1240: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1241: ,p_set_of_books_id in number default hr_api.g_number
1242: ,p_source_type in varchar2 default hr_api.g_varchar2
1243: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1244: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

Line 1241: ,p_set_of_books_id in number default hr_api.g_number

1237: ,p_probation_period in number default hr_api.g_number
1238: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1239: ,p_sal_review_period in number default hr_api.g_number
1240: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1241: ,p_set_of_books_id in number default hr_api.g_number
1242: ,p_source_type in varchar2 default hr_api.g_varchar2
1243: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1244: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1245: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

Line 1242: ,p_source_type in varchar2 default hr_api.g_varchar2

1238: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1239: ,p_sal_review_period in number default hr_api.g_number
1240: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1241: ,p_set_of_books_id in number default hr_api.g_number
1242: ,p_source_type in varchar2 default hr_api.g_varchar2
1243: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1244: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1245: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1246: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

Line 1243: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2

1239: ,p_sal_review_period in number default hr_api.g_number
1240: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1241: ,p_set_of_books_id in number default hr_api.g_number
1242: ,p_source_type in varchar2 default hr_api.g_varchar2
1243: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1244: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1245: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1246: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1247: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

Line 1244: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

1240: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1241: ,p_set_of_books_id in number default hr_api.g_number
1242: ,p_source_type in varchar2 default hr_api.g_varchar2
1243: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1244: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1245: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1246: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1247: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1248: ,p_request_id in number default hr_api.g_number

Line 1245: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2

1241: ,p_set_of_books_id in number default hr_api.g_number
1242: ,p_source_type in varchar2 default hr_api.g_varchar2
1243: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1244: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1245: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1246: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1247: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1248: ,p_request_id in number default hr_api.g_number
1249: ,p_program_application_id in number default hr_api.g_number

Line 1246: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2

1242: ,p_source_type in varchar2 default hr_api.g_varchar2
1243: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1244: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1245: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1246: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1247: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1248: ,p_request_id in number default hr_api.g_number
1249: ,p_program_application_id in number default hr_api.g_number
1250: ,p_program_id in number default hr_api.g_number

Line 1247: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2

1243: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1244: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1245: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1246: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1247: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1248: ,p_request_id in number default hr_api.g_number
1249: ,p_program_application_id in number default hr_api.g_number
1250: ,p_program_id in number default hr_api.g_number
1251: ,p_program_update_date in date default hr_api.g_date

Line 1248: ,p_request_id in number default hr_api.g_number

1244: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1245: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1246: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1247: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1248: ,p_request_id in number default hr_api.g_number
1249: ,p_program_application_id in number default hr_api.g_number
1250: ,p_program_id in number default hr_api.g_number
1251: ,p_program_update_date in date default hr_api.g_date
1252: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

Line 1249: ,p_program_application_id in number default hr_api.g_number

1245: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1246: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1247: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1248: ,p_request_id in number default hr_api.g_number
1249: ,p_program_application_id in number default hr_api.g_number
1250: ,p_program_id in number default hr_api.g_number
1251: ,p_program_update_date in date default hr_api.g_date
1252: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

Line 1250: ,p_program_id in number default hr_api.g_number

1246: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1247: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1248: ,p_request_id in number default hr_api.g_number
1249: ,p_program_application_id in number default hr_api.g_number
1250: ,p_program_id in number default hr_api.g_number
1251: ,p_program_update_date in date default hr_api.g_date
1252: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

Line 1251: ,p_program_update_date in date default hr_api.g_date

1247: ,p_hourly_salaried_code in varchar2 default hr_api.g_varchar2
1248: ,p_request_id in number default hr_api.g_number
1249: ,p_program_application_id in number default hr_api.g_number
1250: ,p_program_id in number default hr_api.g_number
1251: ,p_program_update_date in date default hr_api.g_date
1252: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

Line 1252: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2

1248: ,p_request_id in number default hr_api.g_number
1249: ,p_program_application_id in number default hr_api.g_number
1250: ,p_program_id in number default hr_api.g_number
1251: ,p_program_update_date in date default hr_api.g_date
1252: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

Line 1253: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2

1249: ,p_program_application_id in number default hr_api.g_number
1250: ,p_program_id in number default hr_api.g_number
1251: ,p_program_update_date in date default hr_api.g_date
1252: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

Line 1254: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2

1250: ,p_program_id in number default hr_api.g_number
1251: ,p_program_update_date in date default hr_api.g_date
1252: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

Line 1255: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2

1251: ,p_program_update_date in date default hr_api.g_date
1252: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

Line 1256: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2

1252: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1253: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

Line 1257: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2

1253: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1254: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

Line 1258: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2

1254: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1255: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

Line 1259: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2

1255: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1256: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

Line 1260: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2

1256: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1257: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

Line 1261: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2

1257: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1258: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

Line 1262: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2

1258: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1259: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

Line 1263: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2

1259: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1260: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

Line 1264: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2

1260: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1261: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

Line 1265: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2

1261: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1262: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

Line 1266: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2

1262: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1263: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

Line 1267: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2

1263: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1264: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

Line 1268: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2

1264: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1265: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

Line 1269: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2

1265: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1266: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

Line 1270: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2

1266: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1267: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

Line 1271: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2

1267: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1268: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

Line 1272: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2

1268: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1269: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

Line 1273: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2

1269: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1270: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

Line 1274: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2

1270: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1271: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

Line 1275: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2

1271: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1272: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1279: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

Line 1276: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2

1272: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1273: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1279: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1280: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

Line 1277: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2

1273: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1274: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1279: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1280: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1281: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

Line 1278: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2

1274: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1275: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1279: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1280: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1281: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1282: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

Line 1279: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2

1275: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1276: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1279: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1280: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1281: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1282: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1283: ,p_title in varchar2 default hr_api.g_varchar2

Line 1280: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2

1276: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1277: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1279: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1280: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1281: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1282: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1283: ,p_title in varchar2 default hr_api.g_varchar2
1284: ,p_contract_id in number default hr_api.g_number

Line 1281: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2

1277: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1278: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1279: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1280: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1281: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1282: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1283: ,p_title in varchar2 default hr_api.g_varchar2
1284: ,p_contract_id in number default hr_api.g_number
1285: ,p_establishment_id in number default hr_api.g_number

Line 1282: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2

1278: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1279: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1280: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1281: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1282: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1283: ,p_title in varchar2 default hr_api.g_varchar2
1284: ,p_contract_id in number default hr_api.g_number
1285: ,p_establishment_id in number default hr_api.g_number
1286: ,p_collective_agreement_id in number default hr_api.g_number

Line 1283: ,p_title in varchar2 default hr_api.g_varchar2

1279: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1280: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1281: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1282: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1283: ,p_title in varchar2 default hr_api.g_varchar2
1284: ,p_contract_id in number default hr_api.g_number
1285: ,p_establishment_id in number default hr_api.g_number
1286: ,p_collective_agreement_id in number default hr_api.g_number
1287: ,p_cagr_grade_def_id in number default hr_api.g_number

Line 1284: ,p_contract_id in number default hr_api.g_number

1280: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1281: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1282: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1283: ,p_title in varchar2 default hr_api.g_varchar2
1284: ,p_contract_id in number default hr_api.g_number
1285: ,p_establishment_id in number default hr_api.g_number
1286: ,p_collective_agreement_id in number default hr_api.g_number
1287: ,p_cagr_grade_def_id in number default hr_api.g_number
1288: ,p_cagr_id_flex_num in number default hr_api.g_number

Line 1285: ,p_establishment_id in number default hr_api.g_number

1281: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1282: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1283: ,p_title in varchar2 default hr_api.g_varchar2
1284: ,p_contract_id in number default hr_api.g_number
1285: ,p_establishment_id in number default hr_api.g_number
1286: ,p_collective_agreement_id in number default hr_api.g_number
1287: ,p_cagr_grade_def_id in number default hr_api.g_number
1288: ,p_cagr_id_flex_num in number default hr_api.g_number
1289: ,p_asg_object_version_number in out nocopy number

Line 1286: ,p_collective_agreement_id in number default hr_api.g_number

1282: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1283: ,p_title in varchar2 default hr_api.g_varchar2
1284: ,p_contract_id in number default hr_api.g_number
1285: ,p_establishment_id in number default hr_api.g_number
1286: ,p_collective_agreement_id in number default hr_api.g_number
1287: ,p_cagr_grade_def_id in number default hr_api.g_number
1288: ,p_cagr_id_flex_num in number default hr_api.g_number
1289: ,p_asg_object_version_number in out nocopy number
1290: ,p_notice_period in number default hr_api.g_number

Line 1287: ,p_cagr_grade_def_id in number default hr_api.g_number

1283: ,p_title in varchar2 default hr_api.g_varchar2
1284: ,p_contract_id in number default hr_api.g_number
1285: ,p_establishment_id in number default hr_api.g_number
1286: ,p_collective_agreement_id in number default hr_api.g_number
1287: ,p_cagr_grade_def_id in number default hr_api.g_number
1288: ,p_cagr_id_flex_num in number default hr_api.g_number
1289: ,p_asg_object_version_number in out nocopy number
1290: ,p_notice_period in number default hr_api.g_number
1291: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

Line 1288: ,p_cagr_id_flex_num in number default hr_api.g_number

1284: ,p_contract_id in number default hr_api.g_number
1285: ,p_establishment_id in number default hr_api.g_number
1286: ,p_collective_agreement_id in number default hr_api.g_number
1287: ,p_cagr_grade_def_id in number default hr_api.g_number
1288: ,p_cagr_id_flex_num in number default hr_api.g_number
1289: ,p_asg_object_version_number in out nocopy number
1290: ,p_notice_period in number default hr_api.g_number
1291: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1292: ,p_employee_category in varchar2 default hr_api.g_varchar2

Line 1290: ,p_notice_period in number default hr_api.g_number

1286: ,p_collective_agreement_id in number default hr_api.g_number
1287: ,p_cagr_grade_def_id in number default hr_api.g_number
1288: ,p_cagr_id_flex_num in number default hr_api.g_number
1289: ,p_asg_object_version_number in out nocopy number
1290: ,p_notice_period in number default hr_api.g_number
1291: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1292: ,p_employee_category in varchar2 default hr_api.g_varchar2
1293: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1294: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

Line 1291: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2

1287: ,p_cagr_grade_def_id in number default hr_api.g_number
1288: ,p_cagr_id_flex_num in number default hr_api.g_number
1289: ,p_asg_object_version_number in out nocopy number
1290: ,p_notice_period in number default hr_api.g_number
1291: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1292: ,p_employee_category in varchar2 default hr_api.g_varchar2
1293: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1294: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1295: ,p_posting_content_id in number default hr_api.g_number

Line 1292: ,p_employee_category in varchar2 default hr_api.g_varchar2

1288: ,p_cagr_id_flex_num in number default hr_api.g_number
1289: ,p_asg_object_version_number in out nocopy number
1290: ,p_notice_period in number default hr_api.g_number
1291: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1292: ,p_employee_category in varchar2 default hr_api.g_varchar2
1293: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1294: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1295: ,p_posting_content_id in number default hr_api.g_number
1296: ,p_placement_date_start in date default hr_api.g_date

Line 1293: ,p_work_at_home in varchar2 default hr_api.g_varchar2

1289: ,p_asg_object_version_number in out nocopy number
1290: ,p_notice_period in number default hr_api.g_number
1291: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1292: ,p_employee_category in varchar2 default hr_api.g_varchar2
1293: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1294: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1295: ,p_posting_content_id in number default hr_api.g_number
1296: ,p_placement_date_start in date default hr_api.g_date
1297: ,p_vendor_id in number default hr_api.g_number

Line 1294: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

1290: ,p_notice_period in number default hr_api.g_number
1291: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1292: ,p_employee_category in varchar2 default hr_api.g_varchar2
1293: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1294: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1295: ,p_posting_content_id in number default hr_api.g_number
1296: ,p_placement_date_start in date default hr_api.g_date
1297: ,p_vendor_id in number default hr_api.g_number
1298: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2

Line 1295: ,p_posting_content_id in number default hr_api.g_number

1291: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1292: ,p_employee_category in varchar2 default hr_api.g_varchar2
1293: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1294: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1295: ,p_posting_content_id in number default hr_api.g_number
1296: ,p_placement_date_start in date default hr_api.g_date
1297: ,p_vendor_id in number default hr_api.g_number
1298: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1299: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2

Line 1296: ,p_placement_date_start in date default hr_api.g_date

1292: ,p_employee_category in varchar2 default hr_api.g_varchar2
1293: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1294: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1295: ,p_posting_content_id in number default hr_api.g_number
1296: ,p_placement_date_start in date default hr_api.g_date
1297: ,p_vendor_id in number default hr_api.g_number
1298: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1299: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1300: ,p_assignment_category in varchar2 default hr_api.g_varchar2

Line 1297: ,p_vendor_id in number default hr_api.g_number

1293: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1294: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1295: ,p_posting_content_id in number default hr_api.g_number
1296: ,p_placement_date_start in date default hr_api.g_date
1297: ,p_vendor_id in number default hr_api.g_number
1298: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1299: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1300: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1301: ,p_project_title in varchar2 default hr_api.g_varchar2

Line 1298: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2

1294: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1295: ,p_posting_content_id in number default hr_api.g_number
1296: ,p_placement_date_start in date default hr_api.g_date
1297: ,p_vendor_id in number default hr_api.g_number
1298: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1299: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1300: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1301: ,p_project_title in varchar2 default hr_api.g_varchar2
1302: ,p_applicant_rank in number default hr_api.g_number

Line 1299: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2

1295: ,p_posting_content_id in number default hr_api.g_number
1296: ,p_placement_date_start in date default hr_api.g_date
1297: ,p_vendor_id in number default hr_api.g_number
1298: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1299: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1300: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1301: ,p_project_title in varchar2 default hr_api.g_varchar2
1302: ,p_applicant_rank in number default hr_api.g_number
1303: ,p_grade_ladder_pgm_id in number default hr_api.g_number

Line 1300: ,p_assignment_category in varchar2 default hr_api.g_varchar2

1296: ,p_placement_date_start in date default hr_api.g_date
1297: ,p_vendor_id in number default hr_api.g_number
1298: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1299: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1300: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1301: ,p_project_title in varchar2 default hr_api.g_varchar2
1302: ,p_applicant_rank in number default hr_api.g_number
1303: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1304: ,p_supervisor_assignment_id in number default hr_api.g_number

Line 1301: ,p_project_title in varchar2 default hr_api.g_varchar2

1297: ,p_vendor_id in number default hr_api.g_number
1298: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1299: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1300: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1301: ,p_project_title in varchar2 default hr_api.g_varchar2
1302: ,p_applicant_rank in number default hr_api.g_number
1303: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1304: ,p_supervisor_assignment_id in number default hr_api.g_number
1305: ,p_vendor_site_id in number default hr_api.g_number

Line 1302: ,p_applicant_rank in number default hr_api.g_number

1298: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1299: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1300: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1301: ,p_project_title in varchar2 default hr_api.g_varchar2
1302: ,p_applicant_rank in number default hr_api.g_number
1303: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1304: ,p_supervisor_assignment_id in number default hr_api.g_number
1305: ,p_vendor_site_id in number default hr_api.g_number
1306: ,p_po_header_id in number default hr_api.g_number

Line 1303: ,p_grade_ladder_pgm_id in number default hr_api.g_number

1299: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1300: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1301: ,p_project_title in varchar2 default hr_api.g_varchar2
1302: ,p_applicant_rank in number default hr_api.g_number
1303: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1304: ,p_supervisor_assignment_id in number default hr_api.g_number
1305: ,p_vendor_site_id in number default hr_api.g_number
1306: ,p_po_header_id in number default hr_api.g_number
1307: ,p_po_line_id in number default hr_api.g_number

Line 1304: ,p_supervisor_assignment_id in number default hr_api.g_number

1300: ,p_assignment_category in varchar2 default hr_api.g_varchar2
1301: ,p_project_title in varchar2 default hr_api.g_varchar2
1302: ,p_applicant_rank in number default hr_api.g_number
1303: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1304: ,p_supervisor_assignment_id in number default hr_api.g_number
1305: ,p_vendor_site_id in number default hr_api.g_number
1306: ,p_po_header_id in number default hr_api.g_number
1307: ,p_po_line_id in number default hr_api.g_number
1308: ,p_projected_assignment_end in date default hr_api.g_date

Line 1305: ,p_vendor_site_id in number default hr_api.g_number

1301: ,p_project_title in varchar2 default hr_api.g_varchar2
1302: ,p_applicant_rank in number default hr_api.g_number
1303: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1304: ,p_supervisor_assignment_id in number default hr_api.g_number
1305: ,p_vendor_site_id in number default hr_api.g_number
1306: ,p_po_header_id in number default hr_api.g_number
1307: ,p_po_line_id in number default hr_api.g_number
1308: ,p_projected_assignment_end in date default hr_api.g_date
1309: ,p_payroll_id_updated out nocopy number

Line 1306: ,p_po_header_id in number default hr_api.g_number

1302: ,p_applicant_rank in number default hr_api.g_number
1303: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1304: ,p_supervisor_assignment_id in number default hr_api.g_number
1305: ,p_vendor_site_id in number default hr_api.g_number
1306: ,p_po_header_id in number default hr_api.g_number
1307: ,p_po_line_id in number default hr_api.g_number
1308: ,p_projected_assignment_end in date default hr_api.g_date
1309: ,p_payroll_id_updated out nocopy number
1310: ,p_validation_start_date out nocopy date

Line 1307: ,p_po_line_id in number default hr_api.g_number

1303: ,p_grade_ladder_pgm_id in number default hr_api.g_number
1304: ,p_supervisor_assignment_id in number default hr_api.g_number
1305: ,p_vendor_site_id in number default hr_api.g_number
1306: ,p_po_header_id in number default hr_api.g_number
1307: ,p_po_line_id in number default hr_api.g_number
1308: ,p_projected_assignment_end in date default hr_api.g_date
1309: ,p_payroll_id_updated out nocopy number
1310: ,p_validation_start_date out nocopy date
1311: ,p_validation_end_date out nocopy date

Line 1308: ,p_projected_assignment_end in date default hr_api.g_date

1304: ,p_supervisor_assignment_id in number default hr_api.g_number
1305: ,p_vendor_site_id in number default hr_api.g_number
1306: ,p_po_header_id in number default hr_api.g_number
1307: ,p_po_line_id in number default hr_api.g_number
1308: ,p_projected_assignment_end in date default hr_api.g_date
1309: ,p_payroll_id_updated out nocopy number
1310: ,p_validation_start_date out nocopy date
1311: ,p_validation_end_date out nocopy date
1312: ,p_effective_date in date default hr_api.g_date

Line 1312: ,p_effective_date in date default hr_api.g_date

1308: ,p_projected_assignment_end in date default hr_api.g_date
1309: ,p_payroll_id_updated out nocopy number
1310: ,p_validation_start_date out nocopy date
1311: ,p_validation_end_date out nocopy date
1312: ,p_effective_date in date default hr_api.g_date
1313: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
1314: ,p_validate in number default hr_api.g_false_num
1315: ,p_offer_id in out nocopy number
1316: ,p_offer_status in varchar2 default null

Line 1313: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2

1309: ,p_payroll_id_updated out nocopy number
1310: ,p_validation_start_date out nocopy date
1311: ,p_validation_end_date out nocopy date
1312: ,p_effective_date in date default hr_api.g_date
1313: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
1314: ,p_validate in number default hr_api.g_false_num
1315: ,p_offer_id in out nocopy number
1316: ,p_offer_status in varchar2 default null
1317: ,p_return_status out nocopy varchar2

Line 1314: ,p_validate in number default hr_api.g_false_num

1310: ,p_validation_start_date out nocopy date
1311: ,p_validation_end_date out nocopy date
1312: ,p_effective_date in date default hr_api.g_date
1313: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
1314: ,p_validate in number default hr_api.g_false_num
1315: ,p_offer_id in out nocopy number
1316: ,p_offer_status in varchar2 default null
1317: ,p_return_status out nocopy varchar2
1318: ) is

Line 1355: hr_api.constant_to_boolean

1351: --
1352: -- Convert constant values to their corresponding boolean value
1353: --
1354: l_payroll_id_updated :=
1355: hr_api.constant_to_boolean
1356: (p_constant_value => p_payroll_id_updated);
1357: l_validate :=
1358: hr_api.constant_to_boolean
1359: (p_constant_value => p_validate);

Line 1358: hr_api.constant_to_boolean

1354: l_payroll_id_updated :=
1355: hr_api.constant_to_boolean
1356: (p_constant_value => p_payroll_id_updated);
1357: l_validate :=
1358: hr_api.constant_to_boolean
1359: (p_constant_value => p_validate);
1360: --
1361: -- Register Surrogate ID or user key values
1362: --

Line 1522: hr_api.boolean_to_constant

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

Line 1589: (p_validate in number default hr_api.g_false_num

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

Line 1590: ,p_effective_date in date default hr_api.g_date

1586: -- |------------------------< delete_offer_assignment >-----------------------|
1587: -- ----------------------------------------------------------------------------
1588: PROCEDURE delete_offer_assignment
1589: (p_validate in number default hr_api.g_false_num
1590: ,p_effective_date in date default hr_api.g_date
1591: ,p_offer_assignment_id in number
1592: ,p_return_status out nocopy varchar2
1593: ) is
1594: --

Line 1619: hr_api.constant_to_boolean

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

Line 1683: (p_validate in number default hr_api.g_false_num

1679: -- ----------------------------------------------------------------------------
1680: -- |--------------------------< upload_offer_letter >-------------------------|
1681: -- ----------------------------------------------------------------------------
1682: PROCEDURE upload_offer_letter
1683: (p_validate in number default hr_api.g_false_num
1684: ,p_offer_letter in BLOB
1685: ,p_offer_id in number
1686: ,p_object_version_number in number
1687: ,p_return_status out nocopy varchar2

Line 1714: hr_api.constant_to_boolean

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

Line 1781: ,p_effective_end_date in date default hr_api.g_eot

1777: -- ----------------------------------------------------------------------------
1778: PROCEDURE is_run_benmgle_for_irec_reqd
1779: (p_assignment_id in number
1780: ,p_effective_start_date in date default trunc(sysdate)
1781: ,p_effective_end_date in date default hr_api.g_eot
1782: ,p_business_group_id in number
1783: ,p_recruiter_id in number default null
1784: ,p_grade_id in number default null
1785: ,p_position_id in number default null

Line 2183: ,p_effective_end_date in date default hr_api.g_eot

2179: -- ----------------------------------------------------------------------------
2180: PROCEDURE run_benmgle_for_irec
2181: (p_assignment_id in number
2182: ,p_effective_start_date in date default trunc(sysdate)
2183: ,p_effective_end_date in date default hr_api.g_eot
2184: ,p_business_group_id in number
2185: ,p_recruiter_id in number default null
2186: ,p_grade_id in number default null
2187: ,p_position_id in number default null

Line 2481: ,p_validate in number default hr_api.g_false_num

2477: procedure process_offers_api
2478: (
2479: p_document in CLOB
2480: ,p_return_status out nocopy VARCHAR2
2481: ,p_validate in number default hr_api.g_false_num
2482: ,p_effective_date in date default null
2483: )
2484: IS
2485: l_postState VARCHAR2(2);

Line 2628: ,p_validate in number default hr_api.g_false_num

2624: procedure process_asg_api
2625: (
2626: p_document in CLOB
2627: ,p_return_status out nocopy VARCHAR2
2628: ,p_validate in number default hr_api.g_false_num
2629: ,p_effective_date in date default null
2630: )
2631: IS
2632: l_postState VARCHAR2(2);

Line 2863: from hr_api_transactions hrt, irc_offers iro

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

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

3044: l_proc varchar2(72) := g_package || 'void_ben_records';
3045: l_void_per_in_ler_id ben_pil_assignment.per_in_ler_id%TYPE;
3046: l_restore_per_in_ler_id ben_pil_assignment.per_in_ler_id%TYPE := null;
3047: l_person_id per_all_assignments_f.person_id%TYPE := null;
3048: l_applicant_assignment_id hr_api_transactions.assignment_id%TYPE := p_applicant_assignment_id;
3049: --
3050: cursor csr_applicant_assignment_id is
3051: select assignment_id
3052: from hr_api_transactions

Line 3052: from hr_api_transactions

3048: l_applicant_assignment_id hr_api_transactions.assignment_id%TYPE := p_applicant_assignment_id;
3049: --
3050: cursor csr_applicant_assignment_id is
3051: select assignment_id
3052: from hr_api_transactions
3053: where transaction_id = p_transaction_id;
3054: --
3055: cursor csr_void_per_in_ler_id is
3056: select max(per_in_ler_id)