DBA Data[Home] [Help]

APPS.JL_JLCOGLCM_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 53: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

49: RETURN (FALSE);
50: END GET_COVER_PAGE_VALUES;
51:
52: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
53: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
54: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
55: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
56: NLS_YES FND_LOOKUPS.MEANING%TYPE;
57: NLS_NO FND_LOOKUPS.MEANING%TYPE;

Line 54: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

50: END GET_COVER_PAGE_VALUES;
51:
52: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
53: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
54: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
55: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
56: NLS_YES FND_LOOKUPS.MEANING%TYPE;
57: NLS_NO FND_LOOKUPS.MEANING%TYPE;
58: BEGIN

Line 55: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

51:
52: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
53: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
54: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
55: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
56: NLS_YES FND_LOOKUPS.MEANING%TYPE;
57: NLS_NO FND_LOOKUPS.MEANING%TYPE;
58: BEGIN
59: SELECT

Line 69: AP_LOOKUP_CODES L1,

65: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
66: FROM
67: FND_LOOKUPS LY,
68: FND_LOOKUPS LN,
69: AP_LOOKUP_CODES L1,
70: AP_LOOKUP_CODES L2,
71: AP_LOOKUP_CODES L3
72: WHERE LY.LOOKUP_TYPE = 'YES_NO'
73: AND LY.LOOKUP_CODE = 'Y'

Line 70: AP_LOOKUP_CODES L2,

66: FROM
67: FND_LOOKUPS LY,
68: FND_LOOKUPS LN,
69: AP_LOOKUP_CODES L1,
70: AP_LOOKUP_CODES L2,
71: AP_LOOKUP_CODES L3
72: WHERE LY.LOOKUP_TYPE = 'YES_NO'
73: AND LY.LOOKUP_CODE = 'Y'
74: AND LN.LOOKUP_TYPE = 'YES_NO'

Line 71: AP_LOOKUP_CODES L3

67: FND_LOOKUPS LY,
68: FND_LOOKUPS LN,
69: AP_LOOKUP_CODES L1,
70: AP_LOOKUP_CODES L2,
71: AP_LOOKUP_CODES L3
72: WHERE LY.LOOKUP_TYPE = 'YES_NO'
73: AND LY.LOOKUP_CODE = 'Y'
74: AND LN.LOOKUP_TYPE = 'YES_NO'
75: AND LN.LOOKUP_CODE = 'N'