140: VALUES
141: (
142: l_wrd_fld_rec.list_word_field_id,
143: SYSDATE,
144: FND_GLOBAL.user_id,
145: SYSDATE,
146: FND_GLOBAL.user_id,
147: FND_GLOBAL.conc_login_id,
148: 1,
142: l_wrd_fld_rec.list_word_field_id,
143: SYSDATE,
144: FND_GLOBAL.user_id,
145: SYSDATE,
146: FND_GLOBAL.user_id,
147: FND_GLOBAL.conc_login_id,
148: 1,
149: l_wrd_fld_rec.field_table_name,
150: l_wrd_fld_rec.field_column_name,
143: SYSDATE,
144: FND_GLOBAL.user_id,
145: SYSDATE,
146: FND_GLOBAL.user_id,
147: FND_GLOBAL.conc_login_id,
148: 1,
149: l_wrd_fld_rec.field_table_name,
150: l_wrd_fld_rec.field_column_name,
151: l_wrd_fld_rec.list_word_replaces_id,
309: END IF;
310:
311: UPDATE AMS_LIST_WORD_FIELDS SET
312: last_update_date = SYSDATE,
313: last_updated_by = FND_GLOBAL.user_id,
314: last_update_login = FND_GLOBAL.conc_login_id,
315: object_version_number = l_wrd_fld_rec.object_version_number + 1,
316: field_table_name = l_wrd_fld_rec.field_table_name,
317: field_column_name = l_wrd_fld_rec.field_column_name,
310:
311: UPDATE AMS_LIST_WORD_FIELDS SET
312: last_update_date = SYSDATE,
313: last_updated_by = FND_GLOBAL.user_id,
314: last_update_login = FND_GLOBAL.conc_login_id,
315: object_version_number = l_wrd_fld_rec.object_version_number + 1,
316: field_table_name = l_wrd_fld_rec.field_table_name,
317: field_column_name = l_wrd_fld_rec.field_column_name,
318: list_word_replaces_id = l_wrd_fld_rec.list_word_replaces_id,