APPS.WSH_WMS_LPN_GRP dependencies on WSH_LPN_PURGE_TMP

Line 1590: Select lpn_id FROM wsh_lpn_purge_tmp

1586: l_count NUMBER;
1587: --bmso dependency 4298071
1588:
1589: Cursor c_populate_out_rec IS
1590: Select lpn_id FROM wsh_lpn_purge_tmp
1591: WHERE eligible_flag = 'Y';
1592:
1593:
1594: BEGIN

Line 1632: FROM wsh_lpn_purge_tmp;

1628: IF p_lpn_rec.lpn_ids.COUNT > 0 THEN --{
1629:
1630: BEGIN
1631: SELECT 1 INTO l_count
1632: FROM wsh_lpn_purge_tmp;
1633: EXCEPTION
1634: WHEN NO_DATA_FOUND THEN
1635: l_count := 0;
1636: END;

Line 1643: DELETE FROM wsh_lpn_purge_tmp;

1639: wsh_debug_sv.log (l_module_name,'l_count',l_count);
1640: END IF;
1641:
1642: IF l_count > 0 THEN
1643: DELETE FROM wsh_lpn_purge_tmp;
1644: END IF;
1645:
1646: FORALL I IN p_lpn_rec.lpn_ids.FIRST..p_lpn_rec.lpn_ids.LAST
1647: INSERT INTO wsh_lpn_purge_tmp

Line 1647: INSERT INTO wsh_lpn_purge_tmp

1643: DELETE FROM wsh_lpn_purge_tmp;
1644: END IF;
1645:
1646: FORALL I IN p_lpn_rec.lpn_ids.FIRST..p_lpn_rec.lpn_ids.LAST
1647: INSERT INTO wsh_lpn_purge_tmp
1648: ( lpn_id,
1649: ELIGIBLE_FLAG
1650: )VALUES(
1651: P_lpn_rec.lpn_ids(i),

Line 1655: Update wsh_lpn_purge_tmp

1651: P_lpn_rec.lpn_ids(i),
1652: 'Y'
1653: );
1654:
1655: Update wsh_lpn_purge_tmp
1656: Set eligible_flag = 'N' where
1657: Lpn_id in (
1658: Select wt.lpn_id from
1659: Wsh_lpn_purge_tmp wt, wsh_delivery_details wdd

Line 1659: Wsh_lpn_purge_tmp wt, wsh_delivery_details wdd

1655: Update wsh_lpn_purge_tmp
1656: Set eligible_flag = 'N' where
1657: Lpn_id in (
1658: Select wt.lpn_id from
1659: Wsh_lpn_purge_tmp wt, wsh_delivery_details wdd
1660: Where wt.lpn_id = wdd.lpn_id
1661: And nvl(wt.ELIGIBLE_FLAG ,'Y') = 'Y'
1662: And NVL(wdd.line_direction,'O') IN ('IO','O')
1663: And wdd.released_status <> 'C');

Line 1669: Update wsh_lpn_purge_tmp

1665: IF l_debug_on THEN
1666: wsh_debug_sv.log (l_module_name,'Rows updated',SQL%rowcount);
1667: END IF;
1668:
1669: Update wsh_lpn_purge_tmp
1670: Set ELIGIBLE_FLAG = 'N'
1671: WHERE
1672: Lpn_id in (select wt.lpn_id
1673: FROM wms_lpn_histories wlh,

Line 1675: wsh_lpn_purge_tmp wt

1671: WHERE
1672: Lpn_id in (select wt.lpn_id
1673: FROM wms_lpn_histories wlh,
1674: wsh_inbound_txn_history wth,
1675: wsh_lpn_purge_tmp wt
1676: where wlh.parent_lpn_id = wt.lpn_id
1677: and nvl(wt.ELIGIBLE_FLAG,'Y') = 'Y'
1678: and wlh.source_type_id = 1
1679: AND wlh.lpn_context = 7

Line 1689: lpn_id IN (SELECT LPN_ID FROM wsh_lpn_purge_tmp

1685: END IF;
1686:
1687: UPDATE wsh_delivery_details
1688: SET lpn_id = NULL WHERE
1689: lpn_id IN (SELECT LPN_ID FROM wsh_lpn_purge_tmp
1690: WHERE eligible_flag = 'Y');
1691:
1692: Open c_populate_out_rec;
1693: FETCH c_populate_out_rec BULK COLLECT INTO p_lpn_rec.lpn_ids;