173: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
174: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
175: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
176: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
177: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
178: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
179: x_set_number OUT NOCOPY VARCHAR2) RETURN NUMBER;
180:
181: FUNCTION Update_Set_With_Validation
174: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
175: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
176: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
177: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
178: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
179: x_set_number OUT NOCOPY VARCHAR2) RETURN NUMBER;
180:
181: FUNCTION Update_Set_With_Validation
182: (
203: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
204: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
205: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
206: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
207: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
208: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
209: x_set_id OUT NOCOPY number) RETURN NUMBER;
210:
211: FUNCTION Validate_Set_Type_Name_Create
204: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
205: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
206: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
207: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
208: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
209: x_set_id OUT NOCOPY number) RETURN NUMBER;
210:
211: FUNCTION Validate_Set_Type_Name_Create
212: (
248:
249: FUNCTION Validate_Set_Element_Type_Ids
250: (
251: p_set_type_id IN NUMBER,
252: p_element_type_ids IN JTF_NUMBER_TABLE
253:
254: ) RETURN NUMBER;
255:
256: FUNCTION VALIDATE_VISIBILITY_LEVEL
323: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
324: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
325: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
326: x_visibility_id OUT NOCOPY NUMBER,
327: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
328: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
329: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
330: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
331: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
324: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
325: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
326: x_visibility_id OUT NOCOPY NUMBER,
327: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
328: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
329: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
330: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
331: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
332: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
325: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
326: x_visibility_id OUT NOCOPY NUMBER,
327: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
328: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
329: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
330: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
331: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
332: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
333: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
326: x_visibility_id OUT NOCOPY NUMBER,
327: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
328: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
329: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
330: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
331: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
332: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
333: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
334: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
327: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
328: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
329: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
330: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
331: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
332: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
333: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
334: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
335: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
328: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
329: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
330: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
331: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
332: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
333: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
334: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
335: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
336: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
331: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
332: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
333: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
334: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
335: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
336: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
337: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
338: x_return_status OUT NOCOPY varchar2,
339: x_msg_count OUT NOCOPY number,
343: FUNCTION Link_Soln_Attributes
344: (
345: p_validate_type IN VARCHAR2,
346: p_set_id IN NUMBER,
347: p_given_element_ids IN JTF_NUMBER_TABLE,
348: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
349: p_given_ele_type_ids in JTF_NUMBER_TABLE,
350: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
351: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
345: p_validate_type IN VARCHAR2,
346: p_set_id IN NUMBER,
347: p_given_element_ids IN JTF_NUMBER_TABLE,
348: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
349: p_given_ele_type_ids in JTF_NUMBER_TABLE,
350: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
351: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
352: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
353: p_element_ids IN JTF_NUMBER_TABLE,
349: p_given_ele_type_ids in JTF_NUMBER_TABLE,
350: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
351: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
352: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
353: p_element_ids IN JTF_NUMBER_TABLE,
354: p_element_type_ids IN JTF_NUMBER_TABLE,
355: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
356: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
357: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
350: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
351: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
352: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
353: p_element_ids IN JTF_NUMBER_TABLE,
354: p_element_type_ids IN JTF_NUMBER_TABLE,
355: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
356: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
357: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
358: p_element_dummy_detail IN CLOB,
355: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
356: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
357: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
358: p_element_dummy_detail IN CLOB,
359: p_set_product_ids IN JTF_NUMBER_TABLE,
360: p_set_platform_ids IN JTF_NUMBER_TABLE,
361: p_set_category_ids IN JTF_NUMBER_TABLE,
362: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
363: x_return_status OUT NOCOPY varchar2,
356: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
357: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
358: p_element_dummy_detail IN CLOB,
359: p_set_product_ids IN JTF_NUMBER_TABLE,
360: p_set_platform_ids IN JTF_NUMBER_TABLE,
361: p_set_category_ids IN JTF_NUMBER_TABLE,
362: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
363: x_return_status OUT NOCOPY varchar2,
364: x_msg_count OUT NOCOPY number,
357: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
358: p_element_dummy_detail IN CLOB,
359: p_set_product_ids IN JTF_NUMBER_TABLE,
360: p_set_platform_ids IN JTF_NUMBER_TABLE,
361: p_set_category_ids IN JTF_NUMBER_TABLE,
362: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
363: x_return_status OUT NOCOPY varchar2,
364: x_msg_count OUT NOCOPY number,
365: x_msg_data OUT NOCOPY varchar2
358: p_element_dummy_detail IN CLOB,
359: p_set_product_ids IN JTF_NUMBER_TABLE,
360: p_set_platform_ids IN JTF_NUMBER_TABLE,
361: p_set_category_ids IN JTF_NUMBER_TABLE,
362: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
363: x_return_status OUT NOCOPY varchar2,
364: x_msg_count OUT NOCOPY number,
365: x_msg_data OUT NOCOPY varchar2
366: ) RETURN NUMBER;
413: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
414: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
415: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
416: x_visibility_id OUT NOCOPY NUMBER,
417: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
418: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
419: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
420: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
421: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
414: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
415: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
416: x_visibility_id OUT NOCOPY NUMBER,
417: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
418: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
419: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
420: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
421: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
422: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
415: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
416: x_visibility_id OUT NOCOPY NUMBER,
417: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
418: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
419: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
420: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
421: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
422: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
423: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
416: x_visibility_id OUT NOCOPY NUMBER,
417: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
418: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
419: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
420: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
421: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
422: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
423: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
424: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
417: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
418: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
419: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
420: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
421: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
422: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
423: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
424: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
425: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
418: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
419: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
420: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
421: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
422: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
423: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
424: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
425: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
426: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
421: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
422: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
423: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
424: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
425: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
426: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
427: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
428: x_return_status OUT NOCOPY varchar2,
429: x_msg_count OUT NOCOPY number,
449: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
450: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
451: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
452: x_visibility_id OUT NOCOPY NUMBER,
453: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
454: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
455: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
456: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
457: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
450: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
451: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
452: x_visibility_id OUT NOCOPY NUMBER,
453: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
454: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
455: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
456: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
457: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
458: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
451: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
452: x_visibility_id OUT NOCOPY NUMBER,
453: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
454: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
455: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
456: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
457: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
458: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
459: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
452: x_visibility_id OUT NOCOPY NUMBER,
453: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
454: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
455: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
456: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
457: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
458: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
459: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
460: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
453: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
454: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
455: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
456: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
457: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
458: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
459: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
460: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
461: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
454: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
455: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
456: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
457: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
458: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
459: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
460: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
461: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
462: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
457: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
458: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
459: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
460: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
461: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
462: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
463: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
464: x_return_status OUT NOCOPY varchar2,
465: x_msg_count OUT NOCOPY number,
494: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
495: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
496: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
497: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
498: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
499: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
500: x_set_number OUT NOCOPY VARCHAR2,
501: p_delim IN VARCHAR2
502: ) RETURN NUMBER;
495: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
496: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
497: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
498: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
499: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
500: x_set_number OUT NOCOPY VARCHAR2,
501: p_delim IN VARCHAR2
502: ) RETURN NUMBER;
503:
529: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
530: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
531: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
532: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
533: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
534: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
535: x_set_number OUT NOCOPY VARCHAR2,
536: p_delim IN VARCHAR2
537: ) RETURN NUMBER;
530: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
531: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
532: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
533: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
534: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
535: x_set_number OUT NOCOPY VARCHAR2,
536: p_delim IN VARCHAR2
537: ) RETURN NUMBER;
538:
585: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
586: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
587: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
588: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
589: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
590: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
591: x_set_id OUT NOCOPY number,
592: p_delim IN VARCHAR2
593: ) RETURN NUMBER;
586: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
587: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
588: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
589: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
590: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
591: x_set_id OUT NOCOPY number,
592: p_delim IN VARCHAR2
593: ) RETURN NUMBER;
594:
619: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
620: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
621: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
622: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
623: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
624: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
625: x_set_id OUT NOCOPY number,
626: p_delim IN VARCHAR2
627: ) RETURN NUMBER;
620: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
621: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
622: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
623: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
624: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
625: x_set_id OUT NOCOPY number,
626: p_delim IN VARCHAR2
627: ) RETURN NUMBER;
628: