eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 234: wsh_glbl_var_strct_grp.Delivery_Details_Rec_Type,

230: */
231:
232: PROCEDURE default_container_attr (
233: P_container_rec IN OUT NOCOPY
234: wsh_glbl_var_strct_grp.Delivery_Details_Rec_Type,
235: p_additional_cont_attr IN wsh_glbl_var_strct_grp.LPNRecordType,
236: p_caller IN VARCHAR2,
237: x_return_status OUT NOCOPY VARCHAR2
238:

Line 235: p_additional_cont_attr IN wsh_glbl_var_strct_grp.LPNRecordType,

231:
232: PROCEDURE default_container_attr (
233: P_container_rec IN OUT NOCOPY
234: wsh_glbl_var_strct_grp.Delivery_Details_Rec_Type,
235: p_additional_cont_attr IN wsh_glbl_var_strct_grp.LPNRecordType,
236: p_caller IN VARCHAR2,
237: x_return_status OUT NOCOPY VARCHAR2
238:
239: ) IS

Line 281: l_additional_cont_attr wsh_glbl_var_strct_grp.LPNRecordType;

277: l_unit_volume NUMBER;
278: l_row_id VARCHAR2(30);
279: l_org_name VARCHAR2(240);
280: l_item_name VARCHAR2(2000);
281: l_additional_cont_attr wsh_glbl_var_strct_grp.LPNRecordType;
282:
283: i NUMBER;
284: j NUMBER;
285: l_return_status VARCHAR2(2);

Line 752: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

748: l_last_update_by NUMBER;
749: l_primary_uom VARCHAR2(3);
750: -- J: W/V Changes
751:
752: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
753: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
754:
755: l_row_id VARCHAR2(30);
756: l_del_assg_id NUMBER;

Line 779: --l_cont_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;

775: l_LPN_PREFIX mtl_parameters.LPN_PREFIX%TYPE;
776: l_LPN_SUFFIX mtl_parameters.LPN_SUFFIX%TYPE;
777: l_LPN_STARTING_NUMBER mtl_parameters.LPN_STARTING_NUMBER%TYPE;
778: l_TOTAL_LPN_LENGTH mtl_parameters.TOTAL_LPN_LENGTH%TYPE;
779: --l_cont_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;
780: --l_lpn_ids WSH_UTIL_CORE.id_tab_type;
781: l_cont_name_dig number;
782: l_tare_wt NUMBER;
783: l_tare_wt_uom VARCHAR2(10);

Line 786: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;

782: l_tare_wt NUMBER;
783: l_tare_wt_uom VARCHAR2(10);
784: l_msg_count NUMBER;
785: l_msg_data VARCHAR2(32767);
786: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;
787: l_gen_lpn_rec WMS_Data_Type_Definitions_pub.AutoCreateLPNRecordType;
788: l_lpn_tbl WMS_Data_Type_Definitions_pub.LPNTableType;
789: l_num_warnings NUMBER := 0;
790: l_num_errors NUMBER := 0;

Line 792: l_additional_cont_attr wsh_glbl_var_strct_grp.LPNRecordType;

788: l_lpn_tbl WMS_Data_Type_Definitions_pub.LPNTableType;
789: l_num_warnings NUMBER := 0;
790: l_num_errors NUMBER := 0;
791: l_return_status VARCHAR2(10);
792: l_additional_cont_attr wsh_glbl_var_strct_grp.LPNRecordType;
793: l_organization_id NUMBER;
794: l_inventory_item_id NUMBER;
795: l_first number;
796: CURSOR c_get_default_parameters (v_organization_id NUMBER) IS

Line 2175: p_action_prms IN wsh_glbl_var_strct_grp.dd_action_parameters_rec_type

2171: p_cont_unassign IN VARCHAR2,
2172: p_del_unassign IN VARCHAR2,
2173: x_pack_status OUT NOCOPY VARCHAR2,
2174: x_return_status OUT NOCOPY VARCHAR2,
2175: p_action_prms IN wsh_glbl_var_strct_grp.dd_action_parameters_rec_type
2176: ) IS
2177:
2178: l_del_detail_rec WSH_UTIL_CORE.ID_TAB_TYPE;
2179:

Line 2249: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

2245: l_num_warnings number := 0;
2246:
2247: -- K LPN CONV. rv
2248: l_wms_org VARCHAR2(10) := 'N';
2249: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
2250:
2251: cursor l_get_cnt_org_csr (p_cnt_inst_id IN NUMBER) is
2252: select organization_id
2253: from wsh_delivery_details

Line 3112: l_action_prms wsh_glbl_var_strct_grp.dd_action_parameters_rec_type;

3108: l_debug_on BOOLEAN;
3109: --
3110: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UNASSIGN_DETAIL';
3111: --
3112: l_action_prms wsh_glbl_var_strct_grp.dd_action_parameters_rec_type;
3113: BEGIN
3114:
3115: --
3116: --

Line 6534: l_sync_tmp_wms_ddlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

6530: -- End of OTM R12 : assign delivery detail
6531:
6532: -- K LPN CONV. rv
6533: l_wms_org VARCHAR2(10) := 'N';
6534: l_sync_tmp_wms_ddlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6535: l_sync_tmp_inv_ddlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6536: l_wms_ddtlist_cnt NUMBER;
6537: l_inv_ddtlist_cnt NUMBER;
6538: l_sync_tmp_wms_contlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

Line 6535: l_sync_tmp_inv_ddlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

6531:
6532: -- K LPN CONV. rv
6533: l_wms_org VARCHAR2(10) := 'N';
6534: l_sync_tmp_wms_ddlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6535: l_sync_tmp_inv_ddlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6536: l_wms_ddtlist_cnt NUMBER;
6537: l_inv_ddtlist_cnt NUMBER;
6538: l_sync_tmp_wms_contlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6539: l_sync_tmp_inv_contlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

Line 6538: l_sync_tmp_wms_contlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

6534: l_sync_tmp_wms_ddlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6535: l_sync_tmp_inv_ddlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6536: l_wms_ddtlist_cnt NUMBER;
6537: l_inv_ddtlist_cnt NUMBER;
6538: l_sync_tmp_wms_contlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6539: l_sync_tmp_inv_contlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6540: l_wms_contlist_cnt NUMBER;
6541: l_inv_contlist_cnt NUMBER;
6542: l_sync_tmp_wms_contlist1 wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

Line 6539: l_sync_tmp_inv_contlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

6535: l_sync_tmp_inv_ddlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6536: l_wms_ddtlist_cnt NUMBER;
6537: l_inv_ddtlist_cnt NUMBER;
6538: l_sync_tmp_wms_contlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6539: l_sync_tmp_inv_contlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6540: l_wms_contlist_cnt NUMBER;
6541: l_inv_contlist_cnt NUMBER;
6542: l_sync_tmp_wms_contlist1 wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6543: l_sync_tmp_inv_contlist1 wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

Line 6542: l_sync_tmp_wms_contlist1 wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

6538: l_sync_tmp_wms_contlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6539: l_sync_tmp_inv_contlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6540: l_wms_contlist_cnt NUMBER;
6541: l_inv_contlist_cnt NUMBER;
6542: l_sync_tmp_wms_contlist1 wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6543: l_sync_tmp_inv_contlist1 wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6544: l_wms_contlist1_cnt NUMBER;
6545: l_inv_contlist1_cnt NUMBER;
6546: -- K LPN CONV. rv

Line 6543: l_sync_tmp_inv_contlist1 wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

6539: l_sync_tmp_inv_contlist wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6540: l_wms_contlist_cnt NUMBER;
6541: l_inv_contlist_cnt NUMBER;
6542: l_sync_tmp_wms_contlist1 wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6543: l_sync_tmp_inv_contlist1 wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
6544: l_wms_contlist1_cnt NUMBER;
6545: l_inv_contlist1_cnt NUMBER;
6546: -- K LPN CONV. rv
6547: l_mdc_id_tab wsh_util_core.id_tab_type;

Line 8039: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

8035: l_wms_count NUMBER := 0;
8036: l_wms_enabled_flag VARCHAR2(1);
8037:
8038: -- LPN CONV. rv
8039: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
8040: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
8041: l_msg_count NUMBER;
8042: l_msg_data VARCHAR2(32767);
8043: e_return_excp EXCEPTION;

Line 8040: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

8036: l_wms_enabled_flag VARCHAR2(1);
8037:
8038: -- LPN CONV. rv
8039: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
8040: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
8041: l_msg_count NUMBER;
8042: l_msg_data VARCHAR2(32767);
8043: e_return_excp EXCEPTION;
8044: -- LPN CONV. rv

Line 8536: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

8532: -- HW OPMCONV - New variable to hold item info
8533: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8534:
8535: -- LPN CONV. rv
8536: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
8537: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
8538: l_msg_count NUMBER;
8539: l_msg_data VARCHAR2(32767);
8540: e_return_excp EXCEPTION;

Line 8537: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

8533: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8534:
8535: -- LPN CONV. rv
8536: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
8537: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
8538: l_msg_count NUMBER;
8539: l_msg_data VARCHAR2(32767);
8540: e_return_excp EXCEPTION;
8541: -- LPN CONV. rv

Line 11206: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

11202: WHERE delivery_detail_id=p_del_det_id;
11203:
11204: -- K LPN CONV. rv
11205: l_wms_org VARCHAR2(10) := 'N';
11206: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
11207: l_cont_tab wsh_util_core.id_tab_type;
11208: l_lpn_unit_weight NUMBER;
11209: l_lpn_unit_volume NUMBER;
11210: l_lpn_weight_uom_code VARCHAR2(100);

Line 11711: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

11707: l_client_id NUMBER; -- LSP PROJECT :
11708:
11709: -- K LPN CONV. rv
11710: l_wms_org VARCHAR2(10) := 'N';
11711: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
11712: l_return_status VARCHAR2(1);
11713: l_num_warnings NUMBER := 0;
11714: l_cnt_line_dir VARCHAR2(10);
11715: -- K LPN CONV. rv

Line 13140: x_cont_names OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type,

13136: p_cont_name_suf IN VARCHAR2,
13137: p_cont_name_num IN NUMBER,
13138: p_cont_name_dig IN NUMBER,
13139: p_quantity IN NUMBER,
13140: x_cont_names OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type,
13141: x_return_status OUT NOCOPY VARCHAR2) IS
13142:
13143: CURSOR Get_Exist_Cont(v_cont_name VARCHAR2) IS
13144: SELECT NVL(MAX(1),0) FROM DUAL