APPS.HRDYNDBI dependencies on FF_ROUTE_PARAMETERS

Line 1192: from ff_route_parameters RP

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

Line 1215: from ff_route_parameters RP

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

Line 1413: from ff_route_parameters RP

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

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

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

Line 1952: , ff_route_parameters RPARAM

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

Line 6723: from ff_route_parameters rpm, ff_routes rt

6719: -- declare a cursor to check whether the route uses a parameter
6720: --
6721: cursor c_chk_route_parameter (p_route_name varchar2) is
6722: select data_type
6723: from ff_route_parameters rpm, ff_routes rt
6724: where rt.route_name = p_route_name
6725: and rpm.route_id = rt.route_id;
6726:
6727: l_routes c_routes%rowtype;