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

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

213:
214: CURSOR ak_prompt_csr(p_ak_region VARCHAR2, p_ak_attribute VARCHAR2) IS
215: --start modified abhsaxen for performance SQLID 20562645
216: select a.attribute_label_long
217: from ak_region_items ri, ak_regions r, ak_attributes_vl a
218: where ri.region_code = r.region_code
219: and ri.region_application_id = r.region_application_id
220: and ri.attribute_code = a.attribute_code
221: and ri.attribute_application_id = a.attribute_application_id

Line 228: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

224: --end modified abhsaxen for performance SQLID 20562645
225: ;
226:
227:
228: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
229:
230: BEGIN
231: OPEN ak_prompt_csr(p_ak_region, p_ak_attribute);
232: FETCH ak_prompt_csr INTO l_ak_prompt;

Line 460: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

456:
457: -- WHERE id = p_cpl_id;
458:
459:
460: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
461:
462:
463:
464: Begin

Line 933: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

929:
930:
931:
932:
933: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
934:
935:
936:
937:

Line 1908: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

1904: -- x_return_status := OKC_API.G_RET_STS_SUCCESS;
1905:
1906: ERR_MSG VARCHAR2(50) := 'DEFAULT';
1907:
1908: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1909:
1910: Begin
1911:
1912: -- call START_ACTIVITY to create savepoint, check compatibility

Line 3445: l_fee_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

3441: l_cle_id okl_k_lines.id%type;
3442: l_lty_code okc_line_styles_b.lty_code%type;
3443:
3444:
3445: l_fee_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
3446:
3447:
3448: l_api_name CONSTANT VARCHAR2(30) := 'validate_service';
3449: l_api_version CONSTANT NUMBER := 1.0;

Line 5003: l_service_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

4999: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
5000:
5001:
5002:
5003: l_service_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
5004:
5005:
5006: type item_curs_type is REF CURSOR;
5007: item_curs item_curs_type;

Line 6789: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

6785: ) AS
6786: l_api_name VARCHAR2(30) := 'validate_creditline';
6787: l_api_version CONSTANT NUMBER := 1.0;
6788:
6789: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
6790: l_chr_id okc_k_headers_b.id%type := null;
6791: l_mla_cl_id okc_k_headers_b.id%type := null;
6792: l_mla_id okc_k_headers_b.id%type := null;
6793: l_cl_k_no okc_k_headers_b.contract_number%type := null;

Line 7200: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

7196: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7198: l_object_code VARCHAR2(30) Default Null;
7199:
7200: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
7201: l_chr_id okl_k_headers_full_v.id%type;
7202: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;
7203: l_row_count number;
7204: l_currency_code fnd_currencies_vl.currency_code%type := null;

Line 8010: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

8006: l_object_code VARCHAR2(30) Default Null;
8007:
8008:
8009:
8010: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
8011:
8012: l_chr_id NUMBER;
8013:
8014:

Line 8184: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

8180: l_object_code VARCHAR2(30) Default Null;
8181:
8182:
8183:
8184: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
8185:
8186: l_chr_id NUMBER;
8187:
8188:

Line 8330: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

8326:
8327:
8328: l_object_code VARCHAR2(30) Default Null;
8329:
8330: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
8331:
8332: l_chr_id NUMBER;
8333:
8334:

Line 9526: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

9522: ) AS
9523: l_api_name VARCHAR2(30) := 'validate_crdtln_err';
9524: l_api_version CONSTANT NUMBER := 1.0;
9525:
9526: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
9527: l_chr_id okc_k_headers_b.id%type := null;
9528: l_k_cl_no okc_k_headers_b.contract_number%type := null;
9529: l_mla_no okc_k_headers_b.contract_number%type := null;
9530: l_deal_type okl_k_headers.deal_type%type := null;