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

Line 100: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.

96: -- the sequence.
97: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
98: -- Raise exception for invalid flag.
99: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
100: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
101: --------------------------------------------------------------------
102: PROCEDURE Create_Media (
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 104: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

100: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
101: --------------------------------------------------------------------
102: PROCEDURE Create_Media (
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
105: p_commit IN VARCHAR2 := FND_API.g_false,
106: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
107:
108: x_return_status OUT NOCOPY VARCHAR2,

Line 105: p_commit IN VARCHAR2 := FND_API.g_false,

101: --------------------------------------------------------------------
102: PROCEDURE Create_Media (
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
105: p_commit IN VARCHAR2 := FND_API.g_false,
106: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,

Line 106: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

102: PROCEDURE Create_Media (
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
105: p_commit IN VARCHAR2 := FND_API.g_false,
106: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,

Line 128: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

124: -- p_media_rec: the record representing AMS_MEDIA_VL (without the ROW_ID column).
125: --
126: -- NOTES
127: -- 1. Raise exception if the object_version_number doesn't match.
128: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
129: -- that column won't be updated.
130: --------------------------------------------------------------------
131: PROCEDURE Update_Media (
132: p_api_version IN NUMBER,

Line 133: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

129: -- that column won't be updated.
130: --------------------------------------------------------------------
131: PROCEDURE Update_Media (
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
134: p_commit IN VARCHAR2 := FND_API.g_false,
135: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
136:
137: x_return_status OUT NOCOPY VARCHAR2,

Line 134: p_commit IN VARCHAR2 := FND_API.g_false,

130: --------------------------------------------------------------------
131: PROCEDURE Update_Media (
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
134: p_commit IN VARCHAR2 := FND_API.g_false,
135: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
136:
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,

Line 135: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

131: PROCEDURE Update_Media (
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
134: p_commit IN VARCHAR2 := FND_API.g_false,
135: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
136:
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,

Line 162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

158: -- 1. Raise exception if the object_version_number doesn't match.
159: --------------------------------------------------------------------
160: PROCEDURE Delete_Media (
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
163: p_commit IN VARCHAR2 := FND_API.g_false,
164: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
165:
166: x_return_status OUT NOCOPY VARCHAR2,

Line 163: p_commit IN VARCHAR2 := FND_API.g_false,

159: --------------------------------------------------------------------
160: PROCEDURE Delete_Media (
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
163: p_commit IN VARCHAR2 := FND_API.g_false,
164: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
165:
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,

Line 164: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

160: PROCEDURE Delete_Media (
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
163: p_commit IN VARCHAR2 := FND_API.g_false,
164: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
165:
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,

Line 192: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

188: -- 1. Raise exception if the object_version_number doesn't match.
189: --------------------------------------------------------------------
190: PROCEDURE Lock_Media (
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
193: p_commit IN VARCHAR2 := FND_API.g_false,
194: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
195:
196: x_return_status OUT NOCOPY VARCHAR2,

Line 193: p_commit IN VARCHAR2 := FND_API.g_false,

189: --------------------------------------------------------------------
190: PROCEDURE Lock_Media (
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
193: p_commit IN VARCHAR2 := FND_API.g_false,
194: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,

Line 194: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

190: PROCEDURE Lock_Media (
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
193: p_commit IN VARCHAR2 := FND_API.g_false,
194: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,

Line 216: -- should not be any FND_API.g_miss_char/num/date in it.

212: -- p_media_rec: the record representing AMS_MEDIA_VL (without ROW_ID).
213: --
214: -- NOTES
215: -- 1. p_media_rec should be the complete media record. There
216: -- should not be any FND_API.g_miss_char/num/date in it.
217: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
218: -- an exception, as those values are not handled.
219: --------------------------------------------------------------------
220: PROCEDURE Validate_Media (

Line 217: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise

213: --
214: -- NOTES
215: -- 1. p_media_rec should be the complete media record. There
216: -- should not be any FND_API.g_miss_char/num/date in it.
217: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
218: -- an exception, as those values are not handled.
219: --------------------------------------------------------------------
220: PROCEDURE Validate_Media (
221: p_api_version IN NUMBER,

Line 222: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

218: -- an exception, as those values are not handled.
219: --------------------------------------------------------------------
220: PROCEDURE Validate_Media (
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
223: p_commit IN VARCHAR2 := FND_API.g_false,
224: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
225:
226: x_return_status OUT NOCOPY VARCHAR2,

Line 223: p_commit IN VARCHAR2 := FND_API.g_false,

219: --------------------------------------------------------------------
220: PROCEDURE Validate_Media (
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
223: p_commit IN VARCHAR2 := FND_API.g_false,
224: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
225:
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,

Line 224: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

220: PROCEDURE Validate_Media (
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
223: p_commit IN VARCHAR2 := FND_API.g_false,
224: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
225:
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,

Line 260: -- as FND_API.g_miss_char/num/date

256: -- Check the record level business rules.
257: --
258: -- PARAMETERS
259: -- p_media_rec: the record to be validated; may contain attributes
260: -- as FND_API.g_miss_char/num/date
261: -- p_complete_rec: the complete record after all "g_miss" items
262: -- have been replaced by current database values
263: ---------------------------------------------------------------------
264: PROCEDURE Check_Media_Record (

Line 275: -- Initialize all attributes to be FND_API.g_miss_char/num/date.

271: -- PROCEDURE
272: -- Init_Media_Rec
273: --
274: -- PURPOSE
275: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
276: ---------------------------------------------------------------------
277: PROCEDURE Init_Media_Rec (
278: x_media_rec OUT NOCOPY Media_Rec_Type
279: );

Line 287: -- FND_API.g_miss_char/num/date if the user doesn't want to

283: -- Complete_Media_Rec
284: --
285: -- PURPOSE
286: -- For Update_Media, some attributes may be passed in as
287: -- FND_API.g_miss_char/num/date if the user doesn't want to
288: -- update those attributes. This procedure will replace the
289: -- "g_miss" attributes with current database values.
290: --
291: -- PARAMETERS

Line 293: -- FND_API.g_miss_char/num/date

289: -- "g_miss" attributes with current database values.
290: --
291: -- PARAMETERS
292: -- p_media_rec: the record which may contain attributes as
293: -- FND_API.g_miss_char/num/date
294: -- x_complete_rec: the complete record after all "g_miss" items
295: -- have been replaced by current database values
296: ---------------------------------------------------------------------
297: PROCEDURE Complete_Media_Rec (

Line 341: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.

337: -- the sequence.
338: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
339: -- Raise exception for invalid flag.
340: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
341: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
342: --------------------------------------------------------------------
343: PROCEDURE Create_MediaChannel (
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 345: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

341: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
342: --------------------------------------------------------------------
343: PROCEDURE Create_MediaChannel (
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
346: p_commit IN VARCHAR2 := FND_API.g_false,
347: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
348:
349: x_return_status OUT NOCOPY VARCHAR2,

Line 346: p_commit IN VARCHAR2 := FND_API.g_false,

342: --------------------------------------------------------------------
343: PROCEDURE Create_MediaChannel (
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
346: p_commit IN VARCHAR2 := FND_API.g_false,
347: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
348:
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY NUMBER,

Line 347: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

343: PROCEDURE Create_MediaChannel (
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
346: p_commit IN VARCHAR2 := FND_API.g_false,
347: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
348:
349: x_return_status OUT NOCOPY VARCHAR2,
350: x_msg_count OUT NOCOPY NUMBER,
351: x_msg_data OUT NOCOPY VARCHAR2,

Line 369: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

365: -- p_mediachl_rec: the record representing AMS_MEDIA_CHANNELS (without the ROW_ID column).
366: --
367: -- NOTES
368: -- 1. Raise exception if the object_version_number doesn't match.
369: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
370: -- that column won't be updated.
371: --------------------------------------------------------------------
372: PROCEDURE Update_MediaChannel (
373: p_api_version IN NUMBER,

Line 374: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

370: -- that column won't be updated.
371: --------------------------------------------------------------------
372: PROCEDURE Update_MediaChannel (
373: p_api_version IN NUMBER,
374: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
375: p_commit IN VARCHAR2 := FND_API.g_false,
376: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
377:
378: x_return_status OUT NOCOPY VARCHAR2,

Line 375: p_commit IN VARCHAR2 := FND_API.g_false,

371: --------------------------------------------------------------------
372: PROCEDURE Update_MediaChannel (
373: p_api_version IN NUMBER,
374: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
375: p_commit IN VARCHAR2 := FND_API.g_false,
376: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
377:
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,

Line 376: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

372: PROCEDURE Update_MediaChannel (
373: p_api_version IN NUMBER,
374: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
375: p_commit IN VARCHAR2 := FND_API.g_false,
376: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
377:
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2,

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

399: -- 1. Raise exception if the object_version_number doesn't match.
400: --------------------------------------------------------------------
401: PROCEDURE Delete_MediaChannel (
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: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
406:
407: x_return_status OUT NOCOPY VARCHAR2,

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

400: --------------------------------------------------------------------
401: PROCEDURE Delete_MediaChannel (
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: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
406:
407: x_return_status OUT NOCOPY VARCHAR2,
408: x_msg_count OUT NOCOPY NUMBER,

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

401: PROCEDURE Delete_MediaChannel (
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: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
406:
407: x_return_status OUT NOCOPY VARCHAR2,
408: x_msg_count OUT NOCOPY NUMBER,
409: x_msg_data OUT NOCOPY VARCHAR2,

Line 433: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

429: -- 1. Raise exception if the object_version_number doesn't match.
430: --------------------------------------------------------------------
431: PROCEDURE Lock_MediaChannel (
432: p_api_version IN NUMBER,
433: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
434: p_commit IN VARCHAR2 := FND_API.g_false,
435: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
436:
437: x_return_status OUT NOCOPY VARCHAR2,

Line 434: p_commit IN VARCHAR2 := FND_API.g_false,

430: --------------------------------------------------------------------
431: PROCEDURE Lock_MediaChannel (
432: p_api_version IN NUMBER,
433: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
434: p_commit IN VARCHAR2 := FND_API.g_false,
435: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
436:
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,

Line 435: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

431: PROCEDURE Lock_MediaChannel (
432: p_api_version IN NUMBER,
433: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
434: p_commit IN VARCHAR2 := FND_API.g_false,
435: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
436:
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2,

Line 457: -- should not be any FND_API.g_miss_char/num/date in it.

453: -- p_mediachl_rec: the record representing AMS_MEDIA_CHANNELS (without ROW_ID).
454: --
455: -- NOTES
456: -- 1. p_mediachl_rec should be the complete media channel record. There
457: -- should not be any FND_API.g_miss_char/num/date in it.
458: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
459: -- an exception, as those values are not handled.
460: --------------------------------------------------------------------
461: PROCEDURE Validate_MediaChannel (

Line 458: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise

454: --
455: -- NOTES
456: -- 1. p_mediachl_rec should be the complete media channel record. There
457: -- should not be any FND_API.g_miss_char/num/date in it.
458: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
459: -- an exception, as those values are not handled.
460: --------------------------------------------------------------------
461: PROCEDURE Validate_MediaChannel (
462: p_api_version IN NUMBER,

Line 463: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

459: -- an exception, as those values are not handled.
460: --------------------------------------------------------------------
461: PROCEDURE Validate_MediaChannel (
462: p_api_version IN NUMBER,
463: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
464: p_commit IN VARCHAR2 := FND_API.g_false,
465: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
466:
467: x_return_status OUT NOCOPY VARCHAR2,

Line 464: p_commit IN VARCHAR2 := FND_API.g_false,

460: --------------------------------------------------------------------
461: PROCEDURE Validate_MediaChannel (
462: p_api_version IN NUMBER,
463: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
464: p_commit IN VARCHAR2 := FND_API.g_false,
465: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
466:
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_msg_count OUT NOCOPY NUMBER,

Line 465: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

461: PROCEDURE Validate_MediaChannel (
462: p_api_version IN NUMBER,
463: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
464: p_commit IN VARCHAR2 := FND_API.g_false,
465: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
466:
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_msg_count OUT NOCOPY NUMBER,
469: x_msg_data OUT NOCOPY VARCHAR2,

Line 501: -- as FND_API.g_miss_char/num/date

497: -- Check the record level business rules.
498: --
499: -- PARAMETERS
500: -- p_mediachl_rec: the record to be validated; may contain attributes
501: -- as FND_API.g_miss_char/num/date
502: -- p_complete_rec: the complete record after all "g_miss" items
503: -- have been replaced by current database values
504: ---------------------------------------------------------------------
505: PROCEDURE Check_MediaChannel_Record (

Line 516: -- Initialize all attributes to be FND_API.g_miss_char/num/date.

512: -- PROCEDURE
513: -- Init_MediaChannel_Rec
514: --
515: -- PURPOSE
516: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
517: ---------------------------------------------------------------------
518: PROCEDURE Init_MediaChannel_Rec (
519: x_mediachl_rec OUT NOCOPY MediaChannel_Rec_Type
520: );

Line 528: -- FND_API.g_miss_char/num/date if the user doesn't want to

524: -- Complete_MediaChannel_Rec
525: --
526: -- PURPOSE
527: -- For Update_MediaChannel, some attributes may be passed in as
528: -- FND_API.g_miss_char/num/date if the user doesn't want to
529: -- update those attributes. This procedure will replace the
530: -- "g_miss" attributes with current database values.
531: --
532: -- PARAMETERS

Line 534: -- FND_API.g_miss_char/num/date

530: -- "g_miss" attributes with current database values.
531: --
532: -- PARAMETERS
533: -- p_mediachl_rec: the record which may contain attributes as
534: -- FND_API.g_miss_char/num/date
535: -- x_complete_rec: the complete record after all "g_miss" items
536: -- have been replaced by current database values
537: ---------------------------------------------------------------------
538: PROCEDURE Complete_MediaChannel_Rec (