DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_DELIVERY_DETAILS_INV

Line 2823: x_line_inv_flag_rec OUT NOCOPY wsh_delivery_details_inv.inv_control_flag_rec,

2819: --
2820: -----------------------------------------------------------------------------
2821: PROCEDURE Check_Detail_for_Confirm ( p_detail_id IN NUMBER,
2822: p_check_credit_init_flag IN BOOLEAN, -- 2343058
2823: x_line_inv_flag_rec OUT NOCOPY wsh_delivery_details_inv.inv_control_flag_rec,
2824: x_return_status OUT NOCOPY VARCHAR2) IS
2825:
2826: CURSOR detail_info IS
2827: SELECT delivery_detail_id,

Line 2888: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;

2884:
2885: l_lpn_id NUMBER;
2886: -- 11728970: Cursor to Get the LPN -id
2887:
2888: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2889: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2890: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;
2891: l_details_flag BOOLEAN;
2892:

Line 2889: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;

2885: l_lpn_id NUMBER;
2886: -- 11728970: Cursor to Get the LPN -id
2887:
2888: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2889: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2890: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;
2891: l_details_flag BOOLEAN;
2892:
2893: l_source_line_id NUMBER;

Line 2890: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;

2886: -- 11728970: Cursor to Get the LPN -id
2887:
2888: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2889: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2890: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;
2891: l_details_flag BOOLEAN;
2892:
2893: l_source_line_id NUMBER;
2894: l_source_header_id NUMBER;

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

3006: AND l_line_inv_rec.inventory_item_id IS NOT NULL THEN
3007:
3008:
3009: IF l_debug_on THEN
3010: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights',WSH_DEBUG_SV.C_PROC_LEVEL);
3011: END IF;
3012:
3013: WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights
3014: (p_line_inv_rec => l_line_inv_rec,

Line 3013: WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights

3009: IF l_debug_on THEN
3010: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights',WSH_DEBUG_SV.C_PROC_LEVEL);
3011: END IF;
3012:
3013: WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights
3014: (p_line_inv_rec => l_line_inv_rec,
3015: x_return_status => x_return_status);
3016:
3017: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

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

3036: --
3037: -- Debug Statements
3038: --
3039: IF l_debug_on THEN
3040: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
3041: END IF;
3042: --
3043: wsh_delivery_details_inv.fetch_inv_controls(
3044: p_delivery_detail_id => l_line_inv_rec.delivery_detail_id,

Line 3043: wsh_delivery_details_inv.fetch_inv_controls(

3039: IF l_debug_on THEN
3040: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
3041: END IF;
3042: --
3043: wsh_delivery_details_inv.fetch_inv_controls(
3044: p_delivery_detail_id => l_line_inv_rec.delivery_detail_id,
3045: p_inventory_item_id => l_line_inv_rec.inventory_item_id,
3046: p_organization_id => l_line_inv_rec.organization_id,
3047: p_subinventory => l_line_inv_rec.subinventory,

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

3065: --
3066: -- Debug Statements
3067: --
3068: IF l_debug_on THEN
3069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DETAILS_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3070: END IF;
3071: --
3072: wsh_delivery_details_inv.Details_Required (
3073: p_line_inv_rec => l_line_inv_rec,

Line 3072: wsh_delivery_details_inv.Details_Required (

3068: IF l_debug_on THEN
3069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DETAILS_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3070: END IF;
3071: --
3072: wsh_delivery_details_inv.Details_Required (
3073: p_line_inv_rec => l_line_inv_rec,
3074: p_set_default => FALSE,
3075: x_line_inv_rec => g_line_inv_rec,
3076: x_details_required => l_details_flag,

Line 3128: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(

3124: select DECODE(wsh_util_validate.Check_Wms_Org(l_line_inv_rec.organization_id),'Y','TRUE','FALSE')
3125: into l_wms_enabled
3126: from dual;
3127:
3128: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(
3129: p_source_line_id => l_line_inv_rec.source_line_id,
3130: p_source_code => l_line_inv_rec.source_code,
3131: x_transaction_type_id => L_TRANSACTION_TYPE_ID ,
3132: x_return_status => x_return_status);

Line 3222: WSH_DELIVERY_DETAILS_INV.Validate_Serial( p_serial_number => l_line_inv_rec.serial_number,

3218: return;
3219: END IF;
3220:
3221: ELSE
3222: WSH_DELIVERY_DETAILS_INV.Validate_Serial( p_serial_number => l_line_inv_rec.serial_number,
3223: p_lot_number => l_line_inv_rec.lot_number,
3224: p_organization_id => l_line_inv_rec.organization_id ,
3225: p_inventory_item_id => l_line_inv_rec.inventory_item_id ,
3226: p_subinventory => l_line_inv_rec.subinventory ,