[Home] [Help]
PACKAGE: APPS.BEN_EXTRACT
Source
1 Package ben_extract as
2 /* $Header: benxtrct.pkh 120.5.12010000.2 2008/08/05 15:01:41 ubhat ship $ */
3 --
4 -- replace current global varchar2 array in BEN_EXT_PERSON
5 -- ----------------------------------------------------------------------------
6 -- |---------------------------< user defined types >-------------------------|
7 -- ----------------------------------------------------------------------------
8 --
9 TYPE gtt_ext_rcd_rqd IS RECORD (
10 low_lvl_cd ben_ext_rcd.low_lvl_cd%TYPE,
11 rcd_found boolean
12 );
13
14 TYPE rcd_rqd_table IS TABLE OF gtt_ext_rcd_rqd INDEX BY BINARY_INTEGER;
15
16 TYPE gtt_ext_rcd_typ_c IS RECORD (
17 ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE,
18 sort1 ben_ext_rcd_in_file.sort1_data_elmt_in_rcd_id%TYPE,
19 sort2 ben_ext_rcd_in_file.sort2_data_elmt_in_rcd_id%TYPE,
20 sort3 ben_ext_rcd_in_file.sort3_data_elmt_in_rcd_id%TYPE,
21 sort4 ben_ext_rcd_in_file.sort4_data_elmt_in_rcd_id%TYPE,
22 ext_rcd_in_file_id ben_ext_rcd_in_file.ext_rcd_in_file_id%TYPE,
23 seq_num ben_ext_rcd_in_file.seq_num%TYPE,
24 sprs_cd ben_ext_rcd_in_file.sprs_cd%TYPE,
25 any_or_all_cd ben_ext_rcd_in_file.any_or_all_cd%TYPE,
26 rcd_type_cd ben_ext_rcd.rcd_type_cd%TYPE,
27 low_lvl_cd ben_ext_rcd.low_lvl_cd%TYPE
28 );
29
30 TYPE rcd_typ_table IS TABLE OF gtt_ext_rcd_typ_c INDEX BY BINARY_INTEGER;
31
32
33 TYPE gtt_ext_rcd_rqd_seq IS RECORD (
34 low_lvl_cd ben_ext_rcd.low_lvl_cd%TYPE,
35 seq_num ben_ext_rcd_in_file.seq_num%TYPE,
36 rcd_found boolean
37 );
38
39 TYPE rcd_rqd_table_seq IS TABLE OF gtt_ext_rcd_rqd_seq INDEX BY BINARY_INTEGER;
40
41
42 --
43 -- ----------------------------------------------------------------------------
44 -- |------------------------< package global variables >----------------------|
45 -- ----------------------------------------------------------------------------
46 --
47 -- extract
48 -- =============
49 gtt_rcd_rqd_vals rcd_rqd_table;
50 gtt_rcd_typ_vals rcd_typ_table;
51 gtt_rcd_rqd_vals_seq rcd_rqd_table_seq;
52
53 g_business_group_name per_business_groups.name%TYPE;
54 g_proc_business_group_name per_business_groups.name%TYPE;
55 g_proc_business_group_id per_business_groups.business_group_id%TYPE;
56 g_ext_strt_dt date;
57 g_ext_end_dt date;
58 g_effective_date date;
59 g_run_date date;
60 g_request_id number(15);
61 g_ext_rslt_id number(15);
62 g_ext_dfn_id number(15);
63 g_subhead_dfn varchar2(1); -- subheader
64 --
65 g_per_lvl varchar2(1);
66 g_enrt_lvl varchar2(1);
67 g_prem_lvl varchar2(1);
68 g_dpnt_lvl varchar2(1);
69 g_payroll_lvl varchar2(1);
70 g_runrslt_lvl varchar2(1);
71 g_elig_lvl varchar2(1);
72 g_flex_lvl varchar2(1);
73 g_bnf_lvl varchar2(1);
74 g_actn_lvl varchar2(1);
75 g_contact_lvl varchar2(1);
76 g_eligdpnt_lvl varchar2(1);
77 --cwb
78 g_cwb_bdgt_lvl varchar2(1);
79 g_cwb_awrd_lvl varchar2(1);
80 -- for sub header
81 g_org_lvl varchar2(1);
82 g_pos_lvl varchar2(1);
83 g_job_lvl varchar2(1);
84 g_loc_lvl varchar2(1);
85 g_pay_lvl varchar2(1);
86 g_grd_lvl varchar2(1);
87
88
89 G_OTL_SUMM_LVL VARCHAR2(1);
90 G_OTL_DETL_LVL VARCHAR2(1);
91
92 g_addr_csr varchar2(1);
93 g_asg_csr varchar2(1);
94 g_phn_csr varchar2(1);
95 g_rt_csr varchar2(1);
96 g_ler_csr varchar2(1);
97 g_bgr_csr varchar2(1);
98 g_abs_csr varchar2(1);
99 g_pprem_csr varchar2(1);
100 g_eprem_csr varchar2(1);
101 g_flxcr_csr varchar2(1);
102 g_eler_csr varchar2(1);
103 g_pler_csr varchar2(1);
104 g_ma_csr varchar2(1);
105 g_bp_csr varchar2(1);
106 g_ba_csr varchar2(1);
107 g_chcrt_csr varchar2(1);
108 g_chc_csr varchar2(1);
109 g_cma_csr varchar2(1);
110 g_dp_csr varchar2(1);
111 g_da_csr varchar2(1);
112 g_dpcp_csr varchar2(1);
113 g_bg_csr varchar2(1);
114 g_bb1_csr varchar2(1);
115 g_bb2_csr varchar2(1);
116 g_bb3_csr varchar2(1);
117 g_bb4_csr varchar2(1);
118 g_bb5_csr varchar2(1);
119 g_ppcp_csr varchar2(1);
120 g_pgn_csr varchar2(1);
121 g_ergrp_csr varchar2(1);
122 g_prgrp_csr varchar2(1);
123 g_asa_csr varchar2(1);
124 g_eplyr_csr varchar2(1);
125 g_pplyr_csr varchar2(1);
126 g_pmpr_csr varchar2(1);
127 g_pmtpr_csr varchar2(1);
128 g_intrm_csr varchar2(1);
129 g_cbra_csr varchar2(1);
130 g_int_csr varchar2(1);
131 g_coa_csr varchar2(1);
132 g_cop_csr varchar2(1);
133 g_coed_csr varchar2(1);
134 g_cocd_csr varchar2(1);
135 g_cob_csr varchar2(1);
136 g_cosl_csr varchar2(1);
137 g_coel_csr varchar2(1);
138 g_eda_csr varchar2(1);
139 g_edp_csr varchar2(1);
140 g_pos_csr varchar2(1);
141 g_sup_csr varchar2(1); /* Supervisor information */
142 g_bsl_csr varchar2(1); /* Basic salary calcualtions */
143 g_shl_csr varchar2(1); /* School Information calcualtions */
144 g_cbradm_csr varchar2(1); /* cobra administration */
145 g_cwbdg_csr varchar2(1); /* cwb budget/group */
146 g_cwbawr_csr varchar2(1); /* cwb award/rat */
147
148 g_max_err_num_exception exception;
149
150 -- totals
151 -- =================
152 g_rcd_num number(9);
153 g_error_num number(9);
154 g_per_num number(9);
155 g_trans_num number(9);
156 --
157 g_error varchar2(1);
158 g_spcl_hndl_flag varchar2(30);
159
160 --- person and benefit overide date globals
161 g_pasor_dt_cd ben_ext_crit_val.val_1%type ;
162 g_bdtor_dt_cd ben_ext_crit_val.val_1%type ;
163 ---
164
165 --
166 -- ----------------------------------------------------------------------------
167 -- |------------------------< xtrct_skltn >-----------------------------------|
168 -- ----------------------------------------------------------------------------
169 -- {Start Of Comments}
170 --
171 -- Description:
172 --
173 -- Prerequisites:
174 --
175 -- Post Success:
176 --
177 --
178 -- Post Failure:
179 --
180 -- Access Status:
181 -- Public.
182 --
183 -- {End Of Comments}
184 --
185 Procedure xtrct_skltn(p_ext_dfn_id in number,
186 p_business_group_id in number,
187 p_effective_date in date,
188 p_benefit_action_id in number,
189 p_range_id in number,
190 p_start_person_action_id in number,
191 p_end_person_action_id in number,
192 p_data_typ_cd in varchar2,
193 p_ext_typ_cd in varchar2,
194 p_ext_crit_prfl_id in number,
195 p_ext_rslt_id in number,
196 p_ext_file_id in number,
197 p_ext_strt_dt in date,
198 p_ext_end_dt in date,
199 p_prmy_sort_cd in varchar2,
200 p_scnd_sort_cd in varchar2,
201 p_request_id in number,
202 p_use_eff_dt_for_chgs_flag in varchar2,
203 p_penserv_mode in varchar2
204 );
205 --
206 --
207 Procedure set_ext_lvls
208 (p_ext_file_id in number
209 ,p_business_group_id in number
210 );
211 --
212 --
213 --
214 Procedure setup_rcd_typ_lvl
215 (p_ext_file_id in number
216 );
217 --
218 end ben_extract;