DBA Data[Home] [Help]

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_OBJ_GROUPS_S

Line 664: VALUES (NVL(p_obj_group_id,igs_sc_obj_groups_s.nextval),

660: last_updated_by,
661: last_update_date,
662: last_update_login
663: )
664: VALUES (NVL(p_obj_group_id,igs_sc_obj_groups_s.nextval),
665: p_obj_group_name,
666: l_default_policy_type,
667: SYSDATE,
668: NVL(FND_GLOBAL.user_id,-1),

Line 7920: UPDATE igs_sc_obj_groups SET obj_group_id = l_current_seq WHERE CURRENT OF igs_sc_obj_groups_c;

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:
7922: END IF;
7923:
7924: l_current_seq := l_current_seq +1;