1 PACKAGE ben_dm_download_dk AUTHID CURRENT_USER AS
2 /* $Header: benfdmdddk.pkh 120.0 2006/05/04 04:47:27 nkkrishn noship $ */
3
4 --
5 -- Function to check if the DK already exists in the
6 -- BEN_DM_RESOLVE_MAPPINGS table.
7 --
8 function check_if_dk_exists(p_table_name in VARCHAR2
9 ,p_column_name in VARCHAR2
10 ,p_source_id in NUMBER
11 ,p_business_group_name in VARCHAR2) return boolean;
12
13 --
14 -- Function to get the resolve_mapping_id from the cache.
15 --
16 function get_dk_from_cache(p_table_name in VARCHAR2
17 ,p_column_name in VARCHAR2
18 ,p_source_id in NUMBER
19 ,p_business_group_name in VARCHAR2) return number;
20
21 -- DK Resolve from Table BEN_ACTL_PREM_F
22 procedure get_dk_frm_apr (p_business_group_name in VARCHAR2
23 ,p_source_id in NUMBER
24 ,p_resolve_mapping_id out nocopy NUMBER);
25
26 -- DK Resolve from Table BEN_ACTN_TYP
27 procedure get_dk_frm_eat (p_business_group_name in VARCHAR2
28 ,p_source_id in NUMBER
29 ,p_resolve_mapping_id out nocopy NUMBER);
30
31 -- DK Resolve from Table BEN_ACTY_BASE_RT_F
32 procedure get_dk_frm_abr (p_business_group_name in VARCHAR2
33 ,p_source_id in NUMBER
34 ,p_resolve_mapping_id out nocopy NUMBER);
35
36 -- DK Resolve from Table BEN_BENFTS_GRP
37 procedure get_dk_frm_bng (p_business_group_name in VARCHAR2
38 ,p_source_id in NUMBER
39 ,p_resolve_mapping_id out nocopy NUMBER);
40
41 -- DK Resolve from Table BEN_BNFTS_BAL_F
42 procedure get_dk_frm_bnb (p_business_group_name in VARCHAR2
43 ,p_source_id in NUMBER
44 ,p_resolve_mapping_id out nocopy NUMBER);
45
46 -- DK Resolve from Table BEN_BNFT_PRVDR_POOL_F
47 procedure get_dk_frm_bpp (p_business_group_name in VARCHAR2
48 ,p_source_id in NUMBER
49 ,p_resolve_mapping_id out nocopy NUMBER);
50
51 -- DK Resolve from Table BEN_CMBN_PLIP_F
52 procedure get_dk_frm_cpl (p_business_group_name in VARCHAR2
53 ,p_source_id in NUMBER
54 ,p_resolve_mapping_id out nocopy NUMBER);
55
56 -- DK Resolve from Table BEN_CMBN_PTIP_F
57 procedure get_dk_frm_cbp (p_business_group_name in VARCHAR2
58 ,p_source_id in NUMBER
59 ,p_resolve_mapping_id out nocopy NUMBER);
60
61 -- DK Resolve from Table BEN_CMBN_PTIP_OPT_F
62 procedure get_dk_frm_cpt (p_business_group_name in VARCHAR2
63 ,p_source_id in NUMBER
64 ,p_resolve_mapping_id out nocopy NUMBER);
65
66 -- DK Resolve from Table BEN_CM_TRGR
67 procedure get_dk_frm_bcr (p_business_group_name in VARCHAR2
68 ,p_source_id in NUMBER
69 ,p_resolve_mapping_id out nocopy NUMBER);
70
71 -- DK Resolve from Table BEN_CM_TYP_F
72 procedure get_dk_frm_cct (p_business_group_name in VARCHAR2
73 ,p_source_id in NUMBER
74 ,p_resolve_mapping_id out nocopy NUMBER);
75
76 -- DK Resolve from Table BEN_COMP_LVL_FCTR
77 procedure get_dk_frm_clf (p_business_group_name in VARCHAR2
78 ,p_source_id in NUMBER
79 ,p_resolve_mapping_id out nocopy NUMBER);
80
81 -- DK Resolve from Table BEN_CVG_AMT_CALC_MTHD_F
82 procedure get_dk_frm_ccm (p_business_group_name in VARCHAR2
83 ,p_source_id in NUMBER
84 ,p_resolve_mapping_id out nocopy NUMBER);
85
86 -- DK Resolve from Table BEN_ENRT_PERD
87 procedure get_dk_frm_enp (p_business_group_name in VARCHAR2
88 ,p_source_id in NUMBER
89 ,p_resolve_mapping_id out nocopy NUMBER);
90
91 -- DK Resolve from Table BEN_LEE_RSN_F
92 procedure get_dk_frm_len (p_business_group_name in VARCHAR2
93 ,p_source_id in NUMBER
94 ,p_resolve_mapping_id out nocopy NUMBER);
95
96 -- DK Resolve from Table BEN_LER_F
97 procedure get_dk_frm_ler (p_business_group_name in VARCHAR2
98 ,p_source_id in NUMBER
99 ,p_resolve_mapping_id out nocopy NUMBER);
100
101 -- DK Resolve from Table BEN_OIPLIP_F
102 procedure get_dk_frm_boi (p_business_group_name in VARCHAR2
103 ,p_source_id in NUMBER
104 ,p_resolve_mapping_id out nocopy NUMBER);
105
106 -- DK Resolve from Table BEN_OIPL_F
107 procedure get_dk_frm_cop (p_business_group_name in VARCHAR2
108 ,p_source_id in NUMBER
109 ,p_resolve_mapping_id out nocopy NUMBER);
110
111 -- DK Resolve from Table BEN_OPT_F
112 procedure get_dk_frm_opt (p_business_group_name in VARCHAR2
113 ,p_source_id in NUMBER
114 ,p_resolve_mapping_id out nocopy NUMBER);
115
116 -- DK Resolve from Table BEN_PGM_F
117 procedure get_dk_frm_pgm (p_business_group_name in VARCHAR2
118 ,p_source_id in NUMBER
119 ,p_resolve_mapping_id out nocopy NUMBER);
120
121 -- DK Resolve from Table BEN_PLIP_F
122 procedure get_dk_frm_cpp (p_business_group_name in VARCHAR2
123 ,p_source_id in NUMBER
124 ,p_resolve_mapping_id out nocopy NUMBER);
125
126 -- DK Resolve from Table BEN_PL_F
127 procedure get_dk_frm_pln (p_business_group_name in VARCHAR2
128 ,p_source_id in NUMBER
129 ,p_resolve_mapping_id out nocopy NUMBER);
130
131 -- DK Resolve from Table BEN_PL_TYP_F
132 procedure get_dk_frm_ptp (p_business_group_name in VARCHAR2
133 ,p_source_id in NUMBER
134 ,p_resolve_mapping_id out nocopy NUMBER);
135
136 -- DK Resolve from Table BEN_PTIP_F
137 procedure get_dk_frm_ctp (p_business_group_name in VARCHAR2
138 ,p_source_id in NUMBER
139 ,p_resolve_mapping_id out nocopy NUMBER);
140
141 -- DK Resolve from Table BEN_YR_PERD
142 procedure get_dk_frm_yrp (p_business_group_name in VARCHAR2
143 ,p_source_id in NUMBER
144 ,p_resolve_mapping_id out nocopy NUMBER);
145
146 -- DK Resolve from Table FF_FORMULAS_F
147 procedure get_dk_frm_fra (p_business_group_name in VARCHAR2
148 ,p_source_id in NUMBER
149 ,p_resolve_mapping_id out nocopy NUMBER);
150
151 -- DK Resolve from Table FND_ID_FLEX_STRUCTURES_VL
152 procedure get_dk_frm_fit (p_business_group_name in VARCHAR2
153 ,p_source_id in NUMBER
154 ,p_resolve_mapping_id out nocopy NUMBER);
155
156 -- DK Resolve from Table FND_USER
157 procedure get_dk_frm_fus (p_business_group_name in VARCHAR2
158 ,p_source_id in NUMBER
159 ,p_resolve_mapping_id out nocopy NUMBER);
160
161 -- DK Resolve from Table HR_ALL_ORGANIZATION_UNITS
162 procedure get_dk_frm_aou (p_business_group_name in VARCHAR2
163 ,p_source_id in NUMBER
164 ,p_resolve_mapping_id out nocopy NUMBER);
165
166 -- DK Resolve from Table HR_ALL_ORGANIZATION_UNITS (BG)
167 procedure get_dk_frm_ori (p_business_group_name in VARCHAR2
168 ,p_source_id in NUMBER
169 ,p_resolve_mapping_id out nocopy NUMBER);
170
171 -- DK Resolve from Table HR_LOCATIONS_ALL
172 procedure get_dk_frm_loc (p_business_group_name in VARCHAR2
173 ,p_source_id in NUMBER
174 ,p_resolve_mapping_id out nocopy NUMBER);
175
176 -- DK Resolve from Table PAY_ALL_PAYROLLS_F
177 procedure get_dk_frm_prl (p_business_group_name in VARCHAR2
178 ,p_source_id in NUMBER
179 ,p_resolve_mapping_id out nocopy NUMBER);
180
181 -- DK Resolve from Table PAY_ELEMENT_TYPES_F
182 procedure get_dk_frm_pet (p_business_group_name in VARCHAR2
183 ,p_source_id in NUMBER
184 ,p_resolve_mapping_id out nocopy NUMBER);
185
186 -- DK Resolve from Table PAY_INPUT_VALUES_F
187 procedure get_dk_frm_ipv (p_business_group_name in VARCHAR2
188 ,p_source_id in NUMBER
189 ,p_resolve_mapping_id out nocopy NUMBER);
190
191 -- DK Resolve from Table PAY_ELEMENT_LINKS_F
192 procedure get_dk_frm_pll (p_business_group_name in VARCHAR2
196 -- DK Resolve from Table PER_ASSIGNMENT_STATUS_TYPES
193 ,p_source_id in NUMBER
194 ,p_resolve_mapping_id out nocopy NUMBER);
195
197 procedure get_dk_frm_ast (p_business_group_name in VARCHAR2
198 ,p_source_id in NUMBER
199 ,p_resolve_mapping_id out nocopy NUMBER);
200
201 -- DK Resolve from Table PER_GRADES
202 procedure get_dk_frm_gra (p_business_group_name in VARCHAR2
203 ,p_source_id in NUMBER
204 ,p_resolve_mapping_id out nocopy NUMBER);
205
206 -- DK Resolve from Table PER_JOBS
207 procedure get_dk_frm_job (p_business_group_name in VARCHAR2
208 ,p_source_id in NUMBER
209 ,p_resolve_mapping_id out nocopy NUMBER);
210
211 -- DK Resolve from Table PER_PAY_BASES
212 procedure get_dk_frm_pyb (p_business_group_name in VARCHAR2
213 ,p_source_id in NUMBER
214 ,p_resolve_mapping_id out nocopy NUMBER);
215
216 -- DK Resolve from Table PER_PERSON_TYPES
217 procedure get_dk_frm_prt (p_business_group_name in VARCHAR2
218 ,p_source_id in NUMBER
219 ,p_resolve_mapping_id out nocopy NUMBER);
220
221 -- DK Resolve from Table PER_ABSENCE_ATTENDANCE_TYPES
222 procedure get_dk_frm_aat (p_business_group_name in VARCHAR2
223 ,p_source_id in NUMBER
224 ,p_resolve_mapping_id out nocopy NUMBER);
225
226 -- DK Resolve from Table PER_ABS_ATTENDANCE_REASONS
227 procedure get_dk_frm_aar (p_business_group_name in VARCHAR2
228 ,p_source_id in NUMBER
229 ,p_resolve_mapping_id out nocopy NUMBER);
230
231 -- DK Resolve from Table HR_SOFT_CODING_KEYFLEX
232 procedure get_dk_frm_scl (p_business_group_name in VARCHAR2
233 ,p_source_id in NUMBER
234 ,p_resolve_mapping_id out nocopy NUMBER);
235
236 -- DK Resolve from Table PAY_PEOPLE_GROUPS
237 procedure get_dk_frm_peg (p_business_group_name in VARCHAR2
238 ,p_source_id in NUMBER
239 ,p_resolve_mapping_id out nocopy NUMBER);
240 --
241 end ben_dm_download_dk;