DBA Data[Home] [Help]

APPS.QP_VALIDATE_QUALIFIER_RULES dependencies on QP_VALIDATE

Line 1: PACKAGE BODY QP_Validate_Qualifier_Rules AS

1: PACKAGE BODY QP_Validate_Qualifier_Rules AS
2: /* $Header: QPXLQPRB.pls 120.1 2005/06/09 00:21:19 appldev $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Qualifier_Rules';

2: /* $Header: QPXLQPRB.pls 120.1 2005/06/09 00:21:19 appldev $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Qualifier_Rules';
7:
8:
9: FUNCTION Check_Duplicate_Name(p_name IN VARCHAR2,
10: p_qualifier_rule_id IN NUMBER)RETURN BOOLEAN IS

Line 194: IF NOT QP_Validate.Created_By(p_QUALIFIER_RULES_rec.created_by) THEN

190: ( p_QUALIFIER_RULES_rec.created_by <>
191: p_old_QUALIFIER_RULES_rec.created_by OR
192: p_old_QUALIFIER_RULES_rec.created_by IS NULL )
193: THEN
194: IF NOT QP_Validate.Created_By(p_QUALIFIER_RULES_rec.created_by) THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: END IF;
197: END IF;
198:

Line 210: IF NOT QP_Validate.Creation_Date(p_QUALIFIER_RULES_rec.creation_date) THEN

206: ( p_QUALIFIER_RULES_rec.creation_date <>
207: p_old_QUALIFIER_RULES_rec.creation_date OR
208: p_old_QUALIFIER_RULES_rec.creation_date IS NULL )
209: THEN
210: IF NOT QP_Validate.Creation_Date(p_QUALIFIER_RULES_rec.creation_date) THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: END IF;
213: END IF;
214:

Line 226: IF NOT QP_Validate.Description(p_QUALIFIER_RULES_rec.description) THEN

222: ( p_QUALIFIER_RULES_rec.description <>
223: p_old_QUALIFIER_RULES_rec.description OR
224: p_old_QUALIFIER_RULES_rec.description IS NULL )
225: THEN
226: IF NOT QP_Validate.Description(p_QUALIFIER_RULES_rec.description) THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: END IF;
229: END IF;
230:

Line 244: IF NOT QP_Validate.Last_Updated_By(p_QUALIFIER_RULES_rec.last_updated_by) THEN

240: ( p_QUALIFIER_RULES_rec.last_updated_by <>
241: p_old_QUALIFIER_RULES_rec.last_updated_by OR
242: p_old_QUALIFIER_RULES_rec.last_updated_by IS NULL )
243: THEN
244: IF NOT QP_Validate.Last_Updated_By(p_QUALIFIER_RULES_rec.last_updated_by) THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: END IF;
247: END IF;
248:

Line 263: IF NOT QP_Validate.Last_Update_Date(p_QUALIFIER_RULES_rec.last_update_date) THEN

259: ( p_QUALIFIER_RULES_rec.last_update_date <>
260: p_old_QUALIFIER_RULES_rec.last_update_date OR
261: p_old_QUALIFIER_RULES_rec.last_update_date IS NULL )
262: THEN
263: IF NOT QP_Validate.Last_Update_Date(p_QUALIFIER_RULES_rec.last_update_date) THEN
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: END IF;
266: END IF;
267:

Line 278: IF NOT QP_Validate.Last_Update_Login(p_QUALIFIER_RULES_rec.last_update_login) THEN

274: ( p_QUALIFIER_RULES_rec.last_update_login <>
275: p_old_QUALIFIER_RULES_rec.last_update_login OR
276: p_old_QUALIFIER_RULES_rec.last_update_login IS NULL )
277: THEN
278: IF NOT QP_Validate.Last_Update_Login(p_QUALIFIER_RULES_rec.last_update_login) THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: END IF;
281: END IF;
282:

Line 293: IF NOT QP_Validate.Name(p_QUALIFIER_RULES_rec.name) THEN

289: ( p_QUALIFIER_RULES_rec.name <>
290: p_old_QUALIFIER_RULES_rec.name OR
291: p_old_QUALIFIER_RULES_rec.name IS NULL )
292: THEN
293: IF NOT QP_Validate.Name(p_QUALIFIER_RULES_rec.name) THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: END IF;
296: END IF;
297:

Line 309: IF NOT QP_Validate.Program_Application(p_QUALIFIER_RULES_rec.program_application_id) THEN

305: ( p_QUALIFIER_RULES_rec.program_application_id <>
306: p_old_QUALIFIER_RULES_rec.program_application_id OR
307: p_old_QUALIFIER_RULES_rec.program_application_id IS NULL )
308: THEN
309: IF NOT QP_Validate.Program_Application(p_QUALIFIER_RULES_rec.program_application_id) THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: END IF;
312: END IF;
313:

Line 326: IF NOT QP_Validate.Program(p_QUALIFIER_RULES_rec.program_id) THEN

322: ( p_QUALIFIER_RULES_rec.program_id <>
323: p_old_QUALIFIER_RULES_rec.program_id OR
324: p_old_QUALIFIER_RULES_rec.program_id IS NULL )
325: THEN
326: IF NOT QP_Validate.Program(p_QUALIFIER_RULES_rec.program_id) THEN
327: x_return_status := FND_API.G_RET_STS_ERROR;
328: END IF;
329: END IF;
330:

Line 342: IF NOT QP_Validate.Program_Update_Date(p_QUALIFIER_RULES_rec.program_update_date) THEN

338: ( p_QUALIFIER_RULES_rec.program_update_date <>
339: p_old_QUALIFIER_RULES_rec.program_update_date OR
340: p_old_QUALIFIER_RULES_rec.program_update_date IS NULL )
341: THEN
342: IF NOT QP_Validate.Program_Update_Date(p_QUALIFIER_RULES_rec.program_update_date) THEN
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: END IF;
345: END IF;
346:

Line 358: IF NOT QP_Validate.Qualifier_Rule(p_QUALIFIER_RULES_rec.qualifier_rule_id) THEN

354: ( p_QUALIFIER_RULES_rec.qualifier_rule_id <>
355: p_old_QUALIFIER_RULES_rec.qualifier_rule_id OR
356: p_old_QUALIFIER_RULES_rec.qualifier_rule_id IS NULL )
357: THEN
358: IF NOT QP_Validate.Qualifier_Rule(p_QUALIFIER_RULES_rec.qualifier_rule_id) THEN
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: END IF;
361: END IF;
362:

Line 374: IF NOT QP_Validate.Request(p_QUALIFIER_RULES_rec.request_id) THEN

370: ( p_QUALIFIER_RULES_rec.request_id <>
371: p_old_QUALIFIER_RULES_rec.request_id OR
372: p_old_QUALIFIER_RULES_rec.request_id IS NULL )
373: THEN
374: IF NOT QP_Validate.Request(p_QUALIFIER_RULES_rec.request_id) THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: END IF;
377: END IF;
378:

Line 525: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIER_RULES' ) THEN

521: --dbms_output.put_line('validating flex fields');
522:
523:
524:
525: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIER_RULES' ) THEN
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: END IF;
528:
529:

Line 603: END QP_Validate_Qualifier_Rules;

599: END IF;
600:
601: END Entity_Delete;
602:
603: END QP_Validate_Qualifier_Rules;