126: );
127: --
128: Procedure load_crf_row
129: (
130: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
131: ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
132: ,p_owner in VARCHAR2 default hr_api.g_varchar2
133: ,p_parent_rate_matrix_code in VARCHAR2 default hr_api.g_varchar2
134: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
127: --
128: Procedure load_crf_row
129: (
130: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
131: ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
132: ,p_owner in VARCHAR2 default hr_api.g_varchar2
133: ,p_parent_rate_matrix_code in VARCHAR2 default hr_api.g_varchar2
134: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
135: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
128: Procedure load_crf_row
129: (
130: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
131: ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
132: ,p_owner in VARCHAR2 default hr_api.g_varchar2
133: ,p_parent_rate_matrix_code in VARCHAR2 default hr_api.g_varchar2
134: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
135: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
136: );
129: (
130: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
131: ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
132: ,p_owner in VARCHAR2 default hr_api.g_varchar2
133: ,p_parent_rate_matrix_code in VARCHAR2 default hr_api.g_varchar2
134: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
135: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
136: );
137:
130: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
131: ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
132: ,p_owner in VARCHAR2 default hr_api.g_varchar2
133: ,p_parent_rate_matrix_code in VARCHAR2 default hr_api.g_varchar2
134: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
135: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
136: );
137:
138: Procedure load_cre_row
131: ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
132: ,p_owner in VARCHAR2 default hr_api.g_varchar2
133: ,p_parent_rate_matrix_code in VARCHAR2 default hr_api.g_varchar2
134: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
135: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
136: );
137:
138: Procedure load_cre_row
139: (
136: );
137:
138: Procedure load_cre_row
139: (
140: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
141: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
142: ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
143: ,p_owner in VARCHAR2 default hr_api.g_varchar2
144: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
137:
138: Procedure load_cre_row
139: (
140: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
141: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
142: ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
143: ,p_owner in VARCHAR2 default hr_api.g_varchar2
144: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
145: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
138: Procedure load_cre_row
139: (
140: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
141: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
142: ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
143: ,p_owner in VARCHAR2 default hr_api.g_varchar2
144: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
145: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
146: );
139: (
140: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
141: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
142: ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
143: ,p_owner in VARCHAR2 default hr_api.g_varchar2
144: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
145: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
146: );
147:
140: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
141: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
142: ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
143: ,p_owner in VARCHAR2 default hr_api.g_varchar2
144: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
145: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
146: );
147:
148: Procedure load_rer_row
141: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
142: ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
143: ,p_owner in VARCHAR2 default hr_api.g_varchar2
144: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
145: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
146: );
147:
148: Procedure load_rer_row
149: (
146: );
147:
148: Procedure load_rer_row
149: (
150: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
151: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
152: -- ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
153: ,p_owner in VARCHAR2 default hr_api.g_varchar2
154: ,p_relation_type_code in VARCHAR2 default hr_api.g_varchar2
147:
148: Procedure load_rer_row
149: (
150: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
151: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
152: -- ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
153: ,p_owner in VARCHAR2 default hr_api.g_varchar2
154: ,p_relation_type_code in VARCHAR2 default hr_api.g_varchar2
155: ,p_rel_element_name in VARCHAR2 default hr_api.g_varchar2
148: Procedure load_rer_row
149: (
150: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
151: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
152: -- ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
153: ,p_owner in VARCHAR2 default hr_api.g_varchar2
154: ,p_relation_type_code in VARCHAR2 default hr_api.g_varchar2
155: ,p_rel_element_name in VARCHAR2 default hr_api.g_varchar2
156: ,p_rel_input_val_name in VARCHAR2 default hr_api.g_varchar2
149: (
150: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
151: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
152: -- ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
153: ,p_owner in VARCHAR2 default hr_api.g_varchar2
154: ,p_relation_type_code in VARCHAR2 default hr_api.g_varchar2
155: ,p_rel_element_name in VARCHAR2 default hr_api.g_varchar2
156: ,p_rel_input_val_name in VARCHAR2 default hr_api.g_varchar2
157: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
150: p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
151: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
152: -- ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
153: ,p_owner in VARCHAR2 default hr_api.g_varchar2
154: ,p_relation_type_code in VARCHAR2 default hr_api.g_varchar2
155: ,p_rel_element_name in VARCHAR2 default hr_api.g_varchar2
156: ,p_rel_input_val_name in VARCHAR2 default hr_api.g_varchar2
157: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
158: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
151: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
152: -- ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
153: ,p_owner in VARCHAR2 default hr_api.g_varchar2
154: ,p_relation_type_code in VARCHAR2 default hr_api.g_varchar2
155: ,p_rel_element_name in VARCHAR2 default hr_api.g_varchar2
156: ,p_rel_input_val_name in VARCHAR2 default hr_api.g_varchar2
157: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
158: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
159: );
152: -- ,p_input_value_name in VARCHAR2 default hr_api.g_varchar2
153: ,p_owner in VARCHAR2 default hr_api.g_varchar2
154: ,p_relation_type_code in VARCHAR2 default hr_api.g_varchar2
155: ,p_rel_element_name in VARCHAR2 default hr_api.g_varchar2
156: ,p_rel_input_val_name in VARCHAR2 default hr_api.g_varchar2
157: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
158: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
159: );
160:
153: ,p_owner in VARCHAR2 default hr_api.g_varchar2
154: ,p_relation_type_code in VARCHAR2 default hr_api.g_varchar2
155: ,p_rel_element_name in VARCHAR2 default hr_api.g_varchar2
156: ,p_rel_input_val_name in VARCHAR2 default hr_api.g_varchar2
157: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
158: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
159: );
160:
161: Procedure load_rfe_row
154: ,p_relation_type_code in VARCHAR2 default hr_api.g_varchar2
155: ,p_rel_element_name in VARCHAR2 default hr_api.g_varchar2
156: ,p_rel_input_val_name in VARCHAR2 default hr_api.g_varchar2
157: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
158: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
159: );
160:
161: Procedure load_rfe_row
162: (p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
158: ,p_effective_start_date in varchar2 default hr_api.g_varchar2
159: );
160:
161: Procedure load_rfe_row
162: (p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
163: ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
164: ,p_owner in VARCHAR2 default hr_api.g_varchar2
165: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
166: ,p_rate_factor_val_record_tbl in VARCHAR2 default hr_api.g_varchar2
159: );
160:
161: Procedure load_rfe_row
162: (p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
163: ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
164: ,p_owner in VARCHAR2 default hr_api.g_varchar2
165: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
166: ,p_rate_factor_val_record_tbl in VARCHAR2 default hr_api.g_varchar2
167: ,p_rate_factor_val_record_col in VARCHAR2 default hr_api.g_varchar2
160:
161: Procedure load_rfe_row
162: (p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
163: ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
164: ,p_owner in VARCHAR2 default hr_api.g_varchar2
165: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
166: ,p_rate_factor_val_record_tbl in VARCHAR2 default hr_api.g_varchar2
167: ,p_rate_factor_val_record_col in VARCHAR2 default hr_api.g_varchar2
168: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
161: Procedure load_rfe_row
162: (p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
163: ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
164: ,p_owner in VARCHAR2 default hr_api.g_varchar2
165: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
166: ,p_rate_factor_val_record_tbl in VARCHAR2 default hr_api.g_varchar2
167: ,p_rate_factor_val_record_col in VARCHAR2 default hr_api.g_varchar2
168: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
169: ,p_effective_start_date in VARCHAR2 default hr_api.g_varchar2
162: (p_crit_rt_defn_short_name in VARCHAR2 default hr_api.g_varchar2
163: ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
164: ,p_owner in VARCHAR2 default hr_api.g_varchar2
165: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
166: ,p_rate_factor_val_record_tbl in VARCHAR2 default hr_api.g_varchar2
167: ,p_rate_factor_val_record_col in VARCHAR2 default hr_api.g_varchar2
168: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
169: ,p_effective_start_date in VARCHAR2 default hr_api.g_varchar2
170: );
163: ,p_parent_crit_rt_def_name in VARCHAR2 default hr_api.g_varchar2
164: ,p_owner in VARCHAR2 default hr_api.g_varchar2
165: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
166: ,p_rate_factor_val_record_tbl in VARCHAR2 default hr_api.g_varchar2
167: ,p_rate_factor_val_record_col in VARCHAR2 default hr_api.g_varchar2
168: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
169: ,p_effective_start_date in VARCHAR2 default hr_api.g_varchar2
170: );
171:
164: ,p_owner in VARCHAR2 default hr_api.g_varchar2
165: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
166: ,p_rate_factor_val_record_tbl in VARCHAR2 default hr_api.g_varchar2
167: ,p_rate_factor_val_record_col in VARCHAR2 default hr_api.g_varchar2
168: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
169: ,p_effective_start_date in VARCHAR2 default hr_api.g_varchar2
170: );
171:
172:
165: ,p_element_type_name in VARCHAR2 default hr_api.g_varchar2
166: ,p_rate_factor_val_record_tbl in VARCHAR2 default hr_api.g_varchar2
167: ,p_rate_factor_val_record_col in VARCHAR2 default hr_api.g_varchar2
168: ,p_legislation_code in VARCHAR2 default hr_api.g_varchar2
169: ,p_effective_start_date in VARCHAR2 default hr_api.g_varchar2
170: );
171:
172:
173: --