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 150: When hr_api.check_integrity_violated Then

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

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

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

Line 155: When hr_api.parent_integrity_violated Then

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

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

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

Line 160: When hr_api.unique_integrity_violated Then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

439: If (p_rec.attribute19 = hr_api.g_varchar2) then
440: p_rec.attribute19 :=
441: ssp_mat_shd.g_old_rec.attribute19;
442: End If;
443: If (p_rec.attribute20 = hr_api.g_varchar2) then
444: p_rec.attribute20 :=
445: ssp_mat_shd.g_old_rec.attribute20;
446: End If;
447:

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

444: p_rec.attribute20 :=
445: ssp_mat_shd.g_old_rec.attribute20;
446: End If;
447:
448: If (p_rec.LEAVE_TYPE = hr_api.g_varchar2) then
449: p_rec.LEAVE_TYPE :=
450: ssp_mat_shd.g_old_rec.LEAVE_TYPE;
451: End If;
452:

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

449: p_rec.LEAVE_TYPE :=
450: ssp_mat_shd.g_old_rec.LEAVE_TYPE;
451: End If;
452:
453: If (p_rec.MATCHING_DATE = hr_api.g_date) then
454: p_rec.MATCHING_DATE :=
455: ssp_mat_shd.g_old_rec.MATCHING_DATE;
456: End If;
457:

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

454: p_rec.MATCHING_DATE :=
455: ssp_mat_shd.g_old_rec.MATCHING_DATE;
456: End If;
457:
458: If (p_rec.PLACEMENT_DATE = hr_api.g_date) then
459: p_rec.PLACEMENT_DATE :=
460: ssp_mat_shd.g_old_rec.PLACEMENT_DATE;
461: End If;
462:

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

459: p_rec.PLACEMENT_DATE :=
460: ssp_mat_shd.g_old_rec.PLACEMENT_DATE;
461: End If;
462:
463: If (p_rec.DISRUPTED_PLACEMENT_DATE = hr_api.g_date) then
464: p_rec.DISRUPTED_PLACEMENT_DATE :=
465: ssp_mat_shd.g_old_rec.DISRUPTED_PLACEMENT_DATE;
466: End If;
467:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

588: If (p_rec.mat_information29 = hr_api.g_varchar2) then
589: p_rec.mat_information29 :=
590: ssp_mat_shd.g_old_rec.mat_information29;
591: End If;
592: If (p_rec.mat_information30 = hr_api.g_varchar2) then
593: p_rec.mat_information30 :=
594: ssp_mat_shd.g_old_rec.mat_information30;
595: End If;
596:

Line 597: If (p_rec.partner_stat_pay_start_date = hr_api.g_date) then

593: p_rec.mat_information30 :=
594: ssp_mat_shd.g_old_rec.mat_information30;
595: End If;
596:
597: If (p_rec.partner_stat_pay_start_date = hr_api.g_date) then
598: p_rec.partner_stat_pay_start_date :=
599: ssp_mat_shd.g_old_rec.partner_stat_pay_start_date;
600: End If;
601: If (p_rec.partner_return_to_work = hr_api.g_date) then

Line 601: If (p_rec.partner_return_to_work = hr_api.g_date) then

597: If (p_rec.partner_stat_pay_start_date = hr_api.g_date) then
598: p_rec.partner_stat_pay_start_date :=
599: ssp_mat_shd.g_old_rec.partner_stat_pay_start_date;
600: End If;
601: If (p_rec.partner_return_to_work = hr_api.g_date) then
602: p_rec.partner_return_to_work :=
603: ssp_mat_shd.g_old_rec.partner_return_to_work;
604: End If;
605: If (p_rec.partner_death_date = hr_api.g_date) then

Line 605: If (p_rec.partner_death_date = hr_api.g_date) then

601: If (p_rec.partner_return_to_work = hr_api.g_date) then
602: p_rec.partner_return_to_work :=
603: ssp_mat_shd.g_old_rec.partner_return_to_work;
604: End If;
605: If (p_rec.partner_death_date = hr_api.g_date) then
606: p_rec.partner_death_date :=
607: ssp_mat_shd.g_old_rec.partner_death_date ;
608: End If;
609:

Line 670: Raise HR_Api.Validate_Enabled;

666: --
667: -- If we are validating then raise the Validate_Enabled exception
668: --
669: If p_validate then
670: Raise HR_Api.Validate_Enabled;
671: End If;
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 10);
674: Exception

Line 675: When HR_Api.Validate_Enabled Then

671: End If;
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 10);
674: Exception
675: When HR_Api.Validate_Enabled Then
676: --
677: -- As the Validate_Enabled exception has been raised
678: -- we must rollback to the savepoint
679: --

Line 690: p_due_date in date default hr_api.g_date,

686: Procedure upd
687: (
688: p_maternity_id in number,
689: p_object_version_number in out nocopy number,
690: p_due_date in date default hr_api.g_date,
691: p_start_date_SMA in date default hr_api.g_date,
692: p_notification_of_birth_date in date default hr_api.g_date,
693: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
694: p_stated_return_date in date default hr_api.g_date,

Line 691: p_start_date_SMA in date default hr_api.g_date,

687: (
688: p_maternity_id in number,
689: p_object_version_number in out nocopy number,
690: p_due_date in date default hr_api.g_date,
691: p_start_date_SMA in date default hr_api.g_date,
692: p_notification_of_birth_date in date default hr_api.g_date,
693: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
694: p_stated_return_date in date default hr_api.g_date,
695: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,

Line 692: p_notification_of_birth_date in date default hr_api.g_date,

688: p_maternity_id in number,
689: p_object_version_number in out nocopy number,
690: p_due_date in date default hr_api.g_date,
691: p_start_date_SMA in date default hr_api.g_date,
692: p_notification_of_birth_date in date default hr_api.g_date,
693: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
694: p_stated_return_date in date default hr_api.g_date,
695: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
696: p_start_date_with_new_employer in date default hr_api.g_date,

Line 693: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,

689: p_object_version_number in out nocopy number,
690: p_due_date in date default hr_api.g_date,
691: p_start_date_SMA in date default hr_api.g_date,
692: p_notification_of_birth_date in date default hr_api.g_date,
693: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
694: p_stated_return_date in date default hr_api.g_date,
695: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
696: p_start_date_with_new_employer in date default hr_api.g_date,
697: p_smp_must_be_paid_by_date in date default hr_api.g_date,

Line 694: p_stated_return_date in date default hr_api.g_date,

690: p_due_date in date default hr_api.g_date,
691: p_start_date_SMA in date default hr_api.g_date,
692: p_notification_of_birth_date in date default hr_api.g_date,
693: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
694: p_stated_return_date in date default hr_api.g_date,
695: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
696: p_start_date_with_new_employer in date default hr_api.g_date,
697: p_smp_must_be_paid_by_date in date default hr_api.g_date,
698: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,

Line 695: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,

691: p_start_date_SMA in date default hr_api.g_date,
692: p_notification_of_birth_date in date default hr_api.g_date,
693: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
694: p_stated_return_date in date default hr_api.g_date,
695: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
696: p_start_date_with_new_employer in date default hr_api.g_date,
697: p_smp_must_be_paid_by_date in date default hr_api.g_date,
698: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
699: p_live_birth_flag in varchar2 default hr_api.g_varchar2,

Line 696: p_start_date_with_new_employer in date default hr_api.g_date,

692: p_notification_of_birth_date in date default hr_api.g_date,
693: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
694: p_stated_return_date in date default hr_api.g_date,
695: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
696: p_start_date_with_new_employer in date default hr_api.g_date,
697: p_smp_must_be_paid_by_date in date default hr_api.g_date,
698: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
699: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
700: p_actual_birth_date in date default hr_api.g_date,

Line 697: p_smp_must_be_paid_by_date in date default hr_api.g_date,

693: p_unfit_for_scheduled_return in varchar2 default hr_api.g_varchar2,
694: p_stated_return_date in date default hr_api.g_date,
695: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
696: p_start_date_with_new_employer in date default hr_api.g_date,
697: p_smp_must_be_paid_by_date in date default hr_api.g_date,
698: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
699: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
700: p_actual_birth_date in date default hr_api.g_date,
701: p_mpp_start_date in date default hr_api.g_date,

Line 698: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,

694: p_stated_return_date in date default hr_api.g_date,
695: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
696: p_start_date_with_new_employer in date default hr_api.g_date,
697: p_smp_must_be_paid_by_date in date default hr_api.g_date,
698: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
699: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
700: p_actual_birth_date in date default hr_api.g_date,
701: p_mpp_start_date in date default hr_api.g_date,
702: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 699: p_live_birth_flag in varchar2 default hr_api.g_varchar2,

695: p_intend_to_return_flag in varchar2 default hr_api.g_varchar2,
696: p_start_date_with_new_employer in date default hr_api.g_date,
697: p_smp_must_be_paid_by_date in date default hr_api.g_date,
698: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
699: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
700: p_actual_birth_date in date default hr_api.g_date,
701: p_mpp_start_date in date default hr_api.g_date,
702: p_attribute_category in varchar2 default hr_api.g_varchar2,
703: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 700: p_actual_birth_date in date default hr_api.g_date,

696: p_start_date_with_new_employer in date default hr_api.g_date,
697: p_smp_must_be_paid_by_date in date default hr_api.g_date,
698: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
699: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
700: p_actual_birth_date in date default hr_api.g_date,
701: p_mpp_start_date in date default hr_api.g_date,
702: p_attribute_category in varchar2 default hr_api.g_varchar2,
703: p_attribute1 in varchar2 default hr_api.g_varchar2,
704: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 701: p_mpp_start_date in date default hr_api.g_date,

697: p_smp_must_be_paid_by_date in date default hr_api.g_date,
698: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
699: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
700: p_actual_birth_date in date default hr_api.g_date,
701: p_mpp_start_date in date default hr_api.g_date,
702: p_attribute_category in varchar2 default hr_api.g_varchar2,
703: p_attribute1 in varchar2 default hr_api.g_varchar2,
704: p_attribute2 in varchar2 default hr_api.g_varchar2,
705: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 702: p_attribute_category in varchar2 default hr_api.g_varchar2,

698: p_pay_smp_as_lump_sum in varchar2 default hr_api.g_varchar2,
699: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
700: p_actual_birth_date in date default hr_api.g_date,
701: p_mpp_start_date in date default hr_api.g_date,
702: p_attribute_category in varchar2 default hr_api.g_varchar2,
703: p_attribute1 in varchar2 default hr_api.g_varchar2,
704: p_attribute2 in varchar2 default hr_api.g_varchar2,
705: p_attribute3 in varchar2 default hr_api.g_varchar2,
706: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 703: p_attribute1 in varchar2 default hr_api.g_varchar2,

699: p_live_birth_flag in varchar2 default hr_api.g_varchar2,
700: p_actual_birth_date in date default hr_api.g_date,
701: p_mpp_start_date in date default hr_api.g_date,
702: p_attribute_category in varchar2 default hr_api.g_varchar2,
703: p_attribute1 in varchar2 default hr_api.g_varchar2,
704: p_attribute2 in varchar2 default hr_api.g_varchar2,
705: p_attribute3 in varchar2 default hr_api.g_varchar2,
706: p_attribute4 in varchar2 default hr_api.g_varchar2,
707: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 704: p_attribute2 in varchar2 default hr_api.g_varchar2,

700: p_actual_birth_date in date default hr_api.g_date,
701: p_mpp_start_date in date default hr_api.g_date,
702: p_attribute_category in varchar2 default hr_api.g_varchar2,
703: p_attribute1 in varchar2 default hr_api.g_varchar2,
704: p_attribute2 in varchar2 default hr_api.g_varchar2,
705: p_attribute3 in varchar2 default hr_api.g_varchar2,
706: p_attribute4 in varchar2 default hr_api.g_varchar2,
707: p_attribute5 in varchar2 default hr_api.g_varchar2,
708: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 705: p_attribute3 in varchar2 default hr_api.g_varchar2,

701: p_mpp_start_date in date default hr_api.g_date,
702: p_attribute_category in varchar2 default hr_api.g_varchar2,
703: p_attribute1 in varchar2 default hr_api.g_varchar2,
704: p_attribute2 in varchar2 default hr_api.g_varchar2,
705: p_attribute3 in varchar2 default hr_api.g_varchar2,
706: p_attribute4 in varchar2 default hr_api.g_varchar2,
707: p_attribute5 in varchar2 default hr_api.g_varchar2,
708: p_attribute6 in varchar2 default hr_api.g_varchar2,
709: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 706: p_attribute4 in varchar2 default hr_api.g_varchar2,

702: p_attribute_category in varchar2 default hr_api.g_varchar2,
703: p_attribute1 in varchar2 default hr_api.g_varchar2,
704: p_attribute2 in varchar2 default hr_api.g_varchar2,
705: p_attribute3 in varchar2 default hr_api.g_varchar2,
706: p_attribute4 in varchar2 default hr_api.g_varchar2,
707: p_attribute5 in varchar2 default hr_api.g_varchar2,
708: p_attribute6 in varchar2 default hr_api.g_varchar2,
709: p_attribute7 in varchar2 default hr_api.g_varchar2,
710: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 707: p_attribute5 in varchar2 default hr_api.g_varchar2,

703: p_attribute1 in varchar2 default hr_api.g_varchar2,
704: p_attribute2 in varchar2 default hr_api.g_varchar2,
705: p_attribute3 in varchar2 default hr_api.g_varchar2,
706: p_attribute4 in varchar2 default hr_api.g_varchar2,
707: p_attribute5 in varchar2 default hr_api.g_varchar2,
708: p_attribute6 in varchar2 default hr_api.g_varchar2,
709: p_attribute7 in varchar2 default hr_api.g_varchar2,
710: p_attribute8 in varchar2 default hr_api.g_varchar2,
711: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 708: p_attribute6 in varchar2 default hr_api.g_varchar2,

704: p_attribute2 in varchar2 default hr_api.g_varchar2,
705: p_attribute3 in varchar2 default hr_api.g_varchar2,
706: p_attribute4 in varchar2 default hr_api.g_varchar2,
707: p_attribute5 in varchar2 default hr_api.g_varchar2,
708: p_attribute6 in varchar2 default hr_api.g_varchar2,
709: p_attribute7 in varchar2 default hr_api.g_varchar2,
710: p_attribute8 in varchar2 default hr_api.g_varchar2,
711: p_attribute9 in varchar2 default hr_api.g_varchar2,
712: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 709: p_attribute7 in varchar2 default hr_api.g_varchar2,

705: p_attribute3 in varchar2 default hr_api.g_varchar2,
706: p_attribute4 in varchar2 default hr_api.g_varchar2,
707: p_attribute5 in varchar2 default hr_api.g_varchar2,
708: p_attribute6 in varchar2 default hr_api.g_varchar2,
709: p_attribute7 in varchar2 default hr_api.g_varchar2,
710: p_attribute8 in varchar2 default hr_api.g_varchar2,
711: p_attribute9 in varchar2 default hr_api.g_varchar2,
712: p_attribute10 in varchar2 default hr_api.g_varchar2,
713: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 710: p_attribute8 in varchar2 default hr_api.g_varchar2,

706: p_attribute4 in varchar2 default hr_api.g_varchar2,
707: p_attribute5 in varchar2 default hr_api.g_varchar2,
708: p_attribute6 in varchar2 default hr_api.g_varchar2,
709: p_attribute7 in varchar2 default hr_api.g_varchar2,
710: p_attribute8 in varchar2 default hr_api.g_varchar2,
711: p_attribute9 in varchar2 default hr_api.g_varchar2,
712: p_attribute10 in varchar2 default hr_api.g_varchar2,
713: p_attribute11 in varchar2 default hr_api.g_varchar2,
714: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 711: p_attribute9 in varchar2 default hr_api.g_varchar2,

707: p_attribute5 in varchar2 default hr_api.g_varchar2,
708: p_attribute6 in varchar2 default hr_api.g_varchar2,
709: p_attribute7 in varchar2 default hr_api.g_varchar2,
710: p_attribute8 in varchar2 default hr_api.g_varchar2,
711: p_attribute9 in varchar2 default hr_api.g_varchar2,
712: p_attribute10 in varchar2 default hr_api.g_varchar2,
713: p_attribute11 in varchar2 default hr_api.g_varchar2,
714: p_attribute12 in varchar2 default hr_api.g_varchar2,
715: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 712: p_attribute10 in varchar2 default hr_api.g_varchar2,

708: p_attribute6 in varchar2 default hr_api.g_varchar2,
709: p_attribute7 in varchar2 default hr_api.g_varchar2,
710: p_attribute8 in varchar2 default hr_api.g_varchar2,
711: p_attribute9 in varchar2 default hr_api.g_varchar2,
712: p_attribute10 in varchar2 default hr_api.g_varchar2,
713: p_attribute11 in varchar2 default hr_api.g_varchar2,
714: p_attribute12 in varchar2 default hr_api.g_varchar2,
715: p_attribute13 in varchar2 default hr_api.g_varchar2,
716: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 713: p_attribute11 in varchar2 default hr_api.g_varchar2,

709: p_attribute7 in varchar2 default hr_api.g_varchar2,
710: p_attribute8 in varchar2 default hr_api.g_varchar2,
711: p_attribute9 in varchar2 default hr_api.g_varchar2,
712: p_attribute10 in varchar2 default hr_api.g_varchar2,
713: p_attribute11 in varchar2 default hr_api.g_varchar2,
714: p_attribute12 in varchar2 default hr_api.g_varchar2,
715: p_attribute13 in varchar2 default hr_api.g_varchar2,
716: p_attribute14 in varchar2 default hr_api.g_varchar2,
717: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 714: p_attribute12 in varchar2 default hr_api.g_varchar2,

710: p_attribute8 in varchar2 default hr_api.g_varchar2,
711: p_attribute9 in varchar2 default hr_api.g_varchar2,
712: p_attribute10 in varchar2 default hr_api.g_varchar2,
713: p_attribute11 in varchar2 default hr_api.g_varchar2,
714: p_attribute12 in varchar2 default hr_api.g_varchar2,
715: p_attribute13 in varchar2 default hr_api.g_varchar2,
716: p_attribute14 in varchar2 default hr_api.g_varchar2,
717: p_attribute15 in varchar2 default hr_api.g_varchar2,
718: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 715: p_attribute13 in varchar2 default hr_api.g_varchar2,

711: p_attribute9 in varchar2 default hr_api.g_varchar2,
712: p_attribute10 in varchar2 default hr_api.g_varchar2,
713: p_attribute11 in varchar2 default hr_api.g_varchar2,
714: p_attribute12 in varchar2 default hr_api.g_varchar2,
715: p_attribute13 in varchar2 default hr_api.g_varchar2,
716: p_attribute14 in varchar2 default hr_api.g_varchar2,
717: p_attribute15 in varchar2 default hr_api.g_varchar2,
718: p_attribute16 in varchar2 default hr_api.g_varchar2,
719: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 716: p_attribute14 in varchar2 default hr_api.g_varchar2,

712: p_attribute10 in varchar2 default hr_api.g_varchar2,
713: p_attribute11 in varchar2 default hr_api.g_varchar2,
714: p_attribute12 in varchar2 default hr_api.g_varchar2,
715: p_attribute13 in varchar2 default hr_api.g_varchar2,
716: p_attribute14 in varchar2 default hr_api.g_varchar2,
717: p_attribute15 in varchar2 default hr_api.g_varchar2,
718: p_attribute16 in varchar2 default hr_api.g_varchar2,
719: p_attribute17 in varchar2 default hr_api.g_varchar2,
720: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 717: p_attribute15 in varchar2 default hr_api.g_varchar2,

713: p_attribute11 in varchar2 default hr_api.g_varchar2,
714: p_attribute12 in varchar2 default hr_api.g_varchar2,
715: p_attribute13 in varchar2 default hr_api.g_varchar2,
716: p_attribute14 in varchar2 default hr_api.g_varchar2,
717: p_attribute15 in varchar2 default hr_api.g_varchar2,
718: p_attribute16 in varchar2 default hr_api.g_varchar2,
719: p_attribute17 in varchar2 default hr_api.g_varchar2,
720: p_attribute18 in varchar2 default hr_api.g_varchar2,
721: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 718: p_attribute16 in varchar2 default hr_api.g_varchar2,

714: p_attribute12 in varchar2 default hr_api.g_varchar2,
715: p_attribute13 in varchar2 default hr_api.g_varchar2,
716: p_attribute14 in varchar2 default hr_api.g_varchar2,
717: p_attribute15 in varchar2 default hr_api.g_varchar2,
718: p_attribute16 in varchar2 default hr_api.g_varchar2,
719: p_attribute17 in varchar2 default hr_api.g_varchar2,
720: p_attribute18 in varchar2 default hr_api.g_varchar2,
721: p_attribute19 in varchar2 default hr_api.g_varchar2,
722: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 719: p_attribute17 in varchar2 default hr_api.g_varchar2,

715: p_attribute13 in varchar2 default hr_api.g_varchar2,
716: p_attribute14 in varchar2 default hr_api.g_varchar2,
717: p_attribute15 in varchar2 default hr_api.g_varchar2,
718: p_attribute16 in varchar2 default hr_api.g_varchar2,
719: p_attribute17 in varchar2 default hr_api.g_varchar2,
720: p_attribute18 in varchar2 default hr_api.g_varchar2,
721: p_attribute19 in varchar2 default hr_api.g_varchar2,
722: p_attribute20 in varchar2 default hr_api.g_varchar2,
723: p_LEAVE_TYPE in VARCHAR2 default 'MA',

Line 720: p_attribute18 in varchar2 default hr_api.g_varchar2,

716: p_attribute14 in varchar2 default hr_api.g_varchar2,
717: p_attribute15 in varchar2 default hr_api.g_varchar2,
718: p_attribute16 in varchar2 default hr_api.g_varchar2,
719: p_attribute17 in varchar2 default hr_api.g_varchar2,
720: p_attribute18 in varchar2 default hr_api.g_varchar2,
721: p_attribute19 in varchar2 default hr_api.g_varchar2,
722: p_attribute20 in varchar2 default hr_api.g_varchar2,
723: p_LEAVE_TYPE in VARCHAR2 default 'MA',
724: p_MATCHING_DATE in DATE default hr_api.g_date,

Line 721: p_attribute19 in varchar2 default hr_api.g_varchar2,

717: p_attribute15 in varchar2 default hr_api.g_varchar2,
718: p_attribute16 in varchar2 default hr_api.g_varchar2,
719: p_attribute17 in varchar2 default hr_api.g_varchar2,
720: p_attribute18 in varchar2 default hr_api.g_varchar2,
721: p_attribute19 in varchar2 default hr_api.g_varchar2,
722: p_attribute20 in varchar2 default hr_api.g_varchar2,
723: p_LEAVE_TYPE in VARCHAR2 default 'MA',
724: p_MATCHING_DATE in DATE default hr_api.g_date,
725: p_PLACEMENT_DATE in DATE default hr_api.g_date,

Line 722: p_attribute20 in varchar2 default hr_api.g_varchar2,

718: p_attribute16 in varchar2 default hr_api.g_varchar2,
719: p_attribute17 in varchar2 default hr_api.g_varchar2,
720: p_attribute18 in varchar2 default hr_api.g_varchar2,
721: p_attribute19 in varchar2 default hr_api.g_varchar2,
722: p_attribute20 in varchar2 default hr_api.g_varchar2,
723: p_LEAVE_TYPE in VARCHAR2 default 'MA',
724: p_MATCHING_DATE in DATE default hr_api.g_date,
725: p_PLACEMENT_DATE in DATE default hr_api.g_date,
726: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,

Line 724: p_MATCHING_DATE in DATE default hr_api.g_date,

720: p_attribute18 in varchar2 default hr_api.g_varchar2,
721: p_attribute19 in varchar2 default hr_api.g_varchar2,
722: p_attribute20 in varchar2 default hr_api.g_varchar2,
723: p_LEAVE_TYPE in VARCHAR2 default 'MA',
724: p_MATCHING_DATE in DATE default hr_api.g_date,
725: p_PLACEMENT_DATE in DATE default hr_api.g_date,
726: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
727: p_validate in boolean default false,
728: p_mat_information_category in varchar2 default hr_api.g_varchar2,

Line 725: p_PLACEMENT_DATE in DATE default hr_api.g_date,

721: p_attribute19 in varchar2 default hr_api.g_varchar2,
722: p_attribute20 in varchar2 default hr_api.g_varchar2,
723: p_LEAVE_TYPE in VARCHAR2 default 'MA',
724: p_MATCHING_DATE in DATE default hr_api.g_date,
725: p_PLACEMENT_DATE in DATE default hr_api.g_date,
726: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
727: p_validate in boolean default false,
728: p_mat_information_category in varchar2 default hr_api.g_varchar2,
729: p_mat_information1 in varchar2 default hr_api.g_varchar2,

Line 726: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,

722: p_attribute20 in varchar2 default hr_api.g_varchar2,
723: p_LEAVE_TYPE in VARCHAR2 default 'MA',
724: p_MATCHING_DATE in DATE default hr_api.g_date,
725: p_PLACEMENT_DATE in DATE default hr_api.g_date,
726: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
727: p_validate in boolean default false,
728: p_mat_information_category in varchar2 default hr_api.g_varchar2,
729: p_mat_information1 in varchar2 default hr_api.g_varchar2,
730: p_mat_information2 in varchar2 default hr_api.g_varchar2,

Line 728: p_mat_information_category in varchar2 default hr_api.g_varchar2,

724: p_MATCHING_DATE in DATE default hr_api.g_date,
725: p_PLACEMENT_DATE in DATE default hr_api.g_date,
726: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
727: p_validate in boolean default false,
728: p_mat_information_category in varchar2 default hr_api.g_varchar2,
729: p_mat_information1 in varchar2 default hr_api.g_varchar2,
730: p_mat_information2 in varchar2 default hr_api.g_varchar2,
731: p_mat_information3 in varchar2 default hr_api.g_varchar2,
732: p_mat_information4 in varchar2 default hr_api.g_varchar2,

Line 729: p_mat_information1 in varchar2 default hr_api.g_varchar2,

725: p_PLACEMENT_DATE in DATE default hr_api.g_date,
726: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
727: p_validate in boolean default false,
728: p_mat_information_category in varchar2 default hr_api.g_varchar2,
729: p_mat_information1 in varchar2 default hr_api.g_varchar2,
730: p_mat_information2 in varchar2 default hr_api.g_varchar2,
731: p_mat_information3 in varchar2 default hr_api.g_varchar2,
732: p_mat_information4 in varchar2 default hr_api.g_varchar2,
733: p_mat_information5 in varchar2 default hr_api.g_varchar2,

Line 730: p_mat_information2 in varchar2 default hr_api.g_varchar2,

726: p_DISRUPTED_PLACEMENT_DATE in DATE default hr_api.g_date,
727: p_validate in boolean default false,
728: p_mat_information_category in varchar2 default hr_api.g_varchar2,
729: p_mat_information1 in varchar2 default hr_api.g_varchar2,
730: p_mat_information2 in varchar2 default hr_api.g_varchar2,
731: p_mat_information3 in varchar2 default hr_api.g_varchar2,
732: p_mat_information4 in varchar2 default hr_api.g_varchar2,
733: p_mat_information5 in varchar2 default hr_api.g_varchar2,
734: p_mat_information6 in varchar2 default hr_api.g_varchar2,

Line 731: p_mat_information3 in varchar2 default hr_api.g_varchar2,

727: p_validate in boolean default false,
728: p_mat_information_category in varchar2 default hr_api.g_varchar2,
729: p_mat_information1 in varchar2 default hr_api.g_varchar2,
730: p_mat_information2 in varchar2 default hr_api.g_varchar2,
731: p_mat_information3 in varchar2 default hr_api.g_varchar2,
732: p_mat_information4 in varchar2 default hr_api.g_varchar2,
733: p_mat_information5 in varchar2 default hr_api.g_varchar2,
734: p_mat_information6 in varchar2 default hr_api.g_varchar2,
735: p_mat_information7 in varchar2 default hr_api.g_varchar2,

Line 732: p_mat_information4 in varchar2 default hr_api.g_varchar2,

728: p_mat_information_category in varchar2 default hr_api.g_varchar2,
729: p_mat_information1 in varchar2 default hr_api.g_varchar2,
730: p_mat_information2 in varchar2 default hr_api.g_varchar2,
731: p_mat_information3 in varchar2 default hr_api.g_varchar2,
732: p_mat_information4 in varchar2 default hr_api.g_varchar2,
733: p_mat_information5 in varchar2 default hr_api.g_varchar2,
734: p_mat_information6 in varchar2 default hr_api.g_varchar2,
735: p_mat_information7 in varchar2 default hr_api.g_varchar2,
736: p_mat_information8 in varchar2 default hr_api.g_varchar2,

Line 733: p_mat_information5 in varchar2 default hr_api.g_varchar2,

729: p_mat_information1 in varchar2 default hr_api.g_varchar2,
730: p_mat_information2 in varchar2 default hr_api.g_varchar2,
731: p_mat_information3 in varchar2 default hr_api.g_varchar2,
732: p_mat_information4 in varchar2 default hr_api.g_varchar2,
733: p_mat_information5 in varchar2 default hr_api.g_varchar2,
734: p_mat_information6 in varchar2 default hr_api.g_varchar2,
735: p_mat_information7 in varchar2 default hr_api.g_varchar2,
736: p_mat_information8 in varchar2 default hr_api.g_varchar2,
737: p_mat_information9 in varchar2 default hr_api.g_varchar2,

Line 734: p_mat_information6 in varchar2 default hr_api.g_varchar2,

730: p_mat_information2 in varchar2 default hr_api.g_varchar2,
731: p_mat_information3 in varchar2 default hr_api.g_varchar2,
732: p_mat_information4 in varchar2 default hr_api.g_varchar2,
733: p_mat_information5 in varchar2 default hr_api.g_varchar2,
734: p_mat_information6 in varchar2 default hr_api.g_varchar2,
735: p_mat_information7 in varchar2 default hr_api.g_varchar2,
736: p_mat_information8 in varchar2 default hr_api.g_varchar2,
737: p_mat_information9 in varchar2 default hr_api.g_varchar2,
738: p_mat_information10 in varchar2 default hr_api.g_varchar2,

Line 735: p_mat_information7 in varchar2 default hr_api.g_varchar2,

731: p_mat_information3 in varchar2 default hr_api.g_varchar2,
732: p_mat_information4 in varchar2 default hr_api.g_varchar2,
733: p_mat_information5 in varchar2 default hr_api.g_varchar2,
734: p_mat_information6 in varchar2 default hr_api.g_varchar2,
735: p_mat_information7 in varchar2 default hr_api.g_varchar2,
736: p_mat_information8 in varchar2 default hr_api.g_varchar2,
737: p_mat_information9 in varchar2 default hr_api.g_varchar2,
738: p_mat_information10 in varchar2 default hr_api.g_varchar2,
739: p_mat_information11 in varchar2 default hr_api.g_varchar2,

Line 736: p_mat_information8 in varchar2 default hr_api.g_varchar2,

732: p_mat_information4 in varchar2 default hr_api.g_varchar2,
733: p_mat_information5 in varchar2 default hr_api.g_varchar2,
734: p_mat_information6 in varchar2 default hr_api.g_varchar2,
735: p_mat_information7 in varchar2 default hr_api.g_varchar2,
736: p_mat_information8 in varchar2 default hr_api.g_varchar2,
737: p_mat_information9 in varchar2 default hr_api.g_varchar2,
738: p_mat_information10 in varchar2 default hr_api.g_varchar2,
739: p_mat_information11 in varchar2 default hr_api.g_varchar2,
740: p_mat_information12 in varchar2 default hr_api.g_varchar2,

Line 737: p_mat_information9 in varchar2 default hr_api.g_varchar2,

733: p_mat_information5 in varchar2 default hr_api.g_varchar2,
734: p_mat_information6 in varchar2 default hr_api.g_varchar2,
735: p_mat_information7 in varchar2 default hr_api.g_varchar2,
736: p_mat_information8 in varchar2 default hr_api.g_varchar2,
737: p_mat_information9 in varchar2 default hr_api.g_varchar2,
738: p_mat_information10 in varchar2 default hr_api.g_varchar2,
739: p_mat_information11 in varchar2 default hr_api.g_varchar2,
740: p_mat_information12 in varchar2 default hr_api.g_varchar2,
741: p_mat_information13 in varchar2 default hr_api.g_varchar2,

Line 738: p_mat_information10 in varchar2 default hr_api.g_varchar2,

734: p_mat_information6 in varchar2 default hr_api.g_varchar2,
735: p_mat_information7 in varchar2 default hr_api.g_varchar2,
736: p_mat_information8 in varchar2 default hr_api.g_varchar2,
737: p_mat_information9 in varchar2 default hr_api.g_varchar2,
738: p_mat_information10 in varchar2 default hr_api.g_varchar2,
739: p_mat_information11 in varchar2 default hr_api.g_varchar2,
740: p_mat_information12 in varchar2 default hr_api.g_varchar2,
741: p_mat_information13 in varchar2 default hr_api.g_varchar2,
742: p_mat_information14 in varchar2 default hr_api.g_varchar2,

Line 739: p_mat_information11 in varchar2 default hr_api.g_varchar2,

735: p_mat_information7 in varchar2 default hr_api.g_varchar2,
736: p_mat_information8 in varchar2 default hr_api.g_varchar2,
737: p_mat_information9 in varchar2 default hr_api.g_varchar2,
738: p_mat_information10 in varchar2 default hr_api.g_varchar2,
739: p_mat_information11 in varchar2 default hr_api.g_varchar2,
740: p_mat_information12 in varchar2 default hr_api.g_varchar2,
741: p_mat_information13 in varchar2 default hr_api.g_varchar2,
742: p_mat_information14 in varchar2 default hr_api.g_varchar2,
743: p_mat_information15 in varchar2 default hr_api.g_varchar2,

Line 740: p_mat_information12 in varchar2 default hr_api.g_varchar2,

736: p_mat_information8 in varchar2 default hr_api.g_varchar2,
737: p_mat_information9 in varchar2 default hr_api.g_varchar2,
738: p_mat_information10 in varchar2 default hr_api.g_varchar2,
739: p_mat_information11 in varchar2 default hr_api.g_varchar2,
740: p_mat_information12 in varchar2 default hr_api.g_varchar2,
741: p_mat_information13 in varchar2 default hr_api.g_varchar2,
742: p_mat_information14 in varchar2 default hr_api.g_varchar2,
743: p_mat_information15 in varchar2 default hr_api.g_varchar2,
744: p_mat_information16 in varchar2 default hr_api.g_varchar2,

Line 741: p_mat_information13 in varchar2 default hr_api.g_varchar2,

737: p_mat_information9 in varchar2 default hr_api.g_varchar2,
738: p_mat_information10 in varchar2 default hr_api.g_varchar2,
739: p_mat_information11 in varchar2 default hr_api.g_varchar2,
740: p_mat_information12 in varchar2 default hr_api.g_varchar2,
741: p_mat_information13 in varchar2 default hr_api.g_varchar2,
742: p_mat_information14 in varchar2 default hr_api.g_varchar2,
743: p_mat_information15 in varchar2 default hr_api.g_varchar2,
744: p_mat_information16 in varchar2 default hr_api.g_varchar2,
745: p_mat_information17 in varchar2 default hr_api.g_varchar2,

Line 742: p_mat_information14 in varchar2 default hr_api.g_varchar2,

738: p_mat_information10 in varchar2 default hr_api.g_varchar2,
739: p_mat_information11 in varchar2 default hr_api.g_varchar2,
740: p_mat_information12 in varchar2 default hr_api.g_varchar2,
741: p_mat_information13 in varchar2 default hr_api.g_varchar2,
742: p_mat_information14 in varchar2 default hr_api.g_varchar2,
743: p_mat_information15 in varchar2 default hr_api.g_varchar2,
744: p_mat_information16 in varchar2 default hr_api.g_varchar2,
745: p_mat_information17 in varchar2 default hr_api.g_varchar2,
746: p_mat_information18 in varchar2 default hr_api.g_varchar2,

Line 743: p_mat_information15 in varchar2 default hr_api.g_varchar2,

739: p_mat_information11 in varchar2 default hr_api.g_varchar2,
740: p_mat_information12 in varchar2 default hr_api.g_varchar2,
741: p_mat_information13 in varchar2 default hr_api.g_varchar2,
742: p_mat_information14 in varchar2 default hr_api.g_varchar2,
743: p_mat_information15 in varchar2 default hr_api.g_varchar2,
744: p_mat_information16 in varchar2 default hr_api.g_varchar2,
745: p_mat_information17 in varchar2 default hr_api.g_varchar2,
746: p_mat_information18 in varchar2 default hr_api.g_varchar2,
747: p_mat_information19 in varchar2 default hr_api.g_varchar2,

Line 744: p_mat_information16 in varchar2 default hr_api.g_varchar2,

740: p_mat_information12 in varchar2 default hr_api.g_varchar2,
741: p_mat_information13 in varchar2 default hr_api.g_varchar2,
742: p_mat_information14 in varchar2 default hr_api.g_varchar2,
743: p_mat_information15 in varchar2 default hr_api.g_varchar2,
744: p_mat_information16 in varchar2 default hr_api.g_varchar2,
745: p_mat_information17 in varchar2 default hr_api.g_varchar2,
746: p_mat_information18 in varchar2 default hr_api.g_varchar2,
747: p_mat_information19 in varchar2 default hr_api.g_varchar2,
748: p_mat_information20 in varchar2 default hr_api.g_varchar2,

Line 745: p_mat_information17 in varchar2 default hr_api.g_varchar2,

741: p_mat_information13 in varchar2 default hr_api.g_varchar2,
742: p_mat_information14 in varchar2 default hr_api.g_varchar2,
743: p_mat_information15 in varchar2 default hr_api.g_varchar2,
744: p_mat_information16 in varchar2 default hr_api.g_varchar2,
745: p_mat_information17 in varchar2 default hr_api.g_varchar2,
746: p_mat_information18 in varchar2 default hr_api.g_varchar2,
747: p_mat_information19 in varchar2 default hr_api.g_varchar2,
748: p_mat_information20 in varchar2 default hr_api.g_varchar2,
749: p_mat_information21 in varchar2 default hr_api.g_varchar2,

Line 746: p_mat_information18 in varchar2 default hr_api.g_varchar2,

742: p_mat_information14 in varchar2 default hr_api.g_varchar2,
743: p_mat_information15 in varchar2 default hr_api.g_varchar2,
744: p_mat_information16 in varchar2 default hr_api.g_varchar2,
745: p_mat_information17 in varchar2 default hr_api.g_varchar2,
746: p_mat_information18 in varchar2 default hr_api.g_varchar2,
747: p_mat_information19 in varchar2 default hr_api.g_varchar2,
748: p_mat_information20 in varchar2 default hr_api.g_varchar2,
749: p_mat_information21 in varchar2 default hr_api.g_varchar2,
750: p_mat_information22 in varchar2 default hr_api.g_varchar2,

Line 747: p_mat_information19 in varchar2 default hr_api.g_varchar2,

743: p_mat_information15 in varchar2 default hr_api.g_varchar2,
744: p_mat_information16 in varchar2 default hr_api.g_varchar2,
745: p_mat_information17 in varchar2 default hr_api.g_varchar2,
746: p_mat_information18 in varchar2 default hr_api.g_varchar2,
747: p_mat_information19 in varchar2 default hr_api.g_varchar2,
748: p_mat_information20 in varchar2 default hr_api.g_varchar2,
749: p_mat_information21 in varchar2 default hr_api.g_varchar2,
750: p_mat_information22 in varchar2 default hr_api.g_varchar2,
751: p_mat_information23 in varchar2 default hr_api.g_varchar2,

Line 748: p_mat_information20 in varchar2 default hr_api.g_varchar2,

744: p_mat_information16 in varchar2 default hr_api.g_varchar2,
745: p_mat_information17 in varchar2 default hr_api.g_varchar2,
746: p_mat_information18 in varchar2 default hr_api.g_varchar2,
747: p_mat_information19 in varchar2 default hr_api.g_varchar2,
748: p_mat_information20 in varchar2 default hr_api.g_varchar2,
749: p_mat_information21 in varchar2 default hr_api.g_varchar2,
750: p_mat_information22 in varchar2 default hr_api.g_varchar2,
751: p_mat_information23 in varchar2 default hr_api.g_varchar2,
752: p_mat_information24 in varchar2 default hr_api.g_varchar2,

Line 749: p_mat_information21 in varchar2 default hr_api.g_varchar2,

745: p_mat_information17 in varchar2 default hr_api.g_varchar2,
746: p_mat_information18 in varchar2 default hr_api.g_varchar2,
747: p_mat_information19 in varchar2 default hr_api.g_varchar2,
748: p_mat_information20 in varchar2 default hr_api.g_varchar2,
749: p_mat_information21 in varchar2 default hr_api.g_varchar2,
750: p_mat_information22 in varchar2 default hr_api.g_varchar2,
751: p_mat_information23 in varchar2 default hr_api.g_varchar2,
752: p_mat_information24 in varchar2 default hr_api.g_varchar2,
753: p_mat_information25 in varchar2 default hr_api.g_varchar2,

Line 750: p_mat_information22 in varchar2 default hr_api.g_varchar2,

746: p_mat_information18 in varchar2 default hr_api.g_varchar2,
747: p_mat_information19 in varchar2 default hr_api.g_varchar2,
748: p_mat_information20 in varchar2 default hr_api.g_varchar2,
749: p_mat_information21 in varchar2 default hr_api.g_varchar2,
750: p_mat_information22 in varchar2 default hr_api.g_varchar2,
751: p_mat_information23 in varchar2 default hr_api.g_varchar2,
752: p_mat_information24 in varchar2 default hr_api.g_varchar2,
753: p_mat_information25 in varchar2 default hr_api.g_varchar2,
754: p_mat_information26 in varchar2 default hr_api.g_varchar2,

Line 751: p_mat_information23 in varchar2 default hr_api.g_varchar2,

747: p_mat_information19 in varchar2 default hr_api.g_varchar2,
748: p_mat_information20 in varchar2 default hr_api.g_varchar2,
749: p_mat_information21 in varchar2 default hr_api.g_varchar2,
750: p_mat_information22 in varchar2 default hr_api.g_varchar2,
751: p_mat_information23 in varchar2 default hr_api.g_varchar2,
752: p_mat_information24 in varchar2 default hr_api.g_varchar2,
753: p_mat_information25 in varchar2 default hr_api.g_varchar2,
754: p_mat_information26 in varchar2 default hr_api.g_varchar2,
755: p_mat_information27 in varchar2 default hr_api.g_varchar2,

Line 752: p_mat_information24 in varchar2 default hr_api.g_varchar2,

748: p_mat_information20 in varchar2 default hr_api.g_varchar2,
749: p_mat_information21 in varchar2 default hr_api.g_varchar2,
750: p_mat_information22 in varchar2 default hr_api.g_varchar2,
751: p_mat_information23 in varchar2 default hr_api.g_varchar2,
752: p_mat_information24 in varchar2 default hr_api.g_varchar2,
753: p_mat_information25 in varchar2 default hr_api.g_varchar2,
754: p_mat_information26 in varchar2 default hr_api.g_varchar2,
755: p_mat_information27 in varchar2 default hr_api.g_varchar2,
756: p_mat_information28 in varchar2 default hr_api.g_varchar2,

Line 753: p_mat_information25 in varchar2 default hr_api.g_varchar2,

749: p_mat_information21 in varchar2 default hr_api.g_varchar2,
750: p_mat_information22 in varchar2 default hr_api.g_varchar2,
751: p_mat_information23 in varchar2 default hr_api.g_varchar2,
752: p_mat_information24 in varchar2 default hr_api.g_varchar2,
753: p_mat_information25 in varchar2 default hr_api.g_varchar2,
754: p_mat_information26 in varchar2 default hr_api.g_varchar2,
755: p_mat_information27 in varchar2 default hr_api.g_varchar2,
756: p_mat_information28 in varchar2 default hr_api.g_varchar2,
757: p_mat_information29 in varchar2 default hr_api.g_varchar2,

Line 754: p_mat_information26 in varchar2 default hr_api.g_varchar2,

750: p_mat_information22 in varchar2 default hr_api.g_varchar2,
751: p_mat_information23 in varchar2 default hr_api.g_varchar2,
752: p_mat_information24 in varchar2 default hr_api.g_varchar2,
753: p_mat_information25 in varchar2 default hr_api.g_varchar2,
754: p_mat_information26 in varchar2 default hr_api.g_varchar2,
755: p_mat_information27 in varchar2 default hr_api.g_varchar2,
756: p_mat_information28 in varchar2 default hr_api.g_varchar2,
757: p_mat_information29 in varchar2 default hr_api.g_varchar2,
758: p_mat_information30 in varchar2 default hr_api.g_varchar2,

Line 755: p_mat_information27 in varchar2 default hr_api.g_varchar2,

751: p_mat_information23 in varchar2 default hr_api.g_varchar2,
752: p_mat_information24 in varchar2 default hr_api.g_varchar2,
753: p_mat_information25 in varchar2 default hr_api.g_varchar2,
754: p_mat_information26 in varchar2 default hr_api.g_varchar2,
755: p_mat_information27 in varchar2 default hr_api.g_varchar2,
756: p_mat_information28 in varchar2 default hr_api.g_varchar2,
757: p_mat_information29 in varchar2 default hr_api.g_varchar2,
758: p_mat_information30 in varchar2 default hr_api.g_varchar2,
759: p_partner_stat_pay_start_date in date default hr_api.g_date,

Line 756: p_mat_information28 in varchar2 default hr_api.g_varchar2,

752: p_mat_information24 in varchar2 default hr_api.g_varchar2,
753: p_mat_information25 in varchar2 default hr_api.g_varchar2,
754: p_mat_information26 in varchar2 default hr_api.g_varchar2,
755: p_mat_information27 in varchar2 default hr_api.g_varchar2,
756: p_mat_information28 in varchar2 default hr_api.g_varchar2,
757: p_mat_information29 in varchar2 default hr_api.g_varchar2,
758: p_mat_information30 in varchar2 default hr_api.g_varchar2,
759: p_partner_stat_pay_start_date in date default hr_api.g_date,
760: p_partner_return_to_work in date default hr_api.g_date,

Line 757: p_mat_information29 in varchar2 default hr_api.g_varchar2,

753: p_mat_information25 in varchar2 default hr_api.g_varchar2,
754: p_mat_information26 in varchar2 default hr_api.g_varchar2,
755: p_mat_information27 in varchar2 default hr_api.g_varchar2,
756: p_mat_information28 in varchar2 default hr_api.g_varchar2,
757: p_mat_information29 in varchar2 default hr_api.g_varchar2,
758: p_mat_information30 in varchar2 default hr_api.g_varchar2,
759: p_partner_stat_pay_start_date in date default hr_api.g_date,
760: p_partner_return_to_work in date default hr_api.g_date,
761: p_partner_death_date in date default hr_api.g_date

Line 758: p_mat_information30 in varchar2 default hr_api.g_varchar2,

754: p_mat_information26 in varchar2 default hr_api.g_varchar2,
755: p_mat_information27 in varchar2 default hr_api.g_varchar2,
756: p_mat_information28 in varchar2 default hr_api.g_varchar2,
757: p_mat_information29 in varchar2 default hr_api.g_varchar2,
758: p_mat_information30 in varchar2 default hr_api.g_varchar2,
759: p_partner_stat_pay_start_date in date default hr_api.g_date,
760: p_partner_return_to_work in date default hr_api.g_date,
761: p_partner_death_date in date default hr_api.g_date
762: ) is

Line 759: p_partner_stat_pay_start_date in date default hr_api.g_date,

755: p_mat_information27 in varchar2 default hr_api.g_varchar2,
756: p_mat_information28 in varchar2 default hr_api.g_varchar2,
757: p_mat_information29 in varchar2 default hr_api.g_varchar2,
758: p_mat_information30 in varchar2 default hr_api.g_varchar2,
759: p_partner_stat_pay_start_date in date default hr_api.g_date,
760: p_partner_return_to_work in date default hr_api.g_date,
761: p_partner_death_date in date default hr_api.g_date
762: ) is
763: --

Line 760: p_partner_return_to_work in date default hr_api.g_date,

756: p_mat_information28 in varchar2 default hr_api.g_varchar2,
757: p_mat_information29 in varchar2 default hr_api.g_varchar2,
758: p_mat_information30 in varchar2 default hr_api.g_varchar2,
759: p_partner_stat_pay_start_date in date default hr_api.g_date,
760: p_partner_return_to_work in date default hr_api.g_date,
761: p_partner_death_date in date default hr_api.g_date
762: ) is
763: --
764: l_rec ssp_mat_shd.g_rec_type;

Line 761: p_partner_death_date in date default hr_api.g_date

757: p_mat_information29 in varchar2 default hr_api.g_varchar2,
758: p_mat_information30 in varchar2 default hr_api.g_varchar2,
759: p_partner_stat_pay_start_date in date default hr_api.g_date,
760: p_partner_return_to_work in date default hr_api.g_date,
761: p_partner_death_date in date default hr_api.g_date
762: ) is
763: --
764: l_rec ssp_mat_shd.g_rec_type;
765: l_proc varchar2(72) := g_package||'upd';

Line 778: hr_api.g_number,

774: ssp_mat_shd.convert_args
775: (
776: p_maternity_id,
777: p_due_date,
778: hr_api.g_number,
779: p_start_date_SMA,
780: p_notification_of_birth_date,
781: p_unfit_for_scheduled_return,
782: p_stated_return_date,