158: VALUES
159: (
160: l_rule_fld_rec.list_rule_field_id,
161: SYSDATE,
162: FND_GLOBAL.user_id,
163: SYSDATE,
164: FND_GLOBAL.user_id,
165: FND_GLOBAL.conc_login_id,
166: 1,
160: l_rule_fld_rec.list_rule_field_id,
161: SYSDATE,
162: FND_GLOBAL.user_id,
163: SYSDATE,
164: FND_GLOBAL.user_id,
165: FND_GLOBAL.conc_login_id,
166: 1,
167: l_rule_fld_rec.field_table_name,
168: l_rule_fld_rec.field_column_name,
161: SYSDATE,
162: FND_GLOBAL.user_id,
163: SYSDATE,
164: FND_GLOBAL.user_id,
165: FND_GLOBAL.conc_login_id,
166: 1,
167: l_rule_fld_rec.field_table_name,
168: l_rule_fld_rec.field_column_name,
169: l_rule_fld_rec.list_rule_id,
327: END IF;
328:
329: UPDATE AMS_LIST_RULE_FIELDS SET
330: last_update_date = SYSDATE,
331: last_updated_by = FND_GLOBAL.user_id,
332: last_update_login = FND_GLOBAL.conc_login_id,
333: object_version_number = l_rule_fld_rec.object_version_number + 1,
334: field_table_name = l_rule_fld_rec.field_table_name,
335: field_column_name = l_rule_fld_rec.field_column_name,
328:
329: UPDATE AMS_LIST_RULE_FIELDS SET
330: last_update_date = SYSDATE,
331: last_updated_by = FND_GLOBAL.user_id,
332: last_update_login = FND_GLOBAL.conc_login_id,
333: object_version_number = l_rule_fld_rec.object_version_number + 1,
334: field_table_name = l_rule_fld_rec.field_table_name,
335: field_column_name = l_rule_fld_rec.field_column_name,
336: list_rule_id = l_rule_fld_rec.list_rule_id,