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.JTF_AMV_ITEM_PUB dependencies on FND_API

Line 93: -- Default = FND_API.G_FALSE

89: -- Function : Create a new item given the item information.
90: -- Parameters :
91: -- IN p_api_version NUMBER Required
92: -- p_init_msg_list VARCHAR2 Optional
93: -- Default = FND_API.G_FALSE
94: -- p_commit VARCHAR2 Optional
95: -- Default = FND_API.G_FALSE
96: -- p_item_rec ITEM_REC_TYPE,
97: -- Required

Line 95: -- Default = FND_API.G_FALSE

91: -- IN p_api_version NUMBER Required
92: -- p_init_msg_list VARCHAR2 Optional
93: -- Default = FND_API.G_FALSE
94: -- p_commit VARCHAR2 Optional
95: -- Default = FND_API.G_FALSE
96: -- p_item_rec ITEM_REC_TYPE,
97: -- Required
98: -- OUT : x_return_status VARCHAR2
99: -- x_msg_count NUMBER

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

106: --
107: PROCEDURE Create_Item
108: (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,

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

107: PROCEDURE Create_Item
108: (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_item_rec IN ITEM_REC_TYPE,

Line 138: -- Default = FND_API.G_FALSE

134: -- Function : Delete the item given the item id from database.
135: -- Parameters :
136: -- IN p_api_version NUMBER Required
137: -- p_init_msg_list VARCHAR2 Optional
138: -- Default = FND_API.G_FALSE
139: -- p_commit VARCHAR2 Optional
140: -- Default = FND_API.G_FALSE
141: -- p_item_id NUMBER Required
142: -- OUT : x_return_status VARCHAR2

Line 140: -- Default = FND_API.G_FALSE

136: -- IN p_api_version NUMBER Required
137: -- p_init_msg_list VARCHAR2 Optional
138: -- Default = FND_API.G_FALSE
139: -- p_commit VARCHAR2 Optional
140: -- Default = FND_API.G_FALSE
141: -- p_item_id NUMBER Required
142: -- OUT : x_return_status VARCHAR2
143: -- x_msg_count NUMBER
144: -- x_msg_data VARCHAR2

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

148: --
149: PROCEDURE Delete_Item
150: (
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,

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

149: PROCEDURE Delete_Item
150: (
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_item_id IN NUMBER

Line 178: -- Default = FND_API.G_FALSE

174: -- Function : Update the item based on the passed item record information.
175: -- Parameters :
176: -- IN p_api_version NUMBER Required
177: -- p_init_msg_list VARCHAR2 Optional
178: -- Default = FND_API.G_FALSE
179: -- p_commit VARCHAR2 Optional
180: -- Default = FND_API.G_FALSE
181: -- p_item_rec ITEM_REC_TYPE
182: -- The record for the new data of the item. Required

Line 180: -- Default = FND_API.G_FALSE

176: -- IN p_api_version NUMBER Required
177: -- p_init_msg_list VARCHAR2 Optional
178: -- Default = FND_API.G_FALSE
179: -- p_commit VARCHAR2 Optional
180: -- Default = FND_API.G_FALSE
181: -- p_item_rec ITEM_REC_TYPE
182: -- The record for the new data of the item. Required
183: -- OUT : x_return_status VARCHAR2
184: -- x_msg_count NUMBER

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

189: --
190: PROCEDURE Update_Item
191: (
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,

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

190: PROCEDURE Update_Item
191: (
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_item_rec IN ITEM_REC_TYPE

Line 220: -- Default = FND_API.G_FALSE

216: -- Function : Get an item information given the item id.
217: -- Parameters :
218: -- IN p_api_version NUMBER Required
219: -- p_init_msg_list VARCHAR2 Optional
220: -- Default = FND_API.G_FALSE
221: -- p_item_id NUMBER Required
222: -- OUT : x_return_status VARCHAR2
223: -- x_msg_count NUMBER
224: -- x_msg_data VARCHAR2

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

229: --
230: PROCEDURE Get_Item
231: (
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_item_id IN NUMBER,

Line 256: -- Default = FND_API.G_FALSE

252: -- Function : Add the keywords passed in the table to the specified item.
253: -- Parameters :
254: -- IN p_api_version NUMBER Required
255: -- p_init_msg_list VARCHAR2 Optional
256: -- Default = FND_API.G_FALSE
257: -- p_commit VARCHAR2 Optional
258: -- Default = FND_API.G_FALSE
259: -- p_item_id NUMBER Required
260: -- The item id to be add the keywords.

Line 258: -- Default = FND_API.G_FALSE

254: -- IN p_api_version NUMBER Required
255: -- p_init_msg_list VARCHAR2 Optional
256: -- Default = FND_API.G_FALSE
257: -- p_commit VARCHAR2 Optional
258: -- Default = FND_API.G_FALSE
259: -- p_item_id NUMBER Required
260: -- The item id to be add the keywords.
261: -- p_keyword_tab CHAR_TAB_TYPE
262: -- The keywords table Required

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

269: --
270: PROCEDURE Add_ItemKeyword
271: (
272: p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,

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

270: PROCEDURE Add_ItemKeyword
271: (
272: p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_item_id IN NUMBER,

Line 300: -- Default = FND_API.G_FALSE

296: -- Function : Add the keyword to the specified item.
297: -- Parameters :
298: -- IN p_api_version NUMBER Required
299: -- p_init_msg_list VARCHAR2 Optional
300: -- Default = FND_API.G_FALSE
301: -- p_commit VARCHAR2 Optional
302: -- Default = FND_API.G_FALSE
303: -- p_item_id NUMBER Required
304: -- The item id to be add the keyword.

Line 302: -- Default = FND_API.G_FALSE

298: -- IN p_api_version NUMBER Required
299: -- p_init_msg_list VARCHAR2 Optional
300: -- Default = FND_API.G_FALSE
301: -- p_commit VARCHAR2 Optional
302: -- Default = FND_API.G_FALSE
303: -- p_item_id NUMBER Required
304: -- The item id to be add the keyword.
305: -- p_keyword VARCHAR2 Required
306: -- The keyword to be added to the item.

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

313: --
314: PROCEDURE Add_ItemKeyword
315: (
316: p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE,
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,

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

314: PROCEDURE Add_ItemKeyword
315: (
316: p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_FALSE,
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
322: p_item_id IN NUMBER,

Line 344: -- Default = FND_API.G_FALSE

340: -- from the specified item.
341: -- Parameters :
342: -- IN p_api_version NUMBER Required
343: -- p_init_msg_list VARCHAR2 Optional
344: -- Default = FND_API.G_FALSE
345: -- p_commit VARCHAR2 Optional
346: -- Default = FND_API.G_FALSE
347: -- p_item_id NUMBER Required
348: -- The item id to be add the keywords.

Line 346: -- Default = FND_API.G_FALSE

342: -- IN p_api_version NUMBER Required
343: -- p_init_msg_list VARCHAR2 Optional
344: -- Default = FND_API.G_FALSE
345: -- p_commit VARCHAR2 Optional
346: -- Default = FND_API.G_FALSE
347: -- p_item_id NUMBER Required
348: -- The item id to be add the keywords.
349: -- p_keyword_tab CHAR_TAB_TYPE
350: -- The keywords table Required

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

357: --
358: PROCEDURE Delete_ItemKeyword
359: (
360: p_api_version IN NUMBER,
361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362: p_commit IN VARCHAR2 := FND_API.G_FALSE,
363: x_return_status OUT NOCOPY VARCHAR2,
364: x_msg_count OUT NOCOPY NUMBER,
365: x_msg_data OUT NOCOPY VARCHAR2,

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

358: PROCEDURE Delete_ItemKeyword
359: (
360: p_api_version IN NUMBER,
361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362: p_commit IN VARCHAR2 := FND_API.G_FALSE,
363: x_return_status OUT NOCOPY VARCHAR2,
364: x_msg_count OUT NOCOPY NUMBER,
365: x_msg_data OUT NOCOPY VARCHAR2,
366: p_item_id IN NUMBER,

Line 386: -- Default = FND_API.G_FALSE

382: -- Function : Remove the passed keyword from the specified item.
383: -- Parameters :
384: -- IN p_api_version NUMBER Required
385: -- p_init_msg_list VARCHAR2 Optional
386: -- Default = FND_API.G_FALSE
387: -- p_commit VARCHAR2 Optional
388: -- Default = FND_API.G_FALSE
389: -- p_item_id NUMBER Required
390: -- The id of the item to remove the keyword from.

Line 388: -- Default = FND_API.G_FALSE

384: -- IN p_api_version NUMBER Required
385: -- p_init_msg_list VARCHAR2 Optional
386: -- Default = FND_API.G_FALSE
387: -- p_commit VARCHAR2 Optional
388: -- Default = FND_API.G_FALSE
389: -- p_item_id NUMBER Required
390: -- The id of the item to remove the keyword from.
391: -- p_keyword VARCHAR2 Required
392: -- The keyword to be removed.

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

399: --
400: PROCEDURE Delete_ItemKeyword
401: (
402: p_api_version IN NUMBER,
403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
404: p_commit IN VARCHAR2 := FND_API.G_FALSE,
405: x_return_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2,

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

400: PROCEDURE Delete_ItemKeyword
401: (
402: p_api_version IN NUMBER,
403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
404: p_commit IN VARCHAR2 := FND_API.G_FALSE,
405: x_return_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2,
408: p_item_id IN NUMBER,

Line 434: -- Default = FND_API.G_FALSE

430: -- and add the passed keywords to the item.
431: -- Parameters :
432: -- IN p_api_version NUMBER Required
433: -- p_init_msg_list VARCHAR2 Optional
434: -- Default = FND_API.G_FALSE
435: -- p_commit VARCHAR2 Optional
436: -- Default = FND_API.G_FALSE
437: -- p_item_id NUMBER Required
438: -- The item id to be added the keywords.

Line 436: -- Default = FND_API.G_FALSE

432: -- IN p_api_version NUMBER Required
433: -- p_init_msg_list VARCHAR2 Optional
434: -- Default = FND_API.G_FALSE
435: -- p_commit VARCHAR2 Optional
436: -- Default = FND_API.G_FALSE
437: -- p_item_id NUMBER Required
438: -- The item id to be added the keywords.
439: -- p_keyword_tab CHAR_TAB_TYPE
440: -- The keywords table Required

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

447: --
448: PROCEDURE Replace_ItemKeyword
449: (
450: p_api_version IN NUMBER,
451: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
452: p_commit IN VARCHAR2 := FND_API.G_FALSE,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,

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

448: PROCEDURE Replace_ItemKeyword
449: (
450: p_api_version IN NUMBER,
451: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
452: p_commit IN VARCHAR2 := FND_API.G_FALSE,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,
456: p_item_id IN NUMBER,

Line 474: -- Default = FND_API.G_FALSE

470: -- Function : Query and return all the keywords of the specified item
471: -- Parameters :
472: -- IN p_api_version NUMBER Required
473: -- p_init_msg_list VARCHAR2 Optional
474: -- Default = FND_API.G_FALSE
475: -- p_item_id NUMBER Required
476: -- OUT : x_return_status VARCHAR2
477: -- x_msg_count NUMBER
478: -- x_msg_data VARCHAR2

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

484: --
485: PROCEDURE Get_ItemKeyword
486: (
487: p_api_version IN NUMBER,
488: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
489: x_return_status OUT NOCOPY VARCHAR2,
490: x_msg_count OUT NOCOPY NUMBER,
491: x_msg_data OUT NOCOPY VARCHAR2,
492: p_item_id IN NUMBER,

Line 516: -- Default = FND_API.G_FALSE

512: -- Function : Add the authors passed in the table to the specified item.
513: -- Parameters :
514: -- IN p_api_version NUMBER Required
515: -- p_init_msg_list VARCHAR2 Optional
516: -- Default = FND_API.G_FALSE
517: -- p_commit VARCHAR2 Optional
518: -- Default = FND_API.G_FALSE
519: -- p_item_id NUMBER Required
520: -- The item id to be add the authors.

Line 518: -- Default = FND_API.G_FALSE

514: -- IN p_api_version NUMBER Required
515: -- p_init_msg_list VARCHAR2 Optional
516: -- Default = FND_API.G_FALSE
517: -- p_commit VARCHAR2 Optional
518: -- Default = FND_API.G_FALSE
519: -- p_item_id NUMBER Required
520: -- The item id to be add the authors.
521: -- p_author_tab CHAR_TAB_TYPE
522: -- The authors table Required

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

529: --
530: PROCEDURE Add_ItemAuthor
531: (
532: p_api_version IN NUMBER,
533: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
534: p_commit IN VARCHAR2 := FND_API.G_FALSE,
535: x_return_status OUT NOCOPY VARCHAR2,
536: x_msg_count OUT NOCOPY NUMBER,
537: x_msg_data OUT NOCOPY VARCHAR2,

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

530: PROCEDURE Add_ItemAuthor
531: (
532: p_api_version IN NUMBER,
533: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
534: p_commit IN VARCHAR2 := FND_API.G_FALSE,
535: x_return_status OUT NOCOPY VARCHAR2,
536: x_msg_count OUT NOCOPY NUMBER,
537: x_msg_data OUT NOCOPY VARCHAR2,
538: p_item_id IN NUMBER,

Line 560: -- Default = FND_API.G_FALSE

556: -- Function : Add the author to the specified item.
557: -- Parameters :
558: -- IN p_api_version NUMBER Required
559: -- p_init_msg_list VARCHAR2 Optional
560: -- Default = FND_API.G_FALSE
561: -- p_commit VARCHAR2 Optional
562: -- Default = FND_API.G_FALSE
563: -- p_item_id NUMBER Required
564: -- The item id to be add the author.

Line 562: -- Default = FND_API.G_FALSE

558: -- IN p_api_version NUMBER Required
559: -- p_init_msg_list VARCHAR2 Optional
560: -- Default = FND_API.G_FALSE
561: -- p_commit VARCHAR2 Optional
562: -- Default = FND_API.G_FALSE
563: -- p_item_id NUMBER Required
564: -- The item id to be add the author.
565: -- p_author VARCHAR2 Required
566: -- The author to be added to the item.

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

573: --
574: PROCEDURE Add_ItemAuthor
575: (
576: p_api_version IN NUMBER,
577: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
578: p_commit IN VARCHAR2 := FND_API.G_FALSE,
579: x_return_status OUT NOCOPY VARCHAR2,
580: x_msg_count OUT NOCOPY NUMBER,
581: x_msg_data OUT NOCOPY VARCHAR2,

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

574: PROCEDURE Add_ItemAuthor
575: (
576: p_api_version IN NUMBER,
577: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
578: p_commit IN VARCHAR2 := FND_API.G_FALSE,
579: x_return_status OUT NOCOPY VARCHAR2,
580: x_msg_count OUT NOCOPY NUMBER,
581: x_msg_data OUT NOCOPY VARCHAR2,
582: p_item_id IN NUMBER,

Line 604: -- Default = FND_API.G_FALSE

600: -- from the specified item.
601: -- Parameters :
602: -- IN p_api_version NUMBER Required
603: -- p_init_msg_list VARCHAR2 Optional
604: -- Default = FND_API.G_FALSE
605: -- p_commit VARCHAR2 Optional
606: -- Default = FND_API.G_FALSE
607: -- p_item_id NUMBER Required
608: -- The item id to be add the authors.

Line 606: -- Default = FND_API.G_FALSE

602: -- IN p_api_version NUMBER Required
603: -- p_init_msg_list VARCHAR2 Optional
604: -- Default = FND_API.G_FALSE
605: -- p_commit VARCHAR2 Optional
606: -- Default = FND_API.G_FALSE
607: -- p_item_id NUMBER Required
608: -- The item id to be add the authors.
609: -- p_author_tab CHAR_TAB_TYPE
610: -- The authors table Required

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

617: --
618: PROCEDURE Delete_ItemAuthor
619: (
620: p_api_version IN NUMBER,
621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
622: p_commit IN VARCHAR2 := FND_API.G_FALSE,
623: x_return_status OUT NOCOPY VARCHAR2,
624: x_msg_count OUT NOCOPY NUMBER,
625: x_msg_data OUT NOCOPY VARCHAR2,

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

618: PROCEDURE Delete_ItemAuthor
619: (
620: p_api_version IN NUMBER,
621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
622: p_commit IN VARCHAR2 := FND_API.G_FALSE,
623: x_return_status OUT NOCOPY VARCHAR2,
624: x_msg_count OUT NOCOPY NUMBER,
625: x_msg_data OUT NOCOPY VARCHAR2,
626: p_item_id IN NUMBER,

Line 646: -- Default = FND_API.G_FALSE

642: -- Function : Remove the passed author from the specified item.
643: -- Parameters :
644: -- IN p_api_version NUMBER Required
645: -- p_init_msg_list VARCHAR2 Optional
646: -- Default = FND_API.G_FALSE
647: -- p_commit VARCHAR2 Optional
648: -- Default = FND_API.G_FALSE
649: -- p_item_id NUMBER Required
650: -- The id of the item to remove the author from.

Line 648: -- Default = FND_API.G_FALSE

644: -- IN p_api_version NUMBER Required
645: -- p_init_msg_list VARCHAR2 Optional
646: -- Default = FND_API.G_FALSE
647: -- p_commit VARCHAR2 Optional
648: -- Default = FND_API.G_FALSE
649: -- p_item_id NUMBER Required
650: -- The id of the item to remove the author from.
651: -- p_author VARCHAR2 Required
652: -- The author to be removed.

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

659: --
660: PROCEDURE Delete_ItemAuthor
661: (
662: p_api_version IN NUMBER,
663: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
664: p_commit IN VARCHAR2 := FND_API.G_FALSE,
665: x_return_status OUT NOCOPY VARCHAR2,
666: x_msg_count OUT NOCOPY NUMBER,
667: x_msg_data OUT NOCOPY VARCHAR2,

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

660: PROCEDURE Delete_ItemAuthor
661: (
662: p_api_version IN NUMBER,
663: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
664: p_commit IN VARCHAR2 := FND_API.G_FALSE,
665: x_return_status OUT NOCOPY VARCHAR2,
666: x_msg_count OUT NOCOPY NUMBER,
667: x_msg_data OUT NOCOPY VARCHAR2,
668: p_item_id IN NUMBER,

Line 694: -- Default = FND_API.G_FALSE

690: -- and add the passed authors to the item.
691: -- Parameters :
692: -- IN p_api_version NUMBER Required
693: -- p_init_msg_list VARCHAR2 Optional
694: -- Default = FND_API.G_FALSE
695: -- p_commit VARCHAR2 Optional
696: -- Default = FND_API.G_FALSE
697: -- p_item_id NUMBER Required
698: -- The item id to be added the authors.

Line 696: -- Default = FND_API.G_FALSE

692: -- IN p_api_version NUMBER Required
693: -- p_init_msg_list VARCHAR2 Optional
694: -- Default = FND_API.G_FALSE
695: -- p_commit VARCHAR2 Optional
696: -- Default = FND_API.G_FALSE
697: -- p_item_id NUMBER Required
698: -- The item id to be added the authors.
699: -- p_author_tab CHAR_TAB_TYPE
700: -- The authors table Required

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

707: --
708: PROCEDURE Replace_ItemAuthor
709: (
710: p_api_version IN NUMBER,
711: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
712: p_commit IN VARCHAR2 := FND_API.G_FALSE,
713: x_return_status OUT NOCOPY VARCHAR2,
714: x_msg_count OUT NOCOPY NUMBER,
715: x_msg_data OUT NOCOPY VARCHAR2,

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

708: PROCEDURE Replace_ItemAuthor
709: (
710: p_api_version IN NUMBER,
711: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
712: p_commit IN VARCHAR2 := FND_API.G_FALSE,
713: x_return_status OUT NOCOPY VARCHAR2,
714: x_msg_count OUT NOCOPY NUMBER,
715: x_msg_data OUT NOCOPY VARCHAR2,
716: p_item_id IN NUMBER,

Line 734: -- Default = FND_API.G_FALSE

730: -- Function : Query and return all the authors of the specified item
731: -- Parameters :
732: -- IN p_api_version NUMBER Required
733: -- p_init_msg_list VARCHAR2 Optional
734: -- Default = FND_API.G_FALSE
735: -- p_item_id NUMBER Required
736: -- OUT : x_return_status VARCHAR2
737: -- x_msg_count NUMBER
738: -- x_msg_data VARCHAR2

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

744: --
745: PROCEDURE Get_ItemAuthor
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_item_id IN NUMBER,