APPS.FF_DATA_DICT dependencies on HR_S_ROUTE_PARAMETERS

Line 1931: from hr_s_route_parameters

1927: , DATA_TYPE
1928: , PARAMETER_NAME
1929: , SEQUENCE_NO
1930: , rowid
1931: from hr_s_route_parameters
1932: where route_id = r_id;
1933:
1934: CURSOR parameter_value (ue_id IN number)
1935: IS

Line 2021: from hr_s_route_parameters b

2017: select distinct null
2018: from ff_route_parameters a
2019: where exists
2020: (select null
2021: from hr_s_route_parameters b
2022: where b.route_parameter_id = a.route_parameter_id
2023: );
2024:
2025: cursor get_ff_user_entities is

Line 2072: update /*+NO_INDEX*/ hr_s_route_parameters

2068:
2069: update /*+NO_INDEX*/ hr_s_user_entities
2070: set route_id = route_id - 50000000;
2071:
2072: update /*+NO_INDEX*/ hr_s_route_parameters
2073: set route_id = route_id - 50000000;
2074:
2075: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
2076:

Line 2094: update hr_s_route_parameters

2090: close get_ff_route_parameters;
2091: --
2092: --Conflict exists, so update the stu values of the parameter id
2093:
2094: update hr_s_route_parameters
2095: set route_parameter_id = route_parameter_id -50000000;
2096:
2097: update hr_s_route_parameter_values
2098: set route_parameter_id = route_parameter_id -50000000;

Line 2184: from hr_s_route_parameters;

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

Line 2327: update hr_s_route_parameters

2323: raise;
2324:
2325: END; --select of new surrogate id
2326:
2327: update hr_s_route_parameters
2328: set route_id = l_new_surrogate_key
2329: , route_parameter_id = l_new_parameter_id
2330: where route_parameter_id = delivered_params.route_parameter_id;
2331:

Line 2428: delete from hr_s_route_parameters

2424:
2425: delete from hr_s_route_context_usages
2426: where route_id = v_route_id;
2427:
2428: delete from hr_s_route_parameters
2429: where route_id = v_route_id;
2430:
2431: delete from hr_s_routes
2432: where route_id = v_route_id;