APPS.FND_EXEC_MIG_CMDS dependencies on FND_TS_MIG_STATUS

Line 181: update fnd_ts_mig_status set num_threads=num_threads+1 where item='EXE_MIG_CMDS';

177: l_new_index NUMBER := 0;
178: l_enqueue VARCHAR2(1) := NVL(p_aqStat, 'N');
179:
180: BEGIN
181: update fnd_ts_mig_status set num_threads=num_threads+1 where item='EXE_MIG_CMDS';
182: commit;
183:
184: if p_owner <> '%' then
185: LOOP

Line 362: update fnd_ts_mig_status set num_threads=num_threads-1, status=decode(num_threads,1,'SUCCESS',status),detail_message=decode(num_threads,1,'',detail_message) where item='EXE_MIG_CMDS';

358: WHERE module = 'TS_MIGRATE_SEQUENTIAL_OBJECTS'
359: AND status <> 'KILLED';
360: if l_cnt = 0 then
361: if sqlcode = -25228 then
362: update fnd_ts_mig_status set num_threads=num_threads-1, status=decode(num_threads,1,'SUCCESS',status),detail_message=decode(num_threads,1,'',detail_message) where item='EXE_MIG_CMDS';
363: commit;
364: end if;
365: l_retVal := 1;
366: EXIT;

Line 371: update fnd_ts_mig_status set num_threads=num_threads-1, status=decode(num_threads,1,'SUCCESS',status),detail_message=decode(num_threads,1,'',detail_message) where item='EXE_MIG_CMDS';

367: end if;
368: DBMS_LOCK.SLEEP(300);
369: else
370: if sqlcode = -25228 then
371: update fnd_ts_mig_status set num_threads=num_threads-1, status=decode(num_threads,1,'SUCCESS',status),detail_message=decode(num_threads,1,'',detail_message) where item='EXE_MIG_CMDS';
372: commit;
373: end if;
374: l_retVal := 1;
375: EXIT;