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.AHL_RM_ROUTE_UTIL dependencies on FND_LOOKUPS

Line 102: p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,

98: PROCEDURE validate_lookup
99: (
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
103: p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,
104: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
105: )
106: IS

Line 103: p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,

99: (
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
103: p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,
104: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
105: )
106: IS
107:

Line 104: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE

100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
103: p_lookup_meaning IN FND_LOOKUPS.meaning%TYPE,
104: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
105: )
106: IS
107:
108: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;

Line 108: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;

104: p_x_lookup_code IN OUT NOCOPY FND_LOOKUPS.lookup_code%TYPE
105: )
106: IS
107:
108: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;
109:
110: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
111: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )
112: IS

Line 110: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,

106: IS
107:
108: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;
109:
110: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
111: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )
112: IS
113: SELECT DISTINCT lookup_code
114: FROM FND_LOOKUP_VALUES_VL

Line 111: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )

107:
108: l_lookup_code FND_LOOKUPS.lookup_code%TYPE;
109:
110: CURSOR get_rec_from_value ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
111: c_lookup_meaning FND_LOOKUPS.meaning%TYPE )
112: IS
113: SELECT DISTINCT lookup_code
114: FROM FND_LOOKUP_VALUES_VL
115: WHERE lookup_type = c_lookup_type

Line 120: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,

116: AND meaning = c_lookup_meaning
117: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
118: NVL( end_date_active, SYSDATE );
119:
120: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
121: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
122: IS
123: SELECT DISTINCT lookup_code
124: FROM FND_LOOKUP_VALUES_VL

Line 121: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )

117: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
118: NVL( end_date_active, SYSDATE );
119:
120: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
121: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
122: IS
123: SELECT DISTINCT lookup_code
124: FROM FND_LOOKUP_VALUES_VL
125: WHERE lookup_type = c_lookup_type

Line 2253: CURSOR get_rec_from_id_sp ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,

2249: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2250: NVL( end_date_active, SYSDATE )
2251: AND LOOKUP_CODE IN (c_lookup_code_1, c_lookup_code_2);
2252:
2253: CURSOR get_rec_from_id_sp ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
2254: c_lookup_code FND_LOOKUPS.lookup_code%TYPE ,
2255: c_lookup_code_1 NUMBER ,
2256: c_lookup_code_2 NUMBER)
2257: IS

Line 2254: c_lookup_code FND_LOOKUPS.lookup_code%TYPE ,

2250: NVL( end_date_active, SYSDATE )
2251: AND LOOKUP_CODE IN (c_lookup_code_1, c_lookup_code_2);
2252:
2253: CURSOR get_rec_from_id_sp ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
2254: c_lookup_code FND_LOOKUPS.lookup_code%TYPE ,
2255: c_lookup_code_1 NUMBER ,
2256: c_lookup_code_2 NUMBER)
2257: IS
2258: SELECT DISTINCT lookup_code

Line 2276: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,

2272: AND UPPER(meaning) = UPPER(c_lookup_meaning)
2273: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2274: NVL( end_date_active, SYSDATE );
2275:
2276: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
2277: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
2278: IS
2279: SELECT DISTINCT lookup_code
2280: FROM MFG_LOOKUPS

Line 2277: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )

2273: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2274: NVL( end_date_active, SYSDATE );
2275:
2276: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
2277: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
2278: IS
2279: SELECT DISTINCT lookup_code
2280: FROM MFG_LOOKUPS
2281: WHERE lookup_type = c_lookup_type