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_APXCHECC_XMLP_PKG dependencies on AP_LOOKUP_CODES

Line 53: NLS_ALL 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_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
54: NLS_YES FND_LOOKUPS.MEANING%TYPE;
55: NLS_NO FND_LOOKUPS.MEANING%TYPE;
56: NLS_AMOUNT_DIFFERENCE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
57: NLS_CLEARED_BEFORE_ISSUED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

Line 56: NLS_AMOUNT_DIFFERENCE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

52: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
53: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
54: NLS_YES FND_LOOKUPS.MEANING%TYPE;
55: NLS_NO FND_LOOKUPS.MEANING%TYPE;
56: NLS_AMOUNT_DIFFERENCE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
57: NLS_CLEARED_BEFORE_ISSUED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
58: NLS_VOIDED_AND_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
59: NLS_PAYMENT_NOT_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
60: NLS_CLEAR_DATE_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

Line 57: NLS_CLEARED_BEFORE_ISSUED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

53: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
54: NLS_YES FND_LOOKUPS.MEANING%TYPE;
55: NLS_NO FND_LOOKUPS.MEANING%TYPE;
56: NLS_AMOUNT_DIFFERENCE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
57: NLS_CLEARED_BEFORE_ISSUED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
58: NLS_VOIDED_AND_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
59: NLS_PAYMENT_NOT_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
60: NLS_CLEAR_DATE_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
61: NLS_CLEAR_AMOUNT_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

Line 58: NLS_VOIDED_AND_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

54: NLS_YES FND_LOOKUPS.MEANING%TYPE;
55: NLS_NO FND_LOOKUPS.MEANING%TYPE;
56: NLS_AMOUNT_DIFFERENCE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
57: NLS_CLEARED_BEFORE_ISSUED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
58: NLS_VOIDED_AND_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
59: NLS_PAYMENT_NOT_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
60: NLS_CLEAR_DATE_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
61: NLS_CLEAR_AMOUNT_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
62: NLS_NONE_EP AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

Line 59: NLS_PAYMENT_NOT_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

55: NLS_NO FND_LOOKUPS.MEANING%TYPE;
56: NLS_AMOUNT_DIFFERENCE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
57: NLS_CLEARED_BEFORE_ISSUED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
58: NLS_VOIDED_AND_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
59: NLS_PAYMENT_NOT_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
60: NLS_CLEAR_DATE_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
61: NLS_CLEAR_AMOUNT_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
62: NLS_NONE_EP AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
63: BEGIN

Line 60: NLS_CLEAR_DATE_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

56: NLS_AMOUNT_DIFFERENCE AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
57: NLS_CLEARED_BEFORE_ISSUED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
58: NLS_VOIDED_AND_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
59: NLS_PAYMENT_NOT_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
60: NLS_CLEAR_DATE_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
61: NLS_CLEAR_AMOUNT_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
62: NLS_NONE_EP AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
63: BEGIN
64: NLS_ALL := '';

Line 61: NLS_CLEAR_AMOUNT_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

57: NLS_CLEARED_BEFORE_ISSUED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
58: NLS_VOIDED_AND_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
59: NLS_PAYMENT_NOT_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
60: NLS_CLEAR_DATE_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
61: NLS_CLEAR_AMOUNT_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
62: NLS_NONE_EP AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
63: BEGIN
64: NLS_ALL := '';
65: NLS_YES := '';

Line 62: NLS_NONE_EP AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;

58: NLS_VOIDED_AND_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
59: NLS_PAYMENT_NOT_CLEARED AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
60: NLS_CLEAR_DATE_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
61: NLS_CLEAR_AMOUNT_NULL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
62: NLS_NONE_EP AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
63: BEGIN
64: NLS_ALL := '';
65: NLS_YES := '';
66: NLS_NO := '';

Line 77: AP_LOOKUP_CODES LA,

73: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_NONE_EP
74: FROM
75: FND_LOOKUPS LY,
76: FND_LOOKUPS LN,
77: AP_LOOKUP_CODES LA,
78: AP_LOOKUP_CODES LNEP
79: WHERE LY.LOOKUP_TYPE = 'YES_NO'
80: AND LY.LOOKUP_CODE = 'Y'
81: AND LN.LOOKUP_TYPE = 'YES_NO'

Line 78: AP_LOOKUP_CODES LNEP

74: FROM
75: FND_LOOKUPS LY,
76: FND_LOOKUPS LN,
77: AP_LOOKUP_CODES LA,
78: AP_LOOKUP_CODES LNEP
79: WHERE LY.LOOKUP_TYPE = 'YES_NO'
80: AND LY.LOOKUP_CODE = 'Y'
81: AND LN.LOOKUP_TYPE = 'YES_NO'
82: AND LN.LOOKUP_CODE = 'N'

Line 107: AP_LOOKUP_CODES ALC1,

103: ALC5.DISPLAYED_FIELD,
104: ALC6.DISPLAYED_FIELD
105: INTO NLS_AMOUNT_DIFFERENCE,NLS_CLEARED_BEFORE_ISSUED,NLS_VOIDED_AND_CLEARED,NLS_PAYMENT_NOT_CLEARED,NLS_CLEAR_DATE_NULL,NLS_CLEAR_AMOUNT_NULL
106: FROM
107: AP_LOOKUP_CODES ALC1,
108: AP_LOOKUP_CODES ALC2,
109: AP_LOOKUP_CODES ALC3,
110: AP_LOOKUP_CODES ALC4,
111: AP_LOOKUP_CODES ALC5,

Line 108: AP_LOOKUP_CODES ALC2,

104: ALC6.DISPLAYED_FIELD
105: INTO NLS_AMOUNT_DIFFERENCE,NLS_CLEARED_BEFORE_ISSUED,NLS_VOIDED_AND_CLEARED,NLS_PAYMENT_NOT_CLEARED,NLS_CLEAR_DATE_NULL,NLS_CLEAR_AMOUNT_NULL
106: FROM
107: AP_LOOKUP_CODES ALC1,
108: AP_LOOKUP_CODES ALC2,
109: AP_LOOKUP_CODES ALC3,
110: AP_LOOKUP_CODES ALC4,
111: AP_LOOKUP_CODES ALC5,
112: AP_LOOKUP_CODES ALC6

Line 109: AP_LOOKUP_CODES ALC3,

105: INTO NLS_AMOUNT_DIFFERENCE,NLS_CLEARED_BEFORE_ISSUED,NLS_VOIDED_AND_CLEARED,NLS_PAYMENT_NOT_CLEARED,NLS_CLEAR_DATE_NULL,NLS_CLEAR_AMOUNT_NULL
106: FROM
107: AP_LOOKUP_CODES ALC1,
108: AP_LOOKUP_CODES ALC2,
109: AP_LOOKUP_CODES ALC3,
110: AP_LOOKUP_CODES ALC4,
111: AP_LOOKUP_CODES ALC5,
112: AP_LOOKUP_CODES ALC6
113: WHERE ALC1.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'

Line 110: AP_LOOKUP_CODES ALC4,

106: FROM
107: AP_LOOKUP_CODES ALC1,
108: AP_LOOKUP_CODES ALC2,
109: AP_LOOKUP_CODES ALC3,
110: AP_LOOKUP_CODES ALC4,
111: AP_LOOKUP_CODES ALC5,
112: AP_LOOKUP_CODES ALC6
113: WHERE ALC1.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'
114: AND ALC2.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'

Line 111: AP_LOOKUP_CODES ALC5,

107: AP_LOOKUP_CODES ALC1,
108: AP_LOOKUP_CODES ALC2,
109: AP_LOOKUP_CODES ALC3,
110: AP_LOOKUP_CODES ALC4,
111: AP_LOOKUP_CODES ALC5,
112: AP_LOOKUP_CODES ALC6
113: WHERE ALC1.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'
114: AND ALC2.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'
115: AND ALC3.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'

Line 112: AP_LOOKUP_CODES ALC6

108: AP_LOOKUP_CODES ALC2,
109: AP_LOOKUP_CODES ALC3,
110: AP_LOOKUP_CODES ALC4,
111: AP_LOOKUP_CODES ALC5,
112: AP_LOOKUP_CODES ALC6
113: WHERE ALC1.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'
114: AND ALC2.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'
115: AND ALC3.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'
116: AND ALC4.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'