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_ITEM_PUB dependencies on FND_API

Line 155: -- Default = FND_API.G_FALSE

151: -- given the item information.
152: -- Parameters :
153: -- IN p_api_version NUMBER Required
154: -- p_init_msg_list VARCHAR2 Optional
155: -- Default = FND_API.G_FALSE
156: -- p_commit VARCHAR2 Optional
157: -- Default = FND_API.G_FALSE
158: -- p_check_login_user VARCHAR2 Optional
159: -- Default = FND_API.G_TRUE

Line 157: -- Default = FND_API.G_FALSE

153: -- IN p_api_version NUMBER Required
154: -- p_init_msg_list VARCHAR2 Optional
155: -- Default = FND_API.G_FALSE
156: -- p_commit VARCHAR2 Optional
157: -- Default = FND_API.G_FALSE
158: -- p_check_login_user VARCHAR2 Optional
159: -- Default = FND_API.G_TRUE
160: -- Flag for checking user privilege and if user is login.
161: -- p_channel_id_array AMV_NUMBER_VARRAY_TYPE

Line 159: -- Default = FND_API.G_TRUE

155: -- Default = FND_API.G_FALSE
156: -- p_commit VARCHAR2 Optional
157: -- Default = FND_API.G_FALSE
158: -- p_check_login_user VARCHAR2 Optional
159: -- Default = FND_API.G_TRUE
160: -- Flag for checking user privilege and if user is login.
161: -- p_channel_id_array AMV_NUMBER_VARRAY_TYPE
162: -- Default = NULL. Optional
163: -- p_item_obj AMV_ITEM_OBJ_TYPE

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

173: --
174: PROCEDURE Create_Item
175: (
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,

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

174: PROCEDURE Create_Item
175: (
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

178: p_commit IN VARCHAR2 := FND_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
183: p_channel_id_array IN AMV_NUMBER_VARRAY_TYPE := NULL,
184: p_item_obj IN AMV_ITEM_OBJ_TYPE,
185: p_file_array IN AMV_NUMBER_VARRAY_TYPE,
186: p_persp_array IN AMV_NAMEID_VARRAY_TYPE,

Line 221: -- Default = FND_API.G_FALSE

217: -- Function : Delete an item from MES given the item id.
218: -- Parameters :
219: -- IN p_api_version NUMBER Required
220: -- p_init_msg_list VARCHAR2 Optional
221: -- Default = FND_API.G_FALSE
222: -- p_commit VARCHAR2 Optional
223: -- Default = FND_API.G_FALSE
224: -- p_check_login_user VARCHAR2 Optional
225: -- Default = FND_API.G_TRUE

Line 223: -- Default = FND_API.G_FALSE

219: -- IN p_api_version NUMBER Required
220: -- p_init_msg_list VARCHAR2 Optional
221: -- Default = FND_API.G_FALSE
222: -- p_commit VARCHAR2 Optional
223: -- Default = FND_API.G_FALSE
224: -- p_check_login_user VARCHAR2 Optional
225: -- Default = FND_API.G_TRUE
226: -- Flag for checking user privilege and if user is login.
227: -- p_item_id NUMBER Required

Line 225: -- Default = FND_API.G_TRUE

221: -- Default = FND_API.G_FALSE
222: -- p_commit VARCHAR2 Optional
223: -- Default = FND_API.G_FALSE
224: -- p_check_login_user VARCHAR2 Optional
225: -- Default = FND_API.G_TRUE
226: -- Flag for checking user privilege and if user is login.
227: -- p_item_id NUMBER Required
228: -- OUT : x_return_status VARCHAR2
229: -- x_msg_count NUMBER

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

234: --
235: PROCEDURE Delete_Item
236: (
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,

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

235: PROCEDURE Delete_Item
236: (
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
244: p_item_id IN NUMBER
245: );
246: --
247: -- Algorithm:

Line 275: -- Default = FND_API.G_FALSE

271: -- Function : Update the item based on the passed item object information.
272: -- Parameters :
273: -- IN p_api_version NUMBER Required
274: -- p_init_msg_list VARCHAR2 Optional
275: -- Default = FND_API.G_FALSE
276: -- p_commit VARCHAR2 Optional
277: -- Default = FND_API.G_FALSE
278: -- p_check_login_user VARCHAR2 Optional
279: -- Default = FND_API.G_TRUE

Line 277: -- Default = FND_API.G_FALSE

273: -- IN p_api_version NUMBER Required
274: -- p_init_msg_list VARCHAR2 Optional
275: -- Default = FND_API.G_FALSE
276: -- p_commit VARCHAR2 Optional
277: -- Default = FND_API.G_FALSE
278: -- p_check_login_user VARCHAR2 Optional
279: -- Default = FND_API.G_TRUE
280: -- Flag for checking user privilege and if user is login.
281: -- p_item_obj AMV_ITEM_OBJ_TYPE

Line 279: -- Default = FND_API.G_TRUE

275: -- Default = FND_API.G_FALSE
276: -- p_commit VARCHAR2 Optional
277: -- Default = FND_API.G_FALSE
278: -- p_check_login_user VARCHAR2 Optional
279: -- Default = FND_API.G_TRUE
280: -- Flag for checking user privilege and if user is login.
281: -- p_item_obj AMV_ITEM_OBJ_TYPE
282: -- Required
283: -- The object for the new data of the item

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

290: --
291: PROCEDURE Update_Item
292: (
293: p_api_version IN NUMBER,
294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295: p_commit IN VARCHAR2 := FND_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,

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

291: PROCEDURE Update_Item
292: (
293: p_api_version IN NUMBER,
294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295: p_commit IN VARCHAR2 := FND_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

295: p_commit IN VARCHAR2 := FND_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
300: p_channel_id_array IN AMV_NUMBER_VARRAY_TYPE := NULL,
301: p_item_obj IN AMV_ITEM_OBJ_TYPE,
302: p_file_array IN AMV_NUMBER_VARRAY_TYPE,
303: p_persp_array IN AMV_NAMEID_VARRAY_TYPE,

Line 337: -- Default = FND_API.G_FALSE

333: -- Function : Get an item information from MES given the item id.
334: -- Parameters :
335: -- IN p_api_version NUMBER Required
336: -- p_init_msg_list VARCHAR2 Optional
337: -- Default = FND_API.G_FALSE
338: -- p_check_login_user VARCHAR2 Optional
339: -- Default = FND_API.G_TRUE
340: -- Flag for checking user privilege and if user is login.
341: -- p_item_id NUMBER Required

Line 339: -- Default = FND_API.G_TRUE

335: -- IN p_api_version NUMBER Required
336: -- p_init_msg_list VARCHAR2 Optional
337: -- Default = FND_API.G_FALSE
338: -- p_check_login_user VARCHAR2 Optional
339: -- Default = FND_API.G_TRUE
340: -- Flag for checking user privilege and if user is login.
341: -- p_item_id NUMBER Required
342: -- OUT : x_return_status VARCHAR2
343: -- x_msg_count NUMBER

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

349: --
350: PROCEDURE Get_Item
351: (
352: p_api_version IN NUMBER,
353: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
354: x_return_status OUT NOCOPY VARCHAR2,
355: x_msg_count OUT NOCOPY NUMBER,
356: x_msg_data OUT NOCOPY VARCHAR2,
357: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

353: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
354: x_return_status OUT NOCOPY VARCHAR2,
355: x_msg_count OUT NOCOPY NUMBER,
356: x_msg_data OUT NOCOPY VARCHAR2,
357: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
358: p_item_id IN NUMBER,
359: x_item_obj OUT NOCOPY AMV_ITEM_OBJ_TYPE,
360: x_file_array OUT NOCOPY AMV_NUMBER_VARRAY_TYPE,
361: x_persp_array OUT NOCOPY AMV_NAMEID_VARRAY_TYPE,

Line 384: -- Default = FND_API.G_FALSE

380: -- Function : Query and return items from MES based on the passed criteria.
381: -- Parameters :
382: -- IN p_api_version NUMBER Required
383: -- p_init_msg_list VARCHAR2 Optional
384: -- Default = FND_API.G_FALSE
385: -- p_check_login_user VARCHAR2 Optional
386: -- Default = FND_API.G_TRUE
387: -- Flag for checking user privilege and if user is login.
388: -- p_item_name VARCHAR2 Optional

Line 386: -- Default = FND_API.G_TRUE

382: -- IN p_api_version NUMBER Required
383: -- p_init_msg_list VARCHAR2 Optional
384: -- Default = FND_API.G_FALSE
385: -- p_check_login_user VARCHAR2 Optional
386: -- Default = FND_API.G_TRUE
387: -- Flag for checking user privilege and if user is login.
388: -- p_item_name VARCHAR2 Optional
389: -- search criterion on item name
390: -- default to FND_API.G_MISS_CHAR

Line 390: -- default to FND_API.G_MISS_CHAR

386: -- Default = FND_API.G_TRUE
387: -- Flag for checking user privilege and if user is login.
388: -- p_item_name VARCHAR2 Optional
389: -- search criterion on item name
390: -- default to FND_API.G_MISS_CHAR
391: -- p_description VARCHAR2 Optional
392: -- search criterion on item description
393: -- default to FND_API.G_MISS_CHAR
394: -- p_item_type VARCHAR2 Optional

Line 393: -- default to FND_API.G_MISS_CHAR

389: -- search criterion on item name
390: -- default to FND_API.G_MISS_CHAR
391: -- p_description VARCHAR2 Optional
392: -- search criterion on item description
393: -- default to FND_API.G_MISS_CHAR
394: -- p_item_type VARCHAR2 Optional
395: -- search criterion on item type
396: -- default to FND_API.G_MISS_CHAR
397: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE,

Line 396: -- default to FND_API.G_MISS_CHAR

392: -- search criterion on item description
393: -- default to FND_API.G_MISS_CHAR
394: -- p_item_type VARCHAR2 Optional
395: -- search criterion on item type
396: -- default to FND_API.G_MISS_CHAR
397: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE,
398: -- Required.
399: -- OUT : x_return_status VARCHAR2
400: -- x_msg_count NUMBER

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

407: --
408: PROCEDURE Find_Item
409: (
410: p_api_version IN NUMBER,
411: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2,
415: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

411: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2,
415: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
416: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_item_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
419: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,

Line 416: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2,
415: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
416: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_item_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
419: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
420: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,

Line 417: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2,
415: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
416: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_item_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
419: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
420: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
421: x_item_obj_array OUT NOCOPY AMV_SIMPLE_ITEM_OBJ_VARRAY

Line 418: p_item_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

414: x_msg_data OUT NOCOPY VARCHAR2,
415: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
416: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_item_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
419: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
420: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
421: x_item_obj_array OUT NOCOPY AMV_SIMPLE_ITEM_OBJ_VARRAY
422: );

Line 444: -- Default = FND_API.G_FALSE

440: -- Function : Add the keywords passed in the array to the specified item.
441: -- Parameters :
442: -- IN p_api_version NUMBER Required
443: -- p_init_msg_list VARCHAR2 Optional
444: -- Default = FND_API.G_FALSE
445: -- p_commit VARCHAR2 Optional
446: -- Default = FND_API.G_FALSE
447: -- p_check_login_user VARCHAR2 Optional
448: -- Default = FND_API.G_TRUE

Line 446: -- Default = FND_API.G_FALSE

442: -- IN p_api_version NUMBER Required
443: -- p_init_msg_list VARCHAR2 Optional
444: -- Default = FND_API.G_FALSE
445: -- p_commit VARCHAR2 Optional
446: -- Default = FND_API.G_FALSE
447: -- p_check_login_user VARCHAR2 Optional
448: -- Default = FND_API.G_TRUE
449: -- Flag for checking user privilege and if user is login.
450: -- p_item_id NUMBER Required

Line 448: -- Default = FND_API.G_TRUE

444: -- Default = FND_API.G_FALSE
445: -- p_commit VARCHAR2 Optional
446: -- Default = FND_API.G_FALSE
447: -- p_check_login_user VARCHAR2 Optional
448: -- Default = FND_API.G_TRUE
449: -- Flag for checking user privilege and if user is login.
450: -- p_item_id NUMBER Required
451: -- The item id to be add the keywords.
452: -- p_keyword_varray AMV_CHAR_VARRAY_TYPE

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

461: --
462: PROCEDURE Add_ItemKeyword
463: (
464: p_api_version IN NUMBER,
465: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
466: p_commit IN VARCHAR2 := FND_API.G_FALSE,
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_msg_count OUT NOCOPY NUMBER,
469: x_msg_data OUT NOCOPY VARCHAR2,

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

462: PROCEDURE Add_ItemKeyword
463: (
464: p_api_version IN NUMBER,
465: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
466: p_commit IN VARCHAR2 := FND_API.G_FALSE,
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_msg_count OUT NOCOPY NUMBER,
469: x_msg_data OUT NOCOPY VARCHAR2,
470: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

466: p_commit IN VARCHAR2 := FND_API.G_FALSE,
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_msg_count OUT NOCOPY NUMBER,
469: x_msg_data OUT NOCOPY VARCHAR2,
470: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
471: p_item_id IN NUMBER,
472: p_keyword_varray IN AMV_CHAR_VARRAY_TYPE
473: );
474: -- Algorithm:

Line 505: -- Default = FND_API.G_FALSE

501: -- Function : Add the specified keywords to the specified item.
502: -- Parameters :
503: -- IN p_api_version NUMBER Required
504: -- p_init_msg_list VARCHAR2 Optional
505: -- Default = FND_API.G_FALSE
506: -- p_commit VARCHAR2 Optional
507: -- Default = FND_API.G_FALSE
508: -- p_check_login_user VARCHAR2 Optional
509: -- Default = FND_API.G_TRUE

Line 507: -- Default = FND_API.G_FALSE

503: -- IN p_api_version NUMBER Required
504: -- p_init_msg_list VARCHAR2 Optional
505: -- Default = FND_API.G_FALSE
506: -- p_commit VARCHAR2 Optional
507: -- Default = FND_API.G_FALSE
508: -- p_check_login_user VARCHAR2 Optional
509: -- Default = FND_API.G_TRUE
510: -- Flag for checking user privilege and if user is login.
511: -- p_item_id NUMBER Required

Line 509: -- Default = FND_API.G_TRUE

505: -- Default = FND_API.G_FALSE
506: -- p_commit VARCHAR2 Optional
507: -- Default = FND_API.G_FALSE
508: -- p_check_login_user VARCHAR2 Optional
509: -- Default = FND_API.G_TRUE
510: -- Flag for checking user privilege and if user is login.
511: -- p_item_id NUMBER Required
512: -- The item id to be add the keywords.
513: -- p_keyword VARCHAR2 Required

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

521: --
522: PROCEDURE Add_ItemKeyword
523: (
524: p_api_version IN NUMBER,
525: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
526: p_commit IN VARCHAR2 := FND_API.G_FALSE,
527: x_return_status OUT NOCOPY VARCHAR2,
528: x_msg_count OUT NOCOPY NUMBER,
529: x_msg_data OUT NOCOPY VARCHAR2,

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

522: PROCEDURE Add_ItemKeyword
523: (
524: p_api_version IN NUMBER,
525: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
526: p_commit IN VARCHAR2 := FND_API.G_FALSE,
527: x_return_status OUT NOCOPY VARCHAR2,
528: x_msg_count OUT NOCOPY NUMBER,
529: x_msg_data OUT NOCOPY VARCHAR2,
530: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

526: p_commit IN VARCHAR2 := FND_API.G_FALSE,
527: x_return_status OUT NOCOPY VARCHAR2,
528: x_msg_count OUT NOCOPY NUMBER,
529: x_msg_data OUT NOCOPY VARCHAR2,
530: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
531: p_item_id IN NUMBER,
532: p_keyword IN VARCHAR2
533: );
534: -- Algorithm:

Line 566: -- Default = FND_API.G_FALSE

562: -- from the specified item.
563: -- Parameters :
564: -- IN p_api_version NUMBER Required
565: -- p_init_msg_list VARCHAR2 Optional
566: -- Default = FND_API.G_FALSE
567: -- p_commit VARCHAR2 Optional
568: -- Default = FND_API.G_FALSE
569: -- p_check_login_user VARCHAR2 Optional
570: -- Default = FND_API.G_TRUE

Line 568: -- Default = FND_API.G_FALSE

564: -- IN p_api_version NUMBER Required
565: -- p_init_msg_list VARCHAR2 Optional
566: -- Default = FND_API.G_FALSE
567: -- p_commit VARCHAR2 Optional
568: -- Default = FND_API.G_FALSE
569: -- p_check_login_user VARCHAR2 Optional
570: -- Default = FND_API.G_TRUE
571: -- Flag for checking user privilege and if user is login.
572: -- p_item_id NUMBER Required

Line 570: -- Default = FND_API.G_TRUE

566: -- Default = FND_API.G_FALSE
567: -- p_commit VARCHAR2 Optional
568: -- Default = FND_API.G_FALSE
569: -- p_check_login_user VARCHAR2 Optional
570: -- Default = FND_API.G_TRUE
571: -- Flag for checking user privilege and if user is login.
572: -- p_item_id NUMBER Required
573: -- The item id to be add the keywords.
574: -- p_keyword_varray AMV_CHAR_VARRAY_TYPE

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

583: --
584: PROCEDURE Delete_ItemKeyword
585: (
586: p_api_version IN NUMBER,
587: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
588: p_commit IN VARCHAR2 := FND_API.G_FALSE,
589: x_return_status OUT NOCOPY VARCHAR2,
590: x_msg_count OUT NOCOPY NUMBER,
591: x_msg_data OUT NOCOPY VARCHAR2,

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

584: PROCEDURE Delete_ItemKeyword
585: (
586: p_api_version IN NUMBER,
587: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
588: p_commit IN VARCHAR2 := FND_API.G_FALSE,
589: x_return_status OUT NOCOPY VARCHAR2,
590: x_msg_count OUT NOCOPY NUMBER,
591: x_msg_data OUT NOCOPY VARCHAR2,
592: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

588: p_commit IN VARCHAR2 := FND_API.G_FALSE,
589: x_return_status OUT NOCOPY VARCHAR2,
590: x_msg_count OUT NOCOPY NUMBER,
591: x_msg_data OUT NOCOPY VARCHAR2,
592: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
593: p_item_id IN NUMBER,
594: p_keyword_varray IN AMV_CHAR_VARRAY_TYPE
595: );
596: -- Algorithm:

Line 625: -- Default = FND_API.G_FALSE

621: -- Function : Remove the passed keyword from the specified item.
622: -- Parameters :
623: -- IN p_api_version NUMBER Required
624: -- p_init_msg_list VARCHAR2 Optional
625: -- Default = FND_API.G_FALSE
626: -- p_commit VARCHAR2 Optional
627: -- Default = FND_API.G_FALSE
628: -- p_check_login_user VARCHAR2 Optional
629: -- Default = FND_API.G_TRUE

Line 627: -- Default = FND_API.G_FALSE

623: -- IN p_api_version NUMBER Required
624: -- p_init_msg_list VARCHAR2 Optional
625: -- Default = FND_API.G_FALSE
626: -- p_commit VARCHAR2 Optional
627: -- Default = FND_API.G_FALSE
628: -- p_check_login_user VARCHAR2 Optional
629: -- Default = FND_API.G_TRUE
630: -- Flag for checking user privilege and if user is login.
631: -- p_item_id NUMBER Required

Line 629: -- Default = FND_API.G_TRUE

625: -- Default = FND_API.G_FALSE
626: -- p_commit VARCHAR2 Optional
627: -- Default = FND_API.G_FALSE
628: -- p_check_login_user VARCHAR2 Optional
629: -- Default = FND_API.G_TRUE
630: -- Flag for checking user privilege and if user is login.
631: -- p_item_id NUMBER Required
632: -- The id of the item to remove the keyword from.
633: -- p_keyword VARCHAR2 Required

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

641: --
642: PROCEDURE Delete_ItemKeyword
643: (
644: p_api_version IN NUMBER,
645: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
646: p_commit IN VARCHAR2 := FND_API.G_FALSE,
647: x_return_status OUT NOCOPY VARCHAR2,
648: x_msg_count OUT NOCOPY NUMBER,
649: x_msg_data OUT NOCOPY VARCHAR2,

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

642: PROCEDURE Delete_ItemKeyword
643: (
644: p_api_version IN NUMBER,
645: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
646: p_commit IN VARCHAR2 := FND_API.G_FALSE,
647: x_return_status OUT NOCOPY VARCHAR2,
648: x_msg_count OUT NOCOPY NUMBER,
649: x_msg_data OUT NOCOPY VARCHAR2,
650: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

646: p_commit IN VARCHAR2 := FND_API.G_FALSE,
647: x_return_status OUT NOCOPY VARCHAR2,
648: x_msg_count OUT NOCOPY NUMBER,
649: x_msg_data OUT NOCOPY VARCHAR2,
650: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
651: p_item_id IN NUMBER,
652: p_keyword IN VARCHAR2
653: );
654: -- Algorithm:

Line 685: -- Default = FND_API.G_FALSE

681: -- and add the passed keywords to the item.
682: -- Parameters :
683: -- IN p_api_version NUMBER Required
684: -- p_init_msg_list VARCHAR2 Optional
685: -- Default = FND_API.G_FALSE
686: -- p_commit VARCHAR2 Optional
687: -- Default = FND_API.G_FALSE
688: -- p_check_login_user VARCHAR2 Optional
689: -- Default = FND_API.G_TRUE

Line 687: -- Default = FND_API.G_FALSE

683: -- IN p_api_version NUMBER Required
684: -- p_init_msg_list VARCHAR2 Optional
685: -- Default = FND_API.G_FALSE
686: -- p_commit VARCHAR2 Optional
687: -- Default = FND_API.G_FALSE
688: -- p_check_login_user VARCHAR2 Optional
689: -- Default = FND_API.G_TRUE
690: -- Flag for checking user privilege and if user is login.
691: -- p_item_id NUMBER Required

Line 689: -- Default = FND_API.G_TRUE

685: -- Default = FND_API.G_FALSE
686: -- p_commit VARCHAR2 Optional
687: -- Default = FND_API.G_FALSE
688: -- p_check_login_user VARCHAR2 Optional
689: -- Default = FND_API.G_TRUE
690: -- Flag for checking user privilege and if user is login.
691: -- p_item_id NUMBER Required
692: -- The item id to be add the keywords.
693: -- p_keyword_varray AMV_CHAR_VARRAY_TYPE

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

702: --
703: PROCEDURE Replace_ItemKeyword
704: (
705: p_api_version IN NUMBER,
706: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
707: p_commit IN VARCHAR2 := FND_API.G_FALSE,
708: x_return_status OUT NOCOPY VARCHAR2,
709: x_msg_count OUT NOCOPY NUMBER,
710: x_msg_data OUT NOCOPY VARCHAR2,

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

703: PROCEDURE Replace_ItemKeyword
704: (
705: p_api_version IN NUMBER,
706: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
707: p_commit IN VARCHAR2 := FND_API.G_FALSE,
708: x_return_status OUT NOCOPY VARCHAR2,
709: x_msg_count OUT NOCOPY NUMBER,
710: x_msg_data OUT NOCOPY VARCHAR2,
711: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

707: p_commit IN VARCHAR2 := FND_API.G_FALSE,
708: x_return_status OUT NOCOPY VARCHAR2,
709: x_msg_count OUT NOCOPY NUMBER,
710: x_msg_data OUT NOCOPY VARCHAR2,
711: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
712: p_item_id IN NUMBER,
713: p_keyword_varray IN AMV_CHAR_VARRAY_TYPE
714: );
715: -- Algorithm:

Line 730: -- Default = FND_API.G_FALSE

726: -- Function : Query and return all the keywords of the specified item
727: -- Parameters :
728: -- IN p_api_version NUMBER Required
729: -- p_init_msg_list VARCHAR2 Optional
730: -- Default = FND_API.G_FALSE
731: -- p_check_login_user VARCHAR2 Optional
732: -- Default = FND_API.G_TRUE
733: -- Flag for checking user privilege and if user is login.
734: -- p_item_id NUMBER Required

Line 732: -- Default = FND_API.G_TRUE

728: -- IN p_api_version NUMBER Required
729: -- p_init_msg_list VARCHAR2 Optional
730: -- Default = FND_API.G_FALSE
731: -- p_check_login_user VARCHAR2 Optional
732: -- Default = FND_API.G_TRUE
733: -- Flag for checking user privilege and if user is login.
734: -- p_item_id NUMBER Required
735: -- The item id to be add the keywords.
736: -- OUT : x_return_status VARCHAR2

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

744: --
745: PROCEDURE Get_ItemKeyword
746: (
747: p_api_version IN NUMBER,
748: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
749: x_return_status OUT NOCOPY VARCHAR2,
750: x_msg_count OUT NOCOPY NUMBER,
751: x_msg_data OUT NOCOPY VARCHAR2,
752: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

748: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
749: x_return_status OUT NOCOPY VARCHAR2,
750: x_msg_count OUT NOCOPY NUMBER,
751: x_msg_data OUT NOCOPY VARCHAR2,
752: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
753: p_item_id IN NUMBER,
754: x_keyword_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE
755: );
756: --

Line 781: -- Default = FND_API.G_FALSE

777: -- Function : Add the authors passed in the array to the specified item.
778: -- Parameters :
779: -- IN p_api_version NUMBER Required
780: -- p_init_msg_list VARCHAR2 Optional
781: -- Default = FND_API.G_FALSE
782: -- p_commit VARCHAR2 Optional
783: -- Default = FND_API.G_FALSE
784: -- p_check_login_user VARCHAR2 Optional
785: -- Default = FND_API.G_TRUE

Line 783: -- Default = FND_API.G_FALSE

779: -- IN p_api_version NUMBER Required
780: -- p_init_msg_list VARCHAR2 Optional
781: -- Default = FND_API.G_FALSE
782: -- p_commit VARCHAR2 Optional
783: -- Default = FND_API.G_FALSE
784: -- p_check_login_user VARCHAR2 Optional
785: -- Default = FND_API.G_TRUE
786: -- Flag for checking user privilege and if user is login.
787: -- p_item_id NUMBER Required

Line 785: -- Default = FND_API.G_TRUE

781: -- Default = FND_API.G_FALSE
782: -- p_commit VARCHAR2 Optional
783: -- Default = FND_API.G_FALSE
784: -- p_check_login_user VARCHAR2 Optional
785: -- Default = FND_API.G_TRUE
786: -- Flag for checking user privilege and if user is login.
787: -- p_item_id NUMBER Required
788: -- The item id to be add the authors.
789: -- p_author_varray AMV_CHAR_VARRAY_TYPE

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

798: --
799: PROCEDURE Add_ItemAuthor
800: (
801: p_api_version IN NUMBER,
802: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
803: p_commit IN VARCHAR2 := FND_API.G_FALSE,
804: x_return_status OUT NOCOPY VARCHAR2,
805: x_msg_count OUT NOCOPY NUMBER,
806: x_msg_data OUT NOCOPY VARCHAR2,

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

799: PROCEDURE Add_ItemAuthor
800: (
801: p_api_version IN NUMBER,
802: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
803: p_commit IN VARCHAR2 := FND_API.G_FALSE,
804: x_return_status OUT NOCOPY VARCHAR2,
805: x_msg_count OUT NOCOPY NUMBER,
806: x_msg_data OUT NOCOPY VARCHAR2,
807: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

803: p_commit IN VARCHAR2 := FND_API.G_FALSE,
804: x_return_status OUT NOCOPY VARCHAR2,
805: x_msg_count OUT NOCOPY NUMBER,
806: x_msg_data OUT NOCOPY VARCHAR2,
807: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
808: p_item_id IN NUMBER,
809: p_author_varray IN AMV_CHAR_VARRAY_TYPE
810: );
811: -- Algorithm:

Line 842: -- Default = FND_API.G_FALSE

838: -- Function : Add the specified author to the specified item.
839: -- Parameters :
840: -- IN p_api_version NUMBER Required
841: -- p_init_msg_list VARCHAR2 Optional
842: -- Default = FND_API.G_FALSE
843: -- p_commit VARCHAR2 Optional
844: -- Default = FND_API.G_FALSE
845: -- p_check_login_user VARCHAR2 Optional
846: -- Default = FND_API.G_TRUE

Line 844: -- Default = FND_API.G_FALSE

840: -- IN p_api_version NUMBER Required
841: -- p_init_msg_list VARCHAR2 Optional
842: -- Default = FND_API.G_FALSE
843: -- p_commit VARCHAR2 Optional
844: -- Default = FND_API.G_FALSE
845: -- p_check_login_user VARCHAR2 Optional
846: -- Default = FND_API.G_TRUE
847: -- Flag for checking user privilege and if user is login.
848: -- p_item_id NUMBER Required

Line 846: -- Default = FND_API.G_TRUE

842: -- Default = FND_API.G_FALSE
843: -- p_commit VARCHAR2 Optional
844: -- Default = FND_API.G_FALSE
845: -- p_check_login_user VARCHAR2 Optional
846: -- Default = FND_API.G_TRUE
847: -- Flag for checking user privilege and if user is login.
848: -- p_item_id NUMBER Required
849: -- The item id to be add the authors.
850: -- p_author VARCHAR2 Required

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

858: --
859: PROCEDURE Add_ItemAuthor
860: (
861: p_api_version IN NUMBER,
862: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
863: p_commit IN VARCHAR2 := FND_API.G_FALSE,
864: x_return_status OUT NOCOPY VARCHAR2,
865: x_msg_count OUT NOCOPY NUMBER,
866: x_msg_data OUT NOCOPY VARCHAR2,

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

859: PROCEDURE Add_ItemAuthor
860: (
861: p_api_version IN NUMBER,
862: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
863: p_commit IN VARCHAR2 := FND_API.G_FALSE,
864: x_return_status OUT NOCOPY VARCHAR2,
865: x_msg_count OUT NOCOPY NUMBER,
866: x_msg_data OUT NOCOPY VARCHAR2,
867: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

863: p_commit IN VARCHAR2 := FND_API.G_FALSE,
864: x_return_status OUT NOCOPY VARCHAR2,
865: x_msg_count OUT NOCOPY NUMBER,
866: x_msg_data OUT NOCOPY VARCHAR2,
867: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
868: p_item_id IN NUMBER,
869: p_author IN VARCHAR2
870: );
871: -- Algorithm:

Line 902: -- Default = FND_API.G_FALSE

898: -- from the specified item.
899: -- Parameters :
900: -- IN p_api_version NUMBER Required
901: -- p_init_msg_list VARCHAR2 Optional
902: -- Default = FND_API.G_FALSE
903: -- p_commit VARCHAR2 Optional
904: -- Default = FND_API.G_FALSE
905: -- p_check_login_user VARCHAR2 Optional
906: -- Default = FND_API.G_TRUE

Line 904: -- Default = FND_API.G_FALSE

900: -- IN p_api_version NUMBER Required
901: -- p_init_msg_list VARCHAR2 Optional
902: -- Default = FND_API.G_FALSE
903: -- p_commit VARCHAR2 Optional
904: -- Default = FND_API.G_FALSE
905: -- p_check_login_user VARCHAR2 Optional
906: -- Default = FND_API.G_TRUE
907: -- Flag for checking user privilege and if user is login.
908: -- p_item_id NUMBER Required

Line 906: -- Default = FND_API.G_TRUE

902: -- Default = FND_API.G_FALSE
903: -- p_commit VARCHAR2 Optional
904: -- Default = FND_API.G_FALSE
905: -- p_check_login_user VARCHAR2 Optional
906: -- Default = FND_API.G_TRUE
907: -- Flag for checking user privilege and if user is login.
908: -- p_item_id NUMBER Required
909: -- The item id to be add the authors.
910: -- p_author_varray AMV_CHAR_VARRAY_TYPE

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

919: --
920: PROCEDURE Delete_ItemAuthor
921: (
922: p_api_version IN NUMBER,
923: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
924: p_commit IN VARCHAR2 := FND_API.G_FALSE,
925: x_return_status OUT NOCOPY VARCHAR2,
926: x_msg_count OUT NOCOPY NUMBER,
927: x_msg_data OUT NOCOPY VARCHAR2,

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

920: PROCEDURE Delete_ItemAuthor
921: (
922: p_api_version IN NUMBER,
923: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
924: p_commit IN VARCHAR2 := FND_API.G_FALSE,
925: x_return_status OUT NOCOPY VARCHAR2,
926: x_msg_count OUT NOCOPY NUMBER,
927: x_msg_data OUT NOCOPY VARCHAR2,
928: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

924: p_commit IN VARCHAR2 := FND_API.G_FALSE,
925: x_return_status OUT NOCOPY VARCHAR2,
926: x_msg_count OUT NOCOPY NUMBER,
927: x_msg_data OUT NOCOPY VARCHAR2,
928: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
929: p_item_id IN NUMBER,
930: p_author_varray IN AMV_CHAR_VARRAY_TYPE
931: );
932: -- Algorithm:

Line 961: -- Default = FND_API.G_FALSE

957: -- Function : Remove the passed author from the specified item.
958: -- Parameters :
959: -- IN p_api_version NUMBER Required
960: -- p_init_msg_list VARCHAR2 Optional
961: -- Default = FND_API.G_FALSE
962: -- p_commit VARCHAR2 Optional
963: -- Default = FND_API.G_FALSE
964: -- p_check_login_user VARCHAR2 Optional
965: -- Default = FND_API.G_TRUE

Line 963: -- Default = FND_API.G_FALSE

959: -- IN p_api_version NUMBER Required
960: -- p_init_msg_list VARCHAR2 Optional
961: -- Default = FND_API.G_FALSE
962: -- p_commit VARCHAR2 Optional
963: -- Default = FND_API.G_FALSE
964: -- p_check_login_user VARCHAR2 Optional
965: -- Default = FND_API.G_TRUE
966: -- Flag for checking user privilege and if user is login.
967: -- p_item_id NUMBER Required

Line 965: -- Default = FND_API.G_TRUE

961: -- Default = FND_API.G_FALSE
962: -- p_commit VARCHAR2 Optional
963: -- Default = FND_API.G_FALSE
964: -- p_check_login_user VARCHAR2 Optional
965: -- Default = FND_API.G_TRUE
966: -- Flag for checking user privilege and if user is login.
967: -- p_item_id NUMBER Required
968: -- The item id to be add the author.
969: -- p_author VARCHAR2 Required

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

977: --
978: PROCEDURE Delete_ItemAuthor
979: (
980: p_api_version IN NUMBER,
981: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
982: p_commit IN VARCHAR2 := FND_API.G_FALSE,
983: x_return_status OUT NOCOPY VARCHAR2,
984: x_msg_count OUT NOCOPY NUMBER,
985: x_msg_data OUT NOCOPY VARCHAR2,

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

978: PROCEDURE Delete_ItemAuthor
979: (
980: p_api_version IN NUMBER,
981: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
982: p_commit IN VARCHAR2 := FND_API.G_FALSE,
983: x_return_status OUT NOCOPY VARCHAR2,
984: x_msg_count OUT NOCOPY NUMBER,
985: x_msg_data OUT NOCOPY VARCHAR2,
986: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

982: p_commit IN VARCHAR2 := FND_API.G_FALSE,
983: x_return_status OUT NOCOPY VARCHAR2,
984: x_msg_count OUT NOCOPY NUMBER,
985: x_msg_data OUT NOCOPY VARCHAR2,
986: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
987: p_item_id IN NUMBER,
988: p_author IN VARCHAR2
989: );
990: -- Algorithm:

Line 1021: -- Default = FND_API.G_FALSE

1017: -- and add the passed authors to the item.
1018: -- Parameters :
1019: -- IN p_api_version NUMBER Required
1020: -- p_init_msg_list VARCHAR2 Optional
1021: -- Default = FND_API.G_FALSE
1022: -- p_commit VARCHAR2 Optional
1023: -- Default = FND_API.G_FALSE
1024: -- p_check_login_user VARCHAR2 Optional
1025: -- Default = FND_API.G_TRUE

Line 1023: -- Default = FND_API.G_FALSE

1019: -- IN p_api_version NUMBER Required
1020: -- p_init_msg_list VARCHAR2 Optional
1021: -- Default = FND_API.G_FALSE
1022: -- p_commit VARCHAR2 Optional
1023: -- Default = FND_API.G_FALSE
1024: -- p_check_login_user VARCHAR2 Optional
1025: -- Default = FND_API.G_TRUE
1026: -- Flag for checking user privilege and if user is login.
1027: -- p_item_id NUMBER Required

Line 1025: -- Default = FND_API.G_TRUE

1021: -- Default = FND_API.G_FALSE
1022: -- p_commit VARCHAR2 Optional
1023: -- Default = FND_API.G_FALSE
1024: -- p_check_login_user VARCHAR2 Optional
1025: -- Default = FND_API.G_TRUE
1026: -- Flag for checking user privilege and if user is login.
1027: -- p_item_id NUMBER Required
1028: -- The item id to be add the authors.
1029: -- p_author_varray AMV_CHAR_VARRAY_TYPE

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

1038: --
1039: PROCEDURE Replace_ItemAuthor
1040: (
1041: p_api_version IN NUMBER,
1042: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1043: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1044: x_return_status OUT NOCOPY VARCHAR2,
1045: x_msg_count OUT NOCOPY NUMBER,
1046: x_msg_data OUT NOCOPY VARCHAR2,

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

1039: PROCEDURE Replace_ItemAuthor
1040: (
1041: p_api_version IN NUMBER,
1042: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1043: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1044: x_return_status OUT NOCOPY VARCHAR2,
1045: x_msg_count OUT NOCOPY NUMBER,
1046: x_msg_data OUT NOCOPY VARCHAR2,
1047: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

1043: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1044: x_return_status OUT NOCOPY VARCHAR2,
1045: x_msg_count OUT NOCOPY NUMBER,
1046: x_msg_data OUT NOCOPY VARCHAR2,
1047: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1048: p_item_id IN NUMBER,
1049: p_author_varray IN AMV_CHAR_VARRAY_TYPE
1050: );
1051: -- Algorithm:

Line 1066: -- Default = FND_API.G_FALSE

1062: -- Function : Query and return all the authors of the specified item
1063: -- Parameters :
1064: -- IN p_api_version NUMBER Required
1065: -- p_init_msg_list VARCHAR2 Optional
1066: -- Default = FND_API.G_FALSE
1067: -- p_check_login_user VARCHAR2 Optional
1068: -- Default = FND_API.G_TRUE
1069: -- Flag for checking user privilege and if user is login.
1070: -- p_item_id NUMBER Required

Line 1068: -- Default = FND_API.G_TRUE

1064: -- IN p_api_version NUMBER Required
1065: -- p_init_msg_list VARCHAR2 Optional
1066: -- Default = FND_API.G_FALSE
1067: -- p_check_login_user VARCHAR2 Optional
1068: -- Default = FND_API.G_TRUE
1069: -- Flag for checking user privilege and if user is login.
1070: -- p_item_id NUMBER Required
1071: -- The item id to be add the authors.
1072: -- OUT : x_return_status VARCHAR2

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

1080: --
1081: PROCEDURE Get_ItemAuthor
1082: (
1083: p_api_version IN NUMBER,
1084: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1085: x_return_status OUT NOCOPY VARCHAR2,
1086: x_msg_count OUT NOCOPY NUMBER,
1087: x_msg_data OUT NOCOPY VARCHAR2,
1088: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

1084: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1085: x_return_status OUT NOCOPY VARCHAR2,
1086: x_msg_count OUT NOCOPY NUMBER,
1087: x_msg_data OUT NOCOPY VARCHAR2,
1088: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1089: p_item_id IN NUMBER,
1090: x_author_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE
1091: );
1092: --

Line 1117: -- Default = FND_API.G_FALSE

1113: -- Function : Add the files passed in the id array to the specified item.
1114: -- Parameters :
1115: -- IN p_api_version NUMBER Required
1116: -- p_init_msg_list VARCHAR2 Optional
1117: -- Default = FND_API.G_FALSE
1118: -- p_commit VARCHAR2 Optional
1119: -- Default = FND_API.G_FALSE
1120: -- p_check_login_user VARCHAR2 Optional
1121: -- Default = FND_API.G_TRUE

Line 1119: -- Default = FND_API.G_FALSE

1115: -- IN p_api_version NUMBER Required
1116: -- p_init_msg_list VARCHAR2 Optional
1117: -- Default = FND_API.G_FALSE
1118: -- p_commit VARCHAR2 Optional
1119: -- Default = FND_API.G_FALSE
1120: -- p_check_login_user VARCHAR2 Optional
1121: -- Default = FND_API.G_TRUE
1122: -- Flag for checking user privilege and if user is login.
1123: -- p_application_id NUMBER Optional

Line 1121: -- Default = FND_API.G_TRUE

1117: -- Default = FND_API.G_FALSE
1118: -- p_commit VARCHAR2 Optional
1119: -- Default = FND_API.G_FALSE
1120: -- p_check_login_user VARCHAR2 Optional
1121: -- Default = FND_API.G_TRUE
1122: -- Flag for checking user privilege and if user is login.
1123: -- p_application_id NUMBER Optional
1124: -- The id of application that attaches the file to item.
1125: -- Default to AMV_UTILITY_PVT.G_AMV_APP_ID (520)

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

1137: --
1138: PROCEDURE Add_ItemFile
1139: (
1140: p_api_version IN NUMBER,
1141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1143: x_return_status OUT NOCOPY VARCHAR2,
1144: x_msg_count OUT NOCOPY NUMBER,
1145: x_msg_data OUT NOCOPY VARCHAR2,

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

1138: PROCEDURE Add_ItemFile
1139: (
1140: p_api_version IN NUMBER,
1141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1143: x_return_status OUT NOCOPY VARCHAR2,
1144: x_msg_count OUT NOCOPY NUMBER,
1145: x_msg_data OUT NOCOPY VARCHAR2,
1146: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

1142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1143: x_return_status OUT NOCOPY VARCHAR2,
1144: x_msg_count OUT NOCOPY NUMBER,
1145: x_msg_data OUT NOCOPY VARCHAR2,
1146: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1147: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1148: p_item_id IN NUMBER,
1149: p_file_id_varray IN AMV_NUMBER_VARRAY_TYPE
1150: );

Line 1182: -- Default = FND_API.G_FALSE

1178: -- Function : Add the specified file to the specified item.
1179: -- Parameters :
1180: -- IN p_api_version NUMBER Required
1181: -- p_init_msg_list VARCHAR2 Optional
1182: -- Default = FND_API.G_FALSE
1183: -- p_commit VARCHAR2 Optional
1184: -- Default = FND_API.G_FALSE
1185: -- p_check_login_user VARCHAR2 Optional
1186: -- Default = FND_API.G_TRUE

Line 1184: -- Default = FND_API.G_FALSE

1180: -- IN p_api_version NUMBER Required
1181: -- p_init_msg_list VARCHAR2 Optional
1182: -- Default = FND_API.G_FALSE
1183: -- p_commit VARCHAR2 Optional
1184: -- Default = FND_API.G_FALSE
1185: -- p_check_login_user VARCHAR2 Optional
1186: -- Default = FND_API.G_TRUE
1187: -- Flag for checking user privilege and if user is login.
1188: -- p_application_id NUMBER Optional

Line 1186: -- Default = FND_API.G_TRUE

1182: -- Default = FND_API.G_FALSE
1183: -- p_commit VARCHAR2 Optional
1184: -- Default = FND_API.G_FALSE
1185: -- p_check_login_user VARCHAR2 Optional
1186: -- Default = FND_API.G_TRUE
1187: -- Flag for checking user privilege and if user is login.
1188: -- p_application_id NUMBER Optional
1189: -- The id of application that attaches the file to item.
1190: -- Default to AMV_UTILITY_PVT.G_AMV_APP_ID (520)

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

1201: --
1202: PROCEDURE Add_ItemFile
1203: (
1204: p_api_version IN NUMBER,
1205: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1206: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1207: x_return_status OUT NOCOPY VARCHAR2,
1208: x_msg_count OUT NOCOPY NUMBER,
1209: x_msg_data OUT NOCOPY VARCHAR2,

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

1202: PROCEDURE Add_ItemFile
1203: (
1204: p_api_version IN NUMBER,
1205: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1206: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1207: x_return_status OUT NOCOPY VARCHAR2,
1208: x_msg_count OUT NOCOPY NUMBER,
1209: x_msg_data OUT NOCOPY VARCHAR2,
1210: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

1206: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1207: x_return_status OUT NOCOPY VARCHAR2,
1208: x_msg_count OUT NOCOPY NUMBER,
1209: x_msg_data OUT NOCOPY VARCHAR2,
1210: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1211: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
1212: p_item_id IN NUMBER,
1213: p_file_id IN NUMBER
1214: );

Line 1247: -- Default = FND_API.G_FALSE

1243: -- from the specified item.
1244: -- Parameters :
1245: -- IN p_api_version NUMBER Required
1246: -- p_init_msg_list VARCHAR2 Optional
1247: -- Default = FND_API.G_FALSE
1248: -- p_commit VARCHAR2 Optional
1249: -- Default = FND_API.G_FALSE
1250: -- p_check_login_user VARCHAR2 Optional
1251: -- Default = FND_API.G_TRUE

Line 1249: -- Default = FND_API.G_FALSE

1245: -- IN p_api_version NUMBER Required
1246: -- p_init_msg_list VARCHAR2 Optional
1247: -- Default = FND_API.G_FALSE
1248: -- p_commit VARCHAR2 Optional
1249: -- Default = FND_API.G_FALSE
1250: -- p_check_login_user VARCHAR2 Optional
1251: -- Default = FND_API.G_TRUE
1252: -- Flag for checking user privilege and if user is login.
1253: -- p_item_id NUMBER Required

Line 1251: -- Default = FND_API.G_TRUE

1247: -- Default = FND_API.G_FALSE
1248: -- p_commit VARCHAR2 Optional
1249: -- Default = FND_API.G_FALSE
1250: -- p_check_login_user VARCHAR2 Optional
1251: -- Default = FND_API.G_TRUE
1252: -- Flag for checking user privilege and if user is login.
1253: -- p_item_id NUMBER Required
1254: -- The id of the item to be add the files to.
1255: -- p_file_id_varray AMV_NUMBER_VARRAY_TYPE

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

1264: --
1265: PROCEDURE Delete_ItemFile
1266: (
1267: p_api_version IN NUMBER,
1268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1270: x_return_status OUT NOCOPY VARCHAR2,
1271: x_msg_count OUT NOCOPY NUMBER,
1272: x_msg_data OUT NOCOPY VARCHAR2,

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

1265: PROCEDURE Delete_ItemFile
1266: (
1267: p_api_version IN NUMBER,
1268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1270: x_return_status OUT NOCOPY VARCHAR2,
1271: x_msg_count OUT NOCOPY NUMBER,
1272: x_msg_data OUT NOCOPY VARCHAR2,
1273: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

1269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1270: x_return_status OUT NOCOPY VARCHAR2,
1271: x_msg_count OUT NOCOPY NUMBER,
1272: x_msg_data OUT NOCOPY VARCHAR2,
1273: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1274: p_item_id IN NUMBER,
1275: p_file_id_varray IN AMV_NUMBER_VARRAY_TYPE
1276: );
1277: -- Algorithm:

Line 1306: -- Default = FND_API.G_FALSE

1302: -- Function : Remove the passed file from the specified item.
1303: -- Parameters :
1304: -- IN p_api_version NUMBER Required
1305: -- p_init_msg_list VARCHAR2 Optional
1306: -- Default = FND_API.G_FALSE
1307: -- p_commit VARCHAR2 Optional
1308: -- Default = FND_API.G_FALSE
1309: -- p_check_login_user VARCHAR2 Optional
1310: -- Default = FND_API.G_TRUE

Line 1308: -- Default = FND_API.G_FALSE

1304: -- IN p_api_version NUMBER Required
1305: -- p_init_msg_list VARCHAR2 Optional
1306: -- Default = FND_API.G_FALSE
1307: -- p_commit VARCHAR2 Optional
1308: -- Default = FND_API.G_FALSE
1309: -- p_check_login_user VARCHAR2 Optional
1310: -- Default = FND_API.G_TRUE
1311: -- Flag for checking user privilege and if user is login.
1312: -- p_item_id NUMBER Required

Line 1310: -- Default = FND_API.G_TRUE

1306: -- Default = FND_API.G_FALSE
1307: -- p_commit VARCHAR2 Optional
1308: -- Default = FND_API.G_FALSE
1309: -- p_check_login_user VARCHAR2 Optional
1310: -- Default = FND_API.G_TRUE
1311: -- Flag for checking user privilege and if user is login.
1312: -- p_item_id NUMBER Required
1313: -- The id of item to remove the file from.
1314: -- p_file_id NUMBER Required

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

1322: --
1323: PROCEDURE Delete_ItemFile
1324: (
1325: p_api_version IN NUMBER,
1326: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1327: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1328: x_return_status OUT NOCOPY VARCHAR2,
1329: x_msg_count OUT NOCOPY NUMBER,
1330: x_msg_data OUT NOCOPY VARCHAR2,

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

1323: PROCEDURE Delete_ItemFile
1324: (
1325: p_api_version IN NUMBER,
1326: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1327: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1328: x_return_status OUT NOCOPY VARCHAR2,
1329: x_msg_count OUT NOCOPY NUMBER,
1330: x_msg_data OUT NOCOPY VARCHAR2,
1331: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

1327: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1328: x_return_status OUT NOCOPY VARCHAR2,
1329: x_msg_count OUT NOCOPY NUMBER,
1330: x_msg_data OUT NOCOPY VARCHAR2,
1331: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1332: p_item_id IN NUMBER,
1333: p_file_id IN NUMBER
1334: );
1335: -- Algorithm:

Line 1366: -- Default = FND_API.G_FALSE

1362: -- and add the passed files to the item.
1363: -- Parameters :
1364: -- IN p_api_version NUMBER Required
1365: -- p_init_msg_list VARCHAR2 Optional
1366: -- Default = FND_API.G_FALSE
1367: -- p_commit VARCHAR2 Optional
1368: -- Default = FND_API.G_FALSE
1369: -- p_check_login_user VARCHAR2 Optional
1370: -- Default = FND_API.G_TRUE

Line 1368: -- Default = FND_API.G_FALSE

1364: -- IN p_api_version NUMBER Required
1365: -- p_init_msg_list VARCHAR2 Optional
1366: -- Default = FND_API.G_FALSE
1367: -- p_commit VARCHAR2 Optional
1368: -- Default = FND_API.G_FALSE
1369: -- p_check_login_user VARCHAR2 Optional
1370: -- Default = FND_API.G_TRUE
1371: -- Flag for checking user privilege and if user is login.
1372: -- p_item_id NUMBER Required

Line 1370: -- Default = FND_API.G_TRUE

1366: -- Default = FND_API.G_FALSE
1367: -- p_commit VARCHAR2 Optional
1368: -- Default = FND_API.G_FALSE
1369: -- p_check_login_user VARCHAR2 Optional
1370: -- Default = FND_API.G_TRUE
1371: -- Flag for checking user privilege and if user is login.
1372: -- p_item_id NUMBER Required
1373: -- The id of item to remove the file from.
1374: -- p_file_id_varray AMV_NUMBER_VARRAY_TYPE

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

1383: --
1384: PROCEDURE Replace_ItemFile
1385: (
1386: p_api_version IN NUMBER,
1387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1389: x_return_status OUT NOCOPY VARCHAR2,
1390: x_msg_count OUT NOCOPY NUMBER,
1391: x_msg_data OUT NOCOPY VARCHAR2,

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

1384: PROCEDURE Replace_ItemFile
1385: (
1386: p_api_version IN NUMBER,
1387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1389: x_return_status OUT NOCOPY VARCHAR2,
1390: x_msg_count OUT NOCOPY NUMBER,
1391: x_msg_data OUT NOCOPY VARCHAR2,
1392: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

1388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1389: x_return_status OUT NOCOPY VARCHAR2,
1390: x_msg_count OUT NOCOPY NUMBER,
1391: x_msg_data OUT NOCOPY VARCHAR2,
1392: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1393: p_item_id IN NUMBER,
1394: p_file_id_varray IN AMV_NUMBER_VARRAY_TYPE
1395: );
1396: -- Algorithm:

Line 1411: -- Default = FND_API.G_FALSE

1407: -- Function : Query and return all the files of the specified item
1408: -- Parameters :
1409: -- IN p_api_version NUMBER Required
1410: -- p_init_msg_list VARCHAR2 Optional
1411: -- Default = FND_API.G_FALSE
1412: -- p_check_login_user VARCHAR2 Optional
1413: -- Default = FND_API.G_TRUE
1414: -- Flag for checking user privilege and if user is login.
1415: -- p_item_id NUMBER Required

Line 1413: -- Default = FND_API.G_TRUE

1409: -- IN p_api_version NUMBER Required
1410: -- p_init_msg_list VARCHAR2 Optional
1411: -- Default = FND_API.G_FALSE
1412: -- p_check_login_user VARCHAR2 Optional
1413: -- Default = FND_API.G_TRUE
1414: -- Flag for checking user privilege and if user is login.
1415: -- p_item_id NUMBER Required
1416: -- The item id to be add the files.
1417: -- OUT : x_return_status VARCHAR2

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

1425: --
1426: PROCEDURE Get_ItemFile
1427: (
1428: p_api_version IN NUMBER,
1429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1430: x_return_status OUT NOCOPY VARCHAR2,
1431: x_msg_count OUT NOCOPY NUMBER,
1432: x_msg_data OUT NOCOPY VARCHAR2,
1433: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

1429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1430: x_return_status OUT NOCOPY VARCHAR2,
1431: x_msg_count OUT NOCOPY NUMBER,
1432: x_msg_data OUT NOCOPY VARCHAR2,
1433: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1434: p_item_id IN NUMBER,
1435: x_file_id_varray OUT NOCOPY AMV_NUMBER_VARRAY_TYPE
1436: );
1437: --

Line 1462: -- Default = FND_API.G_FALSE

1458: -- Function : return all the messages(id and name) for the specified user.
1459: -- Parameters :
1460: -- IN p_api_version NUMBER Required
1461: -- p_init_msg_list VARCHAR2 Optional
1462: -- Default = FND_API.G_FALSE
1463: -- p_check_login_user VARCHAR2 Optional
1464: -- Default = FND_API.G_TRUE
1465: -- Flag for checking user privilege and if user is login.
1466: -- p_user_id NUMBER Required

Line 1464: -- Default = FND_API.G_TRUE

1460: -- IN p_api_version NUMBER Required
1461: -- p_init_msg_list VARCHAR2 Optional
1462: -- Default = FND_API.G_FALSE
1463: -- p_check_login_user VARCHAR2 Optional
1464: -- Default = FND_API.G_TRUE
1465: -- Flag for checking user privilege and if user is login.
1466: -- p_user_id NUMBER Required
1467: -- The should be the resource id.
1468: -- OUT : x_return_status VARCHAR2

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

1476: --
1477: PROCEDURE Get_UserMessage
1478: (
1479: p_api_version IN NUMBER,
1480: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1481: x_return_status OUT NOCOPY VARCHAR2,
1482: x_msg_count OUT NOCOPY NUMBER,
1483: x_msg_data OUT NOCOPY VARCHAR2,
1484: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

1480: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1481: x_return_status OUT NOCOPY VARCHAR2,
1482: x_msg_count OUT NOCOPY NUMBER,
1483: x_msg_data OUT NOCOPY VARCHAR2,
1484: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1485: p_user_id IN NUMBER,
1486: x_item_id_varray OUT NOCOPY AMV_NUMBER_VARRAY_TYPE,
1487: x_message_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE
1488: );

Line 1499: -- Default = FND_API.G_FALSE

1495: -- Function : return all the messages(all info) for the specified user.
1496: -- Parameters :
1497: -- IN p_api_version NUMBER Required
1498: -- p_init_msg_list VARCHAR2 Optional
1499: -- Default = FND_API.G_FALSE
1500: -- p_check_login_user VARCHAR2 Optional
1501: -- Default = FND_API.G_TRUE
1502: -- Flag for checking user privilege and if user is login.
1503: -- p_user_id NUMBER Required

Line 1501: -- Default = FND_API.G_TRUE

1497: -- IN p_api_version NUMBER Required
1498: -- p_init_msg_list VARCHAR2 Optional
1499: -- Default = FND_API.G_FALSE
1500: -- p_check_login_user VARCHAR2 Optional
1501: -- Default = FND_API.G_TRUE
1502: -- Flag for checking user privilege and if user is login.
1503: -- p_user_id NUMBER Required
1504: -- The should be the resource id.
1505: -- OUT : x_return_status VARCHAR2

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

1512: --
1513: PROCEDURE Get_UserMessage2
1514: (
1515: p_api_version IN NUMBER,
1516: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1517: x_return_status OUT NOCOPY VARCHAR2,
1518: x_msg_count OUT NOCOPY NUMBER,
1519: x_msg_data OUT NOCOPY VARCHAR2,
1520: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

1516: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1517: x_return_status OUT NOCOPY VARCHAR2,
1518: x_msg_count OUT NOCOPY NUMBER,
1519: x_msg_data OUT NOCOPY VARCHAR2,
1520: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1521: p_user_id IN NUMBER,
1522: x_item_varray OUT NOCOPY AMV_SIMPLE_ITEM_OBJ_VARRAY
1523: );
1524: --------------------------------------------------------------------------------

Line 1534: -- Default = FND_API.G_FALSE

1530: -- Function : Query and return all the channels matched the specified item
1531: -- Parameters :
1532: -- IN p_api_version NUMBER Required
1533: -- p_init_msg_list VARCHAR2 Optional
1534: -- Default = FND_API.G_FALSE
1535: -- p_check_login_user VARCHAR2 Optional
1536: -- Default = FND_API.G_TRUE
1537: -- Flag for checking user privilege and if user is login.
1538: -- p_match_type VARCHAR2 Optional

Line 1536: -- Default = FND_API.G_TRUE

1532: -- IN p_api_version NUMBER Required
1533: -- p_init_msg_list VARCHAR2 Optional
1534: -- Default = FND_API.G_FALSE
1535: -- p_check_login_user VARCHAR2 Optional
1536: -- Default = FND_API.G_TRUE
1537: -- Flag for checking user privilege and if user is login.
1538: -- p_match_type VARCHAR2 Optional
1539: -- p_item_id NUMBER Required
1540: -- The item id to be add the files.

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

1549: --
1550: PROCEDURE Get_ChannelsPerItem
1551: (
1552: p_api_version IN NUMBER,
1553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1554: x_return_status OUT NOCOPY VARCHAR2,
1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

1553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1554: x_return_status OUT NOCOPY VARCHAR2,
1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1558: p_item_id IN NUMBER,
1559: p_match_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1560: x_channel_array OUT NOCOPY AMV_NAMEID_VARRAY_TYPE
1561: );

Line 1559: p_match_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1558: p_item_id IN NUMBER,
1559: p_match_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1560: x_channel_array OUT NOCOPY AMV_NAMEID_VARRAY_TYPE
1561: );
1562: --
1563: -- Algorithm: