[Home] [Help]
2386: l_cr_locked BOOLEAN := FALSE;
2387: l_another_cr_locked BOOLEAN := FALSE;
2388: l_user_in_cr BOOLEAN := FALSE;
2389: l_return_status Varchar2(1);
2390: l_user_id okc_k_processes.user_id%TYPE;
2391: --NPALEPU for bug # 4597099 on 13-AUG-2005
2392: /* l_scs_code okc_k_headers_b.scs_code%TYPE;
2393: l_sts_code okc_k_headers_b.sts_code%TYPE; */
2394: l_scs_code okc_k_headers_all_b.scs_code%TYPE;
2414: and sts_code = l_sts_code
2415: and opn_code = p_opn_code
2416: and allowed_yn = p_allowed_yn;
2417: --
2418: cursor lock_csr (p_in_process_yn okc_k_processes.in_process_yn%TYPE) is
2419: select prc.user_id
2420: from okc_k_processes prc,
2421: okc_change_requests_b crq
2422: where crq.id = p_crt_id
2416: and allowed_yn = p_allowed_yn;
2417: --
2418: cursor lock_csr (p_in_process_yn okc_k_processes.in_process_yn%TYPE) is
2419: select prc.user_id
2420: from okc_k_processes prc,
2421: okc_change_requests_b crq
2422: where crq.id = p_crt_id
2423: and crq.chr_id = p_header_id
2424: and crq.datetime_applied is null
2424: and crq.datetime_applied is null
2425: and crq.id = prc.crt_id
2426: and upper(substr(prc.in_process_yn, 1, 1)) = p_in_process_yn;
2427: --
2428: cursor proc_csr (p_in_process_yn okc_k_processes.in_process_yn%TYPE) is
2429: select prc.user_id
2430: from okc_k_processes prc,
2431: okc_change_requests_b crq
2432: where crq.chr_id = p_header_id
2426: and upper(substr(prc.in_process_yn, 1, 1)) = p_in_process_yn;
2427: --
2428: cursor proc_csr (p_in_process_yn okc_k_processes.in_process_yn%TYPE) is
2429: select prc.user_id
2430: from okc_k_processes prc,
2431: okc_change_requests_b crq
2432: where crq.chr_id = p_header_id
2433: and crq.datetime_applied is null
2434: and crq.id = prc.crt_id