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 294: FROM HZ_CONTACT_POINTS

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

Line 407: l_obj_type := 'HZ_CONTACT_POINTS';

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