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 1440: l_lty_code okc_line_styles_b.lty_code%type;

1436:
1437: l_chr_id okl_k_headers.id%type;
1438: l_rle_code okc_k_party_roles_v.rle_code%type;
1439: l_cle_id okl_k_lines.id%type;
1440: l_lty_code okc_line_styles_b.lty_code%type;
1441:
1442:
1443:
1444: l_api_name CONSTANT VARCHAR2(30) := 'okl_la_jtot_extract';

Line 1899: l_lty_code okc_line_styles_b.lty_code%type;

1895:
1896: l_chr_id okl_k_headers.id%type;
1897: l_rle_code okc_k_party_roles_v.rle_code%type;
1898: l_cle_id okl_k_lines.id%type;
1899: l_lty_code okc_line_styles_b.lty_code%type;
1900:
1901: l_api_name CONSTANT VARCHAR2(30) := 'Get_Party_Jtot_data';
1902: l_api_version CONSTANT NUMBER := 1.0;
1903:

Line 2364: l_lty_code okc_line_styles_b.lty_code%type;

2360:
2361: l_chr_id okl_k_headers.id%type;
2362: l_parent_cle_id okl_k_lines.id%type;
2363: l_cle_id okl_k_lines.id%type;
2364: l_lty_code okc_line_styles_b.lty_code%type;
2365:
2366:
2367:
2368: l_api_name CONSTANT VARCHAR2(30) := 'okl_la_jtot_extract';

Line 2376: FROM okc_line_styles_b lse,

2372: -- Cursor to fetch the lty_code
2373: CURSOR get_lty_code_csr(p_chr_id NUMBER,
2374: p_cle_id NUMBER) IS
2375: SELECT lty_code
2376: FROM okc_line_styles_b lse,
2377: okc_k_lines_b cle
2378: WHERE lse.lse_parent_id = cle.lse_id
2379: AND cle.id = p_cle_id
2380: AND cle.chr_id = p_chr_id;

Line 3442: l_lty_code okc_line_styles_b.lty_code%type;

3438:
3439: l_chr_id okl_k_headers.id%type;
3440: l_cle_id okl_k_lines.id%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:

Line 3462: , okc_line_styles_b lse

3458:
3459: from okc_k_items cim
3460: , okc_k_lines_b cle
3461: , okc_line_style_sources lss
3462: , okc_line_styles_b lse
3463: where nvl(lss.start_date,sysdate) <= sysdate
3464: and nvl(lss.end_date,sysdate + 1) > sysdate
3465: and lse.id = lss.lse_id
3466: and cle.lse_id = lse.id

Line 3481: , okc_line_styles_b lse

3477: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
3478: from okc_k_items cim
3479: , okc_k_lines_b cle
3480: , okc_line_style_sources lss
3481: , okc_line_styles_b lse
3482: where nvl(lss.start_date,sysdate) <= sysdate
3483: and nvl(lss.end_date,sysdate + 1) > sysdate
3484: and lse.id = lss.lse_id
3485: and cle.lse_id = lse.id

Line 5017: l_lty_code okc_line_styles_b.lty_code%type;

5013:
5014: l_chr_id okl_k_headers.id%type;
5015: l_cle_id okl_k_lines.id%type;
5016: l_cle_id okl_k_lines.id%type;
5017: l_lty_code okc_line_styles_b.lty_code%type;
5018:
5019:
5020:
5021: l_api_name CONSTANT VARCHAR2(30) := 'validate_fee';

Line 5035: , okc_line_styles_b lse

5031:
5032: from okc_k_items cim
5033: , okc_k_lines_b cle
5034: , okc_line_style_sources lss
5035: , okc_line_styles_b lse
5036: where nvl(lss.start_date,sysdate) <= sysdate
5037: and nvl(lss.end_date,sysdate + 1) > sysdate
5038: and lse.id = lss.lse_id
5039: and cle.lse_id = lse.id

Line 5055: , okc_line_styles_b lse

5051: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
5052: from okc_k_items cim
5053: , okc_k_lines_b cle
5054: , okc_line_style_sources lss
5055: , okc_line_styles_b lse
5056: where nvl(lss.start_date,sysdate) <= sysdate
5057: and nvl(lss.end_date,sysdate + 1) > sysdate
5058: and lse.id = lss.lse_id
5059: and cle.lse_id = lse.id