APPS.FF_DATA_DICT dependencies on FF_ROUTE_PARAMETER_VALUES

Line 2297: delete ff_route_parameter_values

2293: delete ff_fdi_usages_f where formula_id = r_form3.fid;
2294: delete ff_compiled_info_f where formula_id = r_form3.fid;
2295: end loop;
2296:
2297: delete ff_route_parameter_values
2298: where route_parameter_id in (
2299: select route_parameter_id
2300: from ff_route_parameters
2301: where route_id = l_new_surrogate_key);

Line 2704: from ff_route_parameter_values

2700: from hr_s_route_parameter_values
2701: where user_entity_id = v_user_entity_id
2702: MINUS
2703: select value
2704: from ff_route_parameter_values
2705: where user_entity_id = v_user_entity_id);
2706:
2707: -- Show that this user entity differs from the install one
2708: begin

Line 2916: update ff_route_parameter_values

2912: LOOP
2913:
2914: BEGIN
2915:
2916: update ff_route_parameter_values
2917: set value = pvalues.value
2918: ,last_update_date = pvalues.last_update_date
2919: ,last_updated_by = pvalues.last_updated_by
2920: ,last_update_login = pvalues.last_update_login

Line 2929: insert into ff_route_parameter_values

2925:
2926: IF SQL%NOTFOUND THEN
2927:
2928: BEGIN
2929: insert into ff_route_parameter_values
2930: (route_parameter_id
2931: ,user_entity_id
2932: ,value
2933: ,last_update_date

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

2947: ,pvalues.creation_date
2948: );
2949: EXCEPTION WHEN OTHERS THEN
2950: hr_legislation.hrrunprc_trace_on;
2951: hr_utility.trace('ins ff_route_parameter_values');
2952: hr_utility.trace('value ' ||
2953: pvalues.value);
2954: hr_utility.trace('route_parameter_id ' ||
2955: to_char(pvalues.route_parameter_id));

Line 4796: ff_route_parameter_values rpv

4792: and exists (select distinct null
4793: from ff_user_entities u,
4794: ff_database_items d,
4795: ff_route_parameters rp,
4796: ff_route_parameter_values rpv
4797: where u.user_entity_name = global_name || '_GLOBAL_UE'
4798: and u.user_entity_id = rpv.user_entity_id
4799: and d.user_entity_id = u.user_entity_id
4800: and rpv.route_parameter_id = rp.route_parameter_id

Line 4814: -- Delete ff_route_parameter_values

4810: delete ff_fdi_usages_f where formula_id = r_global.fid;
4811: delete ff_compiled_info_f where formula_id = r_global.fid;
4812: end loop;
4813:
4814: -- Delete ff_route_parameter_values
4815: -- associated with this global bug 3744555
4816: -- and let them get recreated by the global triggers
4817: delete ff_route_parameter_values
4818: where user_entity_id = (select user_entity_id

Line 4817: delete ff_route_parameter_values

4813:
4814: -- Delete ff_route_parameter_values
4815: -- associated with this global bug 3744555
4816: -- and let them get recreated by the global triggers
4817: delete ff_route_parameter_values
4818: where user_entity_id = (select user_entity_id
4819: from ff_user_entities
4820: where user_entity_name = r_distinct.c_true_key || '_GLOBAL_UE');
4821: