DBA Data[Home] [Help]

APPS.WIP_WPS_COMMON dependencies on WSM_COPY_OP_RESOURCE_INSTANCES

Line 1858: update wsm_copy_op_resource_instances wcori

1854: where wcoru.wip_entity_id = p_wip_entity_id
1855: and wcoru.operation_seq_num = p_operation_seq_num
1856: and wcoru.resource_seq_num = p_resource_seq_num;
1857: -- update instances if any
1858: update wsm_copy_op_resource_instances wcori
1859: set wcori.start_date = p_new_start_date,
1860: wcori.completion_date = p_new_completion_date,
1861: wcori.last_update_date = sysdate
1862: where wcori.wip_entity_id = p_wip_entity_id

Line 1888: update wsm_copy_op_resource_instances wcori

1884: and wcor.operation_seq_num = p_operation_seq_num
1885: and wcor.schedule_seq_num = l_sched_seq_num
1886: );
1887: /* update instances if have any */
1888: update wsm_copy_op_resource_instances wcori
1889: set wcori.start_date = wcori.start_date + l_offset,
1890: wcori.completion_date = wcori.completion_date + l_offset,
1891: wcori.last_update_date = sysdate
1892: where wcori.wip_entity_id = p_wip_entity_id