[Home] [Help]
153: l_sleep_time_char VARCHAR2(30);
154: l_errbuf VARCHAR2(1000);
155: l_retcode NUMBER;
156:
157: -- Get individual physical batch id's for the entire logical batch
158: CURSOR physical_batches IS
159: SELECT DISTINCT sca_process_batch_id
160: FROM cn_sca_process_batches
161: WHERE logical_batch_id = x_logical_batch_id;
451: l_end_id := l_id;
452:
453: SELECT cn_sca_process_batches_s.NEXTVAL
454: INTO l_sca_process_batch_id
455: FROM SYS.DUAL;
456:
457: INSERT INTO cn_sca_process_batches
458: (
459: sca_process_batch_id
513: l_end_id := l_id;
514:
515: SELECT cn_sca_process_batches_s.NEXTVAL
516: INTO l_sca_process_batch_id
517: FROM SYS.DUAL;
518:
519: INSERT INTO cn_sca_process_batches
520: (
521: sca_process_batch_id
562: loop_count < l_worker_num OR(loop_count = l_worker_num AND l_physical_batch_size < 1)
563: ) THEN
564: SELECT cn_sca_process_batches_s.NEXTVAL
565: INTO l_sca_process_batch_id
566: FROM SYS.DUAL;
567:
568: INSERT INTO cn_sca_process_batches
569: (
570: sca_process_batch_id
669: --+ Call begin_batch to get process_audit_id for debug log file
670: --+
671: SELECT cn_sca_logical_batches_s.NEXTVAL
672: INTO l_logical_batch_id
673: FROM SYS.DUAL;
674:
675: debugmsg('Allocation Process : Start of Transfer');
676: debugmsg('Allocation Process : process_audit_id is ' || l_process_audit_id);
677: --dbms_output.put_line('Allocation Process : process_audit_id is ' || l_process_audit_id );
1473: debugmsg('SCA : Populating data to TRANS table');
1474:
1475: SELECT TO_NUMBER(NVL(fnd_profile.value('CN_NUMBER_OF_WORKERS'),1))
1476: INTO l_num_workers
1477: FROM dual;
1478:
1479: IF l_num_workers > 10
1480: THEN
1481: l_num_workers := 10;
2798:
2799: debugmsg('SCA : CN_SCATM_TAE_PUB.get_credited_txns completed successfully');
2800:
2801: SELECT TO_NUMBER(NVL(fnd_profile.value('CN_NUMBER_OF_WORKERS'),1)) INTO l_num_workers
2802: FROM dual;
2803:
2804: IF l_num_workers < 1
2805: THEN
2806: l_num_workers := 1;