[Home] [Help]
2643: update /*+NO_INDEX*/ hr_s_balance_dimensions
2644: set asg_action_balance_dim_id = asg_action_balance_dim_id
2645: - 50000000;
2646:
2647: update /*+NO_INDEX*/ hr_s_dimension_routes
2648: set balance_dimension_id = balance_dimension_id - 50000000;
2649:
2650: update /*+NO_INDEX*/ hr_s_dimension_routes
2651: set run_dimension_id = run_dimension_id - 50000000;
2646:
2647: update /*+NO_INDEX*/ hr_s_dimension_routes
2648: set balance_dimension_id = balance_dimension_id - 50000000;
2649:
2650: update /*+NO_INDEX*/ hr_s_dimension_routes
2651: set run_dimension_id = run_dimension_id - 50000000;
2652:
2653: update hr_s_application_ownerships
2654: set key_value = key_value - 50000000
2759: update hr_s_defined_balances
2760: set balance_dimension_id = l_new_surrogate_key
2761: where balance_dimension_id = stu_rec.c_surrogate_key;
2762:
2763: update hr_s_dimension_routes
2764: set balance_dimension_id = l_new_surrogate_key
2765: where balance_dimension_id = stu_rec.c_surrogate_key;
2766:
2767: update hr_s_dimension_routes
2763: update hr_s_dimension_routes
2764: set balance_dimension_id = l_new_surrogate_key
2765: where balance_dimension_id = stu_rec.c_surrogate_key;
2766:
2767: update hr_s_dimension_routes
2768: set run_dimension_id = l_new_surrogate_key
2769: where run_dimension_id = stu_rec.c_surrogate_key;
2770:
2771: update hr_s_balance_dimensions
3225: , RUN_DIMENSION_ID
3226: , BALANCE_TYPE_COLUMN
3227: , DECODE_REQUIRED
3228: , rowid
3229: from hr_s_dimension_routes;
3230:
3231: stu_rec stu%ROWTYPE; -- Record for the above select
3232: l_route_id ff_routes.route_id%type;
3233: l_run_dimension_id pay_dimension_routes.run_dimension_id%type;
3235: PROCEDURE remove IS
3236: -------------------
3237: -- Remove a row from either the startup tables or the installed tables
3238: BEGIN
3239: delete from hr_s_dimension_routes
3240: where rowid = stu_rec.rowid;
3241: END remove;
3242:
3243: PROCEDURE crt_exc (exception_type IN varchar2)