eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_FR_ASSIGNMENT_API dependencies on HR_API

Line 1492: l_establishment_id NUMBER DEFAULT hr_api.g_number;

1488: l_comment_id NUMBER;
1489: l_effective_start_date DATE;
1490: l_effective_end_date DATE;
1491: l_ovn NUMBER;
1492: l_establishment_id NUMBER DEFAULT hr_api.g_number;
1493: l_datetrack_mode VARCHAR2 (100);
1494: l_normal_hours NUMBER;
1495: l_frequency VARCHAR2 (30);
1496: --

Line 1659: OR NVL (lr_old_assign_record.frequency, hr_api.g_varchar2) <>

1655:
1656: IF ( NVL (lr_old_assign_record.normal_hours, -1) <>
1657: NVL (l_normal_hours,
1658: -1)
1659: OR NVL (lr_old_assign_record.frequency, hr_api.g_varchar2) <>
1660: NVL (l_frequency, hr_api.g_varchar2)
1661: OR NVL (lr_old_assign_record.employee_category,
1662: hr_api.g_varchar2) <>
1663: NVL (p_employee_category, hr_api.g_varchar2)

Line 1660: NVL (l_frequency, hr_api.g_varchar2)

1656: IF ( NVL (lr_old_assign_record.normal_hours, -1) <>
1657: NVL (l_normal_hours,
1658: -1)
1659: OR NVL (lr_old_assign_record.frequency, hr_api.g_varchar2) <>
1660: NVL (l_frequency, hr_api.g_varchar2)
1661: OR NVL (lr_old_assign_record.employee_category,
1662: hr_api.g_varchar2) <>
1663: NVL (p_employee_category, hr_api.g_varchar2)
1664: )

Line 1662: hr_api.g_varchar2) <>

1658: -1)
1659: OR NVL (lr_old_assign_record.frequency, hr_api.g_varchar2) <>
1660: NVL (l_frequency, hr_api.g_varchar2)
1661: OR NVL (lr_old_assign_record.employee_category,
1662: hr_api.g_varchar2) <>
1663: NVL (p_employee_category, hr_api.g_varchar2)
1664: )
1665: THEN
1666: hr_assignment_api.update_emp_asg

Line 1663: NVL (p_employee_category, hr_api.g_varchar2)

1659: OR NVL (lr_old_assign_record.frequency, hr_api.g_varchar2) <>
1660: NVL (l_frequency, hr_api.g_varchar2)
1661: OR NVL (lr_old_assign_record.employee_category,
1662: hr_api.g_varchar2) <>
1663: NVL (p_employee_category, hr_api.g_varchar2)
1664: )
1665: THEN
1666: hr_assignment_api.update_emp_asg
1667: (p_validate => p_validate,

Line 1693: IF (NVL (lr_old_assign_record.employee_category, hr_api.g_varchar2) <>

1689: --
1690: ELSIF l_asg_type = 'C'
1691: THEN
1692: -- CWK Worker
1693: IF (NVL (lr_old_assign_record.employee_category, hr_api.g_varchar2) <>
1694: NVL (p_employee_category, hr_api.g_varchar2)
1695: )
1696: THEN
1697: hr_assignment_api.update_cwk_asg

Line 1694: NVL (p_employee_category, hr_api.g_varchar2)

1690: ELSIF l_asg_type = 'C'
1691: THEN
1692: -- CWK Worker
1693: IF (NVL (lr_old_assign_record.employee_category, hr_api.g_varchar2) <>
1694: NVL (p_employee_category, hr_api.g_varchar2)
1695: )
1696: THEN
1697: hr_assignment_api.update_cwk_asg
1698: (p_validate => p_validate,

Line 1773: IF ( NVL (placement_record.information3, hr_api.g_varchar2) <>

1769: 'PLACEMENT_ID',
1770: placement_record.placement_id
1771: );
1772:
1773: IF ( NVL (placement_record.information3, hr_api.g_varchar2) <>
1774: NVL (p_progression_speed, hr_api.g_varchar2)
1775: OR NVL (placement_record.information4, hr_api.g_varchar2) <>
1776: NVL (p_personal_gross_index, hr_api.g_varchar2)
1777: OR NVL (placement_record.step_id, -1) <> NVL (p_step_id, -1)

Line 1774: NVL (p_progression_speed, hr_api.g_varchar2)

1770: placement_record.placement_id
1771: );
1772:
1773: IF ( NVL (placement_record.information3, hr_api.g_varchar2) <>
1774: NVL (p_progression_speed, hr_api.g_varchar2)
1775: OR NVL (placement_record.information4, hr_api.g_varchar2) <>
1776: NVL (p_personal_gross_index, hr_api.g_varchar2)
1777: OR NVL (placement_record.step_id, -1) <> NVL (p_step_id, -1)
1778: )

Line 1775: OR NVL (placement_record.information4, hr_api.g_varchar2) <>

1771: );
1772:
1773: IF ( NVL (placement_record.information3, hr_api.g_varchar2) <>
1774: NVL (p_progression_speed, hr_api.g_varchar2)
1775: OR NVL (placement_record.information4, hr_api.g_varchar2) <>
1776: NVL (p_personal_gross_index, hr_api.g_varchar2)
1777: OR NVL (placement_record.step_id, -1) <> NVL (p_step_id, -1)
1778: )
1779: THEN

Line 1776: NVL (p_personal_gross_index, hr_api.g_varchar2)

1772:
1773: IF ( NVL (placement_record.information3, hr_api.g_varchar2) <>
1774: NVL (p_progression_speed, hr_api.g_varchar2)
1775: OR NVL (placement_record.information4, hr_api.g_varchar2) <>
1776: NVL (p_personal_gross_index, hr_api.g_varchar2)
1777: OR NVL (placement_record.step_id, -1) <> NVL (p_step_id, -1)
1778: )
1779: THEN
1780: hr_sp_placement_api.update_spp