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 clob;
1025: vlive_formula_text clob;
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 1535: IF hr_legislation.g_pseudo_enabled = 'Y' THEN

1531: END;
1532:
1533: -- PSEUDO
1534: -- Error if we clash on delivered data to pseudo data present
1535: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
1536: BEGIN
1537: -- Check if we have a pseudo seed clash if enabled
1538: -- Error handling is done in the procedure itself
1539: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => r_distinct.c_true_key,

Line 1539: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => r_distinct.c_true_key,

1535: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
1536: BEGIN
1537: -- Check if we have a pseudo seed clash if enabled
1538: -- Error handling is done in the procedure itself
1539: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => r_distinct.c_true_key,
1540: P_TABLE_NAME => 'FF_FORMULAS_F',
1541: P_LEGISLATION_CODE => r_distinct.legislation_code);
1542: EXCEPTION WHEN OTHERS THEN
1543: return FALSE;

Line 1820: hr_legislation.hrrunprc_trace_on;

1816: ,r_each_row.created_by
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 ' ||

Line 1830: hr_legislation.hrrunprc_trace_off;

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;
1833:
1834: remove(r_distinct.c_surrogate_key);

Line 1968: hr_legislation.insert_hr_stu_exceptions('ff_routes'

1964:
1965:
1966: rollback to new_route_name;
1967:
1968: hr_legislation.insert_hr_stu_exceptions('ff_routes'
1969: , stu_rec.c_surrogate_key
1970: , exception_type
1971: , stu_rec.c_true_key);
1972:

Line 2149: hr_legislation.munge_sequence('FF_ROUTES_S',

2145:
2146: IF v_sequence_number
2147: BETWEEN v_min_delivered AND v_max_delivered THEN
2148:
2149: hr_legislation.munge_sequence('FF_ROUTES_S',
2150: v_sequence_number,
2151: v_max_delivered);
2152:
2153: END IF;

Line 2171: hr_legislation.munge_sequence('FF_USER_ENTITIES_S',

2167:
2168: IF v_sequence_number
2169: BETWEEN v_min_delivered AND v_max_delivered THEN
2170:
2171: hr_legislation.munge_sequence('FF_USER_ENTITIES_S',
2172: v_sequence_number,
2173: v_max_delivered);
2174:
2175: END IF;

Line 2193: hr_legislation.munge_sequence('FF_ROUTE_PARAMETERS_S',

2189:
2190: IF v_sequence_number
2191: BETWEEN v_min_delivered AND v_max_delivered THEN
2192:
2193: hr_legislation.munge_sequence('FF_ROUTE_PARAMETERS_S',
2194: v_sequence_number,
2195: v_max_delivered);
2196:
2197: END IF;

Line 2238: hr_legislation.hrrunprc_trace_on;

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

Line 2242: hr_legislation.hrrunprc_trace_off;

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;
2245:
2246:

Line 2312: hr_legislation.hrrunprc_trace_on;

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

Line 2322: hr_legislation.hrrunprc_trace_off;

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:
2325: END; --select of new surrogate id
2326:

Line 2342: IF hr_legislation.g_pseudo_enabled = 'Y' THEN

2338: FOR delivered_entities IN user_entity(stu_Rec.c_Surrogate_key) LOOP
2339:
2340: -- PSEUDO
2341: -- Error if we clash on delivered data to pseudo data present
2342: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
2343: -- Check if we have a pseduo seed clash if enabled
2344: -- Error handling is done in the procedure itself
2345: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => delivered_entities.user_entity_name,
2346: P_TABLE_NAME => 'FF_USER_ENTITIES',

Line 2345: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => delivered_entities.user_entity_name,

2341: -- Error if we clash on delivered data to pseudo data present
2342: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
2343: -- Check if we have a pseduo seed clash if enabled
2344: -- Error handling is done in the procedure itself
2345: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => delivered_entities.user_entity_name,
2346: P_TABLE_NAME => 'FF_USER_ENTITIES',
2347: P_LEGISLATION_CODE => delivered_entities.legislation_code);
2348: END IF;
2349:

Line 2366: hr_legislation.hrrunprc_trace_on;

2362: into l_new_entity_id
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 ' ||

Line 2376: hr_legislation.hrrunprc_trace_off;

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;
2379:
2380: update hr_s_user_entities

Line 2563: hr_legislation.hrrunprc_trace_on;

2559: return FALSE;
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:

Line 2566: hr_legislation.hrrunprc_trace_off;

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
2569:
2570: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2573: hr_legislation.hrrunprc_trace_on;

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

Line 2576: hr_legislation.hrrunprc_trace_off;

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:
2579: END;
2580:

Line 2717: -- hr_legislation.hrrunprc_trace_on;

2713: select user_entity_name
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;

Line 2720: -- hr_legislation.hrrunprc_trace_off;

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;
2723:
2724: return TRUE;

Line 2818: hr_legislation.hrrunprc_trace_on;

2814: ,all_user_entities.creation_date
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 ' ||

Line 2834: hr_legislation.hrrunprc_trace_off;

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;
2837: END IF;
2838:

Line 2886: hr_legislation.hrrunprc_trace_on;

2882: ,all_db_items.created_by
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 ' ||

Line 2902: hr_legislation.hrrunprc_trace_off;

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;
2905:
2906: END IF;

Line 2950: hr_legislation.hrrunprc_trace_on;

2946: ,pvalues.created_by
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 ' ||

Line 2968: hr_legislation.hrrunprc_trace_off;

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;
2971:
2972: END IF;

Line 3067: hr_legislation.hrrunprc_trace_on;

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

Line 3073: hr_legislation.hrrunprc_trace_off;

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;
3076:
3077: END IF;

Line 3173: hr_legislation.hrrunprc_trace_on;

3169: ,context_usages.context_id
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 ' ||

Line 3183: hr_legislation.hrrunprc_trace_off;

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;
3186:
3187: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 3230: hr_legislation.hrrunprc_trace_on;

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

Line 3242: hr_legislation.hrrunprc_trace_off;

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;
3245:
3246: END;

Line 3392: hr_legislation.insert_hr_stu_exceptions('ff_functions'

3388:
3389:
3390: rollback to new_function_name;
3391:
3392: hr_legislation.insert_hr_stu_exceptions('ff_functions'
3393: , 0
3394: , exception_type
3395: , stu_rec.name);
3396:

Line 3588: hr_legislation.hrrunprc_trace_on;

3584: );
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 ' ||

Line 3596: hr_legislation.hrrunprc_trace_off;

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;
3599:
3600: BEGIN

Line 3620: hr_legislation.hrrunprc_trace_on;

3616: , optional
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 ' ||

Line 3628: hr_legislation.hrrunprc_trace_off;

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;
3631:
3632: FOR child_usages IN usages(each_func.function_id) LOOP

Line 3661: hr_legislation.hrrunprc_trace_on;

3657:
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 ' ||

Line 3673: hr_legislation.hrrunprc_trace_off;

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:
3676: END;
3677:

Line 3776: hr_legislation.insert_hr_stu_exceptions('ff_qp_reports'

3772:
3773:
3774: rollback to new_qp_report_name;
3775:
3776: hr_legislation.insert_hr_stu_exceptions('ff_qp_reports'
3777: , stu_rec.c_surrogate_key
3778: , exception_type
3779: , stu_rec.c_true_key);
3780:

Line 3852: hr_legislation.munge_sequence('FF_QP_REPORTS_S',

3848:
3849: IF v_sequence_number
3850: BETWEEN v_min_delivered AND v_max_delivered THEN
3851:
3852: hr_legislation.munge_sequence('FF_QP_REPORTS_S',
3853: v_sequence_number,
3854: v_max_delivered);
3855:
3856: END IF;

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

4318: -- details transferred into live tables. The parameter p_phase holds
4319: -- the phase number.
4320:
4321: row_in_error exception;
4322: l_current_proc varchar2(80) := 'hr_legislation.install_globals';
4323: l_new_global_id number(15);
4324: l_null_return varchar2(1);
4325: status varchar2(10);
4326:

Line 4465: hr_legislation.munge_sequence('FF_GLOBALS_S',

4461:
4462: IF v_sequence_number
4463: BETWEEN v_min_delivered AND v_max_delivered THEN
4464:
4465: hr_legislation.munge_sequence('FF_GLOBALS_S',
4466: v_sequence_number,
4467: v_max_delivered);
4468: END IF;
4469:

Line 4505: hr_legislation.hrrunprc_trace_on;

4501: into l_new_global_id
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: ' || ':' ||

Line 4511: hr_legislation.hrrunprc_trace_off;

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;
4514:
4515: update hr_s_globals_f

Line 4542: hr_legislation.insert_hr_stu_exceptions('ff_globals_f'

4538: -- not be raised more than once.
4539:
4540: rollback to new_global_name;
4541:
4542: hr_legislation.insert_hr_stu_exceptions('ff_globals_f'
4543: , r_distinct.c_surrogate_key
4544: , exception_type
4545: , r_distinct.c_true_key);
4546:

Line 4864: hr_legislation.hrrunprc_trace_on;

4860: ,r_each_row.CREATED_BY
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 ' ||

Line 4874: hr_legislation.hrrunprc_trace_off;

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;
4877: END LOOP each_row;
4878:

Line 4906: hr_legislation.hrrunprc_trace_on;

4902: -- Driver procedure to execute all formula installation procedures.
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

Line 4908: hr_legislation.hrrunprc_trace_off;

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;
4912: END IF;

Line 4918: from hr_legislation_installations

4914: IF p_phase = 2 THEN
4915:
4916: select count(*)
4917: into core_selected
4918: from hr_legislation_installations
4919: where legislation_code is null
4920: and action in ('I', 'U', 'F');
4921:
4922: END IF;

Line 4923: hr_legislation.hrrunprc_trace_on;

4919: where legislation_code is null
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

Line 4925: hr_legislation.hrrunprc_trace_off;

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;
4929: hr_utility.trace('start install_fft: ' || to_char(p_phase));

Line 4928: 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;
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

Line 4930: 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:
4934: hr_legislation.hrrunprc_trace_on;

Line 4934: hr_legislation.hrrunprc_trace_on;

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

Line 4936: hr_legislation.hrrunprc_trace_off;

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

Line 4940: hr_legislation.hrrunprc_trace_on;

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

Line 4942: hr_legislation.hrrunprc_trace_off;

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

Line 4946: hr_legislation.hrrunprc_trace_on;

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

Line 4948: hr_legislation.hrrunprc_trace_off;

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

Line 4952: hr_legislation.hrrunprc_trace_on;

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

Line 4954: hr_legislation.hrrunprc_trace_off;

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

Line 4958: hr_legislation.hrrunprc_trace_on;

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

Line 4960: hr_legislation.hrrunprc_trace_off;

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

Line 4964: hr_legislation.hrrunprc_trace_on;

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

Line 4966: hr_legislation.hrrunprc_trace_off;

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:
4970: END ff_data_dict;