224: ELSE
225: USER_ID := 0;
226: END IF;
227:
228: update cn_repositories_all set
229: REPOSITORY_ID = to_number(x_REPOSITORY_ID),
230: VERSION = x_VERSION,
231: SCHEMA = x_SCHEMA,
232: STATUS = x_STATUS,
291: REPOSITORY_ID = X_REPOSITORY_ID
292: and ORG_ID = X_ORG_ID;
293:
294: IF (SQL%NOTFOUND) THEN
295: -- Insert new record to CN_REPOSITORIES_ALL table
296: insert into CN_REPOSITORIES_ALL
297: (
298: REPOSITORY_ID,
299: VERSION,
292: and ORG_ID = X_ORG_ID;
293:
294: IF (SQL%NOTFOUND) THEN
295: -- Insert new record to CN_REPOSITORIES_ALL table
296: insert into CN_REPOSITORIES_ALL
297: (
298: REPOSITORY_ID,
299: VERSION,
300: SCHEMA,