DBA Data[Home] [Help]

APPS.AP_APXIAWRE_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 57: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

53: RETURN (FALSE);
54: END GET_COVER_PAGE_VALUES;
55:
56: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
57: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
58: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
59: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
60: NLS_YES FND_LOOKUPS.MEANING%TYPE;
61: NLS_NO FND_LOOKUPS.MEANING%TYPE;

Line 58: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

54: END GET_COVER_PAGE_VALUES;
55:
56: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
57: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
58: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
59: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
60: NLS_YES FND_LOOKUPS.MEANING%TYPE;
61: NLS_NO FND_LOOKUPS.MEANING%TYPE;
62: BEGIN

Line 59: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

55:
56: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
57: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
58: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
59: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
60: NLS_YES FND_LOOKUPS.MEANING%TYPE;
61: NLS_NO FND_LOOKUPS.MEANING%TYPE;
62: BEGIN
63: SELECT

Line 73: AP_LOOKUP_CODES L1,

69: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
70: FROM
71: FND_LOOKUPS LY,
72: FND_LOOKUPS LN,
73: AP_LOOKUP_CODES L1,
74: AP_LOOKUP_CODES L2,
75: AP_LOOKUP_CODES L3
76: WHERE LY.LOOKUP_TYPE = 'YES_NO'
77: AND LY.LOOKUP_CODE = 'Y'

Line 74: AP_LOOKUP_CODES L2,

70: FROM
71: FND_LOOKUPS LY,
72: FND_LOOKUPS LN,
73: AP_LOOKUP_CODES L1,
74: AP_LOOKUP_CODES L2,
75: AP_LOOKUP_CODES L3
76: WHERE LY.LOOKUP_TYPE = 'YES_NO'
77: AND LY.LOOKUP_CODE = 'Y'
78: AND LN.LOOKUP_TYPE = 'YES_NO'

Line 75: AP_LOOKUP_CODES L3

71: FND_LOOKUPS LY,
72: FND_LOOKUPS LN,
73: AP_LOOKUP_CODES L1,
74: AP_LOOKUP_CODES L2,
75: AP_LOOKUP_CODES L3
76: WHERE LY.LOOKUP_TYPE = 'YES_NO'
77: AND LY.LOOKUP_CODE = 'Y'
78: AND LN.LOOKUP_TYPE = 'YES_NO'
79: AND LN.LOOKUP_CODE = 'N'