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_AD_PS_APINTUNTHS_PKG SQL Statements

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

Line: 32


    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_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
    x_adm_ps_appl_inst_unithist_id IN NUMBER DEFAULT NULL
  ) AS

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

Line: 52


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

Line: 54


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

Line: 85


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

Line: 92


    new_references.last_update_date := x_last_update_date;

Line: 93


    new_references.last_updated_by := x_last_updated_by;

Line: 94


    new_references.last_update_login := x_last_update_login;

Line: 195


      SELECT   rowid
      FROM     IGS_AD_PS_APINTUNTHS_ALL
      WHERE    adm_ps_appl_inst_unit_hist_id = x_adm_ps_appl_inst_unithist_id
      FOR UPDATE NOWAIT;

Line: 223


      SELECT   rowid
      FROM     IGS_AD_PS_APINTUNTHS_ALL
      WHERE    adm_ps_appl_inst_unit_id = x_adm_ps_appl_inst_unit_id
      AND      hist_start_dt = x_hist_start_dt
      AND      (l_rowid IS NULL OR rowid <> l_rowid)
      FOR UPDATE NOWAIT;

Line: 271


    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_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
    x_adm_ps_appl_inst_unithist_id IN NUMBER DEFAULT NULL
  ) AS
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
			x_org_id,
      x_person_id,
      x_admission_appl_number,
      x_nominated_course_cd,
      x_acai_sequence_number,
      x_unit_cd,
      x_hist_start_dt,
      x_hist_end_dt,
      x_hist_who,
      x_uv_version_number,
      x_cal_type,
      x_ci_sequence_number,
      x_location_cd,
      x_unit_class,
      x_unit_mode,
      x_adm_unit_outcome_status,
      x_ass_tracking_id,
      x_rule_waived_dt,
      x_rule_waived_person_id,
      x_sup_unit_cd,
      x_sup_uv_version_number,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_adm_ps_appl_inst_unit_id,
      x_adm_ps_appl_inst_unithist_id
    );

Line: 312


IF (p_action = 'INSERT') THEN
       -- Call all the procedures related to Before Insert.
      IF Get_PK_For_Validation (new_references.adm_ps_appl_inst_unit_hist_id) OR
         Get_UK_For_Validation (
          new_references.adm_ps_appl_inst_unit_id,
          new_references.hist_start_dt
  		) THEN
         Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 324


 ELSIF (p_action = 'UPDATE') THEN
      new_references.adm_ps_appl_inst_unit_hist_id := old_references.adm_ps_appl_inst_unit_hist_id;

Line: 335


 ELSIF (p_action = 'VALIDATE_INSERT') THEN
      IF Get_PK_For_Validation (new_references.adm_ps_appl_inst_unit_hist_id) OR
         Get_UK_For_Validation (
          new_references.adm_ps_appl_inst_unit_id,
          new_references.hist_start_dt
  		) THEN
         Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 346


 ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      new_references.adm_ps_appl_inst_unit_hist_id := old_references.adm_ps_appl_inst_unit_hist_id;

Line: 370


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
	x_ORG_ID in NUMBER,
  X_PERSON_ID in NUMBER,
  X_ADMISSION_APPL_NUMBER in NUMBER,
  X_NOMINATED_COURSE_CD in VARCHAR2,
  X_ACAI_SEQUENCE_NUMBER in NUMBER,
  X_UNIT_CD in VARCHAR2,
  X_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_UV_VERSION_NUMBER in NUMBER,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_LOCATION_CD in VARCHAR2,
  X_UNIT_CLASS in VARCHAR2,
  X_UNIT_MODE in VARCHAR2,
  X_ADM_UNIT_OUTCOME_STATUS in VARCHAR2,
  X_ASS_TRACKING_ID in NUMBER,
  X_RULE_WAIVED_DT in DATE,
  X_RULE_WAIVED_PERSON_ID in NUMBER,
  X_SUP_UNIT_CD in VARCHAR2,
  X_SUP_UV_VERSION_NUMBER in NUMBER,
  X_MODE in VARCHAR2,
  x_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
  x_adm_ps_appl_inst_unithist_id IN OUT NOCOPY NUMBER
  ) AS
    cursor C is select ROWID, ADM_PS_APPL_INST_UNIT_HIST_ID from IGS_AD_PS_APINTUNTHS_ALL
      where ADM_PS_APPL_INST_UNIT_ID = X_ADM_PS_APPL_INST_UNIT_ID
      and HIST_START_DT = X_HIST_START_DT;

Line: 400


    X_LAST_UPDATE_DATE DATE;

Line: 401


    X_LAST_UPDATED_BY NUMBER;

Line: 402


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 404


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 406


    X_LAST_UPDATED_BY := 1;

Line: 407


    X_LAST_UPDATE_LOGIN := 0;

Line: 409


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 410


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 413


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 414


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 422


  Before_DML(p_action =>'INSERT',
  x_rowid =>X_ROWID,
	x_org_id => igs_ge_gen_003.get_org_id,
  x_person_id=>X_PERSON_ID ,
  x_admission_appl_number=>X_ADMISSION_APPL_NUMBER ,
  x_nominated_course_cd=>X_NOMINATED_COURSE_CD,
  x_acai_sequence_number=>X_ACAI_SEQUENCE_NUMBER,
  x_unit_cd=>X_UNIT_CD,
  x_hist_start_dt=>X_HIST_START_DT,
  x_hist_end_dt=>X_HIST_END_DT,
  x_hist_who=>X_HIST_WHO,
  x_uv_version_number=>X_UV_VERSION_NUMBER,
  x_cal_type=>X_CAL_TYPE,
  x_ci_sequence_number=>X_CI_SEQUENCE_NUMBER,
  x_location_cd=>X_LOCATION_CD,
  x_unit_class=>X_UNIT_CLASS,
  x_unit_mode=>X_UNIT_MODE,
  x_adm_unit_outcome_status=>X_ADM_UNIT_OUTCOME_STATUS,
  x_ass_tracking_id=>X_ASS_TRACKING_ID,
  x_rule_waived_dt=>X_RULE_WAIVED_DT,
  x_rule_waived_person_id=>X_RULE_WAIVED_PERSON_ID,
  x_sup_unit_cd=>X_SUP_UNIT_CD,
  x_sup_uv_version_number=>X_SUP_UV_VERSION_NUMBER,
  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_adm_ps_appl_inst_unit_id => X_ADM_PS_APPL_INST_UNIT_ID,
  x_adm_ps_appl_inst_unithist_id => X_ADM_PS_APPL_INST_UNITHIST_ID
  );

Line: 454


  insert into IGS_AD_PS_APINTUNTHS_ALL (
		ORG_ID,
    PERSON_ID,
    ADMISSION_APPL_NUMBER,
    NOMINATED_COURSE_CD,
    ACAI_SEQUENCE_NUMBER,
    UNIT_CD,
    HIST_START_DT,
    HIST_END_DT,
    HIST_WHO,
    UV_VERSION_NUMBER,
    CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    LOCATION_CD,
    UNIT_CLASS,
    UNIT_MODE,
    ADM_UNIT_OUTCOME_STATUS,
    ASS_TRACKING_ID,
    RULE_WAIVED_DT,
    RULE_WAIVED_PERSON_ID,
    SUP_UNIT_CD,
    SUP_UV_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ADM_PS_APPL_INST_UNIT_ID,
    ADM_PS_APPL_INST_UNIT_HIST_ID
  ) values (
		NEW_REFERENCES.ORG_ID,
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.ADMISSION_APPL_NUMBER,
    NEW_REFERENCES.NOMINATED_COURSE_CD,
    NEW_REFERENCES.ACAI_SEQUENCE_NUMBER,
    NEW_REFERENCES.UNIT_CD,
    NEW_REFERENCES.HIST_START_DT,
    NEW_REFERENCES.HIST_END_DT,
    NEW_REFERENCES.HIST_WHO,
    NEW_REFERENCES.UV_VERSION_NUMBER,
    NEW_REFERENCES.CAL_TYPE,
    NEW_REFERENCES.CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.LOCATION_CD,
    NEW_REFERENCES.UNIT_CLASS,
    NEW_REFERENCES.UNIT_MODE,
    NEW_REFERENCES.ADM_UNIT_OUTCOME_STATUS,
    NEW_REFERENCES.ASS_TRACKING_ID,
    NEW_REFERENCES.RULE_WAIVED_DT,
    NEW_REFERENCES.RULE_WAIVED_PERSON_ID,
    NEW_REFERENCES.SUP_UNIT_CD,
    NEW_REFERENCES.SUP_UV_VERSION_NUMBER,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    NEW_REFERENCES.ADM_PS_APPL_INST_UNIT_ID,
    IGS_AD_PS_APINTUNTHS_S.NEXTVAL
  );

Line: 522


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

Line: 540


end INSERT_ROW;

Line: 567


  cursor c1 is select
      HIST_END_DT,
      HIST_WHO,
      UV_VERSION_NUMBER,
      CAL_TYPE,
      CI_SEQUENCE_NUMBER,
      LOCATION_CD,
      UNIT_CLASS,
      UNIT_MODE,
      ADM_UNIT_OUTCOME_STATUS,
      ASS_TRACKING_ID,
      RULE_WAIVED_DT,
      RULE_WAIVED_PERSON_ID,
      SUP_UNIT_CD,
      SUP_UV_VERSION_NUMBER
    from IGS_AD_PS_APINTUNTHS_ALL
    where ROWID = X_ROWID for update nowait;

Line: 591


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

Line: 646


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_ADMISSION_APPL_NUMBER in NUMBER,
  X_NOMINATED_COURSE_CD in VARCHAR2,
  X_ACAI_SEQUENCE_NUMBER in NUMBER,
  X_UNIT_CD in VARCHAR2,
  X_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_UV_VERSION_NUMBER in NUMBER,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_LOCATION_CD in VARCHAR2,
  X_UNIT_CLASS in VARCHAR2,
  X_UNIT_MODE in VARCHAR2,
  X_ADM_UNIT_OUTCOME_STATUS in VARCHAR2,
  X_ASS_TRACKING_ID in NUMBER,
  X_RULE_WAIVED_DT in DATE,
  X_RULE_WAIVED_PERSON_ID in NUMBER,
  X_SUP_UNIT_CD in VARCHAR2,
  X_SUP_UV_VERSION_NUMBER in NUMBER,
  X_MODE in VARCHAR2,
  x_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
  x_adm_ps_appl_inst_unithist_id IN NUMBER DEFAULT NULL
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 673


    X_LAST_UPDATED_BY NUMBER;

Line: 674


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 676


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 678


    X_LAST_UPDATED_BY := 1;

Line: 679


    X_LAST_UPDATE_LOGIN := 0;

Line: 681


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 682


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 685


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 686


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 694


Before_DML(p_action =>'UPDATE',
  x_rowid =>X_ROWID,
  x_person_id=>X_PERSON_ID ,
  x_admission_appl_number=>X_ADMISSION_APPL_NUMBER ,
  x_nominated_course_cd=>X_NOMINATED_COURSE_CD,
  x_acai_sequence_number=>X_ACAI_SEQUENCE_NUMBER,
  x_unit_cd=>X_UNIT_CD,
  x_hist_start_dt=>X_HIST_START_DT,
  x_hist_end_dt=>X_HIST_END_DT,
  x_hist_who=>X_HIST_WHO,
  x_uv_version_number=>X_UV_VERSION_NUMBER,
  x_cal_type=>X_CAL_TYPE,
  x_ci_sequence_number=>X_CI_SEQUENCE_NUMBER,
  x_location_cd=>X_LOCATION_CD,
  x_unit_class=>X_UNIT_CLASS,
  x_unit_mode=>X_UNIT_MODE,
  x_adm_unit_outcome_status=>X_ADM_UNIT_OUTCOME_STATUS,
  x_ass_tracking_id=>X_ASS_TRACKING_ID,
  x_rule_waived_dt=>X_RULE_WAIVED_DT,
  x_rule_waived_person_id=>X_RULE_WAIVED_PERSON_ID,
  x_sup_unit_cd=>X_SUP_UNIT_CD,
      x_sup_uv_version_number=>X_SUP_UV_VERSION_NUMBER,
  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_adm_ps_appl_inst_unit_id => X_ADM_PS_APPL_INST_UNIT_ID,
  x_adm_ps_appl_inst_unithist_id => X_ADM_PS_APPL_INST_UNITHIST_ID
  );

Line: 725


update IGS_AD_PS_APINTUNTHS_ALL set
    HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
    HIST_WHO = NEW_REFERENCES.HIST_WHO,
    UV_VERSION_NUMBER = NEW_REFERENCES.UV_VERSION_NUMBER,
    CAL_TYPE = NEW_REFERENCES.CAL_TYPE,
    CI_SEQUENCE_NUMBER = NEW_REFERENCES.CI_SEQUENCE_NUMBER,
    LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
    UNIT_CLASS = NEW_REFERENCES.UNIT_CLASS,
    UNIT_MODE = NEW_REFERENCES.UNIT_MODE,
    ADM_UNIT_OUTCOME_STATUS = NEW_REFERENCES.ADM_UNIT_OUTCOME_STATUS,
    ASS_TRACKING_ID = NEW_REFERENCES.ASS_TRACKING_ID,
    RULE_WAIVED_DT = NEW_REFERENCES.RULE_WAIVED_DT,
    RULE_WAIVED_PERSON_ID = NEW_REFERENCES.RULE_WAIVED_PERSON_ID,
    SUP_UNIT_CD = NEW_REFERENCES.SUP_UNIT_CD,
    SUP_UV_VERSION_NUMBER = NEW_REFERENCES.SUP_UV_VERSION_NUMBER,
    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: 751


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

Line: 770


end UPDATE_ROW;

Line: 799


  cursor c1 is select rowid from IGS_AD_PS_APINTUNTHS_ALL
     where adm_ps_appl_inst_unit_hist_id = x_adm_ps_appl_inst_unithist_id
  ;

Line: 808


    INSERT_ROW (
     X_ROWID,
		 X_ORG_ID,
     X_PERSON_ID,
     X_ADMISSION_APPL_NUMBER,
     X_NOMINATED_COURSE_CD,
     X_ACAI_SEQUENCE_NUMBER,
     X_UNIT_CD,
     X_HIST_START_DT,
     X_HIST_END_DT,
     X_HIST_WHO,
     X_UV_VERSION_NUMBER,
     X_CAL_TYPE,
     X_CI_SEQUENCE_NUMBER,
     X_LOCATION_CD,
     X_UNIT_CLASS,
     X_UNIT_MODE,
     X_ADM_UNIT_OUTCOME_STATUS,
     X_ASS_TRACKING_ID,
     X_RULE_WAIVED_DT,
     X_RULE_WAIVED_PERSON_ID,
     X_SUP_UNIT_CD,
     X_SUP_UV_VERSION_NUMBER,
     X_MODE,
     X_ADM_PS_APPL_INST_UNIT_ID,
     X_ADM_PS_APPL_INST_UNITHIST_ID);

Line: 837


  UPDATE_ROW (
   X_ROWID,
   X_PERSON_ID,
   X_ADMISSION_APPL_NUMBER,
   X_NOMINATED_COURSE_CD,
   X_ACAI_SEQUENCE_NUMBER,
   X_UNIT_CD,
   X_HIST_START_DT,
   X_HIST_END_DT,
   X_HIST_WHO,
   X_UV_VERSION_NUMBER,
   X_CAL_TYPE,
   X_CI_SEQUENCE_NUMBER,
   X_LOCATION_CD,
   X_UNIT_CLASS,
   X_UNIT_MODE,
   X_ADM_UNIT_OUTCOME_STATUS,
   X_ASS_TRACKING_ID,
   X_RULE_WAIVED_DT,
   X_RULE_WAIVED_PERSON_ID,
   X_SUP_UNIT_CD,
   X_SUP_UV_VERSION_NUMBER,
   X_MODE,
   X_ADM_PS_APPL_INST_UNIT_ID,
   X_ADM_PS_APPL_INST_UNITHIST_ID);

Line: 864


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS

e_resource_busy_exception		EXCEPTION;

Line: 875


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

Line: 880


  	delete from IGS_AD_PS_APINTUNTHS_ALL
  	where ROWID = X_ROWID;

Line: 888


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

Line: 894


	  v_message_name := 'IGS_AD_UNABLE_TO_DELETE';

Line: 912


end DELETE_ROW;