[Home] [Help]
PACKAGE BODY: APPS.IRC_GET_VACANCY_DEFAULTS
Source
1 Package Body IRC_GET_VACANCY_DEFAULTS as
2 /* $Header: irvacdft.pkb 120.2 2005/08/09 04:10:10 cnholmes noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | |
6 -- | IRC_GET_VACANCY_DEFAULTS package gives us access to the configurable |
7 -- | defaults. We can then set the currentRow attributes to these values: |
8 -- | |
9 -- ----------------------------------------------------------------------------
10 --
11 g_package varchar2(33) := ' IRC_GET_VACANCY_DEFAULTS.'; -- Global package name
12 g_defaults g_rec_type;
13 --
14 --
15 Procedure populate_defaults_rec
16 (
17 p_organization_id in varchar2
18 ,p_level in varchar2
19 ) is
20 BEGIN
21 --
22 hr_utility.trace('Entering populate_defaults_rec');
23 --
24 g_defaults.ORG_INFORMATION1 := '';
25 g_defaults.ORG_INFORMATION2 := '';
26 g_defaults.ORG_INFORMATION3 := '';
27 g_defaults.ORG_INFORMATION4 := '';
28 g_defaults.ORG_INFORMATION5 := '';
29 g_defaults.ORG_INFORMATION6 := '';
30 g_defaults.ORG_INFORMATION7 := '';
31 g_defaults.ORG_INFORMATION8 := '';
32 g_defaults.ORG_INFORMATION9 := '';
33 g_defaults.ORG_INFORMATION10 := '';
34 g_defaults.ORG_INFORMATION11 := '';
35 g_defaults.ORG_INFORMATION12 := '';
36 g_defaults.ORG_INFORMATION13 := '';
37 g_defaults.ORG_INFORMATION14 := '';
38 g_defaults.ORG_INFORMATION15 := '';
39 g_defaults.ORG_INFORMATION16 := '';
40 g_defaults.ORG_INFORMATION17 := '';
41 g_defaults.ORG_INFORMATION18 := '';
42 g_defaults.ORG_INFORMATION19 := '';
43 g_defaults.ORG_INFORMATION20 := '';
44 --
45 SELECT
46 ORG_INFORMATION1
47 ,ORG_INFORMATION2
48 ,ORG_INFORMATION3
49 ,ORG_INFORMATION4
50 ,ORG_INFORMATION5
51 ,ORG_INFORMATION6
52 ,ORG_INFORMATION7
53 ,ORG_INFORMATION8
54 ,ORG_INFORMATION9
55 ,ORG_INFORMATION10
56 ,ORG_INFORMATION11
57 ,ORG_INFORMATION12
58 ,ORG_INFORMATION13
59 ,ORG_INFORMATION14
60 ,ORG_INFORMATION15
61 ,ORG_INFORMATION16
62 ,ORG_INFORMATION17
63 ,ORG_INFORMATION18
64 ,ORG_INFORMATION19
65 ,ORG_INFORMATION20
66 INTO
67 g_defaults.ORG_INFORMATION1
68 ,g_defaults.ORG_INFORMATION2
69 ,g_defaults.ORG_INFORMATION3
70 ,g_defaults.ORG_INFORMATION4
71 ,g_defaults.ORG_INFORMATION5
72 ,g_defaults.ORG_INFORMATION6
73 ,g_defaults.ORG_INFORMATION7
74 ,g_defaults.ORG_INFORMATION8
75 ,g_defaults.ORG_INFORMATION9
76 ,g_defaults.ORG_INFORMATION10
77 ,g_defaults.ORG_INFORMATION11
78 ,g_defaults.ORG_INFORMATION12
79 ,g_defaults.ORG_INFORMATION13
80 ,g_defaults.ORG_INFORMATION14
81 ,g_defaults.ORG_INFORMATION15
82 ,g_defaults.ORG_INFORMATION16
83 ,g_defaults.ORG_INFORMATION17
84 ,g_defaults.ORG_INFORMATION18
85 ,g_defaults.ORG_INFORMATION19
86 ,g_defaults.ORG_INFORMATION20
87 FROM HR_ORGANIZATION_INFORMATION
88 WHERE
89 ORG_INFORMATION_CONTEXT = p_level
90 AND
91 ORGANIZATION_ID = p_organization_id;
92 --
93 hr_utility.trace('Exiting populate_defaults_rec');
94 --
95 EXCEPTION
96 WHEN OTHERS THEN
97 --
98 hr_utility.trace('Error occured in populate_defaults_rec');
99 --
100 return;
101 --
102 end populate_defaults_rec;
103 --
104 Procedure get_BG_defaults
105 ( p_business_group_id in number
106 ,p_currency out nocopy varchar2
107 ,p_vacancy_name_is_auto out nocopy varchar2
108 ,p_budget_measurement_type out nocopy varchar2
109 ,p_number_of_openings out nocopy number
110 ,p_location_default out nocopy varchar2
111 ,p_organization_default out nocopy varchar2
112 ) is
113 --
114 begin
115 --
116 hr_utility.trace('Entering get_BG_defaults with business_group_id :'
117 || to_char(p_business_group_id) || ':');
118 --
119 populate_defaults_rec
120 (p_organization_id => p_business_group_id
121 ,p_level => 'BG Recruitment');
122 --
123 hr_utility.trace('defaults record populated');
124 --
125 p_currency :=
126 get_currency(p_organization_id => p_business_group_id);
127 --
128 hr_utility.trace('p_currency is :' || p_currency || ':');
129 --
130 p_vacancy_name_is_auto := get_vacancy_name_is_auto;
131 --
132 hr_utility.trace('p_vacancy_name_is_auto is :' || p_vacancy_name_is_auto || ':');
133 --
134 p_budget_measurement_type := get_budget_measurement_type;
135 --
136 hr_utility.trace('p_budget_measurement_type is :' || p_budget_measurement_type || ':');
137 --
138 p_number_of_openings := get_number_of_openings;
139 --
140 hr_utility.trace('p_number_of_openings is :' || to_char(p_number_of_openings) || ':');
141 --
142 p_location_default := get_location_default;
143 --
144 hr_utility.trace('p_location_default is :' || p_location_default || ':');
145 --
146 p_organization_default := get_organization_default;
147 --
148 hr_utility.trace('p_organization_default is :' || p_organization_default || ':');
149 --
150 hr_utility.trace('Exiting get_BG_defaults');
151 --
152 end get_BG_defaults;
153 --
154 Function get_currency (p_organization_id in varchar)
155 return varchar2 is
156 --
157 l_currency varchar2(250);
158 --
159 begin
160 --
161 hr_utility.trace('Entering get_currency');
162 --
163 SELECT ORG_INFORMATION10
164 INTO l_currency
165 FROM HR_ORGANIZATION_INFORMATION
166 WHERE
167 ORG_INFORMATION_CONTEXT = 'Business Group Information'
168 AND
169 ORGANIZATION_ID = p_organization_id;
170 --
171 hr_utility.trace('Exiting get_currency returning :' || l_currency || ':');
172 --
173 return l_currency;
174 --
175 end get_currency;
176 --
177 Function get_vacancy_name_is_auto return varchar2 is
178 --
179 begin
180 --
181 hr_utility.trace('Entering get_vacancy_name');
182 --
183 if (g_defaults.ORG_INFORMATION1 is null) then
184 --
185 hr_utility.trace('Exiting get_vacancy_name null found so returning N');
186 --
187 return 'N';
188 end if;
189 --
190 if (g_defaults.ORG_INFORMATION1 = 'ID') then
191 --
192 hr_utility.trace('Exiting get_vacancy_name ID found so returning Y');
193 --
194 return 'Y';
195 end if;
196 --
197 hr_utility.trace('Exiting get_vacancy_name wiht default value N');
198 --
199 return 'N';
200 --
201 end get_vacancy_name_is_auto;
202 --
203 Function get_number_of_openings return number is
204 begin
205 --
206 hr_utility.trace('Executing get_number_of_openings');
207 --
208 return nvl(fnd_number.canonical_to_number(g_defaults.ORG_INFORMATION3), 1);
209 --
210 end get_number_of_openings;
211 --
212 Function get_budget_measurement_type return varchar2 is
213 begin
214 --
215 hr_utility.trace('Executing get_budget_measurement_type');
216 --
217 return nvl(g_defaults.ORG_INFORMATION6, 'FTE');
218 --
219 end get_budget_measurement_type;
220 --
221 Function get_organization_default return varchar2 is
222 begin
223 --
224 hr_utility.trace('Executing get_organization_default');
225 --
226 return nvl(g_defaults.ORG_INFORMATION4, 'MANAGER');
227 --
228 end get_organization_default;
229 --
230 Function get_location_default return varchar2 is
231 begin
232 --
233 hr_utility.trace('Executing get_location_default');
234 --
235 return nvl(g_defaults.ORG_INFORMATION5, 'MANAGER');
236 --
237 end get_location_default;
238 --
239 end IRC_GET_VACANCY_DEFAULTS;