DBA Data[Home] [Help]

APPS.FF_DATA_DICT dependencies on HR_S_DATABASE_ITEMS

Line 1947: from hr_s_database_items

1943: IS
1944: -- Cursor to install database items for a given user entity
1945:
1946: select *
1947: from hr_s_database_items
1948: where user_entity_id = ue_id;
1949:
1950: stu_rec stu%ROWTYPE;
1951:

Line 2122: update /*+NO_INDEX*/ hr_s_database_items

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;
2124:
2125: update /*+NO_INDEX*/ hr_s_route_parameter_values
2126: set user_entity_id = user_entity_id -50000000;

Line 2385: update hr_s_database_items

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:
2385: update hr_s_database_items
2386: set user_entity_id = l_new_entity_id
2387: where user_entity_id = delivered_entities.user_entity_id;
2388:
2389: update hr_s_route_parameter_values

Line 2408: delete from hr_s_database_items a

2404: -- Remove a row from the startup tables
2405:
2406: BEGIN
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

Line 2688: from hr_s_database_items

2684: data_type,
2685: definition_text,
2686: null_allowed_flag,
2687: description
2688: from hr_s_database_items
2689: where user_entity_id = v_user_entity_id
2690: MINUS
2691: select user_name,
2692: data_type,