99: END GET_COVER_PAGE_VALUES;
100:
101: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
102: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
103: NLS_YES FND_LOOKUPS.MEANING%TYPE;
104: NLS_NO FND_LOOKUPS.MEANING%TYPE;
105: NLS_UNPAID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
106: HEADER_VENDOR_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
107: HEADER_VENDOR_NAME AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
100:
101: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
102: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
103: NLS_YES FND_LOOKUPS.MEANING%TYPE;
104: NLS_NO FND_LOOKUPS.MEANING%TYPE;
105: NLS_UNPAID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
106: HEADER_VENDOR_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
107: HEADER_VENDOR_NAME AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
108: HEADER_SHOW_PREPAY_DIST FND_LOOKUPS.MEANING%TYPE;
104: NLS_NO FND_LOOKUPS.MEANING%TYPE;
105: NLS_UNPAID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
106: HEADER_VENDOR_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
107: HEADER_VENDOR_NAME AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
108: HEADER_SHOW_PREPAY_DIST FND_LOOKUPS.MEANING%TYPE;
109: HEADER_INCLUDE_INVOICE FND_LOOKUPS.MEANING%TYPE;
110: HEADER_INCLUDE_CREDIT FND_LOOKUPS.MEANING%TYPE;
111: HEADER_PREPAYMENT_TYPE FND_LOOKUPS.MEANING%TYPE;
112: BEGIN
105: NLS_UNPAID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
106: HEADER_VENDOR_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
107: HEADER_VENDOR_NAME AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
108: HEADER_SHOW_PREPAY_DIST FND_LOOKUPS.MEANING%TYPE;
109: HEADER_INCLUDE_INVOICE FND_LOOKUPS.MEANING%TYPE;
110: HEADER_INCLUDE_CREDIT FND_LOOKUPS.MEANING%TYPE;
111: HEADER_PREPAYMENT_TYPE FND_LOOKUPS.MEANING%TYPE;
112: BEGIN
113: NLS_ALL := '';
106: HEADER_VENDOR_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
107: HEADER_VENDOR_NAME AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
108: HEADER_SHOW_PREPAY_DIST FND_LOOKUPS.MEANING%TYPE;
109: HEADER_INCLUDE_INVOICE FND_LOOKUPS.MEANING%TYPE;
110: HEADER_INCLUDE_CREDIT FND_LOOKUPS.MEANING%TYPE;
111: HEADER_PREPAYMENT_TYPE FND_LOOKUPS.MEANING%TYPE;
112: BEGIN
113: NLS_ALL := '';
114: NLS_YES := '';
107: HEADER_VENDOR_NAME AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
108: HEADER_SHOW_PREPAY_DIST FND_LOOKUPS.MEANING%TYPE;
109: HEADER_INCLUDE_INVOICE FND_LOOKUPS.MEANING%TYPE;
110: HEADER_INCLUDE_CREDIT FND_LOOKUPS.MEANING%TYPE;
111: HEADER_PREPAYMENT_TYPE FND_LOOKUPS.MEANING%TYPE;
112: BEGIN
113: NLS_ALL := '';
114: NLS_YES := '';
115: NLS_NO := '';
122: L7.MEANING,
123: L8.MEANING
124: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_UNPAID,HEADER_SHOW_PREPAY_DIST,HEADER_INCLUDE_INVOICE,HEADER_INCLUDE_CREDIT
125: FROM
126: FND_LOOKUPS LY,
127: FND_LOOKUPS LN,
128: AP_LOOKUP_CODES LA,
129: AP_LOOKUP_CODES L4,
130: FND_LOOKUPS L6,
123: L8.MEANING
124: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_UNPAID,HEADER_SHOW_PREPAY_DIST,HEADER_INCLUDE_INVOICE,HEADER_INCLUDE_CREDIT
125: FROM
126: FND_LOOKUPS LY,
127: FND_LOOKUPS LN,
128: AP_LOOKUP_CODES LA,
129: AP_LOOKUP_CODES L4,
130: FND_LOOKUPS L6,
131: FND_LOOKUPS L7,
126: FND_LOOKUPS LY,
127: FND_LOOKUPS LN,
128: AP_LOOKUP_CODES LA,
129: AP_LOOKUP_CODES L4,
130: FND_LOOKUPS L6,
131: FND_LOOKUPS L7,
132: FND_LOOKUPS L8
133: WHERE LY.LOOKUP_TYPE = 'YES_NO'
134: AND LY.LOOKUP_CODE = 'Y'
127: FND_LOOKUPS LN,
128: AP_LOOKUP_CODES LA,
129: AP_LOOKUP_CODES L4,
130: FND_LOOKUPS L6,
131: FND_LOOKUPS L7,
132: FND_LOOKUPS L8
133: WHERE LY.LOOKUP_TYPE = 'YES_NO'
134: AND LY.LOOKUP_CODE = 'Y'
135: AND LN.LOOKUP_TYPE = 'YES_NO'
128: AP_LOOKUP_CODES LA,
129: AP_LOOKUP_CODES L4,
130: FND_LOOKUPS L6,
131: FND_LOOKUPS L7,
132: FND_LOOKUPS L8
133: WHERE LY.LOOKUP_TYPE = 'YES_NO'
134: AND LY.LOOKUP_CODE = 'Y'
135: AND LN.LOOKUP_TYPE = 'YES_NO'
136: AND LN.LOOKUP_CODE = 'N'