eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_EN_ST_SNAPSHOT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL
  ) AS

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_EN_ST_SNAPSHOT
      WHERE    rowid = x_rowid;

Line: 71


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 121


    IF (p_action = 'UPDATE') THEN
      new_references.creation_date := old_references.creation_date;

Line: 128


    new_references.last_update_date := x_last_update_date;

Line: 129


    new_references.last_updated_by := x_last_updated_by;

Line: 130


    new_references.last_update_login := x_last_update_login;

Line: 146


	     Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 160


      SELECT   rowid
      FROM     IGS_EN_ST_SNAPSHOT
      WHERE    snapshot_dt_time = x_snapshot_dt_time ;

Line: 186


      SELECT   rowid
      FROM     IGS_EN_ST_SNAPSHOT
      WHERE    ESS_ID = x_ESS_ID
      FOR UPDATE NOWAIT;

Line: 253


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL
  ) AS
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_ESS_ID,
      x_govt_attendance_type,
      x_funding_source,
      x_govt_funding_source,
      x_major_course,
      x_commencing_student_ind,
      x_school_leaver,
      x_new_to_higher_education,
      x_sua_location_cd,
      x_unit_class,
      x_unit_level,
      x_enrolled_dt,
      x_discontinued_dt,
      x_eftsu,
      x_weftsu,
      x_unit_int_course_level_cd,
      x_govt_reportable_ind,
      x_snapshot_dt_time,
      x_ci_cal_type,
      x_ci_sequence_number,
      x_person_id,
      x_course_cd,
      x_crv_version_number,
      x_unit_cd,
      x_uv_version_number,
      x_sua_cal_type,
      x_sua_ci_sequence_number,
      x_tr_org_unit_cd,
      x_tr_ou_start_dt,
      x_discipline_group_cd,
      x_govt_discipline_group_cd,
      x_crv_org_unit_cd,
      x_crv_ou_start_dt,
      x_course_type,
      x_govt_course_type,
      x_course_type_group_cd,
      x_sca_location_cd,
      x_attendance_mode,
      x_govt_attendance_mode,
      x_attendance_type,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 309


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
	IF Get_PK_For_Validation(
		 new_references.ESS_ID
	                            ) THEN

 		Fnd_message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 322


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
       Check_Parent_Existance;

Line: 325


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      Null;

Line: 328


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      		IF  Get_PK_For_Validation (
		          new_references.ESS_ID
				 ) THEN
		          Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 336


     ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      		  null;

Line: 338


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
           null;

Line: 352


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      Null;

Line: 355


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      Null;

Line: 358


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to After Delete.
      Null;

Line: 364


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_ESS_ID in out NOCOPY NUMBER,
  X_SNAPSHOT_DT_TIME in DATE,
  X_CI_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_PERSON_ID in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_CRV_VERSION_NUMBER in NUMBER,
  X_UNIT_CD in VARCHAR2,
  X_UV_VERSION_NUMBER in NUMBER,
  X_SUA_CAL_TYPE in VARCHAR2,
  X_SUA_CI_SEQUENCE_NUMBER in NUMBER,
  X_TR_ORG_UNIT_CD in VARCHAR2,
  X_TR_OU_START_DT in DATE,
  X_DISCIPLINE_GROUP_CD in VARCHAR2,
  X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
  X_CRV_ORG_UNIT_CD in VARCHAR2,
  X_CRV_OU_START_DT in DATE,
  X_COURSE_TYPE in VARCHAR2,
  X_GOVT_COURSE_TYPE in NUMBER,
  X_COURSE_TYPE_GROUP_CD in VARCHAR2,
  X_SCA_LOCATION_CD in VARCHAR2,
  X_ATTENDANCE_MODE in VARCHAR2,
  X_GOVT_ATTENDANCE_MODE in VARCHAR2,
  X_ATTENDANCE_TYPE in VARCHAR2,
  X_GOVT_ATTENDANCE_TYPE in VARCHAR2,
  X_FUNDING_SOURCE in VARCHAR2,
  X_GOVT_FUNDING_SOURCE in NUMBER,
  X_MAJOR_COURSE in NUMBER,
  X_COMMENCING_STUDENT_IND in VARCHAR2,
  X_SCHOOL_LEAVER in NUMBER,
  X_NEW_TO_HIGHER_EDUCATION in NUMBER,
  X_SUA_LOCATION_CD in VARCHAR2,
  X_UNIT_CLASS in VARCHAR2,
  X_UNIT_LEVEL in VARCHAR2,
  X_ENROLLED_DT in DATE,
  X_DISCONTINUED_DT in DATE,
  X_EFTSU in NUMBER,
  X_WEFTSU in NUMBER,
  X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
  X_GOVT_REPORTABLE_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_EN_ST_SNAPSHOT
      where ESS_ID = X_ESS_ID;

Line: 410


    X_LAST_UPDATE_DATE DATE;

Line: 411


    X_LAST_UPDATED_BY NUMBER;

Line: 412


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 416


    X_PROGRAM_UPDATE_DATE DATE;

Line: 418


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 420


    X_LAST_UPDATED_BY := 1;

Line: 421


    X_LAST_UPDATE_LOGIN := 0;

Line: 423


     X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 424


      if X_LAST_UPDATED_BY is NULL then
         X_LAST_UPDATED_BY := -1;

Line: 427


     X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 428


     if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 440


	 x_program_update_date := NULL;

Line: 442


	 x_program_update_date := SYSDATE;

Line: 451


      SELECT   IGS_EN_ST_SNAPSHOT_ESS_ID_S.Nextval
      INTO     X_ESS_ID
      FROM     DUAL;

Line: 456


  p_action=>'INSERT',
  x_rowid=>X_ROWID,
  x_attendance_mode=>X_ATTENDANCE_MODE,
  x_attendance_type=>X_ATTENDANCE_TYPE,
  x_ci_cal_type=>X_CI_CAL_TYPE,
  x_ci_sequence_number=>X_CI_SEQUENCE_NUMBER,
  x_commencing_student_ind=>X_COMMENCING_STUDENT_IND,
  x_course_cd=>X_COURSE_CD,
  x_course_type=>X_COURSE_TYPE,
  x_course_type_group_cd=>X_COURSE_TYPE_GROUP_CD,
  x_crv_org_unit_cd=>X_CRV_ORG_UNIT_CD,
  x_crv_ou_start_dt=>X_CRV_OU_START_DT,
  x_crv_version_number=>X_CRV_VERSION_NUMBER,
  x_discipline_group_cd=>X_DISCIPLINE_GROUP_CD,
  x_discontinued_dt=>X_DISCONTINUED_DT,
  x_eftsu=>X_EFTSU,
  x_enrolled_dt=>X_ENROLLED_DT,
  x_funding_source=>X_FUNDING_SOURCE,
  x_govt_attendance_mode=>X_GOVT_ATTENDANCE_MODE,
  x_govt_attendance_type=>X_GOVT_ATTENDANCE_TYPE,
  x_govt_course_type=>X_GOVT_COURSE_TYPE,
  x_govt_discipline_group_cd=>X_GOVT_DISCIPLINE_GROUP_CD,
  x_govt_funding_source=>X_GOVT_FUNDING_SOURCE,
  x_govt_reportable_ind=>X_GOVT_REPORTABLE_IND,
  x_major_course=>X_MAJOR_COURSE,
  x_new_to_higher_education=>X_NEW_TO_HIGHER_EDUCATION,
  x_person_id=>X_PERSON_ID,
  x_sca_location_cd=>X_SCA_LOCATION_CD,
  x_school_leaver=>X_SCHOOL_LEAVER,
  x_ESS_ID=>X_ESS_ID,
  x_snapshot_dt_time=>X_SNAPSHOT_DT_TIME,
  x_sua_cal_type=>X_SUA_CAL_TYPE,
  x_sua_ci_sequence_number=>X_SUA_CI_SEQUENCE_NUMBER,
  x_sua_location_cd=>X_SUA_LOCATION_CD,
  x_tr_org_unit_cd=>X_TR_ORG_UNIT_CD,
  x_tr_ou_start_dt=>X_TR_OU_START_DT,
  x_unit_cd=>X_UNIT_CD,
  x_unit_class=>X_UNIT_CLASS,
  x_unit_int_course_level_cd=>X_UNIT_INT_COURSE_LEVEL_CD,
  x_unit_level=>X_UNIT_LEVEL,
  x_uv_version_number=>X_UV_VERSION_NUMBER,
  x_weftsu=>X_WEFTSU,
  x_creation_date=>X_LAST_UPDATE_DATE,
  x_created_by=>X_LAST_UPDATED_BY,
  x_last_update_date=>X_LAST_UPDATE_DATE,
  x_last_updated_by=>X_LAST_UPDATED_BY,
  x_last_update_login=>X_LAST_UPDATE_LOGIN
  );

Line: 505


  insert into IGS_EN_ST_SNAPSHOT (
    ESS_ID,
    SNAPSHOT_DT_TIME,
    CI_CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    PERSON_ID,
    COURSE_CD,
    CRV_VERSION_NUMBER,
    UNIT_CD,
    UV_VERSION_NUMBER,
    SUA_CAL_TYPE,
    SUA_CI_SEQUENCE_NUMBER,
    TR_ORG_UNIT_CD,
    TR_OU_START_DT,
    DISCIPLINE_GROUP_CD,
    GOVT_DISCIPLINE_GROUP_CD,
    CRV_ORG_UNIT_CD,
    CRV_OU_START_DT,
    COURSE_TYPE,
    GOVT_COURSE_TYPE,
    COURSE_TYPE_GROUP_CD,
    SCA_LOCATION_CD,
    ATTENDANCE_MODE,
    GOVT_ATTENDANCE_MODE,
    ATTENDANCE_TYPE,
    GOVT_ATTENDANCE_TYPE,
    FUNDING_SOURCE,
    GOVT_FUNDING_SOURCE,
    MAJOR_COURSE,
    COMMENCING_STUDENT_IND,
    SCHOOL_LEAVER,
    NEW_TO_HIGHER_EDUCATION,
    SUA_LOCATION_CD,
    UNIT_CLASS,
    UNIT_LEVEL,
    ENROLLED_DT,
    DISCONTINUED_DT,
    EFTSU,
    WEFTSU,
    UNIT_INT_COURSE_LEVEL_CD,
    GOVT_REPORTABLE_IND,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE
  ) values (
    new_references.ESS_ID,
    new_references.SNAPSHOT_DT_TIME,
    new_references.CI_CAL_TYPE,
    new_references.CI_SEQUENCE_NUMBER,
    new_references.PERSON_ID,
    new_references.COURSE_CD,
    new_references.CRV_VERSION_NUMBER,
    new_references.UNIT_CD,
    new_references.UV_VERSION_NUMBER,
    new_references.SUA_CAL_TYPE,
    new_references.SUA_CI_SEQUENCE_NUMBER,
    new_references.TR_ORG_UNIT_CD,
    new_references.TR_OU_START_DT,
    new_references.DISCIPLINE_GROUP_CD,
    new_references.GOVT_DISCIPLINE_GROUP_CD,
    new_references.CRV_ORG_UNIT_CD,
    new_references.CRV_OU_START_DT,
    new_references.COURSE_TYPE,
    new_references.GOVT_COURSE_TYPE,
    new_references.COURSE_TYPE_GROUP_CD,
    new_references.SCA_LOCATION_CD,
    new_references.ATTENDANCE_MODE,
    new_references.GOVT_ATTENDANCE_MODE,
    new_references.ATTENDANCE_TYPE,
    new_references.GOVT_ATTENDANCE_TYPE,
    new_references.FUNDING_SOURCE,
    new_references.GOVT_FUNDING_SOURCE,
    new_references.MAJOR_COURSE,
    new_references.COMMENCING_STUDENT_IND,
    new_references.SCHOOL_LEAVER,
    new_references.NEW_TO_HIGHER_EDUCATION,
    new_references.SUA_LOCATION_CD,
    new_references.UNIT_CLASS,
    new_references.UNIT_LEVEL,
    new_references.ENROLLED_DT,
    new_references.DISCONTINUED_DT,
    new_references.EFTSU,
    new_references.WEFTSU,
    new_references.UNIT_INT_COURSE_LEVEL_CD,
    new_references.GOVT_REPORTABLE_IND,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REQUEST_ID,
    X_PROGRAM_ID,
    X_PROGRAM_APPLICATION_ID,
    X_PROGRAM_UPDATE_DATE
  );

Line: 615


    p_action => 'INSERT',
    x_rowid => X_ROWID
  );

Line: 618


end INSERT_ROW;

Line: 663


  cursor c1 is select
      SNAPSHOT_DT_TIME,
      CI_CAL_TYPE,
      CI_SEQUENCE_NUMBER,
      PERSON_ID,
      COURSE_CD,
      CRV_VERSION_NUMBER,
      UNIT_CD,
      UV_VERSION_NUMBER,
      SUA_CAL_TYPE,
      SUA_CI_SEQUENCE_NUMBER,
      TR_ORG_UNIT_CD,
      TR_OU_START_DT,
      DISCIPLINE_GROUP_CD,
      GOVT_DISCIPLINE_GROUP_CD,
      CRV_ORG_UNIT_CD,
      CRV_OU_START_DT,
      COURSE_TYPE,
      GOVT_COURSE_TYPE,
      COURSE_TYPE_GROUP_CD,
      SCA_LOCATION_CD,
      ATTENDANCE_MODE,
      GOVT_ATTENDANCE_MODE,
      ATTENDANCE_TYPE,
      GOVT_ATTENDANCE_TYPE,
      FUNDING_SOURCE,
      GOVT_FUNDING_SOURCE,
      MAJOR_COURSE,
      COMMENCING_STUDENT_IND,
      SCHOOL_LEAVER,
      NEW_TO_HIGHER_EDUCATION,
      SUA_LOCATION_CD,
      UNIT_CLASS,
      UNIT_LEVEL,
      ENROLLED_DT,
      DISCONTINUED_DT,
      EFTSU,
      WEFTSU,
      UNIT_INT_COURSE_LEVEL_CD,
      GOVT_REPORTABLE_IND
    from IGS_EN_ST_SNAPSHOT
    where rowid = x_rowid for update nowait;

Line: 711


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 782


procedure UPDATE_ROW (
  x_rowid IN VARCHAR2,
  X_ESS_ID in NUMBER,
  X_SNAPSHOT_DT_TIME in DATE,
  X_CI_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_PERSON_ID in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_CRV_VERSION_NUMBER in NUMBER,
  X_UNIT_CD in VARCHAR2,
  X_UV_VERSION_NUMBER in NUMBER,
  X_SUA_CAL_TYPE in VARCHAR2,
  X_SUA_CI_SEQUENCE_NUMBER in NUMBER,
  X_TR_ORG_UNIT_CD in VARCHAR2,
  X_TR_OU_START_DT in DATE,
  X_DISCIPLINE_GROUP_CD in VARCHAR2,
  X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
  X_CRV_ORG_UNIT_CD in VARCHAR2,
  X_CRV_OU_START_DT in DATE,
  X_COURSE_TYPE in VARCHAR2,
  X_GOVT_COURSE_TYPE in NUMBER,
  X_COURSE_TYPE_GROUP_CD in VARCHAR2,
  X_SCA_LOCATION_CD in VARCHAR2,
  X_ATTENDANCE_MODE in VARCHAR2,
  X_GOVT_ATTENDANCE_MODE in VARCHAR2,
  X_ATTENDANCE_TYPE in VARCHAR2,
  X_GOVT_ATTENDANCE_TYPE in VARCHAR2,
  X_FUNDING_SOURCE in VARCHAR2,
  X_GOVT_FUNDING_SOURCE in NUMBER,
  X_MAJOR_COURSE in NUMBER,
  X_COMMENCING_STUDENT_IND in VARCHAR2,
  X_SCHOOL_LEAVER in NUMBER,
  X_NEW_TO_HIGHER_EDUCATION in NUMBER,
  X_SUA_LOCATION_CD in VARCHAR2,
  X_UNIT_CLASS in VARCHAR2,
  X_UNIT_LEVEL in VARCHAR2,
  X_ENROLLED_DT in DATE,
  X_DISCONTINUED_DT in DATE,
  X_EFTSU in NUMBER,
  X_WEFTSU in NUMBER,
  X_UNIT_INT_COURSE_LEVEL_CD in VARCHAR2,
  X_GOVT_REPORTABLE_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 827


    X_LAST_UPDATED_BY NUMBER;

Line: 828


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 832


    X_PROGRAM_UPDATE_DATE DATE;

Line: 834


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 836


    X_LAST_UPDATED_BY := 1;

Line: 837


    X_LAST_UPDATE_LOGIN := 0;

Line: 839


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 840


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 843


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 844


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 854


  p_action=>'UPDATE',
  x_rowid=>X_ROWID,
  x_attendance_mode=>X_ATTENDANCE_MODE,
  x_attendance_type=>X_ATTENDANCE_TYPE,
  x_ci_cal_type=>X_CI_CAL_TYPE,
  x_ci_sequence_number=>X_CI_SEQUENCE_NUMBER,
  x_commencing_student_ind=>X_COMMENCING_STUDENT_IND,
  x_course_cd=>X_COURSE_CD,
  x_course_type=>X_COURSE_TYPE,
  x_course_type_group_cd=>X_COURSE_TYPE_GROUP_CD,
  x_crv_org_unit_cd=>X_CRV_ORG_UNIT_CD,
  x_crv_ou_start_dt=>X_CRV_OU_START_DT,
  x_crv_version_number=>X_CRV_VERSION_NUMBER,
  x_discipline_group_cd=>X_DISCIPLINE_GROUP_CD,
  x_discontinued_dt=>X_DISCONTINUED_DT,
  x_eftsu=>X_EFTSU,
  x_enrolled_dt=>X_ENROLLED_DT,
  x_funding_source=>X_FUNDING_SOURCE,
  x_govt_attendance_mode=>X_GOVT_ATTENDANCE_MODE,
  x_govt_attendance_type=>X_GOVT_ATTENDANCE_TYPE,
  x_govt_course_type=>X_GOVT_COURSE_TYPE,
  x_govt_discipline_group_cd=>X_GOVT_DISCIPLINE_GROUP_CD,
  x_govt_funding_source=>X_GOVT_FUNDING_SOURCE,
  x_govt_reportable_ind=>X_GOVT_REPORTABLE_IND,
  x_major_course=>X_MAJOR_COURSE,
  x_new_to_higher_education=>X_NEW_TO_HIGHER_EDUCATION,
  x_person_id=>X_PERSON_ID,
  x_sca_location_cd=>X_SCA_LOCATION_CD,
  x_school_leaver=>X_SCHOOL_LEAVER,
  x_ESS_ID=>X_ESS_ID,
  x_snapshot_dt_time=>X_SNAPSHOT_DT_TIME,
  x_sua_cal_type=>X_SUA_CAL_TYPE,
  x_sua_ci_sequence_number=>X_SUA_CI_SEQUENCE_NUMBER,
  x_sua_location_cd=>X_SUA_LOCATION_CD,
  x_tr_org_unit_cd=>X_TR_ORG_UNIT_CD,
  x_tr_ou_start_dt=>X_TR_OU_START_DT,
  x_unit_cd=>X_UNIT_CD,
  x_unit_class=>X_UNIT_CLASS,
  x_unit_int_course_level_cd=>X_UNIT_INT_COURSE_LEVEL_CD,
  x_unit_level=>X_UNIT_LEVEL,
  x_uv_version_number=>X_UV_VERSION_NUMBER,
  x_weftsu=>X_WEFTSU,
  x_creation_date=>X_LAST_UPDATE_DATE,
  x_created_by=>X_LAST_UPDATED_BY,
  x_last_update_date=>X_LAST_UPDATE_DATE,
  x_last_updated_by=>X_LAST_UPDATED_BY,
  x_last_update_login=>X_LAST_UPDATE_LOGIN
  );

Line: 914


       		X_PROGRAM_UPDATE_DATE :=
        	    OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 917


	 x_program_update_date := SYSDATE;

Line: 921


  update IGS_EN_ST_SNAPSHOT set
    SNAPSHOT_DT_TIME = new_references.SNAPSHOT_DT_TIME,
    CI_CAL_TYPE = new_references.CI_CAL_TYPE,
    CI_SEQUENCE_NUMBER = new_references.CI_SEQUENCE_NUMBER,
    PERSON_ID = new_references.PERSON_ID,
    COURSE_CD = new_references.COURSE_CD,
    CRV_VERSION_NUMBER = new_references.CRV_VERSION_NUMBER,
    UNIT_CD = new_references.UNIT_CD,
    UV_VERSION_NUMBER = new_references.UV_VERSION_NUMBER,
    SUA_CAL_TYPE = new_references.SUA_CAL_TYPE,
    SUA_CI_SEQUENCE_NUMBER = new_references.SUA_CI_SEQUENCE_NUMBER,
    TR_ORG_UNIT_CD = new_references.TR_ORG_UNIT_CD,
    TR_OU_START_DT = new_references.TR_OU_START_DT,
    DISCIPLINE_GROUP_CD = new_references.DISCIPLINE_GROUP_CD,
    GOVT_DISCIPLINE_GROUP_CD = new_references.GOVT_DISCIPLINE_GROUP_CD,
    CRV_ORG_UNIT_CD = new_references.CRV_ORG_UNIT_CD,
    CRV_OU_START_DT = new_references.CRV_OU_START_DT,
    COURSE_TYPE = new_references.COURSE_TYPE,
    GOVT_COURSE_TYPE = new_references.GOVT_COURSE_TYPE,
    COURSE_TYPE_GROUP_CD = new_references.COURSE_TYPE_GROUP_CD,
    SCA_LOCATION_CD = new_references.SCA_LOCATION_CD,
    ATTENDANCE_MODE = new_references.ATTENDANCE_MODE,
    GOVT_ATTENDANCE_MODE = new_references.GOVT_ATTENDANCE_MODE,
    ATTENDANCE_TYPE = new_references.ATTENDANCE_TYPE,
    GOVT_ATTENDANCE_TYPE = new_references.GOVT_ATTENDANCE_TYPE,
    FUNDING_SOURCE = new_references.FUNDING_SOURCE,
    GOVT_FUNDING_SOURCE = new_references.GOVT_FUNDING_SOURCE,
    MAJOR_COURSE = new_references.MAJOR_COURSE,
    COMMENCING_STUDENT_IND = new_references.COMMENCING_STUDENT_IND,
    SCHOOL_LEAVER = new_references.SCHOOL_LEAVER,
    NEW_TO_HIGHER_EDUCATION = new_references.NEW_TO_HIGHER_EDUCATION,
    SUA_LOCATION_CD = new_references.SUA_LOCATION_CD,
    UNIT_CLASS = new_references.UNIT_CLASS,
    UNIT_LEVEL = new_references.UNIT_LEVEL,
    ENROLLED_DT = new_references.ENROLLED_DT,
    DISCONTINUED_DT = new_references.DISCONTINUED_DT,
    EFTSU = new_references.EFTSU,
    WEFTSU = new_references.WEFTSU,
    UNIT_INT_COURSE_LEVEL_CD = new_references.UNIT_INT_COURSE_LEVEL_CD,
    GOVT_REPORTABLE_IND = new_references.GOVT_REPORTABLE_IND,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    REQUEST_ID =  X_REQUEST_ID,
    PROGRAM_ID =  X_PROGRAM_ID,
    PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
  where ROWID = X_ROWID;

Line: 976


    p_action => 'UPDATE',
    x_rowid => X_ROWID
  );

Line: 980


end UPDATE_ROW;

Line: 1026


  cursor c1 is select rowid from IGS_EN_ST_SNAPSHOT
     where ESS_ID = X_ESS_ID;

Line: 1034


    INSERT_ROW (
     X_ROWID,
     X_ESS_ID,
     X_SNAPSHOT_DT_TIME,
     X_CI_CAL_TYPE,
     X_CI_SEQUENCE_NUMBER,
     X_PERSON_ID,
     X_COURSE_CD,
     X_CRV_VERSION_NUMBER,
     X_UNIT_CD,
     X_UV_VERSION_NUMBER,
     X_SUA_CAL_TYPE,
     X_SUA_CI_SEQUENCE_NUMBER,
     X_TR_ORG_UNIT_CD,
     X_TR_OU_START_DT,
     X_DISCIPLINE_GROUP_CD,
     X_GOVT_DISCIPLINE_GROUP_CD,
     X_CRV_ORG_UNIT_CD,
     X_CRV_OU_START_DT,
     X_COURSE_TYPE,
     X_GOVT_COURSE_TYPE,
     X_COURSE_TYPE_GROUP_CD,
     X_SCA_LOCATION_CD,
     X_ATTENDANCE_MODE,
     X_GOVT_ATTENDANCE_MODE,
     X_ATTENDANCE_TYPE,
     X_GOVT_ATTENDANCE_TYPE,
     X_FUNDING_SOURCE,
     X_GOVT_FUNDING_SOURCE,
     X_MAJOR_COURSE,
     X_COMMENCING_STUDENT_IND,
     X_SCHOOL_LEAVER,
     X_NEW_TO_HIGHER_EDUCATION,
     X_SUA_LOCATION_CD,
     X_UNIT_CLASS,
     X_UNIT_LEVEL,
     X_ENROLLED_DT,
     X_DISCONTINUED_DT,
     X_EFTSU,
     X_WEFTSU,
     X_UNIT_INT_COURSE_LEVEL_CD,
     X_GOVT_REPORTABLE_IND,
     X_MODE);

Line: 1080


  UPDATE_ROW (
   X_ROWID,
   X_ESS_ID,
   X_SNAPSHOT_DT_TIME,
   X_CI_CAL_TYPE,
   X_CI_SEQUENCE_NUMBER,
   X_PERSON_ID,
   X_COURSE_CD,
   X_CRV_VERSION_NUMBER,
   X_UNIT_CD,
   X_UV_VERSION_NUMBER,
   X_SUA_CAL_TYPE,
   X_SUA_CI_SEQUENCE_NUMBER,
   X_TR_ORG_UNIT_CD,
   X_TR_OU_START_DT,
   X_DISCIPLINE_GROUP_CD,
   X_GOVT_DISCIPLINE_GROUP_CD,
   X_CRV_ORG_UNIT_CD,
   X_CRV_OU_START_DT,
   X_COURSE_TYPE,
   X_GOVT_COURSE_TYPE,
   X_COURSE_TYPE_GROUP_CD,
   X_SCA_LOCATION_CD,
   X_ATTENDANCE_MODE,
   X_GOVT_ATTENDANCE_MODE,
   X_ATTENDANCE_TYPE,
   X_GOVT_ATTENDANCE_TYPE,
   X_FUNDING_SOURCE,
   X_GOVT_FUNDING_SOURCE,
   X_MAJOR_COURSE,
   X_COMMENCING_STUDENT_IND,
   X_SCHOOL_LEAVER,
   X_NEW_TO_HIGHER_EDUCATION,
   X_SUA_LOCATION_CD,
   X_UNIT_CLASS,
   X_UNIT_LEVEL,
   X_ENROLLED_DT,
   X_DISCONTINUED_DT,
   X_EFTSU,
   X_WEFTSU,
   X_UNIT_INT_COURSE_LEVEL_CD,
   X_GOVT_REPORTABLE_IND,
   X_MODE);

Line: 1125


procedure DELETE_ROW (X_ROWID IN VARCHAR2
) AS
begin
 Before_DML(
    p_action => 'DELETE',
    x_rowid => X_ROWID
  );

Line: 1132


  delete from IGS_EN_ST_SNAPSHOT
  where ROWID = X_ROWID;

Line: 1139


    p_action => 'DELETE',
    x_rowid => X_ROWID
  );

Line: 1143


end DELETE_ROW;