1: package body PER_CAGR_APIS_PKG as
2: /* $Header: peapilct.pkb 120.2 2011/04/28 10:18:02 sidsaxen ship $ */
3:
4: procedure KEY_TO_IDS (
5: X_API_NAME in VARCHAR2,
175: else
176: user_id := 0;
177: end if;
178:
179: PER_CAGR_APIS_PKG.UPDATE_ROW (
180: X_CAGR_API_ID => X_CAGR_API_ID,
181: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
182: X_CATEGORY_NAME => X_CATEGORY_NAME,
183: X_API_NAME => X_API_NAME,
188: exception
189: when NO_DATA_FOUND then
190:
191:
192: PER_CAGR_APIS_PKG.INSERT_ROW(
193: X_ROWID => X_ROW_ID,
194: X_CAGR_API_ID => X_CAGR_API_ID,
195: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
196: X_CATEGORY_NAME => X_CATEGORY_NAME,
389: and T.LANGUAGE = L.LANGUAGE_CODE);
390: end ADD_LANGUAGE;
391:
392:
393: end PER_CAGR_APIS_PKG;