[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;
1569: set --scheduled_start_date = NVL(l_jobStartDate, scheduled_start_date),
1570: --scheduled_completion_date = NVL(l_jobComplDate, scheduled_completion_date),
1571: scheduled_start_date = l_newJobStartDate,
1572: scheduled_completion_date = l_newJobComplDate,
1573: ----standard who columns----
1574: last_update_date = l_sysdate,
1575: last_updated_by = l_userID,
1576: last_update_login = l_loginID,
1577: request_id = l_reqID,
1595: last_unit_start_date = NVL(l_OpStartDate(i), last_unit_start_date),
1596: first_unit_completion_date = NVL(l_OpEndDate(i), first_unit_completion_date),
1597: last_unit_completion_date = NVL(l_OpEndDate(i), last_unit_completion_date),
1598: scheduled_quantity = l_OpQty(i),
1599: ----standard who columns----
1600: last_update_date = l_sysdate,
1601: last_updated_by = l_userID,
1602: last_update_login = l_loginID,
1603: request_id = l_reqID,
1618: update wsm_copy_operations
1619: set reco_start_date = l_OpStartDate(i),
1620: reco_completion_date = l_OpEndDate(i),
1621: reco_scheduled_quantity = l_OpQty(i),
1622: ----standard who columns----
1623: last_update_date = l_sysdate,
1624: last_updated_by = l_userID,
1625: last_update_login = l_loginID,
1626: request_id = l_reqID,
1640: update wsm_copy_operations
1641: set reco_start_date = l_OpStartDate(l_cnt_wo),
1642: reco_completion_date = l_OpEndDate(l_cnt_wo),
1643: reco_scheduled_quantity = l_OpQty(l_cnt_wo),
1644: ----standard who columns----
1645: last_update_date = l_sysdate,
1646: last_updated_by = l_userID,
1647: last_update_login = l_loginID,
1648: request_id = l_reqID,
1664: --update mtl requirement dates WRO
1665: forall i in 1..l_cnt_wo
1666: update wip_requirement_operations
1667: set date_required = NVL(l_OpStartDate(i), date_required),
1668: ----standard who columns----
1669: last_update_date = l_sysdate,
1670: last_updated_by = l_userID,
1671: last_update_login = l_loginID,
1672: request_id = l_reqID,
1684: --update mtl requirement dates WCRO
1685: forall i in l_cnt_wo+1..p_opTbl.count
1686: update wsm_copy_requirement_ops
1687: set reco_date_required = l_OpStartDate(i),
1688: ----standard who columns----
1689: last_update_date = l_sysdate,
1690: last_updated_by = l_userID,
1691: last_update_login = l_loginID,
1692: request_id = l_reqID,
1704: l_stat_num := 105;
1705: if g_update_current_op and l_cnt_wo is not NULL and l_cnt_wo > 0 then --bug 6345672
1706: update wsm_copy_requirement_ops
1707: set reco_date_required = l_OpStartDate(l_cnt_wo),
1708: ----standard who columns----
1709: last_update_date = l_sysdate,
1710: last_updated_by = l_userID,
1711: last_update_login = l_loginID,
1712: request_id = l_reqID,
1739: forall i in 1..l_cnt_wor
1740: update wip_operation_resources
1741: set start_date = NVL(x_resTbls.startDate(i), start_date),
1742: completion_date = NVL(x_resTbls.endDate(i), completion_date),
1743: ----standard who columns----
1744: last_update_date = l_sysdate,
1745: last_updated_by = l_userID,
1746: last_update_login = l_loginID,
1747: request_id = l_reqID,
1761: forall i in l_cnt_wor+1..x_resTbls.resID.count
1762: update wsm_copy_op_resources
1763: set reco_start_date = x_resTbls.startDate(i),
1764: reco_completion_date = x_resTbls.endDate(i),
1765: ----standard who columns----
1766: last_update_date = l_sysdate,
1767: last_updated_by = l_userID,
1768: last_update_login = l_loginID,
1769: request_id = l_reqID,
1783: if g_update_current_op AND l_cnt_wor > 0 and l_cnt_wor is not NULL then --bug 6345672/ -- bug 7248484
1784: update wsm_copy_op_resources
1785: set reco_start_date = x_resTbls.startDate(l_cnt_wor),
1786: reco_completion_date = x_resTbls.endDate(l_cnt_wor),
1787: ----standard who columns----
1788: last_update_date = l_sysdate,
1789: last_updated_by = l_userID,
1790: last_update_login = l_loginID,
1791: request_id = l_reqID,
1809: forall i in 1..l_cnt_wor
1810: update wip_op_resource_instances
1811: set start_date = NVL(x_resTbls.startDate(i), start_date),
1812: completion_date = NVL(x_resTbls.endDate(i), completion_date),
1813: ----standard who columns----
1814: last_update_date = l_sysdate,
1815: last_updated_by = l_userID,
1816: last_update_login = l_loginID
1817: where wip_entity_id = p_wipEntityID
1827: forall i in l_cnt_wor+1..x_resTbls.resID.count
1828: update wsm_copy_op_resource_instances
1829: set start_date = x_resTbls.startDate(i),
1830: completion_date = x_resTbls.endDate(i),
1831: ----standard who columns----
1832: last_update_date = l_sysdate,
1833: last_updated_by = l_userID,
1834: last_update_login = l_loginID
1835: where wip_entity_id = p_wipEntityID
1845: if g_update_current_op and l_cnt_wor > 0 and l_cnt_wor is not NULL then --bug 6345672 -- bug 7248484
1846: update wsm_copy_op_resource_instances
1847: set start_date = x_resTbls.startDate(l_cnt_wor),
1848: completion_date = x_resTbls.endDate(l_cnt_wor),
1849: ----standard who columns----
1850: last_update_date = l_sysdate,
1851: last_updated_by = l_userID,
1852: last_update_login = l_loginID
1853: where wip_entity_id = p_wipEntityID
1882: start_date,
1883: completion_date,
1884: assigned_units,
1885: cumulative_processing_time,
1886: ----standard who columns----
1887: last_update_date,
1888: last_updated_by,
1889: creation_date,
1890: created_by,
1929: assigned_units,
1930: instance_id,
1931: serial_number,
1932: cumulative_processing_time,
1933: ----standard who columns----
1934: last_update_date,
1935: last_updated_by,
1936: creation_date,
1937: created_by,
2005: start_date,
2006: completion_date,
2007: assigned_units,
2008: cumulative_processing_time,
2009: ----standard who columns----
2010: last_update_date,
2011: last_updated_by,
2012: creation_date,
2013: created_by,
2053: start_date,
2054: completion_date,
2055: assigned_units,
2056: cumulative_processing_time,
2057: ----standard who columns----
2058: last_update_date,
2059: last_updated_by,
2060: creation_date,
2061: created_by,
2102: assigned_units,
2103: instance_id,
2104: serial_number,
2105: cumulative_processing_time,
2106: ----standard who columns----
2107: last_update_date,
2108: last_updated_by,
2109: creation_date,
2110: created_by,
2159: assigned_units,
2160: instance_id,
2161: serial_number,
2162: cumulative_processing_time,
2163: ----standard who columns----
2164: last_update_date,
2165: last_updated_by,
2166: creation_date,
2167: created_by,