24:
25: END;
26:
27: FUNCTION get_nls_strings RETURN BOOLEAN IS
28: nls_void ap_lookup_codes.displayed_field%TYPE;
29: nls_na ap_lookup_codes.displayed_field%TYPE;
30: nls_all ap_lookup_codes.displayed_field%TYPE;
31: nls_yes fnd_lookups.meaning%TYPE;
32: nls_no fnd_lookups.meaning%TYPE;
25: END;
26:
27: FUNCTION get_nls_strings RETURN BOOLEAN IS
28: nls_void ap_lookup_codes.displayed_field%TYPE;
29: nls_na ap_lookup_codes.displayed_field%TYPE;
30: nls_all ap_lookup_codes.displayed_field%TYPE;
31: nls_yes fnd_lookups.meaning%TYPE;
32: nls_no fnd_lookups.meaning%TYPE;
33: nls_pay_method ap_lookup_codes.displayed_field%TYPE;
26:
27: FUNCTION get_nls_strings RETURN BOOLEAN IS
28: nls_void ap_lookup_codes.displayed_field%TYPE;
29: nls_na ap_lookup_codes.displayed_field%TYPE;
30: nls_all ap_lookup_codes.displayed_field%TYPE;
31: nls_yes fnd_lookups.meaning%TYPE;
32: nls_no fnd_lookups.meaning%TYPE;
33: nls_pay_method ap_lookup_codes.displayed_field%TYPE;
34: BEGIN
29: nls_na ap_lookup_codes.displayed_field%TYPE;
30: nls_all ap_lookup_codes.displayed_field%TYPE;
31: nls_yes fnd_lookups.meaning%TYPE;
32: nls_no fnd_lookups.meaning%TYPE;
33: nls_pay_method ap_lookup_codes.displayed_field%TYPE;
34: BEGIN
35:
36:
37: IF p_pmt_method IS NOT NULL THEN
49: nls_na,
50: nls_pay_method
51: FROM fnd_lookups ly,
52: fnd_lookups ln,
53: ap_lookup_codes l1,
54: ap_lookup_codes l2,
55: ap_lookup_codes l3,
56: ap_lookup_codes l4
57: WHERE ly.lookup_type = 'YES_NO'
50: nls_pay_method
51: FROM fnd_lookups ly,
52: fnd_lookups ln,
53: ap_lookup_codes l1,
54: ap_lookup_codes l2,
55: ap_lookup_codes l3,
56: ap_lookup_codes l4
57: WHERE ly.lookup_type = 'YES_NO'
58: AND ly.lookup_code = 'Y'
51: FROM fnd_lookups ly,
52: fnd_lookups ln,
53: ap_lookup_codes l1,
54: ap_lookup_codes l2,
55: ap_lookup_codes l3,
56: ap_lookup_codes l4
57: WHERE ly.lookup_type = 'YES_NO'
58: AND ly.lookup_code = 'Y'
59: AND ln.lookup_type = 'YES_NO'
52: fnd_lookups ln,
53: ap_lookup_codes l1,
54: ap_lookup_codes l2,
55: ap_lookup_codes l3,
56: ap_lookup_codes l4
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'
87: nls_void,
88: nls_na
89: FROM fnd_lookups ly,
90: fnd_lookups ln,
91: ap_lookup_codes l1,
92: ap_lookup_codes l2,
93: ap_lookup_codes l3
94: WHERE ly.lookup_type = 'YES_NO'
95: AND ly.lookup_code = 'Y'
88: nls_na
89: FROM fnd_lookups ly,
90: fnd_lookups ln,
91: ap_lookup_codes l1,
92: ap_lookup_codes l2,
93: ap_lookup_codes l3
94: WHERE ly.lookup_type = 'YES_NO'
95: AND ly.lookup_code = 'Y'
96: AND ln.lookup_type = 'YES_NO'
89: FROM fnd_lookups ly,
90: fnd_lookups ln,
91: ap_lookup_codes l1,
92: ap_lookup_codes l2,
93: ap_lookup_codes l3
94: WHERE ly.lookup_type = 'YES_NO'
95: AND ly.lookup_code = 'Y'
96: AND ln.lookup_type = 'YES_NO'
97: AND ln.lookup_code = 'N'