DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on WMS_CONTAINER_GRP

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

2514: l_lpn_id_tab wsh_util_core.id_tab_type;
2515:
2516: l_purged_lpns WMS_Data_Type_Definitions_PUB.LPNPurgeRecordType;
2517:
2518: l_validate_mode VARCHAR2(100) := wms_container_grp.G_LPN_PURGE_ACTION_VALIDATE;
2519: l_delete_mode VARCHAR2(100) := wms_container_grp.G_LPN_PURGE_ACTION_DELETE;
2520: l_rows_lpns wsh_util_core.id_tab_type;
2521: l_cached_lpns WSH_UTIL_CORE.Id_Tab_Type;
2522: l_msg_data VARCHAR2(32000);

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

2515:
2516: l_purged_lpns WMS_Data_Type_Definitions_PUB.LPNPurgeRecordType;
2517:
2518: l_validate_mode VARCHAR2(100) := wms_container_grp.G_LPN_PURGE_ACTION_VALIDATE;
2519: l_delete_mode VARCHAR2(100) := wms_container_grp.G_LPN_PURGE_ACTION_DELETE;
2520: l_rows_lpns wsh_util_core.id_tab_type;
2521: l_cached_lpns WSH_UTIL_CORE.Id_Tab_Type;
2522: l_msg_data VARCHAR2(32000);
2523: l_msg_count NUMBER;

Line 2625: wms_container_grp.LPN_Purge_Actions (

2621: p_rows(i),
2622: decode(l_rows_lpns(i), NULL,'Y','N')
2623: );
2624:
2625: wms_container_grp.LPN_Purge_Actions (
2626: p_api_version => 1.0
2627: , p_init_msg_list => fnd_api.g_false
2628: , p_commit => fnd_api.g_false
2629: , x_return_status => l_return_status

Line 2877: wms_container_grp.LPN_Purge_Actions (

2873: BULK COLLECT INTO l_purged_lpns.lpn_ids;
2874: CLOSE c_get_valid_lpns_for_wms;
2875:
2876: IF l_purged_lpns.lpn_ids.COUNT > 0 THEN
2877: wms_container_grp.LPN_Purge_Actions (
2878: p_api_version => 1.0
2879: , p_init_msg_list => fnd_api.g_false
2880: , p_commit => fnd_api.g_false
2881: , x_return_status => l_return_status