DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_DELIVERY_DETAILS_INV

Line 2792: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

2788: l_dd_org_ids wsh_util_core.id_tab_type; -- list of details org ids
2789: l_item_ids wsh_util_core.id_tab_type; -- list of details inventory_item_ids
2790:
2791: -- for non-transactable items
2792: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
2793: dft_subinv VARCHAR2(30);
2794: loc_restricted_flag VARCHAR2(1);
2795: dft_loc_id NUMBER;
2796: org_loc_ctl NUMBER;

Line 2801: g_line_inv_rec WSH_DELIVERY_DETAILS_INV.line_inv_info;

2797: sub_loc_ctl NUMBER;
2798: item_loc_ctl NUMBER;
2799: loc_ctl_code NUMBER;
2800:
2801: g_line_inv_rec WSH_DELIVERY_DETAILS_INV.line_inv_info;
2802: l_details_flag BOOLEAN;
2803:
2804: l_ship_from_location NUMBER;
2805: l_ship_to_location NUMBER;

Line 4863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);

4859: --
4860: -- Debug Statements
4861: --
4862: IF l_debug_on THEN
4863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
4864: END IF;
4865: --
4866: WSH_DELIVERY_DETAILS_INV.Default_Subinventory ( l_shp_dd_orgs ( dd_count ),
4867: l_shp_dd_items( dd_count ),

Line 4866: WSH_DELIVERY_DETAILS_INV.Default_Subinventory ( l_shp_dd_orgs ( dd_count ),

4862: IF l_debug_on THEN
4863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
4864: END IF;
4865: --
4866: WSH_DELIVERY_DETAILS_INV.Default_Subinventory ( l_shp_dd_orgs ( dd_count ),
4867: l_shp_dd_items( dd_count ),
4868: dft_subinv,
4869: x_return_status);
4870: IF ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN

Line 4884: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_ORG_LOC',WSH_DEBUG_SV.C_PROC_LEVEL);

4880: --
4881: -- Debug Statements
4882: --
4883: IF l_debug_on THEN
4884: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_ORG_LOC',WSH_DEBUG_SV.C_PROC_LEVEL);
4885: END IF;
4886: --
4887: org_loc_ctl := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_shp_dd_orgs ( dd_count ));
4888:

Line 4887: org_loc_ctl := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_shp_dd_orgs ( dd_count ));

4883: IF l_debug_on THEN
4884: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_ORG_LOC',WSH_DEBUG_SV.C_PROC_LEVEL);
4885: END IF;
4886: --
4887: org_loc_ctl := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_shp_dd_orgs ( dd_count ));
4888:
4889: --
4890: -- Debug Statements
4891: --

Line 4893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.SUB_LOC_CTL',WSH_DEBUG_SV.C_PROC_LEVEL);

4889: --
4890: -- Debug Statements
4891: --
4892: IF l_debug_on THEN
4893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.SUB_LOC_CTL',WSH_DEBUG_SV.C_PROC_LEVEL);
4894: END IF;
4895: --
4896: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (
4897: nvl(l_shp_dd_subs ( dd_count ),dft_subinv),

Line 4896: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (

4892: IF l_debug_on THEN
4893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.SUB_LOC_CTL',WSH_DEBUG_SV.C_PROC_LEVEL);
4894: END IF;
4895: --
4896: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (
4897: nvl(l_shp_dd_subs ( dd_count ),dft_subinv),
4898: l_shp_dd_orgs ( dd_count ));
4899:
4900: item_loc_ctl := l_inv_controls_rec.location_control_code;

Line 4905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.LOCATOR_CTL_CODE',WSH_DEBUG_SV.C_PROC_LEVEL);

4901: --
4902: -- Debug Statements
4903: --
4904: IF l_debug_on THEN
4905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.LOCATOR_CTL_CODE',WSH_DEBUG_SV.C_PROC_LEVEL);
4906: END IF;
4907: --
4908: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(
4909: l_shp_dd_orgs ( dd_count ),

Line 4908: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(

4904: IF l_debug_on THEN
4905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.LOCATOR_CTL_CODE',WSH_DEBUG_SV.C_PROC_LEVEL);
4906: END IF;
4907: --
4908: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(
4909: l_shp_dd_orgs ( dd_count ),
4910: l_inv_controls_rec.restrict_loc,
4911: org_loc_ctl,
4912: sub_loc_ctl,

Line 4926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_LOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);

4922: --
4923: -- Debug Statements
4924: --
4925: IF l_debug_on THEN
4926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_LOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
4927: END IF;
4928: --
4929: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (
4930: l_shp_dd_orgs ( dd_count ),

Line 4929: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (

4925: IF l_debug_on THEN
4926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_LOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
4927: END IF;
4928: --
4929: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (
4930: l_shp_dd_orgs ( dd_count ),
4931: l_shp_dd_items ( dd_count ),
4932: NVL(l_shp_dd_subs ( dd_count ), dft_subinv),
4933: loc_restricted_flag);