72: p_data_type in varchar2,
73: p_sequence_no in number
74: ) is
75: begin
76: hr_utility.set_location('pay_us_contr_dbi.insert_route_parameters', 1);
77: insert into ff_route_parameters
78: (route_id,
79: sequence_no,
80: parameter_name,
95: p_context_id in number,
96: p_sequence_no in number
97: ) is
98: begin
99: hr_utility.set_location('pay_us_contr_dbi.insert_route_context_usages', 1);
100: insert into ff_route_context_usages
101: (route_id,
102: context_id,
103: sequence_no)
112: BEGIN
113: --
114: -- get the context ids from the context table
115: --
116: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 1);
117: select context_id
118: into l_assign_id_context_id
119: from ff_contexts
120: where context_name = 'ASSIGNMENT_ID';
118: into l_assign_id_context_id
119: from ff_contexts
120: where context_name = 'ASSIGNMENT_ID';
121: --
122: hr_utility.set_location('pay_us_contr_dbi.create_usdbi_startup', 2);
123: select context_id
124: into l_date_earned_context_id
125: from ff_contexts
126: where context_name = 'DATE_EARNED';
170: AND BCONTR.effective_end_date(+)
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: --
177: from dual;
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,
241: l_route_id NUMBER;
242: --
243: BEGIN
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;
313: --
314: -- retrieve details of the input value and element type
315: --
316: begin
317: hr_utility.set_location ('pay_us_contr_dbi.create_contr_items', 1);
318: select ET.element_type_id,
319: replace (ltrim (rtrim (upper (ET.element_name))), ' ', '_'),
320: replace (ltrim (rtrim (upper (IV.name))), ' ', '_'),
321: IV.business_group_id,
372: -- Handle variable data type
373: --
374: l_text := 'min (' || p_start_string || l_text || p_end_string || ')';
375: --
376: hr_utility.set_location ('pay_us_contr_dbi.create_contr_items', 2);
377: create_item
378: (l_business_group_id
379: ,l_legislation_code
380: ,l_route_name