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_CONTRACT_LINE_ITEM_PVT dependencies on AK_ATTRIBUTES

Line 225: AK_ATTRIBUTES_TL AAT ,

221:
222: -- Changed the sql for performance issue #5484903
223: Select AAT.attribute_label_long
224: FROM FND_APPLICATION_VL FAV ,
225: AK_ATTRIBUTES_TL AAT ,
226: AK_ATTRIBUTES AA
227: WHERE AA.ATTRIBUTE_APPLICATION_ID = AAT.ATTRIBUTE_APPLICATION_ID
228: AND AA.ATTRIBUTE_CODE = AAT.ATTRIBUTE_CODE
229: AND AAT.LANGUAGE = USERENV('LANG')

Line 226: AK_ATTRIBUTES AA

222: -- Changed the sql for performance issue #5484903
223: Select AAT.attribute_label_long
224: FROM FND_APPLICATION_VL FAV ,
225: AK_ATTRIBUTES_TL AAT ,
226: AK_ATTRIBUTES AA
227: WHERE AA.ATTRIBUTE_APPLICATION_ID = AAT.ATTRIBUTE_APPLICATION_ID
228: AND AA.ATTRIBUTE_CODE = AAT.ATTRIBUTE_CODE
229: AND AAT.LANGUAGE = USERENV('LANG')
230: AND AA.ATTRIBUTE_APPLICATION_ID = FAV.APPLICATION_ID

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

236: and ri.attribute_code = aa.attribute_code );
237:
238: /* --commented for performance issue bug#5484903
239: SELECT a.attribute_label_long
240: FROM ak_region_items ri, AK_REGIONS r, AK_ATTRIBUTES_vL a
241: WHERE ri.region_code = r.region_code
242: AND ri.attribute_code = a.attribute_code
243: AND ri.region_code = p_ak_region
244: AND ri.attribute_code = p_ak_attribute; */

Line 246: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

242: AND ri.attribute_code = a.attribute_code
243: AND ri.region_code = p_ak_region
244: AND ri.attribute_code = p_ak_attribute; */
245:
246: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
247: BEGIN
248: OPEN ak_prompt_csr(p_ak_region, p_ak_attribute);
249: FETCH ak_prompt_csr INTO l_ak_prompt;
250: CLOSE ak_prompt_csr;

Line 1158: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

1154: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1155: lx_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
1156: lx_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1157:
1158: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1159:
1160: --Bug# 3877032
1161: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
1162: l_fin_klev_rec okl_contract_pub.klev_rec_type;

Line 1634: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

1630: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1631: lx_cimv_tbl OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
1632: lx_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1633:
1634: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1635:
1636: --Bug# 3877032
1637: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
1638: l_fin_klev_rec okl_contract_pub.klev_rec_type;

Line 2148: l_amt_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

2144: l_klev_rec klev_rec_type;
2145: l_cimv_rec cimv_rec_type;
2146:
2147: l_chr_id l_clev_rec.dnz_chr_id%type;
2148: l_amt_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
2149:
2150: l_api_name CONSTANT VARCHAR2(30) := 'create_contract_line_item';
2151: l_api_version CONSTANT NUMBER := 1.0;
2152: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2503: l_amt_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

2499: l_klev_rec klev_rec_type;
2500: l_cimv_rec cimv_rec_type;
2501:
2502: l_chr_id l_clev_rec.dnz_chr_id%type;
2503: l_amt_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
2504:
2505: l_api_name CONSTANT VARCHAR2(30) := 'update_contract_line_item';
2506: l_api_version CONSTANT NUMBER := 1.0;
2507: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;