DBA Data[Home] [Help]

APPS.ZX_ZXXINUTR_XMLP_PKG dependencies on FND_LOOKUPS

Line 32: L_NLS_REPORT_BASIS FND_LOOKUPS.MEANING%TYPE;

28: RETURN (FALSE);
29: END GET_BASE_CURR_DATA;
30:
31: FUNCTION CUSTOM_INIT RETURN BOOLEAN IS
32: L_NLS_REPORT_BASIS FND_LOOKUPS.MEANING%TYPE;
33: L_NLS_INV_STATUS FND_LOOKUPS.MEANING%TYPE;
34: L_NLS_ORDERBY FND_LOOKUPS.MEANING%TYPE;
35: BEGIN
36: P_MIN_PRECISION := C_BASE_PRECISION;

Line 33: L_NLS_INV_STATUS FND_LOOKUPS.MEANING%TYPE;

29: END GET_BASE_CURR_DATA;
30:
31: FUNCTION CUSTOM_INIT RETURN BOOLEAN IS
32: L_NLS_REPORT_BASIS FND_LOOKUPS.MEANING%TYPE;
33: L_NLS_INV_STATUS FND_LOOKUPS.MEANING%TYPE;
34: L_NLS_ORDERBY FND_LOOKUPS.MEANING%TYPE;
35: BEGIN
36: P_MIN_PRECISION := C_BASE_PRECISION;
37: P_TAX_PARAM_DISP := P_TAX_PARAM;

Line 34: L_NLS_ORDERBY FND_LOOKUPS.MEANING%TYPE;

30:
31: FUNCTION CUSTOM_INIT RETURN BOOLEAN IS
32: L_NLS_REPORT_BASIS FND_LOOKUPS.MEANING%TYPE;
33: L_NLS_INV_STATUS FND_LOOKUPS.MEANING%TYPE;
34: L_NLS_ORDERBY FND_LOOKUPS.MEANING%TYPE;
35: BEGIN
36: P_MIN_PRECISION := C_BASE_PRECISION;
37: P_TAX_PARAM_DISP := P_TAX_PARAM;
38: P_INV_STATUS_D := P_INV_STATUS;

Line 54: FND_LOOKUPS ALC1,

50: ALC2.MEANING,
51: ALC3.MEANING
52: INTO L_NLS_REPORT_BASIS,L_NLS_INV_STATUS,L_NLS_ORDERBY
53: FROM
54: FND_LOOKUPS ALC1,
55: FND_LOOKUPS ALC2,
56: FND_LOOKUPS ALC3
57: WHERE ALC1.LOOKUP_TYPE = 'ZX_TRL_TAX_USE_DATE_BASIS'
58: AND ALC1.LOOKUP_CODE = P_REPORT_BASIS

Line 55: FND_LOOKUPS ALC2,

51: ALC3.MEANING
52: INTO L_NLS_REPORT_BASIS,L_NLS_INV_STATUS,L_NLS_ORDERBY
53: FROM
54: FND_LOOKUPS ALC1,
55: FND_LOOKUPS ALC2,
56: FND_LOOKUPS ALC3
57: WHERE ALC1.LOOKUP_TYPE = 'ZX_TRL_TAX_USE_DATE_BASIS'
58: AND ALC1.LOOKUP_CODE = P_REPORT_BASIS
59: AND ALC2.LOOKUP_TYPE = 'ZX_TRL_INVOICE_STATUS'

Line 56: FND_LOOKUPS ALC3

52: INTO L_NLS_REPORT_BASIS,L_NLS_INV_STATUS,L_NLS_ORDERBY
53: FROM
54: FND_LOOKUPS ALC1,
55: FND_LOOKUPS ALC2,
56: FND_LOOKUPS ALC3
57: WHERE ALC1.LOOKUP_TYPE = 'ZX_TRL_TAX_USE_DATE_BASIS'
58: AND ALC1.LOOKUP_CODE = P_REPORT_BASIS
59: AND ALC2.LOOKUP_TYPE = 'ZX_TRL_INVOICE_STATUS'
60: AND ALC2.LOOKUP_CODE = P_INV_STATUS_D

Line 87: NLS_YES FND_LOOKUPS.MEANING%TYPE;

83: END GET_COVER_PAGE_VALUES;
84:
85: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
86: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
87: NLS_YES FND_LOOKUPS.MEANING%TYPE;
88: NLS_NO FND_LOOKUPS.MEANING%TYPE;
89: BEGIN
90: NLS_ALL := '';
91: NLS_YES := '';

Line 88: NLS_NO FND_LOOKUPS.MEANING%TYPE;

84:
85: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
86: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
87: NLS_YES FND_LOOKUPS.MEANING%TYPE;
88: NLS_NO FND_LOOKUPS.MEANING%TYPE;
89: BEGIN
90: NLS_ALL := '';
91: NLS_YES := '';
92: NLS_NO := '';

Line 99: FND_LOOKUPS LY,

95: LN.MEANING,
96: LA.DISPLAYED_FIELD
97: INTO NLS_YES,NLS_NO,NLS_ALL
98: FROM
99: FND_LOOKUPS LY,
100: FND_LOOKUPS LN,
101: AP_LOOKUP_CODES LA
102: WHERE LY.LOOKUP_TYPE = 'YES_NO'
103: AND LY.LOOKUP_CODE = 'Y'

Line 100: FND_LOOKUPS LN,

96: LA.DISPLAYED_FIELD
97: INTO NLS_YES,NLS_NO,NLS_ALL
98: FROM
99: FND_LOOKUPS LY,
100: FND_LOOKUPS LN,
101: AP_LOOKUP_CODES LA
102: WHERE LY.LOOKUP_TYPE = 'YES_NO'
103: AND LY.LOOKUP_CODE = 'Y'
104: AND LN.LOOKUP_TYPE = 'YES_NO'