177: X_LAST_UPDATED_BY in NUMBER,
178: X_LAST_UPDATE_LOGIN in NUMBER
179: ) is
180: begin
181: update AMS_DS_TCA_ENTITY_COLS set
182: SOURCE_CATEGORY = X_SOURCE_CATEGORY,
183: ENTITY_ID = X_ENTITY_ID,
184: COLUMN_NAME = X_COLUMN_NAME,
185: DATATYPE = X_DATATYPE,
260: from AMS_DS_TCA_ENTITY_COLS
261: where ENTITY_COLUMN_ID = X_ENTITY_COLUMN_ID;
262:
263: cursor c_get_col_mapping_id is
264: select AMS_DS_TCA_ENTITY_COLS_s.nextval
265: from dual;
266:
267: cursor c_get_luby is
268: select last_updated_by