DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_DELIVERY_DETAILS_PKG

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

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

Line 2837: wsh_delivery_details_pkg.Lock_Delivery_Details(

2833: END IF;
2834: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
2835: AND p_action_prms.action_code = 'DELETE'
2836: ) THEN --BUG 4354579
2837: wsh_delivery_details_pkg.Lock_Delivery_Details(
2838: p_rec_attr_tab => p_rec_attr_tab,
2839: p_caller => p_action_prms.caller,
2840: p_valid_index_tab => l_valid_index_tab,
2841: x_valid_ids_tab => l_valid_ids_tab,

Line 4954: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

4950: l_lpn_table WMS_Data_Type_Definitions_pub.LPNTableType;
4951: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;
4952: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4953: l_cont_dummy_tab WSH_UTIL_CORE.id_tab_type;
4954: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
4955: l_assignment_dummy_tab WSH_UTIL_CORE.id_tab_type;
4956: l_wms_enabled BOOLEAN;
4957: l_return_status VARCHAR2(2);
4958: l_number_of_warnings NUMBER := 0;

Line 5435: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk

5431: p_return_status => l_return_status,
5432: x_num_warnings => l_number_of_warnings,
5433: x_num_errors => l_number_of_errors
5434: );
5435: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk
5436: ( p_delivery_details_info => l_container_rec,
5437: p_num_of_rec => p_detail_IN_rec.quantity,
5438: p_container_info_rec => l_container_info_rec,
5439: x_return_status => l_return_status,

Line 5467: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk

5463: x_num_warnings => l_number_of_warnings,
5464: x_num_errors => l_number_of_errors
5465: );
5466:
5467: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk
5468: ( p_delivery_assignments_info => l_del_assg_rec,
5469: p_num_of_rec => p_detail_IN_rec.quantity,
5470: p_dd_id_tab => l_cont_dummy_tab,
5471: x_da_id_tab => l_assignment_dummy_tab,

Line 5547: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk

5543: p_return_status => l_return_status,
5544: x_num_warnings => l_number_of_warnings,
5545: x_num_errors => l_number_of_errors
5546: );
5547: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk
5548: ( p_delivery_details_info => l_container_rec,
5549: p_num_of_rec => 1,
5550: p_container_info_rec => l_container_info_rec,
5551: x_return_status => l_return_status,

Line 5579: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk

5575: x_num_warnings => l_number_of_warnings,
5576: x_num_errors => l_number_of_errors
5577: );
5578:
5579: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk
5580: ( p_delivery_assignments_info => l_del_assg_rec,
5581: p_num_of_rec => 1,
5582: p_dd_id_tab => l_cont_dummy_tab,
5583: x_da_id_tab => l_assignment_dummy_tab,

Line 5741: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

5737: l_new_detail_id NUMBER;
5738: l_dummy_rowid VARCHAR2(32767);
5739: l_dummy_assgn_rowid VARCHAR2(32767);
5740: l_delivery_assignment_id NUMBER;
5741: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
5742: l_item_type VARCHAR2(30);
5743:
5744: l_validation_level NUMBER;
5745:

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

5889: END IF; --}
5890:
5891:
5892: IF l_debug_on THEN
5893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
5894: END IF;
5895: --
5896: WSH_DELIVERY_DETAILS_PKG.create_delivery_details(
5897: p_delivery_details_info => p_detail_info_tab(l_index),

Line 5896: WSH_DELIVERY_DETAILS_PKG.create_delivery_details(

5892: IF l_debug_on THEN
5893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
5894: END IF;
5895: --
5896: WSH_DELIVERY_DETAILS_PKG.create_delivery_details(
5897: p_delivery_details_info => p_detail_info_tab(l_index),
5898: x_rowid => l_dummy_rowid,
5899: x_delivery_detail_id => l_new_detail_id,
5900: x_return_status => l_return_status);

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

5923: l_delivery_assignments_info.parent_delivery_detail_id := NULL;
5924:
5925:
5926: IF l_debug_on THEN
5927: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);
5928: END IF;
5929: --
5930: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments(
5931: p_delivery_assignments_info => l_delivery_assignments_info,

Line 5930: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments(

5926: IF l_debug_on THEN
5927: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);
5928: END IF;
5929: --
5930: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments(
5931: p_delivery_assignments_info => l_delivery_assignments_info,
5932: x_rowid => l_dummy_assgn_rowid,
5933: x_delivery_assignment_id => l_delivery_assignment_id,
5934: x_return_status => l_return_status);

Line 6159: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

6155: l_new_detail_id NUMBER;
6156: l_dummy_rowid NUMBER;
6157: l_dummy_assgn_rowid NUMBER;
6158: l_delivery_assignment_id NUMBER;
6159: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
6160: l_required_field VARCHAR2(32767);
6161:
6162: l_validation_level NUMBER;
6163: l_org_id NUMBER;

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

6959: END IF;
6960:
6961:
6962: IF l_debug_on THEN
6963: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
6964: END IF;
6965: --
6966: wsh_delivery_details_pkg.Update_Delivery_Details(
6967: p_rowid => p_detail_info_tab(l_index).rowid,

Line 6966: wsh_delivery_details_pkg.Update_Delivery_Details(

6962: IF l_debug_on THEN
6963: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.UPDATE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
6964: END IF;
6965: --
6966: wsh_delivery_details_pkg.Update_Delivery_Details(
6967: p_rowid => p_detail_info_tab(l_index).rowid,
6968: p_delivery_details_info => p_detail_info_tab(l_index),
6969: x_return_status => l_return_status);
6970: