[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:
887:
888: -- Added to fix bug# 6512803.
889: CURSOR get_res_type(p_resource_id IN NUMBER) IS
890: SELECT resource_type
891: FROM BOM_RESOURCES
892: WHERE resource_id = p_resource_id;
893:
894: l_resource_type_code BOM_RESOURCES.resource_type%TYPE;
895:
890: SELECT resource_type
891: FROM BOM_RESOURCES
892: WHERE resource_id = p_resource_id;
893:
894: l_resource_type_code BOM_RESOURCES.resource_type%TYPE;
895:
896: BEGIN
897: --------------------- initialize -----------------------
898: -- Check if API is called in debug mode. If yes, enable debug.
1089: CURSOR c_UOM (x_name IN VARCHAR2) IS
1090: SELECT UOM_CODE
1091: FROM MTL_UNITS_OF_MEASURE
1092: WHERE UNIT_OF_MEASURE = x_name;
1093: -- Get uom from bom resources
1094: CURSOR c_uom_code (x_id IN NUMBER)
1095: IS
1096: SELECT unit_of_measure
1097: FROM bom_resources
1093: -- Get uom from bom resources
1094: CURSOR c_uom_code (x_id IN NUMBER)
1095: IS
1096: SELECT unit_of_measure
1097: FROM bom_resources
1098: WHERE resource_id = x_id;
1099:
1100: --Modified by srini to fix timestamp
1101: --Check to get the timestamp for operation
1125: IS
1126: SELECT
1127: STANDARD_RATE_FLAG, resource_type
1128: FROM
1129: BOM_RESOURCES
1130: WHERE
1131: resource_id = p_resource_id;
1132:
1133: -- Schedule seq number validation
1186: l_workorder_name VARCHAR2(80);
1187: l_default VARCHAR2(10);
1188:
1189: -- Added for bug# 6444617.
1190: l_resource_type bom_resources.resource_type%TYPE;
1191:
1192: BEGIN
1193: --------------------Initialize ----------------------------------
1194: -- Standard Start of API savepoint
2183: SELECT UOM_CODE
2184: FROM MTL_UNITS_OF_MEASURE
2185: WHERE UNIT_OF_MEASURE = x_name;
2186:
2187: -- Get uom from bom resources
2188: CURSOR c_uom_code (x_id IN NUMBER)
2189: IS
2190: SELECT unit_of_measure
2191: FROM bom_resources
2187: -- Get uom from bom resources
2188: CURSOR c_uom_code (x_id IN NUMBER)
2189: IS
2190: SELECT unit_of_measure
2191: FROM bom_resources
2192: WHERE resource_id = x_id;
2193:
2194: --Modified by srini to fix timestamp
2195: --Check to get the timestamp for operation
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;
3070: BOM.UNIT_OF_MEASURE uom_code,
3071: MUOM.UNIT_OF_MEASURE UOM_NAME,
3072: AWO.workorder_id job_id
3073: FROM
3074: BOM_RESOURCES BOM,
3075: MTL_UNITS_OF_MEASURE MUOM,
3076: AHL_OPERATION_RESOURCES AOR,
3077: AHL_WORKORDER_OPERATIONS AWO
3078: WHERE
3349: CURSOR c_chk_assgn (oper_resrc_id IN NUMBER)
3350: IS
3351: SELECT count(*) FROM AHL_WORK_ASSIGNMENTS
3352: WHERE OPERATION_RESOURCE_ID = oper_resrc_id;
3353: -- Get uom from bom resources
3354: CURSOR c_uom_code (x_id IN NUMBER)
3355: IS
3356: SELECT unit_of_measure
3357: FROM bom_resources
3353: -- Get uom from bom resources
3354: CURSOR c_uom_code (x_id IN NUMBER)
3355: IS
3356: SELECT unit_of_measure
3357: FROM bom_resources
3358: WHERE resource_id = x_id;
3359: -- Get cost basis, std rate flag,charge type code
3360: CURSOR c_wip_oper_res (c_wip_entity_id IN NUMBER,
3361: c_oper_seq IN NUMBER,