1: package body XDP_FE_SW_GEN_LOOKUP_PKG as
2: /* $Header: XDPFEGLB.pls 120.2 2005/07/15 01:18:30 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_FE_SW_GEN_LOOKUP_ID in NUMBER,
306: -- user_id := 1;
307: --end if;
308: user_id := fnd_load_util.owner_id(X_OWNER);
309:
310: XDP_FE_SW_GEN_LOOKUP_PKG.UPDATE_ROW (
311: X_FE_SW_GEN_LOOKUP_ID => X_FE_SW_GEN_LOOKUP_ID,
312: X_FETYPE_ID => X_FETYPE_ID,
313: X_SW_GENERIC => X_SW_GENERIC,
314: X_ADAPTER_TYPE => X_ADAPTER_TYPE,
321: X_LAST_UPDATE_LOGIN => 0);
322:
323: exception
324: when NO_DATA_FOUND then
325: XDP_FE_SW_GEN_LOOKUP_PKG.INSERT_ROW (
326: X_ROWID => row_id,
327: X_FE_SW_GEN_LOOKUP_ID => X_FE_SW_GEN_LOOKUP_ID,
328: X_FETYPE_ID => X_FETYPE_ID,
329: X_SW_GENERIC => X_SW_GENERIC,
363:
364: end TRANSLATE_ROW;
365:
366:
367: end XDP_FE_SW_GEN_LOOKUP_PKG;