DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_ATT dependencies on HR_DT_ATTRIBUTE_SUPPORT

Line 401: l_asg_rec.supervisor_id:= hr_dt_attribute_support.get_parameter_number

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

Line 408: l_asg_rec.supervisor_assignment_id:= hr_dt_attribute_support.get_parameter_number

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

Line 415: l_asg_rec.assignment_number:= hr_dt_attribute_support.get_parameter_char

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

Line 421: l_asg_rec.change_reason:= hr_dt_attribute_support.get_parameter_char

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

Line 427: l_comments:= hr_dt_attribute_support.get_parameter_char

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

Line 433: l_asg_rec.date_probation_end:= hr_dt_attribute_support.get_parameter_date

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

Line 440: l_asg_rec.default_code_comb_id:= hr_dt_attribute_support.get_parameter_number

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

Line 446: l_asg_rec.frequency:= hr_dt_attribute_support.get_parameter_char

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

Line 452: l_asg_rec.internal_address_line:= hr_dt_attribute_support.get_parameter_char

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

Line 458: l_asg_rec.manager_flag:= hr_dt_attribute_support.get_parameter_char

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

Line 464: l_asg_rec.normal_hours:= hr_dt_attribute_support.get_parameter_number

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

Line 470: l_asg_rec.perf_review_period:= hr_dt_attribute_support.get_parameter_number

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

Line 476: l_asg_rec.perf_review_period_frequency:= hr_dt_attribute_support.get_parameter_char

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

Line 482: l_asg_rec.probation_period:= hr_dt_attribute_support.get_parameter_number

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

Line 488: l_asg_rec.probation_unit:= hr_dt_attribute_support.get_parameter_char

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

Line 494: l_asg_rec.sal_review_period:= hr_dt_attribute_support.get_parameter_number

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

Line 500: l_asg_rec.sal_review_period_frequency:= hr_dt_attribute_support.get_parameter_char

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

Line 506: l_asg_rec.set_of_books_id:= hr_dt_attribute_support.get_parameter_number

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

Line 512: l_asg_rec.source_type:= hr_dt_attribute_support.get_parameter_char

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

Line 518: l_asg_rec.time_normal_finish:= hr_dt_attribute_support.get_parameter_char

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

Line 524: l_asg_rec.time_normal_start:= hr_dt_attribute_support.get_parameter_char

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

Line 530: l_asg_rec.ass_attribute_category:= hr_dt_attribute_support.get_parameter_char

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

Line 536: l_asg_rec.ass_attribute1:= hr_dt_attribute_support.get_parameter_char

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

Line 542: l_asg_rec.ass_attribute2:= hr_dt_attribute_support.get_parameter_char

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

Line 548: l_asg_rec.ass_attribute3:= hr_dt_attribute_support.get_parameter_char

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

Line 554: l_asg_rec.ass_attribute4:= hr_dt_attribute_support.get_parameter_char

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

Line 560: l_asg_rec.ass_attribute5:= hr_dt_attribute_support.get_parameter_char

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

Line 566: l_asg_rec.ass_attribute6:= hr_dt_attribute_support.get_parameter_char

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

Line 572: l_asg_rec.ass_attribute7:= hr_dt_attribute_support.get_parameter_char

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

Line 578: l_asg_rec.ass_attribute8:= hr_dt_attribute_support.get_parameter_char

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

Line 584: l_asg_rec.ass_attribute9:= hr_dt_attribute_support.get_parameter_char

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

Line 590: l_asg_rec.ass_attribute10:= hr_dt_attribute_support.get_parameter_char

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

Line 597: l_asg_rec.ass_attribute11:= hr_dt_attribute_support.get_parameter_char

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

Line 603: l_asg_rec.ass_attribute12:= hr_dt_attribute_support.get_parameter_char

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

Line 609: l_asg_rec.ass_attribute13:= hr_dt_attribute_support.get_parameter_char

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

Line 615: l_asg_rec.ass_attribute14:= hr_dt_attribute_support.get_parameter_char

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

Line 621: l_asg_rec.ass_attribute15:= hr_dt_attribute_support.get_parameter_char

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

Line 627: l_asg_rec.ass_attribute16:= hr_dt_attribute_support.get_parameter_char

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

Line 633: l_asg_rec.ass_attribute17:= hr_dt_attribute_support.get_parameter_char

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

Line 639: l_asg_rec.ass_attribute18:= hr_dt_attribute_support.get_parameter_char

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

Line 645: l_asg_rec.ass_attribute19:= hr_dt_attribute_support.get_parameter_char

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

Line 651: l_asg_rec.ass_attribute20:= hr_dt_attribute_support.get_parameter_char

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

Line 657: l_asg_rec.ass_attribute21:= hr_dt_attribute_support.get_parameter_char

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

Line 663: l_asg_rec.ass_attribute22:= hr_dt_attribute_support.get_parameter_char

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

Line 669: l_asg_rec.ass_attribute23:= hr_dt_attribute_support.get_parameter_char

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

Line 675: l_asg_rec.ass_attribute24:= hr_dt_attribute_support.get_parameter_char

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

Line 681: l_asg_rec.ass_attribute25:= hr_dt_attribute_support.get_parameter_char

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

Line 687: l_asg_rec.ass_attribute26:= hr_dt_attribute_support.get_parameter_char

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

Line 693: l_asg_rec.ass_attribute27:= hr_dt_attribute_support.get_parameter_char

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

Line 699: l_asg_rec.ass_attribute28:= hr_dt_attribute_support.get_parameter_char

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

Line 705: l_asg_rec.ass_attribute29:= hr_dt_attribute_support.get_parameter_char

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

Line 711: l_asg_rec.ass_attribute30:= hr_dt_attribute_support.get_parameter_char

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

Line 717: l_asg_rec.title:= hr_dt_attribute_support.get_parameter_char

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

Line 723: l_asg_rec.project_title:= hr_dt_attribute_support.get_parameter_char

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

Line 730: hr_dt_attribute_support.get_parameter_char

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

Line 737: hr_dt_attribute_support.get_parameter_char

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

Line 743: l_asg_rec.vendor_id:= hr_dt_attribute_support.get_parameter_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);

Line 759: if hr_dt_attribute_support.is_current_row_changing then

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

Line 1119: hr_dt_attribute_support.reset_parameter_statuses;

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

Line 1417: l_asg_rec.grade_id:= hr_dt_attribute_support.get_parameter_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);

Line 1423: l_asg_rec.position_id:= hr_dt_attribute_support.get_parameter_number

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

Line 1429: l_asg_rec.job_id:= hr_dt_attribute_support.get_parameter_number

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

Line 1435: l_asg_rec.payroll_id:= hr_dt_attribute_support.get_parameter_number

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

Line 1441: l_asg_rec.location_id:= hr_dt_attribute_support.get_parameter_number

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

Line 1447: l_asg_rec.special_ceiling_step_id:= hr_dt_attribute_support.get_parameter_number

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

Line 1453: l_asg_rec.organization_id:= hr_dt_attribute_support.get_parameter_number

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

Line 1459: l_asg_rec.pay_basis_id:= hr_dt_attribute_support.get_parameter_number

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

Line 1465: l_asg_rec.employment_category:= hr_dt_attribute_support.get_parameter_char

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

Line 1473: if hr_dt_attribute_support.is_current_row_changing then

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

Line 1679: hr_dt_attribute_support.reset_parameter_statuses;

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