1 PACKAGE PQH_FR_EMP_STAT_SIT_UTILITY AS
2 /* $Header: pqfresut.pkh 120.0 2005/05/29 01:53:09 appldev noship $ */
3 --
4 -- ----------------------< create_emp_stat_situation >------------------------
5 -- Description:
6 -- This procedure is the self-service wrapper procedure to the following
7 -- API: pqh_fr_emp_stat_situation_api.create_emp_stat_situation
8 -- ---------------------------------------------------------------------------
9 PROCEDURE create_emp_stat_situation
10 (p_validate IN NUMBER DEFAULT HR_API.g_false_num
11 ,p_effective_date IN DATE
12 ,p_statutory_situation_id IN NUMBER
13 ,p_person_id IN NUMBER
14 ,p_provisional_start_date IN DATE
15 ,p_provisional_end_date IN DATE
16 ,p_actual_start_date IN DATE DEFAULT NULL
17 ,p_actual_end_date IN DATE DEFAULT NULL
18 ,p_approval_flag IN VARCHAR2 DEFAULT NULL
19 ,p_comments IN VARCHAR2 DEFAULT NULL
20 ,p_contact_person_id IN NUMBER DEFAULT NULL
21 ,p_contact_relationship IN VARCHAR2 DEFAULT NULL
22 ,p_external_organization_id IN NUMBER DEFAULT NULL
23 ,p_renewal_flag IN VARCHAR2 DEFAULT NULL
24 ,p_renew_stat_situation_id IN NUMBER DEFAULT NULL
25 ,p_seconded_career_id IN NUMBER DEFAULT NULL
26 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
27 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
28 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
29 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
30 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
31 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
32 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
33 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
34 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
35 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
36 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
37 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
38 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
39 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
40 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
41 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
42 ,p_attribute16 IN VARCHAR2 DEFAULT NULL
43 ,p_attribute17 IN VARCHAR2 DEFAULT NULL
44 ,p_attribute18 IN VARCHAR2 DEFAULT NULL
45 ,p_attribute19 IN VARCHAR2 DEFAULT NULL
46 ,p_attribute20 IN VARCHAR2 DEFAULT NULL
47 ,p_attribute21 IN VARCHAR2 DEFAULT NULL
48 ,p_attribute22 IN VARCHAR2 DEFAULT NULL
49 ,p_attribute23 IN VARCHAR2 DEFAULT NULL
50 ,p_attribute24 IN VARCHAR2 DEFAULT NULL
51 ,p_attribute25 IN VARCHAR2 DEFAULT NULL
52 ,p_attribute26 IN VARCHAR2 DEFAULT NULL
53 ,p_attribute27 IN VARCHAR2 DEFAULT NULL
54 ,p_attribute28 IN VARCHAR2 DEFAULT NULL
55 ,p_attribute29 IN VARCHAR2 DEFAULT NULL
56 ,p_attribute30 IN VARCHAR2 DEFAULT NULL
57 ,p_emp_stat_situation_id OUT nocopy NUMBER
58 ,p_object_version_number OUT nocopy NUMBER
59 ,p_return_status OUT nocopy VARCHAR2
60 );
61 --
62 -- ----------------------< update_emp_stat_situation >------------------------
63 -- Description:
64 -- This procedure is the self-service wrapper procedure to the following
65 -- API: pqh_fr_emp_stat_situation_api.update_emp_stat_situation
66 -- ---------------------------------------------------------------------------
67 PROCEDURE update_emp_stat_situation
68 (p_validate IN NUMBER DEFAULT HR_API.g_false_num
69 ,p_effective_date IN DATE
70 ,p_emp_stat_situation_id IN NUMBER
71 ,p_statutory_situation_id IN NUMBER DEFAULT HR_API.g_number
72 ,p_person_id IN NUMBER DEFAULT HR_API.g_number
73 ,p_provisional_start_date IN DATE DEFAULT HR_API.g_date
74 ,p_provisional_end_date IN DATE DEFAULT HR_API.g_date
75 ,p_actual_start_date IN DATE DEFAULT HR_API.g_date
76 ,p_actual_end_date IN DATE DEFAULT HR_API.g_date
77 ,p_approval_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
78 ,p_comments IN VARCHAR2 DEFAULT HR_API.g_varchar2
79 ,p_contact_person_id IN NUMBER DEFAULT HR_API.g_number
80 ,p_contact_relationship IN VARCHAR2 DEFAULT HR_API.g_varchar2
81 ,p_external_organization_id IN NUMBER DEFAULT HR_API.g_number
82 ,p_renewal_flag IN VARCHAR2 DEFAULT HR_API.g_varchar2
83 ,p_renew_stat_situation_id IN NUMBER DEFAULT HR_API.g_number
84 ,p_seconded_career_id IN NUMBER DEFAULT HR_API.g_number
85 ,p_attribute_category IN VARCHAR2 DEFAULT HR_API.g_varchar2
86 ,p_attribute1 IN VARCHAR2 DEFAULT HR_API.g_varchar2
87 ,p_attribute2 IN VARCHAR2 DEFAULT HR_API.g_varchar2
88 ,p_attribute3 IN VARCHAR2 DEFAULT HR_API.g_varchar2
89 ,p_attribute4 IN VARCHAR2 DEFAULT HR_API.g_varchar2
90 ,p_attribute5 IN VARCHAR2 DEFAULT HR_API.g_varchar2
91 ,p_attribute6 IN VARCHAR2 DEFAULT HR_API.g_varchar2
92 ,p_attribute7 IN VARCHAR2 DEFAULT HR_API.g_varchar2
93 ,p_attribute8 IN VARCHAR2 DEFAULT HR_API.g_varchar2
94 ,p_attribute9 IN VARCHAR2 DEFAULT HR_API.g_varchar2
95 ,p_attribute10 IN VARCHAR2 DEFAULT HR_API.g_varchar2
96 ,p_attribute11 IN VARCHAR2 DEFAULT HR_API.g_varchar2
97 ,p_attribute12 IN VARCHAR2 DEFAULT HR_API.g_varchar2
98 ,p_attribute13 IN VARCHAR2 DEFAULT HR_API.g_varchar2
99 ,p_attribute14 IN VARCHAR2 DEFAULT HR_API.g_varchar2
100 ,p_attribute15 IN VARCHAR2 DEFAULT HR_API.g_varchar2
101 ,p_attribute16 IN VARCHAR2 DEFAULT HR_API.g_varchar2
102 ,p_attribute17 IN VARCHAR2 DEFAULT HR_API.g_varchar2
103 ,p_attribute18 IN VARCHAR2 DEFAULT HR_API.g_varchar2
104 ,p_attribute19 IN VARCHAR2 DEFAULT HR_API.g_varchar2
105 ,p_attribute20 IN VARCHAR2 DEFAULT HR_API.g_varchar2
106 ,p_attribute21 IN VARCHAR2 DEFAULT HR_API.g_varchar2
107 ,p_attribute22 IN VARCHAR2 DEFAULT HR_API.g_varchar2
108 ,p_attribute23 IN VARCHAR2 DEFAULT HR_API.g_varchar2
109 ,p_attribute24 IN VARCHAR2 DEFAULT HR_API.g_varchar2
110 ,p_attribute25 IN VARCHAR2 DEFAULT HR_API.g_varchar2
111 ,p_attribute26 IN VARCHAR2 DEFAULT HR_API.g_varchar2
112 ,p_attribute27 IN VARCHAR2 DEFAULT HR_API.g_varchar2
113 ,p_attribute28 IN VARCHAR2 DEFAULT HR_API.g_varchar2
114 ,p_attribute29 IN VARCHAR2 DEFAULT HR_API.g_varchar2
115 ,p_attribute30 IN VARCHAR2 DEFAULT HR_API.g_varchar2
116 ,p_object_version_number IN OUT nocopy NUMBER
117 ,p_return_status OUT nocopy VARCHAR2
118 );
119 --
120 -- --------------------< reinstate_emp_stat_situation >-----------------------
121 -- Description:
122 -- This procedure is the self-service wrapper procedure to the following
123 -- API: pqh_fr_emp_stat_situation_api.reinstate_emp_stat_situation
124 -- ---------------------------------------------------------------------------
125 PROCEDURE reinstate_emp_stat_situation
126 (p_validate IN NUMBER DEFAULT HR_API.g_false_num
127 ,p_person_id IN NUMBER
128 ,p_emp_stat_situation_id IN NUMBER
129 ,p_reinstate_date IN DATE
130 ,p_comments IN VARCHAR2
131 ,p_new_emp_stat_situation_id OUT nocopy NUMBER
132 ,p_return_status OUT nocopy VARCHAR2
133 );
134 --
135 -- ----------------------< renew_emp_stat_situation >-------------------------
136 -- Description:
137 -- This procedure is the self-service wrapper procedure to the following
138 -- API: pqh_fr_emp_stat_situation_api.renew_emp_stat_situation
139 -- ---------------------------------------------------------------------------
140 PROCEDURE renew_emp_stat_situation
141 (p_validate IN NUMBER DEFAULT HR_API.g_false_num
142 ,p_emp_stat_situation_id IN OUT nocopy NUMBER
143 ,p_renew_stat_situation_id IN NUMBER
144 ,p_renewal_duration IN NUMBER
145 ,p_duration_units IN VARCHAR2
146 ,p_approval_flag IN VARCHAR2
150 );
147 ,p_comments IN VARCHAR2
148 ,p_object_version_number IN OUT nocopy NUMBER
149 ,p_return_status OUT nocopy VARCHAR2
151 --
152 -- ---------------------< delete_emp_stat_situation >-------------------------
153 -- Description:
154 -- This procedure is the self-service wrapper procedure to the following
155 -- API: pqh_fr_emp_stat_situation_api.delete_emp_stat_situation
156 -- ---------------------------------------------------------------------------
157 PROCEDURE delete_emp_stat_situation
158 (p_validate IN NUMBER DEFAULT HR_API.g_false_num
159 ,p_emp_stat_situation_id IN NUMBER
160 ,p_object_version_number IN NUMBER
161 ,p_return_status OUT nocopy VARCHAR2
162 );
163 --
164 --
165 -- ----------------------------< updt_assign >--------------------------------
166 -- Description:
167 -- This procedure is invoked to call main Update Assignments procedure
168 -- ---------------------------------------------------------------------------
169 PROCEDURE updt_assign
170 (p_person_id IN NUMBER
171 ,p_statutory_situation_id IN NUMBER
172 ,p_iand_stat_sit_id IN NUMBER DEFAULT NULL
173 ,p_start_date IN DATE
174 ,p_end_date IN DATE
175 );
176 --
177 --
178 -- --------------------------< is_person_active >-----------------------------
179 -- Description:
180 -- This function returns whether person is in active situation or not.
181 -- ---------------------------------------------------------------------------
182 FUNCTION is_person_active
183 (p_person_id IN NUMBER,
184 p_effective_date IN DATE) RETURN VARCHAR2;
185 --
186 END PQH_FR_EMP_STAT_SIT_UTILITY;