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.CS_KNOWLEDGE_AUDIT_PVT dependencies on JTF_VARCHAR2_TABLE_2000

Line 164: p_set_products in JTF_VARCHAR2_TABLE_2000,

160: p_set_visibility in varchar2,
161: p_set_title in varchar2,
162: p_set_flow_name in VARCHAR2 DEFAULT NULL,
163: p_set_flow_stepcode in VARCHAR2 DEFAULT NULL,
164: p_set_products in JTF_VARCHAR2_TABLE_2000,
165: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
166: p_set_categories in JTF_VARCHAR2_TABLE_2000,
167: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
168: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 165: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

161: p_set_title in varchar2,
162: p_set_flow_name in VARCHAR2 DEFAULT NULL,
163: p_set_flow_stepcode in VARCHAR2 DEFAULT NULL,
164: p_set_products in JTF_VARCHAR2_TABLE_2000,
165: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
166: p_set_categories in JTF_VARCHAR2_TABLE_2000,
167: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
168: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
169: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 166: p_set_categories in JTF_VARCHAR2_TABLE_2000,

162: p_set_flow_name in VARCHAR2 DEFAULT NULL,
163: p_set_flow_stepcode in VARCHAR2 DEFAULT NULL,
164: p_set_products in JTF_VARCHAR2_TABLE_2000,
165: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
166: p_set_categories in JTF_VARCHAR2_TABLE_2000,
167: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
168: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
169: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
170: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 167: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

163: p_set_flow_stepcode in VARCHAR2 DEFAULT NULL,
164: p_set_products in JTF_VARCHAR2_TABLE_2000,
165: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
166: p_set_categories in JTF_VARCHAR2_TABLE_2000,
167: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
168: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
169: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
170: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
171: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 168: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

164: p_set_products in JTF_VARCHAR2_TABLE_2000,
165: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
166: p_set_categories in JTF_VARCHAR2_TABLE_2000,
167: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
168: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
169: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
170: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
171: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
172: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 169: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

165: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
166: p_set_categories in JTF_VARCHAR2_TABLE_2000,
167: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
168: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
169: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
170: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
171: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
172: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
173: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 170: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

166: p_set_categories in JTF_VARCHAR2_TABLE_2000,
167: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
168: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
169: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
170: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
171: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
172: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
173: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
174: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 171: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

167: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
168: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
169: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
170: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
171: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
172: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 172: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

168: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
169: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
170: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
171: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
172: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 173: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

169: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
170: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
171: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
172: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 174: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

170: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
171: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
172: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 175: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

171: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
172: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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;

Line 176: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

172: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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:

Line 194: p_set_products in JTF_VARCHAR2_TABLE_2000,

190: p_set_number in varchar2,
191: p_set_type_name in varchar2,
192: p_set_visibility in varchar2,
193: p_set_title in varchar2,
194: p_set_products in JTF_VARCHAR2_TABLE_2000,
195: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
196: p_set_categories in JTF_VARCHAR2_TABLE_2000,
197: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
198: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 195: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

191: p_set_type_name in varchar2,
192: p_set_visibility in varchar2,
193: p_set_title in varchar2,
194: p_set_products in JTF_VARCHAR2_TABLE_2000,
195: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
196: p_set_categories in JTF_VARCHAR2_TABLE_2000,
197: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
198: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
199: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 196: p_set_categories in JTF_VARCHAR2_TABLE_2000,

192: p_set_visibility in varchar2,
193: p_set_title in varchar2,
194: p_set_products in JTF_VARCHAR2_TABLE_2000,
195: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
196: p_set_categories in JTF_VARCHAR2_TABLE_2000,
197: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
198: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
199: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
200: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 197: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

193: p_set_title in varchar2,
194: p_set_products in JTF_VARCHAR2_TABLE_2000,
195: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
196: p_set_categories in JTF_VARCHAR2_TABLE_2000,
197: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
198: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
199: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
200: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
201: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 198: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

194: p_set_products in JTF_VARCHAR2_TABLE_2000,
195: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
196: p_set_categories in JTF_VARCHAR2_TABLE_2000,
197: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
198: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
199: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
200: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
201: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
202: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 199: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

195: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
196: p_set_categories in JTF_VARCHAR2_TABLE_2000,
197: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
198: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
199: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
200: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
201: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
202: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
203: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 200: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

196: p_set_categories in JTF_VARCHAR2_TABLE_2000,
197: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
198: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
199: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
200: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
201: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
202: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
203: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
204: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 201: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

197: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
198: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
199: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
200: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
201: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
202: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 202: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

198: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
199: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
200: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
201: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
202: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 203: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

199: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
200: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
201: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
202: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 204: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

200: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
201: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
202: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 205: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

201: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
202: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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;

Line 206: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

202: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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:

Line 315: p_product_names IN JTF_VARCHAR2_TABLE_2000,

311: FUNCTION VALIDATE_SOLN_ATTRIBUTES
312: (
313: p_set_type_id IN NUMBER,
314: p_visibility_name IN VARCHAR2,
315: p_product_names IN JTF_VARCHAR2_TABLE_2000,
316: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
317: p_category_names IN JTF_VARCHAR2_TABLE_2000,
318: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
319: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

Line 316: p_platform_names IN JTF_VARCHAR2_TABLE_2000,

312: (
313: p_set_type_id IN NUMBER,
314: p_visibility_name IN VARCHAR2,
315: p_product_names IN JTF_VARCHAR2_TABLE_2000,
316: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
317: p_category_names IN JTF_VARCHAR2_TABLE_2000,
318: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
319: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
320: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

Line 317: p_category_names IN JTF_VARCHAR2_TABLE_2000,

313: p_set_type_id IN NUMBER,
314: p_visibility_name IN VARCHAR2,
315: p_product_names IN JTF_VARCHAR2_TABLE_2000,
316: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
317: p_category_names IN JTF_VARCHAR2_TABLE_2000,
318: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
319: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
320: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
321: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 318: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,

314: p_visibility_name IN VARCHAR2,
315: p_product_names IN JTF_VARCHAR2_TABLE_2000,
316: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
317: p_category_names IN JTF_VARCHAR2_TABLE_2000,
318: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
319: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
320: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
321: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
322: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

Line 319: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

315: p_product_names IN JTF_VARCHAR2_TABLE_2000,
316: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
317: p_category_names IN JTF_VARCHAR2_TABLE_2000,
318: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
319: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
320: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
321: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
322: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
323: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

Line 320: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

316: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
317: p_category_names IN JTF_VARCHAR2_TABLE_2000,
318: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
319: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
320: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
321: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
322: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
323: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
324: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 321: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

317: p_category_names IN JTF_VARCHAR2_TABLE_2000,
318: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
319: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
320: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
321: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
322: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 322: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

318: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
319: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
320: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
321: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
322: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 323: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

319: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
320: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
321: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
322: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 324: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

320: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
321: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
322: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 325: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,

321: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
322: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 333: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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,
337: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 334: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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,
337: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
338: x_return_status OUT NOCOPY varchar2,

Line 336: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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,
340: x_msg_data OUT NOCOPY varchar2

Line 337: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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,
340: x_msg_data OUT NOCOPY varchar2
341: ) RETURN NUMBER;

Line 348: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,

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,
352: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,

Line 350: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,

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,
354: p_element_type_ids IN JTF_NUMBER_TABLE,

Line 351: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,

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,
354: p_element_type_ids IN JTF_NUMBER_TABLE,
355: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,

Line 352: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,

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,
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,

Line 355: p_element_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,
359: p_set_product_ids IN JTF_NUMBER_TABLE,

Line 356: p_element_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,
359: p_set_product_ids IN JTF_NUMBER_TABLE,
360: p_set_platform_ids IN JTF_NUMBER_TABLE,

Line 357: p_element_summaries 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,
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,

Line 405: p_product_names IN JTF_VARCHAR2_TABLE_2000,

401: FUNCTION VALIDATE_SOLN_ATTRIBUTES_2
402: (
403: p_set_type_id IN NUMBER,
404: p_visibility_name IN VARCHAR2,
405: p_product_names IN JTF_VARCHAR2_TABLE_2000,
406: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
407: p_category_names IN JTF_VARCHAR2_TABLE_2000,
408: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
409: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

Line 406: p_platform_names IN JTF_VARCHAR2_TABLE_2000,

402: (
403: p_set_type_id IN NUMBER,
404: p_visibility_name IN VARCHAR2,
405: p_product_names IN JTF_VARCHAR2_TABLE_2000,
406: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
407: p_category_names IN JTF_VARCHAR2_TABLE_2000,
408: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
409: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
410: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

Line 407: p_category_names IN JTF_VARCHAR2_TABLE_2000,

403: p_set_type_id IN NUMBER,
404: p_visibility_name IN VARCHAR2,
405: p_product_names IN JTF_VARCHAR2_TABLE_2000,
406: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
407: p_category_names IN JTF_VARCHAR2_TABLE_2000,
408: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
409: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
410: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
411: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 408: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,

404: p_visibility_name IN VARCHAR2,
405: p_product_names IN JTF_VARCHAR2_TABLE_2000,
406: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
407: p_category_names IN JTF_VARCHAR2_TABLE_2000,
408: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
409: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
410: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
411: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
412: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

Line 409: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

405: p_product_names IN JTF_VARCHAR2_TABLE_2000,
406: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
407: p_category_names IN JTF_VARCHAR2_TABLE_2000,
408: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
409: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
410: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
411: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
412: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
413: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

Line 410: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

406: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
407: p_category_names IN JTF_VARCHAR2_TABLE_2000,
408: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
409: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
410: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
411: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
412: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
413: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
414: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 411: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

407: p_category_names IN JTF_VARCHAR2_TABLE_2000,
408: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
409: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
410: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
411: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
412: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 412: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

408: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
409: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
410: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
411: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
412: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 413: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

409: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
410: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
411: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
412: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 414: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

410: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
411: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
412: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 415: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,

411: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
412: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 423: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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,
427: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 424: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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,
427: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
428: x_return_status OUT NOCOPY varchar2,

Line 426: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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,
430: x_msg_data OUT NOCOPY varchar2,

Line 427: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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,
430: x_msg_data OUT NOCOPY varchar2,
431: p_delim IN VARCHAR2

Line 439: p_product_names IN JTF_VARCHAR2_TABLE_2000,

435: FUNCTION VALIDATE_SOLN_ATTRIBUTES_3
436: (
437: p_set_type_id IN NUMBER,
438: p_visibility_name IN VARCHAR2,
439: p_product_names IN JTF_VARCHAR2_TABLE_2000,
440: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
441: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
442: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
443: p_category_names IN JTF_VARCHAR2_TABLE_2000,

Line 440: p_product_segments IN JTF_VARCHAR2_TABLE_2000,

436: (
437: p_set_type_id IN NUMBER,
438: p_visibility_name IN VARCHAR2,
439: p_product_names IN JTF_VARCHAR2_TABLE_2000,
440: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
441: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
442: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
443: p_category_names IN JTF_VARCHAR2_TABLE_2000,
444: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,

Line 441: p_platform_names IN JTF_VARCHAR2_TABLE_2000,

437: p_set_type_id IN NUMBER,
438: p_visibility_name IN VARCHAR2,
439: p_product_names IN JTF_VARCHAR2_TABLE_2000,
440: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
441: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
442: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
443: p_category_names IN JTF_VARCHAR2_TABLE_2000,
444: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
445: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

Line 442: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,

438: p_visibility_name IN VARCHAR2,
439: p_product_names IN JTF_VARCHAR2_TABLE_2000,
440: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
441: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
442: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
443: p_category_names IN JTF_VARCHAR2_TABLE_2000,
444: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
445: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
446: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

Line 443: p_category_names IN JTF_VARCHAR2_TABLE_2000,

439: p_product_names IN JTF_VARCHAR2_TABLE_2000,
440: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
441: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
442: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
443: p_category_names IN JTF_VARCHAR2_TABLE_2000,
444: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
445: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
446: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
447: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 444: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,

440: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
441: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
442: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
443: p_category_names IN JTF_VARCHAR2_TABLE_2000,
444: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
445: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
446: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
447: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
448: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

Line 445: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

441: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
442: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
443: p_category_names IN JTF_VARCHAR2_TABLE_2000,
444: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
445: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
446: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
447: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
448: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
449: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

Line 446: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

442: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
443: p_category_names IN JTF_VARCHAR2_TABLE_2000,
444: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
445: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
446: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
447: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
448: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
449: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
450: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 447: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

443: p_category_names IN JTF_VARCHAR2_TABLE_2000,
444: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
445: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
446: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
447: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
448: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 448: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

444: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
445: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
446: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
447: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
448: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 449: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

445: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
446: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
447: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
448: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 450: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

446: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
447: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
448: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 451: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,

447: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
448: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 459: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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,
463: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 460: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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,
463: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
464: x_return_status OUT NOCOPY varchar2,

Line 462: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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,
466: x_msg_data OUT NOCOPY varchar2,

Line 463: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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,
466: x_msg_data OUT NOCOPY varchar2,
467: p_delim IN VARCHAR2

Line 485: p_set_products in JTF_VARCHAR2_TABLE_2000,

481: p_set_visibility in varchar2,
482: p_set_title in varchar2,
483: p_set_flow_name in VARCHAR2,
484: p_set_flow_stepcode in VARCHAR2,
485: p_set_products in JTF_VARCHAR2_TABLE_2000,
486: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
487: p_set_categories in JTF_VARCHAR2_TABLE_2000,
488: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
489: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 486: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

482: p_set_title in varchar2,
483: p_set_flow_name in VARCHAR2,
484: p_set_flow_stepcode in VARCHAR2,
485: p_set_products in JTF_VARCHAR2_TABLE_2000,
486: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
487: p_set_categories in JTF_VARCHAR2_TABLE_2000,
488: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
489: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
490: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 487: p_set_categories in JTF_VARCHAR2_TABLE_2000,

483: p_set_flow_name in VARCHAR2,
484: p_set_flow_stepcode in VARCHAR2,
485: p_set_products in JTF_VARCHAR2_TABLE_2000,
486: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
487: p_set_categories in JTF_VARCHAR2_TABLE_2000,
488: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
489: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
490: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
491: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 488: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

484: p_set_flow_stepcode in VARCHAR2,
485: p_set_products in JTF_VARCHAR2_TABLE_2000,
486: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
487: p_set_categories in JTF_VARCHAR2_TABLE_2000,
488: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
489: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
490: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
491: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
492: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 489: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

485: p_set_products in JTF_VARCHAR2_TABLE_2000,
486: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
487: p_set_categories in JTF_VARCHAR2_TABLE_2000,
488: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
489: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
490: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
491: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
492: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
493: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 490: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

486: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
487: p_set_categories in JTF_VARCHAR2_TABLE_2000,
488: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
489: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
490: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
491: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
492: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
493: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
494: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 491: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

487: p_set_categories in JTF_VARCHAR2_TABLE_2000,
488: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
489: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
490: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
491: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
492: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
493: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
494: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
495: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 492: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

488: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
489: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
490: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
491: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
492: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
493: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 493: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

489: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
490: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
491: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
492: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
493: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 494: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

490: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
491: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
492: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
493: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 495: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

491: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
492: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
493: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 496: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

492: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
493: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 497: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

493: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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

Line 518: p_set_products in JTF_VARCHAR2_TABLE_2000,

514: p_set_visibility in varchar2,
515: p_set_title in varchar2,
516: p_set_flow_name in VARCHAR2,
517: p_set_flow_stepcode in VARCHAR2,
518: p_set_products in JTF_VARCHAR2_TABLE_2000,
519: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
520: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
521: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
522: p_set_categories in JTF_VARCHAR2_TABLE_2000,

Line 519: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,

515: p_set_title in varchar2,
516: p_set_flow_name in VARCHAR2,
517: p_set_flow_stepcode in VARCHAR2,
518: p_set_products in JTF_VARCHAR2_TABLE_2000,
519: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
520: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
521: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
522: p_set_categories in JTF_VARCHAR2_TABLE_2000,
523: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

Line 520: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

516: p_set_flow_name in VARCHAR2,
517: p_set_flow_stepcode in VARCHAR2,
518: p_set_products in JTF_VARCHAR2_TABLE_2000,
519: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
520: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
521: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
522: p_set_categories in JTF_VARCHAR2_TABLE_2000,
523: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
524: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 521: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,

517: p_set_flow_stepcode in VARCHAR2,
518: p_set_products in JTF_VARCHAR2_TABLE_2000,
519: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
520: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
521: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
522: p_set_categories in JTF_VARCHAR2_TABLE_2000,
523: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
524: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
525: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 522: p_set_categories in JTF_VARCHAR2_TABLE_2000,

518: p_set_products in JTF_VARCHAR2_TABLE_2000,
519: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
520: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
521: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
522: p_set_categories in JTF_VARCHAR2_TABLE_2000,
523: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
524: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
525: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
526: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 523: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

519: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
520: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
521: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
522: p_set_categories in JTF_VARCHAR2_TABLE_2000,
523: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
524: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
525: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
526: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
527: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 524: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

520: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
521: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
522: p_set_categories in JTF_VARCHAR2_TABLE_2000,
523: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
524: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
525: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
526: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
527: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
528: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 525: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

521: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
522: p_set_categories in JTF_VARCHAR2_TABLE_2000,
523: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
524: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
525: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
526: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
527: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
528: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
529: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 526: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

522: p_set_categories in JTF_VARCHAR2_TABLE_2000,
523: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
524: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
525: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
526: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
527: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
528: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
529: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
530: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 527: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

523: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
524: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
525: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
526: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
527: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
528: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 528: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

524: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
525: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
526: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
527: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
528: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 529: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

525: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
526: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
527: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
528: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 530: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

526: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
527: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
528: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 531: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

527: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
528: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 532: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

528: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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

Line 576: p_set_products in JTF_VARCHAR2_TABLE_2000,

572: p_set_number in varchar2,
573: p_set_type_name in varchar2,
574: p_set_visibility in varchar2,
575: p_set_title in varchar2,
576: p_set_products in JTF_VARCHAR2_TABLE_2000,
577: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
578: p_set_categories in JTF_VARCHAR2_TABLE_2000,
579: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
580: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 577: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

573: p_set_type_name in varchar2,
574: p_set_visibility in varchar2,
575: p_set_title in varchar2,
576: p_set_products in JTF_VARCHAR2_TABLE_2000,
577: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
578: p_set_categories in JTF_VARCHAR2_TABLE_2000,
579: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
580: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
581: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 578: p_set_categories in JTF_VARCHAR2_TABLE_2000,

574: p_set_visibility in varchar2,
575: p_set_title in varchar2,
576: p_set_products in JTF_VARCHAR2_TABLE_2000,
577: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
578: p_set_categories in JTF_VARCHAR2_TABLE_2000,
579: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
580: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
581: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
582: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 579: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

575: p_set_title in varchar2,
576: p_set_products in JTF_VARCHAR2_TABLE_2000,
577: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
578: p_set_categories in JTF_VARCHAR2_TABLE_2000,
579: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
580: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
581: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
582: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
583: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 580: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

576: p_set_products in JTF_VARCHAR2_TABLE_2000,
577: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
578: p_set_categories in JTF_VARCHAR2_TABLE_2000,
579: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
580: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
581: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
582: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
583: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
584: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 581: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

577: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
578: p_set_categories in JTF_VARCHAR2_TABLE_2000,
579: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
580: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
581: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
582: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
583: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
584: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
585: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 582: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

578: p_set_categories in JTF_VARCHAR2_TABLE_2000,
579: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
580: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
581: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
582: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
583: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
584: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
585: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
586: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 583: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

579: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
580: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
581: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
582: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
583: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
584: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 584: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

580: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
581: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
582: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
583: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
584: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 585: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

581: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
582: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
583: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
584: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 586: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

582: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
583: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
584: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 587: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

583: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
584: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 588: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

584: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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

Line 608: p_set_products in JTF_VARCHAR2_TABLE_2000,

604: p_set_number in varchar2,
605: p_set_type_name in varchar2,
606: p_set_visibility in varchar2,
607: p_set_title in varchar2,
608: p_set_products in JTF_VARCHAR2_TABLE_2000,
609: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
610: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
611: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
612: p_set_categories in JTF_VARCHAR2_TABLE_2000,

Line 609: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,

605: p_set_type_name in varchar2,
606: p_set_visibility in varchar2,
607: p_set_title in varchar2,
608: p_set_products in JTF_VARCHAR2_TABLE_2000,
609: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
610: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
611: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
612: p_set_categories in JTF_VARCHAR2_TABLE_2000,
613: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

Line 610: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

606: p_set_visibility in varchar2,
607: p_set_title in varchar2,
608: p_set_products in JTF_VARCHAR2_TABLE_2000,
609: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
610: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
611: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
612: p_set_categories in JTF_VARCHAR2_TABLE_2000,
613: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
614: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 611: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,

607: p_set_title in varchar2,
608: p_set_products in JTF_VARCHAR2_TABLE_2000,
609: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
610: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
611: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
612: p_set_categories in JTF_VARCHAR2_TABLE_2000,
613: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
614: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
615: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 612: p_set_categories in JTF_VARCHAR2_TABLE_2000,

608: p_set_products in JTF_VARCHAR2_TABLE_2000,
609: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
610: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
611: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
612: p_set_categories in JTF_VARCHAR2_TABLE_2000,
613: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
614: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
615: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
616: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 613: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

609: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
610: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
611: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
612: p_set_categories in JTF_VARCHAR2_TABLE_2000,
613: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
614: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
615: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
616: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
617: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 614: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

610: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
611: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
612: p_set_categories in JTF_VARCHAR2_TABLE_2000,
613: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
614: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
615: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
616: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
617: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
618: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 615: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

611: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
612: p_set_categories in JTF_VARCHAR2_TABLE_2000,
613: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
614: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
615: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
616: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
617: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
618: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
619: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 616: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

612: p_set_categories in JTF_VARCHAR2_TABLE_2000,
613: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
614: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
615: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
616: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
617: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
618: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
619: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
620: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 617: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

613: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
614: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
615: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
616: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
617: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
618: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 618: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

614: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
615: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
616: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
617: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
618: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 619: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

615: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
616: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
617: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
618: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 620: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

616: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
617: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
618: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 621: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

617: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
618: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 622: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

618: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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