DBA Data[Home] [Help]

APPS.AP_APXSSIMP_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 4: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

1: PACKAGE BODY AP_APXSSIMP_XMLP_PKG AS
2: /* $Header: APXSSIMPB.pls 120.0 2007/12/27 08:32:01 vjaganat noship $ */
3: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
4: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
5: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
6: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
7: NLS_YES FND_LOOKUPS.MEANING%TYPE;
8: NLS_NO FND_LOOKUPS.MEANING%TYPE;

Line 5: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

1: PACKAGE BODY AP_APXSSIMP_XMLP_PKG AS
2: /* $Header: APXSSIMPB.pls 120.0 2007/12/27 08:32:01 vjaganat noship $ */
3: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
4: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
5: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
6: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
7: NLS_YES FND_LOOKUPS.MEANING%TYPE;
8: NLS_NO FND_LOOKUPS.MEANING%TYPE;
9: BEGIN

Line 6: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

2: /* $Header: APXSSIMPB.pls 120.0 2007/12/27 08:32:01 vjaganat noship $ */
3: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
4: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
5: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
6: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
7: NLS_YES FND_LOOKUPS.MEANING%TYPE;
8: NLS_NO FND_LOOKUPS.MEANING%TYPE;
9: BEGIN
10: SELECT

Line 20: AP_LOOKUP_CODES L1,

16: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
17: FROM
18: FND_LOOKUPS LY,
19: FND_LOOKUPS LN,
20: AP_LOOKUP_CODES L1,
21: AP_LOOKUP_CODES L2,
22: AP_LOOKUP_CODES L3
23: WHERE LY.LOOKUP_TYPE = 'YES_NO'
24: AND LY.LOOKUP_CODE = 'Y'

Line 21: AP_LOOKUP_CODES L2,

17: FROM
18: FND_LOOKUPS LY,
19: FND_LOOKUPS LN,
20: AP_LOOKUP_CODES L1,
21: AP_LOOKUP_CODES L2,
22: AP_LOOKUP_CODES L3
23: WHERE LY.LOOKUP_TYPE = 'YES_NO'
24: AND LY.LOOKUP_CODE = 'Y'
25: AND LN.LOOKUP_TYPE = 'YES_NO'

Line 22: AP_LOOKUP_CODES L3

18: FND_LOOKUPS LY,
19: FND_LOOKUPS LN,
20: AP_LOOKUP_CODES L1,
21: AP_LOOKUP_CODES L2,
22: AP_LOOKUP_CODES L3
23: WHERE LY.LOOKUP_TYPE = 'YES_NO'
24: AND LY.LOOKUP_CODE = 'Y'
25: AND LN.LOOKUP_TYPE = 'YES_NO'
26: AND LN.LOOKUP_CODE = 'N'

Line 165: AP_LOOKUP_CODES

161: SELECT
162: DISPLAYED_FIELD
163: INTO C_IMPORT_OPTIONS
164: FROM
165: AP_LOOKUP_CODES
166: WHERE LOOKUP_TYPE = 'AP_IMPORT_OPTIONS'
167: AND LOOKUP_CODE = P_WHAT_TO_IMPORT;
168: IF P_PRINT_EXCEPTIONS = 'Y' THEN
169: C_PRINT_EXCEPTIONS := C_NLS_YES;