APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on AK_ATTRIBUTES_VL

Line 23: FROM ak_region_items ri, AK_REGIONS r, AK_ATTRIBUTES_vL a

19: RETURN VARCHAR2 IS
20:
21: CURSOR ak_prompt_csr(p_ak_region VARCHAR2, p_ak_attribute VARCHAR2) IS
22: SELECT a.attribute_label_long
23: FROM ak_region_items ri, AK_REGIONS r, AK_ATTRIBUTES_vL a
24: WHERE ri.region_code = r.region_code
25: AND ri.attribute_code = a.attribute_code
26: AND ri.region_code = p_ak_region
27: AND ri.attribute_code = p_ak_attribute;

Line 29: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

25: AND ri.attribute_code = a.attribute_code
26: AND ri.region_code = p_ak_region
27: AND ri.attribute_code = p_ak_attribute;
28:
29: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
30: BEGIN
31: OPEN ak_prompt_csr(p_ak_region, p_ak_attribute);
32: FETCH ak_prompt_csr INTO l_ak_prompt;
33: CLOSE ak_prompt_csr;

Line 120: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

116:
117: l_api_name CONSTANT VARCHAR2(30) := 'create_contract_link_serv';
118: l_api_version CONSTANT NUMBER := 1.0;
119: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
120: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
121:
122: l_auth number := null;
123: l_inv number := null;
124:

Line 403: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

399:
400: l_api_name CONSTANT VARCHAR2(30) := 'update_contract_link_serv';
401: l_api_version CONSTANT NUMBER := 1.0;
402: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
403: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
404:
405: BEGIN
406:
407: l_chr_id := p_chr_id;

Line 1809: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

1805: l_cap_yn VARCHAR2(3);
1806: l_mult_factor NUMBER;
1807: l_line_amount NUMBER;
1808: l_initial_direct_cost okl_k_lines.initial_direct_cost%type := null;
1809: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1810:
1811: l_clev_rec clev_rec_type ;
1812: l_klev_rec klev_rec_type ;
1813: x_clev_rec clev_rec_type ;