[Home] [Help]
PACKAGE: APPS.PAY_JP_REPORT_PKG
Source
1 PACKAGE PAY_JP_REPORT_PKG AS
2 /* $Header: pyjprep.pkh 120.0.12000000.2 2007/05/17 18:19:06 keyazawa noship $ */
3 TYPE g_rec_bind_variables IS RECORD(
4 NAME VARCHAR2(30),
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 PROCEDURE INSERT_SESSION_DATE(
13 P_EFFECTIVE_DATE IN DATE);
14 --
15 PROCEDURE DELETE_SESSION_DATE;
16 --
17 PROCEDURE TO_ERA( p_date IN DATE,
18 p_era_code OUT NOCOPY NUMBER,
19 p_year OUT NOCOPY NUMBER,
20 p_month OUT NOCOPY NUMBER,
21 p_day OUT NOCOPY NUMBER);
22 --
23 FUNCTION get_concatenated_numbers(
24 p_number1 IN NUMBER,
25 p_number2 IN NUMBER,
26 p_number3 IN NUMBER,
27 p_number4 IN NUMBER,
28 p_number5 IN NUMBER,
29 p_number6 IN NUMBER,
30 p_number7 IN NUMBER,
31 p_number8 IN NUMBER,
32 p_number9 IN NUMBER,
33 p_number10 IN NUMBER) RETURN VARCHAR2;
34 -- pragma restrict_references(get_concatenated_numbers,WNDS,WNPS);
35 --
36 FUNCTION get_concatenated_dependents(
37 p_person_id IN NUMBER,
38 p_effective_date IN DATE,
39 p_kanji_flag IN VARCHAR2 DEFAULT '1') RETURN VARCHAR2;
40 -- pragma restrict_references(get_concatenated_dependents,WNDS,WNPS);
41 --
42 FUNCTION convert2(
43 str IN VARCHAR2,
44 dest_set IN VARCHAR2) RETURN VARCHAR2;
45 -- pragma restrict_references(convert2,WNDS,WNPS);
46 --
47 FUNCTION substrb2(
48 str IN VARCHAR2,
49 pos IN NUMBER,
50 len IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
51 -- pragma restrict_references(substrb2,WNDS,WNPS);
52 --
53 FUNCTION substr2(
54 str IN VARCHAR2,
55 pos IN NUMBER,
56 len IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
57 --
58 PROCEDURE dynamic_sql(
59 p_sql_statement IN VARCHAR2,
60 p_bind_variables IN g_tab_bind_variables,
61 p_column_names IN g_tab_column_names);
62 --
63 FUNCTION set_space_on_address(
64 p_address IN VARCHAR2,
65 p_district_name IN VARCHAR2,
66 p_kana_flag IN NUMBER) RETURN VARCHAR2;
67 -- pragma restrict_references(set_space_on_address,WNDS,WNPS);
68 --
69 FUNCTION get_max_value(
70 p_user_table_name IN VARCHAR2,
71 p_udt_column_name IN VARCHAR2,
72 p_effective_date IN DATE ) RETURN NUMBER;
73 -- pragma restrict_references(get_max_value,WNDS,WNPS);
74 --
75 FUNCTION get_min_value(
76 p_user_table_name IN VARCHAR2,
77 p_udt_column_name IN VARCHAR2,
78 p_effective_date IN DATE ) RETURN NUMBER;
79 -- pragma restrict_references(get_min_value,WNDS,WNPS);
80 --
81 FUNCTION sjtojis(
82 p_src IN VARCHAR2 ) RETURN VARCHAR2;
83 -- pragma restrict_references(get_min_value,WNDS,WNPS);
84 --
85 FUNCTION eligible_for_submission (
86 p_year IN NUMBER,
87 p_itax_yea_category IN VARCHAR2,
88 p_gross_taxable_amt IN NUMBER,
89 p_taxable_amt IN NUMBER,
90 p_prev_swot_taxable_amt IN NUMBER,
91 p_executive_flag IN VARCHAR2,
92 p_itax_category IN VARCHAR2) RETURN VARCHAR2;
93 --
94 FUNCTION get_prev_swot_info (
95 p_business_group_id in NUMBER,
96 p_assignment_id in NUMBER,
97 p_year in NUMBER,
98 p_itax_organization_id in NUMBER,
99 p_swot_iv_id in NUMBER,
100 p_action_sequence in NUMBER,
101 p_kanji_flag in VARCHAR2 DEFAULT '1',
102 p_media_type in VARCHAR2 DEFAULT 'NULL') RETURN VARCHAR2;
103 --
104 --
105 FUNCTION get_pjob_info (
106 p_assignment_id in NUMBER,
107 p_effective_date in DATE,
108 p_business_group_id in NUMBER,
109 p_pjob_ele_type_id in NUMBER,
110 p_taxable_amt_iv_id in NUMBER,
111 p_si_prem_iv_id in NUMBER,
112 p_mutual_aid_iv_id in NUMBER,
113 p_itax_iv_id in NUMBER,
114 p_term_date_iv_id in NUMBER,
115 p_addr_iv_id in NUMBER,
116 p_employer_name_iv_id in NUMBER,
117 p_kanji_flag in VARCHAR2 DEFAULT '1',
118 p_media_type in VARCHAR2 DEFAULT 'NULL') RETURN VARCHAR2;
119 --
120 --
121 FUNCTION convert_to_wtm_format(
122 p_text IN VARCHAR2,
123 p_kanji_flag IN VARCHAR2 DEFAULT '1',
124 p_media_type IN VARCHAR2 DEFAULT 'NULL') RETURN VARCHAR2;
125 --
126 FUNCTION get_concatenated_disability(
127 p_person_id IN NUMBER,
128 p_effective_date IN DATE) RETURN VARCHAR2;
129 --
130 FUNCTION get_hi_dependent_exists(
131 p_person_id IN NUMBER,
132 p_effective_date IN DATE) RETURN VARCHAR2;
133 --
134 FUNCTION get_hi_dependent_number(
135 p_person_id IN NUMBER,
136 p_effective_date IN DATE) RETURN NUMBER;
137 --
138 FUNCTION chk_use_contact_extra_info(
139 p_business_group_id in number) return varchar2;
140 --
141 FUNCTION get_si_dependent_report_type(
142 p_person_id per_all_people_f.person_id%TYPE,
143 p_qualified_date DATE) RETURN NUMBER;
144 --
145 FUNCTION get_si_dep_ee_effective_date(
146 p_person_id per_all_people_f.person_id%TYPE,
147 p_date_from DATE,
148 p_date_to DATE,
149 p_report_type hr_lookups.lookup_code%TYPE) RETURN DATE;
150 --
151 FUNCTION decode_ass_set_name(
152 p_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE) RETURN VARCHAR2;
153 --
154 g_legislation_code varchar2(2);
155 --
156 type t_si_rec is record(
157 hi_org_iv_id number,
158 wp_org_iv_id number,
159 wpf_org_iv_id number,
160 hi_num_iv_id number,
161 wp_num_iv_id number,
162 bp_num_iv_id number,
163 exc_iv_id number,
164 hi_qd_iv_id number,
165 wp_qd_iv_id number,
166 wpf_qd_iv_id number,
167 hi_dqd_iv_id number,
168 wp_dqd_iv_id number,
169 wpf_dqd_iv_id number);
170 --
171 g_si_rec t_si_rec;
172 --
173 type t_gs_rec is record(
174 hi_appl_mth_iv_id number,
175 wp_appl_mth_iv_id number,
176 hi_appl_cat_iv_id number,
177 wp_appl_cat_iv_id number,
178 san_ele_set_id number,
179 gep_ele_set_id number,
180 iku_ele_set_id number);
181 --
182 g_gs_rec t_gs_rec;
183 --
184 function get_si_rec_id(
185 p_rec_name in varchar2)
186 return number;
187 --
188 function get_gs_rec_id(
189 p_rec_name in varchar2)
190 return number;
191 --
192 function chk_hi_wp(
193 p_sort_order in varchar2,
194 p_submit_type in number,
195 p_si_type in number)
196 return number;
197 --
198 procedure get_latest_std_mth_comp_info(
199 p_assignment_id in number,
200 p_effective_date in date,
201 p_date_earned in date,
202 p_applied_mth_iv_id in number,
203 p_new_std_mth_comp_iv_id in number,
204 p_old_std_mth_comp_iv_id in number,
205 p_latest_applied_date out nocopy date,
206 p_latest_std_mth_comp out nocopy varchar2);
207 --
208 function chk_hi_wp_invalid(
209 p_qualified_date in date,
210 p_disqualified_date in date,
211 p_date_earned in date)
212 return number;
213 --
214 function get_applied_date_old(
215 p_hi_invalid in number,
216 p_wp_invalid in number,
217 p_hi_applied_date_old in date,
218 p_wp_applied_date_old in date,
219 p_si_submit_type in number)
220 return date;
221 --
222 function get_user_elm_name(p_base_elm_name in varchar2)
223 return varchar2;
224 --
225 END PAY_JP_REPORT_PKG;