APPS.FF_DATA_DICT dependencies on HR_S_USER_ENTITIES

Line 1914: from hr_s_user_entities

1910:
1911: CURSOR user_entity (r_id IN number) -- To install all user entities
1912: IS -- for a given route
1913: select *
1914: from hr_s_user_entities
1915: where route_id = r_id;
1916:
1917: CURSOR usage (r_id IN number) -- To install context usages
1918: IS -- for a given route

Line 2030: from hr_s_user_entities b

2026: select distinct null
2027: from ff_user_entities a
2028: where exists
2029: (select null
2030: from hr_s_user_entities b
2031: where a.user_entity_id = b.user_entity_id
2032: );
2033: --
2034: BEGIN

Line 2069: update /*+NO_INDEX*/ hr_s_user_entities

2065:
2066: update /*+NO_INDEX*/ hr_s_route_context_usages
2067: set route_id = route_id - 50000000;
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;

Line 2119: update /*+NO_INDEX*/ hr_s_user_entities

2115: close get_ff_user_entities;
2116: --
2117: --conflict exists, so update the stu values of user_entity_id
2118:
2119: update /*+NO_INDEX*/ hr_s_user_entities
2120: set user_entity_id = user_entity_id -50000000;
2121:
2122: update /*+NO_INDEX*/ hr_s_database_items
2123: set user_entity_id = user_entity_id -50000000;

Line 2162: from hr_s_user_entities;

2158: select min(user_entity_id) - (count(*) *3)
2159: , max(user_entity_id) + (count(*) *3)
2160: into v_min_delivered
2161: , v_max_delivered
2162: from hr_s_user_entities;
2163:
2164: select ff_user_entities_s.nextval
2165: into v_sequence_number
2166: from dual;

Line 2380: update hr_s_user_entities

2376: hr_legislation.hrrunprc_trace_off;
2377: raise;
2378: END;
2379:
2380: update hr_s_user_entities
2381: set user_entity_id = l_new_entity_id
2382: , route_id = l_new_surrogate_key
2383: where user_entity_id = delivered_entities.user_entity_id;
2384:

Line 2411: from hr_s_user_entities b

2407:
2408: delete from hr_s_database_items a
2409: where a.user_entity_id in
2410: (select b.user_entity_id
2411: from hr_s_user_entities b
2412: where b.route_id = v_route_id
2413: );
2414:
2415: delete from hr_s_route_parameter_values a

Line 2418: from hr_s_user_entities b

2414:
2415: delete from hr_s_route_parameter_values a
2416: where a.user_entity_id in
2417: (select b.user_entity_id
2418: from hr_s_user_entities b
2419: where b.route_id = v_route_id
2420: );
2421:
2422: delete from hr_s_user_entities

Line 2422: delete from hr_s_user_entities

2418: from hr_s_user_entities b
2419: where b.route_id = v_route_id
2420: );
2421:
2422: delete from hr_s_user_entities
2423: where route_id = v_route_id;
2424:
2425: delete from hr_s_route_context_usages
2426: where route_id = v_route_id;

Line 2642: from hr_s_user_entities

2638: USER_ENTITY_NAME,
2639: CREATOR_ID,
2640: CREATOR_TYPE,
2641: ENTITY_DESCRIPTION
2642: from hr_s_user_entities
2643: where user_entity_id = v_user_entity_id
2644: MINUS
2645: select
2646: BUSINESS_GROUP_ID,

Line 2679: from hr_s_user_entities

2675: USER_ENTITY_NAME,
2676: CREATOR_ID,
2677: CREATOR_TYPE,
2678: ENTITY_DESCRIPTION
2679: from hr_s_user_entities
2680: where user_entity_id = v_user_entity_id
2681: ))
2682: or exists
2683: (select user_name,

Line 2715: from hr_s_user_entities

2711: from ff_user_entities
2712: where user_entity_id = v_user_entity_id;
2713: select user_entity_name
2714: into ue_name2
2715: from hr_s_user_entities
2716: where user_entity_id = v_user_entity_id;
2717: -- hr_legislation.hrrunprc_trace_on;
2718: -- hr_utility.trace('ue chg: ' || to_char(v_user_entity_id) || ' '
2719: -- || ue_name1 || ':' || ue_name2);