[Home] [Help]
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;