eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FF_DATA_DICT dependencies on FF_ROUTE_PARAMETERS

Line 1976: -- 3. ff_route_parameters

1972: -- This instance all STU surrogate keys, for this table, are updated.
1973: -- Three tables are tested:
1974: -- 1. ff_routes
1975: -- 2. ff_user_entities
1976: -- 3. ff_route_parameters
1977: -- The second is tested for using the sequences.
1978: -- If the next value from the live sequence is within the range of
1979: -- delivered surrogate id's then the live sequence must be incremented.
1980: -- If no action is taken, then duplicates may be introduced into the

Line 1985: -- 3. ff_route_parameters_s

1981: -- delivered tables, and child rows may be totally invalidated.
1982: -- This procedure will check three sequences
1983: -- 1. ff_routes_S
1984: -- 2. ff_user_entities_s
1985: -- 3. ff_route_parameters_s
1986:
1987: v_sequence_number number(9);
1988: v_min_delivered number(9);
1989: v_max_delivered number(9);

Line 2000: cursor get_ff_route_parameters is

1996: from hr_s_routes b
1997: where a.route_id = b.route_id
1998: );
1999:
2000: cursor get_ff_route_parameters is
2001: select distinct null
2002: from ff_route_parameters a
2003: where exists
2004: (select null

Line 2002: from ff_route_parameters a

1998: );
1999:
2000: cursor get_ff_route_parameters is
2001: select distinct null
2002: from ff_route_parameters a
2003: where exists
2004: (select null
2005: from hr_s_route_parameters b
2006: where b.route_parameter_id = a.route_parameter_id

Line 2068: open get_ff_route_parameters;

2064: BEGIN --check that no conflict exists within the route
2065: --parameter id's
2066:
2067: --
2068: open get_ff_route_parameters;
2069: fetch get_ff_route_parameters into l_null_return;
2070: IF get_ff_route_parameters%NOTFOUND
2071: OR get_ff_route_parameters%NOTFOUND IS NULL THEN
2072: RAISE NO_DATA_FOUND;

Line 2069: fetch get_ff_route_parameters into l_null_return;

2065: --parameter id's
2066:
2067: --
2068: open get_ff_route_parameters;
2069: fetch get_ff_route_parameters into l_null_return;
2070: IF get_ff_route_parameters%NOTFOUND
2071: OR get_ff_route_parameters%NOTFOUND IS NULL THEN
2072: RAISE NO_DATA_FOUND;
2073: END IF;

Line 2070: IF get_ff_route_parameters%NOTFOUND

2066:
2067: --
2068: open get_ff_route_parameters;
2069: fetch get_ff_route_parameters into l_null_return;
2070: IF get_ff_route_parameters%NOTFOUND
2071: OR get_ff_route_parameters%NOTFOUND IS NULL THEN
2072: RAISE NO_DATA_FOUND;
2073: END IF;
2074: close get_ff_route_parameters;

Line 2071: OR get_ff_route_parameters%NOTFOUND IS NULL THEN

2067: --
2068: open get_ff_route_parameters;
2069: fetch get_ff_route_parameters into l_null_return;
2070: IF get_ff_route_parameters%NOTFOUND
2071: OR get_ff_route_parameters%NOTFOUND IS NULL THEN
2072: RAISE NO_DATA_FOUND;
2073: END IF;
2074: close get_ff_route_parameters;
2075: --

Line 2074: close get_ff_route_parameters;

2070: IF get_ff_route_parameters%NOTFOUND
2071: OR get_ff_route_parameters%NOTFOUND IS NULL THEN
2072: RAISE NO_DATA_FOUND;
2073: END IF;
2074: close get_ff_route_parameters;
2075: --
2076: --Conflict exists, so update the stu values of the parameter id
2077:
2078: update hr_s_route_parameters

Line 2161: -- Now check ff_route_parameters

2157: v_max_delivered);
2158:
2159: END IF;
2160:
2161: -- Now check ff_route_parameters
2162:
2163:
2164: select min(route_parameter_id) - (count(*) *3)
2165: , max(route_parameter_id) + (count(*) *3)

Line 2170: select ff_route_parameters_s.nextval

2166: into v_min_delivered
2167: , v_max_delivered
2168: from hr_s_route_parameters;
2169:
2170: select ff_route_parameters_s.nextval
2171: into v_sequence_number
2172: from dual;
2173:
2174: IF v_sequence_number

Line 2177: hr_legislation.munge_sequence('FF_ROUTE_PARAMETERS_S',

2173:
2174: IF v_sequence_number
2175: BETWEEN v_min_delivered AND v_max_delivered THEN
2176:
2177: hr_legislation.munge_sequence('FF_ROUTE_PARAMETERS_S',
2178: v_sequence_number,
2179: v_max_delivered);
2180:
2181: END IF;

Line 2263: from ff_route_parameters

2259:
2260:
2261: select route_parameter_id
2262: into l_new_parameter_id
2263: from ff_route_parameters
2264: where sequence_no = delivered_params.sequence_no
2265: and parameter_name = delivered_params.parameter_name
2266: and route_id = l_new_surrogate_key;
2267:

Line 2284: from ff_route_parameters

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);
2286:
2287: delete ff_route_parameters
2288: where route_id = l_new_surrogate_key;

Line 2287: delete ff_route_parameters

2283: select route_parameter_id
2284: from ff_route_parameters
2285: where route_id = l_new_surrogate_key);
2286:
2287: delete ff_route_parameters
2288: where route_id = l_new_surrogate_key;
2289:
2290: select ff_route_parameters_s.nextval
2291: into l_new_parameter_id

Line 2290: select ff_route_parameters_s.nextval

2286:
2287: delete ff_route_parameters
2288: where route_id = l_new_surrogate_key;
2289:
2290: select ff_route_parameters_s.nextval
2291: into l_new_parameter_id
2292: from dual;
2293:
2294: WHEN TOO_MANY_ROWS THEN

Line 2297: hr_utility.trace('sel ff_route_parameters TMR');

2293:
2294: WHEN TOO_MANY_ROWS THEN
2295:
2296: hr_legislation.hrrunprc_trace_on;
2297: hr_utility.trace('sel ff_route_parameters TMR');
2298: hr_utility.trace('parameter_name ' ||
2299: delivered_params.parameter_name);
2300: hr_utility.trace('route_id ' ||
2301: to_char(l_new_surrogate_key));

Line 3052: from ff_route_parameters

3048: where context_id = c_context_id;
3049: --
3050: cursor c_ffrp_null (c_route_parameter_id in number) is
3051: select null
3052: from ff_route_parameters
3053: where route_parameter_id = c_route_parameter_id;
3054: --
3055: cursor c_ff_rcu_pop (c_route_id in number,
3056: c_sequence_no in number,

Line 3166: update ff_route_parameters

3162: RAISE NO_DATA_FOUND;
3163: END IF;
3164: close c_ffrp_null;
3165:
3166: update ff_route_parameters
3167: set ROUTE_ID = stu_rec.c_surrogate_key
3168: ,DATA_TYPE = r_hrsrp.DATA_TYPE
3169: ,PARAMETER_NAME = r_hrsrp.PARAMETER_NAME
3170: ,SEQUENCE_NO = r_hrsrp.SEQUENCE_NO

Line 3176: insert into ff_route_parameters

3172:
3173: EXCEPTION WHEN NO_DATA_FOUND THEN
3174:
3175: BEGIN
3176: insert into ff_route_parameters
3177: (ROUTE_PARAMETER_ID
3178: ,ROUTE_ID
3179: ,DATA_TYPE
3180: ,PARAMETER_NAME

Line 3191: hr_utility.trace('ins ff_route_parameters');

3187: r_hrsrp.PARAMETER_NAME,
3188: r_hrsrp.SEQUENCE_NO);
3189: EXCEPTION WHEN OTHERS THEN
3190: hr_legislation.hrrunprc_trace_on;
3191: hr_utility.trace('ins ff_route_parameters');
3192: hr_utility.trace('PARAMETER_NAME ' ||
3193: r_hrsrp.PARAMETER_NAME);
3194: hr_utility.trace('SEQUENCE_NO ' ||
3195: to_char(r_hrsrp.SEQUENCE_NO));

Line 4744: ff_route_parameters rp,

4740: ))
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