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

APPS.PER_PYP_BUS dependencies on PER_PYP_SHD

Line 17: Procedure check_non_updateable_args(p_rec in per_pyp_shd.g_rec_type) is

13: -- ----------------------------------------------------------------------------
14: -- |----------------------< check_non_updateable_args >-----------------------|
15: -- ----------------------------------------------------------------------------
16: --
17: Procedure check_non_updateable_args(p_rec in per_pyp_shd.g_rec_type) is
18: --
19: l_proc varchar2(72) := g_package||'check_non_updateable_args';
20: l_error exception;
21: l_argument varchar2(30);

Line 29: if not per_pyp_shd.api_updating

25: --
26: -- Only proceed with validation if a row exists for
27: -- the current record in the HR Schema
28: --
29: if not per_pyp_shd.api_updating
30: (p_pay_proposal_id => p_rec.pay_proposal_id
31: ,p_object_version_number => p_rec.object_version_number
32: ) then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 40: if p_rec.business_group_id <> per_pyp_shd.g_old_rec.business_group_id then

36: end if;
37: --
38: hr_utility.set_location(l_proc, 6);
39: --
40: if p_rec.business_group_id <> per_pyp_shd.g_old_rec.business_group_id then
41: l_argument := 'business_group_id';
42: raise l_error;
43: end if;
44: hr_utility.set_location(l_proc, 7);

Line 46: if p_rec.assignment_id <> per_pyp_shd.g_old_rec.assignment_id then

42: raise l_error;
43: end if;
44: hr_utility.set_location(l_proc, 7);
45: --
46: if p_rec.assignment_id <> per_pyp_shd.g_old_rec.assignment_id then
47: l_argument := 'assignment_id';
48: raise l_error;
49: end if;
50: hr_utility.set_location(l_proc, 8);

Line 52: if p_rec.pay_proposal_id <> per_pyp_shd.g_old_rec.pay_proposal_id then

48: raise l_error;
49: end if;
50: hr_utility.set_location(l_proc, 8);
51: --
52: if p_rec.pay_proposal_id <> per_pyp_shd.g_old_rec.pay_proposal_id then
53: l_argument := 'pay_proposal_id';
54: raise l_error;
55: end if;
56: hr_utility.set_location(l_proc, 9);

Line 61: if p_rec.change_date <> per_pyp_shd.g_old_rec.change_date then

57: --
58: /* change_date can be updated provided that the proposal has not already
59: been approved.
60:
61: if p_rec.change_date <> per_pyp_shd.g_old_rec.change_date then
62: l_argument := 'change_date';
63: raise l_error;
64: end if;
65: hr_utility.set_location(l_proc, 10);*/

Line 67: if p_rec.last_change_date <> per_pyp_shd.g_old_rec.last_change_date then

63: raise l_error;
64: end if;
65: hr_utility.set_location(l_proc, 10);*/
66: --
67: if p_rec.last_change_date <> per_pyp_shd.g_old_rec.last_change_date then
68: l_argument := 'last_change_date';
69: raise l_error;
70: end if;
71: hr_utility.set_location(l_proc, 11);

Line 153: (p_rec in out nocopy per_pyp_shd.g_rec_type) is

149: hr_utility.set_location('Leaving :'|| l_proc, 90);
150: end validate_date_to;
151: --
152: procedure gen_last_change_date
153: (p_rec in out nocopy per_pyp_shd.g_rec_type) is
154: --
155: l_proc varchar2(72) := g_package || 'gen_last_change_date';
156: l_last_change_date per_pay_proposals.last_change_date%TYPE;
157: --

Line 706: l_api_updating := per_pyp_shd.api_updating

702: -- Only proceed with validation if :
703: -- a) The current g_old_rec is current and
704: -- b) The value for assignment_id or change_date has changed
705: --
706: l_api_updating := per_pyp_shd.api_updating
707: (p_pay_proposal_id => p_pay_proposal_id
708: ,p_object_version_number => p_object_version_number);
709: --
710: -- only proceed if we are inserting or if we are updaing and change date

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 718: if ((l_api_updating and per_pyp_shd.g_old_rec.approved='Y') and

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
719: (nvl(g_validate_ss_change_pay,'N') = 'N'))then
720: hr_utility.set_message(800,'HR_51349_PYP_CNT_UPD_CHG_DATE');
721: hr_utility.raise_error;
722: else

Line 1056: l_api_updating := per_pyp_shd.api_updating

1052: -- Only proceed with validation if :
1053: -- a) The current g_old_rec is current and
1054: -- b) The value for next_sal_review_date has changed
1055: --
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) <>

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 1216: l_api_updating := per_pyp_shd.api_updating

1212: -- Only proceed with validation if :
1213: -- a) The current g_old_rec is current and
1214: -- b) The value for next_sal_review_date has changed
1215: --
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) <>

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 1347: l_api_updating := per_pyp_shd.api_updating

1343: -- Only proceed with validation if :
1344: -- a) The current g_old_rec is current and
1345: -- b) The value for multiple_components has changed
1346: --
1347: l_api_updating := per_pyp_shd.api_updating
1348: (p_pay_proposal_id => p_pay_proposal_id
1349: ,p_object_version_number => p_object_version_number);
1350: --
1351: if (l_api_updating AND(per_pyp_shd.g_old_rec.multiple_components <>

Line 1351: if (l_api_updating AND(per_pyp_shd.g_old_rec.multiple_components <>

1347: l_api_updating := per_pyp_shd.api_updating
1348: (p_pay_proposal_id => p_pay_proposal_id
1349: ,p_object_version_number => p_object_version_number);
1350: --
1351: if (l_api_updating AND(per_pyp_shd.g_old_rec.multiple_components <>
1352: p_multiple_components) OR not l_api_updating) then
1353: hr_utility.set_location(l_proc, 4);
1354: --
1355: -- check that the value of the multiple_components is either 'Y' or 'N'

Line 1447: l_api_updating := per_pyp_shd.api_updating

1443: -- Only proceed with validation if :
1444: -- a) The current g_old_rec is current and
1445: -- b) The value for proposal_reason has changed
1446: --
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) <>

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 2130: l_api_updating := per_pyp_shd.api_updating

2126: -- Only proceed with validation if :
2127: -- a) The current g_old_rec is current and
2128: -- b) The value for proposed_salary_n has changed
2129: --
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) <>

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 2143: /* if (l_api_updating)AND(per_pyp_shd.g_old_rec.approved = 'Y' ) then

2139: -- The following check is commented out. As now we are allowing update of Approved Salary Proposals
2140: -- Change made by ggnanagu
2141: --
2142:
2143: /* if (l_api_updating)AND(per_pyp_shd.g_old_rec.approved = 'Y' ) then
2144: hr_utility.set_location(l_proc||' proposed = '||to_char(p_proposed_salary_n)||' old = '||to_char(per_pyp_shd.g_old_rec.proposed_salary_n), 2);
2145: hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
2146: hr_utility.raise_error;
2147: end if; */

Line 2144: hr_utility.set_location(l_proc||' proposed = '||to_char(p_proposed_salary_n)||' old = '||to_char(per_pyp_shd.g_old_rec.proposed_salary_n), 2);

2140: -- Change made by ggnanagu
2141: --
2142:
2143: /* if (l_api_updating)AND(per_pyp_shd.g_old_rec.approved = 'Y' ) then
2144: hr_utility.set_location(l_proc||' proposed = '||to_char(p_proposed_salary_n)||' old = '||to_char(per_pyp_shd.g_old_rec.proposed_salary_n), 2);
2145: hr_utility.set_message(801,'HR_51268_PYP_CANT_UPD_RECORD');
2146: hr_utility.raise_error;
2147: end if; */
2148:

Line 2301: l_api_updating := per_pyp_shd.api_updating

2297: -- Only proceed with validation if :
2298: -- a) The current g_old_rec is current and
2299: -- b) The value for approved has changed
2300: --
2301: l_api_updating := per_pyp_shd.api_updating
2302: (p_pay_proposal_id => p_pay_proposal_id
2303: ,p_object_version_number => p_object_version_number);
2304: --
2305: -- always check whether it is updating or changed or not

Line 2308: /* if (l_api_updating AND (per_pyp_shd.g_old_rec.approved <> p_approved)

2304: --
2305: -- always check whether it is updating or changed or not
2306: -- because the person type may have changed.
2307: --
2308: /* if (l_api_updating AND (per_pyp_shd.g_old_rec.approved <> p_approved)
2309: or not l_api_updating) then */
2310: --
2311: --
2312: -- check that the value of the approved is either 'Y' or 'N'

Line 2408: if (l_api_updating AND per_pyp_shd.g_old_rec.approved = 'Y' AND p_approved = 'N') then

2404: close csr_unapproved_components;
2405: --
2406: -- Check that an approved proposal cannot be unapproved.
2407: --
2408: if (l_api_updating AND per_pyp_shd.g_old_rec.approved = 'Y' AND p_approved = 'N') then
2409: hr_utility.set_location(l_proc,110);
2410: hr_utility.set_message(801,'HR_51270_PYP_CANT_UNAPPRO_PRO');
2411: hr_utility.raise_error;
2412: end if;

Line 2523: per_pyp_shd.constraint_error('PER_PAY_PROPOSALS_PK');

2519: l_change_date,l_multiple_components, l_approved;
2520: if csr_get_pro_detail%notfound then
2521: close csr_get_pro_detail;
2522: hr_utility.set_location(l_proc, 2);
2523: per_pyp_shd.constraint_error('PER_PAY_PROPOSALS_PK');
2524: end if;
2525: close csr_get_pro_detail;
2526: --
2527: -- Check mandatory column from the above cursor are set

Line 2803: l_api_updating := per_pyp_shd.api_updating

2799: -- Only proceed with validation if :
2800: -- a) The current g_old_rec is current and
2801: -- b) The value for event_id has changed
2802: --
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)

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 2820: per_pyp_shd.constraint_error('PER_PAY_PROPOSALS_FK4');

2816: fetch csr_chk_performance_review_id into l_exists;
2817: if csr_chk_performance_review_id%notfound then
2818: hr_utility.set_location(l_proc, 15);
2819: close csr_chk_performance_review_id;
2820: per_pyp_shd.constraint_error('PER_PAY_PROPOSALS_FK4');
2821: end if;
2822: --
2823: close csr_chk_performance_review_id;
2824: end if;

Line 2859: (p_rec in per_pyp_shd.g_rec_type) is

2855: -- Access Status:
2856: -- Internal Row Handler Use Only.
2857: --
2858: procedure chk_df
2859: (p_rec in per_pyp_shd.g_rec_type) is
2860: --
2861: l_proc varchar2(72) := g_package||'chk_df';
2862: --
2863: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 2975: (p_rec in out nocopy per_pyp_shd.g_rec_type

2971: -- |---------------------------< insert_validate >----------------------------|
2972: -- ----------------------------------------------------------------------------
2973: --
2974: Procedure insert_validate
2975: (p_rec in out nocopy per_pyp_shd.g_rec_type
2976: ,p_inv_next_sal_date_warning out nocopy boolean
2977: ,p_proposed_salary_warning out nocopy boolean
2978: ,p_approved_warning out nocopy boolean
2979: ,p_payroll_warning out nocopy boolean

Line 3196: (p_rec in out nocopy per_pyp_shd.g_rec_type

3192: -- ----------------------------------------------------------------------------
3193: -- |---------------------------< update_validate >----------------------------|
3194: -- ----------------------------------------------------------------------------
3195: Procedure update_validate
3196: (p_rec in out nocopy per_pyp_shd.g_rec_type
3197: ,p_inv_next_sal_date_warning out nocopy boolean
3198: ,p_proposed_salary_warning out nocopy boolean
3199: ,p_approved_warning out nocopy boolean
3200: ,p_payroll_warning out nocopy boolean

Line 3423: (p_rec in per_pyp_shd.g_rec_type

3419: -- ----------------------------------------------------------------------------
3420: -- |---------------------------< delete_validate >----------------------------|
3421: -- ----------------------------------------------------------------------------
3422: Procedure delete_validate
3423: (p_rec in per_pyp_shd.g_rec_type
3424: ,p_salary_warning out nocopy boolean
3425: ) is
3426:
3427: --

Line 3437: per_pyp_bus.chk_access(p_assignment_id => per_pyp_shd.g_old_rec.assignment_id

3433: -- Call all supporting business operations
3434: --
3435: -- Validate delete
3436: -- call to chk_access added for fixing bug#3839734
3437: per_pyp_bus.chk_access(p_assignment_id => per_pyp_shd.g_old_rec.assignment_id
3438: ,p_change_date => per_pyp_shd.g_old_rec.change_date);
3439: --
3440: --
3441: -- Business Rule Mapping

Line 3438: ,p_change_date => per_pyp_shd.g_old_rec.change_date);

3434: --
3435: -- Validate delete
3436: -- call to chk_access added for fixing bug#3839734
3437: per_pyp_bus.chk_access(p_assignment_id => per_pyp_shd.g_old_rec.assignment_id
3438: ,p_change_date => per_pyp_shd.g_old_rec.change_date);
3439: --
3440: --
3441: -- Business Rule Mapping
3442: -- =====================