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.

APPS.IGS_PR_STU_OU_HIST_PKG SQL Statements

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

Line: 48


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

  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

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

Line: 78


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Close cur_old_ref_values;

Line: 80


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

Line: 124


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

Line: 131


    new_references.last_update_date := x_last_update_date;

Line: 132


    new_references.last_updated_by := x_last_updated_by;

Line: 133


    new_references.last_update_login := x_last_update_login;

Line: 303


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

Line: 329


      SELECT   rowid
      FROM     igs_pr_stu_ou_hist_all
      WHERE    person_id = x_person_id
      AND      course_cd = x_course_cd
      AND      sequence_number = x_sequence_number
      AND      hist_start_dt = x_hist_start_dt
      FOR UPDATE NOWAIT;

Line: 370


      SELECT   rowid
      FROM     igs_pr_stu_ou_hist_all
      WHERE    person_id = x_person_id
      AND      course_cd = x_course_cd
      AND      sequence_number = x_sequence_number ;

Line: 434


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_org_id IN NUMBER DEFAULT NULL
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_person_id,
      x_course_cd,
      x_sequence_number,
      x_hist_start_dt,
      x_appeal_comments,
      x_appeal_dt,
      x_appeal_expiry_dt,
      x_appeal_outcome_dt,
      x_appeal_outcome_type,
      x_applied_dt,
      x_comments,
      x_decision_dt,
      x_decision_org_unit_cd,
      x_decision_ou_start_dt,
      x_decision_status,
      x_duration,
      x_duration_type,
      x_encmb_course_group_cd,
      x_expiry_dt,
      x_hist_end_dt,
      x_hist_who,
      x_pra_sequence_number,
      x_prg_cal_type,
      x_prg_ci_sequence_number,
      x_progression_outcome_type,
      x_progression_rule_cat,
      x_pro_pra_sequence_number,
      x_pro_sequence_number,
      x_restricted_attendance_type,
      x_restricted_enrolment_cp,
      x_rule_check_dt,
      x_show_cause_comments,
      x_show_cause_dt,
      x_show_cause_expiry_dt,
      x_show_cause_outcome_dt,
      x_show_cause_outcome_type,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_org_id
    );

Line: 499


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

Line: 513


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

Line: 518


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

Line: 521


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	 -- Call all the procedures related to Before Insert.
      IF Get_PK_For_Validation (
    		new_references.person_id,
    		new_references.course_cd,
    		new_references.sequence_number,
    		new_references.hist_start_dt)  THEN
	       Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

Line: 533


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Constraints;

Line: 535


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;

Line: 560


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

Line: 563


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

Line: 566


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

Line: 573


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_PERSON_ID IN NUMBER,
       x_COURSE_CD IN VARCHAR2,
       x_SEQUENCE_NUMBER IN NUMBER,
       x_HIST_START_DT IN DATE,
       x_APPEAL_COMMENTS IN VARCHAR2,
       x_APPEAL_DT IN DATE,
       x_APPEAL_EXPIRY_DT IN DATE,
       x_APPEAL_OUTCOME_DT IN DATE,
       x_APPEAL_OUTCOME_TYPE IN VARCHAR2,
       x_APPLIED_DT IN DATE,
       x_COMMENTS IN VARCHAR2,
       x_DECISION_DT IN DATE,
       x_DECISION_ORG_UNIT_CD IN VARCHAR2,
       x_DECISION_OU_START_DT IN DATE,
       x_DECISION_STATUS IN VARCHAR2,
       x_DURATION IN NUMBER,
       x_DURATION_TYPE IN VARCHAR2,
       x_ENCMB_COURSE_GROUP_CD IN VARCHAR2,
       x_EXPIRY_DT IN DATE,
       x_HIST_END_DT IN DATE,
       x_HIST_WHO IN VARCHAR2,
       x_PRA_SEQUENCE_NUMBER IN NUMBER,
       x_PRG_CAL_TYPE IN VARCHAR2,
       x_PRG_CI_SEQUENCE_NUMBER IN NUMBER,
       x_PROGRESSION_OUTCOME_TYPE IN VARCHAR2,
       x_PROGRESSION_RULE_CAT IN VARCHAR2,
       x_PRO_PRA_SEQUENCE_NUMBER IN NUMBER,
       x_PRO_SEQUENCE_NUMBER IN NUMBER,
       x_RESTRICTED_ATTENDANCE_TYPE IN VARCHAR2,
       x_RESTRICTED_ENROLMENT_CP IN NUMBER,
       x_RULE_CHECK_DT IN DATE,
       x_SHOW_CAUSE_COMMENTS IN VARCHAR2,
       x_SHOW_CAUSE_DT IN DATE,
       x_SHOW_CAUSE_EXPIRY_DT IN DATE,
       x_SHOW_CAUSE_OUTCOME_DT IN DATE,
       x_SHOW_CAUSE_OUTCOME_TYPE IN DATE,
      X_MODE in VARCHAR2 default 'R',
       X_ORG_ID IN NUMBER
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

    cursor C is select ROWID from IGS_PR_STU_OU_HIST_ALL
             where                 PERSON_ID= X_PERSON_ID
            and COURSE_CD = X_COURSE_CD
            and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
            and HIST_START_DT = X_HIST_START_DT
;

Line: 631


     X_LAST_UPDATE_DATE DATE ;

Line: 632


     X_LAST_UPDATED_BY NUMBER ;

Line: 633


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 635


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 637


        X_LAST_UPDATED_BY := 1;

Line: 638


        X_LAST_UPDATE_LOGIN := 0;

Line: 640


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 641


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 644


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 645


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 654


 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_person_id=>X_PERSON_ID,
 	       x_course_cd=>X_COURSE_CD,
 	       x_sequence_number=>X_SEQUENCE_NUMBER,
 	       x_hist_start_dt=>X_HIST_START_DT,
 	       x_appeal_comments=>X_APPEAL_COMMENTS,
 	       x_appeal_dt=>X_APPEAL_DT,
 	       x_appeal_expiry_dt=>X_APPEAL_EXPIRY_DT,
 	       x_appeal_outcome_dt=>X_APPEAL_OUTCOME_DT,
 	       x_appeal_outcome_type=>X_APPEAL_OUTCOME_TYPE,
 	       x_applied_dt=>X_APPLIED_DT,
 	       x_comments=>X_COMMENTS,
 	       x_decision_dt=>X_DECISION_DT,
 	       x_decision_org_unit_cd=>X_DECISION_ORG_UNIT_CD,
 	       x_decision_ou_start_dt=>X_DECISION_OU_START_DT,
 	       x_decision_status=>X_DECISION_STATUS,
 	       x_duration=>X_DURATION,
 	       x_duration_type=>X_DURATION_TYPE,
 	       x_encmb_course_group_cd=>X_ENCMB_COURSE_GROUP_CD,
 	       x_expiry_dt=>X_EXPIRY_DT,
 	       x_hist_end_dt=>X_HIST_END_DT,
 	       x_hist_who=>X_HIST_WHO,
 	       x_pra_sequence_number=>X_PRA_SEQUENCE_NUMBER,
 	       x_prg_cal_type=>X_PRG_CAL_TYPE,
 	       x_prg_ci_sequence_number=>X_PRG_CI_SEQUENCE_NUMBER,
 	       x_progression_outcome_type=>X_PROGRESSION_OUTCOME_TYPE,
 	       x_progression_rule_cat=>X_PROGRESSION_RULE_CAT,
 	       x_pro_pra_sequence_number=>X_PRO_PRA_SEQUENCE_NUMBER,
 	       x_pro_sequence_number=>X_PRO_SEQUENCE_NUMBER,
 	       x_restricted_attendance_type=>X_RESTRICTED_ATTENDANCE_TYPE,
 	       x_restricted_enrolment_cp=>X_RESTRICTED_ENROLMENT_CP,
 	       x_rule_check_dt=>X_RULE_CHECK_DT,
 	       x_show_cause_comments=>X_SHOW_CAUSE_COMMENTS,
 	       x_show_cause_dt=>X_SHOW_CAUSE_DT,
 	       x_show_cause_expiry_dt=>X_SHOW_CAUSE_EXPIRY_DT,
 	       x_show_cause_outcome_dt=>X_SHOW_CAUSE_OUTCOME_DT,
 	       x_show_cause_outcome_type=>X_SHOW_CAUSE_OUTCOME_TYPE,
	       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,
	       x_org_id=>igs_ge_gen_003.get_org_id);

Line: 698


     insert into IGS_PR_STU_OU_HIST_ALL (
		PERSON_ID
		,COURSE_CD
		,SEQUENCE_NUMBER
		,HIST_START_DT
		,APPEAL_COMMENTS
		,APPEAL_DT
		,APPEAL_EXPIRY_DT
		,APPEAL_OUTCOME_DT
		,APPEAL_OUTCOME_TYPE
		,APPLIED_DT
		,COMMENTS
		,DECISION_DT
		,DECISION_ORG_UNIT_CD
		,DECISION_OU_START_DT
		,DECISION_STATUS
		,DURATION
		,DURATION_TYPE
		,ENCMB_COURSE_GROUP_CD
		,EXPIRY_DT
		,HIST_END_DT
		,HIST_WHO
		,PRA_SEQUENCE_NUMBER
		,PRG_CAL_TYPE
		,PRG_CI_SEQUENCE_NUMBER
		,PROGRESSION_OUTCOME_TYPE
		,PROGRESSION_RULE_CAT
		,PRO_PRA_SEQUENCE_NUMBER
		,PRO_SEQUENCE_NUMBER
		,RESTRICTED_ATTENDANCE_TYPE
		,RESTRICTED_ENROLMENT_CP
		,RULE_CHECK_DT
		,SHOW_CAUSE_COMMENTS
		,SHOW_CAUSE_DT
		,SHOW_CAUSE_EXPIRY_DT
		,SHOW_CAUSE_OUTCOME_DT
		,SHOW_CAUSE_OUTCOME_TYPE
	        ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
		,ORG_ID
        ) values  (
	        NEW_REFERENCES.PERSON_ID
	        ,NEW_REFERENCES.COURSE_CD
	        ,NEW_REFERENCES.SEQUENCE_NUMBER
	        ,NEW_REFERENCES.HIST_START_DT
	        ,NEW_REFERENCES.APPEAL_COMMENTS
	        ,NEW_REFERENCES.APPEAL_DT
	        ,NEW_REFERENCES.APPEAL_EXPIRY_DT
	        ,NEW_REFERENCES.APPEAL_OUTCOME_DT
	        ,NEW_REFERENCES.APPEAL_OUTCOME_TYPE
	        ,NEW_REFERENCES.APPLIED_DT
	        ,NEW_REFERENCES.COMMENTS
	        ,NEW_REFERENCES.DECISION_DT
	        ,NEW_REFERENCES.DECISION_ORG_UNIT_CD
	        ,NEW_REFERENCES.DECISION_OU_START_DT
	        ,NEW_REFERENCES.DECISION_STATUS
	        ,NEW_REFERENCES.DURATION
	        ,NEW_REFERENCES.DURATION_TYPE
	        ,NEW_REFERENCES.ENCMB_COURSE_GROUP_CD
	        ,NEW_REFERENCES.EXPIRY_DT
	        ,NEW_REFERENCES.HIST_END_DT
	        ,NEW_REFERENCES.HIST_WHO
	        ,NEW_REFERENCES.PRA_SEQUENCE_NUMBER
	        ,NEW_REFERENCES.PRG_CAL_TYPE
	        ,NEW_REFERENCES.PRG_CI_SEQUENCE_NUMBER
	        ,NEW_REFERENCES.PROGRESSION_OUTCOME_TYPE
	        ,NEW_REFERENCES.PROGRESSION_RULE_CAT
	        ,NEW_REFERENCES.PRO_PRA_SEQUENCE_NUMBER
	        ,NEW_REFERENCES.PRO_SEQUENCE_NUMBER
	        ,NEW_REFERENCES.RESTRICTED_ATTENDANCE_TYPE
	        ,NEW_REFERENCES.RESTRICTED_ENROLMENT_CP
	        ,NEW_REFERENCES.RULE_CHECK_DT
	        ,NEW_REFERENCES.SHOW_CAUSE_COMMENTS
	        ,NEW_REFERENCES.SHOW_CAUSE_DT
	        ,NEW_REFERENCES.SHOW_CAUSE_EXPIRY_DT
	        ,NEW_REFERENCES.SHOW_CAUSE_OUTCOME_DT
	        ,NEW_REFERENCES.SHOW_CAUSE_OUTCOME_TYPE
	        ,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_LOGIN
		,NEW_REFERENCES.ORG_ID
);

Line: 793


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

Line: 795


end INSERT_ROW;

Line: 846


   cursor c1 is select
      APPEAL_COMMENTS
,      APPEAL_DT
,      APPEAL_EXPIRY_DT
,      APPEAL_OUTCOME_DT
,      APPEAL_OUTCOME_TYPE
,      APPLIED_DT
,      COMMENTS
,      DECISION_DT
,      DECISION_ORG_UNIT_CD
,      DECISION_OU_START_DT
,      DECISION_STATUS
,      DURATION
,      DURATION_TYPE
,      ENCMB_COURSE_GROUP_CD
,      EXPIRY_DT
,      HIST_END_DT
,      HIST_WHO
,      PRA_SEQUENCE_NUMBER
,      PRG_CAL_TYPE
,      PRG_CI_SEQUENCE_NUMBER
,      PROGRESSION_OUTCOME_TYPE
,      PROGRESSION_RULE_CAT
,      PRO_PRA_SEQUENCE_NUMBER
,      PRO_SEQUENCE_NUMBER
,      RESTRICTED_ATTENDANCE_TYPE
,      RESTRICTED_ENROLMENT_CP
,      RULE_CHECK_DT
,      SHOW_CAUSE_COMMENTS
,      SHOW_CAUSE_DT
,      SHOW_CAUSE_EXPIRY_DT
,      SHOW_CAUSE_OUTCOME_DT
,      SHOW_CAUSE_OUTCOME_TYPE
    from IGS_PR_STU_OU_HIST_ALL
    where ROWID = X_ROWID
    for update nowait;

Line: 887


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

Line: 995


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_PERSON_ID IN NUMBER,
       x_COURSE_CD IN VARCHAR2,
       x_SEQUENCE_NUMBER IN NUMBER,
       x_HIST_START_DT IN DATE,
       x_APPEAL_COMMENTS IN VARCHAR2,
       x_APPEAL_DT IN DATE,
       x_APPEAL_EXPIRY_DT IN DATE,
       x_APPEAL_OUTCOME_DT IN DATE,
       x_APPEAL_OUTCOME_TYPE IN VARCHAR2,
       x_APPLIED_DT IN DATE,
       x_COMMENTS IN VARCHAR2,
       x_DECISION_DT IN DATE,
       x_DECISION_ORG_UNIT_CD IN VARCHAR2,
       x_DECISION_OU_START_DT IN DATE,
       x_DECISION_STATUS IN VARCHAR2,
       x_DURATION IN NUMBER,
       x_DURATION_TYPE IN VARCHAR2,
       x_ENCMB_COURSE_GROUP_CD IN VARCHAR2,
       x_EXPIRY_DT IN DATE,
       x_HIST_END_DT IN DATE,
       x_HIST_WHO IN VARCHAR2,
       x_PRA_SEQUENCE_NUMBER IN NUMBER,
       x_PRG_CAL_TYPE IN VARCHAR2,
       x_PRG_CI_SEQUENCE_NUMBER IN NUMBER,
       x_PROGRESSION_OUTCOME_TYPE IN VARCHAR2,
       x_PROGRESSION_RULE_CAT IN VARCHAR2,
       x_PRO_PRA_SEQUENCE_NUMBER IN NUMBER,
       x_PRO_SEQUENCE_NUMBER IN NUMBER,
       x_RESTRICTED_ATTENDANCE_TYPE IN VARCHAR2,
       x_RESTRICTED_ENROLMENT_CP IN NUMBER,
       x_RULE_CHECK_DT IN DATE,
       x_SHOW_CAUSE_COMMENTS IN VARCHAR2,
       x_SHOW_CAUSE_DT IN DATE,
       x_SHOW_CAUSE_EXPIRY_DT IN DATE,
       x_SHOW_CAUSE_OUTCOME_DT IN DATE,
       x_SHOW_CAUSE_OUTCOME_TYPE IN DATE,
      X_MODE in VARCHAR2 default 'R'
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

     X_LAST_UPDATE_DATE DATE ;

Line: 1047


     X_LAST_UPDATED_BY NUMBER ;

Line: 1048


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 1050


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 1052


        X_LAST_UPDATED_BY := 1;

Line: 1053


        X_LAST_UPDATE_LOGIN := 0;

Line: 1055


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1056


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 1059


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 1060


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 1069


 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_person_id=>X_PERSON_ID,
 	       x_course_cd=>X_COURSE_CD,
 	       x_sequence_number=>X_SEQUENCE_NUMBER,
 	       x_hist_start_dt=>X_HIST_START_DT,
 	       x_appeal_comments=>X_APPEAL_COMMENTS,
 	       x_appeal_dt=>X_APPEAL_DT,
 	       x_appeal_expiry_dt=>X_APPEAL_EXPIRY_DT,
 	       x_appeal_outcome_dt=>X_APPEAL_OUTCOME_DT,
 	       x_appeal_outcome_type=>X_APPEAL_OUTCOME_TYPE,
 	       x_applied_dt=>X_APPLIED_DT,
 	       x_comments=>X_COMMENTS,
 	       x_decision_dt=>X_DECISION_DT,
 	       x_decision_org_unit_cd=>X_DECISION_ORG_UNIT_CD,
 	       x_decision_ou_start_dt=>X_DECISION_OU_START_DT,
 	       x_decision_status=>X_DECISION_STATUS,
 	       x_duration=>X_DURATION,
 	       x_duration_type=>X_DURATION_TYPE,
 	       x_encmb_course_group_cd=>X_ENCMB_COURSE_GROUP_CD,
 	       x_expiry_dt=>X_EXPIRY_DT,
 	       x_hist_end_dt=>X_HIST_END_DT,
 	       x_hist_who=>X_HIST_WHO,
 	       x_pra_sequence_number=>X_PRA_SEQUENCE_NUMBER,
 	       x_prg_cal_type=>X_PRG_CAL_TYPE,
 	       x_prg_ci_sequence_number=>X_PRG_CI_SEQUENCE_NUMBER,
 	       x_progression_outcome_type=>X_PROGRESSION_OUTCOME_TYPE,
 	       x_progression_rule_cat=>X_PROGRESSION_RULE_CAT,
 	       x_pro_pra_sequence_number=>X_PRO_PRA_SEQUENCE_NUMBER,
 	       x_pro_sequence_number=>X_PRO_SEQUENCE_NUMBER,
 	       x_restricted_attendance_type=>X_RESTRICTED_ATTENDANCE_TYPE,
 	       x_restricted_enrolment_cp=>X_RESTRICTED_ENROLMENT_CP,
 	       x_rule_check_dt=>X_RULE_CHECK_DT,
 	       x_show_cause_comments=>X_SHOW_CAUSE_COMMENTS,
 	       x_show_cause_dt=>X_SHOW_CAUSE_DT,
 	       x_show_cause_expiry_dt=>X_SHOW_CAUSE_EXPIRY_DT,
 	       x_show_cause_outcome_dt=>X_SHOW_CAUSE_OUTCOME_DT,
 	       x_show_cause_outcome_type=>X_SHOW_CAUSE_OUTCOME_TYPE,
	       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: 1112


   update IGS_PR_STU_OU_HIST_ALL set
      APPEAL_COMMENTS =  NEW_REFERENCES.APPEAL_COMMENTS,
      APPEAL_DT =  NEW_REFERENCES.APPEAL_DT,
      APPEAL_EXPIRY_DT =  NEW_REFERENCES.APPEAL_EXPIRY_DT,
      APPEAL_OUTCOME_DT =  NEW_REFERENCES.APPEAL_OUTCOME_DT,
      APPEAL_OUTCOME_TYPE =  NEW_REFERENCES.APPEAL_OUTCOME_TYPE,
      APPLIED_DT =  NEW_REFERENCES.APPLIED_DT,
      COMMENTS =  NEW_REFERENCES.COMMENTS,
      DECISION_DT =  NEW_REFERENCES.DECISION_DT,
      DECISION_ORG_UNIT_CD =  NEW_REFERENCES.DECISION_ORG_UNIT_CD,
      DECISION_OU_START_DT =  NEW_REFERENCES.DECISION_OU_START_DT,
      DECISION_STATUS =  NEW_REFERENCES.DECISION_STATUS,
      DURATION =  NEW_REFERENCES.DURATION,
      DURATION_TYPE =  NEW_REFERENCES.DURATION_TYPE,
      ENCMB_COURSE_GROUP_CD =  NEW_REFERENCES.ENCMB_COURSE_GROUP_CD,
      EXPIRY_DT =  NEW_REFERENCES.EXPIRY_DT,
      HIST_END_DT =  NEW_REFERENCES.HIST_END_DT,
      HIST_WHO =  NEW_REFERENCES.HIST_WHO,
      PRA_SEQUENCE_NUMBER =  NEW_REFERENCES.PRA_SEQUENCE_NUMBER,
      PRG_CAL_TYPE =  NEW_REFERENCES.PRG_CAL_TYPE,
      PRG_CI_SEQUENCE_NUMBER =  NEW_REFERENCES.PRG_CI_SEQUENCE_NUMBER,
      PROGRESSION_OUTCOME_TYPE =  NEW_REFERENCES.PROGRESSION_OUTCOME_TYPE,
      PROGRESSION_RULE_CAT =  NEW_REFERENCES.PROGRESSION_RULE_CAT,
      PRO_PRA_SEQUENCE_NUMBER =  NEW_REFERENCES.PRO_PRA_SEQUENCE_NUMBER,
      PRO_SEQUENCE_NUMBER =  NEW_REFERENCES.PRO_SEQUENCE_NUMBER,
      RESTRICTED_ATTENDANCE_TYPE =  NEW_REFERENCES.RESTRICTED_ATTENDANCE_TYPE,
      RESTRICTED_ENROLMENT_CP =  NEW_REFERENCES.RESTRICTED_ENROLMENT_CP,
      RULE_CHECK_DT =  NEW_REFERENCES.RULE_CHECK_DT,
      SHOW_CAUSE_COMMENTS =  NEW_REFERENCES.SHOW_CAUSE_COMMENTS,
      SHOW_CAUSE_DT =  NEW_REFERENCES.SHOW_CAUSE_DT,
      SHOW_CAUSE_EXPIRY_DT =  NEW_REFERENCES.SHOW_CAUSE_EXPIRY_DT,
      SHOW_CAUSE_OUTCOME_DT =  NEW_REFERENCES.SHOW_CAUSE_OUTCOME_DT,
      SHOW_CAUSE_OUTCOME_TYPE =  NEW_REFERENCES.SHOW_CAUSE_OUTCOME_TYPE,
	LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
	LAST_UPDATED_BY = X_LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
	  where ROWID = X_ROWID;

Line: 1154


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

Line: 1157


end UPDATE_ROW;

Line: 1210


    cursor c1 is select ROWID from IGS_PR_STU_OU_HIST_ALL
             where     PERSON_ID= X_PERSON_ID
            and COURSE_CD = X_COURSE_CD
            and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
            and HIST_START_DT = X_HIST_START_DT
;

Line: 1221


    INSERT_ROW (
      X_ROWID,
       X_PERSON_ID,
       X_COURSE_CD,
       X_SEQUENCE_NUMBER,
       X_HIST_START_DT,
       X_APPEAL_COMMENTS,
       X_APPEAL_DT,
       X_APPEAL_EXPIRY_DT,
       X_APPEAL_OUTCOME_DT,
       X_APPEAL_OUTCOME_TYPE,
       X_APPLIED_DT,
       X_COMMENTS,
       X_DECISION_DT,
       X_DECISION_ORG_UNIT_CD,
       X_DECISION_OU_START_DT,
       X_DECISION_STATUS,
       X_DURATION,
       X_DURATION_TYPE,
       X_ENCMB_COURSE_GROUP_CD,
       X_EXPIRY_DT,
       X_HIST_END_DT,
       X_HIST_WHO,
       X_PRA_SEQUENCE_NUMBER,
       X_PRG_CAL_TYPE,
       X_PRG_CI_SEQUENCE_NUMBER,
       X_PROGRESSION_OUTCOME_TYPE,
       X_PROGRESSION_RULE_CAT,
       X_PRO_PRA_SEQUENCE_NUMBER,
       X_PRO_SEQUENCE_NUMBER,
       X_RESTRICTED_ATTENDANCE_TYPE,
       X_RESTRICTED_ENROLMENT_CP,
       X_RULE_CHECK_DT,
       X_SHOW_CAUSE_COMMENTS,
       X_SHOW_CAUSE_DT,
       X_SHOW_CAUSE_EXPIRY_DT,
       X_SHOW_CAUSE_OUTCOME_DT,
       X_SHOW_CAUSE_OUTCOME_TYPE,
      X_MODE,
       X_ORG_ID );

Line: 1264


UPDATE_ROW (
      X_ROWID,
       X_PERSON_ID,
       X_COURSE_CD,
       X_SEQUENCE_NUMBER,
       X_HIST_START_DT,
       X_APPEAL_COMMENTS,
       X_APPEAL_DT,
       X_APPEAL_EXPIRY_DT,
       X_APPEAL_OUTCOME_DT,
       X_APPEAL_OUTCOME_TYPE,
       X_APPLIED_DT,
       X_COMMENTS,
       X_DECISION_DT,
       X_DECISION_ORG_UNIT_CD,
       X_DECISION_OU_START_DT,
       X_DECISION_STATUS,
       X_DURATION,
       X_DURATION_TYPE,
       X_ENCMB_COURSE_GROUP_CD,
       X_EXPIRY_DT,
       X_HIST_END_DT,
       X_HIST_WHO,
       X_PRA_SEQUENCE_NUMBER,
       X_PRG_CAL_TYPE,
       X_PRG_CI_SEQUENCE_NUMBER,
       X_PROGRESSION_OUTCOME_TYPE,
       X_PROGRESSION_RULE_CAT,
       X_PRO_PRA_SEQUENCE_NUMBER,
       X_PRO_SEQUENCE_NUMBER,
       X_RESTRICTED_ATTENDANCE_TYPE,
       X_RESTRICTED_ENROLMENT_CP,
       X_RULE_CHECK_DT,
       X_SHOW_CAUSE_COMMENTS,
       X_SHOW_CAUSE_DT,
       X_SHOW_CAUSE_EXPIRY_DT,
       X_SHOW_CAUSE_OUTCOME_DT,
       X_SHOW_CAUSE_OUTCOME_TYPE,
      X_MODE );

Line: 1304


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

begin
Before_DML (
p_action => 'DELETE',
x_rowid => X_ROWID
);

Line: 1323


 delete from IGS_PR_STU_OU_HIST_ALL
 where ROWID = X_ROWID;

Line: 1329


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

Line: 1332


end DELETE_ROW;