eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_LEGISLATION

Line 1: PACKAGE body hr_legislation_elements AS

1: PACKAGE body hr_legislation_elements AS
2: /* $Header: pelegele.pkb 120.8.12020000.3 2013/03/06 16:13:14 divicker ship $ */
3: --****************************************************************************
4: -- INSTALLATION PROCEDURE FOR : PAY_ELEMENT_CLASSIFICATIONS
5: --****************************************************************************

Line 61: hr_legislation.insert_hr_stu_exceptions('pay_element_classifications'

57: -- not be raised more than once.
58:
59: rollback to new_classification_name;
60:
61: hr_legislation.insert_hr_stu_exceptions('pay_element_classifications'
62: , stu_rec.c_surrogate_key
63: , exception_type
64: , stu_rec.c_true_key);
65:

Line 159: hr_legislation.munge_sequence('PAY_ELEMENT_CLASSIFICATIONS_S',

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',
160: v_sequence_number,
161: v_max_delivered);
162: END IF;
163:

Line 267: hr_legislation.hrrunprc_trace_on;

263: from dual;
264:
265: WHEN TOO_MANY_ROWS THEN
266:
267: hr_legislation.hrrunprc_trace_on;
268: hr_utility.trace('sel pay_element_classifications TMR');
269:
270: hr_utility.trace('classification_name ' ||
271: stu_rec.c_true_key);

Line 274: hr_legislation.hrrunprc_trace_off;

270: hr_utility.trace('classification_name ' ||
271: stu_rec.c_true_key);
272: hr_utility.trace(':lc: ' || ':' ||
273: stu_rec.c_leg_code || ':');
274: hr_legislation.hrrunprc_trace_off;
275: raise;
276: END;
277:
278: -- Update all child entities

Line 403: and exists (select null from hr_legislation_subgroups d

399: and c.application_id = b.application_id
400: and ((b.status = 'I' and c.application_short_name <> 'PQP')
401: or
402: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
403: and exists (select null from hr_legislation_subgroups d
404: where d.legislation_code = stu_rec.c_leg_code
405: and d.legislation_subgroup = stu_rec.c_leg_sgrp
406: and d.active_inactive_flag = 'A'
407: );

Line 604: hr_legislation.hrrunprc_trace_on;

600: ,stu_rec.creation_date
601: ,stu_rec.balance_initialization_flag
602: ,stu_rec.FREQ_RULE_ENABLED);
603: EXCEPTION WHEN OTHERS THEN
604: hr_legislation.hrrunprc_trace_on;
605: hr_utility.trace('ins pay_element_classifications');
606: hr_utility.trace('classification_name ' ||
607: stu_rec.c_true_key);
608: hr_utility.trace('classification_id ' ||

Line 612: hr_legislation.hrrunprc_trace_off;

608: hr_utility.trace('classification_id ' ||
609: to_char(stu_rec.c_surrogate_key));
610: hr_utility.trace(':lc: ' || ':' ||
611: stu_rec.c_leg_code || ':');
612: hr_legislation.hrrunprc_trace_off;
613: raise;
614: END;
615:
616: END IF;

Line 689: l_current_proc varchar2(80) := 'hr_legislation.install_elements';

685: -- input values, defined for the element, in the delivered tables and
686: -- the live tables.
687:
688: row_in_error exception;
689: l_current_proc varchar2(80) := 'hr_legislation.install_elements';
690: l_new_element_type_id number(15);
691: l_null_return varchar2(1);
692: l_payroll_install_status varchar2 (1);
693: l_formula_id number (15);

Line 1028: hr_legislation.munge_sequence('PAY_INPUT_VALUES_S',

1024: IF v_sequence_number
1025: BETWEEN v_min_delivered AND v_max_delivered
1026: THEN
1027:
1028: hr_legislation.munge_sequence('PAY_INPUT_VALUES_S',
1029: v_sequence_number,
1030: v_max_delivered);
1031:
1032: END IF;

Line 1050: hr_legislation.munge_sequence('PAY_STATUS_PROCESSING_RULES_S',

1046: IF v_sequence_number
1047: BETWEEN v_min_delivered AND v_max_delivered
1048: THEN
1049:
1050: hr_legislation.munge_sequence('PAY_STATUS_PROCESSING_RULES_S',
1051: v_sequence_number,
1052: v_max_delivered);
1053:
1054: END IF;

Line 1072: hr_legislation.munge_sequence('PAY_FORMULA_RESULT_RULES_S',

1068: IF v_sequence_number
1069: BETWEEN v_min_delivered AND v_max_delivered
1070: THEN
1071:
1072: hr_legislation.munge_sequence('PAY_FORMULA_RESULT_RULES_S',
1073: v_sequence_number,
1074: v_max_delivered);
1075:
1076: END IF;

Line 1095: hr_legislation.munge_sequence('PAY_SUB_CLASSIFICATION_RULES_S',

1091: IF v_sequence_number
1092: BETWEEN v_min_delivered AND v_max_delivered
1093: THEN
1094:
1095: hr_legislation.munge_sequence('PAY_SUB_CLASSIFICATION_RULES_S',
1096: v_sequence_number,
1097: v_max_delivered);
1098:
1099: END IF;

Line 1124: hr_legislation.insert_hr_stu_exceptions('pay_element_types_f'

1120: ELSE
1121: rollback to new_distinct_id;
1122: END IF;
1123:
1124: hr_legislation.insert_hr_stu_exceptions('pay_element_types_f'
1125: , r_distinct.c_surrogate_key
1126: , exception_type
1127: , r_distinct.c_true_key);
1128:

Line 1185: IF hr_legislation.g_pseudo_enabled = 'Y' THEN

1181: -- be updated, as must all child references to the old surrogate uid.
1182:
1183: --PSEUDO
1184: -- Error if we clash on delivered data to pseudo data present
1185: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
1186: BEGIN
1187: -- Check if we have a pseduo seed clash if enabled
1188: -- Error handling is done in the procedure itself
1189: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => r_distinct.c_true_key,

Line 1189: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => r_distinct.c_true_key,

1185: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
1186: BEGIN
1187: -- Check if we have a pseduo seed clash if enabled
1188: -- Error handling is done in the procedure itself
1189: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => r_distinct.c_true_key,
1190: P_TABLE_NAME => 'PAY_ELEMENT_TYPES_F',
1191: P_LEGISLATION_CODE => r_distinct.legislation_code);
1192: EXCEPTION WHEN OTHERS THEN
1193: raise;

Line 1218: hr_legislation.hrrunprc_trace_on;

1214:
1215: v_new_element_type_flag := 'Y';
1216:
1217: WHEN TOO_MANY_ROWS THEN
1218: hr_legislation.hrrunprc_trace_on;
1219: hr_utility.trace('sel pay_element_types_f TMR');
1220: hr_utility.trace('element_name ' ||
1221: r_distinct.c_true_key);
1222: hr_utility.trace(':lc: ' || ':' ||

Line 1224: hr_legislation.hrrunprc_trace_off;

1220: hr_utility.trace('element_name ' ||
1221: r_distinct.c_true_key);
1222: hr_utility.trace(':lc: ' || ':' ||
1223: r_distinct.legislation_code || ':');
1224: hr_legislation.hrrunprc_trace_off;
1225: raise;
1226: END;
1227:
1228: update hr_s_element_types_f

Line 1256: IF hr_legislation.g_pseudo_enabled = 'Y' THEN

1252: FOR i_vals IN inputs(r_distinct.c_surrogate_key) LOOP
1253:
1254: --PSEUDO
1255: -- Error if we clash on delivered data to pseudo data present
1256: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
1257: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => i_vals.name,
1258: P_TABLE_NAME => 'PAY_INPUT_VALUES_F',
1259: P_ADDL_SURROGATE_KEY_NAME1 => r_distinct.c_true_key,
1260: P_LEGISLATION_CODE => r_distinct.legislation_code);

Line 1257: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => i_vals.name,

1253:
1254: --PSEUDO
1255: -- Error if we clash on delivered data to pseudo data present
1256: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
1257: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => i_vals.name,
1258: P_TABLE_NAME => 'PAY_INPUT_VALUES_F',
1259: P_ADDL_SURROGATE_KEY_NAME1 => r_distinct.c_true_key,
1260: P_LEGISLATION_CODE => r_distinct.legislation_code);
1261: END IF;

Line 1288: hr_legislation.hrrunprc_trace_on;

1284:
1285: v_new_input_value_flag := 'Y';
1286:
1287: WHEN TOO_MANY_ROWS THEN
1288: hr_legislation.hrrunprc_trace_on;
1289: hr_utility.trace('sel pay_input_values_f TMR');
1290: hr_utility.trace('iv name ' ||
1291: i_vals.name);
1292: hr_utility.trace('element_type_id ' ||

Line 1296: hr_legislation.hrrunprc_trace_off;

1292: hr_utility.trace('element_type_id ' ||
1293: to_char(l_new_element_Type_id));
1294: hr_utility.trace('element_name ' ||
1295: r_distinct.c_true_key);
1296: hr_legislation.hrrunprc_trace_off;
1297: raise;
1298: END;
1299:
1300: update hr_s_input_values_f

Line 1420: hr_legislation.hrrunprc_trace_on;

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');
1422:
1423: hr_utility.trace('assignment_status_type_id ' ||
1424: to_char(sprs.assignment_status_type_id));

Line 1427: hr_legislation.hrrunprc_trace_off;

1423: hr_utility.trace('assignment_status_type_id ' ||
1424: to_char(sprs.assignment_status_type_id));
1425: hr_utility.trace(':lc: ' || ':' ||
1426: r_distinct.legislation_code || ':');
1427: hr_legislation.hrrunprc_trace_off;
1428: raise;
1429: END;
1430:
1431: update hr_s_status_processing_rules_f

Line 1863: from hr_legislation_subgroups d

1859: or
1860: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
1861: and exists
1862: (select null
1863: from hr_legislation_subgroups d
1864: where d.legislation_code = r_distinct.legislation_code
1865: and d.legislation_subgroup =
1866: r_distinct.legislation_subgroup
1867: and d.active_inactive_flag = 'A'

Line 1994: IF hr_legislation.g_pseudo_enabled = 'Y' THEN

1990: END;
1991:
1992: --PSEUDO
1993: -- Check to see if this will clash with pseudo seeded data only if enabled
1994: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
1995: -- PSEUDO CHECK
1996: -- Check if we have a pseudo seed clash if enabled
1997: -- Error handling is done in the procedure itself
1998: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => r_distinct.c_true_key,

Line 1998: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => r_distinct.c_true_key,

1994: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
1995: -- PSEUDO CHECK
1996: -- Check if we have a pseudo seed clash if enabled
1997: -- Error handling is done in the procedure itself
1998: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => r_distinct.c_true_key,
1999: P_TABLE_NAME => 'PAY_ELEMENT_TYPES_F',
2000: P_LEGISLATION_CODE => r_distinct.legislation_code);
2001: END IF;
2002:

Line 2127: hr_legislation.hrrunprc_trace_on;

2123: ,l_flex_value_set_id
2124: from hr_s_input_values_f
2125: where input_value_id = i_values.input_value_id;
2126: EXCEPTION WHEN OTHERS THEN
2127: hr_legislation.hrrunprc_trace_on;
2128: hr_utility.trace('ins pay_input_values_f');
2129: hr_utility.trace('iv id ' ||
2130: to_char(i_values.input_value_id));
2131: hr_utility.trace('iv name ' ||

Line 2133: hr_legislation.hrrunprc_trace_off;

2129: hr_utility.trace('iv id ' ||
2130: to_char(i_values.input_value_id));
2131: hr_utility.trace('iv name ' ||
2132: i_values.name);
2133: hr_legislation.hrrunprc_trace_off;
2134: raise;
2135: END;
2136:
2137: delete from hr_s_input_values_f

Line 2400: hr_legislation.hrrunprc_trace_on;

2396: ,each_row.TIME_DEFINITION_TYPE
2397: ,each_row.TIME_DEFINITION_ID
2398: );
2399: EXCEPTION WHEN OTHERS THEN
2400: hr_legislation.hrrunprc_trace_on;
2401: hr_utility.trace('ins pay_element_types_f');
2402: hr_utility.trace('element type name ' ||
2403: each_row.element_name);
2404: hr_utility.trace('element_type_id ' ||

Line 2408: hr_legislation.hrrunprc_trace_off;

2404: hr_utility.trace('element_type_id ' ||
2405: to_char(each_row.element_type_id));
2406: hr_utility.trace(':lc: ' || ':' ||
2407: each_row.legislation_code || ':');
2408: hr_legislation.hrrunprc_trace_off;
2409: raise;
2410: END;
2411:
2412: END LOOP each_row;

Line 2459: hr_legislation.hrrunprc_trace_on;

2455: ,s_rules.created_by
2456: ,s_rules.creation_date
2457: );
2458: EXCEPTION WHEN OTHERS THEN
2459: hr_legislation.hrrunprc_trace_on;
2460: hr_utility.trace('ins pay_sub_classification_rules_f');
2461: hr_utility.trace('sub_classification_rule_id ' ||
2462: to_char(s_rules.sub_classification_rule_id));
2463: hr_utility.trace('element_type_id ' ||

Line 2469: hr_legislation.hrrunprc_trace_off;

2465: hr_utility.trace('classification_id ' ||
2466: to_char(s_rules.classification_id));
2467: hr_utility.trace(':lc: ' || ':' ||
2468: s_rules.legislation_code || ':');
2469: hr_legislation.hrrunprc_trace_off;
2470: raise;
2471: END;
2472: --
2473: -- Bug 2888183 need to insert balances feeds

Line 2542: hr_legislation.hrrunprc_trace_on;

2538: ,all_rules.CREATED_BY
2539: ,all_rules.CREATION_DATE
2540: );
2541: EXCEPTION WHEN OTHERS THEN
2542: hr_legislation.hrrunprc_trace_on;
2543: hr_utility.trace('ins pay_status_processing_rules_f');
2544: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2545: to_char(all_rules.STATUS_PROCESSING_RULE_ID));
2546: hr_utility.trace('ELEMENT_TYPE_ID ' ||

Line 2554: hr_legislation.hrrunprc_trace_off;

2550: hr_utility.trace('ASSIGNMENT_STATUS_TYPE_ID ' ||
2551: to_char(all_rules.ASSIGNMENT_STATUS_TYPE_ID));
2552: hr_utility.trace(':lc: ' || ':' ||
2553: all_rules.legislation_code || ':');
2554: hr_legislation.hrrunprc_trace_off;
2555: raise;
2556: END;
2557:
2558:

Line 2603: hr_legislation.hrrunprc_trace_on;

2599: ,all_frrs.CREATED_BY
2600: ,all_frrs.CREATION_DATE
2601: );
2602: EXCEPTION WHEN OTHERS THEN
2603: hr_legislation.hrrunprc_trace_on;
2604: hr_utility.trace('ins pay_formula_result_rules_f');
2605: hr_utility.trace('FORMULA_RESULT_RULE_ID ' ||
2606: to_char(all_frrs.FORMULA_RESULT_RULE_ID));
2607: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||

Line 2613: hr_legislation.hrrunprc_trace_off;

2609: hr_utility.trace('RESULT_NAME ' ||
2610: all_frrs.RESULT_NAME);
2611: hr_utility.trace(':lc: ' || ':' ||
2612: all_frrs.legislation_code || ':');
2613: hr_legislation.hrrunprc_trace_off;
2614: raise;
2615: END;
2616:
2617: END LOOP all_frrs;

Line 2822: hr_legislation.munge_sequence('PAY_ELEMENT_SETS_S',

2818: IF v_sequence_number
2819: BETWEEN v_min_delivered AND v_max_delivered
2820: THEN
2821:
2822: hr_legislation.munge_sequence('PAY_ELEMENT_SETS_S',
2823: v_sequence_number,
2824: v_max_delivered);
2825:
2826: END IF;

Line 2847: hr_legislation.insert_hr_stu_exceptions('pay_element_sets'

2843:
2844:
2845: rollback to new_element_set_name;
2846:
2847: hr_legislation.insert_hr_stu_exceptions('pay_element_sets'
2848: , stu_rec.c_surrogate_key
2849: , exception_type
2850: , stu_rec.c_true_key);
2851:

Line 2882: hr_legislation.hrrunprc_trace_on;

2878: from dual;
2879:
2880: WHEN TOO_MANY_ROWS THEN
2881:
2882: hr_legislation.hrrunprc_trace_on;
2883: hr_utility.trace('sel pay_element_sets TMR');
2884: hr_utility.trace('element_set_name ' ||
2885: stu_rec.c_true_key);
2886: hr_utility.trace(':lc: ' || ':' ||

Line 2888: hr_legislation.hrrunprc_trace_off;

2884: hr_utility.trace('element_set_name ' ||
2885: stu_rec.c_true_key);
2886: hr_utility.trace(':lc: ' || ':' ||
2887: stu_rec.c_leg_code || ':');
2888: hr_legislation.hrrunprc_trace_off;
2889: raise;
2890: END;
2891:
2892: --update all child entities

Line 3141: hr_legislation.hrrunprc_trace_on;

3137: ,stu_rec.created_by
3138: ,stu_rec.creation_date
3139: );
3140: EXCEPTION WHEN OTHERS THEN
3141: hr_legislation.hrrunprc_trace_on;
3142: hr_utility.trace('ins pay_element_sets');
3143: hr_utility.trace('element_set_name ' ||
3144: stu_rec.c_true_key);
3145: hr_utility.trace('element_set_id ' ||

Line 3151: hr_legislation.hrrunprc_trace_off;

3147: hr_utility.trace('element_set_type ' ||
3148: stu_rec.element_set_type);
3149: hr_utility.trace(':lc: ' || ':' ||
3150: stu_rec.c_leg_code || ':');
3151: hr_legislation.hrrunprc_trace_off;
3152: raise;
3153: END;
3154:
3155: END IF;

Line 3190: hr_legislation.hrrunprc_trace_on;

3186: ,ele_types.last_update_login
3187: ,ele_types.created_by
3188: ,ele_types.creation_date);
3189: EXCEPTION WHEN OTHERS THEN
3190: hr_legislation.hrrunprc_trace_on;
3191: hr_utility.trace('ins pay_element_type_rules');
3192: hr_utility.trace('element_type_id ' ||
3193: to_char(ele_types.element_Type_id));
3194: hr_utility.trace('element_set_id ' ||

Line 3196: hr_legislation.hrrunprc_trace_off;

3192: hr_utility.trace('element_type_id ' ||
3193: to_char(ele_types.element_Type_id));
3194: hr_utility.trace('element_set_id ' ||
3195: to_char(ele_types.element_Set_id));
3196: hr_legislation.hrrunprc_trace_off;
3197: raise;
3198: END;
3199:
3200:

Line 3242: hr_legislation.hrrunprc_trace_on;

3238: ,ele_class.last_update_login
3239: ,ele_class.created_by
3240: ,ele_class.creation_date);
3241: EXCEPTION WHEN OTHERS THEN
3242: hr_legislation.hrrunprc_trace_on;
3243: hr_utility.trace('ins pay_ele_classification_rules');
3244: hr_utility.trace('element_set_id ' ||
3245: to_char(ele_class.element_set_id));
3246: hr_utility.trace('classification_id ' ||

Line 3248: hr_legislation.hrrunprc_trace_off;

3244: hr_utility.trace('element_set_id ' ||
3245: to_char(ele_class.element_set_id));
3246: hr_utility.trace('classification_id ' ||
3247: to_char(ele_class.classification_id));
3248: hr_legislation.hrrunprc_trace_off;
3249: raise;
3250: END;
3251:
3252: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 3423: hr_legislation.munge_sequence('PAY_USER_TABLES_S',

3419: IF v_sequence_number
3420: BETWEEN v_min_delivered AND v_max_delivered
3421: THEN
3422:
3423: hr_legislation.munge_sequence('PAY_USER_TABLES_S',
3424: v_sequence_number,
3425: v_max_delivered);
3426:
3427: END IF;

Line 3448: hr_legislation.insert_hr_stu_exceptions('pay_user_tables'

3444:
3445:
3446: rollback to new_user_table_name;
3447:
3448: hr_legislation.insert_hr_stu_exceptions('pay_user_tables'
3449: , stu_rec.c_surrogate_key
3450: , exception_type
3451: , stu_rec.c_true_key);
3452:

Line 3483: hr_legislation.hrrunprc_trace_on;

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');
3485: hr_utility.trace('user_table_name ' ||
3486: stu_rec.c_true_key);
3487: hr_utility.trace(':lc: ' || ':' ||

Line 3489: hr_legislation.hrrunprc_trace_off;

3485: hr_utility.trace('user_table_name ' ||
3486: stu_rec.c_true_key);
3487: hr_utility.trace(':lc: ' || ':' ||
3488: stu_rec.c_leg_code || ':');
3489: hr_legislation.hrrunprc_trace_off;
3490: raise;
3491:
3492: END;
3493:

Line 3593: and exists (select null from hr_legislation_subgroups d

3589: and c.application_id = b.application_id
3590: and ((b.status = 'I' and c.application_short_name <> 'PQP')
3591: or
3592: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
3593: and exists (select null from hr_legislation_subgroups d
3594: where d.legislation_code = stu_rec.c_leg_code
3595: and d.legislation_subgroup = stu_rec.c_leg_sgrp
3596: and d.active_inactive_flag = 'A'
3597: );

Line 3759: hr_legislation.hrrunprc_trace_on;

3755: ,stu_rec.creation_date
3756: ,stu_rec.user_row_title
3757: );
3758: EXCEPTION WHEN OTHERS THEN
3759: hr_legislation.hrrunprc_trace_on;
3760: hr_utility.trace('ins pay_user_tables');
3761: hr_utility.trace('user_table_id ' ||
3762: to_char(stu_rec.c_surrogate_key));
3763: hr_utility.trace('user_table_name ' ||

Line 3767: hr_legislation.hrrunprc_trace_off;

3763: hr_utility.trace('user_table_name ' ||
3764: stu_rec.c_true_key);
3765: hr_utility.trace(':lc: ' || ':' ||
3766: stu_rec.c_leg_code || ':');
3767: hr_legislation.hrrunprc_trace_off;
3768: raise;
3769: END;
3770:
3771: END IF;

Line 3936: hr_legislation.munge_sequence('PAY_USER_COLUMNS_S',

3932: IF v_sequence_number
3933: BETWEEN v_min_delivered AND v_max_delivered
3934: THEN
3935:
3936: hr_legislation.munge_sequence('PAY_USER_COLUMNS_S',
3937: v_sequence_number,
3938: v_max_delivered);
3939:
3940: END IF;

Line 3961: hr_legislation.insert_hr_stu_exceptions('pay_user_columns'

3957:
3958:
3959: rollback to new_user_column_name;
3960:
3961: hr_legislation.insert_hr_stu_exceptions('pay_user_columns'
3962: , stu_rec.c_surrogate_key
3963: , exception_type
3964: , stu_rec.c_true_key);
3965:

Line 4001: hr_legislation.hrrunprc_trace_on;

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');
4003: hr_utility.trace('user_column_name ' ||
4004: stu_rec.c_true_key);
4005: hr_utility.trace('user_table_id ' ||

Line 4009: hr_legislation.hrrunprc_trace_off;

4005: hr_utility.trace('user_table_id ' ||
4006: to_char(stu_rec.user_table_id));
4007: hr_utility.trace(':lc: ' || ':' ||
4008: stu_rec.c_leg_code || ':');
4009: hr_legislation.hrrunprc_trace_off;
4010: raise;
4011: END;
4012:
4013: -- Update all child entities

Line 4111: and exists (select null from hr_legislation_subgroups d

4107: and c.application_id = b.application_id
4108: and ((b.status = 'I' and c.application_short_name <> 'PQP')
4109: or
4110: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
4111: and exists (select null from hr_legislation_subgroups d
4112: where d.legislation_code = stu_rec.c_leg_code
4113: and d.legislation_subgroup = stu_rec.c_leg_sgrp
4114: and d.active_inactive_flag = 'A'
4115: );

Line 4410: hr_legislation.hrrunprc_trace_on;

4406: ,stu_rec.created_by
4407: ,stu_rec.creation_date
4408: );
4409: EXCEPTION WHEN OTHERS THEN
4410: hr_legislation.hrrunprc_trace_on;
4411: hr_utility.trace('ins pay_user_columns');
4412: hr_utility.trace('user_column_id ' ||
4413: to_char(stu_rec.c_surrogate_key));
4414: hr_utility.trace('user_column_name ' ||

Line 4420: hr_legislation.hrrunprc_trace_off;

4416: hr_utility.trace('user_table_id ' ||
4417: to_char(stu_rec.user_table_id));
4418: hr_utility.trace(':lc: ' || ':' ||
4419: stu_rec.c_leg_code || ':');
4420: hr_legislation.hrrunprc_trace_off;
4421: raise;
4422: END;
4423:
4424: END IF;

Line 4488: hr_legislation.hrrunprc_trace_on;

4484: BEGIN
4485:
4486: IF p_phase = 1 OR p_phase =2 THEN
4487:
4488: hr_legislation.hrrunprc_trace_on;
4489: hr_utility.trace('start install_ele_class: ' || to_char(p_phase));
4490: hr_legislation.hrrunprc_trace_off;
4491:
4492: install_ele_class(p_phase); --install element classifications

Line 4490: hr_legislation.hrrunprc_trace_off;

4486: IF p_phase = 1 OR p_phase =2 THEN
4487:
4488: hr_legislation.hrrunprc_trace_on;
4489: hr_utility.trace('start install_ele_class: ' || to_char(p_phase));
4490: hr_legislation.hrrunprc_trace_off;
4491:
4492: install_ele_class(p_phase); --install element classifications
4493:
4494: hr_legislation.hrrunprc_trace_on;

Line 4494: hr_legislation.hrrunprc_trace_on;

4490: hr_legislation.hrrunprc_trace_off;
4491:
4492: install_ele_class(p_phase); --install element classifications
4493:
4494: hr_legislation.hrrunprc_trace_on;
4495: hr_utility.trace('start install_elements: ' || to_char(p_phase));
4496: hr_legislation.hrrunprc_trace_off;
4497:
4498: install_elements(p_phase); --install elements,sprs,frrs,inputs

Line 4496: hr_legislation.hrrunprc_trace_off;

4492: install_ele_class(p_phase); --install element classifications
4493:
4494: hr_legislation.hrrunprc_trace_on;
4495: hr_utility.trace('start install_elements: ' || to_char(p_phase));
4496: hr_legislation.hrrunprc_trace_off;
4497:
4498: install_elements(p_phase); --install elements,sprs,frrs,inputs
4499:
4500: hr_legislation.hrrunprc_trace_on;

Line 4500: hr_legislation.hrrunprc_trace_on;

4496: hr_legislation.hrrunprc_trace_off;
4497:
4498: install_elements(p_phase); --install elements,sprs,frrs,inputs
4499:
4500: hr_legislation.hrrunprc_trace_on;
4501: hr_utility.trace('start install_ele_sets: ' || to_char(p_phase));
4502: hr_legislation.hrrunprc_trace_off;
4503:
4504: install_ele_sets(p_phase); --install sets,type rules,class rules

Line 4502: hr_legislation.hrrunprc_trace_off;

4498: install_elements(p_phase); --install elements,sprs,frrs,inputs
4499:
4500: hr_legislation.hrrunprc_trace_on;
4501: hr_utility.trace('start install_ele_sets: ' || to_char(p_phase));
4502: hr_legislation.hrrunprc_trace_off;
4503:
4504: install_ele_sets(p_phase); --install sets,type rules,class rules
4505:
4506: hr_legislation.hrrunprc_trace_on;

Line 4506: hr_legislation.hrrunprc_trace_on;

4502: hr_legislation.hrrunprc_trace_off;
4503:
4504: install_ele_sets(p_phase); --install sets,type rules,class rules
4505:
4506: hr_legislation.hrrunprc_trace_on;
4507: hr_utility.trace('start install_utables: ' || to_char(p_phase));
4508: hr_legislation.hrrunprc_trace_off;
4509:
4510: install_utables(p_phase); --install user tables

Line 4508: hr_legislation.hrrunprc_trace_off;

4504: install_ele_sets(p_phase); --install sets,type rules,class rules
4505:
4506: hr_legislation.hrrunprc_trace_on;
4507: hr_utility.trace('start install_utables: ' || to_char(p_phase));
4508: hr_legislation.hrrunprc_trace_off;
4509:
4510: install_utables(p_phase); --install user tables
4511:
4512: hr_legislation.hrrunprc_trace_on;

Line 4512: hr_legislation.hrrunprc_trace_on;

4508: hr_legislation.hrrunprc_trace_off;
4509:
4510: install_utables(p_phase); --install user tables
4511:
4512: hr_legislation.hrrunprc_trace_on;
4513: hr_utility.trace('start install_ucolumns: ' || to_char(p_phase));
4514: hr_legislation.hrrunprc_trace_off;
4515:
4516: install_ucolumns(p_phase); --install user columns

Line 4514: hr_legislation.hrrunprc_trace_off;

4510: install_utables(p_phase); --install user tables
4511:
4512: hr_legislation.hrrunprc_trace_on;
4513: hr_utility.trace('start install_ucolumns: ' || to_char(p_phase));
4514: hr_legislation.hrrunprc_trace_off;
4515:
4516: install_ucolumns(p_phase); --install user columns
4517:
4518: END IF;

Line 4522: END hr_legislation_elements;

4518: END IF;
4519:
4520: END install;
4521:
4522: END hr_legislation_elements;