DBA Data[Home] [Help]

APPS.WIP_WPS_COMMON dependencies on WSM_COPY_OPERATIONS

Line 1908: from wsm_copy_operations wco

1904: /* check if operation start/completion dates need to be updated also */
1905: /* here asume the first/last unit will be the same ??*/
1906: select wco.reco_start_date, wco.reco_completion_date
1907: into l_old_start_date, l_old_completion_date
1908: from wsm_copy_operations wco
1909: where wco.wip_entity_id = p_wip_entity_id
1910: and wco.operation_seq_num = p_operation_seq_num
1911: for update;
1912:

Line 1928: update wsm_copy_operations wco

1924: else
1925: l_new_completion_date := p_new_completion_date;
1926: end if;
1927:
1928: update wsm_copy_operations wco
1929: set wco.reco_start_date = l_new_start_date,
1930: wco.reco_completion_date = l_new_completion_date,
1931: wco.last_update_date = sysdate
1932: where wco.wip_entity_id = p_wip_entity_id