[Home] [Help]
65: begin
66: hr_utility.set_location('Entering:'|| l_proc, 10);
67:
68: --check mandatory arguments have been set
69: hr_api.mandatory_arg_error
70: (p_api_name => l_proc,
71: p_argument => 'noa_family_code',
72: p_argument_value => p_noa_family_code
73: );
85: );
86: hr_utility.set_location(l_proc, 30);
87: --
88: if ((l_api_updating
89: and nvl(ghr_par_shd.g_old_rec.first_noa_id, hr_api.g_number)
90: <> nvl(p_first_nature_of_action_id,hr_api.g_number))
91: or
92: (NOT l_api_updating))
93: then
86: hr_utility.set_location(l_proc, 30);
87: --
88: if ((l_api_updating
89: and nvl(ghr_par_shd.g_old_rec.first_noa_id, hr_api.g_number)
90: <> nvl(p_first_nature_of_action_id,hr_api.g_number))
91: or
92: (NOT l_api_updating))
93: then
94: hr_utility.set_location(l_proc, 40);
148: begin
149: hr_utility.set_location('Entering:'|| l_proc, 10);
150:
151: /*--check mandatory arguments have been set
152: hr_api.mandatory_arg_error
153: (p_api_name => l_proc,
154: p_argument => 'noa_family_code',
155: p_argument_value => p_noa_family_code
156: );
169: );
170: hr_utility.set_location(l_proc, 30);
171: --
172: if ((l_api_updating
173: and nvl(ghr_par_shd.g_old_rec.second_noa_id, hr_api.g_number)
174: <> nvl(p_second_nature_of_action_id,hr_api.g_number))
175: or
176: (NOT l_api_updating))
177: then
170: hr_utility.set_location(l_proc, 30);
171: --
172: if ((l_api_updating
173: and nvl(ghr_par_shd.g_old_rec.second_noa_id, hr_api.g_number)
174: <> nvl(p_second_nature_of_action_id,hr_api.g_number))
175: or
176: (NOT l_api_updating))
177: then
178: hr_utility.set_location(l_proc, 40);
336: );
337: hr_utility.set_location(l_proc, 30);
338: --
339: if ((l_api_updating
340: and nvl(ghr_par_shd.g_old_rec.additional_info_person_id, hr_api.g_number)
341: <> nvl(p_additional_info_person_id,hr_api.g_number))
342: or
343: (NOT l_api_updating))
344: then
337: hr_utility.set_location(l_proc, 30);
338: --
339: if ((l_api_updating
340: and nvl(ghr_par_shd.g_old_rec.additional_info_person_id, hr_api.g_number)
341: <> nvl(p_additional_info_person_id,hr_api.g_number))
342: or
343: (NOT l_api_updating))
344: then
345: hr_utility.set_location(l_proc, 40);
424: );
425: hr_utility.set_location(l_proc, 30);
426: --
427: if ((l_api_updating
428: and nvl(ghr_par_shd.g_old_rec.requested_by_person_id, hr_api.g_number)
429: <> nvl(p_requested_by_person_id,hr_api.g_number))
430: or
431: (NOT l_api_updating))
432: then
425: hr_utility.set_location(l_proc, 30);
426: --
427: if ((l_api_updating
428: and nvl(ghr_par_shd.g_old_rec.requested_by_person_id, hr_api.g_number)
429: <> nvl(p_requested_by_person_id,hr_api.g_number))
430: or
431: (NOT l_api_updating))
432: then
433: hr_utility.set_location(l_proc, 40);
532: l_person_type := person_type_rec.system_person_type;
533: l_effective_start_date := person_type_rec.effective_start_date;
534: exit;
535: end loop;
536: If nvl(l_person_type,hr_api.g_varchar2) = 'EX_EMP' then
537: hr_utility.set_location(' Ex Emp in Conv',1);
538: hr_utility.set_location('Termination date ' || l_effective_start_date,1);
539: if (nvl(p_effective_date,sysdate) - 3) >= (l_effective_start_date ) then
540: hr_utility.set_message(8301,'GHR_38645_EX_EMP_MORE_THAN_3');
612: );
613: hr_utility.set_location(l_proc, 30);
614: --
615: if ((l_api_updating
616: and nvl(ghr_par_shd.g_old_rec.authorized_by_person_id, hr_api.g_number)
617: <> nvl(p_authorized_by_person_id,hr_api.g_number))
618: or
619: (NOT l_api_updating))
620: then
613: hr_utility.set_location(l_proc, 30);
614: --
615: if ((l_api_updating
616: and nvl(ghr_par_shd.g_old_rec.authorized_by_person_id, hr_api.g_number)
617: <> nvl(p_authorized_by_person_id,hr_api.g_number))
618: or
619: (NOT l_api_updating))
620: then
621: hr_utility.set_location(l_proc, 40);
728: );
729: hr_utility.set_location(l_proc, 20);
730: --
731: if ((l_api_updating
732: and nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number)
733: <> nvl(p_employee_assignment_id,hr_api.g_number))
734: or
735: (NOT l_api_updating))
736: then
729: hr_utility.set_location(l_proc, 20);
730: --
731: if ((l_api_updating
732: and nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number)
733: <> nvl(p_employee_assignment_id,hr_api.g_number))
734: or
735: (NOT l_api_updating))
736: then
737: hr_utility.set_location(l_proc, 30);
854: );
855: hr_utility.set_location(l_proc, 20);
856: --
857: if ((l_api_updating
858: and nvl(ghr_par_shd.g_old_rec.from_position_id,hr_api.g_number)
859: <> nvl(p_from_position_id,hr_api.g_number))
860: or
861: (NOT l_api_updating))
862: then
855: hr_utility.set_location(l_proc, 20);
856: --
857: if ((l_api_updating
858: and nvl(ghr_par_shd.g_old_rec.from_position_id,hr_api.g_number)
859: <> nvl(p_from_position_id,hr_api.g_number))
860: or
861: (NOT l_api_updating))
862: then
863: hr_utility.set_location(l_proc, 30);
930: );
931: hr_utility.set_location(l_proc, 20);
932: --
933: if ((l_api_updating
934: and nvl(ghr_par_shd.g_old_rec.first_action_la_code1,hr_api.g_varchar2)
935: <> nvl(p_first_action_la_code1,hr_api.g_varchar2))
936: or
937: (NOT l_api_updating))
938: then
931: hr_utility.set_location(l_proc, 20);
932: --
933: if ((l_api_updating
934: and nvl(ghr_par_shd.g_old_rec.first_action_la_code1,hr_api.g_varchar2)
935: <> nvl(p_first_action_la_code1,hr_api.g_varchar2))
936: or
937: (NOT l_api_updating))
938: then
939:
1008: );
1009: hr_utility.set_location(l_proc, 20);
1010: --
1011: if ((l_api_updating
1012: and nvl(ghr_par_shd.g_old_rec.first_action_la_code2,hr_api.g_varchar2)
1013: <> nvl(p_first_action_la_code2,hr_api.g_varchar2))
1014: or
1015: (NOT l_api_updating))
1016: then
1009: hr_utility.set_location(l_proc, 20);
1010: --
1011: if ((l_api_updating
1012: and nvl(ghr_par_shd.g_old_rec.first_action_la_code2,hr_api.g_varchar2)
1013: <> nvl(p_first_action_la_code2,hr_api.g_varchar2))
1014: or
1015: (NOT l_api_updating))
1016: then
1017: hr_utility.set_location(l_proc, 30);
1185: );
1186: hr_utility.set_location(l_proc, 20);
1187: --
1188: if ((l_api_updating
1189: and nvl(ghr_par_shd.g_old_rec.second_action_la_code1,hr_api.g_varchar2)
1190: <> nvl(p_second_action_la_code1,hr_api.g_varchar2))
1191: or
1192: (NOT l_api_updating))
1193: then
1186: hr_utility.set_location(l_proc, 20);
1187: --
1188: if ((l_api_updating
1189: and nvl(ghr_par_shd.g_old_rec.second_action_la_code1,hr_api.g_varchar2)
1190: <> nvl(p_second_action_la_code1,hr_api.g_varchar2))
1191: or
1192: (NOT l_api_updating))
1193: then
1194: hr_utility.set_location(l_proc, 30);
1262: );
1263: hr_utility.set_location(l_proc, 20);
1264: --
1265: if ((l_api_updating
1266: and nvl(ghr_par_shd.g_old_rec.second_action_la_code2,hr_api.g_varchar2)
1267: <> nvl(p_second_action_la_code2,hr_api.g_varchar2))
1268: or
1269: (NOT l_api_updating))
1270: then
1263: hr_utility.set_location(l_proc, 20);
1264: --
1265: if ((l_api_updating
1266: and nvl(ghr_par_shd.g_old_rec.second_action_la_code2,hr_api.g_varchar2)
1267: <> nvl(p_second_action_la_code2,hr_api.g_varchar2))
1268: or
1269: (NOT l_api_updating))
1270: then
1271: hr_utility.set_location(l_proc, 30);
1304: -- Call all supporting operations
1305:
1306: -- Check that the routing_group is not null
1307:
1308: /* hr_api.mandatory_arg_error
1309: (p_api_name => l_proc,
1310: p_argument => 'routing_group_id',
1311: p_argument_value => p_rec.routing_group_id); */
1312:
1310: p_argument => 'routing_group_id',
1311: p_argument_value => p_rec.routing_group_id); */
1312:
1313: -- Check that the Noa_Family Code is not null
1314: hr_api.mandatory_arg_error
1315: (p_api_name => l_proc,
1316: p_argument => 'Noa Family Code',
1317: p_argument_value => p_rec.noa_family_code);
1318:
1506: -- Call all supporting business operations
1507: --
1508: --
1509: -- Check that the Noa_Family Code is not null
1510: hr_api.mandatory_arg_error
1511: (p_api_name => l_proc,
1512: p_argument => 'Noa Family Code',
1513: p_argument_value => p_rec.noa_family_code);
1514:
1752: -- p_rec plsql record structure
1753: -- to see if a system default is being used. If a system default
1754: -- is being used then we must set to the 'current' argument value.
1755: --
1756: If (p_rec.pa_notification_id = hr_api.g_number) then
1757: p_rec.pa_notification_id :=
1758: ghr_par_shd.g_old_rec.pa_notification_id;
1759: End If;
1760: If (p_rec.noa_family_code = hr_api.g_varchar2) then
1756: If (p_rec.pa_notification_id = hr_api.g_number) then
1757: p_rec.pa_notification_id :=
1758: ghr_par_shd.g_old_rec.pa_notification_id;
1759: End If;
1760: If (p_rec.noa_family_code = hr_api.g_varchar2) then
1761: p_rec.noa_family_code :=
1762: ghr_par_shd.g_old_rec.noa_family_code;
1763: End If;
1764: If (p_rec.routing_group_id = hr_api.g_number) then
1760: If (p_rec.noa_family_code = hr_api.g_varchar2) then
1761: p_rec.noa_family_code :=
1762: ghr_par_shd.g_old_rec.noa_family_code;
1763: End If;
1764: If (p_rec.routing_group_id = hr_api.g_number) then
1765: p_rec.routing_group_id :=
1766: ghr_par_shd.g_old_rec.routing_group_id;
1767: End If;
1768: If (p_rec.proposed_effective_asap_flag = hr_api.g_varchar2) then
1764: If (p_rec.routing_group_id = hr_api.g_number) then
1765: p_rec.routing_group_id :=
1766: ghr_par_shd.g_old_rec.routing_group_id;
1767: End If;
1768: If (p_rec.proposed_effective_asap_flag = hr_api.g_varchar2) then
1769: p_rec.proposed_effective_asap_flag :=
1770: ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
1771: End If;
1772: If (p_rec.academic_discipline = hr_api.g_varchar2) then
1768: If (p_rec.proposed_effective_asap_flag = hr_api.g_varchar2) then
1769: p_rec.proposed_effective_asap_flag :=
1770: ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
1771: End If;
1772: If (p_rec.academic_discipline = hr_api.g_varchar2) then
1773: p_rec.academic_discipline :=
1774: ghr_par_shd.g_old_rec.academic_discipline;
1775: End If;
1776: If (p_rec.additional_info_person_id = hr_api.g_number) then
1772: If (p_rec.academic_discipline = hr_api.g_varchar2) then
1773: p_rec.academic_discipline :=
1774: ghr_par_shd.g_old_rec.academic_discipline;
1775: End If;
1776: If (p_rec.additional_info_person_id = hr_api.g_number) then
1777: p_rec.additional_info_person_id :=
1778: ghr_par_shd.g_old_rec.additional_info_person_id;
1779: End If;
1780: If (p_rec.additional_info_tel_number = hr_api.g_varchar2) then
1776: If (p_rec.additional_info_person_id = hr_api.g_number) then
1777: p_rec.additional_info_person_id :=
1778: ghr_par_shd.g_old_rec.additional_info_person_id;
1779: End If;
1780: If (p_rec.additional_info_tel_number = hr_api.g_varchar2) then
1781: p_rec.additional_info_tel_number :=
1782: ghr_par_shd.g_old_rec.additional_info_tel_number;
1783: End If;
1784: If (p_rec.agency_code = hr_api.g_varchar2) then
1780: If (p_rec.additional_info_tel_number = hr_api.g_varchar2) then
1781: p_rec.additional_info_tel_number :=
1782: ghr_par_shd.g_old_rec.additional_info_tel_number;
1783: End If;
1784: If (p_rec.agency_code = hr_api.g_varchar2) then
1785: p_rec.agency_code :=
1786: ghr_par_shd.g_old_rec.agency_code;
1787: End If;
1788: If (p_rec.altered_pa_request_id = hr_api.g_number) then
1784: If (p_rec.agency_code = hr_api.g_varchar2) then
1785: p_rec.agency_code :=
1786: ghr_par_shd.g_old_rec.agency_code;
1787: End If;
1788: If (p_rec.altered_pa_request_id = hr_api.g_number) then
1789: p_rec.altered_pa_request_id :=
1790: ghr_par_shd.g_old_rec.altered_pa_request_id;
1791: End If;
1792: If (p_rec.annuitant_indicator = hr_api.g_varchar2) then
1788: If (p_rec.altered_pa_request_id = hr_api.g_number) then
1789: p_rec.altered_pa_request_id :=
1790: ghr_par_shd.g_old_rec.altered_pa_request_id;
1791: End If;
1792: If (p_rec.annuitant_indicator = hr_api.g_varchar2) then
1793: p_rec.annuitant_indicator :=
1794: ghr_par_shd.g_old_rec.annuitant_indicator;
1795: End If;
1796: If (p_rec.annuitant_indicator_desc = hr_api.g_varchar2) then
1792: If (p_rec.annuitant_indicator = hr_api.g_varchar2) then
1793: p_rec.annuitant_indicator :=
1794: ghr_par_shd.g_old_rec.annuitant_indicator;
1795: End If;
1796: If (p_rec.annuitant_indicator_desc = hr_api.g_varchar2) then
1797: p_rec.annuitant_indicator_desc :=
1798: ghr_par_shd.g_old_rec.annuitant_indicator_desc;
1799: End If;
1800: If (p_rec.appropriation_code1 = hr_api.g_varchar2) then
1796: If (p_rec.annuitant_indicator_desc = hr_api.g_varchar2) then
1797: p_rec.annuitant_indicator_desc :=
1798: ghr_par_shd.g_old_rec.annuitant_indicator_desc;
1799: End If;
1800: If (p_rec.appropriation_code1 = hr_api.g_varchar2) then
1801: p_rec.appropriation_code1 :=
1802: ghr_par_shd.g_old_rec.appropriation_code1;
1803: End If;
1804: If (p_rec.appropriation_code2 = hr_api.g_varchar2) then
1800: If (p_rec.appropriation_code1 = hr_api.g_varchar2) then
1801: p_rec.appropriation_code1 :=
1802: ghr_par_shd.g_old_rec.appropriation_code1;
1803: End If;
1804: If (p_rec.appropriation_code2 = hr_api.g_varchar2) then
1805: p_rec.appropriation_code2 :=
1806: ghr_par_shd.g_old_rec.appropriation_code2;
1807: End If;
1808: If (p_rec.approval_date = hr_api.g_date) then
1804: If (p_rec.appropriation_code2 = hr_api.g_varchar2) then
1805: p_rec.appropriation_code2 :=
1806: ghr_par_shd.g_old_rec.appropriation_code2;
1807: End If;
1808: If (p_rec.approval_date = hr_api.g_date) then
1809: p_rec.approval_date :=
1810: ghr_par_shd.g_old_rec.approval_date;
1811: End If;
1812: If (p_rec.approving_official_full_name = hr_api.g_varchar2) then
1808: If (p_rec.approval_date = hr_api.g_date) then
1809: p_rec.approval_date :=
1810: ghr_par_shd.g_old_rec.approval_date;
1811: End If;
1812: If (p_rec.approving_official_full_name = hr_api.g_varchar2) then
1813: p_rec.approving_official_full_name :=
1814: ghr_par_shd.g_old_rec.approving_official_full_name;
1815: End If;
1816: If (p_rec.approving_official_work_title = hr_api.g_varchar2) then
1812: If (p_rec.approving_official_full_name = hr_api.g_varchar2) then
1813: p_rec.approving_official_full_name :=
1814: ghr_par_shd.g_old_rec.approving_official_full_name;
1815: End If;
1816: If (p_rec.approving_official_work_title = hr_api.g_varchar2) then
1817: p_rec.approving_official_work_title :=
1818: ghr_par_shd.g_old_rec.approving_official_work_title;
1819: End If;
1820: If (p_rec.sf50_approval_date = hr_api.g_date) then
1816: If (p_rec.approving_official_work_title = hr_api.g_varchar2) then
1817: p_rec.approving_official_work_title :=
1818: ghr_par_shd.g_old_rec.approving_official_work_title;
1819: End If;
1820: If (p_rec.sf50_approval_date = hr_api.g_date) then
1821: p_rec.sf50_approval_date :=
1822: ghr_par_shd.g_old_rec.sf50_approval_date;
1823: End If;
1824: If (p_rec.sf50_approving_ofcl_full_name = hr_api.g_varchar2) then
1820: If (p_rec.sf50_approval_date = hr_api.g_date) then
1821: p_rec.sf50_approval_date :=
1822: ghr_par_shd.g_old_rec.sf50_approval_date;
1823: End If;
1824: If (p_rec.sf50_approving_ofcl_full_name = hr_api.g_varchar2) then
1825: p_rec.sf50_approving_ofcl_full_name :=
1826: ghr_par_shd.g_old_rec.sf50_approving_ofcl_full_name ;
1827: End If;
1828: If (p_rec.sf50_approving_ofcl_work_title = hr_api.g_varchar2) then
1824: If (p_rec.sf50_approving_ofcl_full_name = hr_api.g_varchar2) then
1825: p_rec.sf50_approving_ofcl_full_name :=
1826: ghr_par_shd.g_old_rec.sf50_approving_ofcl_full_name ;
1827: End If;
1828: If (p_rec.sf50_approving_ofcl_work_title = hr_api.g_varchar2) then
1829: p_rec.sf50_approving_ofcl_work_title :=
1830: ghr_par_shd.g_old_rec.sf50_approving_ofcl_work_title;
1831: End If;
1832: If (p_rec.authorized_by_person_id = hr_api.g_number) then
1828: If (p_rec.sf50_approving_ofcl_work_title = hr_api.g_varchar2) then
1829: p_rec.sf50_approving_ofcl_work_title :=
1830: ghr_par_shd.g_old_rec.sf50_approving_ofcl_work_title;
1831: End If;
1832: If (p_rec.authorized_by_person_id = hr_api.g_number) then
1833: p_rec.authorized_by_person_id :=
1834: ghr_par_shd.g_old_rec.authorized_by_person_id;
1835: End If;
1836: If (p_rec.authorized_by_title = hr_api.g_varchar2) then
1832: If (p_rec.authorized_by_person_id = hr_api.g_number) then
1833: p_rec.authorized_by_person_id :=
1834: ghr_par_shd.g_old_rec.authorized_by_person_id;
1835: End If;
1836: If (p_rec.authorized_by_title = hr_api.g_varchar2) then
1837: p_rec.authorized_by_title :=
1838: ghr_par_shd.g_old_rec.authorized_by_title;
1839: End If;
1840: If (p_rec.award_amount = hr_api.g_number) then
1836: If (p_rec.authorized_by_title = hr_api.g_varchar2) then
1837: p_rec.authorized_by_title :=
1838: ghr_par_shd.g_old_rec.authorized_by_title;
1839: End If;
1840: If (p_rec.award_amount = hr_api.g_number) then
1841: p_rec.award_amount :=
1842: ghr_par_shd.g_old_rec.award_amount;
1843: End If;
1844: If (p_rec.award_uom = hr_api.g_varchar2) then
1840: If (p_rec.award_amount = hr_api.g_number) then
1841: p_rec.award_amount :=
1842: ghr_par_shd.g_old_rec.award_amount;
1843: End If;
1844: If (p_rec.award_uom = hr_api.g_varchar2) then
1845: p_rec.award_uom :=
1846: ghr_par_shd.g_old_rec.award_uom;
1847: End If;
1848: If (p_rec.bargaining_unit_status = hr_api.g_varchar2) then
1844: If (p_rec.award_uom = hr_api.g_varchar2) then
1845: p_rec.award_uom :=
1846: ghr_par_shd.g_old_rec.award_uom;
1847: End If;
1848: If (p_rec.bargaining_unit_status = hr_api.g_varchar2) then
1849: p_rec.bargaining_unit_status :=
1850: ghr_par_shd.g_old_rec.bargaining_unit_status;
1851: End If;
1852: If (p_rec.citizenship = hr_api.g_varchar2) then
1848: If (p_rec.bargaining_unit_status = hr_api.g_varchar2) then
1849: p_rec.bargaining_unit_status :=
1850: ghr_par_shd.g_old_rec.bargaining_unit_status;
1851: End If;
1852: If (p_rec.citizenship = hr_api.g_varchar2) then
1853: p_rec.citizenship :=
1854: ghr_par_shd.g_old_rec.citizenship;
1855: End If;
1856: If (p_rec.concurrence_date = hr_api.g_date) then
1852: If (p_rec.citizenship = hr_api.g_varchar2) then
1853: p_rec.citizenship :=
1854: ghr_par_shd.g_old_rec.citizenship;
1855: End If;
1856: If (p_rec.concurrence_date = hr_api.g_date) then
1857: p_rec.concurrence_date :=
1858: ghr_par_shd.g_old_rec.concurrence_date;
1859: End If;
1860: If (p_rec.custom_pay_calc_flag = hr_api.g_varchar2) then
1856: If (p_rec.concurrence_date = hr_api.g_date) then
1857: p_rec.concurrence_date :=
1858: ghr_par_shd.g_old_rec.concurrence_date;
1859: End If;
1860: If (p_rec.custom_pay_calc_flag = hr_api.g_varchar2) then
1861: p_rec.custom_pay_calc_flag :=
1862: ghr_par_shd.g_old_rec.custom_pay_calc_flag;
1863: End If;
1864: If (p_rec.duty_station_code = hr_api.g_varchar2) then
1860: If (p_rec.custom_pay_calc_flag = hr_api.g_varchar2) then
1861: p_rec.custom_pay_calc_flag :=
1862: ghr_par_shd.g_old_rec.custom_pay_calc_flag;
1863: End If;
1864: If (p_rec.duty_station_code = hr_api.g_varchar2) then
1865: p_rec.duty_station_code :=
1866: ghr_par_shd.g_old_rec.duty_station_code;
1867: End If;
1868: If (p_rec.duty_station_desc = hr_api.g_varchar2) then
1864: If (p_rec.duty_station_code = hr_api.g_varchar2) then
1865: p_rec.duty_station_code :=
1866: ghr_par_shd.g_old_rec.duty_station_code;
1867: End If;
1868: If (p_rec.duty_station_desc = hr_api.g_varchar2) then
1869: p_rec.duty_station_desc :=
1870: ghr_par_shd.g_old_rec.duty_station_desc;
1871: End If;
1872: If (p_rec.duty_station_id = hr_api.g_number) then
1868: If (p_rec.duty_station_desc = hr_api.g_varchar2) then
1869: p_rec.duty_station_desc :=
1870: ghr_par_shd.g_old_rec.duty_station_desc;
1871: End If;
1872: If (p_rec.duty_station_id = hr_api.g_number) then
1873: p_rec.duty_station_id :=
1874: ghr_par_shd.g_old_rec.duty_station_id;
1875: End If;
1876: If (p_rec.duty_station_location_id = hr_api.g_number) then
1872: If (p_rec.duty_station_id = hr_api.g_number) then
1873: p_rec.duty_station_id :=
1874: ghr_par_shd.g_old_rec.duty_station_id;
1875: End If;
1876: If (p_rec.duty_station_location_id = hr_api.g_number) then
1877: p_rec.duty_station_location_id :=
1878: ghr_par_shd.g_old_rec.duty_station_location_id;
1879: End If;
1880: If (p_rec.education_level = hr_api.g_varchar2) then
1876: If (p_rec.duty_station_location_id = hr_api.g_number) then
1877: p_rec.duty_station_location_id :=
1878: ghr_par_shd.g_old_rec.duty_station_location_id;
1879: End If;
1880: If (p_rec.education_level = hr_api.g_varchar2) then
1881: p_rec.education_level :=
1882: ghr_par_shd.g_old_rec.education_level;
1883: End If;
1884: If (p_rec.effective_date = hr_api.g_date) then
1880: If (p_rec.education_level = hr_api.g_varchar2) then
1881: p_rec.education_level :=
1882: ghr_par_shd.g_old_rec.education_level;
1883: End If;
1884: If (p_rec.effective_date = hr_api.g_date) then
1885: p_rec.effective_date :=
1886: ghr_par_shd.g_old_rec.effective_date;
1887: End If;
1888: If (p_rec.employee_assignment_id = hr_api.g_number) then
1884: If (p_rec.effective_date = hr_api.g_date) then
1885: p_rec.effective_date :=
1886: ghr_par_shd.g_old_rec.effective_date;
1887: End If;
1888: If (p_rec.employee_assignment_id = hr_api.g_number) then
1889: p_rec.employee_assignment_id :=
1890: ghr_par_shd.g_old_rec.employee_assignment_id;
1891: End If;
1892: If (p_rec.employee_date_of_birth = hr_api.g_date) then
1888: If (p_rec.employee_assignment_id = hr_api.g_number) then
1889: p_rec.employee_assignment_id :=
1890: ghr_par_shd.g_old_rec.employee_assignment_id;
1891: End If;
1892: If (p_rec.employee_date_of_birth = hr_api.g_date) then
1893: p_rec.employee_date_of_birth :=
1894: ghr_par_shd.g_old_rec.employee_date_of_birth;
1895: End If;
1896: If (p_rec.employee_dept_or_agency = hr_api.g_varchar2) then
1892: If (p_rec.employee_date_of_birth = hr_api.g_date) then
1893: p_rec.employee_date_of_birth :=
1894: ghr_par_shd.g_old_rec.employee_date_of_birth;
1895: End If;
1896: If (p_rec.employee_dept_or_agency = hr_api.g_varchar2) then
1897: p_rec.employee_dept_or_agency :=
1898: ghr_par_shd.g_old_rec.employee_dept_or_agency;
1899: End If;
1900: If (p_rec.employee_first_name = hr_api.g_varchar2) then
1896: If (p_rec.employee_dept_or_agency = hr_api.g_varchar2) then
1897: p_rec.employee_dept_or_agency :=
1898: ghr_par_shd.g_old_rec.employee_dept_or_agency;
1899: End If;
1900: If (p_rec.employee_first_name = hr_api.g_varchar2) then
1901: p_rec.employee_first_name :=
1902: ghr_par_shd.g_old_rec.employee_first_name;
1903: End If;
1904: If (p_rec.employee_last_name = hr_api.g_varchar2) then
1900: If (p_rec.employee_first_name = hr_api.g_varchar2) then
1901: p_rec.employee_first_name :=
1902: ghr_par_shd.g_old_rec.employee_first_name;
1903: End If;
1904: If (p_rec.employee_last_name = hr_api.g_varchar2) then
1905: p_rec.employee_last_name :=
1906: ghr_par_shd.g_old_rec.employee_last_name;
1907: End If;
1908: If (p_rec.employee_middle_names = hr_api.g_varchar2) then
1904: If (p_rec.employee_last_name = hr_api.g_varchar2) then
1905: p_rec.employee_last_name :=
1906: ghr_par_shd.g_old_rec.employee_last_name;
1907: End If;
1908: If (p_rec.employee_middle_names = hr_api.g_varchar2) then
1909: p_rec.employee_middle_names :=
1910: ghr_par_shd.g_old_rec.employee_middle_names;
1911: End If;
1912: If (p_rec.employee_national_identifier = hr_api.g_varchar2) then
1908: If (p_rec.employee_middle_names = hr_api.g_varchar2) then
1909: p_rec.employee_middle_names :=
1910: ghr_par_shd.g_old_rec.employee_middle_names;
1911: End If;
1912: If (p_rec.employee_national_identifier = hr_api.g_varchar2) then
1913: p_rec.employee_national_identifier :=
1914: ghr_par_shd.g_old_rec.employee_national_identifier;
1915: End If;
1916: If (p_rec.fegli = hr_api.g_varchar2) then
1912: If (p_rec.employee_national_identifier = hr_api.g_varchar2) then
1913: p_rec.employee_national_identifier :=
1914: ghr_par_shd.g_old_rec.employee_national_identifier;
1915: End If;
1916: If (p_rec.fegli = hr_api.g_varchar2) then
1917: p_rec.fegli :=
1918: ghr_par_shd.g_old_rec.fegli;
1919: End If;
1920: If (p_rec.fegli_desc = hr_api.g_varchar2) then
1916: If (p_rec.fegli = hr_api.g_varchar2) then
1917: p_rec.fegli :=
1918: ghr_par_shd.g_old_rec.fegli;
1919: End If;
1920: If (p_rec.fegli_desc = hr_api.g_varchar2) then
1921: p_rec.fegli_desc :=
1922: ghr_par_shd.g_old_rec.fegli_desc;
1923: End If;
1924: If (p_rec.first_action_la_code1 = hr_api.g_varchar2) then
1920: If (p_rec.fegli_desc = hr_api.g_varchar2) then
1921: p_rec.fegli_desc :=
1922: ghr_par_shd.g_old_rec.fegli_desc;
1923: End If;
1924: If (p_rec.first_action_la_code1 = hr_api.g_varchar2) then
1925: p_rec.first_action_la_code1 :=
1926: ghr_par_shd.g_old_rec.first_action_la_code1;
1927: End If;
1928: If (p_rec.first_action_la_code2 = hr_api.g_varchar2) then
1924: If (p_rec.first_action_la_code1 = hr_api.g_varchar2) then
1925: p_rec.first_action_la_code1 :=
1926: ghr_par_shd.g_old_rec.first_action_la_code1;
1927: End If;
1928: If (p_rec.first_action_la_code2 = hr_api.g_varchar2) then
1929: p_rec.first_action_la_code2 :=
1930: ghr_par_shd.g_old_rec.first_action_la_code2;
1931: End If;
1932: If (p_rec.first_action_la_desc1 = hr_api.g_varchar2) then
1928: If (p_rec.first_action_la_code2 = hr_api.g_varchar2) then
1929: p_rec.first_action_la_code2 :=
1930: ghr_par_shd.g_old_rec.first_action_la_code2;
1931: End If;
1932: If (p_rec.first_action_la_desc1 = hr_api.g_varchar2) then
1933: p_rec.first_action_la_desc1 :=
1934: ghr_par_shd.g_old_rec.first_action_la_desc1;
1935: End If;
1936: If (p_rec.first_action_la_desc2 = hr_api.g_varchar2) then
1932: If (p_rec.first_action_la_desc1 = hr_api.g_varchar2) then
1933: p_rec.first_action_la_desc1 :=
1934: ghr_par_shd.g_old_rec.first_action_la_desc1;
1935: End If;
1936: If (p_rec.first_action_la_desc2 = hr_api.g_varchar2) then
1937: p_rec.first_action_la_desc2 :=
1938: ghr_par_shd.g_old_rec.first_action_la_desc2;
1939: End If;
1940: If (p_rec.first_noa_cancel_or_correct = hr_api.g_varchar2) then
1936: If (p_rec.first_action_la_desc2 = hr_api.g_varchar2) then
1937: p_rec.first_action_la_desc2 :=
1938: ghr_par_shd.g_old_rec.first_action_la_desc2;
1939: End If;
1940: If (p_rec.first_noa_cancel_or_correct = hr_api.g_varchar2) then
1941: p_rec.first_noa_cancel_or_correct :=
1942: ghr_par_shd.g_old_rec.first_noa_cancel_or_correct;
1943: End If;
1944: If (p_rec.first_noa_code = hr_api.g_varchar2) then
1940: If (p_rec.first_noa_cancel_or_correct = hr_api.g_varchar2) then
1941: p_rec.first_noa_cancel_or_correct :=
1942: ghr_par_shd.g_old_rec.first_noa_cancel_or_correct;
1943: End If;
1944: If (p_rec.first_noa_code = hr_api.g_varchar2) then
1945: p_rec.first_noa_code :=
1946: ghr_par_shd.g_old_rec.first_noa_code;
1947: End If;
1948: If (p_rec.first_noa_desc = hr_api.g_varchar2) then
1944: If (p_rec.first_noa_code = hr_api.g_varchar2) then
1945: p_rec.first_noa_code :=
1946: ghr_par_shd.g_old_rec.first_noa_code;
1947: End If;
1948: If (p_rec.first_noa_desc = hr_api.g_varchar2) then
1949: p_rec.first_noa_desc :=
1950: ghr_par_shd.g_old_rec.first_noa_desc;
1951: End If;
1952: If (p_rec.first_noa_id = hr_api.g_number) then
1948: If (p_rec.first_noa_desc = hr_api.g_varchar2) then
1949: p_rec.first_noa_desc :=
1950: ghr_par_shd.g_old_rec.first_noa_desc;
1951: End If;
1952: If (p_rec.first_noa_id = hr_api.g_number) then
1953: p_rec.first_noa_id :=
1954: ghr_par_shd.g_old_rec.first_noa_id;
1955: End If;
1956: If (p_rec.first_noa_pa_request_id = hr_api.g_number) then
1952: If (p_rec.first_noa_id = hr_api.g_number) then
1953: p_rec.first_noa_id :=
1954: ghr_par_shd.g_old_rec.first_noa_id;
1955: End If;
1956: If (p_rec.first_noa_pa_request_id = hr_api.g_number) then
1957: p_rec.first_noa_pa_request_id :=
1958: ghr_par_shd.g_old_rec.first_noa_pa_request_id;
1959: End If;
1960: If (p_rec.flsa_category = hr_api.g_varchar2) then
1956: If (p_rec.first_noa_pa_request_id = hr_api.g_number) then
1957: p_rec.first_noa_pa_request_id :=
1958: ghr_par_shd.g_old_rec.first_noa_pa_request_id;
1959: End If;
1960: If (p_rec.flsa_category = hr_api.g_varchar2) then
1961: p_rec.flsa_category :=
1962: ghr_par_shd.g_old_rec.flsa_category;
1963: End If;
1964: If (p_rec.forwarding_address_line1 = hr_api.g_varchar2) then
1960: If (p_rec.flsa_category = hr_api.g_varchar2) then
1961: p_rec.flsa_category :=
1962: ghr_par_shd.g_old_rec.flsa_category;
1963: End If;
1964: If (p_rec.forwarding_address_line1 = hr_api.g_varchar2) then
1965: p_rec.forwarding_address_line1 :=
1966: ghr_par_shd.g_old_rec.forwarding_address_line1;
1967: End If;
1968: If (p_rec.forwarding_address_line2 = hr_api.g_varchar2) then
1964: If (p_rec.forwarding_address_line1 = hr_api.g_varchar2) then
1965: p_rec.forwarding_address_line1 :=
1966: ghr_par_shd.g_old_rec.forwarding_address_line1;
1967: End If;
1968: If (p_rec.forwarding_address_line2 = hr_api.g_varchar2) then
1969: p_rec.forwarding_address_line2 :=
1970: ghr_par_shd.g_old_rec.forwarding_address_line2;
1971: End If;
1972: If (p_rec.forwarding_address_line3 = hr_api.g_varchar2) then
1968: If (p_rec.forwarding_address_line2 = hr_api.g_varchar2) then
1969: p_rec.forwarding_address_line2 :=
1970: ghr_par_shd.g_old_rec.forwarding_address_line2;
1971: End If;
1972: If (p_rec.forwarding_address_line3 = hr_api.g_varchar2) then
1973: p_rec.forwarding_address_line3 :=
1974: ghr_par_shd.g_old_rec.forwarding_address_line3;
1975: End If;
1976: If (p_rec.forwarding_country_short_name = hr_api.g_varchar2) then
1972: If (p_rec.forwarding_address_line3 = hr_api.g_varchar2) then
1973: p_rec.forwarding_address_line3 :=
1974: ghr_par_shd.g_old_rec.forwarding_address_line3;
1975: End If;
1976: If (p_rec.forwarding_country_short_name = hr_api.g_varchar2) then
1977: p_rec.forwarding_country_short_name :=
1978: ghr_par_shd.g_old_rec.forwarding_country_short_name;
1979: End If;
1980: If (p_rec.forwarding_country = hr_api.g_varchar2) then
1976: If (p_rec.forwarding_country_short_name = hr_api.g_varchar2) then
1977: p_rec.forwarding_country_short_name :=
1978: ghr_par_shd.g_old_rec.forwarding_country_short_name;
1979: End If;
1980: If (p_rec.forwarding_country = hr_api.g_varchar2) then
1981: p_rec.forwarding_country :=
1982: ghr_par_shd.g_old_rec.forwarding_country;
1983: End If;
1984: If (p_rec.forwarding_postal_code = hr_api.g_varchar2) then
1980: If (p_rec.forwarding_country = hr_api.g_varchar2) then
1981: p_rec.forwarding_country :=
1982: ghr_par_shd.g_old_rec.forwarding_country;
1983: End If;
1984: If (p_rec.forwarding_postal_code = hr_api.g_varchar2) then
1985: p_rec.forwarding_postal_code :=
1986: ghr_par_shd.g_old_rec.forwarding_postal_code;
1987: End If;
1988: If (p_rec.forwarding_region_2 = hr_api.g_varchar2) then
1984: If (p_rec.forwarding_postal_code = hr_api.g_varchar2) then
1985: p_rec.forwarding_postal_code :=
1986: ghr_par_shd.g_old_rec.forwarding_postal_code;
1987: End If;
1988: If (p_rec.forwarding_region_2 = hr_api.g_varchar2) then
1989: p_rec.forwarding_region_2 :=
1990: ghr_par_shd.g_old_rec.forwarding_region_2;
1991: End If;
1992: If (p_rec.forwarding_town_or_city = hr_api.g_varchar2) then
1988: If (p_rec.forwarding_region_2 = hr_api.g_varchar2) then
1989: p_rec.forwarding_region_2 :=
1990: ghr_par_shd.g_old_rec.forwarding_region_2;
1991: End If;
1992: If (p_rec.forwarding_town_or_city = hr_api.g_varchar2) then
1993: p_rec.forwarding_town_or_city :=
1994: ghr_par_shd.g_old_rec.forwarding_town_or_city;
1995: End If;
1996: If (p_rec.from_adj_basic_pay = hr_api.g_number) then
1992: If (p_rec.forwarding_town_or_city = hr_api.g_varchar2) then
1993: p_rec.forwarding_town_or_city :=
1994: ghr_par_shd.g_old_rec.forwarding_town_or_city;
1995: End If;
1996: If (p_rec.from_adj_basic_pay = hr_api.g_number) then
1997: p_rec.from_adj_basic_pay :=
1998: ghr_par_shd.g_old_rec.from_adj_basic_pay;
1999: End If;
2000: If (p_rec.from_agency_code = hr_api.g_varchar2) then
1996: If (p_rec.from_adj_basic_pay = hr_api.g_number) then
1997: p_rec.from_adj_basic_pay :=
1998: ghr_par_shd.g_old_rec.from_adj_basic_pay;
1999: End If;
2000: If (p_rec.from_agency_code = hr_api.g_varchar2) then
2001: p_rec.from_agency_code :=
2002: ghr_par_shd.g_old_rec.from_agency_code;
2003: End If;
2004: If (p_rec.from_agency_desc = hr_api.g_varchar2) then
2000: If (p_rec.from_agency_code = hr_api.g_varchar2) then
2001: p_rec.from_agency_code :=
2002: ghr_par_shd.g_old_rec.from_agency_code;
2003: End If;
2004: If (p_rec.from_agency_desc = hr_api.g_varchar2) then
2005: p_rec.from_agency_desc :=
2006: ghr_par_shd.g_old_rec.from_agency_desc;
2007: End If;
2008: If (p_rec.from_basic_pay = hr_api.g_number) then
2004: If (p_rec.from_agency_desc = hr_api.g_varchar2) then
2005: p_rec.from_agency_desc :=
2006: ghr_par_shd.g_old_rec.from_agency_desc;
2007: End If;
2008: If (p_rec.from_basic_pay = hr_api.g_number) then
2009: p_rec.from_basic_pay :=
2010: ghr_par_shd.g_old_rec.from_basic_pay;
2011: End If;
2012: If (p_rec.from_grade_or_level = hr_api.g_varchar2) then
2008: If (p_rec.from_basic_pay = hr_api.g_number) then
2009: p_rec.from_basic_pay :=
2010: ghr_par_shd.g_old_rec.from_basic_pay;
2011: End If;
2012: If (p_rec.from_grade_or_level = hr_api.g_varchar2) then
2013: p_rec.from_grade_or_level :=
2014: ghr_par_shd.g_old_rec.from_grade_or_level;
2015: End If;
2016: If (p_rec.from_locality_adj = hr_api.g_number) then
2012: If (p_rec.from_grade_or_level = hr_api.g_varchar2) then
2013: p_rec.from_grade_or_level :=
2014: ghr_par_shd.g_old_rec.from_grade_or_level;
2015: End If;
2016: If (p_rec.from_locality_adj = hr_api.g_number) then
2017: p_rec.from_locality_adj :=
2018: ghr_par_shd.g_old_rec.from_locality_adj;
2019: End If;
2020: If (p_rec.from_occ_code = hr_api.g_varchar2) then
2016: If (p_rec.from_locality_adj = hr_api.g_number) then
2017: p_rec.from_locality_adj :=
2018: ghr_par_shd.g_old_rec.from_locality_adj;
2019: End If;
2020: If (p_rec.from_occ_code = hr_api.g_varchar2) then
2021: p_rec.from_occ_code :=
2022: ghr_par_shd.g_old_rec.from_occ_code;
2023: End If;
2024: If (p_rec.from_office_symbol = hr_api.g_varchar2) then
2020: If (p_rec.from_occ_code = hr_api.g_varchar2) then
2021: p_rec.from_occ_code :=
2022: ghr_par_shd.g_old_rec.from_occ_code;
2023: End If;
2024: If (p_rec.from_office_symbol = hr_api.g_varchar2) then
2025: p_rec.from_office_symbol :=
2026: ghr_par_shd.g_old_rec.from_office_symbol;
2027: End If;
2028: If (p_rec.from_other_pay_amount = hr_api.g_number) then
2024: If (p_rec.from_office_symbol = hr_api.g_varchar2) then
2025: p_rec.from_office_symbol :=
2026: ghr_par_shd.g_old_rec.from_office_symbol;
2027: End If;
2028: If (p_rec.from_other_pay_amount = hr_api.g_number) then
2029: p_rec.from_other_pay_amount :=
2030: ghr_par_shd.g_old_rec.from_other_pay_amount;
2031: End If;
2032: If (p_rec.from_pay_basis = hr_api.g_varchar2) then
2028: If (p_rec.from_other_pay_amount = hr_api.g_number) then
2029: p_rec.from_other_pay_amount :=
2030: ghr_par_shd.g_old_rec.from_other_pay_amount;
2031: End If;
2032: If (p_rec.from_pay_basis = hr_api.g_varchar2) then
2033: p_rec.from_pay_basis :=
2034: ghr_par_shd.g_old_rec.from_pay_basis;
2035: End If;
2036: If (p_rec.from_pay_plan = hr_api.g_varchar2) then
2032: If (p_rec.from_pay_basis = hr_api.g_varchar2) then
2033: p_rec.from_pay_basis :=
2034: ghr_par_shd.g_old_rec.from_pay_basis;
2035: End If;
2036: If (p_rec.from_pay_plan = hr_api.g_varchar2) then
2037: p_rec.from_pay_plan :=
2038: ghr_par_shd.g_old_rec.from_pay_plan;
2039: End If;
2040: -- FWFA Changes Bug#4444609
2037: p_rec.from_pay_plan :=
2038: ghr_par_shd.g_old_rec.from_pay_plan;
2039: End If;
2040: -- FWFA Changes Bug#4444609
2041: If (p_rec.input_pay_rate_determinant = hr_api.g_varchar2) then
2042: p_rec.input_pay_rate_determinant :=
2043: ghr_par_shd.g_old_rec.input_pay_rate_determinant;
2044: End If;
2045: If (p_rec.from_pay_table_identifier = hr_api.g_number) then
2041: If (p_rec.input_pay_rate_determinant = hr_api.g_varchar2) then
2042: p_rec.input_pay_rate_determinant :=
2043: ghr_par_shd.g_old_rec.input_pay_rate_determinant;
2044: End If;
2045: If (p_rec.from_pay_table_identifier = hr_api.g_number) then
2046: p_rec.from_pay_table_identifier :=
2047: ghr_par_shd.g_old_rec.from_pay_table_identifier;
2048: End If;
2049: -- FWFA Changes
2046: p_rec.from_pay_table_identifier :=
2047: ghr_par_shd.g_old_rec.from_pay_table_identifier;
2048: End If;
2049: -- FWFA Changes
2050: If (p_rec.from_position_org_line1 = hr_api.g_varchar2) then
2051: p_rec.from_position_org_line1 :=
2052: ghr_par_shd.g_old_rec.from_position_org_line1;
2053: End If;
2054: If (p_rec.from_position_org_line2 = hr_api.g_varchar2) then
2050: If (p_rec.from_position_org_line1 = hr_api.g_varchar2) then
2051: p_rec.from_position_org_line1 :=
2052: ghr_par_shd.g_old_rec.from_position_org_line1;
2053: End If;
2054: If (p_rec.from_position_org_line2 = hr_api.g_varchar2) then
2055: p_rec.from_position_org_line2 :=
2056: ghr_par_shd.g_old_rec.from_position_org_line2;
2057: End If;
2058: If (p_rec.from_position_org_line3 = hr_api.g_varchar2) then
2054: If (p_rec.from_position_org_line2 = hr_api.g_varchar2) then
2055: p_rec.from_position_org_line2 :=
2056: ghr_par_shd.g_old_rec.from_position_org_line2;
2057: End If;
2058: If (p_rec.from_position_org_line3 = hr_api.g_varchar2) then
2059: p_rec.from_position_org_line3 :=
2060: ghr_par_shd.g_old_rec.from_position_org_line3;
2061: End If;
2062: If (p_rec.from_position_org_line4 = hr_api.g_varchar2) then
2058: If (p_rec.from_position_org_line3 = hr_api.g_varchar2) then
2059: p_rec.from_position_org_line3 :=
2060: ghr_par_shd.g_old_rec.from_position_org_line3;
2061: End If;
2062: If (p_rec.from_position_org_line4 = hr_api.g_varchar2) then
2063: p_rec.from_position_org_line4 :=
2064: ghr_par_shd.g_old_rec.from_position_org_line4;
2065: End If;
2066: If (p_rec.from_position_org_line5 = hr_api.g_varchar2) then
2062: If (p_rec.from_position_org_line4 = hr_api.g_varchar2) then
2063: p_rec.from_position_org_line4 :=
2064: ghr_par_shd.g_old_rec.from_position_org_line4;
2065: End If;
2066: If (p_rec.from_position_org_line5 = hr_api.g_varchar2) then
2067: p_rec.from_position_org_line5 :=
2068: ghr_par_shd.g_old_rec.from_position_org_line5;
2069: End If;
2070: If (p_rec.from_position_org_line6 = hr_api.g_varchar2) then
2066: If (p_rec.from_position_org_line5 = hr_api.g_varchar2) then
2067: p_rec.from_position_org_line5 :=
2068: ghr_par_shd.g_old_rec.from_position_org_line5;
2069: End If;
2070: If (p_rec.from_position_org_line6 = hr_api.g_varchar2) then
2071: p_rec.from_position_org_line6 :=
2072: ghr_par_shd.g_old_rec.from_position_org_line6;
2073: End If;
2074: If (p_rec.from_position_id = hr_api.g_number) then
2070: If (p_rec.from_position_org_line6 = hr_api.g_varchar2) then
2071: p_rec.from_position_org_line6 :=
2072: ghr_par_shd.g_old_rec.from_position_org_line6;
2073: End If;
2074: If (p_rec.from_position_id = hr_api.g_number) then
2075: p_rec.from_position_id :=
2076: ghr_par_shd.g_old_rec.from_position_id;
2077: End If;
2078: If (p_rec.from_position_number = hr_api.g_varchar2) then
2074: If (p_rec.from_position_id = hr_api.g_number) then
2075: p_rec.from_position_id :=
2076: ghr_par_shd.g_old_rec.from_position_id;
2077: End If;
2078: If (p_rec.from_position_number = hr_api.g_varchar2) then
2079: p_rec.from_position_number :=
2080: ghr_par_shd.g_old_rec.from_position_number;
2081: End If;
2082: If (p_rec.from_position_seq_no = hr_api.g_number) then
2078: If (p_rec.from_position_number = hr_api.g_varchar2) then
2079: p_rec.from_position_number :=
2080: ghr_par_shd.g_old_rec.from_position_number;
2081: End If;
2082: If (p_rec.from_position_seq_no = hr_api.g_number) then
2083: p_rec.from_position_seq_no :=
2084: ghr_par_shd.g_old_rec.from_position_seq_no;
2085: End If;
2086: If (p_rec.from_position_title = hr_api.g_varchar2) then
2082: If (p_rec.from_position_seq_no = hr_api.g_number) then
2083: p_rec.from_position_seq_no :=
2084: ghr_par_shd.g_old_rec.from_position_seq_no;
2085: End If;
2086: If (p_rec.from_position_title = hr_api.g_varchar2) then
2087: p_rec.from_position_title :=
2088: ghr_par_shd.g_old_rec.from_position_title;
2089: End If;
2090: If (p_rec.from_step_or_rate = hr_api.g_varchar2) then
2086: If (p_rec.from_position_title = hr_api.g_varchar2) then
2087: p_rec.from_position_title :=
2088: ghr_par_shd.g_old_rec.from_position_title;
2089: End If;
2090: If (p_rec.from_step_or_rate = hr_api.g_varchar2) then
2091: p_rec.from_step_or_rate :=
2092: ghr_par_shd.g_old_rec.from_step_or_rate;
2093: End If;
2094: If (p_rec.from_total_salary = hr_api.g_number) then
2090: If (p_rec.from_step_or_rate = hr_api.g_varchar2) then
2091: p_rec.from_step_or_rate :=
2092: ghr_par_shd.g_old_rec.from_step_or_rate;
2093: End If;
2094: If (p_rec.from_total_salary = hr_api.g_number) then
2095: p_rec.from_total_salary :=
2096: ghr_par_shd.g_old_rec.from_total_salary;
2097: End If;
2098: If (p_rec.functional_class = hr_api.g_varchar2) then
2094: If (p_rec.from_total_salary = hr_api.g_number) then
2095: p_rec.from_total_salary :=
2096: ghr_par_shd.g_old_rec.from_total_salary;
2097: End If;
2098: If (p_rec.functional_class = hr_api.g_varchar2) then
2099: p_rec.functional_class :=
2100: ghr_par_shd.g_old_rec.functional_class;
2101: End If;
2102: If (p_rec.notepad = hr_api.g_varchar2) then
2098: If (p_rec.functional_class = hr_api.g_varchar2) then
2099: p_rec.functional_class :=
2100: ghr_par_shd.g_old_rec.functional_class;
2101: End If;
2102: If (p_rec.notepad = hr_api.g_varchar2) then
2103: p_rec.notepad :=
2104: ghr_par_shd.g_old_rec.notepad;
2105: End If;
2106: If (p_rec.part_time_hours = hr_api.g_number) then
2102: If (p_rec.notepad = hr_api.g_varchar2) then
2103: p_rec.notepad :=
2104: ghr_par_shd.g_old_rec.notepad;
2105: End If;
2106: If (p_rec.part_time_hours = hr_api.g_number) then
2107: p_rec.part_time_hours :=
2108: ghr_par_shd.g_old_rec.part_time_hours;
2109: End If;
2110: If (p_rec.pay_rate_determinant = hr_api.g_varchar2) then
2106: If (p_rec.part_time_hours = hr_api.g_number) then
2107: p_rec.part_time_hours :=
2108: ghr_par_shd.g_old_rec.part_time_hours;
2109: End If;
2110: If (p_rec.pay_rate_determinant = hr_api.g_varchar2) then
2111: p_rec.pay_rate_determinant :=
2112: ghr_par_shd.g_old_rec.pay_rate_determinant;
2113: End If;
2114: If (p_rec.personnel_office_id = hr_api.g_varchar2) then
2110: If (p_rec.pay_rate_determinant = hr_api.g_varchar2) then
2111: p_rec.pay_rate_determinant :=
2112: ghr_par_shd.g_old_rec.pay_rate_determinant;
2113: End If;
2114: If (p_rec.personnel_office_id = hr_api.g_varchar2) then
2115: p_rec.personnel_office_id :=
2116: ghr_par_shd.g_old_rec.personnel_office_id;
2117: End If;
2118: If (p_rec.person_id = hr_api.g_number) then
2114: If (p_rec.personnel_office_id = hr_api.g_varchar2) then
2115: p_rec.personnel_office_id :=
2116: ghr_par_shd.g_old_rec.personnel_office_id;
2117: End If;
2118: If (p_rec.person_id = hr_api.g_number) then
2119: p_rec.person_id :=
2120: ghr_par_shd.g_old_rec.person_id;
2121: End If;
2122: If (p_rec.position_occupied = hr_api.g_varchar2) then
2118: If (p_rec.person_id = hr_api.g_number) then
2119: p_rec.person_id :=
2120: ghr_par_shd.g_old_rec.person_id;
2121: End If;
2122: If (p_rec.position_occupied = hr_api.g_varchar2) then
2123: p_rec.position_occupied :=
2124: ghr_par_shd.g_old_rec.position_occupied;
2125: End If;
2126: If (p_rec.proposed_effective_date = hr_api.g_date) then
2122: If (p_rec.position_occupied = hr_api.g_varchar2) then
2123: p_rec.position_occupied :=
2124: ghr_par_shd.g_old_rec.position_occupied;
2125: End If;
2126: If (p_rec.proposed_effective_date = hr_api.g_date) then
2127: p_rec.proposed_effective_date :=
2128: ghr_par_shd.g_old_rec.proposed_effective_date;
2129: End If;
2130: If (p_rec.proposed_effective_asap_flag = hr_api.g_varchar2) then
2126: If (p_rec.proposed_effective_date = hr_api.g_date) then
2127: p_rec.proposed_effective_date :=
2128: ghr_par_shd.g_old_rec.proposed_effective_date;
2129: End If;
2130: If (p_rec.proposed_effective_asap_flag = hr_api.g_varchar2) then
2131: p_rec.proposed_effective_asap_flag :=
2132: ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
2133: End If;
2134:
2131: p_rec.proposed_effective_asap_flag :=
2132: ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
2133: End If;
2134:
2135: If (p_rec.requested_by_person_id = hr_api.g_number) then
2136: p_rec.requested_by_person_id :=
2137: ghr_par_shd.g_old_rec.requested_by_person_id;
2138: End If;
2139: If (p_rec.requested_by_title = hr_api.g_varchar2) then
2135: If (p_rec.requested_by_person_id = hr_api.g_number) then
2136: p_rec.requested_by_person_id :=
2137: ghr_par_shd.g_old_rec.requested_by_person_id;
2138: End If;
2139: If (p_rec.requested_by_title = hr_api.g_varchar2) then
2140: p_rec.requested_by_title :=
2141: ghr_par_shd.g_old_rec.requested_by_title;
2142: End If;
2143: If (p_rec.requested_date = hr_api.g_date) then
2139: If (p_rec.requested_by_title = hr_api.g_varchar2) then
2140: p_rec.requested_by_title :=
2141: ghr_par_shd.g_old_rec.requested_by_title;
2142: End If;
2143: If (p_rec.requested_date = hr_api.g_date) then
2144: p_rec.requested_date :=
2145: ghr_par_shd.g_old_rec.requested_date;
2146: End If;
2147: If (p_rec.requesting_office_remarks_desc = hr_api.g_varchar2) then
2143: If (p_rec.requested_date = hr_api.g_date) then
2144: p_rec.requested_date :=
2145: ghr_par_shd.g_old_rec.requested_date;
2146: End If;
2147: If (p_rec.requesting_office_remarks_desc = hr_api.g_varchar2) then
2148: p_rec.requesting_office_remarks_desc :=
2149: ghr_par_shd.g_old_rec.requesting_office_remarks_desc;
2150: End If;
2151: If (p_rec.requesting_office_remarks_flag = hr_api.g_varchar2) then
2147: If (p_rec.requesting_office_remarks_desc = hr_api.g_varchar2) then
2148: p_rec.requesting_office_remarks_desc :=
2149: ghr_par_shd.g_old_rec.requesting_office_remarks_desc;
2150: End If;
2151: If (p_rec.requesting_office_remarks_flag = hr_api.g_varchar2) then
2152: p_rec.requesting_office_remarks_flag :=
2153: ghr_par_shd.g_old_rec.requesting_office_remarks_flag;
2154: End If;
2155: If (p_rec.request_number = hr_api.g_varchar2) then
2151: If (p_rec.requesting_office_remarks_flag = hr_api.g_varchar2) then
2152: p_rec.requesting_office_remarks_flag :=
2153: ghr_par_shd.g_old_rec.requesting_office_remarks_flag;
2154: End If;
2155: If (p_rec.request_number = hr_api.g_varchar2) then
2156: p_rec.request_number :=
2157: ghr_par_shd.g_old_rec.request_number;
2158: End If;
2159: If (p_rec.resign_and_retire_reason_desc = hr_api.g_varchar2) then
2155: If (p_rec.request_number = hr_api.g_varchar2) then
2156: p_rec.request_number :=
2157: ghr_par_shd.g_old_rec.request_number;
2158: End If;
2159: If (p_rec.resign_and_retire_reason_desc = hr_api.g_varchar2) then
2160: p_rec.resign_and_retire_reason_desc :=
2161: ghr_par_shd.g_old_rec.resign_and_retire_reason_desc;
2162: End If;
2163: If (p_rec.retirement_plan = hr_api.g_varchar2) then
2159: If (p_rec.resign_and_retire_reason_desc = hr_api.g_varchar2) then
2160: p_rec.resign_and_retire_reason_desc :=
2161: ghr_par_shd.g_old_rec.resign_and_retire_reason_desc;
2162: End If;
2163: If (p_rec.retirement_plan = hr_api.g_varchar2) then
2164: p_rec.retirement_plan :=
2165: ghr_par_shd.g_old_rec.retirement_plan;
2166: End If;
2167: If (p_rec.retirement_plan_desc = hr_api.g_varchar2) then
2163: If (p_rec.retirement_plan = hr_api.g_varchar2) then
2164: p_rec.retirement_plan :=
2165: ghr_par_shd.g_old_rec.retirement_plan;
2166: End If;
2167: If (p_rec.retirement_plan_desc = hr_api.g_varchar2) then
2168: p_rec.retirement_plan_desc :=
2169: ghr_par_shd.g_old_rec.retirement_plan_desc;
2170: End If;
2171: If (p_rec.second_action_la_code1 = hr_api.g_varchar2) then
2167: If (p_rec.retirement_plan_desc = hr_api.g_varchar2) then
2168: p_rec.retirement_plan_desc :=
2169: ghr_par_shd.g_old_rec.retirement_plan_desc;
2170: End If;
2171: If (p_rec.second_action_la_code1 = hr_api.g_varchar2) then
2172: p_rec.second_action_la_code1 :=
2173: ghr_par_shd.g_old_rec.second_action_la_code1;
2174: End If;
2175: If (p_rec.second_action_la_code2 = hr_api.g_varchar2) then
2171: If (p_rec.second_action_la_code1 = hr_api.g_varchar2) then
2172: p_rec.second_action_la_code1 :=
2173: ghr_par_shd.g_old_rec.second_action_la_code1;
2174: End If;
2175: If (p_rec.second_action_la_code2 = hr_api.g_varchar2) then
2176: p_rec.second_action_la_code2 :=
2177: ghr_par_shd.g_old_rec.second_action_la_code2;
2178: End If;
2179: If (p_rec.second_action_la_desc1 = hr_api.g_varchar2) then
2175: If (p_rec.second_action_la_code2 = hr_api.g_varchar2) then
2176: p_rec.second_action_la_code2 :=
2177: ghr_par_shd.g_old_rec.second_action_la_code2;
2178: End If;
2179: If (p_rec.second_action_la_desc1 = hr_api.g_varchar2) then
2180: p_rec.second_action_la_desc1 :=
2181: ghr_par_shd.g_old_rec.second_action_la_desc1;
2182: End If;
2183: If (p_rec.second_action_la_desc2 = hr_api.g_varchar2) then
2179: If (p_rec.second_action_la_desc1 = hr_api.g_varchar2) then
2180: p_rec.second_action_la_desc1 :=
2181: ghr_par_shd.g_old_rec.second_action_la_desc1;
2182: End If;
2183: If (p_rec.second_action_la_desc2 = hr_api.g_varchar2) then
2184: p_rec.second_action_la_desc2 :=
2185: ghr_par_shd.g_old_rec.second_action_la_desc2;
2186: End If;
2187: If (p_rec.second_noa_cancel_or_correct = hr_api.g_varchar2) then
2183: If (p_rec.second_action_la_desc2 = hr_api.g_varchar2) then
2184: p_rec.second_action_la_desc2 :=
2185: ghr_par_shd.g_old_rec.second_action_la_desc2;
2186: End If;
2187: If (p_rec.second_noa_cancel_or_correct = hr_api.g_varchar2) then
2188: p_rec.second_noa_cancel_or_correct :=
2189: ghr_par_shd.g_old_rec.second_noa_cancel_or_correct;
2190: End If;
2191: If (p_rec.second_noa_code = hr_api.g_varchar2) then
2187: If (p_rec.second_noa_cancel_or_correct = hr_api.g_varchar2) then
2188: p_rec.second_noa_cancel_or_correct :=
2189: ghr_par_shd.g_old_rec.second_noa_cancel_or_correct;
2190: End If;
2191: If (p_rec.second_noa_code = hr_api.g_varchar2) then
2192: p_rec.second_noa_code :=
2193: ghr_par_shd.g_old_rec.second_noa_code;
2194: End If;
2195: If (p_rec.second_noa_desc = hr_api.g_varchar2) then
2191: If (p_rec.second_noa_code = hr_api.g_varchar2) then
2192: p_rec.second_noa_code :=
2193: ghr_par_shd.g_old_rec.second_noa_code;
2194: End If;
2195: If (p_rec.second_noa_desc = hr_api.g_varchar2) then
2196: p_rec.second_noa_desc :=
2197: ghr_par_shd.g_old_rec.second_noa_desc;
2198: End If;
2199: If (p_rec.second_noa_id = hr_api.g_number) then
2195: If (p_rec.second_noa_desc = hr_api.g_varchar2) then
2196: p_rec.second_noa_desc :=
2197: ghr_par_shd.g_old_rec.second_noa_desc;
2198: End If;
2199: If (p_rec.second_noa_id = hr_api.g_number) then
2200: p_rec.second_noa_id :=
2201: ghr_par_shd.g_old_rec.second_noa_id;
2202: End If;
2203: If (p_rec.second_noa_pa_request_id = hr_api.g_number) then
2199: If (p_rec.second_noa_id = hr_api.g_number) then
2200: p_rec.second_noa_id :=
2201: ghr_par_shd.g_old_rec.second_noa_id;
2202: End If;
2203: If (p_rec.second_noa_pa_request_id = hr_api.g_number) then
2204: p_rec.second_noa_pa_request_id :=
2205: ghr_par_shd.g_old_rec.second_noa_pa_request_id;
2206: End If;
2207: If (p_rec.service_comp_date = hr_api.g_date) then
2203: If (p_rec.second_noa_pa_request_id = hr_api.g_number) then
2204: p_rec.second_noa_pa_request_id :=
2205: ghr_par_shd.g_old_rec.second_noa_pa_request_id;
2206: End If;
2207: If (p_rec.service_comp_date = hr_api.g_date) then
2208: p_rec.service_comp_date :=
2209: ghr_par_shd.g_old_rec.service_comp_date;
2210: End If;
2211: If (p_rec.status = hr_api.g_varchar2) then
2207: If (p_rec.service_comp_date = hr_api.g_date) then
2208: p_rec.service_comp_date :=
2209: ghr_par_shd.g_old_rec.service_comp_date;
2210: End If;
2211: If (p_rec.status = hr_api.g_varchar2) then
2212: p_rec.status :=
2213: ghr_par_shd.g_old_rec.status;
2214: End If;
2215: If (p_rec.supervisory_status = hr_api.g_varchar2) then
2211: If (p_rec.status = hr_api.g_varchar2) then
2212: p_rec.status :=
2213: ghr_par_shd.g_old_rec.status;
2214: End If;
2215: If (p_rec.supervisory_status = hr_api.g_varchar2) then
2216: p_rec.supervisory_status :=
2217: ghr_par_shd.g_old_rec.supervisory_status;
2218: End If;
2219: If (p_rec.tenure = hr_api.g_varchar2) then
2215: If (p_rec.supervisory_status = hr_api.g_varchar2) then
2216: p_rec.supervisory_status :=
2217: ghr_par_shd.g_old_rec.supervisory_status;
2218: End If;
2219: If (p_rec.tenure = hr_api.g_varchar2) then
2220: p_rec.tenure :=
2221: ghr_par_shd.g_old_rec.tenure;
2222: End If;
2223: If (p_rec.to_adj_basic_pay = hr_api.g_number) then
2219: If (p_rec.tenure = hr_api.g_varchar2) then
2220: p_rec.tenure :=
2221: ghr_par_shd.g_old_rec.tenure;
2222: End If;
2223: If (p_rec.to_adj_basic_pay = hr_api.g_number) then
2224: p_rec.to_adj_basic_pay :=
2225: ghr_par_shd.g_old_rec.to_adj_basic_pay;
2226: End If;
2227: If (p_rec.to_basic_pay = hr_api.g_number) then
2223: If (p_rec.to_adj_basic_pay = hr_api.g_number) then
2224: p_rec.to_adj_basic_pay :=
2225: ghr_par_shd.g_old_rec.to_adj_basic_pay;
2226: End If;
2227: If (p_rec.to_basic_pay = hr_api.g_number) then
2228: p_rec.to_basic_pay :=
2229: ghr_par_shd.g_old_rec.to_basic_pay;
2230: End If;
2231: If (p_rec.to_grade_id = hr_api.g_number) then
2227: If (p_rec.to_basic_pay = hr_api.g_number) then
2228: p_rec.to_basic_pay :=
2229: ghr_par_shd.g_old_rec.to_basic_pay;
2230: End If;
2231: If (p_rec.to_grade_id = hr_api.g_number) then
2232: p_rec.to_grade_id :=
2233: ghr_par_shd.g_old_rec.to_grade_id;
2234: End If;
2235: If (p_rec.to_grade_or_level = hr_api.g_varchar2) then
2231: If (p_rec.to_grade_id = hr_api.g_number) then
2232: p_rec.to_grade_id :=
2233: ghr_par_shd.g_old_rec.to_grade_id;
2234: End If;
2235: If (p_rec.to_grade_or_level = hr_api.g_varchar2) then
2236: p_rec.to_grade_or_level :=
2237: ghr_par_shd.g_old_rec.to_grade_or_level;
2238: End If;
2239: If (p_rec.to_job_id = hr_api.g_number) then
2235: If (p_rec.to_grade_or_level = hr_api.g_varchar2) then
2236: p_rec.to_grade_or_level :=
2237: ghr_par_shd.g_old_rec.to_grade_or_level;
2238: End If;
2239: If (p_rec.to_job_id = hr_api.g_number) then
2240: p_rec.to_job_id :=
2241: ghr_par_shd.g_old_rec.to_job_id;
2242: End If;
2243: If (p_rec.to_locality_adj = hr_api.g_number) then
2239: If (p_rec.to_job_id = hr_api.g_number) then
2240: p_rec.to_job_id :=
2241: ghr_par_shd.g_old_rec.to_job_id;
2242: End If;
2243: If (p_rec.to_locality_adj = hr_api.g_number) then
2244: p_rec.to_locality_adj :=
2245: ghr_par_shd.g_old_rec.to_locality_adj;
2246: End If;
2247: If (p_rec.to_occ_code = hr_api.g_varchar2) then
2243: If (p_rec.to_locality_adj = hr_api.g_number) then
2244: p_rec.to_locality_adj :=
2245: ghr_par_shd.g_old_rec.to_locality_adj;
2246: End If;
2247: If (p_rec.to_occ_code = hr_api.g_varchar2) then
2248: p_rec.to_occ_code :=
2249: ghr_par_shd.g_old_rec.to_occ_code;
2250: End If;
2251: If (p_rec.to_office_symbol = hr_api.g_varchar2) then
2247: If (p_rec.to_occ_code = hr_api.g_varchar2) then
2248: p_rec.to_occ_code :=
2249: ghr_par_shd.g_old_rec.to_occ_code;
2250: End If;
2251: If (p_rec.to_office_symbol = hr_api.g_varchar2) then
2252: p_rec.to_office_symbol :=
2253: ghr_par_shd.g_old_rec.to_office_symbol;
2254: End If;
2255: If (p_rec.to_organization_id = hr_api.g_number) then
2251: If (p_rec.to_office_symbol = hr_api.g_varchar2) then
2252: p_rec.to_office_symbol :=
2253: ghr_par_shd.g_old_rec.to_office_symbol;
2254: End If;
2255: If (p_rec.to_organization_id = hr_api.g_number) then
2256: p_rec.to_organization_id :=
2257: ghr_par_shd.g_old_rec.to_organization_id;
2258: End If;
2259: If (p_rec.to_other_pay_amount = hr_api.g_number) then
2255: If (p_rec.to_organization_id = hr_api.g_number) then
2256: p_rec.to_organization_id :=
2257: ghr_par_shd.g_old_rec.to_organization_id;
2258: End If;
2259: If (p_rec.to_other_pay_amount = hr_api.g_number) then
2260: p_rec.to_other_pay_amount :=
2261: ghr_par_shd.g_old_rec.to_other_pay_amount;
2262: End If;
2263: If (p_rec.to_pay_basis = hr_api.g_varchar2) then
2259: If (p_rec.to_other_pay_amount = hr_api.g_number) then
2260: p_rec.to_other_pay_amount :=
2261: ghr_par_shd.g_old_rec.to_other_pay_amount;
2262: End If;
2263: If (p_rec.to_pay_basis = hr_api.g_varchar2) then
2264: p_rec.to_pay_basis :=
2265: ghr_par_shd.g_old_rec.to_pay_basis;
2266: End If;
2267: If (p_rec.to_pay_plan = hr_api.g_varchar2) then
2263: If (p_rec.to_pay_basis = hr_api.g_varchar2) then
2264: p_rec.to_pay_basis :=
2265: ghr_par_shd.g_old_rec.to_pay_basis;
2266: End If;
2267: If (p_rec.to_pay_plan = hr_api.g_varchar2) then
2268: p_rec.to_pay_plan :=
2269: ghr_par_shd.g_old_rec.to_pay_plan;
2270: End If;
2271: -- FWFA Changes Bug#4444609
2268: p_rec.to_pay_plan :=
2269: ghr_par_shd.g_old_rec.to_pay_plan;
2270: End If;
2271: -- FWFA Changes Bug#4444609
2272: If (p_rec.to_pay_table_identifier = hr_api.g_number) then
2273: p_rec.to_pay_table_identifier :=
2274: ghr_par_shd.g_old_rec.to_pay_table_identifier;
2275: End If;
2276: -- FWFA Changes
2273: p_rec.to_pay_table_identifier :=
2274: ghr_par_shd.g_old_rec.to_pay_table_identifier;
2275: End If;
2276: -- FWFA Changes
2277: If (p_rec.to_position_id = hr_api.g_number) then
2278: p_rec.to_position_id :=
2279: ghr_par_shd.g_old_rec.to_position_id;
2280: End If;
2281: If (p_rec.to_position_org_line1 = hr_api.g_varchar2) then
2277: If (p_rec.to_position_id = hr_api.g_number) then
2278: p_rec.to_position_id :=
2279: ghr_par_shd.g_old_rec.to_position_id;
2280: End If;
2281: If (p_rec.to_position_org_line1 = hr_api.g_varchar2) then
2282: p_rec.to_position_org_line1 :=
2283: ghr_par_shd.g_old_rec.to_position_org_line1;
2284: End If;
2285: If (p_rec.to_position_org_line2 = hr_api.g_varchar2) then
2281: If (p_rec.to_position_org_line1 = hr_api.g_varchar2) then
2282: p_rec.to_position_org_line1 :=
2283: ghr_par_shd.g_old_rec.to_position_org_line1;
2284: End If;
2285: If (p_rec.to_position_org_line2 = hr_api.g_varchar2) then
2286: p_rec.to_position_org_line2 :=
2287: ghr_par_shd.g_old_rec.to_position_org_line2;
2288: End If;
2289: If (p_rec.to_position_org_line3 = hr_api.g_varchar2) then
2285: If (p_rec.to_position_org_line2 = hr_api.g_varchar2) then
2286: p_rec.to_position_org_line2 :=
2287: ghr_par_shd.g_old_rec.to_position_org_line2;
2288: End If;
2289: If (p_rec.to_position_org_line3 = hr_api.g_varchar2) then
2290: p_rec.to_position_org_line3 :=
2291: ghr_par_shd.g_old_rec.to_position_org_line3;
2292: End If;
2293: If (p_rec.to_position_org_line4 = hr_api.g_varchar2) then
2289: If (p_rec.to_position_org_line3 = hr_api.g_varchar2) then
2290: p_rec.to_position_org_line3 :=
2291: ghr_par_shd.g_old_rec.to_position_org_line3;
2292: End If;
2293: If (p_rec.to_position_org_line4 = hr_api.g_varchar2) then
2294: p_rec.to_position_org_line4 :=
2295: ghr_par_shd.g_old_rec.to_position_org_line4;
2296: End If;
2297: If (p_rec.to_position_org_line5 = hr_api.g_varchar2) then
2293: If (p_rec.to_position_org_line4 = hr_api.g_varchar2) then
2294: p_rec.to_position_org_line4 :=
2295: ghr_par_shd.g_old_rec.to_position_org_line4;
2296: End If;
2297: If (p_rec.to_position_org_line5 = hr_api.g_varchar2) then
2298: p_rec.to_position_org_line5 :=
2299: ghr_par_shd.g_old_rec.to_position_org_line5;
2300: End If;
2301: If (p_rec.to_position_org_line6 = hr_api.g_varchar2) then
2297: If (p_rec.to_position_org_line5 = hr_api.g_varchar2) then
2298: p_rec.to_position_org_line5 :=
2299: ghr_par_shd.g_old_rec.to_position_org_line5;
2300: End If;
2301: If (p_rec.to_position_org_line6 = hr_api.g_varchar2) then
2302: p_rec.to_position_org_line6 :=
2303: ghr_par_shd.g_old_rec.to_position_org_line6;
2304: End If;
2305:
2302: p_rec.to_position_org_line6 :=
2303: ghr_par_shd.g_old_rec.to_position_org_line6;
2304: End If;
2305:
2306: If (p_rec.to_position_number = hr_api.g_varchar2) then
2307: p_rec.to_position_number :=
2308: ghr_par_shd.g_old_rec.to_position_number;
2309: End If;
2310: If (p_rec.to_position_seq_no = hr_api.g_number) then
2306: If (p_rec.to_position_number = hr_api.g_varchar2) then
2307: p_rec.to_position_number :=
2308: ghr_par_shd.g_old_rec.to_position_number;
2309: End If;
2310: If (p_rec.to_position_seq_no = hr_api.g_number) then
2311: p_rec.to_position_seq_no :=
2312: ghr_par_shd.g_old_rec.to_position_seq_no;
2313: End If;
2314: If (p_rec.to_position_title = hr_api.g_varchar2) then
2310: If (p_rec.to_position_seq_no = hr_api.g_number) then
2311: p_rec.to_position_seq_no :=
2312: ghr_par_shd.g_old_rec.to_position_seq_no;
2313: End If;
2314: If (p_rec.to_position_title = hr_api.g_varchar2) then
2315: p_rec.to_position_title :=
2316: ghr_par_shd.g_old_rec.to_position_title;
2317: End If;
2318: If (p_rec.to_step_or_rate = hr_api.g_varchar2) then
2314: If (p_rec.to_position_title = hr_api.g_varchar2) then
2315: p_rec.to_position_title :=
2316: ghr_par_shd.g_old_rec.to_position_title;
2317: End If;
2318: If (p_rec.to_step_or_rate = hr_api.g_varchar2) then
2319: p_rec.to_step_or_rate :=
2320: ghr_par_shd.g_old_rec.to_step_or_rate;
2321: End If;
2322:
2319: p_rec.to_step_or_rate :=
2320: ghr_par_shd.g_old_rec.to_step_or_rate;
2321: End If;
2322:
2323: If (p_rec.to_ap_premium_pay_indicator = hr_api.g_varchar2) then
2324: p_rec.to_ap_premium_pay_indicator :=
2325: ghr_par_shd.g_old_rec.to_ap_premium_pay_indicator;
2326: End If;
2327:
2324: p_rec.to_ap_premium_pay_indicator :=
2325: ghr_par_shd.g_old_rec.to_ap_premium_pay_indicator;
2326: End If;
2327:
2328: If (p_rec.to_auo_premium_pay_indicator = hr_api.g_varchar2) then
2329: p_rec.to_auo_premium_pay_indicator :=
2330: ghr_par_shd.g_old_rec.to_auo_premium_pay_indicator;
2331: End If;
2332:
2329: p_rec.to_auo_premium_pay_indicator :=
2330: ghr_par_shd.g_old_rec.to_auo_premium_pay_indicator;
2331: End If;
2332:
2333: If (p_rec.to_au_overtime = hr_api.g_number) then
2334: p_rec.to_au_overtime :=
2335: ghr_par_shd.g_old_rec.to_au_overtime ;
2336: End If;
2337:
2334: p_rec.to_au_overtime :=
2335: ghr_par_shd.g_old_rec.to_au_overtime ;
2336: End If;
2337:
2338: If (p_rec.to_availability_pay = hr_api.g_number) then
2339: p_rec.to_availability_pay :=
2340: ghr_par_shd.g_old_rec.to_availability_pay ;
2341: End If;
2342:
2339: p_rec.to_availability_pay :=
2340: ghr_par_shd.g_old_rec.to_availability_pay ;
2341: End If;
2342:
2343: If (p_rec.to_retention_allowance = hr_api.g_number) then
2344: p_rec.to_retention_allowance :=
2345: ghr_par_shd.g_old_rec.to_retention_allowance;
2346: End If;
2347:
2344: p_rec.to_retention_allowance :=
2345: ghr_par_shd.g_old_rec.to_retention_allowance;
2346: End If;
2347:
2348: If (p_rec.to_staffing_differential = hr_api.g_number) then
2349: p_rec.to_staffing_differential :=
2350: ghr_par_shd.g_old_rec.to_staffing_differential ;
2351: End If;
2352:
2349: p_rec.to_staffing_differential :=
2350: ghr_par_shd.g_old_rec.to_staffing_differential ;
2351: End If;
2352:
2353: If (p_rec.to_supervisory_differential = hr_api.g_number) then
2354: p_rec.to_supervisory_differential :=
2355: ghr_par_shd.g_old_rec.to_supervisory_differential ;
2356: End If;
2357:
2354: p_rec.to_supervisory_differential :=
2355: ghr_par_shd.g_old_rec.to_supervisory_differential ;
2356: End If;
2357:
2358: If (p_rec.to_total_salary = hr_api.g_number) then
2359: p_rec.to_total_salary :=
2360: ghr_par_shd.g_old_rec.to_total_salary;
2361: End If;
2362: If (p_rec.veterans_preference = hr_api.g_varchar2) then
2358: If (p_rec.to_total_salary = hr_api.g_number) then
2359: p_rec.to_total_salary :=
2360: ghr_par_shd.g_old_rec.to_total_salary;
2361: End If;
2362: If (p_rec.veterans_preference = hr_api.g_varchar2) then
2363: p_rec.veterans_preference :=
2364: ghr_par_shd.g_old_rec.veterans_preference;
2365: End If;
2366: If (p_rec.veterans_pref_for_rif = hr_api.g_varchar2) then
2362: If (p_rec.veterans_preference = hr_api.g_varchar2) then
2363: p_rec.veterans_preference :=
2364: ghr_par_shd.g_old_rec.veterans_preference;
2365: End If;
2366: If (p_rec.veterans_pref_for_rif = hr_api.g_varchar2) then
2367: p_rec.veterans_pref_for_rif :=
2368: ghr_par_shd.g_old_rec.veterans_pref_for_rif;
2369: End If;
2370: If (p_rec.veterans_status = hr_api.g_varchar2) then
2366: If (p_rec.veterans_pref_for_rif = hr_api.g_varchar2) then
2367: p_rec.veterans_pref_for_rif :=
2368: ghr_par_shd.g_old_rec.veterans_pref_for_rif;
2369: End If;
2370: If (p_rec.veterans_status = hr_api.g_varchar2) then
2371: p_rec.veterans_status :=
2372: ghr_par_shd.g_old_rec.veterans_status;
2373: End If;
2374: If (p_rec.work_schedule = hr_api.g_varchar2) then
2370: If (p_rec.veterans_status = hr_api.g_varchar2) then
2371: p_rec.veterans_status :=
2372: ghr_par_shd.g_old_rec.veterans_status;
2373: End If;
2374: If (p_rec.work_schedule = hr_api.g_varchar2) then
2375: p_rec.work_schedule :=
2376: ghr_par_shd.g_old_rec.work_schedule;
2377: End If;
2378: If (p_rec.work_schedule_desc = hr_api.g_varchar2) then
2374: If (p_rec.work_schedule = hr_api.g_varchar2) then
2375: p_rec.work_schedule :=
2376: ghr_par_shd.g_old_rec.work_schedule;
2377: End If;
2378: If (p_rec.work_schedule_desc = hr_api.g_varchar2) then
2379: p_rec.work_schedule_desc :=
2380: ghr_par_shd.g_old_rec.work_schedule_desc;
2381: End If;
2382: If (p_rec.year_degree_attained = hr_api.g_number) then
2378: If (p_rec.work_schedule_desc = hr_api.g_varchar2) then
2379: p_rec.work_schedule_desc :=
2380: ghr_par_shd.g_old_rec.work_schedule_desc;
2381: End If;
2382: If (p_rec.year_degree_attained = hr_api.g_number) then
2383: p_rec.year_degree_attained :=
2384: ghr_par_shd.g_old_rec.year_degree_attained;
2385: End If;
2386: If (p_rec.first_noa_information1 = hr_api.g_varchar2) then
2382: If (p_rec.year_degree_attained = hr_api.g_number) then
2383: p_rec.year_degree_attained :=
2384: ghr_par_shd.g_old_rec.year_degree_attained;
2385: End If;
2386: If (p_rec.first_noa_information1 = hr_api.g_varchar2) then
2387: p_rec.first_noa_information1 :=
2388: ghr_par_shd.g_old_rec.first_noa_information1;
2389: End If;
2390: If (p_rec.first_noa_information2 = hr_api.g_varchar2) then
2386: If (p_rec.first_noa_information1 = hr_api.g_varchar2) then
2387: p_rec.first_noa_information1 :=
2388: ghr_par_shd.g_old_rec.first_noa_information1;
2389: End If;
2390: If (p_rec.first_noa_information2 = hr_api.g_varchar2) then
2391: p_rec.first_noa_information2 :=
2392: ghr_par_shd.g_old_rec.first_noa_information2;
2393: End If;
2394: If (p_rec.first_noa_information3 = hr_api.g_varchar2) then
2390: If (p_rec.first_noa_information2 = hr_api.g_varchar2) then
2391: p_rec.first_noa_information2 :=
2392: ghr_par_shd.g_old_rec.first_noa_information2;
2393: End If;
2394: If (p_rec.first_noa_information3 = hr_api.g_varchar2) then
2395: p_rec.first_noa_information3 :=
2396: ghr_par_shd.g_old_rec.first_noa_information3;
2397: End If;
2398: If (p_rec.first_noa_information4 = hr_api.g_varchar2) then
2394: If (p_rec.first_noa_information3 = hr_api.g_varchar2) then
2395: p_rec.first_noa_information3 :=
2396: ghr_par_shd.g_old_rec.first_noa_information3;
2397: End If;
2398: If (p_rec.first_noa_information4 = hr_api.g_varchar2) then
2399: p_rec.first_noa_information4 :=
2400: ghr_par_shd.g_old_rec.first_noa_information4;
2401: End If;
2402: If (p_rec.first_noa_information5 = hr_api.g_varchar2) then
2398: If (p_rec.first_noa_information4 = hr_api.g_varchar2) then
2399: p_rec.first_noa_information4 :=
2400: ghr_par_shd.g_old_rec.first_noa_information4;
2401: End If;
2402: If (p_rec.first_noa_information5 = hr_api.g_varchar2) then
2403: p_rec.first_noa_information5 :=
2404: ghr_par_shd.g_old_rec.first_noa_information5;
2405: End If;
2406: If (p_rec.second_lac1_information1 = hr_api.g_varchar2) then
2402: If (p_rec.first_noa_information5 = hr_api.g_varchar2) then
2403: p_rec.first_noa_information5 :=
2404: ghr_par_shd.g_old_rec.first_noa_information5;
2405: End If;
2406: If (p_rec.second_lac1_information1 = hr_api.g_varchar2) then
2407: p_rec.second_lac1_information1 :=
2408: ghr_par_shd.g_old_rec.second_lac1_information1;
2409: End If;
2410: If (p_rec.second_lac1_information2 = hr_api.g_varchar2) then
2406: If (p_rec.second_lac1_information1 = hr_api.g_varchar2) then
2407: p_rec.second_lac1_information1 :=
2408: ghr_par_shd.g_old_rec.second_lac1_information1;
2409: End If;
2410: If (p_rec.second_lac1_information2 = hr_api.g_varchar2) then
2411: p_rec.second_lac1_information2 :=
2412: ghr_par_shd.g_old_rec.second_lac1_information2;
2413: End If;
2414: If (p_rec.second_lac1_information3 = hr_api.g_varchar2) then
2410: If (p_rec.second_lac1_information2 = hr_api.g_varchar2) then
2411: p_rec.second_lac1_information2 :=
2412: ghr_par_shd.g_old_rec.second_lac1_information2;
2413: End If;
2414: If (p_rec.second_lac1_information3 = hr_api.g_varchar2) then
2415: p_rec.second_lac1_information3 :=
2416: ghr_par_shd.g_old_rec.second_lac1_information3;
2417: End If;
2418: If (p_rec.second_lac1_information4 = hr_api.g_varchar2) then
2414: If (p_rec.second_lac1_information3 = hr_api.g_varchar2) then
2415: p_rec.second_lac1_information3 :=
2416: ghr_par_shd.g_old_rec.second_lac1_information3;
2417: End If;
2418: If (p_rec.second_lac1_information4 = hr_api.g_varchar2) then
2419: p_rec.second_lac1_information4 :=
2420: ghr_par_shd.g_old_rec.second_lac1_information4;
2421: End If;
2422: If (p_rec.second_lac1_information5 = hr_api.g_varchar2) then
2418: If (p_rec.second_lac1_information4 = hr_api.g_varchar2) then
2419: p_rec.second_lac1_information4 :=
2420: ghr_par_shd.g_old_rec.second_lac1_information4;
2421: End If;
2422: If (p_rec.second_lac1_information5 = hr_api.g_varchar2) then
2423: p_rec.second_lac1_information5 :=
2424: ghr_par_shd.g_old_rec.second_lac1_information5;
2425: End If;
2426: If (p_rec.second_lac2_information1 = hr_api.g_varchar2) then
2422: If (p_rec.second_lac1_information5 = hr_api.g_varchar2) then
2423: p_rec.second_lac1_information5 :=
2424: ghr_par_shd.g_old_rec.second_lac1_information5;
2425: End If;
2426: If (p_rec.second_lac2_information1 = hr_api.g_varchar2) then
2427: p_rec.second_lac2_information1 :=
2428: ghr_par_shd.g_old_rec.second_lac2_information1;
2429: End If;
2430: If (p_rec.second_lac2_information2 = hr_api.g_varchar2) then
2426: If (p_rec.second_lac2_information1 = hr_api.g_varchar2) then
2427: p_rec.second_lac2_information1 :=
2428: ghr_par_shd.g_old_rec.second_lac2_information1;
2429: End If;
2430: If (p_rec.second_lac2_information2 = hr_api.g_varchar2) then
2431: p_rec.second_lac2_information2 :=
2432: ghr_par_shd.g_old_rec.second_lac2_information2;
2433: End If;
2434: If (p_rec.second_lac2_information3 = hr_api.g_varchar2) then
2430: If (p_rec.second_lac2_information2 = hr_api.g_varchar2) then
2431: p_rec.second_lac2_information2 :=
2432: ghr_par_shd.g_old_rec.second_lac2_information2;
2433: End If;
2434: If (p_rec.second_lac2_information3 = hr_api.g_varchar2) then
2435: p_rec.second_lac2_information3 :=
2436: ghr_par_shd.g_old_rec.second_lac2_information3;
2437: End If;
2438: If (p_rec.second_lac2_information4 = hr_api.g_varchar2) then
2434: If (p_rec.second_lac2_information3 = hr_api.g_varchar2) then
2435: p_rec.second_lac2_information3 :=
2436: ghr_par_shd.g_old_rec.second_lac2_information3;
2437: End If;
2438: If (p_rec.second_lac2_information4 = hr_api.g_varchar2) then
2439: p_rec.second_lac2_information4 :=
2440: ghr_par_shd.g_old_rec.second_lac2_information4;
2441: End If;
2442: If (p_rec.second_lac2_information5 = hr_api.g_varchar2) then
2438: If (p_rec.second_lac2_information4 = hr_api.g_varchar2) then
2439: p_rec.second_lac2_information4 :=
2440: ghr_par_shd.g_old_rec.second_lac2_information4;
2441: End If;
2442: If (p_rec.second_lac2_information5 = hr_api.g_varchar2) then
2443: p_rec.second_lac2_information5 :=
2444: ghr_par_shd.g_old_rec.second_lac2_information5;
2445: End If;
2446: If (p_rec.second_noa_information1 = hr_api.g_varchar2) then
2442: If (p_rec.second_lac2_information5 = hr_api.g_varchar2) then
2443: p_rec.second_lac2_information5 :=
2444: ghr_par_shd.g_old_rec.second_lac2_information5;
2445: End If;
2446: If (p_rec.second_noa_information1 = hr_api.g_varchar2) then
2447: p_rec.second_noa_information1 :=
2448: ghr_par_shd.g_old_rec.second_noa_information1;
2449: End If;
2450: If (p_rec.second_noa_information2 = hr_api.g_varchar2) then
2446: If (p_rec.second_noa_information1 = hr_api.g_varchar2) then
2447: p_rec.second_noa_information1 :=
2448: ghr_par_shd.g_old_rec.second_noa_information1;
2449: End If;
2450: If (p_rec.second_noa_information2 = hr_api.g_varchar2) then
2451: p_rec.second_noa_information2 :=
2452: ghr_par_shd.g_old_rec.second_noa_information2;
2453: End If;
2454: If (p_rec.second_noa_information3 = hr_api.g_varchar2) then
2450: If (p_rec.second_noa_information2 = hr_api.g_varchar2) then
2451: p_rec.second_noa_information2 :=
2452: ghr_par_shd.g_old_rec.second_noa_information2;
2453: End If;
2454: If (p_rec.second_noa_information3 = hr_api.g_varchar2) then
2455: p_rec.second_noa_information3 :=
2456: ghr_par_shd.g_old_rec.second_noa_information3;
2457: End If;
2458: If (p_rec.second_noa_information4 = hr_api.g_varchar2) then
2454: If (p_rec.second_noa_information3 = hr_api.g_varchar2) then
2455: p_rec.second_noa_information3 :=
2456: ghr_par_shd.g_old_rec.second_noa_information3;
2457: End If;
2458: If (p_rec.second_noa_information4 = hr_api.g_varchar2) then
2459: p_rec.second_noa_information4 :=
2460: ghr_par_shd.g_old_rec.second_noa_information4;
2461: End If;
2462: If (p_rec.second_noa_information5 = hr_api.g_varchar2) then
2458: If (p_rec.second_noa_information4 = hr_api.g_varchar2) then
2459: p_rec.second_noa_information4 :=
2460: ghr_par_shd.g_old_rec.second_noa_information4;
2461: End If;
2462: If (p_rec.second_noa_information5 = hr_api.g_varchar2) then
2463: p_rec.second_noa_information5 :=
2464: ghr_par_shd.g_old_rec.second_noa_information5;
2465: End If;
2466: If (p_rec.first_lac1_information1 = hr_api.g_varchar2) then
2462: If (p_rec.second_noa_information5 = hr_api.g_varchar2) then
2463: p_rec.second_noa_information5 :=
2464: ghr_par_shd.g_old_rec.second_noa_information5;
2465: End If;
2466: If (p_rec.first_lac1_information1 = hr_api.g_varchar2) then
2467: p_rec.first_lac1_information1 :=
2468: ghr_par_shd.g_old_rec.first_lac1_information1;
2469: End If;
2470: If (p_rec.first_lac1_information2 = hr_api.g_varchar2) then
2466: If (p_rec.first_lac1_information1 = hr_api.g_varchar2) then
2467: p_rec.first_lac1_information1 :=
2468: ghr_par_shd.g_old_rec.first_lac1_information1;
2469: End If;
2470: If (p_rec.first_lac1_information2 = hr_api.g_varchar2) then
2471: p_rec.first_lac1_information2 :=
2472: ghr_par_shd.g_old_rec.first_lac1_information2;
2473: End If;
2474: If (p_rec.first_lac1_information3 = hr_api.g_varchar2) then
2470: If (p_rec.first_lac1_information2 = hr_api.g_varchar2) then
2471: p_rec.first_lac1_information2 :=
2472: ghr_par_shd.g_old_rec.first_lac1_information2;
2473: End If;
2474: If (p_rec.first_lac1_information3 = hr_api.g_varchar2) then
2475: p_rec.first_lac1_information3 :=
2476: ghr_par_shd.g_old_rec.first_lac1_information3;
2477: End If;
2478: If (p_rec.first_lac1_information4 = hr_api.g_varchar2) then
2474: If (p_rec.first_lac1_information3 = hr_api.g_varchar2) then
2475: p_rec.first_lac1_information3 :=
2476: ghr_par_shd.g_old_rec.first_lac1_information3;
2477: End If;
2478: If (p_rec.first_lac1_information4 = hr_api.g_varchar2) then
2479: p_rec.first_lac1_information4 :=
2480: ghr_par_shd.g_old_rec.first_lac1_information4;
2481: End If;
2482: If (p_rec.first_lac1_information5 = hr_api.g_varchar2) then
2478: If (p_rec.first_lac1_information4 = hr_api.g_varchar2) then
2479: p_rec.first_lac1_information4 :=
2480: ghr_par_shd.g_old_rec.first_lac1_information4;
2481: End If;
2482: If (p_rec.first_lac1_information5 = hr_api.g_varchar2) then
2483: p_rec.first_lac1_information5 :=
2484: ghr_par_shd.g_old_rec.first_lac1_information5;
2485: End If;
2486: If (p_rec.first_lac2_information1 = hr_api.g_varchar2) then
2482: If (p_rec.first_lac1_information5 = hr_api.g_varchar2) then
2483: p_rec.first_lac1_information5 :=
2484: ghr_par_shd.g_old_rec.first_lac1_information5;
2485: End If;
2486: If (p_rec.first_lac2_information1 = hr_api.g_varchar2) then
2487: p_rec.first_lac2_information1 :=
2488: ghr_par_shd.g_old_rec.first_lac2_information1;
2489: End If;
2490: If (p_rec.first_lac2_information2 = hr_api.g_varchar2) then
2486: If (p_rec.first_lac2_information1 = hr_api.g_varchar2) then
2487: p_rec.first_lac2_information1 :=
2488: ghr_par_shd.g_old_rec.first_lac2_information1;
2489: End If;
2490: If (p_rec.first_lac2_information2 = hr_api.g_varchar2) then
2491: p_rec.first_lac2_information2 :=
2492: ghr_par_shd.g_old_rec.first_lac2_information2;
2493: End If;
2494: If (p_rec.first_lac2_information3 = hr_api.g_varchar2) then
2490: If (p_rec.first_lac2_information2 = hr_api.g_varchar2) then
2491: p_rec.first_lac2_information2 :=
2492: ghr_par_shd.g_old_rec.first_lac2_information2;
2493: End If;
2494: If (p_rec.first_lac2_information3 = hr_api.g_varchar2) then
2495: p_rec.first_lac2_information3 :=
2496: ghr_par_shd.g_old_rec.first_lac2_information3;
2497: End If;
2498: If (p_rec.first_lac2_information4 = hr_api.g_varchar2) then
2494: If (p_rec.first_lac2_information3 = hr_api.g_varchar2) then
2495: p_rec.first_lac2_information3 :=
2496: ghr_par_shd.g_old_rec.first_lac2_information3;
2497: End If;
2498: If (p_rec.first_lac2_information4 = hr_api.g_varchar2) then
2499: p_rec.first_lac2_information4 :=
2500: ghr_par_shd.g_old_rec.first_lac2_information4;
2501: End If;
2502: If (p_rec.first_lac2_information5 = hr_api.g_varchar2) then
2498: If (p_rec.first_lac2_information4 = hr_api.g_varchar2) then
2499: p_rec.first_lac2_information4 :=
2500: ghr_par_shd.g_old_rec.first_lac2_information4;
2501: End If;
2502: If (p_rec.first_lac2_information5 = hr_api.g_varchar2) then
2503: p_rec.first_lac2_information5 :=
2504: ghr_par_shd.g_old_rec.first_lac2_information5;
2505: End If;
2506: If (p_rec.attribute_category = hr_api.g_varchar2) then
2502: If (p_rec.first_lac2_information5 = hr_api.g_varchar2) then
2503: p_rec.first_lac2_information5 :=
2504: ghr_par_shd.g_old_rec.first_lac2_information5;
2505: End If;
2506: If (p_rec.attribute_category = hr_api.g_varchar2) then
2507: p_rec.attribute_category :=
2508: ghr_par_shd.g_old_rec.attribute_category;
2509: End If;
2510: If (p_rec.attribute1 = hr_api.g_varchar2) then
2506: If (p_rec.attribute_category = hr_api.g_varchar2) then
2507: p_rec.attribute_category :=
2508: ghr_par_shd.g_old_rec.attribute_category;
2509: End If;
2510: If (p_rec.attribute1 = hr_api.g_varchar2) then
2511: p_rec.attribute1 :=
2512: ghr_par_shd.g_old_rec.attribute1;
2513: End If;
2514: If (p_rec.attribute2 = hr_api.g_varchar2) then
2510: If (p_rec.attribute1 = hr_api.g_varchar2) then
2511: p_rec.attribute1 :=
2512: ghr_par_shd.g_old_rec.attribute1;
2513: End If;
2514: If (p_rec.attribute2 = hr_api.g_varchar2) then
2515: p_rec.attribute2 :=
2516: ghr_par_shd.g_old_rec.attribute2;
2517: End If;
2518: If (p_rec.attribute3 = hr_api.g_varchar2) then
2514: If (p_rec.attribute2 = hr_api.g_varchar2) then
2515: p_rec.attribute2 :=
2516: ghr_par_shd.g_old_rec.attribute2;
2517: End If;
2518: If (p_rec.attribute3 = hr_api.g_varchar2) then
2519: p_rec.attribute3 :=
2520: ghr_par_shd.g_old_rec.attribute3;
2521: End If;
2522: If (p_rec.attribute4 = hr_api.g_varchar2) then
2518: If (p_rec.attribute3 = hr_api.g_varchar2) then
2519: p_rec.attribute3 :=
2520: ghr_par_shd.g_old_rec.attribute3;
2521: End If;
2522: If (p_rec.attribute4 = hr_api.g_varchar2) then
2523: p_rec.attribute4 :=
2524: ghr_par_shd.g_old_rec.attribute4;
2525: End If;
2526: If (p_rec.attribute5 = hr_api.g_varchar2) then
2522: If (p_rec.attribute4 = hr_api.g_varchar2) then
2523: p_rec.attribute4 :=
2524: ghr_par_shd.g_old_rec.attribute4;
2525: End If;
2526: If (p_rec.attribute5 = hr_api.g_varchar2) then
2527: p_rec.attribute5 :=
2528: ghr_par_shd.g_old_rec.attribute5;
2529: End If;
2530: If (p_rec.attribute6 = hr_api.g_varchar2) then
2526: If (p_rec.attribute5 = hr_api.g_varchar2) then
2527: p_rec.attribute5 :=
2528: ghr_par_shd.g_old_rec.attribute5;
2529: End If;
2530: If (p_rec.attribute6 = hr_api.g_varchar2) then
2531: p_rec.attribute6 :=
2532: ghr_par_shd.g_old_rec.attribute6;
2533: End If;
2534: If (p_rec.attribute7 = hr_api.g_varchar2) then
2530: If (p_rec.attribute6 = hr_api.g_varchar2) then
2531: p_rec.attribute6 :=
2532: ghr_par_shd.g_old_rec.attribute6;
2533: End If;
2534: If (p_rec.attribute7 = hr_api.g_varchar2) then
2535: p_rec.attribute7 :=
2536: ghr_par_shd.g_old_rec.attribute7;
2537: End If;
2538: If (p_rec.attribute8 = hr_api.g_varchar2) then
2534: If (p_rec.attribute7 = hr_api.g_varchar2) then
2535: p_rec.attribute7 :=
2536: ghr_par_shd.g_old_rec.attribute7;
2537: End If;
2538: If (p_rec.attribute8 = hr_api.g_varchar2) then
2539: p_rec.attribute8 :=
2540: ghr_par_shd.g_old_rec.attribute8;
2541: End If;
2542: If (p_rec.attribute9 = hr_api.g_varchar2) then
2538: If (p_rec.attribute8 = hr_api.g_varchar2) then
2539: p_rec.attribute8 :=
2540: ghr_par_shd.g_old_rec.attribute8;
2541: End If;
2542: If (p_rec.attribute9 = hr_api.g_varchar2) then
2543: p_rec.attribute9 :=
2544: ghr_par_shd.g_old_rec.attribute9;
2545: End If;
2546: If (p_rec.attribute10 = hr_api.g_varchar2) then
2542: If (p_rec.attribute9 = hr_api.g_varchar2) then
2543: p_rec.attribute9 :=
2544: ghr_par_shd.g_old_rec.attribute9;
2545: End If;
2546: If (p_rec.attribute10 = hr_api.g_varchar2) then
2547: p_rec.attribute10 :=
2548: ghr_par_shd.g_old_rec.attribute10;
2549: End If;
2550: If (p_rec.attribute11 = hr_api.g_varchar2) then
2546: If (p_rec.attribute10 = hr_api.g_varchar2) then
2547: p_rec.attribute10 :=
2548: ghr_par_shd.g_old_rec.attribute10;
2549: End If;
2550: If (p_rec.attribute11 = hr_api.g_varchar2) then
2551: p_rec.attribute11 :=
2552: ghr_par_shd.g_old_rec.attribute11;
2553: End If;
2554: If (p_rec.attribute12 = hr_api.g_varchar2) then
2550: If (p_rec.attribute11 = hr_api.g_varchar2) then
2551: p_rec.attribute11 :=
2552: ghr_par_shd.g_old_rec.attribute11;
2553: End If;
2554: If (p_rec.attribute12 = hr_api.g_varchar2) then
2555: p_rec.attribute12 :=
2556: ghr_par_shd.g_old_rec.attribute12;
2557: End If;
2558: If (p_rec.attribute13 = hr_api.g_varchar2) then
2554: If (p_rec.attribute12 = hr_api.g_varchar2) then
2555: p_rec.attribute12 :=
2556: ghr_par_shd.g_old_rec.attribute12;
2557: End If;
2558: If (p_rec.attribute13 = hr_api.g_varchar2) then
2559: p_rec.attribute13 :=
2560: ghr_par_shd.g_old_rec.attribute13;
2561: End If;
2562: If (p_rec.attribute14 = hr_api.g_varchar2) then
2558: If (p_rec.attribute13 = hr_api.g_varchar2) then
2559: p_rec.attribute13 :=
2560: ghr_par_shd.g_old_rec.attribute13;
2561: End If;
2562: If (p_rec.attribute14 = hr_api.g_varchar2) then
2563: p_rec.attribute14 :=
2564: ghr_par_shd.g_old_rec.attribute14;
2565: End If;
2566: If (p_rec.attribute15 = hr_api.g_varchar2) then
2562: If (p_rec.attribute14 = hr_api.g_varchar2) then
2563: p_rec.attribute14 :=
2564: ghr_par_shd.g_old_rec.attribute14;
2565: End If;
2566: If (p_rec.attribute15 = hr_api.g_varchar2) then
2567: p_rec.attribute15 :=
2568: ghr_par_shd.g_old_rec.attribute15;
2569: End If;
2570: If (p_rec.attribute16 = hr_api.g_varchar2) then
2566: If (p_rec.attribute15 = hr_api.g_varchar2) then
2567: p_rec.attribute15 :=
2568: ghr_par_shd.g_old_rec.attribute15;
2569: End If;
2570: If (p_rec.attribute16 = hr_api.g_varchar2) then
2571: p_rec.attribute16 :=
2572: ghr_par_shd.g_old_rec.attribute16;
2573: End If;
2574: If (p_rec.attribute17 = hr_api.g_varchar2) then
2570: If (p_rec.attribute16 = hr_api.g_varchar2) then
2571: p_rec.attribute16 :=
2572: ghr_par_shd.g_old_rec.attribute16;
2573: End If;
2574: If (p_rec.attribute17 = hr_api.g_varchar2) then
2575: p_rec.attribute17 :=
2576: ghr_par_shd.g_old_rec.attribute17;
2577: End If;
2578: If (p_rec.attribute18 = hr_api.g_varchar2) then
2574: If (p_rec.attribute17 = hr_api.g_varchar2) then
2575: p_rec.attribute17 :=
2576: ghr_par_shd.g_old_rec.attribute17;
2577: End If;
2578: If (p_rec.attribute18 = hr_api.g_varchar2) then
2579: p_rec.attribute18 :=
2580: ghr_par_shd.g_old_rec.attribute18;
2581: End If;
2582: If (p_rec.attribute19 = hr_api.g_varchar2) then
2578: If (p_rec.attribute18 = hr_api.g_varchar2) then
2579: p_rec.attribute18 :=
2580: ghr_par_shd.g_old_rec.attribute18;
2581: End If;
2582: If (p_rec.attribute19 = hr_api.g_varchar2) then
2583: p_rec.attribute19 :=
2584: ghr_par_shd.g_old_rec.attribute19;
2585: End If;
2586: If (p_rec.attribute20 = hr_api.g_varchar2) then
2582: If (p_rec.attribute19 = hr_api.g_varchar2) then
2583: p_rec.attribute19 :=
2584: ghr_par_shd.g_old_rec.attribute19;
2585: End If;
2586: If (p_rec.attribute20 = hr_api.g_varchar2) then
2587: p_rec.attribute20 :=
2588: ghr_par_shd.g_old_rec.attribute20;
2589: End If;
2590: If (p_rec.first_noa_canc_pa_request_id = hr_api.g_number) then
2586: If (p_rec.attribute20 = hr_api.g_varchar2) then
2587: p_rec.attribute20 :=
2588: ghr_par_shd.g_old_rec.attribute20;
2589: End If;
2590: If (p_rec.first_noa_canc_pa_request_id = hr_api.g_number) then
2591: p_rec.first_noa_canc_pa_request_id :=
2592: ghr_par_shd.g_old_rec.first_noa_canc_pa_request_id;
2593: End If;
2594: If (p_rec.second_noa_canc_pa_request_id = hr_api.g_number) then
2590: If (p_rec.first_noa_canc_pa_request_id = hr_api.g_number) then
2591: p_rec.first_noa_canc_pa_request_id :=
2592: ghr_par_shd.g_old_rec.first_noa_canc_pa_request_id;
2593: End If;
2594: If (p_rec.second_noa_canc_pa_request_id = hr_api.g_number) then
2595: p_rec.second_noa_canc_pa_request_id :=
2596: ghr_par_shd.g_old_rec.second_noa_canc_pa_request_id;
2597: End If;
2598: If (p_rec.to_retention_allow_percentage = hr_api.g_number) then
2594: If (p_rec.second_noa_canc_pa_request_id = hr_api.g_number) then
2595: p_rec.second_noa_canc_pa_request_id :=
2596: ghr_par_shd.g_old_rec.second_noa_canc_pa_request_id;
2597: End If;
2598: If (p_rec.to_retention_allow_percentage = hr_api.g_number) then
2599: p_rec.to_retention_allow_percentage :=
2600: ghr_par_shd.g_old_rec.to_retention_allow_percentage;
2601: End If;
2602: If (p_rec.to_supervisory_diff_percentage = hr_api.g_number) then
2598: If (p_rec.to_retention_allow_percentage = hr_api.g_number) then
2599: p_rec.to_retention_allow_percentage :=
2600: ghr_par_shd.g_old_rec.to_retention_allow_percentage;
2601: End If;
2602: If (p_rec.to_supervisory_diff_percentage = hr_api.g_number) then
2603: p_rec.to_supervisory_diff_percentage :=
2604: ghr_par_shd.g_old_rec.to_supervisory_diff_percentage;
2605: End If;
2606: If (p_rec.to_staffing_diff_percentage = hr_api.g_number) then
2602: If (p_rec.to_supervisory_diff_percentage = hr_api.g_number) then
2603: p_rec.to_supervisory_diff_percentage :=
2604: ghr_par_shd.g_old_rec.to_supervisory_diff_percentage;
2605: End If;
2606: If (p_rec.to_staffing_diff_percentage = hr_api.g_number) then
2607: p_rec.to_staffing_diff_percentage :=
2608: ghr_par_shd.g_old_rec.to_staffing_diff_percentage;
2609: End If;
2610: If (p_rec.award_percentage = hr_api.g_number) then
2606: If (p_rec.to_staffing_diff_percentage = hr_api.g_number) then
2607: p_rec.to_staffing_diff_percentage :=
2608: ghr_par_shd.g_old_rec.to_staffing_diff_percentage;
2609: End If;
2610: If (p_rec.award_percentage = hr_api.g_number) then
2611: p_rec.award_percentage :=
2612: ghr_par_shd.g_old_rec.award_percentage;
2613: End If;
2614: If (p_rec.rpa_type = hr_api.g_varchar2) then
2610: If (p_rec.award_percentage = hr_api.g_number) then
2611: p_rec.award_percentage :=
2612: ghr_par_shd.g_old_rec.award_percentage;
2613: End If;
2614: If (p_rec.rpa_type = hr_api.g_varchar2) then
2615: p_rec.rpa_type :=
2616: ghr_par_shd.g_old_rec.rpa_type;
2617: End If;
2618: If (p_rec.mass_action_id = hr_api.g_number) then
2614: If (p_rec.rpa_type = hr_api.g_varchar2) then
2615: p_rec.rpa_type :=
2616: ghr_par_shd.g_old_rec.rpa_type;
2617: End If;
2618: If (p_rec.mass_action_id = hr_api.g_number) then
2619: p_rec.mass_action_id :=
2620: ghr_par_shd.g_old_rec.mass_action_id;
2621: End If;
2622: If (p_rec.mass_action_eligible_flag = hr_api.g_varchar2) then
2618: If (p_rec.mass_action_id = hr_api.g_number) then
2619: p_rec.mass_action_id :=
2620: ghr_par_shd.g_old_rec.mass_action_id;
2621: End If;
2622: If (p_rec.mass_action_eligible_flag = hr_api.g_varchar2) then
2623: p_rec.mass_action_eligible_flag :=
2624: ghr_par_shd.g_old_rec.mass_action_eligible_flag;
2625: End If;
2626: If (p_rec.mass_action_select_flag = hr_api.g_varchar2) then
2622: If (p_rec.mass_action_eligible_flag = hr_api.g_varchar2) then
2623: p_rec.mass_action_eligible_flag :=
2624: ghr_par_shd.g_old_rec.mass_action_eligible_flag;
2625: End If;
2626: If (p_rec.mass_action_select_flag = hr_api.g_varchar2) then
2627: p_rec.mass_action_select_flag :=
2628: ghr_par_shd.g_old_rec.mass_action_select_flag;
2629: End If;
2630: If (p_rec.mass_action_comments = hr_api.g_varchar2) then
2626: If (p_rec.mass_action_select_flag = hr_api.g_varchar2) then
2627: p_rec.mass_action_select_flag :=
2628: ghr_par_shd.g_old_rec.mass_action_select_flag;
2629: End If;
2630: If (p_rec.mass_action_comments = hr_api.g_varchar2) then
2631: p_rec.mass_action_comments :=
2632: ghr_par_shd.g_old_rec.mass_action_comments;
2633: End If;
2634:
2632: ghr_par_shd.g_old_rec.mass_action_comments;
2633: End If;
2634:
2635: -- Bug#4486823 RRR Changes
2636: If (p_rec.pa_incentive_payment_option = hr_api.g_varchar2) then
2637: p_rec.pa_incentive_payment_option :=
2638: ghr_par_shd.g_old_rec.payment_option;
2639: End If;
2640: If (p_rec.award_salary = hr_api.g_number) then
2636: If (p_rec.pa_incentive_payment_option = hr_api.g_varchar2) then
2637: p_rec.pa_incentive_payment_option :=
2638: ghr_par_shd.g_old_rec.payment_option;
2639: End If;
2640: If (p_rec.award_salary = hr_api.g_number) then
2641: p_rec.award_salary :=
2642: ghr_par_shd.g_old_rec.award_salary;
2643: End If;
2644: -- Bug# RRR Changes