DBA Data[Home] [Help]

APPS.AP_APXTOLRP_XMLP_PKG dependencies on AP_LOOKUP_CODES

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

41:
42: END;
43:
44: FUNCTION get_nls_strings RETURN BOOLEAN IS
45: nls_void ap_lookup_codes.displayed_field%TYPE; nls_na ap_lookup_codes.displayed_field%TYPE; nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
46: BEGIN
47:
48: SELECT ly.meaning,
49: ln.meaning,

Line 60: ap_lookup_codes l1,

56: nls_void,
57: nls_na
58: FROM fnd_lookups ly,
59: fnd_lookups ln,
60: ap_lookup_codes l1,
61: ap_lookup_codes l2,
62: ap_lookup_codes l3
63: WHERE ly.lookup_type = 'YES_NO'
64: AND ly.lookup_code = 'Y'

Line 61: ap_lookup_codes l2,

57: nls_na
58: FROM fnd_lookups ly,
59: fnd_lookups ln,
60: ap_lookup_codes l1,
61: ap_lookup_codes l2,
62: ap_lookup_codes l3
63: WHERE ly.lookup_type = 'YES_NO'
64: AND ly.lookup_code = 'Y'
65: AND ln.lookup_type = 'YES_NO'

Line 62: ap_lookup_codes l3

58: FROM fnd_lookups ly,
59: fnd_lookups ln,
60: ap_lookup_codes l1,
61: ap_lookup_codes l2,
62: ap_lookup_codes l3
63: WHERE ly.lookup_type = 'YES_NO'
64: AND ly.lookup_code = 'Y'
65: AND ln.lookup_type = 'YES_NO'
66: AND ln.lookup_code = 'N'