DBA Data[Home] [Help]

APPS.WIP_WPS_COMMON dependencies on WIP_OP_RESOURCE_INSTANCES

Line 1688: update wip_op_resource_instances wori

1684: where woru.wip_entity_id = p_wip_entity_id
1685: and woru.operation_seq_num = p_operation_seq_num
1686: and woru.resource_seq_num = p_resource_seq_num;
1687: -- update instances if any
1688: update wip_op_resource_instances wori
1689: set wori.start_date = p_new_start_date,
1690: wori.completion_date = p_new_completion_date,
1691: wori.last_update_date = sysdate
1692: where wori.wip_entity_id = p_wip_entity_id

Line 1717: update wip_op_resource_instances wori

1713: and wor.operation_seq_num = p_operation_seq_num
1714: and wor.schedule_seq_num = l_sched_seq_num
1715: );
1716: -- update instances if any
1717: update wip_op_resource_instances wori
1718: set wori.start_date = wori.start_date + l_offset,
1719: wori.completion_date = wori.completion_date + l_offset,
1720: wori.last_update_date = sysdate
1721: where wori.wip_entity_id = p_wip_entity_id