APPS.AMS_QUERY_ALIAS_PKG dependencies on AMS_QUERY_ALIAS_S

Line 103: update AMS_QUERY_ALIAS set

99: X_LAST_UPDATED_BY in NUMBER,
100: X_LAST_UPDATE_LOGIN in NUMBER
101: ) is
102: begin
103: update AMS_QUERY_ALIAS set
104: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
105: REQUEST_ID = X_REQUEST_ID,
106: OBJECT_NAME = X_OBJECT_NAME,
107: ALIAS_SEQ = X_ALIAS_SEQ,

Line 163: SELECT AMS_QUERY_ALIAS_s.NEXTVAL

159: FROM AMS_QUERY_ALIAS
160: WHERE QUERY_ALIAS_ID = x_QUERY_ALIAS_ID;
161:
162: CURSOR c_get_id is
163: SELECT AMS_QUERY_ALIAS_s.NEXTVAL
164: FROM DUAL;
165: BEGIN
166: if X_OWNER = 'SEED' then
167: l_user_id := 1;