APPS.OKL_LA_TRADEIN_PVT dependencies on AK_ATTRIBUTES_VL

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

8: RETURN VARCHAR2 IS
9:
10: CURSOR ak_prompt_csr(p_ak_region VARCHAR2, p_ak_attribute VARCHAR2) IS
11: SELECT a.attribute_label_long
12: FROM ak_region_items ri, AK_REGIONS r, AK_ATTRIBUTES_vL a
13: WHERE ri.region_code = r.region_code
14: AND ri.attribute_code = a.attribute_code
15: AND ri.region_code = p_ak_region
16: AND ri.attribute_code = p_ak_attribute;

Line 18: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

14: AND ri.attribute_code = a.attribute_code
15: AND ri.region_code = p_ak_region
16: AND ri.attribute_code = p_ak_attribute;
17:
18: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
19: BEGIN
20: OPEN ak_prompt_csr(p_ak_region, p_ak_attribute);
21: FETCH ak_prompt_csr INTO l_ak_prompt;
22: CLOSE ak_prompt_csr;

Line 600: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

596: l_tradein_desc okl_k_headers.tradein_description%TYPE := p_tradein_desc;
597:
598: l_api_name CONSTANT VARCHAR2(30) := 'update_contract';
599: l_api_version CONSTANT NUMBER := 1.0;
600: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
601:
602: BEGIN
603:
604: -- call START_ACTIVITY to create savepoint, check compatibility

Line 881: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

877: l_chr_id okc_k_headers_b.id%type := p_chr_id;
878:
879: l_api_name CONSTANT VARCHAR2(30) := 'create_tradein';
880: l_api_version CONSTANT NUMBER := 1.0;
881: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
882:
883: BEGIN
884:
885: -- call START_ACTIVITY to create savepoint, check compatibility

Line 1060: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

1056: l_chr_id okc_k_headers_b.id%type := p_chr_id;
1057:
1058: l_api_name CONSTANT VARCHAR2(30) := 'create_tradein';
1059: l_api_version CONSTANT NUMBER := 1.0;
1060: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1061: i number := 0;
1062:
1063:
1064: BEGIN

Line 1201: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

1197: l_chr_id okc_k_headers_b.id%type := p_chr_id;
1198:
1199: l_api_name CONSTANT VARCHAR2(30) := 'create_tradein';
1200: l_api_version CONSTANT NUMBER := 1.0;
1201: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1202:
1203: BEGIN
1204:
1205: -- call START_ACTIVITY to create savepoint, check compatibility

Line 1324: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

1320: l_chr_id okc_k_headers_b.id%type := p_chr_id;
1321:
1322: l_api_name CONSTANT VARCHAR2(30) := 'create_tradein';
1323: l_api_version CONSTANT NUMBER := 1.0;
1324: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1325: i number := 0;
1326:
1327:
1328: BEGIN

Line 1827: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

1823: l_chr_id okc_k_headers_b.id%type := p_chr_id;
1824:
1825: l_api_name CONSTANT VARCHAR2(30) := 'delete_contract';
1826: l_api_version CONSTANT NUMBER := 1.0;
1827: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1828:
1829:
1830: BEGIN
1831: