1 PACKAGE AP_PAY_INVOICE_PKG AUTHID CURRENT_USER AS
2 /*$Header: apayinvs.pls 120.7 2005/04/15 01:42:03 yicao noship $*/
3
4 PROCEDURE ap_pay_invoice(
5 P_invoice_id IN NUMBER,
6 P_check_id IN NUMBER,
7 P_payment_num IN NUMBER,
8 P_invoice_payment_id IN NUMBER,
9 P_old_invoice_payment_id IN NUMBER Default NULL,
10 P_period_name IN VARCHAR2,
11 P_invoice_type IN VARCHAR2 Default NULL,
12 P_accounting_date IN DATE,
13 P_amount IN NUMBER,
14 P_discount_taken IN NUMBER,
15 P_discount_lost IN NUMBER Default NULL,
16 P_invoice_base_amount IN NUMBER Default NULL,
17 P_payment_base_amount IN NUMBER Default NULL,
18 P_accrual_posted_flag IN VARCHAR2,
19 P_cash_posted_flag IN VARCHAR2,
20 P_posted_flag IN VARCHAR2,
21 P_set_of_books_id IN NUMBER,
22 P_last_updated_by IN NUMBER,
23 P_last_update_login IN NUMBER Default NULL,
24 P_currency_code IN VARCHAR2 Default NULL,
25 P_base_currency_code IN VARCHAR2 Default NULL,
26 P_exchange_rate IN NUMBER Default NULL,
27 P_exchange_rate_type IN VARCHAR2 Default NULL,
28 P_exchange_date IN DATE Default NULL,
29 P_ce_bank_acct_use_id IN NUMBER Default NULL,
30 P_bank_account_num IN VARCHAR2 Default NULL,
31 P_bank_account_type IN VARCHAR2 Default NULL,
32 P_bank_num IN VARCHAR2 Default NULL,
33 P_future_pay_posted_flag IN VARCHAR2 Default NULL,
34 P_exclusive_payment_flag IN VARCHAR2 Default NULL,
35 P_accts_pay_ccid IN NUMBER Default NULL,
36 P_gain_ccid IN NUMBER Default NULL,
37 P_loss_ccid IN NUMBER Default NULL,
38 P_future_pay_ccid IN NUMBER Default NULL,
39 P_asset_ccid IN NUMBER Default NULL,
40 P_payment_dists_flag IN VARCHAR2 Default NULL,
41 P_payment_mode IN VARCHAR2 Default NULL,
42 P_replace_flag IN VARCHAR2 Default NULL,
43 P_attribute1 IN VARCHAR2 Default NULL,
44 P_attribute2 IN VARCHAR2 Default NULL,
45 P_attribute3 IN VARCHAR2 Default NULL,
46 P_attribute4 IN VARCHAR2 Default NULL,
47 P_attribute5 IN VARCHAR2 Default NULL,
48 P_attribute6 IN VARCHAR2 Default NULL,
49 P_attribute7 IN VARCHAR2 Default NULL,
50 P_attribute8 IN VARCHAR2 Default NULL,
51 P_attribute9 IN VARCHAR2 Default NULL,
52 P_attribute10 IN VARCHAR2 Default NULL,
53 P_attribute11 IN VARCHAR2 Default NULL,
54 P_attribute12 IN VARCHAR2 Default NULL,
55 P_attribute13 IN VARCHAR2 Default NULL,
56 P_attribute14 IN VARCHAR2 Default NULL,
57 P_attribute15 IN VARCHAR2 Default NULL,
58 P_attribute_category IN VARCHAR2 Default NULL,
59 P_global_attribute1 IN VARCHAR2 Default NULL,
60 P_global_attribute2 IN VARCHAR2 Default NULL,
61 P_global_attribute3 IN VARCHAR2 Default NULL,
62 P_global_attribute4 IN VARCHAR2 Default NULL,
63 P_global_attribute5 IN VARCHAR2 Default NULL,
64 P_global_attribute6 IN VARCHAR2 Default NULL,
65 P_global_attribute7 IN VARCHAR2 Default NULL,
66 P_global_attribute8 IN VARCHAR2 Default NULL,
67 P_global_attribute9 IN VARCHAR2 Default NULL,
68 P_global_attribute10 IN VARCHAR2 Default NULL,
69 P_global_attribute11 IN VARCHAR2 Default NULL,
70 P_global_attribute12 IN VARCHAR2 Default NULL,
71 P_global_attribute13 IN VARCHAR2 Default NULL,
72 P_global_attribute14 IN VARCHAR2 Default NULL,
73 P_global_attribute15 IN VARCHAR2 Default NULL,
74 P_global_attribute16 IN VARCHAR2 Default NULL,
75 P_global_attribute17 IN VARCHAR2 Default NULL,
76 P_global_attribute18 IN VARCHAR2 Default NULL,
77 P_global_attribute19 IN VARCHAR2 Default NULL,
78 P_global_attribute20 IN VARCHAR2 Default NULL,
79 P_global_attribute_category IN VARCHAR2 Default NULL,
80 P_calling_sequence IN VARCHAR2 Default NULL,
81 P_accounting_event_id IN NUMBER Default NULL,
82 P_org_id IN NUMBER Default NULL);
83
84
85 PROCEDURE ap_pay_insert_invoice_payments(
86 P_invoice_id IN NUMBER,
87 P_check_id IN NUMBER,
88 P_payment_num IN NUMBER,
89 P_invoice_payment_id IN NUMBER,
90 P_old_invoice_payment_id IN NUMBER,
91 P_period_name IN VARCHAR2,
92 P_accounting_date IN DATE,
93 P_amount IN NUMBER,
94 P_discount_taken IN NUMBER,
95 P_discount_lost IN NUMBER,
96 P_invoice_base_amount IN NUMBER,
97 P_payment_base_amount IN NUMBER,
98 P_accrual_posted_flag IN VARCHAR2,
99 P_cash_posted_flag IN VARCHAR2,
100 P_posted_flag IN VARCHAR2,
101 P_set_of_books_id IN NUMBER,
102 P_last_updated_by IN NUMBER,
103 P_last_update_login IN NUMBER,
104 P_last_update_date IN DATE,
105 P_currency_code IN VARCHAR2,
106 P_base_currency_code IN VARCHAR2,
107 P_exchange_rate IN NUMBER,
108 P_exchange_rate_type IN VARCHAR2,
109 P_exchange_date IN DATE,
110 P_ce_bank_acct_use_id IN NUMBER,
111 P_bank_account_num IN VARCHAR2,
112 P_bank_account_type IN VARCHAR2,
113 P_bank_num IN VARCHAR2,
114 P_future_pay_posted_flag IN VARCHAR2,
115 P_exclusive_payment_flag IN VARCHAR2,
116 P_accts_pay_ccid IN NUMBER,
117 P_gain_ccid IN NUMBER,
118 P_loss_ccid IN NUMBER,
119 P_future_pay_ccid IN NUMBER,
120 P_asset_ccid IN NUMBER,
121 P_payment_dists_flag IN VARCHAR2,
122 P_payment_mode IN VARCHAR2,
123 P_replace_flag IN VARCHAR2,
124 P_attribute1 IN VARCHAR2,
125 P_attribute2 IN VARCHAR2,
126 P_attribute3 IN VARCHAR2,
127 P_attribute4 IN VARCHAR2,
128 P_attribute5 IN VARCHAR2,
129 P_attribute6 IN VARCHAR2,
130 P_attribute7 IN VARCHAR2,
131 P_attribute8 IN VARCHAR2,
132 P_attribute9 IN VARCHAR2,
133 P_attribute10 IN VARCHAR2,
134 P_attribute11 IN VARCHAR2,
135 P_attribute12 IN VARCHAR2,
136 P_attribute13 IN VARCHAR2,
137 P_attribute14 IN VARCHAR2,
138 P_attribute15 IN VARCHAR2,
139 P_attribute_category IN VARCHAR2,
140 P_global_attribute1 IN VARCHAR2 Default NULL,
141 P_global_attribute2 IN VARCHAR2 Default NULL,
142 P_global_attribute3 IN VARCHAR2 Default NULL,
143 P_global_attribute4 IN VARCHAR2 Default NULL,
144 P_global_attribute5 IN VARCHAR2 Default NULL,
145 P_global_attribute6 IN VARCHAR2 Default NULL,
146 P_global_attribute7 IN VARCHAR2 Default NULL,
147 P_global_attribute8 IN VARCHAR2 Default NULL,
148 P_global_attribute9 IN VARCHAR2 Default NULL,
149 P_global_attribute10 IN VARCHAR2 Default NULL,
150 P_global_attribute11 IN VARCHAR2 Default NULL,
151 P_global_attribute12 IN VARCHAR2 Default NULL,
152 P_global_attribute13 IN VARCHAR2 Default NULL,
153 P_global_attribute14 IN VARCHAR2 Default NULL,
154 P_global_attribute15 IN VARCHAR2 Default NULL,
155 P_global_attribute16 IN VARCHAR2 Default NULL,
156 P_global_attribute17 IN VARCHAR2 Default NULL,
157 P_global_attribute18 IN VARCHAR2 Default NULL,
158 P_global_attribute19 IN VARCHAR2 Default NULL,
159 P_global_attribute20 IN VARCHAR2 Default NULL,
160 P_global_attribute_category IN VARCHAR2 Default NULL,
161 P_calling_sequence IN VARCHAR2,
162 P_accounting_event_id IN NUMBER Default NULL,
163 P_org_id IN NUMBER Default NULL);
164
165 PROCEDURE ap_pay_update_ap_invoices(
166 P_invoice_id IN NUMBER,
167 P_check_id IN NUMBER,
168 P_amount IN NUMBER,
169 P_discount_taken IN NUMBER,
170 P_payment_dists_flag IN VARCHAR2,
171 P_payment_mode IN VARCHAR2,
172 P_replace_flag IN VARCHAR2,
173 P_last_update_date IN DATE,
174 P_last_updated_by IN NUMBER,
175 P_calling_sequence IN VARCHAR2);
176
177
178 PROCEDURE ap_pay_update_payment_schedule(
179 P_invoice_id IN NUMBER,
180 P_payment_num IN NUMBER,
181 P_check_id IN NUMBER,
182 P_amount IN NUMBER,
183 P_discount_taken IN NUMBER,
184 P_payment_dists_flag IN VARCHAR2,
185 P_payment_mode IN VARCHAR2,
186 P_replace_flag IN VARCHAR2,
187 P_last_updated_by IN NUMBER,
188 P_last_update_date IN DATE,
189 P_calling_sequence IN VARCHAR2);
190
191 FUNCTION ap_pay_update_check_amount(x_check_id IN NUMBER) RETURN NUMBER;
192
193 PROCEDURE ap_inv_pay_update_invoices (
194 P_org_invoice_pay_id IN NUMBER,
195 P_invoice_id IN NUMBER,
196 P_payment_line_number IN NUMBER,
197 P_last_update_date IN DATE,
198 P_last_updated_by IN NUMBER,
199 P_calling_sequence IN VARCHAR2);
200
201 END AP_PAY_INVOICE_PKG;