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 2399: fnd_lookup_values lu

2395:
2396: CURSOR c_org_contact_roles IS
2397: SELECT lu.meaning
2398: FROM hz_org_contact_roles ocr,
2399: fnd_lookup_values lu
2400: WHERE ocr.org_contact_id = p_org_contact_id
2401: AND ocr.status = 'A'
2402: AND lu.view_application_id = 222
2403: AND lu.language = userenv('LANG')

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

2834: /**
2835: * FUNCTION get_lookupMeaning_lang
2836: *
2837: * DESCRIPTION
2838: * This function will return the meaning in FND_LOOKUP_VALUES for the given combination
2839: * of lookup_type, lookup_code and language.
2840: *
2841: * ARGUMENTS
2842: * IN:

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

2843: * p_lookup_type
2844: * p_lookup_code
2845: * p_language
2846: *
2847: * RETURNS : VARCHAR2 (FND_LOOKUP_VALUES.Meaning)
2848: *
2849: * NOTES
2850: *
2851: * MODIFICATION HISTORY

Line 2864: FROM FND_LOOKUP_VALUES

2860: ) RETURN VARCHAR2 IS
2861:
2862: CURSOR c_lookup_meaning_for_lang IS
2863: SELECT meaning
2864: FROM FND_LOOKUP_VALUES
2865: WHERE lookup_type = p_lookup_type
2866: AND lookup_code = p_lookup_code
2867: AND language = p_language
2868: AND enabled_flag = 'Y'

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

2887: /**
2888: * FUNCTION get_lookupDesc_lang
2889: *
2890: * DESCRIPTION
2891: * This function will return the description in FND_LOOKUP_VALUES for the given combination
2892: * of lookup_type, lookup_code and language.
2893: *
2894: * ARGUMENTS
2895: * IN:

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

2896: * p_lookup_type
2897: * p_lookup_code
2898: * p_language
2899: *
2900: * RETURNS : VARCHAR2 (FND_LOOKUP_VALUES.Description)
2901: *
2902: * NOTES
2903: *
2904: * MODIFICATION HISTORY

Line 2917: FROM FND_LOOKUP_VALUES

2913: ) RETURN VARCHAR2 IS
2914:
2915: CURSOR c_lookup_desc_for_lang IS
2916: SELECT description
2917: FROM FND_LOOKUP_VALUES
2918: WHERE lookup_type = p_lookup_type
2919: AND lookup_code = p_lookup_code
2920: AND language = p_language
2921: AND enabled_flag = 'Y'