50:
51: --===================================================================
52: TYPE attribute_usage_rec_type IS RECORD
53: (
54: attribute_usage_id NUMBER := FND_API.G_MISS_NUM
55: ,last_update_date DATE := FND_API.G_MISS_DATE
56: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
57: ,creation_date DATE := FND_API.G_MISS_DATE
58: ,created_by NUMBER := FND_API.G_MISS_NUM
51: --===================================================================
52: TYPE attribute_usage_rec_type IS RECORD
53: (
54: attribute_usage_id NUMBER := FND_API.G_MISS_NUM
55: ,last_update_date DATE := FND_API.G_MISS_DATE
56: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
57: ,creation_date DATE := FND_API.G_MISS_DATE
58: ,created_by NUMBER := FND_API.G_MISS_NUM
59: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: TYPE attribute_usage_rec_type IS RECORD
53: (
54: attribute_usage_id NUMBER := FND_API.G_MISS_NUM
55: ,last_update_date DATE := FND_API.G_MISS_DATE
56: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
57: ,creation_date DATE := FND_API.G_MISS_DATE
58: ,created_by NUMBER := FND_API.G_MISS_NUM
59: ,last_update_login NUMBER := FND_API.G_MISS_NUM
60: ,request_id NUMBER := FND_API.G_MISS_NUM
53: (
54: attribute_usage_id NUMBER := FND_API.G_MISS_NUM
55: ,last_update_date DATE := FND_API.G_MISS_DATE
56: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
57: ,creation_date DATE := FND_API.G_MISS_DATE
58: ,created_by NUMBER := FND_API.G_MISS_NUM
59: ,last_update_login NUMBER := FND_API.G_MISS_NUM
60: ,request_id NUMBER := FND_API.G_MISS_NUM
61: ,program_application_id NUMBER := FND_API.G_MISS_NUM
54: attribute_usage_id NUMBER := FND_API.G_MISS_NUM
55: ,last_update_date DATE := FND_API.G_MISS_DATE
56: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
57: ,creation_date DATE := FND_API.G_MISS_DATE
58: ,created_by NUMBER := FND_API.G_MISS_NUM
59: ,last_update_login NUMBER := FND_API.G_MISS_NUM
60: ,request_id NUMBER := FND_API.G_MISS_NUM
61: ,program_application_id NUMBER := FND_API.G_MISS_NUM
62: ,program_id NUMBER := FND_API.G_MISS_NUM
55: ,last_update_date DATE := FND_API.G_MISS_DATE
56: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
57: ,creation_date DATE := FND_API.G_MISS_DATE
58: ,created_by NUMBER := FND_API.G_MISS_NUM
59: ,last_update_login NUMBER := FND_API.G_MISS_NUM
60: ,request_id NUMBER := FND_API.G_MISS_NUM
61: ,program_application_id NUMBER := FND_API.G_MISS_NUM
62: ,program_id NUMBER := FND_API.G_MISS_NUM
63: ,program_update_date DATE := FND_API.G_MISS_DATE
56: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
57: ,creation_date DATE := FND_API.G_MISS_DATE
58: ,created_by NUMBER := FND_API.G_MISS_NUM
59: ,last_update_login NUMBER := FND_API.G_MISS_NUM
60: ,request_id NUMBER := FND_API.G_MISS_NUM
61: ,program_application_id NUMBER := FND_API.G_MISS_NUM
62: ,program_id NUMBER := FND_API.G_MISS_NUM
63: ,program_update_date DATE := FND_API.G_MISS_DATE
64: ,object_version_number NUMBER := FND_API.G_MISS_NUM
57: ,creation_date DATE := FND_API.G_MISS_DATE
58: ,created_by NUMBER := FND_API.G_MISS_NUM
59: ,last_update_login NUMBER := FND_API.G_MISS_NUM
60: ,request_id NUMBER := FND_API.G_MISS_NUM
61: ,program_application_id NUMBER := FND_API.G_MISS_NUM
62: ,program_id NUMBER := FND_API.G_MISS_NUM
63: ,program_update_date DATE := FND_API.G_MISS_DATE
64: ,object_version_number NUMBER := FND_API.G_MISS_NUM
65: ,attribute_usage_type VARCHAR2(30) := FND_API.G_MISS_CHAR
58: ,created_by NUMBER := FND_API.G_MISS_NUM
59: ,last_update_login NUMBER := FND_API.G_MISS_NUM
60: ,request_id NUMBER := FND_API.G_MISS_NUM
61: ,program_application_id NUMBER := FND_API.G_MISS_NUM
62: ,program_id NUMBER := FND_API.G_MISS_NUM
63: ,program_update_date DATE := FND_API.G_MISS_DATE
64: ,object_version_number NUMBER := FND_API.G_MISS_NUM
65: ,attribute_usage_type VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,attribute_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR
59: ,last_update_login NUMBER := FND_API.G_MISS_NUM
60: ,request_id NUMBER := FND_API.G_MISS_NUM
61: ,program_application_id NUMBER := FND_API.G_MISS_NUM
62: ,program_id NUMBER := FND_API.G_MISS_NUM
63: ,program_update_date DATE := FND_API.G_MISS_DATE
64: ,object_version_number NUMBER := FND_API.G_MISS_NUM
65: ,attribute_usage_type VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,attribute_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,attribute_id NUMBER := FND_API.G_MISS_NUM
60: ,request_id NUMBER := FND_API.G_MISS_NUM
61: ,program_application_id NUMBER := FND_API.G_MISS_NUM
62: ,program_id NUMBER := FND_API.G_MISS_NUM
63: ,program_update_date DATE := FND_API.G_MISS_DATE
64: ,object_version_number NUMBER := FND_API.G_MISS_NUM
65: ,attribute_usage_type VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,attribute_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,attribute_id NUMBER := FND_API.G_MISS_NUM
68: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: ,program_application_id NUMBER := FND_API.G_MISS_NUM
62: ,program_id NUMBER := FND_API.G_MISS_NUM
63: ,program_update_date DATE := FND_API.G_MISS_DATE
64: ,object_version_number NUMBER := FND_API.G_MISS_NUM
65: ,attribute_usage_type VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,attribute_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,attribute_id NUMBER := FND_API.G_MISS_NUM
68: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: --,security_group_id NUMBER := FND_API.G_MISS_NUM
62: ,program_id NUMBER := FND_API.G_MISS_NUM
63: ,program_update_date DATE := FND_API.G_MISS_DATE
64: ,object_version_number NUMBER := FND_API.G_MISS_NUM
65: ,attribute_usage_type VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,attribute_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,attribute_id NUMBER := FND_API.G_MISS_NUM
68: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: --,security_group_id NUMBER := FND_API.G_MISS_NUM
70: );
63: ,program_update_date DATE := FND_API.G_MISS_DATE
64: ,object_version_number NUMBER := FND_API.G_MISS_NUM
65: ,attribute_usage_type VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,attribute_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,attribute_id NUMBER := FND_API.G_MISS_NUM
68: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: --,security_group_id NUMBER := FND_API.G_MISS_NUM
70: );
71:
64: ,object_version_number NUMBER := FND_API.G_MISS_NUM
65: ,attribute_usage_type VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,attribute_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,attribute_id NUMBER := FND_API.G_MISS_NUM
68: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: --,security_group_id NUMBER := FND_API.G_MISS_NUM
70: );
71:
72:
65: ,attribute_usage_type VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,attribute_usage_code VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,attribute_id NUMBER := FND_API.G_MISS_NUM
68: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69: --,security_group_id NUMBER := FND_API.G_MISS_NUM
70: );
71:
72:
73: g_miss_attribute_usage_rec attribute_usage_rec_type;
86: -- Parameters
87: --
88: -- IN
89: -- p_api_version_number IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_attribute_usage_rec IN attribute_usage_rec_type Required
94: --
87: --
88: -- IN
89: -- p_api_version_number IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_attribute_usage_rec IN attribute_usage_rec_type Required
94: --
95: -- OUT
88: -- IN
89: -- p_api_version_number IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- p_attribute_usage_rec IN attribute_usage_rec_type Required
94: --
95: -- OUT
96: -- x_return_status OUT VARCHAR2
105: --
106:
107: PROCEDURE Create_Attribute_Usage(
108: p_api_version_number IN NUMBER
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
112:
113: ,x_return_status OUT NOCOPY VARCHAR2
106:
107: PROCEDURE Create_Attribute_Usage(
108: p_api_version_number IN NUMBER
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
112:
113: ,x_return_status OUT NOCOPY VARCHAR2
114: ,x_msg_count OUT NOCOPY NUMBER
107: PROCEDURE Create_Attribute_Usage(
108: p_api_version_number IN NUMBER
109: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
110: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
112:
113: ,x_return_status OUT NOCOPY VARCHAR2
114: ,x_msg_count OUT NOCOPY NUMBER
115: ,x_msg_data OUT NOCOPY VARCHAR2
130: -- Parameters
131: --
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_attribute_usage_rec IN attribute_usage_rec_type Required
138: --
131: --
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_attribute_usage_rec IN attribute_usage_rec_type Required
138: --
139: -- OUT
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_attribute_usage_rec IN attribute_usage_rec_type Required
138: --
139: -- OUT
140: -- x_return_status OUT VARCHAR2
149: --
150:
151: PROCEDURE Update_Attribute_Usage(
152: p_api_version_number IN NUMBER
153: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
154: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
155: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
156:
157: ,x_return_status OUT NOCOPY VARCHAR2
150:
151: PROCEDURE Update_Attribute_Usage(
152: p_api_version_number IN NUMBER
153: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
154: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
155: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
156:
157: ,x_return_status OUT NOCOPY VARCHAR2
158: ,x_msg_count OUT NOCOPY NUMBER
151: PROCEDURE Update_Attribute_Usage(
152: p_api_version_number IN NUMBER
153: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
154: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
155: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
156:
157: ,x_return_status OUT NOCOPY VARCHAR2
158: ,x_msg_count OUT NOCOPY NUMBER
159: ,x_msg_data OUT NOCOPY VARCHAR2
174: -- Parameters
175: --
176: -- IN
177: -- p_api_version_number IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
179: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
181: -- p_ATTRIBUTE_USAGE_ID IN NUMBER
182: -- p_object_version_number IN NUMBER Optional Default = NULL
175: --
176: -- IN
177: -- p_api_version_number IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
179: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
181: -- p_ATTRIBUTE_USAGE_ID IN NUMBER
182: -- p_object_version_number IN NUMBER Optional Default = NULL
183: --
176: -- IN
177: -- p_api_version_number IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
179: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
181: -- p_ATTRIBUTE_USAGE_ID IN NUMBER
182: -- p_object_version_number IN NUMBER Optional Default = NULL
183: --
184: -- OUT
194: --
195:
196: PROCEDURE Delete_Attribute_Usage(
197: p_api_version_number IN NUMBER
198: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
199: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
200: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
201:
202: ,x_return_status OUT NOCOPY VARCHAR2
195:
196: PROCEDURE Delete_Attribute_Usage(
197: p_api_version_number IN NUMBER
198: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
199: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
200: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
201:
202: ,x_return_status OUT NOCOPY VARCHAR2
203: ,x_msg_count OUT NOCOPY NUMBER
196: PROCEDURE Delete_Attribute_Usage(
197: p_api_version_number IN NUMBER
198: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
199: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
200: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
201:
202: ,x_return_status OUT NOCOPY VARCHAR2
203: ,x_msg_count OUT NOCOPY NUMBER
204: ,x_msg_data OUT NOCOPY VARCHAR2
219: -- Parameters
220: --
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_attribute_usage_rec IN attribute_usage_rec_type Required
227: --
220: --
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_attribute_usage_rec IN attribute_usage_rec_type Required
227: --
228: -- OUT
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_attribute_usage_rec IN attribute_usage_rec_type Required
227: --
228: -- OUT
229: -- x_return_status OUT VARCHAR2
238: --
239:
240: PROCEDURE Lock_Attribute_Usage(
241: p_api_version_number IN NUMBER
242: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
243:
244: ,x_return_status OUT NOCOPY VARCHAR2
245: ,x_msg_count OUT NOCOPY NUMBER
246: ,x_msg_data OUT NOCOPY VARCHAR2
262: -- End of Comments
263:
264: PROCEDURE Validate_Attribute_Usage(
265: p_api_version_number IN NUMBER
266: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
267: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
268: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
269: ,p_attribute_usage_rec IN attribute_usage_rec_type
270: ,x_return_status OUT NOCOPY VARCHAR2
263:
264: PROCEDURE Validate_Attribute_Usage(
265: p_api_version_number IN NUMBER
266: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
267: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
268: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
269: ,p_attribute_usage_rec IN attribute_usage_rec_type
270: ,x_return_status OUT NOCOPY VARCHAR2
271: ,x_msg_count OUT NOCOPY NUMBER
301: -- End of Comments
302:
303: PROCEDURE Validate_Attr_Usage_Rec(
304: p_api_version_number IN NUMBER
305: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
306: ,x_return_status OUT NOCOPY VARCHAR2
307: ,x_msg_count OUT NOCOPY NUMBER
308: ,x_msg_data OUT NOCOPY VARCHAR2
309: ,p_attribute_usage_rec IN attribute_usage_rec_type