[Home] [Help]
PACKAGE: APPS.IBY_SINGPAY_PUB
Source
1 PACKAGE IBY_SINGPAY_PUB AUTHID CURRENT_USER AS
2 /*$Header: ibypsins.pls 120.4.12010000.2 2008/08/22 15:28:33 vkarlapu ship $*/
3
4 --
5 -- This record stores all the document fields that are used in
6 -- as criteria for grouping a document into a payment. Each
7 -- of these fields will result in a grouping rule.
8 --
9 -- Some of the fields of this record are not used specifically
10 -- for grouping, but for raising business events etc.
11 -- e.g., the calling app pay req id
12 --
13 -- Some of the grouping criteria are user defined; these are
14 -- specified in the IBY_PMT_CREATION_RULES table. This record
15 -- contains placeholder for the user defined grouping fields
16 -- as well.
17 --
18 TYPE paymentGroupCriteriaType IS RECORD (
19 calling_app_payreq_cd
20 IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
21 document_id
22 IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
23 calling_app_id
24 IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
25 calling_app_doc_id1
26 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
27 calling_app_doc_id2
28 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
29 calling_app_doc_id3
30 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
31 calling_app_doc_id4
32 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
33 calling_app_doc_id5
34 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
35 pay_proc_ttype_cd
36 IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
37 payment_grp_num
38 IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
39 payment_method_cd
40 IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
41 int_bank_acct_id
42 IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
43 ext_bank_acct_id
44 IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
45 payment_profile_id
46 IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
47 org_id
48 IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
49 org_type
50 IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
51 le_id
52 IBY_DOCS_PAYABLE_ALL.legal_entity_id%TYPE,
53 payment_function
54 IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
55 ext_payee_id
56 IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
57 payee_party_id
58 IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
59 payee_party_site_id
60 IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
61 supplier_site_id
62 IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
63 amount_withheld
64 IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE,
65
66 bank_inst1_code
67 IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
68 bank_inst2_code
69 IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
70 pmt_txt_msg1
71 IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
72 pmt_txt_msg2
73 IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
74 pmt_txt_msg3
75 IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
76
77 payment_currency
78 IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
79 payment_amount
80 IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
81 payment_date
82 IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
83 pay_alone_flag
84 IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,
85
86 pmt_due_date
87 IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
88 discount_date
89 IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
90
91 processing_type
92 IBY_PAYMENT_PROFILES.processing_type%TYPE,
93 decl_option
94 IBY_PAYMENT_PROFILES.declaration_option%TYPE,
95 decl_only_fx_flag
96 IBY_PAYMENT_PROFILES.dcl_only_foreign_curr_pmt_flag%TYPE,
97 decl_curr_fx_rate_type
98 IBY_PAYMENT_PROFILES.declaration_curr_fx_rate_type%TYPE,
99 decl_curr_code
100 IBY_PAYMENT_PROFILES.declaration_currency_code%TYPE,
101 decl_threshold_amount
102 IBY_PAYMENT_PROFILES.declaration_threshold_amount%TYPE,
103 support_prom_notes_flag
104 IBY_PAYMENT_METHODS_VL.support_bills_payable_flag%TYPE
105 );
106
107 --
108 -- Table of payment grouping criteria.
109 --
110 TYPE paymentGroupCriteriaTabType IS TABLE OF paymentGroupCriteriaType
111 INDEX BY BINARY_INTEGER;
112
113 /*--------------------------------------------------------------------
114 | NAME:
115 | createPayments
116 |
117 | PURPOSE:
118 |
119 |
120 |
121 | PARAMETERS:
122 | IN
123 |
124 |
125 | OUT
126 |
127 |
128 | RETURNS:
129 |
130 | NOTES:
131 |
132 *---------------------------------------------------------------------*/
133 PROCEDURE createPayments(
134 p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
135 payment_service_request_id%TYPE,
136 p_pmt_rejection_level IN IBY_INTERNAL_PAYERS_ALL.
137 payment_rejection_level_code%TYPE,
138 p_review_proposed_pmts_flag IN IBY_INTERNAL_PAYERS_ALL.
139 require_prop_pmts_review_flag%TYPE,
140 p_override_complete_point IN VARCHAR2,
141 p_bill_payable_flag IN VARCHAR2,
142 p_maturity_date IN DATE,
143 x_return_status IN OUT NOCOPY VARCHAR2
144 );
145
146 /*--------------------------------------------------------------------
147 | NAME:
148 | performDBUpdates
149 |
150 | PURPOSE:
151 | This is the top level method that is called by the
152 | payment creation program to:
153 | 1. insert payments to DB
154 | 2. update documents with payment id
155 | 3. update status of payment request
156 |
157 | This method will read the 'rejection level' system option
158 | and do updates accordingly.
159 |
160 | PARAMETERS:
161 | IN
162 |
163 |
164 | OUT
165 |
166 |
167 | RETURNS:
168 |
169 | NOTES:
170 |
171 *---------------------------------------------------------------------*/
172 PROCEDURE performDBUpdates(
173 p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
174 payment_service_request_id%type,
175 p_rej_level IN VARCHAR2,
176 p_review_pmts_flag IN VARCHAR2,
177 p_override_compl_pt IN VARCHAR2,
178 x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
179 x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
180 x_allPmtsSuccessFlag IN OUT NOCOPY BOOLEAN,
181 x_allPmtsFailedFlag IN OUT NOCOPY BOOLEAN,
182 x_return_status IN OUT NOCOPY VARCHAR2,
183 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
184 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
185 trxnErrTokenTabType
186 );
187
188 /*--------------------------------------------------------------------
189 | NAME:
190 | initializePmts
191 |
192 | PURPOSE:
193 |
194 |
195 | PARAMETERS:
196 | IN
197 |
198 |
199 | OUT
200 |
201 |
202 | RETURNS:
203 |
204 | NOTES:
205 |
206 *---------------------------------------------------------------------*/
207 PROCEDURE initializePmts(
208 x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType
209 );
210
211 /*--------------------------------------------------------------------
212 | NAME:
213 | negativePmtAmountCheck
214 |
215 | PURPOSE: Validation to check that payment amount is not a negative
216 |value
217 |
218 | PARAMETERS:
219 | IN
220 |
221 |
222 | OUT
223 |
224 |
225 | RETURNS:
226 |
227 | NOTES: Added for the bug 7344352
228 |
229 *---------------------------------------------------------------------*/
230 PROCEDURE negativePmtAmountCheck(
231 x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
232 x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
233 x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
234 x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
235 );
236
237 /*--------------------------------------------------------------------
238 | NAME:
239 | print_debuginfo
240 |
241 | PURPOSE:
242 | This procedure prints the debug message to the concurrent manager
243 | log file.
244 |
245 | PARAMETERS:
246 | IN
247 | p_debug_text - The debug message to be printed
248 |
249 | OUT
250 |
251 |
252 | RETURNS:
253 |
254 | NOTES:
255 |
256 *---------------------------------------------------------------------*/
257 PROCEDURE print_debuginfo(p_module IN VARCHAR2,
258 p_debug_text IN VARCHAR2);
259
260
261 END IBY_SINGPAY_PUB;