1 PACKAGE OE_PUR_CONC_REQUESTS AS
2 /* $Header: OEXCDSPS.pls 120.1.12010000.1 2008/07/25 07:46:13 appldev ship $ */
3
4
5 -- Results for Workflow
6 --Bug2295434 Changed the data type of date parameters to VARCHAR2 type.
7 Procedure Request
8 (ERRBUF OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
9 RETCODE OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
10 /* Moac */
11 p_org_id IN NUMBER,
12 p_order_number_low IN NUMBER,
13 p_order_number_high IN NUMBER,
14 p_request_date_low IN VARCHAR2,
15 p_request_date_high IN VARCHAR2,
16 p_customer_po_number IN VARCHAR2,
17 p_ship_to_location IN VARCHAR2,
18 p_order_type IN VARCHAR2,
19 p_customer IN VARCHAR2,
20 p_item IN VARCHAR2
21 );
22
23 END OE_PUR_CONC_REQUESTS;