[Home] [Help]
PACKAGE: APPS.IBY_FD_EXTRACT_GEN_PVT
Source
1 PACKAGE IBY_FD_EXTRACT_GEN_PVT AUTHID CURRENT_USER AS
2 /* $Header: ibyfdxgs.pls 120.32.12010000.6 2009/01/08 20:29:29 pschalla ship $ */
3
4
5 G_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'iby.plsql.IBY_FD_EXTRACT_GEN_PVT';
6
7 -- Various parameters used by the extract-generating XML views
8 --
9
10 -- system security key- for registered instrument decryption
11 --
12 G_VP_SYS_KEY CONSTANT VARCHAR2(30) := 'SYS_KEY';
13
14 -- payment instruction id; for fv instruction level APIs
15 --
16 G_VP_INSTR_ID CONSTANT VARCHAR2(30) := 'PMT_INSTR_ID';
17
18 -- Federal Summary ECS dos Sequence number; for fv ECS summary
19 --
20 G_VP_FV_ECS_SEQ CONSTANT VARCHAR2(30) := 'FV_ECS_SEQ';
21
22 -- Format type
23 --
24 G_VP_FMT_TYPE CONSTANT VARCHAR2(30) := 'FMT_TYPE';
25
26 -- for payment format
27 PROCEDURE Create_Extract_1_0
28 (
29 p_payment_instruction_id IN NUMBER,
30 p_save_extract_flag IN VARCHAR2,
31 p_format_type IN VARCHAR2,
32 p_is_reprint_flag IN VARCHAR2,
33 p_sys_key IN iby_security_pkg.des3_key_type,
34 x_extract_doc OUT NOCOPY CLOB
35 );
36
37 -- directly for aux formats
38 -- indirectly for payment format
39 PROCEDURE Create_Extract_1_0
40 (
41 p_payment_instruction_id IN NUMBER,
42 p_save_extract_flag IN VARCHAR2,
43 p_format_type IN VARCHAR2,
44 p_sys_key IN iby_security_pkg.des3_key_type,
45 x_extract_doc OUT NOCOPY CLOB
46 );
47
48
49 -- for separate remittance advice
50 PROCEDURE Create_Extract_1_0
51 (
52 p_payment_instruction_id IN NUMBER,
53 p_save_extract_flag IN VARCHAR2,
54 p_format_type IN VARCHAR2,
55 p_delivery_method IN VARCHAR2,
56 p_payment_id IN NUMBER,
57 p_sys_key IN iby_security_pkg.des3_key_type,
58 x_extract_doc OUT NOCOPY CLOB
59 );
60
61
62 -- for positive pay - bug 5028143
63 PROCEDURE Create_Pos_Pay_Extract_1_0
64 (
65 p_payment_instruction_id IN NUMBER,
66 p_payment_profile_id IN NUMBER,
67 p_from_date IN VARCHAR2,
68 p_to_date IN VARCHAR2,
69 p_sys_key IN iby_security_pkg.des3_key_type,
70 x_extract_doc OUT NOCOPY CLOB
71 );
72
73 -- for LKQ POS PAY issue
74 PROCEDURE Create_Pos_Pay_Extract_2_0
75 (
76 p_payment_instruction_id IN NUMBER,
77
78 p_format_name IN VARCHAR2,
79 p_internal_bank_account_name IN VARCHAR2,
80 p_from_date IN VARCHAR2,
81 p_to_date IN VARCHAR2,
82 p_payment_status IN VARCHAR2,
83 p_reselect IN VARCHAR2,
84
85 p_sys_key IN iby_security_pkg.des3_key_type,
86 x_extract_doc OUT NOCOPY CLOB
87 );
88
89 PROCEDURE Create_PPR_Extract_1_0
90 (
91 p_payment_service_request_id IN NUMBER,
92 p_sys_key IN iby_security_pkg.des3_key_type,
93 x_extract_doc OUT NOCOPY CLOB
94 );
95
96
97
98 FUNCTION Get_FP_TaxRegistration(p_legal_entity_id IN NUMBER)
99 RETURN VARCHAR2;
100
101 FUNCTION Get_Payee_LegalRegistration(p_vendor_id IN NUMBER,
102 p_vendor_site_id IN NUMBER,
103 p_vendor_site_country IN VARCHAR2)
104 RETURN VARCHAR2;
105
106
107 FUNCTION Get_Payee_TaxRegistration(p_party_id IN NUMBER,
108 p_supplier_site_id IN NUMBER) -- bug# 7412315
109 RETURN VARCHAR2;
110
111
112 FUNCTION Get_PayerContact(p_party_id IN NUMBER)
113 RETURN XMLTYPE;
114
115 FUNCTION Get_PayeeContact(p_payment_id IN NUMBER)
116 RETURN XMLTYPE;
117
118 FUNCTION format_hr_address(p_hr_location_id IN NUMBER,
119 p_style_code IN VARCHAR2 DEFAULT NULL)
120 RETURN VARCHAR2;
121
122
123 FUNCTION format_hz_address(p_hz_location_id IN NUMBER,
124 p_style_code IN VARCHAR2 DEFAULT NULL)
125 RETURN VARCHAR2;
126
127
128 FUNCTION Get_Pmt_DocPayableCount(p_payment_id IN NUMBER)
129 RETURN NUMBER;
130
131 FUNCTION Get_Ins_PayerInstrAgg(p_payment_instruction_id IN NUMBER)
132 RETURN XMLTYPE;
133
134
135 FUNCTION Get_Payer(p_legal_entity_id IN NUMBER)
136 RETURN XMLTYPE;
137
138 FUNCTION Get_PayerBankAccount(p_bank_account_id IN NUMBER)
139 RETURN XMLTYPE;
140
141
142 FUNCTION Get_Payer_Denorm(p_payment_id IN NUMBER)
143 RETURN XMLTYPE;
144
145 FUNCTION Get_PayerBankAccount_Denorm(p_payment_id IN NUMBER)
146 RETURN XMLTYPE;
147
148
149 FUNCTION Get_PayerIns_Denorm(p_payment_instruction_id IN NUMBER)
150 RETURN XMLTYPE;
151
152 FUNCTION Get_PayerBankAccountIns_Denorm(p_payment_instruction_id IN NUMBER)
153 RETURN XMLTYPE;
154
155
156 FUNCTION Get_Ins_FVFieldsAgg(p_payment_instruction_id IN NUMBER)
157 RETURN XMLTYPE;
158
159 FUNCTION Get_Ins_AccountSettingsAgg(p_bep_account_id IN NUMBER)
160 RETURN XMLTYPE;
161
162 FUNCTION Get_Pmt_DocPayableAgg(p_payment_id IN NUMBER)
163 RETURN XMLTYPE;
164
165 FUNCTION Get_Payee(p_payment_id IN NUMBER)
166 RETURN XMLTYPE;
167
168 /* TPP - Start */
169 FUNCTION Get_InvPayee(p_payment_id IN NUMBER)
170 RETURN XMLTYPE;
171
172 FUNCTION get_rel_add_info(
173 payee_party_id IN NUMBER,
174 supplier_site_id IN NUMBER,
175 inv_payee_party_id IN NUMBER,
176 inv_supplier_site_id IN NUMBER)
177 RETURN VARCHAR2;
178
179 FUNCTION get_relship_id(
180 payee_party_id IN NUMBER,
181 supplier_site_id IN NUMBER,
182 inv_payee_party_id IN NUMBER,
183 inv_supplier_site_id IN NUMBER)
184 RETURN NUMBER;
185 /* TPP - End */
186
187 FUNCTION Get_PayeeBankAccount(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
188 RETURN XMLTYPE;
189
190 FUNCTION Get_PayeeBankAccount_Denorm(p_payment_id IN NUMBER, p_external_bank_account_id IN NUMBER)
191 RETURN XMLTYPE;
192
193 FUNCTION Get_Doc_DocLineAgg(p_document_payable_id IN NUMBER)
194 RETURN XMLTYPE;
195
196 FUNCTION Get_SRA_Attribute(p_payment_id IN NUMBER, p_attribute_type IN NUMBER)
197 RETURN VARCHAR2;
198
199 FUNCTION get_FEIN(payment_instruction_id IN NUMBER)
200 RETURN VARCHAR2;
201
202 FUNCTION get_Abbreviated_Agency_Code(payment_instruction_id IN NUMBER)
203 RETURN VARCHAR2;
204
205 FUNCTION get_Allotment_Code(payment_id IN NUMBER)
206 RETURN VARCHAR2;
207
208 FUNCTION TOP_Offset_Eligibility_Flag(payment_id IN NUMBER)
209 RETURN VARCHAR2;
210
211 FUNCTION get_SPS_PMT_TS(payment_id IN NUMBER)
212 RETURN VARCHAR2;
213
214
215 FUNCTION Get_Bordero_Bank_Ref(p_doc_payable_id IN NUMBER)
216 RETURN VARCHAR2;
217
218 FUNCTION Get_Bordero_Int_Amt(p_doc_payable_id IN NUMBER)
219 RETURN Number;
220
221 FUNCTION Get_Bordero_Abatement(p_doc_payable_id IN NUMBER)
222 RETURN Number;
223
224
225 FUNCTION Get_Payment_Amount_Text(payment_id IN NUMBER)
226 RETURN VARCHAR2;
227
228 FUNCTION Get_Payment_Amount_Withheld(payment_id IN NUMBER)
229 RETURN NUMBER;
230
231
232 -- Payment process request extract functions
233 FUNCTION Get_Ppr_PmtAgg(p_payment_service_request_id IN NUMBER)
234 RETURN XMLTYPE;
235
236 FUNCTION Get_Ppr_PmtCount(p_payment_service_request_id IN NUMBER)
237 RETURN NUMBER;
238
239 FUNCTION Get_Ppr_PreBuildDocAgg(p_payment_service_request_id IN NUMBER)
240 RETURN XMLTYPE;
241
242 FUNCTION Get_Ppr_PreBuildDocCount(p_payment_service_request_id IN NUMBER)
243 RETURN NUMBER;
244
245 FUNCTION Get_Pmt_PmtErrAgg(p_payment_id IN NUMBER)
246 RETURN XMLTYPE;
247
248 FUNCTION Get_Doc_DocErrAgg(p_document_payable_id IN NUMBER)
249 RETURN XMLTYPE;
250
251 PROCEDURE Update_Pmt_SRA_Attr_Prt
252 (
253 p_payment_instruction_id IN NUMBER
254 );
255
256 PROCEDURE Update_Pmt_SRA_Attr_Ele
257 (
258 p_payment_id IN NUMBER,
259 p_delivery_method IN VARCHAR2,
260 p_recipient_email IN VARCHAR2,
261 p_recipient_fax IN VARCHAR2
262 );
263
264 PROCEDURE initialize;
265 FUNCTION Get_Hz_Address(p_location_id IN NUMBER)
266 RETURN XMLTYPE;
267
268 FUNCTION Get_Account_Address(p_location_id IN NUMBER, p_country IN VARCHAR2)
269 RETURN XMLTYPE;
270
271 FUNCTION Get_Hr_Address(p_location_id IN NUMBER)
272 RETURN XMLTYPE;
273
274 FUNCTION Get_Ins_TotalAmt(p_payment_instruction_id IN NUMBER)
275 RETURN NUMBER;
276
277 FUNCTION Get_Expense_Rpt_CC_Num(p_document_payable_id IN NUMBER)
278 RETURN VARCHAR2;
279
280 FUNCTION Replace_Special_Characters(p_base_string IN varchar2)
281 RETURN VARCHAR2;
282
283 END IBY_FD_EXTRACT_GEN_PVT;
284
285