[Home] [Help]
106: or (LIMIT_TYPE='XI' and nvl(l_lim_type,'X') in('X','I')))
107: and CPARTY_CODE = l_grp_party
108: for update of UTILISED_AMOUNT NOWAIT;
109: begin
110: xtr_debug_pkg.debug('Before XTR_AI_XTR_MIRROR_DDA_LIMIT_ROW_T on:'||
111: to_char(sysdate,'MM:DD:HH24:MI:SS'));
112: if :NEW.LIMIT_CODE is NOT NULL then
113: open GET_HOMECCY;
114: fetch GET_HOMECCY INTO l_home_ccy;
294: close CHK_LOCK_GROUP_LIMITS;
295: end if;
296: end if;
297: end if;
298: xtr_debug_pkg.debug('After XTR_AI_XTR_MIRROR_DDA_LIMIT_ROW_T on:'||
299: to_char(sysdate,'MM:DD:HH24:MI:SS'));
300: exception
301: when app_exceptions.RECORD_LOCK_EXCEPTION then
302: if CHK_LOCK_MASTER_CURRENCIES%ISOPEN then