52: TYPE enty_attr_validation_rec_type IS RECORD
53: (
54:
55:
56: validation_id NUMBER := FND_API.G_MISS_NUM
57: ,last_update_date DATE := FND_API.G_MISS_DATE
58: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
59: ,creation_date DATE := FND_API.G_MISS_DATE
60: ,created_by NUMBER := FND_API.G_MISS_NUM
53: (
54:
55:
56: validation_id NUMBER := FND_API.G_MISS_NUM
57: ,last_update_date DATE := FND_API.G_MISS_DATE
58: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
59: ,creation_date DATE := FND_API.G_MISS_DATE
60: ,created_by NUMBER := FND_API.G_MISS_NUM
61: ,last_update_login NUMBER := FND_API.G_MISS_NUM
54:
55:
56: validation_id NUMBER := FND_API.G_MISS_NUM
57: ,last_update_date DATE := FND_API.G_MISS_DATE
58: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
59: ,creation_date DATE := FND_API.G_MISS_DATE
60: ,created_by NUMBER := FND_API.G_MISS_NUM
61: ,last_update_login NUMBER := FND_API.G_MISS_NUM
62: ,object_version_number NUMBER := FND_API.G_MISS_NUM
55:
56: validation_id NUMBER := FND_API.G_MISS_NUM
57: ,last_update_date DATE := FND_API.G_MISS_DATE
58: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
59: ,creation_date DATE := FND_API.G_MISS_DATE
60: ,created_by NUMBER := FND_API.G_MISS_NUM
61: ,last_update_login NUMBER := FND_API.G_MISS_NUM
62: ,object_version_number NUMBER := FND_API.G_MISS_NUM
63: ,validation_date DATE := FND_API.G_MISS_DATE
56: validation_id NUMBER := FND_API.G_MISS_NUM
57: ,last_update_date DATE := FND_API.G_MISS_DATE
58: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
59: ,creation_date DATE := FND_API.G_MISS_DATE
60: ,created_by NUMBER := FND_API.G_MISS_NUM
61: ,last_update_login NUMBER := FND_API.G_MISS_NUM
62: ,object_version_number NUMBER := FND_API.G_MISS_NUM
63: ,validation_date DATE := FND_API.G_MISS_DATE
64: ,validated_by_resource_id NUMBER := FND_API.G_MISS_NUM
57: ,last_update_date DATE := FND_API.G_MISS_DATE
58: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
59: ,creation_date DATE := FND_API.G_MISS_DATE
60: ,created_by NUMBER := FND_API.G_MISS_NUM
61: ,last_update_login NUMBER := FND_API.G_MISS_NUM
62: ,object_version_number NUMBER := FND_API.G_MISS_NUM
63: ,validation_date DATE := FND_API.G_MISS_DATE
64: ,validated_by_resource_id NUMBER := FND_API.G_MISS_NUM
65: ,validation_document_id NUMBER := FND_API.G_MISS_NUM
58: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
59: ,creation_date DATE := FND_API.G_MISS_DATE
60: ,created_by NUMBER := FND_API.G_MISS_NUM
61: ,last_update_login NUMBER := FND_API.G_MISS_NUM
62: ,object_version_number NUMBER := FND_API.G_MISS_NUM
63: ,validation_date DATE := FND_API.G_MISS_DATE
64: ,validated_by_resource_id NUMBER := FND_API.G_MISS_NUM
65: ,validation_document_id NUMBER := FND_API.G_MISS_NUM
66: ,validation_note VARCHAR2(4000) := FND_API.G_MISS_CHAR
59: ,creation_date DATE := FND_API.G_MISS_DATE
60: ,created_by NUMBER := FND_API.G_MISS_NUM
61: ,last_update_login NUMBER := FND_API.G_MISS_NUM
62: ,object_version_number NUMBER := FND_API.G_MISS_NUM
63: ,validation_date DATE := FND_API.G_MISS_DATE
64: ,validated_by_resource_id NUMBER := FND_API.G_MISS_NUM
65: ,validation_document_id NUMBER := FND_API.G_MISS_NUM
66: ,validation_note VARCHAR2(4000) := FND_API.G_MISS_CHAR
67:
60: ,created_by NUMBER := FND_API.G_MISS_NUM
61: ,last_update_login NUMBER := FND_API.G_MISS_NUM
62: ,object_version_number NUMBER := FND_API.G_MISS_NUM
63: ,validation_date DATE := FND_API.G_MISS_DATE
64: ,validated_by_resource_id NUMBER := FND_API.G_MISS_NUM
65: ,validation_document_id NUMBER := FND_API.G_MISS_NUM
66: ,validation_note VARCHAR2(4000) := FND_API.G_MISS_CHAR
67:
68: );
61: ,last_update_login NUMBER := FND_API.G_MISS_NUM
62: ,object_version_number NUMBER := FND_API.G_MISS_NUM
63: ,validation_date DATE := FND_API.G_MISS_DATE
64: ,validated_by_resource_id NUMBER := FND_API.G_MISS_NUM
65: ,validation_document_id NUMBER := FND_API.G_MISS_NUM
66: ,validation_note VARCHAR2(4000) := FND_API.G_MISS_CHAR
67:
68: );
69:
62: ,object_version_number NUMBER := FND_API.G_MISS_NUM
63: ,validation_date DATE := FND_API.G_MISS_DATE
64: ,validated_by_resource_id NUMBER := FND_API.G_MISS_NUM
65: ,validation_document_id NUMBER := FND_API.G_MISS_NUM
66: ,validation_note VARCHAR2(4000) := FND_API.G_MISS_CHAR
67:
68: );
69:
70: g_miss_enty_attr_vldtn_rec enty_attr_validation_rec_type;
81: -- Parameters
82: --
83: -- IN
84: -- p_api_version_number IN NUMBER Required
85: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_enty_attr_validation_rec IN enty_attr_validation_rec_type Required
89: --
82: --
83: -- IN
84: -- p_api_version_number IN NUMBER Required
85: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_enty_attr_validation_rec IN enty_attr_validation_rec_type Required
89: --
90: -- OUT
83: -- IN
84: -- p_api_version_number IN NUMBER Required
85: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_enty_attr_validation_rec IN enty_attr_validation_rec_type Required
89: --
90: -- OUT
91: -- x_return_status OUT VARCHAR2
100: --
101:
102: PROCEDURE Create_Enty_Attr_Validation(
103: p_api_version_number IN NUMBER
104: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
105: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
106: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
107:
108: ,x_return_status OUT NOCOPY VARCHAR2
101:
102: PROCEDURE Create_Enty_Attr_Validation(
103: p_api_version_number IN NUMBER
104: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
105: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
106: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
107:
108: ,x_return_status OUT NOCOPY VARCHAR2
109: ,x_msg_count OUT NOCOPY NUMBER
102: PROCEDURE Create_Enty_Attr_Validation(
103: p_api_version_number IN NUMBER
104: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
105: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
106: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
107:
108: ,x_return_status OUT NOCOPY VARCHAR2
109: ,x_msg_count OUT NOCOPY NUMBER
110: ,x_msg_data OUT NOCOPY VARCHAR2
125: -- Parameters
126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
133: --
126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
133: --
134: -- OUT
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
133: --
134: -- OUT
135: -- x_return_status OUT VARCHAR2
144: --
145:
146: PROCEDURE Update_Enty_Attr_Validation(
147: p_api_version_number IN NUMBER
148: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
149: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
150: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
151:
152: ,x_return_status OUT NOCOPY VARCHAR2
145:
146: PROCEDURE Update_Enty_Attr_Validation(
147: p_api_version_number IN NUMBER
148: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
149: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
150: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
151:
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_count OUT NOCOPY NUMBER
146: PROCEDURE Update_Enty_Attr_Validation(
147: p_api_version_number IN NUMBER
148: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
149: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
150: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
151:
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_count OUT NOCOPY NUMBER
154: ,x_msg_data OUT NOCOPY VARCHAR2
169: -- Parameters
170: --
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_ENTY_ATTR_VAL_ID IN NUMBER
177: -- p_object_version_number IN NUMBER Optional Default = NULL
170: --
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_ENTY_ATTR_VAL_ID IN NUMBER
177: -- p_object_version_number IN NUMBER Optional Default = NULL
178: --
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_ENTY_ATTR_VAL_ID IN NUMBER
177: -- p_object_version_number IN NUMBER Optional Default = NULL
178: --
179: -- OUT
189: --
190:
191: PROCEDURE Delete_Enty_Attr_Validation(
192: p_api_version_number IN NUMBER
193: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
194: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
195: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
196:
197: ,x_return_status OUT NOCOPY VARCHAR2
190:
191: PROCEDURE Delete_Enty_Attr_Validation(
192: p_api_version_number IN NUMBER
193: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
194: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
195: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
196:
197: ,x_return_status OUT NOCOPY VARCHAR2
198: ,x_msg_count OUT NOCOPY NUMBER
191: PROCEDURE Delete_Enty_Attr_Validation(
192: p_api_version_number IN NUMBER
193: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
194: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
195: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
196:
197: ,x_return_status OUT NOCOPY VARCHAR2
198: ,x_msg_count OUT NOCOPY NUMBER
199: ,x_msg_data OUT NOCOPY VARCHAR2
214: -- Parameters
215: --
216: -- IN
217: -- p_api_version_number IN NUMBER Required
218: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
221: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
222: --
215: --
216: -- IN
217: -- p_api_version_number IN NUMBER Required
218: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
221: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
222: --
223: -- OUT
216: -- IN
217: -- p_api_version_number IN NUMBER Required
218: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
221: -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
222: --
223: -- OUT
224: -- x_return_status OUT VARCHAR2
233: --
234:
235: PROCEDURE Lock_Enty_Attr_Validation(
236: p_api_version_number IN NUMBER
237: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
238:
239: ,x_return_status OUT NOCOPY VARCHAR2
240: ,x_msg_count OUT NOCOPY NUMBER
241: ,x_msg_data OUT NOCOPY VARCHAR2
259: -- ===============================================================================
260:
261: PROCEDURE Validate_Enty_Attr_Validation(
262: p_api_version_number IN NUMBER
263: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
264: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
265: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
266: ,p_enty_attr_validation_rec IN enty_attr_validation_rec_type
267:
260:
261: PROCEDURE Validate_Enty_Attr_Validation(
262: p_api_version_number IN NUMBER
263: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
264: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
265: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
266: ,p_enty_attr_validation_rec IN enty_attr_validation_rec_type
267:
268: ,x_return_status OUT NOCOPY VARCHAR2
306: -- ===============================================================================
307:
308: PROCEDURE Validate_enty_attr_vldtn_rec(
309: p_api_version_number IN NUMBER
310: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
311:
312: ,x_return_status OUT NOCOPY VARCHAR2
313: ,x_msg_count OUT NOCOPY NUMBER
314: ,x_msg_data OUT NOCOPY VARCHAR2