APPS.AMS_LIST_RULES_ALL_PVT dependencies on AMS_LIST_RULES_ALL_S

Line 40: SELECT AMS_LIST_RULES_ALL_S.NEXTVAL

36: l_list_rule_rec list_rule_rec_type := p_list_rule_rec;
37: l_list_rule_count NUMBER;
38:
39: CURSOR c_list_rule_seq IS
40: SELECT AMS_LIST_RULES_ALL_S.NEXTVAL
41: FROM DUAL;
42:
43: CURSOR c_list_rule_count(lst_rule_id IN NUMBER) IS
44: SELECT COUNT(*)

Line 335: UPDATE AMS_LIST_RULES_ALL SET

331:
332: -- get org_id
333: l_list_rule_rec.org_id := TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10));
334:
335: UPDATE AMS_LIST_RULES_ALL SET
336: last_update_date = SYSDATE,
337: last_updated_by = FND_GLOBAL.user_id,
338: last_update_login = FND_GLOBAL.conc_login_id,
339: object_version_number = l_list_rule_rec.object_version_number + 1,