8: -- Pre-reqs : None.
9: -- Parameters :
10: -- IN : p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level IN NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_FULL
10: -- IN : p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level IN NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_FULL
17: -- parameter1
18: -- parameter2
12: -- Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- p_validation_level IN NUMBER Optional
16: -- Default = FND_API.G_VALID_LEVEL_FULL
17: -- parameter1
18: -- parameter2
19: -- .
20: -- .
41:
42:
43: PROCEDURE insert_item
44: (
45: p_commit IN VARCHAR2:= FND_API.G_FALSE
46: , x_return_status OUT NOCOPY VARCHAR2
47: , x_msg_count OUT NOCOPY NUMBER
48: , x_msg_data OUT NOCOPY VARCHAR2
49: , X_ITEM_ID OUT NOCOPY NUMBER
79: );
80:
81: PROCEDURE update_item
82: (
83: p_commit IN VARCHAR2:= FND_API.G_FALSE
84: , x_return_status OUT NOCOPY VARCHAR2
85: , x_msg_count OUT NOCOPY NUMBER
86: , x_msg_data OUT NOCOPY VARCHAR2
87: , p_inventory_item_id IN NUMBER
94: , p_prefix_number IN VARCHAR2
95: );
96:
97: PROCEDURE Lock_Item(
98: p_commit IN VARCHAR2:= FND_API.G_FALSE
99: , x_return_status OUT NOCOPY VARCHAR2
100: , x_msg_count OUT NOCOPY NUMBER
101: , x_msg_data OUT NOCOPY VARCHAR2
102: , p_inventory_item_id IN NUMBER