DBA Data[Home] [Help]

APPS.AMV_MYCHANNEL_GRP dependencies on FND_API

Line 28: -- Default = FND_API.G_FALSE

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

Line 30: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 32: -- Default = FND_API.G_TRUE

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

Line 48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 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

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;

Line 81: p_encoded => FND_API.G_FALSE,

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;

Line 96: -- Default = FND_API.G_FALSE

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

Line 98: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 101: -- 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
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

Line 115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 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

Line 145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;

Line 152: p_encoded => FND_API.G_FALSE,

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;