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 2281: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

2277: l_num_warnings number := 0;
2278:
2279: -- K LPN CONV. rv
2280: l_wms_org VARCHAR2(10) := 'N';
2281: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
2282: l_sync_tmp_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
2283: l_operation_type VARCHAR2(100);
2284: -- K LPN CONV. rv
2285:

Line 2282: l_sync_tmp_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

2278:
2279: -- K LPN CONV. rv
2280: l_wms_org VARCHAR2(10) := 'N';
2281: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
2282: l_sync_tmp_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
2283: l_operation_type VARCHAR2(100);
2284: -- K LPN CONV. rv
2285:
2286: -- OTM R12 : update delivery

Line 2303: l_delivery_detail_ids WSH_GLBL_VAR_STRCT_GRP.NUM_TBL_TYPE;

2299: l_delivery_was_empty BOOLEAN;
2300: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2301: l_gross_weight1 WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
2302: l_gross_weight2 WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
2303: l_delivery_detail_ids WSH_GLBL_VAR_STRCT_GRP.NUM_TBL_TYPE;
2304: l_assign_update BOOLEAN;
2305:
2306: -- End of OTM R12 : assign delivery detail
2307:

Line 3712: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

3708:
3709: l_num_warnings number := 0;
3710: -- K LPN CONV. rv
3711: l_wms_org VARCHAR2(10) := 'N';
3712: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
3713: l_mdc_detail_tab wsh_util_core.id_tab_type;
3714:
3715: cursor l_parent_cnt_csr (p_cnt_inst_id IN NUMBER) is
3716: select organization_id,

Line 4237: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

4233:
4234: -- K LPN CONV. rv
4235: l_detail_wms_org VARCHAR2(10) := 'N';
4236: l_line_dir VARCHAR2(10);
4237: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
4238: l_num_warnings NUMBER := 0;
4239: -- K LPN CONV. rv
4240:
4241: -- OTM R12 : update delivery

Line 4258: l_delivery_detail_ids WSH_GLBL_VAR_STRCT_GRP.NUM_TBL_TYPE;

4254: l_delivery_was_empty BOOLEAN;
4255: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
4256: l_gross_weight1 WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE;
4257: l_gross_weight2 WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE;
4258: l_delivery_detail_ids WSH_GLBL_VAR_STRCT_GRP.NUM_TBL_TYPE;
4259: l_assign_update BOOLEAN;
4260: -- End of OTM R12 : assign delivery detail
4261: --
4262: l_client_id NUMBER; -- LSP PROJECT

Line 5440: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

5436: l_out_container NUMBER := 0 ;
5437: --
5438: -- K LPN CONV. rv
5439: l_wms_org VARCHAR2(10) := 'N';
5440: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
5441: l_sync_tmp_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
5442: l_num_warnings NUMBER := 0;
5443: l_operation_type VARCHAR2(100);
5444: -- K LPN CONV. rv

Line 5441: l_sync_tmp_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

5437: --
5438: -- K LPN CONV. rv
5439: l_wms_org VARCHAR2(10) := 'N';
5440: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
5441: l_sync_tmp_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
5442: l_num_warnings NUMBER := 0;
5443: l_operation_type VARCHAR2(100);
5444: -- K LPN CONV. rv
5445: l_mdc_detail_tab WSH_UTIL_CORE.Id_Tab_Type;

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

6702: PROCEDURE Unassign_Detail_from_Delivery(
6703: p_detail_id IN NUMBER
6704: , x_return_status OUT NOCOPY VARCHAR2
6705: , p_validate_flag IN VARCHAR2,
6706: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH
6707: )
6708:
6709: IS
6710: detail_not_assigned exception;

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

6788:
6789: l_dd_id WSH_UTIL_CORE.Id_Tab_Type;
6790: l_del_id_tbl WSH_UTIL_CORE.Id_Tab_Type; -- LPN CONV. rv
6791: l_parent_dd_id_tbl WSH_UTIL_CORE.Id_Tab_Type; -- LPN CONV. rv
6792: l_line_dir_tbl WSH_GLBL_VAR_STRCT_GRP.v3_Tbl_Type; -- LPN CONV. rv
6793: l_cnt_flag_tbl WSH_GLBL_VAR_STRCT_GRP.v3_Tbl_Type; -- LPN CONV. rv
6794: l_det_org_id_tbl WSH_UTIL_CORE.Id_Tab_Type; -- LPN CONV. rv
6795: i BINARY_INTEGER := 0;
6796: j BINARY_INTEGER :=0;

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

6789: l_dd_id WSH_UTIL_CORE.Id_Tab_Type;
6790: l_del_id_tbl WSH_UTIL_CORE.Id_Tab_Type; -- LPN CONV. rv
6791: l_parent_dd_id_tbl WSH_UTIL_CORE.Id_Tab_Type; -- LPN CONV. rv
6792: l_line_dir_tbl WSH_GLBL_VAR_STRCT_GRP.v3_Tbl_Type; -- LPN CONV. rv
6793: l_cnt_flag_tbl WSH_GLBL_VAR_STRCT_GRP.v3_Tbl_Type; -- LPN CONV. rv
6794: l_det_org_id_tbl WSH_UTIL_CORE.Id_Tab_Type; -- LPN CONV. rv
6795: i BINARY_INTEGER := 0;
6796: j BINARY_INTEGER :=0;
6797:

Line 6826: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

6822:
6823: -- K LPN CONV. rv
6824: l_wms_org VARCHAR2(10) := 'N';
6825: l_loop_wms_org VARCHAR2(10) := 'N';
6826: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
6827: l_line_dir VARCHAR2(10);
6828: l_num_warnings NUMBER := 0;
6829:
6830: cursor l_parent_cnt_csr (p_cnt_inst_id IN NUMBER) is

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

7747: l_debug_on BOOLEAN;
7748: --
7749: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PACKAGE_NAME || '.' || 'UNASSIGN_DETAIL_FROM_DELIVERY';
7750: --
7751: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type; -- J-IB-NPARIKH
7752: BEGIN
7753:
7754: /*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*/
7755:

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

7807: , P_FROM_delivery IN VARCHAR2
7808: , P_FROM_container IN VARCHAR2
7809: , x_return_status out NOCOPY varchar2
7810: , p_validate_flag IN VARCHAR2
7811: , p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH
7812: )
7813: IS
7814:
7815: CURSOR c_multi_assign_rec(c_delivery_detail_id number)

Line 7864: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

7860: l_org_id NUMBER;
7861: l_wf_rs VARCHAR2(1);
7862:
7863: -- K LPN CONV. rv
7864: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
7865: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
7866: l_msg_count NUMBER;
7867: l_msg_data VARCHAR2(32767);
7868: -- K LPN CONV. rv

Line 7865: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

7861: l_wf_rs VARCHAR2(1);
7862:
7863: -- K LPN CONV. rv
7864: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
7865: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
7866: l_msg_count NUMBER;
7867: l_msg_data VARCHAR2(32767);
7868: -- K LPN CONV. rv
7869:

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

8451: l_debug_on BOOLEAN;
8452: --
8453: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PACKAGE_NAME || '.' || 'UNASSIGN_MULTIPLE_DETAILS';
8454: --
8455: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type; -- J-IB-NPARIKH
8456: BEGIN
8457: --
8458: --
8459: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 8866: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

8862: */
8863: l_entity_ids WSH_UTIL_CORE.id_tab_type;
8864: reprice_required_err EXCEPTION;
8865: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
8866: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
8867: l_split_weight number;
8868: l_split_volume number;
8869: l_split_return_status varchar2(30);
8870: l_shipped_quantity NUMBER := NULL;

Line 8890: l_new_serial_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

8886: l_serial_tab WSH_DELIVERY_DETAILS_ACTIONS.serial_tab;
8887: i NUMBER;
8888: j NUMBER;
8889: l_serial_orig_rec WSH_DELIVERY_DETAILS_ACTIONS.SplitDetailRecType;
8890: l_new_serial_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
8891: l_transaction_id_tab WSH_UTIL_CORE.id_tab_type;
8892: l_serial_number WSH_DELIVERY_DETAILS.serial_number%TYPE;
8893: TYPE l_sr_no_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
8894: l_serial_number_tab l_sr_no_tab;

Line 9269: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

9265: l_qty_return_status varchar2(30);
9266: new_det_wt_vol_failed exception;
9267: old_det_wt_vol_failed exception;
9268: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
9269: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
9270: l_split_weight number;
9271: l_split_volume number;
9272: l_split_return_status varchar2(30);
9273: l_shipped_quantity NUMBER := NULL;

Line 10171: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

10167: */
10168: l_entity_ids WSH_UTIL_CORE.id_tab_type;
10169: reprice_required_err EXCEPTION;
10170: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
10171: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
10172: l_split_weight number;
10173: l_split_volume number;
10174: l_split_return_status varchar2(30);
10175: l_shipped_quantity NUMBER := NULL;

Line 10594: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

10590: l_qty_return_status varchar2(30);
10591: new_det_wt_vol_failed exception;
10592: old_det_wt_vol_failed exception;
10593: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
10594: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
10595: l_split_weight number;
10596: l_split_volume number;
10597: l_split_return_status varchar2(30);
10598: l_shipped_quantity NUMBER := NULL;

Line 11493: x_new_delivery_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

11489: *****************************************************/
11490:
11491: PROCEDURE Split_Serial_Numbers_INT(
11492: x_old_detail_rec IN OUT NOCOPY SplitDetailRecType,
11493: x_new_delivery_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
11494: p_old_shipped_quantity IN NUMBER,
11495: p_new_shipped_quantity IN NUMBER,
11496: x_return_status OUT NOCOPY VARCHAR2) IS
11497:

Line 12092: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

12088: l_return_status VARCHAR2(1):=NULL ;
12089: l_line_id NUMBER := NULL;
12090:
12091: -- K LPN CONV. rv
12092: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
12093: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
12094: l_msg_count NUMBER;
12095: l_msg_data VARCHAR2(32767);
12096: e_return_excp EXCEPTION;

Line 12093: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

12089: l_line_id NUMBER := NULL;
12090:
12091: -- K LPN CONV. rv
12092: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
12093: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
12094: l_msg_count NUMBER;
12095: l_msg_data VARCHAR2(32767);
12096: e_return_excp EXCEPTION;
12097: