1: package body JTF_AE_PROFPROPS as
2: /* $Header: JTFAEPPB.pls 120.1 2005/07/02 02:00:01 appldev ship $ */
3: procedure INSERT_ROW (
4: X_PROFILEPROPERTIES_ID in NUMBER,
5: X_PROFILE_MAPPINGS_ID in NUMBER,
339: l_user_id := 1;
340: end if;
341:
342: -- Update row if present
343: JTF_AE_PROFPROPS.UPDATE_ROW (
344: X_PROFILEPROPERTIES_ID => X_PROFILE_MAPPINGS_ID,
345: X_PROFILE_MAPPINGS_ID => X_PROFILE_MAPPINGS_ID,
346: X_ATTRNAME => X_ATTRNAME,
347: X_OWNER_APPLICATION_ID => X_OWNER_APPLICATION_ID,
355: X_LAST_UPDATE_LOGIN => 0);
356: exception
357: when NO_DATA_FOUND then
358: -- Insert a row
359: JTF_AE_PROFPROPS.INSERT_ROW (
360: X_PROFILEPROPERTIES_ID => X_PROFILE_MAPPINGS_ID,
361: X_PROFILE_MAPPINGS_ID => X_PROFILE_MAPPINGS_ID,
362: X_ATTRNAME => X_ATTRNAME,
363: X_OWNER_APPLICATION_ID => X_OWNER_APPLICATION_ID,
375:
376:
377: end LOAD_ROW;
378:
379: end JTF_AE_PROFPROPS;