[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
1209:
1210:
1211: select pay_element_types_s.nextval
1212: into l_new_element_type_id
1213: from dual;
1214:
1215: v_new_element_type_flag := 'Y';
1216:
1217: WHEN TOO_MANY_ROWS THEN
1279: EXCEPTION WHEN NO_DATA_FOUND THEN
1280: -- New input value, so new get new _id
1281: select pay_input_values_s.nextval
1282: into v_new_input_id
1283: from dual;
1284:
1285: v_new_input_value_flag := 'Y';
1286:
1287: WHEN TOO_MANY_ROWS THEN
1323: FOR s_class IN sub_rules(r_distinct.c_surrogate_key) LOOP
1324:
1325: select pay_sub_classification_rules_s.nextval
1326: into v_new_sub_class_id
1327: from dual;
1328:
1329: update hr_s_sub_classn_rules_f
1330: set sub_classification_rule_id = v_new_sub_class_id
1331: , element_type_id = l_new_element_type_id
1413: -- New input value, so new get new _id
1414:
1415: select pay_status_processing_rules_s.nextval
1416: into v_new_spr_id
1417: from dual;
1418:
1419: WHEN TOO_MANY_ROWS THEN
1420: hr_legislation.hrrunprc_trace_on;
1421: hr_utility.trace('sel pay_status_processing_rules TMR');
1436: FOR results IN d_frrs(sprs.s_rule_id) LOOP
1437:
1438: select pay_formula_Result_rules_s.nextval
1439: into v_new_frr_id
1440: from dual;
1441:
1442: update hr_s_formula_result_rules_f
1443: set formula_result_rule_id = v_new_frr_id
1444: , status_processing_rule_id = v_new_spr_id
1556: if l_iv_exists = TRUE then
1557:
1558: select 1
1559: into l_null_return
1560: from dual
1561: where exists
1562: (select /*+ ORDERED INDEX(a PAY_RUN_RESULTS_PK)
1563: USE_NL(a b c) */ null
1564: from pay_run_result_values v
1574: else
1575:
1576: select 1
1577: into l_null_return
1578: from dual
1579: where exists
1580: (select null
1581: from pay_run_results a
1582: , pay_assignment_actions b
1828: --if exception raised then this row is not needed
1829: if (r_distinct.legislation_subgroup is null) then
1830: select distinct null
1831: into l_null_Return
1832: from dual
1833: where exists (
1834: select null
1835: from hr_s_application_ownerships a
1836: , fnd_product_installations b
1844: (b.status in ('I', 'S') and c.application_short_name = 'PQP')));
1845: else
1846: select distinct null
1847: into l_null_Return
1848: from dual
1849: where exists (
1850: select null
1851: from hr_s_application_ownerships a
1852: , fnd_product_installations b
2812: from hr_s_element_sets;
2813:
2814: select pay_element_sets_s.nextval
2815: into v_sequence_number
2816: from dual;
2817:
2818: IF v_sequence_number
2819: BETWEEN v_min_delivered AND v_max_delivered
2820: THEN
2874:
2875:
2876: select pay_element_sets_s.nextval
2877: into l_new_surrogate_key
2878: from dual;
2879:
2880: WHEN TOO_MANY_ROWS THEN
2881:
2882: hr_legislation.hrrunprc_trace_on;
2965:
2966:
2967: select null --if exception raised then this row is not needed
2968: into l_null_return
2969: from dual
2970: where exists
2971: (select null
2972: from hr_s_application_ownerships a
2973: , fnd_product_installations b
3413: from hr_s_user_tables;
3414:
3415: select pay_user_tables_s.nextval
3416: into v_sequence_number
3417: from dual;
3418:
3419: IF v_sequence_number
3420: BETWEEN v_min_delivered AND v_max_delivered
3421: THEN
3476:
3477:
3478: select pay_user_tables_s.nextval
3479: into l_new_surrogate_key
3480: from dual;
3481:
3482: WHEN TOO_MANY_ROWS THEN
3483: hr_legislation.hrrunprc_trace_on;
3484: hr_utility.trace('sel pay_user_tables TMR');
3560: -- If exception raised below then this row is not needed
3561: if (stu_rec.c_leg_sgrp is null) then
3562: select null
3563: into l_null_return
3564: from dual
3565: where exists
3566: (select null
3567: from hr_s_application_ownerships a
3568: , fnd_product_installations b
3576: (b.status in ('I', 'S') and c.application_short_name = 'PQP')));
3577: else
3578: select null
3579: into l_null_return
3580: from dual
3581: where exists
3582: (select null
3583: from hr_s_application_ownerships a
3584: , fnd_product_installations b
3926: from hr_s_user_columns;
3927:
3928: select pay_user_columns_s.nextval
3929: into v_sequence_number
3930: from dual;
3931:
3932: IF v_sequence_number
3933: BETWEEN v_min_delivered AND v_max_delivered
3934: THEN
3994:
3995:
3996: select pay_user_columns_s.nextval
3997: into l_new_surrogate_key
3998: from dual;
3999:
4000: WHEN TOO_MANY_ROWS THEN
4001: hr_legislation.hrrunprc_trace_on;
4002: hr_utility.trace('sel pay_user_columns TMR');
4078: -- If exception raised below hen this row is not needed
4079: if (stu_rec.c_leg_sgrp is null) then
4080: select null
4081: into l_null_return
4082: from dual
4083: where exists
4084: (select null
4085: from hr_s_application_ownerships a
4086: , fnd_product_installations b
4094: (b.status in ('I', 'S') and c.application_short_name = 'PQP')));
4095: else
4096: select null
4097: into l_null_return
4098: from dual
4099: where exists
4100: (select null
4101: from hr_s_application_ownerships a
4102: , fnd_product_installations b