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:
285: IF p_phase = 2 THEN
286: l_new_surrogate_key := stu_rec.c_surrogate_key;
287: END IF;
288:
289: delete from hr_stu_exceptions
290: where surrogate_id = stu_rec.c_surrogate_key
291: and table_name = 'FF_CONTEXTS';
292:
293: END remove;
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:
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:
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:
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:
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:
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: