APPS.CN_SCA_TRX_PROC_PVT dependencies on CN_SCA_PROCESS_BATCHES_S

Line 327: l_sca_process_batch_id cn_sca_process_batches.sca_process_batch_id%TYPE;

323: l_sql_stmt_id VARCHAR2(10000);
324: l_sql_stmt_divider VARCHAR2(10000);
325: l_sql_stmt_resource VARCHAR2(10000);
326: l_no_trx BOOLEAN;
327: l_sca_process_batch_id cn_sca_process_batches.sca_process_batch_id%TYPE;
328:
329: TYPE rc IS REF CURSOR;
330: TYPE divider_type IS TABLE OF NUMBER;
331:

Line 341: l_id cn_sca_process_batches.start_id%TYPE;

337: l_comm_lines_api_id cn_comm_lines_api.comm_lines_api_id%TYPE;
338: l_source_id cn_sca_headers_interface.source_id%TYPE;
339: l_order_number cn_comm_lines_api.order_number%TYPE;
340: l_invoice_number cn_comm_lines_api.invoice_number%TYPE;
341: l_id cn_sca_process_batches.start_id%TYPE;
342:
343: l_logical_batch_size NUMBER;
344: l_worker_num NUMBER;
345: l_physical_batch_size NUMBER;

Line 349: l_start_id cn_sca_process_batches.start_id%TYPE;

345: l_physical_batch_size NUMBER;
346: l_divider_size NUMBER;
347: divider divider_type := divider_type();
348: loop_count NUMBER;
349: l_start_id cn_sca_process_batches.start_id%TYPE;
350: l_end_id cn_sca_process_batches.end_id%TYPE;
351:
352: l_user_id NUMBER(15) := fnd_global.user_id;
353: l_login_id NUMBER(15) := fnd_global.login_id;

Line 720: SELECT cn_sca_process_batches_s.NEXTVAL

716:
717: if ((loop_count mod 2) = 0) then
718: l_end_id := l_id;
719:
720: SELECT cn_sca_process_batches_s.NEXTVAL
721: INTO l_sca_process_batch_id
722: FROM sys.dual;
723:
724: insert into CN_SCA_PROCESS_BATCHES

Line 774: SELECT cn_sca_process_batches_s.NEXTVAL

770:
771: if (loop_count > l_worker_num and l_physical_batch_size = 1) then
772: l_end_id := l_id;
773:
774: SELECT cn_sca_process_batches_s.NEXTVAL
775: INTO l_sca_process_batch_id
776: FROM sys.dual;
777:
778: insert into CN_SCA_PROCESS_BATCHES

Line 814: SELECT cn_sca_process_batches_s.NEXTVAL

810:
811:
812: if (loop_count < l_worker_num or (loop_count = l_worker_num and l_physical_batch_size < 1)) then
813:
814: SELECT cn_sca_process_batches_s.NEXTVAL
815: INTO l_sca_process_batch_id
816: FROM sys.dual;
817:
818: insert into CN_SCA_PROCESS_BATCHES

Line 874: l_start_id cn_sca_process_batches.start_id%TYPE;

870: p_start_date DATE,
871: p_end_date DATE,
872: p_physical_batch_id NUMBER) IS
873:
874: l_start_id cn_sca_process_batches.start_id%TYPE;
875: l_end_id cn_sca_process_batches.end_id%TYPE;
876: l_adjusted_by VARCHAR2(30);
877: conc_status BOOLEAN;
878:

Line 1326: l_start_id cn_sca_process_batches.start_id%TYPE;

1322: sca_lines sca_lines_tbl;
1323: sca_no_rule_lines sca_no_rule_lines_tbl;
1324: sca_not_allocate_lines sca_not_allocate_lines_tbl;
1325:
1326: l_start_id cn_sca_process_batches.start_id%TYPE;
1327: l_end_id cn_sca_process_batches.end_id%TYPE;
1328:
1329: l_adjusted_by VARCHAR2(30);
1330: conc_status BOOLEAN;

Line 2622: l_start_id cn_sca_process_batches.start_id%TYPE;

2618: p_end_date DATE,
2619: p_physical_batch_id NUMBER) IS
2620:
2621: l_batch_type cn_sca_process_batches.type%TYPE;
2622: l_start_id cn_sca_process_batches.start_id%TYPE;
2623: l_end_id cn_sca_process_batches.end_id%TYPE;
2624:
2625: conc_status boolean;
2626:

Line 3420: l_start_id cn_sca_process_batches.start_id%TYPE;

3416: l_sql_stmt VARCHAR2(1000);
3417: l_trx_type VARCHAR2(10);
3418:
3419: l_batch_type cn_sca_process_batches.type%TYPE;
3420: l_start_id cn_sca_process_batches.start_id%TYPE;
3421: l_end_id cn_sca_process_batches.end_id%TYPE;
3422: l_source_id cn_sca_headers_interface.source_id%TYPE;
3423:
3424: l_adjusted_by VARCHAR2(30);