APPS.OKC_QUERY dependencies on OKC_UTIL

Line 120: l_name := OKC_UTIL.get_name_from_jtfv(l_object_code, l_object1_id1, l_object1_id2);

116: If (l_found = TRUE) Then
117: If (l_object1_id1 is not null) Then
118: /* Short term solution - should be done at the Header level */
119: -- OKC_CONTEXT.SET_OKC_ORG_CONTEXT(p_chr_id => p_contract_id);
120: l_name := OKC_UTIL.get_name_from_jtfv(l_object_code, l_object1_id1, l_object1_id2);
121: End If;
122: End If;
123: return l_name;
124:

Line 500: l_party_name := OKC_UTIL.GET_NAME_FROM_JTFV(p_object_code => r_pty_csr.jtot_object1_code

496: FOR r_pty_csr IN pty_csr LOOP
497:
498: IF p_party_name <> OKC_API.G_MISS_CHAR THEN
499:
500: l_party_name := OKC_UTIL.GET_NAME_FROM_JTFV(p_object_code => r_pty_csr.jtot_object1_code
501: ,p_id1 => r_pty_csr.object1_id1
502: ,p_id2 => r_pty_csr.object1_id2 );
503:
504: IF l_party_name = p_party_name THEN -- role and party exist in contract

Line 950: -- OKC_UTIL

946: p_object_code in varchar2,
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

Line 986: -- OKC_UTIL

982: p_object_code in varchar2,
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

Line 1038: -- OKC_UTIL

1034: p_object_id1 in varchar2,
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: