APPS.IGS_SC_GRANTS_PVT dependencies on IGS_SC_OBJ_GROUPS

Line 70: default_policy_type igs_sc_obj_groups.default_policy_type%TYPE,

66: TYPE g_object_rec IS RECORD
67: ( obj_group_id igs_sc_objects.obj_group_id%TYPE,
68: object_id igs_sc_objects.object_id%TYPE,
69: table_name fnd_objects.database_object_name%TYPE,
70: default_policy_type igs_sc_obj_groups.default_policy_type%TYPE,
71: pk1_column_name fnd_objects.pk1_column_name%TYPE,
72: pk2_column_name fnd_objects.pk2_column_name%TYPE,
73: pk3_column_name fnd_objects.pk3_column_name%TYPE,
74: pk4_column_name fnd_objects.pk4_column_name%TYPE,

Line 393: igs_sc_obj_groups grp

389: pk5_column_type
390: FROM igs_sc_objects sco,
391: fnd_objects fnd,
392: igs_sc_grants grn,
393: igs_sc_obj_groups grp
394: WHERE (application_id IN (8405,8406))
395: AND fnd.object_id = sco.object_id
396: AND sco.obj_group_id = grn.obj_group_id
397: AND grn.grant_id = cp_grant_id

Line 1234: igs_sc_obj_groups grp

1230: pk4_column_type ,
1231: pk5_column_type
1232: FROM igs_sc_objects sco,
1233: fnd_objects fnd,
1234: igs_sc_obj_groups grp
1235: WHERE application_id IN (8405,8406)
1236: AND fnd.obj_name = cp_obj_name
1237: AND grp.obj_group_id = sco.obj_group_id
1238: AND fnd.object_id = sco.object_id;

Line 1817: UPDATE igs_sc_obj_groups

1813:
1814: IF FND_API.to_Boolean (p_disable_security) THEN
1815:
1816: -- Change default access level for all groups
1817: UPDATE igs_sc_obj_groups
1818: SET default_policy_type = 'G';
1819:
1820: END IF;
1821: