165: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
166: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
167: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
168: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
169: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
170: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
171: x_set_number OUT NOCOPY VARCHAR2) RETURN NUMBER;
172:
173: FUNCTION Update_Set_With_Validation
166: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
167: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
168: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
169: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
170: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
171: x_set_number OUT NOCOPY VARCHAR2) RETURN NUMBER;
172:
173: FUNCTION Update_Set_With_Validation
174: (
195: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
196: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
197: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
198: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
199: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
200: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
201: x_set_id OUT NOCOPY number) RETURN NUMBER;
202:
203: FUNCTION Validate_Set_Type_Name_Create
196: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
197: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
198: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
199: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
200: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
201: x_set_id OUT NOCOPY number) RETURN NUMBER;
202:
203: FUNCTION Validate_Set_Type_Name_Create
204: (
240:
241: FUNCTION Validate_Set_Element_Type_Ids
242: (
243: p_set_type_id IN NUMBER,
244: p_element_type_ids IN JTF_NUMBER_TABLE
245:
246: ) RETURN NUMBER;
247:
248: FUNCTION VALIDATE_VISIBILITY_LEVEL
315: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
316: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
317: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
318: x_visibility_id OUT NOCOPY NUMBER,
319: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
320: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
321: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
322: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
323: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
316: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
317: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
318: x_visibility_id OUT NOCOPY NUMBER,
319: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
320: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
321: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
322: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
323: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
324: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
317: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
318: x_visibility_id OUT NOCOPY NUMBER,
319: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
320: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
321: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
322: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
323: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
324: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
325: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
318: x_visibility_id OUT NOCOPY NUMBER,
319: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
320: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
321: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
322: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
323: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
324: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
325: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
326: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
319: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
320: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
321: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
322: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
323: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
324: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
325: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
326: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
327: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
320: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
321: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
322: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
323: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
324: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
325: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
326: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
327: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
328: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
323: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
324: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
325: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
326: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
327: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
328: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
329: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
330: x_return_status OUT NOCOPY varchar2,
331: x_msg_count OUT NOCOPY number,
335: FUNCTION Link_Soln_Attributes
336: (
337: p_validate_type IN VARCHAR2,
338: p_set_id IN NUMBER,
339: p_given_element_ids IN JTF_NUMBER_TABLE,
340: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
341: p_given_ele_type_ids in JTF_NUMBER_TABLE,
342: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
343: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
337: p_validate_type IN VARCHAR2,
338: p_set_id IN NUMBER,
339: p_given_element_ids IN JTF_NUMBER_TABLE,
340: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
341: p_given_ele_type_ids in JTF_NUMBER_TABLE,
342: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
343: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
344: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
345: p_element_ids IN JTF_NUMBER_TABLE,
341: p_given_ele_type_ids in JTF_NUMBER_TABLE,
342: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
343: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
344: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
345: p_element_ids IN JTF_NUMBER_TABLE,
346: p_element_type_ids IN JTF_NUMBER_TABLE,
347: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
348: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
349: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
342: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
343: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
344: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
345: p_element_ids IN JTF_NUMBER_TABLE,
346: p_element_type_ids IN JTF_NUMBER_TABLE,
347: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
348: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
349: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
350: p_element_dummy_detail IN CLOB,
347: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
348: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
349: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
350: p_element_dummy_detail IN CLOB,
351: p_set_product_ids IN JTF_NUMBER_TABLE,
352: p_set_platform_ids IN JTF_NUMBER_TABLE,
353: p_set_category_ids IN JTF_NUMBER_TABLE,
354: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
355: x_return_status OUT NOCOPY varchar2,
348: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
349: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
350: p_element_dummy_detail IN CLOB,
351: p_set_product_ids IN JTF_NUMBER_TABLE,
352: p_set_platform_ids IN JTF_NUMBER_TABLE,
353: p_set_category_ids IN JTF_NUMBER_TABLE,
354: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
355: x_return_status OUT NOCOPY varchar2,
356: x_msg_count OUT NOCOPY number,
349: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
350: p_element_dummy_detail IN CLOB,
351: p_set_product_ids IN JTF_NUMBER_TABLE,
352: p_set_platform_ids IN JTF_NUMBER_TABLE,
353: p_set_category_ids IN JTF_NUMBER_TABLE,
354: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
355: x_return_status OUT NOCOPY varchar2,
356: x_msg_count OUT NOCOPY number,
357: x_msg_data OUT NOCOPY varchar2
350: p_element_dummy_detail IN CLOB,
351: p_set_product_ids IN JTF_NUMBER_TABLE,
352: p_set_platform_ids IN JTF_NUMBER_TABLE,
353: p_set_category_ids IN JTF_NUMBER_TABLE,
354: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
355: x_return_status OUT NOCOPY varchar2,
356: x_msg_count OUT NOCOPY number,
357: x_msg_data OUT NOCOPY varchar2
358: ) RETURN NUMBER;
405: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
406: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
407: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
408: x_visibility_id OUT NOCOPY NUMBER,
409: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
410: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
411: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
412: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
413: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
406: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
407: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
408: x_visibility_id OUT NOCOPY NUMBER,
409: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
410: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
411: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
412: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
413: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
414: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
407: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
408: x_visibility_id OUT NOCOPY NUMBER,
409: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
410: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
411: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
412: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
413: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
414: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
415: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
408: x_visibility_id OUT NOCOPY NUMBER,
409: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
410: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
411: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
412: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
413: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
414: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
415: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
416: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
409: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
410: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
411: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
412: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
413: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
414: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
415: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
416: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
417: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
410: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
411: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
412: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
413: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
414: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
415: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
416: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
417: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
418: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
413: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
414: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
415: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
416: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
417: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
418: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
419: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
420: x_return_status OUT NOCOPY varchar2,
421: x_msg_count OUT NOCOPY number,
441: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
442: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
443: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
444: x_visibility_id OUT NOCOPY NUMBER,
445: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
446: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
447: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
448: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
449: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
442: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
443: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
444: x_visibility_id OUT NOCOPY NUMBER,
445: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
446: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
447: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
448: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
449: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
450: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
443: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
444: x_visibility_id OUT NOCOPY NUMBER,
445: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
446: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
447: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
448: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
449: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
450: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
451: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
444: x_visibility_id OUT NOCOPY NUMBER,
445: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
446: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
447: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
448: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
449: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
450: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
451: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
452: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
445: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
446: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
447: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
448: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
449: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
450: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
451: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
452: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
453: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
446: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
447: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
448: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
449: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
450: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
451: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
452: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
453: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
454: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
449: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
450: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
451: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
452: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
453: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
454: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
455: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
456: x_return_status OUT NOCOPY varchar2,
457: x_msg_count OUT NOCOPY number,
486: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
487: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
488: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
489: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
490: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
491: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
492: x_set_number OUT NOCOPY VARCHAR2,
493: p_delim IN VARCHAR2
494: ) RETURN NUMBER;
487: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
488: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
489: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
490: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
491: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
492: x_set_number OUT NOCOPY VARCHAR2,
493: p_delim IN VARCHAR2
494: ) RETURN NUMBER;
495:
521: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
522: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
523: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
524: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
525: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
526: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
527: x_set_number OUT NOCOPY VARCHAR2,
528: p_delim IN VARCHAR2
529: ) RETURN NUMBER;
522: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
523: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
524: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
525: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
526: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
527: x_set_number OUT NOCOPY VARCHAR2,
528: p_delim IN VARCHAR2
529: ) RETURN NUMBER;
530:
577: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
578: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
579: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
580: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
581: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
582: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
583: x_set_id OUT NOCOPY number,
584: p_delim IN VARCHAR2
585: ) RETURN NUMBER;
578: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
579: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
580: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
581: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
582: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
583: x_set_id OUT NOCOPY number,
584: p_delim IN VARCHAR2
585: ) RETURN NUMBER;
586:
611: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
612: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
613: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
614: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
615: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
616: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
617: x_set_id OUT NOCOPY number,
618: p_delim IN VARCHAR2
619: ) RETURN NUMBER;
612: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
613: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
614: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
615: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
616: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
617: x_set_id OUT NOCOPY number,
618: p_delim IN VARCHAR2
619: ) RETURN NUMBER;
620: