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