[Home] [Help]
187: raise fnd_api.g_exc_unexpected_error;
188: end if;
189:
190: -- need to adjust the data required field
191: update wip_requirement_operations wro
192: set wro.date_required = (select nvl(max(wo.first_unit_start_date),l_startDate)
193: from wip_operations wo
194: where wo.organization_id = wro.organization_id
195: and wo.wip_entity_id = wro.wip_entity_id
297: l_usePhantomRouting number;
298: cursor c_phantoms is
299: select inventory_item_id,
300: -1*operation_seq_num operation_seq_num
301: from wip_requirement_operations
302: where organization_id = p_orgID
303: and wip_entity_id = p_wipEntityID
304: and operation_seq_num < 0
305: and wip_supply_type = wip_constants.phantom;
557: l_bill_present := 0;
558: End;
559:
560: if l_bill_present =1 OR l_bomItemID is null then --Bug#14172844: Deleting from WRO for Non-std jobs, when the bom_reference_id is null
561: delete from wip_requirement_operations
562: where wip_entity_id = p_wipEntityID
563: and organization_id = p_orgID;
564: end if;
565:
629: if ( x_returnStatus <> fnd_api.g_ret_sts_success ) then
630: raise fnd_api.g_exc_unexpected_error;
631: end if;
632:
633: update wip_requirement_operations wro
634: set wro.date_required = (select nvl(max(wo.first_unit_start_date),l_startDate)
635: from wip_operations wo
636: where wo.organization_id = wro.organization_id
637: and wo.wip_entity_id = wro.wip_entity_id
672: where organization_id = p_orgID
673: and wip_entity_id = p_wipEntityID;
674:
675: -- need to adjust the data required field
676: update wip_requirement_operations wro
677: set wro.date_required = (select nvl(max(wo.first_unit_start_date),l_startDate)
678: from wip_operations wo
679: where wo.organization_id = wro.organization_id
680: and wo.wip_entity_id = wro.wip_entity_id