APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CONTACT_POINTS

Line 359: FROM HZ_CONTACT_POINTS

355: x_msg_data OUT NOCOPY VARCHAR2
356: ) IS
357: CURSOR is_cp_valid(l_cp_id NUMBER, l_cp_type VARCHAR2) IS
358: SELECT 'X'
359: FROM HZ_CONTACT_POINTS
360: WHERE contact_point_id = l_cp_id
361: AND contact_point_type = l_cp_type;
362:
363: CURSOR is_oc_valid(l_oc_id NUMBER) IS

Line 480: l_obj_type := 'HZ_CONTACT_POINTS';

476:
477: -- if px_os/px_osr pass in, get owner_table_id and set l_ss_flag to 'Y'
478: IF(l_ss_flag = 'Y')THEN
479: IF(p_obj_type in ('PHONE','TLX','EMAIL','WEB','EFT','EDI','SMS')) THEN
480: l_obj_type := 'HZ_CONTACT_POINTS';
481: ELSIF(p_obj_type in ('PERSON','ORGANIZATION','PARTY_RELATIONSHIP')) THEN
482: l_obj_type := 'HZ_PARTIES';
483: ELSE
484: l_obj_type := p_obj_type;

Line 1959: FROM HZ_CONTACT_POINTS

1955: p_parent_obj_type IN VARCHAR2
1956: ) RETURN VARCHAR2 IS
1957: CURSOR is_contact_point_exist(l_contact_point_id NUMBER, l_contact_point_type VARCHAR2) IS
1958: SELECT owner_table_id, owner_table_name
1959: FROM HZ_CONTACT_POINTS
1960: WHERE contact_point_id = l_contact_point_id
1961: AND contact_point_type = l_contact_point_type;
1962:
1963: CURSOR is_party_site_exist(l_ps_id NUMBER) IS

Line 2034: IF(p_entity_type = 'HZ_CONTACT_POINTS') THEN

2030: -- if TCA id pass in, check if it is valid or not
2031: IF(p_entity_id IS NOT NULL) THEN
2032: l_input_parent_table := get_owner_table_name(p_parent_obj_type);
2033:
2034: IF(p_entity_type = 'HZ_CONTACT_POINTS') THEN
2035: OPEN is_contact_point_exist(p_entity_id, p_cp_type);
2036: FETCH is_contact_point_exist INTO l_parent_id, l_parent_table;
2037: CLOSE is_contact_point_exist;
2038: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id OR l_parent_table <> l_input_parent_table) THEN

Line 2139: IF(p_entity_type = 'HZ_CONTACT_POINTS') THEN

2135: x_owner_table_id => l_owner_table_id,
2136: x_return_status => l_return_status);
2137:
2138: -- For contact point, check if the id and type is the same
2139: IF(p_entity_type = 'HZ_CONTACT_POINTS') THEN
2140: OPEN is_contact_point_exist(l_owner_table_id, p_cp_type);
2141: FETCH is_contact_point_exist INTO l_parent_id, l_parent_table;
2142: CLOSE is_contact_point_exist;
2143: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id OR l_parent_table <> l_input_parent_table) THEN

Line 2297: RETURN 'HZ_CONTACT_POINTS';

2293: RETURN 'HZ_CUST_ACCOUNT_ROLES';
2294: ELSIF(p_obj_type = 'CUST_ACCT_SITE') THEN
2295: RETURN 'HZ_CUST_ACCT_SITES_ALL';
2296: ELSIF(p_obj_type in ('PHONE', 'EMAIL', 'TLX', 'WEB', 'EDI', 'EFT', 'SMS')) THEN
2297: RETURN 'HZ_CONTACT_POINTS';
2298: ELSIF(p_obj_type = 'LOCATION') THEN
2299: RETURN 'HZ_LOCATIONS';
2300: ELSIF(p_obj_type = 'CUST_ACCT_SITE_USE') THEN
2301: RETURN 'HZ_CUST_SITE_USES_ALL';