24: --
25: --
26: -- Parameters :
27: -- IN : p_api_version NUMBER Require
28: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
29: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
30: -- p_validation_level NUMBER Optional
31: -- (FND_API.G_VALID_LEVEL_FULL)
32: -- OUT : x_return_status VARCHAR2(1)
25: --
26: -- Parameters :
27: -- IN : p_api_version NUMBER Require
28: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
29: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
30: -- p_validation_level NUMBER Optional
31: -- (FND_API.G_VALID_LEVEL_FULL)
32: -- OUT : x_return_status VARCHAR2(1)
33: -- x_msg_count NUMBER
27: -- IN : p_api_version NUMBER Require
28: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
29: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
30: -- p_validation_level NUMBER Optional
31: -- (FND_API.G_VALID_LEVEL_FULL)
32: -- OUT : x_return_status VARCHAR2(1)
33: -- x_msg_count NUMBER
34: -- x_msg_data VARCHAR2(2000)
35: -- IN : p_srp_role_id NUMBER, Required
45: -- End of comments
46:
47: PROCEDURE get_overassign
48: ( p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
46:
47: PROCEDURE get_overassign
48: ( p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,
47: PROCEDURE get_overassign
48: ( p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,
55: p_qm_mgr_srp_group_id IN NUMBER ,