DBA Data[Home] [Help]

PACKAGE: APPS.PO_ASL_THS

Source


1 PACKAGE PO_ASL_THS AUTHID CURRENT_USER as
2 /* $Header: POXA2LSS.pls 115.3 2002/11/23 03:37:41 sbull ship $ */
3 
4 /*===========================================================================
5   PACKAGE NAME:		po_asl_ths
6 
7   DESCRIPTION:		Table Handlers for PO_APPROVED_SUPPLIER_LIST - Part 1
8 
9   CLIENT/SERVER:	Server
10 
11   LIBRARY NAME
12 
13   OWNER:                Liza Broadbent
14 
15   PROCEDURE NAMES:	insert_row()
16 
17 ===========================================================================*/
18 /*===========================================================================
19   PROCEDURE NAME:	insert_row
20 
21 
22   DESCRIPTION:     	Insert table handler for PO_APPROVED_SUPPLIER_LIST
23 
24 
25   CHANGE HISTORY:  	20-May-96	lbroadbe	Created
26 
27 ===============================================================================*/
28 procedure insert_row(
29 	x_row_id		  IN OUT NOCOPY 	VARCHAR2,
30 	x_asl_id		  IN OUT	NOCOPY 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_last_update_date	  		DATE,
36 	x_last_updated_by	  		NUMBER,
37 	x_creation_date		  		DATE,
38 	x_created_by		  		NUMBER,
39 	x_manufacturer_id	  		NUMBER,
40 	x_vendor_id		  		NUMBER,
41 	x_item_id		  		NUMBER,
42 	x_category_id		  		NUMBER,
43 	x_vendor_site_id	  		NUMBER,
44 	x_primary_vendor_item  	  		VARCHAR2,
45 	x_manufacturer_asl_id     		NUMBER,
46 	x_comments				VARCHAR2,
47 	x_review_by_date			DATE,
48 	x_attribute_category	  		VARCHAR2,
49 	x_attribute1		  		VARCHAR2,
50 	x_attribute2		  		VARCHAR2,
51 	x_attribute3		  		VARCHAR2,
52 	x_attribute4		  		VARCHAR2,
53 	x_attribute5		  		VARCHAR2,
54 	x_attribute6		  		VARCHAR2,
55 	x_attribute7		  		VARCHAR2,
56 	x_attribute8		  		VARCHAR2,
57 	x_attribute9		  		VARCHAR2,
58 	x_attribute10		  		VARCHAR2,
59 	x_attribute11		  		VARCHAR2,
60 	x_attribute12		  		VARCHAR2,
61 	x_attribute13		  		VARCHAR2,
62 	x_attribute14		  		VARCHAR2,
63 	x_attribute15		  		VARCHAR2,
64 	x_last_update_login	  		NUMBER,
65         x_disable_flag                          VARCHAR2);
66 
67 END PO_ASL_THS;