DBA Data[Home] [Help]

APPS.IBC_DATA_SECURITY_PVT dependencies on IBC_GRANTS_PKG

Line 1692: IBC_GRANTS_PKG.insert_row(

1688: FROM ibc_grants
1689: WHERE grant_group_id = l_old_grant_group_id
1690: AND cascade_flag = IBC_UTILITIES_PVT.g_true)
1691: LOOP
1692: IBC_GRANTS_PKG.insert_row(
1693: PX_ROWID => l_rowid
1694: ,P_GRANT_ID => r_data.grant_id
1695: ,P_PERMISSION_CODE => r_data.permission_code
1696: ,P_GRANTEE_USER_ID => r_data.grantee_user_id

Line 2118: IBC_GRANTS_PKG.insert_row(

2114: action, grant_level + 1 grant_level, cascade_flag
2115: FROM ibc_grants
2116: WHERE grant_group_id = l_c_grant_group_id)
2117: LOOP
2118: IBC_GRANTS_PKG.insert_row(
2119: PX_ROWID => l_rowid
2120: ,P_GRANT_ID => r_data.grant_id
2121: ,P_PERMISSION_CODE => r_data.permission_code
2122: ,P_GRANTEE_USER_ID => r_data.grantee_user_id

Line 2216: IBC_GRANTS_PKG.insert_row(

2212: FROM ibc_grants
2213: WHERE grant_group_id = l_old_grant_group_id
2214: AND cascade_flag = IBC_UTILITIES_PVT.g_true)
2215: LOOP
2216: IBC_GRANTS_PKG.insert_row(
2217: PX_ROWID => l_rowid
2218: ,P_GRANT_ID => r_data.grant_id
2219: ,P_PERMISSION_CODE => r_data.permission_code
2220: ,P_GRANTEE_USER_ID => r_data.grantee_user_id

Line 2283: IBC_GRANTS_PKG.insert_row(

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
2287: ,P_GRANTEE_USER_ID => p_grantee_user_id

Line 2846: IBC_GRANTS_PKG.insert_row(

2842: action, grant_level + 1 grant_level, cascade_flag
2843: FROM ibc_grants
2844: WHERE grant_group_id = l_grant_group_id)
2845: LOOP
2846: IBC_GRANTS_PKG.insert_row(
2847: PX_ROWID => l_rowid
2848: ,P_GRANT_ID => r_data.grant_id
2849: ,P_PERMISSION_CODE => r_data.permission_code
2850: ,P_GRANTEE_USER_ID => r_data.grantee_user_id

Line 2955: IBC_GRANTS_PKG.delete_row(l_grant_id);

2951: IBC_DEBUG_PVT.debug_message('LOOP');
2952: FETCH l_cursor INTO l_grant_id;
2953: EXIT WHEN l_cursor%NOTFOUND;
2954: l_count := l_count + 1;
2955: IBC_GRANTS_PKG.delete_row(l_grant_id);
2956: END LOOP;
2957: CLOSE l_cursor;
2958: IF l_count > 0 THEN
2959: OPEN c_grants(r_object_grant_group.grant_group_id, r_object_grant_group.inheritance_type);

Line 2967: IBC_GRANTS_PKG.delete_row(r_data.grant_id);

2963: FOR r_data IN (SELECT grant_id
2964: FROM ibc_grants
2965: WHERE grant_group_id = r_object_grant_group.grant_group_id)
2966: LOOP
2967: IBC_GRANTS_PKG.delete_row(r_data.grant_id);
2968: END LOOP;
2969: -- Fetch Parent
2970: OPEN c_object_grant_group_by_id(r_object_grant_group.inherited_from);
2971: FETCH c_object_grant_group_by_id INTO r_object_grant_group_by_id;