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