1: package body XDP_ACTION_CODES_PKG as
2: /* $Header: XDPACTNB.pls 120.1 2005/06/08 23:36:10 appldev $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in OUT NOCOPY VARCHAR2,
268: if (X_OWNER = 'SEED') then
269: user_id := 1;
270: end if;
271:
272: XDP_ACTION_CODES_PKG.UPDATE_ROW (
273: X_ACTION_CODE_ID => X_ACTION_CODE_ID,
274: X_ACTION_CODE => X_ACTION_CODE,
275: X_DISPLAY_NAME => X_DISPLAY_NAME,
276: X_DESCRIPTION => X_DESCRIPTION,
279: X_LAST_UPDATE_LOGIN => 0);
280:
281: exception
282: when NO_DATA_FOUND then
283: XDP_ACTION_CODES_PKG.INSERT_ROW (
284: X_ROWID => row_id,
285: X_ACTION_CODE_ID => X_ACTION_CODE_ID,
286: X_ACTION_CODE => X_ACTION_CODE,
287: X_DISPLAY_NAME => X_DISPLAY_NAME,
316:
317: end TRANSLATE_ROW;
318:
319:
320: end XDP_ACTION_CODES_PKG;