8: -- Pre-reqs : None.
9: -- Parameters :
10: -- IN
11: -- p_api_version_number IN NUMBER Required
12: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
14: -- p_profile_name IN VARCHAR2,
15: -- x_profile_value OUT VARCHAR2,
16: -- OUT
9: -- Parameters :
10: -- IN
11: -- p_api_version_number IN NUMBER Required
12: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
13: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
14: -- p_profile_name IN VARCHAR2,
15: -- x_profile_value OUT VARCHAR2,
16: -- OUT
17: -- x_return_status OUT VARCHAR2
23: --
24: -- End of comments
25: -- **********************************************************
26: PROCEDURE select_profile (p_api_version_number IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_profile_name IN VARCHAR2,
30: x_profile_value OUT NOCOPY VARCHAR2,
31: x_return_status OUT NOCOPY VARCHAR2,
24: -- End of comments
25: -- **********************************************************
26: PROCEDURE select_profile (p_api_version_number IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_profile_name IN VARCHAR2,
30: x_profile_value OUT NOCOPY VARCHAR2,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
40: -- Pre-reqs : None.
41: -- Parameters :
42: -- IN
43: -- p_api_version_number IN NUMBER Required
44: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
45: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
46: -- p_profile_name IN VARCHAR2,
47: -- p_profile_value IN VARCHAR2,
48: -- OUT
41: -- Parameters :
42: -- IN
43: -- p_api_version_number IN NUMBER Required
44: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
45: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
46: -- p_profile_name IN VARCHAR2,
47: -- p_profile_value IN VARCHAR2,
48: -- OUT
49: -- x_return_status OUT VARCHAR2