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 HR_LEGISLATION

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 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 405: hr_legislation.hrrunprc_trace_on;

401: ,stu_rec.context_level
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 ' ||

Line 415: hr_legislation.hrrunprc_trace_off;

411: hr_utility.trace('context_level ' ||
412: to_char(stu_rec.context_level));
413: hr_utility.trace('datatype ' ||
414: stu_rec.data_type);
415: hr_legislation.hrrunprc_trace_off;
416: raise;
417: END;
418:
419:

Line 523: hr_legislation.insert_hr_stu_exceptions('ff_formula_types'

519:
520:
521: rollback to new_formula_type_name;
522:
523: hr_legislation.insert_hr_stu_exceptions('ff_formula_types'
524: , stu_rec.c_surrogate_key
525: , exception_type
526: , stu_rec.c_true_key);
527:

Line 616: hr_legislation.munge_sequence('FF_FORMULA_TYPES_S',

612:
613: IF v_sequence_number
614: BETWEEN v_min_delivered AND v_max_delivered THEN
615:
616: hr_legislation.munge_sequence('FF_FORMULA_TYPES_S',
617: v_sequence_number,
618: v_max_delivered);
619:
620: END IF;

Line 646: hr_legislation.hrrunprc_trace_on;

642: into l_new_surrogate_key
643: from dual;
644:
645: WHEN TOO_MANY_ROWS THEN
646: hr_legislation.hrrunprc_trace_on;
647: hr_utility.trace('multiple ftype ' || stu_rec.c_true_key);
648: hr_legislation.hrrunprc_trace_off;
649: raise;
650: END;

Line 648: hr_legislation.hrrunprc_trace_off;

644:
645: WHEN TOO_MANY_ROWS THEN
646: hr_legislation.hrrunprc_trace_on;
647: hr_utility.trace('multiple ftype ' || stu_rec.c_true_key);
648: hr_legislation.hrrunprc_trace_off;
649: raise;
650: END;
651:
652: -- Update all child entities

Line 860: hr_legislation.hrrunprc_trace_on;

856: ,stu_rec.created_by
857: ,stu_rec.creation_date
858: );
859: EXCEPTION WHEN OTHERS THEN
860: hr_legislation.hrrunprc_trace_on;
861: hr_utility.trace('ins ff_formula_types');
862: hr_utility.trace('formula_type_id ' ||
863: to_char(stu_rec.c_surrogate_key));
864: hr_utility.trace('formula_type_name ' ||

Line 866: hr_legislation.hrrunprc_trace_off;

862: hr_utility.trace('formula_type_id ' ||
863: to_char(stu_rec.c_surrogate_key));
864: hr_utility.trace('formula_type_name ' ||
865: stu_rec.c_true_key);
866: hr_legislation.hrrunprc_trace_off;
867: raise;
868: END;
869:
870:

Line 940: hr_legislation.hrrunprc_trace_on;

936:
937: return;
938:
939: WHEN OTHERS THEN
940: hr_legislation.hrrunprc_trace_on;
941: hr_utility.trace('ins ff_ftype_context_usages');
942: hr_utility.trace('formula_type_id ' ||
943: to_char(usages.formula_type_id));
944: hr_utility.trace('context_id ' ||

Line 948: hr_legislation.hrrunprc_trace_off;

944: hr_utility.trace('context_id ' ||
945: to_char(usages.context_id));
946: hr_utility.trace('formula_type_name ' ||
947: stu_rec.c_true_key);
948: hr_legislation.hrrunprc_trace_off;
949: raise;
950: END;
951:
952: END LOOP usages;

Line 1026: l_current_proc varchar2(80) := 'hr_legislation.install_formulas';

1022:
1023: row_in_error exception;
1024: v_formula_text long;
1025: vlive_formula_text long;
1026: l_current_proc varchar2(80) := 'hr_legislation.install_formulas';
1027: l_new_formula_id number(15);
1028: l_null_return varchar2(1);
1029:
1030: CURSOR c_distinct

Line 1085: hr_legislation.insert_hr_stu_exceptions('ff_formulas_f'

1081: -- not be raised more than once.
1082:
1083: rollback to new_formula_name;
1084:
1085: hr_legislation.insert_hr_stu_exceptions('ff_formulas_f'
1086: , r_distinct.c_surrogate_key
1087: , exception_type
1088: , r_distinct.c_true_key);
1089:

Line 1204: hr_legislation.munge_sequence('FF_FORMULAS_S',

1200:
1201: IF v_sequence_number
1202: BETWEEN v_min_delivered AND v_max_delivered THEN
1203:
1204: hr_legislation.munge_sequence('FF_FORMULAS_S',
1205: v_sequence_number,
1206: v_max_delivered);
1207: END IF;
1208:

Line 1246: hr_legislation.hrrunprc_trace_on;

1242: from dual;
1243:
1244: WHEN TOO_MANY_ROWS THEN
1245:
1246: hr_legislation.hrrunprc_trace_on;
1247: hr_utility.trace('sel ff_formulas_f TMR');
1248: hr_utility.trace('formula_name ' ||
1249: r_distinct.c_true_key);
1250: hr_utility.trace('formula_type_id ' ||

Line 1254: hr_legislation.hrrunprc_trace_off;

1250: hr_utility.trace('formula_type_id ' ||
1251: to_char(r_distinct.formula_type_id));
1252: hr_utility.trace(':lc: ' || ':' ||
1253: r_distinct.legislation_code || ':');
1254: hr_legislation.hrrunprc_trace_off;
1255: raise;
1256: END;
1257:
1258: update hr_s_formulas_f

Line 1806: hr_legislation.hrrunprc_trace_on;

1802: ,r_each_row.created_by
1803: ,r_each_row.creation_date
1804: );
1805: EXCEPTION WHEN OTHERS THEN
1806: hr_legislation.hrrunprc_trace_on;
1807: hr_utility.trace('ins ff_formulas_f');
1808: hr_utility.trace('formula_name ' ||
1809: r_each_row.formula_name);
1810: hr_utility.trace('formula_id ' ||

Line 1816: hr_legislation.hrrunprc_trace_off;

1812: hr_utility.trace('formula_type_id ' ||
1813: to_char(r_each_row.formula_type_id));
1814: hr_utility.trace(':lc: ' || ':' ||
1815: r_each_row.legislation_code || ':');
1816: hr_legislation.hrrunprc_trace_off;
1817: raise;
1818: END;
1819:
1820: remove(r_distinct.c_surrogate_key);

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 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 2155: hr_legislation.munge_sequence('FF_USER_ENTITIES_S',

2151:
2152: IF v_sequence_number
2153: BETWEEN v_min_delivered AND v_max_delivered THEN
2154:
2155: hr_legislation.munge_sequence('FF_USER_ENTITIES_S',
2156: v_sequence_number,
2157: v_max_delivered);
2158:
2159: END IF;

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 2222: hr_legislation.hrrunprc_trace_on;

2218: into l_new_surrogate_key
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;

Line 2226: hr_legislation.hrrunprc_trace_off;

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;
2228: END;
2229:
2230:

Line 2296: hr_legislation.hrrunprc_trace_on;

2292: from dual;
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 ' ||

Line 2306: hr_legislation.hrrunprc_trace_off;

2302: hr_utility.trace('route_name ' ||
2303: stu_rec.c_true_key);
2304: hr_utility.trace('sequence_no ' ||
2305: to_char(delivered_params.sequence_no));
2306: hr_legislation.hrrunprc_trace_off;
2307: raise;
2308:
2309: END; --select of new surrogate id
2310:

Line 2340: hr_legislation.hrrunprc_trace_on;

2336: into l_new_entity_id
2337: from dual;
2338:
2339: WHEN TOO_MANY_ROWS THEN
2340: hr_legislation.hrrunprc_trace_on;
2341: hr_utility.trace('sel ff_user_entities TMR');
2342: hr_utility.trace('user_entity_name ' ||
2343: delivered_entities.user_entity_name);
2344: hr_utility.trace('route_id ' ||

Line 2350: hr_legislation.hrrunprc_trace_off;

2346: hr_utility.trace('route_name ' ||
2347: stu_rec.c_true_key);
2348: hr_utility.trace(':lc: ' || ':' ||
2349: delivered_entities.legislation_code || ':');
2350: hr_legislation.hrrunprc_trace_off;
2351: raise;
2352: END;
2353:
2354: update hr_s_user_entities

Line 2522: -- hr_legislation.hrrunprc_trace_on;

2518: return FALSE;
2519: END IF;
2520:
2521: p_new_route := FALSE;
2522: -- hr_legislation.hrrunprc_trace_on;
2523: -- hr_utility.trace('route diff: ' || to_char(l_new_surrogate_key) || ' '
2524: -- || stu_rec.c_true_key);
2525: -- hr_legislation.hrrunprc_trace_off;
2526:

Line 2525: -- hr_legislation.hrrunprc_trace_off;

2521: p_new_route := FALSE;
2522: -- hr_legislation.hrrunprc_trace_on;
2523: -- hr_utility.trace('route diff: ' || to_char(l_new_surrogate_key) || ' '
2524: -- || stu_rec.c_true_key);
2525: -- hr_legislation.hrrunprc_trace_off;
2526:
2527: return TRUE; --delivered route is defferent
2528:
2529: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2532: -- hr_legislation.hrrunprc_trace_on;

2528:
2529: EXCEPTION WHEN NO_DATA_FOUND THEN
2530: -- The route is not installed
2531: p_new_route := TRUE;
2532: -- hr_legislation.hrrunprc_trace_on;
2533: -- hr_utility.trace('new route: ' || to_char(l_new_surrogate_key) || ' '
2534: -- || stu_rec.c_true_key);
2535: -- hr_legislation.hrrunprc_trace_off;
2536: return TRUE;

Line 2535: -- hr_legislation.hrrunprc_trace_off;

2531: p_new_route := TRUE;
2532: -- hr_legislation.hrrunprc_trace_on;
2533: -- hr_utility.trace('new route: ' || to_char(l_new_surrogate_key) || ' '
2534: -- || stu_rec.c_true_key);
2535: -- hr_legislation.hrrunprc_trace_off;
2536: return TRUE;
2537:
2538: END;
2539:

Line 2676: -- hr_legislation.hrrunprc_trace_on;

2672: select user_entity_name
2673: into ue_name2
2674: from hr_s_user_entities
2675: where user_entity_id = v_user_entity_id;
2676: -- hr_legislation.hrrunprc_trace_on;
2677: -- hr_utility.trace('ue chg: ' || to_char(v_user_entity_id) || ' '
2678: -- || ue_name1 || ':' || ue_name2);
2679: -- hr_legislation.hrrunprc_trace_off;
2680: exception when others then null;

Line 2679: -- hr_legislation.hrrunprc_trace_off;

2675: where user_entity_id = v_user_entity_id;
2676: -- hr_legislation.hrrunprc_trace_on;
2677: -- hr_utility.trace('ue chg: ' || to_char(v_user_entity_id) || ' '
2678: -- || ue_name1 || ':' || ue_name2);
2679: -- hr_legislation.hrrunprc_trace_off;
2680: exception when others then null;
2681: end;
2682:
2683: return TRUE;

Line 2777: hr_legislation.hrrunprc_trace_on;

2773: ,all_user_entities.creation_date
2774: );
2775:
2776: EXCEPTION WHEN OTHERS THEN
2777: hr_legislation.hrrunprc_trace_on;
2778: hr_utility.trace('ins ff_user_entities');
2779: hr_utility.trace('user_entity_name ' ||
2780: all_user_entities.user_entity_name);
2781: hr_utility.trace('user_entity_id ' ||

Line 2793: hr_legislation.hrrunprc_trace_off;

2789: hr_utility.trace('creator_type ' ||
2790: all_user_entities.creator_type);
2791: hr_utility.trace(':lc: ' || ':' ||
2792: all_user_entities.legislation_code || ':');
2793: hr_legislation.hrrunprc_trace_off;
2794: raise;
2795: END;
2796: END IF;
2797:

Line 2845: hr_legislation.hrrunprc_trace_on;

2841: ,all_db_items.created_by
2842: ,all_db_items.creation_date
2843: );
2844: EXCEPTION WHEN OTHERS THEN
2845: hr_legislation.hrrunprc_trace_on;
2846: hr_utility.trace('ins ff_database_items');
2847: hr_utility.trace('dbi user_name ' ||
2848: all_db_items.user_name);
2849: hr_utility.trace('user_entity_id ' ||

Line 2861: hr_legislation.hrrunprc_trace_off;

2857: hr_utility.trace('creator_id ' ||
2858: to_char(all_user_entities.creator_id));
2859: hr_utility.trace('creator_type ' ||
2860: all_user_entities.creator_type);
2861: hr_legislation.hrrunprc_trace_off;
2862: raise;
2863: END;
2864:
2865: END IF;

Line 2909: hr_legislation.hrrunprc_trace_on;

2905: ,pvalues.created_by
2906: ,pvalues.creation_date
2907: );
2908: EXCEPTION WHEN OTHERS THEN
2909: hr_legislation.hrrunprc_trace_on;
2910: hr_utility.trace('ins ff_route_parameter_values');
2911: hr_utility.trace('value ' ||
2912: pvalues.value);
2913: hr_utility.trace('route_parameter_id ' ||

Line 2927: hr_legislation.hrrunprc_trace_off;

2923: hr_utility.trace('creator_id ' ||
2924: to_char(all_user_entities.creator_id));
2925: hr_utility.trace('creator_type ' ||
2926: all_user_entities.creator_type);
2927: hr_legislation.hrrunprc_trace_off;
2928: raise;
2929: END;
2930:
2931: END IF;

Line 3027: hr_legislation.hrrunprc_trace_on;

3023: ,stu_rec.creation_date
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 ' ||

Line 3033: hr_legislation.hrrunprc_trace_off;

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));
3033: hr_legislation.hrrunprc_trace_off;
3034: raise;
3035: END;
3036:
3037: END IF;

Line 3133: hr_legislation.hrrunprc_trace_on;

3129: ,context_usages.context_id
3130: ,context_usages.sequence_no
3131: );
3132: EXCEPTION WHEN OTHERS THEN
3133: hr_legislation.hrrunprc_trace_on;
3134: hr_utility.trace('ins ff_route_context_usages');
3135: hr_utility.trace('route_id ' ||
3136: to_char(context_usages.route_id));
3137: hr_utility.trace('route_name ' ||

Line 3143: hr_legislation.hrrunprc_trace_off;

3139: hr_utility.trace('context_id ' ||
3140: to_char(context_usages.context_id));
3141: hr_utility.trace('sequence_no ' ||
3142: to_char(context_usages.sequence_no));
3143: hr_legislation.hrrunprc_trace_off;
3144: raise;
3145: END;
3146:
3147: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 3190: hr_legislation.hrrunprc_trace_on;

3186: r_hrsrp.DATA_TYPE,
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 ' ||

Line 3202: hr_legislation.hrrunprc_trace_off;

3198: hr_utility.trace('route_name ' ||
3199: stu_rec.c_true_key);
3200: hr_utility.trace('ROUTE_PARAMETER_ID ' ||
3201: to_char(r_hrsrp.ROUTE_PARAMETER_ID));
3202: hr_legislation.hrrunprc_trace_off;
3203: raise;
3204: END;
3205:
3206: END;

Line 3341: hr_legislation.insert_hr_stu_exceptions('ff_functions'

3337:
3338:
3339: rollback to new_function_name;
3340:
3341: hr_legislation.insert_hr_stu_exceptions('ff_functions'
3342: , 0
3343: , exception_type
3344: , stu_rec.name);
3345:

Line 3537: hr_legislation.hrrunprc_trace_on;

3533: );
3534:
3535:
3536: EXCEPTION WHEN OTHERS THEN
3537: hr_legislation.hrrunprc_trace_on;
3538: hr_utility.trace('ins ff_functions');
3539: hr_utility.trace('function name ' ||
3540: each_func.name);
3541: hr_utility.trace('function_id ' ||

Line 3545: hr_legislation.hrrunprc_trace_off;

3541: hr_utility.trace('function_id ' ||
3542: to_char(l_new_surrogate_key));
3543: hr_utility.trace(':lc: ' || ':' ||
3544: each_func.legislation_code || ':');
3545: hr_legislation.hrrunprc_trace_off;
3546: raise;
3547: END;
3548:
3549: BEGIN

Line 3569: hr_legislation.hrrunprc_trace_on;

3565: , optional
3566: from hr_s_function_parameters
3567: where function_id = each_func.function_id;
3568: EXCEPTION WHEN OTHERS THEN
3569: hr_legislation.hrrunprc_trace_on;
3570: hr_utility.trace('ins ff_function_parameters');
3571: hr_utility.trace('function_id ' ||
3572: to_char(each_func.function_id));
3573: hr_utility.trace('function name ' ||

Line 3577: hr_legislation.hrrunprc_trace_off;

3573: hr_utility.trace('function name ' ||
3574: each_func.name);
3575: hr_utility.trace(':lc: ' ||
3576: each_func.legislation_code || ':');
3577: hr_legislation.hrrunprc_trace_off;
3578: raise;
3579: END;
3580:
3581: FOR child_usages IN usages(each_func.function_id) LOOP

Line 3610: hr_legislation.hrrunprc_trace_on;

3606:
3607: return;
3608:
3609: WHEN OTHERS THEN
3610: hr_legislation.hrrunprc_trace_on;
3611: hr_utility.trace('ins ff_function_context_usages');
3612: hr_utility.trace('function_id ' ||
3613: to_char(l_new_surrogate_key));
3614: hr_utility.trace('function name ' ||

Line 3622: hr_legislation.hrrunprc_trace_off;

3618: hr_utility.trace('sequence_number ' ||
3619: to_char(child_usages.sequence_number));
3620: hr_utility.trace('context_id ' ||
3621: to_char(child_usages.context_id));
3622: hr_legislation.hrrunprc_trace_off;
3623: raise;
3624:
3625: END;
3626:

Line 3725: hr_legislation.insert_hr_stu_exceptions('ff_qp_reports'

3721:
3722:
3723: rollback to new_qp_report_name;
3724:
3725: hr_legislation.insert_hr_stu_exceptions('ff_qp_reports'
3726: , stu_rec.c_surrogate_key
3727: , exception_type
3728: , stu_rec.c_true_key);
3729:

Line 3801: hr_legislation.munge_sequence('FF_QP_REPORTS_S',

3797:
3798: IF v_sequence_number
3799: BETWEEN v_min_delivered AND v_max_delivered THEN
3800:
3801: hr_legislation.munge_sequence('FF_QP_REPORTS_S',
3802: v_sequence_number,
3803: v_max_delivered);
3804:
3805: END IF;

Line 4271: l_current_proc varchar2(80) := 'hr_legislation.install_globals';

4267: -- details transferred into live tables. The parameter p_phase holds
4268: -- the phase number.
4269:
4270: row_in_error exception;
4271: l_current_proc varchar2(80) := 'hr_legislation.install_globals';
4272: l_new_global_id number(15);
4273: l_null_return varchar2(1);
4274: status varchar2(10);
4275:

Line 4414: hr_legislation.munge_sequence('FF_GLOBALS_S',

4410:
4411: IF v_sequence_number
4412: BETWEEN v_min_delivered AND v_max_delivered THEN
4413:
4414: hr_legislation.munge_sequence('FF_GLOBALS_S',
4415: v_sequence_number,
4416: v_max_delivered);
4417: END IF;
4418:

Line 4454: hr_legislation.hrrunprc_trace_on;

4450: into l_new_global_id
4451: from dual;
4452:
4453: WHEN TOO_MANY_ROWS THEN
4454: hr_legislation.hrrunprc_trace_on;
4455: hr_utility.trace('sel ff_globals_f TMR');
4456: hr_utility.trace('global_name ' ||
4457: r_distinct.c_true_key);
4458: hr_utility.trace(':lc: ' || ':' ||

Line 4460: hr_legislation.hrrunprc_trace_off;

4456: hr_utility.trace('global_name ' ||
4457: r_distinct.c_true_key);
4458: hr_utility.trace(':lc: ' || ':' ||
4459: r_distinct.legislation_code || ':');
4460: hr_legislation.hrrunprc_trace_off;
4461: raise;
4462: END;
4463:
4464: update hr_s_globals_f

Line 4491: hr_legislation.insert_hr_stu_exceptions('ff_globals_f'

4487: -- not be raised more than once.
4488:
4489: rollback to new_global_name;
4490:
4491: hr_legislation.insert_hr_stu_exceptions('ff_globals_f'
4492: , r_distinct.c_surrogate_key
4493: , exception_type
4494: , r_distinct.c_true_key);
4495:

Line 4813: hr_legislation.hrrunprc_trace_on;

4809: ,r_each_row.CREATED_BY
4810: ,r_each_row.CREATION_DATE);
4811:
4812: EXCEPTION WHEN OTHERS THEN
4813: hr_legislation.hrrunprc_trace_on;
4814: hr_utility.trace('ins ff_globals_f');
4815: hr_utility.trace('GLOBAL_NAME ' ||
4816: r_each_row.GLOBAL_NAME);
4817: hr_utility.trace('GLOBAL_ID ' ||

Line 4823: hr_legislation.hrrunprc_trace_off;

4819: hr_utility.trace('GLOBAL_VALUE ' ||
4820: r_each_row.GLOBAL_VALUE);
4821: hr_utility.trace(':lc: ' || ':' ||
4822: r_each_row.legislation_code || ':');
4823: hr_legislation.hrrunprc_trace_off;
4824: raise;
4825: END;
4826: END LOOP each_row;
4827:

Line 4855: hr_legislation.hrrunprc_trace_on;

4851: -- Driver procedure to execute all formula installation procedures.
4852: core_selected NUMBER;
4853:
4854: BEGIN
4855: hr_legislation.hrrunprc_trace_on;
4856: hr_utility.trace('start ff_data_dict.install: ' || to_char(p_phase));
4857: hr_legislation.hrrunprc_trace_off;
4858:
4859: IF p_phase <> 1 and p_phase <>2 THEN

Line 4857: hr_legislation.hrrunprc_trace_off;

4853:
4854: BEGIN
4855: hr_legislation.hrrunprc_trace_on;
4856: hr_utility.trace('start ff_data_dict.install: ' || to_char(p_phase));
4857: hr_legislation.hrrunprc_trace_off;
4858:
4859: IF p_phase <> 1 and p_phase <>2 THEN
4860: return;
4861: END IF;

Line 4867: from hr_legislation_installations

4863: IF p_phase = 2 THEN
4864:
4865: select count(*)
4866: into core_selected
4867: from hr_legislation_installations
4868: where legislation_code is null
4869: and action in ('I', 'U', 'F');
4870:
4871: END IF;

Line 4872: hr_legislation.hrrunprc_trace_on;

4868: where legislation_code is null
4869: and action in ('I', 'U', 'F');
4870:
4871: END IF;
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

Line 4874: hr_legislation.hrrunprc_trace_off;

4870:
4871: END IF;
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));

Line 4877: 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:
4881: install_fft(p_phase); --install ff_Formula_types

Line 4879: 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:
4881: install_fft(p_phase); --install ff_Formula_types
4882:
4883: hr_legislation.hrrunprc_trace_on;

Line 4883: hr_legislation.hrrunprc_trace_on;

4879: hr_legislation.hrrunprc_trace_off;
4880:
4881: install_fft(p_phase); --install ff_Formula_types
4882:
4883: hr_legislation.hrrunprc_trace_on;
4884: hr_utility.trace('start install_formulas: ' || to_char(p_phase));
4885: hr_legislation.hrrunprc_trace_off;
4886:
4887: install_formulas(p_phase); --install formulas

Line 4885: hr_legislation.hrrunprc_trace_off;

4881: install_fft(p_phase); --install ff_Formula_types
4882:
4883: hr_legislation.hrrunprc_trace_on;
4884: hr_utility.trace('start install_formulas: ' || to_char(p_phase));
4885: hr_legislation.hrrunprc_trace_off;
4886:
4887: install_formulas(p_phase); --install formulas
4888:
4889: hr_legislation.hrrunprc_trace_on;

Line 4889: hr_legislation.hrrunprc_trace_on;

4885: hr_legislation.hrrunprc_trace_off;
4886:
4887: install_formulas(p_phase); --install formulas
4888:
4889: hr_legislation.hrrunprc_trace_on;
4890: hr_utility.trace('start install_routes: ' || to_char(p_phase));
4891: hr_legislation.hrrunprc_trace_off;
4892:
4893: install_routes(p_phase); --install routes,entities,db items

Line 4891: hr_legislation.hrrunprc_trace_off;

4887: install_formulas(p_phase); --install formulas
4888:
4889: hr_legislation.hrrunprc_trace_on;
4890: hr_utility.trace('start install_routes: ' || to_char(p_phase));
4891: hr_legislation.hrrunprc_trace_off;
4892:
4893: install_routes(p_phase); --install routes,entities,db items
4894:
4895: hr_legislation.hrrunprc_trace_on;

Line 4895: hr_legislation.hrrunprc_trace_on;

4891: hr_legislation.hrrunprc_trace_off;
4892:
4893: install_routes(p_phase); --install routes,entities,db items
4894:
4895: hr_legislation.hrrunprc_trace_on;
4896: hr_utility.trace('start install_functions: ' || to_char(p_phase));
4897: hr_legislation.hrrunprc_trace_off;
4898:
4899: install_functions(p_phase); --install functions, context usages etc

Line 4897: hr_legislation.hrrunprc_trace_off;

4893: install_routes(p_phase); --install routes,entities,db items
4894:
4895: hr_legislation.hrrunprc_trace_on;
4896: hr_utility.trace('start install_functions: ' || to_char(p_phase));
4897: hr_legislation.hrrunprc_trace_off;
4898:
4899: install_functions(p_phase); --install functions, context usages etc
4900:
4901: hr_legislation.hrrunprc_trace_on;

Line 4901: hr_legislation.hrrunprc_trace_on;

4897: hr_legislation.hrrunprc_trace_off;
4898:
4899: install_functions(p_phase); --install functions, context usages etc
4900:
4901: hr_legislation.hrrunprc_trace_on;
4902: hr_utility.trace('start install_qpreports: ' || to_char(p_phase));
4903: hr_legislation.hrrunprc_trace_off;
4904:
4905: install_qpreports(p_phase); --install quickpaint reports

Line 4903: hr_legislation.hrrunprc_trace_off;

4899: install_functions(p_phase); --install functions, context usages etc
4900:
4901: hr_legislation.hrrunprc_trace_on;
4902: hr_utility.trace('start install_qpreports: ' || to_char(p_phase));
4903: hr_legislation.hrrunprc_trace_off;
4904:
4905: install_qpreports(p_phase); --install quickpaint reports
4906:
4907: hr_legislation.hrrunprc_trace_on;

Line 4907: hr_legislation.hrrunprc_trace_on;

4903: hr_legislation.hrrunprc_trace_off;
4904:
4905: install_qpreports(p_phase); --install quickpaint reports
4906:
4907: hr_legislation.hrrunprc_trace_on;
4908: hr_utility.trace('start install_globals: ' || to_char(p_phase));
4909: hr_legislation.hrrunprc_trace_off;
4910:
4911: install_globals(p_phase); --install globals

Line 4909: hr_legislation.hrrunprc_trace_off;

4905: install_qpreports(p_phase); --install quickpaint reports
4906:
4907: hr_legislation.hrrunprc_trace_on;
4908: hr_utility.trace('start install_globals: ' || to_char(p_phase));
4909: hr_legislation.hrrunprc_trace_off;
4910:
4911: install_globals(p_phase); --install globals
4912:
4913: hr_legislation.hrrunprc_trace_on;

Line 4913: hr_legislation.hrrunprc_trace_on;

4909: hr_legislation.hrrunprc_trace_off;
4910:
4911: install_globals(p_phase); --install globals
4912:
4913: hr_legislation.hrrunprc_trace_on;
4914: hr_utility.trace('exit ff_data_dict.install: ' || to_char(p_phase));
4915: hr_legislation.hrrunprc_trace_off;
4916:
4917: END install;

Line 4915: hr_legislation.hrrunprc_trace_off;

4911: install_globals(p_phase); --install globals
4912:
4913: hr_legislation.hrrunprc_trace_on;
4914: hr_utility.trace('exit ff_data_dict.install: ' || to_char(p_phase));
4915: hr_legislation.hrrunprc_trace_off;
4916:
4917: END install;
4918:
4919: END ff_data_dict;