1 PACKAGE AP_INTEREST_INVOICE_PKG AS
2 /*$Header: apintins.pls 120.12 2005/09/20 20:16:26 rlandows noship $*/
3
4 PROCEDURE ap_create_interest_invoice(
5 P_invoice_id IN NUMBER,
6 P_int_invoice_id IN NUMBER,
7 P_check_id IN NUMBER,
8 P_payment_num IN NUMBER,
9 P_int_invoice_payment_id IN NUMBER,
10 P_old_invoice_payment_id IN NUMBER Default NULL,
11 P_period_name IN VARCHAR2,
12 P_invoice_type IN VARCHAR2 Default NULL,
13 P_accounting_date IN DATE,
14 P_amount IN NUMBER,
15 P_discount_taken IN NUMBER,
16 P_discount_lost IN NUMBER Default NULL,
17 P_invoice_base_amount IN NUMBER Default NULL,
18 P_payment_base_amount IN NUMBER Default NULL,
19 P_vendor_id IN NUMBER,
20 P_vendor_site_id IN NUMBER Default NULL,
21 P_old_invoice_num IN VARCHAR2,
22 P_int_invoice_num IN VARCHAR2,
23 P_interest_amount IN NUMBER,
24 P_payment_method_code IN VARCHAR2 Default NULL, --4552701
25 P_doc_sequence_value IN NUMBER Default NULL,
26 P_doc_sequence_id IN NUMBER Default NULL,
27 P_checkrun_name IN VARCHAR2 Default NULL,
28 P_payment_priority IN VARCHAR2 Default NULL,
29 P_accrual_posted_flag IN VARCHAR2,
30 P_cash_posted_flag IN VARCHAR2,
31 P_posted_flag IN VARCHAR2,
32 P_set_of_books_id IN NUMBER,
33 P_last_updated_by IN NUMBER,
34 P_last_update_login IN NUMBER Default NULL,
35 P_currency_code IN VARCHAR2 Default NULL,
36 P_base_currency_code IN VARCHAR2 Default NULL,
37 P_exchange_rate IN NUMBER Default NULL,
38 P_exchange_rate_type IN VARCHAR2 Default NULL,
39 P_exchange_date IN DATE Default NULL,
40 P_bank_account_id IN NUMBER Default NULL,
41 P_bank_account_num IN VARCHAR2 Default NULL,
42 P_bank_account_type IN VARCHAR2 Default NULL,
43 P_bank_num IN VARCHAR2 Default NULL,
44 P_future_pay_posted_flag IN VARCHAR2 Default NULL,
45 P_exclusive_payment_flag IN VARCHAR2 Default NULL,
46 P_accts_pay_ccid IN NUMBER Default NULL,
47 P_gain_ccid IN NUMBER Default NULL,
48 P_loss_ccid IN NUMBER Default NULL,
49 P_future_pay_ccid IN NUMBER Default NULL,
50 P_asset_ccid IN NUMBER Default NULL,
51 P_payment_dists_flag IN VARCHAR2 Default NULL,
52 P_payment_mode IN VARCHAR2 Default NULL,
53 P_replace_flag IN VARCHAR2 Default NULL,
54 P_invoice_description IN VARCHAR2 Default NULL,
55 P_attribute1 IN VARCHAR2 Default NULL,
56 P_attribute2 IN VARCHAR2 Default NULL,
57 P_attribute3 IN VARCHAR2 Default NULL,
58 P_attribute4 IN VARCHAR2 Default NULL,
59 P_attribute5 IN VARCHAR2 Default NULL,
60 P_attribute6 IN VARCHAR2 Default NULL,
61 P_attribute7 IN VARCHAR2 Default NULL,
62 P_attribute8 IN VARCHAR2 Default NULL,
63 P_attribute9 IN VARCHAR2 Default NULL,
64 P_attribute10 IN VARCHAR2 Default NULL,
65 P_attribute11 IN VARCHAR2 Default NULL,
66 P_attribute12 IN VARCHAR2 Default NULL,
67 P_attribute13 IN VARCHAR2 Default NULL,
68 P_attribute14 IN VARCHAR2 Default NULL,
69 P_attribute15 IN VARCHAR2 Default NULL,
70 P_attribute_category IN VARCHAR2 Default NULL,
71 P_calling_sequence IN VARCHAR2 Default NULL,
72 P_accounting_event_id IN NUMBER Default NULL,
73 P_org_id IN NUMBER Default NULL);
74
75
76 PROCEDURE ap_reverse_Interest_Invoice(
77 P_Check_Id IN NUMBER,
78 P_Invoice_Payment_Id IN NUMBER,
79 P_Check_Date IN DATE,
80 P_Period_Name IN VARCHAR2,
81 P_Last_Updated_By IN NUMBER,
82 P_Calling_Sequence IN VARCHAR2,
83 P_last_update_login IN NUMBER DEFAULT NULL);
84
85 PROCEDURE ap_calculate_interest(
86 P_invoice_id IN NUMBER,
87 P_sys_auto_calc_int_flag IN VARCHAR2,
88 P_auto_calculate_interest_flag IN VARCHAR2,
89 P_check_date IN DATE,
90 P_payment_num IN NUMBER,
91 P_amount_remaining IN NUMBER,
92 P_discount_taken IN NUMBER,
93 P_discount_available IN NUMBER,
94 P_currency_code IN VARCHAR2,
95 P_interest_amount OUT NOCOPY NUMBER,
96 P_due_date OUT NOCOPY DATE,
97 P_interest_invoice_num OUT NOCOPY VARCHAR2,
98 P_payment_amount IN NUMBER,
99 P_calling_sequence IN VARCHAR2);
100
101 PROCEDURE ap_pay_insert_invoice_payments(
102 P_reference_invoice_id IN NUMBER,
103 P_reference_invoice_num IN VARCHAR2,
104 P_reference_nls_int IN VARCHAR2,
105 P_checkrun_name IN VARCHAR2,
106 P_vendor_id IN NUMBER,
107 P_vendor_site_id IN NUMBER,
108 P_vendor_num IN VARCHAR2,
109 P_vendor_name IN VARCHAR2,
110 P_vendor_site_code IN VARCHAR2,
111 P_address_line1 IN VARCHAR2,
112 P_address_line2 IN VARCHAR2,
113 P_address_line3 IN VARCHAR2,
114 P_city IN VARCHAR2,
115 P_state IN VARCHAR2,
116 P_zip IN VARCHAR2,
117 P_voucher_num IN VARCHAR2,
118 P_ap_ccid IN NUMBER,
119 P_payment_priority IN NUMBER,
120 P_province IN VARCHAR2,
121 P_country IN VARCHAR2,
122 P_withholding_status_lookup IN VARCHAR2,
123 P_attention_ar_flag IN VARCHAR2,
124 P_set_of_books_id IN NUMBER,
125 P_invoice_exchange_rate IN NUMBER,
126 P_payment_cross_rate IN NUMBER,
127 P_customer_num IN VARCHAR2,
128 P_payment_num IN NUMBER,
129 P_last_update_date IN DATE,
130 P_last_updated_by IN NUMBER,
131 P_creation_date IN DATE,
132 P_created_by IN NUMBER,
133 P_invoice_date IN DATE,
134 P_invoice_amount IN NUMBER,
135 P_amount_remaining IN NUMBER,
136 P_amount_paid IN NUMBER,
137 P_discount_amount_taken IN NUMBER,
138 P_due_date IN DATE,
139 P_invoice_description IN VARCHAR2,
140 P_discount_amount_remaining IN NUMBER,
141 P_payment_amount IN NUMBER,
142 P_proposed_payment_amount IN NUMBER,
143 P_discount_amount IN NUMBER,
144 P_ok_to_pay_flag IN VARCHAR2,
145 P_always_take_discount_flag IN VARCHAR2,
146 P_amount_modified_flag IN VARCHAR2,
147 P_original_invoice_id IN VARCHAR2,
148 P_bank_account_num IN VARCHAR2,
149 P_bank_account_type IN VARCHAR2,
150 P_bank_num IN VARCHAR2,
151 P_original_payment_num IN NUMBER,
152 P_sequence_num IN NUMBER,
153 P_pay_selected_check_id IN NUMBER,
154 P_calling_sequence IN VARCHAR2,
155 P_org_id IN NUMBER DEFAULT NULL,
156 P_last_update_login IN NUMBER DEFAULT NULL);
157
158 PROCEDURE ap_create_batch_interest_dists(
159 P_checkrun_name IN VARCHAR2,
160 P_base_currency_code IN VARCHAR2,
161 P_interest_accts_pay_ccid IN NUMBER,
162 P_last_updated_by IN NUMBER,
163 P_period_name IN VARCHAR2,
164 P_asset_account_flag IN VARCHAR2,
165 P_calling_sequence IN VARCHAR2,
166 p_checkrun_id in number,
167 p_completed_pmts_group_id in number,
168 p_org_id in number);
169
170 END AP_INTEREST_INVOICE_PKG;