1829: ,p_login_person_id in varchar2 default null
1830: ,p_assignment_id in varchar2
1831: ,p_object_version_number in varchar2
1832: ,p_effective_date in varchar2
1833: ,p_grade_id in varchar2 default to_char(hr_api.g_number)
1834: ,p_position_id in varchar2 default to_char(hr_api.g_number)
1835: ,p_job_id in varchar2 default to_char(hr_api.g_number)
1836: ,p_location_id in varchar2 default to_char(hr_api.g_number)
1837: ,p_special_ceiling_step_id in varchar2 default to_char(hr_api.g_number)
1830: ,p_assignment_id in varchar2
1831: ,p_object_version_number in varchar2
1832: ,p_effective_date in varchar2
1833: ,p_grade_id in varchar2 default to_char(hr_api.g_number)
1834: ,p_position_id in varchar2 default to_char(hr_api.g_number)
1835: ,p_job_id in varchar2 default to_char(hr_api.g_number)
1836: ,p_location_id in varchar2 default to_char(hr_api.g_number)
1837: ,p_special_ceiling_step_id in varchar2 default to_char(hr_api.g_number)
1838: ,p_organization_id in varchar2 default to_char(hr_api.g_number)
1831: ,p_object_version_number in varchar2
1832: ,p_effective_date in varchar2
1833: ,p_grade_id in varchar2 default to_char(hr_api.g_number)
1834: ,p_position_id in varchar2 default to_char(hr_api.g_number)
1835: ,p_job_id in varchar2 default to_char(hr_api.g_number)
1836: ,p_location_id in varchar2 default to_char(hr_api.g_number)
1837: ,p_special_ceiling_step_id in varchar2 default to_char(hr_api.g_number)
1838: ,p_organization_id in varchar2 default to_char(hr_api.g_number)
1839: ,p_employment_category in varchar2 default hr_api.g_varchar2
1832: ,p_effective_date in varchar2
1833: ,p_grade_id in varchar2 default to_char(hr_api.g_number)
1834: ,p_position_id in varchar2 default to_char(hr_api.g_number)
1835: ,p_job_id in varchar2 default to_char(hr_api.g_number)
1836: ,p_location_id in varchar2 default to_char(hr_api.g_number)
1837: ,p_special_ceiling_step_id in varchar2 default to_char(hr_api.g_number)
1838: ,p_organization_id in varchar2 default to_char(hr_api.g_number)
1839: ,p_employment_category in varchar2 default hr_api.g_varchar2
1840: ,p_supervisor_id in varchar2 default to_char(hr_api.g_number)
1833: ,p_grade_id in varchar2 default to_char(hr_api.g_number)
1834: ,p_position_id in varchar2 default to_char(hr_api.g_number)
1835: ,p_job_id in varchar2 default to_char(hr_api.g_number)
1836: ,p_location_id in varchar2 default to_char(hr_api.g_number)
1837: ,p_special_ceiling_step_id in varchar2 default to_char(hr_api.g_number)
1838: ,p_organization_id in varchar2 default to_char(hr_api.g_number)
1839: ,p_employment_category in varchar2 default hr_api.g_varchar2
1840: ,p_supervisor_id in varchar2 default to_char(hr_api.g_number)
1841: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1834: ,p_position_id in varchar2 default to_char(hr_api.g_number)
1835: ,p_job_id in varchar2 default to_char(hr_api.g_number)
1836: ,p_location_id in varchar2 default to_char(hr_api.g_number)
1837: ,p_special_ceiling_step_id in varchar2 default to_char(hr_api.g_number)
1838: ,p_organization_id in varchar2 default to_char(hr_api.g_number)
1839: ,p_employment_category in varchar2 default hr_api.g_varchar2
1840: ,p_supervisor_id in varchar2 default to_char(hr_api.g_number)
1841: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1842: ,p_normal_hours in varchar2 default to_char(hr_api.g_number)
1835: ,p_job_id in varchar2 default to_char(hr_api.g_number)
1836: ,p_location_id in varchar2 default to_char(hr_api.g_number)
1837: ,p_special_ceiling_step_id in varchar2 default to_char(hr_api.g_number)
1838: ,p_organization_id in varchar2 default to_char(hr_api.g_number)
1839: ,p_employment_category in varchar2 default hr_api.g_varchar2
1840: ,p_supervisor_id in varchar2 default to_char(hr_api.g_number)
1841: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1842: ,p_normal_hours in varchar2 default to_char(hr_api.g_number)
1843: ,p_frequency in varchar2 default hr_api.g_varchar2
1836: ,p_location_id in varchar2 default to_char(hr_api.g_number)
1837: ,p_special_ceiling_step_id in varchar2 default to_char(hr_api.g_number)
1838: ,p_organization_id in varchar2 default to_char(hr_api.g_number)
1839: ,p_employment_category in varchar2 default hr_api.g_varchar2
1840: ,p_supervisor_id in varchar2 default to_char(hr_api.g_number)
1841: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1842: ,p_normal_hours in varchar2 default to_char(hr_api.g_number)
1843: ,p_frequency in varchar2 default hr_api.g_varchar2
1844: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1837: ,p_special_ceiling_step_id in varchar2 default to_char(hr_api.g_number)
1838: ,p_organization_id in varchar2 default to_char(hr_api.g_number)
1839: ,p_employment_category in varchar2 default hr_api.g_varchar2
1840: ,p_supervisor_id in varchar2 default to_char(hr_api.g_number)
1841: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1842: ,p_normal_hours in varchar2 default to_char(hr_api.g_number)
1843: ,p_frequency in varchar2 default hr_api.g_varchar2
1844: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1845: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1838: ,p_organization_id in varchar2 default to_char(hr_api.g_number)
1839: ,p_employment_category in varchar2 default hr_api.g_varchar2
1840: ,p_supervisor_id in varchar2 default to_char(hr_api.g_number)
1841: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1842: ,p_normal_hours in varchar2 default to_char(hr_api.g_number)
1843: ,p_frequency in varchar2 default hr_api.g_varchar2
1844: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1845: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1846: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1839: ,p_employment_category in varchar2 default hr_api.g_varchar2
1840: ,p_supervisor_id in varchar2 default to_char(hr_api.g_number)
1841: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1842: ,p_normal_hours in varchar2 default to_char(hr_api.g_number)
1843: ,p_frequency in varchar2 default hr_api.g_varchar2
1844: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1845: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1846: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1847: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1840: ,p_supervisor_id in varchar2 default to_char(hr_api.g_number)
1841: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1842: ,p_normal_hours in varchar2 default to_char(hr_api.g_number)
1843: ,p_frequency in varchar2 default hr_api.g_varchar2
1844: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1845: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1846: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1847: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1848: ,p_assignment_status_type_id in varchar2 default to_char(hr_api.g_number)
1841: ,p_manager_flag in varchar2 default hr_api.g_varchar2
1842: ,p_normal_hours in varchar2 default to_char(hr_api.g_number)
1843: ,p_frequency in varchar2 default hr_api.g_varchar2
1844: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1845: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1846: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1847: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1848: ,p_assignment_status_type_id in varchar2 default to_char(hr_api.g_number)
1849: ,p_change_reason in varchar2 default hr_api.g_varchar2
1842: ,p_normal_hours in varchar2 default to_char(hr_api.g_number)
1843: ,p_frequency in varchar2 default hr_api.g_varchar2
1844: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1845: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1846: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1847: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1848: ,p_assignment_status_type_id in varchar2 default to_char(hr_api.g_number)
1849: ,p_change_reason in varchar2 default hr_api.g_varchar2
1850: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1843: ,p_frequency in varchar2 default hr_api.g_varchar2
1844: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1845: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1846: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1847: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1848: ,p_assignment_status_type_id in varchar2 default to_char(hr_api.g_number)
1849: ,p_change_reason in varchar2 default hr_api.g_varchar2
1850: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1851: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1844: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
1845: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1846: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1847: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1848: ,p_assignment_status_type_id in varchar2 default to_char(hr_api.g_number)
1849: ,p_change_reason in varchar2 default hr_api.g_varchar2
1850: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1851: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1852: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1845: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
1846: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1847: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1848: ,p_assignment_status_type_id in varchar2 default to_char(hr_api.g_number)
1849: ,p_change_reason in varchar2 default hr_api.g_varchar2
1850: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1851: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1852: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1853: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1846: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
1847: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1848: ,p_assignment_status_type_id in varchar2 default to_char(hr_api.g_number)
1849: ,p_change_reason in varchar2 default hr_api.g_varchar2
1850: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1851: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1852: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1853: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1854: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1847: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
1848: ,p_assignment_status_type_id in varchar2 default to_char(hr_api.g_number)
1849: ,p_change_reason in varchar2 default hr_api.g_varchar2
1850: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1851: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1852: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1853: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1854: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1855: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1848: ,p_assignment_status_type_id in varchar2 default to_char(hr_api.g_number)
1849: ,p_change_reason in varchar2 default hr_api.g_varchar2
1850: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1851: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1852: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1853: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1854: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1855: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1856: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1849: ,p_change_reason in varchar2 default hr_api.g_varchar2
1850: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1851: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1852: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1853: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1854: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1855: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1856: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1857: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1850: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1851: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1852: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1853: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1854: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1855: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1856: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1857: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1858: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1851: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1852: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1853: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1854: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1855: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1856: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1857: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1858: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1859: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1852: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1853: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1854: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1855: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1856: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1857: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1858: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1859: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1860: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1853: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1854: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1855: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1856: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1857: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1858: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1859: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1860: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1861: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1854: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1855: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1856: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1857: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1858: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1859: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1860: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1861: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1862: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1855: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1856: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1857: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1858: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1859: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1860: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1861: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1862: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1863: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1856: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1857: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1858: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1859: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1860: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1861: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1862: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1863: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1864: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1857: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1858: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1859: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1860: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1861: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1862: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1863: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1864: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1865: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1858: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1859: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1860: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1861: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1862: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1863: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1864: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1865: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1866: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1859: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1860: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1861: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1862: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1863: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1864: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1865: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1866: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1867: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1860: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1861: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1862: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1863: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1864: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1865: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1866: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1867: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1868: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1861: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1862: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1863: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1864: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1865: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1866: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1867: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1868: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1869: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1862: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1863: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1864: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1865: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1866: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1867: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1868: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1869: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1870: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1863: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1864: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1865: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1866: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1867: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1868: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1869: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1870: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1871: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1864: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1865: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1866: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1867: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1868: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1869: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1870: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1871: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1872: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1865: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1866: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1867: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1868: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1869: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1870: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1871: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1872: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1873: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1866: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1867: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1868: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1869: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1870: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1871: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1872: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1873: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1874: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1867: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1868: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1869: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1870: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1871: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1872: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1873: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1874: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1875: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1868: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1869: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1870: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1871: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1872: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1873: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1874: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1875: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1876: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1869: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1870: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1871: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1872: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1873: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1874: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1875: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1876: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1877: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1870: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1871: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1872: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1873: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1874: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1875: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1876: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1877: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1878: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1871: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1872: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1873: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1874: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1875: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1876: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1877: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1878: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1879: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1872: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1873: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1874: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1875: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1876: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1877: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1878: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1879: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1880: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1873: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1874: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1875: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1876: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1877: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1878: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1879: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1880: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1881: ,p_soft_coding_keyflex_id in varchar2 default to_char(hr_api.g_number)
1874: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1875: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1876: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1877: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1878: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1879: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1880: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1881: ,p_soft_coding_keyflex_id in varchar2 default to_char(hr_api.g_number)
1882: ,p_people_group_id in varchar2 default to_char(hr_api.g_number)
1875: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1876: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1877: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1878: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1879: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1880: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1881: ,p_soft_coding_keyflex_id in varchar2 default to_char(hr_api.g_number)
1882: ,p_people_group_id in varchar2 default to_char(hr_api.g_number)
1883: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
1876: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1877: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1878: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1879: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1880: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1881: ,p_soft_coding_keyflex_id in varchar2 default to_char(hr_api.g_number)
1882: ,p_people_group_id in varchar2 default to_char(hr_api.g_number)
1883: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
1884: ,p_display_pos in varchar2 default hr_api.g_varchar2
1877: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1878: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1879: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1880: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1881: ,p_soft_coding_keyflex_id in varchar2 default to_char(hr_api.g_number)
1882: ,p_people_group_id in varchar2 default to_char(hr_api.g_number)
1883: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
1884: ,p_display_pos in varchar2 default hr_api.g_varchar2
1885: ,p_display_org in varchar2 default hr_api.g_varchar2
1878: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1879: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1880: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1881: ,p_soft_coding_keyflex_id in varchar2 default to_char(hr_api.g_number)
1882: ,p_people_group_id in varchar2 default to_char(hr_api.g_number)
1883: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
1884: ,p_display_pos in varchar2 default hr_api.g_varchar2
1885: ,p_display_org in varchar2 default hr_api.g_varchar2
1886: ,p_display_job in varchar2 default hr_api.g_varchar2
1879: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1880: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1881: ,p_soft_coding_keyflex_id in varchar2 default to_char(hr_api.g_number)
1882: ,p_people_group_id in varchar2 default to_char(hr_api.g_number)
1883: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
1884: ,p_display_pos in varchar2 default hr_api.g_varchar2
1885: ,p_display_org in varchar2 default hr_api.g_varchar2
1886: ,p_display_job in varchar2 default hr_api.g_varchar2
1887: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
1880: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1881: ,p_soft_coding_keyflex_id in varchar2 default to_char(hr_api.g_number)
1882: ,p_people_group_id in varchar2 default to_char(hr_api.g_number)
1883: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
1884: ,p_display_pos in varchar2 default hr_api.g_varchar2
1885: ,p_display_org in varchar2 default hr_api.g_varchar2
1886: ,p_display_job in varchar2 default hr_api.g_varchar2
1887: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
1888: ,p_grade_lov in varchar2 default hr_api.g_varchar2
1881: ,p_soft_coding_keyflex_id in varchar2 default to_char(hr_api.g_number)
1882: ,p_people_group_id in varchar2 default to_char(hr_api.g_number)
1883: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
1884: ,p_display_pos in varchar2 default hr_api.g_varchar2
1885: ,p_display_org in varchar2 default hr_api.g_varchar2
1886: ,p_display_job in varchar2 default hr_api.g_varchar2
1887: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
1888: ,p_grade_lov in varchar2 default hr_api.g_varchar2
1889: ,p_approver_id in varchar2 default to_char(hr_api.g_number)
1882: ,p_people_group_id in varchar2 default to_char(hr_api.g_number)
1883: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
1884: ,p_display_pos in varchar2 default hr_api.g_varchar2
1885: ,p_display_org in varchar2 default hr_api.g_varchar2
1886: ,p_display_job in varchar2 default hr_api.g_varchar2
1887: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
1888: ,p_grade_lov in varchar2 default hr_api.g_varchar2
1889: ,p_approver_id in varchar2 default to_char(hr_api.g_number)
1890: ,p_review_proc_call in varchar2
1883: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
1884: ,p_display_pos in varchar2 default hr_api.g_varchar2
1885: ,p_display_org in varchar2 default hr_api.g_varchar2
1886: ,p_display_job in varchar2 default hr_api.g_varchar2
1887: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
1888: ,p_grade_lov in varchar2 default hr_api.g_varchar2
1889: ,p_approver_id in varchar2 default to_char(hr_api.g_number)
1890: ,p_review_proc_call in varchar2
1891: ,p_display_grade in varchar2 default hr_api.g_varchar2
1884: ,p_display_pos in varchar2 default hr_api.g_varchar2
1885: ,p_display_org in varchar2 default hr_api.g_varchar2
1886: ,p_display_job in varchar2 default hr_api.g_varchar2
1887: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
1888: ,p_grade_lov in varchar2 default hr_api.g_varchar2
1889: ,p_approver_id in varchar2 default to_char(hr_api.g_number)
1890: ,p_review_proc_call in varchar2
1891: ,p_display_grade in varchar2 default hr_api.g_varchar2
1892: ,p_contract_id in varchar2 default to_char(hr_api.g_number)
1885: ,p_display_org in varchar2 default hr_api.g_varchar2
1886: ,p_display_job in varchar2 default hr_api.g_varchar2
1887: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
1888: ,p_grade_lov in varchar2 default hr_api.g_varchar2
1889: ,p_approver_id in varchar2 default to_char(hr_api.g_number)
1890: ,p_review_proc_call in varchar2
1891: ,p_display_grade in varchar2 default hr_api.g_varchar2
1892: ,p_contract_id in varchar2 default to_char(hr_api.g_number)
1893: ,p_establishment_id in varchar2 default to_char(hr_api.g_number)
1887: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
1888: ,p_grade_lov in varchar2 default hr_api.g_varchar2
1889: ,p_approver_id in varchar2 default to_char(hr_api.g_number)
1890: ,p_review_proc_call in varchar2
1891: ,p_display_grade in varchar2 default hr_api.g_varchar2
1892: ,p_contract_id in varchar2 default to_char(hr_api.g_number)
1893: ,p_establishment_id in varchar2 default to_char(hr_api.g_number)
1894: ,p_cagr_grade_def_id in varchar2 default to_char(hr_api.g_number)
1895: ,p_collective_agreement_id in varchar2 default to_char(hr_api.g_number)
1888: ,p_grade_lov in varchar2 default hr_api.g_varchar2
1889: ,p_approver_id in varchar2 default to_char(hr_api.g_number)
1890: ,p_review_proc_call in varchar2
1891: ,p_display_grade in varchar2 default hr_api.g_varchar2
1892: ,p_contract_id in varchar2 default to_char(hr_api.g_number)
1893: ,p_establishment_id in varchar2 default to_char(hr_api.g_number)
1894: ,p_cagr_grade_def_id in varchar2 default to_char(hr_api.g_number)
1895: ,p_collective_agreement_id in varchar2 default to_char(hr_api.g_number)
1896: ,p_cagr_id_flex_num in varchar2 default to_char(hr_api.g_number)
1889: ,p_approver_id in varchar2 default to_char(hr_api.g_number)
1890: ,p_review_proc_call in varchar2
1891: ,p_display_grade in varchar2 default hr_api.g_varchar2
1892: ,p_contract_id in varchar2 default to_char(hr_api.g_number)
1893: ,p_establishment_id in varchar2 default to_char(hr_api.g_number)
1894: ,p_cagr_grade_def_id in varchar2 default to_char(hr_api.g_number)
1895: ,p_collective_agreement_id in varchar2 default to_char(hr_api.g_number)
1896: ,p_cagr_id_flex_num in varchar2 default to_char(hr_api.g_number)
1897: ,p_payroll_id in varchar2 default to_char(hr_api.g_number)
1890: ,p_review_proc_call in varchar2
1891: ,p_display_grade in varchar2 default hr_api.g_varchar2
1892: ,p_contract_id in varchar2 default to_char(hr_api.g_number)
1893: ,p_establishment_id in varchar2 default to_char(hr_api.g_number)
1894: ,p_cagr_grade_def_id in varchar2 default to_char(hr_api.g_number)
1895: ,p_collective_agreement_id in varchar2 default to_char(hr_api.g_number)
1896: ,p_cagr_id_flex_num in varchar2 default to_char(hr_api.g_number)
1897: ,p_payroll_id in varchar2 default to_char(hr_api.g_number)
1898: ,p_pay_basis_id in varchar2 default to_char(hr_api.g_number)
1891: ,p_display_grade in varchar2 default hr_api.g_varchar2
1892: ,p_contract_id in varchar2 default to_char(hr_api.g_number)
1893: ,p_establishment_id in varchar2 default to_char(hr_api.g_number)
1894: ,p_cagr_grade_def_id in varchar2 default to_char(hr_api.g_number)
1895: ,p_collective_agreement_id in varchar2 default to_char(hr_api.g_number)
1896: ,p_cagr_id_flex_num in varchar2 default to_char(hr_api.g_number)
1897: ,p_payroll_id in varchar2 default to_char(hr_api.g_number)
1898: ,p_pay_basis_id in varchar2 default to_char(hr_api.g_number)
1899: ,p_sal_review_period in varchar2 default to_char(hr_api.g_number)
1892: ,p_contract_id in varchar2 default to_char(hr_api.g_number)
1893: ,p_establishment_id in varchar2 default to_char(hr_api.g_number)
1894: ,p_cagr_grade_def_id in varchar2 default to_char(hr_api.g_number)
1895: ,p_collective_agreement_id in varchar2 default to_char(hr_api.g_number)
1896: ,p_cagr_id_flex_num in varchar2 default to_char(hr_api.g_number)
1897: ,p_payroll_id in varchar2 default to_char(hr_api.g_number)
1898: ,p_pay_basis_id in varchar2 default to_char(hr_api.g_number)
1899: ,p_sal_review_period in varchar2 default to_char(hr_api.g_number)
1900: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1893: ,p_establishment_id in varchar2 default to_char(hr_api.g_number)
1894: ,p_cagr_grade_def_id in varchar2 default to_char(hr_api.g_number)
1895: ,p_collective_agreement_id in varchar2 default to_char(hr_api.g_number)
1896: ,p_cagr_id_flex_num in varchar2 default to_char(hr_api.g_number)
1897: ,p_payroll_id in varchar2 default to_char(hr_api.g_number)
1898: ,p_pay_basis_id in varchar2 default to_char(hr_api.g_number)
1899: ,p_sal_review_period in varchar2 default to_char(hr_api.g_number)
1900: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1901: ,p_date_probation_end in varchar2 default to_char(hr_api.g_date,g_date_format)
1894: ,p_cagr_grade_def_id in varchar2 default to_char(hr_api.g_number)
1895: ,p_collective_agreement_id in varchar2 default to_char(hr_api.g_number)
1896: ,p_cagr_id_flex_num in varchar2 default to_char(hr_api.g_number)
1897: ,p_payroll_id in varchar2 default to_char(hr_api.g_number)
1898: ,p_pay_basis_id in varchar2 default to_char(hr_api.g_number)
1899: ,p_sal_review_period in varchar2 default to_char(hr_api.g_number)
1900: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1901: ,p_date_probation_end in varchar2 default to_char(hr_api.g_date,g_date_format)
1902: ,p_probation_period in varchar2 default to_char(hr_api.g_number)
1895: ,p_collective_agreement_id in varchar2 default to_char(hr_api.g_number)
1896: ,p_cagr_id_flex_num in varchar2 default to_char(hr_api.g_number)
1897: ,p_payroll_id in varchar2 default to_char(hr_api.g_number)
1898: ,p_pay_basis_id in varchar2 default to_char(hr_api.g_number)
1899: ,p_sal_review_period in varchar2 default to_char(hr_api.g_number)
1900: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1901: ,p_date_probation_end in varchar2 default to_char(hr_api.g_date,g_date_format)
1902: ,p_probation_period in varchar2 default to_char(hr_api.g_number)
1903: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1896: ,p_cagr_id_flex_num in varchar2 default to_char(hr_api.g_number)
1897: ,p_payroll_id in varchar2 default to_char(hr_api.g_number)
1898: ,p_pay_basis_id in varchar2 default to_char(hr_api.g_number)
1899: ,p_sal_review_period in varchar2 default to_char(hr_api.g_number)
1900: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1901: ,p_date_probation_end in varchar2 default to_char(hr_api.g_date,g_date_format)
1902: ,p_probation_period in varchar2 default to_char(hr_api.g_number)
1903: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1904: ,p_notice_period in varchar2 default to_char(hr_api.g_number)
1897: ,p_payroll_id in varchar2 default to_char(hr_api.g_number)
1898: ,p_pay_basis_id in varchar2 default to_char(hr_api.g_number)
1899: ,p_sal_review_period in varchar2 default to_char(hr_api.g_number)
1900: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1901: ,p_date_probation_end in varchar2 default to_char(hr_api.g_date,g_date_format)
1902: ,p_probation_period in varchar2 default to_char(hr_api.g_number)
1903: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1904: ,p_notice_period in varchar2 default to_char(hr_api.g_number)
1905: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1898: ,p_pay_basis_id in varchar2 default to_char(hr_api.g_number)
1899: ,p_sal_review_period in varchar2 default to_char(hr_api.g_number)
1900: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1901: ,p_date_probation_end in varchar2 default to_char(hr_api.g_date,g_date_format)
1902: ,p_probation_period in varchar2 default to_char(hr_api.g_number)
1903: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1904: ,p_notice_period in varchar2 default to_char(hr_api.g_number)
1905: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1906: ,p_employee_category in varchar2 default hr_api.g_varchar2
1899: ,p_sal_review_period in varchar2 default to_char(hr_api.g_number)
1900: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1901: ,p_date_probation_end in varchar2 default to_char(hr_api.g_date,g_date_format)
1902: ,p_probation_period in varchar2 default to_char(hr_api.g_number)
1903: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1904: ,p_notice_period in varchar2 default to_char(hr_api.g_number)
1905: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1906: ,p_employee_category in varchar2 default hr_api.g_varchar2
1907: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1900: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
1901: ,p_date_probation_end in varchar2 default to_char(hr_api.g_date,g_date_format)
1902: ,p_probation_period in varchar2 default to_char(hr_api.g_number)
1903: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1904: ,p_notice_period in varchar2 default to_char(hr_api.g_number)
1905: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1906: ,p_employee_category in varchar2 default hr_api.g_varchar2
1907: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1908: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1901: ,p_date_probation_end in varchar2 default to_char(hr_api.g_date,g_date_format)
1902: ,p_probation_period in varchar2 default to_char(hr_api.g_number)
1903: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1904: ,p_notice_period in varchar2 default to_char(hr_api.g_number)
1905: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1906: ,p_employee_category in varchar2 default hr_api.g_varchar2
1907: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1908: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1909: ,p_perf_review_period in varchar2 default to_char(hr_api.g_number)
1902: ,p_probation_period in varchar2 default to_char(hr_api.g_number)
1903: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1904: ,p_notice_period in varchar2 default to_char(hr_api.g_number)
1905: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1906: ,p_employee_category in varchar2 default hr_api.g_varchar2
1907: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1908: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1909: ,p_perf_review_period in varchar2 default to_char(hr_api.g_number)
1910: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1903: ,p_probation_unit in varchar2 default hr_api.g_varchar2
1904: ,p_notice_period in varchar2 default to_char(hr_api.g_number)
1905: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1906: ,p_employee_category in varchar2 default hr_api.g_varchar2
1907: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1908: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1909: ,p_perf_review_period in varchar2 default to_char(hr_api.g_number)
1910: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1911: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1904: ,p_notice_period in varchar2 default to_char(hr_api.g_number)
1905: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1906: ,p_employee_category in varchar2 default hr_api.g_varchar2
1907: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1908: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1909: ,p_perf_review_period in varchar2 default to_char(hr_api.g_number)
1910: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1911: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1912: ,p_element_changed in out nocopy varchar2
1905: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
1906: ,p_employee_category in varchar2 default hr_api.g_varchar2
1907: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1908: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1909: ,p_perf_review_period in varchar2 default to_char(hr_api.g_number)
1910: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1911: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1912: ,p_element_changed in out nocopy varchar2
1913: ,p_page_error in out nocopy varchar2
1906: ,p_employee_category in varchar2 default hr_api.g_varchar2
1907: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1908: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1909: ,p_perf_review_period in varchar2 default to_char(hr_api.g_number)
1910: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1911: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1912: ,p_element_changed in out nocopy varchar2
1913: ,p_page_error in out nocopy varchar2
1914: ,p_page_error_msg in out nocopy varchar2
1907: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1908: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
1909: ,p_perf_review_period in varchar2 default to_char(hr_api.g_number)
1910: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
1911: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
1912: ,p_element_changed in out nocopy varchar2
1913: ,p_page_error in out nocopy varchar2
1914: ,p_page_error_msg in out nocopy varchar2
1915: ,p_page_warning in out nocopy varchar2
1930: ,p_flow_mode in varchar2 default null
1931: ,p_rptg_grp_id in varchar2 default null
1932: ,p_plan_id in varchar2 default null
1933: ,p_effective_date_option in varchar2 default null
1934: ,p_title in varchar2 default hr_api.g_varchar2
1935: ,p_default_code_comb_id in varchar2 default to_char(hr_api.g_number)
1936: ,p_set_of_books_id in varchar2 default to_char(hr_api.g_number)
1937: ,p_source_type in varchar2 default hr_api.g_varchar2
1938: ,p_project_title in varchar2 default hr_api.g_varchar2
1931: ,p_rptg_grp_id in varchar2 default null
1932: ,p_plan_id in varchar2 default null
1933: ,p_effective_date_option in varchar2 default null
1934: ,p_title in varchar2 default hr_api.g_varchar2
1935: ,p_default_code_comb_id in varchar2 default to_char(hr_api.g_number)
1936: ,p_set_of_books_id in varchar2 default to_char(hr_api.g_number)
1937: ,p_source_type in varchar2 default hr_api.g_varchar2
1938: ,p_project_title in varchar2 default hr_api.g_varchar2
1939: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1932: ,p_plan_id in varchar2 default null
1933: ,p_effective_date_option in varchar2 default null
1934: ,p_title in varchar2 default hr_api.g_varchar2
1935: ,p_default_code_comb_id in varchar2 default to_char(hr_api.g_number)
1936: ,p_set_of_books_id in varchar2 default to_char(hr_api.g_number)
1937: ,p_source_type in varchar2 default hr_api.g_varchar2
1938: ,p_project_title in varchar2 default hr_api.g_varchar2
1939: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1940: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1933: ,p_effective_date_option in varchar2 default null
1934: ,p_title in varchar2 default hr_api.g_varchar2
1935: ,p_default_code_comb_id in varchar2 default to_char(hr_api.g_number)
1936: ,p_set_of_books_id in varchar2 default to_char(hr_api.g_number)
1937: ,p_source_type in varchar2 default hr_api.g_varchar2
1938: ,p_project_title in varchar2 default hr_api.g_varchar2
1939: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1940: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1941: ,p_vendor_id in varchar2 default to_char(hr_api.g_number)
1934: ,p_title in varchar2 default hr_api.g_varchar2
1935: ,p_default_code_comb_id in varchar2 default to_char(hr_api.g_number)
1936: ,p_set_of_books_id in varchar2 default to_char(hr_api.g_number)
1937: ,p_source_type in varchar2 default hr_api.g_varchar2
1938: ,p_project_title in varchar2 default hr_api.g_varchar2
1939: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1940: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1941: ,p_vendor_id in varchar2 default to_char(hr_api.g_number)
1942: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1935: ,p_default_code_comb_id in varchar2 default to_char(hr_api.g_number)
1936: ,p_set_of_books_id in varchar2 default to_char(hr_api.g_number)
1937: ,p_source_type in varchar2 default hr_api.g_varchar2
1938: ,p_project_title in varchar2 default hr_api.g_varchar2
1939: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1940: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1941: ,p_vendor_id in varchar2 default to_char(hr_api.g_number)
1942: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1943: ,p_grade_ladder_pgm_id in varchar2 default to_char(hr_api.g_number)
1936: ,p_set_of_books_id in varchar2 default to_char(hr_api.g_number)
1937: ,p_source_type in varchar2 default hr_api.g_varchar2
1938: ,p_project_title in varchar2 default hr_api.g_varchar2
1939: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1940: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1941: ,p_vendor_id in varchar2 default to_char(hr_api.g_number)
1942: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1943: ,p_grade_ladder_pgm_id in varchar2 default to_char(hr_api.g_number)
1944: ,p_supervisor_assignment_id in varchar2 default to_char(hr_api.g_number)
1937: ,p_source_type in varchar2 default hr_api.g_varchar2
1938: ,p_project_title in varchar2 default hr_api.g_varchar2
1939: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1940: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1941: ,p_vendor_id in varchar2 default to_char(hr_api.g_number)
1942: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1943: ,p_grade_ladder_pgm_id in varchar2 default to_char(hr_api.g_number)
1944: ,p_supervisor_assignment_id in varchar2 default to_char(hr_api.g_number)
1945: -- GSP changes
1938: ,p_project_title in varchar2 default hr_api.g_varchar2
1939: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1940: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1941: ,p_vendor_id in varchar2 default to_char(hr_api.g_number)
1942: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1943: ,p_grade_ladder_pgm_id in varchar2 default to_char(hr_api.g_number)
1944: ,p_supervisor_assignment_id in varchar2 default to_char(hr_api.g_number)
1945: -- GSP changes
1946: ,p_salary_change_warning in out nocopy varchar2
1939: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
1940: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1941: ,p_vendor_id in varchar2 default to_char(hr_api.g_number)
1942: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1943: ,p_grade_ladder_pgm_id in varchar2 default to_char(hr_api.g_number)
1944: ,p_supervisor_assignment_id in varchar2 default to_char(hr_api.g_number)
1945: -- GSP changes
1946: ,p_salary_change_warning in out nocopy varchar2
1947: ,p_gsp_post_process_warning out nocopy varchar2
1940: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
1941: ,p_vendor_id in varchar2 default to_char(hr_api.g_number)
1942: ,p_assignment_type in varchar2 default hr_api.g_varchar2
1943: ,p_grade_ladder_pgm_id in varchar2 default to_char(hr_api.g_number)
1944: ,p_supervisor_assignment_id in varchar2 default to_char(hr_api.g_number)
1945: -- GSP changes
1946: ,p_salary_change_warning in out nocopy varchar2
1947: ,p_gsp_post_process_warning out nocopy varchar2
1948: ,p_gsp_salary_effective_date out nocopy date
1946: ,p_salary_change_warning in out nocopy varchar2
1947: ,p_gsp_post_process_warning out nocopy varchar2
1948: ,p_gsp_salary_effective_date out nocopy date
1949: -- End of GSP changes
1950: ,p_po_header_id in varchar2 default to_char(hr_api.g_number)
1951: ,p_po_line_id in varchar2 default to_char(hr_api.g_number)
1952: ,p_vendor_site_id in varchar2 default to_char(hr_api.g_number)
1953: ,p_projected_asgn_end in date default g_canonical_date
1954: ) is
1947: ,p_gsp_post_process_warning out nocopy varchar2
1948: ,p_gsp_salary_effective_date out nocopy date
1949: -- End of GSP changes
1950: ,p_po_header_id in varchar2 default to_char(hr_api.g_number)
1951: ,p_po_line_id in varchar2 default to_char(hr_api.g_number)
1952: ,p_vendor_site_id in varchar2 default to_char(hr_api.g_number)
1953: ,p_projected_asgn_end in date default g_canonical_date
1954: ) is
1955: l_proc varchar2(72) := g_package||'process_save';
1948: ,p_gsp_salary_effective_date out nocopy date
1949: -- End of GSP changes
1950: ,p_po_header_id in varchar2 default to_char(hr_api.g_number)
1951: ,p_po_line_id in varchar2 default to_char(hr_api.g_number)
1952: ,p_vendor_site_id in varchar2 default to_char(hr_api.g_number)
1953: ,p_projected_asgn_end in date default g_canonical_date
1954: ) is
1955: l_proc varchar2(72) := g_package||'process_save';
1956: begin
2111: ,p_login_person_id in number
2112: ,p_assignment_id in number
2113: ,p_object_version_number in number
2114: ,p_effective_date in varchar2
2115: ,p_grade_id in number default hr_api.g_number
2116: ,p_position_id in number default hr_api.g_number
2117: ,p_job_id in number default hr_api.g_number
2118: ,p_location_id in number default hr_api.g_number
2119: ,p_special_ceiling_step_id in number default hr_api.g_number
2112: ,p_assignment_id in number
2113: ,p_object_version_number in number
2114: ,p_effective_date in varchar2
2115: ,p_grade_id in number default hr_api.g_number
2116: ,p_position_id in number default hr_api.g_number
2117: ,p_job_id in number default hr_api.g_number
2118: ,p_location_id in number default hr_api.g_number
2119: ,p_special_ceiling_step_id in number default hr_api.g_number
2120: ,p_organization_id in number default hr_api.g_number
2113: ,p_object_version_number in number
2114: ,p_effective_date in varchar2
2115: ,p_grade_id in number default hr_api.g_number
2116: ,p_position_id in number default hr_api.g_number
2117: ,p_job_id in number default hr_api.g_number
2118: ,p_location_id in number default hr_api.g_number
2119: ,p_special_ceiling_step_id in number default hr_api.g_number
2120: ,p_organization_id in number default hr_api.g_number
2121: ,p_employment_category in varchar2 default hr_api.g_varchar2
2114: ,p_effective_date in varchar2
2115: ,p_grade_id in number default hr_api.g_number
2116: ,p_position_id in number default hr_api.g_number
2117: ,p_job_id in number default hr_api.g_number
2118: ,p_location_id in number default hr_api.g_number
2119: ,p_special_ceiling_step_id in number default hr_api.g_number
2120: ,p_organization_id in number default hr_api.g_number
2121: ,p_employment_category in varchar2 default hr_api.g_varchar2
2122: ,p_supervisor_id in number default hr_api.g_number
2115: ,p_grade_id in number default hr_api.g_number
2116: ,p_position_id in number default hr_api.g_number
2117: ,p_job_id in number default hr_api.g_number
2118: ,p_location_id in number default hr_api.g_number
2119: ,p_special_ceiling_step_id in number default hr_api.g_number
2120: ,p_organization_id in number default hr_api.g_number
2121: ,p_employment_category in varchar2 default hr_api.g_varchar2
2122: ,p_supervisor_id in number default hr_api.g_number
2123: ,p_manager_flag in varchar2 default hr_api.g_varchar2
2116: ,p_position_id in number default hr_api.g_number
2117: ,p_job_id in number default hr_api.g_number
2118: ,p_location_id in number default hr_api.g_number
2119: ,p_special_ceiling_step_id in number default hr_api.g_number
2120: ,p_organization_id in number default hr_api.g_number
2121: ,p_employment_category in varchar2 default hr_api.g_varchar2
2122: ,p_supervisor_id in number default hr_api.g_number
2123: ,p_manager_flag in varchar2 default hr_api.g_varchar2
2124: ,p_normal_hours in number default hr_api.g_number
2117: ,p_job_id in number default hr_api.g_number
2118: ,p_location_id in number default hr_api.g_number
2119: ,p_special_ceiling_step_id in number default hr_api.g_number
2120: ,p_organization_id in number default hr_api.g_number
2121: ,p_employment_category in varchar2 default hr_api.g_varchar2
2122: ,p_supervisor_id in number default hr_api.g_number
2123: ,p_manager_flag in varchar2 default hr_api.g_varchar2
2124: ,p_normal_hours in number default hr_api.g_number
2125: ,p_frequency in varchar2 default hr_api.g_varchar2
2118: ,p_location_id in number default hr_api.g_number
2119: ,p_special_ceiling_step_id in number default hr_api.g_number
2120: ,p_organization_id in number default hr_api.g_number
2121: ,p_employment_category in varchar2 default hr_api.g_varchar2
2122: ,p_supervisor_id in number default hr_api.g_number
2123: ,p_manager_flag in varchar2 default hr_api.g_varchar2
2124: ,p_normal_hours in number default hr_api.g_number
2125: ,p_frequency in varchar2 default hr_api.g_varchar2
2126: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
2119: ,p_special_ceiling_step_id in number default hr_api.g_number
2120: ,p_organization_id in number default hr_api.g_number
2121: ,p_employment_category in varchar2 default hr_api.g_varchar2
2122: ,p_supervisor_id in number default hr_api.g_number
2123: ,p_manager_flag in varchar2 default hr_api.g_varchar2
2124: ,p_normal_hours in number default hr_api.g_number
2125: ,p_frequency in varchar2 default hr_api.g_varchar2
2126: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
2127: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
2120: ,p_organization_id in number default hr_api.g_number
2121: ,p_employment_category in varchar2 default hr_api.g_varchar2
2122: ,p_supervisor_id in number default hr_api.g_number
2123: ,p_manager_flag in varchar2 default hr_api.g_varchar2
2124: ,p_normal_hours in number default hr_api.g_number
2125: ,p_frequency in varchar2 default hr_api.g_varchar2
2126: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
2127: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
2128: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
2121: ,p_employment_category in varchar2 default hr_api.g_varchar2
2122: ,p_supervisor_id in number default hr_api.g_number
2123: ,p_manager_flag in varchar2 default hr_api.g_varchar2
2124: ,p_normal_hours in number default hr_api.g_number
2125: ,p_frequency in varchar2 default hr_api.g_varchar2
2126: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
2127: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
2128: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
2129: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
2122: ,p_supervisor_id in number default hr_api.g_number
2123: ,p_manager_flag in varchar2 default hr_api.g_varchar2
2124: ,p_normal_hours in number default hr_api.g_number
2125: ,p_frequency in varchar2 default hr_api.g_varchar2
2126: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
2127: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
2128: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
2129: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
2130: ,p_assignment_status_type_id in number default hr_api.g_number
2123: ,p_manager_flag in varchar2 default hr_api.g_varchar2
2124: ,p_normal_hours in number default hr_api.g_number
2125: ,p_frequency in varchar2 default hr_api.g_varchar2
2126: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
2127: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
2128: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
2129: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
2130: ,p_assignment_status_type_id in number default hr_api.g_number
2131: ,p_change_reason in varchar2 default hr_api.g_varchar2
2124: ,p_normal_hours in number default hr_api.g_number
2125: ,p_frequency in varchar2 default hr_api.g_varchar2
2126: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
2127: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
2128: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
2129: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
2130: ,p_assignment_status_type_id in number default hr_api.g_number
2131: ,p_change_reason in varchar2 default hr_api.g_varchar2
2132: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
2125: ,p_frequency in varchar2 default hr_api.g_varchar2
2126: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
2127: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
2128: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
2129: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
2130: ,p_assignment_status_type_id in number default hr_api.g_number
2131: ,p_change_reason in varchar2 default hr_api.g_varchar2
2132: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
2133: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
2126: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
2127: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
2128: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
2129: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
2130: ,p_assignment_status_type_id in number default hr_api.g_number
2131: ,p_change_reason in varchar2 default hr_api.g_varchar2
2132: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
2133: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
2134: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
2127: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
2128: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
2129: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
2130: ,p_assignment_status_type_id in number default hr_api.g_number
2131: ,p_change_reason in varchar2 default hr_api.g_varchar2
2132: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
2133: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
2134: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
2135: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
2128: ,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
2129: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
2130: ,p_assignment_status_type_id in number default hr_api.g_number
2131: ,p_change_reason in varchar2 default hr_api.g_varchar2
2132: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
2133: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
2134: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
2135: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
2136: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
2129: ,p_labour_union_member_flag in varchar2 default hr_api.g_varchar2
2130: ,p_assignment_status_type_id in number default hr_api.g_number
2131: ,p_change_reason in varchar2 default hr_api.g_varchar2
2132: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
2133: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
2134: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
2135: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
2136: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
2137: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
2130: ,p_assignment_status_type_id in number default hr_api.g_number
2131: ,p_change_reason in varchar2 default hr_api.g_varchar2
2132: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
2133: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
2134: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
2135: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
2136: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
2137: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
2138: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
2131: ,p_change_reason in varchar2 default hr_api.g_varchar2
2132: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
2133: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
2134: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
2135: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
2136: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
2137: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
2138: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
2139: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
2132: ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
2133: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
2134: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
2135: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
2136: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
2137: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
2138: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
2139: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
2140: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
2133: ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
2134: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
2135: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
2136: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
2137: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
2138: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
2139: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
2140: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
2141: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
2134: ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
2135: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
2136: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
2137: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
2138: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
2139: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
2140: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
2141: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
2142: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
2135: ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
2136: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
2137: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
2138: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
2139: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
2140: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
2141: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
2142: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
2143: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
2136: ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
2137: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
2138: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
2139: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
2140: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
2141: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
2142: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
2143: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
2144: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
2137: ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
2138: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
2139: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
2140: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
2141: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
2142: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
2143: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
2144: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
2145: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
2138: ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
2139: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
2140: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
2141: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
2142: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
2143: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
2144: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
2145: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
2146: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
2139: ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
2140: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
2141: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
2142: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
2143: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
2144: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
2145: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
2146: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
2147: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
2140: ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
2141: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
2142: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
2143: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
2144: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
2145: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
2146: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
2147: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
2148: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
2141: ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
2142: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
2143: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
2144: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
2145: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
2146: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
2147: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
2148: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
2149: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
2142: ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
2143: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
2144: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
2145: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
2146: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
2147: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
2148: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
2149: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
2150: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
2143: ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
2144: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
2145: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
2146: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
2147: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
2148: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
2149: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
2150: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
2151: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
2144: ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
2145: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
2146: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
2147: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
2148: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
2149: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
2150: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
2151: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
2152: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
2145: ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
2146: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
2147: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
2148: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
2149: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
2150: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
2151: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
2152: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
2153: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
2146: ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
2147: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
2148: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
2149: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
2150: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
2151: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
2152: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
2153: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
2154: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
2147: ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
2148: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
2149: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
2150: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
2151: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
2152: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
2153: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
2154: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
2155: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
2148: ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
2149: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
2150: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
2151: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
2152: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
2153: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
2154: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
2155: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
2156: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
2149: ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
2150: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
2151: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
2152: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
2153: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
2154: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
2155: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
2156: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
2157: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
2150: ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
2151: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
2152: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
2153: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
2154: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
2155: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
2156: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
2157: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
2158: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
2151: ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
2152: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
2153: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
2154: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
2155: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
2156: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
2157: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
2158: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
2159: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
2152: ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
2153: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
2154: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
2155: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
2156: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
2157: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
2158: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
2159: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
2160: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
2153: ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
2154: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
2155: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
2156: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
2157: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
2158: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
2159: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
2160: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
2161: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
2154: ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
2155: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
2156: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
2157: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
2158: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
2159: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
2160: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
2161: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
2162: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
2155: ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
2156: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
2157: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
2158: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
2159: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
2160: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
2161: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
2162: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
2163: ,p_soft_coding_keyflex_id in number default hr_api.g_number
2156: ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
2157: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
2158: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
2159: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
2160: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
2161: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
2162: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
2163: ,p_soft_coding_keyflex_id in number default hr_api.g_number
2164: ,p_people_group_id in number default hr_api.g_number
2157: ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
2158: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
2159: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
2160: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
2161: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
2162: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
2163: ,p_soft_coding_keyflex_id in number default hr_api.g_number
2164: ,p_people_group_id in number default hr_api.g_number
2165: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
2158: ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
2159: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
2160: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
2161: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
2162: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
2163: ,p_soft_coding_keyflex_id in number default hr_api.g_number
2164: ,p_people_group_id in number default hr_api.g_number
2165: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
2166: ,p_display_pos in varchar2 default hr_api.g_varchar2
2159: ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
2160: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
2161: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
2162: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
2163: ,p_soft_coding_keyflex_id in number default hr_api.g_number
2164: ,p_people_group_id in number default hr_api.g_number
2165: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
2166: ,p_display_pos in varchar2 default hr_api.g_varchar2
2167: ,p_display_org in varchar2 default hr_api.g_varchar2
2160: ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
2161: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
2162: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
2163: ,p_soft_coding_keyflex_id in number default hr_api.g_number
2164: ,p_people_group_id in number default hr_api.g_number
2165: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
2166: ,p_display_pos in varchar2 default hr_api.g_varchar2
2167: ,p_display_org in varchar2 default hr_api.g_varchar2
2168: ,p_display_job in varchar2 default hr_api.g_varchar2
2161: ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
2162: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
2163: ,p_soft_coding_keyflex_id in number default hr_api.g_number
2164: ,p_people_group_id in number default hr_api.g_number
2165: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
2166: ,p_display_pos in varchar2 default hr_api.g_varchar2
2167: ,p_display_org in varchar2 default hr_api.g_varchar2
2168: ,p_display_job in varchar2 default hr_api.g_varchar2
2169: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
2162: ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
2163: ,p_soft_coding_keyflex_id in number default hr_api.g_number
2164: ,p_people_group_id in number default hr_api.g_number
2165: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
2166: ,p_display_pos in varchar2 default hr_api.g_varchar2
2167: ,p_display_org in varchar2 default hr_api.g_varchar2
2168: ,p_display_job in varchar2 default hr_api.g_varchar2
2169: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
2170: ,p_grade_lov in varchar2 default hr_api.g_varchar2
2163: ,p_soft_coding_keyflex_id in number default hr_api.g_number
2164: ,p_people_group_id in number default hr_api.g_number
2165: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
2166: ,p_display_pos in varchar2 default hr_api.g_varchar2
2167: ,p_display_org in varchar2 default hr_api.g_varchar2
2168: ,p_display_job in varchar2 default hr_api.g_varchar2
2169: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
2170: ,p_grade_lov in varchar2 default hr_api.g_varchar2
2171: ,p_approver_id in number default hr_api.g_number
2164: ,p_people_group_id in number default hr_api.g_number
2165: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
2166: ,p_display_pos in varchar2 default hr_api.g_varchar2
2167: ,p_display_org in varchar2 default hr_api.g_varchar2
2168: ,p_display_job in varchar2 default hr_api.g_varchar2
2169: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
2170: ,p_grade_lov in varchar2 default hr_api.g_varchar2
2171: ,p_approver_id in number default hr_api.g_number
2172: ,p_review_proc_call in varchar2
2165: ,p_hrs_last_date in varchar2 default hr_api.g_varchar2
2166: ,p_display_pos in varchar2 default hr_api.g_varchar2
2167: ,p_display_org in varchar2 default hr_api.g_varchar2
2168: ,p_display_job in varchar2 default hr_api.g_varchar2
2169: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
2170: ,p_grade_lov in varchar2 default hr_api.g_varchar2
2171: ,p_approver_id in number default hr_api.g_number
2172: ,p_review_proc_call in varchar2
2173: ,p_display_grade in varchar2 default hr_api.g_varchar2
2166: ,p_display_pos in varchar2 default hr_api.g_varchar2
2167: ,p_display_org in varchar2 default hr_api.g_varchar2
2168: ,p_display_job in varchar2 default hr_api.g_varchar2
2169: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
2170: ,p_grade_lov in varchar2 default hr_api.g_varchar2
2171: ,p_approver_id in number default hr_api.g_number
2172: ,p_review_proc_call in varchar2
2173: ,p_display_grade in varchar2 default hr_api.g_varchar2
2174: ,p_contract_id in number default hr_api.g_number
2167: ,p_display_org in varchar2 default hr_api.g_varchar2
2168: ,p_display_job in varchar2 default hr_api.g_varchar2
2169: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
2170: ,p_grade_lov in varchar2 default hr_api.g_varchar2
2171: ,p_approver_id in number default hr_api.g_number
2172: ,p_review_proc_call in varchar2
2173: ,p_display_grade in varchar2 default hr_api.g_varchar2
2174: ,p_contract_id in number default hr_api.g_number
2175: ,p_establishment_id in number default hr_api.g_number
2169: ,p_display_ass_status in varchar2 default hr_api.g_varchar2
2170: ,p_grade_lov in varchar2 default hr_api.g_varchar2
2171: ,p_approver_id in number default hr_api.g_number
2172: ,p_review_proc_call in varchar2
2173: ,p_display_grade in varchar2 default hr_api.g_varchar2
2174: ,p_contract_id in number default hr_api.g_number
2175: ,p_establishment_id in number default hr_api.g_number
2176: ,p_cagr_grade_def_id in number default hr_api.g_number
2177: ,p_collective_agreement_id in number default hr_api.g_number
2170: ,p_grade_lov in varchar2 default hr_api.g_varchar2
2171: ,p_approver_id in number default hr_api.g_number
2172: ,p_review_proc_call in varchar2
2173: ,p_display_grade in varchar2 default hr_api.g_varchar2
2174: ,p_contract_id in number default hr_api.g_number
2175: ,p_establishment_id in number default hr_api.g_number
2176: ,p_cagr_grade_def_id in number default hr_api.g_number
2177: ,p_collective_agreement_id in number default hr_api.g_number
2178: ,p_cagr_id_flex_num in number default hr_api.g_number
2171: ,p_approver_id in number default hr_api.g_number
2172: ,p_review_proc_call in varchar2
2173: ,p_display_grade in varchar2 default hr_api.g_varchar2
2174: ,p_contract_id in number default hr_api.g_number
2175: ,p_establishment_id in number default hr_api.g_number
2176: ,p_cagr_grade_def_id in number default hr_api.g_number
2177: ,p_collective_agreement_id in number default hr_api.g_number
2178: ,p_cagr_id_flex_num in number default hr_api.g_number
2179: ,p_payroll_id in number default hr_api.g_number
2172: ,p_review_proc_call in varchar2
2173: ,p_display_grade in varchar2 default hr_api.g_varchar2
2174: ,p_contract_id in number default hr_api.g_number
2175: ,p_establishment_id in number default hr_api.g_number
2176: ,p_cagr_grade_def_id in number default hr_api.g_number
2177: ,p_collective_agreement_id in number default hr_api.g_number
2178: ,p_cagr_id_flex_num in number default hr_api.g_number
2179: ,p_payroll_id in number default hr_api.g_number
2180: ,p_pay_basis_id in number default hr_api.g_number
2173: ,p_display_grade in varchar2 default hr_api.g_varchar2
2174: ,p_contract_id in number default hr_api.g_number
2175: ,p_establishment_id in number default hr_api.g_number
2176: ,p_cagr_grade_def_id in number default hr_api.g_number
2177: ,p_collective_agreement_id in number default hr_api.g_number
2178: ,p_cagr_id_flex_num in number default hr_api.g_number
2179: ,p_payroll_id in number default hr_api.g_number
2180: ,p_pay_basis_id in number default hr_api.g_number
2181: ,p_sal_review_period in number default hr_api.g_number
2174: ,p_contract_id in number default hr_api.g_number
2175: ,p_establishment_id in number default hr_api.g_number
2176: ,p_cagr_grade_def_id in number default hr_api.g_number
2177: ,p_collective_agreement_id in number default hr_api.g_number
2178: ,p_cagr_id_flex_num in number default hr_api.g_number
2179: ,p_payroll_id in number default hr_api.g_number
2180: ,p_pay_basis_id in number default hr_api.g_number
2181: ,p_sal_review_period in number default hr_api.g_number
2182: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
2175: ,p_establishment_id in number default hr_api.g_number
2176: ,p_cagr_grade_def_id in number default hr_api.g_number
2177: ,p_collective_agreement_id in number default hr_api.g_number
2178: ,p_cagr_id_flex_num in number default hr_api.g_number
2179: ,p_payroll_id in number default hr_api.g_number
2180: ,p_pay_basis_id in number default hr_api.g_number
2181: ,p_sal_review_period in number default hr_api.g_number
2182: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
2183: ,p_date_probation_end in date default hr_api.g_date
2176: ,p_cagr_grade_def_id in number default hr_api.g_number
2177: ,p_collective_agreement_id in number default hr_api.g_number
2178: ,p_cagr_id_flex_num in number default hr_api.g_number
2179: ,p_payroll_id in number default hr_api.g_number
2180: ,p_pay_basis_id in number default hr_api.g_number
2181: ,p_sal_review_period in number default hr_api.g_number
2182: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
2183: ,p_date_probation_end in date default hr_api.g_date
2184: ,p_probation_period in number default hr_api.g_number
2177: ,p_collective_agreement_id in number default hr_api.g_number
2178: ,p_cagr_id_flex_num in number default hr_api.g_number
2179: ,p_payroll_id in number default hr_api.g_number
2180: ,p_pay_basis_id in number default hr_api.g_number
2181: ,p_sal_review_period in number default hr_api.g_number
2182: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
2183: ,p_date_probation_end in date default hr_api.g_date
2184: ,p_probation_period in number default hr_api.g_number
2185: ,p_probation_unit in varchar2 default hr_api.g_varchar2
2178: ,p_cagr_id_flex_num in number default hr_api.g_number
2179: ,p_payroll_id in number default hr_api.g_number
2180: ,p_pay_basis_id in number default hr_api.g_number
2181: ,p_sal_review_period in number default hr_api.g_number
2182: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
2183: ,p_date_probation_end in date default hr_api.g_date
2184: ,p_probation_period in number default hr_api.g_number
2185: ,p_probation_unit in varchar2 default hr_api.g_varchar2
2186: ,p_notice_period in number default hr_api.g_number
2179: ,p_payroll_id in number default hr_api.g_number
2180: ,p_pay_basis_id in number default hr_api.g_number
2181: ,p_sal_review_period in number default hr_api.g_number
2182: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
2183: ,p_date_probation_end in date default hr_api.g_date
2184: ,p_probation_period in number default hr_api.g_number
2185: ,p_probation_unit in varchar2 default hr_api.g_varchar2
2186: ,p_notice_period in number default hr_api.g_number
2187: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
2180: ,p_pay_basis_id in number default hr_api.g_number
2181: ,p_sal_review_period in number default hr_api.g_number
2182: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
2183: ,p_date_probation_end in date default hr_api.g_date
2184: ,p_probation_period in number default hr_api.g_number
2185: ,p_probation_unit in varchar2 default hr_api.g_varchar2
2186: ,p_notice_period in number default hr_api.g_number
2187: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
2188: ,p_employee_category in varchar2 default hr_api.g_varchar2
2181: ,p_sal_review_period in number default hr_api.g_number
2182: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
2183: ,p_date_probation_end in date default hr_api.g_date
2184: ,p_probation_period in number default hr_api.g_number
2185: ,p_probation_unit in varchar2 default hr_api.g_varchar2
2186: ,p_notice_period in number default hr_api.g_number
2187: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
2188: ,p_employee_category in varchar2 default hr_api.g_varchar2
2189: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2182: ,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
2183: ,p_date_probation_end in date default hr_api.g_date
2184: ,p_probation_period in number default hr_api.g_number
2185: ,p_probation_unit in varchar2 default hr_api.g_varchar2
2186: ,p_notice_period in number default hr_api.g_number
2187: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
2188: ,p_employee_category in varchar2 default hr_api.g_varchar2
2189: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2190: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
2183: ,p_date_probation_end in date default hr_api.g_date
2184: ,p_probation_period in number default hr_api.g_number
2185: ,p_probation_unit in varchar2 default hr_api.g_varchar2
2186: ,p_notice_period in number default hr_api.g_number
2187: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
2188: ,p_employee_category in varchar2 default hr_api.g_varchar2
2189: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2190: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
2191: ,p_perf_review_period in number default hr_api.g_number
2184: ,p_probation_period in number default hr_api.g_number
2185: ,p_probation_unit in varchar2 default hr_api.g_varchar2
2186: ,p_notice_period in number default hr_api.g_number
2187: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
2188: ,p_employee_category in varchar2 default hr_api.g_varchar2
2189: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2190: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
2191: ,p_perf_review_period in number default hr_api.g_number
2192: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
2185: ,p_probation_unit in varchar2 default hr_api.g_varchar2
2186: ,p_notice_period in number default hr_api.g_number
2187: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
2188: ,p_employee_category in varchar2 default hr_api.g_varchar2
2189: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2190: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
2191: ,p_perf_review_period in number default hr_api.g_number
2192: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
2193: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
2186: ,p_notice_period in number default hr_api.g_number
2187: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
2188: ,p_employee_category in varchar2 default hr_api.g_varchar2
2189: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2190: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
2191: ,p_perf_review_period in number default hr_api.g_number
2192: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
2193: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
2194: ,p_element_changed in out nocopy varchar2
2187: ,p_notice_period_uom in varchar2 default hr_api.g_varchar2
2188: ,p_employee_category in varchar2 default hr_api.g_varchar2
2189: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2190: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
2191: ,p_perf_review_period in number default hr_api.g_number
2192: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
2193: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
2194: ,p_element_changed in out nocopy varchar2
2195: ,p_page_error in out nocopy varchar2
2188: ,p_employee_category in varchar2 default hr_api.g_varchar2
2189: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2190: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
2191: ,p_perf_review_period in number default hr_api.g_number
2192: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
2193: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
2194: ,p_element_changed in out nocopy varchar2
2195: ,p_page_error in out nocopy varchar2
2196: ,p_page_error_msg in out nocopy varchar2
2189: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2190: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
2191: ,p_perf_review_period in number default hr_api.g_number
2192: ,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
2193: ,p_internal_address_line in varchar2 default hr_api.g_varchar2
2194: ,p_element_changed in out nocopy varchar2
2195: ,p_page_error in out nocopy varchar2
2196: ,p_page_error_msg in out nocopy varchar2
2197: ,p_page_warning in out nocopy varchar2
2212: ,p_flow_mode in varchar2 default null
2213: ,p_rptg_grp_id in varchar2 default null
2214: ,p_plan_id in varchar2 default null
2215: ,p_effective_date_option in varchar2 default null
2216: ,p_title in varchar2 default hr_api.g_varchar2
2217: ,p_default_code_comb_id in number default hr_api.g_number
2218: ,p_set_of_books_id in number default hr_api.g_number
2219: ,p_source_type in varchar2 default hr_api.g_varchar2
2220: ,p_project_title in varchar2 default hr_api.g_varchar2
2213: ,p_rptg_grp_id in varchar2 default null
2214: ,p_plan_id in varchar2 default null
2215: ,p_effective_date_option in varchar2 default null
2216: ,p_title in varchar2 default hr_api.g_varchar2
2217: ,p_default_code_comb_id in number default hr_api.g_number
2218: ,p_set_of_books_id in number default hr_api.g_number
2219: ,p_source_type in varchar2 default hr_api.g_varchar2
2220: ,p_project_title in varchar2 default hr_api.g_varchar2
2221: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
2214: ,p_plan_id in varchar2 default null
2215: ,p_effective_date_option in varchar2 default null
2216: ,p_title in varchar2 default hr_api.g_varchar2
2217: ,p_default_code_comb_id in number default hr_api.g_number
2218: ,p_set_of_books_id in number default hr_api.g_number
2219: ,p_source_type in varchar2 default hr_api.g_varchar2
2220: ,p_project_title in varchar2 default hr_api.g_varchar2
2221: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
2222: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
2215: ,p_effective_date_option in varchar2 default null
2216: ,p_title in varchar2 default hr_api.g_varchar2
2217: ,p_default_code_comb_id in number default hr_api.g_number
2218: ,p_set_of_books_id in number default hr_api.g_number
2219: ,p_source_type in varchar2 default hr_api.g_varchar2
2220: ,p_project_title in varchar2 default hr_api.g_varchar2
2221: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
2222: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
2223: ,p_vendor_id in number default hr_api.g_number
2216: ,p_title in varchar2 default hr_api.g_varchar2
2217: ,p_default_code_comb_id in number default hr_api.g_number
2218: ,p_set_of_books_id in number default hr_api.g_number
2219: ,p_source_type in varchar2 default hr_api.g_varchar2
2220: ,p_project_title in varchar2 default hr_api.g_varchar2
2221: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
2222: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
2223: ,p_vendor_id in number default hr_api.g_number
2224: ,p_assignment_type in varchar2 default hr_api.g_varchar2
2217: ,p_default_code_comb_id in number default hr_api.g_number
2218: ,p_set_of_books_id in number default hr_api.g_number
2219: ,p_source_type in varchar2 default hr_api.g_varchar2
2220: ,p_project_title in varchar2 default hr_api.g_varchar2
2221: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
2222: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
2223: ,p_vendor_id in number default hr_api.g_number
2224: ,p_assignment_type in varchar2 default hr_api.g_varchar2
2225: ,p_grade_ladder_pgm_id in number default hr_api.g_number
2218: ,p_set_of_books_id in number default hr_api.g_number
2219: ,p_source_type in varchar2 default hr_api.g_varchar2
2220: ,p_project_title in varchar2 default hr_api.g_varchar2
2221: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
2222: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
2223: ,p_vendor_id in number default hr_api.g_number
2224: ,p_assignment_type in varchar2 default hr_api.g_varchar2
2225: ,p_grade_ladder_pgm_id in number default hr_api.g_number
2226: ,p_supervisor_assignment_id in number default hr_api.g_number
2219: ,p_source_type in varchar2 default hr_api.g_varchar2
2220: ,p_project_title in varchar2 default hr_api.g_varchar2
2221: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
2222: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
2223: ,p_vendor_id in number default hr_api.g_number
2224: ,p_assignment_type in varchar2 default hr_api.g_varchar2
2225: ,p_grade_ladder_pgm_id in number default hr_api.g_number
2226: ,p_supervisor_assignment_id in number default hr_api.g_number
2227: -- GSP change
2220: ,p_project_title in varchar2 default hr_api.g_varchar2
2221: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
2222: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
2223: ,p_vendor_id in number default hr_api.g_number
2224: ,p_assignment_type in varchar2 default hr_api.g_varchar2
2225: ,p_grade_ladder_pgm_id in number default hr_api.g_number
2226: ,p_supervisor_assignment_id in number default hr_api.g_number
2227: -- GSP change
2228: ,p_salary_change_warning in out nocopy varchar2
2221: ,p_vendor_assignment_number in varchar2 default hr_api.g_varchar2
2222: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
2223: ,p_vendor_id in number default hr_api.g_number
2224: ,p_assignment_type in varchar2 default hr_api.g_varchar2
2225: ,p_grade_ladder_pgm_id in number default hr_api.g_number
2226: ,p_supervisor_assignment_id in number default hr_api.g_number
2227: -- GSP change
2228: ,p_salary_change_warning in out nocopy varchar2
2229: ,p_gsp_post_process_warning out nocopy varchar2
2222: ,p_vendor_employee_number in varchar2 default hr_api.g_varchar2
2223: ,p_vendor_id in number default hr_api.g_number
2224: ,p_assignment_type in varchar2 default hr_api.g_varchar2
2225: ,p_grade_ladder_pgm_id in number default hr_api.g_number
2226: ,p_supervisor_assignment_id in number default hr_api.g_number
2227: -- GSP change
2228: ,p_salary_change_warning in out nocopy varchar2
2229: ,p_gsp_post_process_warning out nocopy varchar2
2230: ,p_gsp_salary_effective_date out nocopy date
2228: ,p_salary_change_warning in out nocopy varchar2
2229: ,p_gsp_post_process_warning out nocopy varchar2
2230: ,p_gsp_salary_effective_date out nocopy date
2231: -- End of GSP change
2232: ,p_po_header_id in number default hr_api.g_number
2233: ,p_po_line_id in number default hr_api.g_number
2234: ,p_vendor_site_id in number default hr_api.g_number
2235: ,p_proj_asgn_end in date default g_canonical_date
2236:
2229: ,p_gsp_post_process_warning out nocopy varchar2
2230: ,p_gsp_salary_effective_date out nocopy date
2231: -- End of GSP change
2232: ,p_po_header_id in number default hr_api.g_number
2233: ,p_po_line_id in number default hr_api.g_number
2234: ,p_vendor_site_id in number default hr_api.g_number
2235: ,p_proj_asgn_end in date default g_canonical_date
2236:
2237: ) is
2230: ,p_gsp_salary_effective_date out nocopy date
2231: -- End of GSP change
2232: ,p_po_header_id in number default hr_api.g_number
2233: ,p_po_line_id in number default hr_api.g_number
2234: ,p_vendor_site_id in number default hr_api.g_number
2235: ,p_proj_asgn_end in date default g_canonical_date
2236:
2237: ) is
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2236:
2237: ) is
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_person_id per_all_assignments_f.person_id%TYPE;
2240: l_item_type hr_api_transaction_steps.item_type%TYPE;
2241: l_item_key hr_api_transaction_steps.item_key%TYPE;
2242: l_activity_id hr_api_transaction_steps.activity_id%TYPE;
2243: l_effective_date date;
2244: l_effective_start_date date;
2237: ) is
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_person_id per_all_assignments_f.person_id%TYPE;
2240: l_item_type hr_api_transaction_steps.item_type%TYPE;
2241: l_item_key hr_api_transaction_steps.item_key%TYPE;
2242: l_activity_id hr_api_transaction_steps.activity_id%TYPE;
2243: l_effective_date date;
2244: l_effective_start_date date;
2245: l_effective_end_date date;
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_person_id per_all_assignments_f.person_id%TYPE;
2240: l_item_type hr_api_transaction_steps.item_type%TYPE;
2241: l_item_key hr_api_transaction_steps.item_key%TYPE;
2242: l_activity_id hr_api_transaction_steps.activity_id%TYPE;
2243: l_effective_date date;
2244: l_effective_start_date date;
2245: l_effective_end_date date;
2246: l_transaction_id number;
2408: from per_all_assignments_f
2409: where assignment_id = p_assignment_id;
2410:
2411: cursor process_order(l_item_type in varchar2,l_item_key in varchar2) is
2412: select processing_order from hr_api_transaction_steps where
2413: item_type=l_item_type and item_key=l_item_key and api_name='HR_SUPERVISOR_SS.PROCESS_API';
2414:
2415: cursor pay_step(l_item_type in varchar2,l_item_key in varchar2) is --bug6405208
2416: select transaction_step_id,activity_id from hr_api_transaction_steps where
2412: select processing_order from hr_api_transaction_steps where
2413: item_type=l_item_type and item_key=l_item_key and api_name='HR_SUPERVISOR_SS.PROCESS_API';
2414:
2415: cursor pay_step(l_item_type in varchar2,l_item_key in varchar2) is --bug6405208
2416: select transaction_step_id,activity_id from hr_api_transaction_steps where
2417: item_type=l_item_type and item_key=l_item_key and api_name='HR_PAY_RATE_SS.PROCESS_API';
2418:
2419: cursor step_grade_step(l_item_type in varchar2,l_item_key in varchar2) is
2420: select null from hr_api_transaction_steps where
2416: select transaction_step_id,activity_id from hr_api_transaction_steps where
2417: item_type=l_item_type and item_key=l_item_key and api_name='HR_PAY_RATE_SS.PROCESS_API';
2418:
2419: cursor step_grade_step(l_item_type in varchar2,l_item_key in varchar2) is
2420: select null from hr_api_transaction_steps where
2421: item_type=l_item_type and item_key=l_item_key and api_name='HR_PROCESS_ASSIGNMENT_STEP_SS.PROCESS_API';
2422:
2423: --
2424: begin
2446: open csr_assignment;
2447: fetch csr_assignment into l_assignment_id;
2448: if csr_assignment%notfound then
2449: hr_utility.set_location(' if csr_assignment%notfound then:'||l_proc,20);
2450: hr_api.legislation_hooks('DISABLE'); -- bug 6405208
2451: hr_new_user_reg_ss.processNewUserTransaction
2452: (WfItemType => l_item_type
2453: ,WfItemKey => l_item_key
2454: ,PersonId => l_person_id
2452: (WfItemType => l_item_type
2453: ,WfItemKey => l_item_key
2454: ,PersonId => l_person_id
2455: ,AssignmentId => l_assignment_id);
2456: hr_api.legislation_hooks('ENABLE'); -- bug 6405208
2457: end if;
2458: close csr_assignment;
2459: end if;
2460: --
2679: l_assignment_rec.business_group_id :=
2680: l_old_assignment_rec.business_group_id;
2681: l_assignment_rec.person_id :=
2682: l_old_assignment_rec.person_id;
2683: if (p_grade_id = hr_api.g_number) then
2684: l_assignment_rec.grade_id := l_old_assignment_rec.grade_id;
2685: if nvl(l_old_assignment_rec.grade_id, hr_api.g_number)
2686: <> nvl(l_db_assignment_rec.grade_id, hr_api.g_number)
2687: then
2681: l_assignment_rec.person_id :=
2682: l_old_assignment_rec.person_id;
2683: if (p_grade_id = hr_api.g_number) then
2684: l_assignment_rec.grade_id := l_old_assignment_rec.grade_id;
2685: if nvl(l_old_assignment_rec.grade_id, hr_api.g_number)
2686: <> nvl(l_db_assignment_rec.grade_id, hr_api.g_number)
2687: then
2688: others_changed:=TRUE;
2689: end if;
2682: l_old_assignment_rec.person_id;
2683: if (p_grade_id = hr_api.g_number) then
2684: l_assignment_rec.grade_id := l_old_assignment_rec.grade_id;
2685: if nvl(l_old_assignment_rec.grade_id, hr_api.g_number)
2686: <> nvl(l_db_assignment_rec.grade_id, hr_api.g_number)
2687: then
2688: others_changed:=TRUE;
2689: end if;
2690: else
2693: i_changed:=TRUE;
2694: end if;
2695: end if;
2696:
2697: if (p_position_id = hr_api.g_number) then
2698: l_assignment_rec.position_id :=
2699: l_old_assignment_rec.position_id;
2700: if nvl(l_old_assignment_rec.position_id, hr_api.g_number)
2701: <> nvl(l_db_assignment_rec.position_id, hr_api.g_number)
2696:
2697: if (p_position_id = hr_api.g_number) then
2698: l_assignment_rec.position_id :=
2699: l_old_assignment_rec.position_id;
2700: if nvl(l_old_assignment_rec.position_id, hr_api.g_number)
2701: <> nvl(l_db_assignment_rec.position_id, hr_api.g_number)
2702: then
2703: others_changed:=TRUE;
2704: end if;
2697: if (p_position_id = hr_api.g_number) then
2698: l_assignment_rec.position_id :=
2699: l_old_assignment_rec.position_id;
2700: if nvl(l_old_assignment_rec.position_id, hr_api.g_number)
2701: <> nvl(l_db_assignment_rec.position_id, hr_api.g_number)
2702: then
2703: others_changed:=TRUE;
2704: end if;
2705: else
2709: i_changed:=TRUE;
2710: end if;
2711: end if;
2712:
2713: if (p_job_id = hr_api.g_number) then
2714: l_assignment_rec.job_id :=
2715: l_old_assignment_rec.job_id;
2716: if nvl(l_old_assignment_rec.job_id, hr_api.g_number)
2717: <> nvl(l_db_assignment_rec.job_id, hr_api.g_number)
2712:
2713: if (p_job_id = hr_api.g_number) then
2714: l_assignment_rec.job_id :=
2715: l_old_assignment_rec.job_id;
2716: if nvl(l_old_assignment_rec.job_id, hr_api.g_number)
2717: <> nvl(l_db_assignment_rec.job_id, hr_api.g_number)
2718: then
2719: others_changed:=TRUE;
2720: end if;
2713: if (p_job_id = hr_api.g_number) then
2714: l_assignment_rec.job_id :=
2715: l_old_assignment_rec.job_id;
2716: if nvl(l_old_assignment_rec.job_id, hr_api.g_number)
2717: <> nvl(l_db_assignment_rec.job_id, hr_api.g_number)
2718: then
2719: others_changed:=TRUE;
2720: end if;
2721: else
2724: i_changed:=TRUE;
2725: end if;
2726: end if;
2727:
2728: if (p_location_id = hr_api.g_number) then
2729: l_assignment_rec.location_id :=
2730: l_old_assignment_rec.location_id;
2731: if nvl(l_old_assignment_rec.location_id, hr_api.g_number)
2732: <> nvl(l_db_assignment_rec.location_id, hr_api.g_number)
2727:
2728: if (p_location_id = hr_api.g_number) then
2729: l_assignment_rec.location_id :=
2730: l_old_assignment_rec.location_id;
2731: if nvl(l_old_assignment_rec.location_id, hr_api.g_number)
2732: <> nvl(l_db_assignment_rec.location_id, hr_api.g_number)
2733: then
2734: others_changed:=TRUE;
2735: end if;
2728: if (p_location_id = hr_api.g_number) then
2729: l_assignment_rec.location_id :=
2730: l_old_assignment_rec.location_id;
2731: if nvl(l_old_assignment_rec.location_id, hr_api.g_number)
2732: <> nvl(l_db_assignment_rec.location_id, hr_api.g_number)
2733: then
2734: others_changed:=TRUE;
2735: end if;
2736: else
2740: i_changed:=TRUE;
2741: end if;
2742: end if;
2743:
2744: if (p_supervisor_id = hr_api.g_number) then
2745: l_assignment_rec.supervisor_id :=
2746: l_old_assignment_rec.supervisor_id;
2747: if nvl(l_old_assignment_rec.supervisor_id, hr_api.g_number)
2748: <> nvl(l_db_assignment_rec.supervisor_id, hr_api.g_number)
2743:
2744: if (p_supervisor_id = hr_api.g_number) then
2745: l_assignment_rec.supervisor_id :=
2746: l_old_assignment_rec.supervisor_id;
2747: if nvl(l_old_assignment_rec.supervisor_id, hr_api.g_number)
2748: <> nvl(l_db_assignment_rec.supervisor_id, hr_api.g_number)
2749: then
2750: others_changed:=TRUE;
2751: end if;
2744: if (p_supervisor_id = hr_api.g_number) then
2745: l_assignment_rec.supervisor_id :=
2746: l_old_assignment_rec.supervisor_id;
2747: if nvl(l_old_assignment_rec.supervisor_id, hr_api.g_number)
2748: <> nvl(l_db_assignment_rec.supervisor_id, hr_api.g_number)
2749: then
2750: others_changed:=TRUE;
2751: end if;
2752: else
2756: i_changed:=TRUE;
2757: end if;
2758: end if;
2759:
2760: if (p_special_ceiling_step_id = hr_api.g_number) then
2761: l_assignment_rec.special_ceiling_step_id :=
2762: l_old_assignment_rec.special_ceiling_step_id;
2763: if nvl(l_old_assignment_rec.special_ceiling_step_id, hr_api.g_number)
2764: <> nvl(l_db_assignment_rec.special_ceiling_step_id, hr_api.g_number)
2759:
2760: if (p_special_ceiling_step_id = hr_api.g_number) then
2761: l_assignment_rec.special_ceiling_step_id :=
2762: l_old_assignment_rec.special_ceiling_step_id;
2763: if nvl(l_old_assignment_rec.special_ceiling_step_id, hr_api.g_number)
2764: <> nvl(l_db_assignment_rec.special_ceiling_step_id, hr_api.g_number)
2765: then
2766: others_changed:=TRUE;
2767: end if;
2760: if (p_special_ceiling_step_id = hr_api.g_number) then
2761: l_assignment_rec.special_ceiling_step_id :=
2762: l_old_assignment_rec.special_ceiling_step_id;
2763: if nvl(l_old_assignment_rec.special_ceiling_step_id, hr_api.g_number)
2764: <> nvl(l_db_assignment_rec.special_ceiling_step_id, hr_api.g_number)
2765: then
2766: others_changed:=TRUE;
2767: end if;
2768: else
2773: i_changed:=TRUE;
2774: end if;
2775: end if;
2776:
2777: if (p_organization_id = hr_api.g_number) then
2778: l_assignment_rec.organization_id :=
2779: l_old_assignment_rec.organization_id;
2780: if nvl(l_old_assignment_rec.organization_id, hr_api.g_number)
2781: <> nvl(l_db_assignment_rec.organization_id, hr_api.g_number)
2776:
2777: if (p_organization_id = hr_api.g_number) then
2778: l_assignment_rec.organization_id :=
2779: l_old_assignment_rec.organization_id;
2780: if nvl(l_old_assignment_rec.organization_id, hr_api.g_number)
2781: <> nvl(l_db_assignment_rec.organization_id, hr_api.g_number)
2782: then
2783: others_changed:=TRUE;
2784: end if;
2777: if (p_organization_id = hr_api.g_number) then
2778: l_assignment_rec.organization_id :=
2779: l_old_assignment_rec.organization_id;
2780: if nvl(l_old_assignment_rec.organization_id, hr_api.g_number)
2781: <> nvl(l_db_assignment_rec.organization_id, hr_api.g_number)
2782: then
2783: others_changed:=TRUE;
2784: end if;
2785: else
2790: i_changed:=TRUE;
2791: end if;
2792: end if;
2793:
2794: if (p_employment_category = hr_api.g_varchar2) then
2795: l_assignment_rec.employment_category :=
2796: l_old_assignment_rec.employment_category;
2797: if nvl(l_old_assignment_rec.employment_category, hr_api.g_varchar2)
2798: <> nvl(l_db_assignment_rec.employment_category, hr_api.g_varchar2)
2793:
2794: if (p_employment_category = hr_api.g_varchar2) then
2795: l_assignment_rec.employment_category :=
2796: l_old_assignment_rec.employment_category;
2797: if nvl(l_old_assignment_rec.employment_category, hr_api.g_varchar2)
2798: <> nvl(l_db_assignment_rec.employment_category, hr_api.g_varchar2)
2799: then
2800: others_changed:=TRUE;
2801: end if;
2794: if (p_employment_category = hr_api.g_varchar2) then
2795: l_assignment_rec.employment_category :=
2796: l_old_assignment_rec.employment_category;
2797: if nvl(l_old_assignment_rec.employment_category, hr_api.g_varchar2)
2798: <> nvl(l_db_assignment_rec.employment_category, hr_api.g_varchar2)
2799: then
2800: others_changed:=TRUE;
2801: end if;
2802: else
2800: others_changed:=TRUE;
2801: end if;
2802: else
2803: l_assignment_rec.employment_category := p_employment_category;
2804: if (nvl(p_employment_category, hr_api.g_varchar2) <>
2805: nvl(l_db_assignment_rec.employment_category, hr_api.g_varchar2))
2806: then
2807: i_changed:=TRUE;
2808: end if;
2801: end if;
2802: else
2803: l_assignment_rec.employment_category := p_employment_category;
2804: if (nvl(p_employment_category, hr_api.g_varchar2) <>
2805: nvl(l_db_assignment_rec.employment_category, hr_api.g_varchar2))
2806: then
2807: i_changed:=TRUE;
2808: end if;
2809: end if;
2807: i_changed:=TRUE;
2808: end if;
2809: end if;
2810:
2811: if (p_manager_flag = hr_api.g_varchar2) then
2812: l_assignment_rec.manager_flag :=
2813: l_old_assignment_rec.manager_flag;
2814: if nvl(l_old_assignment_rec.manager_flag, hr_api.g_varchar2)
2815: <> nvl(l_db_assignment_rec.manager_flag, hr_api.g_varchar2)
2810:
2811: if (p_manager_flag = hr_api.g_varchar2) then
2812: l_assignment_rec.manager_flag :=
2813: l_old_assignment_rec.manager_flag;
2814: if nvl(l_old_assignment_rec.manager_flag, hr_api.g_varchar2)
2815: <> nvl(l_db_assignment_rec.manager_flag, hr_api.g_varchar2)
2816: then
2817: others_changed:=TRUE;
2818: end if;
2811: if (p_manager_flag = hr_api.g_varchar2) then
2812: l_assignment_rec.manager_flag :=
2813: l_old_assignment_rec.manager_flag;
2814: if nvl(l_old_assignment_rec.manager_flag, hr_api.g_varchar2)
2815: <> nvl(l_db_assignment_rec.manager_flag, hr_api.g_varchar2)
2816: then
2817: others_changed:=TRUE;
2818: end if;
2819: else
2817: others_changed:=TRUE;
2818: end if;
2819: else
2820: l_assignment_rec.manager_flag := p_manager_flag;
2821: if (nvl(p_manager_flag, hr_api.g_varchar2) <>
2822: nvl(l_db_assignment_rec.manager_flag, hr_api.g_varchar2))
2823: then
2824: i_changed:=TRUE;
2825: end if;
2818: end if;
2819: else
2820: l_assignment_rec.manager_flag := p_manager_flag;
2821: if (nvl(p_manager_flag, hr_api.g_varchar2) <>
2822: nvl(l_db_assignment_rec.manager_flag, hr_api.g_varchar2))
2823: then
2824: i_changed:=TRUE;
2825: end if;
2826: end if;
2824: i_changed:=TRUE;
2825: end if;
2826: end if;
2827:
2828: if (p_frequency = hr_api.g_varchar2) then
2829: l_assignment_rec.frequency :=
2830: l_old_assignment_rec.frequency;
2831: if nvl(l_old_assignment_rec.frequency, hr_api.g_varchar2)
2832: <> nvl(l_db_assignment_rec.frequency, hr_api.g_varchar2)
2827:
2828: if (p_frequency = hr_api.g_varchar2) then
2829: l_assignment_rec.frequency :=
2830: l_old_assignment_rec.frequency;
2831: if nvl(l_old_assignment_rec.frequency, hr_api.g_varchar2)
2832: <> nvl(l_db_assignment_rec.frequency, hr_api.g_varchar2)
2833: then
2834: others_changed:=TRUE;
2835: end if;
2828: if (p_frequency = hr_api.g_varchar2) then
2829: l_assignment_rec.frequency :=
2830: l_old_assignment_rec.frequency;
2831: if nvl(l_old_assignment_rec.frequency, hr_api.g_varchar2)
2832: <> nvl(l_db_assignment_rec.frequency, hr_api.g_varchar2)
2833: then
2834: others_changed:=TRUE;
2835: end if;
2836: else
2834: others_changed:=TRUE;
2835: end if;
2836: else
2837: l_assignment_rec.frequency := p_frequency;
2838: if (nvl(p_frequency, hr_api.g_varchar2) <>
2839: nvl(l_db_assignment_rec.frequency, hr_api.g_varchar2))
2840: then
2841: i_changed:=TRUE;
2842: end if;
2835: end if;
2836: else
2837: l_assignment_rec.frequency := p_frequency;
2838: if (nvl(p_frequency, hr_api.g_varchar2) <>
2839: nvl(l_db_assignment_rec.frequency, hr_api.g_varchar2))
2840: then
2841: i_changed:=TRUE;
2842: end if;
2843: end if;
2841: i_changed:=TRUE;
2842: end if;
2843: end if;
2844:
2845: if (p_normal_hours = hr_api.g_number) then
2846: l_assignment_rec.normal_hours :=
2847: l_old_assignment_rec.normal_hours;
2848: if nvl(l_old_assignment_rec.normal_hours, hr_api.g_number)
2849: <> nvl(l_db_assignment_rec.normal_hours, hr_api.g_number)
2844:
2845: if (p_normal_hours = hr_api.g_number) then
2846: l_assignment_rec.normal_hours :=
2847: l_old_assignment_rec.normal_hours;
2848: if nvl(l_old_assignment_rec.normal_hours, hr_api.g_number)
2849: <> nvl(l_db_assignment_rec.normal_hours, hr_api.g_number)
2850: then
2851: others_changed:=TRUE;
2852: end if;
2845: if (p_normal_hours = hr_api.g_number) then
2846: l_assignment_rec.normal_hours :=
2847: l_old_assignment_rec.normal_hours;
2848: if nvl(l_old_assignment_rec.normal_hours, hr_api.g_number)
2849: <> nvl(l_db_assignment_rec.normal_hours, hr_api.g_number)
2850: then
2851: others_changed:=TRUE;
2852: end if;
2853: else
2858: i_changed:=TRUE;
2859: end if;
2860: end if;
2861:
2862: if (p_time_normal_finish = hr_api.g_varchar2) then
2863: l_assignment_rec.time_normal_finish :=
2864: l_old_assignment_rec.time_normal_finish;
2865: if nvl(l_old_assignment_rec.time_normal_finish, hr_api.g_varchar2)
2866: <> nvl(l_db_assignment_rec.time_normal_finish, hr_api.g_varchar2)
2861:
2862: if (p_time_normal_finish = hr_api.g_varchar2) then
2863: l_assignment_rec.time_normal_finish :=
2864: l_old_assignment_rec.time_normal_finish;
2865: if nvl(l_old_assignment_rec.time_normal_finish, hr_api.g_varchar2)
2866: <> nvl(l_db_assignment_rec.time_normal_finish, hr_api.g_varchar2)
2867: then
2868: others_changed:=TRUE;
2869: end if;
2862: if (p_time_normal_finish = hr_api.g_varchar2) then
2863: l_assignment_rec.time_normal_finish :=
2864: l_old_assignment_rec.time_normal_finish;
2865: if nvl(l_old_assignment_rec.time_normal_finish, hr_api.g_varchar2)
2866: <> nvl(l_db_assignment_rec.time_normal_finish, hr_api.g_varchar2)
2867: then
2868: others_changed:=TRUE;
2869: end if;
2870: else
2868: others_changed:=TRUE;
2869: end if;
2870: else
2871: l_assignment_rec.time_normal_finish := p_time_normal_finish;
2872: if (nvl(p_time_normal_finish, hr_api.g_varchar2) <>
2873: nvl(l_db_assignment_rec.time_normal_finish, hr_api.g_varchar2))
2874: then
2875: i_changed:=TRUE;
2876: end if;
2869: end if;
2870: else
2871: l_assignment_rec.time_normal_finish := p_time_normal_finish;
2872: if (nvl(p_time_normal_finish, hr_api.g_varchar2) <>
2873: nvl(l_db_assignment_rec.time_normal_finish, hr_api.g_varchar2))
2874: then
2875: i_changed:=TRUE;
2876: end if;
2877: end if;
2875: i_changed:=TRUE;
2876: end if;
2877: end if;
2878:
2879: if (p_time_normal_start = hr_api.g_varchar2) then
2880: l_assignment_rec.time_normal_start :=
2881: l_old_assignment_rec.time_normal_start;
2882: if nvl(l_old_assignment_rec.time_normal_start, hr_api.g_varchar2)
2883: <> nvl(l_db_assignment_rec.time_normal_start, hr_api.g_varchar2)
2878:
2879: if (p_time_normal_start = hr_api.g_varchar2) then
2880: l_assignment_rec.time_normal_start :=
2881: l_old_assignment_rec.time_normal_start;
2882: if nvl(l_old_assignment_rec.time_normal_start, hr_api.g_varchar2)
2883: <> nvl(l_db_assignment_rec.time_normal_start, hr_api.g_varchar2)
2884: then
2885: others_changed:=TRUE;
2886: end if;
2879: if (p_time_normal_start = hr_api.g_varchar2) then
2880: l_assignment_rec.time_normal_start :=
2881: l_old_assignment_rec.time_normal_start;
2882: if nvl(l_old_assignment_rec.time_normal_start, hr_api.g_varchar2)
2883: <> nvl(l_db_assignment_rec.time_normal_start, hr_api.g_varchar2)
2884: then
2885: others_changed:=TRUE;
2886: end if;
2887: else
2885: others_changed:=TRUE;
2886: end if;
2887: else
2888: l_assignment_rec.time_normal_start := p_time_normal_start;
2889: if (nvl(p_time_normal_start, hr_api.g_varchar2) <>
2890: nvl(l_db_assignment_rec.time_normal_start, hr_api.g_varchar2))
2891: then
2892: i_changed:=TRUE;
2893: end if;
2886: end if;
2887: else
2888: l_assignment_rec.time_normal_start := p_time_normal_start;
2889: if (nvl(p_time_normal_start, hr_api.g_varchar2) <>
2890: nvl(l_db_assignment_rec.time_normal_start, hr_api.g_varchar2))
2891: then
2892: i_changed:=TRUE;
2893: end if;
2894: end if;
2892: i_changed:=TRUE;
2893: end if;
2894: end if;
2895:
2896: if (p_bargaining_unit_code = hr_api.g_varchar2) then
2897: l_assignment_rec.bargaining_unit_code :=
2898: l_old_assignment_rec.bargaining_unit_code;
2899: if nvl(l_old_assignment_rec.bargaining_unit_code, hr_api.g_varchar2)
2900: <> nvl(l_db_assignment_rec.bargaining_unit_code, hr_api.g_varchar2)
2895:
2896: if (p_bargaining_unit_code = hr_api.g_varchar2) then
2897: l_assignment_rec.bargaining_unit_code :=
2898: l_old_assignment_rec.bargaining_unit_code;
2899: if nvl(l_old_assignment_rec.bargaining_unit_code, hr_api.g_varchar2)
2900: <> nvl(l_db_assignment_rec.bargaining_unit_code, hr_api.g_varchar2)
2901: then
2902: others_changed:=TRUE;
2903: end if;
2896: if (p_bargaining_unit_code = hr_api.g_varchar2) then
2897: l_assignment_rec.bargaining_unit_code :=
2898: l_old_assignment_rec.bargaining_unit_code;
2899: if nvl(l_old_assignment_rec.bargaining_unit_code, hr_api.g_varchar2)
2900: <> nvl(l_db_assignment_rec.bargaining_unit_code, hr_api.g_varchar2)
2901: then
2902: others_changed:=TRUE;
2903: end if;
2904: else
2902: others_changed:=TRUE;
2903: end if;
2904: else
2905: l_assignment_rec.bargaining_unit_code := p_bargaining_unit_code;
2906: if (nvl(p_bargaining_unit_code, hr_api.g_varchar2) <>
2907: nvl(l_db_assignment_rec.bargaining_unit_code, hr_api.g_varchar2))
2908: then
2909: i_changed:=TRUE;
2910: end if;
2903: end if;
2904: else
2905: l_assignment_rec.bargaining_unit_code := p_bargaining_unit_code;
2906: if (nvl(p_bargaining_unit_code, hr_api.g_varchar2) <>
2907: nvl(l_db_assignment_rec.bargaining_unit_code, hr_api.g_varchar2))
2908: then
2909: i_changed:=TRUE;
2910: end if;
2911: end if;
2909: i_changed:=TRUE;
2910: end if;
2911: end if;
2912:
2913: if (p_labour_union_member_flag = hr_api.g_varchar2) then
2914: l_assignment_rec.labour_union_member_flag :=
2915: l_old_assignment_rec.labour_union_member_flag;
2916: if nvl(l_old_assignment_rec.labour_union_member_flag, hr_api.g_varchar2)
2917: <> nvl(l_db_assignment_rec.labour_union_member_flag, hr_api.g_varchar2)
2912:
2913: if (p_labour_union_member_flag = hr_api.g_varchar2) then
2914: l_assignment_rec.labour_union_member_flag :=
2915: l_old_assignment_rec.labour_union_member_flag;
2916: if nvl(l_old_assignment_rec.labour_union_member_flag, hr_api.g_varchar2)
2917: <> nvl(l_db_assignment_rec.labour_union_member_flag, hr_api.g_varchar2)
2918: then
2919: others_changed:=TRUE;
2920: end if;
2913: if (p_labour_union_member_flag = hr_api.g_varchar2) then
2914: l_assignment_rec.labour_union_member_flag :=
2915: l_old_assignment_rec.labour_union_member_flag;
2916: if nvl(l_old_assignment_rec.labour_union_member_flag, hr_api.g_varchar2)
2917: <> nvl(l_db_assignment_rec.labour_union_member_flag, hr_api.g_varchar2)
2918: then
2919: others_changed:=TRUE;
2920: end if;
2921: else
2919: others_changed:=TRUE;
2920: end if;
2921: else
2922: l_assignment_rec.labour_union_member_flag := p_labour_union_member_flag;
2923: if (nvl(p_labour_union_member_flag, hr_api.g_varchar2) <>
2924: nvl(l_db_assignment_rec.labour_union_member_flag, hr_api.g_varchar2))
2925: then
2926: i_changed:=TRUE;
2927: end if;
2920: end if;
2921: else
2922: l_assignment_rec.labour_union_member_flag := p_labour_union_member_flag;
2923: if (nvl(p_labour_union_member_flag, hr_api.g_varchar2) <>
2924: nvl(l_db_assignment_rec.labour_union_member_flag, hr_api.g_varchar2))
2925: then
2926: i_changed:=TRUE;
2927: end if;
2928: end if;
2927: end if;
2928: end if;
2929:
2930:
2931: if (p_ass_attribute_category = hr_api.g_varchar2) then
2932: l_assignment_rec.ass_attribute_category :=
2933: l_old_assignment_rec.ass_attribute_category;
2934: if nvl(l_old_assignment_rec.ass_attribute_category, hr_api.g_varchar2)
2935: <> nvl(l_db_assignment_rec.ass_attribute_category, hr_api.g_varchar2)
2930:
2931: if (p_ass_attribute_category = hr_api.g_varchar2) then
2932: l_assignment_rec.ass_attribute_category :=
2933: l_old_assignment_rec.ass_attribute_category;
2934: if nvl(l_old_assignment_rec.ass_attribute_category, hr_api.g_varchar2)
2935: <> nvl(l_db_assignment_rec.ass_attribute_category, hr_api.g_varchar2)
2936: then
2937: others_changed:=TRUE;
2938: end if;
2931: if (p_ass_attribute_category = hr_api.g_varchar2) then
2932: l_assignment_rec.ass_attribute_category :=
2933: l_old_assignment_rec.ass_attribute_category;
2934: if nvl(l_old_assignment_rec.ass_attribute_category, hr_api.g_varchar2)
2935: <> nvl(l_db_assignment_rec.ass_attribute_category, hr_api.g_varchar2)
2936: then
2937: others_changed:=TRUE;
2938: end if;
2939: else
2937: others_changed:=TRUE;
2938: end if;
2939: else
2940: l_assignment_rec.ass_attribute_category := p_ass_attribute_category;
2941: if (nvl(p_ass_attribute_category, hr_api.g_varchar2) <>
2942: nvl(l_db_assignment_rec.ass_attribute_category, hr_api.g_varchar2))
2943: then
2944: i_changed:=TRUE;
2945: end if;
2938: end if;
2939: else
2940: l_assignment_rec.ass_attribute_category := p_ass_attribute_category;
2941: if (nvl(p_ass_attribute_category, hr_api.g_varchar2) <>
2942: nvl(l_db_assignment_rec.ass_attribute_category, hr_api.g_varchar2))
2943: then
2944: i_changed:=TRUE;
2945: end if;
2946: end if;
2944: i_changed:=TRUE;
2945: end if;
2946: end if;
2947:
2948: if (p_assignment_status_type_id = hr_api.g_number) then
2949: l_assignment_rec.assignment_status_type_id :=
2950: l_old_assignment_rec.assignment_status_type_id;
2951: if nvl(l_old_assignment_rec.assignment_status_type_id, hr_api.g_number)
2952: <> nvl(l_db_assignment_rec.assignment_status_type_id, hr_api.g_number)
2947:
2948: if (p_assignment_status_type_id = hr_api.g_number) then
2949: l_assignment_rec.assignment_status_type_id :=
2950: l_old_assignment_rec.assignment_status_type_id;
2951: if nvl(l_old_assignment_rec.assignment_status_type_id, hr_api.g_number)
2952: <> nvl(l_db_assignment_rec.assignment_status_type_id, hr_api.g_number)
2953: then
2954: others_changed:=TRUE;
2955: end if;
2948: if (p_assignment_status_type_id = hr_api.g_number) then
2949: l_assignment_rec.assignment_status_type_id :=
2950: l_old_assignment_rec.assignment_status_type_id;
2951: if nvl(l_old_assignment_rec.assignment_status_type_id, hr_api.g_number)
2952: <> nvl(l_db_assignment_rec.assignment_status_type_id, hr_api.g_number)
2953: then
2954: others_changed:=TRUE;
2955: end if;
2956: else
2960: then
2961: i_changed:=TRUE;
2962: end if;
2963: end if;
2964: if (p_change_reason = hr_api.g_varchar2) then
2965: l_assignment_rec.change_reason :=
2966: l_old_assignment_rec.change_reason;
2967: if (nvl(l_db_assignment_rec.change_reason, hr_api.g_varchar2) <>
2968: nvl(l_old_assignment_rec.change_reason, hr_api.g_varchar2))
2963: end if;
2964: if (p_change_reason = hr_api.g_varchar2) then
2965: l_assignment_rec.change_reason :=
2966: l_old_assignment_rec.change_reason;
2967: if (nvl(l_db_assignment_rec.change_reason, hr_api.g_varchar2) <>
2968: nvl(l_old_assignment_rec.change_reason, hr_api.g_varchar2))
2969: then
2970: others_changed:=TRUE;
2971: end if;
2964: if (p_change_reason = hr_api.g_varchar2) then
2965: l_assignment_rec.change_reason :=
2966: l_old_assignment_rec.change_reason;
2967: if (nvl(l_db_assignment_rec.change_reason, hr_api.g_varchar2) <>
2968: nvl(l_old_assignment_rec.change_reason, hr_api.g_varchar2))
2969: then
2970: others_changed:=TRUE;
2971: end if;
2972: else
2970: others_changed:=TRUE;
2971: end if;
2972: else
2973: l_assignment_rec.change_reason := p_change_reason;
2974: if (nvl(p_change_reason, hr_api.g_varchar2) <>
2975: nvl(l_db_assignment_rec.change_reason, hr_api.g_varchar2))
2976: then
2977: i_changed:=TRUE;
2978: end if;
2971: end if;
2972: else
2973: l_assignment_rec.change_reason := p_change_reason;
2974: if (nvl(p_change_reason, hr_api.g_varchar2) <>
2975: nvl(l_db_assignment_rec.change_reason, hr_api.g_varchar2))
2976: then
2977: i_changed:=TRUE;
2978: end if;
2979: end if;
2977: i_changed:=TRUE;
2978: end if;
2979: end if;
2980:
2981: if (p_ass_attribute1 = hr_api.g_varchar2) then
2982: l_assignment_rec.ass_attribute1 :=
2983: l_old_assignment_rec.ass_attribute1;
2984: if (nvl(l_db_assignment_rec.ass_attribute1, hr_api.g_varchar2) <>
2985: nvl(l_old_assignment_rec.ass_attribute1, hr_api.g_varchar2))
2980:
2981: if (p_ass_attribute1 = hr_api.g_varchar2) then
2982: l_assignment_rec.ass_attribute1 :=
2983: l_old_assignment_rec.ass_attribute1;
2984: if (nvl(l_db_assignment_rec.ass_attribute1, hr_api.g_varchar2) <>
2985: nvl(l_old_assignment_rec.ass_attribute1, hr_api.g_varchar2))
2986: then
2987: others_changed:=TRUE;
2988: end if;
2981: if (p_ass_attribute1 = hr_api.g_varchar2) then
2982: l_assignment_rec.ass_attribute1 :=
2983: l_old_assignment_rec.ass_attribute1;
2984: if (nvl(l_db_assignment_rec.ass_attribute1, hr_api.g_varchar2) <>
2985: nvl(l_old_assignment_rec.ass_attribute1, hr_api.g_varchar2))
2986: then
2987: others_changed:=TRUE;
2988: end if;
2989: else
2987: others_changed:=TRUE;
2988: end if;
2989: else
2990: l_assignment_rec.ass_attribute1 := p_ass_attribute1;
2991: if (nvl(p_ass_attribute1, hr_api.g_varchar2) <>
2992: nvl(l_db_assignment_rec.ass_attribute1, hr_api.g_varchar2))
2993: then
2994: i_changed:=TRUE;
2995: end if;
2988: end if;
2989: else
2990: l_assignment_rec.ass_attribute1 := p_ass_attribute1;
2991: if (nvl(p_ass_attribute1, hr_api.g_varchar2) <>
2992: nvl(l_db_assignment_rec.ass_attribute1, hr_api.g_varchar2))
2993: then
2994: i_changed:=TRUE;
2995: end if;
2996: end if;
2994: i_changed:=TRUE;
2995: end if;
2996: end if;
2997:
2998: if (p_ass_attribute2 = hr_api.g_varchar2) then
2999: l_assignment_rec.ass_attribute2 :=
3000: l_old_assignment_rec.ass_attribute2;
3001: if (nvl(l_db_assignment_rec.ass_attribute2, hr_api.g_varchar2) <>
3002: nvl(l_old_assignment_rec.ass_attribute2, hr_api.g_varchar2))
2997:
2998: if (p_ass_attribute2 = hr_api.g_varchar2) then
2999: l_assignment_rec.ass_attribute2 :=
3000: l_old_assignment_rec.ass_attribute2;
3001: if (nvl(l_db_assignment_rec.ass_attribute2, hr_api.g_varchar2) <>
3002: nvl(l_old_assignment_rec.ass_attribute2, hr_api.g_varchar2))
3003: then
3004: others_changed:=TRUE;
3005: end if;
2998: if (p_ass_attribute2 = hr_api.g_varchar2) then
2999: l_assignment_rec.ass_attribute2 :=
3000: l_old_assignment_rec.ass_attribute2;
3001: if (nvl(l_db_assignment_rec.ass_attribute2, hr_api.g_varchar2) <>
3002: nvl(l_old_assignment_rec.ass_attribute2, hr_api.g_varchar2))
3003: then
3004: others_changed:=TRUE;
3005: end if;
3006: else
3004: others_changed:=TRUE;
3005: end if;
3006: else
3007: l_assignment_rec.ass_attribute2 := p_ass_attribute2;
3008: if (nvl(p_ass_attribute2, hr_api.g_varchar2) <>
3009: nvl(l_db_assignment_rec.ass_attribute2, hr_api.g_varchar2))
3010: then
3011: i_changed:=TRUE;
3012: end if;
3005: end if;
3006: else
3007: l_assignment_rec.ass_attribute2 := p_ass_attribute2;
3008: if (nvl(p_ass_attribute2, hr_api.g_varchar2) <>
3009: nvl(l_db_assignment_rec.ass_attribute2, hr_api.g_varchar2))
3010: then
3011: i_changed:=TRUE;
3012: end if;
3013: end if;
3011: i_changed:=TRUE;
3012: end if;
3013: end if;
3014:
3015: if (p_ass_attribute3 = hr_api.g_varchar2) then
3016: l_assignment_rec.ass_attribute3 :=
3017: l_old_assignment_rec.ass_attribute3;
3018: if (nvl(l_db_assignment_rec.ass_attribute3, hr_api.g_varchar2) <>
3019: nvl(l_old_assignment_rec.ass_attribute3, hr_api.g_varchar2))
3014:
3015: if (p_ass_attribute3 = hr_api.g_varchar2) then
3016: l_assignment_rec.ass_attribute3 :=
3017: l_old_assignment_rec.ass_attribute3;
3018: if (nvl(l_db_assignment_rec.ass_attribute3, hr_api.g_varchar2) <>
3019: nvl(l_old_assignment_rec.ass_attribute3, hr_api.g_varchar2))
3020: then
3021: others_changed:=TRUE;
3022: end if;
3015: if (p_ass_attribute3 = hr_api.g_varchar2) then
3016: l_assignment_rec.ass_attribute3 :=
3017: l_old_assignment_rec.ass_attribute3;
3018: if (nvl(l_db_assignment_rec.ass_attribute3, hr_api.g_varchar2) <>
3019: nvl(l_old_assignment_rec.ass_attribute3, hr_api.g_varchar2))
3020: then
3021: others_changed:=TRUE;
3022: end if;
3023: else
3021: others_changed:=TRUE;
3022: end if;
3023: else
3024: l_assignment_rec.ass_attribute3 := p_ass_attribute3;
3025: if (nvl(p_ass_attribute3, hr_api.g_varchar2) <>
3026: nvl(l_db_assignment_rec.ass_attribute3, hr_api.g_varchar2))
3027: then
3028: i_changed:=TRUE;
3029: end if;
3022: end if;
3023: else
3024: l_assignment_rec.ass_attribute3 := p_ass_attribute3;
3025: if (nvl(p_ass_attribute3, hr_api.g_varchar2) <>
3026: nvl(l_db_assignment_rec.ass_attribute3, hr_api.g_varchar2))
3027: then
3028: i_changed:=TRUE;
3029: end if;
3030: end if;
3028: i_changed:=TRUE;
3029: end if;
3030: end if;
3031:
3032: if (p_ass_attribute4 = hr_api.g_varchar2) then
3033: l_assignment_rec.ass_attribute4 :=
3034: l_old_assignment_rec.ass_attribute4;
3035: if (nvl(l_db_assignment_rec.ass_attribute4, hr_api.g_varchar2) <>
3036: nvl(l_old_assignment_rec.ass_attribute4, hr_api.g_varchar2))
3031:
3032: if (p_ass_attribute4 = hr_api.g_varchar2) then
3033: l_assignment_rec.ass_attribute4 :=
3034: l_old_assignment_rec.ass_attribute4;
3035: if (nvl(l_db_assignment_rec.ass_attribute4, hr_api.g_varchar2) <>
3036: nvl(l_old_assignment_rec.ass_attribute4, hr_api.g_varchar2))
3037: then
3038: others_changed:=TRUE;
3039: end if;
3032: if (p_ass_attribute4 = hr_api.g_varchar2) then
3033: l_assignment_rec.ass_attribute4 :=
3034: l_old_assignment_rec.ass_attribute4;
3035: if (nvl(l_db_assignment_rec.ass_attribute4, hr_api.g_varchar2) <>
3036: nvl(l_old_assignment_rec.ass_attribute4, hr_api.g_varchar2))
3037: then
3038: others_changed:=TRUE;
3039: end if;
3040: else
3038: others_changed:=TRUE;
3039: end if;
3040: else
3041: l_assignment_rec.ass_attribute4 := p_ass_attribute4;
3042: if (nvl(p_ass_attribute4, hr_api.g_varchar2) <>
3043: nvl(l_db_assignment_rec.ass_attribute4, hr_api.g_varchar2))
3044: then
3045: i_changed:=TRUE;
3046: end if;
3039: end if;
3040: else
3041: l_assignment_rec.ass_attribute4 := p_ass_attribute4;
3042: if (nvl(p_ass_attribute4, hr_api.g_varchar2) <>
3043: nvl(l_db_assignment_rec.ass_attribute4, hr_api.g_varchar2))
3044: then
3045: i_changed:=TRUE;
3046: end if;
3047: end if;
3045: i_changed:=TRUE;
3046: end if;
3047: end if;
3048:
3049: if (p_ass_attribute5 = hr_api.g_varchar2) then
3050: l_assignment_rec.ass_attribute5 :=
3051: l_old_assignment_rec.ass_attribute5;
3052: if (nvl(l_db_assignment_rec.ass_attribute5, hr_api.g_varchar2) <>
3053: nvl(l_old_assignment_rec.ass_attribute5, hr_api.g_varchar2))
3048:
3049: if (p_ass_attribute5 = hr_api.g_varchar2) then
3050: l_assignment_rec.ass_attribute5 :=
3051: l_old_assignment_rec.ass_attribute5;
3052: if (nvl(l_db_assignment_rec.ass_attribute5, hr_api.g_varchar2) <>
3053: nvl(l_old_assignment_rec.ass_attribute5, hr_api.g_varchar2))
3054: then
3055: others_changed:=TRUE;
3056: end if;
3049: if (p_ass_attribute5 = hr_api.g_varchar2) then
3050: l_assignment_rec.ass_attribute5 :=
3051: l_old_assignment_rec.ass_attribute5;
3052: if (nvl(l_db_assignment_rec.ass_attribute5, hr_api.g_varchar2) <>
3053: nvl(l_old_assignment_rec.ass_attribute5, hr_api.g_varchar2))
3054: then
3055: others_changed:=TRUE;
3056: end if;
3057: else
3055: others_changed:=TRUE;
3056: end if;
3057: else
3058: l_assignment_rec.ass_attribute5 := p_ass_attribute5;
3059: if (nvl(p_ass_attribute5, hr_api.g_varchar2) <>
3060: nvl(l_db_assignment_rec.ass_attribute5, hr_api.g_varchar2))
3061: then
3062: i_changed:=TRUE;
3063: end if;
3056: end if;
3057: else
3058: l_assignment_rec.ass_attribute5 := p_ass_attribute5;
3059: if (nvl(p_ass_attribute5, hr_api.g_varchar2) <>
3060: nvl(l_db_assignment_rec.ass_attribute5, hr_api.g_varchar2))
3061: then
3062: i_changed:=TRUE;
3063: end if;
3064: end if;
3062: i_changed:=TRUE;
3063: end if;
3064: end if;
3065:
3066: if (p_ass_attribute6 = hr_api.g_varchar2) then
3067: l_assignment_rec.ass_attribute6 :=
3068: l_old_assignment_rec.ass_attribute6;
3069: if (nvl(l_db_assignment_rec.ass_attribute6, hr_api.g_varchar2) <>
3070: nvl(l_old_assignment_rec.ass_attribute6, hr_api.g_varchar2))
3065:
3066: if (p_ass_attribute6 = hr_api.g_varchar2) then
3067: l_assignment_rec.ass_attribute6 :=
3068: l_old_assignment_rec.ass_attribute6;
3069: if (nvl(l_db_assignment_rec.ass_attribute6, hr_api.g_varchar2) <>
3070: nvl(l_old_assignment_rec.ass_attribute6, hr_api.g_varchar2))
3071: then
3072: others_changed:=TRUE;
3073: end if;
3066: if (p_ass_attribute6 = hr_api.g_varchar2) then
3067: l_assignment_rec.ass_attribute6 :=
3068: l_old_assignment_rec.ass_attribute6;
3069: if (nvl(l_db_assignment_rec.ass_attribute6, hr_api.g_varchar2) <>
3070: nvl(l_old_assignment_rec.ass_attribute6, hr_api.g_varchar2))
3071: then
3072: others_changed:=TRUE;
3073: end if;
3074: else
3072: others_changed:=TRUE;
3073: end if;
3074: else
3075: l_assignment_rec.ass_attribute6 := p_ass_attribute6;
3076: if (nvl(p_ass_attribute6, hr_api.g_varchar2) <>
3077: nvl(l_db_assignment_rec.ass_attribute6, hr_api.g_varchar2))
3078: then
3079: i_changed:=TRUE;
3080: end if;
3073: end if;
3074: else
3075: l_assignment_rec.ass_attribute6 := p_ass_attribute6;
3076: if (nvl(p_ass_attribute6, hr_api.g_varchar2) <>
3077: nvl(l_db_assignment_rec.ass_attribute6, hr_api.g_varchar2))
3078: then
3079: i_changed:=TRUE;
3080: end if;
3081: end if;
3079: i_changed:=TRUE;
3080: end if;
3081: end if;
3082:
3083: if (p_ass_attribute7 = hr_api.g_varchar2) then
3084: l_assignment_rec.ass_attribute7 :=
3085: l_old_assignment_rec.ass_attribute7;
3086: if (nvl(l_db_assignment_rec.ass_attribute7, hr_api.g_varchar2) <>
3087: nvl(l_old_assignment_rec.ass_attribute7, hr_api.g_varchar2))
3082:
3083: if (p_ass_attribute7 = hr_api.g_varchar2) then
3084: l_assignment_rec.ass_attribute7 :=
3085: l_old_assignment_rec.ass_attribute7;
3086: if (nvl(l_db_assignment_rec.ass_attribute7, hr_api.g_varchar2) <>
3087: nvl(l_old_assignment_rec.ass_attribute7, hr_api.g_varchar2))
3088: then
3089: others_changed:=TRUE;
3090: end if;
3083: if (p_ass_attribute7 = hr_api.g_varchar2) then
3084: l_assignment_rec.ass_attribute7 :=
3085: l_old_assignment_rec.ass_attribute7;
3086: if (nvl(l_db_assignment_rec.ass_attribute7, hr_api.g_varchar2) <>
3087: nvl(l_old_assignment_rec.ass_attribute7, hr_api.g_varchar2))
3088: then
3089: others_changed:=TRUE;
3090: end if;
3091: else
3089: others_changed:=TRUE;
3090: end if;
3091: else
3092: l_assignment_rec.ass_attribute7 := p_ass_attribute7;
3093: if (nvl(p_ass_attribute7, hr_api.g_varchar2) <>
3094: nvl(l_db_assignment_rec.ass_attribute7, hr_api.g_varchar2))
3095: then
3096: i_changed:=TRUE;
3097: end if;
3090: end if;
3091: else
3092: l_assignment_rec.ass_attribute7 := p_ass_attribute7;
3093: if (nvl(p_ass_attribute7, hr_api.g_varchar2) <>
3094: nvl(l_db_assignment_rec.ass_attribute7, hr_api.g_varchar2))
3095: then
3096: i_changed:=TRUE;
3097: end if;
3098: end if;
3096: i_changed:=TRUE;
3097: end if;
3098: end if;
3099:
3100: if (p_ass_attribute8 = hr_api.g_varchar2) then
3101: l_assignment_rec.ass_attribute8 :=
3102: l_old_assignment_rec.ass_attribute8;
3103: if (nvl(l_db_assignment_rec.ass_attribute8, hr_api.g_varchar2) <>
3104: nvl(l_old_assignment_rec.ass_attribute8, hr_api.g_varchar2))
3099:
3100: if (p_ass_attribute8 = hr_api.g_varchar2) then
3101: l_assignment_rec.ass_attribute8 :=
3102: l_old_assignment_rec.ass_attribute8;
3103: if (nvl(l_db_assignment_rec.ass_attribute8, hr_api.g_varchar2) <>
3104: nvl(l_old_assignment_rec.ass_attribute8, hr_api.g_varchar2))
3105: then
3106: others_changed:=TRUE;
3107: end if;
3100: if (p_ass_attribute8 = hr_api.g_varchar2) then
3101: l_assignment_rec.ass_attribute8 :=
3102: l_old_assignment_rec.ass_attribute8;
3103: if (nvl(l_db_assignment_rec.ass_attribute8, hr_api.g_varchar2) <>
3104: nvl(l_old_assignment_rec.ass_attribute8, hr_api.g_varchar2))
3105: then
3106: others_changed:=TRUE;
3107: end if;
3108: else
3106: others_changed:=TRUE;
3107: end if;
3108: else
3109: l_assignment_rec.ass_attribute8 := p_ass_attribute8;
3110: if (nvl(p_ass_attribute8, hr_api.g_varchar2) <>
3111: nvl(l_db_assignment_rec.ass_attribute8, hr_api.g_varchar2))
3112: then
3113: i_changed:=TRUE;
3114: end if;
3107: end if;
3108: else
3109: l_assignment_rec.ass_attribute8 := p_ass_attribute8;
3110: if (nvl(p_ass_attribute8, hr_api.g_varchar2) <>
3111: nvl(l_db_assignment_rec.ass_attribute8, hr_api.g_varchar2))
3112: then
3113: i_changed:=TRUE;
3114: end if;
3115: end if;
3113: i_changed:=TRUE;
3114: end if;
3115: end if;
3116:
3117: if (p_ass_attribute9 = hr_api.g_varchar2) then
3118: l_assignment_rec.ass_attribute9 :=
3119: l_old_assignment_rec.ass_attribute9;
3120: if (nvl(l_db_assignment_rec.ass_attribute9, hr_api.g_varchar2) <>
3121: nvl(l_old_assignment_rec.ass_attribute9, hr_api.g_varchar2))
3116:
3117: if (p_ass_attribute9 = hr_api.g_varchar2) then
3118: l_assignment_rec.ass_attribute9 :=
3119: l_old_assignment_rec.ass_attribute9;
3120: if (nvl(l_db_assignment_rec.ass_attribute9, hr_api.g_varchar2) <>
3121: nvl(l_old_assignment_rec.ass_attribute9, hr_api.g_varchar2))
3122: then
3123: others_changed:=TRUE;
3124: end if;
3117: if (p_ass_attribute9 = hr_api.g_varchar2) then
3118: l_assignment_rec.ass_attribute9 :=
3119: l_old_assignment_rec.ass_attribute9;
3120: if (nvl(l_db_assignment_rec.ass_attribute9, hr_api.g_varchar2) <>
3121: nvl(l_old_assignment_rec.ass_attribute9, hr_api.g_varchar2))
3122: then
3123: others_changed:=TRUE;
3124: end if;
3125: else
3123: others_changed:=TRUE;
3124: end if;
3125: else
3126: l_assignment_rec.ass_attribute9 :=p_ass_attribute9;
3127: if (nvl(p_ass_attribute9, hr_api.g_varchar2) <>
3128: nvl(l_db_assignment_rec.ass_attribute9, hr_api.g_varchar2))
3129: then
3130: i_changed:=TRUE;
3131: end if;
3124: end if;
3125: else
3126: l_assignment_rec.ass_attribute9 :=p_ass_attribute9;
3127: if (nvl(p_ass_attribute9, hr_api.g_varchar2) <>
3128: nvl(l_db_assignment_rec.ass_attribute9, hr_api.g_varchar2))
3129: then
3130: i_changed:=TRUE;
3131: end if;
3132: end if;
3130: i_changed:=TRUE;
3131: end if;
3132: end if;
3133:
3134: if (p_ass_attribute10 = hr_api.g_varchar2) then
3135: l_assignment_rec.ass_attribute10 :=
3136: l_old_assignment_rec.ass_attribute10;
3137: if (nvl(l_db_assignment_rec.ass_attribute10, hr_api.g_varchar2) <>
3138: nvl(l_old_assignment_rec.ass_attribute10, hr_api.g_varchar2))
3133:
3134: if (p_ass_attribute10 = hr_api.g_varchar2) then
3135: l_assignment_rec.ass_attribute10 :=
3136: l_old_assignment_rec.ass_attribute10;
3137: if (nvl(l_db_assignment_rec.ass_attribute10, hr_api.g_varchar2) <>
3138: nvl(l_old_assignment_rec.ass_attribute10, hr_api.g_varchar2))
3139: then
3140: others_changed:=TRUE;
3141: end if;
3134: if (p_ass_attribute10 = hr_api.g_varchar2) then
3135: l_assignment_rec.ass_attribute10 :=
3136: l_old_assignment_rec.ass_attribute10;
3137: if (nvl(l_db_assignment_rec.ass_attribute10, hr_api.g_varchar2) <>
3138: nvl(l_old_assignment_rec.ass_attribute10, hr_api.g_varchar2))
3139: then
3140: others_changed:=TRUE;
3141: end if;
3142: else
3140: others_changed:=TRUE;
3141: end if;
3142: else
3143: l_assignment_rec.ass_attribute10 := p_ass_attribute10;
3144: if (nvl(p_ass_attribute10, hr_api.g_varchar2) <>
3145: nvl(l_db_assignment_rec.ass_attribute10, hr_api.g_varchar2))
3146: then
3147: i_changed:=TRUE;
3148: end if;
3141: end if;
3142: else
3143: l_assignment_rec.ass_attribute10 := p_ass_attribute10;
3144: if (nvl(p_ass_attribute10, hr_api.g_varchar2) <>
3145: nvl(l_db_assignment_rec.ass_attribute10, hr_api.g_varchar2))
3146: then
3147: i_changed:=TRUE;
3148: end if;
3149: end if;
3147: i_changed:=TRUE;
3148: end if;
3149: end if;
3150:
3151: if (p_ass_attribute11 = hr_api.g_varchar2) then
3152: l_assignment_rec.ass_attribute11 :=
3153: l_old_assignment_rec.ass_attribute11;
3154: if (nvl(l_db_assignment_rec.ass_attribute11, hr_api.g_varchar2) <>
3155: nvl(l_old_assignment_rec.ass_attribute11, hr_api.g_varchar2))
3150:
3151: if (p_ass_attribute11 = hr_api.g_varchar2) then
3152: l_assignment_rec.ass_attribute11 :=
3153: l_old_assignment_rec.ass_attribute11;
3154: if (nvl(l_db_assignment_rec.ass_attribute11, hr_api.g_varchar2) <>
3155: nvl(l_old_assignment_rec.ass_attribute11, hr_api.g_varchar2))
3156: then
3157: others_changed:=TRUE;
3158: end if;
3151: if (p_ass_attribute11 = hr_api.g_varchar2) then
3152: l_assignment_rec.ass_attribute11 :=
3153: l_old_assignment_rec.ass_attribute11;
3154: if (nvl(l_db_assignment_rec.ass_attribute11, hr_api.g_varchar2) <>
3155: nvl(l_old_assignment_rec.ass_attribute11, hr_api.g_varchar2))
3156: then
3157: others_changed:=TRUE;
3158: end if;
3159: else
3157: others_changed:=TRUE;
3158: end if;
3159: else
3160: l_assignment_rec.ass_attribute11 := p_ass_attribute11;
3161: if (nvl(p_ass_attribute11, hr_api.g_varchar2) <>
3162: nvl(l_db_assignment_rec.ass_attribute11, hr_api.g_varchar2))
3163: then
3164: i_changed:=TRUE;
3165: end if;
3158: end if;
3159: else
3160: l_assignment_rec.ass_attribute11 := p_ass_attribute11;
3161: if (nvl(p_ass_attribute11, hr_api.g_varchar2) <>
3162: nvl(l_db_assignment_rec.ass_attribute11, hr_api.g_varchar2))
3163: then
3164: i_changed:=TRUE;
3165: end if;
3166: end if;
3164: i_changed:=TRUE;
3165: end if;
3166: end if;
3167:
3168: if (p_ass_attribute12 = hr_api.g_varchar2) then
3169: l_assignment_rec.ass_attribute12 :=
3170: l_old_assignment_rec.ass_attribute12;
3171: if (nvl(l_db_assignment_rec.ass_attribute12, hr_api.g_varchar2) <>
3172: nvl(l_old_assignment_rec.ass_attribute12, hr_api.g_varchar2))
3167:
3168: if (p_ass_attribute12 = hr_api.g_varchar2) then
3169: l_assignment_rec.ass_attribute12 :=
3170: l_old_assignment_rec.ass_attribute12;
3171: if (nvl(l_db_assignment_rec.ass_attribute12, hr_api.g_varchar2) <>
3172: nvl(l_old_assignment_rec.ass_attribute12, hr_api.g_varchar2))
3173: then
3174: others_changed:=TRUE;
3175: end if;
3168: if (p_ass_attribute12 = hr_api.g_varchar2) then
3169: l_assignment_rec.ass_attribute12 :=
3170: l_old_assignment_rec.ass_attribute12;
3171: if (nvl(l_db_assignment_rec.ass_attribute12, hr_api.g_varchar2) <>
3172: nvl(l_old_assignment_rec.ass_attribute12, hr_api.g_varchar2))
3173: then
3174: others_changed:=TRUE;
3175: end if;
3176: else
3174: others_changed:=TRUE;
3175: end if;
3176: else
3177: l_assignment_rec.ass_attribute12 := p_ass_attribute12;
3178: if (nvl(p_ass_attribute12, hr_api.g_varchar2) <>
3179: nvl(l_db_assignment_rec.ass_attribute12, hr_api.g_varchar2))
3180: then
3181: i_changed:=TRUE;
3182: end if;
3175: end if;
3176: else
3177: l_assignment_rec.ass_attribute12 := p_ass_attribute12;
3178: if (nvl(p_ass_attribute12, hr_api.g_varchar2) <>
3179: nvl(l_db_assignment_rec.ass_attribute12, hr_api.g_varchar2))
3180: then
3181: i_changed:=TRUE;
3182: end if;
3183: end if;
3181: i_changed:=TRUE;
3182: end if;
3183: end if;
3184:
3185: if (p_ass_attribute13 = hr_api.g_varchar2) then
3186: l_assignment_rec.ass_attribute13 :=
3187: l_old_assignment_rec.ass_attribute13;
3188: if (nvl(l_db_assignment_rec.ass_attribute13, hr_api.g_varchar2) <>
3189: nvl(l_old_assignment_rec.ass_attribute13, hr_api.g_varchar2))
3184:
3185: if (p_ass_attribute13 = hr_api.g_varchar2) then
3186: l_assignment_rec.ass_attribute13 :=
3187: l_old_assignment_rec.ass_attribute13;
3188: if (nvl(l_db_assignment_rec.ass_attribute13, hr_api.g_varchar2) <>
3189: nvl(l_old_assignment_rec.ass_attribute13, hr_api.g_varchar2))
3190: then
3191: others_changed:=TRUE;
3192: end if;
3185: if (p_ass_attribute13 = hr_api.g_varchar2) then
3186: l_assignment_rec.ass_attribute13 :=
3187: l_old_assignment_rec.ass_attribute13;
3188: if (nvl(l_db_assignment_rec.ass_attribute13, hr_api.g_varchar2) <>
3189: nvl(l_old_assignment_rec.ass_attribute13, hr_api.g_varchar2))
3190: then
3191: others_changed:=TRUE;
3192: end if;
3193: else
3191: others_changed:=TRUE;
3192: end if;
3193: else
3194: l_assignment_rec.ass_attribute13 := p_ass_attribute13;
3195: if (nvl(p_ass_attribute13, hr_api.g_varchar2) <>
3196: nvl(l_db_assignment_rec.ass_attribute13, hr_api.g_varchar2))
3197: then
3198: i_changed:=TRUE;
3199: end if;
3192: end if;
3193: else
3194: l_assignment_rec.ass_attribute13 := p_ass_attribute13;
3195: if (nvl(p_ass_attribute13, hr_api.g_varchar2) <>
3196: nvl(l_db_assignment_rec.ass_attribute13, hr_api.g_varchar2))
3197: then
3198: i_changed:=TRUE;
3199: end if;
3200: end if;
3198: i_changed:=TRUE;
3199: end if;
3200: end if;
3201:
3202: if (p_ass_attribute14 = hr_api.g_varchar2) then
3203: l_assignment_rec.ass_attribute14 :=
3204: l_old_assignment_rec.ass_attribute14;
3205: if (nvl(l_db_assignment_rec.ass_attribute14, hr_api.g_varchar2) <>
3206: nvl(l_old_assignment_rec.ass_attribute14, hr_api.g_varchar2))
3201:
3202: if (p_ass_attribute14 = hr_api.g_varchar2) then
3203: l_assignment_rec.ass_attribute14 :=
3204: l_old_assignment_rec.ass_attribute14;
3205: if (nvl(l_db_assignment_rec.ass_attribute14, hr_api.g_varchar2) <>
3206: nvl(l_old_assignment_rec.ass_attribute14, hr_api.g_varchar2))
3207: then
3208: others_changed:=TRUE;
3209: end if;
3202: if (p_ass_attribute14 = hr_api.g_varchar2) then
3203: l_assignment_rec.ass_attribute14 :=
3204: l_old_assignment_rec.ass_attribute14;
3205: if (nvl(l_db_assignment_rec.ass_attribute14, hr_api.g_varchar2) <>
3206: nvl(l_old_assignment_rec.ass_attribute14, hr_api.g_varchar2))
3207: then
3208: others_changed:=TRUE;
3209: end if;
3210: else
3208: others_changed:=TRUE;
3209: end if;
3210: else
3211: l_assignment_rec.ass_attribute14 := p_ass_attribute14;
3212: if (nvl(p_ass_attribute14, hr_api.g_varchar2) <>
3213: nvl(l_db_assignment_rec.ass_attribute14, hr_api.g_varchar2))
3214: then
3215: i_changed:=TRUE;
3216: end if;
3209: end if;
3210: else
3211: l_assignment_rec.ass_attribute14 := p_ass_attribute14;
3212: if (nvl(p_ass_attribute14, hr_api.g_varchar2) <>
3213: nvl(l_db_assignment_rec.ass_attribute14, hr_api.g_varchar2))
3214: then
3215: i_changed:=TRUE;
3216: end if;
3217: end if;
3215: i_changed:=TRUE;
3216: end if;
3217: end if;
3218:
3219: if (p_ass_attribute15 = hr_api.g_varchar2) then
3220: l_assignment_rec.ass_attribute15 :=
3221: l_old_assignment_rec.ass_attribute15;
3222: if (nvl(l_db_assignment_rec.ass_attribute15, hr_api.g_varchar2) <>
3223: nvl(l_old_assignment_rec.ass_attribute15, hr_api.g_varchar2))
3218:
3219: if (p_ass_attribute15 = hr_api.g_varchar2) then
3220: l_assignment_rec.ass_attribute15 :=
3221: l_old_assignment_rec.ass_attribute15;
3222: if (nvl(l_db_assignment_rec.ass_attribute15, hr_api.g_varchar2) <>
3223: nvl(l_old_assignment_rec.ass_attribute15, hr_api.g_varchar2))
3224: then
3225: others_changed:=TRUE;
3226: end if;
3219: if (p_ass_attribute15 = hr_api.g_varchar2) then
3220: l_assignment_rec.ass_attribute15 :=
3221: l_old_assignment_rec.ass_attribute15;
3222: if (nvl(l_db_assignment_rec.ass_attribute15, hr_api.g_varchar2) <>
3223: nvl(l_old_assignment_rec.ass_attribute15, hr_api.g_varchar2))
3224: then
3225: others_changed:=TRUE;
3226: end if;
3227: else
3225: others_changed:=TRUE;
3226: end if;
3227: else
3228: l_assignment_rec.ass_attribute15 := p_ass_attribute15;
3229: if (nvl(p_ass_attribute15, hr_api.g_varchar2) <>
3230: nvl(l_db_assignment_rec.ass_attribute15, hr_api.g_varchar2))
3231: then
3232: i_changed:=TRUE;
3233: end if;
3226: end if;
3227: else
3228: l_assignment_rec.ass_attribute15 := p_ass_attribute15;
3229: if (nvl(p_ass_attribute15, hr_api.g_varchar2) <>
3230: nvl(l_db_assignment_rec.ass_attribute15, hr_api.g_varchar2))
3231: then
3232: i_changed:=TRUE;
3233: end if;
3234: end if;
3232: i_changed:=TRUE;
3233: end if;
3234: end if;
3235:
3236: if (p_ass_attribute16 = hr_api.g_varchar2) then
3237: l_assignment_rec.ass_attribute16 :=
3238: l_old_assignment_rec.ass_attribute16;
3239: if (nvl(l_db_assignment_rec.ass_attribute16, hr_api.g_varchar2) <>
3240: nvl(l_old_assignment_rec.ass_attribute16, hr_api.g_varchar2))
3235:
3236: if (p_ass_attribute16 = hr_api.g_varchar2) then
3237: l_assignment_rec.ass_attribute16 :=
3238: l_old_assignment_rec.ass_attribute16;
3239: if (nvl(l_db_assignment_rec.ass_attribute16, hr_api.g_varchar2) <>
3240: nvl(l_old_assignment_rec.ass_attribute16, hr_api.g_varchar2))
3241: then
3242: others_changed:=TRUE;
3243: end if;
3236: if (p_ass_attribute16 = hr_api.g_varchar2) then
3237: l_assignment_rec.ass_attribute16 :=
3238: l_old_assignment_rec.ass_attribute16;
3239: if (nvl(l_db_assignment_rec.ass_attribute16, hr_api.g_varchar2) <>
3240: nvl(l_old_assignment_rec.ass_attribute16, hr_api.g_varchar2))
3241: then
3242: others_changed:=TRUE;
3243: end if;
3244: else
3242: others_changed:=TRUE;
3243: end if;
3244: else
3245: l_assignment_rec.ass_attribute16 := p_ass_attribute16;
3246: if (nvl(p_ass_attribute16, hr_api.g_varchar2) <>
3247: nvl(l_db_assignment_rec.ass_attribute16, hr_api.g_varchar2))
3248: then
3249: i_changed:=TRUE;
3250: end if;
3243: end if;
3244: else
3245: l_assignment_rec.ass_attribute16 := p_ass_attribute16;
3246: if (nvl(p_ass_attribute16, hr_api.g_varchar2) <>
3247: nvl(l_db_assignment_rec.ass_attribute16, hr_api.g_varchar2))
3248: then
3249: i_changed:=TRUE;
3250: end if;
3251: end if;
3249: i_changed:=TRUE;
3250: end if;
3251: end if;
3252:
3253: if (p_ass_attribute17 = hr_api.g_varchar2) then
3254: l_assignment_rec.ass_attribute17 :=
3255: l_old_assignment_rec.ass_attribute17;
3256: if (nvl(l_db_assignment_rec.ass_attribute17, hr_api.g_varchar2) <>
3257: nvl(l_old_assignment_rec.ass_attribute17, hr_api.g_varchar2))
3252:
3253: if (p_ass_attribute17 = hr_api.g_varchar2) then
3254: l_assignment_rec.ass_attribute17 :=
3255: l_old_assignment_rec.ass_attribute17;
3256: if (nvl(l_db_assignment_rec.ass_attribute17, hr_api.g_varchar2) <>
3257: nvl(l_old_assignment_rec.ass_attribute17, hr_api.g_varchar2))
3258: then
3259: others_changed:=TRUE;
3260: end if;
3253: if (p_ass_attribute17 = hr_api.g_varchar2) then
3254: l_assignment_rec.ass_attribute17 :=
3255: l_old_assignment_rec.ass_attribute17;
3256: if (nvl(l_db_assignment_rec.ass_attribute17, hr_api.g_varchar2) <>
3257: nvl(l_old_assignment_rec.ass_attribute17, hr_api.g_varchar2))
3258: then
3259: others_changed:=TRUE;
3260: end if;
3261: else
3259: others_changed:=TRUE;
3260: end if;
3261: else
3262: l_assignment_rec.ass_attribute17 := p_ass_attribute17;
3263: if (nvl(p_ass_attribute17, hr_api.g_varchar2) <>
3264: nvl(l_db_assignment_rec.ass_attribute17, hr_api.g_varchar2))
3265: then
3266: i_changed:=TRUE;
3267: end if;
3260: end if;
3261: else
3262: l_assignment_rec.ass_attribute17 := p_ass_attribute17;
3263: if (nvl(p_ass_attribute17, hr_api.g_varchar2) <>
3264: nvl(l_db_assignment_rec.ass_attribute17, hr_api.g_varchar2))
3265: then
3266: i_changed:=TRUE;
3267: end if;
3268: end if;
3266: i_changed:=TRUE;
3267: end if;
3268: end if;
3269:
3270: if (p_ass_attribute18 = hr_api.g_varchar2) then
3271: l_assignment_rec.ass_attribute18 :=
3272: l_old_assignment_rec.ass_attribute18;
3273: if (nvl(l_db_assignment_rec.ass_attribute18, hr_api.g_varchar2) <>
3274: nvl(l_old_assignment_rec.ass_attribute18, hr_api.g_varchar2))
3269:
3270: if (p_ass_attribute18 = hr_api.g_varchar2) then
3271: l_assignment_rec.ass_attribute18 :=
3272: l_old_assignment_rec.ass_attribute18;
3273: if (nvl(l_db_assignment_rec.ass_attribute18, hr_api.g_varchar2) <>
3274: nvl(l_old_assignment_rec.ass_attribute18, hr_api.g_varchar2))
3275: then
3276: others_changed:=TRUE;
3277: end if;
3270: if (p_ass_attribute18 = hr_api.g_varchar2) then
3271: l_assignment_rec.ass_attribute18 :=
3272: l_old_assignment_rec.ass_attribute18;
3273: if (nvl(l_db_assignment_rec.ass_attribute18, hr_api.g_varchar2) <>
3274: nvl(l_old_assignment_rec.ass_attribute18, hr_api.g_varchar2))
3275: then
3276: others_changed:=TRUE;
3277: end if;
3278: else
3276: others_changed:=TRUE;
3277: end if;
3278: else
3279: l_assignment_rec.ass_attribute18 := p_ass_attribute18;
3280: if (nvl(p_ass_attribute18, hr_api.g_varchar2) <>
3281: nvl(l_db_assignment_rec.ass_attribute18, hr_api.g_varchar2))
3282: then
3283: i_changed:=TRUE;
3284: end if;
3277: end if;
3278: else
3279: l_assignment_rec.ass_attribute18 := p_ass_attribute18;
3280: if (nvl(p_ass_attribute18, hr_api.g_varchar2) <>
3281: nvl(l_db_assignment_rec.ass_attribute18, hr_api.g_varchar2))
3282: then
3283: i_changed:=TRUE;
3284: end if;
3285: end if;
3283: i_changed:=TRUE;
3284: end if;
3285: end if;
3286:
3287: if (p_ass_attribute19 = hr_api.g_varchar2) then
3288: l_assignment_rec.ass_attribute19 :=
3289: l_old_assignment_rec.ass_attribute19;
3290: if (nvl(l_db_assignment_rec.ass_attribute19, hr_api.g_varchar2) <>
3291: nvl(l_old_assignment_rec.ass_attribute19, hr_api.g_varchar2))
3286:
3287: if (p_ass_attribute19 = hr_api.g_varchar2) then
3288: l_assignment_rec.ass_attribute19 :=
3289: l_old_assignment_rec.ass_attribute19;
3290: if (nvl(l_db_assignment_rec.ass_attribute19, hr_api.g_varchar2) <>
3291: nvl(l_old_assignment_rec.ass_attribute19, hr_api.g_varchar2))
3292: then
3293: others_changed:=TRUE;
3294: end if;
3287: if (p_ass_attribute19 = hr_api.g_varchar2) then
3288: l_assignment_rec.ass_attribute19 :=
3289: l_old_assignment_rec.ass_attribute19;
3290: if (nvl(l_db_assignment_rec.ass_attribute19, hr_api.g_varchar2) <>
3291: nvl(l_old_assignment_rec.ass_attribute19, hr_api.g_varchar2))
3292: then
3293: others_changed:=TRUE;
3294: end if;
3295: else
3293: others_changed:=TRUE;
3294: end if;
3295: else
3296: l_assignment_rec.ass_attribute19 := p_ass_attribute19;
3297: if (nvl(p_ass_attribute19, hr_api.g_varchar2) <>
3298: nvl(l_db_assignment_rec.ass_attribute19, hr_api.g_varchar2))
3299: then
3300: i_changed:=TRUE;
3301: end if;
3294: end if;
3295: else
3296: l_assignment_rec.ass_attribute19 := p_ass_attribute19;
3297: if (nvl(p_ass_attribute19, hr_api.g_varchar2) <>
3298: nvl(l_db_assignment_rec.ass_attribute19, hr_api.g_varchar2))
3299: then
3300: i_changed:=TRUE;
3301: end if;
3302: end if;
3300: i_changed:=TRUE;
3301: end if;
3302: end if;
3303:
3304: if (p_ass_attribute20 = hr_api.g_varchar2) then
3305: l_assignment_rec.ass_attribute20 :=
3306: l_old_assignment_rec.ass_attribute20;
3307: if (nvl(l_db_assignment_rec.ass_attribute20, hr_api.g_varchar2) <>
3308: nvl(l_old_assignment_rec.ass_attribute20, hr_api.g_varchar2))
3303:
3304: if (p_ass_attribute20 = hr_api.g_varchar2) then
3305: l_assignment_rec.ass_attribute20 :=
3306: l_old_assignment_rec.ass_attribute20;
3307: if (nvl(l_db_assignment_rec.ass_attribute20, hr_api.g_varchar2) <>
3308: nvl(l_old_assignment_rec.ass_attribute20, hr_api.g_varchar2))
3309: then
3310: others_changed:=TRUE;
3311: end if;
3304: if (p_ass_attribute20 = hr_api.g_varchar2) then
3305: l_assignment_rec.ass_attribute20 :=
3306: l_old_assignment_rec.ass_attribute20;
3307: if (nvl(l_db_assignment_rec.ass_attribute20, hr_api.g_varchar2) <>
3308: nvl(l_old_assignment_rec.ass_attribute20, hr_api.g_varchar2))
3309: then
3310: others_changed:=TRUE;
3311: end if;
3312: else
3310: others_changed:=TRUE;
3311: end if;
3312: else
3313: l_assignment_rec.ass_attribute20 := p_ass_attribute20;
3314: if (nvl(p_ass_attribute20, hr_api.g_varchar2) <>
3315: nvl(l_db_assignment_rec.ass_attribute20, hr_api.g_varchar2))
3316: then
3317: i_changed:=TRUE;
3318: end if;
3311: end if;
3312: else
3313: l_assignment_rec.ass_attribute20 := p_ass_attribute20;
3314: if (nvl(p_ass_attribute20, hr_api.g_varchar2) <>
3315: nvl(l_db_assignment_rec.ass_attribute20, hr_api.g_varchar2))
3316: then
3317: i_changed:=TRUE;
3318: end if;
3319: end if;
3317: i_changed:=TRUE;
3318: end if;
3319: end if;
3320:
3321: if (p_ass_attribute21 = hr_api.g_varchar2) then
3322: l_assignment_rec.ass_attribute21 :=
3323: l_old_assignment_rec.ass_attribute21;
3324: if (nvl(l_db_assignment_rec.ass_attribute21, hr_api.g_varchar2) <>
3325: nvl(l_old_assignment_rec.ass_attribute21, hr_api.g_varchar2))
3320:
3321: if (p_ass_attribute21 = hr_api.g_varchar2) then
3322: l_assignment_rec.ass_attribute21 :=
3323: l_old_assignment_rec.ass_attribute21;
3324: if (nvl(l_db_assignment_rec.ass_attribute21, hr_api.g_varchar2) <>
3325: nvl(l_old_assignment_rec.ass_attribute21, hr_api.g_varchar2))
3326: then
3327: others_changed:=TRUE;
3328: end if;
3321: if (p_ass_attribute21 = hr_api.g_varchar2) then
3322: l_assignment_rec.ass_attribute21 :=
3323: l_old_assignment_rec.ass_attribute21;
3324: if (nvl(l_db_assignment_rec.ass_attribute21, hr_api.g_varchar2) <>
3325: nvl(l_old_assignment_rec.ass_attribute21, hr_api.g_varchar2))
3326: then
3327: others_changed:=TRUE;
3328: end if;
3329: else
3327: others_changed:=TRUE;
3328: end if;
3329: else
3330: l_assignment_rec.ass_attribute21 := p_ass_attribute21;
3331: if (nvl(p_ass_attribute21, hr_api.g_varchar2) <>
3332: nvl(l_db_assignment_rec.ass_attribute21, hr_api.g_varchar2))
3333: then
3334: i_changed:=TRUE;
3335: end if;
3328: end if;
3329: else
3330: l_assignment_rec.ass_attribute21 := p_ass_attribute21;
3331: if (nvl(p_ass_attribute21, hr_api.g_varchar2) <>
3332: nvl(l_db_assignment_rec.ass_attribute21, hr_api.g_varchar2))
3333: then
3334: i_changed:=TRUE;
3335: end if;
3336: end if;
3334: i_changed:=TRUE;
3335: end if;
3336: end if;
3337:
3338: if (p_ass_attribute22 = hr_api.g_varchar2) then
3339: l_assignment_rec.ass_attribute22 :=
3340: l_old_assignment_rec.ass_attribute22;
3341: if (nvl(l_db_assignment_rec.ass_attribute22, hr_api.g_varchar2) <>
3342: nvl(l_old_assignment_rec.ass_attribute22, hr_api.g_varchar2))
3337:
3338: if (p_ass_attribute22 = hr_api.g_varchar2) then
3339: l_assignment_rec.ass_attribute22 :=
3340: l_old_assignment_rec.ass_attribute22;
3341: if (nvl(l_db_assignment_rec.ass_attribute22, hr_api.g_varchar2) <>
3342: nvl(l_old_assignment_rec.ass_attribute22, hr_api.g_varchar2))
3343: then
3344: others_changed:=TRUE;
3345: end if;
3338: if (p_ass_attribute22 = hr_api.g_varchar2) then
3339: l_assignment_rec.ass_attribute22 :=
3340: l_old_assignment_rec.ass_attribute22;
3341: if (nvl(l_db_assignment_rec.ass_attribute22, hr_api.g_varchar2) <>
3342: nvl(l_old_assignment_rec.ass_attribute22, hr_api.g_varchar2))
3343: then
3344: others_changed:=TRUE;
3345: end if;
3346: else
3344: others_changed:=TRUE;
3345: end if;
3346: else
3347: l_assignment_rec.ass_attribute22 := p_ass_attribute22;
3348: if (nvl(p_ass_attribute22, hr_api.g_varchar2) <>
3349: nvl(l_db_assignment_rec.ass_attribute22, hr_api.g_varchar2))
3350: then
3351: i_changed:=TRUE;
3352: end if;
3345: end if;
3346: else
3347: l_assignment_rec.ass_attribute22 := p_ass_attribute22;
3348: if (nvl(p_ass_attribute22, hr_api.g_varchar2) <>
3349: nvl(l_db_assignment_rec.ass_attribute22, hr_api.g_varchar2))
3350: then
3351: i_changed:=TRUE;
3352: end if;
3353: end if;
3351: i_changed:=TRUE;
3352: end if;
3353: end if;
3354:
3355: if (p_ass_attribute23 = hr_api.g_varchar2) then
3356: l_assignment_rec.ass_attribute23 :=
3357: l_old_assignment_rec.ass_attribute23;
3358: if (nvl(l_db_assignment_rec.ass_attribute23, hr_api.g_varchar2) <>
3359: nvl(l_old_assignment_rec.ass_attribute23, hr_api.g_varchar2))
3354:
3355: if (p_ass_attribute23 = hr_api.g_varchar2) then
3356: l_assignment_rec.ass_attribute23 :=
3357: l_old_assignment_rec.ass_attribute23;
3358: if (nvl(l_db_assignment_rec.ass_attribute23, hr_api.g_varchar2) <>
3359: nvl(l_old_assignment_rec.ass_attribute23, hr_api.g_varchar2))
3360: then
3361: others_changed:=TRUE;
3362: end if;
3355: if (p_ass_attribute23 = hr_api.g_varchar2) then
3356: l_assignment_rec.ass_attribute23 :=
3357: l_old_assignment_rec.ass_attribute23;
3358: if (nvl(l_db_assignment_rec.ass_attribute23, hr_api.g_varchar2) <>
3359: nvl(l_old_assignment_rec.ass_attribute23, hr_api.g_varchar2))
3360: then
3361: others_changed:=TRUE;
3362: end if;
3363: else
3361: others_changed:=TRUE;
3362: end if;
3363: else
3364: l_assignment_rec.ass_attribute23 := p_ass_attribute23;
3365: if (nvl(p_ass_attribute23, hr_api.g_varchar2) <>
3366: nvl(l_db_assignment_rec.ass_attribute23, hr_api.g_varchar2))
3367: then
3368: i_changed:=TRUE;
3369: end if;
3362: end if;
3363: else
3364: l_assignment_rec.ass_attribute23 := p_ass_attribute23;
3365: if (nvl(p_ass_attribute23, hr_api.g_varchar2) <>
3366: nvl(l_db_assignment_rec.ass_attribute23, hr_api.g_varchar2))
3367: then
3368: i_changed:=TRUE;
3369: end if;
3370: end if;
3368: i_changed:=TRUE;
3369: end if;
3370: end if;
3371:
3372: if (p_ass_attribute24 = hr_api.g_varchar2) then
3373: l_assignment_rec.ass_attribute24 :=
3374: l_old_assignment_rec.ass_attribute24;
3375: if (nvl(l_db_assignment_rec.ass_attribute24, hr_api.g_varchar2) <>
3376: nvl(l_old_assignment_rec.ass_attribute24, hr_api.g_varchar2))
3371:
3372: if (p_ass_attribute24 = hr_api.g_varchar2) then
3373: l_assignment_rec.ass_attribute24 :=
3374: l_old_assignment_rec.ass_attribute24;
3375: if (nvl(l_db_assignment_rec.ass_attribute24, hr_api.g_varchar2) <>
3376: nvl(l_old_assignment_rec.ass_attribute24, hr_api.g_varchar2))
3377: then
3378: others_changed:=TRUE;
3379: end if;
3372: if (p_ass_attribute24 = hr_api.g_varchar2) then
3373: l_assignment_rec.ass_attribute24 :=
3374: l_old_assignment_rec.ass_attribute24;
3375: if (nvl(l_db_assignment_rec.ass_attribute24, hr_api.g_varchar2) <>
3376: nvl(l_old_assignment_rec.ass_attribute24, hr_api.g_varchar2))
3377: then
3378: others_changed:=TRUE;
3379: end if;
3380: else
3378: others_changed:=TRUE;
3379: end if;
3380: else
3381: l_assignment_rec.ass_attribute24 := p_ass_attribute24;
3382: if (nvl(p_ass_attribute24, hr_api.g_varchar2) <>
3383: nvl(l_db_assignment_rec.ass_attribute24, hr_api.g_varchar2))
3384: then
3385: i_changed:=TRUE;
3386: end if;
3379: end if;
3380: else
3381: l_assignment_rec.ass_attribute24 := p_ass_attribute24;
3382: if (nvl(p_ass_attribute24, hr_api.g_varchar2) <>
3383: nvl(l_db_assignment_rec.ass_attribute24, hr_api.g_varchar2))
3384: then
3385: i_changed:=TRUE;
3386: end if;
3387: end if;
3385: i_changed:=TRUE;
3386: end if;
3387: end if;
3388:
3389: if (p_ass_attribute25 = hr_api.g_varchar2) then
3390: l_assignment_rec.ass_attribute25 :=
3391: l_old_assignment_rec.ass_attribute25;
3392: if (nvl(l_db_assignment_rec.ass_attribute25, hr_api.g_varchar2) <>
3393: nvl(l_old_assignment_rec.ass_attribute25, hr_api.g_varchar2))
3388:
3389: if (p_ass_attribute25 = hr_api.g_varchar2) then
3390: l_assignment_rec.ass_attribute25 :=
3391: l_old_assignment_rec.ass_attribute25;
3392: if (nvl(l_db_assignment_rec.ass_attribute25, hr_api.g_varchar2) <>
3393: nvl(l_old_assignment_rec.ass_attribute25, hr_api.g_varchar2))
3394: then
3395: others_changed:=TRUE;
3396: end if;
3389: if (p_ass_attribute25 = hr_api.g_varchar2) then
3390: l_assignment_rec.ass_attribute25 :=
3391: l_old_assignment_rec.ass_attribute25;
3392: if (nvl(l_db_assignment_rec.ass_attribute25, hr_api.g_varchar2) <>
3393: nvl(l_old_assignment_rec.ass_attribute25, hr_api.g_varchar2))
3394: then
3395: others_changed:=TRUE;
3396: end if;
3397: else
3395: others_changed:=TRUE;
3396: end if;
3397: else
3398: l_assignment_rec.ass_attribute25 := p_ass_attribute25;
3399: if (nvl(p_ass_attribute25, hr_api.g_varchar2) <>
3400: nvl(l_db_assignment_rec.ass_attribute25, hr_api.g_varchar2))
3401: then
3402: i_changed:=TRUE;
3403: end if;
3396: end if;
3397: else
3398: l_assignment_rec.ass_attribute25 := p_ass_attribute25;
3399: if (nvl(p_ass_attribute25, hr_api.g_varchar2) <>
3400: nvl(l_db_assignment_rec.ass_attribute25, hr_api.g_varchar2))
3401: then
3402: i_changed:=TRUE;
3403: end if;
3404: end if;
3402: i_changed:=TRUE;
3403: end if;
3404: end if;
3405:
3406: if (p_ass_attribute26 = hr_api.g_varchar2) then
3407: l_assignment_rec.ass_attribute26 :=
3408: l_old_assignment_rec.ass_attribute26;
3409: if (nvl(l_db_assignment_rec.ass_attribute26, hr_api.g_varchar2) <>
3410: nvl(l_old_assignment_rec.ass_attribute26, hr_api.g_varchar2))
3405:
3406: if (p_ass_attribute26 = hr_api.g_varchar2) then
3407: l_assignment_rec.ass_attribute26 :=
3408: l_old_assignment_rec.ass_attribute26;
3409: if (nvl(l_db_assignment_rec.ass_attribute26, hr_api.g_varchar2) <>
3410: nvl(l_old_assignment_rec.ass_attribute26, hr_api.g_varchar2))
3411: then
3412: others_changed:=TRUE;
3413: end if;
3406: if (p_ass_attribute26 = hr_api.g_varchar2) then
3407: l_assignment_rec.ass_attribute26 :=
3408: l_old_assignment_rec.ass_attribute26;
3409: if (nvl(l_db_assignment_rec.ass_attribute26, hr_api.g_varchar2) <>
3410: nvl(l_old_assignment_rec.ass_attribute26, hr_api.g_varchar2))
3411: then
3412: others_changed:=TRUE;
3413: end if;
3414: else
3412: others_changed:=TRUE;
3413: end if;
3414: else
3415: l_assignment_rec.ass_attribute26 := p_ass_attribute26;
3416: if (nvl(p_ass_attribute26, hr_api.g_varchar2) <>
3417: nvl(l_db_assignment_rec.ass_attribute26, hr_api.g_varchar2))
3418: then
3419: i_changed:=TRUE;
3420: end if;
3413: end if;
3414: else
3415: l_assignment_rec.ass_attribute26 := p_ass_attribute26;
3416: if (nvl(p_ass_attribute26, hr_api.g_varchar2) <>
3417: nvl(l_db_assignment_rec.ass_attribute26, hr_api.g_varchar2))
3418: then
3419: i_changed:=TRUE;
3420: end if;
3421: end if;
3419: i_changed:=TRUE;
3420: end if;
3421: end if;
3422:
3423: if (p_ass_attribute27 = hr_api.g_varchar2) then
3424: l_assignment_rec.ass_attribute27 :=
3425: l_old_assignment_rec.ass_attribute27;
3426: if (nvl(l_db_assignment_rec.ass_attribute27, hr_api.g_varchar2) <>
3427: nvl(l_old_assignment_rec.ass_attribute27, hr_api.g_varchar2))
3422:
3423: if (p_ass_attribute27 = hr_api.g_varchar2) then
3424: l_assignment_rec.ass_attribute27 :=
3425: l_old_assignment_rec.ass_attribute27;
3426: if (nvl(l_db_assignment_rec.ass_attribute27, hr_api.g_varchar2) <>
3427: nvl(l_old_assignment_rec.ass_attribute27, hr_api.g_varchar2))
3428: then
3429: others_changed:=TRUE;
3430: end if;
3423: if (p_ass_attribute27 = hr_api.g_varchar2) then
3424: l_assignment_rec.ass_attribute27 :=
3425: l_old_assignment_rec.ass_attribute27;
3426: if (nvl(l_db_assignment_rec.ass_attribute27, hr_api.g_varchar2) <>
3427: nvl(l_old_assignment_rec.ass_attribute27, hr_api.g_varchar2))
3428: then
3429: others_changed:=TRUE;
3430: end if;
3431: else
3429: others_changed:=TRUE;
3430: end if;
3431: else
3432: l_assignment_rec.ass_attribute27 := p_ass_attribute27;
3433: if (nvl(p_ass_attribute27, hr_api.g_varchar2) <>
3434: nvl(l_db_assignment_rec.ass_attribute27, hr_api.g_varchar2))
3435: then
3436: i_changed:=TRUE;
3437: end if;
3430: end if;
3431: else
3432: l_assignment_rec.ass_attribute27 := p_ass_attribute27;
3433: if (nvl(p_ass_attribute27, hr_api.g_varchar2) <>
3434: nvl(l_db_assignment_rec.ass_attribute27, hr_api.g_varchar2))
3435: then
3436: i_changed:=TRUE;
3437: end if;
3438: end if;
3436: i_changed:=TRUE;
3437: end if;
3438: end if;
3439:
3440: if (p_ass_attribute28 = hr_api.g_varchar2) then
3441: l_assignment_rec.ass_attribute28 :=
3442: l_old_assignment_rec.ass_attribute28;
3443: if (nvl(l_db_assignment_rec.ass_attribute28, hr_api.g_varchar2) <>
3444: nvl(l_old_assignment_rec.ass_attribute28, hr_api.g_varchar2))
3439:
3440: if (p_ass_attribute28 = hr_api.g_varchar2) then
3441: l_assignment_rec.ass_attribute28 :=
3442: l_old_assignment_rec.ass_attribute28;
3443: if (nvl(l_db_assignment_rec.ass_attribute28, hr_api.g_varchar2) <>
3444: nvl(l_old_assignment_rec.ass_attribute28, hr_api.g_varchar2))
3445: then
3446: others_changed:=TRUE;
3447: end if;
3440: if (p_ass_attribute28 = hr_api.g_varchar2) then
3441: l_assignment_rec.ass_attribute28 :=
3442: l_old_assignment_rec.ass_attribute28;
3443: if (nvl(l_db_assignment_rec.ass_attribute28, hr_api.g_varchar2) <>
3444: nvl(l_old_assignment_rec.ass_attribute28, hr_api.g_varchar2))
3445: then
3446: others_changed:=TRUE;
3447: end if;
3448: else
3446: others_changed:=TRUE;
3447: end if;
3448: else
3449: l_assignment_rec.ass_attribute28 := p_ass_attribute28;
3450: if (nvl(p_ass_attribute28, hr_api.g_varchar2) <>
3451: nvl(l_db_assignment_rec.ass_attribute28, hr_api.g_varchar2))
3452: then
3453: i_changed:=TRUE;
3454: end if;
3447: end if;
3448: else
3449: l_assignment_rec.ass_attribute28 := p_ass_attribute28;
3450: if (nvl(p_ass_attribute28, hr_api.g_varchar2) <>
3451: nvl(l_db_assignment_rec.ass_attribute28, hr_api.g_varchar2))
3452: then
3453: i_changed:=TRUE;
3454: end if;
3455: end if;
3453: i_changed:=TRUE;
3454: end if;
3455: end if;
3456:
3457: if (p_ass_attribute29 = hr_api.g_varchar2) then
3458: l_assignment_rec.ass_attribute29 :=
3459: l_old_assignment_rec.ass_attribute29;
3460: if (nvl(l_db_assignment_rec.ass_attribute29, hr_api.g_varchar2) <>
3461: nvl(l_old_assignment_rec.ass_attribute29, hr_api.g_varchar2))
3456:
3457: if (p_ass_attribute29 = hr_api.g_varchar2) then
3458: l_assignment_rec.ass_attribute29 :=
3459: l_old_assignment_rec.ass_attribute29;
3460: if (nvl(l_db_assignment_rec.ass_attribute29, hr_api.g_varchar2) <>
3461: nvl(l_old_assignment_rec.ass_attribute29, hr_api.g_varchar2))
3462: then
3463: others_changed:=TRUE;
3464: end if;
3457: if (p_ass_attribute29 = hr_api.g_varchar2) then
3458: l_assignment_rec.ass_attribute29 :=
3459: l_old_assignment_rec.ass_attribute29;
3460: if (nvl(l_db_assignment_rec.ass_attribute29, hr_api.g_varchar2) <>
3461: nvl(l_old_assignment_rec.ass_attribute29, hr_api.g_varchar2))
3462: then
3463: others_changed:=TRUE;
3464: end if;
3465: else
3463: others_changed:=TRUE;
3464: end if;
3465: else
3466: l_assignment_rec.ass_attribute29 := p_ass_attribute29;
3467: if (nvl(p_ass_attribute29, hr_api.g_varchar2) <>
3468: nvl(l_db_assignment_rec.ass_attribute29, hr_api.g_varchar2))
3469: then
3470: i_changed:=TRUE;
3471: end if;
3464: end if;
3465: else
3466: l_assignment_rec.ass_attribute29 := p_ass_attribute29;
3467: if (nvl(p_ass_attribute29, hr_api.g_varchar2) <>
3468: nvl(l_db_assignment_rec.ass_attribute29, hr_api.g_varchar2))
3469: then
3470: i_changed:=TRUE;
3471: end if;
3472: end if;
3470: i_changed:=TRUE;
3471: end if;
3472: end if;
3473:
3474: if (p_ass_attribute30 = hr_api.g_varchar2) then
3475: l_assignment_rec.ass_attribute30 :=
3476: l_old_assignment_rec.ass_attribute30;
3477: if (nvl(l_db_assignment_rec.ass_attribute30, hr_api.g_varchar2) <>
3478: nvl(l_old_assignment_rec.ass_attribute30, hr_api.g_varchar2))
3473:
3474: if (p_ass_attribute30 = hr_api.g_varchar2) then
3475: l_assignment_rec.ass_attribute30 :=
3476: l_old_assignment_rec.ass_attribute30;
3477: if (nvl(l_db_assignment_rec.ass_attribute30, hr_api.g_varchar2) <>
3478: nvl(l_old_assignment_rec.ass_attribute30, hr_api.g_varchar2))
3479: then
3480: others_changed:=TRUE;
3481: end if;
3474: if (p_ass_attribute30 = hr_api.g_varchar2) then
3475: l_assignment_rec.ass_attribute30 :=
3476: l_old_assignment_rec.ass_attribute30;
3477: if (nvl(l_db_assignment_rec.ass_attribute30, hr_api.g_varchar2) <>
3478: nvl(l_old_assignment_rec.ass_attribute30, hr_api.g_varchar2))
3479: then
3480: others_changed:=TRUE;
3481: end if;
3482: else
3480: others_changed:=TRUE;
3481: end if;
3482: else
3483: l_assignment_rec.ass_attribute30 := p_ass_attribute30;
3484: if (nvl(p_ass_attribute30, hr_api.g_varchar2) <>
3485: nvl(l_db_assignment_rec.ass_attribute30, hr_api.g_varchar2))
3486: then
3487: i_changed:=TRUE;
3488: end if;
3481: end if;
3482: else
3483: l_assignment_rec.ass_attribute30 := p_ass_attribute30;
3484: if (nvl(p_ass_attribute30, hr_api.g_varchar2) <>
3485: nvl(l_db_assignment_rec.ass_attribute30, hr_api.g_varchar2))
3486: then
3487: i_changed:=TRUE;
3488: end if;
3489: end if;
3487: i_changed:=TRUE;
3488: end if;
3489: end if;
3490:
3491: if (p_people_group_id = hr_api.g_number) then
3492: l_assignment_rec.people_group_id :=
3493: l_old_assignment_rec.people_group_id;
3494: if nvl(l_old_assignment_rec.people_group_id, hr_api.g_number)
3495: <> nvl(l_db_assignment_rec.people_group_id, hr_api.g_number)
3490:
3491: if (p_people_group_id = hr_api.g_number) then
3492: l_assignment_rec.people_group_id :=
3493: l_old_assignment_rec.people_group_id;
3494: if nvl(l_old_assignment_rec.people_group_id, hr_api.g_number)
3495: <> nvl(l_db_assignment_rec.people_group_id, hr_api.g_number)
3496: then
3497: others_changed:=TRUE;
3498: end if;
3491: if (p_people_group_id = hr_api.g_number) then
3492: l_assignment_rec.people_group_id :=
3493: l_old_assignment_rec.people_group_id;
3494: if nvl(l_old_assignment_rec.people_group_id, hr_api.g_number)
3495: <> nvl(l_db_assignment_rec.people_group_id, hr_api.g_number)
3496: then
3497: others_changed:=TRUE;
3498: end if;
3499: else
3504: i_changed:=TRUE;
3505: end if;
3506: end if;
3507:
3508: if (p_soft_coding_keyflex_id = hr_api.g_number) then
3509: l_assignment_rec.soft_coding_keyflex_id :=
3510: l_old_assignment_rec.soft_coding_keyflex_id;
3511: if nvl(l_old_assignment_rec.soft_coding_keyflex_id, hr_api.g_number)
3512: <> nvl(l_db_assignment_rec.soft_coding_keyflex_id, hr_api.g_number)
3507:
3508: if (p_soft_coding_keyflex_id = hr_api.g_number) then
3509: l_assignment_rec.soft_coding_keyflex_id :=
3510: l_old_assignment_rec.soft_coding_keyflex_id;
3511: if nvl(l_old_assignment_rec.soft_coding_keyflex_id, hr_api.g_number)
3512: <> nvl(l_db_assignment_rec.soft_coding_keyflex_id, hr_api.g_number)
3513: then
3514: others_changed:=TRUE;
3515: end if;
3508: if (p_soft_coding_keyflex_id = hr_api.g_number) then
3509: l_assignment_rec.soft_coding_keyflex_id :=
3510: l_old_assignment_rec.soft_coding_keyflex_id;
3511: if nvl(l_old_assignment_rec.soft_coding_keyflex_id, hr_api.g_number)
3512: <> nvl(l_db_assignment_rec.soft_coding_keyflex_id, hr_api.g_number)
3513: then
3514: others_changed:=TRUE;
3515: end if;
3516: else
3521: i_changed:=TRUE;
3522: end if;
3523: end if;
3524:
3525: if (p_sal_review_period_frequency = hr_api.g_varchar2) then
3526: l_assignment_rec.sal_review_period_frequency :=
3527: l_old_assignment_rec.sal_review_period_frequency;
3528: if (nvl(l_db_assignment_rec.sal_review_period_frequency, hr_api.g_varchar2)
3529: <>
3524:
3525: if (p_sal_review_period_frequency = hr_api.g_varchar2) then
3526: l_assignment_rec.sal_review_period_frequency :=
3527: l_old_assignment_rec.sal_review_period_frequency;
3528: if (nvl(l_db_assignment_rec.sal_review_period_frequency, hr_api.g_varchar2)
3529: <>
3530: nvl(l_old_assignment_rec.sal_review_period_frequency, hr_api.g_varchar2))
3531: then
3532: others_changed:=TRUE;
3526: l_assignment_rec.sal_review_period_frequency :=
3527: l_old_assignment_rec.sal_review_period_frequency;
3528: if (nvl(l_db_assignment_rec.sal_review_period_frequency, hr_api.g_varchar2)
3529: <>
3530: nvl(l_old_assignment_rec.sal_review_period_frequency, hr_api.g_varchar2))
3531: then
3532: others_changed:=TRUE;
3533: end if;
3534: else
3533: end if;
3534: else
3535: l_assignment_rec.sal_review_period_frequency :=
3536: p_sal_review_period_frequency;
3537: if (nvl(p_sal_review_period_frequency, hr_api.g_varchar2) <>
3538: nvl(l_db_assignment_rec.sal_review_period_frequency, hr_api.g_varchar2))
3539: then
3540: i_changed:=TRUE;
3541: end if;
3534: else
3535: l_assignment_rec.sal_review_period_frequency :=
3536: p_sal_review_period_frequency;
3537: if (nvl(p_sal_review_period_frequency, hr_api.g_varchar2) <>
3538: nvl(l_db_assignment_rec.sal_review_period_frequency, hr_api.g_varchar2))
3539: then
3540: i_changed:=TRUE;
3541: end if;
3542: end if;
3540: i_changed:=TRUE;
3541: end if;
3542: end if;
3543:
3544: if (p_sal_review_period = hr_api.g_number) then
3545: l_assignment_rec.sal_review_period :=
3546: l_old_assignment_rec.sal_review_period;
3547: if nvl(l_old_assignment_rec.sal_review_period, hr_api.g_number)
3548: <> nvl(l_db_assignment_rec.sal_review_period, hr_api.g_number)
3543:
3544: if (p_sal_review_period = hr_api.g_number) then
3545: l_assignment_rec.sal_review_period :=
3546: l_old_assignment_rec.sal_review_period;
3547: if nvl(l_old_assignment_rec.sal_review_period, hr_api.g_number)
3548: <> nvl(l_db_assignment_rec.sal_review_period, hr_api.g_number)
3549: then
3550: others_changed:=TRUE;
3551: end if;
3544: if (p_sal_review_period = hr_api.g_number) then
3545: l_assignment_rec.sal_review_period :=
3546: l_old_assignment_rec.sal_review_period;
3547: if nvl(l_old_assignment_rec.sal_review_period, hr_api.g_number)
3548: <> nvl(l_db_assignment_rec.sal_review_period, hr_api.g_number)
3549: then
3550: others_changed:=TRUE;
3551: end if;
3552: else
3557: i_changed:=TRUE;
3558: end if;
3559: end if;
3560:
3561: if (p_probation_period = hr_api.g_number) then
3562: l_assignment_rec.probation_period :=
3563: l_old_assignment_rec.probation_period;
3564: if nvl(l_old_assignment_rec.probation_period, hr_api.g_number)
3565: <> nvl(l_db_assignment_rec.probation_period, hr_api.g_number)
3560:
3561: if (p_probation_period = hr_api.g_number) then
3562: l_assignment_rec.probation_period :=
3563: l_old_assignment_rec.probation_period;
3564: if nvl(l_old_assignment_rec.probation_period, hr_api.g_number)
3565: <> nvl(l_db_assignment_rec.probation_period, hr_api.g_number)
3566: then
3567: others_changed:=TRUE;
3568: end if;
3561: if (p_probation_period = hr_api.g_number) then
3562: l_assignment_rec.probation_period :=
3563: l_old_assignment_rec.probation_period;
3564: if nvl(l_old_assignment_rec.probation_period, hr_api.g_number)
3565: <> nvl(l_db_assignment_rec.probation_period, hr_api.g_number)
3566: then
3567: others_changed:=TRUE;
3568: end if;
3569: else
3574: i_changed:=TRUE;
3575: end if;
3576: end if;
3577:
3578: if (to_char(p_date_probation_end) = to_char(hr_api.g_date)) then
3579: l_assignment_rec.date_probation_end :=
3580: l_old_assignment_rec.date_probation_end;
3581:
3582: if (nvl(l_db_assignment_rec.date_probation_end, hr_api.g_date)
3578: if (to_char(p_date_probation_end) = to_char(hr_api.g_date)) then
3579: l_assignment_rec.date_probation_end :=
3580: l_old_assignment_rec.date_probation_end;
3581:
3582: if (nvl(l_db_assignment_rec.date_probation_end, hr_api.g_date)
3583: <>
3584: nvl(l_old_assignment_rec.date_probation_end, hr_api.g_date))
3585: then
3586: others_changed:=TRUE;
3580: l_old_assignment_rec.date_probation_end;
3581:
3582: if (nvl(l_db_assignment_rec.date_probation_end, hr_api.g_date)
3583: <>
3584: nvl(l_old_assignment_rec.date_probation_end, hr_api.g_date))
3585: then
3586: others_changed:=TRUE;
3587: end if;
3588: else
3587: end if;
3588: else
3589: l_assignment_rec.date_probation_end :=
3590: p_date_probation_end;
3591: if (nvl(p_date_probation_end, hr_api.g_date) <>
3592: nvl(l_db_assignment_rec.date_probation_end, hr_api.g_date))
3593: then
3594: i_changed:=TRUE;
3595: end if;
3588: else
3589: l_assignment_rec.date_probation_end :=
3590: p_date_probation_end;
3591: if (nvl(p_date_probation_end, hr_api.g_date) <>
3592: nvl(l_db_assignment_rec.date_probation_end, hr_api.g_date))
3593: then
3594: i_changed:=TRUE;
3595: end if;
3596: end if;
3594: i_changed:=TRUE;
3595: end if;
3596: end if;
3597:
3598: if (p_probation_unit = hr_api.g_varchar2) then
3599: l_assignment_rec.probation_unit :=
3600: l_old_assignment_rec.probation_unit;
3601: if (nvl(l_db_assignment_rec.probation_unit, hr_api.g_varchar2)
3602: <>
3597:
3598: if (p_probation_unit = hr_api.g_varchar2) then
3599: l_assignment_rec.probation_unit :=
3600: l_old_assignment_rec.probation_unit;
3601: if (nvl(l_db_assignment_rec.probation_unit, hr_api.g_varchar2)
3602: <>
3603: nvl(l_old_assignment_rec.probation_unit, hr_api.g_varchar2))
3604: then
3605: others_changed:=TRUE;
3599: l_assignment_rec.probation_unit :=
3600: l_old_assignment_rec.probation_unit;
3601: if (nvl(l_db_assignment_rec.probation_unit, hr_api.g_varchar2)
3602: <>
3603: nvl(l_old_assignment_rec.probation_unit, hr_api.g_varchar2))
3604: then
3605: others_changed:=TRUE;
3606: end if;
3607: else
3606: end if;
3607: else
3608: l_assignment_rec.probation_unit :=
3609: p_probation_unit;
3610: if (nvl(p_probation_unit, hr_api.g_varchar2) <>
3611: nvl(l_db_assignment_rec.probation_unit, hr_api.g_varchar2))
3612: then
3613: i_changed:=TRUE;
3614: end if;
3607: else
3608: l_assignment_rec.probation_unit :=
3609: p_probation_unit;
3610: if (nvl(p_probation_unit, hr_api.g_varchar2) <>
3611: nvl(l_db_assignment_rec.probation_unit, hr_api.g_varchar2))
3612: then
3613: i_changed:=TRUE;
3614: end if;
3615: end if;
3613: i_changed:=TRUE;
3614: end if;
3615: end if;
3616:
3617: if (p_notice_period = hr_api.g_number) then
3618: l_assignment_rec.notice_period :=
3619: l_old_assignment_rec.notice_period;
3620: if nvl(l_old_assignment_rec.notice_period, hr_api.g_number)
3621: <> nvl(l_db_assignment_rec.notice_period, hr_api.g_number)
3616:
3617: if (p_notice_period = hr_api.g_number) then
3618: l_assignment_rec.notice_period :=
3619: l_old_assignment_rec.notice_period;
3620: if nvl(l_old_assignment_rec.notice_period, hr_api.g_number)
3621: <> nvl(l_db_assignment_rec.notice_period, hr_api.g_number)
3622: then
3623: others_changed:=TRUE;
3624: end if;
3617: if (p_notice_period = hr_api.g_number) then
3618: l_assignment_rec.notice_period :=
3619: l_old_assignment_rec.notice_period;
3620: if nvl(l_old_assignment_rec.notice_period, hr_api.g_number)
3621: <> nvl(l_db_assignment_rec.notice_period, hr_api.g_number)
3622: then
3623: others_changed:=TRUE;
3624: end if;
3625: else
3630: i_changed:=TRUE;
3631: end if;
3632: end if;
3633:
3634: if (p_notice_period_uom = hr_api.g_varchar2) then
3635: l_assignment_rec.notice_period_uom :=
3636: l_old_assignment_rec.notice_period_uom;
3637: if (nvl(l_db_assignment_rec.notice_period_uom, hr_api.g_varchar2)
3638: <>
3633:
3634: if (p_notice_period_uom = hr_api.g_varchar2) then
3635: l_assignment_rec.notice_period_uom :=
3636: l_old_assignment_rec.notice_period_uom;
3637: if (nvl(l_db_assignment_rec.notice_period_uom, hr_api.g_varchar2)
3638: <>
3639: nvl(l_old_assignment_rec.notice_period_uom, hr_api.g_varchar2))
3640: then
3641: others_changed:=TRUE;
3635: l_assignment_rec.notice_period_uom :=
3636: l_old_assignment_rec.notice_period_uom;
3637: if (nvl(l_db_assignment_rec.notice_period_uom, hr_api.g_varchar2)
3638: <>
3639: nvl(l_old_assignment_rec.notice_period_uom, hr_api.g_varchar2))
3640: then
3641: others_changed:=TRUE;
3642: end if;
3643: else
3642: end if;
3643: else
3644: l_assignment_rec.notice_period_uom :=
3645: p_notice_period_uom;
3646: if (nvl(p_notice_period_uom, hr_api.g_varchar2) <>
3647: nvl(l_db_assignment_rec.notice_period_uom, hr_api.g_varchar2))
3648: then
3649: i_changed:=TRUE;
3650: end if;
3643: else
3644: l_assignment_rec.notice_period_uom :=
3645: p_notice_period_uom;
3646: if (nvl(p_notice_period_uom, hr_api.g_varchar2) <>
3647: nvl(l_db_assignment_rec.notice_period_uom, hr_api.g_varchar2))
3648: then
3649: i_changed:=TRUE;
3650: end if;
3651: end if;
3649: i_changed:=TRUE;
3650: end if;
3651: end if;
3652:
3653: if (p_employee_category = hr_api.g_varchar2) then
3654: l_assignment_rec.employee_category :=
3655: l_old_assignment_rec.employee_category;
3656: if (nvl(l_db_assignment_rec.employee_category, hr_api.g_varchar2)
3657: <>
3652:
3653: if (p_employee_category = hr_api.g_varchar2) then
3654: l_assignment_rec.employee_category :=
3655: l_old_assignment_rec.employee_category;
3656: if (nvl(l_db_assignment_rec.employee_category, hr_api.g_varchar2)
3657: <>
3658: nvl(l_old_assignment_rec.employee_category, hr_api.g_varchar2))
3659: then
3660: others_changed:=TRUE;
3654: l_assignment_rec.employee_category :=
3655: l_old_assignment_rec.employee_category;
3656: if (nvl(l_db_assignment_rec.employee_category, hr_api.g_varchar2)
3657: <>
3658: nvl(l_old_assignment_rec.employee_category, hr_api.g_varchar2))
3659: then
3660: others_changed:=TRUE;
3661: end if;
3662: else
3661: end if;
3662: else
3663: l_assignment_rec.employee_category :=
3664: p_employee_category;
3665: if (nvl(p_employee_category, hr_api.g_varchar2) <>
3666: nvl(l_db_assignment_rec.employee_category, hr_api.g_varchar2))
3667: then
3668: i_changed:=TRUE;
3669: end if;
3662: else
3663: l_assignment_rec.employee_category :=
3664: p_employee_category;
3665: if (nvl(p_employee_category, hr_api.g_varchar2) <>
3666: nvl(l_db_assignment_rec.employee_category, hr_api.g_varchar2))
3667: then
3668: i_changed:=TRUE;
3669: end if;
3670: end if;
3668: i_changed:=TRUE;
3669: end if;
3670: end if;
3671:
3672: if (p_work_at_home = hr_api.g_varchar2) then
3673: l_assignment_rec.work_at_home :=
3674: l_old_assignment_rec.work_at_home;
3675: if (nvl(l_db_assignment_rec.work_at_home, hr_api.g_varchar2)
3676: <>
3671:
3672: if (p_work_at_home = hr_api.g_varchar2) then
3673: l_assignment_rec.work_at_home :=
3674: l_old_assignment_rec.work_at_home;
3675: if (nvl(l_db_assignment_rec.work_at_home, hr_api.g_varchar2)
3676: <>
3677: nvl(l_old_assignment_rec.work_at_home, hr_api.g_varchar2))
3678: then
3679: others_changed:=TRUE;
3673: l_assignment_rec.work_at_home :=
3674: l_old_assignment_rec.work_at_home;
3675: if (nvl(l_db_assignment_rec.work_at_home, hr_api.g_varchar2)
3676: <>
3677: nvl(l_old_assignment_rec.work_at_home, hr_api.g_varchar2))
3678: then
3679: others_changed:=TRUE;
3680: end if;
3681: else
3680: end if;
3681: else
3682: l_assignment_rec.work_at_home :=
3683: p_work_at_home;
3684: if (nvl(p_work_at_home, hr_api.g_varchar2) <>
3685: nvl(l_db_assignment_rec.work_at_home, hr_api.g_varchar2))
3686: then
3687: i_changed:=TRUE;
3688: end if;
3681: else
3682: l_assignment_rec.work_at_home :=
3683: p_work_at_home;
3684: if (nvl(p_work_at_home, hr_api.g_varchar2) <>
3685: nvl(l_db_assignment_rec.work_at_home, hr_api.g_varchar2))
3686: then
3687: i_changed:=TRUE;
3688: end if;
3689: end if;
3687: i_changed:=TRUE;
3688: end if;
3689: end if;
3690:
3691: if (p_job_post_source_name = hr_api.g_varchar2) then
3692: l_assignment_rec.job_post_source_name :=
3693: l_old_assignment_rec.job_post_source_name;
3694: if (nvl(l_db_assignment_rec.job_post_source_name, hr_api.g_varchar2)
3695: <>
3690:
3691: if (p_job_post_source_name = hr_api.g_varchar2) then
3692: l_assignment_rec.job_post_source_name :=
3693: l_old_assignment_rec.job_post_source_name;
3694: if (nvl(l_db_assignment_rec.job_post_source_name, hr_api.g_varchar2)
3695: <>
3696: nvl(l_old_assignment_rec.job_post_source_name, hr_api.g_varchar2))
3697: then
3698: others_changed:=TRUE;
3692: l_assignment_rec.job_post_source_name :=
3693: l_old_assignment_rec.job_post_source_name;
3694: if (nvl(l_db_assignment_rec.job_post_source_name, hr_api.g_varchar2)
3695: <>
3696: nvl(l_old_assignment_rec.job_post_source_name, hr_api.g_varchar2))
3697: then
3698: others_changed:=TRUE;
3699: end if;
3700: else
3699: end if;
3700: else
3701: l_assignment_rec.job_post_source_name :=
3702: p_job_post_source_name;
3703: if (nvl(p_job_post_source_name, hr_api.g_varchar2) <>
3704: nvl(l_db_assignment_rec.job_post_source_name, hr_api.g_varchar2))
3705: then
3706: i_changed:=TRUE;
3707: end if;
3700: else
3701: l_assignment_rec.job_post_source_name :=
3702: p_job_post_source_name;
3703: if (nvl(p_job_post_source_name, hr_api.g_varchar2) <>
3704: nvl(l_db_assignment_rec.job_post_source_name, hr_api.g_varchar2))
3705: then
3706: i_changed:=TRUE;
3707: end if;
3708: end if;
3706: i_changed:=TRUE;
3707: end if;
3708: end if;
3709:
3710: if (p_title = hr_api.g_varchar2) then
3711: l_assignment_rec.title :=
3712: l_old_assignment_rec.title;
3713: if nvl(l_old_assignment_rec.title, hr_api.g_varchar2)
3714: <> nvl(l_db_assignment_rec.title, hr_api.g_varchar2)
3709:
3710: if (p_title = hr_api.g_varchar2) then
3711: l_assignment_rec.title :=
3712: l_old_assignment_rec.title;
3713: if nvl(l_old_assignment_rec.title, hr_api.g_varchar2)
3714: <> nvl(l_db_assignment_rec.title, hr_api.g_varchar2)
3715: then
3716: others_changed:=TRUE;
3717: end if;
3710: if (p_title = hr_api.g_varchar2) then
3711: l_assignment_rec.title :=
3712: l_old_assignment_rec.title;
3713: if nvl(l_old_assignment_rec.title, hr_api.g_varchar2)
3714: <> nvl(l_db_assignment_rec.title, hr_api.g_varchar2)
3715: then
3716: others_changed:=TRUE;
3717: end if;
3718: else
3723: i_changed:=TRUE;
3724: end if;
3725: end if;
3726:
3727: if (p_project_title = hr_api.g_varchar2) then
3728: l_assignment_rec.project_title :=
3729: l_old_assignment_rec.project_title;
3730: if nvl(l_old_assignment_rec.project_title, hr_api.g_varchar2)
3731: <> nvl(l_db_assignment_rec.project_title, hr_api.g_varchar2)
3726:
3727: if (p_project_title = hr_api.g_varchar2) then
3728: l_assignment_rec.project_title :=
3729: l_old_assignment_rec.project_title;
3730: if nvl(l_old_assignment_rec.project_title, hr_api.g_varchar2)
3731: <> nvl(l_db_assignment_rec.project_title, hr_api.g_varchar2)
3732: then
3733: others_changed:=TRUE;
3734: end if;
3727: if (p_project_title = hr_api.g_varchar2) then
3728: l_assignment_rec.project_title :=
3729: l_old_assignment_rec.project_title;
3730: if nvl(l_old_assignment_rec.project_title, hr_api.g_varchar2)
3731: <> nvl(l_db_assignment_rec.project_title, hr_api.g_varchar2)
3732: then
3733: others_changed:=TRUE;
3734: end if;
3735: else
3740: i_changed:=TRUE;
3741: end if;
3742: end if;
3743:
3744: if (p_source_type = hr_api.g_varchar2) then
3745: l_assignment_rec.source_type :=
3746: l_old_assignment_rec.source_type;
3747: if nvl(l_old_assignment_rec.source_type, hr_api.g_varchar2)
3748: <> nvl(l_db_assignment_rec.source_type, hr_api.g_varchar2)
3743:
3744: if (p_source_type = hr_api.g_varchar2) then
3745: l_assignment_rec.source_type :=
3746: l_old_assignment_rec.source_type;
3747: if nvl(l_old_assignment_rec.source_type, hr_api.g_varchar2)
3748: <> nvl(l_db_assignment_rec.source_type, hr_api.g_varchar2)
3749: then
3750: others_changed:=TRUE;
3751: end if;
3744: if (p_source_type = hr_api.g_varchar2) then
3745: l_assignment_rec.source_type :=
3746: l_old_assignment_rec.source_type;
3747: if nvl(l_old_assignment_rec.source_type, hr_api.g_varchar2)
3748: <> nvl(l_db_assignment_rec.source_type, hr_api.g_varchar2)
3749: then
3750: others_changed:=TRUE;
3751: end if;
3752: else
3757: i_changed:=TRUE;
3758: end if;
3759: end if;
3760:
3761: if (p_vendor_assignment_number = hr_api.g_varchar2) then
3762: l_assignment_rec.vendor_assignment_number :=
3763: l_old_assignment_rec.vendor_assignment_number;
3764: if nvl(l_old_assignment_rec.vendor_assignment_number, hr_api.g_varchar2)
3765: <> nvl(l_db_assignment_rec.vendor_assignment_number, hr_api.g_varchar2)
3760:
3761: if (p_vendor_assignment_number = hr_api.g_varchar2) then
3762: l_assignment_rec.vendor_assignment_number :=
3763: l_old_assignment_rec.vendor_assignment_number;
3764: if nvl(l_old_assignment_rec.vendor_assignment_number, hr_api.g_varchar2)
3765: <> nvl(l_db_assignment_rec.vendor_assignment_number, hr_api.g_varchar2)
3766: then
3767: others_changed:=TRUE;
3768: end if;
3761: if (p_vendor_assignment_number = hr_api.g_varchar2) then
3762: l_assignment_rec.vendor_assignment_number :=
3763: l_old_assignment_rec.vendor_assignment_number;
3764: if nvl(l_old_assignment_rec.vendor_assignment_number, hr_api.g_varchar2)
3765: <> nvl(l_db_assignment_rec.vendor_assignment_number, hr_api.g_varchar2)
3766: then
3767: others_changed:=TRUE;
3768: end if;
3769: else
3774: i_changed:=TRUE;
3775: end if;
3776: end if;
3777:
3778: if (p_vendor_employee_number = hr_api.g_varchar2) then
3779: l_assignment_rec.vendor_employee_number :=
3780: l_old_assignment_rec.vendor_employee_number;
3781: if nvl(l_old_assignment_rec.vendor_employee_number, hr_api.g_varchar2)
3782: <> nvl(l_db_assignment_rec.vendor_employee_number, hr_api.g_varchar2)
3777:
3778: if (p_vendor_employee_number = hr_api.g_varchar2) then
3779: l_assignment_rec.vendor_employee_number :=
3780: l_old_assignment_rec.vendor_employee_number;
3781: if nvl(l_old_assignment_rec.vendor_employee_number, hr_api.g_varchar2)
3782: <> nvl(l_db_assignment_rec.vendor_employee_number, hr_api.g_varchar2)
3783: then
3784: others_changed:=TRUE;
3785: end if;
3778: if (p_vendor_employee_number = hr_api.g_varchar2) then
3779: l_assignment_rec.vendor_employee_number :=
3780: l_old_assignment_rec.vendor_employee_number;
3781: if nvl(l_old_assignment_rec.vendor_employee_number, hr_api.g_varchar2)
3782: <> nvl(l_db_assignment_rec.vendor_employee_number, hr_api.g_varchar2)
3783: then
3784: others_changed:=TRUE;
3785: end if;
3786: else
3791: i_changed:=TRUE;
3792: end if;
3793: end if;
3794:
3795: if (p_default_code_comb_id = hr_api.g_number) then
3796: l_assignment_rec.default_code_comb_id :=
3797: l_old_assignment_rec.default_code_comb_id;
3798: if nvl(l_old_assignment_rec.default_code_comb_id, hr_api.g_number)
3799: <> nvl(l_db_assignment_rec.default_code_comb_id, hr_api.g_number)
3794:
3795: if (p_default_code_comb_id = hr_api.g_number) then
3796: l_assignment_rec.default_code_comb_id :=
3797: l_old_assignment_rec.default_code_comb_id;
3798: if nvl(l_old_assignment_rec.default_code_comb_id, hr_api.g_number)
3799: <> nvl(l_db_assignment_rec.default_code_comb_id, hr_api.g_number)
3800: then
3801: others_changed:=TRUE;
3802: end if;
3795: if (p_default_code_comb_id = hr_api.g_number) then
3796: l_assignment_rec.default_code_comb_id :=
3797: l_old_assignment_rec.default_code_comb_id;
3798: if nvl(l_old_assignment_rec.default_code_comb_id, hr_api.g_number)
3799: <> nvl(l_db_assignment_rec.default_code_comb_id, hr_api.g_number)
3800: then
3801: others_changed:=TRUE;
3802: end if;
3803: else
3808: i_changed:=TRUE;
3809: end if;
3810: end if;
3811:
3812: if (p_set_of_books_id = hr_api.g_number) then
3813: l_assignment_rec.set_of_books_id :=
3814: l_old_assignment_rec.set_of_books_id;
3815: if nvl(l_old_assignment_rec.set_of_books_id, hr_api.g_number)
3816: <> nvl(l_db_assignment_rec.set_of_books_id, hr_api.g_number)
3811:
3812: if (p_set_of_books_id = hr_api.g_number) then
3813: l_assignment_rec.set_of_books_id :=
3814: l_old_assignment_rec.set_of_books_id;
3815: if nvl(l_old_assignment_rec.set_of_books_id, hr_api.g_number)
3816: <> nvl(l_db_assignment_rec.set_of_books_id, hr_api.g_number)
3817: then
3818: others_changed:=TRUE;
3819: end if;
3812: if (p_set_of_books_id = hr_api.g_number) then
3813: l_assignment_rec.set_of_books_id :=
3814: l_old_assignment_rec.set_of_books_id;
3815: if nvl(l_old_assignment_rec.set_of_books_id, hr_api.g_number)
3816: <> nvl(l_db_assignment_rec.set_of_books_id, hr_api.g_number)
3817: then
3818: others_changed:=TRUE;
3819: end if;
3820: else
3825: i_changed:=TRUE;
3826: end if;
3827: end if;
3828:
3829: if (p_vendor_id = hr_api.g_number) then
3830: l_assignment_rec.vendor_id :=
3831: l_old_assignment_rec.vendor_id;
3832: if nvl(l_old_assignment_rec.vendor_id, hr_api.g_number)
3833: <> nvl(l_db_assignment_rec.vendor_id, hr_api.g_number)
3828:
3829: if (p_vendor_id = hr_api.g_number) then
3830: l_assignment_rec.vendor_id :=
3831: l_old_assignment_rec.vendor_id;
3832: if nvl(l_old_assignment_rec.vendor_id, hr_api.g_number)
3833: <> nvl(l_db_assignment_rec.vendor_id, hr_api.g_number)
3834: then
3835: others_changed:=TRUE;
3836: end if;
3829: if (p_vendor_id = hr_api.g_number) then
3830: l_assignment_rec.vendor_id :=
3831: l_old_assignment_rec.vendor_id;
3832: if nvl(l_old_assignment_rec.vendor_id, hr_api.g_number)
3833: <> nvl(l_db_assignment_rec.vendor_id, hr_api.g_number)
3834: then
3835: others_changed:=TRUE;
3836: end if;
3837: else
3843: end if;
3844: end if;
3845:
3846:
3847: if (p_po_header_id = hr_api.g_number) then
3848: l_assignment_rec.po_header_id :=
3849: l_old_assignment_rec.po_header_id;
3850: if nvl(l_old_assignment_rec.po_header_id, hr_api.g_number)
3851: <> nvl(l_db_assignment_rec.po_header_id, hr_api.g_number)
3846:
3847: if (p_po_header_id = hr_api.g_number) then
3848: l_assignment_rec.po_header_id :=
3849: l_old_assignment_rec.po_header_id;
3850: if nvl(l_old_assignment_rec.po_header_id, hr_api.g_number)
3851: <> nvl(l_db_assignment_rec.po_header_id, hr_api.g_number)
3852: then
3853: others_changed:=TRUE;
3854: end if;
3847: if (p_po_header_id = hr_api.g_number) then
3848: l_assignment_rec.po_header_id :=
3849: l_old_assignment_rec.po_header_id;
3850: if nvl(l_old_assignment_rec.po_header_id, hr_api.g_number)
3851: <> nvl(l_db_assignment_rec.po_header_id, hr_api.g_number)
3852: then
3853: others_changed:=TRUE;
3854: end if;
3855: else
3860: i_changed:=TRUE;
3861: end if;
3862: end if;
3863:
3864: if (p_po_line_id = hr_api.g_number) then
3865: l_assignment_rec.po_line_id :=
3866: l_old_assignment_rec.po_line_id;
3867: if nvl(l_old_assignment_rec.po_line_id, hr_api.g_number)
3868: <> nvl(l_db_assignment_rec.po_line_id, hr_api.g_number)
3863:
3864: if (p_po_line_id = hr_api.g_number) then
3865: l_assignment_rec.po_line_id :=
3866: l_old_assignment_rec.po_line_id;
3867: if nvl(l_old_assignment_rec.po_line_id, hr_api.g_number)
3868: <> nvl(l_db_assignment_rec.po_line_id, hr_api.g_number)
3869: then
3870: others_changed:=TRUE;
3871: end if;
3864: if (p_po_line_id = hr_api.g_number) then
3865: l_assignment_rec.po_line_id :=
3866: l_old_assignment_rec.po_line_id;
3867: if nvl(l_old_assignment_rec.po_line_id, hr_api.g_number)
3868: <> nvl(l_db_assignment_rec.po_line_id, hr_api.g_number)
3869: then
3870: others_changed:=TRUE;
3871: end if;
3872: else
3877: i_changed:=TRUE;
3878: end if;
3879: end if;
3880:
3881: if (p_vendor_site_id = hr_api.g_number) then
3882: l_assignment_rec.vendor_site_id :=
3883: l_old_assignment_rec.vendor_site_id;
3884: if nvl(l_old_assignment_rec.vendor_site_id, hr_api.g_number)
3885: <> nvl(l_db_assignment_rec.vendor_site_id, hr_api.g_number)
3880:
3881: if (p_vendor_site_id = hr_api.g_number) then
3882: l_assignment_rec.vendor_site_id :=
3883: l_old_assignment_rec.vendor_site_id;
3884: if nvl(l_old_assignment_rec.vendor_site_id, hr_api.g_number)
3885: <> nvl(l_db_assignment_rec.vendor_site_id, hr_api.g_number)
3886: then
3887: others_changed:=TRUE;
3888: end if;
3881: if (p_vendor_site_id = hr_api.g_number) then
3882: l_assignment_rec.vendor_site_id :=
3883: l_old_assignment_rec.vendor_site_id;
3884: if nvl(l_old_assignment_rec.vendor_site_id, hr_api.g_number)
3885: <> nvl(l_db_assignment_rec.vendor_site_id, hr_api.g_number)
3886: then
3887: others_changed:=TRUE;
3888: end if;
3889: else
3918: -- the following 2 fields are planed for sshr 5.2.
3919: -- We will enable it later.
3920:
3921: -- GSP change
3922: if (p_grade_ladder_pgm_id = hr_api.g_number) then
3923: l_assignment_rec.grade_ladder_pgm_id :=
3924: l_old_assignment_rec.grade_ladder_pgm_id;
3925: if nvl(l_old_assignment_rec.grade_ladder_pgm_id, hr_api.g_number)
3926: <> nvl(l_db_assignment_rec.grade_ladder_pgm_id, hr_api.g_number)
3921: -- GSP change
3922: if (p_grade_ladder_pgm_id = hr_api.g_number) then
3923: l_assignment_rec.grade_ladder_pgm_id :=
3924: l_old_assignment_rec.grade_ladder_pgm_id;
3925: if nvl(l_old_assignment_rec.grade_ladder_pgm_id, hr_api.g_number)
3926: <> nvl(l_db_assignment_rec.grade_ladder_pgm_id, hr_api.g_number)
3927: then
3928: --lb_grade_ladder_changed := true;
3929: others_changed:=TRUE;
3922: if (p_grade_ladder_pgm_id = hr_api.g_number) then
3923: l_assignment_rec.grade_ladder_pgm_id :=
3924: l_old_assignment_rec.grade_ladder_pgm_id;
3925: if nvl(l_old_assignment_rec.grade_ladder_pgm_id, hr_api.g_number)
3926: <> nvl(l_db_assignment_rec.grade_ladder_pgm_id, hr_api.g_number)
3927: then
3928: --lb_grade_ladder_changed := true;
3929: others_changed:=TRUE;
3930: end if;
3938: end if;
3939: end if;
3940: --End of GSP change
3941:
3942: --if (p_supervisor_assignment_id = hr_api.g_number) then
3943: -- l_assignment_rec.supervisor_assignment_id :=
3944: -- l_old_assignment_rec.supervisor_assignment_id;
3945: -- if nvl(l_old_assignment_rec.supervisor_assignment_id, hr_api.g_number)
3946: -- <> nvl(l_db_assignment_rec.supervisor_assignment_id, hr_api.g_number)
3941:
3942: --if (p_supervisor_assignment_id = hr_api.g_number) then
3943: -- l_assignment_rec.supervisor_assignment_id :=
3944: -- l_old_assignment_rec.supervisor_assignment_id;
3945: -- if nvl(l_old_assignment_rec.supervisor_assignment_id, hr_api.g_number)
3946: -- <> nvl(l_db_assignment_rec.supervisor_assignment_id, hr_api.g_number)
3947: -- then
3948: -- others_changed:=TRUE;
3949: -- end if;
3942: --if (p_supervisor_assignment_id = hr_api.g_number) then
3943: -- l_assignment_rec.supervisor_assignment_id :=
3944: -- l_old_assignment_rec.supervisor_assignment_id;
3945: -- if nvl(l_old_assignment_rec.supervisor_assignment_id, hr_api.g_number)
3946: -- <> nvl(l_db_assignment_rec.supervisor_assignment_id, hr_api.g_number)
3947: -- then
3948: -- others_changed:=TRUE;
3949: -- end if;
3950: --else
3955: -- i_changed:=TRUE;
3956: -- end if;
3957: --end if;
3958:
3959: if (p_assignment_type = hr_api.g_varchar2) then
3960: l_assignment_rec.assignment_type :=
3961: l_old_assignment_rec.assignment_type;
3962: if nvl(l_old_assignment_rec.assignment_type, hr_api.g_varchar2)
3963: <> nvl(l_db_assignment_rec.assignment_type, hr_api.g_varchar2)
3958:
3959: if (p_assignment_type = hr_api.g_varchar2) then
3960: l_assignment_rec.assignment_type :=
3961: l_old_assignment_rec.assignment_type;
3962: if nvl(l_old_assignment_rec.assignment_type, hr_api.g_varchar2)
3963: <> nvl(l_db_assignment_rec.assignment_type, hr_api.g_varchar2)
3964: then
3965: others_changed:=TRUE;
3966: end if;
3959: if (p_assignment_type = hr_api.g_varchar2) then
3960: l_assignment_rec.assignment_type :=
3961: l_old_assignment_rec.assignment_type;
3962: if nvl(l_old_assignment_rec.assignment_type, hr_api.g_varchar2)
3963: <> nvl(l_db_assignment_rec.assignment_type, hr_api.g_varchar2)
3964: then
3965: others_changed:=TRUE;
3966: end if;
3967: else
3972: i_changed:=TRUE;
3973: end if;
3974: end if;
3975:
3976: if (p_perf_review_period = hr_api.g_number) then
3977: l_assignment_rec.perf_review_period :=
3978: l_old_assignment_rec.perf_review_period;
3979: if nvl(l_old_assignment_rec.perf_review_period, hr_api.g_number)
3980: <> nvl(l_db_assignment_rec.perf_review_period, hr_api.g_number)
3975:
3976: if (p_perf_review_period = hr_api.g_number) then
3977: l_assignment_rec.perf_review_period :=
3978: l_old_assignment_rec.perf_review_period;
3979: if nvl(l_old_assignment_rec.perf_review_period, hr_api.g_number)
3980: <> nvl(l_db_assignment_rec.perf_review_period, hr_api.g_number)
3981: then
3982: others_changed:=TRUE;
3983: end if;
3976: if (p_perf_review_period = hr_api.g_number) then
3977: l_assignment_rec.perf_review_period :=
3978: l_old_assignment_rec.perf_review_period;
3979: if nvl(l_old_assignment_rec.perf_review_period, hr_api.g_number)
3980: <> nvl(l_db_assignment_rec.perf_review_period, hr_api.g_number)
3981: then
3982: others_changed:=TRUE;
3983: end if;
3984: else
3989: i_changed:=TRUE;
3990: end if;
3991: end if;
3992:
3993: if (p_perf_review_period_frequency = hr_api.g_varchar2) then
3994: l_assignment_rec.perf_review_period_frequency :=
3995: l_old_assignment_rec.perf_review_period_frequency;
3996: if (nvl(l_db_assignment_rec.perf_review_period_frequency, hr_api.g_varchar2)
3997: <>
3992:
3993: if (p_perf_review_period_frequency = hr_api.g_varchar2) then
3994: l_assignment_rec.perf_review_period_frequency :=
3995: l_old_assignment_rec.perf_review_period_frequency;
3996: if (nvl(l_db_assignment_rec.perf_review_period_frequency, hr_api.g_varchar2)
3997: <>
3998: nvl(l_old_assignment_rec.perf_review_period_frequency, hr_api.g_varchar2))
3999: then
4000: others_changed:=TRUE;
3994: l_assignment_rec.perf_review_period_frequency :=
3995: l_old_assignment_rec.perf_review_period_frequency;
3996: if (nvl(l_db_assignment_rec.perf_review_period_frequency, hr_api.g_varchar2)
3997: <>
3998: nvl(l_old_assignment_rec.perf_review_period_frequency, hr_api.g_varchar2))
3999: then
4000: others_changed:=TRUE;
4001: end if;
4002: else
4001: end if;
4002: else
4003: l_assignment_rec.perf_review_period_frequency :=
4004: p_perf_review_period_frequency;
4005: if (nvl(p_perf_review_period_frequency, hr_api.g_varchar2) <>
4006: nvl(l_db_assignment_rec.perf_review_period_frequency, hr_api.g_varchar2))
4007: then
4008: i_changed:=TRUE;
4009: end if;
4002: else
4003: l_assignment_rec.perf_review_period_frequency :=
4004: p_perf_review_period_frequency;
4005: if (nvl(p_perf_review_period_frequency, hr_api.g_varchar2) <>
4006: nvl(l_db_assignment_rec.perf_review_period_frequency, hr_api.g_varchar2))
4007: then
4008: i_changed:=TRUE;
4009: end if;
4010: end if;
4008: i_changed:=TRUE;
4009: end if;
4010: end if;
4011:
4012: if (p_internal_address_line = hr_api.g_varchar2) then
4013: l_assignment_rec.internal_address_line :=
4014: l_old_assignment_rec.internal_address_line;
4015: if (nvl(l_db_assignment_rec.internal_address_line, hr_api.g_varchar2)
4016: <>
4011:
4012: if (p_internal_address_line = hr_api.g_varchar2) then
4013: l_assignment_rec.internal_address_line :=
4014: l_old_assignment_rec.internal_address_line;
4015: if (nvl(l_db_assignment_rec.internal_address_line, hr_api.g_varchar2)
4016: <>
4017: nvl(l_old_assignment_rec.internal_address_line, hr_api.g_varchar2))
4018: then
4019: others_changed:=TRUE;
4013: l_assignment_rec.internal_address_line :=
4014: l_old_assignment_rec.internal_address_line;
4015: if (nvl(l_db_assignment_rec.internal_address_line, hr_api.g_varchar2)
4016: <>
4017: nvl(l_old_assignment_rec.internal_address_line, hr_api.g_varchar2))
4018: then
4019: others_changed:=TRUE;
4020: end if;
4021: else
4020: end if;
4021: else
4022: l_assignment_rec.internal_address_line :=
4023: p_internal_address_line;
4024: if (nvl(p_internal_address_line, hr_api.g_varchar2) <>
4025: nvl(l_db_assignment_rec.internal_address_line, hr_api.g_varchar2))
4026: then
4027: i_changed:=TRUE;
4028: end if;
4021: else
4022: l_assignment_rec.internal_address_line :=
4023: p_internal_address_line;
4024: if (nvl(p_internal_address_line, hr_api.g_varchar2) <>
4025: nvl(l_db_assignment_rec.internal_address_line, hr_api.g_varchar2))
4026: then
4027: i_changed:=TRUE;
4028: end if;
4029: end if;
4027: i_changed:=TRUE;
4028: end if;
4029: end if;
4030:
4031: if (p_payroll_id = hr_api.g_number) then
4032: l_assignment_rec.payroll_id :=
4033: l_old_assignment_rec.payroll_id;
4034: if nvl(l_old_assignment_rec.payroll_id, hr_api.g_number)
4035: <> nvl(l_db_assignment_rec.payroll_id, hr_api.g_number)
4030:
4031: if (p_payroll_id = hr_api.g_number) then
4032: l_assignment_rec.payroll_id :=
4033: l_old_assignment_rec.payroll_id;
4034: if nvl(l_old_assignment_rec.payroll_id, hr_api.g_number)
4035: <> nvl(l_db_assignment_rec.payroll_id, hr_api.g_number)
4036: then
4037: others_changed:=TRUE;
4038: end if;
4031: if (p_payroll_id = hr_api.g_number) then
4032: l_assignment_rec.payroll_id :=
4033: l_old_assignment_rec.payroll_id;
4034: if nvl(l_old_assignment_rec.payroll_id, hr_api.g_number)
4035: <> nvl(l_db_assignment_rec.payroll_id, hr_api.g_number)
4036: then
4037: others_changed:=TRUE;
4038: end if;
4039: else
4051: -- table.
4052: l_legislation_code := hr_misc_web.get_legislation_code
4053: (p_assignment_id => l_assignment_id);
4054:
4055: if (p_pay_basis_id = hr_api.g_number) then
4056: l_assignment_rec.pay_basis_id :=
4057: l_old_assignment_rec.pay_basis_id;
4058: if nvl(l_old_assignment_rec.pay_basis_id, hr_api.g_number)
4059: <> nvl(l_db_assignment_rec.pay_basis_id, hr_api.g_number)
4054:
4055: if (p_pay_basis_id = hr_api.g_number) then
4056: l_assignment_rec.pay_basis_id :=
4057: l_old_assignment_rec.pay_basis_id;
4058: if nvl(l_old_assignment_rec.pay_basis_id, hr_api.g_number)
4059: <> nvl(l_db_assignment_rec.pay_basis_id, hr_api.g_number)
4060: then
4061: -- 05/14/02 - Bug 2374140 Fix Begins
4062: -- Removed the code to set the WF item attribute HR_MID_PAY_PERIOD_CHANGE
4055: if (p_pay_basis_id = hr_api.g_number) then
4056: l_assignment_rec.pay_basis_id :=
4057: l_old_assignment_rec.pay_basis_id;
4058: if nvl(l_old_assignment_rec.pay_basis_id, hr_api.g_number)
4059: <> nvl(l_db_assignment_rec.pay_basis_id, hr_api.g_number)
4060: then
4061: -- 05/14/02 - Bug 2374140 Fix Begins
4062: -- Removed the code to set the WF item attribute HR_MID_PAY_PERIOD_CHANGE
4063: -- here. Instead, we'll set it in the Approvals process when a trans
4098: -- 05/14/02 - Bug 2374140 Fix Ends
4099: end if;
4100:
4101:
4102: if (p_contract_id = hr_api.g_number) then
4103: l_assignment_rec.contract_id :=
4104: l_old_assignment_rec.contract_id;
4105: if nvl(l_old_assignment_rec.contract_id, hr_api.g_number)
4106: <> nvl(l_db_assignment_rec.contract_id, hr_api.g_number)
4101:
4102: if (p_contract_id = hr_api.g_number) then
4103: l_assignment_rec.contract_id :=
4104: l_old_assignment_rec.contract_id;
4105: if nvl(l_old_assignment_rec.contract_id, hr_api.g_number)
4106: <> nvl(l_db_assignment_rec.contract_id, hr_api.g_number)
4107: then
4108: others_changed:=TRUE;
4109: end if;
4102: if (p_contract_id = hr_api.g_number) then
4103: l_assignment_rec.contract_id :=
4104: l_old_assignment_rec.contract_id;
4105: if nvl(l_old_assignment_rec.contract_id, hr_api.g_number)
4106: <> nvl(l_db_assignment_rec.contract_id, hr_api.g_number)
4107: then
4108: others_changed:=TRUE;
4109: end if;
4110: else
4114: i_changed:=TRUE;
4115: end if;
4116: end if;
4117:
4118: if (p_establishment_id = hr_api.g_number) then
4119: l_assignment_rec.establishment_id :=
4120: l_old_assignment_rec.establishment_id;
4121: if nvl(l_old_assignment_rec.establishment_id, hr_api.g_number)
4122: <> nvl(l_db_assignment_rec.establishment_id, hr_api.g_number)
4117:
4118: if (p_establishment_id = hr_api.g_number) then
4119: l_assignment_rec.establishment_id :=
4120: l_old_assignment_rec.establishment_id;
4121: if nvl(l_old_assignment_rec.establishment_id, hr_api.g_number)
4122: <> nvl(l_db_assignment_rec.establishment_id, hr_api.g_number)
4123: then
4124: others_changed:=TRUE;
4125: end if;
4118: if (p_establishment_id = hr_api.g_number) then
4119: l_assignment_rec.establishment_id :=
4120: l_old_assignment_rec.establishment_id;
4121: if nvl(l_old_assignment_rec.establishment_id, hr_api.g_number)
4122: <> nvl(l_db_assignment_rec.establishment_id, hr_api.g_number)
4123: then
4124: others_changed:=TRUE;
4125: end if;
4126: else
4131: i_changed:=TRUE;
4132: end if;
4133: end if;
4134:
4135: if (p_cagr_grade_def_id = hr_api.g_number) then
4136: l_assignment_rec.cagr_grade_def_id :=
4137: l_old_assignment_rec.cagr_grade_def_id;
4138: if nvl(l_old_assignment_rec.cagr_grade_def_id, hr_api.g_number)
4139: <> nvl(l_db_assignment_rec.cagr_grade_def_id, hr_api.g_number)
4134:
4135: if (p_cagr_grade_def_id = hr_api.g_number) then
4136: l_assignment_rec.cagr_grade_def_id :=
4137: l_old_assignment_rec.cagr_grade_def_id;
4138: if nvl(l_old_assignment_rec.cagr_grade_def_id, hr_api.g_number)
4139: <> nvl(l_db_assignment_rec.cagr_grade_def_id, hr_api.g_number)
4140: then
4141: others_changed:=TRUE;
4142: end if;
4135: if (p_cagr_grade_def_id = hr_api.g_number) then
4136: l_assignment_rec.cagr_grade_def_id :=
4137: l_old_assignment_rec.cagr_grade_def_id;
4138: if nvl(l_old_assignment_rec.cagr_grade_def_id, hr_api.g_number)
4139: <> nvl(l_db_assignment_rec.cagr_grade_def_id, hr_api.g_number)
4140: then
4141: others_changed:=TRUE;
4142: end if;
4143: else
4148: i_changed:=TRUE;
4149: end if;
4150: end if;
4151:
4152: if (p_cagr_id_flex_num = hr_api.g_number) then
4153: l_assignment_rec.cagr_id_flex_num :=
4154: l_old_assignment_rec.cagr_id_flex_num;
4155: if nvl(l_old_assignment_rec.cagr_id_flex_num, hr_api.g_number)
4156: <> nvl(l_db_assignment_rec.cagr_id_flex_num, hr_api.g_number)
4151:
4152: if (p_cagr_id_flex_num = hr_api.g_number) then
4153: l_assignment_rec.cagr_id_flex_num :=
4154: l_old_assignment_rec.cagr_id_flex_num;
4155: if nvl(l_old_assignment_rec.cagr_id_flex_num, hr_api.g_number)
4156: <> nvl(l_db_assignment_rec.cagr_id_flex_num, hr_api.g_number)
4157: then
4158: others_changed:=TRUE;
4159: end if;
4152: if (p_cagr_id_flex_num = hr_api.g_number) then
4153: l_assignment_rec.cagr_id_flex_num :=
4154: l_old_assignment_rec.cagr_id_flex_num;
4155: if nvl(l_old_assignment_rec.cagr_id_flex_num, hr_api.g_number)
4156: <> nvl(l_db_assignment_rec.cagr_id_flex_num, hr_api.g_number)
4157: then
4158: others_changed:=TRUE;
4159: end if;
4160: else
4165: i_changed:=TRUE;
4166: end if;
4167: end if;
4168:
4169: if (p_collective_agreement_id = hr_api.g_number) then
4170: l_assignment_rec.collective_agreement_id :=
4171: l_old_assignment_rec.collective_agreement_id;
4172: if nvl(l_old_assignment_rec.collective_agreement_id, hr_api.g_number)
4173: <> nvl(l_db_assignment_rec.collective_agreement_id, hr_api.g_number)
4168:
4169: if (p_collective_agreement_id = hr_api.g_number) then
4170: l_assignment_rec.collective_agreement_id :=
4171: l_old_assignment_rec.collective_agreement_id;
4172: if nvl(l_old_assignment_rec.collective_agreement_id, hr_api.g_number)
4173: <> nvl(l_db_assignment_rec.collective_agreement_id, hr_api.g_number)
4174: then
4175: others_changed:=TRUE;
4176: end if;
4169: if (p_collective_agreement_id = hr_api.g_number) then
4170: l_assignment_rec.collective_agreement_id :=
4171: l_old_assignment_rec.collective_agreement_id;
4172: if nvl(l_old_assignment_rec.collective_agreement_id, hr_api.g_number)
4173: <> nvl(l_db_assignment_rec.collective_agreement_id, hr_api.g_number)
4174: then
4175: others_changed:=TRUE;
4176: end if;
4177: else
4183: end if;
4184: end if;
4185:
4186:
4187: if ( p_hrs_last_date= hr_api.g_varchar2) then
4188: l_hrs_last_date :=
4189: null;
4190: else
4191: l_hrs_last_date := p_hrs_last_date;
4189: null;
4190: else
4191: l_hrs_last_date := p_hrs_last_date;
4192: end if;
4193: if ( p_display_pos= hr_api.g_varchar2) then
4194: l_display_pos :=
4195: null;
4196: else
4197: l_display_pos := p_display_pos;
4196: else
4197: l_display_pos := p_display_pos;
4198: end if;
4199:
4200: if ( p_display_org= hr_api.g_varchar2) then
4201: l_display_org :=
4202: null;
4203: else
4204: l_display_org := p_display_org;
4202: null;
4203: else
4204: l_display_org := p_display_org;
4205: end if;
4206: if ( p_display_ass_status= hr_api.g_varchar2) then
4207: l_display_ass_status :=
4208: null;
4209: else
4210: l_display_ass_status := p_display_ass_status;
4208: null;
4209: else
4210: l_display_ass_status := p_display_ass_status;
4211: end if;
4212: if ( p_display_job= hr_api.g_varchar2) then
4213: l_display_job :=
4214: null;
4215: else
4216: l_display_job := p_display_job;
4215: else
4216: l_display_job := p_display_job;
4217: end if;
4218: -- Bug #1067636 fix begins
4219: if ( p_display_grade = hr_api.g_varchar2) then
4220: l_display_grade :=
4221: null;
4222: else
4223: l_display_grade := p_display_grade;
4224: end if;
4225: -- Bug #1067636 fix ends
4226:
4227: -- Bug #1004255 fix
4228: if ( p_grade_lov = hr_api.g_varchar2) then
4229: l_grade_lov := null;
4230: else
4231: l_grade_lov := p_grade_lov;
4232: end if;
4230: else
4231: l_grade_lov := p_grade_lov;
4232: end if;
4233:
4234: if ( p_approver_id= hr_api.g_number) then
4235: l_approver_id :=
4236: null;
4237: else
4238: l_approver_id := p_approver_id;
6503: -- for US legislation.
6504: -- if p_soft_coding_keyflex_id is null, the GRE region must be turned off
6505: -- for the new hire flow or the applicant hire flow.
6506: -- we need to set the GRE and Work Schedule default values. Otherwise,
6507: -- core hr api will raise error HR_50001_EMP_ASS_NO_GRE.
6508: -- The default GRE and Work Schedule values are set when the p_login_person_id
6509: -- is not null (update_assignment is called by the process_save).
6510: -- The login_person_id is null when update_assignment is called by
6511: -- process_api. The default values should not be set when called by
7462: l_old_organization_id old_organization_id,
7463: l_old_pay_basis_id old_pay_basis_id,
7464: l_old_grade_id old_grade_id
7465: from
7466: hr_api_transaction_steps ts
7467: ,hr_api_transaction_values otv, hr_all_organization_units_tl org
7468: ,hr_api_transaction_values jtv, per_jobs_tl job
7469: ,hr_api_transaction_values ptv, hr_all_positions_f_tl pos
7470: ,hr_api_transaction_values gtv, per_grades_tl grade
7463: l_old_pay_basis_id old_pay_basis_id,
7464: l_old_grade_id old_grade_id
7465: from
7466: hr_api_transaction_steps ts
7467: ,hr_api_transaction_values otv, hr_all_organization_units_tl org
7468: ,hr_api_transaction_values jtv, per_jobs_tl job
7469: ,hr_api_transaction_values ptv, hr_all_positions_f_tl pos
7470: ,hr_api_transaction_values gtv, per_grades_tl grade
7471: ,hr_api_transaction_values vtv, po_vendors vendor
7464: l_old_grade_id old_grade_id
7465: from
7466: hr_api_transaction_steps ts
7467: ,hr_api_transaction_values otv, hr_all_organization_units_tl org
7468: ,hr_api_transaction_values jtv, per_jobs_tl job
7469: ,hr_api_transaction_values ptv, hr_all_positions_f_tl pos
7470: ,hr_api_transaction_values gtv, per_grades_tl grade
7471: ,hr_api_transaction_values vtv, po_vendors vendor
7472: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7465: from
7466: hr_api_transaction_steps ts
7467: ,hr_api_transaction_values otv, hr_all_organization_units_tl org
7468: ,hr_api_transaction_values jtv, per_jobs_tl job
7469: ,hr_api_transaction_values ptv, hr_all_positions_f_tl pos
7470: ,hr_api_transaction_values gtv, per_grades_tl grade
7471: ,hr_api_transaction_values vtv, po_vendors vendor
7472: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7473: ,hr_api_transaction_values htv, po_headers_all po_heads
7466: hr_api_transaction_steps ts
7467: ,hr_api_transaction_values otv, hr_all_organization_units_tl org
7468: ,hr_api_transaction_values jtv, per_jobs_tl job
7469: ,hr_api_transaction_values ptv, hr_all_positions_f_tl pos
7470: ,hr_api_transaction_values gtv, per_grades_tl grade
7471: ,hr_api_transaction_values vtv, po_vendors vendor
7472: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7473: ,hr_api_transaction_values htv, po_headers_all po_heads
7474: ,hr_api_transaction_values ltv, po_lines_all po_lines
7467: ,hr_api_transaction_values otv, hr_all_organization_units_tl org
7468: ,hr_api_transaction_values jtv, per_jobs_tl job
7469: ,hr_api_transaction_values ptv, hr_all_positions_f_tl pos
7470: ,hr_api_transaction_values gtv, per_grades_tl grade
7471: ,hr_api_transaction_values vtv, po_vendors vendor
7472: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7473: ,hr_api_transaction_values htv, po_headers_all po_heads
7474: ,hr_api_transaction_values ltv, po_lines_all po_lines
7475: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits
7468: ,hr_api_transaction_values jtv, per_jobs_tl job
7469: ,hr_api_transaction_values ptv, hr_all_positions_f_tl pos
7470: ,hr_api_transaction_values gtv, per_grades_tl grade
7471: ,hr_api_transaction_values vtv, po_vendors vendor
7472: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7473: ,hr_api_transaction_values htv, po_headers_all po_heads
7474: ,hr_api_transaction_values ltv, po_lines_all po_lines
7475: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits
7476: ,hr_api_transaction_values btv, hr_lookups hl_bargaining_unit
7469: ,hr_api_transaction_values ptv, hr_all_positions_f_tl pos
7470: ,hr_api_transaction_values gtv, per_grades_tl grade
7471: ,hr_api_transaction_values vtv, po_vendors vendor
7472: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7473: ,hr_api_transaction_values htv, po_headers_all po_heads
7474: ,hr_api_transaction_values ltv, po_lines_all po_lines
7475: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits
7476: ,hr_api_transaction_values btv, hr_lookups hl_bargaining_unit
7477:
7470: ,hr_api_transaction_values gtv, per_grades_tl grade
7471: ,hr_api_transaction_values vtv, po_vendors vendor
7472: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7473: ,hr_api_transaction_values htv, po_headers_all po_heads
7474: ,hr_api_transaction_values ltv, po_lines_all po_lines
7475: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits
7476: ,hr_api_transaction_values btv, hr_lookups hl_bargaining_unit
7477:
7478: where
7471: ,hr_api_transaction_values vtv, po_vendors vendor
7472: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7473: ,hr_api_transaction_values htv, po_headers_all po_heads
7474: ,hr_api_transaction_values ltv, po_lines_all po_lines
7475: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits
7476: ,hr_api_transaction_values btv, hr_lookups hl_bargaining_unit
7477:
7478: where
7479:
7472: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7473: ,hr_api_transaction_values htv, po_headers_all po_heads
7474: ,hr_api_transaction_values ltv, po_lines_all po_lines
7475: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits
7476: ,hr_api_transaction_values btv, hr_lookups hl_bargaining_unit
7477:
7478: where
7479:
7480: ts.transaction_step_id = p_transaction_step_id