DBA Data[Home] [Help]

APPS.IGS_AD_TEST_SEGMENTS_PKG SQL Statements

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

Line: 28

    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_segment_type IN VARCHAR2 DEFAULT NULL,
    x_segment_group IN NUMBER DEFAULT NULL
  ) AS

  /*************************************************************
  Created By :samaresh.in
  Date Created By :15-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_AD_TEST_SEGMENTS
      WHERE    rowid = x_rowid;
Line: 59

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

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

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

    new_references.last_update_date := x_last_update_date;
Line: 95

    new_references.last_updated_by := x_last_updated_by;
Line: 96

    new_references.last_update_login := x_last_update_login;
Line: 334

  Purpose : When record is deleted from the master table IGS_AD_TEST_TYPE
            The corresponding detail IGS_AD_TEST_SEGMENTS are not checked
            for dependency. To implement the dependency check this procedure
            is added here and is being called from IGS_AD_TEST_TYPE_PKG.
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

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

    CURSOR cur_rowid IS
      SELECT   rowid
      FROM     IGS_AD_TEST_SEGMENTS
      WHERE    admission_test_type = x_admission_test_type ;
Line: 386

      SELECT   rowid
      FROM     igs_ad_test_segments
      WHERE    test_segment_id = x_test_segment_id AND
               closed_ind = NVL(x_closed_ind,closed_ind)
      FOR UPDATE NOWAIT;
Line: 425

      SELECT   rowid
      FROM     igs_ad_test_segments
      WHERE    admission_test_type = x_admission_test_type
      AND      test_segment_name = x_test_segment_name 	AND
              ((l_rowid is null) or (rowid <> l_rowid)) AND
               closed_ind = NVL(x_closed_ind,closed_ind) ;
Line: 464

      SELECT   rowid
      FROM     igs_ad_test_segments
      WHERE    admission_test_type = x_admission_test_type AND
               ((l_rowid is null) or (rowid <> l_rowid)) AND
               segment_group = x_segment_group AND
               segment_type = 'SCORE' ;
Line: 507

    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_segment_type IN VARCHAR2 DEFAULT NULL,
    x_segment_group IN NUMBER DEFAULT NULL
  ) AS
  /*************************************************************
  Created By :samaresh.in
  Date Created By :15-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_min_score,
      x_max_score,
      x_include_in_comp_score,
      x_score_ind,
      x_percentile_ind,
      x_national_percentile_ind,
      x_state_percentile_ind,
      x_percentile_year_rank_ind,
      x_score_band_upper_ind,
      x_score_band_lower_ind,
      x_irregularity_code_ind,
      x_test_segment_id,
      x_admission_test_type,
      x_test_segment_name,
      x_description,
      x_closed_ind,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_segment_type,
      x_segment_group
    );
Line: 554

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

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

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

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

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;
Line: 587

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;
Line: 612

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

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

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

 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_MIN_SCORE IN NUMBER,
       x_MAX_SCORE IN NUMBER,
       x_INCLUDE_IN_COMP_SCORE IN VARCHAR2,
       x_SCORE_IND IN VARCHAR2,
       x_PERCENTILE_IND IN VARCHAR2,
       x_NATIONAL_PERCENTILE_IND IN VARCHAR2,
       x_STATE_PERCENTILE_IND IN VARCHAR2,
       x_PERCENTILE_YEAR_RANK_IND IN VARCHAR2,
       x_SCORE_BAND_UPPER_IND IN VARCHAR2,
       x_SCORE_BAND_LOWER_IND IN VARCHAR2,
       x_IRREGULARITY_CODE_IND IN VARCHAR2,
       x_TEST_SEGMENT_ID IN OUT NOCOPY NUMBER,
       x_ADMISSION_TEST_TYPE IN VARCHAR2,
       x_TEST_SEGMENT_NAME IN VARCHAR2,
       x_DESCRIPTION IN VARCHAR2,
       x_CLOSED_IND IN VARCHAR2,
       X_MODE in VARCHAR2,
       X_SEGMENT_TYPE IN VARCHAR2 ,
       X_SEGMENT_GROUP IN NUMBER
  ) AS
  /*************************************************************
  Created By :samaresh.in
  Date Created By :15-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_AD_TEST_SEGMENTS
      WHERE TEST_SEGMENT_ID= X_TEST_SEGMENT_ID;
Line: 664

    X_LAST_UPDATE_DATE DATE ;
Line: 665

    X_LAST_UPDATED_BY NUMBER ;
Line: 666

    X_LAST_UPDATE_LOGIN NUMBER ;
Line: 672

    X_LAST_UPDATE_DATE := SYSDATE;
Line: 675

        X_LAST_UPDATED_BY := 1;
Line: 676

        X_LAST_UPDATE_LOGIN := 0;
Line: 678

               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 679

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

            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 683

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

 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_min_score=>X_MIN_SCORE,
 	       x_max_score=>X_MAX_SCORE,
 	       x_include_in_comp_score=>NVL(X_INCLUDE_IN_COMP_SCORE,'N' ),
 	       x_score_ind=>NVL(X_SCORE_IND,'N' ),
 	       x_percentile_ind=>NVL(X_PERCENTILE_IND,'N' ),
 	       x_national_percentile_ind=>NVL(X_NATIONAL_PERCENTILE_IND,'N' ),
 	       x_state_percentile_ind=>NVL(X_STATE_PERCENTILE_IND,'N' ),
 	       x_percentile_year_rank_ind=>NVL(X_PERCENTILE_YEAR_RANK_IND,'N' ),
 	       x_score_band_upper_ind=>NVL(X_SCORE_BAND_UPPER_IND,'N' ),
 	       x_score_band_lower_ind=>NVL(X_SCORE_BAND_LOWER_IND,'N' ),
 	       x_irregularity_code_ind=>NVL(X_IRREGULARITY_CODE_IND,'N' ),
 	       x_test_segment_id=>X_TEST_SEGMENT_ID,
 	       x_admission_test_type=>X_ADMISSION_TEST_TYPE,
 	       x_test_segment_name=>X_TEST_SEGMENT_NAME,
 	       x_description=>X_DESCRIPTION,
 	       x_closed_ind=>NVL(X_CLOSED_IND,'N' ),
 	       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_segment_type => x_segment_type,
         x_segment_group => x_segment_group);
Line: 724

 INSERT INTO IGS_AD_TEST_SEGMENTS (
       		MIN_SCORE
      		,MAX_SCORE
    				,INCLUDE_IN_COMP_SCORE
    				,SCORE_IND
    				,PERCENTILE_IND
    				,NATIONAL_PERCENTILE_IND
    				,STATE_PERCENTILE_IND
    				,PERCENTILE_YEAR_RANK_IND
    				,SCORE_BAND_UPPER_IND
    				,SCORE_BAND_LOWER_IND
    				,IRREGULARITY_CODE_IND
    				,TEST_SEGMENT_ID
    				,ADMISSION_TEST_TYPE
    				,TEST_SEGMENT_NAME
    				,DESCRIPTION
    				,CLOSED_IND
	       ,CREATION_DATE
      		,CREATED_BY
      		,LAST_UPDATE_DATE
      		,LAST_UPDATED_BY
      		,LAST_UPDATE_LOGIN
        ,SEGMENT_TYPE
        ,SEGMENT_GROUP
        ) values  (
	       	NEW_REFERENCES.MIN_SCORE
	       ,NEW_REFERENCES.MAX_SCORE
	       ,NEW_REFERENCES.INCLUDE_IN_COMP_SCORE
	       ,NEW_REFERENCES.SCORE_IND
	       ,NEW_REFERENCES.PERCENTILE_IND
	       ,NEW_REFERENCES.NATIONAL_PERCENTILE_IND
	       ,NEW_REFERENCES.STATE_PERCENTILE_IND
	       ,NEW_REFERENCES.PERCENTILE_YEAR_RANK_IND
	       ,NEW_REFERENCES.SCORE_BAND_UPPER_IND
	       ,NEW_REFERENCES.SCORE_BAND_LOWER_IND
	       ,NEW_REFERENCES.IRREGULARITY_CODE_IND
	       ,IGS_AD_TEST_SEGMENTS_S.NEXTVAL
	       ,NEW_REFERENCES.ADMISSION_TEST_TYPE
	       ,NEW_REFERENCES.TEST_SEGMENT_NAME
	       ,NEW_REFERENCES.DESCRIPTION
	       ,NEW_REFERENCES.CLOSED_IND
	       ,X_LAST_UPDATE_DATE
      		,X_LAST_UPDATED_BY
      		,X_LAST_UPDATE_DATE
      		,X_LAST_UPDATED_BY
      		,X_LAST_UPDATE_LOGIN
        ,NEW_REFERENCES.SEGMENT_TYPE
        ,NEW_REFERENCES.SEGMENT_GROUP
      )RETURNING TEST_SEGMENT_ID INTO X_TEST_SEGMENT_ID;
Line: 789

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

end INSERT_ROW;
Line: 839

   cursor c1 is select
       MIN_SCORE
,      MAX_SCORE
,      INCLUDE_IN_COMP_SCORE
,      SCORE_IND
,      PERCENTILE_IND
,      NATIONAL_PERCENTILE_IND
,      STATE_PERCENTILE_IND
,      PERCENTILE_YEAR_RANK_IND
,      SCORE_BAND_UPPER_IND
,      SCORE_BAND_LOWER_IND
,      IRREGULARITY_CODE_IND
,      ADMISSION_TEST_TYPE
,      TEST_SEGMENT_NAME
,      DESCRIPTION
,      CLOSED_IND
,      SEGMENT_TYPE
,      SEGMENT_GROUP
    from IGS_AD_TEST_SEGMENTS
    where ROWID = X_ROWID
    for update nowait;
Line: 865

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

 Procedure UPDATE_ROW (
       X_ROWID in  VARCHAR2,
       x_MIN_SCORE IN NUMBER,
       x_MAX_SCORE IN NUMBER,
       x_INCLUDE_IN_COMP_SCORE IN VARCHAR2,
       x_SCORE_IND IN VARCHAR2,
       x_PERCENTILE_IND IN VARCHAR2,
       x_NATIONAL_PERCENTILE_IND IN VARCHAR2,
       x_STATE_PERCENTILE_IND IN VARCHAR2,
       x_PERCENTILE_YEAR_RANK_IND IN VARCHAR2,
       x_SCORE_BAND_UPPER_IND IN VARCHAR2,
       x_SCORE_BAND_LOWER_IND IN VARCHAR2,
       x_IRREGULARITY_CODE_IND IN VARCHAR2,
       x_TEST_SEGMENT_ID IN NUMBER,
       x_ADMISSION_TEST_TYPE IN VARCHAR2,
       x_TEST_SEGMENT_NAME IN VARCHAR2,
       x_DESCRIPTION IN VARCHAR2,
       x_CLOSED_IND IN VARCHAR2,
       X_MODE in VARCHAR2,
       X_SEGMENT_TYPE IN VARCHAR2 ,
       X_SEGMENT_GROUP IN NUMBER
  ) AS
  /*************************************************************
  Created By :samaresh.in
  Date Created By :15-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: 932

     X_LAST_UPDATED_BY NUMBER ;
Line: 933

     X_LAST_UPDATE_LOGIN NUMBER ;
Line: 938

      X_LAST_UPDATE_DATE := SYSDATE;
Line: 940

        X_LAST_UPDATED_BY := 1;
Line: 941

        X_LAST_UPDATE_LOGIN := 0;
Line: 943

               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 944

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

            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 948

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

 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_min_score=>X_MIN_SCORE,
 	       x_max_score=>X_MAX_SCORE,
 	       x_include_in_comp_score=>NVL(X_INCLUDE_IN_COMP_SCORE,'N' ),
 	       x_score_ind=>NVL(X_SCORE_IND,'N' ),
 	       x_percentile_ind=>NVL(X_PERCENTILE_IND,'N' ),
 	       x_national_percentile_ind=>NVL(X_NATIONAL_PERCENTILE_IND,'N' ),
 	       x_state_percentile_ind=>NVL(X_STATE_PERCENTILE_IND,'N' ),
 	       x_percentile_year_rank_ind=>NVL(X_PERCENTILE_YEAR_RANK_IND,'N' ),
 	       x_score_band_upper_ind=>NVL(X_SCORE_BAND_UPPER_IND,'N' ),
 	       x_score_band_lower_ind=>NVL(X_SCORE_BAND_LOWER_IND,'N' ),
 	       x_irregularity_code_ind=>NVL(X_IRREGULARITY_CODE_IND,'N' ),
 	       x_test_segment_id=>X_TEST_SEGMENT_ID,
 	       x_admission_test_type=>X_ADMISSION_TEST_TYPE,
 	       x_test_segment_name=>X_TEST_SEGMENT_NAME,
 	       x_description=>X_DESCRIPTION,
 	       x_closed_ind=>NVL(X_CLOSED_IND,'N' ),
	        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_segment_type=>X_SEGMENT_TYPE,
         x_segment_group=>X_SEGMENT_GROUP);
Line: 986

 update IGS_AD_TEST_SEGMENTS set
      MIN_SCORE =  NEW_REFERENCES.MIN_SCORE,
      MAX_SCORE =  NEW_REFERENCES.MAX_SCORE,
      INCLUDE_IN_COMP_SCORE =  NEW_REFERENCES.INCLUDE_IN_COMP_SCORE,
      SCORE_IND =  NEW_REFERENCES.SCORE_IND,
      PERCENTILE_IND =  NEW_REFERENCES.PERCENTILE_IND,
      NATIONAL_PERCENTILE_IND =  NEW_REFERENCES.NATIONAL_PERCENTILE_IND,
      STATE_PERCENTILE_IND =  NEW_REFERENCES.STATE_PERCENTILE_IND,
      PERCENTILE_YEAR_RANK_IND =  NEW_REFERENCES.PERCENTILE_YEAR_RANK_IND,
      SCORE_BAND_UPPER_IND =  NEW_REFERENCES.SCORE_BAND_UPPER_IND,
      SCORE_BAND_LOWER_IND =  NEW_REFERENCES.SCORE_BAND_LOWER_IND,
      IRREGULARITY_CODE_IND =  NEW_REFERENCES.IRREGULARITY_CODE_IND,
      ADMISSION_TEST_TYPE =  NEW_REFERENCES.ADMISSION_TEST_TYPE,
      TEST_SEGMENT_NAME =  NEW_REFERENCES.TEST_SEGMENT_NAME,
      DESCRIPTION =  NEW_REFERENCES.DESCRIPTION,
      CLOSED_IND =  NEW_REFERENCES.CLOSED_IND,
     	LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
     	LAST_UPDATED_BY = X_LAST_UPDATED_BY,
     	LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
      SEGMENT_TYPE   = X_SEGMENT_TYPE,
      SEGMENT_GROUP  = X_SEGMENT_GROUP
	  where ROWID = X_ROWID;
Line: 1020

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

end UPDATE_ROW;
Line: 1070

    cursor c1 is select ROWID from IGS_AD_TEST_SEGMENTS
             where     TEST_SEGMENT_ID= X_TEST_SEGMENT_ID;
Line: 1081

    INSERT_ROW (
       X_ROWID,
       X_MIN_SCORE,
       X_MAX_SCORE,
       X_INCLUDE_IN_COMP_SCORE,
       X_SCORE_IND,
       X_PERCENTILE_IND,
       X_NATIONAL_PERCENTILE_IND,
       X_STATE_PERCENTILE_IND,
       X_PERCENTILE_YEAR_RANK_IND,
       X_SCORE_BAND_UPPER_IND,
       X_SCORE_BAND_LOWER_IND,
       X_IRREGULARITY_CODE_IND,
       X_TEST_SEGMENT_ID,
       X_ADMISSION_TEST_TYPE,
       X_TEST_SEGMENT_NAME,
       X_DESCRIPTION,
       X_CLOSED_IND,
       l_MODE,
       X_SEGMENT_TYPE,
       X_SEGMENT_GROUP);
Line: 1105

UPDATE_ROW (
       X_ROWID,
       X_MIN_SCORE,
       X_MAX_SCORE,
       X_INCLUDE_IN_COMP_SCORE,
       X_SCORE_IND,
       X_PERCENTILE_IND,
       X_NATIONAL_PERCENTILE_IND,
       X_STATE_PERCENTILE_IND,
       X_PERCENTILE_YEAR_RANK_IND,
       X_SCORE_BAND_UPPER_IND,
       X_SCORE_BAND_LOWER_IND,
       X_IRREGULARITY_CODE_IND,
       X_TEST_SEGMENT_ID,
       X_ADMISSION_TEST_TYPE,
       X_TEST_SEGMENT_NAME,
       X_DESCRIPTION,
       X_CLOSED_IND,
       l_MODE,
       X_SEGMENT_TYPE,
       X_SEGMENT_GROUP);
Line: 1127

procedure DELETE_ROW (
  X_ROWID in VARCHAR2,
  x_mode IN VARCHAR2
) AS
  /*************************************************************
  Created By :samaresh.in
  Date Created By :15-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: 1150

 delete from IGS_AD_TEST_SEGMENTS
 where ROWID = X_ROWID;
Line: 1163

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

end DELETE_ROW;