APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_TMP

Line 5528: WSH_TMP wt

5524: msi.indivisible_flag indivisible_flag
5525: FROM WSH_DELIVERY_DETAILS wdd,
5526: wsh_delivery_assignments_v wda,
5527: MTL_SYSTEM_ITEMS msi,
5528: WSH_TMP wt
5529: WHERE wdd.delivery_detail_id = wt.id
5530: AND wdd.delivery_detail_id = wda.delivery_detail_id
5531: AND wdd.container_flag = 'N'
5532: AND wdd.inventory_item_id = msi.inventory_item_id

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

5593: --dbms_output.put_line('---------------------------');
5594: --dbms_output.put_line('In Validate_Dd_for_Pack ...');
5595: --dbms_output.put_line('---------------------------');
5596:
5597: -- 10. Delete and Bulk Insert into the wsh_tmp table
5598: --
5599: --
5600: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5601: --

Line 5611: DELETE FROM wsh_tmp;

5607: IF l_debug_on THEN
5608: WSH_DEBUG_SV.push(l_module_name);
5609: END IF;
5610: --
5611: DELETE FROM wsh_tmp;
5612:
5613: FORALL i IN 1..p_del_detail_tab.count
5614: INSERT INTO wsh_tmp (id) VALUES(p_del_detail_tab(i));
5615:

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

5610: --
5611: DELETE FROM wsh_tmp;
5612:
5613: FORALL i IN 1..p_del_detail_tab.count
5614: INSERT INTO wsh_tmp (id) VALUES(p_del_detail_tab(i));
5615:
5616: -- 20. Populate detail dd info into line_cont_tab PL/SQL table
5617: l_last_organization_id := NULL;
5618: l_dd_count := 0;

Line 6212: DELETE FROM wsh_tmp;

6208: null;
6209:
6210: END LOOP;
6211:
6212: DELETE FROM wsh_tmp;
6213:
6214: x_error_cnt := error_cnt;
6215: x_warn_cnt := warn_cnt;
6216: x_fill_pc_warn_cnt := fill_pc_warn_cnt; -- bug 3562797 jckwok