APPS.HR_LEGISLATION dependencies on PAY_DIMENSION_ROUTES

Line 286: -- 115.84 DVickers 06-JAN-2003 Support for PAY_DIMENSION_ROUTES

282: -- 115.81 DVickers 07-OCT-2002 Added distinct to c_main legislative
283: -- driver cursor
284: -- 115.81.1159.2 DVickers 24-OCT-2002 Fix to create_zz_leg_rule proc to nable
285: -- rerun
286: -- 115.84 DVickers 06-JAN-2003 Support for PAY_DIMENSION_ROUTES
287: -- 115.85 DVickers 06-JAN-2003 Add a call to install_dimension_routes
288: -- 115.86 DVickers 14-JAN-2003 Fixes to install_dimension_routes
289: -- 115.87 DVickers 07-FEB-2003 Add bal_type columns
290: -- 115.88 DVickers 13-FEB-2003 Add support for pay_balance_categories

Line 3457: -- INSTALLATION PROCEDURE FOR : PAY_DIMENSION_ROUTES

3453:
3454: END install_dimensions;
3455:
3456: --****************************************************************************
3457: -- INSTALLATION PROCEDURE FOR : PAY_DIMENSION_ROUTES
3458: --****************************************************************************
3459: PROCEDURE install_dimension_routes(p_phase IN number) IS
3460:
3461: l_null_return varchar2(1); -- used for select null stmts

Line 3479: l_run_dimension_id pay_dimension_routes.run_dimension_id%type;

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;
3480:
3481: PROCEDURE remove IS
3482: -------------------
3483: -- Remove a row from either the startup tables or the installed tables

Line 3493: -- PAY_DIMENSION_ROUTES

3489: PROCEDURE crt_exc (exception_type IN varchar2)
3490: ----------------------------------------------
3491: IS
3492: -- Reports any exceptions during the delivery of startup data to
3493: -- PAY_DIMENSION_ROUTES
3494:
3495: BEGIN
3496: -- See procedure crt_exc in procedure install_past above for generic
3497: -- details.

Line 3500: insert_hr_stu_exceptions('pay_dimension_routes'

3496: -- See procedure crt_exc in procedure install_past above for generic
3497: -- details.
3498:
3499: rollback to new_dimension_route;
3500: insert_hr_stu_exceptions('pay_dimension_routes'
3501: , stu_rec.BALANCE_DIMENSION_ID
3502: , exception_type
3503: , to_char(stu_rec.ROUTE_ID));
3504:

Line 3592: from pay_dimension_routes

3588: BEGIN
3589:
3590: select route_id, run_dimension_id
3591: into l_route_id, l_run_dimension_id
3592: from pay_dimension_routes
3593: where BALANCE_DIMENSION_ID=stu_rec.BALANCE_DIMENSION_ID
3594: and PRIORITY = stu_rec.PRIORITY;
3595:
3596: if (l_route_id <> stu_rec.ROUTE_ID or

Line 3634: delete pay_dimension_routes

3630: null;
3631: END;
3632:
3633: -- Delete potentially existing live dimension route
3634: delete pay_dimension_routes
3635: where BALANCE_DIMENSION_ID=stu_rec.BALANCE_DIMENSION_ID
3636: and PRIORITY = stu_rec.PRIORITY;
3637:
3638: BEGIN

Line 3639: insert into pay_dimension_routes

3635: where BALANCE_DIMENSION_ID=stu_rec.BALANCE_DIMENSION_ID
3636: and PRIORITY = stu_rec.PRIORITY;
3637:
3638: BEGIN
3639: insert into pay_dimension_routes
3640: (BALANCE_DIMENSION_ID
3641: ,ROUTE_ID
3642: ,ROUTE_TYPE
3643: ,PRIORITY