APPS.WSH_UTIL_CORE dependencies on WSH_LPN_PURGE_TMP

Line 2572: wsh_lpn_purge_tmp

2568: WHERE delivery_detail_id = v_delivery_detail_id;
2569:
2570: CURSOR c_get_valid_lpns (v_delivery_detail_id NUMBER) IS
2571: select lpn_id, delivery_detail_id FROM
2572: wsh_lpn_purge_tmp
2573: WHERE delivery_detail_id = v_delivery_detail_id
2574: AND eligible_flag = 'Y';
2575:
2576: CURSOR c_get_valid_lpns_for_wms IS

Line 2578: wsh_lpn_purge_tmp

2574: AND eligible_flag = 'Y';
2575:
2576: CURSOR c_get_valid_lpns_for_wms IS
2577: select lpn_id FROM
2578: wsh_lpn_purge_tmp
2579: WHERE lpn_id IS NOT NULL
2580: AND eligible_flag = 'Y';
2581:
2582: -- K LPN CONV. rv

Line 2630: FROM wsh_lpn_purge_tmp;

2626: IF c_wms_code_present = 'Y' THEN --{
2627: BEGIN
2628: SELECT 1
2629: INTO l_count
2630: FROM wsh_lpn_purge_tmp;
2631: EXCEPTION
2632: WHEN NO_DATA_FOUND THEN
2633: l_count := 0;
2634: END;

Line 2637: DELETE FROM wsh_lpn_purge_tmp;

2633: l_count := 0;
2634: END;
2635:
2636: IF l_count > 0 THEN
2637: DELETE FROM wsh_lpn_purge_tmp;
2638: END IF;
2639:
2640: FOR i IN 1..p_rows.count LOOP
2641: OPEN c_get_lpns(p_rows(i));

Line 2651: INSERT INTO wsh_lpn_purge_tmp(

2647: END IF;
2648: END LOOP;
2649:
2650: FORALL i IN 1..p_rows.count
2651: INSERT INTO wsh_lpn_purge_tmp(
2652: lpn_id,
2653: delivery_detail_id,
2654: eligible_flag
2655: ) VALUES (

Line 2679: UPDATE wsh_lpn_purge_tmp

2675: END IF;
2676: IF l_lpn_ids.lpn_ids.COUNT > 0 THEN
2677:
2678: FORALL i IN l_lpn_ids.lpn_ids.FIRST..l_lpn_ids.lpn_ids.LAST
2679: UPDATE wsh_lpn_purge_tmp
2680: SET eligible_flag = 'Y'
2681: WHERE lpn_id = l_lpn_ids.lpn_ids(i);
2682:
2683: END IF;

Line 2878: update wsh_lpn_purge_tmp

2874: WSH_CONTAINER_ACTIONS.delete_containers(p_rows(i), cur_return_status);
2875: IF cur_return_status NOT IN (wsh_util_core.g_ret_sts_success,
2876: wsh_util_core.g_ret_sts_warning)
2877: THEN
2878: update wsh_lpn_purge_tmp
2879: SET eligible_flag = 'N'
2880: WHERE delivery_detail_id = p_rows(i);
2881: END IF;
2882: ELSE