DBA Data[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_DELIVERY_DETAILS_PKG

Line 726: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

722: l_primary_uom VARCHAR2(3);
723: -- J: W/V Changes
724:
725: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
726: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
727:
728: l_row_id VARCHAR2(30);
729: l_del_assg_id NUMBER;
730:

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

1076: -- within the Loop
1077:
1078: IF l_debug_on THEN
1079: WSH_DEBUG_SV.logmsg(l_module_name, 'CREATING DELIVERY DETAIL'||p_num_of_containers );
1080: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
1081: END IF;
1082: --
1083:
1084:

Line 1085: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk

1081: END IF;
1082: --
1083:
1084:
1085: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk
1086: ( p_delivery_details_info => l_container_rec,
1087: p_num_of_rec => p_num_of_containers,
1088: p_container_info_rec => l_container_info_rec,
1089: x_return_status => x_return_status,

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

1132: l_del_assg_rec.parent_delivery_detail_id := null;
1133:
1134: --
1135: IF l_debug_on THEN
1136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIV_ASSIGNMENT_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
1137: --WSH_DEBUG_SV.logmsg(l_module_name,'NUMBER OF CONTS'||p_num_of_containers);
1138: WSH_DEBUG_SV.logmsg(l_module_name,'NUMBER OF RECORDS IN WDD '||l_cont_dummy_tab.count);
1139: END IF;
1140: --

Line 1142: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk

1138: WSH_DEBUG_SV.logmsg(l_module_name,'NUMBER OF RECORDS IN WDD '||l_cont_dummy_tab.count);
1139: END IF;
1140: --
1141:
1142: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk
1143: ( p_delivery_assignments_info => l_del_assg_rec,
1144: p_num_of_rec => p_num_of_containers,
1145: p_dd_id_tab => l_cont_dummy_tab,
1146: x_da_id_tab => l_assignment_dummy_tab,

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

1433:
1434: --
1435: IF l_debug_on THEN
1436: WSH_DEBUG_SV.log(l_module_name,'Delivery Status',l_del_sts);
1437: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1438: END IF;
1439: --
1440: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details (
1441: p_rowid => null,

Line 1440: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details (

1436: WSH_DEBUG_SV.log(l_module_name,'Delivery Status',l_del_sts);
1437: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1438: END IF;
1439: --
1440: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details (
1441: p_rowid => null,
1442: p_delivery_detail_id => p_container_id,
1443: x_return_status => x_return_status);
1444:

Line 13311: l_del_asg_info_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;

13307:
13308: l_assign_flag VARCHAR2(1);
13309: l_del_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
13310: l_parent_del_info_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
13311: l_del_asg_info_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;
13312: l_child_details_tab wsh_util_core.id_tab_type;
13313: l_dummy_asg_tab wsh_util_core.id_tab_type;
13314: l_wv_delivery_tab wsh_util_core.id_tab_type;
13315: l_child_delivery_id NUMBER;

Line 13632: wsh_delivery_details_pkg.lock_detail_no_compare(p_delivery_detail_id => p_parent_container_id);

13628:
13629: -- Lock the delivery details and assignments.
13630:
13631: BEGIN
13632: wsh_delivery_details_pkg.lock_detail_no_compare(p_delivery_detail_id => p_parent_container_id);
13633: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_parent_container_id);
13634: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_child_container_id);
13635: EXCEPTION
13636: WHEN OTHERS THEN

Line 13633: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_parent_container_id);

13629: -- Lock the delivery details and assignments.
13630:
13631: BEGIN
13632: wsh_delivery_details_pkg.lock_detail_no_compare(p_delivery_detail_id => p_parent_container_id);
13633: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_parent_container_id);
13634: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_child_container_id);
13635: EXCEPTION
13636: WHEN OTHERS THEN
13637: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 13634: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_child_container_id);

13630:
13631: BEGIN
13632: wsh_delivery_details_pkg.lock_detail_no_compare(p_delivery_detail_id => p_parent_container_id);
13633: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_parent_container_id);
13634: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_child_container_id);
13635: EXCEPTION
13636: WHEN OTHERS THEN
13637: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
13638: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');

Line 13721: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => l_child_details_tab(i));

13717: -- lock the children.
13718:
13719: BEGIN
13720: FOR i in 1..l_child_details_tab.count LOOP
13721: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => l_child_details_tab(i));
13722: END LOOP;
13723:
13724: EXCEPTION
13725: WHEN OTHERS THEN

Line 13773: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_Delivery_Details_PKG.Create_Deliv_Assignment_bulk',WSH_DEBUG_SV.C_PROC_LEVEL);

13769: l_del_asg_info_rec.parent_delivery_id := l_new_parent_delivery_id;
13770: l_del_asg_info_rec.type := 'C';
13771:
13772: IF l_debug_on THEN
13773: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_Delivery_Details_PKG.Create_Deliv_Assignment_bulk',WSH_DEBUG_SV.C_PROC_LEVEL);
13774: END IF;
13775: WSH_Delivery_Details_PKG.Create_Deliv_Assignment_bulk(
13776: p_delivery_assignments_info => l_del_asg_info_rec,
13777: p_num_of_rec => l_child_details_tab.count,

Line 13775: WSH_Delivery_Details_PKG.Create_Deliv_Assignment_bulk(

13771:
13772: IF l_debug_on THEN
13773: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_Delivery_Details_PKG.Create_Deliv_Assignment_bulk',WSH_DEBUG_SV.C_PROC_LEVEL);
13774: END IF;
13775: WSH_Delivery_Details_PKG.Create_Deliv_Assignment_bulk(
13776: p_delivery_assignments_info => l_del_asg_info_rec,
13777: p_num_of_rec => l_child_details_tab.count,
13778: p_dd_id_tab => l_child_details_tab,
13779: x_da_id_tab => l_dummy_asg_tab,

Line 14207: WSH_DELIVERY_DETAILS_PKG.lock_wda_no_compare(p_delivery_detail_id => p_delivery_details_tab(i));

14203: -- Lock the delivery assignments.
14204:
14205: BEGIN
14206:
14207: WSH_DELIVERY_DETAILS_PKG.lock_wda_no_compare(p_delivery_detail_id => p_delivery_details_tab(i));
14208:
14209: EXCEPTION
14210: WHEN OTHERS THEN
14211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;