eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_ZONES_PVT dependencies on WMS_ZONE_LOCATORS_TEMP

Line 164: DELETE FROM wms_zone_locators_temp;

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,

Line 167: DEBUG ('deleted from wms_zone_locators_temp ' || SQL%ROWCOUNT,

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;

Line 175: INSERT INTO wms_zone_locators_temp(

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

Line 300: * inserts the locators into the table WMS_ZONE_LOCATORS_TEMP.

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

Line 349: g_add_locator_message wms_zone_locators_temp.MESSAGE%TYPE;

345: l_insert_str VARCHAR2 (2000);
346: l_select_str VARCHAR2 (2000);
347: l_from_str VARCHAR2 (2000);
348: l_where_str VARCHAR2 (2000);
349: g_add_locator_message wms_zone_locators_temp.MESSAGE%TYPE;
350: l_query_str VARCHAR2 (4000);
351: l_query_handle NUMBER;
352: l_query_count NUMBER;
353: l_progress VARCHAR2 (10) := '0';

Line 361: l_jtf_message wms_zone_locators_temp.MESSAGE%TYPE;

357: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
358: l_progress_indicator VARCHAR2(10) := '0';
359:
360: -- Zone enhancement
361: l_jtf_message wms_zone_locators_temp.MESSAGE%TYPE;
362: l_jtf_message_id VARCHAR2(4) := 'NULL';
363:
364: -- bug 3659062
365: l_fm_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

Line 442: DELETE wms_zone_locators_temp;

438: l_jtf_message_id := '1';
439: l_jtf_message := wms_zones_pvt.g_add_locators_message;
440: ELSE
441: -- clear the temp table if OK was pressed in ADD or REMOVE mode
442: DELETE wms_zone_locators_temp;
443: END IF;
444:
445: l_progress_indicator := '20';
446:

Line 466: 'INSERT INTO wms_zone_locators_temp(

462: AND organization_id = p_organization_id;
463: END IF;
464:
465: l_insert_str :=
466: 'INSERT INTO wms_zone_locators_temp(
467: message,
468: message_id,
469: inventory_location_id,
470: locator_name,

Line 1741: * wms_zone_locators_temp to wms_zone_locators. For every

1737: END update_wms_zones;
1738:
1739: /**
1740: * This procedure saves the records from
1741: * wms_zone_locators_temp to wms_zone_locators. For every
1742: * record at a given index in the table p_zoneloc_messages
1743: * table, we get the the corresponding rowid from the input
1744: * parameter table p_zoneloc_rowid_t for the same index.
1745: * If the value in p_zoneloc_messages_t is 0, the

Line 1784: wms_zone_locators_temp wzlt

1780: DELETE FROM wms_zone_locators
1781: WHERE ROWID IN (
1782: SELECT wzl.ROWID
1783: FROM wms_zone_locators wzl,
1784: wms_zone_locators_temp wzlt
1785: WHERE wzl.zone_id = p_zone_id
1786: AND wzlt.rowid = p_zoneloc_rowid_t(i)
1787: AND wzlt.message_id = 1
1788: AND wzl.organization_id = wzlt.organization_id

Line 1832: FROM wms_zone_locators_temp wzlt

1828: , fnd_global.user_id
1829: , SYSDATE
1830: , fnd_global.user_id
1831: , fnd_global.login_id
1832: FROM wms_zone_locators_temp wzlt
1833: WHERE wzlt.message_id = 1
1834: AND ROWID = p_zoneloc_rowid_t (i)
1835: AND NOT EXISTS (
1836: SELECT 1

Line 1867: wms_zone_locators_temp wzlt

1863: DELETE FROM wms_zone_locators
1864: WHERE ROWID IN (
1865: SELECT wzl.ROWID
1866: FROM wms_zone_locators wzl,
1867: wms_zone_locators_temp wzlt
1868: WHERE wzl.zone_id = p_zone_id
1869: AND wzlt.rowid = p_zoneloc_rowid_t(i)
1870: AND wzlt.message_id = 2
1871: AND wzl.organization_id = wzlt.organization_id

Line 1920: FROM wms_zone_locators_temp

1916: subinventory_code,
1917: DECODE (inventory_location_id, -999, 'Y', 'N'), SYSDATE,
1918: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1919: fnd_global.user_id
1920: FROM wms_zone_locators_temp
1921: WHERE MESSAGE_ID = 1 );
1922:
1923: DEBUG ('committing' || SQL%ROWCOUNT, 'save_all_locators', 9);
1924:

Line 1928: FROM wms_zone_locators_temp

1924:
1925: DELETE FROM wms_zone_locators
1926: WHERE inventory_location_id =
1927: (SELECT inventory_location_id
1928: FROM wms_zone_locators_temp
1929: WHERE MESSAGE_id = 2)
1930: AND zone_id = p_zone_id;
1931:
1932: COMMIT;