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

1960: p_parent_obj_type IN VARCHAR2
1961: ) RETURN VARCHAR2 IS
1962: CURSOR is_contact_point_exist(l_contact_point_id NUMBER, l_contact_point_type VARCHAR2) IS
1963: SELECT owner_table_id, owner_table_name
1964: FROM HZ_CONTACT_POINTS
1965: WHERE contact_point_id = l_contact_point_id
1966: AND contact_point_type = l_contact_point_type;
1967:
1968: CURSOR is_party_site_exist(l_ps_id NUMBER) IS

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

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

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

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

Line 2302: RETURN 'HZ_CONTACT_POINTS';

2298: RETURN 'HZ_CUST_ACCOUNT_ROLES';
2299: ELSIF(p_obj_type = 'CUST_ACCT_SITE') THEN
2300: RETURN 'HZ_CUST_ACCT_SITES_ALL';
2301: ELSIF(p_obj_type in ('PHONE', 'EMAIL', 'TLX', 'WEB', 'EDI', 'EFT', 'SMS')) THEN
2302: RETURN 'HZ_CONTACT_POINTS';
2303: ELSIF(p_obj_type = 'LOCATION') THEN
2304: RETURN 'HZ_LOCATIONS';
2305: ELSIF(p_obj_type = 'CUST_ACCT_SITE_USE') THEN
2306: RETURN 'HZ_CUST_SITE_USES_ALL';