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

Line 11: (p_validate IN NUMBER DEFAULT HR_API.g_false_num

7: -- ---------------------------------------------------------------------------
8: -- ----------------------< create_emp_stat_situation >------------------------
9: -- ---------------------------------------------------------------------------
10: PROCEDURE create_emp_stat_situation
11: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
12: ,p_effective_date IN DATE
13: ,p_statutory_situation_id IN NUMBER
14: ,p_person_id IN NUMBER
15: ,p_provisional_start_date IN DATE

Line 144: l_validate := HR_API.constant_to_boolean(p_constant_value => p_validate);

140: --
141: --Initialise Multiple Message Detection
142: HR_MULTI_MESSAGE.enable_message_list;
143: --Convert constant values to their corresponding boolean value
144: l_validate := HR_API.constant_to_boolean(p_constant_value => p_validate);
145: --
146: --Check whether In Activity Normal Default Situation exists during the timeframe.
147: OPEN csr_get_inactivity(p_provisional_start_date,p_provisional_end_date,
148: p_actual_start_date,p_actual_end_date,p_person_id);

Line 324: (p_validate IN NUMBER DEFAULT HR_API.g_false_num

320: -- ---------------------------------------------------------------------------
321: -- ----------------------< update_emp_stat_situation >------------------------
322: -- ---------------------------------------------------------------------------
323: PROCEDURE update_emp_stat_situation
324: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
325: ,p_effective_date IN DATE
326: ,p_emp_stat_situation_id IN NUMBER
327: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
328: ,p_person_id IN NUMBER DEFAULT HR_API.g_number

Line 327: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number

323: PROCEDURE update_emp_stat_situation
324: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
325: ,p_effective_date IN DATE
326: ,p_emp_stat_situation_id IN NUMBER
327: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
328: ,p_person_id IN NUMBER DEFAULT HR_API.g_number
329: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
330: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
331: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date

Line 328: ,p_person_id IN NUMBER DEFAULT HR_API.g_number

324: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
325: ,p_effective_date IN DATE
326: ,p_emp_stat_situation_id IN NUMBER
327: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
328: ,p_person_id IN NUMBER DEFAULT HR_API.g_number
329: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
330: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
331: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
332: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date

Line 329: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date

325: ,p_effective_date IN DATE
326: ,p_emp_stat_situation_id IN NUMBER
327: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
328: ,p_person_id IN NUMBER DEFAULT HR_API.g_number
329: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
330: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
331: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
332: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
333: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 330: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date

326: ,p_emp_stat_situation_id IN NUMBER
327: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
328: ,p_person_id IN NUMBER DEFAULT HR_API.g_number
329: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
330: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
331: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
332: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
333: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
334: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 331: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date

327: ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
328: ,p_person_id IN NUMBER DEFAULT HR_API.g_number
329: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
330: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
331: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
332: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
333: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
334: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
335: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number

Line 332: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date

328: ,p_person_id IN NUMBER DEFAULT HR_API.g_number
329: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
330: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
331: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
332: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
333: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
334: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
335: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
336: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 333: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2

329: ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
330: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
331: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
332: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
333: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
334: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
335: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
336: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
337: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number

Line 334: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2

330: ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
331: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
332: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
333: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
334: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
335: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
336: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
337: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
338: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 335: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number

331: ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
332: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
333: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
334: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
335: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
336: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
337: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
338: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
339: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number

Line 336: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2

332: ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
333: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
334: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
335: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
336: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
337: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
338: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
339: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
340: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number

Line 337: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number

333: ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
334: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
335: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
336: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
337: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
338: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
339: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
340: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
341: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 338: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2

334: ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
335: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
336: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
337: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
338: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
339: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
340: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
341: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
342: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 339: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number

335: ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
336: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
337: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
338: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
339: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
340: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
341: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
342: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
343: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 340: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number

336: ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
337: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
338: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
339: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
340: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
341: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
342: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
343: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
344: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 341: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2

337: ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
338: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
339: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
340: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
341: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
342: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
343: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
344: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
345: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 342: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2

338: ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
339: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
340: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
341: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
342: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
343: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
344: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
345: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
346: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 343: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2

339: ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
340: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
341: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
342: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
343: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
344: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
345: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
346: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
347: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 344: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2

340: ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
341: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
342: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
343: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
344: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
345: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
346: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
347: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
348: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 345: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2

341: ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
342: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
343: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
344: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
345: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
346: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
347: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
348: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
349: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 346: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2

342: ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
343: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
344: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
345: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
346: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
347: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
348: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
349: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
350: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 347: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2

343: ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
344: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
345: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
346: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
347: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
348: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
349: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
350: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
351: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 348: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2

344: ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
345: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
346: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
347: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
348: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
349: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
350: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
351: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
352: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 349: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2

345: ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
346: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
347: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
348: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
349: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
350: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
351: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
352: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
353: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 350: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2

346: ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
347: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
348: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
349: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
350: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
351: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
352: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
353: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
354: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 351: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2

347: ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
348: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
349: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
350: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
351: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
352: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
353: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
354: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
355: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 352: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2

348: ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
349: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
350: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
351: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
352: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
353: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
354: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
355: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
356: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 353: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2

349: ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
350: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
351: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
352: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
353: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
354: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
355: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
356: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
357: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 354: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2

350: ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
351: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
352: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
353: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
354: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
355: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
356: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
357: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
358: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 355: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2

351: ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
352: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
353: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
354: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
355: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
356: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
357: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
358: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
359: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 356: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2

352: ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
353: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
354: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
355: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
356: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
357: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
358: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
359: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
360: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 357: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2

353: ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
354: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
355: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
356: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
357: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
358: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
359: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
360: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
361: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 358: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2

354: ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
355: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
356: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
357: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
358: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
359: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
360: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
361: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
362: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 359: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2

355: ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
356: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
357: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
358: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
359: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
360: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
361: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
362: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
363: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 360: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2

356: ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
357: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
358: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
359: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
360: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
361: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
362: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
363: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
364: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 361: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2

357: ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
358: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
359: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
360: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
361: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
362: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
363: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
364: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
365: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 362: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2

358: ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
359: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
360: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
361: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
362: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
363: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
364: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
365: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
366: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 363: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2

359: ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
360: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
361: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
362: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
363: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
364: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
365: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
366: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
367: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 364: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2

360: ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
361: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
362: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
363: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
364: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
365: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
366: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
367: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
368: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 365: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2

361: ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
362: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
363: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
364: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
365: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
366: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
367: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
368: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
369: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 366: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2

362: ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
363: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
364: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
365: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
366: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
367: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
368: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
369: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
370: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 367: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2

363: ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
364: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
365: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
366: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
367: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
368: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
369: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
370: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2
371: ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2

Line 368: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2

364: ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
365: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
366: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
367: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
368: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
369: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
370: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2
371: ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2
372: ,p_object_version_number IN OUT nocopy NUMBER

Line 369: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2

365: ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
366: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
367: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
368: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
369: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
370: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2
371: ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2
372: ,p_object_version_number IN OUT nocopy NUMBER
373: ,p_return_status OUT nocopy VARCHAR2

Line 370: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2

366: ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
367: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
368: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
369: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
370: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2
371: ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2
372: ,p_object_version_number IN OUT nocopy NUMBER
373: ,p_return_status OUT nocopy VARCHAR2
374: )

Line 371: ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2

367: ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
368: ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
369: ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
370: ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2
371: ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2
372: ,p_object_version_number IN OUT nocopy NUMBER
373: ,p_return_status OUT nocopy VARCHAR2
374: )
375: IS

Line 463: l_validate := HR_API.constant_to_boolean(p_constant_value => p_validate);

459: --Assign OVN for Update Record to IN OUT variable
460: l_object_version_number := p_object_version_number;
461: --
462: --Convert constant values to their corresponding boolean value
463: l_validate := HR_API.constant_to_boolean(p_constant_value => p_validate);
464: --
465: --Fetch details of Situation to be updated.
466: OPEN csr_current_situation_dtls(p_emp_stat_situation_id);
467: FETCH csr_current_situation_dtls INTO l_person_id,l_sit_id,l_act_st_dt,l_prov_st_dt,l_act_end_dt,l_prov_end_dt;

Line 681: (p_validate IN NUMBER DEFAULT HR_API.g_false_num

677: -- ---------------------------------------------------------------------------
678: -- --------------------< reinstate_emp_stat_situation >-----------------------
679: -- ---------------------------------------------------------------------------
680: PROCEDURE reinstate_emp_stat_situation
681: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
682: ,p_person_id IN NUMBER
683: ,p_emp_stat_situation_id IN NUMBER
684: ,p_reinstate_date IN DATE
685: ,p_comments IN VARCHAR2

Line 732: l_validate := HR_API.constant_to_boolean(p_constant_value => p_validate);

728: --Initialise Multiple Message Detection
729: HR_MULTI_MESSAGE.enable_message_list;
730: --
731: --Convert constant values to their corresponding boolean value
732: l_validate := HR_API.constant_to_boolean(p_constant_value => p_validate);
733: --
734: --Get In Activity Normal Default Situation Id
735: l_reinstate_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation
736: (p_business_group_id => HR_GENERAL.get_business_group_id

Line 843: (p_validate IN NUMBER DEFAULT HR_API.g_false_num

839: -- ---------------------------------------------------------------------------
840: -- |-----------------------< renew_emp_stat_situation >-----------------------
841: -- ---------------------------------------------------------------------------
842: PROCEDURE renew_emp_stat_situation
843: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
844: ,p_emp_stat_situation_id IN OUT nocopy NUMBER
845: ,p_renew_stat_situation_id IN NUMBER
846: ,p_renewal_duration IN NUMBER
847: ,p_duration_units IN VARCHAR2

Line 935: l_validate := HR_API.constant_to_boolean(p_constant_value => p_validate);

931: --Initialise Multiple Message Detection
932: HR_MULTI_MESSAGE.enable_message_list;
933: --
934: --Convert constant values to their corresponding boolean value
935: l_validate := HR_API.constant_to_boolean(p_constant_value => p_validate);
936: --
937: -- Remember IN OUT parameter IN values
938: l_emp_stat_situation_id := p_emp_stat_situation_id;
939: l_object_version_number := p_object_version_number;

Line 1100: (p_validate IN NUMBER DEFAULT HR_API.g_false_num

1096: -- ---------------------------------------------------------------------------
1097: -- |-----------------------< delete_emp_stat_situation >----------------------
1098: -- ---------------------------------------------------------------------------
1099: PROCEDURE delete_emp_stat_situation
1100: (p_validate IN NUMBER DEFAULT HR_API.g_false_num
1101: ,p_emp_stat_situation_id IN NUMBER
1102: ,p_object_version_number IN NUMBER
1103: ,p_return_status OUT nocopy VARCHAR2
1104: )

Line 1167: l_validate := HR_API.constant_to_boolean(p_constant_value => p_validate);

1163: --Initialise Multiple Message Detection
1164: HR_MULTI_MESSAGE.enable_message_list;
1165: --
1166: --Convert constant values to their corresponding boolean value
1167: l_validate := HR_API.constant_to_boolean(p_constant_value => p_validate);
1168: --
1169: --Fetch details of Situation to be deleted.
1170: OPEN csr_current_situation_dtls(p_emp_stat_situation_id);
1171: FETCH csr_current_situation_dtls INTO l_person_id, l_act_st_dt, l_prov_st_dt,