APPS.PAY_DATABASE_ITEMS_PKG dependencies on FF_ROUTE_PARAMETERS

Line 172: INSERT INTO ff_route_parameters

168: -- Insert any route parameters
169: --
170: IF p_param_name1 is not null THEN
171: --
172: INSERT INTO ff_route_parameters
173: (route_parameter_id,
174: route_id,
175: sequence_no,
176: parameter_name,

Line 179: (ff_route_parameters_s.nextval,

175: sequence_no,
176: parameter_name,
177: data_type)
178: VALUES
179: (ff_route_parameters_s.nextval,
180: l_route_id,
181: 1,
182: p_param_name1,
183: p_param_type1);

Line 189: INSERT INTO ff_route_parameters

185: END IF;
186: --
187: IF p_param_name2 is not null THEN
188: --
189: INSERT INTO ff_route_parameters
190: (route_parameter_id,
191: route_id,
192: sequence_no,
193: parameter_name,

Line 196: (ff_route_parameters_s.nextval,

192: sequence_no,
193: parameter_name,
194: data_type)
195: VALUES
196: (ff_route_parameters_s.nextval,
197: l_route_id,
198: 1,
199: p_param_name2,
200: p_param_type2);

Line 248: FROM ff_route_parameters

244: value)
245: SELECT route_parameter_id,
246: l_user_entity_id,
247: p_param_value1
248: FROM ff_route_parameters
249: where route_id = l_route_id
250: and sequence_no = 1;
251: --
252: END IF;

Line 263: FROM ff_route_parameters

259: value)
260: SELECT route_parameter_id,
261: l_user_entity_id,
262: p_param_value2
263: FROM ff_route_parameters
264: where route_id = l_route_id
265: and sequence_no = 2;
266: --
267: END IF;