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_ROUTES

Line 1862: -- INSTALLATION PROCEDURE FOR : FF_ROUTES

1858:
1859: END install_formulas;
1860:
1861: --****************************************************************************
1862: -- INSTALLATION PROCEDURE FOR : FF_ROUTES
1863: --****************************************************************************
1864:
1865: PROCEDURE install_routes (p_phase IN number)
1866: ------------------------

Line 1956: -- FF_ROUTES

1952: PROCEDURE crt_exc (exception_type IN varchar2)
1953: ----------------------------------------------
1954: IS
1955: -- Reports any exceptions during the delivery of startup data to
1956: -- FF_ROUTES
1957:
1958: BEGIN
1959: -- When the installation procedures encounter an error that cannot
1960: -- be handled, an exception is raised and all work is rolled back

Line 1968: hr_legislation.insert_hr_stu_exceptions('ff_routes'

1964:
1965:
1966: rollback to new_route_name;
1967:
1968: hr_legislation.insert_hr_stu_exceptions('ff_routes'
1969: , stu_rec.c_surrogate_key
1970: , exception_type
1971: , stu_rec.c_true_key);
1972:

Line 1990: -- 1. ff_routes

1986: -- The first is a simple match, where if a value is detected in the
1987: -- STU tables and the installed tables then a conflict is detected. In
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

Line 1999: -- 1. ff_routes_S

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
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);

Line 2007: cursor get_ff_routes is

2003: v_sequence_number number(9);
2004: v_min_delivered number(9);
2005: v_max_delivered number(9);
2006: --
2007: cursor get_ff_routes is
2008: select distinct null
2009: from ff_routes a
2010: where exists
2011: (select null

Line 2009: from ff_routes a

2005: v_max_delivered number(9);
2006: --
2007: cursor get_ff_routes is
2008: select distinct null
2009: from ff_routes a
2010: where exists
2011: (select null
2012: from hr_s_routes b
2013: where a.route_id = b.route_id

Line 2036: -- Start with check against ff_routes

2032: );
2033: --
2034: BEGIN
2035:
2036: -- Start with check against ff_routes
2037:
2038:
2039: BEGIN --check that the installde routes will not conflict
2040: --with the delivered values

Line 2043: open get_ff_routes;

2039: BEGIN --check that the installde routes will not conflict
2040: --with the delivered values
2041:
2042: --
2043: open get_ff_routes;
2044: fetch get_ff_routes into l_null_return;
2045: IF get_ff_routes%NOTFOUND OR get_ff_routes%NOTFOUND IS NULL THEN
2046: RAISE NO_DATA_FOUND;
2047: END IF;

Line 2044: fetch get_ff_routes into l_null_return;

2040: --with the delivered values
2041:
2042: --
2043: open get_ff_routes;
2044: fetch get_ff_routes into l_null_return;
2045: IF get_ff_routes%NOTFOUND OR get_ff_routes%NOTFOUND IS NULL THEN
2046: RAISE NO_DATA_FOUND;
2047: END IF;
2048: close get_ff_routes;

Line 2045: IF get_ff_routes%NOTFOUND OR get_ff_routes%NOTFOUND IS NULL THEN

2041:
2042: --
2043: open get_ff_routes;
2044: fetch get_ff_routes into l_null_return;
2045: IF get_ff_routes%NOTFOUND OR get_ff_routes%NOTFOUND IS NULL THEN
2046: RAISE NO_DATA_FOUND;
2047: END IF;
2048: close get_ff_routes;
2049: --

Line 2048: close get_ff_routes;

2044: fetch get_ff_routes into l_null_return;
2045: IF get_ff_routes%NOTFOUND OR get_ff_routes%NOTFOUND IS NULL THEN
2046: RAISE NO_DATA_FOUND;
2047: END IF;
2048: close get_ff_routes;
2049: --
2050: --conflict may exist
2051: --update all route_id's to remove conflict
2052:

Line 2142: select ff_routes_s.nextval

2138: into v_min_delivered
2139: , v_max_delivered
2140: from hr_s_routes;
2141:
2142: select ff_routes_s.nextval
2143: into v_sequence_number
2144: from dual;
2145:
2146: IF v_sequence_number

Line 2149: hr_legislation.munge_sequence('FF_ROUTES_S',

2145:
2146: IF v_sequence_number
2147: BETWEEN v_min_delivered AND v_max_delivered THEN
2148:
2149: hr_legislation.munge_sequence('FF_ROUTES_S',
2150: v_sequence_number,
2151: v_max_delivered);
2152:
2153: END IF;

Line 2226: from ff_routes

2222: BEGIN
2223:
2224: select distinct route_id
2225: into l_new_surrogate_key
2226: from ff_routes
2227: where route_name = stu_rec.c_true_key
2228: and user_defined_flag = 'N';
2229:
2230: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2233: select ff_routes_s.nextval

2229:
2230: EXCEPTION WHEN NO_DATA_FOUND THEN
2231:
2232:
2233: select ff_routes_s.nextval
2234: into l_new_surrogate_key
2235: from dual;
2236:
2237: WHEN TOO_MANY_ROWS THEN

Line 2239: hr_utility.trace('sel route ff_routes TMR');

2235: from dual;
2236:
2237: WHEN TOO_MANY_ROWS THEN
2238: hr_legislation.hrrunprc_trace_on;
2239: hr_utility.trace('sel route ff_routes TMR');
2240: hr_utility.trace('route_name ' ||
2241: stu_rec.c_true_key);
2242: hr_legislation.hrrunprc_trace_off;
2243: raise;

Line 2532: v_optimizer_hint ff_routes.optimizer_hint%type;

2528: --
2529: -- from 12.1 also verify route is not a stub (description prefix)
2530:
2531: v_route_text clob; -- Used to select the installed route text
2532: v_optimizer_hint ff_routes.optimizer_hint%type;
2533: v_route_description ff_routes.description%type;
2534: v_last_update date; -- Used to select the installed last update
2535:
2536: BEGIN

Line 2533: v_route_description ff_routes.description%type;

2529: -- from 12.1 also verify route is not a stub (description prefix)
2530:
2531: v_route_text clob; -- Used to select the installed route text
2532: v_optimizer_hint ff_routes.optimizer_hint%type;
2533: v_route_description ff_routes.description%type;
2534: v_last_update date; -- Used to select the installed last update
2535:
2536: BEGIN
2537:

Line 2545: from ff_routes

2541: END IF;
2542:
2543: select text, optimizer_hint , description
2544: into v_route_text, v_optimizer_hint, v_route_description
2545: from ff_routes
2546: where route_id = p_route_id;
2547:
2548: IF (( substr(fnd_release.release_name,1,4) = '12.2' ) or
2549: ( substr(fnd_release.release_name,1,4) = '12.1' )) and

Line 2596: from ff_routes a

2592:
2593: --
2594: select count(*)
2595: into l_number
2596: from ff_routes a
2597: where a.route_name = stu_rec.c_true_key
2598: and a.user_defined_flag = 'Y';
2599: --
2600: if l_number = 0 or l_number is null then

Line 2605: crt_exc('FF_Routes row already created by a user');

2601: return TRUE;
2602: else
2603: --This Route name is an existing User-Defined route
2604: --So cannot be delivered.
2605: crt_exc('FF_Routes row already created by a user');
2606: return FALSE;--indicates this row is not to be transferred
2607: end if;
2608:
2609: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 3025: update ff_routes

3021: -- already in the live tables
3022:
3023: BEGIN
3024:
3025: update ff_routes
3026: set user_defined_flag = stu_rec.user_defined_flag
3027: , description = stu_Rec.description
3028: , text = stu_rec.text
3029: , last_update_date = stu_rec.last_update_date

Line 3040: insert into ff_Routes

3036:
3037: IF SQL%NOTFOUND THEN
3038:
3039: BEGIN
3040: insert into ff_Routes
3041: (route_id
3042: ,route_name
3043: ,user_defined_flag
3044: ,description

Line 3068: hr_utility.trace('ins ff_routes');

3064: ,stu_rec.optimizer_hint
3065: );
3066: EXCEPTION WHEN OTHERS THEN
3067: hr_legislation.hrrunprc_trace_on;
3068: hr_utility.trace('ins ff_routes');
3069: hr_utility.trace('route_name ' ||
3070: stu_rec.c_true_key);
3071: hr_utility.trace('route_id ' ||
3072: to_char(stu_rec.c_surrogate_key));