APPS.OKC_QUERY dependencies on OKC_RULE_PUB

Line 745: -- function get_contact (moved here from OKC_RULE_PUB)

741:
742: END GetClassFunctionName;
743:
744: --
745: -- function get_contact (moved here from OKC_RULE_PUB)
746: --
747: -- returns HZ_PARTIES related contacts points
748: -- otherwise (or if not found) returns contact description
749: -- through jtf_objects_vl

Line 812: return OKC_RULE_PUB.get_object_dsc(p_object_code, p_object_id1, p_object_id2);

808:
809:
810:
811:
812: return OKC_RULE_PUB.get_object_dsc(p_object_code, p_object_id1, p_object_id2);
813: end if;
814:
815: open l_primary_contact_fax_csr(p_object_id1);
816: fetch l_primary_contact_fax_csr into L_FAX_COUNTRY_CODE,L_FAX_AREA_CODE,L_FAX_NUMBER,L_FAX_EXTENSION;

Line 951: -- OKC_RULE_PUB

947: p_object_id1 in varchar2,
948: p_object_id2 in varchar2
949: ) return varchar2 is
950: -- OKC_UTIL
951: -- OKC_RULE_PUB
952: L_RETVAL varchar2(2000);
953: l_not_found BOOLEAN := TRUE;
954: cursor c(pid number) is
955: select EMAIL_ADDRESS

Line 987: -- OKC_RULE_PUB

983: p_object_id1 in varchar2,
984: p_object_id2 in varchar2
985: ) return varchar2 is
986: -- OKC_UTIL
987: -- OKC_RULE_PUB
988: L_RETVAL varchar2(2000);
989: l_not_found BOOLEAN := TRUE;
990: cursor c1(pid number) is
991: select decode(PNT.PHONE_COUNTRY_CODE,NULL,NULL,'+'||PNT.PHONE_COUNTRY_CODE||' ')

Line 1039: -- OKC_RULE_PUB

1035: p_object_id2 in varchar2,
1036: p_info_type in varchar2 -- 'EMAIL', 'PHONE', 'FAX'
1037: ) return varchar2 is
1038: -- OKC_UTIL
1039: -- OKC_RULE_PUB
1040: L_RETVAL varchar2(2000);
1041: begin
1042:
1043: IF p_info_type = 'EMAIL' THEN