APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on MFG_LOOKUPS

Line 24: ( p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,

20: -- PURPOSE
21: -- Converts Lookup Name/Code to ID/Value or Vice versa
22: --------------------------------------------------------------------
23: PROCEDURE Check_Lookup_Name_Or_Id
24: ( p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
25: p_lookup_code IN MFG_LOOKUPS.lookup_code%TYPE,
26: p_meaning IN MFG_LOOKUPS.meaning%TYPE,
27: p_check_id_flag IN VARCHAR2,
28:

Line 25: p_lookup_code IN MFG_LOOKUPS.lookup_code%TYPE,

21: -- Converts Lookup Name/Code to ID/Value or Vice versa
22: --------------------------------------------------------------------
23: PROCEDURE Check_Lookup_Name_Or_Id
24: ( p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
25: p_lookup_code IN MFG_LOOKUPS.lookup_code%TYPE,
26: p_meaning IN MFG_LOOKUPS.meaning%TYPE,
27: p_check_id_flag IN VARCHAR2,
28:
29: x_lookup_code OUT NOCOPY NUMBER,

Line 26: p_meaning IN MFG_LOOKUPS.meaning%TYPE,

22: --------------------------------------------------------------------
23: PROCEDURE Check_Lookup_Name_Or_Id
24: ( p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
25: p_lookup_code IN MFG_LOOKUPS.lookup_code%TYPE,
26: p_meaning IN MFG_LOOKUPS.meaning%TYPE,
27: p_check_id_flag IN VARCHAR2,
28:
29: x_lookup_code OUT NOCOPY NUMBER,
30: x_return_status OUT NOCOPY VARCHAR2)

Line 36: FROM MFG_LOOKUPS

32: BEGIN
33: IF (p_lookup_code IS NOT NULL) THEN
34: IF (p_check_id_flag = 'Y') THEN
35: SELECT lookup_code INTO x_lookup_code
36: FROM MFG_LOOKUPS
37: WHERE lookup_type = p_lookup_type
38: AND lookup_code = p_lookup_code
39: AND SYSDATE BETWEEN start_date_active
40: AND NVL(end_date_active,SYSDATE);

Line 46: FROM MFG_LOOKUPS

42: x_lookup_code := p_lookup_code;
43: END IF;
44: ELSE
45: SELECT lookup_code INTO x_lookup_code
46: FROM MFG_LOOKUPS
47: WHERE lookup_type = p_lookup_type
48: AND meaning = p_meaning
49: AND SYSDATE BETWEEN start_date_active
50: AND NVL(end_date_active,SYSDATE);