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_RULES_V

Line 401: l_id1 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;

397: l_query_string varchar2(2000) default null;
398:
399:
400:
401: l_id1 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
402: l_id2 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
403: l_name VARCHAR2(250) Default Null;
404: l_description VARCHAR2(250) Default Null;
405:

Line 402: l_id2 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;

398:
399:
400:
401: l_id1 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
402: l_id2 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
403: l_name VARCHAR2(250) Default Null;
404: l_description VARCHAR2(250) Default Null;
405:
406: l_object_code VARCHAR2(30) Default Null;

Line 410: l_id11 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;

406: l_object_code VARCHAR2(30) Default Null;
407:
408:
409:
410: l_id11 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
411: l_id22 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
412:
413:
414:

Line 411: l_id22 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;

407:
408:
409:
410: l_id11 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
411: l_id22 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
412:
413:
414:
415: type rule_curs_type is REF CURSOR;

Line 420: l_rdf_code okc_rules_v.rule_information_category%type;

416: rule_curs rule_curs_type;
417:
418: row_count Number default 0;
419: l_chr_id okl_k_headers.id%type;
420: l_rdf_code okc_rules_v.rule_information_category%type;
421: l_rgd_code okc_rule_groups_v.rgd_code%type;
422:
423:
424: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Rule';

Line 439: from okc_rule_groups_v rgp, okc_rules_v rul

435:
436:
437: CURSOR check_rule_csr(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rdf_code VARCHAR2, p_id1 VARCHAR2, p_id2 VARCHAR2) IS
438: select count(1)
439: from okc_rule_groups_v rgp, okc_rules_v rul
440: where rgp.id = rul.rgp_id
441: and rgp.rgd_code = p_rgd_code
442: and rul.rule_information_category = p_rdf_code
443: and rgp.dnz_chr_id = p_chr_id

Line 863: l_id1 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;

859: l_query_string varchar2(2000) default null;
860:
861:
862:
863: l_id1 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
864: l_id2 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
865: l_name VARCHAR2(250) Default Null;
866: l_description VARCHAR2(250) Default Null;
867: l_object_code VARCHAR2(30) Default Null;

Line 864: l_id2 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;

860:
861:
862:
863: l_id1 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
864: l_id2 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
865: l_name VARCHAR2(250) Default Null;
866: l_description VARCHAR2(250) Default Null;
867: l_object_code VARCHAR2(30) Default Null;
868:

Line 871: l_id11 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;

867: l_object_code VARCHAR2(30) Default Null;
868:
869:
870:
871: l_id11 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
872: l_id22 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
873:
874:
875:

Line 872: l_id22 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;

868:
869:
870:
871: l_id11 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
872: l_id22 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
873:
874:
875:
876: type contact_curs_type is REF CURSOR;

Line 886: l_rdf_code okc_rules_v.rule_information_category%type;

882:
883:
884:
885: l_chr_id okl_k_headers.id%type;
886: l_rdf_code okc_rules_v.rule_information_category%type;
887: l_rgd_code okc_rule_groups_v.rgd_code%type;
888:
889:
890:

Line 907: from okc_rule_groups_v rgp, okc_rules_v rul

903:
904: CURSOR check_rule_csr(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rdf_code VARCHAR2, p_id1 VARCHAR2, p_id2 VARCHAR2) IS
905:
906: select count(1)
907: from okc_rule_groups_v rgp, okc_rules_v rul
908: where rgp.id = rul.rgp_id
909: and rgp.rgd_code = p_rgd_code
910: and rul.rule_information_category = p_rdf_code
911: and rgp.dnz_chr_id = p_chr_id