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

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

69: -- p_cell_rec: the new record to be inserted
70: -- x_cell_id: return the cell_id of the new cell
71: --
72: -- NOTES
73: -- 1. Please don't pass in any FND_API.g_mess_char/num/date.
74: -- 2. object_version_number will be set to 1.
75: -- 3. If cell_id is passed in, the uniqueness will be checked.
76: -- Raise exception in case of duplicates. If cell_id is not
77: -- passed in, generate a unique one from the sequence.

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

82: -- 6. If the market segmentflag is passed null then it will be defaulted to Y
83: ---------------------------------------------------------------------
84: PROCEDURE create_cell(
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
87: p_commit IN VARCHAR2 := FND_API.g_false,
88: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
89:
90: x_return_status OUT NOCOPY VARCHAR2,

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

83: ---------------------------------------------------------------------
84: PROCEDURE create_cell(
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
87: p_commit IN VARCHAR2 := FND_API.g_false,
88: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
89:
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,

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

84: PROCEDURE create_cell(
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
87: p_commit IN VARCHAR2 := FND_API.g_false,
88: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
89:
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,

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

114: -- from database.
115: --------------------------------------------------------------------
116: PROCEDURE delete_cell(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
119: p_commit IN VARCHAR2 := FND_API.g_false,
120:
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,

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

115: --------------------------------------------------------------------
116: PROCEDURE delete_cell(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
119: p_commit IN VARCHAR2 := FND_API.g_false,
120:
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,

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

142: -- 1. Raise exception if the object_version_number doesn't match.
143: --------------------------------------------------------------------
144: PROCEDURE lock_cell(
145: p_api_version IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
147:
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,

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

165: -- p_cell_rec: the record with new items
166: --
167: -- NOTES
168: -- 1. Raise exception if the object_version_number doesn't match.
169: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
170: -- that column won't be updated.
171: ----------------------------------------------------------------------
172: PROCEDURE update_cell(
173: p_api_version IN NUMBER,

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

170: -- that column won't be updated.
171: ----------------------------------------------------------------------
172: PROCEDURE update_cell(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
175: p_commit IN VARCHAR2 := FND_API.g_false,
176: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
177:
178: x_return_status OUT NOCOPY VARCHAR2,

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

171: ----------------------------------------------------------------------
172: PROCEDURE update_cell(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
175: p_commit IN VARCHAR2 := FND_API.g_false,
176: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
177:
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,

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

172: PROCEDURE update_cell(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
175: p_commit IN VARCHAR2 := FND_API.g_false,
176: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
177:
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,

Line 198: -- any FND_API.g_miss_char/num/date items.

194: -- p_cell_rec: the record to be validated
195: --
196: -- NOTES
197: -- 1. p_cell_rec should be the complete cell record wothout
198: -- any FND_API.g_miss_char/num/date items.
199: ----------------------------------------------------------------------
200: PROCEDURE validate_cell(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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

198: -- any FND_API.g_miss_char/num/date items.
199: ----------------------------------------------------------------------
200: PROCEDURE validate_cell(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
203: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
204:
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,

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

199: ----------------------------------------------------------------------
200: PROCEDURE validate_cell(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
203: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
204:
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,

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

234: -- PROCEDURE
235: -- init_cell_rec
236: --
237: -- PURPOSE
238: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
239: ---------------------------------------------------------------------
240: PROCEDURE init_cell_rec(
241: x_cell_rec OUT NOCOPY cell_rec_type
242: );

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

247: -- complete_cell_rec
248: --
249: -- PURPOSE
250: -- For update_cell, some attributes may be passed in as
251: -- FND_API.g_miss_char/num/date if the user doesn't want to
252: -- update those attributes. This procedure will replace the
253: -- "g_miss" attributes with current database values.
254: --
255: -- PARAMETERS

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

253: -- "g_miss" attributes with current database values.
254: --
255: -- PARAMETERS
256: -- p_cell_rec: the record which may contain attributes as
257: -- FND_API.g_miss_char/num/date
258: -- x_complete_rec: the complete record after all "g_miss" items
259: -- have been replaced by current database values
260: --
261: -- NOTES

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

285: --
286: ---------------------------------------------------------------------
287: PROCEDURE add_sel_workbook(
288: p_api_version IN NUMBER,
289: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
290: p_commit IN VARCHAR2 := FND_API.g_false,
291: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
292:
293: x_return_status OUT NOCOPY VARCHAR2,

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

286: ---------------------------------------------------------------------
287: PROCEDURE add_sel_workbook(
288: p_api_version IN NUMBER,
289: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
290: p_commit IN VARCHAR2 := FND_API.g_false,
291: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
292:
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,

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

287: PROCEDURE add_sel_workbook(
288: p_api_version IN NUMBER,
289: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
290: p_commit IN VARCHAR2 := FND_API.g_false,
291: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
292:
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,

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

306: -- 02/02/01 yxliu Created.
307: ---------------------------------------------------------------------
308: PROCEDURE add_sel_sql(
309: p_api_version IN NUMBER,
310: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
311: p_commit IN VARCHAR2 := FND_API.g_false,
312: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
313:
314: x_return_status OUT NOCOPY VARCHAR2,

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

307: ---------------------------------------------------------------------
308: PROCEDURE add_sel_sql(
309: p_api_version IN NUMBER,
310: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
311: p_commit IN VARCHAR2 := FND_API.g_false,
312: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
313:
314: x_return_status OUT NOCOPY VARCHAR2,
315: x_msg_count OUT NOCOPY NUMBER,

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

308: PROCEDURE add_sel_sql(
309: p_api_version IN NUMBER,
310: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
311: p_commit IN VARCHAR2 := FND_API.g_false,
312: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
313:
314: x_return_status OUT NOCOPY VARCHAR2,
315: x_msg_count OUT NOCOPY NUMBER,
316: x_msg_data OUT NOCOPY VARCHAR2,

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

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

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

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

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

374: -- comment out for rosetta's sake
375: ---------------------------------------------------------------------
376: PROCEDURE get_comp_sql(
377: p_api_version IN NUMBER,
378: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
379: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
380:
381: x_return_status OUT NOCOPY VARCHAR2,
382: x_msg_count OUT NOCOPY NUMBER,

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

375: ---------------------------------------------------------------------
376: PROCEDURE get_comp_sql(
377: p_api_version IN NUMBER,
378: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
379: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
380:
381: x_return_status OUT NOCOPY VARCHAR2,
382: x_msg_count OUT NOCOPY NUMBER,
383: x_msg_data OUT NOCOPY VARCHAR2,

Line 386: p_party_id_only IN VARCHAR2 := FND_API.g_false,

382: x_msg_count OUT NOCOPY NUMBER,
383: x_msg_data OUT NOCOPY VARCHAR2,
384:
385: p_cell_id IN NUMBER,
386: p_party_id_only IN VARCHAR2 := FND_API.g_false,
387: x_sql_tbl OUT NOCOPY DBMS_SQL.VARCHAR2S
388: );
389:
390: ---------------------------------------------------------------------

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

448: -- 03/01/2001 yxliu Created.
449: ---------------------------------------------------------------------
450: PROCEDURE get_workbook_sql(
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
453: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
454:
455: x_return_status OUT NOCOPY VARCHAR2,
456: x_msg_count OUT NOCOPY NUMBER,

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

449: ---------------------------------------------------------------------
450: PROCEDURE get_workbook_sql(
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
453: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
454:
455: x_return_status OUT NOCOPY VARCHAR2,
456: x_msg_count OUT NOCOPY NUMBER,
457: x_msg_data OUT NOCOPY VARCHAR2,

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

467: -- 03/01/2001 yxliu Created.
468: ---------------------------------------------------------------------
469: PROCEDURE get_segment_size(
470: p_api_version IN NUMBER,
471: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
472: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
473:
474: x_return_status OUT NOCOPY VARCHAR2,
475: x_msg_count OUT NOCOPY NUMBER,

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

468: ---------------------------------------------------------------------
469: PROCEDURE get_segment_size(
470: p_api_version IN NUMBER,
471: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
472: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
473:
474: x_return_status OUT NOCOPY VARCHAR2,
475: x_msg_count OUT NOCOPY NUMBER,
476: x_msg_data OUT NOCOPY VARCHAR2,

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

489: -- criteria.
490: ---------------------------------------------------------------------
491: PROCEDURE get_comp_segment_size(
492: p_api_version IN NUMBER,
493: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
494: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
495:
496: x_return_status OUT NOCOPY VARCHAR2,
497: x_msg_count OUT NOCOPY NUMBER,

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

490: ---------------------------------------------------------------------
491: PROCEDURE get_comp_segment_size(
492: p_api_version IN NUMBER,
493: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
494: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
495:
496: x_return_status OUT NOCOPY VARCHAR2,
497: x_msg_count OUT NOCOPY NUMBER,
498: x_msg_data OUT NOCOPY VARCHAR2,

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

510: -- corresponding mapping tables
511: ---------------------------------------------------------------------
512: PROCEDURE create_sql_cell(
513: p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
515: p_commit IN VARCHAR2 := FND_API.g_false,
516: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
517:
518: x_return_status OUT NOCOPY VARCHAR2,

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

511: ---------------------------------------------------------------------
512: PROCEDURE create_sql_cell(
513: p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
515: p_commit IN VARCHAR2 := FND_API.g_false,
516: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
517:
518: x_return_status OUT NOCOPY VARCHAR2,
519: x_msg_count OUT NOCOPY NUMBER,

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

512: PROCEDURE create_sql_cell(
513: p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
515: p_commit IN VARCHAR2 := FND_API.g_false,
516: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
517:
518: x_return_status OUT NOCOPY VARCHAR2,
519: x_msg_count OUT NOCOPY NUMBER,
520: x_msg_data OUT NOCOPY VARCHAR2,

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

532: -- update the corresponding mapping tables
533: ---------------------------------------------------------------------
534: PROCEDURE update_sql_cell(
535: p_api_version IN NUMBER,
536: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
537: p_commit IN VARCHAR2 := FND_API.g_false,
538: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
539:
540: x_return_status OUT NOCOPY VARCHAR2,

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

533: ---------------------------------------------------------------------
534: PROCEDURE update_sql_cell(
535: p_api_version IN NUMBER,
536: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
537: p_commit IN VARCHAR2 := FND_API.g_false,
538: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
539:
540: x_return_status OUT NOCOPY VARCHAR2,
541: x_msg_count OUT NOCOPY NUMBER,

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

534: PROCEDURE update_sql_cell(
535: p_api_version IN NUMBER,
536: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
537: p_commit IN VARCHAR2 := FND_API.g_false,
538: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
539:
540: x_return_status OUT NOCOPY VARCHAR2,
541: x_msg_count OUT NOCOPY NUMBER,
542: x_msg_data OUT NOCOPY VARCHAR2,