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_CONTEXTS

Line 4: -- INSTALLATION PROCEDURE FOR : FF_CONTEXTS_F

1: PACKAGE body ff_data_dict AS
2: /* $Header: peffdict.pkb 120.4.12000000.2 2007/02/08 11:18:04 divicker ship $ */
3: --****************************************************************************
4: -- INSTALLATION PROCEDURE FOR : FF_CONTEXTS_F
5: --****************************************************************************
6:
7: procedure disable_ffuebru_trig is
8: statem varchar2(256);

Line 119: -- FF_CONTEXTS_F

115: PROCEDURE crt_exc (exception_type IN varchar2)
116: ----------------------------------------------
117: IS
118: -- Reports any exceptions during the delivery of startup data to
119: -- FF_CONTEXTS_F
120: BEGIN
121: -- When the installation procedures encounter an error that cannot
122: -- be handled, an exception is raised and all work is rolled back
123: -- to the last savepoint. The installation process then continues

Line 129: hr_legislation.insert_hr_stu_exceptions('ff_contexts'

125: -- not be raised more than once.
126:
127: rollback to new_context_name;
128:
129: hr_legislation.insert_hr_stu_exceptions('ff_contexts'
130: , stu_rec.c_surrogate_key
131: , exception_type
132: , stu_rec.c_true_key);
133:

Line 170: from ff_contexts a

166:
167:
168: select distinct null
169: into l_null_return
170: from ff_contexts a
171: where exists
172: (select null
173: from hr_s_contexts b
174: where a.context_id = b.context_id

Line 208: select ff_contexts_s.nextval

204: into v_min_delivered
205: , v_max_delivered
206: from hr_s_contexts;
207:
208: select ff_contexts_s.nextval
209: into v_sequence_number
210: from dual;
211:
212: IF v_sequence_number

Line 215: hr_legislation.munge_sequence('FF_CONTEXTS_S',

211:
212: IF v_sequence_number
213: BETWEEN v_min_delivered AND v_max_delivered THEN
214:
215: hr_legislation.munge_sequence('FF_CONTEXTS_S',
216: v_sequence_number,
217: v_max_delivered);
218:
219: END IF;

Line 237: from ff_contexts

233: BEGIN
234:
235: select distinct context_id
236: into l_new_surrogate_key
237: from ff_contexts
238: where context_name = stu_rec.c_true_key;
239:
240: EXCEPTION WHEN NO_DATA_FOUND THEN
241:

Line 243: select ff_contexts_s.nextval

239:
240: EXCEPTION WHEN NO_DATA_FOUND THEN
241:
242:
243: select ff_contexts_s.nextval
244: into l_new_surrogate_key
245: from dual;
246:
247: END;

Line 291: and table_name = 'FF_CONTEXTS';

287: END IF;
288:
289: delete from hr_stu_exceptions
290: where surrogate_id = stu_rec.c_surrogate_key
291: and table_name = 'FF_CONTEXTS';
292:
293: END remove;
294:
295: FUNCTION valid_ownership RETURN BOOLEAN

Line 373: from ff_contexts

369: -- row must be deleted.
370:
371: select null
372: into l_null_return
373: from ff_contexts
374: where context_name = stu_rec.c_true_key;
375:
376:
377: -- Row not required so delete

Line 393: insert into ff_contexts

389: return;
390: END IF;
391:
392: BEGIN
393: insert into ff_contexts
394: (context_id
395: ,context_level
396: ,context_name
397: ,data_type

Line 406: hr_utility.trace('ins ff_contexts');

402: ,stu_rec.c_true_key
403: ,stu_rec.data_type);
404: EXCEPTION WHEN OTHERS THEN
405: hr_legislation.hrrunprc_trace_on;
406: hr_utility.trace('ins ff_contexts');
407: hr_utility.trace('context_id ' ||
408: to_char(stu_rec.c_surrogate_key));
409: hr_utility.trace('context_name ' ||
410: stu_rec.c_true_key);

Line 819: from ff_contexts

815: IS
816:
817: CURSOR c_fft5 (usages_context_id number) IS
818: select null
819: from ff_contexts
820: where context_id = usages_context_id;
821: --
822:
823: BEGIN

Line 891: ff_contexts c

887: where f.formula_id in (
888: select distinct a.formula_id
889: from ff_formulas_f a,
890: ff_fdi_usages_f b,
891: ff_contexts c
892: where a.formula_type_id = stu_rec.c_surrogate_key
893: and a.formula_id = b.formula_id
894: and b.item_name = upper(c.context_name)
895: and c.context_id = usages.context_id

Line 903: ff_contexts c

899: where f.formula_id in (
900: select distinct a.formula_id
901: from ff_formulas_f a,
902: ff_fdi_usages_f b,
903: ff_contexts c
904: where a.formula_type_id = stu_rec.c_surrogate_key
905: and a.formula_id = b.formula_id
906: and b.item_name = upper(c.context_name)
907: and c.context_id = usages.context_id

Line 3045: cursor c_ff_contexts_null (c_context_id in number) is

3041: PROCEDURE transfer_row
3042: ----------------------
3043: IS
3044: -- Procedure to transfer a route from the delivery tables
3045: cursor c_ff_contexts_null (c_context_id in number) is
3046: select null
3047: from ff_contexts
3048: where context_id = c_context_id;
3049: --

Line 3047: from ff_contexts

3043: IS
3044: -- Procedure to transfer a route from the delivery tables
3045: cursor c_ff_contexts_null (c_context_id in number) is
3046: select null
3047: from ff_contexts
3048: where context_id = c_context_id;
3049: --
3050: cursor c_ffrp_null (c_route_parameter_id in number) is
3051: select null

Line 3113: open c_ff_contexts_null (context_usages.context_id);

3109: FOR context_usages IN usage(stu_rec.c_surrogate_key) LOOP
3110:
3111: BEGIN
3112: --
3113: open c_ff_contexts_null (context_usages.context_id);
3114: fetch c_ff_contexts_null into l_null_return;
3115: IF c_ff_contexts_null%NOTFOUND OR c_ff_contexts_null%NOTFOUND IS NULL THEN
3116: close c_ff_contexts_null;
3117: RAISE NO_DATA_FOUND;

Line 3114: fetch c_ff_contexts_null into l_null_return;

3110:
3111: BEGIN
3112: --
3113: open c_ff_contexts_null (context_usages.context_id);
3114: fetch c_ff_contexts_null into l_null_return;
3115: IF c_ff_contexts_null%NOTFOUND OR c_ff_contexts_null%NOTFOUND IS NULL THEN
3116: close c_ff_contexts_null;
3117: RAISE NO_DATA_FOUND;
3118: END IF;

Line 3115: IF c_ff_contexts_null%NOTFOUND OR c_ff_contexts_null%NOTFOUND IS NULL THEN

3111: BEGIN
3112: --
3113: open c_ff_contexts_null (context_usages.context_id);
3114: fetch c_ff_contexts_null into l_null_return;
3115: IF c_ff_contexts_null%NOTFOUND OR c_ff_contexts_null%NOTFOUND IS NULL THEN
3116: close c_ff_contexts_null;
3117: RAISE NO_DATA_FOUND;
3118: END IF;
3119: close c_ff_contexts_null;

Line 3116: close c_ff_contexts_null;

3112: --
3113: open c_ff_contexts_null (context_usages.context_id);
3114: fetch c_ff_contexts_null into l_null_return;
3115: IF c_ff_contexts_null%NOTFOUND OR c_ff_contexts_null%NOTFOUND IS NULL THEN
3116: close c_ff_contexts_null;
3117: RAISE NO_DATA_FOUND;
3118: END IF;
3119: close c_ff_contexts_null;
3120: --

Line 3119: close c_ff_contexts_null;

3115: IF c_ff_contexts_null%NOTFOUND OR c_ff_contexts_null%NOTFOUND IS NULL THEN
3116: close c_ff_contexts_null;
3117: RAISE NO_DATA_FOUND;
3118: END IF;
3119: close c_ff_contexts_null;
3120: --
3121: BEGIN
3122: insert into ff_route_context_usages
3123: (route_id

Line 3588: from ff_contexts

3584:
3585:
3586: select null
3587: into l_null_return
3588: from ff_contexts
3589: where context_id = child_usages.context_id;
3590:
3591: insert into ff_function_context_usages
3592: (function_id

Line 4876: install_ffc(p_phase); --install ff_contexts

4872: hr_legislation.hrrunprc_trace_on;
4873: hr_utility.trace('start install_ffc: ' || to_char(p_phase));
4874: hr_legislation.hrrunprc_trace_off;
4875:
4876: install_ffc(p_phase); --install ff_contexts
4877: hr_legislation.hrrunprc_trace_on;
4878: hr_utility.trace('start install_fft: ' || to_char(p_phase));
4879: hr_legislation.hrrunprc_trace_off;
4880: