1 PACKAGE CS_CHG_SUB_REST_PKG AUTHID CURRENT_USER AS
2 /* $Header: csxrestts.pls 115.1 2004/06/04 01:45:11 aseethep noship $ */
3
4 PROCEDURE INSERT_ROW (
5 PX_RESTRICTION_ID IN OUT NOCOPY NUMBER,
6 P_RESTRICTION_TYPE IN VARCHAR2,
7 P_CONDITION IN VARCHAR2,
8 P_VALUE_OBJECT_ID IN NUMBER,
9 P_VALUE_AMOUNT IN NUMBER,
10 P_CURRENCY_CODE IN VARCHAR2,
11 P_START_DATE_ACTIVE IN DATE,
12 P_END_DATE_ACTIVE IN DATE,
13 P_CREATION_DATE IN DATE,
14 P_CREATED_BY IN NUMBER,
15 P_LAST_UPDATE_DATE IN DATE,
16 P_LAST_UPDATED_BY IN NUMBER,
17 P_LAST_UPDATE_LOGIN IN NUMBER,
18 P_ATTRIBUTE1 IN VARCHAR2,
19 P_ATTRIBUTE2 IN VARCHAR2,
20 P_ATTRIBUTE3 IN VARCHAR2,
21 P_ATTRIBUTE4 IN VARCHAR2,
22 P_ATTRIBUTE5 IN VARCHAR2,
23 P_ATTRIBUTE6 IN VARCHAR2,
24 P_ATTRIBUTE7 IN VARCHAR2,
25 P_ATTRIBUTE8 IN VARCHAR2,
26 P_ATTRIBUTE9 IN VARCHAR2,
27 P_ATTRIBUTE10 IN VARCHAR2,
28 P_ATTRIBUTE11 IN VARCHAR2,
29 P_ATTRIBUTE12 IN VARCHAR2,
30 P_ATTRIBUTE13 IN VARCHAR2,
31 P_ATTRIBUTE14 IN VARCHAR2,
32 P_ATTRIBUTE15 IN VARCHAR2,
33 P_CONTEXT IN VARCHAR2,
34 P_OBJECT_VERSION_NUMBER IN NUMBER,
35 P_SECURITY_GROUP_ID IN NUMBER);
36
37 PROCEDURE LOCK_ROW (
38 P_RESTRICTION_ID IN NUMBER,
39 P_OBJECT_VERSION_NUMBER IN NUMBER );
40
41
42 PROCEDURE UPDATE_ROW (
43 P_RESTRICTION_ID IN NUMBER,
44 P_RESTRICTION_TYPE IN VARCHAR2,
45 P_CONDITION IN VARCHAR2,
46 P_VALUE_OBJECT_ID IN NUMBER,
47 P_VALUE_AMOUNT IN NUMBER,
48 P_CURRENCY_CODE IN VARCHAR2,
49 P_START_DATE_ACTIVE IN DATE,
50 P_END_DATE_ACTIVE IN DATE,
51 P_CREATION_DATE IN DATE,
52 P_CREATED_BY IN NUMBER,
53 P_LAST_UPDATE_DATE IN DATE,
54 P_LAST_UPDATED_BY IN NUMBER,
55 P_LAST_UPDATE_LOGIN IN NUMBER,
56 P_ATTRIBUTE1 IN VARCHAR2,
57 P_ATTRIBUTE2 IN VARCHAR2,
58 P_ATTRIBUTE3 IN VARCHAR2,
59 P_ATTRIBUTE4 IN VARCHAR2,
60 P_ATTRIBUTE5 IN VARCHAR2,
61 P_ATTRIBUTE6 IN VARCHAR2,
62 P_ATTRIBUTE7 IN VARCHAR2,
63 P_ATTRIBUTE8 IN VARCHAR2,
64 P_ATTRIBUTE9 IN VARCHAR2,
65 P_ATTRIBUTE10 IN VARCHAR2,
66 P_ATTRIBUTE11 IN VARCHAR2,
67 P_ATTRIBUTE12 IN VARCHAR2,
68 P_ATTRIBUTE13 IN VARCHAR2,
69 P_ATTRIBUTE14 IN VARCHAR2,
70 P_ATTRIBUTE15 IN VARCHAR2,
71 P_CONTEXT IN VARCHAR2,
72 P_OBJECT_VERSION_NUMBER IN NUMBER,
73 P_SECURITY_GROUP_ID IN NUMBER);
74
75 PROCEDURE DELETE_ROW (
76 P_RESTRICTION_ID in NUMBER );
77
78
79 PROCEDURE LOAD_ROW (
80 P_RESTRICTION_ID IN NUMBER,
81 P_RESTRICTION_TYPE IN VARCHAR2,
82 P_CONDITION IN VARCHAR2,
83 P_VALUE_OBJECT_ID IN NUMBER,
84 P_VALUE_AMOUNT IN NUMBER,
85 P_CURRENCY_CODE IN VARCHAR2,
86 P_START_DATE_ACTIVE IN DATE,
87 P_END_DATE_ACTIVE IN DATE,
88 P_CREATION_DATE IN DATE,
89 P_CREATED_BY IN NUMBER,
90 P_LAST_UPDATE_DATE IN DATE,
91 P_LAST_UPDATED_BY IN NUMBER,
92 P_LAST_UPDATE_LOGIN IN NUMBER,
93 P_ATTRIBUTE1 IN VARCHAR2,
94 P_ATTRIBUTE2 IN VARCHAR2,
95 P_ATTRIBUTE3 IN VARCHAR2,
96 P_ATTRIBUTE4 IN VARCHAR2,
97 P_ATTRIBUTE5 IN VARCHAR2,
98 P_ATTRIBUTE6 IN VARCHAR2,
99 P_ATTRIBUTE7 IN VARCHAR2,
100 P_ATTRIBUTE8 IN VARCHAR2,
101 P_ATTRIBUTE9 IN VARCHAR2,
102 P_ATTRIBUTE10 IN VARCHAR2,
103 P_ATTRIBUTE11 IN VARCHAR2,
104 P_ATTRIBUTE12 IN VARCHAR2,
105 P_ATTRIBUTE13 IN VARCHAR2,
106 P_ATTRIBUTE14 IN VARCHAR2,
107 P_ATTRIBUTE15 IN VARCHAR2,
108 P_CONTEXT IN VARCHAR2,
109 P_OBJECT_VERSION_NUMBER IN NUMBER,
110 P_SECURITY_GROUP_ID IN NUMBER);
111
112 END CS_CHG_SUB_REST_PKG;