APPS.IBC_DATA_SECURITY_PVT dependencies on DUAL

Line 885: FROM dual;

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
888: ,p_grant_group_id => l_grant_group_id
889: ,p_object_version_number => 1

Line 894: FROM dual;

890: );
891: -- Create Row in IBC_object_grant_groups
892: SELECT ibc_object_grant_groups_s1.nextval
893: INTO l_object_grant_group_id
894: FROM dual;
895: IBC_OBJECT_GRANT_GROUPS_PKG.insert_row(
896: px_rowid => l_rowid
897: ,p_object_grant_group_id => l_object_grant_group_id
898: ,p_object_version_number => 1

Line 946: FROM dual;

942: END IF;
943:
944: SELECT ibc_object_grant_groups_s1.nextval
945: INTO l_object_grant_group_id
946: FROM dual;
947: IBC_OBJECT_GRANT_GROUPS_PKG.insert_row(
948: px_rowid => l_rowid
949: ,p_object_grant_group_id => l_object_grant_group_id
950: ,p_object_version_number => 1

Line 1623: FROM dual;

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
1626: ,p_grant_group_id => l_grant_group_id
1627: ,p_object_version_number => 1

Line 2073: FROM dual;

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
2076: ,p_grant_group_id => l_grant_group_id
2077: ,p_object_version_number => 1

Line 2082: FROM dual;

2078: );
2079: IF l_object_grant_group_id IS NULL THEN
2080: SELECT ibc_object_grant_groups_s1.nextval
2081: INTO l_object_grant_group_id
2082: FROM dual;
2083: IF p_container_object_id IS NOT NULL THEN
2084: -- Fetch object's grant group info for Container
2085: get_object_grant_group_info(
2086: p_instance_object_id => p_container_object_id

Line 2282: FROM DUAL;

2278: r_object_grant_group.inheritance_type = 'FULL')
2279: THEN
2280: SELECT ibc_grants_s1.nextval
2281: INTO l_grant_id
2282: FROM DUAL;
2283: IBC_GRANTS_PKG.insert_row(
2284: PX_ROWID => l_rowid
2285: ,P_GRANT_ID => l_grant_id
2286: ,P_PERMISSION_CODE => p_permission_code

Line 2830: FROM dual;

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
2833: ,p_grant_group_id => l_new_grant_group_id
2834: ,p_object_version_number => 1

Line 3989: SELECT group_id group_id, resource_id group_resource_id, 'INDIVIDUAL' resource_type

3985: FROM jtf_rs_all_resources_vl
3986: WHERE resource_id = p_resource_id;
3987:
3988: CURSOR c_grp_members(p_resource_id NUMBER) IS
3989: SELECT group_id group_id, resource_id group_resource_id, 'INDIVIDUAL' resource_type
3990: FROM jtf_rs_group_members
3991: WHERE group_id = p_resource_id
3992: AND delete_flag = 'N'
3993: UNION

Line 4246: -- responsibility users and individual users, checking permission will filter out

4242: -- Set output result
4243: FOR I IN 1..l_user_id_tbl.COUNT LOOP
4244: -- Check permission under a specific user
4245: -- checking permission is commented out as now user list contains mix of all i.e. group,
4246: -- responsibility users and individual users, checking permission will filter out
4247: -- users coming via group and responsibility causing not notification received.
4248: -- so commenting if and end if for same
4249: /*
4250: IF IBC_DATA_SECURITY_PVT.has_permission(p_instance_object_id => p_instance_object_id,