DBA Data[Home] [Help]

APPS.AP_APXIIMPT_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 59: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

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

Line 60: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

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

Line 61: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

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

Line 75: AP_LOOKUP_CODES L1,

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

Line 76: AP_LOOKUP_CODES L2,

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

Line 77: AP_LOOKUP_CODES L3

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

Line 463: AP_LOOKUP_CODES

459: SELECT
460: DISPLAYED_FIELD
461: INTO L_SOURCES
462: FROM
463: AP_LOOKUP_CODES
464: WHERE LOOKUP_TYPE = 'SOURCE'
465: AND LOOKUP_CODE = p_source_t;
466: RETURN L_SOURCES;
467: END;