DBA Data[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_DELIVERY_DETAILS_PKG

Line 753: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

749: l_primary_uom VARCHAR2(3);
750: -- J: W/V Changes
751:
752: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
753: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
754:
755: l_row_id VARCHAR2(30);
756: l_del_assg_id NUMBER;
757:

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

1103: -- within the Loop
1104:
1105: IF l_debug_on THEN
1106: WSH_DEBUG_SV.logmsg(l_module_name, 'CREATING DELIVERY DETAIL'||p_num_of_containers );
1107: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_DETAILS_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
1108: END IF;
1109: --
1110:
1111:

Line 1112: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk

1108: END IF;
1109: --
1110:
1111:
1112: WSH_DELIVERY_DETAILS_PKG.create_delivery_details_bulk
1113: ( p_delivery_details_info => l_container_rec,
1114: p_num_of_rec => p_num_of_containers,
1115: p_container_info_rec => l_container_info_rec,
1116: x_return_status => x_return_status,

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

1159: l_del_assg_rec.parent_delivery_detail_id := null;
1160:
1161: --
1162: IF l_debug_on THEN
1163: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIV_ASSIGNMENT_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
1164: --WSH_DEBUG_SV.logmsg(l_module_name,'NUMBER OF CONTS'||p_num_of_containers);
1165: WSH_DEBUG_SV.logmsg(l_module_name,'NUMBER OF RECORDS IN WDD '||l_cont_dummy_tab.count);
1166: END IF;
1167: --

Line 1169: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk

1165: WSH_DEBUG_SV.logmsg(l_module_name,'NUMBER OF RECORDS IN WDD '||l_cont_dummy_tab.count);
1166: END IF;
1167: --
1168:
1169: WSH_DELIVERY_DETAILS_PKG.create_deliv_assignment_bulk
1170: ( p_delivery_assignments_info => l_del_assg_rec,
1171: p_num_of_rec => p_num_of_containers,
1172: p_dd_id_tab => l_cont_dummy_tab,
1173: x_da_id_tab => l_assignment_dummy_tab,

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

1460:
1461: --
1462: IF l_debug_on THEN
1463: WSH_DEBUG_SV.log(l_module_name,'Delivery Status',l_del_sts);
1464: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1465: END IF;
1466: --
1467: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details (
1468: p_rowid => null,

Line 1467: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details (

1463: WSH_DEBUG_SV.log(l_module_name,'Delivery Status',l_del_sts);
1464: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
1465: END IF;
1466: --
1467: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details (
1468: p_rowid => null,
1469: p_delivery_detail_id => p_container_id,
1470: x_return_status => x_return_status);
1471:

Line 13461: l_del_asg_info_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;

13457:
13458: l_assign_flag VARCHAR2(1);
13459: l_del_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
13460: l_parent_del_info_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
13461: l_del_asg_info_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;
13462: l_child_details_tab wsh_util_core.id_tab_type;
13463: l_dummy_asg_tab wsh_util_core.id_tab_type;
13464: l_wv_delivery_tab wsh_util_core.id_tab_type;
13465: l_child_delivery_id NUMBER;

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

13778:
13779: -- Lock the delivery details and assignments.
13780:
13781: BEGIN
13782: wsh_delivery_details_pkg.lock_detail_no_compare(p_delivery_detail_id => p_parent_container_id);
13783: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_parent_container_id);
13784: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_child_container_id);
13785: EXCEPTION
13786: WHEN OTHERS THEN

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

13779: -- Lock the delivery details and assignments.
13780:
13781: BEGIN
13782: wsh_delivery_details_pkg.lock_detail_no_compare(p_delivery_detail_id => p_parent_container_id);
13783: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_parent_container_id);
13784: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_child_container_id);
13785: EXCEPTION
13786: WHEN OTHERS THEN
13787: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

13780:
13781: BEGIN
13782: wsh_delivery_details_pkg.lock_detail_no_compare(p_delivery_detail_id => p_parent_container_id);
13783: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_parent_container_id);
13784: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => p_child_container_id);
13785: EXCEPTION
13786: WHEN OTHERS THEN
13787: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
13788: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');

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

13867: -- lock the children.
13868:
13869: BEGIN
13870: FOR i in 1..l_child_details_tab.count LOOP
13871: wsh_delivery_details_pkg.lock_wda_no_compare(p_delivery_detail_id => l_child_details_tab(i));
13872: END LOOP;
13873:
13874: EXCEPTION
13875: WHEN OTHERS THEN

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

13919: l_del_asg_info_rec.parent_delivery_id := l_new_parent_delivery_id;
13920: l_del_asg_info_rec.type := 'C';
13921:
13922: IF l_debug_on THEN
13923: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_Delivery_Details_PKG.Create_Deliv_Assignment_bulk',WSH_DEBUG_SV.C_PROC_LEVEL);
13924: END IF;
13925: WSH_Delivery_Details_PKG.Create_Deliv_Assignment_bulk(
13926: p_delivery_assignments_info => l_del_asg_info_rec,
13927: p_num_of_rec => l_child_details_tab.count,

Line 13925: WSH_Delivery_Details_PKG.Create_Deliv_Assignment_bulk(

13921:
13922: IF l_debug_on THEN
13923: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_Delivery_Details_PKG.Create_Deliv_Assignment_bulk',WSH_DEBUG_SV.C_PROC_LEVEL);
13924: END IF;
13925: WSH_Delivery_Details_PKG.Create_Deliv_Assignment_bulk(
13926: p_delivery_assignments_info => l_del_asg_info_rec,
13927: p_num_of_rec => l_child_details_tab.count,
13928: p_dd_id_tab => l_child_details_tab,
13929: x_da_id_tab => l_dummy_asg_tab,

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

14353: -- Lock the delivery assignments.
14354:
14355: BEGIN
14356:
14357: WSH_DELIVERY_DETAILS_PKG.lock_wda_no_compare(p_delivery_detail_id => p_delivery_details_tab(i));
14358:
14359: EXCEPTION
14360: WHEN OTHERS THEN
14361: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;