APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on AR_LOOKUPS

Line 319: l_lookup_type AR_LOOKUPS.lookup_type%TYPE;

315: l_position1 NUMBER;
316: l_position2 NUMBER;
317:
318: l_lookup_table VARCHAR2(30);
319: l_lookup_type AR_LOOKUPS.lookup_type%TYPE;
320: l_lookup_code AR_LOOKUPS.lookup_code%TYPE;
321: l_territory_code VARCHAR2(2);
322:
323: BEGIN

Line 320: l_lookup_code AR_LOOKUPS.lookup_code%TYPE;

316: l_position2 NUMBER;
317:
318: l_lookup_table VARCHAR2(30);
319: l_lookup_type AR_LOOKUPS.lookup_type%TYPE;
320: l_lookup_code AR_LOOKUPS.lookup_code%TYPE;
321: l_territory_code VARCHAR2(2);
322:
323: BEGIN
324:

Line 342: IF UPPER(l_lookup_table) = 'AR_LOOKUPS' THEN

338: l_lookup_type := SUBSTRB(p_val, l_position1 + G_LENGTH,
339: l_position2 - l_position1 - G_LENGTH);
340: l_lookup_code := SUBSTRB(p_val, l_position2 + G_LENGTH);
341:
342: IF UPPER(l_lookup_table) = 'AR_LOOKUPS' THEN
343: BEGIN
344: SELECT 'Y' INTO l_dummy
345: FROM AR_LOOKUPS
346: WHERE LOOKUP_TYPE = l_lookup_type

Line 345: FROM AR_LOOKUPS

341:
342: IF UPPER(l_lookup_table) = 'AR_LOOKUPS' THEN
343: BEGIN
344: SELECT 'Y' INTO l_dummy
345: FROM AR_LOOKUPS
346: WHERE LOOKUP_TYPE = l_lookup_type
347: AND LOOKUP_CODE = l_lookup_code
348: AND (ENABLED_FLAG = 'Y' AND
349: TRUNC(SYSDATE) BETWEEN

Line 988: p_lookup_table IN VARCHAR2 DEFAULT 'AR_LOOKUPS',

984: END validate_cannot_update_to_null;
985:
986: PROCEDURE validate_lookup (
987: p_column IN VARCHAR2,
988: p_lookup_table IN VARCHAR2 DEFAULT 'AR_LOOKUPS',
989: p_lookup_type IN VARCHAR2,
990: p_column_value IN VARCHAR2,
991: x_return_status IN OUT NOCOPY VARCHAR2
992: ) IS