APPS.FF_DATA_DICT dependencies on HR_S_ROUTES

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

1865: PROCEDURE install_routes (p_phase IN number)
1866: ------------------------
1867: IS
1868: -- Procedure install routes/usages/entities/parameters/parameter values.
1869: -- The main driving installation cursor runs from hr_s_routes. All child
1870: -- rows are installed as cursors driven by the current route_id. The user
1871: -- entities then have child rows installed in a similar way.
1872: -- If the route has not changed, ie:does not need to be installed, it may
1873: -- still remain in the startup tables if there are child user entities to

Line 1892: from hr_s_routes

1888: CURSOR c_all_159260
1889: IS
1890: select route_id route_id,
1891: route_name route_name
1892: from hr_s_routes
1893: where last_update_login = 159260;
1894:
1895: CURSOR stu -- Selects all rows from startup entity
1896: IS

Line 1909: from hr_s_routes;

1905: ,created_by
1906: ,creation_date
1907: ,optimizer_hint
1908: ,rowid
1909: from hr_s_routes;
1910:
1911: CURSOR user_entity (r_id IN number) -- To install all user entities
1912: IS -- for a given route
1913: select *

Line 2012: from hr_s_routes b

2008: select distinct null
2009: from ff_routes a
2010: where exists
2011: (select null
2012: from hr_s_routes b
2013: where a.route_id = b.route_id
2014: );
2015:
2016: cursor get_ff_route_parameters is

Line 2053: update /*+NO_INDEX*/ hr_s_routes

2049: --
2050: --conflict may exist
2051: --update all route_id's to remove conflict
2052:
2053: update /*+NO_INDEX*/ hr_s_routes
2054: set route_id = route_id - 50000000;
2055:
2056: update hr_s_application_ownerships
2057: set key_value = key_value - 50000000

Line 2140: from hr_s_routes;

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

Line 2250: update hr_s_routes

2246:
2247: -- Update all child entities
2248:
2249:
2250: update hr_s_routes
2251: set route_id = l_new_surrogate_key
2252: where rowid = stu_rec.rowid;
2253:
2254: update hr_s_application_ownerships

Line 2431: delete from hr_s_routes

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;
2433:
2434: END remove;
2435: