1 package pay_kr_report_pkg as
2 /* $Header: pykrrept.pkh 120.1 2005/07/28 23:34:40 mmark noship $ */
3 g_pre_get_balance_value_perf varchar2(1) := 'N';
4 g_pre_get_dbitem_value_perf varchar2(1) := 'N';
5 --------------------------------------------------------------------------------
6 function legislation_code(p_business_group_id in number) return varchar2;
7 --------------------------------------------------------------------------------
8 procedure pre_get_balance_value(p_business_group_id in number);
9 --------------------------------------------------------------------------------
10 procedure pre_get_dbitem_value(p_business_group_id in number);
11 --------------------------------------------------------------------------------
12 function get_defined_balance_id(p_balance_name in varchar2,
13 p_dimension_name in varchar2,
14 p_business_group_id in number) return number;
15 --------------------------------------------------------------------------------
16 function get_xbal_user_entity_id(p_defined_balance_id in number,
17 p_business_group_id in number) return number;
18 --------------------------------------------------------------------------------
19 function get_user_entity_id(p_user_name in varchar2,
20 p_business_group_id in number) return number;
21 --------------------------------------------------------------------------------
22 function get_xdbitem_user_entity_id(p_user_entity_id in number,
23 p_business_group_id in number) return number;
24 --------------------------------------------------------------------------------
25 function get_latest_assact(p_assignment_id in number,
26 p_business_group_id in number,
27 p_effective_date_from in date,
28 p_effective_date_to in date,
29 p_type in varchar2) return number;
30 --------------------------------------------------------------------------------
31 function get_balance_value_asg_run(p_assignment_action_id in number,
32 p_balance_type_id in number) return number;
33 --------------------------------------------------------------------------------
34 function get_archive_items(p_assignment_action_id in number,
35 p_user_entity_id in number) return varchar2;
36 --------------------------------------------------------------------------------
37 function get_balance_value(p_assignment_action_id in number,
38 p_defined_balance_id in number) return varchar2;
39 --------------------------------------------------------------------------------
40 function get_balance_value(p_assignment_action_id in number,
41 p_balance_name in varchar2,
42 p_dimension_name in varchar2) return varchar2;
43 --------------------------------------------------------------------------------
44 function get_dbitem_value(p_assignment_action_id in number,
45 p_user_entity_id in number) return varchar2;
46 --------------------------------------------------------------------------------
47 function get_dbitem_value(p_assignment_action_id in number,
48 p_user_name in varchar2) return varchar2;
49 --------------------------------------------------------------------------------
50 function get_result_value_date(p_assignment_action_id in number,
51 p_business_group_id in number,
52 p_element_type_name in varchar2,
53 p_input_value_name in varchar2) return date;
54 --------------------------------------------------------------------------------
55 function get_result_value_date(p_assignment_action_id in number,
56 p_business_group_id in number,
57 p_element_type_id in number,
58 p_input_value_id in number) return date;
59 --------------------------------------------------------------------------------
60 function get_result_value_number(p_assignment_action_id in number,
61 p_business_group_id in number,
62 p_element_type_name in varchar2,
63 p_input_value_name in varchar2) return number;
64 --------------------------------------------------------------------------------
65 function get_result_value_number(p_assignment_action_id in number,
66 p_business_group_id in number,
67 p_element_type_id in number,
68 p_input_value_id in number) return number;
69 --------------------------------------------------------------------------------
70 function get_result_value_char(p_assignment_action_id in number,
71 p_business_group_id in number,
72 p_element_type_name in varchar2,
73 p_input_value_name in varchar2) return varchar2;
74 --------------------------------------------------------------------------------
75 function get_result_value_char(p_assignment_action_id in number,
76 p_business_group_id in number,
77 p_element_type_id in number,
78 p_input_value_id in number) return varchar2;
79 --------------------------------------------------------------------------------
80 function get_result_value(p_run_result_id in pay_run_results.run_result_id%type,
81 p_input_value_id in pay_input_values_f.input_value_id%type) return varchar2 ;
82 --------------------------------------------------------------------------------
83 end pay_kr_report_pkg;