1 package ben_pump_get as
2 /* $Header: bedpget.pkh 120.0 2006/02/17 13:24:22 ikasired noship $ */
3 /*
4 Notes:
5 The functions declared in this header are designed to be used by
6 the Data Pump engine to resolve id values that have to be passed
7 to the API modules. However, most of these functions could also
8 be used by any program that might want to do something similar.
9
10 The exceptions to are likely to be the functions where a user
11 key value is one of the parameters.
12 */
13
14 /*
15 * The following functions have been defined in this
16 * header file.
17
18 */
19 ------------------------------ get_acty_base_rt_id ---------------------------
20 /*
21 NAME
22 get_acty_base_rt_id
23 DESCRIPTION
24 Returns an acty base rate ID.
25 NOTES
26 This function returns an acty_base_rt_id1 and is designed for use with the Data Pump.
27 */
28 function get_acty_base_rt_id1
29 ( p_data_pump_always_call in varchar2,
30 p_business_group_id in number,
31 p_acty_base_rate_name1 in varchar2 default null,
32 p_acty_base_rate_num1 in number default null,
33 p_effective_date in date
34 ) return number;
35 pragma restrict_references (get_acty_base_rt_id1 , WNDS);
36 --
37 ------------------------------ get_acty_base_rt_id2 ---------------------------
38 /*
39 NAME
40 get_acty_base_rt_id2
41 DESCRIPTION
42 Returns an acty base rate ID.
43 NOTES
44 This function returns an acty_base_rt_id2 and is designed for use with the Data Pump.
45 */
46 function get_acty_base_rt_id2
47 ( p_data_pump_always_call in varchar2,
48 p_business_group_id in number,
49 p_acty_base_rate_name2 in varchar2 default null,
50 p_acty_base_rate_num2 in number default null,
51 p_effective_date in date
52 ) return number;
53 pragma restrict_references (get_acty_base_rt_id2 , WNDS);
54 --
55 ------------------------------ get_acty_base_rt_id3 ---------------------------
56 /*
57 NAME
58 get_acty_base_rt_id3
59 DESCRIPTION
60 Returns an acty base rate ID.
61 NOTES
62 This function returns an acty_base_rt_id3 and is designed for use with the Data Pump.
63 */
64 function get_acty_base_rt_id3
65 ( p_data_pump_always_call in varchar2,
66 p_business_group_id in number,
67 p_acty_base_rate_name3 in varchar2 default null,
68 p_acty_base_rate_num3 in number default null,
69 p_effective_date in date
70 ) return number;
71 pragma restrict_references (get_acty_base_rt_id3 , WNDS);
72 --
73 ------------------------------ get_acty_base_rt_id4 ---------------------------
74 /*
75 NAME
76 get_acty_base_rt_id4
77 DESCRIPTION
78 Returns an acty base rate ID.
79 NOTES
80 This function returns an acty_base_rt_id and is designed for use with the Data Pump.
81 */
82 function get_acty_base_rt_id4
83 ( p_data_pump_always_call in varchar2,
84 p_business_group_id in number,
85 p_acty_base_rate_name4 in varchar2 default null,
86 p_acty_base_rate_num4 in number default null,
87 p_effective_date in date
88 ) return number;
89 pragma restrict_references (get_acty_base_rt_id4 , WNDS);
90 --
91 ------------------------------ get_pgm_id ---------------------------
92 /*
93 NAME
94 get_pgm_id
95 DESCRIPTION
96 Returns a Program ID.
97 NOTES
98 This function returns a pgm_id and is designed for use with the Data Pump.
99 */
100 function get_pgm_id
101 ( p_data_pump_always_call in varchar2,
102 p_business_group_id in number,
103 p_program in varchar2 default null,
104 p_program_num in number default null,
105 p_effective_date in date
106 ) return number;
107 pragma restrict_references (get_pgm_id , WNDS);
108 --
109
110 ------------------------------ get_pl_id ---------------------------
111 /*
112 NAME
113 get_pl_id
114 DESCRIPTION
115 Returns a Plan ID.
116 NOTES
117 This function returns a pl_id and is designed for use with the Data Pump.
118 */
119 function get_pl_id
120 ( p_data_pump_always_call in varchar2,
121 p_business_group_id in number,
122 p_plan in varchar2 default null,
123 p_plan_num in number default null,
124 p_effective_date in date
125 ) return number;
126 pragma restrict_references (get_pl_id , WNDS);
127 --
128
129 ------------------------------ get_ended_pl_id ---------------------------
130 /*
131 NAME
132 get_ended_pl_id
133 DESCRIPTION
134 Returns a ended_Plan ID.
135 NOTES
136 This function returns a ended_pl_id and is designed for use with the Data Pump.
137 */
138 function get_ended_pl_id
139 ( p_data_pump_always_call in varchar2,
140 p_business_group_id in number,
141 p_ended_plan in varchar2 default null,
142 p_ended_plan_num in number default null,
143 p_effective_date in date
144 ) return number;
145 pragma restrict_references (get_ended_pl_id , WNDS);
146 --
147 ------------------------------ get_opt_id ---------------------------
148 /*
149 NAME
150 get_opt_id
151 DESCRIPTION
152 Returns an option (definition) ID.
153 NOTES
154 This function returns a opt_id and is designed for use with the Data Pump.
155 */
156 function get_opt_id
157 ( p_data_pump_always_call in varchar2,
158 p_business_group_id in number,
159 p_option in varchar2 default null,
160 p_option_num in number default null,
161 p_effective_date in date
162 ) return number;
163 pragma restrict_references (get_opt_id, WNDS);
164 --
165 ------------------------------ get_ended_opt_id ---------------------------
166 /*
167 NAME
168 get_ended_opt_id
169 DESCRIPTION
170 Returns an ended_option (definition) ID.
171 NOTES
172 This function returns a ended_opt_id and is designed for use with the Data Pump.
173 */
174 function get_ended_opt_id
175 ( p_data_pump_always_call in varchar2,
176 p_business_group_id in number,
177 p_ended_option in varchar2 default null,
178 p_ended_option_num in number default null,
179 p_effective_date in date
180 ) return number;
181 pragma restrict_references (get_ended_opt_id, WNDS);
182 --
183 ------------------------------ get_pen_person_id ---------------------------
184 /*
185 NAME
186 get_pen_person_id
187 DESCRIPTION
188 Returns an person_id
189 NOTES
190 This function returns a eperson_id and is designed for use with the Data Pump.
191 */
192 --
193 function get_pen_person_id
194 ( p_data_pump_always_call in varchar2,
195 p_business_group_id in number,
196 p_employee_number in varchar2 default null,
197 p_national_identifier in varchar2 default null,
198 p_full_name in varchar2 default null,
199 p_date_of_birth in date default null,
200 p_person_num in number default null,
201 p_effective_date in date
202 ) return number;
203 --
204 function get_con_person_id
205 ( p_data_pump_always_call in varchar2,
206 p_business_group_id in number,
207 p_con_employee_number in varchar2 default null,
208 p_con_national_identifier in varchar2 default null,
209 p_con_full_name in varchar2 default null,
210 p_con_date_of_birth in date default null,
211 p_con_person_num in number default null,
212 p_effective_date in date
213 ) return number;
214 --
215 pragma restrict_references (get_pen_person_id , WNDS);
216 --
217 end ben_pump_get;