DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on WMS_CONTAINER_GRP

Line 2554: l_validate_mode VARCHAR2(100) := wms_container_grp.G_LPN_PURGE_ACTION_VALIDATE;

2550: l_lpn_id_tab wsh_util_core.id_tab_type;
2551:
2552: l_purged_lpns WMS_Data_Type_Definitions_PUB.LPNPurgeRecordType;
2553:
2554: l_validate_mode VARCHAR2(100) := wms_container_grp.G_LPN_PURGE_ACTION_VALIDATE;
2555: l_delete_mode VARCHAR2(100) := wms_container_grp.G_LPN_PURGE_ACTION_DELETE;
2556: l_rows_lpns wsh_util_core.id_tab_type;
2557: l_cached_lpns WSH_UTIL_CORE.Id_Tab_Type;
2558: l_msg_data VARCHAR2(32000);

Line 2555: l_delete_mode VARCHAR2(100) := wms_container_grp.G_LPN_PURGE_ACTION_DELETE;

2551:
2552: l_purged_lpns WMS_Data_Type_Definitions_PUB.LPNPurgeRecordType;
2553:
2554: l_validate_mode VARCHAR2(100) := wms_container_grp.G_LPN_PURGE_ACTION_VALIDATE;
2555: l_delete_mode VARCHAR2(100) := wms_container_grp.G_LPN_PURGE_ACTION_DELETE;
2556: l_rows_lpns wsh_util_core.id_tab_type;
2557: l_cached_lpns WSH_UTIL_CORE.Id_Tab_Type;
2558: l_msg_data VARCHAR2(32000);
2559: l_msg_count NUMBER;

Line 2661: wms_container_grp.LPN_Purge_Actions (

2657: p_rows(i),
2658: decode(l_rows_lpns(i), NULL,'Y','N')
2659: );
2660:
2661: wms_container_grp.LPN_Purge_Actions (
2662: p_api_version => 1.0
2663: , p_init_msg_list => fnd_api.g_false
2664: , p_commit => fnd_api.g_false
2665: , x_return_status => l_return_status

Line 2913: wms_container_grp.LPN_Purge_Actions (

2909: BULK COLLECT INTO l_purged_lpns.lpn_ids;
2910: CLOSE c_get_valid_lpns_for_wms;
2911:
2912: IF l_purged_lpns.lpn_ids.COUNT > 0 THEN
2913: wms_container_grp.LPN_Purge_Actions (
2914: p_api_version => 1.0
2915: , p_init_msg_list => fnd_api.g_false
2916: , p_commit => fnd_api.g_false
2917: , x_return_status => l_return_status