APPS.INV_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS

Line 77: ,P_Item_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

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: );

Line 78: ,P_Description IN OUT NOCOPY MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE

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:

Line 79: ,P_unit_of_measure IN OUT NOCOPY MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE%TYPE

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(

Line 80: ,P_Item_Catalog_Group_Id IN OUT NOCOPY MTL_SYSTEM_ITEMS.ITEM_CATALOG_GROUP_ID%TYPE

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

Line 87: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

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

Line 101: ,P_Master_Org_Id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

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

Line 108: ,P_Inv_Item_status_old IN MTL_SYSTEM_ITEMS_FVL.INVENTORY_ITEM_STATUS_CODE%TYPE

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: );

Line 135: P_Item_Id IN MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE

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

Line 136: ,P_Org_Id IN MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%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);

Line 137: ,P_Asset_Flag IN MTL_SYSTEM_ITEMS_B.INVENTORY_ASSET_FLAG%TYPE

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:

Line 139: ,P_Last_Updated_By IN MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY%TYPE

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

Line 140: ,P_Last_Updated_Login IN MTL_SYSTEM_ITEMS_B.LAST_UPDATE_LOGIN%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: