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_DELIVERY_DETAILS_ACTIONS dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 55: x_new_delivery_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

51: -- new serial number information as needed (for serial_number, to_serial_number,
52: -- and transaction_temp_id).
53: PROCEDURE Split_Serial_Numbers_INT(
54: x_old_detail_rec IN OUT NOCOPY SplitDetailRecType,
55: x_new_delivery_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
56: p_old_shipped_quantity IN NUMBER,
57: p_new_shipped_quantity IN NUMBER,
58: x_return_status OUT NOCOPY VARCHAR2);
59:

Line 2175: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

2171: l_num_warnings number := 0;
2172:
2173: -- K LPN CONV. rv
2174: l_wms_org VARCHAR2(10) := 'N';
2175: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
2176: l_sync_tmp_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
2177: l_operation_type VARCHAR2(100);
2178: -- K LPN CONV. rv
2179:

Line 2176: l_sync_tmp_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

2172:
2173: -- K LPN CONV. rv
2174: l_wms_org VARCHAR2(10) := 'N';
2175: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
2176: l_sync_tmp_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
2177: l_operation_type VARCHAR2(100);
2178: -- K LPN CONV. rv
2179:
2180: -- OTM R12 : update delivery

Line 2197: l_delivery_detail_ids WSH_GLBL_VAR_STRCT_GRP.NUM_TBL_TYPE;

2193: l_delivery_was_empty BOOLEAN;
2194: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2195: l_gross_weight1 WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
2196: l_gross_weight2 WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
2197: l_delivery_detail_ids WSH_GLBL_VAR_STRCT_GRP.NUM_TBL_TYPE;
2198: l_assign_update BOOLEAN;
2199:
2200: -- End of OTM R12 : assign delivery detail
2201:

Line 3567: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

3563:
3564: l_num_warnings number := 0;
3565: -- K LPN CONV. rv
3566: l_wms_org VARCHAR2(10) := 'N';
3567: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
3568: l_mdc_detail_tab wsh_util_core.id_tab_type;
3569:
3570: cursor l_parent_cnt_csr (p_cnt_inst_id IN NUMBER) is
3571: select organization_id,

Line 4090: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

4086:
4087: -- K LPN CONV. rv
4088: l_detail_wms_org VARCHAR2(10) := 'N';
4089: l_line_dir VARCHAR2(10);
4090: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
4091: l_num_warnings NUMBER := 0;
4092: -- K LPN CONV. rv
4093:
4094: -- OTM R12 : update delivery

Line 4111: l_delivery_detail_ids WSH_GLBL_VAR_STRCT_GRP.NUM_TBL_TYPE;

4107: l_delivery_was_empty BOOLEAN;
4108: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
4109: l_gross_weight1 WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE;
4110: l_gross_weight2 WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE;
4111: l_delivery_detail_ids WSH_GLBL_VAR_STRCT_GRP.NUM_TBL_TYPE;
4112: l_assign_update BOOLEAN;
4113: -- End of OTM R12 : assign delivery detail
4114:
4115: --

Line 5287: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

5283: l_out_container NUMBER := 0 ;
5284: --
5285: -- K LPN CONV. rv
5286: l_wms_org VARCHAR2(10) := 'N';
5287: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
5288: l_sync_tmp_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
5289: l_num_warnings NUMBER := 0;
5290: l_operation_type VARCHAR2(100);
5291: -- K LPN CONV. rv

Line 5288: l_sync_tmp_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

5284: --
5285: -- K LPN CONV. rv
5286: l_wms_org VARCHAR2(10) := 'N';
5287: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
5288: l_sync_tmp_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
5289: l_num_warnings NUMBER := 0;
5290: l_operation_type VARCHAR2(100);
5291: -- K LPN CONV. rv
5292: l_mdc_detail_tab WSH_UTIL_CORE.Id_Tab_Type;

Line 6552: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH

6548: PROCEDURE Unassign_Detail_from_Delivery(
6549: p_detail_id IN NUMBER
6550: , x_return_status OUT NOCOPY VARCHAR2
6551: , p_validate_flag IN VARCHAR2,
6552: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH
6553: )
6554:
6555: IS
6556: detail_not_assigned exception;

Line 6638: l_line_dir_tbl WSH_GLBL_VAR_STRCT_GRP.v3_Tbl_Type; -- LPN CONV. rv

6634:
6635: l_dd_id WSH_UTIL_CORE.Id_Tab_Type;
6636: l_del_id_tbl WSH_UTIL_CORE.Id_Tab_Type; -- LPN CONV. rv
6637: l_parent_dd_id_tbl WSH_UTIL_CORE.Id_Tab_Type; -- LPN CONV. rv
6638: l_line_dir_tbl WSH_GLBL_VAR_STRCT_GRP.v3_Tbl_Type; -- LPN CONV. rv
6639: l_cnt_flag_tbl WSH_GLBL_VAR_STRCT_GRP.v3_Tbl_Type; -- LPN CONV. rv
6640: l_det_org_id_tbl WSH_UTIL_CORE.Id_Tab_Type; -- LPN CONV. rv
6641: i BINARY_INTEGER := 0;
6642: j BINARY_INTEGER :=0;

Line 6639: l_cnt_flag_tbl WSH_GLBL_VAR_STRCT_GRP.v3_Tbl_Type; -- LPN CONV. rv

6635: l_dd_id WSH_UTIL_CORE.Id_Tab_Type;
6636: l_del_id_tbl WSH_UTIL_CORE.Id_Tab_Type; -- LPN CONV. rv
6637: l_parent_dd_id_tbl WSH_UTIL_CORE.Id_Tab_Type; -- LPN CONV. rv
6638: l_line_dir_tbl WSH_GLBL_VAR_STRCT_GRP.v3_Tbl_Type; -- LPN CONV. rv
6639: l_cnt_flag_tbl WSH_GLBL_VAR_STRCT_GRP.v3_Tbl_Type; -- LPN CONV. rv
6640: l_det_org_id_tbl WSH_UTIL_CORE.Id_Tab_Type; -- LPN CONV. rv
6641: i BINARY_INTEGER := 0;
6642: j BINARY_INTEGER :=0;
6643:

Line 6672: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

6668:
6669: -- K LPN CONV. rv
6670: l_wms_org VARCHAR2(10) := 'N';
6671: l_loop_wms_org VARCHAR2(10) := 'N';
6672: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
6673: l_line_dir VARCHAR2(10);
6674: l_num_warnings NUMBER := 0;
6675:
6676: cursor l_parent_cnt_csr (p_cnt_inst_id IN NUMBER) is

Line 7587: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type; -- J-IB-NPARIKH

7583: l_debug_on BOOLEAN;
7584: --
7585: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PACKAGE_NAME || '.' || 'UNASSIGN_DETAIL_FROM_DELIVERY';
7586: --
7587: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type; -- J-IB-NPARIKH
7588: BEGIN
7589:
7590: /*changing as per discussion with PM -- if detail is in a container, unassign from container as well. if detail itself is a container, unassign all children from delivery as well*/
7591:

Line 7647: , p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH

7643: , P_FROM_delivery IN VARCHAR2
7644: , P_FROM_container IN VARCHAR2
7645: , x_return_status out NOCOPY varchar2
7646: , p_validate_flag IN VARCHAR2
7647: , p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH
7648: )
7649: IS
7650:
7651: CURSOR c_multi_assign_rec(c_delivery_detail_id number)

Line 7700: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

7696: l_org_id NUMBER;
7697: l_wf_rs VARCHAR2(1);
7698:
7699: -- K LPN CONV. rv
7700: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
7701: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
7702: l_msg_count NUMBER;
7703: l_msg_data VARCHAR2(32767);
7704: -- K LPN CONV. rv

Line 7701: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

7697: l_wf_rs VARCHAR2(1);
7698:
7699: -- K LPN CONV. rv
7700: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
7701: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
7702: l_msg_count NUMBER;
7703: l_msg_data VARCHAR2(32767);
7704: -- K LPN CONV. rv
7705:

Line 8291: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type; -- J-IB-NPARIKH

8287: l_debug_on BOOLEAN;
8288: --
8289: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PACKAGE_NAME || '.' || 'UNASSIGN_MULTIPLE_DETAILS';
8290: --
8291: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type; -- J-IB-NPARIKH
8292: BEGIN
8293: --
8294: --
8295: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 8702: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

8698: */
8699: l_entity_ids WSH_UTIL_CORE.id_tab_type;
8700: reprice_required_err EXCEPTION;
8701: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
8702: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
8703: l_split_weight number;
8704: l_split_volume number;
8705: l_split_return_status varchar2(30);
8706: l_shipped_quantity NUMBER := NULL;

Line 8726: l_new_serial_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

8722: l_serial_tab WSH_DELIVERY_DETAILS_ACTIONS.serial_tab;
8723: i NUMBER;
8724: j NUMBER;
8725: l_serial_orig_rec WSH_DELIVERY_DETAILS_ACTIONS.SplitDetailRecType;
8726: l_new_serial_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
8727: l_transaction_id_tab WSH_UTIL_CORE.id_tab_type;
8728: l_serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE;
8729: TYPE l_sr_no_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
8730: l_serial_number_tab l_sr_no_tab;

Line 9105: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

9101: l_qty_return_status varchar2(30);
9102: new_det_wt_vol_failed exception;
9103: old_det_wt_vol_failed exception;
9104: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
9105: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
9106: l_split_weight number;
9107: l_split_volume number;
9108: l_split_return_status varchar2(30);
9109: l_shipped_quantity NUMBER := NULL;

Line 9989: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

9985: */
9986: l_entity_ids WSH_UTIL_CORE.id_tab_type;
9987: reprice_required_err EXCEPTION;
9988: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
9989: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
9990: l_split_weight number;
9991: l_split_volume number;
9992: l_split_return_status varchar2(30);
9993: l_shipped_quantity NUMBER := NULL;

Line 10321: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

10317: l_qty_return_status varchar2(30);
10318: new_det_wt_vol_failed exception;
10319: old_det_wt_vol_failed exception;
10320: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
10321: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
10322: l_split_weight number;
10323: l_split_volume number;
10324: l_split_return_status varchar2(30);
10325: l_shipped_quantity NUMBER := NULL;

Line 11062: x_new_delivery_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

11058: *****************************************************/
11059:
11060: PROCEDURE Split_Serial_Numbers_INT(
11061: x_old_detail_rec IN OUT NOCOPY SplitDetailRecType,
11062: x_new_delivery_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
11063: p_old_shipped_quantity IN NUMBER,
11064: p_new_shipped_quantity IN NUMBER,
11065: x_return_status OUT NOCOPY VARCHAR2) IS
11066:

Line 11627: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

11623: l_return_status VARCHAR2(1):=NULL ;
11624: l_line_id NUMBER := NULL;
11625:
11626: -- K LPN CONV. rv
11627: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
11628: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
11629: l_msg_count NUMBER;
11630: l_msg_data VARCHAR2(32767);
11631: e_return_excp EXCEPTION;

Line 11628: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

11624: l_line_id NUMBER := NULL;
11625:
11626: -- K LPN CONV. rv
11627: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
11628: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
11629: l_msg_count NUMBER;
11630: l_msg_data VARCHAR2(32767);
11631: e_return_excp EXCEPTION;
11632: