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 417: l_id1 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;

413: l_query_string varchar2(2000) default null;
414:
415:
416:
417: l_id1 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
418: l_id2 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
419: l_name VARCHAR2(250) Default Null;
420: l_description VARCHAR2(250) Default Null;
421:

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

414:
415:
416:
417: l_id1 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
418: l_id2 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
419: l_name VARCHAR2(250) Default Null;
420: l_description VARCHAR2(250) Default Null;
421:
422: l_object_code VARCHAR2(30) Default Null;

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

422: l_object_code VARCHAR2(30) Default Null;
423:
424:
425:
426: l_id11 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
427: l_id22 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
428:
429:
430:

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

423:
424:
425:
426: l_id11 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
427: l_id22 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
428:
429:
430:
431: type rule_curs_type is REF CURSOR;

Line 436: l_rdf_code okc_rules_v.rule_information_category%type;

432: rule_curs rule_curs_type;
433:
434: row_count Number default 0;
435: l_chr_id okl_k_headers.id%type;
436: l_rdf_code okc_rules_v.rule_information_category%type;
437: l_rgd_code okc_rule_groups_v.rgd_code%type;
438:
439:
440: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Rule';

Line 455: from okc_rule_groups_v rgp, okc_rules_v rul

451:
452:
453: CURSOR check_rule_csr(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rdf_code VARCHAR2, p_id1 VARCHAR2, p_id2 VARCHAR2) IS
454: select count(1)
455: from okc_rule_groups_v rgp, okc_rules_v rul
456: where rgp.id = rul.rgp_id
457: and rgp.rgd_code = p_rgd_code
458: and rul.rule_information_category = p_rdf_code
459: and rgp.dnz_chr_id = p_chr_id

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

875: l_query_string varchar2(2000) default null;
876:
877:
878:
879: l_id1 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
880: l_id2 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
881: l_name VARCHAR2(250) Default Null;
882: l_description VARCHAR2(250) Default Null;
883: l_object_code VARCHAR2(30) Default Null;

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

876:
877:
878:
879: l_id1 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
880: l_id2 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
881: l_name VARCHAR2(250) Default Null;
882: l_description VARCHAR2(250) Default Null;
883: l_object_code VARCHAR2(30) Default Null;
884:

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

883: l_object_code VARCHAR2(30) Default Null;
884:
885:
886:
887: l_id11 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
888: l_id22 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
889:
890:
891:

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

884:
885:
886:
887: l_id11 OKC_RULES_V.OBJECT1_ID1%TYPE default Null;
888: l_id22 OKC_RULES_V.OBJECT1_ID2%TYPE default Null;
889:
890:
891:
892: type contact_curs_type is REF CURSOR;

Line 902: l_rdf_code okc_rules_v.rule_information_category%type;

898:
899:
900:
901: l_chr_id okl_k_headers.id%type;
902: l_rdf_code okc_rules_v.rule_information_category%type;
903: l_rgd_code okc_rule_groups_v.rgd_code%type;
904:
905:
906:

Line 923: from okc_rule_groups_v rgp, okc_rules_v rul

919:
920: CURSOR check_rule_csr(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rdf_code VARCHAR2, p_id1 VARCHAR2, p_id2 VARCHAR2) IS
921:
922: select count(1)
923: from okc_rule_groups_v rgp, okc_rules_v rul
924: where rgp.id = rul.rgp_id
925: and rgp.rgd_code = p_rgd_code
926: and rul.rule_information_category = p_rdf_code
927: and rgp.dnz_chr_id = p_chr_id