APPS.HRDYNDBI dependencies on FF_ROUTE_PARAMETERS

Line 1189: from ff_route_parameters RP

1185: value)
1186: select RP.route_parameter_id,
1187: usr_ent_id,
1188: to_char(p_balance_type_id)
1189: from ff_route_parameters RP
1190: where RP.route_id = rrrec.route_id
1191: and RP.sequence_no = 1;
1192: if sql%rowcount <> 1 then
1193: hr_utility.set_message(801, 'HR_ERROR');

Line 1212: from ff_route_parameters RP

1208: value)
1209: select RP.route_parameter_id,
1210: usr_ent_id,
1211: to_char(rrrec.run_dimension_id)
1212: from ff_route_parameters RP
1213: where RP.route_id = rrrec.route_id
1214: and RP.sequence_no = 2;
1215: if sql%rowcount <> 1 then
1216: hr_utility.set_message(801, 'HR_ERROR');

Line 1410: from ff_route_parameters RP

1406: value)
1407: select RP.route_parameter_id,
1408: usr_ent_id,
1409: to_char(route_param_value)
1410: from ff_route_parameters RP
1411: where RP.route_id = l_route_id
1412: and RP.sequence_no = 1;
1413: if sql%rowcount <> 1 then
1414: hr_utility.set_message(801, 'HR_ERROR');

Line 1904: Get the route parameter id from the ff_route_parameters table and insert

1900: insert_parameter_value - insert the entity value into the route parameter
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:

Line 1949: , ff_route_parameters RPARAM

1945: l_created_by,
1946: l_last_login,
1947: l_user_entity_name
1948: from ff_user_entities ENTITY
1949: , ff_route_parameters RPARAM
1950: where ENTITY.user_entity_id = l_user_entity_id
1951: and RPARAM.route_id = ENTITY.route_id
1952: and RPARAM.sequence_no = p_sequence_no;
1953: EXCEPTION WHEN OTHERS THEN

Line 6713: from ff_route_parameters rpm, ff_routes rt

6709: -- declare a cursor to check whether the route uses a parameter
6710: --
6711: cursor c_chk_route_parameter (p_route_name varchar2) is
6712: select data_type
6713: from ff_route_parameters rpm, ff_routes rt
6714: where rt.route_name = p_route_name
6715: and rpm.route_id = rt.route_id;
6716:
6717: l_routes c_routes%rowtype;