APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on CN_SCA_PROCESS_BATCHES_S

Line 17: -- CN_SCA_PROCESS_BATCHES stmt

13: -- Add the flow diagram here.
14: -- History
15: -- 06/26/03 Rao.Chenna Created
16: -- Nov 17, 2005 vensrini Added org_id to insert into
17: -- CN_SCA_PROCESS_BATCHES stmt
18: --
19: -- Added fnd_request.set_org_id
20: -- call in conc_submit proc
21: --

Line 384: l_sca_process_batch_id cn_sca_process_batches.sca_process_batch_id%TYPE;

380: l_sql_stmt_id VARCHAR2(10000);
381: l_sql_stmt_divider VARCHAR2(10000);
382: l_sql_stmt_resource VARCHAR2(10000);
383: l_no_trx BOOLEAN;
384: l_sca_process_batch_id cn_sca_process_batches.sca_process_batch_id%TYPE;
385:
386: TYPE rc IS REF CURSOR;
387:
388: TYPE divider_type IS TABLE OF NUMBER;

Line 407: l_start_id cn_sca_process_batches.start_id%TYPE;

403: l_divider_size NUMBER;
404: divider divider_type := divider_type
405: ();
406: loop_count NUMBER;
407: l_start_id cn_sca_process_batches.start_id%TYPE;
408: l_end_id cn_sca_process_batches.end_id%TYPE;
409: l_user_id NUMBER(15) := fnd_global.user_id;
410: l_login_id NUMBER(15) := fnd_global.login_id;
411: BEGIN

Line 531: SELECT cn_sca_process_batches_s.NEXTVAL

527:
528: IF ((loop_count MOD 2) = 0) THEN
529: l_end_id := l_id;
530:
531: SELECT cn_sca_process_batches_s.NEXTVAL
532: INTO l_sca_process_batch_id
533: FROM SYS.DUAL;
534:
535: INSERT INTO cn_sca_process_batches

Line 593: SELECT cn_sca_process_batches_s.NEXTVAL

589:
590: IF (loop_count > l_worker_num AND l_physical_batch_size = 1) THEN
591: l_end_id := l_id;
592:
593: SELECT cn_sca_process_batches_s.NEXTVAL
594: INTO l_sca_process_batch_id
595: FROM SYS.DUAL;
596:
597: INSERT INTO cn_sca_process_batches

Line 642: SELECT cn_sca_process_batches_s.NEXTVAL

638:
639: IF (
640: loop_count < l_worker_num OR(loop_count = l_worker_num AND l_physical_batch_size < 1)
641: ) THEN
642: SELECT cn_sca_process_batches_s.NEXTVAL
643: INTO l_sca_process_batch_id
644: FROM SYS.DUAL;
645:
646: INSERT INTO cn_sca_process_batches