APPS.ASO_LINE_ATTRIBS_PVT dependencies on ASO_LOOKUPS

Line 1095: from aso_lookups

1091: -- verify if data is valid
1092: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1093: NULL;
1094: select count(*) into l_count
1095: from aso_lookups
1096: where lookup_type = 'ASO_LINE_ATTRIBUTE_TYPE'
1097: and lookup_code = p_ATTRIBUTE_TYPE_CODE;
1098:
1099: IF l_count < 1 then

Line 1114: from aso_lookups

1110: NULL;
1111:
1112: IF p_ATTRIBUTE_TYPE_CODE <> FND_API.G_MISS_CHAR THEN
1113: select count(*) into l_count
1114: from aso_lookups
1115: where lookup_type = 'ASO_LINE_ATTRIBUTE_TYPE'
1116: and lookup_code = p_ATTRIBUTE_TYPE_CODE;
1117:
1118: IF l_count < 1 then

Line 1163: from aso_lookups

1159: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1160: NULL;
1161:
1162: select count(*) into l_count
1163: from aso_lookups
1164: where lookup_type = 'ASO_LINE_ATTRIBUTE_STATUS'
1165: and lookup_code = p_status;
1166:
1167: if l_count < 1 then

Line 1180: from aso_lookups

1176: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1177: NULL;
1178: IF p_STATUS <> FND_API.G_MISS_CHAR THEN
1179: select count(*) into l_count
1180: from aso_lookups
1181: where lookup_type = 'ATTRIBUTE_STATUS'
1182: and lookup_code = p_status;
1183:
1184: if l_count < 1 then