APPS.IGS_SC_GEN_001 dependencies on IGS_SC_OBJ_GROUPS

Line 216: igs_sc_obj_groups b,

212: CURSOR def_grnt(p_obj_name VARCHAR2)
213: IS
214: SELECT b.DEFAULT_POLICY_TYPE
215: FROM igs_sc_objects a,
216: igs_sc_obj_groups b,
217: fnd_objects c
218: WHERE c.obj_name = p_obj_name
219: AND c.object_id = a.object_id
220: AND b.obj_group_id = a.obj_group_id;

Line 1246: l_default IGS_SC_OBJ_GROUPS.default_policy_type%type ;

1242: ------------------------------------------------------------------
1243:
1244: l_user_id fnd_user.user_id%type;
1245: l_return varchar2(4000); --incase sql errmr then 4000
1246: l_default IGS_SC_OBJ_GROUPS.default_policy_type%type ;
1247: l_obj_grp_id IGS_SC_OBJ_GROUPS.obj_group_id%type;
1248: l_role_id NUMBER;
1249:
1250: CURSOR c_user (cp_igs varchar, cp_fnd varchar, cp_fnd_user fnd_user.user_id%type) IS

Line 1247: l_obj_grp_id IGS_SC_OBJ_GROUPS.obj_group_id%type;

1243:
1244: l_user_id fnd_user.user_id%type;
1245: l_return varchar2(4000); --incase sql errmr then 4000
1246: l_default IGS_SC_OBJ_GROUPS.default_policy_type%type ;
1247: l_obj_grp_id IGS_SC_OBJ_GROUPS.obj_group_id%type;
1248: l_role_id NUMBER;
1249:
1250: CURSOR c_user (cp_igs varchar, cp_fnd varchar, cp_fnd_user fnd_user.user_id%type) IS
1251: SELECT role_orig_system_id

Line 1262: FROM IGS_SC_OBJ_GROUPS

1258:
1259:
1260: CURSOR c_bo (cp_bo_name varchar) IS
1261: SELECT default_policy_type, obj_group_id
1262: FROM IGS_SC_OBJ_GROUPS
1263: WHERE obj_group_name = cp_bo_name;
1264:
1265: CURSOR c_policy (cp_role_id NUMBER, cp_bo_id NUMBER) IS
1266: SELECT grant_id,locked_flag ,grant_select_flag,grant_update_flag,grant_insert_flag,grant_delete_flag