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 SSP_MAT_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ssp_mat_shd.g_rec_type) is

50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ssp_mat_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: ssp_mat_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ssp_mat_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ssp_maternities Row
68: --
69: update ssp_maternities

Line 142: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status

138: mat_information29 = p_rec.mat_information29,
139: mat_information30 = p_rec.mat_information30
140: where maternity_id = p_rec.maternity_id;
141: --
142: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: --
146: Exception

Line 149: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status

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));
152: When hr_api.parent_integrity_violated Then
153: -- Parent integrity has been violated

Line 150: ssp_mat_shd.constraint_error

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));
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

Line 154: 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));
157: When hr_api.unique_integrity_violated Then
158: -- Unique integrity has been violated

Line 155: 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));
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

Line 159: 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));
162: When Others Then
163: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status

Line 160: 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));
162: When Others Then
163: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
164: Raise;

Line 163: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status

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;
166: --
167: -- ----------------------------------------------------------------------------

Line 199: Procedure pre_update(p_rec in ssp_mat_shd.g_rec_type) is

195: -- Internal Table Handler Use Only.
196: --
197: -- {End Of Comments}
198: -- ----------------------------------------------------------------------------
199: Procedure pre_update(p_rec in ssp_mat_shd.g_rec_type) is
200: --
201: l_proc varchar2(72) := g_package||'pre_update';
202: --
203: Begin

Line 241: Procedure post_update(p_rec in ssp_mat_shd.g_rec_type) is

237: -- Internal Table Handler Use Only.
238: --
239: -- {End Of Comments}
240: -- ----------------------------------------------------------------------------
241: Procedure post_update(p_rec in ssp_mat_shd.g_rec_type) is
242: --
243: l_proc varchar2(72) := g_package||'post_update';
244: --
245: Begin

Line 295: Procedure convert_defs(p_rec in out nocopy ssp_mat_shd.g_rec_type) is

291: -- Internal Table Handler Use Only.
292: --
293: -- {End Of Comments}
294: -- ----------------------------------------------------------------------------
295: Procedure convert_defs(p_rec in out nocopy ssp_mat_shd.g_rec_type) is
296: --
297: l_proc varchar2(72) := g_package||'convert_defs';
298: --
299: Begin

Line 310: ssp_mat_shd.g_old_rec.due_date;

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
313: p_rec.person_id :=
314: ssp_mat_shd.g_old_rec.person_id;

Line 314: ssp_mat_shd.g_old_rec.person_id;

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
317: p_rec.start_date_maternity_allowance :=
318: ssp_mat_shd.g_old_rec.start_date_maternity_allowance;

Line 318: ssp_mat_shd.g_old_rec.start_date_maternity_allowance;

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
321: p_rec.notification_of_birth_date :=
322: ssp_mat_shd.g_old_rec.notification_of_birth_date;

Line 322: ssp_mat_shd.g_old_rec.notification_of_birth_date;

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
325: p_rec.unfit_for_scheduled_return :=
326: ssp_mat_shd.g_old_rec.unfit_for_scheduled_return;

Line 326: ssp_mat_shd.g_old_rec.unfit_for_scheduled_return;

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
329: p_rec.stated_return_date :=
330: ssp_mat_shd.g_old_rec.stated_return_date;

Line 330: ssp_mat_shd.g_old_rec.stated_return_date;

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
333: p_rec.intend_to_return_flag :=
334: ssp_mat_shd.g_old_rec.intend_to_return_flag;

Line 334: ssp_mat_shd.g_old_rec.intend_to_return_flag;

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
337: p_rec.start_date_with_new_employer :=
338: ssp_mat_shd.g_old_rec.start_date_with_new_employer;

Line 338: ssp_mat_shd.g_old_rec.start_date_with_new_employer;

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
341: p_rec.smp_must_be_paid_by_date :=
342: ssp_mat_shd.g_old_rec.smp_must_be_paid_by_date;

Line 342: ssp_mat_shd.g_old_rec.smp_must_be_paid_by_date;

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
345: p_rec.pay_smp_as_lump_sum :=
346: ssp_mat_shd.g_old_rec.pay_smp_as_lump_sum;

Line 346: ssp_mat_shd.g_old_rec.pay_smp_as_lump_sum;

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
349: p_rec.live_birth_flag :=
350: ssp_mat_shd.g_old_rec.live_birth_flag;

Line 350: ssp_mat_shd.g_old_rec.live_birth_flag;

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
353: p_rec.actual_birth_date :=
354: ssp_mat_shd.g_old_rec.actual_birth_date;

Line 354: ssp_mat_shd.g_old_rec.actual_birth_date;

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
357: p_rec.mpp_start_date :=
358: ssp_mat_shd.g_old_rec.mpp_start_date;

Line 358: ssp_mat_shd.g_old_rec.mpp_start_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
361: p_rec.attribute_category :=
362: ssp_mat_shd.g_old_rec.attribute_category;

Line 362: ssp_mat_shd.g_old_rec.attribute_category;

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
365: p_rec.attribute1 :=
366: ssp_mat_shd.g_old_rec.attribute1;

Line 366: ssp_mat_shd.g_old_rec.attribute1;

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
369: p_rec.attribute2 :=
370: ssp_mat_shd.g_old_rec.attribute2;

Line 370: ssp_mat_shd.g_old_rec.attribute2;

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
373: p_rec.attribute3 :=
374: ssp_mat_shd.g_old_rec.attribute3;

Line 374: ssp_mat_shd.g_old_rec.attribute3;

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
377: p_rec.attribute4 :=
378: ssp_mat_shd.g_old_rec.attribute4;

Line 378: ssp_mat_shd.g_old_rec.attribute4;

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
381: p_rec.attribute5 :=
382: ssp_mat_shd.g_old_rec.attribute5;

Line 382: ssp_mat_shd.g_old_rec.attribute5;

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
385: p_rec.attribute6 :=
386: ssp_mat_shd.g_old_rec.attribute6;

Line 386: ssp_mat_shd.g_old_rec.attribute6;

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
389: p_rec.attribute7 :=
390: ssp_mat_shd.g_old_rec.attribute7;

Line 390: ssp_mat_shd.g_old_rec.attribute7;

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
393: p_rec.attribute8 :=
394: ssp_mat_shd.g_old_rec.attribute8;

Line 394: ssp_mat_shd.g_old_rec.attribute8;

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
397: p_rec.attribute9 :=
398: ssp_mat_shd.g_old_rec.attribute9;

Line 398: ssp_mat_shd.g_old_rec.attribute9;

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
401: p_rec.attribute10 :=
402: ssp_mat_shd.g_old_rec.attribute10;

Line 402: ssp_mat_shd.g_old_rec.attribute10;

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
405: p_rec.attribute11 :=
406: ssp_mat_shd.g_old_rec.attribute11;

Line 406: ssp_mat_shd.g_old_rec.attribute11;

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
409: p_rec.attribute12 :=
410: ssp_mat_shd.g_old_rec.attribute12;

Line 410: ssp_mat_shd.g_old_rec.attribute12;

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
413: p_rec.attribute13 :=
414: ssp_mat_shd.g_old_rec.attribute13;

Line 414: ssp_mat_shd.g_old_rec.attribute13;

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
417: p_rec.attribute14 :=
418: ssp_mat_shd.g_old_rec.attribute14;

Line 418: ssp_mat_shd.g_old_rec.attribute14;

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
421: p_rec.attribute15 :=
422: ssp_mat_shd.g_old_rec.attribute15;

Line 422: ssp_mat_shd.g_old_rec.attribute15;

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
425: p_rec.attribute16 :=
426: ssp_mat_shd.g_old_rec.attribute16;

Line 426: ssp_mat_shd.g_old_rec.attribute16;

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
429: p_rec.attribute17 :=
430: ssp_mat_shd.g_old_rec.attribute17;

Line 430: ssp_mat_shd.g_old_rec.attribute17;

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
433: p_rec.attribute18 :=
434: ssp_mat_shd.g_old_rec.attribute18;

Line 434: ssp_mat_shd.g_old_rec.attribute18;

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
437: p_rec.attribute19 :=
438: ssp_mat_shd.g_old_rec.attribute19;

Line 438: ssp_mat_shd.g_old_rec.attribute19;

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
441: p_rec.attribute20 :=
442: ssp_mat_shd.g_old_rec.attribute20;

Line 442: ssp_mat_shd.g_old_rec.attribute20;

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:
445: If (p_rec.LEAVE_TYPE = hr_api.g_varchar2) then
446: p_rec.LEAVE_TYPE :=

Line 447: ssp_mat_shd.g_old_rec.LEAVE_TYPE;

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:
450: If (p_rec.MATCHING_DATE = hr_api.g_date) then
451: p_rec.MATCHING_DATE :=

Line 452: ssp_mat_shd.g_old_rec.MATCHING_DATE;

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:
455: If (p_rec.PLACEMENT_DATE = hr_api.g_date) then
456: p_rec.PLACEMENT_DATE :=

Line 457: ssp_mat_shd.g_old_rec.PLACEMENT_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:
460: If (p_rec.DISRUPTED_PLACEMENT_DATE = hr_api.g_date) then
461: p_rec.DISRUPTED_PLACEMENT_DATE :=

Line 462: ssp_mat_shd.g_old_rec.DISRUPTED_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:
465: If (p_rec.mat_information_category = hr_api.g_varchar2) then
466: p_rec.mat_information_category :=

Line 467: ssp_mat_shd.g_old_rec.mat_information_category;

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
470: p_rec.mat_information1 :=
471: ssp_mat_shd.g_old_rec.mat_information1;

Line 471: ssp_mat_shd.g_old_rec.mat_information1;

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
474: p_rec.mat_information1 :=
475: ssp_mat_shd.g_old_rec.mat_information1;

Line 475: ssp_mat_shd.g_old_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
478: p_rec.mat_information2 :=
479: ssp_mat_shd.g_old_rec.mat_information2;

Line 479: ssp_mat_shd.g_old_rec.mat_information2;

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
482: p_rec.mat_information3 :=
483: ssp_mat_shd.g_old_rec.mat_information3;

Line 483: ssp_mat_shd.g_old_rec.mat_information3;

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
486: p_rec.mat_information4 :=
487: ssp_mat_shd.g_old_rec.mat_information4;

Line 487: ssp_mat_shd.g_old_rec.mat_information4;

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
490: p_rec.mat_information5 :=
491: ssp_mat_shd.g_old_rec.mat_information5;

Line 491: ssp_mat_shd.g_old_rec.mat_information5;

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
494: p_rec.mat_information6 :=
495: ssp_mat_shd.g_old_rec.mat_information6;

Line 495: ssp_mat_shd.g_old_rec.mat_information6;

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
498: p_rec.mat_information7 :=
499: ssp_mat_shd.g_old_rec.mat_information7;

Line 499: ssp_mat_shd.g_old_rec.mat_information7;

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
502: p_rec.mat_information8 :=
503: ssp_mat_shd.g_old_rec.mat_information8;

Line 503: ssp_mat_shd.g_old_rec.mat_information8;

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
506: p_rec.mat_information9 :=
507: ssp_mat_shd.g_old_rec.mat_information9;

Line 507: ssp_mat_shd.g_old_rec.mat_information9;

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
510: p_rec.mat_information10 :=
511: ssp_mat_shd.g_old_rec.mat_information10;

Line 511: ssp_mat_shd.g_old_rec.mat_information10;

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
514: p_rec.mat_information11 :=
515: ssp_mat_shd.g_old_rec.mat_information11;

Line 515: ssp_mat_shd.g_old_rec.mat_information11;

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
518: p_rec.mat_information12 :=
519: ssp_mat_shd.g_old_rec.mat_information12;

Line 519: ssp_mat_shd.g_old_rec.mat_information12;

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
522: p_rec.mat_information13 :=
523: ssp_mat_shd.g_old_rec.mat_information13;

Line 523: ssp_mat_shd.g_old_rec.mat_information13;

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
526: p_rec.mat_information14 :=
527: ssp_mat_shd.g_old_rec.mat_information14;

Line 527: ssp_mat_shd.g_old_rec.mat_information14;

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
530: p_rec.mat_information15 :=
531: ssp_mat_shd.g_old_rec.mat_information15;

Line 531: ssp_mat_shd.g_old_rec.mat_information15;

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
534: p_rec.mat_information16 :=
535: ssp_mat_shd.g_old_rec.mat_information16;

Line 535: ssp_mat_shd.g_old_rec.mat_information16;

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
538: p_rec.mat_information17 :=
539: ssp_mat_shd.g_old_rec.mat_information17;

Line 539: ssp_mat_shd.g_old_rec.mat_information17;

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
542: p_rec.mat_information18 :=
543: ssp_mat_shd.g_old_rec.mat_information18;

Line 543: ssp_mat_shd.g_old_rec.mat_information18;

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
546: p_rec.mat_information19 :=
547: ssp_mat_shd.g_old_rec.mat_information19;

Line 547: ssp_mat_shd.g_old_rec.mat_information19;

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
550: p_rec.mat_information20 :=
551: ssp_mat_shd.g_old_rec.mat_information20;

Line 551: ssp_mat_shd.g_old_rec.mat_information20;

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
554: p_rec.mat_information21 :=
555: ssp_mat_shd.g_old_rec.mat_information21;

Line 555: ssp_mat_shd.g_old_rec.mat_information21;

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
558: p_rec.mat_information12 :=
559: ssp_mat_shd.g_old_rec.mat_information22;

Line 559: ssp_mat_shd.g_old_rec.mat_information22;

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
562: p_rec.mat_information23 :=
563: ssp_mat_shd.g_old_rec.mat_information23;

Line 563: ssp_mat_shd.g_old_rec.mat_information23;

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
566: p_rec.mat_information24 :=
567: ssp_mat_shd.g_old_rec.mat_information24;

Line 567: ssp_mat_shd.g_old_rec.mat_information24;

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
570: p_rec.mat_information25 :=
571: ssp_mat_shd.g_old_rec.mat_information25;

Line 571: ssp_mat_shd.g_old_rec.mat_information25;

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
574: p_rec.mat_information26 :=
575: ssp_mat_shd.g_old_rec.mat_information26;

Line 575: ssp_mat_shd.g_old_rec.mat_information26;

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
578: p_rec.mat_information27 :=
579: ssp_mat_shd.g_old_rec.mat_information27;

Line 579: ssp_mat_shd.g_old_rec.mat_information27;

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
582: p_rec.mat_information28 :=
583: ssp_mat_shd.g_old_rec.mat_information28;

Line 583: ssp_mat_shd.g_old_rec.mat_information28;

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
586: p_rec.mat_information29 :=
587: ssp_mat_shd.g_old_rec.mat_information29;

Line 587: ssp_mat_shd.g_old_rec.mat_information29;

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
590: p_rec.mat_information30 :=
591: ssp_mat_shd.g_old_rec.mat_information30;

Line 591: ssp_mat_shd.g_old_rec.mat_information30;

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: --
594: hr_utility.set_location(' Leaving:'||l_proc, 10);
595: --

Line 603: p_rec in out nocopy ssp_mat_shd.g_rec_type,

599: -- |---------------------------------< upd >----------------------------------|
600: -- ----------------------------------------------------------------------------
601: Procedure upd
602: (
603: p_rec in out nocopy ssp_mat_shd.g_rec_type,
604: p_validate in boolean default false
605: ) is
606: --
607: l_proc varchar2(72) := g_package||'upd';

Line 623: ssp_mat_shd.lck

619: End If;
620: --
621: -- We must lock the row which we need to update.
622: --
623: ssp_mat_shd.lck
624: (
625: p_rec.maternity_id,
626: p_rec.object_version_number
627: );

Line 744: l_rec ssp_mat_shd.g_rec_type;

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';
746: --
747: Begin
748: hr_utility.set_location('Entering:'||l_proc, 5);

Line 754: ssp_mat_shd.convert_args

750: -- Call conversion function to turn arguments into the
751: -- l_rec structure.
752: --
753: l_rec :=
754: ssp_mat_shd.convert_args
755: (
756: p_maternity_id,
757: p_due_date,
758: hr_api.g_number,