1 PACKAGE IBY_FD_POST_PICP_PROGS_PVT AUTHID CURRENT_USER AS
2 /* $Header: ibyppics.pls 120.22 2006/09/22 02:01:34 frzhang noship $ */
3
4 -- module name used for the application debugging framework
5 --
6 G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_FD_POST_PICP_PROGS_PVT';
7
8 -- --------------------------------------------------------------------------
9 -- API to Process Federal Summary Format
10 -- --------------------------------------------------------------------------
11 -- The following procedure will be called by Federal code to initiate
12 -- the extract, formatting and delivery of Federal summary formats.
13 --
14 -- Dependencies:
15 -- This API has the following pre-reqs:
16 -- 1. The summary format control number must be stored in the FV_SUMMARY_CONSOLIDATE
17 -- table. The API will lookup the control number by the payment instruction ID.
18 -- 2. The treasury symbol and amounts data must be stored in the
19 -- FV_TP_TS_AMT_DATA table. The API will retrieve the data with the payment
20 -- instruction ID during payment extract.
21 -- 3. The setup must be correct. The input format code for the summary format
22 -- must be a valid format defined in IBY. The summary file will be saved to
23 -- the file system (and) transmitted according to the same settings as the
24 -- original bulk payment file.
25 --
26 -- Parameters:
27 -- Besides the standard FND parameters, the procedure has the parameters:
28 -- Input:
29 -- p_payment_instruction_id: This is the PK of the payment instruction
30 -- for the original bulk data payment file.
31 --
32 -- p_ecs_dos_seq_num: ECS summary format requires a periodic
33 -- sequence as part of the dos file name field.
34 -- This number is generated by a FV sequence
35 -- and passed to IBY via this parameter. IBY
36 -- will use this number for generating the
37 -- ECS dos file name during the formatting.
38 --
39 -- p_summary_format_code: The PK in IBY_FORMATS_B table for the
40 -- summary format.
41 -- Output:
42 -- x_request_id: The concurrent request ID for the
43 -- extract, formatting and delivery of the
44 -- summary file.
45 -- Current version : 1.0
46 -- Previous version: 1.0
47 -- Initial version : 1.0
48 -- Created: 04/06/2005
49 -- Created by: frzhang
50 -- --------------------------------------------------------------------------
51 PROCEDURE Process_Federal_Summary_Format
52 (
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55 p_commit IN VARCHAR2 := FND_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_payment_instruction_id IN NUMBER,
60 p_ecs_dos_seq_num IN NUMBER,
61 p_summary_format_code IN VARCHAR2,
62 x_request_id OUT NOCOPY NUMBER
63 );
64
65
66 -- This is the main interface from the payment instruction
67 -- creation program (PICP) to the post PI programs.
68 -- This procedure will perform extract, formatting, printing
69 -- and transmission for the payment format of a
70 -- payment instruction.
71 --
72 PROCEDURE Run_Post_PI_Programs
73 (
74 p_payment_instruction_id IN NUMBER,
75 p_is_reprint_flag IN VARCHAR2
76 );
77
78
79 -- Update transaction statuses and raise business events after
80 -- successful completion of the post PICP programs.
81 --
82 PROCEDURE Post_Results
83 (
84 p_payment_instruction_id IN NUMBER,
85 p_newStatus IN VARCHAR2,
86 p_is_reprint_flag IN VARCHAR2,
87 x_return_status OUT NOCOPY VARCHAR2
88 );
89
90
91 PROCEDURE Insert_Transmission_Error
92 (
93 p_payment_instruction_id IN NUMBER,
94 p_error_code IN VARCHAR2,
95 p_error_msg IN VARCHAR2
96 );
97
98 PROCEDURE save_last_periodic_seq_nums
99 (
100 p_payment_instruction_id IN NUMBER,
101 p_seq_name1 IN VARCHAR2,
102 p_last_val1 IN VARCHAR2,
103 p_seq_name2 IN VARCHAR2,
104 p_last_val2 IN VARCHAR2,
105 p_seq_name3 IN VARCHAR2,
106 p_last_val3 IN VARCHAR2
107 );
108
109 PROCEDURE set_sra_created
110 (
111 p_payment_instruction_id IN NUMBER
112 );
113
114
115 PROCEDURE set_pos_pay_created
116 (
117 p_payment_instruction_id IN NUMBER
118 );
119
120 PROCEDURE set_reg_rpt_created
121 (
122 p_payment_instruction_id IN NUMBER
123 );
124
125
126 PROCEDURE post_fv_summary_format_status
127 (
128 p_payment_instruction_id IN NUMBER,
129 p_process_status IN VARCHAR2
130 );
131
132
133 FUNCTION get_instruction_format
134 (
135 p_payment_instruction_id IN NUMBER,
136 p_format_type IN VARCHAR2
137 ) RETURN VARCHAR2;
138
139
140 FUNCTION get_allow_multiple_sra_flag
141 (
142 p_payment_instruction_id IN NUMBER
143 ) RETURN VARCHAR2;
144
145
146 FUNCTION val_instruction_accessible
147 (
148 p_payment_instruction_id IN NUMBER
149 ) RETURN VARCHAR2;
150
151 FUNCTION val_pmt_reg_instr_accessible
152 (
153 p_payment_instruction_id IN NUMBER
154 ) RETURN VARCHAR2;
155
156 FUNCTION val_ppr_st_rpt_accessible
157 (
158 p_payment_service_request_id IN NUMBER
159 ) RETURN VARCHAR2;
160
161 FUNCTION check_ppr_moac_blocking
162 (
163 p_payment_service_request_id IN NUMBER
164 ) RETURN VARCHAR2;
165
166
167 PROCEDURE Reset_Periodic_Sequence_Value
168 (
169 x_errbuf OUT NOCOPY VARCHAR2,
170 x_retcode OUT NOCOPY VARCHAR2,
171 p_payment_profile_id IN NUMBER,
172 p_sequence_number IN NUMBER,
173 p_reset_value IN NUMBER,
174 p_arg2 IN VARCHAR2 DEFAULT NULL, p_arg3 IN VARCHAR2 DEFAULT NULL,
175 p_arg4 IN VARCHAR2 DEFAULT NULL,p_arg5 IN VARCHAR2 DEFAULT NULL,
176 p_arg6 IN VARCHAR2 DEFAULT NULL, p_arg7 IN VARCHAR2 DEFAULT NULL,
177 p_arg8 IN VARCHAR2 DEFAULT NULL, p_arg9 IN VARCHAR2 DEFAULT NULL,
178 p_arg10 IN VARCHAR2 DEFAULT NULL, p_arg11 IN VARCHAR2 DEFAULT NULL,
179 p_arg12 IN VARCHAR2 DEFAULT NULL, p_arg13 IN VARCHAR2 DEFAULT NULL,
180 p_arg14 IN VARCHAR2 DEFAULT NULL, p_arg15 IN VARCHAR2 DEFAULT NULL,
181 p_arg16 IN VARCHAR2 DEFAULT NULL, p_arg17 IN VARCHAR2 DEFAULT NULL,
182 p_arg18 IN VARCHAR2 DEFAULT NULL, p_arg19 IN VARCHAR2 DEFAULT NULL,
183 p_arg20 IN VARCHAR2 DEFAULT NULL, p_arg21 IN VARCHAR2 DEFAULT NULL,
184 p_arg22 IN VARCHAR2 DEFAULT NULL, p_arg23 IN VARCHAR2 DEFAULT NULL,
185 p_arg24 IN VARCHAR2 DEFAULT NULL, p_arg25 IN VARCHAR2 DEFAULT NULL,
186 p_arg26 IN VARCHAR2 DEFAULT NULL, p_arg27 IN VARCHAR2 DEFAULT NULL,
187 p_arg28 IN VARCHAR2 DEFAULT NULL, p_arg29 IN VARCHAR2 DEFAULT NULL,
188 p_arg30 IN VARCHAR2 DEFAULT NULL, p_arg31 IN VARCHAR2 DEFAULT NULL,
189 p_arg32 IN VARCHAR2 DEFAULT NULL, p_arg33 IN VARCHAR2 DEFAULT NULL,
190 p_arg34 IN VARCHAR2 DEFAULT NULL, p_arg35 IN VARCHAR2 DEFAULT NULL,
191 p_arg36 IN VARCHAR2 DEFAULT NULL, p_arg37 IN VARCHAR2 DEFAULT NULL,
192 p_arg38 IN VARCHAR2 DEFAULT NULL, p_arg39 IN VARCHAR2 DEFAULT NULL,
193 p_arg40 IN VARCHAR2 DEFAULT NULL, p_arg41 IN VARCHAR2 DEFAULT NULL,
194 p_arg42 IN VARCHAR2 DEFAULT NULL, p_arg43 IN VARCHAR2 DEFAULT NULL,
195 p_arg44 IN VARCHAR2 DEFAULT NULL, p_arg45 IN VARCHAR2 DEFAULT NULL,
196 p_arg46 IN VARCHAR2 DEFAULT NULL, p_arg47 IN VARCHAR2 DEFAULT NULL,
197 p_arg48 IN VARCHAR2 DEFAULT NULL, p_arg49 IN VARCHAR2 DEFAULT NULL,
198 p_arg50 IN VARCHAR2 DEFAULT NULL, p_arg51 IN VARCHAR2 DEFAULT NULL,
199 p_arg52 IN VARCHAR2 DEFAULT NULL, p_arg53 IN VARCHAR2 DEFAULT NULL,
200 p_arg54 IN VARCHAR2 DEFAULT NULL, p_arg55 IN VARCHAR2 DEFAULT NULL,
201 p_arg56 IN VARCHAR2 DEFAULT NULL, p_arg57 IN VARCHAR2 DEFAULT NULL,
202 p_arg58 IN VARCHAR2 DEFAULT NULL, p_arg59 IN VARCHAR2 DEFAULT NULL,
203 p_arg60 IN VARCHAR2 DEFAULT NULL, p_arg61 IN VARCHAR2 DEFAULT NULL,
204 p_arg62 IN VARCHAR2 DEFAULT NULL, p_arg63 IN VARCHAR2 DEFAULT NULL,
205 p_arg64 IN VARCHAR2 DEFAULT NULL, p_arg65 IN VARCHAR2 DEFAULT NULL,
206 p_arg66 IN VARCHAR2 DEFAULT NULL, p_arg67 IN VARCHAR2 DEFAULT NULL,
207 p_arg68 IN VARCHAR2 DEFAULT NULL, p_arg69 IN VARCHAR2 DEFAULT NULL,
208 p_arg70 IN VARCHAR2 DEFAULT NULL, p_arg71 IN VARCHAR2 DEFAULT NULL,
209 p_arg72 IN VARCHAR2 DEFAULT NULL, p_arg73 IN VARCHAR2 DEFAULT NULL,
210 p_arg74 IN VARCHAR2 DEFAULT NULL, p_arg75 IN VARCHAR2 DEFAULT NULL,
211 p_arg76 IN VARCHAR2 DEFAULT NULL, p_arg77 IN VARCHAR2 DEFAULT NULL,
212 p_arg78 IN VARCHAR2 DEFAULT NULL, p_arg79 IN VARCHAR2 DEFAULT NULL,
213 p_arg80 IN VARCHAR2 DEFAULT NULL, p_arg81 IN VARCHAR2 DEFAULT NULL,
214 p_arg82 IN VARCHAR2 DEFAULT NULL, p_arg83 IN VARCHAR2 DEFAULT NULL,
215 p_arg84 IN VARCHAR2 DEFAULT NULL, p_arg85 IN VARCHAR2 DEFAULT NULL,
216 p_arg86 IN VARCHAR2 DEFAULT NULL, p_arg87 IN VARCHAR2 DEFAULT NULL,
217 p_arg88 IN VARCHAR2 DEFAULT NULL, p_arg89 IN VARCHAR2 DEFAULT NULL,
218 p_arg90 IN VARCHAR2 DEFAULT NULL, p_arg91 IN VARCHAR2 DEFAULT NULL,
219 p_arg92 IN VARCHAR2 DEFAULT NULL, p_arg93 IN VARCHAR2 DEFAULT NULL,
220 p_arg94 IN VARCHAR2 DEFAULT NULL, p_arg95 IN VARCHAR2 DEFAULT NULL,
221 p_arg96 IN VARCHAR2 DEFAULT NULL, p_arg97 IN VARCHAR2 DEFAULT NULL,
222 p_arg98 IN VARCHAR2 DEFAULT NULL, p_arg99 IN VARCHAR2 DEFAULT NULL,
223 p_arg100 IN VARCHAR2 DEFAULT NULL
224 );
225
226
227 FUNCTION submit_schedule
228 (
229 p_payment_profile_id IN NUMBER,
230 p_sequence_number IN NUMBER,
231 p_reset_value IN NUMBER
232 ) RETURN NUMBER;
233
234
235 PROCEDURE Test_CP
236 (
237 p_payment_instruction_id IN NUMBER,
238 p_program_short_name IN VARCHAR2
239 );
240
241 PROCEDURE submit_acp_ltr
242 (
243 p_payment_instruction_id IN NUMBER
244 );
245
246
247 PROCEDURE Run_ECE_Formatting
248 (
249 p_payment_instruction_id IN NUMBER
250 );
251
252
253 END IBY_FD_POST_PICP_PROGS_PVT;