[Home] [Help]
PACKAGE: APPS.PAY_KR_YEA_PDF_PKG
Source
1 package pay_kr_yea_pdf_pkg AUTHID CURRENT_USER as
2 /* $Header: pykrypdf.pkh 120.0.12020000.3 2013/01/08 07:41:19 scireddy noship $ */
3 --
4 g_imp_output_hd_show varchar2(1);
5 g_upl_output_hd_show varchar2(1);
6 --
7 g_business_group_id number;
8 g_target_yyyy number;
9 g_business_place_id number;
10 g_assignment_set_id number;
11 g_remove_pdf varchar2(1);
12 g_map_key varchar2(30); /* FULL_NAME, EMPLOYEE_NUMBER */
13 g_upload_to varchar2(30);
14 g_force_load varchar2(1);
15 g_skip_validate varchar2(1);
16 g_import_path fnd_lobs.file_name%type;
17 g_path_delimiter varchar2(1);
18 g_chunk number := 100;
19 g_load_type varchar2(1); /* I(mport), U(pload), L(oad) */
20 g_show_xml varchar2(1);
21 --
22 c_path_delimiter varchar2(1) := '/';
23 c_path_delimiter_win varchar2(1) := '\';
24 c_file_extention varchar2(5) := '.pdf';
25 c_entry_status varchar2(1) := 'N';
26 c_import_status varchar2(3) := 'I';
27 c_pdf_mime varchar2(100) := 'application/pdf';
28 c_upload_status varchar2(3) := 'U';
29 c_error_status varchar2(3) := 'E';
30 c_process_status varchar2(3) := 'P';
31 c_xml_date_fmt varchar2(8) := 'YYYYMMDD';
32 c_int_type1_year_min number := 15;
33 c_int_type2_year_min number := 30;
34 c_don_poli_max number := 100000;
35 c_priority_inc number := 10;
36 c_ni_len number := 13;
37 --
38 procedure load_init(
39 p_business_group_id in number,
40 p_target_year in number,
41 p_business_place_id in number default null,
42 p_assignment_set_id in number default null,
43 p_admin in varchar2 default null,
44 p_remove_pdf in varchar2 default null,
45 p_map_key in varchar2 default null,
46 p_upload_to in varchar2 default null,
47 p_force_load in varchar2 default null,
48 p_skip_validate in varchar2 default null,
49 p_show_xml in varchar2 default null,
50 p_import_path out nocopy varchar2,
51 p_nts_certs_path out nocopy varchar2);
52 --
53 procedure import_init(
54 p_business_group_id in number,
55 p_target_year in number,
56 p_business_place_id in number,
57 p_assignment_set_id in number,
58 p_remove_pdf in varchar2,
59 p_map_key in varchar2,
60 p_force_import in varchar2,
61 p_import_path out nocopy varchar2);
62 --
63 procedure import_kr_ass_yea(
64 p_assignment_id in number,
65 p_target_year in number,
66 p_file_id in number,
67 p_proc_status in varchar2,
68 p_assignment_yea_info_id out nocopy number);
69 --
70 function import_file(
71 p_file_name in varchar2)
72 return number;
73 --
74 procedure import_post;
75 --
76 procedure import_error;
77 --
78 procedure get_pdf_blob(
79 p_emp_num out nocopy varchar2,
80 p_emp_name out nocopy varchar2,
81 p_pdf_pwd out nocopy varchar2,
82 p_blob out nocopy blob);
83 --
84 procedure get_pdf_blob_ss(
85 p_assignment_yea_info_id in number,
86 p_business_group_id in number,
87 p_target_year in number,
88 p_business_place_id in number,
89 p_force_upload in varchar2,
90 p_nts_certs_path out nocopy varchar2,
91 p_emp_num out nocopy varchar2,
92 p_emp_name out nocopy varchar2,
93 p_pdf_pwd out nocopy varchar2,
94 p_blob out nocopy blob);
95 --
96 procedure upload_init(
97 p_assignment_yea_info_id in number default null,
98 p_business_group_id in number default null,
99 p_target_year in number default null,
100 p_business_place_id in number default null,
101 p_assignment_set_id in number default null,
102 p_admin in varchar2 default null,
103 p_remove_pdf in varchar2 default null,
104 p_upload_to in varchar2 default null,
105 p_force_upload in varchar2 default null,
106 p_skip_validate in varchar2 default null,
107 p_show_xml in varchar2 default null,
108 p_nts_certs_path out nocopy varchar2);
109 --
110 procedure load_map_file(
111 p_file_name in varchar2,
112 p_file_map out nocopy varchar2,
113 p_emp_num out nocopy varchar2,
114 p_ni_num out nocopy varchar2,
115 p_emp_name out nocopy varchar2,
116 p_pdf_pwd out nocopy varchar2);
117 --
118 function cnv_ni(
119 p_text in varchar2)
120 return varchar2;
121 --
122 function load_validate(
123 p_emp_num in varchar2,
124 p_ni_num in varchar2,
125 p_emp_name in varchar2,
126 p_xml in clob)
127 return number;
128 --
129 function upload_validate(
130 p_xml in clob)
131 return number;
132 --
133 procedure load_xml(
134 p_emp_num in varchar2,
135 p_ni_num in varchar2,
136 p_emp_name in varchar2,
137 p_xml in clob);
138 --
139 function upload_xml(
140 p_xml in clob)
141 return varchar2;
142 --
143 function load_post(
144 p_error_code in varchar2)
145 return number;
146 --
147 procedure upload_post(
148 p_status in varchar2,
149 p_error_code in varchar2);
150 --
151 procedure load_deinit;
152 --
153 procedure map_yea_assignment(
154 p_file_id in number default null);
155 --
156 procedure mass_map_yea_assignment(
157 p_business_group_id in number,
158 p_target_year in number,
159 p_business_place_id in number,
160 p_assignment_set_id in number,
161 p_remove_pdf in varchar2,
162 p_map_key in varchar2,
163 p_force_import in varchar2);
164 --
165 procedure delete_pdf(
166 p_file_id in number,
167 p_with_status in varchar2 default null);
168 --
169 procedure mass_delete_pdf(
170 p_business_group_id in number,
171 p_target_year in number,
172 p_with_status in varchar2 default null);
173 --
174 function submit_yea_pdf_upload (
175 p_bus_grp_id in number,
176 p_year in varchar2,
177 p_bus_plc_id in number,
178 p_asg_id in number)
179 return number;
180 end pay_kr_yea_pdf_pkg;