DBA Data[Home] [Help]

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_OBJ_ATTRIBS_S

Line 828: NVL(p_obj_attrib_id,igs_sc_obj_attribs_s.nextval),

824: last_update_login,
825: active_flag
826: )
827: VALUES (l_obj_group_id,
828: NVL(p_obj_attrib_id,igs_sc_obj_attribs_s.nextval),
829: p_obj_attrib_name,
830: SYSDATE,
831: NVL(FND_GLOBAL.user_id,-1),
832: NVL(FND_GLOBAL.user_id,-1),

Line 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;

7911: UPDATE IGS_SC_OBJECTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7912:
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

Line 7967: UPDATE igs_sc_obj_attribs SET obj_attrib_id = l_current_seq WHERE CURRENT OF igs_sc_obj_attribs_c;

7963:
7964: UPDATE IGS_SC_GRANT_CONDS SET obj_attrib_id = l_current_seq WHERE obj_attrib_id = igs_sc_obj_attribs_rec.obj_attrib_id;
7965:
7966: -- Update table itself
7967: UPDATE igs_sc_obj_attribs SET obj_attrib_id = l_current_seq WHERE CURRENT OF igs_sc_obj_attribs_c;
7968:
7969: END IF;
7970:
7971: l_current_seq := l_current_seq +1;