1 PACKAGE GMF_AP_GET_INVOICE_PRICE AUTHID CURRENT_USER AS
2 /* $Header: gmfinvps.pls 115.3 2002/12/04 17:04:28 umoogala ship $ */
3 PROCEDURE proc_ap_get_invoice_price (
4 start_date in date,
5 end_date in date,
6 invoicenum in out nocopy varchar2,
7 invoice_line_no in out nocopy number,
8 invoiceid in out nocopy number,
9 vendor_id in out nocopy number,
10 invoice_type in out nocopy varchar2,
11 previous_invoice_num out nocopy varchar2,
12 invoice_status in out nocopy varchar2,
13 po_header_id in out nocopy number,
14 po_line_id in out nocopy number,
15 po_line_location_id in out nocopy number,
16 line_type in out nocopy varchar2,
17 item_no out nocopy varchar2,
18 item_desc out nocopy varchar2,
19 invoice_qty out nocopy number,
20 invoice_uom out nocopy varchar2,
21 invoice_amount out nocopy number,
22 invoice_base_amount out nocopy number,
23 base_unit_price out nocopy number,
24 unit_price out nocopy number,
25 billing_currency out nocopy varchar2,
26 base_currency out nocopy varchar2,
27 exchange_rate out nocopy number,
28 invoice_date out nocopy date,
29 gl_date out nocopy date,
30 creation_date out nocopy date,
31 created_by out nocopy number,
32 last_update_date out nocopy date,
33 last_updated_by out nocopy number,
34 t_cancelled_date in out nocopy date,
35 t_match_status_flag in out nocopy varchar2,
36 t_hold_count in out nocopy number,
37 approval out nocopy varchar2,
38 statuscode out nocopy number,
39 rowtofetch in out nocopy number);
40 END GMF_AP_GET_INVOICE_PRICE;