1 Package per_asg_bus3 AUTHID CURRENT_USER as
2 /* $Header: peasgrhi.pkh 120.7 2011/03/08 09:20:38 sidsaxen ship $ */
3 --
4 -- ---------------------------------------------------------------------------
5 -- |-------------------------< chk_vendor_id >-------------------------------|
6 -- ---------------------------------------------------------------------------
7 --
8 -- Description:
9 --
10 -- - Validates that the assignment is a contingent worker assignment.
11 -- - Validates that the Supplier is effective and enabled.
12 --
13 -- Pre-conditions:
14 -- A valid assignment type.
15 --
16 -- In Arguments:
17 -- As below.
18 --
19 -- Post Success:
20 -- Processing continues if the above validation passes and no
21 -- error is raised.
22 --
23 -- Post Failure:
24 -- If the above validation fails, an error is raised and processing
25 -- halts.
26 --
27 -- Access Status:
28 -- Internal Row Handler Use Only.
29 --
30 PROCEDURE chk_vendor_id
31 (p_assignment_id IN NUMBER
32 ,p_assignment_type IN VARCHAR2
33 ,p_vendor_id IN NUMBER
34 ,p_business_group_id IN NUMBER
35 ,p_object_version_number IN NUMBER
36 ,p_effective_date IN DATE);
37 --
38 -- ---------------------------------------------------------------------------
39 -- |-------------------------< chk_vendor_site_id >---------------------------|
40 -- ---------------------------------------------------------------------------
41 --
42 -- Description:
43 --
44 -- - Validates that the assignment is a contingent worker assignment.
45 -- - Validates that the Supplier Site exists in po_vendor_sites_all.
46 --
47 -- Pre-conditions:
48 -- A valid assignment type.
49 --
50 -- In Arguments:
51 -- As below.
52 --
53 -- Post Success:
54 -- Processing continues if the above validation passes and no
55 -- error is raised.
56 --
57 -- Post Failure:
58 -- If the above validation fails, an error is raised and processing
59 -- halts.
60 --
61 -- Access Status:
62 -- Internal Row Handler Use Only.
63 --
64 PROCEDURE chk_vendor_site_id
65 (p_assignment_id IN NUMBER
66 ,p_assignment_type IN VARCHAR2
67 ,p_vendor_site_id IN NUMBER
68 ,p_object_version_number IN NUMBER
69 ,p_effective_date IN DATE);
70 --
71 -- ---------------------------------------------------------------------------
72 -- |-------------------------< chk_po_header_id >-----------------------------|
73 -- ---------------------------------------------------------------------------
74 --
75 -- Description:
76 --
77 -- - Validates that the assignment is a contingent worker assignment.
78 -- - Validates that Services Procurement is installed.
79 -- - Validates that the PO is a Services Procurement PO, that it is of
80 -- a valid status (for example, Approved), that it exists within the
81 -- business group and that there is at least one purchase order line
82 -- which is of a Services Procurement line type and is unassigned
83 -- to any other HR assignment.
84 --
85 -- Pre-conditions:
86 -- A valid assignment type.
87 -- A valid business group.
88 --
89 -- In Arguments:
90 -- As below.
91 --
92 -- Post Success:
93 -- Processing continues if the above validation passes and no
94 -- error is raised.
95 --
96 -- Post Failure:
97 -- If the above validation fails, an error is raised and processing
98 -- halts.
99 --
100 -- Access Status:
101 -- Internal Row Handler Use Only.
102 --
103 PROCEDURE chk_po_header_id
104 (p_assignment_id IN NUMBER
105 ,p_assignment_type IN VARCHAR2
106 ,p_po_header_id IN NUMBER
107 ,p_business_group_id IN NUMBER
108 ,p_object_version_number IN NUMBER
109 ,p_effective_date IN DATE);
110 --
111 -- ---------------------------------------------------------------------------
112 -- |-------------------------< chk_po_line_id >-------------------------------|
113 -- ---------------------------------------------------------------------------
114 --
115 -- Description:
116 --
117 -- - Validates that the assignment is a contingent worker assignment.
118 -- - Validates that Services Procurement is installed.
119 -- - Validates that the PO Line has at least one purchase order line
120 -- which is of a Services Procurement line type and is unassigned
121 -- to any other HR assignment.
122 --
123 -- Pre-conditions:
124 -- A valid assignment type.
125 --
126 -- In Arguments:
127 -- As below.
128 --
129 -- Post Success:
130 -- Processing continues if the above validation passes and no
131 -- error is raised.
132 --
133 -- Post Failure:
134 -- If the above validation fails, an error is raised and processing
135 -- halts.
136 --
137 -- Access Status:
138 -- Internal Row Handler Use Only.
139 --
140 PROCEDURE chk_po_line_id
144 ,p_object_version_number IN NUMBER
141 (p_assignment_id IN NUMBER
142 ,p_assignment_type IN VARCHAR2
143 ,p_po_line_id IN NUMBER
145 ,p_effective_date IN DATE);
146 --
147 -- ---------------------------------------------------------------------------
148 -- |-------------------------< chk_projected_assignment_end >-----------------|
149 -- ---------------------------------------------------------------------------
150 --
151 -- Description:
152 --
153 -- - Validates that the assignment is a contingent worker assignment.
154 -- - Validates that the Projected Assignment End is not earlier than
155 -- the assignment effective start date.
156 --
157 -- Pre-conditions:
158 -- A valid effective_start_date
159 --
160 -- In Arguments:
161 -- As below.
162 --
163 -- Post Success:
164 -- Processing continues if the above validation passes and no
165 -- error is raised.
166 --
167 -- Post Failure:
168 -- If the above validation fails, an error is raised and processing
169 -- halts.
170 --
171 -- Access Status:
172 -- Internal Row Handler Use Only.
173 --
174 PROCEDURE chk_projected_assignment_end
175 (p_assignment_id IN NUMBER
176 ,p_assignment_type IN VARCHAR2
177 ,p_effective_start_date IN DATE
178 ,p_projected_assignment_end IN DATE
179 ,p_object_version_number IN NUMBER
180 ,p_effective_date IN DATE);
181 --
182 -- ---------------------------------------------------------------------------
183 -- |-------------------------< chk_vendor_id_site_id >------------------------|
184 -- ---------------------------------------------------------------------------
185 --
186 -- Description:
187 --
188 -- - Validates that the Supplier Site belongs to the given Supplier.
189 --
190 -- Pre-conditions:
191 -- - Vendor_id has been validated.
192 -- - Vendor_site_id has been validated.
193 --
194 -- In Arguments:
195 -- As below.
196 --
197 -- Post Success:
198 -- Processing continues if the above validation passes and no
199 -- error is raised.
200 --
201 -- Post Failure:
202 -- If the above validation fails, an error is raised and processing
203 -- halts.
204 --
205 -- Access Status:
206 -- Internal Row Handler Use Only.
207 --
208 PROCEDURE chk_vendor_id_site_id
209 (p_assignment_id IN NUMBER
210 ,p_vendor_id IN NUMBER
211 ,p_vendor_site_id IN NUMBER
212 ,p_object_version_number IN NUMBER
213 ,p_effective_date IN DATE);
214 --
215 -- ---------------------------------------------------------------------------
216 -- |-------------------------< chk_po_header_id_line_id >---------------------|
217 -- ---------------------------------------------------------------------------
218 --
219 -- Description:
220 --
221 -- - Validates that the Purchase Order Line exists within the Purchase Order.
222 --
223 -- Pre-conditions:
224 -- - Purchase Order has been validated.
225 -- - Purchase Order line has been validated.
226 --
227 -- In Arguments:
228 -- As below.
229 --
230 -- Post Success:
231 -- Processing continues if the above validation passes and no
232 -- error is raised.
233 --
234 -- Post Failure:
235 -- If the above validation fails, an error is raised and processing
236 -- halts.
237 --
238 -- Access Status:
239 -- Internal Row Handler Use Only.
240 --
241 PROCEDURE chk_po_header_id_line_id
242 (p_assignment_id IN NUMBER
243 ,p_po_header_id IN NUMBER
244 ,p_po_line_id IN NUMBER
245 ,p_object_version_number IN NUMBER
246 ,p_effective_date IN DATE);
247 --
248 -- ---------------------------------------------------------------------------
249 -- |-------------------------< chk_vendor_po_match >--------------------------|
250 -- ---------------------------------------------------------------------------
251 --
252 -- Description:
253 --
254 -- - Validates that the Supplier and Supplier Site on the assignment is the
255 -- same as the Supplier on the Purchase Order.
256 --
257 -- Pre-conditions:
258 -- A valid Supplier.
259 -- A valid Supplier Site.
260 -- A valid Purchase Order header.
261 --
262 -- In Arguments:
263 -- As below.
264 --
265 -- Post Success:
266 -- Processing continues if the above validation passes and no
267 -- error is raised.
268 --
269 -- Post Failure:
270 -- If the above validation fails, an error is raised and processing
271 -- halts.
272 --
273 -- Access Status:
274 -- Internal Row Handler Use Only.
275 --
276 PROCEDURE chk_vendor_po_match
277 (p_assignment_id IN NUMBER
278 ,p_vendor_id IN NUMBER
279 ,p_vendor_site_id IN NUMBER
280 ,p_po_header_id IN NUMBER
281 ,p_object_version_number IN NUMBER
282 ,p_effective_date IN DATE);
283 --
284 -- ---------------------------------------------------------------------------
285 -- |-------------------------< chk_po_job_match >-----------------------------|
286 -- ---------------------------------------------------------------------------
287 --
288 -- Description:
289 --
290 -- - Validates that the job on the assignment matches the job on the
291 -- Purchase Order Line.
292 --
293 -- Pre-conditions:
294 -- A valid Job.
298 -- As below.
295 -- A valid Purchase Order line.
296 --
297 -- In Arguments:
299 --
300 -- Post Success:
301 -- Processing continues if the above validation passes and no
302 -- error is raised.
303 --
304 -- Post Failure:
305 -- If the above validation fails, an error is raised and processing
306 -- halts.
307 --
308 -- Access Status:
309 -- Internal Row Handler Use Only.
310 --
311 PROCEDURE chk_po_job_match
312 (p_assignment_id IN NUMBER
313 ,p_job_id IN NUMBER
314 ,p_po_line_id IN NUMBER
315 ,p_object_version_number IN NUMBER
316 ,p_effective_date IN DATE);
317 --
318 -- ---------------------------------------------------------------------------
319 -- |-------------------------< chk_vendor_employee_number >-------------------|
320 -- ---------------------------------------------------------------------------
321 --
322 -- Description:
323 --
324 -- - Validates that the assignment is an non payrolled worker assignment.
325 -- - Validates that the vendor employee number is set for an NPW assignment.
326 --
327 -- Pre-conditions:
328 -- A valid assignment type
329 -- A Valid business group
330 --
331 -- In Arguments:
332 -- p_assignment_id
333 -- p_business_group_id
334 -- p_vendor_employee_number
335 -- p_assignment_type
336 -- p_effective_date
337 -- p_object_version_number
338 --
339 -- Post Success:
340 -- Processing continues if:
341 -- - the assignment is an NPW assignment.
342 -- - vendor empoyee number is set for an NPW assignment.
343 --
344 -- Post Failure:
345 -- An application error is raised and processing ends if:
346 -- - the assignment is not an NPW assignment.
347 -- - vendor employee number is not set for a NPW assignment.
348 --
349 -- Access Status:
350 -- Internal Table Handler Use Only.
351 --
352 PROCEDURE chk_vendor_employee_number
353 (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
354 ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
355 ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
356 ,p_business_group_id IN per_assignments_f.business_group_id%TYPE
357 ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
358 ,p_effective_date IN DATE);
359 --
360 -- ---------------------------------------------------------------------------
361 -- |----------------------< chk_vendor_assignment_number >-------------------|
362 -- ---------------------------------------------------------------------------
363 --
364 -- Description:
365 --
366 -- - Validates that the assignment is an non payrolled worker assignment.
367 -- - Validates that the vendor assignment number is set for an NPW assignment.
368 --
369 -- Pre-conditions:
370 -- A valid assignment type
371 -- A Valid business group
372 --
373 -- In Arguments:
374 -- p_assignment_id
375 -- p_business_group_id
376 -- p_vendor_assignment_number
377 -- p_assignment_type
378 -- p_effective_date
379 -- p_object_version_number
380 --
381 -- Post Success:
382 -- Processing continues if:
383 -- - the assignment is an NPW assignment.
384 -- - vendor assignment number is set for an NPW assignment.
385 --
386 -- Post Failure:
387 -- An application error is raised and processing ends if:
388 -- - the assignment is not an NPW assignment.
389 -- - vendor assignment number is not set for a NPW assignment.
390 --
391 -- Access Status:
392 -- Internal Table Handler Use Only.
393 --
394 PROCEDURE chk_vendor_assignment_number
395 (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
396 ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
397 ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
398 ,p_business_group_id IN per_assignments_f.business_group_id%TYPE
399 ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
400 ,p_effective_date IN DATE);
401 --
402 -- ---------------------------------------------------------------------------
403 -- |---------------------------< chk_pop_date_start >------------------------|
404 -- ---------------------------------------------------------------------------
405 --
406 -- Description:
407 --
408 -- - Validates that the assignment is an non payrolled worker assignment.
409 -- - Validates that the period of placement date start is set for
410 -- an NPW assignment.
411 -- - Validates that the period of placement date start exists in
412 -- PER_PERIODS_OF_PLACEMENTS between the period of service date start
413 -- and actual termination date and for the person id.
414 -- - Validates that the business_group_id of the Assignment is the same as
415 -- that of the period of placement.
416 -- - Validates that the effective start date of the assignment is between
417 -- the date start and actual termination date of the period of placement.
418 --
419 -- Pre-conditions:
420 -- A valid Person
421 -- A valid assignment type
422 -- A Valid business group
423 --
424 -- In Arguments:
425 -- p_assignment_id
426 -- p_business_group_id
427 -- p_person_id
428 -- p_assignment_type
429 -- p_pop_date_start
430 -- p_effective_date
434 --
431 -- p_validation_start_date
432 -- p_validation_end_date
433 -- p_object_version_number
435 -- Post Success:
436 -- Processing continues if:
437 -- - the assignment is an NPW assignment.
438 -- - period of placement is set for an NPW assignment.
439 -- - period of placement exists in PER_PERIODS_OF_PLACMENT between
440 -- date start and actual termination date and for the person id.
441 -- - the period of placment is in the same business group as the
442 -- assignment business group.
443 -- - the effective start date of the assignment is between date start
444 -- and actual termination date of the period of placement.
445 --
446 -- Post Failure:
447 -- An application error is raised and processing ends if:
448 -- - the assignment is not an NPW assignment.
449 -- - period of placement is not set for a NPW assignment.
450 -- - period of placement does'nt exist in PER_PERIODS_OF_PLACEMENT between
451 -- date start and actual termination date and for the person_id
452 -- - the period of placement is in a different business group to
453 -- the assignment business group.
454 -- - the effective start date of the assignment is not between date
455 -- start and actual termination date of the period of placement.
456 --
457 -- Access Status:
458 -- Internal Table Handler Use Only.
459 --
460 PROCEDURE chk_pop_date_start
461 (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
462 ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
463 ,p_person_id IN per_all_assignments_f.person_id%TYPE
464 ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
465 ,p_pop_date_start IN per_periods_of_placement.date_start%TYPE
466 ,p_validation_start_date IN DATE
467 ,p_validation_end_date IN DATE
468 ,p_effective_date IN DATE
469 ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
470 );
471 --
472 -- --------------------------------------------------------------------------+
473 -- |--------------------< chk_cagr_grade_def_id >---------------------------|
474 -- --------------------------------------------------------------------------+
475 --
476 -- Description:
477 -- - Validates that the assignment cagr_grade_def_id is valid.
478 --
479 -- Pre-conditions:
480 -- A valid cagr_id_flex_num
481 --
482 -- In Arguments:
483 -- p_assignment_id
484 -- p_effective_date
485 -- p_object_version_number
486 -- p_cagr_grade_def_id
487 -- p_collective_agreement_id
488 -- p_cagr_id_flex_num
489 --
490 -- Post Success:
491 -- Processing continues if:
492 -- - the cagr_grade_def_id is valid for an employee assignment.
493 --
494 -- Post Failure:
495 -- An application error is raised and processing ends if:
496 -- - the cagr_grade_def_id / p_collective_agreement_id combination is
497 -- invalid.
498 -- - The user has tried to insert a new grade, hwen only reference grades
499 -- are allowed.
500 --
501 -- Access Status:
502 -- Internal Table Handler Use Only.
503 --
504 procedure chk_cagr_grade_def_id
505 (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
506 ,p_effective_date in date
507 ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
508 ,p_cagr_grade_def_id in per_all_assignments_f.cagr_grade_def_id%TYPE
509 ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
510 ,p_cagr_id_flex_num in per_all_assignments_f.cagr_id_flex_num%TYPE
511 );
512 --
513 -- --------------------------------------------------------------------------+
514 -- |--------------------< chk_cagr_id_flex_num >----------------------------|
515 -- --------------------------------------------------------------------------+
516 --
517 -- Description:
518 -- - Validates that the assignment cagr_id_flex_num is valid.
519 --
520 -- Pre-conditions:
521 -- A validated collective_agreement_id
522 --
523 -- In Arguments:
524 -- p_assignment_id
525 -- p_effective_date
526 -- p_object_version_number
527 -- p_cagr_id_flex_num
528 -- p_collective_agreement_id
529 --
530 -- Post Success:
531 -- Processing continues if:
532 -- - the cagr_id_flex_num is valid for an assignment.
533 --
534 -- Post Failure:
535 -- An application error is raised and processing ends if:
536 -- - the cagr_id_flex_num is invalid.
537 --
538 -- Access Status:
539 -- Internal Table Handler Use Only.
540 --
541 procedure chk_cagr_id_flex_num
542 (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
543 ,p_effective_date in date
544 ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
545 ,p_cagr_id_flex_num in per_all_assignments_f.cagr_id_flex_num%TYPE
546 ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
547 );
548 --
549 -- --------------------------------------------------------------------------+
550 -- |--------------------< chk_contract_id >----------------------------------|
551 -- --------------------------------------------------------------------------+
552 --
553 -- Description:
554 -- - Validates that the assignment contract_id is valid.
555 --
556 -- Pre-conditions:
557 --
558 --
559 -- In Arguments:
563 -- p_contract_id
560 -- p_assignment_id
561 -- p_effective_date
562 -- p_object_version_number
564 -- p_validation_start_date
565 -- p_business_group_id
566 --
567 --
568 -- Post Success:
569 -- Processing continues if:
570 -- - the chk_contract_id is valid for an assignment.
571 --
572 -- Post Failure:
573 -- An application error is raised and processing ends if:
574 -- - the chk_contract_id is invalid.
575 --
576 -- Access Status:
577 -- Internal Table Handler Use Only.
578 --
579 procedure chk_contract_id
580 (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
581 ,p_effective_date in date
582 ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
583 ,p_contract_id in per_all_assignments_f.contract_id%TYPE
584 ,p_person_id in per_all_assignments_f.person_id%TYPE
585 ,p_validation_start_date in date
586 ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
587 );
588 --
589 -- --------------------------------------------------------------------------+
590 -- |--------------------< chk_collective_agreement_id >----------------------|
591 -- --------------------------------------------------------------------------+
592 --
593 -- Description:
594 -- - Validates that the assignment collective_agreement_id is valid.
595 --
596 -- Pre-conditions:
597 -- A validated establishment_id
598 --
599 -- In Arguments:
600 -- p_assignment_id
601 -- p_effective_date
602 -- p_object_version_number
603 -- p_collective_agreement_id
604 -- p_business_group_id
605 -- p_establishment_id
606 --
607 -- Post Success:
608 -- Processing continues if:
609 -- - the collective_agreement_id is valid for an assignment.
610 --
611 -- Post Failure:
612 -- An application error is raised and processing ends if:
613 -- - the collective_agreement_id is invalid.
614 --
615 -- Access Status:
616 -- Internal Table Handler Use Only.
617 --
618 procedure chk_collective_agreement_id
619 (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
620 ,p_effective_date in date
621 ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
622 ,p_collective_agreement_id in per_all_assignments_f.collective_agreement_id%TYPE
623 ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
624 ,p_establishment_id in per_all_assignments_f.establishment_id%TYPE
625 );
626 -- --------------------------------------------------------------------------+
627 -- |--------------------< chk_establishment_id >-----------------------------|
628 -- --------------------------------------------------------------------------+
629 --
630 -- Description:
631 -- - Validates that the assignment establishment_id is valid.
632 --
633 -- Pre-conditions:
634 --
635 --
636 -- In Arguments:
637 -- p_assignment_id
638 -- p_effective_date
639 -- p_object_version_number
640 -- p_establishment_id
641 -- p_business_group_id
642 --
643 -- Post Success:
644 -- Processing continues if:
645 -- - the establishment_id is valid for an assignment.
646 --
647 -- Post Failure:
648 -- An application error is raised and processing ends if:
649 -- - the establishment_id is invalid.
650 --
651 -- Access Status:
652 -- Internal Table Handler Use Only.
653 --
654 procedure chk_establishment_id
655 (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
656 ,p_effective_date in date
657 ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
658 ,p_establishment_id in per_all_assignments_f.establishment_id%TYPE
659 ,p_assignment_type in per_all_assignments_f.assignment_type%TYPE
660 ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
661 );
662
663 -- --------------------------------------------------------------------------+
664 -- |--------------------< chk_notice_period >-----------------------------|
665 -- --------------------------------------------------------------------------+
666 --
667 -- Description:
668 -- - Validates that the notice_period is valid.
669 --
670 -- Pre-conditions:
671 --
672 --
673 -- In Arguments:
674 -- p_assignment_id
675 -- p_notice_period
676
677 --
678 -- Post Success:
679 -- Processing continues if:
680 -- - the notice_period is valid.
681 --
682 -- Post Failure:
683 -- An application error is raised and processing ends if:
684 -- - the notice_period is invalid.
685 --
686 -- Access Status:
687 -- Internal Table Handler Use Only.
688 --
689 procedure chk_notice_period
690 (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
691 ,p_notice_period in per_all_assignments_f.notice_period%TYPE
692 );
693
694 -- --------------------------------------------------------------------------+
695 -- |--------------------< chk_notice_period_uom >-----------------------------|
696 -- --------------------------------------------------------------------------+
697 --
698 -- Description:
699 -- - Validates that the notice_period_uom is valid.
700 --
701 -- Pre-conditions:
702 --
703 --
704 -- In Arguments:
705 -- p_assignment_id
706 -- p_notice_period
707 -- p_notice_period_uom
708 -- p_effective_date
712 -- - the notice_period_uom is valid.
709 --
710 -- Post Success:
711 -- Processing continues if:
713 --
714 -- Post Failure:
715 -- An application error is raised and processing ends if:
716 -- - the notice_period_uom is invalid.
717 --
718 -- Access Status:
719 -- Internal Table Handler Use Only.
720 --
721 procedure chk_notice_period_uom
722 (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
723 ,p_notice_period in per_all_assignments_f.notice_period%TYPE
724 ,p_notice_period_uom in per_all_assignments_f.notice_period_uom%TYPE
725 ,p_effective_date in date
726 ,p_validation_start_date IN DATE
727 ,P_VALIDATION_END_DATE IN DATE
728 );
729
730 -- --------------------------------------------------------------------------+
731 -- |--------------------< chk_work_at_home >-----------------------------|
732 -- --------------------------------------------------------------------------+
733 --
734 -- Description:
735 -- - Validates that the work_at_home is valid.
736 --
737 -- Pre-conditions:
738 --
739 --
740 -- In Arguments:
741 -- p_assignment_id
742 -- p_work_at_home
743 -- p_effective_date
744 --
745 -- Post Success:
746 -- Processing continues if:
747 -- - the work_at_home is valid.
748 --
749 -- Post Failure:
750 -- An application error is raised and processing ends if:
751 -- - the work_at_home is invalid.
752 --
753 -- Access Status:
754 -- Internal Table Handler Use Only.
755 --
756 procedure chk_work_at_home
757 (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
758 ,p_work_at_home in per_all_assignments_f.work_at_home%TYPE
759 ,p_effective_date in date
760 ,p_validation_start_date IN DATE
761 ,P_VALIDATION_END_DATE IN DATE
762 );
763
764 -- --------------------------------------------------------------------------+
765 -- |--------------------< chk_employee_category >---------------------------|
766 -- --------------------------------------------------------------------------+
767 --
768 -- Description:
769 -- - Validates that the employee_category is valid.
770 --
771 -- Pre-conditions:
772 --
773 --
774 -- In Arguments:
775 -- p_assignment_id
776 -- p_employee_category
777 -- p_effective_date
778 --
779 -- Post Success:
780 -- Processing continues if:
781 -- - the employee_category is valid.
782 --
783 -- Post Failure:
784 -- An application error is raised and processing ends if:
785 -- - the employee_category is invalid.
786 --
787 -- Access Status:
788 -- Internal Table Handler Use Only.
789 --
790 procedure chk_employee_category
791 (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
792 ,p_employee_category in per_all_assignments_f.employee_category%TYPE
793 ,p_effective_date in date
794 ,p_validation_start_date IN DATE
795 ,P_VALIDATION_END_DATE IN DATE
796 );
797 --
798 -- --------------------------------------------------------------------------+
799 -- |--------------------< chk_grade_ladder_pgm_id >--------------------------|
800 -- --------------------------------------------------------------------------+
801 --
802 -- Description:
803 -- - Validates that the grade_ladder_pgm_id is valid.
804 --
805 -- Pre-conditions:
806 --
807 --
808 -- In Arguments:
809 -- p_grade_id
810 -- p_grade_ladder_pgm_id
811 -- p_business_group_id
812 -- p_effective_date
813 --
814 -- Post Success:
815 -- Processing continues if:
816 -- - the grade_ladder_pgm_id is valid.
817 --
818 -- Post Failure:
819 -- An application error is raised and processing ends if:
820 -- - the grade_ladder_pgm_id is invalid.
821 --
822 -- Access Status:
823 -- Internal Table Handler Use Only.
824 --
825 procedure chk_grade_ladder_pgm_id
826 ( p_grade_id in per_all_assignments_f.grade_id%TYPE
827 ,p_grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%TYPE
828 ,p_business_group_id in per_all_assignments_f.business_group_id%TYPE
829 ,p_effective_date in date
830 ) ;
831 --
832 -- --------------------------------------------------------------------------+
833 -- |--------------------< access_to_primary_asg >----------------------------|
834 -- --------------------------------------------------------------------------+
835 --
836 -- Description:
837 -- - Determines whether the primary assignment is visible to the current
838 -- session.
839 --
840 -- Pre-conditions:
841 -- Security should have been initialised using fnd_global.apps_initialise.
842 --
843 -- In Arguments:
844 -- p_person_id
845 -- p_effective_date
846 -- p_assignment_type
847 --
848 -- Post Success:
849 -- The function returns TRUE.
850 --
851 -- Post Failure:
852 -- The function returns FALSE.
853 --
854 -- Access Status:
855 -- Internal Development Use Only.
856 --
857 FUNCTION access_to_primary_asg
858 (p_person_id IN NUMBER
859 ,p_effective_date IN DATE
860 ,p_assignment_type IN VARCHAR2)
861 RETURN BOOLEAN;
862 --
863 end per_asg_bus3;
864