PACKAGE: APPS.POS_AP_INVOICES_PKG

Source

1 PACKAGE POS_AP_INVOICES_PKG AS
2 /* $Header: POSAPINS.pls 120.6 2006/09/28 00:25:48 abtrived noship $ */
3 
4     FUNCTION get_po_number_list(l_invoice_id IN NUMBER) RETURN VARCHAR2;
5 
6     FUNCTION get_packing_slip_list(l_invoice_id IN NUMBER,
7 			p_invoice_num IN VARCHAR2) RETURN VARCHAR2;
8 
9     FUNCTION get_retainage_for_invoice(l_invoice_id IN NUMBER) RETURN NUMBER;
10 
11     FUNCTION get_prepay_for_invoice(l_invoice_id IN NUMBER) RETURN NUMBER;
12 
13     FUNCTION get_total_for_invoice(l_invoice_id IN NUMBER) RETURN NUMBER;
14 
15     FUNCTION get_tax_for_invoice(l_invoice_id IN NUMBER) RETURN NUMBER;
16 
17     FUNCTION get_packing_slip(l_invoice_id IN NUMBER,
18     			p_invoice_num IN VARCHAR2) RETURN VARCHAR2;
19 
20     FUNCTION get_payment_list(l_invoice_id IN NUMBER,
21                               l_payment_num IN NUMBER) RETURN VARCHAR2;
22 
23     PROCEDURE get_on_hold_info(l_invoice_id IN NUMBER,
24                                     p_hold_status OUT NOCOPY VARCHAR2,
25                                     p_hold_reason OUT NOCOPY VARCHAR2);
26 
27     FUNCTION get_due_date(l_invoice_id IN NUMBER) RETURN VARCHAR2;
28 
29     PROCEDURE get_po_info(l_invoice_id IN NUMBER,
30     				p_po_switch OUT NOCOPY VARCHAR2,
31      				p_po_num OUT NOCOPY VARCHAR2,
32      				p_header_id OUT NOCOPY VARCHAR2,
33      				p_release_id OUT NOCOPY VARCHAR2);
34 
35     PROCEDURE get_receipt_info(l_invoice_id IN NUMBER,
36     				p_receipt_switch OUT NOCOPY VARCHAR2,
37     				p_receipt_num OUT NOCOPY VARCHAR2,
38     				p_receipt_shipment_header_id OUT NOCOPY VARCHAR2);
39 
40     /*deprecated - should be replaced by method with same name and which passes p_payment_method also*/
41     PROCEDURE get_payment_info(l_invoice_id IN NUMBER,
42        				p_payment_switch OUT NOCOPY VARCHAR2,
43     				p_payment_num OUT NOCOPY VARCHAR2,
44     				p_payment_id OUT NOCOPY VARCHAR2,
45  				p_payment_date OUT NOCOPY VARCHAR2
46  				);
47 
48     PROCEDURE get_payment_info(l_invoice_id IN NUMBER,
49      				p_payment_switch OUT NOCOPY VARCHAR2,
50   				p_payment_num OUT NOCOPY VARCHAR2,
51   				p_payment_id OUT NOCOPY VARCHAR2,
52   				p_payment_date OUT NOCOPY VARCHAR2,
53   				p_payment_method OUT NOCOPY VARCHAR2
54   				);
55 
56     FUNCTION get_amount_withheld(l_invoice_id IN NUMBER) RETURN NUMBER;
57 
58     FUNCTION get_on_hold_status(l_invoice_id IN NUMBER) RETURN VARCHAR2;
59 
60     PRAGMA RESTRICT_REFERENCES(get_amount_withheld, WNDS, WNPS, RNPS);
61 
62 END POS_AP_INVOICES_PKG;