APPS.PER_APP_ASG_PKG dependencies on HR_GENERAL

Line 457: p_frequency_meaning := hr_general.decode_lookup( 'FREQUENCY',

453: -- Set the frequency meaning if the frequency is not null and the meaning is
454: -- null
455: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 9 ) ;
456: if ( ( p_frequency is not null ) and ( p_frequency_meaning is null ) ) then
457: p_frequency_meaning := hr_general.decode_lookup( 'FREQUENCY',
458: p_frequency ) ;
459: end if;
460: --
461: --

Line 672: if ( p_validation_end_date = hr_general.end_of_time ) then

668: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 10 ) ;
669:
670: elsif ( p_delete_mode in ('FUTURE_CHANGE','DELETE_NEXT_CHANGE' ) ) then
671: if ( p_new_end_date is null ) then
672: if ( p_validation_end_date = hr_general.end_of_time ) then
673: hr_assignment.tidy_up_ref_int ( p_assignment_id,
674: 'FUTURE',
675: p_validation_end_date,
676: p_effective_end_date,

Line 1590: p_frequency_meaning := hr_general.decode_lookup( 'FREQUENCY',

1586: -- Set the frequency meaning if the frequency is not null and the meaning is
1587: -- null
1588: if ( ( p_frequency is not null ) and ( p_frequency_meaning is null ) ) then
1589: hr_utility.set_location ('per_app_asg_pkg.update_row', 21);
1590: p_frequency_meaning := hr_general.decode_lookup( 'FREQUENCY',
1591: p_frequency ) ;
1592: end if;
1593: --
1594: --

Line 1647: if max_apl_date = hr_general.end_of_time

1643: hr_utility.raise_error;
1644: end if;
1645: close get_max_apl_date;
1646:
1647: if max_apl_date = hr_general.end_of_time
1648: then
1649: p_status := 'UPD_OR_CORR';
1650: elsif hr_general2.is_person_type(p_person_id,
1651: 'EMP',

Line 1650: elsif hr_general2.is_person_type(p_person_id,

1646:
1647: if max_apl_date = hr_general.end_of_time
1648: then
1649: p_status := 'UPD_OR_CORR';
1650: elsif hr_general2.is_person_type(p_person_id,
1651: 'EMP',
1652: max_apl_date + 1)
1653: then
1654: p_status := 'CORR_ONLY';

Line 1790: if ( l_dummy_date < hr_general.end_of_time ) then

1786: hr_utility.set_location ('per_app_asg_pkg.check_end_date', 10);
1787: open c1 ;
1788: fetch c1 into l_dummy_date ;
1789: close c1 ;
1790: if ( l_dummy_date < hr_general.end_of_time ) then
1791: hr_utility.set_message ( 801 , 'HR_ASS_FUTURE_END' ) ;
1792: hr_utility.set_warning ;
1793: p_warning_set := true ;
1794: else

Line 1902: and (apl.effective_end_date = hr_general.end_of_time

1898: select 'Y' from per_assignments_f apl
1899: where apl.assignment_type = 'A'
1900: and apl.application_id = cp_appl_id
1901: and apl.assignment_id <> cp_asg_id
1902: and (apl.effective_end_date = hr_general.end_of_time
1903: or exists
1904: (select 'Y' from per_applications apa
1905: where apa.application_id = cp_appl_id
1906: and apa.date_end is not null