[Home] [Help]
PACKAGE: APPS.PAY_JP_LTAX_IMP_PKG
Source
1 package pay_jp_ltax_imp_pkg AUTHID CURRENT_USER as
2 /* $Header: pyjpltxi.pkh 120.0.12010000.1 2009/06/24 07:04:18 keyazawa noship $ */
3 --
4 c_char_set varchar2(30) := 'JA16SJIS';
5 c_file_prefix varchar2(6) := 'ltax';
6 c_file_spliter varchar2(1) := '_';
7 c_file_extension varchar2(4) := '.csv';
8 c_asg_set_prefix varchar2(30) := 'REQUEST_ID_';
9 --
10 c_def_val varchar2(1000) := to_char(hr_api.g_number);
11 c_value_if_null_tbl constant pay_jp_bee_utility_pkg.t_varchar2_tbl
12 := pay_jp_bee_utility_pkg.entry_value_tbl(
13 c_def_val,
14 c_def_val,
15 c_def_val,
16 c_def_val,
17 c_def_val,
18 c_def_val,
19 c_def_val,
20 c_def_val,
21 c_def_val,
22 c_def_val,
23 c_def_val,
24 c_def_val,
25 c_def_val,
26 c_def_val,
27 c_def_val);
28 --
29 g_request_id number;
30 g_business_group_id number;
31 g_effective_yyyymm varchar2(6);
32 g_effective_som date;
33 g_effective_eom date;
34 g_effective_soy date;
35 g_effective_eoy date;
36 g_upload_date date;
37 g_session_date date;
38 g_district_code per_addresses.town_or_city%type;
39 g_organization_id number;
40 g_assignment_set_id number;
41 g_ass_set_formula_id number;
42 g_ass_set_amendment_type hr_assignment_set_amendments.include_or_exclude%type;
43 g_file_dir fnd_concurrent_processes.plsql_dir%type;
44 g_action_if_exists varchar2(1);
45 g_reject_if_future_changes varchar2(1);
46 g_create_entry_if_not_exist varchar2(1);
47 g_create_asg_set_for_errored varchar2(1);
48 g_payroll_id number;
49 g_err_ass_set_id number;
50 g_err_ass_set_name hr_assignment_sets.assignment_set_name%type;
51 --
52 g_file_prefix varchar2(30);
53 g_file_suffix varchar2(30);
54 g_file_extension varchar2(30);
55 --
56 g_file_split varchar2(1) := 'Y';
57 g_datetrack_eev varchar2(1) := 'N';
58 g_valid_term_flag varchar2(1) := 'Y';
59 --
60 g_show_dup_file varchar2(1) := 'N';
61 g_show_no_file varchar2(1) := 'N';
62 g_valid_diff_ltax varchar2(1) := 'N';
63 g_valid_incon_data varchar2(1) := 'N';
64 g_show_incon_data varchar2(1) := 'N';
65 g_valid_non_res varchar2(1) := 'N';
66 g_valid_dup_ass varchar2(1) := 'N';
67 g_show_upd_eev varchar2(1) := 'N';
68 g_valid_no_upd varchar2(1) := 'Y';
69 g_show_no_upd varchar2(1) := 'N';
70 g_valid_sp_with varchar2(1) := 'Y';
71 g_valid_inv_ass varchar2(1) := 'Y';
72 --
73 g_show_data varchar2(1) := 'N';
74 g_detail_debug varchar2(1) := 'N';
75 g_detail_eev varchar2(1) := 'Y';
76 --
77 procedure set_file_prefix(
78 p_file_prefix in varchar2);
79 --
80 procedure set_file_suffix(
81 p_file_suffix in varchar2);
82 --
83 procedure set_file_extension(
84 p_file_extension in varchar2);
85 --
86 procedure set_file_split(
87 p_file_split in varchar2);
88 --
89 procedure set_datetrack_eev(
90 p_datetrack_eev in varchar2);
91 --
92 procedure set_detail_debug(
93 p_yn in varchar2);
94 --
95 procedure init(
96 p_business_group_id in number,
97 p_subject_yyyymm in varchar2,
98 p_upload_date in date,
99 p_organization_id in number,
100 p_district_code in varchar2,
101 p_assignment_set_id in number,
102 p_file_suffix in varchar2,
103 p_file_split in varchar2,
104 p_datetrack_eev in varchar2,
105 p_show_dup_file in varchar2,
106 p_show_no_file in varchar2,
107 p_valid_diff_ltax in varchar2,
108 p_valid_incon_data in varchar2,
109 p_show_incon_data in varchar2,
110 p_valid_non_res in varchar2,
111 p_valid_dup_ass in varchar2,
112 p_show_upd_eev in varchar2,
113 p_valid_no_upd in varchar2,
114 p_show_no_upd in varchar2,
115 p_valid_sp_with in varchar2,
116 p_action_if_exists in varchar2,
117 p_reject_if_future_changes in varchar2,
118 p_create_entry_if_not_exist in varchar2,
119 p_create_asg_set_for_errored in varchar2);
120 --
121 procedure transfer_imp_ltax_info_to_bee(
122 p_errbuf out nocopy varchar2,
123 p_retcode out nocopy varchar2,
124 p_business_group_id in number,
125 p_subject_yyyymm in varchar2,
126 p_upload_date in varchar2,
127 p_batch_name in varchar2,
128 p_action_if_exists in varchar2,
129 p_reject_if_future_changes in varchar2,
130 p_date_effective_changes in varchar2,
131 p_purge_after_transfer in varchar2,
132 p_create_entry_if_not_exist in varchar2,
133 p_create_asg_set_for_errored in varchar2,
134 p_organization_id in number,
135 p_district_code in varchar2,
136 p_assignment_set_id in number,
137 p_file_suffix in varchar2,
138 p_file_split in varchar2,
139 p_datetrack_eev in varchar2,
140 p_valid_diff_ltax in varchar2,
141 p_valid_incon_data in varchar2,
142 p_valid_non_res in varchar2,
143 p_valid_dup_ass in varchar2,
144 p_valid_no_upd in varchar2,
145 p_valid_sp_with in varchar2,
146 p_show_dup_file in varchar2 default 'N',
147 p_show_no_file in varchar2 default 'N',
148 p_show_incon_data in varchar2 default 'N',
149 p_show_upd_eev in varchar2 default 'N',
150 p_show_no_upd in varchar2 default 'N');
151 --
152 end pay_jp_ltax_imp_pkg;