APPS.PAY_RULES_DBI_PKG dependencies on FF_ROUTE_PARAMETERS

Line 178: INSERT INTO ff_route_parameters

174: -- Insert any route parameters
175: --
176: IF p_param_name1 is not null THEN
177: --
178: INSERT INTO ff_route_parameters
179: (route_parameter_id,
180: route_id,
181: sequence_no,
182: parameter_name,

Line 185: (ff_route_parameters_s.nextval,

181: sequence_no,
182: parameter_name,
183: data_type)
184: VALUES
185: (ff_route_parameters_s.nextval,
186: l_route_id,
187: 1,
188: p_param_name1,
189: p_param_type1);

Line 195: INSERT INTO ff_route_parameters

191: END IF;
192: --
193: IF p_param_name2 is not null THEN
194: --
195: INSERT INTO ff_route_parameters
196: (route_parameter_id,
197: route_id,
198: sequence_no,
199: parameter_name,

Line 202: (ff_route_parameters_s.nextval,

198: sequence_no,
199: parameter_name,
200: data_type)
201: VALUES
202: (ff_route_parameters_s.nextval,
203: l_route_id,
204: 1,
205: p_param_name2,
206: p_param_type2);

Line 255: FROM ff_route_parameters

251: value)
252: SELECT route_parameter_id,
253: l_user_entity_id,
254: p_param_value1
255: FROM ff_route_parameters
256: where route_id = l_route_id
257: and sequence_no = 1;
258: --
259: END IF;

Line 270: FROM ff_route_parameters

266: value)
267: SELECT route_parameter_id,
268: l_user_entity_id,
269: p_param_value2
270: FROM ff_route_parameters
271: where route_id = l_route_id
272: and sequence_no = 2;
273: --
274: END IF;