427: X_MODE in VARCHAR2 default 'R',
428: x_org_id IN NUMBER
429: ) as
430: /****************************************************************************
431: sbaliga 13-feb-2002 Assigned igs_ge_gen_003.get_org_id to x_org_id
432: in call to before_dml as part of SWCR006 build.
433: ****************************************************************************/
434: cursor C is select ROWID from IGS_PS_DSCP_ALL
435: where DISCIPLINE_GROUP_CD = X_DISCIPLINE_GROUP_CD;
469: x_created_by => X_LAST_UPDATED_BY,
470: x_last_update_date => X_LAST_UPDATE_DATE,
471: x_last_updated_by => X_LAST_UPDATED_BY,
472: x_last_update_login => X_LAST_UPDATE_LOGIN,
473: x_org_id => igs_ge_gen_003.get_org_id
474: );
475: insert into IGS_PS_DSCP_ALL (
476: DISCIPLINE_GROUP_CD,
477: DESCRIPTION,