DBA Data[Home] [Help]

APPS.JE_JEHUIAGE_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 39: L_SORT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

35:
36: FUNCTION CUSTOM_INIT RETURN BOOLEAN IS
37: MINDAY NUMBER(10);
38: MAXDAY NUMBER(10);
39: L_SORT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
40: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
41: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
42: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
43: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

Line 40: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

36: FUNCTION CUSTOM_INIT RETURN BOOLEAN IS
37: MINDAY NUMBER(10);
38: MAXDAY NUMBER(10);
39: L_SORT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
40: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
41: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
42: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
43: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
44: L_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;

Line 41: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

37: MINDAY NUMBER(10);
38: MAXDAY NUMBER(10);
39: L_SORT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
40: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
41: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
42: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
43: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
44: L_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;
45: BEGIN

Line 42: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

38: MAXDAY NUMBER(10);
39: L_SORT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
40: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
41: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
42: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
43: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
44: L_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;
45: BEGIN
46: /*SRW.MESSAGE('260974'

Line 43: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

39: L_SORT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
40: L_SUMMARY_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
41: L_FORMAT_OPTION AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
42: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
43: L_INVOICE_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
44: L_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;
45: BEGIN
46: /*SRW.MESSAGE('260974'
47: ,'One')*/NULL;

Line 53: AP_LOOKUP_CODES

49: SELECT
50: DISPLAYED_FIELD
51: INTO L_SORT_OPTION
52: FROM
53: 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 65: AP_LOOKUP_CODES

61: SELECT
62: DISPLAYED_FIELD
63: INTO L_SUMMARY_OPTION
64: FROM
65: AP_LOOKUP_CODES
66: WHERE LOOKUP_TYPE = 'AGING_SUMMARY_OPTION'
67: AND LOOKUP_CODE = P_SUMMARY_OPTION;
68: C_HEAD_SUMMARY_OPTION := L_SUMMARY_OPTION;
69: END;

Line 77: AP_LOOKUP_CODES

73: SELECT
74: DISPLAYED_FIELD
75: INTO L_FORMAT_OPTION
76: FROM
77: AP_LOOKUP_CODES
78: WHERE LOOKUP_TYPE = 'AGING_FORMAT_OPTION'
79: AND LOOKUP_CODE = P_FORMAT_OPTION;
80: C_HEAD_FORMAT_OPTION := L_FORMAT_OPTION;
81: END;

Line 89: AP_LOOKUP_CODES

85: SELECT
86: DISPLAYED_FIELD
87: INTO L_NLS_ALL
88: FROM
89: AP_LOOKUP_CODES
90: WHERE LOOKUP_TYPE = 'NLS REPORT PARAMETER'
91: AND LOOKUP_CODE = 'ALL';
92: END;
93: /*SRW.MESSAGE('260974'

Line 104: AP_LOOKUP_CODES

100: SELECT
101: DISPLAYED_FIELD
102: INTO L_INVOICE_TYPE
103: FROM
104: AP_LOOKUP_CODES
105: WHERE LOOKUP_TYPE = 'INVOICE TYPE'
106: AND LOOKUP_CODE = P_INVOICE_TYPE;
107: C_HEAD_INVOICE_TYPE := L_INVOICE_TYPE;
108: C_INVOICE_TYPE_SELECT := P_INVOICE_TYPE;

Line 182: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

178: L_LEDGER_ID NUMBER;
179: L_LEGAL_ENTITY_ID NUMBER;
180: L_LEDGER_NAME GL_LEDGERS.NAME%TYPE;
181: L_LEGAL_ENTITY_NAME XLE_ENTITY_PROFILES.NAME%TYPE;
182: L_NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
183: BEGIN
184: L_LEDGER_ID := P_LEDGER_ID;
185: L_LEGAL_ENTITY_ID := P_LEGAL_ENTITY_ID;
186: L_NLS_ALL := C_NLS_ALL;

Line 213: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

209: RETURN (FALSE);
210: END GET_COVER_PAGE_VALUES;
211:
212: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
213: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
214: NLS_YES FND_LOOKUPS.MEANING%TYPE;
215: NLS_NO FND_LOOKUPS.MEANING%TYPE;
216: BEGIN
217: NLS_ALL := '';

Line 228: AP_LOOKUP_CODES LA

224: INTO NLS_YES,NLS_NO,NLS_ALL
225: FROM
226: FND_LOOKUPS LY,
227: FND_LOOKUPS LN,
228: AP_LOOKUP_CODES LA
229: WHERE LY.LOOKUP_TYPE = 'YES_NO'
230: AND LY.LOOKUP_CODE = 'Y'
231: AND LN.LOOKUP_TYPE = 'YES_NO'
232: AND LN.LOOKUP_CODE = 'N'