APPS.OKL_KBK_APPROVALS_WF dependencies on OKC_K_HEADERS_B

Line 226: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE)

222: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE)
227: IS
228:
229: -- Get Contract Details
230: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)

Line 604: CURSOR l_okl_list_contents_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE)

600: AND chrv.sts_code = stsv.code;
601: -- Changed query as part of Bug#4693302 by zrehman : ends
602:
603: -- start: cklee 31-May-2005 okl.h Lease App IA Authoring
604: CURSOR l_okl_list_contents_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
605: IS
606: SELECT DNZ_CHECKLIST_OBJ_ID,
607: TODO_ITEM_CODE,
608: TODO_ITEM_MEANING,

Line 619: CURSOR c_contract(p_contract_id OKC_K_HEADERS_B.ID%TYPE)

615: CHECKIST_RESULTS
616: FROM okl_instance_checklist_dtl_uv
617: WHERE DNZ_CHECKLIST_OBJ_ID = p_chr_id;
618:
619: CURSOR c_contract(p_contract_id OKC_K_HEADERS_B.ID%TYPE)
620: IS
621: select 1
622: from okc_k_headers_b
623: where ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'

Line 622: from okc_k_headers_b

618:
619: CURSOR c_contract(p_contract_id OKC_K_HEADERS_B.ID%TYPE)
620: IS
621: select 1
622: from okc_k_headers_b
623: where ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'
624: and id = p_contract_id;
625: -- end: cklee 31-May-2005 okl.h Lease App IA Authoring
626:

Line 1453: l_contract_number okc_k_headers_b.contract_number%TYPE;

1449: resultout OUT NOCOPY VARCHAR2 )
1450: IS
1451: l_approval_option VARCHAR2(5);
1452: l_contract_id VARCHAR2(240);
1453: l_contract_number okc_k_headers_b.contract_number%TYPE;
1454:
1455: l_api_name VARCHAR2(30) := 'check_approval_process';
1456:
1457: BEGIN