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.

[Home] [Help]

APPS.FF_DATA_DICT dependencies on FF_ROUTES

Line 1848: -- INSTALLATION PROCEDURE FOR : FF_ROUTES

1844:
1845: END install_formulas;
1846:
1847: --****************************************************************************
1848: -- INSTALLATION PROCEDURE FOR : FF_ROUTES
1849: --****************************************************************************
1850:
1851: PROCEDURE install_routes (p_phase IN number)
1852: ------------------------

Line 1940: -- FF_ROUTES

1936: PROCEDURE crt_exc (exception_type IN varchar2)
1937: ----------------------------------------------
1938: IS
1939: -- Reports any exceptions during the delivery of startup data to
1940: -- FF_ROUTES
1941:
1942: BEGIN
1943: -- When the installation procedures encounter an error that cannot
1944: -- be handled, an exception is raised and all work is rolled back

Line 1952: hr_legislation.insert_hr_stu_exceptions('ff_routes'

1948:
1949:
1950: rollback to new_route_name;
1951:
1952: hr_legislation.insert_hr_stu_exceptions('ff_routes'
1953: , stu_rec.c_surrogate_key
1954: , exception_type
1955: , stu_rec.c_true_key);
1956:

Line 1974: -- 1. ff_routes

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

Line 1983: -- 1. ff_routes_S

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

Line 1991: cursor get_ff_routes is

1987: v_sequence_number number(9);
1988: v_min_delivered number(9);
1989: v_max_delivered number(9);
1990: --
1991: cursor get_ff_routes is
1992: select distinct null
1993: from ff_routes a
1994: where exists
1995: (select null

Line 1993: from ff_routes a

1989: v_max_delivered number(9);
1990: --
1991: cursor get_ff_routes is
1992: select distinct null
1993: from ff_routes a
1994: where exists
1995: (select null
1996: from hr_s_routes b
1997: where a.route_id = b.route_id

Line 2020: -- Start with check against ff_routes

2016: );
2017: --
2018: BEGIN
2019:
2020: -- Start with check against ff_routes
2021:
2022:
2023: BEGIN --check that the installde routes will not conflict
2024: --with the delivered values

Line 2027: open get_ff_routes;

2023: BEGIN --check that the installde routes will not conflict
2024: --with the delivered values
2025:
2026: --
2027: open get_ff_routes;
2028: fetch get_ff_routes into l_null_return;
2029: IF get_ff_routes%NOTFOUND OR get_ff_routes%NOTFOUND IS NULL THEN
2030: RAISE NO_DATA_FOUND;
2031: END IF;

Line 2028: fetch get_ff_routes into l_null_return;

2024: --with the delivered values
2025:
2026: --
2027: open get_ff_routes;
2028: fetch get_ff_routes into l_null_return;
2029: IF get_ff_routes%NOTFOUND OR get_ff_routes%NOTFOUND IS NULL THEN
2030: RAISE NO_DATA_FOUND;
2031: END IF;
2032: close get_ff_routes;

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

2025:
2026: --
2027: open get_ff_routes;
2028: fetch get_ff_routes into l_null_return;
2029: IF get_ff_routes%NOTFOUND OR get_ff_routes%NOTFOUND IS NULL THEN
2030: RAISE NO_DATA_FOUND;
2031: END IF;
2032: close get_ff_routes;
2033: --

Line 2032: close get_ff_routes;

2028: fetch get_ff_routes into l_null_return;
2029: IF get_ff_routes%NOTFOUND OR get_ff_routes%NOTFOUND IS NULL THEN
2030: RAISE NO_DATA_FOUND;
2031: END IF;
2032: close get_ff_routes;
2033: --
2034: --conflict may exist
2035: --update all route_id's to remove conflict
2036:

Line 2126: select ff_routes_s.nextval

2122: into v_min_delivered
2123: , v_max_delivered
2124: from hr_s_routes;
2125:
2126: select ff_routes_s.nextval
2127: into v_sequence_number
2128: from dual;
2129:
2130: IF v_sequence_number

Line 2133: hr_legislation.munge_sequence('FF_ROUTES_S',

2129:
2130: IF v_sequence_number
2131: BETWEEN v_min_delivered AND v_max_delivered THEN
2132:
2133: hr_legislation.munge_sequence('FF_ROUTES_S',
2134: v_sequence_number,
2135: v_max_delivered);
2136:
2137: END IF;

Line 2210: from ff_routes

2206: BEGIN
2207:
2208: select distinct route_id
2209: into l_new_surrogate_key
2210: from ff_routes
2211: where route_name = stu_rec.c_true_key
2212: and user_defined_flag = 'N';
2213:
2214: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2217: select ff_routes_s.nextval

2213:
2214: EXCEPTION WHEN NO_DATA_FOUND THEN
2215:
2216:
2217: select ff_routes_s.nextval
2218: into l_new_surrogate_key
2219: from dual;
2220:
2221: WHEN TOO_MANY_ROWS THEN

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

2219: from dual;
2220:
2221: WHEN TOO_MANY_ROWS THEN
2222: hr_legislation.hrrunprc_trace_on;
2223: hr_utility.trace('sel route ff_routes TMR');
2224: hr_utility.trace('route_name ' ||
2225: stu_rec.c_true_key);
2226: hr_legislation.hrrunprc_trace_off;
2227: raise;

Line 2504: v_optimizer_hint ff_routes.optimizer_hint%type;

2500: --
2501: -- Optimizer hint now can trigger update
2502:
2503: v_route_text long; -- Used to select the installed route text
2504: v_optimizer_hint ff_routes.optimizer_hint%type;
2505: v_last_update date; -- Used to select the installed last update
2506:
2507: BEGIN
2508:

Line 2511: from ff_routes

2507: BEGIN
2508:
2509: select text, optimizer_hint
2510: into v_route_text, v_optimizer_hint
2511: from ff_routes
2512: where route_id = p_route_id;
2513:
2514: IF v_route_text = stu_rec.text AND
2515: nvl(v_optimizer_hint, 'nohint') =

Line 2555: from ff_routes a

2551:
2552: --
2553: select count(*)
2554: into l_number
2555: from ff_routes a
2556: where a.route_name = stu_rec.c_true_key
2557: and a.user_defined_flag = 'Y';
2558: --
2559: if l_number = 0 or l_number is null then

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

2560: return TRUE;
2561: else
2562: --This Route name is an existing User-Defined route
2563: --So cannot be delivered.
2564: crt_exc('FF_Routes row already created by a user');
2565: return FALSE;--indicates this row is not to be transferred
2566: end if;
2567:
2568: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2961: ff_routes fr

2957: from ff_fdi_usages_f ffu
2958: where ffu.item_name in (select fdbi.user_name
2959: from ff_database_items fdbi,
2960: ff_user_entities fue,
2961: ff_routes fr
2962: where fdbi.user_entity_id = fue.user_entity_id
2963: and fue.route_id = fr.route_id
2964: and fr.route_id = p_route_id);
2965:

Line 2985: update ff_routes

2981: -- already in the live tables
2982:
2983: BEGIN
2984:
2985: update ff_routes
2986: set user_defined_flag = stu_rec.user_defined_flag
2987: , description = stu_Rec.description
2988: , text = stu_rec.text
2989: , last_update_date = stu_rec.last_update_date

Line 3000: insert into ff_Routes

2996:
2997: IF SQL%NOTFOUND THEN
2998:
2999: BEGIN
3000: insert into ff_Routes
3001: (route_id
3002: ,route_name
3003: ,user_defined_flag
3004: ,description

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

3024: ,stu_rec.optimizer_hint
3025: );
3026: EXCEPTION WHEN OTHERS THEN
3027: hr_legislation.hrrunprc_trace_on;
3028: hr_utility.trace('ins ff_routes');
3029: hr_utility.trace('route_name ' ||
3030: stu_rec.c_true_key);
3031: hr_utility.trace('route_id ' ||
3032: to_char(stu_rec.c_surrogate_key));