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 455: -- FROM okc_k_party_roles_v

451: -- CURSOR get_rule_csr(p_cpl_id NUMBER) IS
452:
453: -- SELECT rul.object1_id1, object1_id2
454:
455: -- FROM okc_k_party_roles_v
456:
457: -- WHERE id = p_cpl_id;
458:
459:

Line 922: -- FROM okc_k_party_roles_v

918: -- CURSOR get_rule_csr(p_cpl_id NUMBER) IS
919:
920: -- SELECT rul.object1_id1, object1_id2
921:
922: -- FROM okc_k_party_roles_v
923:
924: -- WHERE id = p_cpl_id;
925:
926:

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

1414: l_order_by_clause varchar2(2000) default null;
1415: l_query_string varchar2(2000) default null;
1416:
1417:
1418: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1419: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1420: l_name VARCHAR2(250) Default Null;
1421: l_description VARCHAR2(250) Default Null;
1422: l_object_code VARCHAR2(30) Default Null;

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

1415: l_query_string varchar2(2000) default null;
1416:
1417:
1418: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1419: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1420: l_name VARCHAR2(250) Default Null;
1421: l_description VARCHAR2(250) Default Null;
1422: l_object_code VARCHAR2(30) Default Null;
1423:

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

1421: l_description VARCHAR2(250) Default Null;
1422: l_object_code VARCHAR2(30) Default Null;
1423:
1424:
1425: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1426: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1427:
1428:
1429: type party_curs_type is REF CURSOR;

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

1422: l_object_code VARCHAR2(30) Default Null;
1423:
1424:
1425: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1426: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1427:
1428:
1429: type party_curs_type is REF CURSOR;
1430: party_curs party_curs_type;

Line 1438: l_rle_code okc_k_party_roles_v.rle_code%type;

1434:
1435:
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:

Line 1472: FROM okc_k_party_roles_v

1468:
1469:
1470: CURSOR get_party_csr(p_cpl_id NUMBER) IS
1471: SELECT rle_code, object1_id1, object1_id2
1472: FROM okc_k_party_roles_v
1473: WHERE id = p_cpl_id;
1474:
1475:
1476:

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

1878: l_where_clause varchar2(2000) default null;
1879: l_order_by_clause varchar2(2000) default null;
1880: l_query_string varchar2(2000) default null;
1881:
1882: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1883: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1884: l_name VARCHAR2(250) Default Null;
1885: l_description VARCHAR2(250) Default Null;
1886: l_object_code VARCHAR2(30) Default Null;

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

1879: l_order_by_clause varchar2(2000) default null;
1880: l_query_string varchar2(2000) default null;
1881:
1882: l_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1883: l_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1884: l_name VARCHAR2(250) Default Null;
1885: l_description VARCHAR2(250) Default Null;
1886: l_object_code VARCHAR2(30) Default Null;
1887:

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

1884: l_name VARCHAR2(250) Default Null;
1885: l_description VARCHAR2(250) Default Null;
1886: l_object_code VARCHAR2(30) Default Null;
1887:
1888: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1889: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1890:
1891: type party_curs_type is REF CURSOR;
1892: party_curs party_curs_type;

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

1885: l_description VARCHAR2(250) Default Null;
1886: l_object_code VARCHAR2(30) Default Null;
1887:
1888: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
1889: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
1890:
1891: type party_curs_type is REF CURSOR;
1892: party_curs party_curs_type;
1893:

Line 1897: l_rle_code okc_k_party_roles_v.rle_code%type;

1893:
1894: row_count Number default 0;
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';

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

2344: l_description VARCHAR2(250) Default Null;
2345: l_object_code VARCHAR2(30) Default Null;
2346:
2347:
2348: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
2349: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
2350:
2351:
2352:

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

2345: l_object_code VARCHAR2(30) Default Null;
2346:
2347:
2348: l_id11 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
2349: l_id22 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
2350:
2351:
2352:
2353: type item_curs_type is REF CURSOR;

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

3418: l_item_id22 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
3419:
3420:
3421:
3422: l_party_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
3423: l_party_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
3424: l_party_name VARCHAR2(250) Default Null;
3425: l_party_object_code VARCHAR2(30) Default Null;
3426:

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

3419:
3420:
3421:
3422: l_party_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE default Null;
3423: l_party_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE default Null;
3424: l_party_name VARCHAR2(250) Default Null;
3425: l_party_object_code VARCHAR2(30) Default Null;
3426:
3427: