1 PACKAGE OKE_K_USER_ATTRIBUTES_PKG AUTHID CURRENT_USER AS
2 /* $Header: OKEKUATS.pls 115.4 2002/11/20 20:28:44 who ship $ */
3 PROCEDURE INSERT_ROW
4 ( X_ROWID IN OUT NOCOPY VARCHAR2
5 , X_K_USER_ATTRIBUTE_ID IN OUT NOCOPY NUMBER
6 , X_RECORD_VERSION_NUMBER IN OUT NOCOPY NUMBER
7 , X_CREATION_DATE IN DATE
8 , X_CREATED_BY IN NUMBER
9 , X_LAST_UPDATE_DATE IN DATE
10 , X_LAST_UPDATED_BY IN NUMBER
11 , X_LAST_UPDATE_LOGIN IN NUMBER
12 , X_K_HEADER_ID IN NUMBER
13 , X_K_LINE_ID IN NUMBER
14 , X_USER_ATTRIBUTE_CONTEXT IN VARCHAR2
15 , X_USER_ATTRIBUTE01 IN VARCHAR2
16 , X_USER_ATTRIBUTE02 IN VARCHAR2
17 , X_USER_ATTRIBUTE03 IN VARCHAR2
18 , X_USER_ATTRIBUTE04 IN VARCHAR2
19 , X_USER_ATTRIBUTE05 IN VARCHAR2
20 , X_USER_ATTRIBUTE06 IN VARCHAR2
21 , X_USER_ATTRIBUTE07 IN VARCHAR2
22 , X_USER_ATTRIBUTE08 IN VARCHAR2
23 , X_USER_ATTRIBUTE09 IN VARCHAR2
24 , X_USER_ATTRIBUTE10 IN VARCHAR2
25 , X_USER_ATTRIBUTE11 IN VARCHAR2
26 , X_USER_ATTRIBUTE12 IN VARCHAR2
27 , X_USER_ATTRIBUTE13 IN VARCHAR2
28 , X_USER_ATTRIBUTE14 IN VARCHAR2
29 , X_USER_ATTRIBUTE15 IN VARCHAR2
30 , X_USER_ATTRIBUTE16 IN VARCHAR2
31 , X_USER_ATTRIBUTE17 IN VARCHAR2
32 , X_USER_ATTRIBUTE18 IN VARCHAR2
33 , X_USER_ATTRIBUTE19 IN VARCHAR2
34 , X_USER_ATTRIBUTE20 IN VARCHAR2
35 , X_USER_ATTRIBUTE21 IN VARCHAR2
36 , X_USER_ATTRIBUTE22 IN VARCHAR2
37 , X_USER_ATTRIBUTE23 IN VARCHAR2
38 , X_USER_ATTRIBUTE24 IN VARCHAR2
39 , X_USER_ATTRIBUTE25 IN VARCHAR2
40 , X_USER_ATTRIBUTE26 IN VARCHAR2
41 , X_USER_ATTRIBUTE27 IN VARCHAR2
42 , X_USER_ATTRIBUTE28 IN VARCHAR2
43 , X_USER_ATTRIBUTE29 IN VARCHAR2
44 , X_USER_ATTRIBUTE30 IN VARCHAR2
45 );
46
47 PROCEDURE LOCK_ROW
48 ( X_ROWID IN VARCHAR2
49 , X_RECORD_VERSION_NUMBER IN NUMBER
50 );
51
52 PROCEDURE UPDATE_ROW
53 ( X_K_USER_ATTRIBUTE_ID IN NUMBER
54 , X_RECORD_VERSION_NUMBER IN OUT NOCOPY NUMBER
55 , X_LAST_UPDATE_DATE IN DATE
56 , X_LAST_UPDATED_BY IN NUMBER
57 , X_LAST_UPDATE_LOGIN IN NUMBER
58 , X_K_HEADER_ID IN NUMBER
59 , X_K_LINE_ID IN NUMBER
60 , X_USER_ATTRIBUTE_CONTEXT IN VARCHAR2
61 , X_USER_ATTRIBUTE01 IN VARCHAR2
62 , X_USER_ATTRIBUTE02 IN VARCHAR2
63 , X_USER_ATTRIBUTE03 IN VARCHAR2
64 , X_USER_ATTRIBUTE04 IN VARCHAR2
65 , X_USER_ATTRIBUTE05 IN VARCHAR2
66 , X_USER_ATTRIBUTE06 IN VARCHAR2
67 , X_USER_ATTRIBUTE07 IN VARCHAR2
68 , X_USER_ATTRIBUTE08 IN VARCHAR2
69 , X_USER_ATTRIBUTE09 IN VARCHAR2
70 , X_USER_ATTRIBUTE10 IN VARCHAR2
71 , X_USER_ATTRIBUTE11 IN VARCHAR2
72 , X_USER_ATTRIBUTE12 IN VARCHAR2
73 , X_USER_ATTRIBUTE13 IN VARCHAR2
74 , X_USER_ATTRIBUTE14 IN VARCHAR2
75 , X_USER_ATTRIBUTE15 IN VARCHAR2
76 , X_USER_ATTRIBUTE16 IN VARCHAR2
77 , X_USER_ATTRIBUTE17 IN VARCHAR2
78 , X_USER_ATTRIBUTE18 IN VARCHAR2
79 , X_USER_ATTRIBUTE19 IN VARCHAR2
80 , X_USER_ATTRIBUTE20 IN VARCHAR2
81 , X_USER_ATTRIBUTE21 IN VARCHAR2
82 , X_USER_ATTRIBUTE22 IN VARCHAR2
83 , X_USER_ATTRIBUTE23 IN VARCHAR2
84 , X_USER_ATTRIBUTE24 IN VARCHAR2
85 , X_USER_ATTRIBUTE25 IN VARCHAR2
86 , X_USER_ATTRIBUTE26 IN VARCHAR2
87 , X_USER_ATTRIBUTE27 IN VARCHAR2
88 , X_USER_ATTRIBUTE28 IN VARCHAR2
89 , X_USER_ATTRIBUTE29 IN VARCHAR2
90 , X_USER_ATTRIBUTE30 IN VARCHAR2
91 );
92
93 PROCEDURE DELETE_ROW (
94 X_K_USER_ATTRIBUTE_ID IN NUMBER
95 );
96
97 END OKE_K_USER_ATTRIBUTES_PKG;
[Home] [Help]