[Home] [Help]
PACKAGE: APPS.PAY_JP_REPORT_PKG
Source
4 NAME VARCHAR2(30),
1 PACKAGE PAY_JP_REPORT_PKG AUTHID CURRENT_USER AS
2 /* $Header: pyjprep.pkh 120.7 2010/12/09 04:05:55 keyazawa ship $ */
3 TYPE g_rec_bind_variables IS RECORD(
5 VALUE VARCHAR2(255),
6 DATATYPE VARCHAR2(10) DEFAULT 'NUMBER');
7 TYPE g_tab_bind_variables IS TABLE OF g_rec_bind_variables INDEX BY BINARY_INTEGER;
8 g_bind_variables g_tab_bind_variables;
9 TYPE g_tab_column_names IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
10 g_column_names g_tab_column_names;
11 --
12 g_detail_debug varchar2(1);
13 --
14 PROCEDURE INSERT_SESSION_DATE(
15 P_EFFECTIVE_DATE IN DATE);
16 --
17 PROCEDURE DELETE_SESSION_DATE;
18 --
19 PROCEDURE TO_ERA( p_date IN DATE,
20 p_era_code OUT NOCOPY NUMBER,
21 p_year OUT NOCOPY NUMBER,
22 p_month OUT NOCOPY NUMBER,
23 p_day OUT NOCOPY NUMBER);
24 --
25 FUNCTION get_concatenated_numbers(
26 p_number1 IN NUMBER,
27 p_number2 IN NUMBER,
28 p_number3 IN NUMBER,
29 p_number4 IN NUMBER,
30 p_number5 IN NUMBER,
31 p_number6 IN NUMBER,
32 p_number7 IN NUMBER,
33 p_number8 IN NUMBER,
34 p_number9 IN NUMBER,
35 p_number10 IN NUMBER) RETURN VARCHAR2;
36 -- pragma restrict_references(get_concatenated_numbers,WNDS,WNPS);
37 --
38 FUNCTION get_concatenated_dependents(
39 p_person_id IN NUMBER,
40 p_effective_date IN DATE,
41 p_kanji_flag IN VARCHAR2 DEFAULT '1') RETURN VARCHAR2;
42 -- pragma restrict_references(get_concatenated_dependents,WNDS,WNPS);
43 --
44 FUNCTION convert2(
45 str IN VARCHAR2,
46 dest_set IN VARCHAR2) RETURN VARCHAR2;
47 -- pragma restrict_references(convert2,WNDS,WNPS);
48 --
49 FUNCTION substrb2(
50 str IN VARCHAR2,
54 --
51 pos IN NUMBER,
52 len IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
53 -- pragma restrict_references(substrb2,WNDS,WNPS);
55 FUNCTION substr2(
56 str IN VARCHAR2,
57 pos IN NUMBER,
58 len IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
59 --
60 PROCEDURE dynamic_sql(
61 p_sql_statement IN VARCHAR2,
62 p_bind_variables IN g_tab_bind_variables,
63 p_column_names IN g_tab_column_names);
64 --
65 FUNCTION set_space_on_address(
66 p_address IN VARCHAR2,
67 p_district_name IN VARCHAR2,
68 p_kana_flag IN NUMBER) RETURN VARCHAR2;
69 -- pragma restrict_references(set_space_on_address,WNDS,WNPS);
70 --
71 FUNCTION get_max_value(
72 p_user_table_name IN VARCHAR2,
73 p_udt_column_name IN VARCHAR2,
74 p_effective_date IN DATE ) RETURN NUMBER;
75 -- pragma restrict_references(get_max_value,WNDS,WNPS);
76 --
77 FUNCTION get_min_value(
78 p_user_table_name IN VARCHAR2,
79 p_udt_column_name IN VARCHAR2,
80 p_effective_date IN DATE ) RETURN NUMBER;
81 -- pragma restrict_references(get_min_value,WNDS,WNPS);
82 --
83 FUNCTION sjtojis(
84 p_src IN VARCHAR2 ) RETURN VARCHAR2;
85 -- pragma restrict_references(get_min_value,WNDS,WNPS);
86 --
87 FUNCTION eligible_for_submission (
88 p_year IN NUMBER,
89 p_itax_yea_category IN VARCHAR2,
90 p_gross_taxable_amt IN NUMBER,
91 p_taxable_amt IN NUMBER,
92 p_prev_swot_taxable_amt IN NUMBER,
93 p_executive_flag IN VARCHAR2,
94 p_itax_category IN VARCHAR2) RETURN VARCHAR2;
95 --
96 FUNCTION get_prev_swot_info (
97 p_business_group_id in NUMBER,
98 p_assignment_id in NUMBER,
99 p_year in NUMBER,
100 p_itax_organization_id in NUMBER,
101 p_swot_iv_id in NUMBER,
102 p_action_sequence in NUMBER,
103 p_kanji_flag in VARCHAR2 DEFAULT '1',
104 p_media_type in VARCHAR2 DEFAULT 'NULL') RETURN VARCHAR2;
105 --
106 --
107 FUNCTION get_pjob_info (
108 p_assignment_id in NUMBER,
109 p_effective_date in DATE,
110 p_business_group_id in NUMBER,
111 p_pjob_ele_type_id in NUMBER,
112 p_taxable_amt_iv_id in NUMBER,
113 p_si_prem_iv_id in NUMBER,
114 p_mutual_aid_iv_id in NUMBER,
115 p_itax_iv_id in NUMBER,
116 p_term_date_iv_id in NUMBER,
117 p_addr_iv_id in NUMBER,
118 p_employer_name_iv_id in NUMBER,
119 p_kanji_flag in VARCHAR2 DEFAULT '1',
120 p_media_type in VARCHAR2 DEFAULT 'NULL') RETURN VARCHAR2;
121 --
122 --
123 FUNCTION convert_to_wtm_format(
124 p_text IN VARCHAR2,
125 p_kanji_flag IN VARCHAR2 DEFAULT '1',
126 p_media_type IN VARCHAR2 DEFAULT 'NULL') RETURN VARCHAR2;
127 --
128 FUNCTION get_concatenated_disability(
129 p_person_id IN NUMBER,
130 p_effective_date IN DATE) RETURN VARCHAR2;
131 --
132 FUNCTION get_hi_dependent_exists(
133 p_person_id IN NUMBER,
134 p_effective_date IN DATE) RETURN VARCHAR2;
135 --
136 FUNCTION get_hi_dependent_number(
137 p_person_id IN NUMBER,
138 p_effective_date IN DATE) RETURN NUMBER;
139 --
140 FUNCTION chk_use_contact_extra_info(
141 p_business_group_id in number) return varchar2;
142 --
143 FUNCTION get_si_dependent_report_type(
144 p_person_id per_all_people_f.person_id%TYPE,
145 p_qualified_date DATE) RETURN NUMBER;
146 --
147 FUNCTION get_si_dep_ee_effective_date(
148 p_person_id per_all_people_f.person_id%TYPE,
149 p_date_from DATE,
150 p_date_to DATE,
151 p_report_type hr_lookups.lookup_code%TYPE) RETURN DATE;
152 --
153 FUNCTION decode_ass_set_name(
154 p_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE) RETURN VARCHAR2;
155 --
156 g_legislation_code varchar2(2);
157 --
158 type t_si_rec is record(
159 hi_org_iv_id number,
160 wp_org_iv_id number,
161 wpf_org_iv_id number,
162 hi_num_iv_id number,
163 wp_num_iv_id number,
164 bp_num_iv_id number,
165 exc_iv_id number,
166 hi_qd_iv_id number,
167 wp_qd_iv_id number,
168 wpf_qd_iv_id number,
169 hi_dqd_iv_id number,
170 wp_dqd_iv_id number,
171 wpf_dqd_iv_id number);
172 --
173 g_si_rec t_si_rec;
174 --
175 type t_gs_rec is record(
176 hi_appl_mth_iv_id number,
177 wp_appl_mth_iv_id number,
178 hi_appl_cat_iv_id number,
179 wp_appl_cat_iv_id number,
180 san_ele_set_id number,
181 gep_ele_set_id number,
182 iku_ele_set_id number);
183 --
184 g_gs_rec t_gs_rec;
185 --
186 type t_file_data_tbl is table of varchar2(32767) index by binary_integer;
187 --
188 function get_si_rec_id(
189 p_rec_name in varchar2)
190 return number;
191 --
192 function get_gs_rec_id(
193 p_rec_name in varchar2)
194 return number;
198 p_submit_type in number,
195 --
196 function chk_hi_wp(
197 p_sort_order in varchar2,
199 p_si_type in number)
200 return number;
201 --
202 procedure get_latest_std_mth_comp_info(
203 p_assignment_id in number,
204 p_effective_date in date,
205 p_date_earned in date,
206 p_applied_mth_iv_id in number,
207 p_new_std_mth_comp_iv_id in number,
208 p_old_std_mth_comp_iv_id in number,
209 p_latest_applied_date out nocopy date,
210 p_latest_std_mth_comp out nocopy varchar2);
211 --
212 function chk_hi_wp_invalid(
213 p_qualified_date in date,
214 p_disqualified_date in date,
215 p_date_earned in date)
216 return number;
217 --
218 function get_applied_date_old(
219 p_hi_invalid in number,
220 p_wp_invalid in number,
221 p_hi_applied_date_old in date,
222 p_wp_applied_date_old in date,
223 p_si_submit_type in number)
224 return date;
225 --
226 function get_user_elm_name(p_base_elm_name in varchar2)
227 return varchar2;
228 --
229 g_char_set varchar2(30);
230 g_db_char_set varchar2(30);
231 g_delimiter varchar2(1);
232 --
233 procedure append_select_clause(
234 p_clause in varchar2,
235 p_select_clause in out nocopy varchar2);
236 --
237 procedure append_from_clause(
238 p_clause in varchar2,
239 p_from_clause in out nocopy varchar2,
240 p_top in varchar2 default 'N');
241 --
242 procedure append_where_clause(
243 p_clause in varchar2,
244 p_where_clause in out nocopy varchar2);
245 --
246 procedure append_order_clause(
247 p_clause in varchar2,
248 p_order_clause in out nocopy varchar2);
249 --
250 procedure show_debug(
251 p_text in varchar2);
252 --
253 procedure show_warning(
254 p_which in number,
255 p_text in varchar2);
256 --
257 procedure set_char_set(
258 p_char_set in varchar2);
259 --
260 procedure set_db_char_set(
261 p_db_char_set in varchar2 default null);
262 --
263 function check_file(
264 p_file_name in varchar2,
265 p_file_dir in varchar2)
266 return boolean;
267 --
268 procedure open_file(
269 p_file_name in varchar2,
270 p_file_dir in varchar2,
271 p_file_out out nocopy utl_file.file_type,
272 p_file_type in varchar2 default 'a');
273 --
274 procedure write_file(
275 p_file_name in varchar2,
276 p_file_out in utl_file.file_type,
277 p_line in varchar2,
278 p_char_set in varchar2 default null);
279 --
280 procedure read_file(
281 p_file_name in varchar2,
282 p_file_out in utl_file.file_type,
283 p_file_data_tbl out nocopy t_file_data_tbl);
284 --
285 procedure close_file(
286 p_file_name in varchar2,
287 p_file_out in out nocopy utl_file.file_type,
288 p_file_type in varchar2 default 'a');
289 --
290 procedure delete_file(
291 p_file_dir in varchar2,
292 p_file_name in varchar2);
293 --
294 function split_str(
295 p_text in varchar2,
296 p_n in number)
297 return varchar2;
298 --
299 function cnv_str(
300 p_text in varchar2,
301 p_start in number default null,
302 p_end in number default null)
303 return varchar2;
304 --
305 function cnv_siz(
306 p_type in varchar2,
307 p_len in number,
308 p_text in varchar2)
309 return varchar2;
310 --
311 function cnv_siz(
312 p_type in varchar2,
313 p_len in number,
314 p_text in number)
315 return number;
316 --
317 function cnv_txt(
318 p_text in varchar2,
319 p_char_set in varchar2 default null)
320 return varchar2;
321 --
322 function cnv_txt(
323 p_text in number,
324 p_char_set in varchar2 default null)
325 return varchar2;
326 --
327 function cnv_db_txt(
328 p_text in varchar2,
329 p_char_set in varchar2 default null,
330 p_db_char_set in varchar2 default null)
331 return varchar2;
332 --
333 function add_tag(
334 p_tag in varchar2,
335 p_text in varchar2)
336 return varchar2;
337 --
338 function add_tag(
339 p_tag in varchar2,
340 p_text in date)
341 return varchar2;
342 --
343 function add_tag(
344 p_tag in varchar2,
345 p_text in number)
346 return varchar2;
347 --
348 function add_tag_m(
349 p_tag in varchar2,
350 p_text in number)
351 return varchar2;
352 --
353 function add_tag_v(
354 p_tag in varchar2,
355 p_text in varchar2)
356 return varchar2;
357 --
358 function htmlspchar(
359 p_text in varchar2)
360 return varchar2;
361 --
362 procedure set_delimiter(
363 p_delimiter in varchar2);
364 --
365 function csvspchar(
366 p_text in varchar2)
367 return varchar2;
368 --
369 function decode_value(
370 p_condition in boolean,
371 p_true_value in varchar2,
372 p_false_value in varchar2)
373 return varchar2;
374 --
375 function jp_era_date(
376 p_date in date,
377 p_format in varchar2)
378 return varchar2;
379 --
380 function get_udt_value(
381 p_business_group_id in number,
382 p_table in varchar2,
383 p_column in varchar2,
384 p_row in varchar2,
385 p_effective_date in date default null)
386 return varchar2;
387 --
391 return varchar2;
388 function set_era_code(
389 p_date in date,
390 p_era_code in varchar2)
392 --
393 function set_circle(
394 p_data in varchar2,
395 p_condition in varchar2)
396 return varchar2;
397 --
398 function concatenate(
399 p_str1 in varchar2,
400 p_str2 in varchar2)
401 return varchar2;
402 --
403 procedure set_detail_debug(
404 p_parm_name in varchar2,
405 p_yn in varchar2);
406 --
407 END PAY_JP_REPORT_PKG;