APPS.FF_DATA_DICT dependencies on HR_S_USER_ENTITIES

Line 1898: from hr_s_user_entities

1894:
1895: CURSOR user_entity (r_id IN number) -- To install all user entities
1896: IS -- for a given route
1897: select *
1898: from hr_s_user_entities
1899: where route_id = r_id;
1900:
1901: CURSOR usage (r_id IN number) -- To install context usages
1902: IS -- for a given route

Line 2014: from hr_s_user_entities b

2010: select distinct null
2011: from ff_user_entities a
2012: where exists
2013: (select null
2014: from hr_s_user_entities b
2015: where a.user_entity_id = b.user_entity_id
2016: );
2017: --
2018: BEGIN

Line 2053: update /*+NO_INDEX*/ hr_s_user_entities

2049:
2050: update /*+NO_INDEX*/ hr_s_route_context_usages
2051: set route_id = route_id - 50000000;
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;

Line 2103: update /*+NO_INDEX*/ hr_s_user_entities

2099: close get_ff_user_entities;
2100: --
2101: --conflict exists, so update the stu values of user_entity_id
2102:
2103: update /*+NO_INDEX*/ hr_s_user_entities
2104: set user_entity_id = user_entity_id -50000000;
2105:
2106: update /*+NO_INDEX*/ hr_s_database_items
2107: set user_entity_id = user_entity_id -50000000;

Line 2146: from hr_s_user_entities;

2142: select min(user_entity_id) - (count(*) *3)
2143: , max(user_entity_id) + (count(*) *3)
2144: into v_min_delivered
2145: , v_max_delivered
2146: from hr_s_user_entities;
2147:
2148: select ff_user_entities_s.nextval
2149: into v_sequence_number
2150: from dual;

Line 2354: update hr_s_user_entities

2350: hr_legislation.hrrunprc_trace_off;
2351: raise;
2352: END;
2353:
2354: update hr_s_user_entities
2355: set user_entity_id = l_new_entity_id
2356: , route_id = l_new_surrogate_key
2357: where user_entity_id = delivered_entities.user_entity_id;
2358:

Line 2385: from hr_s_user_entities b

2381:
2382: delete from hr_s_database_items a
2383: where a.user_entity_id in
2384: (select b.user_entity_id
2385: from hr_s_user_entities b
2386: where b.route_id = v_route_id
2387: );
2388:
2389: delete from hr_s_route_parameter_values a

Line 2392: from hr_s_user_entities b

2388:
2389: delete from hr_s_route_parameter_values a
2390: where a.user_entity_id in
2391: (select b.user_entity_id
2392: from hr_s_user_entities b
2393: where b.route_id = v_route_id
2394: );
2395:
2396: delete from hr_s_user_entities

Line 2396: delete from hr_s_user_entities

2392: from hr_s_user_entities b
2393: where b.route_id = v_route_id
2394: );
2395:
2396: delete from hr_s_user_entities
2397: where route_id = v_route_id;
2398:
2399: delete from hr_s_route_context_usages
2400: where route_id = v_route_id;

Line 2601: from hr_s_user_entities

2597: USER_ENTITY_NAME,
2598: CREATOR_ID,
2599: CREATOR_TYPE,
2600: ENTITY_DESCRIPTION
2601: from hr_s_user_entities
2602: where user_entity_id = v_user_entity_id
2603: MINUS
2604: select
2605: BUSINESS_GROUP_ID,

Line 2638: from hr_s_user_entities

2634: USER_ENTITY_NAME,
2635: CREATOR_ID,
2636: CREATOR_TYPE,
2637: ENTITY_DESCRIPTION
2638: from hr_s_user_entities
2639: where user_entity_id = v_user_entity_id
2640: ))
2641: or exists
2642: (select user_name,

Line 2674: from hr_s_user_entities

2670: from ff_user_entities
2671: where user_entity_id = v_user_entity_id;
2672: select user_entity_name
2673: into ue_name2
2674: from hr_s_user_entities
2675: where user_entity_id = v_user_entity_id;
2676: -- hr_legislation.hrrunprc_trace_on;
2677: -- hr_utility.trace('ue chg: ' || to_char(v_user_entity_id) || ' '
2678: -- || ue_name1 || ':' || ue_name2);