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.HR_PROCESS_CEI_SS SQL Statements

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

Line: 20


		select
			effective_end_date
		into
			l_effective_end_date
		from
			per_contact_extra_info_f
		where
			contact_extra_info_id = p_contact_extra_info_id
			and
			p_effective_date
				between
					effective_start_date
					and
					effective_end_date
			and
			effective_end_date <> to_date('31/12/4712', 'DD/MM/YYYY');

Line: 39


			select
				'Y'
			into
				l_dummy
			from
				per_contact_extra_info_f
			where
				contact_extra_info_id = p_contact_extra_info_id
				and
				l_effective_end_date + 1
					between
						effective_start_date
						and
						effective_end_date;

Line: 58


				l_row_status := 'FUTURE_DELETE_ROW';

Line: 76


	p_action                  in         varchar2, -- 'INSERT' or 'UPDATE' or 'DELETE'
	p_effective_date          in         date     default null,
	p_date_track_option       in         varchar2 default null,
	p_contact_extra_info_id   in         number   default null,
	p_contact_relationship_id in         number   default null,
	p_information_type        in         varchar2 default null,
	p_object_version_number   in         number   default null,
	p_information_category    in         varchar2 default null,
	p_information1            in         varchar2 default null,
	p_information2            in         varchar2 default null,
	p_information3            in         varchar2 default null,
	p_information4            in         varchar2 default null,
	p_information5            in         varchar2 default null,
	p_information6            in         varchar2 default null,
	p_information7            in         varchar2 default null,
	p_information8            in         varchar2 default null,
	p_information9            in         varchar2 default null,
	p_information10           in         varchar2 default null,
	p_information11           in         varchar2 default null,
	p_information12           in         varchar2 default null,
	p_information13           in         varchar2 default null,
	p_information14           in         varchar2 default null,
	p_information15           in         varchar2 default null,
	p_information16           in         varchar2 default null,
	p_information17           in         varchar2 default null,
	p_information18           in         varchar2 default null,
	p_information19           in         varchar2 default null,
	p_information20           in         varchar2 default null,
	p_information21           in         varchar2 default null,
	p_information22           in         varchar2 default null,
	p_information23           in         varchar2 default null,
	p_information24           in         varchar2 default null,
	p_information25           in         varchar2 default null,
	p_information26           in         varchar2 default null,
	p_information27           in         varchar2 default null,
	p_information28           in         varchar2 default null,
	p_information29           in         varchar2 default null,
	p_information30           in         varchar2 default null,
	p_attribute_category      in         varchar2 default null,
	p_attribute1              in         varchar2 default null,
	p_attribute2              in         varchar2 default null,
	p_attribute3              in         varchar2 default null,
	p_attribute4              in         varchar2 default null,
	p_attribute5              in         varchar2 default null,
	p_attribute6              in         varchar2 default null,
	p_attribute7              in         varchar2 default null,
	p_attribute8              in         varchar2 default null,
	p_attribute9              in         varchar2 default null,
	p_attribute10             in         varchar2 default null,
	p_attribute11             in         varchar2 default null,
	p_attribute12             in         varchar2 default null,
	p_attribute13             in         varchar2 default null,
	p_attribute14             in         varchar2 default null,
	p_attribute15             in         varchar2 default null,
	p_attribute16             in         varchar2 default null,
	p_attribute17             in         varchar2 default null,
	p_attribute18             in         varchar2 default null,
	p_attribute19             in         varchar2 default null,
	p_attribute20             in         varchar2 default null
) is

	l_date_format         varchar2(10);

Line: 502


	hr_transaction_ss.delete_transaction_steps
	(
		p_item_type       => p_item_type,
		p_item_key        => p_item_key,
		p_actid           => p_activity_id,
		p_login_person_id => p_login_person_id
	);

Line: 672


    hr_util_misc_web.insert_session_row(l_effective_date);

Line: 674


	if l_action = 'INSERT' then

		hr_contact_extra_info_api.create_contact_extra_info
		(
			p_validate                 => p_validate,
			p_effective_date           => l_effective_date,
			p_contact_relationship_id  => l_tran_rec.contact_relationship_id,
			p_information_type         => l_tran_rec.information_type,
			p_cei_information_category => l_tran_rec.cei_information_category,
			p_cei_information1         => l_tran_rec.cei_information1,
			p_cei_information2         => l_tran_rec.cei_information2,
			p_cei_information3         => l_tran_rec.cei_information3,
			p_cei_information4         => l_tran_rec.cei_information4,
			p_cei_information5         => l_tran_rec.cei_information5,
			p_cei_information6         => l_tran_rec.cei_information6,
			p_cei_information7         => l_tran_rec.cei_information7,
			p_cei_information8         => l_tran_rec.cei_information8,
			p_cei_information9         => l_tran_rec.cei_information9,
			p_cei_information10        => l_tran_rec.cei_information10,
			p_cei_information11        => l_tran_rec.cei_information11,
			p_cei_information12        => l_tran_rec.cei_information12,
			p_cei_information13        => l_tran_rec.cei_information13,
			p_cei_information14        => l_tran_rec.cei_information14,
			p_cei_information15        => l_tran_rec.cei_information15,
			p_cei_information16        => l_tran_rec.cei_information16,
			p_cei_information17        => l_tran_rec.cei_information17,
			p_cei_information18        => l_tran_rec.cei_information18,
			p_cei_information19        => l_tran_rec.cei_information19,
			p_cei_information20        => l_tran_rec.cei_information20,
			p_cei_information21        => l_tran_rec.cei_information21,
			p_cei_information22        => l_tran_rec.cei_information22,
			p_cei_information23        => l_tran_rec.cei_information23,
			p_cei_information24        => l_tran_rec.cei_information24,
			p_cei_information25        => l_tran_rec.cei_information25,
			p_cei_information26        => l_tran_rec.cei_information26,
			p_cei_information27        => l_tran_rec.cei_information27,
			p_cei_information28        => l_tran_rec.cei_information28,
			p_cei_information29        => l_tran_rec.cei_information29,
			p_cei_information30        => l_tran_rec.cei_information30,
			p_cei_attribute_category   => l_tran_rec.cei_attribute_category,
			p_cei_attribute1           => l_tran_rec.cei_attribute1,
			p_cei_attribute2           => l_tran_rec.cei_attribute2,
			p_cei_attribute3           => l_tran_rec.cei_attribute3,
			p_cei_attribute4           => l_tran_rec.cei_attribute4,
			p_cei_attribute5           => l_tran_rec.cei_attribute5,
			p_cei_attribute6           => l_tran_rec.cei_attribute6,
			p_cei_attribute7           => l_tran_rec.cei_attribute7,
			p_cei_attribute8           => l_tran_rec.cei_attribute8,
			p_cei_attribute9           => l_tran_rec.cei_attribute9,
			p_cei_attribute10          => l_tran_rec.cei_attribute10,
			p_cei_attribute11          => l_tran_rec.cei_attribute11,
			p_cei_attribute12          => l_tran_rec.cei_attribute12,
			p_cei_attribute13          => l_tran_rec.cei_attribute13,
			p_cei_attribute14          => l_tran_rec.cei_attribute14,
			p_cei_attribute15          => l_tran_rec.cei_attribute15,
			p_cei_attribute16          => l_tran_rec.cei_attribute16,
			p_cei_attribute17          => l_tran_rec.cei_attribute17,
			p_cei_attribute18          => l_tran_rec.cei_attribute18,
			p_cei_attribute19          => l_tran_rec.cei_attribute19,
			p_cei_attribute20          => l_tran_rec.cei_attribute20,
			p_contact_extra_info_id    => l_contact_extra_info_id,
			p_object_version_number    => l_object_version_number,
			p_effective_start_date     => l_effective_start_date,
			p_effective_end_date       => l_effective_end_date
		);

Line: 740


	elsif l_action = 'UPDATE' then

		hr_contact_extra_info_api.update_contact_extra_info
		(
			p_validate                 => p_validate,
			p_effective_date           => l_effective_date,
			p_datetrack_update_mode    => l_date_track_option,
			p_contact_extra_info_id    => l_tran_rec.contact_extra_info_id,
			p_contact_relationship_id  => l_tran_rec.contact_relationship_id,
			p_information_type         => l_tran_rec.information_type,
			p_object_version_number    => l_tran_rec.object_version_number,
			p_cei_information_category => l_tran_rec.cei_information_category,
			p_cei_information1         => l_tran_rec.cei_information1,
			p_cei_information2         => l_tran_rec.cei_information2,
			p_cei_information3         => l_tran_rec.cei_information3,
			p_cei_information4         => l_tran_rec.cei_information4,
			p_cei_information5         => l_tran_rec.cei_information5,
			p_cei_information6         => l_tran_rec.cei_information6,
			p_cei_information7         => l_tran_rec.cei_information7,
			p_cei_information8         => l_tran_rec.cei_information8,
			p_cei_information9         => l_tran_rec.cei_information9,
			p_cei_information10        => l_tran_rec.cei_information10,
			p_cei_information11        => l_tran_rec.cei_information11,
			p_cei_information12        => l_tran_rec.cei_information12,
			p_cei_information13        => l_tran_rec.cei_information13,
			p_cei_information14        => l_tran_rec.cei_information14,
			p_cei_information15        => l_tran_rec.cei_information15,
			p_cei_information16        => l_tran_rec.cei_information16,
			p_cei_information17        => l_tran_rec.cei_information17,
			p_cei_information18        => l_tran_rec.cei_information18,
			p_cei_information19        => l_tran_rec.cei_information19,
			p_cei_information20        => l_tran_rec.cei_information20,
			p_cei_information21        => l_tran_rec.cei_information21,
			p_cei_information22        => l_tran_rec.cei_information22,
			p_cei_information23        => l_tran_rec.cei_information23,
			p_cei_information24        => l_tran_rec.cei_information24,
			p_cei_information25        => l_tran_rec.cei_information25,
			p_cei_information26        => l_tran_rec.cei_information26,
			p_cei_information27        => l_tran_rec.cei_information27,
			p_cei_information28        => l_tran_rec.cei_information28,
			p_cei_information29        => l_tran_rec.cei_information29,
			p_cei_information30        => l_tran_rec.cei_information30,
			p_cei_attribute_category   => l_tran_rec.cei_attribute_category,
			p_cei_attribute1           => l_tran_rec.cei_attribute1,
			p_cei_attribute2           => l_tran_rec.cei_attribute2,
			p_cei_attribute3           => l_tran_rec.cei_attribute3,
			p_cei_attribute4           => l_tran_rec.cei_attribute4,
			p_cei_attribute5           => l_tran_rec.cei_attribute5,
			p_cei_attribute6           => l_tran_rec.cei_attribute6,
			p_cei_attribute7           => l_tran_rec.cei_attribute7,
			p_cei_attribute8           => l_tran_rec.cei_attribute8,
			p_cei_attribute9           => l_tran_rec.cei_attribute9,
			p_cei_attribute10          => l_tran_rec.cei_attribute10,
			p_cei_attribute11          => l_tran_rec.cei_attribute11,
			p_cei_attribute12          => l_tran_rec.cei_attribute12,
			p_cei_attribute13          => l_tran_rec.cei_attribute13,
			p_cei_attribute14          => l_tran_rec.cei_attribute14,
			p_cei_attribute15          => l_tran_rec.cei_attribute15,
			p_cei_attribute16          => l_tran_rec.cei_attribute16,
			p_cei_attribute17          => l_tran_rec.cei_attribute17,
			p_cei_attribute18          => l_tran_rec.cei_attribute18,
			p_cei_attribute19          => l_tran_rec.cei_attribute19,
			p_cei_attribute20          => l_tran_rec.cei_attribute20,
			p_effective_start_date     => l_effective_start_date,
			p_effective_end_date       => l_effective_end_date
		);

Line: 807


	elsif l_action = 'DELETE' then

		hr_contact_extra_info_api.delete_contact_extra_info
		(
			p_validate              => p_validate,
			p_effective_date        => l_effective_date,
			p_datetrack_delete_mode => l_date_track_option,
			p_contact_extra_info_id => l_tran_rec.contact_extra_info_id,
			p_object_version_number => l_tran_rec.object_version_number,
			p_effective_start_date  => l_effective_start_date,
			p_effective_end_date    => l_effective_end_date
		);