24: -- Function : Get all the channels for a given user (p_user_id)
25: -- Parameters :
26: -- IN p_api_version IN NUMBER Required
27: -- p_init_msg_list IN VARCHAR2 Optional
28: -- Default = FND_API.G_FALSE
29: -- p_validation_level IN NUMBER Optional
30: -- Default = FND_API.G_VALID_LEVEL_FULL
31: -- p_check_login_user IN VARCHAR2 Optional
32: -- Default = FND_API.G_TRUE
26: -- IN p_api_version IN NUMBER Required
27: -- p_init_msg_list IN VARCHAR2 Optional
28: -- Default = FND_API.G_FALSE
29: -- p_validation_level IN NUMBER Optional
30: -- Default = FND_API.G_VALID_LEVEL_FULL
31: -- p_check_login_user IN VARCHAR2 Optional
32: -- Default = FND_API.G_TRUE
33: -- p_user_id IN NUMBER Required
34: -- the given user
28: -- Default = FND_API.G_FALSE
29: -- p_validation_level IN NUMBER Optional
30: -- Default = FND_API.G_VALID_LEVEL_FULL
31: -- p_check_login_user IN VARCHAR2 Optional
32: -- Default = FND_API.G_TRUE
33: -- p_user_id IN NUMBER Required
34: -- the given user
35: -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
36: -- x_msg_count OUT NOCOPY NUMBER
44: -- End of comments
45: --
46: PROCEDURE Get_MyChannels
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,
45: --
46: PROCEDURE Get_MyChannels
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,
53: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,
53: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
54: p_user_id IN NUMBER,
55: x_mychannel_array OUT NOCOPY AMV_MYCHANNEL_PVT.AMV_MY_CHANNEL_VARRAY_TYPE
56: )
57: IS
70: x_mychannel_array => x_mychannel_array );
71:
72: EXCEPTION
73: WHEN OTHERS THEN
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
76: THEN
77: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
78: END IF;
77: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
78: END IF;
79: -- Standard call to get message count and if count=1, get the message
80: FND_MSG_PUB.Count_And_Get (
81: p_encoded => FND_API.G_FALSE,
82: p_count => x_msg_count,
83: p_data => x_msg_data
84: );
85: END Get_MyChannels;
92: -- Function : Return all items a user can access based channel/cat access
93: -- Parameters :
94: -- IN p_api_version IN NUMBER Required
95: -- p_init_msg_list IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_validation_level IN NUMBER Optional
98: -- Default = FND_API.G_VALID_LEVEL_FULL
99: -- p_category_id IN NUMBER Required
100: -- p_include_subcats IN VARCHAR2 Optional
94: -- IN p_api_version IN NUMBER Required
95: -- p_init_msg_list IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_validation_level IN NUMBER Optional
98: -- Default = FND_API.G_VALID_LEVEL_FULL
99: -- p_category_id IN NUMBER Required
100: -- p_include_subcats IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
97: -- p_validation_level IN NUMBER Optional
98: -- Default = FND_API.G_VALID_LEVEL_FULL
99: -- p_category_id IN NUMBER Required
100: -- p_include_subcats IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
103: -- x_msg_count OUT NOCOPY NUMBER
104: -- x_msg_data OUT NOCOPY VARCHAR2
105: -- x_items_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
111: -- End of comments
112: --
113: PROCEDURE Get_ItemsPerUser
114: ( p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
112: --
113: PROCEDURE Get_ItemsPerUser
114: ( p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
121: p_user_id IN NUMBER,
122: p_request_obj IN AMV_MYCHANNEL_PVT.AMV_REQUEST_OBJ_TYPE,
123: x_return_obj OUT NOCOPY AMV_MYCHANNEL_PVT.AMV_RETURN_OBJ_TYPE,
124: x_items_array OUT NOCOPY AMV_MYCHANNEL_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
141: x_items_array => x_items_array);
142:
143: EXCEPTION
144: WHEN OTHERS THEN
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
147: THEN
148: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
149: END IF;
148: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
149: END IF;
150: -- Standard call to get message count and if count=1, get the message
151: FND_MSG_PUB.Count_And_Get (
152: p_encoded => FND_API.G_FALSE,
153: p_count => x_msg_count,
154: p_data => x_msg_data
155: );
156: END Get_ItemsPerUser;