397: -- get the parameter values to pass to the API
398:
399: -- if (l_effective_date_row) then
400:
401: l_asg_rec.supervisor_id:= hr_dt_attribute_support.get_parameter_number
402: (p_effective_date_row => l_effective_date_row
403: ,p_parameter_name => 'P_SUPERVISOR_ID'
404: ,p_new_value => p_supervisor_id
405: ,p_current_value => c_supervisor_id);
404: ,p_new_value => p_supervisor_id
405: ,p_current_value => c_supervisor_id);
406:
407: -- Assignment Security
408: l_asg_rec.supervisor_assignment_id:= hr_dt_attribute_support.get_parameter_number
409: (p_effective_date_row => l_effective_date_row
410: ,p_parameter_name => 'P_SUPERVISOR_ASSIGNMENT_ID'
411: ,p_new_value => p_supervisor_assignment_id
412: ,p_current_value => c_supervisor_assignment_id);
411: ,p_new_value => p_supervisor_assignment_id
412: ,p_current_value => c_supervisor_assignment_id);
413:
414:
415: l_asg_rec.assignment_number:= hr_dt_attribute_support.get_parameter_char
416: (p_effective_date_row => l_effective_date_row
417: ,p_parameter_name => 'p_assignment_number'
418: ,p_new_value => p_assignment_number
419: ,p_current_value => c_assignment_number);
417: ,p_parameter_name => 'p_assignment_number'
418: ,p_new_value => p_assignment_number
419: ,p_current_value => c_assignment_number);
420:
421: l_asg_rec.change_reason:= hr_dt_attribute_support.get_parameter_char
422: (p_effective_date_row => l_effective_date_row
423: ,p_parameter_name => 'p_change_reason'
424: ,p_new_value => p_change_reason
425: ,p_current_value => c_change_reason);
423: ,p_parameter_name => 'p_change_reason'
424: ,p_new_value => p_change_reason
425: ,p_current_value => c_change_reason);
426:
427: l_comments:= hr_dt_attribute_support.get_parameter_char
428: (p_effective_date_row => l_effective_date_row
429: ,p_parameter_name => 'p_comments'
430: ,p_new_value => p_comments
431: ,p_current_value => c_comments);
429: ,p_parameter_name => 'p_comments'
430: ,p_new_value => p_comments
431: ,p_current_value => c_comments);
432:
433: l_asg_rec.date_probation_end:= hr_dt_attribute_support.get_parameter_date
434: (p_effective_date_row => l_effective_date_row
435: ,p_parameter_name => 'p_date_probation_end'
436: ,p_new_value => p_date_probation_end
437: ,p_current_value => c_date_probation_end);
436: ,p_new_value => p_date_probation_end
437: ,p_current_value => c_date_probation_end);
438:
439:
440: l_asg_rec.default_code_comb_id:= hr_dt_attribute_support.get_parameter_number
441: (p_effective_date_row => l_effective_date_row
442: ,p_parameter_name => 'p_default_code_comb_id'
443: ,p_new_value => p_default_code_comb_id
444: ,p_current_value => c_default_code_comb_id);
442: ,p_parameter_name => 'p_default_code_comb_id'
443: ,p_new_value => p_default_code_comb_id
444: ,p_current_value => c_default_code_comb_id);
445:
446: l_asg_rec.frequency:= hr_dt_attribute_support.get_parameter_char
447: (p_effective_date_row => l_effective_date_row
448: ,p_parameter_name => 'p_frequency'
449: ,p_new_value => p_frequency
450: ,p_current_value => c_frequency);
448: ,p_parameter_name => 'p_frequency'
449: ,p_new_value => p_frequency
450: ,p_current_value => c_frequency);
451:
452: l_asg_rec.internal_address_line:= hr_dt_attribute_support.get_parameter_char
453: (p_effective_date_row => l_effective_date_row
454: ,p_parameter_name => 'p_internal_address_line'
455: ,p_new_value => p_internal_address_line
456: ,p_current_value => c_internal_address_line);
454: ,p_parameter_name => 'p_internal_address_line'
455: ,p_new_value => p_internal_address_line
456: ,p_current_value => c_internal_address_line);
457:
458: l_asg_rec.manager_flag:= hr_dt_attribute_support.get_parameter_char
459: (p_effective_date_row => l_effective_date_row
460: ,p_parameter_name => 'p_manager_flag'
461: ,p_new_value => p_manager_flag
462: ,p_current_value => c_manager_flag);
460: ,p_parameter_name => 'p_manager_flag'
461: ,p_new_value => p_manager_flag
462: ,p_current_value => c_manager_flag);
463:
464: l_asg_rec.normal_hours:= hr_dt_attribute_support.get_parameter_number
465: (p_effective_date_row => l_effective_date_row
466: ,p_parameter_name => 'p_normal_hours'
467: ,p_new_value => p_normal_hours
468: ,p_current_value => c_normal_hours);
466: ,p_parameter_name => 'p_normal_hours'
467: ,p_new_value => p_normal_hours
468: ,p_current_value => c_normal_hours);
469:
470: l_asg_rec.perf_review_period:= hr_dt_attribute_support.get_parameter_number
471: (p_effective_date_row => l_effective_date_row
472: ,p_parameter_name => 'p_perf_review_period'
473: ,p_new_value => p_perf_review_period
474: ,p_current_value => c_perf_review_period);
472: ,p_parameter_name => 'p_perf_review_period'
473: ,p_new_value => p_perf_review_period
474: ,p_current_value => c_perf_review_period);
475:
476: l_asg_rec.perf_review_period_frequency:= hr_dt_attribute_support.get_parameter_char
477: (p_effective_date_row => l_effective_date_row
478: ,p_parameter_name => 'p_perf_review_period_frequency'
479: ,p_new_value => p_perf_review_period_frequency
480: ,p_current_value => c_perf_review_period_frequency);
478: ,p_parameter_name => 'p_perf_review_period_frequency'
479: ,p_new_value => p_perf_review_period_frequency
480: ,p_current_value => c_perf_review_period_frequency);
481:
482: l_asg_rec.probation_period:= hr_dt_attribute_support.get_parameter_number
483: (p_effective_date_row => l_effective_date_row
484: ,p_parameter_name => 'p_probation_period'
485: ,p_new_value => p_probation_period
486: ,p_current_value => c_probation_period);
484: ,p_parameter_name => 'p_probation_period'
485: ,p_new_value => p_probation_period
486: ,p_current_value => c_probation_period);
487:
488: l_asg_rec.probation_unit:= hr_dt_attribute_support.get_parameter_char
489: (p_effective_date_row => l_effective_date_row
490: ,p_parameter_name => 'p_probation_unit'
491: ,p_new_value => p_probation_unit
492: ,p_current_value => c_probation_unit);
490: ,p_parameter_name => 'p_probation_unit'
491: ,p_new_value => p_probation_unit
492: ,p_current_value => c_probation_unit);
493:
494: l_asg_rec.sal_review_period:= hr_dt_attribute_support.get_parameter_number
495: (p_effective_date_row => l_effective_date_row
496: ,p_parameter_name => 'p_sal_review_period'
497: ,p_new_value => p_sal_review_period
498: ,p_current_value => c_sal_review_period);
496: ,p_parameter_name => 'p_sal_review_period'
497: ,p_new_value => p_sal_review_period
498: ,p_current_value => c_sal_review_period);
499:
500: l_asg_rec.sal_review_period_frequency:= hr_dt_attribute_support.get_parameter_char
501: (p_effective_date_row => l_effective_date_row
502: ,p_parameter_name => 'p_sal_review_period_frequency'
503: ,p_new_value => p_sal_review_period_frequency
504: ,p_current_value => c_sal_review_period_frequency);
502: ,p_parameter_name => 'p_sal_review_period_frequency'
503: ,p_new_value => p_sal_review_period_frequency
504: ,p_current_value => c_sal_review_period_frequency);
505:
506: l_asg_rec.set_of_books_id:= hr_dt_attribute_support.get_parameter_number
507: (p_effective_date_row => l_effective_date_row
508: ,p_parameter_name => 'p_set_of_books_id'
509: ,p_new_value => p_set_of_books_id
510: ,p_current_value => c_set_of_books_id);
508: ,p_parameter_name => 'p_set_of_books_id'
509: ,p_new_value => p_set_of_books_id
510: ,p_current_value => c_set_of_books_id);
511:
512: l_asg_rec.source_type:= hr_dt_attribute_support.get_parameter_char
513: (p_effective_date_row => l_effective_date_row
514: ,p_parameter_name => 'p_source_type'
515: ,p_new_value => p_source_type
516: ,p_current_value => c_source_type);
514: ,p_parameter_name => 'p_source_type'
515: ,p_new_value => p_source_type
516: ,p_current_value => c_source_type);
517:
518: l_asg_rec.time_normal_finish:= hr_dt_attribute_support.get_parameter_char
519: (p_effective_date_row => l_effective_date_row
520: ,p_parameter_name => 'p_time_normal_finish'
521: ,p_new_value => p_time_normal_finish
522: ,p_current_value => c_time_normal_finish);
520: ,p_parameter_name => 'p_time_normal_finish'
521: ,p_new_value => p_time_normal_finish
522: ,p_current_value => c_time_normal_finish);
523:
524: l_asg_rec.time_normal_start:= hr_dt_attribute_support.get_parameter_char
525: (p_effective_date_row => l_effective_date_row
526: ,p_parameter_name => 'p_time_normal_start'
527: ,p_new_value => p_time_normal_start
528: ,p_current_value => c_time_normal_start);
526: ,p_parameter_name => 'p_time_normal_start'
527: ,p_new_value => p_time_normal_start
528: ,p_current_value => c_time_normal_start);
529:
530: l_asg_rec.ass_attribute_category:= hr_dt_attribute_support.get_parameter_char
531: (p_effective_date_row => l_effective_date_row
532: ,p_parameter_name => 'p_ass_attribute_category'
533: ,p_new_value => p_ass_attribute_category
534: ,p_current_value => c_ass_attribute_category);
532: ,p_parameter_name => 'p_ass_attribute_category'
533: ,p_new_value => p_ass_attribute_category
534: ,p_current_value => c_ass_attribute_category);
535:
536: l_asg_rec.ass_attribute1:= hr_dt_attribute_support.get_parameter_char
537: (p_effective_date_row => l_effective_date_row
538: ,p_parameter_name => 'p_ass_attribute1'
539: ,p_new_value => p_ass_attribute1
540: ,p_current_value => c_ass_attribute1);
538: ,p_parameter_name => 'p_ass_attribute1'
539: ,p_new_value => p_ass_attribute1
540: ,p_current_value => c_ass_attribute1);
541:
542: l_asg_rec.ass_attribute2:= hr_dt_attribute_support.get_parameter_char
543: (p_effective_date_row => l_effective_date_row
544: ,p_parameter_name => 'p_ass_attribute2'
545: ,p_new_value => p_ass_attribute2
546: ,p_current_value => c_ass_attribute2);
544: ,p_parameter_name => 'p_ass_attribute2'
545: ,p_new_value => p_ass_attribute2
546: ,p_current_value => c_ass_attribute2);
547:
548: l_asg_rec.ass_attribute3:= hr_dt_attribute_support.get_parameter_char
549: (p_effective_date_row => l_effective_date_row
550: ,p_parameter_name => 'p_ass_attribute3'
551: ,p_new_value => p_ass_attribute3
552: ,p_current_value => c_ass_attribute3);
550: ,p_parameter_name => 'p_ass_attribute3'
551: ,p_new_value => p_ass_attribute3
552: ,p_current_value => c_ass_attribute3);
553:
554: l_asg_rec.ass_attribute4:= hr_dt_attribute_support.get_parameter_char
555: (p_effective_date_row => l_effective_date_row
556: ,p_parameter_name => 'p_ass_attribute4'
557: ,p_new_value => p_ass_attribute4
558: ,p_current_value => c_ass_attribute4);
556: ,p_parameter_name => 'p_ass_attribute4'
557: ,p_new_value => p_ass_attribute4
558: ,p_current_value => c_ass_attribute4);
559:
560: l_asg_rec.ass_attribute5:= hr_dt_attribute_support.get_parameter_char
561: (p_effective_date_row => l_effective_date_row
562: ,p_parameter_name => 'p_ass_attribute5'
563: ,p_new_value => p_ass_attribute5
564: ,p_current_value => c_ass_attribute5);
562: ,p_parameter_name => 'p_ass_attribute5'
563: ,p_new_value => p_ass_attribute5
564: ,p_current_value => c_ass_attribute5);
565:
566: l_asg_rec.ass_attribute6:= hr_dt_attribute_support.get_parameter_char
567: (p_effective_date_row => l_effective_date_row
568: ,p_parameter_name => 'p_ass_attribute6'
569: ,p_new_value => p_ass_attribute6
570: ,p_current_value => c_ass_attribute6);
568: ,p_parameter_name => 'p_ass_attribute6'
569: ,p_new_value => p_ass_attribute6
570: ,p_current_value => c_ass_attribute6);
571:
572: l_asg_rec.ass_attribute7:= hr_dt_attribute_support.get_parameter_char
573: (p_effective_date_row => l_effective_date_row
574: ,p_parameter_name => 'p_ass_attribute7'
575: ,p_new_value => p_ass_attribute7
576: ,p_current_value => c_ass_attribute7);
574: ,p_parameter_name => 'p_ass_attribute7'
575: ,p_new_value => p_ass_attribute7
576: ,p_current_value => c_ass_attribute7);
577:
578: l_asg_rec.ass_attribute8:= hr_dt_attribute_support.get_parameter_char
579: (p_effective_date_row => l_effective_date_row
580: ,p_parameter_name => 'p_ass_attribute8'
581: ,p_new_value => p_ass_attribute8
582: ,p_current_value => c_ass_attribute8);
580: ,p_parameter_name => 'p_ass_attribute8'
581: ,p_new_value => p_ass_attribute8
582: ,p_current_value => c_ass_attribute8);
583:
584: l_asg_rec.ass_attribute9:= hr_dt_attribute_support.get_parameter_char
585: (p_effective_date_row => l_effective_date_row
586: ,p_parameter_name => 'p_ass_attribute9'
587: ,p_new_value => p_ass_attribute9
588: ,p_current_value => c_ass_attribute9);
586: ,p_parameter_name => 'p_ass_attribute9'
587: ,p_new_value => p_ass_attribute9
588: ,p_current_value => c_ass_attribute9);
589:
590: l_asg_rec.ass_attribute10:= hr_dt_attribute_support.get_parameter_char
591: (p_effective_date_row => l_effective_date_row
592: ,p_parameter_name => 'p_ass_attribute10'
593: ,p_new_value => p_ass_attribute10
594: ,p_current_value => c_ass_attribute10);
593: ,p_new_value => p_ass_attribute10
594: ,p_current_value => c_ass_attribute10);
595:
596:
597: l_asg_rec.ass_attribute11:= hr_dt_attribute_support.get_parameter_char
598: (p_effective_date_row => l_effective_date_row
599: ,p_parameter_name => 'p_ass_attribute11'
600: ,p_new_value => p_ass_attribute11
601: ,p_current_value => c_ass_attribute11);
599: ,p_parameter_name => 'p_ass_attribute11'
600: ,p_new_value => p_ass_attribute11
601: ,p_current_value => c_ass_attribute11);
602:
603: l_asg_rec.ass_attribute12:= hr_dt_attribute_support.get_parameter_char
604: (p_effective_date_row => l_effective_date_row
605: ,p_parameter_name => 'p_ass_attribute12'
606: ,p_new_value => p_ass_attribute12
607: ,p_current_value => c_ass_attribute12);
605: ,p_parameter_name => 'p_ass_attribute12'
606: ,p_new_value => p_ass_attribute12
607: ,p_current_value => c_ass_attribute12);
608:
609: l_asg_rec.ass_attribute13:= hr_dt_attribute_support.get_parameter_char
610: (p_effective_date_row => l_effective_date_row
611: ,p_parameter_name => 'p_ass_attribute13'
612: ,p_new_value => p_ass_attribute13
613: ,p_current_value => c_ass_attribute13);
611: ,p_parameter_name => 'p_ass_attribute13'
612: ,p_new_value => p_ass_attribute13
613: ,p_current_value => c_ass_attribute13);
614:
615: l_asg_rec.ass_attribute14:= hr_dt_attribute_support.get_parameter_char
616: (p_effective_date_row => l_effective_date_row
617: ,p_parameter_name => 'p_ass_attribute14'
618: ,p_new_value => p_ass_attribute14
619: ,p_current_value => c_ass_attribute14);
617: ,p_parameter_name => 'p_ass_attribute14'
618: ,p_new_value => p_ass_attribute14
619: ,p_current_value => c_ass_attribute14);
620:
621: l_asg_rec.ass_attribute15:= hr_dt_attribute_support.get_parameter_char
622: (p_effective_date_row => l_effective_date_row
623: ,p_parameter_name => 'p_ass_attribute15'
624: ,p_new_value => p_ass_attribute15
625: ,p_current_value => c_ass_attribute15);
623: ,p_parameter_name => 'p_ass_attribute15'
624: ,p_new_value => p_ass_attribute15
625: ,p_current_value => c_ass_attribute15);
626:
627: l_asg_rec.ass_attribute16:= hr_dt_attribute_support.get_parameter_char
628: (p_effective_date_row => l_effective_date_row
629: ,p_parameter_name => 'p_ass_attribute16'
630: ,p_new_value => p_ass_attribute16
631: ,p_current_value => c_ass_attribute16);
629: ,p_parameter_name => 'p_ass_attribute16'
630: ,p_new_value => p_ass_attribute16
631: ,p_current_value => c_ass_attribute16);
632:
633: l_asg_rec.ass_attribute17:= hr_dt_attribute_support.get_parameter_char
634: (p_effective_date_row => l_effective_date_row
635: ,p_parameter_name => 'p_ass_attribute17'
636: ,p_new_value => p_ass_attribute17
637: ,p_current_value => c_ass_attribute17);
635: ,p_parameter_name => 'p_ass_attribute17'
636: ,p_new_value => p_ass_attribute17
637: ,p_current_value => c_ass_attribute17);
638:
639: l_asg_rec.ass_attribute18:= hr_dt_attribute_support.get_parameter_char
640: (p_effective_date_row => l_effective_date_row
641: ,p_parameter_name => 'p_ass_attribute18'
642: ,p_new_value => p_ass_attribute18
643: ,p_current_value => c_ass_attribute18);
641: ,p_parameter_name => 'p_ass_attribute18'
642: ,p_new_value => p_ass_attribute18
643: ,p_current_value => c_ass_attribute18);
644:
645: l_asg_rec.ass_attribute19:= hr_dt_attribute_support.get_parameter_char
646: (p_effective_date_row => l_effective_date_row
647: ,p_parameter_name => 'p_ass_attribute19'
648: ,p_new_value => p_ass_attribute19
649: ,p_current_value => c_ass_attribute19);
647: ,p_parameter_name => 'p_ass_attribute19'
648: ,p_new_value => p_ass_attribute19
649: ,p_current_value => c_ass_attribute19);
650:
651: l_asg_rec.ass_attribute20:= hr_dt_attribute_support.get_parameter_char
652: (p_effective_date_row => l_effective_date_row
653: ,p_parameter_name => 'p_ass_attribute20'
654: ,p_new_value => p_ass_attribute20
655: ,p_current_value => c_ass_attribute20);
653: ,p_parameter_name => 'p_ass_attribute20'
654: ,p_new_value => p_ass_attribute20
655: ,p_current_value => c_ass_attribute20);
656:
657: l_asg_rec.ass_attribute21:= hr_dt_attribute_support.get_parameter_char
658: (p_effective_date_row => l_effective_date_row
659: ,p_parameter_name => 'p_ass_attribute21'
660: ,p_new_value => p_ass_attribute21
661: ,p_current_value => c_ass_attribute21);
659: ,p_parameter_name => 'p_ass_attribute21'
660: ,p_new_value => p_ass_attribute21
661: ,p_current_value => c_ass_attribute21);
662:
663: l_asg_rec.ass_attribute22:= hr_dt_attribute_support.get_parameter_char
664: (p_effective_date_row => l_effective_date_row
665: ,p_parameter_name => 'p_ass_attribute22'
666: ,p_new_value => p_ass_attribute22
667: ,p_current_value => c_ass_attribute22);
665: ,p_parameter_name => 'p_ass_attribute22'
666: ,p_new_value => p_ass_attribute22
667: ,p_current_value => c_ass_attribute22);
668:
669: l_asg_rec.ass_attribute23:= hr_dt_attribute_support.get_parameter_char
670: (p_effective_date_row => l_effective_date_row
671: ,p_parameter_name => 'p_ass_attribute23'
672: ,p_new_value => p_ass_attribute23
673: ,p_current_value => c_ass_attribute23);
671: ,p_parameter_name => 'p_ass_attribute23'
672: ,p_new_value => p_ass_attribute23
673: ,p_current_value => c_ass_attribute23);
674:
675: l_asg_rec.ass_attribute24:= hr_dt_attribute_support.get_parameter_char
676: (p_effective_date_row => l_effective_date_row
677: ,p_parameter_name => 'p_ass_attribute24'
678: ,p_new_value => p_ass_attribute24
679: ,p_current_value => c_ass_attribute24);
677: ,p_parameter_name => 'p_ass_attribute24'
678: ,p_new_value => p_ass_attribute24
679: ,p_current_value => c_ass_attribute24);
680:
681: l_asg_rec.ass_attribute25:= hr_dt_attribute_support.get_parameter_char
682: (p_effective_date_row => l_effective_date_row
683: ,p_parameter_name => 'p_ass_attribute25'
684: ,p_new_value => p_ass_attribute25
685: ,p_current_value => c_ass_attribute25);
683: ,p_parameter_name => 'p_ass_attribute25'
684: ,p_new_value => p_ass_attribute25
685: ,p_current_value => c_ass_attribute25);
686:
687: l_asg_rec.ass_attribute26:= hr_dt_attribute_support.get_parameter_char
688: (p_effective_date_row => l_effective_date_row
689: ,p_parameter_name => 'p_ass_attribute26'
690: ,p_new_value => p_ass_attribute26
691: ,p_current_value => c_ass_attribute26);
689: ,p_parameter_name => 'p_ass_attribute26'
690: ,p_new_value => p_ass_attribute26
691: ,p_current_value => c_ass_attribute26);
692:
693: l_asg_rec.ass_attribute27:= hr_dt_attribute_support.get_parameter_char
694: (p_effective_date_row => l_effective_date_row
695: ,p_parameter_name => 'p_ass_attribute27'
696: ,p_new_value => p_ass_attribute27
697: ,p_current_value => c_ass_attribute27);
695: ,p_parameter_name => 'p_ass_attribute27'
696: ,p_new_value => p_ass_attribute27
697: ,p_current_value => c_ass_attribute27);
698:
699: l_asg_rec.ass_attribute28:= hr_dt_attribute_support.get_parameter_char
700: (p_effective_date_row => l_effective_date_row
701: ,p_parameter_name => 'p_ass_attribute28'
702: ,p_new_value => p_ass_attribute28
703: ,p_current_value => c_ass_attribute28);
701: ,p_parameter_name => 'p_ass_attribute28'
702: ,p_new_value => p_ass_attribute28
703: ,p_current_value => c_ass_attribute28);
704:
705: l_asg_rec.ass_attribute29:= hr_dt_attribute_support.get_parameter_char
706: (p_effective_date_row => l_effective_date_row
707: ,p_parameter_name => 'p_ass_attribute29'
708: ,p_new_value => p_ass_attribute29
709: ,p_current_value => c_ass_attribute29);
707: ,p_parameter_name => 'p_ass_attribute29'
708: ,p_new_value => p_ass_attribute29
709: ,p_current_value => c_ass_attribute29);
710:
711: l_asg_rec.ass_attribute30:= hr_dt_attribute_support.get_parameter_char
712: (p_effective_date_row => l_effective_date_row
713: ,p_parameter_name => 'p_ass_attribute30'
714: ,p_new_value => p_ass_attribute30
715: ,p_current_value => c_ass_attribute30);
713: ,p_parameter_name => 'p_ass_attribute30'
714: ,p_new_value => p_ass_attribute30
715: ,p_current_value => c_ass_attribute30);
716:
717: l_asg_rec.title:= hr_dt_attribute_support.get_parameter_char
718: (p_effective_date_row => l_effective_date_row
719: ,p_parameter_name => 'p_title'
720: ,p_new_value => p_title
721: ,p_current_value => c_title);
719: ,p_parameter_name => 'p_title'
720: ,p_new_value => p_title
721: ,p_current_value => c_title);
722:
723: l_asg_rec.project_title:= hr_dt_attribute_support.get_parameter_char
724: (p_effective_date_row => l_effective_date_row
725: ,p_parameter_name => 'p_project_title'
726: ,p_new_value => p_project_title
727: ,p_current_value => c_project_title);
726: ,p_new_value => p_project_title
727: ,p_current_value => c_project_title);
728:
729: l_asg_rec.vendor_assignment_number:=
730: hr_dt_attribute_support.get_parameter_char
731: (p_effective_date_row => l_effective_date_row
732: ,p_parameter_name => 'p_vendor_assignment_number'
733: ,p_new_value => p_vendor_assignment_number
734: ,p_current_value => c_vendor_assignment_number);
733: ,p_new_value => p_vendor_assignment_number
734: ,p_current_value => c_vendor_assignment_number);
735:
736: l_asg_rec.vendor_employee_number:=
737: hr_dt_attribute_support.get_parameter_char
738: (p_effective_date_row => l_effective_date_row
739: ,p_parameter_name => 'p_vendor_employee_number'
740: ,p_new_value => p_vendor_employee_number
741: ,p_current_value => c_vendor_employee_number);
739: ,p_parameter_name => 'p_vendor_employee_number'
740: ,p_new_value => p_vendor_employee_number
741: ,p_current_value => c_vendor_employee_number);
742:
743: l_asg_rec.vendor_id:= hr_dt_attribute_support.get_parameter_number
744: (p_effective_date_row => l_effective_date_row
745: ,p_parameter_name => 'p_vendor_id'
746: ,p_new_value => p_vendor_id
747: ,p_current_value => c_vendor_id);
755: -- end if;
756:
757: --
758: -- call the API if at least one attribute can be changed
759: if hr_dt_attribute_support.is_current_row_changing then
760: -- set the object version number and effective date
761: if l_effective_date_row then
762: -- as we are on the first row, the ovn and effective date should be
763: -- set to the parameter specified by the caller
1115: if p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1116: -- reset the parameter statuses
1117: hr_utility.trace(' after if condition'||
1118: 'p_attribute_update_mode = ATTRIBUTE_CORRECTION');
1119: hr_dt_attribute_support.reset_parameter_statuses;
1120: for I in csr_asg2 loop
1121: if not process_row
1122: (c_effective_start_date => I.effective_start_date
1123: ,c_object_version_number => I.object_version_number
1413: l_proc varchar2(72) := g_package||'process_row';
1414: begin
1415: hr_utility.set_location('Entering:'|| l_proc, 5);
1416: -- get the parameter values to pass to the API
1417: l_asg_rec.grade_id:= hr_dt_attribute_support.get_parameter_number
1418: (p_effective_date_row => l_effective_date_row
1419: ,p_parameter_name => 'P_GRADE_ID'
1420: ,p_new_value => p_grade_id
1421: ,p_current_value => c_grade_id);
1419: ,p_parameter_name => 'P_GRADE_ID'
1420: ,p_new_value => p_grade_id
1421: ,p_current_value => c_grade_id);
1422:
1423: l_asg_rec.position_id:= hr_dt_attribute_support.get_parameter_number
1424: (p_effective_date_row => l_effective_date_row
1425: ,p_parameter_name => 'P_POSITION_ID'
1426: ,p_new_value => p_position_id
1427: ,p_current_value => c_position_id);
1425: ,p_parameter_name => 'P_POSITION_ID'
1426: ,p_new_value => p_position_id
1427: ,p_current_value => c_position_id);
1428:
1429: l_asg_rec.job_id:= hr_dt_attribute_support.get_parameter_number
1430: (p_effective_date_row => l_effective_date_row
1431: ,p_parameter_name => 'P_JOB_ID'
1432: ,p_new_value => p_job_id
1433: ,p_current_value => c_job_id);
1431: ,p_parameter_name => 'P_JOB_ID'
1432: ,p_new_value => p_job_id
1433: ,p_current_value => c_job_id);
1434:
1435: l_asg_rec.payroll_id:= hr_dt_attribute_support.get_parameter_number
1436: (p_effective_date_row => l_effective_date_row
1437: ,p_parameter_name => 'P_PAYROLL_ID'
1438: ,p_new_value => p_payroll_id
1439: ,p_current_value => c_payroll_id);
1437: ,p_parameter_name => 'P_PAYROLL_ID'
1438: ,p_new_value => p_payroll_id
1439: ,p_current_value => c_payroll_id);
1440:
1441: l_asg_rec.location_id:= hr_dt_attribute_support.get_parameter_number
1442: (p_effective_date_row => l_effective_date_row
1443: ,p_parameter_name => 'P_LOCATION_ID'
1444: ,p_new_value => p_location_id
1445: ,p_current_value => c_location_id);
1443: ,p_parameter_name => 'P_LOCATION_ID'
1444: ,p_new_value => p_location_id
1445: ,p_current_value => c_location_id);
1446:
1447: l_asg_rec.special_ceiling_step_id:= hr_dt_attribute_support.get_parameter_number
1448: (p_effective_date_row => l_effective_date_row
1449: ,p_parameter_name => 'P_SPECIAL_CEILING_STEP_ID'
1450: ,p_new_value => p_special_ceiling_step_id
1451: ,p_current_value => c_special_ceiling_step_id);
1449: ,p_parameter_name => 'P_SPECIAL_CEILING_STEP_ID'
1450: ,p_new_value => p_special_ceiling_step_id
1451: ,p_current_value => c_special_ceiling_step_id);
1452:
1453: l_asg_rec.organization_id:= hr_dt_attribute_support.get_parameter_number
1454: (p_effective_date_row => l_effective_date_row
1455: ,p_parameter_name => 'P_ORGANIZATION_ID'
1456: ,p_new_value => p_organization_id
1457: ,p_current_value => c_organization_id);
1455: ,p_parameter_name => 'P_ORGANIZATION_ID'
1456: ,p_new_value => p_organization_id
1457: ,p_current_value => c_organization_id);
1458:
1459: l_asg_rec.pay_basis_id:= hr_dt_attribute_support.get_parameter_number
1460: (p_effective_date_row => l_effective_date_row
1461: ,p_parameter_name => 'P_PAY_BASIS_ID'
1462: ,p_new_value => p_pay_basis_id
1463: ,p_current_value => c_pay_basis_id);
1461: ,p_parameter_name => 'P_PAY_BASIS_ID'
1462: ,p_new_value => p_pay_basis_id
1463: ,p_current_value => c_pay_basis_id);
1464:
1465: l_asg_rec.employment_category:= hr_dt_attribute_support.get_parameter_char
1466: (p_effective_date_row => l_effective_date_row
1467: ,p_parameter_name => 'P_EMPLOYMENT_CATEGORY'
1468: ,p_new_value => p_employment_category
1469: ,p_current_value => c_employment_category);
1469: ,p_current_value => c_employment_category);
1470:
1471: --
1472: -- call the API if at least one attribute can be changed
1473: if hr_dt_attribute_support.is_current_row_changing then
1474: -- set the object version number and effective date
1475: if l_effective_date_row then
1476: -- as we are on the first row, the ovn and effective date should be
1477: -- set to the parameter specified by the caller
1675: -- ------------------------------------------------------------------------
1676: -- process any past row(s)
1677: if p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1678: -- reset the parameter statuses
1679: hr_dt_attribute_support.reset_parameter_statuses;
1680: for I in csr_asg2 loop
1681: if not process_row
1682: (c_effective_start_date => I.effective_start_date
1683: ,c_object_version_number => I.object_version_number