eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_APXSUIMP_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 4: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

1: PACKAGE BODY AP_APXSUIMP_XMLP_PKG AS
2: /* $Header: APXSUIMPB.pls 120.0 2007/12/27 08:33:20 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_APXSUIMP_XMLP_PKG AS
2: /* $Header: APXSUIMPB.pls 120.0 2007/12/27 08:33:20 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: l_dummy number;

Line 6: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

2: /* $Header: APXSUIMPB.pls 120.0 2007/12/27 08:33:20 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: l_dummy number;
10: BEGIN

Line 21: AP_LOOKUP_CODES L1,

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

Line 22: AP_LOOKUP_CODES L2,

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

Line 23: AP_LOOKUP_CODES L3

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

Line 167: AP_LOOKUP_CODES

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