174: -- Insert into mutli-language supported table.
175: --
176: INSERT INTO ams_user_statuses_b (
177: user_status_id,
178: -- standard who columns
179: last_update_date,
180: last_updated_by,
181: creation_date,
182: created_by,
192: application_id
193: )
194: VALUES (
195: l_user_status_rec.user_status_id,
196: -- standard who columns
197: SYSDATE,
198: FND_GLOBAL.User_Id,
199: SYSDATE,
200: FND_GLOBAL.User_Id,
222: description
223: )
224: SELECT l_user_status_rec.user_status_id,
225: l.language_code,
226: -- standard who columns
227: SYSDATE,
228: FND_GLOBAL.User_Id,
229: SYSDATE,
230: FND_GLOBAL.User_Id,
243: x_user_status_id := l_user_status_rec.user_status_id;
244: --
245: -- END of API body.
246: --
247: -- Standard check of p_commit.
248: IF FND_API.To_Boolean ( p_commit ) THEN
249: COMMIT WORK;
250: END IF;
251: FND_MSG_PUB.count_and_get(