1 PACKAGE INV_ITEM_PVT AS
2 /* $Header: INVVITMS.pls 120.1.12010000.1 2008/07/24 01:52:01 appldev ship $ */
3
4 -- =============================================================================
5 -- Global types
6 -- =============================================================================
7
8 -- =============================================================================
9 -- Global variables and constants
10 -- =============================================================================
11
12 -- =============================================================================
13 -- Procedure specs
14 -- =============================================================================
15
16 /*------------------------------ Lock_Org_Items ------------------------------*/
17
18 PROCEDURE Lock_Org_Items
19 (
20 p_Item_ID IN NUMBER
21 , p_Org_ID IN NUMBER
22 , p_lock_Master IN VARCHAR2 := FND_API.g_TRUE
23 , p_lock_Orgs IN VARCHAR2 := FND_API.g_FALSE
24 , x_return_status OUT NOCOPY VARCHAR2
25 );
26
27
28 /*----------------------------- Update_Org_Items -----------------------------*/
29
30 PROCEDURE Update_Org_Items
31 (
32 p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
33 , p_commit IN VARCHAR2 := FND_API.g_FALSE
34 , p_lock_rows IN VARCHAR2 := FND_API.g_TRUE
35 , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
36 , p_Item_rec IN INV_Item_API.Item_rec_type
37 , p_update_changes_only IN VARCHAR2 := FND_API.g_FALSE
38 , p_validate_Master IN VARCHAR2 := FND_API.g_TRUE
39 , x_return_status OUT NOCOPY VARCHAR2
40 , x_msg_count OUT NOCOPY NUMBER
41 , x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44
45 /*------------------------------- Get_Org_Item -------------------------------*/
46
47 PROCEDURE Get_Org_Item
48 (
49 p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
50 , p_Item_ID IN NUMBER
51 , p_Org_ID IN NUMBER
52 , p_Language IN VARCHAR2 := FND_API.g_MISS_CHAR
53 , x_Item_rec OUT NOCOPY INV_Item_API.Item_rec_type
54 , x_return_status OUT NOCOPY VARCHAR2
55 , x_msg_count OUT NOCOPY NUMBER
56 , x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59
60 /*------------------------------ Validate_Item -------------------------------*/
61
62 -- Item record validation is currently performed within Update_Org_Items.
63
64 /*
65 PROCEDURE Validate_Item
66 (
67 p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
68 , p_Item_rec IN INV_Item_API.Item_rec_type
69 , x_return_status OUT VARCHAR2
70 , x_msg_count OUT NUMBER
71 , x_msg_data OUT VARCHAR2
72 );
73 */
74
75 PROCEDURE Check_Item_Number (
76 P_Segment_Rec IN INV_ITEM_API.Item_rec_type
77 ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
78 ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE
79 ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE
80 ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE
81 );
82
83 PROCEDURE Create_Item(
84 P_Item_Rec IN INV_ITEM_API.Item_rec_type
85 ,P_Item_Category_Struct_Id IN NUMBER
86 ,P_Inv_Install IN NUMBER
87 ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
88 ,P_Category_Set_Id IN NUMBER
89 ,P_Item_Category_Id IN NUMBER
90 ,P_Event IN VARCHAR2 DEFAULT 'INSERT'
91 ,x_row_Id OUT NOCOPY ROWID
92 ,P_Default_Move_Order_Sub_Inv IN VARCHAR2 -- Item Transaction Defaults for 11.5.9
93 ,P_Default_Receiving_Sub_Inv IN VARCHAR2
94 ,P_Default_Shipping_Sub_Inv IN VARCHAR2
95 );
96
97 PROCEDURE Update_Item(
98 P_Item_Rec IN INV_ITEM_API.Item_rec_type
99 ,P_Item_Category_Struct_Id IN NUMBER
100 ,P_Inv_Install IN NUMBER
101 ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
102 ,P_Category_Set_Id IN NUMBER
103 ,P_Item_Category_Id IN NUMBER
104 ,P_Mode IN VARCHAR2
105 ,P_Updateble_Item IN VARCHAR2
106 ,P_Cost_Txn IN VARCHAR2
107 ,P_Item_Cost_Details IN VARCHAR2
108 ,P_Inv_Item_status_old IN MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE
109 ,P_Default_Move_Order_Sub_Inv IN VARCHAR2 -- Item Transaction Defaults for 11.5.9
110 ,P_Default_Receiving_Sub_Inv IN VARCHAR2
111 ,P_Default_Shipping_Sub_Inv IN VARCHAR2
112 );
113
114 PROCEDURE Lock_Item( P_Item_Rec IN INV_ITEM_API.Item_rec_type);
115
116 PROCEDURE DELETE_ROW;
117
118 PROCEDURE UPDATE_NLS_TO_ORG(
119 X_INVENTORY_ITEM_ID IN VARCHAR2,
120 X_ORGANIZATION_ID IN VARCHAR2,
121 X_LANGUAGE IN VARCHAR2,
122 X_DESCRIPTION IN VARCHAR2,
123 X_LONG_DESCRIPTION IN VARCHAR2);
124
125 PROCEDURE ADD_LANGUAGE;
126
127 --Sync iM index after item creation,updation and org assignment.
128 PROCEDURE SYNC_IM_INDEX;
129
130 -- Added as part of Bug Fix 3623450
131 PROCEDURE Check_Master_Record_Locked( P_Item_Rec IN INV_ITEM_API.Item_rec_type);
132
133 --Enabled in spec for bug:3899614
134 PROCEDURE Delete_Cost_Details(
135 P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
136 ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE
137 ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE
138 ,P_Cost_Txn IN NUMBER
139 ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE
140 ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%TYPE);
141
142
143 FUNCTION Get_Is_Master_Attr_Modified RETURN VARCHAR2; --Business Event Related Changes 5236170
144
145
146 PROCEDURE Set_Is_Master_Attr_Modified(p_is_master_attr_modified VARCHAR2); --Business Event Related Changes 5236170
147
148
149 END INV_ITEM_PVT;