APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_FTE_COMP_CLASSES

Line 520: FROM WSH_FTE_COMP_CLASSES

516: IS
517:
518: CURSOR c_get_comp_class_info(c_comp_class_id IN NUMBER) IS
519: SELECT *
520: FROM WSH_FTE_COMP_CLASSES
521: WHERE COMPATIBILITY_CLASS_ID = c_comp_class_id;
522:
523: l_comp_class_rec WSH_FTE_COMP_CLASSES%ROWTYPE;
524: i NUMBER := 0;

Line 523: l_comp_class_rec WSH_FTE_COMP_CLASSES%ROWTYPE;

519: SELECT *
520: FROM WSH_FTE_COMP_CLASSES
521: WHERE COMPATIBILITY_CLASS_ID = c_comp_class_id;
522:
523: l_comp_class_rec WSH_FTE_COMP_CLASSES%ROWTYPE;
524: i NUMBER := 0;
525: l_result VARCHAR2(30) := NULL;
526: l_hash_value NUMBER := 0;
527:

Line 603: FROM WSH_FTE_COMP_CLASSES

599: IS
600:
601: CURSOR c_get_comp_class_info(c_comp_class_code IN VARCHAR2) IS
602: SELECT *
603: FROM WSH_FTE_COMP_CLASSES
604: WHERE COMPATIBILITY_CLASS_CODE = c_comp_class_code;
605:
606: l_hash_value NUMBER:=0;
607: l_comp_class_rec WSH_FTE_COMP_CLASSES%ROWTYPE;

Line 607: l_comp_class_rec WSH_FTE_COMP_CLASSES%ROWTYPE;

603: FROM WSH_FTE_COMP_CLASSES
604: WHERE COMPATIBILITY_CLASS_CODE = c_comp_class_code;
605:
606: l_hash_value NUMBER:=0;
607: l_comp_class_rec WSH_FTE_COMP_CLASSES%ROWTYPE;
608:
609: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
610: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'get_compclass_id';
611:

Line 1721: p_lookup_type => 'WSH_FTE_COMP_CLASSES'

1717: END IF;
1718:
1719: l_class_meaning := WSH_XC_UTIL.Get_Lookup_Meaning(
1720: p_lookup_code => l_class_type,
1721: p_lookup_type => 'WSH_FTE_COMP_CLASSES'
1722: );
1723:
1724: IF l_class_meaning IS NULL THEN
1725: raise FND_API.G_EXC_UNEXPECTED_ERROR;