DBA Data[Home] [Help]

APPS.IRC_GET_VACANCY_DEFAULTS dependencies on HR_UTILITY

Line 22: hr_utility.trace('Entering populate_defaults_rec');

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 := '';

Line 93: hr_utility.trace('Exiting populate_defaults_rec');

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: --

Line 98: hr_utility.trace('Error occured in 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;

Line 116: hr_utility.trace('Entering get_BG_defaults with business_group_id :'

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

Line 123: hr_utility.trace('defaults record populated');

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: --

Line 128: hr_utility.trace('p_currency is :' || p_currency || ':');

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 || ':');

Line 132: hr_utility.trace('p_vacancy_name_is_auto is :' || p_vacancy_name_is_auto || ':');

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 || ':');

Line 136: hr_utility.trace('p_budget_measurement_type is :' || p_budget_measurement_type || ':');

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) || ':');

Line 140: hr_utility.trace('p_number_of_openings is :' || to_char(p_number_of_openings) || ':');

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 || ':');

Line 144: hr_utility.trace('p_location_default is :' || p_location_default || ':');

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 || ':');

Line 148: hr_utility.trace('p_organization_default is :' || p_organization_default || ':');

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;

Line 150: hr_utility.trace('Exiting get_BG_defaults');

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)

Line 161: hr_utility.trace('Entering get_currency');

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

Line 171: hr_utility.trace('Exiting get_currency returning :' || l_currency || ':');

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;

Line 181: hr_utility.trace('Entering get_vacancy_name');

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');

Line 185: hr_utility.trace('Exiting get_vacancy_name null found so returning N');

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: --

Line 192: hr_utility.trace('Exiting get_vacancy_name ID found so returning Y');

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: --

Line 197: hr_utility.trace('Exiting get_vacancy_name wiht default value N');

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;

Line 206: hr_utility.trace('Executing get_number_of_openings');

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;

Line 215: hr_utility.trace('Executing get_budget_measurement_type');

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;

Line 224: hr_utility.trace('Executing get_organization_default');

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;

Line 233: hr_utility.trace('Executing get_location_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;