DBA Data[Home] [Help]

APPS.QP_VALIDATE_LIMIT_ATTRS dependencies on QP_VALIDATE

Line 1: PACKAGE BODY QP_Validate_Limit_Attrs AS

1: PACKAGE BODY QP_Validate_Limit_Attrs AS
2: /* $Header: QPXLLATB.pls 120.3 2006/09/07 10:06:08 rbagri noship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: QPXLLATB.pls 120.3 2006/09/07 10:06:08 rbagri noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Limit_Attrs';
7:
8:
9: PROCEDURE Validate_List_Header_Limits
10: (x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 946: IF NOT QP_Validate.Comparison_Operator(p_LIMIT_ATTRS_rec.comparison_operator_code) THEN

942: ( p_LIMIT_ATTRS_rec.comparison_operator_code <>
943: p_old_LIMIT_ATTRS_rec.comparison_operator_code OR
944: p_old_LIMIT_ATTRS_rec.comparison_operator_code IS NULL )
945: THEN
946: IF NOT QP_Validate.Comparison_Operator(p_LIMIT_ATTRS_rec.comparison_operator_code) THEN
947: x_return_status := FND_API.G_RET_STS_ERROR;
948: END IF;
949: END IF;
950:

Line 956: IF NOT QP_Validate.Created_By(p_LIMIT_ATTRS_rec.created_by) THEN

952: ( p_LIMIT_ATTRS_rec.created_by <>
953: p_old_LIMIT_ATTRS_rec.created_by OR
954: p_old_LIMIT_ATTRS_rec.created_by IS NULL )
955: THEN
956: IF NOT QP_Validate.Created_By(p_LIMIT_ATTRS_rec.created_by) THEN
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: END IF;
959: END IF;
960:

Line 966: IF NOT QP_Validate.Creation_Date(p_LIMIT_ATTRS_rec.creation_date) THEN

962: ( p_LIMIT_ATTRS_rec.creation_date <>
963: p_old_LIMIT_ATTRS_rec.creation_date OR
964: p_old_LIMIT_ATTRS_rec.creation_date IS NULL )
965: THEN
966: IF NOT QP_Validate.Creation_Date(p_LIMIT_ATTRS_rec.creation_date) THEN
967: x_return_status := FND_API.G_RET_STS_ERROR;
968: END IF;
969: END IF;
970:

Line 976: IF NOT QP_Validate.Last_Updated_By(p_LIMIT_ATTRS_rec.last_updated_by) THEN

972: ( p_LIMIT_ATTRS_rec.last_updated_by <>
973: p_old_LIMIT_ATTRS_rec.last_updated_by OR
974: p_old_LIMIT_ATTRS_rec.last_updated_by IS NULL )
975: THEN
976: IF NOT QP_Validate.Last_Updated_By(p_LIMIT_ATTRS_rec.last_updated_by) THEN
977: x_return_status := FND_API.G_RET_STS_ERROR;
978: END IF;
979: END IF;
980:

Line 986: IF NOT QP_Validate.Last_Update_Date(p_LIMIT_ATTRS_rec.last_update_date) THEN

982: ( p_LIMIT_ATTRS_rec.last_update_date <>
983: p_old_LIMIT_ATTRS_rec.last_update_date OR
984: p_old_LIMIT_ATTRS_rec.last_update_date IS NULL )
985: THEN
986: IF NOT QP_Validate.Last_Update_Date(p_LIMIT_ATTRS_rec.last_update_date) THEN
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: END IF;
989: END IF;
990:

Line 996: IF NOT QP_Validate.Last_Update_Login(p_LIMIT_ATTRS_rec.last_update_login) THEN

992: ( p_LIMIT_ATTRS_rec.last_update_login <>
993: p_old_LIMIT_ATTRS_rec.last_update_login OR
994: p_old_LIMIT_ATTRS_rec.last_update_login IS NULL )
995: THEN
996: IF NOT QP_Validate.Last_Update_Login(p_LIMIT_ATTRS_rec.last_update_login) THEN
997: x_return_status := FND_API.G_RET_STS_ERROR;
998: END IF;
999: END IF;
1000:

Line 1006: IF NOT QP_Validate.Limit_Attribute(p_LIMIT_ATTRS_rec.limit_attribute) THEN

1002: ( p_LIMIT_ATTRS_rec.limit_attribute <>
1003: p_old_LIMIT_ATTRS_rec.limit_attribute OR
1004: p_old_LIMIT_ATTRS_rec.limit_attribute IS NULL )
1005: THEN
1006: IF NOT QP_Validate.Limit_Attribute(p_LIMIT_ATTRS_rec.limit_attribute) THEN
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: END IF;
1009: END IF;
1010:

Line 1016: IF NOT QP_Validate.Limit_Attribute_Context(p_LIMIT_ATTRS_rec.limit_attribute_context) THEN

1012: ( p_LIMIT_ATTRS_rec.limit_attribute_context <>
1013: p_old_LIMIT_ATTRS_rec.limit_attribute_context OR
1014: p_old_LIMIT_ATTRS_rec.limit_attribute_context IS NULL )
1015: THEN
1016: IF NOT QP_Validate.Limit_Attribute_Context(p_LIMIT_ATTRS_rec.limit_attribute_context) THEN
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: END IF;
1019: END IF;
1020:

Line 1026: IF NOT QP_Validate.Limit_Attribute(p_LIMIT_ATTRS_rec.limit_attribute_id) THEN

1022: ( p_LIMIT_ATTRS_rec.limit_attribute_id <>
1023: p_old_LIMIT_ATTRS_rec.limit_attribute_id OR
1024: p_old_LIMIT_ATTRS_rec.limit_attribute_id IS NULL )
1025: THEN
1026: IF NOT QP_Validate.Limit_Attribute(p_LIMIT_ATTRS_rec.limit_attribute_id) THEN
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: END IF;
1029: END IF;
1030:

Line 1036: IF NOT QP_Validate.Limit_Attribute_Type(p_LIMIT_ATTRS_rec.limit_attribute_type) THEN

1032: ( p_LIMIT_ATTRS_rec.limit_attribute_type <>
1033: p_old_LIMIT_ATTRS_rec.limit_attribute_type OR
1034: p_old_LIMIT_ATTRS_rec.limit_attribute_type IS NULL )
1035: THEN
1036: IF NOT QP_Validate.Limit_Attribute_Type(p_LIMIT_ATTRS_rec.limit_attribute_type) THEN
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: END IF;
1039: END IF;
1040:

Line 1046: IF NOT QP_Validate.Limit_Attr_Datatype(p_LIMIT_ATTRS_rec.limit_attr_datatype) THEN

1042: ( p_LIMIT_ATTRS_rec.limit_attr_datatype <>
1043: p_old_LIMIT_ATTRS_rec.limit_attr_datatype OR
1044: p_old_LIMIT_ATTRS_rec.limit_attr_datatype IS NULL )
1045: THEN
1046: IF NOT QP_Validate.Limit_Attr_Datatype(p_LIMIT_ATTRS_rec.limit_attr_datatype) THEN
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: END IF;
1049: END IF;
1050:

Line 1056: IF NOT QP_Validate.Limit_Attr_Value(p_LIMIT_ATTRS_rec.limit_attr_value) THEN

1052: ( p_LIMIT_ATTRS_rec.limit_attr_value <>
1053: p_old_LIMIT_ATTRS_rec.limit_attr_value OR
1054: p_old_LIMIT_ATTRS_rec.limit_attr_value IS NULL )
1055: THEN
1056: IF NOT QP_Validate.Limit_Attr_Value(p_LIMIT_ATTRS_rec.limit_attr_value) THEN
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: END IF;
1059: END IF;
1060:

Line 1066: IF NOT QP_Validate.Limit(p_LIMIT_ATTRS_rec.limit_id) THEN

1062: ( p_LIMIT_ATTRS_rec.limit_id <>
1063: p_old_LIMIT_ATTRS_rec.limit_id OR
1064: p_old_LIMIT_ATTRS_rec.limit_id IS NULL )
1065: THEN
1066: IF NOT QP_Validate.Limit(p_LIMIT_ATTRS_rec.limit_id) THEN
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: END IF;
1069: END IF;
1070:

Line 1076: IF NOT QP_Validate.Program_Application(p_LIMIT_ATTRS_rec.program_application_id) THEN

1072: ( p_LIMIT_ATTRS_rec.program_application_id <>
1073: p_old_LIMIT_ATTRS_rec.program_application_id OR
1074: p_old_LIMIT_ATTRS_rec.program_application_id IS NULL )
1075: THEN
1076: IF NOT QP_Validate.Program_Application(p_LIMIT_ATTRS_rec.program_application_id) THEN
1077: x_return_status := FND_API.G_RET_STS_ERROR;
1078: END IF;
1079: END IF;
1080:

Line 1086: IF NOT QP_Validate.Program(p_LIMIT_ATTRS_rec.program_id) THEN

1082: ( p_LIMIT_ATTRS_rec.program_id <>
1083: p_old_LIMIT_ATTRS_rec.program_id OR
1084: p_old_LIMIT_ATTRS_rec.program_id IS NULL )
1085: THEN
1086: IF NOT QP_Validate.Program(p_LIMIT_ATTRS_rec.program_id) THEN
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: END IF;
1089: END IF;
1090:

Line 1096: IF NOT QP_Validate.Program_Update_Date(p_LIMIT_ATTRS_rec.program_update_date) THEN

1092: ( p_LIMIT_ATTRS_rec.program_update_date <>
1093: p_old_LIMIT_ATTRS_rec.program_update_date OR
1094: p_old_LIMIT_ATTRS_rec.program_update_date IS NULL )
1095: THEN
1096: IF NOT QP_Validate.Program_Update_Date(p_LIMIT_ATTRS_rec.program_update_date) THEN
1097: x_return_status := FND_API.G_RET_STS_ERROR;
1098: END IF;
1099: END IF;
1100:

Line 1106: IF NOT QP_Validate.Request(p_LIMIT_ATTRS_rec.request_id) THEN

1102: ( p_LIMIT_ATTRS_rec.request_id <>
1103: p_old_LIMIT_ATTRS_rec.request_id OR
1104: p_old_LIMIT_ATTRS_rec.request_id IS NULL )
1105: THEN
1106: IF NOT QP_Validate.Request(p_LIMIT_ATTRS_rec.request_id) THEN
1107: x_return_status := FND_API.G_RET_STS_ERROR;
1108: END IF;
1109: END IF;
1110:

Line 1248: /*IF NOT QP_Validate.Desc_Flex( 'LIMIT_ATTRS' ) THEN

1244: */
1245:
1246: -- Validate descriptive flexfield.
1247:
1248: /*IF NOT QP_Validate.Desc_Flex( 'LIMIT_ATTRS' ) THEN
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: END IF; */
1251: NULL;
1252:

Line 1508: END QP_Validate_Limit_Attrs;

1504: END IF;
1505:
1506: END Entity_Update;
1507:
1508: END QP_Validate_Limit_Attrs;