eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_DEAL_CREAT_PVT dependencies on AK_ATTRIBUTES_VL

Line 39: from ak_region_items ri, ak_regions r, ak_attributes_vl a

35:
36: CURSOR ak_prompt_csr(p_ak_region VARCHAR2, p_ak_attribute VARCHAR2) IS
37: --start modified abhsaxen for performance SQLID 20562566
38: select a.attribute_label_long
39: from ak_region_items ri, ak_regions r, ak_attributes_vl a
40: where ri.region_code = r.region_code
41: and ri.region_application_id = r.region_application_id
42: and ri.attribute_code = a.attribute_code
43: and ri.attribute_application_id = a.attribute_application_id

Line 49: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

45: and ri.attribute_code = p_ak_attribute
46: --end modified abhsaxen for performance SQLID 20562566
47: ;
48:
49: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
50: BEGIN
51: OPEN ak_prompt_csr(p_ak_region, p_ak_attribute);
52: FETCH ak_prompt_csr INTO l_ak_prompt;
53: CLOSE ak_prompt_csr;

Line 3889: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

3885: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3886: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3887: l_object_code VARCHAR2(30) DEFAULT NULL;
3888:
3889: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
3890:
3891: BEGIN
3892:
3893: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(

Line 4184: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

4180: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4181: l_object_code VARCHAR2(30) DEFAULT NULL;
4182: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4183:
4184: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4185:
4186: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4187: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4188: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 4820: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

4816: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4817: l_object_code VARCHAR2(30) DEFAULT NULL;
4818: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4819:
4820: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4821:
4822: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4823: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4824: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 5564: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

5560: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5561: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5562: l_object_code VARCHAR2(30) DEFAULT NULL;
5563:
5564: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
5565: l_chr_id NUMBER;
5566:
5567: CURSOR l_chk_cust_acc_csr(p_cust_acc_id1 VARCHAR2, p_name VARCHAR2) IS
5568: SELECT COUNT(1)

Line 5840: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

5836: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5837: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5838: l_object_code VARCHAR2(30) DEFAULT NULL;
5839:
5840: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
5841: l_chr_id NUMBER;
5842:
5843: cursor l_get_cust_id_csr(p_name VARCHAR2) is
5844: select OKX_PARTY.ID1, OKX_PARTY.ID2

Line 6620: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

6616: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6617: l_object_code VARCHAR2(30) DEFAULT NULL;
6618: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;
6619:
6620: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
6621: l_chr_id NUMBER;
6622: row_cnt NUMBER;
6623: l_rgp_id NUMBER := NULL;
6624: l_rul_id NUMBER := NULL;

Line 8329: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

8325: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8326: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8327: l_object_code VARCHAR2(30) DEFAULT NULL;
8328:
8329: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
8330: l_chr_id NUMBER;
8331: row_cnt NUMBER;
8332:
8333: CURSOR l_load_hdr_csr IS