APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_GRANTS_S

Line 266: VALUES (NVL(p_grant_id,igs_sc_grants_s.nextval),

262: last_updated_by,
263: last_update_date,
264: last_update_login
265: )
266: VALUES (NVL(p_grant_id,igs_sc_grants_s.nextval),
267: l_function_id,
268: l_user_group_id,
269: l_obj_group_id,
270: p_grant_name,

Line 7869: UPDATE igs_sc_grants SET grant_id = l_current_seq WHERE CURRENT OF igs_sc_grants_c;

7865:
7866: UPDATE IGS_SC_GRANT_CONDS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;
7867:
7868: -- Update table itself
7869: UPDATE igs_sc_grants SET grant_id = l_current_seq WHERE CURRENT OF igs_sc_grants_c;
7870:
7871: END IF;
7872:
7873: l_current_seq := l_current_seq +1;

Line 7917: UPDATE IGS_SC_GRANTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;

7913: UPDATE IGS_SC_OBJ_FUNCTNS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7914:
7915: UPDATE IGS_SC_OBJ_ATTRIBS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7916:
7917: UPDATE IGS_SC_GRANTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7918:
7919: -- Update table itself
7920: UPDATE igs_sc_obj_groups SET obj_group_id = l_current_seq WHERE CURRENT OF igs_sc_obj_groups_c;
7921:

Line 7938: UPDATE IGS_SC_GRANTS SET function_id = l_current_seq WHERE function_id = igs_sc_obj_functns_rec.function_id;

7934: IF igs_sc_obj_functns_rec.function_id <> l_current_seq THEN
7935:
7936: -- Update all tables
7937:
7938: UPDATE IGS_SC_GRANTS SET function_id = l_current_seq WHERE function_id = igs_sc_obj_functns_rec.function_id;
7939:
7940: -- Update table itself
7941: UPDATE igs_sc_obj_functns SET function_id = l_current_seq WHERE CURRENT OF igs_sc_obj_functns_c;
7942: