PACKAGE: APPS.OE_CAT_RESULTS_PUB

Source

1 PACKAGE OE_CAT_RESULTS_PUB AS
2 /* $Header: OEXCATRS.pls 120.0 2005/06/01 00:43:50 appldev noship $ */
3 
4 PROCEDURE Check_Availability (
5 p_calling_module IN VARCHAR2,
6 p_inventory_item_id IN NUMBER,
7 p_organization_id IN NUMBER,
8 p_customer_id IN NUMBER,
9 p_customer_site_id IN NUMBER,
10 p_uom IN VARCHAR2,
11 p_pricelist_id IN VARCHAR2,
12 p_input_quantity IN NUMBER ,
13 p_need_by_date IN VARCHAR2,
14 p_vendor_item_number IN VARCHAR2,
15 p_currency_code IN VARCHAR2,
16 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
17 x_pocall_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
18 x_available_qty OUT NOCOPY /* file.sql.39 change */ NUMBER,
19 x_available_date OUT NOCOPY /* file.sql.39 change */ DATE,
20 x_customer_price OUT NOCOPY /* file.sql.39 change */ NUMBER,
21 x_list_price OUT NOCOPY /* file.sql.39 change */ NUMBER,
22 x_pricing_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 );
24 
25 
26 PROCEDURE Get_Availability (
27 p_inventory_item_id IN NUMBER ,
28 p_input_quantity IN NUMBER,
29 p_organization_id IN NUMBER,
30 p_customer_id IN NUMBER,
31 p_customer_site_id IN NUMBER,
32 p_uom IN VARCHAR2,
33 p_need_by_date IN VARCHAR2
34 );
35 
36 END OE_CAT_RESULTS_PUB ;