112: P_VALUE,
113: P_DEFAULT_VALUE,
114: P_USER_SETTABLE,
115: sysdate,
116: FND_GLOBAL.user_id,
117: sysdate,
118: FND_GLOBAL.user_id,
119: FND_GLOBAL.login_id
120: );
114: P_USER_SETTABLE,
115: sysdate,
116: FND_GLOBAL.user_id,
117: sysdate,
118: FND_GLOBAL.user_id,
119: FND_GLOBAL.login_id
120: );
121:
122: IF SQL%NOTFOUND THEN
115: sysdate,
116: FND_GLOBAL.user_id,
117: sysdate,
118: FND_GLOBAL.user_id,
119: FND_GLOBAL.login_id
120: );
121:
122: IF SQL%NOTFOUND THEN
123: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
156: l_PARAMETER_ID,
157: P_USER_PARAMETER_NAME,
158: P_DESCRIPTION,
159: sysdate,
160: FND_GLOBAL.user_id,
161: sysdate,
162: FND_GLOBAL.user_id,
163: FND_GLOBAL.login_id,
164: L.LANGUAGE_CODE,
158: P_DESCRIPTION,
159: sysdate,
160: FND_GLOBAL.user_id,
161: sysdate,
162: FND_GLOBAL.user_id,
163: FND_GLOBAL.login_id,
164: L.LANGUAGE_CODE,
165: userenv('LANG')
166: from FND_LANGUAGES L
159: sysdate,
160: FND_GLOBAL.user_id,
161: sysdate,
162: FND_GLOBAL.user_id,
163: FND_GLOBAL.login_id,
164: L.LANGUAGE_CODE,
165: userenv('LANG')
166: from FND_LANGUAGES L
167: where L.INSTALLED_FLAG in ('I', 'B')
477: VALUE = P_VALUE,
478: DEFAULT_VALUE = P_DEFAULT_VALUE,
479: USER_SETTABLE = P_USER_SETTABLE,
480: LAST_UPDATE_DATE = sysdate,
481: LAST_UPDATED_BY = FND_GLOBAL.user_id,
482: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
483: where PARAMETER_ID = P_PARAMETER_ID;
484:
485: IF SQL%NOTFOUND THEN
478: DEFAULT_VALUE = P_DEFAULT_VALUE,
479: USER_SETTABLE = P_USER_SETTABLE,
480: LAST_UPDATE_DATE = sysdate,
481: LAST_UPDATED_BY = FND_GLOBAL.user_id,
482: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
483: where PARAMETER_ID = P_PARAMETER_ID;
484:
485: IF SQL%NOTFOUND THEN
486: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');