APPS.OKC_CONTRACT_PVT dependencies on OKC_K_PROCESSES

Line 77: l_item_key OKC_K_PROCESSES.PROCESS_ID%TYPE;

73: --
74: FUNCTION Is_Process_Active(p_chr_id IN NUMBER) RETURN VARCHAR2 Is
75:
76: l_wf_name OKC_PROCESS_DEFS_B.WF_NAME%TYPE;
77: l_item_key OKC_K_PROCESSES.PROCESS_ID%TYPE;
78: l_return_code VARCHAR2(1) := 'N';
79: l_end_date DATE;
80:
81: -- cursor for item type and item key

Line 85: okc_k_processes cpsv

81: -- cursor for item type and item key
82: Cursor l_pdfv_csr Is
83: SELECT pdfv.wf_name, cpsv.process_id
84: FROM okc_process_defs_b pdfv,
85: okc_k_processes cpsv
86: WHERE pdfv.id = cpsv.pdf_id
87: AND cpsv.chr_id = p_chr_id;
88:
89: -- cursor to check active process

Line 3675: FROM OKC_K_PROCESSES

3671: l_chr_id NUMBER;
3672: l_not_found BOOLEAN;
3673: Cursor l_cpsv_csr(p_id IN NUMBER) Is
3674: SELECT CHR_ID
3675: FROM OKC_K_PROCESSES
3676: WHERE ID = p_id;
3677: BEGIN
3678: -- check whether the process is active or not
3679: l_process_active_yn := Is_Process_Active(p_cpsv_rec.chr_id);

Line 4095: okc_k_processes cpsv

4091: wf_process_name,
4092: procedure_name,
4093: package_name
4094: FROM okc_process_defs_v pdfv,
4095: okc_k_processes cpsv
4096: WHERE pdfv.id = cpsv.pdf_id
4097: AND cpsv.chr_id = l_chr_id
4098: AND cpsv.last_update_date = (SELECT MAX(last_update_date)
4099: FROM okc_k_processes

Line 4099: FROM okc_k_processes

4095: okc_k_processes cpsv
4096: WHERE pdfv.id = cpsv.pdf_id
4097: AND cpsv.chr_id = l_chr_id
4098: AND cpsv.last_update_date = (SELECT MAX(last_update_date)
4099: FROM okc_k_processes
4100: WHERE chr_id = l_chr_id);
4101: BEGIN
4102: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4103: -- get id from header table