1 PACKAGE PV_ENTY_ATTR_VALUE_PUB AUTHID CURRENT_USER AS
2 /* $Header: pvxvavps.pls 120.1 2005/11/11 15:28:13 amaram noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_ENTY_ATTR_VALUE_PUB
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16
17 -- ===================================================================
18 -- Start of Comments
19 -- -------------------------------------------------------
20 -- Record name
21 -- attr_val_rec_type
22 -- -------------------------------------------------------
23 -- Parameters:
24 --
25 -- attr_value
26 -- attr_value_extn
27 --
28 --
29 -- Required
30 --
31 -- Defaults
32 --
33 -- Note: This is automatic generated record definition, it includes all columns
34 -- defined in the table, developer must manually add or delete some of the attributes.
35 --
36 -- End of Comments
37
38 -- ===================================================================
39
40 TYPE attr_val_rec_type IS RECORD
41 (
42 attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
43 ,attr_value_extn VARCHAR2(4000) := FND_API.G_MISS_CHAR
44
45 );
46
47 g_miss_attr_val_rec attr_val_rec_type;
48 TYPE attr_value_tbl_type IS TABLE OF attr_val_rec_type INDEX BY BINARY_INTEGER;
49 g_miss_attr_value_tbl attr_value_tbl_type;
50
51 TYPE NUMBER_TABLE IS TABLE OF NUMBER;
52
53 /*type attr_value_table_type is TABLE of varchar2(500);
54 type attr_value_extn_table_type is TABLE of varchar2(4000);
55 g_miss_attr_value_table_type attr_value_table_type;
56 g_miss_attr_value_extn_table attr_value_extn_table_type;
57
58
59
60 TYPE attr_val_rec_group_type IS RECORD
61
62 (
63 attribute_id NUMBER := FND_API.G_MISS_NUM
64 ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
65 ,entity_id NUMBER := FND_API.G_MISS_NUM
66 ,version NUMBER := FND_API.G_MISS_NUM
67 ,attr_val_tbl attr_value_table_type := g_miss_attr_value_table_type
68 --,attr_value_extn_tbl attr_value_extn_table_type := g_miss_attr_value_extn_table
69
70 );
71
72 g_miss_attr_val_group_rec attr_val_rec_group_type;
73 TYPE attr_value_group_tbl_type IS TABLE OF attr_val_rec_group_type INDEX BY BINARY_INTEGER;
74 g_miss_attr_value_group_tbl attr_value_group_tbl_type;
75 */
76 -- ==============================================================================
77 -- Start of Comments
78 -- ==============================================================================
79 -- API Name
80 -- Upsert_Attr_Value
81 -- Type
82 -- Public
83 -- Pre-Req
84 --
85 -- Parameters
86 --
87 -- IN
88 -- p_api_version_number IN NUMBER Required
89 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92 -- p_attribute_id IN NUMBER Required
93 -- entity IN VARCHAR2 Required
94 -- entity_id IN NUMBER Required
95 -- version IN NUMBER Required
96 -- p_attr_val_tbl IN attr_value_tbl_type Optional Default= g_miss_attr_value_tbl
97 --
98 -- OUT
99 -- x_return_status OUT VARCHAR2
100 -- x_msg_count OUT NUMBER
101 -- x_msg_data OUT VARCHAR2
102 -- Version : Current version 1.0
103 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
104 -- and basic operation, developer must manually add parameters and business logic as necessary.
105 --
106 -- End of Comments
107 -- ==============================================================================
108 --
109
110 PROCEDURE Upsert_Attr_Value(
111 p_api_version_number 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
116 ,x_return_status OUT NOCOPY VARCHAR2
117 ,x_msg_count OUT NOCOPY NUMBER
118 ,x_msg_data OUT NOCOPY VARCHAR2
119
120 ,p_attribute_id IN NUMBER
121 ,p_entity IN VARCHAR2
122 ,p_entity_id IN NUMBER
123 ,p_version IN NUMBER :=0
124 ,p_attr_val_tbl IN attr_value_tbl_type := g_miss_attr_value_tbl
125 );
126
127 -- ==============================================================================
128 -- Start of Comments
129 -- ==============================================================================
130 -- API Name
131 -- Upsert_Attr_Value_in_groups
132 -- Type
133 -- Public
134 -- Pre-Req
135 --
136 -- Parameters
137 --
138 -- IN
139 -- p_api_version_number IN NUMBER Required
140 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143 -- p_attr_val_group_tbl IN attr_value_tbl_type Optional Default= g_miss_attr_value_group_tbl
144 --
145 -- OUT
146 -- x_return_status OUT VARCHAR2
147 -- x_msg_count OUT NUMBER
148 -- x_msg_data OUT VARCHAR2
149 -- Version : Current version 1.0
150 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
151 -- and basic operation, developer must manually add parameters and business logic as necessary.
152 --
153 -- End of Comments
154 -- ==============================================================================
155 --
156 /*
157 PROCEDURE Upsert_Attr_Value_in_groups(
158 p_api_version_number IN NUMBER
159 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162
163 ,x_return_status OUT NOCOPY VARCHAR2
164 ,x_msg_count OUT NOCOPY NUMBER
165 ,x_msg_data OUT NOCOPY VARCHAR2
166
167 ,p_attr_val_group_tbl IN attr_value_group_tbl_type := g_miss_attr_value_group_tbl
168 );
169 */
170
171 -- ==============================================================================
172 -- Start of Comments
173 -- ==============================================================================
174 -- API Name
175 -- Copy_Partner_Attr_Values
176 -- Type
177 -- Public
178 -- Pre-Req
179 --
180 -- Parameters
181 --
182 -- IN
183 -- p_api_version_number IN NUMBER Required
184 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
185 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
186 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187 -- p_attr_id_tbl IN JTF_NUMBER_TABLE Required
188 -- entity IN VARCHAR2 Required
189 -- entity_id IN NUMBER Required
190 -- p_partner_id IN NUMBER Required
191
192 --
193 -- OUT
194 -- x_return_status OUT VARCHAR2
195 -- x_msg_count OUT NUMBER
196 -- x_msg_data OUT VARCHAR2
197 -- Version : Current version 1.0
198 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
199 -- and basic operation, developer must manually add parameters and business logic as necessary.
200 --
201 -- End of Comments
202 -- ==============================================================================
203 --
204
205 PROCEDURE Copy_Partner_Attr_Values(
206 p_api_version_number IN NUMBER
207 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
208 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
209 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
210
211 ,x_return_status OUT NOCOPY VARCHAR2
212 ,x_msg_count OUT NOCOPY NUMBER
213 ,x_msg_data OUT NOCOPY VARCHAR2
214
215 ,p_attr_id_tbl IN NUMBER_TABLE
216 ,p_entity IN VARCHAR2
217 ,p_entity_id IN NUMBER
218 ,p_partner_id IN NUMBER
219
220 );
221
222 -- ==============================================================================
223 -- Start of Comments
224 -- ==============================================================================
225 -- API Name
226 -- Upsert_Partner_Types
227 -- Type
228 -- Public
229 -- Pre-Req
230 --
231 -- Parameters
232 --
233 -- IN
234 -- p_api_version_number IN NUMBER Required
235 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
237 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
238 -- p_entity_id IN NUMBER Required
239 -- p_version IN NUMBER Required
240 -- p_attr_val_tbl IN attr_value_tbl_type Required
241
242 --
243 -- OUT
244 -- x_return_status OUT VARCHAR2
245 -- x_msg_count OUT NUMBER
246 -- x_msg_data OUT VARCHAR2
247 -- Version : Current version 1.0
248 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
249 -- and basic operation, developer must manually add parameters and business logic as necessary.
250 --
251 -- End of Comments
252 -- ==============================================================================
253 --
254 PROCEDURE Upsert_Partner_Types (
255 p_api_version_number IN NUMBER
256 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
257 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
258 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
259 ,x_return_status OUT NOCOPY VARCHAR2
260 ,x_msg_count OUT NOCOPY NUMBER
261 ,x_msg_data OUT NOCOPY VARCHAR2
262 ,p_entity_id IN NUMBER
263 ,p_version IN NUMBER :=0
264 ,p_attr_val_tbl IN attr_value_tbl_type := g_miss_attr_value_tbl
265 );
266
267
268 END PV_ENTY_ATTR_VALUE_PUB;