[Home] [Help]
79: sequence_no,
80: parameter_name,
81: data_type,
82: route_parameter_id)
83: select ff_routes_s.currval,
84: p_sequence_no,
85: p_parameter_name,
86: p_data_type,
87: ff_route_parameters_s.nextval
100: insert into ff_route_context_usages
101: (route_id,
102: context_id,
103: sequence_no)
104: select ff_routes_s.currval,
105: p_context_id,
106: p_sequence_no
107: from dual;
108: end insert_route_context_usages;
171: AND BCONTR.coverage_type(+) = EEV2.screen_entry_value
172: AND upper(INPUTV2.name) = ''COVERAGE''';
173: --
174: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 5);
175: select ff_routes_s.nextval
176: into l_temp
177: from dual;
178: --
179: -- now do the normal insert
178: --
179: -- now do the normal insert
180: --
181: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 6);
182: insert into ff_routes
183: (route_id,
184: route_name,
185: user_defined_flag,
186: description,
189: last_updated_by,
190: last_update_login,
191: created_by,
192: creation_date)
193: values (ff_routes_s.currval,
194: 'US_CONTRIBUTION_VALUES',
195: 'N',
196: 'route for contribution values using benefit contributions',
197: l_text,
244: --
245: hr_utility.set_location ('pay_us_contr_dbi.get_route', 1);
246: SELECT route_id
247: INTO l_route_id
248: FROM ff_routes
249: WHERE route_name = p_route_name;
250: --
251: return(l_route_id);
252: --