APPS.AMS_QUERY_TEMP_INST_PKG dependencies on AMS_QUERY_TEMPLATE_INSTANCE_S

Line 112: update AMS_QUERY_TEMPLATE_INSTANCE set

108: X_LAST_UPDATED_BY in NUMBER,
109: X_LAST_UPDATE_LOGIN in NUMBER
110: ) is
111: begin
112: update AMS_QUERY_TEMPLATE_INSTANCE set
113: TEMPLATE_ID = X_TEMPLATE_ID,
114: ADMIN_INDICATOR_FLAG = X_ADMIN_INDICATOR_FLAG,
115: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
116: REQUEST_ID = X_REQUEST_ID,

Line 174: SELECT AMS_QUERY_TEMPLATE_INSTANCE_s.NEXTVAL

170: FROM AMS_QUERY_TEMPLATE_INSTANCE
171: WHERE TEMPLATE_INSTANCE_ID = x_TEMPLATE_INSTANCE_ID;
172:
173: CURSOR c_get_id is
174: SELECT AMS_QUERY_TEMPLATE_INSTANCE_s.NEXTVAL
175: FROM DUAL;
176: BEGIN
177: if X_OWNER = 'SEED' then
178: l_user_id := 1;