DBA Data[Home] [Help]

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_OBJ_FUNCTNS_S

Line 1204: VALUES (NVL(igs_sc_obj_functns_s.nextval,p_function_id),

1200: last_updated_by,
1201: last_update_date,
1202: last_update_login
1203: )
1204: VALUES (NVL(igs_sc_obj_functns_s.nextval,p_function_id),
1205: l_obj_group_id,
1206: p_function_name,
1207: SYSDATE,
1208: NVL(FND_GLOBAL.user_id,-1),

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

7909: -- Update all tables
7910:
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;

Line 7941: UPDATE igs_sc_obj_functns SET function_id = l_current_seq WHERE CURRENT OF igs_sc_obj_functns_c;

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:
7943: END IF;
7944:
7945: l_current_seq := l_current_seq +1;