DBA Data[Home] [Help]

APPS.AP_APXMTDCR_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 112: l_nls_all ap_lookup_codes.displayed_field%TYPE;

108: END;
109:
110: FUNCTION get_nls_strings RETURN BOOLEAN IS
111: l_nls_yes fnd_lookups.meaning%TYPE;
112: l_nls_all ap_lookup_codes.displayed_field%TYPE;
113: l_payment_type ap_lookup_codes.displayed_field%TYPE;
114: l_nls_void_payment_not_incl varchar2(100);
115: l_nls_display_supp_address varchar2(80);
116: l_nls_none_ep ap_lookup_codes.displayed_field%TYPE;

Line 113: l_payment_type ap_lookup_codes.displayed_field%TYPE;

109:
110: FUNCTION get_nls_strings RETURN BOOLEAN IS
111: l_nls_yes fnd_lookups.meaning%TYPE;
112: l_nls_all ap_lookup_codes.displayed_field%TYPE;
113: l_payment_type ap_lookup_codes.displayed_field%TYPE;
114: l_nls_void_payment_not_incl varchar2(100);
115: l_nls_display_supp_address varchar2(80);
116: l_nls_none_ep ap_lookup_codes.displayed_field%TYPE;
117:

Line 116: l_nls_none_ep ap_lookup_codes.displayed_field%TYPE;

112: l_nls_all ap_lookup_codes.displayed_field%TYPE;
113: l_payment_type ap_lookup_codes.displayed_field%TYPE;
114: l_nls_void_payment_not_incl varchar2(100);
115: l_nls_display_supp_address varchar2(80);
116: l_nls_none_ep ap_lookup_codes.displayed_field%TYPE;
117:
118: BEGIN
119:
120:

Line 129: FROM fnd_lookups ly, ap_lookup_codes la, ap_lookup_codes lnep

125: SELECT ly.meaning,
126: la.displayed_field,
127: lnep.displayed_field
128: INTO l_nls_yes, l_nls_all, l_nls_none_ep
129: FROM fnd_lookups ly, ap_lookup_codes la, ap_lookup_codes lnep
130: WHERE ly.lookup_type = 'YES_NO'
131: AND ly.lookup_code = 'Y'
132: AND la.lookup_type = 'NLS REPORT PARAMETER'
133: AND la.lookup_code = 'ALL'

Line 154: FROM ap_lookup_codes

150: C_NLS_PAYMENT_TYPE := C_NLS_ALL;
151: else
152: SELECT displayed_field
153: INTO l_payment_type
154: FROM ap_lookup_codes
155: WHERE lookup_code = P_PAYMENT_TYPE
156: AND lookup_type = 'PAYMENT TYPE';
157:
158: C_NLS_PAYMENT_TYPE := l_payment_type;

Line 193: FROM ap_lookup_codes

189: END;
190: BEGIN
191: SELECT '* '||description
192: INTO l_nls_void_payment_not_incl
193: FROM ap_lookup_codes
194: WHERE lookup_type = 'NLS REPORT PARAMETER'
195: AND lookup_code = 'VOID PAYMENT NOT INCLUDED';
196:
197: c_nls_void_payment_not_incl := l_nls_void_payment_not_incl;