DBA Data[Home] [Help]

APPS.IGS_EN_TIMESLOT_STUP_PKG SQL Statements

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

Line: 19

    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_org_id 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_EN_TIMESLOT_STUP
      WHERE    rowid = x_rowid;
Line: 49

    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      CLOSE cur_old_ref_values;
Line: 51

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

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

    new_references.last_update_date := x_last_update_date;
Line: 74

    new_references.last_updated_by := x_last_updated_by;
Line: 75

    new_references.last_update_login := x_last_update_login;
Line: 165

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

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

      SELECT   rowid
      FROM     igs_en_timeslot_stup
      WHERE    igs_en_timeslot_stup_id = x_igs_en_timeslot_stup_id
      FOR UPDATE NOWAIT;
Line: 258

      SELECT   rowid
      FROM     igs_en_timeslot_stup
      WHERE    program_type_group_cd = x_program_type_group_cd
      AND      cal_type = x_cal_type
      AND      sequence_number = x_sequence_number
      AND      student_type = x_student_type 	and      ((l_rowid is null) or (rowid <> l_rowid))

      ;
Line: 297

      SELECT   rowid
      FROM     igs_en_timeslot_stup
      WHERE    cal_type = x_cal_type
      AND      sequence_number = x_sequence_number ;
Line: 335

      SELECT   rowid
      FROM     igs_en_timeslot_stup
      WHERE    program_type_group_cd = x_course_type_group_cd ;
Line: 368

    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_org_id 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_sequence_number,
      x_student_type,
      x_assign_randomly,
      x_surname_alphabet,
      x_cal_type,
      x_igs_en_timeslot_stup_id,
      x_program_type_group_cd,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
      x_org_id
    );
Line: 405

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

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

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

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	 -- Call all the procedures related to Before Insert.
      IF get_pk_for_validation (
    		new_references.igs_en_timeslot_stup_id)  THEN
	       fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
Line: 437

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      check_uniqueness;
Line: 440

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      check_child_existance;
Line: 465

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

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

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

 PROCEDURE insert_row (
      x_rowid IN OUT NOCOPY VARCHAR2,
       x_sequence_number IN NUMBER,
       x_student_type IN VARCHAR2,
       x_assign_randomly IN VARCHAR2,
       x_surname_alphabet IN VARCHAR2,
       x_cal_type IN VARCHAR2,
       x_igs_en_timeslot_stup_id IN OUT NOCOPY NUMBER,
       x_program_type_group_cd IN VARCHAR2,
       x_mode IN VARCHAR2 DEFAULT 'R'  ,
       X_ORG_ID in NUMBER

  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  pradhakr	23-Jul-2002	Assigned igs_ge_gen_003.get_org_id to x_org_id in
				before dml as part of bug# 2457599
  ***************************************************************/

    CURSOR c IS SELECT ROWID FROM igs_en_timeslot_stup
             WHERE                 igs_en_timeslot_stup_id= x_igs_en_timeslot_stup_id
;
Line: 507

     x_last_update_date DATE ;
Line: 508

     x_last_updated_by NUMBER ;
Line: 509

     x_last_update_login NUMBER ;
Line: 511

     x_last_update_date := SYSDATE;
Line: 513

        x_last_updated_by := 1;
Line: 514

        x_last_update_login := 0;
Line: 516

               x_last_updated_by := fnd_global.user_id;
Line: 517

            IF x_last_updated_by IS NULL then
                x_last_updated_by := -1;
Line: 520

            x_last_update_login := fnd_global.login_id;
Line: 521

         IF x_last_update_login IS NULL THEN
            x_last_update_login := -1;
Line: 530

     select igs_en_timeslot_stup_s.nextval into x_igs_en_timeslot_stup_id from dual;
Line: 533

 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_sequence_number=>x_sequence_number,
 	       x_student_type=>x_student_type,
 	       x_assign_randomly=>x_assign_randomly,
 	       x_surname_alphabet=>x_surname_alphabet,
 	       x_cal_type=>x_cal_type,
 	       x_igs_en_timeslot_stup_id=>x_igs_en_timeslot_stup_id,
 	       x_program_type_group_cd=>x_program_type_group_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_org_id => igs_ge_gen_003.get_org_id );
Line: 548

     INSERT INTO igs_en_timeslot_stup (
		sequence_number
		,student_type
		,assign_randomly
		,surname_alphabet
		,cal_type
		,igs_en_timeslot_stup_id
		,program_type_group_cd
	        ,creation_date
		,created_by
		,last_update_date
		,last_updated_by
		,last_update_login
	      ,ORG_ID
        ) VALUES  (
	        new_references.sequence_number
	        ,new_references.student_type
	        ,new_references.assign_randomly
	        ,new_references.surname_alphabet
	        ,new_references.cal_type
	        ,new_references.igs_en_timeslot_stup_id
	        ,new_references.program_type_group_cd
	        ,x_last_update_date
		,x_last_updated_by
		,x_last_update_date
		,x_last_updated_by
		,x_last_update_login
 		,NEW_REFERENCES.ORG_ID );
Line: 584

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

END insert_row;
Line: 607

   CURSOR c1 IS SELECT
      sequence_number
,      student_type
,      assign_randomly
,      surname_alphabet
,      cal_type
,      program_type_group_cd
    FROM igs_en_timeslot_stup
    WHERE ROWID = x_rowid
    FOR UPDATE NOWAIT;
Line: 622

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

 PROCEDURE update_row (
    x_rowid IN  VARCHAR2,
    x_SEQUENCE_NUMBER IN NUMBER,
    x_STUDENT_TYPE IN VARCHAR2,
    x_ASSIGN_RANDOMLY IN VARCHAR2,
    x_SURNAME_ALPHABET IN VARCHAR2,
    x_CAL_TYPE IN VARCHAR2,
    x_IGS_EN_TIMESLOT_STUP_ID IN NUMBER,
    x_PROGRAM_TYPE_GROUP_CD IN VARCHAR2,
    x_mode IN VARCHAR2 DEFAULT 'R'
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

     x_last_update_date DATE ;
Line: 669

     x_last_updated_by NUMBER ;
Line: 670

     x_last_update_login NUMBER ;
Line: 672

     x_last_update_date := SYSDATE;
Line: 674

        x_last_updated_by := 1;
Line: 675

        x_last_update_login := 0;
Line: 677

               x_last_updated_by := fnd_global.user_id;
Line: 678

            IF x_last_updated_by IS NULL THEN
                x_last_updated_by := -1;
Line: 681

            x_last_update_login := fnd_global.login_id;
Line: 682

         IF x_last_update_login IS NULL THEN
            x_last_update_login := -1;
Line: 691

 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_sequence_number=>X_SEQUENCE_NUMBER,
 	       x_student_type=>X_STUDENT_TYPE,
 	       x_assign_randomly=>X_ASSIGN_RANDOMLY,
 	       x_surname_alphabet=>X_SURNAME_ALPHABET,
 	       x_cal_type=>X_CAL_TYPE,
 	       x_igs_en_timeslot_stup_id=>X_IGS_EN_TIMESLOT_STUP_ID,
 	       x_program_type_group_cd=>X_PROGRAM_TYPE_GROUP_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);
Line: 705

   UPDATE igs_en_timeslot_stup SET
      sequence_number =  NEW_REFERENCES.sequence_number,
      student_type =  NEW_REFERENCES.student_type,
      assign_randomly =  NEW_REFERENCES.assign_randomly,
      surname_alphabet =  NEW_REFERENCES.surname_alphabet,
      cal_type =  NEW_REFERENCES.cal_type,
      program_type_group_cd =  NEW_REFERENCES.program_type_group_cd,
	last_update_date = x_last_update_date,
	last_updated_by = x_last_updated_by,
	last_update_login = x_last_update_login
	  WHERE ROWID = x_rowid;
Line: 721

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

END update_row;
Line: 748

    CURSOR c1 IS SELECT ROWID FROM igs_en_timeslot_stup
             WHERE     igs_en_timeslot_stup_id= x_igs_en_timeslot_stup_id
;
Line: 756

    insert_row (
      x_rowid,
       X_sequence_number,
       X_student_type,
       X_assign_randomly,
       X_surname_alphabet,
       X_cal_type,
       X_igs_en_timeslot_stup_id,
       X_program_type_group_cd,
       x_mode ,
       X_ORG_ID);
Line: 771

update_row (
      x_rowid,
       x_sequence_number,
       x_student_type,
       x_assign_randomly,
       x_surname_alphabet,
       x_cal_type,
       x_igs_en_timeslot_stup_id,
       x_program_type_group_cd,
       x_mode );
Line: 782

PROCEDURE delete_row (
  x_rowid 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: 801

 DELETE FROM igs_en_timeslot_stup
 WHERE ROWID = x_rowid;
Line: 807

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

END delete_row;