[Home] [Help]
8: function create_other_kv(p_business_group_id number
9: ,p_key_type_id number) return boolean is
10: begin
11: --
12: hr_utility.set_location('Entering: hr_summary_util.create_other_kv', 10);
13: --
14: hr_summary_api.create_key_value(p_key_value_id => l_key_value_id
15: ,p_business_group_id => p_business_group_id
16: ,p_object_version_number => l_object_version_number
17: ,p_key_type_id => p_key_type_id
18: ,p_item_value_id => zero_item_value_id
19: ,p_name => OTHER);
20: --
21: hr_utility.set_location('Leaving: hr_summary_util.create_other_kv', 20);
22: --
23: return TRUE;
24: end;
25: --
36: l_clause varchar2(32000);
37: --
38: begin
39: --
40: hr_utility.set_location('Entering: hr_summary_util.get_lookup_values', 10);
41: --
42: i := 0;
43: for v in c_lookup(p_lookup_type) loop
44: if i > 0 then
73: l_clause := l_clause ||',''GSP_OTHER'')';
74: end if;
75: ---------------------------------------------------------------
76: --
77: hr_utility.set_location('Leaving: hr_summary_util.get_lookup_values', 20);
78: --
79: return l_clause;
80: end get_lookup_values;
81: --
107: l_clause varchar2(32000);
108: --
109: begin
110: --
111: hr_utility.set_location('Entering: hr_summary_util.get_alternate_values', 10);
112: --
113: i := 0;
114: for v in c_user_table(p_table_name
115: ,p_column) loop
145: l_clause := l_clause ||','||''''||OTHER||''''||')';
146: end if;
147: ---------------------------------------------------------------
148: --
149: hr_utility.set_location('Leaving: hr_summary_util.get_alternate_values', 20);
150: --
151: return l_clause;
152: end;
153: --
192: l_clause varchar2(32000);
193: --
194: begin
195: --
196: hr_utility.set_location('Entering: hr_summary_util.get_band_values', 10);
197: --
198: select legislation_code
199: into l_legislation_code
200: from per_business_groups
233: else
234: l_clause := l_clause || ','''||OTHER||''')';
235: end if;
236: --
237: hr_utility.set_location('Leaving: hr_summary_util.get_band_values', 20);
238: --
239: return l_clause;
240: End;
241: --
249: l_process_run_id number;
250: l_parameter_id number;
251: begin
252: --
253: hr_utility.set_location('Entering: hr_summary_util.initialize_run', 10);
254: --
255: if p_store_data then
256: hr_summary_api.create_process_run (p_process_run_id => l_process_run_id
257: ,p_business_group_id => p_business_group_id
275: end if;
276: --
277: g_business_group_id := p_business_group_id;
278: --
279: hr_utility.set_location('Leaving: hr_summary_util.initialize_run', 20);
280: --
281: end;
282: --
283: procedure initialize_procedure (p_business_group_id number) is
282: --
283: procedure initialize_procedure (p_business_group_id number) is
284: begin
285: --
286: hr_utility.set_location('Entering: hr_summary_util.initialize_procedure', 10);
287: --
288: if store_data then
289: hr_summary_api.create_item_value(p_item_value_id => zero_item_value_id
290: ,p_business_group_id => p_business_group_id
297: ,p_datevalue => null);
298:
299: end if;
300: --
301: hr_utility.set_location('Leaving: hr_summary_util.initialize_procedure', 20);
302: --
303: end;
304: --
305: procedure load_item_value(p_business_group_id number
305: procedure load_item_value(p_business_group_id number
306: ,p_value number) is
307: begin
308: --
309: hr_utility.set_location('Entering: hr_summary_util.load_item_value', 10);
310: --
311: hr_summary_api.create_item_value(p_item_value_id => l_item_value_id
312: ,p_business_group_id => p_business_group_id
313: ,p_object_version_number => l_object_version_number
317: ,p_numvalue1 => p_value
318: ,p_numvalue2 => null
319: ,p_datevalue => null);
320: --
321: hr_utility.set_location('Leaving: hr_summary_util.load_item_value', 20);
322: --
323: --dbms_output.put_line(l_item_value_id ||' '||item_type_usage_id||' '||p_value);
324: end load_item_value;
325: --
378: ignore integer;
379: --
380: begin
381: --
382: hr_utility.set_location('Entering: hr_summary_util.get_cagr_values', 10);
383: --
384: for l_rec in csr_get_info loop
385: l_seg_string := REPLACE(l_rec.segment_value,'SEGMENT','cagr_def.SEGMENT');
386: l_seg_string := REPLACE(l_seg_string,',','||'' ''||');
432: else
433: l_clause := l_clause ||','||''''||OTHER||''''||')';
434: end if;
435: --
436: hr_utility.set_location('Leaving: hr_summary_util.get_cagr_values', 20);
437: --
438: return (l_clause);
439: --
440: end get_cagr_values;
449: l_key_value hr_summary_key_value.name%type;
450: --
451: begin
452: --
453: hr_utility.set_location('Entering: hr_summary_util.get_month', 10);
454: --
455: l_month := 'to_char(to_date('||''''||'P_YEAR'||p_db_column||'01'||''''||',''YYYYMMDD''),''MON'')';
456: --
457: for i in 1..12 loop
475: end if;
476: end loop;
477: dbms_sql.close_cursor(source_cursor);
478: --
479: hr_utility.set_location('Leaving: hr_summary_util.get_month', 20);
480: --
481: return l_month;
482: --
483: end get_month;