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

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

Line: 23


    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 :
  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_AD_APPL_PGMAPPRV
      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: 73


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

Line: 80


    new_references.last_update_date := x_last_update_date;

Line: 81


    new_references.last_updated_by := x_last_updated_by;

Line: 82


    new_references.last_update_login := x_last_update_login;

Line: 227


      SELECT   rowid
      FROM     igs_ad_appl_pgmapprv
      WHERE    appl_pgmapprv_id = x_appl_pgmapprv_id
      FOR UPDATE NOWAIT;

Line: 267


      SELECT   rowid
      FROM     igs_ad_appl_pgmapprv
      WHERE    pgm_approver_id = x_pgm_approver_id
      AND      sequence_number = x_sequence_number
      AND      admission_appl_number = x_admission_appl_number
      AND      nominated_course_cd = x_nominated_course_cd
      AND      person_id = x_person_id  and      ((l_rowid is null) or (rowid <> l_rowid))

      ;

Line: 309


      SELECT   rowid
      FROM     igs_ad_appl_pgmapprv
      WHERE    person_id = x_person_id
      AND      admission_appl_number = x_admission_appl_number
      AND      nominated_course_cd = x_nominated_course_cd
      AND      sequence_number = x_sequence_number ;

Line: 349


      SELECT   rowid
      FROM     igs_ad_appl_pgmapprv
      WHERE    pgm_approver_id = x_person_id ;

Line: 386


    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 :
  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_appl_pgmapprv_id,
      x_person_id,
      x_admission_appl_number,
      x_nominated_course_cd,
      x_sequence_number,
      x_pgm_approver_id,
      x_assign_type,
      x_assign_date,
      x_program_approval_date,
      x_program_approval_status,
      x_approval_notes,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 431


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

Line: 443


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

Line: 449


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

Line: 452


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

Line: 462


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;

Line: 465


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;

Line: 490


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

Line: 493


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

Line: 496


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

Line: 504


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_APPL_PGMAPPRV_ID IN OUT NOCOPY NUMBER,
       x_PERSON_ID IN NUMBER,
       x_ADMISSION_APPL_NUMBER IN NUMBER,
       x_NOMINATED_COURSE_CD IN VARCHAR2,
       x_SEQUENCE_NUMBER IN NUMBER,
       x_PGM_APPROVER_ID IN NUMBER,
       x_ASSIGN_TYPE IN VARCHAR2,
       x_ASSIGN_DATE IN DATE,
       x_PROGRAM_APPROVAL_DATE IN DATE,
       x_PROGRAM_APPROVAL_STATUS IN VARCHAR2,
       x_APPROVAL_NOTES IN VARCHAR2,
      X_MODE in VARCHAR2
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  RAVISHAR        Feb,25 2005     Removed the default value of X_MODE parameter from
                                  body of this package for bug 4163319
				  GSCC standard says that default value should be
				  present only in specification
  (reverse chronological order - newest change first)
  ***************************************************************/

    cursor C is select ROWID from IGS_AD_APPL_PGMAPPRV
             where                 APPL_PGMAPPRV_ID= X_APPL_PGMAPPRV_ID
;

Line: 536


     X_LAST_UPDATE_DATE DATE ;

Line: 537


     X_LAST_UPDATED_BY NUMBER ;

Line: 538


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 542


     X_PROGRAM_UPDATE_DATE DATE;

Line: 547


    X_LAST_UPDATE_DATE := SYSDATE;

Line: 549


      X_LAST_UPDATED_BY := 1;

Line: 550


      X_LAST_UPDATE_LOGIN := 0;

Line: 552


      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 553


      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;

Line: 556


      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 557


      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;

Line: 567


        X_PROGRAM_UPDATE_DATE := NULL;

Line: 569


        X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 579


                p_action=>'INSERT',
                x_rowid=>X_ROWID,
               x_appl_pgmapprv_id=>X_APPL_PGMAPPRV_ID,
               x_person_id=>X_PERSON_ID,
               x_admission_appl_number=>X_ADMISSION_APPL_NUMBER,
               x_nominated_course_cd=>X_NOMINATED_COURSE_CD,
               x_sequence_number=>X_SEQUENCE_NUMBER,
               x_pgm_approver_id=>X_PGM_APPROVER_ID,
               x_assign_type=>X_ASSIGN_TYPE,
               x_assign_date=>X_ASSIGN_DATE,
               x_program_approval_date=>X_PROGRAM_APPROVAL_DATE,
               x_program_approval_status=>X_PROGRAM_APPROVAL_STATUS,
               x_approval_notes=>X_APPROVAL_NOTES,
               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: 601


 insert into IGS_AD_APPL_PGMAPPRV (
                APPL_PGMAPPRV_ID
                ,PERSON_ID
                ,ADMISSION_APPL_NUMBER
                ,NOMINATED_COURSE_CD
                ,SEQUENCE_NUMBER
                ,PGM_APPROVER_ID
                ,ASSIGN_TYPE
                ,ASSIGN_DATE
                ,PROGRAM_APPROVAL_DATE
                ,PROGRAM_APPROVAL_STATUS
                ,APPROVAL_NOTES
                ,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_APPL_PGMAPPRV_S.NEXTVAL
                ,NEW_REFERENCES.PERSON_ID
                ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
                ,NEW_REFERENCES.NOMINATED_COURSE_CD
                ,NEW_REFERENCES.SEQUENCE_NUMBER
                ,NEW_REFERENCES.PGM_APPROVER_ID
                ,NEW_REFERENCES.ASSIGN_TYPE
                ,NEW_REFERENCES.ASSIGN_DATE
                ,NEW_REFERENCES.PROGRAM_APPROVAL_DATE
                ,NEW_REFERENCES.PROGRAM_APPROVAL_STATUS
                ,NEW_REFERENCES.APPROVAL_NOTES
                ,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 APPL_PGMAPPRV_ID INTO X_APPL_PGMAPPRV_ID;

Line: 657


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

Line: 680


end INSERT_ROW;

Line: 711


   cursor c1 is select
      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      SEQUENCE_NUMBER
,      PGM_APPROVER_ID
,      ASSIGN_TYPE
,      ASSIGN_DATE
,      PROGRAM_APPROVAL_DATE
,      PROGRAM_APPROVAL_STATUS
,      APPROVAL_NOTES
    from IGS_AD_APPL_PGMAPPRV
    where ROWID = X_ROWID
    for update nowait;

Line: 730


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

Line: 762


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_APPL_PGMAPPRV_ID IN NUMBER,
       x_PERSON_ID IN NUMBER,
       x_ADMISSION_APPL_NUMBER IN NUMBER,
       x_NOMINATED_COURSE_CD IN VARCHAR2,
       x_SEQUENCE_NUMBER IN NUMBER,
       x_PGM_APPROVER_ID IN NUMBER,
       x_ASSIGN_TYPE IN VARCHAR2,
       x_ASSIGN_DATE IN DATE,
       x_PROGRAM_APPROVAL_DATE IN DATE,
       x_PROGRAM_APPROVAL_STATUS IN VARCHAR2,
       x_APPROVAL_NOTES IN VARCHAR2,
      X_MODE in VARCHAR2
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  RAVISHAR        Feb,25 2005     Removed the default value of X_MODE parameter from
                                  body of this package for bug 4163319
  				  GSCC standard says that default value should be
				  present only in specification
(reverse chronological order - newest change first)
  ***************************************************************/

     X_LAST_UPDATE_DATE DATE ;

Line: 792


     X_LAST_UPDATED_BY NUMBER ;

Line: 793


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 797


     X_PROGRAM_UPDATE_DATE DATE;

Line: 802


    X_LAST_UPDATE_DATE := SYSDATE;

Line: 804


      X_LAST_UPDATED_BY := 1;

Line: 805


      X_LAST_UPDATE_LOGIN := 0;

Line: 807


      X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 808


      if X_LAST_UPDATED_BY is NULL then
        X_LAST_UPDATED_BY := -1;

Line: 811


      X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 812


      if X_LAST_UPDATE_LOGIN is NULL then
        X_LAST_UPDATE_LOGIN := -1;

Line: 821


                p_action=>'UPDATE',
                x_rowid=>X_ROWID,
               x_appl_pgmapprv_id=>X_APPL_PGMAPPRV_ID,
               x_person_id=>X_PERSON_ID,
               x_admission_appl_number=>X_ADMISSION_APPL_NUMBER,
               x_nominated_course_cd=>X_NOMINATED_COURSE_CD,
               x_sequence_number=>X_SEQUENCE_NUMBER,
               x_pgm_approver_id=>X_PGM_APPROVER_ID,
               x_assign_type=>X_ASSIGN_TYPE,
               x_assign_date=>X_ASSIGN_DATE,
               x_program_approval_date=>X_PROGRAM_APPROVAL_DATE,
               x_program_approval_status=>X_PROGRAM_APPROVAL_STATUS,
               x_approval_notes=>X_APPROVAL_NOTES,
               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: 848


        X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 850


        X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 857


 update IGS_AD_APPL_PGMAPPRV set
      PERSON_ID =  NEW_REFERENCES.PERSON_ID,
      ADMISSION_APPL_NUMBER =  NEW_REFERENCES.ADMISSION_APPL_NUMBER,
      NOMINATED_COURSE_CD =  NEW_REFERENCES.NOMINATED_COURSE_CD,
      SEQUENCE_NUMBER =  NEW_REFERENCES.SEQUENCE_NUMBER,
      PGM_APPROVER_ID =  NEW_REFERENCES.PGM_APPROVER_ID,
      ASSIGN_TYPE =  NEW_REFERENCES.ASSIGN_TYPE,
      ASSIGN_DATE =  NEW_REFERENCES.ASSIGN_DATE,
      PROGRAM_APPROVAL_DATE =  NEW_REFERENCES.PROGRAM_APPROVAL_DATE,
      PROGRAM_APPROVAL_STATUS =  NEW_REFERENCES.PROGRAM_APPROVAL_STATUS,
      APPROVAL_NOTES =  NEW_REFERENCES.APPROVAL_NOTES,
        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: 888


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

Line: 906


end UPDATE_ROW;

Line: 936


    cursor c1 is select ROWID from IGS_AD_APPL_PGMAPPRV
             where     APPL_PGMAPPRV_ID= X_APPL_PGMAPPRV_ID
;

Line: 947


    INSERT_ROW (
      X_ROWID,
       X_APPL_PGMAPPRV_ID,
       X_PERSON_ID,
       X_ADMISSION_APPL_NUMBER,
       X_NOMINATED_COURSE_CD,
       X_SEQUENCE_NUMBER,
       X_PGM_APPROVER_ID,
       X_ASSIGN_TYPE,
       X_ASSIGN_DATE,
       X_PROGRAM_APPROVAL_DATE,
       X_PROGRAM_APPROVAL_STATUS,
       X_APPROVAL_NOTES,
      l_mode );

Line: 964


UPDATE_ROW (
      X_ROWID,
       X_APPL_PGMAPPRV_ID,
       X_PERSON_ID,
       X_ADMISSION_APPL_NUMBER,
       X_NOMINATED_COURSE_CD,
       X_SEQUENCE_NUMBER,
       X_PGM_APPROVER_ID,
       X_ASSIGN_TYPE,
       X_ASSIGN_DATE,
       X_PROGRAM_APPROVAL_DATE,
       X_PROGRAM_APPROVAL_STATUS,
       X_APPROVAL_NOTES,
      l_mode );

Line: 979


procedure DELETE_ROW (
  X_ROWID in VARCHAR2,
  x_mode 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: 1002


 delete from IGS_AD_APPL_PGMAPPRV
 where ROWID = X_ROWID;

Line: 1015


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

Line: 1033


end DELETE_ROW;