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 MFG_LOOKUPS

Line 2358: -- Procedure to validate MFG Lookups

2354: RETURN;
2355:
2356: END validate_pt_zone_subzone;
2357:
2358: -- Procedure to validate MFG Lookups
2359: PROCEDURE validate_mfg_lookup
2360: (
2361: x_return_status OUT NOCOPY VARCHAR2,
2362: x_msg_data OUT NOCOPY VARCHAR2,

Line 2363: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,

2359: PROCEDURE validate_mfg_lookup
2360: (
2361: x_return_status OUT NOCOPY VARCHAR2,
2362: x_msg_data OUT NOCOPY VARCHAR2,
2363: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
2364: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,
2365: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
2366: )
2367: IS

Line 2364: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,

2360: (
2361: x_return_status OUT NOCOPY VARCHAR2,
2362: x_msg_data OUT NOCOPY VARCHAR2,
2363: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
2364: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,
2365: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
2366: )
2367: IS
2368:

Line 2365: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE

2361: x_return_status OUT NOCOPY VARCHAR2,
2362: x_msg_data OUT NOCOPY VARCHAR2,
2363: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
2364: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,
2365: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
2366: )
2367: IS
2368:
2369: l_lookup_code MFG_LOOKUPS.lookup_code%TYPE;

Line 2369: l_lookup_code MFG_LOOKUPS.lookup_code%TYPE;

2365: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
2366: )
2367: IS
2368:
2369: l_lookup_code MFG_LOOKUPS.lookup_code%TYPE;
2370: l_sp_cursor_use VARCHAR2(5) := 'N';
2371:
2372: CURSOR get_rec_from_value_sp ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,
2373: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE ,

Line 2372: CURSOR get_rec_from_value_sp ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,

2368:
2369: l_lookup_code MFG_LOOKUPS.lookup_code%TYPE;
2370: l_sp_cursor_use VARCHAR2(5) := 'N';
2371:
2372: CURSOR get_rec_from_value_sp ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,
2373: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE ,
2374: c_lookup_code_1 NUMBER ,
2375: c_lookup_code_2 NUMBER)
2376: IS

Line 2373: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE ,

2369: l_lookup_code MFG_LOOKUPS.lookup_code%TYPE;
2370: l_sp_cursor_use VARCHAR2(5) := 'N';
2371:
2372: CURSOR get_rec_from_value_sp ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,
2373: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE ,
2374: c_lookup_code_1 NUMBER ,
2375: c_lookup_code_2 NUMBER)
2376: IS
2377: SELECT DISTINCT lookup_code

Line 2378: FROM MFG_LOOKUPS

2374: c_lookup_code_1 NUMBER ,
2375: c_lookup_code_2 NUMBER)
2376: IS
2377: SELECT DISTINCT lookup_code
2378: FROM MFG_LOOKUPS
2379: WHERE lookup_type = c_lookup_type
2380: AND UPPER(meaning) = UPPER(c_lookup_meaning)
2381: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2382: NVL( end_date_active, SYSDATE )

Line 2391: FROM MFG_LOOKUPS

2387: c_lookup_code_1 NUMBER ,
2388: c_lookup_code_2 NUMBER)
2389: IS
2390: SELECT DISTINCT lookup_code
2391: FROM MFG_LOOKUPS
2392: WHERE lookup_type = c_lookup_type
2393: AND lookup_code = c_lookup_code
2394: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2395: NVL( end_date_active, SYSDATE )

Line 2398: CURSOR get_rec_from_value ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,

2394: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2395: NVL( end_date_active, SYSDATE )
2396: AND LOOKUP_CODE IN (c_lookup_code_1, c_lookup_code_2);
2397:
2398: CURSOR get_rec_from_value ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,
2399: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE )
2400: IS
2401: SELECT DISTINCT lookup_code
2402: FROM MFG_LOOKUPS

Line 2399: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE )

2395: NVL( end_date_active, SYSDATE )
2396: AND LOOKUP_CODE IN (c_lookup_code_1, c_lookup_code_2);
2397:
2398: CURSOR get_rec_from_value ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,
2399: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE )
2400: IS
2401: SELECT DISTINCT lookup_code
2402: FROM MFG_LOOKUPS
2403: WHERE lookup_type = c_lookup_type

Line 2402: FROM MFG_LOOKUPS

2398: CURSOR get_rec_from_value ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,
2399: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE )
2400: IS
2401: SELECT DISTINCT lookup_code
2402: FROM MFG_LOOKUPS
2403: WHERE lookup_type = c_lookup_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 );

Line 2412: FROM MFG_LOOKUPS

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
2414: AND lookup_code = c_lookup_code
2415: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2416: NVL( end_date_active, SYSDATE );

Line 2519: x_msg_data := 'AHL_COM_TOO_MANY_MFG_LOOKUPS';

2515: ELSIF ( get_rec_from_value_sp%ROWCOUNT = 1 ) THEN
2516: p_x_lookup_code := l_lookup_code;
2517: ELSE
2518: x_return_status := FND_API.G_RET_STS_ERROR;
2519: x_msg_data := 'AHL_COM_TOO_MANY_MFG_LOOKUPS';
2520: END IF;
2521:
2522: CLOSE get_rec_from_value_sp;
2523: RETURN;

Line 2545: x_msg_data := 'AHL_COM_TOO_MANY_MFG_LOOKUPS';

2541: ELSIF ( get_rec_from_value%ROWCOUNT = 1 ) THEN
2542: p_x_lookup_code := l_lookup_code;
2543: ELSE
2544: x_return_status := FND_API.G_RET_STS_ERROR;
2545: x_msg_data := 'AHL_COM_TOO_MANY_MFG_LOOKUPS';
2546: END IF;
2547:
2548: CLOSE get_rec_from_value;
2549: RETURN;