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 451: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'

447: if p_assignment_type not in ('E','A','B','O') then
448: --
449: hr_utility.set_message(801, 'HR_51226_ASG_INV_ASG_TYP_PAY');
450: hr_multi_message.add
451: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
452: );
453: --
454: end if;
455: hr_utility.set_location(l_proc, 50);

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

477: --
478: if p_address_line1 is null then
479: hr_utility.set_message(800, 'PER_52990_ASG_PRADD_NE_PAY');
480: hr_multi_message.add
481: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
482: );
483: --
484: end if;
485:

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

496: if hr_general2.is_legislation_install('PAY','US') then --11933456
497: hr_utility.set_location(l_proc, 54);
498: hr_utility.set_message(800, 'HR_51283_ADD_MUST_BE_US_STYLE');
499: hr_multi_message.add
500: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
501: );
502:
503: end if;
504: end if;

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

521: if csr_payroll_exists%notfound then
522: close csr_payroll_exists;
523: hr_utility.set_message(801, 'HR_7370_ASG_INVALID_PAYROLL');
524: hr_multi_message.add
525: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
526: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
527: );
528: else
529: close csr_payroll_exists;

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

522: close csr_payroll_exists;
523: hr_utility.set_message(801, 'HR_7370_ASG_INVALID_PAYROLL');
524: hr_multi_message.add
525: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
526: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
527: );
528: else
529: close csr_payroll_exists;
530: end if;

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

538: if l_business_group_id <> p_business_group_id then
539: close csr_get_bus_grp;
540: hr_utility.set_message(801, 'HR_7373_ASG_INVALID_BG_PAYROLL');
541: hr_multi_message.add
542: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
543: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
544: );
545: else
546: close csr_get_bus_grp;

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

539: close csr_get_bus_grp;
540: hr_utility.set_message(801, 'HR_7373_ASG_INVALID_BG_PAYROLL');
541: hr_multi_message.add
542: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
543: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
544: );
545: else
546: close csr_get_bus_grp;
547: end if;

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

554: hr_utility.set_location(l_proc, 75);
555: if p_date_of_birth is null then
556: hr_utility.set_message(801, 'HR_7378_ASG_NO_DATE_OF_BIRTH');
557: hr_multi_message.add
558: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_OF_BIRTH'
559: );
560: end if;
561: hr_utility.set_location(l_proc, 80);
562: end if;

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

778: hr_utility.set_location(l_proc, 230);
779: --
780: hr_utility.set_message(801, 'HR_7969_ASG_INV_PAYROLL_PPMS');
781: hr_multi_message.add
782: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
783: );
784: end if;
785: end if;
786: --

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

813: close csr_any_future_asas;
814: --
815: hr_utility.set_message(801, 'HR_7975_ASG_INV_FUTURE_ASA');
816: hr_multi_message.add
817: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
818: );
819: else
820: --
821: hr_utility.set_location(l_proc, 240);

Line 837: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

833: -- |-----------------------< chk_people_group_id >---------------------------|
834: -- ---------------------------------------------------------------------------
835: --
836: procedure chk_people_group_id
837: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
838: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
839: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
840: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
841: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

Line 838: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

834: -- ---------------------------------------------------------------------------
835: --
836: procedure chk_people_group_id
837: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
838: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
839: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
840: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
841: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
842: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 839: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

835: --
836: procedure chk_people_group_id
837: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
838: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
839: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
840: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
841: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
842: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
843: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 840: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE

836: procedure chk_people_group_id
837: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
838: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
839: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
840: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
841: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
842: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
843: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
844: ,p_effective_date in date

Line 841: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

837: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
838: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
839: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
840: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
841: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
842: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
843: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
844: ,p_effective_date in date
845: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 842: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

838: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
839: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
840: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
841: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
842: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
843: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
844: ,p_effective_date in date
845: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
846: )

Line 843: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

839: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
840: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
841: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
842: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
843: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
844: ,p_effective_date in date
845: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
846: )
847: is

Line 845: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

841: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
842: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
843: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
844: ,p_effective_date in date
845: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
846: )
847: is
848: --
849: l_exists varchar2(1);

Line 852: l_vac_people_group_id per_all_assignments_f.people_group_id%TYPE;

848: --
849: l_exists varchar2(1);
850: l_api_updating boolean;
851: l_proc varchar2(72) := g_package||'chk_people_group_id';
852: l_vac_people_group_id per_all_assignments_f.people_group_id%TYPE;
853: l_enabled_flag pay_people_groups.enabled_flag%TYPE;
854: --
855: cursor csr_valid_people_group is
856: select enabled_flag

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

928: if csr_valid_people_group%notfound then
929: close csr_valid_people_group;
930: hr_utility.set_message(801, 'HR_7385_ASG_INV_PEOPLE_GROUP');
931: hr_multi_message.add
932: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
933: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
934: );
935: --
936: else

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

929: close csr_valid_people_group;
930: hr_utility.set_message(801, 'HR_7385_ASG_INV_PEOPLE_GROUP');
931: hr_multi_message.add
932: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
933: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
934: );
935: --
936: else
937: close csr_valid_people_group;

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

942: If l_enabled_flag <> 'Y' then
943: --
944: hr_utility.set_message(801, 'HR_51252_ASG_INV_PGP_ENBD_FLAG');
945: hr_multi_message.add
946: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
947: );
948: --
949: end if;
950: end if;

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

960: if csr_valid_id_flex_num%notfound then
961: close csr_valid_id_flex_num;
962: hr_utility.set_message(801, 'HR_7386_ASG_INV_PEOP_GRP_LINK');
963: hr_multi_message.add
964: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID'
965: );
966: --
967: else
968: close csr_valid_id_flex_num;

Line 984: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

980: -- |-------------------< chk_perf_review_period_freq >-----------------------|
981: -- ---------------------------------------------------------------------------
982: --
983: procedure chk_perf_review_period_freq
984: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
985: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
986: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
987: ,p_effective_date in date
988: ,p_validation_start_date in date

Line 985: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE

981: -- ---------------------------------------------------------------------------
982: --
983: procedure chk_perf_review_period_freq
984: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
985: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
986: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
987: ,p_effective_date in date
988: ,p_validation_start_date in date
989: ,p_validation_end_date in date

Line 986: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

982: --
983: procedure chk_perf_review_period_freq
984: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
985: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
986: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
987: ,p_effective_date in date
988: ,p_validation_start_date in date
989: ,p_validation_end_date in date
990: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 990: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

986: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
987: ,p_effective_date in date
988: ,p_validation_start_date in date
989: ,p_validation_end_date in date
990: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
991: )
992: is
993: --
994: l_proc varchar2(72) := g_package||'chk_perf_review_period_freq';

Line 1053: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'

1049: --
1050: hr_utility.set_message(801, 'HR_51178_ASG_INV_ASG_TYP_PRPF');
1051: hr_multi_message.add
1052: (p_associated_column1 =>
1053: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1054: );
1055: --
1056: end if;
1057: hr_utility.set_location(l_proc, 50);

Line 1077: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'

1073: --
1074: hr_utility.set_message(801, 'HR_51149_ASG_INV_PRP_FREQ');
1075: hr_multi_message.add
1076: (p_associated_column1 =>
1077: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1078: );
1079: --
1080: end if;
1081: hr_utility.set_location(l_proc, 60);

Line 1096: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1092: -- |-----------------------< chk_perf_review_period >------------------------|
1093: -- ---------------------------------------------------------------------------
1094: --
1095: procedure chk_perf_review_period
1096: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1097: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1098: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1099: ,p_effective_date in date
1100: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1097: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE

1093: -- ---------------------------------------------------------------------------
1094: --
1095: procedure chk_perf_review_period
1096: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1097: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1098: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1099: ,p_effective_date in date
1100: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1101: )

Line 1098: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1094: --
1095: procedure chk_perf_review_period
1096: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1097: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1098: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1099: ,p_effective_date in date
1100: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1101: )
1102: is

Line 1100: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1096: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1097: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1098: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1099: ,p_effective_date in date
1100: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1101: )
1102: is
1103: --
1104: l_proc varchar2(72) := g_package||'chk_perf_review_period';

Line 1161: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'

1157: exception
1158: when app_exception.application_exception then
1159: if hr_multi_message.exception_add
1160: (p_associated_column1 =>
1161: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1162: ) then
1163: hr_utility.set_location(' Leaving:'|| l_proc, 6);
1164: raise;
1165: end if;

Line 1174: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1170: -- |-------------------< chk_perf_rp_freq_perf_rp >--------------------------|
1171: -- ---------------------------------------------------------------------------
1172: --
1173: procedure chk_perf_rp_freq_perf_rp
1174: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1175: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
1176: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1177: ,p_effective_date in date
1178: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1175: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE

1171: -- ---------------------------------------------------------------------------
1172: --
1173: procedure chk_perf_rp_freq_perf_rp
1174: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1175: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
1176: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1177: ,p_effective_date in date
1178: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1179: )

Line 1176: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE

1172: --
1173: procedure chk_perf_rp_freq_perf_rp
1174: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1175: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
1176: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1177: ,p_effective_date in date
1178: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1179: )
1180: is

Line 1178: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1174: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1175: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
1176: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
1177: ,p_effective_date in date
1178: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1179: )
1180: is
1181: --
1182: l_proc varchar2(72):= g_package||'chk_perf_rp_freq_perf_rp';

Line 1190: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'

1186: hr_utility.set_location('Entering:'|| l_proc, 1);
1187: --
1188: if hr_multi_message.no_exclusive_error
1189: (p_check_column1 =>
1190: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1191: ,p_check_column2 =>
1192: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1193: ) then
1194: --

Line 1192: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'

1188: if hr_multi_message.no_exclusive_error
1189: (p_check_column1 =>
1190: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1191: ,p_check_column2 =>
1192: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1193: ) then
1194: --
1195: -- Check mandatory parameters have been set
1196: --

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

1249: --
1250: exception
1251: when app_exception.application_exception then
1252: if hr_multi_message.exception_add
1253: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1254: ,p_associated_column2 =>
1255: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1256: ) then
1257: hr_utility.set_location(' Leaving:'|| l_proc, 5);

Line 1255: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'

1251: when app_exception.application_exception then
1252: if hr_multi_message.exception_add
1253: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1254: ,p_associated_column2 =>
1255: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'
1256: ) then
1257: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1258: raise;
1259: end if;

Line 1268: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1264: -- |---------------------< chk_period_of_service_id >------------------------|
1265: -- ---------------------------------------------------------------------------
1266: --
1267: procedure chk_period_of_service_id
1268: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1269: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1270: ,p_person_id in per_all_assignments_f.person_id%TYPE
1271: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1272: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE

Line 1269: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1265: -- ---------------------------------------------------------------------------
1266: --
1267: procedure chk_period_of_service_id
1268: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1269: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1270: ,p_person_id in per_all_assignments_f.person_id%TYPE
1271: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1272: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
1273: ,p_validation_start_date in date

Line 1270: ,p_person_id in per_all_assignments_f.person_id%TYPE

1266: --
1267: procedure chk_period_of_service_id
1268: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1269: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1270: ,p_person_id in per_all_assignments_f.person_id%TYPE
1271: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1272: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
1273: ,p_validation_start_date in date
1274: ,p_validation_end_date in date

Line 1271: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1267: procedure chk_period_of_service_id
1268: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1269: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1270: ,p_person_id in per_all_assignments_f.person_id%TYPE
1271: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1272: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
1273: ,p_validation_start_date in date
1274: ,p_validation_end_date in date
1275: ,p_effective_date in date

Line 1272: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE

1268: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1269: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1270: ,p_person_id in per_all_assignments_f.person_id%TYPE
1271: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1272: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
1273: ,p_validation_start_date in date
1274: ,p_validation_end_date in date
1275: ,p_effective_date in date
1276: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1276: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1272: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
1273: ,p_validation_start_date in date
1274: ,p_validation_end_date in date
1275: ,p_effective_date in date
1276: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1277: )
1278: is
1279: --
1280: l_api_updating boolean;

Line 1284: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

1280: l_api_updating boolean;
1281: l_exists varchar2(1);
1282: l_proc varchar2(72):= g_package||'chk_period_of_service_id';
1283: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1284: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1285: --
1286: cursor csr_valid_pds is
1287: select business_group_id, actual_termination_date
1288: from per_periods_of_service

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

1344: If p_period_of_service_id is not null then
1345: --
1346: hr_utility.set_message(801, 'HR_51203_ASG_INV_ASG_TYP_PDS');
1347: hr_multi_message.add
1348: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1349: );
1350: --
1351: end if;
1352: hr_utility.set_location(l_proc, 50);

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

1371: if csr_valid_pds%notfound then
1372: close csr_valid_pds;
1373: hr_utility.set_message(801, 'HR_7391_ASG_INV_PERIOD_OF_SERV');
1374: hr_multi_message.add
1375: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1376: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1377: );
1378: --
1379: else

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

1372: close csr_valid_pds;
1373: hr_utility.set_message(801, 'HR_7391_ASG_INV_PERIOD_OF_SERV');
1374: hr_multi_message.add
1375: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1376: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1377: );
1378: --
1379: else
1380: close csr_valid_pds;

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

1387: If p_business_group_id <> l_business_group_id then
1388: --
1389: hr_utility.set_message(801, 'HR_51320_ASG_INV_PDS_BG');
1390: hr_multi_message.add
1391: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1392: );
1393: --
1394: end if;
1395: hr_utility.set_location(l_proc, 80);

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

1400: If p_validation_end_date > nvl(l_actual_termination_date, hr_api.g_eot) then
1401: --
1402: hr_utility.set_message(801, 'HR_6434_EMP_ASS_PER_CLOSED');
1403: hr_multi_message.add
1404: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1405: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1406: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
1407: );
1408: --

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

1401: --
1402: hr_utility.set_message(801, 'HR_6434_EMP_ASS_PER_CLOSED');
1403: hr_multi_message.add
1404: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1405: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1406: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
1407: );
1408: --
1409: end if;

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

1402: hr_utility.set_message(801, 'HR_6434_EMP_ASS_PER_CLOSED');
1403: hr_multi_message.add
1404: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
1405: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1406: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
1407: );
1408: --
1409: end if;
1410: hr_utility.set_location(l_proc, 90);

Line 1423: (p_person_id in per_all_assignments_f.person_id%TYPE

1419: -- |--------------------------< chk_person_id >------------------------------|
1420: -- ---------------------------------------------------------------------------
1421: --
1422: procedure chk_person_id
1423: (p_person_id in per_all_assignments_f.person_id%TYPE
1424: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1425: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
1426: )
1427: is

Line 1424: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1420: -- ---------------------------------------------------------------------------
1421: --
1422: procedure chk_person_id
1423: (p_person_id in per_all_assignments_f.person_id%TYPE
1424: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1425: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
1426: )
1427: is
1428: --

Line 1425: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE

1421: --
1422: procedure chk_person_id
1423: (p_person_id in per_all_assignments_f.person_id%TYPE
1424: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1425: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
1426: )
1427: is
1428: --
1429: l_exists varchar2(1);

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

1466: hr_utility.set_location(' Leaving:'|| l_proc, 3);
1467: exception
1468: when app_exception.application_exception then
1469: if hr_multi_message.exception_add
1470: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
1471: ) then
1472: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1473: raise;
1474: end if;

Line 1483: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1479: -- |---------------------< chk_person_referred_by_id >-----------------------|
1480: -- ---------------------------------------------------------------------------
1481: --
1482: procedure chk_person_referred_by_id
1483: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1485: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1486: ,p_person_id in per_all_assignments_f.person_id%TYPE
1487: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE

Line 1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1480: -- ---------------------------------------------------------------------------
1481: --
1482: procedure chk_person_referred_by_id
1483: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1485: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1486: ,p_person_id in per_all_assignments_f.person_id%TYPE
1487: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
1488: ,p_effective_date in date

Line 1485: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1481: --
1482: procedure chk_person_referred_by_id
1483: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1485: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1486: ,p_person_id in per_all_assignments_f.person_id%TYPE
1487: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
1488: ,p_effective_date in date
1489: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1486: ,p_person_id in per_all_assignments_f.person_id%TYPE

1482: procedure chk_person_referred_by_id
1483: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1485: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1486: ,p_person_id in per_all_assignments_f.person_id%TYPE
1487: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
1488: ,p_effective_date in date
1489: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1490: ,p_validation_start_date in date

Line 1487: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE

1483: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1484: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1485: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1486: ,p_person_id in per_all_assignments_f.person_id%TYPE
1487: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
1488: ,p_effective_date in date
1489: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1490: ,p_validation_start_date in date
1491: ,p_validation_end_date in date

Line 1489: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1485: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1486: ,p_person_id in per_all_assignments_f.person_id%TYPE
1487: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
1488: ,p_effective_date in date
1489: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1490: ,p_validation_start_date in date
1491: ,p_validation_end_date in date
1492: )
1493: is

Line 1498: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

1494: --
1495: l_proc varchar2(72) := g_package||'chk_person_referred_by_id';
1496: l_api_updating boolean;
1497: l_exists varchar2(1);
1498: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1499: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
1500: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
1501: --
1502: cursor csr_val_prb_id is

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

1557: if p_assignment_type in ('E','B','C')then
1558: --
1559: hr_utility.set_message(801, 'HR_51224_ASG_INV_ASG_TYP_PRB');
1560: hr_multi_message.add
1561: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1562: );
1563: --
1564: end if;
1565: hr_utility.set_location(l_proc, 50);

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

1570: If p_person_referred_by_id = p_person_id then
1571: --
1572: hr_utility.set_message(801, 'HR_51304_ASG_APL_EQUAL_PRB');
1573: hr_multi_message.add
1574: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1575: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
1576: );
1577: --
1578: end if;

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

1571: --
1572: hr_utility.set_message(801, 'HR_51304_ASG_APL_EQUAL_PRB');
1573: hr_multi_message.add
1574: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1575: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
1576: );
1577: --
1578: end if;
1579: hr_utility.set_location(l_proc, 60);

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

1595: then
1596: --
1597: hr_utility.set_message(801, 'HR_51302_ASG_INV_PER_REF_BY');
1598: hr_multi_message.add
1599: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1600: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1601: );
1602: --
1603: end if;

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

1596: --
1597: hr_utility.set_message(801, 'HR_51302_ASG_INV_PER_REF_BY');
1598: hr_multi_message.add
1599: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1600: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1601: );
1602: --
1603: end if;
1604: --

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

1615: then
1616: --
1617: hr_utility.set_message(801, 'HR_51303_ASG_INV_PER_REF_BY_BG');
1618: hr_multi_message.add
1619: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID'
1620: );
1621: --
1622: end if;
1623: hr_utility.set_location(l_proc, 80);

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

1632: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
1633: nvl(l_current_npw_flag, 'N') = 'Y') ) then
1634: hr_utility.set_message(801, 'HR_51305_ASG_PER_RB_NOT_EMP');
1635: hr_multi_message.add
1636: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID');
1637: --
1638: end if;
1639: hr_utility.set_location(l_proc, 90);
1640: --

Line 1653: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1649: -- |------------------------< chk_position_id >------------------------------|
1650: -- ---------------------------------------------------------------------------
1651: --
1652: procedure chk_position_id
1653: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1654: ,p_position_id in per_all_assignments_f.position_id%TYPE
1655: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1656: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1657: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

Line 1654: ,p_position_id in per_all_assignments_f.position_id%TYPE

1650: -- ---------------------------------------------------------------------------
1651: --
1652: procedure chk_position_id
1653: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1654: ,p_position_id in per_all_assignments_f.position_id%TYPE
1655: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1656: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1657: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1658: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 1655: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

1651: --
1652: procedure chk_position_id
1653: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1654: ,p_position_id in per_all_assignments_f.position_id%TYPE
1655: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1656: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1657: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1658: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1659: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 1656: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

1652: procedure chk_position_id
1653: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1654: ,p_position_id in per_all_assignments_f.position_id%TYPE
1655: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1656: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1657: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1658: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1659: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1660: ,p_effective_date in date

Line 1657: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

1653: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1654: ,p_position_id in per_all_assignments_f.position_id%TYPE
1655: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1656: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1657: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1658: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1659: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1660: ,p_effective_date in date
1661: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1658: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

1654: ,p_position_id in per_all_assignments_f.position_id%TYPE
1655: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1656: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1657: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1658: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1659: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1660: ,p_effective_date in date
1661: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1662: )

Line 1659: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

1655: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1656: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1657: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1658: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1659: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1660: ,p_effective_date in date
1661: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1662: )
1663: is

Line 1661: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1657: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1658: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1659: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1660: ,p_effective_date in date
1661: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1662: )
1663: is
1664: --
1665: l_proc varchar2(72) := g_package||'chk_position_id';

Line 1668: l_position_id per_all_assignments_f.position_id%TYPE;

1664: --
1665: l_proc varchar2(72) := g_package||'chk_position_id';
1666: l_exists varchar2(1);
1667: l_api_updating boolean;
1668: l_position_id per_all_assignments_f.position_id%TYPE;
1669: l_pos_bus_group_id per_all_assignments_f.business_group_id%TYPE;
1670: l_vac_position_id per_all_assignments_f.position_id%TYPE;
1671: --
1672: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) date tracked position requirement

Line 1669: l_pos_bus_group_id per_all_assignments_f.business_group_id%TYPE;

1665: l_proc varchar2(72) := g_package||'chk_position_id';
1666: l_exists varchar2(1);
1667: l_api_updating boolean;
1668: l_position_id per_all_assignments_f.position_id%TYPE;
1669: l_pos_bus_group_id per_all_assignments_f.business_group_id%TYPE;
1670: l_vac_position_id per_all_assignments_f.position_id%TYPE;
1671: --
1672: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) date tracked position requirement
1673:

Line 1670: l_vac_position_id per_all_assignments_f.position_id%TYPE;

1666: l_exists varchar2(1);
1667: l_api_updating boolean;
1668: l_position_id per_all_assignments_f.position_id%TYPE;
1669: l_pos_bus_group_id per_all_assignments_f.business_group_id%TYPE;
1670: l_vac_position_id per_all_assignments_f.position_id%TYPE;
1671: --
1672: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions_f) date tracked position requirement
1673:
1674: cursor csr_valid_pos is

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

1745: if csr_valid_pos%notfound then
1746: close csr_valid_pos;
1747: hr_utility.set_message(801, 'HR_51000_ASG_INVALID_POS');
1748: hr_multi_message.add
1749: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1750: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1751: );
1752: else
1753: close csr_valid_pos;

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

1746: close csr_valid_pos;
1747: hr_utility.set_message(801, 'HR_51000_ASG_INVALID_POS');
1748: hr_multi_message.add
1749: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1750: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
1751: );
1752: else
1753: close csr_valid_pos;
1754: end if;

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

1760: if l_pos_bus_group_id <> p_business_group_id then
1761: --
1762: hr_utility.set_message(801, 'HR_51009_ASG_INVALID_BG_POS');
1763: hr_multi_message.add
1764: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1765: );
1766: --
1767: end if;
1768: hr_utility.set_location(l_proc, 50);

Line 1783: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1779: -------------------< chk_position_id_grade_id >-------------------------------
1780: ------------------------------------------------------------------------------
1781: --
1782: procedure chk_position_id_grade_id
1783: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1784: ,p_position_id in per_all_assignments_f.position_id%TYPE
1785: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1786: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1787: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 1784: ,p_position_id in per_all_assignments_f.position_id%TYPE

1780: ------------------------------------------------------------------------------
1781: --
1782: procedure chk_position_id_grade_id
1783: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1784: ,p_position_id in per_all_assignments_f.position_id%TYPE
1785: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1786: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1787: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1788: ,p_effective_date in date

Line 1785: ,p_grade_id in per_all_assignments_f.grade_id%TYPE

1781: --
1782: procedure chk_position_id_grade_id
1783: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1784: ,p_position_id in per_all_assignments_f.position_id%TYPE
1785: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1786: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1787: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1788: ,p_effective_date in date
1789: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1786: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

1782: procedure chk_position_id_grade_id
1783: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1784: ,p_position_id in per_all_assignments_f.position_id%TYPE
1785: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1786: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1787: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1788: ,p_effective_date in date
1789: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1790: ,p_inv_pos_grade_warning out nocopy boolean

Line 1787: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

1783: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1784: ,p_position_id in per_all_assignments_f.position_id%TYPE
1785: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1786: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1787: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1788: ,p_effective_date in date
1789: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1790: ,p_inv_pos_grade_warning out nocopy boolean
1791: )

Line 1789: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1785: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1786: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1787: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1788: ,p_effective_date in date
1789: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1790: ,p_inv_pos_grade_warning out nocopy boolean
1791: )
1792: as
1793: l_proc varchar2(72) := g_package||'chk_position_id_grade_id';

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

1823: --
1824: hr_utility.set_location('Entering:'|| l_proc, 1);
1825: --
1826: if hr_multi_message.no_exclusive_error
1827: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1828: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
1829: ) then
1830: --
1831: -- Check mandatory parameters have been set

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

1824: hr_utility.set_location('Entering:'|| l_proc, 1);
1825: --
1826: if hr_multi_message.no_exclusive_error
1827: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1828: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
1829: ) then
1830: --
1831: -- Check mandatory parameters have been set
1832: --

Line 1916: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

1912: --------------------------< chk_position_id_org_id >--------------------------
1913: ------------------------------------------------------------------------------
1914: --
1915: procedure chk_position_id_org_id
1916: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1917: ,p_position_id in per_all_assignments_f.position_id%TYPE
1918: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1919: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1920: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 1917: ,p_position_id in per_all_assignments_f.position_id%TYPE

1913: ------------------------------------------------------------------------------
1914: --
1915: procedure chk_position_id_org_id
1916: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1917: ,p_position_id in per_all_assignments_f.position_id%TYPE
1918: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1919: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1920: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1921: ,p_effective_date in date

Line 1918: ,p_organization_id in per_all_assignments_f.organization_id%TYPE

1914: --
1915: procedure chk_position_id_org_id
1916: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1917: ,p_position_id in per_all_assignments_f.position_id%TYPE
1918: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1919: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1920: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1921: ,p_effective_date in date
1922: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 1919: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

1915: procedure chk_position_id_org_id
1916: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1917: ,p_position_id in per_all_assignments_f.position_id%TYPE
1918: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1919: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1920: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1921: ,p_effective_date in date
1922: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1923: )

Line 1920: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

1916: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1917: ,p_position_id in per_all_assignments_f.position_id%TYPE
1918: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1919: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1920: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1921: ,p_effective_date in date
1922: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1923: )
1924: as

Line 1922: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1918: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
1919: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1920: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1921: ,p_effective_date in date
1922: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1923: )
1924: as
1925: l_proc varchar2(72) := g_package||'chk_position_id_org_id';
1926: l_exists varchar2(1);

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

1948: --
1949: hr_utility.set_location('Entering:'|| l_proc, 1);
1950: --
1951: if hr_multi_message.no_exclusive_error
1952: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1953: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
1954: ) then
1955: --
1956: -- Check mandatory parameters have been set

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

1949: hr_utility.set_location('Entering:'|| l_proc, 1);
1950: --
1951: if hr_multi_message.no_exclusive_error
1952: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1953: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
1954: ) then
1955: --
1956: -- Check mandatory parameters have been set
1957: --

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

2018: hr_utility.set_location('Leaving'||l_proc, 4);
2019: exception
2020: when app_exception.application_exception then
2021: if hr_multi_message.exception_add
2022: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2023: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
2024: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2025: ) then
2026: hr_utility.set_location(' Leaving:'|| l_proc, 5);

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

2019: exception
2020: when app_exception.application_exception then
2021: if hr_multi_message.exception_add
2022: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2023: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
2024: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2025: ) then
2026: hr_utility.set_location(' Leaving:'|| l_proc, 5);
2027: raise;

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

2020: when app_exception.application_exception then
2021: if hr_multi_message.exception_add
2022: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2023: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
2024: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2025: ) then
2026: hr_utility.set_location(' Leaving:'|| l_proc, 5);
2027: raise;
2028: end if;

Line 2037: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2033: -------------------------< chk_position_id_job_id >---------------------------
2034: ------------------------------------------------------------------------------
2035: --
2036: procedure chk_position_id_job_id
2037: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2038: ,p_position_id in per_all_assignments_f.position_id%TYPE
2039: ,p_job_id in per_all_assignments_f.job_id%TYPE
2040: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2041: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 2038: ,p_position_id in per_all_assignments_f.position_id%TYPE

2034: ------------------------------------------------------------------------------
2035: --
2036: procedure chk_position_id_job_id
2037: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2038: ,p_position_id in per_all_assignments_f.position_id%TYPE
2039: ,p_job_id in per_all_assignments_f.job_id%TYPE
2040: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2041: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2042: ,p_effective_date in date

Line 2039: ,p_job_id in per_all_assignments_f.job_id%TYPE

2035: --
2036: procedure chk_position_id_job_id
2037: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2038: ,p_position_id in per_all_assignments_f.position_id%TYPE
2039: ,p_job_id in per_all_assignments_f.job_id%TYPE
2040: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2041: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2042: ,p_effective_date in date
2043: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 2040: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

2036: procedure chk_position_id_job_id
2037: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2038: ,p_position_id in per_all_assignments_f.position_id%TYPE
2039: ,p_job_id in per_all_assignments_f.job_id%TYPE
2040: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2041: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2042: ,p_effective_date in date
2043: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2044: )

Line 2041: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

2037: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2038: ,p_position_id in per_all_assignments_f.position_id%TYPE
2039: ,p_job_id in per_all_assignments_f.job_id%TYPE
2040: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2041: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2042: ,p_effective_date in date
2043: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2044: )
2045: as

Line 2043: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2039: ,p_job_id in per_all_assignments_f.job_id%TYPE
2040: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2041: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2042: ,p_effective_date in date
2043: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2044: )
2045: as
2046: l_proc varchar2(72) := g_package||'chk_position_id_job_id';
2047: l_exists varchar2(1);

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

2067: begin
2068: hr_utility.set_location('Entering:'|| l_proc, 10);
2069: --
2070: if hr_multi_message.no_exclusive_error
2071: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2072: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2073: ) then
2074: --
2075: -- Check mandatory parameters have been set

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

2068: hr_utility.set_location('Entering:'|| l_proc, 10);
2069: --
2070: if hr_multi_message.no_exclusive_error
2071: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2072: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2073: ) then
2074: --
2075: -- Check mandatory parameters have been set
2076: --

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

2126: if csr_valid_pos_job_comb%notfound then
2127: close csr_valid_pos_job_comb;
2128: hr_utility.set_message(801, 'HR_51056_ASG_INV_POS_JOB_COMB');
2129: hr_multi_message.add
2130: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2131: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2132: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2133: );
2134: else

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

2127: close csr_valid_pos_job_comb;
2128: hr_utility.set_message(801, 'HR_51056_ASG_INV_POS_JOB_COMB');
2129: hr_multi_message.add
2130: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2131: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2132: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2133: );
2134: else
2135: close csr_valid_pos_job_comb;

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

2128: hr_utility.set_message(801, 'HR_51056_ASG_INV_POS_JOB_COMB');
2129: hr_multi_message.add
2130: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2131: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2132: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2133: );
2134: else
2135: close csr_valid_pos_job_comb;
2136: end if;

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

2140: -- Position is not null but job is null
2141: --
2142: hr_utility.set_message(801, 'HR_51057_ASG_JOB_NULL_VALUE');
2143: hr_multi_message.add
2144: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2145: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2146: );
2147: --
2148: end if;

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

2141: --
2142: hr_utility.set_message(801, 'HR_51057_ASG_JOB_NULL_VALUE');
2143: hr_multi_message.add
2144: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
2145: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2146: );
2147: --
2148: end if;
2149: --

Line 2161: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2157: -- |-------------------------< chk_primary_flag >----------------------------|
2158: -- ---------------------------------------------------------------------------
2159: --
2160: procedure chk_primary_flag
2161: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2162: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
2163: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2164: ,p_person_id in per_all_assignments_f.person_id%TYPE
2165: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE

Line 2162: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE

2158: -- ---------------------------------------------------------------------------
2159: --
2160: procedure chk_primary_flag
2161: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2162: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
2163: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2164: ,p_person_id in per_all_assignments_f.person_id%TYPE
2165: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
2166: ,p_pop_date_start in DATE

Line 2163: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

2159: --
2160: procedure chk_primary_flag
2161: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2162: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
2163: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2164: ,p_person_id in per_all_assignments_f.person_id%TYPE
2165: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
2166: ,p_pop_date_start in DATE
2167: ,p_effective_date in date

Line 2164: ,p_person_id in per_all_assignments_f.person_id%TYPE

2160: procedure chk_primary_flag
2161: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2162: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
2163: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2164: ,p_person_id in per_all_assignments_f.person_id%TYPE
2165: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
2166: ,p_pop_date_start in DATE
2167: ,p_effective_date in date
2168: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 2165: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE

2161: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2162: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
2163: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2164: ,p_person_id in per_all_assignments_f.person_id%TYPE
2165: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
2166: ,p_pop_date_start in DATE
2167: ,p_effective_date in date
2168: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2169: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 2168: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2164: ,p_person_id in per_all_assignments_f.person_id%TYPE
2165: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
2166: ,p_pop_date_start in DATE
2167: ,p_effective_date in date
2168: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2169: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2170: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2171: ) is
2172: --

Line 2169: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

2165: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
2166: ,p_pop_date_start in DATE
2167: ,p_effective_date in date
2168: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2169: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2170: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2171: ) is
2172: --
2173: l_exists varchar2(1);

Line 2170: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

2166: ,p_pop_date_start in DATE
2167: ,p_effective_date in date
2168: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2169: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2170: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
2171: ) is
2172: --
2173: l_exists varchar2(1);
2174: l_proc varchar2(72) := g_package||'chk_primary_flag';

Line 2179: from per_all_assignments_f

2175: l_api_updating boolean;
2176: --
2177: cursor csr_asg_exists is
2178: select null
2179: from per_all_assignments_f
2180: where person_id = p_person_id
2181: and period_of_service_id = p_period_of_service_id
2182: and primary_flag = 'Y';
2183: --

Line 2186: from per_all_assignments_f

2182: and primary_flag = 'Y';
2183: --
2184: cursor csr_cwk_asg_exists is
2185: select null
2186: from per_all_assignments_f
2187: where person_id = p_person_id
2188: and period_of_placement_date_start = p_pop_date_start
2189: and primary_flag = 'Y';
2190: --

Line 2240: from per_all_assignments_f pas

2236: select null
2237: from sys.dual
2238: where exists
2239: (select null
2240: from per_all_assignments_f pas
2241: where pas.effective_start_date <= p_validation_start_date
2242: and pas.person_id = p_person_id
2243: and pas.period_of_service_id = p_period_of_service_id
2244: --

Line 2251: from per_all_assignments_f pas1

2247: --and pas.primary_flag = 'Y');
2248: and pas.primary_flag = 'Y')
2249: or (csr_ins_non_prim.p_per_system_status = 'TERM_ASSIGN' and exists
2250: (select null
2251: from per_all_assignments_f pas1
2252: where pas1.effective_start_date <= p_validation_start_date
2253: and pas1.person_id = p_person_id
2254: and pas1.period_of_service_id <> p_period_of_service_id
2255: and pas1.primary_flag = 'Y'

Line 2267: from per_all_assignments_f pas

2263: select null
2264: from sys.dual
2265: where exists
2266: (select null
2267: from per_all_assignments_f pas
2268: where pas.effective_start_date <= p_validation_start_date
2269: and pas.person_id = p_person_id
2270: and pas.period_of_placement_date_start = p_pop_date_start
2271: and pas.primary_flag = 'Y');

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

2345: --
2346: hr_utility.set_message(801, 'HR_51198_ASG_INV_APL_ASG_PF');
2347: --
2348: hr_multi_message.add
2349: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PRIMARY_FLAG');
2350: --
2351: end if;
2352: --
2353: hr_utility.set_location(l_proc, 50);

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

2358: --
2359: hr_utility.set_message(801, 'HR_51323_ASG_INV_PRIM_ASG_EED');
2360: --
2361: hr_multi_message.add
2362: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2363: --
2364: end if;
2365: --
2366: hr_utility.set_location(l_proc, 60);

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

2365: --
2366: hr_utility.set_location(l_proc, 60);
2367: --
2368: if hr_multi_message.no_exclusive_error
2369: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2370: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
2371: --
2372: hr_utility.set_location(l_proc, 70);
2373: --

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

2366: hr_utility.set_location(l_proc, 60);
2367: --
2368: if hr_multi_message.no_exclusive_error
2369: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2370: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
2371: --
2372: hr_utility.set_location(l_proc, 70);
2373: --
2374: if p_assignment_type = 'C' then

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

2384: --
2385: hr_utility.set_message(801, 'HR_7435_ASG_PRIM_ASS_EXISTS');
2386: --
2387: hr_multi_message.add
2388: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2389: ,p_associated_column2 =>
2390: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START');
2391: --
2392: else

Line 2390: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START');

2386: --
2387: hr_multi_message.add
2388: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2389: ,p_associated_column2 =>
2390: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START');
2391: --
2392: else
2393: --
2394: close csr_cwk_asg_exists;

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

2412: --
2413: hr_utility.set_message(801, 'HR_7435_ASG_PRIM_ASS_EXISTS');
2414: --
2415: hr_multi_message.add
2416: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2417: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID');
2418: --
2419: else
2420: --

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

2413: hr_utility.set_message(801, 'HR_7435_ASG_PRIM_ASS_EXISTS');
2414: --
2415: hr_multi_message.add
2416: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2417: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID');
2418: --
2419: else
2420: --
2421: close csr_asg_exists;

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

2444: --
2445: hr_utility.set_location(l_proc, 140);
2446: --
2447: if hr_multi_message.no_exclusive_error
2448: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2449: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
2450: --
2451: hr_utility.set_location(l_proc, 150);
2452: --

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

2445: hr_utility.set_location(l_proc, 140);
2446: --
2447: if hr_multi_message.no_exclusive_error
2448: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2449: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
2450: --
2451: hr_utility.set_location(l_proc, 150);
2452: --
2453: -- Check that the primary cwk assignment exists during

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

2466: --
2467: hr_utility.set_message(801, 'HR_7436_ASG_NO_PRIM_ASS');
2468: --
2469: hr_multi_message.add
2470: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2471: ,p_associated_column2 =>
2472: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START'
2473: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2474: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');

Line 2472: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START'

2468: --
2469: hr_multi_message.add
2470: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2471: ,p_associated_column2 =>
2472: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START'
2473: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2474: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2475: --
2476: else

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

2469: hr_multi_message.add
2470: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2471: ,p_associated_column2 =>
2472: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START'
2473: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2474: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2475: --
2476: else
2477: --

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

2470: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2471: ,p_associated_column2 =>
2472: 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_PLACEMENT_DATE_START'
2473: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2474: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2475: --
2476: else
2477: --
2478: close csr_ins_non_cwk_prim;

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

2521: --
2522: hr_utility.set_message(801, 'HR_7436_ASG_NO_PRIM_ASS');
2523: --
2524: hr_multi_message.add
2525: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2526: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2527: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2528: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2529: --

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

2522: hr_utility.set_message(801, 'HR_7436_ASG_NO_PRIM_ASS');
2523: --
2524: hr_multi_message.add
2525: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2526: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2527: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2528: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2529: --
2530: else

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

2523: --
2524: hr_multi_message.add
2525: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2526: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2527: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2528: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2529: --
2530: else
2531: --

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

2524: hr_multi_message.add
2525: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2526: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'
2527: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2528: ,p_associated_column4 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE');
2529: --
2530: else
2531: --
2532: close csr_ins_non_prim;

Line 2558: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2554: -- ---------------------------------------------------------------------------
2555: -- |----------------------< chk_probation_period >---------------------------|
2556: -- ---------------------------------------------------------------------------
2557: procedure chk_probation_period
2558: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2559: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2560: ,p_effective_date in date
2561: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2562: )

Line 2559: ,p_probation_period in per_all_assignments_f.probation_period%TYPE

2555: -- |----------------------< chk_probation_period >---------------------------|
2556: -- ---------------------------------------------------------------------------
2557: procedure chk_probation_period
2558: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2559: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2560: ,p_effective_date in date
2561: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2562: )
2563: is

Line 2561: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2557: procedure chk_probation_period
2558: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2559: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2560: ,p_effective_date in date
2561: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2562: )
2563: is
2564: --
2565: l_proc varchar2(72) := g_package||'chk_probation_period';

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

2612: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2613: exception
2614: when app_exception.application_exception then
2615: if hr_multi_message.exception_add
2616: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2617: ) then
2618: hr_utility.set_location(' Leaving:'|| l_proc, 70);
2619: raise;
2620: end if;

Line 2630: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2626: -- |------------------------< chk_probation_unit >---------------------------|
2627: -- ---------------------------------------------------------------------------
2628: --
2629: procedure chk_probation_unit
2630: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2631: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2632: ,p_effective_date in date
2633: ,p_validation_start_date in date
2634: ,p_validation_end_date in date

Line 2631: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE

2627: -- ---------------------------------------------------------------------------
2628: --
2629: procedure chk_probation_unit
2630: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2631: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2632: ,p_effective_date in date
2633: ,p_validation_start_date in date
2634: ,p_validation_end_date in date
2635: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 2635: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2631: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2632: ,p_effective_date in date
2633: ,p_validation_start_date in date
2634: ,p_validation_end_date in date
2635: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2636: )
2637: is
2638: --
2639: l_proc varchar2(72) := g_package||'chk_probation_unit';

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

2712: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2713: exception
2714: when app_exception.application_exception then
2715: if hr_multi_message.exception_add
2716: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2717: ) then
2718: hr_utility.set_location(' Leaving:'|| l_proc, 70);
2719: raise;
2720: end if;

Line 2729: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2725: -- |-------------------< chk_prob_unit_prob_period >-------------------------|
2726: -- ---------------------------------------------------------------------------
2727: --
2728: procedure chk_prob_unit_prob_period
2729: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2730: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2731: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2732: ,p_effective_date in date
2733: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 2730: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE

2726: -- ---------------------------------------------------------------------------
2727: --
2728: procedure chk_prob_unit_prob_period
2729: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2730: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2731: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2732: ,p_effective_date in date
2733: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2734: )

Line 2731: ,p_probation_period in per_all_assignments_f.probation_period%TYPE

2727: --
2728: procedure chk_prob_unit_prob_period
2729: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2730: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2731: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2732: ,p_effective_date in date
2733: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2734: )
2735: is

Line 2733: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2729: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2730: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2731: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2732: ,p_effective_date in date
2733: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2734: )
2735: is
2736: --
2737: l_proc varchar2(72):= g_package||'chk_prob_unit_prob_period';

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

2742: --
2743: -- Check mandatory parameters have been set
2744: --
2745: if hr_multi_message.no_exclusive_error
2746: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2747: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2748: ) then
2749: hr_api.mandatory_arg_error
2750: (p_api_name => l_proc

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

2743: -- Check mandatory parameters have been set
2744: --
2745: if hr_multi_message.no_exclusive_error
2746: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2747: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2748: ) then
2749: hr_api.mandatory_arg_error
2750: (p_api_name => l_proc
2751: ,p_argument => 'effective_date'

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

2795: hr_utility.set_location(' Leaving:'|| l_proc, 4);
2796: exception
2797: when app_exception.application_exception then
2798: if hr_multi_message.exception_add
2799: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2800: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2801: ) then
2802: hr_utility.set_location(' Leaving:'|| l_proc, 5);
2803: raise;

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

2796: exception
2797: when app_exception.application_exception then
2798: if hr_multi_message.exception_add
2799: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2800: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2801: ) then
2802: hr_utility.set_location(' Leaving:'|| l_proc, 5);
2803: raise;
2804: end if;

Line 2814: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2810: -- |------------------------< chk_recruiter_id >-----------------------------|
2811: -- ---------------------------------------------------------------------------
2812: --
2813: procedure chk_recruiter_id
2814: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2815: ,p_person_id in per_all_assignments_f.person_id%TYPE
2816: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2817: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2818: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE

Line 2815: ,p_person_id in per_all_assignments_f.person_id%TYPE

2811: -- ---------------------------------------------------------------------------
2812: --
2813: procedure chk_recruiter_id
2814: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2815: ,p_person_id in per_all_assignments_f.person_id%TYPE
2816: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2817: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2818: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
2819: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

Line 2816: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

2812: --
2813: procedure chk_recruiter_id
2814: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2815: ,p_person_id in per_all_assignments_f.person_id%TYPE
2816: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2817: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2818: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
2819: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
2820: ,p_effective_date in date

Line 2817: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

2813: procedure chk_recruiter_id
2814: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2815: ,p_person_id in per_all_assignments_f.person_id%TYPE
2816: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2817: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2818: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
2819: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
2820: ,p_effective_date in date
2821: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 2818: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE

2814: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2815: ,p_person_id in per_all_assignments_f.person_id%TYPE
2816: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2817: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2818: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
2819: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
2820: ,p_effective_date in date
2821: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2822: ,p_validation_start_date in date

Line 2819: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

2815: ,p_person_id in per_all_assignments_f.person_id%TYPE
2816: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2817: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2818: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
2819: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
2820: ,p_effective_date in date
2821: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2822: ,p_validation_start_date in date
2823: ,p_validation_end_date in date

Line 2821: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2817: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2818: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
2819: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
2820: ,p_effective_date in date
2821: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2822: ,p_validation_start_date in date
2823: ,p_validation_end_date in date
2824: )
2825: is

Line 2829: l_vac_recruiter_id per_all_assignments_f.recruiter_id%TYPE;

2825: is
2826: --
2827: l_proc varchar2(72) := g_package||'chk_recruiter_id';
2828: l_api_updating boolean;
2829: l_vac_recruiter_id per_all_assignments_f.recruiter_id%TYPE;
2830: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2831: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
2832: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
2833: --

Line 2830: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

2826: --
2827: l_proc varchar2(72) := g_package||'chk_recruiter_id';
2828: l_api_updating boolean;
2829: l_vac_recruiter_id per_all_assignments_f.recruiter_id%TYPE;
2830: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2831: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
2832: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
2833: --
2834: cursor csr_val_recruiter is

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

2893: then
2894: --
2895: hr_utility.set_message(801, 'HR_51216_ASG_INV_ASG_TYP_REC');
2896: hr_multi_message.add
2897: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2898: );
2899: --
2900: end if;
2901: hr_utility.set_location(l_proc, 70);

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

2906: If p_recruiter_id = p_person_id then
2907: --
2908: hr_utility.set_message(801, 'HR_51289_ASG_APL_EQUAL_RECRUIT');
2909: hr_multi_message.add
2910: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2911: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2912: );
2913: --
2914: end if;

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

2907: --
2908: hr_utility.set_message(801, 'HR_51289_ASG_APL_EQUAL_RECRUIT');
2909: hr_multi_message.add
2910: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2911: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
2912: );
2913: --
2914: end if;
2915: hr_utility.set_location(l_proc, 80);

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

2923: if csr_val_recruiter%notfound then
2924: close csr_val_recruiter;
2925: hr_utility.set_message(801, 'HR_51280_ASG_INV_RECRUIT_ID');
2926: hr_multi_message.add
2927: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2928: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2929: );
2930: --
2931: else

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

2924: close csr_val_recruiter;
2925: hr_utility.set_message(801, 'HR_51280_ASG_INV_RECRUIT_ID');
2926: hr_multi_message.add
2927: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
2928: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2929: );
2930: --
2931: else
2932: close csr_val_recruiter;

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

2942: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
2943: nvl(l_current_npw_flag, 'N') = 'Y') ) then
2944: hr_utility.set_message(801, 'HR_51290_ASG_RECRUIT_NOT_EMP');
2945: hr_multi_message.add
2946: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID');
2947: end if;
2948: hr_utility.set_location(l_proc, 100);
2949: --
2950: -- Check that the recruiter is in the same business group

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

2955: then
2956: --
2957: hr_utility.set_message(801, 'HR_51284_ASG_INV_RECRUIT_BG');
2958: hr_multi_message.add
2959: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITER_ID'
2960: );
2961: --
2962: end if;
2963: hr_utility.set_location(l_proc, 110);

Line 2977: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

2973: -- |--------------------< chk_recruitment_activity_id >----------------------|
2974: -- ---------------------------------------------------------------------------
2975: --
2976: procedure chk_recruitment_activity_id
2977: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2978: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2979: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2980: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
2981: ,p_effective_date in date

Line 2978: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

2974: -- ---------------------------------------------------------------------------
2975: --
2976: procedure chk_recruitment_activity_id
2977: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2978: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2979: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2980: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
2981: ,p_effective_date in date
2982: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 2979: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

2975: --
2976: procedure chk_recruitment_activity_id
2977: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2978: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2979: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2980: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
2981: ,p_effective_date in date
2982: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2983: ,p_validation_start_date in date

Line 2980: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE

2976: procedure chk_recruitment_activity_id
2977: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2978: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2979: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2980: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
2981: ,p_effective_date in date
2982: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2983: ,p_validation_start_date in date
2984: ,p_validation_end_date in date

Line 2982: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

2978: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2979: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
2980: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
2981: ,p_effective_date in date
2982: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2983: ,p_validation_start_date in date
2984: ,p_validation_end_date in date
2985: )
2986: is

Line 2991: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

2987: --
2988: l_proc varchar2(72) := g_package||'chk_recruitment_activity_id';
2989: l_api_updating boolean;
2990: l_exists varchar2(1);
2991: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2992: --
2993: cursor csr_val_rec_act_id is
2994: select business_group_id
2995: from per_recruitment_activities

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

3049: if p_assignment_type in ('E','C','B') then
3050: --
3051: hr_utility.set_message(801, 'HR_51223_ASG_INV_ASG_TYP_RCAT');
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, 50);

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

3070: if p_assignment_type <> 'O'
3071: then
3072: hr_utility.set_message(801, 'HR_51306_ASG_INV_REC_ACT');
3073: hr_multi_message.add
3074: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3075: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3076: );
3077: --
3078: end if;

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

3071: then
3072: hr_utility.set_message(801, 'HR_51306_ASG_INV_REC_ACT');
3073: hr_multi_message.add
3074: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3075: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3076: );
3077: --
3078: end if;
3079: --

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

3089: If p_business_group_id <> l_business_group_id then
3090: --
3091: hr_utility.set_message(801, 'HR_51307_ASG_INV_REC_ACT_BG');
3092: hr_multi_message.add
3093: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
3094: );
3095: --
3096: end if;
3097: hr_utility.set_location(l_proc, 70);

Line 3144: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3140: -- If child rows exist in any of the tables listed above, an application
3141: -- error is raised and processing is terminated.
3142: --
3143: procedure chk_ref_int_del
3144: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3145: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
3146: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
3147: ,p_datetrack_mode in varchar2
3148: )

Line 3145: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

3141: -- error is raised and processing is terminated.
3142: --
3143: procedure chk_ref_int_del
3144: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3145: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
3146: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
3147: ,p_datetrack_mode in varchar2
3148: )
3149: is

Line 3146: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

3142: --
3143: procedure chk_ref_int_del
3144: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3145: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
3146: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
3147: ,p_datetrack_mode in varchar2
3148: )
3149: is
3150: --

Line 3431: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3427: -- |---------------------< chk_sal_review_period_freq >----------------------|
3428: -- ---------------------------------------------------------------------------
3429: --
3430: procedure chk_sal_review_period_freq
3431: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3432: ,p_sal_review_period_frequency in
3433: per_all_assignments_f.sal_review_period_frequency%TYPE
3434: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3435: ,p_effective_date in date

Line 3433: per_all_assignments_f.sal_review_period_frequency%TYPE

3429: --
3430: procedure chk_sal_review_period_freq
3431: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3432: ,p_sal_review_period_frequency in
3433: per_all_assignments_f.sal_review_period_frequency%TYPE
3434: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3435: ,p_effective_date in date
3436: ,p_validation_start_date in date
3437: ,p_validation_end_date in date

Line 3434: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

3430: procedure chk_sal_review_period_freq
3431: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3432: ,p_sal_review_period_frequency in
3433: per_all_assignments_f.sal_review_period_frequency%TYPE
3434: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3435: ,p_effective_date in date
3436: ,p_validation_start_date in date
3437: ,p_validation_end_date in date
3438: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 3438: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

3434: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3435: ,p_effective_date in date
3436: ,p_validation_start_date in date
3437: ,p_validation_end_date in date
3438: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3439: )
3440: is
3441: --
3442: l_proc varchar2(72) := g_package||'chk_sal_review_period_freq';

Line 3501: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'

3497: --
3498: hr_utility.set_message(801, 'HR_51181_ASG_INV_ASG_TYP_SRPF');
3499: hr_multi_message.add
3500: (p_associated_column1 =>
3501: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3502: );
3503: --
3504: end if;
3505: hr_utility.set_location(l_proc, 50);

Line 3525: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'

3521: --
3522: hr_utility.set_message(801, 'HR_51164_ASG_INV_SRP_FREQ');
3523: hr_multi_message.add
3524: (p_associated_column1 =>
3525: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3526: );
3527: --
3528: end if;
3529: hr_utility.set_location(l_proc, 60);

Line 3543: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3539: -- |-----------------------< chk_sal_review_period >------------------------|
3540: -- ---------------------------------------------------------------------------
3541: --
3542: procedure chk_sal_review_period
3543: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3544: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3545: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3546: ,p_effective_date in date
3547: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 3544: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE

3540: -- ---------------------------------------------------------------------------
3541: --
3542: procedure chk_sal_review_period
3543: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3544: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3545: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3546: ,p_effective_date in date
3547: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3548: )

Line 3545: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

3541: --
3542: procedure chk_sal_review_period
3543: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3544: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3545: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3546: ,p_effective_date in date
3547: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3548: )
3549: is

Line 3547: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

3543: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3544: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3545: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3546: ,p_effective_date in date
3547: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3548: )
3549: is
3550: --
3551: l_proc varchar2(72) := g_package||'chk_sal_review_period';

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

3602: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3603: exception
3604: when app_exception.application_exception then
3605: if hr_multi_message.exception_add
3606: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3607: ) then
3608: hr_utility.set_location(' Leaving:'|| l_proc, 6);
3609: raise;
3610: end if;

Line 3619: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3615: -- |---------------------< chk_sal_rp_freq_sal_rp >--------------------------|
3616: -- ---------------------------------------------------------------------------
3617: --
3618: procedure chk_sal_rp_freq_sal_rp
3619: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3620: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
3621: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3622: ,p_effective_date in date
3623: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 3620: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE

3616: -- ---------------------------------------------------------------------------
3617: --
3618: procedure chk_sal_rp_freq_sal_rp
3619: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3620: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
3621: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3622: ,p_effective_date in date
3623: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3624: )

Line 3621: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE

3617: --
3618: procedure chk_sal_rp_freq_sal_rp
3619: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3620: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
3621: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3622: ,p_effective_date in date
3623: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3624: )
3625: is

Line 3623: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

3619: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3620: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
3621: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
3622: ,p_effective_date in date
3623: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3624: )
3625: is
3626: --
3627: l_proc varchar2(72):= g_package||'chk_sal_rp_freq_sal_rp';

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

3630: begin
3631: hr_utility.set_location('Entering:'|| l_proc, 1);
3632: --
3633: if hr_multi_message.no_exclusive_error
3634: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3635: ,p_check_column2 =>
3636: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3637: ) then
3638: --

Line 3636: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'

3632: --
3633: if hr_multi_message.no_exclusive_error
3634: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3635: ,p_check_column2 =>
3636: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3637: ) then
3638: --
3639: -- Check mandatory parameters have been set
3640: --

Line 3693: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'

3689: exception
3690: when app_exception.application_exception then
3691: if hr_multi_message.exception_add
3692: (p_associated_column1 =>
3693: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3694: ,p_associated_column2 =>
3695: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3696: ) then
3697: hr_utility.set_location(' Leaving:'|| l_proc, 5);

Line 3695: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'

3691: if hr_multi_message.exception_add
3692: (p_associated_column1 =>
3693: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3694: ,p_associated_column2 =>
3695: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD_FREQUENCY'
3696: ) then
3697: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3698: raise;
3699: end if;

Line 3708: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3704: -- |-----------------------< chk_set_of_books_id >---------------------------|
3705: -- ---------------------------------------------------------------------------
3706: --
3707: procedure chk_set_of_books_id
3708: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3709: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3710: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3711: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
3712: ,p_effective_date in date

Line 3709: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

3705: -- ---------------------------------------------------------------------------
3706: --
3707: procedure chk_set_of_books_id
3708: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3709: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3710: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3711: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
3712: ,p_effective_date in date
3713: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 3710: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

3706: --
3707: procedure chk_set_of_books_id
3708: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3709: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3710: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3711: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
3712: ,p_effective_date in date
3713: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3714: )

Line 3711: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE

3707: procedure chk_set_of_books_id
3708: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3709: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3710: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3711: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
3712: ,p_effective_date in date
3713: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3714: )
3715: is

Line 3713: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

3709: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3710: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3711: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
3712: ,p_effective_date in date
3713: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3714: )
3715: is
3716: --
3717: l_proc varchar2(72) := g_package||'chk_set_of_books_id';

Line 3720: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

3716: --
3717: l_proc varchar2(72) := g_package||'chk_set_of_books_id';
3718: l_exists varchar2(1);
3719: l_api_updating boolean;
3720: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3721: --
3722: cursor csr_valid_sob is
3723: select null
3724: from gl_sets_of_books

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

3810: hr_utility.set_location(' Leaving:'|| l_proc, 100);
3811: exception
3812: when app_exception.application_exception then
3813: if hr_multi_message.exception_add
3814: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID'
3815: ) then
3816: hr_utility.set_location(' Leaving:'|| l_proc, 110);
3817: raise;
3818: end if;

Line 3827: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3823: -- |--------------------< chk_soft_coding_keyflex_id >-----------------------|
3824: -- ---------------------------------------------------------------------------
3825: --
3826: procedure chk_soft_coding_keyflex_id
3827: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3828: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3829: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
3830: ,p_effective_date in date
3831: ,p_validation_start_date in date

Line 3828: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

3824: -- ---------------------------------------------------------------------------
3825: --
3826: procedure chk_soft_coding_keyflex_id
3827: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3828: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3829: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
3830: ,p_effective_date in date
3831: ,p_validation_start_date in date
3832: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 3829: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE

3825: --
3826: procedure chk_soft_coding_keyflex_id
3827: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3828: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3829: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
3830: ,p_effective_date in date
3831: ,p_validation_start_date in date
3832: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3833: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE

Line 3832: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

3828: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3829: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
3830: ,p_effective_date in date
3831: ,p_validation_start_date in date
3832: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3833: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
3834: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3835: )
3836: is

Line 3833: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE

3829: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
3830: ,p_effective_date in date
3831: ,p_validation_start_date in date
3832: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3833: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
3834: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3835: )
3836: is
3837: --

Line 3834: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

3830: ,p_effective_date in date
3831: ,p_validation_start_date in date
3832: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3833: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
3834: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3835: )
3836: is
3837: --
3838: l_exists varchar2(1);

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

3916: if p_assignment_type not in ('E','A','B','C','O') then
3917: --
3918: hr_utility.set_message(801, 'HR_51227_ASG_INV_ASG_TYP_SCF');
3919: hr_multi_message.add
3920: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID'
3921: );
3922: --
3923: end if;
3924: hr_utility.set_location(l_proc, 50);

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

3931: if csr_valid_keyflex%notfound then
3932: close csr_valid_keyflex;
3933: hr_utility.set_message(801, 'HR_7383_ASG_INV_KEYFLEX');
3934: hr_multi_message.add
3935: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID'
3936: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3937: );
3938: else
3939: close csr_valid_keyflex;

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

3932: close csr_valid_keyflex;
3933: hr_utility.set_message(801, 'HR_7383_ASG_INV_KEYFLEX');
3934: hr_multi_message.add
3935: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID'
3936: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3937: );
3938: else
3939: close csr_valid_keyflex;
3940: end if;

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

3969: end if;
3970: close csr_tax_unit_message;
3971: end if;
3972: hr_multi_message.add
3973: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PAYROLL_ID'
3974: );
3975: else
3976: close csr_pay_legislation_rules;
3977: end if;

Line 3992: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

3988: -- |--------------------< chk_source_organization_id >-----------------------|
3989: -- ---------------------------------------------------------------------------
3990: --
3991: procedure chk_source_organization_id
3992: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3993: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3994: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3995: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
3996: ,p_effective_date in date

Line 3993: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

3989: -- ---------------------------------------------------------------------------
3990: --
3991: procedure chk_source_organization_id
3992: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3993: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3994: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3995: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
3996: ,p_effective_date in date
3997: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 3994: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

3990: --
3991: procedure chk_source_organization_id
3992: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3993: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3994: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3995: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
3996: ,p_effective_date in date
3997: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3998: ,p_validation_start_date in date

Line 3995: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE

3991: procedure chk_source_organization_id
3992: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
3993: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3994: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3995: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
3996: ,p_effective_date in date
3997: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3998: ,p_validation_start_date in date
3999: ,p_validation_end_date in date

Line 3997: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

3993: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
3994: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
3995: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
3996: ,p_effective_date in date
3997: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
3998: ,p_validation_start_date in date
3999: ,p_validation_end_date in date
4000: )
4001: is

Line 4005: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

4001: is
4002: --
4003: l_proc varchar2(72) := g_package||'chk_source_organization_id';
4004: l_api_updating boolean;
4005: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4006: --
4007: cursor csr_val_source_org_id is
4008: select business_group_id
4009: from per_organization_units

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

4068: If l_api_updating then
4069: --
4070: hr_utility.set_message(801, 'HR_51220_ASG_INV_EASG_U_SORG');
4071: hr_multi_message.add
4072: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4073: );
4074: --
4075: else -- inserting an employee assignment
4076: --

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

4075: else -- inserting an employee assignment
4076: --
4077: hr_utility.set_message(801, 'HR_51219_ASG_INV_EASG_I_SORG');
4078: hr_multi_message.add
4079: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4080: );
4081: --
4082: end if;
4083: hr_utility.set_location(l_proc, 60);

Line 4099: 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'

4095: close csr_val_source_org_id;
4096: hr_utility.set_message(801, 'HR_51308_ASG_INV_SOURCE_ORG');
4097: hr_multi_message.add
4098: (p_associated_column1 =>
4099: 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4100: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4101: );
4102: --
4103: else

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

4096: hr_utility.set_message(801, 'HR_51308_ASG_INV_SOURCE_ORG');
4097: hr_multi_message.add
4098: (p_associated_column1 =>
4099: 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4100: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4101: );
4102: --
4103: else
4104: close csr_val_source_org_id;

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

4111: If p_business_group_id <> l_business_group_id then
4112: --
4113: hr_utility.set_message(801, 'HR_51309_ASG_INV_SOURCE_ORG_BG');
4114: hr_multi_message.add
4115: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID'
4116: );
4117: --
4118: end if;
4119: hr_utility.set_location(l_proc, 90);

Line 4133: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

4129: -- |------------------------< chk_source_type >------------------------------|
4130: -- ---------------------------------------------------------------------------
4131: --
4132: procedure chk_source_type
4133: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4134: ,p_source_type in per_all_assignments_f.source_type%TYPE
4135: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
4136: ,p_effective_date in date
4137: ,p_validation_start_date in date

Line 4134: ,p_source_type in per_all_assignments_f.source_type%TYPE

4130: -- ---------------------------------------------------------------------------
4131: --
4132: procedure chk_source_type
4133: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4134: ,p_source_type in per_all_assignments_f.source_type%TYPE
4135: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
4136: ,p_effective_date in date
4137: ,p_validation_start_date in date
4138: ,p_validation_end_date in date

Line 4135: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE

4131: --
4132: procedure chk_source_type
4133: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4134: ,p_source_type in per_all_assignments_f.source_type%TYPE
4135: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
4136: ,p_effective_date in date
4137: ,p_validation_start_date in date
4138: ,p_validation_end_date in date
4139: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 4139: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

4135: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
4136: ,p_effective_date in date
4137: ,p_validation_start_date in date
4138: ,p_validation_end_date in date
4139: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4140: )
4141: is
4142: --
4143: l_proc varchar2(72) := g_package||'chk_source_type';

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

4209: then
4210: --
4211: hr_utility.set_message(801, 'HR_51162_ASG_INV_SOURCE_TYPE');
4212: hr_multi_message.add
4213: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE'
4214: );
4215: --
4216: end if;
4217: hr_utility.set_location(l_proc, 50);

Line 4236: 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'

4232: --
4233: hr_utility.set_message(801, 'HR_51325_ASG_INV_SOU_TYP_RAT');
4234: hr_multi_message.add
4235: (p_associated_column1 =>
4236: 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
4237: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE'
4238: );
4239: --
4240: end if;

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

4233: hr_utility.set_message(801, 'HR_51325_ASG_INV_SOU_TYP_RAT');
4234: hr_multi_message.add
4235: (p_associated_column1 =>
4236: 'PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID'
4237: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SOURCE_TYPE'
4238: );
4239: --
4240: end if;
4241: hr_utility.set_location(l_proc, 70);

Line 4259: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

4255: -- |-------------------< chk_special_ceiling_step_id >-----------------------|
4256: -- ---------------------------------------------------------------------------
4257: --
4258: procedure chk_special_ceiling_step_id
4259: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4260: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
4261: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4262: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4263: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

Line 4260: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

4256: -- ---------------------------------------------------------------------------
4257: --
4258: procedure chk_special_ceiling_step_id
4259: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4260: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
4261: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4262: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4263: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4264: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 4261: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE

4257: --
4258: procedure chk_special_ceiling_step_id
4259: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4260: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
4261: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4262: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4263: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4264: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4265: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 4262: ,p_grade_id in per_all_assignments_f.grade_id%TYPE

4258: procedure chk_special_ceiling_step_id
4259: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4260: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
4261: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4262: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4263: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4264: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4265: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4266: ,p_effective_date in date

Line 4263: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

4259: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4260: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
4261: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4262: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4263: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4264: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4265: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4266: ,p_effective_date in date
4267: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 4264: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

4260: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
4261: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4262: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4263: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4264: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4265: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4266: ,p_effective_date in date
4267: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4268: )

Line 4265: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

4261: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
4262: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
4263: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4264: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4265: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4266: ,p_effective_date in date
4267: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4268: )
4269: is

Line 4267: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

4263: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4264: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4265: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4266: ,p_effective_date in date
4267: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4268: )
4269: is
4270: --
4271: l_sequence per_spinal_point_steps_f.sequence%TYPE;

Line 4388: 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'

4384: --
4385: hr_utility.set_message(801, 'HR_51225_ASG_INV_ASG_TYP_SCS');
4386: hr_multi_message.add
4387: (p_associated_column1 =>
4388: 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4389: );
4390: --
4391: end if;
4392: hr_utility.set_location(l_proc, 50);

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

4399: if csr_valid_step%notfound then
4400: close csr_valid_step;
4401: hr_utility.set_message(801, 'HR_7379_ASG_INV_SPEC_CEIL_STEP');
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.EFFECTIVE_END_DATE'
4406: );
4407: --

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

4400: close csr_valid_step;
4401: hr_utility.set_message(801, 'HR_7379_ASG_INV_SPEC_CEIL_STEP');
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.EFFECTIVE_END_DATE'
4406: );
4407: --
4408: else

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

4401: hr_utility.set_message(801, 'HR_7379_ASG_INV_SPEC_CEIL_STEP');
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.EFFECTIVE_END_DATE'
4406: );
4407: --
4408: else
4409: close csr_valid_step;

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

4418: if l_business_group_id <> p_business_group_id then
4419: close csr_get_bus_grp;
4420: hr_utility.set_message(801, 'HR_7375_ASG_INV_BG_SP_CLG_STEP');
4421: hr_multi_message.add
4422: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4423: );
4424: else
4425: close csr_get_bus_grp;
4426: end if;

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

4426: end if;
4427: hr_utility.set_location(l_proc, 70);
4428: --
4429: if hr_multi_message.no_exclusive_error
4430: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4431: ) then
4432: --
4433: -- Check that the special_ceiling_step_id is valid for the grade
4434: -- if p_grade is not null.

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

4439: if csr_valid_step_grade%notfound then
4440: close csr_valid_step_grade;
4441: hr_utility.set_message(801, 'HR_7380_ASG_STEP_INV_FOR_GRADE');
4442: hr_multi_message.add
4443: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4444: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4445: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4446: );
4447: else

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

4440: close csr_valid_step_grade;
4441: hr_utility.set_message(801, 'HR_7380_ASG_STEP_INV_FOR_GRADE');
4442: hr_multi_message.add
4443: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4444: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4445: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4446: );
4447: else
4448: close csr_valid_step_grade;

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

4441: hr_utility.set_message(801, 'HR_7380_ASG_STEP_INV_FOR_GRADE');
4442: hr_multi_message.add
4443: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4444: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4445: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4446: );
4447: else
4448: close csr_valid_step_grade;
4449: end if;

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

4454: -- then grade id must also be not null
4455: --
4456: hr_utility.set_message(801, 'HR_7434_ASG_GRADE_REQUIRED');
4457: hr_multi_message.add
4458: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4459: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4460: );
4461: end if;
4462: hr_utility.set_location(l_proc, 90);

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

4455: --
4456: hr_utility.set_message(801, 'HR_7434_ASG_GRADE_REQUIRED');
4457: hr_multi_message.add
4458: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
4459: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4460: );
4461: end if;
4462: hr_utility.set_location(l_proc, 90);
4463: --

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

4473: if csr_low_step%found then
4474: close csr_low_step;
4475: hr_utility.set_message(801, 'HR_7381_ASG_CEIL_STEP_TOO_HIGH');
4476: hr_multi_message.add
4477: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4478: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4479: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
4480: );
4481: else

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

4474: close csr_low_step;
4475: hr_utility.set_message(801, 'HR_7381_ASG_CEIL_STEP_TOO_HIGH');
4476: hr_multi_message.add
4477: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4478: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4479: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
4480: );
4481: else
4482: close csr_low_step;

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

4475: hr_utility.set_message(801, 'HR_7381_ASG_CEIL_STEP_TOO_HIGH');
4476: hr_multi_message.add
4477: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
4478: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4479: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_END_DATE'
4480: );
4481: else
4482: close csr_low_step;
4483: end if;

Line 4502: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

4498: -- |--------------------------< chk_supervisor_id >--------------------------|
4499: -- ---------------------------------------------------------------------------
4500: --
4501: procedure chk_supervisor_id
4502: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4503: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4504: ,p_person_id in per_all_assignments_f.person_id%TYPE
4505: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4506: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 4503: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE

4499: -- ---------------------------------------------------------------------------
4500: --
4501: procedure chk_supervisor_id
4502: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4503: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4504: ,p_person_id in per_all_assignments_f.person_id%TYPE
4505: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4506: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4507: ,p_effective_date in date

Line 4504: ,p_person_id in per_all_assignments_f.person_id%TYPE

4500: --
4501: procedure chk_supervisor_id
4502: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4503: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4504: ,p_person_id in per_all_assignments_f.person_id%TYPE
4505: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4506: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4507: ,p_effective_date in date
4508: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 4505: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

4501: procedure chk_supervisor_id
4502: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4503: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4504: ,p_person_id in per_all_assignments_f.person_id%TYPE
4505: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4506: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4507: ,p_effective_date in date
4508: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4509: )

Line 4506: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

4502: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4503: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4504: ,p_person_id in per_all_assignments_f.person_id%TYPE
4505: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4506: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4507: ,p_effective_date in date
4508: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4509: )
4510: is

Line 4508: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

4504: ,p_person_id in per_all_assignments_f.person_id%TYPE
4505: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
4506: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4507: ,p_effective_date in date
4508: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4509: )
4510: is
4511: --
4512: l_proc varchar2(72) := g_package||'chk_supervisor_id';

Line 4519: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

4515: --
4516: l_business_group_id per_people_f.business_group_id%TYPE;
4517: l_current_employee_flag per_people_f.current_employee_flag%TYPE;
4518: l_current_npw_flag per_people_f.current_npw_flag%TYPE;
4519: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4520: --
4521: -- Fix for bug 4305723 starts here.
4522: --
4523: cursor csr_party_id(p_per_id number) IS

Line 4539: from per_all_assignments_f asg

4535: --
4536: -- Bug#3917021
4537: cursor csr_asg_typ is
4538: select assignment_type
4539: from per_all_assignments_f asg
4540: where asg.assignment_id = p_assignment_id
4541: and p_validation_start_date
4542: between asg.effective_start_date
4543: and asg.effective_end_date;

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

4562: begin
4563: hr_utility.set_location('Entering:'|| l_proc, 10);
4564: --
4565: if hr_multi_message.no_exclusive_error
4566: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4567: ) then
4568: --
4569: -- Check mandatory parameters have been set
4570: --

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

4621: If p_supervisor_id = p_person_id then
4622: --
4623: hr_utility.set_message(801, 'HR_51143_ASG_EMP_EQUAL_SUP');
4624: hr_multi_message.add
4625: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4626: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4627: );
4628: end if;
4629: hr_utility.set_location(l_proc, 50);

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

4622: --
4623: hr_utility.set_message(801, 'HR_51143_ASG_EMP_EQUAL_SUP');
4624: hr_multi_message.add
4625: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4626: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4627: );
4628: end if;
4629: hr_utility.set_location(l_proc, 50);
4630: --

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

4642: If l_per_party_id = l_sup_party_id
4643: then
4644: hr_utility.set_message(800, 'HR_449603_ASG_SUP_DUP_PER');
4645: hr_multi_message.add
4646: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4647: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4648: );
4649: end if;
4650: --

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

4643: then
4644: hr_utility.set_message(800, 'HR_449603_ASG_SUP_DUP_PER');
4645: hr_multi_message.add
4646: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4647: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4648: );
4649: end if;
4650: --
4651: -- Fix for bug 4305723 ends here.

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

4684: close csr_valid_supervisor_id;
4685: --
4686: hr_utility.set_message(801, 'PAY_7599_SYS_SUP_DT_OUTDATE');
4687: hr_multi_message.add
4688: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4689: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4690: );
4691: else
4692: close csr_valid_supervisor_id;

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

4685: --
4686: hr_utility.set_message(801, 'PAY_7599_SYS_SUP_DT_OUTDATE');
4687: hr_multi_message.add
4688: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4689: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4690: );
4691: else
4692: close csr_valid_supervisor_id;
4693: end if;

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

4702: then
4703: --
4704: hr_utility.set_message(801, 'HR_51145_ASG_SUP_BG_NE_EMP_BG');
4705: hr_multi_message.add
4706: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4707: );
4708: end if;
4709: hr_utility.set_location(l_proc, 70);
4710: --

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

4725: if l_assignment_type in ('C','E','B') then
4726: --
4727: hr_utility.set_message(801, 'HR_51346_ASG_SUP_NOT_EMP');
4728: hr_multi_message.add
4729: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID');
4730: --
4731: end if;
4732: --Bug#3917021 ends here
4733: --

Line 4750: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

4746: -- |-------------------< chk_supervisor_assignment_id >----------------------|
4747: -- ---------------------------------------------------------------------------
4748: --
4749: procedure chk_supervisor_assignment_id
4750: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4751: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4752: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
4753: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4754: ,p_effective_date in date

Line 4751: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE

4747: -- ---------------------------------------------------------------------------
4748: --
4749: procedure chk_supervisor_assignment_id
4750: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4751: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4752: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
4753: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4754: ,p_effective_date in date
4755: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

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

4748: --
4749: procedure chk_supervisor_assignment_id
4750: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4751: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4752: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
4753: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4754: ,p_effective_date in date
4755: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4756: )

Line 4753: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

4749: procedure chk_supervisor_assignment_id
4750: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
4751: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4752: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
4753: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4754: ,p_effective_date in date
4755: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4756: )
4757: is

Line 4755: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

4751: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
4752: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
4753: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4754: ,p_effective_date in date
4755: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4756: )
4757: is
4758: --
4759: l_proc varchar2(72) := g_package||'chk_supervisor_assignment_id';

Line 4761: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

4757: is
4758: --
4759: l_proc varchar2(72) := g_package||'chk_supervisor_assignment_id';
4760: l_api_updating boolean;
4761: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4762: --
4763: cursor csr_supervisor_assignment_id is
4764: select paaf.assignment_type
4765: from per_all_assignments_f paaf

Line 4765: from per_all_assignments_f paaf

4761: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
4762: --
4763: cursor csr_supervisor_assignment_id is
4764: select paaf.assignment_type
4765: from per_all_assignments_f paaf
4766: where paaf.person_id = p_supervisor_id
4767: and p_supervisor_id is not null
4768: and paaf.assignment_id = p_supervisor_assignment_id
4769: and p_validation_start_date between

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

4772: begin
4773: hr_utility.set_location('Entering:'|| l_proc, 10);
4774: --
4775: if hr_multi_message.no_exclusive_error
4776: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4777: ) then
4778: --
4779: -- Check mandatory parameters have been set
4780: --

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

4850: --
4851: hr_utility.set_message(800, 'HR_50146_SUP_ASG_INVALID');
4852: hr_utility.raise_error;
4853: /* hr_multi_message.add
4854: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4855: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4856: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'
4857: ); */
4858: else

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

4851: hr_utility.set_message(800, 'HR_50146_SUP_ASG_INVALID');
4852: hr_utility.raise_error;
4853: /* hr_multi_message.add
4854: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4855: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4856: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'
4857: ); */
4858: else
4859: close csr_supervisor_assignment_id;

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

4852: hr_utility.raise_error;
4853: /* hr_multi_message.add
4854: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4855: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID'
4856: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'
4857: ); */
4858: else
4859: close csr_supervisor_assignment_id;
4860: end if;

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

4873: hr_utility.set_location(l_proc, 80);
4874: hr_utility.set_message(800, 'HR_50147_SUP_ASG_WRONG_TYPE');
4875: hr_utility.raise_error;
4876: /*hr_multi_message.add
4877: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ASSIGNMENT_ID'
4878: ); */
4879: --
4880: end if;
4881: hr_utility.set_location(l_proc, 90);

Line 4921: (p_person_id in per_all_assignments_f.person_id%TYPE

4917: -- Access Status:
4918: -- Internal Table Handler Use Only.
4919: --
4920: procedure chk_system_pers_type
4921: (p_person_id in per_all_assignments_f.person_id%TYPE
4922: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4923: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4924: ,p_datetrack_mode in varchar2
4925: ,p_effective_date in date

Line 4922: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

4918: -- Internal Table Handler Use Only.
4919: --
4920: procedure chk_system_pers_type
4921: (p_person_id in per_all_assignments_f.person_id%TYPE
4922: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4923: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4924: ,p_datetrack_mode in varchar2
4925: ,p_effective_date in date
4926: )

Line 4923: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

4919: --
4920: procedure chk_system_pers_type
4921: (p_person_id in per_all_assignments_f.person_id%TYPE
4922: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4923: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
4924: ,p_datetrack_mode in varchar2
4925: ,p_effective_date in date
4926: )
4927: is

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

4993: --
4994: exception
4995: when app_exception.application_exception then
4996: if hr_multi_message.exception_add
4997: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4998: ) then
4999: hr_utility.set_location(' Leaving:'|| l_proc, 5);
5000: raise;
5001: end if;

Line 5040: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5036: -- Access Status:
5037: -- Internal Table Handler Use Only.
5038: --
5039: procedure chk_term_status
5040: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5041: ,p_datetrack_mode in varchar2
5042: ,p_validation_start_date in date
5043: )
5044: is

Line 5051: from per_all_assignments_f pas

5047: l_proc varchar2(72) := g_package||'chk_term_status';
5048: --
5049: cursor csr_chk_term_status is
5050: select null
5051: from per_all_assignments_f pas
5052: , per_assignment_status_types past
5053: where pas.assignment_id = p_assignment_id
5054: and pas.effective_start_date >= p_validation_start_date
5055: and past.assignment_status_type_id = pas.assignment_status_type_id

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

5068: if csr_chk_term_status%found then
5069: close csr_chk_term_status;
5070: hr_utility.set_message(801, 'HR_7412_ASG_ASS_TERM_IN_FUTURE');
5071: hr_multi_message.add
5072: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATETRACK_MODE'
5073: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5074: );
5075: else
5076: close csr_chk_term_status;

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

5069: close csr_chk_term_status;
5070: hr_utility.set_message(801, 'HR_7412_ASG_ASS_TERM_IN_FUTURE');
5071: hr_multi_message.add
5072: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATETRACK_MODE'
5073: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5074: );
5075: else
5076: close csr_chk_term_status;
5077: end if;

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

5087: -- ---------------------------------------------------------------------------
5088: -- << 2734822 >>
5089: --
5090: procedure chk_time_finish_formatted
5091: (p_time_normal_finish in out nocopy per_all_assignments_f.time_normal_finish%TYPE
5092: )
5093: is
5094: --
5095: l_proc varchar2(72) := g_package||'chk_time_finish_formatted';

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

5111: hr_utility.set_location(' Leaving:'|| l_proc, 2);
5112: exception
5113: when app_exception.application_exception then
5114: if hr_multi_message.exception_add
5115: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH'
5116: ) then
5117: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5118: raise;
5119: end if;

Line 5126: (p_time_normal_finish in per_all_assignments_f.time_normal_finish%TYPE

5122: end chk_time_finish_formatted;
5123: --
5124: --
5125: procedure chk_time_normal_finish
5126: (p_time_normal_finish in per_all_assignments_f.time_normal_finish%TYPE
5127: )
5128: is
5129: --
5130: l_value per_all_assignments_f.time_normal_finish%TYPE;

Line 5130: l_value per_all_assignments_f.time_normal_finish%TYPE;

5126: (p_time_normal_finish in per_all_assignments_f.time_normal_finish%TYPE
5127: )
5128: is
5129: --
5130: l_value per_all_assignments_f.time_normal_finish%TYPE;
5131: begin
5132:
5133: l_value := p_time_normal_finish;
5134: chk_time_finish_formatted(l_value);

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

5139: -- |---------------------< chk_time_normal_start >---------------------------|
5140: -- ---------------------------------------------------------------------------
5141: --
5142: procedure chk_time_start_formatted -- #2734822
5143: (p_time_normal_start in out nocopy per_all_assignments_f.time_normal_start%TYPE
5144: )
5145: is
5146: --
5147: l_proc varchar2(72) := g_package||'chk_time_normal_start_formatted';

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

5163: hr_utility.set_location(' Leaving:'|| l_proc, 2);
5164: exception
5165: when app_exception.application_exception then
5166: if hr_multi_message.exception_add
5167: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START'
5168: ) then
5169: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5170: raise;
5171: end if;

Line 5178: (p_time_normal_start in per_all_assignments_f.time_normal_start%TYPE

5174: --
5175: -- << 2734822 >>
5176: --
5177: procedure chk_time_normal_start
5178: (p_time_normal_start in per_all_assignments_f.time_normal_start%TYPE
5179: )
5180: is
5181: --
5182: l_value per_all_assignments_f.time_normal_start%TYPE;

Line 5182: l_value per_all_assignments_f.time_normal_start%TYPE;

5178: (p_time_normal_start in per_all_assignments_f.time_normal_start%TYPE
5179: )
5180: is
5181: --
5182: l_value per_all_assignments_f.time_normal_start%TYPE;
5183: begin
5184:
5185: l_value := p_time_normal_start;
5186: chk_time_start_formatted(l_value);

Line 5197: (p_person_id in per_all_assignments_f.person_id%TYPE

5193: -- |-----------------------< chk_dup_apl_vacancy >----------------------------|
5194: -- ---------------------------------------------------------------------------
5195: --
5196: procedure chk_dup_apl_vacancy
5197: (p_person_id in per_all_assignments_f.person_id%TYPE
5198: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5199: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5200: ,p_effective_date in date
5201: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null

Line 5198: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

5194: -- ---------------------------------------------------------------------------
5195: --
5196: procedure chk_dup_apl_vacancy
5197: (p_person_id in per_all_assignments_f.person_id%TYPE
5198: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5199: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5200: ,p_effective_date in date
5201: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
5202: )

Line 5199: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

5195: --
5196: procedure chk_dup_apl_vacancy
5197: (p_person_id in per_all_assignments_f.person_id%TYPE
5198: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5199: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5200: ,p_effective_date in date
5201: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
5202: )
5203: is

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

5197: (p_person_id in per_all_assignments_f.person_id%TYPE
5198: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5199: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5200: ,p_effective_date in date
5201: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
5202: )
5203: is
5204: l_proc varchar2(72) := g_package||'chk_dup_apl_vacancy';
5205: begin

Line 5231: (p_person_id in per_all_assignments_f.person_id%TYPE

5227: -- |-----------------------< chk_dup_apl_vacancy >----------------------------|
5228: -- ---------------------------------------------------------------------------
5229: --
5230: procedure chk_dup_apl_vacancy
5231: (p_person_id in per_all_assignments_f.person_id%TYPE
5232: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5233: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5234: ,p_effective_date in date
5235: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null

Line 5232: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

5228: -- ---------------------------------------------------------------------------
5229: --
5230: procedure chk_dup_apl_vacancy
5231: (p_person_id in per_all_assignments_f.person_id%TYPE
5232: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5233: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5234: ,p_effective_date in date
5235: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
5236: -- Start changes for bug 8687386

Line 5233: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

5229: --
5230: procedure chk_dup_apl_vacancy
5231: (p_person_id in per_all_assignments_f.person_id%TYPE
5232: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5233: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5234: ,p_effective_date in date
5235: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
5236: -- Start changes for bug 8687386
5237: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

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

5231: (p_person_id in per_all_assignments_f.person_id%TYPE
5232: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5233: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5234: ,p_effective_date in date
5235: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
5236: -- Start changes for bug 8687386
5237: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5238: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5239: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

Line 5237: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5233: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5234: ,p_effective_date in date
5235: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
5236: -- Start changes for bug 8687386
5237: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5238: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5239: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
5240: ,P_datetrack_mode in varchar2
5241: -- End changes for bug 8687386

Line 5238: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

5234: ,p_effective_date in date
5235: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
5236: -- Start changes for bug 8687386
5237: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5238: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5239: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
5240: ,P_datetrack_mode in varchar2
5241: -- End changes for bug 8687386
5242: )

Line 5239: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE

5235: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
5236: -- Start changes for bug 8687386
5237: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5238: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5239: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
5240: ,P_datetrack_mode in varchar2
5241: -- End changes for bug 8687386
5242: )
5243: is

Line 5255: from per_all_assignments_f paf

5251: -- cursor to handle INSERT, UPDATE, UPDATE_OVERRIDE and FUTURE_CHANGE cases, return the
5252: -- assignment_id which already has the vacancy, which user is going to associate to this application.
5253: cursor csr_dup_apl_vac_with_eot is
5254: select paf.assignment_id
5255: from per_all_assignments_f paf
5256: ,per_applications pa
5257: ,per_vacancies pv
5258: where paf.application_id = pa.application_id
5259: and pa.date_end is null

Line 5274: from per_all_assignments_f paf

5270: -- return the assignment_id which already has the vacancy, which user is going to
5271: -- associate to this application.
5272: cursor csr_dup_apl_vac_without_eot is
5273: select paf.assignment_id
5274: from per_all_assignments_f paf
5275: ,per_applications pa
5276: ,per_vacancies pv
5277: where paf.application_id = pa.application_id
5278: and pa.date_end is null

Line 5293: per_all_assignments_f paf,

5289: cursor csr_dup_apl_vacancy is
5290: select pa.application_id
5291: from
5292: per_applications pa,
5293: per_all_assignments_f paf,
5294: per_vacancies pv
5295: where
5296: paf.person_id = p_person_id
5297: and paf.vacancy_id = pv.vacancy_id

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

5371:
5372: exception
5373: when app_exception.application_exception then
5374: if hr_multi_message.exception_add
5375: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5376: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5377: ) then
5378: hr_utility.set_location(' Leaving:'|| l_proc, 30);
5379: raise;

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

5372: exception
5373: when app_exception.application_exception then
5374: if hr_multi_message.exception_add
5375: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5376: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5377: ) then
5378: hr_utility.set_location(' Leaving:'|| l_proc, 30);
5379: raise;
5380: end if;

Line 5390: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5386: -- |-------------------------< chk_vacancy_id >------------------------------|
5387: -- ---------------------------------------------------------------------------
5388: --
5389: procedure chk_vacancy_id
5390: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5391: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5392: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5393: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5394: ,p_effective_date in date

Line 5391: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

5387: -- ---------------------------------------------------------------------------
5388: --
5389: procedure chk_vacancy_id
5390: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5391: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5392: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5393: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5394: ,p_effective_date in date
5395: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 5392: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE

5388: --
5389: procedure chk_vacancy_id
5390: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5391: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5392: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5393: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5394: ,p_effective_date in date
5395: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5396: ,p_validation_start_date in date

Line 5393: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE

5389: procedure chk_vacancy_id
5390: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5391: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5392: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5393: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5394: ,p_effective_date in date
5395: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5396: ,p_validation_start_date in date
5397: ,p_validation_end_date in date

Line 5395: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

5391: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5392: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
5393: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
5394: ,p_effective_date in date
5395: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5396: ,p_validation_start_date in date
5397: ,p_validation_end_date in date
5398: )
5399: is

Line 5404: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

5400: --
5401: l_proc varchar2(72) := g_package||'chk_vacancy_id';
5402: l_api_updating boolean;
5403: l_exists varchar2(1);
5404: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
5405: --
5406: cursor csr_val_vacancy_id is
5407: select business_group_id
5408: from per_vacancies

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

5471: If l_api_updating then
5472: --
5473: hr_utility.set_message(801, 'HR_51222_ASG_INV_EASG_U_VAC');
5474: hr_multi_message.add
5475: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5476: );
5477: --
5478: else -- inserting a non employee
5479: --

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

5478: else -- inserting a non employee
5479: --
5480: hr_utility.set_message(801, 'HR_51221_ASG_INV_EASG_I_VAC');
5481: hr_multi_message.add
5482: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5483: );
5484: --
5485: end if;
5486: hr_utility.set_location(l_proc, 50);

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

5518: close csr_val_vacancy_id;
5519: hr_utility.set_message(801, 'HR_51297_ASG_INV_VACANCY');
5520: hr_utility.raise_error;
5521: /* hr_multi_message.add
5522: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5523: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5524: ); */
5525: --
5526: else

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

5519: hr_utility.set_message(801, 'HR_51297_ASG_INV_VACANCY');
5520: hr_utility.raise_error;
5521: /* hr_multi_message.add
5522: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5523: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5524: ); */
5525: --
5526: else
5527: close csr_val_vacancy_id;

Line 5557: (p_assignment_type in per_all_assignments_f.assignment_type%TYPE

5553: -- |----------------------< gen_assignment_sequence >------------------------|
5554: -- ---------------------------------------------------------------------------
5555: --
5556: procedure gen_assignment_sequence
5557: (p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5558: ,p_person_id in per_all_assignments_f.person_id%TYPE
5559: ,p_assignment_sequence in out nocopy per_all_assignments_f.assignment_sequence%TYPE
5560: )
5561: is

Line 5558: ,p_person_id in per_all_assignments_f.person_id%TYPE

5554: -- ---------------------------------------------------------------------------
5555: --
5556: procedure gen_assignment_sequence
5557: (p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5558: ,p_person_id in per_all_assignments_f.person_id%TYPE
5559: ,p_assignment_sequence in out nocopy per_all_assignments_f.assignment_sequence%TYPE
5560: )
5561: is
5562: --

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

5555: --
5556: procedure gen_assignment_sequence
5557: (p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5558: ,p_person_id in per_all_assignments_f.person_id%TYPE
5559: ,p_assignment_sequence in out nocopy per_all_assignments_f.assignment_sequence%TYPE
5560: )
5561: is
5562: --
5563: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 5563: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

5559: ,p_assignment_sequence in out nocopy per_all_assignments_f.assignment_sequence%TYPE
5560: )
5561: is
5562: --
5563: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
5564: l_proc varchar2(72) := g_package||'gen_assignment_sequence';
5565: --
5566: cursor csr_get_ass_seq is
5567: select nvl(max(assignment_sequence),0) +1

Line 5568: from per_all_assignments_f

5564: l_proc varchar2(72) := g_package||'gen_assignment_sequence';
5565: --
5566: cursor csr_get_ass_seq is
5567: select nvl(max(assignment_sequence),0) +1
5568: from per_all_assignments_f
5569: where person_id = p_person_id
5570: and assignment_type = p_assignment_type;
5571: --
5572: begin

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

5572: begin
5573: hr_utility.set_location('Entering:'|| l_proc, 1);
5574: --
5575: if hr_multi_message.no_exclusive_error
5576: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
5577: ) then
5578: --
5579: -- Check mandatory parameters have been set
5580: --

Line 5634: (p_organization_id in per_all_assignments_f.organization_id%TYPE

5630: -- Access Status:
5631: -- Internal Table Handler Use Only.
5632: --
5633: function other_managers_in_org
5634: (p_organization_id in per_all_assignments_f.organization_id%TYPE
5635: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5636: ,p_effective_date in date
5637: )
5638: return boolean is

Line 5635: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5631: -- Internal Table Handler Use Only.
5632: --
5633: function other_managers_in_org
5634: (p_organization_id in per_all_assignments_f.organization_id%TYPE
5635: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5636: ,p_effective_date in date
5637: )
5638: return boolean is
5639: --

Line 5643: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

5639: --
5640: l_exists varchar2(1);
5641: l_proc varchar2(72) := g_package||'other_managers_in_org';
5642: l_other_manager_exists boolean;
5643: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
5644: --
5645: cursor csr_other_manager_in_org is
5646: select null
5647: from per_all_assignments_f pas

Line 5647: from per_all_assignments_f pas

5643: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
5644: --
5645: cursor csr_other_manager_in_org is
5646: select null
5647: from per_all_assignments_f pas
5648: where pas.organization_id = p_organization_id
5649: and pas.assignment_type = 'E'
5650: and pas.manager_flag = 'Y'
5651: and pas.assignment_id <> l_assignment_id

Line 5696: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5692: -- |-----------------------< gen_date_probation_end >------------------------|
5693: -- ---------------------------------------------------------------------------
5694: --
5695: procedure gen_date_probation_end
5696: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5697: ,p_effective_date in date
5698: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
5699: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
5700: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

Line 5698: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE

5694: --
5695: procedure gen_date_probation_end
5696: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5697: ,p_effective_date in date
5698: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
5699: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
5700: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5701: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5702: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE

Line 5699: ,p_probation_period in per_all_assignments_f.probation_period%TYPE

5695: procedure gen_date_probation_end
5696: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5697: ,p_effective_date in date
5698: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
5699: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
5700: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5701: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5702: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
5703: )

Line 5700: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE

5696: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5697: ,p_effective_date in date
5698: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
5699: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
5700: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5701: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5702: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
5703: )
5704: is

Line 5701: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

5697: ,p_effective_date in date
5698: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
5699: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
5700: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5701: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5702: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
5703: )
5704: is
5705: --

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

5698: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
5699: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
5700: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
5701: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5702: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
5703: )
5704: is
5705: --
5706: l_proc varchar2(72) := g_package||'gen_date_probation_end';

Line 5810: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5806: -- |---------------------< chk_internal_address_line >-----------------------|
5807: -- ---------------------------------------------------------------------------
5808: --
5809: procedure chk_internal_address_line
5810: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5811: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5812: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE
5813: ,p_effective_date in date
5814: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

Line 5811: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE

5807: -- ---------------------------------------------------------------------------
5808: --
5809: procedure chk_internal_address_line
5810: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5811: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5812: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE
5813: ,p_effective_date in date
5814: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5815: )

Line 5812: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE

5808: --
5809: procedure chk_internal_address_line
5810: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5811: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5812: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE
5813: ,p_effective_date in date
5814: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5815: )
5816: is

Line 5814: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

5810: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5811: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
5812: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE
5813: ,p_effective_date in date
5814: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5815: )
5816: is
5817: --
5818: l_proc varchar2(72) := g_package||'chk_internal_address_line';

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

5869: hr_utility.set_location(' Leaving:'|| l_proc, 60);
5870: exception
5871: when app_exception.application_exception then
5872: if hr_multi_message.exception_add
5873: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE'
5874: ) then
5875: hr_utility.set_location(' Leaving:'|| l_proc, 70);
5876: raise;
5877: end if;

Line 5891: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5887: --
5888: procedure chk_applicant_rank
5889: (p_applicant_rank in number
5890: ,p_assignment_type in varchar2
5891: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5892: ,p_effective_date in date
5893: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE)
5894: IS
5895: --

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

5889: (p_applicant_rank in number
5890: ,p_assignment_type in varchar2
5891: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5892: ,p_effective_date in date
5893: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE)
5894: IS
5895: --
5896: l_proc varchar2(72) := g_package||'chk_applicant_rank';
5897: l_api_updating boolean;

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

5961: hr_utility.set_location('Leaving:'|| l_proc, 70);
5962: exception
5963: when app_exception.application_exception then
5964: if hr_multi_message.exception_add
5965: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK'
5966: ) then
5967: raise;
5968: end if;
5969: end chk_applicant_rank;

Line 5979: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE

5975: --
5976: procedure chk_posting_content_id
5977: (p_posting_content_id in number
5978: ,p_assignment_type in varchar2
5979: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5980: ,p_effective_date in date
5981: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5982: ) IS
5983: --

Line 5981: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

5977: (p_posting_content_id in number
5978: ,p_assignment_type in varchar2
5979: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
5980: ,p_effective_date in date
5981: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
5982: ) IS
5983: --
5984: l_proc varchar2(72) := g_package||'chk_posting_content_id';
5985: l_api_updating boolean;

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

6061: hr_utility.set_location('Leaving: '||l_proc, 50);
6062: exception
6063: when app_exception.application_exception then
6064: if hr_multi_message.exception_add
6065: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID'
6066: ) then
6067: raise;
6068: end if;
6069: --