DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_ATT dependencies on HR_DT_ATTRIBUTE_SUPPORT

Line 390: l_asg_rec.supervisor_id:= hr_dt_attribute_support.get_parameter_number

386: -- get the parameter values to pass to the API
387:
388: -- if (l_effective_date_row) then
389:
390: l_asg_rec.supervisor_id:= hr_dt_attribute_support.get_parameter_number
391: (p_effective_date_row => l_effective_date_row
392: ,p_parameter_name => 'P_SUPERVISOR_ID'
393: ,p_new_value => p_supervisor_id
394: ,p_current_value => c_supervisor_id);

Line 397: l_asg_rec.supervisor_assignment_id:= hr_dt_attribute_support.get_parameter_number

393: ,p_new_value => p_supervisor_id
394: ,p_current_value => c_supervisor_id);
395:
396: -- Assignment Security
397: l_asg_rec.supervisor_assignment_id:= hr_dt_attribute_support.get_parameter_number
398: (p_effective_date_row => l_effective_date_row
399: ,p_parameter_name => 'P_SUPERVISOR_ASSIGNMENT_ID'
400: ,p_new_value => p_supervisor_assignment_id
401: ,p_current_value => c_supervisor_assignment_id);

Line 404: l_asg_rec.assignment_number:= hr_dt_attribute_support.get_parameter_char

400: ,p_new_value => p_supervisor_assignment_id
401: ,p_current_value => c_supervisor_assignment_id);
402:
403:
404: l_asg_rec.assignment_number:= hr_dt_attribute_support.get_parameter_char
405: (p_effective_date_row => l_effective_date_row
406: ,p_parameter_name => 'p_assignment_number'
407: ,p_new_value => p_assignment_number
408: ,p_current_value => c_assignment_number);

Line 410: l_asg_rec.change_reason:= hr_dt_attribute_support.get_parameter_char

406: ,p_parameter_name => 'p_assignment_number'
407: ,p_new_value => p_assignment_number
408: ,p_current_value => c_assignment_number);
409:
410: l_asg_rec.change_reason:= hr_dt_attribute_support.get_parameter_char
411: (p_effective_date_row => l_effective_date_row
412: ,p_parameter_name => 'p_change_reason'
413: ,p_new_value => p_change_reason
414: ,p_current_value => c_change_reason);

Line 416: l_comments:= hr_dt_attribute_support.get_parameter_char

412: ,p_parameter_name => 'p_change_reason'
413: ,p_new_value => p_change_reason
414: ,p_current_value => c_change_reason);
415:
416: l_comments:= hr_dt_attribute_support.get_parameter_char
417: (p_effective_date_row => l_effective_date_row
418: ,p_parameter_name => 'p_comments'
419: ,p_new_value => p_comments
420: ,p_current_value => c_comments);

Line 422: l_asg_rec.date_probation_end:= hr_dt_attribute_support.get_parameter_date

418: ,p_parameter_name => 'p_comments'
419: ,p_new_value => p_comments
420: ,p_current_value => c_comments);
421:
422: l_asg_rec.date_probation_end:= hr_dt_attribute_support.get_parameter_date
423: (p_effective_date_row => l_effective_date_row
424: ,p_parameter_name => 'p_date_probation_end'
425: ,p_new_value => p_date_probation_end
426: ,p_current_value => c_date_probation_end);

Line 429: l_asg_rec.default_code_comb_id:= hr_dt_attribute_support.get_parameter_number

425: ,p_new_value => p_date_probation_end
426: ,p_current_value => c_date_probation_end);
427:
428:
429: l_asg_rec.default_code_comb_id:= hr_dt_attribute_support.get_parameter_number
430: (p_effective_date_row => l_effective_date_row
431: ,p_parameter_name => 'p_default_code_comb_id'
432: ,p_new_value => p_default_code_comb_id
433: ,p_current_value => c_default_code_comb_id);

Line 435: l_asg_rec.frequency:= hr_dt_attribute_support.get_parameter_char

431: ,p_parameter_name => 'p_default_code_comb_id'
432: ,p_new_value => p_default_code_comb_id
433: ,p_current_value => c_default_code_comb_id);
434:
435: l_asg_rec.frequency:= hr_dt_attribute_support.get_parameter_char
436: (p_effective_date_row => l_effective_date_row
437: ,p_parameter_name => 'p_frequency'
438: ,p_new_value => p_frequency
439: ,p_current_value => c_frequency);

Line 441: l_asg_rec.internal_address_line:= hr_dt_attribute_support.get_parameter_char

437: ,p_parameter_name => 'p_frequency'
438: ,p_new_value => p_frequency
439: ,p_current_value => c_frequency);
440:
441: l_asg_rec.internal_address_line:= hr_dt_attribute_support.get_parameter_char
442: (p_effective_date_row => l_effective_date_row
443: ,p_parameter_name => 'p_internal_address_line'
444: ,p_new_value => p_internal_address_line
445: ,p_current_value => c_internal_address_line);

Line 447: l_asg_rec.manager_flag:= hr_dt_attribute_support.get_parameter_char

443: ,p_parameter_name => 'p_internal_address_line'
444: ,p_new_value => p_internal_address_line
445: ,p_current_value => c_internal_address_line);
446:
447: l_asg_rec.manager_flag:= hr_dt_attribute_support.get_parameter_char
448: (p_effective_date_row => l_effective_date_row
449: ,p_parameter_name => 'p_manager_flag'
450: ,p_new_value => p_manager_flag
451: ,p_current_value => c_manager_flag);

Line 453: l_asg_rec.normal_hours:= hr_dt_attribute_support.get_parameter_number

449: ,p_parameter_name => 'p_manager_flag'
450: ,p_new_value => p_manager_flag
451: ,p_current_value => c_manager_flag);
452:
453: l_asg_rec.normal_hours:= hr_dt_attribute_support.get_parameter_number
454: (p_effective_date_row => l_effective_date_row
455: ,p_parameter_name => 'p_normal_hours'
456: ,p_new_value => p_normal_hours
457: ,p_current_value => c_normal_hours);

Line 459: l_asg_rec.perf_review_period:= hr_dt_attribute_support.get_parameter_number

455: ,p_parameter_name => 'p_normal_hours'
456: ,p_new_value => p_normal_hours
457: ,p_current_value => c_normal_hours);
458:
459: l_asg_rec.perf_review_period:= hr_dt_attribute_support.get_parameter_number
460: (p_effective_date_row => l_effective_date_row
461: ,p_parameter_name => 'p_perf_review_period'
462: ,p_new_value => p_perf_review_period
463: ,p_current_value => c_perf_review_period);

Line 465: l_asg_rec.perf_review_period_frequency:= hr_dt_attribute_support.get_parameter_char

461: ,p_parameter_name => 'p_perf_review_period'
462: ,p_new_value => p_perf_review_period
463: ,p_current_value => c_perf_review_period);
464:
465: l_asg_rec.perf_review_period_frequency:= hr_dt_attribute_support.get_parameter_char
466: (p_effective_date_row => l_effective_date_row
467: ,p_parameter_name => 'p_perf_review_period_frequency'
468: ,p_new_value => p_perf_review_period_frequency
469: ,p_current_value => c_perf_review_period_frequency);

Line 471: l_asg_rec.probation_period:= hr_dt_attribute_support.get_parameter_number

467: ,p_parameter_name => 'p_perf_review_period_frequency'
468: ,p_new_value => p_perf_review_period_frequency
469: ,p_current_value => c_perf_review_period_frequency);
470:
471: l_asg_rec.probation_period:= hr_dt_attribute_support.get_parameter_number
472: (p_effective_date_row => l_effective_date_row
473: ,p_parameter_name => 'p_probation_period'
474: ,p_new_value => p_probation_period
475: ,p_current_value => c_probation_period);

Line 477: l_asg_rec.probation_unit:= hr_dt_attribute_support.get_parameter_char

473: ,p_parameter_name => 'p_probation_period'
474: ,p_new_value => p_probation_period
475: ,p_current_value => c_probation_period);
476:
477: l_asg_rec.probation_unit:= hr_dt_attribute_support.get_parameter_char
478: (p_effective_date_row => l_effective_date_row
479: ,p_parameter_name => 'p_probation_unit'
480: ,p_new_value => p_probation_unit
481: ,p_current_value => c_probation_unit);

Line 483: l_asg_rec.sal_review_period:= hr_dt_attribute_support.get_parameter_number

479: ,p_parameter_name => 'p_probation_unit'
480: ,p_new_value => p_probation_unit
481: ,p_current_value => c_probation_unit);
482:
483: l_asg_rec.sal_review_period:= hr_dt_attribute_support.get_parameter_number
484: (p_effective_date_row => l_effective_date_row
485: ,p_parameter_name => 'p_sal_review_period'
486: ,p_new_value => p_sal_review_period
487: ,p_current_value => c_sal_review_period);

Line 489: l_asg_rec.sal_review_period_frequency:= hr_dt_attribute_support.get_parameter_char

485: ,p_parameter_name => 'p_sal_review_period'
486: ,p_new_value => p_sal_review_period
487: ,p_current_value => c_sal_review_period);
488:
489: l_asg_rec.sal_review_period_frequency:= hr_dt_attribute_support.get_parameter_char
490: (p_effective_date_row => l_effective_date_row
491: ,p_parameter_name => 'p_sal_review_period_frequency'
492: ,p_new_value => p_sal_review_period_frequency
493: ,p_current_value => c_sal_review_period_frequency);

Line 495: l_asg_rec.set_of_books_id:= hr_dt_attribute_support.get_parameter_number

491: ,p_parameter_name => 'p_sal_review_period_frequency'
492: ,p_new_value => p_sal_review_period_frequency
493: ,p_current_value => c_sal_review_period_frequency);
494:
495: l_asg_rec.set_of_books_id:= hr_dt_attribute_support.get_parameter_number
496: (p_effective_date_row => l_effective_date_row
497: ,p_parameter_name => 'p_set_of_books_id'
498: ,p_new_value => p_set_of_books_id
499: ,p_current_value => c_set_of_books_id);

Line 501: l_asg_rec.source_type:= hr_dt_attribute_support.get_parameter_char

497: ,p_parameter_name => 'p_set_of_books_id'
498: ,p_new_value => p_set_of_books_id
499: ,p_current_value => c_set_of_books_id);
500:
501: l_asg_rec.source_type:= hr_dt_attribute_support.get_parameter_char
502: (p_effective_date_row => l_effective_date_row
503: ,p_parameter_name => 'p_source_type'
504: ,p_new_value => p_source_type
505: ,p_current_value => c_source_type);

Line 507: l_asg_rec.time_normal_finish:= hr_dt_attribute_support.get_parameter_char

503: ,p_parameter_name => 'p_source_type'
504: ,p_new_value => p_source_type
505: ,p_current_value => c_source_type);
506:
507: l_asg_rec.time_normal_finish:= hr_dt_attribute_support.get_parameter_char
508: (p_effective_date_row => l_effective_date_row
509: ,p_parameter_name => 'p_time_normal_finish'
510: ,p_new_value => p_time_normal_finish
511: ,p_current_value => c_time_normal_finish);

Line 513: l_asg_rec.time_normal_start:= hr_dt_attribute_support.get_parameter_char

509: ,p_parameter_name => 'p_time_normal_finish'
510: ,p_new_value => p_time_normal_finish
511: ,p_current_value => c_time_normal_finish);
512:
513: l_asg_rec.time_normal_start:= hr_dt_attribute_support.get_parameter_char
514: (p_effective_date_row => l_effective_date_row
515: ,p_parameter_name => 'p_time_normal_start'
516: ,p_new_value => p_time_normal_start
517: ,p_current_value => c_time_normal_start);

Line 519: l_asg_rec.ass_attribute_category:= hr_dt_attribute_support.get_parameter_char

515: ,p_parameter_name => 'p_time_normal_start'
516: ,p_new_value => p_time_normal_start
517: ,p_current_value => c_time_normal_start);
518:
519: l_asg_rec.ass_attribute_category:= hr_dt_attribute_support.get_parameter_char
520: (p_effective_date_row => l_effective_date_row
521: ,p_parameter_name => 'p_ass_attribute_category'
522: ,p_new_value => p_ass_attribute_category
523: ,p_current_value => c_ass_attribute_category);

Line 525: l_asg_rec.ass_attribute1:= hr_dt_attribute_support.get_parameter_char

521: ,p_parameter_name => 'p_ass_attribute_category'
522: ,p_new_value => p_ass_attribute_category
523: ,p_current_value => c_ass_attribute_category);
524:
525: l_asg_rec.ass_attribute1:= hr_dt_attribute_support.get_parameter_char
526: (p_effective_date_row => l_effective_date_row
527: ,p_parameter_name => 'p_ass_attribute1'
528: ,p_new_value => p_ass_attribute1
529: ,p_current_value => c_ass_attribute1);

Line 531: l_asg_rec.ass_attribute2:= hr_dt_attribute_support.get_parameter_char

527: ,p_parameter_name => 'p_ass_attribute1'
528: ,p_new_value => p_ass_attribute1
529: ,p_current_value => c_ass_attribute1);
530:
531: l_asg_rec.ass_attribute2:= hr_dt_attribute_support.get_parameter_char
532: (p_effective_date_row => l_effective_date_row
533: ,p_parameter_name => 'p_ass_attribute2'
534: ,p_new_value => p_ass_attribute2
535: ,p_current_value => c_ass_attribute2);

Line 537: l_asg_rec.ass_attribute3:= hr_dt_attribute_support.get_parameter_char

533: ,p_parameter_name => 'p_ass_attribute2'
534: ,p_new_value => p_ass_attribute2
535: ,p_current_value => c_ass_attribute2);
536:
537: l_asg_rec.ass_attribute3:= hr_dt_attribute_support.get_parameter_char
538: (p_effective_date_row => l_effective_date_row
539: ,p_parameter_name => 'p_ass_attribute3'
540: ,p_new_value => p_ass_attribute3
541: ,p_current_value => c_ass_attribute3);

Line 543: l_asg_rec.ass_attribute4:= hr_dt_attribute_support.get_parameter_char

539: ,p_parameter_name => 'p_ass_attribute3'
540: ,p_new_value => p_ass_attribute3
541: ,p_current_value => c_ass_attribute3);
542:
543: l_asg_rec.ass_attribute4:= hr_dt_attribute_support.get_parameter_char
544: (p_effective_date_row => l_effective_date_row
545: ,p_parameter_name => 'p_ass_attribute4'
546: ,p_new_value => p_ass_attribute4
547: ,p_current_value => c_ass_attribute4);

Line 549: l_asg_rec.ass_attribute5:= hr_dt_attribute_support.get_parameter_char

545: ,p_parameter_name => 'p_ass_attribute4'
546: ,p_new_value => p_ass_attribute4
547: ,p_current_value => c_ass_attribute4);
548:
549: l_asg_rec.ass_attribute5:= hr_dt_attribute_support.get_parameter_char
550: (p_effective_date_row => l_effective_date_row
551: ,p_parameter_name => 'p_ass_attribute5'
552: ,p_new_value => p_ass_attribute5
553: ,p_current_value => c_ass_attribute5);

Line 555: l_asg_rec.ass_attribute6:= hr_dt_attribute_support.get_parameter_char

551: ,p_parameter_name => 'p_ass_attribute5'
552: ,p_new_value => p_ass_attribute5
553: ,p_current_value => c_ass_attribute5);
554:
555: l_asg_rec.ass_attribute6:= hr_dt_attribute_support.get_parameter_char
556: (p_effective_date_row => l_effective_date_row
557: ,p_parameter_name => 'p_ass_attribute6'
558: ,p_new_value => p_ass_attribute6
559: ,p_current_value => c_ass_attribute6);

Line 561: l_asg_rec.ass_attribute7:= hr_dt_attribute_support.get_parameter_char

557: ,p_parameter_name => 'p_ass_attribute6'
558: ,p_new_value => p_ass_attribute6
559: ,p_current_value => c_ass_attribute6);
560:
561: l_asg_rec.ass_attribute7:= hr_dt_attribute_support.get_parameter_char
562: (p_effective_date_row => l_effective_date_row
563: ,p_parameter_name => 'p_ass_attribute7'
564: ,p_new_value => p_ass_attribute7
565: ,p_current_value => c_ass_attribute7);

Line 567: l_asg_rec.ass_attribute8:= hr_dt_attribute_support.get_parameter_char

563: ,p_parameter_name => 'p_ass_attribute7'
564: ,p_new_value => p_ass_attribute7
565: ,p_current_value => c_ass_attribute7);
566:
567: l_asg_rec.ass_attribute8:= hr_dt_attribute_support.get_parameter_char
568: (p_effective_date_row => l_effective_date_row
569: ,p_parameter_name => 'p_ass_attribute8'
570: ,p_new_value => p_ass_attribute8
571: ,p_current_value => c_ass_attribute8);

Line 573: l_asg_rec.ass_attribute9:= hr_dt_attribute_support.get_parameter_char

569: ,p_parameter_name => 'p_ass_attribute8'
570: ,p_new_value => p_ass_attribute8
571: ,p_current_value => c_ass_attribute8);
572:
573: l_asg_rec.ass_attribute9:= hr_dt_attribute_support.get_parameter_char
574: (p_effective_date_row => l_effective_date_row
575: ,p_parameter_name => 'p_ass_attribute9'
576: ,p_new_value => p_ass_attribute9
577: ,p_current_value => c_ass_attribute9);

Line 579: l_asg_rec.ass_attribute10:= hr_dt_attribute_support.get_parameter_char

575: ,p_parameter_name => 'p_ass_attribute9'
576: ,p_new_value => p_ass_attribute9
577: ,p_current_value => c_ass_attribute9);
578:
579: l_asg_rec.ass_attribute10:= hr_dt_attribute_support.get_parameter_char
580: (p_effective_date_row => l_effective_date_row
581: ,p_parameter_name => 'p_ass_attribute10'
582: ,p_new_value => p_ass_attribute10
583: ,p_current_value => c_ass_attribute10);

Line 586: l_asg_rec.ass_attribute11:= hr_dt_attribute_support.get_parameter_char

582: ,p_new_value => p_ass_attribute10
583: ,p_current_value => c_ass_attribute10);
584:
585:
586: l_asg_rec.ass_attribute11:= hr_dt_attribute_support.get_parameter_char
587: (p_effective_date_row => l_effective_date_row
588: ,p_parameter_name => 'p_ass_attribute11'
589: ,p_new_value => p_ass_attribute11
590: ,p_current_value => c_ass_attribute11);

Line 592: l_asg_rec.ass_attribute12:= hr_dt_attribute_support.get_parameter_char

588: ,p_parameter_name => 'p_ass_attribute11'
589: ,p_new_value => p_ass_attribute11
590: ,p_current_value => c_ass_attribute11);
591:
592: l_asg_rec.ass_attribute12:= hr_dt_attribute_support.get_parameter_char
593: (p_effective_date_row => l_effective_date_row
594: ,p_parameter_name => 'p_ass_attribute12'
595: ,p_new_value => p_ass_attribute12
596: ,p_current_value => c_ass_attribute12);

Line 598: l_asg_rec.ass_attribute13:= hr_dt_attribute_support.get_parameter_char

594: ,p_parameter_name => 'p_ass_attribute12'
595: ,p_new_value => p_ass_attribute12
596: ,p_current_value => c_ass_attribute12);
597:
598: l_asg_rec.ass_attribute13:= hr_dt_attribute_support.get_parameter_char
599: (p_effective_date_row => l_effective_date_row
600: ,p_parameter_name => 'p_ass_attribute13'
601: ,p_new_value => p_ass_attribute13
602: ,p_current_value => c_ass_attribute13);

Line 604: l_asg_rec.ass_attribute14:= hr_dt_attribute_support.get_parameter_char

600: ,p_parameter_name => 'p_ass_attribute13'
601: ,p_new_value => p_ass_attribute13
602: ,p_current_value => c_ass_attribute13);
603:
604: l_asg_rec.ass_attribute14:= hr_dt_attribute_support.get_parameter_char
605: (p_effective_date_row => l_effective_date_row
606: ,p_parameter_name => 'p_ass_attribute14'
607: ,p_new_value => p_ass_attribute14
608: ,p_current_value => c_ass_attribute14);

Line 610: l_asg_rec.ass_attribute15:= hr_dt_attribute_support.get_parameter_char

606: ,p_parameter_name => 'p_ass_attribute14'
607: ,p_new_value => p_ass_attribute14
608: ,p_current_value => c_ass_attribute14);
609:
610: l_asg_rec.ass_attribute15:= hr_dt_attribute_support.get_parameter_char
611: (p_effective_date_row => l_effective_date_row
612: ,p_parameter_name => 'p_ass_attribute15'
613: ,p_new_value => p_ass_attribute15
614: ,p_current_value => c_ass_attribute15);

Line 616: l_asg_rec.ass_attribute16:= hr_dt_attribute_support.get_parameter_char

612: ,p_parameter_name => 'p_ass_attribute15'
613: ,p_new_value => p_ass_attribute15
614: ,p_current_value => c_ass_attribute15);
615:
616: l_asg_rec.ass_attribute16:= hr_dt_attribute_support.get_parameter_char
617: (p_effective_date_row => l_effective_date_row
618: ,p_parameter_name => 'p_ass_attribute16'
619: ,p_new_value => p_ass_attribute16
620: ,p_current_value => c_ass_attribute16);

Line 622: l_asg_rec.ass_attribute17:= hr_dt_attribute_support.get_parameter_char

618: ,p_parameter_name => 'p_ass_attribute16'
619: ,p_new_value => p_ass_attribute16
620: ,p_current_value => c_ass_attribute16);
621:
622: l_asg_rec.ass_attribute17:= hr_dt_attribute_support.get_parameter_char
623: (p_effective_date_row => l_effective_date_row
624: ,p_parameter_name => 'p_ass_attribute17'
625: ,p_new_value => p_ass_attribute17
626: ,p_current_value => c_ass_attribute17);

Line 628: l_asg_rec.ass_attribute18:= hr_dt_attribute_support.get_parameter_char

624: ,p_parameter_name => 'p_ass_attribute17'
625: ,p_new_value => p_ass_attribute17
626: ,p_current_value => c_ass_attribute17);
627:
628: l_asg_rec.ass_attribute18:= hr_dt_attribute_support.get_parameter_char
629: (p_effective_date_row => l_effective_date_row
630: ,p_parameter_name => 'p_ass_attribute18'
631: ,p_new_value => p_ass_attribute18
632: ,p_current_value => c_ass_attribute18);

Line 634: l_asg_rec.ass_attribute19:= hr_dt_attribute_support.get_parameter_char

630: ,p_parameter_name => 'p_ass_attribute18'
631: ,p_new_value => p_ass_attribute18
632: ,p_current_value => c_ass_attribute18);
633:
634: l_asg_rec.ass_attribute19:= hr_dt_attribute_support.get_parameter_char
635: (p_effective_date_row => l_effective_date_row
636: ,p_parameter_name => 'p_ass_attribute19'
637: ,p_new_value => p_ass_attribute19
638: ,p_current_value => c_ass_attribute19);

Line 640: l_asg_rec.ass_attribute20:= hr_dt_attribute_support.get_parameter_char

636: ,p_parameter_name => 'p_ass_attribute19'
637: ,p_new_value => p_ass_attribute19
638: ,p_current_value => c_ass_attribute19);
639:
640: l_asg_rec.ass_attribute20:= hr_dt_attribute_support.get_parameter_char
641: (p_effective_date_row => l_effective_date_row
642: ,p_parameter_name => 'p_ass_attribute20'
643: ,p_new_value => p_ass_attribute20
644: ,p_current_value => c_ass_attribute20);

Line 646: l_asg_rec.ass_attribute21:= hr_dt_attribute_support.get_parameter_char

642: ,p_parameter_name => 'p_ass_attribute20'
643: ,p_new_value => p_ass_attribute20
644: ,p_current_value => c_ass_attribute20);
645:
646: l_asg_rec.ass_attribute21:= hr_dt_attribute_support.get_parameter_char
647: (p_effective_date_row => l_effective_date_row
648: ,p_parameter_name => 'p_ass_attribute21'
649: ,p_new_value => p_ass_attribute21
650: ,p_current_value => c_ass_attribute21);

Line 652: l_asg_rec.ass_attribute22:= hr_dt_attribute_support.get_parameter_char

648: ,p_parameter_name => 'p_ass_attribute21'
649: ,p_new_value => p_ass_attribute21
650: ,p_current_value => c_ass_attribute21);
651:
652: l_asg_rec.ass_attribute22:= hr_dt_attribute_support.get_parameter_char
653: (p_effective_date_row => l_effective_date_row
654: ,p_parameter_name => 'p_ass_attribute22'
655: ,p_new_value => p_ass_attribute22
656: ,p_current_value => c_ass_attribute22);

Line 658: l_asg_rec.ass_attribute23:= hr_dt_attribute_support.get_parameter_char

654: ,p_parameter_name => 'p_ass_attribute22'
655: ,p_new_value => p_ass_attribute22
656: ,p_current_value => c_ass_attribute22);
657:
658: l_asg_rec.ass_attribute23:= hr_dt_attribute_support.get_parameter_char
659: (p_effective_date_row => l_effective_date_row
660: ,p_parameter_name => 'p_ass_attribute23'
661: ,p_new_value => p_ass_attribute23
662: ,p_current_value => c_ass_attribute23);

Line 664: l_asg_rec.ass_attribute24:= hr_dt_attribute_support.get_parameter_char

660: ,p_parameter_name => 'p_ass_attribute23'
661: ,p_new_value => p_ass_attribute23
662: ,p_current_value => c_ass_attribute23);
663:
664: l_asg_rec.ass_attribute24:= hr_dt_attribute_support.get_parameter_char
665: (p_effective_date_row => l_effective_date_row
666: ,p_parameter_name => 'p_ass_attribute24'
667: ,p_new_value => p_ass_attribute24
668: ,p_current_value => c_ass_attribute24);

Line 670: l_asg_rec.ass_attribute25:= hr_dt_attribute_support.get_parameter_char

666: ,p_parameter_name => 'p_ass_attribute24'
667: ,p_new_value => p_ass_attribute24
668: ,p_current_value => c_ass_attribute24);
669:
670: l_asg_rec.ass_attribute25:= hr_dt_attribute_support.get_parameter_char
671: (p_effective_date_row => l_effective_date_row
672: ,p_parameter_name => 'p_ass_attribute25'
673: ,p_new_value => p_ass_attribute25
674: ,p_current_value => c_ass_attribute25);

Line 676: l_asg_rec.ass_attribute26:= hr_dt_attribute_support.get_parameter_char

672: ,p_parameter_name => 'p_ass_attribute25'
673: ,p_new_value => p_ass_attribute25
674: ,p_current_value => c_ass_attribute25);
675:
676: l_asg_rec.ass_attribute26:= hr_dt_attribute_support.get_parameter_char
677: (p_effective_date_row => l_effective_date_row
678: ,p_parameter_name => 'p_ass_attribute26'
679: ,p_new_value => p_ass_attribute26
680: ,p_current_value => c_ass_attribute26);

Line 682: l_asg_rec.ass_attribute27:= hr_dt_attribute_support.get_parameter_char

678: ,p_parameter_name => 'p_ass_attribute26'
679: ,p_new_value => p_ass_attribute26
680: ,p_current_value => c_ass_attribute26);
681:
682: l_asg_rec.ass_attribute27:= hr_dt_attribute_support.get_parameter_char
683: (p_effective_date_row => l_effective_date_row
684: ,p_parameter_name => 'p_ass_attribute27'
685: ,p_new_value => p_ass_attribute27
686: ,p_current_value => c_ass_attribute27);

Line 688: l_asg_rec.ass_attribute28:= hr_dt_attribute_support.get_parameter_char

684: ,p_parameter_name => 'p_ass_attribute27'
685: ,p_new_value => p_ass_attribute27
686: ,p_current_value => c_ass_attribute27);
687:
688: l_asg_rec.ass_attribute28:= hr_dt_attribute_support.get_parameter_char
689: (p_effective_date_row => l_effective_date_row
690: ,p_parameter_name => 'p_ass_attribute28'
691: ,p_new_value => p_ass_attribute28
692: ,p_current_value => c_ass_attribute28);

Line 694: l_asg_rec.ass_attribute29:= hr_dt_attribute_support.get_parameter_char

690: ,p_parameter_name => 'p_ass_attribute28'
691: ,p_new_value => p_ass_attribute28
692: ,p_current_value => c_ass_attribute28);
693:
694: l_asg_rec.ass_attribute29:= hr_dt_attribute_support.get_parameter_char
695: (p_effective_date_row => l_effective_date_row
696: ,p_parameter_name => 'p_ass_attribute29'
697: ,p_new_value => p_ass_attribute29
698: ,p_current_value => c_ass_attribute29);

Line 700: l_asg_rec.ass_attribute30:= hr_dt_attribute_support.get_parameter_char

696: ,p_parameter_name => 'p_ass_attribute29'
697: ,p_new_value => p_ass_attribute29
698: ,p_current_value => c_ass_attribute29);
699:
700: l_asg_rec.ass_attribute30:= hr_dt_attribute_support.get_parameter_char
701: (p_effective_date_row => l_effective_date_row
702: ,p_parameter_name => 'p_ass_attribute30'
703: ,p_new_value => p_ass_attribute30
704: ,p_current_value => c_ass_attribute30);

Line 706: l_asg_rec.title:= hr_dt_attribute_support.get_parameter_char

702: ,p_parameter_name => 'p_ass_attribute30'
703: ,p_new_value => p_ass_attribute30
704: ,p_current_value => c_ass_attribute30);
705:
706: l_asg_rec.title:= hr_dt_attribute_support.get_parameter_char
707: (p_effective_date_row => l_effective_date_row
708: ,p_parameter_name => 'p_title'
709: ,p_new_value => p_title
710: ,p_current_value => c_title);

Line 712: l_asg_rec.project_title:= hr_dt_attribute_support.get_parameter_char

708: ,p_parameter_name => 'p_title'
709: ,p_new_value => p_title
710: ,p_current_value => c_title);
711:
712: l_asg_rec.project_title:= hr_dt_attribute_support.get_parameter_char
713: (p_effective_date_row => l_effective_date_row
714: ,p_parameter_name => 'p_project_title'
715: ,p_new_value => p_project_title
716: ,p_current_value => c_project_title);

Line 719: hr_dt_attribute_support.get_parameter_char

715: ,p_new_value => p_project_title
716: ,p_current_value => c_project_title);
717:
718: l_asg_rec.vendor_assignment_number:=
719: hr_dt_attribute_support.get_parameter_char
720: (p_effective_date_row => l_effective_date_row
721: ,p_parameter_name => 'p_vendor_assignment_number'
722: ,p_new_value => p_vendor_assignment_number
723: ,p_current_value => c_vendor_assignment_number);

Line 726: hr_dt_attribute_support.get_parameter_char

722: ,p_new_value => p_vendor_assignment_number
723: ,p_current_value => c_vendor_assignment_number);
724:
725: l_asg_rec.vendor_employee_number:=
726: hr_dt_attribute_support.get_parameter_char
727: (p_effective_date_row => l_effective_date_row
728: ,p_parameter_name => 'p_vendor_employee_number'
729: ,p_new_value => p_vendor_employee_number
730: ,p_current_value => c_vendor_employee_number);

Line 732: l_asg_rec.vendor_id:= hr_dt_attribute_support.get_parameter_number

728: ,p_parameter_name => 'p_vendor_employee_number'
729: ,p_new_value => p_vendor_employee_number
730: ,p_current_value => c_vendor_employee_number);
731:
732: l_asg_rec.vendor_id:= hr_dt_attribute_support.get_parameter_number
733: (p_effective_date_row => l_effective_date_row
734: ,p_parameter_name => 'p_vendor_id'
735: ,p_new_value => p_vendor_id
736: ,p_current_value => c_vendor_id);

Line 742: if hr_dt_attribute_support.is_current_row_changing then

738: -- end if;
739:
740: --
741: -- call the API if at least one attribute can be changed
742: if hr_dt_attribute_support.is_current_row_changing then
743: -- set the object version number and effective date
744: if l_effective_date_row then
745: -- as we are on the first row, the ovn and effective date should be
746: -- set to the parameter specified by the caller

Line 1084: hr_dt_attribute_support.reset_parameter_statuses;

1080: -- ------------------------------------------------------------------------
1081: -- process any past row(s)
1082: if p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1083: -- reset the parameter statuses
1084: hr_dt_attribute_support.reset_parameter_statuses;
1085: for I in csr_asg2 loop
1086: if not process_row
1087: (c_effective_start_date => I.effective_start_date
1088: ,c_object_version_number => I.object_version_number

Line 1379: l_asg_rec.grade_id:= hr_dt_attribute_support.get_parameter_number

1375: l_proc varchar2(72) := g_package||'process_row';
1376: begin
1377: hr_utility.set_location('Entering:'|| l_proc, 5);
1378: -- get the parameter values to pass to the API
1379: l_asg_rec.grade_id:= hr_dt_attribute_support.get_parameter_number
1380: (p_effective_date_row => l_effective_date_row
1381: ,p_parameter_name => 'P_GRADE_ID'
1382: ,p_new_value => p_grade_id
1383: ,p_current_value => c_grade_id);

Line 1385: l_asg_rec.position_id:= hr_dt_attribute_support.get_parameter_number

1381: ,p_parameter_name => 'P_GRADE_ID'
1382: ,p_new_value => p_grade_id
1383: ,p_current_value => c_grade_id);
1384:
1385: l_asg_rec.position_id:= hr_dt_attribute_support.get_parameter_number
1386: (p_effective_date_row => l_effective_date_row
1387: ,p_parameter_name => 'P_POSITION_ID'
1388: ,p_new_value => p_position_id
1389: ,p_current_value => c_position_id);

Line 1391: l_asg_rec.job_id:= hr_dt_attribute_support.get_parameter_number

1387: ,p_parameter_name => 'P_POSITION_ID'
1388: ,p_new_value => p_position_id
1389: ,p_current_value => c_position_id);
1390:
1391: l_asg_rec.job_id:= hr_dt_attribute_support.get_parameter_number
1392: (p_effective_date_row => l_effective_date_row
1393: ,p_parameter_name => 'P_JOB_ID'
1394: ,p_new_value => p_job_id
1395: ,p_current_value => c_job_id);

Line 1397: l_asg_rec.payroll_id:= hr_dt_attribute_support.get_parameter_number

1393: ,p_parameter_name => 'P_JOB_ID'
1394: ,p_new_value => p_job_id
1395: ,p_current_value => c_job_id);
1396:
1397: l_asg_rec.payroll_id:= hr_dt_attribute_support.get_parameter_number
1398: (p_effective_date_row => l_effective_date_row
1399: ,p_parameter_name => 'P_PAYROLL_ID'
1400: ,p_new_value => p_payroll_id
1401: ,p_current_value => c_payroll_id);

Line 1403: l_asg_rec.location_id:= hr_dt_attribute_support.get_parameter_number

1399: ,p_parameter_name => 'P_PAYROLL_ID'
1400: ,p_new_value => p_payroll_id
1401: ,p_current_value => c_payroll_id);
1402:
1403: l_asg_rec.location_id:= hr_dt_attribute_support.get_parameter_number
1404: (p_effective_date_row => l_effective_date_row
1405: ,p_parameter_name => 'P_LOCATION_ID'
1406: ,p_new_value => p_location_id
1407: ,p_current_value => c_location_id);

Line 1409: l_asg_rec.special_ceiling_step_id:= hr_dt_attribute_support.get_parameter_number

1405: ,p_parameter_name => 'P_LOCATION_ID'
1406: ,p_new_value => p_location_id
1407: ,p_current_value => c_location_id);
1408:
1409: l_asg_rec.special_ceiling_step_id:= hr_dt_attribute_support.get_parameter_number
1410: (p_effective_date_row => l_effective_date_row
1411: ,p_parameter_name => 'P_SPECIAL_CEILING_STEP_ID'
1412: ,p_new_value => p_special_ceiling_step_id
1413: ,p_current_value => c_special_ceiling_step_id);

Line 1415: l_asg_rec.organization_id:= hr_dt_attribute_support.get_parameter_number

1411: ,p_parameter_name => 'P_SPECIAL_CEILING_STEP_ID'
1412: ,p_new_value => p_special_ceiling_step_id
1413: ,p_current_value => c_special_ceiling_step_id);
1414:
1415: l_asg_rec.organization_id:= hr_dt_attribute_support.get_parameter_number
1416: (p_effective_date_row => l_effective_date_row
1417: ,p_parameter_name => 'P_ORGANIZATION_ID'
1418: ,p_new_value => p_organization_id
1419: ,p_current_value => c_organization_id);

Line 1421: l_asg_rec.pay_basis_id:= hr_dt_attribute_support.get_parameter_number

1417: ,p_parameter_name => 'P_ORGANIZATION_ID'
1418: ,p_new_value => p_organization_id
1419: ,p_current_value => c_organization_id);
1420:
1421: l_asg_rec.pay_basis_id:= hr_dt_attribute_support.get_parameter_number
1422: (p_effective_date_row => l_effective_date_row
1423: ,p_parameter_name => 'P_PAY_BASIS_ID'
1424: ,p_new_value => p_pay_basis_id
1425: ,p_current_value => c_pay_basis_id);

Line 1427: l_asg_rec.employment_category:= hr_dt_attribute_support.get_parameter_char

1423: ,p_parameter_name => 'P_PAY_BASIS_ID'
1424: ,p_new_value => p_pay_basis_id
1425: ,p_current_value => c_pay_basis_id);
1426:
1427: l_asg_rec.employment_category:= hr_dt_attribute_support.get_parameter_char
1428: (p_effective_date_row => l_effective_date_row
1429: ,p_parameter_name => 'P_EMPLOYMENT_CATEGORY'
1430: ,p_new_value => p_employment_category
1431: ,p_current_value => c_employment_category);

Line 1435: if hr_dt_attribute_support.is_current_row_changing then

1431: ,p_current_value => c_employment_category);
1432:
1433: --
1434: -- call the API if at least one attribute can be changed
1435: if hr_dt_attribute_support.is_current_row_changing then
1436: -- set the object version number and effective date
1437: if l_effective_date_row then
1438: -- as we are on the first row, the ovn and effective date should be
1439: -- set to the parameter specified by the caller

Line 1641: hr_dt_attribute_support.reset_parameter_statuses;

1637: -- ------------------------------------------------------------------------
1638: -- process any past row(s)
1639: if p_attribute_update_mode = 'ATTRIBUTE_CORRECTION' then
1640: -- reset the parameter statuses
1641: hr_dt_attribute_support.reset_parameter_statuses;
1642: for I in csr_asg2 loop
1643: if not process_row
1644: (c_effective_start_date => I.effective_start_date
1645: ,c_object_version_number => I.object_version_number