50: -- ===================================================================
51:
52: TYPE enty_attr_val_rec_type IS RECORD
53: (
54: enty_attr_val_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 enty_attr_val_rec_type IS RECORD
53: (
54: enty_attr_val_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 enty_attr_val_rec_type IS RECORD
53: (
54: enty_attr_val_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: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: (
54: enty_attr_val_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: ,object_version_number NUMBER := FND_API.G_MISS_NUM
61: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
54: enty_attr_val_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: ,object_version_number NUMBER := FND_API.G_MISS_NUM
61: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
62: ,attribute_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: ,object_version_number NUMBER := FND_API.G_MISS_NUM
61: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
62: ,attribute_id NUMBER := FND_API.G_MISS_NUM
63: ,party_id NUMBER := FND_API.G_MISS_NUM
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: ,object_version_number NUMBER := FND_API.G_MISS_NUM
61: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
62: ,attribute_id NUMBER := FND_API.G_MISS_NUM
63: ,party_id NUMBER := FND_API.G_MISS_NUM
64: ,attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
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: ,object_version_number NUMBER := FND_API.G_MISS_NUM
61: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
62: ,attribute_id NUMBER := FND_API.G_MISS_NUM
63: ,party_id NUMBER := FND_API.G_MISS_NUM
64: ,attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
65: ,score 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: ,object_version_number NUMBER := FND_API.G_MISS_NUM
61: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
62: ,attribute_id NUMBER := FND_API.G_MISS_NUM
63: ,party_id NUMBER := FND_API.G_MISS_NUM
64: ,attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
65: ,score VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
59: ,last_update_login NUMBER := FND_API.G_MISS_NUM
60: ,object_version_number NUMBER := FND_API.G_MISS_NUM
61: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
62: ,attribute_id NUMBER := FND_API.G_MISS_NUM
63: ,party_id NUMBER := FND_API.G_MISS_NUM
64: ,attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
65: ,score VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
67: ,entity_id NUMBER := FND_API.G_MISS_NUM
60: ,object_version_number NUMBER := FND_API.G_MISS_NUM
61: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
62: ,attribute_id NUMBER := FND_API.G_MISS_NUM
63: ,party_id NUMBER := FND_API.G_MISS_NUM
64: ,attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
65: ,score VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
67: ,entity_id NUMBER := FND_API.G_MISS_NUM
68: -- security_group_id NUMBER := FND_API.G_MISS_NUM
61: ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
62: ,attribute_id NUMBER := FND_API.G_MISS_NUM
63: ,party_id NUMBER := FND_API.G_MISS_NUM
64: ,attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
65: ,score VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
67: ,entity_id NUMBER := FND_API.G_MISS_NUM
68: -- security_group_id NUMBER := FND_API.G_MISS_NUM
69:
62: ,attribute_id NUMBER := FND_API.G_MISS_NUM
63: ,party_id NUMBER := FND_API.G_MISS_NUM
64: ,attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
65: ,score VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
67: ,entity_id NUMBER := FND_API.G_MISS_NUM
68: -- security_group_id NUMBER := FND_API.G_MISS_NUM
69:
70: ,version NUMBER := FND_API.G_MISS_NUM
63: ,party_id NUMBER := FND_API.G_MISS_NUM
64: ,attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
65: ,score VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
67: ,entity_id NUMBER := FND_API.G_MISS_NUM
68: -- security_group_id NUMBER := FND_API.G_MISS_NUM
69:
70: ,version NUMBER := FND_API.G_MISS_NUM
71: ,latest_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
64: ,attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
65: ,score VARCHAR2(30) := FND_API.G_MISS_CHAR
66: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
67: ,entity_id NUMBER := FND_API.G_MISS_NUM
68: -- security_group_id NUMBER := FND_API.G_MISS_NUM
69:
70: ,version NUMBER := FND_API.G_MISS_NUM
71: ,latest_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
72: ,attr_value_extn VARCHAR2(4000) := FND_API.G_MISS_CHAR
66: ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
67: ,entity_id NUMBER := FND_API.G_MISS_NUM
68: -- security_group_id NUMBER := FND_API.G_MISS_NUM
69:
70: ,version NUMBER := FND_API.G_MISS_NUM
71: ,latest_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
72: ,attr_value_extn VARCHAR2(4000) := FND_API.G_MISS_CHAR
73: ,validation_id NUMBER := FND_API.G_MISS_NUM
74:
67: ,entity_id NUMBER := FND_API.G_MISS_NUM
68: -- security_group_id NUMBER := FND_API.G_MISS_NUM
69:
70: ,version NUMBER := FND_API.G_MISS_NUM
71: ,latest_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
72: ,attr_value_extn VARCHAR2(4000) := FND_API.G_MISS_CHAR
73: ,validation_id NUMBER := FND_API.G_MISS_NUM
74:
75: );
68: -- security_group_id NUMBER := FND_API.G_MISS_NUM
69:
70: ,version NUMBER := FND_API.G_MISS_NUM
71: ,latest_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
72: ,attr_value_extn VARCHAR2(4000) := FND_API.G_MISS_CHAR
73: ,validation_id NUMBER := FND_API.G_MISS_NUM
74:
75: );
76:
69:
70: ,version NUMBER := FND_API.G_MISS_NUM
71: ,latest_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
72: ,attr_value_extn VARCHAR2(4000) := FND_API.G_MISS_CHAR
73: ,validation_id NUMBER := FND_API.G_MISS_NUM
74:
75: );
76:
77: g_miss_enty_attr_val_rec enty_attr_val_rec_type;
90: -- Parameters
91: --
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
98: --
91: --
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
98: --
99: -- OUT
92: -- IN
93: -- p_api_version_number IN NUMBER Required
94: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
98: --
99: -- OUT
100: -- x_return_status OUT VARCHAR2
109: --
110:
111: PROCEDURE Create_Attr_Value(
112: p_api_version_number IN NUMBER
113: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
114: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
115: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
116:
117: ,x_return_status OUT NOCOPY VARCHAR2
110:
111: PROCEDURE Create_Attr_Value(
112: p_api_version_number IN NUMBER
113: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
114: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
115: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
116:
117: ,x_return_status OUT NOCOPY VARCHAR2
118: ,x_msg_count OUT NOCOPY NUMBER
111: PROCEDURE Create_Attr_Value(
112: p_api_version_number IN NUMBER
113: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
114: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
115: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
116:
117: ,x_return_status OUT NOCOPY VARCHAR2
118: ,x_msg_count OUT NOCOPY NUMBER
119: ,x_msg_data OUT NOCOPY VARCHAR2
134: -- Parameters
135: --
136: -- IN
137: -- p_api_version_number IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
139: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
142: --
135: --
136: -- IN
137: -- p_api_version_number IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
139: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
142: --
143: -- OUT
136: -- IN
137: -- p_api_version_number IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
139: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
142: --
143: -- OUT
144: -- x_return_status OUT VARCHAR2
153: --
154:
155: PROCEDURE Update_Attr_Value(
156: p_api_version_number IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160:
161: ,x_return_status OUT NOCOPY VARCHAR2
154:
155: PROCEDURE Update_Attr_Value(
156: p_api_version_number IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160:
161: ,x_return_status OUT NOCOPY VARCHAR2
162: ,x_msg_count OUT NOCOPY NUMBER
155: PROCEDURE Update_Attr_Value(
156: p_api_version_number IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160:
161: ,x_return_status OUT NOCOPY VARCHAR2
162: ,x_msg_count OUT NOCOPY NUMBER
163: ,x_msg_data OUT NOCOPY VARCHAR2
178: -- Parameters
179: --
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_ENTY_ATTR_VAL_ID IN NUMBER
186: -- p_object_version_number IN NUMBER Optional Default = NULL
179: --
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_ENTY_ATTR_VAL_ID IN NUMBER
186: -- p_object_version_number IN NUMBER Optional Default = NULL
187: --
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_ENTY_ATTR_VAL_ID IN NUMBER
186: -- p_object_version_number IN NUMBER Optional Default = NULL
187: --
188: -- OUT
198: --
199:
200: PROCEDURE Delete_Attr_Value(
201: p_api_version_number IN NUMBER
202: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
203: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
204: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
205:
206: ,x_return_status OUT NOCOPY VARCHAR2
199:
200: PROCEDURE Delete_Attr_Value(
201: p_api_version_number IN NUMBER
202: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
203: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
204: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
205:
206: ,x_return_status OUT NOCOPY VARCHAR2
207: ,x_msg_count OUT NOCOPY NUMBER
200: PROCEDURE Delete_Attr_Value(
201: p_api_version_number IN NUMBER
202: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
203: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
204: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
205:
206: ,x_return_status OUT NOCOPY VARCHAR2
207: ,x_msg_count OUT NOCOPY NUMBER
208: ,x_msg_data OUT NOCOPY VARCHAR2
223: -- Parameters
224: --
225: -- IN
226: -- p_api_version_number IN NUMBER Required
227: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
228: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
229: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
230: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
231: --
224: --
225: -- IN
226: -- p_api_version_number IN NUMBER Required
227: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
228: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
229: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
230: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
231: --
232: -- OUT
225: -- IN
226: -- p_api_version_number IN NUMBER Required
227: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
228: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
229: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
230: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
231: --
232: -- OUT
233: -- x_return_status OUT VARCHAR2
242: --
243:
244: PROCEDURE Lock_Attr_Value(
245: p_api_version_number IN NUMBER
246: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
247:
248: ,x_return_status OUT NOCOPY VARCHAR2
249: ,x_msg_count OUT NOCOPY NUMBER
250: ,x_msg_data OUT NOCOPY VARCHAR2
268: -- ===============================================================================
269:
270: PROCEDURE Validate_attr_value(
271: p_api_version_number IN NUMBER
272: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
273: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
274: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
275: ,p_enty_attr_val_rec IN enty_attr_val_rec_type
276:
269:
270: PROCEDURE Validate_attr_value(
271: p_api_version_number IN NUMBER
272: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
273: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
274: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
275: ,p_enty_attr_val_rec IN enty_attr_val_rec_type
276:
277: ,x_return_status OUT NOCOPY VARCHAR2
315: -- ===============================================================================
316:
317: PROCEDURE Validate_attr_val_rec(
318: p_api_version_number IN NUMBER
319: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
320:
321: ,x_return_status OUT NOCOPY VARCHAR2
322: ,x_msg_count OUT NOCOPY NUMBER
323: ,x_msg_data OUT NOCOPY VARCHAR2