[Home] [Help]
132: BEGIN
133: IF (p_resource_code IS NOT NULL) THEN
134: SELECT DISTINCT(BR.RESOURCE_ID)
135: INTO x_resource_id
136: FROM BOM_RESOURCES BR, BOM_DEPARTMENT_RESOURCES BDR, AHL_WORKORDER_OPERATIONS_V AWV
137: WHERE BR.RESOURCE_ID = BDR.RESOURCE_ID AND BDR.DEPARTMENT_ID = AWV.DEPARTMENT_ID
138: AND AWV.WORKORDER_ID = p_workorder_id AND BR.RESOURCE_CODE = p_resource_code;
139: END IF;
140:
900:
901: -- Added to fix bug# 6512803.
902: CURSOR get_res_type(p_resource_id IN NUMBER) IS
903: SELECT resource_type
904: FROM BOM_RESOURCES
905: WHERE resource_id = p_resource_id;
906:
907: l_resource_type_code BOM_RESOURCES.resource_type%TYPE;
908:
903: SELECT resource_type
904: FROM BOM_RESOURCES
905: WHERE resource_id = p_resource_id;
906:
907: l_resource_type_code BOM_RESOURCES.resource_type%TYPE;
908:
909: BEGIN
910: --------------------- initialize -----------------------
911: -- Check if API is called in debug mode. If yes, enable debug.
1267: CURSOR c_UOM (x_name IN VARCHAR2) IS
1268: SELECT UOM_CODE
1269: FROM MTL_UNITS_OF_MEASURE
1270: WHERE UNIT_OF_MEASURE = x_name;
1271: -- Get uom from bom resources
1272: CURSOR c_uom_code (x_id IN NUMBER)
1273: IS
1274: SELECT unit_of_measure
1275: FROM bom_resources
1271: -- Get uom from bom resources
1272: CURSOR c_uom_code (x_id IN NUMBER)
1273: IS
1274: SELECT unit_of_measure
1275: FROM bom_resources
1276: WHERE resource_id = x_id;
1277:
1278: --Modified by srini to fix timestamp
1279: --Check to get the timestamp for operation
1303: IS
1304: SELECT
1305: STANDARD_RATE_FLAG, resource_type
1306: FROM
1307: BOM_RESOURCES
1308: WHERE
1309: resource_id = p_resource_id;
1310:
1311: -- Schedule seq number validation
1364: l_workorder_name VARCHAR2(80);
1365: l_default VARCHAR2(10);
1366:
1367: -- Added for bug# 6444617.
1368: l_resource_type bom_resources.resource_type%TYPE;
1369:
1370: BEGIN
1371: --------------------Initialize ----------------------------------
1372: -- Standard Start of API savepoint
2381: SELECT UOM_CODE
2382: FROM MTL_UNITS_OF_MEASURE
2383: WHERE UNIT_OF_MEASURE = x_name;
2384:
2385: -- Get uom from bom resources
2386: CURSOR c_uom_code (x_id IN NUMBER)
2387: IS
2388: SELECT unit_of_measure
2389: FROM bom_resources
2385: -- Get uom from bom resources
2386: CURSOR c_uom_code (x_id IN NUMBER)
2387: IS
2388: SELECT unit_of_measure
2389: FROM bom_resources
2390: WHERE resource_id = x_id;
2391:
2392: --Modified by srini to fix timestamp
2393: --Check to get the timestamp for operation
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;
3315: BOM.UNIT_OF_MEASURE uom_code,
3316: MUOM.UNIT_OF_MEASURE UOM_NAME,
3317: AWO.workorder_id job_id
3318: FROM
3319: BOM_RESOURCES BOM,
3320: MTL_UNITS_OF_MEASURE MUOM,
3321: AHL_OPERATION_RESOURCES AOR,
3322: AHL_WORKORDER_OPERATIONS AWO
3323: WHERE
3594: CURSOR c_chk_assgn (oper_resrc_id IN NUMBER)
3595: IS
3596: SELECT count(*) FROM AHL_WORK_ASSIGNMENTS
3597: WHERE OPERATION_RESOURCE_ID = oper_resrc_id;
3598: -- Get uom from bom resources
3599: CURSOR c_uom_code (x_id IN NUMBER)
3600: IS
3601: SELECT unit_of_measure
3602: FROM bom_resources
3598: -- Get uom from bom resources
3599: CURSOR c_uom_code (x_id IN NUMBER)
3600: IS
3601: SELECT unit_of_measure
3602: FROM bom_resources
3603: WHERE resource_id = x_id;
3604: -- Get cost basis, std rate flag,charge type code
3605: CURSOR c_wip_oper_res (c_wip_entity_id IN NUMBER,
3606: c_oper_seq IN NUMBER,