eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_ENTRIES_PKG SQL Statements

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

Line: 148


		select	piv.input_value_id,
			piv.display_sequence,
			piv.uom,
			piv.mandatory_flag
		from	pay_input_values_f	piv
		where	piv.element_type_id = p_element_type_id
		and	p_effective_date
			between piv.effective_start_date and piv.effective_end_date;

Line: 246


	p_dt_update_mode	in     varchar2,
	p_dt_delete_mode	in     varchar2)
Is
Begin
	hr_entry.chk_element_entry(
		p_element_entry_id	=> p_element_entry_id,
		p_original_entry_id	=> p_original_entry_id,
		p_session_date		=> p_effective_date,
		p_element_link_id	=> p_element_link_id,
		p_assignment_id		=> p_assignment_id,
		p_entry_type		=> p_entry_type,
		p_effective_start_date	=> p_effective_start_date,
		p_effective_end_date	=> p_effective_end_date,
		p_validation_start_date	=> p_validation_start_date,
		p_validation_end_date	=> p_validation_end_date,
		p_dt_update_mode	=> p_dt_update_mode,
		p_dt_delete_mode	=> p_dt_delete_mode,
		p_usage			=> p_usage,
		p_target_entry_id	=> p_target_entry_id);

Line: 287


		select	piv.input_value_id,
			piv.display_sequence,
			decode(piv.hot_default_flag,
					'Y',nvl(pliv.default_value,piv.default_value),
					pliv.default_value)	DEFAULT_VALUE,
			decode(piv.lookup_type,NULL,NULL,
				hr_general.decode_lookup(
						piv.lookup_type,
						decode(piv.hot_default_flag,
							'Y',nvl(pliv.default_value,piv.default_value),
							pliv.default_value)))	D_DEFAULT_VALUE
		from	pay_input_values_f	piv,
			pay_link_input_values_f	pliv
		where	pliv.element_link_id = p_element_link_id
		and	p_effective_date
			between pliv.effective_start_date and pliv.effective_end_date
		and	piv.input_value_id = pliv.input_value_id
		and	p_effective_date
			between piv.effective_start_date and piv.effective_end_date
		order by piv.display_sequence;

Line: 334


		p_usage			=> 'INSERT',
		p_dt_update_mode	=> NULL,
		p_dt_delete_mode	=> NULL);

Line: 385


		select	item_name						NAME,
			decode(data_type,'T','TEXT','N','NUMBER','D','DATE')	DATATYPE,
			decode(usage,'U','CONTEXT','INPUT')			CLASS
		from	ff_fdi_usages_f
		where	formula_id = p_formula_id
		and	p_date_earned
			between effective_start_date and effective_end_date;

Line: 466


		select	pivtl.name,
			piv.uom,
			piv.mandatory_flag,
			piv.hot_default_flag,
			piv.lookup_type,
			decode(piv.hot_default_flag,
					'Y',nvl(pliv.default_value,piv.default_value),
					pliv.default_value)	DEFAULT_VALUE,
--			decode(piv.lookup_type,NULL,NULL,
--				hr_general.decode_lookup(
--						piv.lookup_type,
--						decode(piv.hot_default_flag,
--							'Y',nvl(pliv.default_value,piv.default_value),
--							pliv.default_value)))	D_DEFAULT_VALUE,
			decode(piv.hot_default_flag,
					'Y',nvl(pliv.min_value,piv.min_value),
					pliv.min_value)		MIN_VALUE,
			decode(piv.hot_default_flag,
					'Y',nvl(pliv.max_value,piv.max_value),
					pliv.max_value)		MAX_VALUE,
			piv.formula_id,
			decode(piv.hot_default_flag,
					'Y',nvl(pliv.warning_or_error,piv.warning_or_error),
					pliv.warning_or_error)	WARNING_OR_ERROR,
			pet.input_currency_code
		from	pay_element_types_f	pet,
			pay_input_values_f_tl	pivtl,
			pay_input_values_f	piv,
			pay_link_input_values_f	pliv
		where	pliv.element_link_id = p_element_link_id
		and	pliv.input_value_id = p_input_value_id
		and	p_effective_date
			between pliv.effective_start_date and pliv.effective_end_date
		and	piv.input_value_id = pliv.input_value_id
		and	p_effective_date
			between piv.effective_start_date and piv.effective_end_date
		and	pivtl.input_value_id = piv.input_value_id
		and	pivtl.language = userenv('LANG')
		and	pet.element_type_id = piv.element_type_id
		and	p_effective_date
			between pet.effective_start_date and pet.effective_end_date;

Line: 700


	 p_update	 out nocopy boolean,
	 p_update_override out nocopy boolean,
	 p_update_change_insert out nocopy boolean)
Is
--
  l_proc 	varchar2(72) := g_package||'find_dt_upd_modes';

Line: 711


    select  pee.entry_type,
            pet.processing_type
    from    pay_element_types_f		pet,
            pay_element_links_f		pel,
            pay_element_entries_f	pee
    where   pee.element_entry_id = p_base_key_value
    and     p_effective_date
            between pee.effective_start_date and pee.effective_end_date
    and     pel.element_link_id = pee.element_link_id
    and     p_effective_date
            between pel.effective_start_date and pel.effective_end_date
    and     pet.element_type_id = pel.element_type_id
    and     p_effective_date
            between pet.effective_start_date and pet.effective_end_date;

Line: 743


    p_update			:= false;

Line: 744


    p_update_override		:= false;

Line: 745


    p_update_change_insert	:= false;

Line: 756


	 p_update		=> p_update,
	 p_update_override	=> p_update_override,
	 p_update_change_insert	=> p_update_change_insert);

Line: 775


	 p_delete	 out nocopy boolean,
	 p_future_change out nocopy boolean,
	 p_delete_next_change out nocopy boolean)
Is
--
  l_proc 		varchar2(72) 	:= g_package||'find_dt_del_modes';

Line: 788


    select  pee.assignment_id,
            pee.element_link_id,
            pee.entry_type,
            pet.processing_type
    from    pay_element_types_f		pet,
            pay_element_links_f		pel,
            pay_element_entries_f	pee
    where   pee.element_entry_id = p_base_key_value
    and     p_effective_date
            between pee.effective_start_date and pee.effective_end_date
    and     pel.element_link_id = pee.element_link_id
    and     p_effective_date
            between pel.effective_start_date and pel.effective_end_date
    and     pet.element_type_id = pel.element_type_id
    and     p_effective_date
            between pet.effective_start_date and pet.effective_end_date;

Line: 824


    p_delete			:= false;

Line: 826


    p_delete_next_change	:= false;

Line: 843


	 p_delete		=> p_delete,
	 p_future_change	=> p_future_change,
	 p_delete_next_change	=> p_delete_next_change);

Line: 929


    select  *
    from    pay_element_entries_f
    where   element_entry_id = p_element_entry_id
    and	    p_effective_date  between effective_start_date
                              and     effective_end_date
    for update nowait;

Line: 968


  If (p_datetrack_mode <> 'INSERT') then
    --
    -- We must select and lock the current row.
    --
    Open  C_Sel1;

Line: 1210


	p_datetrack_update_mode	in     varchar2,
	p_element_entry_id	in     number,
	p_object_version_number	in out nocopy number,
	p_ev_rec_tbl		in     ev_rec_tbl,
	p_attribute_tbl		in     attribute_tbl,
	p_business_group_id	in     number,
	p_effective_start_date out nocopy    date,
	p_effective_end_date out nocopy    date)
Is
	l_warning		BOOLEAN;

Line: 1223


	py_element_entry_api.update_element_entry(
		P_VALIDATE			=> p_validate,
		P_DATETRACK_UPDATE_MODE		=> p_datetrack_update_mode,
		P_EFFECTIVE_DATE		=> p_effective_date,
		P_BUSINESS_GROUP_ID		=> p_business_group_id,
		P_ELEMENT_ENTRY_ID		=> p_element_entry_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_ATTRIBUTE_CATEGORY		=> p_attribute_tbl.attribute_category,
		P_ATTRIBUTE1			=> p_attribute_tbl.attribute(1),
		P_ATTRIBUTE2			=> p_attribute_tbl.attribute(2),
		P_ATTRIBUTE3			=> p_attribute_tbl.attribute(3),
		P_ATTRIBUTE4			=> p_attribute_tbl.attribute(4),
		P_ATTRIBUTE5			=> p_attribute_tbl.attribute(5),
		P_ATTRIBUTE6			=> p_attribute_tbl.attribute(6),
		P_ATTRIBUTE7			=> p_attribute_tbl.attribute(7),
		P_ATTRIBUTE8			=> p_attribute_tbl.attribute(8),
		P_ATTRIBUTE9			=> p_attribute_tbl.attribute(9),
		P_ATTRIBUTE10			=> p_attribute_tbl.attribute(10),
		P_ATTRIBUTE11			=> p_attribute_tbl.attribute(11),
		P_ATTRIBUTE12			=> p_attribute_tbl.attribute(12),
		P_ATTRIBUTE13			=> p_attribute_tbl.attribute(13),
		P_ATTRIBUTE14			=> p_attribute_tbl.attribute(14),
		P_ATTRIBUTE15			=> p_attribute_tbl.attribute(15),
		P_ATTRIBUTE16			=> p_attribute_tbl.attribute(16),
		P_ATTRIBUTE17			=> p_attribute_tbl.attribute(17),
		P_ATTRIBUTE18			=> p_attribute_tbl.attribute(18),
		P_ATTRIBUTE19			=> p_attribute_tbl.attribute(19),
		P_ATTRIBUTE20			=> p_attribute_tbl.attribute(20),
		P_INPUT_VALUE_ID1		=> l_ev_rec_tbl(1).input_value_id,
		P_INPUT_VALUE_ID2		=> l_ev_rec_tbl(2).input_value_id,
		P_INPUT_VALUE_ID3		=> l_ev_rec_tbl(3).input_value_id,
		P_INPUT_VALUE_ID4		=> l_ev_rec_tbl(4).input_value_id,
		P_INPUT_VALUE_ID5		=> l_ev_rec_tbl(5).input_value_id,
		P_INPUT_VALUE_ID6		=> l_ev_rec_tbl(6).input_value_id,
		P_INPUT_VALUE_ID7		=> l_ev_rec_tbl(7).input_value_id,
		P_INPUT_VALUE_ID8		=> l_ev_rec_tbl(8).input_value_id,
		P_INPUT_VALUE_ID9		=> l_ev_rec_tbl(9).input_value_id,
		P_INPUT_VALUE_ID10		=> l_ev_rec_tbl(10).input_value_id,
		P_INPUT_VALUE_ID11		=> l_ev_rec_tbl(11).input_value_id,
		P_INPUT_VALUE_ID12		=> l_ev_rec_tbl(12).input_value_id,
		P_INPUT_VALUE_ID13		=> l_ev_rec_tbl(13).input_value_id,
		P_INPUT_VALUE_ID14		=> l_ev_rec_tbl(14).input_value_id,
		P_INPUT_VALUE_ID15		=> l_ev_rec_tbl(15).input_value_id,
		P_ENTRY_VALUE1			=> l_ev_rec_tbl(1).entry_value,
		P_ENTRY_VALUE2			=> l_ev_rec_tbl(2).entry_value,
		P_ENTRY_VALUE3			=> l_ev_rec_tbl(3).entry_value,
		P_ENTRY_VALUE4			=> l_ev_rec_tbl(4).entry_value,
		P_ENTRY_VALUE5			=> l_ev_rec_tbl(5).entry_value,
		P_ENTRY_VALUE6			=> l_ev_rec_tbl(6).entry_value,
		P_ENTRY_VALUE7			=> l_ev_rec_tbl(7).entry_value,
		P_ENTRY_VALUE8			=> l_ev_rec_tbl(8).entry_value,
		P_ENTRY_VALUE9			=> l_ev_rec_tbl(9).entry_value,
		P_ENTRY_VALUE10			=> l_ev_rec_tbl(10).entry_value,
		P_ENTRY_VALUE11			=> l_ev_rec_tbl(11).entry_value,
		P_ENTRY_VALUE12			=> l_ev_rec_tbl(12).entry_value,
		P_ENTRY_VALUE13			=> l_ev_rec_tbl(13).entry_value,
		P_ENTRY_VALUE14			=> l_ev_rec_tbl(14).entry_value,
		P_ENTRY_VALUE15			=> l_ev_rec_tbl(15).entry_value,
		P_EFFECTIVE_START_DATE		=> p_effective_start_date,
		P_EFFECTIVE_END_DATE		=> p_effective_end_date,
		P_UPDATE_WARNING		=> l_warning);

Line: 1295


	p_datetrack_delete_mode	in     varchar2,
	p_element_entry_id	in     number,
	p_object_version_number	in out nocopy number,
	p_effective_start_date out nocopy    date,
	p_effective_end_date out nocopy    date)
Is
	l_warning		BOOLEAN;

Line: 1303


	py_element_entry_api.delete_element_entry(
		P_VALIDATE			=> p_validate,
		P_DATETRACK_DELETE_MODE		=> p_datetrack_delete_mode,
		P_EFFECTIVE_DATE		=> p_effective_date,
		P_ELEMENT_ENTRY_ID		=> p_element_entry_id,
		P_OBJECT_VERSION_NUMBER		=> p_object_version_number,
		P_EFFECTIVE_START_DATE		=> p_effective_start_date,
		P_EFFECTIVE_END_DATE		=> p_effective_end_date,
		P_DELETE_WARNING		=> l_warning);