[Home] [Help]
567: p_input_value_id_tbl(3),
568: p_effective_date
569: );
570: fetch csr_get_curr_percnt into l_cp;
571: l_current_percentage := fnd_number.canonical_to_number(l_cp);
572: if csr_get_curr_percnt%FOUND then
573: close csr_get_curr_percnt;
574: return l_current_percentage;
575: else
689: l_new_vertex_value_tbl(1) := null;
690: l_new_vertex_value_tbl(2) := p_jurisdiction;
691: if p_percentage is not null then
692: hr_utility.set_location(l_proc, 20);
693: l_new_vertex_value_tbl(3) := fnd_number.canonical_to_number(p_percentage);
694: hr_entry_api.update_element_entry
695: (
696: p_dt_update_mode => 'CORRECTION',
697: p_session_date => p_effective_date,
1070: -- Store screen entry value in the table
1071: --
1072: l_new_vertex_value_tbl(1) := null;
1073: l_new_vertex_value_tbl(2) := l_jurisdiction;
1074: l_new_vertex_value_tbl(3) := nvl(fnd_number.canonical_to_number(p_percentage),'0');
1075: --
1076: If p_datetrack_mode in ('DELETE_NEXT_CHANGE',
1077: 'FUTURE_CHANGE',
1078: 'DELETE',
1618: p_input_value_id_tbl => l_input_value_id_tbl,
1619: p_entry_value_tbl => l_new_vertex_value_tbl
1620: );
1621: end if;
1622: l_new_vertex_value_tbl(3) := fnd_number.canonical_to_number(p_percentage);
1623: if l_element_rec_tbl(l_pct_inc).effective_start_date <
1624: l_location_chg_tbl(l_asg_inc).start_date then
1625: l_modified_correction := TRUE;
1626: --
1799: --
1800: -- Call hr_entry_api.update_element_entry with MODE =
1801: -- 'UPDATE_CHANGE_INSERT' as of the effective date.
1802: --
1803: l_new_vertex_value_tbl(3) := fnd_number.canonical_to_number(p_percentage);
1804: --
1805: hr_utility.set_location(l_proc ,195);
1806: --
1807: hr_entry_api.update_element_entry