APPS.OKL_VENDOR_PROGRAM_PVT dependencies on OKC_K_PROCESSES

Line 256: -- if the insert in the okc_k_headers_v is successful,then insert a record into okc_k_processes_v

252: x_chrv_rec => x_header_rec,
253: x_khrv_rec => x_k_header_rec);
254: x_chrv_rec := x_header_rec;
255: x_khrv_rec := x_k_header_rec;
256: -- if the insert in the okc_k_headers_v is successful,then insert a record into okc_k_processes_v
257:
258: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
259:
260: IF (((p_hdr_rec.p_workflow_process) <> OKL_API.G_MISS_NUM) AND ((p_hdr_rec.p_workflow_process) IS NOT NULL))THEN

Line 1094: FROM okc_k_processes_v p

1090: WHERE v.id =program_id;
1091:
1092: CURSOR cur_k_process_id(program_id number) IS
1093: SELECT p.id
1094: FROM okc_k_processes_v p
1095: WHERE p.chr_id=program_id;
1096:
1097: l_party_id NUMBER;
1098:

Line 1576: l_item_key OKC_K_PROCESSES.PROCESS_ID%TYPE;

1572:
1573: FUNCTION Is_Process_Active(p_chr_id IN okl_k_headers_full_v.id%TYPE) RETURN VARCHAR2 IS
1574:
1575: l_wf_name OKC_PROCESS_DEFS_B.WF_NAME%TYPE;
1576: l_item_key OKC_K_PROCESSES.PROCESS_ID%TYPE;
1577: l_return_code VARCHAR2(1) := 'N';
1578: l_end_date DATE;
1579:
1580: -- cursor for item type and item key

Line 1584: okc_k_processes cpsv

1580: -- cursor for item type and item key
1581: CURSOR l_pdfv_csr Is
1582: SELECT pdfv.wf_name, cpsv.process_id
1583: FROM okc_process_defs_b pdfv,
1584: okc_k_processes cpsv
1585: WHERE pdfv.id = cpsv.pdf_id
1586: AND cpsv.chr_id = p_chr_id;
1587:
1588: -- cursor to check active process