APPS.CN_TRANSACTION_LOAD_PKG dependencies on DUAL

Line 51: FROM SYS.DUAL;

47: BEGIN
48: -- sequence s3 is for physical batch id
49: SELECT cn_process_batches_s3.NEXTVAL
50: INTO x_physical_batch_id
51: FROM SYS.DUAL;
52:
53: RETURN x_physical_batch_id;
54: EXCEPTION
55: WHEN NO_DATA_FOUND THEN

Line 389: -- Get individual physical batch id's for the entire logical batch

385: conc_status BOOLEAN;
386: l_sleep_time NUMBER := 180;
387: l_sleep_time_char VARCHAR2(30);
388:
389: -- Get individual physical batch id's for the entire logical batch
390: CURSOR physical_batches IS
391: SELECT DISTINCT physical_batch_id
392: FROM cn_process_batches
393: WHERE logical_batch_id = x_logical_batch_id AND status_code = 'IN_USE';

Line 1242: SELECT cn_process_batches_s2.NEXTVAL INTO l_logical_batch_id FROM dual;

1238: RAISE fail_validate_ruleset;
1239: END IF;
1240: END IF;
1241:
1242: SELECT cn_process_batches_s2.NEXTVAL INTO l_logical_batch_id FROM dual;
1243:
1244: INSERT INTO cn_process_batches(
1245: process_batch_id
1246: , logical_batch_id

Line 1420: FROM DUAL;

1416:
1417: -- this is used to make it more restrict for handling reversal trx later on
1418: SELECT cn_commission_headers_s.NEXTVAL
1419: INTO l_init_commission_header_id
1420: FROM DUAL;
1421:
1422: FOR batch IN batches LOOP
1423: debugmsg(
1424: 'Loader : Load_Worker : Load '