APPS.AMS_LIST_RULES_PKG dependencies on AMS_LIST_RULES_ALL_S

Line 163: update AMS_LIST_RULES_ALL set

159: x_ENABLED_FLAG in VARCHAR2,
160: x_SEEDED_FLAG in VARCHAR2
161: ) is
162: begin
163: update AMS_LIST_RULES_ALL set
164: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
165: LIST_RULE_NAME = X_LIST_RULE_NAME,
166: WEIGHTAGE_FOR_DEDUPE = X_WEIGHTAGE_FOR_DEDUPE,
167: ACTIVE_FROM_DATE = X_ACTIVE_FROM_DATE,

Line 251: SELECT ams_list_rules_all_s.NEXTVAL

247: FROM ams_list_rules_all
248: WHERE list_rule_id = x_list_rule_id;
249:
250: CURSOR c_get_id is
251: SELECT ams_list_rules_all_s.NEXTVAL
252: FROM DUAL;
253: BEGIN
254: if X_OWNER = 'SEED' then
255: l_user_id := 1;