PACKAGE: APPS.PO_ASL_THS2

Source

1 PACKAGE PO_ASL_THS2 AUTHID CURRENT_USER as
2 /* $Header: POXA4LSS.pls 115.1 99/07/17 01:33:57 porting sh $ */
3 
4 /*===========================================================================
5   PACKAGE NAME:		po_asl_ths2
6 
7   DESCRIPTION:		Table handlers for PO_APPROVED_SUPPLIER_LIST - part 3
8 
9   CLIENT/SERVER:	Server
10 
11   LIBRARY NAME
12 
13   OWNER:                Liza Broadbent
14 
15   PROCEDURE NAMES:	lock_row()
16 
17 ===========================================================================*/
18 /*===========================================================================
19   PROCEDURE NAME:	lock_row
20 
21 
22   DESCRIPTION:     	Lock table handler for PO_APPROVED_SUPPLIER_LIST
23 
24 
25   CHANGE HISTORY:  	20-May-96	lbroadbe	Created
26 
27 ===============================================================================*/
28 procedure lock_row(
29 	x_row_id		  	 	VARCHAR2,
30 	x_asl_id		 		NUMBER,
31 	x_using_organization_id   		NUMBER,
32 	x_owning_organization_id  		NUMBER,
33 	x_vendor_business_type	  		VARCHAR2,
34 	x_asl_status_id		  		NUMBER,
35 	x_manufacturer_id	  		NUMBER,
36 	x_vendor_id		  		NUMBER,
37 	x_item_id		  		NUMBER,
38 	x_category_id		  		NUMBER,
39 	x_vendor_site_id	  		NUMBER,
40 	x_primary_vendor_item  	  		VARCHAR2,
41 	x_manufacturer_asl_id     		NUMBER,
42 	x_comments				VARCHAR2,
43 	x_review_by_date			DATE,
44 	x_attribute_category	  		VARCHAR2,
45 	x_attribute1		  		VARCHAR2,
46 	x_attribute2		  		VARCHAR2,
47 	x_attribute3		  		VARCHAR2,
48 	x_attribute4		  		VARCHAR2,
49 	x_attribute5		  		VARCHAR2,
50 	x_attribute6		  		VARCHAR2,
51 	x_attribute7		  		VARCHAR2,
52 	x_attribute8		  		VARCHAR2,
53 	x_attribute9		  		VARCHAR2,
54 	x_attribute10		  		VARCHAR2,
55 	x_attribute11		  		VARCHAR2,
56 	x_attribute12		  		VARCHAR2,
57 	x_attribute13		  		VARCHAR2,
58 	x_attribute14		  		VARCHAR2,
59 	x_attribute15		  		VARCHAR2,
60         x_disable_flag                          VARCHAR2);
61 
62 END PO_ASL_THS2;