DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_DELIVERY_DETAILS_PKG

Line 2838: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

2834:
2835: -- we need to send only the valid records to lock procedure
2836: -- Build the table using the valid index output from Is_Action_Enabled
2837: IF l_debug_on THEN
2838: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2839: END IF;
2840: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
2841: AND p_action_prms.action_code = 'DELETE'
2842: ) THEN --BUG 4354579

Line 2843: wsh_delivery_details_pkg.Lock_Delivery_Details(

2839: END IF;
2840: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
2841: AND p_action_prms.action_code = 'DELETE'
2842: ) THEN --BUG 4354579
2843: wsh_delivery_details_pkg.Lock_Delivery_Details(
2844: p_rec_attr_tab => p_rec_attr_tab,
2845: p_caller => p_action_prms.caller,
2846: p_valid_index_tab => l_valid_index_tab,
2847: x_valid_ids_tab => l_valid_ids_tab,

Line 4964: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

4960: l_lpn_table WMS_Data_Type_Definitions_pub.LPNTableType;
4961: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;
4962: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4963: l_cont_dummy_tab WSH_UTIL_CORE.id_tab_type;
4964: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
4965: l_assignment_dummy_tab WSH_UTIL_CORE.id_tab_type;
4966: l_wms_enabled BOOLEAN;
4967: l_return_status VARCHAR2(2);
4968: l_number_of_warnings NUMBER := 0;

Line 5445: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk

5441: p_return_status => l_return_status,
5442: x_num_warnings => l_number_of_warnings,
5443: x_num_errors => l_number_of_errors
5444: );
5445: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk
5446: ( p_delivery_details_info => l_container_rec,
5447: p_num_of_rec => p_detail_IN_rec.quantity,
5448: p_container_info_rec => l_container_info_rec,
5449: x_return_status => l_return_status,

Line 5477: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk

5473: x_num_warnings => l_number_of_warnings,
5474: x_num_errors => l_number_of_errors
5475: );
5476:
5477: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk
5478: ( p_delivery_assignments_info => l_del_assg_rec,
5479: p_num_of_rec => p_detail_IN_rec.quantity,
5480: p_dd_id_tab => l_cont_dummy_tab,
5481: x_da_id_tab => l_assignment_dummy_tab,

Line 5557: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk

5553: p_return_status => l_return_status,
5554: x_num_warnings => l_number_of_warnings,
5555: x_num_errors => l_number_of_errors
5556: );
5557: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk
5558: ( p_delivery_details_info => l_container_rec,
5559: p_num_of_rec => 1,
5560: p_container_info_rec => l_container_info_rec,
5561: x_return_status => l_return_status,

Line 5589: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk

5585: x_num_warnings => l_number_of_warnings,
5586: x_num_errors => l_number_of_errors
5587: );
5588:
5589: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk
5590: ( p_delivery_assignments_info => l_del_assg_rec,
5591: p_num_of_rec => 1,
5592: p_dd_id_tab => l_cont_dummy_tab,
5593: x_da_id_tab => l_assignment_dummy_tab,

Line 5751: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

5747: l_new_detail_id NUMBER;
5748: l_dummy_rowid VARCHAR2(32767);
5749: l_dummy_assgn_rowid VARCHAR2(32767);
5750: l_delivery_assignment_id NUMBER;
5751: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
5752: l_item_type VARCHAR2(30);
5753:
5754: l_validation_level NUMBER;
5755:

Line 5903: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

5899: END IF; --}
5900:
5901:
5902: IF l_debug_on THEN
5903: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
5904: END IF;
5905: --
5906: WSH_DELIVERY_DETAILS_PKG.create_delivery_details(
5907: p_delivery_details_info => p_detail_info_tab(l_index),

Line 5906: WSH_DELIVERY_DETAILS_PKG.create_delivery_details(

5902: IF l_debug_on THEN
5903: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
5904: END IF;
5905: --
5906: WSH_DELIVERY_DETAILS_PKG.create_delivery_details(
5907: p_delivery_details_info => p_detail_info_tab(l_index),
5908: x_rowid => l_dummy_rowid,
5909: x_delivery_detail_id => l_new_detail_id,
5910: x_return_status => l_return_status);

Line 5937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);

5933: l_delivery_assignments_info.parent_delivery_detail_id := NULL;
5934:
5935:
5936: IF l_debug_on THEN
5937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);
5938: END IF;
5939: --
5940: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments(
5941: p_delivery_assignments_info => l_delivery_assignments_info,

Line 5940: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments(

5936: IF l_debug_on THEN
5937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);
5938: END IF;
5939: --
5940: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments(
5941: p_delivery_assignments_info => l_delivery_assignments_info,
5942: x_rowid => l_dummy_assgn_rowid,
5943: x_delivery_assignment_id => l_delivery_assignment_id,
5944: x_return_status => l_return_status);

Line 6169: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

6165: l_new_detail_id NUMBER;
6166: l_dummy_rowid NUMBER;
6167: l_dummy_assgn_rowid NUMBER;
6168: l_delivery_assignment_id NUMBER;
6169: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
6170: l_required_field VARCHAR2(32767);
6171:
6172: l_validation_level NUMBER;
6173: l_org_id NUMBER;

Line 7050: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

7046: END IF;
7047:
7048:
7049: IF l_debug_on THEN
7050: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
7051: END IF;
7052: --
7053: wsh_delivery_details_pkg.Update_Delivery_Details(
7054: p_rowid => p_detail_info_tab(l_index).rowid,

Line 7053: wsh_delivery_details_pkg.Update_Delivery_Details(

7049: IF l_debug_on THEN
7050: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
7051: END IF;
7052: --
7053: wsh_delivery_details_pkg.Update_Delivery_Details(
7054: p_rowid => p_detail_info_tab(l_index).rowid,
7055: p_delivery_details_info => p_detail_info_tab(l_index),
7056: x_return_status => l_return_status);
7057: