DBA Data[Home] [Help]

APPS.WSH_WMS_LPN_GRP dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 8: WSH_GLBL_VAR_STRCT_GRP.delivery_details_Rec_Type,

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_WMS_LPN_GRP';
5:
6: PROCEDURE Handle_miss_info
7: ( p_container_info_rec IN OUT NOCOPY
8: WSH_GLBL_VAR_STRCT_GRP.delivery_details_Rec_Type,
9: x_return_status OUT NOCOPY varchar2
10: );
11:
12: --========================================================================

Line 38: WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type,

34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: p_detail_info_tab IN OUT NOCOPY
38: WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type,
39: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
40: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
41: )
42: IS

Line 39: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,

35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: p_detail_info_tab IN OUT NOCOPY
38: WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type,
39: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
40: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
41: )
42: IS
43: --

Line 40: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType

36: x_msg_data OUT NOCOPY VARCHAR2,
37: p_detail_info_tab IN OUT NOCOPY
38: WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type,
39: p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
40: x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
41: )
42: IS
43: --
44: l_debug_on BOOLEAN;

Line 230: IF p_IN_rec.caller <> WSH_GLBL_VAR_STRCT_GRP.c_skip_miss_info THEN

226: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DETAIL'); --bmso new message
227: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
228: RAISE FND_API.G_EXC_ERROR;
229: END;
230: IF p_IN_rec.caller <> WSH_GLBL_VAR_STRCT_GRP.c_skip_miss_info THEN
231:
232: --handle_miss_info is not used, when wsh_container_grp.update_container calls this API.
233:
234: IF l_debug_on THEN

Line 449: WSH_GLBL_VAR_STRCT_GRP.delivery_details_Rec_Type,

445: --========================================================================
446:
447: PROCEDURE Handle_miss_info
448: ( p_container_info_rec IN OUT NOCOPY
449: WSH_GLBL_VAR_STRCT_GRP.delivery_details_Rec_Type,
450: x_return_status OUT NOCOPY varchar2
451: )
452: IS
453: --

Line 732: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,

728: x_msg_count OUT NOCOPY NUMBER,
729: x_msg_data OUT NOCOPY VARCHAR2,
730: p_lpn_id_tbl IN wsh_util_core.id_tab_type,
731: p_del_det_id_tbl IN wsh_util_core.id_tab_type,
732: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
733: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type,
734: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
735: )
736: IS

Line 733: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type,

729: x_msg_data OUT NOCOPY VARCHAR2,
730: p_lpn_id_tbl IN wsh_util_core.id_tab_type,
731: p_del_det_id_tbl IN wsh_util_core.id_tab_type,
732: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
733: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type,
734: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
735: )
736: IS
737: --{

Line 734: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type

730: p_lpn_id_tbl IN wsh_util_core.id_tab_type,
731: p_del_det_id_tbl IN wsh_util_core.id_tab_type,
732: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
733: x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type,
734: x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
735: )
736: IS
737: --{
738:

Line 815: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

811: l_calc_fill_pc_flag BOOLEAN := FALSE;
812: l_update_sub_loc_flag BOOLEAN := FALSE;
813: l_cont_fill_pc NUMBER;
814: l_fill_status VARCHAR2(10);
815: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
816: l_return_status VARCHAR2(1);
817: l_api_version_number CONSTANT NUMBER := 1.0;
818: l_api_name CONSTANT VARCHAR2(30):= 'create_update_containers';
819: l_msg_count NUMBER;

Line 829: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;

825: i NUMBER;
826: j NUMBER;
827: k NUMBER;
828: l_index NUMBER;
829: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
830:
831: l_cr_up_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
832: l_cr_up_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
833: l_exist_detail_id NUMBER;

Line 831: l_cr_up_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

827: k NUMBER;
828: l_index NUMBER;
829: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
830:
831: l_cr_up_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
832: l_cr_up_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
833: l_exist_detail_id NUMBER;
834: l_exist_cnt_item_id NUMBER;
835:

Line 832: l_cr_up_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

828: l_index NUMBER;
829: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
830:
831: l_cr_up_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
832: l_cr_up_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
833: l_exist_detail_id NUMBER;
834: l_exist_cnt_item_id NUMBER;
835:
836: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

Line 836: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;

832: l_cr_up_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
833: l_exist_detail_id NUMBER;
834: l_exist_cnt_item_id NUMBER;
835:
836: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
837: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
838: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
839:
840: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

Line 837: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

833: l_exist_detail_id NUMBER;
834: l_exist_cnt_item_id NUMBER;
835:
836: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
837: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
838: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
839:
840: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
841: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

Line 838: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;

834: l_exist_cnt_item_id NUMBER;
835:
836: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
837: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
838: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
839:
840: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
841: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
842:

Line 840: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

836: l_rec_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
837: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
838: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
839:
840: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
841: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
842:
843:
844:

Line 841: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

837: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
838: l_dummy_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
839:
840: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
841: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
842:
843:
844:
845:

Line 1572: WSH_GLBL_VAR_STRCT_GRP.purgeInOutRecType

1568: x_return_status OUT NOCOPY VARCHAR2,
1569: x_msg_count OUT NOCOPY NUMBER,
1570: x_msg_data OUT NOCOPY VARCHAR2,
1571: P_lpn_rec IN OUT NOCOPY
1572: WSH_GLBL_VAR_STRCT_GRP.purgeInOutRecType
1573: )
1574: IS
1575: --
1576: l_debug_on BOOLEAN;