APPS.WIP_WPS_COMMON dependencies on WSM_COPY_OP_RESOURCES

Line 1824: from wsm_copy_op_resources wcor

1820:
1821: BEGIN
1822: select wcor.reco_start_date, wcor.reco_completion_date
1823: into l_old_start_date, l_old_completion_date
1824: from wsm_copy_op_resources wcor
1825: where wcor.wip_entity_id = p_wip_entity_id
1826: and wcor.operation_seq_num = p_operation_seq_num
1827: and wcor.resource_seq_num = p_resource_seq_num
1828: for update;

Line 1838: from wsm_copy_op_resources wcor

1834:
1835: --yl_debug.dump('Updating op resource...');
1836: select wcor.schedule_seq_num
1837: into l_sched_seq_num
1838: from wsm_copy_op_resources wcor
1839: where wcor.wip_entity_id = p_wip_entity_id
1840: and wcor.operation_seq_num = p_operation_seq_num
1841: and wcor.resource_seq_num = p_resource_seq_num;
1842:

Line 1845: update wsm_copy_op_resources wcor

1841: and wcor.resource_seq_num = p_resource_seq_num;
1842:
1843: if( l_sched_seq_num is null) then
1844: -- update op resource
1845: update wsm_copy_op_resources wcor
1846: set wcor.reco_start_date = p_new_start_date,
1847: wcor.reco_completion_date = p_new_completion_date,
1848: wcor.last_update_date = sysdate
1849: where wcor.wip_entity_id = p_wip_entity_id

Line 1868: update wsm_copy_op_resources wcor

1864: and wcori.resource_seq_num = p_resource_seq_num;
1865: else
1866: l_offset := p_new_start_date - l_old_start_date;
1867: -- update operation resources
1868: update wsm_copy_op_resources wcor
1869: set wcor.reco_start_date = wcor.reco_start_date + l_offset,
1870: wcor.reco_completion_date = wcor.reco_completion_date + l_offset,
1871: wcor.last_update_date = sysdate
1872: where wcor.wip_entity_id = p_wip_entity_id

Line 1882: from wsm_copy_op_resources wcor

1878: where wcoru.wip_entity_id = p_wip_entity_id
1879: and wcoru.operation_seq_num = p_operation_seq_num
1880: and wcoru.resource_seq_num in
1881: ( select wcor.resource_seq_num
1882: from wsm_copy_op_resources wcor
1883: where wcor.wip_entity_id = p_wip_entity_id
1884: and wcor.operation_seq_num = p_operation_seq_num
1885: and wcor.schedule_seq_num = l_sched_seq_num
1886: );

Line 1896: from wsm_copy_op_resources wcor

1892: where wcori.wip_entity_id = p_wip_entity_id
1893: and wcori.operation_seq_num = p_operation_seq_num
1894: and wcori.resource_seq_num in
1895: ( select wcor.resource_seq_num
1896: from wsm_copy_op_resources wcor
1897: where wcor.wip_entity_id = p_wip_entity_id
1898: and wcor.operation_seq_num = p_operation_seq_num
1899: and wcor.schedule_seq_num = l_sched_seq_num
1900: );