APPS.HZ_DSS_GROUPS_PUB dependencies on HZ_RELATIONSHIP_TYPES

Line 1619: l_rel_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;

1615: )
1616: IS
1617: row_id varchar2(64);
1618: l_dup_count NUMBER := 0;
1619: l_rel_type HZ_RELATIONSHIP_TYPES.RELATIONSHIP_TYPE%TYPE;
1620:
1621: BEGIN
1622:
1623: -- standard start of API savepoint

Line 1662: IF HZ_DSS_VALIDATE_PKG.exist_in_hz_relationship_types (p_dss_secured_rel_type.relationship_type_id) = 'N'

1658: RAISE FND_API.G_EXC_ERROR;
1659: END IF;
1660:
1661: -- PASSED IN RELATIONSHIP_TYPE_ID SHOULD BE VALID
1662: IF HZ_DSS_VALIDATE_PKG.exist_in_hz_relationship_types (p_dss_secured_rel_type.relationship_type_id) = 'N'
1663: THEN
1664: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_REL_TYPE_ID_INVALID');
1665: FND_MSG_PUB.ADD;
1666: RAISE FND_API.G_EXC_ERROR;

Line 1686: and owner_table_name = 'HZ_RELATIONSHIP_TYPES'

1682:
1683: select count(*) into l_dup_count
1684: from HZ_DSS_CRITERIA
1685: where dss_group_code = p_dss_secured_rel_type.dss_group_code
1686: and owner_table_name = 'HZ_RELATIONSHIP_TYPES'
1687: and owner_table_id1 = TO_CHAR(p_dss_secured_rel_type.relationship_type_id);
1688:
1689: if l_dup_count >= 1 then
1690: --get the rel type

Line 1692: from HZ_RELATIONSHIP_TYPES

1688:
1689: if l_dup_count >= 1 then
1690: --get the rel type
1691: select relationship_type into l_rel_type
1692: from HZ_RELATIONSHIP_TYPES
1693: where relationship_type_id = p_dss_secured_rel_type.relationship_type_id;
1694:
1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_DUP_CRITERIA_REL');
1696: FND_MESSAGE.SET_TOKEN('RELROLE', l_rel_type);

Line 1708: x_owner_table_name => 'HZ_RELATIONSHIP_TYPES',

1704: x_rowid => row_id,
1705: x_secured_item_id => x_secured_item_id,
1706: x_status => nvl(p_dss_secured_rel_type.status,'A'),
1707: x_dss_group_code => p_dss_secured_rel_type.dss_group_code,
1708: x_owner_table_name => 'HZ_RELATIONSHIP_TYPES',
1709: x_owner_table_id1 => p_dss_secured_rel_type.relationship_type_id,
1710: x_object_version_number => 1);
1711:
1712:

Line 1862: x_owner_table_name => 'HZ_RELATIONSHIP_TYPES',

1858: HZ_DSS_CRITERIA_PKG.Update_Row (
1859: x_rowid => l_rowid,
1860: x_status => p_dss_secured_rel_type.status,
1861: x_dss_group_code => p_dss_secured_rel_type.dss_group_code,
1862: x_owner_table_name => 'HZ_RELATIONSHIP_TYPES',
1863: x_owner_table_id1 => p_dss_secured_rel_type.relationship_type_id,
1864: x_object_version_number => x_object_version_number);
1865:
1866: