APPS.AP_WEB_POLICY_UTILS dependencies on FND_LOOKUPS

Line 203: l_meaning fnd_lookups.meaning%TYPE := '';

199: |
200: *=======================================================================*/
201: FUNCTION get_schedule_status(p_policy_id IN NUMBER) RETURN VARCHAR2 IS
202:
203: l_meaning fnd_lookups.meaning%TYPE := '';
204: l_lookup_code fnd_lookups.lookup_code%TYPE;
205: l_sch_end_date ap_pol_headers.end_date%TYPE;
206: l_no__saved_or_duplicated NUMBER;
207: l_no__active_or_inactive NUMBER;

Line 204: l_lookup_code fnd_lookups.lookup_code%TYPE;

200: *=======================================================================*/
201: FUNCTION get_schedule_status(p_policy_id IN NUMBER) RETURN VARCHAR2 IS
202:
203: l_meaning fnd_lookups.meaning%TYPE := '';
204: l_lookup_code fnd_lookups.lookup_code%TYPE;
205: l_sch_end_date ap_pol_headers.end_date%TYPE;
206: l_no__saved_or_duplicated NUMBER;
207: l_no__active_or_inactive NUMBER;
208: l_no__need_activation NUMBER;

Line 320: l_meaning fnd_lookups.meaning%TYPE;

316: |
317: *=======================================================================*/
318: FUNCTION get_lookup_meaning(p_lookup_type IN VARCHAR2,
319: p_lookup_code IN VARCHAR2) RETURN VARCHAR2 IS
320: l_meaning fnd_lookups.meaning%TYPE;
321: l_hash_value NUMBER;
322: l_lang VARCHAR2(500);
323: BEGIN
324:

Line 387: l_description fnd_lookups.description%TYPE;

383: |
384: *=======================================================================*/
385: FUNCTION get_lookup_description(p_lookup_type IN VARCHAR2,
386: p_lookup_code IN VARCHAR2) RETURN VARCHAR2 IS
387: l_description fnd_lookups.description%TYPE;
388: BEGIN
389:
390: IF p_lookup_code IS NOT NULL AND
391: p_lookup_type IS NOT NULL THEN

Line 4963: l_lookup_type fnd_lookups.lookup_type%TYPE;

4959: |
4960: *=======================================================================*/
4961: FUNCTION get_per_diem_type_meaning(p_source IN VARCHAR2,
4962: p_lookup_code IN VARCHAR2) RETURN VARCHAR2 IS
4963: l_lookup_type fnd_lookups.lookup_type%TYPE;
4964: BEGIN
4965:
4966: IF ( p_source = 'CONUS' ) THEN
4967: l_lookup_type := 'OIE_PER_DIEM_UPLOAD_TYPES';