APPS.AP_APXGDGDL_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 67: nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;

63:
64: END;
65:
66: FUNCTION get_nls_strings RETURN BOOLEAN IS
67: nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
68: BEGIN
69:
70: nls_all := '';
71: nls_yes := '';

Line 78: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la

74: SELECT ly.meaning,
75: ln.meaning,
76: la.displayed_field
77: INTO nls_yes, nls_no, nls_all
78: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la
79: WHERE ly.lookup_type = 'YES_NO'
80: AND ly.lookup_code = 'Y'
81: AND ln.lookup_type = 'YES_NO'
82: AND ln.lookup_code = 'N'

Line 277: displayed_whichset ap_lookup_codes.displayed_field%TYPE;

273:
274: END;
275:
276: FUNCTION get_whichset RETURN BOOLEAN IS
277: displayed_whichset ap_lookup_codes.displayed_field%TYPE;
278: l_which_set varchar2(15);
279: BEGIN
280: l_which_set := p_whichset;
281: SELECT displayed_field

Line 283: FROM ap_lookup_codes

279: BEGIN
280: l_which_set := p_whichset;
281: SELECT displayed_field
282: INTO displayed_whichset
283: FROM ap_lookup_codes
284: WHERE lookup_type = 'ACTIVE_OPTIONS'
285: AND upper(lookup_code) = upper(l_which_set);
286:
287: c_displayed_whichset := displayed_whichset;