DBA Data[Home] [Help]

APPS.IGS_PS_CATLG_NOTES_PKG SQL Statements

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

Line: 20

    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 : ssuri
|
| Date Created By : 10-MAY-2000
|
| Purpose : NEW TABLE
|
| 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_PS_CATLG_NOTES_ALL
      WHERE    rowid = x_rowid;
Line: 57

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

      FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
Line: 75

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

    new_references.last_update_date := x_last_update_date;
Line: 83

    new_references.last_updated_by  := x_last_updated_by;
Line: 84

    new_references.last_update_login:= x_last_update_login;
Line: 113

          SELECT create_date,end_date
	  FROM igs_ps_catlg_notes_all
	  WHERE catalog_version_id = new_references.catalog_version_id and
	        note_type_id = new_references.note_type_id and
		(
		  (l_rowid is not null AND
		   rowid <>  l_rowid)
                   OR
		  (l_rowid is null)
		)
        ORDER BY create_date;
Line: 233

	 FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
Line: 244

          FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
Line: 274

      SELECT   rowid
      FROM     igs_ps_catlg_notes_ALL
      WHERE    catalog_note_id = x_catalog_note_id
      FOR UPDATE NOWAIT;
Line: 320

      SELECT   rowid
      FROM     igs_ps_catlg_notes_ALL
      WHERE    catalog_version_id = x_catalog_version_id
      AND      note_type_id = x_note_type_id
      AND      sequence = x_sequence 	and      ((l_rowid is null) or (rowid <> l_rowid))

      ;
Line: 364

      SELECT   rowid
      FROM     igs_ps_catlg_notes_ALL
      WHERE    catalog_version_id = x_catalog_version_id ;
Line: 408

      SELECT   rowid
      FROM     igs_ps_catlg_notes_ALL
      WHERE    note_type_id = x_note_type_id ;
Line: 441

    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 : ssuri
|
| Date Created By : 10-MAY-2000
|
| Purpose : NEW TABLE
|
| 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_catalog_note_id,
      x_catalog_version_id,
      x_note_type_id,
      x_create_date,
      x_end_date,
      x_sequence,
      x_note_text,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_org_id
    );
Line: 485

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

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

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

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

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

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

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

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

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

 procedure INSERT_ROW (
      X_ROWID in out NOCOPY VARCHAR2,
       x_CATALOG_NOTE_ID IN OUT NOCOPY NUMBER,
       x_CATALOG_VERSION_ID IN NUMBER,
       x_NOTE_TYPE_ID IN NUMBER,
       x_CREATE_DATE IN DATE,
       x_END_DATE IN DATE,
       x_SEQUENCE IN NUMBER,
       x_NOTE_TEXT IN VARCHAR2,
      X_MODE in VARCHAR2 default 'R',
      X_ORG_ID IN NUMBER
  ) AS

/*=======================================================================+
|
| Created By : ssuri
|
| Date Created By : 10-MAY-2000
|
| Purpose : NEW TABLE
|
| Know limitations, enhancements or remarks
|
| Change History
|
| Who		When 		What
|
|
|(reverse chronological order - newest change first)
*=======================================================================*/

    cursor C is select ROWID from IGS_PS_CATLG_NOTES_ALL
             where                 CATALOG_NOTE_ID= X_CATALOG_NOTE_ID
;
Line: 599

     X_LAST_UPDATE_DATE DATE ;
Line: 600

     X_LAST_UPDATED_BY NUMBER ;
Line: 601

     X_LAST_UPDATE_LOGIN NUMBER ;
Line: 603

     X_LAST_UPDATE_DATE := SYSDATE;
Line: 605

        X_LAST_UPDATED_BY := 1;
Line: 606

        X_LAST_UPDATE_LOGIN := 0;
Line: 608

               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 609

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

            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 613

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

       SELECT IGS_PS_CATLG_NOTES_S.nextval INTO x_CATALOG_NOTE_ID FROM DUAL;
Line: 623

 		p_action=>'INSERT',
 		x_rowid=>X_ROWID,
 	       x_catalog_note_id=>X_CATALOG_NOTE_ID,
 	       x_catalog_version_id=>X_CATALOG_VERSION_ID,
 	       x_note_type_id=>X_NOTE_TYPE_ID,
 	       x_create_date=>X_CREATE_DATE,
 	       x_end_date=>X_END_DATE,
 	       x_sequence=>X_SEQUENCE,
 	       x_note_text=>X_NOTE_TEXT,
	       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: 638

     insert into IGS_PS_CATLG_NOTES_ALL (
		CATALOG_NOTE_ID
		,CATALOG_VERSION_ID
		,NOTE_TYPE_ID
		,CREATE_DATE
		,END_DATE
		,SEQUENCE
		,NOTE_TEXT
	        ,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
		,ORG_ID
        ) values  (
	        NEW_REFERENCES.CATALOG_NOTE_ID
	        ,NEW_REFERENCES.CATALOG_VERSION_ID
	        ,NEW_REFERENCES.NOTE_TYPE_ID
	        ,NEW_REFERENCES.CREATE_DATE
	        ,NEW_REFERENCES.END_DATE
	        ,NEW_REFERENCES.SEQUENCE
	        ,NEW_REFERENCES.NOTE_TEXT
	        ,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: 675

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

end INSERT_ROW;
Line: 708

   cursor c1 is select
      CATALOG_VERSION_ID
,      NOTE_TYPE_ID
,      CREATE_DATE
,      END_DATE
,      SEQUENCE
,      NOTE_TEXT

    from IGS_PS_CATLG_NOTES_ALL
    where ROWID = X_ROWID
    for update nowait;
Line: 724

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

 Procedure UPDATE_ROW (
      X_ROWID in  VARCHAR2,
       x_CATALOG_NOTE_ID IN NUMBER,
       x_CATALOG_VERSION_ID IN NUMBER,
       x_NOTE_TYPE_ID IN NUMBER,
       x_CREATE_DATE IN DATE,
       x_END_DATE IN DATE,
       x_SEQUENCE IN NUMBER,
       x_NOTE_TEXT IN VARCHAR2,
      X_MODE in VARCHAR2 default 'R'
    ) AS

/*=======================================================================+
|
| Created By : ssuri
|
| Date Created By : 10-MAY-2000
|
| Purpose : NEW TABLE
|
| Know limitations, enhancements or remarks
|
| Change History
|
| Who		When 		What
|
|
|(reverse chronological order - newest change first)
*=======================================================================*/

     X_LAST_UPDATE_DATE DATE ;
Line: 784

     X_LAST_UPDATED_BY NUMBER ;
Line: 785

     X_LAST_UPDATE_LOGIN NUMBER ;
Line: 787

     X_LAST_UPDATE_DATE := SYSDATE;
Line: 789

        X_LAST_UPDATED_BY := 1;
Line: 790

        X_LAST_UPDATE_LOGIN := 0;
Line: 792

               X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 793

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

            X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 797

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

 		p_action=>'UPDATE',
 		x_rowid=>X_ROWID,
 	       x_catalog_note_id=>X_CATALOG_NOTE_ID,
 	       x_catalog_version_id=>X_CATALOG_VERSION_ID,
 	       x_note_type_id=>X_NOTE_TYPE_ID,
 	       x_create_date=>X_CREATE_DATE,
 	       x_end_date=>X_END_DATE,
 	       x_sequence=>X_SEQUENCE,
 	       x_note_text=>X_NOTE_TEXT,
	       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: 821

   update IGS_PS_CATLG_NOTES_ALL set
      CATALOG_VERSION_ID =  NEW_REFERENCES.CATALOG_VERSION_ID,
      NOTE_TYPE_ID =  NEW_REFERENCES.NOTE_TYPE_ID,
      CREATE_DATE =  NEW_REFERENCES.CREATE_DATE,
      END_DATE =  NEW_REFERENCES.END_DATE,
      SEQUENCE =  NEW_REFERENCES.SEQUENCE,
      NOTE_TEXT =  NEW_REFERENCES.NOTE_TEXT,
	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: 838

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

end UPDATE_ROW;
Line: 875

    cursor c1 is select ROWID from IGS_PS_CATLG_NOTES_ALL
             where     CATALOG_NOTE_ID= X_CATALOG_NOTE_ID
;
Line: 883

    INSERT_ROW (
      X_ROWID,
       X_CATALOG_NOTE_ID,
       X_CATALOG_VERSION_ID,
       X_NOTE_TYPE_ID,
       X_CREATE_DATE,
       X_END_DATE,
       X_SEQUENCE,
       X_NOTE_TEXT,
      X_MODE,
      X_ORG_ID
);
Line: 898

UPDATE_ROW (
      X_ROWID,
       X_CATALOG_NOTE_ID,
       X_CATALOG_VERSION_ID,
       X_NOTE_TYPE_ID,
       X_CREATE_DATE,
       X_END_DATE,
       X_SEQUENCE,
       X_NOTE_TEXT,
      X_MODE
);
Line: 911

procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS

/*=======================================================================+
|
| Created By : ssuri
|
| Date Created By : 10-MAY-2000
|
| Purpose : NEW TABLE
|
| 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: 938

 delete from IGS_PS_CATLG_NOTES_ALL
 where ROWID = X_ROWID;
Line: 944

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

end DELETE_ROW;