301: INSERT INTO icx_cat_zone_secure_attributes
302: (zone_id, securing_attribute, ip_category_id, created_by, creation_date,
303: last_updated_by, last_update_date, last_update_login)
304: SELECT p_new_zone_ids(i), 'CATEGORY', p_zone_categories(p_new_zone_ids(i))(j),
305: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
306: fnd_global.login_id
307: FROM dual;
308:
309: END LOOP;
302: (zone_id, securing_attribute, ip_category_id, created_by, creation_date,
303: last_updated_by, last_update_date, last_update_login)
304: SELECT p_new_zone_ids(i), 'CATEGORY', p_zone_categories(p_new_zone_ids(i))(j),
305: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
306: fnd_global.login_id
307: FROM dual;
308:
309: END LOOP;
310: