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 1821: hr_utility.trace('ins ff_formulas_f');

1817: ,r_each_row.creation_date
1818: );
1819: EXCEPTION WHEN OTHERS THEN
1820: hr_legislation.hrrunprc_trace_on;
1821: hr_utility.trace('ins ff_formulas_f');
1822: hr_utility.trace('formula_name ' ||
1823: r_each_row.formula_name);
1824: hr_utility.trace('formula_id ' ||
1825: to_char(r_each_row.formula_id));

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

1818: );
1819: EXCEPTION WHEN OTHERS THEN
1820: hr_legislation.hrrunprc_trace_on;
1821: hr_utility.trace('ins ff_formulas_f');
1822: hr_utility.trace('formula_name ' ||
1823: r_each_row.formula_name);
1824: hr_utility.trace('formula_id ' ||
1825: to_char(r_each_row.formula_id));
1826: hr_utility.trace('formula_type_id ' ||

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

1820: hr_legislation.hrrunprc_trace_on;
1821: hr_utility.trace('ins ff_formulas_f');
1822: hr_utility.trace('formula_name ' ||
1823: r_each_row.formula_name);
1824: hr_utility.trace('formula_id ' ||
1825: to_char(r_each_row.formula_id));
1826: hr_utility.trace('formula_type_id ' ||
1827: to_char(r_each_row.formula_type_id));
1828: hr_utility.trace(':lc: ' || ':' ||

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

1822: hr_utility.trace('formula_name ' ||
1823: r_each_row.formula_name);
1824: hr_utility.trace('formula_id ' ||
1825: to_char(r_each_row.formula_id));
1826: hr_utility.trace('formula_type_id ' ||
1827: to_char(r_each_row.formula_type_id));
1828: hr_utility.trace(':lc: ' || ':' ||
1829: r_each_row.legislation_code || ':');
1830: hr_legislation.hrrunprc_trace_off;

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

1824: hr_utility.trace('formula_id ' ||
1825: to_char(r_each_row.formula_id));
1826: hr_utility.trace('formula_type_id ' ||
1827: to_char(r_each_row.formula_type_id));
1828: hr_utility.trace(':lc: ' || ':' ||
1829: r_each_row.legislation_code || ':');
1830: hr_legislation.hrrunprc_trace_off;
1831: raise;
1832: END;

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

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

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

2309:
2310: WHEN TOO_MANY_ROWS THEN
2311:
2312: hr_legislation.hrrunprc_trace_on;
2313: hr_utility.trace('sel ff_route_parameters TMR');
2314: hr_utility.trace('parameter_name ' ||
2315: delivered_params.parameter_name);
2316: hr_utility.trace('route_id ' ||
2317: to_char(l_new_surrogate_key));

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

2310: WHEN TOO_MANY_ROWS THEN
2311:
2312: hr_legislation.hrrunprc_trace_on;
2313: hr_utility.trace('sel ff_route_parameters TMR');
2314: hr_utility.trace('parameter_name ' ||
2315: delivered_params.parameter_name);
2316: hr_utility.trace('route_id ' ||
2317: to_char(l_new_surrogate_key));
2318: hr_utility.trace('route_name ' ||

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

2312: hr_legislation.hrrunprc_trace_on;
2313: hr_utility.trace('sel ff_route_parameters TMR');
2314: hr_utility.trace('parameter_name ' ||
2315: delivered_params.parameter_name);
2316: hr_utility.trace('route_id ' ||
2317: to_char(l_new_surrogate_key));
2318: hr_utility.trace('route_name ' ||
2319: stu_rec.c_true_key);
2320: hr_utility.trace('sequence_no ' ||

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

2314: hr_utility.trace('parameter_name ' ||
2315: delivered_params.parameter_name);
2316: hr_utility.trace('route_id ' ||
2317: to_char(l_new_surrogate_key));
2318: hr_utility.trace('route_name ' ||
2319: stu_rec.c_true_key);
2320: hr_utility.trace('sequence_no ' ||
2321: to_char(delivered_params.sequence_no));
2322: hr_legislation.hrrunprc_trace_off;

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

2316: hr_utility.trace('route_id ' ||
2317: to_char(l_new_surrogate_key));
2318: hr_utility.trace('route_name ' ||
2319: stu_rec.c_true_key);
2320: hr_utility.trace('sequence_no ' ||
2321: to_char(delivered_params.sequence_no));
2322: hr_legislation.hrrunprc_trace_off;
2323: raise;
2324:

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

2363: from dual;
2364:
2365: WHEN TOO_MANY_ROWS THEN
2366: hr_legislation.hrrunprc_trace_on;
2367: hr_utility.trace('sel ff_user_entities TMR');
2368: hr_utility.trace('user_entity_name ' ||
2369: delivered_entities.user_entity_name);
2370: hr_utility.trace('route_id ' ||
2371: to_char(l_new_surrogate_key));

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

2364:
2365: WHEN TOO_MANY_ROWS THEN
2366: hr_legislation.hrrunprc_trace_on;
2367: hr_utility.trace('sel ff_user_entities TMR');
2368: hr_utility.trace('user_entity_name ' ||
2369: delivered_entities.user_entity_name);
2370: hr_utility.trace('route_id ' ||
2371: to_char(l_new_surrogate_key));
2372: hr_utility.trace('route_name ' ||

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

2366: hr_legislation.hrrunprc_trace_on;
2367: hr_utility.trace('sel ff_user_entities TMR');
2368: hr_utility.trace('user_entity_name ' ||
2369: delivered_entities.user_entity_name);
2370: hr_utility.trace('route_id ' ||
2371: to_char(l_new_surrogate_key));
2372: hr_utility.trace('route_name ' ||
2373: stu_rec.c_true_key);
2374: hr_utility.trace(':lc: ' || ':' ||

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

2368: hr_utility.trace('user_entity_name ' ||
2369: delivered_entities.user_entity_name);
2370: hr_utility.trace('route_id ' ||
2371: to_char(l_new_surrogate_key));
2372: hr_utility.trace('route_name ' ||
2373: stu_rec.c_true_key);
2374: hr_utility.trace(':lc: ' || ':' ||
2375: delivered_entities.legislation_code || ':');
2376: hr_legislation.hrrunprc_trace_off;

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

2370: hr_utility.trace('route_id ' ||
2371: to_char(l_new_surrogate_key));
2372: hr_utility.trace('route_name ' ||
2373: stu_rec.c_true_key);
2374: hr_utility.trace(':lc: ' || ':' ||
2375: delivered_entities.legislation_code || ':');
2376: hr_legislation.hrrunprc_trace_off;
2377: raise;
2378: END;

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

2560: END IF;
2561:
2562: p_new_route := FALSE;
2563: hr_legislation.hrrunprc_trace_on;
2564: hr_utility.trace('route diff: ' || to_char(l_new_surrogate_key) || ' '
2565: || stu_rec.c_true_key);
2566: hr_legislation.hrrunprc_trace_off;
2567:
2568: return TRUE; --delivered route is defferent

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

2570: EXCEPTION WHEN NO_DATA_FOUND THEN
2571: -- The route is not installed
2572: p_new_route := TRUE;
2573: hr_legislation.hrrunprc_trace_on;
2574: hr_utility.trace('new route: ' || to_char(l_new_surrogate_key) || ' '
2575: || stu_rec.c_true_key);
2576: hr_legislation.hrrunprc_trace_off;
2577: return TRUE;
2578:

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

2714: into ue_name2
2715: from hr_s_user_entities
2716: where user_entity_id = v_user_entity_id;
2717: -- hr_legislation.hrrunprc_trace_on;
2718: -- hr_utility.trace('ue chg: ' || to_char(v_user_entity_id) || ' '
2719: -- || ue_name1 || ':' || ue_name2);
2720: -- hr_legislation.hrrunprc_trace_off;
2721: exception when others then null;
2722: end;

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

2815: );
2816:
2817: EXCEPTION WHEN OTHERS THEN
2818: hr_legislation.hrrunprc_trace_on;
2819: hr_utility.trace('ins ff_user_entities');
2820: hr_utility.trace('user_entity_name ' ||
2821: all_user_entities.user_entity_name);
2822: hr_utility.trace('user_entity_id ' ||
2823: to_char(all_user_entities.user_entity_id));

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

2816:
2817: EXCEPTION WHEN OTHERS THEN
2818: hr_legislation.hrrunprc_trace_on;
2819: hr_utility.trace('ins ff_user_entities');
2820: hr_utility.trace('user_entity_name ' ||
2821: all_user_entities.user_entity_name);
2822: hr_utility.trace('user_entity_id ' ||
2823: to_char(all_user_entities.user_entity_id));
2824: hr_utility.trace('route_id ' ||

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

2818: hr_legislation.hrrunprc_trace_on;
2819: hr_utility.trace('ins ff_user_entities');
2820: hr_utility.trace('user_entity_name ' ||
2821: all_user_entities.user_entity_name);
2822: hr_utility.trace('user_entity_id ' ||
2823: to_char(all_user_entities.user_entity_id));
2824: hr_utility.trace('route_id ' ||
2825: to_char(all_user_entities.route_id));
2826: hr_utility.trace('route_name ' ||

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

2820: hr_utility.trace('user_entity_name ' ||
2821: all_user_entities.user_entity_name);
2822: hr_utility.trace('user_entity_id ' ||
2823: to_char(all_user_entities.user_entity_id));
2824: hr_utility.trace('route_id ' ||
2825: to_char(all_user_entities.route_id));
2826: hr_utility.trace('route_name ' ||
2827: stu_rec.c_true_key);
2828: hr_utility.trace('creator_id ' ||

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

2822: hr_utility.trace('user_entity_id ' ||
2823: to_char(all_user_entities.user_entity_id));
2824: hr_utility.trace('route_id ' ||
2825: to_char(all_user_entities.route_id));
2826: hr_utility.trace('route_name ' ||
2827: stu_rec.c_true_key);
2828: hr_utility.trace('creator_id ' ||
2829: to_char(all_user_entities.creator_id));
2830: hr_utility.trace('creator_type ' ||

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

2824: hr_utility.trace('route_id ' ||
2825: to_char(all_user_entities.route_id));
2826: hr_utility.trace('route_name ' ||
2827: stu_rec.c_true_key);
2828: hr_utility.trace('creator_id ' ||
2829: to_char(all_user_entities.creator_id));
2830: hr_utility.trace('creator_type ' ||
2831: all_user_entities.creator_type);
2832: hr_utility.trace(':lc: ' || ':' ||

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

2826: hr_utility.trace('route_name ' ||
2827: stu_rec.c_true_key);
2828: hr_utility.trace('creator_id ' ||
2829: to_char(all_user_entities.creator_id));
2830: hr_utility.trace('creator_type ' ||
2831: all_user_entities.creator_type);
2832: hr_utility.trace(':lc: ' || ':' ||
2833: all_user_entities.legislation_code || ':');
2834: hr_legislation.hrrunprc_trace_off;

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

2828: hr_utility.trace('creator_id ' ||
2829: to_char(all_user_entities.creator_id));
2830: hr_utility.trace('creator_type ' ||
2831: all_user_entities.creator_type);
2832: hr_utility.trace(':lc: ' || ':' ||
2833: all_user_entities.legislation_code || ':');
2834: hr_legislation.hrrunprc_trace_off;
2835: raise;
2836: END;

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

2883: ,all_db_items.creation_date
2884: );
2885: EXCEPTION WHEN OTHERS THEN
2886: hr_legislation.hrrunprc_trace_on;
2887: hr_utility.trace('ins ff_database_items');
2888: hr_utility.trace('dbi user_name ' ||
2889: all_db_items.user_name);
2890: hr_utility.trace('user_entity_id ' ||
2891: to_char(all_db_items.user_entity_id));

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

2884: );
2885: EXCEPTION WHEN OTHERS THEN
2886: hr_legislation.hrrunprc_trace_on;
2887: hr_utility.trace('ins ff_database_items');
2888: hr_utility.trace('dbi user_name ' ||
2889: all_db_items.user_name);
2890: hr_utility.trace('user_entity_id ' ||
2891: to_char(all_db_items.user_entity_id));
2892: hr_utility.trace('user_entity_name ' ||

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

2886: hr_legislation.hrrunprc_trace_on;
2887: hr_utility.trace('ins ff_database_items');
2888: hr_utility.trace('dbi user_name ' ||
2889: all_db_items.user_name);
2890: hr_utility.trace('user_entity_id ' ||
2891: to_char(all_db_items.user_entity_id));
2892: hr_utility.trace('user_entity_name ' ||
2893: all_user_entities.user_entity_name);
2894: hr_utility.trace('route_id ' ||

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

2888: hr_utility.trace('dbi user_name ' ||
2889: all_db_items.user_name);
2890: hr_utility.trace('user_entity_id ' ||
2891: to_char(all_db_items.user_entity_id));
2892: hr_utility.trace('user_entity_name ' ||
2893: all_user_entities.user_entity_name);
2894: hr_utility.trace('route_id ' ||
2895: to_char(all_user_entities.route_id));
2896: hr_utility.trace('route_name ' ||

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

2890: hr_utility.trace('user_entity_id ' ||
2891: to_char(all_db_items.user_entity_id));
2892: hr_utility.trace('user_entity_name ' ||
2893: all_user_entities.user_entity_name);
2894: hr_utility.trace('route_id ' ||
2895: to_char(all_user_entities.route_id));
2896: hr_utility.trace('route_name ' ||
2897: stu_rec.c_true_key);
2898: hr_utility.trace('creator_id ' ||

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

2892: hr_utility.trace('user_entity_name ' ||
2893: all_user_entities.user_entity_name);
2894: hr_utility.trace('route_id ' ||
2895: to_char(all_user_entities.route_id));
2896: hr_utility.trace('route_name ' ||
2897: stu_rec.c_true_key);
2898: hr_utility.trace('creator_id ' ||
2899: to_char(all_user_entities.creator_id));
2900: hr_utility.trace('creator_type ' ||

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

2894: hr_utility.trace('route_id ' ||
2895: to_char(all_user_entities.route_id));
2896: hr_utility.trace('route_name ' ||
2897: stu_rec.c_true_key);
2898: hr_utility.trace('creator_id ' ||
2899: to_char(all_user_entities.creator_id));
2900: hr_utility.trace('creator_type ' ||
2901: all_user_entities.creator_type);
2902: hr_legislation.hrrunprc_trace_off;

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

2896: hr_utility.trace('route_name ' ||
2897: stu_rec.c_true_key);
2898: hr_utility.trace('creator_id ' ||
2899: to_char(all_user_entities.creator_id));
2900: hr_utility.trace('creator_type ' ||
2901: all_user_entities.creator_type);
2902: hr_legislation.hrrunprc_trace_off;
2903: raise;
2904: END;

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

2947: ,pvalues.creation_date
2948: );
2949: EXCEPTION WHEN OTHERS THEN
2950: hr_legislation.hrrunprc_trace_on;
2951: hr_utility.trace('ins ff_route_parameter_values');
2952: hr_utility.trace('value ' ||
2953: pvalues.value);
2954: hr_utility.trace('route_parameter_id ' ||
2955: to_char(pvalues.route_parameter_id));

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

2948: );
2949: EXCEPTION WHEN OTHERS THEN
2950: hr_legislation.hrrunprc_trace_on;
2951: hr_utility.trace('ins ff_route_parameter_values');
2952: hr_utility.trace('value ' ||
2953: pvalues.value);
2954: hr_utility.trace('route_parameter_id ' ||
2955: to_char(pvalues.route_parameter_id));
2956: hr_utility.trace('user_entity_id ' ||

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

2950: hr_legislation.hrrunprc_trace_on;
2951: hr_utility.trace('ins ff_route_parameter_values');
2952: hr_utility.trace('value ' ||
2953: pvalues.value);
2954: hr_utility.trace('route_parameter_id ' ||
2955: to_char(pvalues.route_parameter_id));
2956: hr_utility.trace('user_entity_id ' ||
2957: to_char(pvalues.user_entity_id));
2958: hr_utility.trace('user_entity_name ' ||

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

2952: hr_utility.trace('value ' ||
2953: pvalues.value);
2954: hr_utility.trace('route_parameter_id ' ||
2955: to_char(pvalues.route_parameter_id));
2956: hr_utility.trace('user_entity_id ' ||
2957: to_char(pvalues.user_entity_id));
2958: hr_utility.trace('user_entity_name ' ||
2959: all_user_entities.user_entity_name);
2960: hr_utility.trace('route_id ' ||

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

2954: hr_utility.trace('route_parameter_id ' ||
2955: to_char(pvalues.route_parameter_id));
2956: hr_utility.trace('user_entity_id ' ||
2957: to_char(pvalues.user_entity_id));
2958: hr_utility.trace('user_entity_name ' ||
2959: all_user_entities.user_entity_name);
2960: hr_utility.trace('route_id ' ||
2961: to_char(all_user_entities.route_id));
2962: hr_utility.trace('route_name ' ||

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

2956: hr_utility.trace('user_entity_id ' ||
2957: to_char(pvalues.user_entity_id));
2958: hr_utility.trace('user_entity_name ' ||
2959: all_user_entities.user_entity_name);
2960: hr_utility.trace('route_id ' ||
2961: to_char(all_user_entities.route_id));
2962: hr_utility.trace('route_name ' ||
2963: stu_rec.c_true_key);
2964: hr_utility.trace('creator_id ' ||

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

2958: hr_utility.trace('user_entity_name ' ||
2959: all_user_entities.user_entity_name);
2960: hr_utility.trace('route_id ' ||
2961: to_char(all_user_entities.route_id));
2962: hr_utility.trace('route_name ' ||
2963: stu_rec.c_true_key);
2964: hr_utility.trace('creator_id ' ||
2965: to_char(all_user_entities.creator_id));
2966: hr_utility.trace('creator_type ' ||

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

2960: hr_utility.trace('route_id ' ||
2961: to_char(all_user_entities.route_id));
2962: hr_utility.trace('route_name ' ||
2963: stu_rec.c_true_key);
2964: hr_utility.trace('creator_id ' ||
2965: to_char(all_user_entities.creator_id));
2966: hr_utility.trace('creator_type ' ||
2967: all_user_entities.creator_type);
2968: hr_legislation.hrrunprc_trace_off;

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

2962: hr_utility.trace('route_name ' ||
2963: stu_rec.c_true_key);
2964: hr_utility.trace('creator_id ' ||
2965: to_char(all_user_entities.creator_id));
2966: hr_utility.trace('creator_type ' ||
2967: all_user_entities.creator_type);
2968: hr_legislation.hrrunprc_trace_off;
2969: raise;
2970: END;

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

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

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

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

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));
3073: hr_legislation.hrrunprc_trace_off;
3074: raise;
3075: END;

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

3170: ,context_usages.sequence_no
3171: );
3172: EXCEPTION WHEN OTHERS THEN
3173: hr_legislation.hrrunprc_trace_on;
3174: hr_utility.trace('ins ff_route_context_usages');
3175: hr_utility.trace('route_id ' ||
3176: to_char(context_usages.route_id));
3177: hr_utility.trace('route_name ' ||
3178: stu_rec.c_true_key);

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

3171: );
3172: EXCEPTION WHEN OTHERS THEN
3173: hr_legislation.hrrunprc_trace_on;
3174: hr_utility.trace('ins ff_route_context_usages');
3175: hr_utility.trace('route_id ' ||
3176: to_char(context_usages.route_id));
3177: hr_utility.trace('route_name ' ||
3178: stu_rec.c_true_key);
3179: hr_utility.trace('context_id ' ||

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

3173: hr_legislation.hrrunprc_trace_on;
3174: hr_utility.trace('ins ff_route_context_usages');
3175: hr_utility.trace('route_id ' ||
3176: to_char(context_usages.route_id));
3177: hr_utility.trace('route_name ' ||
3178: stu_rec.c_true_key);
3179: hr_utility.trace('context_id ' ||
3180: to_char(context_usages.context_id));
3181: hr_utility.trace('sequence_no ' ||

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

3175: hr_utility.trace('route_id ' ||
3176: to_char(context_usages.route_id));
3177: hr_utility.trace('route_name ' ||
3178: stu_rec.c_true_key);
3179: hr_utility.trace('context_id ' ||
3180: to_char(context_usages.context_id));
3181: hr_utility.trace('sequence_no ' ||
3182: to_char(context_usages.sequence_no));
3183: hr_legislation.hrrunprc_trace_off;

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

3177: hr_utility.trace('route_name ' ||
3178: stu_rec.c_true_key);
3179: hr_utility.trace('context_id ' ||
3180: to_char(context_usages.context_id));
3181: hr_utility.trace('sequence_no ' ||
3182: to_char(context_usages.sequence_no));
3183: hr_legislation.hrrunprc_trace_off;
3184: raise;
3185: END;

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

3227: r_hrsrp.PARAMETER_NAME,
3228: r_hrsrp.SEQUENCE_NO);
3229: EXCEPTION WHEN OTHERS THEN
3230: hr_legislation.hrrunprc_trace_on;
3231: hr_utility.trace('ins ff_route_parameters');
3232: hr_utility.trace('PARAMETER_NAME ' ||
3233: r_hrsrp.PARAMETER_NAME);
3234: hr_utility.trace('SEQUENCE_NO ' ||
3235: to_char(r_hrsrp.SEQUENCE_NO));

Line 3232: hr_utility.trace('PARAMETER_NAME ' ||

3228: r_hrsrp.SEQUENCE_NO);
3229: EXCEPTION WHEN OTHERS THEN
3230: hr_legislation.hrrunprc_trace_on;
3231: hr_utility.trace('ins ff_route_parameters');
3232: hr_utility.trace('PARAMETER_NAME ' ||
3233: r_hrsrp.PARAMETER_NAME);
3234: hr_utility.trace('SEQUENCE_NO ' ||
3235: to_char(r_hrsrp.SEQUENCE_NO));
3236: hr_utility.trace('ROUTE_ID ' ||

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

3230: hr_legislation.hrrunprc_trace_on;
3231: hr_utility.trace('ins ff_route_parameters');
3232: hr_utility.trace('PARAMETER_NAME ' ||
3233: r_hrsrp.PARAMETER_NAME);
3234: hr_utility.trace('SEQUENCE_NO ' ||
3235: to_char(r_hrsrp.SEQUENCE_NO));
3236: hr_utility.trace('ROUTE_ID ' ||
3237: to_char(stu_rec.c_surrogate_key));
3238: hr_utility.trace('route_name ' ||

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

3232: hr_utility.trace('PARAMETER_NAME ' ||
3233: r_hrsrp.PARAMETER_NAME);
3234: hr_utility.trace('SEQUENCE_NO ' ||
3235: to_char(r_hrsrp.SEQUENCE_NO));
3236: hr_utility.trace('ROUTE_ID ' ||
3237: to_char(stu_rec.c_surrogate_key));
3238: hr_utility.trace('route_name ' ||
3239: stu_rec.c_true_key);
3240: hr_utility.trace('ROUTE_PARAMETER_ID ' ||

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

3234: hr_utility.trace('SEQUENCE_NO ' ||
3235: to_char(r_hrsrp.SEQUENCE_NO));
3236: hr_utility.trace('ROUTE_ID ' ||
3237: to_char(stu_rec.c_surrogate_key));
3238: hr_utility.trace('route_name ' ||
3239: stu_rec.c_true_key);
3240: hr_utility.trace('ROUTE_PARAMETER_ID ' ||
3241: to_char(r_hrsrp.ROUTE_PARAMETER_ID));
3242: hr_legislation.hrrunprc_trace_off;

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

3236: hr_utility.trace('ROUTE_ID ' ||
3237: to_char(stu_rec.c_surrogate_key));
3238: hr_utility.trace('route_name ' ||
3239: stu_rec.c_true_key);
3240: hr_utility.trace('ROUTE_PARAMETER_ID ' ||
3241: to_char(r_hrsrp.ROUTE_PARAMETER_ID));
3242: hr_legislation.hrrunprc_trace_off;
3243: raise;
3244: END;

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

3585:
3586:
3587: EXCEPTION WHEN OTHERS THEN
3588: hr_legislation.hrrunprc_trace_on;
3589: hr_utility.trace('ins ff_functions');
3590: hr_utility.trace('function name ' ||
3591: each_func.name);
3592: hr_utility.trace('function_id ' ||
3593: to_char(l_new_surrogate_key));

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

3586:
3587: EXCEPTION WHEN OTHERS THEN
3588: hr_legislation.hrrunprc_trace_on;
3589: hr_utility.trace('ins ff_functions');
3590: hr_utility.trace('function name ' ||
3591: each_func.name);
3592: hr_utility.trace('function_id ' ||
3593: to_char(l_new_surrogate_key));
3594: hr_utility.trace(':lc: ' || ':' ||

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

3588: hr_legislation.hrrunprc_trace_on;
3589: hr_utility.trace('ins ff_functions');
3590: hr_utility.trace('function name ' ||
3591: each_func.name);
3592: hr_utility.trace('function_id ' ||
3593: to_char(l_new_surrogate_key));
3594: hr_utility.trace(':lc: ' || ':' ||
3595: each_func.legislation_code || ':');
3596: hr_legislation.hrrunprc_trace_off;

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

3590: hr_utility.trace('function name ' ||
3591: each_func.name);
3592: hr_utility.trace('function_id ' ||
3593: to_char(l_new_surrogate_key));
3594: hr_utility.trace(':lc: ' || ':' ||
3595: each_func.legislation_code || ':');
3596: hr_legislation.hrrunprc_trace_off;
3597: raise;
3598: END;

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

3617: from hr_s_function_parameters
3618: where function_id = each_func.function_id;
3619: EXCEPTION WHEN OTHERS THEN
3620: hr_legislation.hrrunprc_trace_on;
3621: hr_utility.trace('ins ff_function_parameters');
3622: hr_utility.trace('function_id ' ||
3623: to_char(each_func.function_id));
3624: hr_utility.trace('function name ' ||
3625: each_func.name);

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

3618: where function_id = each_func.function_id;
3619: EXCEPTION WHEN OTHERS THEN
3620: hr_legislation.hrrunprc_trace_on;
3621: hr_utility.trace('ins ff_function_parameters');
3622: hr_utility.trace('function_id ' ||
3623: to_char(each_func.function_id));
3624: hr_utility.trace('function name ' ||
3625: each_func.name);
3626: hr_utility.trace(':lc: ' ||

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

3620: hr_legislation.hrrunprc_trace_on;
3621: hr_utility.trace('ins ff_function_parameters');
3622: hr_utility.trace('function_id ' ||
3623: to_char(each_func.function_id));
3624: hr_utility.trace('function name ' ||
3625: each_func.name);
3626: hr_utility.trace(':lc: ' ||
3627: each_func.legislation_code || ':');
3628: hr_legislation.hrrunprc_trace_off;

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

3622: hr_utility.trace('function_id ' ||
3623: to_char(each_func.function_id));
3624: hr_utility.trace('function name ' ||
3625: each_func.name);
3626: hr_utility.trace(':lc: ' ||
3627: each_func.legislation_code || ':');
3628: hr_legislation.hrrunprc_trace_off;
3629: raise;
3630: END;

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

3658: return;
3659:
3660: WHEN OTHERS THEN
3661: hr_legislation.hrrunprc_trace_on;
3662: hr_utility.trace('ins ff_function_context_usages');
3663: hr_utility.trace('function_id ' ||
3664: to_char(l_new_surrogate_key));
3665: hr_utility.trace('function name ' ||
3666: each_func.name);

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

3659:
3660: WHEN OTHERS THEN
3661: hr_legislation.hrrunprc_trace_on;
3662: hr_utility.trace('ins ff_function_context_usages');
3663: hr_utility.trace('function_id ' ||
3664: to_char(l_new_surrogate_key));
3665: hr_utility.trace('function name ' ||
3666: each_func.name);
3667: hr_utility.trace(':lc: ' ||

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

3661: hr_legislation.hrrunprc_trace_on;
3662: hr_utility.trace('ins ff_function_context_usages');
3663: hr_utility.trace('function_id ' ||
3664: to_char(l_new_surrogate_key));
3665: hr_utility.trace('function name ' ||
3666: each_func.name);
3667: hr_utility.trace(':lc: ' ||
3668: each_func.legislation_code || ':');
3669: hr_utility.trace('sequence_number ' ||

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

3663: hr_utility.trace('function_id ' ||
3664: to_char(l_new_surrogate_key));
3665: hr_utility.trace('function name ' ||
3666: each_func.name);
3667: hr_utility.trace(':lc: ' ||
3668: each_func.legislation_code || ':');
3669: hr_utility.trace('sequence_number ' ||
3670: to_char(child_usages.sequence_number));
3671: hr_utility.trace('context_id ' ||

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

3665: hr_utility.trace('function name ' ||
3666: each_func.name);
3667: hr_utility.trace(':lc: ' ||
3668: each_func.legislation_code || ':');
3669: hr_utility.trace('sequence_number ' ||
3670: to_char(child_usages.sequence_number));
3671: hr_utility.trace('context_id ' ||
3672: to_char(child_usages.context_id));
3673: hr_legislation.hrrunprc_trace_off;

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

3667: hr_utility.trace(':lc: ' ||
3668: each_func.legislation_code || ':');
3669: hr_utility.trace('sequence_number ' ||
3670: to_char(child_usages.sequence_number));
3671: hr_utility.trace('context_id ' ||
3672: to_char(child_usages.context_id));
3673: hr_legislation.hrrunprc_trace_off;
3674: raise;
3675:

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

4502: from dual;
4503:
4504: WHEN TOO_MANY_ROWS THEN
4505: hr_legislation.hrrunprc_trace_on;
4506: hr_utility.trace('sel ff_globals_f TMR');
4507: hr_utility.trace('global_name ' ||
4508: r_distinct.c_true_key);
4509: hr_utility.trace(':lc: ' || ':' ||
4510: r_distinct.legislation_code || ':');

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

4503:
4504: WHEN TOO_MANY_ROWS THEN
4505: hr_legislation.hrrunprc_trace_on;
4506: hr_utility.trace('sel ff_globals_f TMR');
4507: hr_utility.trace('global_name ' ||
4508: r_distinct.c_true_key);
4509: hr_utility.trace(':lc: ' || ':' ||
4510: r_distinct.legislation_code || ':');
4511: hr_legislation.hrrunprc_trace_off;

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

4505: hr_legislation.hrrunprc_trace_on;
4506: hr_utility.trace('sel ff_globals_f TMR');
4507: hr_utility.trace('global_name ' ||
4508: r_distinct.c_true_key);
4509: hr_utility.trace(':lc: ' || ':' ||
4510: r_distinct.legislation_code || ':');
4511: hr_legislation.hrrunprc_trace_off;
4512: raise;
4513: END;

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

4861: ,r_each_row.CREATION_DATE);
4862:
4863: EXCEPTION WHEN OTHERS THEN
4864: hr_legislation.hrrunprc_trace_on;
4865: hr_utility.trace('ins ff_globals_f');
4866: hr_utility.trace('GLOBAL_NAME ' ||
4867: r_each_row.GLOBAL_NAME);
4868: hr_utility.trace('GLOBAL_ID ' ||
4869: to_char(r_each_row.GLOBAL_ID));

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

4862:
4863: EXCEPTION WHEN OTHERS THEN
4864: hr_legislation.hrrunprc_trace_on;
4865: hr_utility.trace('ins ff_globals_f');
4866: hr_utility.trace('GLOBAL_NAME ' ||
4867: r_each_row.GLOBAL_NAME);
4868: hr_utility.trace('GLOBAL_ID ' ||
4869: to_char(r_each_row.GLOBAL_ID));
4870: hr_utility.trace('GLOBAL_VALUE ' ||

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

4864: hr_legislation.hrrunprc_trace_on;
4865: hr_utility.trace('ins ff_globals_f');
4866: hr_utility.trace('GLOBAL_NAME ' ||
4867: r_each_row.GLOBAL_NAME);
4868: hr_utility.trace('GLOBAL_ID ' ||
4869: to_char(r_each_row.GLOBAL_ID));
4870: hr_utility.trace('GLOBAL_VALUE ' ||
4871: r_each_row.GLOBAL_VALUE);
4872: hr_utility.trace(':lc: ' || ':' ||

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

4866: hr_utility.trace('GLOBAL_NAME ' ||
4867: r_each_row.GLOBAL_NAME);
4868: hr_utility.trace('GLOBAL_ID ' ||
4869: to_char(r_each_row.GLOBAL_ID));
4870: hr_utility.trace('GLOBAL_VALUE ' ||
4871: r_each_row.GLOBAL_VALUE);
4872: hr_utility.trace(':lc: ' || ':' ||
4873: r_each_row.legislation_code || ':');
4874: hr_legislation.hrrunprc_trace_off;

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

4868: hr_utility.trace('GLOBAL_ID ' ||
4869: to_char(r_each_row.GLOBAL_ID));
4870: hr_utility.trace('GLOBAL_VALUE ' ||
4871: r_each_row.GLOBAL_VALUE);
4872: hr_utility.trace(':lc: ' || ':' ||
4873: r_each_row.legislation_code || ':');
4874: hr_legislation.hrrunprc_trace_off;
4875: raise;
4876: END;

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

4903: core_selected NUMBER;
4904:
4905: BEGIN
4906: hr_legislation.hrrunprc_trace_on;
4907: hr_utility.trace('start ff_data_dict.install: ' || to_char(p_phase));
4908: hr_legislation.hrrunprc_trace_off;
4909:
4910: IF p_phase <> 1 and p_phase <>2 THEN
4911: return;

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

4920: and action in ('I', 'U', 'F');
4921:
4922: END IF;
4923: hr_legislation.hrrunprc_trace_on;
4924: hr_utility.trace('start install_ffc: ' || to_char(p_phase));
4925: hr_legislation.hrrunprc_trace_off;
4926:
4927: install_ffc(p_phase); --install ff_contexts
4928: hr_legislation.hrrunprc_trace_on;

Line 4929: hr_utility.trace('start install_fft: ' || to_char(p_phase));

4925: hr_legislation.hrrunprc_trace_off;
4926:
4927: install_ffc(p_phase); --install ff_contexts
4928: hr_legislation.hrrunprc_trace_on;
4929: hr_utility.trace('start install_fft: ' || to_char(p_phase));
4930: hr_legislation.hrrunprc_trace_off;
4931:
4932: install_fft(p_phase); --install ff_Formula_types
4933:

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

4931:
4932: install_fft(p_phase); --install ff_Formula_types
4933:
4934: hr_legislation.hrrunprc_trace_on;
4935: hr_utility.trace('start install_formulas: ' || to_char(p_phase));
4936: hr_legislation.hrrunprc_trace_off;
4937:
4938: install_formulas(p_phase); --install formulas
4939:

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

4937:
4938: install_formulas(p_phase); --install formulas
4939:
4940: hr_legislation.hrrunprc_trace_on;
4941: hr_utility.trace('start install_routes: ' || to_char(p_phase));
4942: hr_legislation.hrrunprc_trace_off;
4943:
4944: install_routes(p_phase); --install routes,entities,db items
4945:

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

4943:
4944: install_routes(p_phase); --install routes,entities,db items
4945:
4946: hr_legislation.hrrunprc_trace_on;
4947: hr_utility.trace('start install_functions: ' || to_char(p_phase));
4948: hr_legislation.hrrunprc_trace_off;
4949:
4950: install_functions(p_phase); --install functions, context usages etc
4951:

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

4949:
4950: install_functions(p_phase); --install functions, context usages etc
4951:
4952: hr_legislation.hrrunprc_trace_on;
4953: hr_utility.trace('start install_qpreports: ' || to_char(p_phase));
4954: hr_legislation.hrrunprc_trace_off;
4955:
4956: install_qpreports(p_phase); --install quickpaint reports
4957:

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

4955:
4956: install_qpreports(p_phase); --install quickpaint reports
4957:
4958: hr_legislation.hrrunprc_trace_on;
4959: hr_utility.trace('start install_globals: ' || to_char(p_phase));
4960: hr_legislation.hrrunprc_trace_off;
4961:
4962: install_globals(p_phase); --install globals
4963:

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

4961:
4962: install_globals(p_phase); --install globals
4963:
4964: hr_legislation.hrrunprc_trace_on;
4965: hr_utility.trace('exit ff_data_dict.install: ' || to_char(p_phase));
4966: hr_legislation.hrrunprc_trace_off;
4967:
4968: END install;
4969: