1 PACKAGE JL_ZZ_AP_LIBRARY_1_PKG AUTHID CURRENT_USER AS
2 /* $Header: jlzzpl1s.pls 120.7 2005/10/30 02:06:00 appldev ship $ */
3
4 Procedure get_state_valid(vscountry IN Varchar2,
5 vsstate IN Varchar2,
6 row_number IN Number,
7 errcd IN OUT NOCOPY Number);
8
9 Procedure get_context_name(vdesc IN OUT NOCOPY Varchar2,
10 row_number IN Number,
11 errcd IN OUT NOCOPY Number);
12
13 Procedure get_interest_type(vndstid IN Number,
14 inttyp IN OUT NOCOPY Varchar2,
15 row_number IN Number,
16 errcd IN OUT NOCOPY Number);
17
18 Procedure get_interest_penalty_details(vndstid IN Number,
19 pntamt IN OUT NOCOPY Varchar2,
20 intgrd IN OUT NOCOPY Varchar2,
21 intprd IN OUT NOCOPY Varchar2,
22 intamt IN OUT NOCOPY Varchar2,
23 row_number IN Number,
24 errcd IN OUT NOCOPY Number);
25
26 Procedure get_interest_formula(vndstid IN Number,
27 intfml IN OUT NOCOPY Varchar2,
28 row_number IN Number,
29 errcd IN OUT NOCOPY Number);
30
31 Procedure get_penalty_type(vndstid IN Number,
32 pnttyp IN OUT NOCOPY Varchar2,
33 row_number IN Number,
34 errcd IN OUT NOCOPY Number);
35
36 Procedure get_cons_inv_num(invoiceid IN Number,
37 cons_inv_num IN OUT NOCOPY Number,
38 row_number IN Number,
39 errcd IN OUT NOCOPY Number);
40
41 Procedure get_payment_status_flag(invoiceid IN Number,
42 pay_stat IN OUT NOCOPY Varchar2,
43 row_number IN Number,
44 errcd IN OUT NOCOPY Number);
45
46 Procedure get_associated_payment_count(invoiceid IN Number,
47 tot_recs IN OUT NOCOPY Number,
48 row_number IN Number,
49 errcd IN OUT NOCOPY Number);
50
51 Procedure get_podist_ccid(line_locn_id IN Number,
52 ccid IN OUT NOCOPY Number,
53 row_number IN Number,
54 errcd IN OUT NOCOPY Number);
55
56 Procedure get_account_type(ccid IN Number,
57 account_type IN OUT NOCOPY Varchar2,
58 row_number IN Number,
59 errcd IN OUT NOCOPY Number);
60
61 Procedure get_tax_ccid(tax_name IN Varchar2,
62 ccid IN OUT NOCOPY Number,
63 row_number IN Number,
64 errcd IN OUT NOCOPY Number,
65 p_val_date IN Date);
66
67 Procedure get_hr_loc_distccid(locn_id IN Number,
68 ccid IN OUT NOCOPY Number,
69 row_number IN Number,
70 errcd IN OUT NOCOPY Number);
71
72 Procedure get_max_dist_line_num(invoiceid IN Number,
73 max_dist_line_num IN OUT NOCOPY Number,
74 row_number IN Number,
75 errcd IN OUT NOCOPY Number);
76
77 Procedure get_po_dist_id(line_locn_id IN Number,
78 distid IN OUT NOCOPY Number,
79 row_number IN Number,
80 errcd IN OUT NOCOPY Number);
81
82 FUNCTION Get_Inv_Distrib_ID RETURN number;
83
84 PROCEDURE Get_Invoice_Information(P_Invoice_id IN number,
85 p_last_update_date IN OUT NOCOPY Date,
86 p_Last_Updated_By IN OUT NOCOPY number,
87 p_Set_Of_Books_Id IN OUT NOCOPY number,
88 p_Type_1099 IN OUT NOCOPY varchar2,
89 p_Last_Update_Login IN OUT NOCOPY number,
90 p_Creation_Date IN OUT NOCOPY Date,
91 p_Created_By IN OUT NOCOPY number,
92 p_exchange_rate IN OUT NOCOPY Number,
93 p_exchange_rate_type IN OUT NOCOPY Varchar2,
94 p_exchange_date IN OUT NOCOPY Date,
95 p_invoice_amount_limit IN OUT NOCOPY number,
96 p_amount_hold_flag IN OUT NOCOPY varchar2,
97 p_cfo_code IN OUT NOCOPY varchar2
98 );
99
100
101
102 Procedure get_tax_count(invoiceid IN Number,
103 tot_rec IN OUT NOCOPY Number,
104 row_number IN Number,
105 errcd IN OUT NOCOPY Number);
106
107 Procedure get_ship_from(vendsite_id IN Number,
108 shp_frm IN OUT NOCOPY Varchar2,
109 row_number IN Number,
110 errcd IN OUT NOCOPY Number);
111
112 Procedure get_ship_to(locn_id IN Number,
113 shp_to IN OUT NOCOPY Varchar2,
114 row_number IN Number,
115 errcd IN OUT NOCOPY Number);
116
117 Procedure get_ship_to_org_id(inv_org_id IN OUT NOCOPY Number,
118 p_po_line_id IN Number,
119 errcd IN OUT NOCOPY Number);
120
121 Procedure get_tax_rate_diff(cfocd IN Varchar2,
122 tax_flag IN OUT NOCOPY Varchar2,
123 row_number IN Number,
124 errcd IN OUT NOCOPY Number);
125
126 Procedure get_trans_reason_code(polineid IN Number,
127 trans_reason_code IN OUT NOCOPY Varchar2,
128 fiscal_class_code IN OUT NOCOPY Varchar2,
129 row_number IN Number,
130 errcd IN OUT NOCOPY Number);
131
132 Procedure get_inv_org_id(inv_org_id IN OUT NOCOPY Number,
133 row_number IN Number,
134 errcd IN OUT NOCOPY Number);
135
136 Procedure get_Association_Method(asson_method IN OUT NOCOPY Varchar2,
137 row_number IN Number,
138 errcd IN OUT NOCOPY Number);
139
140 Procedure get_tcc_id(tax_reco_flg IN Varchar2,
141 vatcode IN Varchar2,
142 tcc_id IN OUT NOCOPY Number,
143 description IN OUT NOCOPY Varchar2,
144 account_type IN OUT NOCOPY Varchar2,
145 row_number IN Number,
146 errcd IN OUT NOCOPY Number);
147
148 Procedure get_dist_count(invoiceid IN Number,
149 tot_rec IN OUT NOCOPY Number,
150 row_number IN Number,
151 errcd IN OUT NOCOPY Number);
152
153 Procedure get_Tax_Recoverable(cfocd IN Varchar2,
154 tax_recoverable IN OUT NOCOPY Varchar2,
155 row_number IN Number,
156 errcd IN OUT NOCOPY Number);
157
158 Procedure get_payment_schedule_count(invoiceid IN Number,
159 tot_rec IN OUT NOCOPY Number,
160 row_number IN Number,
161 errcd IN OUT NOCOPY Number);
162
163 Procedure get_distribution_count(invoiceid IN Number,
164 tot_rec IN OUT NOCOPY Number,
165 row_number IN Number,
166 errcd IN OUT NOCOPY Number);
167
168 Procedure get_vendor_site_id(invoiceid IN Number,
169 vendsite_id IN OUT NOCOPY Number,
170 row_number IN Number,
171 errcd IN OUT NOCOPY Number);
172
173 Procedure get_tax_calendar_name(vendsite_id IN Number,
174 tax_cal_name IN OUT NOCOPY Varchar2,
175 row_number IN Number,
176 errcd IN OUT NOCOPY Number);
177
178 Procedure get_tax_type(tax_code_id IN Number,
179 tax_type IN OUT NOCOPY Varchar2,
180 row_number IN Number,
181 errcd IN OUT NOCOPY Number);
182
183 Procedure get_base_date(taxcal_name IN Varchar2,
184 taxtype IN Varchar2,
185 basedt IN OUT NOCOPY Varchar2,
186 row_number IN Number,
187 errcd IN OUT NOCOPY Number);
188
189
190 Procedure get_terms_due_date(invoiceid IN Number,
191 taxcal_name IN Varchar2,
192 duedt IN OUT NOCOPY Date,
193 row_number IN Number,
194 errcd IN OUT NOCOPY Number);
195
196 Procedure get_inv_due_date(invoiceid IN Number,
197 taxcal_name IN Varchar2,
198 duedt IN OUT NOCOPY Date,
199 row_number IN Number,
200 errcd IN OUT NOCOPY Number);
201
202 Procedure get_gl_due_date(invoiceid IN Number,
203 taxcal_name IN Varchar2,
204 duedt IN OUT NOCOPY Date,
205 row_number IN Number,
206 errcd IN OUT NOCOPY Number);
207
208 Procedure get_city_frm_sys(vcity IN OUT NOCOPY Varchar2,
209 row_number IN Number,
210 errcd IN OUT NOCOPY Number);
211
212 Procedure get_city_frm_povend(vendsite_id IN Number,
213 vcity IN OUT NOCOPY Varchar2,
214 row_number IN Number,
215 errcd IN OUT NOCOPY Number);
216
217 PROCEDURE get_count_cnab(cnab IN VARCHAR2,
218 curr_code IN VARCHAR2,
219 total_rec IN OUT NOCOPY NUMBER,
220 row_number IN NUMBER,
221 Errcd IN OUT NOCOPY NUMBER);
222
223 PROCEDURE get_old_cnab_code(curr_code IN VARCHAR2,
224 cnab IN OUT NOCOPY VARCHAR2,
225 row_number IN NUMBER,
226 Errcd IN OUT NOCOPY NUMBER);
227
228 PROCEDURE get_tax_code_id(p_tax_name IN Varchar2,
229 p_val_date IN Date,
230 p_tax_id IN OUT NOCOPY Number);
231
232 Procedure get_city_frm_sys(vcity IN OUT NOCOPY Varchar2,
233 row_number IN Number,
234 errcd IN OUT NOCOPY Number,
235 vstate IN OUT NOCOPY Varchar2); --Bug # 2319552
236
237 Procedure get_city_frm_povend(vendsite_id IN Number,
238 vcity IN OUT NOCOPY Varchar2,
239 row_number IN Number,
240 errcd IN OUT NOCOPY Number,
241 vstate IN OUT NOCOPY Varchar2); --Bug # 2319552
242
243 Procedure get_vendor_id(invoiceid IN Number,
244 vendor_id IN OUT NOCOPY Number,
245 row_number IN Number,
246 errcd IN OUT NOCOPY Number);
247
248 --Bug 3740729
249 PROCEDURE upd_inwkb_br_def_ps_segmts_1
250 (v_inttyp IN VARCHAR2,
251 v_intamt IN VARCHAR2,
252 v_intprd IN VARCHAR2,
253 v_intfml IN VARCHAR2,
254 v_intgrd IN VARCHAR2,
255 v_pnttyp IN VARCHAR2,
256 v_pntamt IN VARCHAR2,
257 v_glbattctg IN VARCHAR2,
258 v_invid IN NUMBER,
259 errcd IN OUT NOCOPY NUMBER);
260
261 PROCEDURE upd_inwkb_br_def_ps_segmts_2
262 (v_inttyp IN VARCHAR2,
263 v_intamt IN VARCHAR2,
264 v_intprd IN VARCHAR2,
265 v_intfml IN VARCHAR2,
266 v_intgrd IN VARCHAR2,
267 v_pnttyp IN VARCHAR2,
268 v_pntamt IN VARCHAR2,
269 v_glbattctg IN VARCHAR2,
270 v_invid IN NUMBER,
271 v_pmtno IN NUMBER,
272 errcd IN OUT NOCOPY NUMBER);
273
274 PROCEDURE upd_inwkb_br_upd_due_date1
275 (l_due_date_char IN VARCHAR2,
276 l_invoice_id IN NUMBER,
277 l_payment_num IN NUMBER,
278 errcd IN OUT NOCOPY NUMBER);
279
280 PROCEDURE upd_inwkb_br_upd_due_date2
281 (l_discount_date_char IN VARCHAR2,
282 l_invoice_id IN NUMBER,
283 l_payment_num IN NUMBER,
284 errcd IN OUT NOCOPY NUMBER);
285
286 PROCEDURE upd_inwkb_br_up_wh_due_date1
287 (l_due_date_char IN VARCHAR2,
288 l_new_invoice_id IN NUMBER,
289 errcd IN OUT NOCOPY NUMBER);
290
291 PROCEDURE upd_inwkb_br_val_pay_sched1
292 (l_new_date1 IN DATE,
293 s_invoice_id IN NUMBER,
294 s_payment_num IN NUMBER,
295 errcd IN OUT NOCOPY NUMBER);
296
297 PROCEDURE upd_inwkb_br_val_pay_sched2
298 (l_new_date1 IN DATE,
299 s_invoice_id IN NUMBER,
300 s_payment_num IN NUMBER,
301 errcd IN OUT NOCOPY NUMBER);
302
303 PROCEDURE upd_inwkb_br_val_pay_sched3
304 (s_bank_collection_id IN jl_br_ap_collection_docs.bank_collection_id%Type,
305 s_invoice_id IN NUMBER,
306 s_payment_num IN NUMBER,
307 errcd IN OUT NOCOPY NUMBER);
308
309 END JL_ZZ_AP_LIBRARY_1_PKG;