APPS.PAY_DATABASE_ITEMS_PKG dependencies on FF_ROUTE_PARAMETERS

Line 174: INSERT INTO ff_route_parameters

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

Line 181: (ff_route_parameters_s.nextval,

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

Line 191: INSERT INTO ff_route_parameters

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

Line 198: (ff_route_parameters_s.nextval,

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

Line 250: FROM ff_route_parameters

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

Line 265: FROM ff_route_parameters

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