DBA Data[Home] [Help]

APPS.AP_APXINPSR_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 102: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

98: RETURN (FALSE);
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;

Line 105: NLS_UNPAID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

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;
109: HEADER_INCLUDE_INVOICE FND_LOOKUPS.MEANING%TYPE;

Line 106: HEADER_VENDOR_TYPE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

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;
109: HEADER_INCLUDE_INVOICE FND_LOOKUPS.MEANING%TYPE;
110: HEADER_INCLUDE_CREDIT FND_LOOKUPS.MEANING%TYPE;

Line 107: HEADER_VENDOR_NAME 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;
109: HEADER_INCLUDE_INVOICE FND_LOOKUPS.MEANING%TYPE;
110: HEADER_INCLUDE_CREDIT FND_LOOKUPS.MEANING%TYPE;
111: HEADER_PREPAYMENT_TYPE FND_LOOKUPS.MEANING%TYPE;

Line 129: AP_LOOKUP_CODES LA,

125: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_UNPAID,HEADER_SHOW_PREPAY_DIST,HEADER_INCLUDE_INVOICE,HEADER_INCLUDE_CREDIT
126: FROM
127: FND_LOOKUPS LY,
128: FND_LOOKUPS LN,
129: AP_LOOKUP_CODES LA,
130: AP_LOOKUP_CODES L4,
131: FND_LOOKUPS L6,
132: FND_LOOKUPS L7,
133: FND_LOOKUPS L8

Line 130: AP_LOOKUP_CODES L4,

126: FROM
127: FND_LOOKUPS LY,
128: FND_LOOKUPS LN,
129: AP_LOOKUP_CODES LA,
130: AP_LOOKUP_CODES L4,
131: FND_LOOKUPS L6,
132: FND_LOOKUPS L7,
133: FND_LOOKUPS L8
134: WHERE LY.LOOKUP_TYPE = 'YES_NO'

Line 176: AP_LOOKUP_CODES

172: SELECT
173: DISPLAYED_FIELD
174: INTO HEADER_PREPAYMENT_TYPE
175: FROM
176: AP_LOOKUP_CODES
177: WHERE LOOKUP_CODE = NVL(P_PREPAYMENT_TYPE
178: ,'TEMPORARY')
179: AND LOOKUP_TYPE = 'PREPAY TYPES';
180: C_NLS_YES := NLS_YES;