APPS.FF_DATA_DICT dependencies on HR_UTILITY

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 407: hr_utility.trace('context_id ' ||

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);
411: hr_utility.trace('context_level ' ||

Line 409: hr_utility.trace('context_name ' ||

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);
411: hr_utility.trace('context_level ' ||
412: to_char(stu_rec.context_level));
413: hr_utility.trace('datatype ' ||

Line 411: hr_utility.trace('context_level ' ||

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

Line 413: hr_utility.trace('datatype ' ||

409: hr_utility.trace('context_name ' ||
410: stu_rec.c_true_key);
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;

Line 647: hr_utility.trace('multiple ftype ' || stu_rec.c_true_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;
651:

Line 861: hr_utility.trace('ins ff_formula_types');

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 ' ||
865: stu_rec.c_true_key);

Line 862: hr_utility.trace('formula_type_id ' ||

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 ' ||
865: stu_rec.c_true_key);
866: hr_legislation.hrrunprc_trace_off;

Line 864: hr_utility.trace('formula_type_name ' ||

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 ' ||
865: stu_rec.c_true_key);
866: hr_legislation.hrrunprc_trace_off;
867: raise;
868: END;

Line 941: hr_utility.trace('ins ff_ftype_context_usages');

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 ' ||
945: to_char(usages.context_id));

Line 942: hr_utility.trace('formula_type_id ' ||

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 ' ||
945: to_char(usages.context_id));
946: hr_utility.trace('formula_type_name ' ||

Line 944: hr_utility.trace('context_id ' ||

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

Line 946: hr_utility.trace('formula_type_name ' ||

942: hr_utility.trace('formula_type_id ' ||
943: to_char(usages.formula_type_id));
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;

Line 1247: hr_utility.trace('sel ff_formulas_f TMR');

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 ' ||
1251: to_char(r_distinct.formula_type_id));

Line 1248: hr_utility.trace('formula_name ' ||

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 ' ||
1251: to_char(r_distinct.formula_type_id));
1252: hr_utility.trace(':lc: ' || ':' ||

Line 1250: hr_utility.trace('formula_type_id ' ||

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 ' ||
1251: to_char(r_distinct.formula_type_id));
1252: hr_utility.trace(':lc: ' || ':' ||
1253: r_distinct.legislation_code || ':');
1254: hr_legislation.hrrunprc_trace_off;

Line 1252: hr_utility.trace(':lc: ' || ':' ||

1248: hr_utility.trace('formula_name ' ||
1249: r_distinct.c_true_key);
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;

Line 1807: hr_utility.trace('ins ff_formulas_f');

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 ' ||
1811: to_char(r_each_row.formula_id));

Line 1808: hr_utility.trace('formula_name ' ||

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 ' ||
1811: to_char(r_each_row.formula_id));
1812: hr_utility.trace('formula_type_id ' ||

Line 1810: hr_utility.trace('formula_id ' ||

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 ' ||
1811: to_char(r_each_row.formula_id));
1812: hr_utility.trace('formula_type_id ' ||
1813: to_char(r_each_row.formula_type_id));
1814: hr_utility.trace(':lc: ' || ':' ||

Line 1812: hr_utility.trace('formula_type_id ' ||

1808: hr_utility.trace('formula_name ' ||
1809: r_each_row.formula_name);
1810: hr_utility.trace('formula_id ' ||
1811: to_char(r_each_row.formula_id));
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;

Line 1814: hr_utility.trace(':lc: ' || ':' ||

1810: hr_utility.trace('formula_id ' ||
1811: to_char(r_each_row.formula_id));
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;

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 2224: hr_utility.trace('route_name ' ||

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

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

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 ' ||
2301: to_char(l_new_surrogate_key));

Line 2298: hr_utility.trace('parameter_name ' ||

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 ' ||
2301: to_char(l_new_surrogate_key));
2302: hr_utility.trace('route_name ' ||

Line 2300: hr_utility.trace('route_id ' ||

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 ' ||
2301: to_char(l_new_surrogate_key));
2302: hr_utility.trace('route_name ' ||
2303: stu_rec.c_true_key);
2304: hr_utility.trace('sequence_no ' ||

Line 2302: hr_utility.trace('route_name ' ||

2298: hr_utility.trace('parameter_name ' ||
2299: delivered_params.parameter_name);
2300: hr_utility.trace('route_id ' ||
2301: to_char(l_new_surrogate_key));
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;

Line 2304: hr_utility.trace('sequence_no ' ||

2300: hr_utility.trace('route_id ' ||
2301: to_char(l_new_surrogate_key));
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:

Line 2341: hr_utility.trace('sel ff_user_entities TMR');

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 ' ||
2345: to_char(l_new_surrogate_key));

Line 2342: hr_utility.trace('user_entity_name ' ||

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 ' ||
2345: to_char(l_new_surrogate_key));
2346: hr_utility.trace('route_name ' ||

Line 2344: hr_utility.trace('route_id ' ||

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 ' ||
2345: to_char(l_new_surrogate_key));
2346: hr_utility.trace('route_name ' ||
2347: stu_rec.c_true_key);
2348: hr_utility.trace(':lc: ' || ':' ||

Line 2346: hr_utility.trace('route_name ' ||

2342: hr_utility.trace('user_entity_name ' ||
2343: delivered_entities.user_entity_name);
2344: hr_utility.trace('route_id ' ||
2345: to_char(l_new_surrogate_key));
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;

Line 2348: hr_utility.trace(':lc: ' || ':' ||

2344: hr_utility.trace('route_id ' ||
2345: to_char(l_new_surrogate_key));
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;

Line 2523: -- hr_utility.trace('route diff: ' || to_char(l_new_surrogate_key) || ' '

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:
2527: return TRUE; --delivered route is defferent

Line 2533: -- hr_utility.trace('new route: ' || to_char(l_new_surrogate_key) || ' '

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;
2537:

Line 2677: -- hr_utility.trace('ue chg: ' || to_char(v_user_entity_id) || ' '

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;
2681: end;

Line 2778: hr_utility.trace('ins ff_user_entities');

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 ' ||
2782: to_char(all_user_entities.user_entity_id));

Line 2779: hr_utility.trace('user_entity_name ' ||

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 ' ||
2782: to_char(all_user_entities.user_entity_id));
2783: hr_utility.trace('route_id ' ||

Line 2781: hr_utility.trace('user_entity_id ' ||

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 ' ||
2782: to_char(all_user_entities.user_entity_id));
2783: hr_utility.trace('route_id ' ||
2784: to_char(all_user_entities.route_id));
2785: hr_utility.trace('route_name ' ||

Line 2783: hr_utility.trace('route_id ' ||

2779: hr_utility.trace('user_entity_name ' ||
2780: all_user_entities.user_entity_name);
2781: hr_utility.trace('user_entity_id ' ||
2782: to_char(all_user_entities.user_entity_id));
2783: hr_utility.trace('route_id ' ||
2784: to_char(all_user_entities.route_id));
2785: hr_utility.trace('route_name ' ||
2786: stu_rec.c_true_key);
2787: hr_utility.trace('creator_id ' ||

Line 2785: hr_utility.trace('route_name ' ||

2781: hr_utility.trace('user_entity_id ' ||
2782: to_char(all_user_entities.user_entity_id));
2783: hr_utility.trace('route_id ' ||
2784: to_char(all_user_entities.route_id));
2785: hr_utility.trace('route_name ' ||
2786: stu_rec.c_true_key);
2787: hr_utility.trace('creator_id ' ||
2788: to_char(all_user_entities.creator_id));
2789: hr_utility.trace('creator_type ' ||

Line 2787: hr_utility.trace('creator_id ' ||

2783: hr_utility.trace('route_id ' ||
2784: to_char(all_user_entities.route_id));
2785: hr_utility.trace('route_name ' ||
2786: stu_rec.c_true_key);
2787: hr_utility.trace('creator_id ' ||
2788: to_char(all_user_entities.creator_id));
2789: hr_utility.trace('creator_type ' ||
2790: all_user_entities.creator_type);
2791: hr_utility.trace(':lc: ' || ':' ||

Line 2789: hr_utility.trace('creator_type ' ||

2785: hr_utility.trace('route_name ' ||
2786: stu_rec.c_true_key);
2787: hr_utility.trace('creator_id ' ||
2788: to_char(all_user_entities.creator_id));
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;

Line 2791: hr_utility.trace(':lc: ' || ':' ||

2787: hr_utility.trace('creator_id ' ||
2788: to_char(all_user_entities.creator_id));
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;

Line 2846: hr_utility.trace('ins ff_database_items');

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 ' ||
2850: to_char(all_db_items.user_entity_id));

Line 2847: hr_utility.trace('dbi user_name ' ||

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 ' ||
2850: to_char(all_db_items.user_entity_id));
2851: hr_utility.trace('user_entity_name ' ||

Line 2849: hr_utility.trace('user_entity_id ' ||

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 ' ||
2850: to_char(all_db_items.user_entity_id));
2851: hr_utility.trace('user_entity_name ' ||
2852: all_user_entities.user_entity_name);
2853: hr_utility.trace('route_id ' ||

Line 2851: hr_utility.trace('user_entity_name ' ||

2847: hr_utility.trace('dbi user_name ' ||
2848: all_db_items.user_name);
2849: hr_utility.trace('user_entity_id ' ||
2850: to_char(all_db_items.user_entity_id));
2851: hr_utility.trace('user_entity_name ' ||
2852: all_user_entities.user_entity_name);
2853: hr_utility.trace('route_id ' ||
2854: to_char(all_user_entities.route_id));
2855: hr_utility.trace('route_name ' ||

Line 2853: hr_utility.trace('route_id ' ||

2849: hr_utility.trace('user_entity_id ' ||
2850: to_char(all_db_items.user_entity_id));
2851: hr_utility.trace('user_entity_name ' ||
2852: all_user_entities.user_entity_name);
2853: hr_utility.trace('route_id ' ||
2854: to_char(all_user_entities.route_id));
2855: hr_utility.trace('route_name ' ||
2856: stu_rec.c_true_key);
2857: hr_utility.trace('creator_id ' ||

Line 2855: hr_utility.trace('route_name ' ||

2851: hr_utility.trace('user_entity_name ' ||
2852: all_user_entities.user_entity_name);
2853: hr_utility.trace('route_id ' ||
2854: to_char(all_user_entities.route_id));
2855: hr_utility.trace('route_name ' ||
2856: stu_rec.c_true_key);
2857: hr_utility.trace('creator_id ' ||
2858: to_char(all_user_entities.creator_id));
2859: hr_utility.trace('creator_type ' ||

Line 2857: hr_utility.trace('creator_id ' ||

2853: hr_utility.trace('route_id ' ||
2854: to_char(all_user_entities.route_id));
2855: hr_utility.trace('route_name ' ||
2856: stu_rec.c_true_key);
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;

Line 2859: hr_utility.trace('creator_type ' ||

2855: hr_utility.trace('route_name ' ||
2856: stu_rec.c_true_key);
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;

Line 2910: hr_utility.trace('ins ff_route_parameter_values');

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 ' ||
2914: to_char(pvalues.route_parameter_id));

Line 2911: hr_utility.trace('value ' ||

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 ' ||
2914: to_char(pvalues.route_parameter_id));
2915: hr_utility.trace('user_entity_id ' ||

Line 2913: hr_utility.trace('route_parameter_id ' ||

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 ' ||
2914: to_char(pvalues.route_parameter_id));
2915: hr_utility.trace('user_entity_id ' ||
2916: to_char(pvalues.user_entity_id));
2917: hr_utility.trace('user_entity_name ' ||

Line 2915: hr_utility.trace('user_entity_id ' ||

2911: hr_utility.trace('value ' ||
2912: pvalues.value);
2913: hr_utility.trace('route_parameter_id ' ||
2914: to_char(pvalues.route_parameter_id));
2915: hr_utility.trace('user_entity_id ' ||
2916: to_char(pvalues.user_entity_id));
2917: hr_utility.trace('user_entity_name ' ||
2918: all_user_entities.user_entity_name);
2919: hr_utility.trace('route_id ' ||

Line 2917: hr_utility.trace('user_entity_name ' ||

2913: hr_utility.trace('route_parameter_id ' ||
2914: to_char(pvalues.route_parameter_id));
2915: hr_utility.trace('user_entity_id ' ||
2916: to_char(pvalues.user_entity_id));
2917: hr_utility.trace('user_entity_name ' ||
2918: all_user_entities.user_entity_name);
2919: hr_utility.trace('route_id ' ||
2920: to_char(all_user_entities.route_id));
2921: hr_utility.trace('route_name ' ||

Line 2919: hr_utility.trace('route_id ' ||

2915: hr_utility.trace('user_entity_id ' ||
2916: to_char(pvalues.user_entity_id));
2917: hr_utility.trace('user_entity_name ' ||
2918: all_user_entities.user_entity_name);
2919: hr_utility.trace('route_id ' ||
2920: to_char(all_user_entities.route_id));
2921: hr_utility.trace('route_name ' ||
2922: stu_rec.c_true_key);
2923: hr_utility.trace('creator_id ' ||

Line 2921: hr_utility.trace('route_name ' ||

2917: hr_utility.trace('user_entity_name ' ||
2918: all_user_entities.user_entity_name);
2919: hr_utility.trace('route_id ' ||
2920: to_char(all_user_entities.route_id));
2921: hr_utility.trace('route_name ' ||
2922: stu_rec.c_true_key);
2923: hr_utility.trace('creator_id ' ||
2924: to_char(all_user_entities.creator_id));
2925: hr_utility.trace('creator_type ' ||

Line 2923: hr_utility.trace('creator_id ' ||

2919: hr_utility.trace('route_id ' ||
2920: to_char(all_user_entities.route_id));
2921: hr_utility.trace('route_name ' ||
2922: stu_rec.c_true_key);
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;

Line 2925: hr_utility.trace('creator_type ' ||

2921: hr_utility.trace('route_name ' ||
2922: stu_rec.c_true_key);
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;

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

Line 3029: hr_utility.trace('route_name ' ||

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));
3033: hr_legislation.hrrunprc_trace_off;

Line 3031: hr_utility.trace('route_id ' ||

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

Line 3134: hr_utility.trace('ins ff_route_context_usages');

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 ' ||
3138: stu_rec.c_true_key);

Line 3135: hr_utility.trace('route_id ' ||

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 ' ||
3138: stu_rec.c_true_key);
3139: hr_utility.trace('context_id ' ||

Line 3137: hr_utility.trace('route_name ' ||

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 ' ||
3138: stu_rec.c_true_key);
3139: hr_utility.trace('context_id ' ||
3140: to_char(context_usages.context_id));
3141: hr_utility.trace('sequence_no ' ||

Line 3139: hr_utility.trace('context_id ' ||

3135: hr_utility.trace('route_id ' ||
3136: to_char(context_usages.route_id));
3137: hr_utility.trace('route_name ' ||
3138: stu_rec.c_true_key);
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;

Line 3141: hr_utility.trace('sequence_no ' ||

3137: hr_utility.trace('route_name ' ||
3138: stu_rec.c_true_key);
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;

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

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 ' ||
3195: to_char(r_hrsrp.SEQUENCE_NO));

Line 3192: hr_utility.trace('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 ' ||
3195: to_char(r_hrsrp.SEQUENCE_NO));
3196: hr_utility.trace('ROUTE_ID ' ||

Line 3194: hr_utility.trace('SEQUENCE_NO ' ||

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 ' ||
3195: to_char(r_hrsrp.SEQUENCE_NO));
3196: hr_utility.trace('ROUTE_ID ' ||
3197: to_char(stu_rec.c_surrogate_key));
3198: hr_utility.trace('route_name ' ||

Line 3196: hr_utility.trace('ROUTE_ID ' ||

3192: hr_utility.trace('PARAMETER_NAME ' ||
3193: r_hrsrp.PARAMETER_NAME);
3194: hr_utility.trace('SEQUENCE_NO ' ||
3195: to_char(r_hrsrp.SEQUENCE_NO));
3196: hr_utility.trace('ROUTE_ID ' ||
3197: to_char(stu_rec.c_surrogate_key));
3198: hr_utility.trace('route_name ' ||
3199: stu_rec.c_true_key);
3200: hr_utility.trace('ROUTE_PARAMETER_ID ' ||

Line 3198: hr_utility.trace('route_name ' ||

3194: hr_utility.trace('SEQUENCE_NO ' ||
3195: to_char(r_hrsrp.SEQUENCE_NO));
3196: hr_utility.trace('ROUTE_ID ' ||
3197: to_char(stu_rec.c_surrogate_key));
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;

Line 3200: hr_utility.trace('ROUTE_PARAMETER_ID ' ||

3196: hr_utility.trace('ROUTE_ID ' ||
3197: to_char(stu_rec.c_surrogate_key));
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;

Line 3538: hr_utility.trace('ins ff_functions');

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 ' ||
3542: to_char(l_new_surrogate_key));

Line 3539: hr_utility.trace('function name ' ||

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 ' ||
3542: to_char(l_new_surrogate_key));
3543: hr_utility.trace(':lc: ' || ':' ||

Line 3541: hr_utility.trace('function_id ' ||

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 ' ||
3542: to_char(l_new_surrogate_key));
3543: hr_utility.trace(':lc: ' || ':' ||
3544: each_func.legislation_code || ':');
3545: hr_legislation.hrrunprc_trace_off;

Line 3543: hr_utility.trace(':lc: ' || ':' ||

3539: hr_utility.trace('function name ' ||
3540: each_func.name);
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;

Line 3570: hr_utility.trace('ins ff_function_parameters');

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 ' ||
3574: each_func.name);

Line 3571: hr_utility.trace('function_id ' ||

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 ' ||
3574: each_func.name);
3575: hr_utility.trace(':lc: ' ||

Line 3573: hr_utility.trace('function name ' ||

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 ' ||
3574: each_func.name);
3575: hr_utility.trace(':lc: ' ||
3576: each_func.legislation_code || ':');
3577: hr_legislation.hrrunprc_trace_off;

Line 3575: hr_utility.trace(':lc: ' ||

3571: hr_utility.trace('function_id ' ||
3572: to_char(each_func.function_id));
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;

Line 3611: hr_utility.trace('ins ff_function_context_usages');

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 ' ||
3615: each_func.name);

Line 3612: hr_utility.trace('function_id ' ||

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 ' ||
3615: each_func.name);
3616: hr_utility.trace(':lc: ' ||

Line 3614: hr_utility.trace('function name ' ||

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 ' ||
3615: each_func.name);
3616: hr_utility.trace(':lc: ' ||
3617: each_func.legislation_code || ':');
3618: hr_utility.trace('sequence_number ' ||

Line 3616: hr_utility.trace(':lc: ' ||

3612: hr_utility.trace('function_id ' ||
3613: to_char(l_new_surrogate_key));
3614: hr_utility.trace('function name ' ||
3615: each_func.name);
3616: hr_utility.trace(':lc: ' ||
3617: each_func.legislation_code || ':');
3618: hr_utility.trace('sequence_number ' ||
3619: to_char(child_usages.sequence_number));
3620: hr_utility.trace('context_id ' ||

Line 3618: hr_utility.trace('sequence_number ' ||

3614: hr_utility.trace('function name ' ||
3615: each_func.name);
3616: hr_utility.trace(':lc: ' ||
3617: each_func.legislation_code || ':');
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;

Line 3620: hr_utility.trace('context_id ' ||

3616: hr_utility.trace(':lc: ' ||
3617: each_func.legislation_code || ':');
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:

Line 4455: hr_utility.trace('sel ff_globals_f TMR');

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: ' || ':' ||
4459: r_distinct.legislation_code || ':');

Line 4456: hr_utility.trace('global_name ' ||

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: ' || ':' ||
4459: r_distinct.legislation_code || ':');
4460: hr_legislation.hrrunprc_trace_off;

Line 4458: hr_utility.trace(':lc: ' || ':' ||

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: ' || ':' ||
4459: r_distinct.legislation_code || ':');
4460: hr_legislation.hrrunprc_trace_off;
4461: raise;
4462: END;

Line 4814: hr_utility.trace('ins ff_globals_f');

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 ' ||
4818: to_char(r_each_row.GLOBAL_ID));

Line 4815: hr_utility.trace('GLOBAL_NAME ' ||

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 ' ||
4818: to_char(r_each_row.GLOBAL_ID));
4819: hr_utility.trace('GLOBAL_VALUE ' ||

Line 4817: hr_utility.trace('GLOBAL_ID ' ||

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 ' ||
4818: to_char(r_each_row.GLOBAL_ID));
4819: hr_utility.trace('GLOBAL_VALUE ' ||
4820: r_each_row.GLOBAL_VALUE);
4821: hr_utility.trace(':lc: ' || ':' ||

Line 4819: hr_utility.trace('GLOBAL_VALUE ' ||

4815: hr_utility.trace('GLOBAL_NAME ' ||
4816: r_each_row.GLOBAL_NAME);
4817: hr_utility.trace('GLOBAL_ID ' ||
4818: to_char(r_each_row.GLOBAL_ID));
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;

Line 4821: hr_utility.trace(':lc: ' || ':' ||

4817: hr_utility.trace('GLOBAL_ID ' ||
4818: to_char(r_each_row.GLOBAL_ID));
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;

Line 4856: hr_utility.trace('start ff_data_dict.install: ' || to_char(p_phase));

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
4860: return;

Line 4873: hr_utility.trace('start install_ffc: ' || to_char(p_phase));

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

Line 4878: hr_utility.trace('start install_fft: ' || 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
4882:

Line 4884: hr_utility.trace('start install_formulas: ' || to_char(p_phase));

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
4888:

Line 4890: hr_utility.trace('start install_routes: ' || to_char(p_phase));

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
4894:

Line 4896: hr_utility.trace('start install_functions: ' || to_char(p_phase));

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
4900:

Line 4902: hr_utility.trace('start install_qpreports: ' || to_char(p_phase));

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
4906:

Line 4908: hr_utility.trace('start install_globals: ' || to_char(p_phase));

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
4912:

Line 4914: hr_utility.trace('exit ff_data_dict.install: ' || to_char(p_phase));

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;
4918: