eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_MYCHANNEL_PVT dependencies on FND_API

Line 83: -- Default = FND_API.G_FALSE

79: -- Function : Launch workflow to subscribe a channel for an user
80: -- Parameters :
81: -- IN p_api_version IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional
83: -- Default = FND_API.G_FALSE
84: -- p_commit IN VARCHAR2 Optional
85: -- Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional
87: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 85: -- Default = FND_API.G_FALSE

81: -- IN p_api_version IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional
83: -- Default = FND_API.G_FALSE
84: -- p_commit IN VARCHAR2 Optional
85: -- Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional
87: -- Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_check_login_user IN VARCHAR2 Optional
89: -- Default = FND_API.G_TRUE

Line 87: -- Default = FND_API.G_VALID_LEVEL_FULL

83: -- Default = FND_API.G_FALSE
84: -- p_commit IN VARCHAR2 Optional
85: -- Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional
87: -- Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_check_login_user IN VARCHAR2 Optional
89: -- Default = FND_API.G_TRUE
90: -- p_channel_id IN NUMBER Required
91: -- OUT : x_return_status OUT VARCHAR2

Line 89: -- Default = FND_API.G_TRUE

85: -- Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional
87: -- Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_check_login_user IN VARCHAR2 Optional
89: -- Default = FND_API.G_TRUE
90: -- p_channel_id IN NUMBER Required
91: -- OUT : x_return_status OUT VARCHAR2
92: -- x_msg_count OUT NUMBER
93: -- x_msg_data OUT VARCHAR2

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

98: --
99: -- End of comments
100: PROCEDURE Subscribe_Channel
101: ( p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
106: p_channel_id IN NUMBER,

Line 103: p_commit IN VARCHAR2 := FND_API.G_FALSE,

99: -- End of comments
100: PROCEDURE Subscribe_Channel
101: ( p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
106: p_channel_id IN NUMBER,
107: x_return_status OUT NOCOPY VARCHAR2,

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

100: PROCEDURE Subscribe_Channel
101: ( p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
106: p_channel_id IN NUMBER,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,

Line 105: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

101: ( p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
106: p_channel_id IN NUMBER,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2

Line 130: -- Default = FND_API.G_FALSE

126: -- Function : Subscribe a channel/category for an user
127: -- Parameters :
128: -- IN p_api_version IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional
130: -- Default = FND_API.G_FALSE
131: -- p_commit IN VARCHAR2 Optional
132: -- Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional
134: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 132: -- Default = FND_API.G_FALSE

128: -- IN p_api_version IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional
130: -- Default = FND_API.G_FALSE
131: -- p_commit IN VARCHAR2 Optional
132: -- Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional
134: -- Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_check_login_user IN VARCHAR2 Optional
136: -- Default = FND_API.G_TRUE

Line 134: -- Default = FND_API.G_VALID_LEVEL_FULL

130: -- Default = FND_API.G_FALSE
131: -- p_commit IN VARCHAR2 Optional
132: -- Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional
134: -- Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_check_login_user IN VARCHAR2 Optional
136: -- Default = FND_API.G_TRUE
137: -- p_mychannel_obj IN
138: -- AMV_MY_CHANNEL_OBJ_TYPE Required

Line 136: -- Default = FND_API.G_TRUE

132: -- Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional
134: -- Default = FND_API.G_VALID_LEVEL_FULL
135: -- p_check_login_user IN VARCHAR2 Optional
136: -- Default = FND_API.G_TRUE
137: -- p_mychannel_obj IN
138: -- AMV_MY_CHANNEL_OBJ_TYPE Required
139: -- MyChannel data to be created.
140: -- OUT : x_return_status OUT VARCHAR2

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

150: --
151: --BREAK
152: PROCEDURE Add_Subscription
153: ( p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,

Line 155: p_commit IN VARCHAR2 := FND_API.G_FALSE,

151: --BREAK
152: PROCEDURE Add_Subscription
153: ( p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,

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

152: PROCEDURE Add_Subscription
153: ( p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 160: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
161: p_mychannel_obj IN AMV_MY_CHANNEL_OBJ_TYPE,
162: x_mychannel_id OUT NOCOPY NUMBER
163: );
164: --

Line 179: -- Default = FND_API.G_FALSE

175: -- Function : Delete the subscription given p_mychannel_id.
176: -- Parameters :
177: -- IN p_api_version IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Optional
179: -- Default = FND_API.G_FALSE
180: -- p_commit IN VARCHAR2 Optional
181: -- Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional
183: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 181: -- Default = FND_API.G_FALSE

177: -- IN p_api_version IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Optional
179: -- Default = FND_API.G_FALSE
180: -- p_commit IN VARCHAR2 Optional
181: -- Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional
183: -- Default = FND_API.G_VALID_LEVEL_FULL
184: -- p_check_login_user IN VARCHAR2 Optional
185: -- Default = FND_API.G_TRUE

Line 183: -- Default = FND_API.G_VALID_LEVEL_FULL

179: -- Default = FND_API.G_FALSE
180: -- p_commit IN VARCHAR2 Optional
181: -- Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional
183: -- Default = FND_API.G_VALID_LEVEL_FULL
184: -- p_check_login_user IN VARCHAR2 Optional
185: -- Default = FND_API.G_TRUE
186: -- p_mychannel_id IN NUMBER Optional
187: -- Default = FND_API.G_MISS_NUM

Line 185: -- Default = FND_API.G_TRUE

181: -- Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional
183: -- Default = FND_API.G_VALID_LEVEL_FULL
184: -- p_check_login_user IN VARCHAR2 Optional
185: -- Default = FND_API.G_TRUE
186: -- p_mychannel_id IN NUMBER Optional
187: -- Default = FND_API.G_MISS_NUM
188: -- MyChannel Id
189: -- p_user_or_group_id IN NUMBER Optional

Line 187: -- Default = FND_API.G_MISS_NUM

183: -- Default = FND_API.G_VALID_LEVEL_FULL
184: -- p_check_login_user IN VARCHAR2 Optional
185: -- Default = FND_API.G_TRUE
186: -- p_mychannel_id IN NUMBER Optional
187: -- Default = FND_API.G_MISS_NUM
188: -- MyChannel Id
189: -- p_user_or_group_id IN NUMBER Optional
190: -- Default = FND_API.G_MISS_NUM
191: -- p_user_or_group_type IN VARCHAR2 Optional

Line 190: -- Default = FND_API.G_MISS_NUM

186: -- p_mychannel_id IN NUMBER Optional
187: -- Default = FND_API.G_MISS_NUM
188: -- MyChannel Id
189: -- p_user_or_group_id IN NUMBER Optional
190: -- Default = FND_API.G_MISS_NUM
191: -- p_user_or_group_type IN VARCHAR2 Optional
192: -- Default = FND_API.G_MISS_CHAR
193: -- p_subscribing_to_id IN NUMBER Optional
194: -- Default = FND_API.G_MISS_NUM

Line 192: -- Default = FND_API.G_MISS_CHAR

188: -- MyChannel Id
189: -- p_user_or_group_id IN NUMBER Optional
190: -- Default = FND_API.G_MISS_NUM
191: -- p_user_or_group_type IN VARCHAR2 Optional
192: -- Default = FND_API.G_MISS_CHAR
193: -- p_subscribing_to_id IN NUMBER Optional
194: -- Default = FND_API.G_MISS_NUM
195: -- p_subscribing_to_type IN VARCHAR2 Optional
196: -- Default = FND_API.G_MISS_CHAR

Line 194: -- Default = FND_API.G_MISS_NUM

190: -- Default = FND_API.G_MISS_NUM
191: -- p_user_or_group_type IN VARCHAR2 Optional
192: -- Default = FND_API.G_MISS_CHAR
193: -- p_subscribing_to_id IN NUMBER Optional
194: -- Default = FND_API.G_MISS_NUM
195: -- p_subscribing_to_type IN VARCHAR2 Optional
196: -- Default = FND_API.G_MISS_CHAR
197: -- Pass the user and subscription id and types
198: -- instead of mychannel id.

Line 196: -- Default = FND_API.G_MISS_CHAR

192: -- Default = FND_API.G_MISS_CHAR
193: -- p_subscribing_to_id IN NUMBER Optional
194: -- Default = FND_API.G_MISS_NUM
195: -- p_subscribing_to_type IN VARCHAR2 Optional
196: -- Default = FND_API.G_MISS_CHAR
197: -- Pass the user and subscription id and types
198: -- instead of mychannel id.
199: -- Must pass the mychannel id or the joint key of
200: -- above four values

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

209: -- End of comments
210: --
211: PROCEDURE Remove_Subscription
212: ( p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214: p_commit IN VARCHAR2 := FND_API.G_FALSE,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,

Line 214: p_commit IN VARCHAR2 := FND_API.G_FALSE,

210: --
211: PROCEDURE Remove_Subscription
212: ( p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214: p_commit IN VARCHAR2 := FND_API.G_FALSE,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,

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

211: PROCEDURE Remove_Subscription
212: ( p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214: p_commit IN VARCHAR2 := FND_API.G_FALSE,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 219: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
220: p_mychannel_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_user_or_group_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_user_or_group_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_subscribing_to_id IN NUMBER := FND_API.G_MISS_NUM,

Line 220: p_mychannel_id IN NUMBER := FND_API.G_MISS_NUM,

216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
220: p_mychannel_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_user_or_group_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_user_or_group_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_subscribing_to_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_subscribing_to_type IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 221: p_user_or_group_id IN NUMBER := FND_API.G_MISS_NUM,

217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
220: p_mychannel_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_user_or_group_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_user_or_group_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_subscribing_to_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_subscribing_to_type IN VARCHAR2 := FND_API.G_MISS_CHAR
225: );

Line 222: p_user_or_group_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
220: p_mychannel_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_user_or_group_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_user_or_group_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_subscribing_to_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_subscribing_to_type IN VARCHAR2 := FND_API.G_MISS_CHAR
225: );
226: --

Line 223: p_subscribing_to_id IN NUMBER := FND_API.G_MISS_NUM,

219: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
220: p_mychannel_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_user_or_group_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_user_or_group_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_subscribing_to_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_subscribing_to_type IN VARCHAR2 := FND_API.G_MISS_CHAR
225: );
226: --
227: -- Algorithm:

Line 224: p_subscribing_to_type IN VARCHAR2 := FND_API.G_MISS_CHAR

220: p_mychannel_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_user_or_group_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_user_or_group_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_subscribing_to_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_subscribing_to_type IN VARCHAR2 := FND_API.G_MISS_CHAR
225: );
226: --
227: -- Algorithm:
228: -- BEGIN

Line 241: -- Default = FND_API.G_FALSE

237: -- Function : Update the mychannel given p_mychannel_id.
238: -- Parameters :
239: -- IN p_api_version IN NUMBER Required
240: -- p_init_msg_list IN VARCHAR2 Optional
241: -- Default = FND_API.G_FALSE
242: -- p_commit IN VARCHAR2 Optional
243: -- Default = FND_API.G_FALSE
244: -- p_validation_level IN NUMBER Optional
245: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 243: -- Default = FND_API.G_FALSE

239: -- IN p_api_version IN NUMBER Required
240: -- p_init_msg_list IN VARCHAR2 Optional
241: -- Default = FND_API.G_FALSE
242: -- p_commit IN VARCHAR2 Optional
243: -- Default = FND_API.G_FALSE
244: -- p_validation_level IN NUMBER Optional
245: -- Default = FND_API.G_VALID_LEVEL_FULL
246: -- p_check_login_user IN VARCHAR2 Optional
247: -- Default = FND_API.G_TRUE

Line 245: -- Default = FND_API.G_VALID_LEVEL_FULL

241: -- Default = FND_API.G_FALSE
242: -- p_commit IN VARCHAR2 Optional
243: -- Default = FND_API.G_FALSE
244: -- p_validation_level IN NUMBER Optional
245: -- Default = FND_API.G_VALID_LEVEL_FULL
246: -- p_check_login_user IN VARCHAR2 Optional
247: -- Default = FND_API.G_TRUE
248: -- p_mychannel_obj IN AMV_MY_CHANNEL_OBJ_TYPE Required
249: -- OUT : x_return_status OUT VARCHAR2

Line 247: -- Default = FND_API.G_TRUE

243: -- Default = FND_API.G_FALSE
244: -- p_validation_level IN NUMBER Optional
245: -- Default = FND_API.G_VALID_LEVEL_FULL
246: -- p_check_login_user IN VARCHAR2 Optional
247: -- Default = FND_API.G_TRUE
248: -- p_mychannel_obj IN AMV_MY_CHANNEL_OBJ_TYPE Required
249: -- OUT : x_return_status OUT VARCHAR2
250: -- x_msg_count OUT NUMBER
251: -- x_msg_data OUT VARCHAR2

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

257: -- End of comments
258: --
259: PROCEDURE Update_MyChannel
260: ( p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,

Line 262: p_commit IN VARCHAR2 := FND_API.G_FALSE,

258: --
259: PROCEDURE Update_MyChannel
260: ( p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,

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

259: PROCEDURE Update_MyChannel
260: ( p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 267: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
268: p_mychannel_obj IN AMV_MY_CHANNEL_OBJ_TYPE
269: );
270: --
271: -- Algorithm:

Line 284: -- Default = FND_API.G_FALSE

280: -- Function : Get all the channels for a given user (p_user_id)
281: -- Parameters :
282: -- IN p_api_version IN NUMBER Required
283: -- p_init_msg_list IN VARCHAR2 Optional
284: -- Default = FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Optional
286: -- Default = FND_API.G_VALID_LEVEL_FULL
287: -- p_check_login_user IN VARCHAR2 Optional
288: -- Default = FND_API.G_TRUE

Line 286: -- Default = FND_API.G_VALID_LEVEL_FULL

282: -- IN p_api_version IN NUMBER Required
283: -- p_init_msg_list IN VARCHAR2 Optional
284: -- Default = FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Optional
286: -- Default = FND_API.G_VALID_LEVEL_FULL
287: -- p_check_login_user IN VARCHAR2 Optional
288: -- Default = FND_API.G_TRUE
289: -- p_user_id IN NUMBER Required
290: -- the given user

Line 288: -- Default = FND_API.G_TRUE

284: -- Default = FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Optional
286: -- Default = FND_API.G_VALID_LEVEL_FULL
287: -- p_check_login_user IN VARCHAR2 Optional
288: -- Default = FND_API.G_TRUE
289: -- p_user_id IN NUMBER Required
290: -- the given user
291: -- OUT : x_return_status OUT VARCHAR2
292: -- x_msg_count OUT NUMBER

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

300: -- End of comments
301: --
302: PROCEDURE Get_MyChannels
303: ( p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,
308: x_msg_data OUT NOCOPY VARCHAR2,

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

301: --
302: PROCEDURE Get_MyChannels
303: ( p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,
308: x_msg_data OUT NOCOPY VARCHAR2,
309: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 309: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,
308: x_msg_data OUT NOCOPY VARCHAR2,
309: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
310: p_user_id IN NUMBER,
311: x_mychannel_array OUT NOCOPY AMV_MY_CHANNEL_VARRAY_TYPE
312: );
313: --

Line 328: -- Default = FND_API.G_FALSE

324: -- Function : Get all channels in a category which an user has access to
325: -- Parameters :
326: -- IN p_api_version IN NUMBER Required
327: -- p_init_msg_list IN VARCHAR2 Optional
328: -- Default = FND_API.G_FALSE
329: -- p_validation_level IN NUMBER Optional
330: -- Default = FND_API.G_VALID_LEVEL_FULL
331: -- p_check_login_user IN VARCHAR2 Optional
332: -- Default = FND_API.G_TRUE

Line 330: -- Default = FND_API.G_VALID_LEVEL_FULL

326: -- IN p_api_version IN NUMBER Required
327: -- p_init_msg_list IN VARCHAR2 Optional
328: -- Default = FND_API.G_FALSE
329: -- p_validation_level IN NUMBER Optional
330: -- Default = FND_API.G_VALID_LEVEL_FULL
331: -- p_check_login_user IN VARCHAR2 Optional
332: -- Default = FND_API.G_TRUE
333: -- p_user_id IN NUMBER Required
334: -- the given user

Line 332: -- Default = FND_API.G_TRUE

328: -- Default = FND_API.G_FALSE
329: -- p_validation_level IN NUMBER Optional
330: -- Default = FND_API.G_VALID_LEVEL_FULL
331: -- p_check_login_user IN VARCHAR2 Optional
332: -- Default = FND_API.G_TRUE
333: -- p_user_id IN NUMBER Required
334: -- the given user
335: -- p_category_id IN NUMBER Required
336: -- OUT : x_return_status OUT VARCHAR2

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

345: -- End of comments
346: --
347: PROCEDURE Get_MyChannelsPerCategory
348: ( p_api_version IN NUMBER,
349: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2,

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

346: --
347: PROCEDURE Get_MyChannelsPerCategory
348: ( p_api_version IN NUMBER,
349: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 354: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
355: p_user_id IN NUMBER,
356: p_category_id IN NUMBER,
357: x_channel_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
358: );

Line 375: -- Default = FND_API.G_FALSE

371: -- Function : Get all notifications for a user - either approval or fyi
372: -- Parameters :
373: -- IN p_api_version IN NUMBER Required
374: -- p_init_msg_list IN VARCHAR2 Optional
375: -- Default = FND_API.G_FALSE
376: -- p_validation_level IN NUMBER Optional
377: -- Default = FND_API.G_VALID_LEVEL_FULL
378: -- p_check_login_user IN VARCHAR2 Optional
379: -- Default = FND_API.G_TRUE

Line 377: -- Default = FND_API.G_VALID_LEVEL_FULL

373: -- IN p_api_version IN NUMBER Required
374: -- p_init_msg_list IN VARCHAR2 Optional
375: -- Default = FND_API.G_FALSE
376: -- p_validation_level IN NUMBER Optional
377: -- Default = FND_API.G_VALID_LEVEL_FULL
378: -- p_check_login_user IN VARCHAR2 Optional
379: -- Default = FND_API.G_TRUE
380: -- p_resource_id IN NUMBER Optional
381: -- Default = FND_API.G_MISS_NUM

Line 379: -- Default = FND_API.G_TRUE

375: -- Default = FND_API.G_FALSE
376: -- p_validation_level IN NUMBER Optional
377: -- Default = FND_API.G_VALID_LEVEL_FULL
378: -- p_check_login_user IN VARCHAR2 Optional
379: -- Default = FND_API.G_TRUE
380: -- p_resource_id IN NUMBER Optional
381: -- Default = FND_API.G_MISS_NUM
382: -- resource manager resource id
383: -- p_user_id IN NUMBER Optional

Line 381: -- Default = FND_API.G_MISS_NUM

377: -- Default = FND_API.G_VALID_LEVEL_FULL
378: -- p_check_login_user IN VARCHAR2 Optional
379: -- Default = FND_API.G_TRUE
380: -- p_resource_id IN NUMBER Optional
381: -- Default = FND_API.G_MISS_NUM
382: -- resource manager resource id
383: -- p_user_id IN NUMBER Optional
384: -- Default = FND_API.G_MISS_NUM
385: -- fnd user id

Line 384: -- Default = FND_API.G_MISS_NUM

380: -- p_resource_id IN NUMBER Optional
381: -- Default = FND_API.G_MISS_NUM
382: -- resource manager resource id
383: -- p_user_id IN NUMBER Optional
384: -- Default = FND_API.G_MISS_NUM
385: -- fnd user id
386: -- p_user_name IN VARCHAR2 Optional
387: -- Default = FND_API.G_MISS_CHAR
388: -- fnd user name

Line 387: -- Default = FND_API.G_MISS_CHAR

383: -- p_user_id IN NUMBER Optional
384: -- Default = FND_API.G_MISS_NUM
385: -- fnd user id
386: -- p_user_name IN VARCHAR2 Optional
387: -- Default = FND_API.G_MISS_CHAR
388: -- fnd user name
389: -- p_notification_type IN VARCHAR2 Optional
390: -- Default = FND_API.G_MISS_CHAR
391: -- OUT : x_return_status OUT VARCHAR2

Line 390: -- Default = FND_API.G_MISS_CHAR

386: -- p_user_name IN VARCHAR2 Optional
387: -- Default = FND_API.G_MISS_CHAR
388: -- fnd user name
389: -- p_notification_type IN VARCHAR2 Optional
390: -- Default = FND_API.G_MISS_CHAR
391: -- OUT : x_return_status OUT VARCHAR2
392: -- x_msg_count OUT NUMBER
393: -- x_msg_data OUT VARCHAR2
394: -- x_notifications_array OUT AMV_WF_NOTIF_VARRAY_TYPE

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

400: -- End of comments
401: --
402: PROCEDURE Get_MyNotifications
403: ( p_api_version IN NUMBER,
404: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
406: x_return_status OUT NOCOPY VARCHAR2,
407: x_msg_count OUT NOCOPY NUMBER,
408: x_msg_data OUT NOCOPY VARCHAR2,

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

401: --
402: PROCEDURE Get_MyNotifications
403: ( p_api_version IN NUMBER,
404: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
406: x_return_status OUT NOCOPY VARCHAR2,
407: x_msg_count OUT NOCOPY NUMBER,
408: x_msg_data OUT NOCOPY VARCHAR2,
409: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 409: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
406: x_return_status OUT NOCOPY VARCHAR2,
407: x_msg_count OUT NOCOPY NUMBER,
408: x_msg_data OUT NOCOPY VARCHAR2,
409: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
410: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
412: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
413: p_notification_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 410: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

406: x_return_status OUT NOCOPY VARCHAR2,
407: x_msg_count OUT NOCOPY NUMBER,
408: x_msg_data OUT NOCOPY VARCHAR2,
409: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
410: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
412: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
413: p_notification_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: x_notification_url OUT NOCOPY VARCHAR2,

Line 411: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

407: x_msg_count OUT NOCOPY NUMBER,
408: x_msg_data OUT NOCOPY VARCHAR2,
409: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
410: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
412: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
413: p_notification_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: x_notification_url OUT NOCOPY VARCHAR2,
415: x_notifications_array OUT NOCOPY AMV_WF_NOTIF_VARRAY_TYPE

Line 412: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

408: x_msg_data OUT NOCOPY VARCHAR2,
409: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
410: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
412: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
413: p_notification_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: x_notification_url OUT NOCOPY VARCHAR2,
415: x_notifications_array OUT NOCOPY AMV_WF_NOTIF_VARRAY_TYPE
416: );

Line 413: p_notification_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

409: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
410: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
411: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
412: p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
413: p_notification_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: x_notification_url OUT NOCOPY VARCHAR2,
415: x_notifications_array OUT NOCOPY AMV_WF_NOTIF_VARRAY_TYPE
416: );
417: --

Line 433: -- Default = FND_API.G_FALSE

429: -- Function : Return all items a user can access based channel/cat access
430: -- Parameters :
431: -- IN p_api_version IN NUMBER Required
432: -- p_init_msg_list IN VARCHAR2 Optional
433: -- Default = FND_API.G_FALSE
434: -- p_validation_level IN NUMBER Optional
435: -- Default = FND_API.G_VALID_LEVEL_FULL
436: -- p_category_id IN NUMBER Required
437: -- p_include_subcats IN VARCHAR2 Optional

Line 435: -- Default = FND_API.G_VALID_LEVEL_FULL

431: -- IN p_api_version IN NUMBER Required
432: -- p_init_msg_list IN VARCHAR2 Optional
433: -- Default = FND_API.G_FALSE
434: -- p_validation_level IN NUMBER Optional
435: -- Default = FND_API.G_VALID_LEVEL_FULL
436: -- p_category_id IN NUMBER Required
437: -- p_include_subcats IN VARCHAR2 Optional
438: -- Default = FND_API.G_FALSE
439: -- OUT : x_return_status OUT VARCHAR2

Line 438: -- Default = FND_API.G_FALSE

434: -- p_validation_level IN NUMBER Optional
435: -- Default = FND_API.G_VALID_LEVEL_FULL
436: -- p_category_id IN NUMBER Required
437: -- p_include_subcats IN VARCHAR2 Optional
438: -- Default = FND_API.G_FALSE
439: -- OUT : x_return_status OUT VARCHAR2
440: -- x_msg_count OUT NUMBER
441: -- x_msg_data OUT VARCHAR2
442: -- x_items_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE

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

448: -- End of comments
449: --
450: PROCEDURE Get_ItemsPerUser
451: ( p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
453: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
454: x_return_status OUT NOCOPY VARCHAR2,
455: x_msg_count OUT NOCOPY NUMBER,
456: x_msg_data OUT NOCOPY VARCHAR2,

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

449: --
450: PROCEDURE Get_ItemsPerUser
451: ( p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
453: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
454: x_return_status OUT NOCOPY VARCHAR2,
455: x_msg_count OUT NOCOPY NUMBER,
456: x_msg_data OUT NOCOPY VARCHAR2,
457: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 457: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

453: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
454: x_return_status OUT NOCOPY VARCHAR2,
455: x_msg_count OUT NOCOPY NUMBER,
456: x_msg_data OUT NOCOPY VARCHAR2,
457: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
458: p_user_id IN NUMBER,
459: p_request_obj IN AMV_REQUEST_OBJ_TYPE,
460: x_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
461: x_items_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE

Line 479: -- Default = FND_API.G_FALSE

475: -- Function : Return all items published by the user
476: -- Parameters :
477: -- IN p_api_version IN NUMBER Required
478: -- p_init_msg_list IN VARCHAR2 Optional
479: -- Default = FND_API.G_FALSE
480: -- p_validation_level IN NUMBER Optional
481: -- Default = FND_API.G_VALID_LEVEL_FULL
482: -- p_category_id IN NUMBER Required
483: -- p_include_subcats IN VARCHAR2 Optional

Line 481: -- Default = FND_API.G_VALID_LEVEL_FULL

477: -- IN p_api_version IN NUMBER Required
478: -- p_init_msg_list IN VARCHAR2 Optional
479: -- Default = FND_API.G_FALSE
480: -- p_validation_level IN NUMBER Optional
481: -- Default = FND_API.G_VALID_LEVEL_FULL
482: -- p_category_id IN NUMBER Required
483: -- p_include_subcats IN VARCHAR2 Optional
484: -- Default = FND_API.G_FALSE
485: -- OUT : x_return_status OUT VARCHAR2

Line 484: -- Default = FND_API.G_FALSE

480: -- p_validation_level IN NUMBER Optional
481: -- Default = FND_API.G_VALID_LEVEL_FULL
482: -- p_category_id IN NUMBER Required
483: -- p_include_subcats IN VARCHAR2 Optional
484: -- Default = FND_API.G_FALSE
485: -- OUT : x_return_status OUT VARCHAR2
486: -- x_msg_count OUT NUMBER
487: -- x_msg_data OUT VARCHAR2
488: -- x_items_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE

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

494: -- End of comments
495: --
496: PROCEDURE Get_UserItems
497: ( p_api_version IN NUMBER,
498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
500: x_return_status OUT NOCOPY VARCHAR2,
501: x_msg_count OUT NOCOPY NUMBER,
502: x_msg_data OUT NOCOPY VARCHAR2,

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

495: --
496: PROCEDURE Get_UserItems
497: ( p_api_version IN NUMBER,
498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
500: x_return_status OUT NOCOPY VARCHAR2,
501: x_msg_count OUT NOCOPY NUMBER,
502: x_msg_data OUT NOCOPY VARCHAR2,
503: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 503: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

499: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
500: x_return_status OUT NOCOPY VARCHAR2,
501: x_msg_count OUT NOCOPY NUMBER,
502: x_msg_data OUT NOCOPY VARCHAR2,
503: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
504: p_application_id IN NUMBER,
505: p_user_id IN NUMBER,
506: p_request_obj IN AMV_REQUEST_OBJ_TYPE,
507: x_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,

Line 526: -- Default = FND_API.G_FALSE

522: -- Function : check if user can maintain channel
523: -- Parameters :
524: -- IN p_api_version IN NUMBER Required
525: -- p_init_msg_list IN VARCHAR2 Optional
526: -- Default = FND_API.G_FALSE
527: -- p_validation_level IN NUMBER Optional
528: -- Default = FND_API.G_VALID_LEVEL_FULL
529: -- p_user_id IN NUMBER Required
530: -- p_include_subcats IN VARCHAR2 Optional

Line 528: -- Default = FND_API.G_VALID_LEVEL_FULL

524: -- IN p_api_version IN NUMBER Required
525: -- p_init_msg_list IN VARCHAR2 Optional
526: -- Default = FND_API.G_FALSE
527: -- p_validation_level IN NUMBER Optional
528: -- Default = FND_API.G_VALID_LEVEL_FULL
529: -- p_user_id IN NUMBER Required
530: -- p_include_subcats IN VARCHAR2 Optional
531: -- Default = FND_API.G_FALSE
532: -- OUT : x_return_status OUT VARCHAR2

Line 531: -- Default = FND_API.G_FALSE

527: -- p_validation_level IN NUMBER Optional
528: -- Default = FND_API.G_VALID_LEVEL_FULL
529: -- p_user_id IN NUMBER Required
530: -- p_include_subcats IN VARCHAR2 Optional
531: -- Default = FND_API.G_FALSE
532: -- OUT : x_return_status OUT VARCHAR2
533: -- x_msg_count OUT NUMBER
534: -- x_msg_data OUT VARCHAR2
535: -- x_items_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE

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

541: -- End of comments
542: --
543: PROCEDURE Can_UserMaintainChannel
544: ( p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
546: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
547: x_return_status OUT NOCOPY VARCHAR2,
548: x_msg_count OUT NOCOPY NUMBER,
549: x_msg_data OUT NOCOPY VARCHAR2,

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

542: --
543: PROCEDURE Can_UserMaintainChannel
544: ( p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
546: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
547: x_return_status OUT NOCOPY VARCHAR2,
548: x_msg_count OUT NOCOPY NUMBER,
549: x_msg_data OUT NOCOPY VARCHAR2,
550: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 550: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

546: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
547: x_return_status OUT NOCOPY VARCHAR2,
548: x_msg_count OUT NOCOPY NUMBER,
549: x_msg_data OUT NOCOPY VARCHAR2,
550: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
551: p_user_id IN NUMBER,
552: p_channel_id IN NUMBER,
553: x_maintain_flag OUT NOCOPY VARCHAR2
554: );