DBA Data[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;