APPS.PER_ABSENCE_ATTENDANCES_PKG2 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

procedure insert_element(p_effective_start_date IN OUT NOCOPY DATE,
		         p_effective_end_date IN OUT NOCOPY DATE,
		         p_element_entry_id IN OUT NOCOPY NUMBER,
		         p_assignment_id In NUMBER,
		         p_element_link_id IN NUMBER,
		         p_creator_id IN NUMBER,
			 p_creator_type IN VARCHAR2,
			 p_entry_type IN VARCHAR2,
		         p_input_value_id1 IN NUMBER,
		         p_entry_value1 IN VARCHAR2) is
--
-- local vars being used so values not passed back to the client
-- they are incorrect. KLS 13/7/95 WWbug 269609
--
l_eff_start_date  date;

Line: 32

select distinct pel.element_type_id
from   pay_element_links_f pel
where  pel.element_link_id = p_element_link_id
and    p_effective_start_date between pel.effective_start_date
                              and     pel.effective_end_date;

Line: 58

hr_entry_api.insert_element_entry(p_effective_start_date => l_eff_start_date,
				  p_effective_end_date => l_eff_end_date,
				  p_element_entry_id => p_element_entry_id,
				  p_assignment_id => p_assignment_id,
				  p_element_link_id => l_element_link_id,
				  p_creator_id => p_creator_id,
				  p_creator_type => p_creator_type,
				  p_entry_type => p_entry_type,
				  p_input_value_id1 => p_input_value_id1,
				  p_entry_value1 => p_entry_value1);

Line: 68

end insert_element;

Line: 80

procedure update_element(p_dt_update_mode IN VARCHAR2,
			 p_session_date IN DATE,
			 p_element_entry_id IN NUMBER,
			 p_creator_id IN NUMBER,
			 p_creator_type IN VARCHAR2,
			 p_input_value_id1 IN NUMBER,
			 p_entry_value1 IN VARCHAR2) is

begin
hr_entry_api.update_element_entry(p_dt_update_mode => p_dt_update_mode,
                                  p_session_date => p_session_date,
				  p_element_entry_id =>
				  p_element_entry_id,
				  p_creator_id => p_creator_id,
				  p_creator_type => p_creator_type,
				  p_input_value_id1 =>
				  p_input_value_id1,
				  p_entry_value1 => p_entry_value1);

Line: 98

end update_element;