APPS.PAY_JP_DIMENSION_GENERATOR_PKG dependencies on FF_ROUTES

Line 280: from ff_routes

276: l_route_id number;
277: begin
278: select route_id
279: into l_route_id
280: from ff_routes
281: where route_name = p_route_name;
282: --
283: return l_route_id;
284: exception

Line 440: l_optimizer_hint ff_routes.optimizer_hint%type;

436: is
437: l_route_name varchar2(255);
438: l_template_route_name varchar2(255);
439: l_template_route_id number;
440: l_optimizer_hint ff_routes.optimizer_hint%type;
441: l_text varchar2(32767);
442: l_description ff_routes.description%type;
443: begin
444: l_route_name := get_route_name(p_route_type, p_date_type, p_reset_date, p_frequency_type, p_frequency, p_exclude_reversal);

Line 442: l_description ff_routes.description%type;

438: l_template_route_name varchar2(255);
439: l_template_route_id number;
440: l_optimizer_hint ff_routes.optimizer_hint%type;
441: l_text varchar2(32767);
442: l_description ff_routes.description%type;
443: begin
444: l_route_name := get_route_name(p_route_type, p_date_type, p_reset_date, p_frequency_type, p_frequency, p_exclude_reversal);
445: p_route_id := get_route_id(l_route_name, false);
446: --

Line 459: from ff_routes

455: text
456: into l_template_route_id,
457: l_optimizer_hint,
458: l_text
459: from ff_routes
460: where route_name = l_template_route_name;
461: --
462: l_text := my_replace(l_text, '', p_reset_date);
463: l_text := replace(l_text, '', p_frequency_type);

Line 469: select ff_routes_s.nextval

465: --
466: l_description := p_route_type || ' Balance Dimension Route for ' ||
467: get_description(p_date_type, p_reset_date, p_frequency_type, p_frequency, p_exclude_reversal);
468: --
469: select ff_routes_s.nextval
470: into p_route_id
471: from dual;
472: --
473: -- Set user_defined_flag = 'Y'

Line 475: insert into ff_routes(

471: from dual;
472: --
473: -- Set user_defined_flag = 'Y'
474: --
475: insert into ff_routes(
476: ROUTE_ID,
477: ROUTE_NAME,
478: USER_DEFINED_FLAG,
479: DESCRIPTION,

Line 1197: -- Delete FF_ROUTES

1193: from pay_dimension_routes
1194: where balance_dimension_id = l_rec.balance_dimension_id;
1195: end loop;
1196: --
1197: -- Delete FF_ROUTES
1198: --
1199: delete
1200: from ff_routes
1201: where ( route_name like 'JP\_ASG\_DP\_%\_BALANCE_DIMENSION%' escape '\'

Line 1200: from ff_routes

1196: --
1197: -- Delete FF_ROUTES
1198: --
1199: delete
1200: from ff_routes
1201: where ( route_name like 'JP\_ASG\_DP\_%\_BALANCE_DIMENSION%' escape '\'
1202: or route_name like 'JP\_ASG\_DE\_%\_BALANCE_DIMENSION%' escape '\')
1203: and user_defined_flag = 'Y';
1204: --