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 684: hr_api.mandatory_arg_error

680: hr_utility.set_location('Entering:'|| l_proc, 1);
681: --
682: -- Check mandatory parameters have been set
683: --
684: hr_api.mandatory_arg_error
685: (p_api_name => l_proc
686: ,p_argument => 'assignment_id'
687: ,p_argument_value => p_assignment_id
688: );

Line 690: hr_api.mandatory_arg_error

686: ,p_argument => 'assignment_id'
687: ,p_argument_value => p_assignment_id
688: );
689: --
690: hr_api.mandatory_arg_error
691: (p_api_name => l_proc
692: ,p_argument => 'business_group_id'
693: ,p_argument_value => p_business_group_id
694: );

Line 696: hr_api.mandatory_arg_error

692: ,p_argument => 'business_group_id'
693: ,p_argument_value => p_business_group_id
694: );
695: --
696: hr_api.mandatory_arg_error
697: (p_api_name => l_proc
698: ,p_argument => 'change_date'
699: ,p_argument_value => p_change_date
700: );

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

709: --
710: -- only proceed if we are inserting or if we are updaing and change date
711: -- has changed
712: --
713: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.change_date,hr_api.g_date) <>
714: nvl(p_change_date,hr_api.g_date) )or not l_api_updating) then
715: --
716: -- if we are updating but it was already approved then error.
717: --

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

710: -- only proceed if we are inserting or if we are updaing and change date
711: -- has changed
712: --
713: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.change_date,hr_api.g_date) <>
714: nvl(p_change_date,hr_api.g_date) )or not l_api_updating) then
715: --
716: -- if we are updating but it was already approved then error.
717: --
718: if ((l_api_updating and per_pyp_shd.g_old_rec.approved='Y') and

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

1021: where assg.assignment_id = p_assignment_id
1022: and assg.assignment_status_type_id = ast.assignment_status_type_id
1023: and assg.business_group_id + 0 = p_business_group_id
1024: and p_next_sal_review_date between assg.effective_start_date
1025: and nvl(assg.effective_end_date, hr_api.g_eot)
1026: and ast.per_system_status = 'TERM_ASSIGN';
1027: --
1028: begin
1029: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1034: hr_api.mandatory_arg_error

1030: p_inv_next_sal_date_warning := false;
1031: --
1032: -- Check mandatory parameters have being set.
1033: --
1034: hr_api.mandatory_arg_error
1035: (p_api_name => l_proc
1036: ,p_argument => 'change_date'
1037: ,p_argument_value => p_change_date
1038: );

Line 1040: hr_api.mandatory_arg_error

1036: ,p_argument => 'change_date'
1037: ,p_argument_value => p_change_date
1038: );
1039: --
1040: hr_api.mandatory_arg_error
1041: (p_api_name => l_proc
1042: ,p_argument => 'assignment_id'
1043: ,p_argument_value => p_assignment_id
1044: );

Line 1046: hr_api.mandatory_arg_error

1042: ,p_argument => 'assignment_id'
1043: ,p_argument_value => p_assignment_id
1044: );
1045: --
1046: hr_api.mandatory_arg_error
1047: (p_api_name => l_proc
1048: ,p_argument => 'business_group_id'
1049: ,p_argument_value => p_business_group_id
1050: );

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

1056: l_api_updating := per_pyp_shd.api_updating
1057: (p_pay_proposal_id => p_pay_proposal_id
1058: ,p_object_version_number => p_object_version_number);
1059: --
1060: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.next_sal_review_date,hr_api.g_date) <>
1061: nvl(p_next_sal_review_date,hr_api.g_date) )or not l_api_updating) then
1062: --
1063: -- If the next_sal_review is not null do the following checks
1064: --

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

1057: (p_pay_proposal_id => p_pay_proposal_id
1058: ,p_object_version_number => p_object_version_number);
1059: --
1060: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.next_sal_review_date,hr_api.g_date) <>
1061: nvl(p_next_sal_review_date,hr_api.g_date) )or not l_api_updating) then
1062: --
1063: -- If the next_sal_review is not null do the following checks
1064: --
1065: if (p_next_sal_review_date IS NOT NULL) then

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

1167: from per_all_assignments_f
1168: where assignment_id = p_assignment_id
1169: and business_group_id + 0 = p_business_group_id
1170: and p_change_date between effective_start_date
1171: and nvl(effective_end_date, hr_api.g_eot);
1172: --
1173: --
1174: -- Cursor to check the assignment status as next_sal_review_date.
1175: --

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

1180: where assg.assignment_id = p_assignment_id
1181: and assg.assignment_status_type_id = ast.assignment_status_type_id
1182: and assg.business_group_id + 0 = p_business_group_id
1183: and p_next_sal_review_date between assg.effective_start_date
1184: and nvl(assg.effective_end_date, hr_api.g_eot)
1185: and ast.per_system_status = 'TERM_ASSIGN';
1186: --
1187: begin
1188: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1193: hr_api.mandatory_arg_error

1189: p_inv_next_sal_date_warning := false;
1190: --
1191: -- Check mandatory parameters have being set.
1192: --
1193: hr_api.mandatory_arg_error
1194: (p_api_name => l_proc
1195: ,p_argument => 'change_date'
1196: ,p_argument_value => p_change_date
1197: );

Line 1199: hr_api.mandatory_arg_error

1195: ,p_argument => 'change_date'
1196: ,p_argument_value => p_change_date
1197: );
1198: --
1199: hr_api.mandatory_arg_error
1200: (p_api_name => l_proc
1201: ,p_argument => 'assignment_id'
1202: ,p_argument_value => p_assignment_id
1203: );

Line 1205: hr_api.mandatory_arg_error

1201: ,p_argument => 'assignment_id'
1202: ,p_argument_value => p_assignment_id
1203: );
1204: --
1205: hr_api.mandatory_arg_error
1206: (p_api_name => l_proc
1207: ,p_argument => 'business_group_id'
1208: ,p_argument_value => p_business_group_id
1209: );

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

1216: l_api_updating := per_pyp_shd.api_updating
1217: (p_pay_proposal_id => p_pay_proposal_id
1218: ,p_object_version_number => p_object_version_number);
1219: --
1220: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.next_sal_review_date,hr_api.g_date) <>
1221: nvl(p_next_sal_review_date,hr_api.g_date)) OR not l_api_updating) then
1222: --
1223: if (p_next_sal_review_date IS NULL) then
1224: -- When the next_sal_review is null then we do the following:

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

1217: (p_pay_proposal_id => p_pay_proposal_id
1218: ,p_object_version_number => p_object_version_number);
1219: --
1220: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.next_sal_review_date,hr_api.g_date) <>
1221: nvl(p_next_sal_review_date,hr_api.g_date)) OR not l_api_updating) then
1222: --
1223: if (p_next_sal_review_date IS NULL) then
1224: -- When the next_sal_review is null then we do the following:
1225: -- a) check the sal_review details at the assignment level

Line 1325: hr_api.mandatory_arg_error

1321: hr_utility.set_location('Entering:'|| l_proc, 1);
1322: --
1323: -- Check mandatory parameters have being set.
1324: --
1325: hr_api.mandatory_arg_error
1326: (p_api_name => l_proc
1327: ,p_argument => 'change_date'
1328: ,p_argument_value => p_change_date
1329: );

Line 1331: hr_api.mandatory_arg_error

1327: ,p_argument => 'change_date'
1328: ,p_argument_value => p_change_date
1329: );
1330: --
1331: hr_api.mandatory_arg_error
1332: (p_api_name => l_proc
1333: ,p_argument => 'assignment_id'
1334: ,p_argument_value => p_assignment_id
1335: );

Line 1337: hr_api.mandatory_arg_error

1333: ,p_argument => 'assignment_id'
1334: ,p_argument_value => p_assignment_id
1335: );
1336: --
1337: hr_api.mandatory_arg_error
1338: (p_api_name => l_proc
1339: ,p_argument => 'multiple_components'
1340: ,p_argument_value => p_multiple_components
1341: );

Line 1437: hr_api.mandatory_arg_error

1433: hr_utility.set_location('Entering:'|| l_proc, 1);
1434: --
1435: -- Check mandatory parameters have being set.
1436: --
1437: hr_api.mandatory_arg_error
1438: (p_api_name => l_proc
1439: ,p_argument => 'change_date'
1440: ,p_argument_value => p_change_date
1441: );

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

1447: l_api_updating := per_pyp_shd.api_updating
1448: (p_pay_proposal_id => p_pay_proposal_id
1449: ,p_object_version_number => p_object_version_number);
1450: --
1451: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.proposal_reason,hr_api.g_varchar2) <>
1452: nvl(p_proposal_reason,hr_api.g_varchar2))
1453: OR not l_api_updating ) then
1454: hr_utility.set_location(l_proc, 6);
1455: --

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

1448: (p_pay_proposal_id => p_pay_proposal_id
1449: ,p_object_version_number => p_object_version_number);
1450: --
1451: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.proposal_reason,hr_api.g_varchar2) <>
1452: nvl(p_proposal_reason,hr_api.g_varchar2))
1453: OR not l_api_updating ) then
1454: hr_utility.set_location(l_proc, 6);
1455: --
1456: -- check that the p_proposal_reason exists in hr_lookups.

Line 1459: if hr_api.not_exists_in_hr_lookups

1455: --
1456: -- check that the p_proposal_reason exists in hr_lookups.
1457: --
1458: if (p_proposal_reason IS NOT NULL ) then
1459: if hr_api.not_exists_in_hr_lookups
1460: (p_effective_date => p_change_date
1461: ,p_lookup_type => 'PROPOSAL_REASON'
1462: ,p_lookup_code => p_proposal_reason
1463: ) then

Line 2093: hr_api.mandatory_arg_error

2089: hr_utility.set_location('Entering:'|| l_proc, 1);
2090: --
2091: -- Check mandatory parameters have being set.
2092: --
2093: hr_api.mandatory_arg_error
2094: (p_api_name => l_proc
2095: ,p_argument => 'change_date'
2096: ,p_argument_value => p_change_date
2097: );

Line 2099: hr_api.mandatory_arg_error

2095: ,p_argument => 'change_date'
2096: ,p_argument_value => p_change_date
2097: );
2098: --
2099: hr_api.mandatory_arg_error
2100: (p_api_name => l_proc
2101: ,p_argument => 'assignment_id'
2102: ,p_argument_value => p_assignment_id
2103: );

Line 2105: hr_api.mandatory_arg_error

2101: ,p_argument => 'assignment_id'
2102: ,p_argument_value => p_assignment_id
2103: );
2104: --
2105: hr_api.mandatory_arg_error
2106: (p_api_name => l_proc
2107: ,p_argument => 'business_group_id'
2108: ,p_argument_value => p_business_group_id
2109: );

Line 2112: /*hr_api.mandatory_arg_error

2108: ,p_argument_value => p_business_group_id
2109: );
2110: -- vkodedal 19-feb-2008 p_proposed_salary_n can be null when there are multiple components
2111: if( p_multiple_components <> 'Y' ) then
2112: /*hr_api.mandatory_arg_error
2113: (p_api_name => l_proc
2114: ,p_argument => 'proposed_salary_n'
2115: ,p_argument_value => p_proposed_salary_n
2116: ); */

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

2130: l_api_updating := per_pyp_shd.api_updating
2131: (p_pay_proposal_id => p_pay_proposal_id
2132: ,p_object_version_number => p_object_version_number);
2133: --
2134: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.proposed_salary_n,hr_api.g_number) <>
2135: nvl(p_proposed_salary_n,hr_api.g_number))OR not l_api_updating) then
2136: if p_proposed_salary_n is not null then
2137:
2138: --

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

2131: (p_pay_proposal_id => p_pay_proposal_id
2132: ,p_object_version_number => p_object_version_number);
2133: --
2134: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.proposed_salary_n,hr_api.g_number) <>
2135: nvl(p_proposed_salary_n,hr_api.g_number))OR not l_api_updating) then
2136: if p_proposed_salary_n is not null then
2137:
2138: --
2139: -- The following check is commented out. As now we are allowing update of Approved Salary Proposals

Line 2272: hr_api.mandatory_arg_error

2268: -- Check mandatory parameters have being set.
2269: --
2270: --
2271: --
2272: hr_api.mandatory_arg_error
2273: (p_api_name => l_proc
2274: ,p_argument => 'change_date'
2275: ,p_argument_value => p_change_date
2276: );

Line 2278: hr_api.mandatory_arg_error

2274: ,p_argument => 'change_date'
2275: ,p_argument_value => p_change_date
2276: );
2277: --
2278: hr_api.mandatory_arg_error
2279: (p_api_name => l_proc
2280: ,p_argument => 'assignment_id'
2281: ,p_argument_value => p_assignment_id
2282: );

Line 2284: hr_api.mandatory_arg_error

2280: ,p_argument => 'assignment_id'
2281: ,p_argument_value => p_assignment_id
2282: );
2283: --
2284: hr_api.mandatory_arg_error
2285: (p_api_name => l_proc
2286: ,p_argument => 'business_group_id'
2287: ,p_argument_value => p_business_group_id
2288: );

Line 2291: hr_api.mandatory_arg_error

2287: ,p_argument_value => p_business_group_id
2288: );
2289: --
2290: --
2291: hr_api.mandatory_arg_error
2292: (p_api_name => l_proc
2293: ,p_argument => 'approved'
2294: ,p_argument_value => p_approved
2295: );

Line 2529: hr_api.mandatory_arg_error

2525: close csr_get_pro_detail;
2526: --
2527: -- Check mandatory column from the above cursor are set
2528: --
2529: hr_api.mandatory_arg_error
2530: (p_api_name => l_proc
2531: ,p_argument => 'assignment_id'
2532: ,p_argument_value => l_assignment_id
2533: );

Line 2535: hr_api.mandatory_arg_error

2531: ,p_argument => 'assignment_id'
2532: ,p_argument_value => l_assignment_id
2533: );
2534: --
2535: hr_api.mandatory_arg_error
2536: (p_api_name => l_proc
2537: ,p_argument => 'business_group_id'
2538: ,p_argument_value => l_business_group_id
2539: );

Line 2541: hr_api.mandatory_arg_error

2537: ,p_argument => 'business_group_id'
2538: ,p_argument_value => l_business_group_id
2539: );
2540: --
2541: hr_api.mandatory_arg_error
2542: (p_api_name => l_proc
2543: ,p_argument => 'change_date'
2544: ,p_argument_value => l_change_date
2545: );

Line 2547: hr_api.mandatory_arg_error

2543: ,p_argument => 'change_date'
2544: ,p_argument_value => l_change_date
2545: );
2546: --
2547: hr_api.mandatory_arg_error
2548: (p_api_name => l_proc
2549: ,p_argument => 'multiple_components'
2550: ,p_argument_value => l_multiple_components
2551: );

Line 2553: hr_api.mandatory_arg_error

2549: ,p_argument => 'multiple_components'
2550: ,p_argument_value => l_multiple_components
2551: );
2552: --
2553: hr_api.mandatory_arg_error
2554: (p_api_name => l_proc
2555: ,p_argument => 'approved'
2556: ,p_argument_value => l_approved
2557: );

Line 2793: hr_api.mandatory_arg_error

2789: hr_utility.set_location('Entering:'|| l_proc, 5);
2790: --
2791: -- Check mandatory parameters have being set.
2792: --
2793: hr_api.mandatory_arg_error
2794: (p_api_name => l_proc
2795: ,p_argument => 'assignment_id'
2796: ,p_argument_value => p_assignment_id
2797: );

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

2803: l_api_updating := per_pyp_shd.api_updating
2804: (p_pay_proposal_id => p_pay_proposal_id
2805: ,p_object_version_number => p_object_version_number);
2806: --
2807: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.performance_review_id,hr_api.g_number)
2808: <> nvl(p_performance_review_id,hr_api.g_number))
2809: or not l_api_updating) then
2810: hr_utility.set_location(l_proc, 10);
2811: --

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

2804: (p_pay_proposal_id => p_pay_proposal_id
2805: ,p_object_version_number => p_object_version_number);
2806: --
2807: if (l_api_updating AND (nvl(per_pyp_shd.g_old_rec.performance_review_id,hr_api.g_number)
2808: <> nvl(p_performance_review_id,hr_api.g_number))
2809: or not l_api_updating) then
2810: hr_utility.set_location(l_proc, 10);
2811: --
2812: --

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

2863: begin
2864: hr_utility.set_location('Entering:'||l_proc, 10);
2865: --
2866: if ((p_rec.pay_proposal_id is not null) and (
2867: nvl(per_pyp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2868: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2869: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2871: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

2864: hr_utility.set_location('Entering:'||l_proc, 10);
2865: --
2866: if ((p_rec.pay_proposal_id is not null) and (
2867: nvl(per_pyp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2868: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2869: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2871: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2872: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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

2865: --
2866: if ((p_rec.pay_proposal_id is not null) and (
2867: nvl(per_pyp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2868: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2869: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2871: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2873: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

2866: if ((p_rec.pay_proposal_id is not null) and (
2867: nvl(per_pyp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2868: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2869: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2871: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2873: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2874: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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

2867: nvl(per_pyp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2868: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2869: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2871: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2873: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2875: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

2868: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2869: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2871: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2873: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2875: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2876: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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

2869: nvl(per_pyp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2871: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2873: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2875: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2877: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

2870: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2871: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2873: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2875: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2877: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2878: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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

2871: nvl(per_pyp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2873: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2875: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2877: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2879: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

2872: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2873: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2875: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2877: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2879: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2880: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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

2873: nvl(per_pyp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2875: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2877: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2879: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2881: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

2874: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2875: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2877: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2879: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2881: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2882: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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

2875: nvl(per_pyp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2877: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2879: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2881: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2883: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

2876: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2877: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2879: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2881: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2883: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2884: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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

2877: nvl(per_pyp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2879: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2881: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2883: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2885: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

2878: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2879: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2881: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2883: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2885: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2886: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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

2879: nvl(per_pyp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2881: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2883: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2885: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2887: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

2880: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2881: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2883: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2885: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2887: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2888: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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

2881: nvl(per_pyp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2883: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2885: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2887: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2889: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

2882: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2883: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2885: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2887: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2889: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2890: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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

2883: nvl(per_pyp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2885: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2887: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2889: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2891: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

2884: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2885: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2887: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2889: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2891: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2892: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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

2885: nvl(per_pyp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2887: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2889: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2891: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2893: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

2886: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2887: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2889: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2891: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2893: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2894: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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

2887: nvl(per_pyp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2889: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2891: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2893: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2895: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

2888: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2889: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2891: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2893: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2895: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2896: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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

2889: nvl(per_pyp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2891: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2893: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2895: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2897: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

2890: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2891: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2893: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2895: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2897: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2898: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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

2891: nvl(per_pyp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2893: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2895: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2897: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2899: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

2892: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2893: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2895: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2897: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2899: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2900: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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

2893: nvl(per_pyp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2895: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2897: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2899: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2901: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

2894: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2895: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2897: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2899: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2901: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2902: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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

2895: nvl(per_pyp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2897: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2899: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2901: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2903: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

2896: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2897: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2899: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2901: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2903: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2904: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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

2897: nvl(per_pyp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2899: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2901: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2903: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2905: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

2898: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2899: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2901: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2903: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2905: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2906: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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

2899: nvl(per_pyp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2901: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2903: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2905: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2907: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

2900: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2901: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2903: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2905: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2907: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2908: nvl(p_rec.attribute20, hr_api.g_varchar2)))

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

2901: nvl(per_pyp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2903: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2905: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2907: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2908: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2909: or

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

2902: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2903: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2905: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2907: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2908: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2909: or
2910: (p_rec.pay_proposal_id is null) then

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

2903: nvl(per_pyp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2905: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2907: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2908: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2909: or
2910: (p_rec.pay_proposal_id is null) then
2911: --

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

2904: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2905: nvl(per_pyp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2906: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2907: nvl(per_pyp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2908: nvl(p_rec.attribute20, hr_api.g_varchar2)))
2909: or
2910: (p_rec.pay_proposal_id is null) then
2911: --
2912: -- Only execute the validation if absolutely necessary:

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

2997: -- Business Rule Mapping
2998: -- =====================
2999: -- Rule CHK_BUSINESS_GROUP_ID a,c
3000: --
3001: hr_api.validate_bus_grp_id(p_rec.business_group_id);
3002: --
3003: hr_utility.set_location(l_proc, 10);
3004: --
3005: --

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

3211: -- relevant)
3212: --
3213: -- Validate business_group id
3214: --
3215: hr_api.validate_bus_grp_id(p_rec.business_group_id);
3216: --
3217: hr_utility.set_location(l_proc, 12);
3218: --
3219: -- Check those columns which cannot be updated

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

3476: hr_utility.set_location('Entering:'|| l_proc, 10);
3477: --
3478: -- Ensure that all the mandatory parameter are not null
3479: --
3480: hr_api.mandatory_arg_error(p_api_name => l_proc,
3481: p_argument => 'pay_proposal_id',
3482: p_argument_value => p_pay_proposal_id);
3483: --
3484: if nvl(g_pay_proposal_id, hr_api.g_number) = p_pay_proposal_id then

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

3480: hr_api.mandatory_arg_error(p_api_name => l_proc,
3481: p_argument => 'pay_proposal_id',
3482: p_argument_value => p_pay_proposal_id);
3483: --
3484: if nvl(g_pay_proposal_id, hr_api.g_number) = p_pay_proposal_id then
3485: --
3486: -- The legislation code has already been found with a previous
3487: -- call to this function. Just return the value in the global
3488: -- variable.