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.

[Home] [Help]

APPS.AHL_RM_ROUTE_UTIL dependencies on MFG_LOOKUPS

Line 2226: -- Procedure to validate MFG Lookups

2222: RETURN;
2223:
2224: END validate_pt_zone_subzone;
2225:
2226: -- Procedure to validate MFG Lookups
2227: PROCEDURE validate_mfg_lookup
2228: (
2229: x_return_status OUT NOCOPY VARCHAR2,
2230: x_msg_data OUT NOCOPY VARCHAR2,

Line 2231: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,

2227: PROCEDURE validate_mfg_lookup
2228: (
2229: x_return_status OUT NOCOPY VARCHAR2,
2230: x_msg_data OUT NOCOPY VARCHAR2,
2231: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
2232: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,
2233: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
2234: )
2235: IS

Line 2232: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,

2228: (
2229: x_return_status OUT NOCOPY VARCHAR2,
2230: x_msg_data OUT NOCOPY VARCHAR2,
2231: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
2232: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,
2233: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
2234: )
2235: IS
2236:

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

2229: x_return_status OUT NOCOPY VARCHAR2,
2230: x_msg_data OUT NOCOPY VARCHAR2,
2231: p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
2232: p_lookup_meaning IN MFG_LOOKUPS.meaning%TYPE,
2233: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
2234: )
2235: IS
2236:
2237: l_lookup_code MFG_LOOKUPS.lookup_code%TYPE;

Line 2237: l_lookup_code MFG_LOOKUPS.lookup_code%TYPE;

2233: p_x_lookup_code IN OUT NOCOPY MFG_LOOKUPS.lookup_code%TYPE
2234: )
2235: IS
2236:
2237: l_lookup_code MFG_LOOKUPS.lookup_code%TYPE;
2238: l_sp_cursor_use VARCHAR2(5) := 'N';
2239:
2240: CURSOR get_rec_from_value_sp ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,
2241: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE ,

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

2236:
2237: l_lookup_code MFG_LOOKUPS.lookup_code%TYPE;
2238: l_sp_cursor_use VARCHAR2(5) := 'N';
2239:
2240: CURSOR get_rec_from_value_sp ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,
2241: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE ,
2242: c_lookup_code_1 NUMBER ,
2243: c_lookup_code_2 NUMBER)
2244: IS

Line 2241: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE ,

2237: l_lookup_code MFG_LOOKUPS.lookup_code%TYPE;
2238: l_sp_cursor_use VARCHAR2(5) := 'N';
2239:
2240: CURSOR get_rec_from_value_sp ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,
2241: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE ,
2242: c_lookup_code_1 NUMBER ,
2243: c_lookup_code_2 NUMBER)
2244: IS
2245: SELECT DISTINCT lookup_code

Line 2246: FROM MFG_LOOKUPS

2242: c_lookup_code_1 NUMBER ,
2243: c_lookup_code_2 NUMBER)
2244: IS
2245: SELECT DISTINCT lookup_code
2246: FROM MFG_LOOKUPS
2247: WHERE lookup_type = c_lookup_type
2248: AND UPPER(meaning) = UPPER(c_lookup_meaning)
2249: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2250: NVL( end_date_active, SYSDATE )

Line 2259: FROM MFG_LOOKUPS

2255: c_lookup_code_1 NUMBER ,
2256: c_lookup_code_2 NUMBER)
2257: IS
2258: SELECT DISTINCT lookup_code
2259: FROM MFG_LOOKUPS
2260: WHERE lookup_type = c_lookup_type
2261: AND lookup_code = c_lookup_code
2262: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2263: NVL( end_date_active, SYSDATE )

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

2262: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2263: NVL( end_date_active, SYSDATE )
2264: AND LOOKUP_CODE IN (c_lookup_code_1, c_lookup_code_2);
2265:
2266: CURSOR get_rec_from_value ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,
2267: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE )
2268: IS
2269: SELECT DISTINCT lookup_code
2270: FROM MFG_LOOKUPS

Line 2267: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE )

2263: NVL( end_date_active, SYSDATE )
2264: AND LOOKUP_CODE IN (c_lookup_code_1, c_lookup_code_2);
2265:
2266: CURSOR get_rec_from_value ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,
2267: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE )
2268: IS
2269: SELECT DISTINCT lookup_code
2270: FROM MFG_LOOKUPS
2271: WHERE lookup_type = c_lookup_type

Line 2270: FROM MFG_LOOKUPS

2266: CURSOR get_rec_from_value ( c_lookup_type MFG_LOOKUPS.lookup_type%TYPE,
2267: c_lookup_meaning MFG_LOOKUPS.meaning%TYPE )
2268: IS
2269: SELECT DISTINCT lookup_code
2270: FROM MFG_LOOKUPS
2271: WHERE lookup_type = c_lookup_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 );

Line 2280: FROM MFG_LOOKUPS

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
2282: AND lookup_code = c_lookup_code
2283: AND SYSDATE BETWEEN NVL( start_date_active, SYSDATE ) AND
2284: NVL( end_date_active, SYSDATE );

Line 2387: x_msg_data := 'AHL_COM_TOO_MANY_MFG_LOOKUPS';

2383: ELSIF ( get_rec_from_value_sp%ROWCOUNT = 1 ) THEN
2384: p_x_lookup_code := l_lookup_code;
2385: ELSE
2386: x_return_status := FND_API.G_RET_STS_ERROR;
2387: x_msg_data := 'AHL_COM_TOO_MANY_MFG_LOOKUPS';
2388: END IF;
2389:
2390: CLOSE get_rec_from_value_sp;
2391: RETURN;

Line 2413: x_msg_data := 'AHL_COM_TOO_MANY_MFG_LOOKUPS';

2409: ELSIF ( get_rec_from_value%ROWCOUNT = 1 ) THEN
2410: p_x_lookup_code := l_lookup_code;
2411: ELSE
2412: x_return_status := FND_API.G_RET_STS_ERROR;
2413: x_msg_data := 'AHL_COM_TOO_MANY_MFG_LOOKUPS';
2414: END IF;
2415:
2416: CLOSE get_rec_from_value;
2417: RETURN;