APPS.CN_SCA_TRX_PROC_PVT dependencies on DUAL

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

158:
159: l_sleep_time number := 180;
160: l_sleep_time_char varchar2(30);
161:
162: -- Get individual physical batch id's for the entire logical batch
163: CURSOR physical_batches IS
164:
165: SELECT distinct sca_process_batch_id
166: FROM cn_sca_process_batches

Line 720: FROM sys.dual;

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
723: ( sca_process_batch_id,
724: start_id,

Line 774: FROM sys.dual;

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
777: ( sca_process_batch_id,
778: start_id,

Line 814: FROM sys.dual;

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
817: ( sca_process_batch_id,
818: start_id,

Line 2137: FROM sys.dual;

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
2140: INTO l_negate_logical_batch_id
2141: FROM sys.dual;

Line 2141: FROM sys.dual;

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,
2144: p_start_date,
2145: p_end_date,

Line 2386: FROM sys.dual;

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');
2389: debugmsg('Allocation Transfer : process_audit_id is ' || l_process_audit_id );
2390: debugmsg('Allocation Transfer : logical_batch_id is ' || l_logical_batch_id );

Line 2419: FROM sys.dual;

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 ');
2422: debugmsg('Allocation Transfer : Rerun: Logical batch id = ' || l_logical_batch_id);
2423:

Line 2449: FROM sys.dual;

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 ');
2452: debugmsg('Allocation Transfer : Logical batch id = ' || l_logical_batch_id);
2453:

Line 3959: -- from dual;

3955:
3956: -- select NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
3957: -- SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
3958: -- into l_org_id
3959: -- from dual;
3960:
3961: l_org_id := p_org_id; -- replaced the able select statement with the assignment statement
3962:
3963: if l_org_id = -99 then