1 PACKAGE hr_it_extra_person_rules AS
2 /* $Header: peitexpr.pkh 120.0 2005/05/31 10:27:55 appldev noship $ */
3 --
4 --
5 -- Uses Tobacco:
6 --
7 -- This cannot be entered.
8 --
9 -- Employee Reference No (per_information2):
10 --
11 -- Must be unique.
12 --
13 -- Note: ONLY supports real values.
14 --
15 procedure extra_create_person_checks
16 (p_per_information2 IN VARCHAR2
17 ,p_uses_tobacco_flag IN VARCHAR2
18 ,p_business_group_id IN NUMBER);
19 --
20 -- Uses Tobacco:
21 --
22 -- This cannot be entered.
23 --
24 -- Employee Reference No (per_information2):
25 --
26 -- Must be unique.
27 --
28 -- Note: Supports both real and API system values (these are passed when the value has not
29 -- been changed.
30 --
31 PROCEDURE extra_update_person_checks
32 (p_person_id IN NUMBER
33 ,p_per_information2 IN VARCHAR2
34 ,p_uses_tobacco_flag IN VARCHAR2);
35 --
36 --
37 -- Collective Agreement Grades:
38 --
39 -- If the user is using a collective agreement grade then it must be within the
40 -- predefined structure of IT_CAGR: Grade - Level - Description. This requires that
41 -- the structure is associated with the collective agreement and the collective
42 -- agreement is defined within the business group to which the assignment belongs.
43 --
44 -- The grade structure must be built from the first segment down i.e. cannot have a null
45 -- value followed by an actual value e.g. cannot have a value for level if there is no
46 -- grade.
47 --
48 -- If dynamic inserts is not enabled for the IT_CAGR structure then the combination
49 -- must already exist.
50 --
51 -- Unemployment Insurance Code (p_segment2):
52 --
53 -- This is mandatory.
54 --
55 -- Note: ONLY supports real values.
56 --
57 PROCEDURE extra_create_assignment_checks
58 (p_collective_agreement_id IN NUMBER
59 ,p_cagr_id_flex_num IN NUMBER
60 ,p_organization_id IN NUMBER
61 ,p_cag_segment1 IN VARCHAR2
62 ,p_cag_segment2 IN VARCHAR2
63 ,p_cag_segment3 IN VARCHAR2
64 ,p_scl_segment2 IN VARCHAR2);
65 --
66 --
67 -- Collective Agreement Grades:
68 --
69 -- If the user is using a collective agreement grade then it must be within the
70 -- predefined structure of IT_CAGR: Grade - Level - Description. This requires that
71 -- the structure is associated with the collective agreement and the collective
72 -- agreement is defined within the business group to which the assignment belongs.
73 --
74 -- The grade structure must be built from the first segment down i.e. cannot have a null
75 -- value followed by an actual value e.g. cannot have a value for level if there is no
76 -- grade.
77 --
78 -- If dynamic inserts is not enabled for the IT_CAGR structure then the combination
79 -- must already exist.
80 --
81 -- Unemployment Insurance Code (p_segment2):
82 --
83 -- This is mandatory.
84 --
85 -- Note: Supports both real and API system values (these are passed when the value has not
86 -- been changed.
87 --
88 PROCEDURE extra_update_assignment_checks
89 (p_collective_agreement_id IN NUMBER
90 ,p_cagr_id_flex_num IN NUMBER
91 ,p_assignment_id IN NUMBER
92 ,p_object_version_number IN NUMBER
93 ,p_effective_date IN DATE
94 ,p_cag_segment1 IN VARCHAR2
95 ,p_cag_segment2 IN VARCHAR2
96 ,p_cag_segment3 IN VARCHAR2
97 ,p_segment2 IN VARCHAR2);
98 END hr_it_extra_person_rules;