APPS.PN_NOTE_HEADERS_PKG SQL Statements

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

Line: 7

procedure INSERT_ROW
        (
                X_ROWID                         IN OUT NOCOPY VARCHAR2,
                X_NOTE_HEADER_ID                IN OUT NOCOPY NUMBER,
                X_LEASE_ID                      IN            NUMBER,
                X_NOTE_TYPE_LOOKUP_CODE         IN            VARCHAR2,
                X_NOTE_DATE                     IN            DATE,
                X_CREATION_DATE                 IN            DATE,
                X_CREATED_BY                    IN            NUMBER,
                X_LAST_UPDATE_DATE              IN            DATE,
                X_LAST_UPDATED_BY               IN            NUMBER,
                X_LAST_UPDATE_LOGIN             IN            NUMBER,
		X_ATTRIBUTE_CATEGORY            IN            VARCHAR2, --3626177
                X_ATTRIBUTE1          		IN 	      VARCHAR2,
  		X_ATTRIBUTE2          		IN 	      VARCHAR2,
  		X_ATTRIBUTE3          		IN 	      VARCHAR2,
  		X_ATTRIBUTE4          		IN 	      VARCHAR2,
  		X_ATTRIBUTE5          		IN 	      VARCHAR2,
  		X_ATTRIBUTE6          		IN 	      VARCHAR2,
  		X_ATTRIBUTE7          		IN 	      VARCHAR2,
  		X_ATTRIBUTE8          		IN 	      VARCHAR2,
  		X_ATTRIBUTE9          		IN 	      VARCHAR2,
  		X_ATTRIBUTE10         		IN 	      VARCHAR2,
  		X_ATTRIBUTE11         		IN 	      VARCHAR2,
  		X_ATTRIBUTE12         		IN 	      VARCHAR2,
  		X_ATTRIBUTE13         		IN 	      VARCHAR2,
  		X_ATTRIBUTE14         		IN 	      VARCHAR2,
  		X_ATTRIBUTE15         		IN 	      VARCHAR2
        ) is
   cursor C is
      select ROWID
      from   PN_NOTE_HEADERS
      where  NOTE_HEADER_ID = X_NOTE_HEADER_ID;

Line: 43

      select PN_NOTE_HEADERS_S.nextval
      into   X_NOTE_HEADER_ID
      from   dual;

Line: 48

   insert into PN_NOTE_HEADERS
   (
                NOTE_HEADER_ID,
                NOTE_DATE,
                LAST_UPDATED_BY,
                LAST_UPDATE_DATE,
                LAST_UPDATE_LOGIN,
                CREATED_BY,
                CREATION_DATE,
                NOTE_TYPE_LOOKUP_CODE,
                LEASE_ID,
		ATTRIBUTE_CATEGORY, --3626177
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15
   )
   values
   (
                X_NOTE_HEADER_ID,
                X_NOTE_DATE,
                X_LAST_UPDATED_BY,
                X_LAST_UPDATE_DATE,
                X_LAST_UPDATE_LOGIN,
                X_CREATED_BY,
                X_CREATION_DATE,
                X_NOTE_TYPE_LOOKUP_CODE,
                X_LEASE_ID,
		X_ATTRIBUTE_CATEGORY, --3626177
                X_ATTRIBUTE1,
    		X_ATTRIBUTE2,
    		X_ATTRIBUTE3,
    		X_ATTRIBUTE4,
    		X_ATTRIBUTE5,
    		X_ATTRIBUTE6,
    		X_ATTRIBUTE7,
    		X_ATTRIBUTE8,
    		X_ATTRIBUTE9,
    		X_ATTRIBUTE10,
    		X_ATTRIBUTE11,
    		X_ATTRIBUTE12,
    		X_ATTRIBUTE13,
    		X_ATTRIBUTE14,
    		X_ATTRIBUTE15

   );

Line: 114

END INSERT_ROW;

Line: 144

      select *
      from   PN_NOTE_HEADERS
      where  NOTE_HEADER_ID = X_NOTE_HEADER_ID
      for update of NOTE_HEADER_ID nowait;

Line: 269

procedure UPDATE_ROW
        (
                X_NOTE_HEADER_ID                in NUMBER,
                X_LEASE_ID                      in NUMBER,
                X_NOTE_TYPE_LOOKUP_CODE         in VARCHAR2,
                X_NOTE_DATE                     in        DATE,
                X_LAST_UPDATE_DATE              in DATE,
                X_LAST_UPDATED_BY               in NUMBER,
                X_LAST_UPDATE_LOGIN             in NUMBER,
		X_ATTRIBUTE_CATEGORY            in VARCHAR2, --3626177
                X_ATTRIBUTE1          		in VARCHAR2,
  		X_ATTRIBUTE2          		in VARCHAR2,
  		X_ATTRIBUTE3          		in VARCHAR2,
  		X_ATTRIBUTE4          		in VARCHAR2,
  		X_ATTRIBUTE5          		in VARCHAR2,
  		X_ATTRIBUTE6          		in VARCHAR2,
  		X_ATTRIBUTE7          		in VARCHAR2,
  		X_ATTRIBUTE8          		in VARCHAR2,
  		X_ATTRIBUTE9          		in VARCHAR2,
  		X_ATTRIBUTE10         		in VARCHAR2,
  		X_ATTRIBUTE11         		in VARCHAR2,
  		X_ATTRIBUTE12         		in VARCHAR2,
  		X_ATTRIBUTE13         		in VARCHAR2,
  		X_ATTRIBUTE14         		in VARCHAR2,
  		X_ATTRIBUTE15         		in VARCHAR2
        )
IS
BEGIN
   update PN_NOTE_HEADERS
      set LEASE_ID                        = X_LEASE_ID,
          NOTE_DATE                       = X_NOTE_DATE,
          NOTE_TYPE_LOOKUP_CODE           = X_NOTE_TYPE_LOOKUP_CODE,
          LAST_UPDATE_DATE                = X_LAST_UPDATE_DATE,
          LAST_UPDATED_BY                 = X_LAST_UPDATED_BY,
          LAST_UPDATE_LOGIN               = X_LAST_UPDATE_LOGIN,
	  ATTRIBUTE_CATEGORY              = X_ATTRIBUTE_CATEGORY, --3626177
          ATTRIBUTE1          		  = X_ATTRIBUTE1,
      	  ATTRIBUTE2          		  = X_ATTRIBUTE2,
      	  ATTRIBUTE3          		  = X_ATTRIBUTE3,
      	  ATTRIBUTE4          		  = X_ATTRIBUTE4,
      	  ATTRIBUTE5          		  = X_ATTRIBUTE5,
      	  ATTRIBUTE6          		  = X_ATTRIBUTE6,
      	  ATTRIBUTE7          		  = X_ATTRIBUTE7,
      	  ATTRIBUTE8          		  = X_ATTRIBUTE8,
      	  ATTRIBUTE9          		  = X_ATTRIBUTE9,
      	  ATTRIBUTE10         		  = X_ATTRIBUTE10,
      	  ATTRIBUTE11         		  = X_ATTRIBUTE11,
      	  ATTRIBUTE12         		  = X_ATTRIBUTE12,
      	  ATTRIBUTE13         		  = X_ATTRIBUTE13,
      	  ATTRIBUTE14         		  = X_ATTRIBUTE14,
	  ATTRIBUTE15         		  = X_ATTRIBUTE15
    where NOTE_HEADER_ID = X_NOTE_HEADER_ID;

Line: 326

END UPDATE_ROW;

Line: 331

PROCEDURE DELETE_ROW
        (
                X_NOTE_HEADER_ID in NUMBER
        )
is
   cursor c is
      select note_detail_id
      from   pn_note_details
      where  note_header_id = X_NOTE_HEADER_ID
      for update of note_detail_id nowait;

Line: 344

      PN_NOTE_DETAILS_PKG.DELETE_ROW (X_NOTE_DETAIL_ID =>i.note_detail_id);

Line: 347

   delete from PN_NOTE_HEADERS where NOTE_HEADER_ID = X_NOTE_HEADER_ID;

Line: 353

END DELETE_ROW;