APPS.AP_APXINAGE_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 43: L_SORT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

39:
40: FUNCTION custom_init RETURN BOOLEAN IS
41: MINDAY NUMBER(10);
42: MAXDAY NUMBER(10);
43: L_SORT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
44: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
45: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
46: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
47: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

Line 44: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

40: FUNCTION custom_init RETURN BOOLEAN IS
41: MINDAY NUMBER(10);
42: MAXDAY NUMBER(10);
43: L_SORT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
44: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
45: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
46: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
47: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
48: L_PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE;

Line 45: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

41: MINDAY NUMBER(10);
42: MAXDAY NUMBER(10);
43: L_SORT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
44: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
45: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
46: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
47: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
48: L_PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE;
49: BEGIN

Line 46: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

42: MAXDAY NUMBER(10);
43: L_SORT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
44: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
45: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
46: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
47: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
48: L_PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE;
49: BEGIN
50: BEGIN

Line 47: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

43: L_SORT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
44: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
45: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
46: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
47: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
48: L_PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE;
49: BEGIN
50: BEGIN
51: SELECT displayed_field

Line 53: FROM ap_lookup_codes

49: BEGIN
50: BEGIN
51: SELECT displayed_field
52: INTO l_sort_option
53: FROM ap_lookup_codes
54: WHERE lookup_type = 'AGING_SORT_OPTION'
55: AND lookup_code = P_SORT_OPTION;
56: C_HEAD_SORT_OPTION := L_SORT_OPTION;
57: END;

Line 81: FROM ap_lookup_codes

77:
78: BEGIN
79: SELECT displayed_field
80: INTO l_nls_all
81: FROM ap_lookup_codes
82: WHERE lookup_type = 'NLS REPORT PARAMETER'
83: AND lookup_code = 'ALL';
84: END;
85: BEGIN

Line 92: FROM ap_lookup_codes

88: C_HEAD_INVOICE_TYPE := L_NLS_ALL;
89: else
90: SELECT displayed_field
91: INTO l_invoice_type
92: FROM ap_lookup_codes
93: WHERE lookup_type = 'INVOICE TYPE'
94: AND lookup_code = P_INVOICE_TYPE;
95: C_HEAD_INVOICE_TYPE := L_INVOICE_TYPE;
96: C_INVOICE_TYPE_SELECT := P_INVOICE_TYPE;

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

152:
153: END;
154:
155: FUNCTION get_nls_strings RETURN BOOLEAN IS
156: nls_all ap_lookup_codes.displayed_field%TYPE; nls_yes fnd_lookups.meaning%TYPE; nls_no fnd_lookups.meaning%TYPE;
157: BEGIN
158:
159: nls_all := '';
160: nls_yes := '';

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

163: SELECT ly.meaning,
164: ln.meaning,
165: la.displayed_field
166: INTO nls_yes, nls_no, nls_all
167: FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la
168: WHERE ly.lookup_type = 'YES_NO'
169: AND ly.lookup_code = 'Y'
170: AND ln.lookup_type = 'YES_NO'
171: AND ln.lookup_code = 'N'