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 3211: -- INSTALLATION PROCEDURE FOR : PAY_DIMENSION_ROUTES

3207:
3208: END install_dimensions;
3209:
3210: --****************************************************************************
3211: -- INSTALLATION PROCEDURE FOR : PAY_DIMENSION_ROUTES
3212: --****************************************************************************
3213: PROCEDURE install_dimension_routes(p_phase IN number) IS
3214:
3215: l_null_return varchar2(1); -- used for select null stmts

Line 3233: l_run_dimension_id pay_dimension_routes.run_dimension_id%type;

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;
3234:
3235: PROCEDURE remove IS
3236: -------------------
3237: -- Remove a row from either the startup tables or the installed tables

Line 3247: -- PAY_DIMENSION_ROUTES

3243: PROCEDURE crt_exc (exception_type IN varchar2)
3244: ----------------------------------------------
3245: IS
3246: -- Reports any exceptions during the delivery of startup data to
3247: -- PAY_DIMENSION_ROUTES
3248:
3249: BEGIN
3250: -- See procedure crt_exc in procedure install_past above for generic
3251: -- details.

Line 3254: insert_hr_stu_exceptions('pay_dimension_routes'

3250: -- See procedure crt_exc in procedure install_past above for generic
3251: -- details.
3252:
3253: rollback to new_dimension_route;
3254: insert_hr_stu_exceptions('pay_dimension_routes'
3255: , stu_rec.BALANCE_DIMENSION_ID
3256: , exception_type
3257: , to_char(stu_rec.ROUTE_ID));
3258:

Line 3346: from pay_dimension_routes

3342: BEGIN
3343:
3344: select route_id, run_dimension_id
3345: into l_route_id, l_run_dimension_id
3346: from pay_dimension_routes
3347: where BALANCE_DIMENSION_ID=stu_rec.BALANCE_DIMENSION_ID
3348: and PRIORITY = stu_rec.PRIORITY;
3349:
3350: if (l_route_id <> stu_rec.ROUTE_ID or

Line 3388: delete pay_dimension_routes

3384: null;
3385: END;
3386:
3387: -- Delete potentially existing live dimension route
3388: delete pay_dimension_routes
3389: where BALANCE_DIMENSION_ID=stu_rec.BALANCE_DIMENSION_ID
3390: and PRIORITY = stu_rec.PRIORITY;
3391:
3392: BEGIN

Line 3393: insert into pay_dimension_routes

3389: where BALANCE_DIMENSION_ID=stu_rec.BALANCE_DIMENSION_ID
3390: and PRIORITY = stu_rec.PRIORITY;
3391:
3392: BEGIN
3393: insert into pay_dimension_routes
3394: (BALANCE_DIMENSION_ID
3395: ,ROUTE_ID
3396: ,ROUTE_TYPE
3397: ,PRIORITY