[Home] [Help]
2889: update /*+NO_INDEX*/ hr_s_balance_dimensions
2890: set asg_action_balance_dim_id = asg_action_balance_dim_id
2891: - 50000000;
2892:
2893: update /*+NO_INDEX*/ hr_s_dimension_routes
2894: set balance_dimension_id = balance_dimension_id - 50000000;
2895:
2896: update /*+NO_INDEX*/ hr_s_dimension_routes
2897: set run_dimension_id = run_dimension_id - 50000000;
2892:
2893: update /*+NO_INDEX*/ hr_s_dimension_routes
2894: set balance_dimension_id = balance_dimension_id - 50000000;
2895:
2896: update /*+NO_INDEX*/ hr_s_dimension_routes
2897: set run_dimension_id = run_dimension_id - 50000000;
2898:
2899: update hr_s_application_ownerships
2900: set key_value = key_value - 50000000
3005: update hr_s_defined_balances
3006: set balance_dimension_id = l_new_surrogate_key
3007: where balance_dimension_id = stu_rec.c_surrogate_key;
3008:
3009: update hr_s_dimension_routes
3010: set balance_dimension_id = l_new_surrogate_key
3011: where balance_dimension_id = stu_rec.c_surrogate_key;
3012:
3013: update hr_s_dimension_routes
3009: update hr_s_dimension_routes
3010: set balance_dimension_id = l_new_surrogate_key
3011: where balance_dimension_id = stu_rec.c_surrogate_key;
3012:
3013: update hr_s_dimension_routes
3014: set run_dimension_id = l_new_surrogate_key
3015: where run_dimension_id = stu_rec.c_surrogate_key;
3016:
3017: update hr_s_balance_dimensions
3471: , RUN_DIMENSION_ID
3472: , BALANCE_TYPE_COLUMN
3473: , DECODE_REQUIRED
3474: , rowid
3475: from hr_s_dimension_routes;
3476:
3477: stu_rec stu%ROWTYPE; -- Record for the above select
3478: l_route_id ff_routes.route_id%type;
3479: l_run_dimension_id pay_dimension_routes.run_dimension_id%type;
3481: PROCEDURE remove IS
3482: -------------------
3483: -- Remove a row from either the startup tables or the installed tables
3484: BEGIN
3485: delete from hr_s_dimension_routes
3486: where rowid = stu_rec.rowid;
3487: END remove;
3488:
3489: PROCEDURE crt_exc (exception_type IN varchar2)