APPS.HZ_EXTRACT_BO_UTIL_PVT dependencies on HZ_CONTACT_POINTS

Line 77: from HZ_CONTACT_POINTS

73: and ca.cust_account_id = p_parent_id;
74:
75: cursor c_cp is
76: select contact_point_type
77: from HZ_CONTACT_POINTS
78: where contact_point_id = p_parent_id;
79:
80: BEGIN
81: if p_parent_table_name = 'HZ_PARTIES'

Line 86: elsif p_parent_table_name = 'HZ_CONTACT_POINTS'

82: then
83: open c1;
84: fetch c1 into l_party_type;
85: close c1;
86: elsif p_parent_table_name = 'HZ_CONTACT_POINTS'
87: then
88: open c_cp;
89: fetch c_cp into l_party_type;
90: close c_cp;

Line 109: ELSIF(p_parent_table_name = 'HZ_CONTACT_POINTS') THEN

105: RETURN 'PERSON';
106: ELSIF(l_party_type = 'PARTY_RELATIONSHIP') THEN
107: RETURN 'ORG_CONTACT';
108: END IF;
109: ELSIF(p_parent_table_name = 'HZ_CONTACT_POINTS') THEN
110: RETURN l_party_type;
111: ELSIF(p_parent_table_name = 'HZ_CUST_ACCOUNTS') THEN
112: IF(l_party_type = 'ORGANIZATION') THEN
113: RETURN 'ORG_CUST';

Line 290: FROM HZ_CONTACT_POINTS

286: x_msg_data OUT NOCOPY VARCHAR2
287: ) IS
288: CURSOR is_cp_valid(l_cp_id NUMBER, l_cp_type VARCHAR2) IS
289: SELECT 'X'
290: FROM HZ_CONTACT_POINTS
291: WHERE contact_point_id = l_cp_id
292: AND contact_point_type = l_cp_type;
293:
294: CURSOR is_oc_valid(l_oc_id NUMBER) IS

Line 403: l_obj_type := 'HZ_CONTACT_POINTS';

399:
400: -- if px_os/px_osr pass in, get owner_table_id and set l_ss_flag to 'Y'
401: IF(l_ss_flag = 'Y')THEN
402: IF(p_obj_type in ('PHONE','TLX','EMAIL','WEB','EFT','EDI','SMS')) THEN
403: l_obj_type := 'HZ_CONTACT_POINTS';
404: ELSIF(p_obj_type in ('PERSON','ORGANIZATION','PARTY_RELATIONSHIP')) THEN
405: l_obj_type := 'HZ_PARTIES';
406: ELSE
407: l_obj_type := p_obj_type;