DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_FEE_PVT dependencies on AK_ATTRIBUTES_VL

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

908: RETURN VARCHAR2 IS
909:
910: CURSOR ak_prompt_csr(p_ak_region VARCHAR2, p_ak_attribute VARCHAR2) IS
911: SELECT a.attribute_label_long
912: FROM ak_region_items ri, AK_REGIONS r, AK_ATTRIBUTES_vL a
913: WHERE ri.region_code = r.region_code
914: AND ri.attribute_code = a.attribute_code
915: AND ri.attribute_application_id = a.attribute_application_id
916: AND ri.region_application_id = r.region_application_id

Line 920: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

916: AND ri.region_application_id = r.region_application_id
917: AND ri.attribute_code = p_ak_attribute
918: AND ri.region_code = p_ak_region;
919:
920: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
921: BEGIN
922: OPEN ak_prompt_csr(p_ak_region, p_ak_attribute);
923: FETCH ak_prompt_csr INTO l_ak_prompt;
924: CLOSE ak_prompt_csr;

Line 948: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

944: ) IS
945:
946: l_api_name CONSTANT VARCHAR2(30) := 'validate_fee_type';
947: l_api_version CONSTANT NUMBER := 1.0;
948: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
949:
950: l_supp_id okx_vendors_v.id1%type := null;
951: l_party_name okx_vendors_v.name%type := null;
952: l_item_id NUMBER:= null;

Line 1914: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

1910: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type) IS
1911:
1912: l_api_name CONSTANT VARCHAR2(30) := 'fill_fee_type_info';
1913: l_api_version CONSTANT NUMBER := 1.0;
1914: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1915:
1916: l_lse_id OKC_LINE_STYLES_B.id%type := null;
1917: l_currency_code okc_k_headers_b.currency_code%type := null;
1918: l_sts_code okc_k_headers_b.sts_code%type := null;

Line 2349: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

2345: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2346:
2347: l_api_name CONSTANT VARCHAR2(30) := 'create_fee_type';
2348: l_api_version CONSTANT NUMBER := 1.0;
2349: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
2350:
2351: BEGIN
2352:
2353: -- call START_ACTIVITY to create savepoint, check compatibility

Line 2787: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

2783: l_rul_id okc_rules_v.id%type := null;
2784:
2785: l_api_name CONSTANT VARCHAR2(30) := 'update_fee_type';
2786: l_api_version CONSTANT NUMBER := 1.0;
2787: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
2788:
2789: CURSOR l_strm_type_rul_csr IS
2790: select rgp.id,
2791: rul.id

Line 5479: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

5475:
5476: l_api_version CONSTANT NUMBER := 1.0;
5477: l_price_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%type;
5478:
5479: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
5480: l_check_box_val VARCHAR2(450);
5481: l_cim_id NUMBER;
5482: --Bug# 4524091
5483: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;