APPS.HRDYNDBI dependencies on FF_ROUTE_PARAMETER_VALUES

Line 1182: insert into ff_route_parameter_values

1178: -- add Route Parameter values which contains the
1179: -- balance type ID and balance Dimension id to make
1180: -- the route work (we know sequence is 1 and 2)
1181:
1182: insert into ff_route_parameter_values
1183: (route_parameter_id,
1184: user_entity_id,
1185: value)
1186: select RP.route_parameter_id,

Line 1205: insert into ff_route_parameter_values

1201: --
1202: -- RR routes will only have route parameters for Balance type_id
1203: --
1204:
1205: insert into ff_route_parameter_values
1206: (route_parameter_id,
1207: user_entity_id,
1208: value)
1209: select RP.route_parameter_id,

Line 1403: insert into ff_route_parameter_values

1399: route_param_value := p_balance_type_id;
1400: else
1401: route_param_value := p_defined_balance_id;
1402: end if;
1403: insert into ff_route_parameter_values
1404: (route_parameter_id,
1405: user_entity_id,
1406: value)
1407: select RP.route_parameter_id,

Line 1905: the actual entity value into the ff_route_parameter_values table. For

1901: table
1902: DESCRIPTION
1903: This routine is called if the routes contains where clause fillers (Ux).
1904: Get the route parameter id from the ff_route_parameters table and insert
1905: the actual entity value into the ff_route_parameter_values table. For
1906: example, when an element type is created, the value inserted into the
1907: ff_route_parameter_values table is the element type id.
1908: The parameters passed are:
1909: p_value - the actual where clause filler value

Line 1907: ff_route_parameter_values table is the element type id.

1903: This routine is called if the routes contains where clause fillers (Ux).
1904: Get the route parameter id from the ff_route_parameters table and insert
1905: the actual entity value into the ff_route_parameter_values table. For
1906: example, when an element type is created, the value inserted into the
1907: ff_route_parameter_values table is the element type id.
1908: The parameters passed are:
1909: p_value - the actual where clause filler value
1910: p_sequence_no - the number of the where clause filler, eg. 1 for U1.
1911: */

Line 2005: insert into ff_route_parameter_values (

2001: END;
2002: --
2003: -- populate the route parameter value table with the entity value
2004: --
2005: insert into ff_route_parameter_values (
2006: user_entity_id,
2007: route_parameter_id,
2008: value,
2009: last_update_date,

Line 6267: l_param_value ff_route_parameter_values.value%type;

6263: p_param_value in varchar2,
6264: p_leg_code in varchar2,
6265: p_business_group_id in varchar2
6266: ) is
6267: l_param_value ff_route_parameter_values.value%type;
6268: l_dbitem_found boolean;
6269: l_entity_name ff_user_entities.user_entity_name%type;
6270: l_created_by number;
6271: l_last_login number;

Line 6721: l_parameter_value ff_route_parameter_values.value%type;

6717: l_routes c_routes%rowtype;
6718: l_routes_count number := 0;
6719: l_parameter_type varchar2(1);
6720: l_entity_name varchar2(80);
6721: l_parameter_value ff_route_parameter_values.value%type;
6722: --
6723: ---------------------- create_dev_desc_flex_dict -------------------------
6724: --
6725: BEGIN