14: from PER_CAGR_APIS API
15: where API.API_NAME = X_API_NAME;
16:
17: cursor CSR_SEQUENCE is
18: select PER_CAGR_APIS_S.nextval
19: from dual;
20:
21: begin
22:
246: X_LAST_UPDATED_BY in NUMBER,
247: X_LAST_UPDATE_LOGIN in NUMBER
248: ) is
249: begin
250: update PER_CAGR_APIS set
251: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
252: CATEGORY_NAME = X_CATEGORY_NAME,
253: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
254: LAST_UPDATED_BY = X_LAST_UPDATED_BY,