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 1992: -- 3. ff_route_parameters

1988: -- This instance all STU surrogate keys, for this table, are updated.
1989: -- Three tables are tested:
1990: -- 1. ff_routes
1991: -- 2. ff_user_entities
1992: -- 3. ff_route_parameters
1993: -- The second is tested for using the sequences.
1994: -- If the next value from the live sequence is within the range of
1995: -- delivered surrogate id's then the live sequence must be incremented.
1996: -- If no action is taken, then duplicates may be introduced into the

Line 2001: -- 3. ff_route_parameters_s

1997: -- delivered tables, and child rows may be totally invalidated.
1998: -- This procedure will check three sequences
1999: -- 1. ff_routes_S
2000: -- 2. ff_user_entities_s
2001: -- 3. ff_route_parameters_s
2002:
2003: v_sequence_number number(9);
2004: v_min_delivered number(9);
2005: v_max_delivered number(9);

Line 2016: cursor get_ff_route_parameters is

2012: from hr_s_routes b
2013: where a.route_id = b.route_id
2014: );
2015:
2016: cursor get_ff_route_parameters is
2017: select distinct null
2018: from ff_route_parameters a
2019: where exists
2020: (select null

Line 2018: from ff_route_parameters a

2014: );
2015:
2016: cursor get_ff_route_parameters is
2017: select distinct null
2018: from ff_route_parameters a
2019: where exists
2020: (select null
2021: from hr_s_route_parameters b
2022: where b.route_parameter_id = a.route_parameter_id

Line 2084: open get_ff_route_parameters;

2080: BEGIN --check that no conflict exists within the route
2081: --parameter id's
2082:
2083: --
2084: open get_ff_route_parameters;
2085: fetch get_ff_route_parameters into l_null_return;
2086: IF get_ff_route_parameters%NOTFOUND
2087: OR get_ff_route_parameters%NOTFOUND IS NULL THEN
2088: RAISE NO_DATA_FOUND;

Line 2085: fetch get_ff_route_parameters into l_null_return;

2081: --parameter id's
2082:
2083: --
2084: open get_ff_route_parameters;
2085: fetch get_ff_route_parameters into l_null_return;
2086: IF get_ff_route_parameters%NOTFOUND
2087: OR get_ff_route_parameters%NOTFOUND IS NULL THEN
2088: RAISE NO_DATA_FOUND;
2089: END IF;

Line 2086: IF get_ff_route_parameters%NOTFOUND

2082:
2083: --
2084: open get_ff_route_parameters;
2085: fetch get_ff_route_parameters into l_null_return;
2086: IF get_ff_route_parameters%NOTFOUND
2087: OR get_ff_route_parameters%NOTFOUND IS NULL THEN
2088: RAISE NO_DATA_FOUND;
2089: END IF;
2090: close get_ff_route_parameters;

Line 2087: OR get_ff_route_parameters%NOTFOUND IS NULL THEN

2083: --
2084: open get_ff_route_parameters;
2085: fetch get_ff_route_parameters into l_null_return;
2086: IF get_ff_route_parameters%NOTFOUND
2087: OR get_ff_route_parameters%NOTFOUND IS NULL THEN
2088: RAISE NO_DATA_FOUND;
2089: END IF;
2090: close get_ff_route_parameters;
2091: --

Line 2090: close get_ff_route_parameters;

2086: IF get_ff_route_parameters%NOTFOUND
2087: OR get_ff_route_parameters%NOTFOUND IS NULL THEN
2088: RAISE NO_DATA_FOUND;
2089: END IF;
2090: close get_ff_route_parameters;
2091: --
2092: --Conflict exists, so update the stu values of the parameter id
2093:
2094: update hr_s_route_parameters

Line 2177: -- Now check ff_route_parameters

2173: v_max_delivered);
2174:
2175: END IF;
2176:
2177: -- Now check ff_route_parameters
2178:
2179:
2180: select min(route_parameter_id) - (count(*) *3)
2181: , max(route_parameter_id) + (count(*) *3)

Line 2186: select ff_route_parameters_s.nextval

2182: into v_min_delivered
2183: , v_max_delivered
2184: from hr_s_route_parameters;
2185:
2186: select ff_route_parameters_s.nextval
2187: into v_sequence_number
2188: from dual;
2189:
2190: IF v_sequence_number

Line 2193: hr_legislation.munge_sequence('FF_ROUTE_PARAMETERS_S',

2189:
2190: IF v_sequence_number
2191: BETWEEN v_min_delivered AND v_max_delivered THEN
2192:
2193: hr_legislation.munge_sequence('FF_ROUTE_PARAMETERS_S',
2194: v_sequence_number,
2195: v_max_delivered);
2196:
2197: END IF;

Line 2279: from ff_route_parameters

2275:
2276:
2277: select route_parameter_id
2278: into l_new_parameter_id
2279: from ff_route_parameters
2280: where sequence_no = delivered_params.sequence_no
2281: and parameter_name = delivered_params.parameter_name
2282: and route_id = l_new_surrogate_key;
2283:

Line 2300: from ff_route_parameters

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);
2302:
2303: delete ff_route_parameters
2304: where route_id = l_new_surrogate_key;

Line 2303: delete ff_route_parameters

2299: select route_parameter_id
2300: from ff_route_parameters
2301: where route_id = l_new_surrogate_key);
2302:
2303: delete ff_route_parameters
2304: where route_id = l_new_surrogate_key;
2305:
2306: select ff_route_parameters_s.nextval
2307: into l_new_parameter_id

Line 2306: select ff_route_parameters_s.nextval

2302:
2303: delete ff_route_parameters
2304: where route_id = l_new_surrogate_key;
2305:
2306: select ff_route_parameters_s.nextval
2307: into l_new_parameter_id
2308: from dual;
2309:
2310: WHEN TOO_MANY_ROWS THEN

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

2309:
2310: WHEN TOO_MANY_ROWS THEN
2311:
2312: hr_legislation.hrrunprc_trace_on;
2313: hr_utility.trace('sel ff_route_parameters TMR');
2314: hr_utility.trace('parameter_name ' ||
2315: delivered_params.parameter_name);
2316: hr_utility.trace('route_id ' ||
2317: to_char(l_new_surrogate_key));

Line 3092: from ff_route_parameters

3088: where context_id = c_context_id;
3089: --
3090: cursor c_ffrp_null (c_route_parameter_id in number) is
3091: select null
3092: from ff_route_parameters
3093: where route_parameter_id = c_route_parameter_id;
3094: --
3095: cursor c_ff_rcu_pop (c_route_id in number,
3096: c_sequence_no in number,

Line 3206: update ff_route_parameters

3202: RAISE NO_DATA_FOUND;
3203: END IF;
3204: close c_ffrp_null;
3205:
3206: update ff_route_parameters
3207: set ROUTE_ID = stu_rec.c_surrogate_key
3208: ,DATA_TYPE = r_hrsrp.DATA_TYPE
3209: ,PARAMETER_NAME = r_hrsrp.PARAMETER_NAME
3210: ,SEQUENCE_NO = r_hrsrp.SEQUENCE_NO

Line 3216: insert into ff_route_parameters

3212:
3213: EXCEPTION WHEN NO_DATA_FOUND THEN
3214:
3215: BEGIN
3216: insert into ff_route_parameters
3217: (ROUTE_PARAMETER_ID
3218: ,ROUTE_ID
3219: ,DATA_TYPE
3220: ,PARAMETER_NAME

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

3227: r_hrsrp.PARAMETER_NAME,
3228: r_hrsrp.SEQUENCE_NO);
3229: EXCEPTION WHEN OTHERS THEN
3230: hr_legislation.hrrunprc_trace_on;
3231: hr_utility.trace('ins ff_route_parameters');
3232: hr_utility.trace('PARAMETER_NAME ' ||
3233: r_hrsrp.PARAMETER_NAME);
3234: hr_utility.trace('SEQUENCE_NO ' ||
3235: to_char(r_hrsrp.SEQUENCE_NO));

Line 4795: ff_route_parameters rp,

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