DBA Data[Home] [Help]

APPS.FF_DATA_DICT dependencies on FF_ROUTE_PARAMETERS_S

Line 2001: -- 3. ff_route_parameters_s

1997: -- delivered tables, and child rows may be totally invalidated.
1998: -- This procedure will check three sequences
1999: -- 1. ff_routes_S
2000: -- 2. ff_user_entities_s
2001: -- 3. ff_route_parameters_s
2002:
2003: v_sequence_number number(9);
2004: v_min_delivered number(9);
2005: v_max_delivered number(9);

Line 2186: select ff_route_parameters_s.nextval

2182: into v_min_delivered
2183: , v_max_delivered
2184: from hr_s_route_parameters;
2185:
2186: select ff_route_parameters_s.nextval
2187: into v_sequence_number
2188: from dual;
2189:
2190: IF v_sequence_number

Line 2193: hr_legislation.munge_sequence('FF_ROUTE_PARAMETERS_S',

2189:
2190: IF v_sequence_number
2191: BETWEEN v_min_delivered AND v_max_delivered THEN
2192:
2193: hr_legislation.munge_sequence('FF_ROUTE_PARAMETERS_S',
2194: v_sequence_number,
2195: v_max_delivered);
2196:
2197: END IF;

Line 2306: select ff_route_parameters_s.nextval

2302:
2303: delete ff_route_parameters
2304: where route_id = l_new_surrogate_key;
2305:
2306: select ff_route_parameters_s.nextval
2307: into l_new_parameter_id
2308: from dual;
2309:
2310: WHEN TOO_MANY_ROWS THEN