242: ELSE
243: USER_ID := 0;
244: END IF;
245:
246: update cn_table_maps_all set
247: MAPPING_TYPE = x_MAPPING_TYPE,
248: SOURCE_TABLE_ID = to_number(x_SOURCE_TABLE_ID),
249: DESTINATION_TABLE_ID = to_number(x_DESTINATION_TABLE_ID),
250: MODULE_ID = to_number(x_MODULE_ID),
269: and ORG_ID = x_ORG_ID;
270:
271: IF (SQL%NOTFOUND) THEN
272: -- Insert new record to CN_OBJECTS_TABLE table
273: insert into cn_table_maps_all
274: (TABLE_MAP_ID,
275: MAPPING_TYPE,
276: SOURCE_TABLE_ID,
277: DESTINATION_TABLE_ID,