PACKAGE: APPS.HR_SUMMARY_UTIL

Source

1 package hr_summary_util as
2 /* $Header: hrbsutil.pkh 120.0 2005/05/30 23:06:37 appldev noship $ */
3 --
4 item_type_usage_id number;
5 zero_item_value_id number;
6 g_business_group_id number;
7 year varchar2(4);
8 end_of_year varchar2(80);
9 process_run_id number;
10 --
11 OTHER varchar2(1000) := fnd_message.get_string('PER','PER_74885_OTHER');
12 --
13 l_gender_other boolean;
14 l_age_other boolean;
15 l_employee_category_other boolean;
16 l_nationality_other boolean;
17 l_seniority_other boolean;
18 --
19 gender_clause varchar2(2000);
20 age_clause varchar2(2000);
21 emp_cat_clause varchar2(2000);
22 nationality_clause varchar2(2000);
23 seniority_clause varchar2(2000);
24 --
25 store_data boolean;
26 --
27 TYPE prmRecType IS RECORD
28    (name varchar2(240)
29    ,value varchar2(4000));
30 TYPE prmTabType IS TABLE of prmRecType INDEX BY BINARY_INTEGER;
31 --
32 nullprmTab prmTabType;
33 --
34 function create_other_kv(p_business_group_id number
35                         ,p_key_type_id number) return boolean;
36 --
37 function get_lookup_values(p_lookup_type varchar2
38                           ,p_db_column varchar2
39                           ,p_key_type_id number) return varchar2;
40 --
41 function get_alternate_values(p_table_name varchar2
42                              ,p_column varchar2
43                              ,p_db_column varchar2
44                              ,p_key_type_id number) return varchar2;
45 --
46 --
47 function get_band_values(p_table_name varchar2
48                         ,p_low_column varchar2
49                         ,p_high_column varchar2
50                         ,p_db_column varchar2
51                         ,p_key_type_id number) return varchar2;
52 --
53 procedure initialize_run(p_store_data boolean
54                         ,p_business_group_id number
55                         ,p_template_id number
56                         ,p_process_run_name varchar2
57                         ,p_process_type varchar2
58                         ,p_parameters prmTabType);
59 procedure initialize_procedure (p_business_group_id number);
60 procedure load_item_value(p_business_group_id number
61                          ,p_value number);
62 /*
63 procedure load_item_key_value(p_business_group_id number
64                              ,p_key_type_id number
65                              ,p_other_entry IN OUT boolean
66                              ,p_value varchar2);
67 */
68 function get_cagr_values (p_key_type_id in number
69                          ,p_db_column   in varchar2
70                          ,p_table_name  in varchar2
71                          ,p_column_name in varchar2) return varchar2;
72 function get_month (p_key_type_id in number
73                    ,p_db_column   in varchar2) return varchar2;
74 --
75 --
76 --
77 end;