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