DBA Data[Home] [Help]

APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_DELIVERY_AUTOCREATE

Line 2952: l_grp_attr_tab_type WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;

2948: IS
2949: SELECT to_number(Column1) delivery_id, Column3
2950: FROM Wsh_Tmp;
2951:
2952: l_grp_attr_tab_type WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
2953: l_action_code VARCHAR2(30);
2954: l_return_status VARCHAR2(1);
2955: l_hash_count NUMBER;
2956: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Get_Delivery_Hash';

Line 2988: WSH_DELIVERY_AUTOCREATE.Create_Hash (

2984: -- {
2985: l_grp_attr_tab_type(1).Entity_Type := 'DELIVERY_DETAIL';
2986: l_grp_attr_tab_type(1).Entity_Id := i.Column3;
2987:
2988: WSH_DELIVERY_AUTOCREATE.Create_Hash (
2989: p_grouping_attributes => l_grp_attr_tab_type,
2990: p_group_by_header => 'N',
2991: p_action_code => l_action_code,
2992: x_return_status => l_return_status );

Line 3572: l_grp_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;

3568: l_shipping_control g_char_tbl_type;
3569: l_party_id g_number_tbl_type;
3570: l_client_id g_number_tbl_type;
3571:
3572: l_grp_attr_tab WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
3573: l_dummyIdTab g_number_tbl_type;
3574: l_rec_exists varchar2(1);
3575: l_no_rtv_del_details NUMBER := 0;
3576: l_exception_id NUMBER;

Line 4398: WSH_DELIVERY_AUTOCREATE.Create_Hash(

4394: l_grp_attr_tab(i).client_id := l_client_id(i);
4395: l_grp_attr_tab(i).consignee_flag := 'V';
4396:
4397: END LOOP;
4398: WSH_DELIVERY_AUTOCREATE.Create_Hash(
4399: p_grouping_attributes => l_grp_attr_tab,
4400: p_group_by_header => 'N',
4401: p_action_code => NULL,
4402: x_return_status => x_return_status);

Line 4408: WSH_DEBUG_SV.log(l_module_name,'Error returned from API WSH_DELIVERY_AUTOCREATE.Create_Hash');

4404: WSH_UTIL_CORE.G_RET_STS_WARNING) )
4405: THEN
4406: --
4407: IF ( l_debug_on ) THEN
4408: WSH_DEBUG_SV.log(l_module_name,'Error returned from API WSH_DELIVERY_AUTOCREATE.Create_Hash');
4409: RAISE FND_API.G_EXC_ERROR;
4410: END IF;
4411: --
4412: END IF;