25: IS
26:
27: CURSOR cntrct_status_cur IS
28: SELECT '1'
29: FROM okc_k_headers_v
30: WHERE id = p_contract_id
31: AND sts_code = G_BOOKED;
32:
33: l_dummy_var VARCHAR2(1);
667: l_dummy_var VARCHAR2(1);
668: l_trx_id NUMBER;
669: l_row_notfound BOOLEAN;
670: -- Manu 11-Aug-2004
671: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
672: l_row_found BOOLEAN;
673: --Added by dpsingh for LE uptake
674: l_legal_entity_id NUMBER;
675: l_api_version CONSTANT NUMBER := 1;
696: -- cklee
697:
698: CURSOR cntrct_cur IS
699: SELECT '1'
700: FROM okc_k_headers_v
701: WHERE id = p_contract_id;
702:
703: CURSOR ctrct_trx_cur IS
704: SELECT '1'
737:
738: -- Cursor to select contract number
739:
740: CURSOR contract_number_csr(p_k_id OKC_K_HEADERS_B.ID%TYPE) IS
741: SELECT contract_number FROM okc_k_headers_v
742: WHERE id = p_k_id;
743:
744: -- End Manu 11-Aug-2004
745: