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 OKC_LINE_STYLES_B

Line 1456: l_lty_code okc_line_styles_b.lty_code%type;

1452:
1453: l_chr_id okl_k_headers.id%type;
1454: l_rle_code okc_k_party_roles_v.rle_code%type;
1455: l_cle_id okl_k_lines.id%type;
1456: l_lty_code okc_line_styles_b.lty_code%type;
1457:
1458:
1459:
1460: l_api_name CONSTANT VARCHAR2(30) := 'okl_la_jtot_extract';

Line 1915: l_lty_code okc_line_styles_b.lty_code%type;

1911:
1912: l_chr_id okl_k_headers.id%type;
1913: l_rle_code okc_k_party_roles_v.rle_code%type;
1914: l_cle_id okl_k_lines.id%type;
1915: l_lty_code okc_line_styles_b.lty_code%type;
1916:
1917: l_api_name CONSTANT VARCHAR2(30) := 'Get_Party_Jtot_data';
1918: l_api_version CONSTANT NUMBER := 1.0;
1919:

Line 2380: l_lty_code okc_line_styles_b.lty_code%type;

2376:
2377: l_chr_id okl_k_headers.id%type;
2378: l_parent_cle_id okl_k_lines.id%type;
2379: l_cle_id okl_k_lines.id%type;
2380: l_lty_code okc_line_styles_b.lty_code%type;
2381:
2382:
2383:
2384: l_api_name CONSTANT VARCHAR2(30) := 'okl_la_jtot_extract';

Line 2392: FROM okc_line_styles_b lse,

2388: -- Cursor to fetch the lty_code
2389: CURSOR get_lty_code_csr(p_chr_id NUMBER,
2390: p_cle_id NUMBER) IS
2391: SELECT lty_code
2392: FROM okc_line_styles_b lse,
2393: okc_k_lines_b cle
2394: WHERE lse.lse_parent_id = cle.lse_id
2395: AND cle.id = p_cle_id
2396: AND cle.chr_id = p_chr_id;

Line 3458: l_lty_code okc_line_styles_b.lty_code%type;

3454:
3455: l_chr_id okl_k_headers.id%type;
3456: l_cle_id okl_k_lines.id%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:

Line 3478: , okc_line_styles_b lse

3474:
3475: from okc_k_items cim
3476: , okc_k_lines_b cle
3477: , okc_line_style_sources lss
3478: , okc_line_styles_b lse
3479: where nvl(lss.start_date,sysdate) <= sysdate
3480: and nvl(lss.end_date,sysdate + 1) > sysdate
3481: and lse.id = lss.lse_id
3482: and cle.lse_id = lse.id

Line 3497: , okc_line_styles_b lse

3493: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
3494: from okc_k_items cim
3495: , okc_k_lines_b cle
3496: , okc_line_style_sources lss
3497: , okc_line_styles_b lse
3498: where nvl(lss.start_date,sysdate) <= sysdate
3499: and nvl(lss.end_date,sysdate + 1) > sysdate
3500: and lse.id = lss.lse_id
3501: and cle.lse_id = lse.id

Line 5033: l_lty_code okc_line_styles_b.lty_code%type;

5029:
5030: l_chr_id okl_k_headers.id%type;
5031: l_cle_id okl_k_lines.id%type;
5032: l_cle_id okl_k_lines.id%type;
5033: l_lty_code okc_line_styles_b.lty_code%type;
5034:
5035:
5036:
5037: l_api_name CONSTANT VARCHAR2(30) := 'validate_fee';

Line 5051: , okc_line_styles_b lse

5047:
5048: from okc_k_items cim
5049: , okc_k_lines_b cle
5050: , okc_line_style_sources lss
5051: , okc_line_styles_b lse
5052: where nvl(lss.start_date,sysdate) <= sysdate
5053: and nvl(lss.end_date,sysdate + 1) > sysdate
5054: and lse.id = lss.lse_id
5055: and cle.lse_id = lse.id

Line 5071: , okc_line_styles_b lse

5067: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
5068: from okc_k_items cim
5069: , okc_k_lines_b cle
5070: , okc_line_style_sources lss
5071: , okc_line_styles_b lse
5072: where nvl(lss.start_date,sysdate) <= sysdate
5073: and nvl(lss.end_date,sysdate + 1) > sysdate
5074: and lse.id = lss.lse_id
5075: and cle.lse_id = lse.id