APPS.CSI_TRANSACTION_IMPORT_PVT dependencies on FND_CONCURRENT

Line 141: FROM FND_CONCURRENT_REQUESTS FCR,

137: end if;
138:
139: SELECT COUNT(*)
140: INTO l_active_num
141: FROM FND_CONCURRENT_REQUESTS FCR,
142: fnd_concurrent_programs FCP
143: WHERE FCR.concurrent_program_id = FCP.concurrent_program_id
144: AND FCR.program_application_id = FCP.application_id
145: AND FCP.application_id = 542

Line 142: fnd_concurrent_programs FCP

138:
139: SELECT COUNT(*)
140: INTO l_active_num
141: FROM FND_CONCURRENT_REQUESTS FCR,
142: fnd_concurrent_programs FCP
143: WHERE FCR.concurrent_program_id = FCP.concurrent_program_id
144: AND FCR.program_application_id = FCP.application_id
145: AND FCP.application_id = 542
146: AND FCP.concurrent_program_name = 'CSITXIMW'

Line 154: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);

150: --check number of workers currently running
151: if l_max_worker_number <= l_active_num then
152: debug('Requested '||l_max_worker_number||' workers, but there are already '||l_active_num||' active workers');
153: RETCODE := 'Success';
154: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);
155: l_num_workers := 0;
156: return;
157: else
158: l_num_workers := l_max_worker_number - l_active_num;

Line 198: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);

194: --FND_MESSAGE.RETREIVE;
195: --FND_MESSAGE.ERROR;
196: debug('Error: Submit Request failed by returning Request Id '||l_request_id);
197: RETCODE := 'Error';
198: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
199:
200: -- unmark rows in csi_batch_txn_lines
201: update csi_batch_txn_lines
202: set batch_id = -1,last_update_date = sysdate,last_updated_by = fnd_global.user_id

Line 221: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);

217: debug('END CSI_TRANSACTION_IMPORT_PVT.process_transaction_rows');
218: COMMIT;
219: RETCODE := 'Success';
220:
221: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);
222:
223: EXCEPTION
224: WHEN OTHERS THEN
225: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level THEN