APPS.AMS_LIST_QUERIES_PARAM_PKG dependencies on AMS_LIST_QUERIES_PARAM_S

Line 189: update AMS_LIST_QUERIES_PARAM set

185: X_LAST_UPDATED_BY in NUMBER,
186: X_LAST_UPDATE_LOGIN in NUMBER
187: ) is
188: begin
189: update AMS_LIST_QUERIES_PARAM set
190: ATTB_LOV_ID = X_ATTB_LOV_ID,
191: PARAM_VALUE_2 = X_PARAM_VALUE_2,
192: CONDITION_VALUE = X_CONDITION_VALUE,
193: PARAMETER_NAME = X_PARAMETER_NAME,

Line 413: SELECT AMS_LIST_QUERIES_PARAM_S.NEXTVAL

409: FROM AMS_LIST_QUERIES_PARAM
410: WHERE LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID;
411:
412: CURSOR c_get_id is
413: SELECT AMS_LIST_QUERIES_PARAM_S.NEXTVAL
414: FROM DUAL;
415: BEGIN
416: if X_OWNER = 'SEED' then
417: l_user_id := 1;