1 PACKAGE AP_RECURRING_INVOICES_PKG AUTHID CURRENT_USER AS
2 /*$Header: aprecins.pls 120.12 2010/12/20 12:24:23 sbonala ship $*/
3
4 PROCEDURE ap_create_recurring_invoices(
5 P_batch_name IN VARCHAR2 DEFAULT NULL,
6 P_last_update_date IN DATE,
7 P_last_updated_by IN NUMBER,
8 P_invoice_currency_code IN VARCHAR2,
9 P_payment_currency_code IN VARCHAR2,
10 P_invoice_num IN VARCHAR2,
11 P_invoice_amount IN OUT NOCOPY NUMBER,
12 P_vendor_id IN NUMBER,
13 P_vendor_site_id IN NUMBER Default NULL,
14 P_invoice_date IN DATE Default NULL,
15 P_description IN VARCHAR2 DEFAULT NULL,
16 P_terms_id IN NUMBER Default NULL,
17 P_pay_group_lookup_code IN VARCHAR2 DEFAULT NULL,
18 P_set_of_books_id IN NUMBER,
19 P_accts_pay_ccid IN NUMBER Default NULL,
20 P_payment_cross_rate IN NUMBER,
21 P_exchange_date IN DATE Default NULL,
22 P_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
23 P_exchange_rate IN NUMBER Default NULL,
24 P_invoice_base_amount IN NUMBER Default NULL,
25 P_base_currency_code IN VARCHAR2 DEFAULT NULL,
26 P_recurring_payment_id IN NUMBER Default NULL,
27 P_doc_sequence_id IN NUMBER Default NULL,
28 P_doc_sequence_value IN NUMBER Default NULL,
29 P_doc_category_code IN VARCHAR2 DEFAULT NULL,
30 P_exclusive_payment_flag IN VARCHAR2 DEFAULT NULL,
31 P_awt_group_id IN NUMBER Default NULL,
32 P_pay_awt_group_id IN NUMBER Default NULL,--bug6639866
33 P_distribution_set_id IN NUMBER Default NULL,
34 P_accounting_date IN DATE,
35 P_po_shipment_id IN NUMBER Default NULL,
36 P_batch_control_flag IN VARCHAR2 DEFAULT NULL,
37 P_multi_currency_flag IN VARCHAR2 Default NULL,
38 P_po_match_flag IN VARCHAR2 Default NULL,
39 -- Removed for bug 4277744
40 -- P_ussgl_txn_code IN VARCHAR2 Default NULL,
41 P_attribute1 IN VARCHAR2 DEFAULT NULL,
42 P_attribute2 IN VARCHAR2 DEFAULT NULL,
43 P_attribute3 IN VARCHAR2 Default NULL,
44 P_attribute4 IN VARCHAR2 DEFAULT NULL,
45 P_attribute5 IN VARCHAR2 DEFAULT NULL,
46 P_attribute6 IN VARCHAR2 DEFAULT NULL,
47 P_attribute7 IN VARCHAR2 DEFAULT NULL,
48 P_attribute8 IN VARCHAR2 DEFAULT NULL,
49 P_attribute9 IN VARCHAR2 DEFAULT NULL,
50 P_attribute10 IN VARCHAR2 DEFAULT NULL,
51 P_attribute11 IN VARCHAR2 DEFAULT NULL,
52 P_attribute12 IN VARCHAR2 DEFAULT NULL,
53 P_attribute13 IN VARCHAR2 DEFAULT NULL,
54 P_attribute14 IN VARCHAR2 DEFAULT NULL,
55 P_attribute15 IN VARCHAR2 DEFAULT NULL,
56 P_attribute_category IN VARCHAR2 DEFAULT NULL,
57 P_calling_sequence IN VARCHAR2 DEFAULT NULL,
58 P_invoice_id OUT NOCOPY NUMBER,
59 P_Org_Id IN NUMBER Default mo_global.get_current_org_id,
60 P_Requester_Id IN NUMBER Default NULL,
61 P_Po_Release_Id IN NUMBER DEFAULT NULL,
62 P_Item_Description IN VARCHAR2 DEFAULT NULL,
63 P_Manufacturer IN VARCHAR2 DEFAULT NULL,
67 P_User_Defined_Fisc_Class IN VARCHAR2 DEFAULT NULL,
64 P_Model_Number IN VARCHAR2 DEFAULT NULL,
65 P_Tax_Control_Amount IN NUMBER DEFAULT NULL,
66 P_Trx_Business_Category IN VARCHAR2 DEFAULT NULL,
68 P_Taxation_Country IN VARCHAR2 DEFAULT NULL,
69 P_Primary_Intended_Use IN VARCHAR2 DEFAULT NULL,
70 P_Product_Fisc_Classification IN VARCHAR2 DEFAULT NULL,
71 P_Tax_Amount IN NUMBER DEFAULT NULL,
72 P_Tax_Amt_Exclusive IN VARCHAR2 DEFAULT NULL,
73 P_Legal_Entity_Id IN NUMBER DEFAULT NULL,
74 p_PAYMENT_METHOD_CODE in varchar2 default null,
75 p_PAYMENT_REASON_CODE in varchar2 default null,
76 p_remittance_message1 in varchar2 default null,
77 p_remittance_message2 in varchar2 default null,
78 p_remittance_message3 in varchar2 default null,
79 p_bank_charge_bearer in varchar2 default null,
80 p_settlement_priority in varchar2 default null,
81 p_payment_reason_comments in varchar2 default null,
82 p_delivery_channel_code in varchar2 default null,
83 p_external_bank_account_id in number default null,
84 p_party_id in number default null,
85 p_party_site_id in number default null,
86 /* bug 4931755. Exclude Tax From Discount */
87 p_disc_is_inv_less_tax_flag in varchar2 default null,
88 p_exclude_freight_from_disc in varchar2 default null,
89 p_tax_classification_code in varchar2 default null,
90 P_REMIT_TO_SUPPLIER_NAME VARCHAR2 DEFAULT NULL,
91 P_REMIT_TO_SUPPLIER_ID NUMBER DEFAULT NULL,
92 P_REMIT_TO_SUPPLIER_SITE VARCHAR2 DEFAULT NULL,
93 P_REMIT_TO_SUPPLIER_SITE_ID NUMBER DEFAULT NULL,
94 P_RELATIONSHIP_ID NUMBER DEFAULT NULL,
95 P_PRODUCT_TYPE VARCHAR2 DEFAULT NULL, --Bug#8640313
96 P_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL); --Bug#8640313
97
98 PROCEDURE ap_get_next_period(
99 P_period_type IN VARCHAR2,
100 P_current_period_name IN VARCHAR2,
101 P_next_period_name OUT NOCOPY VARCHAR2,
102 P_next_period_num OUT NOCOPY NUMBER,
103 P_next_period_year OUT NOCOPY NUMBER,
104 P_calling_sequence IN VARCHAR2);
105
106 PROCEDURE ap_get_next_payment(
107 P_next_period_name IN VARCHAR2,
108 P_special_period_name1 IN VARCHAR2,
109 P_special_payment_amount1 IN NUMBER,
110 P_special_period_name2 IN VARCHAR2,
114 P_current_amount IN NUMBER,
111 P_special_payment_amount2 IN NUMBER,
112 P_increment_percent IN NUMBER,
113 P_currency_code IN VARCHAR2,
115 P_next_amount OUT NOCOPY NUMBER,
116 P_next_amount_exclude_special OUT NOCOPY NUMBER,
117 P_calling_sequence IN VARCHAR2);
118
119 PROCEDURE ap_get_first_amount(
120 P_first_period_name IN VARCHAR2,
121 P_special_period_name1 IN VARCHAR2,
122 P_special_payment_amount1 IN NUMBER,
123 P_special_period_name2 IN VARCHAR2,
124 P_special_payment_amount2 IN NUMBER,
125 P_number_of_regular_periods IN NUMBER,
126 P_amount_source_flag IN VARCHAR2,
127 P_increment_percent IN NUMBER,
128 P_currency_code IN VARCHAR2,
129 P_first_amount IN OUT NOCOPY NUMBER,
130 P_control_total IN OUT NOCOPY NUMBER,
131 P_calling_sequence IN VARCHAR2);
132
133
134 END AP_RECURRING_INVOICES_PKG;