APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_PARALLEL_PROCESSES

Line 3388: OKL_PARALLEL_PROCESSES pws

3384: okl_txl_ar_inv_lns_v t2,
3385: okl_txd_ar_ln_dtls_v t3,
3386: okl_strm_type_v t4,
3387: okc_k_headers_b CHR,
3388: OKL_PARALLEL_PROCESSES pws
3389: WHERE t1.trx_status_code = 'SUBMITTED'
3390: AND t1.khr_id = CHR.id
3391: AND CHR.contract_number = NVL(p_contract_number, CHR.contract_number)
3392: AND t2.tai_id = t1.id

Line 3443: OKL_PARALLEL_PROCESSES pws

3439: FROM okl_trx_ar_invoices_v t1,
3440: okl_txl_ar_inv_lns_v t2,
3441: okl_strm_type_v t4,
3442: okc_k_headers_b CHR,
3443: OKL_PARALLEL_PROCESSES pws
3444: WHERE t1.trx_status_code = 'SUBMITTED'
3445: AND t1.khr_id = CHR.id
3446: AND CHR.contract_number = NVL(p_contract_number, CHR.contract_number)
3447: AND t2.tai_id = t1.id

Line 3750: DELETE OKL_PARALLEL_PROCESSES

3746: -- -------------------------------------------
3747:
3748: IF p_assigned_process IS NOT NULL THEN
3749:
3750: DELETE OKL_PARALLEL_PROCESSES
3751: WHERE assigned_process = p_assigned_process;
3752:
3753: COMMIT;
3754:

Line 3775: DELETE OKL_PARALLEL_PROCESSES

3771: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3772: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3773:
3774: IF p_assigned_process IS NOT NULL THEN
3775: DELETE OKL_PARALLEL_PROCESSES
3776: WHERE assigned_process = p_assigned_process;
3777: COMMIT;
3778: END IF;
3779:

Line 3797: DELETE OKL_PARALLEL_PROCESSES

3793: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3794: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3795:
3796: IF p_assigned_process IS NOT NULL THEN
3797: DELETE OKL_PARALLEL_PROCESSES
3798: WHERE assigned_process = p_assigned_process;
3799: COMMIT;
3800: END IF;
3801:

Line 3818: DELETE OKL_PARALLEL_PROCESSES

3814: WHEN OTHERS THEN
3815: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 2) => '||SQLERRM);
3816:
3817: IF p_assigned_process IS NOT NULL THEN
3818: DELETE OKL_PARALLEL_PROCESSES
3819: WHERE assigned_process = p_assigned_process;
3820: COMMIT;
3821: END IF;
3822: