[Home] [Help]
PACKAGE: APPS.PAY_ORG_PAYMENT_METHODS_PKG
Source
1 PACKAGE pay_org_payment_methods_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyopm01t.pkh 120.3 2005/09/30 12:40:27 adkumar noship $ */
3 procedure insert_row(
4 p_row_id in out nocopy varchar2,
5 p_org_payment_method_id in out nocopy number,
6 p_effective_start_date date,
7 p_effective_end_date date,
8 p_business_group_id number,
9 p_external_account_id number,
10 p_currency_code varchar2,
11 p_payment_type_id number,
12 p_defined_balance_id number,
13 p_org_payment_method_name varchar2,
14 p_base_opm_name varchar2,
15 p_comment_id number,
16 p_attribute_category varchar2,
17 p_attribute1 varchar2,
18 p_attribute2 varchar2,
19 p_attribute3 varchar2,
20 p_attribute4 varchar2,
21 p_attribute5 varchar2,
22 p_attribute6 varchar2,
23 p_attribute7 varchar2,
24 p_attribute8 varchar2,
25 p_attribute9 varchar2,
26 p_attribute10 varchar2,
27 p_attribute11 varchar2,
28 p_attribute12 varchar2,
29 p_attribute13 varchar2,
30 p_attribute14 varchar2,
31 p_attribute15 varchar2,
32 p_attribute16 varchar2,
33 p_attribute17 varchar2,
34 p_attribute18 varchar2,
35 p_attribute19 varchar2,
36 p_attribute20 varchar2,
37 p_pmeth_information_category varchar2,
38 p_pmeth_information1 varchar2,
39 p_pmeth_information2 varchar2,
40 p_pmeth_information3 varchar2,
41 p_pmeth_information4 varchar2,
42 p_pmeth_information5 varchar2,
43 p_pmeth_information6 varchar2,
44 p_pmeth_information7 varchar2,
45 p_pmeth_information8 varchar2,
46 p_pmeth_information9 varchar2,
47 p_pmeth_information10 varchar2,
48 p_pmeth_information11 varchar2,
49 p_pmeth_information12 varchar2,
50 p_pmeth_information13 varchar2,
51 p_pmeth_information14 varchar2,
52 p_pmeth_information15 varchar2,
53 p_pmeth_information16 varchar2,
54 p_pmeth_information17 varchar2,
55 p_pmeth_information18 varchar2,
56 p_pmeth_information19 varchar2,
57 p_pmeth_information20 varchar2,
58 p_asset_code_combination_id number,
59 p_set_of_books_id number,
60 p_transfer_to_gl_flag varchar2,
61 p_cost_payment varchar2,
62 p_cost_cleared_payment varchar2,
63 p_cost_cleared_void_payment varchar2,
64 p_exclude_manual_payment varchar2,
65 p_gl_set_of_books_id number,
66 p_gl_cash_ac_id number,
67 p_gl_cash_clearing_ac_id number,
68 p_gl_control_ac_id number,
69 p_gl_error_ac_id number,
70 p_default_gl_account varchar2,
71 p_bank_account_id number,
72 p_pay_gl_account_id_out out nocopy number
73 );
74 --------------------------------------------------------------------------------
75 PROCEDURE set_translation_globals(p_business_group_id IN NUMBER,
76 p_validation_start_date IN DATE,
77 p_validation_end_date IN DATE);
78 -----------------------------------------------------------------------------
79 procedure validate_translation (org_payment_method_id IN number,
80 language IN varchar2,
81 org_payment_method_name IN varchar2);
82 -----------------------------------------------------------------------------
83 --
84 -- Standard delete procedure
85 --
86 procedure delete_row(p_org_payment_method_id NUMBER,
87 p_row_id varchar2,
88 p_dt_delete_mode varchar2,
89 p_effective_date date,
90 p_org_effective_start_date date,
91 p_org_effective_end_date date );
92 -----------------------------------------------------------------------------
93 --
94 -- Standard lock procedure
95 --
96 procedure lock_row(
97 p_row_id varchar2,
98 p_org_payment_method_id number,
99 p_effective_start_date date,
100 p_effective_end_date date,
101 p_business_group_id number,
102 p_external_account_id number,
103 p_currency_code varchar2,
104 p_payment_type_id number,
105 p_defined_balance_id number,
106 p_base_opm_name varchar2,
107 p_comment_id number,
108 p_attribute_category varchar2,
109 p_attribute1 varchar2,
110 p_attribute2 varchar2,
111 p_attribute3 varchar2,
112 p_attribute4 varchar2,
113 p_attribute5 varchar2,
114 p_attribute6 varchar2,
115 p_attribute7 varchar2,
116 p_attribute8 varchar2,
117 p_attribute9 varchar2,
118 p_attribute10 varchar2,
119 p_attribute11 varchar2,
120 p_attribute12 varchar2,
121 p_attribute13 varchar2,
122 p_attribute14 varchar2,
123 p_attribute15 varchar2,
124 p_attribute16 varchar2,
125 p_attribute17 varchar2,
126 p_attribute18 varchar2,
127 p_attribute19 varchar2,
128 p_attribute20 varchar2,
129 p_pmeth_information_category varchar2,
130 p_pmeth_information1 varchar2,
131 p_pmeth_information2 varchar2,
132 p_pmeth_information3 varchar2,
133 p_pmeth_information4 varchar2,
134 p_pmeth_information5 varchar2,
135 p_pmeth_information6 varchar2,
136 p_pmeth_information7 varchar2,
137 p_pmeth_information8 varchar2,
138 p_pmeth_information9 varchar2,
139 p_pmeth_information10 varchar2,
140 p_pmeth_information11 varchar2,
141 p_pmeth_information12 varchar2,
142 p_pmeth_information13 varchar2,
143 p_pmeth_information14 varchar2,
144 p_pmeth_information15 varchar2,
145 p_pmeth_information16 varchar2,
146 p_pmeth_information17 varchar2,
147 p_pmeth_information18 varchar2,
148 p_pmeth_information19 varchar2,
149 p_pmeth_information20 varchar2,
150 p_transfer_to_gl_flag varchar2,
151 p_cost_payment varchar2,
152 p_cost_cleared_payment varchar2,
153 p_cost_cleared_void_payment varchar2,
154 p_exclude_manual_payment varchar2,
155 p_pay_gl_account_id number,
156 p_set_of_books_id number,
157 p_gl_cash_ac_id number,
158 p_gl_cash_clearing_ac_id number,
159 p_gl_control_ac_id number,
160 p_gl_error_ac_id number
161 );
162 --
163 -----------------------------------------------------------------------------
164 --
165 -- Standard update procedure
166 --
167 procedure update_row(
168 p_row_id varchar2,
169 p_org_payment_method_id number,
170 p_effective_start_date date,
171 p_effective_end_date date,
172 p_business_group_id number,
173 p_external_account_id number,
174 p_currency_code varchar2,
175 p_payment_type_id number,
176 p_defined_balance_id number,
177 p_org_payment_method_name varchar2,
178 p_comment_id number,
179 p_attribute_category varchar2,
180 p_attribute1 varchar2,
181 p_attribute2 varchar2,
182 p_attribute3 varchar2,
183 p_attribute4 varchar2,
184 p_attribute5 varchar2,
185 p_attribute6 varchar2,
186 p_attribute7 varchar2,
187 p_attribute8 varchar2,
188 p_attribute9 varchar2,
189 p_attribute10 varchar2,
190 p_attribute11 varchar2,
191 p_attribute12 varchar2,
192 p_attribute13 varchar2,
193 p_attribute14 varchar2,
194 p_attribute15 varchar2,
195 p_attribute16 varchar2,
196 p_attribute17 varchar2,
197 p_attribute18 varchar2,
198 p_attribute19 varchar2,
199 p_attribute20 varchar2,
200 p_pmeth_information_category varchar2,
201 p_pmeth_information1 varchar2,
202 p_pmeth_information2 varchar2,
203 p_pmeth_information3 varchar2,
204 p_pmeth_information4 varchar2,
205 p_pmeth_information5 varchar2,
206 p_pmeth_information6 varchar2,
207 p_pmeth_information7 varchar2,
208 p_pmeth_information8 varchar2,
209 p_pmeth_information9 varchar2,
210 p_pmeth_information10 varchar2,
211 p_pmeth_information11 varchar2,
212 p_pmeth_information12 varchar2,
213 p_pmeth_information13 varchar2,
214 p_pmeth_information14 varchar2,
215 p_pmeth_information15 varchar2,
216 p_pmeth_information16 varchar2,
217 p_pmeth_information17 varchar2,
218 p_pmeth_information18 varchar2,
219 p_pmeth_information19 varchar2,
220 p_pmeth_information20 varchar2,
221 p_asset_code_combination_id number,
222 p_set_of_books_id number,
223 p_dt_update_mode varchar2,
224 p_base_opm_name varchar2,
225 p_transfer_to_gl_flag varchar2,
226 p_cost_payment varchar2,
227 p_cost_cleared_payment varchar2,
228 p_cost_cleared_void_payment varchar2,
229 p_exclude_manual_payment varchar2,
230 p_gl_set_of_books_id number,
231 p_gl_cash_ac_id number,
232 p_gl_cash_clearing_ac_id number,
233 p_gl_control_ac_id number,
234 p_gl_error_ac_id number,
235 p_default_gl_account varchar2,
236 p_bank_account_id number,
237 p_pay_gl_account_id_out out nocopy number
238 );
239 --
240 procedure check_end_date(p_end_date varchar2,
241 p_opm_id number);
242
243 function chk_dflt_prpy_ppm(opm_id varchar2,
244 val_start_date varchar2) return boolean;
245
246 function payee_type(p_payee_type varchar2,
247 p_payee_id number,
248 p_effective_date date) return varchar2;
249
250 ----------------------------------------------------------------
251 procedure ADD_LANGUAGE;
252 ----------------------------------------------------------------
253 procedure TRANSLATE_ROW (
254 X_O_ORG_PAYMENT_METHOD_NAME in varchar2,
255 X_O_EFFECTIVE_START_DATE in date,
256 X_O_EFFECTIVE_END_DATE in date,
257 X_ORG_PAYMENT_METHOD_NAME in varchar2,
258 X_OWNER in varchar2
259 );
260 ----------------------------------------------------------------
261 procedure lock_aba_row(
262 p_external_account_id in number,
263 p_set_of_books_id in number,
264 p_asset_code_combination_id in number
265 );
266 ----------------------------------------------------------------
267 END pay_org_payment_methods_pkg;