APPS.HR_GBBAL dependencies on FF_ROUTES

Line 3257: -- INSERT INTO FF_ROUTES --

3253: raise_application_error ('-20000', fnd_message.get);
3254: end if;
3255:
3256: ---------------------------
3257: -- INSERT INTO FF_ROUTES --
3258: ---------------------------
3259: DECLARE
3260: l_route_text ff_routes.text%TYPE;
3261: l_bal_next number;

Line 3260: l_route_text ff_routes.text%TYPE;

3256: ---------------------------
3257: -- INSERT INTO FF_ROUTES --
3258: ---------------------------
3259: DECLARE
3260: l_route_text ff_routes.text%TYPE;
3261: l_bal_next number;
3262: BEGIN
3263: SELECT
3264: pay_balance_dimensions_s.NEXTVAL

Line 3279: INSERT INTO FF_ROUTES

3275: AND TARGET.balance_dimension_id = ' || TO_CHAR(l_bal_next);
3276: --
3277: --
3278:
3279: INSERT INTO FF_ROUTES
3280: (
3281: route_id,
3282: route_name,
3283: user_defined_flag,

Line 3289: ff_routes_s.NEXTVAL,

3285: text
3286: )
3287: VALUES
3288: (
3289: ff_routes_s.NEXTVAL,
3290: 'ROUTE_NAME_' || ff_routes_s.CURRVAL ,
3291: 'N',
3292: 'User balance dimension for '||
3293: UPPER(RPAD(p_suffix,30,' ')) || 'USER-REG ASG '||

Line 3290: 'ROUTE_NAME_' || ff_routes_s.CURRVAL ,

3286: )
3287: VALUES
3288: (
3289: ff_routes_s.NEXTVAL,
3290: 'ROUTE_NAME_' || ff_routes_s.CURRVAL ,
3291: 'N',
3292: 'User balance dimension for '||
3293: UPPER(RPAD(p_suffix,30,' ')) || 'USER-REG ASG '||
3294: p_start_dd_mm || ' RESET'|| TO_CHAR(p_frequency,'00'),

Line 3311: ff_routes_s.CURRVAL,

3307: context_id,
3308: sequence_no
3309: )
3310: SELECT
3311: ff_routes_s.CURRVAL,
3312: context_id,
3313: 1
3314: FROM
3315: ff_contexts

Line 3336: ff_routes_s.CURRVAL,

3332: )
3333: VALUES
3334: (
3335: ff_route_parameters_s.NEXTVAL,
3336: ff_routes_s.CURRVAL,
3337: 1,
3338: 'BALANCE TYPE ID',
3339: 'N'
3340: );

Line 3416: ff_routes_s.CURRVAL,

3412: (
3413: pay_balance_dimensions_s.CURRVAL,
3414: p_business_group_id,
3415: NULL,
3416: ff_routes_s.CURRVAL,
3417: p_suffix,
3418: l_dim_name,
3419: l_dim_type,
3420: 'User dimension defined by Request Id ' || l_req_id,