DBA Data[Home] [Help]

APPS.FF_DATA_DICT dependencies on FF_ROUTES_S

Line 1983: -- 1. ff_routes_S

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

Line 2126: select ff_routes_s.nextval

2122: into v_min_delivered
2123: , v_max_delivered
2124: from hr_s_routes;
2125:
2126: select ff_routes_s.nextval
2127: into v_sequence_number
2128: from dual;
2129:
2130: IF v_sequence_number

Line 2133: hr_legislation.munge_sequence('FF_ROUTES_S',

2129:
2130: IF v_sequence_number
2131: BETWEEN v_min_delivered AND v_max_delivered THEN
2132:
2133: hr_legislation.munge_sequence('FF_ROUTES_S',
2134: v_sequence_number,
2135: v_max_delivered);
2136:
2137: END IF;

Line 2217: select ff_routes_s.nextval

2213:
2214: EXCEPTION WHEN NO_DATA_FOUND THEN
2215:
2216:
2217: select ff_routes_s.nextval
2218: into l_new_surrogate_key
2219: from dual;
2220:
2221: WHEN TOO_MANY_ROWS THEN