DBA Data[Home] [Help]

APPS.WMS_LABEL_FIELD_VARIABLES_PKG SQL Statements

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

Line: 3

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_FIELD_ID	in 	NUMBER,
  X_FIELD_VARIABLE_NAME in      VARCHAR2,
  X_FIELD_VARIABLE_DESCRIPTION  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_FIELD_VARIABLES
    where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID
    AND   LABEL_FIELD_ID  = X_LABEL_FIELD_ID
    ;
Line: 40

  insert into WMS_LABEL_FIELD_VARIABLES (
  LABEL_FORMAT_ID,
  LABEL_FIELD_ID,
  FIELD_VARIABLE_NAME,
  FIELD_VARIABLE_DESCRIPTION,
  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_FIELD_ID,
  X_FIELD_VARIABLE_NAME,
  X_FIELD_VARIABLE_DESCRIPTION,
  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: 110

end INSERT_ROW;
Line: 117

  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
     FIELD_VARIABLE_NAME,
     FIELD_VARIABLE_DESCRIPTION,
     ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15
    from WMS_LABEL_FIELD_VARIABLES
    where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID
    AND   LABEL_FIELD_ID  = X_LABEL_FIELD_ID
    for update of LABEL_FORMAT_ID nowait;
Line: 173

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

procedure UPDATE_ROW (
  X_LABEL_FORMAT_ID	in 	NUMBER,
  X_LABEL_FIELD_ID	in 	NUMBER,
  X_FIELD_VARIABLE_NAME in      VARCHAR2,
  X_FIELD_VARIABLE_DESCRIPTION  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
begin
  update WMS_LABEL_FIELD_VARIABLES
    set FIELD_VARIABLE_NAME   = X_FIELD_VARIABLE_NAME,
    FIELD_VARIABLE_DESCRIPTION 	= X_FIELD_VARIABLE_DESCRIPTION,
    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
  AND   FIELD_VARIABLE_NAME  = X_FIELD_VARIABLE_NAME;
Line: 286

end UPDATE_ROW;
Line: 288

procedure DELETE_ROW (
  X_ROWID     IN VARCHAR2
) is
begin
  delete from WMS_LABEL_FIELD_VARIABLES
  where ROWID = X_ROWID;
Line: 299

end DELETE_ROW;
Line: 354

      SELECT Sysdate INTO l_sysdate FROM dual;
Line: 358

      wms_label_field_variables_pkg.update_row
	(
 	  x_label_format_id           => l_label_format_id
 	 ,x_label_field_id           => l_label_field_id
	 ,x_field_variable_name        => x_field_variable_name
	 ,x_field_variable_description       => x_field_variable_description
	 ,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: 392

       wms_label_field_variables_pkg.insert_row
        (
	  x_rowid                    => l_row_id
 	 , x_label_format_id         => l_label_format_id
 	 ,x_label_field_id           => l_label_field_id
	 ,x_field_variable_name        => x_field_variable_name
	 ,x_field_variable_description       => x_field_variable_description
	 ,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
	 );