DBA Data[Home] [Help]

APPS.IGS_ST_GVT_STDNT_LBL_PKG SQL Statements

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

Line: 34

    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

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_ST_GVT_STDNT_LBL
      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: 83

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

    new_references.last_update_date := x_last_update_date;
Line: 91

    new_references.last_updated_by := x_last_updated_by;
Line: 92

    new_references.last_update_login := x_last_update_login;
Line: 96

  PROCEDURE BeforeRowInsertUpdateDelete1(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) AS
	v_message_name VARCHAR2(30);
Line: 106

	IF p_inserting THEN
		v_transaction_type := 'p_inserting';
Line: 129

  END BeforeRowInsertUpdateDelete1;
Line: 224

	Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
Line: 241

      SELECT   rowid
      FROM     IGS_ST_GVT_STDNT_LBL
      WHERE    submission_yr = x_submission_yr
      AND      submission_number = x_submission_number
      AND      person_id = x_person_id
      AND      course_cd = x_course_cd
      AND      govt_semester = x_govt_semester
      FOR UPDATE NOWAIT;
Line: 273

      SELECT   rowid
      FROM     IGS_ST_GVT_STDNT_LBL
      WHERE    submission_yr = x_submission_yr
      AND      submission_number = x_submission_number
      AND      govt_semester = x_govt_semester ;
Line: 322

    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
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_submission_yr,
      x_submission_number,
      x_person_id,
      x_course_cd,
      x_version_number,
      x_govt_semester,
      x_hecs_payment_option,
      x_govt_hecs_payment_option,
      x_total_eftsu,
      x_industrial_eftsu,
      x_hecs_prexmt_exie,
      x_hecs_amount_paid,
      x_tuition_fee,
      x_differential_hecs_ind,
      x_birth_dt,
      x_sex,
      x_citizenship_cd,
      x_govt_citizenship_cd,
      x_perm_resident_cd,
      x_govt_perm_resident_cd,
      x_commencement_dt,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );
Line: 359

    IF (p_action = 'INSERT') THEN
      BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE );
Line: 374

    ELSIF (p_action = 'UPDATE') THEN
      BeforeRowInsertUpdateDelete1 ( p_updating => TRUE );
Line: 378

    ELSIF (p_action = 'DELETE') THEN
      BeforeRowInsertUpdateDelete1 ( p_deleting => TRUE );
Line: 380

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	IF Get_PK_For_Validation (
		new_references.submission_yr,
		new_references.submission_number,
		new_references.person_id,
		new_references.course_cd,
		new_references.govt_semester
	) THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
Line: 393

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
	Check_Constraints;
Line: 395

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;
Line: 409

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_SUBMISSION_YR in NUMBER,
  X_SUBMISSION_NUMBER in NUMBER,
  X_PERSON_ID in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_GOVT_SEMESTER in NUMBER,
  X_VERSION_NUMBER in NUMBER,
  X_HECS_PAYMENT_OPTION in VARCHAR2,
  X_GOVT_HECS_PAYMENT_OPTION in VARCHAR2,
  X_TOTAL_EFTSU in NUMBER,
  X_INDUSTRIAL_EFTSU in NUMBER,
  X_HECS_PREXMT_EXIE in NUMBER,
  X_HECS_AMOUNT_PAID in NUMBER,
  X_TUITION_FEE in NUMBER,
  X_DIFFERENTIAL_HECS_IND in VARCHAR2,
  X_BIRTH_DT in DATE,
  X_SEX in VARCHAR2,
  X_CITIZENSHIP_CD in VARCHAR2,
  X_GOVT_CITIZENSHIP_CD in NUMBER,
  X_PERM_RESIDENT_CD in VARCHAR2,
  X_GOVT_PERM_RESIDENT_CD in NUMBER,
  X_COMMENCEMENT_DT in DATE,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_ST_GVT_STDNT_LBL
      where SUBMISSION_YR = X_SUBMISSION_YR
      and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
      and PERSON_ID = X_PERSON_ID
      and COURSE_CD = X_COURSE_CD
      and GOVT_SEMESTER = X_GOVT_SEMESTER;
Line: 440

    X_LAST_UPDATE_DATE DATE;
Line: 441

    X_LAST_UPDATED_BY NUMBER;
Line: 442

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 446

    X_PROGRAM_UPDATE_DATE DATE;
Line: 449

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 451

    X_LAST_UPDATED_BY := 1;
Line: 452

    X_LAST_UPDATE_LOGIN := 0;
Line: 454

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 455

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 458

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 459

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 469

      X_PROGRAM_UPDATE_DATE := NULL;
Line: 471

      X_PROGRAM_UPDATE_DATE := SYSDATE;
Line: 479

     p_action => 'INSERT',
     x_rowid => X_ROWID,
     x_submission_yr => X_SUBMISSION_YR,
     x_submission_number => X_SUBMISSION_NUMBER,
     x_person_id => X_PERSON_ID,
     x_course_cd => X_COURSE_CD,
     x_version_number => X_VERSION_NUMBER,
     x_govt_semester => X_GOVT_SEMESTER,
     x_hecs_payment_option => X_HECS_PAYMENT_OPTION,
     x_govt_hecs_payment_option => X_GOVT_HECS_PAYMENT_OPTION,
     x_total_eftsu => X_TOTAL_EFTSU,
     x_industrial_eftsu => X_INDUSTRIAL_EFTSU,
     x_hecs_prexmt_exie => X_HECS_PREXMT_EXIE,
     x_hecs_amount_paid => X_HECS_AMOUNT_PAID,
     x_tuition_fee => X_TUITION_FEE,
     x_differential_hecs_ind => X_DIFFERENTIAL_HECS_IND,
     x_birth_dt => X_BIRTH_DT,
     x_sex => X_SEX,
     x_citizenship_cd => X_CITIZENSHIP_CD,
     x_govt_citizenship_cd => X_GOVT_CITIZENSHIP_CD,
     x_perm_resident_cd => X_PERM_RESIDENT_CD,
     x_govt_perm_resident_cd => X_GOVT_PERM_RESIDENT_CD,
     x_commencement_dt => X_COMMENCEMENT_DT,
     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: 509

  insert into IGS_ST_GVT_STDNT_LBL (
    SUBMISSION_YR,
    SUBMISSION_NUMBER,
    PERSON_ID,
    COURSE_CD,
    VERSION_NUMBER,
    GOVT_SEMESTER,
    HECS_PAYMENT_OPTION,
    GOVT_HECS_PAYMENT_OPTION,
    TOTAL_EFTSU,
    INDUSTRIAL_EFTSU,
    HECS_PREXMT_EXIE,
    HECS_AMOUNT_PAID,
    TUITION_FEE,
    DIFFERENTIAL_HECS_IND,
    BIRTH_DT,
    SEX,
    CITIZENSHIP_CD,
    GOVT_CITIZENSHIP_CD,
    PERM_RESIDENT_CD,
    GOVT_PERM_RESIDENT_CD,
    COMMENCEMENT_DT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE
  ) values (
    NEW_REFERENCES.SUBMISSION_YR,
    NEW_REFERENCES.SUBMISSION_NUMBER,
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.COURSE_CD,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.GOVT_SEMESTER,
    NEW_REFERENCES.HECS_PAYMENT_OPTION,
    NEW_REFERENCES.GOVT_HECS_PAYMENT_OPTION,
    NEW_REFERENCES.TOTAL_EFTSU,
    NEW_REFERENCES.INDUSTRIAL_EFTSU,
    NEW_REFERENCES.HECS_PREXMT_EXIE,
    NEW_REFERENCES.HECS_AMOUNT_PAID,
    NEW_REFERENCES.TUITION_FEE,
    NEW_REFERENCES.DIFFERENTIAL_HECS_IND,
    NEW_REFERENCES.BIRTH_DT,
    NEW_REFERENCES.SEX,
    NEW_REFERENCES.CITIZENSHIP_CD,
    NEW_REFERENCES.GOVT_CITIZENSHIP_CD,
    NEW_REFERENCES.PERM_RESIDENT_CD,
    NEW_REFERENCES.GOVT_PERM_RESIDENT_CD,
    NEW_REFERENCES.COMMENCEMENT_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
  );
Line: 582

     p_action => 'INSERT',
     x_rowid => X_ROWID
    );
Line: 585

end INSERT_ROW;
Line: 611

  cursor c1 is select
      VERSION_NUMBER,
      HECS_PAYMENT_OPTION,
      GOVT_HECS_PAYMENT_OPTION,
      TOTAL_EFTSU,
      INDUSTRIAL_EFTSU,
      HECS_PREXMT_EXIE,
      HECS_AMOUNT_PAID,
      TUITION_FEE,
      DIFFERENTIAL_HECS_IND,
      BIRTH_DT,
      SEX,
      CITIZENSHIP_CD,
      GOVT_CITIZENSHIP_CD,
      PERM_RESIDENT_CD,
      GOVT_PERM_RESIDENT_CD,
      COMMENCEMENT_DT
    from IGS_ST_GVT_STDNT_LBL
    where ROWID = X_ROWID for update nowait;
Line: 637

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Line: 672

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_SUBMISSION_YR in NUMBER,
  X_SUBMISSION_NUMBER in NUMBER,
  X_PERSON_ID in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_GOVT_SEMESTER in NUMBER,
  X_VERSION_NUMBER in NUMBER,
  X_HECS_PAYMENT_OPTION in VARCHAR2,
  X_GOVT_HECS_PAYMENT_OPTION in VARCHAR2,
  X_TOTAL_EFTSU in NUMBER,
  X_INDUSTRIAL_EFTSU in NUMBER,
  X_HECS_PREXMT_EXIE in NUMBER,
  X_HECS_AMOUNT_PAID in NUMBER,
  X_TUITION_FEE in NUMBER,
  X_DIFFERENTIAL_HECS_IND in VARCHAR2,
  X_BIRTH_DT in DATE,
  X_SEX in VARCHAR2,
  X_CITIZENSHIP_CD in VARCHAR2,
  X_GOVT_CITIZENSHIP_CD in NUMBER,
  X_PERM_RESIDENT_CD in VARCHAR2,
  X_GOVT_PERM_RESIDENT_CD in NUMBER,
  X_COMMENCEMENT_DT in DATE,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;
Line: 698

    X_LAST_UPDATED_BY NUMBER;
Line: 699

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 703

    X_PROGRAM_UPDATE_DATE DATE;
Line: 706

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 708

    X_LAST_UPDATED_BY := 1;
Line: 709

    X_LAST_UPDATE_LOGIN := 0;
Line: 711

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 712

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 715

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 716

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 725

     p_action => 'UPDATE',
     x_rowid => X_ROWID,
     x_submission_yr => X_SUBMISSION_YR,
     x_submission_number => X_SUBMISSION_NUMBER,
     x_person_id => X_PERSON_ID,
     x_course_cd => X_COURSE_CD,
     x_version_number => X_VERSION_NUMBER,
     x_govt_semester => X_GOVT_SEMESTER,
     x_hecs_payment_option => X_HECS_PAYMENT_OPTION,
     x_govt_hecs_payment_option => X_GOVT_HECS_PAYMENT_OPTION,
     x_total_eftsu => X_TOTAL_EFTSU,
     x_industrial_eftsu => X_INDUSTRIAL_EFTSU,
     x_hecs_prexmt_exie => X_HECS_PREXMT_EXIE,
     x_hecs_amount_paid => X_HECS_AMOUNT_PAID,
     x_tuition_fee => X_TUITION_FEE,
     x_differential_hecs_ind => X_DIFFERENTIAL_HECS_IND,
     x_birth_dt => X_BIRTH_DT,
     x_sex => X_SEX,
     x_citizenship_cd => X_CITIZENSHIP_CD,
     x_govt_citizenship_cd => X_GOVT_CITIZENSHIP_CD,
     x_perm_resident_cd => X_PERM_RESIDENT_CD,
     x_govt_perm_resident_cd => X_GOVT_PERM_RESIDENT_CD,
     x_commencement_dt => X_COMMENCEMENT_DT,
     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: 762

      X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;
Line: 764

      X_PROGRAM_UPDATE_DATE := SYSDATE;
Line: 768

  update IGS_ST_GVT_STDNT_LBL set
    VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
    HECS_PAYMENT_OPTION = NEW_REFERENCES.HECS_PAYMENT_OPTION,
    GOVT_HECS_PAYMENT_OPTION = NEW_REFERENCES.GOVT_HECS_PAYMENT_OPTION,
    TOTAL_EFTSU = NEW_REFERENCES.TOTAL_EFTSU,
    INDUSTRIAL_EFTSU = NEW_REFERENCES.INDUSTRIAL_EFTSU,
    HECS_PREXMT_EXIE = NEW_REFERENCES.HECS_PREXMT_EXIE,
    HECS_AMOUNT_PAID = NEW_REFERENCES.HECS_AMOUNT_PAID,
    TUITION_FEE = NEW_REFERENCES.TUITION_FEE,
    DIFFERENTIAL_HECS_IND = NEW_REFERENCES.DIFFERENTIAL_HECS_IND,
    BIRTH_DT = NEW_REFERENCES.BIRTH_DT,
    SEX = NEW_REFERENCES.SEX,
    CITIZENSHIP_CD = NEW_REFERENCES.CITIZENSHIP_CD,
    GOVT_CITIZENSHIP_CD = NEW_REFERENCES.GOVT_CITIZENSHIP_CD,
    PERM_RESIDENT_CD = NEW_REFERENCES.PERM_RESIDENT_CD,
    GOVT_PERM_RESIDENT_CD = NEW_REFERENCES.GOVT_PERM_RESIDENT_CD,
    COMMENCEMENT_DT = NEW_REFERENCES.COMMENCEMENT_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
  where ROWID = X_ROWID
  ;
Line: 798

     p_action => 'UPDATE',
     x_rowid => X_ROWID
    );
Line: 801

end UPDATE_ROW;
Line: 828

  cursor c1 is select rowid from IGS_ST_GVT_STDNT_LBL
     where SUBMISSION_YR = X_SUBMISSION_YR
     and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
     and PERSON_ID = X_PERSON_ID
     and COURSE_CD = X_COURSE_CD
     and GOVT_SEMESTER = X_GOVT_SEMESTER
  ;
Line: 840

    INSERT_ROW (
     X_ROWID,
     X_SUBMISSION_YR,
     X_SUBMISSION_NUMBER,
     X_PERSON_ID,
     X_COURSE_CD,
     X_GOVT_SEMESTER,
     X_VERSION_NUMBER,
     X_HECS_PAYMENT_OPTION,
     X_GOVT_HECS_PAYMENT_OPTION,
     X_TOTAL_EFTSU,
     X_INDUSTRIAL_EFTSU,
     X_HECS_PREXMT_EXIE,
     X_HECS_AMOUNT_PAID,
     X_TUITION_FEE,
     X_DIFFERENTIAL_HECS_IND,
     X_BIRTH_DT,
     X_SEX,
     X_CITIZENSHIP_CD,
     X_GOVT_CITIZENSHIP_CD,
     X_PERM_RESIDENT_CD,
     X_GOVT_PERM_RESIDENT_CD,
     X_COMMENCEMENT_DT,
     X_MODE);
Line: 867

  UPDATE_ROW (
   X_ROWID,
   X_SUBMISSION_YR,
   X_SUBMISSION_NUMBER,
   X_PERSON_ID,
   X_COURSE_CD,
   X_GOVT_SEMESTER,
   X_VERSION_NUMBER,
   X_HECS_PAYMENT_OPTION,
   X_GOVT_HECS_PAYMENT_OPTION,
   X_TOTAL_EFTSU,
   X_INDUSTRIAL_EFTSU,
   X_HECS_PREXMT_EXIE,
   X_HECS_AMOUNT_PAID,
   X_TUITION_FEE,
   X_DIFFERENTIAL_HECS_IND,
   X_BIRTH_DT,
   X_SEX,
   X_CITIZENSHIP_CD,
   X_GOVT_CITIZENSHIP_CD,
   X_PERM_RESIDENT_CD,
   X_GOVT_PERM_RESIDENT_CD,
   X_COMMENCEMENT_DT,
   X_MODE);
Line: 893

procedure DELETE_ROW (
   X_ROWID in VARCHAR2
) AS
begin
  Before_DML (
     p_action => 'DELETE',
     x_rowid => X_ROWID
  );
Line: 901

  delete from IGS_ST_GVT_STDNT_LBL
  where ROWID = X_ROWID;
Line: 907

     p_action => 'DELETE',
     x_rowid => X_ROWID
  );
Line: 910

end DELETE_ROW;