APPS.HZ_UTILITY_V2PUB dependencies on FND_LOOKUP_VALUES

Line 364: ELSIF UPPER( l_lookup_table ) = 'FND_LOOKUP_VALUES' THEN

360: EXCEPTION
361: WHEN NO_DATA_FOUND THEN
362: l_return := FALSE;
363: END;
364: ELSIF UPPER( l_lookup_table ) = 'FND_LOOKUP_VALUES' THEN
365: BEGIN
366: SELECT meaning INTO x_lookup_meaning
367: FROM FND_LOOKUP_VALUES
368: WHERE LOOKUP_TYPE = l_lookup_type

Line 367: FROM FND_LOOKUP_VALUES

363: END;
364: ELSIF UPPER( l_lookup_table ) = 'FND_LOOKUP_VALUES' THEN
365: BEGIN
366: SELECT meaning INTO x_lookup_meaning
367: FROM FND_LOOKUP_VALUES
368: WHERE LOOKUP_TYPE = l_lookup_type
369: AND LOOKUP_CODE = l_lookup_code
370: AND ( ENABLED_FLAG = 'Y' AND
371: TRUNC( SYSDATE ) BETWEEN

Line 1018: * FND_LOOKUP_VALUES

1014: * For now, we are supporting
1015: * AR_LOOKUPS
1016: * SO_LOOKUPS
1017: * OE_SHIP_METHODS_V
1018: * FND_LOOKUP_VALUES
1019: * Default value is AR_LOOKUPS
1020: * p_lookup_type FND lookup type
1021: * p_column_value Column value
1022: * IN/OUT:

Line 1643: * FND_LOOKUP_VALUES

1639: * For now, we are supporting
1640: * AR_LOOKUPS
1641: * SO_LOOKUPS
1642: * OE_SHIP_METHODS_V
1643: * FND_LOOKUP_VALUES
1644: * Default value is AR_LOOKUPS
1645: * p_lookup_type FND lookup type
1646: * p_lookup_code FND lookup code
1647: *

Line 2383: fnd_lookup_values lu

2379:
2380: CURSOR c_org_contact_roles IS
2381: SELECT lu.meaning
2382: FROM hz_org_contact_roles ocr,
2383: fnd_lookup_values lu
2384: WHERE ocr.org_contact_id = p_org_contact_id
2385: AND ocr.status = 'A'
2386: AND lu.view_application_id = 222
2387: AND lu.language = userenv('LANG')

Line 2822: * This function will return the meaning in FND_LOOKUP_VALUES for the given combination

2818: /**
2819: * FUNCTION get_lookupMeaning_lang
2820: *
2821: * DESCRIPTION
2822: * This function will return the meaning in FND_LOOKUP_VALUES for the given combination
2823: * of lookup_type, lookup_code and language.
2824: *
2825: * ARGUMENTS
2826: * IN:

Line 2831: * RETURNS : VARCHAR2 (FND_LOOKUP_VALUES.Meaning)

2827: * p_lookup_type
2828: * p_lookup_code
2829: * p_language
2830: *
2831: * RETURNS : VARCHAR2 (FND_LOOKUP_VALUES.Meaning)
2832: *
2833: * NOTES
2834: *
2835: * MODIFICATION HISTORY

Line 2848: FROM FND_LOOKUP_VALUES

2844: ) RETURN VARCHAR2 IS
2845:
2846: CURSOR c_lookup_meaning_for_lang IS
2847: SELECT meaning
2848: FROM FND_LOOKUP_VALUES
2849: WHERE lookup_type = p_lookup_type
2850: AND lookup_code = p_lookup_code
2851: AND language = p_language
2852: AND enabled_flag = 'Y'

Line 2875: * This function will return the description in FND_LOOKUP_VALUES for the given combination

2871: /**
2872: * FUNCTION get_lookupDesc_lang
2873: *
2874: * DESCRIPTION
2875: * This function will return the description in FND_LOOKUP_VALUES for the given combination
2876: * of lookup_type, lookup_code and language.
2877: *
2878: * ARGUMENTS
2879: * IN:

Line 2884: * RETURNS : VARCHAR2 (FND_LOOKUP_VALUES.Description)

2880: * p_lookup_type
2881: * p_lookup_code
2882: * p_language
2883: *
2884: * RETURNS : VARCHAR2 (FND_LOOKUP_VALUES.Description)
2885: *
2886: * NOTES
2887: *
2888: * MODIFICATION HISTORY

Line 2901: FROM FND_LOOKUP_VALUES

2897: ) RETURN VARCHAR2 IS
2898:
2899: CURSOR c_lookup_desc_for_lang IS
2900: SELECT description
2901: FROM FND_LOOKUP_VALUES
2902: WHERE lookup_type = p_lookup_type
2903: AND lookup_code = p_lookup_code
2904: AND language = p_language
2905: AND enabled_flag = 'Y'