140: X_ATTRIBUTE14,
141: X_ATTRIBUTE15,
142:
143: sysdate,
144: fnd_global.user_id,
145: sysdate,
146: fnd_global.user_id,
147: fnd_global.login_id
148:
142:
143: sysdate,
144: fnd_global.user_id,
145: sysdate,
146: fnd_global.user_id,
147: fnd_global.login_id
148:
149: );
150:
143: sysdate,
144: fnd_global.user_id,
145: sysdate,
146: fnd_global.user_id,
147: fnd_global.login_id
148:
149: );
150:
151: open c;
177: X_ATTRIBUTE_LABEL_LONG,
178: X_DESCRIPTION,
179: userenv('LANG'),
180:
181: fnd_global.user_id,
182: sysdate,
183: fnd_global.user_id,
184: sysdate,
185: fnd_global.login_id
179: userenv('LANG'),
180:
181: fnd_global.user_id,
182: sysdate,
183: fnd_global.user_id,
184: sysdate,
185: fnd_global.login_id
186:
187: from FND_LANGUAGES L
181: fnd_global.user_id,
182: sysdate,
183: fnd_global.user_id,
184: sysdate,
185: fnd_global.login_id
186:
187: from FND_LANGUAGES L
188: where L.INSTALLED_FLAG in ('I', 'B')
189: and not exists
520: ATTRIBUTE14 = X_ATTRIBUTE14,
521: ATTRIBUTE15 = X_ATTRIBUTE15,
522:
523: LAST_UPDATE_DATE = sysdate,
524: LAST_UPDATED_BY = fnd_global.user_id,
525: LAST_UPDATE_LOGIN = fnd_global.login_id
526:
527: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
528: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
521: ATTRIBUTE15 = X_ATTRIBUTE15,
522:
523: LAST_UPDATE_DATE = sysdate,
524: LAST_UPDATED_BY = fnd_global.user_id,
525: LAST_UPDATE_LOGIN = fnd_global.login_id
526:
527: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
528: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
529: if (sql%notfound) then
535: ATTRIBUTE_LABEL_LONG = X_ATTRIBUTE_LABEL_LONG,
536: DESCRIPTION = X_DESCRIPTION,
537:
538: LAST_UPDATE_DATE = sysdate,
539: LAST_UPDATED_BY = fnd_global.user_id,
540: LAST_UPDATE_LOGIN = fnd_global.login_id,
541:
542: SOURCE_LANG = userenv('LANG')
543: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
536: DESCRIPTION = X_DESCRIPTION,
537:
538: LAST_UPDATE_DATE = sysdate,
539: LAST_UPDATED_BY = fnd_global.user_id,
540: LAST_UPDATE_LOGIN = fnd_global.login_id,
541:
542: SOURCE_LANG = userenv('LANG')
543: where ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
544: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE