52: -- Access Status:
53: -- Internal Table Handler Use Only.
54: --
55: procedure chk_pay_basis_id
56: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
57: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
58: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
59: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
60: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
53: -- Internal Table Handler Use Only.
54: --
55: procedure chk_pay_basis_id
56: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
57: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
58: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
59: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
60: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
61: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
54: --
55: procedure chk_pay_basis_id
56: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
57: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
58: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
59: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
60: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
61: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
62: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
55: procedure chk_pay_basis_id
56: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
57: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
58: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
59: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
60: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
61: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
62: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
63: );
56: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
57: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
58: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
59: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
60: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
61: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
62: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
63: );
64: --
57: ,p_pay_basis_id in per_all_assignments_f.pay_basis_id%TYPE
58: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
59: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
60: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
61: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
62: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
63: );
64: --
65: -- --------------------------------------------------------------------------+
58: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
59: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
60: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
61: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
62: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
63: );
64: --
65: -- --------------------------------------------------------------------------+
66: -- |------------------------< chk_payroll_id >-------------------------------|
130: -- Access Status:
131: -- Internal Table Handler Use Only.
132: --
133: procedure chk_payroll_id
134: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
135: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
136: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
137: ,p_person_id in per_all_assignments_f.person_id%TYPE
138: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
131: -- Internal Table Handler Use Only.
132: --
133: procedure chk_payroll_id
134: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
135: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
136: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
137: ,p_person_id in per_all_assignments_f.person_id%TYPE
138: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
139: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
132: --
133: procedure chk_payroll_id
134: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
135: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
136: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
137: ,p_person_id in per_all_assignments_f.person_id%TYPE
138: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
139: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
140: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
133: procedure chk_payroll_id
134: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
135: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
136: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
137: ,p_person_id in per_all_assignments_f.person_id%TYPE
138: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
139: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
140: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
141: ,p_effective_date in date
134: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
135: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
136: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
137: ,p_person_id in per_all_assignments_f.person_id%TYPE
138: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
139: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
140: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
141: ,p_effective_date in date
142: ,p_datetrack_mode in varchar2
135: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
136: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
137: ,p_person_id in per_all_assignments_f.person_id%TYPE
138: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
139: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
140: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
141: ,p_effective_date in date
142: ,p_datetrack_mode in varchar2
143: ,p_payroll_id_updated out nocopy boolean
136: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
137: ,p_person_id in per_all_assignments_f.person_id%TYPE
138: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
139: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
140: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
141: ,p_effective_date in date
142: ,p_datetrack_mode in varchar2
143: ,p_payroll_id_updated out nocopy boolean
144: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
140: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
141: ,p_effective_date in date
142: ,p_datetrack_mode in varchar2
143: ,p_payroll_id_updated out nocopy boolean
144: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
145: );
146: --
147: -- --------------------------------------------------------------------------+
148: -- |----------------------< chk_payroll_id_int >------------------------------|
148: -- |----------------------< chk_payroll_id_int >------------------------------|
149: -- --------------------------------------------------------------------------+
150: --
151: procedure chk_payroll_id_int
152: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
153: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
154: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
155: ,p_person_id in per_all_assignments_f.person_id%TYPE
156: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
149: -- --------------------------------------------------------------------------+
150: --
151: procedure chk_payroll_id_int
152: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
153: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
154: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
155: ,p_person_id in per_all_assignments_f.person_id%TYPE
156: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
157: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
150: --
151: procedure chk_payroll_id_int
152: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
153: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
154: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
155: ,p_person_id in per_all_assignments_f.person_id%TYPE
156: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
157: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
158: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
151: procedure chk_payroll_id_int
152: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
153: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
154: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
155: ,p_person_id in per_all_assignments_f.person_id%TYPE
156: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
157: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
158: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
159: ,p_effective_date in date
152: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
153: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
154: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
155: ,p_person_id in per_all_assignments_f.person_id%TYPE
156: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
157: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
158: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
159: ,p_effective_date in date
160: ,p_datetrack_mode in varchar2
153: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
154: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
155: ,p_person_id in per_all_assignments_f.person_id%TYPE
156: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
157: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
158: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
159: ,p_effective_date in date
160: ,p_datetrack_mode in varchar2
161: ,p_address_line1 in per_addresses.address_line1%type
154: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
155: ,p_person_id in per_all_assignments_f.person_id%TYPE
156: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
157: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
158: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
159: ,p_effective_date in date
160: ,p_datetrack_mode in varchar2
161: ,p_address_line1 in per_addresses.address_line1%type
162: ,p_date_of_birth in per_all_people_f.date_of_birth%type
160: ,p_datetrack_mode in varchar2
161: ,p_address_line1 in per_addresses.address_line1%type
162: ,p_date_of_birth in per_all_people_f.date_of_birth%type
163: ,p_payroll_id_updated out nocopy boolean
164: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
165: );
166: --
167: -- --------------------------------------------------------------------------+
168: -- |----------------------< chk_posting_content_id >-------------------------|
178:
179: procedure chk_posting_content_id
180: (p_posting_content_id in number
181: ,p_assignment_type in varchar2
182: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
183: ,p_effective_date in date
184: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE);
185:
186: --
180: (p_posting_content_id in number
181: ,p_assignment_type in varchar2
182: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
183: ,p_effective_date in date
184: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE);
185:
186: --
187: -- --------------------------------------------------------------------------+
188: -- |-------------------------< chk_applicant_rank >--------------------------|
198:
199: procedure chk_applicant_rank
200: (p_applicant_rank in number
201: ,p_assignment_type in varchar2
202: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
203: ,p_effective_date in date
204: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE);
205:
206:
200: (p_applicant_rank in number
201: ,p_assignment_type in varchar2
202: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
203: ,p_effective_date in date
204: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE);
205:
206:
207: -- --------------------------------------------------------------------------+
208: -- |-----------------------< chk_people_group_id >---------------------------|
253: -- Access Status:
254: -- Internal Table Handler Use Only.
255: --
256: procedure chk_people_group_id
257: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
258: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
259: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
260: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
261: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
254: -- Internal Table Handler Use Only.
255: --
256: procedure chk_people_group_id
257: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
258: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
259: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
260: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
261: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
262: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
255: --
256: procedure chk_people_group_id
257: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
258: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
259: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
260: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
261: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
262: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
263: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
256: procedure chk_people_group_id
257: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
258: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
259: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
260: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
261: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
262: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
263: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
264: ,p_effective_date in date
257: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
258: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
259: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
260: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
261: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
262: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
263: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
264: ,p_effective_date in date
265: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
258: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
259: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
260: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
261: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
262: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
263: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
264: ,p_effective_date in date
265: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
266: );
259: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
260: ,p_people_group_id in per_all_assignments_f.people_group_id%TYPE
261: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
262: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
263: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
264: ,p_effective_date in date
265: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
266: );
267: --
261: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
262: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
263: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
264: ,p_effective_date in date
265: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
266: );
267: --
268: -- --------------------------------------------------------------------------+
269: -- |-------------------< chk_perf_review_period_freq >-----------------------|
312: -- Access Status:
313: -- Internal Table Handler Use Only.
314: --
315: procedure chk_perf_review_period_freq
316: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
317: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
318: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
319: ,p_effective_date in date
320: ,p_validation_start_date in date
313: -- Internal Table Handler Use Only.
314: --
315: procedure chk_perf_review_period_freq
316: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
317: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
318: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
319: ,p_effective_date in date
320: ,p_validation_start_date in date
321: ,p_validation_end_date in date
314: --
315: procedure chk_perf_review_period_freq
316: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
317: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
318: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
319: ,p_effective_date in date
320: ,p_validation_start_date in date
321: ,p_validation_end_date in date
322: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
318: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
319: ,p_effective_date in date
320: ,p_validation_start_date in date
321: ,p_validation_end_date in date
322: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
323: );
324: --
325: -- --------------------------------------------------------------------------+
326: -- |-----------------------< chk_perf_review_period >------------------------|
355: -- Access Status:
356: -- Internal Table Handler Use Only.
357: --
358: procedure chk_perf_review_period
359: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
360: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
361: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
362: ,p_effective_date in date
363: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
356: -- Internal Table Handler Use Only.
357: --
358: procedure chk_perf_review_period
359: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
360: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
361: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
362: ,p_effective_date in date
363: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
364: );
357: --
358: procedure chk_perf_review_period
359: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
360: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
361: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
362: ,p_effective_date in date
363: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
364: );
365: --
359: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
360: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
361: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
362: ,p_effective_date in date
363: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
364: );
365: --
366: -- --------------------------------------------------------------------------+
367: -- |-------------------< chk_perf_rp_freq_perf_rp >--------------------------|
395: -- Access Status:
396: -- Internal Table Handler Use Only.
397: --
398: procedure chk_perf_rp_freq_perf_rp
399: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
400: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
401: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
402: ,p_effective_date in date
403: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
396: -- Internal Table Handler Use Only.
397: --
398: procedure chk_perf_rp_freq_perf_rp
399: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
400: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
401: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
402: ,p_effective_date in date
403: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
404: );
397: --
398: procedure chk_perf_rp_freq_perf_rp
399: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
400: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
401: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
402: ,p_effective_date in date
403: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
404: );
405: --
399: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
400: ,p_perf_review_period_frequency in per_all_assignments_f.perf_review_period_frequency%TYPE
401: ,p_perf_review_period in per_all_assignments_f.perf_review_period%TYPE
402: ,p_effective_date in date
403: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
404: );
405: --
406: -- --------------------------------------------------------------------------+
407: -- |---------------------< chk_period_of_service_id >------------------------|
459: -- Access Status:
460: -- Internal Table Handler Use Only.
461: --
462: procedure chk_period_of_service_id
463: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
464: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
465: ,p_person_id in per_all_assignments_f.person_id%TYPE
466: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
467: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
460: -- Internal Table Handler Use Only.
461: --
462: procedure chk_period_of_service_id
463: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
464: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
465: ,p_person_id in per_all_assignments_f.person_id%TYPE
466: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
467: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
468: ,p_validation_start_date in date
461: --
462: procedure chk_period_of_service_id
463: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
464: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
465: ,p_person_id in per_all_assignments_f.person_id%TYPE
466: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
467: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
468: ,p_validation_start_date in date
469: ,p_validation_end_date in date
462: procedure chk_period_of_service_id
463: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
464: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
465: ,p_person_id in per_all_assignments_f.person_id%TYPE
466: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
467: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
468: ,p_validation_start_date in date
469: ,p_validation_end_date in date
470: ,p_effective_date in date
463: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
464: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
465: ,p_person_id in per_all_assignments_f.person_id%TYPE
466: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
467: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
468: ,p_validation_start_date in date
469: ,p_validation_end_date in date
470: ,p_effective_date in date
471: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
467: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
468: ,p_validation_start_date in date
469: ,p_validation_end_date in date
470: ,p_effective_date in date
471: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
472: );
473: --
474: -- --------------------------------------------------------------------------+
475: -- |--------------------------< chk_person_id >------------------------------|
500: --
501: -- 70.2 change b start.
502: --
503: procedure chk_person_id
504: (p_person_id in per_all_assignments_f.person_id%TYPE
505: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
506: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
507: );
508: --
501: -- 70.2 change b start.
502: --
503: procedure chk_person_id
504: (p_person_id in per_all_assignments_f.person_id%TYPE
505: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
506: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
507: );
508: --
509: -- --------------------------------------------------------------------------+
502: --
503: procedure chk_person_id
504: (p_person_id in per_all_assignments_f.person_id%TYPE
505: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
506: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
507: );
508: --
509: -- --------------------------------------------------------------------------+
510: -- |---------------------< chk_person_referred_by_id >-----------------------|
561: -- Access Status:
562: -- Internal Table Handler Use Only.
563: --
564: procedure chk_person_referred_by_id
565: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
566: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
567: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
568: ,p_person_id in per_all_assignments_f.person_id%TYPE
569: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
562: -- Internal Table Handler Use Only.
563: --
564: procedure chk_person_referred_by_id
565: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
566: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
567: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
568: ,p_person_id in per_all_assignments_f.person_id%TYPE
569: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
570: ,p_effective_date in date
563: --
564: procedure chk_person_referred_by_id
565: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
566: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
567: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
568: ,p_person_id in per_all_assignments_f.person_id%TYPE
569: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
570: ,p_effective_date in date
571: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
564: procedure chk_person_referred_by_id
565: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
566: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
567: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
568: ,p_person_id in per_all_assignments_f.person_id%TYPE
569: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
570: ,p_effective_date in date
571: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
572: ,p_validation_start_date in date
565: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
566: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
567: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
568: ,p_person_id in per_all_assignments_f.person_id%TYPE
569: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
570: ,p_effective_date in date
571: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
572: ,p_validation_start_date in date
573: ,p_validation_end_date in date
567: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
568: ,p_person_id in per_all_assignments_f.person_id%TYPE
569: ,p_person_referred_by_id in per_all_assignments_f.person_referred_by_id%TYPE
570: ,p_effective_date in date
571: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
572: ,p_validation_start_date in date
573: ,p_validation_end_date in date
574: );
575: --
616: -- Access Status:
617: -- Internal Table Handler Use Only
618: --
619: procedure chk_position_id
620: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
621: ,p_position_id in per_all_assignments_f.position_id%TYPE
622: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
623: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
624: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
617: -- Internal Table Handler Use Only
618: --
619: procedure chk_position_id
620: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
621: ,p_position_id in per_all_assignments_f.position_id%TYPE
622: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
623: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
624: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
625: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
618: --
619: procedure chk_position_id
620: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
621: ,p_position_id in per_all_assignments_f.position_id%TYPE
622: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
623: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
624: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
625: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
626: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
619: procedure chk_position_id
620: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
621: ,p_position_id in per_all_assignments_f.position_id%TYPE
622: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
623: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
624: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
625: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
626: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
627: ,p_effective_date in date
620: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
621: ,p_position_id in per_all_assignments_f.position_id%TYPE
622: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
623: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
624: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
625: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
626: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
627: ,p_effective_date in date
628: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
621: ,p_position_id in per_all_assignments_f.position_id%TYPE
622: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
623: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
624: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
625: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
626: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
627: ,p_effective_date in date
628: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
629: );
622: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
623: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
624: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
625: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
626: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
627: ,p_effective_date in date
628: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
629: );
630: -----------------------------------------------------------------------------+
624: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
625: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
626: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
627: ,p_effective_date in date
628: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
629: );
630: -----------------------------------------------------------------------------+
631: -------------------< chk_position_id_grade_id >------------------------------+
632: -----------------------------------------------------------------------------+
667: -- Access Status:
668: -- Internal Table Handler Use Only
669: --
670: procedure chk_position_id_grade_id
671: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
672: ,p_position_id in per_all_assignments_f.position_id%TYPE
673: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
674: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
675: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
668: -- Internal Table Handler Use Only
669: --
670: procedure chk_position_id_grade_id
671: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
672: ,p_position_id in per_all_assignments_f.position_id%TYPE
673: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
674: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
675: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
676: ,p_effective_date in date
669: --
670: procedure chk_position_id_grade_id
671: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
672: ,p_position_id in per_all_assignments_f.position_id%TYPE
673: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
674: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
675: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
676: ,p_effective_date in date
677: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
670: procedure chk_position_id_grade_id
671: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
672: ,p_position_id in per_all_assignments_f.position_id%TYPE
673: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
674: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
675: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
676: ,p_effective_date in date
677: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
678: ,p_inv_pos_grade_warning out nocopy boolean
671: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
672: ,p_position_id in per_all_assignments_f.position_id%TYPE
673: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
674: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
675: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
676: ,p_effective_date in date
677: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
678: ,p_inv_pos_grade_warning out nocopy boolean
679: );
673: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
674: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
675: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
676: ,p_effective_date in date
677: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
678: ,p_inv_pos_grade_warning out nocopy boolean
679: );
680: -----------------------------------------------------------------------------+
681: --------------------------< chk_position_id_org_id >-------------------------+
711: --
712: -- Access Status:
713: -- Internal Table Handler Use Only
714: procedure chk_position_id_org_id
715: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
716: ,p_position_id in per_all_assignments_f.position_id%TYPE
717: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
718: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
719: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
712: -- Access Status:
713: -- Internal Table Handler Use Only
714: procedure chk_position_id_org_id
715: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
716: ,p_position_id in per_all_assignments_f.position_id%TYPE
717: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
718: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
719: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
720: ,p_effective_date in date
713: -- Internal Table Handler Use Only
714: procedure chk_position_id_org_id
715: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
716: ,p_position_id in per_all_assignments_f.position_id%TYPE
717: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
718: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
719: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
720: ,p_effective_date in date
721: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
714: procedure chk_position_id_org_id
715: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
716: ,p_position_id in per_all_assignments_f.position_id%TYPE
717: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
718: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
719: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
720: ,p_effective_date in date
721: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
722: );
715: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
716: ,p_position_id in per_all_assignments_f.position_id%TYPE
717: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
718: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
719: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
720: ,p_effective_date in date
721: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
722: );
723: -----------------------------------------------------------------------------+
717: ,p_organization_id in per_all_assignments_f.organization_id%TYPE
718: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
719: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
720: ,p_effective_date in date
721: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
722: );
723: -----------------------------------------------------------------------------+
724: -------------------------< chk_position_id_job_id >--------------------------+
725: -----------------------------------------------------------------------------+
761: -- Access Status:
762: -- Internal Table Handler Use Only
763: --
764: procedure chk_position_id_job_id
765: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
766: ,p_position_id in per_all_assignments_f.position_id%TYPE
767: ,p_job_id in per_all_assignments_f.job_id%TYPE
768: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
769: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
762: -- Internal Table Handler Use Only
763: --
764: procedure chk_position_id_job_id
765: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
766: ,p_position_id in per_all_assignments_f.position_id%TYPE
767: ,p_job_id in per_all_assignments_f.job_id%TYPE
768: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
769: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
770: ,p_effective_date in date
763: --
764: procedure chk_position_id_job_id
765: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
766: ,p_position_id in per_all_assignments_f.position_id%TYPE
767: ,p_job_id in per_all_assignments_f.job_id%TYPE
768: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
769: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
770: ,p_effective_date in date
771: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
764: procedure chk_position_id_job_id
765: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
766: ,p_position_id in per_all_assignments_f.position_id%TYPE
767: ,p_job_id in per_all_assignments_f.job_id%TYPE
768: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
769: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
770: ,p_effective_date in date
771: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
772: );
765: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
766: ,p_position_id in per_all_assignments_f.position_id%TYPE
767: ,p_job_id in per_all_assignments_f.job_id%TYPE
768: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
769: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
770: ,p_effective_date in date
771: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
772: );
773: --
767: ,p_job_id in per_all_assignments_f.job_id%TYPE
768: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
769: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
770: ,p_effective_date in date
771: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
772: );
773: --
774: -- --------------------------------------------------------------------------+
775: -- |-------------------------< chk_primary_flag >----------------------------|
827: -- Access Status:
828: -- Internal Table Handler Use Only.
829: --
830: procedure chk_primary_flag
831: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
832: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
833: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
834: ,p_person_id in per_all_assignments_f.person_id%TYPE
835: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
828: -- Internal Table Handler Use Only.
829: --
830: procedure chk_primary_flag
831: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
832: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
833: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
834: ,p_person_id in per_all_assignments_f.person_id%TYPE
835: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
836: ,p_pop_date_start in DATE
829: --
830: procedure chk_primary_flag
831: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
832: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
833: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
834: ,p_person_id in per_all_assignments_f.person_id%TYPE
835: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
836: ,p_pop_date_start in DATE
837: ,p_effective_date in date
830: procedure chk_primary_flag
831: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
832: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
833: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
834: ,p_person_id in per_all_assignments_f.person_id%TYPE
835: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
836: ,p_pop_date_start in DATE
837: ,p_effective_date in date
838: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
831: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
832: ,p_primary_flag in per_all_assignments_f.primary_flag%TYPE
833: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
834: ,p_person_id in per_all_assignments_f.person_id%TYPE
835: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
836: ,p_pop_date_start in DATE
837: ,p_effective_date in date
838: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
839: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
834: ,p_person_id in per_all_assignments_f.person_id%TYPE
835: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
836: ,p_pop_date_start in DATE
837: ,p_effective_date in date
838: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
839: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
840: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
841: );
842: --
835: ,p_period_of_service_id in per_all_assignments_f.period_of_service_id%TYPE
836: ,p_pop_date_start in DATE
837: ,p_effective_date in date
838: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
839: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
840: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
841: );
842: --
843: -- --------------------------------------------------------------------------+
836: ,p_pop_date_start in DATE
837: ,p_effective_date in date
838: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
839: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
840: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
841: );
842: --
843: -- --------------------------------------------------------------------------+
844: -- |----------------------< chk_probation_period >---------------------------|
868: -- Access Status:
869: -- Internal Table Handler Use Only.
870: --
871: procedure chk_probation_period
872: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
873: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
874: ,p_effective_date in date
875: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
876: );
869: -- Internal Table Handler Use Only.
870: --
871: procedure chk_probation_period
872: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
873: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
874: ,p_effective_date in date
875: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
876: );
877: --
871: procedure chk_probation_period
872: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
873: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
874: ,p_effective_date in date
875: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
876: );
877: --
878: -- --------------------------------------------------------------------------+
879: -- |------------------------< chk_probation_unit >---------------------------|
911: -- 'Y' and the effective start date of the assignment is between
912: -- start date active and end date active on HR_LOOKUPS.
913: --
914: procedure chk_probation_unit
915: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
916: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
917: ,p_effective_date in date
918: ,p_validation_start_date in date
919: ,p_validation_end_date in date
912: -- start date active and end date active on HR_LOOKUPS.
913: --
914: procedure chk_probation_unit
915: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
916: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
917: ,p_effective_date in date
918: ,p_validation_start_date in date
919: ,p_validation_end_date in date
920: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
916: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
917: ,p_effective_date in date
918: ,p_validation_start_date in date
919: ,p_validation_end_date in date
920: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
921: );
922: --
923: -- --------------------------------------------------------------------------+
924: -- |-------------------< chk_prob_unit_prob_period >-------------------------|
950: -- Access Status:
951: -- Internal Table Handler Use Only.
952: --
953: procedure chk_prob_unit_prob_period
954: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
955: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
956: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
957: ,p_effective_date in date
958: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
951: -- Internal Table Handler Use Only.
952: --
953: procedure chk_prob_unit_prob_period
954: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
955: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
956: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
957: ,p_effective_date in date
958: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
959: );
952: --
953: procedure chk_prob_unit_prob_period
954: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
955: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
956: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
957: ,p_effective_date in date
958: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
959: );
960: --
954: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
955: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
956: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
957: ,p_effective_date in date
958: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
959: );
960: --
961: -- --------------------------------------------------------------------------+
962: -- |------------------------< chk_recruiter_id >-----------------------------|
1016: -- Access Status:
1017: -- Internal Table Handler Use Only.
1018: --
1019: procedure chk_recruiter_id
1020: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1021: ,p_person_id in per_all_assignments_f.person_id%TYPE
1022: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1023: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1024: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
1017: -- Internal Table Handler Use Only.
1018: --
1019: procedure chk_recruiter_id
1020: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1021: ,p_person_id in per_all_assignments_f.person_id%TYPE
1022: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1023: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1024: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
1025: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1018: --
1019: procedure chk_recruiter_id
1020: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1021: ,p_person_id in per_all_assignments_f.person_id%TYPE
1022: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1023: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1024: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
1025: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1026: ,p_effective_date in date
1019: procedure chk_recruiter_id
1020: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1021: ,p_person_id in per_all_assignments_f.person_id%TYPE
1022: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1023: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1024: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
1025: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1026: ,p_effective_date in date
1027: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1020: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1021: ,p_person_id in per_all_assignments_f.person_id%TYPE
1022: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1023: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1024: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
1025: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1026: ,p_effective_date in date
1027: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1028: ,p_validation_start_date in date
1021: ,p_person_id in per_all_assignments_f.person_id%TYPE
1022: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1023: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1024: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
1025: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1026: ,p_effective_date in date
1027: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1028: ,p_validation_start_date in date
1029: ,p_validation_end_date in date
1023: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1024: ,p_recruiter_id in per_all_assignments_f.recruiter_id%TYPE
1025: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1026: ,p_effective_date in date
1027: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1028: ,p_validation_start_date in date
1029: ,p_validation_end_date in date
1030: );
1031: --
1074: -- Access Status:
1075: -- Internal Table Handler Use Only.
1076: --
1077: procedure chk_recruitment_activity_id
1078: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1079: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1080: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1081: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
1082: ,p_effective_date in date
1075: -- Internal Table Handler Use Only.
1076: --
1077: procedure chk_recruitment_activity_id
1078: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1079: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1080: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1081: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
1082: ,p_effective_date in date
1083: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1076: --
1077: procedure chk_recruitment_activity_id
1078: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1079: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1080: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1081: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
1082: ,p_effective_date in date
1083: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1084: ,p_validation_start_date in date
1077: procedure chk_recruitment_activity_id
1078: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1079: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1080: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1081: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
1082: ,p_effective_date in date
1083: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1084: ,p_validation_start_date in date
1085: ,p_validation_end_date in date
1079: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1080: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1081: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
1082: ,p_effective_date in date
1083: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1084: ,p_validation_start_date in date
1085: ,p_validation_end_date in date
1086: );
1087: --
1122: -- If child rows exist in any of the tables listed above, an application
1123: -- error is raised and processing is terminated.
1124: --
1125: procedure chk_ref_int_del
1126: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1127: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1128: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1129: ,p_datetrack_mode in varchar2
1130: );
1123: -- error is raised and processing is terminated.
1124: --
1125: procedure chk_ref_int_del
1126: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1127: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1128: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1129: ,p_datetrack_mode in varchar2
1130: );
1131: --
1124: --
1125: procedure chk_ref_int_del
1126: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1127: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1128: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1129: ,p_datetrack_mode in varchar2
1130: );
1131: --
1132: -- --------------------------------------------------------------------------+
1173: -- Access Status:
1174: -- Internal Table Handler Use Only.
1175: --
1176: procedure chk_sal_review_period_freq
1177: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1178: ,p_sal_review_period_frequency in
1179: per_all_assignments_f.sal_review_period_frequency%TYPE
1180: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1181: ,p_effective_date in date
1175: --
1176: procedure chk_sal_review_period_freq
1177: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1178: ,p_sal_review_period_frequency in
1179: per_all_assignments_f.sal_review_period_frequency%TYPE
1180: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1181: ,p_effective_date in date
1182: ,p_validation_start_date in date
1183: ,p_validation_end_date in date
1176: procedure chk_sal_review_period_freq
1177: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1178: ,p_sal_review_period_frequency in
1179: per_all_assignments_f.sal_review_period_frequency%TYPE
1180: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1181: ,p_effective_date in date
1182: ,p_validation_start_date in date
1183: ,p_validation_end_date in date
1184: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1180: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1181: ,p_effective_date in date
1182: ,p_validation_start_date in date
1183: ,p_validation_end_date in date
1184: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1185: );
1186: --
1187: -- --------------------------------------------------------------------------+
1188: -- |-----------------------< chk_sal_review_period >------------------------|
1217: -- Access Status:
1218: -- Internal Table Handler Use Only.
1219: --
1220: procedure chk_sal_review_period
1221: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1222: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
1223: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1224: ,p_effective_date in date
1225: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1218: -- Internal Table Handler Use Only.
1219: --
1220: procedure chk_sal_review_period
1221: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1222: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
1223: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1224: ,p_effective_date in date
1225: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1226: );
1219: --
1220: procedure chk_sal_review_period
1221: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1222: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
1223: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1224: ,p_effective_date in date
1225: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1226: );
1227: --
1221: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1222: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
1223: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1224: ,p_effective_date in date
1225: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1226: );
1227: --
1228: -- --------------------------------------------------------------------------+
1229: -- |---------------------< chk_sal_rp_freq_sal_rp >--------------------------|
1257: -- Access Status:
1258: -- Internal Table Handler Use Only.
1259: --
1260: procedure chk_sal_rp_freq_sal_rp
1261: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1262: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
1263: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
1264: ,p_effective_date in date
1265: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1258: -- Internal Table Handler Use Only.
1259: --
1260: procedure chk_sal_rp_freq_sal_rp
1261: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1262: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
1263: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
1264: ,p_effective_date in date
1265: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1266: );
1259: --
1260: procedure chk_sal_rp_freq_sal_rp
1261: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1262: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
1263: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
1264: ,p_effective_date in date
1265: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1266: );
1267: --
1261: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1262: ,p_sal_review_period_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
1263: ,p_sal_review_period in per_all_assignments_f.sal_review_period%TYPE
1264: ,p_effective_date in date
1265: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1266: );
1267: --
1268: -- --------------------------------------------------------------------------+
1269: -- |-----------------------< chk_set_of_books_id >---------------------------|
1314: -- Access Status:
1315: -- Internal Table Handler Use Only
1316: --
1317: procedure chk_set_of_books_id
1318: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1319: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1320: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1321: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
1322: ,p_effective_date in date
1315: -- Internal Table Handler Use Only
1316: --
1317: procedure chk_set_of_books_id
1318: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1319: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1320: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1321: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
1322: ,p_effective_date in date
1323: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1316: --
1317: procedure chk_set_of_books_id
1318: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1319: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1320: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1321: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
1322: ,p_effective_date in date
1323: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1324: );
1317: procedure chk_set_of_books_id
1318: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1319: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1320: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1321: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
1322: ,p_effective_date in date
1323: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1324: );
1325: --
1319: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1320: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1321: ,p_set_of_books_id in per_all_assignments_f.set_of_books_id%TYPE
1322: ,p_effective_date in date
1323: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1324: );
1325: --
1326: -- --------------------------------------------------------------------------+
1327: -- |--------------------< chk_soft_coding_keyflex_id >-----------------------|
1379: -- Access Status:
1380: -- Internal Table Handler Use Only.
1381: --
1382: procedure chk_soft_coding_keyflex_id
1383: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1384: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1385: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
1386: ,p_effective_date in date
1387: ,p_validation_start_date in date
1380: -- Internal Table Handler Use Only.
1381: --
1382: procedure chk_soft_coding_keyflex_id
1383: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1384: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1385: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
1386: ,p_effective_date in date
1387: ,p_validation_start_date in date
1388: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1381: --
1382: procedure chk_soft_coding_keyflex_id
1383: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1384: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1385: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
1386: ,p_effective_date in date
1387: ,p_validation_start_date in date
1388: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1389: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
1384: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1385: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
1386: ,p_effective_date in date
1387: ,p_validation_start_date in date
1388: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1389: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
1390: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1391: );
1392: --
1385: ,p_soft_coding_keyflex_id in per_all_assignments_f.soft_coding_keyflex_id%TYPE
1386: ,p_effective_date in date
1387: ,p_validation_start_date in date
1388: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1389: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
1390: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1391: );
1392: --
1393: -- --------------------------------------------------------------------------+
1386: ,p_effective_date in date
1387: ,p_validation_start_date in date
1388: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1389: ,p_payroll_id in per_all_assignments_f.payroll_id%TYPE
1390: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1391: );
1392: --
1393: -- --------------------------------------------------------------------------+
1394: -- |--------------------< chk_source_organization_id >-----------------------|
1441: -- Access Status:
1442: -- Internal Table Handler Use Only.
1443: --
1444: procedure chk_source_organization_id
1445: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1446: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1447: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1448: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
1449: ,p_effective_date in date
1442: -- Internal Table Handler Use Only.
1443: --
1444: procedure chk_source_organization_id
1445: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1446: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1447: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1448: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
1449: ,p_effective_date in date
1450: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1443: --
1444: procedure chk_source_organization_id
1445: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1446: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1447: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1448: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
1449: ,p_effective_date in date
1450: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1451: ,p_validation_start_date in date
1444: procedure chk_source_organization_id
1445: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1446: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1447: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1448: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
1449: ,p_effective_date in date
1450: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1451: ,p_validation_start_date in date
1452: ,p_validation_end_date in date
1446: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1447: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1448: ,p_source_organization_id in per_all_assignments_f.source_organization_id%TYPE
1449: ,p_effective_date in date
1450: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1451: ,p_validation_start_date in date
1452: ,p_validation_end_date in date
1453: );
1454: --
1499: -- Access Status:
1500: -- Internal Table Handler Use Only
1501: --
1502: procedure chk_source_type
1503: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1504: ,p_source_type in per_all_assignments_f.source_type%TYPE
1505: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
1506: ,p_effective_date in date
1507: ,p_validation_start_date in date
1500: -- Internal Table Handler Use Only
1501: --
1502: procedure chk_source_type
1503: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1504: ,p_source_type in per_all_assignments_f.source_type%TYPE
1505: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
1506: ,p_effective_date in date
1507: ,p_validation_start_date in date
1508: ,p_validation_end_date in date
1501: --
1502: procedure chk_source_type
1503: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1504: ,p_source_type in per_all_assignments_f.source_type%TYPE
1505: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
1506: ,p_effective_date in date
1507: ,p_validation_start_date in date
1508: ,p_validation_end_date in date
1509: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1505: ,p_recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%TYPE
1506: ,p_effective_date in date
1507: ,p_validation_start_date in date
1508: ,p_validation_end_date in date
1509: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1510: );
1511: --
1512: -- --------------------------------------------------------------------------+
1513: -- |-------------------< chk_special_ceiling_step_id >-----------------------|
1576: -- Access Status:
1577: -- Internal Table Handler Use Only.
1578: --
1579: procedure chk_special_ceiling_step_id
1580: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1582: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1583: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1584: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1577: -- Internal Table Handler Use Only.
1578: --
1579: procedure chk_special_ceiling_step_id
1580: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1582: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1583: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1584: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1585: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1578: --
1579: procedure chk_special_ceiling_step_id
1580: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1582: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1583: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1584: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1585: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1586: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1579: procedure chk_special_ceiling_step_id
1580: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1582: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1583: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1584: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1585: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1586: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1587: ,p_effective_date in date
1580: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1582: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1583: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1584: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1585: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1586: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1587: ,p_effective_date in date
1588: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1581: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1582: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1583: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1584: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1585: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1586: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1587: ,p_effective_date in date
1588: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1589: );
1582: ,p_special_ceiling_step_id in per_all_assignments_f.special_ceiling_step_id%TYPE
1583: ,p_grade_id in per_all_assignments_f.grade_id%TYPE
1584: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1585: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1586: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1587: ,p_effective_date in date
1588: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1589: );
1590: --
1584: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1585: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1586: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1587: ,p_effective_date in date
1588: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1589: );
1590: --
1591: -- --------------------------------------------------------------------------+
1592: -- |--------------------------< chk_supervisor_id >--------------------------|
1641: -- Access Status:
1642: -- Internal Table Handler Use Only.
1643: --
1644: procedure chk_supervisor_id
1645: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1646: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
1647: ,p_person_id in per_all_assignments_f.person_id%TYPE
1648: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1649: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1642: -- Internal Table Handler Use Only.
1643: --
1644: procedure chk_supervisor_id
1645: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1646: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
1647: ,p_person_id in per_all_assignments_f.person_id%TYPE
1648: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1649: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1650: ,p_effective_date in date
1643: --
1644: procedure chk_supervisor_id
1645: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1646: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
1647: ,p_person_id in per_all_assignments_f.person_id%TYPE
1648: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1649: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1650: ,p_effective_date in date
1651: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1644: procedure chk_supervisor_id
1645: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1646: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
1647: ,p_person_id in per_all_assignments_f.person_id%TYPE
1648: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1649: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1650: ,p_effective_date in date
1651: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1652: );
1645: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1646: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
1647: ,p_person_id in per_all_assignments_f.person_id%TYPE
1648: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1649: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1650: ,p_effective_date in date
1651: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1652: );
1653: --
1647: ,p_person_id in per_all_assignments_f.person_id%TYPE
1648: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1649: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1650: ,p_effective_date in date
1651: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1652: );
1653: --
1654: -- --------------------------------------------------------------------------+
1655: -- |------------------< chk_supervisor_assignment_id >-----------------------|
1689: -- Access Status:
1690: -- Internal Row Handler Use Only.
1691: --
1692: procedure chk_supervisor_assignment_id
1693: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1694: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
1695: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
1696: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1697: ,p_effective_date in date
1690: -- Internal Row Handler Use Only.
1691: --
1692: procedure chk_supervisor_assignment_id
1693: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1694: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
1695: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
1696: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1697: ,p_effective_date in date
1698: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1691: --
1692: procedure chk_supervisor_assignment_id
1693: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1694: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
1695: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
1696: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1697: ,p_effective_date in date
1698: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1699: );
1692: procedure chk_supervisor_assignment_id
1693: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1694: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
1695: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
1696: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1697: ,p_effective_date in date
1698: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1699: );
1700: --
1694: ,p_supervisor_id in per_all_assignments_f.supervisor_id%TYPE
1695: ,p_supervisor_assignment_id in out nocopy per_all_assignments_f.supervisor_assignment_id%TYPE
1696: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1697: ,p_effective_date in date
1698: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1699: );
1700: --
1701: -- --------------------------------------------------------------------------+
1702: -- |-----------------------< chk_system_pers_type >--------------------------|
1726: -- Access Status:
1727: -- Internal Table Handler Use Only.
1728: --
1729: procedure chk_system_pers_type
1730: (p_person_id in per_all_assignments_f.person_id%TYPE
1731: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1732: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1733: ,p_datetrack_mode in varchar2
1734: ,p_effective_date in date
1727: -- Internal Table Handler Use Only.
1728: --
1729: procedure chk_system_pers_type
1730: (p_person_id in per_all_assignments_f.person_id%TYPE
1731: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1732: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1733: ,p_datetrack_mode in varchar2
1734: ,p_effective_date in date
1735: );
1728: --
1729: procedure chk_system_pers_type
1730: (p_person_id in per_all_assignments_f.person_id%TYPE
1731: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
1732: ,p_validation_end_date in per_all_assignments_f.effective_end_date%TYPE
1733: ,p_datetrack_mode in varchar2
1734: ,p_effective_date in date
1735: );
1736: --
1767: -- Access Status:
1768: -- Internal Table Handler Use Only.
1769: --
1770: procedure chk_term_status
1771: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1772: ,p_datetrack_mode in varchar2
1773: ,p_validation_start_date in date
1774: );
1775: --
1799: -- Access Status:
1800: -- Internal Table Handler Use Only.
1801: --
1802: procedure chk_time_normal_finish
1803: (p_time_normal_finish in per_all_assignments_f.time_normal_finish%TYPE
1804: );
1805: --
1806: --
1807: procedure chk_time_finish_formatted
1804: );
1805: --
1806: --
1807: procedure chk_time_finish_formatted
1808: (p_time_normal_finish in out nocopy per_all_assignments_f.time_normal_finish%TYPE
1809: );
1810: --
1811: -- --------------------------------------------------------------------------+
1812: -- |---------------------< chk_time_normal_start >---------------------------|
1831: -- Access Status:
1832: -- Internal Table Handler Use Only.
1833: --
1834: procedure chk_time_normal_start
1835: (p_time_normal_start in per_all_assignments_f.time_normal_start%TYPE
1836: );
1837: --
1838: --
1839: procedure chk_time_start_formatted
1836: );
1837: --
1838: --
1839: procedure chk_time_start_formatted
1840: (p_time_normal_start in out nocopy per_all_assignments_f.time_normal_start%TYPE
1841: );
1842: --
1843: -- --------------------------------------------------------------------------+
1844: -- |------------------------< chk_dup_apl_vacancy >---------------------------|
1866: -- If condition met then an application error is raised
1867: -- and processing is terminated
1868: --
1869: procedure chk_dup_apl_vacancy
1870: (p_person_id in per_all_assignments_f.person_id%type
1871: ,p_business_group_id in per_all_assignments_f.business_group_id%type
1872: ,p_vacancy_id in per_all_assignments_f.vacancy_id%type
1873: ,p_effective_date in date
1874: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
1867: -- and processing is terminated
1868: --
1869: procedure chk_dup_apl_vacancy
1870: (p_person_id in per_all_assignments_f.person_id%type
1871: ,p_business_group_id in per_all_assignments_f.business_group_id%type
1872: ,p_vacancy_id in per_all_assignments_f.vacancy_id%type
1873: ,p_effective_date in date
1874: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
1875: );
1868: --
1869: procedure chk_dup_apl_vacancy
1870: (p_person_id in per_all_assignments_f.person_id%type
1871: ,p_business_group_id in per_all_assignments_f.business_group_id%type
1872: ,p_vacancy_id in per_all_assignments_f.vacancy_id%type
1873: ,p_effective_date in date
1874: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
1875: );
1876: --
1870: (p_person_id in per_all_assignments_f.person_id%type
1871: ,p_business_group_id in per_all_assignments_f.business_group_id%type
1872: ,p_vacancy_id in per_all_assignments_f.vacancy_id%type
1873: ,p_effective_date in date
1874: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE default null
1875: );
1876: --
1877: -- --------------------------------------------------------------------------+
1878: -- |-------------------------< chk_vacancy_id >------------------------------|
1924: -- Access Status:
1925: -- Internal Table Handler Use Only.
1926: --
1927: procedure chk_vacancy_id
1928: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1929: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1930: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1931: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1932: ,p_effective_date in date
1925: -- Internal Table Handler Use Only.
1926: --
1927: procedure chk_vacancy_id
1928: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1929: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1930: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1931: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1932: ,p_effective_date in date
1933: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1926: --
1927: procedure chk_vacancy_id
1928: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1929: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1930: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1931: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1932: ,p_effective_date in date
1933: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1934: ,p_validation_start_date in date
1927: procedure chk_vacancy_id
1928: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
1929: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1930: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1931: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1932: ,p_effective_date in date
1933: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1934: ,p_validation_start_date in date
1935: ,p_validation_end_date in date
1929: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1930: ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
1931: ,p_vacancy_id in per_all_assignments_f.vacancy_id%TYPE
1932: ,p_effective_date in date
1933: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1934: ,p_validation_start_date in date
1935: ,p_validation_end_date in date
1936: );
1937: --
1965: -- Access Status:
1966: -- Internal Table Handler Use Only.
1967: --
1968: procedure gen_assignment_sequence
1969: (p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1970: ,p_person_id in per_all_assignments_f.person_id%TYPE
1971: ,p_assignment_sequence in out nocopy per_all_assignments_f.assignment_sequence%TYPE
1972: );
1973: --
1966: -- Internal Table Handler Use Only.
1967: --
1968: procedure gen_assignment_sequence
1969: (p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1970: ,p_person_id in per_all_assignments_f.person_id%TYPE
1971: ,p_assignment_sequence in out nocopy per_all_assignments_f.assignment_sequence%TYPE
1972: );
1973: --
1974: -- --------------------------------------------------------------------------+
1967: --
1968: procedure gen_assignment_sequence
1969: (p_assignment_type in per_all_assignments_f.assignment_type%TYPE
1970: ,p_person_id in per_all_assignments_f.person_id%TYPE
1971: ,p_assignment_sequence in out nocopy per_all_assignments_f.assignment_sequence%TYPE
1972: );
1973: --
1974: -- --------------------------------------------------------------------------+
1975: -- |-----------------------< other_managers_in_org >-------------------------|
1998: -- Access Status:
1999: -- Internal Table Handler Use Only.
2000: --
2001: function other_managers_in_org
2002: (p_organization_id in per_all_assignments_f.organization_id%TYPE
2003: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2004: ,p_effective_date in date
2005: ) return boolean;
2006: --
1999: -- Internal Table Handler Use Only.
2000: --
2001: function other_managers_in_org
2002: (p_organization_id in per_all_assignments_f.organization_id%TYPE
2003: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2004: ,p_effective_date in date
2005: ) return boolean;
2006: --
2007: -- --------------------------------------------------------------------------+
2046: -- Access Status:
2047: -- Internal Table Handler Use Only.
2048: --
2049: procedure gen_date_probation_end
2050: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2051: ,p_effective_date in date
2052: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2053: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2054: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2048: --
2049: procedure gen_date_probation_end
2050: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2051: ,p_effective_date in date
2052: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2053: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2054: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2055: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2056: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
2049: procedure gen_date_probation_end
2050: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2051: ,p_effective_date in date
2052: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2053: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2054: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2055: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2056: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
2057: );
2050: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2051: ,p_effective_date in date
2052: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2053: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2054: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2055: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2056: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
2057: );
2058: --
2051: ,p_effective_date in date
2052: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2053: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2054: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2055: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2056: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
2057: );
2058: --
2059: -- --------------------------------------------------------------------------+
2052: ,p_probation_unit in per_all_assignments_f.probation_unit%TYPE
2053: ,p_probation_period in per_all_assignments_f.probation_period%TYPE
2054: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
2055: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2056: ,p_date_probation_end in out nocopy per_all_assignments_f.date_probation_end%TYPE
2057: );
2058: --
2059: -- --------------------------------------------------------------------------+
2060: -- |--------------------< chk_internal_address_line >-----------------------|
2088: -- Access Status:
2089: -- Internal Table Handler Use Only.
2090: --
2091: procedure chk_internal_address_line
2092: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2093: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2094: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE
2095: ,p_effective_date in date
2096: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2089: -- Internal Table Handler Use Only.
2090: --
2091: procedure chk_internal_address_line
2092: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2093: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2094: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE
2095: ,p_effective_date in date
2096: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2097: );
2090: --
2091: procedure chk_internal_address_line
2092: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2093: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2094: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE
2095: ,p_effective_date in date
2096: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2097: );
2098: end per_asg_bus2;
2092: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
2093: ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
2094: ,p_internal_address_line in per_all_assignments_f.internal_address_line%TYPE
2095: ,p_effective_date in date
2096: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
2097: );
2098: end per_asg_bus2;