33: DESCRIPTION,
34: CREATION_DATE
35: ) values (
36: sysdate,
37: fnd_global.user_id,
38: fnd_global.user_id,
39: fnd_global.user_id,
40: X_STATUS_LIST_ID,
41: X_STATUS_TYPE,
34: CREATION_DATE
35: ) values (
36: sysdate,
37: fnd_global.user_id,
38: fnd_global.user_id,
39: fnd_global.user_id,
40: X_STATUS_LIST_ID,
41: X_STATUS_TYPE,
42: X_NAME,
35: ) values (
36: sysdate,
37: fnd_global.user_id,
38: fnd_global.user_id,
39: fnd_global.user_id,
40: X_STATUS_LIST_ID,
41: X_STATUS_TYPE,
42: X_NAME,
43: X_RECORD_VERSION_NUMBER,
154: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
155: DESCRIPTION = X_DESCRIPTION,
156: STATUS_LIST_ID = X_STATUS_LIST_ID,
157: LAST_UPDATE_DATE = sysdate,
158: LAST_UPDATED_BY = fnd_global.user_id,
159: LAST_UPDATE_LOGIN = fnd_global.user_id
160: where STATUS_LIST_ID = X_STATUS_LIST_ID;
161:
162: if (sql%notfound) then
155: DESCRIPTION = X_DESCRIPTION,
156: STATUS_LIST_ID = X_STATUS_LIST_ID,
157: LAST_UPDATE_DATE = sysdate,
158: LAST_UPDATED_BY = fnd_global.user_id,
159: LAST_UPDATE_LOGIN = fnd_global.user_id
160: where STATUS_LIST_ID = X_STATUS_LIST_ID;
161:
162: if (sql%notfound) then
163: raise no_data_found;