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_GRANTS

Line 665: DELETE FROM ibc_grants WHERE grant_group_id = l_grant_group_id;

661:
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;

Line 1008: DELETE FROM ibc_grants

1004: );
1005:
1006: IF p_inheritance_type = 'WSFOLDER' AND l_inherited_flag = FND_API.G_FALSE THEN
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;

Line 1334: DELETE FROM ibc_grants

1330: -- Only update if not currently inheriting and it is inheriting from
1331: -- a container
1332: IF l_inherited_flag = 'N' and l_inherited_from IS NOT NULL THEN
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;

Line 1683: FOR r_data IN (SELECT ibc_grants_s1.nextval grant_id,

1679: );
1680: END LOOP;
1681:
1682: -- Copy all rows From inherited from IBC_object_grant_groups
1683: FOR r_data IN (SELECT ibc_grants_s1.nextval grant_id,
1684: object_id, permission_code, grantee_user_id,
1685: grantee_resource_id, grantee_resource_type,
1686: l_grant_group_id grant_group_id,
1687: action, grant_level + 1 grant_level, cascade_flag

Line 1688: FROM ibc_grants

1684: object_id, permission_code, grantee_user_id,
1685: grantee_resource_id, grantee_resource_type,
1686: l_grant_group_id grant_group_id,
1687: action, grant_level + 1 grant_level, cascade_flag
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(

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 2110: FOR r_data IN (SELECT ibc_grants_s1.nextval grant_id,

2106: END IF;
2107:
2108: -- Copy all rows from container object
2109: -- It doesn't check for cascading at this point
2110: FOR r_data IN (SELECT ibc_grants_s1.nextval grant_id,
2111: object_id, permission_code, grantee_user_id,
2112: grantee_resource_id, grantee_resource_type,
2113: l_grant_group_id grant_group_id,
2114: action, grant_level + 1 grant_level, cascade_flag

Line 2115: FROM ibc_grants

2111: object_id, permission_code, grantee_user_id,
2112: grantee_resource_id, grantee_resource_type,
2113: l_grant_group_id grant_group_id,
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

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 2207: FOR r_data IN (SELECT ibc_grants_s1.nextval grant_id,

2203:
2204: END IF;
2205: IF l_inherited_flag = 'Y' THEN
2206: -- Copy all rows From inherited from IBC_object_grant_groups
2207: FOR r_data IN (SELECT ibc_grants_s1.nextval grant_id,
2208: object_id, permission_code, grantee_user_id,
2209: grantee_resource_id, grantee_resource_type,
2210: l_grant_group_id grant_group_id,
2211: action, grant_level + 1 grant_level, cascade_flag

Line 2212: FROM ibc_grants

2208: object_id, permission_code, grantee_user_id,
2209: grantee_resource_id, grantee_resource_type,
2210: l_grant_group_id grant_group_id,
2211: action, grant_level + 1 grant_level, cascade_flag
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(

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 2236: ' FROM ibc_grants ' ||

2232: END IF;
2233:
2234: -- Check if there is a row already with the same information at current level
2235: l_statement := ' SELECT ''X'' ' ||
2236: ' FROM ibc_grants ' ||
2237: ' WHERE object_id = :p_permission_object_id ' ||
2238: ' AND permission_code = :p_permission_code ' ||
2239: ' AND grant_group_id = :p_grant_group_id ' ||
2240: ' AND action = :p_action ' ||

Line 2271: -- Create and Propagate Row in IBC_GRANTS.

2267:
2268: FETCH c_chk_data INTO l_dummy;
2269:
2270: IF c_chk_data%NOTFOUND THEN
2271: -- Create and Propagate Row in IBC_GRANTS.
2272: FOR r_object_grant_group IN c_object_grant_group_tree(l_object_grant_group_id) LOOP
2273: --DBMS_OUTPUT.put_line(' inherited_flag:[' || r_object_grant_group.inherited_flag || ']' ||
2274: -- ' grant_level:['|| r_object_grant_group.grant_level || ']' ||
2275: -- ' inheritance_type:[' || r_object_grant_group.inheritance_type || ']');

Line 2280: SELECT ibc_grants_s1.nextval

2276: IF r_object_grant_group.inherited_flag = 'N' AND
2277: (r_object_grant_group.grant_level = 0 OR
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

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 2705: FROM ibc_grants

2701: WHERE grant_group_id = p_grant_group_id;
2702: -- Cursor for grants to check if there's need for branch of grants
2703: CURSOR c_grants(p_grant_group_id NUMBER, p_inheritance_type VARCHAR2) IS
2704: SELECT *
2705: FROM ibc_grants
2706: WHERE grant_group_id = p_grant_group_id
2707: AND (grant_level = 0 OR p_inheritance_type <> 'FULL');
2708: r_grant c_grants%ROWTYPE;
2709:

Line 2783: ' FROM ibc_grants ' ||

2779: IF l_object_grant_group_rowid IS NOT NULL THEN
2780:
2781:
2782: l_statement := ' SELECT grant_id ' ||
2783: ' FROM ibc_grants ' ||
2784: ' WHERE object_id = :p_permission_object_id ' ||
2785: ' AND permission_code = :p_permission_code ' ||
2786: ' AND action = :p_action ';
2787: IF p_grantee_user_id IS NOT NULL THEN

Line 2838: FOR r_data IN (SELECT ibc_grants_s1.nextval grant_id,

2834: ,p_object_version_number => 1
2835: );
2836:
2837: -- Copy all rows From inherited from IBC_object_grant_groups
2838: FOR r_data IN (SELECT ibc_grants_s1.nextval grant_id,
2839: object_id, permission_code, grantee_user_id,
2840: grantee_resource_id, grantee_resource_type,
2841: l_new_grant_group_id grant_group_id,
2842: action, grant_level + 1 grant_level, cascade_flag

Line 2843: FROM ibc_grants

2839: object_id, permission_code, grantee_user_id,
2840: grantee_resource_id, grantee_resource_type,
2841: l_new_grant_group_id grant_group_id,
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

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 2964: FROM ibc_grants

2960: FETCH c_grants into r_grant;
2961: IF c_grants%NOTFOUND THEN
2962: -- Remove grants if not grants at this level in case of FULL inheritance type
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;

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;

Line 3330: FROM ibc_grants

3326: ,p_inherited_flag VARCHAR2
3327: ,p_inheritance_type VARCHAR2)
3328: IS
3329: SELECT action
3330: FROM ibc_grants
3331: WHERE object_id = p_instance_object_id
3332: AND permission_code = p_permission_code
3333: AND grant_group_id = p_grant_group_id
3334: AND (p_inherited_flag = 'N'

Line 3517: FROM ibc_grants a0

3513: CURSOR c_permission(p_grant_group_id NUMBER
3514: ,p_inherited_flag VARCHAR2)
3515: IS
3516: SELECT permission_code
3517: FROM ibc_grants a0
3518: WHERE object_id = p_instance_object_id
3519: AND grant_group_id = p_grant_group_id
3520: AND ((grantee_user_id IS NULL AND grantee_resource_id IS NULL) OR
3521: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,

Line 3531: FROM ibc_grants a1

3527: OR cascade_flag = IBC_UTILITIES_PVT.g_true
3528: )
3529: AND NOT EXISTS (
3530: SELECT 'x'
3531: FROM ibc_grants a1
3532: WHERE a1.grant_group_id = a0.grant_group_id
3533: AND a1.object_id = a0.object_id
3534: AND a1.permission_code = a0.permission_code
3535: AND a1.action = 'RESTRICT'

Line 3752: FROM ibc_grants a0

3748: CURSOR c_permission(p_grant_group_id NUMBER
3749: ,p_inherited_flag VARCHAR2)
3750: IS
3751: SELECT permission_code
3752: FROM ibc_grants a0
3753: WHERE object_id = p_instance_object_id
3754: AND grant_group_id = p_grant_group_id
3755: AND ((grantee_user_id IS NULL AND grantee_resource_id IS NULL) OR
3756: (IBC_UTILITIES_PVT.Check_Current_User(grantee_user_id,

Line 3766: FROM ibc_grants a1

3762: OR cascade_flag = IBC_UTILITIES_PVT.g_true
3763: )
3764: AND NOT EXISTS (
3765: SELECT 'x'
3766: FROM ibc_grants a1
3767: WHERE a1.grant_group_id = a0.grant_group_id
3768: AND a1.object_id = a0.object_id
3769: AND a1.permission_code = a0.permission_code
3770: AND a1.action = 'RESTRICT'

Line 4136: FROM ibc_grants a0

4132: grant_group_id,
4133: grantee_user_id,
4134: grantee_resource_id,
4135: grantee_resource_type
4136: FROM ibc_grants a0
4137: WHERE object_id = p_object_id
4138: AND grant_group_id = p_grant_group_id
4139: AND permission_code = p_permission_code
4140: AND action = 'ALLOW'

Line 4482: FROM ibc_grants a0

4478: grant_level,
4479: grant_group_id,
4480: grantee_user_id,
4481: grantee_resource_id, grantee_resource_type
4482: FROM ibc_grants a0
4483: WHERE object_id = p_object_id
4484: AND grant_group_id = p_grant_group_id
4485: AND permission_code = p_permission_code
4486: AND action = 'ALLOW'