[Home] [Help]
151: from hr_s_element_classifications;
152:
153: select pay_element_classifications_s.nextval
154: into v_sequence_number
155: from dual;
156:
157: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered) THEN
158:
159: hr_legislation.munge_sequence('PAY_ELEMENT_CLASSIFICATIONS_S',
259:
260:
261: select pay_element_classifications_s.nextval
262: into l_new_surrogate_key
263: from dual;
264:
265: WHEN TOO_MANY_ROWS THEN
266:
267: hr_legislation.hrrunprc_trace_on;
370: -- If exception raised below then this row is not needed
371: if (stu_rec.c_leg_sgrp is null) then
372: select null
373: into l_null_return
374: from dual
375: where exists
376: (select null
377: from hr_s_application_ownerships a
378: , fnd_product_installations b
386: (b.status in ('I', 'S') and c.application_short_name = 'PQP')));
387: else
388: select null
389: into l_null_return
390: from dual
391: where exists
392: (select null
393: from hr_s_application_ownerships a
394: , fnd_product_installations b
994: from hr_s_element_types_f;
995:
996: select pay_element_types_s.nextval
997: into v_sequence_number
998: from dual;
999:
1000: WHILE v_sequence_number
1001: BETWEEN v_min_delivered AND v_max_delivered
1002: LOOP
1003:
1004:
1005: select pay_element_types_s.nextval
1006: into v_sequence_number
1007: from dual;
1008:
1009: END LOOP;
1010:
1011: --Now check input values
1018: from hr_s_input_values_f;
1019:
1020: select pay_input_Values_s.nextval
1021: into v_sequence_number
1022: from dual;
1023:
1024: IF v_sequence_number
1025: BETWEEN v_min_delivered AND v_max_delivered
1026: THEN
1040: from hr_s_status_processing_rules_f;
1041:
1042: select pay_status_processing_rules_s.nextval
1043: into v_sequence_number
1044: from dual;
1045:
1046: IF v_sequence_number
1047: BETWEEN v_min_delivered AND v_max_delivered
1048: THEN
1062: from hr_s_formula_result_rules_f;
1063:
1064: select pay_formula_result_rules_s.nextval
1065: into v_sequence_number
1066: from dual;
1067:
1068: IF v_sequence_number
1069: BETWEEN v_min_delivered AND v_max_delivered
1070: THEN
1085: from hr_s_sub_classn_rules_f;
1086:
1087: select pay_sub_classification_rules_s.nextval
1088: into v_sequence_number
1089: from dual;
1090:
1091: IF v_sequence_number
1092: BETWEEN v_min_delivered AND v_max_delivered
1093: THEN
1196:
1197:
1198: select pay_element_types_s.nextval
1199: into l_new_element_type_id
1200: from dual;
1201:
1202: v_new_element_type_flag := 'Y';
1203:
1204: WHEN TOO_MANY_ROWS THEN
1258: EXCEPTION WHEN NO_DATA_FOUND THEN
1259: -- New input value, so new get new _id
1260: select pay_input_values_s.nextval
1261: into v_new_input_id
1262: from dual;
1263:
1264: v_new_input_value_flag := 'Y';
1265:
1266: WHEN TOO_MANY_ROWS THEN
1302: FOR s_class IN sub_rules(r_distinct.c_surrogate_key) LOOP
1303:
1304: select pay_sub_classification_rules_s.nextval
1305: into v_new_sub_class_id
1306: from dual;
1307:
1308: update hr_s_sub_classn_rules_f
1309: set sub_classification_rule_id = v_new_sub_class_id
1310: , element_type_id = l_new_element_type_id
1392: -- New input value, so new get new _id
1393:
1394: select pay_status_processing_rules_s.nextval
1395: into v_new_spr_id
1396: from dual;
1397:
1398: WHEN TOO_MANY_ROWS THEN
1399: hr_legislation.hrrunprc_trace_on;
1400: hr_utility.trace('sel pay_status_processing_rules TMR');
1415: FOR results IN d_frrs(sprs.s_rule_id) LOOP
1416:
1417: select pay_formula_Result_rules_s.nextval
1418: into v_new_frr_id
1419: from dual;
1420:
1421: update hr_s_formula_result_rules_f
1422: set formula_result_rule_id = v_new_frr_id
1423: , status_processing_rule_id = v_new_spr_id
1535: if l_iv_exists = TRUE then
1536:
1537: select 1
1538: into l_null_return
1539: from dual
1540: where exists
1541: (select /*+ ORDERED INDEX(a PAY_RUN_RESULTS_PK)
1542: USE_NL(a b c) */ null
1543: from pay_run_result_values v
1553: else
1554:
1555: select 1
1556: into l_null_return
1557: from dual
1558: where exists
1559: (select null
1560: from pay_run_results a
1561: , pay_assignment_actions b
1807: --if exception raised then this row is not needed
1808: if (r_distinct.legislation_subgroup is null) then
1809: select distinct null
1810: into l_null_Return
1811: from dual
1812: where exists (
1813: select null
1814: from hr_s_application_ownerships a
1815: , fnd_product_installations b
1823: (b.status in ('I', 'S') and c.application_short_name = 'PQP')));
1824: else
1825: select distinct null
1826: into l_null_Return
1827: from dual
1828: where exists (
1829: select null
1830: from hr_s_application_ownerships a
1831: , fnd_product_installations b
2780: from hr_s_element_sets;
2781:
2782: select pay_element_sets_s.nextval
2783: into v_sequence_number
2784: from dual;
2785:
2786: IF v_sequence_number
2787: BETWEEN v_min_delivered AND v_max_delivered
2788: THEN
2842:
2843:
2844: select pay_element_sets_s.nextval
2845: into l_new_surrogate_key
2846: from dual;
2847:
2848: WHEN TOO_MANY_ROWS THEN
2849:
2850: hr_legislation.hrrunprc_trace_on;
2933:
2934:
2935: select null --if exception raised then this row is not needed
2936: into l_null_return
2937: from dual
2938: where exists
2939: (select null
2940: from hr_s_application_ownerships a
2941: , fnd_product_installations b
3381: from hr_s_user_tables;
3382:
3383: select pay_user_tables_s.nextval
3384: into v_sequence_number
3385: from dual;
3386:
3387: IF v_sequence_number
3388: BETWEEN v_min_delivered AND v_max_delivered
3389: THEN
3444:
3445:
3446: select pay_user_tables_s.nextval
3447: into l_new_surrogate_key
3448: from dual;
3449:
3450: WHEN TOO_MANY_ROWS THEN
3451: hr_legislation.hrrunprc_trace_on;
3452: hr_utility.trace('sel pay_user_tables TMR');
3528: -- If exception raised below then this row is not needed
3529: if (stu_rec.c_leg_sgrp is null) then
3530: select null
3531: into l_null_return
3532: from dual
3533: where exists
3534: (select null
3535: from hr_s_application_ownerships a
3536: , fnd_product_installations b
3544: (b.status in ('I', 'S') and c.application_short_name = 'PQP')));
3545: else
3546: select null
3547: into l_null_return
3548: from dual
3549: where exists
3550: (select null
3551: from hr_s_application_ownerships a
3552: , fnd_product_installations b
3894: from hr_s_user_columns;
3895:
3896: select pay_user_columns_s.nextval
3897: into v_sequence_number
3898: from dual;
3899:
3900: IF v_sequence_number
3901: BETWEEN v_min_delivered AND v_max_delivered
3902: THEN
3962:
3963:
3964: select pay_user_columns_s.nextval
3965: into l_new_surrogate_key
3966: from dual;
3967:
3968: WHEN TOO_MANY_ROWS THEN
3969: hr_legislation.hrrunprc_trace_on;
3970: hr_utility.trace('sel pay_user_columns TMR');
4046: -- If exception raised below hen this row is not needed
4047: if (stu_rec.c_leg_sgrp is null) then
4048: select null
4049: into l_null_return
4050: from dual
4051: where exists
4052: (select null
4053: from hr_s_application_ownerships a
4054: , fnd_product_installations b
4062: (b.status in ('I', 'S') and c.application_short_name = 'PQP')));
4063: else
4064: select null
4065: into l_null_return
4066: from dual
4067: where exists
4068: (select null
4069: from hr_s_application_ownerships a
4070: , fnd_product_installations b