[Home] [Help]
91: , qualifying_event_id c_surrogate_key
92: , qualifying_event c_true_key
93: , legislation_code c_leg_code
94: , legislation_subgroup c_leg_sgrp
95: from hr_s_cobra_qfying_events_f
96: group by qualifying_event_id
97: , qualifying_event
98: , legislation_code
99: , legislation_subgroup;
105: -- This cursor accepts the primary key as a parameter and selects all
106: -- date effective rows for it.
107:
108: select *
109: from hr_s_cobra_qfying_events_f
110: where qualifying_event_id = pc_qualifying_event_id;
111:
112: -- These records are defined here so all sub procedures may use the
113: -- values selected. This saves the need for all sub procedures to have
154: into l_null_return
155: from per_cobra_qfying_events_f a
156: where exists
157: (select null
158: from hr_s_cobra_qfying_events_f b
159: where a.qualifying_event_id = b.qualifying_event_id
160: );
161:
162: --conflict may exist
161:
162: --conflict may exist
163: --update all qualifying_event_id's to remove conflict
164:
165: update hr_s_cobra_qfying_events_f
166: set qualifying_event_id = qualifying_event_id - 50000000;
167:
168: update hr_s_application_ownerships
169: set key_value = key_value - 50000000
178: select min(qualifying_event_id) - (count(*) *3)
179: , max(qualifying_event_id) + (count(*) *3)
180: into v_min_delivered
181: , v_max_delivered
182: from hr_s_cobra_qfying_events_f;
183:
184: select per_cobra_qfying_events_s.nextval
185: into v_sequence_number
186: from dual;
228:
229: BEGIN
230:
231:
232: delete from hr_s_cobra_qfying_events_f
233: where qualifying_event_id = v_id;
234:
235: END remove;
236:
271:
272:
273: END;
274:
275: update hr_s_cobra_qfying_events_f
276: set qualifying_event_id = l_new_cqe_id
277: where qualifying_event_id = r_distinct.c_surrogate_key;
278:
279: update hr_s_application_ownerships