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

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

Line: 21


    SELECT DISTINCT 1
    FROM igs_ad_acad_history_v hist, igs_ad_transcript_v trans
    WHERE hist.education_id = trans.education_id
    AND trans.transcript_id = cp_transcript_id
    AND hist.status = 'I';

Line: 62


    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

  /*************************************************************
  Created By : knaraset.in
  Date Created By : 2000/05/16
  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_AD_TERM_DETAILS
      WHERE    rowid = x_rowid;

Line: 91


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

Line: 93


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

Line: 111


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

Line: 118


    new_references.last_update_date := x_last_update_date;

Line: 119


    new_references.last_updated_by := x_last_updated_by;

Line: 120


    new_references.last_update_login := x_last_update_login;

Line: 281


      SELECT   rowid
      FROM     igs_ad_term_details
      WHERE    term_details_id = x_term_details_id
      FOR UPDATE NOWAIT;

Line: 317


      SELECT   rowid
      FROM     igs_ad_term_details
      WHERE    transcript_id = x_transcript_id ;

Line: 353


    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
  /*************************************************************
  Created By : knaraset.in
  Date Created By : 2000/05/16
  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_term_details_id,
      x_transcript_id,
      x_term,
      x_start_date,
      x_end_date,
      x_total_cp_attempted,
      x_total_cp_earned,
      x_total_unit_gp,
      x_total_gpa_units,
      x_gpa,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 390


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

Line: 402


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

Line: 408


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

Line: 412


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
         -- Call all the procedures related to Before Insert.
      IF Get_PK_For_Validation (
                new_references.term_details_id)  THEN
        Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 421


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Constraints;

Line: 423


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;

Line: 448


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

Line: 451


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

Line: 454


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

Line: 462


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_TERM_DETAILS_ID IN OUT NOCOPY NUMBER,
       x_TRANSCRIPT_ID IN NUMBER,
       x_TERM IN VARCHAR2,
       x_START_DATE IN DATE,
       x_END_DATE IN DATE,
       x_TOTAL_CP_ATTEMPTED IN NUMBER,
       x_TOTAL_CP_EARNED IN NUMBER,
       x_TOTAL_UNIT_GP IN NUMBER,
       x_TOTAL_GPA_UNITS IN NUMBER,
       x_GPA IN VARCHAR2,
      X_MODE in VARCHAR2 default 'R'
  ) AS
 /*************************************************************
  Created By : knaraset.in
  Date Created By : 2000/05/16
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

    cursor C is select ROWID from IGS_AD_TERM_DETAILS
             where                 TERM_DETAILS_ID= X_TERM_DETAILS_ID
;

Line: 490


     X_LAST_UPDATE_DATE DATE ;

Line: 491


     X_LAST_UPDATED_BY NUMBER ;

Line: 492


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 496


     X_PROGRAM_UPDATE_DATE DATE;

Line: 498


    X_LAST_UPDATE_DATE := SYSDATE;

Line: 500


      X_LAST_UPDATED_BY := 1;

Line: 501


      X_LAST_UPDATE_LOGIN := 0;

Line: 503


      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 504


      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;

Line: 507


      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 508


      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;

Line: 518


        X_PROGRAM_UPDATE_DATE := NULL;

Line: 520


        X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 530


                p_action=>'INSERT',
                x_rowid=>X_ROWID,
               x_term_details_id=>X_TERM_DETAILS_ID,
               x_transcript_id=>X_TRANSCRIPT_ID,
               x_term=>X_TERM,
               x_start_date=>X_START_DATE,
               x_end_date=>X_END_DATE,
               x_total_cp_attempted=>X_TOTAL_CP_ATTEMPTED,
               x_total_cp_earned=>X_TOTAL_CP_EARNED,
               x_total_unit_gp=>X_TOTAL_UNIT_GP,
               x_total_gpa_units=>X_TOTAL_GPA_UNITS,
               x_gpa=>X_GPA,
               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: 550


 insert into IGS_AD_TERM_DETAILS (
                TERM_DETAILS_ID
                ,TRANSCRIPT_ID
                ,TERM
                ,START_DATE
                ,END_DATE
                ,TOTAL_CP_ATTEMPTED
                ,TOTAL_CP_EARNED
                ,TOTAL_UNIT_GP
                ,TOTAL_GPA_UNITS
                ,GPA
                ,CREATION_DATE
                ,CREATED_BY
                ,LAST_UPDATE_DATE
                ,LAST_UPDATED_BY
                ,LAST_UPDATE_LOGIN
                ,REQUEST_ID
                ,PROGRAM_ID
                ,PROGRAM_APPLICATION_ID
                ,PROGRAM_UPDATE_DATE
        ) values  (
                 IGS_AD_TERM_DETAILS_S.NEXTVAL
                ,NEW_REFERENCES.TRANSCRIPT_ID
                ,NEW_REFERENCES.TERM
                ,NEW_REFERENCES.START_DATE
                ,NEW_REFERENCES.END_DATE
                ,NEW_REFERENCES.TOTAL_CP_ATTEMPTED
                ,NEW_REFERENCES.TOTAL_CP_EARNED
                ,NEW_REFERENCES.TOTAL_UNIT_GP
                ,NEW_REFERENCES.TOTAL_GPA_UNITS
                ,NEW_REFERENCES.GPA
                ,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
)RETURNING TERM_DETAILS_ID INTO X_TERM_DETAILS_ID;

Line: 603


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

Line: 618


end INSERT_ROW;

Line: 642


   cursor c1 is select
      TRANSCRIPT_ID
,      TERM
,      START_DATE
,      END_DATE
,      TOTAL_CP_ATTEMPTED
,      TOTAL_CP_EARNED
,      TOTAL_UNIT_GP
,      TOTAL_GPA_UNITS
,      GPA
    from IGS_AD_TERM_DETAILS
    where ROWID = X_ROWID
    for update nowait;

Line: 660


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

Line: 695


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_TERM_DETAILS_ID IN NUMBER,
       x_TRANSCRIPT_ID IN NUMBER,
       x_TERM IN VARCHAR2,
       x_START_DATE IN DATE,
       x_END_DATE IN DATE,
       x_TOTAL_CP_ATTEMPTED IN NUMBER,
       x_TOTAL_CP_EARNED IN NUMBER,
       x_TOTAL_UNIT_GP IN NUMBER,
       x_TOTAL_GPA_UNITS IN NUMBER,
       x_GPA IN VARCHAR2,
      X_MODE in VARCHAR2 default 'R'
  ) AS
  /*************************************************************
  Created By : knaraset.in
  Date Created By : 2000/05/16
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

     X_LAST_UPDATE_DATE DATE ;

Line: 721


     X_LAST_UPDATED_BY NUMBER ;

Line: 722


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 726


     X_PROGRAM_UPDATE_DATE DATE;

Line: 728


    X_LAST_UPDATE_DATE := SYSDATE;

Line: 730


      X_LAST_UPDATED_BY := 1;

Line: 731


      X_LAST_UPDATE_LOGIN := 0;

Line: 733


      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 734


      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;

Line: 737


      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 738


      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;

Line: 747


                p_action=>'UPDATE',
                x_rowid=>X_ROWID,
               x_term_details_id=>X_TERM_DETAILS_ID,
               x_transcript_id=>X_TRANSCRIPT_ID,
               x_term=>X_TERM,
               x_start_date=>X_START_DATE,
               x_end_date=>X_END_DATE,
               x_total_cp_attempted=>X_TOTAL_CP_ATTEMPTED,
               x_total_cp_earned=>X_TOTAL_CP_EARNED,
               x_total_unit_gp=>X_TOTAL_UNIT_GP,
               x_total_gpa_units=>X_TOTAL_GPA_UNITS,
               x_gpa=>X_GPA,
               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: 773


        X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 775


        X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 782


 update IGS_AD_TERM_DETAILS set
      TRANSCRIPT_ID =  NEW_REFERENCES.TRANSCRIPT_ID,
      TERM =  NEW_REFERENCES.TERM,
      START_DATE =  NEW_REFERENCES.START_DATE,
      END_DATE =  NEW_REFERENCES.END_DATE,
      TOTAL_CP_ATTEMPTED =  NEW_REFERENCES.TOTAL_CP_ATTEMPTED,
      TOTAL_CP_EARNED =  NEW_REFERENCES.TOTAL_CP_EARNED,
      TOTAL_UNIT_GP =  NEW_REFERENCES.TOTAL_UNIT_GP,
      TOTAL_GPA_UNITS =  NEW_REFERENCES.TOTAL_GPA_UNITS,
      GPA =  NEW_REFERENCES.GPA,
        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 = PROGRAM_APPLICATION_ID,
        PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
          where ROWID = X_ROWID;

Line: 812


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

Line: 828


end UPDATE_ROW;

Line: 854


    cursor c1 is select ROWID from IGS_AD_TERM_DETAILS
             where     TERM_DETAILS_ID= X_TERM_DETAILS_ID
;

Line: 862


    INSERT_ROW (
      X_ROWID,
       X_TERM_DETAILS_ID,
       X_TRANSCRIPT_ID,
       X_TERM,
       X_START_DATE,
       X_END_DATE,
       X_TOTAL_CP_ATTEMPTED,
       X_TOTAL_CP_EARNED,
       X_TOTAL_UNIT_GP,
       X_TOTAL_GPA_UNITS,
       X_GPA,
      X_MODE );

Line: 878


UPDATE_ROW (
      X_ROWID,
       X_TERM_DETAILS_ID,
       X_TRANSCRIPT_ID,
       X_TERM,
       X_START_DATE,
       X_END_DATE,
       X_TOTAL_CP_ATTEMPTED,
       X_TOTAL_CP_EARNED,
       X_TOTAL_UNIT_GP,
       X_TOTAL_GPA_UNITS,
       X_GPA,
      X_MODE );

Line: 892


procedure DELETE_ROW (
  X_ROWID in VARCHAR2,
  x_mode IN VARCHAR2
) AS
  /*************************************************************
  Created By : knaraset.in
  Date Created By : 2000/05/16
  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: 915


 delete from IGS_AD_TERM_DETAILS
 where ROWID = X_ROWID;

Line: 928


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

Line: 931


end DELETE_ROW;