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_OBJECT_GRANT_GROUPS

Line 211: ' FROM ibc_object_grant_groups ' ||

207: );
208: -- Prepare SQL statement to get Grant Bundle Id
209: l_statement := 'SELECT rowid, object_grant_group_id, grant_group_id, ' ||
210: ' inherited_flag, inherited_from, inheritance_type ' ||
211: ' FROM ibc_object_grant_groups ' ||
212: ' WHERE object_id = :p_instance_object_id ' ||
213: ' AND instance_pk1_value = :p_instance_pk1_value ';
214: IF l_nbr_pk_cols > 1 THEN
215: l_statement := l_statement ||

Line 267: -- Fetching Info from IBC_object_grant_groups

263: USING p_instance_object_id,
264: canonical_from_value(p_instance_pk1_value, l_object_definition.pk1_column_type);
265: END IF;
266:
267: -- Fetching Info from IBC_object_grant_groups
268: FETCH c_cursor INTO x_rowid, x_object_grant_group_id, x_grant_group_id,
269: x_inherited_flag, x_inherited_from, x_inheritance_type;
270:
271: IF c_cursor%NOTFOUND THEN

Line 383: -- IBC_object_grant_groups

379: l_rowid ROWID;
380: --******** local variable for standards **********
381: l_api_name CONSTANT VARCHAR2(30) := 'set_inheritance_type';
382: l_api_version CONSTANT NUMBER := 1.0;
383: -- IBC_object_grant_groups
384: l_object_grant_group_rowid ROWID;
385: l_object_grant_group_id NUMBER;
386: l_old_grant_group_id NUMBER;
387: l_grant_group_id NUMBER;

Line 392: -- IBC_object_grant_groups

388: l_inherited_flag VARCHAR2(2);
389: l_inherited_from NUMBER;
390: l_inheritance_type VARCHAR2(30);
391: l_default_inheritance_type VARCHAR2(30);
392: -- IBC_object_grant_groups
393: l_c_object_grant_group_rowid ROWID;
394: l_c_object_grant_group_id NUMBER;
395: l_c_grant_group_id NUMBER;
396: l_c_inherited_flag VARCHAR2(2);

Line 407: FROM ibc_object_grant_groups

403: instance_pk2_value,
404: instance_pk3_value,
405: instance_pk4_value,
406: instance_pk5_value
407: FROM ibc_object_grant_groups
408: WHERE object_grant_group_id = p_object_grant_group_id;
409: r_ogg c_ogg%ROWTYPE;
410:
411: BEGIN

Line 587: -- IBC_object_grant_groups

583: l_rowid ROWID;
584: --******** local variable for standards **********
585: l_api_name CONSTANT VARCHAR2(30) := 'Remove_Instance';
586: l_api_version CONSTANT NUMBER := 1.0;
587: -- IBC_object_grant_groups
588: l_object_grant_group_rowid ROWID;
589: l_object_grant_group_id NUMBER;
590: l_old_grant_group_id NUMBER;
591: l_grant_group_id NUMBER;

Line 599: FROM ibc_object_grant_groups

595: l_default_inheritance_type VARCHAR2(30);
596:
597: CURSOR c_child_ogg(p_ogg_id NUMBER) IS
598: SELECT *
599: FROM ibc_object_grant_groups
600: WHERE inherited_from = p_ogg_id;
601:
602: BEGIN
603: SAVEPOINT svpt_remove_instance;

Line 668: DELETE FROM ibc_object_grant_groups

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;
671:
672: END IF;

Line 798: -- IBC_object_grant_groups

794: l_rowid ROWID;
795: --******** local variable for standards **********
796: l_api_name CONSTANT VARCHAR2(30) := 'establish_inheritance';
797: l_api_version CONSTANT NUMBER := 1.0;
798: -- IBC_object_grant_groups
799: l_object_grant_group_rowid ROWID;
800: l_object_grant_group_id NUMBER;
801: l_old_grant_group_id NUMBER;
802: l_grant_group_id NUMBER;

Line 807: -- IBC_object_grant_groups

803: l_inherited_flag VARCHAR2(2);
804: l_inherited_from NUMBER;
805: l_inheritance_type VARCHAR2(30);
806: l_default_inheritance_type VARCHAR2(30);
807: -- IBC_object_grant_groups
808: l_c_object_grant_group_rowid ROWID;
809: l_c_object_grant_group_id NUMBER;
810: l_c_grant_group_id NUMBER;
811: l_c_inherited_flag VARCHAR2(2);

Line 817: FROM ibc_object_grant_groups

813: l_c_inheritance_type VARCHAR2(30);
814: -- Cursor to get all ogg children objects
815: CURSOR c_ogg_children(p_ogg_id IN NUMBER) IS
816: SELECT *
817: FROM ibc_object_grant_groups
818: WHERE inherited_from = p_ogg_id;
819: BEGIN
820: SAVEPOINT svpt_establish_inheritance;
821:

Line 891: -- Create Row in IBC_object_grant_groups

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

Line 892: SELECT ibc_object_grant_groups_s1.nextval

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

Line 895: IBC_OBJECT_GRANT_GROUPS_PKG.insert_row(

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
899: ,p_grant_group_id => l_grant_group_id

Line 914: -- Create Row in IBC_object_grant_groups

910: ELSIF l_object_grant_group_rowid IS NULL THEN
911: -- No object's grant group (inheritance) defined for object
912: -- but defined for container object.
913: -- Regular inheritance row will be added to object_grant_group
914: -- Create Row in IBC_object_grant_groups
915:
916: -- Validation of inheritance type
917: IF (l_c_inheritance_type = 'WORKSPACE' AND
918: p_inheritance_type <> 'WSFOLDER')

Line 944: SELECT ibc_object_grant_groups_s1.nextval

940: l_default_inheritance_Type := l_c_inheritance_type;
941: END IF;
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

Line 947: IBC_OBJECT_GRANT_GROUPS_PKG.insert_row(

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
951: ,p_grant_group_id => l_c_grant_group_id

Line 991: Ibc_Object_Grant_Groups_Pkg.UPDATE_ROW (

987: END IF;
988:
989: -- Actual UPDATE
990: -- *****
991: Ibc_Object_Grant_Groups_Pkg.UPDATE_ROW (
992: P_OBJECT_GRANT_GROUP_ID => l_object_grant_group_id,
993: p_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM,
994: P_GRANT_GROUP_ID => l_grant_group_id,
995: P_OBJECT_ID => p_instance_object_id,

Line 1016: UPDATE ibc_object_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
1016: UPDATE ibc_object_grant_groups
1017: SET inherited_flag = 'Y',
1018: grant_group_id = l_c_grant_group_id
1019: WHERE object_grant_group_id
1020: IN ( SELECT object_grant_group_id

Line 1021: FROM ibc_object_grant_groups

1017: SET inherited_flag = 'Y',
1018: grant_group_id = l_c_grant_group_id
1019: WHERE object_grant_group_id
1020: IN ( SELECT object_grant_group_id
1021: FROM ibc_object_grant_groups
1022: CONNECT BY PRIOR object_grant_group_id = inherited_from
1023: START WITH inherited_from = l_object_grant_group_id);
1024: END IF;
1025:

Line 1258: -- IBC_object_grant_groups

1254: l_rowid ROWID;
1255: --******** local variable for standards **********
1256: l_api_name CONSTANT VARCHAR2(30) := 'reset_permissions';
1257: l_api_version CONSTANT NUMBER := 1.0;
1258: -- IBC_object_grant_groups
1259: l_object_grant_group_rowid ROWID;
1260: l_object_grant_group_id NUMBER;
1261: l_old_grant_group_id NUMBER;
1262: l_grant_group_id NUMBER;

Line 1340: UPDATE ibc_object_grant_groups

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',
1342: grant_group_id = (SELECT grant_group_id
1343: FROM ibc_object_grant_groups
1344: WHERE object_grant_group_id = l_inherited_from)

Line 1343: FROM ibc_object_grant_groups

1339: -- Sets inherited_flag to Y and points to grant group from container
1340: UPDATE ibc_object_grant_groups
1341: SET inherited_flag = 'Y',
1342: grant_group_id = (SELECT grant_group_id
1343: FROM ibc_object_grant_groups
1344: WHERE object_grant_group_id = l_inherited_from)
1345: WHERE object_grant_group_id
1346: IN ( SELECT object_grant_group_id
1347: FROM ibc_object_grant_groups

Line 1347: FROM ibc_object_grant_groups

1343: FROM ibc_object_grant_groups
1344: WHERE object_grant_group_id = l_inherited_from)
1345: WHERE object_grant_group_id
1346: IN ( SELECT object_grant_group_id
1347: FROM ibc_object_grant_groups
1348: WHERE grant_group_id = l_grant_group_id);
1349: END IF;
1350:
1351: -- COMMIT?

Line 1509: -- IBC_object_grant_groups

1505: l_rowid ROWID;
1506: --******** local variable for standards **********
1507: l_api_name CONSTANT VARCHAR2(30) := 'override_permissions';
1508: l_api_version CONSTANT NUMBER := 1.0;
1509: -- IBC_object_grant_groups
1510: l_object_grant_group_rowid ROWID;
1511: l_object_grant_group_id NUMBER;
1512: l_grant_group_id NUMBER;
1513: l_inherited_flag VARCHAR2(2);

Line 1517: -- IBC_object_grant_groups

1513: l_inherited_flag VARCHAR2(2);
1514: l_inherited_from NUMBER;
1515: l_inheritance_type VARCHAR2(30);
1516: l_old_grant_group_id NUMBER;
1517: -- IBC_object_grant_groups
1518: l_c_object_grant_group_rowid ROWID;
1519: l_c_object_grant_group_id NUMBER;
1520: l_c_grant_group_id NUMBER;
1521: l_c_inherited_flag VARCHAR2(2);

Line 1532: FROM ibc_object_grant_groups

1528: instance_pk2_value,
1529: instance_pk3_value,
1530: instance_pk4_value,
1531: instance_pk5_value
1532: FROM ibc_object_grant_groups
1533: WHERE object_grant_group_id = p_object_grant_group_id;
1534:
1535: -- Cursor to apply/propagate changes for ObjectGrantGroups with same old grant group id
1536: CURSOR c_ogg_tree_update (p_object_grant_group_id NUMBER,

Line 1539: FROM ibc_object_grant_groups ogg

1535: -- Cursor to apply/propagate changes for ObjectGrantGroups with same old grant group id
1536: CURSOR c_ogg_tree_update (p_object_grant_group_id NUMBER,
1537: p_grant_group_id NUMBER) IS
1538: SELECT ogg.*
1539: FROM ibc_object_grant_groups ogg
1540: WHERE grant_group_id = p_grant_group_id
1541: AND inherited_flag = 'Y'
1542: CONNECT BY PRIOR object_grant_group_id = inherited_from
1543: START WITH inherited_from = p_object_grant_group_id;

Line 1630: -- Update Row in IBC_object_grant_groups

1626: ,p_grant_group_id => l_grant_group_id
1627: ,p_object_version_number => 1
1628: );
1629:
1630: -- Update Row in IBC_object_grant_groups
1631: FOR r_data IN (SELECT object_grant_group_id,
1632: object_version_number,
1633: object_id,
1634: inherited_from,

Line 1641: FROM ibc_object_grant_groups

1637: instance_pk3_value,
1638: instance_pk4_value,
1639: instance_pk5_value,
1640: inheritance_type
1641: FROM ibc_object_grant_groups
1642: WHERE ROWID = l_object_grant_group_rowid)
1643: LOOP
1644: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(
1645: p_object_grant_group_id => r_data.object_grant_group_id

Line 1644: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(

1640: inheritance_type
1641: FROM ibc_object_grant_groups
1642: WHERE ROWID = l_object_grant_group_rowid)
1643: LOOP
1644: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(
1645: p_object_grant_group_id => r_data.object_grant_group_id
1646: ,p_object_version_number => r_data.object_version_number
1647: ,p_grant_group_id => l_grant_group_id
1648: ,p_object_id => r_data.object_id

Line 1666: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(

1662:
1663: FOR r_tree_ogg IN c_ogg_tree_update (l_object_grant_group_id,
1664: l_old_grant_group_id)
1665: LOOP
1666: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(
1667: p_object_grant_group_id => r_tree_ogg.object_grant_group_id
1668: ,p_object_version_number => r_tree_ogg.object_version_number
1669: ,p_grant_group_id => l_grant_group_id
1670: ,p_object_id => r_tree_ogg.object_id

Line 1682: -- Copy all rows From inherited from IBC_object_grant_groups

1678: ,p_inheritance_type => r_tree_ogg.inheritance_type
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,

Line 1908: -- IBC_object_grant_groups

1904: -- Object Definition
1905: l_nbr_pk_cols NUMBER;
1906: l_fmt_col_lst VARCHAR2(4096);
1907: l_object_definition c_object%ROWTYPE;
1908: -- IBC_object_grant_groups
1909: l_object_grant_group_rowid ROWID;
1910: l_object_grant_group_id NUMBER;
1911: l_old_grant_group_id NUMBER;
1912: l_grant_group_id NUMBER;

Line 1916: -- IBC_object_grant_groups

1912: l_grant_group_id NUMBER;
1913: l_inherited_flag VARCHAR2(2);
1914: l_inherited_from NUMBER;
1915: l_inheritance_type VARCHAR2(30);
1916: -- IBC_object_grant_groups
1917: l_c_object_grant_group_rowid ROWID;
1918: l_c_object_grant_group_id NUMBER;
1919: l_c_grant_group_id NUMBER;
1920: l_c_inherited_flag VARCHAR2(2);

Line 1927: FROM ibc_object_grant_groups ogg

1923:
1924: -- Cursor to apply/propagate changes
1925: CURSOR c_object_grant_group_tree (p_object_grant_group_id NUMBER) IS
1926: SELECT LEVEL - 1 grant_level, ogg.*
1927: FROM ibc_object_grant_groups ogg
1928: CONNECT BY PRIOR object_grant_group_id = inherited_from
1929: AND p_cascade_flag = IBC_UTILITIES_PVT.g_true
1930: START WITH object_grant_group_id = p_object_grant_group_id;
1931:

Line 1936: FROM ibc_object_grant_groups ogg

1932: -- Cursor to apply/propagate changes for ObjectGrantGroups with same old grant group id
1933: CURSOR c_ogg_tree_update (p_object_grant_group_id NUMBER,
1934: p_grant_group_id NUMBER) IS
1935: SELECT ogg.*
1936: FROM ibc_object_grant_groups ogg
1937: WHERE grant_group_id = p_grant_group_id
1938: AND inherited_flag = 'Y'
1939: CONNECT BY PRIOR object_grant_group_id = inherited_from
1940: AND p_cascade_flag = IBC_UTILITIES_PVT.g_true

Line 2080: SELECT ibc_object_grant_groups_s1.nextval

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

Line 2134: -- Create Row in IBC_object_grant_groups

2130: ,P_OBJECT_ID => r_data.object_id
2131: );
2132: END LOOP;
2133: END IF;
2134: -- Create Row in IBC_object_grant_groups
2135: IBC_OBJECT_GRANT_GROUPS_PKG.insert_row(
2136: px_rowid => l_rowid
2137: ,p_object_grant_group_id => l_object_grant_group_id
2138: ,p_object_version_number => 1

Line 2135: IBC_OBJECT_GRANT_GROUPS_PKG.insert_row(

2131: );
2132: END LOOP;
2133: END IF;
2134: -- Create Row in IBC_object_grant_groups
2135: IBC_OBJECT_GRANT_GROUPS_PKG.insert_row(
2136: px_rowid => l_rowid
2137: ,p_object_grant_group_id => l_object_grant_group_id
2138: ,p_object_version_number => 1
2139: ,p_grant_group_id => l_grant_group_id

Line 2152: -- Update Row in IBC_object_grant_groups

2148: ,p_inheritance_type => l_c_inheritance_type
2149: );
2150:
2151: ELSE
2152: -- Update Row in IBC_object_grant_groups
2153: FOR r_data IN (SELECT object_grant_group_id,
2154: object_version_number,
2155: object_id,
2156: inherited_from,

Line 2163: FROM ibc_object_grant_groups

2159: instance_pk3_value,
2160: instance_pk4_value,
2161: instance_pk5_value,
2162: inheritance_type
2163: FROM ibc_object_grant_groups
2164: WHERE ROWID = l_object_grant_group_rowid)
2165: LOOP
2166: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(
2167: p_object_grant_group_id => r_data.object_grant_group_id

Line 2166: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(

2162: inheritance_type
2163: FROM ibc_object_grant_groups
2164: WHERE ROWID = l_object_grant_group_rowid)
2165: LOOP
2166: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(
2167: p_object_grant_group_id => r_data.object_grant_group_id
2168: ,p_object_version_number => r_data.object_version_number
2169: ,p_grant_group_id => l_grant_group_id
2170: ,p_object_id => r_data.object_id

Line 2188: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(

2184:
2185: FOR r_ogg IN c_ogg_tree_update (l_object_grant_group_id,
2186: l_old_grant_group_id)
2187: LOOP
2188: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(
2189: p_object_grant_group_id => r_ogg.object_grant_group_id
2190: ,p_object_version_number => r_ogg.object_version_number
2191: ,p_grant_group_id => l_grant_group_id
2192: ,p_object_id => r_ogg.object_id

Line 2206: -- Copy all rows From inherited from IBC_object_grant_groups

2202: END LOOP;
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,

Line 2673: -- IBC_object_grant_groups

2669: l_rowid ROWID;
2670: TYPE cursorType IS REF CURSOR;
2671: l_cursor cursorType;
2672: l_grant_id NUMBER;
2673: -- IBC_object_grant_groups
2674: l_object_grant_group_rowid ROWID;
2675: l_object_grant_group_id NUMBER;
2676: l_grant_group_id NUMBER;
2677: l_new_grant_group_id NUMBER;

Line 2687: FROM ibc_object_grant_groups ogg

2683: l_api_version CONSTANT NUMBER := 1.0;
2684: -- Cursor to apply/propagate changes
2685: CURSOR c_object_grant_group (p_object_grant_group_id NUMBER) IS
2686: SELECT LEVEL - 1 grant_level, ogg.*
2687: FROM ibc_object_grant_groups ogg
2688: CONNECT BY PRIOR object_grant_group_id = inherited_from
2689: START WITH object_grant_group_id = p_object_grant_group_id
2690: ORDER BY 1 asc;
2691: -- Cursor to fetch a specific object's grant group

Line 2694: FROM ibc_object_grant_groups

2690: ORDER BY 1 asc;
2691: -- Cursor to fetch a specific object's grant group
2692: CURSOR c_object_grant_group_by_id(p_object_grant_group_id NUMBER) IS
2693: SELECT *
2694: FROM ibc_object_grant_groups
2695: WHERE object_grant_group_id = p_object_grant_group_id;
2696: r_object_grant_group_by_id c_object_grant_group_by_id%ROWTYPE;
2697: -- Cursor to Check if object's grant group is still associated to a grant bundle id
2698: CURSOR c_object_grant_groups(p_grant_group_id NUMBER) IS

Line 2700: FROM ibc_object_grant_groups

2696: r_object_grant_group_by_id c_object_grant_group_by_id%ROWTYPE;
2697: -- Cursor to Check if object's grant group is still associated to a grant bundle id
2698: CURSOR c_object_grant_groups(p_grant_group_id NUMBER) IS
2699: SELECT 'X'
2700: FROM ibc_object_grant_groups
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 *

Line 2837: -- Copy all rows From inherited from IBC_object_grant_groups

2833: ,p_grant_group_id => l_new_grant_group_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,

Line 2862: -- Update Row in IBC_object_grant_groups

2858: ,P_OBJECT_ID => r_data.object_id
2859: );
2860: END LOOP;
2861:
2862: -- Update Row in IBC_object_grant_groups
2863: FOR r_data IN (SELECT object_grant_group_id,
2864: object_version_number,
2865: object_id,
2866: inherited_from,

Line 2873: FROM ibc_object_grant_groups

2869: instance_pk3_value,
2870: instance_pk4_value,
2871: instance_pk5_value,
2872: inheritance_type
2873: FROM ibc_object_grant_groups
2874: WHERE ROWID = l_object_grant_group_rowid)
2875:
2876: LOOP
2877: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(

Line 2877: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(

2873: FROM ibc_object_grant_groups
2874: WHERE ROWID = l_object_grant_group_rowid)
2875:
2876: LOOP
2877: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(
2878: p_object_grant_group_id => r_data.object_grant_group_id
2879: ,p_object_version_number => r_data.object_version_number
2880: ,p_grant_group_id => l_new_grant_group_id
2881: ,p_object_id => r_data.object_id

Line 2977: IBC_OBJECT_GRANT_GROUPS_PKG.delete_row(r_object_grant_group.object_grant_group_id);

2973: -- Remove grant object's grant group if parent object_id
2974: -- it's not the same as current object_id
2975: -- it means no danger to break the inheritance
2976: IF r_object_grant_group_by_id.object_id <> r_object_grant_group.object_id THEN
2977: IBC_OBJECT_GRANT_GROUPS_PKG.delete_row(r_object_grant_group.object_grant_group_id);
2978: ELSIF r_object_grant_group.inherited_from IS NOT NULL AND
2979: r_object_grant_group.inheritance_type = 'FULL' -- Added to fix bug# 3392944
2980: THEN
2981: -- Update grant object's grant group to inherit from container

Line 2984: FROM ibc_object_grant_groups

2980: THEN
2981: -- Update grant object's grant group to inherit from container
2982: SELECT grant_group_id
2983: INTO l_grant_group_id
2984: FROM ibc_object_grant_groups
2985: WHERE object_grant_group_id = r_object_grant_group.inherited_from;
2986: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(
2987: p_object_grant_group_id => r_object_grant_group.object_grant_group_id
2988: ,p_object_version_number => r_object_grant_group.object_version_number

Line 2986: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(

2982: SELECT grant_group_id
2983: INTO l_grant_group_id
2984: FROM ibc_object_grant_groups
2985: WHERE object_grant_group_id = r_object_grant_group.inherited_from;
2986: IBC_OBJECT_GRANT_GROUPS_PKG.update_row(
2987: p_object_grant_group_id => r_object_grant_group.object_grant_group_id
2988: ,p_object_version_number => r_object_grant_group.object_version_number
2989: ,p_grant_group_id => l_grant_group_id
2990: ,p_object_id => r_object_grant_group.object_id

Line 3317: -- IBC_object_grant_groups

3313: ) RETURN VARCHAR2 AS
3314: l_result VARCHAR2(30);
3315: -- Permission variables
3316: l_action VARCHAR2(30);
3317: -- IBC_object_grant_groups
3318: l_object_grant_group_rowid ROWID;
3319: l_object_grant_group_id NUMBER;
3320: l_grant_group_id NUMBER;
3321: l_inherited_flag VARCHAR2(2);

Line 3505: -- IBC_object_grant_groups

3501: l_result VARCHAR2(4096);
3502: l_perms_lookup_type VARCHAR2(30);
3503: -- Permission variables
3504: l_action VARCHAR2(30);
3505: -- IBC_object_grant_groups
3506: l_object_grant_group_rowid ROWID;
3507: l_object_grant_group_id NUMBER;
3508: l_grant_group_id NUMBER;
3509: l_inherited_flag VARCHAR2(2);

Line 3740: -- IBC_object_grant_groups

3736: l_api_version CONSTANT NUMBER := 1.0;
3737: -- Permission variables
3738: l_action VARCHAR2(30);
3739: l_add BOOLEAN;
3740: -- IBC_object_grant_groups
3741: l_object_grant_group_rowid ROWID;
3742: l_object_grant_group_id NUMBER;
3743: l_grant_group_id NUMBER;
3744: l_inherited_flag VARCHAR2(2);

Line 4109: -- IBC_object_grant_groups

4105: -- Variable to know if a grant ALLOW was given to everybody
4106: -- not used for the moment, but could be used in the future.
4107: l_granted_to_all VARCHAR2(1) := FND_API.g_false;
4108:
4109: -- IBC_object_grant_groups
4110: l_object_grant_group_rowid ROWID;
4111: l_object_grant_group_id NUMBER;
4112: l_grant_group_id NUMBER;
4113: l_inherited_flag VARCHAR2(2);

Line 4456: -- IBC_object_grant_groups

4452: -- Variable to know if a grant ALLOW was given to everybody
4453: -- not used for the moment, but could be used in the future.
4454: l_granted_to_all VARCHAR2(1) := FND_API.g_false;
4455:
4456: -- IBC_object_grant_groups
4457: l_object_grant_group_rowid ROWID;
4458: l_object_grant_group_id NUMBER;
4459: l_grant_group_id NUMBER;
4460: l_inherited_flag VARCHAR2(2);

Line 4699: -- IBC_object_grant_groups

4695: ,x_msg_count OUT NOCOPY NUMBER
4696: ,x_msg_data OUT NOCOPY VARCHAR2
4697: ) IS
4698:
4699: -- IBC_object_grant_groups
4700: l_object_grant_group_rowid ROWID;
4701: l_object_grant_group_id NUMBER;
4702: l_grant_group_id NUMBER;
4703: l_inherited_flag VARCHAR2(2);