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.IBC_DATA_SECURITY_PVT dependencies on IBC_GRANT_GROUPS

Line 666: DELETE FROM ibc_grant_groups WHERE grant_group_id = l_grant_group_id;

662: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
663: IF l_inherited_flag = 'N' THEN
664: -- Removing grants and grant group if not inheriting
665: DELETE FROM ibc_grants WHERE grant_group_id = l_grant_group_id;
666: DELETE FROM ibc_grant_groups WHERE grant_group_id = l_grant_group_id;
667: END IF;
668: DELETE FROM ibc_object_grant_groups
669: WHERE ROWID = l_object_grant_group_rowid;
670: END IF;

Line 882: -- Create Row in IBC_grant_groups

878: THEN
879: -- No object's grant group (inheritance) defined for object
880: -- And no object's grant group for container
881: -- It will be treated as initial setup for root dir
882: -- Create Row in IBC_grant_groups
883: SELECT ibc_grant_groups_s1.nextval
884: INTO l_grant_group_id
885: FROM dual;
886: IBC_GRANT_GROUPS_PKG.insert_row(

Line 883: SELECT ibc_grant_groups_s1.nextval

879: -- No object's grant group (inheritance) defined for object
880: -- And no object's grant group for container
881: -- It will be treated as initial setup for root dir
882: -- Create Row in IBC_grant_groups
883: SELECT ibc_grant_groups_s1.nextval
884: INTO l_grant_group_id
885: FROM dual;
886: IBC_GRANT_GROUPS_PKG.insert_row(
887: px_rowid => l_rowid

Line 886: IBC_GRANT_GROUPS_PKG.insert_row(

882: -- Create Row in IBC_grant_groups
883: SELECT ibc_grant_groups_s1.nextval
884: INTO l_grant_group_id
885: FROM dual;
886: IBC_GRANT_GROUPS_PKG.insert_row(
887: px_rowid => l_rowid
888: ,p_grant_group_id => l_grant_group_id
889: ,p_object_version_number => 1
890: );

Line 1011: DELETE FROM ibc_grant_groups

1007: -- Removing all permissions for grant group if it's WSFOLDER and it's not inheriting
1008: DELETE FROM ibc_grants
1009: WHERE grant_group_id = l_grant_group_id;
1010: -- Remove grant group
1011: DELETE FROM ibc_grant_groups
1012: WHERE grant_group_id = l_grant_group_id;
1013: -- update inheritance to all the the ones pointing to such grant group to
1014: -- point to the container's, and change inheritance type for all of them to
1015: -- WSFOLDER

Line 1337: DELETE FROM ibc_grant_groups

1333: -- Removing all permissions for grant group
1334: DELETE FROM ibc_grants
1335: WHERE grant_group_id = l_grant_group_id;
1336: -- Remove grant group
1337: DELETE FROM ibc_grant_groups
1338: WHERE grant_group_id = l_grant_group_id;
1339: -- Sets inherited_flag to Y and points to grant group from container
1340: UPDATE ibc_object_grant_groups
1341: SET inherited_flag = 'Y',

Line 1620: -- Create Row in IBC_grant_groups

1616: IF c_ogg%FOUND THEN
1617:
1618: l_old_grant_group_id := l_grant_group_id;
1619:
1620: -- Create Row in IBC_grant_groups
1621: SELECT ibc_grant_groups_s1.nextval
1622: INTO l_grant_group_id
1623: FROM dual;
1624: IBC_GRANT_GROUPS_PKG.insert_row(

Line 1621: SELECT ibc_grant_groups_s1.nextval

1617:
1618: l_old_grant_group_id := l_grant_group_id;
1619:
1620: -- Create Row in IBC_grant_groups
1621: SELECT ibc_grant_groups_s1.nextval
1622: INTO l_grant_group_id
1623: FROM dual;
1624: IBC_GRANT_GROUPS_PKG.insert_row(
1625: px_rowid => l_rowid

Line 1624: IBC_GRANT_GROUPS_PKG.insert_row(

1620: -- Create Row in IBC_grant_groups
1621: SELECT ibc_grant_groups_s1.nextval
1622: INTO l_grant_group_id
1623: FROM dual;
1624: IBC_GRANT_GROUPS_PKG.insert_row(
1625: px_rowid => l_rowid
1626: ,p_grant_group_id => l_grant_group_id
1627: ,p_object_version_number => 1
1628: );

Line 2070: -- Create Row in IBC_grant_groups

2066: IF l_object_grant_group_id IS NULL OR
2067: l_inherited_flag = 'Y'
2068: THEN
2069: l_old_grant_group_id := l_grant_group_id;
2070: -- Create Row in IBC_grant_groups
2071: SELECT ibc_grant_groups_s1.nextval
2072: INTO l_grant_group_id
2073: FROM dual;
2074: IBC_GRANT_GROUPS_PKG.insert_row(

Line 2071: SELECT ibc_grant_groups_s1.nextval

2067: l_inherited_flag = 'Y'
2068: THEN
2069: l_old_grant_group_id := l_grant_group_id;
2070: -- Create Row in IBC_grant_groups
2071: SELECT ibc_grant_groups_s1.nextval
2072: INTO l_grant_group_id
2073: FROM dual;
2074: IBC_GRANT_GROUPS_PKG.insert_row(
2075: px_rowid => l_rowid

Line 2074: IBC_GRANT_GROUPS_PKG.insert_row(

2070: -- Create Row in IBC_grant_groups
2071: SELECT ibc_grant_groups_s1.nextval
2072: INTO l_grant_group_id
2073: FROM dual;
2074: IBC_GRANT_GROUPS_PKG.insert_row(
2075: px_rowid => l_rowid
2076: ,p_grant_group_id => l_grant_group_id
2077: ,p_object_version_number => 1
2078: );

Line 2827: -- Create Row in IBC_grant_groups

2823:
2824: FETCH l_cursor INTO l_grant_id;
2825: IF l_cursor%FOUND THEN
2826:
2827: -- Create Row in IBC_grant_groups
2828: SELECT ibc_grant_groups_s1.nextval
2829: INTO l_new_grant_group_id
2830: FROM dual;
2831: IBC_GRANT_GROUPS_PKG.insert_row(

Line 2828: SELECT ibc_grant_groups_s1.nextval

2824: FETCH l_cursor INTO l_grant_id;
2825: IF l_cursor%FOUND THEN
2826:
2827: -- Create Row in IBC_grant_groups
2828: SELECT ibc_grant_groups_s1.nextval
2829: INTO l_new_grant_group_id
2830: FROM dual;
2831: IBC_GRANT_GROUPS_PKG.insert_row(
2832: px_rowid => l_rowid

Line 2831: IBC_GRANT_GROUPS_PKG.insert_row(

2827: -- Create Row in IBC_grant_groups
2828: SELECT ibc_grant_groups_s1.nextval
2829: INTO l_new_grant_group_id
2830: FROM dual;
2831: IBC_GRANT_GROUPS_PKG.insert_row(
2832: px_rowid => l_rowid
2833: ,p_grant_group_id => l_new_grant_group_id
2834: ,p_object_version_number => 1
2835: );

Line 3005: IBC_GRANT_GROUPS_PKG.delete_row(r_object_grant_group.grant_group_id);

3001: -- Remove Grant Bundle if not in use anymore
3002: OPEN c_object_grant_groups(r_object_grant_group.grant_group_id);
3003: FETCH c_object_grant_groups INTO l_dummy;
3004: IF c_object_grant_groups%NOTFOUND THEN
3005: IBC_GRANT_GROUPS_PKG.delete_row(r_object_grant_group.grant_group_id);
3006: END IF;
3007: CLOSE c_object_grant_groups;
3008: END IF;
3009: CLOSE c_grants;