APPS.AP_WEB_POLICY_UTILS dependencies on FND_LOOKUPS

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

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

Line 203: l_lookup_code fnd_lookups.lookup_code%TYPE;

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

Line 318: l_meaning fnd_lookups.meaning%TYPE;

314: |
315: *=======================================================================*/
316: FUNCTION get_lookup_meaning(p_lookup_type IN VARCHAR2,
317: p_lookup_code IN VARCHAR2) RETURN VARCHAR2 IS
318: l_meaning fnd_lookups.meaning%TYPE;
319: l_hash_value NUMBER;
320: BEGIN
321:
322: IF p_lookup_code IS NOT NULL AND

Line 376: l_description fnd_lookups.description%TYPE;

372: |
373: *=======================================================================*/
374: FUNCTION get_lookup_description(p_lookup_type IN VARCHAR2,
375: p_lookup_code IN VARCHAR2) RETURN VARCHAR2 IS
376: l_description fnd_lookups.description%TYPE;
377: BEGIN
378:
379: IF p_lookup_code IS NOT NULL AND
380: p_lookup_type IS NOT NULL THEN

Line 4892: l_lookup_type fnd_lookups.lookup_type%TYPE;

4888: |
4889: *=======================================================================*/
4890: FUNCTION get_per_diem_type_meaning(p_source IN VARCHAR2,
4891: p_lookup_code IN VARCHAR2) RETURN VARCHAR2 IS
4892: l_lookup_type fnd_lookups.lookup_type%TYPE;
4893: BEGIN
4894:
4895: IF ( p_source = 'CONUS' ) THEN
4896: l_lookup_type := 'OIE_PER_DIEM_UPLOAD_TYPES';