DBA Data[Home] [Help]

APPS.AP_APXINDUP_XMLP_PKG dependencies on FND_LOOKUPS

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

46: WHEN OTHERS THEN
47: RETURN(FALSE);
48: END;
49: FUNCTION get_nls_strings RETURN BOOLEAN IS
50: nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
51: BEGIN
52: nls_all := '';
53: nls_yes := '';
54: nls_no := '';

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

55: SELECT ly.meaning,
56: ln.meaning,
57: la.displayed_field
58: INTO nls_yes, nls_no, nls_all
59: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la
60: WHERE ly.lookup_type = 'YES_NO'
61: AND ly.lookup_code = 'Y'
62: AND ln.lookup_type = 'YES_NO'
63: AND ln.lookup_code = 'N'

Line 187: l_comp_inv_date fnd_lookups.meaning%TYPE;

183: --Commented By Raj
184: --RETURN NULL; end;
185: RETURN ' '; end;
186: function CF_INV_DATE_COMPFormula return Char is
187: l_comp_inv_date fnd_lookups.meaning%TYPE;
188: l_lookup_code fnd_lookups.lookup_type%TYPE;
189: begin
190: select meaning into l_comp_inv_date
191: from fnd_lookups

Line 188: l_lookup_code fnd_lookups.lookup_type%TYPE;

184: --RETURN NULL; end;
185: RETURN ' '; end;
186: function CF_INV_DATE_COMPFormula return Char is
187: l_comp_inv_date fnd_lookups.meaning%TYPE;
188: l_lookup_code fnd_lookups.lookup_type%TYPE;
189: begin
190: select meaning into l_comp_inv_date
191: from fnd_lookups
192: where lookup_type = 'YES_NO'

Line 191: from fnd_lookups

187: l_comp_inv_date fnd_lookups.meaning%TYPE;
188: l_lookup_code fnd_lookups.lookup_type%TYPE;
189: begin
190: select meaning into l_comp_inv_date
191: from fnd_lookups
192: where lookup_type = 'YES_NO'
193: and lookup_code = p_inv_date_comp;
194: return(l_comp_inv_date);
195: end;