DBA Data[Home] [Help]

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 1540: FROM MFG_LOOKUPS

1536: IF (l_Resrc_Require_Rec.STD_RATE_FLAG_CODE IS NOT NULL AND
1537: l_Resrc_Require_Rec.STD_RATE_FLAG_CODE <> Fnd_Api.G_MISS_NUM) THEN
1538: SELECT meaning
1539: INTO l_std_rate_flag
1540: FROM MFG_LOOKUPS
1541: WHERE lookup_code = l_Resrc_Require_Rec.STD_RATE_FLAG_CODE
1542: AND LOOKUP_TYPE = 'BOM_NO_YES';
1543: END IF;
1544:

Line 2588: FROM MFG_LOOKUPS

2584: IF (l_Resrc_Require_Rec.STD_RATE_FLAG_CODE IS NOT NULL AND
2585: l_Resrc_Require_Rec.STD_RATE_FLAG_CODE <> Fnd_Api.G_MISS_NUM) THEN
2586: SELECT meaning
2587: INTO l_std_rate_flag
2588: FROM MFG_LOOKUPS
2589: WHERE lookup_code = l_Resrc_Require_Rec.STD_RATE_FLAG_CODE
2590: AND LOOKUP_TYPE = 'BOM_NO_YES';
2591: END IF;
2592:

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

3030: c_resrc_req c_res_req%ROWTYPE;
3031:
3032: CURSOR c_resource (x_id IN NUMBER) IS
3033: SELECT ML.MEANING, BR.RESOURCE_TYPE, BR.RESOURCE_CODE
3034: FROM BOM_RESOURCES BR, MFG_LOOKUPS ML, AHL_OPERATION_RESOURCES AOR
3035: WHERE BR.RESOURCE_TYPE = ML.LOOKUP_CODE
3036: AND ML.LOOKUP_TYPE= 'BOM_RESOURCE_TYPE'
3037: AND AOR.RESOURCE_ID = BR.RESOURCE_ID
3038: AND AOR.OPERATION_RESOURCE_ID = x_id;

Line 3088: FROM MFG_LOOKUPS

3084: c_require_rec c_require%ROWTYPE;
3085:
3086: CURSOR c_lookups (x_lookup_type IN VARCHAR2, x_lookup_code IN VARCHAR2) IS
3087: SELECT meaning
3088: FROM MFG_LOOKUPS
3089: WHERE lookup_type = x_lookup_type
3090: AND lookup_code = x_lookup_code
3091: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
3092: AND TRUNC(NVL(end_date_active,SYSDATE));

Line 3170: FROM MFG_LOOKUPS

3166: -- To find meaning for fnd_lookups code
3167: IF (c_WIP_oper_rec.STANDARD_RATE_FLAG IS NOT NULL) THEN
3168: SELECT meaning
3169: INTO l_std_rate_flag
3170: FROM MFG_LOOKUPS
3171: WHERE lookup_code = c_WIP_oper_rec.STANDARD_RATE_FLAG
3172: AND LOOKUP_TYPE = 'BOM_NO_YES';
3173: END IF;
3174: