[Home] [Help]
PACKAGE: APPS.PV_ATTRIBUTE_PKG
Source
1 PACKAGE PV_ATTRIBUTE_PKG AS
2 /* $Header: pvxtatss.pls 120.1 2005/06/30 13:07:51 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_ATTRIBUTE_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 PROCEDURE Insert_Row(
17 px_attribute_id IN OUT NOCOPY NUMBER,
18 p_last_update_date DATE,
19 p_last_updated_by NUMBER,
20 p_creation_date DATE,
21 p_created_by NUMBER,
22 p_last_update_login NUMBER,
23 px_object_version_number IN OUT NOCOPY NUMBER,
24 --p_security_group_id NUMBER,
25 p_enabled_flag VARCHAR2,
26 p_attribute_type VARCHAR2,
27 p_attribute_category VARCHAR2,
28 p_seeded_flag VARCHAR2,
29 p_lov_function_name VARCHAR2,
30 p_return_type VARCHAR2,
31 p_max_value_flag VARCHAR2,
32 p_name VARCHAR2,
33 p_description VARCHAR2,
34 p_short_name VARCHAR2,
35
36 --new columns added
37
38 p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
39 p_character_width NUMBER := FND_API.G_MISS_NUM,
40 p_decimal_points NUMBER := FND_API.G_MISS_NUM,
41 p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
42 p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
43 p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
44 p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
45 p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
46 p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
47 p_sequence_number NUMBER := FND_API.G_MISS_NUM
48 );
49
50 PROCEDURE Update_Row(
51 p_attribute_id NUMBER,
52 p_last_update_date DATE,
53 p_last_updated_by NUMBER,
54 --p_creation_date DATE,
55 --p_created_by NUMBER,
56 p_last_update_login NUMBER,
57 p_object_version_number NUMBER,
58 --p_security_group_id NUMBER,
59 p_enabled_flag VARCHAR2,
60 p_attribute_type VARCHAR2,
61 p_attribute_category VARCHAR2,
62 p_seeded_flag VARCHAR2,
63 p_lov_function_name VARCHAR2,
64 p_return_type VARCHAR2,
65 p_max_value_flag VARCHAR2,
66 p_name VARCHAR2,
67 p_description VARCHAR2,
68 p_short_name VARCHAR2,
69
70 --new columns added
71
72 p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
73 p_character_width NUMBER := FND_API.G_MISS_NUM,
74 p_decimal_points NUMBER := FND_API.G_MISS_NUM,
75 p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
76 p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
77 p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
78 p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
79 p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
80 p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
81 p_sequence_number NUMBER := FND_API.G_MISS_NUM
82 );
83
84 PROCEDURE Update_Row_Seed(
85 p_attribute_id NUMBER,
86 p_last_update_date DATE,
87 p_last_updated_by NUMBER,
88 --p_creation_date DATE,
89 --p_created_by NUMBER,
90 p_last_update_login NUMBER,
91 p_object_version_number NUMBER,
92 --p_security_group_id NUMBER,
93 p_enabled_flag VARCHAR2,
94 p_attribute_type VARCHAR2,
95 p_attribute_category VARCHAR2,
96 p_seeded_flag VARCHAR2,
97 p_lov_function_name VARCHAR2,
98 p_return_type VARCHAR2,
99 p_max_value_flag VARCHAR2,
100 p_name VARCHAR2,
101 p_description VARCHAR2,
102 p_short_name VARCHAR2,
103
104 --new columns added
105
106 p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
107 p_character_width NUMBER := FND_API.G_MISS_NUM,
108 p_decimal_points NUMBER := FND_API.G_MISS_NUM,
109 p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
110 p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
111 p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
112 p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
113 p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
114 p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_sequence_number NUMBER := FND_API.G_MISS_NUM
116 );
117
118 PROCEDURE Delete_Row(
119 p_ATTRIBUTE_ID NUMBER
120 );
121
122 PROCEDURE Lock_Row(
123 p_attribute_id NUMBER,
124 p_last_update_date DATE,
125 p_last_updated_by NUMBER,
126 p_creation_date DATE,
127 p_created_by NUMBER,
128 p_last_update_login NUMBER,
129 p_object_version_number NUMBER,
130 --p_security_group_id NUMBER,
131 p_enabled_flag VARCHAR2,
132 p_attribute_type VARCHAR2,
133 p_attribute_category VARCHAR2,
134 p_seeded_flag VARCHAR2,
135 p_lov_function_name VARCHAR2,
136 p_return_type VARCHAR2,
137 p_max_value_flag VARCHAR2,
138
139 --new columns added
140
141 p_display_style VARCHAR2 := FND_API.G_MISS_CHAR,
142 p_character_width NUMBER := FND_API.G_MISS_NUM,
143 p_decimal_points NUMBER := FND_API.G_MISS_NUM,
144 p_no_of_lines NUMBER := FND_API.G_MISS_NUM,
145 p_expose_to_partner_flag VARCHAR2 := FND_API.G_MISS_CHAR,
146 p_value_extn_return_type VARCHAR2 := FND_API.G_MISS_CHAR,
147 p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
148 p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
149 p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
150 p_sequence_number NUMBER := FND_API.G_MISS_NUM
151 );
152
153
154 procedure ADD_LANGUAGE;
155
156
157 procedure TRANSLATE_ROW(
158 p_attribute_id in NUMBER,
159 p_name in VARCHAR2,
160 p_description in VARCHAR2,
161 p_owner in VARCHAR2
162 );
163
164 procedure LOAD_ROW(
165 p_attribute_id IN NUMBER,
166 --p_creation_date IN DATE,
167 --p_created_by IN NUMBER,
168 --p_security_group_id IN NUMBER,
169 p_enabled_flag IN VARCHAR2,
170 p_attribute_type IN VARCHAR2,
171 p_attribute_category IN VARCHAR2,
172 p_seeded_flag IN VARCHAR2,
173 p_lov_function_name IN VARCHAR2,
174 p_return_type IN VARCHAR2,
175 p_max_value_flag IN VARCHAR2,
176 p_name IN VARCHAR2,
177 p_description IN VARCHAR2,
178 p_short_name IN VARCHAR2,
179 p_owner IN VARCHAR2,
180
181 --new columns added
182
183 p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
184 p_character_width IN NUMBER := FND_API.G_MISS_NUM,
185 p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
186 p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
187 p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
188 p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
189 p_enable_matching_flag VARCHAR2 := FND_API.G_MISS_CHAR,
190 p_performance_flag VARCHAR2 := FND_API.G_MISS_CHAR,
191 p_additive_flag VARCHAR2 := FND_API.G_MISS_CHAR,
192 p_sequence_number NUMBER := FND_API.G_MISS_NUM
193 );
194
195 procedure LOAD_SEED_ROW(
196 p_upload_mode IN VARCHAR2,
197 p_attribute_id IN NUMBER,
198 p_enabled_flag IN VARCHAR2,
199 p_attribute_type IN VARCHAR2,
200 p_attribute_category IN VARCHAR2,
201 p_seeded_flag IN VARCHAR2,
202 p_lov_function_name IN VARCHAR2,
203 p_return_type IN VARCHAR2,
204 p_max_value_flag IN VARCHAR2,
205 p_name IN VARCHAR2,
206 p_description IN VARCHAR2,
207 p_short_name IN VARCHAR2,
208 p_owner IN VARCHAR2,
209 p_display_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
210 p_character_width IN NUMBER := FND_API.G_MISS_NUM,
211 p_decimal_points IN NUMBER := FND_API.G_MISS_NUM,
212 p_no_of_lines IN NUMBER := FND_API.G_MISS_NUM,
213 p_expose_to_partner_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
214 p_value_extn_return_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
215 p_enable_matching_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
216 p_performance_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
217 p_additive_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
218 p_sequence_number IN NUMBER := FND_API.G_MISS_NUM
219 );
220
221 END PV_ATTRIBUTE_PKG;