[Home] [Help]
4694: wip_operations wop,
4695: wip_operation_resources wor,
4696: wip_discrete_jobs wdj,
4697: wip_move_txn_interface wmti,
4698: wip_requirement_operations WRO
4699: WHERE wmti.group_id = p_gib.group_id
4700: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
4701: AND wdj.wip_entity_id = wmti.wip_entity_id
4702: AND wdj.organization_id = wmti.organization_id
9178: /*****************************************************************************
9179: * This procedure is equivalent to witoc_update_wro in wiltps5.ppc
9180: * This update statement in this procedure is equivalent to the one in
9181: * WIP_OVERCOMPLETION.update_wip_req_operations. This procedure is used to
9182: * update WIP_REQUIREMENT_OPERATIONS table
9183: ****************************************************************************/
9184: PROCEDURE update_wro(p_gib IN group_rec_t,
9185: x_returnStatus OUT NOCOPY VARCHAR2) IS
9186:
9199: p_params => l_params,
9200: x_returnStatus => l_returnStatus);
9201: END IF;
9202:
9203: UPDATE wip_requirement_operations wro
9204: SET (wro.required_quantity,
9205: last_updated_by,
9206: last_update_date,
9207: last_update_login,
9220: DECODE(p_gib.request_id,-1,NULL,p_gib.request_id),
9221: DECODE(p_gib.application_id,-1,NULL,p_gib.application_id),
9222: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
9223: DECODE(p_gib.request_id,-1,NULL,SYSDATE)
9224: FROM wip_requirement_operations wro1,
9225: wip_move_txn_interface wmti1,
9226: wip_move_txn_allocations wma1
9227: WHERE wro1.rowid = wro.rowid
9228: -- The WO rows to be updated are identIFied by the rowids.
9241: = NVL(wro1.repetitive_schedule_id,0)
9242: )
9243: WHERE wro.rowid in
9244: (SELECT wro2.rowid
9245: FROM wip_requirement_operations wro2,
9246: wip_move_txn_interface wmti2,
9247: wip_move_txn_allocations wma2
9248: WHERE wmti2.group_id = p_gib.group_id
9249: AND wmti2.process_phase = WIP_CONSTANTS.MOVE_PROC