APPS.PO_ASL_THS SQL Statements

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

Line: 12

  PROCEDURE NAME:	insert_row()

===============================================================================*/
procedure insert_row(
	x_row_id		  IN OUT NOCOPY 	VARCHAR2,
	x_asl_id		  IN OUT	NOCOPY 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

  cursor row_id is 	SELECT rowid
			FROM   PO_APPROVED_SUPPLIER_LIST
    		   	WHERE  x_asl_id = asl_id;

Line: 66

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

Line: 93

    SELECT po_approved_supplier_list_s.nextval
    INTO   x_asl_id
    FROM   sys.dual;

Line: 99

    INSERT INTO PO_APPROVED_SUPPLIER_LIST(
	asl_id		  	,
	using_organization_id   ,
	owning_organization_id  ,
	vendor_business_type	,
	asl_status_id		,
	last_update_date	,
	last_updated_by	  	,
	creation_date		,
	created_by		,
	manufacturer_id	  	,
	vendor_id		,
	item_id		  	,
	category_id		,
	vendor_site_id	  	,
	primary_vendor_item  	,
	manufacturer_asl_id     ,
	comments		,
	review_by_date		,
	attribute_category	,
	attribute1		,
	attribute2		,
	attribute3		,
	attribute4		,
	attribute5		,
	attribute6		,
	attribute7		,
	attribute8		,
	attribute9		,
	attribute10		,
	attribute11		,
	attribute12		,
	attribute13		,
	attribute14		,
	attribute15		,
	last_update_login	,
        disable_flag
     )  VALUES 			(
	x_asl_id		  ,
	x_using_organization_id   ,
	x_owning_organization_id  ,
	x_vendor_business_type	  ,
	x_asl_status_id		  ,
	x_last_update_date	  ,
	x_last_updated_by	  ,
	x_creation_date		  ,
	x_created_by		  ,
	x_manufacturer_id	  ,
	x_vendor_id		  ,
	x_item_id		  ,
	x_category_id		  ,
	x_vendor_site_id	  ,
	x_primary_vendor_item  	  ,
	x_manufacturer_asl_id     ,
	x_comments		  ,
	x_review_by_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		  ,
	x_last_update_login	  ,
        x_disable_flag
	);

Line: 246

end insert_row;