[Home] [Help]
1277: l_retStatus VARCHAR2(1);
1278: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1279: l_params wip_logger.param_tbl_t;
1280:
1281: --standard who columns
1282: l_sysDate DATE := sysdate;
1283: l_userID NUMBER := fnd_global.user_id;
1284: l_loginID NUMBER := fnd_global.login_id;
1285: l_reqID NUMBER := fnd_global.conc_request_id;
1572: set --scheduled_start_date = NVL(l_jobStartDate, scheduled_start_date),
1573: --scheduled_completion_date = NVL(l_jobComplDate, scheduled_completion_date),
1574: scheduled_start_date = l_newJobStartDate,
1575: scheduled_completion_date = l_newJobComplDate,
1576: ----standard who columns----
1577: last_update_date = l_sysdate,
1578: last_updated_by = l_userID,
1579: last_update_login = l_loginID,
1580: request_id = l_reqID,
1598: last_unit_start_date = NVL(l_OpStartDate(i), last_unit_start_date),
1599: first_unit_completion_date = NVL(l_OpEndDate(i), first_unit_completion_date),
1600: last_unit_completion_date = NVL(l_OpEndDate(i), last_unit_completion_date),
1601: scheduled_quantity = l_OpQty(i),
1602: ----standard who columns----
1603: last_update_date = l_sysdate,
1604: last_updated_by = l_userID,
1605: last_update_login = l_loginID,
1606: request_id = l_reqID,
1621: update wsm_copy_operations
1622: set reco_start_date = l_OpStartDate(i),
1623: reco_completion_date = l_OpEndDate(i),
1624: reco_scheduled_quantity = l_OpQty(i),
1625: ----standard who columns----
1626: last_update_date = l_sysdate,
1627: last_updated_by = l_userID,
1628: last_update_login = l_loginID,
1629: request_id = l_reqID,
1643: update wsm_copy_operations
1644: set reco_start_date = l_OpStartDate(l_cnt_wo),
1645: reco_completion_date = l_OpEndDate(l_cnt_wo),
1646: reco_scheduled_quantity = l_OpQty(l_cnt_wo),
1647: ----standard who columns----
1648: last_update_date = l_sysdate,
1649: last_updated_by = l_userID,
1650: last_update_login = l_loginID,
1651: request_id = l_reqID,
1667: --update mtl requirement dates WRO
1668: forall i in 1..l_cnt_wo
1669: update wip_requirement_operations
1670: set date_required = NVL(l_OpStartDate(i), date_required),
1671: ----standard who columns----
1672: last_update_date = l_sysdate,
1673: last_updated_by = l_userID,
1674: last_update_login = l_loginID,
1675: request_id = l_reqID,
1687: --update mtl requirement dates WCRO
1688: forall i in l_cnt_wo+1..p_opTbl.count
1689: update wsm_copy_requirement_ops
1690: set reco_date_required = l_OpStartDate(i),
1691: ----standard who columns----
1692: last_update_date = l_sysdate,
1693: last_updated_by = l_userID,
1694: last_update_login = l_loginID,
1695: request_id = l_reqID,
1707: l_stat_num := 105;
1708: if g_update_current_op and l_cnt_wo is not NULL and l_cnt_wo > 0 then --bug 6345672
1709: update wsm_copy_requirement_ops
1710: set reco_date_required = l_OpStartDate(l_cnt_wo),
1711: ----standard who columns----
1712: last_update_date = l_sysdate,
1713: last_updated_by = l_userID,
1714: last_update_login = l_loginID,
1715: request_id = l_reqID,
1742: forall i in 1..l_cnt_wor
1743: update wip_operation_resources
1744: set start_date = NVL(x_resTbls.startDate(i), start_date),
1745: completion_date = NVL(x_resTbls.endDate(i), completion_date),
1746: ----standard who columns----
1747: last_update_date = l_sysdate,
1748: last_updated_by = l_userID,
1749: last_update_login = l_loginID,
1750: request_id = l_reqID,
1764: forall i in l_cnt_wor+1..x_resTbls.resID.count
1765: update wsm_copy_op_resources
1766: set reco_start_date = x_resTbls.startDate(i),
1767: reco_completion_date = x_resTbls.endDate(i),
1768: ----standard who columns----
1769: last_update_date = l_sysdate,
1770: last_updated_by = l_userID,
1771: last_update_login = l_loginID,
1772: request_id = l_reqID,
1786: if g_update_current_op and l_cnt_wor > 0 and l_cnt_wor is not NULL then --bug 6345672/bug 7163667
1787: update wsm_copy_op_resources
1788: set reco_start_date = x_resTbls.startDate(l_cnt_wor),
1789: reco_completion_date = x_resTbls.endDate(l_cnt_wor),
1790: ----standard who columns----
1791: last_update_date = l_sysdate,
1792: last_updated_by = l_userID,
1793: last_update_login = l_loginID,
1794: request_id = l_reqID,
1812: forall i in 1..l_cnt_wor
1813: update wip_op_resource_instances
1814: set start_date = NVL(x_resTbls.startDate(i), start_date),
1815: completion_date = NVL(x_resTbls.endDate(i), completion_date),
1816: ----standard who columns----
1817: last_update_date = l_sysdate,
1818: last_updated_by = l_userID,
1819: last_update_login = l_loginID
1820: where wip_entity_id = p_wipEntityID
1830: forall i in l_cnt_wor+1..x_resTbls.resID.count
1831: update wsm_copy_op_resource_instances
1832: set start_date = x_resTbls.startDate(i),
1833: completion_date = x_resTbls.endDate(i),
1834: ----standard who columns----
1835: last_update_date = l_sysdate,
1836: last_updated_by = l_userID,
1837: last_update_login = l_loginID
1838: where wip_entity_id = p_wipEntityID
1848: if g_update_current_op and l_cnt_wor > 0 and l_cnt_wor is not NULL then --bug 6345672/bug 7163667
1849: update wsm_copy_op_resource_instances
1850: set start_date = x_resTbls.startDate(l_cnt_wor),
1851: completion_date = x_resTbls.endDate(l_cnt_wor),
1852: ----standard who columns----
1853: last_update_date = l_sysdate,
1854: last_updated_by = l_userID,
1855: last_update_login = l_loginID
1856: where wip_entity_id = p_wipEntityID
1885: start_date,
1886: completion_date,
1887: assigned_units,
1888: cumulative_processing_time,
1889: ----standard who columns----
1890: last_update_date,
1891: last_updated_by,
1892: creation_date,
1893: created_by,
1932: assigned_units,
1933: instance_id,
1934: serial_number,
1935: cumulative_processing_time,
1936: ----standard who columns----
1937: last_update_date,
1938: last_updated_by,
1939: creation_date,
1940: created_by,
2008: start_date,
2009: completion_date,
2010: assigned_units,
2011: cumulative_processing_time,
2012: ----standard who columns----
2013: last_update_date,
2014: last_updated_by,
2015: creation_date,
2016: created_by,
2056: start_date,
2057: completion_date,
2058: assigned_units,
2059: cumulative_processing_time,
2060: ----standard who columns----
2061: last_update_date,
2062: last_updated_by,
2063: creation_date,
2064: created_by,
2105: assigned_units,
2106: instance_id,
2107: serial_number,
2108: cumulative_processing_time,
2109: ----standard who columns----
2110: last_update_date,
2111: last_updated_by,
2112: creation_date,
2113: created_by,
2162: assigned_units,
2163: instance_id,
2164: serial_number,
2165: cumulative_processing_time,
2166: ----standard who columns----
2167: last_update_date,
2168: last_updated_by,
2169: creation_date,
2170: created_by,