1: package body PER_CAGR_APIS_PKG as
2: /* $Header: peapilct.pkb 120.1 2006/06/20 09:24:40 bshukla noship $ */
3:
4: procedure KEY_TO_IDS (
5: X_API_NAME in VARCHAR2,
155: else
156: user_id := 0;
157: end if;
158:
159: PER_CAGR_APIS_PKG.UPDATE_ROW (
160: X_CAGR_API_ID => X_CAGR_API_ID,
161: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
162: X_CATEGORY_NAME => X_CATEGORY_NAME,
163: X_API_NAME => X_API_NAME,
168: exception
169: when NO_DATA_FOUND then
170:
171:
172: PER_CAGR_APIS_PKG.INSERT_ROW(
173: X_ROWID => X_ROW_ID,
174: X_CAGR_API_ID => X_CAGR_API_ID,
175: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
176: X_CATEGORY_NAME => X_CATEGORY_NAME,
351: and T.LANGUAGE = L.LANGUAGE_CODE);
352: end ADD_LANGUAGE;
353:
354:
355: end PER_CAGR_APIS_PKG;