1 PACKAGE AP_PAYMENT_PUBLIC_PKG AUTHID CURRENT_USER AS
2 /* $Header: appaypks.pls 120.0.12010000.3 2009/03/20 04:16:29 njakkula ship $ */
3
4 TYPE Invoice_Payment_Info_Rec IS RECORD
5 (
6 Invoice_ID NUMBER(15),
7 Payment_Schedule_Num NUMBER,
8 Amount_To_Pay NUMBER,
9 Discount_Taken NUMBER);
10
11 TYPE Invoice_Payment_Info_Tab IS TABLE OF
12 AP_PAYMENT_PUBLIC_PKG.Invoice_Payment_Info_Rec
13 INDEX BY BINARY_INTEGER;
14
15 PROCEDURE Create_Netting_Payment(
16 P_Check_Rec IN
17 AP_CHECKS_ALL%ROWTYPE,
18 P_Invoice_Payment_Info_Tab IN
19 AP_PAYMENT_PUBLIC_PKG.Invoice_Payment_Info_Tab,
20 P_Check_ID OUT NOCOPY NUMBER,
21 P_Curr_Calling_Sequence IN VARCHAR2,
22 p_gl_date IN DATE DEFAULT NULL/* p_gl_date Added for bug#7663371 */);
23
24 PROCEDURE Create_Netting_Inv_Payment
25 (P_Invoice_Payment_Info_Tab IN
26 AP_PAYMENT_PUBLIC_PKG.Invoice_Payment_Info_Tab,
27 P_check_id IN NUMBER,
28 P_payment_type_flag IN VARCHAR2,
29 P_payment_method IN VARCHAR2,
30 P_ce_bank_acct_use_id IN NUMBER,
31 P_bank_account_num IN VARCHAR2,
32 P_bank_account_type IN VARCHAR2,
33 P_bank_num IN VARCHAR2,
34 P_check_date IN DATE,
35 P_period_name IN VARCHAR2,
36 P_currency_code IN VARCHAR2,
37 P_base_currency_code IN VARCHAR2,
38 P_checkrun_id IN NUMBER,
39 P_exchange_rate IN NUMBER,
40 P_exchange_rate_type IN VARCHAR2,
41 P_exchange_date IN DATE,
42 P_set_of_books_id IN NUMBER,
43 P_last_updated_by IN NUMBER,
44 P_last_update_login IN NUMBER,
45 P_accounting_event_id IN NUMBER,
46 P_org_id IN NUMBER,
47 P_calling_sequence IN VARCHAR2
48 );
49
50 FUNCTION Get_Disc_For_Pmt_Schedule
51 (p_invoice_id IN NUMBER,
52 p_payment_num IN NUMBER,
53 p_date IN DATE)
54 RETURN NUMBER;
55
56 FUNCTION Get_Disc_For_Netted_Amt
57 (p_invoice_id IN NUMBER,
58 p_payment_num IN NUMBER,
59 p_date IN DATE,
60 P_Netted_Amt IN NUMBER)
61 RETURN NUMBER;
62
63 END AP_PAYMENT_PUBLIC_PKG;