DBA Data[Home] [Help]

APPS.PV_ENTY_ATTR_VALIDATIONS_PVT dependencies on FND_API

Line 56: validation_id NUMBER := FND_API.G_MISS_NUM

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

Line 57: ,last_update_date DATE := FND_API.G_MISS_DATE

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

Line 58: ,last_updated_by 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

Line 59: ,creation_date DATE := FND_API.G_MISS_DATE

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

Line 60: ,created_by NUMBER := FND_API.G_MISS_NUM

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

Line 61: ,last_update_login 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

Line 62: ,object_version_number 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

Line 63: ,validation_date DATE := FND_API.G_MISS_DATE

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:

Line 64: ,validated_by_resource_id NUMBER := FND_API.G_MISS_NUM

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: );

Line 65: ,validation_document_id 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: );
69:

Line 66: ,validation_note VARCHAR2(4000) := FND_API.G_MISS_CHAR

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;

Line 85: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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: --

Line 86: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 104: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 105: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

Line 106: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

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

Line 129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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: --

Line 130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 148: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 149: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

Line 150: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

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

Line 173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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: --

Line 175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 193: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 194: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

Line 195: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

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

Line 218: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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: --

Line 219: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 220: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 237: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 263: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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:

Line 264: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

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

Line 310: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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