1 PACKAGE pay_element_data_pump AUTHID CURRENT_USER AS
2 /* $Header: pyeledpm.pkh 115.2 2003/04/03 06:49:59 sdhole noship $ */
3
4 Function user_key_to_id(p_user_key_value in varchar2)
5 return number;
6 --
7 Function get_balancing_keyflex_id
8 (p_balancing_keyflex_user_key in varchar2
9 )
10 return number;
11 --
12 Function get_element_set_id
13 (p_business_group_id number
14 ,p_element_set_name varchar2
15 )
16 return number;
17 --
18 Function get_element_link_ovn
19 (p_element_link_user_key in varchar2
20 ,p_effective_date in date
21 )
22 return number;
23 --
24 Function get_link_input_value_id
25 (p_element_link_user_key in varchar2
26 ,p_input_value_name in varchar
27 ,p_element_name in varchar2
28 ,p_business_group_id in number
29 ,p_language_code in varchar2
30 ,p_effective_date in date
31 )
32 return number;
33 --
34 Function get_link_input_value_ovn
35 (p_element_link_user_key in varchar2
36 ,p_input_value_name in varchar
37 ,p_element_name in varchar2
38 ,p_business_group_id in number
39 ,p_language_code in varchar2
40 ,p_effective_date in date
41 )
42 return number;
43 --
44 Function get_classification_id
45 ( p_classification_name varchar2,
46 p_business_group_id number
47 ) RETURN NUMBER ;
48 --
49 Function get_formula_id( p_formula_Name in varchar2,
50 p_business_group_id in number,
51 p_effective_date in date
52 ) RETURN NUMBER ;
53 --
54 Function get_benefit_classification_id
55 ( p_benefit_classification_name in varchar2,
56 p_business_group_id in number
57 ) RETURN NUMBER ;
58 --
59 Function get_iterative_formula_id
60 ( p_iterative_formula_name in varchar2,
61 p_business_group_id in number ,
62 p_effective_date in date
63 ) RETURN NUMBER ;
64 --
65 Function get_retro_summ_ele_id
66 ( p_retro_summ_element_name in varchar2,
67 p_business_group_id in number ,
68 p_effective_date in date
69 ) RETURN NUMBER ;
70 --
71 Function get_proration_group_id
72 ( p_event_group_name in varchar2,
73 p_business_group_id in number
74 ) RETURN NUMBER ;
75 --
76 Function get_proration_formula_id
77 ( p_proration_formula_Name in varchar2,
78 p_business_group_id in number,
79 p_effective_date in date
80 ) RETURN NUMBER ;
81 --
82 Function get_recalc_event_group_id
83 ( p_recalc_event_group_name in varchar2,
84 p_business_group_id in number
85 ) RETURN NUMBER ;
86 --
87 Function get_element_type_ovn
88 ( p_element_type_user_key in varchar2,
89 p_effective_date in date
90 ) return number ;
91 --
92 Function get_input_value_ovn ( p_element_type_user_key in varchar2,
93 p_existing_input_name in varchar2,
94 p_business_group_id in number,
95 p_effective_date in date,
96 p_language_code in varchar2
97 ) return number ;
98 --
99 Function get_element_type_id
100 ( p_element_type_user_key in varchar2
101 ) return number ;
102 --
103 Function get_input_value_formula_id
104 ( p_input_formula_name in varchar2,
105 p_business_group_id in number,
106 p_effective_date in date
107 ) return number ;
108 --
109 Function get_input_value_id (p_element_type_user_key in varchar2,
110 p_existing_input_name in varchar2,
111 p_business_group_id in number,
112 p_effective_date in date,
113 p_language_code in varchar2
114 ) return number;
115 --
116 END pay_element_data_pump ;