APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_ROLE_RESPONSIBILITY

Line 1707: FROM HZ_ROLE_RESPONSIBILITY

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

Line 1713: FROM HZ_ROLE_RESPONSIBILITY

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

Line 3535: -- HZ_ROLE_RESPONSIBILITY

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

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

3536: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
3537: p_bus_object.user_mandated_flag(i) = 'Y' AND
3538: p_bus_object.business_object_code(i) = 'CUST_ACCT_CONTACT' AND
3539: p_bus_object.child_bo_code(i) IS NULL) THEN
3540: IF(p_bus_object.entity_name(i) = 'HZ_ROLE_RESPONSIBILITY') THEN
3541: l_rr := TRUE;
3542: END IF;
3543: END IF;
3544: END LOOP;