1 PACKAGE AHL_UNIT_ACCOMPLISH_PKG AUTHID CURRENT_USER AS
2 /* $Header: AHLLUMAS.pls 115.4 2002/12/04 23:14:18 sracha noship $ */
3 -- ARCS header version
4
5 PROCEDURE insert_row (
6 P_X_UNIT_ACCOMPLISHMNT_ID IN OUT NOCOPY NUMBER,
7 P_UNIT_EFFECTIVITY_ID IN NUMBER,
8 P_COUNTER_ID IN NUMBER,
9 P_COUNTER_VALUE IN NUMBER,
10 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
11 P_ATTRIBUTE1 IN VARCHAR2,
12 P_ATTRIBUTE2 IN VARCHAR2,
13 P_ATTRIBUTE3 IN VARCHAR2,
14 P_ATTRIBUTE4 IN VARCHAR2,
15 P_ATTRIBUTE5 IN VARCHAR2,
16 P_ATTRIBUTE6 IN VARCHAR2,
17 P_ATTRIBUTE7 IN VARCHAR2,
18 P_ATTRIBUTE8 IN VARCHAR2,
19 P_ATTRIBUTE9 IN VARCHAR2,
20 P_ATTRIBUTE10 IN VARCHAR2,
21 P_ATTRIBUTE11 IN VARCHAR2,
22 P_ATTRIBUTE12 IN VARCHAR2,
23 P_ATTRIBUTE13 IN VARCHAR2,
24 P_ATTRIBUTE14 IN VARCHAR2,
25 P_ATTRIBUTE15 IN VARCHAR2,
26 P_OBJECT_VERSION_NUMBER IN NUMBER,
27 P_LAST_UPDATE_DATE IN DATE,
28 P_LAST_UPDATED_BY IN NUMBER,
29 P_CREATION_DATE IN DATE,
30 P_CREATED_BY IN NUMBER,
31 P_LAST_UPDATE_LOGIN IN NUMBER
32 );
33
34 PROCEDURE update_row (
35 P_UNIT_ACCOMPLISHMNT_ID IN NUMBER,
36 P_UNIT_EFFECTIVITY_ID IN NUMBER,
37 P_COUNTER_ID IN NUMBER,
38 P_COUNTER_VALUE IN NUMBER,
39 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
40 P_ATTRIBUTE1 IN VARCHAR2,
41 P_ATTRIBUTE2 IN VARCHAR2,
42 P_ATTRIBUTE3 IN VARCHAR2,
43 P_ATTRIBUTE4 IN VARCHAR2,
44 P_ATTRIBUTE5 IN VARCHAR2,
45 P_ATTRIBUTE6 IN VARCHAR2,
46 P_ATTRIBUTE7 IN VARCHAR2,
47 P_ATTRIBUTE8 IN VARCHAR2,
48 P_ATTRIBUTE9 IN VARCHAR2,
49 P_ATTRIBUTE10 IN VARCHAR2,
50 P_ATTRIBUTE11 IN VARCHAR2,
51 P_ATTRIBUTE12 IN VARCHAR2,
52 P_ATTRIBUTE13 IN VARCHAR2,
53 P_ATTRIBUTE14 IN VARCHAR2,
54 P_ATTRIBUTE15 IN VARCHAR2,
55 P_OBJECT_VERSION_NUMBER IN NUMBER,
56 P_LAST_UPDATE_DATE IN DATE,
57 P_LAST_UPDATED_BY IN NUMBER,
58 P_LAST_UPDATE_LOGIN IN NUMBER
59 );
60
61 procedure delete_row (
62 P_UNIT_ACCOMPLISHMNT_ID IN NUMBER
63 );
64
65
66 END AHL_UNIT_ACCOMPLISH_PKG;