[Home] [Help]
1247: --
1248: close chk_for_children;
1249: for each_child in chk_for_children loop
1250: --
1251: pay_run_type_usage_api.delete_run_type_usage
1252: (p_effective_date => g_to_be_uploaded_eed
1253: ,p_datetrack_delete_mode => 'ZAP'
1254: ,p_run_type_usage_id => each_child.run_type_usage_id
1255: ,p_object_version_number => each_child.object_version_number
2100: --
2101: -- call insert api. End date will be EOT for now, will be updated
2102: -- later if it should be anything other than eot.
2103: --
2104: pay_run_type_usage_api.create_run_type_usage
2105: (p_effective_date => p_effective_start_date
2106: ,p_parent_run_type_id => l_par_rt_id
2107: ,p_child_run_type_id => l_ch_rt_id
2108: ,p_sequence => p_sequence
2168: delete from pay_run_type_usages_f
2169: where run_type_usage_id = l_valid_seq;
2170: end if;
2171: --
2172: pay_run_type_usage_api.create_run_type_usage
2173: (p_effective_date => p_effective_start_date
2174: ,p_parent_run_type_id => l_par_rt_id
2175: ,p_child_run_type_id => l_ch_rt_id
2176: ,p_sequence => p_sequence
2220: hr_startup_data_api_support.delete_owner_definitions;
2221: hr_startup_data_api_support.create_owner_definition('PAY');
2222: end if;
2223: --
2224: pay_run_type_usage_api.update_run_type_usage
2225: (p_effective_date => p_effective_start_date
2226: ,p_datetrack_update_mode => 'UPDATE'
2227: ,p_run_type_usage_id => rec_rtu_uploaded.rtu_id
2228: ,p_object_version_number => rec_rtu_uploaded.rtu_ovn
2271: end if;
2272: --
2273: -- delete the run type usage
2274: --
2275: pay_run_type_usage_api.delete_run_type_usage
2276: (p_effective_date => g_rtu_to_be_uploaded_eed
2277: ,p_datetrack_delete_mode => 'DELETE'
2278: ,p_run_type_usage_id => rec_rtu_uploaded.rtu_id
2279: ,p_object_version_number => rec_rtu_uploaded.rtu_ovn