44:
45: BEGIN
46: SELECT locker_type_owner_id
47: ,locker_type_requestor_id
48: , fnd_load_util.owner_name(NVL(last_updated_by,-1))
49: , grant_lock
50:
51: INTO l_owner_id
52: ,l_requestor_id
125: BEGIN
126:
127: l_owner_id:=find_locker_type_id(p_owner_process_type,p_owner_locker_type);
128: l_requestor_id:=find_locker_type_id(p_requestor_process_type,p_requestor_locker_type);
129: l_last_updated_by_f := fnd_load_util.owner_id(p_owner);
130: l_last_update_date_f := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
131:
132: BEGIN
133: SELECT locker_type_owner_id
148: WHERE lkr.locker_type_owner_id = l_owner_id
149: AND lkr.locker_type_requestor_id = l_requestor_id;
150:
151:
152: IF (fnd_load_util.upload_test( l_last_updated_by_f,
153: l_last_update_date_f,
154: l_last_updated_by_db,
155: l_last_update_date_db ,
156: p_custom_mode))