APPS.FF_DATA_DICT dependencies on FF_ROUTE_PARAMETER_VALUES

Line 2281: delete ff_route_parameter_values

2277: delete ff_fdi_usages_f where formula_id = r_form3.fid;
2278: delete ff_compiled_info_f where formula_id = r_form3.fid;
2279: end loop;
2280:
2281: delete ff_route_parameter_values
2282: where route_parameter_id in (
2283: select route_parameter_id
2284: from ff_route_parameters
2285: where route_id = l_new_surrogate_key);

Line 2663: from ff_route_parameter_values

2659: from hr_s_route_parameter_values
2660: where user_entity_id = v_user_entity_id
2661: MINUS
2662: select value
2663: from ff_route_parameter_values
2664: where user_entity_id = v_user_entity_id);
2665:
2666: -- Show that this user entity differs from the install one
2667: begin

Line 2875: update ff_route_parameter_values

2871: LOOP
2872:
2873: BEGIN
2874:
2875: update ff_route_parameter_values
2876: set value = pvalues.value
2877: ,last_update_date = pvalues.last_update_date
2878: ,last_updated_by = pvalues.last_updated_by
2879: ,last_update_login = pvalues.last_update_login

Line 2888: insert into ff_route_parameter_values

2884:
2885: IF SQL%NOTFOUND THEN
2886:
2887: BEGIN
2888: insert into ff_route_parameter_values
2889: (route_parameter_id
2890: ,user_entity_id
2891: ,value
2892: ,last_update_date

Line 2910: hr_utility.trace('ins ff_route_parameter_values');

2906: ,pvalues.creation_date
2907: );
2908: EXCEPTION WHEN OTHERS THEN
2909: hr_legislation.hrrunprc_trace_on;
2910: hr_utility.trace('ins ff_route_parameter_values');
2911: hr_utility.trace('value ' ||
2912: pvalues.value);
2913: hr_utility.trace('route_parameter_id ' ||
2914: to_char(pvalues.route_parameter_id));

Line 4745: ff_route_parameter_values rpv

4741: and exists (select distinct null
4742: from ff_user_entities u,
4743: ff_database_items d,
4744: ff_route_parameters rp,
4745: ff_route_parameter_values rpv
4746: where u.user_entity_name = global_name || '_GLOBAL_UE'
4747: and u.user_entity_id = rpv.user_entity_id
4748: and d.user_entity_id = u.user_entity_id
4749: and rpv.route_parameter_id = rp.route_parameter_id

Line 4763: -- Delete ff_route_parameter_values

4759: delete ff_fdi_usages_f where formula_id = r_global.fid;
4760: delete ff_compiled_info_f where formula_id = r_global.fid;
4761: end loop;
4762:
4763: -- Delete ff_route_parameter_values
4764: -- associated with this global bug 3744555
4765: -- and let them get recreated by the global triggers
4766: delete ff_route_parameter_values
4767: where user_entity_id = (select user_entity_id

Line 4766: delete ff_route_parameter_values

4762:
4763: -- Delete ff_route_parameter_values
4764: -- associated with this global bug 3744555
4765: -- and let them get recreated by the global triggers
4766: delete ff_route_parameter_values
4767: where user_entity_id = (select user_entity_id
4768: from ff_user_entities
4769: where user_entity_name = r_distinct.c_true_key || '_GLOBAL_UE');
4770: