DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_DELIVERY_DETAILS_INV

Line 2754: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

2750: l_dd_org_ids wsh_util_core.id_tab_type; -- list of details org ids
2751: l_item_ids wsh_util_core.id_tab_type; -- list of details inventory_item_ids
2752:
2753: -- for non-transactable items
2754: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
2755: dft_subinv VARCHAR2(30);
2756: loc_restricted_flag VARCHAR2(1);
2757: dft_loc_id NUMBER;
2758: org_loc_ctl NUMBER;

Line 2763: g_line_inv_rec WSH_DELIVERY_DETAILS_INV.line_inv_info;

2759: sub_loc_ctl NUMBER;
2760: item_loc_ctl NUMBER;
2761: loc_ctl_code NUMBER;
2762:
2763: g_line_inv_rec WSH_DELIVERY_DETAILS_INV.line_inv_info;
2764: l_details_flag BOOLEAN;
2765:
2766: l_ship_from_location NUMBER;
2767: l_ship_to_location NUMBER;

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

4775: --
4776: -- Debug Statements
4777: --
4778: IF l_debug_on THEN
4779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
4780: END IF;
4781: --
4782: WSH_DELIVERY_DETAILS_INV.Default_Subinventory ( l_shp_dd_orgs ( dd_count ),
4783: l_shp_dd_items( dd_count ),

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

4778: IF l_debug_on THEN
4779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
4780: END IF;
4781: --
4782: WSH_DELIVERY_DETAILS_INV.Default_Subinventory ( l_shp_dd_orgs ( dd_count ),
4783: l_shp_dd_items( dd_count ),
4784: dft_subinv,
4785: x_return_status);
4786: IF ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN

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

4796: --
4797: -- Debug Statements
4798: --
4799: IF l_debug_on THEN
4800: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_ORG_LOC',WSH_DEBUG_SV.C_PROC_LEVEL);
4801: END IF;
4802: --
4803: org_loc_ctl := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_shp_dd_orgs ( dd_count ));
4804:

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

4799: IF l_debug_on THEN
4800: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_ORG_LOC',WSH_DEBUG_SV.C_PROC_LEVEL);
4801: END IF;
4802: --
4803: org_loc_ctl := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_shp_dd_orgs ( dd_count ));
4804:
4805: --
4806: -- Debug Statements
4807: --

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

4805: --
4806: -- Debug Statements
4807: --
4808: IF l_debug_on THEN
4809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.SUB_LOC_CTL',WSH_DEBUG_SV.C_PROC_LEVEL);
4810: END IF;
4811: --
4812: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (
4813: nvl(l_shp_dd_subs ( dd_count ),dft_subinv),

Line 4812: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (

4808: IF l_debug_on THEN
4809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.SUB_LOC_CTL',WSH_DEBUG_SV.C_PROC_LEVEL);
4810: END IF;
4811: --
4812: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (
4813: nvl(l_shp_dd_subs ( dd_count ),dft_subinv),
4814: l_shp_dd_orgs ( dd_count ));
4815:
4816: item_loc_ctl := l_inv_controls_rec.location_control_code;

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

4817: --
4818: -- Debug Statements
4819: --
4820: IF l_debug_on THEN
4821: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.LOCATOR_CTL_CODE',WSH_DEBUG_SV.C_PROC_LEVEL);
4822: END IF;
4823: --
4824: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(
4825: l_shp_dd_orgs ( dd_count ),

Line 4824: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(

4820: IF l_debug_on THEN
4821: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.LOCATOR_CTL_CODE',WSH_DEBUG_SV.C_PROC_LEVEL);
4822: END IF;
4823: --
4824: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(
4825: l_shp_dd_orgs ( dd_count ),
4826: l_inv_controls_rec.restrict_loc,
4827: org_loc_ctl,
4828: sub_loc_ctl,

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

4838: --
4839: -- Debug Statements
4840: --
4841: IF l_debug_on THEN
4842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_LOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
4843: END IF;
4844: --
4845: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (
4846: l_shp_dd_orgs ( dd_count ),

Line 4845: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (

4841: IF l_debug_on THEN
4842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_LOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
4843: END IF;
4844: --
4845: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (
4846: l_shp_dd_orgs ( dd_count ),
4847: l_shp_dd_items ( dd_count ),
4848: NVL(l_shp_dd_subs ( dd_count ), dft_subinv),
4849: loc_restricted_flag);