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_CREATE_PUB dependencies on AK_ATTRIBUTES_VL

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

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

Line 50: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

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

Line 3909: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

3905: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3906: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3907: l_object_code VARCHAR2(30) DEFAULT NULL;
3908:
3909: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
3910:
3911: BEGIN
3912:
3913: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(

Line 4204: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

4200: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4201: l_object_code VARCHAR2(30) DEFAULT NULL;
4202: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4203:
4204: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4205:
4206: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4207: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4208: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 4839: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

4835: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4836: l_object_code VARCHAR2(30) DEFAULT NULL;
4837: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4838:
4839: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4840:
4841: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4842: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
4843: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 5442: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

5438: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5439: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5440: l_object_code VARCHAR2(30) DEFAULT NULL;
5441:
5442: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
5443: l_chr_id NUMBER;
5444:
5445: CURSOR l_chk_cust_acc_csr(p_cust_acc_id1 VARCHAR2, p_name VARCHAR2) IS
5446: SELECT COUNT(1)

Line 5716: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

5712: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5713: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5714: l_object_code VARCHAR2(30) DEFAULT NULL;
5715:
5716: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
5717: l_chr_id NUMBER;
5718:
5719: cursor l_get_cust_id_csr(p_name VARCHAR2) is
5720: select OKX_PARTY.ID1, OKX_PARTY.ID2

Line 6458: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

6454: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6455: l_object_code VARCHAR2(30) DEFAULT NULL;
6456: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;
6457:
6458: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
6459: l_chr_id NUMBER;
6460: row_cnt NUMBER;
6461: l_rgp_id NUMBER := NULL;
6462: l_rul_id NUMBER := NULL;

Line 8060: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

8056: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8057: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8058: l_object_code VARCHAR2(30) DEFAULT NULL;
8059:
8060: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
8061: l_chr_id NUMBER;
8062: row_cnt NUMBER;
8063:
8064: CURSOR l_load_hdr_csr IS