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

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

Line: 30


    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_claimable_hours IN NUMBER DEFAULT NULL,
    x_achievable_credit_points IN NUMBER DEFAULT NULL,
    x_enrolled_credit_points IN NUMBER DEFAULT NULL,
    x_billing_credit_points IN NUMBER,
    x_billing_hrs IN NUMBER
  ) AS

  /*************************************************************
  Created By :  shgeorge
  Date Created By :  10-May-2000
  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_PS_USEC_CPS
      WHERE    rowid = x_rowid;

Line: 64


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

Line: 66


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

Line: 98


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

Line: 105


    new_references.last_update_date := x_last_update_date;

Line: 106


    new_references.last_updated_by := x_last_updated_by;

Line: 107


    new_references.last_update_login := x_last_update_login;

Line: 111


 PROCEDURE AfterRowUpdate1(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) AS

  -- Select the teaching responsibilites record which has only workload percentage defined and not
  -- other workload values defined.
  CURSOR c_teach_resp(p_uoo_id NUMBER) IS
         SELECT rowid,iputr.*
         FROM igs_ps_usec_tch_resp iputr
         WHERE iputr.uoo_id = p_uoo_id AND
               iputr.percentage_allocation IS NOT NULL AND
               iputr.instructional_load_lab IS NULL AND
               iputr.instructional_load_lecture IS NULL AND
               iputr.instructional_load IS NULL;

Line: 137


       )) OR p_inserting = TRUE THEN
         -- Re-calculating the values in Worload lecture,Laboratory and Other in Teaching Responsibilities as these points are modified at Unit Section level

          FOR c_teach_resp_rec in c_teach_resp(new_references.uoo_id)
          LOOP
               igs_ps_fac_credt_wrkload.calculate_teach_work_load(c_teach_resp_rec.uoo_id,c_teach_resp_rec.percentage_allocation,l_new_lab,l_new_lecture,l_new_other);

Line: 143


               igs_ps_usec_tch_resp_pkg.update_row (
                                                  x_mode                       => 'R',
                                                  x_rowid                      => c_teach_resp_rec.rowid,
                                                  x_unit_section_teach_resp_id => c_teach_resp_rec.unit_section_teach_resp_id,
                                                  x_instructor_id              => c_teach_resp_rec.instructor_id,
                                                  x_confirmed_flag             => c_teach_resp_rec.confirmed_flag ,
                                                  x_percentage_allocation      => c_teach_resp_rec.percentage_allocation,
                                                  x_instructional_load         => l_new_other ,
                                                  x_lead_instructor_flag       => c_teach_resp_rec.lead_instructor_flag,
                                                  x_uoo_id                     => c_teach_resp_rec.uoo_id,
                                                  x_instructional_load_lab     => l_new_lab,
                                                  x_instructional_load_lecture => l_new_lecture
                                                 );

Line: 158


 END AfterRowUpdate1;

Line: 435


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

Line: 458


      SELECT   rowid
      FROM     igs_ps_usec_cps
      WHERE    unit_sec_credit_points_id = x_unit_sec_credit_points_id
      FOR UPDATE NOWAIT;

Line: 494


      SELECT   rowid
      FROM     igs_ps_usec_cps
      WHERE    uoo_id = x_uoo_id        and      ((l_rowid is null) or (rowid <> l_rowid))

      ;

Line: 529


      SELECT   rowid
      FROM     igs_ps_usec_cps
      WHERE    uoo_id = x_uoo_id ;

Line: 573


    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_claimable_hours IN NUMBER DEFAULT NULL,
    x_achievable_credit_points IN NUMBER ,
    x_enrolled_credit_points IN NUMBER ,
    x_billing_credit_points IN NUMBER,
    x_billing_hrs IN NUMBER
  ) AS
  /*************************************************************
  Created By :  shgeorge
  Date Created By :  10-May-2000
  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_unit_sec_credit_points_id,
      x_uoo_id,
      x_minimum_credit_points,
      x_maximum_credit_points,
      x_variable_increment,
      x_lecture_credit_points,
      x_lab_credit_points,
      x_other_credit_points,
      x_clock_hours,
      x_work_load_cp_lecture,
      x_work_load_cp_lab,
      x_continuing_education_units,
      x_work_load_other,
      x_contact_hrs_lecture,
      x_contact_hrs_lab,
      x_contact_hrs_other,
      x_non_schd_required_hrs,
      x_exclude_from_max_cp_limit,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
      x_claimable_hours,
      x_achievable_credit_points,
      x_enrolled_credit_points ,
      x_billing_credit_points,
      x_billing_hrs
    );

Line: 628


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

Line: 640


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

Line: 646


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

Line: 649


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

Line: 659


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;

Line: 662


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;

Line: 687


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      AfterRowUpdate1 ( p_inserting => TRUE );

Line: 690


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      AfterRowUpdate1 ( p_updating => TRUE );

Line: 693


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

Line: 701


 procedure INSERT_ROW (
       X_ROWID in out NOCOPY VARCHAR2,
       x_UNIT_SEC_CREDIT_POINTS_ID IN OUT NOCOPY NUMBER,
       x_UOO_ID IN NUMBER,
       x_MINIMUM_CREDIT_POINTS IN NUMBER,
       x_MAXIMUM_CREDIT_POINTS IN NUMBER,
       x_VARIABLE_INCREMENT IN NUMBER,
       x_LECTURE_CREDIT_POINTS IN NUMBER,
       x_LAB_CREDIT_POINTS IN NUMBER,
       x_OTHER_CREDIT_POINTS IN NUMBER,
       x_CLOCK_HOURS IN NUMBER,
       x_WORK_LOAD_CP_LECTURE IN NUMBER,
       x_WORK_LOAD_CP_LAB IN NUMBER,
       x_CONTINUING_EDUCATION_UNITS IN NUMBER,
       x_WORK_LOAD_OTHER IN NUMBER DEFAULT NULL,
       x_CONTACT_HRS_LECTURE IN NUMBER DEFAULT NULL,
       x_CONTACT_HRS_LAB IN NUMBER DEFAULT NULL,
       x_CONTACT_HRS_OTHER IN NUMBER DEFAULT NULL,
       x_NON_SCHD_REQUIRED_HRS IN NUMBER DEFAULT NULL,
       x_EXCLUDE_FROM_MAX_CP_LIMIT IN VARCHAR2 DEFAULT NULL,
       X_MODE in VARCHAR2 default 'R'  ,
       x_claimable_hours IN NUMBER DEFAULT NULL,
        x_achievable_credit_points IN NUMBER ,
       x_enrolled_credit_points IN NUMBER ,
       x_billing_credit_points IN NUMBER,
       x_billing_hrs IN NUMBER
  ) AS
  /*************************************************************
  Created By :  shgeorge
  Date Created By :  10-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

    cursor C is select ROWID from IGS_PS_USEC_CPS
             where                 UNIT_SEC_CREDIT_POINTS_ID= X_UNIT_SEC_CREDIT_POINTS_ID
;

Line: 742


     X_LAST_UPDATE_DATE DATE ;

Line: 743


     X_LAST_UPDATED_BY NUMBER ;

Line: 744


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 746


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 748


        X_LAST_UPDATED_BY := 1;

Line: 749


        X_LAST_UPDATE_LOGIN := 0;

Line: 751


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 752


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 755


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 756


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 764


   SELECT
        IGS_PS_USEC_CPS_S.NextVal
   INTO
        x_UNIT_SEC_CREDIT_POINTS_ID
   FROM
        dual;

Line: 771


                p_action=>'INSERT',
                x_rowid=>X_ROWID,
               x_unit_sec_credit_points_id=>X_UNIT_SEC_CREDIT_POINTS_ID,
               x_uoo_id=>X_UOO_ID,
               x_minimum_credit_points=>X_MINIMUM_CREDIT_POINTS,
               x_maximum_credit_points=>X_MAXIMUM_CREDIT_POINTS,
               x_variable_increment=>X_VARIABLE_INCREMENT,
               x_lecture_credit_points=>X_LECTURE_CREDIT_POINTS,
               x_lab_credit_points=>X_LAB_CREDIT_POINTS,
               x_other_credit_points=>X_OTHER_CREDIT_POINTS,
               x_clock_hours=>X_CLOCK_HOURS,
               x_work_load_cp_lecture=>X_WORK_LOAD_CP_LECTURE,
               x_work_load_cp_lab=>X_WORK_LOAD_CP_LAB,
               x_continuing_education_units=>X_CONTINUING_EDUCATION_UNITS,
               x_work_load_other => X_WORK_LOAD_OTHER,
               x_contact_hrs_lecture => X_CONTACT_HRS_LECTURE,
               x_contact_hrs_lab => X_CONTACT_HRS_LAB,
               x_contact_hrs_other => X_CONTACT_HRS_OTHER,
               x_non_schd_required_hrs => X_NON_SCHD_REQUIRED_HRS,
               x_exclude_from_max_cp_limit => X_EXCLUDE_FROM_MAX_CP_LIMIT,
               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_claimable_hours => x_claimable_hours,
              x_achievable_credit_points => x_achievable_credit_points,
              x_enrolled_credit_points => x_enrolled_credit_points,
              x_billing_credit_points => x_billing_credit_points,
              x_billing_hrs => x_billing_hrs
	      );

Line: 803


     insert into IGS_PS_USEC_CPS (
                 UNIT_SEC_CREDIT_POINTS_ID
                ,UOO_ID
                ,MINIMUM_CREDIT_POINTS
                ,MAXIMUM_CREDIT_POINTS
                ,VARIABLE_INCREMENT
                ,LECTURE_CREDIT_POINTS
                ,LAB_CREDIT_POINTS
                ,OTHER_CREDIT_POINTS
                ,CLOCK_HOURS
                ,WORK_LOAD_CP_LECTURE
                ,WORK_LOAD_CP_LAB
                ,CONTINUING_EDUCATION_UNITS
                ,WORK_LOAD_OTHER
                ,CONTACT_HRS_LECTURE
                ,CONTACT_HRS_LAB
                ,CONTACT_HRS_OTHER
                ,NON_SCHD_REQUIRED_HRS
                ,EXCLUDE_FROM_MAX_CP_LIMIT
               ,CREATION_DATE
                ,CREATED_BY
                ,LAST_UPDATE_DATE
                ,LAST_UPDATED_BY
                ,LAST_UPDATE_LOGIN
              ,claimable_hours
              ,achievable_credit_points
              ,enrolled_credit_points
              ,billing_credit_points
	      ,billing_hrs
        ) values  (
                 NEW_REFERENCES.UNIT_SEC_CREDIT_POINTS_ID
                ,NEW_REFERENCES.UOO_ID
                ,NEW_REFERENCES.MINIMUM_CREDIT_POINTS
                ,NEW_REFERENCES.MAXIMUM_CREDIT_POINTS
                ,NEW_REFERENCES.VARIABLE_INCREMENT
                ,NEW_REFERENCES.LECTURE_CREDIT_POINTS
                ,NEW_REFERENCES.LAB_CREDIT_POINTS
                ,NEW_REFERENCES.OTHER_CREDIT_POINTS
                ,NEW_REFERENCES.CLOCK_HOURS
                ,NEW_REFERENCES.WORK_LOAD_CP_LECTURE
                ,NEW_REFERENCES.WORK_LOAD_CP_LAB
                ,NEW_REFERENCES.CONTINUING_EDUCATION_UNITS
                ,NEW_REFERENCES.WORK_LOAD_OTHER
                 ,NEW_REFERENCES.CONTACT_HRS_LECTURE
                 ,NEW_REFERENCES.CONTACT_HRS_LAB
                 ,NEW_REFERENCES.CONTACT_HRS_OTHER
                 ,NEW_REFERENCES.NON_SCHD_REQUIRED_HRS
                 ,NEW_REFERENCES.EXCLUDE_FROM_MAX_CP_LIMIT
                ,X_LAST_UPDATE_DATE
                 ,X_LAST_UPDATED_BY
                 ,X_LAST_UPDATE_DATE
                 ,X_LAST_UPDATED_BY
                 ,X_LAST_UPDATE_LOGIN
               ,new_references.claimable_hours
               ,new_references.achievable_credit_points
               ,new_references.enrolled_credit_points
               ,new_references.billing_credit_points
	       ,new_references.billing_hrs);

Line: 869


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

Line: 871


end INSERT_ROW;

Line: 909


   cursor c1 is select
      UOO_ID
,      MINIMUM_CREDIT_POINTS
,      MAXIMUM_CREDIT_POINTS
,      VARIABLE_INCREMENT
,      LECTURE_CREDIT_POINTS
,      LAB_CREDIT_POINTS
,      OTHER_CREDIT_POINTS
,      CLOCK_HOURS
,      WORK_LOAD_CP_LECTURE
,      WORK_LOAD_CP_LAB
,      CONTINUING_EDUCATION_UNITS
,      WORK_LOAD_OTHER
,      CONTACT_HRS_LECTURE
,      CONTACT_HRS_LAB
,      CONTACT_HRS_OTHER
,      NON_SCHD_REQUIRED_HRS
,      EXCLUDE_FROM_MAX_CP_LIMIT
,      claimable_hours
,      achievable_credit_points
,      enrolled_credit_points
,      billing_credit_points
,      billing_hrs
    from IGS_PS_USEC_CPS
    where ROWID = X_ROWID
    for update nowait;

Line: 940


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

Line: 1021


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_UNIT_SEC_CREDIT_POINTS_ID IN NUMBER,
       x_UOO_ID IN NUMBER,
       x_MINIMUM_CREDIT_POINTS IN NUMBER,
       x_MAXIMUM_CREDIT_POINTS IN NUMBER,
       x_VARIABLE_INCREMENT IN NUMBER,
       x_LECTURE_CREDIT_POINTS IN NUMBER,
       x_LAB_CREDIT_POINTS IN NUMBER,
       x_OTHER_CREDIT_POINTS IN NUMBER,
       x_CLOCK_HOURS IN NUMBER,
       x_WORK_LOAD_CP_LECTURE IN NUMBER,
       x_WORK_LOAD_CP_LAB IN NUMBER,
       x_CONTINUING_EDUCATION_UNITS IN NUMBER,
       x_WORK_LOAD_OTHER IN NUMBER DEFAULT NULL,
       x_CONTACT_HRS_LECTURE IN NUMBER DEFAULT NULL,
       x_CONTACT_HRS_LAB IN NUMBER DEFAULT NULL,
       x_CONTACT_HRS_OTHER IN NUMBER DEFAULT NULL,
       x_NON_SCHD_REQUIRED_HRS IN NUMBER DEFAULT NULL,
       x_EXCLUDE_FROM_MAX_CP_LIMIT IN VARCHAR2 DEFAULT NULL,
       X_MODE in VARCHAR2 default 'R',
       x_claimable_hours IN NUMBER DEFAULT NULL,
       x_achievable_credit_points IN NUMBER,
       x_enrolled_credit_points IN NUMBER  ,
       x_billing_credit_points IN NUMBER ,
       x_billing_hrs IN NUMBER
  ) AS
  /*************************************************************
  Created By :  shgeorge
  Date Created By :  10-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

     X_LAST_UPDATE_DATE DATE ;

Line: 1060


     X_LAST_UPDATED_BY NUMBER ;

Line: 1061


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 1063


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 1065


        X_LAST_UPDATED_BY := 1;

Line: 1066


        X_LAST_UPDATE_LOGIN := 0;

Line: 1068


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1069


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 1072


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 1073


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 1082


                p_action=>'UPDATE',
                x_rowid=>X_ROWID,
               x_unit_sec_credit_points_id=>X_UNIT_SEC_CREDIT_POINTS_ID,
               x_uoo_id=>X_UOO_ID,
               x_minimum_credit_points=>X_MINIMUM_CREDIT_POINTS,
               x_maximum_credit_points=>X_MAXIMUM_CREDIT_POINTS,
               x_variable_increment=>X_VARIABLE_INCREMENT,
               x_lecture_credit_points=>X_LECTURE_CREDIT_POINTS,
               x_lab_credit_points=>X_LAB_CREDIT_POINTS,
               x_other_credit_points=>X_OTHER_CREDIT_POINTS,
               x_clock_hours=>X_CLOCK_HOURS,
               x_work_load_cp_lecture=>X_WORK_LOAD_CP_LECTURE,
               x_work_load_cp_lab=>X_WORK_LOAD_CP_LAB,
               x_continuing_education_units=>X_CONTINUING_EDUCATION_UNITS,
               x_work_load_other => X_WORK_LOAD_OTHER,
               x_contact_hrs_lecture => X_CONTACT_HRS_LECTURE,
               x_contact_hrs_lab => X_CONTACT_HRS_LAB,
               x_contact_hrs_other => X_CONTACT_HRS_OTHER,
               x_non_schd_required_hrs => X_NON_SCHD_REQUIRED_HRS,
               x_exclude_from_max_cp_limit => X_EXCLUDE_FROM_MAX_CP_LIMIT,
               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_claimable_hours=>x_claimable_hours,
              x_achievable_credit_points=>x_achievable_credit_points,
              x_enrolled_credit_points=>x_enrolled_credit_points,
              x_billing_credit_points =>x_billing_credit_points,
              x_billing_hrs => x_billing_hrs
              );

Line: 1115


   update IGS_PS_USEC_CPS set
      UOO_ID =  NEW_REFERENCES.UOO_ID,
      MINIMUM_CREDIT_POINTS =  NEW_REFERENCES.MINIMUM_CREDIT_POINTS,
      MAXIMUM_CREDIT_POINTS =  NEW_REFERENCES.MAXIMUM_CREDIT_POINTS,
      VARIABLE_INCREMENT =  NEW_REFERENCES.VARIABLE_INCREMENT,
      LECTURE_CREDIT_POINTS =  NEW_REFERENCES.LECTURE_CREDIT_POINTS,
      LAB_CREDIT_POINTS =  NEW_REFERENCES.LAB_CREDIT_POINTS,
      OTHER_CREDIT_POINTS =  NEW_REFERENCES.OTHER_CREDIT_POINTS,
      CLOCK_HOURS =  NEW_REFERENCES.CLOCK_HOURS,
      WORK_LOAD_CP_LECTURE =  NEW_REFERENCES.WORK_LOAD_CP_LECTURE,
      WORK_LOAD_CP_LAB =  NEW_REFERENCES.WORK_LOAD_CP_LAB,
      CONTINUING_EDUCATION_UNITS =  NEW_REFERENCES.CONTINUING_EDUCATION_UNITS,
      WORK_LOAD_OTHER = NEW_REFERENCES.WORK_LOAD_OTHER,
      CONTACT_HRS_LECTURE = NEW_REFERENCES.CONTACT_HRS_LECTURE,
      CONTACT_HRS_LAB = NEW_REFERENCES.CONTACT_HRS_LAB,
      CONTACT_HRS_OTHER = NEW_REFERENCES.CONTACT_HRS_OTHER,
      NON_SCHD_REQUIRED_HRS = NEW_REFERENCES.NON_SCHD_REQUIRED_HRS,
      EXCLUDE_FROM_MAX_CP_LIMIT = NEW_REFERENCES.EXCLUDE_FROM_MAX_CP_LIMIT,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
      claimable_hours = new_references.claimable_hours,
      achievable_credit_points = new_references.achievable_credit_points,
      enrolled_credit_points = new_references.enrolled_credit_points ,
      billing_credit_points = new_references.billing_credit_points,
      billing_hrs = new_references.billing_hrs
  where ROWID = X_ROWID;

Line: 1147


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

Line: 1150


end UPDATE_ROW;

Line: 1190


    cursor c1 is select ROWID from IGS_PS_USEC_CPS
             where     UNIT_SEC_CREDIT_POINTS_ID= X_UNIT_SEC_CREDIT_POINTS_ID
;

Line: 1198


    INSERT_ROW (
       X_ROWID,
       X_UNIT_SEC_CREDIT_POINTS_ID,
       X_UOO_ID,
       X_MINIMUM_CREDIT_POINTS,
       X_MAXIMUM_CREDIT_POINTS,
       X_VARIABLE_INCREMENT,
       X_LECTURE_CREDIT_POINTS,
       X_LAB_CREDIT_POINTS,
       X_OTHER_CREDIT_POINTS,
       X_CLOCK_HOURS,
       X_WORK_LOAD_CP_LECTURE,
       X_WORK_LOAD_CP_LAB,
       X_CONTINUING_EDUCATION_UNITS,
       x_WORK_LOAD_OTHER ,
       x_CONTACT_HRS_LECTURE ,
       x_CONTACT_HRS_LAB ,
       x_CONTACT_HRS_OTHER ,
       x_NON_SCHD_REQUIRED_HRS ,
       x_EXCLUDE_FROM_MAX_CP_LIMIT ,
       X_MODE,
       x_claimable_hours,
       x_achievable_credit_points,
       x_enrolled_credit_points,
       x_billing_credit_points,
       x_billing_hrs );

Line: 1227


UPDATE_ROW (
      X_ROWID,
       X_UNIT_SEC_CREDIT_POINTS_ID,
       X_UOO_ID,
       X_MINIMUM_CREDIT_POINTS,
       X_MAXIMUM_CREDIT_POINTS,
       X_VARIABLE_INCREMENT,
       X_LECTURE_CREDIT_POINTS,
       X_LAB_CREDIT_POINTS,
       X_OTHER_CREDIT_POINTS,
       X_CLOCK_HOURS,
       X_WORK_LOAD_CP_LECTURE,
       X_WORK_LOAD_CP_LAB,
       X_CONTINUING_EDUCATION_UNITS,
       x_WORK_LOAD_OTHER ,
       x_CONTACT_HRS_LECTURE ,
       x_CONTACT_HRS_LAB ,
       x_CONTACT_HRS_OTHER ,
       x_NON_SCHD_REQUIRED_HRS ,
       x_EXCLUDE_FROM_MAX_CP_LIMIT ,
       X_MODE,
       x_claimable_hours,
       x_achievable_credit_points,
       x_enrolled_credit_points,
       x_billing_credit_points,
       x_billing_hrs);

Line: 1255


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
  /*************************************************************
  Created By :  shgeorge
  Date Created By :  10-May-2000
  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: 1274


 delete from IGS_PS_USEC_CPS
 where ROWID = X_ROWID;

Line: 1280


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

Line: 1283


END DELETE_ROW;