APPS.HXC_LOCKER_TYPES_UPLOAD_PKG SQL Statements

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

Line: 18

	SELECT           locker_type_id
			, fnd_load_util.owner_name(NVL(last_updated_by,-1))
			, locker_type
			, process_type

	INTO	         l_locker_type_id
			,l_owner
			,l_locker_type
			,l_process_type

	FROM 		 hxc_locker_types lot
	WHERE   lot.process_type = p_process_type
	AND     lot.locker_type = p_locker_type;

Line: 35

		-- only update if the alias component mapping that has actually changed


		hxc_lck_upd.upd
		  (
		     p_locker_type_id		=>l_locker_type_id
		    ,p_locker_type              =>l_locker_type
		    ,p_process_type             => l_process_type
		  );

Line: 61

	,p_last_update_date         IN VARCHAR2 ) IS
l_locker_type_id  		hxc_locker_types.locker_type_id%TYPE;

Line: 66

l_last_update_date_db              hxc_locker_types.last_update_date%TYPE;

Line: 67

l_last_updated_by_db               hxc_locker_types.last_updated_by%TYPE;

Line: 68

l_last_updated_by_f               hxc_locker_types.last_updated_by%TYPE;

Line: 69

l_last_update_date_f               hxc_locker_types.last_update_date%TYPE;

Line: 73

l_last_updated_by_f := fnd_load_util.owner_id(p_owner);

Line: 74

l_last_update_date_f := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 75

	SELECT           locker_type_id

			, locker_type
			, process_type
			,last_update_date
			,last_updated_by

	INTO	         l_locker_type_id

			,l_locker_type
			,l_process_type
			,l_last_update_date_db
                        ,l_last_updated_by_db

	FROM 		 hxc_locker_types lot
	WHERE   lot.process_type = p_process_type
	AND     lot.locker_type = p_locker_type;

Line: 94

	IF (fnd_load_util.upload_test(	l_last_updated_by_f,
					l_last_update_date_f,
	                        	 l_last_updated_by_db,
					l_last_update_date_db ,
					 p_custom_mode))
	THEN
		-- only update if the alias component mapping that has actually changed

		hxc_lck_upd.upd
		  (
		     p_locker_type_id		=>l_locker_type_id
		    ,p_locker_type              =>l_locker_type
		    ,p_process_type             => l_process_type
		  );