[Home] [Help]
27:
28: cursor op_attachments(p_org_id number, p_wip_entity_id number) is
29: select wo.operation_seq_num,
30: wo.operation_sequence_id
31: from wip_operations wo
32: where wo.organization_id = p_org_id
33: and wo.wip_entity_id = p_wip_entity_id
34: and exists (select fad.pk1_value
35: from fnd_attached_documents fad
90: wip_update_setup_resources.delete_setup_resources_pub(
91: p_wip_entity_id => p_wipEntityID,
92: p_organization_id => p_orgID);
93:
94: delete from wip_operations
95: where wip_entity_id = p_wipEntityID
96: and organization_id = p_orgID;
97:
98: delete from wip_operation_resources
116: wip_logger.log('exclude ECO is: ' || l_excludeECO, l_retStatus);
117: wip_logger.log('RoutingSeqID is: ' || l_routingSeqID, l_retStatus);
118: end if;
119:
120: insert into wip_operations
121: (wip_entity_id,
122: operation_seq_num,
123: organization_id,
124: repetitive_schedule_id,
247: bos.attribute9, bos.attribute10, bos.attribute11, bos.attribute12, bos.attribute13,
248: bos.attribute14, bos.attribute15, bos.check_skill;
249:
250:
251: update wip_operations wo
252: set previous_operation_seq_num = (select max(operation_seq_num)
253: from wip_operations
254: where wip_entity_id = p_wipEntityID
255: and organization_id = p_orgID
249:
250:
251: update wip_operations wo
252: set previous_operation_seq_num = (select max(operation_seq_num)
253: from wip_operations
254: where wip_entity_id = p_wipEntityID
255: and organization_id = p_orgID
256: and operation_seq_num < wo.operation_seq_num),
257: next_operation_seq_num = (select min(operation_seq_num)
254: where wip_entity_id = p_wipEntityID
255: and organization_id = p_orgID
256: and operation_seq_num < wo.operation_seq_num),
257: next_operation_seq_num = (select min(operation_seq_num)
258: from wip_operations
259: where wip_entity_id = p_wipEntityID
260: and organization_id = p_orgID
261: and operation_seq_num > wo.operation_seq_num)
262: where wo.wip_entity_id = p_wipEntityID
499: bsor.attribute14,
500: bsor.attribute15
501: from bom_resources br,
502: bom_sub_operation_resources bsor,
503: wip_operations wo
504: where wo.organization_id = p_orgID
505: and wo.wip_entity_id = p_wipEntityID
506: and wo.operation_sequence_id = bsor.operation_sequence_id
507: and bsor.resource_id = br.resource_id
549: BOS.STANDARD_OPERATION_ID, BOS.COMPETENCE_ID, BOS.RATING_LEVEL_ID,
550: BOS.QUALIFICATION_TYPE_ID, WO.LAST_UPDATE_DATE, WO.LAST_UPDATED_BY,
551: WO.LAST_UPDATE_LOGIN, WO.CREATED_BY, WO.CREATION_DATE
552: FROM BOM_OPERATION_SKILLS BOS,
553: WIP_OPERATIONS WO,
554: WIP_ENTITIES WE
555: WHERE
556: WE.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
557: AND WO.ORGANIZATION_ID = WO.ORGANIZATION_ID
722:
723: begin
724: select nvl(min(operation_seq_num), 1)
725: into l_minOp
726: from wip_operations
727: where wip_entity_id = p_wipEntityID;
728: exception
729: when others then
730: l_minOp := 1;
736: -- routing to create the job so the op exploded might not exists. In that case, we will assign this component
737: -- to the first operation
738: begin
739: select 1 into l_exists
740: from wip_operations
741: where wip_entity_id = p_wipEntityID
742: and operation_seq_num = l_compTbl(l_count).operation_seq_num;
743: l_opSeq := l_compTbl(l_count).operation_seq_num;
744: exception
773: else
774: l_multipleFactor := p_qty ;
775: end if;
776:
777: /* Moved This fix inside exception block of SQL on wip_operations.
778: /* Fix for bug 4703486. If no rtg exists, Op pull components should become Assy Pull
779: if (l_opSeq = 1 AND l_compTbl(l_count).wip_supply_type = WIP_CONSTANTS.OP_PULL) then
780: l_compTbl(l_count).wip_supply_type := WIP_CONSTANTS.ASSY_PULL;
781: end if;
941: decode(nvl(max(wo.count_point_type), 0),
942: wip_constants.no_manual, wip_constants.op_pull,
943: wro.wip_supply_type),
944: wro.wip_supply_type)
945: from wip_operations wo
946: where wo.organization_id = wro.organization_id
947: and wo.wip_entity_id = wro.wip_entity_id
948: and nvl(wo.repetitive_schedule_id, -1) = nvl(wro.repetitive_schedule_id, -1)
949: and wo.operation_seq_num = abs(wro.operation_seq_num)),
1119:
1120: if ( l_jobStatus <> wip_constants.unreleased ) then
1121: select nvl(min(operation_seq_num), fnd_api.g_miss_num)
1122: into l_minOp
1123: from wip_operations
1124: where organization_id = p_orgID
1125: and wip_entity_id = p_wipEntityID;
1126:
1127: if ( l_minOp = fnd_api.g_miss_num ) then
1142: end if;
1143: return;
1144: end if;
1145:
1146: update wip_operations
1147: set quantity_in_queue = quantity_in_queue - (scheduled_quantity - p_qty)
1148: where organization_id = p_orgID
1149: and wip_entity_id = p_wipEntityID
1150: and operation_seq_num = l_minOp /* Fix for Bug 6639146 */
1166: Also, the SQL for quantity_in_queue = 0, is split into 2.
1167: 1. Released jobs that have First Operation complete (quantity_completed+quantity_running+quantity_in_queue) > 0
1168: 2. Unreleased job is just now released with Start quantity change. Thus no quantity in any step of the operation
1169: (quantity_completed+quantity_running+quantity_in_queue) = 0*/
1170: update wip_operations
1171: set quantity_in_queue = CASE WHEN p_qty -(quantity_completed+quantity_running+quantity_in_queue) <0 THEN 0
1172: ELSE p_qty -(quantity_completed+quantity_running+quantity_in_queue) END --Bug#13655641- Qty_in_queue cannot be less than 0
1173: where organization_id = p_orgID
1174: and wip_entity_id = p_wipEntityID
1180: if SQL%FOUND then
1181: l_updateFlag :=1;
1182: end if;
1183:
1184: update wip_operations
1185: set quantity_in_queue = p_qty
1186: where organization_id = p_orgID
1187: and wip_entity_id = p_wipEntityID
1188: and operation_seq_num = l_minOp
1200: end if;
1201:
1202: end if;
1203:
1204: update wip_operations
1205: set scheduled_quantity = p_qty
1206: where organization_id = p_orgID
1207: and wip_entity_id = p_wipEntityID;
1208: