APPS.PER_PYP_BUS dependencies on HR_API

Line 74: hr_api.argument_changed_error

70: end if;
71: hr_utility.set_location(l_proc, 11);
72: exception
73: when l_error then
74: hr_api.argument_changed_error
75: (p_api_name => l_proc
76: ,p_argument => l_argument);
77: when others then
78: raise;

Line 664: hr_api.mandatory_arg_error

660: hr_utility.set_location('Entering:'|| l_proc, 1);
661: --
662: -- Check mandatory parameters have been set
663: --
664: hr_api.mandatory_arg_error
665: (p_api_name => l_proc
666: ,p_argument => 'assignment_id'
667: ,p_argument_value => p_assignment_id
668: );

Line 670: hr_api.mandatory_arg_error

666: ,p_argument => 'assignment_id'
667: ,p_argument_value => p_assignment_id
668: );
669: --
670: hr_api.mandatory_arg_error
671: (p_api_name => l_proc
672: ,p_argument => 'business_group_id'
673: ,p_argument_value => p_business_group_id
674: );

Line 676: hr_api.mandatory_arg_error

672: ,p_argument => 'business_group_id'
673: ,p_argument_value => p_business_group_id
674: );
675: --
676: hr_api.mandatory_arg_error
677: (p_api_name => l_proc
678: ,p_argument => 'change_date'
679: ,p_argument_value => p_change_date
680: );

Line 693: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.change_date,hr_api.g_date) <>

689: --
690: -- only proceed if we are inserting or if we are updaing and change date
691: -- has changed
692: --
693: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.change_date,hr_api.g_date) <>
694: nvl(p_change_date,hr_api.g_date) )or not l_api_updating) then
695: --
696: -- if we are updating but it was already approved then error.
697: --

Line 694: nvl(p_change_date,hr_api.g_date) )or not l_api_updating) then

690: -- only proceed if we are inserting or if we are updaing and change date
691: -- has changed
692: --
693: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.change_date,hr_api.g_date) <>
694: nvl(p_change_date,hr_api.g_date) )or not l_api_updating) then
695: --
696: -- if we are updating but it was already approved then error.
697: --
698: if ((l_api_updating and per_pyp_shd.g_old_rec.approved='Y') and

Line 1000: and nvl(assg.effective_end_date, hr_api.g_eot)

996: where assg.assignment_id = p_assignment_id
997: and assg.assignment_status_type_id = ast.assignment_status_type_id
998: and assg.business_group_id + 0 = p_business_group_id
999: and p_next_sal_review_date between assg.effective_start_date
1000: and nvl(assg.effective_end_date, hr_api.g_eot)
1001: and ast.per_system_status = 'TERM_ASSIGN';
1002: --
1003: begin
1004: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1009: hr_api.mandatory_arg_error

1005: p_inv_next_sal_date_warning := false;
1006: --
1007: -- Check mandatory parameters have being set.
1008: --
1009: hr_api.mandatory_arg_error
1010: (p_api_name => l_proc
1011: ,p_argument => 'change_date'
1012: ,p_argument_value => p_change_date
1013: );

Line 1015: hr_api.mandatory_arg_error

1011: ,p_argument => 'change_date'
1012: ,p_argument_value => p_change_date
1013: );
1014: --
1015: hr_api.mandatory_arg_error
1016: (p_api_name => l_proc
1017: ,p_argument => 'assignment_id'
1018: ,p_argument_value => p_assignment_id
1019: );

Line 1021: hr_api.mandatory_arg_error

1017: ,p_argument => 'assignment_id'
1018: ,p_argument_value => p_assignment_id
1019: );
1020: --
1021: hr_api.mandatory_arg_error
1022: (p_api_name => l_proc
1023: ,p_argument => 'business_group_id'
1024: ,p_argument_value => p_business_group_id
1025: );

Line 1035: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.next_sal_review_date,hr_api.g_date) <>

1031: l_api_updating := per_pyp_shd.api_updating
1032: (p_pay_proposal_id => p_pay_proposal_id
1033: ,p_object_version_number => p_object_version_number);
1034: --
1035: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.next_sal_review_date,hr_api.g_date) <>
1036: nvl(p_next_sal_review_date,hr_api.g_date) )or not l_api_updating) then
1037: --
1038: -- If the next_sal_review is not null do the following checks
1039: --

Line 1036: nvl(p_next_sal_review_date,hr_api.g_date) )or not l_api_updating) then

1032: (p_pay_proposal_id => p_pay_proposal_id
1033: ,p_object_version_number => p_object_version_number);
1034: --
1035: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.next_sal_review_date,hr_api.g_date) <>
1036: nvl(p_next_sal_review_date,hr_api.g_date) )or not l_api_updating) then
1037: --
1038: -- If the next_sal_review is not null do the following checks
1039: --
1040: if (p_next_sal_review_date IS NOT NULL) then

Line 1146: and nvl(effective_end_date, hr_api.g_eot);

1142: from per_all_assignments_f
1143: where assignment_id = p_assignment_id
1144: and business_group_id + 0 = p_business_group_id
1145: and p_change_date between effective_start_date
1146: and nvl(effective_end_date, hr_api.g_eot);
1147: --
1148: --
1149: -- Cursor to check the assignment status as next_sal_review_date.
1150: --

Line 1159: and nvl(assg.effective_end_date, hr_api.g_eot)

1155: where assg.assignment_id = p_assignment_id
1156: and assg.assignment_status_type_id = ast.assignment_status_type_id
1157: and assg.business_group_id + 0 = p_business_group_id
1158: and p_next_sal_review_date between assg.effective_start_date
1159: and nvl(assg.effective_end_date, hr_api.g_eot)
1160: and ast.per_system_status = 'TERM_ASSIGN';
1161: --
1162: begin
1163: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1168: hr_api.mandatory_arg_error

1164: p_inv_next_sal_date_warning := false;
1165: --
1166: -- Check mandatory parameters have being set.
1167: --
1168: hr_api.mandatory_arg_error
1169: (p_api_name => l_proc
1170: ,p_argument => 'change_date'
1171: ,p_argument_value => p_change_date
1172: );

Line 1174: hr_api.mandatory_arg_error

1170: ,p_argument => 'change_date'
1171: ,p_argument_value => p_change_date
1172: );
1173: --
1174: hr_api.mandatory_arg_error
1175: (p_api_name => l_proc
1176: ,p_argument => 'assignment_id'
1177: ,p_argument_value => p_assignment_id
1178: );

Line 1180: hr_api.mandatory_arg_error

1176: ,p_argument => 'assignment_id'
1177: ,p_argument_value => p_assignment_id
1178: );
1179: --
1180: hr_api.mandatory_arg_error
1181: (p_api_name => l_proc
1182: ,p_argument => 'business_group_id'
1183: ,p_argument_value => p_business_group_id
1184: );

Line 1195: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.next_sal_review_date,hr_api.g_date) <>

1191: l_api_updating := per_pyp_shd.api_updating
1192: (p_pay_proposal_id => p_pay_proposal_id
1193: ,p_object_version_number => p_object_version_number);
1194: --
1195: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.next_sal_review_date,hr_api.g_date) <>
1196: nvl(p_next_sal_review_date,hr_api.g_date)) OR not l_api_updating) then
1197: --
1198: if (p_next_sal_review_date IS NULL) then
1199: -- When the next_sal_review is null then we do the following:

Line 1196: nvl(p_next_sal_review_date,hr_api.g_date)) OR not l_api_updating) then

1192: (p_pay_proposal_id => p_pay_proposal_id
1193: ,p_object_version_number => p_object_version_number);
1194: --
1195: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.next_sal_review_date,hr_api.g_date) <>
1196: nvl(p_next_sal_review_date,hr_api.g_date)) OR not l_api_updating) then
1197: --
1198: if (p_next_sal_review_date IS NULL) then
1199: -- When the next_sal_review is null then we do the following:
1200: -- a) check the sal_review details at the assignment level

Line 1300: hr_api.mandatory_arg_error

1296: hr_utility.set_location('Entering:'|| l_proc, 1);
1297: --
1298: -- Check mandatory parameters have being set.
1299: --
1300: hr_api.mandatory_arg_error
1301: (p_api_name => l_proc
1302: ,p_argument => 'change_date'
1303: ,p_argument_value => p_change_date
1304: );

Line 1306: hr_api.mandatory_arg_error

1302: ,p_argument => 'change_date'
1303: ,p_argument_value => p_change_date
1304: );
1305: --
1306: hr_api.mandatory_arg_error
1307: (p_api_name => l_proc
1308: ,p_argument => 'assignment_id'
1309: ,p_argument_value => p_assignment_id
1310: );

Line 1312: hr_api.mandatory_arg_error

1308: ,p_argument => 'assignment_id'
1309: ,p_argument_value => p_assignment_id
1310: );
1311: --
1312: hr_api.mandatory_arg_error
1313: (p_api_name => l_proc
1314: ,p_argument => 'multiple_components'
1315: ,p_argument_value => p_multiple_components
1316: );

Line 1412: hr_api.mandatory_arg_error

1408: hr_utility.set_location('Entering:'|| l_proc, 1);
1409: --
1410: -- Check mandatory parameters have being set.
1411: --
1412: hr_api.mandatory_arg_error
1413: (p_api_name => l_proc
1414: ,p_argument => 'change_date'
1415: ,p_argument_value => p_change_date
1416: );

Line 1426: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.proposal_reason,hr_api.g_varchar2) <>

1422: l_api_updating := per_pyp_shd.api_updating
1423: (p_pay_proposal_id => p_pay_proposal_id
1424: ,p_object_version_number => p_object_version_number);
1425: --
1426: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.proposal_reason,hr_api.g_varchar2) <>
1427: nvl(p_proposal_reason,hr_api.g_varchar2))
1428: OR not l_api_updating ) then
1429: hr_utility.set_location(l_proc, 6);
1430: --

Line 1427: nvl(p_proposal_reason,hr_api.g_varchar2))

1423: (p_pay_proposal_id => p_pay_proposal_id
1424: ,p_object_version_number => p_object_version_number);
1425: --
1426: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.proposal_reason,hr_api.g_varchar2) <>
1427: nvl(p_proposal_reason,hr_api.g_varchar2))
1428: OR not l_api_updating ) then
1429: hr_utility.set_location(l_proc, 6);
1430: --
1431: -- check that the p_proposal_reason exists in hr_lookups.

Line 1434: if hr_api.not_exists_in_hr_lookups

1430: --
1431: -- check that the p_proposal_reason exists in hr_lookups.
1432: --
1433: if (p_proposal_reason IS NOT NULL ) then
1434: if hr_api.not_exists_in_hr_lookups
1435: (p_effective_date => p_change_date
1436: ,p_lookup_type => 'PROPOSAL_REASON'
1437: ,p_lookup_code => p_proposal_reason
1438: ) then

Line 1956: hr_api.mandatory_arg_error

1952: hr_utility.set_location('Entering:'|| l_proc, 1);
1953: --
1954: -- Check mandatory parameters have being set.
1955: --
1956: hr_api.mandatory_arg_error
1957: (p_api_name => l_proc
1958: ,p_argument => 'change_date'
1959: ,p_argument_value => p_change_date
1960: );

Line 1962: hr_api.mandatory_arg_error

1958: ,p_argument => 'change_date'
1959: ,p_argument_value => p_change_date
1960: );
1961: --
1962: hr_api.mandatory_arg_error
1963: (p_api_name => l_proc
1964: ,p_argument => 'assignment_id'
1965: ,p_argument_value => p_assignment_id
1966: );

Line 1968: hr_api.mandatory_arg_error

1964: ,p_argument => 'assignment_id'
1965: ,p_argument_value => p_assignment_id
1966: );
1967: --
1968: hr_api.mandatory_arg_error
1969: (p_api_name => l_proc
1970: ,p_argument => 'business_group_id'
1971: ,p_argument_value => p_business_group_id
1972: );

Line 1975: hr_api.mandatory_arg_error

1971: ,p_argument_value => p_business_group_id
1972: );
1973: -- vkodedal 19-feb-2008 p_proposed_salary_n can be null when there are multiple components
1974: if( p_multiple_components <> 'Y' ) then
1975: hr_api.mandatory_arg_error
1976: (p_api_name => l_proc
1977: ,p_argument => 'proposed_salary_n'
1978: ,p_argument_value => p_proposed_salary_n
1979: );

Line 1991: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.proposed_salary_n,hr_api.g_number) <>

1987: l_api_updating := per_pyp_shd.api_updating
1988: (p_pay_proposal_id => p_pay_proposal_id
1989: ,p_object_version_number => p_object_version_number);
1990: --
1991: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.proposed_salary_n,hr_api.g_number) <>
1992: nvl(p_proposed_salary_n,hr_api.g_number))OR not l_api_updating) then
1993: if p_proposed_salary_n is not null then
1994:
1995: --

Line 1992: nvl(p_proposed_salary_n,hr_api.g_number))OR not l_api_updating) then

1988: (p_pay_proposal_id => p_pay_proposal_id
1989: ,p_object_version_number => p_object_version_number);
1990: --
1991: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.proposed_salary_n,hr_api.g_number) <>
1992: nvl(p_proposed_salary_n,hr_api.g_number))OR not l_api_updating) then
1993: if p_proposed_salary_n is not null then
1994:
1995: --
1996: -- The following check is commented out. As now we are allowing update of Approved Salary Proposals

Line 2129: hr_api.mandatory_arg_error

2125: -- Check mandatory parameters have being set.
2126: --
2127: --
2128: --
2129: hr_api.mandatory_arg_error
2130: (p_api_name => l_proc
2131: ,p_argument => 'change_date'
2132: ,p_argument_value => p_change_date
2133: );

Line 2135: hr_api.mandatory_arg_error

2131: ,p_argument => 'change_date'
2132: ,p_argument_value => p_change_date
2133: );
2134: --
2135: hr_api.mandatory_arg_error
2136: (p_api_name => l_proc
2137: ,p_argument => 'assignment_id'
2138: ,p_argument_value => p_assignment_id
2139: );

Line 2141: hr_api.mandatory_arg_error

2137: ,p_argument => 'assignment_id'
2138: ,p_argument_value => p_assignment_id
2139: );
2140: --
2141: hr_api.mandatory_arg_error
2142: (p_api_name => l_proc
2143: ,p_argument => 'business_group_id'
2144: ,p_argument_value => p_business_group_id
2145: );

Line 2148: hr_api.mandatory_arg_error

2144: ,p_argument_value => p_business_group_id
2145: );
2146: --
2147: --
2148: hr_api.mandatory_arg_error
2149: (p_api_name => l_proc
2150: ,p_argument => 'approved'
2151: ,p_argument_value => p_approved
2152: );

Line 2386: hr_api.mandatory_arg_error

2382: close csr_get_pro_detail;
2383: --
2384: -- Check mandatory column from the above cursor are set
2385: --
2386: hr_api.mandatory_arg_error
2387: (p_api_name => l_proc
2388: ,p_argument => 'assignment_id'
2389: ,p_argument_value => l_assignment_id
2390: );

Line 2392: hr_api.mandatory_arg_error

2388: ,p_argument => 'assignment_id'
2389: ,p_argument_value => l_assignment_id
2390: );
2391: --
2392: hr_api.mandatory_arg_error
2393: (p_api_name => l_proc
2394: ,p_argument => 'business_group_id'
2395: ,p_argument_value => l_business_group_id
2396: );

Line 2398: hr_api.mandatory_arg_error

2394: ,p_argument => 'business_group_id'
2395: ,p_argument_value => l_business_group_id
2396: );
2397: --
2398: hr_api.mandatory_arg_error
2399: (p_api_name => l_proc
2400: ,p_argument => 'change_date'
2401: ,p_argument_value => l_change_date
2402: );

Line 2404: hr_api.mandatory_arg_error

2400: ,p_argument => 'change_date'
2401: ,p_argument_value => l_change_date
2402: );
2403: --
2404: hr_api.mandatory_arg_error
2405: (p_api_name => l_proc
2406: ,p_argument => 'multiple_components'
2407: ,p_argument_value => l_multiple_components
2408: );

Line 2410: hr_api.mandatory_arg_error

2406: ,p_argument => 'multiple_components'
2407: ,p_argument_value => l_multiple_components
2408: );
2409: --
2410: hr_api.mandatory_arg_error
2411: (p_api_name => l_proc
2412: ,p_argument => 'approved'
2413: ,p_argument_value => l_approved
2414: );

Line 2650: hr_api.mandatory_arg_error

2646: hr_utility.set_location('Entering:'|| l_proc, 5);
2647: --
2648: -- Check mandatory parameters have being set.
2649: --
2650: hr_api.mandatory_arg_error
2651: (p_api_name => l_proc
2652: ,p_argument => 'assignment_id'
2653: ,p_argument_value => p_assignment_id
2654: );

Line 2664: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.performance_review_id,hr_api.g_number)

2660: l_api_updating := per_pyp_shd.api_updating
2661: (p_pay_proposal_id => p_pay_proposal_id
2662: ,p_object_version_number => p_object_version_number);
2663: --
2664: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.performance_review_id,hr_api.g_number)
2665: <> nvl(p_performance_review_id,hr_api.g_number))
2666: or not l_api_updating) then
2667: hr_utility.set_location(l_proc, 10);
2668: --

Line 2665: <> nvl(p_performance_review_id,hr_api.g_number))

2661: (p_pay_proposal_id => p_pay_proposal_id
2662: ,p_object_version_number => p_object_version_number);
2663: --
2664: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.performance_review_id,hr_api.g_number)
2665: <> nvl(p_performance_review_id,hr_api.g_number))
2666: or not l_api_updating) then
2667: hr_utility.set_location(l_proc, 10);
2668: --
2669: --

Line 2724: nvl(per_pyp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

2720: begin
2721: hr_utility.set_location('Entering:'||l_proc, 10);
2722: --
2723: if ((p_rec.pay_proposal_id is not null) and (
2724: nvl(per_pyp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2725: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2726: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2727: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2728: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 2725: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

2721: hr_utility.set_location('Entering:'||l_proc, 10);
2722: --
2723: if ((p_rec.pay_proposal_id is not null) and (
2724: nvl(per_pyp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2725: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2726: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2727: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2728: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2729: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 2726: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

2722: --
2723: if ((p_rec.pay_proposal_id is not null) and (
2724: nvl(per_pyp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2725: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2726: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2727: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2728: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2729: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2730: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 2727: nvl(p_rec.attribute1, hr_api.g_varchar2) or

2723: if ((p_rec.pay_proposal_id is not null) and (
2724: nvl(per_pyp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2725: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2726: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2727: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2728: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2729: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2730: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2731: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 2728: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

2724: nvl(per_pyp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2725: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2726: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2727: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2728: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2729: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2730: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2731: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2732: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 2729: nvl(p_rec.attribute2, hr_api.g_varchar2) or

2725: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2726: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2727: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2728: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2729: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2730: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2731: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2732: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2733: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 2730: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

2726: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2727: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2728: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2729: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2730: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2731: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2732: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2733: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2734: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 2731: nvl(p_rec.attribute3, hr_api.g_varchar2) or

2727: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2728: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2729: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2730: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2731: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2732: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2733: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2734: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2735: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 2732: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

2728: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2729: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2730: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2731: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2732: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2733: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2734: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2735: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2736: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 2733: nvl(p_rec.attribute4, hr_api.g_varchar2) or

2729: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2730: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2731: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2732: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2733: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2734: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2735: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2736: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2737: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 2734: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

2730: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2731: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2732: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2733: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2734: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2735: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2736: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2737: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2738: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 2735: nvl(p_rec.attribute5, hr_api.g_varchar2) or

2731: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2732: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2733: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2734: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2735: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2736: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2737: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2738: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2739: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 2736: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

2732: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2733: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2734: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2735: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2736: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2737: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2738: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2739: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2740: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 2737: nvl(p_rec.attribute6, hr_api.g_varchar2) or

2733: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2734: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2735: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2736: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2737: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2738: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2739: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2740: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2741: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 2738: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

2734: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2735: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2736: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2737: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2738: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2739: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2740: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2741: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2742: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 2739: nvl(p_rec.attribute7, hr_api.g_varchar2) or

2735: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2736: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2737: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2738: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2739: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2740: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2741: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2742: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2743: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 2740: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

2736: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2737: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2738: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2739: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2740: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2741: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2742: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2743: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2744: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 2741: nvl(p_rec.attribute8, hr_api.g_varchar2) or

2737: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2738: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2739: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2740: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2741: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2742: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2743: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2744: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2745: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 2742: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

2738: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2739: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2740: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2741: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2742: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2743: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2744: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2745: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2746: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 2743: nvl(p_rec.attribute9, hr_api.g_varchar2) or

2739: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2740: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2741: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2742: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2743: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2744: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2745: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2746: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2747: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 2744: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

2740: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2741: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2742: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2743: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2744: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2745: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2746: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2747: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2748: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 2745: nvl(p_rec.attribute10, hr_api.g_varchar2) or

2741: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2742: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2743: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2744: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2745: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2746: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2747: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2748: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2749: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 2746: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

2742: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2743: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2744: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2745: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2746: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2747: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2748: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2749: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2750: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 2747: nvl(p_rec.attribute11, hr_api.g_varchar2) or

2743: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2744: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2745: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2746: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2747: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2748: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2749: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2750: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2751: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 2748: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

2744: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2745: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2746: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2747: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2748: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2749: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2750: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2751: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2752: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 2749: nvl(p_rec.attribute12, hr_api.g_varchar2) or

2745: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2746: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2747: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2748: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2749: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2750: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2751: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2752: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2753: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 2750: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

2746: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2747: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2748: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2749: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2750: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2751: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2752: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2753: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2754: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 2751: nvl(p_rec.attribute13, hr_api.g_varchar2) or

2747: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2748: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2749: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2750: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2751: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2752: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2753: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2754: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2755: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 2752: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

2748: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2749: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2750: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2751: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2752: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2753: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2754: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2755: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2756: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 2753: nvl(p_rec.attribute14, hr_api.g_varchar2) or

2749: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2750: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2751: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2752: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2753: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2754: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2755: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2756: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2757: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 2754: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

2750: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2751: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2752: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2753: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2754: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2755: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2756: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2757: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2758: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 2755: nvl(p_rec.attribute15, hr_api.g_varchar2) or

2751: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2752: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2753: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2754: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2755: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2756: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2757: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2758: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2759: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 2756: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

2752: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2753: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2754: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2755: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2756: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2757: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2758: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2759: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2760: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 2757: nvl(p_rec.attribute16, hr_api.g_varchar2) or

2753: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2754: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2755: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2756: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2757: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2758: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2759: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2760: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2761: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 2758: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

2754: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2755: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2756: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2757: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2758: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2759: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2760: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2761: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2762: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 2759: nvl(p_rec.attribute17, hr_api.g_varchar2) or

2755: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2756: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2757: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2758: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2759: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2760: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2761: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2762: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2763: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 2760: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

2756: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2757: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2758: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2759: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2760: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2761: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2762: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2763: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2764: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 2761: nvl(p_rec.attribute18, hr_api.g_varchar2) or

2757: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2758: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2759: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2760: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2761: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2762: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2763: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2764: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2765: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 2762: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

2758: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2759: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2760: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2761: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2762: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2763: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2764: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2765: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2766: or

Line 2763: nvl(p_rec.attribute19, hr_api.g_varchar2) or

2759: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2760: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2761: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2762: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2763: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2764: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2765: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2766: or
2767: (p_rec.pay_proposal_id is null) then

Line 2764: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

2760: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2761: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2762: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2763: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2764: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2765: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2766: or
2767: (p_rec.pay_proposal_id is null) then
2768: --

Line 2765: nvl(p_rec.attribute20, hr_api.g_varchar2)))

2761: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2762: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2763: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2764: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2765: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2766: or
2767: (p_rec.pay_proposal_id is null) then
2768: --
2769: -- Only execute the validation if absolutely necessary:

Line 2858: hr_api.validate_bus_grp_id(p_rec.business_group_id);

2854: -- Business Rule Mapping
2855: -- =====================
2856: -- Rule CHK_BUSINESS_GROUP_ID a,c
2857: --
2858: hr_api.validate_bus_grp_id(p_rec.business_group_id);
2859: --
2860: hr_utility.set_location(l_proc, 10);
2861: --
2862: --

Line 3072: hr_api.validate_bus_grp_id(p_rec.business_group_id);

3068: -- relevant)
3069: --
3070: -- Validate business_group id
3071: --
3072: hr_api.validate_bus_grp_id(p_rec.business_group_id);
3073: --
3074: hr_utility.set_location(l_proc, 12);
3075: --
3076: -- Check those columns which cannot be updated

Line 3337: hr_api.mandatory_arg_error(p_api_name => l_proc,

3333: hr_utility.set_location('Entering:'|| l_proc, 10);
3334: --
3335: -- Ensure that all the mandatory parameter are not null
3336: --
3337: hr_api.mandatory_arg_error(p_api_name => l_proc,
3338: p_argument => 'pay_proposal_id',
3339: p_argument_value => p_pay_proposal_id);
3340: --
3341: if nvl(g_pay_proposal_id, hr_api.g_number) = p_pay_proposal_id then

Line 3341: if nvl(g_pay_proposal_id, hr_api.g_number) = p_pay_proposal_id then

3337: hr_api.mandatory_arg_error(p_api_name => l_proc,
3338: p_argument => 'pay_proposal_id',
3339: p_argument_value => p_pay_proposal_id);
3340: --
3341: if nvl(g_pay_proposal_id, hr_api.g_number) = p_pay_proposal_id then
3342: --
3343: -- The legislation code has already been found with a previous
3344: -- call to this function. Just return the value in the global
3345: -- variable.