1 package PSB_ATTRIBUTE_VALUES_PVT as
2 /* $Header: PSBVPAVS.pls 120.2 2005/07/13 11:27:50 shtripat ship $ */
3
4 procedure INSERT_ROW (
5 p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE,
8 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9 p_return_status OUT NOCOPY VARCHAR2,
10 p_msg_count OUT NOCOPY NUMBER,
11 p_msg_data OUT NOCOPY VARCHAR2,
12 --
13 P_ROWID in OUT NOCOPY VARCHAR2,
14 --
15 P_ATTRIBUTE_VALUE_ID in NUMBER,
16 P_ATTRIBUTE_ID in NUMBER,
17 P_ATTRIBUTE_VALUE in VARCHAR2,
18 P_HR_VALUE_ID in VARCHAR2,
19 P_DESCRIPTION in VARCHAR2,
20 P_DATA_EXTRACT_ID in NUMBER,
21 P_CONTEXT in VARCHAR2,
22 P_ATTRIBUTE1 in VARCHAR2,
23 P_ATTRIBUTE2 in VARCHAR2,
24 P_ATTRIBUTE3 in VARCHAR2,
25 P_ATTRIBUTE4 in VARCHAR2,
26 P_ATTRIBUTE5 in VARCHAR2,
27 P_ATTRIBUTE6 in VARCHAR2,
28 P_ATTRIBUTE7 in VARCHAR2,
29 P_ATTRIBUTE8 in VARCHAR2,
30 P_ATTRIBUTE9 in VARCHAR2,
31 P_ATTRIBUTE10 in VARCHAR2,
32 P_ATTRIBUTE11 in VARCHAR2,
33 P_ATTRIBUTE12 in VARCHAR2,
34 P_ATTRIBUTE13 in VARCHAR2,
35 P_ATTRIBUTE14 in VARCHAR2,
36 P_ATTRIBUTE15 in VARCHAR2,
37 P_ATTRIBUTE16 in VARCHAR2,
38 P_ATTRIBUTE17 in VARCHAR2,
39 P_ATTRIBUTE18 in VARCHAR2,
40 P_ATTRIBUTE19 in VARCHAR2,
41 P_ATTRIBUTE20 in VARCHAR2,
42 P_ATTRIBUTE21 in VARCHAR2,
43 P_ATTRIBUTE22 in VARCHAR2,
44 P_ATTRIBUTE23 in VARCHAR2,
45 P_ATTRIBUTE24 in VARCHAR2,
46 P_ATTRIBUTE25 in VARCHAR2,
47 P_ATTRIBUTE26 in VARCHAR2,
48 P_ATTRIBUTE27 in VARCHAR2,
49 P_ATTRIBUTE28 in VARCHAR2,
50 P_ATTRIBUTE29 in VARCHAR2,
51 P_ATTRIBUTE30 in VARCHAR2,
52 P_LAST_UPDATE_DATE in DATE,
53 P_LAST_UPDATED_BY in NUMBER,
54 P_LAST_UPDATE_LOGIN in NUMBER,
55 P_CREATED_BY in NUMBER,
56 P_CREATION_DATE in DATE
57 );
58
59 procedure LOCK_ROW (
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 p_return_status OUT NOCOPY VARCHAR2,
65 p_msg_count OUT NOCOPY NUMBER,
66 p_msg_data OUT NOCOPY VARCHAR2,
67 --
68 p_lock_row OUT NOCOPY VARCHAR2,
69 P_ROWID in VARCHAR2,
70 --
71 P_ATTRIBUTE_VALUE_ID in NUMBER,
72 P_ATTRIBUTE_ID in NUMBER,
73 P_ATTRIBUTE_VALUE in VARCHAR2,
74 P_HR_VALUE_ID in VARCHAR2,
75 P_DESCRIPTION in VARCHAR2,
76 P_DATA_EXTRACT_ID in NUMBER,
77 P_CONTEXT in VARCHAR2,
78 P_ATTRIBUTE1 in VARCHAR2,
79 P_ATTRIBUTE2 in VARCHAR2,
80 P_ATTRIBUTE3 in VARCHAR2,
81 P_ATTRIBUTE4 in VARCHAR2,
82 P_ATTRIBUTE5 in VARCHAR2,
83 P_ATTRIBUTE6 in VARCHAR2,
84 P_ATTRIBUTE7 in VARCHAR2,
85 P_ATTRIBUTE8 in VARCHAR2,
86 P_ATTRIBUTE9 in VARCHAR2,
87 P_ATTRIBUTE10 in VARCHAR2,
88 P_ATTRIBUTE11 in VARCHAR2,
89 P_ATTRIBUTE12 in VARCHAR2,
90 P_ATTRIBUTE13 in VARCHAR2,
91 P_ATTRIBUTE14 in VARCHAR2,
92 P_ATTRIBUTE15 in VARCHAR2,
93 P_ATTRIBUTE16 in VARCHAR2,
94 P_ATTRIBUTE17 in VARCHAR2,
95 P_ATTRIBUTE18 in VARCHAR2,
96 P_ATTRIBUTE19 in VARCHAR2,
97 P_ATTRIBUTE20 in VARCHAR2,
98 P_ATTRIBUTE21 in VARCHAR2,
99 P_ATTRIBUTE22 in VARCHAR2,
100 P_ATTRIBUTE23 in VARCHAR2,
101 P_ATTRIBUTE24 in VARCHAR2,
102 P_ATTRIBUTE25 in VARCHAR2,
103 P_ATTRIBUTE26 in VARCHAR2,
104 P_ATTRIBUTE27 in VARCHAR2,
105 P_ATTRIBUTE28 in VARCHAR2,
106 P_ATTRIBUTE29 in VARCHAR2,
107 P_ATTRIBUTE30 in VARCHAR2
108 );
109
110 procedure UPDATE_ROW (
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113 p_commit IN VARCHAR2 := FND_API.G_FALSE,
114 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115 p_return_status OUT NOCOPY VARCHAR2,
116 p_msg_count OUT NOCOPY NUMBER,
117 p_msg_data OUT NOCOPY VARCHAR2,
118 --
119 P_ATTRIBUTE_VALUE_ID in NUMBER,
120 P_ATTRIBUTE_ID in NUMBER,
121 P_ATTRIBUTE_VALUE in VARCHAR2,
122 P_HR_VALUE_ID in VARCHAR2,
123 P_DESCRIPTION in VARCHAR2,
124 P_DATA_EXTRACT_ID in NUMBER,
125 P_CONTEXT in VARCHAR2,
126 P_ATTRIBUTE1 in VARCHAR2,
127 P_ATTRIBUTE2 in VARCHAR2,
128 P_ATTRIBUTE3 in VARCHAR2,
129 P_ATTRIBUTE4 in VARCHAR2,
130 P_ATTRIBUTE5 in VARCHAR2,
131 P_ATTRIBUTE6 in VARCHAR2,
132 P_ATTRIBUTE7 in VARCHAR2,
133 P_ATTRIBUTE8 in VARCHAR2,
134 P_ATTRIBUTE9 in VARCHAR2,
135 P_ATTRIBUTE10 in VARCHAR2,
136 P_ATTRIBUTE11 in VARCHAR2,
137 P_ATTRIBUTE12 in VARCHAR2,
138 P_ATTRIBUTE13 in VARCHAR2,
139 P_ATTRIBUTE14 in VARCHAR2,
140 P_ATTRIBUTE15 in VARCHAR2,
141 P_ATTRIBUTE16 in VARCHAR2,
142 P_ATTRIBUTE17 in VARCHAR2,
143 P_ATTRIBUTE18 in VARCHAR2,
144 P_ATTRIBUTE19 in VARCHAR2,
145 P_ATTRIBUTE20 in VARCHAR2,
146 P_ATTRIBUTE21 in VARCHAR2,
147 P_ATTRIBUTE22 in VARCHAR2,
148 P_ATTRIBUTE23 in VARCHAR2,
149 P_ATTRIBUTE24 in VARCHAR2,
150 P_ATTRIBUTE25 in VARCHAR2,
151 P_ATTRIBUTE26 in VARCHAR2,
152 P_ATTRIBUTE27 in VARCHAR2,
153 P_ATTRIBUTE28 in VARCHAR2,
154 P_ATTRIBUTE29 in VARCHAR2,
155 P_ATTRIBUTE30 in VARCHAR2,
156 P_LAST_UPDATE_DATE in DATE,
157 P_LAST_UPDATED_BY in NUMBER,
158 P_LAST_UPDATE_LOGIN in NUMBER
159 );
160
161
162 procedure DELETE_ROW (
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165 p_commit IN VARCHAR2 := FND_API.G_FALSE,
166 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167 p_return_status OUT NOCOPY VARCHAR2,
168 p_msg_count OUT NOCOPY NUMBER,
169 p_msg_data OUT NOCOPY VARCHAR2,
170 --
171 P_ATTRIBUTE_VALUE_ID IN NUMBER
172 );
173
174
175 PROCEDURE Check_References
176 (
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179 p_commit IN VARCHAR2 := FND_API.G_FALSE,
180 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181 p_return_status OUT NOCOPY VARCHAR2,
182 p_msg_count OUT NOCOPY NUMBER,
183 p_msg_data OUT NOCOPY VARCHAR2,
184 --
185 p_ATTRIBUTE_ID IN NUMBER,
186 p_ATTRIBUTE_VALUE_ID IN NUMBER,
187 p_Return_Value IN OUT NOCOPY VARCHAR2
188 );
189
190
191 end PSB_ATTRIBUTE_VALUES_PVT;