[Home] [Help]
206: from hr_s_contexts;
207:
208: select ff_contexts_s.nextval
209: into v_sequence_number
210: from dual;
211:
212: IF v_sequence_number
213: BETWEEN v_min_delivered AND v_max_delivered THEN
214:
241:
242:
243: select ff_contexts_s.nextval
244: into l_new_surrogate_key
245: from dual;
246:
247: END;
248:
249: -- Update all child entities
326: END IF;
327:
328: select null --if exception raised then this row is not needed
329: into l_null_return
330: from dual
331: where exists (
332: select null
333: from hr_s_application_ownerships a
334: , fnd_product_installations b
607: from hr_s_formula_types;
608:
609: select ff_formula_types_s.nextval
610: into v_sequence_number
611: from dual;
612:
613: IF v_sequence_number
614: BETWEEN v_min_delivered AND v_max_delivered THEN
615:
639: EXCEPTION WHEN NO_DATA_FOUND THEN
640:
641: select ff_formula_types_s.nextval
642: into l_new_surrogate_key
643: from dual;
644:
645: WHEN TOO_MANY_ROWS THEN
646: hr_legislation.hrrunprc_trace_on;
647: hr_utility.trace('multiple ftype ' || stu_rec.c_true_key);
694: IS
695: --
696: CURSOR c_fft2 IS
697: select null --if exception raised then this row is not needed
698: from dual
699: where exists (
700: select null
701: from hr_s_application_ownerships a
702: , fnd_product_installations b
717: -- so eleiminating the need for formula invalidation.
718: -- new version. Only need for live to not be a superset of HR_S
719: CURSOR c_fft3 IS
720: select 1
721: from dual
722: where exists
723: (select hfcu.context_id
724: from hr_s_ftype_context_usages hfcu
725: where hfcu.formula_type_id = l_new_surrogate_key
1195: from hr_s_formulas_f;
1196:
1197: select ff_formulas_s.nextval
1198: into v_sequence_number
1199: from dual;
1200:
1201: IF v_sequence_number
1202: BETWEEN v_min_delivered AND v_max_delivered THEN
1203:
1238:
1239:
1240: select ff_formulas_s.nextval
1241: into l_new_formula_id
1242: from dual;
1243:
1244: WHEN TOO_MANY_ROWS THEN
1245:
1246: hr_legislation.hrrunprc_trace_on;
1566:
1567:
1568: select null --if exception raised then this row is not needed
1569: into l_null_return
1570: from dual
1571: where exists (select null
1572: from hr_s_application_ownerships a
1573: , fnd_product_installations b
1574: , fnd_application c
1650: -- not imported by a later hdt
1651: begin
1652: select null
1653: into l_dummy
1654: from dual
1655: where not exists
1656: ((
1657: select effective_start_date,
1658: effective_end_date,
2140: from hr_s_routes;
2141:
2142: select ff_routes_s.nextval
2143: into v_sequence_number
2144: from dual;
2145:
2146: IF v_sequence_number
2147: BETWEEN v_min_delivered AND v_max_delivered THEN
2148:
2162: from hr_s_user_entities;
2163:
2164: select ff_user_entities_s.nextval
2165: into v_sequence_number
2166: from dual;
2167:
2168: IF v_sequence_number
2169: BETWEEN v_min_delivered AND v_max_delivered THEN
2170:
2184: from hr_s_route_parameters;
2185:
2186: select ff_route_parameters_s.nextval
2187: into v_sequence_number
2188: from dual;
2189:
2190: IF v_sequence_number
2191: BETWEEN v_min_delivered AND v_max_delivered THEN
2192:
2231:
2232:
2233: select ff_routes_s.nextval
2234: into l_new_surrogate_key
2235: from dual;
2236:
2237: WHEN TOO_MANY_ROWS THEN
2238: hr_legislation.hrrunprc_trace_on;
2239: hr_utility.trace('sel route ff_routes TMR');
2304: where route_id = l_new_surrogate_key;
2305:
2306: select ff_route_parameters_s.nextval
2307: into l_new_parameter_id
2308: from dual;
2309:
2310: WHEN TOO_MANY_ROWS THEN
2311:
2312: hr_legislation.hrrunprc_trace_on;
2359: EXCEPTION WHEN NO_DATA_FOUND THEN
2360:
2361: select ff_user_entities_s.nextval
2362: into l_new_entity_id
2363: from dual;
2364:
2365: WHEN TOO_MANY_ROWS THEN
2366: hr_legislation.hrrunprc_trace_on;
2367: hr_utility.trace('sel ff_user_entities TMR');
2438: IS
2439: -- Test ownership of this current row
2440: cursor get_application_ownerships is
2441: select null
2442: from dual
2443: where exists
2444: (select null
2445: from hr_s_application_ownerships a
2446: , fnd_product_installations b
2627: BEGIN
2628:
2629: select null
2630: into l_null_return
2631: from dual
2632: where exists
2633: ((select
2634: BUSINESS_GROUP_ID,
2635: LEGISLATION_CODE,
3548:
3549:
3550: select ff_functions_s.nextval
3551: into l_new_surrogate_key
3552: from dual;
3553:
3554:
3555: BEGIN
3556: insert into ff_functions
3843: from hr_s_qp_reports;
3844:
3845: select ff_qp_reports_s.nextval
3846: into v_sequence_number
3847: from dual;
3848:
3849: IF v_sequence_number
3850: BETWEEN v_min_delivered AND v_max_delivered THEN
3851:
3878: EXCEPTION WHEN NO_DATA_FOUND THEN
3879:
3880: select ff_qp_reports_s.nextval
3881: into l_new_surrogate_key
3882: from dual;
3883:
3884: END;
3885:
3886: -- Update all child entities
3947: -- If exception raised below then this row is not needed
3948: -- get rid of subgrp table, not even using it!
3949: select null
3950: into l_null_return
3951: from dual
3952: where exists
3953: (select null
3954: from hr_s_application_ownerships a
3955: , fnd_product_installations b
4456: from hr_s_globals_f;
4457:
4458: select ff_globals_s.nextval
4459: into v_sequence_number
4460: from dual;
4461:
4462: IF v_sequence_number
4463: BETWEEN v_min_delivered AND v_max_delivered THEN
4464:
4498:
4499:
4500: select ff_globals_s.nextval
4501: into l_new_global_id
4502: from dual;
4503:
4504: WHEN TOO_MANY_ROWS THEN
4505: hr_legislation.hrrunprc_trace_on;
4506: hr_utility.trace('sel ff_globals_f TMR');
4648:
4649:
4650: select null
4651: into l_null_return
4652: from dual
4653: where exists (select null from hr_s_application_ownerships a
4654: , fnd_product_installations b
4655: , fnd_application c
4656: where a.key_name = 'GLOBAL_ID'