eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_DSS_GROUPS_PUB dependencies on HZ_DSS_CRITERIA

Line 705: from HZ_DSS_CRITERIA

701: --Bug 2645685 Duplicate criteria should not be created for a Data Sharing
702: --group, class catefory and class code combination
703:
704: select count(*) into l_dup_count
705: from HZ_DSS_CRITERIA
706: where dss_group_code = p_dss_secured_module.dss_group_code
707: and owner_table_name = 'AR_LOOKUPS'
708: and owner_table_id1 = 'HZ_CREATED_BY_MODULES'
709: and owner_table_id2 = p_dss_secured_module.created_by_module;

Line 720: HZ_DSS_CRITERIA_PKG.Insert_Row (

716: END IF;
717:
718:
719: -- Call the low level table handler
720: HZ_DSS_CRITERIA_PKG.Insert_Row (
721: x_rowid => row_id,
722: x_secured_item_id => x_secured_item_id,
723: x_status => nvl(p_dss_secured_module.status,'A'),
724: x_dss_group_code => p_dss_secured_module.dss_group_code,

Line 798: l_dss_group_code HZ_DSS_CRITERIA.DSS_GROUP_CODE%TYPE;

794: )
795: IS
796: l_object_version_number NUMBER;
797: l_rowid ROWID;
798: l_dss_group_code HZ_DSS_CRITERIA.DSS_GROUP_CODE%TYPE;
799: l_created_by_module HZ_DSS_CRITERIA.owner_table_id2%TYPE;
800:
801: BEGIN
802: -- initialize message list if p_init_msg_list is set to TRUE.

Line 799: l_created_by_module HZ_DSS_CRITERIA.owner_table_id2%TYPE;

795: IS
796: l_object_version_number NUMBER;
797: l_rowid ROWID;
798: l_dss_group_code HZ_DSS_CRITERIA.DSS_GROUP_CODE%TYPE;
799: l_created_by_module HZ_DSS_CRITERIA.owner_table_id2%TYPE;
800:
801: BEGIN
802: -- initialize message list if p_init_msg_list is set to TRUE.
803: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 817: FROM HZ_DSS_CRITERIA

813: -- check whether record has been updated by another user. If not, lock it.
814: BEGIN
815: SELECT object_version_number, rowid,dss_group_code,owner_table_id2
816: INTO l_object_version_number, l_rowid,l_dss_group_code,l_created_by_module
817: FROM HZ_DSS_CRITERIA
818: WHERE secured_item_id = p_dss_secured_module.secured_item_id
819: FOR UPDATE NOWAIT;
820: EXCEPTION
821: WHEN NO_DATA_FOUND THEN

Line 832: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');

828: IF NOT ((x_object_version_number is null and l_object_version_number is null)
829: OR (x_object_version_number = l_object_version_number))
830: THEN
831: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
832: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');
833: FND_MSG_PUB.ADD;
834: RAISE FND_API.G_EXC_ERROR;
835: END IF;
836:

Line 844: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

840: IF ( p_dss_secured_module.dss_group_code <> FND_API.G_MISS_CHAR OR
841: l_dss_group_code IS NOT NULL )
842: AND ( l_dss_group_code IS NULL OR
843: p_dss_secured_module.dss_group_code <> l_dss_group_code ) THEN
844: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
845: FND_MSG_PUB.ADD;
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848:

Line 854: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

850: IF ( p_dss_secured_module.created_by_module <> FND_API.G_MISS_CHAR OR
851: l_created_by_module IS NOT NULL )
852: AND ( l_created_by_module IS NULL OR
853: p_dss_secured_module.created_by_module <> l_created_by_module ) THEN
854: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
855: FND_MSG_PUB.ADD;
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858:

Line 884: HZ_DSS_CRITERIA_PKG.Update_Row (

880: */
881:
882:
883: -- Call the low level table handler
884: HZ_DSS_CRITERIA_PKG.Update_Row (
885: x_rowid => l_rowid,
886: x_status => p_dss_secured_module.status,
887: x_dss_group_code => p_dss_secured_module.dss_group_code,
888: x_owner_table_name => 'AR_LOOKUPS',

Line 1030: HZ_DSS_CRITERIA_PKG.Insert_Row (

1026: END IF;
1027:
1028:
1029: -- Call the low level table handler
1030: HZ_DSS_CRITERIA_PKG.Insert_Row (
1031: x_rowid => row_id,
1032: x_secured_item_id => x_secured_item_id,
1033: x_status => nvl(p_dss_secured_criterion.status,'A'),
1034: x_dss_group_code => p_dss_secured_criterion.dss_group_code,

Line 1129: FROM HZ_DSS_CRITERIA

1125: -- check whether record has been updated by another user. If not, lock it.
1126: BEGIN
1127: SELECT object_version_number, rowid
1128: INTO l_object_version_number, l_rowid
1129: FROM HZ_DSS_CRITERIA
1130: WHERE secured_item_id = p_dss_secured_criterion.secured_item_id
1131: FOR UPDATE NOWAIT;
1132: EXCEPTION
1133: WHEN NO_DATA_FOUND THEN

Line 1144: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');

1140: IF NOT ((x_object_version_number is null and l_object_version_number is null)
1141: OR (x_object_version_number = l_object_version_number))
1142: THEN
1143: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1144: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');
1145: FND_MSG_PUB.ADD;
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148:

Line 1191: HZ_DSS_CRITERIA_PKG.Update_Row (

1187:
1188: x_object_version_number := nvl(l_object_version_number, 1) + 1;
1189:
1190: -- Call the low level table handler
1191: HZ_DSS_CRITERIA_PKG.Update_Row (
1192: x_rowid => l_rowid,
1193: x_status => p_dss_secured_criterion.status,
1194: x_dss_group_code => p_dss_secured_criterion.dss_group_code,
1195: x_owner_table_name => p_dss_secured_criterion.owner_table_name,

Line 1354: from HZ_DSS_CRITERIA

1350: --Bug 2645685 Duplicate criteria should not be created for a Data Sharing
1351: --group, class catefory and class code combination
1352:
1353: select count(*) into l_dup_count
1354: from HZ_DSS_CRITERIA
1355: where dss_group_code = p_dss_secured_class.dss_group_code
1356: and owner_table_name = 'FND_LOOKUP_VALUES'
1357: and owner_table_id1 = p_dss_secured_class.class_category
1358: and owner_table_id2 = p_dss_secured_class.class_code;

Line 1370: HZ_DSS_CRITERIA_PKG.Insert_Row (

1366: END IF;
1367:
1368:
1369: -- Call the low level table handler
1370: HZ_DSS_CRITERIA_PKG.Insert_Row (
1371: x_rowid => row_id,
1372: x_secured_item_id => x_secured_item_id,
1373: x_status => nvl(p_dss_secured_class.status,'A'),
1374: x_dss_group_code => p_dss_secured_class.dss_group_code,

Line 1451: l_dss_group_code HZ_DSS_CRITERIA.DSS_GROUP_CODE%TYPE;

1447: )
1448: IS
1449: l_object_version_number NUMBER;
1450: l_rowid ROWID;
1451: l_dss_group_code HZ_DSS_CRITERIA.DSS_GROUP_CODE%TYPE;
1452: l_class_category HZ_DSS_CRITERIA.owner_table_id1%TYPE;
1453: l_class_code HZ_DSS_CRITERIA.owner_table_id2%TYPE;
1454:
1455: BEGIN

Line 1452: l_class_category HZ_DSS_CRITERIA.owner_table_id1%TYPE;

1448: IS
1449: l_object_version_number NUMBER;
1450: l_rowid ROWID;
1451: l_dss_group_code HZ_DSS_CRITERIA.DSS_GROUP_CODE%TYPE;
1452: l_class_category HZ_DSS_CRITERIA.owner_table_id1%TYPE;
1453: l_class_code HZ_DSS_CRITERIA.owner_table_id2%TYPE;
1454:
1455: BEGIN
1456: -- initialize message list if p_init_msg_list is set to TRUE.

Line 1453: l_class_code HZ_DSS_CRITERIA.owner_table_id2%TYPE;

1449: l_object_version_number NUMBER;
1450: l_rowid ROWID;
1451: l_dss_group_code HZ_DSS_CRITERIA.DSS_GROUP_CODE%TYPE;
1452: l_class_category HZ_DSS_CRITERIA.owner_table_id1%TYPE;
1453: l_class_code HZ_DSS_CRITERIA.owner_table_id2%TYPE;
1454:
1455: BEGIN
1456: -- initialize message list if p_init_msg_list is set to TRUE.
1457: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1474: FROM HZ_DSS_CRITERIA

1470: SELECT object_version_number, rowid , dss_group_code,
1471: owner_table_id1,owner_table_id2
1472: INTO l_object_version_number, l_rowid ,l_dss_group_code ,
1473: l_class_category , l_class_code
1474: FROM HZ_DSS_CRITERIA
1475: WHERE secured_item_id = p_dss_secured_class.secured_item_id
1476: FOR UPDATE NOWAIT;
1477: EXCEPTION
1478: WHEN NO_DATA_FOUND THEN

Line 1488: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');

1484: IF NOT ((x_object_version_number is null and l_object_version_number is null)
1485: OR (x_object_version_number = l_object_version_number))
1486: THEN
1487: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1488: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');
1489: FND_MSG_PUB.ADD;
1490: RAISE FND_API.G_EXC_ERROR;
1491: END IF;
1492:

Line 1501: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

1497: IF ( p_dss_secured_class.dss_group_code <> FND_API.G_MISS_CHAR OR
1498: l_dss_group_code IS NOT NULL )
1499: AND ( l_dss_group_code IS NULL OR
1500: p_dss_secured_class.dss_group_code <> l_dss_group_code ) THEN
1501: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505:

Line 1511: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

1507: IF ( p_dss_secured_class.class_category <> FND_API.G_MISS_CHAR OR
1508: l_class_category IS NOT NULL )
1509: AND ( l_class_category IS NULL OR
1510: p_dss_secured_class.class_category <> l_class_category ) THEN
1511: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515:

Line 1520: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

1516: IF ( p_dss_secured_class.class_code <> FND_API.G_MISS_CHAR OR
1517: l_class_code IS NOT NULL )
1518: AND ( l_class_code IS NULL OR
1519: p_dss_secured_class.class_code <> l_class_code ) THEN
1520: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
1521: FND_MSG_PUB.ADD;
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524:

Line 1537: HZ_DSS_CRITERIA_PKG.Update_Row (

1533: END IF;
1534: END IF;
1535:
1536: -- Call the low level table handler
1537: HZ_DSS_CRITERIA_PKG.Update_Row (
1538: x_rowid => l_rowid,
1539: x_status => p_dss_secured_class.status,
1540: x_dss_group_code => p_dss_secured_class.dss_group_code,
1541: x_owner_table_name => 'AR_LOOKUPS',

Line 1588: * The create_secured_rel_type procedure creates a record in HZ_DSS_CRITERIA that

1584: /**
1585: * PROCEDURE create_secured_rel_type
1586: *
1587: * DESCRIPTION
1588: * The create_secured_rel_type procedure creates a record in HZ_DSS_CRITERIA that
1589: * identifies a Relationship Type to be used as a criterion to determine if data falls under
1590: * the Data Sharing Group.
1591: *
1592: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 1684: from HZ_DSS_CRITERIA

1680: --Bug 2645685 Duplicate criteria should not be created for a Data Sharing
1681: --group, class catefory and class code combination
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:

Line 1703: HZ_DSS_CRITERIA_PKG.Insert_Row (

1699: END IF;
1700:
1701:
1702: -- Call the low level table handler
1703: HZ_DSS_CRITERIA_PKG.Insert_Row (
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,

Line 1752: * The UPDATE_SECURED_REL_TYPE procedure updates a record in HZ_DSS_CRITERIA that identifies

1748: /**
1749: * PROCEDURE update_secured_rel_type
1750: *
1751: * DESCRIPTION
1752: * The UPDATE_SECURED_REL_TYPE procedure updates a record in HZ_DSS_CRITERIA that identifies
1753: * a Relationship Type to be used as a criterion to determine if data falls under the Data Sharing
1754: * Group. Currently, only the STATUS column can be updated at this time.
1755: *
1756: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 1781: l_dss_group_code HZ_DSS_CRITERIA.DSS_GROUP_CODE%TYPE;

1777: )
1778: IS
1779: l_object_version_number NUMBER;
1780: l_rowid ROWID;
1781: l_dss_group_code HZ_DSS_CRITERIA.DSS_GROUP_CODE%TYPE;
1782: l_relationship_type_id HZ_DSS_CRITERIA.owner_table_id1%TYPE;
1783:
1784: BEGIN
1785: -- initialize message list if p_init_msg_list is set to TRUE.

Line 1782: l_relationship_type_id HZ_DSS_CRITERIA.owner_table_id1%TYPE;

1778: IS
1779: l_object_version_number NUMBER;
1780: l_rowid ROWID;
1781: l_dss_group_code HZ_DSS_CRITERIA.DSS_GROUP_CODE%TYPE;
1782: l_relationship_type_id HZ_DSS_CRITERIA.owner_table_id1%TYPE;
1783:
1784: BEGIN
1785: -- initialize message list if p_init_msg_list is set to TRUE.
1786: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1802: FROM HZ_DSS_CRITERIA

1798: BEGIN
1799: SELECT object_version_number, rowid , dss_group_code, owner_table_id1
1800: INTO l_object_version_number, l_rowid,l_dss_group_code,
1801: l_relationship_type_id
1802: FROM HZ_DSS_CRITERIA
1803: WHERE secured_item_id = p_dss_secured_rel_type.secured_item_id
1804: FOR UPDATE NOWAIT;
1805: EXCEPTION
1806: WHEN NO_DATA_FOUND THEN

Line 1816: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');

1812: IF NOT ((x_object_version_number is null and l_object_version_number is null)
1813: OR (x_object_version_number = l_object_version_number))
1814: THEN
1815: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1816: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;
1820:

Line 1828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

1824: IF ( p_dss_secured_rel_type.dss_group_code <> FND_API.G_MISS_CHAR OR
1825: l_dss_group_code IS NOT NULL )
1826: AND ( l_dss_group_code IS NULL OR
1827: p_dss_secured_rel_type.dss_group_code <> l_dss_group_code ) THEN
1828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
1829: FND_MSG_PUB.ADD;
1830: RAISE FND_API.G_EXC_ERROR;
1831: END IF;
1832:

Line 1839: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

1835: l_relationship_type_id IS NOT NULL )
1836: AND ( l_relationship_type_id IS NULL OR
1837: p_dss_secured_rel_type.relationship_type_id <> l_relationship_type_id )
1838: THEN
1839: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
1840: FND_MSG_PUB.ADD;
1841: RAISE FND_API.G_EXC_ERROR;
1842: END IF;
1843:

Line 1858: HZ_DSS_CRITERIA_PKG.Update_Row (

1854: END IF;
1855:
1856:
1857: -- Call the low level table handler
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',