352: X_LAST_UPDATED_BY in NUMBER,
353: X_LAST_UPDATE_LOGIN in NUMBER
354: ) is
355: begin
356: update AMS_COLUMNS_METADATA set
357: SEARCH_EXCLUSION_GROUP = X_SEARCH_EXCLUSION_GROUP,
358: SEARCH_OPERATOR_EXCLUSION_ID = X_SEARCH_OPERATOR_EXCLUSION_ID,
359: SEARCH_COLSPAN = X_SEARCH_COLSPAN,
360: APPLICATION_ID = X_APPLICATION_ID,
485: -- and APPLICATION_ID = X_APPLICATION_ID;
486: where COLUMNS_METADATA_ID = X_COLUMNS_METADATA_ID;
487:
488: cursor c_get_colmtd_id is
489: select AMS_COLUMNS_METADATA_S.nextval
490: from dual;
491:
492: BEGIN
493: if X_OWNER = 'SEED' then