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;
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
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
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'
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'
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'
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;