APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_TMP

Line 5600: WSH_TMP wt

5596: msi.indivisible_flag indivisible_flag
5597: FROM WSH_DELIVERY_DETAILS wdd,
5598: wsh_delivery_assignments_v wda,
5599: MTL_SYSTEM_ITEMS msi,
5600: WSH_TMP wt
5601: WHERE wdd.delivery_detail_id = wt.id
5602: AND wdd.delivery_detail_id = wda.delivery_detail_id
5603: AND wdd.container_flag = 'N'
5604: AND wdd.inventory_item_id = msi.inventory_item_id

Line 5669: -- 10. Delete and Bulk Insert into the wsh_tmp table

5665: --dbms_output.put_line('---------------------------');
5666: --dbms_output.put_line('In Validate_Dd_for_Pack ...');
5667: --dbms_output.put_line('---------------------------');
5668:
5669: -- 10. Delete and Bulk Insert into the wsh_tmp table
5670: --
5671: --
5672: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5673: --

Line 5683: DELETE FROM wsh_tmp;

5679: IF l_debug_on THEN
5680: WSH_DEBUG_SV.push(l_module_name);
5681: END IF;
5682: --
5683: DELETE FROM wsh_tmp;
5684:
5685: FORALL i IN 1..p_del_detail_tab.count
5686: INSERT INTO wsh_tmp (id) VALUES(p_del_detail_tab(i));
5687:

Line 5686: INSERT INTO wsh_tmp (id) VALUES(p_del_detail_tab(i));

5682: --
5683: DELETE FROM wsh_tmp;
5684:
5685: FORALL i IN 1..p_del_detail_tab.count
5686: INSERT INTO wsh_tmp (id) VALUES(p_del_detail_tab(i));
5687:
5688: -- 20. Populate detail dd info into line_cont_tab PL/SQL table
5689: l_last_organization_id := NULL;
5690: l_dd_count := 0;

Line 6284: DELETE FROM wsh_tmp;

6280: null;
6281:
6282: END LOOP;
6283:
6284: DELETE FROM wsh_tmp;
6285:
6286: x_error_cnt := error_cnt;
6287: x_warn_cnt := warn_cnt;
6288: x_fill_pc_warn_cnt := fill_pc_warn_cnt; -- bug 3562797 jckwok