APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_ROLE_RESPONSIBILITY

Line 1710: FROM HZ_ROLE_RESPONSIBILITY

1706: x_object_version_number OUT NOCOPY NUMBER
1707: ) IS
1708: CURSOR is_role_resp_id_exist(l_resp_id NUMBER) IS
1709: SELECT nvl(object_version_number,1), cust_account_role_id
1710: FROM HZ_ROLE_RESPONSIBILITY
1711: WHERE responsibility_id = l_resp_id
1712: AND rownum = 1;
1713:
1714: CURSOR is_role_resp_exist(l_cac_id NUMBER, l_resp_type VARCHAR2) IS

Line 1716: FROM HZ_ROLE_RESPONSIBILITY

1712: AND rownum = 1;
1713:
1714: CURSOR is_role_resp_exist(l_cac_id NUMBER, l_resp_type VARCHAR2) IS
1715: SELECT nvl(object_version_number,1), responsibility_id
1716: FROM HZ_ROLE_RESPONSIBILITY
1717: WHERE cust_account_role_id = l_cac_id
1718: AND responsibility_type = l_resp_type
1719: AND rownum = 1;
1720:

Line 3540: -- HZ_ROLE_RESPONSIBILITY

3536: END IF;
3537:
3538: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3539: -- get all entities of cust acct contact, for cust acct contact, the possible entites are
3540: -- HZ_ROLE_RESPONSIBILITY
3541: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
3542: p_bus_object.user_mandated_flag(i) = 'Y' AND
3543: p_bus_object.business_object_code(i) = 'CUST_ACCT_CONTACT' AND
3544: p_bus_object.child_bo_code(i) IS NULL) THEN

Line 3545: IF(p_bus_object.entity_name(i) = 'HZ_ROLE_RESPONSIBILITY') THEN

3541: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
3542: p_bus_object.user_mandated_flag(i) = 'Y' AND
3543: p_bus_object.business_object_code(i) = 'CUST_ACCT_CONTACT' AND
3544: p_bus_object.child_bo_code(i) IS NULL) THEN
3545: IF(p_bus_object.entity_name(i) = 'HZ_ROLE_RESPONSIBILITY') THEN
3546: l_rr := TRUE;
3547: END IF;
3548: END IF;
3549: END LOOP;