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 718: SELECT cn_sca_process_batches_s.NEXTVAL

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

Line 772: SELECT cn_sca_process_batches_s.NEXTVAL

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

Line 812: SELECT cn_sca_process_batches_s.NEXTVAL

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

Line 872: l_start_id cn_sca_process_batches.start_id%TYPE;

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

Line 1324: l_start_id cn_sca_process_batches.start_id%TYPE;

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

Line 2620: l_start_id cn_sca_process_batches.start_id%TYPE;

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

Line 3416: l_start_id cn_sca_process_batches.start_id%TYPE;

3412: l_sql_stmt VARCHAR2(1000);
3413: l_trx_type VARCHAR2(10);
3414:
3415: l_batch_type cn_sca_process_batches.type%TYPE;
3416: l_start_id cn_sca_process_batches.start_id%TYPE;
3417: l_end_id cn_sca_process_batches.end_id%TYPE;
3418: l_source_id cn_sca_headers_interface.source_id%TYPE;
3419:
3420: l_adjusted_by VARCHAR2(30);