1 PACKAGE Ibc_Attribute_Types_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctatts.pls 120.2 2005/07/12 03:46:10 appldev ship $*/
3
4 -- Purpose: Table Handler for Ibc_Attribute_Types table.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Sri Rangarajan 01/06/2002 Created Package
10 -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX
11 -- vicho 11/13/2002 Added Overloaded procedures for OA UI
12 -- Subir Anshumali 06/03/2005 Declared OUT and IN OUT arguments as references using the NOCOPY hint
13 -- Sharma 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
14 -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
15
16 PROCEDURE insert_row (
17 x_rowid OUT NOCOPY VARCHAR2
18 ,p_attribute_type_code IN VARCHAR2
19 ,p_content_type_code IN VARCHAR2
20 ,p_data_type_code IN VARCHAR2
21 ,p_data_length IN NUMBER
22 ,p_min_instances IN NUMBER
23 ,p_max_instances IN NUMBER
24 ,p_reference_code IN VARCHAR2
25 ,p_default_value IN VARCHAR2
26 ,p_updateable_flag IN VARCHAR2
27 ,p_object_version_number IN NUMBER
28 ,p_attribute_type_name IN VARCHAR2
29 ,p_description IN VARCHAR2
30 ,p_creation_date IN DATE DEFAULT NULL
31 ,p_created_by IN NUMBER DEFAULT NULL
32 ,p_last_update_date IN DATE DEFAULT NULL
33 ,p_last_updated_by IN NUMBER DEFAULT NULL
34 ,p_last_update_login IN NUMBER DEFAULT NULL
35 ,p_display_order IN NUMBER DEFAULT NULL
36 ,p_flex_value_set_id IN NUMBER DEFAULT NULL
37 );
38
39
40 PROCEDURE lock_row (
41 p_attribute_type_code IN VARCHAR2
42 ,p_content_type_code IN VARCHAR2
43 ,p_data_type_code IN VARCHAR2
44 ,p_data_length IN NUMBER
45 ,p_min_instances IN NUMBER
46 ,p_max_instances IN NUMBER
47 ,p_reference_code IN VARCHAR2
48 ,p_default_value IN VARCHAR2
49 ,p_updateable_flag IN VARCHAR2
50 ,p_object_version_number IN NUMBER
51 ,p_attribute_type_name IN VARCHAR2
52 ,p_description IN VARCHAR2
53 );
54
55
56 PROCEDURE update_row (
57 p_attribute_type_code IN VARCHAR2
58 ,p_attribute_type_name IN VARCHAR2 DEFAULT NULL
59 ,p_content_type_code IN VARCHAR2
60 ,p_data_length IN NUMBER DEFAULT NULL
61 ,p_data_type_code IN VARCHAR2 DEFAULT NULL
62 ,p_default_value IN VARCHAR2 DEFAULT NULL
63 ,p_description IN VARCHAR2 DEFAULT NULL
64 ,p_last_updated_by IN NUMBER DEFAULT NULL
65 ,p_last_update_date IN DATE DEFAULT NULL
66 ,p_last_update_login IN NUMBER DEFAULT NULL
67 ,p_max_instances IN NUMBER DEFAULT NULL
68 ,p_min_instances IN NUMBER DEFAULT NULL
69 ,p_object_version_number IN NUMBER DEFAULT NULL
70 ,p_reference_code IN VARCHAR2 DEFAULT NULL
71 ,p_updateable_flag IN VARCHAR2 DEFAULT NULL
72 ,p_display_order IN NUMBER DEFAULT NULL
73 ,p_flex_value_set_id IN NUMBER DEFAULT NULL
74 );
75
76
77 PROCEDURE delete_row (
78 p_attribute_type_code IN VARCHAR2
79 ,p_content_type_code IN VARCHAR2
80 );
81
82 PROCEDURE delete_rows (
83 p_content_type_code IN VARCHAR2
84 );
85
86 PROCEDURE LOAD_ROW (
87 p_upload_mode IN VARCHAR2,
88 p_attribute_type_code IN VARCHAR2
89 ,p_content_type_code IN VARCHAR2
90 ,p_data_type_code IN VARCHAR2
91 ,p_data_length IN NUMBER
92 ,p_min_instances IN NUMBER
93 ,p_max_instances IN NUMBER
94 ,p_reference_code IN VARCHAR2
95 ,p_default_value IN VARCHAR2
96 ,p_updateable_flag IN VARCHAR2
97 ,p_attribute_type_name IN VARCHAR2
98 ,p_description IN VARCHAR2
99 ,p_owner IN VARCHAR2
100 ,p_display_order IN NUMBER DEFAULT NULL
101 ,p_flex_value_set_id IN NUMBER DEFAULT NULL,
102 p_last_update_date IN VARCHAR2 );
103
104 PROCEDURE LOAD_SEED_ROW (
105 p_upload_mode IN VARCHAR2,
106 p_attribute_type_code IN VARCHAR2
107 ,p_content_type_code IN VARCHAR2
108 ,p_data_type_code IN VARCHAR2
109 ,p_data_length IN NUMBER
110 ,p_min_instances IN NUMBER
111 ,p_max_instances IN NUMBER
112 ,p_reference_code IN VARCHAR2
113 ,p_default_value IN VARCHAR2
114 ,p_updateable_flag IN VARCHAR2
115 ,p_attribute_type_name IN VARCHAR2
116 ,p_description IN VARCHAR2
117 ,p_owner IN VARCHAR2
118 ,p_display_order IN NUMBER DEFAULT NULL
119 ,p_flex_value_set_id IN NUMBER DEFAULT NULL,
120 p_last_update_date IN VARCHAR2 );
121
122
123
124
125 PROCEDURE TRANSLATE_ROW (
126 p_upload_mode IN VARCHAR2,
127 p_content_type_code IN VARCHAR2
128 ,p_attribute_type_code IN VARCHAR2
129 ,p_attribute_type_name IN VARCHAR2
130 ,p_description IN VARCHAR2
131 ,p_owner IN VARCHAR2
132 , p_last_update_date IN VARCHAR2 );
133
134 PROCEDURE add_language;
135
136
137 --
138 -- Overloaded Procedures for OA Content Type UI
139 --
140 PROCEDURE INSERT_ROW (
141 X_ROWID IN OUT NOCOPY VARCHAR2,
142 X_CONTENT_TYPE_CODE IN VARCHAR2,
143 X_ATTRIBUTE_TYPE_CODE IN VARCHAR2,
144 X_MIN_INSTANCES IN NUMBER,
145 X_MAX_INSTANCES IN NUMBER,
146 X_DEFAULT_VALUE IN VARCHAR2,
147 X_UPDATEABLE_FLAG IN VARCHAR2,
148 X_REFERENCE_CODE IN VARCHAR2,
149 X_OBJECT_VERSION_NUMBER IN NUMBER,
150 X_SECURITY_GROUP_ID IN NUMBER,
151 X_DISPLAY_ORDER IN NUMBER,
152 X_FLEX_VALUE_SET_ID IN NUMBER,
153 X_DATA_TYPE_CODE IN VARCHAR2,
154 X_DATA_LENGTH IN NUMBER,
155 X_ATTRIBUTE_TYPE_NAME IN VARCHAR2,
156 X_DESCRIPTION IN VARCHAR2,
157 X_CREATION_DATE IN DATE,
158 X_CREATED_BY IN NUMBER,
159 X_LAST_UPDATE_DATE IN DATE,
160 X_LAST_UPDATED_BY IN NUMBER,
161 X_LAST_UPDATE_LOGIN IN NUMBER
162 );
163
164 PROCEDURE LOCK_ROW (
165 X_CONTENT_TYPE_CODE IN VARCHAR2,
166 X_ATTRIBUTE_TYPE_CODE IN VARCHAR2,
167 X_MIN_INSTANCES IN NUMBER,
168 X_MAX_INSTANCES IN NUMBER,
169 X_DEFAULT_VALUE IN VARCHAR2,
170 X_UPDATEABLE_FLAG IN VARCHAR2,
171 X_REFERENCE_CODE IN VARCHAR2,
172 X_OBJECT_VERSION_NUMBER IN NUMBER,
173 X_SECURITY_GROUP_ID IN NUMBER,
174 X_DISPLAY_ORDER IN NUMBER,
175 X_FLEX_VALUE_SET_ID IN NUMBER,
176 X_DATA_TYPE_CODE IN VARCHAR2,
177 X_DATA_LENGTH IN NUMBER,
178 X_ATTRIBUTE_TYPE_NAME IN VARCHAR2,
179 X_DESCRIPTION IN VARCHAR2
180 );
181
182 PROCEDURE UPDATE_ROW (
183 X_CONTENT_TYPE_CODE IN VARCHAR2,
184 X_ATTRIBUTE_TYPE_CODE IN VARCHAR2,
185 X_MIN_INSTANCES IN NUMBER,
186 X_MAX_INSTANCES IN NUMBER,
187 X_DEFAULT_VALUE IN VARCHAR2,
188 X_UPDATEABLE_FLAG IN VARCHAR2,
189 X_REFERENCE_CODE IN VARCHAR2,
190 X_OBJECT_VERSION_NUMBER IN NUMBER,
191 X_SECURITY_GROUP_ID IN NUMBER,
192 X_DISPLAY_ORDER IN NUMBER,
193 X_FLEX_VALUE_SET_ID IN NUMBER,
194 X_DATA_TYPE_CODE IN VARCHAR2,
195 X_DATA_LENGTH IN NUMBER,
196 X_ATTRIBUTE_TYPE_NAME IN VARCHAR2,
197 X_DESCRIPTION IN VARCHAR2,
198 X_LAST_UPDATE_DATE IN DATE,
199 X_LAST_UPDATED_BY IN NUMBER,
200 X_LAST_UPDATE_LOGIN IN NUMBER
201 );
202
203 PROCEDURE DELETE_ROW (
204 X_CONTENT_TYPE_CODE IN VARCHAR2,
205 X_ATTRIBUTE_TYPE_CODE IN VARCHAR2
206 );
207
208 END Ibc_Attribute_Types_Pkg;