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

Line 20: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

16: -- if not provided as a parameter.
17: --
18:
19: PROCEDURE Create_Delivery_Details(
20: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
21: x_rowid OUT NOCOPY VARCHAR2,
22: x_delivery_detail_id OUT NOCOPY NUMBER,
23: x_return_status OUT NOCOPY VARCHAR2
24: ) IS

Line 52: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;

48: AND released_status = Decode(v_wms_flag,'Y','X',released_status));
49: l_cont_cnt NUMBER;
50: -- end bug 3022644
51: -- lpn conv
52: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;
53: --
54: l_debug_on BOOLEAN;
55: --
56: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_DELIVERY_DETAILS';

Line 164: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

160: -- keeping old parameters as they were
161: --
162:
163: PROCEDURE Create_Delivery_Details_Bulk(
164: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
165: p_num_of_rec IN NUMBER,
166: -- lpn conv
167: p_container_info_rec IN WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype,
168: x_return_status OUT NOCOPY VARCHAR2,

Line 167: p_container_info_rec IN WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype,

163: PROCEDURE Create_Delivery_Details_Bulk(
164: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
165: p_num_of_rec IN NUMBER,
166: -- lpn conv
167: p_container_info_rec IN WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_dd_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type
170: ) IS
171:

Line 205: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

201: l_temp_id NUMBER;
202: l_cont_dummy_tab WSH_UTIL_CORE.id_tab_type;
203:
204: -- 2530743
205: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
206: l_dff_attribute WSH_FLEXFIELD_UTILS.FlexfieldAttributeTabType;
207: l_dff_context VARCHAR2(150);
208: l_dff_update_flag VARCHAR2(1);
209: l_dff_ret_status VARCHAR2(1);

Line 961: p_delivery_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

957: -- line will be split 2 times with qty of 5
958: -- so create 2 new records
959:
960: PROCEDURE create_dd_from_old_bulk(
961: p_delivery_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
962: p_delivery_detail_id IN NUMBER,
963: p_num_of_rec IN NUMBER,
964: x_dd_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
965: x_return_status OUT NOCOPY VARCHAR2

Line 979: l_dd_rec WSH_GLBL_VAR_STRCT_GRP.DELIVERY_DETAILS_REC_TYPE;

975: l_row_count NUMBER;
976: l_temp_id NUMBER;
977:
978: l_dd_id_tab WSH_UTIL_CORE.id_tab_type;
979: l_dd_rec WSH_GLBL_VAR_STRCT_GRP.DELIVERY_DETAILS_REC_TYPE;
980: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
981:
982: others exception;
983:

Line 1634: p_delivery_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

1630: END Create_Deliv_Assignment_bulk;
1631: /************* End of BULK OPERATION *****************/
1632:
1633: PROCEDURE create_new_detail_from_old(
1634: p_delivery_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
1635: p_delivery_detail_id IN NUMBER,
1636: x_row_id OUT NOCOPY VARCHAR2,
1637: x_delivery_detail_id OUT NOCOPY NUMBER,
1638: x_return_status OUT NOCOPY VARCHAR2

Line 2108: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type)

2104: --
2105:
2106: PROCEDURE Lock_Delivery_Details(
2107: p_rowid IN VARCHAR2,
2108: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type)
2109: IS
2110:
2111: CURSOR C_LOCK_DELIVERY_DETAIL IS
2112: SELECT *

Line 3151: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

3147: --
3148:
3149: PROCEDURE Update_Delivery_Details(
3150: p_rowid IN VARCHAR2 := NULL,
3151: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
3152: x_return_status OUT NOCOPY VARCHAR2
3153: ) IS
3154:
3155: -- J: W/V Changes

Line 3260: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;

3256: l_wms_installed VARCHAR2(10);
3257: l_org_type VARCHAR2(3) := 'INV';
3258: l_call_out BOOLEAN := FALSE;
3259: l_CALL_BACK_REQUIRED VARCHAR2(2) := 'N';
3260: l_sync_tmp_rec wsh_glbl_var_strct_grp.sync_tmp_rec_type;
3261: l_cont_fill_pc NUMBER;
3262:
3263: CURSOR Get_Cont_Item_Info (v_cont_item_id NUMBER, v_org_id NUMBER) IS
3264: SELECT Description,

Line 4686: p_rec_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,

4682: END Lock_Delivery_Assignments;
4683:
4684:
4685: procedure Lock_Delivery_Details(
4686: p_rec_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
4687: p_caller IN VARCHAR2,
4688: p_valid_index_tab IN wsh_util_core.id_tab_type,
4689: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,
4690: x_return_status OUT NOCOPY VARCHAR2

Line 4939: x_delivery_detail_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,

4935: -- and copy it to a record.
4936:
4937: Procedure Table_To_Record(
4938: p_delivery_detail_id IN NUMBER,
4939: x_delivery_detail_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
4940: x_return_status OUT NOCOPY VARCHAR2) IS
4941:
4942: CURSOR c_tbl_rec (p_delivery_detail_id IN NUMBER) IS
4943: SELECT delivery_detail_id