[Home] [Help]
612: l_people_data per_all_people_f%rowtype;
613: l_asgei_data per_assignment_extra_info%rowtype;
614: l_asgn_data per_all_assignments_f%rowtype;
615: l_peopleei_data per_people_extra_info%rowtype;
616: l_element_entry_value_data pay_element_entry_values_f%rowtype;
617: l_element_entry_data pay_element_entries_f%rowtype;
618: l_posnei_data per_position_extra_info%rowtype;
619: l_peranalyses_data per_person_analyses%rowtype;
620: l_address_data per_addresses%rowtype;
836: l_pre_mode varchar2(10):='PRE';
837: l_post_mode varchar2(10):='POST';
838: l_hist_data ghr_pa_history%rowtype;
839: l_eleevl_hist_data ghr_pa_history%rowtype;
840: l_eleevl_data pay_element_entry_values_f%rowtype;
841: l_pre_record ghr_pa_history%rowtype;
842: l_post_data ghr_pa_history%rowtype;
843: l_session_var g_session_var_type;
844: pa_history_id ghr_pa_history.pa_history_id%type;
1346: p_hist_data_as_of_date => l_hist_data_as_of_date
1347: );
1348: end if;
1349: elsif (lower(g_operation_info(indx).table_name) = lower(ghr_history_api.g_eleevl_table)) then
1350: -- PAY_ELEMENT_ENTRY_VALUES_F is a special case and needs to be handled differently.
1351: -- Cascade need not be performed for PAY_ELEMENT_ENTRY_VALUES_F,
1352: -- as it has only one column value so a record will be created only
1353: -- if the value changes thur sf52 or any other process which need not be
1354: -- cascaded. But if more than one sf52s were applied on the same date then
1347: );
1348: end if;
1349: elsif (lower(g_operation_info(indx).table_name) = lower(ghr_history_api.g_eleevl_table)) then
1350: -- PAY_ELEMENT_ENTRY_VALUES_F is a special case and needs to be handled differently.
1351: -- Cascade need not be performed for PAY_ELEMENT_ENTRY_VALUES_F,
1352: -- as it has only one column value so a record will be created only
1353: -- if the value changes thur sf52 or any other process which need not be
1354: -- cascaded. But if more than one sf52s were applied on the same date then
1355: -- we need to update the row with the most recent value.