The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT locker_type_id
FROM hxc_locker_types
WHERE locker_type = p_locker_type
AND process_type = p_process_type;
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;
-- 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
);
,p_last_update_date IN VARCHAR2 ) IS
l_owner_id hxc_locking_rules.locker_type_owner_id%TYPE;
l_last_update_date_db hxc_locking_rules.last_update_date%TYPE;
l_last_updated_by_db hxc_locking_rules.last_updated_by%TYPE;
l_last_updated_by_f hxc_locking_rules.last_updated_by%TYPE;
l_last_update_date_f hxc_locking_rules.last_update_date%TYPE;
SELECT locker_type_id
FROM hxc_locker_types
WHERE locker_type = p_locker_type
AND process_type = p_process_type;
l_last_updated_by_f := fnd_load_util.owner_id(p_owner);
l_last_update_date_f := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
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;
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
);