APPS.PA_CONTROL_ITEMS_PVT dependencies on PA_LOOKUPS

Line 254: --Validate all PA_LOOKUPS values

250: l_debug_level6);
251: END IF;
252:
253:
254: --Validate all PA_LOOKUPS values
255:
256: IF (x_return_status <> 'E') THEN
257: PA_CONTROL_ITEMS_PKG.INSERT_ROW (
258: p_ci_type_id

Line 2077: -- Validates pa_lookups which has p_lookup_type and p_lookup_code

2073: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2074: RAISE;
2075: END ci_number_exists;
2076:
2077: -- Validates pa_lookups which has p_lookup_type and p_lookup_code
2078: --
2079: FUNCTION is_lookup_valid (p_lookup_type IN VARCHAR2
2080: ,p_lookup_code IN VARCHAR2)
2081: RETURN BOOLEAN

Line 2088: FROM pa_lookups

2084: BEGIN
2085:
2086: SELECT meaning
2087: INTO l_meaning
2088: FROM pa_lookups
2089: WHERE lookup_type = p_lookup_type
2090: AND lookup_code = p_lookup_code;
2091:
2092: return TRUE;