[Home] [Help]
PACKAGE: APPS.BEN_EXTRACT_SEED
Source
1 PACKAGE ben_extract_seed AS
2 /* $Header: benextse.pkh 120.5.12000000.2 2007/02/13 01:17:15 tjesumic noship $ */
3 --
4
5 g_business_group_id per_business_groups.Business_group_id%type ;
6 g_max_errors_allowed number ;
7 g_errors_count number := 0 ;
8 g_Total_file number := 0 ;
9 g_file_count number := 0 ;
10 g_group_record varchar2(600) ;
11 g_group_elmt1 varchar2(600) ;
12 g_group_elmt2 varchar2(600) ;
13 g_override varchar2(1) ;
14
15 TYPE Ext_adv_crit_cmbn IS RECORD
16 (old_crit_val_id number,
17 new_crit_val_id number
18 );
19
20 TYPE tbl_Ext_adv_crit_cmbn IS TABLE OF Ext_adv_crit_cmbn INDEX BY Binary_Integer ;
21
22
23 Procedure load_business_group(p_owner IN VARCHAR2
24 ,p_legislation_code IN VARCHAR2
25 ,p_business_group in VARCHAR2
26 ,p_totalcount in VARCHAR2 default null
27 ,p_allow_override in VARCHAR2 default null
28
29 ) ;
30
31
32
33
34 FUNCTION get_value (p_crit_typ_cd in VARCHAR2
35 ,p_val in VARCHAR2
36 ,p_val_order IN VARCHAR2
37 ,p_bg_group_id in number default null
38 )return varchar2;
39 --
40 FUNCTION decode_value (p_crit_typ_cd in VARCHAR2,
41 p_meaning in VARCHAR2
42 ,p_val_order IN VARCHAR2
43 ,p_parent_meaning IN VARCHAR2
44 )return varchar2;
45 --
46 PROCEDURE load_extract(p_file_name IN VARCHAR2
47 ,p_owner IN VARCHAR2
48 ,p_last_update_date IN VARCHAR2
49 ,p_legislation_code IN VARCHAR2
50 ,p_business_group in VARCHAR2
51 ,p_xml_tag_name in VARCHAR2
52 ,p_ext_group_record in VARCHAR2
53 ,p_ext_group_elmt1 in VARCHAR2
54 ,p_ext_group_elmt2 in VARCHAR2
55 );
56 --
57 PROCEDURE load_record(p_record_name IN VARCHAR2
58 ,p_owner IN VARCHAR2
59 ,p_last_update_date IN VARCHAR2
60 ,p_rcd_type_cd IN VARCHAR2
61 ,p_low_lvl_cd IN VARCHAR2
62 ,p_legislation_code IN VARCHAR2
63 ,p_business_group in VARCHAR2
64 ,p_xml_tag_name in VARCHAR2);
65 --
66 PROCEDURE load_record_in_file(p_file_name IN VARCHAR2
67 ,p_parent_record_name IN VARCHAR2
68 ,p_owner IN VARCHAR2
69 ,p_last_update_date IN VARCHAR2
70 ,p_rqd_flag IN VARCHAR2 DEFAULT 'N'
71 ,p_hide_flag IN VARCHAR2 DEFAULT 'N'
72 ,p_CHG_RCD_UPD_FLAG IN VARCHAR2 DEFAULT 'N'
73 ,p_seq_num IN VARCHAR2 DEFAULT null
74 ,p_sprs_cd IN VARCHAR2 DEFAULT NULL
75 ,p_any_or_all_cd IN VARCHAR2 DEFAULT 'N'
76 ,p_sort1_element IN VARCHAR2 DEFAULT NULL
77 ,p_sort2_element IN VARCHAR2 DEFAULT NULL
78 ,p_sort3_element IN VARCHAR2 DEFAULT NULL
79 ,p_sort4_element IN VARCHAR2 DEFAULT NULL
80 ,p_legislation_code IN VARCHAR2
81 ,p_business_group in VARCHAR2
82 );
83 --
84 PROCEDURE load_ext_data_elmt(p_data_elemt_name IN VARCHAR2
85 ,p_parent_data_element IN VARCHAR2 DEFAULT NULL
86 ,p_field_short_name IN VARCHAR2 DEFAULT NULL
87 ,p_parent_record_name IN VARCHAR2 DEFAULT NULL
88 ,p_owner IN VARCHAR2
89 ,p_last_update_date IN VARCHAR2
90 ,p_ttl_fnctn_cd IN VARCHAR2
91 ,p_ttl_cond_oper_cd IN VARCHAR2
92 ,p_ttl_cond_val IN VARCHAR2
93 ,p_data_elmt_typ_cd IN VARCHAR2
94 ,p_data_elmt_rl IN VARCHAR2
95 ,p_frmt_mask_cd IN VARCHAR2
96 ,p_string_val IN VARCHAR2
97 ,p_dflt_val IN VARCHAR2
98 ,p_max_length_num IN VARCHAR2
99 ,p_just_cd IN VARCHAR2
100 ,p_legislation_code IN VARCHAR2
101 ,p_business_group in VARCHAR2
102 ,p_xml_tag_name in VARCHAR2
103 ,p_defined_balance in VARCHAR2 DEFAULT NULL
104 );
105 --
106 PROCEDURE load_ext_data_elmt_in_rcd(p_data_element_name IN VARCHAR2
107 ,p_record_name IN VARCHAR2
108 ,p_owner IN VARCHAR2
109 ,p_last_update_date IN VARCHAR2
110 ,p_rqd_flag IN VARCHAR2
111 ,p_hide_flag IN VARCHAR2
112 ,p_seq_num IN VARCHAR2
113 ,p_strt_pos IN VARCHAR2
114 ,p_dlmtr_val IN VARCHAR2
115 ,p_sprs_cd IN VARCHAR2
116 ,p_any_or_all_cd IN VARCHAR2
117 ,p_legislation_code IN VARCHAR2
118 ,p_business_group in VARCHAR2
119 );
120 --
121 PROCEDURE load_ext_where_clause(p_data_elmt_name IN VARCHAR2
122 ,p_record_name IN VARCHAR2 default null
123 ,p_file_name IN VARCHAR2 DEFAULT NULL
124 ,p_record_data_elmt_name IN VARCHAR2 DEFAULT NULL
125 ,p_cond_ext_data_elmt_name IN VARCHAR2 DEFAULT NULL
126 ,p_owner IN VARCHAR2
127 ,p_last_update_date IN VARCHAR2
128 ,p_seq_num IN VARCHAR2
129 ,p_oper_cd IN VARCHAR2
130 ,p_val IN VARCHAR2
131 ,p_and_or_cd IN VARCHAR2
132 ,p_legislation_code IN VARCHAR2
133 ,p_business_group IN VARCHAR2
134 );
135
136 --
137 PROCEDURE load_incl_chgs(p_data_elmt_name IN VARCHAR2 DEFAULT NULL
138 ,p_record_name IN VARCHAR2
139 ,p_file_name IN VARCHAR2 DEFAULT NULL
140 ,p_chg_evt_cd IN VARCHAR2
141 ,p_owner IN VARCHAR2
142 ,p_last_update_date IN VARCHAR2
143 ,p_legislation_code IN VARCHAR2
144 ,p_business_group in VARCHAR2
145 ,p_chg_evt_source in VARCHAR2 DEFAULT NULL
146 ) ;
147
148 --
149 PROCEDURE load_profile(p_profile_name IN VARCHAR2
150 ,p_owner IN VARCHAR2
151 ,p_last_update_date IN VARCHAR2
152 ,p_legislation_code IN VARCHAR2
153 ,p_business_group in VARCHAR2
154 ,p_ext_Global_flag in VARCHAR2 default 'N'
155 );
156 --
157 PROCEDURE load_criteria_type(p_profile_name IN VARCHAR2
158 ,p_type_code IN VARCHAR2
159 ,p_owner IN VARCHAR2
160 ,p_last_update_date IN VARCHAR2
161 ,p_crit_typ_cd IN VARCHAR2
162 ,p_excld_flag IN VARCHAR2
163 ,p_legislation_code IN VARCHAR2
164 ,p_business_group in VARCHAR2 );
165 --
166 PROCEDURE load_criteria_val(p_profile_name IN VARCHAR2
167 ,p_type_code IN VARCHAR2
168 ,p_val IN VARCHAR2
169 ,p_owner IN VARCHAR2
170 ,p_last_update_date IN VARCHAR2
171 ,p_val2 IN VARCHAR2
172 ,p_legislation_code IN VARCHAR2
173 ,p_business_group in VARCHAR2
174 ,p_ext_crit_val_id in varchar2 default null
175 ,p_lookup_code1 in varchar2 default null
176 ,p_lookup_code2 in varchar2 default null
177 );
178 --
179 PROCEDURE load_combination(p_profile_name IN VARCHAR2
180 ,p_type_code IN VARCHAR2
181 ,p_val IN VARCHAR2
182 ,p_val_2 IN VARCHAR2
183 ,p_crit_typ_cd IN VARCHAR2
184 ,p_oper_cd IN VARCHAR2
185 ,p_owner IN VARCHAR2
186 ,p_last_update_date IN VARCHAR2
187 ,p_legislation_code IN VARCHAR2
188 ,p_business_group in VARCHAR2
189 ,p_ext_crit_val_id in varchar2 default null
190 ,p_lookup_code1 in varchar2 default null
191 ,p_lookup_code2 in varchar2 default null
192 );
193 --
194 PROCEDURE load_definition(p_definition_name IN VARCHAR2
195 ,p_file_name IN VARCHAR2
196 ,p_profile_name IN VARCHAR2
197 ,p_owner IN VARCHAR2
198 ,p_last_update_date IN VARCHAR2
199 ,p_kickoff_wrt_prc_flag IN VARCHAR2
200 ,p_apnd_rqst_id_flag IN VARCHAR2
201 ,p_prmy_sort_cd IN VARCHAR2
202 ,p_scnd_sort_cd IN VARCHAR2
203 ,p_strt_dt IN VARCHAR2
204 ,p_end_dt IN VARCHAR2
205 ,p_spcl_hndl_flag IN VARCHAR2
206 ,p_upd_cm_sent_dt_flag IN VARCHAR2
207 ,p_use_eff_dt_for_chgs_flag IN VARCHAR2
208 ,p_data_typ_cd IN VARCHAR2
209 ,p_ext_typ_cd IN VARCHAR2
210 ,p_drctry_name IN VARCHAR2
211 ,p_output_name IN VARCHAR2
212 ,p_post_processing_rule IN VARCHAR2
213 ,p_legislation_code IN VARCHAR2
214 ,p_business_group in VARCHAR2
215 ,p_xml_tag_name in VARCHAR2
216 ,p_output_type in VARCHAR2
217 ,p_xdo_template_name in VARCHAR2
218 ,p_ext_Global_flag in VARCHAR2 default 'N'
219 ,p_cm_display_flag in VARCHAR2 default 'N'
220 );
221
222 PROCEDURE load_decode(p_element_name IN VARCHAR2
223 ,p_owner IN VARCHAR2
224 ,p_last_update_date IN VARCHAR2
225 ,p_val IN VARCHAR2
226 ,p_dcd_val IN VARCHAR2
227 ,p_legislation_code IN VARCHAR2
228 ,p_business_group IN VARCHAR2
229 ,p_chg_evt_source in VARCHAR2 default null
230 )
231 ;
232
233
234 function get_lookup_code (p_crit_typ_cd in VARCHAR2
235 ,p_val in VARCHAR2
236 ,p_val_order IN VARCHAR2
237 ,p_bg_group_id IN NUMBER default null
238 )return varchar2
239 ;
240
241
242
243
244 PROCEDURE validate_data(validate IN VARCHAR2 DEFAULT null ) ;
245
246
247 function get_chg_evt_cd (p_CHG_EVT_CD varchar2 ,
248 p_chg_evt_source varchar2,
249 p_business_group_id number
250 ) return varchar2 ;
251
252
253
254 function set_chg_evt_cd (p_CHG_EVT_CD varchar2 ,
255 p_chg_evt_source varchar2,
256 p_business_group_id number
257 ) return varchar2 ;
258
259 END ben_extract_seed;