APPS.OKL_CONTRACT_APP_WF dependencies on OKC_K_HEADERS_V

Line 137: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

133: resultout OUT NOCOPY VARCHAR2) IS
134:
135: l_api_name CONSTANT VARCHAR2(30) := 'populate_attributes';
136:
137: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
138: l_chrv_id OKC_K_HEADERS_V.ID%TYPE;
139:
140: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
141: IS

Line 138: l_chrv_id OKC_K_HEADERS_V.ID%TYPE;

134:
135: l_api_name CONSTANT VARCHAR2(30) := 'populate_attributes';
136:
137: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
138: l_chrv_id OKC_K_HEADERS_V.ID%TYPE;
139:
140: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
141: IS
142: SELECT chrv.contract_number

Line 140: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)

136:
137: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
138: l_chrv_id OKC_K_HEADERS_V.ID%TYPE;
139:
140: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
141: IS
142: SELECT chrv.contract_number
143: FROM okc_k_headers_v chrv
144: WHERE chrv.id = p_contract_id;

Line 143: FROM okc_k_headers_v chrv

139:
140: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
141: IS
142: SELECT chrv.contract_number
143: FROM okc_k_headers_v chrv
144: WHERE chrv.id = p_contract_id;
145:
146: lx_return_status VARCHAR2(1);
147: