DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on WSH_WMS_LPN_GRP

Line 1051: WSH_WMS_LPN_GRP.Create_Update_Containers (

1047:
1048: l_IN_rec.caller := 'WMS';
1049: l_IN_rec.action_code := 'CREATE';
1050:
1051: WSH_WMS_LPN_GRP.Create_Update_Containers (
1052: p_api_version => 1.0
1053: , p_init_msg_list => fnd_api.g_false
1054: , p_commit => fnd_api.g_false
1055: , x_return_status => x_return_status

Line 1716: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers

1712: AND msi.organization_id = p_new_org_id
1713: ORDER BY wlc.inventory_item_id;
1714: --End of changes for Bug #3516547
1715:
1716: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers
1717: wsh_update_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1718: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1719: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1720: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

Line 1722: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action

1718: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1719: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1720: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1721:
1722: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
1723: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
1724: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
1725: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
1726: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

Line 1728: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action

1724: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
1725: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
1726: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
1727:
1728: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
1729: -- Need 2 different tables one for lpns that need to be unpacked one for
1730: -- lpns thatn need to be deleted
1731: l_wsh_unpack_lpn_id_tbl wsh_util_core.id_tab_type;
1732: l_wsh_delete_lpn_id_tbl wsh_util_core.id_tab_type;

Line 3208: -- add record to call WSH_WMS_LPN_GRP.create_update_containers

3204: ELSIF ( NVL(l_old.subinventory_code, G_NULL_CHAR) <> NVL(l_new.subinventory_code, G_NULL_CHAR) OR
3205: NVL(l_old.locator_id, G_NULL_NUM) <> NVL(l_new.locator_id, G_NULL_NUM) )
3206: THEN
3207: -- If any of the following attributes were changed need to inform shipping
3208: -- add record to call WSH_WMS_LPN_GRP.create_update_containers
3209: l_tmp_i := NVL(wsh_update_tbl.last, 0) + 1;
3210:
3211: wsh_update_tbl(l_tmp_i).organization_id := l_new.organization_id;
3212: wsh_update_tbl(l_tmp_i).lpn_id := l_new.outermost_lpn_id;

Line 3231: WSH_WMS_LPN_GRP.Create_Update_Containers (

3227:
3228: l_IN_rec.caller := 'WMS';
3229: l_IN_rec.action_code := 'CREATE';
3230:
3231: WSH_WMS_LPN_GRP.Create_Update_Containers (
3232: p_api_version => 1.0
3233: , p_init_msg_list => fnd_api.g_false
3234: , p_commit => fnd_api.g_false
3235: , x_return_status => x_return_status

Line 3252: WSH_WMS_LPN_GRP.Create_Update_Containers (

3248: mdebug('msg: '||l_msgdata, G_ERROR);
3249: END IF;
3250: l_IN_rec.action_code := 'UPDATE';
3251:
3252: WSH_WMS_LPN_GRP.Create_Update_Containers (
3253: p_api_version => 1.0
3254: , p_init_msg_list => fnd_api.g_false
3255: , p_commit => fnd_api.g_false
3256: , x_return_status => x_return_status

Line 3286: WSH_WMS_LPN_GRP.Create_Update_Containers (

3282:
3283: l_IN_rec.caller := 'WMS';
3284: l_IN_rec.action_code := 'UPDATE';
3285:
3286: WSH_WMS_LPN_GRP.Create_Update_Containers (
3287: p_api_version => 1.0
3288: , p_init_msg_list => fnd_api.g_false
3289: , p_commit => fnd_api.g_false
3290: , x_return_status => x_return_status

Line 3307: WSH_WMS_LPN_GRP.Create_Update_Containers (

3303: mdebug('msg: '||l_msgdata, G_ERROR);
3304: END IF;
3305: l_IN_rec.action_code := 'CREATE';
3306:
3307: WSH_WMS_LPN_GRP.Create_Update_Containers (
3308: p_api_version => 1.0
3309: , p_init_msg_list => fnd_api.g_false
3310: , p_commit => fnd_api.g_false
3311: , x_return_status => x_return_status

Line 3347: WSH_WMS_LPN_GRP.Delivery_Detail_Action (

3343:
3344: l_wsh_action_prms.caller := 'WMS';
3345: l_wsh_action_prms.action_code := 'UNPACK';
3346:
3347: WSH_WMS_LPN_GRP.Delivery_Detail_Action (
3348: p_api_version_number => 1.0
3349: , p_init_msg_list => fnd_api.g_false
3350: , p_commit => fnd_api.g_false
3351: , x_return_status => x_return_status

Line 3387: WSH_WMS_LPN_GRP.Delivery_Detail_Action (

3383:
3384: l_wsh_action_prms.caller := 'WMS';
3385: l_wsh_action_prms.action_code := 'DELETE';
3386:
3387: WSH_WMS_LPN_GRP.Delivery_Detail_Action (
3388: p_api_version_number => 1.0
3389: , p_init_msg_list => fnd_api.g_false
3390: , p_commit => fnd_api.g_false
3391: , x_return_status => x_return_status

Line 4186: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action

4182: L_UNPACK CONSTANT NUMBER := 2;
4183: L_CORRECT CONSTANT NUMBER := 3;
4184: L_UNPACK_ALL CONSTANT NUMBER := 4;
4185:
4186: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
4187: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;
4188: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
4189: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
4190: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;

Line 5657: WSH_WMS_LPN_GRP.Delivery_Detail_Action (

5653: l_wsh_action_prms.lpn_rec.lpn_id := l_lpn.lpn_id;
5654: l_wsh_action_prms.lpn_rec.container_name := l_lpn.license_plate_number;
5655: l_wsh_lpn_id_tbl(1) := p_content_lpn_id;
5656:
5657: WSH_WMS_LPN_GRP.Delivery_Detail_Action (
5658: p_api_version_number => 1.0
5659: , p_init_msg_list => fnd_api.g_false
5660: , p_commit => fnd_api.g_false
5661: , x_return_status => x_return_status

Line 5728: WSH_WMS_LPN_GRP.Delivery_Detail_Action (

5724: l_wsh_action_prms.lpn_rec.lpn_id := l_lpn.lpn_id;
5725: l_wsh_action_prms.lpn_rec.container_name := l_lpn.license_plate_number;
5726: l_wsh_lpn_id_tbl(1) := p_content_lpn_id;
5727:
5728: WSH_WMS_LPN_GRP.Delivery_Detail_Action (
5729: p_api_version_number => 1.0
5730: , p_init_msg_list => fnd_api.g_false
5731: , p_commit => fnd_api.g_false
5732: , x_return_status => x_return_status