DBA Data[Home] [Help]

APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_SHIPPING_PARAMS_PVT

Line 10: TYPE PARAM_INFO_TAB_TYPE IS TABLE OF WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ INDEX BY BINARY_INTEGER;

6: TYPE g_char_hash_string IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
7: TYPE g_char_tbl_type IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
8: G_DELIVERY_ID g_number_tbl_type;
9: G_LIMIT NUMBER := 5000;--Added for Vendor Merge of Shipping RTV Transactions
10: TYPE PARAM_INFO_TAB_TYPE IS TABLE OF WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ INDEX BY BINARY_INTEGER;
11: G_PARAM_INFO_TAB PARAM_INFO_TAB_TYPE;
12: --
13: TYPE g_LocChangeRec IS RECORD
14: (

Line 3226: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;

3222: p_weight_uom IN g_char_tbl_type,
3223: p_volume_uom IN g_char_tbl_type,
3224: x_return_status OUT NOCOPY VARCHAR2 )
3225: IS
3226: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
3227: l_return_status VARCHAR2(10);
3228:
3229: Weight_Volume_Exp EXCEPTION;
3230: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Adjust_Parent_WV';

Line 3274: WSH_SHIPPING_PARAMS_PVT.Get(

3270: IF ( NOT G_PARAM_INFO_TAB.EXISTS(p_organization_id(wvCnt)) )
3271: THEN
3272: l_return_status := NULL;
3273:
3274: WSH_SHIPPING_PARAMS_PVT.Get(
3275: p_organization_id => p_organization_id(wvCnt),
3276: x_param_info => l_param_info,
3277: x_return_status => l_return_status);
3278:

Line 3282: WSH_DEBUG_SV.logmsg(l_module_name,'API WSH_SHIPPING_PARAMS_PVT.Get returned error');

3278:
3279: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3280: --
3281: IF ( l_debug_on ) THEN
3282: WSH_DEBUG_SV.logmsg(l_module_name,'API WSH_SHIPPING_PARAMS_PVT.Get returned error');
3283: END IF;
3284: --
3285: RAISE Weight_Volume_Exp;
3286: END IF;