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 121: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,

117: AND ( (lookup_type <> 'ITEM_TYPE') OR (lookup_type = 'ITEM_TYPE' AND view_application_id in (0,3)))
118: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
119: NVL( end_date_active, SYSDATE );
120:
121: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
122: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
123: IS
124: SELECT DISTINCT lookup_code
125: FROM FND_LOOKUP_VALUES_VL

Line 122: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )

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

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

2381: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2382: NVL( end_date_active, SYSDATE )
2383: AND LOOKUP_CODE IN (c_lookup_code_1, c_lookup_code_2);
2384:
2385: CURSOR get_rec_from_id_sp ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
2386: c_lookup_code FND_LOOKUPS.lookup_code%TYPE ,
2387: c_lookup_code_1 NUMBER ,
2388: c_lookup_code_2 NUMBER)
2389: IS

Line 2386: c_lookup_code FND_LOOKUPS.lookup_code%TYPE ,

2382: NVL( end_date_active, SYSDATE )
2383: AND LOOKUP_CODE IN (c_lookup_code_1, c_lookup_code_2);
2384:
2385: CURSOR get_rec_from_id_sp ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
2386: c_lookup_code FND_LOOKUPS.lookup_code%TYPE ,
2387: c_lookup_code_1 NUMBER ,
2388: c_lookup_code_2 NUMBER)
2389: IS
2390: SELECT DISTINCT lookup_code

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

2404: AND UPPER(meaning) = UPPER(c_lookup_meaning)
2405: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2406: NVL( end_date_active, SYSDATE );
2407:
2408: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
2409: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
2410: IS
2411: SELECT DISTINCT lookup_code
2412: FROM MFG_LOOKUPS

Line 2409: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )

2405: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2406: NVL( end_date_active, SYSDATE );
2407:
2408: CURSOR get_rec_from_id ( c_lookup_type FND_LOOKUPS.lookup_type%TYPE,
2409: c_lookup_code FND_LOOKUPS.lookup_code%TYPE )
2410: IS
2411: SELECT DISTINCT lookup_code
2412: FROM MFG_LOOKUPS
2413: WHERE lookup_type = c_lookup_type