DBA Data[Home] [Help]

APPS.AP_APXT7CMT_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 132: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

128: RETURN (FALSE);
129: END GET_COVER_PAGE_VALUES;
130:
131: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
132: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
133: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
134: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
135: NLS_YES FND_LOOKUPS.MEANING%TYPE;
136: NLS_NO FND_LOOKUPS.MEANING%TYPE;

Line 133: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

129: END GET_COVER_PAGE_VALUES;
130:
131: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
132: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
133: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
134: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
135: NLS_YES FND_LOOKUPS.MEANING%TYPE;
136: NLS_NO FND_LOOKUPS.MEANING%TYPE;
137: BEGIN

Line 134: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

130:
131: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
132: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
133: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
134: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
135: NLS_YES FND_LOOKUPS.MEANING%TYPE;
136: NLS_NO FND_LOOKUPS.MEANING%TYPE;
137: BEGIN
138: SELECT

Line 148: AP_LOOKUP_CODES L1,

144: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
145: FROM
146: FND_LOOKUPS LY,
147: FND_LOOKUPS LN,
148: AP_LOOKUP_CODES L1,
149: AP_LOOKUP_CODES L2,
150: AP_LOOKUP_CODES L3
151: WHERE LY.LOOKUP_TYPE = 'YES_NO'
152: AND LY.LOOKUP_CODE = 'Y'

Line 149: AP_LOOKUP_CODES L2,

145: FROM
146: FND_LOOKUPS LY,
147: FND_LOOKUPS LN,
148: AP_LOOKUP_CODES L1,
149: AP_LOOKUP_CODES L2,
150: AP_LOOKUP_CODES L3
151: WHERE LY.LOOKUP_TYPE = 'YES_NO'
152: AND LY.LOOKUP_CODE = 'Y'
153: AND LN.LOOKUP_TYPE = 'YES_NO'

Line 150: AP_LOOKUP_CODES L3

146: FND_LOOKUPS LY,
147: FND_LOOKUPS LN,
148: AP_LOOKUP_CODES L1,
149: AP_LOOKUP_CODES L2,
150: AP_LOOKUP_CODES L3
151: WHERE LY.LOOKUP_TYPE = 'YES_NO'
152: AND LY.LOOKUP_CODE = 'Y'
153: AND LN.LOOKUP_TYPE = 'YES_NO'
154: AND LN.LOOKUP_CODE = 'N'