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_ASG_BUS2 dependencies on PER_ALL_ASSIGNMENTS_F

Line 15: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

11: -- |------------------------< chk_pay_basis_id >-----------------------------|
12: -- ---------------------------------------------------------------------------
13: --
14: procedure chk_pay_basis_id
15: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
16: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
17: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
18: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
19: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE

Line 16: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE

12: -- ---------------------------------------------------------------------------
13: --
14: procedure chk_pay_basis_id
15: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
16: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
17: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
18: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
19: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
20: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 17: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

13: --
14: procedure chk_pay_basis_id
15: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
16: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
17: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
18: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
19: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
20: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
21: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 18: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

14: procedure chk_pay_basis_id
15: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
16: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
17: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
18: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
19: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
20: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
21: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
22: )

Line 19: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE

15: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
16: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
17: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
18: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
19: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
20: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
21: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
22: )
23: is

Line 20: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

16: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
17: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
18: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
19: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
20: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
21: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
22: )
23: is
24: --

Line 21: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

17: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
18: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
19: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
20: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
21: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
22: )
23: is
24: --
25: l_proc varchar2(72) := g_package||'chk_pay_basis_id';

Line 88: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID'

84: if p_assignment_type not in ('E','A','B','O') then
85: --
86: hr_utility.set_message(801, 'HR_51176_ASG_INV_ASG_TYP_PBS');
87: hr_multi_message.add
88: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID'
89: );
90: --
91: end if;
92: hr_utility.set_location(l_proc, 4);

Line 102: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID'

98: if csr_chk_pay_basis%notfound then
99: close csr_chk_pay_basis;
100: hr_utility.set_message(801, 'HR_51168_ASG_INV_PAY_BASIS_ID');
101: hr_multi_message.add
102: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID'
103: );
104: else
105: close csr_chk_pay_basis;
106: end if;

Line 116: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID'

112: If p_business_group_id <> l_business_group_id then
113: --
114: hr_utility.set_message(801, 'HR_51169_ASG_INV_PAY_BAS_BG');
115: hr_multi_message.add
116: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID'
117: );
118: --
119: end if;
120: hr_utility.set_location(l_proc, 6);

Line 141: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

137: if l_max_pp_chg_date > p_validation_start_date then
138: --
139: hr_utility.set_message(801, 'HR_51171_ASG_INV_PB_PP_CD');
140: hr_multi_message.add
141: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
142: );
143: --
144: end if;
145: hr_utility.set_location(l_proc, 8);

Line 160: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

156: -- |------------------------< chk_payroll_id >-------------------------------|
157: -- ---------------------------------------------------------------------------
158: --
159: procedure chk_payroll_id
160: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
161: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
162: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
163: ,p_person_id in per_all_assignments_f.person_id%TYPE
164: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE

Line 161: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

157: -- ---------------------------------------------------------------------------
158: --
159: procedure chk_payroll_id
160: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
161: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
162: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
163: ,p_person_id in per_all_assignments_f.person_id%TYPE
164: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
165: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 162: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

158: --
159: procedure chk_payroll_id
160: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
161: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
162: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
163: ,p_person_id in per_all_assignments_f.person_id%TYPE
164: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
165: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
166: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 163: ,p_person_id in per_all_assignments_f.person_id%TYPE

159: procedure chk_payroll_id
160: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
161: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
162: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
163: ,p_person_id in per_all_assignments_f.person_id%TYPE
164: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
165: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
166: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
167: ,p_effective_date in date

Line 164: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE

160: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
161: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
162: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
163: ,p_person_id in per_all_assignments_f.person_id%TYPE
164: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
165: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
166: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
167: ,p_effective_date in date
168: ,p_datetrack_mode in varchar2

Line 165: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

161: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
162: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
163: ,p_person_id in per_all_assignments_f.person_id%TYPE
164: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
165: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
166: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
167: ,p_effective_date in date
168: ,p_datetrack_mode in varchar2
169: ,p_payroll_id_updated out nocopy boolean

Line 166: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

162: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
163: ,p_person_id in per_all_assignments_f.person_id%TYPE
164: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
165: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
166: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
167: ,p_effective_date in date
168: ,p_datetrack_mode in varchar2
169: ,p_payroll_id_updated out nocopy boolean
170: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 170: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

166: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
167: ,p_effective_date in date
168: ,p_datetrack_mode in varchar2
169: ,p_payroll_id_updated out nocopy boolean
170: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
171: )
172: is
173: --
174: l_proc varchar2(72) := g_package||'chk_payroll_id';

Line 238: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

234: -- |----------------------< chk_payroll_id_int >------------------------------|
235: -- ---------------------------------------------------------------------------
236: --
237: procedure chk_payroll_id_int
238: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
239: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
240: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
241: ,p_person_id in per_all_assignments_f.person_id%TYPE
242: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE

Line 239: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

235: -- ---------------------------------------------------------------------------
236: --
237: procedure chk_payroll_id_int
238: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
239: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
240: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
241: ,p_person_id in per_all_assignments_f.person_id%TYPE
242: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
243: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 240: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

236: --
237: procedure chk_payroll_id_int
238: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
239: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
240: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
241: ,p_person_id in per_all_assignments_f.person_id%TYPE
242: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
243: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
244: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 241: ,p_person_id in per_all_assignments_f.person_id%TYPE

237: procedure chk_payroll_id_int
238: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
239: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
240: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
241: ,p_person_id in per_all_assignments_f.person_id%TYPE
242: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
243: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
244: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
245: ,p_effective_date in date

Line 242: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE

238: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
239: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
240: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
241: ,p_person_id in per_all_assignments_f.person_id%TYPE
242: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
243: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
244: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
245: ,p_effective_date in date
246: ,p_datetrack_mode in varchar2

Line 243: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

239: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
240: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
241: ,p_person_id in per_all_assignments_f.person_id%TYPE
242: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
243: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
244: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
245: ,p_effective_date in date
246: ,p_datetrack_mode in varchar2
247: ,p_address_line1 in per_addresses.address_line1%type

Line 244: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

240: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
241: ,p_person_id in per_all_assignments_f.person_id%TYPE
242: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
243: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
244: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
245: ,p_effective_date in date
246: ,p_datetrack_mode in varchar2
247: ,p_address_line1 in per_addresses.address_line1%type
248: ,p_date_of_birth in per_all_people_f.date_of_birth%type

Line 250: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

246: ,p_datetrack_mode in varchar2
247: ,p_address_line1 in per_addresses.address_line1%type
248: ,p_date_of_birth in per_all_people_f.date_of_birth%type
249: ,p_payroll_id_updated out nocopy boolean
250: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
251: )
252: is
253: --
254: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 330: from per_all_assignments_f asg

326: order by 2;
327: --
328: cursor csr_any_future_changes is
329: select null
330: from per_all_assignments_f asg
331: where asg.assignment_id = p_assignment_id
332: and asg.payroll_id <> p_payroll_id
333: and asg.effective_start_date <= p_validation_end_date
334: and asg.effective_end_date >= p_validation_start_date;

Line 340: ,per_all_assignments_f paf

336: cursor csr_any_future_asas is
337: select null
338: from pay_assignment_actions asa
339: ,pay_payroll_actions pra
340: ,per_all_assignments_f paf
341: where asa.assignment_id = p_assignment_id
342: and pra.payroll_action_id = asa.payroll_action_id
343: --
344: -- Fix for bug 3693830 starts here.

Line 441: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'

437: if p_assignment_type not in ('E','A','B','O') then
438: --
439: hr_utility.set_message(801, 'HR_51226_ASG_INV_ASG_TYP_PAY');
440: hr_multi_message.add
441: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
442: );
443: --
444: end if;
445: hr_utility.set_location(l_proc, 50);

Line 471: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'

467: --
468: if p_address_line1 is null then
469: hr_utility.set_message(800, 'PER_52990_ASG_PRADD_NE_PAY');
470: hr_multi_message.add
471: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
472: );
473: --
474: end if;
475: hr_utility.set_location(l_proc, 55);

Line 490: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'

486: if csr_payroll_exists%notfound then
487: close csr_payroll_exists;
488: hr_utility.set_message(801, 'HR_7370_ASG_INVALID_PAYROLL');
489: hr_multi_message.add
490: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
491: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
492: );
493: else
494: close csr_payroll_exists;

Line 491: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

487: close csr_payroll_exists;
488: hr_utility.set_message(801, 'HR_7370_ASG_INVALID_PAYROLL');
489: hr_multi_message.add
490: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
491: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
492: );
493: else
494: close csr_payroll_exists;
495: end if;

Line 507: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'

503: if l_business_group_id <> p_business_group_id then
504: close csr_get_bus_grp;
505: hr_utility.set_message(801, 'HR_7373_ASG_INVALID_BG_PAYROLL');
506: hr_multi_message.add
507: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
508: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
509: );
510: else
511: close csr_get_bus_grp;

Line 508: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

504: close csr_get_bus_grp;
505: hr_utility.set_message(801, 'HR_7373_ASG_INVALID_BG_PAYROLL');
506: hr_multi_message.add
507: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
508: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
509: );
510: else
511: close csr_get_bus_grp;
512: end if;

Line 523: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_OF_BIRTH'

519: hr_utility.set_location(l_proc, 75);
520: if p_date_of_birth is null then
521: hr_utility.set_message(801, 'HR_7378_ASG_NO_DATE_OF_BIRTH');
522: hr_multi_message.add
523: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_OF_BIRTH'
524: );
525: end if;
526: hr_utility.set_location(l_proc, 80);
527: end if;

Line 746: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'

742: hr_utility.set_location(l_proc, 230);
743: --
744: hr_utility.set_message(801, 'HR_7969_ASG_INV_PAYROLL_PPMS');
745: hr_multi_message.add
746: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
747: );
748: end if;
749: end if;
750: --

Line 777: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

773: close csr_any_future_asas;
774: --
775: hr_utility.set_message(801, 'HR_7975_ASG_INV_FUTURE_ASA');
776: hr_multi_message.add
777: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
778: );
779: else
780: --
781: hr_utility.set_location(l_proc, 240);

Line 797: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

793: -- |-----------------------< chk_people_group_id >---------------------------|
794: -- ---------------------------------------------------------------------------
795: --
796: procedure chk_people_group_id
797: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
798: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
799: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
800: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
801: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

Line 798: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

794: -- ---------------------------------------------------------------------------
795: --
796: procedure chk_people_group_id
797: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
798: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
799: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
800: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
801: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
802: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 799: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

795: --
796: procedure chk_people_group_id
797: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
798: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
799: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
800: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
801: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
802: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
803: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 800: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE

796: procedure chk_people_group_id
797: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
798: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
799: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
800: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
801: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
802: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
803: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
804: ,p_effective_date in date

Line 801: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

797: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
798: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
799: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
800: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
801: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
802: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
803: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
804: ,p_effective_date in date
805: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 802: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

798: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
799: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
800: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
801: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
802: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
803: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
804: ,p_effective_date in date
805: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
806: )

Line 803: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

799: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
800: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
801: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
802: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
803: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
804: ,p_effective_date in date
805: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
806: )
807: is

Line 805: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

801: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
802: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
803: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
804: ,p_effective_date in date
805: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
806: )
807: is
808: --
809: l_exists varchar2(1);

Line 812: l_vac_people_group_id per_all_assignments_f.people_group_id%TYPE;

808: --
809: l_exists varchar2(1);
810: l_api_updating boolean;
811: l_proc varchar2(72) := g_package||'chk_people_group_id';
812: l_vac_people_group_id per_all_assignments_f.people_group_id%TYPE;
813: l_enabled_flag pay_people_groups.enabled_flag%TYPE;
814: --
815: cursor csr_valid_people_group is
816: select enabled_flag

Line 892: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'

888: if csr_valid_people_group%notfound then
889: close csr_valid_people_group;
890: hr_utility.set_message(801, 'HR_7385_ASG_INV_PEOPLE_GROUP');
891: hr_multi_message.add
892: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
893: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
894: );
895: --
896: else

Line 893: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

889: close csr_valid_people_group;
890: hr_utility.set_message(801, 'HR_7385_ASG_INV_PEOPLE_GROUP');
891: hr_multi_message.add
892: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
893: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
894: );
895: --
896: else
897: close csr_valid_people_group;

Line 906: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'

902: If l_enabled_flag <> 'Y' then
903: --
904: hr_utility.set_message(801, 'HR_51252_ASG_INV_PGP_ENBD_FLAG');
905: hr_multi_message.add
906: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
907: );
908: --
909: end if;
910: end if;

Line 924: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'

920: if csr_valid_id_flex_num%notfound then
921: close csr_valid_id_flex_num;
922: hr_utility.set_message(801, 'HR_7386_ASG_INV_PEOP_GRP_LINK');
923: hr_multi_message.add
924: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
925: );
926: --
927: else
928: close csr_valid_id_flex_num;

Line 944: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

940: -- |-------------------< chk_perf_review_period_freq >-----------------------|
941: -- ---------------------------------------------------------------------------
942: --
943: procedure chk_perf_review_period_freq
944: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
945: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
946: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
947: ,p_effective_date in date
948: ,p_validation_start_date in date

Line 945: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE

941: -- ---------------------------------------------------------------------------
942: --
943: procedure chk_perf_review_period_freq
944: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
945: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
946: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
947: ,p_effective_date in date
948: ,p_validation_start_date in date
949: ,p_validation_end_date in date

Line 946: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

942: --
943: procedure chk_perf_review_period_freq
944: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
945: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
946: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
947: ,p_effective_date in date
948: ,p_validation_start_date in date
949: ,p_validation_end_date in date
950: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 950: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

946: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
947: ,p_effective_date in date
948: ,p_validation_start_date in date
949: ,p_validation_end_date in date
950: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
951: )
952: is
953: --
954: l_proc varchar2(72) := g_package||'chk_perf_review_period_freq';

Line 1013: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'

1009: --
1010: hr_utility.set_message(801, 'HR_51178_ASG_INV_ASG_TYP_PRPF');
1011: hr_multi_message.add
1012: (p_associated_column1 =>
1013: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1014: );
1015: --
1016: end if;
1017: hr_utility.set_location(l_proc, 50);

Line 1037: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'

1033: --
1034: hr_utility.set_message(801, 'HR_51149_ASG_INV_PRP_FREQ');
1035: hr_multi_message.add
1036: (p_associated_column1 =>
1037: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1038: );
1039: --
1040: end if;
1041: hr_utility.set_location(l_proc, 60);

Line 1056: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1052: -- |-----------------------< chk_perf_review_period >------------------------|
1053: -- ---------------------------------------------------------------------------
1054: --
1055: procedure chk_perf_review_period
1056: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1057: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1058: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1059: ,p_effective_date in date
1060: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1057: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE

1053: -- ---------------------------------------------------------------------------
1054: --
1055: procedure chk_perf_review_period
1056: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1057: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1058: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1059: ,p_effective_date in date
1060: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1061: )

Line 1058: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1054: --
1055: procedure chk_perf_review_period
1056: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1057: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1058: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1059: ,p_effective_date in date
1060: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1061: )
1062: is

Line 1060: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1056: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1057: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1058: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1059: ,p_effective_date in date
1060: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1061: )
1062: is
1063: --
1064: l_proc varchar2(72) := g_package||'chk_perf_review_period';

Line 1121: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'

1117: exception
1118: when app_exception.application_exception then
1119: if hr_multi_message.exception_add
1120: (p_associated_column1 =>
1121: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1122: ) then
1123: hr_utility.set_location(' Leaving:'|| l_proc, 6);
1124: raise;
1125: end if;

Line 1134: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1130: -- |-------------------< chk_perf_rp_freq_perf_rp >--------------------------|
1131: -- ---------------------------------------------------------------------------
1132: --
1133: procedure chk_perf_rp_freq_perf_rp
1134: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1135: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
1136: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1137: ,p_effective_date in date
1138: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1135: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE

1131: -- ---------------------------------------------------------------------------
1132: --
1133: procedure chk_perf_rp_freq_perf_rp
1134: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1135: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
1136: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1137: ,p_effective_date in date
1138: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1139: )

Line 1136: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE

1132: --
1133: procedure chk_perf_rp_freq_perf_rp
1134: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1135: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
1136: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1137: ,p_effective_date in date
1138: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1139: )
1140: is

Line 1138: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1134: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1135: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
1136: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1137: ,p_effective_date in date
1138: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1139: )
1140: is
1141: --
1142: l_proc varchar2(72):= g_package||'chk_perf_rp_freq_perf_rp';

Line 1150: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'

1146: hr_utility.set_location('Entering:'|| l_proc, 1);
1147: --
1148: if hr_multi_message.no_exclusive_error
1149: (p_check_column1 =>
1150: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1151: ,p_check_column2 =>
1152: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1153: ) then
1154: --

Line 1152: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'

1148: if hr_multi_message.no_exclusive_error
1149: (p_check_column1 =>
1150: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1151: ,p_check_column2 =>
1152: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1153: ) then
1154: --
1155: -- Check mandatory parameters have been set
1156: --

Line 1213: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'

1209: --
1210: exception
1211: when app_exception.application_exception then
1212: if hr_multi_message.exception_add
1213: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1214: ,p_associated_column2 =>
1215: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1216: ) then
1217: hr_utility.set_location(' Leaving:'|| l_proc, 5);

Line 1215: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'

1211: when app_exception.application_exception then
1212: if hr_multi_message.exception_add
1213: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1214: ,p_associated_column2 =>
1215: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1216: ) then
1217: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1218: raise;
1219: end if;

Line 1228: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1224: -- |---------------------< chk_period_of_service_id >------------------------|
1225: -- ---------------------------------------------------------------------------
1226: --
1227: procedure chk_period_of_service_id
1228: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1229: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1230: ,p_person_id in per_all_assignments_f.person_id%TYPE
1231: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1232: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE

Line 1229: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1225: -- ---------------------------------------------------------------------------
1226: --
1227: procedure chk_period_of_service_id
1228: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1229: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1230: ,p_person_id in per_all_assignments_f.person_id%TYPE
1231: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1232: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
1233: ,p_validation_start_date in date

Line 1230: ,p_person_id in per_all_assignments_f.person_id%TYPE

1226: --
1227: procedure chk_period_of_service_id
1228: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1229: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1230: ,p_person_id in per_all_assignments_f.person_id%TYPE
1231: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1232: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
1233: ,p_validation_start_date in date
1234: ,p_validation_end_date in date

Line 1231: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1227: procedure chk_period_of_service_id
1228: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1229: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1230: ,p_person_id in per_all_assignments_f.person_id%TYPE
1231: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1232: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
1233: ,p_validation_start_date in date
1234: ,p_validation_end_date in date
1235: ,p_effective_date in date

Line 1232: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE

1228: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1229: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1230: ,p_person_id in per_all_assignments_f.person_id%TYPE
1231: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1232: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
1233: ,p_validation_start_date in date
1234: ,p_validation_end_date in date
1235: ,p_effective_date in date
1236: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1236: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1232: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
1233: ,p_validation_start_date in date
1234: ,p_validation_end_date in date
1235: ,p_effective_date in date
1236: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1237: )
1238: is
1239: --
1240: l_api_updating boolean;

Line 1244: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

1240: l_api_updating boolean;
1241: l_exists varchar2(1);
1242: l_proc varchar2(72):= g_package||'chk_period_of_service_id';
1243: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1244: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1245: --
1246: cursor csr_valid_pds is
1247: select business_group_id, actual_termination_date
1248: from per_periods_of_service

Line 1308: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'

1304: If p_period_of_service_id is not null then
1305: --
1306: hr_utility.set_message(801, 'HR_51203_ASG_INV_ASG_TYP_PDS');
1307: hr_multi_message.add
1308: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1309: );
1310: --
1311: end if;
1312: hr_utility.set_location(l_proc, 50);

Line 1335: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'

1331: if csr_valid_pds%notfound then
1332: close csr_valid_pds;
1333: hr_utility.set_message(801, 'HR_7391_ASG_INV_PERIOD_OF_SERV');
1334: hr_multi_message.add
1335: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1336: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1337: );
1338: --
1339: else

Line 1336: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

1332: close csr_valid_pds;
1333: hr_utility.set_message(801, 'HR_7391_ASG_INV_PERIOD_OF_SERV');
1334: hr_multi_message.add
1335: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1336: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1337: );
1338: --
1339: else
1340: close csr_valid_pds;

Line 1351: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'

1347: If p_business_group_id <> l_business_group_id then
1348: --
1349: hr_utility.set_message(801, 'HR_51320_ASG_INV_PDS_BG');
1350: hr_multi_message.add
1351: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1352: );
1353: --
1354: end if;
1355: hr_utility.set_location(l_proc, 80);

Line 1364: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'

1360: If p_validation_end_date > nvl(l_actual_termination_date, hr_api.g_eot) then
1361: --
1362: hr_utility.set_message(801, 'HR_6434_EMP_ASS_PER_CLOSED');
1363: hr_multi_message.add
1364: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1365: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1366: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
1367: );
1368: --

Line 1365: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

1361: --
1362: hr_utility.set_message(801, 'HR_6434_EMP_ASS_PER_CLOSED');
1363: hr_multi_message.add
1364: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1365: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1366: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
1367: );
1368: --
1369: end if;

Line 1366: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'

1362: hr_utility.set_message(801, 'HR_6434_EMP_ASS_PER_CLOSED');
1363: hr_multi_message.add
1364: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1365: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1366: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
1367: );
1368: --
1369: end if;
1370: hr_utility.set_location(l_proc, 90);

Line 1383: (p_person_id in per_all_assignments_f.person_id%TYPE

1379: -- |--------------------------< chk_person_id >------------------------------|
1380: -- ---------------------------------------------------------------------------
1381: --
1382: procedure chk_person_id
1383: (p_person_id in per_all_assignments_f.person_id%TYPE
1384: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1385: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
1386: )
1387: is

Line 1384: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1380: -- ---------------------------------------------------------------------------
1381: --
1382: procedure chk_person_id
1383: (p_person_id in per_all_assignments_f.person_id%TYPE
1384: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1385: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
1386: )
1387: is
1388: --

Line 1385: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE

1381: --
1382: procedure chk_person_id
1383: (p_person_id in per_all_assignments_f.person_id%TYPE
1384: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1385: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
1386: )
1387: is
1388: --
1389: l_exists varchar2(1);

Line 1430: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'

1426: hr_utility.set_location(' Leaving:'|| l_proc, 3);
1427: exception
1428: when app_exception.application_exception then
1429: if hr_multi_message.exception_add
1430: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
1431: ) then
1432: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1433: raise;
1434: end if;

Line 1443: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1439: -- |---------------------< chk_person_referred_by_id >-----------------------|
1440: -- ---------------------------------------------------------------------------
1441: --
1442: procedure chk_person_referred_by_id
1443: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1444: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1445: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1446: ,p_person_id in per_all_assignments_f.person_id%TYPE
1447: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE

Line 1444: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1440: -- ---------------------------------------------------------------------------
1441: --
1442: procedure chk_person_referred_by_id
1443: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1444: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1445: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1446: ,p_person_id in per_all_assignments_f.person_id%TYPE
1447: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
1448: ,p_effective_date in date

Line 1445: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1441: --
1442: procedure chk_person_referred_by_id
1443: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1444: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1445: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1446: ,p_person_id in per_all_assignments_f.person_id%TYPE
1447: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
1448: ,p_effective_date in date
1449: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1446: ,p_person_id in per_all_assignments_f.person_id%TYPE

1442: procedure chk_person_referred_by_id
1443: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1444: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1445: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1446: ,p_person_id in per_all_assignments_f.person_id%TYPE
1447: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
1448: ,p_effective_date in date
1449: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1450: ,p_validation_start_date in date

Line 1447: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE

1443: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1444: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1445: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1446: ,p_person_id in per_all_assignments_f.person_id%TYPE
1447: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
1448: ,p_effective_date in date
1449: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1450: ,p_validation_start_date in date
1451: ,p_validation_end_date in date

Line 1449: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1445: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1446: ,p_person_id in per_all_assignments_f.person_id%TYPE
1447: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
1448: ,p_effective_date in date
1449: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1450: ,p_validation_start_date in date
1451: ,p_validation_end_date in date
1452: )
1453: is

Line 1458: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

1454: --
1455: l_proc varchar2(72) := g_package||'chk_person_referred_by_id';
1456: l_api_updating boolean;
1457: l_exists varchar2(1);
1458: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1459: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
1460: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
1461: --
1462: cursor csr_val_prb_id is

Line 1521: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'

1517: if p_assignment_type in ('E','B','C')then
1518: --
1519: hr_utility.set_message(801, 'HR_51224_ASG_INV_ASG_TYP_PRB');
1520: hr_multi_message.add
1521: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1522: );
1523: --
1524: end if;
1525: hr_utility.set_location(l_proc, 50);

Line 1534: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'

1530: If p_person_referred_by_id = p_person_id then
1531: --
1532: hr_utility.set_message(801, 'HR_51304_ASG_APL_EQUAL_PRB');
1533: hr_multi_message.add
1534: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1535: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
1536: );
1537: --
1538: end if;

Line 1535: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'

1531: --
1532: hr_utility.set_message(801, 'HR_51304_ASG_APL_EQUAL_PRB');
1533: hr_multi_message.add
1534: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1535: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
1536: );
1537: --
1538: end if;
1539: hr_utility.set_location(l_proc, 60);

Line 1559: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

1555: then
1556: --
1557: hr_utility.set_message(801, 'HR_51302_ASG_INV_PER_REF_BY');
1558: hr_multi_message.add
1559: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1560: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1561: );
1562: --
1563: end if;

Line 1560: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'

1556: --
1557: hr_utility.set_message(801, 'HR_51302_ASG_INV_PER_REF_BY');
1558: hr_multi_message.add
1559: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1560: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1561: );
1562: --
1563: end if;
1564: --

Line 1579: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'

1575: then
1576: --
1577: hr_utility.set_message(801, 'HR_51303_ASG_INV_PER_REF_BY_BG');
1578: hr_multi_message.add
1579: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1580: );
1581: --
1582: end if;
1583: hr_utility.set_location(l_proc, 80);

Line 1596: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID');

1592: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
1593: nvl(l_current_npw_flag, 'N') = 'Y') ) then
1594: hr_utility.set_message(801, 'HR_51305_ASG_PER_RB_NOT_EMP');
1595: hr_multi_message.add
1596: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID');
1597: --
1598: end if;
1599: hr_utility.set_location(l_proc, 90);
1600: --

Line 1613: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1609: -- |------------------------< chk_position_id >------------------------------|
1610: -- ---------------------------------------------------------------------------
1611: --
1612: procedure chk_position_id
1613: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1614: ,p_position_id in per_all_assignments_f.position_id%TYPE
1615: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1616: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1617: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

Line 1614: ,p_position_id in per_all_assignments_f.position_id%TYPE

1610: -- ---------------------------------------------------------------------------
1611: --
1612: procedure chk_position_id
1613: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1614: ,p_position_id in per_all_assignments_f.position_id%TYPE
1615: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1616: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1617: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1618: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 1615: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1611: --
1612: procedure chk_position_id
1613: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1614: ,p_position_id in per_all_assignments_f.position_id%TYPE
1615: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1616: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1617: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1618: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1619: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 1616: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1612: procedure chk_position_id
1613: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1614: ,p_position_id in per_all_assignments_f.position_id%TYPE
1615: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1616: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1617: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1618: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1619: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1620: ,p_effective_date in date

Line 1617: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

1613: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1614: ,p_position_id in per_all_assignments_f.position_id%TYPE
1615: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1616: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1617: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1618: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1619: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1620: ,p_effective_date in date
1621: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1618: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

1614: ,p_position_id in per_all_assignments_f.position_id%TYPE
1615: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1616: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1617: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1618: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1619: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1620: ,p_effective_date in date
1621: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1622: )

Line 1619: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

1615: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1616: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1617: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1618: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1619: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1620: ,p_effective_date in date
1621: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1622: )
1623: is

Line 1621: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1617: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1618: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1619: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1620: ,p_effective_date in date
1621: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1622: )
1623: is
1624: --
1625: l_proc varchar2(72) := g_package||'chk_position_id';

Line 1628: l_position_id per_all_assignments_f.position_id%TYPE;

1624: --
1625: l_proc varchar2(72) := g_package||'chk_position_id';
1626: l_exists varchar2(1);
1627: l_api_updating boolean;
1628: l_position_id per_all_assignments_f.position_id%TYPE;
1629: l_pos_bus_group_id per_all_assignments_f.business_group_id%TYPE;
1630: l_vac_position_id per_all_assignments_f.position_id%TYPE;
1631: --
1632: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) date tracked position requirement

Line 1629: l_pos_bus_group_id per_all_assignments_f.business_group_id%TYPE;

1625: l_proc varchar2(72) := g_package||'chk_position_id';
1626: l_exists varchar2(1);
1627: l_api_updating boolean;
1628: l_position_id per_all_assignments_f.position_id%TYPE;
1629: l_pos_bus_group_id per_all_assignments_f.business_group_id%TYPE;
1630: l_vac_position_id per_all_assignments_f.position_id%TYPE;
1631: --
1632: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) date tracked position requirement
1633:

Line 1630: l_vac_position_id per_all_assignments_f.position_id%TYPE;

1626: l_exists varchar2(1);
1627: l_api_updating boolean;
1628: l_position_id per_all_assignments_f.position_id%TYPE;
1629: l_pos_bus_group_id per_all_assignments_f.business_group_id%TYPE;
1630: l_vac_position_id per_all_assignments_f.position_id%TYPE;
1631: --
1632: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) date tracked position requirement
1633:
1634: cursor csr_valid_pos is

Line 1709: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'

1705: if csr_valid_pos%notfound then
1706: close csr_valid_pos;
1707: hr_utility.set_message(801, 'HR_51000_ASG_INVALID_POS');
1708: hr_multi_message.add
1709: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1710: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1711: );
1712: else
1713: close csr_valid_pos;

Line 1710: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

1706: close csr_valid_pos;
1707: hr_utility.set_message(801, 'HR_51000_ASG_INVALID_POS');
1708: hr_multi_message.add
1709: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1710: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1711: );
1712: else
1713: close csr_valid_pos;
1714: end if;

Line 1724: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'

1720: if l_pos_bus_group_id <> p_business_group_id then
1721: --
1722: hr_utility.set_message(801, 'HR_51009_ASG_INVALID_BG_POS');
1723: hr_multi_message.add
1724: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1725: );
1726: --
1727: end if;
1728: hr_utility.set_location(l_proc, 50);

Line 1743: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1739: -------------------< chk_position_id_grade_id >-------------------------------
1740: ------------------------------------------------------------------------------
1741: --
1742: procedure chk_position_id_grade_id
1743: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1744: ,p_position_id in per_all_assignments_f.position_id%TYPE
1745: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1746: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1747: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 1744: ,p_position_id in per_all_assignments_f.position_id%TYPE

1740: ------------------------------------------------------------------------------
1741: --
1742: procedure chk_position_id_grade_id
1743: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1744: ,p_position_id in per_all_assignments_f.position_id%TYPE
1745: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1746: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1747: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1748: ,p_effective_date in date

Line 1745: ,p_grade_id in per_all_assignments_f.grade_id%TYPE

1741: --
1742: procedure chk_position_id_grade_id
1743: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1744: ,p_position_id in per_all_assignments_f.position_id%TYPE
1745: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1746: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1747: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1748: ,p_effective_date in date
1749: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1746: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

1742: procedure chk_position_id_grade_id
1743: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1744: ,p_position_id in per_all_assignments_f.position_id%TYPE
1745: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1746: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1747: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1748: ,p_effective_date in date
1749: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1750: ,p_inv_pos_grade_warning out nocopy boolean

Line 1747: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

1743: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1744: ,p_position_id in per_all_assignments_f.position_id%TYPE
1745: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1746: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1747: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1748: ,p_effective_date in date
1749: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1750: ,p_inv_pos_grade_warning out nocopy boolean
1751: )

Line 1749: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1745: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1746: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1747: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1748: ,p_effective_date in date
1749: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1750: ,p_inv_pos_grade_warning out nocopy boolean
1751: )
1752: as
1753: l_proc varchar2(72) := g_package||'chk_position_id_grade_id';

Line 1787: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'

1783: --
1784: hr_utility.set_location('Entering:'|| l_proc, 1);
1785: --
1786: if hr_multi_message.no_exclusive_error
1787: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1788: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
1789: ) then
1790: --
1791: -- Check mandatory parameters have been set

Line 1788: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'

1784: hr_utility.set_location('Entering:'|| l_proc, 1);
1785: --
1786: if hr_multi_message.no_exclusive_error
1787: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1788: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
1789: ) then
1790: --
1791: -- Check mandatory parameters have been set
1792: --

Line 1876: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1872: --------------------------< chk_position_id_org_id >--------------------------
1873: ------------------------------------------------------------------------------
1874: --
1875: procedure chk_position_id_org_id
1876: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1877: ,p_position_id in per_all_assignments_f.position_id%TYPE
1878: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1879: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1880: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 1877: ,p_position_id in per_all_assignments_f.position_id%TYPE

1873: ------------------------------------------------------------------------------
1874: --
1875: procedure chk_position_id_org_id
1876: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1877: ,p_position_id in per_all_assignments_f.position_id%TYPE
1878: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1879: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1880: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1881: ,p_effective_date in date

Line 1878: ,p_organization_id in per_all_assignments_f.organization_id%TYPE

1874: --
1875: procedure chk_position_id_org_id
1876: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1877: ,p_position_id in per_all_assignments_f.position_id%TYPE
1878: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1879: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1880: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1881: ,p_effective_date in date
1882: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1879: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

1875: procedure chk_position_id_org_id
1876: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1877: ,p_position_id in per_all_assignments_f.position_id%TYPE
1878: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1879: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1880: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1881: ,p_effective_date in date
1882: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1883: )

Line 1880: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

1876: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1877: ,p_position_id in per_all_assignments_f.position_id%TYPE
1878: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1879: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1880: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1881: ,p_effective_date in date
1882: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1883: )
1884: as

Line 1882: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1878: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1879: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1880: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1881: ,p_effective_date in date
1882: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1883: )
1884: as
1885: l_proc varchar2(72) := g_package||'chk_position_id_org_id';
1886: l_exists varchar2(1);

Line 1912: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'

1908: --
1909: hr_utility.set_location('Entering:'|| l_proc, 1);
1910: --
1911: if hr_multi_message.no_exclusive_error
1912: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1913: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
1914: ) then
1915: --
1916: -- Check mandatory parameters have been set

Line 1913: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'

1909: hr_utility.set_location('Entering:'|| l_proc, 1);
1910: --
1911: if hr_multi_message.no_exclusive_error
1912: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1913: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
1914: ) then
1915: --
1916: -- Check mandatory parameters have been set
1917: --

Line 1982: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'

1978: hr_utility.set_location('Leaving'||l_proc, 4);
1979: exception
1980: when app_exception.application_exception then
1981: if hr_multi_message.exception_add
1982: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1983: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
1984: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1985: ) then
1986: hr_utility.set_location(' Leaving:'|| l_proc, 5);

Line 1983: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'

1979: exception
1980: when app_exception.application_exception then
1981: if hr_multi_message.exception_add
1982: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1983: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
1984: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1985: ) then
1986: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1987: raise;

Line 1984: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

1980: when app_exception.application_exception then
1981: if hr_multi_message.exception_add
1982: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1983: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
1984: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1985: ) then
1986: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1987: raise;
1988: end if;

Line 1997: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1993: -------------------------< chk_position_id_job_id >---------------------------
1994: ------------------------------------------------------------------------------
1995: --
1996: procedure chk_position_id_job_id
1997: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1998: ,p_position_id in per_all_assignments_f.position_id%TYPE
1999: ,p_job_id in per_all_assignments_f.job_id%TYPE
2000: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2001: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 1998: ,p_position_id in per_all_assignments_f.position_id%TYPE

1994: ------------------------------------------------------------------------------
1995: --
1996: procedure chk_position_id_job_id
1997: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1998: ,p_position_id in per_all_assignments_f.position_id%TYPE
1999: ,p_job_id in per_all_assignments_f.job_id%TYPE
2000: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2001: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2002: ,p_effective_date in date

Line 1999: ,p_job_id in per_all_assignments_f.job_id%TYPE

1995: --
1996: procedure chk_position_id_job_id
1997: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1998: ,p_position_id in per_all_assignments_f.position_id%TYPE
1999: ,p_job_id in per_all_assignments_f.job_id%TYPE
2000: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2001: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2002: ,p_effective_date in date
2003: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 2000: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

1996: procedure chk_position_id_job_id
1997: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1998: ,p_position_id in per_all_assignments_f.position_id%TYPE
1999: ,p_job_id in per_all_assignments_f.job_id%TYPE
2000: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2001: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2002: ,p_effective_date in date
2003: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2004: )

Line 2001: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

1997: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1998: ,p_position_id in per_all_assignments_f.position_id%TYPE
1999: ,p_job_id in per_all_assignments_f.job_id%TYPE
2000: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2001: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2002: ,p_effective_date in date
2003: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2004: )
2005: as

Line 2003: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1999: ,p_job_id in per_all_assignments_f.job_id%TYPE
2000: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2001: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2002: ,p_effective_date in date
2003: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2004: )
2005: as
2006: l_proc varchar2(72) := g_package||'chk_position_id_job_id';
2007: l_exists varchar2(1);

Line 2031: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'

2027: begin
2028: hr_utility.set_location('Entering:'|| l_proc, 10);
2029: --
2030: if hr_multi_message.no_exclusive_error
2031: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2032: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2033: ) then
2034: --
2035: -- Check mandatory parameters have been set

Line 2032: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'

2028: hr_utility.set_location('Entering:'|| l_proc, 10);
2029: --
2030: if hr_multi_message.no_exclusive_error
2031: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2032: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2033: ) then
2034: --
2035: -- Check mandatory parameters have been set
2036: --

Line 2090: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'

2086: if csr_valid_pos_job_comb%notfound then
2087: close csr_valid_pos_job_comb;
2088: hr_utility.set_message(801, 'HR_51056_ASG_INV_POS_JOB_COMB');
2089: hr_multi_message.add
2090: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2091: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2092: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2093: );
2094: else

Line 2091: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

2087: close csr_valid_pos_job_comb;
2088: hr_utility.set_message(801, 'HR_51056_ASG_INV_POS_JOB_COMB');
2089: hr_multi_message.add
2090: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2091: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2092: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2093: );
2094: else
2095: close csr_valid_pos_job_comb;

Line 2092: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'

2088: hr_utility.set_message(801, 'HR_51056_ASG_INV_POS_JOB_COMB');
2089: hr_multi_message.add
2090: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2091: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2092: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2093: );
2094: else
2095: close csr_valid_pos_job_comb;
2096: end if;

Line 2104: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'

2100: -- Position is not null but job is null
2101: --
2102: hr_utility.set_message(801, 'HR_51057_ASG_JOB_NULL_VALUE');
2103: hr_multi_message.add
2104: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2105: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2106: );
2107: --
2108: end if;

Line 2105: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'

2101: --
2102: hr_utility.set_message(801, 'HR_51057_ASG_JOB_NULL_VALUE');
2103: hr_multi_message.add
2104: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2105: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2106: );
2107: --
2108: end if;
2109: --

Line 2121: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2117: -- |-------------------------< chk_primary_flag >----------------------------|
2118: -- ---------------------------------------------------------------------------
2119: --
2120: procedure chk_primary_flag
2121: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2122: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
2123: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2124: ,p_person_id in per_all_assignments_f.person_id%TYPE
2125: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE

Line 2122: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE

2118: -- ---------------------------------------------------------------------------
2119: --
2120: procedure chk_primary_flag
2121: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2122: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
2123: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2124: ,p_person_id in per_all_assignments_f.person_id%TYPE
2125: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
2126: ,p_pop_date_start in DATE

Line 2123: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

2119: --
2120: procedure chk_primary_flag
2121: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2122: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
2123: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2124: ,p_person_id in per_all_assignments_f.person_id%TYPE
2125: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
2126: ,p_pop_date_start in DATE
2127: ,p_effective_date in date

Line 2124: ,p_person_id in per_all_assignments_f.person_id%TYPE

2120: procedure chk_primary_flag
2121: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2122: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
2123: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2124: ,p_person_id in per_all_assignments_f.person_id%TYPE
2125: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
2126: ,p_pop_date_start in DATE
2127: ,p_effective_date in date
2128: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 2125: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE

2121: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2122: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
2123: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2124: ,p_person_id in per_all_assignments_f.person_id%TYPE
2125: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
2126: ,p_pop_date_start in DATE
2127: ,p_effective_date in date
2128: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2129: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 2128: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2124: ,p_person_id in per_all_assignments_f.person_id%TYPE
2125: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
2126: ,p_pop_date_start in DATE
2127: ,p_effective_date in date
2128: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2129: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2130: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2131: ) is
2132: --

Line 2129: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

2125: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
2126: ,p_pop_date_start in DATE
2127: ,p_effective_date in date
2128: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2129: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2130: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2131: ) is
2132: --
2133: l_exists varchar2(1);

Line 2130: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

2126: ,p_pop_date_start in DATE
2127: ,p_effective_date in date
2128: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2129: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2130: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2131: ) is
2132: --
2133: l_exists varchar2(1);
2134: l_proc varchar2(72) := g_package||'chk_primary_flag';

Line 2139: from per_all_assignments_f

2135: l_api_updating boolean;
2136: --
2137: cursor csr_asg_exists is
2138: select null
2139: from per_all_assignments_f
2140: where person_id = p_person_id
2141: and period_of_service_id = p_period_of_service_id
2142: and primary_flag = 'Y';
2143: --

Line 2146: from per_all_assignments_f

2142: and primary_flag = 'Y';
2143: --
2144: cursor csr_cwk_asg_exists is
2145: select null
2146: from per_all_assignments_f
2147: where person_id = p_person_id
2148: and period_of_placement_date_start = p_pop_date_start
2149: and primary_flag = 'Y';
2150: --

Line 2200: from per_all_assignments_f pas

2196: select null
2197: from sys.dual
2198: where exists
2199: (select null
2200: from per_all_assignments_f pas
2201: where pas.effective_start_date <= p_validation_start_date
2202: and pas.person_id = p_person_id
2203: and pas.period_of_service_id = p_period_of_service_id
2204: --

Line 2211: from per_all_assignments_f pas1

2207: --and pas.primary_flag = 'Y');
2208: and pas.primary_flag = 'Y')
2209: or (csr_ins_non_prim.p_per_system_status = 'TERM_ASSIGN' and exists
2210: (select null
2211: from per_all_assignments_f pas1
2212: where pas1.effective_start_date <= p_validation_start_date
2213: and pas1.person_id = p_person_id
2214: and pas1.period_of_service_id <> p_period_of_service_id
2215: and pas1.primary_flag = 'Y'

Line 2227: from per_all_assignments_f pas

2223: select null
2224: from sys.dual
2225: where exists
2226: (select null
2227: from per_all_assignments_f pas
2228: where pas.effective_start_date <= p_validation_start_date
2229: and pas.person_id = p_person_id
2230: and pas.period_of_placement_date_start = p_pop_date_start
2231: and pas.primary_flag = 'Y');

Line 2309: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG');

2305: --
2306: hr_utility.set_message(801, 'HR_51198_ASG_INV_APL_ASG_PF');
2307: --
2308: hr_multi_message.add
2309: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG');
2310: --
2311: end if;
2312: --
2313: hr_utility.set_location(l_proc, 50);

Line 2322: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');

2318: --
2319: hr_utility.set_message(801, 'HR_51323_ASG_INV_PRIM_ASG_EED');
2320: --
2321: hr_multi_message.add
2322: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2323: --
2324: end if;
2325: --
2326: hr_utility.set_location(l_proc, 60);

Line 2329: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'

2325: --
2326: hr_utility.set_location(l_proc, 60);
2327: --
2328: if hr_multi_message.no_exclusive_error
2329: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2330: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
2331: --
2332: hr_utility.set_location(l_proc, 70);
2333: --

Line 2330: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then

2326: hr_utility.set_location(l_proc, 60);
2327: --
2328: if hr_multi_message.no_exclusive_error
2329: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2330: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
2331: --
2332: hr_utility.set_location(l_proc, 70);
2333: --
2334: if p_assignment_type = 'C' then

Line 2348: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'

2344: --
2345: hr_utility.set_message(801, 'HR_7435_ASG_PRIM_ASS_EXISTS');
2346: --
2347: hr_multi_message.add
2348: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2349: ,p_associated_column2 =>
2350: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START');
2351: --
2352: else

Line 2350: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START');

2346: --
2347: hr_multi_message.add
2348: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2349: ,p_associated_column2 =>
2350: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START');
2351: --
2352: else
2353: --
2354: close csr_cwk_asg_exists;

Line 2376: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'

2372: --
2373: hr_utility.set_message(801, 'HR_7435_ASG_PRIM_ASS_EXISTS');
2374: --
2375: hr_multi_message.add
2376: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2377: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID');
2378: --
2379: else
2380: --

Line 2377: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID');

2373: hr_utility.set_message(801, 'HR_7435_ASG_PRIM_ASS_EXISTS');
2374: --
2375: hr_multi_message.add
2376: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2377: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID');
2378: --
2379: else
2380: --
2381: close csr_asg_exists;

Line 2408: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'

2404: --
2405: hr_utility.set_location(l_proc, 140);
2406: --
2407: if hr_multi_message.no_exclusive_error
2408: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2409: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
2410: --
2411: hr_utility.set_location(l_proc, 150);
2412: --

Line 2409: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then

2405: hr_utility.set_location(l_proc, 140);
2406: --
2407: if hr_multi_message.no_exclusive_error
2408: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2409: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
2410: --
2411: hr_utility.set_location(l_proc, 150);
2412: --
2413: -- Check that the primary cwk assignment exists during

Line 2430: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'

2426: --
2427: hr_utility.set_message(801, 'HR_7436_ASG_NO_PRIM_ASS');
2428: --
2429: hr_multi_message.add
2430: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2431: ,p_associated_column2 =>
2432: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START'
2433: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2434: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');

Line 2432: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START'

2428: --
2429: hr_multi_message.add
2430: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2431: ,p_associated_column2 =>
2432: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START'
2433: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2434: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2435: --
2436: else

Line 2433: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

2429: hr_multi_message.add
2430: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2431: ,p_associated_column2 =>
2432: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START'
2433: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2434: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2435: --
2436: else
2437: --

Line 2434: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');

2430: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2431: ,p_associated_column2 =>
2432: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START'
2433: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2434: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2435: --
2436: else
2437: --
2438: close csr_ins_non_cwk_prim;

Line 2485: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'

2481: --
2482: hr_utility.set_message(801, 'HR_7436_ASG_NO_PRIM_ASS');
2483: --
2484: hr_multi_message.add
2485: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2486: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2487: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2488: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2489: --

Line 2486: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'

2482: hr_utility.set_message(801, 'HR_7436_ASG_NO_PRIM_ASS');
2483: --
2484: hr_multi_message.add
2485: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2486: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2487: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2488: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2489: --
2490: else

Line 2487: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

2483: --
2484: hr_multi_message.add
2485: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2486: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2487: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2488: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2489: --
2490: else
2491: --

Line 2488: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');

2484: hr_multi_message.add
2485: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2486: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2487: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2488: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2489: --
2490: else
2491: --
2492: close csr_ins_non_prim;

Line 2518: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2514: -- ---------------------------------------------------------------------------
2515: -- |----------------------< chk_probation_period >---------------------------|
2516: -- ---------------------------------------------------------------------------
2517: procedure chk_probation_period
2518: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2519: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2520: ,p_effective_date in date
2521: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2522: )

Line 2519: ,p_probation_period in per_all_assignments_f.probation_period%TYPE

2515: -- |----------------------< chk_probation_period >---------------------------|
2516: -- ---------------------------------------------------------------------------
2517: procedure chk_probation_period
2518: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2519: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2520: ,p_effective_date in date
2521: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2522: )
2523: is

Line 2521: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2517: procedure chk_probation_period
2518: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2519: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2520: ,p_effective_date in date
2521: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2522: )
2523: is
2524: --
2525: l_proc varchar2(72) := g_package||'chk_probation_period';

Line 2576: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'

2572: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2573: exception
2574: when app_exception.application_exception then
2575: if hr_multi_message.exception_add
2576: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2577: ) then
2578: hr_utility.set_location(' Leaving:'|| l_proc, 70);
2579: raise;
2580: end if;

Line 2590: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2586: -- |------------------------< chk_probation_unit >---------------------------|
2587: -- ---------------------------------------------------------------------------
2588: --
2589: procedure chk_probation_unit
2590: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2591: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2592: ,p_effective_date in date
2593: ,p_validation_start_date in date
2594: ,p_validation_end_date in date

Line 2591: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE

2587: -- ---------------------------------------------------------------------------
2588: --
2589: procedure chk_probation_unit
2590: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2591: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2592: ,p_effective_date in date
2593: ,p_validation_start_date in date
2594: ,p_validation_end_date in date
2595: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 2595: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2591: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2592: ,p_effective_date in date
2593: ,p_validation_start_date in date
2594: ,p_validation_end_date in date
2595: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2596: )
2597: is
2598: --
2599: l_proc varchar2(72) := g_package||'chk_probation_unit';

Line 2676: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'

2672: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2673: exception
2674: when app_exception.application_exception then
2675: if hr_multi_message.exception_add
2676: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2677: ) then
2678: hr_utility.set_location(' Leaving:'|| l_proc, 70);
2679: raise;
2680: end if;

Line 2689: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2685: -- |-------------------< chk_prob_unit_prob_period >-------------------------|
2686: -- ---------------------------------------------------------------------------
2687: --
2688: procedure chk_prob_unit_prob_period
2689: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2690: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2691: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2692: ,p_effective_date in date
2693: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 2690: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE

2686: -- ---------------------------------------------------------------------------
2687: --
2688: procedure chk_prob_unit_prob_period
2689: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2690: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2691: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2692: ,p_effective_date in date
2693: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2694: )

Line 2691: ,p_probation_period in per_all_assignments_f.probation_period%TYPE

2687: --
2688: procedure chk_prob_unit_prob_period
2689: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2690: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2691: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2692: ,p_effective_date in date
2693: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2694: )
2695: is

Line 2693: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2689: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2690: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2691: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2692: ,p_effective_date in date
2693: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2694: )
2695: is
2696: --
2697: l_proc varchar2(72):= g_package||'chk_prob_unit_prob_period';

Line 2706: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'

2702: --
2703: -- Check mandatory parameters have been set
2704: --
2705: if hr_multi_message.no_exclusive_error
2706: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2707: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2708: ) then
2709: hr_api.mandatory_arg_error
2710: (p_api_name => l_proc

Line 2707: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'

2703: -- Check mandatory parameters have been set
2704: --
2705: if hr_multi_message.no_exclusive_error
2706: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2707: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2708: ) then
2709: hr_api.mandatory_arg_error
2710: (p_api_name => l_proc
2711: ,p_argument => 'effective_date'

Line 2759: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'

2755: hr_utility.set_location(' Leaving:'|| l_proc, 4);
2756: exception
2757: when app_exception.application_exception then
2758: if hr_multi_message.exception_add
2759: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2760: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2761: ) then
2762: hr_utility.set_location(' Leaving:'|| l_proc, 5);
2763: raise;

Line 2760: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'

2756: exception
2757: when app_exception.application_exception then
2758: if hr_multi_message.exception_add
2759: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2760: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2761: ) then
2762: hr_utility.set_location(' Leaving:'|| l_proc, 5);
2763: raise;
2764: end if;

Line 2774: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2770: -- |------------------------< chk_recruiter_id >-----------------------------|
2771: -- ---------------------------------------------------------------------------
2772: --
2773: procedure chk_recruiter_id
2774: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2775: ,p_person_id in per_all_assignments_f.person_id%TYPE
2776: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2777: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2778: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE

Line 2775: ,p_person_id in per_all_assignments_f.person_id%TYPE

2771: -- ---------------------------------------------------------------------------
2772: --
2773: procedure chk_recruiter_id
2774: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2775: ,p_person_id in per_all_assignments_f.person_id%TYPE
2776: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2777: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2778: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
2779: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

Line 2776: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

2772: --
2773: procedure chk_recruiter_id
2774: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2775: ,p_person_id in per_all_assignments_f.person_id%TYPE
2776: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2777: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2778: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
2779: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
2780: ,p_effective_date in date

Line 2777: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

2773: procedure chk_recruiter_id
2774: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2775: ,p_person_id in per_all_assignments_f.person_id%TYPE
2776: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2777: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2778: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
2779: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
2780: ,p_effective_date in date
2781: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 2778: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE

2774: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2775: ,p_person_id in per_all_assignments_f.person_id%TYPE
2776: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2777: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2778: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
2779: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
2780: ,p_effective_date in date
2781: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2782: ,p_validation_start_date in date

Line 2779: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

2775: ,p_person_id in per_all_assignments_f.person_id%TYPE
2776: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2777: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2778: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
2779: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
2780: ,p_effective_date in date
2781: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2782: ,p_validation_start_date in date
2783: ,p_validation_end_date in date

Line 2781: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2777: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2778: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
2779: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
2780: ,p_effective_date in date
2781: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2782: ,p_validation_start_date in date
2783: ,p_validation_end_date in date
2784: )
2785: is

Line 2789: l_vac_recruiter_id per_all_assignments_f.recruiter_id%TYPE;

2785: is
2786: --
2787: l_proc varchar2(72) := g_package||'chk_recruiter_id';
2788: l_api_updating boolean;
2789: l_vac_recruiter_id per_all_assignments_f.recruiter_id%TYPE;
2790: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2791: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
2792: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
2793: --

Line 2790: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

2786: --
2787: l_proc varchar2(72) := g_package||'chk_recruiter_id';
2788: l_api_updating boolean;
2789: l_vac_recruiter_id per_all_assignments_f.recruiter_id%TYPE;
2790: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2791: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
2792: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
2793: --
2794: cursor csr_val_recruiter is

Line 2857: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'

2853: then
2854: --
2855: hr_utility.set_message(801, 'HR_51216_ASG_INV_ASG_TYP_REC');
2856: hr_multi_message.add
2857: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2858: );
2859: --
2860: end if;
2861: hr_utility.set_location(l_proc, 70);

Line 2870: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'

2866: If p_recruiter_id = p_person_id then
2867: --
2868: hr_utility.set_message(801, 'HR_51289_ASG_APL_EQUAL_RECRUIT');
2869: hr_multi_message.add
2870: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2871: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2872: );
2873: --
2874: end if;

Line 2871: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'

2867: --
2868: hr_utility.set_message(801, 'HR_51289_ASG_APL_EQUAL_RECRUIT');
2869: hr_multi_message.add
2870: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2871: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2872: );
2873: --
2874: end if;
2875: hr_utility.set_location(l_proc, 80);

Line 2887: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

2883: if csr_val_recruiter%notfound then
2884: close csr_val_recruiter;
2885: hr_utility.set_message(801, 'HR_51280_ASG_INV_RECRUIT_ID');
2886: hr_multi_message.add
2887: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2888: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2889: );
2890: --
2891: else

Line 2888: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'

2884: close csr_val_recruiter;
2885: hr_utility.set_message(801, 'HR_51280_ASG_INV_RECRUIT_ID');
2886: hr_multi_message.add
2887: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2888: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2889: );
2890: --
2891: else
2892: close csr_val_recruiter;

Line 2906: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID');

2902: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
2903: nvl(l_current_npw_flag, 'N') = 'Y') ) then
2904: hr_utility.set_message(801, 'HR_51290_ASG_RECRUIT_NOT_EMP');
2905: hr_multi_message.add
2906: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID');
2907: end if;
2908: hr_utility.set_location(l_proc, 100);
2909: --
2910: -- Check that the recruiter is in the same business group

Line 2919: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'

2915: then
2916: --
2917: hr_utility.set_message(801, 'HR_51284_ASG_INV_RECRUIT_BG');
2918: hr_multi_message.add
2919: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2920: );
2921: --
2922: end if;
2923: hr_utility.set_location(l_proc, 110);

Line 2937: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2933: -- |--------------------< chk_recruitment_activity_id >----------------------|
2934: -- ---------------------------------------------------------------------------
2935: --
2936: procedure chk_recruitment_activity_id
2937: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2938: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2939: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2940: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
2941: ,p_effective_date in date

Line 2938: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

2934: -- ---------------------------------------------------------------------------
2935: --
2936: procedure chk_recruitment_activity_id
2937: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2938: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2939: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2940: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
2941: ,p_effective_date in date
2942: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 2939: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

2935: --
2936: procedure chk_recruitment_activity_id
2937: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2938: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2939: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2940: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
2941: ,p_effective_date in date
2942: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2943: ,p_validation_start_date in date

Line 2940: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE

2936: procedure chk_recruitment_activity_id
2937: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2938: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2939: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2940: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
2941: ,p_effective_date in date
2942: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2943: ,p_validation_start_date in date
2944: ,p_validation_end_date in date

Line 2942: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2938: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2939: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2940: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
2941: ,p_effective_date in date
2942: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2943: ,p_validation_start_date in date
2944: ,p_validation_end_date in date
2945: )
2946: is

Line 2951: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

2947: --
2948: l_proc varchar2(72) := g_package||'chk_recruitment_activity_id';
2949: l_api_updating boolean;
2950: l_exists varchar2(1);
2951: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2952: --
2953: cursor csr_val_rec_act_id is
2954: select business_group_id
2955: from per_recruitment_activities

Line 3013: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'

3009: if p_assignment_type in ('E','C','B') then
3010: --
3011: hr_utility.set_message(801, 'HR_51223_ASG_INV_ASG_TYP_RCAT');
3012: hr_multi_message.add
3013: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3014: );
3015: --
3016: end if;
3017: hr_utility.set_location(l_proc, 50);

Line 3034: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'

3030: if p_assignment_type <> 'O'
3031: then
3032: hr_utility.set_message(801, 'HR_51306_ASG_INV_REC_ACT');
3033: hr_multi_message.add
3034: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3035: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3036: );
3037: --
3038: end if;

Line 3035: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

3031: then
3032: hr_utility.set_message(801, 'HR_51306_ASG_INV_REC_ACT');
3033: hr_multi_message.add
3034: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3035: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3036: );
3037: --
3038: end if;
3039: --

Line 3053: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'

3049: If p_business_group_id <> l_business_group_id then
3050: --
3051: hr_utility.set_message(801, 'HR_51307_ASG_INV_REC_ACT_BG');
3052: hr_multi_message.add
3053: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3054: );
3055: --
3056: end if;
3057: hr_utility.set_location(l_proc, 70);

Line 3104: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3100: -- If child rows exist in any of the tables listed above, an application
3101: -- error is raised and processing is terminated.
3102: --
3103: procedure chk_ref_int_del
3104: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3105: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
3106: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
3107: ,p_datetrack_mode in varchar2
3108: )

Line 3105: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

3101: -- error is raised and processing is terminated.
3102: --
3103: procedure chk_ref_int_del
3104: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3105: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
3106: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
3107: ,p_datetrack_mode in varchar2
3108: )
3109: is

Line 3106: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

3102: --
3103: procedure chk_ref_int_del
3104: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3105: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
3106: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
3107: ,p_datetrack_mode in varchar2
3108: )
3109: is
3110: --

Line 3391: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3387: -- |---------------------< chk_sal_review_period_freq >----------------------|
3388: -- ---------------------------------------------------------------------------
3389: --
3390: procedure chk_sal_review_period_freq
3391: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3392: ,p_sal_review_period_frequency in
3393: per_all_assignments_f.sal_review_period_frequency%TYPE
3394: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3395: ,p_effective_date in date

Line 3393: per_all_assignments_f.sal_review_period_frequency%TYPE

3389: --
3390: procedure chk_sal_review_period_freq
3391: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3392: ,p_sal_review_period_frequency in
3393: per_all_assignments_f.sal_review_period_frequency%TYPE
3394: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3395: ,p_effective_date in date
3396: ,p_validation_start_date in date
3397: ,p_validation_end_date in date

Line 3394: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

3390: procedure chk_sal_review_period_freq
3391: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3392: ,p_sal_review_period_frequency in
3393: per_all_assignments_f.sal_review_period_frequency%TYPE
3394: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3395: ,p_effective_date in date
3396: ,p_validation_start_date in date
3397: ,p_validation_end_date in date
3398: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 3398: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

3394: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3395: ,p_effective_date in date
3396: ,p_validation_start_date in date
3397: ,p_validation_end_date in date
3398: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3399: )
3400: is
3401: --
3402: l_proc varchar2(72) := g_package||'chk_sal_review_period_freq';

Line 3461: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'

3457: --
3458: hr_utility.set_message(801, 'HR_51181_ASG_INV_ASG_TYP_SRPF');
3459: hr_multi_message.add
3460: (p_associated_column1 =>
3461: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3462: );
3463: --
3464: end if;
3465: hr_utility.set_location(l_proc, 50);

Line 3485: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'

3481: --
3482: hr_utility.set_message(801, 'HR_51164_ASG_INV_SRP_FREQ');
3483: hr_multi_message.add
3484: (p_associated_column1 =>
3485: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3486: );
3487: --
3488: end if;
3489: hr_utility.set_location(l_proc, 60);

Line 3503: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3499: -- |-----------------------< chk_sal_review_period >------------------------|
3500: -- ---------------------------------------------------------------------------
3501: --
3502: procedure chk_sal_review_period
3503: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3504: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3505: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3506: ,p_effective_date in date
3507: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 3504: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE

3500: -- ---------------------------------------------------------------------------
3501: --
3502: procedure chk_sal_review_period
3503: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3504: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3505: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3506: ,p_effective_date in date
3507: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3508: )

Line 3505: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

3501: --
3502: procedure chk_sal_review_period
3503: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3504: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3505: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3506: ,p_effective_date in date
3507: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3508: )
3509: is

Line 3507: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

3503: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3504: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3505: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3506: ,p_effective_date in date
3507: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3508: )
3509: is
3510: --
3511: l_proc varchar2(72) := g_package||'chk_sal_review_period';

Line 3566: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'

3562: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3563: exception
3564: when app_exception.application_exception then
3565: if hr_multi_message.exception_add
3566: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3567: ) then
3568: hr_utility.set_location(' Leaving:'|| l_proc, 6);
3569: raise;
3570: end if;

Line 3579: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3575: -- |---------------------< chk_sal_rp_freq_sal_rp >--------------------------|
3576: -- ---------------------------------------------------------------------------
3577: --
3578: procedure chk_sal_rp_freq_sal_rp
3579: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3580: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
3581: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3582: ,p_effective_date in date
3583: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 3580: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE

3576: -- ---------------------------------------------------------------------------
3577: --
3578: procedure chk_sal_rp_freq_sal_rp
3579: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3580: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
3581: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3582: ,p_effective_date in date
3583: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3584: )

Line 3581: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE

3577: --
3578: procedure chk_sal_rp_freq_sal_rp
3579: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3580: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
3581: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3582: ,p_effective_date in date
3583: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3584: )
3585: is

Line 3583: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

3579: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3580: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
3581: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3582: ,p_effective_date in date
3583: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3584: )
3585: is
3586: --
3587: l_proc varchar2(72):= g_package||'chk_sal_rp_freq_sal_rp';

Line 3594: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'

3590: begin
3591: hr_utility.set_location('Entering:'|| l_proc, 1);
3592: --
3593: if hr_multi_message.no_exclusive_error
3594: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3595: ,p_check_column2 =>
3596: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3597: ) then
3598: --

Line 3596: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'

3592: --
3593: if hr_multi_message.no_exclusive_error
3594: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3595: ,p_check_column2 =>
3596: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3597: ) then
3598: --
3599: -- Check mandatory parameters have been set
3600: --

Line 3653: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'

3649: exception
3650: when app_exception.application_exception then
3651: if hr_multi_message.exception_add
3652: (p_associated_column1 =>
3653: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3654: ,p_associated_column2 =>
3655: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3656: ) then
3657: hr_utility.set_location(' Leaving:'|| l_proc, 5);

Line 3655: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'

3651: if hr_multi_message.exception_add
3652: (p_associated_column1 =>
3653: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3654: ,p_associated_column2 =>
3655: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3656: ) then
3657: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3658: raise;
3659: end if;

Line 3668: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3664: -- |-----------------------< chk_set_of_books_id >---------------------------|
3665: -- ---------------------------------------------------------------------------
3666: --
3667: procedure chk_set_of_books_id
3668: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3669: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3670: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3671: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
3672: ,p_effective_date in date

Line 3669: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

3665: -- ---------------------------------------------------------------------------
3666: --
3667: procedure chk_set_of_books_id
3668: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3669: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3670: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3671: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
3672: ,p_effective_date in date
3673: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 3670: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

3666: --
3667: procedure chk_set_of_books_id
3668: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3669: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3670: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3671: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
3672: ,p_effective_date in date
3673: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3674: )

Line 3671: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE

3667: procedure chk_set_of_books_id
3668: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3669: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3670: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3671: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
3672: ,p_effective_date in date
3673: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3674: )
3675: is

Line 3673: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

3669: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3670: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3671: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
3672: ,p_effective_date in date
3673: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3674: )
3675: is
3676: --
3677: l_proc varchar2(72) := g_package||'chk_set_of_books_id';

Line 3680: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

3676: --
3677: l_proc varchar2(72) := g_package||'chk_set_of_books_id';
3678: l_exists varchar2(1);
3679: l_api_updating boolean;
3680: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3681: --
3682: cursor csr_valid_sob is
3683: select null
3684: from gl_sets_of_books

Line 3774: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID'

3770: hr_utility.set_location(' Leaving:'|| l_proc, 100);
3771: exception
3772: when app_exception.application_exception then
3773: if hr_multi_message.exception_add
3774: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID'
3775: ) then
3776: hr_utility.set_location(' Leaving:'|| l_proc, 110);
3777: raise;
3778: end if;

Line 3787: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3783: -- |--------------------< chk_soft_coding_keyflex_id >-----------------------|
3784: -- ---------------------------------------------------------------------------
3785: --
3786: procedure chk_soft_coding_keyflex_id
3787: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3788: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3789: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
3790: ,p_effective_date in date
3791: ,p_validation_start_date in date

Line 3788: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

3784: -- ---------------------------------------------------------------------------
3785: --
3786: procedure chk_soft_coding_keyflex_id
3787: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3788: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3789: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
3790: ,p_effective_date in date
3791: ,p_validation_start_date in date
3792: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 3789: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE

3785: --
3786: procedure chk_soft_coding_keyflex_id
3787: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3788: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3789: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
3790: ,p_effective_date in date
3791: ,p_validation_start_date in date
3792: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3793: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE

Line 3792: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

3788: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3789: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
3790: ,p_effective_date in date
3791: ,p_validation_start_date in date
3792: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3793: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
3794: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3795: )
3796: is

Line 3793: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE

3789: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
3790: ,p_effective_date in date
3791: ,p_validation_start_date in date
3792: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3793: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
3794: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3795: )
3796: is
3797: --

Line 3794: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

3790: ,p_effective_date in date
3791: ,p_validation_start_date in date
3792: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3793: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
3794: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3795: )
3796: is
3797: --
3798: l_exists varchar2(1);

Line 3880: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID'

3876: if p_assignment_type not in ('E','A','B','C','O') then
3877: --
3878: hr_utility.set_message(801, 'HR_51227_ASG_INV_ASG_TYP_SCF');
3879: hr_multi_message.add
3880: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID'
3881: );
3882: --
3883: end if;
3884: hr_utility.set_location(l_proc, 50);

Line 3895: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID'

3891: if csr_valid_keyflex%notfound then
3892: close csr_valid_keyflex;
3893: hr_utility.set_message(801, 'HR_7383_ASG_INV_KEYFLEX');
3894: hr_multi_message.add
3895: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID'
3896: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3897: );
3898: else
3899: close csr_valid_keyflex;

Line 3896: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

3892: close csr_valid_keyflex;
3893: hr_utility.set_message(801, 'HR_7383_ASG_INV_KEYFLEX');
3894: hr_multi_message.add
3895: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID'
3896: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3897: );
3898: else
3899: close csr_valid_keyflex;
3900: end if;

Line 3933: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'

3929: end if;
3930: close csr_tax_unit_message;
3931: end if;
3932: hr_multi_message.add
3933: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
3934: );
3935: else
3936: close csr_pay_legislation_rules;
3937: end if;

Line 3952: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3948: -- |--------------------< chk_source_organization_id >-----------------------|
3949: -- ---------------------------------------------------------------------------
3950: --
3951: procedure chk_source_organization_id
3952: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3953: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3954: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3955: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
3956: ,p_effective_date in date

Line 3953: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

3949: -- ---------------------------------------------------------------------------
3950: --
3951: procedure chk_source_organization_id
3952: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3953: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3954: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3955: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
3956: ,p_effective_date in date
3957: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 3954: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

3950: --
3951: procedure chk_source_organization_id
3952: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3953: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3954: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3955: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
3956: ,p_effective_date in date
3957: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3958: ,p_validation_start_date in date

Line 3955: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE

3951: procedure chk_source_organization_id
3952: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3953: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3954: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3955: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
3956: ,p_effective_date in date
3957: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3958: ,p_validation_start_date in date
3959: ,p_validation_end_date in date

Line 3957: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

3953: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3954: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3955: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
3956: ,p_effective_date in date
3957: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3958: ,p_validation_start_date in date
3959: ,p_validation_end_date in date
3960: )
3961: is

Line 3965: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

3961: is
3962: --
3963: l_proc varchar2(72) := g_package||'chk_source_organization_id';
3964: l_api_updating boolean;
3965: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3966: --
3967: cursor csr_val_source_org_id is
3968: select business_group_id
3969: from per_organization_units

Line 4032: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'

4028: If l_api_updating then
4029: --
4030: hr_utility.set_message(801, 'HR_51220_ASG_INV_EASG_U_SORG');
4031: hr_multi_message.add
4032: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4033: );
4034: --
4035: else -- inserting an employee assignment
4036: --

Line 4039: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'

4035: else -- inserting an employee assignment
4036: --
4037: hr_utility.set_message(801, 'HR_51219_ASG_INV_EASG_I_SORG');
4038: hr_multi_message.add
4039: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4040: );
4041: --
4042: end if;
4043: hr_utility.set_location(l_proc, 60);

Line 4059: 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'

4055: close csr_val_source_org_id;
4056: hr_utility.set_message(801, 'HR_51308_ASG_INV_SOURCE_ORG');
4057: hr_multi_message.add
4058: (p_associated_column1 =>
4059: 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4060: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4061: );
4062: --
4063: else

Line 4060: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

4056: hr_utility.set_message(801, 'HR_51308_ASG_INV_SOURCE_ORG');
4057: hr_multi_message.add
4058: (p_associated_column1 =>
4059: 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4060: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4061: );
4062: --
4063: else
4064: close csr_val_source_org_id;

Line 4075: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'

4071: If p_business_group_id <> l_business_group_id then
4072: --
4073: hr_utility.set_message(801, 'HR_51309_ASG_INV_SOURCE_ORG_BG');
4074: hr_multi_message.add
4075: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4076: );
4077: --
4078: end if;
4079: hr_utility.set_location(l_proc, 90);

Line 4093: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

4089: -- |------------------------< chk_source_type >------------------------------|
4090: -- ---------------------------------------------------------------------------
4091: --
4092: procedure chk_source_type
4093: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4094: ,p_source_type in per_all_assignments_f.source_type%TYPE
4095: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
4096: ,p_effective_date in date
4097: ,p_validation_start_date in date

Line 4094: ,p_source_type in per_all_assignments_f.source_type%TYPE

4090: -- ---------------------------------------------------------------------------
4091: --
4092: procedure chk_source_type
4093: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4094: ,p_source_type in per_all_assignments_f.source_type%TYPE
4095: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
4096: ,p_effective_date in date
4097: ,p_validation_start_date in date
4098: ,p_validation_end_date in date

Line 4095: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE

4091: --
4092: procedure chk_source_type
4093: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4094: ,p_source_type in per_all_assignments_f.source_type%TYPE
4095: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
4096: ,p_effective_date in date
4097: ,p_validation_start_date in date
4098: ,p_validation_end_date in date
4099: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 4099: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

4095: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
4096: ,p_effective_date in date
4097: ,p_validation_start_date in date
4098: ,p_validation_end_date in date
4099: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4100: )
4101: is
4102: --
4103: l_proc varchar2(72) := g_package||'chk_source_type';

Line 4173: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE'

4169: then
4170: --
4171: hr_utility.set_message(801, 'HR_51162_ASG_INV_SOURCE_TYPE');
4172: hr_multi_message.add
4173: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE'
4174: );
4175: --
4176: end if;
4177: hr_utility.set_location(l_proc, 50);

Line 4196: 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'

4192: --
4193: hr_utility.set_message(801, 'HR_51325_ASG_INV_SOU_TYP_RAT');
4194: hr_multi_message.add
4195: (p_associated_column1 =>
4196: 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
4197: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE'
4198: );
4199: --
4200: end if;

Line 4197: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE'

4193: hr_utility.set_message(801, 'HR_51325_ASG_INV_SOU_TYP_RAT');
4194: hr_multi_message.add
4195: (p_associated_column1 =>
4196: 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
4197: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE'
4198: );
4199: --
4200: end if;
4201: hr_utility.set_location(l_proc, 70);

Line 4219: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

4215: -- |-------------------< chk_special_ceiling_step_id >-----------------------|
4216: -- ---------------------------------------------------------------------------
4217: --
4218: procedure chk_special_ceiling_step_id
4219: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4220: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
4221: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4222: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4223: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

Line 4220: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

4216: -- ---------------------------------------------------------------------------
4217: --
4218: procedure chk_special_ceiling_step_id
4219: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4220: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
4221: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4222: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4223: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4224: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 4221: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE

4217: --
4218: procedure chk_special_ceiling_step_id
4219: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4220: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
4221: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4222: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4223: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4224: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4225: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 4222: ,p_grade_id in per_all_assignments_f.grade_id%TYPE

4218: procedure chk_special_ceiling_step_id
4219: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4220: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
4221: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4222: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4223: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4224: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4225: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4226: ,p_effective_date in date

Line 4223: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

4219: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4220: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
4221: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4222: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4223: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4224: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4225: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4226: ,p_effective_date in date
4227: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 4224: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

4220: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
4221: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4222: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4223: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4224: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4225: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4226: ,p_effective_date in date
4227: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4228: )

Line 4225: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

4221: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4222: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4223: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4224: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4225: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4226: ,p_effective_date in date
4227: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4228: )
4229: is

Line 4227: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

4223: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4224: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4225: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4226: ,p_effective_date in date
4227: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4228: )
4229: is
4230: --
4231: l_sequence per_spinal_point_steps_f.sequence%TYPE;

Line 4348: 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'

4344: --
4345: hr_utility.set_message(801, 'HR_51225_ASG_INV_ASG_TYP_SCS');
4346: hr_multi_message.add
4347: (p_associated_column1 =>
4348: 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4349: );
4350: --
4351: end if;
4352: hr_utility.set_location(l_proc, 50);

Line 4363: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'

4359: if csr_valid_step%notfound then
4360: close csr_valid_step;
4361: hr_utility.set_message(801, 'HR_7379_ASG_INV_SPEC_CEIL_STEP');
4362: hr_multi_message.add
4363: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4364: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4365: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
4366: );
4367: --

Line 4364: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

4360: close csr_valid_step;
4361: hr_utility.set_message(801, 'HR_7379_ASG_INV_SPEC_CEIL_STEP');
4362: hr_multi_message.add
4363: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4364: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4365: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
4366: );
4367: --
4368: else

Line 4365: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'

4361: hr_utility.set_message(801, 'HR_7379_ASG_INV_SPEC_CEIL_STEP');
4362: hr_multi_message.add
4363: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4364: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4365: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
4366: );
4367: --
4368: else
4369: close csr_valid_step;

Line 4382: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'

4378: if l_business_group_id <> p_business_group_id then
4379: close csr_get_bus_grp;
4380: hr_utility.set_message(801, 'HR_7375_ASG_INV_BG_SP_CLG_STEP');
4381: hr_multi_message.add
4382: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4383: );
4384: else
4385: close csr_get_bus_grp;
4386: end if;

Line 4390: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'

4386: end if;
4387: hr_utility.set_location(l_proc, 70);
4388: --
4389: if hr_multi_message.no_exclusive_error
4390: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4391: ) then
4392: --
4393: -- Check that the special_ceiling_step_id is valid for the grade
4394: -- if p_grade is not null.

Line 4403: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'

4399: if csr_valid_step_grade%notfound then
4400: close csr_valid_step_grade;
4401: hr_utility.set_message(801, 'HR_7380_ASG_STEP_INV_FOR_GRADE');
4402: hr_multi_message.add
4403: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4404: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4405: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4406: );
4407: else

Line 4404: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

4400: close csr_valid_step_grade;
4401: hr_utility.set_message(801, 'HR_7380_ASG_STEP_INV_FOR_GRADE');
4402: hr_multi_message.add
4403: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4404: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4405: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4406: );
4407: else
4408: close csr_valid_step_grade;

Line 4405: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'

4401: hr_utility.set_message(801, 'HR_7380_ASG_STEP_INV_FOR_GRADE');
4402: hr_multi_message.add
4403: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4404: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4405: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4406: );
4407: else
4408: close csr_valid_step_grade;
4409: end if;

Line 4418: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'

4414: -- then grade id must also be not null
4415: --
4416: hr_utility.set_message(801, 'HR_7434_ASG_GRADE_REQUIRED');
4417: hr_multi_message.add
4418: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4419: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4420: );
4421: end if;
4422: hr_utility.set_location(l_proc, 90);

Line 4419: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'

4415: --
4416: hr_utility.set_message(801, 'HR_7434_ASG_GRADE_REQUIRED');
4417: hr_multi_message.add
4418: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4419: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4420: );
4421: end if;
4422: hr_utility.set_location(l_proc, 90);
4423: --

Line 4437: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'

4433: if csr_low_step%found then
4434: close csr_low_step;
4435: hr_utility.set_message(801, 'HR_7381_ASG_CEIL_STEP_TOO_HIGH');
4436: hr_multi_message.add
4437: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4438: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4439: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
4440: );
4441: else

Line 4438: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

4434: close csr_low_step;
4435: hr_utility.set_message(801, 'HR_7381_ASG_CEIL_STEP_TOO_HIGH');
4436: hr_multi_message.add
4437: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4438: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4439: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
4440: );
4441: else
4442: close csr_low_step;

Line 4439: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'

4435: hr_utility.set_message(801, 'HR_7381_ASG_CEIL_STEP_TOO_HIGH');
4436: hr_multi_message.add
4437: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4438: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4439: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
4440: );
4441: else
4442: close csr_low_step;
4443: end if;

Line 4462: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

4458: -- |--------------------------< chk_supervisor_id >--------------------------|
4459: -- ---------------------------------------------------------------------------
4460: --
4461: procedure chk_supervisor_id
4462: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4463: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4464: ,p_person_id in per_all_assignments_f.person_id%TYPE
4465: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4466: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 4463: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE

4459: -- ---------------------------------------------------------------------------
4460: --
4461: procedure chk_supervisor_id
4462: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4463: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4464: ,p_person_id in per_all_assignments_f.person_id%TYPE
4465: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4466: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4467: ,p_effective_date in date

Line 4464: ,p_person_id in per_all_assignments_f.person_id%TYPE

4460: --
4461: procedure chk_supervisor_id
4462: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4463: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4464: ,p_person_id in per_all_assignments_f.person_id%TYPE
4465: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4466: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4467: ,p_effective_date in date
4468: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 4465: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

4461: procedure chk_supervisor_id
4462: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4463: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4464: ,p_person_id in per_all_assignments_f.person_id%TYPE
4465: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4466: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4467: ,p_effective_date in date
4468: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4469: )

Line 4466: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

4462: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4463: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4464: ,p_person_id in per_all_assignments_f.person_id%TYPE
4465: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4466: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4467: ,p_effective_date in date
4468: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4469: )
4470: is

Line 4468: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

4464: ,p_person_id in per_all_assignments_f.person_id%TYPE
4465: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4466: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4467: ,p_effective_date in date
4468: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4469: )
4470: is
4471: --
4472: l_proc varchar2(72) := g_package||'chk_supervisor_id';

Line 4478: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

4474: --
4475: l_business_group_id per_people_f.business_group_id%TYPE;
4476: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
4477: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
4478: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4479: --
4480: -- Fix for bug 4305723 starts here.
4481: --
4482: cursor csr_party_id(p_per_id number) IS

Line 4498: from per_all_assignments_f asg

4494: --
4495: -- Bug#3917021
4496: cursor csr_asg_typ is
4497: select assignment_type
4498: from per_all_assignments_f asg
4499: where asg.assignment_id = p_assignment_id
4500: and p_validation_start_date
4501: between asg.effective_start_date
4502: and asg.effective_end_date;

Line 4516: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'

4512: begin
4513: hr_utility.set_location('Entering:'|| l_proc, 10);
4514: --
4515: if hr_multi_message.no_exclusive_error
4516: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4517: ) then
4518: --
4519: -- Check mandatory parameters have been set
4520: --

Line 4575: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'

4571: If p_supervisor_id = p_person_id then
4572: --
4573: hr_utility.set_message(801, 'HR_51143_ASG_EMP_EQUAL_SUP');
4574: hr_multi_message.add
4575: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4576: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4577: );
4578: end if;
4579: hr_utility.set_location(l_proc, 50);

Line 4576: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'

4572: --
4573: hr_utility.set_message(801, 'HR_51143_ASG_EMP_EQUAL_SUP');
4574: hr_multi_message.add
4575: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4576: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4577: );
4578: end if;
4579: hr_utility.set_location(l_proc, 50);
4580: --

Line 4596: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'

4592: If l_per_party_id = l_sup_party_id
4593: then
4594: hr_utility.set_message(800, 'HR_449603_ASG_SUP_DUP_PER');
4595: hr_multi_message.add
4596: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4597: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4598: );
4599: end if;
4600: --

Line 4597: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'

4593: then
4594: hr_utility.set_message(800, 'HR_449603_ASG_SUP_DUP_PER');
4595: hr_multi_message.add
4596: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4597: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4598: );
4599: end if;
4600: --
4601: -- Fix for bug 4305723 ends here.

Line 4616: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

4612: close csr_valid_supervisor_id;
4613: --
4614: hr_utility.set_message(801, 'PAY_7599_SYS_SUP_DT_OUTDATE');
4615: hr_multi_message.add
4616: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4617: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4618: );
4619: else
4620: close csr_valid_supervisor_id;

Line 4617: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'

4613: --
4614: hr_utility.set_message(801, 'PAY_7599_SYS_SUP_DT_OUTDATE');
4615: hr_multi_message.add
4616: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4617: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4618: );
4619: else
4620: close csr_valid_supervisor_id;
4621: end if;

Line 4633: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'

4629: then
4630: --
4631: hr_utility.set_message(801, 'HR_51145_ASG_SUP_BG_NE_EMP_BG');
4632: hr_multi_message.add
4633: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4634: );
4635: end if;
4636: hr_utility.set_location(l_proc, 70);
4637: --

Line 4656: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID');

4652: if l_assignment_type in ('C','E','B') then
4653: --
4654: hr_utility.set_message(801, 'HR_51346_ASG_SUP_NOT_EMP');
4655: hr_multi_message.add
4656: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID');
4657: --
4658: end if;
4659: --Bug#3917021 ends here
4660: --

Line 4677: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

4673: -- |-------------------< chk_supervisor_assignment_id >----------------------|
4674: -- ---------------------------------------------------------------------------
4675: --
4676: procedure chk_supervisor_assignment_id
4677: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4678: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4679: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
4680: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4681: ,p_effective_date in date

Line 4678: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE

4674: -- ---------------------------------------------------------------------------
4675: --
4676: procedure chk_supervisor_assignment_id
4677: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4678: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4679: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
4680: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4681: ,p_effective_date in date
4682: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 4679: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE

4675: --
4676: procedure chk_supervisor_assignment_id
4677: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4678: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4679: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
4680: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4681: ,p_effective_date in date
4682: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4683: )

Line 4680: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

4676: procedure chk_supervisor_assignment_id
4677: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4678: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4679: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
4680: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4681: ,p_effective_date in date
4682: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4683: )
4684: is

Line 4682: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

4678: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4679: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
4680: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4681: ,p_effective_date in date
4682: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4683: )
4684: is
4685: --
4686: l_proc varchar2(72) := g_package||'chk_supervisor_assignment_id';

Line 4688: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

4684: is
4685: --
4686: l_proc varchar2(72) := g_package||'chk_supervisor_assignment_id';
4687: l_api_updating boolean;
4688: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4689: --
4690: cursor csr_supervisor_assignment_id is
4691: select paaf.assignment_type
4692: from per_all_assignments_f paaf

Line 4692: from per_all_assignments_f paaf

4688: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4689: --
4690: cursor csr_supervisor_assignment_id is
4691: select paaf.assignment_type
4692: from per_all_assignments_f paaf
4693: where paaf.person_id = p_supervisor_id
4694: and p_supervisor_id is not null
4695: and paaf.assignment_id = p_supervisor_assignment_id
4696: and p_validation_start_date between

Line 4703: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'

4699: begin
4700: hr_utility.set_location('Entering:'|| l_proc, 10);
4701: --
4702: if hr_multi_message.no_exclusive_error
4703: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4704: ) then
4705: --
4706: -- Check mandatory parameters have been set
4707: --

Line 4781: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

4777: --
4778: hr_utility.set_message(800, 'HR_50146_SUP_ASG_INVALID');
4779: hr_utility.raise_error;
4780: /* hr_multi_message.add
4781: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4782: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4783: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'
4784: ); */
4785: else

Line 4782: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'

4778: hr_utility.set_message(800, 'HR_50146_SUP_ASG_INVALID');
4779: hr_utility.raise_error;
4780: /* hr_multi_message.add
4781: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4782: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4783: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'
4784: ); */
4785: else
4786: close csr_supervisor_assignment_id;

Line 4783: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'

4779: hr_utility.raise_error;
4780: /* hr_multi_message.add
4781: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4782: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4783: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'
4784: ); */
4785: else
4786: close csr_supervisor_assignment_id;
4787: end if;

Line 4804: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'

4800: hr_utility.set_location(l_proc, 80);
4801: hr_utility.set_message(800, 'HR_50147_SUP_ASG_WRONG_TYPE');
4802: hr_utility.raise_error;
4803: /*hr_multi_message.add
4804: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'
4805: ); */
4806: --
4807: end if;
4808: hr_utility.set_location(l_proc, 90);

Line 4848: (p_person_id in per_all_assignments_f.person_id%TYPE

4844: -- Access Status:
4845: -- Internal Table Handler Use Only.
4846: --
4847: procedure chk_system_pers_type
4848: (p_person_id in per_all_assignments_f.person_id%TYPE
4849: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4850: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4851: ,p_datetrack_mode in varchar2
4852: ,p_effective_date in date

Line 4849: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

4845: -- Internal Table Handler Use Only.
4846: --
4847: procedure chk_system_pers_type
4848: (p_person_id in per_all_assignments_f.person_id%TYPE
4849: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4850: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4851: ,p_datetrack_mode in varchar2
4852: ,p_effective_date in date
4853: )

Line 4850: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

4846: --
4847: procedure chk_system_pers_type
4848: (p_person_id in per_all_assignments_f.person_id%TYPE
4849: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4850: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4851: ,p_datetrack_mode in varchar2
4852: ,p_effective_date in date
4853: )
4854: is

Line 4919: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'

4915: --
4916: exception
4917: when app_exception.application_exception then
4918: if hr_multi_message.exception_add
4919: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4920: ) then
4921: hr_utility.set_location(' Leaving:'|| l_proc, 5);
4922: raise;
4923: end if;

Line 4962: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

4958: -- Access Status:
4959: -- Internal Table Handler Use Only.
4960: --
4961: procedure chk_term_status
4962: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4963: ,p_datetrack_mode in varchar2
4964: ,p_validation_start_date in date
4965: )
4966: is

Line 4973: from per_all_assignments_f pas

4969: l_proc varchar2(72) := g_package||'chk_term_status';
4970: --
4971: cursor csr_chk_term_status is
4972: select null
4973: from per_all_assignments_f pas
4974: , per_assignment_status_types past
4975: where pas.assignment_id = p_assignment_id
4976: and pas.effective_start_date >= p_validation_start_date
4977: and past.assignment_status_type_id = pas.assignment_status_type_id

Line 4994: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATETRACK_MODE'

4990: if csr_chk_term_status%found then
4991: close csr_chk_term_status;
4992: hr_utility.set_message(801, 'HR_7412_ASG_ASS_TERM_IN_FUTURE');
4993: hr_multi_message.add
4994: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATETRACK_MODE'
4995: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4996: );
4997: else
4998: close csr_chk_term_status;

Line 4995: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

4991: close csr_chk_term_status;
4992: hr_utility.set_message(801, 'HR_7412_ASG_ASS_TERM_IN_FUTURE');
4993: hr_multi_message.add
4994: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATETRACK_MODE'
4995: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4996: );
4997: else
4998: close csr_chk_term_status;
4999: end if;

Line 5013: (p_time_normal_finish in out nocopy per_all_assignments_f.time_normal_finish%TYPE

5009: -- ---------------------------------------------------------------------------
5010: -- << 2734822 >>
5011: --
5012: procedure chk_time_finish_formatted
5013: (p_time_normal_finish in out nocopy per_all_assignments_f.time_normal_finish%TYPE
5014: )
5015: is
5016: --
5017: l_proc varchar2(72) := g_package||'chk_time_finish_formatted';

Line 5037: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH'

5033: hr_utility.set_location(' Leaving:'|| l_proc, 2);
5034: exception
5035: when app_exception.application_exception then
5036: if hr_multi_message.exception_add
5037: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH'
5038: ) then
5039: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5040: raise;
5041: end if;

Line 5048: (p_time_normal_finish in per_all_assignments_f.time_normal_finish%TYPE

5044: end chk_time_finish_formatted;
5045: --
5046: --
5047: procedure chk_time_normal_finish
5048: (p_time_normal_finish in per_all_assignments_f.time_normal_finish%TYPE
5049: )
5050: is
5051: --
5052: l_value per_all_assignments_f.time_normal_finish%TYPE;

Line 5052: l_value per_all_assignments_f.time_normal_finish%TYPE;

5048: (p_time_normal_finish in per_all_assignments_f.time_normal_finish%TYPE
5049: )
5050: is
5051: --
5052: l_value per_all_assignments_f.time_normal_finish%TYPE;
5053: begin
5054:
5055: l_value := p_time_normal_finish;
5056: chk_time_finish_formatted(l_value);

Line 5065: (p_time_normal_start in out nocopy per_all_assignments_f.time_normal_start%TYPE

5061: -- |---------------------< chk_time_normal_start >---------------------------|
5062: -- ---------------------------------------------------------------------------
5063: --
5064: procedure chk_time_start_formatted -- #2734822
5065: (p_time_normal_start in out nocopy per_all_assignments_f.time_normal_start%TYPE
5066: )
5067: is
5068: --
5069: l_proc varchar2(72) := g_package||'chk_time_normal_start_formatted';

Line 5089: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START'

5085: hr_utility.set_location(' Leaving:'|| l_proc, 2);
5086: exception
5087: when app_exception.application_exception then
5088: if hr_multi_message.exception_add
5089: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START'
5090: ) then
5091: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5092: raise;
5093: end if;

Line 5100: (p_time_normal_start in per_all_assignments_f.time_normal_start%TYPE

5096: --
5097: -- << 2734822 >>
5098: --
5099: procedure chk_time_normal_start
5100: (p_time_normal_start in per_all_assignments_f.time_normal_start%TYPE
5101: )
5102: is
5103: --
5104: l_value per_all_assignments_f.time_normal_start%TYPE;

Line 5104: l_value per_all_assignments_f.time_normal_start%TYPE;

5100: (p_time_normal_start in per_all_assignments_f.time_normal_start%TYPE
5101: )
5102: is
5103: --
5104: l_value per_all_assignments_f.time_normal_start%TYPE;
5105: begin
5106:
5107: l_value := p_time_normal_start;
5108: chk_time_start_formatted(l_value);

Line 5117: (p_person_id in per_all_assignments_f.person_id%TYPE

5113: -- |-----------------------< chk_dup_apl_vacancy >----------------------------|
5114: -- ---------------------------------------------------------------------------
5115: --
5116: procedure chk_dup_apl_vacancy
5117: (p_person_id in per_all_assignments_f.person_id%TYPE
5118: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5119: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5120: ,p_effective_date in date
5121: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null

Line 5118: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

5114: -- ---------------------------------------------------------------------------
5115: --
5116: procedure chk_dup_apl_vacancy
5117: (p_person_id in per_all_assignments_f.person_id%TYPE
5118: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5119: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5120: ,p_effective_date in date
5121: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
5122: )

Line 5119: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

5115: --
5116: procedure chk_dup_apl_vacancy
5117: (p_person_id in per_all_assignments_f.person_id%TYPE
5118: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5119: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5120: ,p_effective_date in date
5121: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
5122: )
5123: is

Line 5121: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null

5117: (p_person_id in per_all_assignments_f.person_id%TYPE
5118: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5119: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5120: ,p_effective_date in date
5121: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
5122: )
5123: is
5124: --
5125: l_proc varchar2(72) := g_package||'chk_dup_apl_vacancy';

Line 5132: per_all_assignments_f paf,

5128: cursor csr_dup_apl_vacancy is
5129: select pa.application_id
5130: from
5131: per_applications pa,
5132: per_all_assignments_f paf,
5133: per_vacancies pv
5134: where
5135: paf.person_id = p_person_id
5136: and paf.vacancy_id = pv.vacancy_id

Line 5169: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'

5165: end if;
5166: exception
5167: when app_exception.application_exception then
5168: if hr_multi_message.exception_add
5169: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5170: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5171: ) then
5172: hr_utility.set_location(' Leaving:'|| l_proc, 30);
5173: raise;

Line 5170: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

5166: exception
5167: when app_exception.application_exception then
5168: if hr_multi_message.exception_add
5169: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5170: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5171: ) then
5172: hr_utility.set_location(' Leaving:'|| l_proc, 30);
5173: raise;
5174: end if;

Line 5185: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5181: -- |-------------------------< chk_vacancy_id >------------------------------|
5182: -- ---------------------------------------------------------------------------
5183: --
5184: procedure chk_vacancy_id
5185: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5186: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5187: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5188: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5189: ,p_effective_date in date

Line 5186: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

5182: -- ---------------------------------------------------------------------------
5183: --
5184: procedure chk_vacancy_id
5185: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5186: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5187: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5188: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5189: ,p_effective_date in date
5190: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 5187: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

5183: --
5184: procedure chk_vacancy_id
5185: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5186: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5187: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5188: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5189: ,p_effective_date in date
5190: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5191: ,p_validation_start_date in date

Line 5188: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

5184: procedure chk_vacancy_id
5185: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5186: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5187: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5188: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5189: ,p_effective_date in date
5190: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5191: ,p_validation_start_date in date
5192: ,p_validation_end_date in date

Line 5190: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

5186: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5187: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5188: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5189: ,p_effective_date in date
5190: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5191: ,p_validation_start_date in date
5192: ,p_validation_end_date in date
5193: )
5194: is

Line 5199: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

5195: --
5196: l_proc varchar2(72) := g_package||'chk_vacancy_id';
5197: l_api_updating boolean;
5198: l_exists varchar2(1);
5199: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
5200: --
5201: cursor csr_val_vacancy_id is
5202: select business_group_id
5203: from per_vacancies

Line 5270: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'

5266: If l_api_updating then
5267: --
5268: hr_utility.set_message(801, 'HR_51222_ASG_INV_EASG_U_VAC');
5269: hr_multi_message.add
5270: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5271: );
5272: --
5273: else -- inserting a non employee
5274: --

Line 5277: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'

5273: else -- inserting a non employee
5274: --
5275: hr_utility.set_message(801, 'HR_51221_ASG_INV_EASG_I_VAC');
5276: hr_multi_message.add
5277: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5278: );
5279: --
5280: end if;
5281: hr_utility.set_location(l_proc, 50);

Line 5317: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'

5313: close csr_val_vacancy_id;
5314: hr_utility.set_message(801, 'HR_51297_ASG_INV_VACANCY');
5315: hr_utility.raise_error;
5316: /* hr_multi_message.add
5317: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5318: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5319: ); */
5320: --
5321: else

Line 5318: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

5314: hr_utility.set_message(801, 'HR_51297_ASG_INV_VACANCY');
5315: hr_utility.raise_error;
5316: /* hr_multi_message.add
5317: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5318: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5319: ); */
5320: --
5321: else
5322: close csr_val_vacancy_id;

Line 5352: (p_assignment_type in per_all_assignments_f.assignment_type%TYPE

5348: -- |----------------------< gen_assignment_sequence >------------------------|
5349: -- ---------------------------------------------------------------------------
5350: --
5351: procedure gen_assignment_sequence
5352: (p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5353: ,p_person_id in per_all_assignments_f.person_id%TYPE
5354: ,p_assignment_sequence in out nocopy per_all_assignments_f.assignment_sequence%TYPE
5355: )
5356: is

Line 5353: ,p_person_id in per_all_assignments_f.person_id%TYPE

5349: -- ---------------------------------------------------------------------------
5350: --
5351: procedure gen_assignment_sequence
5352: (p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5353: ,p_person_id in per_all_assignments_f.person_id%TYPE
5354: ,p_assignment_sequence in out nocopy per_all_assignments_f.assignment_sequence%TYPE
5355: )
5356: is
5357: --

Line 5354: ,p_assignment_sequence in out nocopy per_all_assignments_f.assignment_sequence%TYPE

5350: --
5351: procedure gen_assignment_sequence
5352: (p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5353: ,p_person_id in per_all_assignments_f.person_id%TYPE
5354: ,p_assignment_sequence in out nocopy per_all_assignments_f.assignment_sequence%TYPE
5355: )
5356: is
5357: --
5358: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 5358: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

5354: ,p_assignment_sequence in out nocopy per_all_assignments_f.assignment_sequence%TYPE
5355: )
5356: is
5357: --
5358: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
5359: l_proc varchar2(72) := g_package||'gen_assignment_sequence';
5360: --
5361: cursor csr_get_ass_seq is
5362: select nvl(max(assignment_sequence),0) +1

Line 5363: from per_all_assignments_f

5359: l_proc varchar2(72) := g_package||'gen_assignment_sequence';
5360: --
5361: cursor csr_get_ass_seq is
5362: select nvl(max(assignment_sequence),0) +1
5363: from per_all_assignments_f
5364: where person_id = p_person_id
5365: and assignment_type = p_assignment_type;
5366: --
5367: begin

Line 5371: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'

5367: begin
5368: hr_utility.set_location('Entering:'|| l_proc, 1);
5369: --
5370: if hr_multi_message.no_exclusive_error
5371: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
5372: ) then
5373: --
5374: -- Check mandatory parameters have been set
5375: --

Line 5429: (p_organization_id in per_all_assignments_f.organization_id%TYPE

5425: -- Access Status:
5426: -- Internal Table Handler Use Only.
5427: --
5428: function other_managers_in_org
5429: (p_organization_id in per_all_assignments_f.organization_id%TYPE
5430: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5431: ,p_effective_date in date
5432: )
5433: return boolean is

Line 5430: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5426: -- Internal Table Handler Use Only.
5427: --
5428: function other_managers_in_org
5429: (p_organization_id in per_all_assignments_f.organization_id%TYPE
5430: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5431: ,p_effective_date in date
5432: )
5433: return boolean is
5434: --

Line 5438: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

5434: --
5435: l_exists varchar2(1);
5436: l_proc varchar2(72) := g_package||'other_managers_in_org';
5437: l_other_manager_exists boolean;
5438: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
5439: --
5440: cursor csr_other_manager_in_org is
5441: select null
5442: from per_all_assignments_f pas

Line 5442: from per_all_assignments_f pas

5438: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
5439: --
5440: cursor csr_other_manager_in_org is
5441: select null
5442: from per_all_assignments_f pas
5443: where pas.organization_id = p_organization_id
5444: and pas.assignment_type = 'E'
5445: and pas.manager_flag = 'Y'
5446: and pas.assignment_id <> l_assignment_id

Line 5491: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5487: -- |-----------------------< gen_date_probation_end >------------------------|
5488: -- ---------------------------------------------------------------------------
5489: --
5490: procedure gen_date_probation_end
5491: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5492: ,p_effective_date in date
5493: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
5494: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
5495: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 5493: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE

5489: --
5490: procedure gen_date_probation_end
5491: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5492: ,p_effective_date in date
5493: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
5494: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
5495: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5496: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5497: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE

Line 5494: ,p_probation_period in per_all_assignments_f.probation_period%TYPE

5490: procedure gen_date_probation_end
5491: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5492: ,p_effective_date in date
5493: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
5494: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
5495: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5496: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5497: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
5498: )

Line 5495: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

5491: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5492: ,p_effective_date in date
5493: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
5494: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
5495: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5496: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5497: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
5498: )
5499: is

Line 5496: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

5492: ,p_effective_date in date
5493: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
5494: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
5495: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5496: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5497: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
5498: )
5499: is
5500: --

Line 5497: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE

5493: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
5494: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
5495: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5496: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5497: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
5498: )
5499: is
5500: --
5501: l_proc varchar2(72) := g_package||'gen_date_probation_end';

Line 5605: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5601: -- |---------------------< chk_internal_address_line >-----------------------|
5602: -- ---------------------------------------------------------------------------
5603: --
5604: procedure chk_internal_address_line
5605: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5606: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5607: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE
5608: ,p_effective_date in date
5609: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 5606: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

5602: -- ---------------------------------------------------------------------------
5603: --
5604: procedure chk_internal_address_line
5605: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5606: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5607: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE
5608: ,p_effective_date in date
5609: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5610: )

Line 5607: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE

5603: --
5604: procedure chk_internal_address_line
5605: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5606: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5607: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE
5608: ,p_effective_date in date
5609: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5610: )
5611: is

Line 5609: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

5605: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5606: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5607: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE
5608: ,p_effective_date in date
5609: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5610: )
5611: is
5612: --
5613: l_proc varchar2(72) := g_package||'chk_internal_address_line';

Line 5668: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE'

5664: hr_utility.set_location(' Leaving:'|| l_proc, 60);
5665: exception
5666: when app_exception.application_exception then
5667: if hr_multi_message.exception_add
5668: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE'
5669: ) then
5670: hr_utility.set_location(' Leaving:'|| l_proc, 70);
5671: raise;
5672: end if;

Line 5686: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5682: --
5683: procedure chk_applicant_rank
5684: (p_applicant_rank in number
5685: ,p_assignment_type in varchar2
5686: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5687: ,p_effective_date in date
5688: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE)
5689: IS
5690: --

Line 5688: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE)

5684: (p_applicant_rank in number
5685: ,p_assignment_type in varchar2
5686: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5687: ,p_effective_date in date
5688: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE)
5689: IS
5690: --
5691: l_proc varchar2(72) := g_package||'chk_applicant_rank';
5692: l_api_updating boolean;

Line 5760: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK'

5756: hr_utility.set_location('Leaving:'|| l_proc, 70);
5757: exception
5758: when app_exception.application_exception then
5759: if hr_multi_message.exception_add
5760: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK'
5761: ) then
5762: raise;
5763: end if;
5764: end chk_applicant_rank;

Line 5774: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5770: --
5771: procedure chk_posting_content_id
5772: (p_posting_content_id in number
5773: ,p_assignment_type in varchar2
5774: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5775: ,p_effective_date in date
5776: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5777: ) IS
5778: --

Line 5776: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

5772: (p_posting_content_id in number
5773: ,p_assignment_type in varchar2
5774: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5775: ,p_effective_date in date
5776: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5777: ) IS
5778: --
5779: l_proc varchar2(72) := g_package||'chk_posting_content_id';
5780: l_api_updating boolean;

Line 5860: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID'

5856: hr_utility.set_location('Leaving: '||l_proc, 50);
5857: exception
5858: when app_exception.application_exception then
5859: if hr_multi_message.exception_add
5860: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID'
5861: ) then
5862: raise;
5863: end if;
5864: --