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

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

Line: 24


    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER ,
    x_enforce_date_alias  IN VARCHAR2 ,
    x_config_min_cp_valdn IN VARCHAR2
  ) AS

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_EN_CAT_PRC_DTL
      WHERE    rowid = x_rowid;

Line: 44


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

Line: 46


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

Line: 59


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

Line: 66


    new_references.last_update_date := x_last_update_date;

Line: 67


    new_references.last_updated_by := x_last_updated_by;

Line: 68


    new_references.last_update_login := x_last_update_login;

Line: 81


  PROCEDURE BeforeRowInsert1(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN
    ) AS
      v_message_name  varchar2(30);

Line: 90


		IF p_inserting THEN
			-- Validate the enrolment method type
			IF IGS_EN_VAL_ECPD.enrp_val_ecpd_emt(
					new_references.enr_method_type,
	 				v_message_name) = FALSE THEN
			    Fnd_Message.Set_Name('IGS', v_message_name);

Line: 103


  END BeforeRowInsert1;

Line: 110


  PROCEDURE AfterStmtInsert2(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN
    ) AS
	CURSOR c_ecpd IS
	SELECT	enrolment_cat,
		enr_method_type,
		s_student_comm_type
	FROM	IGS_EN_CAT_PRC_DTL;

Line: 123


	IF p_inserting AND
	     igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_CAT_PRC_DTL') THEN
		FOR v_ecpd_rec IN c_ecpd
		LOOP
			-- Validate the enrolment method type
			IF IGS_EN_VAL_ECPD.enrp_val_ecpd_comm(
					v_ecpd_rec.enrolment_cat,
					v_ecpd_rec.enr_method_type,
					v_ecpd_rec.s_student_comm_type,
		 			v_message_name) = FALSE THEN
			    Fnd_Message.Set_Name('IGS', v_message_name);

Line: 141


  END AfterStmtInsert2;

Line: 220


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

Line: 235


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

Line: 263


      SELECT   rowid
      FROM     IGS_EN_CAT_PRC_DTL
      WHERE    enrolment_cat = x_enrolment_cat
      AND      s_student_comm_type = x_s_student_comm_type
      AND      enr_method_type = x_enr_method_type
      FOR UPDATE NOWAIT;

Line: 292


      SELECT   rowid
      FROM     IGS_EN_CAT_PRC_DTL
      WHERE    enr_method_type = x_enr_method_type ;

Line: 318


      SELECT   rowid
      FROM     IGS_EN_CAT_PRC_DTL
      WHERE    enrolment_cat = x_enrolment_cat ;

Line: 345


      SELECT   rowid
      FROM     igs_en_cat_prc_dtl
      WHERE   ((enforce_date_alias = x_dt_alias));

Line: 377


    x_last_update_date IN DATE  ,
    x_last_updated_by IN NUMBER  ,
    x_last_update_login IN NUMBER  ,
    x_enforce_date_alias  IN VARCHAR2 ,
    x_config_min_cp_valdn IN VARCHAR2
  ) AS
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_enrolment_cat,
      x_s_student_comm_type,
      x_enr_method_type,
      x_person_add_allow_ind,
      x_course_add_allow_ind,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_enforce_date_alias ,
      x_config_min_cp_valdn
    );

Line: 402


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      BeforeRowInsert1 ( p_inserting => TRUE ,
		         p_updating  => FALSE,
			 p_deleting  => FALSE );

Line: 420


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

Line: 424


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

      Check_Child_Existance;

Line: 429


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      		IF  Get_PK_For_Validation (
		          new_references.enrolment_cat,
		          new_references.s_student_comm_type,
                          new_references.enr_method_type
				 ) THEN
		          Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 440


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      		  Check_Constraints;

Line: 442


    ELSIF (p_action = 'VALIDATE_DELETE') THEN

                 Check_Child_Existance;

Line: 457


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      AfterStmtInsert2 ( p_inserting => TRUE,
                         p_updating  => FALSE,
			 p_deleting  => FALSE);

Line: 462


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

Line: 465


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

Line: 472


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_ENROLMENT_CAT in VARCHAR2,
  X_S_STUDENT_COMM_TYPE in VARCHAR2,
  X_ENR_METHOD_TYPE in VARCHAR2,
  X_PERSON_ADD_ALLOW_IND in VARCHAR2,
  X_COURSE_ADD_ALLOW_IND in VARCHAR2,
  X_MODE in VARCHAR2 ,
  X_ENFORCE_DATE_ALIAS  IN VARCHAR2 ,
  X_CONFIG_MIN_CP_VALDN IN VARCHAR2
  ) AS
    cursor C is select ROWID from IGS_EN_CAT_PRC_DTL
      where ENROLMENT_CAT = X_ENROLMENT_CAT
      and S_STUDENT_COMM_TYPE = X_S_STUDENT_COMM_TYPE
      and ENR_METHOD_TYPE = X_ENR_METHOD_TYPE;

Line: 487


    X_LAST_UPDATE_DATE DATE;

Line: 488


    X_LAST_UPDATED_BY NUMBER;

Line: 489


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 491


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 493


    X_LAST_UPDATED_BY := 1;

Line: 494


    X_LAST_UPDATE_LOGIN := 0;

Line: 496


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 497


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 500


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 501


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 511


  p_action => 'INSERT',
  x_rowid => X_ROWID,
  x_enrolment_cat => X_ENROLMENT_CAT,
  x_s_student_comm_type => X_S_STUDENT_COMM_TYPE,
  x_enr_method_type => X_ENR_METHOD_TYPE,
  x_person_add_allow_ind => X_PERSON_ADD_ALLOW_IND,
  x_course_add_allow_ind => X_COURSE_ADD_ALLOW_IND,
  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_enforce_date_alias =>  X_ENFORCE_DATE_ALIAS,
  x_config_min_cp_valdn =>   X_CONFIG_MIN_CP_VALDN
);

Line: 527


  insert into IGS_EN_CAT_PRC_DTL (
    ENROLMENT_CAT,
    S_STUDENT_COMM_TYPE,
    ENR_METHOD_TYPE,
    PERSON_ADD_ALLOW_IND,
    COURSE_ADD_ALLOW_IND,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ENFORCE_DATE_ALIAS,
    CONFIG_MIN_CP_VALDN
  ) values (
    NEW_REFERENCES.ENROLMENT_CAT,
    NEW_REFERENCES.S_STUDENT_COMM_TYPE,
    NEW_REFERENCES.ENR_METHOD_TYPE,
    NEW_REFERENCES.PERSON_ADD_ALLOW_IND,
    NEW_REFERENCES.COURSE_ADD_ALLOW_IND,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    NEW_REFERENCES.ENFORCE_DATE_ALIAS,
    NEW_REFERENCES.CONFIG_MIN_CP_VALDN
  );

Line: 564


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

Line: 569


end INSERT_ROW;

Line: 581


  cursor c1 is select
      PERSON_ADD_ALLOW_IND,
      COURSE_ADD_ALLOW_IND,
      ENFORCE_DATE_ALIAS,
      CONFIG_MIN_CP_VALDN
    from IGS_EN_CAT_PRC_DTL
    where ROWID = X_ROWID
    for update nowait;

Line: 596


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

Line: 617


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_ENROLMENT_CAT in VARCHAR2,
  X_S_STUDENT_COMM_TYPE in VARCHAR2,
  X_ENR_METHOD_TYPE in VARCHAR2,
  X_PERSON_ADD_ALLOW_IND in VARCHAR2,
  X_COURSE_ADD_ALLOW_IND in VARCHAR2,
  X_MODE in VARCHAR2 ,
  X_ENFORCE_DATE_ALIAS  IN VARCHAR2 ,
  X_CONFIG_MIN_CP_VALDN IN VARCHAR2
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 629


    X_LAST_UPDATED_BY NUMBER;

Line: 630


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 632


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 634


    X_LAST_UPDATED_BY := 1;

Line: 635


    X_LAST_UPDATE_LOGIN := 0;

Line: 637


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 638


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 641


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 642


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 652


  p_action => 'UPDATE',
  x_rowid => X_ROWID,
  x_enrolment_cat => X_ENROLMENT_CAT,
  x_s_student_comm_type => X_S_STUDENT_COMM_TYPE,
  x_enr_method_type => X_ENR_METHOD_TYPE,
  x_person_add_allow_ind => X_PERSON_ADD_ALLOW_IND,
  x_course_add_allow_ind => X_COURSE_ADD_ALLOW_IND,
  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_enforce_date_alias  =>  X_ENFORCE_DATE_ALIAS,
  x_config_min_cp_valdn =>  X_CONFIG_MIN_CP_VALDN
);

Line: 668


  update IGS_EN_CAT_PRC_DTL set
    PERSON_ADD_ALLOW_IND = NEW_REFERENCES.PERSON_ADD_ALLOW_IND,
    COURSE_ADD_ALLOW_IND = NEW_REFERENCES.COURSE_ADD_ALLOW_IND,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    ENFORCE_DATE_ALIAS  =  NEW_REFERENCES.ENFORCE_DATE_ALIAS,
    CONFIG_MIN_CP_VALDN = NEW_REFERENCES.CONFIG_MIN_CP_VALDN
    where ROWID = X_ROWID;

Line: 683


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

Line: 687


end UPDATE_ROW;

Line: 700


  cursor c1 is select rowid from IGS_EN_CAT_PRC_DTL
     where ENROLMENT_CAT = X_ENROLMENT_CAT
     and S_STUDENT_COMM_TYPE = X_S_STUDENT_COMM_TYPE
     and ENR_METHOD_TYPE = X_ENR_METHOD_TYPE
  ;

Line: 711


    INSERT_ROW (
     X_ROWID,
     X_ENROLMENT_CAT,
     X_S_STUDENT_COMM_TYPE,
     X_ENR_METHOD_TYPE,
     X_PERSON_ADD_ALLOW_IND,
     X_COURSE_ADD_ALLOW_IND,
     X_MODE,
     X_ENFORCE_DATE_ALIAS,
     X_CONFIG_MIN_CP_VALDN
  );

Line: 725


  UPDATE_ROW (
   X_ROWID,
   X_ENROLMENT_CAT,
   X_S_STUDENT_COMM_TYPE,
   X_ENR_METHOD_TYPE,
   X_PERSON_ADD_ALLOW_IND,
   X_COURSE_ADD_ALLOW_IND,
   X_MODE,
   X_ENFORCE_DATE_ALIAS,
   X_CONFIG_MIN_CP_VALDN
);

Line: 738


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

Line: 748


  delete from IGS_EN_CAT_PRC_DTL
  where ROWID = X_ROWID;

Line: 754


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

Line: 758


end DELETE_ROW;