DBA Data[Home] [Help]

APPS.AP_APXPTPTR_XMLP_PKG dependencies on AP_LOOKUP_CODES

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

41: WHEN OTHERS THEN
42: RETURN(FALSE);
43: END;
44: FUNCTION get_nls_strings RETURN BOOLEAN IS
45: nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE; nls_termtype ap_lookup_codes.displayed_field%TYPE;
46: BEGIN
47: nls_all := '';
48: nls_yes := '';
49: nls_no := '';

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

51: SELECT ly.meaning,
52: ln.meaning,
53: la.displayed_field, lt.displayed_field
54: INTO nls_yes, nls_no, nls_all, nls_termtype
55: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la,
56: ap_lookup_codes lt
57: WHERE ly.lookup_type = 'YES_NO'
58: AND ly.lookup_code = 'Y'
59: AND ln.lookup_type = 'YES_NO'

Line 56: ap_lookup_codes lt

52: ln.meaning,
53: la.displayed_field, lt.displayed_field
54: INTO nls_yes, nls_no, nls_all, nls_termtype
55: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la,
56: ap_lookup_codes lt
57: WHERE ly.lookup_type = 'YES_NO'
58: AND ly.lookup_code = 'Y'
59: AND ln.lookup_type = 'YES_NO'
60: AND ln.lookup_code = 'N'