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 722: FROM sys.dual;

718: l_end_id := l_id;
719:
720: SELECT cn_sca_process_batches_s.NEXTVAL
721: INTO l_sca_process_batch_id
722: FROM sys.dual;
723:
724: insert into CN_SCA_PROCESS_BATCHES
725: ( sca_process_batch_id,
726: start_id,

Line 776: FROM sys.dual;

772: l_end_id := l_id;
773:
774: SELECT cn_sca_process_batches_s.NEXTVAL
775: INTO l_sca_process_batch_id
776: FROM sys.dual;
777:
778: insert into CN_SCA_PROCESS_BATCHES
779: ( sca_process_batch_id,
780: start_id,

Line 816: FROM sys.dual;

812: if (loop_count < l_worker_num or (loop_count = l_worker_num and l_physical_batch_size < 1)) then
813:
814: SELECT cn_sca_process_batches_s.NEXTVAL
815: INTO l_sca_process_batch_id
816: FROM sys.dual;
817:
818: insert into CN_SCA_PROCESS_BATCHES
819: ( sca_process_batch_id,
820: start_id,

Line 2139: FROM sys.dual;

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

Line 2143: FROM sys.dual;

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,
2146: p_start_date,
2147: p_end_date,

Line 2388: FROM sys.dual;

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

Line 2421: FROM sys.dual;

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

Line 2451: FROM sys.dual;

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

Line 3965: -- from dual;

3961:
3962: -- select NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
3963: -- SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
3964: -- into l_org_id
3965: -- from dual;
3966:
3967: l_org_id := p_org_id; -- replaced the able select statement with the assignment statement
3968:
3969: if l_org_id = -99 then