DBA Data[Home] [Help]

APPS.FTE_MLS_WRAPPER dependencies on WSH_DELIVERY_AUTOCREATE

Line 5602: l_id_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- DetailIdTab

5598: x_msg_count OUT NOCOPY NUMBER,
5599: x_msg_data OUT NOCOPY VARCHAR2
5600: )IS
5601:
5602: l_id_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- DetailIdTab
5603: l_id_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- DetailIdRec
5604: l_id_entity_tab WSH_UTIL_CORE.ID_TAB_TYPE; -- MatchingIdTab
5605: l_action_rec WSH_DELIVERY_AUTOCREATE.ACTION_REC_TYPE; -- ActionOutRec
5606: l_out_rec WSH_DELIVERY_AUTOCREATE.OUT_REC_TYPE; -- OutRecType

Line 5603: l_id_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- DetailIdRec

5599: x_msg_data OUT NOCOPY VARCHAR2
5600: )IS
5601:
5602: l_id_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- DetailIdTab
5603: l_id_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- DetailIdRec
5604: l_id_entity_tab WSH_UTIL_CORE.ID_TAB_TYPE; -- MatchingIdTab
5605: l_action_rec WSH_DELIVERY_AUTOCREATE.ACTION_REC_TYPE; -- ActionOutRec
5606: l_out_rec WSH_DELIVERY_AUTOCREATE.OUT_REC_TYPE; -- OutRecType
5607: l_targ_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- TargetIdRec

Line 5605: l_action_rec WSH_DELIVERY_AUTOCREATE.ACTION_REC_TYPE; -- ActionOutRec

5601:
5602: l_id_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- DetailIdTab
5603: l_id_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- DetailIdRec
5604: l_id_entity_tab WSH_UTIL_CORE.ID_TAB_TYPE; -- MatchingIdTab
5605: l_action_rec WSH_DELIVERY_AUTOCREATE.ACTION_REC_TYPE; -- ActionOutRec
5606: l_out_rec WSH_DELIVERY_AUTOCREATE.OUT_REC_TYPE; -- OutRecType
5607: l_targ_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- TargetIdRec
5608: l_grp_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- GroupIdTab
5609: --

Line 5606: l_out_rec WSH_DELIVERY_AUTOCREATE.OUT_REC_TYPE; -- OutRecType

5602: l_id_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- DetailIdTab
5603: l_id_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- DetailIdRec
5604: l_id_entity_tab WSH_UTIL_CORE.ID_TAB_TYPE; -- MatchingIdTab
5605: l_action_rec WSH_DELIVERY_AUTOCREATE.ACTION_REC_TYPE; -- ActionOutRec
5606: l_out_rec WSH_DELIVERY_AUTOCREATE.OUT_REC_TYPE; -- OutRecType
5607: l_targ_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- TargetIdRec
5608: l_grp_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- GroupIdTab
5609: --
5610: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line 5607: l_targ_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- TargetIdRec

5603: l_id_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- DetailIdRec
5604: l_id_entity_tab WSH_UTIL_CORE.ID_TAB_TYPE; -- MatchingIdTab
5605: l_action_rec WSH_DELIVERY_AUTOCREATE.ACTION_REC_TYPE; -- ActionOutRec
5606: l_out_rec WSH_DELIVERY_AUTOCREATE.OUT_REC_TYPE; -- OutRecType
5607: l_targ_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- TargetIdRec
5608: l_grp_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- GroupIdTab
5609: --
5610: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
5611: --

Line 5608: l_grp_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- GroupIdTab

5604: l_id_entity_tab WSH_UTIL_CORE.ID_TAB_TYPE; -- MatchingIdTab
5605: l_action_rec WSH_DELIVERY_AUTOCREATE.ACTION_REC_TYPE; -- ActionOutRec
5606: l_out_rec WSH_DELIVERY_AUTOCREATE.OUT_REC_TYPE; -- OutRecType
5607: l_targ_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- TargetIdRec
5608: l_grp_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- GroupIdTab
5609: --
5610: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
5611: --
5612: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'GROUP_DETAIL_SEARCH_DLVY';

Line 5656: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(

5652: -- Create targetRecType
5653: l_targ_attr_rec.entity_type := 'DELIVERY';
5654:
5655: -- Call WSH's grouping API
5656: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(
5657: p_attr_tab => l_id_attr_tab,
5658: p_action_rec => l_action_rec,
5659: p_target_rec => l_targ_attr_rec,
5660: p_group_tab => l_grp_attr_tab,

Line 5670: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;

5666: -- Check output params
5667: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
5668: AND l_grp_attr_tab.count>1)
5669: THEN
5670: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;
5671: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5672: FND_MESSAGE.SET_NAME('FTE','FTE_LINES_NOT_GROUPABLE');
5673: FND_MSG_PUB.ADD;
5674: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 5677: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;

5673: FND_MSG_PUB.ADD;
5674: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
5675: AND l_grp_attr_tab.count>1)
5676: THEN
5677: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;
5678: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5679: FND_MESSAGE.SET_NAME('FTE','FTE_LINES_NOT_GROUPABLE');
5680: FND_MSG_PUB.ADD;
5681: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

Line 5684: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;

5680: FND_MSG_PUB.ADD;
5681: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5682: OR x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
5683: THEN
5684: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;
5685: END IF;
5686:
5687: FND_MSG_PUB.Count_And_Get
5688: (