APPS.HRDYNDBI dependencies on FF_ROUTE_PARAMETER_VALUES

Line 1185: insert into ff_route_parameter_values

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

Line 1208: insert into ff_route_parameter_values

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

Line 1406: insert into ff_route_parameter_values

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

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

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

Line 1910: ff_route_parameter_values table is the element type id.

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

Line 2008: insert into ff_route_parameter_values (

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

Line 6270: l_param_value ff_route_parameter_values.value%type;

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

Line 6731: l_parameter_value ff_route_parameter_values.value%type;

6727: l_routes c_routes%rowtype;
6728: l_routes_count number := 0;
6729: l_parameter_type varchar2(1);
6730: l_entity_name varchar2(80);
6731: l_parameter_value ff_route_parameter_values.value%type;
6732: --
6733: ---------------------- create_dev_desc_flex_dict -------------------------
6734: --
6735: BEGIN