[Home] [Help]
160: END IF;
161:
162: l_progress_indicator := '20';
163:
164: DELETE FROM wms_zone_locators_temp;
165:
166: IF l_debug > 0 THEN
167: DEBUG ('deleted from wms_zone_locators_temp ' || SQL%ROWCOUNT,
168: l_module_name,
163:
164: DELETE FROM wms_zone_locators_temp;
165:
166: IF l_debug > 0 THEN
167: DEBUG ('deleted from wms_zone_locators_temp ' || SQL%ROWCOUNT,
168: l_module_name,
169: 9
170: );
171: END IF;
171: END IF;
172:
173: l_progress_indicator := '30';
174:
175: INSERT INTO wms_zone_locators_temp(
176: message
177: , message_id
178: , inventory_location_id
179: , locator_name
296: END populate_grid;
297:
298: /**
299: * Using the filter criteria given in the Add Locators form,
300: * inserts the locators into the table WMS_ZONE_LOCATORS_TEMP.
301: *
302: * @param p_fm_zone_id from_zone_id in the range. Will have a
303: * null value if the user doesnt choose a from_zone
304: * @param p_to_zone_id to_zone_id in the range. Can have a null
344: l_insert_str VARCHAR2 (2000);
345: l_select_str VARCHAR2 (2000);
346: l_from_str VARCHAR2 (2000);
347: l_where_str VARCHAR2 (2000);
348: g_add_locator_message wms_zone_locators_temp.MESSAGE%TYPE;
349: l_query_str VARCHAR2 (4000);
350: l_query_handle NUMBER;
351: l_query_count NUMBER;
352: l_progress VARCHAR2 (10) := '0';
356: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
357: l_progress_indicator VARCHAR2(10) := '0';
358:
359: -- Zone enhancement
360: l_jtf_message wms_zone_locators_temp.MESSAGE%TYPE;
361: l_jtf_message_id VARCHAR2(4) := 'NULL';
362:
363: -- bug 3659062
364: l_fm_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
437: l_jtf_message_id := '1';
438: l_jtf_message := wms_zones_pvt.g_add_locators_message;
439: ELSE
440: -- clear the temp table if OK was pressed in ADD or REMOVE mode
441: DELETE wms_zone_locators_temp;
442: END IF;
443:
444: l_progress_indicator := '20';
445:
461: AND organization_id = p_organization_id;
462: END IF;
463:
464: l_insert_str :=
465: 'INSERT INTO wms_zone_locators_temp(
466: message,
467: message_id,
468: inventory_location_id,
469: locator_name,
1713: END update_wms_zones;
1714:
1715: /**
1716: * This procedure saves the records from
1717: * wms_zone_locators_temp to wms_zone_locators. For every
1718: * record at a given index in the table p_zoneloc_messages
1719: * table, we get the the corresponding rowid from the input
1720: * parameter table p_zoneloc_rowid_t for the same index.
1721: * If the value in p_zoneloc_messages_t is 0, the
1756: DELETE FROM wms_zone_locators
1757: WHERE ROWID IN (
1758: SELECT wzl.ROWID
1759: FROM wms_zone_locators wzl,
1760: wms_zone_locators_temp wzlt
1761: WHERE wzl.zone_id = p_zone_id
1762: AND wzlt.rowid = p_zoneloc_rowid_t(i)
1763: AND wzlt.message_id = 1
1764: AND wzl.organization_id = wzlt.organization_id
1804: , fnd_global.user_id
1805: , SYSDATE
1806: , fnd_global.user_id
1807: , fnd_global.login_id
1808: FROM wms_zone_locators_temp wzlt
1809: WHERE wzlt.message_id = 1
1810: AND ROWID = p_zoneloc_rowid_t (i)
1811: AND NOT EXISTS (
1812: SELECT 1
1839: DELETE FROM wms_zone_locators
1840: WHERE ROWID IN (
1841: SELECT wzl.ROWID
1842: FROM wms_zone_locators wzl,
1843: wms_zone_locators_temp wzlt
1844: WHERE wzl.zone_id = p_zone_id
1845: AND wzlt.rowid = p_zoneloc_rowid_t(i)
1846: AND wzlt.message_id = 2
1847: AND wzl.organization_id = wzlt.organization_id
1892: subinventory_code,
1893: DECODE (inventory_location_id, -999, 'Y', 'N'), SYSDATE,
1894: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1895: fnd_global.user_id
1896: FROM wms_zone_locators_temp
1897: WHERE MESSAGE_ID = 1 );
1898:
1899: DEBUG ('committing' || SQL%ROWCOUNT, 'save_all_locators', 9);
1900:
1900:
1901: DELETE FROM wms_zone_locators
1902: WHERE inventory_location_id =
1903: (SELECT inventory_location_id
1904: FROM wms_zone_locators_temp
1905: WHERE MESSAGE_id = 2)
1906: AND zone_id = p_zone_id;
1907:
1908: COMMIT;