APPS.CN_SCA_TRX_PROC_PVT dependencies on CN_SCA_LOGICAL_BATCHES_S

Line 2137: SELECT cn_sca_logical_batches_s.NEXTVAL

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

Line 2141: SELECT cn_sca_logical_batches_s.NEXTVAL

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

Line 2386: SELECT cn_sca_logical_batches_s.NEXTVAL

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

Line 2419: SELECT cn_sca_logical_batches_s.NEXTVAL

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

Line 2449: SELECT cn_sca_logical_batches_s.NEXTVAL

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