1 PACKAGE INV_CUSTOMER_ITEM_GRP as
2 /* $Header: INVICSDS.pls 120.1 2005/06/21 03:18:10 appldev ship $ */
3
4 PRAGMA RESTRICT_REFERENCES ( INV_CUSTOMER_ITEM_GRP, WNDS, WNPS, RNDS, RNPS );
5
6 PROCEDURE CI_Attribute_Value(
7 Z_Customer_Item_Id IN Number DEFAULT NULL,
8 Z_Customer_Id IN Number DEFAULT NULL,
9 Z_Customer_Category_Code IN Varchar2 DEFAULT NULL,
10 Z_Address_Id IN Number DEFAULT NULL,
11 Z_Customer_Item_Number IN Varchar2 DEFAULT NULL,
12 Z_Inventory_Item_Id IN Number DEFAULT NULL,
13 Z_Organization_Id IN Number DEFAULT NULL,
14 Attribute_Name IN Varchar2 DEFAULT NULL,
15 Error_Code OUT NOCOPY Varchar2,
16 Error_Flag OUT NOCOPY Varchar2,
17 Error_Message OUT NOCOPY Varchar2,
18 Attribute_Value OUT NOCOPY Varchar2
19 );
20
21
22 PROCEDURE Fetch_Attributes(
23 Y_Address_Id IN Number DEFAULT NULL,
24 Y_Customer_Category_Code IN Varchar2 DEFAULT NULL,
25 Y_Customer_Id IN Number DEFAULT NULL,
26 Y_Customer_Item_Number IN Varchar2 DEFAULT NULL,
27 Y_Organization_Id IN Number DEFAULT NULL,
28 Y_Customer_Item_Id IN Number DEFAULT NULL,
29 Y_Inventory_Item_Id IN Number DEFAULT NULL,
30 X_Customer_Item_Id OUT NOCOPY Number,
31 X_Customer_Id OUT NOCOPY Number,
32 X_Customer_Category_Code OUT NOCOPY Varchar2,
33 X_Address_Id OUT NOCOPY Number,
34 X_Customer_Item_Number OUT NOCOPY Varchar2,
35 X_Item_Definition_Level OUT NOCOPY Varchar2,
36 X_Customer_Item_Desc OUT NOCOPY Varchar2,
37 X_Model_Customer_Item_Id OUT NOCOPY Number,
38 X_Commodity_Code_Id OUT NOCOPY Number,
39 X_Master_Container_Item_Id OUT NOCOPY Number,
40 X_Container_Item_Org_Id OUT NOCOPY Number,
41 X_Detail_Container_Item_Id OUT NOCOPY Number,
42 X_Min_Fill_Percentage OUT NOCOPY Number,
43 X_Dep_Plan_Required_Flag OUT NOCOPY Varchar2,
44 X_Dep_Plan_Prior_Bld_Flag OUT NOCOPY Varchar2,
45 X_Demand_Tolerance_Positive OUT NOCOPY Number,
46 X_Demand_Tolerance_Negative OUT NOCOPY Number,
47 X_Attribute_Category OUT NOCOPY Varchar2,
48 X_Attribute1 OUT NOCOPY Varchar2,
49 X_Attribute2 OUT NOCOPY Varchar2,
50 X_Attribute3 OUT NOCOPY Varchar2,
51 X_Attribute4 OUT NOCOPY Varchar2,
52 X_Attribute5 OUT NOCOPY Varchar2,
53 X_Attribute6 OUT NOCOPY Varchar2,
54 X_Attribute7 OUT NOCOPY Varchar2,
55 X_Attribute8 OUT NOCOPY Varchar2,
56 X_Attribute9 OUT NOCOPY Varchar2,
57 X_Attribute10 OUT NOCOPY Varchar2,
58 X_Attribute11 OUT NOCOPY Varchar2,
59 X_Attribute12 OUT NOCOPY Varchar2,
60 X_Attribute13 OUT NOCOPY Varchar2,
61 X_Attribute14 OUT NOCOPY Varchar2,
62 X_Attribute15 OUT NOCOPY Varchar2,
63 X_Inventory_Item_Id OUT NOCOPY Number,
64 X_Master_Organization_Id OUT NOCOPY Number,
65 X_Preference_Number OUT NOCOPY Number,
66 X_Error_Code OUT NOCOPY Varchar2,
67 X_Error_Flag OUT NOCOPY Varchar2,
68 X_Error_Message OUT NOCOPY Varchar2
69 );
70
71
72 END INV_CUSTOMER_ITEM_GRP;