DBA Data[Home] [Help]

PACKAGE: APPS.INVWATP

Source


1 PACKAGE INVWATP as
2 /* $Header: INVWATPS.pls 120.1 2005/06/11 07:46:08 appldev  $ */
3 
4 WebAtpGroupId number;
5 
6 FUNCTION WebAtpInsert
7 (
8   x_organization_id number,
9   x_inventory_item_id number,
10   x_atp_rule_id number,
11   x_request_quantity number,
12   x_request_primary_uom_quantity number,
13   x_request_date date,
14   x_atp_lead_time number,
15   x_uom_code varchar2,
16   x_demand_class varchar2,
17   x_n_column2 number
18 ) return number
19 ;
20 
21 PROCEDURE SetAtpGroupId ( x_atp_group_id number );
22 
23 FUNCTION GetAtpGroupId return number;
24 
25 FUNCTION WebAtpLaunch (
26   x_user_id in number,
27   x_resp_id in number,
28   x_resp_appl_id in number
29 ) return number;
30 
31 FUNCTION WebAtpFetch (
32     x_n_column2 number,
33     x_inventory_item_id OUT NOCOPY /* file.sql.39 change */ number,
34     x_organization_id OUT NOCOPY /* file.sql.39 change */ number,
35     x_request_quantity OUT NOCOPY /* file.sql.39 change */ number,
36     x_request_primary_uom_quantity OUT NOCOPY /* file.sql.39 change */ number,
37     x_request_date OUT NOCOPY /* file.sql.39 change */ date,
38     x_error_code OUT NOCOPY /* file.sql.39 change */ number,
39     x_group_available_date OUT NOCOPY /* file.sql.39 change */ date,
40     x_request_date_atp_quantity OUT NOCOPY /* file.sql.39 change */ number,
41     x_earliest_atp_date OUT NOCOPY /* file.sql.39 change */ date,
42     x_earliest_atp_date_quantity OUT NOCOPY /* file.sql.39 change */ number,
43     x_request_atp_date OUT NOCOPY /* file.sql.39 change */ date,
44     x_request_atp_date_quantity OUT NOCOPY /* file.sql.39 change */ number,
45     x_infinite_time_fence_date OUT NOCOPY /* file.sql.39 change */ date
46 ) return number;
47 
48 FUNCTION WebAtpClear return number;
49 
50 END INVWATP;