[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;
1552:
1553:
1554: select null --if exception raised then this row is not needed
1555: into l_null_return
1556: from dual
1557: where exists (select null
1558: from hr_s_application_ownerships a
1559: , fnd_product_installations b
1560: , fnd_application c
1636: -- not imported by a later hdt
1637: begin
1638: select null
1639: into l_dummy
1640: from dual
1641: where not exists
1642: ((
1643: select effective_start_date,
1644: effective_end_date,
2124: from hr_s_routes;
2125:
2126: select ff_routes_s.nextval
2127: into v_sequence_number
2128: from dual;
2129:
2130: IF v_sequence_number
2131: BETWEEN v_min_delivered AND v_max_delivered THEN
2132:
2146: from hr_s_user_entities;
2147:
2148: select ff_user_entities_s.nextval
2149: into v_sequence_number
2150: from dual;
2151:
2152: IF v_sequence_number
2153: BETWEEN v_min_delivered AND v_max_delivered THEN
2154:
2168: from hr_s_route_parameters;
2169:
2170: select ff_route_parameters_s.nextval
2171: into v_sequence_number
2172: from dual;
2173:
2174: IF v_sequence_number
2175: BETWEEN v_min_delivered AND v_max_delivered THEN
2176:
2215:
2216:
2217: select ff_routes_s.nextval
2218: into l_new_surrogate_key
2219: from dual;
2220:
2221: WHEN TOO_MANY_ROWS THEN
2222: hr_legislation.hrrunprc_trace_on;
2223: hr_utility.trace('sel route ff_routes TMR');
2288: where route_id = l_new_surrogate_key;
2289:
2290: select ff_route_parameters_s.nextval
2291: into l_new_parameter_id
2292: from dual;
2293:
2294: WHEN TOO_MANY_ROWS THEN
2295:
2296: hr_legislation.hrrunprc_trace_on;
2333: EXCEPTION WHEN NO_DATA_FOUND THEN
2334:
2335: select ff_user_entities_s.nextval
2336: into l_new_entity_id
2337: from dual;
2338:
2339: WHEN TOO_MANY_ROWS THEN
2340: hr_legislation.hrrunprc_trace_on;
2341: hr_utility.trace('sel ff_user_entities TMR');
2412: IS
2413: -- Test ownership of this current row
2414: cursor get_application_ownerships is
2415: select null
2416: from dual
2417: where exists
2418: (select null
2419: from hr_s_application_ownerships a
2420: , fnd_product_installations b
2586: BEGIN
2587:
2588: select null
2589: into l_null_return
2590: from dual
2591: where exists
2592: ((select
2593: BUSINESS_GROUP_ID,
2594: LEGISLATION_CODE,
3497:
3498:
3499: select ff_functions_s.nextval
3500: into l_new_surrogate_key
3501: from dual;
3502:
3503:
3504: BEGIN
3505: insert into ff_functions
3792: from hr_s_qp_reports;
3793:
3794: select ff_qp_reports_s.nextval
3795: into v_sequence_number
3796: from dual;
3797:
3798: IF v_sequence_number
3799: BETWEEN v_min_delivered AND v_max_delivered THEN
3800:
3827: EXCEPTION WHEN NO_DATA_FOUND THEN
3828:
3829: select ff_qp_reports_s.nextval
3830: into l_new_surrogate_key
3831: from dual;
3832:
3833: END;
3834:
3835: -- Update all child entities
3896: -- If exception raised below then this row is not needed
3897: -- get rid of subgrp table, not even using it!
3898: select null
3899: into l_null_return
3900: from dual
3901: where exists
3902: (select null
3903: from hr_s_application_ownerships a
3904: , fnd_product_installations b
4405: from hr_s_globals_f;
4406:
4407: select ff_globals_s.nextval
4408: into v_sequence_number
4409: from dual;
4410:
4411: IF v_sequence_number
4412: BETWEEN v_min_delivered AND v_max_delivered THEN
4413:
4447:
4448:
4449: select ff_globals_s.nextval
4450: into l_new_global_id
4451: from dual;
4452:
4453: WHEN TOO_MANY_ROWS THEN
4454: hr_legislation.hrrunprc_trace_on;
4455: hr_utility.trace('sel ff_globals_f TMR');
4597:
4598:
4599: select null
4600: into l_null_return
4601: from dual
4602: where exists (select null from hr_s_application_ownerships a
4603: , fnd_product_installations b
4604: , fnd_application c
4605: where a.key_name = 'GLOBAL_ID'