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.WMS_LABEL_FORMATS_PKG SQL Statements

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

Line: 6


procedure INSERT_ROW (
  X_ROWID 	 IN OUT NOCOPY /* file.sql.39 change */ 	VARCHAR2,  -- NOCOPY added as a part of Bug# 4380449
  X_LABEL_FORMAT_ID	in 	NUMBER,
  X_LABEL_FORMAT_NAME   in      VARCHAR2,
  X_FORMAT_DESCRIPTION  in      VARCHAR2,
  X_DOCUMENT_ID		in 	NUMBER,
  X_DEFAULT_FORMAT_FLAG	in      VARCHAR2,
  X_FORMAT_DISABLE_DATE in      VARCHAR2,
  X_LAST_UPDATE_DATE 	in DATE,
  X_LAST_UPDATED_BY 	in NUMBER,
  X_LAST_UPDATE_LOGIN 	in NUMBER,
  X_CREATED_BY          in NUMBER,
  X_CREATION_DATE       in DATE,
  X_REQUEST_ID		in NUMBER,
  X_PROGRAM_APPLICATION_ID in NUMBER,
  X_PROGRAM_ID		in NUMBER,
  X_PROGRAM_UPDATE_DATE in DATE,
  X_ATTRIBUTE_CATEGORY 	in VARCHAR2,
  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 WMS_LABEL_FORMATS
    where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID
    ;

Line: 45


  insert into WMS_LABEL_FORMATS (
  LABEL_FORMAT_ID,
  LABEL_FORMAT_NAME  ,
  FORMAT_DESCRIPTION,
  DOCUMENT_ID	,
  DEFAULT_FORMAT_FLAG,
  FORMAT_DISABLE_DATE,
  LAST_UPDATE_DATE ,
  LAST_UPDATED_BY ,
  LAST_UPDATE_LOGIN,
  CREATED_BY      ,
  CREATION_DATE  ,
  REQUEST_ID	,
  PROGRAM_APPLICATION_ID,
  PROGRAM_ID		,
  PROGRAM_UPDATE_DATE,
  ATTRIBUTE_CATEGORY,
  ATTRIBUTE1 	,
  ATTRIBUTE2 ,
  ATTRIBUTE3 ,
  ATTRIBUTE4 ,
  ATTRIBUTE5 ,
  ATTRIBUTE6,
  ATTRIBUTE7,
  ATTRIBUTE8,
  ATTRIBUTE9,
  ATTRIBUTE10,
  ATTRIBUTE11,
  ATTRIBUTE12,
  ATTRIBUTE13,
  ATTRIBUTE14,
  ATTRIBUTE15
  ) values (
  X_LABEL_FORMAT_ID	,
  X_LABEL_FORMAT_NAME ,
  X_FORMAT_DESCRIPTION,
  X_DOCUMENT_ID	,
  X_DEFAULT_FORMAT_FLAG,
  X_FORMAT_DISABLE_DATE,
  X_LAST_UPDATE_DATE ,
  X_LAST_UPDATED_BY ,
  X_LAST_UPDATE_LOGIN,
  X_CREATED_BY      ,
  X_CREATION_DATE  ,
  X_REQUEST_ID	,
  X_PROGRAM_APPLICATION_ID,
  X_PROGRAM_ID		,
  X_PROGRAM_UPDATE_DATE,
  X_ATTRIBUTE_CATEGORY,
  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: 119


end INSERT_ROW;

Line: 128


  X_LAST_UPDATE_DATE 	in DATE,
  X_LAST_UPDATED_BY 	in NUMBER,
  X_LAST_UPDATE_LOGIN 	in NUMBER,
  X_CREATED_BY          in NUMBER,
  X_CREATION_DATE       in DATE,
  X_REQUEST_ID		in NUMBER,
  X_PROGRAM_APPLICATION_ID in NUMBER,
  X_PROGRAM_ID		in NUMBER,
  X_PROGRAM_UPDATE_DATE in DATE,
  X_ATTRIBUTE_CATEGORY 	in VARCHAR2,
  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
      LABEL_FORMAT_NAME,
      FORMAT_DESCRIPTION,
      DOCUMENT_ID,
      DEFAULT_FORMAT_FLAG,
      FORMAT_DISABLE_DATE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15
    from WMS_LABEL_FORMATS
    where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID
    for update of LABEL_FORMAT_ID nowait;

Line: 187


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

Line: 244


procedure UPDATE_ROW (
  X_LABEL_FORMAT_ID	in 	NUMBER,
  X_LABEL_FORMAT_NAME   in      VARCHAR2,
  X_FORMAT_DESCRIPTION  in      VARCHAR2,
  X_DOCUMENT_ID		in 	NUMBER,
  X_DEFAULT_FORMAT_FLAG	in      VARCHAR2,
  X_FORMAT_DISABLE_DATE in      VARCHAR2,
  X_LAST_UPDATE_DATE 	in DATE,
  X_LAST_UPDATED_BY 	in NUMBER,
  X_LAST_UPDATE_LOGIN 	in NUMBER,
  X_CREATED_BY          in NUMBER,
  X_CREATION_DATE       in DATE,
  X_REQUEST_ID		in NUMBER,
  X_PROGRAM_APPLICATION_ID in NUMBER,
  X_PROGRAM_ID		in NUMBER,
  X_PROGRAM_UPDATE_DATE in DATE,
  X_ATTRIBUTE_CATEGORY 	in VARCHAR2,
  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
l_msg    varchar2(2000);

Line: 283


  update WMS_LABEL_FORMATS
     set DOCUMENT_ID 	= X_DOCUMENT_ID,
    LABEL_FORMAT_NAME   = X_LABEL_FORMAT_NAME,
    FORMAT_DESCRIPTION 	= X_FORMAT_DESCRIPTION,
    DEFAULT_FORMAT_FLAG = X_DEFAULT_FORMAT_FLAG,
    FORMAT_DISABLE_DATE = X_FORMAT_DISABLE_DATE,
    ATTRIBUTE_CATEGORY 	= X_ATTRIBUTE_CATEGORY,
    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,
    LAST_UPDATE_DATE 	= X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY 	= X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN 	= X_LAST_UPDATE_LOGIN,
    CREATED_BY          = X_CREATED_BY,
   CREATION_DATE       = X_CREATION_DATE
  where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID;

Line: 316


end UPDATE_ROW;

Line: 318


procedure DELETE_ROW (
  X_LABEL_FORMAT_ID in NUMBER
) is
    l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line: 323


  delete from WMS_LABEL_FORMATS
  where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID;

Line: 330


end DELETE_ROW;

Line: 393


      SELECT Sysdate INTO l_sysdate FROM dual;

Line: 402


      wms_label_formats_pkg.update_row
	(
 	  x_label_format_id           => l_label_format_id
	 ,x_label_format_name        => x_label_format_name
	 ,x_format_description       => x_format_description
	 ,x_document_id 	     => l_document_id
         ,x_default_format_flag      => x_default_format_flag
         ,x_format_disable_date      => x_format_disable_date
	 ,x_last_update_date         => l_sysdate
	 ,x_last_updated_by          => l_user_id
	 ,x_last_update_login        => 0
         ,x_created_by                => l_user_id
         ,x_creation_date             => l_sysdate
	 ,x_request_id		     => null
	 ,x_program_application_id   => null
	 ,x_program_id		     => null
	 ,x_program_update_date      => null
	 ,x_attribute_category	     => x_attribute_category
	 ,x_attribute1 		     => x_attribute1
	 ,x_attribute2 		     => x_attribute2
	 ,x_attribute3 		     => x_attribute3
	 ,x_attribute4 		     => x_attribute4
	 ,x_attribute5 		     => x_attribute5
	 ,x_attribute6 		     => x_attribute6
	 ,x_attribute7               => x_attribute7
	 ,x_attribute8 		     => x_attribute8
	 ,x_attribute9 		     => x_attribute9
	 ,x_attribute10		     => x_attribute10
	 ,x_attribute11		     => x_attribute11
	 ,x_attribute12		     => x_attribute12
	 ,x_attribute13		     => x_attribute13
	 ,x_attribute14		     => x_attribute14
	 ,x_attribute15		     => x_attribute15
	);

Line: 438


       wms_label_formats_pkg.insert_row
        (
	  x_rowid                    => l_row_id
 	 , x_label_format_id         => l_label_format_id
	 ,x_label_format_name        => x_label_format_name
	 ,x_format_description       => x_format_description
	 ,x_document_id 	     => l_document_id
         ,x_default_format_flag      => x_default_format_flag
         ,x_format_disable_date      => x_format_disable_date
	 ,x_last_update_date         => l_sysdate
	 ,x_last_updated_by          => l_user_id
	 ,x_last_update_login        => 0
         ,x_created_by                => l_user_id
         ,x_creation_date             => l_sysdate
	 ,x_request_id		     => null
	 ,x_program_application_id   => null
	 ,x_program_id		     => null
	 ,x_program_update_date      => null
	 ,x_attribute_category	     => x_attribute_category
	 ,x_attribute1 		     => x_attribute1
	 ,x_attribute2 		     => x_attribute2
	 ,x_attribute3 		     => x_attribute3
	 ,x_attribute4 		     => x_attribute4
	 ,x_attribute5 		     => x_attribute5
	 ,x_attribute6 		     => x_attribute6
	 ,x_attribute7               => x_attribute7
	 ,x_attribute8 		     => x_attribute8
	 ,x_attribute9 		     => x_attribute9
	 ,x_attribute10		     => x_attribute10
	 ,x_attribute11		     => x_attribute11
	 ,x_attribute12		     => x_attribute12
	 ,x_attribute13		     => x_attribute13
	 ,x_attribute14		     => x_attribute14
	 ,x_attribute15		     => x_attribute15
	 );