APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_PARALLEL_PROCESSES

Line 3034: OKL_PARALLEL_PROCESSES pws

3030: OKL_K_HEADERS khl,
3031: okc_k_lines_b kle,
3032: okc_statuses_b khs,
3033: okc_statuses_b kls,
3034: OKL_PARALLEL_PROCESSES pws
3035: WHERE TRUNC(ste.stream_element_date) >=
3036: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
3037: AND TRUNC(ste.stream_element_date) <=
3038: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 3090: OKL_PARALLEL_PROCESSES pws

3086: okc_k_lines_b kle,
3087: okc_statuses_b khs,
3088: okc_statuses_b kls,
3089: okc_k_lines_b cle,
3090: OKL_PARALLEL_PROCESSES pws
3091: WHERE TRUNC(ste.stream_element_date) >=
3092: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
3093: AND TRUNC(ste.stream_element_date) <=
3094: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 3142: OKL_PARALLEL_PROCESSES pws

3138: OKL_K_HEADERS khl,
3139: okc_k_lines_b kle,
3140: okc_statuses_b khs,
3141: okc_statuses_b kls,
3142: OKL_PARALLEL_PROCESSES pws
3143: WHERE TRUNC(ste.stream_element_date) >=
3144: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
3145: AND TRUNC(ste.stream_element_date) <=
3146: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 3205: OKL_PARALLEL_PROCESSES pws

3201: OKL_K_HEADERS khl,
3202: okc_k_lines_b kle,
3203: okc_statuses_b khs,
3204: okc_statuses_b kls,
3205: OKL_PARALLEL_PROCESSES pws
3206: WHERE TRUNC(ste.stream_element_date) >=
3207: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
3208: AND TRUNC(ste.stream_element_date) <=
3209: TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))

Line 3863: DELETE OKL_PARALLEL_PROCESSES

3859: -- Purge data from the Parallel process Table
3860: -- -------------------------------------------
3861: IF p_assigned_process IS NOT NULL THEN
3862:
3863: DELETE OKL_PARALLEL_PROCESSES
3864: WHERE assigned_process = p_assigned_process;
3865:
3866: COMMIT;
3867:

Line 3892: DELETE OKL_PARALLEL_PROCESSES

3888: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3889: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (EXCP) => '||SQLERRM);
3890:
3891: IF p_assigned_process IS NOT NULL THEN
3892: DELETE OKL_PARALLEL_PROCESSES
3893: WHERE assigned_process = p_assigned_process;
3894: COMMIT;
3895: END IF;
3896:

Line 3914: DELETE OKL_PARALLEL_PROCESSES

3910: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3911: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (UNEXP) => '||SQLERRM);
3912:
3913: IF p_assigned_process IS NOT NULL THEN
3914: DELETE OKL_PARALLEL_PROCESSES
3915: WHERE assigned_process = p_assigned_process;
3916: COMMIT;
3917: END IF;
3918:

Line 3936: DELETE OKL_PARALLEL_PROCESSES

3932: WHEN OTHERS THEN
3933: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Error (OTHERS 1) => '||SQLERRM);
3934:
3935: IF p_assigned_process IS NOT NULL THEN
3936: DELETE OKL_PARALLEL_PROCESSES
3937: WHERE assigned_process = p_assigned_process;
3938: COMMIT;
3939: END IF;
3940: