APPS.PO_ASL_THS1 SQL Statements

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

Line: 11

  PROCEDURE NAME:	update_row()

===============================================================================*/
procedure update_row(
	x_row_id		 		VARCHAR2,
	x_asl_id				NUMBER,
	x_using_organization_id   		NUMBER,
	x_owning_organization_id  		NUMBER,
	x_vendor_business_type	  		VARCHAR2,
	x_asl_status_id		  		NUMBER,
	x_last_update_date	  		DATE,
	x_last_updated_by	  		NUMBER,
	x_creation_date		  		DATE,
	x_created_by		  		NUMBER,
	x_manufacturer_id	  		NUMBER,
	x_vendor_id		  		NUMBER,
	x_item_id		  		NUMBER,
	x_category_id		  		NUMBER,
	x_vendor_site_id	  		NUMBER,
	x_primary_vendor_item  	  		VARCHAR2,
	x_manufacturer_asl_id     		NUMBER,
	x_comments				VARCHAR2,
	x_review_by_date			DATE,
	x_attribute_category	  		VARCHAR2,
	x_attribute1		  		VARCHAR2,
	x_attribute2		  		VARCHAR2,
	x_attribute3		  		VARCHAR2,
	x_attribute4		  		VARCHAR2,
	x_attribute5		  		VARCHAR2,
	x_attribute6		  		VARCHAR2,
	x_attribute7		  		VARCHAR2,
	x_attribute8		  		VARCHAR2,
	x_attribute9		  		VARCHAR2,
	x_attribute10		  		VARCHAR2,
	x_attribute11		  		VARCHAR2,
	x_attribute12		  		VARCHAR2,
	x_attribute13		  		VARCHAR2,
	x_attribute14		  		VARCHAR2,
	x_attribute15		  		VARCHAR2,
	x_last_update_login	  		NUMBER,
        x_disable_flag                          VARCHAR2) is
    -- 
    l_api_version      CONSTANT NUMBER := 1.0;

Line: 58

    l_api_name         CONSTANT VARCHAR2(40) := 'update_row';

Line: 63

    UPDATE PO_APPROVED_SUPPLIER_LIST
    SET
	asl_id			= x_asl_id,
	using_organization_id   = x_using_organization_id,
	owning_organization_id  = x_owning_organization_id,
	vendor_business_type	= x_vendor_business_type,
	asl_status_id		= x_asl_status_id,
	last_update_date	= x_last_update_date,
	last_updated_by	  	= x_last_updated_by,
	creation_date		= x_creation_date,
	created_by		= x_created_by,
	manufacturer_id	  	= x_manufacturer_id,
	vendor_id		= x_vendor_id,
	item_id		  	= x_item_id,
	category_id		= x_category_id,
	vendor_site_id	  	= x_vendor_site_id,
	primary_vendor_item  	= x_primary_vendor_item,
	manufacturer_asl_id     = x_manufacturer_asl_id,
	comments		= x_comments,
	review_by_date	        = x_review_by_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_login	= x_last_update_login,
        disable_flag            = x_disable_flag
     WHERE rowid = x_row_id;

Line: 125

      p_event_name       =>    'oracle.apps.po.event.update_asl',
      p_entity_name      =>    'ASL',
      p_entity_id        =>    x_asl_id
  );

Line: 170

end update_row;