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 306: l_sca_process_batch_id cn_sca_process_batches.sca_process_batch_id%TYPE;

302: l_sql_stmt_id VARCHAR2(10000);
303: l_sql_stmt_divider VARCHAR2(10000);
304: l_sql_stmt_resource VARCHAR2(10000);
305: l_no_trx BOOLEAN;
306: l_sca_process_batch_id cn_sca_process_batches.sca_process_batch_id%TYPE;
307:
308: TYPE rc IS REF CURSOR;
309:
310: TYPE divider_type IS TABLE OF NUMBER;

Line 329: l_start_id cn_sca_process_batches.start_id%TYPE;

325: l_divider_size NUMBER;
326: divider divider_type := divider_type
327: ();
328: loop_count NUMBER;
329: l_start_id cn_sca_process_batches.start_id%TYPE;
330: l_end_id cn_sca_process_batches.end_id%TYPE;
331: l_user_id NUMBER(15) := fnd_global.user_id;
332: l_login_id NUMBER(15) := fnd_global.login_id;
333: BEGIN

Line 453: SELECT cn_sca_process_batches_s.NEXTVAL

449:
450: IF ((loop_count MOD 2) = 0) THEN
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

Line 515: SELECT cn_sca_process_batches_s.NEXTVAL

511:
512: IF (loop_count > l_worker_num AND l_physical_batch_size = 1) THEN
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

Line 564: SELECT cn_sca_process_batches_s.NEXTVAL

560:
561: IF (
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