APPS.OKL_AM_BTCH_EXP_LEASE_LOAN_PVT dependencies on OKL_PARALLEL_PROCESSES

Line 3368: FROM okl_parallel_processes opp

3364: CURSOR get_contracts_of_process_csr (p_assigned_process IN VARCHAR2) IS
3365: SELECT opp.khr_id khr_id,
3366: opp.object_value contract_number,
3367: opp.trx_id trx_id
3368: FROM okl_parallel_processes opp
3369: WHERE opp.assigned_process = p_assigned_process;
3370:
3371: -- rmunjulu LOANS_ENHANCEMENTS
3372: CURSOR k_details_csr (p_khr_id IN NUMBER) IS

Line 3747: DELETE FROM okl_parallel_processes

3743: -- create report
3744: create_report;
3745:
3746: -- Do clean up of parallel processes
3747: DELETE FROM okl_parallel_processes
3748: WHERE assigned_process = p_assigned_processes;
3749:
3750: IF (is_debug_procedure_on) THEN
3751: okl_debug_pub.log_debug (g_level_procedure, l_module_name, 'End(-)');

Line 3830: FROM okl_parallel_processes opp

3826: --
3827: AND k.ID = t.khr_id)
3828: WHERE NOT EXISTS (
3829: SELECT '1'
3830: FROM okl_parallel_processes opp
3831: WHERE contract_number = opp.object_value
3832: AND opp.object_type = 'CONT_TERM'
3833: AND opp.process_status IN
3834: ('PENDING_ASSIGNMENT', 'ASSIGNED'));

Line 3841: okl_parallel_processes opp

3837: --Bug # 6174484 fixed for SQL Performance ssdehpa start
3838: CURSOR chk_data_volume_csr (p_seq_next VARCHAR2) IS
3839: /* SELECT opp.object_value contract_number , count(KLE.id) line_count
3840: FROM OKC_K_LINES_B KLE,
3841: okl_parallel_processes opp
3842: WHERE opp.khr_id = KLE.dnz_chr_id
3843: AND KLE.sts_code = ('BOOKED')
3844: AND opp.khr_id NOT IN(
3845: SELECT NVL(TCN.khr_id,-9999) khr_id

Line 3866: FROM okl_parallel_processes opp,

3862: AND opp.assigned_process = p_seq_next
3863: GROUP BY opp.object_value
3864: UNION
3865: SELECT opp.object_value contract_number, count(KLE.id) line_count
3866: FROM okl_parallel_processes opp,
3867: OKL_TRX_CONTRACTS T,
3868: OKC_K_LINES_B KLE
3869: WHERE NVL(T.tmt_recycle_yn,'?') = 'Y'
3870: AND opp.khr_id = KLE.dnz_chr_id

Line 3880: FROM okc_k_lines_b kle, okl_parallel_processes opp

3876: AND opp.assigned_process = p_seq_next
3877: GROUP BY opp.object_value; */
3878: SELECT opp.object_value contract_number,
3879: COUNT (kle.ID) line_count
3880: FROM okc_k_lines_b kle, okl_parallel_processes opp
3881: WHERE opp.khr_id = kle.dnz_chr_id
3882: AND kle.sts_code = ('BOOKED')
3883: AND opp.khr_id NOT IN (
3884: SELECT NVL (tcn.khr_id, -9999) khr_id

Line 3916: FROM okl_parallel_processes opp,

3912: GROUP BY opp.object_value
3913: UNION
3914: SELECT opp.object_value contract_number,
3915: COUNT (kle.ID) line_count
3916: FROM okl_parallel_processes opp,
3917: okl_trx_contracts t,
3918: okc_k_lines_b kle
3919: WHERE NVL (t.tmt_recycle_yn, '?') = 'Y'
3920: AND opp.khr_id = kle.dnz_chr_id

Line 4052: INSERT INTO okl_parallel_processes

4048:
4049: -- mark records for processing
4050: FOR chk_update_header_csr_rec IN chk_update_header_csr
4051: LOOP
4052: INSERT INTO okl_parallel_processes
4053: (object_type,
4054: object_value,
4055: assigned_process,
4056: process_status,

Line 4214: UPDATE okl_parallel_processes

4210: IF l_sort_tab1.EXISTS (i)
4211: AND (l_sort_tab1 (i).worker_number =
4212: l_worker_load (j).worker_number
4213: ) THEN
4214: UPDATE okl_parallel_processes
4215: SET assigned_process =
4216: l_seq_next
4217: || '-'
4218: || l_sort_tab1 (i).worker_number,

Line 4267: DELETE okl_parallel_processes

4263: END LOOP;
4264:
4265: -- clean up
4266: -- Delete records from in chk_update_header_csr that were unassigned
4267: DELETE okl_parallel_processes
4268: WHERE process_status = 'PENDING_ASSIGNMENT'
4269: AND assigned_process = TO_CHAR (l_seq_next);
4270:
4271: COMMIT;