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.HR_SIT_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

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

Line 109: hr_api.constant_to_boolean

105: --
106: -- Convert constant values to their corresponding boolean value
107: --
108: l_validate :=
109: hr_api.constant_to_boolean
110: (p_constant_value => p_validate);
111: --
112: -- Register Surrogate ID or user key values
113: --

Line 244: (p_validate in number default hr_api.g_false_num

240: -- ----------------------------------------------------------------------------
241: -- |------------------------------< delete_sit >------------------------------|
242: -- ----------------------------------------------------------------------------
243: PROCEDURE delete_sit
244: (p_validate in number default hr_api.g_false_num
245: ,p_person_analysis_id in number
246: ,p_pea_object_version_number in number
247: ,p_return_status out nocopy varchar2
248: ) is

Line 274: hr_api.constant_to_boolean

270: --
271: -- Convert constant values to their corresponding boolean value
272: --
273: l_validate :=
274: hr_api.constant_to_boolean
275: (p_constant_value => p_validate);
276: --
277: -- Register Surrogate ID or user key values
278: --

Line 338: (p_validate in number default hr_api.g_false_num

334: -- ----------------------------------------------------------------------------
335: -- |------------------------------< update_sit >------------------------------|
336: -- ----------------------------------------------------------------------------
337: PROCEDURE update_sit
338: (p_validate in number default hr_api.g_false_num
339: ,p_person_analysis_id in number
340: ,p_pea_object_version_number in out nocopy number
341: ,p_comments in varchar2 default hr_api.g_varchar2
342: ,p_date_from in date default hr_api.g_date

Line 341: ,p_comments in varchar2 default hr_api.g_varchar2

337: PROCEDURE update_sit
338: (p_validate in number default hr_api.g_false_num
339: ,p_person_analysis_id in number
340: ,p_pea_object_version_number in out nocopy number
341: ,p_comments in varchar2 default hr_api.g_varchar2
342: ,p_date_from in date default hr_api.g_date
343: ,p_date_to in date default hr_api.g_date
344: ,p_request_id in number default hr_api.g_number
345: ,p_program_application_id in number default hr_api.g_number

Line 342: ,p_date_from in date default hr_api.g_date

338: (p_validate in number default hr_api.g_false_num
339: ,p_person_analysis_id in number
340: ,p_pea_object_version_number in out nocopy number
341: ,p_comments in varchar2 default hr_api.g_varchar2
342: ,p_date_from in date default hr_api.g_date
343: ,p_date_to in date default hr_api.g_date
344: ,p_request_id in number default hr_api.g_number
345: ,p_program_application_id in number default hr_api.g_number
346: ,p_program_id in number default hr_api.g_number

Line 343: ,p_date_to in date default hr_api.g_date

339: ,p_person_analysis_id in number
340: ,p_pea_object_version_number in out nocopy number
341: ,p_comments in varchar2 default hr_api.g_varchar2
342: ,p_date_from in date default hr_api.g_date
343: ,p_date_to in date default hr_api.g_date
344: ,p_request_id in number default hr_api.g_number
345: ,p_program_application_id in number default hr_api.g_number
346: ,p_program_id in number default hr_api.g_number
347: ,p_program_update_date in date default hr_api.g_date

Line 344: ,p_request_id in number default hr_api.g_number

340: ,p_pea_object_version_number in out nocopy number
341: ,p_comments in varchar2 default hr_api.g_varchar2
342: ,p_date_from in date default hr_api.g_date
343: ,p_date_to in date default hr_api.g_date
344: ,p_request_id in number default hr_api.g_number
345: ,p_program_application_id in number default hr_api.g_number
346: ,p_program_id in number default hr_api.g_number
347: ,p_program_update_date in date default hr_api.g_date
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 345: ,p_program_application_id in number default hr_api.g_number

341: ,p_comments in varchar2 default hr_api.g_varchar2
342: ,p_date_from in date default hr_api.g_date
343: ,p_date_to in date default hr_api.g_date
344: ,p_request_id in number default hr_api.g_number
345: ,p_program_application_id in number default hr_api.g_number
346: ,p_program_id in number default hr_api.g_number
347: ,p_program_update_date in date default hr_api.g_date
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 346: ,p_program_id in number default hr_api.g_number

342: ,p_date_from in date default hr_api.g_date
343: ,p_date_to in date default hr_api.g_date
344: ,p_request_id in number default hr_api.g_number
345: ,p_program_application_id in number default hr_api.g_number
346: ,p_program_id in number default hr_api.g_number
347: ,p_program_update_date in date default hr_api.g_date
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 347: ,p_program_update_date in date default hr_api.g_date

343: ,p_date_to in date default hr_api.g_date
344: ,p_request_id in number default hr_api.g_number
345: ,p_program_application_id in number default hr_api.g_number
346: ,p_program_id in number default hr_api.g_number
347: ,p_program_update_date in date default hr_api.g_date
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 348: ,p_attribute_category in varchar2 default hr_api.g_varchar2

344: ,p_request_id in number default hr_api.g_number
345: ,p_program_application_id in number default hr_api.g_number
346: ,p_program_id in number default hr_api.g_number
347: ,p_program_update_date in date default hr_api.g_date
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 349: ,p_attribute1 in varchar2 default hr_api.g_varchar2

345: ,p_program_application_id in number default hr_api.g_number
346: ,p_program_id in number default hr_api.g_number
347: ,p_program_update_date in date default hr_api.g_date
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 350: ,p_attribute2 in varchar2 default hr_api.g_varchar2

346: ,p_program_id in number default hr_api.g_number
347: ,p_program_update_date in date default hr_api.g_date
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 351: ,p_attribute3 in varchar2 default hr_api.g_varchar2

347: ,p_program_update_date in date default hr_api.g_date
348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 352: ,p_attribute4 in varchar2 default hr_api.g_varchar2

348: ,p_attribute_category in varchar2 default hr_api.g_varchar2
349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 353: ,p_attribute5 in varchar2 default hr_api.g_varchar2

349: ,p_attribute1 in varchar2 default hr_api.g_varchar2
350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 354: ,p_attribute6 in varchar2 default hr_api.g_varchar2

350: ,p_attribute2 in varchar2 default hr_api.g_varchar2
351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 355: ,p_attribute7 in varchar2 default hr_api.g_varchar2

351: ,p_attribute3 in varchar2 default hr_api.g_varchar2
352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 356: ,p_attribute8 in varchar2 default hr_api.g_varchar2

352: ,p_attribute4 in varchar2 default hr_api.g_varchar2
353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 357: ,p_attribute9 in varchar2 default hr_api.g_varchar2

353: ,p_attribute5 in varchar2 default hr_api.g_varchar2
354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 358: ,p_attribute10 in varchar2 default hr_api.g_varchar2

354: ,p_attribute6 in varchar2 default hr_api.g_varchar2
355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 359: ,p_attribute11 in varchar2 default hr_api.g_varchar2

355: ,p_attribute7 in varchar2 default hr_api.g_varchar2
356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 360: ,p_attribute12 in varchar2 default hr_api.g_varchar2

356: ,p_attribute8 in varchar2 default hr_api.g_varchar2
357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 361: ,p_attribute13 in varchar2 default hr_api.g_varchar2

357: ,p_attribute9 in varchar2 default hr_api.g_varchar2
358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 362: ,p_attribute14 in varchar2 default hr_api.g_varchar2

358: ,p_attribute10 in varchar2 default hr_api.g_varchar2
359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 363: ,p_attribute15 in varchar2 default hr_api.g_varchar2

359: ,p_attribute11 in varchar2 default hr_api.g_varchar2
360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 364: ,p_attribute16 in varchar2 default hr_api.g_varchar2

360: ,p_attribute12 in varchar2 default hr_api.g_varchar2
361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 365: ,p_attribute17 in varchar2 default hr_api.g_varchar2

361: ,p_attribute13 in varchar2 default hr_api.g_varchar2
362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_segment1 in varchar2 default hr_api.g_varchar2

Line 366: ,p_attribute18 in varchar2 default hr_api.g_varchar2

362: ,p_attribute14 in varchar2 default hr_api.g_varchar2
363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_segment1 in varchar2 default hr_api.g_varchar2
370: ,p_segment2 in varchar2 default hr_api.g_varchar2

Line 367: ,p_attribute19 in varchar2 default hr_api.g_varchar2

363: ,p_attribute15 in varchar2 default hr_api.g_varchar2
364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_segment1 in varchar2 default hr_api.g_varchar2
370: ,p_segment2 in varchar2 default hr_api.g_varchar2
371: ,p_segment3 in varchar2 default hr_api.g_varchar2

Line 368: ,p_attribute20 in varchar2 default hr_api.g_varchar2

364: ,p_attribute16 in varchar2 default hr_api.g_varchar2
365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_segment1 in varchar2 default hr_api.g_varchar2
370: ,p_segment2 in varchar2 default hr_api.g_varchar2
371: ,p_segment3 in varchar2 default hr_api.g_varchar2
372: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 369: ,p_segment1 in varchar2 default hr_api.g_varchar2

365: ,p_attribute17 in varchar2 default hr_api.g_varchar2
366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_segment1 in varchar2 default hr_api.g_varchar2
370: ,p_segment2 in varchar2 default hr_api.g_varchar2
371: ,p_segment3 in varchar2 default hr_api.g_varchar2
372: ,p_segment4 in varchar2 default hr_api.g_varchar2
373: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 370: ,p_segment2 in varchar2 default hr_api.g_varchar2

366: ,p_attribute18 in varchar2 default hr_api.g_varchar2
367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_segment1 in varchar2 default hr_api.g_varchar2
370: ,p_segment2 in varchar2 default hr_api.g_varchar2
371: ,p_segment3 in varchar2 default hr_api.g_varchar2
372: ,p_segment4 in varchar2 default hr_api.g_varchar2
373: ,p_segment5 in varchar2 default hr_api.g_varchar2
374: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 371: ,p_segment3 in varchar2 default hr_api.g_varchar2

367: ,p_attribute19 in varchar2 default hr_api.g_varchar2
368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_segment1 in varchar2 default hr_api.g_varchar2
370: ,p_segment2 in varchar2 default hr_api.g_varchar2
371: ,p_segment3 in varchar2 default hr_api.g_varchar2
372: ,p_segment4 in varchar2 default hr_api.g_varchar2
373: ,p_segment5 in varchar2 default hr_api.g_varchar2
374: ,p_segment6 in varchar2 default hr_api.g_varchar2
375: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 372: ,p_segment4 in varchar2 default hr_api.g_varchar2

368: ,p_attribute20 in varchar2 default hr_api.g_varchar2
369: ,p_segment1 in varchar2 default hr_api.g_varchar2
370: ,p_segment2 in varchar2 default hr_api.g_varchar2
371: ,p_segment3 in varchar2 default hr_api.g_varchar2
372: ,p_segment4 in varchar2 default hr_api.g_varchar2
373: ,p_segment5 in varchar2 default hr_api.g_varchar2
374: ,p_segment6 in varchar2 default hr_api.g_varchar2
375: ,p_segment7 in varchar2 default hr_api.g_varchar2
376: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 373: ,p_segment5 in varchar2 default hr_api.g_varchar2

369: ,p_segment1 in varchar2 default hr_api.g_varchar2
370: ,p_segment2 in varchar2 default hr_api.g_varchar2
371: ,p_segment3 in varchar2 default hr_api.g_varchar2
372: ,p_segment4 in varchar2 default hr_api.g_varchar2
373: ,p_segment5 in varchar2 default hr_api.g_varchar2
374: ,p_segment6 in varchar2 default hr_api.g_varchar2
375: ,p_segment7 in varchar2 default hr_api.g_varchar2
376: ,p_segment8 in varchar2 default hr_api.g_varchar2
377: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 374: ,p_segment6 in varchar2 default hr_api.g_varchar2

370: ,p_segment2 in varchar2 default hr_api.g_varchar2
371: ,p_segment3 in varchar2 default hr_api.g_varchar2
372: ,p_segment4 in varchar2 default hr_api.g_varchar2
373: ,p_segment5 in varchar2 default hr_api.g_varchar2
374: ,p_segment6 in varchar2 default hr_api.g_varchar2
375: ,p_segment7 in varchar2 default hr_api.g_varchar2
376: ,p_segment8 in varchar2 default hr_api.g_varchar2
377: ,p_segment9 in varchar2 default hr_api.g_varchar2
378: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 375: ,p_segment7 in varchar2 default hr_api.g_varchar2

371: ,p_segment3 in varchar2 default hr_api.g_varchar2
372: ,p_segment4 in varchar2 default hr_api.g_varchar2
373: ,p_segment5 in varchar2 default hr_api.g_varchar2
374: ,p_segment6 in varchar2 default hr_api.g_varchar2
375: ,p_segment7 in varchar2 default hr_api.g_varchar2
376: ,p_segment8 in varchar2 default hr_api.g_varchar2
377: ,p_segment9 in varchar2 default hr_api.g_varchar2
378: ,p_segment10 in varchar2 default hr_api.g_varchar2
379: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 376: ,p_segment8 in varchar2 default hr_api.g_varchar2

372: ,p_segment4 in varchar2 default hr_api.g_varchar2
373: ,p_segment5 in varchar2 default hr_api.g_varchar2
374: ,p_segment6 in varchar2 default hr_api.g_varchar2
375: ,p_segment7 in varchar2 default hr_api.g_varchar2
376: ,p_segment8 in varchar2 default hr_api.g_varchar2
377: ,p_segment9 in varchar2 default hr_api.g_varchar2
378: ,p_segment10 in varchar2 default hr_api.g_varchar2
379: ,p_segment11 in varchar2 default hr_api.g_varchar2
380: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 377: ,p_segment9 in varchar2 default hr_api.g_varchar2

373: ,p_segment5 in varchar2 default hr_api.g_varchar2
374: ,p_segment6 in varchar2 default hr_api.g_varchar2
375: ,p_segment7 in varchar2 default hr_api.g_varchar2
376: ,p_segment8 in varchar2 default hr_api.g_varchar2
377: ,p_segment9 in varchar2 default hr_api.g_varchar2
378: ,p_segment10 in varchar2 default hr_api.g_varchar2
379: ,p_segment11 in varchar2 default hr_api.g_varchar2
380: ,p_segment12 in varchar2 default hr_api.g_varchar2
381: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 378: ,p_segment10 in varchar2 default hr_api.g_varchar2

374: ,p_segment6 in varchar2 default hr_api.g_varchar2
375: ,p_segment7 in varchar2 default hr_api.g_varchar2
376: ,p_segment8 in varchar2 default hr_api.g_varchar2
377: ,p_segment9 in varchar2 default hr_api.g_varchar2
378: ,p_segment10 in varchar2 default hr_api.g_varchar2
379: ,p_segment11 in varchar2 default hr_api.g_varchar2
380: ,p_segment12 in varchar2 default hr_api.g_varchar2
381: ,p_segment13 in varchar2 default hr_api.g_varchar2
382: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 379: ,p_segment11 in varchar2 default hr_api.g_varchar2

375: ,p_segment7 in varchar2 default hr_api.g_varchar2
376: ,p_segment8 in varchar2 default hr_api.g_varchar2
377: ,p_segment9 in varchar2 default hr_api.g_varchar2
378: ,p_segment10 in varchar2 default hr_api.g_varchar2
379: ,p_segment11 in varchar2 default hr_api.g_varchar2
380: ,p_segment12 in varchar2 default hr_api.g_varchar2
381: ,p_segment13 in varchar2 default hr_api.g_varchar2
382: ,p_segment14 in varchar2 default hr_api.g_varchar2
383: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 380: ,p_segment12 in varchar2 default hr_api.g_varchar2

376: ,p_segment8 in varchar2 default hr_api.g_varchar2
377: ,p_segment9 in varchar2 default hr_api.g_varchar2
378: ,p_segment10 in varchar2 default hr_api.g_varchar2
379: ,p_segment11 in varchar2 default hr_api.g_varchar2
380: ,p_segment12 in varchar2 default hr_api.g_varchar2
381: ,p_segment13 in varchar2 default hr_api.g_varchar2
382: ,p_segment14 in varchar2 default hr_api.g_varchar2
383: ,p_segment15 in varchar2 default hr_api.g_varchar2
384: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 381: ,p_segment13 in varchar2 default hr_api.g_varchar2

377: ,p_segment9 in varchar2 default hr_api.g_varchar2
378: ,p_segment10 in varchar2 default hr_api.g_varchar2
379: ,p_segment11 in varchar2 default hr_api.g_varchar2
380: ,p_segment12 in varchar2 default hr_api.g_varchar2
381: ,p_segment13 in varchar2 default hr_api.g_varchar2
382: ,p_segment14 in varchar2 default hr_api.g_varchar2
383: ,p_segment15 in varchar2 default hr_api.g_varchar2
384: ,p_segment16 in varchar2 default hr_api.g_varchar2
385: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 382: ,p_segment14 in varchar2 default hr_api.g_varchar2

378: ,p_segment10 in varchar2 default hr_api.g_varchar2
379: ,p_segment11 in varchar2 default hr_api.g_varchar2
380: ,p_segment12 in varchar2 default hr_api.g_varchar2
381: ,p_segment13 in varchar2 default hr_api.g_varchar2
382: ,p_segment14 in varchar2 default hr_api.g_varchar2
383: ,p_segment15 in varchar2 default hr_api.g_varchar2
384: ,p_segment16 in varchar2 default hr_api.g_varchar2
385: ,p_segment17 in varchar2 default hr_api.g_varchar2
386: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 383: ,p_segment15 in varchar2 default hr_api.g_varchar2

379: ,p_segment11 in varchar2 default hr_api.g_varchar2
380: ,p_segment12 in varchar2 default hr_api.g_varchar2
381: ,p_segment13 in varchar2 default hr_api.g_varchar2
382: ,p_segment14 in varchar2 default hr_api.g_varchar2
383: ,p_segment15 in varchar2 default hr_api.g_varchar2
384: ,p_segment16 in varchar2 default hr_api.g_varchar2
385: ,p_segment17 in varchar2 default hr_api.g_varchar2
386: ,p_segment18 in varchar2 default hr_api.g_varchar2
387: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 384: ,p_segment16 in varchar2 default hr_api.g_varchar2

380: ,p_segment12 in varchar2 default hr_api.g_varchar2
381: ,p_segment13 in varchar2 default hr_api.g_varchar2
382: ,p_segment14 in varchar2 default hr_api.g_varchar2
383: ,p_segment15 in varchar2 default hr_api.g_varchar2
384: ,p_segment16 in varchar2 default hr_api.g_varchar2
385: ,p_segment17 in varchar2 default hr_api.g_varchar2
386: ,p_segment18 in varchar2 default hr_api.g_varchar2
387: ,p_segment19 in varchar2 default hr_api.g_varchar2
388: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 385: ,p_segment17 in varchar2 default hr_api.g_varchar2

381: ,p_segment13 in varchar2 default hr_api.g_varchar2
382: ,p_segment14 in varchar2 default hr_api.g_varchar2
383: ,p_segment15 in varchar2 default hr_api.g_varchar2
384: ,p_segment16 in varchar2 default hr_api.g_varchar2
385: ,p_segment17 in varchar2 default hr_api.g_varchar2
386: ,p_segment18 in varchar2 default hr_api.g_varchar2
387: ,p_segment19 in varchar2 default hr_api.g_varchar2
388: ,p_segment20 in varchar2 default hr_api.g_varchar2
389: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 386: ,p_segment18 in varchar2 default hr_api.g_varchar2

382: ,p_segment14 in varchar2 default hr_api.g_varchar2
383: ,p_segment15 in varchar2 default hr_api.g_varchar2
384: ,p_segment16 in varchar2 default hr_api.g_varchar2
385: ,p_segment17 in varchar2 default hr_api.g_varchar2
386: ,p_segment18 in varchar2 default hr_api.g_varchar2
387: ,p_segment19 in varchar2 default hr_api.g_varchar2
388: ,p_segment20 in varchar2 default hr_api.g_varchar2
389: ,p_segment21 in varchar2 default hr_api.g_varchar2
390: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 387: ,p_segment19 in varchar2 default hr_api.g_varchar2

383: ,p_segment15 in varchar2 default hr_api.g_varchar2
384: ,p_segment16 in varchar2 default hr_api.g_varchar2
385: ,p_segment17 in varchar2 default hr_api.g_varchar2
386: ,p_segment18 in varchar2 default hr_api.g_varchar2
387: ,p_segment19 in varchar2 default hr_api.g_varchar2
388: ,p_segment20 in varchar2 default hr_api.g_varchar2
389: ,p_segment21 in varchar2 default hr_api.g_varchar2
390: ,p_segment22 in varchar2 default hr_api.g_varchar2
391: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 388: ,p_segment20 in varchar2 default hr_api.g_varchar2

384: ,p_segment16 in varchar2 default hr_api.g_varchar2
385: ,p_segment17 in varchar2 default hr_api.g_varchar2
386: ,p_segment18 in varchar2 default hr_api.g_varchar2
387: ,p_segment19 in varchar2 default hr_api.g_varchar2
388: ,p_segment20 in varchar2 default hr_api.g_varchar2
389: ,p_segment21 in varchar2 default hr_api.g_varchar2
390: ,p_segment22 in varchar2 default hr_api.g_varchar2
391: ,p_segment23 in varchar2 default hr_api.g_varchar2
392: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 389: ,p_segment21 in varchar2 default hr_api.g_varchar2

385: ,p_segment17 in varchar2 default hr_api.g_varchar2
386: ,p_segment18 in varchar2 default hr_api.g_varchar2
387: ,p_segment19 in varchar2 default hr_api.g_varchar2
388: ,p_segment20 in varchar2 default hr_api.g_varchar2
389: ,p_segment21 in varchar2 default hr_api.g_varchar2
390: ,p_segment22 in varchar2 default hr_api.g_varchar2
391: ,p_segment23 in varchar2 default hr_api.g_varchar2
392: ,p_segment24 in varchar2 default hr_api.g_varchar2
393: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 390: ,p_segment22 in varchar2 default hr_api.g_varchar2

386: ,p_segment18 in varchar2 default hr_api.g_varchar2
387: ,p_segment19 in varchar2 default hr_api.g_varchar2
388: ,p_segment20 in varchar2 default hr_api.g_varchar2
389: ,p_segment21 in varchar2 default hr_api.g_varchar2
390: ,p_segment22 in varchar2 default hr_api.g_varchar2
391: ,p_segment23 in varchar2 default hr_api.g_varchar2
392: ,p_segment24 in varchar2 default hr_api.g_varchar2
393: ,p_segment25 in varchar2 default hr_api.g_varchar2
394: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 391: ,p_segment23 in varchar2 default hr_api.g_varchar2

387: ,p_segment19 in varchar2 default hr_api.g_varchar2
388: ,p_segment20 in varchar2 default hr_api.g_varchar2
389: ,p_segment21 in varchar2 default hr_api.g_varchar2
390: ,p_segment22 in varchar2 default hr_api.g_varchar2
391: ,p_segment23 in varchar2 default hr_api.g_varchar2
392: ,p_segment24 in varchar2 default hr_api.g_varchar2
393: ,p_segment25 in varchar2 default hr_api.g_varchar2
394: ,p_segment26 in varchar2 default hr_api.g_varchar2
395: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 392: ,p_segment24 in varchar2 default hr_api.g_varchar2

388: ,p_segment20 in varchar2 default hr_api.g_varchar2
389: ,p_segment21 in varchar2 default hr_api.g_varchar2
390: ,p_segment22 in varchar2 default hr_api.g_varchar2
391: ,p_segment23 in varchar2 default hr_api.g_varchar2
392: ,p_segment24 in varchar2 default hr_api.g_varchar2
393: ,p_segment25 in varchar2 default hr_api.g_varchar2
394: ,p_segment26 in varchar2 default hr_api.g_varchar2
395: ,p_segment27 in varchar2 default hr_api.g_varchar2
396: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 393: ,p_segment25 in varchar2 default hr_api.g_varchar2

389: ,p_segment21 in varchar2 default hr_api.g_varchar2
390: ,p_segment22 in varchar2 default hr_api.g_varchar2
391: ,p_segment23 in varchar2 default hr_api.g_varchar2
392: ,p_segment24 in varchar2 default hr_api.g_varchar2
393: ,p_segment25 in varchar2 default hr_api.g_varchar2
394: ,p_segment26 in varchar2 default hr_api.g_varchar2
395: ,p_segment27 in varchar2 default hr_api.g_varchar2
396: ,p_segment28 in varchar2 default hr_api.g_varchar2
397: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 394: ,p_segment26 in varchar2 default hr_api.g_varchar2

390: ,p_segment22 in varchar2 default hr_api.g_varchar2
391: ,p_segment23 in varchar2 default hr_api.g_varchar2
392: ,p_segment24 in varchar2 default hr_api.g_varchar2
393: ,p_segment25 in varchar2 default hr_api.g_varchar2
394: ,p_segment26 in varchar2 default hr_api.g_varchar2
395: ,p_segment27 in varchar2 default hr_api.g_varchar2
396: ,p_segment28 in varchar2 default hr_api.g_varchar2
397: ,p_segment29 in varchar2 default hr_api.g_varchar2
398: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 395: ,p_segment27 in varchar2 default hr_api.g_varchar2

391: ,p_segment23 in varchar2 default hr_api.g_varchar2
392: ,p_segment24 in varchar2 default hr_api.g_varchar2
393: ,p_segment25 in varchar2 default hr_api.g_varchar2
394: ,p_segment26 in varchar2 default hr_api.g_varchar2
395: ,p_segment27 in varchar2 default hr_api.g_varchar2
396: ,p_segment28 in varchar2 default hr_api.g_varchar2
397: ,p_segment29 in varchar2 default hr_api.g_varchar2
398: ,p_segment30 in varchar2 default hr_api.g_varchar2
399: ,p_concat_segments in varchar2 default hr_api.g_varchar2

Line 396: ,p_segment28 in varchar2 default hr_api.g_varchar2

392: ,p_segment24 in varchar2 default hr_api.g_varchar2
393: ,p_segment25 in varchar2 default hr_api.g_varchar2
394: ,p_segment26 in varchar2 default hr_api.g_varchar2
395: ,p_segment27 in varchar2 default hr_api.g_varchar2
396: ,p_segment28 in varchar2 default hr_api.g_varchar2
397: ,p_segment29 in varchar2 default hr_api.g_varchar2
398: ,p_segment30 in varchar2 default hr_api.g_varchar2
399: ,p_concat_segments in varchar2 default hr_api.g_varchar2
400: ,p_analysis_criteria_id in out nocopy number

Line 397: ,p_segment29 in varchar2 default hr_api.g_varchar2

393: ,p_segment25 in varchar2 default hr_api.g_varchar2
394: ,p_segment26 in varchar2 default hr_api.g_varchar2
395: ,p_segment27 in varchar2 default hr_api.g_varchar2
396: ,p_segment28 in varchar2 default hr_api.g_varchar2
397: ,p_segment29 in varchar2 default hr_api.g_varchar2
398: ,p_segment30 in varchar2 default hr_api.g_varchar2
399: ,p_concat_segments in varchar2 default hr_api.g_varchar2
400: ,p_analysis_criteria_id in out nocopy number
401: ,p_return_status out nocopy varchar2

Line 398: ,p_segment30 in varchar2 default hr_api.g_varchar2

394: ,p_segment26 in varchar2 default hr_api.g_varchar2
395: ,p_segment27 in varchar2 default hr_api.g_varchar2
396: ,p_segment28 in varchar2 default hr_api.g_varchar2
397: ,p_segment29 in varchar2 default hr_api.g_varchar2
398: ,p_segment30 in varchar2 default hr_api.g_varchar2
399: ,p_concat_segments in varchar2 default hr_api.g_varchar2
400: ,p_analysis_criteria_id in out nocopy number
401: ,p_return_status out nocopy varchar2
402: ) is

Line 399: ,p_concat_segments in varchar2 default hr_api.g_varchar2

395: ,p_segment27 in varchar2 default hr_api.g_varchar2
396: ,p_segment28 in varchar2 default hr_api.g_varchar2
397: ,p_segment29 in varchar2 default hr_api.g_varchar2
398: ,p_segment30 in varchar2 default hr_api.g_varchar2
399: ,p_concat_segments in varchar2 default hr_api.g_varchar2
400: ,p_analysis_criteria_id in out nocopy number
401: ,p_return_status out nocopy varchar2
402: ) is
403: --

Line 432: hr_api.constant_to_boolean

428: --
429: -- Convert constant values to their corresponding boolean value
430: --
431: l_validate :=
432: hr_api.constant_to_boolean
433: (p_constant_value => p_validate);
434: --
435: -- Register Surrogate ID or user key values
436: --