APPS.HXC_LOCKING_RULES_UPLOAD_PKG SQL Statements

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

Line: 23

SELECT	locker_type_id
FROM	hxc_locker_types
WHERE	locker_type	 = p_locker_type
AND	 process_type    = p_process_type;

Line: 46

	SELECT           locker_type_owner_id
			,locker_type_requestor_id
			, fnd_load_util.owner_name(NVL(last_updated_by,-1))
			, grant_lock

	INTO	         l_owner_id
			,l_requestor_id
			,l_owner
			,l_grant_lock

	FROM 		 hxc_locking_rules lkr
	WHERE            lkr.locker_type_owner_id    = l_owner_id
	AND              lkr.locker_type_requestor_id = l_requestor_id;

Line: 63

		-- only update if the grant_lock  has actually changed


		hxc_lkr_upd.upd
		  ( p_locker_type_owner_id	=>l_owner_id
		   ,p_locker_type_requestor_id	=>l_requestor_id
		   ,p_grant_lock		=>p_grant_lock
		  );

Line: 92

	,p_last_update_date         IN VARCHAR2 ) IS

l_owner_id	 		hxc_locking_rules.locker_type_owner_id%TYPE;

Line: 101

l_last_update_date_db              hxc_locking_rules.last_update_date%TYPE;

Line: 102

l_last_updated_by_db               hxc_locking_rules.last_updated_by%TYPE;

Line: 103

l_last_updated_by_f               hxc_locking_rules.last_updated_by%TYPE;

Line: 104

l_last_update_date_f               hxc_locking_rules.last_update_date%TYPE;

Line: 108

SELECT	locker_type_id
FROM	hxc_locker_types
WHERE	locker_type	 = p_locker_type
AND	 process_type    = p_process_type;

Line: 129

l_last_updated_by_f := fnd_load_util.owner_id(p_owner);

Line: 130

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

Line: 133

	SELECT           locker_type_owner_id
			,locker_type_requestor_id

			, grant_lock
			,last_update_date
			,last_updated_by

	INTO	         l_owner_id
			,l_requestor_id

			,l_grant_lock
			,l_last_update_date_db
                        ,l_last_updated_by_db

	FROM 		 hxc_locking_rules lkr
	WHERE            lkr.locker_type_owner_id    = l_owner_id
	AND              lkr.locker_type_requestor_id = l_requestor_id;

Line: 152

	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 grant_lock  has actually changed


		hxc_lkr_upd.upd
		  ( p_locker_type_owner_id	=>l_owner_id
		   ,p_locker_type_requestor_id	=>l_requestor_id
		   ,p_grant_lock		=>p_grant_lock
		  );