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_K_PARTY_ROLES_V

Line 471: -- FROM okc_k_party_roles_v

467: -- CURSOR get_rule_csr(p_cpl_id NUMBER) IS
468:
469: -- SELECT rul.object1_id1, object1_id2
470:
471: -- FROM okc_k_party_roles_v
472:
473: -- WHERE id = p_cpl_id;
474:
475:

Line 938: -- FROM okc_k_party_roles_v

934: -- CURSOR get_rule_csr(p_cpl_id NUMBER) IS
935:
936: -- SELECT rul.object1_id1, object1_id2
937:
938: -- FROM okc_k_party_roles_v
939:
940: -- WHERE id = p_cpl_id;
941:
942:

Line 1434: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

1430: l_order_by_clause varchar2(2000) default null;
1431: l_query_string varchar2(2000) default null;
1432:
1433:
1434: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1435: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1436: l_name VARCHAR2(250) Default Null;
1437: l_description VARCHAR2(250) Default Null;
1438: l_object_code VARCHAR2(30) Default Null;

Line 1435: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;

1431: l_query_string varchar2(2000) default null;
1432:
1433:
1434: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1435: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1436: l_name VARCHAR2(250) Default Null;
1437: l_description VARCHAR2(250) Default Null;
1438: l_object_code VARCHAR2(30) Default Null;
1439:

Line 1441: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

1437: l_description VARCHAR2(250) Default Null;
1438: l_object_code VARCHAR2(30) Default Null;
1439:
1440:
1441: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1442: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1443:
1444:
1445: type party_curs_type is REF CURSOR;

Line 1442: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;

1438: l_object_code VARCHAR2(30) Default Null;
1439:
1440:
1441: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1442: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1443:
1444:
1445: type party_curs_type is REF CURSOR;
1446: party_curs party_curs_type;

Line 1454: l_rle_code okc_k_party_roles_v.rle_code%type;

1450:
1451:
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:

Line 1488: FROM okc_k_party_roles_v

1484:
1485:
1486: CURSOR get_party_csr(p_cpl_id NUMBER) IS
1487: SELECT rle_code, object1_id1, object1_id2
1488: FROM okc_k_party_roles_v
1489: WHERE id = p_cpl_id;
1490:
1491:
1492:

Line 1898: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

1894: l_where_clause varchar2(2000) default null;
1895: l_order_by_clause varchar2(2000) default null;
1896: l_query_string varchar2(2000) default null;
1897:
1898: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1899: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1900: l_name VARCHAR2(250) Default Null;
1901: l_description VARCHAR2(250) Default Null;
1902: l_object_code VARCHAR2(30) Default Null;

Line 1899: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;

1895: l_order_by_clause varchar2(2000) default null;
1896: l_query_string varchar2(2000) default null;
1897:
1898: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1899: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1900: l_name VARCHAR2(250) Default Null;
1901: l_description VARCHAR2(250) Default Null;
1902: l_object_code VARCHAR2(30) Default Null;
1903:

Line 1904: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

1900: l_name VARCHAR2(250) Default Null;
1901: l_description VARCHAR2(250) Default Null;
1902: l_object_code VARCHAR2(30) Default Null;
1903:
1904: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1905: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1906:
1907: type party_curs_type is REF CURSOR;
1908: party_curs party_curs_type;

Line 1905: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;

1901: l_description VARCHAR2(250) Default Null;
1902: l_object_code VARCHAR2(30) Default Null;
1903:
1904: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1905: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1906:
1907: type party_curs_type is REF CURSOR;
1908: party_curs party_curs_type;
1909:

Line 1913: l_rle_code okc_k_party_roles_v.rle_code%type;

1909:
1910: row_count Number default 0;
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';

Line 2364: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

2360: l_description VARCHAR2(250) Default Null;
2361: l_object_code VARCHAR2(30) Default Null;
2362:
2363:
2364: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
2365: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
2366:
2367:
2368:

Line 2365: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;

2361: l_object_code VARCHAR2(30) Default Null;
2362:
2363:
2364: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
2365: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
2366:
2367:
2368:
2369: type item_curs_type is REF CURSOR;

Line 3438: l_party_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;

3434: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
3435:
3436:
3437:
3438: l_party_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
3439: l_party_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
3440: l_party_name VARCHAR2(250) Default Null;
3441: l_party_object_code VARCHAR2(30) Default Null;
3442:

Line 3439: l_party_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;

3435:
3436:
3437:
3438: l_party_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
3439: l_party_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
3440: l_party_name VARCHAR2(250) Default Null;
3441: l_party_object_code VARCHAR2(30) Default Null;
3442:
3443: