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 386: -- Get individual physical batch id's for the entire logical batch

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

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

1234: RAISE fail_validate_ruleset;
1235: END IF;
1236: END IF;
1237:
1238: SELECT cn_process_batches_s2.NEXTVAL INTO l_logical_batch_id FROM dual;
1239:
1240: INSERT INTO cn_process_batches(
1241: process_batch_id
1242: , logical_batch_id

Line 1408: FROM DUAL;

1404:
1405: -- this is used to make it more restrict for handling reversal trx later on
1406: SELECT cn_commission_headers_s.NEXTVAL
1407: INTO l_init_commission_header_id
1408: FROM DUAL;
1409:
1410: FOR batch IN batches LOOP
1411: debugmsg(
1412: 'Loader : Load_Worker : Load '