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 3733: FROM OKC_K_PROCESSES

3729: l_chr_id NUMBER;
3730: l_not_found BOOLEAN;
3731: Cursor l_cpsv_csr(p_id IN NUMBER) Is
3732: SELECT CHR_ID
3733: FROM OKC_K_PROCESSES
3734: WHERE ID = p_id;
3735: BEGIN
3736: -- check whether the process is active or not
3737: l_process_active_yn := Is_Process_Active(p_cpsv_rec.chr_id);

Line 4153: okc_k_processes cpsv

4149: wf_process_name,
4150: procedure_name,
4151: package_name
4152: FROM okc_process_defs_v pdfv,
4153: okc_k_processes cpsv
4154: WHERE pdfv.id = cpsv.pdf_id
4155: AND cpsv.chr_id = l_chr_id
4156: AND cpsv.last_update_date = (SELECT MAX(last_update_date)
4157: FROM okc_k_processes

Line 4157: FROM okc_k_processes

4153: okc_k_processes cpsv
4154: WHERE pdfv.id = cpsv.pdf_id
4155: AND cpsv.chr_id = l_chr_id
4156: AND cpsv.last_update_date = (SELECT MAX(last_update_date)
4157: FROM okc_k_processes
4158: WHERE chr_id = l_chr_id);
4159: BEGIN
4160: x_return_status := OKC_API.G_RET_STS_SUCCESS;
4161: -- get id from header table