DBA Data[Home] [Help]

APPS.AMS_QUERY_COND_PKG dependencies on AMS_QUERY_CONDITION_S

Line 172: update AMS_QUERY_CONDITION set

168: X_LAST_UPDATED_BY in NUMBER,
169: X_LAST_UPDATE_LOGIN in NUMBER
170: ) is
171: begin
172: update AMS_QUERY_CONDITION set
173: PARAMETER_KEY = X_PARAMETER_KEY,
174: TEMPLATE_ID = X_TEMPLATE_ID,
175: JOIN_CONDITION = X_JOIN_CONDITION,
176: OPERAND_DATA_TYPE = X_OPERAND_DATA_TYPE,

Line 250: SELECT AMS_QUERY_CONDITION_s.NEXTVAL

246: FROM AMS_QUERY_CONDITION
247: WHERE QUERY_CONDITION_ID = x_QUERY_CONDITION_ID;
248:
249: CURSOR c_get_id is
250: SELECT AMS_QUERY_CONDITION_s.NEXTVAL
251: FROM DUAL;
252: BEGIN
253: if X_OWNER = 'SEED' then
254: l_user_id := 1;