APPS.FF_DATA_DICT dependencies on HR_S_ROUTES

Line 1855: -- The main driving installation cursor runs from hr_s_routes. All child

1851: PROCEDURE install_routes (p_phase IN number)
1852: ------------------------
1853: IS
1854: -- Procedure install routes/usages/entities/parameters/parameter values.
1855: -- The main driving installation cursor runs from hr_s_routes. All child
1856: -- rows are installed as cursors driven by the current route_id. The user
1857: -- entities then have child rows installed in a similar way.
1858: -- If the route has not changed, ie:does not need to be installed, it may
1859: -- still remain in the startup tables if there are child user entities to

Line 1876: from hr_s_routes

1872: CURSOR c_all_159260
1873: IS
1874: select route_id route_id,
1875: route_name route_name
1876: from hr_s_routes
1877: where last_update_login = 159260;
1878:
1879: CURSOR stu -- Selects all rows from startup entity
1880: IS

Line 1893: from hr_s_routes;

1889: ,created_by
1890: ,creation_date
1891: ,optimizer_hint
1892: ,rowid
1893: from hr_s_routes;
1894:
1895: CURSOR user_entity (r_id IN number) -- To install all user entities
1896: IS -- for a given route
1897: select *

Line 1996: from hr_s_routes b

1992: select distinct null
1993: from ff_routes a
1994: where exists
1995: (select null
1996: from hr_s_routes b
1997: where a.route_id = b.route_id
1998: );
1999:
2000: cursor get_ff_route_parameters is

Line 2037: update /*+NO_INDEX*/ hr_s_routes

2033: --
2034: --conflict may exist
2035: --update all route_id's to remove conflict
2036:
2037: update /*+NO_INDEX*/ hr_s_routes
2038: set route_id = route_id - 50000000;
2039:
2040: update hr_s_application_ownerships
2041: set key_value = key_value - 50000000

Line 2124: from hr_s_routes;

2120: select min(route_id) - (count(*) *3)
2121: , max(route_id) + (count(*) *3)
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;

Line 2234: update hr_s_routes

2230:
2231: -- Update all child entities
2232:
2233:
2234: update hr_s_routes
2235: set route_id = l_new_surrogate_key
2236: where rowid = stu_rec.rowid;
2237:
2238: update hr_s_application_ownerships

Line 2405: delete from hr_s_routes

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;
2407:
2408: END remove;
2409: