DBA Data[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.12000000.1 2007/01/21 23:59:27 appldev 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 1205: hr_legislation.hrrunprc_trace_on;

1201:
1202: v_new_element_type_flag := 'Y';
1203:
1204: WHEN TOO_MANY_ROWS THEN
1205: hr_legislation.hrrunprc_trace_on;
1206: hr_utility.trace('sel pay_element_types_f TMR');
1207: hr_utility.trace('element_name ' ||
1208: r_distinct.c_true_key);
1209: hr_utility.trace(':lc: ' || ':' ||

Line 1211: hr_legislation.hrrunprc_trace_off;

1207: hr_utility.trace('element_name ' ||
1208: r_distinct.c_true_key);
1209: hr_utility.trace(':lc: ' || ':' ||
1210: r_distinct.legislation_code || ':');
1211: hr_legislation.hrrunprc_trace_off;
1212: raise;
1213: END;
1214:
1215: update hr_s_element_types_f

Line 1267: hr_legislation.hrrunprc_trace_on;

1263:
1264: v_new_input_value_flag := 'Y';
1265:
1266: WHEN TOO_MANY_ROWS THEN
1267: hr_legislation.hrrunprc_trace_on;
1268: hr_utility.trace('sel pay_input_values_f TMR');
1269: hr_utility.trace('iv name ' ||
1270: i_vals.name);
1271: hr_utility.trace('element_type_id ' ||

Line 1275: hr_legislation.hrrunprc_trace_off;

1271: hr_utility.trace('element_type_id ' ||
1272: to_char(l_new_element_Type_id));
1273: hr_utility.trace('element_name ' ||
1274: r_distinct.c_true_key);
1275: hr_legislation.hrrunprc_trace_off;
1276: raise;
1277: END;
1278:
1279: update hr_s_input_values_f

Line 1399: hr_legislation.hrrunprc_trace_on;

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');
1401:
1402: hr_utility.trace('assignment_status_type_id ' ||
1403: to_char(sprs.assignment_status_type_id));

Line 1406: hr_legislation.hrrunprc_trace_off;

1402: hr_utility.trace('assignment_status_type_id ' ||
1403: to_char(sprs.assignment_status_type_id));
1404: hr_utility.trace(':lc: ' || ':' ||
1405: r_distinct.legislation_code || ':');
1406: hr_legislation.hrrunprc_trace_off;
1407: raise;
1408: END;
1409:
1410: update hr_s_status_processing_rules_f

Line 1842: from hr_legislation_subgroups d

1838: or
1839: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
1840: and exists
1841: (select null
1842: from hr_legislation_subgroups d
1843: where d.legislation_code = r_distinct.legislation_code
1844: and d.legislation_subgroup =
1845: r_distinct.legislation_subgroup
1846: and d.active_inactive_flag = 'A'

Line 2095: hr_legislation.hrrunprc_trace_on;

2091: ,l_flex_value_set_id
2092: from hr_s_input_values_f
2093: where input_value_id = i_values.input_value_id;
2094: EXCEPTION WHEN OTHERS THEN
2095: hr_legislation.hrrunprc_trace_on;
2096: hr_utility.trace('ins pay_input_values_f');
2097: hr_utility.trace('iv id ' ||
2098: to_char(i_values.input_value_id));
2099: hr_utility.trace('iv name ' ||

Line 2101: hr_legislation.hrrunprc_trace_off;

2097: hr_utility.trace('iv id ' ||
2098: to_char(i_values.input_value_id));
2099: hr_utility.trace('iv name ' ||
2100: i_values.name);
2101: hr_legislation.hrrunprc_trace_off;
2102: raise;
2103: END;
2104:
2105: delete from hr_s_input_values_f

Line 2368: hr_legislation.hrrunprc_trace_on;

2364: ,each_row.TIME_DEFINITION_TYPE
2365: ,each_row.TIME_DEFINITION_ID
2366: );
2367: EXCEPTION WHEN OTHERS THEN
2368: hr_legislation.hrrunprc_trace_on;
2369: hr_utility.trace('ins pay_element_types_f');
2370: hr_utility.trace('element type name ' ||
2371: each_row.element_name);
2372: hr_utility.trace('element_type_id ' ||

Line 2376: hr_legislation.hrrunprc_trace_off;

2372: hr_utility.trace('element_type_id ' ||
2373: to_char(each_row.element_type_id));
2374: hr_utility.trace(':lc: ' || ':' ||
2375: each_row.legislation_code || ':');
2376: hr_legislation.hrrunprc_trace_off;
2377: raise;
2378: END;
2379:
2380: END LOOP each_row;

Line 2427: hr_legislation.hrrunprc_trace_on;

2423: ,s_rules.created_by
2424: ,s_rules.creation_date
2425: );
2426: EXCEPTION WHEN OTHERS THEN
2427: hr_legislation.hrrunprc_trace_on;
2428: hr_utility.trace('ins pay_sub_classification_rules_f');
2429: hr_utility.trace('sub_classification_rule_id ' ||
2430: to_char(s_rules.sub_classification_rule_id));
2431: hr_utility.trace('element_type_id ' ||

Line 2437: hr_legislation.hrrunprc_trace_off;

2433: hr_utility.trace('classification_id ' ||
2434: to_char(s_rules.classification_id));
2435: hr_utility.trace(':lc: ' || ':' ||
2436: s_rules.legislation_code || ':');
2437: hr_legislation.hrrunprc_trace_off;
2438: raise;
2439: END;
2440: --
2441: -- Bug 2888183 need to insert balances feeds

Line 2510: hr_legislation.hrrunprc_trace_on;

2506: ,all_rules.CREATED_BY
2507: ,all_rules.CREATION_DATE
2508: );
2509: EXCEPTION WHEN OTHERS THEN
2510: hr_legislation.hrrunprc_trace_on;
2511: hr_utility.trace('ins pay_status_processing_rules_f');
2512: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||
2513: to_char(all_rules.STATUS_PROCESSING_RULE_ID));
2514: hr_utility.trace('ELEMENT_TYPE_ID ' ||

Line 2522: hr_legislation.hrrunprc_trace_off;

2518: hr_utility.trace('ASSIGNMENT_STATUS_TYPE_ID ' ||
2519: to_char(all_rules.ASSIGNMENT_STATUS_TYPE_ID));
2520: hr_utility.trace(':lc: ' || ':' ||
2521: all_rules.legislation_code || ':');
2522: hr_legislation.hrrunprc_trace_off;
2523: raise;
2524: END;
2525:
2526:

Line 2571: hr_legislation.hrrunprc_trace_on;

2567: ,all_frrs.CREATED_BY
2568: ,all_frrs.CREATION_DATE
2569: );
2570: EXCEPTION WHEN OTHERS THEN
2571: hr_legislation.hrrunprc_trace_on;
2572: hr_utility.trace('ins pay_formula_result_rules_f');
2573: hr_utility.trace('FORMULA_RESULT_RULE_ID ' ||
2574: to_char(all_frrs.FORMULA_RESULT_RULE_ID));
2575: hr_utility.trace('STATUS_PROCESSING_RULE_ID ' ||

Line 2581: hr_legislation.hrrunprc_trace_off;

2577: hr_utility.trace('RESULT_NAME ' ||
2578: all_frrs.RESULT_NAME);
2579: hr_utility.trace(':lc: ' || ':' ||
2580: all_frrs.legislation_code || ':');
2581: hr_legislation.hrrunprc_trace_off;
2582: raise;
2583: END;
2584:
2585: END LOOP all_frrs;

Line 2790: hr_legislation.munge_sequence('PAY_ELEMENT_SETS_S',

2786: IF v_sequence_number
2787: BETWEEN v_min_delivered AND v_max_delivered
2788: THEN
2789:
2790: hr_legislation.munge_sequence('PAY_ELEMENT_SETS_S',
2791: v_sequence_number,
2792: v_max_delivered);
2793:
2794: END IF;

Line 2815: hr_legislation.insert_hr_stu_exceptions('pay_element_sets'

2811:
2812:
2813: rollback to new_element_set_name;
2814:
2815: hr_legislation.insert_hr_stu_exceptions('pay_element_sets'
2816: , stu_rec.c_surrogate_key
2817: , exception_type
2818: , stu_rec.c_true_key);
2819:

Line 2850: hr_legislation.hrrunprc_trace_on;

2846: from dual;
2847:
2848: WHEN TOO_MANY_ROWS THEN
2849:
2850: hr_legislation.hrrunprc_trace_on;
2851: hr_utility.trace('sel pay_element_sets TMR');
2852: hr_utility.trace('element_set_name ' ||
2853: stu_rec.c_true_key);
2854: hr_utility.trace(':lc: ' || ':' ||

Line 2856: hr_legislation.hrrunprc_trace_off;

2852: hr_utility.trace('element_set_name ' ||
2853: stu_rec.c_true_key);
2854: hr_utility.trace(':lc: ' || ':' ||
2855: stu_rec.c_leg_code || ':');
2856: hr_legislation.hrrunprc_trace_off;
2857: raise;
2858: END;
2859:
2860: --update all child entities

Line 3109: hr_legislation.hrrunprc_trace_on;

3105: ,stu_rec.created_by
3106: ,stu_rec.creation_date
3107: );
3108: EXCEPTION WHEN OTHERS THEN
3109: hr_legislation.hrrunprc_trace_on;
3110: hr_utility.trace('ins pay_element_sets');
3111: hr_utility.trace('element_set_name ' ||
3112: stu_rec.c_true_key);
3113: hr_utility.trace('element_set_id ' ||

Line 3119: hr_legislation.hrrunprc_trace_off;

3115: hr_utility.trace('element_set_type ' ||
3116: stu_rec.element_set_type);
3117: hr_utility.trace(':lc: ' || ':' ||
3118: stu_rec.c_leg_code || ':');
3119: hr_legislation.hrrunprc_trace_off;
3120: raise;
3121: END;
3122:
3123: END IF;

Line 3158: hr_legislation.hrrunprc_trace_on;

3154: ,ele_types.last_update_login
3155: ,ele_types.created_by
3156: ,ele_types.creation_date);
3157: EXCEPTION WHEN OTHERS THEN
3158: hr_legislation.hrrunprc_trace_on;
3159: hr_utility.trace('ins pay_element_type_rules');
3160: hr_utility.trace('element_type_id ' ||
3161: to_char(ele_types.element_Type_id));
3162: hr_utility.trace('element_set_id ' ||

Line 3164: hr_legislation.hrrunprc_trace_off;

3160: hr_utility.trace('element_type_id ' ||
3161: to_char(ele_types.element_Type_id));
3162: hr_utility.trace('element_set_id ' ||
3163: to_char(ele_types.element_Set_id));
3164: hr_legislation.hrrunprc_trace_off;
3165: raise;
3166: END;
3167:
3168:

Line 3210: hr_legislation.hrrunprc_trace_on;

3206: ,ele_class.last_update_login
3207: ,ele_class.created_by
3208: ,ele_class.creation_date);
3209: EXCEPTION WHEN OTHERS THEN
3210: hr_legislation.hrrunprc_trace_on;
3211: hr_utility.trace('ins pay_ele_classification_rules');
3212: hr_utility.trace('element_set_id ' ||
3213: to_char(ele_class.element_set_id));
3214: hr_utility.trace('classification_id ' ||

Line 3216: hr_legislation.hrrunprc_trace_off;

3212: hr_utility.trace('element_set_id ' ||
3213: to_char(ele_class.element_set_id));
3214: hr_utility.trace('classification_id ' ||
3215: to_char(ele_class.classification_id));
3216: hr_legislation.hrrunprc_trace_off;
3217: raise;
3218: END;
3219:
3220: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 3391: hr_legislation.munge_sequence('PAY_USER_TABLES_S',

3387: IF v_sequence_number
3388: BETWEEN v_min_delivered AND v_max_delivered
3389: THEN
3390:
3391: hr_legislation.munge_sequence('PAY_USER_TABLES_S',
3392: v_sequence_number,
3393: v_max_delivered);
3394:
3395: END IF;

Line 3416: hr_legislation.insert_hr_stu_exceptions('pay_user_tables'

3412:
3413:
3414: rollback to new_user_table_name;
3415:
3416: hr_legislation.insert_hr_stu_exceptions('pay_user_tables'
3417: , stu_rec.c_surrogate_key
3418: , exception_type
3419: , stu_rec.c_true_key);
3420:

Line 3451: hr_legislation.hrrunprc_trace_on;

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');
3453: hr_utility.trace('user_table_name ' ||
3454: stu_rec.c_true_key);
3455: hr_utility.trace(':lc: ' || ':' ||

Line 3457: hr_legislation.hrrunprc_trace_off;

3453: hr_utility.trace('user_table_name ' ||
3454: stu_rec.c_true_key);
3455: hr_utility.trace(':lc: ' || ':' ||
3456: stu_rec.c_leg_code || ':');
3457: hr_legislation.hrrunprc_trace_off;
3458: raise;
3459:
3460: END;
3461:

Line 3561: and exists (select null from hr_legislation_subgroups d

3557: and c.application_id = b.application_id
3558: and ((b.status = 'I' and c.application_short_name <> 'PQP')
3559: or
3560: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
3561: and exists (select null from hr_legislation_subgroups d
3562: where d.legislation_code = stu_rec.c_leg_code
3563: and d.legislation_subgroup = stu_rec.c_leg_sgrp
3564: and d.active_inactive_flag = 'A'
3565: );

Line 3727: hr_legislation.hrrunprc_trace_on;

3723: ,stu_rec.creation_date
3724: ,stu_rec.user_row_title
3725: );
3726: EXCEPTION WHEN OTHERS THEN
3727: hr_legislation.hrrunprc_trace_on;
3728: hr_utility.trace('ins pay_user_tables');
3729: hr_utility.trace('user_table_id ' ||
3730: to_char(stu_rec.c_surrogate_key));
3731: hr_utility.trace('user_table_name ' ||

Line 3735: hr_legislation.hrrunprc_trace_off;

3731: hr_utility.trace('user_table_name ' ||
3732: stu_rec.c_true_key);
3733: hr_utility.trace(':lc: ' || ':' ||
3734: stu_rec.c_leg_code || ':');
3735: hr_legislation.hrrunprc_trace_off;
3736: raise;
3737: END;
3738:
3739: END IF;

Line 3904: hr_legislation.munge_sequence('PAY_USER_COLUMNS_S',

3900: IF v_sequence_number
3901: BETWEEN v_min_delivered AND v_max_delivered
3902: THEN
3903:
3904: hr_legislation.munge_sequence('PAY_USER_COLUMNS_S',
3905: v_sequence_number,
3906: v_max_delivered);
3907:
3908: END IF;

Line 3929: hr_legislation.insert_hr_stu_exceptions('pay_user_columns'

3925:
3926:
3927: rollback to new_user_column_name;
3928:
3929: hr_legislation.insert_hr_stu_exceptions('pay_user_columns'
3930: , stu_rec.c_surrogate_key
3931: , exception_type
3932: , stu_rec.c_true_key);
3933:

Line 3969: hr_legislation.hrrunprc_trace_on;

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');
3971: hr_utility.trace('user_column_name ' ||
3972: stu_rec.c_true_key);
3973: hr_utility.trace('user_table_id ' ||

Line 3977: hr_legislation.hrrunprc_trace_off;

3973: hr_utility.trace('user_table_id ' ||
3974: to_char(stu_rec.user_table_id));
3975: hr_utility.trace(':lc: ' || ':' ||
3976: stu_rec.c_leg_code || ':');
3977: hr_legislation.hrrunprc_trace_off;
3978: raise;
3979: END;
3980:
3981: -- Update all child entities

Line 4079: and exists (select null from hr_legislation_subgroups d

4075: and c.application_id = b.application_id
4076: and ((b.status = 'I' and c.application_short_name <> 'PQP')
4077: or
4078: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
4079: and exists (select null from hr_legislation_subgroups d
4080: where d.legislation_code = stu_rec.c_leg_code
4081: and d.legislation_subgroup = stu_rec.c_leg_sgrp
4082: and d.active_inactive_flag = 'A'
4083: );

Line 4378: hr_legislation.hrrunprc_trace_on;

4374: ,stu_rec.created_by
4375: ,stu_rec.creation_date
4376: );
4377: EXCEPTION WHEN OTHERS THEN
4378: hr_legislation.hrrunprc_trace_on;
4379: hr_utility.trace('ins pay_user_columns');
4380: hr_utility.trace('user_column_id ' ||
4381: to_char(stu_rec.c_surrogate_key));
4382: hr_utility.trace('user_column_name ' ||

Line 4388: hr_legislation.hrrunprc_trace_off;

4384: hr_utility.trace('user_table_id ' ||
4385: to_char(stu_rec.user_table_id));
4386: hr_utility.trace(':lc: ' || ':' ||
4387: stu_rec.c_leg_code || ':');
4388: hr_legislation.hrrunprc_trace_off;
4389: raise;
4390: END;
4391:
4392: END IF;

Line 4456: hr_legislation.hrrunprc_trace_on;

4452: BEGIN
4453:
4454: IF p_phase = 1 OR p_phase =2 THEN
4455:
4456: hr_legislation.hrrunprc_trace_on;
4457: hr_utility.trace('start install_ele_class: ' || to_char(p_phase));
4458: hr_legislation.hrrunprc_trace_off;
4459:
4460: install_ele_class(p_phase); --install element classifications

Line 4458: hr_legislation.hrrunprc_trace_off;

4454: IF p_phase = 1 OR p_phase =2 THEN
4455:
4456: hr_legislation.hrrunprc_trace_on;
4457: hr_utility.trace('start install_ele_class: ' || to_char(p_phase));
4458: hr_legislation.hrrunprc_trace_off;
4459:
4460: install_ele_class(p_phase); --install element classifications
4461:
4462: hr_legislation.hrrunprc_trace_on;

Line 4462: hr_legislation.hrrunprc_trace_on;

4458: hr_legislation.hrrunprc_trace_off;
4459:
4460: install_ele_class(p_phase); --install element classifications
4461:
4462: hr_legislation.hrrunprc_trace_on;
4463: hr_utility.trace('start install_elements: ' || to_char(p_phase));
4464: hr_legislation.hrrunprc_trace_off;
4465:
4466: install_elements(p_phase); --install elements,sprs,frrs,inputs

Line 4464: hr_legislation.hrrunprc_trace_off;

4460: install_ele_class(p_phase); --install element classifications
4461:
4462: hr_legislation.hrrunprc_trace_on;
4463: hr_utility.trace('start install_elements: ' || to_char(p_phase));
4464: hr_legislation.hrrunprc_trace_off;
4465:
4466: install_elements(p_phase); --install elements,sprs,frrs,inputs
4467:
4468: hr_legislation.hrrunprc_trace_on;

Line 4468: hr_legislation.hrrunprc_trace_on;

4464: hr_legislation.hrrunprc_trace_off;
4465:
4466: install_elements(p_phase); --install elements,sprs,frrs,inputs
4467:
4468: hr_legislation.hrrunprc_trace_on;
4469: hr_utility.trace('start install_ele_sets: ' || to_char(p_phase));
4470: hr_legislation.hrrunprc_trace_off;
4471:
4472: install_ele_sets(p_phase); --install sets,type rules,class rules

Line 4470: hr_legislation.hrrunprc_trace_off;

4466: install_elements(p_phase); --install elements,sprs,frrs,inputs
4467:
4468: hr_legislation.hrrunprc_trace_on;
4469: hr_utility.trace('start install_ele_sets: ' || to_char(p_phase));
4470: hr_legislation.hrrunprc_trace_off;
4471:
4472: install_ele_sets(p_phase); --install sets,type rules,class rules
4473:
4474: hr_legislation.hrrunprc_trace_on;

Line 4474: hr_legislation.hrrunprc_trace_on;

4470: hr_legislation.hrrunprc_trace_off;
4471:
4472: install_ele_sets(p_phase); --install sets,type rules,class rules
4473:
4474: hr_legislation.hrrunprc_trace_on;
4475: hr_utility.trace('start install_utables: ' || to_char(p_phase));
4476: hr_legislation.hrrunprc_trace_off;
4477:
4478: install_utables(p_phase); --install user tables

Line 4476: hr_legislation.hrrunprc_trace_off;

4472: install_ele_sets(p_phase); --install sets,type rules,class rules
4473:
4474: hr_legislation.hrrunprc_trace_on;
4475: hr_utility.trace('start install_utables: ' || to_char(p_phase));
4476: hr_legislation.hrrunprc_trace_off;
4477:
4478: install_utables(p_phase); --install user tables
4479:
4480: hr_legislation.hrrunprc_trace_on;

Line 4480: hr_legislation.hrrunprc_trace_on;

4476: hr_legislation.hrrunprc_trace_off;
4477:
4478: install_utables(p_phase); --install user tables
4479:
4480: hr_legislation.hrrunprc_trace_on;
4481: hr_utility.trace('start install_ucolumns: ' || to_char(p_phase));
4482: hr_legislation.hrrunprc_trace_off;
4483:
4484: install_ucolumns(p_phase); --install user columns

Line 4482: hr_legislation.hrrunprc_trace_off;

4478: install_utables(p_phase); --install user tables
4479:
4480: hr_legislation.hrrunprc_trace_on;
4481: hr_utility.trace('start install_ucolumns: ' || to_char(p_phase));
4482: hr_legislation.hrrunprc_trace_off;
4483:
4484: install_ucolumns(p_phase); --install user columns
4485:
4486: END IF;

Line 4490: END hr_legislation_elements;

4486: END IF;
4487:
4488: END install;
4489:
4490: END hr_legislation_elements;