DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_FEE_PVT dependencies on AK_ATTRIBUTES_VL

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

917: RETURN VARCHAR2 IS
918:
919: CURSOR ak_prompt_csr(p_ak_region VARCHAR2, p_ak_attribute VARCHAR2) IS
920: SELECT a.attribute_label_long
921: FROM ak_region_items ri, AK_REGIONS r, AK_ATTRIBUTES_vL a
922: WHERE ri.region_code = r.region_code
923: AND ri.attribute_code = a.attribute_code
924: AND ri.attribute_application_id = a.attribute_application_id
925: AND ri.region_application_id = r.region_application_id

Line 929: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

925: AND ri.region_application_id = r.region_application_id
926: AND ri.attribute_code = p_ak_attribute
927: AND ri.region_code = p_ak_region;
928:
929: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
930: BEGIN
931: OPEN ak_prompt_csr(p_ak_region, p_ak_attribute);
932: FETCH ak_prompt_csr INTO l_ak_prompt;
933: CLOSE ak_prompt_csr;

Line 957: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

953: ) IS
954:
955: l_api_name CONSTANT VARCHAR2(30) := 'validate_fee_type';
956: l_api_version CONSTANT NUMBER := 1.0;
957: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
958:
959: l_supp_id okx_vendors_v.id1%type := null;
960: l_party_name okx_vendors_v.name%type := null;
961: l_item_id NUMBER:= null;

Line 1923: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

1919: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type) IS
1920:
1921: l_api_name CONSTANT VARCHAR2(30) := 'fill_fee_type_info';
1922: l_api_version CONSTANT NUMBER := 1.0;
1923: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1924:
1925: l_lse_id OKC_LINE_STYLES_B.id%type := null;
1926: l_currency_code okc_k_headers_b.currency_code%type := null;
1927: l_sts_code okc_k_headers_b.sts_code%type := null;

Line 2362: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

2358: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2359:
2360: l_api_name CONSTANT VARCHAR2(30) := 'create_fee_type';
2361: l_api_version CONSTANT NUMBER := 1.0;
2362: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
2363:
2364: BEGIN
2365:
2366: -- call START_ACTIVITY to create savepoint, check compatibility

Line 2800: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

2796: l_rul_id okc_rules_v.id%type := null;
2797:
2798: l_api_name CONSTANT VARCHAR2(30) := 'update_fee_type';
2799: l_api_version CONSTANT NUMBER := 1.0;
2800: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
2801:
2802: CURSOR l_strm_type_rul_csr IS
2803: select rgp.id,
2804: rul.id

Line 5492: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

5488:
5489: l_api_version CONSTANT NUMBER := 1.0;
5490: l_price_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%type;
5491:
5492: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
5493: l_check_box_val VARCHAR2(450);
5494: l_cim_id NUMBER;
5495: --Bug# 4524091
5496: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;