APPS.FF_DATA_DICT dependencies on FF_ROUTE_PARAMETERS_S

Line 1985: -- 3. ff_route_parameters_s

1981: -- delivered tables, and child rows may be totally invalidated.
1982: -- This procedure will check three sequences
1983: -- 1. ff_routes_S
1984: -- 2. ff_user_entities_s
1985: -- 3. ff_route_parameters_s
1986:
1987: v_sequence_number number(9);
1988: v_min_delivered number(9);
1989: v_max_delivered number(9);

Line 2170: select ff_route_parameters_s.nextval

2166: into v_min_delivered
2167: , v_max_delivered
2168: from hr_s_route_parameters;
2169:
2170: select ff_route_parameters_s.nextval
2171: into v_sequence_number
2172: from dual;
2173:
2174: IF v_sequence_number

Line 2177: hr_legislation.munge_sequence('FF_ROUTE_PARAMETERS_S',

2173:
2174: IF v_sequence_number
2175: BETWEEN v_min_delivered AND v_max_delivered THEN
2176:
2177: hr_legislation.munge_sequence('FF_ROUTE_PARAMETERS_S',
2178: v_sequence_number,
2179: v_max_delivered);
2180:
2181: END IF;

Line 2290: select ff_route_parameters_s.nextval

2286:
2287: delete ff_route_parameters
2288: where route_id = l_new_surrogate_key;
2289:
2290: select ff_route_parameters_s.nextval
2291: into l_new_parameter_id
2292: from dual;
2293:
2294: WHEN TOO_MANY_ROWS THEN