APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on CN_SCA_PROCESS_BATCHES

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 238: FROM cn_sca_process_batches

234:
235: -- Get individual physical batch id's for the entire logical batch
236: CURSOR physical_batches IS
237: SELECT DISTINCT sca_process_batch_id
238: FROM cn_sca_process_batches
239: WHERE logical_batch_id = x_logical_batch_id;
240:
241: physical_rec physical_batches%ROWTYPE;
242: BEGIN

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 408: l_end_id cn_sca_process_batches.end_id%TYPE;

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
412: debugmsg('Allocation Process : Split Batches Start ');

Line 515: debugmsg(p_transaction_source || ': Assign : Insert into CN_SCA_PROCESS_BATCHES ');

511: OPEN query_cur
512: FOR l_sql_stmt_id USING p_start_date, p_end_date, p_transaction_source, p_org_id;
513:
514: loop_count := 1;
515: debugmsg(p_transaction_source || ': Assign : Insert into CN_SCA_PROCESS_BATCHES ');
516:
517: IF (l_physical_batch_size >= 2) THEN
518: LOOP
519: FETCH query_cur

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 535: INSERT INTO cn_sca_process_batches

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
536: (
537: sca_process_batch_id
538: , start_id
539: , end_id

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 597: INSERT INTO cn_sca_process_batches

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
598: (
599: sca_process_batch_id
600: , start_id
601: , end_id

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

Line 646: INSERT INTO cn_sca_process_batches

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
647: (
648: sca_process_batch_id
649: , start_id
650: , end_id