APPS.WSH_UTIL_CORE dependencies on WSH_LPN_PURGE_TMP

Line 2536: wsh_lpn_purge_tmp

2532: WHERE delivery_detail_id = v_delivery_detail_id;
2533:
2534: CURSOR c_get_valid_lpns (v_delivery_detail_id NUMBER) IS
2535: select lpn_id, delivery_detail_id FROM
2536: wsh_lpn_purge_tmp
2537: WHERE delivery_detail_id = v_delivery_detail_id
2538: AND eligible_flag = 'Y';
2539:
2540: CURSOR c_get_valid_lpns_for_wms IS

Line 2542: wsh_lpn_purge_tmp

2538: AND eligible_flag = 'Y';
2539:
2540: CURSOR c_get_valid_lpns_for_wms IS
2541: select lpn_id FROM
2542: wsh_lpn_purge_tmp
2543: WHERE lpn_id IS NOT NULL
2544: AND eligible_flag = 'Y';
2545:
2546: -- K LPN CONV. rv

Line 2594: FROM wsh_lpn_purge_tmp;

2590: IF c_wms_code_present = 'Y' THEN --{
2591: BEGIN
2592: SELECT 1
2593: INTO l_count
2594: FROM wsh_lpn_purge_tmp;
2595: EXCEPTION
2596: WHEN NO_DATA_FOUND THEN
2597: l_count := 0;
2598: END;

Line 2601: DELETE FROM wsh_lpn_purge_tmp;

2597: l_count := 0;
2598: END;
2599:
2600: IF l_count > 0 THEN
2601: DELETE FROM wsh_lpn_purge_tmp;
2602: END IF;
2603:
2604: FOR i IN 1..p_rows.count LOOP
2605: OPEN c_get_lpns(p_rows(i));

Line 2615: INSERT INTO wsh_lpn_purge_tmp(

2611: END IF;
2612: END LOOP;
2613:
2614: FORALL i IN 1..p_rows.count
2615: INSERT INTO wsh_lpn_purge_tmp(
2616: lpn_id,
2617: delivery_detail_id,
2618: eligible_flag
2619: ) VALUES (

Line 2643: UPDATE wsh_lpn_purge_tmp

2639: END IF;
2640: IF l_lpn_ids.lpn_ids.COUNT > 0 THEN
2641:
2642: FORALL i IN l_lpn_ids.lpn_ids.FIRST..l_lpn_ids.lpn_ids.LAST
2643: UPDATE wsh_lpn_purge_tmp
2644: SET eligible_flag = 'Y'
2645: WHERE lpn_id = l_lpn_ids.lpn_ids(i);
2646:
2647: END IF;

Line 2842: update wsh_lpn_purge_tmp

2838: WSH_CONTAINER_ACTIONS.delete_containers(p_rows(i), cur_return_status);
2839: IF cur_return_status NOT IN (wsh_util_core.g_ret_sts_success,
2840: wsh_util_core.g_ret_sts_warning)
2841: THEN
2842: update wsh_lpn_purge_tmp
2843: SET eligible_flag = 'N'
2844: WHERE delivery_detail_id = p_rows(i);
2845: END IF;
2846: ELSE