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.

[Home] [Help]

APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on AK_ATTRIBUTES_VL

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

229:
230: CURSOR ak_prompt_csr(p_ak_region VARCHAR2, p_ak_attribute VARCHAR2) IS
231: --start modified abhsaxen for performance SQLID 20562645
232: select a.attribute_label_long
233: from ak_region_items ri, ak_regions r, ak_attributes_vl a
234: where ri.region_code = r.region_code
235: and ri.region_application_id = r.region_application_id
236: and ri.attribute_code = a.attribute_code
237: and ri.attribute_application_id = a.attribute_application_id

Line 244: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

240: --end modified abhsaxen for performance SQLID 20562645
241: ;
242:
243:
244: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
245:
246: BEGIN
247: OPEN ak_prompt_csr(p_ak_region, p_ak_attribute);
248: FETCH ak_prompt_csr INTO l_ak_prompt;

Line 476: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

472:
473: -- WHERE id = p_cpl_id;
474:
475:
476: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
477:
478:
479:
480: Begin

Line 949: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

945:
946:
947:
948:
949: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
950:
951:
952:
953:

Line 1924: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

1920: -- x_return_status := OKC_API.G_RET_STS_SUCCESS;
1921:
1922: ERR_MSG VARCHAR2(50) := 'DEFAULT';
1923:
1924: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1925:
1926: Begin
1927:
1928: -- call START_ACTIVITY to create savepoint, check compatibility

Line 3461: l_fee_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

3457: l_cle_id okl_k_lines.id%type;
3458: l_lty_code okc_line_styles_b.lty_code%type;
3459:
3460:
3461: l_fee_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
3462:
3463:
3464: l_api_name CONSTANT VARCHAR2(30) := 'validate_service';
3465: l_api_version CONSTANT NUMBER := 1.0;

Line 5019: l_service_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

5015: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
5016:
5017:
5018:
5019: l_service_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
5020:
5021:
5022: type item_curs_type is REF CURSOR;
5023: item_curs item_curs_type;

Line 6805: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

6801: ) AS
6802: l_api_name VARCHAR2(30) := 'validate_creditline';
6803: l_api_version CONSTANT NUMBER := 1.0;
6804:
6805: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
6806: l_chr_id okc_k_headers_b.id%type := null;
6807: l_mla_cl_id okc_k_headers_b.id%type := null;
6808: l_mla_id okc_k_headers_b.id%type := null;
6809: l_cl_k_no okc_k_headers_b.contract_number%type := null;

Line 7216: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

7212: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7213: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7214: l_object_code VARCHAR2(30) Default Null;
7215:
7216: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
7217: l_chr_id okl_k_headers_full_v.id%type;
7218: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;
7219: l_row_count number;
7220: l_currency_code fnd_currencies_vl.currency_code%type := null;

Line 8072: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

8068: l_object_code VARCHAR2(30) Default Null;
8069:
8070:
8071:
8072: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
8073:
8074: l_chr_id NUMBER;
8075:
8076:

Line 8246: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

8242: l_object_code VARCHAR2(30) Default Null;
8243:
8244:
8245:
8246: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
8247:
8248: l_chr_id NUMBER;
8249:
8250:

Line 8392: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

8388:
8389:
8390: l_object_code VARCHAR2(30) Default Null;
8391:
8392: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
8393:
8394: l_chr_id NUMBER;
8395:
8396:

Line 9588: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

9584: ) AS
9585: l_api_name VARCHAR2(30) := 'validate_crdtln_err';
9586: l_api_version CONSTANT NUMBER := 1.0;
9587:
9588: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
9589: l_chr_id okc_k_headers_b.id%type := null;
9590: l_k_cl_no okc_k_headers_b.contract_number%type := null;
9591: l_mla_no okc_k_headers_b.contract_number%type := null;
9592: l_deal_type okl_k_headers.deal_type%type := null;