APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on MFG_LOOKUPS

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

27: -- PURPOSE
28: -- Converts Lookup Name/Code to ID/Value or Vice versa
29: --------------------------------------------------------------------
30: PROCEDURE Check_Lookup_Name_Or_Id
31: ( p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
32: p_lookup_code IN MFG_LOOKUPS.lookup_code%TYPE,
33: p_meaning IN MFG_LOOKUPS.meaning%TYPE,
34: p_check_id_flag IN VARCHAR2,
35:

Line 32: p_lookup_code IN MFG_LOOKUPS.lookup_code%TYPE,

28: -- Converts Lookup Name/Code to ID/Value or Vice versa
29: --------------------------------------------------------------------
30: PROCEDURE Check_Lookup_Name_Or_Id
31: ( p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
32: p_lookup_code IN MFG_LOOKUPS.lookup_code%TYPE,
33: p_meaning IN MFG_LOOKUPS.meaning%TYPE,
34: p_check_id_flag IN VARCHAR2,
35:
36: x_lookup_code OUT NOCOPY NUMBER,

Line 33: p_meaning IN MFG_LOOKUPS.meaning%TYPE,

29: --------------------------------------------------------------------
30: PROCEDURE Check_Lookup_Name_Or_Id
31: ( p_lookup_type IN MFG_LOOKUPS.lookup_type%TYPE,
32: p_lookup_code IN MFG_LOOKUPS.lookup_code%TYPE,
33: p_meaning IN MFG_LOOKUPS.meaning%TYPE,
34: p_check_id_flag IN VARCHAR2,
35:
36: x_lookup_code OUT NOCOPY NUMBER,
37: x_return_status OUT NOCOPY VARCHAR2)

Line 43: FROM MFG_LOOKUPS

39: BEGIN
40: IF (p_lookup_code IS NOT NULL) THEN
41: IF (p_check_id_flag = 'Y') THEN
42: SELECT lookup_code INTO x_lookup_code
43: FROM MFG_LOOKUPS
44: WHERE lookup_type = p_lookup_type
45: AND lookup_code = p_lookup_code
46: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
47: AND TRUNC(NVL(end_date_active,SYSDATE));

Line 53: FROM MFG_LOOKUPS

49: x_lookup_code := p_lookup_code;
50: END IF;
51: ELSE
52: SELECT lookup_code INTO x_lookup_code
53: FROM MFG_LOOKUPS
54: WHERE lookup_type = p_lookup_type
55: AND meaning = p_meaning
56: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
57: AND TRUNC(NVL(end_date_active,SYSDATE));

Line 1731: FROM MFG_LOOKUPS

1727: IF (l_Resrc_Require_Rec.STD_RATE_FLAG_CODE IS NOT NULL AND
1728: l_Resrc_Require_Rec.STD_RATE_FLAG_CODE <> Fnd_Api.G_MISS_NUM) THEN
1729: SELECT meaning
1730: INTO l_std_rate_flag
1731: FROM MFG_LOOKUPS
1732: WHERE lookup_code = l_Resrc_Require_Rec.STD_RATE_FLAG_CODE
1733: AND LOOKUP_TYPE = 'BOM_NO_YES';
1734: END IF;
1735:

Line 2805: FROM MFG_LOOKUPS

2801: IF (l_Resrc_Require_Rec.STD_RATE_FLAG_CODE IS NOT NULL AND
2802: l_Resrc_Require_Rec.STD_RATE_FLAG_CODE <> Fnd_Api.G_MISS_NUM) THEN
2803: SELECT meaning
2804: INTO l_std_rate_flag
2805: FROM MFG_LOOKUPS
2806: WHERE lookup_code = l_Resrc_Require_Rec.STD_RATE_FLAG_CODE
2807: AND LOOKUP_TYPE = 'BOM_NO_YES';
2808: END IF;
2809:

Line 3279: FROM BOM_RESOURCES BR, MFG_LOOKUPS ML, AHL_OPERATION_RESOURCES AOR

3275: c_resrc_req c_res_req%ROWTYPE;
3276:
3277: CURSOR c_resource (x_id IN NUMBER) IS
3278: SELECT ML.MEANING, BR.RESOURCE_TYPE, BR.RESOURCE_CODE
3279: FROM BOM_RESOURCES BR, MFG_LOOKUPS ML, AHL_OPERATION_RESOURCES AOR
3280: WHERE BR.RESOURCE_TYPE = ML.LOOKUP_CODE
3281: AND ML.LOOKUP_TYPE= 'BOM_RESOURCE_TYPE'
3282: AND AOR.RESOURCE_ID = BR.RESOURCE_ID
3283: AND AOR.OPERATION_RESOURCE_ID = x_id;

Line 3333: FROM MFG_LOOKUPS

3329: c_require_rec c_require%ROWTYPE;
3330:
3331: CURSOR c_lookups (x_lookup_type IN VARCHAR2, x_lookup_code IN VARCHAR2) IS
3332: SELECT meaning
3333: FROM MFG_LOOKUPS
3334: WHERE lookup_type = x_lookup_type
3335: AND lookup_code = x_lookup_code
3336: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
3337: AND TRUNC(NVL(end_date_active,SYSDATE));

Line 3415: FROM MFG_LOOKUPS

3411: -- To find meaning for fnd_lookups code
3412: IF (c_WIP_oper_rec.STANDARD_RATE_FLAG IS NOT NULL) THEN
3413: SELECT meaning
3414: INTO l_std_rate_flag
3415: FROM MFG_LOOKUPS
3416: WHERE lookup_code = c_WIP_oper_rec.STANDARD_RATE_FLAG
3417: AND LOOKUP_TYPE = 'BOM_NO_YES';
3418: END IF;
3419: