APPS.AP_APXVCHCR_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; l_nls_display_supp_address 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; l_nls_display_supp_address fnd_lookups.meaning%TYPE;
68: l_nls_zero_amt_option fnd_lookups.meaning%TYPE;
69: nls_none_ep ap_lookup_codes.displayed_field%TYPE;
70:
71: BEGIN

Line 69: nls_none_ep ap_lookup_codes.displayed_field%TYPE;

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; l_nls_display_supp_address fnd_lookups.meaning%TYPE;
68: l_nls_zero_amt_option fnd_lookups.meaning%TYPE;
69: nls_none_ep ap_lookup_codes.displayed_field%TYPE;
70:
71: BEGIN
72:
73: nls_all := '';

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

79: ln.meaning,
80: la.displayed_field,
81: lanep.displayed_field
82: INTO nls_yes, nls_no, nls_all, nls_none_ep
83: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la,
84: ap_lookup_codes lanep
85: WHERE ly.lookup_type = 'YES_NO'
86: AND ly.lookup_code = 'Y'
87: AND ln.lookup_type = 'YES_NO'

Line 84: ap_lookup_codes lanep

80: la.displayed_field,
81: lanep.displayed_field
82: INTO nls_yes, nls_no, nls_all, nls_none_ep
83: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la,
84: ap_lookup_codes lanep
85: WHERE ly.lookup_type = 'YES_NO'
86: AND ly.lookup_code = 'Y'
87: AND ln.lookup_type = 'YES_NO'
88: AND ln.lookup_code = 'N'

Line 387: l_displayed_field ap_lookup_codes.displayed_field%TYPE;

383:
384: RETURN NULL; end;
385:
386: FUNCTION GET_DATE_OPTION RETURN BOOLEAN IS
387: l_displayed_field ap_lookup_codes.displayed_field%TYPE;
388:
389: BEGIN
390:
391: SELECT displayed_field

Line 393: FROM ap_lookup_codes

389: BEGIN
390:
391: SELECT displayed_field
392: INTO l_displayed_field
393: FROM ap_lookup_codes
394: WHERE lookup_type = 'CHECK OR VOID'
395: AND lookup_code = P_DATE_OPTION;
396:
397: c_date_option := l_displayed_field;