PACKAGE BODY: APPS.PO_ASL_DOCUMENTS_THS1

Source

1 PACKAGE BODY PO_ASL_DOCUMENTS_THS1 as
2 /* $Header: POXAALSB.pls 115.0 99/07/17 01:34:42 porting ship $ */
3 
4 /*=============================================================================
5 
6   PROCEDURE NAME:	update_row()
7 
8 ===============================================================================*/
9 procedure update_row(
10 	x_row_id		  		VARCHAR2,
11 	x_asl_id		  		NUMBER,
12 	x_using_organization_id   		NUMBER,
13 	x_sequence_num				NUMBER,
14 	x_document_type_code			VARCHAR2,
15 	x_document_header_id			NUMBER,
16 	x_document_line_id			NUMBER,
17 	x_last_update_date	  		DATE,
18 	x_last_updated_by	  		NUMBER,
19 	x_creation_date		  		DATE,
20 	x_created_by		  		NUMBER,
21 	x_attribute_category	  		VARCHAR2,
22 	x_attribute1		  		VARCHAR2,
23 	x_attribute2		  		VARCHAR2,
24 	x_attribute3		  		VARCHAR2,
25 	x_attribute4		  		VARCHAR2,
26 	x_attribute5		  		VARCHAR2,
27 	x_attribute6		  		VARCHAR2,
28 	x_attribute7		  		VARCHAR2,
29 	x_attribute8		  		VARCHAR2,
30 	x_attribute9		  		VARCHAR2,
31 	x_attribute10		  		VARCHAR2,
32 	x_attribute11		  		VARCHAR2,
33 	x_attribute12		  		VARCHAR2,
34 	x_attribute13		  		VARCHAR2,
35 	x_attribute14		  		VARCHAR2,
36 	x_attribute15		  		VARCHAR2,
37 	x_last_update_login	  		NUMBER) is
38 begin
39 
40 
41     UPDATE PO_ASL_DOCUMENTS
42     SET
43 	asl_id			   = x_asl_id				,
44 	using_organization_id      = x_using_organization_id		,
45 	sequence_num		   = x_sequence_num			,
46 	document_type_code	   = x_document_type_code		,
47 	document_header_id	   = x_document_header_id		,
48 	document_line_id	   = x_document_line_id			,
49 	last_update_date	   = x_last_update_date			,
50 	last_updated_by	  	   = x_last_updated_by			,
51 	creation_date		   = x_creation_date			,
52 	created_by		   = x_created_by			,
53 	attribute_category	   = x_attribute_category		,
54 	attribute1		   = x_attribute1			,
55 	attribute2		   = x_attribute2			,
56 	attribute3		   = x_attribute3			,
57 	attribute4		   = x_attribute4			,
58 	attribute5		   = x_attribute5			,
59 	attribute6		   = x_attribute6			,
60 	attribute7		   = x_attribute7			,
61 	attribute8		   = x_attribute8			,
62 	attribute9		   = x_attribute9			,
63 	attribute10		   = x_attribute10			,
64 	attribute11		   = x_attribute11			,
65 	attribute12		   = x_attribute12			,
66 	attribute13		   = x_attribute13			,
67 	attribute14		   = x_attribute14			,
68 	attribute15		   = x_attribute15			,
69 	last_update_login	   = x_last_update_login
70      WHERE rowid = x_row_id;
71 
72   if (sql%notfound) then
73     raise no_data_found;
74   end if;
75 
76 end update_row;
77 
78 END PO_ASL_DOCUMENTS_THS1;