[Home] [Help]
PACKAGE: APPS.CSI_CTR_DERIVED_FILTERS_PKG
Source
1 PACKAGE CSI_CTR_DERIVED_FILTERS_PKG AUTHID CURRENT_USER as
2 /* $Header: csitcdfs.pls 120.0 2005/06/10 14:00:54 rktow noship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_CTR_DERIVED_FILTERS_PKG';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitcdfs.pls';
6
7 PROCEDURE Insert_Row(
8 px_COUNTER_DERIVED_FILTER_ID IN OUT NOCOPY NUMBER
9 ,p_COUNTER_ID NUMBER
10 ,p_SEQ_NO NUMBER
11 ,p_LEFT_PARENT VARCHAR2
12 ,p_COUNTER_PROPERTY_ID NUMBER
13 ,p_RELATIONAL_OPERATOR VARCHAR2
14 ,p_RIGHT_VALUE VARCHAR2
15 ,p_RIGHT_PARENT VARCHAR2
16 ,p_LOGICAL_OPERATOR VARCHAR2
17 ,p_START_DATE_ACTIVE DATE
18 ,p_END_DATE_ACTIVE DATE
19 ,p_OBJECT_VERSION_NUMBER NUMBER
20 ,p_LAST_UPDATE_DATE DATE
21 ,p_LAST_UPDATED_BY NUMBER
22 ,p_CREATION_DATE DATE
23 ,p_CREATED_BY NUMBER
24 ,p_LAST_UPDATE_LOGIN NUMBER
25 ,p_ATTRIBUTE1 VARCHAR2
26 ,p_ATTRIBUTE2 VARCHAR2
27 ,p_ATTRIBUTE3 VARCHAR2
28 ,p_ATTRIBUTE4 VARCHAR2
29 ,p_ATTRIBUTE5 VARCHAR2
30 ,p_ATTRIBUTE6 VARCHAR2
31 ,p_ATTRIBUTE7 VARCHAR2
32 ,p_ATTRIBUTE8 VARCHAR2
33 ,p_ATTRIBUTE9 VARCHAR2
34 ,p_ATTRIBUTE10 VARCHAR2
35 ,p_ATTRIBUTE11 VARCHAR2
36 ,p_ATTRIBUTE12 VARCHAR2
37 ,p_ATTRIBUTE13 VARCHAR2
38 ,p_ATTRIBUTE14 VARCHAR2
39 ,p_ATTRIBUTE15 VARCHAR2
40 ,p_ATTRIBUTE_CATEGORY VARCHAR2
41 ,p_SECURITY_GROUP_ID NUMBER
42 ,p_MIGRATED_FLAG VARCHAR2
43 );
44
45 PROCEDURE Update_Row(
46 p_COUNTER_DERIVED_FILTER_ID NUMBER
47 ,p_COUNTER_ID NUMBER
48 ,p_SEQ_NO NUMBER
49 ,p_LEFT_PARENT VARCHAR2
50 ,p_COUNTER_PROPERTY_ID NUMBER
51 ,p_RELATIONAL_OPERATOR VARCHAR2
52 ,p_RIGHT_VALUE VARCHAR2
53 ,p_RIGHT_PARENT VARCHAR2
54 ,p_LOGICAL_OPERATOR VARCHAR2
55 ,p_START_DATE_ACTIVE DATE
56 ,p_END_DATE_ACTIVE DATE
57 ,p_OBJECT_VERSION_NUMBER NUMBER
58 ,p_LAST_UPDATE_DATE DATE
59 ,p_LAST_UPDATED_BY NUMBER
60 ,p_CREATION_DATE DATE
61 ,p_CREATED_BY NUMBER
62 ,p_LAST_UPDATE_LOGIN NUMBER
63 ,p_ATTRIBUTE1 VARCHAR2
64 ,p_ATTRIBUTE2 VARCHAR2
65 ,p_ATTRIBUTE3 VARCHAR2
66 ,p_ATTRIBUTE4 VARCHAR2
67 ,p_ATTRIBUTE5 VARCHAR2
68 ,p_ATTRIBUTE6 VARCHAR2
69 ,p_ATTRIBUTE7 VARCHAR2
70 ,p_ATTRIBUTE8 VARCHAR2
71 ,p_ATTRIBUTE9 VARCHAR2
72 ,p_ATTRIBUTE10 VARCHAR2
73 ,p_ATTRIBUTE11 VARCHAR2
74 ,p_ATTRIBUTE12 VARCHAR2
75 ,p_ATTRIBUTE13 VARCHAR2
76 ,p_ATTRIBUTE14 VARCHAR2
77 ,p_ATTRIBUTE15 VARCHAR2
78 ,p_ATTRIBUTE_CATEGORY VARCHAR2
79 ,p_SECURITY_GROUP_ID NUMBER
80 ,p_MIGRATED_FLAG VARCHAR2
81 );
82
83 PROCEDURE Lock_Row(
84 p_COUNTER_DERIVED_FILTER_ID NUMBER
85 ,p_COUNTER_ID NUMBER
86 ,p_SEQ_NO NUMBER
87 ,p_LEFT_PARENT VARCHAR2
88 ,p_COUNTER_PROPERTY_ID NUMBER
89 ,p_RELATIONAL_OPERATOR VARCHAR2
90 ,p_RIGHT_VALUE VARCHAR2
91 ,p_RIGHT_PARENT VARCHAR2
92 ,p_LOGICAL_OPERATOR VARCHAR2
93 ,p_START_DATE_ACTIVE DATE
94 ,p_END_DATE_ACTIVE DATE
95 ,p_OBJECT_VERSION_NUMBER NUMBER
96 ,p_LAST_UPDATE_DATE DATE
97 ,p_LAST_UPDATED_BY NUMBER
98 ,p_CREATION_DATE DATE
99 ,p_CREATED_BY NUMBER
100 ,p_LAST_UPDATE_LOGIN NUMBER
101 ,p_ATTRIBUTE1 VARCHAR2
102 ,p_ATTRIBUTE2 VARCHAR2
103 ,p_ATTRIBUTE3 VARCHAR2
104 ,p_ATTRIBUTE4 VARCHAR2
105 ,p_ATTRIBUTE5 VARCHAR2
106 ,p_ATTRIBUTE6 VARCHAR2
107 ,p_ATTRIBUTE7 VARCHAR2
108 ,p_ATTRIBUTE8 VARCHAR2
109 ,p_ATTRIBUTE9 VARCHAR2
110 ,p_ATTRIBUTE10 VARCHAR2
111 ,p_ATTRIBUTE11 VARCHAR2
112 ,p_ATTRIBUTE12 VARCHAR2
113 ,p_ATTRIBUTE13 VARCHAR2
114 ,p_ATTRIBUTE14 VARCHAR2
115 ,p_ATTRIBUTE15 VARCHAR2
116 ,p_ATTRIBUTE_CATEGORY VARCHAR2
117 ,p_SECURITY_GROUP_ID NUMBER
118 ,p_MIGRATED_FLAG VARCHAR2
119 );
120
121 PROCEDURE Delete_Row(
122 p_COUNTER_DERIVED_FILTER_ID NUMBER
123 );
124
125 End CSI_CTR_DERIVED_FILTERS_PKG;