PACKAGE: APPS.AP_WEB_PAYMENTS_PKG

Source

1 PACKAGE AP_WEB_PAYMENTS_PKG AS
2 /* $Header: apwxpays.pls 120.4 2006/09/22 12:49:26 nammishr noship $ */
3     FUNCTION get_paid_by_list(l_invoice_id IN NUMBER,
4                               l_payment_num IN NUMBER) RETURN VARCHAR2;
5     FUNCTION get_total_payments_made(l_invoice_id IN NUMBER)
6     						RETURN VARCHAR2;
7     FUNCTION get_checkid(l_invoice_id IN NUMBER)
8     						RETURN NUMBER;
9     FUNCTION get_last_payment_date(l_invoice_id IN NUMBER)
10     						RETURN DATE;
11     PRAGMA RESTRICT_REFERENCES(get_paid_by_list, WNDS);
12     FUNCTION get_prepay_amount_remaining(P_invoice_id IN number,
13                                      p_Invoice_num IN VARCHAR2,
14                                      p_employee_id IN NUMBER,
15                                      p_currency IN VARCHAR2,
16                                      P_header_id IN NUMBER DEFAULT NULL,
17                                      p_resp_id IN NUMBER DEFAULT NULL,
18                                      p_apps_id NUMBER DEFAULT NULL)
19        				 RETURN NUMBER;
20 
21     FUNCTION get_prepay_balance(P_invoice_id IN number,
22                                 p_Invoice_num IN VARCHAR2,
23                                 p_employee_id IN NUMBER,
24                                 p_currency IN VARCHAR2)
25 			       RETURN number;
26 
27     FUNCTION get_line_prepay_balance(P_invoice_id IN number,
28                                  line_id IN NUMBER)
29 		       RETURN number;
30 
31 END AP_WEB_PAYMENTS_PKG;