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

Line 147: When hr_api.check_integrity_violated Then

143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: --
146: Exception
147: When hr_api.check_integrity_violated Then
148: -- A check constraint has been violated
149: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
150: ssp_mat_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

147: When hr_api.check_integrity_violated Then
148: -- A check constraint has been violated
149: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
150: ssp_mat_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.parent_integrity_violated Then
153: -- Parent integrity has been violated
154: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
155: ssp_mat_shd.constraint_error

Line 152: When hr_api.parent_integrity_violated Then

148: -- A check constraint has been violated
149: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
150: ssp_mat_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.parent_integrity_violated Then
153: -- Parent integrity has been violated
154: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
155: ssp_mat_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

152: When hr_api.parent_integrity_violated Then
153: -- Parent integrity has been violated
154: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
155: ssp_mat_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.unique_integrity_violated Then
158: -- Unique integrity has been violated
159: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
160: ssp_mat_shd.constraint_error

Line 157: When hr_api.unique_integrity_violated Then

153: -- Parent integrity has been violated
154: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
155: ssp_mat_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.unique_integrity_violated Then
158: -- Unique integrity has been violated
159: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
160: ssp_mat_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

157: When hr_api.unique_integrity_violated Then
158: -- Unique integrity has been violated
159: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
160: ssp_mat_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When Others Then
163: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
164: Raise;
165: End update_dml;

Line 308: If (p_rec.due_date = hr_api.g_date) then

304: -- p_rec plsql record structure
305: -- to see if a system default is being used. If a system default
306: -- is being used then we must set to the 'current' argument value.
307: --
308: If (p_rec.due_date = hr_api.g_date) then
309: p_rec.due_date :=
310: ssp_mat_shd.g_old_rec.due_date;
311: End If;
312: If (p_rec.person_id = hr_api.g_number) then

Line 312: If (p_rec.person_id = hr_api.g_number) then

308: If (p_rec.due_date = hr_api.g_date) then
309: p_rec.due_date :=
310: ssp_mat_shd.g_old_rec.due_date;
311: End If;
312: If (p_rec.person_id = hr_api.g_number) then
313: p_rec.person_id :=
314: ssp_mat_shd.g_old_rec.person_id;
315: End If;
316: If (p_rec.start_date_maternity_allowance = hr_api.g_date) then

Line 316: If (p_rec.start_date_maternity_allowance = hr_api.g_date) then

312: If (p_rec.person_id = hr_api.g_number) then
313: p_rec.person_id :=
314: ssp_mat_shd.g_old_rec.person_id;
315: End If;
316: If (p_rec.start_date_maternity_allowance = hr_api.g_date) then
317: p_rec.start_date_maternity_allowance :=
318: ssp_mat_shd.g_old_rec.start_date_maternity_allowance;
319: End If;
320: If (p_rec.notification_of_birth_date = hr_api.g_date) then

Line 320: If (p_rec.notification_of_birth_date = hr_api.g_date) then

316: If (p_rec.start_date_maternity_allowance = hr_api.g_date) then
317: p_rec.start_date_maternity_allowance :=
318: ssp_mat_shd.g_old_rec.start_date_maternity_allowance;
319: End If;
320: If (p_rec.notification_of_birth_date = hr_api.g_date) then
321: p_rec.notification_of_birth_date :=
322: ssp_mat_shd.g_old_rec.notification_of_birth_date;
323: End If;
324: If (p_rec.unfit_for_scheduled_return = hr_api.g_varchar2) then

Line 324: If (p_rec.unfit_for_scheduled_return = hr_api.g_varchar2) then

320: If (p_rec.notification_of_birth_date = hr_api.g_date) then
321: p_rec.notification_of_birth_date :=
322: ssp_mat_shd.g_old_rec.notification_of_birth_date;
323: End If;
324: If (p_rec.unfit_for_scheduled_return = hr_api.g_varchar2) then
325: p_rec.unfit_for_scheduled_return :=
326: ssp_mat_shd.g_old_rec.unfit_for_scheduled_return;
327: End If;
328: If (p_rec.stated_return_date = hr_api.g_date) then

Line 328: If (p_rec.stated_return_date = hr_api.g_date) then

324: If (p_rec.unfit_for_scheduled_return = hr_api.g_varchar2) then
325: p_rec.unfit_for_scheduled_return :=
326: ssp_mat_shd.g_old_rec.unfit_for_scheduled_return;
327: End If;
328: If (p_rec.stated_return_date = hr_api.g_date) then
329: p_rec.stated_return_date :=
330: ssp_mat_shd.g_old_rec.stated_return_date;
331: End If;
332: If (p_rec.intend_to_return_flag = hr_api.g_varchar2) then

Line 332: If (p_rec.intend_to_return_flag = hr_api.g_varchar2) then

328: If (p_rec.stated_return_date = hr_api.g_date) then
329: p_rec.stated_return_date :=
330: ssp_mat_shd.g_old_rec.stated_return_date;
331: End If;
332: If (p_rec.intend_to_return_flag = hr_api.g_varchar2) then
333: p_rec.intend_to_return_flag :=
334: ssp_mat_shd.g_old_rec.intend_to_return_flag;
335: End If;
336: If (p_rec.start_date_with_new_employer = hr_api.g_date) then

Line 336: If (p_rec.start_date_with_new_employer = hr_api.g_date) then

332: If (p_rec.intend_to_return_flag = hr_api.g_varchar2) then
333: p_rec.intend_to_return_flag :=
334: ssp_mat_shd.g_old_rec.intend_to_return_flag;
335: End If;
336: If (p_rec.start_date_with_new_employer = hr_api.g_date) then
337: p_rec.start_date_with_new_employer :=
338: ssp_mat_shd.g_old_rec.start_date_with_new_employer;
339: End If;
340: If (p_rec.smp_must_be_paid_by_date = hr_api.g_date) then

Line 340: If (p_rec.smp_must_be_paid_by_date = hr_api.g_date) then

336: If (p_rec.start_date_with_new_employer = hr_api.g_date) then
337: p_rec.start_date_with_new_employer :=
338: ssp_mat_shd.g_old_rec.start_date_with_new_employer;
339: End If;
340: If (p_rec.smp_must_be_paid_by_date = hr_api.g_date) then
341: p_rec.smp_must_be_paid_by_date :=
342: ssp_mat_shd.g_old_rec.smp_must_be_paid_by_date;
343: End If;
344: If (p_rec.pay_smp_as_lump_sum = hr_api.g_varchar2) then

Line 344: If (p_rec.pay_smp_as_lump_sum = hr_api.g_varchar2) then

340: If (p_rec.smp_must_be_paid_by_date = hr_api.g_date) then
341: p_rec.smp_must_be_paid_by_date :=
342: ssp_mat_shd.g_old_rec.smp_must_be_paid_by_date;
343: End If;
344: If (p_rec.pay_smp_as_lump_sum = hr_api.g_varchar2) then
345: p_rec.pay_smp_as_lump_sum :=
346: ssp_mat_shd.g_old_rec.pay_smp_as_lump_sum;
347: End If;
348: If (p_rec.live_birth_flag = hr_api.g_varchar2) then

Line 348: If (p_rec.live_birth_flag = hr_api.g_varchar2) then

344: If (p_rec.pay_smp_as_lump_sum = hr_api.g_varchar2) then
345: p_rec.pay_smp_as_lump_sum :=
346: ssp_mat_shd.g_old_rec.pay_smp_as_lump_sum;
347: End If;
348: If (p_rec.live_birth_flag = hr_api.g_varchar2) then
349: p_rec.live_birth_flag :=
350: ssp_mat_shd.g_old_rec.live_birth_flag;
351: End If;
352: If (p_rec.actual_birth_date = hr_api.g_date) then

Line 352: If (p_rec.actual_birth_date = hr_api.g_date) then

348: If (p_rec.live_birth_flag = hr_api.g_varchar2) then
349: p_rec.live_birth_flag :=
350: ssp_mat_shd.g_old_rec.live_birth_flag;
351: End If;
352: If (p_rec.actual_birth_date = hr_api.g_date) then
353: p_rec.actual_birth_date :=
354: ssp_mat_shd.g_old_rec.actual_birth_date;
355: End If;
356: If (p_rec.mpp_start_date = hr_api.g_date) then

Line 356: If (p_rec.mpp_start_date = hr_api.g_date) then

352: If (p_rec.actual_birth_date = hr_api.g_date) then
353: p_rec.actual_birth_date :=
354: ssp_mat_shd.g_old_rec.actual_birth_date;
355: End If;
356: If (p_rec.mpp_start_date = hr_api.g_date) then
357: p_rec.mpp_start_date :=
358: ssp_mat_shd.g_old_rec.mpp_start_date;
359: End If;
360: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 360: If (p_rec.attribute_category = hr_api.g_varchar2) then

356: If (p_rec.mpp_start_date = hr_api.g_date) then
357: p_rec.mpp_start_date :=
358: ssp_mat_shd.g_old_rec.mpp_start_date;
359: End If;
360: If (p_rec.attribute_category = hr_api.g_varchar2) then
361: p_rec.attribute_category :=
362: ssp_mat_shd.g_old_rec.attribute_category;
363: End If;
364: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 364: If (p_rec.attribute1 = hr_api.g_varchar2) then

360: If (p_rec.attribute_category = hr_api.g_varchar2) then
361: p_rec.attribute_category :=
362: ssp_mat_shd.g_old_rec.attribute_category;
363: End If;
364: If (p_rec.attribute1 = hr_api.g_varchar2) then
365: p_rec.attribute1 :=
366: ssp_mat_shd.g_old_rec.attribute1;
367: End If;
368: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 368: If (p_rec.attribute2 = hr_api.g_varchar2) then

364: If (p_rec.attribute1 = hr_api.g_varchar2) then
365: p_rec.attribute1 :=
366: ssp_mat_shd.g_old_rec.attribute1;
367: End If;
368: If (p_rec.attribute2 = hr_api.g_varchar2) then
369: p_rec.attribute2 :=
370: ssp_mat_shd.g_old_rec.attribute2;
371: End If;
372: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 372: If (p_rec.attribute3 = hr_api.g_varchar2) then

368: If (p_rec.attribute2 = hr_api.g_varchar2) then
369: p_rec.attribute2 :=
370: ssp_mat_shd.g_old_rec.attribute2;
371: End If;
372: If (p_rec.attribute3 = hr_api.g_varchar2) then
373: p_rec.attribute3 :=
374: ssp_mat_shd.g_old_rec.attribute3;
375: End If;
376: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 376: If (p_rec.attribute4 = hr_api.g_varchar2) then

372: If (p_rec.attribute3 = hr_api.g_varchar2) then
373: p_rec.attribute3 :=
374: ssp_mat_shd.g_old_rec.attribute3;
375: End If;
376: If (p_rec.attribute4 = hr_api.g_varchar2) then
377: p_rec.attribute4 :=
378: ssp_mat_shd.g_old_rec.attribute4;
379: End If;
380: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 380: If (p_rec.attribute5 = hr_api.g_varchar2) then

376: If (p_rec.attribute4 = hr_api.g_varchar2) then
377: p_rec.attribute4 :=
378: ssp_mat_shd.g_old_rec.attribute4;
379: End If;
380: If (p_rec.attribute5 = hr_api.g_varchar2) then
381: p_rec.attribute5 :=
382: ssp_mat_shd.g_old_rec.attribute5;
383: End If;
384: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 384: If (p_rec.attribute6 = hr_api.g_varchar2) then

380: If (p_rec.attribute5 = hr_api.g_varchar2) then
381: p_rec.attribute5 :=
382: ssp_mat_shd.g_old_rec.attribute5;
383: End If;
384: If (p_rec.attribute6 = hr_api.g_varchar2) then
385: p_rec.attribute6 :=
386: ssp_mat_shd.g_old_rec.attribute6;
387: End If;
388: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 388: If (p_rec.attribute7 = hr_api.g_varchar2) then

384: If (p_rec.attribute6 = hr_api.g_varchar2) then
385: p_rec.attribute6 :=
386: ssp_mat_shd.g_old_rec.attribute6;
387: End If;
388: If (p_rec.attribute7 = hr_api.g_varchar2) then
389: p_rec.attribute7 :=
390: ssp_mat_shd.g_old_rec.attribute7;
391: End If;
392: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 392: If (p_rec.attribute8 = hr_api.g_varchar2) then

388: If (p_rec.attribute7 = hr_api.g_varchar2) then
389: p_rec.attribute7 :=
390: ssp_mat_shd.g_old_rec.attribute7;
391: End If;
392: If (p_rec.attribute8 = hr_api.g_varchar2) then
393: p_rec.attribute8 :=
394: ssp_mat_shd.g_old_rec.attribute8;
395: End If;
396: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 396: If (p_rec.attribute9 = hr_api.g_varchar2) then

392: If (p_rec.attribute8 = hr_api.g_varchar2) then
393: p_rec.attribute8 :=
394: ssp_mat_shd.g_old_rec.attribute8;
395: End If;
396: If (p_rec.attribute9 = hr_api.g_varchar2) then
397: p_rec.attribute9 :=
398: ssp_mat_shd.g_old_rec.attribute9;
399: End If;
400: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 400: If (p_rec.attribute10 = hr_api.g_varchar2) then

396: If (p_rec.attribute9 = hr_api.g_varchar2) then
397: p_rec.attribute9 :=
398: ssp_mat_shd.g_old_rec.attribute9;
399: End If;
400: If (p_rec.attribute10 = hr_api.g_varchar2) then
401: p_rec.attribute10 :=
402: ssp_mat_shd.g_old_rec.attribute10;
403: End If;
404: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 404: If (p_rec.attribute11 = hr_api.g_varchar2) then

400: If (p_rec.attribute10 = hr_api.g_varchar2) then
401: p_rec.attribute10 :=
402: ssp_mat_shd.g_old_rec.attribute10;
403: End If;
404: If (p_rec.attribute11 = hr_api.g_varchar2) then
405: p_rec.attribute11 :=
406: ssp_mat_shd.g_old_rec.attribute11;
407: End If;
408: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 408: If (p_rec.attribute12 = hr_api.g_varchar2) then

404: If (p_rec.attribute11 = hr_api.g_varchar2) then
405: p_rec.attribute11 :=
406: ssp_mat_shd.g_old_rec.attribute11;
407: End If;
408: If (p_rec.attribute12 = hr_api.g_varchar2) then
409: p_rec.attribute12 :=
410: ssp_mat_shd.g_old_rec.attribute12;
411: End If;
412: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 412: If (p_rec.attribute13 = hr_api.g_varchar2) then

408: If (p_rec.attribute12 = hr_api.g_varchar2) then
409: p_rec.attribute12 :=
410: ssp_mat_shd.g_old_rec.attribute12;
411: End If;
412: If (p_rec.attribute13 = hr_api.g_varchar2) then
413: p_rec.attribute13 :=
414: ssp_mat_shd.g_old_rec.attribute13;
415: End If;
416: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 416: If (p_rec.attribute14 = hr_api.g_varchar2) then

412: If (p_rec.attribute13 = hr_api.g_varchar2) then
413: p_rec.attribute13 :=
414: ssp_mat_shd.g_old_rec.attribute13;
415: End If;
416: If (p_rec.attribute14 = hr_api.g_varchar2) then
417: p_rec.attribute14 :=
418: ssp_mat_shd.g_old_rec.attribute14;
419: End If;
420: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 420: If (p_rec.attribute15 = hr_api.g_varchar2) then

416: If (p_rec.attribute14 = hr_api.g_varchar2) then
417: p_rec.attribute14 :=
418: ssp_mat_shd.g_old_rec.attribute14;
419: End If;
420: If (p_rec.attribute15 = hr_api.g_varchar2) then
421: p_rec.attribute15 :=
422: ssp_mat_shd.g_old_rec.attribute15;
423: End If;
424: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 424: If (p_rec.attribute16 = hr_api.g_varchar2) then

420: If (p_rec.attribute15 = hr_api.g_varchar2) then
421: p_rec.attribute15 :=
422: ssp_mat_shd.g_old_rec.attribute15;
423: End If;
424: If (p_rec.attribute16 = hr_api.g_varchar2) then
425: p_rec.attribute16 :=
426: ssp_mat_shd.g_old_rec.attribute16;
427: End If;
428: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 428: If (p_rec.attribute17 = hr_api.g_varchar2) then

424: If (p_rec.attribute16 = hr_api.g_varchar2) then
425: p_rec.attribute16 :=
426: ssp_mat_shd.g_old_rec.attribute16;
427: End If;
428: If (p_rec.attribute17 = hr_api.g_varchar2) then
429: p_rec.attribute17 :=
430: ssp_mat_shd.g_old_rec.attribute17;
431: End If;
432: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 432: If (p_rec.attribute18 = hr_api.g_varchar2) then

428: If (p_rec.attribute17 = hr_api.g_varchar2) then
429: p_rec.attribute17 :=
430: ssp_mat_shd.g_old_rec.attribute17;
431: End If;
432: If (p_rec.attribute18 = hr_api.g_varchar2) then
433: p_rec.attribute18 :=
434: ssp_mat_shd.g_old_rec.attribute18;
435: End If;
436: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 436: If (p_rec.attribute19 = hr_api.g_varchar2) then

432: If (p_rec.attribute18 = hr_api.g_varchar2) then
433: p_rec.attribute18 :=
434: ssp_mat_shd.g_old_rec.attribute18;
435: End If;
436: If (p_rec.attribute19 = hr_api.g_varchar2) then
437: p_rec.attribute19 :=
438: ssp_mat_shd.g_old_rec.attribute19;
439: End If;
440: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 440: If (p_rec.attribute20 = hr_api.g_varchar2) then

436: If (p_rec.attribute19 = hr_api.g_varchar2) then
437: p_rec.attribute19 :=
438: ssp_mat_shd.g_old_rec.attribute19;
439: End If;
440: If (p_rec.attribute20 = hr_api.g_varchar2) then
441: p_rec.attribute20 :=
442: ssp_mat_shd.g_old_rec.attribute20;
443: End If;
444:

Line 445: If (p_rec.LEAVE_TYPE = hr_api.g_varchar2) then

441: p_rec.attribute20 :=
442: ssp_mat_shd.g_old_rec.attribute20;
443: End If;
444:
445: If (p_rec.LEAVE_TYPE = hr_api.g_varchar2) then
446: p_rec.LEAVE_TYPE :=
447: ssp_mat_shd.g_old_rec.LEAVE_TYPE;
448: End If;
449:

Line 450: If (p_rec.MATCHING_DATE = hr_api.g_date) then

446: p_rec.LEAVE_TYPE :=
447: ssp_mat_shd.g_old_rec.LEAVE_TYPE;
448: End If;
449:
450: If (p_rec.MATCHING_DATE = hr_api.g_date) then
451: p_rec.MATCHING_DATE :=
452: ssp_mat_shd.g_old_rec.MATCHING_DATE;
453: End If;
454:

Line 455: If (p_rec.PLACEMENT_DATE = hr_api.g_date) then

451: p_rec.MATCHING_DATE :=
452: ssp_mat_shd.g_old_rec.MATCHING_DATE;
453: End If;
454:
455: If (p_rec.PLACEMENT_DATE = hr_api.g_date) then
456: p_rec.PLACEMENT_DATE :=
457: ssp_mat_shd.g_old_rec.PLACEMENT_DATE;
458: End If;
459:

Line 460: If (p_rec.DISRUPTED_PLACEMENT_DATE = hr_api.g_date) then

456: p_rec.PLACEMENT_DATE :=
457: ssp_mat_shd.g_old_rec.PLACEMENT_DATE;
458: End If;
459:
460: If (p_rec.DISRUPTED_PLACEMENT_DATE = hr_api.g_date) then
461: p_rec.DISRUPTED_PLACEMENT_DATE :=
462: ssp_mat_shd.g_old_rec.DISRUPTED_PLACEMENT_DATE;
463: End If;
464:

Line 465: If (p_rec.mat_information_category = hr_api.g_varchar2) then

461: p_rec.DISRUPTED_PLACEMENT_DATE :=
462: ssp_mat_shd.g_old_rec.DISRUPTED_PLACEMENT_DATE;
463: End If;
464:
465: If (p_rec.mat_information_category = hr_api.g_varchar2) then
466: p_rec.mat_information_category :=
467: ssp_mat_shd.g_old_rec.mat_information_category;
468: End If;
469: If (p_rec.mat_information1 = hr_api.g_varchar2) then

Line 469: If (p_rec.mat_information1 = hr_api.g_varchar2) then

465: If (p_rec.mat_information_category = hr_api.g_varchar2) then
466: p_rec.mat_information_category :=
467: ssp_mat_shd.g_old_rec.mat_information_category;
468: End If;
469: If (p_rec.mat_information1 = hr_api.g_varchar2) then
470: p_rec.mat_information1 :=
471: ssp_mat_shd.g_old_rec.mat_information1;
472: End If;
473: If (p_rec.mat_information1 = hr_api.g_varchar2) then

Line 473: If (p_rec.mat_information1 = hr_api.g_varchar2) then

469: If (p_rec.mat_information1 = hr_api.g_varchar2) then
470: p_rec.mat_information1 :=
471: ssp_mat_shd.g_old_rec.mat_information1;
472: End If;
473: If (p_rec.mat_information1 = hr_api.g_varchar2) then
474: p_rec.mat_information1 :=
475: ssp_mat_shd.g_old_rec.mat_information1;
476: End If;
477: If (p_rec.mat_information2 = hr_api.g_varchar2) then

Line 477: If (p_rec.mat_information2 = hr_api.g_varchar2) then

473: If (p_rec.mat_information1 = hr_api.g_varchar2) then
474: p_rec.mat_information1 :=
475: ssp_mat_shd.g_old_rec.mat_information1;
476: End If;
477: If (p_rec.mat_information2 = hr_api.g_varchar2) then
478: p_rec.mat_information2 :=
479: ssp_mat_shd.g_old_rec.mat_information2;
480: End If;
481: If (p_rec.mat_information3 = hr_api.g_varchar2) then

Line 481: If (p_rec.mat_information3 = hr_api.g_varchar2) then

477: If (p_rec.mat_information2 = hr_api.g_varchar2) then
478: p_rec.mat_information2 :=
479: ssp_mat_shd.g_old_rec.mat_information2;
480: End If;
481: If (p_rec.mat_information3 = hr_api.g_varchar2) then
482: p_rec.mat_information3 :=
483: ssp_mat_shd.g_old_rec.mat_information3;
484: End If;
485: If (p_rec.mat_information4 = hr_api.g_varchar2) then

Line 485: If (p_rec.mat_information4 = hr_api.g_varchar2) then

481: If (p_rec.mat_information3 = hr_api.g_varchar2) then
482: p_rec.mat_information3 :=
483: ssp_mat_shd.g_old_rec.mat_information3;
484: End If;
485: If (p_rec.mat_information4 = hr_api.g_varchar2) then
486: p_rec.mat_information4 :=
487: ssp_mat_shd.g_old_rec.mat_information4;
488: End If;
489: If (p_rec.mat_information5 = hr_api.g_varchar2) then

Line 489: If (p_rec.mat_information5 = hr_api.g_varchar2) then

485: If (p_rec.mat_information4 = hr_api.g_varchar2) then
486: p_rec.mat_information4 :=
487: ssp_mat_shd.g_old_rec.mat_information4;
488: End If;
489: If (p_rec.mat_information5 = hr_api.g_varchar2) then
490: p_rec.mat_information5 :=
491: ssp_mat_shd.g_old_rec.mat_information5;
492: End If;
493: If (p_rec.mat_information6 = hr_api.g_varchar2) then

Line 493: If (p_rec.mat_information6 = hr_api.g_varchar2) then

489: If (p_rec.mat_information5 = hr_api.g_varchar2) then
490: p_rec.mat_information5 :=
491: ssp_mat_shd.g_old_rec.mat_information5;
492: End If;
493: If (p_rec.mat_information6 = hr_api.g_varchar2) then
494: p_rec.mat_information6 :=
495: ssp_mat_shd.g_old_rec.mat_information6;
496: End If;
497: If (p_rec.mat_information7 = hr_api.g_varchar2) then

Line 497: If (p_rec.mat_information7 = hr_api.g_varchar2) then

493: If (p_rec.mat_information6 = hr_api.g_varchar2) then
494: p_rec.mat_information6 :=
495: ssp_mat_shd.g_old_rec.mat_information6;
496: End If;
497: If (p_rec.mat_information7 = hr_api.g_varchar2) then
498: p_rec.mat_information7 :=
499: ssp_mat_shd.g_old_rec.mat_information7;
500: End If;
501: If (p_rec.mat_information8 = hr_api.g_varchar2) then

Line 501: If (p_rec.mat_information8 = hr_api.g_varchar2) then

497: If (p_rec.mat_information7 = hr_api.g_varchar2) then
498: p_rec.mat_information7 :=
499: ssp_mat_shd.g_old_rec.mat_information7;
500: End If;
501: If (p_rec.mat_information8 = hr_api.g_varchar2) then
502: p_rec.mat_information8 :=
503: ssp_mat_shd.g_old_rec.mat_information8;
504: End If;
505: If (p_rec.mat_information9 = hr_api.g_varchar2) then

Line 505: If (p_rec.mat_information9 = hr_api.g_varchar2) then

501: If (p_rec.mat_information8 = hr_api.g_varchar2) then
502: p_rec.mat_information8 :=
503: ssp_mat_shd.g_old_rec.mat_information8;
504: End If;
505: If (p_rec.mat_information9 = hr_api.g_varchar2) then
506: p_rec.mat_information9 :=
507: ssp_mat_shd.g_old_rec.mat_information9;
508: End If;
509: If (p_rec.mat_information10 = hr_api.g_varchar2) then

Line 509: If (p_rec.mat_information10 = hr_api.g_varchar2) then

505: If (p_rec.mat_information9 = hr_api.g_varchar2) then
506: p_rec.mat_information9 :=
507: ssp_mat_shd.g_old_rec.mat_information9;
508: End If;
509: If (p_rec.mat_information10 = hr_api.g_varchar2) then
510: p_rec.mat_information10 :=
511: ssp_mat_shd.g_old_rec.mat_information10;
512: End If;
513: If (p_rec.mat_information11 = hr_api.g_varchar2) then

Line 513: If (p_rec.mat_information11 = hr_api.g_varchar2) then

509: If (p_rec.mat_information10 = hr_api.g_varchar2) then
510: p_rec.mat_information10 :=
511: ssp_mat_shd.g_old_rec.mat_information10;
512: End If;
513: If (p_rec.mat_information11 = hr_api.g_varchar2) then
514: p_rec.mat_information11 :=
515: ssp_mat_shd.g_old_rec.mat_information11;
516: End If;
517: If (p_rec.mat_information12 = hr_api.g_varchar2) then

Line 517: If (p_rec.mat_information12 = hr_api.g_varchar2) then

513: If (p_rec.mat_information11 = hr_api.g_varchar2) then
514: p_rec.mat_information11 :=
515: ssp_mat_shd.g_old_rec.mat_information11;
516: End If;
517: If (p_rec.mat_information12 = hr_api.g_varchar2) then
518: p_rec.mat_information12 :=
519: ssp_mat_shd.g_old_rec.mat_information12;
520: End If;
521: If (p_rec.mat_information13 = hr_api.g_varchar2) then

Line 521: If (p_rec.mat_information13 = hr_api.g_varchar2) then

517: If (p_rec.mat_information12 = hr_api.g_varchar2) then
518: p_rec.mat_information12 :=
519: ssp_mat_shd.g_old_rec.mat_information12;
520: End If;
521: If (p_rec.mat_information13 = hr_api.g_varchar2) then
522: p_rec.mat_information13 :=
523: ssp_mat_shd.g_old_rec.mat_information13;
524: End If;
525: If (p_rec.mat_information14 = hr_api.g_varchar2) then

Line 525: If (p_rec.mat_information14 = hr_api.g_varchar2) then

521: If (p_rec.mat_information13 = hr_api.g_varchar2) then
522: p_rec.mat_information13 :=
523: ssp_mat_shd.g_old_rec.mat_information13;
524: End If;
525: If (p_rec.mat_information14 = hr_api.g_varchar2) then
526: p_rec.mat_information14 :=
527: ssp_mat_shd.g_old_rec.mat_information14;
528: End If;
529: If (p_rec.mat_information15 = hr_api.g_varchar2) then

Line 529: If (p_rec.mat_information15 = hr_api.g_varchar2) then

525: If (p_rec.mat_information14 = hr_api.g_varchar2) then
526: p_rec.mat_information14 :=
527: ssp_mat_shd.g_old_rec.mat_information14;
528: End If;
529: If (p_rec.mat_information15 = hr_api.g_varchar2) then
530: p_rec.mat_information15 :=
531: ssp_mat_shd.g_old_rec.mat_information15;
532: End If;
533: If (p_rec.mat_information16 = hr_api.g_varchar2) then

Line 533: If (p_rec.mat_information16 = hr_api.g_varchar2) then

529: If (p_rec.mat_information15 = hr_api.g_varchar2) then
530: p_rec.mat_information15 :=
531: ssp_mat_shd.g_old_rec.mat_information15;
532: End If;
533: If (p_rec.mat_information16 = hr_api.g_varchar2) then
534: p_rec.mat_information16 :=
535: ssp_mat_shd.g_old_rec.mat_information16;
536: End If;
537: If (p_rec.mat_information17 = hr_api.g_varchar2) then

Line 537: If (p_rec.mat_information17 = hr_api.g_varchar2) then

533: If (p_rec.mat_information16 = hr_api.g_varchar2) then
534: p_rec.mat_information16 :=
535: ssp_mat_shd.g_old_rec.mat_information16;
536: End If;
537: If (p_rec.mat_information17 = hr_api.g_varchar2) then
538: p_rec.mat_information17 :=
539: ssp_mat_shd.g_old_rec.mat_information17;
540: End If;
541: If (p_rec.mat_information18 = hr_api.g_varchar2) then

Line 541: If (p_rec.mat_information18 = hr_api.g_varchar2) then

537: If (p_rec.mat_information17 = hr_api.g_varchar2) then
538: p_rec.mat_information17 :=
539: ssp_mat_shd.g_old_rec.mat_information17;
540: End If;
541: If (p_rec.mat_information18 = hr_api.g_varchar2) then
542: p_rec.mat_information18 :=
543: ssp_mat_shd.g_old_rec.mat_information18;
544: End If;
545: If (p_rec.mat_information19 = hr_api.g_varchar2) then

Line 545: If (p_rec.mat_information19 = hr_api.g_varchar2) then

541: If (p_rec.mat_information18 = hr_api.g_varchar2) then
542: p_rec.mat_information18 :=
543: ssp_mat_shd.g_old_rec.mat_information18;
544: End If;
545: If (p_rec.mat_information19 = hr_api.g_varchar2) then
546: p_rec.mat_information19 :=
547: ssp_mat_shd.g_old_rec.mat_information19;
548: End If;
549: If (p_rec.mat_information20 = hr_api.g_varchar2) then

Line 549: If (p_rec.mat_information20 = hr_api.g_varchar2) then

545: If (p_rec.mat_information19 = hr_api.g_varchar2) then
546: p_rec.mat_information19 :=
547: ssp_mat_shd.g_old_rec.mat_information19;
548: End If;
549: If (p_rec.mat_information20 = hr_api.g_varchar2) then
550: p_rec.mat_information20 :=
551: ssp_mat_shd.g_old_rec.mat_information20;
552: End If;
553: If (p_rec.mat_information21 = hr_api.g_varchar2) then

Line 553: If (p_rec.mat_information21 = hr_api.g_varchar2) then

549: If (p_rec.mat_information20 = hr_api.g_varchar2) then
550: p_rec.mat_information20 :=
551: ssp_mat_shd.g_old_rec.mat_information20;
552: End If;
553: If (p_rec.mat_information21 = hr_api.g_varchar2) then
554: p_rec.mat_information21 :=
555: ssp_mat_shd.g_old_rec.mat_information21;
556: End If;
557: If (p_rec.mat_information22 = hr_api.g_varchar2) then

Line 557: If (p_rec.mat_information22 = hr_api.g_varchar2) then

553: If (p_rec.mat_information21 = hr_api.g_varchar2) then
554: p_rec.mat_information21 :=
555: ssp_mat_shd.g_old_rec.mat_information21;
556: End If;
557: If (p_rec.mat_information22 = hr_api.g_varchar2) then
558: p_rec.mat_information12 :=
559: ssp_mat_shd.g_old_rec.mat_information22;
560: End If;
561: If (p_rec.mat_information23 = hr_api.g_varchar2) then

Line 561: If (p_rec.mat_information23 = hr_api.g_varchar2) then

557: If (p_rec.mat_information22 = hr_api.g_varchar2) then
558: p_rec.mat_information12 :=
559: ssp_mat_shd.g_old_rec.mat_information22;
560: End If;
561: If (p_rec.mat_information23 = hr_api.g_varchar2) then
562: p_rec.mat_information23 :=
563: ssp_mat_shd.g_old_rec.mat_information23;
564: End If;
565: If (p_rec.mat_information24 = hr_api.g_varchar2) then

Line 565: If (p_rec.mat_information24 = hr_api.g_varchar2) then

561: If (p_rec.mat_information23 = hr_api.g_varchar2) then
562: p_rec.mat_information23 :=
563: ssp_mat_shd.g_old_rec.mat_information23;
564: End If;
565: If (p_rec.mat_information24 = hr_api.g_varchar2) then
566: p_rec.mat_information24 :=
567: ssp_mat_shd.g_old_rec.mat_information24;
568: End If;
569: If (p_rec.mat_information25 = hr_api.g_varchar2) then

Line 569: If (p_rec.mat_information25 = hr_api.g_varchar2) then

565: If (p_rec.mat_information24 = hr_api.g_varchar2) then
566: p_rec.mat_information24 :=
567: ssp_mat_shd.g_old_rec.mat_information24;
568: End If;
569: If (p_rec.mat_information25 = hr_api.g_varchar2) then
570: p_rec.mat_information25 :=
571: ssp_mat_shd.g_old_rec.mat_information25;
572: End If;
573: If (p_rec.mat_information26 = hr_api.g_varchar2) then

Line 573: If (p_rec.mat_information26 = hr_api.g_varchar2) then

569: If (p_rec.mat_information25 = hr_api.g_varchar2) then
570: p_rec.mat_information25 :=
571: ssp_mat_shd.g_old_rec.mat_information25;
572: End If;
573: If (p_rec.mat_information26 = hr_api.g_varchar2) then
574: p_rec.mat_information26 :=
575: ssp_mat_shd.g_old_rec.mat_information26;
576: End If;
577: If (p_rec.mat_information27 = hr_api.g_varchar2) then

Line 577: If (p_rec.mat_information27 = hr_api.g_varchar2) then

573: If (p_rec.mat_information26 = hr_api.g_varchar2) then
574: p_rec.mat_information26 :=
575: ssp_mat_shd.g_old_rec.mat_information26;
576: End If;
577: If (p_rec.mat_information27 = hr_api.g_varchar2) then
578: p_rec.mat_information27 :=
579: ssp_mat_shd.g_old_rec.mat_information27;
580: End If;
581: If (p_rec.mat_information28 = hr_api.g_varchar2) then

Line 581: If (p_rec.mat_information28 = hr_api.g_varchar2) then

577: If (p_rec.mat_information27 = hr_api.g_varchar2) then
578: p_rec.mat_information27 :=
579: ssp_mat_shd.g_old_rec.mat_information27;
580: End If;
581: If (p_rec.mat_information28 = hr_api.g_varchar2) then
582: p_rec.mat_information28 :=
583: ssp_mat_shd.g_old_rec.mat_information28;
584: End If;
585: If (p_rec.mat_information29 = hr_api.g_varchar2) then

Line 585: If (p_rec.mat_information29 = hr_api.g_varchar2) then

581: If (p_rec.mat_information28 = hr_api.g_varchar2) then
582: p_rec.mat_information28 :=
583: ssp_mat_shd.g_old_rec.mat_information28;
584: End If;
585: If (p_rec.mat_information29 = hr_api.g_varchar2) then
586: p_rec.mat_information29 :=
587: ssp_mat_shd.g_old_rec.mat_information29;
588: End If;
589: If (p_rec.mat_information30 = hr_api.g_varchar2) then

Line 589: If (p_rec.mat_information30 = hr_api.g_varchar2) then

585: If (p_rec.mat_information29 = hr_api.g_varchar2) then
586: p_rec.mat_information29 :=
587: ssp_mat_shd.g_old_rec.mat_information29;
588: End If;
589: If (p_rec.mat_information30 = hr_api.g_varchar2) then
590: p_rec.mat_information30 :=
591: ssp_mat_shd.g_old_rec.mat_information30;
592: End If;
593: --

Line 653: Raise HR_Api.Validate_Enabled;

649: --
650: -- If we are validating then raise the Validate_Enabled exception
651: --
652: If p_validate then
653: Raise HR_Api.Validate_Enabled;
654: End If;
655: --
656: hr_utility.set_location(' Leaving:'||l_proc, 10);
657: Exception

Line 658: When HR_Api.Validate_Enabled Then

654: End If;
655: --
656: hr_utility.set_location(' Leaving:'||l_proc, 10);
657: Exception
658: When HR_Api.Validate_Enabled Then
659: --
660: -- As the Validate_Enabled exception has been raised
661: -- we must rollback to the savepoint
662: --

Line 673: p_due_date in date default hr_api.g_date,

669: Procedure upd
670: (
671: p_maternity_id in number,
672: p_object_version_number in out nocopy number,
673: p_due_date in date default hr_api.g_date,
674: p_start_date_SMA in date default hr_api.g_date,
675: p_notification_of_birth_date in date default hr_api.g_date,
676: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
677: p_stated_return_date in date default hr_api.g_date,

Line 674: p_start_date_SMA in date default hr_api.g_date,

670: (
671: p_maternity_id in number,
672: p_object_version_number in out nocopy number,
673: p_due_date in date default hr_api.g_date,
674: p_start_date_SMA in date default hr_api.g_date,
675: p_notification_of_birth_date in date default hr_api.g_date,
676: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
677: p_stated_return_date in date default hr_api.g_date,
678: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,

Line 675: p_notification_of_birth_date in date default hr_api.g_date,

671: p_maternity_id in number,
672: p_object_version_number in out nocopy number,
673: p_due_date in date default hr_api.g_date,
674: p_start_date_SMA in date default hr_api.g_date,
675: p_notification_of_birth_date in date default hr_api.g_date,
676: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
677: p_stated_return_date in date default hr_api.g_date,
678: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
679: p_start_date_with_new_employer in date default hr_api.g_date,

Line 676: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,

672: p_object_version_number in out nocopy number,
673: p_due_date in date default hr_api.g_date,
674: p_start_date_SMA in date default hr_api.g_date,
675: p_notification_of_birth_date in date default hr_api.g_date,
676: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
677: p_stated_return_date in date default hr_api.g_date,
678: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
679: p_start_date_with_new_employer in date default hr_api.g_date,
680: p_smp_must_be_paid_by_date in date default hr_api.g_date,

Line 677: p_stated_return_date in date default hr_api.g_date,

673: p_due_date in date default hr_api.g_date,
674: p_start_date_SMA in date default hr_api.g_date,
675: p_notification_of_birth_date in date default hr_api.g_date,
676: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
677: p_stated_return_date in date default hr_api.g_date,
678: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
679: p_start_date_with_new_employer in date default hr_api.g_date,
680: p_smp_must_be_paid_by_date in date default hr_api.g_date,
681: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,

Line 678: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,

674: p_start_date_SMA in date default hr_api.g_date,
675: p_notification_of_birth_date in date default hr_api.g_date,
676: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
677: p_stated_return_date in date default hr_api.g_date,
678: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
679: p_start_date_with_new_employer in date default hr_api.g_date,
680: p_smp_must_be_paid_by_date in date default hr_api.g_date,
681: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
682: p_live_birth_flag in varchar2 default hr_api.g_varchar2,

Line 679: p_start_date_with_new_employer in date default hr_api.g_date,

675: p_notification_of_birth_date in date default hr_api.g_date,
676: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
677: p_stated_return_date in date default hr_api.g_date,
678: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
679: p_start_date_with_new_employer in date default hr_api.g_date,
680: p_smp_must_be_paid_by_date in date default hr_api.g_date,
681: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
682: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
683: p_actual_birth_date in date default hr_api.g_date,

Line 680: p_smp_must_be_paid_by_date in date default hr_api.g_date,

676: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
677: p_stated_return_date in date default hr_api.g_date,
678: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
679: p_start_date_with_new_employer in date default hr_api.g_date,
680: p_smp_must_be_paid_by_date in date default hr_api.g_date,
681: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
682: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
683: p_actual_birth_date in date default hr_api.g_date,
684: p_mpp_start_date in date default hr_api.g_date,

Line 681: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,

677: p_stated_return_date in date default hr_api.g_date,
678: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
679: p_start_date_with_new_employer in date default hr_api.g_date,
680: p_smp_must_be_paid_by_date in date default hr_api.g_date,
681: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
682: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
683: p_actual_birth_date in date default hr_api.g_date,
684: p_mpp_start_date in date default hr_api.g_date,
685: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 682: p_live_birth_flag in varchar2 default hr_api.g_varchar2,

678: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
679: p_start_date_with_new_employer in date default hr_api.g_date,
680: p_smp_must_be_paid_by_date in date default hr_api.g_date,
681: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
682: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
683: p_actual_birth_date in date default hr_api.g_date,
684: p_mpp_start_date in date default hr_api.g_date,
685: p_attribute_category in varchar2 default hr_api.g_varchar2,
686: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 683: p_actual_birth_date in date default hr_api.g_date,

679: p_start_date_with_new_employer in date default hr_api.g_date,
680: p_smp_must_be_paid_by_date in date default hr_api.g_date,
681: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
682: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
683: p_actual_birth_date in date default hr_api.g_date,
684: p_mpp_start_date in date default hr_api.g_date,
685: p_attribute_category in varchar2 default hr_api.g_varchar2,
686: p_attribute1 in varchar2 default hr_api.g_varchar2,
687: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 684: p_mpp_start_date in date default hr_api.g_date,

680: p_smp_must_be_paid_by_date in date default hr_api.g_date,
681: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
682: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
683: p_actual_birth_date in date default hr_api.g_date,
684: p_mpp_start_date in date default hr_api.g_date,
685: p_attribute_category in varchar2 default hr_api.g_varchar2,
686: p_attribute1 in varchar2 default hr_api.g_varchar2,
687: p_attribute2 in varchar2 default hr_api.g_varchar2,
688: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 685: p_attribute_category in varchar2 default hr_api.g_varchar2,

681: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
682: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
683: p_actual_birth_date in date default hr_api.g_date,
684: p_mpp_start_date in date default hr_api.g_date,
685: p_attribute_category in varchar2 default hr_api.g_varchar2,
686: p_attribute1 in varchar2 default hr_api.g_varchar2,
687: p_attribute2 in varchar2 default hr_api.g_varchar2,
688: p_attribute3 in varchar2 default hr_api.g_varchar2,
689: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 686: p_attribute1 in varchar2 default hr_api.g_varchar2,

682: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
683: p_actual_birth_date in date default hr_api.g_date,
684: p_mpp_start_date in date default hr_api.g_date,
685: p_attribute_category in varchar2 default hr_api.g_varchar2,
686: p_attribute1 in varchar2 default hr_api.g_varchar2,
687: p_attribute2 in varchar2 default hr_api.g_varchar2,
688: p_attribute3 in varchar2 default hr_api.g_varchar2,
689: p_attribute4 in varchar2 default hr_api.g_varchar2,
690: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 687: p_attribute2 in varchar2 default hr_api.g_varchar2,

683: p_actual_birth_date in date default hr_api.g_date,
684: p_mpp_start_date in date default hr_api.g_date,
685: p_attribute_category in varchar2 default hr_api.g_varchar2,
686: p_attribute1 in varchar2 default hr_api.g_varchar2,
687: p_attribute2 in varchar2 default hr_api.g_varchar2,
688: p_attribute3 in varchar2 default hr_api.g_varchar2,
689: p_attribute4 in varchar2 default hr_api.g_varchar2,
690: p_attribute5 in varchar2 default hr_api.g_varchar2,
691: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 688: p_attribute3 in varchar2 default hr_api.g_varchar2,

684: p_mpp_start_date in date default hr_api.g_date,
685: p_attribute_category in varchar2 default hr_api.g_varchar2,
686: p_attribute1 in varchar2 default hr_api.g_varchar2,
687: p_attribute2 in varchar2 default hr_api.g_varchar2,
688: p_attribute3 in varchar2 default hr_api.g_varchar2,
689: p_attribute4 in varchar2 default hr_api.g_varchar2,
690: p_attribute5 in varchar2 default hr_api.g_varchar2,
691: p_attribute6 in varchar2 default hr_api.g_varchar2,
692: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 689: p_attribute4 in varchar2 default hr_api.g_varchar2,

685: p_attribute_category in varchar2 default hr_api.g_varchar2,
686: p_attribute1 in varchar2 default hr_api.g_varchar2,
687: p_attribute2 in varchar2 default hr_api.g_varchar2,
688: p_attribute3 in varchar2 default hr_api.g_varchar2,
689: p_attribute4 in varchar2 default hr_api.g_varchar2,
690: p_attribute5 in varchar2 default hr_api.g_varchar2,
691: p_attribute6 in varchar2 default hr_api.g_varchar2,
692: p_attribute7 in varchar2 default hr_api.g_varchar2,
693: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 690: p_attribute5 in varchar2 default hr_api.g_varchar2,

686: p_attribute1 in varchar2 default hr_api.g_varchar2,
687: p_attribute2 in varchar2 default hr_api.g_varchar2,
688: p_attribute3 in varchar2 default hr_api.g_varchar2,
689: p_attribute4 in varchar2 default hr_api.g_varchar2,
690: p_attribute5 in varchar2 default hr_api.g_varchar2,
691: p_attribute6 in varchar2 default hr_api.g_varchar2,
692: p_attribute7 in varchar2 default hr_api.g_varchar2,
693: p_attribute8 in varchar2 default hr_api.g_varchar2,
694: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 691: p_attribute6 in varchar2 default hr_api.g_varchar2,

687: p_attribute2 in varchar2 default hr_api.g_varchar2,
688: p_attribute3 in varchar2 default hr_api.g_varchar2,
689: p_attribute4 in varchar2 default hr_api.g_varchar2,
690: p_attribute5 in varchar2 default hr_api.g_varchar2,
691: p_attribute6 in varchar2 default hr_api.g_varchar2,
692: p_attribute7 in varchar2 default hr_api.g_varchar2,
693: p_attribute8 in varchar2 default hr_api.g_varchar2,
694: p_attribute9 in varchar2 default hr_api.g_varchar2,
695: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 692: p_attribute7 in varchar2 default hr_api.g_varchar2,

688: p_attribute3 in varchar2 default hr_api.g_varchar2,
689: p_attribute4 in varchar2 default hr_api.g_varchar2,
690: p_attribute5 in varchar2 default hr_api.g_varchar2,
691: p_attribute6 in varchar2 default hr_api.g_varchar2,
692: p_attribute7 in varchar2 default hr_api.g_varchar2,
693: p_attribute8 in varchar2 default hr_api.g_varchar2,
694: p_attribute9 in varchar2 default hr_api.g_varchar2,
695: p_attribute10 in varchar2 default hr_api.g_varchar2,
696: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 693: p_attribute8 in varchar2 default hr_api.g_varchar2,

689: p_attribute4 in varchar2 default hr_api.g_varchar2,
690: p_attribute5 in varchar2 default hr_api.g_varchar2,
691: p_attribute6 in varchar2 default hr_api.g_varchar2,
692: p_attribute7 in varchar2 default hr_api.g_varchar2,
693: p_attribute8 in varchar2 default hr_api.g_varchar2,
694: p_attribute9 in varchar2 default hr_api.g_varchar2,
695: p_attribute10 in varchar2 default hr_api.g_varchar2,
696: p_attribute11 in varchar2 default hr_api.g_varchar2,
697: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 694: p_attribute9 in varchar2 default hr_api.g_varchar2,

690: p_attribute5 in varchar2 default hr_api.g_varchar2,
691: p_attribute6 in varchar2 default hr_api.g_varchar2,
692: p_attribute7 in varchar2 default hr_api.g_varchar2,
693: p_attribute8 in varchar2 default hr_api.g_varchar2,
694: p_attribute9 in varchar2 default hr_api.g_varchar2,
695: p_attribute10 in varchar2 default hr_api.g_varchar2,
696: p_attribute11 in varchar2 default hr_api.g_varchar2,
697: p_attribute12 in varchar2 default hr_api.g_varchar2,
698: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 695: p_attribute10 in varchar2 default hr_api.g_varchar2,

691: p_attribute6 in varchar2 default hr_api.g_varchar2,
692: p_attribute7 in varchar2 default hr_api.g_varchar2,
693: p_attribute8 in varchar2 default hr_api.g_varchar2,
694: p_attribute9 in varchar2 default hr_api.g_varchar2,
695: p_attribute10 in varchar2 default hr_api.g_varchar2,
696: p_attribute11 in varchar2 default hr_api.g_varchar2,
697: p_attribute12 in varchar2 default hr_api.g_varchar2,
698: p_attribute13 in varchar2 default hr_api.g_varchar2,
699: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 696: p_attribute11 in varchar2 default hr_api.g_varchar2,

692: p_attribute7 in varchar2 default hr_api.g_varchar2,
693: p_attribute8 in varchar2 default hr_api.g_varchar2,
694: p_attribute9 in varchar2 default hr_api.g_varchar2,
695: p_attribute10 in varchar2 default hr_api.g_varchar2,
696: p_attribute11 in varchar2 default hr_api.g_varchar2,
697: p_attribute12 in varchar2 default hr_api.g_varchar2,
698: p_attribute13 in varchar2 default hr_api.g_varchar2,
699: p_attribute14 in varchar2 default hr_api.g_varchar2,
700: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 697: p_attribute12 in varchar2 default hr_api.g_varchar2,

693: p_attribute8 in varchar2 default hr_api.g_varchar2,
694: p_attribute9 in varchar2 default hr_api.g_varchar2,
695: p_attribute10 in varchar2 default hr_api.g_varchar2,
696: p_attribute11 in varchar2 default hr_api.g_varchar2,
697: p_attribute12 in varchar2 default hr_api.g_varchar2,
698: p_attribute13 in varchar2 default hr_api.g_varchar2,
699: p_attribute14 in varchar2 default hr_api.g_varchar2,
700: p_attribute15 in varchar2 default hr_api.g_varchar2,
701: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 698: p_attribute13 in varchar2 default hr_api.g_varchar2,

694: p_attribute9 in varchar2 default hr_api.g_varchar2,
695: p_attribute10 in varchar2 default hr_api.g_varchar2,
696: p_attribute11 in varchar2 default hr_api.g_varchar2,
697: p_attribute12 in varchar2 default hr_api.g_varchar2,
698: p_attribute13 in varchar2 default hr_api.g_varchar2,
699: p_attribute14 in varchar2 default hr_api.g_varchar2,
700: p_attribute15 in varchar2 default hr_api.g_varchar2,
701: p_attribute16 in varchar2 default hr_api.g_varchar2,
702: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 699: p_attribute14 in varchar2 default hr_api.g_varchar2,

695: p_attribute10 in varchar2 default hr_api.g_varchar2,
696: p_attribute11 in varchar2 default hr_api.g_varchar2,
697: p_attribute12 in varchar2 default hr_api.g_varchar2,
698: p_attribute13 in varchar2 default hr_api.g_varchar2,
699: p_attribute14 in varchar2 default hr_api.g_varchar2,
700: p_attribute15 in varchar2 default hr_api.g_varchar2,
701: p_attribute16 in varchar2 default hr_api.g_varchar2,
702: p_attribute17 in varchar2 default hr_api.g_varchar2,
703: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 700: p_attribute15 in varchar2 default hr_api.g_varchar2,

696: p_attribute11 in varchar2 default hr_api.g_varchar2,
697: p_attribute12 in varchar2 default hr_api.g_varchar2,
698: p_attribute13 in varchar2 default hr_api.g_varchar2,
699: p_attribute14 in varchar2 default hr_api.g_varchar2,
700: p_attribute15 in varchar2 default hr_api.g_varchar2,
701: p_attribute16 in varchar2 default hr_api.g_varchar2,
702: p_attribute17 in varchar2 default hr_api.g_varchar2,
703: p_attribute18 in varchar2 default hr_api.g_varchar2,
704: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 701: p_attribute16 in varchar2 default hr_api.g_varchar2,

697: p_attribute12 in varchar2 default hr_api.g_varchar2,
698: p_attribute13 in varchar2 default hr_api.g_varchar2,
699: p_attribute14 in varchar2 default hr_api.g_varchar2,
700: p_attribute15 in varchar2 default hr_api.g_varchar2,
701: p_attribute16 in varchar2 default hr_api.g_varchar2,
702: p_attribute17 in varchar2 default hr_api.g_varchar2,
703: p_attribute18 in varchar2 default hr_api.g_varchar2,
704: p_attribute19 in varchar2 default hr_api.g_varchar2,
705: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 702: p_attribute17 in varchar2 default hr_api.g_varchar2,

698: p_attribute13 in varchar2 default hr_api.g_varchar2,
699: p_attribute14 in varchar2 default hr_api.g_varchar2,
700: p_attribute15 in varchar2 default hr_api.g_varchar2,
701: p_attribute16 in varchar2 default hr_api.g_varchar2,
702: p_attribute17 in varchar2 default hr_api.g_varchar2,
703: p_attribute18 in varchar2 default hr_api.g_varchar2,
704: p_attribute19 in varchar2 default hr_api.g_varchar2,
705: p_attribute20 in varchar2 default hr_api.g_varchar2,
706: p_LEAVE_TYPE in VARCHAR2 default 'MA',

Line 703: p_attribute18 in varchar2 default hr_api.g_varchar2,

699: p_attribute14 in varchar2 default hr_api.g_varchar2,
700: p_attribute15 in varchar2 default hr_api.g_varchar2,
701: p_attribute16 in varchar2 default hr_api.g_varchar2,
702: p_attribute17 in varchar2 default hr_api.g_varchar2,
703: p_attribute18 in varchar2 default hr_api.g_varchar2,
704: p_attribute19 in varchar2 default hr_api.g_varchar2,
705: p_attribute20 in varchar2 default hr_api.g_varchar2,
706: p_LEAVE_TYPE in VARCHAR2 default 'MA',
707: p_MATCHING_DATE in DATE default hr_api.g_date,

Line 704: p_attribute19 in varchar2 default hr_api.g_varchar2,

700: p_attribute15 in varchar2 default hr_api.g_varchar2,
701: p_attribute16 in varchar2 default hr_api.g_varchar2,
702: p_attribute17 in varchar2 default hr_api.g_varchar2,
703: p_attribute18 in varchar2 default hr_api.g_varchar2,
704: p_attribute19 in varchar2 default hr_api.g_varchar2,
705: p_attribute20 in varchar2 default hr_api.g_varchar2,
706: p_LEAVE_TYPE in VARCHAR2 default 'MA',
707: p_MATCHING_DATE in DATE default hr_api.g_date,
708: p_PLACEMENT_DATE in DATE default hr_api.g_date,

Line 705: p_attribute20 in varchar2 default hr_api.g_varchar2,

701: p_attribute16 in varchar2 default hr_api.g_varchar2,
702: p_attribute17 in varchar2 default hr_api.g_varchar2,
703: p_attribute18 in varchar2 default hr_api.g_varchar2,
704: p_attribute19 in varchar2 default hr_api.g_varchar2,
705: p_attribute20 in varchar2 default hr_api.g_varchar2,
706: p_LEAVE_TYPE in VARCHAR2 default 'MA',
707: p_MATCHING_DATE in DATE default hr_api.g_date,
708: p_PLACEMENT_DATE in DATE default hr_api.g_date,
709: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,

Line 707: p_MATCHING_DATE in DATE default hr_api.g_date,

703: p_attribute18 in varchar2 default hr_api.g_varchar2,
704: p_attribute19 in varchar2 default hr_api.g_varchar2,
705: p_attribute20 in varchar2 default hr_api.g_varchar2,
706: p_LEAVE_TYPE in VARCHAR2 default 'MA',
707: p_MATCHING_DATE in DATE default hr_api.g_date,
708: p_PLACEMENT_DATE in DATE default hr_api.g_date,
709: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
710: p_validate in boolean default false,
711: p_mat_information_category in varchar2 default hr_api.g_varchar2,

Line 708: p_PLACEMENT_DATE in DATE default hr_api.g_date,

704: p_attribute19 in varchar2 default hr_api.g_varchar2,
705: p_attribute20 in varchar2 default hr_api.g_varchar2,
706: p_LEAVE_TYPE in VARCHAR2 default 'MA',
707: p_MATCHING_DATE in DATE default hr_api.g_date,
708: p_PLACEMENT_DATE in DATE default hr_api.g_date,
709: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
710: p_validate in boolean default false,
711: p_mat_information_category in varchar2 default hr_api.g_varchar2,
712: p_mat_information1 in varchar2 default hr_api.g_varchar2,

Line 709: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,

705: p_attribute20 in varchar2 default hr_api.g_varchar2,
706: p_LEAVE_TYPE in VARCHAR2 default 'MA',
707: p_MATCHING_DATE in DATE default hr_api.g_date,
708: p_PLACEMENT_DATE in DATE default hr_api.g_date,
709: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
710: p_validate in boolean default false,
711: p_mat_information_category in varchar2 default hr_api.g_varchar2,
712: p_mat_information1 in varchar2 default hr_api.g_varchar2,
713: p_mat_information2 in varchar2 default hr_api.g_varchar2,

Line 711: p_mat_information_category in varchar2 default hr_api.g_varchar2,

707: p_MATCHING_DATE in DATE default hr_api.g_date,
708: p_PLACEMENT_DATE in DATE default hr_api.g_date,
709: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
710: p_validate in boolean default false,
711: p_mat_information_category in varchar2 default hr_api.g_varchar2,
712: p_mat_information1 in varchar2 default hr_api.g_varchar2,
713: p_mat_information2 in varchar2 default hr_api.g_varchar2,
714: p_mat_information3 in varchar2 default hr_api.g_varchar2,
715: p_mat_information4 in varchar2 default hr_api.g_varchar2,

Line 712: p_mat_information1 in varchar2 default hr_api.g_varchar2,

708: p_PLACEMENT_DATE in DATE default hr_api.g_date,
709: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
710: p_validate in boolean default false,
711: p_mat_information_category in varchar2 default hr_api.g_varchar2,
712: p_mat_information1 in varchar2 default hr_api.g_varchar2,
713: p_mat_information2 in varchar2 default hr_api.g_varchar2,
714: p_mat_information3 in varchar2 default hr_api.g_varchar2,
715: p_mat_information4 in varchar2 default hr_api.g_varchar2,
716: p_mat_information5 in varchar2 default hr_api.g_varchar2,

Line 713: p_mat_information2 in varchar2 default hr_api.g_varchar2,

709: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
710: p_validate in boolean default false,
711: p_mat_information_category in varchar2 default hr_api.g_varchar2,
712: p_mat_information1 in varchar2 default hr_api.g_varchar2,
713: p_mat_information2 in varchar2 default hr_api.g_varchar2,
714: p_mat_information3 in varchar2 default hr_api.g_varchar2,
715: p_mat_information4 in varchar2 default hr_api.g_varchar2,
716: p_mat_information5 in varchar2 default hr_api.g_varchar2,
717: p_mat_information6 in varchar2 default hr_api.g_varchar2,

Line 714: p_mat_information3 in varchar2 default hr_api.g_varchar2,

710: p_validate in boolean default false,
711: p_mat_information_category in varchar2 default hr_api.g_varchar2,
712: p_mat_information1 in varchar2 default hr_api.g_varchar2,
713: p_mat_information2 in varchar2 default hr_api.g_varchar2,
714: p_mat_information3 in varchar2 default hr_api.g_varchar2,
715: p_mat_information4 in varchar2 default hr_api.g_varchar2,
716: p_mat_information5 in varchar2 default hr_api.g_varchar2,
717: p_mat_information6 in varchar2 default hr_api.g_varchar2,
718: p_mat_information7 in varchar2 default hr_api.g_varchar2,

Line 715: p_mat_information4 in varchar2 default hr_api.g_varchar2,

711: p_mat_information_category in varchar2 default hr_api.g_varchar2,
712: p_mat_information1 in varchar2 default hr_api.g_varchar2,
713: p_mat_information2 in varchar2 default hr_api.g_varchar2,
714: p_mat_information3 in varchar2 default hr_api.g_varchar2,
715: p_mat_information4 in varchar2 default hr_api.g_varchar2,
716: p_mat_information5 in varchar2 default hr_api.g_varchar2,
717: p_mat_information6 in varchar2 default hr_api.g_varchar2,
718: p_mat_information7 in varchar2 default hr_api.g_varchar2,
719: p_mat_information8 in varchar2 default hr_api.g_varchar2,

Line 716: p_mat_information5 in varchar2 default hr_api.g_varchar2,

712: p_mat_information1 in varchar2 default hr_api.g_varchar2,
713: p_mat_information2 in varchar2 default hr_api.g_varchar2,
714: p_mat_information3 in varchar2 default hr_api.g_varchar2,
715: p_mat_information4 in varchar2 default hr_api.g_varchar2,
716: p_mat_information5 in varchar2 default hr_api.g_varchar2,
717: p_mat_information6 in varchar2 default hr_api.g_varchar2,
718: p_mat_information7 in varchar2 default hr_api.g_varchar2,
719: p_mat_information8 in varchar2 default hr_api.g_varchar2,
720: p_mat_information9 in varchar2 default hr_api.g_varchar2,

Line 717: p_mat_information6 in varchar2 default hr_api.g_varchar2,

713: p_mat_information2 in varchar2 default hr_api.g_varchar2,
714: p_mat_information3 in varchar2 default hr_api.g_varchar2,
715: p_mat_information4 in varchar2 default hr_api.g_varchar2,
716: p_mat_information5 in varchar2 default hr_api.g_varchar2,
717: p_mat_information6 in varchar2 default hr_api.g_varchar2,
718: p_mat_information7 in varchar2 default hr_api.g_varchar2,
719: p_mat_information8 in varchar2 default hr_api.g_varchar2,
720: p_mat_information9 in varchar2 default hr_api.g_varchar2,
721: p_mat_information10 in varchar2 default hr_api.g_varchar2,

Line 718: p_mat_information7 in varchar2 default hr_api.g_varchar2,

714: p_mat_information3 in varchar2 default hr_api.g_varchar2,
715: p_mat_information4 in varchar2 default hr_api.g_varchar2,
716: p_mat_information5 in varchar2 default hr_api.g_varchar2,
717: p_mat_information6 in varchar2 default hr_api.g_varchar2,
718: p_mat_information7 in varchar2 default hr_api.g_varchar2,
719: p_mat_information8 in varchar2 default hr_api.g_varchar2,
720: p_mat_information9 in varchar2 default hr_api.g_varchar2,
721: p_mat_information10 in varchar2 default hr_api.g_varchar2,
722: p_mat_information11 in varchar2 default hr_api.g_varchar2,

Line 719: p_mat_information8 in varchar2 default hr_api.g_varchar2,

715: p_mat_information4 in varchar2 default hr_api.g_varchar2,
716: p_mat_information5 in varchar2 default hr_api.g_varchar2,
717: p_mat_information6 in varchar2 default hr_api.g_varchar2,
718: p_mat_information7 in varchar2 default hr_api.g_varchar2,
719: p_mat_information8 in varchar2 default hr_api.g_varchar2,
720: p_mat_information9 in varchar2 default hr_api.g_varchar2,
721: p_mat_information10 in varchar2 default hr_api.g_varchar2,
722: p_mat_information11 in varchar2 default hr_api.g_varchar2,
723: p_mat_information12 in varchar2 default hr_api.g_varchar2,

Line 720: p_mat_information9 in varchar2 default hr_api.g_varchar2,

716: p_mat_information5 in varchar2 default hr_api.g_varchar2,
717: p_mat_information6 in varchar2 default hr_api.g_varchar2,
718: p_mat_information7 in varchar2 default hr_api.g_varchar2,
719: p_mat_information8 in varchar2 default hr_api.g_varchar2,
720: p_mat_information9 in varchar2 default hr_api.g_varchar2,
721: p_mat_information10 in varchar2 default hr_api.g_varchar2,
722: p_mat_information11 in varchar2 default hr_api.g_varchar2,
723: p_mat_information12 in varchar2 default hr_api.g_varchar2,
724: p_mat_information13 in varchar2 default hr_api.g_varchar2,

Line 721: p_mat_information10 in varchar2 default hr_api.g_varchar2,

717: p_mat_information6 in varchar2 default hr_api.g_varchar2,
718: p_mat_information7 in varchar2 default hr_api.g_varchar2,
719: p_mat_information8 in varchar2 default hr_api.g_varchar2,
720: p_mat_information9 in varchar2 default hr_api.g_varchar2,
721: p_mat_information10 in varchar2 default hr_api.g_varchar2,
722: p_mat_information11 in varchar2 default hr_api.g_varchar2,
723: p_mat_information12 in varchar2 default hr_api.g_varchar2,
724: p_mat_information13 in varchar2 default hr_api.g_varchar2,
725: p_mat_information14 in varchar2 default hr_api.g_varchar2,

Line 722: p_mat_information11 in varchar2 default hr_api.g_varchar2,

718: p_mat_information7 in varchar2 default hr_api.g_varchar2,
719: p_mat_information8 in varchar2 default hr_api.g_varchar2,
720: p_mat_information9 in varchar2 default hr_api.g_varchar2,
721: p_mat_information10 in varchar2 default hr_api.g_varchar2,
722: p_mat_information11 in varchar2 default hr_api.g_varchar2,
723: p_mat_information12 in varchar2 default hr_api.g_varchar2,
724: p_mat_information13 in varchar2 default hr_api.g_varchar2,
725: p_mat_information14 in varchar2 default hr_api.g_varchar2,
726: p_mat_information15 in varchar2 default hr_api.g_varchar2,

Line 723: p_mat_information12 in varchar2 default hr_api.g_varchar2,

719: p_mat_information8 in varchar2 default hr_api.g_varchar2,
720: p_mat_information9 in varchar2 default hr_api.g_varchar2,
721: p_mat_information10 in varchar2 default hr_api.g_varchar2,
722: p_mat_information11 in varchar2 default hr_api.g_varchar2,
723: p_mat_information12 in varchar2 default hr_api.g_varchar2,
724: p_mat_information13 in varchar2 default hr_api.g_varchar2,
725: p_mat_information14 in varchar2 default hr_api.g_varchar2,
726: p_mat_information15 in varchar2 default hr_api.g_varchar2,
727: p_mat_information16 in varchar2 default hr_api.g_varchar2,

Line 724: p_mat_information13 in varchar2 default hr_api.g_varchar2,

720: p_mat_information9 in varchar2 default hr_api.g_varchar2,
721: p_mat_information10 in varchar2 default hr_api.g_varchar2,
722: p_mat_information11 in varchar2 default hr_api.g_varchar2,
723: p_mat_information12 in varchar2 default hr_api.g_varchar2,
724: p_mat_information13 in varchar2 default hr_api.g_varchar2,
725: p_mat_information14 in varchar2 default hr_api.g_varchar2,
726: p_mat_information15 in varchar2 default hr_api.g_varchar2,
727: p_mat_information16 in varchar2 default hr_api.g_varchar2,
728: p_mat_information17 in varchar2 default hr_api.g_varchar2,

Line 725: p_mat_information14 in varchar2 default hr_api.g_varchar2,

721: p_mat_information10 in varchar2 default hr_api.g_varchar2,
722: p_mat_information11 in varchar2 default hr_api.g_varchar2,
723: p_mat_information12 in varchar2 default hr_api.g_varchar2,
724: p_mat_information13 in varchar2 default hr_api.g_varchar2,
725: p_mat_information14 in varchar2 default hr_api.g_varchar2,
726: p_mat_information15 in varchar2 default hr_api.g_varchar2,
727: p_mat_information16 in varchar2 default hr_api.g_varchar2,
728: p_mat_information17 in varchar2 default hr_api.g_varchar2,
729: p_mat_information18 in varchar2 default hr_api.g_varchar2,

Line 726: p_mat_information15 in varchar2 default hr_api.g_varchar2,

722: p_mat_information11 in varchar2 default hr_api.g_varchar2,
723: p_mat_information12 in varchar2 default hr_api.g_varchar2,
724: p_mat_information13 in varchar2 default hr_api.g_varchar2,
725: p_mat_information14 in varchar2 default hr_api.g_varchar2,
726: p_mat_information15 in varchar2 default hr_api.g_varchar2,
727: p_mat_information16 in varchar2 default hr_api.g_varchar2,
728: p_mat_information17 in varchar2 default hr_api.g_varchar2,
729: p_mat_information18 in varchar2 default hr_api.g_varchar2,
730: p_mat_information19 in varchar2 default hr_api.g_varchar2,

Line 727: p_mat_information16 in varchar2 default hr_api.g_varchar2,

723: p_mat_information12 in varchar2 default hr_api.g_varchar2,
724: p_mat_information13 in varchar2 default hr_api.g_varchar2,
725: p_mat_information14 in varchar2 default hr_api.g_varchar2,
726: p_mat_information15 in varchar2 default hr_api.g_varchar2,
727: p_mat_information16 in varchar2 default hr_api.g_varchar2,
728: p_mat_information17 in varchar2 default hr_api.g_varchar2,
729: p_mat_information18 in varchar2 default hr_api.g_varchar2,
730: p_mat_information19 in varchar2 default hr_api.g_varchar2,
731: p_mat_information20 in varchar2 default hr_api.g_varchar2,

Line 728: p_mat_information17 in varchar2 default hr_api.g_varchar2,

724: p_mat_information13 in varchar2 default hr_api.g_varchar2,
725: p_mat_information14 in varchar2 default hr_api.g_varchar2,
726: p_mat_information15 in varchar2 default hr_api.g_varchar2,
727: p_mat_information16 in varchar2 default hr_api.g_varchar2,
728: p_mat_information17 in varchar2 default hr_api.g_varchar2,
729: p_mat_information18 in varchar2 default hr_api.g_varchar2,
730: p_mat_information19 in varchar2 default hr_api.g_varchar2,
731: p_mat_information20 in varchar2 default hr_api.g_varchar2,
732: p_mat_information21 in varchar2 default hr_api.g_varchar2,

Line 729: p_mat_information18 in varchar2 default hr_api.g_varchar2,

725: p_mat_information14 in varchar2 default hr_api.g_varchar2,
726: p_mat_information15 in varchar2 default hr_api.g_varchar2,
727: p_mat_information16 in varchar2 default hr_api.g_varchar2,
728: p_mat_information17 in varchar2 default hr_api.g_varchar2,
729: p_mat_information18 in varchar2 default hr_api.g_varchar2,
730: p_mat_information19 in varchar2 default hr_api.g_varchar2,
731: p_mat_information20 in varchar2 default hr_api.g_varchar2,
732: p_mat_information21 in varchar2 default hr_api.g_varchar2,
733: p_mat_information22 in varchar2 default hr_api.g_varchar2,

Line 730: p_mat_information19 in varchar2 default hr_api.g_varchar2,

726: p_mat_information15 in varchar2 default hr_api.g_varchar2,
727: p_mat_information16 in varchar2 default hr_api.g_varchar2,
728: p_mat_information17 in varchar2 default hr_api.g_varchar2,
729: p_mat_information18 in varchar2 default hr_api.g_varchar2,
730: p_mat_information19 in varchar2 default hr_api.g_varchar2,
731: p_mat_information20 in varchar2 default hr_api.g_varchar2,
732: p_mat_information21 in varchar2 default hr_api.g_varchar2,
733: p_mat_information22 in varchar2 default hr_api.g_varchar2,
734: p_mat_information23 in varchar2 default hr_api.g_varchar2,

Line 731: p_mat_information20 in varchar2 default hr_api.g_varchar2,

727: p_mat_information16 in varchar2 default hr_api.g_varchar2,
728: p_mat_information17 in varchar2 default hr_api.g_varchar2,
729: p_mat_information18 in varchar2 default hr_api.g_varchar2,
730: p_mat_information19 in varchar2 default hr_api.g_varchar2,
731: p_mat_information20 in varchar2 default hr_api.g_varchar2,
732: p_mat_information21 in varchar2 default hr_api.g_varchar2,
733: p_mat_information22 in varchar2 default hr_api.g_varchar2,
734: p_mat_information23 in varchar2 default hr_api.g_varchar2,
735: p_mat_information24 in varchar2 default hr_api.g_varchar2,

Line 732: p_mat_information21 in varchar2 default hr_api.g_varchar2,

728: p_mat_information17 in varchar2 default hr_api.g_varchar2,
729: p_mat_information18 in varchar2 default hr_api.g_varchar2,
730: p_mat_information19 in varchar2 default hr_api.g_varchar2,
731: p_mat_information20 in varchar2 default hr_api.g_varchar2,
732: p_mat_information21 in varchar2 default hr_api.g_varchar2,
733: p_mat_information22 in varchar2 default hr_api.g_varchar2,
734: p_mat_information23 in varchar2 default hr_api.g_varchar2,
735: p_mat_information24 in varchar2 default hr_api.g_varchar2,
736: p_mat_information25 in varchar2 default hr_api.g_varchar2,

Line 733: p_mat_information22 in varchar2 default hr_api.g_varchar2,

729: p_mat_information18 in varchar2 default hr_api.g_varchar2,
730: p_mat_information19 in varchar2 default hr_api.g_varchar2,
731: p_mat_information20 in varchar2 default hr_api.g_varchar2,
732: p_mat_information21 in varchar2 default hr_api.g_varchar2,
733: p_mat_information22 in varchar2 default hr_api.g_varchar2,
734: p_mat_information23 in varchar2 default hr_api.g_varchar2,
735: p_mat_information24 in varchar2 default hr_api.g_varchar2,
736: p_mat_information25 in varchar2 default hr_api.g_varchar2,
737: p_mat_information26 in varchar2 default hr_api.g_varchar2,

Line 734: p_mat_information23 in varchar2 default hr_api.g_varchar2,

730: p_mat_information19 in varchar2 default hr_api.g_varchar2,
731: p_mat_information20 in varchar2 default hr_api.g_varchar2,
732: p_mat_information21 in varchar2 default hr_api.g_varchar2,
733: p_mat_information22 in varchar2 default hr_api.g_varchar2,
734: p_mat_information23 in varchar2 default hr_api.g_varchar2,
735: p_mat_information24 in varchar2 default hr_api.g_varchar2,
736: p_mat_information25 in varchar2 default hr_api.g_varchar2,
737: p_mat_information26 in varchar2 default hr_api.g_varchar2,
738: p_mat_information27 in varchar2 default hr_api.g_varchar2,

Line 735: p_mat_information24 in varchar2 default hr_api.g_varchar2,

731: p_mat_information20 in varchar2 default hr_api.g_varchar2,
732: p_mat_information21 in varchar2 default hr_api.g_varchar2,
733: p_mat_information22 in varchar2 default hr_api.g_varchar2,
734: p_mat_information23 in varchar2 default hr_api.g_varchar2,
735: p_mat_information24 in varchar2 default hr_api.g_varchar2,
736: p_mat_information25 in varchar2 default hr_api.g_varchar2,
737: p_mat_information26 in varchar2 default hr_api.g_varchar2,
738: p_mat_information27 in varchar2 default hr_api.g_varchar2,
739: p_mat_information28 in varchar2 default hr_api.g_varchar2,

Line 736: p_mat_information25 in varchar2 default hr_api.g_varchar2,

732: p_mat_information21 in varchar2 default hr_api.g_varchar2,
733: p_mat_information22 in varchar2 default hr_api.g_varchar2,
734: p_mat_information23 in varchar2 default hr_api.g_varchar2,
735: p_mat_information24 in varchar2 default hr_api.g_varchar2,
736: p_mat_information25 in varchar2 default hr_api.g_varchar2,
737: p_mat_information26 in varchar2 default hr_api.g_varchar2,
738: p_mat_information27 in varchar2 default hr_api.g_varchar2,
739: p_mat_information28 in varchar2 default hr_api.g_varchar2,
740: p_mat_information29 in varchar2 default hr_api.g_varchar2,

Line 737: p_mat_information26 in varchar2 default hr_api.g_varchar2,

733: p_mat_information22 in varchar2 default hr_api.g_varchar2,
734: p_mat_information23 in varchar2 default hr_api.g_varchar2,
735: p_mat_information24 in varchar2 default hr_api.g_varchar2,
736: p_mat_information25 in varchar2 default hr_api.g_varchar2,
737: p_mat_information26 in varchar2 default hr_api.g_varchar2,
738: p_mat_information27 in varchar2 default hr_api.g_varchar2,
739: p_mat_information28 in varchar2 default hr_api.g_varchar2,
740: p_mat_information29 in varchar2 default hr_api.g_varchar2,
741: p_mat_information30 in varchar2 default hr_api.g_varchar2

Line 738: p_mat_information27 in varchar2 default hr_api.g_varchar2,

734: p_mat_information23 in varchar2 default hr_api.g_varchar2,
735: p_mat_information24 in varchar2 default hr_api.g_varchar2,
736: p_mat_information25 in varchar2 default hr_api.g_varchar2,
737: p_mat_information26 in varchar2 default hr_api.g_varchar2,
738: p_mat_information27 in varchar2 default hr_api.g_varchar2,
739: p_mat_information28 in varchar2 default hr_api.g_varchar2,
740: p_mat_information29 in varchar2 default hr_api.g_varchar2,
741: p_mat_information30 in varchar2 default hr_api.g_varchar2
742: ) is

Line 739: p_mat_information28 in varchar2 default hr_api.g_varchar2,

735: p_mat_information24 in varchar2 default hr_api.g_varchar2,
736: p_mat_information25 in varchar2 default hr_api.g_varchar2,
737: p_mat_information26 in varchar2 default hr_api.g_varchar2,
738: p_mat_information27 in varchar2 default hr_api.g_varchar2,
739: p_mat_information28 in varchar2 default hr_api.g_varchar2,
740: p_mat_information29 in varchar2 default hr_api.g_varchar2,
741: p_mat_information30 in varchar2 default hr_api.g_varchar2
742: ) is
743: --

Line 740: p_mat_information29 in varchar2 default hr_api.g_varchar2,

736: p_mat_information25 in varchar2 default hr_api.g_varchar2,
737: p_mat_information26 in varchar2 default hr_api.g_varchar2,
738: p_mat_information27 in varchar2 default hr_api.g_varchar2,
739: p_mat_information28 in varchar2 default hr_api.g_varchar2,
740: p_mat_information29 in varchar2 default hr_api.g_varchar2,
741: p_mat_information30 in varchar2 default hr_api.g_varchar2
742: ) is
743: --
744: l_rec ssp_mat_shd.g_rec_type;

Line 741: p_mat_information30 in varchar2 default hr_api.g_varchar2

737: p_mat_information26 in varchar2 default hr_api.g_varchar2,
738: p_mat_information27 in varchar2 default hr_api.g_varchar2,
739: p_mat_information28 in varchar2 default hr_api.g_varchar2,
740: p_mat_information29 in varchar2 default hr_api.g_varchar2,
741: p_mat_information30 in varchar2 default hr_api.g_varchar2
742: ) is
743: --
744: l_rec ssp_mat_shd.g_rec_type;
745: l_proc varchar2(72) := g_package||'upd';

Line 758: hr_api.g_number,

754: ssp_mat_shd.convert_args
755: (
756: p_maternity_id,
757: p_due_date,
758: hr_api.g_number,
759: p_start_date_SMA,
760: p_notification_of_birth_date,
761: p_unfit_for_scheduled_return,
762: p_stated_return_date,