[Home] [Help]
PACKAGE: APPS.IBE_ATP_PVT
Source
1 PACKAGE IBE_ATP_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVATPS.pls 115.9 2003/08/29 09:08:57 nsultan ship $ */
3
4 TYPE ATP_Line_Typ IS RECORD (
5 quote_line_id NUMBER,
6 organization_id NUMBER,
7 inventory_item_id NUMBER,
8 quantity NUMBER,
9 uom_code VARCHAR2(3),
10 customer_id NUMBER,
11 ship_to_site_id NUMBER,
12 ship_method_code VARCHAR2(30),
13 request_date VARCHAR2(30),
14 request_date_quantity NUMBER,
15 available_date VARCHAR2(30),
16 error_code NUMBER,
17 error_message VARCHAR2(2000)
18 );
19
20 TYPE ATP_Line_Tbl_Typ IS TABLE OF ATP_Line_Typ INDEX BY BINARY_INTEGER;
21
22 PROCEDURE Check_Availability (
23 p_quote_header_id IN NUMBER,
24 p_date_format IN VARCHAR2,
25 p_lang_code IN VARCHAR2,
26 x_error_flag OUT NOCOPY VARCHAR2,
27 x_error_message OUT NOCOPY VARCHAR2,
28 x_atp_line_tbl IN OUT NOCOPY ATP_Line_Tbl_Typ
29 );
30
31 END IBE_ATP_PVT;