62:
63: --===================================================================
64: TYPE attribute_rec_type IS RECORD
65: (
66: attribute_id NUMBER := FND_API.G_MISS_NUM
67: ,last_update_date DATE := FND_API.G_MISS_DATE
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
63: --===================================================================
64: TYPE attribute_rec_type IS RECORD
65: (
66: attribute_id NUMBER := FND_API.G_MISS_NUM
67: ,last_update_date DATE := FND_API.G_MISS_DATE
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
64: TYPE attribute_rec_type IS RECORD
65: (
66: attribute_id NUMBER := FND_API.G_MISS_NUM
67: ,last_update_date DATE := FND_API.G_MISS_DATE
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
65: (
66: attribute_id NUMBER := FND_API.G_MISS_NUM
67: ,last_update_date DATE := FND_API.G_MISS_DATE
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
66: attribute_id NUMBER := FND_API.G_MISS_NUM
67: ,last_update_date DATE := FND_API.G_MISS_DATE
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
67: ,last_update_date DATE := FND_API.G_MISS_DATE
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
68: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
69: ,creation_date DATE := FND_API.G_MISS_DATE
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
70: ,created_by NUMBER := FND_API.G_MISS_NUM
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
71: ,last_update_login NUMBER := FND_API.G_MISS_NUM
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
72: ,object_version_number NUMBER := FND_API.G_MISS_NUM
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
73: --,security_group_id NUMBER := FND_API.G_MISS_NUM
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
74: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
75: ,attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
76: ,attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
77: ,seeded_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
78: ,lov_function_name VARCHAR2(30) := FND_API.G_MISS_CHAR
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
79: ,return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
80: ,max_value_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: ,name VARCHAR2(60) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
82: ,description VARCHAR2(240) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
83: ,short_name VARCHAR2(60) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
84: ,display_style VARCHAR2(30) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
85: ,character_width NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,sequence_number NUMBER := FND_API.G_MISS_NUM
86: ,decimal_points NUMBER := FND_API.G_MISS_NUM
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,sequence_number NUMBER := FND_API.G_MISS_NUM
94: );
87: ,no_of_lines NUMBER := FND_API.G_MISS_NUM
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,sequence_number NUMBER := FND_API.G_MISS_NUM
94: );
95:
88: ,expose_to_partner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,sequence_number NUMBER := FND_API.G_MISS_NUM
94: );
95:
96: g_miss_attribute_rec attribute_rec_type;
89: ,value_extn_return_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: ,enable_matching_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: ,performance_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: ,additive_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
93: ,sequence_number NUMBER := FND_API.G_MISS_NUM
94: );
95:
96: g_miss_attribute_rec attribute_rec_type;
97: TYPE attribute_tbl_type IS TABLE OF attribute_rec_type INDEX BY BINARY_INTEGER;
109: -- Parameters
110: --
111: -- IN
112: -- p_api_version_number IN NUMBER Required
113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_attribute_rec IN attribute_rec_type Required
117: --
110: --
111: -- IN
112: -- p_api_version_number IN NUMBER Required
113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_attribute_rec IN attribute_rec_type Required
117: --
118: -- OUT
111: -- IN
112: -- p_api_version_number IN NUMBER Required
113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_attribute_rec IN attribute_rec_type Required
117: --
118: -- OUT
119: -- x_return_status OUT VARCHAR2
128: --
129:
130: PROCEDURE Create_Attribute(
131: p_api_version_number IN NUMBER
132: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
134: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
135:
136: ,x_return_status OUT NOCOPY VARCHAR2
129:
130: PROCEDURE Create_Attribute(
131: p_api_version_number IN NUMBER
132: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
134: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
135:
136: ,x_return_status OUT NOCOPY VARCHAR2
137: ,x_msg_count OUT NOCOPY NUMBER
130: PROCEDURE Create_Attribute(
131: p_api_version_number IN NUMBER
132: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
134: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
135:
136: ,x_return_status OUT NOCOPY VARCHAR2
137: ,x_msg_count OUT NOCOPY NUMBER
138: ,x_msg_data OUT NOCOPY VARCHAR2
153: -- Parameters
154: --
155: -- IN
156: -- p_api_version_number IN NUMBER Required
157: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
158: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
159: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
160: -- p_attribute_rec IN attribute_rec_type Required
161: --
154: --
155: -- IN
156: -- p_api_version_number IN NUMBER Required
157: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
158: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
159: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
160: -- p_attribute_rec IN attribute_rec_type Required
161: --
162: -- OUT
155: -- IN
156: -- p_api_version_number IN NUMBER Required
157: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
158: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
159: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
160: -- p_attribute_rec IN attribute_rec_type Required
161: --
162: -- OUT
163: -- x_return_status OUT VARCHAR2
172: --
173:
174: PROCEDURE Update_Attribute(
175: p_api_version_number IN NUMBER
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
179:
180: ,x_return_status OUT NOCOPY VARCHAR2
173:
174: PROCEDURE Update_Attribute(
175: p_api_version_number IN NUMBER
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
179:
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER
174: PROCEDURE Update_Attribute(
175: p_api_version_number IN NUMBER
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
179:
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER
182: ,x_msg_data OUT NOCOPY VARCHAR2
197: -- Parameters
198: --
199: -- IN
200: -- p_api_version_number IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
202: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_ATTRIBUTE_ID IN NUMBER
205: -- p_object_version_number IN NUMBER Optional Default = NULL
198: --
199: -- IN
200: -- p_api_version_number IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
202: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_ATTRIBUTE_ID IN NUMBER
205: -- p_object_version_number IN NUMBER Optional Default = NULL
206: --
199: -- IN
200: -- p_api_version_number IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
202: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
204: -- p_ATTRIBUTE_ID IN NUMBER
205: -- p_object_version_number IN NUMBER Optional Default = NULL
206: --
207: -- OUT
217: --
218:
219: PROCEDURE Delete_Attribute(
220: p_api_version_number IN NUMBER
221: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
222: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
223: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
224: ,x_return_status OUT NOCOPY VARCHAR2
225: ,x_msg_count OUT NOCOPY NUMBER
218:
219: PROCEDURE Delete_Attribute(
220: p_api_version_number IN NUMBER
221: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
222: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
223: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
224: ,x_return_status OUT NOCOPY VARCHAR2
225: ,x_msg_count OUT NOCOPY NUMBER
226: ,x_msg_data OUT NOCOPY VARCHAR2
219: PROCEDURE Delete_Attribute(
220: p_api_version_number IN NUMBER
221: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
222: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
223: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
224: ,x_return_status OUT NOCOPY VARCHAR2
225: ,x_msg_count OUT NOCOPY NUMBER
226: ,x_msg_data OUT NOCOPY VARCHAR2
227: ,p_attribute_id IN NUMBER
240: -- Parameters
241: --
242: -- IN
243: -- p_api_version_number IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
247: -- p_attribute_rec IN attribute_rec_type Required
248: --
241: --
242: -- IN
243: -- p_api_version_number IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
247: -- p_attribute_rec IN attribute_rec_type Required
248: --
249: -- OUT
242: -- IN
243: -- p_api_version_number IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
247: -- p_attribute_rec IN attribute_rec_type Required
248: --
249: -- OUT
250: -- x_return_status OUT VARCHAR2
259: --
260:
261: PROCEDURE Lock_Attribute(
262: p_api_version_number IN NUMBER
263: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
264:
265: ,x_return_status OUT NOCOPY VARCHAR2
266: ,x_msg_count OUT NOCOPY NUMBER
267: ,x_msg_data OUT NOCOPY VARCHAR2
283: -- End of Comments
284:
285: PROCEDURE Validate_attribute(
286: p_api_version_number IN NUMBER
287: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
288: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
289: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_UPDATE
290: ,p_attribute_rec IN attribute_rec_type
291: ,x_return_status OUT NOCOPY VARCHAR2
284:
285: PROCEDURE Validate_attribute(
286: p_api_version_number IN NUMBER
287: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
288: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
289: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_UPDATE
290: ,p_attribute_rec IN attribute_rec_type
291: ,x_return_status OUT NOCOPY VARCHAR2
292: ,x_msg_count OUT NOCOPY NUMBER
322: -- End of Comments
323:
324: PROCEDURE Validate_attribute_rec(
325: p_api_version_number IN NUMBER
326: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
327: ,x_return_status OUT NOCOPY VARCHAR2
328: ,x_msg_count OUT NOCOPY NUMBER
329: ,x_msg_data OUT NOCOPY VARCHAR2
330: ,p_attribute_rec IN attribute_rec_type