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 156: p_set_products in JTF_VARCHAR2_TABLE_2000,

152: p_set_visibility in varchar2,
153: p_set_title in varchar2,
154: p_set_flow_name in VARCHAR2 DEFAULT NULL,
155: p_set_flow_stepcode in VARCHAR2 DEFAULT NULL,
156: p_set_products in JTF_VARCHAR2_TABLE_2000,
157: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
158: p_set_categories in JTF_VARCHAR2_TABLE_2000,
159: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
160: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 157: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

153: p_set_title in varchar2,
154: p_set_flow_name in VARCHAR2 DEFAULT NULL,
155: p_set_flow_stepcode in VARCHAR2 DEFAULT NULL,
156: p_set_products in JTF_VARCHAR2_TABLE_2000,
157: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
158: p_set_categories in JTF_VARCHAR2_TABLE_2000,
159: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
160: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
161: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 158: p_set_categories in JTF_VARCHAR2_TABLE_2000,

154: p_set_flow_name in VARCHAR2 DEFAULT NULL,
155: p_set_flow_stepcode in VARCHAR2 DEFAULT NULL,
156: p_set_products in JTF_VARCHAR2_TABLE_2000,
157: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
158: p_set_categories in JTF_VARCHAR2_TABLE_2000,
159: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
160: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
161: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
162: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 159: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

155: p_set_flow_stepcode in VARCHAR2 DEFAULT NULL,
156: p_set_products in JTF_VARCHAR2_TABLE_2000,
157: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
158: p_set_categories in JTF_VARCHAR2_TABLE_2000,
159: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
160: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
161: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
162: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
163: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 160: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

156: p_set_products in JTF_VARCHAR2_TABLE_2000,
157: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
158: p_set_categories in JTF_VARCHAR2_TABLE_2000,
159: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
160: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
161: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
162: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
163: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
164: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 161: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

157: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
158: p_set_categories in JTF_VARCHAR2_TABLE_2000,
159: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
160: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
161: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
162: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
163: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
164: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
165: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 162: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

158: p_set_categories in JTF_VARCHAR2_TABLE_2000,
159: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
160: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
161: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
162: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
163: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
164: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
165: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
166: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 163: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

159: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
160: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
161: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
162: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
163: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
164: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 164: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

160: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
161: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
162: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
163: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
164: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 165: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

161: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
162: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
163: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
164: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 166: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

162: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
163: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
164: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 167: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

163: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
164: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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;

Line 168: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

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

Line 186: p_set_products in JTF_VARCHAR2_TABLE_2000,

182: p_set_number in varchar2,
183: p_set_type_name in varchar2,
184: p_set_visibility in varchar2,
185: p_set_title in varchar2,
186: p_set_products in JTF_VARCHAR2_TABLE_2000,
187: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
188: p_set_categories in JTF_VARCHAR2_TABLE_2000,
189: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
190: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 187: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

183: p_set_type_name in varchar2,
184: p_set_visibility in varchar2,
185: p_set_title in varchar2,
186: p_set_products in JTF_VARCHAR2_TABLE_2000,
187: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
188: p_set_categories in JTF_VARCHAR2_TABLE_2000,
189: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
190: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
191: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 188: p_set_categories in JTF_VARCHAR2_TABLE_2000,

184: p_set_visibility in varchar2,
185: p_set_title in varchar2,
186: p_set_products in JTF_VARCHAR2_TABLE_2000,
187: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
188: p_set_categories in JTF_VARCHAR2_TABLE_2000,
189: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
190: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
191: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
192: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 189: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

185: p_set_title in varchar2,
186: p_set_products in JTF_VARCHAR2_TABLE_2000,
187: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
188: p_set_categories in JTF_VARCHAR2_TABLE_2000,
189: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
190: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
191: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
192: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
193: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 190: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

186: p_set_products in JTF_VARCHAR2_TABLE_2000,
187: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
188: p_set_categories in JTF_VARCHAR2_TABLE_2000,
189: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
190: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
191: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
192: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
193: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
194: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 191: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

187: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
188: p_set_categories in JTF_VARCHAR2_TABLE_2000,
189: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
190: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
191: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
192: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
193: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
194: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
195: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 192: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

188: p_set_categories in JTF_VARCHAR2_TABLE_2000,
189: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
190: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
191: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
192: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
193: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
194: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
195: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
196: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 193: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

189: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
190: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
191: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
192: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
193: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
194: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 194: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

190: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
191: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
192: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
193: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
194: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 195: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

191: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
192: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
193: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
194: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 196: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

192: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
193: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
194: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 197: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

193: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
194: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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;

Line 198: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

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

Line 307: p_product_names IN JTF_VARCHAR2_TABLE_2000,

303: FUNCTION VALIDATE_SOLN_ATTRIBUTES
304: (
305: p_set_type_id IN NUMBER,
306: p_visibility_name IN VARCHAR2,
307: p_product_names IN JTF_VARCHAR2_TABLE_2000,
308: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
309: p_category_names IN JTF_VARCHAR2_TABLE_2000,
310: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
311: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

Line 308: p_platform_names IN JTF_VARCHAR2_TABLE_2000,

304: (
305: p_set_type_id IN NUMBER,
306: p_visibility_name IN VARCHAR2,
307: p_product_names IN JTF_VARCHAR2_TABLE_2000,
308: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
309: p_category_names IN JTF_VARCHAR2_TABLE_2000,
310: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
311: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
312: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

Line 309: p_category_names IN JTF_VARCHAR2_TABLE_2000,

305: p_set_type_id IN NUMBER,
306: p_visibility_name IN VARCHAR2,
307: p_product_names IN JTF_VARCHAR2_TABLE_2000,
308: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
309: p_category_names IN JTF_VARCHAR2_TABLE_2000,
310: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
311: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
312: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
313: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 310: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,

306: p_visibility_name IN VARCHAR2,
307: p_product_names IN JTF_VARCHAR2_TABLE_2000,
308: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
309: p_category_names IN JTF_VARCHAR2_TABLE_2000,
310: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
311: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
312: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
313: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
314: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

Line 311: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

307: p_product_names IN JTF_VARCHAR2_TABLE_2000,
308: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
309: p_category_names IN JTF_VARCHAR2_TABLE_2000,
310: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
311: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
312: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
313: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
314: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
315: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

Line 312: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

308: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
309: p_category_names IN JTF_VARCHAR2_TABLE_2000,
310: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
311: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
312: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
313: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
314: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
315: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
316: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 313: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

309: p_category_names IN JTF_VARCHAR2_TABLE_2000,
310: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
311: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
312: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
313: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
314: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 314: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

310: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
311: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
312: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
313: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
314: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 315: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

311: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
312: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
313: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
314: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 316: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

312: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
313: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
314: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 317: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,

313: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
314: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 325: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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

Line 326: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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

Line 328: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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

Line 329: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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

Line 340: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,

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

Line 342: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,

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

Line 343: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,

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,
346: p_element_type_ids IN JTF_NUMBER_TABLE,
347: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,

Line 344: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,

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

Line 347: p_element_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,
351: p_set_product_ids IN JTF_NUMBER_TABLE,

Line 348: p_element_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,
351: p_set_product_ids IN JTF_NUMBER_TABLE,
352: p_set_platform_ids IN JTF_NUMBER_TABLE,

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

Line 397: p_product_names IN JTF_VARCHAR2_TABLE_2000,

393: FUNCTION VALIDATE_SOLN_ATTRIBUTES_2
394: (
395: p_set_type_id IN NUMBER,
396: p_visibility_name IN VARCHAR2,
397: p_product_names IN JTF_VARCHAR2_TABLE_2000,
398: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
399: p_category_names IN JTF_VARCHAR2_TABLE_2000,
400: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
401: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

Line 398: p_platform_names IN JTF_VARCHAR2_TABLE_2000,

394: (
395: p_set_type_id IN NUMBER,
396: p_visibility_name IN VARCHAR2,
397: p_product_names IN JTF_VARCHAR2_TABLE_2000,
398: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
399: p_category_names IN JTF_VARCHAR2_TABLE_2000,
400: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
401: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
402: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

Line 399: p_category_names IN JTF_VARCHAR2_TABLE_2000,

395: p_set_type_id IN NUMBER,
396: p_visibility_name IN VARCHAR2,
397: p_product_names IN JTF_VARCHAR2_TABLE_2000,
398: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
399: p_category_names IN JTF_VARCHAR2_TABLE_2000,
400: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
401: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
402: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
403: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 400: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,

396: p_visibility_name IN VARCHAR2,
397: p_product_names IN JTF_VARCHAR2_TABLE_2000,
398: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
399: p_category_names IN JTF_VARCHAR2_TABLE_2000,
400: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
401: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
402: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
403: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
404: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

Line 401: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

397: p_product_names IN JTF_VARCHAR2_TABLE_2000,
398: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
399: p_category_names IN JTF_VARCHAR2_TABLE_2000,
400: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
401: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
402: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
403: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
404: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
405: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

Line 402: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

398: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
399: p_category_names IN JTF_VARCHAR2_TABLE_2000,
400: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
401: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
402: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
403: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
404: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
405: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
406: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 403: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

399: p_category_names IN JTF_VARCHAR2_TABLE_2000,
400: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
401: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
402: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
403: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
404: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 404: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

400: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
401: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
402: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
403: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
404: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 405: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

401: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
402: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
403: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
404: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 406: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

402: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
403: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
404: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 407: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,

403: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
404: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 415: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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

Line 416: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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

Line 418: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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

Line 419: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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

Line 431: p_product_names IN JTF_VARCHAR2_TABLE_2000,

427: FUNCTION VALIDATE_SOLN_ATTRIBUTES_3
428: (
429: p_set_type_id IN NUMBER,
430: p_visibility_name IN VARCHAR2,
431: p_product_names IN JTF_VARCHAR2_TABLE_2000,
432: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
433: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
434: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
435: p_category_names IN JTF_VARCHAR2_TABLE_2000,

Line 432: p_product_segments IN JTF_VARCHAR2_TABLE_2000,

428: (
429: p_set_type_id IN NUMBER,
430: p_visibility_name IN VARCHAR2,
431: p_product_names IN JTF_VARCHAR2_TABLE_2000,
432: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
433: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
434: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
435: p_category_names IN JTF_VARCHAR2_TABLE_2000,
436: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,

Line 433: p_platform_names IN JTF_VARCHAR2_TABLE_2000,

429: p_set_type_id IN NUMBER,
430: p_visibility_name IN VARCHAR2,
431: p_product_names IN JTF_VARCHAR2_TABLE_2000,
432: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
433: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
434: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
435: p_category_names IN JTF_VARCHAR2_TABLE_2000,
436: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
437: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

Line 434: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,

430: p_visibility_name IN VARCHAR2,
431: p_product_names IN JTF_VARCHAR2_TABLE_2000,
432: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
433: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
434: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
435: p_category_names IN JTF_VARCHAR2_TABLE_2000,
436: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
437: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
438: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

Line 435: p_category_names IN JTF_VARCHAR2_TABLE_2000,

431: p_product_names IN JTF_VARCHAR2_TABLE_2000,
432: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
433: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
434: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
435: p_category_names IN JTF_VARCHAR2_TABLE_2000,
436: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
437: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
438: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
439: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 436: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,

432: p_product_segments IN JTF_VARCHAR2_TABLE_2000,
433: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
434: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
435: p_category_names IN JTF_VARCHAR2_TABLE_2000,
436: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
437: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
438: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
439: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
440: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

Line 437: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,

433: p_platform_names IN JTF_VARCHAR2_TABLE_2000,
434: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
435: p_category_names IN JTF_VARCHAR2_TABLE_2000,
436: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
437: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
438: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
439: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
440: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
441: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

Line 438: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,

434: p_platform_segments IN JTF_VARCHAR2_TABLE_2000,
435: p_category_names IN JTF_VARCHAR2_TABLE_2000,
436: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
437: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
438: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
439: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
440: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
441: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
442: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

Line 439: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,

435: p_category_names IN JTF_VARCHAR2_TABLE_2000,
436: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
437: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
438: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
439: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
440: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 440: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,

436: p_category_last_names IN JTF_VARCHAR2_TABLE_2000,
437: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
438: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
439: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
440: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 441: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,

437: p_ele_nums IN JTF_VARCHAR2_TABLE_2000,
438: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
439: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
440: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 442: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,

438: p_ele_upd_nums IN JTF_VARCHAR2_TABLE_2000,
439: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
440: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 443: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,

439: p_ele_upd_content_types IN JTF_VARCHAR2_TABLE_2000,
440: p_ele_upd_dist_names IN JTF_VARCHAR2_TABLE_2000,
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,

Line 451: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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

Line 452: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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

Line 454: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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

Line 455: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

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

Line 477: p_set_products in JTF_VARCHAR2_TABLE_2000,

473: p_set_visibility in varchar2,
474: p_set_title in varchar2,
475: p_set_flow_name in VARCHAR2,
476: p_set_flow_stepcode in VARCHAR2,
477: p_set_products in JTF_VARCHAR2_TABLE_2000,
478: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
479: p_set_categories in JTF_VARCHAR2_TABLE_2000,
480: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
481: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 478: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

474: p_set_title in varchar2,
475: p_set_flow_name in VARCHAR2,
476: p_set_flow_stepcode in VARCHAR2,
477: p_set_products in JTF_VARCHAR2_TABLE_2000,
478: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
479: p_set_categories in JTF_VARCHAR2_TABLE_2000,
480: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
481: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
482: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 479: p_set_categories in JTF_VARCHAR2_TABLE_2000,

475: p_set_flow_name in VARCHAR2,
476: p_set_flow_stepcode in VARCHAR2,
477: p_set_products in JTF_VARCHAR2_TABLE_2000,
478: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
479: p_set_categories in JTF_VARCHAR2_TABLE_2000,
480: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
481: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
482: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
483: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 480: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

476: p_set_flow_stepcode in VARCHAR2,
477: p_set_products in JTF_VARCHAR2_TABLE_2000,
478: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
479: p_set_categories in JTF_VARCHAR2_TABLE_2000,
480: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
481: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
482: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
483: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
484: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 481: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

477: p_set_products in JTF_VARCHAR2_TABLE_2000,
478: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
479: p_set_categories in JTF_VARCHAR2_TABLE_2000,
480: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
481: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
482: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
483: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
484: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
485: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 482: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

478: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
479: p_set_categories in JTF_VARCHAR2_TABLE_2000,
480: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
481: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
482: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
483: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
484: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
485: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
486: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 483: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

479: p_set_categories in JTF_VARCHAR2_TABLE_2000,
480: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
481: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
482: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
483: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
484: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
485: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
486: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
487: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 484: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

480: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
481: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
482: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
483: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
484: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
485: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 485: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

481: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
482: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
483: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
484: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
485: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 486: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

482: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
483: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
484: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
485: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 487: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

483: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
484: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
485: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 488: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

484: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
485: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 489: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

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

Line 510: p_set_products in JTF_VARCHAR2_TABLE_2000,

506: p_set_visibility in varchar2,
507: p_set_title in varchar2,
508: p_set_flow_name in VARCHAR2,
509: p_set_flow_stepcode in VARCHAR2,
510: p_set_products in JTF_VARCHAR2_TABLE_2000,
511: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
512: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
513: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
514: p_set_categories in JTF_VARCHAR2_TABLE_2000,

Line 511: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,

507: p_set_title in varchar2,
508: p_set_flow_name in VARCHAR2,
509: p_set_flow_stepcode in VARCHAR2,
510: p_set_products in JTF_VARCHAR2_TABLE_2000,
511: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
512: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
513: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
514: p_set_categories in JTF_VARCHAR2_TABLE_2000,
515: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

Line 512: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

508: p_set_flow_name in VARCHAR2,
509: p_set_flow_stepcode in VARCHAR2,
510: p_set_products in JTF_VARCHAR2_TABLE_2000,
511: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
512: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
513: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
514: p_set_categories in JTF_VARCHAR2_TABLE_2000,
515: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
516: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 513: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,

509: p_set_flow_stepcode in VARCHAR2,
510: p_set_products in JTF_VARCHAR2_TABLE_2000,
511: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
512: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
513: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
514: p_set_categories in JTF_VARCHAR2_TABLE_2000,
515: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
516: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
517: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 514: p_set_categories in JTF_VARCHAR2_TABLE_2000,

510: p_set_products in JTF_VARCHAR2_TABLE_2000,
511: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
512: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
513: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
514: p_set_categories in JTF_VARCHAR2_TABLE_2000,
515: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
516: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
517: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
518: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 515: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

511: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
512: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
513: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
514: p_set_categories in JTF_VARCHAR2_TABLE_2000,
515: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
516: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
517: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
518: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
519: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 516: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

512: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
513: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
514: p_set_categories in JTF_VARCHAR2_TABLE_2000,
515: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
516: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
517: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
518: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
519: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
520: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 517: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

513: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
514: p_set_categories in JTF_VARCHAR2_TABLE_2000,
515: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
516: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
517: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
518: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
519: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
520: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
521: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 518: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

514: p_set_categories in JTF_VARCHAR2_TABLE_2000,
515: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
516: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
517: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
518: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
519: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
520: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
521: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
522: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 519: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

515: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
516: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
517: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
518: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
519: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
520: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 520: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

516: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
517: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
518: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
519: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
520: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 521: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

517: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
518: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
519: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
520: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 522: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

518: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
519: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
520: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 523: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

519: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
520: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 524: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

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

Line 568: p_set_products in JTF_VARCHAR2_TABLE_2000,

564: p_set_number in varchar2,
565: p_set_type_name in varchar2,
566: p_set_visibility in varchar2,
567: p_set_title in varchar2,
568: p_set_products in JTF_VARCHAR2_TABLE_2000,
569: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
570: p_set_categories in JTF_VARCHAR2_TABLE_2000,
571: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
572: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 569: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

565: p_set_type_name in varchar2,
566: p_set_visibility in varchar2,
567: p_set_title in varchar2,
568: p_set_products in JTF_VARCHAR2_TABLE_2000,
569: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
570: p_set_categories in JTF_VARCHAR2_TABLE_2000,
571: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
572: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
573: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 570: p_set_categories in JTF_VARCHAR2_TABLE_2000,

566: p_set_visibility in varchar2,
567: p_set_title in varchar2,
568: p_set_products in JTF_VARCHAR2_TABLE_2000,
569: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
570: p_set_categories in JTF_VARCHAR2_TABLE_2000,
571: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
572: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
573: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
574: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 571: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

567: p_set_title in varchar2,
568: p_set_products in JTF_VARCHAR2_TABLE_2000,
569: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
570: p_set_categories in JTF_VARCHAR2_TABLE_2000,
571: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
572: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
573: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
574: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
575: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 572: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

568: p_set_products in JTF_VARCHAR2_TABLE_2000,
569: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
570: p_set_categories in JTF_VARCHAR2_TABLE_2000,
571: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
572: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
573: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
574: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
575: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
576: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 573: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

569: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
570: p_set_categories in JTF_VARCHAR2_TABLE_2000,
571: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
572: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
573: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
574: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
575: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
576: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
577: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 574: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

570: p_set_categories in JTF_VARCHAR2_TABLE_2000,
571: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
572: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
573: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
574: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
575: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
576: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
577: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
578: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 575: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

571: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
572: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
573: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
574: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
575: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
576: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 576: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

572: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
573: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
574: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
575: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
576: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 577: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

573: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
574: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
575: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
576: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 578: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

574: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
575: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
576: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 579: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

575: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
576: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 580: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

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

Line 600: p_set_products in JTF_VARCHAR2_TABLE_2000,

596: p_set_number in varchar2,
597: p_set_type_name in varchar2,
598: p_set_visibility in varchar2,
599: p_set_title in varchar2,
600: p_set_products in JTF_VARCHAR2_TABLE_2000,
601: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
602: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
603: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
604: p_set_categories in JTF_VARCHAR2_TABLE_2000,

Line 601: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,

597: p_set_type_name in varchar2,
598: p_set_visibility in varchar2,
599: p_set_title in varchar2,
600: p_set_products in JTF_VARCHAR2_TABLE_2000,
601: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
602: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
603: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
604: p_set_categories in JTF_VARCHAR2_TABLE_2000,
605: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

Line 602: p_set_platforms in JTF_VARCHAR2_TABLE_2000,

598: p_set_visibility in varchar2,
599: p_set_title in varchar2,
600: p_set_products in JTF_VARCHAR2_TABLE_2000,
601: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
602: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
603: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
604: p_set_categories in JTF_VARCHAR2_TABLE_2000,
605: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
606: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

Line 603: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,

599: p_set_title in varchar2,
600: p_set_products in JTF_VARCHAR2_TABLE_2000,
601: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
602: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
603: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
604: p_set_categories in JTF_VARCHAR2_TABLE_2000,
605: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
606: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
607: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

Line 604: p_set_categories in JTF_VARCHAR2_TABLE_2000,

600: p_set_products in JTF_VARCHAR2_TABLE_2000,
601: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
602: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
603: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
604: p_set_categories in JTF_VARCHAR2_TABLE_2000,
605: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
606: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
607: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
608: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

Line 605: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,

601: p_set_product_segments in JTF_VARCHAR2_TABLE_2000,
602: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
603: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
604: p_set_categories in JTF_VARCHAR2_TABLE_2000,
605: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
606: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
607: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
608: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
609: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

Line 606: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,

602: p_set_platforms in JTF_VARCHAR2_TABLE_2000,
603: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
604: p_set_categories in JTF_VARCHAR2_TABLE_2000,
605: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
606: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
607: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
608: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
609: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
610: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 607: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,

603: p_set_platform_segments in JTF_VARCHAR2_TABLE_2000,
604: p_set_categories in JTF_VARCHAR2_TABLE_2000,
605: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
606: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
607: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
608: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
609: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
610: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
611: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 608: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,

604: p_set_categories in JTF_VARCHAR2_TABLE_2000,
605: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
606: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
607: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
608: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
609: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
610: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
611: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
612: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

Line 609: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,

605: p_ele_type_name_tbl in JTF_VARCHAR2_TABLE_2000,
606: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
607: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
608: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
609: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
610: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 610: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,

606: p_ele_dist_tbl in JTF_VARCHAR2_TABLE_2000,
607: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
608: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
609: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
610: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 611: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,

607: p_ele_content_type_tbl in JTF_VARCHAR2_TABLE_2000,
608: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
609: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
610: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 612: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,

608: p_ele_summary_tbl in JTF_VARCHAR2_TABLE_2000,
609: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
610: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 613: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,

609: p_ele_nos_tbl in JTF_VARCHAR2_TABLE_2000,
610: p_ele_nos_upd_tbl in JTF_VARCHAR2_TABLE_2000,
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,

Line 614: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,

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