APPS.CN_SCA_TRX_PROC_PVT dependencies on CN_SCA_LOGICAL_BATCHES_S

Line 2135: SELECT cn_sca_logical_batches_s.NEXTVAL

2131: -- Convert the dates for the varchar2 parameters passed in from concurrent program
2132: p_start_date := fnd_date.canonical_to_date(pp_start_date);
2133: p_end_date := fnd_date.canonical_to_date(pp_end_date);
2134:
2135: SELECT cn_sca_logical_batches_s.NEXTVAL
2136: INTO l_create_logical_batch_id
2137: FROM sys.dual;
2138:
2139: SELECT cn_sca_logical_batches_s.NEXTVAL

Line 2139: SELECT cn_sca_logical_batches_s.NEXTVAL

2135: SELECT cn_sca_logical_batches_s.NEXTVAL
2136: INTO l_create_logical_batch_id
2137: FROM sys.dual;
2138:
2139: SELECT cn_sca_logical_batches_s.NEXTVAL
2140: INTO l_negate_logical_batch_id
2141: FROM sys.dual;
2142:
2143: assign(l_negate_logical_batch_id,

Line 2384: SELECT cn_sca_logical_batches_s.NEXTVAL

2380: x_process_audit_id => l_process_audit_id,
2381: x_request_id => fnd_global.conc_request_id,
2382: p_org_id => p_org_id);
2383:
2384: SELECT cn_sca_logical_batches_s.NEXTVAL
2385: INTO l_logical_batch_id
2386: FROM sys.dual;
2387:
2388: debugmsg('Allocation Transfer : Start of Transfer');

Line 2417: SELECT cn_sca_logical_batches_s.NEXTVAL

2413:
2414:
2415: if (p_checkbox_value = 'Y') then
2416:
2417: SELECT cn_sca_logical_batches_s.NEXTVAL
2418: INTO l_logical_batch_id
2419: FROM sys.dual;
2420:
2421: debugmsg('Allocation Transfer : Need to Rerun ');

Line 2447: SELECT cn_sca_logical_batches_s.NEXTVAL

2443: x_process => 'Rollback_data');
2444:
2445: end if;
2446:
2447: SELECT cn_sca_logical_batches_s.NEXTVAL
2448: INTO l_logical_batch_id
2449: FROM sys.dual;
2450:
2451: debugmsg('Allocation Transfer : Get the set of transactions that needs to be transferred ');