1 PACKAGE AP_PAY_IN_FULL_PKG AUTHID CURRENT_USER AS
2 /* $Header: apayfuls.pls 120.7.12010000.4 2009/01/20 05:02:36 sbonala ship $ */
3
4 --Modified below procedure parameter types for bug #7721348
5 PROCEDURE AP_Lock_Invoices(
6 P_invoice_id_list IN VARCHAR2,
7 P_payment_num_list IN VARCHAR2,
8 P_currency_code OUT NOCOPY VARCHAR2,
9 P_payment_method OUT NOCOPY AP_PAYMENT_SCHEDULES.PAYMENT_METHOD_CODE%TYPE, --VARCHAR2,
10 P_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE, --NUMBER,
11 P_vendor_site_id OUT NOCOPY AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE, --NUMBER,
12 P_party_id OUT NOCOPY AP_SUPPLIERS.PARTY_ID%TYPE, --NUMBER,
13 P_party_site_id OUT NOCOPY AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE, --NUMBER,
14 P_org_id OUT NOCOPY NUMBER,
15 P_payment_function OUT NOCOPY AP_INVOICES.PAYMENT_FUNCTION%TYPE, --VARCHAR2, -- 4965233
16 P_proc_trxn_type OUT NOCOPY AP_INVOICES.PAY_PROC_TRXN_TYPE_CODE%TYPE, --VARCHAR2, -- 4965233
17 P_num_payments OUT NOCOPY NUMBER,
18 P_le_id OUT NOCOPY NUMBER, -- 5617689
19 --Added below variables for the bug 7662240
20 P_remit_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE, --NUMBER,
21 P_remit_vendor_site_id OUT NOCOPY AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE, --NUMBER,
22 P_remit_party_id OUT NOCOPY AP_SUPPLIERS.PARTY_ID%TYPE, --NUMBER,
23 P_remit_party_site_id OUT NOCOPY AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE, --NUMBER,
24 P_remit_vendor_name OUT NOCOPY AP_SUPPLIERS.VENDOR_NAME%TYPE, --VARCHAR2,
25 P_remit_vendor_site_name OUT NOCOPY AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE, --VARCHAR2,
26 P_calling_sequence IN VARCHAR2,
27 --Added below parameter for 7688200
28 p_relationship_id OUT NOCOPY NUMBER);
29
30 FUNCTION AP_Discount_Available(P_invoice_id_list IN VARCHAR2,
31 P_payment_num_list IN VARCHAR2,
32 P_check_date IN DATE,
33 P_currency_code IN VARCHAR2,
34 P_calling_sequence IN VARCHAR2)
35 RETURN BOOLEAN;
36
37 FUNCTION AP_Get_Check_Amount(P_invoice_id_list IN VARCHAR2,
38 P_payment_num_list IN VARCHAR2,
39 P_payment_type_flag IN VARCHAR2,
40 P_check_date IN DATE,
41 P_currency_code IN VARCHAR2,
42 P_take_discount IN VARCHAR2,
43 P_sys_auto_calc_int_flag IN VARCHAR2,
44 P_auto_calc_int_flag IN VARCHAR2,
45 P_calling_sequence IN VARCHAR2)
46 RETURN NUMBER;
47
48 PROCEDURE AP_Create_Payments(P_invoice_id_list IN VARCHAR2,
49 P_payment_num_list IN VARCHAR2,
50 P_check_id IN NUMBER,
51 P_payment_type_flag IN VARCHAR2,
52 P_payment_method IN VARCHAR2,
53 P_ce_bank_acct_use_id IN NUMBER,
54 P_bank_account_num IN VARCHAR2,
55 P_bank_account_type IN VARCHAR2,
56 P_bank_num IN VARCHAR2,
57 P_check_date IN DATE,
58 P_period_name IN VARCHAR2,
59 P_currency_code IN VARCHAR2,
60 P_base_currency_code IN VARCHAR2,
61 P_checkrun_name IN VARCHAR2,
62 P_doc_sequence_value IN NUMBER,
63 P_doc_sequence_id IN NUMBER,
64 P_exchange_rate IN NUMBER,
65 P_exchange_rate_type IN VARCHAR2,
66 P_exchange_date IN DATE,
67 P_take_discount IN VARCHAR2,
68 P_sys_auto_calc_int_flag IN VARCHAR2,
69 P_auto_calc_int_flag IN VARCHAR2,
70 P_set_of_books_id IN NUMBER,
71 P_future_pay_ccid IN NUMBER,
72 P_last_updated_by IN NUMBER,
73 P_last_update_login IN NUMBER,
74 P_calling_sequence IN VARCHAR2,
75 P_sequential_numbering IN VARCHAR2 DEFAULT 'N', --1724353
76 P_accounting_event_id IN NUMBER, --Events
77 P_org_id IN NUMBER);
78 END AP_PAY_IN_FULL_PKG;