APPS.HR_GBBAL dependencies on FF_ROUTES

Line 3241: -- INSERT INTO FF_ROUTES --

3237: BEGIN
3238: errbuf := NULL;
3239: retcode := 0;
3240: ---------------------------
3241: -- INSERT INTO FF_ROUTES --
3242: ---------------------------
3243: DECLARE
3244: l_route_text ff_routes.text%TYPE;
3245: l_bal_next number;

Line 3244: l_route_text ff_routes.text%TYPE;

3240: ---------------------------
3241: -- INSERT INTO FF_ROUTES --
3242: ---------------------------
3243: DECLARE
3244: l_route_text ff_routes.text%TYPE;
3245: l_bal_next number;
3246: BEGIN
3247: SELECT
3248: pay_balance_dimensions_s.NEXTVAL

Line 3263: INSERT INTO FF_ROUTES

3259: AND TARGET.balance_dimension_id = ' || TO_CHAR(l_bal_next);
3260: --
3261: --
3262:
3263: INSERT INTO FF_ROUTES
3264: (
3265: route_id,
3266: route_name,
3267: user_defined_flag,

Line 3273: ff_routes_s.NEXTVAL,

3269: text
3270: )
3271: VALUES
3272: (
3273: ff_routes_s.NEXTVAL,
3274: 'ROUTE_NAME_' || ff_routes_s.CURRVAL ,
3275: 'N',
3276: 'User balance dimension for '||
3277: UPPER(RPAD(p_suffix,30,' ')) || 'USER-REG ASG '||

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

3270: )
3271: VALUES
3272: (
3273: ff_routes_s.NEXTVAL,
3274: 'ROUTE_NAME_' || ff_routes_s.CURRVAL ,
3275: 'N',
3276: 'User balance dimension for '||
3277: UPPER(RPAD(p_suffix,30,' ')) || 'USER-REG ASG '||
3278: p_start_dd_mm || ' RESET'|| TO_CHAR(p_frequency,'00'),

Line 3295: ff_routes_s.CURRVAL,

3291: context_id,
3292: sequence_no
3293: )
3294: SELECT
3295: ff_routes_s.CURRVAL,
3296: context_id,
3297: 1
3298: FROM
3299: ff_contexts

Line 3320: ff_routes_s.CURRVAL,

3316: )
3317: VALUES
3318: (
3319: ff_route_parameters_s.NEXTVAL,
3320: ff_routes_s.CURRVAL,
3321: 1,
3322: 'BALANCE TYPE ID',
3323: 'N'
3324: );

Line 3400: ff_routes_s.CURRVAL,

3396: (
3397: pay_balance_dimensions_s.CURRVAL,
3398: p_business_group_id,
3399: NULL,
3400: ff_routes_s.CURRVAL,
3401: p_suffix,
3402: l_dim_name,
3403: l_dim_type,
3404: 'User dimension defined by Request Id ' || l_req_id,