DBA Data[Home] [Help]

APPS.FF_DATA_DICT dependencies on FF_ROUTES_S

Line 1999: -- 1. ff_routes_S

1995: -- delivered surrogate id's then the live sequence must be incremented.
1996: -- If no action is taken, then duplicates may be introduced into the
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);

Line 2142: select ff_routes_s.nextval

2138: into v_min_delivered
2139: , v_max_delivered
2140: from hr_s_routes;
2141:
2142: select ff_routes_s.nextval
2143: into v_sequence_number
2144: from dual;
2145:
2146: IF v_sequence_number

Line 2149: hr_legislation.munge_sequence('FF_ROUTES_S',

2145:
2146: IF v_sequence_number
2147: BETWEEN v_min_delivered AND v_max_delivered THEN
2148:
2149: hr_legislation.munge_sequence('FF_ROUTES_S',
2150: v_sequence_number,
2151: v_max_delivered);
2152:
2153: END IF;

Line 2233: select ff_routes_s.nextval

2229:
2230: EXCEPTION WHEN NO_DATA_FOUND THEN
2231:
2232:
2233: select ff_routes_s.nextval
2234: into l_new_surrogate_key
2235: from dual;
2236:
2237: WHEN TOO_MANY_ROWS THEN