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.
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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: );
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
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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: ---------------------------------------------------------------------
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,