34: -- Declare Procedure for Utilization --
35: -----------------------------------------
36:
37: PROCEDURE Update_Utilization(p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_Utilization_tbl IN AHL_UC_Utilization_PVT.utilization_tbl_type,
42: x_return_status OUT NOCOPY VARCHAR2,
35: -----------------------------------------
36:
37: PROCEDURE Update_Utilization(p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_Utilization_tbl IN AHL_UC_Utilization_PVT.utilization_tbl_type,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
36:
37: PROCEDURE Update_Utilization(p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_Utilization_tbl IN AHL_UC_Utilization_PVT.utilization_tbl_type,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2);
51: -- Pre-reqs :
52: -- Parameters :
53: -- Standard IN Parameters :
54: -- p_api_version IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
56: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
57: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
58: --
59: -- Standard OUT Parameters :
52: -- Parameters :
53: -- Standard IN Parameters :
54: -- p_api_version IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
56: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
57: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
58: --
59: -- Standard OUT Parameters :
60: -- x_return_status OUT VARCHAR2 Required
53: -- Standard IN Parameters :
54: -- p_api_version IN NUMBER Required
55: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
56: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
57: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
58: --
59: -- Standard OUT Parameters :
60: -- x_return_status OUT VARCHAR2 Required
61: -- x_msg_count OUT NUMBER Required