APPS.FF_DATA_DICT dependencies on HR_S_ROUTE_PARAMETERS

Line 1915: from hr_s_route_parameters

1911: , DATA_TYPE
1912: , PARAMETER_NAME
1913: , SEQUENCE_NO
1914: , rowid
1915: from hr_s_route_parameters
1916: where route_id = r_id;
1917:
1918: CURSOR parameter_value (ue_id IN number)
1919: IS

Line 2005: from hr_s_route_parameters b

2001: select distinct null
2002: from ff_route_parameters a
2003: where exists
2004: (select null
2005: from hr_s_route_parameters b
2006: where b.route_parameter_id = a.route_parameter_id
2007: );
2008:
2009: cursor get_ff_user_entities is

Line 2056: update /*+NO_INDEX*/ hr_s_route_parameters

2052:
2053: update /*+NO_INDEX*/ hr_s_user_entities
2054: set route_id = route_id - 50000000;
2055:
2056: update /*+NO_INDEX*/ hr_s_route_parameters
2057: set route_id = route_id - 50000000;
2058:
2059: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
2060:

Line 2078: update hr_s_route_parameters

2074: close get_ff_route_parameters;
2075: --
2076: --Conflict exists, so update the stu values of the parameter id
2077:
2078: update hr_s_route_parameters
2079: set route_parameter_id = route_parameter_id -50000000;
2080:
2081: update hr_s_route_parameter_values
2082: set route_parameter_id = route_parameter_id -50000000;

Line 2168: from hr_s_route_parameters;

2164: select min(route_parameter_id) - (count(*) *3)
2165: , max(route_parameter_id) + (count(*) *3)
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;

Line 2311: update hr_s_route_parameters

2307: raise;
2308:
2309: END; --select of new surrogate id
2310:
2311: update hr_s_route_parameters
2312: set route_id = l_new_surrogate_key
2313: , route_parameter_id = l_new_parameter_id
2314: where route_parameter_id = delivered_params.route_parameter_id;
2315:

Line 2402: delete from hr_s_route_parameters

2398:
2399: delete from hr_s_route_context_usages
2400: where route_id = v_route_id;
2401:
2402: delete from hr_s_route_parameters
2403: where route_id = v_route_id;
2404:
2405: delete from hr_s_routes
2406: where route_id = v_route_id;