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_AD_SYSSRC_CAT_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_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
  ) AS

  /*************************************************************
  Created By : amuthu
  Date Created On : 16-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
 pkpatel        16-JUN-2001   Added processing for two newly added columns AD_TAB_NAME and INT_TAB_NAME
  (reverse chronological order - newest change first)
  ***************************************************************/

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_AD_SYSSRC_CAT
      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: 125


                               Lookups are not deleted Hence no need to
                               check for existence.
  (reverse chronological order - newest change first)
  ***************************************************************/

  BEGIN
    NULL;

Line: 140


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

Line: 167


      SELECT   rowid
      FROM     igs_ad_syssrc_cat
      WHERE    category_name = x_category_name
      AND      system_source_type = x_system_source_type AND
               closed_ind = NVL(x_closed_ind,closed_ind)
      FOR UPDATE NOWAIT;

Line: 204


      SELECT   rowid
      FROM     igs_ad_syssrc_cat
      WHERE    upper(category_name) = upper(x_category_name)
      AND      upper(system_source_type) = upper(x_system_source_type)
      AND      ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line: 261


    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_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
  ) AS
  /*************************************************************
  Created By : amuthu
  Date Created On : 16-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
 pkpatel   16-JUN-2001     Added processing for two newly added columns AD_TAB_NAME and INT_TAB_NAME
  (reverse chronological order - newest change first)
  ***************************************************************/

  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_system_source_type,
      x_category_name,
      x_mandatory_ind,
      x_ss_ind,
      x_display_sequence,
      x_ad_tab_name,
      x_int_tab_name,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_closed_ind
    );

Line: 297


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

Line: 311


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

Line: 318


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

Line: 321


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

Line: 331


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Constraints;

Line: 333


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;

Line: 358


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

Line: 361


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

Line: 364


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

Line: 371


 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_SYSTEM_SOURCE_TYPE IN VARCHAR2,
       x_CATEGORY_NAME IN VARCHAR2,
       x_MANDATORY_IND IN VARCHAR2,
       x_SS_IND IN VARCHAR2,
       x_DISPLAY_SEQUENCE IN NUMBER,
       x_ad_tab_name  IN VARCHAR2 DEFAULT NULL,
       x_int_tab_name IN VARCHAR2 DEFAULT NULL,
      X_MODE in VARCHAR2 default 'R',
      X_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
  ) AS
  /*************************************************************
  Created By : amuthu
  Date Created On : 16-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
 pkpatel     16-JUN-2001    Added processing for two newly added columns AD_TAB_NAME and INT_TAB_NAME
  (reverse chronological order - newest change first)
  ***************************************************************/

    cursor C is select ROWID from IGS_AD_SYSSRC_CAT
             where                 CATEGORY_NAME= X_CATEGORY_NAME
            and SYSTEM_SOURCE_TYPE = X_SYSTEM_SOURCE_TYPE
;

Line: 398


     X_LAST_UPDATE_DATE DATE ;

Line: 399


     X_LAST_UPDATED_BY NUMBER ;

Line: 400


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 402


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 404


        X_LAST_UPDATED_BY := 1;

Line: 405


        X_LAST_UPDATE_LOGIN := 0;

Line: 407


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 408


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 411


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 412


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 421


 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_system_source_type=>X_SYSTEM_SOURCE_TYPE,
 	       x_category_name=>X_CATEGORY_NAME,
 	       x_mandatory_ind=>X_MANDATORY_IND,
 	       x_ss_ind=>X_SS_IND,
 	       x_display_sequence=>X_DISPLAY_SEQUENCE,
 	       x_ad_tab_name=>X_AD_TAB_NAME,
	       x_int_tab_name=>X_INT_TAB_NAME,
	       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_closed_ind=>X_CLOSED_IND);

Line: 436


     insert into IGS_AD_SYSSRC_CAT (
		SYSTEM_SOURCE_TYPE
		,CATEGORY_NAME
		,MANDATORY_IND
		,SS_IND
		,DISPLAY_SEQUENCE
		,AD_TAB_NAME
		,INT_TAB_NAME
	        ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
		,CLOSED_IND
        ) values  (
	        NEW_REFERENCES.SYSTEM_SOURCE_TYPE
	        ,NEW_REFERENCES.CATEGORY_NAME
	        ,NEW_REFERENCES.MANDATORY_IND
	        ,NULL
	        ,NULL
	        ,NEW_REFERENCES.AD_TAB_NAME
	        ,NEW_REFERENCES.INT_TAB_NAME
	        ,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_DATE
		,X_LAST_UPDATED_BY
		,X_LAST_UPDATE_LOGIN
		,NVL(X_CLOSED_IND,'N')
);

Line: 473


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

Line: 475


end INSERT_ROW;

Line: 498


   cursor c1 is select
      SYSTEM_SOURCE_TYPE,
      CATEGORY_NAME,
      MANDATORY_IND,
      SS_IND,
      DISPLAY_SEQUENCE,
      AD_TAB_NAME,
      INT_TAB_NAME,
      CLOSED_IND
    from IGS_AD_SYSSRC_CAT
    where ROWID = X_ROWID
    for update nowait;

Line: 515


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

Line: 535


 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_SYSTEM_SOURCE_TYPE IN VARCHAR2,
       x_CATEGORY_NAME IN VARCHAR2,
       x_MANDATORY_IND IN VARCHAR2,
       x_SS_IND IN VARCHAR2,
       x_DISPLAY_SEQUENCE IN NUMBER,
       x_AD_TAB_NAME IN VARCHAR2 DEFAULT NULL,
       x_INT_TAB_NAME IN VARCHAR2 DEFAULT NULL,
      X_MODE in VARCHAR2 default 'R',
      X_CLOSED_IND IN VARCHAR2 DEFAULT 'N'
  ) AS
  /*************************************************************
  Created By : amuthu
  Date Created On : 16-May-2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
pkpatel       16-JUN-2001   Added processing for two newly added columns AD_TAB_NAME and INT_TAB_NAME
  (reverse chronological order - newest change first)
  ***************************************************************/

     X_LAST_UPDATE_DATE DATE ;

Line: 559


     X_LAST_UPDATED_BY NUMBER ;

Line: 560


     X_LAST_UPDATE_LOGIN NUMBER ;

Line: 562


     X_LAST_UPDATE_DATE := SYSDATE;

Line: 564


        X_LAST_UPDATED_BY := 1;

Line: 565


        X_LAST_UPDATE_LOGIN := 0;

Line: 567


               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 568


            if X_LAST_UPDATED_BY is NULL then
                X_LAST_UPDATED_BY := -1;

Line: 571


            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 572


         if X_LAST_UPDATE_LOGIN is NULL then
            X_LAST_UPDATE_LOGIN := -1;

Line: 581


 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_system_source_type=>X_SYSTEM_SOURCE_TYPE,
 	       x_category_name=>X_CATEGORY_NAME,
 	       x_mandatory_ind=>X_MANDATORY_IND,
 	       x_ss_ind=>X_SS_IND,
 	       x_display_sequence=>X_DISPLAY_SEQUENCE,
               x_ad_tab_name=>X_AD_TAB_NAME,
               x_int_tab_name=>X_INT_TAB_NAME,
	       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_closed_ind=>X_CLOSED_IND);

Line: 597


            update IGS_AD_SYSSRC_CAT set
               mandatory_ind=X_MANDATORY_IND,
               ss_ind=NULL,
               display_sequence=NULL,
               ad_tab_name=X_AD_TAB_NAME,
               int_tab_name=X_INT_TAB_NAME,
  	       LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
	       LAST_UPDATED_BY = X_LAST_UPDATED_BY,
	       LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
	       CLOSED_IND = NVL(X_CLOSED_IND,'N')
	          where ROWID = X_ROWID;

Line: 613


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

Line: 616


end UPDATE_ROW;

Line: 640


    cursor c1 is select ROWID from IGS_AD_SYSSRC_CAT
             where     CATEGORY_NAME= X_CATEGORY_NAME
            and SYSTEM_SOURCE_TYPE = X_SYSTEM_SOURCE_TYPE
;

Line: 649


    INSERT_ROW (
      X_ROWID,
       X_SYSTEM_SOURCE_TYPE,
       X_CATEGORY_NAME,
       X_MANDATORY_IND,
       X_SS_IND,
       X_DISPLAY_SEQUENCE,
       X_AD_TAB_NAME,
       X_INT_TAB_NAME,
      X_MODE,
      X_CLOSED_IND);

Line: 663


UPDATE_ROW (
      X_ROWID,
       X_SYSTEM_SOURCE_TYPE,
       X_CATEGORY_NAME,
       X_MANDATORY_IND,
       X_SS_IND,
       X_DISPLAY_SEQUENCE,
       X_AD_TAB_NAME,
       X_INT_TAB_NAME,
      X_MODE,
      X_CLOSED_IND);

Line: 675


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
  /*************************************************************
  Created By : amuthu
  Date Created On : 16-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: 694


 delete from IGS_AD_SYSSRC_CAT
 where ROWID = X_ROWID;

Line: 700


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

Line: 703


end DELETE_ROW;