DBA Data[Home] [Help]

APPS.PER_PJU_UPD dependencies on PER_PJU_SHD

Line 55: (p_rec in out nocopy per_pju_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_pju_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 134: per_pju_shd.constraint_error

130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: --
134: per_pju_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --

Line 139: per_pju_shd.constraint_error

135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
139: per_pju_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --

Line 144: per_pju_shd.constraint_error

140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
144: per_pju_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: --
148: Raise;

Line 184: (p_rec in per_pju_shd.g_rec_type

180: --
181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure pre_update
184: (p_rec in per_pju_shd.g_rec_type
185: ) is
186: --
187: l_proc varchar2(72) := g_package||'pre_update';
188: --

Line 228: (p_rec in per_pju_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure post_update
228: (p_rec in per_pju_shd.g_rec_type
229: ) is
230: --
231: l_proc varchar2(72) := g_package||'post_update';
232: --

Line 401: (p_rec in out nocopy per_pju_shd.g_rec_type

397: --
398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: Procedure convert_defs
401: (p_rec in out nocopy per_pju_shd.g_rec_type
402: ) is
403: --
404: Begin
405: --

Line 413: per_pju_shd.g_old_rec.assignment_id;

409: -- is being used then we must set to the 'current' argument value.
410: --
411: If (p_rec.assignment_id = hr_api.g_number) then
412: p_rec.assignment_id :=
413: per_pju_shd.g_old_rec.assignment_id;
414: End If;
415: If (p_rec.previous_employer_id = hr_api.g_number) then
416: p_rec.previous_employer_id :=
417: per_pju_shd.g_old_rec.previous_employer_id;

Line 417: per_pju_shd.g_old_rec.previous_employer_id;

413: per_pju_shd.g_old_rec.assignment_id;
414: End If;
415: If (p_rec.previous_employer_id = hr_api.g_number) then
416: p_rec.previous_employer_id :=
417: per_pju_shd.g_old_rec.previous_employer_id;
418: End If;
419: If (p_rec.previous_job_id = hr_api.g_number) then
420: p_rec.previous_job_id :=
421: per_pju_shd.g_old_rec.previous_job_id;

Line 421: per_pju_shd.g_old_rec.previous_job_id;

417: per_pju_shd.g_old_rec.previous_employer_id;
418: End If;
419: If (p_rec.previous_job_id = hr_api.g_number) then
420: p_rec.previous_job_id :=
421: per_pju_shd.g_old_rec.previous_job_id;
422: End If;
423: If (p_rec.start_date = hr_api.g_date) then
424: p_rec.start_date :=
425: per_pju_shd.g_old_rec.start_date;

Line 425: per_pju_shd.g_old_rec.start_date;

421: per_pju_shd.g_old_rec.previous_job_id;
422: End If;
423: If (p_rec.start_date = hr_api.g_date) then
424: p_rec.start_date :=
425: per_pju_shd.g_old_rec.start_date;
426: End If;
427: If (p_rec.end_date = hr_api.g_date) then
428: p_rec.end_date :=
429: per_pju_shd.g_old_rec.end_date;

Line 429: per_pju_shd.g_old_rec.end_date;

425: per_pju_shd.g_old_rec.start_date;
426: End If;
427: If (p_rec.end_date = hr_api.g_date) then
428: p_rec.end_date :=
429: per_pju_shd.g_old_rec.end_date;
430: End If;
431: If (p_rec.period_years = hr_api.g_number) then
432: p_rec.period_years :=
433: per_pju_shd.g_old_rec.period_years;

Line 433: per_pju_shd.g_old_rec.period_years;

429: per_pju_shd.g_old_rec.end_date;
430: End If;
431: If (p_rec.period_years = hr_api.g_number) then
432: p_rec.period_years :=
433: per_pju_shd.g_old_rec.period_years;
434: End If;
435: If (p_rec.period_months = hr_api.g_number) then
436: p_rec.period_months :=
437: per_pju_shd.g_old_rec.period_months;

Line 437: per_pju_shd.g_old_rec.period_months;

433: per_pju_shd.g_old_rec.period_years;
434: End If;
435: If (p_rec.period_months = hr_api.g_number) then
436: p_rec.period_months :=
437: per_pju_shd.g_old_rec.period_months;
438: End If;
439: If (p_rec.period_days = hr_api.g_number) then
440: p_rec.period_days :=
441: per_pju_shd.g_old_rec.period_days;

Line 441: per_pju_shd.g_old_rec.period_days;

437: per_pju_shd.g_old_rec.period_months;
438: End If;
439: If (p_rec.period_days = hr_api.g_number) then
440: p_rec.period_days :=
441: per_pju_shd.g_old_rec.period_days;
442: End If;
443: If (p_rec.pju_attribute_category = hr_api.g_varchar2) then
444: p_rec.pju_attribute_category :=
445: per_pju_shd.g_old_rec.pju_attribute_category;

Line 445: per_pju_shd.g_old_rec.pju_attribute_category;

441: per_pju_shd.g_old_rec.period_days;
442: End If;
443: If (p_rec.pju_attribute_category = hr_api.g_varchar2) then
444: p_rec.pju_attribute_category :=
445: per_pju_shd.g_old_rec.pju_attribute_category;
446: End If;
447: If (p_rec.pju_attribute1 = hr_api.g_varchar2) then
448: p_rec.pju_attribute1 :=
449: per_pju_shd.g_old_rec.pju_attribute1;

Line 449: per_pju_shd.g_old_rec.pju_attribute1;

445: per_pju_shd.g_old_rec.pju_attribute_category;
446: End If;
447: If (p_rec.pju_attribute1 = hr_api.g_varchar2) then
448: p_rec.pju_attribute1 :=
449: per_pju_shd.g_old_rec.pju_attribute1;
450: End If;
451: If (p_rec.pju_attribute2 = hr_api.g_varchar2) then
452: p_rec.pju_attribute2 :=
453: per_pju_shd.g_old_rec.pju_attribute2;

Line 453: per_pju_shd.g_old_rec.pju_attribute2;

449: per_pju_shd.g_old_rec.pju_attribute1;
450: End If;
451: If (p_rec.pju_attribute2 = hr_api.g_varchar2) then
452: p_rec.pju_attribute2 :=
453: per_pju_shd.g_old_rec.pju_attribute2;
454: End If;
455: If (p_rec.pju_attribute3 = hr_api.g_varchar2) then
456: p_rec.pju_attribute3 :=
457: per_pju_shd.g_old_rec.pju_attribute3;

Line 457: per_pju_shd.g_old_rec.pju_attribute3;

453: per_pju_shd.g_old_rec.pju_attribute2;
454: End If;
455: If (p_rec.pju_attribute3 = hr_api.g_varchar2) then
456: p_rec.pju_attribute3 :=
457: per_pju_shd.g_old_rec.pju_attribute3;
458: End If;
459: If (p_rec.pju_attribute4 = hr_api.g_varchar2) then
460: p_rec.pju_attribute4 :=
461: per_pju_shd.g_old_rec.pju_attribute4;

Line 461: per_pju_shd.g_old_rec.pju_attribute4;

457: per_pju_shd.g_old_rec.pju_attribute3;
458: End If;
459: If (p_rec.pju_attribute4 = hr_api.g_varchar2) then
460: p_rec.pju_attribute4 :=
461: per_pju_shd.g_old_rec.pju_attribute4;
462: End If;
463: If (p_rec.pju_attribute5 = hr_api.g_varchar2) then
464: p_rec.pju_attribute5 :=
465: per_pju_shd.g_old_rec.pju_attribute5;

Line 465: per_pju_shd.g_old_rec.pju_attribute5;

461: per_pju_shd.g_old_rec.pju_attribute4;
462: End If;
463: If (p_rec.pju_attribute5 = hr_api.g_varchar2) then
464: p_rec.pju_attribute5 :=
465: per_pju_shd.g_old_rec.pju_attribute5;
466: End If;
467: If (p_rec.pju_attribute6 = hr_api.g_varchar2) then
468: p_rec.pju_attribute6 :=
469: per_pju_shd.g_old_rec.pju_attribute6;

Line 469: per_pju_shd.g_old_rec.pju_attribute6;

465: per_pju_shd.g_old_rec.pju_attribute5;
466: End If;
467: If (p_rec.pju_attribute6 = hr_api.g_varchar2) then
468: p_rec.pju_attribute6 :=
469: per_pju_shd.g_old_rec.pju_attribute6;
470: End If;
471: If (p_rec.pju_attribute7 = hr_api.g_varchar2) then
472: p_rec.pju_attribute7 :=
473: per_pju_shd.g_old_rec.pju_attribute7;

Line 473: per_pju_shd.g_old_rec.pju_attribute7;

469: per_pju_shd.g_old_rec.pju_attribute6;
470: End If;
471: If (p_rec.pju_attribute7 = hr_api.g_varchar2) then
472: p_rec.pju_attribute7 :=
473: per_pju_shd.g_old_rec.pju_attribute7;
474: End If;
475: If (p_rec.pju_attribute8 = hr_api.g_varchar2) then
476: p_rec.pju_attribute8 :=
477: per_pju_shd.g_old_rec.pju_attribute8;

Line 477: per_pju_shd.g_old_rec.pju_attribute8;

473: per_pju_shd.g_old_rec.pju_attribute7;
474: End If;
475: If (p_rec.pju_attribute8 = hr_api.g_varchar2) then
476: p_rec.pju_attribute8 :=
477: per_pju_shd.g_old_rec.pju_attribute8;
478: End If;
479: If (p_rec.pju_attribute9 = hr_api.g_varchar2) then
480: p_rec.pju_attribute9 :=
481: per_pju_shd.g_old_rec.pju_attribute9;

Line 481: per_pju_shd.g_old_rec.pju_attribute9;

477: per_pju_shd.g_old_rec.pju_attribute8;
478: End If;
479: If (p_rec.pju_attribute9 = hr_api.g_varchar2) then
480: p_rec.pju_attribute9 :=
481: per_pju_shd.g_old_rec.pju_attribute9;
482: End If;
483: If (p_rec.pju_attribute10 = hr_api.g_varchar2) then
484: p_rec.pju_attribute10 :=
485: per_pju_shd.g_old_rec.pju_attribute10;

Line 485: per_pju_shd.g_old_rec.pju_attribute10;

481: per_pju_shd.g_old_rec.pju_attribute9;
482: End If;
483: If (p_rec.pju_attribute10 = hr_api.g_varchar2) then
484: p_rec.pju_attribute10 :=
485: per_pju_shd.g_old_rec.pju_attribute10;
486: End If;
487: If (p_rec.pju_attribute11 = hr_api.g_varchar2) then
488: p_rec.pju_attribute11 :=
489: per_pju_shd.g_old_rec.pju_attribute11;

Line 489: per_pju_shd.g_old_rec.pju_attribute11;

485: per_pju_shd.g_old_rec.pju_attribute10;
486: End If;
487: If (p_rec.pju_attribute11 = hr_api.g_varchar2) then
488: p_rec.pju_attribute11 :=
489: per_pju_shd.g_old_rec.pju_attribute11;
490: End If;
491: If (p_rec.pju_attribute12 = hr_api.g_varchar2) then
492: p_rec.pju_attribute12 :=
493: per_pju_shd.g_old_rec.pju_attribute12;

Line 493: per_pju_shd.g_old_rec.pju_attribute12;

489: per_pju_shd.g_old_rec.pju_attribute11;
490: End If;
491: If (p_rec.pju_attribute12 = hr_api.g_varchar2) then
492: p_rec.pju_attribute12 :=
493: per_pju_shd.g_old_rec.pju_attribute12;
494: End If;
495: If (p_rec.pju_attribute13 = hr_api.g_varchar2) then
496: p_rec.pju_attribute13 :=
497: per_pju_shd.g_old_rec.pju_attribute13;

Line 497: per_pju_shd.g_old_rec.pju_attribute13;

493: per_pju_shd.g_old_rec.pju_attribute12;
494: End If;
495: If (p_rec.pju_attribute13 = hr_api.g_varchar2) then
496: p_rec.pju_attribute13 :=
497: per_pju_shd.g_old_rec.pju_attribute13;
498: End If;
499: If (p_rec.pju_attribute14 = hr_api.g_varchar2) then
500: p_rec.pju_attribute14 :=
501: per_pju_shd.g_old_rec.pju_attribute14;

Line 501: per_pju_shd.g_old_rec.pju_attribute14;

497: per_pju_shd.g_old_rec.pju_attribute13;
498: End If;
499: If (p_rec.pju_attribute14 = hr_api.g_varchar2) then
500: p_rec.pju_attribute14 :=
501: per_pju_shd.g_old_rec.pju_attribute14;
502: End If;
503: If (p_rec.pju_attribute15 = hr_api.g_varchar2) then
504: p_rec.pju_attribute15 :=
505: per_pju_shd.g_old_rec.pju_attribute15;

Line 505: per_pju_shd.g_old_rec.pju_attribute15;

501: per_pju_shd.g_old_rec.pju_attribute14;
502: End If;
503: If (p_rec.pju_attribute15 = hr_api.g_varchar2) then
504: p_rec.pju_attribute15 :=
505: per_pju_shd.g_old_rec.pju_attribute15;
506: End If;
507: If (p_rec.pju_attribute16 = hr_api.g_varchar2) then
508: p_rec.pju_attribute16 :=
509: per_pju_shd.g_old_rec.pju_attribute16;

Line 509: per_pju_shd.g_old_rec.pju_attribute16;

505: per_pju_shd.g_old_rec.pju_attribute15;
506: End If;
507: If (p_rec.pju_attribute16 = hr_api.g_varchar2) then
508: p_rec.pju_attribute16 :=
509: per_pju_shd.g_old_rec.pju_attribute16;
510: End If;
511: If (p_rec.pju_attribute17 = hr_api.g_varchar2) then
512: p_rec.pju_attribute17 :=
513: per_pju_shd.g_old_rec.pju_attribute17;

Line 513: per_pju_shd.g_old_rec.pju_attribute17;

509: per_pju_shd.g_old_rec.pju_attribute16;
510: End If;
511: If (p_rec.pju_attribute17 = hr_api.g_varchar2) then
512: p_rec.pju_attribute17 :=
513: per_pju_shd.g_old_rec.pju_attribute17;
514: End If;
515: If (p_rec.pju_attribute18 = hr_api.g_varchar2) then
516: p_rec.pju_attribute18 :=
517: per_pju_shd.g_old_rec.pju_attribute18;

Line 517: per_pju_shd.g_old_rec.pju_attribute18;

513: per_pju_shd.g_old_rec.pju_attribute17;
514: End If;
515: If (p_rec.pju_attribute18 = hr_api.g_varchar2) then
516: p_rec.pju_attribute18 :=
517: per_pju_shd.g_old_rec.pju_attribute18;
518: End If;
519: If (p_rec.pju_attribute19 = hr_api.g_varchar2) then
520: p_rec.pju_attribute19 :=
521: per_pju_shd.g_old_rec.pju_attribute19;

Line 521: per_pju_shd.g_old_rec.pju_attribute19;

517: per_pju_shd.g_old_rec.pju_attribute18;
518: End If;
519: If (p_rec.pju_attribute19 = hr_api.g_varchar2) then
520: p_rec.pju_attribute19 :=
521: per_pju_shd.g_old_rec.pju_attribute19;
522: End If;
523: If (p_rec.pju_attribute20 = hr_api.g_varchar2) then
524: p_rec.pju_attribute20 :=
525: per_pju_shd.g_old_rec.pju_attribute20;

Line 525: per_pju_shd.g_old_rec.pju_attribute20;

521: per_pju_shd.g_old_rec.pju_attribute19;
522: End If;
523: If (p_rec.pju_attribute20 = hr_api.g_varchar2) then
524: p_rec.pju_attribute20 :=
525: per_pju_shd.g_old_rec.pju_attribute20;
526: End If;
527: If (p_rec.pju_information_category = hr_api.g_varchar2) then
528: p_rec.pju_information_category :=
529: per_pju_shd.g_old_rec.pju_information_category;

Line 529: per_pju_shd.g_old_rec.pju_information_category;

525: per_pju_shd.g_old_rec.pju_attribute20;
526: End If;
527: If (p_rec.pju_information_category = hr_api.g_varchar2) then
528: p_rec.pju_information_category :=
529: per_pju_shd.g_old_rec.pju_information_category;
530: End If;
531: If (p_rec.pju_information1 = hr_api.g_varchar2) then
532: p_rec.pju_information1 :=
533: per_pju_shd.g_old_rec.pju_information1;

Line 533: per_pju_shd.g_old_rec.pju_information1;

529: per_pju_shd.g_old_rec.pju_information_category;
530: End If;
531: If (p_rec.pju_information1 = hr_api.g_varchar2) then
532: p_rec.pju_information1 :=
533: per_pju_shd.g_old_rec.pju_information1;
534: End If;
535: If (p_rec.pju_information2 = hr_api.g_varchar2) then
536: p_rec.pju_information2 :=
537: per_pju_shd.g_old_rec.pju_information2;

Line 537: per_pju_shd.g_old_rec.pju_information2;

533: per_pju_shd.g_old_rec.pju_information1;
534: End If;
535: If (p_rec.pju_information2 = hr_api.g_varchar2) then
536: p_rec.pju_information2 :=
537: per_pju_shd.g_old_rec.pju_information2;
538: End If;
539: If (p_rec.pju_information3 = hr_api.g_varchar2) then
540: p_rec.pju_information3 :=
541: per_pju_shd.g_old_rec.pju_information3;

Line 541: per_pju_shd.g_old_rec.pju_information3;

537: per_pju_shd.g_old_rec.pju_information2;
538: End If;
539: If (p_rec.pju_information3 = hr_api.g_varchar2) then
540: p_rec.pju_information3 :=
541: per_pju_shd.g_old_rec.pju_information3;
542: End If;
543: If (p_rec.pju_information4 = hr_api.g_varchar2) then
544: p_rec.pju_information4 :=
545: per_pju_shd.g_old_rec.pju_information4;

Line 545: per_pju_shd.g_old_rec.pju_information4;

541: per_pju_shd.g_old_rec.pju_information3;
542: End If;
543: If (p_rec.pju_information4 = hr_api.g_varchar2) then
544: p_rec.pju_information4 :=
545: per_pju_shd.g_old_rec.pju_information4;
546: End If;
547: If (p_rec.pju_information5 = hr_api.g_varchar2) then
548: p_rec.pju_information5 :=
549: per_pju_shd.g_old_rec.pju_information5;

Line 549: per_pju_shd.g_old_rec.pju_information5;

545: per_pju_shd.g_old_rec.pju_information4;
546: End If;
547: If (p_rec.pju_information5 = hr_api.g_varchar2) then
548: p_rec.pju_information5 :=
549: per_pju_shd.g_old_rec.pju_information5;
550: End If;
551: If (p_rec.pju_information6 = hr_api.g_varchar2) then
552: p_rec.pju_information6 :=
553: per_pju_shd.g_old_rec.pju_information6;

Line 553: per_pju_shd.g_old_rec.pju_information6;

549: per_pju_shd.g_old_rec.pju_information5;
550: End If;
551: If (p_rec.pju_information6 = hr_api.g_varchar2) then
552: p_rec.pju_information6 :=
553: per_pju_shd.g_old_rec.pju_information6;
554: End If;
555: If (p_rec.pju_information7 = hr_api.g_varchar2) then
556: p_rec.pju_information7 :=
557: per_pju_shd.g_old_rec.pju_information7;

Line 557: per_pju_shd.g_old_rec.pju_information7;

553: per_pju_shd.g_old_rec.pju_information6;
554: End If;
555: If (p_rec.pju_information7 = hr_api.g_varchar2) then
556: p_rec.pju_information7 :=
557: per_pju_shd.g_old_rec.pju_information7;
558: End If;
559: If (p_rec.pju_information8 = hr_api.g_varchar2) then
560: p_rec.pju_information8 :=
561: per_pju_shd.g_old_rec.pju_information8;

Line 561: per_pju_shd.g_old_rec.pju_information8;

557: per_pju_shd.g_old_rec.pju_information7;
558: End If;
559: If (p_rec.pju_information8 = hr_api.g_varchar2) then
560: p_rec.pju_information8 :=
561: per_pju_shd.g_old_rec.pju_information8;
562: End If;
563: If (p_rec.pju_information9 = hr_api.g_varchar2) then
564: p_rec.pju_information9 :=
565: per_pju_shd.g_old_rec.pju_information9;

Line 565: per_pju_shd.g_old_rec.pju_information9;

561: per_pju_shd.g_old_rec.pju_information8;
562: End If;
563: If (p_rec.pju_information9 = hr_api.g_varchar2) then
564: p_rec.pju_information9 :=
565: per_pju_shd.g_old_rec.pju_information9;
566: End If;
567: If (p_rec.pju_information10 = hr_api.g_varchar2) then
568: p_rec.pju_information10 :=
569: per_pju_shd.g_old_rec.pju_information10;

Line 569: per_pju_shd.g_old_rec.pju_information10;

565: per_pju_shd.g_old_rec.pju_information9;
566: End If;
567: If (p_rec.pju_information10 = hr_api.g_varchar2) then
568: p_rec.pju_information10 :=
569: per_pju_shd.g_old_rec.pju_information10;
570: End If;
571: If (p_rec.pju_information11 = hr_api.g_varchar2) then
572: p_rec.pju_information11 :=
573: per_pju_shd.g_old_rec.pju_information11;

Line 573: per_pju_shd.g_old_rec.pju_information11;

569: per_pju_shd.g_old_rec.pju_information10;
570: End If;
571: If (p_rec.pju_information11 = hr_api.g_varchar2) then
572: p_rec.pju_information11 :=
573: per_pju_shd.g_old_rec.pju_information11;
574: End If;
575: If (p_rec.pju_information12 = hr_api.g_varchar2) then
576: p_rec.pju_information12 :=
577: per_pju_shd.g_old_rec.pju_information12;

Line 577: per_pju_shd.g_old_rec.pju_information12;

573: per_pju_shd.g_old_rec.pju_information11;
574: End If;
575: If (p_rec.pju_information12 = hr_api.g_varchar2) then
576: p_rec.pju_information12 :=
577: per_pju_shd.g_old_rec.pju_information12;
578: End If;
579: If (p_rec.pju_information13 = hr_api.g_varchar2) then
580: p_rec.pju_information13 :=
581: per_pju_shd.g_old_rec.pju_information13;

Line 581: per_pju_shd.g_old_rec.pju_information13;

577: per_pju_shd.g_old_rec.pju_information12;
578: End If;
579: If (p_rec.pju_information13 = hr_api.g_varchar2) then
580: p_rec.pju_information13 :=
581: per_pju_shd.g_old_rec.pju_information13;
582: End If;
583: If (p_rec.pju_information14 = hr_api.g_varchar2) then
584: p_rec.pju_information14 :=
585: per_pju_shd.g_old_rec.pju_information14;

Line 585: per_pju_shd.g_old_rec.pju_information14;

581: per_pju_shd.g_old_rec.pju_information13;
582: End If;
583: If (p_rec.pju_information14 = hr_api.g_varchar2) then
584: p_rec.pju_information14 :=
585: per_pju_shd.g_old_rec.pju_information14;
586: End If;
587: If (p_rec.pju_information15 = hr_api.g_varchar2) then
588: p_rec.pju_information15 :=
589: per_pju_shd.g_old_rec.pju_information15;

Line 589: per_pju_shd.g_old_rec.pju_information15;

585: per_pju_shd.g_old_rec.pju_information14;
586: End If;
587: If (p_rec.pju_information15 = hr_api.g_varchar2) then
588: p_rec.pju_information15 :=
589: per_pju_shd.g_old_rec.pju_information15;
590: End If;
591: If (p_rec.pju_information16 = hr_api.g_varchar2) then
592: p_rec.pju_information16 :=
593: per_pju_shd.g_old_rec.pju_information16;

Line 593: per_pju_shd.g_old_rec.pju_information16;

589: per_pju_shd.g_old_rec.pju_information15;
590: End If;
591: If (p_rec.pju_information16 = hr_api.g_varchar2) then
592: p_rec.pju_information16 :=
593: per_pju_shd.g_old_rec.pju_information16;
594: End If;
595: If (p_rec.pju_information17 = hr_api.g_varchar2) then
596: p_rec.pju_information17 :=
597: per_pju_shd.g_old_rec.pju_information17;

Line 597: per_pju_shd.g_old_rec.pju_information17;

593: per_pju_shd.g_old_rec.pju_information16;
594: End If;
595: If (p_rec.pju_information17 = hr_api.g_varchar2) then
596: p_rec.pju_information17 :=
597: per_pju_shd.g_old_rec.pju_information17;
598: End If;
599: If (p_rec.pju_information18 = hr_api.g_varchar2) then
600: p_rec.pju_information18 :=
601: per_pju_shd.g_old_rec.pju_information18;

Line 601: per_pju_shd.g_old_rec.pju_information18;

597: per_pju_shd.g_old_rec.pju_information17;
598: End If;
599: If (p_rec.pju_information18 = hr_api.g_varchar2) then
600: p_rec.pju_information18 :=
601: per_pju_shd.g_old_rec.pju_information18;
602: End If;
603: If (p_rec.pju_information19 = hr_api.g_varchar2) then
604: p_rec.pju_information19 :=
605: per_pju_shd.g_old_rec.pju_information19;

Line 605: per_pju_shd.g_old_rec.pju_information19;

601: per_pju_shd.g_old_rec.pju_information18;
602: End If;
603: If (p_rec.pju_information19 = hr_api.g_varchar2) then
604: p_rec.pju_information19 :=
605: per_pju_shd.g_old_rec.pju_information19;
606: End If;
607: If (p_rec.pju_information20 = hr_api.g_varchar2) then
608: p_rec.pju_information20 :=
609: per_pju_shd.g_old_rec.pju_information20;

Line 609: per_pju_shd.g_old_rec.pju_information20;

605: per_pju_shd.g_old_rec.pju_information19;
606: End If;
607: If (p_rec.pju_information20 = hr_api.g_varchar2) then
608: p_rec.pju_information20 :=
609: per_pju_shd.g_old_rec.pju_information20;
610: End If;
611: --
612: End convert_defs;
613: --

Line 618: (p_rec in out nocopy per_pju_shd.g_rec_type

614: -- ----------------------------------------------------------------------------
615: -- |---------------------------------< upd >----------------------------------|
616: -- ----------------------------------------------------------------------------
617: Procedure upd
618: (p_rec in out nocopy per_pju_shd.g_rec_type
619: ) is
620: --
621: l_proc varchar2(72) := g_package||'upd';
622: --

Line 628: per_pju_shd.lck

624: hr_utility.set_location('Entering:'||l_proc, 5);
625: --
626: -- We must lock the row which we need to update.
627: --
628: per_pju_shd.lck
629: (p_rec.previous_job_usage_id
630: ,p_rec.object_version_number
631: );
632: --

Line 717: l_rec per_pju_shd.g_rec_type;

713: ,p_pju_information19 in varchar2 default hr_api.g_varchar2
714: ,p_pju_information20 in varchar2 default hr_api.g_varchar2
715: ) is
716: --
717: l_rec per_pju_shd.g_rec_type;
718: l_proc varchar2(72) := g_package||'upd';
719: --
720: Begin
721: hr_utility.set_location('Entering:'||l_proc, 5);

Line 727: per_pju_shd.convert_args

723: -- Call conversion function to turn arguments into the
724: -- l_rec structure.
725: --
726: l_rec :=
727: per_pju_shd.convert_args
728: (p_previous_job_usage_id
729: ,p_assignment_id
730: ,p_previous_employer_id
731: ,p_previous_job_id