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

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

Line: 37


    x_logical_delete_dt IN DATE DEFAULT NULL,

    x_creation_date IN DATE DEFAULT NULL,

    x_created_by IN NUMBER DEFAULT NULL,

    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_uoo_id IN NUMBER DEFAULT NULL

  ) AS



    CURSOR cur_old_ref_values IS

      SELECT   *

      FROM     IGS_PE_STD_TODO_REF

      WHERE    rowid = x_rowid;

Line: 81


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

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

Line: 117


    new_references.logical_delete_dt := x_logical_delete_dt;

Line: 121


    IF (p_action = 'UPDATE') THEN

      new_references.creation_date := old_references.creation_date;

Line: 135


    new_references.last_update_date := x_last_update_date;

Line: 137


    new_references.last_updated_by := x_last_updated_by;

Line: 139


    new_references.last_update_login := x_last_update_login;

Line: 248


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

Line: 273


      SELECT   rowid

      FROM     IGS_PE_STD_TODO_REF

      WHERE    person_id = x_person_id

      AND      s_student_todo_type = x_s_student_todo_type

      AND      sequence_number = x_sequence_number

      AND      reference_number = x_reference_number

      FOR UPDATE NOWAIT;

Line: 321


      SELECT   rowid

      FROM     IGS_PE_STD_TODO_REF

      WHERE    person_id = x_person_id

      AND      s_student_todo_type = x_s_student_todo_type

      AND      sequence_number = x_sequence_number ;

Line: 388


    x_logical_delete_dt IN DATE DEFAULT NULL,

    x_creation_date IN DATE DEFAULT NULL,

    x_created_by IN NUMBER DEFAULT NULL,

    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_uoo_id IN NUMBER DEFAULT NULL

  ) AS

  BEGIN



    Set_Column_Values (

      p_action,

      x_rowid,

      x_person_id,

      x_s_student_todo_type,

      x_sequence_number,

      x_reference_number,

      x_cal_type,

      x_ci_sequence_number,

      x_course_cd,

      x_unit_cd,

      x_other_reference,

      x_logical_delete_dt,

      x_creation_date,

      x_created_by,

      x_last_update_date,

      x_last_updated_by,

      x_last_update_login,

      x_uoo_id

    );

Line: 450


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

      IF  Get_PK_For_Validation (
          new_references.person_id ,
    new_references.s_student_todo_type ,
    new_references.sequence_number ,
    new_references.reference_number ) THEN
         Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 465


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

       Check_Constraints; -- if procedure present

Line: 471


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

       NULL;

Line: 475


 ELSIF (p_action = 'VALIDATE_INSERT') THEN
      IF  Get_PK_For_Validation (
          new_references.person_id ,
    new_references.s_student_todo_type ,
    new_references.sequence_number ,
    new_references.reference_number ) THEN
         Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 487


 ELSIF (p_action = 'VALIDATE_UPDATE') THEN

       Check_Constraints; -- if procedure present

Line: 491


ELSIF (p_action = 'VALIDATE_DELETE') THEN
      NULL;

Line: 517


    IF (p_action = 'INSERT') THEN

      -- Call all the procedures related to After Insert.

      Null;

Line: 523


    ELSIF (p_action = 'UPDATE') THEN

      -- Call all the procedures related to After Update.

      Null;

Line: 529


    ELSIF (p_action = 'DELETE') THEN

      -- Call all the procedures related to After Delete.

      Null;

Line: 546


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_S_STUDENT_TODO_TYPE in VARCHAR2,
  X_SEQUENCE_NUMBER in NUMBER,
  X_REFERENCE_NUMBER in NUMBER,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_UNIT_CD in VARCHAR2,
  X_OTHER_REFERENCE in VARCHAR2,
  X_LOGICAL_DELETE_DT in DATE,
  X_MODE in VARCHAR2 default 'R',
  X_UOO_ID in NUMBER
  ) AS
    cursor C is select ROWID from IGS_PE_STD_TODO_REF
      where PERSON_ID = X_PERSON_ID
      and S_STUDENT_TODO_TYPE = X_S_STUDENT_TODO_TYPE
      and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
      and REFERENCE_NUMBER = X_REFERENCE_NUMBER;

Line: 566


    X_LAST_UPDATE_DATE DATE;

Line: 567


    X_LAST_UPDATED_BY NUMBER;

Line: 568


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 576


    X_PROGRAM_UPDATE_DATE DATE;

Line: 579


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 581


    X_LAST_UPDATED_BY := 1;

Line: 582


    X_LAST_UPDATE_LOGIN := 0;

Line: 584


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 585


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 588


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 589


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 609


     X_PROGRAM_UPDATE_DATE := NULL;

Line: 613


     X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 626


 p_action=>'INSERT',

 x_rowid=>X_ROWID,

 x_cal_type=>X_CAL_TYPE,

 x_ci_sequence_number=>X_CI_SEQUENCE_NUMBER,

 x_course_cd=>X_COURSE_CD,

 x_logical_delete_dt=>X_LOGICAL_DELETE_DT,

 x_other_reference=>X_OTHER_REFERENCE,

 x_person_id=>X_PERSON_ID,

 x_reference_number=>X_REFERENCE_NUMBER,

 x_s_student_todo_type=>X_S_STUDENT_TODO_TYPE,

 x_sequence_number=>X_SEQUENCE_NUMBER,

 x_unit_cd=>X_UNIT_CD,

 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_uoo_id=>X_UOO_ID

 );

Line: 666


  insert into IGS_PE_STD_TODO_REF (
    PERSON_ID,
    S_STUDENT_TODO_TYPE,
    SEQUENCE_NUMBER,
    REFERENCE_NUMBER,
    CAL_TYPE,
    CI_SEQUENCE_NUMBER,
    COURSE_CD,
    UNIT_CD,
    OTHER_REFERENCE,
    LOGICAL_DELETE_DT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,

    REQUEST_ID,

    PROGRAM_ID,

    PROGRAM_APPLICATION_ID,

    PROGRAM_UPDATE_DATE,
    UOO_ID
  ) values (
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.S_STUDENT_TODO_TYPE,
    NEW_REFERENCES.SEQUENCE_NUMBER,
    NEW_REFERENCES.REFERENCE_NUMBER,
    NEW_REFERENCES.CAL_TYPE,
    NEW_REFERENCES.CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.COURSE_CD,
    NEW_REFERENCES.UNIT_CD,
    NEW_REFERENCES.OTHER_REFERENCE,
    NEW_REFERENCES.LOGICAL_DELETE_DT,
    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 ,
    NEW_REFERENCES.UOO_ID
  );

Line: 729


  p_action => 'INSERT',

  x_rowid => X_ROWID

  );

Line: 741


end INSERT_ROW;

Line: 755


  X_LOGICAL_DELETE_DT in DATE,
  X_UOO_ID in NUMBER
) AS
  cursor c1 is select
      CAL_TYPE,
      CI_SEQUENCE_NUMBER,
      COURSE_CD,
      UNIT_CD,
      OTHER_REFERENCE,
      LOGICAL_DELETE_DT,
      UOO_ID
    from IGS_PE_STD_TODO_REF
    where ROWID = X_ROWID
    for update nowait;

Line: 775


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

Line: 797


      AND ((tlinfo.LOGICAL_DELETE_DT = X_LOGICAL_DELETE_DT)
           OR ((tlinfo.LOGICAL_DELETE_DT is null)
               AND (X_LOGICAL_DELETE_DT is null)))
     AND ((tlinfo.UOO_ID = X_UOO_ID)
           OR ((tlinfo.UOO_ID is null)
               AND (X_UOO_ID is null)))

  ) then
    null;

Line: 813


procedure UPDATE_ROW (

  X_ROWID in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_S_STUDENT_TODO_TYPE in VARCHAR2,
  X_SEQUENCE_NUMBER in NUMBER,
  X_REFERENCE_NUMBER in NUMBER,
  X_CAL_TYPE in VARCHAR2,
  X_CI_SEQUENCE_NUMBER in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_UNIT_CD in VARCHAR2,
  X_OTHER_REFERENCE in VARCHAR2,
  X_LOGICAL_DELETE_DT in DATE,
  X_MODE in VARCHAR2 default 'R',
  X_UOO_ID in NUMBER
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 830


    X_LAST_UPDATED_BY NUMBER;

Line: 831


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 839


    X_PROGRAM_UPDATE_DATE DATE;

Line: 841


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 843


    X_LAST_UPDATED_BY := 1;

Line: 844


    X_LAST_UPDATE_LOGIN := 0;

Line: 846


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 847


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 850


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 851


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 866


   p_action=>'UPDATE',

   x_rowid=>X_ROWID,

   x_cal_type=>X_CAL_TYPE,

   x_ci_sequence_number=>X_CI_SEQUENCE_NUMBER,

   x_course_cd=>X_COURSE_CD,

   x_logical_delete_dt=>X_LOGICAL_DELETE_DT,

   x_other_reference=>X_OTHER_REFERENCE,

   x_person_id=>X_PERSON_ID,

   x_reference_number=>X_REFERENCE_NUMBER,

   x_s_student_todo_type=>X_S_STUDENT_TODO_TYPE,

   x_sequence_number=>X_SEQUENCE_NUMBER,

   x_unit_cd=>X_UNIT_CD,

   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_uoo_id=>X_UOO_ID


   );

Line: 926


     X_PROGRAM_UPDATE_DATE :=

                  OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 932


     X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 944


  update IGS_PE_STD_TODO_REF set
    CAL_TYPE = NEW_REFERENCES.CAL_TYPE,
    CI_SEQUENCE_NUMBER = NEW_REFERENCES.CI_SEQUENCE_NUMBER,
    COURSE_CD = NEW_REFERENCES.COURSE_CD,
    UNIT_CD = NEW_REFERENCES.UNIT_CD,
    OTHER_REFERENCE = NEW_REFERENCES.OTHER_REFERENCE,
    LOGICAL_DELETE_DT = NEW_REFERENCES.LOGICAL_DELETE_DT,
    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,
    UOO_ID = NEW_REFERENCES.UOO_ID
  where ROWID = X_ROWID
  ;

Line: 972


  p_action => 'UPDATE',

  x_rowid => X_ROWID

  );

Line: 980


end UPDATE_ROW;

Line: 993


  X_LOGICAL_DELETE_DT in DATE,
  X_MODE in VARCHAR2 default 'R',
  X_UOO_ID in NUMBER
  ) AS
  cursor c1 is select rowid from IGS_PE_STD_TODO_REF
     where PERSON_ID = X_PERSON_ID
     and S_STUDENT_TODO_TYPE = X_S_STUDENT_TODO_TYPE
     and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
     and REFERENCE_NUMBER = X_REFERENCE_NUMBER
  ;

Line: 1009


    INSERT_ROW (
     X_ROWID,
     X_PERSON_ID,
     X_S_STUDENT_TODO_TYPE,
     X_SEQUENCE_NUMBER,
     X_REFERENCE_NUMBER,
     X_CAL_TYPE,
     X_CI_SEQUENCE_NUMBER,
     X_COURSE_CD,
     X_UNIT_CD,
     X_OTHER_REFERENCE,
     X_LOGICAL_DELETE_DT,
     X_MODE,
     X_UOO_ID);

Line: 1026


  UPDATE_ROW (

   X_ROWID,
   X_PERSON_ID,
   X_S_STUDENT_TODO_TYPE,
   X_SEQUENCE_NUMBER,
   X_REFERENCE_NUMBER,
   X_CAL_TYPE,
   X_CI_SEQUENCE_NUMBER,
   X_COURSE_CD,
   X_UNIT_CD,
   X_OTHER_REFERENCE,
   X_LOGICAL_DELETE_DT,
   X_MODE,
   X_UOO_ID);

Line: 1043


procedure DELETE_ROW (
 X_ROWID in VARCHAR2
) AS
begin



Before_DML(

  p_action => 'DELETE',

  x_rowid => X_ROWID

  );

Line: 1059


  delete from IGS_PE_STD_TODO_REF
  where ROWID = X_ROWID;

Line: 1069


  p_action => 'DELETE',

  x_rowid => X_ROWID

  );

Line: 1074


end DELETE_ROW;