APPS.PY_ZA_BAL dependencies on FF_ROUTES

Line 2987: -- INSERT INTO FF_ROUTES --

2983: BEGIN
2984: errbuf := NULL;
2985: retcode := 0;
2986: ---------------------------
2987: -- INSERT INTO FF_ROUTES --
2988: ---------------------------
2989: DECLARE
2990: l_route_text ff_routes.text%TYPE;
2991: l_bal_next number;

Line 2990: l_route_text ff_routes.text%TYPE;

2986: ---------------------------
2987: -- INSERT INTO FF_ROUTES --
2988: ---------------------------
2989: DECLARE
2990: l_route_text ff_routes.text%TYPE;
2991: l_bal_next number;
2992: BEGIN
2993: SELECT
2994: pay_balance_dimensions_s.NEXTVAL

Line 3009: INSERT INTO FF_ROUTES

3005: AND TARGET.balance_dimension_id = ' || TO_CHAR(l_bal_next);
3006: --
3007: --
3008:
3009: INSERT INTO FF_ROUTES
3010: (
3011: route_id,
3012: route_name,
3013: user_defined_flag,

Line 3019: ff_routes_s.NEXTVAL,

3015: text
3016: )
3017: VALUES
3018: (
3019: ff_routes_s.NEXTVAL,
3020: 'ROUTE_NAME_' || ff_routes_s.CURRVAL ,
3021: 'N',
3022: 'User balance dimension for '||
3023: UPPER(RPAD(p_suffix,30,' ')) || 'USER-REG ASG '||

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

3016: )
3017: VALUES
3018: (
3019: ff_routes_s.NEXTVAL,
3020: 'ROUTE_NAME_' || ff_routes_s.CURRVAL ,
3021: 'N',
3022: 'User balance dimension for '||
3023: UPPER(RPAD(p_suffix,30,' ')) || 'USER-REG ASG '||
3024: p_start_dd_mm || ' RESET'|| TO_CHAR(p_frequency,'00'),

Line 3041: ff_routes_s.CURRVAL,

3037: context_id,
3038: sequence_no
3039: )
3040: SELECT
3041: ff_routes_s.CURRVAL,
3042: context_id,
3043: 1
3044: FROM
3045: ff_contexts

Line 3066: ff_routes_s.CURRVAL,

3062: )
3063: VALUES
3064: (
3065: ff_route_parameters_s.NEXTVAL,
3066: ff_routes_s.CURRVAL,
3067: 1,
3068: 'BALANCE TYPE ID',
3069: 'N'
3070: );

Line 3146: ff_routes_s.CURRVAL,

3142: (
3143: pay_balance_dimensions_s.CURRVAL,
3144: p_business_group_id,
3145: NULL,
3146: ff_routes_s.CURRVAL,
3147: p_suffix,
3148: l_dim_name,
3149: l_dim_type,
3150: 'User dimension defined by Request Id ' || l_req_id,