DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on WSH_WMS_LPN_GRP

Line 1106: WSH_WMS_LPN_GRP.Create_Update_Containers (

1102:
1103: l_IN_rec.caller := 'WMS';
1104: l_IN_rec.action_code := 'CREATE';
1105:
1106: WSH_WMS_LPN_GRP.Create_Update_Containers (
1107: p_api_version => 1.0
1108: , p_init_msg_list => fnd_api.g_false
1109: , p_commit => fnd_api.g_false
1110: , x_return_status => x_return_status

Line 1909: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers

1905: AND msi.organization_id = p_new_org_id
1906: ORDER BY wlc.inventory_item_id;
1907: --End of changes for Bug #3516547
1908:
1909: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers
1910: wsh_update_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1911: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1912: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1913: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

Line 1915: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action

1911: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1912: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1913: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1914:
1915: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
1916: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
1917: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
1918: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
1919: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

Line 1921: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action

1917: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
1918: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
1919: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
1920:
1921: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
1922: -- Need 2 different tables one for lpns that need to be unpacked one for
1923: -- lpns thatn need to be deleted
1924: l_wsh_unpack_lpn_id_tbl wsh_util_core.id_tab_type;
1925: l_wsh_delete_lpn_id_tbl wsh_util_core.id_tab_type;

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

3504: ELSIF ( NVL(l_old.subinventory_code, G_NULL_CHAR) <> NVL(l_new.subinventory_code, G_NULL_CHAR) OR
3505: NVL(l_old.locator_id, G_NULL_NUM) <> NVL(l_new.locator_id, G_NULL_NUM) )
3506: THEN
3507: -- If any of the following attributes were changed need to inform shipping
3508: -- add record to call WSH_WMS_LPN_GRP.create_update_containers
3509: l_tmp_i := NVL(wsh_update_tbl.last, 0) + 1;
3510:
3511: wsh_update_tbl(l_tmp_i).organization_id := l_new.organization_id;
3512: wsh_update_tbl(l_tmp_i).lpn_id := l_new.outermost_lpn_id;

Line 3531: WSH_WMS_LPN_GRP.Create_Update_Containers (

3527:
3528: l_IN_rec.caller := 'WMS';
3529: l_IN_rec.action_code := 'CREATE';
3530:
3531: WSH_WMS_LPN_GRP.Create_Update_Containers (
3532: p_api_version => 1.0
3533: , p_init_msg_list => fnd_api.g_false
3534: , p_commit => fnd_api.g_false
3535: , x_return_status => x_return_status

Line 3552: WSH_WMS_LPN_GRP.Create_Update_Containers (

3548: mdebug('msg: '||l_msgdata, G_ERROR);
3549: END IF;
3550: l_IN_rec.action_code := 'UPDATE';
3551:
3552: WSH_WMS_LPN_GRP.Create_Update_Containers (
3553: p_api_version => 1.0
3554: , p_init_msg_list => fnd_api.g_false
3555: , p_commit => fnd_api.g_false
3556: , x_return_status => x_return_status

Line 3586: WSH_WMS_LPN_GRP.Create_Update_Containers (

3582:
3583: l_IN_rec.caller := 'WMS';
3584: l_IN_rec.action_code := 'UPDATE';
3585:
3586: WSH_WMS_LPN_GRP.Create_Update_Containers (
3587: p_api_version => 1.0
3588: , p_init_msg_list => fnd_api.g_false
3589: , p_commit => fnd_api.g_false
3590: , x_return_status => x_return_status

Line 3607: WSH_WMS_LPN_GRP.Create_Update_Containers (

3603: mdebug('msg: '||l_msgdata, G_ERROR);
3604: END IF;
3605: l_IN_rec.action_code := 'CREATE';
3606:
3607: WSH_WMS_LPN_GRP.Create_Update_Containers (
3608: p_api_version => 1.0
3609: , p_init_msg_list => fnd_api.g_false
3610: , p_commit => fnd_api.g_false
3611: , x_return_status => x_return_status

Line 3647: WSH_WMS_LPN_GRP.Delivery_Detail_Action (

3643:
3644: l_wsh_action_prms.caller := 'WMS';
3645: l_wsh_action_prms.action_code := 'UNPACK';
3646:
3647: WSH_WMS_LPN_GRP.Delivery_Detail_Action (
3648: p_api_version_number => 1.0
3649: , p_init_msg_list => fnd_api.g_false
3650: , p_commit => fnd_api.g_false
3651: , x_return_status => x_return_status

Line 3687: WSH_WMS_LPN_GRP.Delivery_Detail_Action (

3683:
3684: l_wsh_action_prms.caller := 'WMS';
3685: l_wsh_action_prms.action_code := 'DELETE';
3686:
3687: WSH_WMS_LPN_GRP.Delivery_Detail_Action (
3688: p_api_version_number => 1.0
3689: , p_init_msg_list => fnd_api.g_false
3690: , p_commit => fnd_api.g_false
3691: , x_return_status => x_return_status

Line 4628: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action

4624: L_UNPACK CONSTANT NUMBER := 2;
4625: L_CORRECT CONSTANT NUMBER := 3;
4626: L_UNPACK_ALL CONSTANT NUMBER := 4;
4627:
4628: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
4629: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;
4630: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
4631: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
4632: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;

Line 6217: WSH_WMS_LPN_GRP.Delivery_Detail_Action (

6213: l_wsh_action_prms.lpn_rec.lpn_id := l_lpn.lpn_id;
6214: l_wsh_action_prms.lpn_rec.container_name := l_lpn.license_plate_number;
6215: l_wsh_lpn_id_tbl(1) := p_content_lpn_id;
6216:
6217: WSH_WMS_LPN_GRP.Delivery_Detail_Action (
6218: p_api_version_number => 1.0
6219: , p_init_msg_list => fnd_api.g_false
6220: , p_commit => fnd_api.g_false
6221: , x_return_status => x_return_status

Line 6288: WSH_WMS_LPN_GRP.Delivery_Detail_Action (

6284: l_wsh_action_prms.lpn_rec.lpn_id := l_lpn.lpn_id;
6285: l_wsh_action_prms.lpn_rec.container_name := l_lpn.license_plate_number;
6286: l_wsh_lpn_id_tbl(1) := p_content_lpn_id;
6287:
6288: WSH_WMS_LPN_GRP.Delivery_Detail_Action (
6289: p_api_version_number => 1.0
6290: , p_init_msg_list => fnd_api.g_false
6291: , p_commit => fnd_api.g_false
6292: , x_return_status => x_return_status