APPS.OKL_KBK_APPROVALS_WF dependencies on OKC_K_HEADERS_B

Line 227: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE)

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

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

626: AND chrv.sts_code = stsv.code;
627: -- Changed query as part of Bug#4693302 by zrehman : ends
628:
629: -- start: cklee 31-May-2005 okl.h Lease App IA Authoring
630: CURSOR l_okl_list_contents_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
631: IS
632: SELECT DNZ_CHECKLIST_OBJ_ID,
633: TODO_ITEM_CODE,
634: TODO_ITEM_MEANING,

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

641: CHECKIST_RESULTS
642: FROM okl_instance_checklist_dtl_uv
643: WHERE DNZ_CHECKLIST_OBJ_ID = p_chr_id;
644:
645: CURSOR c_contract(p_contract_id OKC_K_HEADERS_B.ID%TYPE)
646: IS
647: select 1
648: from okc_k_headers_b
649: where ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'

Line 648: from okc_k_headers_b

644:
645: CURSOR c_contract(p_contract_id OKC_K_HEADERS_B.ID%TYPE)
646: IS
647: select 1
648: from okc_k_headers_b
649: where ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'
650: and id = p_contract_id;
651: -- end: cklee 31-May-2005 okl.h Lease App IA Authoring
652:

Line 1318: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE; -- Bug#9873432

1314: --
1315:
1316: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1317: l_process_status VARCHAR2 (1) := okl_api.g_ret_sts_success; -- Bug#9873432
1318: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE; -- Bug#9873432
1319: l_api_version NUMBER := 1.0;
1320: l_msg_count NUMBER;
1321: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
1322: l_msg_data VARCHAR2(2000);

Line 1558: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

1554: document IN OUT nocopy VARCHAR2,
1555: document_type IN OUT nocopy VARCHAR2) IS
1556:
1557: l_message VARCHAR2(32000);
1558: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1559: BEGIN
1560:
1561: l_contract_number := wf_engine.GetItemAttrText (
1562: itemtype => G_ITEM_TYPE_WF,

Line 1595: l_contract_number okc_k_headers_b.contract_number%TYPE;

1591: resultout OUT NOCOPY VARCHAR2 )
1592: IS
1593: l_approval_option VARCHAR2(5);
1594: l_contract_id VARCHAR2(240);
1595: l_contract_number okc_k_headers_b.contract_number%TYPE;
1596:
1597: l_api_name VARCHAR2(30) := 'check_approval_process';
1598:
1599: BEGIN