[Home] [Help]
4823: wip_operations wop,
4824: wip_operation_resources wor,
4825: wip_discrete_jobs wdj,
4826: wip_move_txn_interface wmti,
4827: wip_requirement_operations WRO
4828: WHERE wmti.group_id = p_gib.group_id
4829: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
4830: AND wdj.wip_entity_id = wmti.wip_entity_id
4831: AND wdj.organization_id = wmti.organization_id
9451: /*****************************************************************************
9452: * This procedure is equivalent to witoc_update_wro in wiltps5.ppc
9453: * This update statement in this procedure is equivalent to the one in
9454: * WIP_OVERCOMPLETION.update_wip_req_operations. This procedure is used to
9455: * update WIP_REQUIREMENT_OPERATIONS table
9456: ****************************************************************************/
9457: PROCEDURE update_wro(p_gib IN group_rec_t,
9458: x_returnStatus OUT NOCOPY VARCHAR2) IS
9459:
9472: p_params => l_params,
9473: x_returnStatus => l_returnStatus);
9474: END IF;
9475:
9476: UPDATE wip_requirement_operations wro
9477: SET (wro.required_quantity,
9478: last_updated_by,
9479: last_update_date,
9480: last_update_login,
9493: DECODE(p_gib.request_id,-1,NULL,p_gib.request_id),
9494: DECODE(p_gib.application_id,-1,NULL,p_gib.application_id),
9495: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
9496: DECODE(p_gib.request_id,-1,NULL,SYSDATE)
9497: FROM wip_requirement_operations wro1,
9498: wip_move_txn_interface wmti1,
9499: wip_move_txn_allocations wma1
9500: WHERE wro1.rowid = wro.rowid
9501: -- The WO rows to be updated are identIFied by the rowids.
9514: = NVL(wro1.repetitive_schedule_id,0)
9515: )
9516: WHERE wro.rowid in
9517: (SELECT wro2.rowid
9518: FROM wip_requirement_operations wro2,
9519: wip_move_txn_interface wmti2,
9520: wip_move_txn_allocations wma2
9521: WHERE wmti2.group_id = p_gib.group_id
9522: AND wmti2.process_phase = WIP_CONSTANTS.MOVE_PROC